X-Git-Url: https://vcs.fsf.org/?a=blobdiff_plain;f=CRM%2FReport%2FForm%2FContribute%2FRepeat.php;h=7d07560621757db94cc3e8b70a436d6eab47160a;hb=276ee0a0d34630e77fab855111697bc46b20222b;hp=99918334d68f88e5dd8fbc424fcda55cd2a7349d;hpb=3beb999f86bc826d2b0b4f778aa32b3d1d0bc791;p=civicrm-core.git diff --git a/CRM/Report/Form/Contribute/Repeat.php b/CRM/Report/Form/Contribute/Repeat.php index 99918334d6..7d07560621 100644 --- a/CRM/Report/Form/Contribute/Repeat.php +++ b/CRM/Report/Form/Contribute/Repeat.php @@ -149,9 +149,7 @@ class CRM_Report_Form_Contribute_Repeat extends CRM_Report_Form { 'type' => CRM_Utils_Type::T_MONEY, 'default' => TRUE, 'required' => TRUE, - 'clause' => ' -contribution_civireport1.total_amount_count as contribution1_total_amount_count, -contribution_civireport1.total_amount_sum as contribution1_total_amount_sum', + 'clause' => 'contribution_civireport1.total_amount_count as contribution1_total_amount_count, contribution_civireport1.total_amount_sum as contribution1_total_amount_sum', ), 'total_amount2' => array( 'name' => 'total_amount', @@ -160,9 +158,7 @@ contribution_civireport1.total_amount_sum as contribution1_total_amount_sum', 'type' => CRM_Utils_Type::T_MONEY, 'default' => TRUE, 'required' => TRUE, - 'clause' => ' -contribution_civireport2.total_amount_count as contribution2_total_amount_count, -contribution_civireport2.total_amount_sum as contribution2_total_amount_sum', + 'clause' => 'contribution_civireport2.total_amount_count as contribution2_total_amount_count, contribution_civireport2.total_amount_sum as contribution2_total_amount_sum', ), ), 'grouping' => 'contri-fields', @@ -397,8 +393,8 @@ LEFT JOIN civicrm_temp_civireport_repeat2 {$this->_aliases['civicrm_contribution public function where() { if (!$this->_amountClauseWithAND) { - $this->_amountClauseWithAND = - "!({$this->_aliases['civicrm_contribution']}1.total_amount_count IS NULL AND {$this->_aliases['civicrm_contribution']}2.total_amount_count IS NULL)"; + $this->_amountClauseWithAND + = "!({$this->_aliases['civicrm_contribution']}1.total_amount_count IS NULL AND {$this->_aliases['civicrm_contribution']}2.total_amount_count IS NULL)"; } $clauses = array("atleast_one_amount" => $this->_amountClauseWithAND); @@ -617,8 +613,8 @@ LEFT JOIN civicrm_temp_civireport_repeat2 //store contributions in array 'contact_sums' for comparison $contact_sums = array(); while ($dao->fetch()) { - $contact_sums[$dao->contact_id] = - array( + $contact_sums[$dao->contact_id] + = array( 'contribution1_total_amount_sum' => $dao->contribution1_total_amount_sum, 'contribution2_total_amount_sum' => $dao->contribution2_total_amount_sum, ); @@ -701,16 +697,16 @@ GROUP BY currency $count = $count2 = 0; while ($dao->fetch()) { if ($dao->amount) { - $amount[] = - CRM_Utils_Money::format($dao->amount, $dao->currency) . "(" . + $amount[] + = CRM_Utils_Money::format($dao->amount, $dao->currency) . "(" . $dao->count . ")"; $average[] = CRM_Utils_Money::format($dao->avg, $dao->currency); } $count += $dao->count; if ($dao->amount2) { - $amount2[] = - CRM_Utils_Money::format($dao->amount2, $dao->currency) . "(" . + $amount2[] + = CRM_Utils_Money::format($dao->amount2, $dao->currency) . "(" . $dao->count . ")"; $average2[] = CRM_Utils_Money::format($dao->avg2, $dao->currency); } @@ -853,13 +849,13 @@ currency varchar(3) $rows[$uid]['change'] = ts('New Donor'); } if ($row['contribution1_total_amount_count']) { - $rows[$uid]['contribution1_total_amount_sum'] = - $row['contribution1_total_amount_sum'] . + $rows[$uid]['contribution1_total_amount_sum'] + = $row['contribution1_total_amount_sum'] . " ({$row['contribution1_total_amount_count']})"; } if ($row['contribution2_total_amount_count']) { - $rows[$uid]['contribution2_total_amount_sum'] = - $row['contribution2_total_amount_sum'] . + $rows[$uid]['contribution2_total_amount_sum'] + = $row['contribution2_total_amount_sum'] . " ({$row['contribution2_total_amount_count']})"; } }