You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@fineract.apache.org by ar...@apache.org on 2022/08/04 12:24:06 UTC
[fineract] 01/02: Fix floating rate and floating rate period native queries
This is an automated email from the ASF dual-hosted git repository.
arnold pushed a commit to branch develop
in repository https://gitbox.apache.org/repos/asf/fineract.git
commit 69083de9498749fb3eb96439473751cacc4d473c
Author: Adam Saghy <ad...@gmail.com>
AuthorDate: Wed Aug 3 18:33:32 2022 +0200
Fix floating rate and floating rate period native queries
---
.../service/FloatingRatesReadPlatformServiceImpl.java | 12 ++++++------
1 file changed, 6 insertions(+), 6 deletions(-)
diff --git a/fineract-provider/src/main/java/org/apache/fineract/portfolio/floatingrates/service/FloatingRatesReadPlatformServiceImpl.java b/fineract-provider/src/main/java/org/apache/fineract/portfolio/floatingrates/service/FloatingRatesReadPlatformServiceImpl.java
index 9d8bcea3a..3fb1af249 100644
--- a/fineract-provider/src/main/java/org/apache/fineract/portfolio/floatingrates/service/FloatingRatesReadPlatformServiceImpl.java
+++ b/fineract-provider/src/main/java/org/apache/fineract/portfolio/floatingrates/service/FloatingRatesReadPlatformServiceImpl.java
@@ -110,8 +110,8 @@ public class FloatingRatesReadPlatformServiceImpl implements FloatingRatesReadPl
.append("crappu.username as createdBy, ").append("rate.created_date as createdOn, ")
.append("rate.created_on_utc as createdOnUTC, ").append("moappu.username as modifiedBy, ")
.append("rate.lastmodified_date as modifiedOn, ").append("rate.last_modified_on_utc as modifiedOnUTC ")
- .append("FROM m_floating_rates as rate ").append("LEFT JOIN m_appuser as crappu on rate.createdby_id = crappu.id ")
- .append("LEFT JOIN m_appuser as moappu on rate.lastmodifiedby_id = moappu.id ");
+ .append("FROM m_floating_rates as rate ").append("LEFT JOIN m_appuser as crappu on rate.created_by = crappu.id ")
+ .append("LEFT JOIN m_appuser as moappu on rate.last_modified_by = moappu.id ");
FloatingRateRowMapper(final boolean addRatePeriods) {
this.addRatePeriods = addRatePeriods;
@@ -155,11 +155,11 @@ public class FloatingRatesReadPlatformServiceImpl implements FloatingRatesReadPl
.append("period.interest_rate as interestRate, ")
.append("period.is_differential_to_base_lending_rate as isDifferentialToBaseLendingRate, ")
.append("period.is_active as isActive, ").append("crappu.username as createdBy, ")
- .append("period.created_date as createdOn, ").append("rate.created_on_utc as createdOnUTC, ")
+ .append("period.created_date as createdOn, ").append("period.created_on_utc as createdOnUTC, ")
.append("moappu.username as modifiedBy, ").append("period.lastmodified_date as modifiedOn, ")
- .append("rate.last_modified_on_utc as modifiedOnUTC ").append("FROM m_floating_rates_periods as period ")
- .append("LEFT JOIN m_appuser as crappu on period.createdby_id = crappu.id ")
- .append("LEFT JOIN m_appuser as moappu on period.lastmodifiedby_id = moappu.id ");
+ .append("period.last_modified_on_utc as modifiedOnUTC ").append("FROM m_floating_rates_periods as period ")
+ .append("LEFT JOIN m_appuser as crappu on period.created_by = crappu.id ")
+ .append("LEFT JOIN m_appuser as moappu on period.last_modified_by = moappu.id ");
@Override
public FloatingRatePeriodData mapRow(final ResultSet rs, @SuppressWarnings("unused") final int rowNum) throws SQLException {