| | |
| | | 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")); |
| | | |