fix(ai):修复根据公司ID查询工作流的空值处理

Administrator

2 days ago 26b39b241617a21223b5cdef2bb8fd8616f61a1a

fix(ai):修复根据公司ID查询工作流的空值处理

- 添加对 companyId为空情况的判断
- 当 companyId 为空时，查询条件改为 IS NULL
- 避免因空字符串导致的查询异常

 src/main/java/cc/mrbird/febs/ai/service/impl/AiCompanyWorkflowServiceImpl.java

@@ -3,6 +3,7 @@
import cc.mrbird.febs.ai.entity.AiCompanyWorkflow;
import cc.mrbird.febs.ai.mapper.AiCompanyWorkflowMapper;
import cc.mrbird.febs.ai.service.AiCompanyWorkflowService;
import cn.hutool.core.util.StrUtil;
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import com.baomidou.mybatisplus.core.toolkit.Wrappers;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
@@ -21,7 +22,11 @@
    public AiCompanyWorkflow getByTypeAndCompanyId(Integer type, String companyId) {
        LambdaQueryWrapper<AiCompanyWorkflow> query = Wrappers.lambdaQuery(AiCompanyWorkflow.class);
        query.eq(AiCompanyWorkflow::getType, type);
        if (StrUtil.isEmpty(companyId)){
            query.isNull(AiCompanyWorkflow::getCompanyId);
        }else{
        query.eq(AiCompanyWorkflow::getCompanyId, companyId);
        }
        query.last("limit 1");
        return aiCompanyWorkflowMapper.selectOne(query);
    }