审查视图

application/mobile/controller/Old.php 13.7 KB
何书鹏 authored
1 2 3 4 5 6 7 8 9
<?php
namespace app\mobile\controller;

use think\Validate;
use think\Db;
use app\common\controller\Api;
use app\mobile\model\Question;
use app\mobile\model\QuestionAnswer;
use app\mobile\model\OldResult;
何书鹏 authored
10
use app\mobile\model\Course;
何书鹏 authored
11 12 13

/**
 * 历年真题接口
何书鹏 authored
14
 * @ApiWeigh (96)
何书鹏 authored
15 16 17 18 19
 */
class Old extends Api
{
	protected $noNeedLogin = ['index','info'];
    protected $noNeedRight = ['*'];
何书鹏 authored
20
    protected $model = null;
何书鹏 authored
21 22 23 24

    public function _initialize()
    {
        parent::_initialize();
何书鹏 authored
25
        $this->model = model('app\mobile\model\Old');
何书鹏 authored
26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50
    }

    /**
     * @ApiTitle    (首页)
     * @ApiSummary  (首页)
     * @ApiMethod   (POST)
     *
     * @ApiReturn({
        "code": 1,
        "msg": "成功",
        "time": "1599814710",
        "data": {
            "banner": "", //广告图 
            "list": [{ // 试卷列表
                "id": 2, //试卷ID
                "title": "测试试卷2", //试卷标题
                "do_num": 9 //做过人数
            }]
        }
    })
     */
    public function index()
    {
        $banner = Db::name('mobile_config')->where('id',1)->value('old_adver');
        $banner = !empty($banner) ? cdnurl($banner,true) : '';
何书鹏 authored
51
        $list = $this->model->order('createtime desc')->select();
何书鹏 authored
52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74
        foreach ($list as $v) {
            $v->visible(['id','title','do_num']);
        }
        $this->success('成功',compact('banner','list'));
    }

    /**
     * @ApiTitle    (详情)
     * @ApiSummary  (详情)
     * @ApiMethod   (POST)
     *
     * @ApiParams (name="old_id", type="int", required=true, description="试卷ID")
     *
     * @ApiReturn({
        "code": 1,
        "msg": "成功",
        "time": "1599046220",
        "data": {
            "id": 1, //试卷ID
            "title": "测试试卷", //试卷标题
            "year": 2015, //年费(单位:年)
            "time": 100, //答题时间(单位:分)
            "pass_score": 80, //合格分数
何书鹏 authored
75
            "satisfaction": 0, //满意度
何书鹏 authored
76 77 78 79 80 81 82 83 84 85
            "description": "这个还行", //试卷描述
            "do_num": 10, //回答人数
            "full_score": 100 //试卷分数(单位:分)
        }
    })
     */
    public function info()
    {
        $old_id = $this->request->param('old_id');
        empty($old_id) && $this->error('缺少必要参数');
何书鹏 authored
86
        $info = $this->model->get($old_id);
何书鹏 authored
87 88
        empty($info) && $this->error('试卷信息不存在');
        $info['full_score'] = Question::where('target_id',$old_id)->sum('score');
何书鹏 authored
89
        $info = $info->visible(['id','title','year','time','pass_score','satisfaction','description','do_num'])->append(['full_score']);
何书鹏 authored
90 91 92 93 94 95 96 97 98 99
        $this->success('成功',$info);
    }

