fineract-provider/src/main/java/org/apache/fineract/infrastructure/bulkimport/populator/fixeddeposits/FixedDepositTransactionWorkbookPopulator.java [183:259]: - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - + clientNameToBeginEndIndexes.get(clientsWithActiveSavings.get(j))[0] + ":$Q$" + clientNameToBeginEndIndexes.get(clientsWithActiveSavings.get(j))[1]); } // Payment Type Name Name paymentTypeGroup = savingsTransactionWorkbook.createName(); paymentTypeGroup.setNameName("PaymentTypes"); paymentTypeGroup.setRefersToFormula( TemplatePopulateImportConstants.EXTRAS_SHEET_NAME + "!$D$2:$D$" + (extrasSheetPopulator.getPaymentTypesSize() + 1)); } private void populateSavingsTable(Sheet savingsTransactionSheet, String dateFormat) { Workbook workbook = savingsTransactionSheet.getWorkbook(); CellStyle dateCellStyle = workbook.createCellStyle(); short df = workbook.createDataFormat().getFormat(dateFormat); dateCellStyle.setDataFormat(df); int rowIndex = 1; Row row; Collections.sort(savingsAccounts, SavingsAccountData.ClientNameComparator); for (SavingsAccountData savingsAccount : savingsAccounts) { row = savingsTransactionSheet.createRow(rowIndex++); writeString(TransactionConstants.LOOKUP_CLIENT_NAME_COL, row, savingsAccount.getClientName() + "(" + savingsAccount.getClientId() + ")"); writeString(TransactionConstants.LOOKUP_ACCOUNT_NO_COL, row, savingsAccount.getAccountNo()); writeString(TransactionConstants.LOOKUP_PRODUCT_COL, row, savingsAccount.getSavingsProductName()); if (savingsAccount.getMinRequiredOpeningBalance() != null) { writeBigDecimal(TransactionConstants.LOOKUP_OPENING_BALANCE_COL, row, savingsAccount.getMinRequiredOpeningBalance()); } writeDate(TransactionConstants.LOOKUP_SAVINGS_ACTIVATION_DATE_COL, row, "" + savingsAccount.getTimeline().getActivatedOnDate().getDayOfMonth() + "/" + savingsAccount.getTimeline().getActivatedOnDate().getMonthValue() + "/" + savingsAccount.getTimeline().getActivatedOnDate().getYear(), dateCellStyle, dateFormat); } } private void setLayout(Sheet worksheet) { Row rowHeader = worksheet.createRow(TemplatePopulateImportConstants.ROWHEADER_INDEX); rowHeader.setHeight(TemplatePopulateImportConstants.ROW_HEADER_HEIGHT); worksheet.setColumnWidth(TransactionConstants.OFFICE_NAME_COL, 4000); worksheet.setColumnWidth(TransactionConstants.CLIENT_NAME_COL, 5000); worksheet.setColumnWidth(TransactionConstants.SAVINGS_ACCOUNT_NO_COL, 3000); worksheet.setColumnWidth(TransactionConstants.PRODUCT_COL, 4000); worksheet.setColumnWidth(TransactionConstants.OPENING_BALANCE_COL, 4000); worksheet.setColumnWidth(TransactionConstants.TRANSACTION_TYPE_COL, 3300); worksheet.setColumnWidth(TransactionConstants.AMOUNT_COL, 4000); worksheet.setColumnWidth(TransactionConstants.TRANSACTION_DATE_COL, 3000); worksheet.setColumnWidth(TransactionConstants.PAYMENT_TYPE_COL, 3000); worksheet.setColumnWidth(TransactionConstants.ACCOUNT_NO_COL, 3000); worksheet.setColumnWidth(TransactionConstants.CHECK_NO_COL, 3000); worksheet.setColumnWidth(TransactionConstants.RECEIPT_NO_COL, 3000); worksheet.setColumnWidth(TransactionConstants.ROUTING_CODE_COL, 3000); worksheet.setColumnWidth(TransactionConstants.BANK_NO_COL, 3000); worksheet.setColumnWidth(TransactionConstants.LOOKUP_CLIENT_NAME_COL, 5000); worksheet.setColumnWidth(TransactionConstants.LOOKUP_ACCOUNT_NO_COL, 3000); worksheet.setColumnWidth(TransactionConstants.LOOKUP_PRODUCT_COL, 3000); worksheet.setColumnWidth(TransactionConstants.LOOKUP_OPENING_BALANCE_COL, 3700); worksheet.setColumnWidth(TransactionConstants.LOOKUP_SAVINGS_ACTIVATION_DATE_COL, 3500); writeString(TransactionConstants.OFFICE_NAME_COL, rowHeader, "Office Name*"); writeString(TransactionConstants.CLIENT_NAME_COL, rowHeader, "Client Name*"); writeString(TransactionConstants.SAVINGS_ACCOUNT_NO_COL, rowHeader, "Account No.*"); writeString(TransactionConstants.PRODUCT_COL, rowHeader, "Product Name"); writeString(TransactionConstants.OPENING_BALANCE_COL, rowHeader, "Opening Balance"); writeString(TransactionConstants.TRANSACTION_TYPE_COL, rowHeader, "Transaction Type*"); writeString(TransactionConstants.AMOUNT_COL, rowHeader, "Amount*"); writeString(TransactionConstants.TRANSACTION_DATE_COL, rowHeader, "Date*"); writeString(TransactionConstants.PAYMENT_TYPE_COL, rowHeader, "Type*"); writeString(TransactionConstants.ACCOUNT_NO_COL, rowHeader, "Account No"); writeString(TransactionConstants.CHECK_NO_COL, rowHeader, "Check No"); writeString(TransactionConstants.RECEIPT_NO_COL, rowHeader, "Receipt No"); writeString(TransactionConstants.ROUTING_CODE_COL, rowHeader, "Routing Code"); writeString(TransactionConstants.BANK_NO_COL, rowHeader, "Bank No"); writeString(TransactionConstants.LOOKUP_CLIENT_NAME_COL, rowHeader, "Lookup Client"); writeString(TransactionConstants.LOOKUP_ACCOUNT_NO_COL, rowHeader, "Lookup Account"); writeString(TransactionConstants.LOOKUP_PRODUCT_COL, rowHeader, "Lookup Product"); writeString(TransactionConstants.LOOKUP_OPENING_BALANCE_COL, rowHeader, "Lookup Opening Balance"); writeString(TransactionConstants.LOOKUP_SAVINGS_ACTIVATION_DATE_COL, rowHeader, "Lookup Savings Activation Date"); - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - fineract-provider/src/main/java/org/apache/fineract/infrastructure/bulkimport/populator/recurringdeposit/RecurringDepositTransactionWorkbookPopulator.java [184:260]: - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - + clientNameToBeginEndIndexes.get(clientsWithActiveSavings.get(j))[0] + ":$Q$" + clientNameToBeginEndIndexes.get(clientsWithActiveSavings.get(j))[1]); } // Payment Type Name Name paymentTypeGroup = savingsTransactionWorkbook.createName(); paymentTypeGroup.setNameName("PaymentTypes"); paymentTypeGroup.setRefersToFormula( TemplatePopulateImportConstants.EXTRAS_SHEET_NAME + "!$D$2:$D$" + (extrasSheetPopulator.getPaymentTypesSize() + 1)); } private void populateSavingsTable(Sheet savingsTransactionSheet, String dateFormat) { Workbook workbook = savingsTransactionSheet.getWorkbook(); CellStyle dateCellStyle = workbook.createCellStyle(); short df = workbook.createDataFormat().getFormat(dateFormat); dateCellStyle.setDataFormat(df); int rowIndex = 1; Row row; Collections.sort(savingsAccounts, SavingsAccountData.ClientNameComparator); for (SavingsAccountData savingsAccount : savingsAccounts) { row = savingsTransactionSheet.createRow(rowIndex++); writeString(TransactionConstants.LOOKUP_CLIENT_NAME_COL, row, savingsAccount.getClientName() + "(" + savingsAccount.getClientId() + ")"); writeString(TransactionConstants.LOOKUP_ACCOUNT_NO_COL, row, savingsAccount.getAccountNo()); writeString(TransactionConstants.LOOKUP_PRODUCT_COL, row, savingsAccount.getSavingsProductName()); if (savingsAccount.getMinRequiredOpeningBalance() != null) { writeBigDecimal(TransactionConstants.LOOKUP_OPENING_BALANCE_COL, row, savingsAccount.getMinRequiredOpeningBalance()); } writeDate(TransactionConstants.LOOKUP_SAVINGS_ACTIVATION_DATE_COL, row, "" + savingsAccount.getTimeline().getActivatedOnDate().getDayOfMonth() + "/" + savingsAccount.getTimeline().getActivatedOnDate().getMonthValue() + "/" + savingsAccount.getTimeline().getActivatedOnDate().getYear(), dateCellStyle, dateFormat); } } private void setLayout(Sheet worksheet) { Row rowHeader = worksheet.createRow(TemplatePopulateImportConstants.ROWHEADER_INDEX); rowHeader.setHeight(TemplatePopulateImportConstants.ROW_HEADER_HEIGHT); worksheet.setColumnWidth(TransactionConstants.OFFICE_NAME_COL, 4000); worksheet.setColumnWidth(TransactionConstants.CLIENT_NAME_COL, 5000); worksheet.setColumnWidth(TransactionConstants.SAVINGS_ACCOUNT_NO_COL, 3000); worksheet.setColumnWidth(TransactionConstants.PRODUCT_COL, 4000); worksheet.setColumnWidth(TransactionConstants.OPENING_BALANCE_COL, 4000); worksheet.setColumnWidth(TransactionConstants.TRANSACTION_TYPE_COL, 3300); worksheet.setColumnWidth(TransactionConstants.AMOUNT_COL, 4000); worksheet.setColumnWidth(TransactionConstants.TRANSACTION_DATE_COL, 3000); worksheet.setColumnWidth(TransactionConstants.PAYMENT_TYPE_COL, 3000); worksheet.setColumnWidth(TransactionConstants.ACCOUNT_NO_COL, 3000); worksheet.setColumnWidth(TransactionConstants.CHECK_NO_COL, 3000); worksheet.setColumnWidth(TransactionConstants.RECEIPT_NO_COL, 3000); worksheet.setColumnWidth(TransactionConstants.ROUTING_CODE_COL, 3000); worksheet.setColumnWidth(TransactionConstants.BANK_NO_COL, 3000); worksheet.setColumnWidth(TransactionConstants.LOOKUP_CLIENT_NAME_COL, 5000); worksheet.setColumnWidth(TransactionConstants.LOOKUP_ACCOUNT_NO_COL, 3000); worksheet.setColumnWidth(TransactionConstants.LOOKUP_PRODUCT_COL, 3000); worksheet.setColumnWidth(TransactionConstants.LOOKUP_OPENING_BALANCE_COL, 3700); worksheet.setColumnWidth(TransactionConstants.LOOKUP_SAVINGS_ACTIVATION_DATE_COL, 3500); writeString(TransactionConstants.OFFICE_NAME_COL, rowHeader, "Office Name*"); writeString(TransactionConstants.CLIENT_NAME_COL, rowHeader, "Client Name*"); writeString(TransactionConstants.SAVINGS_ACCOUNT_NO_COL, rowHeader, "Account No.*"); writeString(TransactionConstants.PRODUCT_COL, rowHeader, "Product Name"); writeString(TransactionConstants.OPENING_BALANCE_COL, rowHeader, "Opening Balance"); writeString(TransactionConstants.TRANSACTION_TYPE_COL, rowHeader, "Transaction Type*"); writeString(TransactionConstants.AMOUNT_COL, rowHeader, "Amount*"); writeString(TransactionConstants.TRANSACTION_DATE_COL, rowHeader, "Date*"); writeString(TransactionConstants.PAYMENT_TYPE_COL, rowHeader, "Type*"); writeString(TransactionConstants.ACCOUNT_NO_COL, rowHeader, "Account No"); writeString(TransactionConstants.CHECK_NO_COL, rowHeader, "Check No"); writeString(TransactionConstants.RECEIPT_NO_COL, rowHeader, "Receipt No"); writeString(TransactionConstants.ROUTING_CODE_COL, rowHeader, "Routing Code"); writeString(TransactionConstants.BANK_NO_COL, rowHeader, "Bank No"); writeString(TransactionConstants.LOOKUP_CLIENT_NAME_COL, rowHeader, "Lookup Client"); writeString(TransactionConstants.LOOKUP_ACCOUNT_NO_COL, rowHeader, "Lookup Account"); writeString(TransactionConstants.LOOKUP_PRODUCT_COL, rowHeader, "Lookup Product"); writeString(TransactionConstants.LOOKUP_OPENING_BALANCE_COL, rowHeader, "Lookup Opening Balance"); writeString(TransactionConstants.LOOKUP_SAVINGS_ACTIVATION_DATE_COL, rowHeader, "Lookup Savings Activation Date"); - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -