public function onConstruct() { $lastThreads = $this->modelsManager->createBuilder()->from(['p' => 'Phosphorum\\Models\\Posts'])->groupBy("p.id")->join('Phosphorum\\Models\\Categories', "r.id = p.categories_id", 'r')->join('Phosphorum\\Models\\Users', "u.id = p.users_id", 'u')->columns(['p.title as title_post', 'p.id as id_post', 'p.slug as slug_post', 'r.name as name_category', 'u.name as name_user'])->where('p.deleted = 0')->orderBy('p.created_at DESC')->limit(3)->getQuery()->execute(); /** @var Simple $lastMember */ $lastMember = Users::find(['order' => 'created_at DESC', 'limit' => 1, 'columns' => 'login']); $login = null; if ($lastMember->valid()) { $login = $lastMember->getFirst()->login; } $this->view->setVars(['app_name' => $this->config->get('site')->name, 'app_version' => VERSION, 'threads' => Posts::count(), 'last_threads' => $lastThreads, 'users' => Users::count(), 'users_latest' => $login, 'actionName' => $this->dispatcher->getActionName(), 'controllerName' => $this->dispatcher->getControllerName()]); }
public function statsAction() { $this->view->threads = Posts::count(); $this->view->replies = Posts::sum(array('column' => 'number_replies')); $this->view->votes = Posts::sum(array('column' => 'votes_up + votes_down')); $this->view->users = Users::count(); $this->view->karma = Users::sum(array('column' => 'karma')); $this->view->notifications = Notifications::count(); $this->view->unotifications = ActivityNotifications::count(); $this->view->views = Posts::sum(array('column' => 'number_views')); $this->view->irc = IrcLog::count(); }
public function onConstruct() { $last_threads = $this->modelsManager->createBuilder()->from(array('p' => 'Phosphorum\\Models\\Posts'))->groupBy("p.id")->join('Phosphorum\\Models\\Categories', "r.id = p.categories_id", 'r')->join('Phosphorum\\Models\\Users', "u.id = p.users_id", 'u')->columns(array('p.title as title_post', 'p.id as id_post', 'p.slug as slug_post', 'r.name as name_category', 'u.name as name_user'))->orderBy('p.created_at DESC')->limit(3)->getQuery()->execute(); $users = Users::find()->getLast(); $this->view->setVars(['threads' => Posts::count(), 'last_threads' => $last_threads, 'users' => Users::count(), 'users_latest' => $users->login, 'actionName' => $this->dispatcher->getActionName()]); }
public function statsAction() { $this->breadcrumbs->add('Help', '/help')->add('Statistics', '/help/stats', ['linked' => false]); $this->tag->setTitle("Statistics"); $this->view->setVars(['threads' => Posts::count(), 'replies' => Posts::sum(['column' => 'number_replies']), 'votes' => Posts::sum(['column' => 'votes_up + votes_down']), 'users' => Users::count(), 'karma' => Users::sum(['column' => 'karma']), 'notifications' => Notifications::count(), 'unotifications' => ActivityNotifications::count(), 'views' => Posts::sum(['column' => 'number_views']), 'irc' => IrcLog::count()]); }