Matchitems.php 17.7 KB
<?php

namespace app\school\controller\match;

use app\admin\model\User;
use app\common\model\Territory;
use app\expert\model\ProjectRegister;
use app\expert\model\ProjectRegisterDetails;
use app\school\controller\basic\College;
use app\school\model\basic\Specialty;
use app\school\model\review\Review;
use app\school\model\review\ReviewScore;
use app\common\controller\ManystoreBase;
use app\common\model\Member;
use app\school\model\setting\ProjectFormSet;
use app\teacher\model\basic\Teacher;
use think\Db;
use think\Exception;

class Matchitems extends  ManystoreBase {

    protected  $noNeedRight = ['*'];
    protected  $noNeedLogin = ['*'];

    protected  $model = null;

    public function _initialize()
    {
        parent::_initialize(); // TODO: Change the autogenerated stub
        $this->model = new \app\school\model\match\MatchItems();
    }


    /**
     * 查看
     */
    public function index()
    {
        //设置过滤方法
        $this->request->filter(['strip_tags']);
        if ($this->request->isAjax()) {
            //如果发送的来源是Selectpage,则转发到Selectpage
            if ($this->request->request('keyField')) {
                return $this->selectpage();
            }
            list($where, $sort, $order, $offset, $limit) = $this->buildparams();
            $tag = request()->param('tag',false);
            $match_type = request()->param('match_type',false);
            $collageSearch = request()->param('collageSearch',false);
            $specialtySearch = request()->param('specialtySearch',false);
            $student_name = request()->param('student_name',false);
            $project_name = request()->param('project_name',false);
            $map = [];
            $idx = request()->param('idx',false);
            if (!$idx) $this->error("系统繁忙,请稍后再试!");
            if (!empty($tag)){
                //标签id
                $map['m.match_tag_id'] = $tag;
            }
            //赛道id
            $map['m.match_type'] = $match_type;
            //学校id
            $map['m.school_id'] = SCHOOL_ID;
            //比赛id
            $map['m.match_id'] = $idx;

            if ($collageSearch){
                $map['u.college'] = $collageSearch;
            }
            if ($specialtySearch){
                $map['u.specialty'] = $specialtySearch;
            }
            if ($student_name){
                $map['u.nickname'] = ['like',"%{$student_name}%"];
            }
            if($project_name) {
                $map['m.project_name'] = ['like',"%{$project_name}%"];
            }
            $total = $this->model
                ->alias('m')
                ->field('m.*,c.college_name')
                ->where($map)
                ->join('user u','u.id=m.user_id','left')
                ->join('college c','u.college = c.id','left')
                ->count();
            $list = $this->model
                ->alias('m')
                ->field('m.*,c.college_name,u.student_no,rw.id as review_id,res.result,mt.tag_name,p.prize_type,p.get_time,p.url')
                ->where($map)
                ->join('user u','u.id=m.user_id','left')
                ->join('review rw','find_in_set(m.match_tag_id,rw.match_tags_id)','left')
                ->join('match_review_result res','res.match_item_id = m.id and res.tag_id = m.match_tag_id and res.review_id = rw.id','left')
                ->join('college c','u.college = c.id','left')
                ->join('match_tags mt','mt.id = m.match_tag_id','left')
                ->join('match_item_prize p','p.match_items_id = m.id','left')
                ->where('res.deletetime',null)
                ->where('rw.deletetime',null)
                ->order('res.result desc,m.createtime asc')
                ->limit($offset, $limit)
                ->select();
            $territoryModel = new Territory();
            foreach ($list as &$value) {
                $territoryIds = explode(',',$value['territory_id']);
                $territoryInfo = $territoryModel->whereIn('id',$value['territory_id'])->column('territory_name');
                $value['territory_name'] = $territoryInfo ? implode(',',$territoryInfo) : '--';
            }
            $result = array("total" => $total, "rows" => $list);

            return json($result);
        }
        return $this->view->fetch();
    }


