function loadSlowestPageViews() { global $interface; global $user; global $analytics; $pageView = new Analytics_PageView(); $session = $analytics->getSessionFilters(); if ($session != null) { $pageView->joinAdd($session); } $pageView->selectAdd('AVG(loadTime) as loadTime'); $pageView->selectAdd('COUNT(analytics_page_view.id) as numViews'); $pageView->whereAdd('loadTime > 0'); $pageView->groupBy('module, action'); $pageView->orderBy('loadTime DESC'); $pageView->limit(0, 25); $pageView->addDateFilters(); $slowPages = array(); $pageView->find(); while ($pageView->fetch()) { $slowPages[] = array('module' => $pageView->module, 'action' => $pageView->action, 'method' => $pageView->method, 'loadTime' => $pageView->loadTime, 'numViews' => $pageView->numViews); } $interface->assign('slowPages', $slowPages); }
function getPageViewsByModuleAction($forGraph) { //load searches by type $pageViews = new Analytics_PageView(); $pageViews->selectAdd('count(analytics_page_view.id) as numViews'); $pageViews->selectAdd('module'); $pageViews->selectAdd('action'); $session = $this->getSessionFilters(); if ($session != null) { $pageViews->joinAdd($session); } $pageViews->addDateFilters(); $pageViews->groupBy('module'); $pageViews->groupBy('action'); $pageViews->orderBy('numViews DESC'); if ($forGraph) { $pageViews->limit(0, 10); } $pageViews->find(); $pageViewsByModuleRaw = array(); while ($pageViews->fetch()) { if ($forGraph) { $pageViewsByModuleRaw[] = array($pageViews->module . ' - ' . $pageViews->action, (int) $pageViews->numViews); } else { $pageViewsByModuleRaw[] = array($pageViews->module, $pageViews->action, (int) $pageViews->numViews); } } return $pageViewsByModuleRaw; }