stats-ages.php

Aller à la documentation de ce fichier.

<?php
// 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 classés par catégorie
foreach ($userNode->children() as $child)
{
  $datamap = $child->object()->dataMap();
  $ages = array_filter(explode(';',$datamap['age_slot2']->content()));

  foreach ($ages as $age) {
    $nodes[$age][] = $child->attribute('node_id');
  }
}

$hash_i18n = array(0 => ezpI18n::tr('ipediatre/ages', '0-3 months'),
                   1 => ezpI18n::tr('ipediatre/ages', '4-6 months'),
                   2 => ezpI18n::tr('ipediatre/ages', '7-9 months'),
                   3 => ezpI18n::tr('ipediatre/ages', '10-12 months'),
                   4 => ezpI18n::tr('ipediatre/ages', '1 year'),
                   5 => ezpI18n::tr('ipediatre/ages', '2-3 years'));

foreach ($hash_i18n as $h) {
  $data[" ".$h] = 0;
}

foreach( $nodes as $k=>$n) {
  $q = $db->createSelectQuery();

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

  $stmt->execute();
  $rows = $stmt->fetch();
  $data[" ".$hash_i18n[$k-1]] = $rows[0];
}

try {
$graph = new ezcGraphPieChart();
$graph->legend->position   = ezcGraph::RIGHT;
$graph->options->label     = '';
$graph->legend->portraitSize = 0.25;

if($Params['type'] != "svg")
{
  $graph->driver = new ezcGraphGdDriver();
  $graph->options->font = 'design/standard/fonts/arial.ttf';
}
class CustomPaletteB extends ezcGraphPalette
{
    protected $dataSetColor = array(
        '#ffaba7',
        '#8ad2ef',
        '#fdab00',
        '#6db900',
        '#fd7dab',
        '#cc429c',
    );

    protected $dataSetSymbol = array(ezcGraph::SQUARE);
    protected $fontName = 'sans-serif';
    protected $fontColor = '#3485cd';
}

$graph->palette = new CustomPaletteB;
$graph->data['Access statistics'] = new ezcGraphArrayDataSet($data);

$graph->renderToOutput(450,200);


} catch(Exception $e) {

  header("Content-Type: image/png");
  $im = @imagecreate(1, 1);
  $background_color = imagecolorallocate($im, 0, 0, 0);
  imagepng($im);
  imagedestroy($im);
}


eZExecution::cleanExit();