feat：语音题

龚焕茏

2024-06-13 08afe9556ce0578cd879fff194d01f66610c86e7

feat：语音题

 src/main/java/com/ycl/jxkg/domain/entity/Question.java

@@ -24,6 +24,12 @@
    private Integer questionType;

    /**
     * 题目
     */
    @TableField("title")
    private String title;

    /**
     * 学科
     */
    @TableField("subject_id")
@@ -48,6 +54,18 @@
    private String content;

    /**
     * 语音文件
     */
    @TableField("audio_file")
    private String audioFile;

    /**
     * 原始文件名称
     */
    @TableField("original_file")
    private String originalFile;

    /**
     * 创建人
     */
    @TableField("create_user")

 src/main/java/com/ycl/jxkg/domain/vo/admin/question/QuestionEditRequestVO.java

@@ -39,4 +39,8 @@

    private Integer itemOrder;

    private String audioFile;

    private String originalFile;

}

 src/main/java/com/ycl/jxkg/service/impl/QuestionServiceImpl.java

@@ -18,6 +18,7 @@
import com.ycl.jxkg.service.QuestionService;
import com.ycl.jxkg.utils.DateTimeUtil;
import com.ycl.jxkg.utils.ExamUtil;
import com.ycl.jxkg.utils.HtmlUtil;
import com.ycl.jxkg.utils.JsonUtil;
import lombok.RequiredArgsConstructor;
import org.springframework.beans.BeanUtils;
@@ -60,6 +61,9 @@
        question.setDifficult(model.getDifficult());
        question.setContent(questionObject);
        question.setCreateUser(userId);
        question.setTitle(HtmlUtil.clear(model.getTitle()));
        question.setAudioFile(model.getAudioFile());
        question.setOriginalFile(model.getOriginalFile());
        questionMapper.insert(question);
        return question;
    }
@@ -74,6 +78,9 @@
        //题干、解析、选项等 更新
        String questionObject = setQuestionInfoFromVM(model);
        question.setContent(questionObject);
        question.setTitle(HtmlUtil.clear(model.getTitle()));
        question.setAudioFile(model.getAudioFile());
        question.setOriginalFile(model.getOriginalFile());
        questionMapper.updateById(question);
        return question;
    }

 src/main/resources/mapper/ExamPaperAnswerMapper.xml

@@ -86,7 +86,6 @@
        a.id,
        a.name AS paperName,
        a.score DIV 10 AS systemScore,
        a.question_count,
        a.subject_id,
        a.paper_type,
        a.suggest_time,

 src/main/resources/mapper/QuestionMapper.xml

@@ -21,7 +21,13 @@
    <select id="page" resultType="com.ycl.jxkg.domain.vo.admin.question.QuestionResponseVO" parameterType="com.ycl.jxkg.domain.vo.admin.question.QuestionPageRequestVO">
        SELECT
        tq.*,
        CASE WHEN tq.question_type = 1 THEN '单选题' WHEN tq.question_type = 2 THEN '多选题' WHEN tq.question_type = 3 THEN '判断题' WHEN tq.question_type = 4 THEN '填空题' WHEN tq.question_type = 5 THEN '简答题' END AS questionTypeName,
        CASE WHEN tq.question_type = 1 THEN '单选题'
        WHEN tq.question_type = 2 THEN '多选题'
        WHEN tq.question_type = 3 THEN '判断题'
        WHEN tq.question_type = 4 THEN '填空题'
        WHEN tq.question_type = 5 THEN '简答题'
        WHEN tq.question_type = 6 THEN '语音题'
        END AS questionTypeName,
        ts.name AS subjectName,
        tu.real_name AS createUserName
        FROM t_question tq