dashboard.php

Aller à la documentation de ce fichier.

<?php
$Module = $Params['Module'];
$tpl    = eZTemplate::factory();
$http   = eZHTTPTool::instance();
$user   = eZUser::currentUser();
$ini    = eZINI::instance();

// On récupère le noeud principal de l'utilisateur
$userNode = eZUser::currentUser()->contentObject()->mainNode();

// On récupère les données de connection à la base de données
$ini    = eZINI::instance();
$user   = $ini->variable('DatabaseSettings', 'User');
$passwd = $ini->variable('DatabaseSettings', 'Password');
$host   = $ini->variable('DatabaseSettings', 'Server');
$dbname = $ini->variable('DatabaseSettings', 'Database');

// On récupère les node ids de tous les articles publiés sur la page du pédiatre
// $nodes_id_array = array_map(function($node){return $node->attribute('node_id');}, $userNode->children());

// On crée une connection à la base de données
$db =  ezcDbFactory::create( "mysql://{$user}:{$passwd}@{$host}/{$dbname}" );

// On crée un tableau contenant tous les nodes ids
$nodes   = array_map(function($child){return $child->attribute('node_id');}, $userNode->children());
$nodes[] = $userNode->attribute('node_id');

$q = $db->createSelectQuery();

$stmt = $q->selectDistinct('session_id')
            ->from('ipediatre_visits')
            ->where($q->expr->in('node_id', $nodes))
          ->prepare();

$stmt->execute();
$rows = $stmt->fetchAll();

$families = count($rows);

$q = $db->createSelectQuery();

$stmt = $q->select($q->expr->count('*'))
            ->from('ipediatre_visits')
            ->where($q->expr->in('node_id', $nodes))
          ->prepare();

$stmt->execute();
$rows = $stmt->fetch();

$views = $rows[0];

$q = $db->createSelectQuery();

$stmt = $q->select($q->expr->min('date'))
            ->from('ipediatre_visits')
            ->where($q->expr->in('node_id', $nodes))
          ->prepare();

$stmt->execute();
$rows = $stmt->fetch();

$from = $rows[0];

$q = $db->createSelectQuery();

$stmt = $q->select($q->expr->max('date'))
            ->from('ipediatre_visits')
            ->where($q->expr->in('node_id', $nodes))
          ->prepare();

$stmt->execute();
$rows = $stmt->fetch();

$to = $rows[0];

$tpl->setVariable('from', $from);
$tpl->setVariable('to', $to);
$tpl->setVariable('families', $families);
$tpl->setVariable('views', $views);


$Result['content'] = $tpl->fetch('design:ip/dashboard.tpl');