From d87094a39d864993006b4f7a10209f0d96749ba4 Mon Sep 17 00:00:00 2001
From: Administrator <15274802129@163.com>
Date: Fri, 24 Oct 2025 15:07:39 +0800
Subject: [PATCH] feat(ai): 添加产品ID字段以优化查询条件
---
src/main/java/cc/mrbird/febs/ai/service/impl/AiMemberTalkItemServiceImpl.java | 76 ++++++++++++++++++++++++++++++++++++--
1 files changed, 72 insertions(+), 4 deletions(-)
diff --git a/src/main/java/cc/mrbird/febs/ai/service/impl/AiMemberTalkItemServiceImpl.java b/src/main/java/cc/mrbird/febs/ai/service/impl/AiMemberTalkItemServiceImpl.java
index c3dc6d5..cd6e136 100644
--- a/src/main/java/cc/mrbird/febs/ai/service/impl/AiMemberTalkItemServiceImpl.java
+++ b/src/main/java/cc/mrbird/febs/ai/service/impl/AiMemberTalkItemServiceImpl.java
@@ -1,16 +1,28 @@
package cc.mrbird.febs.ai.service.impl;
+import cc.mrbird.febs.ai.enumerates.AiTypeEnum;
import cc.mrbird.febs.ai.entity.AiMemberTalkItem;
import cc.mrbird.febs.ai.mapper.AiMemberTalkItemMapper;
+import cc.mrbird.febs.ai.req.ai.AiMessage;
+import cc.mrbird.febs.ai.req.memberTalk.ApiMemberTalkItemPageDto;
+import cc.mrbird.febs.ai.req.memberTalk.ApiTalkMemberListDto;
+import cc.mrbird.febs.ai.res.memberTalk.ApiMemberTalkItemVo;
+import cc.mrbird.febs.ai.res.memberTalk.ApiTalkMemberListVo;
import cc.mrbird.febs.ai.service.AiMemberTalkItemService;
import cc.mrbird.febs.ai.utils.UUID;
+import cc.mrbird.febs.common.entity.FebsResponse;
+import cn.hutool.core.collection.CollUtil;
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.volcengine.ark.runtime.model.completion.chat.ChatMessageRole;
import lombok.RequiredArgsConstructor;
import lombok.extern.slf4j.Slf4j;
import org.springframework.stereotype.Service;
-import org.springframework.transaction.annotation.Transactional;
+import java.util.ArrayList;
import java.util.Date;
import java.util.List;
@@ -27,21 +39,77 @@
private final AiMemberTalkItemMapper aiMemberTalkItemMapper;
-
@Override
- public void add(String memberUuid, String id, int type, String resContext,Date createdTime) {
+ public AiMemberTalkItem add(String memberUuid, String id, String companyId, int type, String resContext,Date createdTime) {
AiMemberTalkItem aiMemberTalkItem = new AiMemberTalkItem();
aiMemberTalkItem.setId(UUID.getSimpleUUIDString());
+ aiMemberTalkItem.setCompanyId(companyId);
aiMemberTalkItem.setCreatedTime(createdTime);
aiMemberTalkItem.setMemberId(memberUuid);
aiMemberTalkItem.setMemberTalkId(id);
aiMemberTalkItem.setType(type);
aiMemberTalkItem.setContext(resContext);
aiMemberTalkItemMapper.insert(aiMemberTalkItem);
+
+ return aiMemberTalkItem;
}
@Override
- public AiMemberTalkItem getByQuery(LambdaQueryWrapper<AiMemberTalkItem> memberTalkItemQuery) {
+ public AiMemberTalkItem getOneByQuery(LambdaQueryWrapper<AiMemberTalkItem> memberTalkItemQuery) {
return aiMemberTalkItemMapper.selectOne(memberTalkItemQuery);
}
+
+ @Override
+ public List<AiMemberTalkItem> getListByQuery(LambdaQueryWrapper<AiMemberTalkItem> memberTalkItemQuery) {
+ return aiMemberTalkItemMapper.selectList(memberTalkItemQuery);
+ }
+
+ @Override
+ public IPage<ApiMemberTalkItemVo> historyPage(ApiMemberTalkItemPageDto dto) {
+ // 创建分页对象，传入当前页和每页大小
+ Page<ApiMemberTalkItemVo> page = new Page<>(dto.getPageNow(), dto.getPageSize());
+ return aiMemberTalkItemMapper.getPageListByQuery(page, dto);
+ }
+
+ @Override
+ public List<AiMessage> getQuestionUpDownContext(String memberTalkId, int code) {
+ List<AiMessage> aiMessages = new ArrayList<>();
+
+ LambdaQueryWrapper<AiMemberTalkItem> query = Wrappers.lambdaQuery(AiMemberTalkItem.class);
+ if (AiTypeEnum.QUESTION.getCode() == code){
+ query.eq(AiMemberTalkItem::getType,AiTypeEnum.QUESTION_ANSWER.getCode());
+ query.eq(AiMemberTalkItem::getMemberTalkId,memberTalkId);
+ query.orderByDesc(AiMemberTalkItem::getCreatedTime);
+ query.last("limit 1");
+ List<AiMemberTalkItem> aiMemberTalkItems = aiMemberTalkItemMapper.selectList(query);
+ if (CollUtil.isNotEmpty(aiMemberTalkItems)){
+ AiMessage assistantMessage = new AiMessage();
+ assistantMessage.setRole(ChatMessageRole.ASSISTANT);
+ assistantMessage.setContent(aiMemberTalkItems.get(0).getContext());
+ aiMessages.add(assistantMessage);
+ }
+ }
+ if (AiTypeEnum.ANSWER.getCode() == code){
+ query.eq(AiMemberTalkItem::getType,AiTypeEnum.ANSWER_ANALYSIS.getCode());
+ query.eq(AiMemberTalkItem::getMemberTalkId,memberTalkId);
+ query.orderByDesc(AiMemberTalkItem::getCreatedTime);
+ query.last("limit 1");
+ List<AiMemberTalkItem> aiMemberTalkItems = aiMemberTalkItemMapper.selectList(query);
+ if (CollUtil.isNotEmpty(aiMemberTalkItems)){
+ AiMessage assistantMessage = new AiMessage();
+ assistantMessage.setRole(ChatMessageRole.ASSISTANT);
+ assistantMessage.setContent(aiMemberTalkItems.get(0).getContext());
+ aiMessages.add(assistantMessage);
+ }
+ }
+ return aiMessages;
+ }
+
+ @Override
+ public IPage<ApiTalkMemberListVo> getPageByDto(ApiTalkMemberListDto dto) {
+ // 创建分页对象，传入当前页和每页大小
+ Page<ApiTalkMemberListVo> page = new Page<>(dto.getPageNow(), dto.getPageSize());
+ return aiMemberTalkItemMapper.getPageByDto(page, dto);
+ }
+
}
--
Gitblit v1.9.1