3 +--------------------------------------------------------------------+
4 | Copyright CiviCRM LLC. All rights reserved. |
6 | This work is published under the GNU AGPLv3 license with some |
7 | permitted exceptions and without any warranty. For full license |
8 | and copyright information, see https://civicrm.org/licensing |
9 +--------------------------------------------------------------------+
15 * @copyright CiviCRM LLC https://civicrm.org/licensing
19 * BAO object for crm_log table
21 class CRM_Core_BAO_Log
extends CRM_Core_DAO_Log
{
22 public static $_processed = NULL;
26 * @param string $table
31 public static function &lastModified($id, $table = 'civicrm_contact') {
33 $log = new CRM_Core_DAO_Log();
35 $log->entity_table
= $table;
36 $log->entity_id
= $id;
37 $log->orderBy('modified_date desc');
39 $displayName = $result = $contactImage = NULL;
40 if ($log->find(TRUE)) {
41 if ($log->modified_id
) {
42 list($displayName, $contactImage) = CRM_Contact_BAO_Contact
::getDisplayAndImage($log->modified_id
);
45 'id' => $log->modified_id
,
46 'name' => $displayName,
47 'image' => $contactImage,
48 'date' => $log->modified_date
,
55 * Add log to civicrm_log table.
57 * @param array $params
58 * Array of name-value pairs of log table.
61 public static function add(&$params) {
63 $log = new CRM_Core_DAO_Log();
64 $log->copyValues($params);
69 * @param int $contactID
70 * @param string $tableName
74 * @throws \CRM_Core_Exception
76 public static function register(
82 if (!self
::$_processed) {
83 self
::$_processed = [];
87 $session = CRM_Core_Session
::singleton();
88 $userID = $session->get('userID');
92 $api_key = CRM_Utils_Request
::retrieve('api_key', 'String', $store, FALSE, NULL, 'REQUEST');
94 if ($api_key && strtolower($api_key) != 'null') {
95 $userID = CRM_Core_DAO
::getFieldValue('CRM_Contact_DAO_Contact', $api_key, 'id', 'api_key');
100 $userID = $contactID;
107 $log = new CRM_Core_DAO_Log();
110 if (isset(self
::$_processed[$contactID])) {
111 if (isset(self
::$_processed[$contactID][$userID])) {
112 $log->id
= self
::$_processed[$contactID][$userID];
114 self
::$_processed[$contactID][$userID] = 1;
117 self
::$_processed[$contactID] = [$userID => 1];
120 $logData = "$tableName,$tableID";
122 $log->entity_table
= 'civicrm_contact';
123 $log->entity_id
= $contactID;
124 $log->modified_id
= $userID;
125 $log->modified_date
= date("YmdHis");
126 $log->data
= $logData;
132 SET data = concat( data, ':$logData' )
133 WHERE id = {$log->id}
135 CRM_Core_DAO
::executeQuery($query);
138 self
::$_processed[$contactID][$userID] = $log->id
;
142 * Get log record count for a Contact.
144 * @param int $contactID
147 * count of log records
149 public static function getContactLogCount($contactID) {
150 $query = "SELECT count(*) FROM civicrm_log
151 WHERE civicrm_log.entity_table = 'civicrm_contact' AND civicrm_log.entity_id = {$contactID}";
152 return CRM_Core_DAO
::singleValueQuery($query);
156 * Get the id of the report to use to display the change log.
158 * If logging is not enabled a return value of FALSE means to use the
159 * basic change log view.
162 * report id of Contact Logging Report (Summary)
164 public static function useLoggingReport() {
165 if (!\Civi
::settings()->get('logging')) {
169 $loggingSchema = new CRM_Logging_Schema();
171 if ($loggingSchema->isEnabled()) {
172 $params = ['report_id' => 'logging/contact/summary'];
174 CRM_Report_BAO_ReportInstance
::retrieve($params, $instance);
176 if (!empty($instance) &&
177 (empty($instance['permission']) ||
178 (!empty($instance['permission']) && CRM_Core_Permission
::check($instance['permission']))
181 return $instance['id'];