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/AiMemberServiceImpl.java | 1 +
src/main/java/cc/mrbird/febs/ai/req/member/ApiMemberTalkPageDto.java | 4 ++++
src/main/java/cc/mrbird/febs/ai/res/member/ApiMemberTeamPracticeVo.java | 3 +++
src/main/resources/mapper/modules/AiMemberAnswerMapper.xml | 1 +
src/main/resources/mapper/modules/AiMemberTalkMapper.xml | 1 +
src/main/java/cc/mrbird/febs/ai/req/member/ApiMemberAnswerPageDto.java | 4 ++++
6 files changed, 14 insertions(+), 0 deletions(-)
diff --git a/src/main/java/cc/mrbird/febs/ai/req/member/ApiMemberAnswerPageDto.java b/src/main/java/cc/mrbird/febs/ai/req/member/ApiMemberAnswerPageDto.java
index 89eca68..eca977b 100644
--- a/src/main/java/cc/mrbird/febs/ai/req/member/ApiMemberAnswerPageDto.java
+++ b/src/main/java/cc/mrbird/febs/ai/req/member/ApiMemberAnswerPageDto.java
@@ -23,6 +23,10 @@
@ApiModelProperty(value = "会员ID", example = "10")
private String memberUuid;
+ @NotBlank(message = "产品ID不能为空")
+ @ApiModelProperty(value = "产品ID", example = "10")
+ private String productId;
+
@ApiModelProperty(hidden = true)
private String companyId;
diff --git a/src/main/java/cc/mrbird/febs/ai/req/member/ApiMemberTalkPageDto.java b/src/main/java/cc/mrbird/febs/ai/req/member/ApiMemberTalkPageDto.java
index e20090d..e88ea07 100644
--- a/src/main/java/cc/mrbird/febs/ai/req/member/ApiMemberTalkPageDto.java
+++ b/src/main/java/cc/mrbird/febs/ai/req/member/ApiMemberTalkPageDto.java
@@ -22,6 +22,10 @@
@ApiModelProperty(value = "会员ID", example = "10")
private String memberUuid;
+ @NotBlank(message = "产品ID不能为空")
+ @ApiModelProperty(value = "产品ID", example = "10")
+ private String productId;
+
@ApiModelProperty(hidden = true)
private String companyId;
}
diff --git a/src/main/java/cc/mrbird/febs/ai/res/member/ApiMemberTeamPracticeVo.java b/src/main/java/cc/mrbird/febs/ai/res/member/ApiMemberTeamPracticeVo.java
index ddf9fe4..ec5e210 100644
--- a/src/main/java/cc/mrbird/febs/ai/res/member/ApiMemberTeamPracticeVo.java
+++ b/src/main/java/cc/mrbird/febs/ai/res/member/ApiMemberTeamPracticeVo.java
@@ -14,6 +14,9 @@
@ApiModelProperty(value = "会员ID")
private String memberUuid;
+ @ApiModelProperty(value = "产品ID")
+ private String productId;
+
@ApiModelProperty(value = "名称")
private String name;
diff --git a/src/main/java/cc/mrbird/febs/ai/service/impl/AiMemberServiceImpl.java b/src/main/java/cc/mrbird/febs/ai/service/impl/AiMemberServiceImpl.java
index 362c510..1ea68f5 100644
--- a/src/main/java/cc/mrbird/febs/ai/service/impl/AiMemberServiceImpl.java
+++ b/src/main/java/cc/mrbird/febs/ai/service/impl/AiMemberServiceImpl.java
@@ -206,6 +206,7 @@
String productId = aiProduct.getId();
ApiMemberTeamPracticeVo vo = new ApiMemberTeamPracticeVo();
vo.setMemberUuid(memberUuid);
+ vo.setProductId(aiProduct.getId());
vo.setName(aiProduct.getName());
vo.setTarget(aiProduct.getTarget());
diff --git a/src/main/resources/mapper/modules/AiMemberAnswerMapper.xml b/src/main/resources/mapper/modules/AiMemberAnswerMapper.xml
index f08407c..5e1eb1c 100644
--- a/src/main/resources/mapper/modules/AiMemberAnswerMapper.xml
+++ b/src/main/resources/mapper/modules/AiMemberAnswerMapper.xml
@@ -38,6 +38,7 @@
left join ai_product b on a.product_id = b.id and b.state = 1
where a.member_id = #{record.memberUuid}
and a.state = 1
+ and a.product_id = #{record.productId}
and a.company_id = #{record.companyId}
order by a.CREATED_TIME desc
</select>
diff --git a/src/main/resources/mapper/modules/AiMemberTalkMapper.xml b/src/main/resources/mapper/modules/AiMemberTalkMapper.xml
index bc08ecd..4fd954d 100644
--- a/src/main/resources/mapper/modules/AiMemberTalkMapper.xml
+++ b/src/main/resources/mapper/modules/AiMemberTalkMapper.xml
@@ -28,6 +28,7 @@
<where>
and a.member_id = #{record.memberUuid}
and a.company_id = #{record.companyId}
+ and a.product_id = #{record.productId}
and a.state = 1
</where>
order by a.CREATED_TIME desc
--
Gitblit v1.9.1