    public function remark()
    {
        $id = request()->param('id');
        $list = [];
        $reviewModel = new Review();
        $info = \app\school\model\match\MatchItems::get($id);
        $review = $reviewModel->where('find_in_set(:id,match_tags_id)',['id'=>$info['match_tag_id']])->find();
        if($review) {
            $model = new ReviewScore;
            $list = $model
                ->alias('s')
                ->field('s.remark,s.score_total,e.nickname')
                ->join('project_experts e','s.judge_id = e.id','left')
                ->where(['s.match_items_id' => $id,'review_id' => $review['id']])
                ->select();
        }
        $this->assign('list',$list);
        return $this->view->fetch();
    }

    /**
     * 新增成员数据表  更新老数据使用
     */
    public function updateStatistics()
    {
        $flg = request()->param('flg',false);
        $model = new Member();
        $model->updateMembers($flg);
    }

    /**
     * 删除无用数据
     */
    public function deleteRegister()
    {
        //删除详情
        $detailsIds = (new ProjectRegister())->where('school_id','neq',6)->column('project_details');
        Db::name('project_register_details')->whereIn('id',$detailsIds)->delete();
        //删除报名数据
        Db::name('project_register')->where('school_id','neq',6)->delete();

        //删除比赛
        Db::name('project_container')->where('school_id','neq',6)->delete();
        //删除formset
        Db::name('project_form_set')->where('school_id','neq',6)->delete();

        //删除包衣已删除比赛数据
        $delCids = Db::name('project_container')->where('school_id',6)->where('deletetime','not null')->column('id');
        $typeIds = Db::name('project_type')->whereIn('container_id',$delCids)->column('id');


        Db::name('project_form_set')->whereIn('project_type_id',$typeIds)->delete();
        Db::name('project_container')->where('school_id',6)->where('deletetime','not null')->delete();

        $exist = Db::name('project_container')->where('school_id',6)->column('id');

        Db::name('project_type')->whereNotIn('container_id',$exist)->delete();

    }


