ball/app/adminapi/logic/training/TrainingWorkerTaskLogic.php

<?php
// +----------------------------------------------------------------------
// | likeadmin快速开发前后端分离管理后台（PHP版）
// +----------------------------------------------------------------------
// | 欢迎阅读学习系统程序代码，建议反馈是我们前进的动力
// | 开源版本可自由商用，可去除界面版权logo
// | gitee下载：https://gitee.com/likeshop_gitee/likeadmin
// | github下载：https://github.com/likeshop-github/likeadmin
// | 访问官网：https://www.likeadmin.cn
// | likeadmin团队 版权所有 拥有最终解释权
// +----------------------------------------------------------------------
// | author: likeadminTeam
// +----------------------------------------------------------------------

namespace app\adminapi\logic\training;


use app\common\model\training\TrainingCourse;
use app\common\model\training\TrainingTask;
use app\common\model\training\TrainingWorkerCourse;
use app\common\model\training\TrainingWorkerQuestion;
use app\common\model\training\TrainingWorkerTask;
use app\common\logic\BaseLogic;
use think\facade\Db;


/**
 * TrainingWorkerTask逻辑
 * Class TrainingWorkerTaskLogic
 * @package app\adminapi\logic
 */
class TrainingWorkerTaskLogic extends BaseLogic
{


    /**
     * @notes 添加
     * @param array $params
     * @return bool
     * @author likeadmin
     * @date 2025/02/16 13:49
     */
    public static function add(array $params): bool
    {
        Db::startTrans();
        try {
            TrainingWorkerTask::create([
                'master_worker_id' => $params['master_worker_id'],
                'shop_goods_id' => $params['shop_goods_id'],
                'training_task_id' => $params['training_task_id'],
                'lead_master_worker_id' => $params['lead_master_worker_id'],
                'operate_status' => $params['operate_status']??0,
            ]);

            // 添加该工程师初始化记录
            self::trainingCourseRecord($params['master_worker_id'],$params['training_task_id']);

            Db::commit();
            return true;
        } catch (\Exception $e) {
            Db::rollback();
            self::setError($e->getMessage());
            return false;
        }
    }


    /**
     * @notes 编辑
     * @param array $params
     * @return bool
     * @author likeadmin
     * @date 2025/02/16 13:49
     */
    public static function edit(array $params): bool
    {
        Db::startTrans();
        try {
            TrainingWorkerTask::where('id', $params['id'])->update([
                'master_worker_id' => $params['master_worker_id'],
                'shop_goods_id' => $params['shop_goods_id'],
                'training_task_id' => $params['training_task_id'],
                'lead_master_worker_id' => $params['lead_master_worker_id'],
                'operate_status' => $params['operate_status']??0,
            ]);

            Db::commit();
            return true;
        } catch (\Exception $e) {
            Db::rollback();
            self::setError($e->getMessage());
            return false;
        }
    }


    /**
     * @notes 删除
     * @param array $params
     * @return bool
     * @author likeadmin
     * @date 2025/02/16 13:49
     */
    public static function delete(array $params): bool
    {
        return TrainingWorkerTask::destroy($params['id']);
    }


    /**
     * @notes 获取详情
     * @param $params
     * @return array
     * @author likeadmin
     * @date 2025/02/16 13:49
     */
    public static function detail($params): array
    {
        return TrainingWorkerTask::findOrEmpty($params['id'])->toArray();
    }

    /** 培训课程初始化记录
     */
    public static function trainingCourseRecord($masterWorkerId,$training_task_id): array
    {
        $training_course_ids  = json_decode(TrainingTask::where('id',$training_task_id)->value('training_course_id'),true);
        // 添加该工程师的所有培训课程初始化记录
        foreach ($training_course_ids as $course_id) {
            $workerCourse = TrainingWorkerCourse::create([
                'master_worker_id' => $masterWorkerId,
                'training_task_id' => $training_task_id,
                'training_course_id' => $course_id,
                'play_time' => 0,
                'exam_start_time' => 0,
                'exam_end_time' => 0,
                'study_status' => 0,
                'exam_score' => 0,
            ]);

            // 添加该工程师该课程的所有试题初始化记录
            //[{"block_key":1,"select_value":1,"score":"20"},{"block_key":2,"select_value":2,"score":"10"},{"block_key":3,"select_value":3,"score":"70"}]
            $course_question = json_decode(TrainingCourse::where('id',$course_id)->value('course_question_setting'),true);
            $course_question_ids = array_column($course_question,'select_value');
            foreach ($course_question_ids as $question_id) {
                $workerQuestion = TrainingWorkerQuestion::create([
                    'worker_course_id' => $workerCourse->id,
                    'questions_id' => $question_id,
                    'worker_answer' => '',
                    'exam_score' => 0
                ]);
            }
        }
        return $training_course_ids??[];
    }

}