From c2768e5568aa911988a3df92b0431eeeb9627c3d Mon Sep 17 00:00:00 2001
From: zm <2369059705qq.com>
Date: 星期四, 01 八月 2024 14:12:40 +0800
Subject: [PATCH] 整体优化

---
 src/main/java/com/product/contract/service/ProjectCommissionService.java |    4 ++--
 1 files changed, 2 insertions(+), 2 deletions(-)

diff --git a/src/main/java/com/product/contract/service/ProjectCommissionService.java b/src/main/java/com/product/contract/service/ProjectCommissionService.java
index baaf43f..2269545 100644
--- a/src/main/java/com/product/contract/service/ProjectCommissionService.java
+++ b/src/main/java/com/product/contract/service/ProjectCommissionService.java
@@ -84,13 +84,13 @@
 	 */
 	private DataTableEntity getUnCommissionProjectSub(String projectUUID) {
 		StringBuilder sb = new StringBuilder();
-		sb.append(" SELECT '椤圭洰缁勯暱' project_role_name,'1' AS project_role, A.group_leader AS project_user,'0.01' bonus_ratio,b.workload actual_human_days,b.workload/C.work_days human_days_ratio ");
+		sb.append(" SELECT '椤圭洰缁勯暱' project_role_name,'1' AS project_role, A.group_leader AS project_user,'0.01' bonus_ratio,b.workload actual_human_days,ROUND(b.workload/C.work_days, 2)  human_days_ratio ");
 		sb.append(" FROM product_project_business A ");
 		sb.append(" LEFT JOIN (SELECT  project_uuid,sum(workload)workload FROM product_project_schedule_weekly_sub GROUP BY project_uuid) B on A.uuid=b.project_uuid ");
 		sb.append(" LEFT JOIN (SELECT  project_uuid,sum(work_days)work_days FROM product_project_business_plan GROUP BY project_uuid) C on A.uuid=C.project_uuid ");
 		sb.append(" WHERE A.uuid = ? ");
 		sb.append(" UNION ALL ");
-		sb.append(" SELECT '椤圭洰鎴愬憳' project_role_name,'2' AS project_role, A.team_members AS project_user,'0.05' bonus_ratio,B.workload,B.workload/C.work_days human_days_ratio ");
+		sb.append(" SELECT '椤圭洰鎴愬憳' project_role_name,'2' AS project_role, A.team_members AS project_user,'0.05' bonus_ratio,B.workload,ROUND(b.workload/C.work_days, 2) human_days_ratio ");
 		sb.append(" FROM product_project_business A LEFT JOIN");
 		sb.append(" (SELECT a.apply_user,b.project_uuid,sum(workload) workload FROM  product_project_schedule_weekly a LEFT JOIN product_project_schedule_weekly_sub b on b.main_uuid = a.uuid GROUP BY a.apply_user,b.project_uuid) B");
 		sb.append(" on A.team_members=b.apply_user and A.uuid =B.project_uuid LEFT JOIN");

--
Gitblit v1.9.2