/**
* 二手房精选推广设置页面
*
* @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);
}
