/** * 获取平均预算和点击 * * @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; }