示例#1
0
 function launch()
 {
     global $interface;
     global $analytics;
     //Setup filters
     $this->setupFilters();
     $topSearches = $analytics->getTopSearches(true);
     $interface->assign('topSearches', $topSearches);
     $session = $analytics->getSessionFilters();
     $search = new Analytics_Search();
     $search->selectAdd();
     $search->selectAdd("count(analytics_search.id) as numSearches");
     $search->selectAdd("lookfor");
     if ($session != null) {
         $search->joinAdd($session);
     }
     $search->whereAdd("numResults = 0");
     $search->groupBy('lookfor');
     $search->orderBy('numSearches DESC');
     $search->limit(0, 20);
     $search->find();
     $topNoHitSearches = array();
     while ($search->fetch()) {
         if (!is_null($search->lookfor) || strlen(trim($search->lookfor)) > 0) {
             $topNoHitSearches[] = "{$search->lookfor} ({$search->numSearches})";
         } else {
             $topNoHitSearches[] = "<blank> ({$search->numSearches})";
         }
     }
     $interface->assign('topNoHitSearches', $topNoHitSearches);
     $search = new Analytics_Search();
     $search->selectAdd();
     $search->selectAdd("lookfor");
     $search->selectAdd("MAX(searchTime) as lastSearch ");
     if ($session != null) {
         $search->joinAdd($session);
     }
     $search->groupBy('lookfor');
     $search->orderBy('lastSearch DESC');
     $search->limit(0, 20);
     $search->find();
     $latestSearches = array();
     while ($search->fetch()) {
         if (!is_null($search->lookfor) || strlen(trim($search->lookfor)) > 0) {
             $latestSearches[] = "{$search->lookfor} {$search->searchTime}";
         } else {
             $latestSearches[] = "<blank>";
         }
     }
     $interface->assign('latestSearches', $latestSearches);
     $search = new Analytics_Search();
     $search->selectAdd();
     $search->selectAdd("lookfor");
     $search->selectAdd("MAX(searchTime) as lastSearch ");
     if ($session != null) {
         $search->joinAdd($session);
     }
     $search->whereAdd("numResults = 0");
     $search->groupBy('lookfor');
     $search->orderBy('lastSearch DESC');
     $search->limit(0, 20);
     $search->find();
     $latestNoHitSearches = array();
     while ($search->fetch()) {
         if (!is_null($search->lookfor) || strlen(trim($search->lookfor)) > 0) {
             $latestNoHitSearches[] = "{$search->lookfor} {$search->searchTime}";
         } else {
             $latestNoHitSearches[] = "<blank>";
         }
     }
     $interface->assign('latestNoHitSearches', $latestNoHitSearches);
     $interface->setPageTitle('Report - Searches');
     $interface->setTemplate('searches.tpl');
     $interface->display('layout.tpl');
 }
示例#2
0
 function getTopSearches($forGraph)
 {
     $search = new Analytics_Search();
     $search->selectAdd();
     $search->selectAdd("count(analytics_search.id) as numSearches");
     $search->selectAdd("lookfor");
     $session = $this->getSessionFilters();
     if ($session != null) {
         $search->joinAdd($session);
     }
     $search->addDateFilters();
     $search->whereAdd("numResults > 0");
     $search->groupBy('lookfor');
     $search->orderBy('numSearches DESC');
     if ($forGraph) {
         $search->limit(0, 20);
     } else {
         $search->limit(0, 50);
     }
     $search->find();
     $topSearches = array();
     while ($search->fetch()) {
         if (!is_null($search->lookfor) && strlen(trim($search->lookfor)) > 0) {
             $searchTerm = $search->lookfor;
         } else {
             $searchTerm = "&lt;blank&gt;";
         }
         if ($forGraph) {
             $topSearches[] = "{$searchTerm} ({$search->numSearches})";
         } else {
             $topSearches[] = array($searchTerm, $search->numSearches);
         }
     }
     return $topSearches;
 }