From 6a4df2a4101533fc3e6805eaccf2dd4c31550095 Mon Sep 17 00:00:00 2001
From: Administrator <15274802129@163.com>
Date: Fri, 24 Oct 2025 17:11:10 +0800
Subject: [PATCH] fix(ai):修正产品依赖查询条件 - 将查询条件从大于等于改为小于等于 - 确保正确筛选出所需分数以下的产品依赖项
---
src/main/java/cc/mrbird/febs/ai/service/impl/AiMemberRoleProductServiceImpl.java | 119 +++--------------------------------------------------------
1 files changed, 6 insertions(+), 113 deletions(-)
diff --git a/src/main/java/cc/mrbird/febs/ai/service/impl/AiMemberRoleProductServiceImpl.java b/src/main/java/cc/mrbird/febs/ai/service/impl/AiMemberRoleProductServiceImpl.java
index 8ba2b70..49ebee2 100644
--- a/src/main/java/cc/mrbird/febs/ai/service/impl/AiMemberRoleProductServiceImpl.java
+++ b/src/main/java/cc/mrbird/febs/ai/service/impl/AiMemberRoleProductServiceImpl.java
@@ -4,6 +4,7 @@
import cc.mrbird.febs.ai.mapper.AiMemberRoleProductMapper;
import cc.mrbird.febs.ai.service.AiMemberRoleProductService;
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
+import com.baomidou.mybatisplus.core.toolkit.Wrappers;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import lombok.RequiredArgsConstructor;
import lombok.extern.slf4j.Slf4j;
@@ -25,121 +26,13 @@
private final AiMemberRoleProductMapper aiMemberRoleProductMapper;
- @Override
- public AiMemberRoleProduct getById(String id) {
- return this.getById(id);
- }
@Override
- public List<AiMemberRoleProduct> getByRoleId(String roleId) {
- LambdaQueryWrapper<AiMemberRoleProduct> queryWrapper = new LambdaQueryWrapper<>();
- queryWrapper.eq(AiMemberRoleProduct::getRoleId, roleId);
- return this.list(queryWrapper);
- }
+ public List<AiMemberRoleProduct> getProductListByMemberRoleId(String memberRoleId) {
- @Override
- public List<AiMemberRoleProduct> getByProductId(String productId) {
- LambdaQueryWrapper<AiMemberRoleProduct> queryWrapper = new LambdaQueryWrapper<>();
- queryWrapper.eq(AiMemberRoleProduct::getProductId, productId);
- return this.list(queryWrapper);
- }
-
- @Override
- public List<AiMemberRoleProduct> getByCompanyId(String companyId) {
- LambdaQueryWrapper<AiMemberRoleProduct> queryWrapper = new LambdaQueryWrapper<>();
- queryWrapper.eq(AiMemberRoleProduct::getCompanyId, companyId);
- return this.list(queryWrapper);
- }
-
- @Override
- public List<AiMemberRoleProduct> getByRoleIdAndProductId(String roleId, String productId) {
- LambdaQueryWrapper<AiMemberRoleProduct> queryWrapper = new LambdaQueryWrapper<>();
- queryWrapper.eq(AiMemberRoleProduct::getRoleId, roleId);
- queryWrapper.eq(AiMemberRoleProduct::getProductId, productId);
- return this.list(queryWrapper);
- }
-
- @Override
- @Transactional(rollbackFor = Exception.class)
- public boolean saveRoleProduct(AiMemberRoleProduct aiMemberRoleProduct) {
- try {
- return this.save(aiMemberRoleProduct);
- } catch (Exception e) {
- log.error("保存角色产品关联记录失败: ", e);
- return false;
- }
- }
-
- @Override
- @Transactional(rollbackFor = Exception.class)
- public boolean saveBatchRoleProducts(List<AiMemberRoleProduct> roleProducts) {
- try {
- return this.saveBatch(roleProducts);
- } catch (Exception e) {
- log.error("批量保存角色产品关联记录失败: ", e);
- return false;
- }
- }
-
- @Override
- @Transactional(rollbackFor = Exception.class)
- public boolean updateRoleProduct(AiMemberRoleProduct aiMemberRoleProduct) {
- try {
- return this.updateById(aiMemberRoleProduct);
- } catch (Exception e) {
- log.error("更新角色产品关联记录失败: ", e);
- return false;
- }
- }
-
- @Override
- @Transactional(rollbackFor = Exception.class)
- public boolean deleteById(String id) {
- try {
- return this.removeById(id);
- } catch (Exception e) {
- log.error("删除角色产品关联记录失败: ", e);
- return false;
- }
- }
-
- @Override
- @Transactional(rollbackFor = Exception.class)
- public boolean deleteByRoleId(String roleId) {
- try {
- LambdaQueryWrapper<AiMemberRoleProduct> queryWrapper = new LambdaQueryWrapper<>();
- queryWrapper.eq(AiMemberRoleProduct::getRoleId, roleId);
- return this.remove(queryWrapper);
- } catch (Exception e) {
- log.error("根据角色ID删除角色产品关联记录失败: ", e);
- return false;
- }
- }
-
- @Override
- @Transactional(rollbackFor = Exception.class)
- public boolean deleteByProductId(String productId) {
- try {
- LambdaQueryWrapper<AiMemberRoleProduct> queryWrapper = new LambdaQueryWrapper<>();
- queryWrapper.eq(AiMemberRoleProduct::getProductId, productId);
- return this.remove(queryWrapper);
- } catch (Exception e) {
- log.error("根据产品ID删除角色产品关联记录失败: ", e);
- return false;
- }
- }
-
- @Override
- @Transactional(rollbackFor = Exception.class)
- public boolean deleteByRoleIdAndProductId(String roleId, String productId) {
- try {
- LambdaQueryWrapper<AiMemberRoleProduct> queryWrapper = new LambdaQueryWrapper<>();
- queryWrapper.eq(AiMemberRoleProduct::getRoleId, roleId);
- queryWrapper.eq(AiMemberRoleProduct::getProductId, productId);
- return this.remove(queryWrapper);
- } catch (Exception e) {
- log.error("根据角色ID和产品ID删除角色产品关联记录失败: ", e);
- return false;
- }
+ return aiMemberRoleProductMapper.selectList(
+ Wrappers.lambdaQuery(AiMemberRoleProduct.class)
+ .eq(AiMemberRoleProduct::getRoleId, memberRoleId)
+ );
}
}
--
Gitblit v1.9.1