From e2bd522c69969233f7b2835b69bb27702ed09c92 Mon Sep 17 00:00:00 2001
From: Administrator <15274802129@163.com>
Date: Mon, 04 Aug 2025 18:13:24 +0800
Subject: [PATCH] feat(ai): 新增答题功能 - 新增答题记录接口和相关实体类 - 实现开始答题、答题、提交和上一题功能 - 添加答题记录和题目相关查询接口 - 优化答题流程和数据结构

---
 src/main/java/cc/mrbird/febs/ai/service/impl/AiMemberAnswerServiceImpl.java |  237 ++++++++++++++++++++++++++++++++++++++++++++++++++++++----
 1 files changed, 218 insertions(+), 19 deletions(-)

diff --git a/src/main/java/cc/mrbird/febs/ai/service/impl/AiMemberAnswerServiceImpl.java b/src/main/java/cc/mrbird/febs/ai/service/impl/AiMemberAnswerServiceImpl.java
index ede9b9c..9a1587e 100644
--- a/src/main/java/cc/mrbird/febs/ai/service/impl/AiMemberAnswerServiceImpl.java
+++ b/src/main/java/cc/mrbird/febs/ai/service/impl/AiMemberAnswerServiceImpl.java
@@ -1,28 +1,35 @@
 package cc.mrbird.febs.ai.service.impl;
 
-import cc.mrbird.febs.ai.entity.AiMemberAnswer;
-import cc.mrbird.febs.ai.entity.AiMemberAnswerItem;
-import cc.mrbird.febs.ai.entity.AiProduct;
-import cc.mrbird.febs.ai.entity.AiProductQuestion;
+import cc.mrbird.febs.ai.entity.*;
 import cc.mrbird.febs.ai.mapper.AiMemberAnswerMapper;
 import cc.mrbird.febs.ai.req.memberAnswer.ApiMemberAnswerDto;
-import cc.mrbird.febs.ai.res.memberAnswer.ApiMemberAnswerVo;
-import cc.mrbird.febs.ai.service.AiMemberAnswerItemService;
-import cc.mrbird.febs.ai.service.AiMemberAnswerService;
-import cc.mrbird.febs.ai.service.AiProductQuestionService;
-import cc.mrbird.febs.ai.service.AiProductService;
+import cc.mrbird.febs.ai.req.memberAnswer.ApiMemberAnswerInsureDto;
+import cc.mrbird.febs.ai.req.memberAnswer.ApiMemberAnswerPreviousDto;
+import cc.mrbird.febs.ai.req.memberAnswer.ApiQuestionAnswerDto;
+import cc.mrbird.febs.ai.res.memberAnswer.*;
+import cc.mrbird.febs.ai.res.product.ApiProductVo;
+import cc.mrbird.febs.ai.res.productQuestionItem.ApiMemberAnswerItemVo;
+import cc.mrbird.febs.ai.service.*;
+import cc.mrbird.febs.ai.utils.UUID;
 import cc.mrbird.febs.common.entity.FebsResponse;
 import cc.mrbird.febs.common.utils.LoginUserUtil;
 import cn.hutool.core.collection.CollUtil;
+import cn.hutool.core.date.DateUnit;
+import cn.hutool.core.date.DateUtil;
 import cn.hutool.core.util.ObjectUtil;
 import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
 import com.baomidou.mybatisplus.core.toolkit.Wrappers;
+import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
 import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
 import lombok.RequiredArgsConstructor;
 import lombok.extern.slf4j.Slf4j;
 import org.springframework.stereotype.Service;
 import org.springframework.transaction.annotation.Transactional;
 
