Double.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
<?php
namespace app\teacher\controller;
use app\common\controller\TeacherBase;
use app\teacher\model\ProjectRegister;
use think\Db;
class Double extends TeacherBase
{
public function _initialize()
{
$this->ProjectRegister = new ProjectRegister();
$this->teacher = $this->getSessionData();
return parent::_initialize(); // TODO: Change the autogenerated stub
}
/**
* @return string|\think\response\Json
* @throws \think\Exception
* 项目双选视图
*/
public function index(){
$teacher = $this->teacher;
$total = Db::name('project_container')->where("can_apply_double",1)->whereRaw("project_double_starttime < ".time()." and project_double_endtime > ". time())->where("school_id", $this->school_id)->count();
$container_ids = Db::name('project_container')->where("can_apply_double",1)->whereRaw("project_double_starttime < ".time()." and project_double_endtime > ". time())->where("school_id", $this->school_id)->column("id");
$list = Db::name('project_container')
->field('id,container_name,can_apply_double,project_double_starttime,project_double_endtime,can_apply_approval,project_starttime,project_endtime,can_apply_mid,midterm_review_starttime,midterm_review_endtime,can_apply_conclusion,conclusion_starttime,conclusion_endtime')
->whereIn("id",$container_ids)
->order("createtime","desc")
->paginate(5,false,['query'=>request()->param()]);
foreach ($list as $k=>$v){
$v["count"] = Db::name('project_double')->where("project_container_id","=",$v['id'])->count();
$sql = "SELECT t.id type_id ,t.name type_name,count(r.id) `count`,r.id id
FROM fa_project_type t
LEFT JOIN fa_project_double r ON t.id = r.project_type
WHERE t.container_id = ".$v['id']."
GROUP BY t.id";
$v['type'] = Db::query($sql);
foreach ($v['type'] as $key=>$val){
$double_ids = Db::name("project_double")->where(["project_type"=>$val['type_id'],"project_container_id"=>$v['id']])->column("id");
$val['member'] = Db::name('project_double_apply')->where('project_double_id',"in",$double_ids)->count();//
$v['type'][$key] = $val;
}
$list[$k] = $v;
}
$res = [
'total' => $total,
'rows' => $list
];
$this->assign("res",$res);
return $this->view->fetch();
}
public function doublelist(){
$param = $this->request->param();
return $this->view->fetch();
}
/**
* @return array
* @throws \think\Exception
* @throws \think\db\exception\DataNotFoundException
* @throws \think\db\exception\ModelNotFoundException
* @throws \think\exception\DbException
* 获取教师的双选项目数据
*/
public function getDouble(){
list($where,$sort,$order,$offset,$limit) = $this->buildparams();
$teacher = $this->auth;
$total = Db::name('project_container')->where(['school_id'=>$teacher["school_id"]])->count();
$list = Db::name('project_container')
->field('id,container_name,project_double_starttime,project_double_endtime')
->where(['school_id'=>$teacher["school_id"]])
->limit($offset,$limit)
->order($sort,$order)
->select();
foreach ($list as $k=>$v){
$v['total_member'] = 0;
$v["project_double_starttime"] = date("Y-m-d H:i:s",$v["project_double_starttime"]);
$v["project_double_endtime"] = date("Y-m-d H:i:s",$v["project_double_endtime"]);
$sql = "SELECT t.id type_id ,t.project_name type_name,count(r.id) `count`
FROM fa_project_double t
LEFT JOIN fa_project_double_apply r ON t.id = r.project_double_id
WHERE t.project_container_id = ".$v['id']." and (r.deletetime is null or r.deletetime ='')
GROUP BY t.id";
$v['type'] = Db::query($sql);
foreach ($v['type'] as $key=>$val){
if(!empty($val['member'])){
$val['member'] = $val['count'];
}else{
$val['member'] = 0;
}
$v['total_member'] += $val['count'];
$v['type'][$key] = $val;
}
$list[$k] = $v;
}
$res = [
"rows" => $list,
"total" => $total
];
return $res;
}
}