From 80a520d0a62dacf8237a5ab01b5346a002b14e8e Mon Sep 17 00:00:00 2001
From: zm <2369059705qq.com>
Date: 星期三, 09 十月 2024 11:38:42 +0800
Subject: [PATCH] 项目立项计算整体项目进度
---
src/main/java/com/product/contract/service/ProjectBusinessService.java | 12 +++++-------
1 files changed, 5 insertions(+), 7 deletions(-)
diff --git a/src/main/java/com/product/contract/service/ProjectBusinessService.java b/src/main/java/com/product/contract/service/ProjectBusinessService.java
index d18dd2e..ec2b31b 100644
--- a/src/main/java/com/product/contract/service/ProjectBusinessService.java
+++ b/src/main/java/com/product/contract/service/ProjectBusinessService.java
@@ -22,6 +22,9 @@
@Override
public JSONObject findProject(FieldSetEntity fse) {
FieldSetEntity fsData = baseDao.getFieldSet(CmnConst.PRODUCT_PROJECT_BUSINESS, fse.getUUID(), false);
+ //璁＄畻鏁翠綋椤圭洰杩涘害
+ FieldSetEntity task_rate_fs = baseDao.getFieldSetEntityBySQL("SELECT CONCAT(sum(REPLACE(task_rate, '%', ''))/COUNT(*),'%') task_rate FROM `product_project_schedule_weekly_sub` where project_uuid=? GROUP BY project_uuid", new String[]{fse.getUUID()}, false);
+ fsData.setValue("schedule",task_rate_fs.getString("task_rate"));
//灏佽椤圭洰璁″垝鏁版嵁鎺ュ彛
JSONObject json = new JSONObject();
DataTableEntity planData=baseDao.listTable(CmnConst.PRODUCT_PROJECT_BUSINESS_PLAN,"project_uuid=?",new String[]{fse.getUUID()});
@@ -43,7 +46,7 @@
DataTableEntity scheduleDt =baseDao.listTable("select project_task_sub,a.* from product_project_schedule a\n" +
"LEFT JOIN product_project_business_plan b on a.business_sub_uuid =b.uuid\n" +
"where b.project_uuid=? order by a.business_sub_uuid,a.reporting_time",new String[]{fse.getUUID()});
-
+ baseDao.loadPromptData(scheduleDt);
rejson.put(CmnConst.PRODUCT_PROJECT_SCHEDULE,BaseUtil.dataTableEntityToJson(scheduleDt));
//灏佽璧勬枡鏁版嵁缁撴瀯
DataTableEntity dataList = baseDao.listTable(CmnConst.PRODUCT_PROJECT_MANAGER_DATA_LIST, "project_type=?", new String[]{fsData.getString("project_type")});
@@ -55,11 +58,6 @@
@Transactional
@Override
public boolean saveProject(FieldSetEntity fse) {
- boolean b = baseDao.saveFieldSetEntity(fse);
-// if (b){
-// DataTableEntity dt = fse.getSubDataTable(CmnConst.PRODUCT_PROJECT_MANAGER_DATA_LIST);
-// return baseDao.update(dt);
-// }
- return b;
+ return baseDao.saveFieldSetEntity(BaseUtil.createCreatorAndCreationTime(fse));
}
}
--
Gitblit v1.9.2