| | |
|---|
| | | "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，通过客户名称过滤 |
|---|
