Judge.php 4.5 KB
<?php

namespace app\school\controller\project_common;

use app\common\controller\DoubleBase;
use app\common\model\Territory;
use app\school\model\project_common\ProjectReviewScore;
use app\school\model\setting\ProjectExperts;
use think\Db;
use think\Exception;

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

    public function _initialize()
    {
        parent::_initialize();
        $this->containerId = isset($_COOKIE['container_id']) ? $_COOKIE['container_id'] : '';
        $this->model = new ProjectExperts();
        $this->view->assign("territoryList", Territory::getTerritoryList());
    }

    /**
     * 添加评委-列表页
     */
    public function index()
    {
        if ($this->request->isAjax()) {
            list($where, $sort, $order, $offset, $limit) = $this->buildparams();
            $projectIds = $this->request->param('project_ids');
            $reviewId = $this->request->param('review_id');
            $reviewStage = $this->request->param('review_stage');
            // 项目已分配的专家不再显示
            $ignoreJudges = array_column(ProjectReviewScore::all(
                ['review_stage' => $reviewStage, 'project_register_id' => ['IN', $projectIds], 'review_id' => $reviewId]), 'judge_id');
            $judgeWhere = ['id' => ['NOT IN', $ignoreJudges]];

            $total = $this->model->where($where)->where($judgeWhere)->count();
            $rows = $this->model
                //->where('type','review')
                ->field('id, nickname, gender, email, mobile,territory_id')
                ->where($where)
                ->where($judgeWhere)
                ->order('id','desc')
                ->limit($offset, $limit)
                ->select();
            $rows = collection($rows)->toArray();
            $territoryModel = new Territory();
            foreach ($rows as &$value) {
                $territoryInfo = $territoryModel->whereIn('id',$value['territory_id'])->column('territory_name');
                $value['territory_name'] = $territoryInfo ? implode(',',$territoryInfo) : '--';
            }
            $res = [
                'total' => $total,
                'rows'  => $rows
            ];

            return $res;
        }

        return $this->fetch();
    }

    /**
     * 添加评委-接口
     */
    public function addJudge()
    {
        if ($this->request->isAjax()) {
            $data = $this->request->param('data_json');
            $data = json_decode($data, true);

            Db::startTrans();
            try {
                $reviewScoreModel = new ProjectReviewScore();
                $reviewScoreModel->saveAll($data);
                Db::commit();
            } catch (Exception $e) {
                Db::rollback();
                $this->error($e->getMessage());
            }
            $this->success();
            return $data;
        }
    }

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

        if ($this->request->isAjax()) {
            list($where, $sort, $order, $offset, $limit) = $this->buildparams();
            $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')
                ->limit($offset, $limit)
                ->select();
//            foreach ($list as &$val) {
//                if($val['type'] == 'teacher') {
//                    $val['teacher_name'] = Db::name('teacher')->where(['id' => $val['teacher_id']])->find()['username'];
//                }else{
//                    $val['teacher_name'] = Db::name('manystore')->where(['id' => $val['teacher_id']])->find()['nickname'];
//                }
//            }
            $result = array("total" => $total, "rows" => $list);

            return json($result);
        }
        $this->assignconfig('reviewStage',$reviewStage);
        $this->assignconfig('register_id',$registerId);

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