| Line 703... |
Line 703... |
| 703 |
sheet.getRow(2).getCell(2).setCellValue(openingBalance);
|
703 |
sheet.getRow(2).getCell(2).setCellValue(openingBalance);
|
| 704 |
long grandTotalDebit = 0l;
|
704 |
long grandTotalDebit = 0l;
|
| 705 |
long grandTotalCredit = 0l;
|
705 |
long grandTotalCredit = 0l;
|
| 706 |
int row = 4;
|
706 |
int row = 4;
|
| 707 |
for (UserWalletHistory walletEntry : history) {
|
707 |
for (UserWalletHistory walletEntry : history) {
|
| 708 |
Cell dateCell = sheet.getRow(row).createCell(0);
|
708 |
Cell dateCell = sheet.createRow(row).createCell(0);
|
| 709 |
dateCell.setCellValue(new Date(walletEntry.getTimestamp().atZone( ZoneId.systemDefault()).toInstant().toEpochMilli()));
|
709 |
dateCell.setCellValue(new Date(walletEntry.getTimestamp().atZone( ZoneId.systemDefault()).toInstant().toEpochMilli()));
|
| 710 |
dateCell.setCellStyle(style2);
|
710 |
dateCell.setCellStyle(style2);
|
| 711 |
sheet.createRow(row).createCell(1).setCellValue(walletEntry.getReferenceType().toString());
|
711 |
sheet.getRow(row).createCell(1).setCellValue(walletEntry.getReferenceType().toString());
|
| 712 |
if(walletEntry.getAmount() > 0) {
|
712 |
if(walletEntry.getAmount() > 0) {
|
| 713 |
sheet.getRow(row).createCell(2).setCellValue(0);
|
713 |
sheet.getRow(row).createCell(2).setCellValue(0);
|
| 714 |
sheet.getRow(row).createCell(3).setCellValue(walletEntry.getAmount());
|
714 |
sheet.getRow(row).createCell(3).setCellValue(walletEntry.getAmount());
|
| 715 |
grandTotalCredit += walletEntry.getAmount();
|
715 |
grandTotalCredit += walletEntry.getAmount();
|
| 716 |
} else {
|
716 |
} else {
|