Project.php 5.6 KB
<?php


namespace app\teacher\controller;


use app\common\controller\TeacherBase;
use app\common\model\Member;
use app\school\model\setting\ProjectContainer;
use app\school\model\setting\ProjectType;
use app\teacher\model\ProjectRegister;
use think\Db;

class Project extends TeacherBase
{
    public function _initialize()
    {
        $this->model = new ProjectRegister();
        return parent::_initialize(); // TODO: Change the autogenerated stub
    }

    /**
     * @return string|\think\response\Json
     * @throws \think\Exception
     * 首页视图
     */
    public function index(){
        list($where, $sort, $order, $offset, $limit) = $this->buildparams();
        $teacherInfo = $this->getSessionData();
        $list = (new ProjectContainer()) -> alias('c')
            ->field('c.*')
            ->join('project_register r','c.id = r.container_id','left')
            ->join('members m','r.id = m.item_id AND m.member_source = 2 AND m.member_type = 2')
            ->where(['m.member_id' => $teacherInfo['id']])
            ->order('c.createtime','desc')
            ->group('c.id')
            ->paginate(8);
        $typeModel = new ProjectType();
        foreach ($list as $k=> $v){
            $typeInfo = $typeModel->alias('t')
                ->field('t.id as type_id,t.name type_name,count(m.member_id) `count`')
                ->join('project_register r',"r.project_type = t.id",'left')
                ->join('members m',"r.id = m.item_id AND m.member_source = 2 AND m.member_type = 2 AND m.member_id = {$teacherInfo['id']}",'left')
                ->where(['t.container_id' => $v['id']])
                ->where('r.deletetime',null)
                ->group('t.id')
                ->select();
            $typeInfo = collection($typeInfo)->toArray();
            $v["count"] = array_sum(array_column($typeInfo,'count'));
            $tmp = [];
            foreach ($typeInfo as $key => $val){
                $tmp[$key] = $val;
            }
            $v['type'] = $tmp;
            $list[$k] = $v;
        }
        $this->assign("list",$list);
        return $this->view->fetch();
    }

    /*public function index(){
        list($where, $sort, $order, $offset, $limit) = $this->buildparams();
        $data = $this->model->where($where)->where("school_id", $this->school_id)->column("container_id");
        $container_ids = array_unique($data);
        $total = Db::name('project_container')->whereIn("id",$container_ids)->count();
        $teacherId = $this->auth['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)
            ->limit($offset,$limit)
            ->order("createtime","desc")
            ->select();
        $typeModel = new ProjectType();
        foreach ($list as $k=>$v){
            $v["count"] = $this->model->where("container_id","=",$v['id'])->where(['project_teacher_ids' => $teacherId])->count();

            $typeInfo = $typeModel->alias('t')
                ->field('t.id as type_id,t.name type_name,count(r.id) `count`')
                ->join('project_register r',"r.project_type = t.id and r.project_teacher_ids = {$teacherId}",'left')
                ->where(['t.container_id' => $v['id'] ])
                ->where('r.deletetime',null)
                ->group('t.id')
                ->select();
            foreach ($typeInfo as $key=>$val){
                $v['type'][$key] = $val;
            }
            $list[$k] = $v;
        }

        $res = [
            'total' => $total,
            'rows'   => $list
        ];
        $this->assign("res",$res);
        return $this->view->fetch();
    }*/

    /**
     * 获取教师未审核项目
     */
    public function getContainer(){
        list($where, $sort, $order, $offset, $limit) = $this->buildparams();

        $data = $this->model->where($where)->where("school_id", $this->school_id)->column("container_id");
        $container_ids = array_unique($data);
        $total = Db::name('project_container')->whereIn("id",$container_ids)->count();
        $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)->limit($offset,$limit)->select();

        foreach ($list as $k=>$v){
            $v["count"] = $this->model->where("container_id","=",$v['id'])->count();
            $sql = "SELECT t.id type_id ,t.name type_name,count(r.id) `count`, group_concat( r.project_member_ids ) member 
                    FROM fa_project_type t
                    LEFT JOIN fa_project_register r ON t.id = r.project_type 
                    WHERE t.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'] = count(explode(",",$val['member']));
                }else{
                    $val['member'] =  0;
                }
                $v['type'][$key] = $val;
            }
            $list[$k] = $v;
        }
      
        $res = [
            'total' => $total,
            'rows'   => $list
        ];
        return $res;
    }

}