From 2b8e522ec7c38570463a08e04bc1cc264a038e5b Mon Sep 17 00:00:00 2001
From: zm <2369059705qq.com>
Date: 星期一, 17 三月 2025 11:26:39 +0800
Subject: [PATCH] 整体BUG修改

---
 src/main/java/com/product/contract/service/ProjectScheduleService.java |   31 ++++++++++++++++++-------------
 src/main/java/com/product/contract/service/ProjectBusinessService.java |    2 +-
 2 files changed, 19 insertions(+), 14 deletions(-)

diff --git a/src/main/java/com/product/contract/service/ProjectBusinessService.java b/src/main/java/com/product/contract/service/ProjectBusinessService.java
index 8c5efcc..4c4754e 100644
--- a/src/main/java/com/product/contract/service/ProjectBusinessService.java
+++ b/src/main/java/com/product/contract/service/ProjectBusinessService.java
@@ -63,7 +63,7 @@
 	public JSONObject findTranslate(FieldSetEntity fse) {
 		FieldSetEntity fsData = baseDao.getFieldSetBySQL("SELECT project_type,date FROM product_project_business_translate where project_type=?", new String[]{fse.getString("project_type")}, false);
 		JSONObject rejson=BaseUtil.fieldSetEntityToJson(fsData);
-		DataTableEntity projectType = baseDao.listTable(CmnConst.PRODUCT_PROJECT_BUSINESS_TRANSLATE, "project_type=? ORDER BY project_task", new String[]{fse.getString("project_type")});
+		DataTableEntity projectType = baseDao.listTable(CmnConst.PRODUCT_PROJECT_BUSINESS_TRANSLATE, "project_type=? ORDER BY project_task,id", new String[]{fse.getString("project_type")});
 		JSONObject json = new JSONObject();
 		for (int i = 0; i < projectType.getRows(); i++) {
 			FieldSetEntity fs = projectType.getFieldSetEntity(i);
diff --git a/src/main/java/com/product/contract/service/ProjectScheduleService.java b/src/main/java/com/product/contract/service/ProjectScheduleService.java
index 9a0f662..0767da0 100644
--- a/src/main/java/com/product/contract/service/ProjectScheduleService.java
+++ b/src/main/java/com/product/contract/service/ProjectScheduleService.java
@@ -37,7 +37,7 @@
 		sql.append("LEFT JOIN product_project_schedule c on b.uuid=c.business_sub_uuid\n");
 		sql.append("WHERE  a.project_name is not null \n");
 		sql.append("AND (CONCAT(',',a.team_members,',') LIKE ? OR a.group_leader = ?) \n");
-		sql.append("ORDER BY a.project_name,b.start_date");
+		sql.append("ORDER BY a.project_name,b.start_date,c.reporting_time");
 		DataTableEntity dt = baseDao.listTable(sql.toString(), new String[]{"%," + curUserId + ",%", curUserId});
 		baseDao.loadPromptData(dt);
 		JSONObject projectJsob = new JSONObject(new LinkedHashMap<>());
@@ -93,20 +93,25 @@
 					json.put("reporting_time", timeString);
 					json.put("number1", 1);
 
-
 				}else {
-					jsonArray.getJSONObject(0).put("number1",jsonArray.size()+1);
-					num=num+jsonArray.size()+1;
+					String progressRate = jsonArray.getJSONObject(jsonArray.size() - 1).getString("progress_rate");
+					if (!progressRate.equals("100%")){
+						jsonArray.getJSONObject(0).put("number1",jsonArray.size()+1);
+						num=num+jsonArray.size()+1;
 
-					//鏂板棰楀~鍐欐暟鎹�
-					JSONObject j = new JSONObject();
-					j.put("business_uuid",jsonArray.getJSONObject(0).getString("business_uuid"));
-					j.put("business_sub_uuid",jsonArray.getJSONObject(0).getString("business_sub_uuid"));
-					j.put("project_name",jsonArray.getJSONObject(0).getString("project_name"));
-					j.put("project_task_sub",jsonArray.getJSONObject(0).getString("project_task_sub"));
-					j.put("reporter", SpringMVCContextHolder.getCurrentUser().getUser_name());
-					j.put("reporting_time", timeString);
-					jsonArray.add(j);
+						//鏂板棰楀~鍐欐暟鎹�
+						JSONObject j = new JSONObject();
+						j.put("business_uuid",jsonArray.getJSONObject(0).getString("business_uuid"));
+						j.put("business_sub_uuid",jsonArray.getJSONObject(0).getString("business_sub_uuid"));
+						j.put("project_name",jsonArray.getJSONObject(0).getString("project_name"));
+						j.put("project_task_sub",jsonArray.getJSONObject(0).getString("project_task_sub"));
+						j.put("reporter", SpringMVCContextHolder.getCurrentUser().getUser_name());
+						j.put("reporting_time", timeString);
+						jsonArray.add(j);
+					}else {
+						jsonArray.getJSONObject(0).put("number1",jsonArray.size());
+						num=num+jsonArray.size();
+					}
 				}
 				for (int i = 0; i <jsonArray.size() ; i++) {
 					JSONObject a = jsonArray.getJSONObject(i);

--
Gitblit v1.9.2