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; }