| | |
|---|
| | | 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(" 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[报表成型]） |
|---|
| | |
|---|
| | | .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<>(); |
|---|
| | |
|---|
| | | } |
|---|
| | | |
|---|
| | | //计算汇总 |
|---|
| | | 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++) { |
|---|
