Anjing Webshells

Website : rimsha.abasa.com
: / var / www / goldfishtank.com / mautic / plugins / MauticFocusBundle / EventListener /
Filename : ReportSubscriber.php
back
<?php

declare(strict_types=1);

namespace MauticPlugin\MauticFocusBundle\EventListener;

use Mautic\ReportBundle\Event\ReportBuilderEvent;
use Mautic\ReportBundle\Event\ReportGeneratorEvent;
use Mautic\ReportBundle\ReportEvents;
use Symfony\Component\EventDispatcher\EventSubscriberInterface;

final class ReportSubscriber implements EventSubscriberInterface
{
    public const CONTEXT_FOCUS_STATS = 'focus_stats';
    public const FOCUS_GROUP         = 'focus';
    public const PREFIX_FOCUS        = 'f';
    public const PREFIX_STATS        = 'fs';
    public const PREFIX_REDIRECTS    = 'r';
    public const PREFIX_TRACKABLES   = 't';

    public static function getSubscribedEvents(): array
    {
        return [
            ReportEvents::REPORT_ON_BUILD    => ['onReportBuilder', 0],
            ReportEvents::REPORT_ON_GENERATE => ['onReportGenerate', 0],
        ];
    }

    /**
     * Add available tables and columns to the report builder lookup.
     */
    public function onReportBuilder(ReportBuilderEvent $event): void
    {
        if (!$event->checkContext(self::CONTEXT_FOCUS_STATS)) {
            return;
        }

        $columns = [
            self::PREFIX_FOCUS.'.name' => [
                'label'   => 'mautic.core.name',
                'type'    => 'html',
                'alias'   => 'focus_name',
                'formula' => 'MAX('.self::PREFIX_FOCUS.'.name)',
            ],
            self::PREFIX_FOCUS.'.description' => [
                'label'   => 'mautic.core.description',
                'type'    => 'html',
                'alias'   => 'focus_desc',
                'formula' => 'MAX('.self::PREFIX_FOCUS.'.description)',
            ],
            self::PREFIX_FOCUS.'.focus_type' => [
                'label'   => 'mautic.focus.thead.type',
                'type'    => 'html',
                'alias'   => 'focus_type',
                'formula' => 'MAX('.self::PREFIX_FOCUS.'.focus_type)',
            ],
            self::PREFIX_FOCUS.'.style' => [
                'label'   => 'mautic.focus.tab.focus_style',
                'type'    => 'html',
                'alias'   => 'focus_style',
                'formula' => 'MAX('.self::PREFIX_FOCUS.'.style)',
            ],
            self::PREFIX_STATS.'.type' => [
                'label' => 'mautic.focus.interaction',
                'type'  => 'html',
                'alias' => 'interaction_type',
            ],
            self::PREFIX_TRACKABLES.'.hits' => [
                'label'   => 'mautic.page.graph.line.hits',
                'type'    => 'html',
                'alias'   => 'hit_count',
                'formula' => 'CASE 
                    WHEN '.self::PREFIX_STATS.'.type = "view" THEN (
                        SELECT COUNT(fs2.id) 
                        FROM '.MAUTIC_TABLE_PREFIX.'focus_stats fs2 
                        INNER JOIN '.MAUTIC_TABLE_PREFIX.'focus f2 
                        ON f2.id = fs2.focus_id 
                        WHERE fs2.type = "view" 
                        AND f2.id = '.self::PREFIX_FOCUS.'.id
                        GROUP BY f2.id
                    )
                    ELSE MAX('.self::PREFIX_TRACKABLES.'.hits)
                END',
            ],
            self::PREFIX_TRACKABLES.'.unique_hits' => [
                'label'   => 'mautic.report.focus.uniquehits',
                'type'    => 'html',
                'alias'   => 'unique_hit_count',
                'formula' => 'CASE 
                    WHEN '.self::PREFIX_STATS.'.type = "view" THEN (
                        SELECT COUNT(DISTINCT fs2.lead_id) 
                        FROM '.MAUTIC_TABLE_PREFIX.'focus_stats fs2 
                        WHERE fs2.type = "view" 
                        AND fs2.focus_id = '.self::PREFIX_STATS.'.focus_id
                    )
                    ELSE MAX('.self::PREFIX_TRACKABLES.'.unique_hits)
                END',
            ],
            self::PREFIX_REDIRECTS.'.url' => [
                'label'   => 'url',
                'type'    => 'html',
                'alias'   => 'redirect_url',
                'formula' => 'MAX('.self::PREFIX_REDIRECTS.'.url)',
            ],
        ];

        $data = [
            'display_name' => 'mautic.focus.graph.stats',
            'columns'      => $columns,
        ];
        $context = self::CONTEXT_FOCUS_STATS;

        $event->addTable($context, $data, self::FOCUS_GROUP);
    }

    /**
     * Initialize the QueryBuilder object to generate reports from.
     */
    public function onReportGenerate(ReportGeneratorEvent $event): void
    {
        if (!$event->checkContext([self::CONTEXT_FOCUS_STATS])) {
            return;
        }

        $queryBuilder = $event->getQueryBuilder();
        $queryBuilder->from(MAUTIC_TABLE_PREFIX.'focus_stats', self::PREFIX_STATS)
            ->leftJoin(self::PREFIX_STATS, MAUTIC_TABLE_PREFIX.'focus', self::PREFIX_FOCUS,
                self::PREFIX_FOCUS.'.id = '.self::PREFIX_STATS.'.focus_id')
            ->leftJoin(self::PREFIX_STATS, MAUTIC_TABLE_PREFIX.'channel_url_trackables', self::PREFIX_TRACKABLES,
                self::PREFIX_TRACKABLES.'.channel_id = '.self::PREFIX_STATS.'.focus_id AND '.
                self::PREFIX_TRACKABLES.'.channel = "focus"')
            ->leftJoin(self::PREFIX_STATS, MAUTIC_TABLE_PREFIX.'page_redirects', self::PREFIX_REDIRECTS,
                self::PREFIX_REDIRECTS.'.id = '.self::PREFIX_TRACKABLES.'.redirect_id')
            ->groupBy(self::PREFIX_STATS.'.focus_id', self::PREFIX_STATS.'.type');

        $event->applyDateFilters($queryBuilder, 'date_added', self::PREFIX_STATS);
        $event->setQueryBuilder($queryBuilder);
    }
}