From 22d8b68b19e35bdd2086fd047296abe440639f32 Mon Sep 17 00:00:00 2001
From: 杜洪波 <1074825718@qq.com>
Date: 星期四, 18 九月 2025 15:52:27 +0800
Subject: [PATCH] 代码提交
---
src/main/java/com/product/administration/service/IndicatorsEarlyWarningService.java | 11 ++++++++---
1 files changed, 8 insertions(+), 3 deletions(-)
diff --git a/src/main/java/com/product/administration/service/IndicatorsEarlyWarningService.java b/src/main/java/com/product/administration/service/IndicatorsEarlyWarningService.java
index 3e51286..4f51065 100644
--- a/src/main/java/com/product/administration/service/IndicatorsEarlyWarningService.java
+++ b/src/main/java/com/product/administration/service/IndicatorsEarlyWarningService.java
@@ -19,6 +19,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.quartz.SchedulerException;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
@@ -589,9 +591,12 @@
//鍏徃鎴栭儴闂╱uid
} else {
StringBuffer sql = new StringBuffer();
- sql.append(" SELECT * FROM product_sys_staffs WHERE org_level_uuid = ( ")
- .append(" SELECT IFNULL(org_level_uuid,uuid) org_level_uuid FROM product_sys_org_levels WHERE uuid = ? ) ")
- .append(" and is_org_manager = 1 ");
+ sql.append("\nSELECT * FROM product_sys_staffs ")
+ .append("\nWHERE org_level_uuid = ( ")
+ .append("\n SELECT ").append(UnifySQLFunction.ifnull("org_level_uuid", "uuid")).append(" AS org_level_uuid ")
+ .append("\n FROM product_sys_org_levels WHERE uuid = ? ")
+ .append("\n) ")
+ .append("\nAND is_org_manager = 1 ");
dataTableEntity = baseDao.listTable(sql.toString(), new String[]{responsible});
}
if (!BaseUtil.dataTableIsEmpty(dataTableEntity)) {
--
Gitblit v1.9.2