public function handle_request_combo()
{
$ajkBrokerId = $this->brokerId;
$cityId = $this->cityId;
//套餐信息
$comboInfoList = Bll_Combo_Broker_BrokerComboInfo::getBrokerComboList($ajkBrokerId);
$currentDate = time();
foreach ($comboInfoList as $comboInfo) {
$startDate = strtotime($comboInfo['startTime']);
$endDate = strtotime($comboInfo['endTime']);
//获取当前使用的套餐
if ($currentDate >= $startDate && $currentDate < $endDate && $comboInfo['rentPropNum'] + $comboInfo['salePropNum'] > 0) {
$currentCombo = $comboInfo;
break;
}
}
$currentComboTotal = $currentCombo['salePropNum'] + $currentCombo['rentPropNum'];
$currentComboName = $currentCombo['name'];
//二手房套餐列表
$comboEsfList = Bll_Broker_Combo_ManageAjk::getComboSpreadHouseList($ajkBrokerId, $cityId);
$comboEsfPropIds = array_keys($comboEsfList);
//租房套餐列表
$comboZuFangList = Bll_Combo_HouseRelation::getHouseRelations($ajkBrokerId, Bll_Combo_HouseRelation::SITE_TYPE_HZ, 1);
$comboZuFangPropIds = array();
foreach ($comboZuFangList as $v) {
$comboZuFangPropIds[] = (int) $v['houseId'];
}
$currentComboUsed = count($comboZuFangPropIds) + count($comboEsfPropIds);
$canSpread = $currentComboUsed >= $currentComboTotal ? 0 : 1;
$propId = $this->_params['propId'];
$comboInfo = Bll_Combo_HouseRelation::getHouseRelation($ajkBrokerId, $cityId, $propId, Bll_Combo_HouseRelation::SITE_TYPE_HZ);
if (!empty($comboInfo) && $comboInfo[0]['state'] > 100 & $comboInfo[0]['state'] < 200) {
//推广中
$status = 2;
$statusMsg = '套餐推广中';
$currentComboInfo = $currentComboName . " （{$currentComboUsed}/{$currentComboTotal}）";
} else {
$comboInfos = Bll_Combo_Broker_BrokerComboInfo::getComboListBySite($ajkBrokerId, Bll_Combo_Broker_BrokerComboInfo::SITE_TYPE_HZ);
if (empty($comboInfos)) {
$status = 0;
$statusMsg = '尚未购买套餐，请购买套餐';
$currentComboInfo = '尚未购买套餐';
} else {
$status = 1;
$statusMsg = '好房源，不推广就浪费了～';
$currentComboInfo = $currentComboName . " （{$currentComboUsed}/{$currentComboTotal}）";
}
}
$startDate = $endDate = date('Ymd');
$todayClicks = Bll_Combo_Broker_BrokerComboInfo::getHouseComboClickEx($propId, $startDate, $endDate, Model_Ppc_NewPackageStatsHouseDay::SITE_TYPE_HZ);
$totalClicks = Bll_House_HzHouse::getComboHouseAccumulateClick($ajkBrokerId, $propId, $cityId);
$todayClick = $todayClicks[$propId][$startDate] ?: 0;
$totalClick = $totalClicks[$propId] ?: 0;
$totalClick += $todayClick;
return array('status' => Const_APIStatus::RETURN_CODE_OK, 'data' => array('todayClicks' => $todayClick, 'totalClicks' => $totalClick, 'status' => $status, 'statusMsg' => $statusMsg, 'canSpread' => $canSpread, 'currentComboInfo' => $currentComboInfo));
}
public function handle_request_combo()
{
$ajkBrokerId = $this->brokerId;
$cityId = $this->cityId;
$siteType = Bll_Combo_Broker_BrokerComboInfo::SITE_TYPE_HZ;
//首先获取套餐关系房源列表 ---- 那房源到主表去除status 已删除的房源 -----在房源主表获取房源基本信息
$comboList = Bll_Combo_HouseRelation::getHouseRelations($ajkBrokerId, $siteType, 1);
$surplus = $hasCombo = 0;
//获取套餐信息-首先判断经纪人有无套餐
$comboInfos = Bll_Combo_Broker_BrokerComboInfo::getComboListBySite($ajkBrokerId, $siteType);
if (count($comboInfos) > 0) {
$index = Bll_Combo_Broker_BrokerComboInfo::getComboIndexBySiteType($siteType);
$currentTime = time();
foreach ($comboInfos as $combo) {
if ($combo[$index] == 0) {
continue;
}
if (strtotime($combo['endTime']) > $currentTime && strtotime($combo['startTime']) < $currentTime) {
$currentCombo = $combo;
}
}
if (!empty($currentCombo)) {
$surplus = $currentCombo['rentPropNum'];
if (Bll_Combo_Broker_BrokerComboInfo::isOpenUp($currentCombo)) {
//商业地产没打通
$surplus = $currentCombo['rentPropNum'] + $currentCombo['salePropNum'];
}
$hasCombo = 1;
}
}
//获取当前已推广套餐数量
if (Bll_Combo_Broker_BrokerComboInfo::isOpenUp($currentCombo)) {
$currentSpreadHouseCount = Bll_Combo_HouseRelation::getHouseCount($ajkBrokerId, $siteType, true);
} else {
$currentSpreadHouseCount = Bll_Combo_HouseRelation::getHouseCountEx($ajkBrokerId, $cityId, $siteType);
}
$oldList = $newList = array();
if (empty($comboInfos)) {
return array('status' => Const_APIStatus::RETURN_CODE_OK, 'data' => array('newList' => $newList, 'oldList' => $oldList, 'surplus' => $surplus - $currentSpreadHouseCount, 'hasCombo' => $hasCombo));
}
$propIds = array();
foreach ($comboList as $row) {
$propIds[] = $row['houseId'];
}
$hzBrokerId = Bll_HzBroker::get_brokerid_by_ajk_brokerid($ajkBrokerId);
$comboPropList = Model_House_HzPropSearch::getPropList($propIds, $hzBrokerId, $this->cityId);
foreach ($comboPropList as $key => $list) {
if (in_array($list['status'], array(Const_HzStatus::VERIFY, Const_HzStatus::REMOVE, Const_HzStatus::EXPIRED))) {
unset($comboPropList[$key]);
}
}
//fix bug45133
if (empty($comboPropList)) {
return array('status' => Const_APIStatus::RETURN_CODE_OK, 'data' => array('newList' => $newList, 'oldList' => $oldList, 'surplus' => $surplus - $currentSpreadHouseCount, 'hasCombo' => $hasCombo));
}
$propIds = array();
foreach ($comboPropList as $row) {
$propIds[] = $row['proid'];
}
//从主表获取房源信息
$propertyList = Model_House_HzProp::getPropsByPropIds($propIds);
//获取是否精选或者竞价
$relations = Model_Plan_HzPlanning::getBidRelationsByHouseIds($propIds, array(Const_HzPlan::SPREAD, Const_HzPlan::WAITING));
if (!empty($relations)) {
$planPropMap = array();
foreach ($relations as $relation) {
$planIds[] = $relation['plan_id'];
$planPropMap[$relation['plan_id']] = $relation['proid'];
}
if (!empty($planIds)) {
$plans = Model_Plan_HzPlanBasic::getPlansByIds($planIds);
foreach ($plans as $plan) {
if ($plan->flag == 0) {
continue;
}
if ($plan->bid_version == 2) {
$propId = $planPropMap[$plan['id']];
$propertyList[$propId]['isChoice'] = 1;
} else {
$propId = $planPropMap[$plan['id']];
$propertyList[$propId]['isBid'] = 1;
}
}
}
}
// 批量获取房源的默认图片
$defaultImages = Model_Image_HzImage::getDefaultImagesByHouseIds($propIds);
if (!empty($defaultImages)) {
foreach ($defaultImages as $defaultImage) {
$propertyList[$defaultImage['proid']]['imgUrl'] = $defaultImage->imageUrl();
}
}
krsort($propertyList);
$startDate = $endDate = date('Ymd');
$todayClicks = Bll_Combo_Broker_BrokerComboInfo::getHouseComboClickEx($propIds, $startDate, $endDate, Model_Ppc_NewPackageStatsHouseDay::SITE_TYPE_HZ);
$totalClicks = Bll_House_HzHouse::getComboHouseAccumulateClick($ajkBrokerId, $propIds, $cityId);
foreach ($propertyList as $list) {
$row = array();
$row['id'] = $list['propId'];
$row['propId'] = $list['propId'];
$row['title'] = $list['title'];
$row['imgUrl'] = $list['imgUrl'] ?: '';
$row['commId'] = $list['commid'];
$row['commName'] = $list['commname'];
$row['roomNum'] = $list['roomnum'];
$row['hallNum'] = $list['hallnum'];
$row['toiletNum'] = $list['toilnetnum'];
$row['area'] = round($list['areanum']);
$row['price'] = round($list['pricenum']);
$row['priceUnit'] = '元/月';
$row['todayClicks'] = $todayClicks[$list['propId']][$startDate] ?: 0;
$row['totalClicks'] = $totalClicks[$list['propId']] ?: 0;
$row['totalClicks'] = $row['totalClicks'] + $row['todayClicks'];
$row['isBid'] = isset($list['isBid']) ? $list['isBid'] : 0;
$row['isChoice'] = isset($list['isChoice']) ? $list['isChoice'] : 0;
$row['isVisible'] = (int) ($list['status'] != 6);
$row['isMoreImg'] = (int) $list['quality'];
$row['isPhonePub'] = (int) (isset($list['from']) && $list['from'] == 'mobile-ajk-broker');
$row['publishDays'] = floor((time() - $list['created']) / 86400);
$row['publishDaysMsg'] = $row['publishDays'] > 0 ? "{$row['publishDays']}天前发布" : '今天发布';
$row['createTime'] = date('Y-m-d H:i:s', $list['created']);
//$row['updateTime'] = date('Y-m-d H:i:s', $list['updated']);
//是否委托
$isEntrust = Bll_Zufang_Choice::isCommissionHouse($list['propId'], $ajkBrokerId, Model_House_Commission::TYPE_RENT);
$row['isEntrust'] = $isEntrust ? 1 : 0;
$row['publishDays'] > 30 ? $oldList[] = $row : ($newList[] = $row);
}
return array('status' => Const_APIStatus::RETURN_CODE_OK, 'data' => array('newList' => $newList, 'oldList' => $oldList, 'surplus' => $surplus - $currentSpreadHouseCount, 'hasCombo' => $hasCombo));
}
public function do_getComboPropAllClicks()
{
$proIds = is_string($this->params['proIds']) ? explode(',', $this->params['proIds']) : $this->params['proIds'];
$result = Bll_House_HzHouse::getComboHouseAccumulateClick($this->brokerId, $proIds, $this->cityId);
return Util_GlobalFunc::buildReturn(1, $result);
}
public function getComboPropsInOneComm($brokerId, $cityId, $commId = '')
{
$siteType = Bll_Combo_Broker_BrokerComboInfo::SITE_TYPE_HZ;
$comboList = Bll_Combo_HouseRelation::getHouseRelations($brokerId, $siteType, 1);
if (empty($comboList)) {
return array();
}
$propIds = array();
foreach ($comboList as $row) {
$propIds[] = $row['houseId'];
}
$propertyList = Model_House_HzProp::getPropsByPropIds($propIds);
//获取是否精选或者竞价
$relations = Model_Plan_HzPlanning::getBidRelationsByHouseIds($propIds, array(Const_HzPlan::SPREAD, Const_HzPlan::WAITING));
if (!empty($relations)) {
$planPropMap = array();
foreach ($relations as $relation) {
$planIds[] = $relation['plan_id'];
$planPropMap[$relation['plan_id']] = $relation['proid'];
}
if (!empty($planIds)) {
$plans = Model_Plan_HzPlanBasic::getPlansByIds($planIds);
foreach ($plans as $plan) {
if ($plan->flag == 0) {
continue;
}
if ($plan->bid_version == 2) {
$propId = $planPropMap[$plan['id']];
$propertyList[$propId]['isChoice'] = 1;
} else {
$propId = $planPropMap[$plan['id']];
$propertyList[$propId]['isBid'] = 1;
}
}
}
}
// 批量获取房源的默认图片
$defaultImages = Model_Image_HzImage::getDefaultImagesByHouseIds($propIds);
if (!empty($defaultImages)) {
foreach ($defaultImages as $defaultImage) {
$propertyList[$defaultImage['proid']]['imgUrl'] = $defaultImage->imageUrl();
}
}
krsort($propertyList);
$base_domain = APF::get_instance()->get_config('base_domain');
$startDate = $endDate = date('Ymd');
$todayClicks = Bll_Combo_Broker_BrokerComboInfo::getHouseComboClickEx($propIds, $startDate, $endDate, Model_Ppc_NewPackageStatsHouseDay::SITE_TYPE_HZ);
$totalClicks = Bll_House_HzHouse::getComboHouseAccumulateClick($brokerId, $propIds, $cityId);
foreach ($propertyList as $key => $prop) {
if (in_array($prop['status'], array(Const_HzStatus::VERIFY, Const_HzStatus::REMOVE, Const_HzStatus::EXPIRED))) {
continue;
}
$row = array();
$row['id'] = $prop['propId'];
$row['title'] = $prop['title'];
$row['commId'] = $prop['commid'];
$row['commName'] = $prop['commname'];
$row['roomNum'] = $prop['roomnum'];
$row['hallNum'] = $prop['hallnum'];
$row['toiletNum'] = $prop['toilnetnum'];
$row['area'] = round($prop['areanum']);
$row['price'] = round($prop['pricenum']);
$row['priceUnit'] = '元/月';
$row['isVisible'] = (int) ($prop['status'] != 6);
$row['imgUrl'] = $prop['imgUrl'] ?: '';
$row['isMoreImg'] = (int) $prop['quality'];
$row['isPhonePub'] = (int) (isset($prop['from']) && $prop['from'] == 'mobile-ajk-broker');
$row['propUrl'] = 'http://' . $base_domain . '/web/rent/x/' . $prop['cityid'] . '/' . $prop['propId'] . '-3';
$row['isBid'] = isset($prop['isBid']) ? $prop['isBid'] : 0;
$row['isChoice'] = isset($prop['isChoice']) ? $prop['isChoice'] : 0;
$todayClick = $todayClicks[$prop['propId']][$startDate] ?: 0;
$row['totalClicks'] = $totalClicks[$prop['propId']] ?: 0;
$row['totalClicks'] = $row['totalClicks'] + $todayClick;
$row['createTime'] = date('Y-m-d H:i:s', $prop['created']);
$row['updateTime'] = date('Y-m-d H:i:s', $prop['updated']);
$commProps[$prop['commid']][$key] = $row;
}
// 如果是获取某单个小区房源列表
if ($commId) {
$ret['status'] = 'ok';
$ret['data']['propertyList'] = isset($commProps[$commId]) && !empty($commProps[$commId]) ? array_values($commProps[$commId]) : array();
} else {
$ret = isset($commProps) && !empty($commProps) ? $commProps : array();
}
return $ret;
}