RegiterDetail.php 8.1 KB
<?php


namespace app\index\controller;


use app\common\controller\Frontend;
use app\school\model\basic\Teacher;
use app\school\model\project_common\ProjectRegister;
use app\school\model\setting\ProjectContainer;
use app\school\model\setting\ProjectFormSet;
use app\school\model\setting\ProjectType;
use think\Db;
use think\Exception;

class RegiterDetail extends Frontend
{
    protected $noNeedLogin = ['getUserByUserId','getMemberInfo','getUserByUserId','getTeachersByIds'];
    protected $noNeedRight = '*';
    protected $layout = 'default';

    public function _initialize()
    {
        parent::_initialize(); // TODO: Change the autogenerated stub
        $this->assignconfig('user_id',$this->auth->id);
        $this->assignconfig('user',$this->auth->getUser());
    }


    public function index( $id = 0)
    {

        $projectRegisternewVo =  new  ProjectRegister();
        # 查询已经填过的数据
        $regData = $projectRegisternewVo->find($id);
        $project_type_id =  $regData["project_type"] ;
        $regDetail = db('project_register_details')->find(['id'=>$regData['project_details']]);
        $map['project_type_id'] = $regData["project_type"];
        $map['stage_type'] = ['not in',['meta_check','conclusion']];
        /*$map['project_starttime'] = ['lt',time()];
        $map['project_endtime'] = ['gt',time()];*/
        $formSets = ProjectFormSet::all($map);

        $user_id = $this->auth->id;
        $project_type = ProjectType::get($project_type_id);
        $container = ProjectContainer::get($project_type->container_id);

        foreach ($formSets as $k=>&$v){
            if ($v){

                $v['fields_settings'] = json_decode($v['fields_setting'],true);
                unset($formSets[$k]['fields_setting']);
            }
        }
        # 报名阶段无需填写字段
        $RegNoInputField = ['reg_student_no','reg_project_college','reg_college_text','reg_specialty_text','reg_username','reg_mobile'
            ,'reg_college','reg_specialty'
            ,'reg_entry_year','reg_email'];
        # 项目成员无需填写字段
        $MembersNoInputField = ['members_username','members_mobile'
            ,'members_college','members_specialty'
            ,'members_entry_year','members_email','members_college_text','members_specialty_text'];

        $teacherNoInputField = ['teachers_username','teachers_mobile','teachers_college_text'
            ,'teachers_position_text','teachers_education_text','teachers_degree_text'
        ];

        # 动态下拉框的字段
        $selectPage = [
            'collage',
            'specialty',
            'clazz'
        ];

        foreach ($formSets as $k=>&$v){
            $project_starttime = $v['project_starttime'];
            $project_endtime = $v['project_endtime'];
            if ($project_starttime!= null && $project_endtime != null){
                $v['flag'] = 'start';
                if ($project_starttime > time()){
                    //如果未到开始时间
                    //$v['flag'] = 'noStart';
                    unset($v);
                }
                continue;
            }
            $v['flag'] = "start";
        }
//        echo json_encode($formSets);exit;
        $this->assign('teacherNoInputField',$teacherNoInputField);
        $this->assign('selectPage',$selectPage);
        $this->assign('regNotInput',$RegNoInputField);
        $this->assign('MembersNoInputField',$MembersNoInputField);
        $this->assignconfig('regNotInput',$RegNoInputField);
        $this->assignconfig('MembersNoInputField',$MembersNoInputField);

        $this->assign('formset',$formSets);
        $this->assign('container',$container);
        $this->assign('project_type_id',$project_type_id);
        $this->assignconfig('formset',$formSets);


        if ($regDetail){
            $regDetail = json_decode($regDetail['project_details'],true);
        }

        if ($regData['custom_form_data']){
            $regData = array_merge(json_decode($regData['custom_form_data'],true)['reg'],$regData->toArray());
        }
        $this->assign('row',$regData);
        $this->assign('id',$regData['id']);
        $this->assignconfig('member_ids',explode(',',$regData['project_member_ids']));
        // 查询指导教师
        $teachers = [];
        if ($regData['project_teachers']){
            $project_teacher_json = json_decode($regData['project_teachers'],true);
            if(!empty($project_teacher_json)){
                $teachers = $project_teacher_json[$regData['project_teacher_ids']];
            }else{
                $teachers = Teacher::whereIn("id",$regData['project_teacher_ids'])->find();
            }
        }
        if(empty($regDetail)){
            $regDetail = [];
        }
        if(is_object($teachers)){
            $teachers = $teachers->toArray();
        }else if(!is_array($teachers)){
            $teachers = [];
        }
        $regDetail = array_merge($regDetail??[],$teachers);
        $this->assign('reg_detail',$regDetail);

        return $this->view->fetch();
    }
    public function getMemberInfo($members_student_no){
        $user = \app\admin\model\User::get(['student_no'=>$members_student_no /*, 'school_id'=>$this->auth->school_id*/]);
        if(!$user) $this->error('未查询到用户');
        if($user['status'] == 'lock') $this->error('该学生已被禁用');
        //if (!$user) $this->error("未查询到用户");
        $this->success("查询成功",null,$user);
    }

