入库统计报表

354798ggg

2023-12-01 75339563cebc86759a1e8addab9ab5382b4fd1a1

 product-server-project-management/src/main/java/com/product/project/management/service/ProjectStatisticAnalysisService.java

@@ -39,16 +39,19 @@
        //数据库出库信息汇总
        StringBuilder outboundInfo = new StringBuilder(512);
        outboundInfo.append(" WITH outbound AS( ")
        .append(" SELECT project_uuid,itemize,material_type,material_code,SUM(outbound_weight)outbound_weight FROM ( ")
        .append(" SELECT ")
        .append(" A.project_uuid,B.material_type,B.material_code,B.outbound_weight, ")
        .append(" (SELECT itemize FROM product_project_item WHERE project_uuid = A.project_uuid AND itemize_code = substring(C.itemize_code,1,11)) itemize ")
        .append(" FROM product_project_outbound A ")
        .append(" LEFT JOIN product_project_outbound_sub B ON A.uuid=B.outbound_uuid ")
        .append(" LEFT JOIN product_project_item C ON C.uuid = A.project_itemize ")
        .append(" WHERE A.flow_flag=2 AND A.project_uuid=? ")
        .append(" )A GROUP BY project_uuid,itemize,material_type,material_code ")
        .append(" )");
        .append("  SELECT project_uuid,itemize,material_type,material_code,SUM(outbound_weight)outbound_weight FROM ( ")
        .append("    SELECT A.project_uuid,A.material_type,A.material_code,A.outbound_weight,B.itemize ")
        .append("    FROM( ")
        .append("      SELECT A.project_uuid,B.material_type,B.material_code,B.outbound_weight,substring(C.itemize_code,1,11) itemize ")
        .append("      FROM product_project_outbound A ")
        .append("      LEFT JOIN product_project_outbound_sub B ON A.uuid=B.outbound_uuid ")
        .append("      LEFT JOIN product_project_item C ON C.uuid = A.project_itemize ")
        .append("      WHERE A.flow_flag=2 AND A.project_uuid=? ")
        .append("    )A ")
        .append("    LEFT JOIN product_project_item B ON A.itemize = B.itemize_code ")
        .append("    WHERE B.project_uuid = ? ")
        .append("  )A GROUP BY project_uuid,itemize,material_type,material_code ")
        .append(")");
        //出库信息操作（getItemizeSum[钢筋和架立筋左侧汇总]；allitemize[所有三级分项]；intermediateData1[钢筋架立筋按分项汇总]；intermediateData2[钢筋网片按分项和材料汇总]；intermediateData3[报表成型]）
        StringBuilder operateInfo = new StringBuilder(1024);
        operateInfo.append(" ,getItemizeSum AS( ")
@@ -131,7 +134,7 @@
        .append(" SELECT '合计',ROUND(SUM(outbound_weight)/1000,1) FROM outbound WHERE material_type IN (0,1,3) GROUP BY project_uuid ");
        
        //获取SQL解析的基本数据，利用JAVA将项目分项对应的不同材料行转列
        DataTableEntity dtItemizeInfo = baseDao.listTable(outboundInfo.toString() + operateInfo.toString(), new Object[]{project_uuid});
        DataTableEntity dtItemizeInfo = baseDao.listTable(outboundInfo.toString() + operateInfo.toString(), new Object[]{project_uuid, project_uuid});
        if (!BaseUtil.dataTableIsEmpty(dtItemizeInfo)) {

            Map<String, FieldSetEntity> convertData = new HashMap<>();
@@ -176,7 +179,7 @@
            }
            
            //计算汇总
            DataTableEntity dtTotalInfo = baseDao.listTable(outboundInfo.toString() + totalSum.toString(), new Object[]{project_uuid});
            DataTableEntity dtTotalInfo = baseDao.listTable(outboundInfo.toString() + totalSum.toString(), new Object[]{project_uuid, project_uuid});
            FieldSetEntity fseConvertData = new FieldSetEntity(Cmnconst.PRODUCT_PROJECT_QXLW);
            if (!BaseUtil.dataTableIsEmpty(dtTotalInfo)) {
            for (int i = 0; i < dtTotalInfo.getRows(); i++) {
@@ -223,8 +226,7 @@
     * @return
     */
    public List<List<String>> getReportMaterialType() {
    	
       DataTableEntity dtMaterialType = baseDao.listTable("product_sys_dict", "dict_name = ?", new Object[] {Cmnconst.MATERIAL_TYPE}, new Object[] {"dict_value","dict_label"});
       DataTableEntity dtMaterialType = baseDao.listTable(Cmnconst.PRODUCT_PROJECT_BASE_MATERIAL_TYPE, null, new Object[] {}, new Object[] {"material_type_name","material_type_value"});
       if (!BaseUtil.dataTableIsEmpty(dtMaterialType)) {
          
          List<List<String>> returnList = new ArrayList<>();
@@ -234,8 +236,8 @@
           List<String> listNotShowMaterialCodeName = new ArrayList<>();
          
         for (int i = 0; i < dtMaterialType.getRows(); i++) {
            String dictValue = dtMaterialType.getFieldSetEntity(i).getString("dict_value");
            String dictLabel = dtMaterialType.getFieldSetEntity(i).getString("dict_label");
            String dictValue = dtMaterialType.getFieldSetEntity(i).getString("material_type_value");
            String dictLabel = dtMaterialType.getFieldSetEntity(i).getString("material_type_name");
            if ("0".equals(dictValue)) {
               listSummary.add(dictValue);
               listShowMaterialCode.add(dictValue);