Commit | Line | Data |
---|---|---|
6a488035 TO |
1 | <?php |
2 | /* | |
3 | +--------------------------------------------------------------------+ | |
bc77d7c0 | 4 | | Copyright CiviCRM LLC. All rights reserved. | |
6a488035 | 5 | | | |
bc77d7c0 TO |
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 | | |
6a488035 | 9 | +--------------------------------------------------------------------+ |
d25dd0ee | 10 | */ |
6a488035 TO |
11 | |
12 | /** | |
cb22e5dc | 13 | * Class CRM_Logging_ReportSummary |
6a488035 TO |
14 | */ |
15 | class CRM_Logging_ReportSummary extends CRM_Report_Form { | |
16 | protected $cid; | |
17 | ||
be2fb01f | 18 | protected $_logTables = []; |
6a488035 TO |
19 | |
20 | protected $loggingDB; | |
21 | ||
41c9c9e9 | 22 | /** |
63dc1f23 | 23 | * Clause used in the final run of buildQuery but not when doing preliminary work. |
24 | * | |
25 | * (We do this to all the api to run this report since it doesn't call postProcess). | |
41c9c9e9 | 26 | * |
27 | * @var string | |
28 | */ | |
63dc1f23 | 29 | protected $logTypeTableClause; |
41c9c9e9 | 30 | |
65ec4c8c | 31 | /** |
63dc1f23 | 32 | * The log table currently being processed. |
65ec4c8c | 33 | * |
34 | * @var string | |
35 | */ | |
63dc1f23 | 36 | protected $currentLogTable; |
65ec4c8c | 37 | |
e0ef6999 | 38 | /** |
2fb1dd66 | 39 | * Class constructor. |
e0ef6999 | 40 | */ |
00be9182 | 41 | public function __construct() { |
694e78fd DS |
42 | // don’t display the ‘Add these Contacts to Group’ button |
43 | $this->_add2groupSupported = FALSE; | |
44 | ||
45 | $dsn = defined('CIVICRM_LOGGING_DSN') ? DB::parseDSN(CIVICRM_LOGGING_DSN) : DB::parseDSN(CIVICRM_DSN); | |
46 | $this->loggingDB = $dsn['database']; | |
47 | ||
48 | // used for redirect back to contact summary | |
41c9c9e9 | 49 | $this->cid = CRM_Utils_Request::retrieve('cid', 'Integer'); |
cbb9666e | 50 | |
be2fb01f CW |
51 | $this->_logTables = [ |
52 | 'log_civicrm_contact' => [ | |
ae5ffbb7 | 53 | 'fk' => 'id', |
be2fb01f CW |
54 | ], |
55 | 'log_civicrm_email' => [ | |
ae5ffbb7 TO |
56 | 'fk' => 'contact_id', |
57 | 'log_type' => 'Contact', | |
be2fb01f CW |
58 | ], |
59 | 'log_civicrm_phone' => [ | |
ae5ffbb7 TO |
60 | 'fk' => 'contact_id', |
61 | 'log_type' => 'Contact', | |
be2fb01f CW |
62 | ], |
63 | 'log_civicrm_address' => [ | |
ae5ffbb7 TO |
64 | 'fk' => 'contact_id', |
65 | 'log_type' => 'Contact', | |
be2fb01f CW |
66 | ], |
67 | 'log_civicrm_note' => [ | |
ae5ffbb7 TO |
68 | 'fk' => 'entity_id', |
69 | 'entity_table' => TRUE, | |
be2fb01f | 70 | 'bracket_info' => [ |
ae5ffbb7 TO |
71 | 'table' => 'log_civicrm_note', |
72 | 'column' => 'subject', | |
be2fb01f CW |
73 | ], |
74 | ], | |
75 | 'log_civicrm_note_comment' => [ | |
ae5ffbb7 TO |
76 | 'fk' => 'entity_id', |
77 | 'table_name' => 'log_civicrm_note', | |
be2fb01f | 78 | 'joins' => [ |
ae5ffbb7 TO |
79 | 'table' => 'log_civicrm_note', |
80 | 'join' => "entity_log_civireport.entity_id = fk_table.id AND entity_log_civireport.entity_table = 'civicrm_note'", | |
be2fb01f | 81 | ], |
ae5ffbb7 | 82 | 'entity_table' => TRUE, |
be2fb01f | 83 | 'bracket_info' => [ |
ae5ffbb7 TO |
84 | 'table' => 'log_civicrm_note', |
85 | 'column' => 'subject', | |
be2fb01f CW |
86 | ], |
87 | ], | |
88 | 'log_civicrm_group_contact' => [ | |
ae5ffbb7 | 89 | 'fk' => 'contact_id', |
be2fb01f | 90 | 'bracket_info' => [ |
ae5ffbb7 TO |
91 | 'entity_column' => 'group_id', |
92 | 'table' => 'log_civicrm_group', | |
93 | 'column' => 'title', | |
be2fb01f | 94 | ], |
ae5ffbb7 TO |
95 | 'action_column' => 'status', |
96 | 'log_type' => 'Group', | |
be2fb01f CW |
97 | ], |
98 | 'log_civicrm_entity_tag' => [ | |
ae5ffbb7 | 99 | 'fk' => 'entity_id', |
be2fb01f | 100 | 'bracket_info' => [ |
ae5ffbb7 TO |
101 | 'entity_column' => 'tag_id', |
102 | 'table' => 'log_civicrm_tag', | |
103 | 'column' => 'name', | |
be2fb01f | 104 | ], |
ae5ffbb7 | 105 | 'entity_table' => TRUE, |
be2fb01f CW |
106 | ], |
107 | 'log_civicrm_relationship' => [ | |
ae5ffbb7 | 108 | 'fk' => 'contact_id_a', |
be2fb01f | 109 | 'bracket_info' => [ |
ae5ffbb7 TO |
110 | 'entity_column' => 'relationship_type_id', |
111 | 'table' => 'log_civicrm_relationship_type', | |
112 | 'column' => 'label_a_b', | |
be2fb01f CW |
113 | ], |
114 | ], | |
115 | 'log_civicrm_activity_contact' => [ | |
ae5ffbb7 | 116 | 'fk' => 'contact_id', |
41c9c9e9 | 117 | 'table_name' => 'log_civicrm_activity_contact', |
15ca2e9d | 118 | 'log_type' => 'Activity Contact', |
41c9c9e9 | 119 | 'field' => 'activity_id', |
be2fb01f | 120 | 'extra_joins' => [ |
b94abe71 | 121 | 'table' => 'log_civicrm_activity', |
122 | 'join' => 'extra_table.id = entity_log_civireport.activity_id', | |
be2fb01f | 123 | ], |
41c9c9e9 | 124 | |
be2fb01f | 125 | 'bracket_info' => [ |
ae5ffbb7 TO |
126 | 'entity_column' => 'activity_type_id', |
127 | 'options' => CRM_Core_PseudoConstant::activityType(TRUE, TRUE, FALSE, 'label', TRUE), | |
41c9c9e9 | 128 | 'lookup_table' => 'log_civicrm_activity', |
be2fb01f CW |
129 | ], |
130 | ], | |
131 | 'log_civicrm_case' => [ | |
ae5ffbb7 | 132 | 'fk' => 'contact_id', |
be2fb01f | 133 | 'joins' => [ |
ae5ffbb7 TO |
134 | 'table' => 'log_civicrm_case_contact', |
135 | 'join' => 'entity_log_civireport.id = fk_table.case_id', | |
be2fb01f CW |
136 | ], |
137 | 'bracket_info' => [ | |
ae5ffbb7 | 138 | 'entity_column' => 'case_type_id', |
7a5c0c6c | 139 | 'options' => CRM_Case_BAO_Case::buildOptions('case_type_id', 'search'), |
be2fb01f CW |
140 | ], |
141 | ], | |
142 | ]; | |
6a488035 | 143 | |
ae5ffbb7 | 144 | $logging = new CRM_Logging_Schema(); |
694e78fd DS |
145 | |
146 | // build _logTables for contact custom tables | |
147 | $customTables = $logging->entityCustomDataLogTables('Contact'); | |
6a488035 | 148 | foreach ($customTables as $table) { |
be2fb01f | 149 | $this->_logTables[$table] = [ |
9d72cede | 150 | 'fk' => 'entity_id', |
21dfd5f5 | 151 | 'log_type' => 'Contact', |
be2fb01f | 152 | ]; |
6a488035 TO |
153 | } |
154 | ||
694e78fd DS |
155 | // build _logTables for address custom tables |
156 | $customTables = $logging->entityCustomDataLogTables('Address'); | |
157 | foreach ($customTables as $table) { | |
be2fb01f | 158 | $this->_logTables[$table] = [ |
2fb1dd66 EM |
159 | // For join of fk_table with contact table. |
160 | 'fk' => 'contact_id', | |
be2fb01f | 161 | 'joins' => [ |
2fb1dd66 EM |
162 | // fk_table |
163 | 'table' => 'log_civicrm_address', | |
ae5ffbb7 | 164 | 'join' => 'entity_log_civireport.entity_id = fk_table.id', |
be2fb01f | 165 | ], |
ae5ffbb7 | 166 | 'log_type' => 'Contact', |
be2fb01f | 167 | ]; |
694e78fd DS |
168 | } |
169 | ||
2fb1dd66 | 170 | // Allow log tables to be extended via report hooks. |
6b4b11c4 | 171 | CRM_Report_BAO_Hook::singleton()->alterLogTables($this, $this->_logTables); |
c3e3dd65 | 172 | |
6a488035 TO |
173 | parent::__construct(); |
174 | } | |
175 | ||
00be9182 | 176 | public function groupBy() { |
6a488035 TO |
177 | $this->_groupBy = 'GROUP BY entity_log_civireport.log_conn_id, entity_log_civireport.log_user_id, EXTRACT(DAY_MICROSECOND FROM entity_log_civireport.log_date), entity_log_civireport.id'; |
178 | } | |
179 | ||
41c9c9e9 | 180 | /** |
181 | * Adjust query for the activity_contact table. | |
182 | * | |
183 | * As this is just a join table the ID we REALLY care about is the activity id. | |
184 | * | |
185 | * @param string $tableName | |
186 | * @param string $tableKey | |
187 | * @param string $fieldName | |
188 | * @param string $field | |
189 | * | |
190 | * @return string | |
191 | */ | |
192 | public function selectClause(&$tableName, $tableKey, &$fieldName, &$field) { | |
193 | if ($this->currentLogTable == 'log_civicrm_activity_contact' && $fieldName == 'id') { | |
194 | $alias = "{$tableName}_{$fieldName}"; | |
195 | $select[] = "{$tableName}.activity_id as $alias"; | |
196 | $this->_selectAliases[] = $alias; | |
197 | return "activity_id"; | |
6a488035 | 198 | } |
b94abe71 | 199 | if ($fieldName == 'log_grouping') { |
200 | if ($this->currentLogTable != 'log_civicrm_activity_contact') { | |
201 | return 1; | |
202 | } | |
203 | $mergeActivityID = CRM_Core_PseudoConstant::getKey('CRM_Activity_BAO_Activity', 'activity_type_id', 'Contact Merged'); | |
204 | return " IF (entity_log_civireport.log_action = 'Insert' AND extra_table.activity_type_id = $mergeActivityID , GROUP_CONCAT(entity_log_civireport.contact_id), 1) "; | |
205 | } | |
6a488035 TO |
206 | } |
207 | ||
00be9182 | 208 | public function where() { |
8c544cd2 | 209 | // reset where clause as its called multiple times, every time insert sql is built. |
be2fb01f | 210 | $this->_whereClauses = []; |
42047ce4 | 211 | |
6a488035 TO |
212 | parent::where(); |
213 | $this->_where .= " AND (entity_log_civireport.log_action != 'Initialization')"; | |
214 | } | |
215 | ||
e0ef6999 | 216 | /** |
2fb1dd66 EM |
217 | * Get log type. |
218 | * | |
219 | * @param string $entity | |
e0ef6999 EM |
220 | * |
221 | * @return string | |
222 | */ | |
00be9182 | 223 | public function getLogType($entity) { |
a7488080 | 224 | if (!empty($this->_logTables[$entity]['log_type'])) { |
6a488035 TO |
225 | return $this->_logTables[$entity]['log_type']; |
226 | } | |
227 | $logType = ucfirst(substr($entity, strrpos($entity, '_') + 1)); | |
228 | return $logType; | |
229 | } | |
230 | ||
e0ef6999 | 231 | /** |
2fb1dd66 EM |
232 | * Get entity value. |
233 | * | |
100fef9d | 234 | * @param int $id |
e0ef6999 EM |
235 | * @param $entity |
236 | * @param $logDate | |
237 | * | |
238 | * @return mixed|null|string | |
239 | */ | |
00be9182 | 240 | public function getEntityValue($id, $entity, $logDate) { |
a7488080 CW |
241 | if (!empty($this->_logTables[$entity]['bracket_info'])) { |
242 | if (!empty($this->_logTables[$entity]['bracket_info']['entity_column'])) { | |
0d8afee2 | 243 | $logTable = !empty($this->_logTables[$entity]['table_name']) ? $this->_logTables[$entity]['table_name'] : $entity; |
41c9c9e9 | 244 | if (!empty($this->_logTables[$entity]['bracket_info']['lookup_table'])) { |
245 | $logTable = $this->_logTables[$entity]['bracket_info']['lookup_table']; | |
246 | } | |
6a488035 | 247 | $sql = " |
eea16664 | 248 | SELECT {$this->_logTables[$entity]['bracket_info']['entity_column']} |
249 | FROM `{$this->loggingDB}`.{$logTable} | |
6a488035 | 250 | WHERE log_date <= %1 AND id = %2 ORDER BY log_date DESC LIMIT 1"; |
41c9c9e9 | 251 | |
be2fb01f CW |
252 | $entityID = CRM_Core_DAO::singleValueQuery($sql, [ |
253 | 1 => [ | |
cbb9666e | 254 | CRM_Utils_Date::isoToMysql($logDate), |
21dfd5f5 | 255 | 'Timestamp', |
be2fb01f CW |
256 | ], |
257 | 2 => [$id, 'Integer'], | |
258 | ]); | |
cbb9666e | 259 | } |
260 | else { | |
6a488035 TO |
261 | $entityID = $id; |
262 | } | |
263 | ||
9d72cede EM |
264 | if ($entityID && $logDate && |
265 | array_key_exists('table', $this->_logTables[$entity]['bracket_info']) | |
266 | ) { | |
6a488035 | 267 | $sql = " |
eea16664 | 268 | SELECT {$this->_logTables[$entity]['bracket_info']['column']} |
269 | FROM `{$this->loggingDB}`.{$this->_logTables[$entity]['bracket_info']['table']} | |
6a488035 | 270 | WHERE log_date <= %1 AND id = %2 ORDER BY log_date DESC LIMIT 1"; |
be2fb01f CW |
271 | return CRM_Core_DAO::singleValueQuery($sql, [ |
272 | 1 => [CRM_Utils_Date::isoToMysql($logDate), 'Timestamp'], | |
273 | 2 => [$entityID, 'Integer'], | |
274 | ]); | |
cbb9666e | 275 | } |
276 | else { | |
9d72cede EM |
277 | if (array_key_exists('options', $this->_logTables[$entity]['bracket_info']) && |
278 | $entityID | |
279 | ) { | |
914d3734 | 280 | return $this->_logTables[$entity]['bracket_info']['options'][$entityID] ?? NULL; |
cbb9666e | 281 | } |
6a488035 TO |
282 | } |
283 | } | |
cbb9666e | 284 | return NULL; |
6a488035 TO |
285 | } |
286 | ||
e0ef6999 | 287 | /** |
2fb1dd66 EM |
288 | * Get entity action. |
289 | * | |
100fef9d CW |
290 | * @param int $id |
291 | * @param int $connId | |
e0ef6999 EM |
292 | * @param $entity |
293 | * @param $oldAction | |
294 | * | |
295 | * @return null|string | |
296 | */ | |
00be9182 | 297 | public function getEntityAction($id, $connId, $entity, $oldAction) { |
a7488080 | 298 | if (!empty($this->_logTables[$entity]['action_column'])) { |
6a488035 | 299 | $sql = "select {$this->_logTables[$entity]['action_column']} from `{$this->loggingDB}`.{$entity} where id = %1 AND log_conn_id = %2"; |
be2fb01f CW |
300 | $newAction = CRM_Core_DAO::singleValueQuery($sql, [ |
301 | 1 => [$id, 'Integer'], | |
302 | 2 => [$connId, 'String'], | |
303 | ]); | |
6a488035 TO |
304 | |
305 | switch ($entity) { | |
cbb9666e | 306 | case 'log_civicrm_group_contact': |
307 | if ($oldAction !== 'Update') { | |
308 | $newAction = $oldAction; | |
309 | } | |
310 | if ($oldAction == 'Insert') { | |
311 | $newAction = 'Added'; | |
312 | } | |
313 | break; | |
6a488035 TO |
314 | } |
315 | return $newAction; | |
316 | } | |
cbb9666e | 317 | return NULL; |
6a488035 | 318 | } |
96025800 | 319 | |
63dc1f23 | 320 | /** |
321 | * Build the temporary tables for the query. | |
322 | */ | |
323 | protected function buildTemporaryTables() { | |
324 | $tempColumns = "id int(10), log_civicrm_entity_log_grouping varchar(32)"; | |
325 | if (!empty($this->_params['fields']['log_action'])) { | |
326 | $tempColumns .= ", log_action varchar(64)"; | |
327 | } | |
328 | $tempColumns .= ", log_type varchar(64), log_user_id int(10), log_date timestamp"; | |
329 | if (!empty($this->_params['fields']['altered_contact'])) { | |
330 | $tempColumns .= ", altered_contact varchar(128)"; | |
331 | } | |
332 | $tempColumns .= ", altered_contact_id int(10), log_conn_id varchar(17), is_deleted tinyint(4)"; | |
333 | if (!empty($this->_params['fields']['display_name'])) { | |
334 | $tempColumns .= ", display_name varchar(128)"; | |
335 | } | |
336 | ||
337 | // temp table to hold all altered contact-ids | |
1e130d2a SL |
338 | $this->temporaryTable = CRM_Utils_SQL_TempTable::build()->setCategory('logsummary')->setMemory()->createwithColumns($tempColumns); |
339 | $this->addToDeveloperTab($this->temporaryTable->getCreateSql()); | |
340 | $this->temporaryTableName = $this->temporaryTable->getName(); | |
63dc1f23 | 341 | |
9c1bc317 | 342 | $logTypes = $this->_params['log_type_value'] ?? NULL; |
63dc1f23 | 343 | unset($this->_params['log_type_value']); |
344 | if (empty($logTypes)) { | |
345 | foreach (array_keys($this->_logTables) as $table) { | |
346 | $type = $this->getLogType($table); | |
347 | $logTypes[$type] = $type; | |
348 | } | |
349 | } | |
350 | ||
351 | $logTypeTableClause = '(1)'; | |
352 | if ($logTypeTableValue = CRM_Utils_Array::value("log_type_table_value", $this->_params)) { | |
353 | $logTypeTableClause = $this->whereClause($this->_columns['log_civicrm_entity']['filters']['log_type_table'], | |
354 | $this->_params['log_type_table_op'], $logTypeTableValue, NULL, NULL); | |
355 | unset($this->_params['log_type_table_value']); | |
356 | } | |
357 | ||
358 | foreach ($this->_logTables as $entity => $detail) { | |
359 | if ((in_array($this->getLogType($entity), $logTypes) && | |
360 | CRM_Utils_Array::value('log_type_op', $this->_params) == 'in') || | |
361 | (!in_array($this->getLogType($entity), $logTypes) && | |
362 | CRM_Utils_Array::value('log_type_op', $this->_params) == 'notin') | |
363 | ) { | |
364 | $this->currentLogTable = $entity; | |
365 | $sql = $this->buildQuery(FALSE); | |
366 | $sql = str_replace("entity_log_civireport.log_type as", "'{$entity}' as", $sql); | |
1e130d2a | 367 | $sql = "INSERT IGNORE INTO {$this->temporaryTableName} {$sql}"; |
63dc1f23 | 368 | CRM_Core_DAO::disableFullGroupByMode(); |
369 | CRM_Core_DAO::executeQuery($sql); | |
370 | CRM_Core_DAO::reenableFullGroupByMode(); | |
371 | $this->addToDeveloperTab($sql); | |
372 | } | |
373 | } | |
374 | ||
375 | $this->currentLogTable = ''; | |
376 | ||
377 | // add computed log_type column so that we can do a group by after that, which will help | |
378 | // alterDisplay() counts sync with pager counts | |
1e130d2a | 379 | $sql = "SELECT DISTINCT log_type FROM {$this->temporaryTableName}"; |
63dc1f23 | 380 | $dao = CRM_Core_DAO::executeQuery($sql); |
381 | $this->addToDeveloperTab($sql); | |
be2fb01f | 382 | $replaceWith = []; |
63dc1f23 | 383 | while ($dao->fetch()) { |
384 | $type = $this->getLogType($dao->log_type); | |
385 | if (!array_key_exists($type, $replaceWith)) { | |
be2fb01f | 386 | $replaceWith[$type] = []; |
63dc1f23 | 387 | } |
388 | $replaceWith[$type][] = $dao->log_type; | |
389 | } | |
390 | foreach ($replaceWith as $type => $tables) { | |
391 | if (!empty($tables)) { | |
392 | $replaceWith[$type] = implode("','", $tables); | |
393 | } | |
394 | } | |
395 | ||
1e130d2a | 396 | $sql = "ALTER TABLE {$this->temporaryTableName} ADD COLUMN log_civicrm_entity_log_type_label varchar(64)"; |
63dc1f23 | 397 | CRM_Core_DAO::executeQuery($sql); |
398 | $this->addToDeveloperTab($sql); | |
399 | foreach ($replaceWith as $type => $in) { | |
1e130d2a | 400 | $sql = "UPDATE {$this->temporaryTableName} SET log_civicrm_entity_log_type_label='{$type}', log_date=log_date WHERE log_type IN('$in')"; |
63dc1f23 | 401 | CRM_Core_DAO::executeQuery($sql); |
402 | $this->addToDeveloperTab($sql); | |
403 | } | |
404 | $this->logTypeTableClause = $logTypeTableClause; | |
405 | } | |
406 | ||
407 | /** | |
408 | * Common processing, also via api/unit tests. | |
409 | */ | |
410 | public function beginPostProcessCommon() { | |
411 | parent::beginPostProcessCommon(); | |
412 | $this->buildTemporaryTables(); | |
413 | } | |
414 | ||
65ec4c8c | 415 | /** |
416 | * Build the report query. | |
417 | * | |
418 | * We override this in order to be able to run from the api. | |
419 | * | |
420 | * @param bool $applyLimit | |
421 | * | |
422 | * @return string | |
423 | */ | |
424 | public function buildQuery($applyLimit = TRUE) { | |
425 | if (!$this->logTypeTableClause) { | |
426 | return parent::buildQuery($applyLimit); | |
427 | } | |
428 | // note the group by columns are same as that used in alterDisplay as $newRows - $key | |
429 | $this->limit(); | |
430 | $this->orderBy(); | |
431 | $sql = "{$this->_select} | |
1e130d2a | 432 | FROM {$this->temporaryTableName} entity_log_civireport |
65ec4c8c | 433 | WHERE {$this->logTypeTableClause} |
434 | GROUP BY log_civicrm_entity_log_date, log_civicrm_entity_log_type_label, log_civicrm_entity_log_conn_id, log_civicrm_entity_log_user_id, log_civicrm_entity_altered_contact_id, log_civicrm_entity_log_grouping | |
435 | {$this->_orderBy} | |
436 | {$this->_limit} "; | |
437 | $sql = str_replace('modified_contact_civireport.display_name', 'entity_log_civireport.altered_contact', $sql); | |
438 | $sql = str_replace('modified_contact_civireport.id', 'entity_log_civireport.altered_contact_id', $sql); | |
be2fb01f | 439 | $sql = str_replace([ |
65ec4c8c | 440 | 'modified_contact_civireport.', |
441 | 'altered_by_contact_civireport.', | |
be2fb01f | 442 | ], 'entity_log_civireport.', $sql); |
65ec4c8c | 443 | return $sql; |
444 | } | |
445 | ||
63dc1f23 | 446 | /** |
447 | * Build output rows. | |
448 | * | |
449 | * @param string $sql | |
450 | * @param array $rows | |
451 | */ | |
452 | public function buildRows($sql, &$rows) { | |
453 | parent::buildRows($sql, $rows); | |
454 | // Clean up the temp table - mostly for the unit test. | |
1e130d2a | 455 | $this->temporaryTable->drop(); |
63dc1f23 | 456 | } |
457 | ||
6a488035 | 458 | } |