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 ";

        Attachments

          Activity

            People

            • Assignee:
              deepak Deepak Srivastava
              Reporter:
              ldugger leslie dugger
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: