← All changes | back/Classes/MailArchiveClass.php +65 -0 10.2.0 → 11.1.0 View file →

		@@ -1,0 +1,65 @@
	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	+}