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/CooperateModelService.java | 12 ++++++------ 1 files changed, 6 insertions(+), 6 deletions(-) diff --git a/src/main/java/com/product/administration/service/CooperateModelService.java b/src/main/java/com/product/administration/service/CooperateModelService.java index 0888120..1c3bd9c 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,created_by,type from ("); - sql.append("\n select uuid,name,created_utc_datetime,created_by,0 as 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,created_by,1 as 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,created_by,2 as type from product_oa_cooperates_template where created_by=1"); + sql.append("\nselect uuid,name,created_utc_datetime,created_by,type from ("); + sql.append("\n select uuid,name,created_utc_datetime,created_by,0 as 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,created_by,1 as 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,created_by,2 as 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