acymailing / back / Controllers / Stats / Detailed.php

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

105 lines 4.1 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	wp_verify_nonce(acym_getVar('cmd', '_wpnonce'), 'acymnonce') \|\| die('Invalid Token');
35
36	$exportHelper = new ExportHelper();
37	$data = [];
38	$this->prepareDefaultPageInfo($data);
39
40	$where = '';
41	if (!empty($this->selectedMailIds)) {
42	$where = 'WHERE userstat.`mail_id` IN ('.implode(',', $this->selectedMailIds).')';
43	}
44
45	$groupBy = ' GROUP BY userstat.mail_id, userstat.user_id ';
46
47	$columnsMailStat = acym_getColumns('user_stat');
48	$columnsToExport = [];
49
50	$columnsToExport['mail.subject'] = acym_translation('ACYM_EMAIL_SUBJECT');
51	$columnsToExport['user.email'] = acym_translation('ACYM_USER_EMAIL');
52	$columnsToExport['user.name'] = acym_translation('ACYM_USER_NAME');
53	foreach ($columnsMailStat as $column) {
54	if (in_array($column, ['user_id', 'mail_id'])) continue;
55	$trad = acym_translation('ACYM_'.strtoupper($column).'_COLUMN_STAT');
56	if ($column === 'send_date') $trad = acym_translation('ACYM_SEND_DATE');
57	if ($column === 'open') $trad = acym_translation('ACYM_OPEN_TOTAL_COLUMN_STAT');
58	if ($column === 'bounce') $trad = acym_translation('ACYM_BOUNCE_UNIQUE_COLUMN_STAT');
59	$columnsToExport['userstat.'.$column] = $trad;
60	}
61
62	$query = 'SELECT '.implode(', ', array_keys($columnsToExport)).', SUM(urlclick.click) AS click FROM #__acym_user_stat AS userstat
63	LEFT JOIN #__acym_user AS user ON user.id = userstat.user_id
64	LEFT JOIN #__acym_mail AS mail ON mail.id = userstat.mail_id
65	LEFT JOIN #__acym_url_click AS urlclick ON urlclick.user_id = userstat.user_id AND userstat.mail_id = urlclick.mail_id '.$where.$groupBy;
66	$columnsToExport['urlclick.click'] = acym_translation('ACYM_TOTAL_CLICK');
67	$exportHelper->exportStatsFullCSV($query, $columnsToExport, 'detailed');
68	exit;
69	}
70
71	private function prepareDetailedListing(array &$data): void
72	{
73	$data['search'] = $this->getVarFiltersListing('string', 'detailed_stats_search', '');
74	$data['ordering'] = $this->getVarFiltersListing('cmd', 'detailed_stats_ordering', 'send_date');
75	$data['orderingSortOrder'] = $this->getVarFiltersListing('cmd', 'detailed_stats_ordering_sort_order', 'desc');
76
77	if (empty($this->selectedMailIds)) {
78	return;
79	}
80
81	$userStatClass = new UserStatClass();
82	$pagination = new PaginationHelper();
83
84	$detailedStatsPerPage = $pagination->getListLimit();
85	$page = $this->getVarFiltersListing('int', 'detailed_stats_pagination_page', 1);
86
87	$matchingDetailedStats = $userStatClass->getDetailedStats(
88	[
89	'ordering' => $data['ordering'],
90	'ordering_sort_order' => $data['orderingSortOrder'],
91	'search' => $data['search'],
92	'detailedStatsPerPage' => $detailedStatsPerPage,
93	'offset' => ($page - 1) * $detailedStatsPerPage,
94	'mail_ids' => $this->selectedMailIds,
95	]
96	);
97
98	// Prepare the pagination
99	$pagination->setStatus((int)$matchingDetailedStats['total']->total, $page, $detailedStatsPerPage);
100
101	$data['pagination'] = $pagination;
102	$data['detailed_stats'] = $matchingDetailedStats['detailed_stats'];
103	}
104	}
105