From b2eec14bf5a5924d17640e484810f75663c1f38b Mon Sep 17 00:00:00 2001
From: Administrator <15274802129@163.com>
Date: Mon, 04 Aug 2025 10:39:58 +0800
Subject: [PATCH] fix(ai): 修复商品列表查询功能
---
src/main/java/cc/mrbird/febs/ai/service/impl/AiProductQuestionServiceImpl.java | 239 ++++++++++++++++++++++++++++-------------------------------
1 files changed, 113 insertions(+), 126 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..cdea318 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,28 @@
package cc.mrbird.febs.ai.service.impl;
+import cc.mrbird.febs.ai.entity.AiMemberRole;
+import cc.mrbird.febs.ai.entity.AiProductPoint;
import cc.mrbird.febs.ai.entity.AiProductQuestion;
+import cc.mrbird.febs.ai.entity.AiProductQuestionItem;
import cc.mrbird.febs.ai.mapper.AiProductQuestionMapper;
+import cc.mrbird.febs.ai.service.AiProductQuestionItemService;
import cc.mrbird.febs.ai.service.AiProductQuestionService;
+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 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 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 +37,127 @@
public class AiProductQuestionServiceImpl extends ServiceImpl<AiProductQuestionMapper, AiProductQuestion> implements AiProductQuestionService {
private final AiProductQuestionMapper aiProductQuestionMapper;
+ private final AiProductQuestionItemService aiProductQuestionItemService;
@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);
- }
-
- @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);
- }
-
- @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);
- }
-
- @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);
- }
-
- @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);
- }
-
- @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);
- }
-
- @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) {
- try {
- return this.save(aiProductQuestion);
- } catch (Exception e) {
- log.error("保存AI产品题目失败: ", e);
- return false;
+ 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
- @Transactional(rollbackFor = Exception.class)
- public boolean saveBatchProductQuestions(List<AiProductQuestion> productQuestions) {
- try {
- return this.saveBatch(productQuestions);
- } catch (Exception e) {
- log.error("批量保存AI产品题目失败: ", e);
- return false;
+ 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
- @Transactional(rollbackFor = Exception.class)
- public boolean updateProductQuestion(AiProductQuestion aiProductQuestion) {
- try {
- return this.updateById(aiProductQuestion);
- } catch (Exception e) {
- log.error("更新AI产品题目失败: ", e);
- return false;
+ 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
- @Transactional(rollbackFor = Exception.class)
- public boolean deleteById(String id) {
- try {
- return this.removeById(id);
- } catch (Exception e) {
- log.error("删除AI产品题目失败: ", e);
- return false;
- }
+ public List<AiProductQuestion> questionTree() {
+
+ return aiProductQuestionMapper.selectList(null);
}
- @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