整体优化

zm

2024-08-01 cad03a7d84cf89646473588628cb3128c05de0cf

 src/main/java/com/product/contract/service/ProjectCommissionService.java

@@ -84,7 +84,7 @@
    */
   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 ");