From 520ec40373c082eefe00d6a6f2c08bf62cd70323 Mon Sep 17 00:00:00 2001 From: Pratik Joshi Date: Mon, 30 Dec 2013 12:52:28 +0530 Subject: [PATCH] CRM-13964 : minor query fix in bao function for fetching balance amount --- CRM/Core/BAO/FinancialTrxn.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/CRM/Core/BAO/FinancialTrxn.php b/CRM/Core/BAO/FinancialTrxn.php index 3093a09985..9322d0ea74 100644 --- a/CRM/Core/BAO/FinancialTrxn.php +++ b/CRM/Core/BAO/FinancialTrxn.php @@ -86,7 +86,7 @@ class CRM_Core_BAO_FinancialTrxn extends CRM_Financial_DAO_FinancialTrxn { static function getBalanceTrxnAmt($contributionId, $contributionFinancialTypeId) { $relationTypeId = key(CRM_Core_PseudoConstant::accountOptionValues('account_relationship', NULL, " AND v.name LIKE 'Accounts Receivable Account is' ")); $toFinancialAccount = CRM_Contribute_PseudoConstant::financialAccountType($contributionFinancialTypeId, $relationTypeId); - $q = "SELECT ft.id, ft.total_amount FROM civicrm_financial_trxn ft LEFT JOIN civicrm_entity_financial_trxn eft ON (eft.financial_trxn_id = ft.id AND eft.entity_table = 'civicrm_contribution' AND eft.entity_id = %1) WHERE ft.to_financial_account_id = %2 "; + $q = "SELECT ft.id, ft.total_amount FROM civicrm_financial_trxn ft INNER JOIN civicrm_entity_financial_trxn eft ON (eft.financial_trxn_id = ft.id AND eft.entity_table = 'civicrm_contribution') WHERE eft.entity_id = %1 AND ft.to_financial_account_id = %2"; $p[1] = array($contributionId, 'Integer'); $p[2] = array($toFinancialAccount, 'Integer'); $balanceAmtDAO = CRM_Core_DAO::executeQuery($q, $p); -- 2.25.1