/** * display monthly stats overview * @param sfWebRequest $request */ public function executeMonthly(sfWebRequest $request) { $this->getResponse()->setSlot('js_document_ready', $this->getPartial('oldstats/js_init_visit_history.js')); $this->pMonth = $request->getParameter('month', date('Y-m')); $this->pHost = $request->getParameter('host', null); $this->pSortCat = $request->getParameter('sort', 'host'); $this->pSortOrder = $request->getParameter('order', 'asc'); $this->pPage = $request->getParameter('page', 1); $lQuery = '&month=' . $this->pMonth . '&host=' . $this->pHost . '&sort=' . $this->pSortCat . '&order=' . $this->pSortOrder; $this->pQuery = $lQuery; $this->lHostCount = VisitTable::countHostsForMonth($this->pMonth, $this->pHost); $this->lVisits = VisitTable::getMonthlyStatistics($this->pMonth, $this->pHost, $this->pPage, $this->pSortCat, $this->pSortOrder); }
/** * Executes advertisement action * * @param sfRequest $request A request object */ public function executeAdvertisement(sfWebRequest $request) { $domain = $request->getParameter("domain", "http://spreadly.com/"); $domain = urldecode($domain); $host = parse_url($domain, PHP_URL_HOST); $scheme = parse_url($domain, PHP_URL_SCHEME); $visit = VisitTable::getMonthlyStatistics(date('Y-m', strtotime("-1 month")), $host); $counter = 0; if (is_array($visit) && count($visit) > 0) { if (array_key_exists("pis_total", $visit[0])) { $counter = $visit[0]["pis_total"]; } } $this->domain = $scheme . "://" . $host; $this->counter = $counter; }