    /**
     * 同步数据
     */
    public function regdetailsTB()
    {
        $jsons = $formFieldsMap = json_decode(file_get_contents('assets/js/school/setting/formFieldsMap.json', FILE_USE_INCLUDE_PATH), true);

        foreach ($jsons as $k => $json) {
            if($k == 'reg') {
                foreach ($json as $ks => &$val) {
                    if($val['name'] == 'territory_id') {
                        unset($json[$ks]);
                    }
                }
            }
        }
        $reg = json_encode($jsons['reg'],true);
        $members = json_encode($jsons['members'],true);
        $teachers = json_encode($jsons['teachers'],true);
        $details = json_encode($jsons['details'],true);
        $meta_check = json_encode($jsons['meta_check'],true);
        $conclusion = json_encode($jsons['conclusion'],true);

        //更新formset
        $formsetModel = new ProjectFormSet();
        $formSets = $formsetModel->select();
        foreach ($formSets as $form) {
            $json = '';
            if($form['stage_type'] == 'reg') {
                $json = $reg;
            }else if($form['stage_type'] == 'members') {
                $json = $members;
            }else if($form['stage_type'] == 'teachers') {
                $json = $teachers;
            }else if($form['stage_type'] == 'details') {
                $json = $details;
            }else if($form['stage_type'] == 'meta_check') {
                $json = $meta_check;
            }else {
                $json = $conclusion;
            }
            Db::name('project_form_set')->where('id', $form['id'])->update(['fields_setting'	=> $json]);
        }

        //同步报名数据详情
        $details = Db::name('project_register')->alias('r')
            ->field('d.id as detail_id,d.project_details as detail_info,r.*')
            ->join('project_register_details d','r.project_details = d.id','inner')
            ->where('r.id','neq',478)
            ->select();
        $update = [];
        $teacherJsons = [];
        foreach ($details as $key => $value) {
            $teacherJson = json_decode($value['project_teachers'],true);
            $tmpSubjects = [strval($value['project_lv1_subject']),strval($value['project_lv2_subject'])];
            $regJson = json_decode($value['detail_info'],true);
            $tmp = [];
            $tmp1 = [];
            //reg
            $tmp['reg']['project_name'] = $value['project_name'];
            $tmp['reg']['project_des']  = $value['project_des'];
            $tmp['reg']['_email']       = isset($regJson['reg']['_email']) ?  $regJson['reg']['_email'] : User::get($value['user_id'])['email'];
            $tmp['reg']['project_starttiem']  = date('Y-m-d',$value['project_starttiem']);
            $tmp['reg']['project_endtime']  = date('Y-m-d',$value['project_endtime']);
            $tmp['reg']['subjects']         = $tmpSubjects;
            $tmp['reg']['project_source']   = strval($value['project_source']);


            //teachers
            $tmp['teachers']['job_num']   = strval($teacherJson[$value['project_teacher_ids']]['job_num']);
            $tmp['teachers']['username']   = strval($teacherJson[$value['project_teacher_ids']]['username']);
            $tmp['teachers']['college_text']   = strval($teacherJson[$value['project_teacher_ids']]['college_text']);
            $tmp['teachers']['position_text']   = strval($teacherJson[$value['project_teacher_ids']]['position_text']);
            $tmp['teachers']['education_text']   = strval($teacherJson[$value['project_teacher_ids']]['education_text']);
            $tmp['teachers']['degree_text']   = strval($teacherJson[$value['project_teacher_ids']]['degree_text']);
            $tmp['teachers']['main_results']   = strval($teacherJson[$value['project_teacher_ids']]['main_results']);
            $tmp['teachers']['id']   = strval($value['project_teacher_ids']);

            $tmp1['item_id'] = $value['id'];
            $tmp1['member_id'] = $value['project_teacher_ids'];
            $tmp1['reg_json'] = json_encode($tmp['teachers'],true);
            $teacherJsons[] = $tmp1;

            //details
            $tmp['details']['apply_reason']   = isset($regJson['details']['apply_reason']) ?  $regJson['details']['apply_reason'] : $regJson['apply_reason'];
            $tmp['details']['project_purpose']   = isset($regJson['details']['project_purpose']) ?  $regJson['details']['project_purpose'] : $regJson['project_purpose'];
            $tmp['details']['project_content']   = isset($regJson['details']['project_content']) ?  $regJson['details']['project_content'] : $regJson['project_content'];
            $tmp['details']['project_conditions']   = isset($regJson['details']['project_conditions']) ?  $regJson['details']['project_conditions'] : $regJson['project_conditions'];

            $tmp['details']['project_plan']   = isset($regJson['details']['project_plan']) ?  $regJson['details']['project_plan'] : $regJson['project_plan'];

            $tmp['details']['school_support']   = isset($regJson['details']['school_support']) ?  $regJson['details']['school_support'] : $regJson['school_support'];

            $tmp['details']['expected_results']   = isset($regJson['details']['expected_results']) ?  $regJson['details']['expected_results'] : $regJson['expected_results'];

            $tmp['details']['project_budget']   = isset($regJson['details']['project_budget']) ?  $regJson['details']['project_budget'] : $regJson['project_budget'];

            $tmp['details']['declaration_attachment']   = isset($regJson['details']['declaration_attachment']) ?  $regJson['details']['declaration_attachment'] : $regJson['declaration_attachment'];

            $tmp['details']['declaration_attachment_file_name']   = isset($regJson['details']['declaration_attachment_file_name']) ?  $regJson['details']['declaration_attachment_file_name'] : (isset($regJson['declaration_attachment_file_name']) ? $regJson['declaration_attachment_file_name'] : '作品信息表.doc');


            $res = json_encode($tmp,true);
            $update[$key]['id'] = $value['detail_id'];
            $update[$key]['project_details'] = $res;
        }

        //同步教师
        foreach ($teacherJsons as $teacher) {
            $result = (new Member())->where(['member_id' => $teacher['member_id'],'item_id' => $teacher['item_id'],'member_type' => 2,'member_source' => 2])->update(['reg_json' => $teacher['reg_json']]);
        }
        $model = new ProjectRegisterDetails();
        $model->isUpdate(true)->saveAll($update);
    }

