ProjectSummary.php 3.5 KB
<?php

namespace app\school\controller;

use app\common\controller\DoubleBase;
use app\school\controller\project_common\ProjectData;
use app\school\model\project_common\ProjectRegister;
use think\Db;
use fast\Export;

class ProjectSummary extends DoubleBase
{
    protected $containerId = null;
    protected $shopIdAutoCondition = false;
    protected $model = null;

    use ProjectData;

    public function _initialize()
    {
        parent::_initialize();
        $this->containerId = $_COOKIE['container_id'];
        $this->model = new ProjectRegister();
    }

    public function index() {
        if ($this->request->isAjax()) {
            $map = [];
            $filter = json_decode($this->request->get('filter'), true);
            //自定义搜索条件
            if(isset($filter['project_type'])) {
                $map['a.project_type'] =  $filter['project_type'];
            }
            if(isset($filter['project_level'])) {
                $map['a.project_level'] =  $filter['project_level'];
            }
            if(isset($filter['college_id'])) {
                $map['u.college'] =  $filter['college_id'];
            }
            if(isset($filter['username'])) {
                $map['u.nickname'] = ['like',"%{$filter['username']}%"];
            }
            $map['a.project_status'] =  ['IN', '0,1,2,3'];
            if ($this->auth->rule_type == 1){
                //所属学院或部门
                $map['a.project_college'] =  $this->auth->college_id;
            }
            $res = $this->projectData($map);
            foreach ($res['rows'] as &$row) {
                // 已经中期评审或者立项结题的项目状态为:已立项、已提交
                if ('0' != $row['review_stage']) {
                    $row['check_stage'] = 3;
                }
            }
            return $res;
        }
        return $this->view->fetch();
    }

    /**
     * 导出数据(全部数据)
     */
    public function export()
    {
        //获取sql  数量
        $map = [];
        $map['a.project_status'] =  ['IN', '0,1,2,3'];
        if ($this->auth->rule_type == 1){
            //所属学院或部门
            $map['a.project_college'] =  $this->auth->college_id;
        }
        $result = $this->getExportSql($map);
        $sqlInfo = collection($result)->toArray();
        if($sqlInfo['total'] == 0){
            $this->error('暂无可导出数据');
        }

        //开始导出
        $export = new Export();
        $export->setCount($sqlInfo['total']);
        $export->setSql($sqlInfo['sql']);
        $export->setFileName(time().'export');
        $export->setDirName(date('Y-m-d'));
        $export->setHeader(['Id','项目名称','项目编号','项目分类','项目所属学院','负责人姓名','负责人学号','负责人学院','负责人专业','项目级别','项目状态']);
        $export->setFields('id,project_name,project_no,project_type_name,project_college,nickname,student_no,college_name,major_name,project_level,check_stage');

        $exportRes = $export->out();
        if($exportRes) {
            $url = $export->getUrl();
            header( "Content-Type: application/zip" );
            header( "Content-Transfer-Encoding: Binary" );
            header( "Content-Length: " . filesize ($url));
            header( "Content-Disposition: attachment; filename=\"".basename ($url)."\"" );
            readfile( $url);
            exit ;
        }else{
            $this->error('导出失败,稍后请重新尝试');
        }
    }
}