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 | 3 +++ 1 files changed, 3 insertions(+), 0 deletions(-) diff --git a/src/main/java/com/product/contract/service/ProjectBusinessService.java b/src/main/java/com/product/contract/service/ProjectBusinessService.java index f18574b..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()}); -- Gitblit v1.9.2