    //同步成员json
    public function memberJsonTB()
    {
        $memberModel = new Member();
        $memberInfo = $memberModel->where(['member_type' => 1,'member_source' => 2])->select();
        $memberInfo = collection($memberInfo)->toArray();
        $userModel = new \app\school\model\basic\User();
        Db::startTrans();
        try {
            foreach ($memberInfo as $member) {
                $memberModel = new Member();
                $json = [];
                $user = $userModel->where(['id' => $member['member_id']])->find();
                $json['student_no'] = $user['student_no'];
                $json['username'] = $user['username'];
                $json['mobile'] = $user['mobile'];
                $json['college_text'] = $user['college_text'];
                $json['specialty_text'] = $user['specialty_text'];
                $json['entry_year'] = $user['entry_year'];
                $json['email'] = $user['email'];
                $json['id'] = $user['id'];
                $json['college_id'] = $user['college'];
                $json['is_captain'] = $member['is_captain'];

                $jsonRes = json_encode($json,true);
                $result = $memberModel->where(['id' => $member['id']])->find();
                $result->reg_json = $jsonRes;
                $res = $result->save();
            }
            Db::commit();
        }  catch (Exception $e) {
            Db::rollback();
            $this->error($e->getMessage());
        }
    }

    /**
     * 获取学院下报名数据统计
     * @param  match_id 比赛id
     */
    public function getStatisticsData()
    {
        $matchId = request()->param('match_id');
        $matchInfo = \app\school\model\match\Match::get($matchId);
        $responseData = ['collegeList' => [],'match_title'=>$matchInfo['match_title'],'college_group'=>['title' => [],'value'=>[],'total'=>0],'college_people' => [],'members_group'=>['title' => [],'value'=>[],'total' => 0]];
        $collegeModel = new \app\school\model\basic\College();
        //学院报名组数
        $collegeList = $collegeModel->alias('c')
            ->field('count(m.id) as sum,c.college_name,c.id')
            ->join('members m',"c.id = m.college_id and m.container_id = {$matchId} and m.member_type = 1 and m.member_source = 1 and m.is_captain = 2",'left')
            ->where(['c.school_id' => SCHOOL_ID,'c.is_college' => 1])
            ->group('c.id')
            ->select();
        if($collegeList) {
            $responseData['college_group']['title'] = array_column($collegeList,'college_name');
            $responseData['college_group']['value'] = array_column($collegeList,'sum');
            $responseData['college_group']['total'] = array_sum(array_column($collegeList,'sum'));
            $responseData['collegeList'] = $collegeList;
        }
        //学院报名成员个数
        $membersGroup = $collegeModel->alias('c')
            ->field('count(m.id) as sum,c.college_name,c.id')
            ->join('members m',"c.id = m.college_id and m.container_id = {$matchId} and m.member_type = 1 and m.member_source = 1",'left')
            ->where(['c.school_id' => SCHOOL_ID,'c.is_college' => 1])
            ->group('c.id')
            ->select();

        if($membersGroup) {
            $responseData['members_group']['title'] = array_column($membersGroup,'college_name');
            $responseData['members_group']['value'] = array_column($membersGroup,'sum');
            $responseData['members_group']['total'] = array_sum(array_column($membersGroup,'sum'));
        }
        $this->success('',null,$responseData);
    }



    /**
     * 获取专业下报名数据统计
     * @param  match_id 比赛id
     * @param  college_id 学院id
     */
    public function getSpecialtyStatistics()
    {
        $matchId = request()->param('match_id');
        $collegeId = request()->param('college_id');
        $result = ['match_title' => '','title' => [],'val' => [],'total' => 0];
        $matchInfo = \app\school\model\match\Match::get($matchId);
        $result['match_title'] =  $matchInfo['match_title'];
        $specialtyModel = new Specialty();
        $specialtyList = $specialtyModel->alias('s')
            ->field('s.specialty_name,count(m.id) as sum')
            ->join('college c','s.college_id = c.id','left')
            ->join('user u','u.specialty = s.id','left')
            ->join('members m',"u.id = m.member_id and m.container_id = {$matchId} and m.member_type = 1 and m.member_source = 1 and m.is_captain = 2",'left')
            ->where(['c.id' => $collegeId])
            ->group('s.id')
            ->select();
        if($specialtyList) {
            $result['title']  = array_column($specialtyList,'specialty_name');
            $result['val']    = array_column($specialtyList,'sum');
            $result['total']  = array_sum(array_column($specialtyList,'sum'));
        }

        $this->success('',null,$result);
    }
}