public function handle_request()
{
if ($this->request->is_post_method()) {
$brokerId = $this->request->get_parameter('brokerId');
$deviceId = $this->request->get_parameter('deviceId');
//删除da_mobile_broker_find_user_upload表跟制定broker_id相关的数据
$brokerFindUserData = Model_Broker_BrokerFindUser::data_access()->filter('brokerId', $brokerId)->find();
foreach ($brokerFindUserData as $val) {
$val->delete();
}
//删除da_mobile_broker_find_user_upload表跟制定device_id相关的数据
$brokerFindUserData = Model_Broker_BrokerFindUser::data_access()->filter('userId', $deviceId)->find();
foreach ($brokerFindUserData as $val) {
$val->delete();
}
//删除broker_user_relation_XX表跟制定brokerId相关的数据
$brokerUserRelationData = Model_Mobile_BrokerUserRelation::data_access()->filter('brokerId', $brokerId)->find();
foreach ($brokerUserRelationData as $val) {
$val->delete();
}
//删除broker_user_relation_XX表跟制定user_device_id相关的数据
$brokerUserRelationData = Model_Mobile_BrokerUserRelation::data_access()->filter('userDeviceId', $deviceId)->find();
foreach ($brokerUserRelationData as $val) {
$val->delete();
}
//删除broker_bind表跟制定brokerId相关的数据
$brokerBindData = Model_Mobile_BrokerBind::data_access()->filter('brokerId', $brokerId)->find();
foreach ($brokerBindData as $val) {
$val->delete();
}
//删除user_bind表跟制定device_id相关的数据
$userBindData = Model_Mobile_UserBind::data_access()->filter('deviceId', $deviceId)->find();
foreach ($userBindData as $val) {
$val->delete();
}
$this->setAttribute('out', 1);
}
return 'Test_TruncateDataForCustomerRush';
}
/**
* 获取经纪人和用户的关系
*
* @param string $deviceId
* @param int $brokerId
* @param string $date
* @param string $splitSuffix
* @return array
*/
public static function getCustomerRelation($deviceId, $brokerId, $date, $splitSuffix = '')
{
if (empty($splitSuffix)) {
$splitSuffix = date('Ym');
}
try {
return Model_Mobile_BrokerUserRelation::data_access($splitSuffix)->filter('userDeviceId', $deviceId)->filter('brokerId', $brokerId)->filter('uploadDt', $date)->get_row();
} catch (Exception $e) {
return array();
}
}
private function pushLastMsgNum($brokerId)
{
$thisPushLastMsgNum = Model_Mobile_CustomerLatestPushCount::data_access()->filter('brokerId', $brokerId)->filter('pushDate', date('Y-m-d', time()))->find_only();
if (!empty($thisPushLastMsgNum)) {
$thisPushLastMsgNum->incrPushedCount();
} else {
$insertData['brokerId'] = $brokerId;
$insertData['pushDate'] = date('Y-m-d', time());
$insertData['count'] = 1;
try {
$MODEL = Model_Mobile_CustomerLatestPushCount::create($insertData);
$MODEL::$enable_cache = false;
$MODEL->save();
} catch (Exception $e) {
Model_Mobile_BrokerUserRelation::data_access()->roll_back();
}
}
}
/**
* 获取经纪人和客户今日推送的关系
*
* @param $deviceId
* @param $brokerId
* @return Model_Mobile_BrokerUserRelation|null
*/
public function getUserBrokerTodayRelation($deviceId, $brokerId)
{
return Model_Mobile_BrokerUserRelation::data_access(date('Ym'))->filter('userDeviceId', $deviceId)->filter('brokerId', $brokerId)->filter('uploadDt', date('Y-m-d'))->sort('id')->find_only();
}
