X-Git-Url: https://vcs.fsf.org/?a=blobdiff_plain;f=CRM%2FReport%2FForm%2FContribute%2FLybunt.php;h=1fa3a79327deec7a098b52e5b62a7e0d41f5058a;hb=276ee0a0d34630e77fab855111697bc46b20222b;hp=5b18ae58abe92d32fd8fceee0f263ae024bce3fa;hpb=e44431fee3e48e503e8500ace6206f2d25c8956f;p=civicrm-core.git diff --git a/CRM/Report/Form/Contribute/Lybunt.php b/CRM/Report/Form/Contribute/Lybunt.php index 5b18ae58ab..1fa3a79327 100644 --- a/CRM/Report/Form/Contribute/Lybunt.php +++ b/CRM/Report/Form/Contribute/Lybunt.php @@ -1,7 +1,7 @@ _columns = array( - 'civicrm_contact' => array( - 'dao' => 'CRM_Contact_DAO_Contact', - 'grouping' => 'contact-field', - 'fields' => array( - 'sort_name' => array( - 'title' => ts('Donor Name'), - 'default' => TRUE, - 'required' => TRUE, - ), - 'first_name' => array( - 'title' => ts('First Name'), - ), - 'last_name' => array( - 'title' => ts('Last Name'), - ), - 'contact_type' => array( - 'title' => ts('Contact Type'), - ), - 'contact_sub_type' => array( - 'title' => ts('Contact Subtype'), - ), + 'civicrm_contact' => array( + 'dao' => 'CRM_Contact_DAO_Contact', + 'grouping' => 'contact-field', + 'fields' => array( + 'sort_name' => array( + 'title' => ts('Donor Name'), + 'default' => TRUE, + 'required' => TRUE, + ), + 'first_name' => array( + 'title' => ts('First Name'), + ), + 'last_name' => array( + 'title' => ts('Last Name'), + ), + 'contact_type' => array( + 'title' => ts('Contact Type'), ), - 'filters' => array( - 'sort_name' => array( - 'title' => ts('Donor Name'), - 'operator' => 'like', - ), + 'contact_sub_type' => array( + 'title' => ts('Contact Subtype'), ), ), - 'civicrm_email' => array( - 'dao' => 'CRM_Core_DAO_Email', - 'grouping' => 'contact-field', - 'fields' => array( - 'email' => array( - 'title' => ts('Email'), - 'default' => TRUE, - ), + 'filters' => array( + 'sort_name' => array( + 'title' => ts('Donor Name'), + 'operator' => 'like', ), ), - 'civicrm_phone' => array( - 'dao' => 'CRM_Core_DAO_Phone', - 'grouping' => 'contact-field', - 'fields' => array( - 'phone' => array( - 'title' => ts('Phone'), - 'default' => TRUE, - ), + ), + 'civicrm_email' => array( + 'dao' => 'CRM_Core_DAO_Email', + 'grouping' => 'contact-field', + 'fields' => array( + 'email' => array( + 'title' => ts('Email'), + 'default' => TRUE, ), ), - ) - + $this->addAddressFields() - + array( - 'civicrm_contribution' => array( - 'dao' => 'CRM_Contribute_DAO_Contribution', - 'fields' => array( - 'contact_id' => array( - 'title' => ts('contactId'), - 'no_display' => TRUE, - 'required' => TRUE, - 'no_repeat' => TRUE, - ), - 'total_amount' => array( - 'title' => ts('Total Amount'), - 'no_display' => TRUE, - 'required' => TRUE, - 'no_repeat' => TRUE, - ), - 'receive_date' => array( - 'title' => ts('Year'), - 'no_display' => TRUE, - 'required' => TRUE, - 'no_repeat' => TRUE, - ), + ), + 'civicrm_phone' => array( + 'dao' => 'CRM_Core_DAO_Phone', + 'grouping' => 'contact-field', + 'fields' => array( + 'phone' => array( + 'title' => ts('Phone'), + 'default' => TRUE, + ), + ), + ), + ); + $this->_columns += $this->addAddressFields(); + $this->_columns += array( + 'civicrm_contribution' => array( + 'dao' => 'CRM_Contribute_DAO_Contribution', + 'fields' => array( + 'contact_id' => array( + 'title' => ts('contactId'), + 'no_display' => TRUE, + 'required' => TRUE, + 'no_repeat' => TRUE, + ), + 'total_amount' => array( + 'title' => ts('Total Amount'), + 'no_display' => TRUE, + 'required' => TRUE, + 'no_repeat' => TRUE, ), - 'filters' => array( - 'yid' => array( - 'name' => 'receive_date', - 'title' => ts('This Year'), - 'operatorType' => CRM_Report_Form::OP_SELECT, - 'options' => $optionYear, - 'default' => date('Y'), - ), - 'financial_type_id' => array( - 'title' => ts('Financial Type'), - 'operatorType' => CRM_Report_Form::OP_MULTISELECT, - 'options' => CRM_Contribute_PseudoConstant::financialType(), - ), - 'contribution_status_id' => array( - 'title' => ts('Contribution Status'), - 'operatorType' => CRM_Report_Form::OP_MULTISELECT, - 'options' => CRM_Contribute_PseudoConstant::contributionStatus(), - 'default' => array('1'), - ), + 'receive_date' => array( + 'title' => ts('Year'), + 'no_display' => TRUE, + 'required' => TRUE, + 'no_repeat' => TRUE, ), ), - ); + 'filters' => array( + 'yid' => array( + 'name' => 'receive_date', + 'title' => ts('This Year'), + 'operatorType' => CRM_Report_Form::OP_SELECT, + 'options' => $optionYear, + 'default' => date('Y'), + ), + 'financial_type_id' => array( + 'title' => ts('Financial Type'), + 'operatorType' => CRM_Report_Form::OP_MULTISELECT, + 'options' => CRM_Contribute_PseudoConstant::financialType(), + ), + 'contribution_status_id' => array( + 'title' => ts('Contribution Status'), + 'operatorType' => CRM_Report_Form::OP_MULTISELECT, + 'options' => CRM_Contribute_PseudoConstant::contributionStatus(), + 'default' => array('1'), + ), + ), + ), + ); // If we have a campaign, build out the relevant elements if ($campaignEnabled && !empty($this->activeCampaigns)) { @@ -187,17 +185,16 @@ class CRM_Report_Form_Contribute_Lybunt extends CRM_Report_Form { parent::__construct(); } - function preProcess() { + public function preProcess() { parent::preProcess(); } - function select() { + public function select() { $this->_columnHeaders = $select = array(); $current_year = $this->_params['yid_value']; $previous_year = $current_year - 1; - foreach ($this->_columns as $tableName => $table) { if (array_key_exists('fields', $table)) { @@ -236,7 +233,7 @@ class CRM_Report_Form_Contribute_Lybunt extends CRM_Report_Form { $this->_select = "SELECT " . implode(', ', $select) . " "; } - function from() { + public function from() { $this->_from = " FROM civicrm_contribution {$this->_aliases['civicrm_contribution']} @@ -259,7 +256,7 @@ class CRM_Report_Form_Contribute_Lybunt extends CRM_Report_Form { $this->addAddressFromClause(); } - function where() { + public function where() { $this->_statusClause = ""; $clauses = array($this->_aliases['civicrm_contribution'] . '.is_test = 0'); $current_year = $this->_params['yid_value']; @@ -277,8 +274,7 @@ class CRM_Report_Form_Contribute_Lybunt extends CRM_Report_Form { WHERE " . self::fiscalYearOffset('contri.receive_date') . " = $previous_year AND contri.is_test = 0)"; } - elseif (CRM_Utils_Array::value('type', $field) & - CRM_Utils_Type::T_DATE + elseif (CRM_Utils_Array::value('type', $field) & CRM_Utils_Type::T_DATE ) { $relative = CRM_Utils_Array::value("{$fieldName}_relative", $this->_params); $from = CRM_Utils_Array::value("{$fieldName}_from", $this->_params); @@ -319,9 +315,8 @@ class CRM_Report_Form_Contribute_Lybunt extends CRM_Report_Form { } } - function groupBy() { - $this->_groupBy = - "GROUP BY {$this->_aliases['civicrm_contribution']}.contact_id, " . + public function groupBy() { + $this->_groupBy = "GROUP BY {$this->_aliases['civicrm_contribution']}.contact_id, " . self::fiscalYearOffset($this->_aliases['civicrm_contribution'] . '.receive_date') . " WITH ROLLUP"; $this->assign('chartSupported', TRUE); @@ -332,7 +327,7 @@ class CRM_Report_Form_Contribute_Lybunt extends CRM_Report_Form { * * @return array */ - function statistics(&$rows) { + public function statistics(&$rows) { $statistics = parent::statistics($rows); if (!empty($rows)) { $select = " @@ -353,7 +348,7 @@ class CRM_Report_Form_Contribute_Lybunt extends CRM_Report_Form { return $statistics; } - function postProcess() { + public function postProcess() { // get ready with post process params $this->beginPostProcess(); @@ -384,8 +379,7 @@ class CRM_Report_Form_Contribute_Lybunt extends CRM_Report_Form { $sql = "{$this->_select} {$this->_from} {$this->_where} {$this->_groupBy}"; } else { - $sql = - "{$this->_select} {$this->_from} WHERE {$this->_aliases['civicrm_contact']}.id IN (" . + $sql = "{$this->_select} {$this->_from} WHERE {$this->_aliases['civicrm_contact']}.id IN (" . implode(',', $contactIds) . ") AND {$this->_aliases['civicrm_contribution']}.is_test = 0 {$this->_statusClause} {$this->_groupBy} "; } @@ -431,7 +425,7 @@ class CRM_Report_Form_Contribute_Lybunt extends CRM_Report_Form { /** * @param $rows */ - function buildChart(&$rows) { + public function buildChart(&$rows) { $graphRows = array(); $count = 0; @@ -445,8 +439,7 @@ class CRM_Report_Form_Contribute_Lybunt extends CRM_Report_Form { foreach ($rows as $key => $row) { $display['life_time'] = CRM_Utils_Array::value('life_time', $display) + $row['civicrm_life_time_total']; - $display[$previous_year] = - CRM_Utils_Array::value($previous_year, $display) + $row[$previous_year]; + $display[$previous_year] = CRM_Utils_Array::value($previous_year, $display) + $row[$previous_year]; } $config = CRM_Core_Config::Singleton(); @@ -466,7 +459,7 @@ class CRM_Report_Form_Contribute_Lybunt extends CRM_Report_Form { /** * @param $rows */ - function alterDisplay(&$rows) { + public function alterDisplay(&$rows) { // custom code to alter rows $entryFound = FALSE; @@ -503,21 +496,20 @@ class CRM_Report_Form_Contribute_Lybunt extends CRM_Report_Form { } } - // Override "This Year" $op options /** + * Override "This Year" $op options * @param string $type * @param null $fieldName * * @return array */ - function getOperationPair($type = "string", $fieldName = NULL) { + public function getOperationPair($type = "string", $fieldName = NULL) { if ($fieldName == 'yid') { return array( 'calendar' => ts('Is Calendar Year'), - 'fiscal' => ts('Fiscal Year Starting') + 'fiscal' => ts('Fiscal Year Starting'), ); } return parent::getOperationPair($type, $fieldName); } } -