+import java.math.BigDecimal;
+import java.math.RoundingMode;
+import java.util.ArrayList;
+import java.util.Date;
 import java.util.List;
 
 /**
@@ -40,6 +47,14 @@
     private final AiMemberAnswerItemService aiMemberAnswerItemService;
     private final AiProductService aiProductService;
     private final AiProductQuestionService aiProductQuestionService;
+    private final AiProductQuestionItemService aiProductQuestionItemService;
+
+
+    @Override
+    public AiMemberAnswer getOneByQuery(LambdaQueryWrapper<AiMemberAnswer> aiMemberAnswerLambdaQueryWrapper) {
+        aiMemberAnswerLambdaQueryWrapper.last("limit 1");
+        return aiMemberAnswerMapper.selectOne(aiMemberAnswerLambdaQueryWrapper);
+    }
 
 
     @Override
@@ -62,18 +77,202 @@
             // todo 没有题目采用AI生成题目
             throw new RuntimeException("产品没有题目");
         }
-        ApiMemberAnswerVo apiMemberAnswerVo = new ApiMemberAnswerVo();
-        AiMemberAnswer aiMemberAnswer = new AiMemberAnswer();
-        aiMemberAnswer.setProductId(aiProduct.getId());
-        aiMemberAnswer.setMemberId(memberUuid);
-        aiMemberAnswer.setQuestionCnt(aiProduct.getQuestionCount());
-        aiMemberAnswer.setScore(0);
-        aiMemberAnswer.setCorrectCnt(0);
-        aiMemberAnswer.setState(0);
-        aiMemberAnswerMapper.insert(aiMemberAnswer);
+        //判断该产品是否有正在进行的练习
+        LambdaQueryWrapper<AiMemberAnswer> aiMemberAnswerLambdaQueryWrapper = Wrappers.lambdaQuery(AiMemberAnswer.class);
+        aiMemberAnswerLambdaQueryWrapper.eq(AiMemberAnswer::getMemberId,memberUuid);
+        aiMemberAnswerLambdaQueryWrapper.eq(AiMemberAnswer::getProductId,aiProduct.getId());
+        aiMemberAnswerLambdaQueryWrapper.eq(AiMemberAnswer::getState,0);
+        AiMemberAnswer aiMemberAnswer = this.getOneByQuery(aiMemberAnswerLambdaQueryWrapper);
+        if(ObjectUtil.isNull(aiMemberAnswer)){
+            aiMemberAnswer = new AiMemberAnswer();
+            aiMemberAnswer.setId(UUID.getSimpleUUIDString());
+            Date createdTime = new Date();
+            aiMemberAnswer.setCreatedTime(createdTime);
+            aiMemberAnswer.setUpdatedTime(createdTime);
+            aiMemberAnswer.setProductId(aiProduct.getId());
+            aiMemberAnswer.setMemberId(memberUuid);
+            aiMemberAnswer.setState(0);
+            aiMemberAnswer.setScore(0);
+            aiMemberAnswer.setQuestionCnt(aiProduct.getQuestionCount());
+            aiMemberAnswer.setDoneCnt(0);
+            aiMemberAnswer.setCorrectCnt(0);
+            aiMemberAnswerMapper.insert(aiMemberAnswer);
+        }
+        boolean checkMemberAnswerDone = this.checkMemberAnswerDone(aiMemberAnswer);
+        if(!checkMemberAnswerDone){
+            return new FebsResponse().fail().message("您已完成本次答题");
+        }
 
-//        apiMemberAnswerVo.setTitle();
+        ApiMemberAnswerVo apiMemberAnswerVo = new ApiMemberAnswerVo();
+        apiMemberAnswerVo.setName(aiProduct.getName());
+        apiMemberAnswerVo.setQuestionCnt(aiMemberAnswer.getQuestionCnt());
+        apiMemberAnswerVo.setDoneCnt(aiMemberAnswer.getDoneCnt());
+        apiMemberAnswerVo.setCorrectCnt(aiMemberAnswer.getCorrectCnt());
+        apiMemberAnswerVo.setProductId(aiMemberAnswer.getProductId());
+
+        AiProductQuestion aiProductQuestion = aiProductQuestionService.createQuestion(aiProduct.getId());
+        if(ObjectUtil.isNotNull(aiProductQuestion)){
+            apiMemberAnswerVo.setProductQuestionId(aiProductQuestion.getId());
+            apiMemberAnswerVo.setTitle(aiProductQuestion.getTitle());
+            apiMemberAnswerVo.setDifficulty(aiProductQuestion.getDifficulty());
+
+            List<ApiMemberAnswerItemVo> answerList = new ArrayList<>();
+            LambdaQueryWrapper<AiProductQuestionItem> productQuestionItemLambdaQueryWrapper = Wrappers.lambdaQuery(AiProductQuestionItem.class);
+            productQuestionItemLambdaQueryWrapper.eq(AiProductQuestionItem::getProductQuestionId,aiProductQuestion.getId());
+            productQuestionItemLambdaQueryWrapper.orderByAsc(AiProductQuestionItem::getCreatedTime);
+            List<AiProductQuestionItem> aiProductQuestionItems = aiProductQuestionItemService.getListByQuery(productQuestionItemLambdaQueryWrapper);
+            if (CollUtil.isNotEmpty(aiProductQuestionItems)){
+                for (AiProductQuestionItem aiProductQuestionItem : aiProductQuestionItems){
+                    ApiMemberAnswerItemVo apiMemberAnswerItemVo = new ApiMemberAnswerItemVo();
+                    apiMemberAnswerItemVo.setId(aiProductQuestionItem.getId());
+                    apiMemberAnswerItemVo.setAnswer(aiProductQuestionItem.getAnswer());
+                    apiMemberAnswerItemVo.setAnswerAnalysis(aiProductQuestionItem.getAnswerAnalysis());
+                    apiMemberAnswerItemVo.setCorrectAnswer(aiProductQuestionItem.getCorrectAnswer());
+                    answerList.add(apiMemberAnswerItemVo);
+                }
+            }
+            apiMemberAnswerVo.setAnswerList(answerList);
+        }
 
         return new FebsResponse().success().data(apiMemberAnswerVo);
     }
+
+    @Override
+    public boolean checkMemberAnswerDone(AiMemberAnswer aiMemberAnswer) {
+        Integer doneCnt = aiMemberAnswer.getDoneCnt();
+        Integer questionCnt = aiMemberAnswer.getQuestionCnt();
+        if (questionCnt > doneCnt){
+            return true;
+        }
+        return false;
+    }
+
+    @Override
+    public FebsResponse answer(ApiQuestionAnswerDto dto) {
+        String memberUuid = LoginUserUtil.getLoginUser().getMemberUuid();
+
+        ApiQuestionItemInfoVo apiQuestionItemInfoVo = new ApiQuestionItemInfoVo();
+
+        String productQuestionItemId = dto.getId();
+        String productQuestionId = dto.getProductQuestionId();
+        String memberAnswerId = dto.getMemberAnswerId();
+        AiMemberAnswer aiMemberAnswer = this.getById(memberAnswerId);
+
+        if(ObjectUtil.isNull(aiMemberAnswer)){
+            throw new RuntimeException("答题记录不存在");
+        }
+
+        Date createdTime = new Date();
+        AiMemberAnswerItem aiMemberAnswerItem = new AiMemberAnswerItem();
+        aiMemberAnswerItem.setId(UUID.getSimpleUUIDString());
+        aiMemberAnswerItem.setCreatedTime(createdTime);
+        aiMemberAnswerItem.setAnswerId(aiMemberAnswer.getId());
+        aiMemberAnswerItem.setProductId(aiMemberAnswer.getProductId());
+        aiMemberAnswerItem.setMemberId(memberUuid);
+        aiMemberAnswerItem.setProductQuestionId(productQuestionId);
+
+        AiProductQuestion aiProductQuestion = aiProductQuestionService.getById(productQuestionId);
+        aiMemberAnswerItem.setTitle(aiProductQuestion.getTitle());
+        aiMemberAnswerItem.setDifficulty(aiProductQuestion.getDifficulty());
+
+        LambdaQueryWrapper<AiProductQuestionItem> productQuestionItemLambdaQueryWrapper = Wrappers.lambdaQuery(AiProductQuestionItem.class);
+        productQuestionItemLambdaQueryWrapper.eq(AiProductQuestionItem::getProductQuestionId,aiProductQuestion.getId());
+        productQuestionItemLambdaQueryWrapper.eq(AiProductQuestionItem::getCorrectAnswer,1);
+        List<AiProductQuestionItem> listByQuery = aiProductQuestionItemService.getListByQuery(productQuestionItemLambdaQueryWrapper);
+        if(CollUtil.isNotEmpty(listByQuery)){
+            AiProductQuestionItem aiProductQuestionItem = listByQuery.get(0);
+            aiMemberAnswerItem.setAnswer(aiProductQuestionItem.getId());
+            aiMemberAnswerItem.setCorrectAnswer(aiProductQuestionItem.getCorrectAnswer());
+            aiMemberAnswerItem.setAnswerAnalysis(aiProductQuestionItem.getAnswerAnalysis());
+        }
+        aiMemberAnswerItem.setMemberAnswerQuestionId(productQuestionItemId);
+        aiMemberAnswerItem.setMemberAnswerState(
+                ObjectUtil.equal(aiMemberAnswerItem.getMemberAnswerQuestionId(),aiMemberAnswerItem.getAnswer()) ? 1 : 2
+        );
+        if (aiMemberAnswerItem.getMemberAnswerState() == 2){
+            aiMemberAnswerItem.setIsCollected(1);
+        }
+        aiMemberAnswerItemService.save(aiMemberAnswerItem);
+
+        aiMemberAnswer.setDoneCnt(aiMemberAnswer.getDoneCnt() + 1);
+        if (aiMemberAnswerItem.getMemberAnswerState() == 1){
+            aiMemberAnswer.setCorrectCnt(aiMemberAnswer.getCorrectCnt() + 1);
+        }
+        aiMemberAnswer.setUpdatedTime(createdTime);
+        this.updateById(aiMemberAnswer);
+
+        apiQuestionItemInfoVo.setAnswer(aiMemberAnswerItem.getAnswer());
+        apiQuestionItemInfoVo.setAnswerAnalysis(aiMemberAnswerItem.getAnswerAnalysis());
+        apiQuestionItemInfoVo.setMemberAnswerState(aiMemberAnswerItem.getMemberAnswerState());
+        return new FebsResponse().success().data(apiQuestionItemInfoVo);
+    }
+
+    @Override
+    public FebsResponse insure(ApiMemberAnswerInsureDto dto) {
+        String memberUuid = LoginUserUtil.getLoginUser().getMemberUuid();
+
+        ApiMemberAnswerInsureVo apiMemberAnswerInsureVo = new ApiMemberAnswerInsureVo();
+        String memberAnswerId = dto.getMemberAnswerId();
+        AiMemberAnswer aiMemberAnswer = this.getById(memberAnswerId);
+        Integer questionCnt = aiMemberAnswer.getQuestionCnt();
+        Integer correctCnt = aiMemberAnswer.getCorrectCnt();
+        Date createdTime = aiMemberAnswer.getCreatedTime();
+        Date updatedTime = aiMemberAnswer.getUpdatedTime();
+        apiMemberAnswerInsureVo.setCorrectCnt(correctCnt);
+
+        BigDecimal divide = new BigDecimal(correctCnt).divide(new BigDecimal(questionCnt), 2, RoundingMode.HALF_DOWN);
+        // 转换为百分比字符串
+        BigDecimal percentage = divide.multiply(new BigDecimal(100));
+        String percentageStr = percentage.setScale(2, RoundingMode.HALF_DOWN).toString() + "%";
+        apiMemberAnswerInsureVo.setCorrectCntPercent(percentageStr);
+
+        long between = DateUtil.between(createdTime, updatedTime, DateUnit.MINUTE);
+        apiMemberAnswerInsureVo.setUseTime(between);
+        return new FebsResponse().success().data(apiMemberAnswerInsureVo);
+    }
+
+    @Override
+    public FebsResponse previous(ApiMemberAnswerPreviousDto dto) {
+
+        String memberUuid = LoginUserUtil.getLoginUser().getMemberUuid();
+        ApiMemberAnswerPreviousVo apiMemberAnswerPreviousVo = new ApiMemberAnswerPreviousVo();
+
+        // 创建分页对象,传入当前页和每页大小
+        Page<ApiMemberAnswerPreviousVo> page = new Page<>(dto.getPageNow(), dto.getPageSize());
+        Page<ApiMemberAnswerPreviousVo> pageListByQuery = aiMemberAnswerItemService.getPageListByQuery(page, dto);
+        List<ApiMemberAnswerPreviousVo> records = pageListByQuery.getRecords();
+        if (CollUtil.isNotEmpty(records)){
+            apiMemberAnswerPreviousVo = records.get(0);
+
+            String memberAnswerId = apiMemberAnswerPreviousVo.getMemberAnswerId();
+            AiMemberAnswer aiMemberAnswer = this.getById(memberAnswerId);
+            String productId = aiMemberAnswer.getProductId();
+            AiProduct aiProduct = aiProductService.getById(productId);
+            apiMemberAnswerPreviousVo.setName(aiProduct.getName());
+            apiMemberAnswerPreviousVo.setQuestionCnt(aiMemberAnswer.getQuestionCnt());
+
+            String productQuestionId = apiMemberAnswerPreviousVo.getProductQuestionId();
+            AiProductQuestion aiProductQuestion = aiProductQuestionService.getById(productQuestionId);
+            apiMemberAnswerPreviousVo.setTitle(aiProductQuestion.getTitle());
+            apiMemberAnswerPreviousVo.setDifficulty(aiProductQuestion.getDifficulty());
+
+            List<ApiMemberAnswerPreviousItemVo> answerList = new ArrayList<>();
+            LambdaQueryWrapper<AiProductQuestionItem> productQuestionItemLambdaQueryWrapper = Wrappers.lambdaQuery(AiProductQuestionItem.class);
+            productQuestionItemLambdaQueryWrapper.eq(AiProductQuestionItem::getProductQuestionId,productQuestionId);
+            productQuestionItemLambdaQueryWrapper.orderByAsc(AiProductQuestionItem::getCreatedTime);
+            List<AiProductQuestionItem> listByQuery = aiProductQuestionItemService.getListByQuery(productQuestionItemLambdaQueryWrapper);
+            if(CollUtil.isNotEmpty(listByQuery)){
+                for (AiProductQuestionItem aiProductQuestionItem : listByQuery){
+                    ApiMemberAnswerPreviousItemVo apiMemberAnswerPreviousItemVo = new ApiMemberAnswerPreviousItemVo();
+                    apiMemberAnswerPreviousItemVo.setId(aiProductQuestionItem.getId());
+                    apiMemberAnswerPreviousItemVo.setAnswer(aiProductQuestionItem.getAnswer());
+                    apiMemberAnswerPreviousItemVo.setAnswerAnalysis(aiProductQuestionItem.getAnswerAnalysis());
+                    apiMemberAnswerPreviousItemVo.setCorrectAnswer(aiProductQuestionItem.getCorrectAnswer());
+                    answerList.add(apiMemberAnswerPreviousItemVo);
+                }
+                apiMemberAnswerPreviousVo.setAnswerList(answerList);
+            }
+        }
+        return new FebsResponse().success().data(apiMemberAnswerPreviousVo);
+    }
 }

--
Gitblit v1.9.1