Details
-
Type: Patch
-
Status: Done/Fixed
-
Priority: Trivial
-
Resolution: Fixed/Completed
-
Affects Version/s: 4.2.5, 4.2.6, 4.2.7
-
Fix Version/s: 4.2.8
-
Component/s: CiviReport
-
Labels:None
Description
The soft Credit Report is grouping people incorrectly. I altered 3 lines on the softcredit.php report file to fix the issue.
Was previously grouping constituents in ABC order without regard to connected soft creditor. Below is the part of file that needed to be altered. I had to switch the word creditor for constituent and vice versa in the grouping and the ordering.
LINES 357, 358
LINE 365
function groupBy() {
$alias_constituent = 'constituentname';
$alias_creditor = 'contact_civireport';
$this->_groupBy = "GROUP BY {$this->_aliases['civicrm_contribution_soft']}.contact_id,
{$alias_creditor}.id,
{$alias_constituent}.display_name";
}
function orderBy() {
$alias_constituent = 'constituentname';
$alias_creditor = 'contact_civireport';
$this->_orderBy = "ORDER BY {$alias_creditor}.sort_name, {$this->_aliases['civicrm_contribution_soft']}.contact_id,
{$alias_constituent}.sort_name, {$alias_creditor}.id ";