Projectitem.php
5.2 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
<?php
namespace app\index\controller;
use app\common\controller\Frontend;
use app\common\model\Member;
use app\expert\model\ProjectRegister;
use app\index\model\ItemDelay;
use app\index\model\ProjectChangeMembers;
use think\Db;
use think\Exception;
class Projectitem extends Frontend
{
protected $noNeedLogin = [];
protected $noNeedRight = '*';
protected $layout = 'default';
protected $model = null;
CONST PARAMS_ERROR = '参数错误';
CONST BAD_REQUEST = '非法请求';
CONST NOT_FOUND = '作品不存在';
CONST DELAY_APPLY = '您已申请项目延期';
public function _initialize()
{
parent::_initialize();
$this->model = new ProjectRegister();
$userInfo = $this->auth->getUser();
}
public function index()
{
// 查询学生参与的作品
$memberModel = new Member();
$list = $memberModel->alias('m')
->field('m.is_captain,r.*,pc.container_name , pt.name , pc.midterm_review_starttime, pc.midterm_review_endtime,pc.conclusion_starttime,pc.conclusion_endtime,pc.container_desc,pc.project_starttime,pc.project_endtime,pc.project_double_starttime,pc.project_double_endtime,pc.can_apply_mid,pc.can_apply_conclusion,pc.can_apply_approval')
->join('project_register r','m.item_id = r.id','inner')
->join('project_container pc','pc.id = r.container_id','left')
->join('project_type pt','pt.id = r.project_type','left')
->where(['m.member_type' => Member::STUDENT,'m.member_source' => Member::PROJECT,'m.member_id' => $this->auth->id])
->where('r.deletetime',null)
->order('r.createtime','desc')
->paginate(1);
$count = $memberModel->alias('m')
->field('m.id')
->join('project_register r','m.item_id = r.id','inner')
->join('project_container pc','pc.id = r.container_id','left')
->join('project_type pt','pt.id = r.project_type','left')
->where(['m.member_type' => Member::STUDENT,'m.member_source' => Member::PROJECT,'m.member_id' => $this->auth->id])
->where('r.deletetime',null)
->count();
$this->assign('_list',$list);
$this->assign('login_id',$this->auth->id);
$this->assign('_list_count',$count);
return $this->view->fetch();
}
// 项目延期申请
public function subject_delay(){
if (!request()->post()) $this->error(self::BAD_REQUEST);
$item_id = request()->param('item_id',false);
$delay_memo = request()->param('delay_memo',null);
if (!$item_id) $this->error(self::PARAMS_ERROR);
$item = $this->model->where('id',$item_id)->find();
if (!$item) $this->error(self::NOT_FOUND);
$_delay = ItemDelay::get(['register_id'=>$item_id]);
if ($_delay){
$this->error(self::DELAY_APPLY);
}
$created['register_id'] = $item_id;
$created['delay_memo'] = $delay_memo;
try {
ItemDelay::create($created);
}catch (Exception $e){
$this->error($e->getMessage());
}
$this->success("申请项目延期成功");
}
/**
* 变更成员申请
*/
public function member_change(){
$register_id = request()->param('register_id');
$projectChangeMembersModel = new ProjectChangeMembers();
$changeMembers = $projectChangeMembersModel->where('register_id',$register_id)->paginate(5);
$this->assign('change_members',$changeMembers);
return $this->fetch();
}
/**
*审核信息
*/
public function verify_list()
{
$reviewStage = request()->param('review_stage');
$registerId = request()->param('register_id');
$map['l.register_id'] = $registerId;
if($reviewStage != 'all') {
$map['l.verify_stage'] = $reviewStage;
}
$total = Db::name('register_log')->alias('l')
->field('l.register_id')
->where($map)
->count();
$list = Db::name('register_log')->alias('l')
->field('l.register_id,l.memo,l.teacher_name,l.created_time,l.verify_stage,l.operation,l.type,l.teacher_id,l.teacher_name')
->where($map)
->order('l.created_time', 'desc')
->select();
if($list) {
foreach ($list as &$val) {
switch ($val['type']) {
case 'teacher':
$val['type'] = '教师';
break;
case 'collage':
$val['type'] = '学院';
break;
default:
$val['type'] = '学校';
}
switch ($val['verify_stage']) {
case 0:
$val['verify_stage'] = '立项';
break;
case 1:
$val['verify_stage'] = '中期检查';
break;
default:
$val['verify_stage'] = '结题';
}
}
}
$this->assign('login','');
$this->view->assign('list',$list);//首页隐藏头部使用
return $this->view->fetch();
}
}