Double.php 7.3 KB
<?php


namespace app\index\controller;


use app\common\controller\Frontend;
use app\common\model\TemplateView;
use app\school\model\project_common\ProjectDoubleApply;
use app\school\model\setting\ProjectContainer;
use app\teacher\model\basic\Teacher;
use think\Db;

class Double extends Frontend
{
    protected $noNeedLogin = '*';
    protected $noNeedRight = '*';
    protected $layout = 'default';
    protected $template = 'weilai';
    public function _initialize()
    {
        parent::_initialize(); // TODO: Change the autogenerated stub
        $template = TemplateView::getSchoolTemplate( $this->school_id);
        $this->layout = $template->layout ?? 'default';
        $this->template = $template->template_url;
    }

    public function double_list(){
        $type = $this->request->param('type');
        $type = isset($type) ? $type :0;
        $where["school_id"] = $this->school_id;
        $user = $this->auth->getUser();
        switch ($type){
            case 1://教师
                $where['captain_type'] = 1;
                break;
            case 2://学生
                $where['captain_type'] = 0;
                break;
        }
        $where['is_recruit'] = 1;
        $list = Db::name("project_double")->order('createtime desc')->where($where)->paginate(10,false,["query"=>request()->param()]);
//        $count = Db::name("project_double")->where($where)->count();
        foreach ($list as $k=>$v){
            $v["is_can"]  =0;
            if($v['is_complete'] ==1){
                $v["is_can"]  = 2;
            }else{
                if($user) {
                    $info_apply = Db::name("project_double_apply")->where(["project_double_id" => $v['id'], "proposer_id" => $user["id"], "proposer_type" => 0])->find();
                    if ($info_apply) {
                        $v["is_can"] = 1;
                    } else {
                        $v["is_can"] = 0;
                    }
                }else{
                    $v["is_can"] = 0;
                }
            }
            if($v['is_recruit'] ==0){
                $v["is_can"]  = -1;
            }
            $container_name = Db::name("project_container")->where("id",$v["project_container_id"])->value("container_name");
            $type_name = Db::name("project_type")->where("id",$v['project_type'])->value("name");
            $v["container"] = $container_name ."--".$type_name;
            $list[$k] = $v;
        }
        $arr = [];
        if($list) {
            $arr = sortArrByManyField($list->items(),'is_can',SORT_ASC,'is_complete',SORT_ASC);
        }
        $render = $list->render();
        $count = count($arr);
        $this->assign("index","1");
        $this->assign("type",$type);
        $this->assign("count",$count);
        $this->assign("double_list",$arr);
        $this->assign("render",$render);
        return $this->view->fetch();
    }

    public function double_detail()
    {
        if(!$this->auth->getUser()) {
            $this->redirect('index/student_login/index');
        }
        $param= $this->request->param();
        $user_id = Db::name("project_double_apply")->where(["project_double_id"=>$param["id"],"proposer_type"=>0,"sort"=>1])->value("proposer_id");
        $user = (new \app\school\model\basic\User())->where(['id' => $user_id])->find();
        if(!empty($user)){
            $sort =Db::name("project_double_apply")->where(["project_double_id"=>$param["id"],"proposer_type"=>0,"proposer_id"=>$user['id']])->value("sort");
            $user['specialty'] = $user['specialty_text'];
            $user['college']   = $user['college_text'];
        }else{
            $sort = 1;
        }


        $info = Db::name("project_double")->where("id",$param["id"])->find();
        $info["apply"] = (new ProjectDoubleApply())->where("project_double_id",$info["id"])->select();
        $container_info =(new ProjectContainer())->where("id",$info['project_container_id'])->find();
        if($this->auth->id == $info['user_id']){
            $info["operation"] = 1;
        }else{
            $info["operation"] = 0;
        }
        $have_teacher = 0;
        $have_student = 0;
        foreach($info['apply'] as $k=>$v){
            if($v['proposer_type'] == 0){//学生信息
                $have_student = 1;
                $user_ = (new \app\school\model\basic\User())->where(['id' => $v['proposer_id']])->find();
                $v['username'] = $user_['nickname'];
                $v['specialty'] = $user_['specialty_text'];
            }else{//指导教师信息
                $have_teacher = 1;
                $user_ = (new \app\school\model\basic\Teacher())->where(['id'=>$v['proposer_id']])->find();
                $v['username'] = $user_['username'];
                $v['job_num'] = $user_['job_num'];
                $v['teacher_id'] = $user_['id'];
                $v['college'] = $user_['college_text'];
            }
            $info['apply'][$k] = $v;
        }

        $this->assign("sort",$sort);
        $this->assign("have_student",$have_student);
        $this->assign("have_teacher",$have_teacher);
        $this->assign("user_info",$user);
        $this->assign("container_info",$container_info);
        $this->assign("info",$info);
        return $this->view->fetch();
    }

    public function add_apply(){
        if($this->request->isAjax()){

            if($this->auth->isLogin()){
                $user = $this->auth->getUserinfo();
            }else{
                $this->error("请登录",url('student_login/index'));
            }
            $param = $this->request->param("row/a");
            $info =  Db::name('project_double')->where("id",$param['double_id'])->find();
            $data = Db::name('project_double_apply')->where("project_double_id",$param['double_id'])->where("proposer_id",$user['id'])->where("proposer_type",0)->find();
            $data = [];
            if(!empty($data)){
                $this->error("请勿重复申报");
            }else{
                if(empty($param['mobile'])) {
                    $this->error("请填写手机号码");
                }
                if(!checkMobile($param['mobile'])) {
                    $this->error("请填写正确的手机号码");
                }
                if(empty($param['proposer_details'])) {
                    $this->error("请填写申请理由和个人简介");
                }
                $sort = Db::name('project_double_apply')->where("project_double_id",$param['double_id'])->where('proposer_type',0)->max("sort");
                if($sort){
                    $sort += 1;
                }else{
                    $sort = 1;
                }

                $insert["project_double_id"] = $param['double_id'];;
                $insert["proposer_id"] = $user['id'];
                $insert["proposer_type"] = 0;
                $insert["proposer_state"] = 0;
                $insert["proposer_details"] = $param['proposer_details'];
                $insert["mobile"] = $param['mobile'];
                $insert["container_id"] = $info['project_container_id'];
                $insert["sort"] = $sort;
                $insert["createtime"] = time();
                $status = Db::name('project_double_apply')->insert($insert);
                if($status){
                    $this->success("申请成功",url('create/my_double'));
                }else{
                    $this->error("申请失败,请联系系统管理员");
                }
            }
        }
    }
}