Gc\User\Visitor::getNbVisitors PHP Method

    public function getNbVisitors($sort)
    {
        $sort = $this->checkSort($sort);
        $object = $this;
        $rows = $this->fetchAll($this->select(function (Select $select) use($sort, $object) {
            $select->columns(array('date' => new Expression(sprintf('EXTRACT(%s FROM lu.visit_at)', $sort)), 'nb' => new Expression('COUNT(DISTINCT(log_visitor.id))')));
            $select->join(array('lu' => 'log_url'), 'lu.log_visitor_id = log_visitor.id', array());
            $object->groupByDate($sort, $select);
            $select->order('date ASC');
            $select->group(array('date'));
        }));
        return $this->sortData($sort, $rows);
    }

 /**
  * Display statistics for visitors
  *
  * @return \Zend\View\Model\ViewModel
  */
 public function indexAction()
 {
     $visitorModel = new Visitor();
     $settings = array('back_colour' => '#FFFFFF', 'stroke_colour' => '#C2C2C2', 'back_stroke_width' => 0, 'back_stroke_colour' => '#C2C2C2', 'axis_colour' => '#333', 'axis_overlap' => 1, 'axis_font' => 'Verdana', 'axis_font_size' => 10, 'grid_colour' => '#888888', 'label_colour' => '#555555', 'pad_right' => 10, 'pad_left' => 10, 'project_angle' => 45, 'minimum_grid_spacing' => 40);
     $graph = new SVGGraph(600, 400, $settings);
     $graph->colours = array(array('#855D10', '#855D10'));
     $data = array();
     $array = array('hours' => 'HOUR', 'days' => 'DAY', 'months' => 'MONTH', 'years' => 'YEAR');
     foreach ($array as $type => $sqlValue) {
         $label = '';
         switch ($type) {
             case 'hours':
                 $label = 'This day';
                 break;
             case 'days':
                 $label = 'This month';
                 break;
             case 'months':
                 $label = 'This year';
                 break;
             case 'years':
                 $label = 'All the time';
                 break;
         }
         $data[$type] = array('label' => $label, 'labels' => array('visitors' => 'Visitors', 'pagesviews' => 'Pages views', 'urlsviews' => 'Most urls views', 'referers' => 'Referers'), 'values' => array('visitors' => $visitorModel->getNbVisitors($sqlValue), 'pagesviews' => $visitorModel->getNbPagesViews($sqlValue), 'urlsviews' => $visitorModel->getUrlsViews($sqlValue), 'referers' => $visitorModel->getReferers($sqlValue)));
     }
     return array('graph' => $graph, 'groups' => $data);
 }