@Override
public ModelAndView getReportTemplate() {
List<MonthlyTraffic> monthlyTrafficReports = monthlyTraffictDAO.getMonthlyTraffic(monthDate);
HSSFWorkbook workbook = new HSSFWorkbook();
HSSFSheet sheet = workbook.createSheet("Monthly Traffic Report");
int rownum = 0;
Row row0 = sheet.createRow(rownum++);
row0.createCell(0).setCellValue("Source Country");
row0.createCell(1).setCellValue("Service");
row0.createCell(2).setCellValue("Destination Country");
row0.createCell(3).setCellValue("Total Call Minutes");
for (MonthlyTraffic mt : monthlyTrafficReports) {
Row row = sheet.createRow(rownum++);
row.createCell(0).setCellValue(mt.getFromCountry());
row.createCell(1).setCellValue(mt.getServiceName());
row.createCell(2).setCellValue(mt.getToCountry());
row.createCell(3).setCellValue(mt.getMinutesOfCalls());
}
Map<String, HSSFWorkbook> parameterMap = new HashMap<String, HSSFWorkbook>();
parameterMap.put("excelBook", workbook);
ModelAndView modelAndView = new ModelAndView();
modelAndView.addAllObjects(parameterMap);
return modelAndView;
}
public List<MonthlyTraffic> getAllMonthlyTraffic(Date dateforMonth) {
return monthlyTrafficDao.getMonthlyTraffic(dateforMonth);
}