CRM/Report/Form/Contribute/LoggingDetail.php

   1 <?php
   2
   3 /*
   4  +--------------------------------------------------------------------+
   5  | CiviCRM version 4.4                                                |
   6  +--------------------------------------------------------------------+
   7  | Copyright CiviCRM LLC (c) 2004-2013                                |
   8  +--------------------------------------------------------------------+
   9  | This file is a part of CiviCRM.                                    |
  10  |                                                                    |
  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.   |
  14  |                                                                    |
  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.        |
  19  |                                                                    |
  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  +--------------------------------------------------------------------+
  27 */
  28
  29 /**
  30  *
  31  * @package CRM
  32  * @copyright CiviCRM LLC (c) 2004-2013
  33  * $Id$
  34  *
  35  */
  36 class CRM_Report_Form_Contribute_LoggingDetail extends CRM_Logging_ReportDetail {
  37   function __construct() {
  38     $logging        = new CRM_Logging_Schema;
  39     $this->tables[] = 'civicrm_contribution';
  40     $this->tables   = array_merge($this->tables, array_keys($logging->customDataLogTables()));
  41
  42     $this->detail = 'logging/contribute/detail';
  43     $this->summary = 'logging/contribute/summary';
  44
  45     parent::__construct();
  46   }
  47
  48   function buildQuickForm() {
  49     parent::buildQuickForm();
  50
  51     // link back to summary report
  52     $this->assign('backURL', CRM_Report_Utils_Report::getNextUrl('logging/contribute/summary', 'reset=1', FALSE, TRUE));
  53   }
  54
  55   protected function whoWhomWhenSql() {
  56     return "
  57             SELECT who.id who_id, who.display_name who_name, whom.id whom_id, whom.display_name whom_name
  58             FROM `{$this->db}`.log_civicrm_contribution l
  59             LEFT JOIN civicrm_contact who ON (l.log_user_id = who.id)
  60             LEFT JOIN civicrm_contact whom ON (l.contact_id = whom.id)
  61             WHERE log_action = 'Update' AND log_conn_id = %1 AND log_date = %2 ORDER BY log_date DESC LIMIT 1
  62         ";
  63   }
  64 }
  65