public function handle_request_internal()
{
$request = APF::get_instance()->get_request();
$routeMatches = $request->get_router_matches();
$business = $routeMatches[1];
/** 处理二手房 */
if (strcasecmp($business, 'ajk') == 0) {
$siteType = Bll_Combo_HouseRelation::SITE_TYPE_AJK;
} elseif (strcasecmp($business, 'hz') == 0) {
$siteType = Bll_Combo_HouseRelation::SITE_TYPE_HZ;
} else {
$this->responseJSON('error', array(), '非法请求');
return;
}
$brokerId = intval($request->get_parameter('broker_id'));
if ($brokerId <= 0) {
$this->responseJSON('error', array(), '请提交经纪人ID');
return;
}
$houseComboRelationList = Bll_Combo_HouseRelation::getHouseRelations($brokerId, $siteType, 1);
if (empty($houseComboRelationList)) {
$this->responseJSON('ok', array(), '没有获取到房源推广信息');
return;
}
$result = array('spread_house' => array(), 'not_spread_house' => array());
foreach ($houseComboRelationList as $houseComboRelation) {
$result['spread_house'][] = $houseComboRelation['houseId'];
}
$this->responseJSON('ok', $result, $request->get_parameter('broker_id'));
}
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()
{
if ($this->_brokerId == 0) {
echo sprintf('Usage: launcher.php Monitor_JpHouseSpreadState --broker=[:number:] [--release=...]'), PHP_EOL;
return;
}
$loadFields = array('id', 'cityId', 'ajkMemberId');
$brokerInfo = Model_Broker_JpBroker::getJpBrokerInfoByAjkBrokerIdEx($this->_brokerId, $loadFields);
if (empty($brokerInfo)) {
$this->logMsg(sprintf('没有获取到经纪人[%d]的金铺经纪人信息', $this->_brokerId));
return;
}
$this->logMsg(sprintf('经纪人[%d]的金铺经纪人信息: %s', $this->_brokerId, json_encode($brokerInfo)));
$searchParams = array('fl' => 'id,is_auction,is_combo', 'q' => '*:*', 'version' => '2.2', 'indent' => 'on', 'rows' => 1000, 'wt' => 'json');
$fieldQuery = array('fq=' . urlencode(sprintf('list_time:[0 TO %d]', time())), 'fq=' . urlencode(sprintf('member_id:%d', $brokerInfo['id'])), 'fq=' . urlencode(sprintf('city_id:%d', $brokerInfo['cityId'])));
$query = http_build_query($searchParams);
$houseInInSolr = array();
/** 查询在Solr中的房源 */
foreach ($this->_hosts as $houseType => $host) {
$url = $host . '?' . $query . '&' . implode('&', $fieldQuery);
$this->logMsg('URL: ' . $url);
$temp = $this->httpRequest($url);
foreach ($temp as $tmp) {
$tmp['houseType'] = $houseType;
$houseInInSolr[$tmp['id']] = $tmp;
}
}
/** 获取推广中的房源 */
$houseComboRelationList = Bll_Combo_HouseRelation::getHouseRelations($this->_brokerId, Bll_Combo_HouseRelation::SITE_TYPE_JP, 1);
if (empty($houseInInSolr) && empty($houseComboRelationList)) {
$this->logMsg(sprintf('经纪人[%d]没有在solr和在线的房源', $this->_brokerId));
return;
}
$comboSpreadHouseIds = array();
foreach ($houseComboRelationList as $houseComboRelation) {
$comboSpreadHouseIds[] = $houseComboRelation['houseId'];
}
/** 判断solr中的房源是否都在套餐推广中 该下没下 */
foreach ($houseInInSolr as $houseId => $houseSpreadState) {
if (!in_array($houseId, $comboSpreadHouseIds)) {
$this->logMsg(sprintf('房源[%d]在solr中，但是不在套餐推广中', $houseId));
file_put_contents($this->_houseInSolrNotSpread, sprintf('%d-%d' . PHP_EOL, $houseId, $houseSpreadState['houseType']), FILE_APPEND);
}
}
/** 判断套餐推广中的房源是否在solr中 该上没上 */
foreach ($comboSpreadHouseIds as $houseId) {
if (!isset($houseInInSolr[$houseId])) {
$this->logMsg(sprintf('房源[%d]在套餐推广中，但是不在solr中', $houseId));
file_put_contents($this->_comboSpreadHouseNotInSolr, $houseId . PHP_EOL, FILE_APPEND);
}
}
}
public function handle_request_combo()
{
$brokerId = $this->brokerId;
$cityId = $this->cityId;
$hzBrokerId = Bll_HzBroker::get_brokerid_by_ajk_brokerid($brokerId);
//获取所有有效房源
$props = Bll_House_HzHouse::getValidPropsByBrokerId($hzBrokerId, $cityId);
$propertyList = array();
if (!empty($props)) {
//获取套餐推广房源列表
$comboList = Bll_Combo_HouseRelation::getHouseRelations($brokerId, Bll_Combo_HouseRelation::SITE_TYPE_HZ, 1);
//所有有效房源-套餐推广房源 = 套餐未推广房源
if (!empty($comboList)) {
foreach ($comboList as $row) {
unset($props[$row['houseId']]);
}
}
if (!empty($props)) {
// 批量获取房源的默认图片
$defaultImages = Model_Image_HzImage::getDefaultImagesByHouseIds(array_keys($props));
if (!empty($defaultImages)) {
foreach ($defaultImages as $defaultImage) {
$props[$defaultImage['proid']]['imgUrl'] = $defaultImage->imageUrl();
}
}
foreach ($props as $list) {
$row = array();
$row['id'] = $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'] = $row['totalClicks'] = $row['isBid'] = $row['isChoice'] = 0;
$row['isVisible'] = (int) ($list['status'] != 6);
$row['isMoreImg'] = (int) $list['quality'];
$row['isPhonePub'] = (int) (isset($list['from']) && $list['from'] == 'mobile-ajk-broker');
$isEntrust = Bll_Zufang_Choice::isCommissionHouse($list['propId'], $brokerId, Model_House_Commission::TYPE_RENT);
$row['isEntrust'] = $isEntrust ? 1 : 0;
$row['createTime'] = date('Y-m-d H:i:s', $list['created']);
$propertyList[] = $row;
}
}
}
return array('status' => Const_APIStatus::RETURN_CODE_OK, 'data' => array('propertyList' => $propertyList));
}
public function handle_request_combo()
{
$ajkBrokerId = $this->brokerId;
//获取经纪人套餐推广今日点击量
$comboClick = Bll_Ppc_NewPackageStatsBrokerDay::getComboClickInfo($ajkBrokerId, date('Ymd'), Model_Ppc_NewPackageStatsBrokerDay::SITE_TYPE_HZ);
$comboList = Bll_Combo_HouseRelation::getHouseRelations($ajkBrokerId, Bll_Combo_HouseRelation::SITE_TYPE_HZ, 1);
$hzBrokerId = Bll_HzBroker::get_brokerid_by_ajk_brokerid($ajkBrokerId);
$propIds = array();
foreach ($comboList as $row) {
$propIds[] = $row['houseId'];
}
$propertyList = Model_House_HzPropSearch::getPropList($propIds, $hzBrokerId, $this->cityId);
foreach ($propertyList as $key => $list) {
$row['publishDays'] = floor((time() - $list['created']) / 86400);
if (in_array($list['status'], array(Const_HzStatus::VERIFY, Const_HzStatus::REMOVE, Const_HzStatus::EXPIRED))) {
unset($propertyList[$key]);
}
}
return array('status' => Const_APIStatus::RETURN_CODE_OK, 'data' => array('todayClicks' => $comboClick, 'totalProps' => count($propertyList)));
}
/**
* 组装套餐列表
* @param $out
*/
public static function prepareComboList(&$out)
{
// 获取套餐信息
$out['comboInfos'] = Bll_Combo_Broker_BrokerComboInfo::getComboListBySite($out['ajkBrokerId'], Bll_Combo_Broker_BrokerComboInfo::SITE_TYPE_HZ);
if (count($out['comboInfos']) > 0) {
$currentCombo = $out['comboInfos'][0];
// 套餐打通
if (isset($currentCombo['openUp']) && $currentCombo['openUp'] == 1) {
$spreadPropNum = $currentCombo['salePropNum'] + $currentCombo['rentPropNum'] + $currentCombo['jpPropNum'];
// 减去二手房正在推广数
$ajkSpreadList = Bll_Combo_HouseRelation::getHouseRelations($out['ajkBrokerId'], Bll_Combo_HouseRelation::SITE_TYPE_AJK, 1);
$out['spreadPropNum'] = $spreadPropNum - count($ajkSpreadList);
} else {
$out['spreadPropNum'] = $currentCombo['rentPropNum'];
}
}
// 获取套餐点击量
// $comboClick = Bll_Ppc_NewPackageStatsBrokerDay::getComboClickInfo($out['ajkBrokerId'], date('Ymd'), Model_Ppc_NewPackageStatsBrokerDay::SITE_TYPE_HZ);
// $out['comboClick'] = $comboClick ? $comboClick : 0;
// 获取套餐推广关系列表
$out['comboList'] = Bll_Combo_HouseRelation::getHouseRelations($out['ajkBrokerId'], Bll_Combo_HouseRelation::SITE_TYPE_HZ, 1);
$temProps = array();
if (count($out['comboList'])) {
foreach ($out['comboList'] as $k => $comboInfo) {
// 转换房子id下标数组
$out['comboList'][$comboInfo['houseId']] = $comboInfo;
unset($out['comboList'][$k]);
if (isset($out['props'][$comboInfo['houseId']])) {
$temProps[] = $out['props'][$comboInfo['houseId']];
}
// 非有效房源过滤
$proId = $comboInfo['houseId'];
// 房子无效 关系还在， 过滤掉
if (!isset($out['props'][$proId])) {
unset($out['comboList'][$proId]);
continue;
}
$propInfo = $out['props'][$proId];
if (!in_array($propInfo['status'], array(Const_HzStatus::VERIFY, Const_HzStatus::REMOVE, Const_HzStatus::EXPIRED))) {
continue;
}
unset($out['comboList'][$proId]);
}
}
// 获取定价房子可否精选状态
if ($out['isChoiceCity']) {
$out['propChoiceStatus'] = Bll_HzProp::getPropChoiceStatus($temProps, $out['cityId']);
}
}
/**
* 获取租房房源数据
* [getBrokerEsfPro description]
*/
private function getBrokerZfPro()
{
$data = $proClickInfo = array();
$isCombo = Bll_Combo_HouseRelation::isComboCity($this->cityId);
if ($isCombo['data']) {
$comboList = Bll_Combo_HouseRelation::getHouseRelations($this->brokerId, Bll_Combo_HouseRelation::SITE_TYPE_HZ, 1);
$proIds = $this->getObjFieldInfo($comboList, 'houseId');
$clicksInfo = Bll_Ppc_NewPackageStatsBrokerDay::getHouseComboClickInfo($proIds, date('Ymd'), Model_Ppc_NewPackageStatsHouseDay::SITE_TYPE_HZ);
if (!empty($clicksInfo)) {
foreach ($clicksInfo as $val) {
if (isset($proClickInfo[$val['propId']])) {
$proClickInfo[$val['propId']] += intval($val['cnum']);
} else {
$proClickInfo[$val['propId']] = intval($val['cnum']);
}
}
}
} else {
$hzBrokerId = Bll_Broker_BrokerCheckInfo::getHzBrokerIdByAjkBrokerId($this->brokerId);
//定价房源信息
$fixedProInfos = Bll_House_FixedPro::getInstance()->getBrokerHzFiexdProInfo($hzBrokerId);
if (empty($fixedProInfos)) {
$this->outData($data, 1);
}
$proIds = $this->getObjFieldInfo($fixedProInfos, 'proid');
//房源点击量信息
$proClicks = Bll_House_HzPro::getInstance()->getProClicks($proIds, array(), date('Ymd'));
if (!empty($proClicks)) {
//将房源ID作为key拼接点击量信息
foreach ($proClicks as $proClickVal) {
$proClickInfo[$proClickVal['proid']] = intval($proClickVal['cnt']);
}
}
}
$proInfos = Bll_House_HzPro::getInstance()->getBrokerHzProInfo($proIds, $this->cityId);
if (empty($proInfos)) {
$this->outData($data, 1);
}
//经纪人橱窗房源设置信息
$adProInfos = Bll_Broker_ShowcaseAdSetPro::getInstance()->getBrokerAdRentPropInfo($this->brokerId);
$addPro = array();
if (!empty($adProInfos)) {
foreach ($adProInfos as $adProVal) {
$addPro[$adProVal->propId] = true;
}
}
//房源主表信息
$propMianInfo = Bll_House_HzPro::getInstance()->getHzProInfoByIds($proIds);
$propMianNew = array();
foreach ($propMianInfo as $propMianVal) {
$propMianNew[$propMianVal->propId]['contentBasic'] = json_decode($propMianVal->contentBasic, true);
$propMianNew[$propMianVal->propId]['contentOther'] = json_decode($propMianVal->contentOther, true);
}
$this->initZfProData($proInfos, $proClickInfo, $addPro, $propMianNew);
}
/**
* 获取经纪人可选房源
* @param $siteType
* @return array
*/
private function getProIdsByBrokerId($siteType)
{
$comboList = Bll_Combo_HouseRelation::getHouseRelations($this->brokerId, $siteType, 1);
$proIds = array();
foreach ($comboList as $key => $val) {
$proIds[] = $val['houseId'];
}
return $proIds;
}
public function handle_request_internal()
{
$brokerId = $this->_params['brokerId'];
$cityId = $this->_params['cityId'];
// 获取未推广房源列表
$hzBrokerId = Bll_HzBroker::get_brokerid_by_ajk_brokerid($brokerId);
//APP套餐城市调错API了 需要做一下套餐城市的兼容处理
$isComboBroker = Bll_Broker_HzBroker::isComboBroker($brokerId);
if (!$isComboBroker) {
$props = Bll_HzFixPlan::get_outline_list($hzBrokerId, $cityId, 1);
$propIds = array();
$propertyList = array();
foreach ($props as $prop) {
$propId = $prop['proid'];
$propIds[] = $propId;
$row = array();
$row['propId'] = $row['id'] = $propId;
$row['title'] = $prop['content_basic']['title'];
$row['imgUrl'] = '';
$row['commId'] = $prop['content_basic']['commid'];
$row['commName'] = $prop['content_basic']['commname'];
$row['roomNum'] = $prop['content_basic']['roomnum'];
$row['hallNum'] = $prop['content_basic']['hallnum'];
$row['toiletNum'] = $prop['content_basic']['toilnetnum'];
$row['area'] = round($prop['content_basic']['areanum']);
$row['price'] = round($prop['content_basic']['pricenum']);
$row['priceUnit'] = '元/月';
$row['isBid'] = 0;
$row['isChoice'] = 0;
$row['isVisible'] = intval($prop['content_basic']['status'] != 6);
$row['isMoreImg'] = intval($prop['content_basic']['quality']);
$row['isPhonePub'] = intval(isset($prop['content_basic']['from']) && $prop['content_basic']['from'] == 'mobile-ajk-broker');
$row['publishDays'] = floor((time() - $prop['content_basic']['created']) / 86400);
$row['publishDaysMsg'] = $row['publishDays'] > 0 ? "{$row['publishDays']}天前发布" : '今天发布';
$row['createTime'] = date('Y-m-d H:i:s', $prop['content_basic']['created']);
$row['updateTime'] = date('Y-m-d H:i:s', $prop['content_basic']['updated']);
//增加委托房源标签
$isEntrust = Bll_Zufang_Choice::isCommissionHouse($propId, $brokerId, Model_House_Commission::TYPE_RENT);
$row['isEntrust'] = $isEntrust ? 1 : 0;
$propertyList[$propId] = $row;
}
if ($propIds) {
// 批量获取房源的默认图片
$defaultImages = Model_Image_HzImage::getDefaultImagesByHouseIds($propIds);
foreach ($defaultImages as $defaultImage) {
$propertyList[$defaultImage['proid']]['imgUrl'] = $defaultImage->imageUrl();
}
}
$result = array();
$result['status'] = Const_APIStatus::RETURN_CODE_OK;
$result['data']['propertyList'] = array_values($propertyList);
return $result;
} else {
//获取所有有效房源
$props = Bll_House_HzHouse::getValidPropsByBrokerId($hzBrokerId, $cityId);
$propertyList = array();
if (!empty($props)) {
//获取套餐推广房源列表
$comboList = Bll_Combo_HouseRelation::getHouseRelations($brokerId, Bll_Combo_HouseRelation::SITE_TYPE_HZ, 1);
//所有有效房源-套餐推广房源 = 套餐未推广房源
if (!empty($comboList)) {
foreach ($comboList as $row) {
unset($props[$row['houseId']]);
}
}
if (!empty($props)) {
// 批量获取房源的默认图片
$defaultImages = Model_Image_HzImage::getDefaultImagesByHouseIds(array_keys($props));
if (!empty($defaultImages)) {
foreach ($defaultImages as $defaultImage) {
$props[$defaultImage['proid']]['imgUrl'] = $defaultImage->imageUrl();
}
}
foreach ($props as $list) {
$row = array();
$row['id'] = $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'] = $row['totalClicks'] = $row['isBid'] = $row['isChoice'] = 0;
$row['isVisible'] = (int) ($list['status'] != 6);
$row['isMoreImg'] = (int) $list['quality'];
$row['isPhonePub'] = (int) (isset($list['from']) && $list['from'] == 'mobile-ajk-broker');
$isEntrust = Bll_Zufang_Choice::isCommissionHouse($list['propId'], $brokerId, Model_House_Commission::TYPE_RENT);
$row['isEntrust'] = $isEntrust ? 1 : 0;
$row['createTime'] = date('Y-m-d H:i:s', $list['created']);
$propertyList[] = $row;
}
}
}
return array('status' => Const_APIStatus::RETURN_CODE_OK, 'data' => array('propertyList' => $propertyList));
}
}
public function handle_request_internal()
{
if (!Bll_City::isShowCaseCity(static::$intBrokerCityID)) {
$this->redirect('/user/combo/brokerhome');
exit;
}
//获取经纪人id
$objRequest = APF::get_instance()->get_request();
$cityid = self::$BrokerInfo['BaseInfo']['CITYID'];
$objRequest->set_attribute('PayType', self::$BrokerInfo['BaseInfo']['PAYTYPE']);
$isCombo = Bll_Combo_HouseRelation::isComboCity($cityid);
$tmp = array('cityId' => $cityid, 'status' => 1, 'startDate' => date('Ymd'));
$cityPrice = Bll_Broker_ConfigCityPrice::getInstance()->getCityPrice($tmp, Const_ShowcaseOrders::RENT_DB);
$todayPrice = round($cityPrice->discountPrice / 100, 2);
$intBrokerID = $objRequest->getBrokerId();
//好租经纪人ID
$hzBrokerId = Bll_Broker_BrokerCheckInfo::getHzBrokerIdByAjkBrokerId($intBrokerID);
$userId = $objRequest->getUserId();
$data = array('brokerId' => $intBrokerID);
$orderinfo = Bll_Broker_ShowcaseOrders::getInstance()->getBrokerOrders($data, $this->db);
//判断经纪人是否有订单
if (!$orderinfo) {
$this->toManage('/ajkbroker/showcase/zf/');
}
$lavedays = ceil((strtotime($orderinfo->endDate) - strtotime(date('Ymd'))) / 3600 / 24);
if ($orderinfo->isStop == 1 || $lavedays < 0) {
$order_status = 'stop';
} else {
$objRequest->set_attribute('lavedays', $lavedays);
$objRequest->set_attribute('lastday', date('Y-m-d', strtotime($orderinfo->endDate)));
$order_status = 'open';
}
//获取参数值
$params = APF::get_instance()->get_request()->get_parameters();
$days = intval($params['days']);
//status=2是停止，status=1是续费
if ($params['status'] == 2) {
if ($orderinfo->isStop == 0) {
$stopstatus = Bll_Broker_ShowcaseOrders::getInstance()->stopBrokerOthers($orderinfo, $cityPrice->discountPrice, $this->db);
if ($stopstatus['status']) {
$this->toManage();
} else {
$this->toError($stopstatus['msg']);
}
} else {
$msg = '订单类型不能操作';
$this->toError($msg);
}
} elseif ($params['status'] == 1 && $days >= 1) {
$BrokerMoney = Bll_Broker_ShowcaseOrders::getInstance()->getBrokerMoney($userId);
if ($BrokerMoney < $todayPrice) {
$this->toError(Const_ShowcaseOrders::MONEY_NOT_ENOUGH);
}
$Continueorder = Bll_Broker_ShowcaseOrders::getInstance()->continueBrokerOthers($orderinfo, $days, $cityPrice->discountPrice, $this->db);
if ($Continueorder['status']) {
$this->toManage();
} else {
$this->toError($Continueorder['msg']);
}
} elseif ($params['status'] == 3) {
if (!empty($params['rooms'])) {
$proIds = explode(';', $params['rooms']);
$filterProIds = Bll_Broker_ShowcaseAdSetPro::getInstance()->filterProIds($intBrokerID, $cityid, $this->db, $proIds);
//有些房源不在线上展示
if (count($filterProIds) != count($proIds)) {
$this->toError('有些房源没在线上推广，操作失败！');
}
$res = Bll_Broker_ShowcaseAdSetPro::getInstance()->insertAdProsInfo($intBrokerID, $cityid, $proIds, $this->db);
if (!$res['status']) {
$this->toError($res['msg']);
} else {
//插入成功，跳转至管理页面
if ($orderinfo->isStop == 0) {
$log = array();
$log['brokerId'] = $orderinfo->brokerId;
$log['cityId'] = $orderinfo->cityId;
$log['endDate'] = $orderinfo->endDate;
$log['startDate'] = $orderinfo->startDate;
$log['opType'] = Const_ShowcaseOrders::OPTYPE_6;
$log['totalDays'] = ceil((strtotime($orderinfo->endDate) - strtotime($orderinfo->startDate)) / 3600 / 24) + 1;
$log['createTime'] = time();
Bll_Broker_ShowcaseOrders::getInstance()->insertSetLog($log, $this->db);
}
$this->toManage();
}
}
}
$orderCreated = date('Ymd', $orderinfo->createTime);
if ($orderCreated < date('Ymd')) {
$click = Bll_Broker_ShowcaseOrders::getInstance()->getBrokerClick($intBrokerID, date('Ymd', strtotime('-1 days')), $this->db);
if (!$click->quantityCount) {
$objRequest->set_attribute('YClick', 0);
} else {
$objRequest->set_attribute('YClick', $click->quantityCount);
}
$objRequest->set_attribute('IS_YClick', true);
}
if ($isCombo['data']) {
$comboList = Bll_Combo_HouseRelation::getHouseRelations($intBrokerID, Bll_Combo_HouseRelation::SITE_TYPE_HZ, 1);
if (!empty($comboList)) {
if (count($comboList) >= Const_ShowcaseOrders::SALE_PRO_MAX_COUNT) {
$fixedProInfosCnt = Const_ShowcaseOrders::SALE_PRO_MAX_COUNT;
} else {
$fixedProInfosCnt = count($comboList);
}
} else {
$fixedProInfosCnt = 0;
}
$proInfo = Bll_Broker_ShowcaseAdSetPro::getInstance()->getBrokerAdRentPropInfo($intBrokerID);
$proIds = Bll_Broker_ShowcaseOrders::getInstance()->getObjFieldInfo($proInfo, 'propId');
$proInfos = Bll_House_HzPro::getInstance()->getBrokerHzProInfo($proIds, $cityid);
$propMianInfo = Bll_House_HzPro::getInstance()->getHzProInfoByIds($proIds);
$propMianNew = array();
foreach ($propMianInfo as $propMianVal) {
$propMianNew[$propMianVal->propId]['contentBasic'] = json_decode($propMianVal->contentBasic, true);
$propMianNew[$propMianVal->propId]['contentOther'] = json_decode($propMianVal->contentOther, true);
}
$proList = Bll_Broker_ShowcaseAdSetPro::getInstance()->initComboZfProData($proInfos, $propMianNew, $comboList);
} else {
$fixedProInfos = Bll_House_FixedPro::getInstance()->getBrokerHzFiexdProInfo($hzBrokerId);
if (!empty($fixedProInfos)) {
$proIds = Bll_Broker_ShowcaseOrders::getInstance()->getObjFieldInfo($fixedProInfos, 'proid');
$proInfos_tmp = Bll_House_HzPro::getInstance()->getBrokerHzProInfo($proIds, $cityid);
$proIdsc = Bll_Broker_ShowcaseOrders::getInstance()->getObjFieldInfo($proInfos_tmp, 'proid');
$proInfosc = Bll_House_HzPro::getInstance()->getBrokerHzProInfo($proIdsc, $cityid);
if (!empty($proInfosc)) {
if (count($proInfosc) >= Const_ShowcaseOrders::RENT_PRO_MAX_COUNT) {
$fixedProInfosCnt = Const_ShowcaseOrders::RENT_PRO_MAX_COUNT;
} else {
$fixedProInfosCnt = count($proInfosc);
}
} else {
$fixedProInfosCnt = 0;
}
} else {
$fixedProInfosCnt = 0;
}
$proInfo = Bll_Broker_ShowcaseAdSetPro::getInstance()->getBrokerAdRentPropInfo($intBrokerID);
$proIds = Bll_Broker_ShowcaseOrders::getInstance()->getObjFieldInfo($proInfo, 'propId');
$proStatus = Bll_House_FixedPro::getInstance()->getBrokerHzFiexdProStatus($proIds);
$proInfos = Bll_House_HzPro::getInstance()->getBrokerHzProInfo($proIds, $cityid);
$propMianInfo = Bll_House_HzPro::getInstance()->getHzProInfoByIds($proIds);
$propMianNew = array();
foreach ($propMianInfo as $propMianVal) {
$propMianNew[$propMianVal->propId]['contentBasic'] = json_decode($propMianVal->contentBasic, true);
$propMianNew[$propMianVal->propId]['contentOther'] = json_decode($propMianVal->contentOther, true);
}
$proList = Bll_Broker_ShowcaseAdSetPro::getInstance()->initZfProData($proInfos, $propMianNew, $proStatus);
}
if (count($proList) > $fixedProInfosCnt) {
$fixedProInfosCnt = count($proList);
}
$objRequest->set_attribute('type', 'hz');
$objRequest->set_attribute('index', 2);
//精选推广开关
$isChoice = Bll_City::isChoiceCity($cityid, Const_Site::HAOZU);
$objRequest->set_attribute('isChoice', $isChoice);
$objRequest->set_attribute('proList', $proList);
$objRequest->set_attribute('fixedProInfosCnt', $fixedProInfosCnt);
$objRequest->set_attribute('order_status', $order_status);
$objRequest->set_attribute('todayPrice', $todayPrice);
return 'Showcase_ZfManage';
}
public function handle_request_internal()
{
/*
@params planId ：计划id
@params resType ：默认为0,0表示不取计划房源信息，1为取房源信息
@params from ：来源
@success return 该计划id的信息
*/
if (!isset($this->_params['brokerId'])) {
return Util_MobileAPI::error(Const_APIStatus::E_PLAN_PARAM_BROKERID_MISS);
}
$brokerId = $this->_params['brokerId'];
//根据安居客经纪人ID获取好租经纪人ID
$brokerId_hz = Bll_HzBroker::get_brokerid_by_ajk_brokerid($brokerId);
if ($brokerId_hz) {
$broker_info = Dao_Broker_HzPlan::get_hzbroker_info($brokerId_hz);
if (!Bll_City::isBidCity($broker_info['cityid'])) {
return array('status' => 'ok', 'data' => array('propertyList' => array()));
}
}
if (Bll_Broker_HzBroker::isComboBroker($brokerId)) {
//获取套餐推广房源列表
$comboList = Bll_Combo_HouseRelation::getHouseRelations($brokerId, Bll_Combo_HouseRelation::SITE_TYPE_HZ, 1);
if (!empty($comboList)) {
foreach ($comboList as $combo) {
$comboIds[$combo['houseId']] = 1;
}
//获取竞价房源 去除竞价房源
$validBidPlans = Model_Plan_HzPlanBasic::getBidPlansByBrokerId($brokerId_hz);
$planIds = array();
if (!empty($validBidPlans)) {
foreach ($validBidPlans as $plan) {
if ($plan['flag'] == 1 && $plan['status'] != Const_HzPlan::DELETE) {
$planIds[] = $plan['id'];
}
}
if (!empty($planIds)) {
$bidPlannings = Model_Plan_HzPlanning::getPlanningByPlanIds($planIds);
}
if (!empty($bidPlannings)) {
foreach ($bidPlannings as $bid) {
unset($comboIds[$bid['proid']]);
}
}
}
//$propertyList = Model_House_HzProp::getPropsByPropIds(array_keys($comboIds));
$propertyList = Dao_Broker_HzProp::get_prop(array_keys($comboIds));
if (!empty($propertyList)) {
foreach ($propertyList as $key => $list) {
if ($list['content_basic']['quality'] != 1) {
unset($propertyList[$key]);
}
}
}
$result = $propertyList;
} else {
$result = array();
}
//去除竞价房源和非多图房源
} else {
$result = Bll_HzBidPlan::get_canbid_props($brokerId_hz);
}
$return = array();
$return["status"] = "ok";
$return["data"]['propertyList'] = array();
if (!empty($result)) {
$proprow = array();
foreach ($result as $propertyList) {
$proprow["id"] = $propertyList['proid'];
$proprow["title"] = $propertyList['content_basic']['title'];
$proprow["commId"] = $propertyList['content_basic']['commid'];
$proprow["commName"] = $propertyList['content_basic']['commname'];
$proprow["roomNum"] = $propertyList['content_basic']['roomnum'];
$proprow["hallNum"] = $propertyList['content_basic']['hallnum'];
$proprow["toiletNum"] = $propertyList['content_basic']['toilnetnum'];
$proprow["area"] = round($propertyList['content_basic']['areanum']);
$proprow["price"] = round($propertyList['content_basic']['pricenum']);
$proprow["isMoreImg"] = $propertyList['content_basic']['quality'] ? 1 : 0;
$proprow["priceUnit"] = "元";
$return["data"]['propertyList'][] = $proprow;
unset($proprow);
}
unset($result);
}
return $return;
}
/**
* 判断给定房源是否在线上推广
* @param $brokerId 二手房经纪人ID
* @param $cityId 城市ID
* @param $type 类型，二手房或者租房或者商业地产
* @param $filterProIds
* @param array $updateTimeArr
* @param array $newFixedProInfos
* @return array
*/
public function filterProIds($brokerId, $cityId, $type, $filterProIds, &$updateTimeArr = array(), &$newFixedProInfos = array())
{
//判断是否是套餐城市
$isCombo = Bll_Combo_HouseRelation::isComboCity($cityId);
if ($type == Const_ShowcaseOrders::SALE_DB) {
//二手房
//经纪人计划信息
if ($isCombo['data']) {
//套餐城市
$comboList = Bll_Combo_HouseRelation::getHouseRelations($brokerId, Bll_Combo_HouseRelation::SITE_TYPE_AJK, 1);
foreach ($comboList as $comboVal) {
$uTime = strtotime($comboVal['updateTime']);
$newFixedProInfos[$comboVal['houseId']] = array($comboVal['houseId'], $uTime);
$updateTimeArr[$comboVal['houseId']] = $uTime;
}
} else {
//PPC城市
$brokerPlanInfo = BLL_Plan_EsfPropFixedPlanRelation::get_instance()->getBrokerEsfOnlinePlan($brokerId);
if (empty($brokerPlanInfo)) {
return array();
}
//计划ID
$planIds = array();
foreach ($brokerPlanInfo as $brokerPlanVal) {
$planIds[] = $brokerPlanVal->id;
}
//定价推广房源
$fixedProInfos = Bll_Fixedspread_AjkFixedSpread::getFixedOnlineProByPlanIds($cityId, $planIds);
if (empty($fixedProInfos)) {
return array();
}
foreach ($fixedProInfos as $fixedProVal) {
$uTime = strtotime($fixedProVal->updatedDateTime);
$newFixedProInfos[$fixedProVal->proId] = array($fixedProVal->proId, $uTime);
$updateTimeArr[$fixedProVal->proId] = $uTime;
}
}
} elseif ($type == Const_ShowcaseOrders::RENT_DB) {
//如果是租房
if ($isCombo['data']) {
//套餐城市
$comboList = Bll_Combo_HouseRelation::getHouseRelations($brokerId, Bll_Combo_HouseRelation::SITE_TYPE_HZ, 1);
foreach ($comboList as $comboVal) {
$uTime = strtotime($comboVal['updateTime']);
$newFixedProInfos[$comboVal['houseId']] = array($comboVal['houseId'], $uTime);
$updateTimeArr[$comboVal['houseId']] = $uTime;
}
} else {
//PPC城市
$hzBrokerId = intval(Bll_Broker_BrokerCheckInfo::getHzBrokerIdByAjkBrokerId($brokerId));
//定价房源信息
$fixedProInfos = Bll_House_FixedPro::getInstance()->getBrokerHzFiexdProInfo($hzBrokerId);
if (empty($fixedProInfos)) {
return array();
}
foreach ($fixedProInfos as $fixedProVal) {
$newFixedProInfos[$fixedProVal->proid] = array($fixedProVal->proid, $fixedProVal->created);
$updateTimeArr[$fixedProVal->proid] = $fixedProVal->created;
}
}
}
//判断需要过滤的房源ID是否在推广房源信息中
if (!empty($filterProIds)) {
foreach ($filterProIds as $filterProKey => $filterProId) {
if (empty($newFixedProInfos[$filterProId])) {
//不在在线推广房源中，则释放
unset($filterProIds[$filterProKey]);
} else {
//过滤ID，因为补充逻辑肯定是补充不在过滤ID中的房源
unset($newFixedProInfos[$filterProId]);
unset($updateTimeArr[$filterProId]);
}
}
}
return $filterProIds;
}
/**
* 把经纪人因为套餐到期停止推广的房源（套餐规定的可推广房源数）重新上线，（按房源发布时间 倒序排列）
* @return string
*/
private function reUpExpireHouse()
{
$currentCombo = Bll_Combo_Broker_BrokerComboInfo::getBrokerCurrentCombo($this->params['ajk_broker_id'], Bll_Combo_Broker_BrokerComboInfo::SITE_TYPE_HZ);
if (Bll_Combo_Broker_BrokerComboInfo::isOpenUp($currentCombo)) {
return $this->allReturn[] = '打通套餐，好租不处理';
}
// 当前在线房源数
$onLineSpreadHouseCount = Bll_Combo_HouseRelation::getOnLineSpreadHouseCount($this->params['ajk_broker_id'], Bll_Combo_HouseRelation::SITE_TYPE_HZ);
$comboProNum = Bll_Combo_Broker_BrokerComboInfo::getTotalCombosProNum($this->params['ajk_broker_id']);
// 套餐可以推广的房源数
$comboProNum = isset($comboProNum['totalRentPropNum']) ? $comboProNum['totalRentPropNum'] : 0;
if (!$comboProNum) {
return $this->allReturn[] = "套餐可以推广的房源数0";
}
if ($onLineSpreadHouseCount >= $comboProNum) {
return $this->allReturn[] = "在线推广房源数{$onLineSpreadHouseCount}, 套餐可推广房源数{$comboProNum},不需要上线套餐到期的房子";
}
$shouldUpNum = $comboProNum - $onLineSpreadHouseCount;
$allExpireRelations = Bll_Combo_HouseRelation::getHouseRelations($this->params['ajk_broker_id'], Bll_Combo_HouseRelation::SITE_TYPE_HZ, Model_Combo_HouseRelation::ENUM_COMBO_EXPIRE);
if (empty($allExpireRelations)) {
return $this->allReturn[] = "没有需要上线的推广房子";
}
// 房子有效性判断
$num = 0;
$shouldUpRelations = array();
foreach ($allExpireRelations as $relation) {
$proId = $relation['houseId'];
if (!($propInfo = Bll_House_HzHouse::getPropInfo($proId, $relation['cityId'], 2))) {
continue;
}
if (!$propInfo['status'] || in_array($propInfo['msg']['status'], array(Const_HzStatus::VERIFY, Const_HzStatus::REMOVE, Const_HzStatus::EXPIRED))) {
continue;
}
if ($num < $shouldUpNum) {
$shouldUpRelations[] = $relation;
}
$num++;
}
foreach ($shouldUpRelations as $comboRelation) {
$this->params['pro_id'] = $comboRelation['houseId'];
// 更新关系
Bll_Combo_HouseRelation::updateComboStatusById($comboRelation['id'], Model_Combo_HouseRelation::ENUM_HOUSE_ONLINE, Bll_Combo_HouseRelation::SITE_TYPE_HZ);
// 维护房子状态
Bll_HzPropBll::bulidHzProStatu($this->params['pro_id']);
// 写入房源取消套餐推广日志
$this->writePropLog(Const_ProLogType::LOG_ADD_INTO_COMBO, '开始套餐推广');
}
}
/**
* 获取经纪人的发房房源houstIds
* @param $ctx
* @return array
*/
public static function getSpreadProIds($ctx)
{
$spreadProIds = array();
// ppc
if ($ctx['isFixCity']) {
$plannings = Bll_Plan_Fix_HzFix::getValidPlannings($ctx['hzBrokerId']);
if ($plannings) {
foreach ($plannings as $planning) {
$spreadProIds[] = $planning->proid;
}
}
} else {
// 新套餐
$spreadHouses = Bll_Combo_HouseRelation::getHouseRelations($ctx['ajkBrokerId'], Bll_Combo_HouseRelation::SITE_TYPE_HZ, 1);
if ($spreadHouses) {
foreach ($spreadHouses as $spreadHouse) {
$spreadProIds[] = $spreadHouse['houseId'];
}
}
}
return $spreadProIds;
}
/**
*
* 根据经纪人查询套餐房源的标签（优、良、中、待评）
* 根据房源的rank大段
* @param $brokerId
* @param $siteType
* @return array
* $result['list'][proid]['rankStar'] 大段
* $result['list'][proid]['rankStarName'] 大段名称
* $result['count'][0][rankStar] 各大段的数量标记
* $result['count'][0][rankStarName] 各大段的数量名称
* $result['count'][0][rankStarNum] 各大段的数量
*/
public static function getBrokerComboProRank($brokerId, $siteType, $cityId = '')
{
//标签返回值
$result = array();
switch ($siteType) {
case 'ajk':
//二手房
//分类计算标签数量
$rankTips = array(0 => '待评', 1 => '中等', 2 => '良好', 3 => '优质');
//获取经纪人套餐房源
$comboList = Bll_Combo_HouseRelation::getHouseRelations($brokerId, Bll_Combo_HouseRelation::SITE_TYPE_AJK, 1);
$houseIds = array();
foreach ($comboList as $combo) {
$houseIds[$combo['houseId']] = $combo['houseId'];
}
if (empty($houseIds)) {
return $result;
}
$houseInfo = array();
foreach ($comboList as $combo) {
$houseInfo['houseIdList'][] = $combo['houseId'];
$tmp = array('proId' => $combo['houseId'], 'postDate' => strtotime($combo['created']), 'cityId' => $combo['cityId']);
$houseInfo['comboSpreadHouseList'][$combo['houseId']] = $tmp;
}
if (empty($houseInfo)) {
return $result;
}
$housePostDate = array();
$housePostDateTmp = Bll_House_EsfHouse::getHouseInfo($houseInfo['houseIdList'], $cityId);
foreach ($housePostDateTmp as $k => $v) {
$housePostDate[$v['proId']] = $v;
}
foreach ($houseInfo['comboSpreadHouseList'] as $k => &$v) {
$v['postDate'] = $housePostDate[$k]['postDate'];
}
//获取房源的标签
$houseSollyResultList = Bll_House_EsfHouse::getHouseRankEx($houseInfo);
$houseRank = array();
foreach ($houseSollyResultList as $houseSollyResult) {
$houseRank[$houseSollyResult['propId']] = $houseSollyResult['rankStar'];
}
//标签数量计算
foreach ($houseIds as $houseId) {
if (isset($rankTips[$houseRank[$houseId]])) {
$rankStar = $houseRank[$houseId];
} else {
$rankStar = 0;
}
//数据列表
$result['list'][$houseId]['rankStar'] = $rankStar;
$result['list'][$houseId]['rankStarName'] = $rankTips[$rankStar];
//统计数据
$result['count'][$rankStar]['rankStar'] = $rankStar;
$result['count'][$rankStar]['rankStarName'] = $rankTips[$rankStar];
if (isset($result['count'][$rankStar]['rankStarNum'])) {
$result['count'][$rankStar]['rankStarNum'] += 1;
} else {
$result['count'][$rankStar]['rankStarNum'] = 1;
}
}
break;
case 'hz':
//租房
//分类计算标签数量
$rankTips = array(0 => '待评', 1 => '中等', 2 => '良好', 3 => '优质');
//获取经纪人套餐房源
$comboList = Bll_Combo_HouseRelation::getHouseRelations($brokerId, Bll_Combo_HouseRelation::SITE_TYPE_HZ, 1);
$houseIds = array();
foreach ($comboList as $combo) {
$houseIds[$combo['houseId']] = $combo['houseId'];
}
if (empty($houseIds)) {
return $result;
}
//获取房源的标签
//$houseSollyResultList = Model_Stats_HzPropQuality::getPropsqualityv2($houseIds);
$houseInfo = array();
$tmp = array();
foreach ($comboList as $v) {
$tmp['propId'] = $v['houseId'];
$tmp['cityid'] = $v['cityId'];
$tmp['created'] = strtotime($v['created']);
$houseInfo[$v['houseId']] = $tmp;
$tmp = array();
}
$housePostDate = array();
$housePostDateTmp = Bll_House_HzHouse::getValidPropsByBrokerIdEx($brokerId, $cityId);
foreach ($housePostDateTmp as $k => $v) {
$housePostDate[$v['proid']] = $v;
}
foreach ($houseInfo as $k => &$v) {
$v['created'] = $housePostDate[$k]['created'];
}
$houseSollyResultListTmp = Bll_Broker_Combo_ManageHz::getHzPropsQuality($houseInfo);
foreach ($houseSollyResultListTmp as $v) {
$tmp['cityId'] = $v['cityId'];
$tmp['proId'] = $v['proId'];
$tmp['rank'] = $v['rank'];
$houseSollyResultList[] = $tmp;
}
$houseRank = array();
foreach ($houseSollyResultList as $houseSollyResult) {
$houseRank[$houseSollyResult['proId']] = $houseSollyResult['rank'];
}
//标签数量计算
foreach ($houseIds as $houseId) {
if (isset($rankTips[$houseRank[$houseId]])) {
if ($houseRank[$houseId] == 1) {
$rankStar = 3;
//优
} elseif ($houseRank[$houseId] == 2) {
$rankStar = 2;
//良
} elseif ($houseRank[$houseId] == 3) {
$rankStar = 1;
//中
} else {
$rankStar = 0;
//优
}
} else {
$rankStar = 0;
}
//数据列表
$result['list'][$houseId]['rankStar'] = $rankStar;
$result['list'][$houseId]['rankStarName'] = $rankTips[$rankStar];
//统计数据
$result['count'][$rankStar]['rankStar'] = $rankStar;
$result['count'][$rankStar]['rankStarName'] = $rankTips[$rankStar];
if (isset($result['count'][$rankStar]['rankStarNum'])) {
$result['count'][$rankStar]['rankStarNum'] += 1;
} else {
$result['count'][$rankStar]['rankStarNum'] = 1;
}
}
break;
case 'jp':
//金铺
$exquisite = array(1 => '精品', 2 => '非精品');
//获取经纪人套餐房源
$comboList = Bll_Combo_HouseRelation::getHouseRelations($brokerId, Bll_Combo_HouseRelation::SITE_TYPE_JP, 1);
$houseIds = array();
foreach ($comboList as $combo) {
$houseIds[$combo['houseId']] = $combo['houseId'];
}
if (empty($houseIds)) {
return $result;
}
//获取房源的标签
$jpOfficeRent = Model_House_JpOfficeRent::getPropInfoByIds($houseIds);
$jpOfficeSale = Model_House_JpOfficeSale::getPropInfoByIds($houseIds);
$jpShopRent = Model_House_JpShopRent::getPropInfoByIds($houseIds);
$jpShopSale = Model_House_JpShopSale::getPropInfoByIds($houseIds);
$houseSollyResultList = array_merge($jpOfficeRent, $jpOfficeSale, $jpShopRent, $jpShopSale);
$houseExquisite = array();
foreach ($houseSollyResultList as $houseSollyResult) {
$houseExquisite[$houseSollyResult['id']] = $houseSollyResult['isExquisite'];
}
//标签数量计算
foreach ($houseIds as $houseId) {
if (isset($exquisite[$houseExquisite[$houseId]])) {
$exquisiteStar = $houseExquisite[$houseId];
} else {
$exquisiteStar = 2;
}
//数据列表
$result['list'][$houseId]['exquisiteStar'] = $exquisiteStar;
$result['list'][$houseId]['exquisiteStarName'] = $exquisite[$exquisiteStar];
//统计数据
$result['count'][$exquisiteStar]['exquisiteStar'] = $exquisiteStar;
$result['count'][$exquisiteStar]['exquisiteStarName'] = $exquisite[$exquisiteStar];
if (isset($result['count'][$exquisiteStar]['exquisiteStarNum'])) {
$result['count'][$exquisiteStar]['exquisiteStarNum'] += 1;
} else {
$result['count'][$exquisiteStar]['exquisiteStarNum'] = 1;
}
}
break;
default:
break;
}
return $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;
}
public function handle_request_internal()
{
$brokerId = $this->_params['brokerId'];
//经纪人信息
$brokerInfo = Model_Broker_AjkBrokerExtend::findWithBrokerId($brokerId);
if (!$brokerInfo) {
throw new Exception_BrokerNotFoundException('经纪人不存在', Const_APIStatus::E_BROKER_NOT_EXISTS);
}
$communityList = array();
$cityId = $brokerInfo->cityId;
$hzBrokerId = Model_Broker_HzMapping::get_hz_broker_id($brokerId);
if (Bll_Broker_HzBroker::isComboBroker($brokerId)) {
/** 租房 */
$comboList = Bll_Combo_HouseRelation::getHouseRelations($brokerId, Bll_Combo_HouseRelation::SITE_TYPE_HZ, 1);
//套餐列表
$propIds = array();
foreach ($comboList as $combo) {
$propIds[] = $combo['houseId'];
}
if ($propIds && $hzBrokerId) {
$hzPropList = Model_House_HzPropSearch::getPropList($propIds, $hzBrokerId, $cityId);
//房源信息
foreach ($hzPropList as $list) {
//过滤无效房源
if (in_array($list['status'], array(Const_HzStatus::VERIFY, Const_HzStatus::REMOVE, Const_HzStatus::EXPIRED))) {
continue;
}
$row = array();
$row['commId'] = $list['commid'];
$row['commName'] = $list['commname'];
$communityList[$list['commid']] = $row;
}
}
/** 二手房 */
$comboSpreadHouseList = Bll_Broker_Combo_ManageAjk::getComboSpreadHouseList($brokerId, $cityId);
if ($comboSpreadHouseList) {
//获取房源信息
$propIds = array_keys($comboSpreadHouseList);
$propsInfo = Bll_House_EsfHouse::getHouseBaseInfo($propIds, $cityId);
foreach ($propsInfo as $prop) {
$row = array();
$row['commId'] = $prop->commId;
$row['commName'] = $prop->commName;
$communityList[$prop->commId] = $row;
}
}
} else {
//定价的情况
$brokerProps = Bll_Broker_HzBroker::getBrokerProps($brokerId, $cityId);
// 获取房源关系列表
if ($brokerProps['status']) {
/** 租房*/
$brokerProps = $brokerProps['msg'];
$plans = $brokerProps['plans'][0];
//定价计划
$plannings = $brokerProps['plannings'];
//计划房源关系
$propsTemp = $brokerProps['props'];
//定价房源
if (empty($plans)) {
$hzPropList = array();
} else {
$hzPropList = array();
foreach ($propsTemp as $prop) {
$hzPropList[$prop['proId']] = $prop;
}
foreach ($plannings as $key => $planning) {
// 非有效 过滤掉
if (!Bll_HzFixPlan::isValidPlanning($planning['isValid'])) {
unset($hzPropList[$planning['proId']]);
}
}
}
foreach ($hzPropList as $prop) {
$row = array();
$row['commId'] = $prop['commId'];
$row['commName'] = $prop['commName'];
$communityList[$prop['commId']] = $row;
}
}
/** 二手房*/
//获取经纪人有效定价计划 计划表
$fixSpreadPlanList = Bll_Plan_Fix_AjkPlan::getBrokerPlanList($brokerId);
$fixPlanId = $fixSpreadPlanList[0]['id'];
//关系表中获取房源；
if ($fixPlanId) {
$relations = Model_Plan_AjkFixRelation::getRelationListByPlanId($fixPlanId, $cityId);
$propIds = array();
foreach ($relations as $relation) {
$propIds[] = $relation['proId'];
}
if ($propIds) {
$propsInfo = Bll_House_EsfHouse::getHouseBaseInfo($propIds, $cityId);
foreach ($propsInfo as $prop) {
$row = array();
$row['commId'] = $prop->commId;
$row['commName'] = $prop->commName;
$communityList[$prop->commId] = $row;
}
}
}
}
//对小区按首字母排序
$communityList = $this->communitySortByCommCode($communityList);
return array('status' => Const_APIStatus::RETURN_CODE_OK, 'data' => array('communityList' => array_values($communityList)));
}
public function handle_request_combo()
{
$brokerId = $this->brokerId;
$cityId = $this->cityId;
$hzBrokerId = Bll_HzBroker::get_brokerid_by_ajk_brokerid($brokerId);
//获取所有有效房源
$props = Bll_House_HzHouse::getValidPropsByBrokerId($hzBrokerId, $cityId);
$propertyList = array();
if (!empty($props)) {
//获取套餐推广房源列表
$comboList = Bll_Combo_HouseRelation::getHouseRelations($brokerId, Bll_Combo_HouseRelation::SITE_TYPE_HZ, 1);
//获取精选房源列表
$bllChoice = new Bll_Zufang_Choice();
$choices = $bllChoice->get_active_choice_plans($hzBrokerId, array(1, 13, 2, 3, 7, 8));
$choicePropIds = array();
if (!empty($choices)) {
$keyedPlans = array();
foreach ($choices as $choice) {
$keyedPlans[$choice->id] = $choice;
}
// 获取所有的房源和精选的关系
$choiceRelations = $bllChoice->get_prop(array_keys($keyedPlans));
foreach ($choiceRelations as $choiceRelation) {
$choicePropIds[] = $choiceRelation->proid;
}
}
//所有有效房源-套餐推广房源-精选推广房源 = 待推广房源
if (!empty($comboList)) {
foreach ($comboList as $row) {
unset($props[$row['houseId']]);
}
}
if (!empty($choicePropIds)) {
foreach ($choicePropIds as $k => $v) {
unset($props[$v]);
}
}
if (!empty($props)) {
// 批量获取房源的默认图片
$defaultImages = Model_Image_HzImage::getDefaultImagesByHouseIds(array_keys($props));
if (!empty($defaultImages)) {
foreach ($defaultImages as $defaultImage) {
$props[$defaultImage['proid']]['imgUrl'] = $defaultImage->imageUrl();
}
}
//是否是精选城市，城市是否精选分离
$cityIsChoice = Bll_City::isChoiceCity($cityId, Const_Site::HAOZU);
$cityIsChoiceIndependent = Bll_City::isChoiceIndependentCity($cityId, Const_Site::HAOZU);
foreach ($props as $list) {
$row = array();
$row['id'] = $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'] = $row['totalClicks'] = $row['isBid'] = $row['isChoice'] = 0;
$row['isVisible'] = (int) ($list['status'] != 6);
$row['isMoreImg'] = (int) $list['quality'];
$row['isPhonePub'] = (int) (isset($list['from']) && $list['from'] == 'mobile-ajk-broker');
$isEntrust = Bll_Zufang_Choice::isCommissionHouse($list['propId'], $brokerId, Model_House_Commission::TYPE_RENT);
$row['isEntrust'] = $isEntrust ? 1 : 0;
$row['createTime'] = date('Y-m-d H:i:s', $list['created']);
//精选状态
$choiceStatus = Bll_HzProp::getZuFangChoiceStatus($list, $cityId, $cityIsChoice);
if (!$cityIsChoiceIndependent && $choiceStatus['choiceStatus']) {
//城市未精选分离
$choiceStatus['choiceStatus'] = 0;
$choiceStatus['choiceStatusName'] = '';
}
$row['choiceStatus'] = $choiceStatus['choiceStatus'];
$row['choiceStatusName'] = $choiceStatus['choiceStatusName'];
$propertyList[] = $row;
}
}
}
return array('status' => Const_APIStatus::RETURN_CODE_OK, 'data' => array('propertyList' => $propertyList));
}
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));
}
/**
* @param $task
* @return bool
*/
public function dealTask($task)
{
$brokerId = $task['brokerId'];
//获取订单信息
$brokerOrderInfo = Bll_Broker_ShowcaseOrders::getInstance()->getBrokerOrders(array('brokerId' => $brokerId), $this->_dataBase);
if (empty($brokerOrderInfo)) {
printf('[%s] remark: %s' . PHP_EOL, date('Y-m-d H:i:s'), '经纪人' . $brokerId . '还没有购买橱窗');
return true;
}
// 判断该经纪人橱窗是否过期
if ($this->currentYMD > $brokerOrderInfo['endDate']) {
printf('[%s] remark: %s' . PHP_EOL, date('Y-m-d H:i:s'), '经纪人' . $brokerId . '购买的橱窗已过期');
return true;
}
//TODO 查询该经纪人当前推广房源数是否小于0
if ($this->_dataBase == Const_ShowcaseOrders::SALE_DB) {
$comboList = Bll_Combo_HouseRelation::getHouseRelations($brokerId, Bll_Combo_HouseRelation::SITE_TYPE_AJK, 1);
} else {
$comboList = Bll_Combo_HouseRelation::getHouseRelations($brokerId, Bll_Combo_HouseRelation::SITE_TYPE_HZ, 1);
}
if (empty($comboList)) {
printf('[%s] remark: %s' . PHP_EOL, date('Y-m-d H:i:s'), '经纪人' . $brokerId . '当前还没有推广房源');
return true;
}
//判断该经纪人当天是否已经扣费
//default没有扣费记录
$requestTimes = 0;
$siteType = 1;
if ($this->_dataBase == Const_ShowcaseOrders::RENT_DB) {
$siteType = 2;
}
$condition = array('brokerId' => $brokerId, 'siteType' => $siteType, 'consumeDate' => $this->currentYMD);
$limit = 1;
$sort = array('id', 'desc');
$brokerConsumeInfo = Bll_Broker_ShowcaseAdConsumeQueue::getBrokerIsConsume($condition, $limit, $sort);
//有扣费记录
if (!empty($brokerConsumeInfo)) {
//待扣费
if ($brokerConsumeInfo['status'] == 0) {
printf('[%s] remark: %s' . PHP_EOL, date('Y-m-d H:i:s'), '经纪人' . $brokerId . '橱窗待扣费');
return true;
} elseif ($brokerConsumeInfo['status'] == 3) {
//已经扣费
printf('[%s] remark: %s' . PHP_EOL, date('Y-m-d H:i:s'), '经纪人' . $brokerId . '橱窗已经扣费');
return true;
} elseif ($brokerConsumeInfo['status'] == 2) {
//扣费失败
printf('[%s] remark: %s' . PHP_EOL, date('Y-m-d H:i:s'), '经纪人' . $brokerId . '橱窗扣费调用api失败');
return true;
} elseif ($brokerConsumeInfo['status'] == 1) {
//余额不足，继续写入扣费记录
$requestTimes = $brokerConsumeInfo['requestTimes'] + 1;
}
}
//获取扣费price
$tmpArr = array('cityId' => $task['cityId'], 'status' => 1, 'startDate' => $this->currentYMD);
$tmpCityPrice = Bll_Broker_ConfigCityPrice::getInstance()->getCityPrice($tmpArr, $this->_dataBase);
if ($tmpCityPrice) {
$cityPrice = $tmpCityPrice->discountPrice > 0 ? $tmpCityPrice->discountPrice : 0;
}
if (empty($cityPrice)) {
printf('[%s] remark: %s' . PHP_EOL, date('Y-m-d H:i:s'), '经纪人' . $brokerId . '橱窗扣费价格为0');
return true;
}
// 写扣费记录
$adConsumeArr = array('brokerId' => $brokerId, 'amount' => $cityPrice, 'consumeDate' => $this->currentYMD, 'status' => 0, 'siteType' => $siteType, 'requestTimes' => $requestTimes, 'createTime' => time());
Bll_Broker_ShowcaseAdConsumeQueue::dataInsert($adConsumeArr);
printf('[%s] remark: %s' . PHP_EOL, date('Y-m-d H:i:s'), '经纪人' . $brokerId . '橱窗扣费记录插入成功，请求次数：' . $requestTimes);
return true;
}
public function handle_request_internal()
{
if (!Bll_City::isShowCaseCity(static::$intBrokerCityID)) {
$this->redirect('/user/combo/brokerhome');
exit;
}
$objRequest = APF::get_instance()->get_request();
$cityID = self::$BrokerInfo['BaseInfo']['CITYID'];
$objRequest->set_attribute('PayType', self::$BrokerInfo['BaseInfo']['PAYTYPE']);
$tmp = array('cityId' => $cityID, 'status' => 1, 'startDate' => date('Ymd'));
$cityPrice = Bll_Broker_ConfigCityPrice::getInstance()->getCityPrice($tmp, Const_ShowcaseOrders::SALE_DB);
$todayPrice = round($cityPrice->discountPrice / 100, 2);
$intBrokerID = $objRequest->getBrokerId();
$userId = $objRequest->getUserId();
$data = array('brokerId' => $intBrokerID);
$orderinfo = Bll_Broker_ShowcaseOrders::getInstance()->getBrokerOrders($data, $this->db);
if (!$orderinfo) {
$this->toManage('/ajkbroker/showcase/esf/');
}
$lavedays = ceil((strtotime($orderinfo->endDate) - strtotime(date('Ymd'))) / 3600 / 24);
if ($orderinfo->isStop == 1 || $lavedays < 0) {
$order_status = 'stop';
} else {
$objRequest->set_attribute('lavedays', $lavedays);
$objRequest->set_attribute('lastday', date('Y-m-d', strtotime($orderinfo->endDate)));
$order_status = 'open';
}
$objRequest->set_attribute('order_status', $order_status);
$objRequest->set_attribute('todayPrice', $todayPrice);
$params = APF::get_instance()->get_request()->get_parameters();
$days = intval($params['days']);
//status=2是停止，status=1是续费
if ($params['status'] == 2) {
if ($orderinfo->isStop == 0) {
$stopstatus = Bll_Broker_ShowcaseOrders::getInstance()->stopBrokerOthers($orderinfo, $cityPrice->discountPrice, $this->db);
if ($stopstatus['status']) {
$this->toManage();
} else {
$this->toError($stopstatus['msg']);
}
} else {
$msg = '订单类型不能操作';
$this->toError($msg);
}
} elseif ($params['status'] == 1 && $days >= 1) {
$BrokerMoney = Bll_Broker_ShowcaseOrders::getInstance()->getBrokerMoney($userId);
if ($BrokerMoney < $todayPrice) {
$this->toError(Const_ShowcaseOrders::MONEY_NOT_ENOUGH);
}
$Continueorder = Bll_Broker_ShowcaseOrders::getInstance()->continueBrokerOthers($orderinfo, $days, $cityPrice->discountPrice, $this->db);
if ($Continueorder['status']) {
$this->toManage();
} else {
$this->toError($Continueorder['msg']);
}
} elseif ($params['status'] == 3) {
$proIds = array();
if (!empty($params['rooms'])) {
$proIds = explode(';', $params['rooms']);
$filterProIds = Bll_Broker_ShowcaseAdSetPro::getInstance()->filterProIds($intBrokerID, $cityID, $this->db, $proIds);
//有些房源不在线上展示
if (count($filterProIds) != count($proIds)) {
$this->toError('有些房源没在线上推广，操作失败！');
}
$res = Bll_Broker_ShowcaseAdSetPro::getInstance()->insertAdProsInfo($intBrokerID, $cityID, $proIds, $this->db);
if (!$res['status']) {
$this->toError($res['msg']);
} else {
//插入成功，跳转至管理页面
if ($orderinfo->isStop == 0) {
$log = array();
$log['brokerId'] = $orderinfo->brokerId;
$log['cityId'] = $orderinfo->cityId;
$log['endDate'] = $orderinfo->endDate;
$log['startDate'] = $orderinfo->startDate;
$log['opType'] = Const_ShowcaseOrders::OPTYPE_6;
$log['totalDays'] = ceil((strtotime($orderinfo->endDate) - strtotime($orderinfo->startDate)) / 3600 / 24) + 1;
$log['createTime'] = time();
Bll_Broker_ShowcaseOrders::getInstance()->insertSetLog($log, $this->db);
}
$this->toManage();
}
}
}
$orderCreated = date('Ymd', $orderinfo->createTime);
if ($orderCreated < date('Ymd')) {
$click = Bll_Broker_ShowcaseOrders::getInstance()->getBrokerClick($intBrokerID, date('Ymd', strtotime('-1 days')), $this->db);
if (!$click->quantityCount) {
$objRequest->set_attribute('YClick', 0);
} else {
$objRequest->set_attribute('YClick', $click->quantityCount);
}
$objRequest->set_attribute('IS_YClick', true);
}
$isCombo = Bll_Combo_HouseRelation::isComboCity($cityID);
if ($isCombo['data']) {
$comboList = Bll_Combo_HouseRelation::getHouseRelations($intBrokerID, Bll_Combo_HouseRelation::SITE_TYPE_AJK, 1);
if (!empty($comboList)) {
if (count($comboList) >= Const_ShowcaseOrders::SALE_PRO_MAX_COUNT) {
$fixedProInfosCnt = Const_ShowcaseOrders::SALE_PRO_MAX_COUNT;
} else {
$fixedProInfosCnt = count($comboList);
}
} else {
$fixedProInfosCnt = 0;
}
$proInfo = Bll_Broker_ShowcaseAdSetPro::getInstance()->getBrokerAdSalePropInfo($intBrokerID);
$proIds = Bll_Broker_ShowcaseOrders::getInstance()->getObjFieldInfo($proInfo, 'propId');
$proInfos = Bll_House_EsfHouse::getHouseInfo($proIds, $cityID);
$proList = Bll_Broker_ShowcaseAdSetPro::getInstance()->initComboEsfProData($proInfos, $comboList);
} else {
//获取经纪人计划
$brokerPlanInfo = BLL_Plan_EsfPropFixedPlanRelation::get_instance()->getBrokerEsfOnlinePlan($intBrokerID);
if (!empty($brokerPlanInfo)) {
//计划数据不为空
//计划IDs
$planIds = Bll_Broker_ShowcaseOrders::getInstance()->getObjFieldInfo($brokerPlanInfo, 'id');
//定价推广房源
$fixedProInfos = Bll_Fixedspread_AjkFixedSpread::getFixedOnlineProByPlanIds($cityID, $planIds);
$proIdsc = Bll_Broker_ShowcaseOrders::getInstance()->getObjFieldInfo($fixedProInfos, 'proId');
$proInfosc = Bll_House_EsfHouse::getHouseInfo($proIdsc, $cityID);
if (!empty($proInfosc)) {
if (count($proInfosc) >= Const_ShowcaseOrders::SALE_PRO_MAX_COUNT) {
$fixedProInfosCnt = Const_ShowcaseOrders::SALE_PRO_MAX_COUNT;
} else {
$fixedProInfosCnt = count($proInfosc);
}
} else {
$fixedProInfosCnt = 0;
}
} else {
$fixedProInfosCnt = 0;
}
$proInfo = Bll_Broker_ShowcaseAdSetPro::getInstance()->getBrokerAdSalePropInfo($intBrokerID);
$proIds = Bll_Broker_ShowcaseOrders::getInstance()->getObjFieldInfo($proInfo, 'propId');
$proInfos = Bll_House_EsfHouse::getHouseInfo($proIds, $cityID);
$proStatus = Bll_Fixedspread_AjkFixedSpread::getFixedProBy($cityID, $proIds);
$proList = Bll_Broker_ShowcaseAdSetPro::getInstance()->initEsfProData($proInfos, $proStatus, $planIds);
}
if (count($proList) > $fixedProInfosCnt) {
$fixedProInfosCnt = count($proList);
}
$objRequest->set_attribute('type', 'ajk');
$objRequest->set_attribute('index', 2);
//精选推广开关
$isChoice = Bll_City::isChoiceCity($cityID);
$objRequest->set_attribute('isChoice', $isChoice);
$objRequest->set_attribute('fixedProInfosCnt', $fixedProInfosCnt);
$objRequest->set_attribute('proList', $proList);
return 'Showcase_EsfManage';
}
public function handle_request()
{
if ($this->_cityId == 0 || $this->_brokerId == 0) {
echo sprintf('Usage: launcher.php Monitor_AjkHouseSpreadState --city=[:number:] --broker=[:number:] [--release=...]'), PHP_EOL;
return;
}
$searchParams = array('__test__' => __CLASS__ . time(), 'fl' => 'id,updatetime', 'q' => '*:*', 'rows' => 1000, 'wt' => 'json');
$fieldQuery = array('fq=' . urlencode(sprintf('hpstarttime:[0 TO %d]', time())), 'fq=' . urlencode('islist:1'), 'fq=' . urlencode('hpplanid:0'), 'fq=' . urlencode(sprintf('broker_id:%d', $this->_brokerId)), 'fq=' . urlencode(sprintf('city_id:%d', $this->_cityId)));
$query = http_build_query($searchParams);
$url = $this->getSolrUrl($this->_cityId) . '?' . $query . '&' . implode('&', $fieldQuery);
$houseInSolrTemp = $this->httpRequest($url);
$houseInSolrIds = array();
foreach ($houseInSolrTemp as $house) {
$houseInSolrIds[] = $house['id'];
}
if (!empty($houseInSolrIds)) {
$this->logMsg(sprintf('在solr中的房源[%s]', implode(',', $houseInSolrIds)));
} else {
$this->logMsg('在solr中的没有房源');
}
/** 获取推广中的房源 */
$houseComboRelationList = Bll_Combo_HouseRelation::getHouseRelations($this->_brokerId, Bll_Combo_HouseRelation::SITE_TYPE_AJK, 1);
$comboSpreadHouseIds = array();
foreach ($houseComboRelationList as $houseComboRelation) {
$comboSpreadHouseIds[] = $houseComboRelation['houseId'];
}
if (!empty($comboSpreadHouseIds)) {
$this->logMsg(sprintf('在推广的房源[%s]', implode(',', $comboSpreadHouseIds)));
} else {
$this->logMsg('没有在推广的房源');
}
if (empty($comboSpreadHouseIds) && empty($houseInSolrIds)) {
$this->logMsg('没有在solr和在推广的房源');
return;
}
/** 判断solr中的房源是否都在套餐推广中 该下没下 */
$houseInSolrNotSpread = array_diff($houseInSolrIds, $comboSpreadHouseIds);
if (!empty($houseInSolrNotSpread)) {
$this->logMsg(sprintf('房源[%s]在solr中，但是不在套餐推广中', implode(',', $houseInSolrNotSpread)));
$logContent = array();
foreach ($houseInSolrNotSpread as $houseInSolrNotSpreadId) {
$logContent[] = "{$this->_cityId}\t{$this->_brokerId}\t{$houseInSolrNotSpreadId}";
if ($this->_doAction) {
$this->notifyMiddleWare($houseInSolrNotSpreadId, Bll_Combo_NoticeSolrUpDown::SOLR_ACTION_DOWN);
}
}
file_put_contents($this->_houseInSolrNotSpread, implode(PHP_EOL, $logContent) . PHP_EOL, FILE_APPEND);
} else {
$this->logMsg('没有在solr中，但是不在套餐推广中的房源【该下没下】');
}
/** 判断套餐推广中的房源是否在solr中 该上没上 */
$comboSpreadHouseNotInSolr = array_diff($comboSpreadHouseIds, $houseInSolrIds);
if (!empty($comboSpreadHouseNotInSolr)) {
$this->logMsg(sprintf('房源[%s]在套餐推广中，但是不在solr中', implode(',', $comboSpreadHouseNotInSolr)));
$logContent = array();
foreach ($comboSpreadHouseNotInSolr as $comboSpreadHouseNotInSolrId) {
$logContent[] = "{$this->_cityId}\t{$this->_brokerId}\t{$comboSpreadHouseNotInSolrId}";
if ($this->_doAction) {
$this->notifyMiddleWare($comboSpreadHouseNotInSolrId, Bll_Combo_NoticeSolrUpDown::SOLR_ACTION_UP);
}
}
file_put_contents($this->_comboSpreadHouseNotInSolr, implode(PHP_EOL, $logContent) . PHP_EOL, FILE_APPEND);
} else {
$this->logMsg('没有在套餐推广中，但是不在solr中的房源【该上没上】');
}
}
/**
* 502 经纪人套餐生效
*
* @param $queueInfo
* @return array
*/
public static function comboEffect($queueInfo)
{
$dealRemark = array();
$currentCombo = Bll_Combo_Broker_BrokerComboInfo::getBrokerCurrentCombo($queueInfo['broker_id'], Bll_Combo_Broker_BrokerComboInfo::SITE_TYPE_AJK);
$onlineHouseRelationList = Bll_Combo_HouseRelation::getOnlineHouseList($queueInfo['broker_id'], $queueInfo['city_id'], Bll_Combo_HouseRelation::SITE_TYPE_AJK);
/** 当前没有生效的套餐，下掉所有的房子 */
if (empty($currentCombo)) {
$dealRemark[] = sprintf('%d 经纪人当前[%s]没有生效的租售套餐', $queueInfo['id'], date('Y-m-d H:i:s'));
$data = static::buildHouseLog($queueInfo, 21, '经纪人套餐生效，未获取到套餐信息房源下架', 0);
if (!empty($onlineHouseRelationList)) {
foreach ($onlineHouseRelationList as $onlineHouseRelation) {
$data['houseId'] = $onlineHouseRelation['houseId'];
if (!Model_Log_HouseLogNew::create($data, date('Ymd'))->save()) {
$dealRemark[] = sprintf('%d 套餐生效,未获取到套餐信息，下掉房源(%d) 失败', $queueInfo['id'], $onlineHouseRelation['houseId']);
continue;
}
$dealRemark[] = sprintf('%d 套餐生效,未获取到套餐信息，下掉房源(%d) 成功', $queueInfo['id'], $onlineHouseRelation['houseId']);
}
}
return static::buildReturn(self::PROCESS_STATUS_SUCCESS, $dealRemark);
}
/** 添加打通的套餐的逻辑 */
if (Bll_Combo_Broker_BrokerComboInfo::isOpenUp($currentCombo)) {
$dealRemark[] = '当前套餐为打通套餐';
$comboSpreadHouseCount = $currentCombo['salePropNum'] + $currentCombo['rentPropNum'];
$hzHouseOnlineRelationList = Bll_Combo_HouseRelation::getOnlineHouseList($queueInfo['broker_id'], $queueInfo['city_id'], Bll_Combo_HouseRelation::SITE_TYPE_HZ);
$spreadHouseCount = count($hzHouseOnlineRelationList) + count($onlineHouseRelationList);
if ($spreadHouseCount >= $comboSpreadHouseCount) {
$dealRemark[] = sprintf('%d 经纪人当前[%s]套餐,可推广房源数小于当前在线房源数，不处理。', $queueInfo['id'], date('Y-m-d H:i:s'));
return static::buildReturn(self::PROCESS_STATUS_SUCCESS, $dealRemark);
}
/** 上架房源 */
$needSpreadHouseCount = $comboSpreadHouseCount - $spreadHouseCount;
$hzExpiredHouseRelationList = Bll_Combo_HouseRelation::getHouseRelations($queueInfo['broker_id'], Bll_Combo_HouseRelation::SITE_TYPE_HZ, Model_Combo_HouseRelation::ENUM_COMBO_EXPIRE);
$ajkExpiredHouseRelationList = Bll_Combo_HouseRelation::getHouseRelations($queueInfo['broker_id'], Bll_Combo_HouseRelation::SITE_TYPE_AJK, Model_Combo_HouseRelation::ENUM_COMBO_EXPIRE);
$rangedHouseRelation = Bll_Combo_Updown_AjkDealJob::calculateRangeByCreated($ajkExpiredHouseRelationList, $hzExpiredHouseRelationList);
/** 过滤无效房源 */
$validateHouseRelation = array();
foreach ($rangedHouseRelation as $houseRelation) {
$houseId = $houseRelation['houseId'];
if ($houseRelation['siteType'] == Bll_Combo_HouseRelation::SITE_TYPE_HZ) {
$houseInfo = Model_House_HzPropSearch::get_prop_by_prop_id($queueInfo['city_id'], $houseId);
if (empty($houseInfo)) {
$dealRemark[] = sprintf('好租房源[%d]不存在', $houseId);
continue;
}
if (in_array($houseInfo['status'], array(Const_HzStatus::VERIFY, Const_HzStatus::REMOVE, Const_HzStatus::EXPIRED))) {
$dealRemark[] = sprintf('好租房源[%d]不是有效的房源', $houseId);
continue;
}
$validateHouseRelation[] = $houseRelation;
continue;
}
$houseInfo = Bll_House_EsfHouse::getHouseBaseInfoEx($houseId, $queueInfo['city_id']);
if (empty($houseInfo)) {
$dealRemark[] = sprintf('二手房房源[%d]不是有效的房源', $houseId);
continue;
}
if ($houseInfo['isVisible'] == 0 && $houseInfo['expireWorker'] != 'propertyReport') {
$dealRemark[] = sprintf('二手房房源（%d）违规，不做处理', $houseId);
continue;
}
$validateHouseRelation[] = $houseRelation;
}
$houseUpRelationList = array_slice($validateHouseRelation, 0, $needSpreadHouseCount);
$data = static::buildHouseLog($queueInfo, 20, '经纪人套餐生效，房源上架', 0);
foreach ($houseUpRelationList as $onlineHouseRelation) {
$site = $onlineHouseRelation['siteType'] == Bll_Combo_HouseRelation::SITE_TYPE_AJK ? '二手房' : '好租';
if (1 == Model_Combo_HouseRelation::updateHouseComboSpreadStateEx($queueInfo['broker_id'], $queueInfo['city_id'], $onlineHouseRelation['houseId'], Model_Combo_HouseRelation::ENUM_HOUSE_ONLINE, $onlineHouseRelation['siteType'])) {
$dealRemark[] = sprintf('上架' . $site . '房源[%d]成功', $onlineHouseRelation['houseId']);
} else {
$dealRemark[] = sprintf('上架' . $site . '房源[%d]失败', $onlineHouseRelation['houseId']);
}
$data['houseId'] = $onlineHouseRelation['houseId'];
$data['siteType'] = $onlineHouseRelation['siteType'] == Bll_Combo_HouseRelation::SITE_TYPE_AJK ? 1 : 2;
if (!Model_Log_HouseLogNew::create($data, date('Ymd'))->save()) {
$dealRemark[] = sprintf('%d 套餐生效,上架' . $site . '房源(%d) 失败', $queueInfo['id'], $onlineHouseRelation['houseId']);
continue;
}
$dealRemark[] = sprintf('%d 套餐生效,上架' . $site . '房源(%d) 成功', $queueInfo['id'], $onlineHouseRelation['houseId']);
}
$dealRemark[] = sprintf('%d [%s] 经纪人套餐生效，上架%d套房源。', $queueInfo['id'], date('Y-m-d H:i:s'), $spreadHouseCount);
return static::buildReturn(self::PROCESS_STATUS_SUCCESS, $dealRemark);
}
/**
* 下掉超出限制的房源
*/
if (count($onlineHouseRelationList) >= $currentCombo['salePropNum']) {
$data = static::buildHouseLog($queueInfo, 21, '经纪人套餐生效，下掉多余房子', 0);
$offLineHouseList = array_slice($onlineHouseRelationList, $currentCombo['salePropNum']);
if (empty($offLineHouseList)) {
return static::buildReturn(self::PROCESS_STATUS_SUCCESS, sprintf('%d [%s] 经纪人在线房源数已经达到套餐限制[%d]。', $queueInfo['id'], date('Y-m-d H:i:s'), $currentCombo['salePropNum']));
}
foreach ($offLineHouseList as $offLineHouse) {
$data['houseId'] = $offLineHouse['houseId'];
if (!Model_Log_HouseLogNew::create($data, date('Ymd'))->save()) {
$dealRemark[] = sprintf('%d 套餐生效,未获取到套餐信息，下掉房源(%d) 失败', $queueInfo['id'], $offLineHouse['houseId']);
continue;
}
$dealRemark[] = sprintf('%d 套餐生效,未获取到套餐信息，下掉房源(%d) 成功', $queueInfo['id'], $offLineHouse['houseId']);
}
return static::buildReturn(self::PROCESS_STATUS_SUCCESS, $dealRemark);
}
$expiredHouseRelationList = Bll_Combo_HouseRelation::getHouseRelations($queueInfo['broker_id'], Bll_Combo_HouseRelation::SITE_TYPE_AJK, Model_Combo_HouseRelation::ENUM_COMBO_EXPIRE);
if (empty($expiredHouseRelationList)) {
return static::buildReturn(self::PROCESS_STATUS_SUCCESS, sprintf('%d [%s] 没有获取到经纪人因套餐到期而下架的房源。', $queueInfo['id'], date('Y-m-d H:i:s')));
}
$expiredHouseRelationIds = array();
foreach ($expiredHouseRelationList as $expiredHouseRelation) {
$expiredHouseRelationIds[] = $expiredHouseRelation['houseId'];
}
$houseInfoList = Bll_House_EsfHouse::getHouseInfoByHouseIdEx($queueInfo['broker_id'], $expiredHouseRelationIds, $queueInfo['city_id'], array('proId', 'expireWorker', 'isVisible'));
if (empty($houseInfoList)) {
return static::buildReturn(self::PROCESS_STATUS_SUCCESS, sprintf('%d [%s] 没有获取到房源（%s）信息。', $queueInfo['id'], date('Y-m-d H:i:s'), implode(',', $expiredHouseRelationIds)));
}
/** 过滤掉违规房源 */
$validateHouseIds = array();
foreach ($houseInfoList as $houseInfo) {
if ($houseInfo['isVisible'] == 0 && $houseInfo['expireWorker'] != 'propertyReport') {
$dealRemark[] = sprintf('房源（%d）违规，不做处理', $houseInfo['proId']);
continue;
}
$validateHouseIds[] = $houseInfo['proId'];
}
/** 按照房源ID 排序 */
sort($validateHouseIds, SORT_NUMERIC);
if (count($validateHouseIds) > $currentCombo['salePropNum']) {
$onlineHouseIds = array_slice($validateHouseIds, count($validateHouseIds) - $currentCombo['salePropNum']);
} else {
$onlineHouseIds = $validateHouseIds;
}
$data = static::buildHouseLog($queueInfo, 20, '经纪人套餐生效，房源上架', 0);
foreach ($onlineHouseIds as $onlineHouseId) {
$data['houseId'] = $onlineHouseId;
if (!Model_Log_HouseLogNew::create($data, date('Ymd'))->save()) {
$dealRemark[] = sprintf('%d 套餐生效,上架房源(%d) 失败', $queueInfo['id'], $onlineHouseId);
continue;
}
$dealRemark[] = sprintf('%d 套餐生效,上架房源(%d) 成功', $queueInfo['id'], $onlineHouseId);
}
$spreadHouseCount = Model_Combo_HouseRelation::updateHouseComboSpreadStateEx($queueInfo['broker_id'], $queueInfo['city_id'], $onlineHouseIds, Model_Combo_HouseRelation::ENUM_HOUSE_ONLINE, Bll_Combo_HouseRelation::SITE_TYPE_AJK);
$dealRemark[] = sprintf('%d [%s] 经纪人套餐生效，上架%d套房源[%s]。', $queueInfo['id'], date('Y-m-d H:i:s'), $spreadHouseCount, implode(',', $onlineHouseIds));
return static::buildReturn(self::PROCESS_STATUS_SUCCESS, $dealRemark);
}
public function handle_request_internal()
{
$brokerId = $this->_params['brokerId'];
$propId = $this->_params['propId'];
//好丑陋。。。。。。好无奈。。。。。。
//委托房源自动转发停用，为了app能够展示报错信息。。。
if (empty($propId)) {
$this->_params['apiDebug'] = 1;
return array('status' => Const_APIStatus::RETURN_CODE_ERROR, 'errcode' => '0000', 'message' => '委托房源自动转发功能已停用；若要发布请手动发布');
}
$brokerInfo = Model_Broker_AjkBrokerExtend::findWithBrokerId($brokerId);
if (!$brokerInfo) {
throw new Exception_BrokerNotFoundException('经纪人不存在', Const_APIStatus::E_BROKER_NOT_EXISTS);
}
if (!Bll_Broker_HzBroker::isComboBroker($brokerId)) {
throw new Exception_ISNotComboBrokerException('不是套餐经纪人。');
}
$cityId = $brokerInfo->cityId;
/** 套餐信息 */
$comboInfoList = Bll_Combo_Broker_BrokerComboInfo::getBrokerComboList($brokerId);
$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;
}
}
//没有二手房套餐
if (!isset($currentCombo)) {
return array('status' => Const_APIStatus::RETURN_CODE_OK, 'data' => array('status' => 0, 'statusMsg' => '尚未购买套餐，请购买套餐', 'currentComboInfo' => '尚未购买套餐'));
}
$currentComboName = $currentCombo['name'];
$currentComboUsed = 0;
$currentComboTotal = $currentCombo['salePropNum'] + $currentCombo['rentPropNum'];
//二手房套餐列表
$comboEsfList = Bll_Broker_Combo_ManageAjk::getComboSpreadHouseList($brokerId, $cityId);
$comboEsfPropIds = array_keys($comboEsfList);
//租房套餐列表
$comboZuFangList = Bll_Combo_HouseRelation::getHouseRelations($brokerId, 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 : (!$currentCombo['openUp'] && !$currentCombo['salePropNum'] ? 0 : 1);
if (in_array($propId, array_merge($comboEsfPropIds, $comboZuFangPropIds))) {
$status = 2;
$statusMsg = '套餐推广中';
} else {
$status = 1;
$statusMsg = '好房源，不推广就浪费了～';
}
//房源今日点击 房源总点击
$houseTodayClickInfo = Bll_House_EsfHouse::getHouseTodayComboClick($propId);
$todayClicks = $houseTodayClickInfo[$propId];
//房源总点击
$houseClickInfo = Bll_House_EsfHouse::getComboHouseAccumulateClickByPropIds($brokerId, $propId, $cityId);
$totalClicks = $todayClicks + $houseClickInfo[$propId];
$currentComboInfo = isset($currentCombo) ? $currentComboName . " （{$currentComboUsed}/{$currentComboTotal}）" : '尚未购买套餐';
return array('status' => Const_APIStatus::RETURN_CODE_OK, 'data' => array('todayClicks' => $todayClicks, 'totalClicks' => $totalClicks, 'status' => $status, 'statusMsg' => $statusMsg, 'canSpread' => $canSpread, 'currentComboInfo' => $currentComboInfo));
}
/**
* 502 经纪人套餐生效
*
* @param $queueInfo
* @return array
*/
public static function comboEffect($params)
{
$allReturn = array();
$brokerCombo = Bll_Combo_Broker_BrokerComboInfo::getBrokerCurrentCombo($params['broker_id'], Bll_Combo_Broker_BrokerComboInfo::SITE_TYPE_JP);
$expiredHouseRelationList = Bll_Combo_HouseRelation::getHouseRelations($params['broker_id'], Bll_Combo_HouseRelation::SITE_TYPE_JP, Model_Combo_HouseRelation::ENUM_COMBO_EXPIRE);
//经纪人当前在线房源，按照update_time asc排序
$brokerOnlineProps = Model_Combo_HouseRelation::data_access('jp')->filter('brokerId', $params['broker_id'])->filter_by_op('state', '>=', 101)->filter_by_op('state', '<=', 199)->sort('updateTime', 'asc')->find_all();
/** 当前没有生效的套餐，下掉所有的房子 */
if (empty($brokerCombo)) {
$allReturn[] = sprintf('%d 经纪人当前[%s]没有生效的套餐', $params['id'], date('Y-m-d H:i:s'));
}
if (empty($expiredHouseRelationList)) {
$allReturn[] = sprintf('%d [%s] 没有获取到经纪人因套餐到期而下架的房源。', $params['id'], date('Y-m-d H:i:s'));
}
if (empty($brokerCombo) && !empty($brokerOnlineProps)) {
$allReturn[] = sprintf('%d [%s] 经纪人无套餐，但是有在线房源，需要下线房源。', $params['id'], date('Y-m-d H:i:s'));
foreach ($brokerOnlineProps as $key => $prop) {
if ($key < count($brokerOnlineProps) - $brokerCombo['jpPropNum']) {
//房源下线 更新数据 关系表状态 state=到期
$prop->state = Model_Combo_HouseRelation::ENUM_COMBO_EXPIRE;
$prop->save();
//写入下线日志
$params['pro_id'] = $prop->houseId;
$data = Bll_JpPropBll::build_prop_log($params, 21, "房源取消套餐推广", $params['broker_id']);
Model_Log_HouseLogNew::create($data, date('Ymd'))->save();
$allReturn[] = "套餐到期，房源" . $params['pro_id'] . "取消套餐推广日志写入成功";
}
}
return Bll_JpPropBll::build_return(1, $allReturn);
}
if (count($brokerOnlineProps) > $brokerCombo['jpPropNum']) {
//下架多出来的房源
foreach ($brokerOnlineProps as $key => $prop) {
if ($key < count($brokerOnlineProps) - $brokerCombo['jpPropNum']) {
//房源下线 更新数据 关系表状态 state=到期
$prop->state = Model_Combo_HouseRelation::ENUM_COMBO_EXPIRE;
$prop->save();
//写入下线日志
$params['pro_id'] = $prop->houseId;
$data = Bll_JpPropBll::build_prop_log($params, 21, "房源取消套餐推广", $params['broker_id']);
Model_Log_HouseLogNew::create($data, date('Ymd'))->save();
$allReturn[] = "套餐转出，房源" . $params['pro_id'] . "取消套餐推广日志写入成功";
}
}
} elseif (count($brokerOnlineProps) < $brokerCombo['jpPropNum']) {
//上架房源 获取经纪人自动上架的房源,state=到期 按照update_time desc 排序
$brokerAutoProp = Model_Combo_HouseRelation::data_access('jp')->filter('brokerId', $params['broker_id'])->filter('state', Model_Combo_HouseRelation::ENUM_COMBO_EXPIRE)->sort('updateTime')->find_all();
if (!empty($brokerAutoProp)) {
foreach ($brokerAutoProp as $key => $prop) {
if ($key < $brokerCombo['jpPropNum'] - count($brokerOnlineProps)) {
//房源信息验证
$check = self::propCheck($prop->houseId, $prop->brokerId);
if (!$check['flg']) {
$allReturn[] = "房源" . $prop->houseId . "无法上线," . $check['data'];
continue;
}
//房源上线 更新数据 关系表状态 state=上线
$prop->state = Model_Combo_HouseRelation::ENUM_HOUSE_ONLINE;
$prop->save();
//写入上线日志
$params['pro_id'] = $prop->houseId;
$data = Bll_JpPropBll::build_prop_log($params, 20, "房源开始套餐推广", $params['broker_id']);
Model_Log_HouseLogNew::create($data, date('Ymd'))->save();
$allReturn[] = "房源" . $params['pro_id'] . "开始套餐推广日志写入成功";
}
}
}
}
return Bll_JpPropBll::build_return(1, $allReturn);
}
