优化采购提示消息不准确问题

wuxw

2024-08-21 0a090d236f0bd70d1cff62370942196c9ac1c941

 springboot/src/main/java/com/java110/boot/smo/assetExport/impl/ExportReportFeeSMOImpl.java

@@ -80,7 +80,7 @@
    public static final String RESOURCE_STAFF_FEE_MANAGE = "staffFeeManage";
    public static final String REPORT_PAY_FEE_DEPOSIT = "reportPayFeeDeposit";
    public static final String INSPECTION_TASK_DETAILS = "inspectionTaskDetails";
    public static final String APPLY_PAY_FEE = "applyPayFee";
    public static final String EXPORT_EXCEL = "exportExcel";
    @Autowired
    private RestTemplate restTemplate;

@@ -189,9 +189,6 @@
                break;
            case INSPECTION_TASK_DETAILS:
                inspectionTaskDetails(pd, result, workbook);
                break;
            case APPLY_PAY_FEE:
                applyPayFees(pd, result, workbook);

        }
        ByteArrayOutputStream os = new ByteArrayOutputStream();
@@ -559,7 +556,7 @@
        for (int roomIndex = 0; roomIndex < deadlineFees.size(); roomIndex++) {
            row = sheet.createRow(roomIndex + 1);
            dataObj = deadlineFees.getJSONObject(roomIndex);
            row.createCell(0).setCellValue(dataObj.getString("objNameNum"));
            row.createCell(0).setCellValue(dataObj.getString("objName"));
            row.createCell(1).setCellValue(dataObj.getString("feeName"));
            row.createCell(2).setCellValue(dataObj.getString("deadlineTime"));
            row.createCell(3).setCellValue(dataObj.getString("oweDay"));
@@ -981,29 +978,6 @@
        }
    }


    private void applyPayFees(IPageData pd, ComponentValidateResult result, SXSSFWorkbook workbook) {

        JSONObject paramIn = JSONObject.parseObject(pd.getReqData());

        Sheet sheet = workbook.createSheet(paramIn.getString("sheetName"));
        Row row = sheet.createRow(0);
        row.createCell(0).setCellValue(paramIn.getString("title"));


        JSONArray datas = paramIn.getJSONArray("datas");

        JSONObject dataObj = null;
        String[] keyColumns = null;
        for (int roomIndex = 0; roomIndex < datas.size(); roomIndex++) {
            row = sheet.createRow(roomIndex + 1);
            dataObj = datas.getJSONObject(roomIndex);
            keyColumns = dataObj.keySet().toArray(new String[dataObj.keySet().size()]);
            for (int keySetIndex = 0; keySetIndex < keyColumns.length; keySetIndex ++) {
                row.createCell(keySetIndex).setCellValue(dataObj.getString(keyColumns[keySetIndex]));
            }
        }
    }

    private void resourceStoreUseRecordManage(IPageData pd, ComponentValidateResult result, Workbook workbook) {
        Sheet sheet = workbook.createSheet("物品使用记录");
@@ -1641,30 +1615,38 @@
        row.createCell(0).setCellValue("费用编号");
        row.createCell(1).setCellValue("房号");
        row.createCell(2).setCellValue("业主");
        row.createCell(3).setCellValue("面积");
        row.createCell(4).setCellValue("费用项");
        row.createCell(5).setCellValue("费用开始时间");
        row.createCell(6).setCellValue("更新时间");
        row.createCell(7).setCellValue("欠费时长（天）");
        row.createCell(8).setCellValue("欠费金额");
        row.createCell(3).setCellValue("业主电话");
        row.createCell(4).setCellValue("面积");
        row.createCell(5).setCellValue("费用项");
        row.createCell(6).setCellValue("费用开始时间");
        row.createCell(7).setCellValue("更新时间");
        row.createCell(8).setCellValue("欠费时长（天）");
        row.createCell(9).setCellValue("欠费时长（月）");
        row.createCell(10).setCellValue("欠费金额");

        //查询楼栋信息
        JSONArray rooms = this.getReportOweFeeDetail(pd, result);
        if (rooms == null || rooms.size() == 0) {
            return;
        }
        JSONObject dataObj = null;
        BigDecimal monthDec = null;
        for (int roomIndex = 0; roomIndex < rooms.size(); roomIndex++) {
            row = sheet.createRow(roomIndex + 1);
            dataObj = rooms.getJSONObject(roomIndex);
            row.createCell(0).setCellValue(roomIndex + 1);
            row.createCell(1).setCellValue(dataObj.getString("objName"));
            row.createCell(2).setCellValue(dataObj.getString("ownerName"));
            row.createCell(3).setCellValue(dataObj.getString("builtUpArea"));
            row.createCell(4).setCellValue(dataObj.getString("feeName"));
            row.createCell(5).setCellValue(dataObj.getString("feeCreateTime"));
            row.createCell(6).setCellValue(dataObj.getString("updateTime"));
            row.createCell(7).setCellValue(dataObj.getString("oweDay"));
            row.createCell(8).setCellValue(dataObj.getString("oweAmount"));
            row.createCell(3).setCellValue(dataObj.getString("ownerTel"));
            row.createCell(4).setCellValue(dataObj.getString("builtUpArea"));
            row.createCell(5).setCellValue(dataObj.getString("feeName"));
            row.createCell(6).setCellValue(dataObj.getString("feeCreateTime"));
            row.createCell(7).setCellValue(dataObj.getString("updateTime"));
            row.createCell(8).setCellValue(dataObj.getString("oweDay"));
            monthDec = new BigDecimal(dataObj.getString("oweDay"));
            monthDec = monthDec.divide(new BigDecimal("30"), 2, BigDecimal.ROUND_HALF_UP);
            row.createCell(9).setCellValue(monthDec.doubleValue());
            row.createCell(10).setCellValue(dataObj.getString("oweAmount"));
        }
    }