private function getPromosStats($qsForm) { if (isset($_POST['QuickStatsForm'])) { $qsForm->attributes = $_POST['QuickStatsForm']; $qsForm->saveDatesToSession(); } else { $qsForm->loadDatesFromSession(); } return ViewsStats::getPromosStats($qsForm->dateFrom, $qsForm->dateTo); }
public function loadDatesFromSession() { $this->dateFrom = ViewsStats::getDateFrom(); $this->dateTo = ViewsStats::getDateTo(); }
private static function addAdvertiserIds() { $listingIds = ViewsStats::getListingsForAdvertiser(); if (count($listingIds) > 0) { $sql = "update p_view_listings set advertiser_id=" . Yii::app()->user->getAdvertiserId() . " WHERE listing_id in (" . implode(',', $listingIds) . ")"; $dbCommand = Yii::app()->db->createCommand($sql); //$results = $dbCommand->execute(); $sql = "update p_view_coupons set advertiser_id=" . Yii::app()->user->getAdvertiserId() . " WHERE coupon_id in (select coupon_id from p_coupons where listing_id in (" . implode(',', $listingIds) . "))"; $dbCommand = Yii::app()->db->createCommand($sql); //$results = $dbCommand->execute(); } return ViewsStats::getCategoriesForListings($listingIds); }
public function getStatsData($couponIds, $dateFrom, $dateTo) { $couponStats = $this->getSummaryStats($couponIds, $dateFrom, $dateTo); $redemptionStats = $this->getRedemptionStats($couponIds, $dateFrom, $dateTo); $results = array(); foreach ($couponIds as $id) { $results[$id]['redeemed'] = $redemptionStats[$id]; $results[$id]['redemption_rate'] = 100 * ViewsStats::safeDivide($redemptionStats[$id], $couponStats[$id]) . ' %'; } return $results; }