| @@ -1,65 +1,0 @@ | ||
| 1 | -<?php | |
| 2 | - | |
| 3 | -namespace AcyMailing\Classes; | |
| 4 | - | |
| 5 | -use AcyMailing\Core\AcymClass; | |
| 6 | - | |
| 7 | -class MailArchiveClass extends AcymClass | |
| 8 | -{ | |
| 9 | - public function __construct() | |
| 10 | - { | |
| 11 | - parent::__construct(); | |
| 12 | - | |
| 13 | - $this->table = 'mail_archive'; | |
| 14 | - $this->pkey = 'id'; | |
| 15 | - } | |
| 16 | - | |
| 17 | - public function save(object $element): ?int | |
| 18 | - { | |
| 19 | - $mailArchive = clone $element; | |
| 20 | - | |
| 21 | - foreach ($mailArchive as $oneAttribute => $value) { | |
| 22 | - if (empty($value) || $oneAttribute === 'settings') { | |
| 23 | - continue; | |
| 24 | - } | |
| 25 | - | |
| 26 | - if (is_array($value)) { | |
| 27 | - $mailArchive->$oneAttribute = json_encode($value); | |
| 28 | - } | |
| 29 | - } | |
| 30 | - | |
| 31 | - return parent::save($mailArchive); | |
| 32 | - } | |
| 33 | - | |
| 34 | - public function getOneByMailId(int $mailId): ?object | |
| 35 | - { | |
| 36 | - $mailArchive = acym_loadObject('SELECT * FROM #__acym_mail_archive WHERE `mail_id` = '.intval($mailId)); | |
| 37 | - | |
| 38 | - return empty($mailArchive) ? null : $mailArchive; | |
| 39 | - } | |
| 40 | - | |
| 41 | - public function deleteArchivePeriod(): array | |
| 42 | - { | |
| 43 | - if (empty($this->config->get('delete_archive_history_enabled', 1))) { | |
| 44 | - return []; | |
| 45 | - } | |
| 46 | - | |
| 47 | - $deleteOverSecond = $this->config->get('delete_archive_history_after', 86400 * 90); | |
| 48 | - if (empty($deleteOverSecond)) { | |
| 49 | - return []; | |
| 50 | - } | |
| 51 | - | |
| 52 | - try { | |
| 53 | - $status = acym_query('DELETE FROM #__acym_mail_archive WHERE `date` < '.intval(time() - $deleteOverSecond)); | |
| 54 | - $message = empty($status) ? '' : acym_translationSprintf('ACYM_DELETE_X_ROWS_TABLE_X', $status, strtolower(acym_translation('ACYM_EMAIL_ARCHIVE_HISTORY'))); | |
| 55 | - } catch (\Exception $e) { | |
| 56 | - $status = false; | |
| 57 | - $message = $e->getMessage(); | |
| 58 | - } | |
| 59 | - | |
| 60 | - return [ | |
| 61 | - 'status' => $status !== false, | |
| 62 | - 'message' => $message, | |
| 63 | - ]; | |
| 64 | - } | |
| 65 | -} | |