/**
* 获取平均预算和点击
*
* @param $communityId
* @param $cityId
* @param $price
* @return array|bool
*/
public static function getBucketAverageClickBudget($communityId, $cityId, $price)
{
$priceIntervalInfo = Model_House_EsfPrice::get_price($cityId, $price);
if (empty($priceIntervalInfo)) {
return false;
}
$validDate = Model_Config_huTablesUploadStatus::getDate(self::STATICCLICKANDBUDGETCONFIGNAME);
if (empty($validDate)) {
$validDate = date("Y-m-d");
}
$validDate = $validDate->calDt;
return Model_Stats_EsfAverageClickBudget::getAverageClickBudget($communityId, $priceIntervalInfo['id'], date("Ymd", strtotime($validDate)));
}
/**
* 获取坑位的平均点击的预算
*
* @param $blockId
* @param $priceId
* @return array
*/
public static function getAverageClickBudget($commId, $priceId, $date)
{
$month = date('m', strtotime($date));
try {
$averageClickAndBucket = Model_Stats_EsfAverageClickBudget::data_access($month)->filter('communityId', $commId)->filter('priceId', $priceId)->filter('datei', $date)->sort('id')->get_row();
} catch (Exception $e) {
return array();
}
if (is_null($averageClickAndBucket)) {
return array();
}
return $averageClickAndBucket;
}
