Project.php
4.6 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
129
130
131
132
133
134
135
136
137
138
<?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": "124",
// "project_type_id": "330",
// "user_id": 21759,
// "register_id": "700",
// "checkagain_scale": "30.00",
// "project_details": 701
// },
$data = [
'container_id' => 124,
'project_type_id' => 330,
'user_id' => 21759,
'register_id' => 700,
'checkagain_scale' => 30.00,
'project_details' => 701,
];
$isJobDone = $this->doRegisterJob($data);
}
//消费者
public function fire(Job $job,$data) {
$isJobDone = $this->doRegisterJob($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 doRegisterJob($data)
{
ini_set("memory_limit","2048M");
$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;
}
}