/** * 二手房精选推广设置页面 * * @param $brokerId * @param $cityId * @param $houseId * @param $userId * @param array $params * @return array */ public static function esf_setting_post($brokerId, $cityId, $houseId, $userId, $params = array()) { $result = array(); //获取精选推广预算 $brokerInfo = Bll_BrokerBaseBll::get_instance()->get_broker_info($brokerId); $brokerCompanyId = $brokerInfo['BaseInfo']['COMPANYID']; $choiceSet = APF::get_instance()->get_config('choice_set'); if (isset($choiceSet[$brokerCompanyId]) && !empty($choiceSet[$brokerCompanyId])) { $min_budget = $choiceSet[$brokerCompanyId]['ajk']['ESF_CHOICE_MIN_BUDGET']; $max_budget = $choiceSet[$brokerCompanyId]['ajk']['ESF_CHOICE_MAX_BUDGET']; } else { $min_budget = $choiceSet['default']['ajk']['ESF_CHOICE_MIN_BUDGET']; $max_budget = $choiceSet['default']['ajk']['ESF_CHOICE_MAX_BUDGET']; } //判断预算的合法性 if ($params['budget'] < $min_budget || $params['budget'] > $max_budget) { return array('err_no' => self::BID_FAIL_OTHER, 'err_msg' => '预算价格范围非法'); } //获取房源信息 $pageAttribute['housesInfo'] = Bll_House_EsfHouse::getHouseBaseInfo($houseId, $cityId); if (empty($pageAttribute['housesInfo'])) { return array('err_no' => self::BID_FAIL_OTHER, 'err_msg' => '房源不存在'); } $houseInfo = $pageAttribute['housesInfo'][0]; if ($houseInfo->userId != $userId) { return array('err_no' => self::BID_FAIL_QUALITY_OR_NEW, 'err_msg' => '房源不属于当前操作人'); } if ($houseInfo->isVisible != 1) { return array('err_no' => self::BID_FAIL_QUALITY_OR_NEW, 'err_msg' => '房源是违规房源,不可以参加精选房源推广'); } if ($houseInfo->isHighQulity == 0) { return array('err_no' => self::BID_FAIL_QUALITY_OR_NEW, 'err_msg' => '多图、新发15天房源才能参与精选推广'); } if (date('Ymd', strtotime('-15 days')) > date('Ymd', $houseInfo->postDate)) { return array('err_no' => self::BID_FAIL_QUALITY_OR_NEW, 'err_msg' => '只能精选推广15天内发布的房源'); } self::setChoiceNum($cityId); //判断当前经纪人已经精选推广的房源数 if (isset($params['act']) && isset($params['rebid'])) { if (self::checkEsfBidChoiceFull($brokerId, $cityId, 1)) { return array('err_no' => self::BID_FAIL_OTHER, 'err_msg' => '最多精选推广' . self::$all_esf_plan_num . '套房源'); } } else { if (self::checkEsfBidChoiceFull($brokerId, $cityId)) { return array('err_no' => self::BID_FAIL_OTHER, 'err_msg' => '最多精选推广' . self::$all_esf_plan_num . '套房源'); } } /** 判断是否是精选开放城市 */ if (!Bll_City::isChoiceIndependentCity($cityId, Const_Site::ANJUKE)) { /** 判断是在套餐推广中 */ $houseState = Bll_Combo_HouseRelation::getOnlineRelationByHouseId($houseId, Bll_Combo_HouseRelation::SITE_TYPE_AJK); if (empty($houseState)) { return array('err_no' => self::BID_FAIL_QUALITY_OR_NEW, 'err_msg' => '该房源不在推广中'); } } //判断是否已在竞价计划中 $planInfo = Model_Plan_EsfAjkPropSpread::getChoicePlanInfoByHouseid($houseId); if (!empty($planInfo) && !isset($params['rebid'])) { return array('err_no' => self::BID_FAIL_OTHER, 'err_msg' => '房源已经精选'); } /** 防并发 */ if (false === self::rejectSameRequest(Bll_Plan_Bid_Choice::SITE_AJK, $brokerId, $houseId)) { return array('err_no' => self::BID_FAIL_OTHER, 'err_msg' => '系统繁忙(code:-906)'); } //重新推广,判断结算状态 if (isset($params['act']) && isset($params['rebid'])) { //获取计划信息 if (!isset($planInfo)) { $planInfo = Model_Plan_EsfAjkPropSpread::getChoicePlanInfoByHouseid($houseId); } if ($planInfo->status == Model_Plan_EsfAjkPropSpread::ONLINE || $planInfo->status == Model_Plan_EsfAjkPropSpread::ONQUEUE) { return array('err_no' => self::BID_FAIL_OTHER, 'err_msg' => '房源已经精选'); } if ($planInfo->tradestatus != Model_Plan_EsfAjkPropSpread::COMPLETETTRADESTATU) { return array('err_no' => self::BID_FAIL_OTHER, 'err_msg' => '房源还未结算完成'); } } $housePrice = intval($houseInfo->proPrice * 10000); $priceIntervalInfo = Model_House_EsfPrice::get_price($cityId, $housePrice); if (empty($priceIntervalInfo)) { return array('err_no' => self::BID_FAIL_QUALITY_OR_NEW, 'err_msg' => '房源价格未知'); } $priceId = $priceIntervalInfo['id']; $minPrice = $priceIntervalInfo['minPrice']; $maxPrice = $priceIntervalInfo['maxPrice']; /** 获取点击单价 最低预算不能小于点击单价 */ try { /** * @var Bll_Service_Client_HttpResponse $clickPrice */ for ($i = 0; $i < 3; $i++) { $clickPrice = Bll_Service_Choice::ajkClickPrice(array('brokerId' => $brokerId, 'cityId' => $cityId, 'price' => $housePrice, 'commId' => $houseInfo->commId)); if ($clickPrice->isSucceeded()) { break; } } if (!$clickPrice->isSucceeded() || $clickPrice['status'] == 'error') { return array('err_no' => self::BID_FAIL_OTHER, 'err_msg' => '服务器繁忙,请重试(code: -' . __LINE__ . ')'); } if ($params['budget'] * 100 < $clickPrice['realTradeAmount']) { return array('err_no' => self::BID_FAIL_OTHER, 'err_msg' => '推广预算不能小于点击单价'); } if (isset($params['fromApi']) && $params['fromApi']) { /** 来自API 的精选创建计划 */ $params['price'] = $clickPrice['realTradeAmount'] / 100; } else { /** 点击单价不能小于当前系统内的单价 防止恶意操作 */ if ($params['price'] < $clickPrice['realTradeAmount'] / 100) { return array('err_no' => self::BID_FAIL_OTHER, 'err_msg' => '点击单价错误'); } } } catch (Exception $e) { return array('err_no' => self::BID_FAIL_OTHER, 'err_msg' => '服务器繁忙,请重试(code: -' . __LINE__ . ')'); } //查询坑情况 $bucketInfo = Model_Choice_EsfBidBucket::get_bucket_info($houseInfo->commId, $priceId); if (empty($bucketInfo)) { if (Model_Choice_EsfBidBucket::init_bucket_info($houseInfo->commId, $priceId, $cityId)) { $bucketInfo = array('communityId' => $houseInfo->commId, 'priceId' => $priceId, 'totalNum' => Model_Choice_EsfBidBucket::TOTALNUM, 'usedNum' => 0, 'maxOnlineNum' => Model_Choice_EsfBidBucket::MAXONLINENUM); } else { return array('err_no' => self::BID_FAIL_OTHER, 'err_msg' => '服务器繁忙,请重试(code: -' . __LINE__ . ')'); } } //坑位表维护 if ($params['show'] == 1) { //预判断坑位 if ($bucketInfo['usedNum'] >= $bucketInfo['maxOnlineNum']) { return array('err_no' => self::BID_SHOW_FAIL, 'err_msg' => '推广位置已满,请重新推广!'); } //按照最大在线数目更新坑位表 if (!Model_Choice_EsfBidBucket::increment_used_num($houseInfo->commId, $priceId, 1)) { return array('err_no' => self::BID_FAIL_OTHER, 'err_msg' => '服务器繁忙,请重试(code: -' . __LINE__ . ')'); } } else { //预判断坑位 if ($bucketInfo['usedNum'] >= $bucketInfo['totalNum']) { return array('err_no' => self::BID_WAIT_FAIL, 'err_msg' => '排队位置已满,请重新推广!'); } //按照最大坑位数目更新 if (!Model_Choice_EsfBidBucket::increment_used_num($houseInfo->commId, $priceId, 0)) { return array('err_no' => self::BID_FAIL_OTHER, 'err_msg' => '服务器繁忙,请重试(code: -' . __LINE__ . ')'); } } //获取reuqestid $year = date('Y'); $bll = new Bll_Plan_BidFreezeOrderNum($year); $requestId = $bll->getRequestId(Bll_Plan_BidFreezeOrderNum::ESF, $userId, $year, 0, $houseId); //冻结金额 $amount = $params['budget'] * 100; $note = sprintf("二手房精选房源冻结,propId: %d", $houseId); if (($freezeResult = self::bid_freeze($brokerId, $amount, $requestId, $note, Const_PaymentApp::AJK_CHOICE)) === false) { return array('err_no' => self::BID_FAIL_OTHER, 'err_msg' => '服务器繁忙,请重试(code: -' . __LINE__ . ')'); } if (!$freezeResult->isSucceeded()) { return array('err_no' => self::BID_FAIL_OTHER, 'err_msg' => '服务器繁忙,请重试(code: -' . __LINE__ . ')'); } if ($freezeResult['status'] == 'error') { return array('err_no' => self::BID_FAIL_OTHER, 'err_msg' => '冻结失败!'); } $snNum = $freezeResult['data']['sn']; //重新推广,将原来的推广计划置为删除状态 if (isset($params['act']) && $params['rebid']) { $planInfo->status = Model_Plan_EsfAjkPropSpread::DELETE; if (!$planInfo->save()) { return array('err_no' => self::BID_FAIL_OTHER, 'err_msg' => '服务器繁忙,请重试(code: -' . __LINE__ . ')'); } } //新建计划 $time = time(); $offer = $params['price'] * 100; $stopTime = $time + self::ESF_AUTO_STOP_TIME; $endTime = time() + Model_Plan_EsfAjkPropSpread::CHOICELASTINGTIME; $arrAddInfo['serialnumber'] = $snNum; $arrAddInfo['propId'] = $houseId; $arrAddInfo['cityId'] = $cityId; $arrAddInfo['commId'] = $houseInfo->commId; $arrAddInfo['brokerId'] = $brokerId; $arrAddInfo['userId'] = $userId; $arrAddInfo['budget'] = $amount; $arrAddInfo['balance'] = $amount; $arrAddInfo['spreadstartdate'] = $time; $arrAddInfo['spreadenddate'] = $endTime; $arrAddInfo['bigprice'] = $maxPrice; $arrAddInfo['smallprice'] = $minPrice; $arrAddInfo['propriceint'] = $housePrice; $arrAddInfo['status'] = Model_Plan_EsfAjkPropSpread::ONQUEUE; $arrAddInfo['isreserve'] = Model_Plan_EsfAjkPropSpread::RESERVE; $arrAddInfo['bidVersion'] = Model_Plan_EsfAjkPropSpread::CHOICEVERSION; $arrAddInfo['areacode'] = $houseInfo->areaCode; $arrAddInfo['stoptime'] = $stopTime; $arrAddInfo['createtime'] = $time; $arrAddInfo['offer'] = $offer; $arrAddInfo['model'] = Model_Plan_EsfAjkPropSpread::COMM_CHOICE; //排名系数,请直接绕过 +_+ $hpratioABll = new Bll_Plan_Bid_EsfHpratioA(); $arrAddInfo['qulityScore'] = $hpratioABll->getHouseMass($houseId, $brokerId, $cityId, $houseInfo->commId, $houseInfo->hasRoomPic, $houseInfo->isHighQulity, $houseInfo->postDate, $houseInfo->unitPrice); $commScore = round($hpratioABll->getCommScore($houseInfo->commId), 5); $arrAddInfo['commScore'] = $commScore; $userActionScore = $hpratioABll->getUserActionScore($houseId, $cityId); $arrAddInfo['behaviorScore'] = $userActionScore; $arrAddInfo['hpratioA'] = $hpratioABll->getHpraio($offer, $arrAddInfo['qulityScore'], $userActionScore); $hpratioNorm = $hpratioABll->getPpcNormHpratio($arrAddInfo['hpratioA'], $houseInfo->commId, false, $minPrice, $maxPrice, $houseInfo->areaCode); $arrAddInfo['commsHpratioA'] = round($commScore * $hpratioNorm, 5); if (($planId = Model_Plan_EsfAjkPropSpread::insertLayer($arrAddInfo)) === false) { return array('err_no' => self::BID_FAIL_OTHER, 'err_msg' => '服务器繁忙,请重试(code: -' . __LINE__ . ')'); } //新精选队列插入记录 if (!Bll_Plan_Bid_EsfChoiceQueue::insert($brokerId, $planId, Model_Choice_ActionQueue::ENUM_BEGIN_BY_HAND, date('m'), $brokerId, '经纪人手动开始推广', APF::get_instance()->get_request()->get_client_ip(), $houseId)) { return array('err_no' => self::BID_FAIL_OTHER, 'err_msg' => '服务器繁忙,请重试(code: -' . __LINE__ . ')'); } //插入自动停止队列 $stopType = Model_Plan_EsfAjkPropspreadQueue::AUTOSTOP; Model_Plan_EsfAjkPropspreadQueue::insertOne($planId, $stopTime, $stopType); //记录log表 $remark = sprintf("PROP_ID:null=>%d;CITY_ID:null=>%d;COMM_ID:null=>%d;BROKER_ID:null=>%d;USER_ID:null=>%d;BUDGET:null=>%d;SPREADSTARTDATE:null=>%d;SPREADENDDATE:null=>%d;STATUS:null=>%d;ISRESERVE:null=>%d;SERIALNUMBER:null=>%d;TRADETYPE:0=>1;BALANCE:0=>%d;PROPRICEINT:0=>%d;BIGPRICE:0=>%d;SMALLPRICE:0=>%d", $houseId, $cityId, $houseInfo->commId, $brokerId, $userId, $amount, $time, $endTime, Model_Plan_EsfAjkPropSpread::ONQUEUE, Model_Plan_EsfAjkPropSpread::RESERVE, $snNum, $amount, $housePrice, $maxPrice, $minPrice); Model_Plan_LogAjkPropspread::addNewLog($planId, $brokerId, Model_Plan_LogAjkPropspread::ADD, $remark); //更新reuqest id完成 if (!$bll->updateRequestComplete($requestId, $snNum, $planId)) { return array('err_no' => self::BID_FAIL_OTHER, 'err_msg' => '服务器繁忙,请重试(code: -' . __LINE__ . ')'); } if ($params['show'] == 1) { return array('err_no' => self::BID_SHOW_SUCCESS); } else { $rank = Bll_Plan_Bid_Choice::getEsfOnQueueNum($planId, $houseInfo->commId, $minPrice, $maxPrice); return array('err_no' => self::BID_WAIT_SUCCESS, 'rank' => $rank); } }
/** * 停止推广的对应操作 * * @return array */ public function stopPlanAciton($brokerId, $planId, $commId, $priceId, APF_DB_DataObject $planInfo) { //坑位减1 Model_Choice_EsfBidBucket::decrement_used_num($commId, $priceId); //更新状态 $oldStatus = $planInfo->status; $planInfo->status = Model_Plan_EsfAjkPropSpread::HANDELSTOP; if (!$planInfo->save()) { $this->error(self::SYSTEM_BUSY_ERROR, self::SYSTEM_BUSY_ERROR_MSG); } //放入队列 $ip = APF::get_instance()->get_request()->get_client_ip(); if (!Bll_Plan_Bid_EsfChoiceQueue::insert($brokerId, $planId, Model_Choice_ActionQueue::ENUM_STOP_BY_HAND, date('m'), $brokerId, '经纪人手动停止推广', $ip)) { $this->error(self::SYSTEM_BUSY_ERROR, self::SYSTEM_BUSY_ERROR_MSG); } //记录日志 $remark = sprintf("STATUS:%d=>%d", $oldStatus, Model_Plan_EsfAjkPropSpread::HANDELSTOP); Model_Plan_LogAjkPropspread::addNewLog($planId, $brokerId, Model_Plan_LogAjkPropspread::STOP, $remark); }
/** * 页面删除推广操作封装 * * @param $planId * @return array */ public static function delete_plan($planId, $brokerId) { $rstArr = array('status' => 'ok'); //获取计划信息 $planInfo = Model_Plan_EsfAjkPropSpread::data_access()->filter('id', $planId)->find_only(); if (empty($planInfo)) { return array('status' => 'fail', 'info' => 'empty plan'); } if ($planInfo->status == Model_Plan_EsfAjkPropSpread::ONLINE) { return array('status' => 'fail', 'info' => '计划正在推广中'); } if ($planInfo->status == Model_Plan_EsfAjkPropSpread::ONQUEUE) { return array('status' => 'fail', 'info' => '计划正在排队中'); } if ($planInfo->tradestatus != Model_Plan_EsfAjkPropSpread::COMPLETETTRADESTATU) { return array('status' => 'fail', 'info' => '计划正在结算中'); } if ($planInfo->status == Model_Plan_EsfAjkPropSpread::DELETE) { return array('status' => 'ok', 'info' => '计划已经被删除'); } if ($brokerId != $planInfo->brokerId) { return array('status' => 'fail', 'info' => 'invalid broker'); } if (Model_Plan_EsfAjkPropSpread::COMM_CHOICE != $planInfo->model) { return array('status' => 'fail', 'info' => 'invalid house'); } //验证choice城市 $cityId = $planInfo->cityId; if (!Bll_City::isChoiceCity($cityId)) { return array('status' => 'fail', 'info' => 'starttime not achieved '); } //更新状态 $oldStatus = $planInfo->status; $planInfo->status = Model_Plan_EsfAjkPropSpread::DELETE; if (!$planInfo->save()) { return array('status' => 'fail', 'info' => 'update plan status fail'); } //记录日志 $remark = sprintf("STATUS:%d=>%d", $oldStatus, Model_Plan_EsfAjkPropSpread::DELETE); Model_Plan_LogAjkPropspread::addNewLog($planId, $brokerId, Model_Plan_LogAjkPropspread::DEL, $remark); return $rstArr; }
/** * 房源推广变更日志生成 ppc_db.Hp_Pro_Change_Log_ * * <ol> * <li> * 当房源日志type为房源推广(5)时,对应推广变更日志action=1 * </li> * <li> * 当房源日志type为取消推广(6)时,对应推广变更日志action=2 * </li> * <li> * 当房源日志type为第二天推广(7)时,对应推广变更日志action=2 * </li> * <li> * 当房源日志type为取消推广(14)时,对应精选推广变更日志action=1 * </li> * <li> * 当房源日志type为取消推广(15)时,对应精选推广变更日志action=2 * </li> * <li> * 其他不处理 * </li> * </ol> * * @param array $records 定价上下架房源日志数据(二手房) */ public function proSpreadChangeLogCreateAjk($record) { if ($record['siteType'] != 1) { //记录处理日志 $this->setLog('改网站类型的数据暂不处理(定价推广变更日志) ' . __METHOD__); return true; } $type = $record['type']; $date = date('Ymd', strtotime($record['addDate'])); if ($type == 5) { $action = 1; $type = 1; } elseif ($type == 6) { $action = 2; $type = 1; } elseif ($type == 7) { $action = 2; $type = 1; } elseif ($type == 14) { $action = 1; $type = 2; } elseif ($type == 15) { $action = 2; $type = 2; } elseif ($type == 21) { $type = 3; $action = 2; } elseif ($type == 20) { $type = 3; $action = 1; } else { //记录处理日志 $this->setLog('不需要生成推广变更日志'); return true; } $dataObject = new Model_House_HpProChangeLog($date); //查询最近的日志 $ChangeLogInfo = $dataObject->getChangeLogByProId($record['houseId'], $date, $type); $Time = 0; //展示时间 if (!empty($ChangeLogInfo)) { switch ($ChangeLogInfo['Action']) { case 1: //上一条为推广 if ($action == 1) { //本次为推广 $Time = $ChangeLogInfo['Time']; } if ($action == 2) { //本次为取消推广 $Time = $ChangeLogInfo['Time'] + time() - strtotime($ChangeLogInfo['LogTime']); } break; case 2: //上一条为取消推广 if ($action == 1) { //本次为推广 if (empty($ChangeLogInfo['Time'])) { //上一条取消推广时间为0 $Time = strtotime($ChangeLogInfo['LogTime']) - strtotime(substr($ChangeLogInfo['LogTime'], 0, 10)); } else { $Time = $ChangeLogInfo['Time']; } } if ($action == 2) { //本次为取消推广 $Time = $ChangeLogInfo['Time']; } break; default: } } $dataObject->ProId = $record['houseId']; $dataObject->BrokerId = $record['brokerId']; $dataObject->Time = $Time; $dataObject->Action = $action; $dataObject->Type = $type; $dataObject->LogTime = date('Y-m-d H:i:s'); $dataObject->ActionId = 0; //触发动作id $dataObject->SpreadId = $record['planId'] ? $record['planId'] : 0; //计划id if (!$dataObject->save()) { //记录处理日志 $this->setLog('推广变更日志生成失败'); } else { //记录处理日志 $this->setLog('推广变更日志生成成功'); } //对接竞价房源日志老数据 if ($type == 2) { if ($action == 1) { $remark = 'STATUS:11=>1'; $bidAction = 1; } else { $remark = $record['changeType'] == 404 ? 'STATUS:1=>5' : 'STATUS:1=>3'; $bidAction = 4; } Model_Plan_LogAjkPropspread::addNewLog($record['planId'] ? $record['planId'] : 0, $record['brokerId'], $bidAction, $remark, -10); } return true; }
/** * 添加房源竞价推广日志 * * @param int $planId * @param int $brokerId * @param int $action * @param int $remark * @param int $operator */ public static function addHouseBidSpreadLog($planId, $brokerId, $action, $remark, $operator = 21181) { $actionMapping = APF::get_instance()->get_config('log_action_type', 'hp'); $action = strtoupper($action); $actionId = isset($actionMapping[$action]) ? $actionMapping[$action] : 0; Model_Plan_LogAjkPropspread::addNewLog($planId, $brokerId, $actionId, $remark, $operator); }