public function render()
{
$date = new \Ilch\Date();
$statisticMapper = new \Modules\Statistic\Mappers\Statistic();
$this->getView()->set('visitsToday', $statisticMapper->getVisitsCount($date->format('Y-m-d', true)));
$this->getView()->set('visitsOnline', $statisticMapper->getVisitsCountOnline());
$date->modify('-1 day');
$this->getView()->set('visitsYesterday', $statisticMapper->getVisitsCount($date->format('Y-m-d', true)));
$this->getView()->set('visitsMonth', $statisticMapper->getVisitsMonthCount());
$this->getView()->set('visitsYear', $statisticMapper->getVisitsYearCount());
$this->getView()->set('visitsRegistUser', $statisticMapper->getRegistUserCount());
$this->getView()->set('visitsTotal', $statisticMapper->getVisitsCount());
}
/**
* @return integer
*/
public function getVisitsCountOnline()
{
$date = new \Ilch\Date();
$date->modify('-5 minutes');
$sql = 'SELECT COUNT(*)
FROM `[prefix]_visits_online`
WHERE `date_last_activity` > "' . $date->format("Y-m-d H:i:s", true) . '"';
$visits = $this->db()->queryCell($sql);
return $visits;
}
