TrainingLogic.php 31 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623
  1. <?php
  2. namespace app\workerapi\logic;
  3. use app\adminapi\logic\master_worker_register\MasterWorkerRegisterLogic;
  4. use app\common\enum\worker\WorkerAccountLogEnum;
  5. use app\common\enum\YesNoEnum;
  6. use app\common\logic\BaseLogic;
  7. use app\common\model\bank_account\BankAccount;
  8. use app\common\model\goods_category\GoodsCategory;
  9. use app\common\model\master_worker\MasterWorker;
  10. use app\common\model\master_worker\MasterWorkerAccountLog;
  11. use app\common\model\master_worker\MasterWorkerAgree;
  12. use app\common\model\master_worker\MasterWorkerInfo;
  13. use app\common\model\master_worker\MasterWorkerTeam;
  14. use app\common\model\shops\ShopOrderGoods;
  15. use app\common\model\shops\ShopOrders;
  16. use app\common\model\tenant\TenantAgree;
  17. use app\common\model\tenant\TenantRegister;
  18. use app\common\model\training\TrainingCategory;
  19. use app\common\model\training\TrainingCourse;
  20. use app\common\model\training\TrainingQuestions;
  21. use app\common\model\training\TrainingTask;
  22. use app\common\model\training\TrainingWorkerCourse;
  23. use app\common\model\training\TrainingWorkerQuestion;
  24. use app\common\model\training\TrainingWorkerTask;
  25. use app\common\model\works\ServiceWork;
  26. use app\common\service\FileService;
  27. use app\workerapi\lists\MasterWorkerLists;
  28. use app\workerapi\lists\ServiceWorkLists;
  29. use think\Exception;
  30. use think\facade\Config;
  31. use think\facade\Db;
  32. use think\facade\Log;
  33. class TrainingLogic extends BaseLogic
  34. {
  35. public static function getDetail(int $masterWorkerId)
  36. {
  37. try {
  38. TrainingWorkerTaskLogic::upTaskOrder($masterWorkerId);
  39. $task_info = ['id'=>0];
  40. $task = TrainingWorkerTask::where('master_worker_id',$masterWorkerId)->findOrEmpty();
  41. if (!$task->isEmpty()) {
  42. $task_info = $task->toArray();
  43. // 0 不展示按钮 1 去学习 2 已学完
  44. $task_info['learning_status'] = $task_info['shop_orders_id']>0?1:0;
  45. $task_info['operate_status'] = empty($task_info['lead_master_worker_id'])?0:($task_info['operate_status']?1:2);
  46. $task_info['bank_status'] = BankAccount::where('worker_id',$masterWorkerId)->where('audit_state',1)->value('id')?1:0;
  47. $masterWorker = MasterWorker::where('id',$masterWorkerId)->find();
  48. //服务类目
  49. $task_info['category_status'] = empty($masterWorker['category_ids'])?0:1;
  50. $task_info['category_ids'] = $masterWorker['category_ids']??[];
  51. $task_info['service_status'] = (empty($masterWorker['lon']) || empty($masterWorker['lat']))?0:1;
  52. // 团队入驻状态 审核状态 0待审核 1审核通过 2审核拒绝
  53. $task_info['tenant_register_status'] = TenantRegister::where('mobile',$masterWorker['mobile'])->value('status')??0;
  54. // 团队协议状态 审核状态 0待审核 1审核通过 2审核拒绝 3待提交
  55. $task_info['tenant_agree_status'] = TenantAgree::where('worker_id',$masterWorker['id'])->value('audit_state')??0;
  56. $task_info['tenant_agree_info'] = TenantAgreeLogic::getAgreeByType('tenant_cooperate',$masterWorker['id']);
  57. // 工程师免责协议状态 审核状态 0待审核 1审核通过 2审核拒绝 3待提交
  58. $task_info['harmless_agree_status'] = MasterWorkerAgree::where(['agree_type'=>'harmless_content','worker_id'=>$masterWorker['id']])->value('audit_state')??0;
  59. $task_info['harmless_agree_info'] = MasterWorkerAgreeLogic::getAgreeByType('harmless',$masterWorker['id']);
  60. // 工程师无犯罪协议状态 审核状态 0待审核 1审核通过 2审核拒绝 3待提交
  61. $task_info['crime_agree_status'] = MasterWorkerAgree::where(['agree_type'=>'crime_content','worker_id'=>$masterWorker['id']])->value('audit_state')??0;
  62. $task_info['crime_agree_info'] = MasterWorkerAgreeLogic::getAgreeByType('crime',$masterWorker['id']);
  63. // 该工程师所有必须任务是否完成
  64. $task_info['task_required'] = MasterWorkerLogic::taskRequired($masterWorker['id'],$masterWorker['identity_source'])?1:0;
  65. }
  66. //$task_info['free_videos'] = TrainingCourse::where('course_lock',1)->select()->toArray();
  67. return $task_info;
  68. } catch (\Exception $e) {
  69. self::setError($e->getMessage());
  70. return [];
  71. }
  72. }
  73. /**
  74. * 获取工程师的课程列表
  75. * @param int $masterWorkerId
  76. * @param array $params
  77. * @return array training_task_id => 工程师的任务id
  78. */
  79. public static function getCourseList(int $masterWorkerId,$params = [])
  80. {
  81. try {
  82. if(!isset($params['training_task_id']) || empty($params['training_task_id'])) {
  83. throw new \Exception('缺少参数');
  84. }
  85. $list = TrainingWorkerCourse::with(['trainingCourse'])->where('master_worker_id',$masterWorkerId)->where('training_task_id',$params['training_task_id'])->select()->toArray();
  86. foreach ($list as &$item) {
  87. $item['course_name'] = $item['trainingCourse']['course_name']??'';
  88. $item['course_picture'] = FileService::getFileUrl($item['trainingCourse']['course_picture']??'');
  89. $item['course_url'] = FileService::getFileUrl($item['trainingCourse']['course_url']??'');
  90. }
  91. return $list;
  92. } catch (\Exception $e) {
  93. self::setError($e->getMessage());
  94. return [];
  95. }
  96. }
  97. /**
  98. * 获取工程师的课程详情
  99. * @param int $masterWorkerId
  100. * @param array $params
  101. * @return array id => 工程师的课程id free_course_id => 免费课程ID
  102. */
  103. public static function getCourseDetail(int $masterWorkerId,$params = [])
  104. {
  105. try {
  106. if(isset($params['free_course_id']) && $params['free_course_id'] > 0) $params['id'] = self::freeWorkerCourseId($masterWorkerId,$params['free_course_id']);
  107. $info = TrainingWorkerCourse::with(['trainingCourse'])->where('master_worker_id',$masterWorkerId)->where('id',$params['id'])->findOrEmpty()->toArray();
  108. $info['course_name'] = $info['trainingCourse']['course_name'];
  109. $info['course_picture'] = FileService::getFileUrl($info['trainingCourse']['course_picture']);
  110. $info['course_url'] = FileService::getFileUrl($info['trainingCourse']['course_url']);
  111. return $info;
  112. } catch (\Exception $e) {
  113. self::setError($e->getMessage());
  114. return [];
  115. }
  116. }
  117. /**
  118. * 修改学习记录状态 播放开始 播放暂停 播放结束 考试开始 考试结束
  119. * @param array $params
  120. * @param int $masterWorkerId
  121. * @return bool
  122. */
  123. public static function upWorkerCourse(array $params)
  124. {
  125. try {
  126. $logCourse = TrainingWorkerCourse::where('id',$params['id'])->findOrEmpty();
  127. if ($logCourse->isEmpty()) {
  128. throw new \Exception('课程不存在');
  129. }
  130. // 播放开始 播放暂停 播放结束
  131. switch ($params['status']) {
  132. case 1:
  133. $logCourse->play_time = $params['play_time']??($params['play_time']>0?$params['play_time']:1);
  134. $logCourse->study_status = 1;
  135. TrainingWorkerTask::where('training_task_id',$logCourse->training_task_id)
  136. ->where('master_worker_id',$logCourse->master_worker_id)
  137. ->where('training_status',0)
  138. ->update(['training_status'=>1]);
  139. break;
  140. case 2:
  141. $logCourse->play_time = $params['play_time']??10;
  142. break;
  143. case 3:
  144. $logCourse->study_status = 2;
  145. break;
  146. case 4:
  147. $logCourse->exam_start_time = time();
  148. $logCourse->study_status = 3;
  149. break;
  150. case 5:
  151. $logCourse->exam_end_time = time();
  152. $logCourse->study_status = 4;
  153. break;
  154. case 6:
  155. $logCourse->exam_end_time = time();
  156. $logCourse->study_status = 5;
  157. break;
  158. }
  159. $logCourse->save();
  160. return true;
  161. } catch (\Exception $e) {
  162. self::setError($e->getMessage());
  163. return false;
  164. }
  165. }
  166. /**
  167. * 获取工程师的考试试题列表(即开始考试)
  168. * @param array $params worker_course_id 工程师的课程id
  169. * @return array id 工程师的试题id
  170. */
  171. public static function getQuestionList(array $params)
  172. {
  173. try {
  174. $workerCourse = TrainingWorkerCourse::where('id',$params['worker_course_id'])->findOrEmpty();
  175. $study_status = 0;
  176. if(isset($params['is_resit']) && $params['is_resit'] == 1 && $workerCourse['study_status'] == 4){
  177. // 重置
  178. TrainingWorkerCourse::update(['exam_start_time'=>0,'exam_end_time'=>0,'study_status'=>2,'exam_score'=>0],['id'=>$params['worker_course_id']]);
  179. TrainingWorkerQuestion::update(['worker_answer'=>'','exam_score'=>0],['worker_course_id'=>$params['worker_course_id']]);
  180. $study_status = 2;
  181. }
  182. if($workerCourse['study_status'] == 2 || $study_status == 2) {
  183. // 开始考试
  184. self::upWorkerCourse(['id'=>$params['worker_course_id'],'status'=> 4]);
  185. }
  186. $trainingCourse = TrainingCourse::where('id',$workerCourse['training_course_id'])->findOrEmpty();
  187. // 配置是否随机出题? 0 1
  188. if($trainingCourse->randomly_question){
  189. $where = [];
  190. if($trainingCourse->subclass){
  191. $where[] = ['subclass','=',$trainingCourse->subclass];
  192. }else{
  193. $where[] = ['subclass','=',0];
  194. }
  195. // 随机出题 随机x个试题 x由该课程配置决定 比如10个试题
  196. $trainingQuestions = TrainingQuestions::where($where)->order(Db::raw('rand()'))->limit($trainingCourse->randomly_num)->select()->toArray();
  197. //每题多少分(按总分100分计算)
  198. $score = bcdiv(100, count($trainingQuestions), 2);
  199. $course_question = [];
  200. foreach ($trainingQuestions as $block_key => $trainingQuestion) {
  201. //[{"block_key":1,"select_value":1,"score":"20"},{"block_key":2,"select_value":2,"score":"10"},{"block_key":3,"select_value":3,"score":"70"}]
  202. $course_question[] = [
  203. 'block_key' => $block_key+1,
  204. 'select_value' => $trainingQuestion['id'],
  205. 'score' => $score
  206. ];
  207. }
  208. TrainingWorkerCourse::where('id',$workerCourse['id'])->update(['course_question_setting'=>json_encode($course_question)]);
  209. TrainingWorkerQuestion::where('worker_course_id',$workerCourse['id'])->delete();
  210. // 添加该工程师该课程的所有试题初始化记录
  211. $course_question_ids = array_column($course_question,'select_value');
  212. foreach ($course_question_ids as $question_id) {
  213. TrainingWorkerQuestion::create([
  214. 'master_worker_id' => $params['user_id'],
  215. 'subclass' => $trainingCourse->subclass,
  216. 'worker_course_id' => $workerCourse['id'],
  217. 'questions_id' => $question_id,
  218. 'worker_answer' => '',
  219. 'exam_score' => 0
  220. ]);
  221. }
  222. }
  223. $list = TrainingWorkerQuestion::with(['trainingQuestions'])->where('worker_course_id',$params['worker_course_id'])->select()->toArray();
  224. foreach ($list as &$item) {
  225. $item['title'] = $item['trainingQuestions']['title'];
  226. $item['question_type'] = $item['trainingQuestions']['question_type'];
  227. $item['question_selects'] = $item['trainingQuestions']['question_selects'];
  228. $item['question_answer'] = $item['trainingQuestions']['question_answer'];
  229. $item['question_analysis'] = $item['trainingQuestions']['question_analysis'];
  230. }
  231. return $list;
  232. } catch (\Exception $e) {
  233. throw new \Exception($e->getMessage());
  234. }
  235. }
  236. /**
  237. * 提交考试 该工程师的课程id + 所有的工程师的试题id、答案
  238. * @param array
  239. * @param int $masterWorkerId
  240. * @return
  241. */
  242. public static function submitExam($params){
  243. Db::startTrans();
  244. try {
  245. // 课程试卷详情
  246. $exam_paper_details = self::getExamPaperDetails(['worker_course_id'=>$params['worker_course_id']]);
  247. // 提交的答案 [['id'=> ,'answer'=>],['id'=> ,'answer'=>]]
  248. !is_array($params['worker_answer']) && $params['worker_answer'] = json_decode($params['worker_answer'],true);
  249. $worker_answer = array_column($params['worker_answer'],'answer','id');
  250. //对比答案 更新答题记录实际每题得分,总得分
  251. $all_exam_score = 0;
  252. $course_question_setting = $exam_paper_details['course']['course_question_setting'];
  253. foreach ($course_question_setting as &$item) {
  254. $exam_score = 0;
  255. $worker_answer_value = '';
  256. ($worker_answer_value = explode(',',$worker_answer[$item['select_value']])) && sort($worker_answer_value) && ($worker_answer_value = implode(',',$worker_answer_value));
  257. if($worker_answer_value == $item['question_answer']){
  258. $exam_score = $item['score'];
  259. }
  260. $all_exam_score += $exam_score;
  261. TrainingWorkerQuestion::update(
  262. ['worker_answer' => $worker_answer_value,'exam_score' => $exam_score],
  263. ['worker_course_id' => $params['worker_course_id'],'questions_id' => $item['select_value']]
  264. );
  265. }
  266. // 更新课程得分、状态
  267. if((float)$all_exam_score < (float)$exam_paper_details['course']['course_question_score']){
  268. $study_status = 4;
  269. }else{
  270. $study_status = 5;
  271. }
  272. TrainingWorkerCourse::update(
  273. ['exam_score' => $all_exam_score,'study_status'=>$study_status,'exam_end_time'=>time()],
  274. ['id' => $params['worker_course_id']]
  275. );
  276. Log::info(
  277. '提交考试结果:'.$params['worker_course_id'].' 得分: '.$all_exam_score.' 状态: '.$study_status.
  278. ' 合格分: '.$exam_paper_details['course']['course_question_score'].
  279. ' 工程师id: '. $exam_paper_details['master_worker_id'].
  280. ' 试题详情: '.json_encode($exam_paper_details)
  281. );
  282. // 判断是否为服务类目考试
  283. if($exam_paper_details['subclass'] > 0){
  284. if($study_status == 5){
  285. // 该工程师的服务类目课程全部完成,更新任务状态
  286. $workerCourseCount = TrainingWorkerCourse::where('master_worker_id',$exam_paper_details['master_worker_id'])
  287. ->where('training_task_id',$exam_paper_details['training_task_id'])
  288. ->where('subclass',$exam_paper_details['subclass'])
  289. ->where('study_status','<',5)
  290. ->count();
  291. if($workerCourseCount == 0){
  292. TrainingCategory::where('master_worker_id',$exam_paper_details['master_worker_id'])
  293. ->where('training_task_id',$exam_paper_details['training_task_id'])
  294. ->where('category_id',$exam_paper_details['subclass'])
  295. ->update(['is_must' => 1]);
  296. $masterWorker = MasterWorker::where('id',$exam_paper_details['master_worker_id'])->findOrEmpty();
  297. $category_ids = explode(',',$masterWorker->category_ids);
  298. $category_ids[] = $exam_paper_details['subclass'];
  299. $category_ids = array_unique($category_ids);
  300. // 更新工程师服务类目
  301. MasterWorker::update(['category_ids' => implode(',',$category_ids)],['id'=>$exam_paper_details['master_worker_id']]);
  302. }
  303. }
  304. }else{
  305. // 该工程师的课程全部完成,更新任务状态
  306. $workerCourseCount = TrainingWorkerCourse::where('master_worker_id',$exam_paper_details['master_worker_id'])
  307. ->where('training_task_id',$exam_paper_details['training_task_id'])
  308. ->where('study_status','<',5)
  309. ->count();
  310. if($workerCourseCount == 0){
  311. TrainingWorkerTask::where('master_worker_id',$exam_paper_details['master_worker_id'])
  312. ->where('training_task_id',$exam_paper_details['training_task_id'])
  313. ->where('training_status',1)
  314. ->update(['training_status'=>2]);
  315. }
  316. }
  317. Db::commit();
  318. return true;
  319. }catch(\Exception $e){
  320. Db::rollback();
  321. self::setError($e->getMessage());
  322. return false;
  323. }
  324. }
  325. public static function getExamPaperDetails($params){
  326. // 试卷详情
  327. $workerCourse = [];
  328. if(isset($params['worker_course_id'])){
  329. $workerCourse = TrainingWorkerCourse::where('id',$params['worker_course_id'])->findOrEmpty()->toArray();
  330. // 课程详情
  331. $course = TrainingCourse::where('id',$workerCourse['training_course_id'])->findOrEmpty()->toArray();
  332. // 若$workerCourse['course_question_setting']存在说明随机题 则 替换最新试题配置
  333. if($workerCourse['course_question_setting']){
  334. $course['course_question_setting'] = json_decode($workerCourse['course_question_setting'],true);
  335. }
  336. // 该课程所有试题 答案、分数
  337. $question_ids = array_column($course['course_question_setting'],'select_value')??[];
  338. $question_column = TrainingQuestions::whereIn('id',$question_ids)->column('question_answer','id');
  339. foreach ($course['course_question_setting'] as &$item) {
  340. $item['question_answer'] = $question_column[$item['select_value']];
  341. }
  342. $workerCourse['course'] = $course;
  343. }
  344. Log::info('exam_paper_details:'.json_encode($workerCourse));
  345. return $workerCourse;
  346. }
  347. /**
  348. * 考试结果统计
  349. * @param int $teamId
  350. * @param int $masterWorkerId
  351. * @return array
  352. */
  353. public static function examStatistics($params){
  354. // 计算考试结果: 总题数 正确率(>0的题数) 总得分(每题得分累计) | 总用时 是否合格
  355. // training_worker_question training_worker_course
  356. /*total_questions 总题数 correct_questions 正确题数 correct_rate_percentage 正确率 total_score 总得分
  357. exam_time 总用时秒*/
  358. $res = [];
  359. $res['statistics'] = TrainingWorkerQuestion::where('worker_course_id',$params['worker_course_id'])
  360. ->field(['worker_course_id',Db::raw('COUNT(id) AS total_questions,SUM(CASE WHEN exam_score > 0 THEN 1 ELSE 0 END) AS correct_questions,ROUND((SUM(CASE WHEN exam_score > 0 THEN 1 ELSE 0 END) / COUNT(id)) * 100, 0) AS correct_rate_percentage,SUM(exam_score) AS total_score')])
  361. ->group('worker_course_id')
  362. ->find();
  363. $workerCourse = TrainingWorkerCourse::where('id',$params['worker_course_id'])->findOrEmpty()->toArray();
  364. $res['statistics']['exam_time'] = $workerCourse['exam_end_time'] - $workerCourse['exam_start_time'];
  365. $res['statistics']['study_status'] = $workerCourse['study_status'];
  366. $res['statistics_list'] = TrainingWorkerQuestion::where('worker_course_id',$params['worker_course_id'])->select();
  367. return $res;
  368. }
  369. /**
  370. * 免费课程进入(不存在则创建返回ID)
  371. * @param array
  372. * @return array
  373. */
  374. public static function freeWorkerCourseId($masterWorkerId,$free_course_id){
  375. $free_course = TrainingWorkerCourse::where('master_worker_id',$masterWorkerId)
  376. ->where('training_task_id',0)
  377. ->where('subclass',0)
  378. ->where('training_course_id',$free_course_id)->findOrEmpty();
  379. if($free_course->isEmpty()){
  380. $free_course = TrainingWorkerCourse::create([
  381. 'master_worker_id' => $masterWorkerId,
  382. 'training_task_id' => 0,
  383. 'training_course_id' => $free_course_id,
  384. 'play_time' => 0,
  385. 'exam_start_time' => 0,
  386. 'exam_end_time' => 0,
  387. 'study_status' => 0,
  388. 'exam_score' => 0,
  389. ]);
  390. // 添加该工程师该课程的所有试题初始化记录
  391. //[{"block_key":1,"select_value":1,"score":"20"},{"block_key":2,"select_value":2,"score":"10"},{"block_key":3,"select_value":3,"score":"70"}]
  392. $course_question = json_decode(TrainingCourse::where('id',$free_course_id)->value('course_question_setting'),true);
  393. $course_question_ids = array_column($course_question,'select_value');
  394. foreach ($course_question_ids as $question_id) {
  395. $workerQuestion = TrainingWorkerQuestion::create([
  396. 'worker_course_id' => $free_course->id,
  397. 'questions_id' => $question_id,
  398. 'worker_answer' => '',
  399. 'exam_score' => 0
  400. ]);
  401. }
  402. }
  403. return $free_course->id;
  404. }
  405. /**
  406. * 提交分类
  407. * @param array
  408. * @return bool
  409. */
  410. public static function submitCategory($params){
  411. try {
  412. if(!isset($params['category_ids']) || empty($params['category_ids'])){
  413. throw new \Exception('分类不能为空');
  414. }
  415. $category_ids = explode(',',$params['category_ids']);
  416. foreach ($category_ids as $category_id) {
  417. // 检查该分类下是否存在该分类的培训任务以及课程?
  418. $trainingCategory = TrainingCategory::where('master_worker_id',$params['user_id'])->where('category_id',$category_id)->findOrEmpty();
  419. if($trainingCategory->isEmpty()){
  420. TrainingCategory::create([
  421. 'master_worker_id' => $params['user_id'],
  422. 'category_id' => $category_id
  423. ]);
  424. }
  425. }
  426. return true;
  427. }catch(\Exception $e){
  428. self::setError($e->getMessage());
  429. return false;
  430. }
  431. }
  432. /**
  433. * 获取所有类目信息
  434. * @param array
  435. * @return array
  436. */
  437. public static function getTrainingCategory($params){
  438. try {
  439. $lists = TrainingCategory::with(['goodsCategory'])->where('master_worker_id',$params['user_id'])->select()->toArray();
  440. foreach ($lists as &$item) {
  441. $item['category_id_text'] = $item['goodsCategory']['name'];
  442. $item['category_two_text'] = GoodsCategory::where('id',$item['goodsCategory']['pid']??0)->value('name')??'';
  443. $item['category_three_text'] = GoodsCategory::where('id',GoodsCategory::where('id',$item['goodsCategory']['pid'])->value('pid')??0)->value('name')??'';
  444. }
  445. return $lists;
  446. }catch(\Exception $e){
  447. self::setError($e->getMessage());
  448. return [];
  449. }
  450. }
  451. /**
  452. * 获取某类目所有课程任务ID
  453. * @param array
  454. * @return int
  455. */
  456. public static function getCategoryCourse($params){
  457. try {
  458. $trainingCategory = TrainingCategory::where('id',$params['id'])->findOrEmpty();
  459. if($trainingCategory->isEmpty()){
  460. throw new \Exception('该类目不存在');
  461. }
  462. $params['category_id'] = $trainingCategory->category_id;
  463. // 获取该类目 $trainingCategory->category_id 下随机课程|固定任务(固定课程) (随机数由配置决定)
  464. /*看配置 随机课程 0 固定任务 1 ( 那么就是每个分类对应一个任务即课程组)
  465. 随机---先补充需要添加任务 - 返回任务ID
  466. 固定---不需要添加任务 - 直接返回任务ID*/
  467. if($trainingCategory->training_task_id){ //存在
  468. $trainingTask = TrainingTask::where('id',$trainingCategory->training_task_id)->findOrEmpty();
  469. }else{ //不存在
  470. // 获取该类目下任务ID
  471. $trainingTask = TrainingTask::where('subclass',$params['category_id'])->findOrEmpty();
  472. if($trainingTask->isEmpty()){
  473. // 获取该类目 随机课程
  474. //$fixed_course_ids = [1,2,3];
  475. $trainingCourse = TrainingCourse::where('subclass',$trainingTask->subclass)->order(Db::raw('rand()'))->limit(3)->select()->toArray();
  476. if(empty($trainingCourse)){
  477. throw new \Exception('该类目下不存在课程,请联系客服配置');
  478. }
  479. $fixed_course_ids = array_column($trainingCourse,'id');
  480. $trainingTask = TrainingTask::create([
  481. 'task_name' => '分类ID-'.$params['category_id'],
  482. 'training_course_id' => array_map('intval', $fixed_course_ids),
  483. 'subclass' => $params['category_id'],
  484. 'master_worker_id' => $params['user_id'],
  485. ]);
  486. }
  487. /*$is_random_course = false; // 配置随机课程
  488. if($is_random_course){
  489. // 获取该类目配置 随机课程或类目下无任务则随机
  490. $fixed_course_ids = [1,2,3];
  491. $trainingTask = TrainingTask::create([
  492. 'task_name' => '分类ID-'.$params['category_id'],
  493. 'training_course_id' => array_map('intval', $fixed_course_ids),
  494. 'subclass' => $params['category_id'],
  495. 'master_worker_id' => $params['user_id'],
  496. ]);
  497. }else{
  498. // 获取该类目下任务ID
  499. $trainingTask = TrainingTask::where('subclass',$params['category_id'])->findOrEmpty();
  500. if($trainingTask->isEmpty()){
  501. throw new \Exception('该类目下不存在培训任务,请联系客服配置');
  502. }
  503. }*/
  504. $trainingCategory->training_task_id = $trainingTask->id;
  505. $trainingCategory->save();
  506. /*// 保证用户进来后该分类都是新课程记录 新试题记录 即原来的记录被删除
  507. TrainingWorkerCourse::where('master_worker_id',$params['user_id'])
  508. ->where('subclass',$params['category_id'])
  509. ->delete();
  510. TrainingWorkerQuestion::where('master_worker_id',$params['user_id'])
  511. ->where('subclass',$params['category_id'])
  512. ->delete();*/
  513. $training_course_ids = json_decode(TrainingTask::where('id',$trainingTask->id)->value('training_course_id')??'[]',true);
  514. // 添加该工程师的所有培训课程初始化记录
  515. foreach ($training_course_ids as $course_id) {
  516. $workerCourse = TrainingWorkerCourse::create([
  517. 'master_worker_id' => $params['user_id'],
  518. 'training_task_id' => $trainingTask->id,
  519. 'training_course_id' => $course_id,
  520. 'subclass' => $params['category_id'],
  521. 'play_time' => 0,
  522. 'exam_start_time' => 0,
  523. 'exam_end_time' => 0,
  524. 'study_status' => 0,
  525. 'exam_score' => 0,
  526. ]);
  527. $trainingCourse = TrainingCourse::where('id',$course_id)->findOrEmpty();
  528. // 配置是否随机出题? 0 1
  529. //$trainingCourse->randomly_question = true;
  530. if($trainingCourse->randomly_question){
  531. // 随机出题 随机x个试题 x由该课程配置决定 比如10个试题
  532. $trainingQuestions = TrainingQuestions::where('subclass',$trainingCourse->subclass)->order(Db::raw('rand()'))->limit($trainingCourse->randomly_num)->select()->toArray();
  533. if(empty($trainingQuestions)){
  534. throw new \Exception('该类目下不存在试题,请联系客服配置');
  535. }
  536. //每题多少分(按总分100分计算)
  537. $score = bcdiv(100, count($trainingQuestions), 2);
  538. $course_question = [];
  539. foreach ($trainingQuestions as $block_key => $trainingQuestion) {
  540. //[{"block_key":1,"select_value":1,"score":"20"},{"block_key":2,"select_value":2,"score":"10"},{"block_key":3,"select_value":3,"score":"70"}]
  541. $course_question[] = [
  542. 'block_key' => $block_key+1,
  543. 'select_value' => $trainingQuestion['id'],
  544. 'score' => $score
  545. ];
  546. }
  547. TrainingWorkerCourse::where('id',$workerCourse->id)->update(['course_question_setting'=>json_encode($course_question)]);
  548. }else{
  549. $course_question = $trainingCourse->course_question_setting;
  550. }
  551. if(empty($course_question)){
  552. throw new \Exception('该类目下不存在试题,请联系客服配置');
  553. }
  554. // 添加该工程师该课程的所有试题初始化记录
  555. $course_question_ids = array_column($course_question,'select_value');
  556. foreach ($course_question_ids as $question_id) {
  557. $workerQuestion = TrainingWorkerQuestion::create([
  558. 'master_worker_id' => $params['user_id'],
  559. 'subclass' => $params['category_id'],
  560. 'worker_course_id' => $workerCourse->id,
  561. 'questions_id' => $question_id,
  562. 'worker_answer' => '',
  563. 'exam_score' => 0
  564. ]);
  565. }
  566. }
  567. }
  568. //return self::getCourseList($params['user_id'],['training_task_id'=>$trainingTask->id]);
  569. return $trainingTask->id;
  570. }catch(\Exception $e){
  571. self::setError($e->getMessage());
  572. return false;
  573. }
  574. }
  575. }