Double.php 4.5 KB
<?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;
    }
}