McDeclare.php 6.7 KB
<?php

namespace app\index\controller;

use app\common\controller\Frontend;
use app\common\model\Member;
use app\common\model\User;
use app\expert\model\ProjectRegister;
use think\Db;

class McDeclare extends Frontend
{

    protected $noNeedLogin = '*';
    protected $noNeedRight = '*';
    protected $layout = 'default';
    public function _initialize()
    {
        parent::_initialize(); // TODO: Change the autogenerated stub
    }

    /**
     * @return string
     * @throws \think\Exception
     * 变更成员视图
     */
    public function index()
    {
        $param = $this->request->param();
        $memberModel = new Member();
        $memberInfo = $memberModel->alias('m')
            ->field('u.*,c.college_name,m.member_type,m.member_source,m.is_captain,m.sort')
            ->join('user u','m.member_id = u.id','inner')
            ->join('college c','u.college = c.id','left')
            ->where(['m.member_type' => Member::STUDENT,'m.member_source' => Member::PROJECT,'m.item_id' => $param['register_id']])
            ->order('sort','asc')
            ->select();
        //成员
        $jsons = $formFieldsMap = json_decode(file_get_contents('assets/js/school/setting/formFieldsMap.json', FILE_USE_INCLUDE_PATH), true);
        $memberField = $jsons['members'];
        $registerInfo = ProjectRegister::get(['id' => $param['register_id']]);
        $this->assignconfig("register_id",$param['register_id']);
        $this->assignconfig("registerInfo",$registerInfo);
        $this->assignconfig("memberField",$memberField);
        $this->assignconfig("membersInfo",collection($memberInfo)->toArray());
        return $this->view->fetch();
    }

    /**
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     * 获取当前项目成员数据
     */
    public function getData(){
        $param = $this->request->param();
        $info = Db::name('project_register')->where(["id"=>$param['register_id']])->find();
        $members = !empty($info['project_members']) ? json_decode($info['project_members'],true) : [];
        $info['project_members'] = array_merge($members);
        $info['member_id_array'] =   explode(",",$info['project_member_ids']);
        $this->success('','',$info);

    }

    /**
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     * 获取当前学校及不在当前成员中所有学生
     */
    public function getAllstudents(){
        $params = request()->param();
        $where = [];
        $where1['student_no'] = ['neq','not null']; //不为空
        if(isset($params['existIds']) && !empty($params['existIds'])) {
            $where = ['id' => ['NOT IN', $params['existIds']]];
        }
        $students_list = Db::name('user')->where($where1)->where($where)->where('school_id',$this->school_id)->select();
        $this->success('',null,$students_list);
    }
    /**
     * @param regId 报名id
     * @param members_student_no 学号
     * 添加成员   查询学生
     */
    public function getMemberInfo()
    {
        $registerId = request()->param('register_id');
        $studentNo  = request()->param('student_no');
        $studentInfo = (new \app\school\model\basic\User())->where(['student_no' => $studentNo])->find();
        if(!$studentInfo) $this->error('未查询到学生');
        $studentInfo = $studentInfo->toArray();
        if($studentInfo['status'] == 'lock') $this->error('该学生已被禁用');


        $studentInfo['member_type']     = Member::STUDENT;
        $studentInfo['member_source']   = Member::PROJECT;
        $studentInfo['is_captain']      = Member::CAPTAIN_N;
        if($registerId) {
            $membersInfo = (new Member())->where(['member_id' => $studentInfo['id'],'item_id' => $registerId,'member_type' => Member::STUDENT,'member_source' => Member::PROJECT])->find();
            if($membersInfo) {
                $studentInfo['member_type']     = $membersInfo['member_type'];
                $studentInfo['member_source']   = $membersInfo['member_source'];
                $studentInfo['is_captain']      = $membersInfo['is_captain'];
                $studentInfo['sort']            = $membersInfo['sort'];
            }
        }
        $this->success("查询成功",null,$studentInfo);
    }


    /**
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     * 提交项目成员变更申请
     */
    public function saveChange(){
        $param = $this->request->param();
        if(empty($param['memo'])) {
            $this->error("请填写成员变更原因");
        }
        if(mb_strlen($param['memo'],"UTF-8") > 200) {
            $this->error("变更原因在200字之内");
        }
        $register= Db::name("project_register")->where("id",$param['register_id'])->find();
        if(empty($register)){
            $this->error("项目不存在,请核对");
        }
        if(!isset($param['membersInfo']) || empty($param['membersInfo'])) {
            $this->error("团队成员不能为空");
        }

        $captainArrs = array_column($param['membersInfo'],'is_captain');
        if(!in_array(Member::CAPTAIN_Y,$captainArrs)) {
            $this->error("请选择队长");
        }
        $keyCount = array_count_values($captainArrs);
        foreach ($keyCount as $key => $val) {
            if($key == Member::CAPTAIN_Y) {
                if($val > 1) {
                    $this->error("团队中只能存在一位队长");
                }
            }
        }
        $memberModel = new Member();
        $oldMembersInfo = $memberModel->alias('m')
            ->field('m.*,u.nickname,u.college')
            ->join('user u','m.member_id = u.id','left')
            ->where(['m.item_id' => $param['register_id'],'m.member_type' => Member::STUDENT,'m.member_source' => Member::PROJECT])
            ->order('m.sort','asc')
            ->select();

        $insert['register_id']  = $param['register_id'];
        $insert['title']        = '【'.$register['project_name'].'】成员变更申请';
        $insert['change_memo']  = $param['memo'];
        $insert['user_id']      = $this->auth->id;
        $insert['status']       = 0;
        $insert['createtime']   = time();
        $insert['old_members_json']   = json_encode($oldMembersInfo,true);
        $insert['change_members_json']      = json_encode($param['membersInfo'],true);

        $status = Db::name("project_change_members")->insert($insert);

        if($status){
            $this->success('提交成功,请等待审核结果');
        }else{
            $this->error("提交失败,请联系管理员");
        }
    }
}