From d5ae9b5b81f0b683a8be3ad76381c41cd5caf519 Mon Sep 17 00:00:00 2001
From: 陈昶聿 <chychen@nbjetron.com>
Date: 星期四, 15 十月 2026 16:28:17 +0800
Subject: [PATCH] 【丽水】1. /smartor/serviceSubtask/getCurrentUserServiceSubtaskCount工作台里加即将超时数量字段 2. /smartor/serviceSubtask/querySubtaskList 给一个列表可以查询多少小时（可选）即将超时的随访服务，如：48小时内即将超时任务（今天15号10.40到17号10.40这段时间会到达超时时间的任务）
---
ruoyi-quartz/src/main/java/com/ruoyi/quartz/util/CreateDataTable.java | 4 ++--
1 files changed, 2 insertions(+), 2 deletions(-)
diff --git a/ruoyi-quartz/src/main/java/com/ruoyi/quartz/util/CreateDataTable.java b/ruoyi-quartz/src/main/java/com/ruoyi/quartz/util/CreateDataTable.java
index e9655c3..c711623 100644
--- a/ruoyi-quartz/src/main/java/com/ruoyi/quartz/util/CreateDataTable.java
+++ b/ruoyi-quartz/src/main/java/com/ruoyi/quartz/util/CreateDataTable.java
@@ -268,8 +268,8 @@
line = " IF " + pName + " IS NOT NULL THEN SET @cond=CONCAT(@cond,' AND " + col + "=',QUOTE(" + pName + ")); END IF;";
break;
case "like":
- // MySQL 瀛樺偍杩囩▼鍐� '' 琛ㄧず涓�涓崟寮曞彿
- line = " IF " + pName + " IS NOT NULL THEN SET @cond=CONCAT(@cond,' AND " + col + " LIKE CONCAT(''%''," + pName + ",''%'')'); END IF;";
+ // 蹇呴』鐢� QUOTE() 鎶婂�煎睍寮�鍒板瓧绗︿覆閲岋紝鍚﹀垯 PREPARE 鎵ц鏃跺弬鏁板悕琚綋鍒楀悕
+ line = " IF " + pName + " IS NOT NULL THEN SET @cond=CONCAT(@cond,' AND " + col + " LIKE CONCAT(''%'',',QUOTE(" + pName + "),',''%'')'); END IF;";
break;
case "date_ge":
line = " IF " + pName + " IS NOT NULL THEN SET @cond=CONCAT(@cond,' AND " + col + ">=',QUOTE(" + pName + ")); END IF;";
--
Gitblit v1.9.3