McDeclare.php
6.7 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
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
<?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("提交失败,请联系管理员");
}
}
}