From 84169fc928d887d606e12380cfa3c1409d04db2a Mon Sep 17 00:00:00 2001
From: 许鹏程 <1821349743@qq.com>
Date: 星期二, 22 八月 2023 14:44:01 +0800
Subject: [PATCH] 协同办公列表排序
---
src/main/java/com/product/administration/service/CooperatesService.java | 24 ++++++++++++++++--------
1 files changed, 16 insertions(+), 8 deletions(-)
diff --git a/src/main/java/com/product/administration/service/CooperatesService.java b/src/main/java/com/product/administration/service/CooperatesService.java
index ea7f0ed..b1d3f2b 100644
--- a/src/main/java/com/product/administration/service/CooperatesService.java
+++ b/src/main/java/com/product/administration/service/CooperatesService.java
@@ -86,7 +86,7 @@
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.append(" select ifnull(concat(tricode,'-',receiver) ,receiver) code,uuid,title,cooperate_uuid,grade,receiver as id,receiver,sender, ");
stringBuilder.append(" receiver_name,(select user_name FROM product_sys_users where user_id=receiver) label,sender_name,status, ");
- stringBuilder.append(" tricode,opinion,handle_time,type,attachments from product_oa_cooperate_flow_node where cooperate_uuid=? ORDER BY tricode ");
+ stringBuilder.append(" tricode,opinion,handle_time,type,attachments,is_hide_commentss from product_oa_cooperate_flow_node where cooperate_uuid=? ORDER BY tricode ");
DataTableEntity dt = baseDao.listTable(stringBuilder.toString(), new Object[]{fs.getString("uuid")});
JSONArray json = null;
if (dt != null && dt.getRows() > 0) {
@@ -117,9 +117,9 @@
fse.addSubDataTable(dd);
json = BaseUtil.dataTableToTreeData(dt, "code", "tricode", null, false);
}
- String sql = " select count(*) sum from product_oa_cooperate_flow_node where cooperate_uuid =? and status =? ";
- String sql1 = " select count(*) sum from product_oa_cooperate_flow_node where cooperate_uuid =? ";
- String sql0 = " select count(*) sum from product_oa_cooperate_flow_node where cooperate_uuid =? and (status =? or status is null) ";
+ String sql = " select count(*) sum from product_oa_cooperate_flow_node where cooperate_uuid =? and status =? and tricode is not null";
+ String sql1 = " select count(*) sum from product_oa_cooperate_flow_node where cooperate_uuid =? and tricode is not null";
+ String sql0 = " select count(*) sum from product_oa_cooperate_flow_node where cooperate_uuid =? and (status =? or status is null) and tricode is not null";
FieldSetEntity fss = baseDao.getFieldSetEntityBySQL(sql1, new Object[]{fs.getString(CmnConst.UUID)}, true);
FieldSetEntity fs0 = baseDao.getFieldSetEntityBySQL(sql0, new Object[]{fs.getString(CmnConst.UUID), 0}, true);
FieldSetEntity fs1 = baseDao.getFieldSetEntityBySQL(sql, new Object[]{fs.getString(CmnConst.UUID), 1}, true);
@@ -127,7 +127,7 @@
if (fss.getInteger("sum") == null) {
fse.setValue("totals", 0);//娴佺▼鍏辨湁浜烘暟
} else {
- fse.setValue("totals", fss.getInteger("sum") - 1);
+ fse.setValue("totals", fss.getInteger("sum"));
}
if (fs0.getInteger("sum") == null) {
fse.setValue("uncollectd", 0);//鏈敹鏈姙浜烘暟
@@ -142,7 +142,7 @@
if (fs2.getInteger("sum") == null) {
fse.setValue("done", 0);//宸叉敹宸插姙浜烘暟
} else {
- fse.setValue("done", fs2.getInteger("sum") - 1);
+ fse.setValue("done", fs2.getInteger("sum"));
}
int a = fse.getInteger("totals") - fse.getInteger("uncollectd") - fse.getInteger("received") - fse.getInteger("done");
fse.setValue("not_yet", a);//鏈埌鐜妭浜烘暟
@@ -250,6 +250,7 @@
*/
public void saveTodo(FieldSetEntity fs) throws BaseException {
fs.setValue("status", 1);
+ fs.setValue("handle_time", new Date());
baseDao.update(fs);
}
@@ -264,6 +265,11 @@
fs.setValue("created_by", SpringMVCContextHolder.getCurrentUser().getUser_id());
fs.setValue("created_utc_datetime", new Date());
return baseDao.add(fs);
+ }
+
+ @Override
+ public boolean delSupplyText(FieldSetEntity fs) {
+ return baseDao.delete(fs.getTableName(),new String[]{fs.getUUID()});
}
/**
@@ -307,11 +313,13 @@
int user_id = SpringMVCContextHolder.getCurrentUser().getUser_id();
String queryFilter = queryFilterService.getQueryFilter(fs);
StringBuffer str = new StringBuffer();
- str.append(" select lc.*,lcn.uuid flow_node_uuid from product_oa_cooperate_flow_node lcn LEFT JOIN product_oa_cooperates lc ");
+ str.append("SELECT * FROM ( ");
+ str.append(" select lc.*,lcn.uuid flow_node_uuid from product_oa_cooperate_flow_node as lcn LEFT JOIN product_oa_cooperates as lc ");
str.append(" on lc.uuid=lcn.cooperate_uuid where lcn.receiver=? and lcn.status=? and sender_name is not null ");
if (!StringUtils.isEmpty(queryFilter)) {
- str.append(" and ").append(queryFilter);
+ str.append(" and ").append(queryFilter);
}
+ str.append(" order by start_time desc) a");
DataTableEntity dt = baseDao.listTable(str.toString(), new Object[]{user_id, 2}, fs.getInteger(CmnConst.PAGESIZE), fs.getInteger(CmnConst.CPAGE));
dt.getMeta().addAliasTable("product_oa_cooperates", "lc");
dt.getMeta().addAliasTable("product_oa_cooperate_flow_node", "lcn");
--
Gitblit v1.9.2