4 +--------------------------------------------------------------------+
5 | CiviCRM version 4.6 |
6 +--------------------------------------------------------------------+
7 | Copyright CiviCRM LLC (c) 2004-2014 |
8 +--------------------------------------------------------------------+
9 | This file is a part of CiviCRM. |
11 | CiviCRM is free software; you can copy, modify, and distribute it |
12 | under the terms of the GNU Affero General Public License |
13 | Version 3, 19 November 2007 and the CiviCRM Licensing Exception. |
15 | CiviCRM is distributed in the hope that it will be useful, but |
16 | WITHOUT ANY WARRANTY; without even the implied warranty of |
17 | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. |
18 | See the GNU Affero General Public License for more details. |
20 | You should have received a copy of the GNU Affero General Public |
21 | License and the CiviCRM Licensing Exception along |
22 | with this program; if not, contact CiviCRM LLC |
23 | at info[AT]civicrm[DOT]org. If you have questions about the |
24 | GNU Affero General Public License or the licensing of CiviCRM, |
25 | see the CiviCRM license FAQ at http://civicrm.org/licensing |
26 +--------------------------------------------------------------------+
32 * @copyright CiviCRM LLC (c) 2004-2014
36 class CRM_Report_Form_Contribute_LoggingSummary
extends CRM_Logging_ReportSummary
{
40 function __construct() {
41 $this->_columns
= array(
42 'civicrm_contact_altered_contact' => array(
43 'dao' => 'CRM_Contact_DAO_Contact',
49 'display_name' => array(
51 'title' => ts('Altered Contact'),
53 'is_deleted' => array(
59 'altered_contact' => array(
60 'name' => 'display_name',
61 'title' => ts('Altered Contact'),
62 'type' => CRM_Utils_Type
::T_STRING
,
66 'log_civicrm_contribution' => array(
67 'dao' => 'CRM_Contribute_DAO_Contribution',
73 'contact_id' => array(
77 'log_user_id' => array(
84 'type' => CRM_Utils_Type
::T_TIME
,
85 'title' => ts('When'),
87 'log_conn_id' => array(
91 'log_action' => array(
93 'title' => ts('Action'),
95 'financial_type_id' => array(
99 'contribution_status_id' => array(
100 'no_display' => TRUE,
103 'aggregate_amount' => array(
105 'name' => 'total_amount',
106 'title' => ts('Aggregate Amount'),
107 'type' => CRM_Utils_Type
::T_MONEY
,
112 'title' => ts('When'),
113 'operatorType' => CRM_Report_Form
::OP_DATE
,
114 'type' => CRM_Utils_Type
::T_DATE
,
116 'log_action' => array(
117 'operatorType' => CRM_Report_Form
::OP_MULTISELECT
,
118 'options' => array('Insert' => ts('Insert'), 'Update' => ts('Update'), 'Delete' => ts('Delete')),
119 'title' => ts('Action'),
120 'type' => CRM_Utils_Type
::T_STRING
,
123 'no_display' => TRUE,
124 'type' => CRM_Utils_Type
::T_INT
,
128 'civicrm_financial_type' => array(
129 'dao' => 'CRM_Financial_DAO_FinancialType',
132 'no_display' => TRUE,
136 'title' => ts('Financial Type'),
137 'type' => CRM_Utils_Type
::T_STRING
,
141 'civicrm_contribution_status' => array(
142 'dao' => 'CRM_Core_DAO_OptionValue',
145 'no_display' => TRUE,
149 'title' => ts('Contribution Status'),
150 'type' => CRM_Utils_Type
::T_STRING
,
154 'civicrm_contact_altered_by' => array(
155 'dao' => 'CRM_Contact_DAO_Contact',
158 'no_display' => TRUE,
161 'display_name' => array(
163 'title' => ts('Altered By'),
167 'altered_by' => array(
168 'name' => 'display_name',
169 'title' => ts('Altered By'),
170 'type' => CRM_Utils_Type
::T_STRING
,
175 parent
::__construct();
181 function alterDisplay(&$rows) {
182 // cache for id → is_deleted mapping
183 $isDeleted = array();
185 foreach ($rows as & $row) {
186 if (!isset($isDeleted[$row['civicrm_contact_is_deleted']])) {
187 $isDeleted[$row['civicrm_contact_is_deleted']] = CRM_Core_DAO
::getFieldValue('CRM_Contact_DAO_Contact', $row['civicrm_contact_altered_contact_id'], 'is_deleted') !== '0';
190 if (!$isDeleted[$row['civicrm_contact_is_deleted']]) {
191 $row['civicrm_contact_altered_contact_display_name_link'] = CRM_Utils_System
::url('civicrm/contact/view', 'reset=1&cid=' . $row['log_civicrm_contribution_contact_id']);
192 $row['civicrm_contact_altered_contact_display_name_hover'] = ts('Go to contact summary');
195 $row['civicrm_contact_altered_by_display_name_link'] = CRM_Utils_System
::url('civicrm/contact/view', 'reset=1&cid=' . $row['log_civicrm_contribution_log_user_id']);
196 $row['civicrm_contact_altered_by_display_name_hover'] = ts('Go to contact summary');
198 if ($row['civicrm_contact_altered_contact_is_deleted'] and ($row['log_civicrm_contribution_log_action'] == 'Update')) {
199 $row['log_civicrm_contribution_log_action'] = ts('Delete');
202 if ($row['log_civicrm_contribution_log_action'] == 'Update') {
203 $q = "reset=1&log_conn_id={$row['log_civicrm_contribution_log_conn_id']}&log_date={$row['log_civicrm_contribution_log_date']}";
205 $q .= '&cid=' . $this->cid
;
208 $url = CRM_Report_Utils_Report
::getNextUrl('logging/contribute/detail', $q, FALSE, TRUE);
209 $row['log_civicrm_contribution_log_action_link'] = $url;
210 $row['log_civicrm_contribution_log_action_hover'] = ts('View details for this update');
211 $row['log_civicrm_contribution_log_action'] = '<div class="icon details-icon"></div> ' . ts('Update');
214 unset($row['log_civicrm_contribute_log_user_id']);
215 unset($row['log_civicrm_contribute_log_conn_id']);
221 FROM `{$this->loggingDB}`.log_civicrm_contribution {$this->_aliases['log_civicrm_contribution']}
222 LEFT JOIN civicrm_contact {$this->_aliases['civicrm_contact_altered_by']}
223 ON ({$this->_aliases['log_civicrm_contribution']}.log_user_id = {$this->_aliases['civicrm_contact_altered_by']}.id)
224 LEFT JOIN civicrm_contact {$this->_aliases['civicrm_contact_altered_contact']}
225 ON ({$this->_aliases['log_civicrm_contribution']}.contact_id = {$this->_aliases['civicrm_contact_altered_contact']}.id)
226 LEFT JOIN civicrm_financial_type {$this->_aliases['civicrm_financial_type']}
227 ON ({$this->_aliases['log_civicrm_contribution']}.financial_type_id = {$this->_aliases['civicrm_financial_type']}.id)
228 LEFT JOIN civicrm_option_value {$this->_aliases['civicrm_contribution_status']}
229 ON ({$this->_aliases['log_civicrm_contribution']}.contribution_status_id = {$this->_aliases['civicrm_contribution_status']}.value)
230 INNER JOIN civicrm_option_group
231 ON ({$this->_aliases['civicrm_contribution_status']}.option_group_id = civicrm_option_group.id
232 AND civicrm_option_group.name = 'contribution_status')