public function get_prop_choice_clicks($propId, $cityId)
{
$table = Model_Stats_PropClick::getTableName($cityId);
$sql = "select SUM(bid_cnum) AS bidClicks from {$table} where prop_id = ?";
$value = array($propId);
$da = Model_Stats_PropClick::data_access($cityId);
$result = $da->native_sql($sql, $value);
return $result;
}
public static function get_prop_total_clicks($proids, $city_id)
{
$proids = is_array($proids) ? $proids : array($proids);
$re = Model_Stats_PropClick::data_access($city_id)->load_field(array('fix_cnum', 'bid_cnum'))->filter_by_op('prop_id', 'in', $proids)->get_all();
$return = array();
if ($re) {
foreach ($re as $v) {
$return[$v['prop_id']]['fix_total_cnum'] += intval($v['fix_cnum']);
$return[$v['prop_id']]['bid_total_cnum'] += intval($v['bid_cnum']);
}
}
return $return;
}
/**
* 根据经纪人ID获取房源点击详情
*
* @param int $brokerId
* @param int $cityId
* @param string $date
* @return array
*/
public static function getClickInfoByBrokerId($brokerId, $cityId, $date = '')
{
if (empty($date)) {
$date = date('Ymd');
}
try {
$clicksInfo = Model_Stats_PropClick::data_access($cityId)->filter('datei', $date)->filter('broker_id', $brokerId)->find();
} catch (Exception $e) {
return array();
}
if (is_null($clicksInfo)) {
return array();
}
return $clicksInfo;
}
