acymailing / back / Controllers / Stats / Detailed.php

Detailed.php in AcyMailing – An Ultimate Newsletter Plugin and Marketing Automation Solution for WordPress 10.2.2, at back/Controllers/Stats/Detailed.php

102 lines 4.0 KB

Raw Download Zip

1	<?php
2
3	namespace AcyMailing\Controllers\Stats;
4
5	use AcyMailing\Classes\UserStatClass;
6	use AcyMailing\Helpers\ExportHelper;
7	use AcyMailing\Helpers\PaginationHelper;
8
9	trait Detailed
10	{
11	public function detailedStats(): void
12	{
13	acym_setVar('layout', 'detailed_stats');
14
15	$data = [];
16
17	$this->prepareDefaultPageInfo($data);
18
19	$this->prepareDetailedListing($data);
20	if (count($this->selectedMailIds) == 1) {
21	if ($data['isAbTest']) {
22	$this->prepareAbTestMails($data);
23	} elseif (acym_isMultilingual()) {
24	$this->prepareMultilingualMails($data);
25	}
26	}
27	$this->prepareMailFilter($data);
28
29	parent::display($data);
30	}
31
32	public function exportDetailed(): void
33	{
34	$exportHelper = new ExportHelper();
35	$data = [];
36	$this->prepareDefaultPageInfo($data);
37
38	$where = '';
39	if (!empty($this->selectedMailIds)) {
40	$where = 'WHERE userstat.`mail_id` IN ('.implode(',', $this->selectedMailIds).')';
41	}
42
43	$groupBy = ' GROUP BY userstat.mail_id, userstat.user_id ';
44
45	$columnsMailStat = acym_getColumns('user_stat');
46	$columnsToExport = [];
47
48	$columnsToExport['mail.subject'] = acym_translation('ACYM_EMAIL_SUBJECT');
49	$columnsToExport['user.email'] = acym_translation('ACYM_USER_EMAIL');
50	$columnsToExport['user.name'] = acym_translation('ACYM_USER_NAME');
51	foreach ($columnsMailStat as $column) {
52	if (in_array($column, ['user_id', 'mail_id'])) continue;
53	$trad = acym_translation('ACYM_'.strtoupper($column).'_COLUMN_STAT');
54	if ($column == 'send_date') $trad = acym_translation('ACYM_SEND_DATE');
55	if ($column == 'open') $trad = acym_translation('ACYM_OPEN_TOTAL_COLUMN_STAT');
56	if ($column == 'bounce') $trad = acym_translation('ACYM_BOUNCE_UNIQUE_COLUMN_STAT');
57	$columnsToExport['userstat.'.$column] = $trad;
58	}
59
60	$query = 'SELECT '.implode(', ', array_keys($columnsToExport)).', SUM(urlclick.click) AS click FROM #__acym_user_stat AS userstat
61	LEFT JOIN #__acym_user AS user ON user.id = userstat.user_id
62	LEFT JOIN #__acym_mail AS mail ON mail.id = userstat.mail_id
63	LEFT JOIN #__acym_url_click AS urlclick ON urlclick.user_id = userstat.user_id AND userstat.mail_id = urlclick.mail_id '.$where.$groupBy;
64	$columnsToExport['urlclick.click'] = acym_translation('ACYM_TOTAL_CLICK');
65	$exportHelper->exportStatsFullCSV($query, $columnsToExport, 'detailed');
66	exit;
67	}
68
69	private function prepareDetailedListing(array &$data): void
70	{
71	$data['search'] = $this->getVarFiltersListing('string', 'detailed_stats_search', '');
72	$data['ordering'] = $this->getVarFiltersListing('string', 'detailed_stats_ordering', 'send_date');
73	$data['orderingSortOrder'] = $this->getVarFiltersListing('string', 'detailed_stats_ordering_sort_order', 'desc');
74
75	if (empty($this->selectedMailIds)) {
76	return;
77	}
78
79	$userStatClass = new UserStatClass();
80	$pagination = new PaginationHelper();
81
82	$detailedStatsPerPage = $pagination->getListLimit();
83	$page = $this->getVarFiltersListing('int', 'detailed_stats_pagination_page', 1);
84
85	$matchingDetailedStats = $userStatClass->getDetailedStats(
86	[
87	'ordering' => $data['ordering'],
88	'ordering_sort_order' => $data['orderingSortOrder'],
89	'search' => $data['search'],
90	'detailedStatsPerPage' => $detailedStatsPerPage,
91	'offset' => ($page - 1) * $detailedStatsPerPage,
92	'mail_ids' => $this->selectedMailIds,
93	]
94	);
95
96	$pagination->setStatus((int)$matchingDetailedStats['total']->total, $page, $detailedStatsPerPage);
97
98	$data['pagination'] = $pagination;
99	$data['detailed_stats'] = $matchingDetailedStats['detailed_stats'];
100	}
101	}
102