From af7dd07dc1521f3c0012e9e0eea836de3260f374 Mon Sep 17 00:00:00 2001
From: 陈昶聿 <chychen@nbjetron.com>
Date: 星期一, 08 六月 2026 15:37:04 +0800
Subject: [PATCH] 【丽水】随访查询页面-统计调整 * total: 患者服务总量 * wxsf: 无需随访数量 sendstate != 4 * xsf: 需随访数量 sendstate = 4 * dsf: 待随访数量 sendstate = 1L, 2L, 3L, 5L, 7L * ywc: 已完成数量 sendstate = 6L * yc: 异常数量 excep = '1' * yc: 警告数量 excep = '2'
---
ruoyi-quartz/src/main/java/com/ruoyi/quartz/util/CreateDataTable.java | 8 ++++----
1 files changed, 4 insertions(+), 4 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 d8cab10..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
@@ -220,11 +220,11 @@
// varchar / char / text 绛夊瓧绗︿覆绫诲瀷
if (dataType.contains("char") || dataType.contains("text") || dataType.contains("enum")) {
if (colName.equals("deptcode")) {
- activeParams.add(new Object[]{"p_" + colName, colName, "in", colType});
+ activeParams.add(new Object[]{"p_" + colName, colName, "in", "TEXT"});
break;
}
if (colName.equals("hospitaldistrictcode")) {
- activeParams.add(new Object[]{"p_" + colName, colName, "in", colType});
+ activeParams.add(new Object[]{"p_" + colName, colName, "in", "TEXT"});
break;
}
String kind = forceEqCols.contains(colName) ? "eq" : (eqPattern.matcher(colName).find() ? "eq" : "like");
@@ -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