Double.php
5.9 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
<?php
namespace app\school\controller;
use app\common\controller\DoubleBase;
use app\school\model\project_common\ProjectRegister;
use app\school\model\setting\ProjectContainer;
use think\Db;
use think\Exception;
class Double extends DoubleBase
{
protected $containerId = null;
protected $model = null;
public function _initialize()
{
parent::_initialize();
if ( empty($_COOKIE['container_id']) ) {
$this->redirect(url('school/index/transfer'));
}
$this->containerId = $_COOKIE['container_id'];
$this->model = new ProjectRegister();
}
public function index() {
$projectTotalNum = $this->model->where("container_id", $this->containerId)->count();
$containerData = (new ProjectContainer())->where('id', $this->containerId)->find();
$containerData['project_starttime'] = !empty($containerData['project_starttime']) ? date('Y-m-d', $containerData['project_starttime']) : date('Y-m-d');
$containerData['project_endtime'] = !empty($containerData['project_endtime']) ? date('Y-m-d', $containerData['project_endtime']) : date('Y-m-d');
$containerData['project_double_starttime'] = date('Y-m-d', $containerData['project_double_starttime']);
$containerData['project_double_endtime'] = date('Y-m-d', $containerData['project_double_endtime']);
$containerData['midterm_review_starttime'] = !empty($containerData['midterm_review_starttime']) ? date('Y-m-d', $containerData['midterm_review_starttime']) : date('Y-m-d');
$containerData['midterm_review_endtime'] = !empty($containerData['midterm_review_endtime']) ? date('Y-m-d', $containerData['midterm_review_endtime']) : date('Y-m-d');
$containerData['conclusion_starttime'] = !empty( $containerData['conclusion_starttime']) ?date('Y-m-d', $containerData['conclusion_starttime']) : date('Y-m-d');
$containerData['conclusion_endtime'] = !empty( $containerData['conclusion_endtime']) ? date('Y-m-d', $containerData['conclusion_endtime']) : date('Y-m-d');
$data['project_competition'] = Db::name("project_competition")->where("container_id",$this->containerId)->count();//竞赛获奖
$data['project_paper'] = Db::name("project_paper")->where("container_id",$this->containerId)->count();//发表论文
$data['project_patent'] = Db::name("project_patent")->where("container_id",$this->containerId)->count();//申请专利
$data['project_copyright'] = Db::name("project_copyright")->where("container_id",$this->containerId)->count();//著作权
$data['project_production'] = Db::name("project_production")->where("container_id",$this->containerId)->count();//实物
$projectDetails['total_num'] = $projectTotalNum;
$data['projecr_examine'] = Db::name("project_register")->where(["project_status"=>0,"check_stage"=>0])->where("container_id",$this->containerId)->count();//待审核项目
$regiter_ids = Db::name("project_register")->where("container_id",$this->containerId)->column("id");
$data['member_change'] = Db::name("project_change_members")->where("status",0)->whereIn('register_id',$regiter_ids)->count();//待审核变更成员
$data['yanqi'] = Db::name("project_register")->where("container_id",$this->containerId)->where("project_status",3)->count();//待审核延期结题
// $data['projecr_examine'] = Db::name("project_register")->where("container_id",$this->containerId)->count();//待审核终止项目
$this->assignconfig('container_data', $containerData);
$this->assign('data', $data);
$this->assign('container_data', $containerData);
$this->assign('project_details', $projectDetails);
return $this->view->fetch();
}
public function editContainer()
{
if ($this->request->isAjax()) {
// 项目状态在各个审核阶段是否改变过(0:没改变过;1:在立项时改变过;2:在中期评审时改变过;3:在项目结题时改变过),用于决定报名表和项目的一些设置能否修改
$applyStatusLogMap = [
'is_open' => 0,
'can_apply_double' => 0,
'can_apply_approval' => 1,
'can_apply_mid' => 2,
'can_apply_conclusion' => 3
];
$data = $this->request->param('row/a');
$stateName = array_keys($data)[0];
// 记录项目在哪些阶段改变过状态
$data['apply_status_log'] = $applyStatusLogMap[$stateName];
Db::startTrans();
try {
(new ProjectContainer())->allowField(true)->save($data, ['id' => $this->containerId]);
Db::commit();
} catch (Exception $e) {
Db::rollback();
$this->error($e->getMessage());
}
$this->success();
}
}
/**
* 修改项目双选的时间
*/
public function editDoubleDateTime()
{
if ($this->request->isAjax()) {
$row = $this->request->param();
if(is_array($row)){
$endTime = ['project_endtime', 'midterm_review_endtime', 'conclusion_endtime'];
foreach ($row as $k => $v){
if(in_array($k,$endTime)) {
$row[$k] = strtotime(date('Y-m-d 23:59:59', strtotime($v)));
}else{
$row[$k] = strtotime($v);
}
}
}else{
$this->error("数据类型错误,请联系管理员");
}
Db::startTrans();
try {
(new ProjectContainer())->allowField(true)->save($row,['id' => $this->containerId]);
Db::commit();
} catch (Exception $e) {
Db::rollback();
$this->error($e->getMessage());
}
$this->success();
}
}
}