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;
}
