public function handle_request()
{
$currentTableSplitSuffix = date('m');
$failedActionQueue = Model_Choice_ActionQueue::getFailedAbandonFee($this->queueId, Model_Choice_ActionQueue::ENUM_HAOZU, $this->tableSplitSuffix);
if (empty($failedActionQueue)) {
/** 如果不是同一个月的话，那么前一个月没有需要修复的数据就开始修复本月的数据 */
if (strcmp($currentTableSplitSuffix, $this->tableSplitSuffix) != 0) {
$this->saveCursor($currentTableSplitSuffix, 0);
}
return;
}
$this->log("开始修复: ID={$failedActionQueue['id']}\tBrokerId={$failedActionQueue['brokerId']}\tPlanId={$failedActionQueue['planId']}\tupdateRemark={$failedActionQueue['updateRemark']}");
$ajkBrokerExtend = Model_Broker_AjkBrokerExtend::getDataByBrokerId($failedActionQueue['brokerId']);
/** TODO 添加获取二手房经纪人信息为空日志 */
if (empty($ajkBrokerExtend)) {
$this->log(sprintf(' 获取经纪人(%d)的UserId失败(%d)。', $failedActionQueue['brokerId'], $failedActionQueue['id']));
$this->saveCursor($this->tableSplitSuffix, $failedActionQueue['id']);
return;
}
$planExtend = Dao_Broker_HzPlan::get_bid_sn($failedActionQueue['planId']);
/** TODO 添加获取SN 失败日志 */
if (empty($planExtend)) {
$this->log(sprintf(' 获取计划(%d)的SN失败(%d)。', $failedActionQueue['planId'], $failedActionQueue['id']));
$this->saveCursor($this->tableSplitSuffix, $failedActionQueue['id']);
return;
}
// $planInfo = Dao_Broker_HzPlan::get_plan($failedActionQueue['planId']);
$planInfo = Model_Plan_HzPlanBasic::get_plan_by_id($failedActionQueue['planId']);
/** TODO 添加获取计划信息失败日志*/
if (empty($planInfo)) {
$this->log(sprintf(' 获取计划(%d)的信息失败(%d)。', $failedActionQueue['planId'], $failedActionQueue['id']));
$this->saveCursor($this->tableSplitSuffix, $failedActionQueue['id']);
return;
}
//精选结算
$amount = $planInfo['total_consume'];
$note = '%E8%A7%A3%E5%86%BB';
$this->log(" 传递的参数：UserId={$ajkBrokerExtend['userId']}\tamount={$amount}\tplanId={$failedActionQueue['planId']}\tSN={$planExtend['sn']}");
$unlockSuccess = Bll_PayAccount::cancel_frozen($ajkBrokerExtend['userId'], $amount, $failedActionQueue['planId'], Const_PaymentApp::HZ_CHOICE, $planExtend['sn'], $note, true);
if ($unlockSuccess === true) {
$this->log(' 解冻成功。');
$this->saveCursor($this->tableSplitSuffix, $failedActionQueue['id']);
$repairRemark = $failedActionQueue['updateRemark'] . ', 解冻修复成功';
/** 更新队列状态为处理成功 */
Model_Choice_ActionQueue::setBidQueenStatusById($this->tableSplitSuffix, $failedActionQueue['id'], Model_Choice_ActionQueue::ENUM_SUCCESS, $repairRemark);
return;
}
$this->log(' 解冻失败。');
}
/**
* 修复竞价计划没有解冻
*/
public function repairPlanDeduct()
{
$planIds = array(823960, 829941, 832069, 832072, 832092, 832094, 836322, 836323, 839239, 839247);
$note = urlencode('解冻');
foreach ($planIds as $planId) {
$this->log(sprintf('开始修复计划%d.....', $planId));
$planInfo = Model_Plan_HzPlanBasic::get_plan_by_id($planId);
$hzBrokerId = $planInfo['user_id'];
$userId = Bll_HzBroker::get_userid_by_hzbrokerid($hzBrokerId);
$planExtend = Dao_Broker_HzPlan::get_bid_sn($planId);
$amount = $planInfo['total_consume'];
$this->log("传递的参数：UserId={$userId}\tamount={$amount}\tplanId={$planId}\tSN={$planExtend['sn']}");
$charge_sn = Bll_PayAccount::cancel_frozen($userId, $amount, $planId, Const_PaymentApp::HZ_BID, $planExtend['sn'], $note, true);
if ($charge_sn['data']['status'] === 'ok') {
$this->log('修复成功。');
} else {
$this->log('修复失败。');
}
}
}
/**
* 租房精选房源取消推广
* 1. 维护计划状态
* 2. 通知solr上下
*/
public static function choicePropOutBid($broker_id, $proid)
{
$flag_array = array('status' => 0, 'msg' => '');
//获取精选 房源、计划关系表信息（promotion_prop_planning）
$planning = Dao_Broker_HzPlan::get_prop_all_planning($proid, Const_HzPlan::BID_TYPE);
if (empty($planning)) {
$flag_array['msg'] = Const_HzErrorInfo::PROPFIXNULL;
return $flag_array;
}
//根据计划查询精选计划的信息
$plan_info = Dao_Broker_HzPlan::get_plan($planning[0]['plan_id']);
if (empty($plan_info)) {
$flag_array['msg'] = Const_HzErrorInfo::NULLPLAN;
return $flag_array;
}
//判断计划是否为该经纪人的
if ($plan_info['user_id'] != $broker_id) {
$flag_array['msg'] = Const_HzErrorInfo::PLANINFOERROR;
return $flag_array;
}
//获取精选计划的冻结号
$sn = Dao_Broker_HzPlan::get_bid_sn($plan_info['id']);
$sn = $sn['sn'];
if (empty($sn)) {
$flag_array['msg'] = Const_HzErrorInfo::PROPERROR;
return $flag_array;
}
//获取精选花费
// $amount = $plan_info['total_consume'];
$amount = $plan_info['amount'] - $plan_info['total_consume'];
$note = urlencode('推广房源' . $proid);
$user_id = Bll_HzBroker::get_userid_by_hzbrokerid($broker_id);
/** 精选结算 调用3次 */
$charge_sn = false;
$unfreezeOrderData = array('userId' => $user_id, 'proId' => $proid, 'serialNumber' => $sn, 'planId' => $plan_info['id'], 'amount' => $amount);
$unfreezeOrder = Bll_Ppc_BidUnfreeze::createHzOrder($unfreezeOrderData);
for ($i = 0; $i < 3 && !$charge_sn; $i++) {
$charge_sn = Bll_PayAccount::cancel_frozen($user_id, $amount, $proid, Const_PaymentApp::HZ_CHOICE, $sn, $note, true);
}
if (!$charge_sn) {
$unfreezeOrder->fail();
$flag_array['msg'] = Const_HzErrorInfo::CHARGEFAIL;
// 此处不需要block,由job保证此处解冻正确
//return $flag_array;
} else {
$unfreezeOrder->complete();
}
//查询房源信息
$proInfo = Model_House_HzProp::get_prop_info_by_prop_id($proid);
//房源违规的、删除的不能更新房源状态
$prop_status = $proInfo['contentBasic']['status'];
// 兼容新套餐
$ajkBrokerId = Model_Broker_HzMapping::get_ajk_broker_id($broker_id);
if (Bll_Broker_HzBroker::isComboBroker($ajkBrokerId)) {
/** 判断房源是否在套餐推广中 */
if (!Bll_Combo_HouseRelation::getOnlineRelationByHouseId($proid, Bll_Combo_HouseRelation::SITE_TYPE_HZ)) {
$prop_status = Const_HzStatus::OUTLINE;
}
} else {
//查询房源是否在计划里面
$fix_planning = Dao_Broker_HzPlan::get_prop_planning($proid, Const_HzPlan::SPREAD_TYPE);
if (!in_array($proInfo['contentBasic']['status'], array(Const_HzStatus::VERIFY, Const_HzStatus::REMOVE, Const_HzStatus::EXPIRED))) {
if (empty($fix_planning)) {
//房源不在计划里面
$prop_status = Const_HzStatus::OUTLINE;
//房源不在计划里面
} elseif ($fix_planning[0]['is_valid'] == Const_HzPlan::SPREAD) {
$prop_status = Const_HzStatus::ONLINE;
//定价正在推广
} elseif ($fix_planning[0]['is_valid'] == Const_HzPlan::UPPERLIMIT) {
//定价非推广（没钱状态）
$prop_status = Const_HzStatus::NOCASH;
//房源没钱
} else {
$prop_status = Const_HzStatus::MANUALLY;
//房源状态更新为9手动停止
}
}
}
//维护精选关联关系
if (!Dao_Broker_HzPlan::update_planning($planning[0]['id'], Const_HzPlan::MENUOVER)) {
$flag_array['msg'] = Const_HzErrorInfo::UPDATAPLANNINGFAIL;
return $flag_array;
}
//维护计划状态
if (!Dao_Broker_HzPlan::update_plan_status($plan_info['id'], Const_HzPlan::MENUOVER)) {
$flag_array['msg'] = Const_HzErrorInfo::UPDATAPLANFAIL;
return $flag_array;
}
//通知solr
if ($prop_status == Const_HzStatus::ONLINE) {
//定价正在推广
Dao_Broker_HzProp::into_prop_lucene($proid, $planning[0]['city_id'], 1);
//竞价下，定价还在线。则更新上
} else {
Dao_Broker_HzProp::into_prop_lucene($proid, $planning[0]['city_id'], 2);
//下线房源
}
$flag_array['status'] = 1;
return $flag_array;
}
/**
* 动作 7
* 房源移出定价计划，导致竞价停止（房源日志发起）
* 结算
* 更新计划为停止状态
* 通知solr下（停止的房源）
* 记录房源日志（停止的房源）
* 根据停止的房源，取出坑位里面的推广、排队房源
* 计算排名
* 更新计划状态（坑位里面的异动房源更新状态）
* 通知solr（坑位里面的异动房源通知solr）
* 记房源日志（坑位里面的房源异动日志）
* @param array $params
* @return array|bool
*/
public static function removeFixPlanForBid($params = array())
{
self::$qInfo = $params;
// 检查参数
$checkParams = self::checkParams($params);
if (!$checkParams['status']) {
return $checkParams;
}
// 获取信息,组装$params
$joinParams = self::joinParams($params);
if (!$joinParams['status']) {
return $joinParams;
}
$all_return = array();
//判断竞价计划是否删除
if ($params['flag'] != 1) {
return Bll_HzPropBll::build_return(0, '无效的竞价计划' . json_encode($params));
}
//非推广的计划
if ($params['status'] != 1) {
return Bll_HzPropBll::build_return(0, '非推广的竞价计划' . json_encode($params));
}
// 非精选判断
if ($params['bidVersion'] == 2) {
return Bll_HzPropBll::build_return(0, '房源为精选' . json_encode($params));
}
//获取竞价计划的冻结号
$sn = Dao_Broker_HzPlan::get_bid_sn($params['planId']);
$sn = $sn['sn'];
if (empty($sn)) {
return Bll_HzPropBll::build_return(0, Const_HzErrorInfo::PROPERROR . json_encode($params));
}
//获取竞价花费
$amount = $params['totalConsume'];
$note = urlencode('推广房源' . $params['proId']);
$user_id = Bll_HzBroker::get_userid_by_hzbrokerid($params['']);
/** 竞价结算 调用3次 */
$charge_sn = false;
$unfreezeOrderData = array('userId' => $user_id, 'proId' => $params['proId'], 'serialNumber' => $sn, 'planId' => $params['planId'], 'amount' => $amount);
$unfreezeOrder = Bll_Ppc_BidUnfreeze::createHzOrder($unfreezeOrderData);
for ($i = 0; $i < 3 && !$charge_sn; $i++) {
$charge_sn = Bll_PayAccount::cancel_frozen($user_id, $amount, '', Const_PaymentApp::HZ_BID, $sn, $note, true);
}
if (!$charge_sn) {
$unfreezeOrder->fail();
$flag_array['msg'] = Const_HzErrorInfo::CHARGEFAIL;
// 此处不需要block,由job保证此处解冻正确
//return $flag_array;
} else {
$unfreezeOrder->complete();
}
//维护竞价关联关系
if (!Dao_Broker_HzPlan::update_planning($params['planId'], Const_HzPlan::DELETE)) {
$flag_array['msg'] = '维护竞价关联关系,数据更新失败.';
return $flag_array;
}
//维护计划状态
if (!Dao_Broker_HzPlan::update_plan_status($params['planId'], Const_HzPlan::DELETE)) {
$flag_array['msg'] = '维护计划状态,数据更新失败.';
return $flag_array;
}
// 更新计划的flag为删除状态
if (!Dao_Broker_HzPlan::update_history_bids($params['planId'])) {
$flag_array['msg'] = '更新计划的flag为删除状态,数据更新失败.';
return $flag_array;
}
//记录房源日志
$data = array('houseId' => $params['proId'], 'planId' => $params['planId'], 'brokerId' => $params['ajkBrokerId'], 'cityId' => $params['cityId'], 'type' => 15, 'changeType' => 407, 'remark' => '房源' . $params['proId'] . '移出定价计划。竞价' . $params['planId'] . '(id)取消竞价推广。', 'addDate' => date('Y-m-d H:i:s'), 'operatorId' => $params['operationId'], 'siteType' => 2);
if (!Model_Log_HouseLogNew::create($data, date('Ymd'))->save()) {
return Bll_HzPropBll::build_return(0, array("日志写入失败"));
}
//计算房源状态
Bll_HzPropBll::bulidHzProStatu($params['proId']);
return Bll_HzPropBll::build_return(1, array('竞价' . $params['planId'] . '(id)取消竞价推广。'));
}
public function dealTask($task)
{
// 处理解冻
$charge_sn = false;
$failNum = 0;
$note = urlencode('推广房源' . $task['proId']);
for ($i = 0; $i < $this->tryNum; $i++) {
$charge_sn = Bll_PayAccount::cancel_frozen($task['userId'], $task['amount'], $task['proId'], $task['appName'], $task['serialNumber'], $note, true, $task['requestId']);
printf('队列id %s, 房源id %s 尝试第%d次解冻， 结果是: %s' . PHP_EOL, $task['id'], $task['proId'], $i + 1, $charge_sn ? '成功' : '失败');
if ($charge_sn) {
break;
}
$failNum++;
}
if ($failNum > 0) {
Model_Payment_ABidUnfreeze::updateRelation(array('id' => $task['id']), array('failNum' => $task['failNum'] + $failNum));
}
// 尝试多次还是失败
if (!$charge_sn) {
$this->failInfos[] = sprintf('[%s] 队列id: %d 房子id: %d 尝试解冻%d次后还是失败!' . PHP_EOL, date('Y-m-d H:i:s'), $task['id'], $task['proId'], $failNum);
} else {
// 更新队列处理成功
Model_Payment_ABidUnfreeze::updateRelation(array('id' => $task['id']), array('status' => 1));
$this->repairSpreadPlanState($task);
}
return true;
}
