DcProject.php 1.1 KB
<?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();
    }

}