| | |
| | | }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()); |
| | | } |
| | |
| | | "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,通过客户名称过滤 |