| @@ -1,944 +1,0 @@ | ||
| 1 | -<?php | |
| 2 | - | |
| 3 | -namespace AcyMailing\Controllers\Stats; | |
| 4 | - | |
| 5 | -use AcyMailing\Classes\CampaignClass; | |
| 6 | -use AcyMailing\Classes\MailClass; | |
| 7 | -use AcyMailing\Classes\MailStatClass; | |
| 8 | -use AcyMailing\Classes\UrlClickClass; | |
| 9 | -use AcyMailing\Classes\UserStatClass; | |
| 10 | -use AcyMailing\Helpers\ExportHelper; | |
| 11 | -use AcyMailing\Helpers\MailerHelper; | |
| 12 | -use AcyMailing\Helpers\PaginationHelper; | |
| 13 | -use AcyMailing\Helpers\WorkflowHelper; | |
| 14 | -use AcyMailing\Libraries\Browser\BrowserDetection; | |
| 15 | -use AcyMailing\Classes\UserClass; | |
| 16 | - | |
| 17 | -trait GlobalStats | |
| 18 | -{ | |
| 19 | - public function globalStats(): void | |
| 20 | - { | |
| 21 | - acym_setVar('layout', 'global_stats'); | |
| 22 | - | |
| 23 | - $data = []; | |
| 24 | - | |
| 25 | - $this->prepareDefaultPageInfo($data); | |
| 26 | - | |
| 27 | - $this->prepareOpenTimeChart($data); | |
| 28 | - $this->preparecharts($data); | |
| 29 | - $this->prepareListReceivers($data); | |
| 30 | - $this->prepareDefaultLineChart($data); | |
| 31 | - $this->prepareDefaultDevicesChart($data); | |
| 32 | - $this->prepareDefaultBrowsersChart($data); | |
| 33 | - if (count($this->selectedMailIds) == 1) { | |
| 34 | - if ($data['isAbTest']) { | |
| 35 | - $this->prepareAbTestMails($data); | |
| 36 | - } elseif (acym_isMultilingual()) { | |
| 37 | - $this->prepareMultilingualMails($data); | |
| 38 | - } | |
| 39 | - } | |
| 40 | - $this->prepareMailFilter($data); | |
| 41 | - | |
| 42 | - parent::display($data); | |
| 43 | - } | |
| 44 | - | |
| 45 | - private function prepareMailFilter(array &$data): void | |
| 46 | - { | |
| 47 | - $data['input_mail_ids'] = ''; | |
| 48 | - | |
| 49 | - if (!empty($this->multiLanguageMailAdded) || !empty($this->generatedMailAdded)) { | |
| 50 | - $this->selectedMailIds = array_filter( | |
| 51 | - $this->selectedMailIds, | |
| 52 | - function ($mailId) { | |
| 53 | - return !in_array($mailId, $this->multiLanguageMailAdded) && !in_array($mailId, $this->generatedMailAdded); | |
| 54 | - } | |
| 55 | - ); | |
| 56 | - } | |
| 57 | - | |
| 58 | - if (count($this->selectedMailIds) > 1) { | |
| 59 | - $data['input_mail_ids'] = '<input type="hidden" value="'.implode(',', $this->selectedMailIds).'" name="mail_ids">'; | |
| 60 | - } | |
| 61 | - | |
| 62 | - $attributes = [ | |
| 63 | - 'class' => 'acym__select acym_select2_ajax acym__stats__select__mails', | |
| 64 | - 'data-placeholder' => acym_translation('ACYM_ALL_EMAILS'), | |
| 65 | - 'data-ctrl' => 'stats', | |
| 66 | - 'data-task' => 'searchSentMail', | |
| 67 | - 'data-min' => '0', | |
| 68 | - 'id' => 'mail_ids', | |
| 69 | - ]; | |
| 70 | - | |
| 71 | - if (!empty($this->selectedMailIds)) { | |
| 72 | - $attributes['data-selected'] = implode(',', $this->selectedMailIds); | |
| 73 | - } | |
| 74 | - | |
| 75 | - $data['mail_filter_options'] = $attributes; | |
| 76 | - $data['emailVersionsFilters'] = []; | |
| 77 | - | |
| 78 | - if (!empty($data['emailVersions'])) { | |
| 79 | - $data['emailVersionsFilters'] = [ | |
| 80 | - 'options' => $data['emailVersions'], | |
| 81 | - 'mailId' => $this->selectedMailIds[0], | |
| 82 | - ]; | |
| 83 | - } | |
| 84 | - if (!empty($data['emailTranslations'])) { | |
| 85 | - $data['emailVersionsFilters'] = [ | |
| 86 | - 'options' => $data['emailTranslations'], | |
| 87 | - 'mailId' => $this->selectedMailIds[0], | |
| 88 | - ]; | |
| 89 | - } | |
| 90 | - } | |
| 91 | - | |
| 92 | - private function prepareClickStats(array &$data): void | |
| 93 | - { | |
| 94 | - if (empty($data['selectedMailid'])) { | |
| 95 | - return; | |
| 96 | - } | |
| 97 | - | |
| 98 | - $urlClickClass = new UrlClickClass(); | |
| 99 | - $allClickInfo = $urlClickClass->getAllLinkFromEmail($this->selectedMailIds[0]); | |
| 100 | - | |
| 101 | - $data['url_click'] = []; | |
| 102 | - $data['url_click']['allClick'] = $allClickInfo['allClick']; | |
| 103 | - | |
| 104 | - $allPercentage = []; | |
| 105 | - foreach ($allClickInfo['urls_click'] as $url) { | |
| 106 | - $percentage = 0; | |
| 107 | - if (empty($url->click)) { | |
| 108 | - $data['url_click'][$url->name] = ['percentage' => $percentage, 'numberClick' => '0']; | |
| 109 | - } else { | |
| 110 | - $percentage = intval(($url->click * 100) / $allClickInfo['allClick']); | |
| 111 | - $data['url_click'][$url->name] = ['percentage' => $percentage, 'numberClick' => $url->click]; | |
| 112 | - } | |
| 113 | - $allPercentage[] = $percentage; | |
| 114 | - } | |
| 115 | - | |
| 116 | - $helperMailer = new MailerHelper(); | |
| 117 | - if (!empty($data['mailInformation'])) { | |
| 118 | - $helperMailer->body = $data['mailInformation']->body; | |
| 119 | - $helperMailer->statClick(intval($data['mailInformation']->id), 0, true); | |
| 120 | - $data['mailInformation']->body = preg_replace('#&(amp;)?autoSubId=[^"]+"#Uis', '"', $helperMailer->body); | |
| 121 | - } | |
| 122 | - | |
| 123 | - if (!empty($allPercentage)) { | |
| 124 | - $maxPercentage = max($allPercentage); | |
| 125 | - | |
| 126 | - foreach ($data['url_click'] as $name => $val) { | |
| 127 | - if ($name === 'allClick') continue; | |
| 128 | - $percentageRecalc = intval(($val['percentage'] * 100) / $maxPercentage); | |
| 129 | - if ($percentageRecalc <= 33) { | |
| 130 | - $data['url_click'][$name]['color'] = '0, 164, 255'; | |
| 131 | - } elseif ($percentageRecalc <= 66) { | |
| 132 | - $data['url_click'][$name]['color'] = '248, 31, 255'; | |
| 133 | - } else { | |
| 134 | - $data['url_click'][$name]['color'] = '255, 82, 89'; | |
| 135 | - } | |
| 136 | - } | |
| 137 | - } | |
| 138 | - | |
| 139 | - $data['url_click'] = json_encode($data['url_click']); | |
| 140 | - | |
| 141 | - $data['url_foundation_email'] = ACYM_CSS.'libraries/foundation_email.min.css?v='.filemtime(ACYM_MEDIA.'css'.DS.'libraries'.DS.'foundation_email.min.css'); | |
| 142 | - $data['url_click_map_email'] = ACYM_CSS.'click_map.min.css?v='.filemtime(ACYM_MEDIA.'css'.DS.'click_map.min.css'); | |
| 143 | - } | |
| 144 | - | |
| 145 | - public function prepareDefaultLineChart(array &$data): void | |
| 146 | - { | |
| 147 | - $data['example_line_chart'] = [ | |
| 148 | - 'month' => [ | |
| 149 | - 'Jan 18' => ['open' => '150', 'click' => '40'], | |
| 150 | - ], | |
| 151 | - 'day' => [ | |
| 152 | - '23 Jan' => ['open' => '150', 'click' => '40'], | |
| 153 | - ], | |
| 154 | - 'hour' => [ | |
| 155 | - '23 Jan' => ['open' => '150', 'click' => '40'], | |
| 156 | - '23 Jan 08:00' => ['open' => '25', 'click' => '10'], | |
| 157 | - '23 Jan 09:00' => ['open' => '50', 'click' => '10'], | |
| 158 | - '23 Jan 10:00' => ['open' => '16', 'click' => '10'], | |
| 159 | - '23 Jan 11:00' => ['open' => '59', 'click' => '10'], | |
| 160 | - ], | |
| 161 | - ]; | |
| 162 | - } | |
| 163 | - | |
| 164 | - public function prepareDefaultDevicesChart(array &$data): void | |
| 165 | - { | |
| 166 | - $data['example_devices_chart'] = [ | |
| 167 | - 'ACYM_MOBILE' => 25662, | |
| 168 | - 'ACYM_DESKTOP' => 12471, | |
| 169 | - 'ACYM_OTHER' => 3548, | |
| 170 | - 'ACYM_UNKNOWN' => 6213, | |
| 171 | - ]; | |
| 172 | - } | |
| 173 | - | |
| 174 | - public function prepareDefaultBrowsersChart(array &$data): void | |
| 175 | - { | |
| 176 | - $data['example_source_chart'] = [ | |
| 177 | - 'Apple Mail' => 15835, | |
| 178 | - 'Google Chrome' => 13375, | |
| 179 | - 'Safari' => 2667, | |
| 180 | - 'Outlook' => 2458, | |
| 181 | - 'Edge' => 1190, | |
| 182 | - 'Firefox' => 826, | |
| 183 | - 'ACYM_OTHER' => 4775, | |
| 184 | - 'ACYM_UNKNOWN' => 6123, | |
| 185 | - ]; | |
| 186 | - } | |
| 187 | - | |
| 188 | - public function setDataForChartLine(): void | |
| 189 | - { | |
| 190 | - $newStart = acym_date(acym_getVar('string', 'start'), 'Y-m-d H:i:s'); | |
| 191 | - $newEnd = acym_date(acym_getVar('string', 'end'), 'Y-m-d H:i:s'); | |
| 192 | - $mailIds = acym_getVar('int', 'id'); | |
| 193 | - | |
| 194 | - if (empty($mailIds)) { | |
| 195 | - $mailIds = []; | |
| 196 | - } | |
| 197 | - | |
| 198 | - $mailClass = new MailClass(); | |
| 199 | - if (!empty($mailIds)) { | |
| 200 | - $mailIds = $mailClass->getAutomaticMailIds($mailIds); | |
| 201 | - } | |
| 202 | - | |
| 203 | - if (!empty($mailIds) && !is_array($mailIds)) { | |
| 204 | - $mailIds = [$mailIds]; | |
| 205 | - } | |
| 206 | - | |
| 207 | - if ($newStart >= $newEnd) { | |
| 208 | - echo 'error'; | |
| 209 | - exit; | |
| 210 | - } | |
| 211 | - | |
| 212 | - $statsCampaignSelected = new \stdClass(); | |
| 213 | - $this->prepareLineChart($statsCampaignSelected, $mailIds, $newStart, $newEnd); | |
| 214 | - | |
| 215 | - acym_lineChart($statsCampaignSelected->month, $statsCampaignSelected->day, $statsCampaignSelected->hour, true); | |
| 216 | - exit; | |
| 217 | - } | |
| 218 | - | |
| 219 | - private function getValues(string $modifier, string $intervalCode, array $campaignOpens, array $campaignClicks, string $dateCode, bool $hour = false): array | |
| 220 | - { | |
| 221 | - $opens = []; | |
| 222 | - foreach ($campaignOpens as $one) { | |
| 223 | - if (!empty($one->open_date)) { | |
| 224 | - $opens[acym_date(acym_getTimeFromUTCDate($one->open_date), $dateCode)] = $one->open; | |
| 225 | - } | |
| 226 | - } | |
| 227 | - | |
| 228 | - $clicks = []; | |
| 229 | - foreach ($campaignClicks as $one) { | |
| 230 | - if (!empty($one->date_click)) { | |
| 231 | - $clicks[acym_date(acym_getTimeFromUTCDate($one->date_click), $dateCode)] = $one->click; | |
| 232 | - } | |
| 233 | - } | |
| 234 | - | |
| 235 | - $startDate = $campaignOpens[0]->open_date ?? null; | |
| 236 | - if (!empty($campaignClicks) && !empty($campaignClicks[0]->date_click)) { | |
| 237 | - $clickDate = $campaignClicks[0]->date_click; | |
| 238 | - if (!empty($startDate)) { | |
| 239 | - $startDate = min([$startDate, $clickDate]); | |
| 240 | - } else { | |
| 241 | - $startDate = $clickDate; | |
| 242 | - } | |
| 243 | - } | |
| 244 | - | |
| 245 | - $lastOpen = empty($campaignOpens) ? null : end($campaignOpens); | |
| 246 | - $endDate = $lastOpen->open_date ?? null; | |
| 247 | - if (!empty($campaignClicks)) { | |
| 248 | - $lastClick = end($campaignClicks); | |
| 249 | - $clickDate = $lastClick->date_click ?? null; | |
| 250 | - if (!empty($endDate) && !empty($clickDate)) { | |
| 251 | - $endDate = max([$endDate, $clickDate]); | |
| 252 | - } elseif (!empty($clickDate)) { | |
| 253 | - $endDate = $clickDate; | |
| 254 | - } | |
| 255 | - } | |
| 256 | - | |
| 257 | - if (empty($startDate) || empty($endDate)) { | |
| 258 | - return []; | |
| 259 | - } | |
| 260 | - | |
| 261 | - // Apply timezone for chart by hour | |
| 262 | - if ($modifier === 'min') { | |
| 263 | - $startDate = acym_date(acym_getTimeFromUTCDate($startDate), 'Y-m-d H:i:s'); | |
| 264 | - $endDate = acym_date(acym_getTimeFromUTCDate($endDate), 'Y-m-d H:i:s'); | |
| 265 | - } | |
| 266 | - | |
| 267 | - $begin = new \DateTime($startDate); | |
| 268 | - $end = new \DateTime($endDate); | |
| 269 | - | |
| 270 | - $end->modify('+1 '.$modifier); | |
| 271 | - | |
| 272 | - $interval = new \DateInterval($intervalCode); | |
| 273 | - $daterange = new \DatePeriod($begin, $interval, $end); | |
| 274 | - | |
| 275 | - $result = []; | |
| 276 | - foreach ($daterange as $date) { | |
| 277 | - $one = $date->format($dateCode); | |
| 278 | - | |
| 279 | - $current = []; | |
| 280 | - $current['open'] = empty($opens[$one]) ? 0 : $opens[$one]; | |
| 281 | - $current['click'] = empty($clicks[$one]) ? 0 : $clicks[$one]; | |
| 282 | - | |
| 283 | - $key = $hour ? $one.':00' : $one; | |
| 284 | - $result[$key] = $current; | |
| 285 | - } | |
| 286 | - | |
| 287 | - return $result; | |
| 288 | - } | |
| 289 | - | |
| 290 | - public function prepareLineChart(object &$statsCampaignSelected, array $mailIdsOfCampaign, string $newStart = '', string $newEnd = ''): void | |
| 291 | - { | |
| 292 | - $statsCampaignSelected->hasStats = true; | |
| 293 | - $anonymousStats = !empty($this->config->get('anonymous_stats', 0)); | |
| 294 | - | |
| 295 | - //We get the opening by month, day, hour | |
| 296 | - if ($anonymousStats) { | |
| 297 | - $mailStatClass = new MailStatClass(); | |
| 298 | - $campaignOpenByMonth = $mailStatClass->getAnonOpensByFormat($mailIdsOfCampaign, '%Y-%m', $newStart, $newEnd); | |
| 299 | - $campaignOpenByDay = $mailStatClass->getAnonOpensByFormat($mailIdsOfCampaign, '%Y-%m-%d', $newStart, $newEnd); | |
| 300 | - $campaignOpenByHour = $mailStatClass->getAnonOpensByFormat($mailIdsOfCampaign, '%Y-%m-%d %H:00:00', $newStart, $newEnd); | |
| 301 | - } else { | |
| 302 | - $campaignClass = new CampaignClass(); | |
| 303 | - $campaignOpenByMonth = $campaignClass->getOpenByMonth($mailIdsOfCampaign, $newStart, $newEnd); | |
| 304 | - $campaignOpenByDay = $campaignClass->getOpenByDay($mailIdsOfCampaign, $newStart, $newEnd); | |
| 305 | - $campaignOpenByHour = $campaignClass->getOpenByHour($mailIdsOfCampaign, $newStart, $newEnd); | |
| 306 | - } | |
| 307 | - | |
| 308 | - $urlClickClass = new UrlClickClass(); | |
| 309 | - $campaignClickByMonth = $urlClickClass->getAllClickByMailMonth($mailIdsOfCampaign, $newStart, $newEnd); | |
| 310 | - $campaignClickByDay = $urlClickClass->getAllClickByMailDay($mailIdsOfCampaign, $newStart, $newEnd); | |
| 311 | - $campaignClickByHour = $urlClickClass->getAllClickByMailHour($mailIdsOfCampaign, $newStart, $newEnd); | |
| 312 | - | |
| 313 | - // In anonymous mode a click doesn't register an open, and in any mode a link can be clicked without the open pixel firing: gating on opens alone wrongly hid the whole chart. | |
| 314 | - $hasOpens = !empty($campaignOpenByMonth) && !empty($campaignOpenByDay) && !empty($campaignOpenByHour); | |
| 315 | - $hasClicks = !empty($campaignClickByMonth) && !empty($campaignClickByDay) && !empty($campaignClickByHour); | |
| 316 | - if (!$hasOpens && !$hasClicks) { | |
| 317 | - $statsCampaignSelected->hasStats = false; | |
| 318 | - | |
| 319 | - return; | |
| 320 | - } | |
| 321 | - | |
| 322 | - $statsCampaignSelected->month = $this->getValues('day', 'P1M', $campaignOpenByMonth, $campaignClickByMonth, 'Y-m'); | |
| 323 | - $statsCampaignSelected->day = $this->getValues('hour', 'P1D', $campaignOpenByDay, $campaignClickByDay, 'Y-m-d'); | |
| 324 | - $statsCampaignSelected->hour = $this->getValues('min', 'PT1H', $campaignOpenByHour, $campaignClickByHour, 'Y-m-d H:i', true); | |
| 325 | - | |
| 326 | - $allHour = array_keys($statsCampaignSelected->hour); | |
| 327 | - | |
| 328 | - //those are the dates when the first was open and the last was open | |
| 329 | - $statsCampaignSelected->startEndDateHour = []; | |
| 330 | - if (!empty($allHour)) { | |
| 331 | - $statsCampaignSelected->startEndDateHour['start'] = $allHour[0]; | |
| 332 | - $statsCampaignSelected->startEndDateHour['end'] = end($allHour); | |
| 333 | - } | |
| 334 | - } | |
| 335 | - | |
| 336 | - public function exportGlobal(): void | |
| 337 | - { | |
| 338 | - wp_verify_nonce(acym_getVar('cmd', '_wpnonce'), 'acymnonce') || die('Invalid Token'); | |
| 339 | - | |
| 340 | - $exportType = acym_getVar('string', 'export_type', 'charts'); | |
| 341 | - | |
| 342 | - $functionName = 'exportGlobal'.ucfirst($exportType); | |
| 343 | - | |
| 344 | - if (!method_exists($this, $functionName)) { | |
| 345 | - acym_enqueueMessage(acym_translation('ACYM_EXPORT_METHOD_NOT_FOUND'), 'error'); | |
| 346 | - $this->listing(); | |
| 347 | - | |
| 348 | - return; | |
| 349 | - } | |
| 350 | - | |
| 351 | - $this->$functionName(); | |
| 352 | - } | |
| 353 | - | |
| 354 | - public function prepareOpenTimeChart(array &$data): void | |
| 355 | - { | |
| 356 | - $userStatClass = new UserStatClass(); | |
| 357 | - if (!empty($this->config->get('anonymous_stats', 0))) { | |
| 358 | - $mailStatClass = new MailStatClass(); | |
| 359 | - $statsDB = $mailStatClass->getAnonOpenTimeStats($this->selectedMailIds); | |
| 360 | - } else { | |
| 361 | - $statsDB = $userStatClass->getOpenTimeStats($this->selectedMailIds); | |
| 362 | - } | |
| 363 | - | |
| 364 | - if (empty($statsDB['total_open'])) { | |
| 365 | - $data['openTime'] = $userStatClass->getDefaultStat(); | |
| 366 | - $data['empty_open'] = true; | |
| 367 | - | |
| 368 | - return; | |
| 369 | - } | |
| 370 | - | |
| 371 | - $data['empty_open'] = false; | |
| 372 | - | |
| 373 | - $stats = []; | |
| 374 | - | |
| 375 | - for ($day = 0; $day < 7; $day++) { | |
| 376 | - $stats[$day] = []; | |
| 377 | - for ($hour = 0; $hour < 8; $hour++) { | |
| 378 | - if (empty($statsDB['stats'][$day.'_'.$hour])) { | |
| 379 | - $percentage = 0; | |
| 380 | - } else { | |
| 381 | - $percentage = ($statsDB['stats'][$day.'_'.$hour]->open_total * 100) / $statsDB['total_open']; | |
| 382 | - } | |
| 383 | - $stats[$day][$hour] = round($percentage); | |
| 384 | - } | |
| 385 | - } | |
| 386 | - | |
| 387 | - $data['openTime'] = $stats; | |
| 388 | - } | |
| 389 | - | |
| 390 | - public function prepareStatByList(array &$data): void | |
| 391 | - { | |
| 392 | - $selectedMailIds = array_unique($data['selectedMailid']); | |
| 393 | - $mailid = count($selectedMailIds) !== 1 ? 0 : (int)reset($selectedMailIds); | |
| 394 | - | |
| 395 | - if (empty($mailid)) { | |
| 396 | - return; | |
| 397 | - } | |
| 398 | - | |
| 399 | - $mailSelected = (int)$this->getVarFiltersListing('int', 'mail_id_language', $mailid); | |
| 400 | - | |
| 401 | - $data['lists'] = []; | |
| 402 | - $data['emailsSent'] = []; | |
| 403 | - $data['emailsOpen'] = []; | |
| 404 | - $data['bounces'] = []; | |
| 405 | - $data['unsubscribed'] = []; | |
| 406 | - $data['click'] = []; | |
| 407 | - $data['listsStats'] = []; | |
| 408 | - $data['userPerList'] = []; | |
| 409 | - | |
| 410 | - $mailClass = new MailClass(); | |
| 411 | - $mail = $mailClass->getOneById($mailSelected); | |
| 412 | - | |
| 413 | - if (empty($mail) || !in_array($mailid, [$mail->id, $mail->parent_id])) { | |
| 414 | - $mailSelected = $mailid; | |
| 415 | - $mail = $mailClass->getOneById($mailSelected); | |
| 416 | - } | |
| 417 | - | |
| 418 | - if (empty($mail)) { | |
| 419 | - return; | |
| 420 | - } | |
| 421 | - | |
| 422 | - $mainMailId = empty($mail->parent_id) ? $mail->id : $mail->parent_id; | |
| 423 | - | |
| 424 | - // get lists from the selected campaign | |
| 425 | - $query = 'SELECT l.id, l.name, l.color FROM #__acym_list l'; | |
| 426 | - $query .= ' JOIN #__acym_mail_has_list ml on l.id = ml.list_id'; | |
| 427 | - $query .= ' WHERE ml.mail_id = '.intval($mainMailId); | |
| 428 | - | |
| 429 | - $data['lists'] = acym_loadObjectList($query, 'id'); | |
| 430 | - $listIds = implode(',', array_keys($data['lists'])); | |
| 431 | - | |
| 432 | - if (!empty($listIds)) { | |
| 433 | - //get nbSent, nbOpen, nbBounce, nbUnsubscribe | |
| 434 | - $query = 'SELECT ul.list_id, SUM(us.sent) as nbSent, SUM(IF(us.open >= 1, 1, 0)) as nbOpen, SUM(us.bounce) as nbBounce, SUM(us.unsubscribe) as nbUnsub from #__acym_user_has_list ul'; | |
| 435 | - $query .= ' JOIN #__acym_user_stat us on ul.user_id = us.user_id'; | |
| 436 | - $query .= ' WHERE ul.list_id in ('.$listIds.') AND us.mail_id = '.$mailSelected; | |
| 437 | - $query .= ' GROUP BY ul.list_id;'; | |
| 438 | - $data['listsStats'] = acym_loadObjectList($query, 'list_id'); | |
| 439 | - | |
| 440 | - //get nbClick | |
| 441 | - $query = 'SELECT ul.list_id, COUNT(uc.click) as nbClick'; | |
| 442 | - $query .= ' FROM #__acym_user_has_list ul '; | |
| 443 | - $query .= ' JOIN #__acym_url_click uc on ul.user_id = uc.user_id'; | |
| 444 | - $query .= ' WHERE ul.list_id in ('.$listIds.') AND uc.mail_id = '.$mailSelected; | |
| 445 | - $query .= ' GROUP BY ul.list_id;'; | |
| 446 | - | |
| 447 | - $data['nbClick'] = acym_loadObjectList($query, 'list_id'); | |
| 448 | - | |
| 449 | - //get nbUser per list | |
| 450 | - $query = 'SELECT ul.list_id, COUNT(ul.user_id) as nbUser'; | |
| 451 | - $query .= ' FROM #__acym_user_has_list ul'; | |
| 452 | - $query .= ' JOIN #__acym_user_stat us ON ul.user_id = us.user_id'; | |
| 453 | - $query .= ' WHERE ul.list_id in ('.$listIds.') AND us.mail_id = '.$mailSelected; | |
| 454 | - $query .= ' GROUP BY ul.list_id;'; | |
| 455 | - | |
| 456 | - $data['userPerList'] = acym_loadObjectList($query, 'list_id'); | |
| 457 | - } | |
| 458 | - | |
| 459 | - //format data for barChart | |
| 460 | - foreach ($data['listsStats'] as $listId => $item) { | |
| 461 | - $nbSent = empty($item->nbSent) ? 1 : $item->nbSent; | |
| 462 | - | |
| 463 | - $data['emailsSent'][$listId] = [ | |
| 464 | - 'label' => $data['lists'][$listId]->name, | |
| 465 | - 'value' => $item->nbSent, | |
| 466 | - 'color' => $data['lists'][$listId]->color, | |
| 467 | - ]; | |
| 468 | - $data['emailsOpen'][$listId] = [ | |
| 469 | - 'label' => $data['lists'][$listId]->name, | |
| 470 | - 'value' => round(($item->nbOpen * 100) / $nbSent), | |
| 471 | - 'color' => $data['lists'][$listId]->color, | |
| 472 | - ]; | |
| 473 | - $data['bounces'][$listId] = [ | |
| 474 | - 'label' => $data['lists'][$listId]->name, | |
| 475 | - 'value' => round(($item->nbBounce * 100) / $nbSent), | |
| 476 | - 'color' => $data['lists'][$listId]->color, | |
| 477 | - ]; | |
| 478 | - $data['unsubscribed'][$listId] = [ | |
| 479 | - 'label' => $data['lists'][$listId]->name, | |
| 480 | - 'value' => round(($item->nbUnsub * 100) / $nbSent), | |
| 481 | - 'color' => $data['lists'][$listId]->color, | |
| 482 | - ]; | |
| 483 | - } | |
| 484 | - | |
| 485 | - foreach ($data['userPerList'] as $listId => $item) { | |
| 486 | - $nbUser = $item->nbUser; | |
| 487 | - // we can't provide lists and their colors if there is no click, | |
| 488 | - // so we initialize the values with $data['lists'] to display lists with no click rather than nothing | |
| 489 | - $data['click'][$listId] = ['label' => $data['lists'][$listId]->name, 'value' => 0, 'color' => $data['lists'][$listId]->color]; | |
| 490 | - | |
| 491 | - if ($nbUser > 0 && !empty($data['nbClick'][$listId]->nbClick)) { | |
| 492 | - $data['click'][$listId]['value'] = round(($data['nbClick'][$listId]->nbClick * 100) / $nbUser); | |
| 493 | - } | |
| 494 | - } | |
| 495 | - } | |
| 496 | - | |
| 497 | - private function prepareAbTestMails(array &$data): void | |
| 498 | - { | |
| 499 | - if (empty($this->selectedMailIds)) return; | |
| 500 | - | |
| 501 | - $mailClass = new MailClass(); | |
| 502 | - | |
| 503 | - $mailVersions = []; | |
| 504 | - | |
| 505 | - if (empty($data['mailInformation']->parent_id)) { | |
| 506 | - $mailVersions = $mailClass->getParentAndChildMails($data['mailInformation']->id); | |
| 507 | - } elseif (!empty($data['mailInformation']->parent_id)) { | |
| 508 | - $parentEmail = $mailClass->getOneById($data['mailInformation']->parent_id); | |
| 509 | - if (empty($parentEmail)) return; | |
| 510 | - $mailVersions = $mailClass->getParentAndChildMails($parentEmail->id); | |
| 511 | - } | |
| 512 | - | |
| 513 | - $data['emailVersions'] = []; | |
| 514 | - | |
| 515 | - foreach ($mailVersions as $email) { | |
| 516 | - $data['emailVersions'][$email->id] = $email->name.' - '.$email->subject; | |
| 517 | - } | |
| 518 | - } | |
| 519 | - | |
| 520 | - private function prepareMultilingualMails(array &$data): void | |
| 521 | - { | |
| 522 | - if (empty($this->selectedMailIds)) return; | |
| 523 | - | |
| 524 | - $mailClass = new MailClass(); | |
| 525 | - | |
| 526 | - $translatedEmails = []; | |
| 527 | - | |
| 528 | - if (empty($data['mailInformation']->parent_id)) { | |
| 529 | - $translatedEmails = $mailClass->getTranslationsById($data['mailInformation']->id, true, true); | |
| 530 | - } elseif (!empty($data['mailInformation']->parent_id)) { | |
| 531 | - $parentEmail = $mailClass->getOneById($data['mailInformation']->parent_id); | |
| 532 | - if (empty($parentEmail)) return; | |
| 533 | - $translatedEmails = $mailClass->getTranslationsById($parentEmail->id, true, true); | |
| 534 | - } | |
| 535 | - | |
| 536 | - $data['emailTranslations'] = []; | |
| 537 | - $allLanguages = acym_getLanguages(); | |
| 538 | - | |
| 539 | - foreach ($translatedEmails as $email) { | |
| 540 | - if (!empty($email->language)) { | |
| 541 | - $data['emailTranslations'][$email->id] = empty($allLanguages[$email->language]) ? $email->language | |
| 542 | - : $allLanguages[$email->language]->name; | |
| 543 | - } | |
| 544 | - } | |
| 545 | - } | |
| 546 | - | |
| 547 | - private function prepareDevicesStats(array &$data): void | |
| 548 | - { | |
| 549 | - if (!empty($this->config->get('anonymous_stats', 0))) { | |
| 550 | - $mailStatClass = new MailStatClass(); | |
| 551 | - $devicesCampaign = $mailStatClass->getAnonDevices($this->selectedMailIds); | |
| 552 | - } else { | |
| 553 | - $campaignClass = new CampaignClass(); | |
| 554 | - $devicesCampaign = $campaignClass->getDevicesWithCountByMailId($this->selectedMailIds); | |
| 555 | - } | |
| 556 | - | |
| 557 | - $defaultDataDevices = [ | |
| 558 | - 'ACYM_MOBILE' => 0, | |
| 559 | - 'ACYM_DESKTOP' => 0, | |
| 560 | - 'ACYM_OTHER' => 0, | |
| 561 | - 'ACYM_UNKNOWN' => 0, | |
| 562 | - ]; | |
| 563 | - $data['devices'] = $defaultDataDevices; | |
| 564 | - | |
| 565 | - foreach ($devicesCampaign as $oneDevice) { | |
| 566 | - if (empty($oneDevice->number)) { | |
| 567 | - continue; | |
| 568 | - } | |
| 569 | - | |
| 570 | - if (empty($oneDevice->device)) { | |
| 571 | - $device = 'ACYM_UNKNOWN'; | |
| 572 | - } elseif (in_array($oneDevice->device, array_merge(BrowserDetection::PLATFORMS_MOBILE, BrowserDetection::LEGACY_PLATFORMS_MOBILE))) { | |
| 573 | - $device = 'ACYM_MOBILE'; | |
| 574 | - } elseif (in_array($oneDevice->device, array_merge(BrowserDetection::PLATFORMS_DESKTOP, BrowserDetection::LEGACY_PLATFORMS_DESKTOP))) { | |
| 575 | - $device = 'ACYM_DESKTOP'; | |
| 576 | - } else { | |
| 577 | - $device = 'ACYM_OTHER'; | |
| 578 | - } | |
| 579 | - | |
| 580 | - $data['devices'][$device] += $oneDevice->number; | |
| 581 | - } | |
| 582 | - | |
| 583 | - if ($data['devices'] === $defaultDataDevices) { | |
| 584 | - $data['devices'] = []; | |
| 585 | - } | |
| 586 | - } | |
| 587 | - | |
| 588 | - private function prepareOpenSourcesStats(array &$data): void | |
| 589 | - { | |
| 590 | - if (!empty($this->config->get('anonymous_stats', 0))) { | |
| 591 | - $mailStatClass = new MailStatClass(); | |
| 592 | - $openedFromStats = $mailStatClass->getAnonOpenSources($this->selectedMailIds); | |
| 593 | - } else { | |
| 594 | - $userStatClass = new UserStatClass(); | |
| 595 | - $openedFromStats = $userStatClass->getOpenSourcesStats($this->selectedMailIds); | |
| 596 | - } | |
| 597 | - | |
| 598 | - $data['openedWith'] = []; | |
| 599 | - foreach ($openedFromStats as $oneSource) { | |
| 600 | - if (empty($oneSource->number)) { | |
| 601 | - continue; | |
| 602 | - } | |
| 603 | - | |
| 604 | - if (!empty($oneSource->opened_with) && isset(BrowserDetection::LEGACY_OPENED_WITH_MAP[$oneSource->opened_with])) { | |
| 605 | - $oneSource->opened_with = BrowserDetection::LEGACY_OPENED_WITH_MAP[$oneSource->opened_with]; | |
| 606 | - } | |
| 607 | - | |
| 608 | - if (empty($oneSource->opened_with)) { | |
| 609 | - $oneSource->opened_with = 'ACYM_UNKNOWN'; | |
| 610 | - } | |
| 611 | - | |
| 612 | - $data['openedWith'][$oneSource->opened_with] = $oneSource->number; | |
| 613 | - } | |
| 614 | - } | |
| 615 | - | |
| 616 | - public function preparecharts(array &$data): void | |
| 617 | - { | |
| 618 | - $mailStatClass = new MailStatClass(); | |
| 619 | - | |
| 620 | - $data['mail'] = $mailStatClass->getSentFailByMailIds($this->selectedMailIds); | |
| 621 | - if (empty($data['mail'])) return; | |
| 622 | - | |
| 623 | - $campaignClass = new CampaignClass(); | |
| 624 | - $urlClickClass = new UrlClickClass(); | |
| 625 | - | |
| 626 | - //For the total opening, the doughnut chart | |
| 627 | - $data['mail']->totalMail = $data['mail']->sent + $data['mail']->fail; | |
| 628 | - $data['mail']->percentageSent = empty($data['mail']->totalMail) ? 0 : number_format(($data['mail']->sent * 100) / $data['mail']->totalMail, 2); | |
| 629 | - $data['mail']->allSent = empty($data['mail']->totalMail) | |
| 630 | - ? acym_translationSprintf('ACYM_X_MAIL_SUCCESSFULLY_SENT_OF_X', 0, 0) | |
| 631 | - : acym_translationSprintf( | |
| 632 | - 'ACYM_X_MAIL_SUCCESSFULLY_SENT_OF_X', | |
| 633 | - $data['mail']->sent, | |
| 634 | - $data['mail']->totalMail | |
| 635 | - ); | |
| 636 | - | |
| 637 | - // Anonymized mode has no per-subscriber data: show total opens/clicks instead of unique counts | |
| 638 | - $anonymousStats = !empty($this->config->get('anonymous_stats', 0)); | |
| 639 | - $data['anonymousStats'] = $anonymousStats; | |
| 640 | - | |
| 641 | - if ($anonymousStats) { | |
| 642 | - $cumulatedTotals = $mailStatClass->getCumulatedStatsByMailIds($this->selectedMailIds); | |
| 643 | - $openCount = (int)($cumulatedTotals->open ?? 0); | |
| 644 | - $clickCount = (int)($cumulatedTotals->click_unique ?? 0); | |
| 645 | - $openSent = (int)$data['mail']->sent; | |
| 646 | - } else { | |
| 647 | - $openRateCampaign = empty($this->selectedMailIds) ? $campaignClass->getOpenRateAllCampaign() : $campaignClass->getOpenRateCampaigns($this->selectedMailIds); | |
| 648 | - $openCount = (int)$openRateCampaign->open_unique; | |
| 649 | - $openSent = (int)$openRateCampaign->sent; | |
| 650 | - $clickCount = $urlClickClass->getNumberUsersClicked($this->selectedMailIds); | |
| 651 | - } | |
| 652 | - | |
| 653 | - //open rate | |
| 654 | - // In anonymous mode $openCount is a total number of opens (not a unique-user count), so use a wording that reflects the total number of times mails were opened | |
| 655 | - $openLabelKey = $anonymousStats ? 'ACYM_X_MAIL_OPENED_TIMES_OF_X' : 'ACYM_X_MAIL_OPENED_OF_X'; | |
| 656 | - $data['mail']->openCount = $openCount; | |
| 657 | - // In anonymous mode the count is a total (not a unique), so the rate can exceed 100%: cap it to keep a meaningful percentage | |
| 658 | - $openRate = empty($openSent) ? 0 : ($openCount * 100) / $openSent; | |
| 659 | - $data['mail']->percentageOpen = number_format($anonymousStats ? min($openRate, 100) : $openRate, 2); | |
| 660 | - $data['mail']->allOpen = empty($openSent) | |
| 661 | - ? acym_translationSprintf($openLabelKey, 0, 0) | |
| 662 | - : acym_translationSprintf($openLabelKey, $openCount, $openSent); | |
| 663 | - | |
| 664 | - //click rate | |
| 665 | - // In anonymous mode $clickCount is a total (aggregated with user_id = 0), not a unique-user count, so use a wording that reflects total clicks | |
| 666 | - $clickLabelKey = $anonymousStats ? 'ACYM_X_CLICKS_REGISTERED_OF_X' : 'ACYM_X_MAIL_CLICKED_OF_X'; | |
| 667 | - $data['mail']->clickCount = $clickCount; | |
| 668 | - // In anonymous mode the count is a total (not a unique), so the rate can exceed 100%: cap it to keep a meaningful percentage | |
| 669 | - $clickRate = empty($data['mail']->sent) ? 0 : ($clickCount * 100) / $data['mail']->sent; | |
| 670 | - $data['mail']->percentageClick = number_format($anonymousStats ? min($clickRate, 100) : $clickRate, 2); | |
| 671 | - $data['mail']->allClick = empty($data['mail']->sent) | |
| 672 | - ? acym_translationSprintf($clickLabelKey, 0, 0) | |
| 673 | - : acym_translationSprintf($clickLabelKey, $clickCount, $data['mail']->sent); | |
| 674 | - | |
| 675 | - //bounce rate | |
| 676 | - $bounceRateCampaign = empty($this->selectedMailIds) ? $campaignClass->getBounceRateAllCampaign() : $campaignClass->getBounceRateCampaigns($this->selectedMailIds); | |
| 677 | - $data['mail']->percentageBounce = empty($data['mail']->sent) ? 0 : number_format(($bounceRateCampaign->bounce_unique * 100) / $data['mail']->sent, 2); | |
| 678 | - $data['mail']->allBounce = empty($data['mail']->sent) | |
| 679 | - ? acym_translationSprintf('ACYM_X_BOUNCE_OF_X', 0, 0) | |
| 680 | - : acym_translationSprintf( | |
| 681 | - 'ACYM_X_BOUNCE_OF_X', | |
| 682 | - $bounceRateCampaign->bounce_unique, | |
| 683 | - $data['mail']->sent | |
| 684 | - ); | |
| 685 | - | |
| 686 | - if (!empty($this->selectedMailIds)) { | |
| 687 | - //unsubscribe rate | |
| 688 | - $mailStat = $mailStatClass->getByMailIds($this->selectedMailIds); | |
| 689 | - $data['mail']->allUnsub = 0; | |
| 690 | - $data['mail']->percentageUnsub = 0; | |
| 691 | - if (!empty($mailStat)) { | |
| 692 | - $data['mail']->percentageUnsub = empty($data['mail']->sent) ? 0 : number_format(($mailStat->unsubscribe_total * 100) / $data['mail']->sent, 2); | |
| 693 | - $data['mail']->allUnsub = empty($data['mail']->sent) | |
| 694 | - ? acym_translationSprintf('ACYM_X_USERS_UNSUBSCRIBED_OF_X', 0, 0) | |
| 695 | - : acym_translationSprintf( | |
| 696 | - 'ACYM_X_USERS_UNSUBSCRIBED_OF_X', | |
| 697 | - $mailStat->unsubscribe_total, | |
| 698 | - $data['mail']->sent | |
| 699 | - ); | |
| 700 | - } | |
| 701 | - } | |
| 702 | - | |
| 703 | - $this->prepareDevicesStats($data); | |
| 704 | - $this->prepareOpenSourcesStats($data); | |
| 705 | - $this->prepareLineChart($data['mail'], $this->selectedMailIds); | |
| 706 | - $this->prepareComparedStats($data); | |
| 707 | - } | |
| 708 | - | |
| 709 | - private function decode(array &$detailedStats, array $columnsToDecode = ['mail_subject', 'mail_name']): void | |
| 710 | - { | |
| 711 | - foreach ($detailedStats as $oneDetailedStat) { | |
| 712 | - foreach ($columnsToDecode as $column) { | |
| 713 | - if (!empty($oneDetailedStat->$column)) { | |
| 714 | - $oneDetailedStat->$column = acym_utf8Decode($oneDetailedStat->$column); | |
| 715 | - } | |
| 716 | - } | |
| 717 | - } | |
| 718 | - } | |
| 719 | - | |
| 720 | - private function prepareLinksDetailsListing(array &$data): void | |
| 721 | - { | |
| 722 | - $data['search'] = $this->getVarFiltersListing('string', 'links_details_search', ''); | |
| 723 | - $data['ordering'] = $this->getVarFiltersListing('cmd', 'links_details_ordering', 'id'); | |
| 724 | - $data['orderingSortOrder'] = $this->getVarFiltersListing('cmd', 'links_details_ordering_sort_order', 'desc'); | |
| 725 | - | |
| 726 | - if (empty($this->selectedMailIds)) return; | |
| 727 | - | |
| 728 | - $pagination = new PaginationHelper(); | |
| 729 | - $urlClickClass = new UrlClickClass(); | |
| 730 | - | |
| 731 | - $detailedStatsPerPage = $pagination->getListLimit(); | |
| 732 | - $page = $this->getVarFiltersListing('int', 'links_details_pagination_page', 1); | |
| 733 | - | |
| 734 | - $urlClicks = $urlClickClass->getUrlsFromMailsWithDetails( | |
| 735 | - [ | |
| 736 | - 'ordering' => $data['ordering'], | |
| 737 | - 'search' => $data['search'], | |
| 738 | - 'detailedStatsPerPage' => $detailedStatsPerPage, | |
| 739 | - 'offset' => ($page - 1) * $detailedStatsPerPage, | |
| 740 | - 'ordering_sort_order' => $data['orderingSortOrder'], | |
| 741 | - 'mail_ids' => $this->selectedMailIds, | |
| 742 | - ] | |
| 743 | - ); | |
| 744 | - | |
| 745 | - $this->decode($urlClicks['links_details']); | |
| 746 | - | |
| 747 | - // Prepare the pagination | |
| 748 | - $pagination->setStatus((int)$urlClicks['total']->total, $page, $detailedStatsPerPage); | |
| 749 | - | |
| 750 | - $data['pagination'] = $pagination; | |
| 751 | - $data['links_details'] = $urlClicks['links_details']; | |
| 752 | - $data['query'] = $urlClicks['query']; | |
| 753 | - } | |
| 754 | - | |
| 755 | - private function prepareListReceivers(array &$data): void | |
| 756 | - { | |
| 757 | - if (empty($this->selectedMailIds)) return; | |
| 758 | - | |
| 759 | - $mailStatClass = new MailStatClass(); | |
| 760 | - $mailClass = new MailClass(); | |
| 761 | - | |
| 762 | - $data['mailStat'] = $mailStatClass->getByMailIds($this->selectedMailIds); | |
| 763 | - $data['lists'] = $mailClass->getAllListsByMailId($this->selectedMailIds[0]); | |
| 764 | - } | |
| 765 | - | |
| 766 | - private function exportGlobalFormatted(): void | |
| 767 | - { | |
| 768 | - $exportHelper = new ExportHelper(); | |
| 769 | - $data = []; | |
| 770 | - $this->prepareDefaultPageInfo($data); | |
| 771 | - $data['show_date_filters'] = true; | |
| 772 | - $data['page_title'] = false; | |
| 773 | - $timeLinechart = acym_getVar('string', 'time_linechart', 'month'); | |
| 774 | - | |
| 775 | - $this->prepareMailFilter($data); | |
| 776 | - $this->prepareClickStats($data); | |
| 777 | - $this->preparecharts($data); | |
| 778 | - $this->prepareDefaultLineChart($data); | |
| 779 | - $this->prepareDefaultDevicesChart($data); | |
| 780 | - $this->prepareDefaultBrowsersChart($data); | |
| 781 | - | |
| 782 | - $globalDonut = [ | |
| 783 | - $data['mail']->percentageSent, | |
| 784 | - $data['mail']->percentageOpen, | |
| 785 | - $data['mail']->percentageClick, | |
| 786 | - $data['mail']->percentageBounce, | |
| 787 | - $data['mail']->percentageUnsub, | |
| 788 | - ]; | |
| 789 | - $mailName = empty($this->selectedMailIds) ? acym_translation('ACYM_ALL_MAILS') : $data['mailInformation']->name; | |
| 790 | - $globalLine = $data['mail']->$timeLinechart; | |
| 791 | - | |
| 792 | - $exportHelper->exportStatsFormattedCSV($mailName, $globalDonut, $globalLine, $timeLinechart); | |
| 793 | - exit; | |
| 794 | - } | |
| 795 | - | |
| 796 | - private function exportGlobalFull(): void | |
| 797 | - { | |
| 798 | - $exportHelper = new ExportHelper(); | |
| 799 | - $data = []; | |
| 800 | - $this->prepareDefaultPageInfo($data); | |
| 801 | - | |
| 802 | - $where = ''; | |
| 803 | - if (!empty($this->selectedMailIds)) { | |
| 804 | - $where = 'WHERE mail_id IN ('.implode(',', $this->selectedMailIds).')'; | |
| 805 | - } | |
| 806 | - | |
| 807 | - $columnsMailStat = acym_getColumns('mail_stat'); | |
| 808 | - $columnsToExport = []; | |
| 809 | - | |
| 810 | - $columnsToExport['mail.subject'] = acym_translation('ACYM_EMAIL_SUBJECT'); | |
| 811 | - foreach ($columnsMailStat as $column) { | |
| 812 | - if ($column === 'mail_id') { | |
| 813 | - continue; | |
| 814 | - } | |
| 815 | - | |
| 816 | - $translation = acym_translation('ACYM_'.strtoupper($column).'_COLUMN_STAT'); | |
| 817 | - if ($column === 'send_date') { | |
| 818 | - $translation = acym_translation('ACYM_SEND_DATE'); | |
| 819 | - } elseif ($column === 'click_total') { | |
| 820 | - $translation = acym_translation('ACYM_TOTAL_CLICKS'); | |
| 821 | - } elseif ($column === 'click_unique') { | |
| 822 | - $translation = acym_translation('ACYM_UNIQUE_CLICKS'); | |
| 823 | - } | |
| 824 | - | |
| 825 | - $columnsToExport['mailstat.'.$column] = $translation; | |
| 826 | - } | |
| 827 | - | |
| 828 | - $query = 'SELECT '.implode(', ', array_keys($columnsToExport)).' FROM #__acym_mail_stat AS mailstat LEFT JOIN #__acym_mail AS mail ON mail.id = mailstat.mail_id '.$where; | |
| 829 | - $exportHelper->exportStatsFullCSV($query, $columnsToExport); | |
| 830 | - exit; | |
| 831 | - } | |
| 832 | - | |
| 833 | - private function prepareComparedStats(array &$data): void | |
| 834 | - { | |
| 835 | - if (empty($data['totalSubscribers']) || empty($data['mail']->percentageOpen) || empty($data['mail']->percentageClick) || empty($data['mail']->percentageBounce)) { | |
| 836 | - return; | |
| 837 | - } | |
| 838 | - | |
| 839 | - $currentDate = acym_date('now', 'Y-m-d'); | |
| 840 | - | |
| 841 | - $newStats = [ | |
| 842 | - 'date' => $currentDate, | |
| 843 | - 'value' => [ | |
| 844 | - 'totalSubscribers' => $data['totalSubscribers'], | |
| 845 | - 'openRate' => $data['mail']->percentageOpen, | |
| 846 | - 'clickRate' => $data['mail']->percentageClick, | |
| 847 | - 'bounceRate' => $data['mail']->percentageBounce, | |
| 848 | - 'totalNewSubscribers' => $data['totalSubscribers'], | |
| 849 | - ], | |
| 850 | - ]; | |
| 851 | - | |
| 852 | - $keys = [ | |
| 853 | - 'totalSubscribersHistory' => true, | |
| 854 | - 'percentageOpenHistory' => false, | |
| 855 | - 'percentageClickHistory' => false, | |
| 856 | - 'percentageBounceHistory' => false, | |
| 857 | - 'totalNewSubscribersHistory' => false, | |
| 858 | - ]; | |
| 859 | - | |
| 860 | - $oldEvolutionData = json_decode($this->config->get('statsEvolution', '{}'), true); | |
| 861 | - | |
| 862 | - foreach ($keys as $key => $isPercentage) { | |
| 863 | - $history = json_decode($this->config->get($key, '[]'), true); | |
| 864 | - | |
| 865 | - if (!empty($history) && end($history)['date'] === $currentDate) { | |
| 866 | - continue; | |
| 867 | - } | |
| 868 | - | |
| 869 | - $history[] = ['date' => $currentDate, 'value' => $newStats['value'][$this->getStatKey($key)]]; | |
| 870 | - | |
| 871 | - if (count($history) > 30) { | |
| 872 | - array_shift($history); | |
| 873 | - } | |
| 874 | - | |
| 875 | - $this->config->saveConfig([$key => json_encode($history)]); | |
| 876 | - | |
| 877 | - $evolutionKey = $this->getEvolutionKey($key); | |
| 878 | - $oldEvolutionData[$evolutionKey] = $this->calculateEvolution($history, $isPercentage); | |
| 879 | - } | |
| 880 | - | |
| 881 | - $this->config->saveConfig(['statsEvolution' => json_encode($oldEvolutionData)]); | |
| 882 | - | |
| 883 | - if (!empty($data)) { | |
| 884 | - $this->updateDashboardData($data); | |
| 885 | - } | |
| 886 | - } | |
| 887 | - | |
| 888 | - private function getStatKey(string $key): ?string | |
| 889 | - { | |
| 890 | - return [ | |
| 891 | - 'totalSubscribersHistory' => 'totalSubscribers', | |
| 892 | - 'percentageOpenHistory' => 'openRate', | |
| 893 | - 'percentageClickHistory' => 'clickRate', | |
| 894 | - 'percentageBounceHistory' => 'bounceRate', | |
| 895 | - 'totalNewSubscribersHistory' => 'totalNewSubscribers', | |
| 896 | - ][$key] ?? null; | |
| 897 | - } | |
| 898 | - | |
| 899 | - private function getEvolutionKey(string $key): ?string | |
| 900 | - { | |
| 901 | - return [ | |
| 902 | - 'totalSubscribersHistory' => 'totalSubscribersEvolution', | |
| 903 | - 'percentageOpenHistory' => 'openRateEvolution', | |
| 904 | - 'percentageClickHistory' => 'clickRateEvolution', | |
| 905 | - 'percentageBounceHistory' => 'bounceRateEvolution', | |
| 906 | - 'totalNewSubscribersHistory' => 'totalNewSubscribersEvolution', | |
| 907 | - ][$key] ?? null; | |
| 908 | - } | |
| 909 | - | |
| 910 | - private function calculateEvolution(array $history, bool $isPercentage = false): ?float | |
| 911 | - { | |
| 912 | - if (empty($history)) { | |
| 913 | - return null; | |
| 914 | - } | |
| 915 | - | |
| 916 | - $oldValue = $history[0]['value'] ?? 0; | |
| 917 | - $newValue = end($history)['value'] ?? 0; | |
| 918 | - | |
| 919 | - if ($oldValue === 0) { | |
| 920 | - return null; | |
| 921 | - } | |
| 922 | - | |
| 923 | - if ($isPercentage) { | |
| 924 | - // For totalSubscribers: percentage variation | |
| 925 | - return round((($newValue - $oldValue) / $oldValue) * 100, 2); | |
| 926 | - } else { | |
| 927 | - // For other stats: absolute difference | |
| 928 | - return round($newValue - $oldValue, 2); | |
| 929 | - } | |
| 930 | - } | |
| 931 | - | |
| 932 | - private function updateDashboardData(array &$data): void | |
| 933 | - { | |
| 934 | - $evolutionData = json_decode($this->config->get('statsEvolution', '{}'), true); | |
| 935 | - | |
| 936 | - if (!empty($evolutionData)) { | |
| 937 | - $data['totalSubscribersEvolution'] = $evolutionData['totalSubscribersEvolution'] ?? null; | |
| 938 | - $data['openRateEvolution'] = $evolutionData['openRateEvolution'] ?? null; | |
| 939 | - $data['clickRateEvolution'] = $evolutionData['clickRateEvolution'] ?? null; | |
| 940 | - $data['bounceRateEvolution'] = $evolutionData['bounceRateEvolution'] ?? null; | |
| 941 | - $data['totalNewSubscribersEvolution'] = $evolutionData['totalNewSubscribersEvolution'] ?? null; | |
| 942 | - } | |
| 943 | - } | |
| 944 | -} | |
