Double.php 5.9 KB
<?php

namespace app\school\controller;

use app\common\controller\DoubleBase;
use app\school\model\project_common\ProjectRegister;
use app\school\model\setting\ProjectContainer;
use think\Db;
use think\Exception;

class Double extends DoubleBase
{
    protected $containerId = null;
    protected $model = null;

    public function _initialize()
    {
        parent::_initialize();

        if ( empty($_COOKIE['container_id']) ) {
            $this->redirect(url('school/index/transfer'));
        }

        $this->containerId = $_COOKIE['container_id'];
        $this->model = new ProjectRegister();
    }

    public function index() {

        $projectTotalNum = $this->model->where("container_id", $this->containerId)->count();
        $containerData = (new ProjectContainer())->where('id', $this->containerId)->find();

        $containerData['project_starttime'] = !empty($containerData['project_starttime']) ? date('Y-m-d', $containerData['project_starttime']) : date('Y-m-d');
        $containerData['project_endtime'] = !empty($containerData['project_endtime']) ? date('Y-m-d', $containerData['project_endtime']) : date('Y-m-d');


        $containerData['project_double_starttime'] = date('Y-m-d', $containerData['project_double_starttime']);
        $containerData['project_double_endtime'] = date('Y-m-d', $containerData['project_double_endtime']);
        
        $containerData['midterm_review_starttime'] = !empty($containerData['midterm_review_starttime']) ? date('Y-m-d', $containerData['midterm_review_starttime']) : date('Y-m-d');
        $containerData['midterm_review_endtime'] = !empty($containerData['midterm_review_endtime']) ? date('Y-m-d', $containerData['midterm_review_endtime']) : date('Y-m-d');

        $containerData['conclusion_starttime'] = !empty( $containerData['conclusion_starttime']) ?date('Y-m-d', $containerData['conclusion_starttime']) : date('Y-m-d');
        $containerData['conclusion_endtime'] = !empty( $containerData['conclusion_endtime']) ? date('Y-m-d', $containerData['conclusion_endtime']) : date('Y-m-d');

        $data['project_competition'] = Db::name("project_competition")->where("container_id",$this->containerId)->count();//竞赛获奖
        $data['project_paper'] = Db::name("project_paper")->where("container_id",$this->containerId)->count();//发表论文
        $data['project_patent'] = Db::name("project_patent")->where("container_id",$this->containerId)->count();//申请专利
        $data['project_copyright'] = Db::name("project_copyright")->where("container_id",$this->containerId)->count();//著作权
        $data['project_production'] = Db::name("project_production")->where("container_id",$this->containerId)->count();//实物
        $projectDetails['total_num'] = $projectTotalNum;
        $data['projecr_examine'] =  Db::name("project_register")->where(["project_status"=>0,"check_stage"=>0])->where("container_id",$this->containerId)->count();//待审核项目
        $regiter_ids = Db::name("project_register")->where("container_id",$this->containerId)->column("id");
        $data['member_change']   =  Db::name("project_change_members")->where("status",0)->whereIn('register_id',$regiter_ids)->count();//待审核变更成员
        $data['yanqi'] =  Db::name("project_register")->where("container_id",$this->containerId)->where("project_status",3)->count();//待审核延期结题
//        $data['projecr_examine'] =  Db::name("project_register")->where("container_id",$this->containerId)->count();//待审核终止项目
        $this->assignconfig('container_data', $containerData);
        $this->assign('data', $data);
        $this->assign('container_data', $containerData);
        $this->assign('project_details', $projectDetails);
        return $this->view->fetch();
    }

    public function editContainer()
    {
        if ($this->request->isAjax()) {
            // 项目状态在各个审核阶段是否改变过(0:没改变过;1:在立项时改变过;2:在中期评审时改变过;3:在项目结题时改变过),用于决定报名表和项目的一些设置能否修改
            $applyStatusLogMap = [
                'is_open' => 0,
                'can_apply_double' => 0,
                'can_apply_approval' => 1,
                'can_apply_mid' => 2,
                'can_apply_conclusion' => 3
            ];

            $data = $this->request->param('row/a');
            $stateName = array_keys($data)[0];
            // 记录项目在哪些阶段改变过状态
            $data['apply_status_log'] = $applyStatusLogMap[$stateName];
            Db::startTrans();
            try {
                (new ProjectContainer())->allowField(true)->save($data, ['id' => $this->containerId]);
                Db::commit();
            } catch (Exception $e) {
                Db::rollback();
                $this->error($e->getMessage());
            }
            $this->success();
        }
    }

    /**
     * 修改项目双选的时间
     */
    public function editDoubleDateTime()
    {
        if ($this->request->isAjax()) {
            $row = $this->request->param();
            if(is_array($row)){
                $endTime = ['project_endtime', 'midterm_review_endtime', 'conclusion_endtime'];
                foreach ($row as $k => $v){
                    if(in_array($k,$endTime)) {
                        $row[$k] = strtotime(date('Y-m-d 23:59:59', strtotime($v)));
                    }else{
                        $row[$k] = strtotime($v);

                    }
                }
            }else{
                $this->error("数据类型错误,请联系管理员");
            }

            Db::startTrans();
            try {
                (new ProjectContainer())->allowField(true)->save($row,['id' => $this->containerId]);
                Db::commit();
            } catch (Exception $e) {
                Db::rollback();
                $this->error($e->getMessage());
            }
            $this->success();
        }
    }
}