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 | 7 +++++-- 1 files changed, 5 insertions(+), 2 deletions(-) diff --git a/src/main/java/com/product/administration/service/EarlyWarningManagerService.java b/src/main/java/com/product/administration/service/EarlyWarningManagerService.java index b14455f..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; @@ -338,6 +340,8 @@ StaffManagerService staffManagerService; public void sendWarnFeedBackMessage(FieldSetEntity fse) throws BaseException { + String userId = String.valueOf(SpringMVCContextHolder.getCurrentUser().getUser_id()); + fse.setValue( CmnConst.USER_ID,userId);//褰撳墠浜轰綔涓烘秷鎭彂閫佷汉锛屽叾瀹冮璀︽帴鏀朵汉浣滀负鏀舵秷鎭汉 String parent_uuid = fse.getString("puuid"); Set<String> receiverSet = this.getReceiver(fse.getString("parent_uuid")); if (StringUtils.isEmpty(parent_uuid)) { @@ -346,7 +350,6 @@ if (!StringUtils.isEmpty(leaderUserId)) { receiverSet.add(leaderUserId); } - String userId = String.valueOf(SpringMVCContextHolder.getCurrentUser().getUser_id()); receiverSet.remove(userId); if(receiverSet.isEmpty()){ logger.error("鍙戦�佹秷鎭�,澶辫触"); @@ -482,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