| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673 |
- <?php
- // +----------------------------------------------------------------------
- // | LARAVEL8.0 框架 [ LARAVEL ][ RXThinkCMF ]
- // +----------------------------------------------------------------------
- // | 版权所有 2017~2021 LARAVEL研发中心
- // +----------------------------------------------------------------------
- // | 官方网站: http://www.laravel.cn
- // +----------------------------------------------------------------------
- // | Author: laravel开发员 <laravel.qq.com>
- // +----------------------------------------------------------------------
- namespace App\Services\Api;
- use App\Models\ExamAccessLogModel;
- use App\Models\ExamAnswerModel;
- use App\Models\ExamAnswerTopicModel;
- use App\Models\ExamPaperModel;
- use App\Models\ExamTopicModel;
- use App\Models\MemberAnswerRankModel;
- use App\Services\BaseService;
- use App\Services\ConfigService;
- use App\Services\DeepSeekService;
- use App\Services\RedisService;
- use Illuminate\Support\Facades\DB;
- /**
- * 答题服务-服务类
- * @author laravel开发员
- * @since 2020/11/11
- * @package App\Services\Api
- */
- class ExamService extends BaseService
- {
- // 静态对象
- protected static $instance = null;
- /**
- * 构造函数
- * @author laravel开发员
- * @since 2020/11/11
- */
- public function __construct()
- {
- $this->model = new ExamAnswerModel();
- }
- /**
- * 静态入口
- */
- public static function make()
- {
- if (!self::$instance) {
- self::$instance = new static();
- }
- return self::$instance;
- }
- /**
- * @param $params
- * @param int $pageSize
- * @return array
- */
- public function getDataList($params, $pageSize = 15)
- {
- $page = isset($params['page']) ? $params['page'] : 1;
- $cacheKey = "caches:exams:list_{$page}_{$pageSize}:" . md5(json_encode($params));
- $datas = RedisService::get($cacheKey);
- if ($datas) {
- return $datas;
- }
- $query = $this->getQuery($params);
- $list = $query->select(['a.id', 'a.user_ids', 'a.paper_id', 'a.score', 'a.accurate_count', 'b.name', 'b.type', 'b.topic_count', 'b.score_total', 'b.is_charge', 'a.create_time', 'a.answer_times', 'a.status'])
- ->orderBy('a.create_time', 'desc')
- ->paginate($pageSize > 0 ? $pageSize : 9999999);
- $list = $list ? $list->toArray() : [];
- if ($list) {
- foreach ($list['data'] as &$item) {
- $item['create_time'] = $item['create_time'] ? datetime($item['create_time'], 'Y-m-d H.i.s') : '';
- }
- }
- $rows = isset($list['data']) ? $list['data'] : [];
- $datas = [
- 'pageSize' => $pageSize,
- 'total' => isset($list['total']) ? $list['total'] : 0,
- 'list' => $rows
- ];
- if ($rows) {
- RedisService::set($cacheKey, $datas, rand(30, 60));
- }
- return $datas;
- }
- /**
- * 查询
- * @param $params
- * @return mixed
- */
- public function getQuery($params)
- {
- $where = ['b.status' => 1, 'b.mark' => 1, 'a.mark' => 1];
- $status = isset($params['status']) ? $params['status'] : 0;
- $type = isset($params['type']) ? $params['type'] : 0;
- $sceneType = isset($params['scene_type']) ? $params['scene_type'] : 0;
- $userId = isset($params['user_id']) ? $params['user_id'] : 0;
- $subjectId = isset($params['subject_id']) ? $params['subject_id'] : 0;
- if ($userId > 0) {
- $where['a.user_id'] = $userId;
- }
- if ($status > 0) {
- $where['a.status'] = $status;
- }
- if ($type > 0) {
- $where['b.type'] = $type;
- }
- if ($sceneType > 0) {
- $where['b.scene_type'] = $sceneType;
- }
- if ($subjectId > 0) {
- $where['b.subject_id'] = $subjectId;
- }
- return $this->model->from('exam_answers as a')
- ->leftJoin('exam_papers as b', 'b.id', '=', 'a.paper_id')
- ->where($where)
- ->where(function ($query) use ($params) {
- $keyword = isset($params['keyword']) ? $params['keyword'] : '';
- if ($keyword) {
- $query->where('b.name', 'like', "%{$keyword}%");
- }
- });
- }
- /**
- * 答题历史
- * @param $params
- * @param int $pageSize
- * @return array|mixed
- */
- public function getHistoryList($params, $pageSize = 10)
- {
- $page = isset($params['page']) ? $params['page'] : 1;
- $userId = isset($params['user_id']) ? $params['user_id'] : 0;
- $cacheKey = "caches:exams:{$userId}_history_{$page}:" . md5(json_encode($params));
- $datas = RedisService::get($cacheKey);
- if ($datas) {
- return $datas;
- }
- $query = $this->getQuery($params);
- $list = $query->select(['a.id', 'a.user_id', 'a.paper_id', 'a.score', 'a.accurate_count', 'b.name', 'b.type','b.scene_type', 'b.topic_count', 'b.score_total', 'b.is_charge', 'a.create_time', 'a.answer_times', 'a.status'])
- ->orderBy('a.create_time', 'desc')
- ->paginate($pageSize > 0 ? $pageSize : 9999999);
- $list = $list ? $list->toArray() : [];
- if ($list) {
- foreach ($list['data'] as &$item) {
- $item['create_time'] = $item['create_time'] ? datetime($item['create_time'], 'Y-m-d H.i.s') : '';
- }
- }
- $rows = isset($list['data']) ? $list['data'] : [];
- $datas = [
- 'pageSize' => $pageSize,
- 'total' => isset($list['total']) ? $list['total'] : 0,
- 'list' => $rows
- ];
- if ($rows) {
- RedisService::set($cacheKey, $datas, rand(10, 20));
- }
- return $datas;
- }
- /**
- * 每日一练目录数据
- * @param $userId 用户ID
- * @param $params
- * @param $pageSize
- * @return array|mixed
- */
- public function getPracticeList($userId, $params, $pageSize = 10)
- {
- $page = isset($params['page']) ? $params['page'] : 1;
- $type = isset($params['type']) ? $params['type'] : 1;
- $cacheKey = "caches:exams:{$userId}_practice:{$page}_" . md5(json_encode($params));
- $datas = RedisService::get($cacheKey);
- // 每日一练访问次数统计
- if(empty($sc)){
- ExamAccessLogModel::saveLog(date('Y-m-d'), $type, 1);
- }
- if ($datas) {
- return $datas;
- }
- $list = $this->model->from('exam_answers as a')
- ->leftJoin('exam_papers as b', 'b.id', '=', 'a.paper_id')
- ->where(['b.scene_type' => 1, 'b.status' => 1,'a.status'=>1, 'b.mark' => 1, 'a.mark' => 1])
- ->where(function ($query) use ($params) {
- $type = isset($params['type']) && $params['type'] ? intval($params['type']) : 1;
- if ($type > 0) {
- $query->where('b.type', $type);
- }
- })
- ->select(['a.*', 'b.name', 'b.scene_type', 'b.type', 'b.score_total', 'b.topic_count'])
- ->orderBy('a.create_time', 'desc')
- ->paginate($pageSize > 0 ? $pageSize : 9999999);
- $list = $list ? $list->toArray() : [];
- if ($list) {
- foreach ($list['data'] as &$item) {
- $item['date'] = $item['create_time'] ? datetime($item['create_time'], 'Y-m-d') : '';
- }
- }
- // 今日是否练习过
- $rows = isset($list['data']) ? $list['data'] : [];
- $first = isset($rows[0]) ? $rows[0] : [];
- $firstTime = isset($first['date']) ? $first['date'] : 0;
- if ($page == 1 && strtotime($firstTime) < strtotime(date('Y-m-d'))) {
- $type = isset($params['type']) && $params['type'] ? intval($params['type']) : 1;
- $data = PaperService::make()->getRandomPaper($userId, $type, 1);
- if($data){
- $rows = array_merge([$data], $rows);
- }
- }
- $datas = [
- 'pageSize' => $pageSize,
- 'total' => isset($list['total']) ? $list['total'] : 0,
- 'list' => $rows
- ];
- if ($rows) {
- RedisService::set($cacheKey, $datas, rand(10, 20));
- }
- return $datas;
- }
- /**
- * 答题排行榜
- * @param $type 1-日,2-周(7天),3-月
- * @param int $num
- * @return array|mixed
- */
- public function getRankByType($type, $num = 0)
- {
- $num = $num ? $num : ConfigService::make()->getConfigByCode('rank_num', 10);
- $cacheKey = "caches:exams:ranks:{$type}_{$num}";
- $datas = RedisService::get($cacheKey);
- if ($datas) {
- return $datas;
- }
- $prefix = env('DB_PREFIX', 'lev_');
- $datas = MemberAnswerRankModel::from('member_answer_ranks as a')
- ->leftJoin('member as b', 'b.id', '=', 'a.user_id')
- ->where(['a.status' => 1, 'a.mark' => 1])
- ->where(function ($query) use ($type) {
- if ($type == 1) {
- // 日
- $query->where('a.date', date('Y-m-d'));
- } else if ($type == 2) {
- // 周
- $query->where('a.date', '>=', date('Y-m-d', time() - 7 * 86400));
- } else if ($type == 3) {
- // 月
- $query->where('a.date', '>=', date('Y-m-01'));
- }
- })
- ->select(['a.id', 'a.user_id', 'b.avatar', 'b.nickname', 'a.answer_time', 'a.answer_count', DB::raw("ROUND(sum({$prefix}a.answer_time)/3600,0) as answer_hour"), DB::raw("sum({$prefix}a.answer_count) as count")])
- ->groupBy('a.user_id')
- ->orderByRaw("sum({$prefix}a.answer_time)/3600 desc")
- ->take($num)
- ->get();
- $datas = $datas ? $datas->toArray() : [];
- if ($datas) {
- foreach ($datas as &$item) {
- $item['avatar'] = $item['avatar'] ? get_image_url($item['avatar']) : '';
- }
- RedisService::set($cacheKey, $datas, rand(20, 30));
- }
- return $datas;
- }
- /**
- * 获取答题卡列表题目数据
- * @param $userId 用户
- * @param $paperId
- * @param int $rid
- * @return array|mixed
- */
- public function getCardList($userId, $paperId, $rid=0)
- {
- $cacheKey = "caches:exams:{$userId}_cardList:{$paperId}_{$rid}";
- $datas = RedisService::get($cacheKey);
- if($datas){
- return $datas;
- }
- $datas = ExamTopicModel::from('exam_topics as a')
- ->leftJoin('exam_answers_topics as b',function($join) use($userId, $rid){
- if($rid){
- $join->on('b.topic_id','=','a.id')->where(['b.user_id'=>$userId,'b.answer_log_id'=> $rid,'status'=>1,'mark'=>1]);
- }
- })
- ->where(['a.paper_id'=> $paperId, 'a.status'=>1,'a.mark'=>1])
- ->select(['a.id','a.topic_name','a.answer','a.score','a.paper_id','a.topic_type','b.id as rid','b.answer as submit_answer','b.accurate','b.score as submit_score'])
- ->groupBy('a.topic_type')
- ->orderBy('a.sort','desc')
- ->orderBy('a.id','asc')
- ->get();
- $datas = $datas? $datas->toArray() :[];
- if($datas){
- foreach ($datas as &$item){
- $item['rid'] = !empty($item['rid'])? $item['rid'] : 0;
- $item['submit_answer'] = isset($item['submit_answer'])? $item['submit_answer'] : '';
- $item['accurate'] = isset($item['accurate'])? $item['accurate'] : -1;
- $item['submit_score'] = isset($item['submit_score'])? $item['submit_score'] : 0;
- }
- RedisService::set($cacheKey, $datas, rand(5, 10));
- }
- return $datas;
- }
- /**
- * 重新答题,清除答题记录数据
- * @param $id
- * @return bool
- */
- public function reset($id, $userId=0)
- {
- $log = $this->model->where(['id'=> $id,'mark'=>1])->first();
- if(empty($log)){
- return true;
- }
- $updateData = ['score'=>0,'accurate_count'=>0,'answer_count'=>0,'answer_times'=>0,'answer_last_id'=>0,'is_submit'=>0,'status'=>1];
- $this->model->where(['id'=> $id,'mark'=>1])->update($updateData);
- ExamAnswerTopicModel::where(['answer_log_id'=> $id,'mark'=>1])->update(['status'=>2,'update_time'=>time()]);
- RedisService::keyDel("caches:exams:{$userId}*");
- return true;
- }
- /**
- * 答题
- * @param $userId
- * @param $params
- * @return array|false
- */
- public function answer($userId, $params)
- {
- $paperId = isset($params['id'])? $params['id'] : 0;
- $rid = isset($params['rid'])? $params['rid'] : 0;
- $tid = isset($params['tid'])? $params['tid'] : 0;
- $isSubmit = isset($params['is_submit'])? $params['is_submit'] : 1;
- $answer = isset($params['answer'])? $params['answer'] : '';
- $answerImage = isset($params['answer_image'])? $params['answer_image'] : '';
- $answerType = isset($params['answer_type']) && $params['answer_type']? $params['answer_type'] : 2;
- $remainTime = isset($params['remain_time']) && $params['remain_time']? $params['remain_time'] : 0;
- if($isSubmit<=0 && $answerType==2 && empty($answer)){
- $this->error = '请先提交答案';
- return false;
- }
- if($isSubmit<=0 && $answerType==1 && empty($answerImage)){
- $this->error = '请先上传图片答案';
- return false;
- }
- $cacheKey = "caches:answers:{$userId}_{$paperId}:{$tid}_{$rid}";
- if(RedisService::get($cacheKey.'_lock')){
- $this->error = '请不要频繁提交';
- return false;
- }
- RedisService::set($cacheKey.'_lock', $params, rand(2,3));
- // 试卷数据
- $paperInfo = ExamPaperModel::where(['id'=> $paperId,'status'=>1,'mark'=>1])
- ->first();
- $type = isset($paperInfo['type']) && $paperInfo['type']? $paperInfo['type'] : 1;
- $sceneType = isset($paperInfo['scene_type']) && $paperInfo['scene_type']? $paperInfo['scene_type'] : 1;
- $topicCount = isset($paperInfo['topic_count'])? $paperInfo['topic_count'] : 0;
- if(empty($paperInfo)){
- RedisService::clear($cacheKey.'_lock');
- $this->error = '试题数据错误,请返回刷新重试';
- return false;
- }
- // 题目数据
- $topicInfo = ExamTopicModel::where(['id'=> $tid,'paper_id'=>$paperId,'status'=>1,'mark'=>1])->first();
- $topicType = isset($topicInfo['topic_type'])? trim($topicInfo['topic_type']) : '';
- $topicScore = isset($topicInfo['score'])? intval($topicInfo['score']) : 0;
- $topicName = isset($topicInfo['topic_name'])? $topicInfo['topic_name'] : '';
- $topicShowType = isset($topicInfo['show_type'])? $topicInfo['show_type'] : 1;
- $correctAnswer = isset($topicInfo['correct_answer'])? $topicInfo['correct_answer'] : '';
- if(empty($topicInfo) || empty($topicType) || empty($topicName)){
- RedisService::clear($cacheKey.'_lock');
- $this->error = '题库已更新,请返回刷新重试';
- return false;
- }
- // 答题记录
- $submit = 0;
- $answerCount = 0;
- if($rid){
- $answerInfo = ExamAnswerModel::where(['id'=>$rid,'status'=>1,'mark'=>1])->first();
- $submit = isset($answerInfo['is_submit'])? $answerInfo['is_submit'] : 0;
- $answerCount = isset($answerInfo['answer_count'])? $answerInfo['answer_count'] : 0;
- if(empty($answerInfo)){
- $rid = 0;
- }
- if($submit){
- $this->error = '您已交卷';
- return false;
- }
- }
- // 验证答案内容类型和数据
- // 每日一练
- if($sceneType == 1 && $rid<=0){
- // 今日记录
- $answerInfo = ExamAnswerModel::where(['paper_id'=>$paperId,'status'=>1,'mark'=>1])->where('create_time','>=', strtotime(date('Y-m-d')))->first();
- $rid = isset($answerInfo['id'])? $answerInfo['id'] : 0;
- $submit = isset($answerInfo['is_submit'])? $answerInfo['is_submit'] : 0;
- $answerCount = isset($answerInfo['answer_count'])? $answerInfo['answer_count'] : 0;
- }
- // 是否已交卷
- if($submit == 1){
- RedisService::clear($cacheKey.'_lock');
- $this->error = '您已交卷';
- return false;
- }
- // 直接交卷
- $totalTime = ConfigService::make()->getConfigByCode('answer_total_time', 1800);
- $answerTime = $totalTime >$remainTime? $totalTime-$remainTime : $totalTime;
- if($isSubmit==1 && empty($answer) && empty($answerImage)){
- // 是否提交过
- if($answerCount<=0){
- $this->error = '您未提交过答案,请先答题再交卷';
- return false;
- }
- $this->model->where(['id'=> $rid])->update(['is_submit'=>1,'update_time'=>time()]);
- $this->error = '交卷成功';
- // 答题时间统计
- $id = MemberAnswerRankModel::where(['user_id'=> $userId,'date'=>date('Y-m-d'),'mark'=>1])->value('id');
- if($id){
- MemberAnswerRankModel::where(['id'=> $id])->update(['answer_time'=>DB::raw("answer_time + {$answerTime}"),'answer_count'=>DB::raw("answer_count + {$answerCount}"),'update_time'=>time()]);
- }else{
- MemberAnswerRankModel::insert(['user_id'=>$userId,'answer_time'=>$answerTime,'answer_count'=> $answerCount,'date'=>date('Y-m-d'),'create_time'=>time()]);
- }
- RedisService::keyDel("caches:exams:{$userId}*");
- return ['rid'=> $rid,'paper_id'=>$paperId];
- }
- // 该题是否已提交答案
- $logId = 0;
- if($rid>0){
- $answerTopic = ExamAnswerTopicModel::where(['answer_log_id'=>$rid,'topic_id'=> $tid,'mark'=>1])->first();
- $accurate = isset($answerTopic['accurate'])? $answerTopic['accurate'] : -1;
- $logId = isset($answerTopic['id'])? $answerTopic['id'] : 0;
- $status = isset($answerTopic['status'])? $answerTopic['status'] : 0;
- if($answerTopic && $accurate>=0 && $status == 1){
- RedisService::clear($cacheKey.'_lock');
- $this->error = '该题答案已提交';
- return false;
- }
- }
- /* TODO 验证答案 */
- $submitType = 1;
- $topicData = [
- 'user_id'=> $userId,
- 'topic_id'=> $tid,
- 'answer'=> $answerType==1? get_image_path($answer) : $answer,
- 'score'=>0,
- 'accurate'=>0,
- 'create_time'=> time(),
- 'status'=> 1,
- 'mark'=> 1,
- ];
- if(in_array($topicType,['选择题','单选题','多选题','填空题'])){
- $topicData['answer_analysis'] = isset($topicInfo['answer_analysis'])? $topicInfo['answer_analysis'] : '';
- if($answer == $correctAnswer){
- $topicData['accurate'] = 1;
- $topicData['score'] = $topicScore;
- }else{
- $topicData['accurate'] = 0;
- }
- // }else if (in_array($topicType, ['简答题','计算题','阅读理解'])){
- }else {
- // 图片答案AI验证
- if($answerType == 1){
- if(empty($answerImage)){
- $this->error = '请上传图片答案~';
- return false;
- }
- $submitType = 3;
- $apiData = [
- 'answer'=> DeepSeekService::make()->getImageTopicData($answerImage),
- 'score'=> $topicScore,
- 'topic'=> $topicShowType == 2 && $topicName? DeepSeekService::make()->getImageTopicData($topicName) : $topicName,
- ];
- var_dump($apiData);
- $result = DeepSeekService::make()->apiRequest($apiData);
- RedisService::clear($cacheKey.'_lock');
- $this->error = '功能开放中~';
- return false;
- }else {
- $submitType = 2;
- $apiData = [
- 'answer'=> $answer,
- 'score'=> $topicScore,
- 'topic'=> $topicShowType == 2 && $topicName? DeepSeekService::make()->getImageTopicData($topicName) : $topicName,
- ];
- $result = DeepSeekService::make()->apiRequest($apiData);
- $score = isset($result['score'])?$result['score'] : 0;
- $analysis = isset($result['analysis'])?$result['analysis'] : '';
- if($score>0){
- $topicData['accurate'] = 1;
- $topicData['score'] = $score;
- $topicData['answer_analysis'] = $analysis;
- }else{
- $topicData['accurate'] = 0;
- }
- }
- }
- DB::beginTransaction();
- if($rid){
- $log = [
- 'answer_times'=> $answerTime,
- 'answer_last_at'=> date('Y-m-d H:i:s'),
- 'answer_count'=> DB::raw("answer_count + 1"),
- 'answer_last_id'=> $tid,
- 'is_submit'=> $isSubmit==1?1:0,
- 'update_time'=> time()
- ];
- // 对题数
- if($topicData['accurate']==1){
- $log['accurate_count'] = DB::raw("accurate_count + 1");
- $log['score'] = DB::raw("score + {$topicData['score']}");
- }
- if(!$this->model->where(['id'=> $rid])->update($log)){
- DB::rollBack();
- RedisService::clear($cacheKey.'_lock');
- $this->error = '答题失败,请刷新后重新提交';
- return false;
- }
- }else{
- $log = [
- 'user_id'=> $userId,
- 'paper_id'=> $paperId,
- 'score'=> $topicData['score'],
- 'answer_count'=> 1,
- 'answer_times'=> $answerTime,
- 'answer_last_at'=> date('Y-m-d H:i:s'),
- 'answer_last_id'=> $tid,
- 'is_submit'=> $isSubmit,
- 'create_time'=> time()
- ];
- if(!$rid = $this->model->insertGetId($log)){
- DB::rollBack();
- RedisService::clear($cacheKey.'_lock');
- $this->error = '答题失败,请刷新后重新提交';
- return false;
- }
- }
- // 答题题目数据
- $topicData['answer_type'] = $submitType;
- $topicData['answer_log_id'] = $rid;
- if($logId){
- $topicData['update_time'] = $submitType;
- ExamAnswerTopicModel::where(['id'=> $logId])->update($topicData);
- }else if (!ExamAnswerTopicModel::insert($topicData)){
- DB::rollBack();
- RedisService::clear($cacheKey.'_lock');
- $this->error = '答题失败,请刷新后重新提交';
- return false;
- }
- DB::commit();
- // 答题时间统计
- if($isSubmit==1){
- $id = MemberAnswerRankModel::where(['user_id'=> $userId,'date'=>date('Y-m-d'),'mark'=>1])->value('id');
- if($id){
- $answerCount++;
- MemberAnswerRankModel::where(['id'=> $id])->update(['answer_time'=>DB::raw("answer_time + {$answerTime}"),'answer_count'=>DB::raw("answer_count + {$answerCount}"),'update_time'=>time()]);
- }else{
- MemberAnswerRankModel::insert(['user_id'=>$userId,'answer_time'=>$answerTime,'answer_count'=> $answerCount,'date'=>date('Y-m-d'),'create_time'=>time()]);
- }
- }
- $this->error = '答题成功';
- RedisService::clear($cacheKey.'_lock');
- RedisService::keyDel("caches:exams:{$userId}*");
- RedisService::clear("caches:exams:info_{$rid}");
- RedisService::keyDel("caches:paper:info_{$userId}:p{$paperId}*");
- return ['paper_id'=> $paperId,'rid'=>$rid,'tid'=>$tid, 'accurate'=> $topicData['accurate'],'answer'=>$topicData['answer']];
- }
- /**
- * 是否有答题记录数据
- * @param $rid
- * @param $tid
- * @return array|mixed
- */
- public function getAnswerCacheTopic($rid, $tid)
- {
- $cacheKey = "caches:answers:topic_{$rid}_{$tid}";
- $data = RedisService::get($cacheKey);
- if($data){
- return $data;
- }
- $data = ExamAnswerTopicModel::where(['rid'=> $rid,'topic_id'=>$tid,'mark'=>1])->value('id');
- if($data){
- RedisService::set($cacheKey, $data, rand(5, 10));
- }
- return $data;
- }
- /**
- * 答题分数结果详情
- * @param $rid
- * @return array|mixed
- */
- public function getInfo($rid)
- {
- $cacheKey = "caches:exams:info_{$rid}";
- $data = RedisService::get($cacheKey);
- if($data){
- return $data;
- }
- $data = $this->model->from('exam_answers as a')
- ->leftJoin('exam_papers as b','b.id','=','a.paper_id')
- ->where(['a.id'=> $rid,'a.status'=>1,'a.mark'=>1])
- ->select(['a.*','b.topic_count'])
- ->first();
- $data = $data? $data->toArray() : [];
- if($data){
- $data['accurate_rate'] = round($data['accurate_count']/$data['topic_count'] * 100,2);
- $data['answer_times_text'] = $data['answer_times']? format_times($data['answer_times']) : '00:00';
- RedisService::set($cacheKey, $data, rand(5, 10));
- }
- return $data;
- }
- }
|