From a49a8d87f994ceb57291ac2d656c828456ec5ec1 Mon Sep 17 00:00:00 2001
From: shicf <shi_chongfu@163.com>
Date: 星期四, 17 十月 2024 16:30:16 +0800
Subject: [PATCH] 预警消息推送，通用方法
---
src/main/java/com/product/administration/service/CooperateModelService.java | 8 ++++----
1 files changed, 4 insertions(+), 4 deletions(-)
diff --git a/src/main/java/com/product/administration/service/CooperateModelService.java b/src/main/java/com/product/administration/service/CooperateModelService.java
index fd17ae5..4f6f0ef 100644
--- a/src/main/java/com/product/administration/service/CooperateModelService.java
+++ b/src/main/java/com/product/administration/service/CooperateModelService.java
@@ -43,12 +43,12 @@
public DataTableEntity listModel(FieldSetEntity fse) {
String curUserID = SpringMVCContextHolder.getCurrentUserId();
StringBuilder sql = new StringBuilder(256);
- sql.append("\nselect uuid,name,date_format(created_utc_datetime,'%Y-%m-%d %H:%i:%s') created_utc_datetime,type from (");
- sql.append("\n select uuid,name,created_utc_datetime,0 type from product_oa_cooperates_template where created_by=? and created_by<>1");
+ sql.append("\nselect uuid,name,date_format(created_utc_datetime,'%Y-%m-%d %H:%i:%s') created_utc_datetime,created_by,type from (");
+ sql.append("\n select uuid,name,created_utc_datetime,created_by,0 type from product_oa_cooperates_template where created_by=? and created_by<>1");
sql.append("\n union all");
- sql.append("\n select uuid,name,created_utc_datetime,1 type from product_oa_cooperates_template where find_in_set(?,share_user)>0 and created_by<>1 and created_by<>?");
+ sql.append("\n select uuid,name,created_utc_datetime,created_by,1 type from product_oa_cooperates_template where find_in_set(?,share_user)>0 and created_by<>1 and created_by<>?");
sql.append("\n union all");
- sql.append("\n select uuid,name,created_utc_datetime,2 type from product_oa_cooperates_template where created_by=1");
+ sql.append("\n select uuid,name,created_utc_datetime,created_by,2 type from product_oa_cooperates_template where created_by=1");
sql.append("\n) t");
sql.append("\norder by created_utc_datetime desc");
return baseDao.listTable(sql.toString(), new Object[]{curUserID, curUserID, curUserID});
--
Gitblit v1.9.2