    //赛事报名获取教师信息
    public function getTeacher($job_num)
    {
        $teacher = \app\school\model\basic\Teacher::get(['job_num' => $job_num]);
        if(!$teacher) $this->error("未查询到该教师");
        if ($teacher['status'] == 0) $this->error("该教师已被禁用");
        $this->success("查询成功",null,$teacher);
    }

    public function getUserByUserId($user_id){
        $user = \app\admin\model\User::get(['id'=>$user_id /*, 'school_id'=>$this->auth->school_id*/]);
        if (!$user) $this->error("未查询到用户");
        $this->success("查询成功",null,$user);
    }

    public function getUsersByIds($ids = ''){
        $map['id'] = ['in',$ids];
        $limit = request()->param('limit');
        $order = request()->param('order');
        $sort = request()->param('sort');
        $model = new \app\admin\model\User;
        $list = $model
            ->where($map)
            ->order($sort, $order)
            ->paginate($limit);
        $result = array("total" => $list->total(), "rows" => $list->items());
        return json($result);
    }

    public function getTeachersByIds($ids = ''){
        $map['id'] = ['in',$ids];
        $limit = request()->param('limit');
        $order = request()->param('order');
        $sort = request()->param('sort');
        $list = (new \app\teacher\model\Teacher())
            ->where($map)
            ->order($sort, $order)
            ->paginate($limit);
        $result = array("total" => $list->total(), "rows" => $list->items());
        return json($result);
    }

    // 新增项目成员模板
    public function addStudents(){
        $this->view->assign('login',$login='foot');//首页隐藏头部使用
        return $this->fetch();
    }

    // 按教师ID查询教师
    public function getTeacherInfo(){
        $teacher_id = request()->param('teacher_id',false);
        if (!$teacher_id) $this->error("请填写教师工号");
        $teacher = Teacher::get(['job_num'=>$teacher_id]);
        if (!$teacher) $this->error("教师信息不存在");
        if ($teacher['status'] == 0) $this->error("该教师已被禁用");
        $this->success("查询成功","",$teacher);
    }

    /**
     * 查看 学生学生作为队员次数
     * @param $userId
     */
    public function getStudentCount($userId)
    {
        return (new ProjectRegister())->where('user_id','neq',$userId)->where('find_in_set(:id,project_member_ids)',['id'=>$userId])->count();
    }
    /**
     * 查看 队长作为队员次数
     * @param $userId
     */
    public function getCaptainCount($userId)
    {
        return (new ProjectRegister())->where('user_id','neq',$userId)->where('find_in_set(:id,project_member_ids)',['id'=>$userId])->count();
    }

}