chengf
2026-02-06 49158a77cb676a15bebe1be5507e18e5a30c1fa5
jeecg-module-system/jeecg-system-biz/src/main/java/org/jeecg/modules/demo/semanticword/controller/SemanticWordController.java
@@ -86,7 +86,9 @@
        }else {
            queryWrapper = QueryGenerator.initQueryWrapper(semanticWord, req.getParameterMap(),customeRuleMap);
        }
//        if (!semanticWord.getStatus().isEmpty()) {
//            queryWrapper.eq("status",semanticWord.getStatus());
//        }
        if (semanticWord.getUser() != null && !semanticWord.getUser().equals("admin")) {
            queryWrapper.eq("create_by", semanticWord.getUser());
        }
@@ -98,6 +100,14 @@
                    "SELECT id FROM contract WHERE customer_name = '" + customerName + "'"
            );
        }
        String isDropService = semanticWord.getIsDropService();
        if (customerName != null && !customerName.isEmpty()) {
            // 拼接关联条件:semantic_word关联contract,contract关联customer,通过客户名称过滤
            queryWrapper.inSql(
                    "contract_id",  // semantic_word表中关联contract的字段
                    "SELECT id FROM contract WHERE is_drop_service = '" + isDropService + "'"
            );
        }
        String agentName = semanticWord.getAgentName();
        if (agentName != null && !agentName.isEmpty()) {
            // 拼接关联条件:semantic_word关联contract,contract关联customer,通过客户名称过滤