From d7e5728e207bf0ac67d3a9f6684e60dff31e21a5 Mon Sep 17 00:00:00 2001
From: Administrator <15274802129@163.com>
Date: Fri, 05 Sep 2025 17:43:24 +0800
Subject: [PATCH] refactor(ai): 优化产品要点页面布局和代码结构
---
src/main/java/cc/mrbird/febs/ai/service/impl/AiProductQuestionServiceImpl.java | 318 +++++++++++++++++++++++++++++++++-------------------
1 files changed, 199 insertions(+), 119 deletions(-)
diff --git a/src/main/java/cc/mrbird/febs/ai/service/impl/AiProductQuestionServiceImpl.java b/src/main/java/cc/mrbird/febs/ai/service/impl/AiProductQuestionServiceImpl.java
index 90d990b..d125cf8 100644
--- a/src/main/java/cc/mrbird/febs/ai/service/impl/AiProductQuestionServiceImpl.java
+++ b/src/main/java/cc/mrbird/febs/ai/service/impl/AiProductQuestionServiceImpl.java
@@ -1,15 +1,33 @@
package cc.mrbird.febs.ai.service.impl;
-import cc.mrbird.febs.ai.entity.AiProductQuestion;
+import cc.mrbird.febs.ai.entity.*;
import cc.mrbird.febs.ai.mapper.AiProductQuestionMapper;
+import cc.mrbird.febs.ai.req.AiProductQuestionAiDto;
+import cc.mrbird.febs.ai.service.AiProductQuestionItemService;
import cc.mrbird.febs.ai.service.AiProductQuestionService;
+import cc.mrbird.febs.ai.service.AiService;
+import cc.mrbird.febs.ai.util.UUID;
+import cc.mrbird.febs.common.entity.FebsResponse;
+import cc.mrbird.febs.common.entity.QueryRequest;
+import cn.hutool.core.collection.CollUtil;
+import cn.hutool.core.util.ObjectUtil;
+import cn.hutool.json.JSONArray;
+import cn.hutool.json.JSONObject;
+import cn.hutool.json.JSONUtil;
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
+import com.baomidou.mybatisplus.core.metadata.IPage;
+import com.baomidou.mybatisplus.core.toolkit.Wrappers;
+import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
+import com.fasterxml.jackson.databind.JsonNode;
+import com.fasterxml.jackson.databind.ObjectMapper;
+import com.fasterxml.jackson.databind.SerializationFeature;
import lombok.RequiredArgsConstructor;
import lombok.extern.slf4j.Slf4j;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
+import java.util.Date;
import java.util.List;
/**
@@ -24,153 +42,215 @@
public class AiProductQuestionServiceImpl extends ServiceImpl<AiProductQuestionMapper, AiProductQuestion> implements AiProductQuestionService {
private final AiProductQuestionMapper aiProductQuestionMapper;
+ private final AiProductQuestionItemService aiProductQuestionItemService;
+ private final AiService aiService;
@Override
public AiProductQuestion getById(String id) {
- return this.getById(id);
+
+ return aiProductQuestionMapper.selectById(id);
}
@Override
- public List<AiProductQuestion> getByCompanyId(String companyId) {
- LambdaQueryWrapper<AiProductQuestion> queryWrapper = new LambdaQueryWrapper<>();
- queryWrapper.eq(AiProductQuestion::getCompanyId, companyId);
- queryWrapper.orderByDesc(AiProductQuestion::getCreatedTime);
- return this.list(queryWrapper);
+ public IPage<AiProductQuestion> listInPage(AiProductQuestion dto, QueryRequest request) {
+ Page<AiProductQuestion> page = new Page<>(request.getPageNum(), request.getPageSize());
+ LambdaQueryWrapper<AiProductQuestion> query = Wrappers.lambdaQuery(AiProductQuestion.class);
+ query.ne(AiProductQuestion::getState, 2);
+ Page<AiProductQuestion> pages = aiProductQuestionMapper.selectPage(page, query);
+ return pages;
}
@Override
- public List<AiProductQuestion> getByProductCategoryId(String productCategoryId) {
- LambdaQueryWrapper<AiProductQuestion> queryWrapper = new LambdaQueryWrapper<>();
- queryWrapper.eq(AiProductQuestion::getProductCategoryId, productCategoryId);
- queryWrapper.orderByDesc(AiProductQuestion::getCreatedTime);
- return this.list(queryWrapper);
+ public FebsResponse changeState(String id, Integer state) {
+ AiProductQuestion entity = this.getById(id);
+ if(ObjectUtil.isNotEmpty(entity)){
+ this.update(null,
+ Wrappers.lambdaUpdate(AiProductQuestion.class)
+ .set(AiProductQuestion::getState, state)
+ .set(AiProductQuestion::getUpdatedTime, new Date())
+ .eq(AiProductQuestion::getId, id));
+ }
+ return new FebsResponse().success().message("操作成功");
}
@Override
- public List<AiProductQuestion> getByTitle(String title) {
- LambdaQueryWrapper<AiProductQuestion> queryWrapper = new LambdaQueryWrapper<>();
- queryWrapper.like(AiProductQuestion::getTitle, title);
- queryWrapper.orderByDesc(AiProductQuestion::getCreatedTime);
- return this.list(queryWrapper);
+ public FebsResponse add(AiProductQuestion dto) {
+
+ List<AiProductQuestionItem> aiProductQuestionItems = dto.getAiProductQuestionItems();
+ if(CollUtil.isEmpty(aiProductQuestionItems)){
+ return new FebsResponse().fail().message("请添加答案选项");
+ }
+ //stream流操作aiProductQuestionItems，返回aiProductQuestionItems是否存在中correctAnswer为1的元素
+ boolean hasCorrectAnswer = aiProductQuestionItems.stream().anyMatch(item -> item != null && item.getCorrectAnswer() != null && item.getCorrectAnswer() == 1);
+ if (!hasCorrectAnswer) {
+ return new FebsResponse().fail().message("请添加一项为正确的答案");
+ }
+
+ AiProductQuestion entity = new AiProductQuestion();
+ entity.setId(UUID.getSimpleUUIDString());
+ entity.setCompanyId(dto.getCompanyId());
+ entity.setProductCategoryId(dto.getProductCategoryId());
+ entity.setTitle(dto.getTitle());
+ entity.setDifficulty(dto.getDifficulty());
+ entity.setCreatedTime(new Date());
+ this.save(entity);
+
+
+ for (AiProductQuestionItem item : dto.getAiProductQuestionItems()){
+ item.setId(UUID.getSimpleUUIDString());
+ item.setProductQuestionId(entity.getId());
+ item.setTitle(entity.getTitle());
+ item.setCreatedTime(new Date());
+ aiProductQuestionItemService.getBaseMapper().insert(item);
+ }
+ return new FebsResponse().success().message("操作成功");
+ }
+
+
+
+ @Override
+ public FebsResponse update(AiProductQuestion dto) {
+ String id = dto.getId();
+ AiProductQuestion entity = this.getById(id);
+
+ List<AiProductQuestionItem> aiProductQuestionItems = dto.getAiProductQuestionItems();
+ if(CollUtil.isEmpty(aiProductQuestionItems)){
+ return new FebsResponse().fail().message("请添加答案选项");
+ }
+ //stream流操作aiProductQuestionItems，返回aiProductQuestionItems是否存在中correctAnswer为1的元素
+ boolean hasCorrectAnswer = aiProductQuestionItems.stream().anyMatch(item -> item != null && item.getCorrectAnswer() != null && item.getCorrectAnswer() == 1);
+ if (!hasCorrectAnswer) {
+ return new FebsResponse().fail().message("请添加一项为正确的答案");
+ }
+ if (ObjectUtil.isNotNull( entity)){
+ this.update(null,
+ Wrappers.lambdaUpdate(AiProductQuestion.class)
+ .set(AiProductQuestion::getCompanyId, dto.getCompanyId())
+ .set(AiProductQuestion::getProductCategoryId, dto.getProductCategoryId())
+ .set(AiProductQuestion::getTitle, dto.getTitle())
+ .set(AiProductQuestion::getDifficulty, dto.getDifficulty())
+ .set(AiProductQuestion::getUpdatedTime, new Date())
+ .eq(AiProductQuestion::getId, id)
+ );
+
+ aiProductQuestionItemService.deleteByQuestionId(id);
+
+ for (AiProductQuestionItem item : dto.getAiProductQuestionItems()){
+ item.setId(UUID.getSimpleUUIDString());
+ item.setProductQuestionId(entity.getId());
+ item.setTitle(entity.getTitle());
+ item.setCreatedTime(new Date());
+ aiProductQuestionItemService.getBaseMapper().insert(item);
+ }
+ }
+ return new FebsResponse().success().message("操作成功");
}
@Override
- public List<AiProductQuestion> getByParentId(String parentId) {
- LambdaQueryWrapper<AiProductQuestion> queryWrapper = new LambdaQueryWrapper<>();
- queryWrapper.eq(AiProductQuestion::getParentId, parentId);
- queryWrapper.orderByAsc(AiProductQuestion::getCreatedTime);
- return this.list(queryWrapper);
+ public FebsResponse delete(String id) {
+ AiProductQuestion entity = this.getById(id);
+ if(ObjectUtil.isNotNull( entity)){
+ this.update(null,
+ Wrappers.lambdaUpdate(AiProductQuestion.class)
+ .set(AiProductQuestion::getState, 2)
+ .set(AiProductQuestion::getUpdatedTime, new Date())
+ .eq(AiProductQuestion::getId, id));
+
+ }
+ return new FebsResponse().success().message("操作成功");
}
@Override
- public List<AiProductQuestion> getByDifficulty(Integer difficulty) {
- LambdaQueryWrapper<AiProductQuestion> queryWrapper = new LambdaQueryWrapper<>();
- queryWrapper.eq(AiProductQuestion::getDifficulty, difficulty);
- queryWrapper.orderByDesc(AiProductQuestion::getCreatedTime);
- return this.list(queryWrapper);
+ public List<AiProductQuestion> questionTree() {
+
+ return aiProductQuestionMapper.selectList(null);
}
@Override
- public List<AiProductQuestion> getByState(Integer state) {
- LambdaQueryWrapper<AiProductQuestion> queryWrapper = new LambdaQueryWrapper<>();
- queryWrapper.eq(AiProductQuestion::getState, state);
- queryWrapper.orderByDesc(AiProductQuestion::getCreatedTime);
- return this.list(queryWrapper);
+ public List<AiProductQuestion> productQuestionTree(LambdaQueryWrapper<AiProductQuestion> aiProductQuestionLambdaQueryWrapper) {
+ return aiProductQuestionMapper.selectList(aiProductQuestionLambdaQueryWrapper);
}
@Override
- public List<AiProductQuestion> getByCorrectAnswer(Integer correctAnswer) {
- LambdaQueryWrapper<AiProductQuestion> queryWrapper = new LambdaQueryWrapper<>();
- queryWrapper.eq(AiProductQuestion::getCorrectAnswer, correctAnswer);
- queryWrapper.orderByDesc(AiProductQuestion::getCreatedTime);
- return this.list(queryWrapper);
+ public FebsResponse aiAdd(AiProductQuestionAiDto dto) {
+
+ String jsonFormat = "{\"question_list\":[{\"title\": \"消费者对透明质酸的主要担忧是什么？\",\"answer_list\":[{\"answer\": \"消费者担心透明质酸维持时间短，效果不明显。\",\"type\": 1,\"analysis\": \"\"},{\"answer\": \"消费者担心透明质酸注射后可能出现移位、凹陷、馒化、僵硬以及炎症反应。\",\"type\": 1,\"analysis\": \"\"},{\"answer\": \"消费者的主要担忧包括效果不明显、维持时间短、注射后出现移位、凹陷、馒化、僵硬以及炎症反应。他们希望既达到理想效果，又避免这些副作用。\",\"type\": 2,\"analysis\": \"标准答案涵盖了消费者对透明质酸的所有主要担忧，既包括效果问题，也涵盖副作用风险，全面反映消费者心理需求。\"}]}]} ";
+ dto.setJsonFormat(jsonFormat);
+ String questionAndAnswerStr = aiService.llmInvokeNonStreaming(dto);
+ System.out.println(questionAndAnswerStr);
+ // 解析AI返回的结果
+ List<JSONObject> questionList = parseAiQuestionResponse(questionAndAnswerStr);
+
+ String productCategoryId = dto.getProductCategoryId();
+ Integer difficulty = dto.getDifficulty();
+ Date createdTime = new Date();
+ // 处理解析后的问题列表
+ for (JSONObject questionObj : questionList) {
+ String title = questionObj.getStr("title");
+
+ AiProductQuestion aiProductQuestion = new AiProductQuestion();
+ aiProductQuestion.setId(UUID.getSimpleUUIDString());
+ aiProductQuestion.setProductCategoryId(productCategoryId);
+ aiProductQuestion.setTitle(title);
+ aiProductQuestion.setDifficulty(difficulty);
+ aiProductQuestion.setCreatedTime(createdTime);
+ this.save(aiProductQuestion);
+
+ JSONArray answerList = questionObj.getJSONArray("answer_list");
+ System.out.println("问题: " + title);
+ for (int i = 0; i < answerList.size(); i++) {
+ JSONObject answer = answerList.getJSONObject(i);
+ System.out.println("答案" + (i+1) + ": " + answer.getStr("answer"));
+ System.out.println("类型: " + answer.getStr("type"));
+ System.out.println("分析: " + answer.getStr("analysis"));
+ AiProductQuestionItem aiProductQuestionItem = new AiProductQuestionItem();
+ aiProductQuestionItem.setId(UUID.getSimpleUUIDString());
+ aiProductQuestionItem.setProductQuestionId(aiProductQuestion.getId());
+ aiProductQuestionItem.setTitle(aiProductQuestion.getTitle());
+ aiProductQuestionItem.setAnswer(answer.getStr("answer"));
+ aiProductQuestionItem.setCorrectAnswer(answer.getInt("type") == 2 ? 1 : 0);
+ aiProductQuestionItem.setAnswerAnalysis(answer.getStr("analysis"));
+ aiProductQuestionItem.setCreatedTime(createdTime);
+ aiProductQuestionItemService.getBaseMapper().insert(aiProductQuestionItem);
+ }
+ }
+ return new FebsResponse().success().message("操作成功");
}
- @Override
- public List<AiProductQuestion> getByCompanyIdAndState(String companyId, Integer state) {
- LambdaQueryWrapper<AiProductQuestion> queryWrapper = new LambdaQueryWrapper<>();
- queryWrapper.eq(AiProductQuestion::getCompanyId, companyId);
- queryWrapper.eq(AiProductQuestion::getState, state);
- queryWrapper.orderByDesc(AiProductQuestion::getCreatedTime);
- return this.list(queryWrapper);
- }
-
- @Override
- public List<AiProductQuestion> getByParentIdAndState(String parentId, Integer state) {
- LambdaQueryWrapper<AiProductQuestion> queryWrapper = new LambdaQueryWrapper<>();
- queryWrapper.eq(AiProductQuestion::getParentId, parentId);
- queryWrapper.eq(AiProductQuestion::getState, state);
- queryWrapper.orderByAsc(AiProductQuestion::getCreatedTime);
- return this.list(queryWrapper);
- }
-
- @Override
- @Transactional(rollbackFor = Exception.class)
- public boolean saveProductQuestion(AiProductQuestion aiProductQuestion) {
+ /**
+ * 解析AI返回的包含问题和答案的JSON字符串
+ * @param aiResponse AI返回的原始响应字符串
+ * @return 解析后的问题列表
+ */
+ public List<JSONObject> parseAiQuestionResponse(String aiResponse) {
try {
- return this.save(aiProductQuestion);
+ // 解析外层JSON
+ JSONObject outerJson = JSONUtil.parseObj(aiResponse);
+
+ // 提取output字段
+ String output = outerJson.getStr("output");
+
+ // 去除<start>和</start>标签，并清理多余字符
+ String jsonContent = output.replace("<start>", "")
+ .replace("</start>", "")
+ .replace("\\n", "")
+ .replace("\\n", "")
+ .replace("\\\"", "\"")
+ .trim();
+
+ // 解析内部JSON
+ JSONObject innerJson = JSONUtil.parseObj(jsonContent);
+
+ // 提取question_list
+ JSONArray questionList = innerJson.getJSONArray("question_list");
+
+ // 转换为List<JSONObject>返回
+ return questionList.toList(JSONObject.class);
+
} catch (Exception e) {
- log.error("保存AI产品题目失败: ", e);
- return false;
+ log.error("解析AI问题响应失败: ", e);
+ throw new RuntimeException("解析AI响应失败", e);
}
}
- @Override
- @Transactional(rollbackFor = Exception.class)
- public boolean saveBatchProductQuestions(List<AiProductQuestion> productQuestions) {
- try {
- return this.saveBatch(productQuestions);
- } catch (Exception e) {
- log.error("批量保存AI产品题目失败: ", e);
- return false;
- }
- }
-
- @Override
- @Transactional(rollbackFor = Exception.class)
- public boolean updateProductQuestion(AiProductQuestion aiProductQuestion) {
- try {
- return this.updateById(aiProductQuestion);
- } catch (Exception e) {
- log.error("更新AI产品题目失败: ", e);
- return false;
- }
- }
-
- @Override
- @Transactional(rollbackFor = Exception.class)
- public boolean deleteById(String id) {
- try {
- return this.removeById(id);
- } catch (Exception e) {
- log.error("删除AI产品题目失败: ", e);
- return false;
- }
- }
-
- @Override
- @Transactional(rollbackFor = Exception.class)
- public boolean deleteByParentId(String parentId) {
- try {
- LambdaQueryWrapper<AiProductQuestion> queryWrapper = new LambdaQueryWrapper<>();
- queryWrapper.eq(AiProductQuestion::getParentId, parentId);
- return this.remove(queryWrapper);
- } catch (Exception e) {
- log.error("根据父ID删除AI产品题目失败: ", e);
- return false;
- }
- }
-
- @Override
- @Transactional(rollbackFor = Exception.class)
- public boolean deleteByCompanyId(String companyId) {
- try {
- LambdaQueryWrapper<AiProductQuestion> queryWrapper = new LambdaQueryWrapper<>();
- queryWrapper.eq(AiProductQuestion::getCompanyId, companyId);
- return this.remove(queryWrapper);
- } catch (Exception e) {
- log.error("根据公司ID删除AI产品题目失败: ", e);
- return false;
- }
- }
}
--
Gitblit v1.9.1