← All changes | back/Classes/HistoryClass.php +124 -0 11.1.1 → 11.1.0 View file →

		@@ -1,0 +1,124 @@
	1	+<?php
	2	+
	3	+namespace AcyMailing\Classes;
	4	+
	5	+use AcyMailing\Core\AcymClass;
	6	+
	7	+class HistoryClass extends AcymClass
	8	+{
	9	+ public function __construct()
	10	+ {
	11	+ parent::__construct();
	12	+
	13	+ $this->table = 'history';
	14	+ }
	15	+
	16	+ /**
	17	+ * Function insert to insert a line into the history...
	18	+ * User modification, user update, bounces... etc.
	19	+ */
	20	+ public function insert(int $userId, string $action, array $data = [], int $mailid = 0, $unsubscribe_reason = null): void
	21	+ {
	22	+ $currentUserid = acym_currentUserId();
	23	+ if (!empty($currentUserid)) {
	24	+ $data[] = acym_translation('EXECUTED_BY').'::'.$currentUserid.' ( '.acym_currentUserName().' )';
	25	+ }
	26	+ $history = new \stdClass();
	27	+ $history->user_id = intval($userId);
	28	+ $history->action = acym_stripTags($action);
	29	+ $history->data = implode("\n", $data);
	30	+ $history->unsubscribe_reason = $unsubscribe_reason;
	31	+ //Avoid a memory issue when the data is way too big.
	32	+ if (strlen($history->data) > 100000) {
	33	+ $history->data = substr($history->data, 0, 10000);
	34	+ }
	35	+
	36	+ static $date = null;
	37	+ if (empty($date)) {
	38	+ $date = time();
	39	+ }
	40	+
	41	+ $history->date = ++$date;
	42	+ while ($this->alreadyExists($history->user_id, $history->date)) {
	43	+ $history->date++;
	44	+ }
	45	+
	46	+ $date = $history->date;
	47	+
	48	+ $history->mail_id = $mailid;
	49	+ $history->ip = acym_getIP();
	50	+
	51	+ if (!empty($_SERVER) && empty($this->config->get('anonymous_stats', 0))) {
	52	+ $source = [];
	53	+ $vars = [
	54	+ 'HTTP_REFERER',
	55	+ 'HTTP_USER_AGENT',
	56	+ 'HTTP_HOST',
	57	+ 'SERVER_ADDR',
	58	+ 'REMOTE_ADDR',
	59	+ 'REQUEST_URI',
	60	+ 'QUERY_STRING',
	61	+ ];
	62	+
	63	+ foreach ($vars as $oneVar) {
	64	+ $remoteIp = acym_getVar('string', $oneVar, '', 'SERVER');
	65	+ if (!empty($remoteIp)) {
	66	+ $source[] = $oneVar.'::'.acym_stripTags($remoteIp);
	67	+ }
	68	+ }
	69	+ $history->source = implode("\n", $source);
	70	+ }
	71	+
	72	+ try {
	73	+ acym_insertObject('#__acym_history', $history);
	74	+ } catch (\Exception $e) {
	75	+ }
	76	+ }
	77	+
	78	+ private function alreadyExists(int $userId, int $time): bool
	79	+ {
	80	+ $result = acym_loadResult('SELECT user_id FROM #__acym_history WHERE user_id = '.intval($userId).' AND date = '.intval($time));
	81	+
	82	+ return !empty($result);
	83	+ }
	84	+
	85	+ /**
	86	+ * Get all history lines for one user order by date descending
	87	+ */
	88	+ public function getHistoryOfOneById(int $userId): array
	89	+ {
	90	+ return acym_loadObjectList(
	91	+ 'SELECT h.*, m.id, m.subject FROM #__acym_history AS h
	92	+ LEFT JOIN #__acym_mail AS m ON h.mail_id = m.id
	93	+ WHERE h.user_id = '.intval($userId).'
	94	+ ORDER BY h.date DESC'
	95	+ );
	96	+ }
	97	+
	98	+ public function getAllUnsubReasons(): array
	99	+ {
	100	+ $query = 'SELECT `action`, `data`, `unsubscribe_reason` FROM #__acym_history WHERE `action` = "unsubscribed" AND `unsubscribe_reason` != ""';
	101	+
	102	+ return acym_loadObjectList($query);
	103	+ }
	104	+
	105	+ public function getAllMainLanguageUnsubReasons(): array
	106	+ {
	107	+ $allUnsubReasons = $this->config->get('unsub_survey', '{}');
	108	+
	109	+ return json_decode($allUnsubReasons, true);
	110	+ }
	111	+
	112	+ public function getUnsubscribeReasonText($index)
	113	+ {
	114	+ $surveyAnswers = json_decode($this->config->get('unsub_survey'), true);
	115	+ if (is_numeric($index)) {
	116	+ $index = $index - 1;
	117	+ $reason = $surveyAnswers[$index] ?? $index;
	118	+ } else {
	119	+ $reason = $index;
	120	+ }
	121	+
	122	+ return $reason;
	123	+ }
	124	+}