DcProject.php
1.1 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
<?php
namespace app\index\controller;
use app\common\controller\Frontend;
use app\school\model\setting\ProjectContainer;
use think\View;
class DcProject extends Frontend
{
protected $noNeedLogin = '*';
protected $noNeedRight = '*';
protected $layout = 'default';
public function _initialize()
{
parent::_initialize(); // TODO: Change the autogenerated stub
$this->assign('index','index');
}
public function index()
{
# 查询所有大创项目
$projectContainerVo = new ProjectContainer();
$projects = $projectContainerVo
->field('c.*,count(p.id) as item_count')
->alias('c')
->where("c.school_id",$this->school_id)
->where(['c.school_id' => $this->school_id,'c.is_open' => 1])
->join('project_register p','c.id = p.container_id','left')
->order('c.createtime','desc')
->group('c.id')
->paginate(4);
// $projects = $projectContainerVo->paginate(10);
$this->assign('_list',$projects);
return $this->view->fetch();
}
}