← All changes | back/Classes/UrlClass.php +114 -0 10.1.0 → 11.1.0 View file →

		@@ -1,0 +1,114 @@
	1	+<?php
	2	+
	3	+namespace AcyMailing\Classes;
	4	+
	5	+use AcyMailing\Core\AcymClass;
	6	+
	7	+class UrlClass extends AcymClass
	8	+{
	9	+ public function __construct()
	10	+ {
	11	+ parent::__construct();
	12	+
	13	+ $this->table = 'url';
	14	+ $this->pkey = 'id';
	15	+ }
	16	+
	17	+ public function save(object $url): ?int
	18	+ {
	19	+ if (empty($url)) {
	20	+ return null;
	21	+ }
	22	+
	23	+ foreach ($url as $oneAttribute => $value) {
	24	+ if (empty($value)) {
	25	+ continue;
	26	+ }
	27	+
	28	+ $url->$oneAttribute = acym_stripTags($value);
	29	+ }
	30	+
	31	+ return parent::save($url);
	32	+ }
	33	+
	34	+ public function getOneUrlById(int $id): ?object
	35	+ {
	36	+ $url = acym_loadObject('SELECT * FROM #__acym_url WHERE `id` = '.intval($id));
	37	+
	38	+ return empty($url) ? null : $url;
	39	+ }
	40	+
	41	+ public function getUrl(string $url, int $mailid, int $userid, string $userkey = ''): string
	42	+ {
	43	+ if (empty($url) || empty($mailid) || empty($userid)) {
	44	+ return '';
	45	+ }
	46	+
	47	+ static $allurls;
	48	+
	49	+ $url = str_replace('&amp;', '&', $url);
	50	+
	51	+ if (empty($allurls[$url])) {
	52	+ $allurls[$url] = $this->getAdd($url);
	53	+ }
	54	+
	55	+ if (empty($allurls[$url]->id)) {
	56	+ return $url;
	57	+ }
	58	+
	59	+ $trackingUrl = acym_frontendLink('fronturl&task=click&urlid='.$allurls[$url]->id.'&userid='.$userid.'&mailid='.$mailid);
	60	+
	61	+ if (!empty($userkey)) {
	62	+ $trackingUrl .= (strpos($trackingUrl, '?') === false ? '?' : '&').'userkey='.urlencode($userkey);
	63	+ }
	64	+
	65	+ return $trackingUrl;
	66	+ }
	67	+
	68	+ // Used in checkDB to address a bug before the 12/04/19
	69	+ public function getDuplicatedUrls(): array
	70	+ {
	71	+ return acym_loadResultArray(
	72	+ 'SELECT DISTINCT duplicates.id
	73	+ FROM #__acym_url AS duplicates
	74	+ JOIN #__acym_url AS original ON duplicates.url = original.url
	75	+ JOIN #__acym_url_click AS clickoriginal ON original.id = clickoriginal.url_id
	76	+ LEFT JOIN #__acym_url_click AS click ON duplicates.id = click.url_id
	77	+ WHERE click.url_id IS NULL
	78	+ LIMIT 500'
	79	+ );
	80	+ /*
	81	+ To clean the potential duplicated rows in the #__acym_url table, you can execute this query when no email is being sent:
	82	+ DELETE url.*
	83	+ FROM #__acym_url AS url
	84	+ LEFT JOIN #__acym_url_click AS urlclick ON url.id = urlclick.url_id
	85	+ WHERE urlclick.url_id IS NULL
	86	+
	87	+ If an email is currently being sent, exclude its urls from the delete query
	88	+ */
	89	+ }
	90	+
	91	+ private function getAdd(string $url): ?object
	92	+ {
	93	+ $currentUrl = $this->getOneByUrl($url);
	94	+ if (empty($currentUrl->id)) {
	95	+ $currentUrl = new \stdClass();
	96	+ $currentUrl->name = $url;
	97	+ $currentUrl->url = $url;
	98	+ $currentUrl->id = $this->save($currentUrl);
	99	+
	100	+ if (empty($currentUrl->id)) {
	101	+ return null;
	102	+ }
	103	+ }
	104	+
	105	+ return $currentUrl;
	106	+ }
	107	+
	108	+ private function getOneByUrl(string $url): ?object
	109	+ {
	110	+ $url = acym_loadObject('SELECT * FROM #__acym_url WHERE `url` = '.acym_escapeDB($url));
	111	+
	112	+ return empty($url) ? null : $url;
	113	+ }
	114	+}