| | |
| | | queryStatisticsDto.setFeeTypeCd(reqJson.getString("feeTypeCd")); |
| | | queryStatisticsDto.setOwnerName(reqJson.getString("ownerName")); |
| | | queryStatisticsDto.setLink(reqJson.getString("link")); |
| | | queryStatisticsDto.setPage(reqJson.getInteger("page")); |
| | | queryStatisticsDto.setRow(reqJson.getInteger("row")); |
| | | |
| | | long roomCount = getOweRoomCount(queryStatisticsDto); |
| | | |
| | |
| | | JSONArray datas = computeRoomOweReceivedFee(rooms,queryStatisticsDto); |
| | | appendData(datas, sheet, dictDtos,(page - 1) * MAX_ROW); |
| | | } |
| | | return null; |
| | | return workbook; |
| | | } |
| | | |
| | | /** |
| | |
| | | String feeTypeCdValue = ""; |
| | | JSONObject feeTypeData = null; |
| | | for (int roomIndex = 0; roomIndex < datas.size(); roomIndex++) { |
| | | row = sheet.createRow(roomIndex + 1); |
| | | row = sheet.createRow(roomIndex + step + 1); |
| | | dataObj = datas.getJSONObject(roomIndex); |
| | | row.createCell(0).setCellValue(dataObj.getString("roomName")); |
| | | row.createCell(1).setCellValue(dataObj.getString("ownerName")+"("+dataObj.getString("link")+")"); |