| | |
| | | |
| | | //查询楼栋信息 |
| | | JSONArray rooms = this.getReportPayFeeDetail(pd, result); |
| | | |
| | | if (rooms == null) { |
| | | return; |
| | | } |
| | | JSONObject dataObj = null; |
| | | for (int roomIndex = 0; roomIndex < rooms.size(); roomIndex++) { |
| | | row = sheet.createRow(roomIndex + 1); |
| | |
| | | row.createCell(1).setCellValue(dataObj.getString("objName")); |
| | | row.createCell(2).setCellValue(dataObj.getString("feeName")); |
| | | row.createCell(3).setCellValue(dataObj.getString("feeCreateTime")); |
| | | row.createCell(4).setCellValue("-"); |
| | | row.createCell(4).setCellValue(dataObj.getString("deadlineTime")); |
| | | row.createCell(5).setCellValue(dataObj.getString("receivableAmount")); |
| | | row.createCell(6).setCellValue(dataObj.getString("receivedAmount")); |
| | | |
| | |
| | | dataObj = rooms.getJSONObject(roomIndex); |
| | | |
| | | row.createCell(0).setCellValue(roomIndex + 1); |
| | | row.createCell(2).setCellValue(dataObj.getString("feeName")); |
| | | row.createCell(3).setCellValue(dataObj.getString("feeCreateTime")); |
| | | row.createCell(1).setCellValue(dataObj.getString("receivableAmount")); |
| | | row.createCell(1).setCellValue(dataObj.getString("feeName")); |
| | | row.createCell(2).setCellValue(dataObj.getString("feeCreateTime")); |
| | | row.createCell(3).setCellValue(dataObj.getString("receivableAmount")); |
| | | row.createCell(4).setCellValue(dataObj.getString("receivedAmount")); |
| | | row.createCell(5).setCellValue(dataObj.getString("oweAmount")); |
| | | |
| | |
| | | for (int roomIndex = 0; roomIndex < rooms.size(); roomIndex++) { |
| | | row = sheet.createRow(roomIndex + 1); |
| | | dataObj = rooms.getJSONObject(roomIndex); |
| | | |
| | | row.createCell(0).setCellValue(dataObj.getString("feeYear") + "年" + dataObj.getString("feeMonth") + "月"); |
| | | row.createCell(1).setCellValue(dataObj.getString("receivableAmount")); |
| | | row.createCell(2).setCellValue(dataObj.getString("floorNum") + "号楼"); |
| | | row.createCell(3).setCellValue(dataObj.getString("unitNum") + "单元"); |
| | | row.createCell(1).setCellValue(dataObj.getString("floorNum") + "号楼"); |
| | | row.createCell(2).setCellValue(dataObj.getString("unitNum") + "单元"); |
| | | row.createCell(3).setCellValue(dataObj.getString("receivableAmount")); |
| | | row.createCell(4).setCellValue(dataObj.getString("receivedAmount")); |
| | | row.createCell(5).setCellValue(dataObj.getString("oweAmount")); |
| | | |