    /**
     * @ApiTitle    (考试模式-题目列表)
     * @ApiSummary  (考试模式-题目列表)
     * @ApiMethod   (POST)
     *
     * @ApiHeaders  (name=token, type=string, required=true, description="请求的Token")
     * @ApiParams (name="old_id", type="int", required=true, description="试卷ID")
何书鹏 authored
100
     * @ApiParams (name="answer_type", type="string", required=false, description="作答类型:0=全部,1=已答题,2=未答题,3=错题")
何书鹏 authored
101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123
     *
     * @ApiReturn({
        "code": 1,
        "msg": "成功",
        "time": "1599032660",
        "data": {
            "time": 6000, //倒计时(单位:秒)
            "total": 1, //题目总数
            "list": [{ //题目列表
                "id": 1, //题目ID
                "title": "测定混凝土立方体抗压强度时,标准试件的尺寸是(      )㎜。", //题目
                "option": "[{\"name\":\"A\",\"gender\":\"100\\u00d7100\\u00d7100\"},{\"name\":\"B\",\"gender\":\"150\\u00d7150\\u00d7150\"},{\"name\":\"C\",\"gender\":\"200\\u00d7200\\u00d7200\"},{\"name\":\"D\",\"gender\":\"70.7\\u00d770.7\\u00d770.7\"}]", //题目选项
                "type": "1", //题目类型:1=单选题,2=多选题,3=判断题,4=简答题
                "answer": "A", //答案
                "is_collect": "1" //是否收藏:0=否,1=是
            }]
        }
    })
     */
    public function questionList()
    {
        $user_id = $this->auth->id;
        $old_id = $this->request->param('old_id');
何书鹏 authored
124
        $answer_type = $this->request->param('answer_type');
何书鹏 authored
125
        empty($old_id) && $this->error('缺少必要参数');
何书鹏 authored
126
        $info = $this->model->get($old_id);
何书鹏 authored
127 128
        empty($info) && $this->error('试卷信息不存在');
        $time = $info['time'] * 60;
何书鹏 authored
129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146
        $where['q.target_id'] = $old_id;
        $where['q.target_type'] = '3';
        switch ($answer_type) {
            case '1':
                $question_id_arr = QuestionAnswer::where('user_id',$user_id)->column('question_id');
                $where['q.id'] = !empty($question_id_arr) ? ['in',$question_id_arr] : 0;
                break;
            case '2':
                $question_id_arr = QuestionAnswer::where('user_id',$user_id)->column('question_id');
                if(!empty($question_id_arr)){
                    $where['q.id'] = ['notin',$question_id_arr];
                }
                break;
            case '3':
                $question_id_arr = QuestionAnswer::where('user_id',$user_id)->where('is_wrong','1')->column('question_id');
                $where['q.id'] = !empty($question_id_arr) ? ['in',$question_id_arr] : 0;
                break;
        }
何书鹏 authored
147 148
        $list = Question::alias('q')
            ->join('mobile_question_collect qc','q.id = qc.question_id and user_id='.$user_id,'left')
何书鹏 authored
149
            ->where($where)
何书鹏 authored
150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196
            ->field('
                q.id,
                q.title,
                q.option,
                q.type,
                q.answer,
                if(qc.id > 0,1,0) is_collect
            ')->order(['type'=>'asc'])
            ->select();
        $total = count($list);
        // 删除原来的做题记录
        QuestionAnswer::where('question_id','in',array_column($list, 'id'))
            ->where('user_id',$user_id)
            ->delete();
        $this->success('成功',compact('time','total','list'));
    }

    /**
     * @ApiTitle    (模考答题卡)
     * @ApiSummary  (模考答题卡)
     * @ApiMethod   (POST)
     * 
     * @ApiHeaders  (name=token, type=string, required=true, description="请求的Token")
     * @ApiParams (name="old_id", type="int", required=true, description="试卷ID")
     *
     * @ApiReturn({
        "code": 1,
        "msg": "成功",
        "time": "1599032660",
        "data": {
            "total": 1, //题目总数
            "list": [{ //题目列表
                "id": 1, //题目ID
                "title": "测定混凝土立方体抗压强度时,标准试件的尺寸是(      )㎜。", //题目
                "option": "[{\"name\":\"A\",\"gender\":\"100\\u00d7100\\u00d7100\"},{\"name\":\"B\",\"gender\":\"150\\u00d7150\\u00d7150\"},{\"name\":\"C\",\"gender\":\"200\\u00d7200\\u00d7200\"},{\"name\":\"D\",\"gender\":\"70.7\\u00d770.7\\u00d770.7\"}]", //题目选项
                "type": "1", //题目类型:1=单选题,2=多选题,3=判断题,4=简答题
                "answer": "A", //答案
                "status": "1" //状态:0=未答,1=答对,2=答错
            }]
        }
    })
     */
    public function answerSheet()
    {
        $user_id = $this->auth->id;
        $old_id = $this->request->param('old_id');
        empty($old_id) && $this->error('缺少必要参数');
何书鹏 authored
197
        $info = $this->model->get($old_id);
何书鹏 authored
198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240
        empty($info) && $this->error('试卷信息不存在');
        $list = Question::alias('q')
            ->join('mobile_question_answer qa','q.id = qa.question_id and user_id='.$user_id,'left')
            ->where('q.target_id',$old_id)
            ->where('q.target_type','3')
            ->field('
                q.id,
                q.title,
                q.option,
                q.type,
                q.answer,
                if(qa.id > 0,if(qa.is_wrong="0",1,2),0) status
            ')->order(['type'=>'asc'])
            ->select();
        $new_list = [];
        foreach ($list as $v) {
            $new_list[$v['type']][] = $v;
        }
        $this->success('成功',$list);
    }

    /**
     * @ApiTitle    (交卷)
     * @ApiSummary  (交卷)
     * @ApiMethod   (POST)
     *
     * @ApiHeaders  (name=token, type=string, required=true, description="请求的Token")
     * @ApiParams (name="old_id", type="int", required=true, description="试卷ID")
     *
     * @ApiReturn({
        "code": 1,
        "msg": "交卷成功",
        "time": "1599116222",
        "data": {
            "old_result_id": "10" //考试结果ID
        }
    })
     */
    public function submit()
    {
        $user_id = $this->auth->id;
        $old_id = $this->request->param('old_id');
        empty($old_id) && $this->error('缺少必要参数');
何书鹏 authored
241
        $info = $this->model->get($old_id);
何书鹏 authored
242 243 244 245
        empty($info) && $this->error('试卷信息不存在');
        $list = Question::alias('q')
            ->join('mobile_question_answer qa','q.id = qa.question_id and user_id='.$user_id,'left')
            ->where('q.target_id',$old_id)
何书鹏 authored
246
            ->where('q.target_type','3')
何书鹏 authored
247 248 249 250 251 252 253 254
            ->field('q.id,q.title,q.option,q.type,q.answer,q.score,qa.get_score,qa.is_wrong')
            ->select();
        // 考试得分
        $myscore = array_sum(array_column($list, 'get_score'));
        // 正确率
        $right_count = Question::alias('q')
            ->join('mobile_question_answer qa','q.id = qa.question_id and user_id='.$user_id,'left')
            ->where('q.target_id',$old_id)
何书鹏 authored
255
            ->where('q.target_type','3')
何书鹏 authored
256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313
            ->where('qa.is_wrong','0')
            ->sum('q.id');
        $right_rate = !empty($right_count) ? bcdiv($right_count,count($list),4) * 100 : 0;
        // 记录结果
        $result = oldResult::create([
            'user_id' => $user_id,
            'old_id' => $old_id,
            'full_score' => array_sum(array_column($list, 'score')),
            'get_score' => $myscore,
            'right_rate' => $right_rate
        ]);
        /*击败考生率和平均分*/
        $result_list = oldResult::where('old_id',$old_id)->select();
        // 击败考生
        $lt_count = oldResult::where('old_id',$old_id)
            ->where('get_score','<',$myscore)
            ->count();
        $win_rate = !empty($lt_count) ? bcdiv($lt_count,count($result_list),4) * 100 : 0;
        // 平均分
        $average_score = ceil(array_sum(array_column($result_list, 'get_score')) / count($result_list));
        // 记录下来击败考证率和平均分
        $result->save([
            'win_rate' => $win_rate,
            'average_score' => $average_score
        ]);
        $this->success('交卷成功',['old_result_id'=>$result['id']]);
    }

    /**
     * @ApiTitle    (测试结果页)
     * @ApiSummary  (测试结果页)
     * @ApiMethod   (POST)
     *
     * @ApiParams (name="old_result_id", type="int", required=true, description="考试结果ID")
     *
     * @ApiReturn({
        "code": 1,
        "msg": "成功",
        "time": "1599116915",
        "data": {
            "info": { //考试结果
                "id": 10, //考试结果ID
                "user_id": 9, //用户ID
                "old_id": 1, //试卷ID
                "full_score": 6, //试卷满分
                "get_score": 3, //考试得分
                "right_rate": 50, //正确率
                "win_rate": 100, //击败考生率
                "average_score": 3, //全站平均得分
                "createtime": 1599116222,
                "updatetime": 1599116222
            },
            "list": [{ //答题卡
                "id": 1, //题目ID
                "title": "测定混凝土立方体抗压强度时,标准试件的尺寸是(      )㎜。", //题目
                "option": "[{\"name\":\"A\",\"gender\":\"100\\u00d7100\\u00d7100\"},{\"name\":\"B\",\"gender\":\"150\\u00d7150\\u00d7150\"},{\"name\":\"C\",\"gender\":\"200\\u00d7200\\u00d7200\"},{\"name\":\"D\",\"gender\":\"70.7\\u00d770.7\\u00d770.7\"}]", //题目选项
                "type": "1", //题目类型:1=单选题,2=多选题,3=判断题,4=简答题
                "answer": "A", //题目答案
314 315
                "status": 2, //状态:0=未答,1=答对,2=答错
                "my_answer": A //我的答案
何书鹏 authored
316 317 318 319 320 321 322 323
            }],
            "course": { //推荐课程
                "id": 1, //课程ID
                "title": "测试课程", //课程名称
                "current_price": "50.00", //现价
                "original_price": "100.00", //原价
                "select_rate": 64 //选择率
            }
何书鹏 authored
324 325 326 327 328 329 330 331 332 333 334 335 336 337 338 339 340 341 342 343
        }
    })
     */
    public function examResult()
    {
        $user_id = $this->auth->id;
        $old_result_id = $this->request->param('old_result_id');
        empty($old_result_id) && $this->error('缺少必要参数');
        $info = OldResult::get($old_result_id);
        empty($info) && $this->error('考试结果信息不存在');
        $list = Question::alias('q')
            ->join('mobile_question_answer qa','q.id = qa.question_id and user_id='.$user_id,'left')
            ->where('q.target_id',$info['old_id'])
            ->where('q.target_type','3')
            ->field('
                q.id,
                q.title,
                q.option,
                q.type,
                q.answer,
344 345
                if(qa.id > 0,if(qa.is_wrong="0",1,2),0) status,
                qa.content my_answer
何书鹏 authored
346 347 348 349 350 351
            ')->order(['type'=>'asc'])
            ->select();
        $new_list = [];
        foreach ($list as $v) {
            $new_list[$v['type']][] = $v;
        }
何书鹏 authored
352 353 354 355 356 357 358 359 360
        // 推荐课程
        $course_id = $this->model->where('id',$info['old_id'])->value('course_id');
        $course = Course::where('id',$course_id)->field('id,title,current_price,original_price')->find();
        if($course){
            $course->select_rate = mt_rand(40,70);
        }else{
            $course = [];
        }
        $this->success('成功',compact('info','list','course'));
何书鹏 authored
361 362
    }
}