/**
* @param $task
* @return bool
*/
public function dealTask($task)
{
$brokerId = $task['brokerId'];
$amount = $task['amount'];
$siteType = Const_ShowcaseOrders::SALE_DB;
if ($task['siteType'] == 2) {
$siteType = Const_ShowcaseOrders::RENT_DB;
}
$requestId = Bll_Broker_ShowcaseAdConsumeQueue::getPaymentRequestId($task['id'], $this->currentYMD, $siteType);
//获取账户余额
$ajkBrokerData = Model_Broker_AjkBrokerExtend::getDataByBrokerId($brokerId);
$userId = !empty($ajkBrokerData) ? $ajkBrokerData->userId : 0;
$cityId = $ajkBrokerData->cityId;
$balance = Bll_Broker_ShowcaseOrders::getInstance()->getBrokerMoney($userId);
$balance = $balance * 100;
if ($balance < $amount) {
//余额不足,停止橱窗订单，更新订单操作日志.
$this->stopShowCase($task, $siteType, $cityId);
//TODO 更新扣费队列状态
$updateArr = array('status' => 1, 'requestId' => $requestId, 'remark' => json_encode(array('balance' => $balance, 'remark' => '余额不足')));
} else {
//余额足够,调用扣费API
$apiResult = Bll_Broker_ShowcaseConsumeQuery::getInstance()->callCosumeApi($userId, $requestId, $amount, $task['consumeDate'], $siteType);
//扣费成功
if ($apiResult['status'] === true) {
$updateArr = array('status' => 3, 'requestId' => $requestId, 'remark' => json_encode(array('balance' => $balance, 'apiData' => $apiResult['apiData'])));
} else {
$updateArr = array('status' => 2, 'requestId' => $requestId, 'remark' => json_encode(array('balance' => $balance, 'apiData' => $apiResult['apiData'])));
}
}
//更新扣费队列状态
Bll_Broker_ShowcaseAdConsumeQueue::updateConsumeInfo($updateArr, array('id' => $task['id']));
return true;
}
/**
* 通过java接口获取套餐列表
*
* @param $brokerId
* @return bool|mixed
*/
public function getComboListByJavaApi($brokerId)
{
$ajkBrokerData = Model_Broker_AjkBrokerExtend::getDataByBrokerId($brokerId);
$host = APF::get_instance()->get_config("JavaAPIHost");
$url = $host . "service-combo/rest/combo/order/myOrder/?json&userId={$ajkBrokerData->userId}";
$res = Util_Curl::service_curl($url);
return $res;
}
/**
* 获取userId
* @param $brokerId 二手房经纪人id
* @param $type
* @return int
*/
public static function getUserIdByBrokerId($brokerId, $type)
{
/*if($type == Const_ShowcaseOrders::SALE_DB){ // 二手房
$ajkBrokerData = Model_Broker_AjkBrokerExtend::getDataByBrokerId($brokerId);
}elseif($type == Const_ShowcaseOrders::RENT_DB){
$ajkBrokerId = self::getAjkBrokerByhzBrokerId($brokerId); // 租房
$ajkBrokerData = Model_Broker_AjkBrokerExtend::getDataByBrokerId($ajkBrokerId);
}else{
return 0;
}*/
$ajkBrokerData = Model_Broker_AjkBrokerExtend::getDataByBrokerId($brokerId);
return !empty($ajkBrokerData) ? $ajkBrokerData->userId : 0;
}
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 beforeHandlerRequest()
{
if (!$this->params['brokerId']) {
$this->outPut(0, '参数缺失');
}
// 获取经纪人信息
$brokerInfo = Model_Broker_AjkBrokerExtend::getDataByBrokerId($this->params['brokerId']);
$this->params['cityId'] = $brokerInfo->cityId;
$this->params['userId'] = $brokerInfo->userId;
/** 不是套餐城市就直接返回 */
if (!Bll_City::isComboCity($this->params['cityId'])) {
$this->outPut(0, '未开通套餐业务');
}
/** 不是套餐经纪人直接返回 */
if (!Bll_Broker_HzBroker::isComboBroker($this->params['brokerId'])) {
$this->outPut(0, '不是套餐经纪人');
}
}
public function handle_request_internal()
{
$brokerId = $this->_params['brokerId'];
$plans = Model_Plan_EsfFixedPlan::getValidPlan($brokerId);
$props = 0;
$result['status'] = 'ok';
if (!empty($plans)) {
$planId = $plans['id'];
$cityId = $plans['cityid'] ?: 0;
$relations = Model_Plan_AjkFixRelation::getRelationListByPlanId($planId, $cityId);
if (!empty($relations)) {
$propIds = array();
foreach ($relations as $row) {
$propIds[] = $row['proId'];
}
$houseInfo = Bll_House_EsfHouse::getHouseBaseInfo($propIds, $cityId);
$props = count($houseInfo);
}
$planBll = new DAO_My_Ppc_PlanOpe();
$clicks = $planBll->planTodayNewCost($planId);
$data['planId'] = $planId;
$data['todayClicks'] = $clicks['allclick'];
$data['todayConsume'] = Util_Formatter::formatTodayConsume($clicks['allamount']);
$data['todayConsumeUnit'] = '元';
$data['totalProps'] = $props;
//获取计划状态
$api_url = '/service-ppc/rest/ppc/getPpcPlan/' . $planId . '?resType=1';
$plan_info = Util_CallAPI::get_data_from_java_api($api_url);
$data['planStatus'] = $plan_info['data']['plan']['statusDescrip'] == '推广中' ? 1 : 0;
$limitInfo = Bll_Fixedspread_AjkFixedSpread::getLimitInfo($brokerId);
$data['budget'] = !empty($limitInfo) ? round($limitInfo['amountLimit'] / 100, 2) : 0;
$data['budgetUnit'] = '元';
} else {
$brokerInfo = Model_Broker_AjkBrokerExtend::getDataByBrokerId($brokerId);
$planId = Model_Plan_EsfFixedPlan::addPlan('定价推广组', 1, $brokerInfo->cityId, $brokerInfo->userId, $brokerInfo->brokerId);
$data['planId'] = $planId;
$data['todayClicks'] = $data['todayConsume'] = $data['totalProps'] = $data['planStatus'] = 0;
$data['todayConsumeUnit'] = $data['budgetUnit'] = '元';
$limitInfo = Bll_Fixedspread_AjkFixedSpread::getLimitInfo($brokerId);
$data['budget'] = !empty($limitInfo) ? round($limitInfo['amountLimit'] / 100, 2) : 0;
}
$result['data'] = $data;
return $result;
}
public function handle_request()
{
$sqlSelectErrorQueue = 'SELECT * from q_new_bid_deal_06 WHERE `actionId`=2 AND `siteType`=2 AND `status`=2 AND `id` >7330;';
$errorQueueList = Model_Choice_ActionQueue::data_access(date('m'))->native_sql($sqlSelectErrorQueue, array());
foreach ($errorQueueList as $errorQueue) {
$this->log("开始修复: ID={$errorQueue['id']}\tBrokerId={$errorQueue['brokerId']}\tPlanId={$errorQueue['planId']}");
$ajkBrokerExtend = Model_Broker_AjkBrokerExtend::getDataByBrokerId($errorQueue['brokerId']);
/** TODO 添加获取二手房经纪人信息为空日志 */
if (empty($ajkBrokerExtend)) {
$this->log(sprintf('获取经纪人(%d)的UserId失败(%d)。', $errorQueue['brokerId'], $errorQueue['id']));
continue;
}
$planExtend = Dao_Broker_HzPlan::get_bid_sn($errorQueue['planId']);
/** TODO 添加获取SN 失败日志 */
if (empty($planExtend)) {
$this->log(sprintf('获取计划(%d)的SN失败(%d)。', $errorQueue['planId'], $errorQueue['id']));
continue;
}
$planInfo = Dao_Broker_HzPlan::get_plan($errorQueue['planId']);
/** TODO 添加获取计划信息失败日志*/
if (empty($planInfo)) {
$this->log(sprintf('获取计划(%d)的信息失败(%d)。', $errorQueue['planId'], $errorQueue['id']));
continue;
}
//精选结算
$amount = $planInfo['total_consume'];
$note = urlencode(sprintf('精选推广(%d)扣费失败修复', $errorQueue['planId']));
$this->log("传递的参数：UserId={$ajkBrokerExtend['userId']}\tamount={$amount}\tplanId={$errorQueue['planId']}\tSN={$planExtend['sn']}");
$charge_sn = Bll_PayAccount::cancel_frozen($ajkBrokerExtend['userId'], $amount, $errorQueue['planId'], Const_PaymentApp::HZ_CHOICE, $planExtend['sn'], $note, true);
if ($charge_sn['data']['status'] === 'ok') {
$this->log('修复成功。');
} else {
$this->log('修复失败。');
}
$this->log(print_r($charge_sn, true));
}
return 'success';
}
public function handle_request()
{
$list = Bll_Broker_ShowcaseArrearageQuery::getInstance()->getBrokerSumList($this->_lastAdSetId, $this->_dateBase);
//$list = Bll_Broker_ShowcaseArrearageQuery::getInstance()->getBrokerSumList(0,$this->_dateBase);
if ($list) {
foreach ($list as $val) {
$this->setMyFlag($val['broker_id']);
$data = array('brokerId' => $val['broker_id']);
$orderinfo = Bll_Broker_ShowcaseOrders::getInstance()->getBrokerOrders($data, $this->_dateBase);
if ($orderinfo) {
$lavedays = ceil((strtotime($orderinfo->endDate) - strtotime(date('Ymd'))) / 3600 / 24);
$brokerInfo = new Model_Broker_AjkBrokerExtend();
$info = $brokerInfo->getDataByBrokerId($val['broker_id']);
$tmp = array('cityId' => $info['cityId'], 'status' => 1, 'startDate' => date('Ymd'));
$cityPrice = Bll_Broker_ConfigCityPrice::getInstance()->getCityPrice($tmp, $this->_dateBase);
$isComboCity = $this->isComboCity($orderinfo->cityId);
if ($isComboCity['code'] == 200) {
if ($isComboCity['data']) {
if ($val['cnt'] >= 1) {
if ($orderinfo->isStop == 0 && $lavedays > 0) {
$stopstatus = Bll_Broker_ShowcaseOrders::getInstance()->stopBrokerOthersAuto($orderinfo, $cityPrice->discountPrice, $this->_dateBase);
if (!$stopstatus['status']) {
$this->getError($this->_dateBaseName, $val['broker_id']);
}
}
}
} else {
if ($val['cnt'] >= 7) {
if ($orderinfo->isStop == 0 && $lavedays > 0) {
$stopstatus = Bll_Broker_ShowcaseOrders::getInstance()->stopBrokerOthersAuto($orderinfo, $cityPrice->discountPrice, $this->_dateBase);
if (!$stopstatus['status']) {
$this->getError($this->_dateBaseName, $val['broker_id']);
}
}
}
}
}
}
/*
if($val['cnt']>=7){
$data = array('brokerId'=>$val['broker_id']);
$orderinfo = Bll_Broker_ShowcaseOrders::getInstance()->getBrokerOrders($data,$this->_dateBase);
if($orderinfo){
$lavedays = ceil((strtotime($orderinfo->endDate)-strtotime(date('Ymd')))/3600/24);
if($orderinfo->isStop==0 && $lavedays > 0 ){
$brokerInfo =new Model_Broker_AjkBrokerExtend();
$info = $brokerInfo->getDataByBrokerId($val['broker_id']);
$tmp = array('cityId'=>$info['cityId'],'status'=>1,'startDate'=>date('Ymd'));
$cityPrice = Bll_Broker_ConfigCityPrice::getInstance()->getCityPrice($tmp,$this->_dateBase);
$stopstatus = Bll_Broker_ShowcaseOrders::getInstance()->stopBrokerOthers($orderinfo,$cityPrice->discountPrice,$this->_dateBase);
if(!$stopstatus['status']){
$mailSubject = date('Ymd').$this->_dateBaseName.'停止订单出错问题';
$mailBody =$this->_dateBaseName.'的二手房经纪人id:'.$val['broker_id'];
Bll_Broker_ShowcaseCommon::getInstance()->sendMail($mailSubject,$mailBody,$this->mailArr);
}
}
}
}
*/
}
} else {
$this->setMyFlag($this->getLastJobId(), 'over');
$mailSubject = $this->yDate . $this->subject;
$mailBody = $mailSubject . "完成 完成时间:" . date("Y-m-d H:i:s", time());
Bll_Broker_ShowcaseCommon::getInstance()->sendMail($mailSubject, $mailBody, $this->mailArr);
$this->setShStopFlag();
exit;
}
}
public function handle_request()
{
$houses = $this->getHouses();
if (!empty($_SERVER['PG_TEST'])) {
//如果是PG
$commIds = APF::get_instance()->get_config('pg_test_communitys_id', 'apiTestId');
} else {
$commIds = APF::get_instance()->get_config('test_communitys_id', 'apiTestId');
}
foreach ($houses as $house) {
//是否收费
$pushOpen = Bll_Broker_EntrustPrice::getInstance()->checkCityConsumeStatus($house['cityId']);
//城市是否开通房源库
//$cityInfo = Bll_Fyk_Prop_Manage::getInstance()->getCityConfig($house['cityId']);
$community = $this->getCommunity($house['commId']);
if (empty($community) || !$community['sosolat'] || !$community['sosolng']) {
$this->setLog(date('Y-m-d H:i:s') . ' - propId: ' . $house['id'] . ',no around community');
// 更新游标
$this->cursor['id'] = $house['id'];
$this->setFlag($this->cursor);
continue;
}
//两公里经纪人获取------3.7版本以上或者免费城市3.4版本以上
$brokerIds = $this->getBroker2K($house['commId'], $community['sosolat'], $community['sosolng'], $commIds, $pushOpen, $house['id']);
/**
* 板块推送功能关闭，后期将会删除
*/
/*
if (empty($brokerIds)) {
//板块下经纪人-》------3.7版本以上或者免费城市3.4版本以上 如果是测试小区测试经纪人id已经是存在的这里就没判断测试小区。
$brokerIds = $this->areaEntrustBroker($community['areaCode'],$pushOpen,$house['cityId'],$house['id']);
}
*/
if (empty($brokerIds)) {
$this->setLog(date('Y-m-d H:i:s') . ' - propId: ' . $house['id'] . ',commid: ' . $community['commId'] . ',no around broker');
// 更新游标
$this->cursor['id'] = $house['id'];
$this->setFlag($this->cursor);
continue;
}
$tmp = array_values(APF::get_instance()->get_config('test_broker_id', 'apiTestId'));
$brokerIdsArr = $tmp[0];
foreach ($brokerIds as $brokerId) {
$brokerInfoForAjkBrokerExtend = Model_Broker_AjkBrokerExtend::getDataByBrokerId($brokerId);
if (!in_array($brokerId, $brokerIdsArr) && $house['cityId'] != $brokerInfoForAjkBrokerExtend['cityId']) {
$this->setLog(date('Y-m-d H:i:s') . " - house: {$house['id']} and broker: {$brokerId} not in the same city.");
continue;
}
echo '执行队列插入' . "\n";
Model_House_CommissionHousePushed::create(array('userId' => Bll_Broker_MainBusiness::getDataByEsfId($brokerId)->memberId, 'brokerId' => $brokerId, 'propertyId' => $house['id'], 'createTime' => date('Y-m-d H:i:s'), 'propertyStatus' => $house['proStatus'], 'robNum' => $house['openBrokerCnt']))->save();
echo '更新可抢插入' . "\n";
// 更新可抢房源数
$daCommissionHousePushedCount = Model_House_CommissionHousePushedCount::data_access()->filter('brokerId', $brokerId)->find_only();
if (!empty($daCommissionHousePushedCount)) {
$daCommissionHousePushedCount->incrCommissionHousePushedCount();
} else {
Model_House_CommissionHousePushedCount::create(array('brokerId' => $brokerId, 'total' => 1))->save();
}
}
echo '完成' . "\n";
// 更新游标
$this->cursor['id'] = $house['id'];
$this->setFlag($this->cursor);
}
}
/**
* 是否PPC经纪人
* @param $ajkBrokerId
* @return bool
*/
public static function isPpcBroker($ajkBrokerId)
{
$data = Model_Broker_AjkBrokerExtend::getDataByBrokerId($ajkBrokerId);
return $data ? $data->payType == Model_Broker_AjkBrokerExtend::PAY_TYPE_PPC : false;
}
public function handle_request()
{
$adBrokerList = $this->getRequestData();
foreach ($adBrokerList as $val) {
$data = array();
$this->setMyFlag($val['id']);
// $priceList = Bll_Broker_ShowcaseConsumeQuery::getInstance()->getBrokerQuery($val['brokerId'],$this->yDate,$this->nDate,$this->_dateBase);
// $price = 0;
// if($priceList){
// foreach($priceList as $plist){
// $price += $plist['realAccount'];
// }
// }
$priceList = Bll_Broker_ShowcaseConsumeQuery::getInstance()->getBrokerQueryV2($val['brokerId'], $this->yDate, $this->_dateBase);
$price = 0;
if ($priceList) {
foreach ($priceList as $plist) {
$price += $plist['amount'];
}
}
$time = date('Y-m-d 00:10:00', strtotime($this->yDate));
$propList = Bll_Broker_ShowcaseAdSetPro::getInstance()->getBrokerTimeHouse($val['brokerId'], $time, $this->nDate, $this->_dateBase);
$props = $propstmp = array();
if ($propList) {
foreach ($propList as $hlist) {
if (!in_array($hlist['propId'], $props)) {
$props[] = $hlist['propId'];
}
}
}
$tpropList = Bll_Broker_ShowcaseAdSetPro::getInstance()->getBrokerTimeHouse($val['brokerId'], $this->nDate, 0, $this->_dateBase);
if ($tpropList) {
$propstmp = $this->aryMerger($tpropList, $propstmp);
}
$propShowList = Bll_Broker_ShowcaseAdSetPro::getInstance()->getBrokerAdPropShowInfo($val['brokerId'], $this->_dateBase);
if ($propShowList) {
$propstmp = $this->aryMerger($propShowList, $propstmp, 2);
}
if ($propstmp) {
foreach ($propstmp as $newval) {
if ($newval['flag'] != 1) {
if (!in_array($newval['propId'], $props)) {
$props[] = $newval['propId'];
}
}
}
}
$brokerInfo = new Model_Broker_AjkBrokerExtend();
$info = $brokerInfo->getDataByBrokerId($val['brokerId']);
$data['brokerId'] = $val['brokerId'];
$data['cityId'] = $info['cityId'];
$data['dayDate'] = $this->yDate;
$data['createTime'] = time();
$data['updateTime'] = date('Y-m-d H:i:s');
$data['propsSum'] = count($props);
$data['price'] = $price;
$lastid = Bll_Broker_ShowcaseLogs::getInstance()->addAdStatusLog($data, $this->_dateBase);
if (!$lastid) {
$mailSubject = $this->yDate . $this->_dateBaseName . '插入出错问题';
$mailBody = $this->_dateBaseName . '的' . $val['id'] . ',经纪人id:' . $val['brokerId'] . '执行时间:' . date('Y-m-d H:i:s');
Bll_Broker_ShowcaseCommon::getInstance()->sendMail($mailSubject, $mailBody, $this->mailArr);
}
}
}
