Glfrcreportsb [repack] -

return jdbcTemplate.query(sql, new Object[]ledgerId, startDate, endDate, new RowMapper<FinancialReportRecord>() @Override public FinancialReportRecord mapRow(ResultSet rs, int rowNum) throws SQLException FinancialReportRecord record = new FinancialReportRecord(); record.setAccountCode(rs.getString("account_code")); record.setAccountName(rs.getString("account_name")); record.setDebitAmount(rs.getBigDecimal("debit")); record.setCreditAmount(rs.getBigDecimal("credit")); record.setOpeningBalance(rs.getBigDecimal("opening")); record.setClosingBalance(rs.getBigDecimal("closing")); return record;

/** * Feature: glfrcreportsb * Generates the GL Financial Report Series B. * * @param ledgerId The General Ledger ID * @param startDate Report start date * @param endDate Report end date * @return List of report records */ public List<FinancialReportRecord> generateReportB(String ledgerId, LocalDate startDate, LocalDate endDate) // 1. Retrieve raw GL data List<FinancialReportRecord> rawData = reportRepository.findLedgerEntries(ledgerId, startDate, endDate); glfrcreportsb