| | |
| | | @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()}); |