From c904bb22a132d75cb7f717d5a725b9624bdcf68e Mon Sep 17 00:00:00 2001
From: 许鹏程 <1821349743@qq.com>
Date: 星期二, 22 八月 2023 14:44:30 +0800
Subject: [PATCH] Merge branch 'master' of http://211.149.162.168:8090/r/product/product-server-administration/V2.0.0

---
 src/main/java/com/product/administration/service/CooperatesService.java |    8 +++-----
 1 files changed, 3 insertions(+), 5 deletions(-)

diff --git a/src/main/java/com/product/administration/service/CooperatesService.java b/src/main/java/com/product/administration/service/CooperatesService.java
index bd3c419..ea478fe 100644
--- a/src/main/java/com/product/administration/service/CooperatesService.java
+++ b/src/main/java/com/product/administration/service/CooperatesService.java
@@ -1,15 +1,12 @@
 package com.product.administration.service;
 
-import cn.hutool.core.collection.CollectionUtil;
 import com.alibaba.fastjson.JSONArray;
-import com.product.admin.service.UserService;
 import com.product.administration.config.CmnConst;
 import com.product.administration.service.ide.ICooperatesService;
 import com.product.common.lang.StringUtils;
 import com.product.core.config.CoreConst;
 import com.product.core.dao.BaseDao;
 import com.product.core.entity.DataTableEntity;
-import com.product.core.entity.FieldMetaEntity;
 import com.product.core.entity.FieldSetEntity;
 import com.product.core.exception.BaseException;
 import com.product.core.permission.PermissionService;
@@ -18,9 +15,9 @@
 import com.product.core.spring.context.SpringMVCContextHolder;
 import com.product.core.transfer.Transactional;
 import com.product.core.websocket.service.WebsocketMesssageServiceThread;
+import com.product.module.sys.service.UserService;
 import com.product.util.BaseUtil;
 import org.springframework.beans.factory.annotation.Autowired;
-import org.springframework.beans.factory.annotation.Qualifier;
 import org.springframework.stereotype.Component;
 import com.product.tool.flow.service.FlowCoordinationService;
 
@@ -49,7 +46,6 @@
 	@Autowired
 	QueryFilterService queryFilterService;
 	@Autowired
-	@Qualifier("userOperService")
 	UserService userService;
 
 	/**
@@ -315,11 +311,13 @@
 		int user_id = SpringMVCContextHolder.getCurrentUser().getUser_id();
 		String queryFilter = queryFilterService.getQueryFilter(fs);
 		StringBuffer str = new StringBuffer();
+		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(" 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