added Pentaho reports
Project: http://git-wip-us.apache.org/repos/asf/incubator-fineract/repo Commit: http://git-wip-us.apache.org/repos/asf/incubator-fineract/commit/df8ef2e8 Tree: http://git-wip-us.apache.org/repos/asf/incubator-fineract/tree/df8ef2e8 Diff: http://git-wip-us.apache.org/repos/asf/incubator-fineract/diff/df8ef2e8 Branch: refs/heads/develop Commit: df8ef2e8b6c50846e58b3fc01cffe6d27a987cc1 Parents: bb4799f Author: pramod <[email protected]> Authored: Mon Feb 8 18:17:46 2016 +0530 Committer: Adi Narayana Raju <[email protected]> Committed: Wed Feb 10 13:23:09 2016 +0530 ---------------------------------------------------------------------- fineract-provider/build.gradle | 21 ++ fineract-provider/dependencies.gradle | 16 ++ fineract-provider/dev-dependencies.gradle | 18 +- .../PentahoReportingProcessServiceImpl.java | 237 +++++++++++++++++++ .../Active Loan Summary per Branch.prpt | Bin 0 -> 8686 bytes .../Active Loans - Details(Pentaho).prpt | Bin 0 -> 9655 bytes .../Active Loans - Details.properties | 26 ++ .../Active Loans - Summary(Pentaho).prpt | Bin 0 -> 23008 bytes .../Active Loans - Summary.properties | 25 ++ ... Passed Final Maturity Summary(Pentaho).prpt | Bin 0 -> 9307 bytes ...ans Passed Final Maturity Summary.properties | 25 ++ ...ve Loans Passed Final Maturity(Pentaho).prpt | Bin 0 -> 9048 bytes ...ctive Loans Passed Final Maturity.properties | 27 +++ ...tive Loans by Disbursal Period(Pentaho).prpt | Bin 0 -> 23194 bytes .../Active Loans by Disbursal Period.properties | 20 ++ ...ns in last installment Summary(Pentaho).prpt | Bin 0 -> 9579 bytes ...Loans in last installment Summary.properties | 24 ++ ...tive Loans in last installment(Pentaho).prpt | Bin 0 -> 22860 bytes .../Active Loans in last installment.properties | 26 ++ .../ActiveLoanSummaryperBranch.properties | 16 ++ .../pentahoReports/Aging Detail(Pentaho).prpt | Bin 0 -> 8555 bytes .../main/pentahoReports/Aging Detail.properties | 20 ++ ...ng Summary (Arrears in Months)(Pentaho).prpt | Bin 0 -> 8630 bytes ...Aging Summary (Arrears in Months).properties | 12 + ...ing Summary (Arrears in Weeks)(Pentaho).prpt | Bin 0 -> 8785 bytes .../Aging Summary (Arrears in Weeks).properties | 13 + .../pentahoReports/Balance Outstanding.prpt | Bin 0 -> 9436 bytes .../src/main/pentahoReports/Balance Sheet.prpt | Bin 0 -> 22446 bytes .../Branch Expected Cash Flow.prpt | Bin 0 -> 35048 bytes .../pentahoReports/Client Listing(Pentaho).prpt | Bin 0 -> 7662 bytes .../pentahoReports/Client Listing.properties | 10 + .../Client Loan Account Schedule.prpt | Bin 0 -> 13698 bytes .../Client Loans Listing(Pentaho).prpt | Bin 0 -> 10456 bytes .../Client Saving Transactions.properties | 19 ++ .../Client Saving Transactions.prpt | Bin 0 -> 8451 bytes .../Client Saving Transactions_fr.properties | 18 ++ .../pentahoReports/Client Savings Summary.prpt | Bin 0 -> 15945 bytes .../main/pentahoReports/Collection Report.prpt | Bin 0 -> 9769 bytes .../pentahoReports/CollectionReport.properties | 20 ++ .../main/pentahoReports/Disbursal Report.prpt | Bin 0 -> 9334 bytes .../pentahoReports/DisbursalReport.properties | 23 ++ ...ected Payments By Date - Basic(Pentaho).prpt | Bin 0 -> 8515 bytes ...Expected Payments By Date - Basic.properties | 20 ++ .../Expected Payments By Date - Formatted.prpt | Bin 0 -> 35580 bytes ...etween Dates Summary by Office(Pentaho).prpt | Bin 0 -> 7745 bytes ...d Between Dates Summary by Office.PROPERTIES | 8 + ...isbursed Between Dates Summary(Pentaho).prpt | Bin 0 -> 7509 bytes ...s Disbursed Between Dates Summary.PROPERTIES | 4 + .../GeneralLedgerReport.properties | 18 ++ .../pentahoReports/GeneralLedgerReport.prpt | Bin 0 -> 8548 bytes .../main/pentahoReports/Income Statement.prpt | Bin 0 -> 17202 bytes .../Loan Account Statement.properties | 20 ++ .../pentahoReports/Loan Account statement.prpt | Bin 0 -> 7694 bytes .../Loan Transaction Receipt.properties | 42 ++++ .../Loan Transaction Receipt.prpt | Bin 0 -> 6795 bytes ...ing Disbursal Summary by Month(Pentaho).prpt | Bin 0 -> 8131 bytes ...aiting Disbursal Summary by Month.properties | 12 + ...ans Awaiting Disbursal Summary(Pentaho).prpt | Bin 0 -> 7965 bytes .../Loans Awaiting Disbursal Summary.properties | 13 + .../Loans Awaiting Disbursal(Pentaho).prpt | Bin 0 -> 9048 bytes .../Loans Awaiting Disbursal.properties | 24 ++ .../Loans Pending Approval(Pentaho).prpt | Bin 0 -> 8800 bytes .../Loans Pending Approval.properties | 18 ++ .../Obligation Met Loans Details(Pentaho).prpt | Bin 0 -> 9061 bytes .../Obligation Met Loans Details.properties | 22 ++ .../Obligation Met Loans Summary(Pentaho).prpt | Bin 0 -> 8752 bytes .../Obligation Met Loans Summary.properties | 17 ++ .../Portfolio at Risk by Branch(Pentaho).prpt | Bin 0 -> 8671 bytes .../Portfolio at Risk by Branch.properties | 15 ++ .../Portfolio at Risk(Pentaho).prpt | Bin 0 -> 8469 bytes .../pentahoReports/Portfolio at Risk.properties | 16 ++ .../Rescheduled Loans(Pentaho).prpt | Bin 0 -> 8415 bytes .../pentahoReports/Rescheduled Loans.properties | 17 ++ .../Saving Account Statement.properties | 9 + .../Saving Account Statement.prpt | Bin 0 -> 7565 bytes .../Saving Transaction.properties | 14 ++ .../Savings Transaction Receipt.properties | 27 +++ .../Savings Transaction Receipt.prpt | Bin 0 -> 6854 bytes .../pentahoReports/Savings Transactions.prpt | Bin 0 -> 14997 bytes .../Staff Assignment History.prpt | Bin 0 -> 6565 bytes .../src/main/pentahoReports/Trial Balance.prpt | Bin 0 -> 7978 bytes .../TxnRunningBalances(Pentaho).prpt | Bin 0 -> 8743 bytes .../TxnRunningBalances.properties | 19 ++ .../Written-Off Loans(Pentaho).prpt | Bin 0 -> 8739 bytes .../pentahoReports/Written-Off Loans.properties | 17 ++ .../balanceOutstanding.properties | 15 ++ .../main/pentahoReports/balanceSheet.properties | 13 + .../branchExpectedCashFlow.properties | 21 ++ .../clientLoansListing.properties | 43 ++++ .../clientSavingsSummary.properties | 19 ++ .../expectedPaymentsByDate.properties | 23 ++ .../pentahoReports/incomeStatement.properties | 15 ++ .../loanScheduleDetailed.properties | 33 +++ .../loanScheduleDetailed_fr.properties | 33 +++ .../savingsTransactions.properties | 16 ++ .../staff assigment history.properties | 17 ++ .../main/pentahoReports/trialBalance.properties | 14 ++ .../resources/META-INF/spring/appContext.xml | 3 +- .../src/main/resources/application.properties | 19 -- 99 files changed, 1231 insertions(+), 21 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/df8ef2e8/fineract-provider/build.gradle ---------------------------------------------------------------------- diff --git a/fineract-provider/build.gradle b/fineract-provider/build.gradle index d104a1f..d508b28 100644 --- a/fineract-provider/build.gradle +++ b/fineract-provider/build.gradle @@ -45,6 +45,9 @@ group = 'org.apache.fineract' repositories { jcenter() + maven { + url "http://nexus.pentaho.org/content/repositories/pentaho-public-release-repos/"; + } // mavenLocal() // useful for local dev using MariaDB4j SNAPSHOTs (not needed for real-world non-SNAPHOT builds) } @@ -94,6 +97,11 @@ task dist(type:Zip){ include '**/*' into('apps') } + from('src/main/pentahoReports/') { + fileMode = 0755 + include '*' + into('pentahoReports') + } from('../api-docs/') { fileMode = 0755 include '*' @@ -114,7 +122,20 @@ task dist(type:Zip){ into(baseName + '-' + version) } +task deployPentahoReports() { + def pentahoReportDir = System.properties['user.home'] + System.properties['file.separator'] + '.mifosx' + System.properties['file.separator'] + 'pentahoReports' + copy { + from "src/main/pentahoReports" + into pentahoReportDir + } + + doLast { + println ':deployPentahoReports - moving pentaho reports under: ' + pentahoReportDir + } +} + war { + it.dependsOn deployPentahoReports war.finalizedBy(bootRepackage) } http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/df8ef2e8/fineract-provider/dependencies.gradle ---------------------------------------------------------------------- diff --git a/fineract-provider/dependencies.gradle b/fineract-provider/dependencies.gradle index d8dabd5..610eec0 100644 --- a/fineract-provider/dependencies.gradle +++ b/fineract-provider/dependencies.gradle @@ -51,6 +51,22 @@ dependencies { [group: 'org.drizzle.jdbc', name: 'drizzle-jdbc', version: '1.3'], // [group: 'org.apache.tomcat', name: 'tomcat-jdbc', version: tomcatVersion], + [group: 'pentaho-reporting-engine', name: 'pentaho-reporting-engine-classic-core', version: '3.9.1.1'], + [group: 'pentaho-reporting-engine', name: 'pentaho-reporting-engine-classic-extensions', version: '3.9.1-GA'], + [group: 'pentaho-reporting-engine', name: 'pentaho-reporting-engine-classic-extensions-scripting', version: '3.9.1-GA'], + [group: 'pentaho-reporting-engine', name: 'pentaho-reporting-engine-wizard-core', version: '3.9.1-GA'], + [group: 'pentaho-report-designer', name: 'pentaho-reporting-engine-wizard-xul', version: '3.9.1-GA'], + + [group: 'pentaho-library', name: 'libbase', version: '1.2.8'], + [group: 'pentaho-library',name: 'libdocbundle', version: '1.2.8'], + [group: 'pentaho-library',name: 'libfonts', version: '1.2.8'], + [group: 'pentaho-library',name: 'libformat', version: '1.2.8'], + [group: 'pentaho-library',name: 'libformula', version: '1.2.8'], + [group: 'pentaho-library',name: 'libloader', version: '1.2.8'], + [group: 'pentaho-library',name: 'librepository', version: '1.2.8'], + [group: 'pentaho-library',name: 'libserializer', version: '1.2.8'], + [group: 'pentaho-library',name: 'libsparkline', version: '1.2.8'], + [group: 'pentaho-library',name: 'libxml', version: '1.2.8'], [group: 'org.apache.poi',name: 'poi', version: '3.9'], [group: 'org.apache.poi',name: 'poi-ooxml', version: '3.9'], http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/df8ef2e8/fineract-provider/dev-dependencies.gradle ---------------------------------------------------------------------- diff --git a/fineract-provider/dev-dependencies.gradle b/fineract-provider/dev-dependencies.gradle index 89ffcf1..74e5b37 100644 --- a/fineract-provider/dev-dependencies.gradle +++ b/fineract-provider/dev-dependencies.gradle @@ -50,7 +50,23 @@ dependencies { [group: 'org.drizzle.jdbc', name: 'drizzle-jdbc', version: '1.3'], [group: 'org.apache.tomcat', name: 'tomcat-jdbc', version: tomcatVersion], - + [group: 'pentaho-reporting-engine', name: 'pentaho-reporting-engine-classic-core', version: '3.9.1.1'], + [group: 'pentaho-reporting-engine', name: 'pentaho-reporting-engine-classic-extensions', version: '3.9.1-GA'], + [group: 'pentaho-reporting-engine', name: 'pentaho-reporting-engine-classic-extensions-scripting', version: '3.9.1-GA'], + [group: 'pentaho-reporting-engine', name: 'pentaho-reporting-engine-wizard-core', version: '3.9.1-GA'], + [group: 'pentaho-report-designer', name: 'pentaho-reporting-engine-wizard-xul', version: '3.9.1-GA'], + + [group: 'pentaho-library', name: 'libbase', version: '1.2.8'], + [group: 'pentaho-library',name: 'libdocbundle', version: '1.2.8'], + [group: 'pentaho-library',name: 'libfonts', version: '1.2.8'], + [group: 'pentaho-library',name: 'libformat', version: '1.2.8'], + [group: 'pentaho-library',name: 'libformula', version: '1.2.8'], + [group: 'pentaho-library',name: 'libloader', version: '1.2.8'], + [group: 'pentaho-library',name: 'librepository', version: '1.2.8'], + [group: 'pentaho-library',name: 'libserializer', version: '1.2.8'], + [group: 'pentaho-library',name: 'libsparkline', version: '1.2.8'], + [group: 'pentaho-library',name: 'libxml', version: '1.2.8'], + [group: 'org.apache.poi',name: 'poi', version: '3.9'], [group: 'org.apache.poi',name: 'poi-ooxml', version: '3.9'], [group: 'org.apache.poi',name: 'poi-ooxml-schemas', version: '3.9'], http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/df8ef2e8/fineract-provider/src/main/java/org/mifosplatform/infrastructure/report/service/PentahoReportingProcessServiceImpl.java ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/java/org/mifosplatform/infrastructure/report/service/PentahoReportingProcessServiceImpl.java b/fineract-provider/src/main/java/org/mifosplatform/infrastructure/report/service/PentahoReportingProcessServiceImpl.java new file mode 100644 index 0000000..154fc74 --- /dev/null +++ b/fineract-provider/src/main/java/org/mifosplatform/infrastructure/report/service/PentahoReportingProcessServiceImpl.java @@ -0,0 +1,237 @@ +/** + * This Source Code Form is subject to the terms of the Mozilla Public + * License, v. 2.0. If a copy of the MPL was not distributed with this file, + * You can obtain one at http://mozilla.org/MPL/2.0/. + */ +package org.mifosplatform.infrastructure.report.service; + +import java.io.ByteArrayOutputStream; +import java.io.File; +import java.io.IOException; +import java.sql.Connection; +import java.sql.Date; +import java.util.HashMap; +import java.util.Locale; +import java.util.Map; +import java.util.Set; + +import javax.sql.DataSource; +import javax.ws.rs.core.MultivaluedMap; +import javax.ws.rs.core.Response; + +import org.apache.commons.lang.StringUtils; +import org.apache.fineract.infrastructure.core.api.ApiParameterHelper; +import org.apache.fineract.infrastructure.core.domain.FineractPlatformTenant; +import org.apache.fineract.infrastructure.core.domain.FineractPlatformTenantConnection; +import org.apache.fineract.infrastructure.core.exception.PlatformDataIntegrityException; +import org.apache.fineract.infrastructure.core.service.RoutingDataSource; +import org.apache.fineract.infrastructure.core.service.ThreadLocalContextUtil; +import org.apache.fineract.infrastructure.report.annotation.ReportService; +import org.apache.fineract.infrastructure.report.service.ReportingProcessService; +import org.apache.fineract.infrastructure.security.service.PlatformSecurityContext; +import org.apache.fineract.useradministration.domain.AppUser; +import org.pentaho.reporting.engine.classic.core.ClassicEngineBoot; +import org.pentaho.reporting.engine.classic.core.DefaultReportEnvironment; +import org.pentaho.reporting.engine.classic.core.MasterReport; +import org.pentaho.reporting.engine.classic.core.ReportProcessingException; +import org.pentaho.reporting.engine.classic.core.modules.output.pageable.pdf.PdfReportUtil; +import org.pentaho.reporting.engine.classic.core.modules.output.table.csv.CSVReportUtil; +import org.pentaho.reporting.engine.classic.core.modules.output.table.html.HtmlReportUtil; +import org.pentaho.reporting.engine.classic.core.modules.output.table.xls.ExcelReportUtil; +import org.pentaho.reporting.engine.classic.core.parameters.ParameterDefinitionEntry; +import org.pentaho.reporting.engine.classic.core.parameters.ReportParameterDefinition; +import org.pentaho.reporting.engine.classic.core.util.ReportParameterValues; +import org.pentaho.reporting.libraries.resourceloader.Resource; +import org.pentaho.reporting.libraries.resourceloader.ResourceException; +import org.pentaho.reporting.libraries.resourceloader.ResourceManager; +import org.slf4j.Logger; +import org.slf4j.LoggerFactory; +import org.springframework.beans.factory.annotation.Autowired; +import org.springframework.stereotype.Service; + +@Service +@ReportService(type = "Pentaho") +public class PentahoReportingProcessServiceImpl implements ReportingProcessService { + + private final static Logger logger = LoggerFactory.getLogger(PentahoReportingProcessServiceImpl.class); + public static final String MIFOS_BASE_DIR = System.getProperty("user.home") + File.separator + ".mifosx"; + + private final DataSource dataSource; + private final PlatformSecurityContext context; + private boolean noPentaho = false; + + @Autowired + public PentahoReportingProcessServiceImpl(final PlatformSecurityContext context, final RoutingDataSource dataSource) { + // kick off pentaho reports server + ClassicEngineBoot.getInstance().start(); + this.noPentaho = false; + + this.context = context; + this.dataSource = dataSource; + } + + @Override + public Response processRequest(final String reportName, final MultivaluedMap<String, String> queryParams) { + + final String outputTypeParam = queryParams.getFirst("output-type"); + final Map<String, String> reportParams = getReportParams(queryParams); + final Locale locale = ApiParameterHelper.extractLocale(queryParams); + + String outputType = "HTML"; + if (StringUtils.isNotBlank(outputTypeParam)) { + outputType = outputTypeParam; + } + + if (!(outputType.equalsIgnoreCase("HTML") || outputType.equalsIgnoreCase("PDF") || outputType.equalsIgnoreCase("XLS") + || outputType.equalsIgnoreCase("XLSX") || outputType.equalsIgnoreCase("CSV"))) { throw new PlatformDataIntegrityException( + "error.msg.invalid.outputType", "No matching Output Type: " + outputType); } + + if (this.noPentaho) { throw new PlatformDataIntegrityException("error.msg.no.pentaho", "Pentaho is not enabled", + "Pentaho is not enabled"); } + + final String reportPath = MIFOS_BASE_DIR + File.separator + "pentahoReports" + File.separator + reportName + ".prpt"; + logger.info("Report path: " + reportPath); + + // load report definition + final ResourceManager manager = new ResourceManager(); + manager.registerDefaults(); + Resource res; + + try { + res = manager.createDirectly(reportPath, MasterReport.class); + final MasterReport masterReport = (MasterReport) res.getResource(); + final DefaultReportEnvironment reportEnvironment = (DefaultReportEnvironment) masterReport.getReportEnvironment(); + if (locale != null) { + reportEnvironment.setLocale(locale); + } + addParametersToReport(masterReport, reportParams); + + final ByteArrayOutputStream baos = new ByteArrayOutputStream(); + + if ("PDF".equalsIgnoreCase(outputType)) { + PdfReportUtil.createPDF(masterReport, baos); + return Response.ok().entity(baos.toByteArray()).type("application/pdf").build(); + } + + if ("XLS".equalsIgnoreCase(outputType)) { + ExcelReportUtil.createXLS(masterReport, baos); + return Response.ok().entity(baos.toByteArray()).type("application/vnd.ms-excel") + .header("Content-Disposition", "attachment;filename=" + reportName.replaceAll(" ", "") + ".xls").build(); + } + + if ("XLSX".equalsIgnoreCase(outputType)) { + ExcelReportUtil.createXLSX(masterReport, baos); + return Response.ok().entity(baos.toByteArray()).type("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet") + .header("Content-Disposition", "attachment;filename=" + reportName.replaceAll(" ", "") + ".xlsx").build(); + } + + if ("CSV".equalsIgnoreCase(outputType)) { + CSVReportUtil.createCSV(masterReport, baos, "UTF-8"); + return Response.ok().entity(baos.toByteArray()).type("text/csv") + .header("Content-Disposition", "attachment;filename=" + reportName.replaceAll(" ", "") + ".csv").build(); + } + + if ("HTML".equalsIgnoreCase(outputType)) { + HtmlReportUtil.createStreamHTML(masterReport, baos); + return Response.ok().entity(baos.toByteArray()).type("text/html").build(); + } + } catch (final ResourceException e) { + throw new PlatformDataIntegrityException("error.msg.reporting.error", e.getMessage()); + } catch (final ReportProcessingException e) { + throw new PlatformDataIntegrityException("error.msg.reporting.error", e.getMessage()); + } catch (final IOException e) { + throw new PlatformDataIntegrityException("error.msg.reporting.error", e.getMessage()); + } + + throw new PlatformDataIntegrityException("error.msg.invalid.outputType", "No matching Output Type: " + outputType); + } + + private void addParametersToReport(final MasterReport report, final Map<String, String> queryParams) { + + final AppUser currentUser = this.context.authenticatedUser(); + + try { + + final ReportParameterValues rptParamValues = report.getParameterValues(); + final ReportParameterDefinition paramsDefinition = report.getParameterDefinition(); + + /* + * only allow integer, long, date and string parameter types and + * assume all mandatory - could go more detailed like Pawel did in + * Mifos later and could match incoming and pentaho parameters + * better... currently assuming they come in ok... and if not an + * error + */ + for (final ParameterDefinitionEntry paramDefEntry : paramsDefinition.getParameterDefinitions()) { + final String paramName = paramDefEntry.getName(); + if (!((paramName.equals("tenantUrl")) || (paramName.equals("userhierarchy") || (paramName.equals("username")) || (paramName + .equals("password") || (paramName.equals("userid")))))) { + logger.info("paramName:" + paramName); + final String pValue = queryParams.get(paramName); + if (StringUtils.isBlank(pValue)) { throw new PlatformDataIntegrityException("error.msg.reporting.error", + "Pentaho Parameter: " + paramName + " - not Provided"); } + + final Class<?> clazz = paramDefEntry.getValueType(); + logger.info("addParametersToReport(" + paramName + " : " + pValue + " : " + clazz.getCanonicalName() + ")"); + if (clazz.getCanonicalName().equalsIgnoreCase("java.lang.Integer")) { + rptParamValues.put(paramName, Integer.parseInt(pValue)); + } else if (clazz.getCanonicalName().equalsIgnoreCase("java.lang.Long")) { + rptParamValues.put(paramName, Long.parseLong(pValue)); + } else if (clazz.getCanonicalName().equalsIgnoreCase("java.sql.Date")) { + rptParamValues.put(paramName, Date.valueOf(pValue)); + } else { + rptParamValues.put(paramName, pValue); + } + } + + } + + // tenant database name and current user's office hierarchy + // passed as parameters to allow multitenant penaho reporting + // and + // data scoping + final Connection connection = this.dataSource.getConnection(); + String tenantUrl; + try { + tenantUrl = connection.getMetaData().getURL(); + } finally { + connection.close(); + } + final String userhierarchy = currentUser.getOffice().getHierarchy(); + logger.info("db URL:" + tenantUrl + " userhierarchy:" + userhierarchy); + rptParamValues.put("userhierarchy", userhierarchy); + + final Long userid = currentUser.getId(); + logger.info("db URL:" + tenantUrl + " userid:" + userid); + rptParamValues.put("userid", userid); + + final FineractPlatformTenant tenant = ThreadLocalContextUtil.getTenant(); + final FineractPlatformTenantConnection tenantConnection = tenant.getConnection(); + + rptParamValues.put("tenantUrl", tenantUrl); + rptParamValues.put("username", tenantConnection.getSchemaUsername()); + rptParamValues.put("password", tenantConnection.getSchemaPassword()); + } catch (final Exception e) { + logger.error("error.msg.reporting.error:" + e.getMessage()); + throw new PlatformDataIntegrityException("error.msg.reporting.error", e.getMessage()); + } + } + + private Map<String, String> getReportParams(final MultivaluedMap<String, String> queryParams) { + + final Map<String, String> reportParams = new HashMap<>(); + final Set<String> keys = queryParams.keySet(); + String pKey; + String pValue; + for (final String k : keys) { + + if (k.startsWith("R_")) { + pKey = k.substring(2); + pValue = queryParams.get(k).get(0); + reportParams.put(pKey, pValue); + } + } + return reportParams; + } + +} \ No newline at end of file http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/df8ef2e8/fineract-provider/src/main/pentahoReports/Active Loan Summary per Branch.prpt ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/pentahoReports/Active Loan Summary per Branch.prpt b/fineract-provider/src/main/pentahoReports/Active Loan Summary per Branch.prpt new file mode 100644 index 0000000..76af0d3 Binary files /dev/null and b/fineract-provider/src/main/pentahoReports/Active Loan Summary per Branch.prpt differ http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/df8ef2e8/fineract-provider/src/main/pentahoReports/Active Loans - Details(Pentaho).prpt ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/pentahoReports/Active Loans - Details(Pentaho).prpt b/fineract-provider/src/main/pentahoReports/Active Loans - Details(Pentaho).prpt new file mode 100644 index 0000000..3429338 Binary files /dev/null and b/fineract-provider/src/main/pentahoReports/Active Loans - Details(Pentaho).prpt differ http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/df8ef2e8/fineract-provider/src/main/pentahoReports/Active Loans - Details.properties ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/pentahoReports/Active Loans - Details.properties b/fineract-provider/src/main/pentahoReports/Active Loans - Details.properties new file mode 100644 index 0000000..5986b16 --- /dev/null +++ b/fineract-provider/src/main/pentahoReports/Active Loans - Details.properties @@ -0,0 +1,26 @@ +label.column.Office/Branch=Office/Branch +label.column.Currency=Currency +label.column.loan.Officer=Loan Officer +label.column.client=Client +label.column.Loan.Account.No=Loan Account No. +label.column.Product=Product +label.column.Fund=Fund +label.column.Loan.Amount=Loan Amount +label.column.Annual.Nominal.Interest.Rate=Annual Nominal Interest Rate +label.column.Disbursed.Date=Disbursed Date +label.column.Expected.Matured.On=Expected Matured On +label.column.Principal.Repaid=Principal Repaid +label.column.Principal.Outstanding=Principal Outstanding +label.column.Principal.Overdue=Principal Overdue +label.column.Interest.Repaid=Interest Repaid +label.column.Interest.Outstanding=Interest Outstanding +label.column.Interest.Overdue=Interest Overdue +label.column.Fees.Repaid=Fees Repaid +label.column.Fees.Outstanding=Fees Outstanding +label.column.Fees.Overdue=Fees Overdue +label.column.Penalties.Repaid=Penalties Repaid +label.column.Penalties.Outstanding=Penalties Outstanding +label.column.Penalties.Overdue=Penalties Overdue +label.groupby.Branch=Branch +label.title.Active.Loans.Details=Active Loans - Details +lable.group.tolat=Total http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/df8ef2e8/fineract-provider/src/main/pentahoReports/Active Loans - Summary(Pentaho).prpt ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/pentahoReports/Active Loans - Summary(Pentaho).prpt b/fineract-provider/src/main/pentahoReports/Active Loans - Summary(Pentaho).prpt new file mode 100644 index 0000000..34bc154 Binary files /dev/null and b/fineract-provider/src/main/pentahoReports/Active Loans - Summary(Pentaho).prpt differ http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/df8ef2e8/fineract-provider/src/main/pentahoReports/Active Loans - Summary.properties ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/pentahoReports/Active Loans - Summary.properties b/fineract-provider/src/main/pentahoReports/Active Loans - Summary.properties new file mode 100644 index 0000000..2b92dbc --- /dev/null +++ b/fineract-provider/src/main/pentahoReports/Active Loans - Summary.properties @@ -0,0 +1,25 @@ +label.column.Office/Branch=Office/Branch +label.column.Currency=Currency +label.column.No.of.Clients=No. of Clients +label.column.No.Active.Loans=No. Active Loans +label.column.No.of.Loans.in.Arrears=No. of Loans in Arrears +label.column.Total.Loans.Disbursed=Total Loans Disbursed +label.column.Principal.Repaid=Principal Repaid +label.column.Principal.Outstanding=Principal Outstanding +label.column.Principal.Overdue=Principal Overdue +label.column.Total.Interest=Total Interest +label.column.Interest.Repaid=Interest Repaid +label.column.Interest.Outstanding=Interest Outstanding +label.column.Interest.Overdue=Interest Overdue +label.column.Total.Fees=Total Fees +label.column.Fees.Repaid=Fees Repaid +label.column.Fees.Outstanding=Fees Outstanding +label.column.Fees.Overdue=Fees Overdue +label.column.Total.Penalties=Total Penalties +label.column.Penalties.Repaid=Penalties Repaid +label.column.Penalties.Outstanding=Penalties Outstanding +label.column.Penalties.Overdue=Penalties Overdue +label.column.Portfolio.at.Risk%=Portfolio at Risk % +label.groupby.column.Branch=Branch + +label.title.Active.Loans.Details=Active Loan-Summary \ No newline at end of file http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/df8ef2e8/fineract-provider/src/main/pentahoReports/Active Loans Passed Final Maturity Summary(Pentaho).prpt ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/pentahoReports/Active Loans Passed Final Maturity Summary(Pentaho).prpt b/fineract-provider/src/main/pentahoReports/Active Loans Passed Final Maturity Summary(Pentaho).prpt new file mode 100644 index 0000000..0426d38 Binary files /dev/null and b/fineract-provider/src/main/pentahoReports/Active Loans Passed Final Maturity Summary(Pentaho).prpt differ http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/df8ef2e8/fineract-provider/src/main/pentahoReports/Active Loans Passed Final Maturity Summary.properties ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/pentahoReports/Active Loans Passed Final Maturity Summary.properties b/fineract-provider/src/main/pentahoReports/Active Loans Passed Final Maturity Summary.properties new file mode 100644 index 0000000..6a4e9b4 --- /dev/null +++ b/fineract-provider/src/main/pentahoReports/Active Loans Passed Final Maturity Summary.properties @@ -0,0 +1,25 @@ +label.column.Office/Branch=Office/Branch +label.column.Currency=Currency +label.column.No.of.Clients=No. of Clients +label.column.No.Active.Loans=No. Active Loans +label.column.No.of.Loans.in.Arrears=No. of Loans in Arrears +label.column.Total.Loans.Disbursed=Total Loans Disbursed +label.column.Principal.Repaid=Principal Repaid +label.column.Principal.Outstanding=Principal Outstanding +label.column.Principal.Overdue=Principal Overdue +label.column.Total.Interest=Total Interest +label.column.Interest.Repaid=Interest Repaid +label.column.Interest.Outstanding=Interest Outstanding +label.column.Interest.Overdue=Interest Overdue +label.column.Total.Fees=Total Fees +label.column.Fees.Repaid=Fees Repaid +label.column.Fees.Outstanding=Fees Outstanding +label.column.Fees.Overdue=Fees Overdue +label.column.Total.Penalties=Total Penalties +label.column.Penalties.Repaid=Penalties Repaid +label.column.Penalties.Outstanding=Penalties Outstanding +label.column.Penalties.Overdue=Penalties Overdue +label.column.Portfolio.at.Risk%=Portfolio at Risk % +lable.title.Active.Loans.Passed.Final.Maturity.Summary=Active Loans Passed Final Maturity Summary + + http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/df8ef2e8/fineract-provider/src/main/pentahoReports/Active Loans Passed Final Maturity(Pentaho).prpt ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/pentahoReports/Active Loans Passed Final Maturity(Pentaho).prpt b/fineract-provider/src/main/pentahoReports/Active Loans Passed Final Maturity(Pentaho).prpt new file mode 100644 index 0000000..70da51a Binary files /dev/null and b/fineract-provider/src/main/pentahoReports/Active Loans Passed Final Maturity(Pentaho).prpt differ http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/df8ef2e8/fineract-provider/src/main/pentahoReports/Active Loans Passed Final Maturity.properties ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/pentahoReports/Active Loans Passed Final Maturity.properties b/fineract-provider/src/main/pentahoReports/Active Loans Passed Final Maturity.properties new file mode 100644 index 0000000..88cefb1 --- /dev/null +++ b/fineract-provider/src/main/pentahoReports/Active Loans Passed Final Maturity.properties @@ -0,0 +1,27 @@ +label.column.Office/Branch=Office/Branch +label.column.Currency=Currency +label.column.Loan.Officer=Loan Officer +label.column.Client=Client +label.column.Loan.Account.No=Loan Account No. +label.column.Product=Product +label.column.Fund=Fund +label.column.Loan.Amount=Loan Amount +label.column.Annual.Nominal.Interest.Rate=Annual Nominal Interest Rate +label.column.Disbursed.Date=Disbursed Date +label.column.Expected.Matured.On=Expected Matured On +label.column.Principal.Repaid=Principal Repaid +label.column.Principal.Outstanding=Principal Outstanding +label.column.Principal.Overdue=Principal Overdue +label.column.Interest.Repaid=Interest Repaid +label.column.Interest.Outstanding=Interest Outstanding +label.column.Interest.Overdue=Interest Overdue +label.column.Fees.Repaid=Fees Repaid +label.column.Fees.Outstanding=Fees Outstanding +label.column.Fees.Overdue=Fees Overdue +label.column.Penalties.Repaid=Penalties Repaid +label.column.Penalties.Outstanding=Penalties Outstanding +label.column.Penalties.Overdue=Penalties Overdue + +lable.title.Active.Loans.Passed.Final.Maturity=Active Loans Passed Final Maturity + +lable.title.group.Branch=Branch \ No newline at end of file http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/df8ef2e8/fineract-provider/src/main/pentahoReports/Active Loans by Disbursal Period(Pentaho).prpt ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/pentahoReports/Active Loans by Disbursal Period(Pentaho).prpt b/fineract-provider/src/main/pentahoReports/Active Loans by Disbursal Period(Pentaho).prpt new file mode 100644 index 0000000..709040f Binary files /dev/null and b/fineract-provider/src/main/pentahoReports/Active Loans by Disbursal Period(Pentaho).prpt differ http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/df8ef2e8/fineract-provider/src/main/pentahoReports/Active Loans by Disbursal Period.properties ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/pentahoReports/Active Loans by Disbursal Period.properties b/fineract-provider/src/main/pentahoReports/Active Loans by Disbursal Period.properties new file mode 100644 index 0000000..f5e48bf --- /dev/null +++ b/fineract-provider/src/main/pentahoReports/Active Loans by Disbursal Period.properties @@ -0,0 +1,20 @@ +label.column.Office/Branch=Office/Branch +label.column.Currency=Currency +label.column.Client.Account.No=Client Account No +label.column.Client=Client +label.column.Loan.Account.No=Loan Account No +label.column.Product=Product +label.column.Fund=Fund +label.column.Loan.Principal.Amount=Loan Principal Amount +label.column.Annual.Nominal.Interest.Rate=Annual Nominal Interest Rate +label.column.Disbursed.Date=Disbursed Date +label.column.Total.Loan(P+I+F+Pen)=Total Loan (P+I+F+Pen) +label.column.Total.Repaid(P+I+F+Pen)=Total Repaid (P+I+F+Pen) +label.column.Loan.Officer=Loan Officer +label.title.Active.Loans.by.Disbursal.Period=Active Loans by Disbursal Period +lable.grouptotal.by.date=Total +lable.grouptotal.by.Branch= Branch Total +label.groupby.column.Disbursed.Date=Disbursed Date +label.groupby.column.Branch=Branch +lable.title.Disbursal.Period.from=Disbursal Period from +lable.title.Disbursal.Period.to=To \ No newline at end of file http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/df8ef2e8/fineract-provider/src/main/pentahoReports/Active Loans in last installment Summary(Pentaho).prpt ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/pentahoReports/Active Loans in last installment Summary(Pentaho).prpt b/fineract-provider/src/main/pentahoReports/Active Loans in last installment Summary(Pentaho).prpt new file mode 100644 index 0000000..d08aeda Binary files /dev/null and b/fineract-provider/src/main/pentahoReports/Active Loans in last installment Summary(Pentaho).prpt differ http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/df8ef2e8/fineract-provider/src/main/pentahoReports/Active Loans in last installment Summary.properties ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/pentahoReports/Active Loans in last installment Summary.properties b/fineract-provider/src/main/pentahoReports/Active Loans in last installment Summary.properties new file mode 100644 index 0000000..ca21497 --- /dev/null +++ b/fineract-provider/src/main/pentahoReports/Active Loans in last installment Summary.properties @@ -0,0 +1,24 @@ +label.column.Office/Branch=Office/Branch +label.column.Currency=Currency +label.column.No.of.Clients=No. of Clients +label.column.No.Active.Loans=No. Active Loans +label.column.No.of.Loans.in.Arrears=No. of Loans in Arrears +label.column.Total.Loans.Disbursed=Total Loans Disbursed +label.column.Principal.Repaid=Principal Repaid +label.column.Principal.Outstanding=Principal Outstanding +label.column.Principal.Overdue=Principal Overdue +label.column.Total.Interest=Total Interest +label.column.Interest.Repaid=Interest Repaid +label.column.Interest.Outstanding=Interest Outstanding +label.column.Interest.Overdue=Interest Overdue +label.column.Total.Fees=Total Fees +label.column.Fees.Repaid=Fees Repaid +label.column.Fees.Outstanding=Fees Outstanding +label.column.Fees.Overdue=Fees Overdue +label.column.Total.Penalties=Total Penalties +label.column.Penalties.Repaid=Penalties Repaid +label.column.Penalties.Outstanding=Penalties Outstanding +label.column.Penalties.Overdue=Penalties Overdue +label.column.Portfolio.at.Risk%=Portfolio at Risk % +label.groupby.column.Branch=Branch +lable.title.Active.Loans.In.Last.Installment.Summary=Active Loans In Last Installment Summary http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/df8ef2e8/fineract-provider/src/main/pentahoReports/Active Loans in last installment(Pentaho).prpt ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/pentahoReports/Active Loans in last installment(Pentaho).prpt b/fineract-provider/src/main/pentahoReports/Active Loans in last installment(Pentaho).prpt new file mode 100644 index 0000000..256450b Binary files /dev/null and b/fineract-provider/src/main/pentahoReports/Active Loans in last installment(Pentaho).prpt differ http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/df8ef2e8/fineract-provider/src/main/pentahoReports/Active Loans in last installment.properties ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/pentahoReports/Active Loans in last installment.properties b/fineract-provider/src/main/pentahoReports/Active Loans in last installment.properties new file mode 100644 index 0000000..00cf44d --- /dev/null +++ b/fineract-provider/src/main/pentahoReports/Active Loans in last installment.properties @@ -0,0 +1,26 @@ +label.column.Office/Branch=Office/Branch +label.column.Currency=Currency +label.column.Loan.Officer=Loan Officer +label.column.Client.Account.No=Client Account No +label.column.Client=Client +label.column.Loan.Account.No=Loan Account No +label.column.Product=Product +label.column.Fund=Fund +label.column.Loan.Amount=Loan Amount +label.column.Annual.Nominal.Interest.Rate=Annual Nominal Interest Rate +label.column.Disbursed=Disbursed +label.column.Expected.Matured.On=Expected Matured On +label.column.Principal.Repaid=Principal Repaid +label.column.Principal.Outstanding=Principal Outstanding +label.column.Principal.Overdue=Principal Overdue +label.column.Interest.Repaid=Interest Repaid +label.column.Interest.Outstanding=Interest Outstanding +label.column.Interest.Overdue=Interest Overdue +label.column.Fees.Repaid=Fees Repaid +label.column.Fees.Outstanding=Fees Outstanding +label.column.Fees.Overdue=Fees Overdue +label.column.Penalties.Repaid=Penalties Repaid +label.column.Penalties.Outstanding=Penalties Outstanding +label.column.Penalties.Overdue=Penalties Overdue +label.groupby.column.Branch=Branch +lable.title.Active.Loans.In.Last.Installment=Active Loans In Last Installment http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/df8ef2e8/fineract-provider/src/main/pentahoReports/ActiveLoanSummaryperBranch.properties ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/pentahoReports/ActiveLoanSummaryperBranch.properties b/fineract-provider/src/main/pentahoReports/ActiveLoanSummaryperBranch.properties new file mode 100644 index 0000000..5a8ff11 --- /dev/null +++ b/fineract-provider/src/main/pentahoReports/ActiveLoanSummaryperBranch.properties @@ -0,0 +1,16 @@ +active_loan_summery.=Active Loan Summary per Branch +branch.=Branch +centers.=No of Centers +groups.=No of Groups +clients.=No of Clients +activeloan.=No of Active Loan +loanarrears.=No of Loan in Arrears +disbursed.=Total Loans Disbursed +principalrepaid.=Total Principal Repaid +interestrepaid.=Total Interest Repaid +principaloutstand.=Total Principal Outstanding +interestoutstand.=Total Interest Outstanding +amountarreas.=Amount in Arrears +total.=Total +PrintedBy\:=Printed By : +On\:=On : \ No newline at end of file http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/df8ef2e8/fineract-provider/src/main/pentahoReports/Aging Detail(Pentaho).prpt ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/pentahoReports/Aging Detail(Pentaho).prpt b/fineract-provider/src/main/pentahoReports/Aging Detail(Pentaho).prpt new file mode 100644 index 0000000..c5c1b89 Binary files /dev/null and b/fineract-provider/src/main/pentahoReports/Aging Detail(Pentaho).prpt differ http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/df8ef2e8/fineract-provider/src/main/pentahoReports/Aging Detail.properties ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/pentahoReports/Aging Detail.properties b/fineract-provider/src/main/pentahoReports/Aging Detail.properties new file mode 100644 index 0000000..de8165c --- /dev/null +++ b/fineract-provider/src/main/pentahoReports/Aging Detail.properties @@ -0,0 +1,20 @@ +label.column.Office/Branch=Office/Branch +label.column.Currency=Currency +label.column.Client.Account.No=Client Account No. +label.column.Client.Name=Client Name +label.column.Account.Number=Account Number +label.column.Loan.Amount=Loan Amount +label.column.Original.Principal=Original Principal +label.column.Original.Interest=Original Interest +label.column.Principal.Paid=Principal Paid +label.column.Interest.Paid=Interest Paid +label.column.Principal.Overdue=Principal Overdue +label.column.Interest.Overdue=Interest Overdue +label.column.Days.in.Arrears=Days in Arrears +label.column.Weeks.In.Arrears.Band=Weeks In Arrears Band +label.column.Days.in.Arrears.Band=Days in Arrears Band + + +lable.title.Aging.Detail=Aging Detail + +lable.title.group.Branch=Branch http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/df8ef2e8/fineract-provider/src/main/pentahoReports/Aging Summary (Arrears in Months)(Pentaho).prpt ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/pentahoReports/Aging Summary (Arrears in Months)(Pentaho).prpt b/fineract-provider/src/main/pentahoReports/Aging Summary (Arrears in Months)(Pentaho).prpt new file mode 100644 index 0000000..581b0a4 Binary files /dev/null and b/fineract-provider/src/main/pentahoReports/Aging Summary (Arrears in Months)(Pentaho).prpt differ http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/df8ef2e8/fineract-provider/src/main/pentahoReports/Aging Summary (Arrears in Months).properties ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/pentahoReports/Aging Summary (Arrears in Months).properties b/fineract-provider/src/main/pentahoReports/Aging Summary (Arrears in Months).properties new file mode 100644 index 0000000..c322bf4 --- /dev/null +++ b/fineract-provider/src/main/pentahoReports/Aging Summary (Arrears in Months).properties @@ -0,0 +1,12 @@ +label.column.currency=currency +label.column.Days.In.Arrears=Days In Arrears +label.column.No.Of.Loans=No Of Loans +label.column.Original.Principal=Original Principal +label.column.Original.Interest=Original Interest +label.column.Principal.Paid=Principal Paid +label.column.Interest.Paid=Interest Paid +label.column.Principal.Overdue=Principal Overdue +label.column.Interest.Overdue=Interest Overdue +lable.title.Aging.Summary.Months=Aging Summary (Arrears in Months) + +lable.title.group.Branch=Branch http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/df8ef2e8/fineract-provider/src/main/pentahoReports/Aging Summary (Arrears in Weeks)(Pentaho).prpt ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/pentahoReports/Aging Summary (Arrears in Weeks)(Pentaho).prpt b/fineract-provider/src/main/pentahoReports/Aging Summary (Arrears in Weeks)(Pentaho).prpt new file mode 100644 index 0000000..7f2604b Binary files /dev/null and b/fineract-provider/src/main/pentahoReports/Aging Summary (Arrears in Weeks)(Pentaho).prpt differ http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/df8ef2e8/fineract-provider/src/main/pentahoReports/Aging Summary (Arrears in Weeks).properties ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/pentahoReports/Aging Summary (Arrears in Weeks).properties b/fineract-provider/src/main/pentahoReports/Aging Summary (Arrears in Weeks).properties new file mode 100644 index 0000000..5869937 --- /dev/null +++ b/fineract-provider/src/main/pentahoReports/Aging Summary (Arrears in Weeks).properties @@ -0,0 +1,13 @@ +label.column.Currency=Currency +label.column.Weeks.In.Arrears=Weeks In Arrears(Up To) +label.column.N.Of.Loans=No Of Loans +label.column.Original.Principal=Original Principal +label.column.Original.Interest=Original Interest +label.column.Principal.Paid=Principal Paid +label.column.Interest.Paid=Interest Paid +label.column.Principal.Overdue=Principal Overdue +label.column.Interest.Overdue=Interest Overdue + +lable.title.Aging.Summary.in.Weeks=Aging Summary (Arrears in Weeks) + +lable.title.group.Branch=Branch http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/df8ef2e8/fineract-provider/src/main/pentahoReports/Balance Outstanding.prpt ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/pentahoReports/Balance Outstanding.prpt b/fineract-provider/src/main/pentahoReports/Balance Outstanding.prpt new file mode 100644 index 0000000..9fdaf17 Binary files /dev/null and b/fineract-provider/src/main/pentahoReports/Balance Outstanding.prpt differ http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/df8ef2e8/fineract-provider/src/main/pentahoReports/Balance Sheet.prpt ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/pentahoReports/Balance Sheet.prpt b/fineract-provider/src/main/pentahoReports/Balance Sheet.prpt new file mode 100644 index 0000000..eb5ed86 Binary files /dev/null and b/fineract-provider/src/main/pentahoReports/Balance Sheet.prpt differ http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/df8ef2e8/fineract-provider/src/main/pentahoReports/Branch Expected Cash Flow.prpt ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/pentahoReports/Branch Expected Cash Flow.prpt b/fineract-provider/src/main/pentahoReports/Branch Expected Cash Flow.prpt new file mode 100644 index 0000000..113980a Binary files /dev/null and b/fineract-provider/src/main/pentahoReports/Branch Expected Cash Flow.prpt differ http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/df8ef2e8/fineract-provider/src/main/pentahoReports/Client Listing(Pentaho).prpt ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/pentahoReports/Client Listing(Pentaho).prpt b/fineract-provider/src/main/pentahoReports/Client Listing(Pentaho).prpt new file mode 100644 index 0000000..c091452 Binary files /dev/null and b/fineract-provider/src/main/pentahoReports/Client Listing(Pentaho).prpt differ http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/df8ef2e8/fineract-provider/src/main/pentahoReports/Client Listing.properties ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/pentahoReports/Client Listing.properties b/fineract-provider/src/main/pentahoReports/Client Listing.properties new file mode 100644 index 0000000..623a419 --- /dev/null +++ b/fineract-provider/src/main/pentahoReports/Client Listing.properties @@ -0,0 +1,10 @@ +label.column.ID=ID +label.column.Office/Branch=Office/Branch +label.column.Client.Account.No=Client Account No. +label.column.Name=Name +label.column.Status=Status +label.column.Activation=Activation +label.column.External.Id=External Id + +lable.title.Client.Listing=Client Listing +lable.title.group.Branch=Branch http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/df8ef2e8/fineract-provider/src/main/pentahoReports/Client Loan Account Schedule.prpt ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/pentahoReports/Client Loan Account Schedule.prpt b/fineract-provider/src/main/pentahoReports/Client Loan Account Schedule.prpt new file mode 100644 index 0000000..c57cb3d Binary files /dev/null and b/fineract-provider/src/main/pentahoReports/Client Loan Account Schedule.prpt differ http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/df8ef2e8/fineract-provider/src/main/pentahoReports/Client Loans Listing(Pentaho).prpt ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/pentahoReports/Client Loans Listing(Pentaho).prpt b/fineract-provider/src/main/pentahoReports/Client Loans Listing(Pentaho).prpt new file mode 100644 index 0000000..8f1d7bb Binary files /dev/null and b/fineract-provider/src/main/pentahoReports/Client Loans Listing(Pentaho).prpt differ http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/df8ef2e8/fineract-provider/src/main/pentahoReports/Client Saving Transactions.properties ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/pentahoReports/Client Saving Transactions.properties b/fineract-provider/src/main/pentahoReports/Client Saving Transactions.properties new file mode 100644 index 0000000..b981f9e --- /dev/null +++ b/fineract-provider/src/main/pentahoReports/Client Saving Transactions.properties @@ -0,0 +1,19 @@ +label.column.Transaction.ID=Transaction ID +label.column.Transaction.Date=Transaction Date +label.column.Transaction.Type=Transaction Type +label.column.Debit=Debit +label.column.Credit=Credit +label.column.Balance=Balance +label.column.Reversed=Reversed +lable.title.Saving.Transaction=Client Saving Transaction +lable.title.Transaction.from=From : +lable.title.Saving.Transaction.To= To : +lable.title.Client.Name=Client Name +lable.title.Savings.Account.Name/No=Account Name/No +lable.title.Branch=Branch +lable.title.Staff=Staff +lable.title.Interest=Interest Rate +lable.title.Balance=Balance +PrintedBy\:=Printed by: +On\:=On: + http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/df8ef2e8/fineract-provider/src/main/pentahoReports/Client Saving Transactions.prpt ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/pentahoReports/Client Saving Transactions.prpt b/fineract-provider/src/main/pentahoReports/Client Saving Transactions.prpt new file mode 100644 index 0000000..e88cd96 Binary files /dev/null and b/fineract-provider/src/main/pentahoReports/Client Saving Transactions.prpt differ http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/df8ef2e8/fineract-provider/src/main/pentahoReports/Client Saving Transactions_fr.properties ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/pentahoReports/Client Saving Transactions_fr.properties b/fineract-provider/src/main/pentahoReports/Client Saving Transactions_fr.properties new file mode 100644 index 0000000..e87c594 --- /dev/null +++ b/fineract-provider/src/main/pentahoReports/Client Saving Transactions_fr.properties @@ -0,0 +1,18 @@ +label.column.Transaction.ID=Transaction Id +label.column.Transaction.Date=Date de transaction +label.column.Transaction.Type=Type de transaction +label.column.Debit=Débit +label.column.Credit=Crédit +label.column.Balance=Solde +label.column.Reversed=Reversed +lable.title.Transaction.from=à partir de la date : +lable.title.Saving.Transaction.To= Jusquâà la date : +lable.title.Client.Name=Client Nom +lable.title.Savings.Account.Name/No=Account Name/No +lable.title.Branch=Branch +lable.title.Staff=Staff +lable.title.Interest=Interest Rate +lable.title.Balance=Balance +PrintedBy\:=Printed by: +On\:=On: + http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/df8ef2e8/fineract-provider/src/main/pentahoReports/Client Savings Summary.prpt ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/pentahoReports/Client Savings Summary.prpt b/fineract-provider/src/main/pentahoReports/Client Savings Summary.prpt new file mode 100644 index 0000000..79888b0 Binary files /dev/null and b/fineract-provider/src/main/pentahoReports/Client Savings Summary.prpt differ http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/df8ef2e8/fineract-provider/src/main/pentahoReports/Collection Report.prpt ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/pentahoReports/Collection Report.prpt b/fineract-provider/src/main/pentahoReports/Collection Report.prpt new file mode 100644 index 0000000..5e18785 Binary files /dev/null and b/fineract-provider/src/main/pentahoReports/Collection Report.prpt differ http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/df8ef2e8/fineract-provider/src/main/pentahoReports/CollectionReport.properties ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/pentahoReports/CollectionReport.properties b/fineract-provider/src/main/pentahoReports/CollectionReport.properties new file mode 100644 index 0000000..6f23eed --- /dev/null +++ b/fineract-provider/src/main/pentahoReports/CollectionReport.properties @@ -0,0 +1,20 @@ +collection.=Collection Report +receipt.=Receipt No +group.=Group Name +client.=Clients Name +loanAccNo.=Loan Account No +pricAmt.=Principal Amount +intAmt.=Interest Amount +totalAmt.=Total Receipt Amount +feeAmt.=Fees +penaltyAmt.=Penalty +others.=Others +mifos.=Mifos User +actdate.=Action Date +created.=Created Date +office.=Branch : +ondate.=From : +todate.=To : +PrintedBy\:=Printed by: +On\:=On: +center\:=Center : \ No newline at end of file http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/df8ef2e8/fineract-provider/src/main/pentahoReports/Disbursal Report.prpt ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/pentahoReports/Disbursal Report.prpt b/fineract-provider/src/main/pentahoReports/Disbursal Report.prpt new file mode 100644 index 0000000..d871826 Binary files /dev/null and b/fineract-provider/src/main/pentahoReports/Disbursal Report.prpt differ http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/df8ef2e8/fineract-provider/src/main/pentahoReports/DisbursalReport.properties ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/pentahoReports/DisbursalReport.properties b/fineract-provider/src/main/pentahoReports/DisbursalReport.properties new file mode 100644 index 0000000..df864a8 --- /dev/null +++ b/fineract-provider/src/main/pentahoReports/DisbursalReport.properties @@ -0,0 +1,23 @@ +disbursalReport=Disbursal Report +receiptNo=Receipt No: +phoneNo=Phone No: +accountId=Account ID: +clientGroup=Client/Group +loanAmount=Loan Amount +disbDate=Disbursed Date +loanType=Loan Type +loanOfficer=Loan Officer +PrintedBy\:=Printed By : +On\:=On : +center\:=Center : +centerName=Center Name +groupName=Group Name +disbursedAmount=Disbursed Amount +clientName=Client Name +serviceTax=Service Tax +annualSubscription=Annual Subscription +processingFees=Processing Fees +disbursedDate=Disbursed Date +createdDate=Created Date +mifosUser=Mifos User +fees=Fees \ No newline at end of file http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/df8ef2e8/fineract-provider/src/main/pentahoReports/Expected Payments By Date - Basic(Pentaho).prpt ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/pentahoReports/Expected Payments By Date - Basic(Pentaho).prpt b/fineract-provider/src/main/pentahoReports/Expected Payments By Date - Basic(Pentaho).prpt new file mode 100644 index 0000000..6366070 Binary files /dev/null and b/fineract-provider/src/main/pentahoReports/Expected Payments By Date - Basic(Pentaho).prpt differ http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/df8ef2e8/fineract-provider/src/main/pentahoReports/Expected Payments By Date - Basic.properties ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/pentahoReports/Expected Payments By Date - Basic.properties b/fineract-provider/src/main/pentahoReports/Expected Payments By Date - Basic.properties new file mode 100644 index 0000000..b5a620e --- /dev/null +++ b/fineract-provider/src/main/pentahoReports/Expected Payments By Date - Basic.properties @@ -0,0 +1,20 @@ + +label.column.Office=Office +label.column.Loan.Officer=Loan Officer +label.column.Client.Account.Number=Client Account Number +label.column.Name=Name +label.column.Product=Product +label.column.Loan.Account.Number=Loan Account Number +label.column.Due.Date=Due Date +label.column.Installment=Installment +label.column.Currency=Currency +label.column.Principal.Due=Principal Due +label.column.Interest.Due=Interest Due +label.column.Fees.Due=Fees Due +label.column.Penalty.Due=Penalty Due +label.column.Total.Due=Total Due +label.column.Total.Overdue=Total Overdue + + +lable.title.Expected.Payments.By.Date.Basic=Expected Payments By Date - Basic +lable.title.group.Branch=Branch http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/df8ef2e8/fineract-provider/src/main/pentahoReports/Expected Payments By Date - Formatted.prpt ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/pentahoReports/Expected Payments By Date - Formatted.prpt b/fineract-provider/src/main/pentahoReports/Expected Payments By Date - Formatted.prpt new file mode 100644 index 0000000..db0e39f Binary files /dev/null and b/fineract-provider/src/main/pentahoReports/Expected Payments By Date - Formatted.prpt differ http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/df8ef2e8/fineract-provider/src/main/pentahoReports/Funds Disbursed Between Dates Summary by Office(Pentaho).prpt ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/pentahoReports/Funds Disbursed Between Dates Summary by Office(Pentaho).prpt b/fineract-provider/src/main/pentahoReports/Funds Disbursed Between Dates Summary by Office(Pentaho).prpt new file mode 100644 index 0000000..ab66914 Binary files /dev/null and b/fineract-provider/src/main/pentahoReports/Funds Disbursed Between Dates Summary by Office(Pentaho).prpt differ http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/df8ef2e8/fineract-provider/src/main/pentahoReports/Funds Disbursed Between Dates Summary by Office.PROPERTIES ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/pentahoReports/Funds Disbursed Between Dates Summary by Office.PROPERTIES b/fineract-provider/src/main/pentahoReports/Funds Disbursed Between Dates Summary by Office.PROPERTIES new file mode 100644 index 0000000..d09905b --- /dev/null +++ b/fineract-provider/src/main/pentahoReports/Funds Disbursed Between Dates Summary by Office.PROPERTIES @@ -0,0 +1,8 @@ +label.column.Office/Branch=Office/Branch +label.column.Fund=Fund +label.column.Currency=Currency +label.column.Disbursed.amount=Disbursed_amount + + +lable.title.Funds.Disbursed.Between.Dates.Summary.by.Office=Funds Disbursed Between Dates Summary by Office + http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/df8ef2e8/fineract-provider/src/main/pentahoReports/Funds Disbursed Between Dates Summary(Pentaho).prpt ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/pentahoReports/Funds Disbursed Between Dates Summary(Pentaho).prpt b/fineract-provider/src/main/pentahoReports/Funds Disbursed Between Dates Summary(Pentaho).prpt new file mode 100644 index 0000000..976d05e Binary files /dev/null and b/fineract-provider/src/main/pentahoReports/Funds Disbursed Between Dates Summary(Pentaho).prpt differ http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/df8ef2e8/fineract-provider/src/main/pentahoReports/Funds Disbursed Between Dates Summary.PROPERTIES ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/pentahoReports/Funds Disbursed Between Dates Summary.PROPERTIES b/fineract-provider/src/main/pentahoReports/Funds Disbursed Between Dates Summary.PROPERTIES new file mode 100644 index 0000000..32d6fce --- /dev/null +++ b/fineract-provider/src/main/pentahoReports/Funds Disbursed Between Dates Summary.PROPERTIES @@ -0,0 +1,4 @@ +label.column.Fund=Fund +label.column.Currency=Currency +label.column.disbursed_amount=disbursed_amount +lable.title.Funds.Disbursed.Between.Dates.Summary=Funds Disbursed Between Dates Summary http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/df8ef2e8/fineract-provider/src/main/pentahoReports/GeneralLedgerReport.properties ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/pentahoReports/GeneralLedgerReport.properties b/fineract-provider/src/main/pentahoReports/GeneralLedgerReport.properties new file mode 100644 index 0000000..908b48f --- /dev/null +++ b/fineract-provider/src/main/pentahoReports/GeneralLedgerReport.properties @@ -0,0 +1,18 @@ +lable.detail.Vch_No_Unit=Vch No./Unit +lable.detail.AC.code=GL Code +lable.detail.Account_Description=Account Description +lable.detail.Narration=Description +lable.detail.Debits=Debits +lable.detail.Credits=Credits +lable.detail.Opening_Balance=BALANCE BROUGHT FORWARD (b/f) +lable.detail.Day_Total=Day Total +lable.detail.Closing_Balance=Closing Balance +lable.detail.date=Date +lable.detail.Cash_Book_From=Ledger Report From Date : +lable.detail.Run_Date=Run Date : +lable.detail.Cash_Code= Ledger Account : +lable.header=GENERAL LEDGER REPORT +lable.page=Page No +lable.detail.AfterTxn=Balance +lable.detail.office = Office : +lable.detail.todate = To Date : \ No newline at end of file http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/df8ef2e8/fineract-provider/src/main/pentahoReports/GeneralLedgerReport.prpt ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/pentahoReports/GeneralLedgerReport.prpt b/fineract-provider/src/main/pentahoReports/GeneralLedgerReport.prpt new file mode 100644 index 0000000..99287cc Binary files /dev/null and b/fineract-provider/src/main/pentahoReports/GeneralLedgerReport.prpt differ http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/df8ef2e8/fineract-provider/src/main/pentahoReports/Income Statement.prpt ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/pentahoReports/Income Statement.prpt b/fineract-provider/src/main/pentahoReports/Income Statement.prpt new file mode 100644 index 0000000..22f2e9b Binary files /dev/null and b/fineract-provider/src/main/pentahoReports/Income Statement.prpt differ http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/df8ef2e8/fineract-provider/src/main/pentahoReports/Loan Account Statement.properties ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/pentahoReports/Loan Account Statement.properties b/fineract-provider/src/main/pentahoReports/Loan Account Statement.properties new file mode 100644 index 0000000..e7113c8 --- /dev/null +++ b/fineract-provider/src/main/pentahoReports/Loan Account Statement.properties @@ -0,0 +1,20 @@ +Loan_Account_Statement.=Loan Account Statement +Date.=Date +type.=Type +disbur.=Disbursement +repayment.=Repayment +contra.=Contra +waiveint=WaiveInterest +repaydisbur=Repayment At Disburesement +writeoff.=Write-off +marked_resch.=Marked for Rescheduling +recover.=Recover Repayment +waive_cha.=Waive Charges +apply_char.=Apply charges +apply_int.=Apply Interest +description.=Description +amount.=Amount +principal.=Principal +interest.=Interest +recepit_no.=Recepit No +paymentype.=Payment Type \ No newline at end of file http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/df8ef2e8/fineract-provider/src/main/pentahoReports/Loan Account statement.prpt ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/pentahoReports/Loan Account statement.prpt b/fineract-provider/src/main/pentahoReports/Loan Account statement.prpt new file mode 100644 index 0000000..ed06b71 Binary files /dev/null and b/fineract-provider/src/main/pentahoReports/Loan Account statement.prpt differ http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/df8ef2e8/fineract-provider/src/main/pentahoReports/Loan Transaction Receipt.properties ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/pentahoReports/Loan Transaction Receipt.properties b/fineract-provider/src/main/pentahoReports/Loan Transaction Receipt.properties new file mode 100644 index 0000000..f55ed9a --- /dev/null +++ b/fineract-provider/src/main/pentahoReports/Loan Transaction Receipt.properties @@ -0,0 +1,42 @@ +title.Loan.Transaction.Receipt=Receipt +label.ClientName=Client Name: +label.ClientAccountNumber=Client Account Number: +label.ProductName=Client Account Title: +label.Operation=Operation: +label.Operation.Deposit=Deposit +label.Operation.Withdrawal=Withdrawal +label.Operation.Amount=Amount: +label.Operation.Amount.InFigures=In Figures: +label.Operation.Amount.InWords=In Words: +label.Operation.Description=Description: +label.receipt.text1=Your account has been +label.receipt.credited=credited +label.receipt.debited=debited +label.receipt.text2= with +label.receipt.text.dot=. +label.receipt.ClientName=Client Name and Signature +label.receipt.TxnDateTime=Date and Time of Transaction: +label.receipt.Operator=Cashier Name: +label.receipt.TxnID=Transaction ID: +txn_type.1=Disbursement +txn_type.2=Repayment +txn_type.3=Contra +txn_type.4=Waive Interest +txn_type.5=Repayment At Disbursement +txn_type.6=Write-Off +txn_type.7=Marked for Rescheduling +txn_type.8=Recovery Repayment +txn_type.9=Waive Charges +txn_type.10=Apply Charges +txn_type.11=Apply Interest +accounting_txn_type.1=debited +accounting_txn_type.2=credited +accounting_txn_type.3=contra-ed +accounting_txn_type.4=credited +accounting_txn_type.5=credited +accounting_txn_type.6=credited +accounting_txn_type.7=credited +accounting_txn_type.8=debited +accounting_txn_type.9=credited +accounting_txn_type.10=debitd +accounting_txn_type.11=debited \ No newline at end of file http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/df8ef2e8/fineract-provider/src/main/pentahoReports/Loan Transaction Receipt.prpt ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/pentahoReports/Loan Transaction Receipt.prpt b/fineract-provider/src/main/pentahoReports/Loan Transaction Receipt.prpt new file mode 100644 index 0000000..f4b6ad5 Binary files /dev/null and b/fineract-provider/src/main/pentahoReports/Loan Transaction Receipt.prpt differ http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/df8ef2e8/fineract-provider/src/main/pentahoReports/Loans Awaiting Disbursal Summary by Month(Pentaho).prpt ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/pentahoReports/Loans Awaiting Disbursal Summary by Month(Pentaho).prpt b/fineract-provider/src/main/pentahoReports/Loans Awaiting Disbursal Summary by Month(Pentaho).prpt new file mode 100644 index 0000000..dd7fbae Binary files /dev/null and b/fineract-provider/src/main/pentahoReports/Loans Awaiting Disbursal Summary by Month(Pentaho).prpt differ http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/df8ef2e8/fineract-provider/src/main/pentahoReports/Loans Awaiting Disbursal Summary by Month.properties ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/pentahoReports/Loans Awaiting Disbursal Summary by Month.properties b/fineract-provider/src/main/pentahoReports/Loans Awaiting Disbursal Summary by Month.properties new file mode 100644 index 0000000..5751fcf --- /dev/null +++ b/fineract-provider/src/main/pentahoReports/Loans Awaiting Disbursal Summary by Month.properties @@ -0,0 +1,12 @@ + +label.column.Office/Branch=Office/Branch +label.column.Product=Product +label.column.Currency=Currency + +label.column.Year=Year +label.column.Month=Month +label.column.Principal=Principal + +lable.title.Loans.Awaiting.Disbursal.Summary.by.Month=Loans Awaiting Disbursal Summary by Month +lable.Group.title.Branch=Branch + http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/df8ef2e8/fineract-provider/src/main/pentahoReports/Loans Awaiting Disbursal Summary(Pentaho).prpt ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/pentahoReports/Loans Awaiting Disbursal Summary(Pentaho).prpt b/fineract-provider/src/main/pentahoReports/Loans Awaiting Disbursal Summary(Pentaho).prpt new file mode 100644 index 0000000..0baa288 Binary files /dev/null and b/fineract-provider/src/main/pentahoReports/Loans Awaiting Disbursal Summary(Pentaho).prpt differ http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/df8ef2e8/fineract-provider/src/main/pentahoReports/Loans Awaiting Disbursal Summary.properties ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/pentahoReports/Loans Awaiting Disbursal Summary.properties b/fineract-provider/src/main/pentahoReports/Loans Awaiting Disbursal Summary.properties new file mode 100644 index 0000000..ddabb80 --- /dev/null +++ b/fineract-provider/src/main/pentahoReports/Loans Awaiting Disbursal Summary.properties @@ -0,0 +1,13 @@ +label.column.Office/Branch=Office/Branch +label.column.Product=Product +label.column.Currency=Currency +label.column.Fund=Fund +label.column.Principal=Principal +lable.title.Loans.Awaiting.Disbursal.Summary=Loans Awaiting Disbursal Summary +lable.Group.title.Branch=Branch + + + + + + http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/df8ef2e8/fineract-provider/src/main/pentahoReports/Loans Awaiting Disbursal(Pentaho).prpt ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/pentahoReports/Loans Awaiting Disbursal(Pentaho).prpt b/fineract-provider/src/main/pentahoReports/Loans Awaiting Disbursal(Pentaho).prpt new file mode 100644 index 0000000..353e8c2 Binary files /dev/null and b/fineract-provider/src/main/pentahoReports/Loans Awaiting Disbursal(Pentaho).prpt differ http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/df8ef2e8/fineract-provider/src/main/pentahoReports/Loans Awaiting Disbursal.properties ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/pentahoReports/Loans Awaiting Disbursal.properties b/fineract-provider/src/main/pentahoReports/Loans Awaiting Disbursal.properties new file mode 100644 index 0000000..915d7d6 --- /dev/null +++ b/fineract-provider/src/main/pentahoReports/Loans Awaiting Disbursal.properties @@ -0,0 +1,24 @@ +label.column.Office/Branch=Office/Branch +label.column.Client.Account.No=Client Account No +label.column.Name=Name +label.column.Loan.Account.No=Loan Account No. +label.column.Product=Product +label.column.Fund=Fund +label.column.Currency=Currency +label.column.Principal=Principal +label.column.Term.Frequency=Term Frequency +label.column.Term.Frequency.Period=Term Frequency Period +label.column.Annual.Nominal.Interest.Rate=Annual Nominal Interest Rate +label.column.Approved=Approved +label.column.Days.to.Disbursal=Days to Disbursal +label.column.Expected.Disbursal=Expected Disbursal +label.column.Loan.Purpose=Loan Purpose +label.column.Loan.Officer=Loan Officer +label.group.title.Branch.Name=Branch Name + + +lable.title.Loans.Awaiting.Disbursal=Loans Awaiting Disbursal + + + + http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/df8ef2e8/fineract-provider/src/main/pentahoReports/Loans Pending Approval(Pentaho).prpt ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/pentahoReports/Loans Pending Approval(Pentaho).prpt b/fineract-provider/src/main/pentahoReports/Loans Pending Approval(Pentaho).prpt new file mode 100644 index 0000000..b7a1329 Binary files /dev/null and b/fineract-provider/src/main/pentahoReports/Loans Pending Approval(Pentaho).prpt differ http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/df8ef2e8/fineract-provider/src/main/pentahoReports/Loans Pending Approval.properties ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/pentahoReports/Loans Pending Approval.properties b/fineract-provider/src/main/pentahoReports/Loans Pending Approval.properties new file mode 100644 index 0000000..bd9e6b4 --- /dev/null +++ b/fineract-provider/src/main/pentahoReports/Loans Pending Approval.properties @@ -0,0 +1,18 @@ +label.column.Branch/Office=Branch/Office +label.column.Client.Account.No=Client Account No. +label.column.Client.Name=Client Name +label.column.Currency=Currency +label.column.Product=Product +label.column.Loan.Account.No=Loan Account No. +label.column.Loan.Amount=Loan Amount +label.column.Term.Frequency=Term Frequency +label.column.Term.Frequency.Period=Term Frequency Period +label.column.Annual.Nominal.Interest.Rate=Annual Nominal Interest Rate +label.column.Days.Pending.Approval=Days Pending Approval +label.column.Loan.Purpose=Loan Purpose +label.column.Loan.Officer=Loan Officer + +label.group.title.Branch.Name=Branch Name + + +lable.title.Loans.Pending.Approval=Loans Pending Approval http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/df8ef2e8/fineract-provider/src/main/pentahoReports/Obligation Met Loans Details(Pentaho).prpt ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/pentahoReports/Obligation Met Loans Details(Pentaho).prpt b/fineract-provider/src/main/pentahoReports/Obligation Met Loans Details(Pentaho).prpt new file mode 100644 index 0000000..aec6f96 Binary files /dev/null and b/fineract-provider/src/main/pentahoReports/Obligation Met Loans Details(Pentaho).prpt differ http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/df8ef2e8/fineract-provider/src/main/pentahoReports/Obligation Met Loans Details.properties ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/pentahoReports/Obligation Met Loans Details.properties b/fineract-provider/src/main/pentahoReports/Obligation Met Loans Details.properties new file mode 100644 index 0000000..b3614e7 --- /dev/null +++ b/fineract-provider/src/main/pentahoReports/Obligation Met Loans Details.properties @@ -0,0 +1,22 @@ +label.column.Office/Branch=Office/Branch +label.column.Currency=Currency +label.column.Client.Account.No=Client Account No. +label.column.Client=Client +label.column.Loan.Account.No=Loan Account No. +label.column.Product=Product +label.column.Fund=Fund +label.column.Loan.Amount=Loan Amount +label.column.Total.Repaid=Total Repaid +label.column.Annual.Nominal.Interest.Rate=Annual Nominal Interest Rate +label.column.Disbursed=Disbursed +label.column.Closed=Closed +label.column.Principal.Repaid=Principal Repaid +label.column.Interest.Repaid=Interest Repaid +label.column.Fees.Repaid=Fees Repaid +label.column.Penalties.Repaid=Penalties Repaid +label.column.Loan.Officer=Loan Officer +label.group.title.Branch.Name=Branch Name + + +lable.title.Obligation.Met.Loans.Details=Obligation Met Loans Details + http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/df8ef2e8/fineract-provider/src/main/pentahoReports/Obligation Met Loans Summary(Pentaho).prpt ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/pentahoReports/Obligation Met Loans Summary(Pentaho).prpt b/fineract-provider/src/main/pentahoReports/Obligation Met Loans Summary(Pentaho).prpt new file mode 100644 index 0000000..3d22709 Binary files /dev/null and b/fineract-provider/src/main/pentahoReports/Obligation Met Loans Summary(Pentaho).prpt differ http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/df8ef2e8/fineract-provider/src/main/pentahoReports/Obligation Met Loans Summary.properties ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/pentahoReports/Obligation Met Loans Summary.properties b/fineract-provider/src/main/pentahoReports/Obligation Met Loans Summary.properties new file mode 100644 index 0000000..0243333 --- /dev/null +++ b/fineract-provider/src/main/pentahoReports/Obligation Met Loans Summary.properties @@ -0,0 +1,17 @@ +label.column.Office/Branch=Office/Branch +label.column.Currency=Currency +label.column.No.of.Clients=No. of Clients +label.column.Total.Loan.Amount=Total Loan Amount +label.column.Total.Principal.Repaid=Total Principal Repaid +label.column.Total.Interest.Repaid=Total Interest Repaid +label.column.Total.Fees.Repaid=Total Fees Repaid +label.column.Total.Penalties.Repaid=Total Penalties Repaid +label.column.Total.Interest.Waived=Total Interest Waived +label.column.Total.Fees.Waived=Total Fees Waived +label.column.Total.Penalties.Waived=Total Penalties Waived +label.group.title.Branch=Branch +label.column. + + +lable.title.Obligation.Met.Loans.Summary=Obligation Met Loans Summary + http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/df8ef2e8/fineract-provider/src/main/pentahoReports/Portfolio at Risk by Branch(Pentaho).prpt ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/pentahoReports/Portfolio at Risk by Branch(Pentaho).prpt b/fineract-provider/src/main/pentahoReports/Portfolio at Risk by Branch(Pentaho).prpt new file mode 100644 index 0000000..639e0fd Binary files /dev/null and b/fineract-provider/src/main/pentahoReports/Portfolio at Risk by Branch(Pentaho).prpt differ http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/df8ef2e8/fineract-provider/src/main/pentahoReports/Portfolio at Risk by Branch.properties ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/pentahoReports/Portfolio at Risk by Branch.properties b/fineract-provider/src/main/pentahoReports/Portfolio at Risk by Branch.properties new file mode 100644 index 0000000..f845130 --- /dev/null +++ b/fineract-provider/src/main/pentahoReports/Portfolio at Risk by Branch.properties @@ -0,0 +1,15 @@ +label.group.title.Branch=Branch +label.column.Office/Branch=Office/Branch +label.column.Currency=Currency +label.column.Principal.Outstanding=Principal Outstanding +label.column.Principal.Overdue=Principal Overdue +label.column.Interest.Outstanding=Interest Outstanding +label.column.Interest.Overdue=Interest Overdue +label.column.Fees.Outstanding=Fees Outstanding +label.column.Fees.Overdue=Fees Overdue +label.column.Penalties.Outstanding=Penalties Outstanding +label.column.Penalties.Overdue=Penalties Overdue + + + +lable.title.Portfolio.At.Risk.By.Branch=Portfolio At Risk By Branch http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/df8ef2e8/fineract-provider/src/main/pentahoReports/Portfolio at Risk(Pentaho).prpt ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/pentahoReports/Portfolio at Risk(Pentaho).prpt b/fineract-provider/src/main/pentahoReports/Portfolio at Risk(Pentaho).prpt new file mode 100644 index 0000000..7e68f7e Binary files /dev/null and b/fineract-provider/src/main/pentahoReports/Portfolio at Risk(Pentaho).prpt differ http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/df8ef2e8/fineract-provider/src/main/pentahoReports/Portfolio at Risk.properties ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/pentahoReports/Portfolio at Risk.properties b/fineract-provider/src/main/pentahoReports/Portfolio at Risk.properties new file mode 100644 index 0000000..653f768 --- /dev/null +++ b/fineract-provider/src/main/pentahoReports/Portfolio at Risk.properties @@ -0,0 +1,16 @@ +label.column.Currency=Currency +label.column.Principal.Outstanding=Principal Outstanding +label.column.Principal.Overdue=Principal Overdue +label.column.Interest.Outstanding=Interest Outstanding +label.column.Interest.Overdue=Interest Overdue +label.column.Fees.Outstanding=Fees Outstanding +label.column.Fees.Overdue=Fees Overdue +label.column.Penalties.Outstanding=Penalties Outstanding +label.column.Penalties.Overdue=Penalties Overdue +label.column.Portfolio.at.Risk.per=Portfolio at Risk % + +label.group.title.Branch=Branch +lable.title.Portfolio.at.Risk=Portfolio at Risk + + + http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/df8ef2e8/fineract-provider/src/main/pentahoReports/Rescheduled Loans(Pentaho).prpt ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/pentahoReports/Rescheduled Loans(Pentaho).prpt b/fineract-provider/src/main/pentahoReports/Rescheduled Loans(Pentaho).prpt new file mode 100644 index 0000000..424cdc8 Binary files /dev/null and b/fineract-provider/src/main/pentahoReports/Rescheduled Loans(Pentaho).prpt differ http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/df8ef2e8/fineract-provider/src/main/pentahoReports/Rescheduled Loans.properties ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/pentahoReports/Rescheduled Loans.properties b/fineract-provider/src/main/pentahoReports/Rescheduled Loans.properties new file mode 100644 index 0000000..28c3058 --- /dev/null +++ b/fineract-provider/src/main/pentahoReports/Rescheduled Loans.properties @@ -0,0 +1,17 @@ +label.column.Office/Branch=Office/Branch +label.column.Currency=Currency +label.column.Client.Account.No=Client Account No. +label.column.Client.Name=Client Name +label.column.Loan.AccountNo=Loan Account No. +label.column.Product.Name=Product Name +label.column.Disbursed.Date=Disbursed Date +label.column.Written.Off.date=Written Off date +label.column.Loan.Amount=Loan Amount +label.column.Rescheduled.Principal=Rescheduled Principal +label.column.Rescheduled.Interest=Rescheduled Interest +label.column.Rescheduled.Fees=Rescheduled Fees +label.column.Rescheduled.Penalties=Rescheduled Penalties +label.column.Reason.For.Rescheduling=Reason For Rescheduling +label.columnLoan.Officer.Name=Loan Officer Name +label.group.title.Branch=Branch +lable.title.Rescheduled.Loans=Rescheduled Loans http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/df8ef2e8/fineract-provider/src/main/pentahoReports/Saving Account Statement.properties ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/pentahoReports/Saving Account Statement.properties b/fineract-provider/src/main/pentahoReports/Saving Account Statement.properties new file mode 100644 index 0000000..24c4500 --- /dev/null +++ b/fineract-provider/src/main/pentahoReports/Saving Account Statement.properties @@ -0,0 +1,9 @@ +Saving_Account_Statement.=Saving Account Statement +date.=Date +transaction_type=Transaction type +receipt_number=Receipt no +Description.=Description +Credited.=Credited +Debited.=Debited +Balance.=Balance +transaction.=Patment Type \ No newline at end of file http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/df8ef2e8/fineract-provider/src/main/pentahoReports/Saving Account Statement.prpt ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/pentahoReports/Saving Account Statement.prpt b/fineract-provider/src/main/pentahoReports/Saving Account Statement.prpt new file mode 100644 index 0000000..4b42b84 Binary files /dev/null and b/fineract-provider/src/main/pentahoReports/Saving Account Statement.prpt differ http://git-wip-us.apache.org/repos/asf/incubator-fineract/blob/df8ef2e8/fineract-provider/src/main/pentahoReports/Saving Transaction.properties ---------------------------------------------------------------------- diff --git a/fineract-provider/src/main/pentahoReports/Saving Transaction.properties b/fineract-provider/src/main/pentahoReports/Saving Transaction.properties new file mode 100644 index 0000000..c4b5451 --- /dev/null +++ b/fineract-provider/src/main/pentahoReports/Saving Transaction.properties @@ -0,0 +1,14 @@ +label.column.Transaction.ID=Transaction ID +label.column.Transaction.Date=Transaction Date +label.column.Transaction.Type=Transaction Type +label.column.Debit=Debit +label.column.Credit=Credit +label.column.Balance=Balance +label.column.Reversed=Reversed +lable.title.Saving.Transaction=Client Saving Transaction +lable.title.Transaction.from=Transaction From : +lable.title.Saving.Transaction.To= To : +lable.title.Client.Name=Client Name : +lable.title.Savings.Account.Name/No=Account Name/No. : +lable.title. +
