Projectitem.php 5.2 KB
<?php

namespace app\index\controller;

use app\common\controller\Frontend;
use app\common\model\Member;
use app\expert\model\ProjectRegister;
use app\index\model\ItemDelay;
use app\index\model\ProjectChangeMembers;
use think\Db;
use think\Exception;

class Projectitem extends Frontend
{

    protected $noNeedLogin = [];
    protected $noNeedRight = '*';
    protected $layout = 'default';
    protected $model = null;
    CONST PARAMS_ERROR = '参数错误';
    CONST BAD_REQUEST  = '非法请求';
    CONST NOT_FOUND  = '作品不存在';
    CONST DELAY_APPLY  = '您已申请项目延期';

    public function _initialize()
    {
        parent::_initialize();
        $this->model = new ProjectRegister();
        $userInfo = $this->auth->getUser();
    }

    public function index()
    {
        // 查询学生参与的作品
        $memberModel = new Member();
        $list = $memberModel->alias('m')
            ->field('m.is_captain,r.*,pc.container_name , pt.name , pc.midterm_review_starttime, pc.midterm_review_endtime,pc.conclusion_starttime,pc.conclusion_endtime,pc.container_desc,pc.project_starttime,pc.project_endtime,pc.project_double_starttime,pc.project_double_endtime,pc.can_apply_mid,pc.can_apply_conclusion,pc.can_apply_approval')
            ->join('project_register r','m.item_id = r.id','inner')
            ->join('project_container pc','pc.id = r.container_id','left')
            ->join('project_type pt','pt.id = r.project_type','left')
            ->where(['m.member_type' => Member::STUDENT,'m.member_source' => Member::PROJECT,'m.member_id' => $this->auth->id])
            ->where('r.deletetime',null)
            ->order('r.createtime','desc')
            ->paginate(1);
        $count = $memberModel->alias('m')
            ->field('m.id')
            ->join('project_register r','m.item_id = r.id','inner')
            ->join('project_container pc','pc.id = r.container_id','left')
            ->join('project_type pt','pt.id = r.project_type','left')
            ->where(['m.member_type' => Member::STUDENT,'m.member_source' => Member::PROJECT,'m.member_id' => $this->auth->id])
            ->where('r.deletetime',null)
            ->count();
        $this->assign('_list',$list);
        $this->assign('login_id',$this->auth->id);
        $this->assign('_list_count',$count);

        return $this->view->fetch();
    }

    // 项目延期申请
    public function subject_delay(){
        if (!request()->post()) $this->error(self::BAD_REQUEST);
        $item_id = request()->param('item_id',false);
        $delay_memo = request()->param('delay_memo',null);
        if (!$item_id) $this->error(self::PARAMS_ERROR);
        $item = $this->model->where('id',$item_id)->find();
        if (!$item) $this->error(self::NOT_FOUND);
        $_delay = ItemDelay::get(['register_id'=>$item_id]);
        if ($_delay){
            $this->error(self::DELAY_APPLY);
        }
        $created['register_id'] = $item_id;
        $created['delay_memo']  = $delay_memo;
        try {
            ItemDelay::create($created);
        }catch (Exception $e){
            $this->error($e->getMessage());
        }
        $this->success("申请项目延期成功");
    }


    /**
     *  变更成员申请
     */
    public function member_change(){
        $register_id = request()->param('register_id');
        $projectChangeMembersModel = new ProjectChangeMembers();
        $changeMembers = $projectChangeMembersModel->where('register_id',$register_id)->paginate(5);
        $this->assign('change_members',$changeMembers);
        return $this->fetch();
    }


    /**
     *审核信息
     */
    public function verify_list()
    {
        $reviewStage = request()->param('review_stage');
        $registerId  = request()->param('register_id');

        $map['l.register_id'] = $registerId;
        if($reviewStage != 'all') {
            $map['l.verify_stage'] = $reviewStage;
        }
        $total =  Db::name('register_log')->alias('l')
            ->field('l.register_id')
            ->where($map)
            ->count();
        $list =  Db::name('register_log')->alias('l')
            ->field('l.register_id,l.memo,l.teacher_name,l.created_time,l.verify_stage,l.operation,l.type,l.teacher_id,l.teacher_name')
            ->where($map)
            ->order('l.created_time', 'desc')
            ->select();
        if($list) {
            foreach ($list as &$val) {
                switch ($val['type']) {
                    case 'teacher':
                        $val['type'] =  '教师';
                        break;
                    case 'collage':
                        $val['type'] =  '学院';
                        break;
                    default:
                        $val['type'] =  '学校';
                }
                switch ($val['verify_stage']) {
                    case 0:
                        $val['verify_stage'] =  '立项';
                        break;
                    case 1:
                        $val['verify_stage'] =  '中期检查';
                        break;
                    default:
                        $val['verify_stage'] =  '结题';
                }
            }
        }
        $this->assign('login','');
        $this->view->assign('list',$list);//首页隐藏头部使用

        return $this->view->fetch();
    }

}