From eb2a6d19fd28fa4edcc58b471149604ad718e868 Mon Sep 17 00:00:00 2001
From: 杜洪波 <1074825718@qq.com>
Date: 星期三, 17 九月 2025 09:28:03 +0800
Subject: [PATCH] 代码提交
---
src/main/java/com/product/administration/service/EarlyWarningManagerService.java | 4 +++-
1 files changed, 3 insertions(+), 1 deletions(-)
diff --git a/src/main/java/com/product/administration/service/EarlyWarningManagerService.java b/src/main/java/com/product/administration/service/EarlyWarningManagerService.java
index 971f0c0..39646af 100644
--- a/src/main/java/com/product/administration/service/EarlyWarningManagerService.java
+++ b/src/main/java/com/product/administration/service/EarlyWarningManagerService.java
@@ -28,6 +28,8 @@
import com.product.quartz.service.impl.SysJobService;
import com.product.util.BaseUtil;
import com.product.util.SystemParamReplace;
+import com.product.util.UnifySQLFunction;
+
import org.apache.commons.codec.binary.Base64;
import org.quartz.SchedulerException;
import org.springframework.beans.factory.annotation.Autowired;
@@ -483,7 +485,7 @@
sql.append("\n select org_level_code from product_sys_staffs sc inner join product_sys_org_levels d on sc.dept_uuid=d.uuid and sc.is_dept_manage=1 and user_id=?");
sql.append("\n ) o on s.tricode like concat(o.org_level_code,'%')");
sql.append("\n union all");
- sql.append("\n select ? from dual");
+ sql.append("\n ").append(UnifySQLFunction.dualFunction("?"));
sql.append("\n) u on concat(',',i.receiver,',') like concat('%,',u.user_id,',%')");
sql.append("\nwhere early_warning_uuid is not null");
--
Gitblit v1.9.2