3 +--------------------------------------------------------------------+
4 | CiviCRM version 4.7 |
5 +--------------------------------------------------------------------+
6 | Copyright CiviCRM LLC (c) 2004-2016 |
7 +--------------------------------------------------------------------+
8 | This file is a part of CiviCRM. |
10 | CiviCRM is free software; you can copy, modify, and distribute it |
11 | under the terms of the GNU Affero General Public License |
12 | Version 3, 19 November 2007 and the CiviCRM Licensing Exception. |
14 | CiviCRM is distributed in the hope that it will be useful, but |
15 | WITHOUT ANY WARRANTY; without even the implied warranty of |
16 | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. |
17 | See the GNU Affero General Public License for more details. |
19 | You should have received a copy of the GNU Affero General Public |
20 | License and the CiviCRM Licensing Exception along |
21 | with this program; if not, contact CiviCRM LLC |
22 | at info[AT]civicrm[DOT]org. If you have questions about the |
23 | GNU Affero General Public License or the licensing of CiviCRM, |
24 | see the CiviCRM license FAQ at http://civicrm.org/licensing |
25 +--------------------------------------------------------------------+
31 * @copyright CiviCRM LLC (c) 2004-2016
35 class CRM_Report_Form_Member_ContributionDetail
extends CRM_Report_Form
{
36 protected $_addressField = FALSE;
38 protected $_emailField = FALSE;
40 protected $_summary = NULL;
41 protected $_allBatches = NULL;
43 protected $_customGroupExtends = array(
52 public function __construct() {
53 $config = CRM_Core_Config
::singleton();
54 $campaignEnabled = in_array('CiviCampaign', $config->enableComponents
);
55 if ($campaignEnabled) {
56 $getCampaigns = CRM_Campaign_BAO_Campaign
::getPermissionedCampaigns(NULL, NULL, TRUE, FALSE, TRUE);
57 $this->activeCampaigns
= $getCampaigns['campaigns'];
58 asort($this->activeCampaigns
);
60 $this->_columns
= array(
61 'civicrm_contact' => array(
62 'dao' => 'CRM_Contact_DAO_Contact',
65 'title' => ts('Donor Name'),
69 'first_name' => array(
70 'title' => ts('First Name'),
74 'title' => ts('Last Name'),
77 'contact_type' => array(
78 'title' => ts('Contact Type'),
81 'contact_sub_type' => array(
82 'title' => ts('Contact Subtype'),
85 'do_not_email' => array(
86 'title' => ts('Do Not Email'),
89 'is_opt_out' => array(
90 'title' => ts('No Bulk Email(Is Opt Out)'),
96 'csv_display' => TRUE,
97 'title' => ts('Contact ID'),
101 'sort_name' => array(
102 'title' => ts('Donor Name'),
103 'operator' => 'like',
106 'title' => ts('Contact ID'),
107 'no_display' => TRUE,
110 'grouping' => 'contact-fields',
112 'civicrm_email' => array(
113 'dao' => 'CRM_Core_DAO_Email',
116 'title' => ts('Donor Email'),
121 'grouping' => 'contact-fields',
123 'civicrm_phone' => array(
124 'dao' => 'CRM_Core_DAO_Phone',
127 'title' => ts('Donor Phone'),
132 'grouping' => 'contact-fields',
134 'first_donation' => array(
135 'dao' => 'CRM_Contribute_DAO_Contribution',
137 'first_donation_date' => array(
138 'title' => ts('First Contribution Date'),
139 'base_field' => 'receive_date',
142 'first_donation_amount' => array(
143 'title' => ts('First Contribution Amount'),
144 'base_field' => 'total_amount',
149 'civicrm_contribution' => array(
150 'dao' => 'CRM_Contribute_DAO_Contribution',
152 'contribution_id' => array(
154 'no_display' => TRUE,
156 'csv_display' => TRUE,
157 'title' => ts('Contribution ID'),
159 'financial_type_id' => array(
160 'title' => ts('Financial Type'),
163 'contribution_recur_id' => array(
164 'title' => ts('Recurring Contribution Id'),
165 'name' => 'contribution_recur_id',
167 'no_display' => TRUE,
168 'csv_display' => TRUE,
170 'contribution_status_id' => array(
171 'title' => ts('Contribution Status'),
173 'payment_instrument_id' => array(
174 'title' => ts('Payment Type'),
176 'contribution_source' => array(
178 'title' => ts('Contribution Source'),
182 'no_display' => TRUE,
185 'receive_date' => array('default' => TRUE),
186 'receipt_date' => NULL,
187 'fee_amount' => NULL,
188 'net_amount' => NULL,
189 'total_amount' => array(
190 'title' => ts('Amount'),
195 'receive_date' => array('operatorType' => CRM_Report_Form
::OP_DATE
),
196 'financial_type_id' => array(
197 'title' => ts('Financial Type'),
198 'type' => CRM_Utils_Type
::T_INT
,
199 'operatorType' => CRM_Report_Form
::OP_MULTISELECT
,
200 'options' => CRM_Contribute_PseudoConstant
::financialType(),
203 'title' => 'Currency',
204 'operatorType' => CRM_Report_Form
::OP_MULTISELECT
,
205 'options' => CRM_Core_OptionGroup
::values('currencies_enabled'),
207 'type' => CRM_Utils_Type
::T_STRING
,
209 'payment_instrument_id' => array(
210 'title' => ts('Payment Type'),
211 'type' => CRM_Utils_Type
::T_INT
,
212 'operatorType' => CRM_Report_Form
::OP_MULTISELECT
,
213 'options' => CRM_Contribute_PseudoConstant
::paymentInstrument(),
215 'contribution_status_id' => array(
216 'title' => ts('Contribution Status'),
217 'operatorType' => CRM_Report_Form
::OP_MULTISELECT
,
218 'options' => CRM_Contribute_PseudoConstant
::contributionStatus(),
219 'default' => array(1),
221 'total_amount' => array('title' => ts('Contribution Amount')),
223 'grouping' => 'contri-fields',
225 'civicrm_product' => array(
226 'dao' => 'CRM_Contribute_DAO_Product',
228 'product_name' => array(
230 'title' => ts('Premium'),
234 'civicrm_contribution_product' => array(
235 'dao' => 'CRM_Contribute_DAO_ContributionProduct',
237 'product_id' => array(
238 'no_display' => TRUE,
240 'product_option' => array(
241 'title' => ts('Premium Option'),
243 'fulfilled_date' => array(
244 'title' => ts('Premium Fulfilled Date'),
246 'contribution_id' => array(
247 'no_display' => TRUE,
251 'civicrm_contribution_ordinality' => array(
252 'dao' => 'CRM_Contribute_DAO_Contribution',
253 'alias' => 'cordinality',
255 'ordinality' => array(
256 'title' => ts('Contribution Ordinality'),
257 'type' => CRM_Utils_Type
::T_INT
,
258 'operatorType' => CRM_Report_Form
::OP_MULTISELECT
,
260 0 => 'First by Contributor',
261 1 => 'Second or Later by Contributor',
266 'civicrm_membership' => array(
267 'dao' => 'CRM_Member_DAO_Membership',
269 'membership_type_id' => array(
270 'title' => ts('Membership Type'),
274 'membership_start_date' => array(
275 'title' => ts('Start Date'),
278 'membership_end_date' => array(
279 'title' => ts('End Date'),
282 'join_date' => array(
283 'title' => ts('Join Date'),
286 'source' => array('title' => ts('Membership Source')),
289 'join_date' => array('operatorType' => CRM_Report_Form
::OP_DATE
),
290 'membership_start_date' => array('operatorType' => CRM_Report_Form
::OP_DATE
),
291 'membership_end_date' => array('operatorType' => CRM_Report_Form
::OP_DATE
),
292 'owner_membership_id' => array(
293 'title' => ts('Membership Owner ID'),
294 'operatorType' => CRM_Report_Form
::OP_INT
,
297 'name' => 'membership_type_id',
298 'title' => ts('Membership Types'),
299 'type' => CRM_Utils_Type
::T_INT
,
300 'operatorType' => CRM_Report_Form
::OP_MULTISELECT
,
301 'options' => CRM_Member_PseudoConstant
::membershipType(),
304 'grouping' => 'member-fields',
306 'civicrm_membership_status' => array(
307 'dao' => 'CRM_Member_DAO_MembershipStatus',
308 'alias' => 'mem_status',
310 'membership_status_name' => array(
312 'title' => ts('Membership Status'),
319 'title' => ts('Membership Status'),
320 'type' => CRM_Utils_Type
::T_INT
,
321 'operatorType' => CRM_Report_Form
::OP_MULTISELECT
,
322 'options' => CRM_Member_PseudoConstant
::membershipStatus(NULL, NULL, 'label'),
325 'grouping' => 'member-fields',
327 'civicrm_note' => array(
328 'dao' => 'CRM_Core_DAO_Note',
330 'contribution_note' => array(
332 'title' => ts('Contribution Note'),
338 'title' => ts('Contribution Note'),
339 'operator' => 'like',
340 'type' => CRM_Utils_Type
::T_STRING
,
344 ) +
$this->addAddressFields(FALSE);
346 $this->_groupFilter
= TRUE;
347 $this->_tagFilter
= TRUE;
349 // Don't show Batch display column and filter unless batches are being used
350 $this->_allBatches
= CRM_Batch_BAO_Batch
::getBatches();
351 if (!empty($this->_allBatches
)) {
352 $this->_columns
['civicrm_batch']['dao'] = 'CRM_Batch_DAO_Batch';
353 $this->_columns
['civicrm_batch']['fields']['batch_id'] = array(
355 'title' => ts('Batch Name'),
357 $this->_columns
['civicrm_batch']['filters']['bid'] = array(
359 'title' => ts('Batch Name'),
360 'type' => CRM_Utils_Type
::T_INT
,
361 'operatorType' => CRM_Report_Form
::OP_MULTISELECT
,
362 'options' => $this->_allBatches
,
364 $this->_columns
['civicrm_entity_batch']['dao'] = 'CRM_Batch_DAO_EntityBatch';
365 $this->_columns
['civicrm_entity_batch']['fields']['entity_batch_id'] = array(
366 'name' => 'batch_id',
368 'no_display' => TRUE,
372 if ($campaignEnabled && !empty($this->activeCampaigns
)) {
373 $this->_columns
['civicrm_contribution']['fields']['campaign_id'] = array(
374 'title' => ts('Campaign'),
375 'default' => 'false',
377 $this->_columns
['civicrm_contribution']['filters']['campaign_id'] = array(
378 'title' => ts('Campaign'),
379 'operatorType' => CRM_Report_Form
::OP_MULTISELECT
,
380 'options' => $this->activeCampaigns
,
381 'type' => CRM_Utils_Type
::T_INT
,
383 $this->_columns
['civicrm_contribution']['order_bys']['campaign_id'] = array('title' => ts('Campaign'));
386 $this->_currencyColumn
= 'civicrm_contribution_currency';
387 parent
::__construct();
390 public function preProcess() {
391 parent
::preProcess();
394 public function select() {
397 $this->_columnHeaders
= array();
398 foreach ($this->_columns
as $tableName => $table) {
399 if (array_key_exists('fields', $table)) {
400 foreach ($table['fields'] as $fieldName => $field) {
401 if (!empty($field['required']) ||
402 !empty($this->_params
['fields'][$fieldName])
404 if ($tableName == 'civicrm_address') {
405 $this->_addressField
= TRUE;
407 if ($tableName == 'civicrm_email') {
408 $this->_emailField
= TRUE;
411 // only include statistics columns if set
412 if (!empty($field['statistics'])) {
413 foreach ($field['statistics'] as $stat => $label) {
414 switch (strtolower($stat)) {
416 $select[] = "SUM({$field['dbAlias']}) as {$tableName}_{$fieldName}_{$stat}";
417 $this->_columnHeaders
["{$tableName}_{$fieldName}_{$stat}"]['title'] = $label;
418 $this->_columnHeaders
["{$tableName}_{$fieldName}_{$stat}"]['type'] = $field['type'];
419 $this->_statFields
[] = "{$tableName}_{$fieldName}_{$stat}";
423 $select[] = "COUNT({$field['dbAlias']}) as {$tableName}_{$fieldName}_{$stat}";
424 $this->_columnHeaders
["{$tableName}_{$fieldName}_{$stat}"]['title'] = $label;
425 $this->_statFields
[] = "{$tableName}_{$fieldName}_{$stat}";
429 $select[] = "ROUND(AVG({$field['dbAlias']}),2) as {$tableName}_{$fieldName}_{$stat}";
430 $this->_columnHeaders
["{$tableName}_{$fieldName}_{$stat}"]['type'] = $field['type'];
431 $this->_columnHeaders
["{$tableName}_{$fieldName}_{$stat}"]['title'] = $label;
432 $this->_statFields
[] = "{$tableName}_{$fieldName}_{$stat}";
437 elseif ($fieldName == 'first_donation_date' ||
438 $fieldName == 'first_donation_amount'
440 $baseField = CRM_Utils_Array
::value('base_field', $field);
441 $select[] = "{$this->_aliases['civicrm_contribution']}.{$baseField} as {$tableName}_{$fieldName}";
442 $this->_columnHeaders
["{$tableName}_{$fieldName}"]['title'] = CRM_Utils_Array
::value('title', $field);
443 $this->_columnHeaders
["{$tableName}_{$fieldName}"]['type'] = CRM_Utils_Array
::value('type', $field);
446 $select[] = "{$field['dbAlias']} as {$tableName}_{$fieldName}";
447 $this->_columnHeaders
["{$tableName}_{$fieldName}"]['title'] = CRM_Utils_Array
::value('title', $field);
448 $this->_columnHeaders
["{$tableName}_{$fieldName}"]['type'] = CRM_Utils_Array
::value('type', $field);
455 $this->_select
= 'SELECT ' . implode(', ', $select) . ' ';
458 public function from() {
460 FROM civireport_membership_contribution_detail
461 INNER JOIN civicrm_contribution {$this->_aliases['civicrm_contribution']}
462 ON (civireport_membership_contribution_detail.contribution_id = {$this->_aliases['civicrm_contribution']}.id)
463 LEFT JOIN civicrm_membership {$this->_aliases['civicrm_membership']}
464 ON (civireport_membership_contribution_detail.membership_id = {$this->_aliases['civicrm_membership']}.id)
465 INNER JOIN civicrm_contact {$this->_aliases['civicrm_contact']}
466 ON (civireport_membership_contribution_detail.contact_id = {$this->_aliases['civicrm_contact']}.id)
467 LEFT JOIN civicrm_membership_status {$this->_aliases['civicrm_membership_status']}
468 ON {$this->_aliases['civicrm_membership_status']}.id =
469 {$this->_aliases['civicrm_membership']}.status_id
474 if (!empty($this->_params
['fields']['product_name']) ||
475 !empty($this->_params
['fields']['product_option']) ||
476 !empty($this->_params
['fields']['fulfilled_date'])
479 LEFT JOIN civicrm_contribution_product {$this->_aliases['civicrm_contribution_product']}
480 ON ({$this->_aliases['civicrm_contribution_product']}.contribution_id = {$this->_aliases['civicrm_contribution']}.id)
481 LEFT JOIN civicrm_product {$this->_aliases['civicrm_product']} ON ({$this->_aliases['civicrm_product']}.id = {$this->_aliases['civicrm_contribution_product']}.product_id)";
484 if (!empty($this->_params
['ordinality_value'])) {
486 INNER JOIN (SELECT c.id, IF(COUNT(oc.id) = 0, 0, 1) AS ordinality FROM civicrm_contribution c LEFT JOIN civicrm_contribution oc ON c.contact_id = oc.contact_id AND oc.receive_date < c.receive_date GROUP BY c.id) {$this->_aliases['civicrm_contribution_ordinality']}
487 ON {$this->_aliases['civicrm_contribution_ordinality']}.id = {$this->_aliases['civicrm_contribution']}.id";
490 // include contribution note
491 if (!empty($this->_params
['fields']['contribution_note']) ||
492 !empty($this->_params
['note_value'])
495 LEFT JOIN civicrm_note {$this->_aliases['civicrm_note']}
496 ON ( {$this->_aliases['civicrm_note']}.entity_table = 'civicrm_contribution' AND
497 {$this->_aliases['civicrm_contribution']}.id = {$this->_aliases['civicrm_note']}.entity_id )";
501 if (!empty($this->_params
['fields']['phone'])) {
503 LEFT JOIN civicrm_phone {$this->_aliases['civicrm_phone']}
504 ON ({$this->_aliases['civicrm_contact']}.id = {$this->_aliases['civicrm_phone']}.contact_id AND
505 {$this->_aliases['civicrm_phone']}.is_primary = 1)";
507 //for contribution batches
508 if ($this->_allBatches
&&
509 (!empty($this->_params
['fields']['batch_id']) ||
510 !empty($this->_params
['bid_value']))
513 LEFT JOIN civicrm_entity_financial_trxn tx ON (tx.entity_id = {$this->_aliases['civicrm_contribution']}.id AND
514 tx.entity_table = 'civicrm_contribution')
515 LEFT JOIN civicrm_entity_batch {$this->_aliases['civicrm_entity_batch']}
516 ON ({$this->_aliases['civicrm_entity_batch']}.entity_id = tx.financial_trxn_id AND
517 {$this->_aliases['civicrm_entity_batch']}.entity_table = 'civicrm_financial_trxn')
518 LEFT JOIN civicrm_batch {$this->_aliases['civicrm_batch']}
519 ON {$this->_aliases['civicrm_batch']}.id = {$this->_aliases['civicrm_entity_batch']}.batch_id";
522 if ($this->_addressField
OR
523 (!empty($this->_params
['state_province_id_value']) OR
524 !empty($this->_params
['country_id_value']))
527 LEFT JOIN civicrm_address {$this->_aliases['civicrm_address']}
528 ON {$this->_aliases['civicrm_contact']}.id = {$this->_aliases['civicrm_address']}.contact_id AND
529 {$this->_aliases['civicrm_address']}.is_primary = 1\n";
532 if ($this->_emailField
) {
534 LEFT JOIN civicrm_email {$this->_aliases['civicrm_email']}
535 ON {$this->_aliases['civicrm_contact']}.id = {$this->_aliases['civicrm_email']}.contact_id AND
536 {$this->_aliases['civicrm_email']}.is_primary = 1\n";
541 * @param bool $applyLimit
543 public function tempTable($applyLimit = TRUE) {
544 // create temp table with contact ids,contribtuion id,membership id
545 $dropTempTable = 'DROP TEMPORARY TABLE IF EXISTS civireport_membership_contribution_detail';
546 CRM_Core_DAO
::executeQuery($dropTempTable);
548 $sql = 'CREATE TEMPORARY TABLE civireport_membership_contribution_detail
549 (contribution_id int, INDEX USING HASH(contribution_id), contact_id int, INDEX USING HASH(contact_id),
550 membership_id int, INDEX USING HASH(membership_id), payment_id int, INDEX USING HASH(payment_id)) ENGINE=MEMORY';
551 CRM_Core_DAO
::executeQuery($sql);
554 INSERT INTO civireport_membership_contribution_detail (contribution_id, contact_id, membership_id)
555 SELECT contribution.id, {$this->_aliases['civicrm_contact']}.id, m.id
556 FROM civicrm_contribution contribution
557 INNER JOIN civicrm_contact {$this->_aliases['civicrm_contact']}
558 ON {$this->_aliases['civicrm_contact']}.id = contribution.contact_id AND contribution.is_test = 0
560 LEFT JOIN civicrm_membership_payment mp
561 ON contribution.id = mp.contribution_id
562 LEFT JOIN civicrm_membership m
563 ON mp.membership_id = m.id AND m.is_test = 0 ";
565 CRM_Core_DAO
::executeQuery($fillTemp);
569 * @param bool $applyLimit
573 public function buildQuery($applyLimit = TRUE) {
575 //create temp table to be used as base table
578 $this->customDataFrom();
583 // order_by columns not selected for display need to be included in SELECT
584 $unselectedSectionColumns = $this->unselectedSectionColumns();
585 foreach ($unselectedSectionColumns as $alias => $section) {
586 $this->_select
.= ", {$section['dbAlias']} as {$alias}";
589 if ($applyLimit && empty($this->_params
['charts'])) {
593 $sql = "{$this->_select} {$this->_from} {$this->_where} {$this->_groupBy} {$this->_having} {$this->_orderBy} {$this->_limit}";
594 $this->addToDeveloperTab($sql);
598 public function groupBy() {
599 $this->_groupBy
= " GROUP BY {$this->_aliases['civicrm_contact']}.id, {$this->_aliases['civicrm_contribution']}.id ";
602 public function orderBy() {
603 $this->_orderBy
= " ORDER BY {$this->_aliases['civicrm_contact']}.sort_name, {$this->_aliases['civicrm_contact']}.id ";
604 if (!empty($this->_params
['fields']['first_donation_date']) ||
605 !empty($this->_params
['fields']['first_donation_amount'])
607 $this->_orderBy
.= ", {$this->_aliases['civicrm_contribution']}.receive_date";
616 public function statistics(&$rows) {
617 $statistics = parent
::statistics($rows);
619 $select = "SELECT DISTINCT {$this->_aliases['civicrm_contribution']}.id";
621 $sql = "SELECT COUNT(cc.id) as count, SUM(cc.total_amount) as amount, ROUND(AVG(cc.total_amount), 2) as avg, cc.currency as currency
622 FROM civicrm_contribution cc
623 WHERE cc.id IN ({$select} {$this->_from} {$this->_where})
624 GROUP BY cc.currency";
626 $dao = CRM_Core_DAO
::executeQuery($sql);
627 $totalAmount = $average = array();
628 while ($dao->fetch()) {
630 = CRM_Utils_Money
::format($dao->amount
, $dao->currency
) . "(" .
632 $average[] = CRM_Utils_Money
::format($dao->avg
, $dao->currency
);
634 $statistics['counts']['amount'] = array(
635 'title' => ts('Total Amount'),
636 'value' => implode(', ', $totalAmount),
637 'type' => CRM_Utils_Type
::T_STRING
,
640 $statistics['counts']['avg'] = array(
641 'title' => ts('Average'),
642 'value' => implode(', ', $average),
643 'type' => CRM_Utils_Type
::T_STRING
,
649 public function postProcess() {
650 // get the acl clauses built before we assemble the query
651 $this->buildACLClause($this->_aliases
['civicrm_contact']);
652 parent
::postProcess();
658 public function alterDisplay(&$rows) {
659 // custom code to alter rows
660 $checkList = array();
663 $contributionTypes = CRM_Contribute_PseudoConstant
::financialType();
664 $contributionStatus = CRM_Contribute_PseudoConstant
::contributionStatus();
665 $paymentInstruments = CRM_Contribute_PseudoConstant
::paymentInstrument();
667 //altering the csv display adding additional fields
668 if ($this->_outputMode
== 'csv') {
669 foreach ($this->_columns
as $tableName => $table) {
670 if (array_key_exists('fields', $table)) {
671 foreach ($table['fields'] as $fieldName => $field) {
672 if (!empty($field['csv_display']) && !empty($field['no_display'])) {
673 $this->_columnHeaders
["{$tableName}_{$fieldName}"]['title'] = CRM_Utils_Array
::value('title', $field);
674 $this->_columnHeaders
["{$tableName}_{$fieldName}"]['type'] = CRM_Utils_Array
::value('type', $field);
681 // allow repeat for first donation amount and date in csv
684 foreach ($rows as $rowNum => $row) {
685 if ($this->_outputMode
== 'csv') {
686 if (array_key_exists('civicrm_contact_id', $row)) {
687 if ($contactId = $row['civicrm_contact_id']) {
690 $fAmt = $row['first_donation_first_donation_amount'];
691 $fDate = $row['first_donation_first_donation_date'];
694 if ($pcid == $contactId) {
695 $rows[$rowNum]['first_donation_first_donation_amount'] = $fAmt;
696 $rows[$rowNum]['first_donation_first_donation_date'] = $fDate;
700 $fAmt = $row['first_donation_first_donation_amount'];
701 $fDate = $row['first_donation_first_donation_date'];
709 if (!empty($this->_noRepeats
) && $this->_outputMode
!= 'csv') {
710 $repeatFound = FALSE;
712 $display_flag = NULL;
713 if (array_key_exists('civicrm_contact_id', $row)) {
714 if ($cid = $row['civicrm_contact_id']) {
719 if ($prev_cid == $cid) {
730 foreach ($row as $colName => $colVal) {
731 if (in_array($colName, $this->_noRepeats
)) {
732 unset($rows[$rowNum][$colName]);
741 if (array_key_exists('civicrm_membership_membership_type_id', $row)) {
742 if ($value = $row['civicrm_membership_membership_type_id']) {
743 $rows[$rowNum]['civicrm_membership_membership_type_id'] = CRM_Member_PseudoConstant
::membershipType($value, FALSE);
748 if (array_key_exists('civicrm_batch_batch_id', $row)) {
749 if ($value = $row['civicrm_batch_batch_id']) {
750 $rows[$rowNum]['civicrm_batch_batch_id'] = CRM_Core_DAO
::getFieldValue('CRM_Batch_DAO_Batch', $value, 'title');
755 if (array_key_exists('civicrm_address_state_province_id', $row)) {
756 if ($value = $row['civicrm_address_state_province_id']) {
757 $rows[$rowNum]['civicrm_address_state_province_id'] = CRM_Core_PseudoConstant
::stateProvince($value, FALSE);
762 if (array_key_exists('civicrm_address_country_id', $row)) {
763 if ($value = $row['civicrm_address_country_id']) {
764 $rows[$rowNum]['civicrm_address_country_id'] = CRM_Core_PseudoConstant
::country($value, FALSE);
769 // convert donor sort name to link
770 if (array_key_exists('civicrm_contact_sort_name', $row) &&
771 !empty($rows[$rowNum]['civicrm_contact_sort_name']) &&
772 array_key_exists('civicrm_contact_id', $row)
774 $url = CRM_Utils_System
::url('civicrm/contact/view',
775 'reset=1&cid=' . $row['civicrm_contact_id'],
779 $rows[$rowNum]['civicrm_contact_sort_name_link'] = $url;
780 $rows[$rowNum]['civicrm_contact_sort_name_hover'] = ts('View Contact Summary for this Contact.');
783 if ($value = CRM_Utils_Array
::value('civicrm_contribution_financial_type_id', $row)) {
784 $rows[$rowNum]['civicrm_contribution_financial_type_id'] = $contributionTypes[$value];
787 if ($value = CRM_Utils_Array
::value('civicrm_contribution_contribution_status_id', $row)) {
788 $rows[$rowNum]['civicrm_contribution_contribution_status_id'] = $contributionStatus[$value];
791 if ($value = CRM_Utils_Array
::value('civicrm_contribution_payment_instrument_id', $row)) {
792 $rows[$rowNum]['civicrm_contribution_payment_instrument_id'] = $paymentInstruments[$value];
795 if (($value = CRM_Utils_Array
::value('civicrm_contribution_total_amount_sum', $row)) &&
796 CRM_Core_Permission
::check('access CiviContribute')
798 $url = CRM_Utils_System
::url('civicrm/contact/view/contribution',
799 'reset=1&id=' . $row['civicrm_contribution_contribution_id'] .
800 '&cid=' . $row['civicrm_contact_id'] .
801 '&action=view&context=contribution&selectedChild=contribute',
804 $rows[$rowNum]['civicrm_contribution_total_amount_sum_link'] = $url;
805 $rows[$rowNum]['civicrm_contribution_total_amount_sum_hover'] = ts('View Details of this Contribution.');
809 // convert campaign_id to campaign title
810 if (array_key_exists('civicrm_contribution_campaign_id', $row)) {
811 if ($value = $row['civicrm_contribution_campaign_id']) {
812 $rows[$rowNum]['civicrm_contribution_campaign_id'] = $this->activeCampaigns
[$value];
817 $entryFound = $this->alterDisplayAddressFields($row, $rows, $rowNum, 'member/contributionDetail', 'List all contribution(s) for this ') ?
TRUE : $entryFound;
819 // skip looking further in rows, if first row itself doesn't
820 // have the column we need