Project.php 4.6 KB
<?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;
    }

}