From 98e0cf827c5184f29ce580948aefa74c067cde9d Mon Sep 17 00:00:00 2001 From: francescbassas Date: Thu, 21 Feb 2019 23:33:32 +0100 Subject: [PATCH] /dev/core#716 - Add decimals in Contribution Amount on Repeat Contributions Report --- CRM/Report/Form/Contribute/Repeat.php | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/CRM/Report/Form/Contribute/Repeat.php b/CRM/Report/Form/Contribute/Repeat.php index 8fc1786ae9..e9f0d41821 100644 --- a/CRM/Report/Form/Contribute/Repeat.php +++ b/CRM/Report/Form/Contribute/Repeat.php @@ -1035,7 +1035,7 @@ GROUP BY contribution2.{$this->contributionJoinTableColumn}, currency"; CREATE TEMPORARY TABLE $this->tempTableRepeat1 ( {$create} {$this->contributionJoinTableColumn} int unsigned, -total_amount_sum int, +total_amount_sum decimal(20,2), total_amount_count int ) ENGINE=HEAP {$this->_databaseAttributes}"; $this->executeReportQuery($sql); @@ -1050,7 +1050,7 @@ total_amount_count int CREATE TEMPORARY TABLE $this->tempTableRepeat2 ( {$create} {$this->contributionJoinTableColumn} int unsigned, -total_amount_sum int, +total_amount_sum decimal(20,2), total_amount_count int, currency varchar(3) ) ENGINE=HEAP {$this->_databaseAttributes}"; -- 2.25.1