项目立项计算整体项目进度

zm

2024-10-09 f23de33f7fadd304d9f6d74d9e2f44f559f537d9

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

@@ -23,8 +23,13 @@
   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"));
      String sql ="SELECT CONCAT(sum(REPLACE(a.task_rate, '%', ''))/COUNT(*),'%') task_rate FROM `product_project_schedule_weekly_sub` a\n" +
            "LEFT JOIN  product_project_schedule_weekly b on a.main_uuid=b.uuid\n" +
            "where a.project_uuid=? and b.flow_flag =2 GROUP BY project_uuid";
      FieldSetEntity task_rate_fs = baseDao.getFieldSetEntityBySQL(sql, new String[]{fse.getUUID()}, false);
      if (!FieldSetEntity.isEmpty(task_rate_fs)){
         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()});