Judge.php
4.5 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
<?php
namespace app\school\controller\project_common;
use app\common\controller\DoubleBase;
use app\common\model\Territory;
use app\school\model\project_common\ProjectReviewScore;
use app\school\model\setting\ProjectExperts;
use think\Db;
use think\Exception;
class Judge extends DoubleBase
{
protected $containerId = null;
protected $model = null;
public function _initialize()
{
parent::_initialize();
$this->containerId = isset($_COOKIE['container_id']) ? $_COOKIE['container_id'] : '';
$this->model = new ProjectExperts();
$this->view->assign("territoryList", Territory::getTerritoryList());
}
/**
* 添加评委-列表页
*/
public function index()
{
if ($this->request->isAjax()) {
list($where, $sort, $order, $offset, $limit) = $this->buildparams();
$projectIds = $this->request->param('project_ids');
$reviewId = $this->request->param('review_id');
$reviewStage = $this->request->param('review_stage');
// 项目已分配的专家不再显示
$ignoreJudges = array_column(ProjectReviewScore::all(
['review_stage' => $reviewStage, 'project_register_id' => ['IN', $projectIds], 'review_id' => $reviewId]), 'judge_id');
$judgeWhere = ['id' => ['NOT IN', $ignoreJudges]];
$total = $this->model->where($where)->where($judgeWhere)->count();
$rows = $this->model
//->where('type','review')
->field('id, nickname, gender, email, mobile,territory_id')
->where($where)
->where($judgeWhere)
->order('id','desc')
->limit($offset, $limit)
->select();
$rows = collection($rows)->toArray();
$territoryModel = new Territory();
foreach ($rows as &$value) {
$territoryInfo = $territoryModel->whereIn('id',$value['territory_id'])->column('territory_name');
$value['territory_name'] = $territoryInfo ? implode(',',$territoryInfo) : '--';
}
$res = [
'total' => $total,
'rows' => $rows
];
return $res;
}
return $this->fetch();
}
/**
* 添加评委-接口
*/
public function addJudge()
{
if ($this->request->isAjax()) {
$data = $this->request->param('data_json');
$data = json_decode($data, true);
Db::startTrans();
try {
$reviewScoreModel = new ProjectReviewScore();
$reviewScoreModel->saveAll($data);
Db::commit();
} catch (Exception $e) {
Db::rollback();
$this->error($e->getMessage());
}
$this->success();
return $data;
}
}
/**
*审核信息
*/
public function verify_list()
{
$reviewStage = request()->param('review_stage');
$registerId = request()->param('register_id');
if ($this->request->isAjax()) {
list($where, $sort, $order, $offset, $limit) = $this->buildparams();
$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')
->limit($offset, $limit)
->select();
// foreach ($list as &$val) {
// if($val['type'] == 'teacher') {
// $val['teacher_name'] = Db::name('teacher')->where(['id' => $val['teacher_id']])->find()['username'];
// }else{
// $val['teacher_name'] = Db::name('manystore')->where(['id' => $val['teacher_id']])->find()['nickname'];
// }
// }
$result = array("total" => $total, "rows" => $list);
return json($result);
}
$this->assignconfig('reviewStage',$reviewStage);
$this->assignconfig('register_id',$registerId);
return $this->view->fetch();
}
}