Project.php
4.4 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
<?php
namespace app\index\controller\job;
use app\school\model\project_common\ProjectRegister;
use app\school\model\setting\ProjectFormSet;
use Predis\Client;
use think\queue\Job;
use think\Db;
class Project
{
// public function test()
// {
// $data = [
// 'container_id' => 99,
// 'project_type_id' => 248,
// 'user_id' => 13844,
// 'register_id' => 489,
// 'checkagain_scale' => 20,
// 'project_details' => 490,
// ];
// $isJobDone = $this->doHelloJob($data);
// }
//消费者
public function fire(Job $job,$data) {
$isJobDone = $this->doHelloJob($data);
if ($isJobDone) {
$job->delete();
}else{
if ($job->attempts() > 2) {
Db::name('project_check_log')->insert(['register_id' => $data['register_id'],'reason' => '查重失败超过2次','createtime' => time()]);
$job->delete();
//$job->release(2); //$delay为延迟时间,表示该任务延迟2秒后再执行
}
}
}
/**
* 有些消息在到达消费者时,可能已经不再需要执行了
* @param array|mixed $data 发布任务时自定义的数据
* @return boolean 任务执行的结果
*/
private function checkDatabaseToSeeIfJobNeedToBeDone($data){
return true;
}
/**
* 大创报名查重
*/
private function doHelloJob($data)
{
$server = array(
'host' => 'r-8vb3mizdy07emeuv4upd.redis.zhangbei.rds.aliyuncs.com',//IP
'port' => 6379, //端口
'password' => 'Yundai2019', //密码
);
$redisKey = 'checkProject:'.$data['container_id'].'_'.$data['project_type_id'];
$redis = new Client($server);//实例化
$redis->select(8);
$infos = $redis->hgetall($redisKey);
//该组别下文本报名数据
if(empty($infos)) {
return true;
}
//自己的报名数据
if(array_key_exists($data['user_id'].'_'.$data['register_id'],$infos)) {
$checkData = json_decode($infos[$data['user_id'].'_'.$data['register_id']],true);
}else {
//Redis中不存在 查询数据库
$selfDetail = Db::name('project_register_details')->where(['id' => $data['project_details']])->find();
$selfFields = json_decode($selfDetail['project_details'],true);
$checkData = array_merge($selfFields['reg'],$selfFields['details']);
}
//查询该组别下 表单项
$map['project_type_id'] = $data['project_type_id'];
$map['stage_type'] = ['in',['reg','details']];
$formSets = ProjectFormSet::all($map);
$textField = [];
foreach ($formSets as $value) {
$fields_setting = json_decode($value['fields_setting'],true);
foreach ($fields_setting as $v) {
if($v['type'] == 'input' || $v['type'] == 'textarea') {
if(array_key_exists($v['name'],$checkData)) {
$textField[$v['name']] = $checkData[$v['name']];
}
}
}
}
unset($infos[$data['user_id'].'_'.$data['register_id']]);
if(empty($textField)) {
return true;
}
//对数组排序
ksort($textField);
$textField = implode(',',$textField);
$flg = false;
$rate = 0;
//比较文本差异百分比
foreach ($infos as $key => $value) {
if($flg) {
break;
}
$tmp = json_decode($value,true);
//同样排序
ksort($tmp);
$tmp = implode(',',$tmp);
//比较文本差异百分比
similar_text($textField,$tmp,$percent);
if($percent >= $data['checkagain_scale']) {
$rate = number_format($percent);
$flg = true;
}
}
//有重复更新报名记录
if($flg) {
$result = Db::name('project_register')->where('id', $data['register_id'])->update(['repeat_rate' => $rate]);
if(!$result) {
Db::name('project_check_log')->insert(['register_id' => $data['register_id'],'reason' => '更新查重率失败','createtime' => time()]);
}
}
return true;
}
}