OwlCyberSecurity - MANAGER

Edit File: DevicesDataProvider.php

<?php

namespace WP_Statistics\Service\Admin\Devices;

use WP_STATISTICS\Helper;
use WP_Statistics\Models\VisitorsModel;
use WP_Statistics\Service\Charts\ChartDataProviderFactory;

class DevicesDataProvider
{
    protected $args;
    protected $visitorsModel;

public function __construct($args)
    {
        $this->args = $args;

$this->visitorsModel = new VisitorsModel();
    }

public function getOverviewData()
    {
        $platformChartDataProvider = ChartDataProviderFactory::platformCharts(['limit' => 6]);

return [
            'os'        => $platformChartDataProvider->getOsData(),
            'browsers'  => $platformChartDataProvider->getBrowserData(),
            'devices'   => $platformChartDataProvider->getDeviceData(),
            'models'    => $platformChartDataProvider->getModelData()
        ];
    }

/**
     * Returns data for "Browsers" tab.
     *
     * @return  array
     */
    public function getBrowsersData()
    {
        $args = array_merge($this->args, [
            'field'    => 'agent',
            'group_by' => ['agent'],
        ]);

return [
            'visitors' => $this->visitorsModel->getVisitorsDevices($args),
            'total'    => $this->visitorsModel->countColumnDistinct($args),
            'visits'   => $this->visitorsModel->countColumnDistinct(array_merge($args, ['field' => 'ID'])),
        ];
    }

/**
     * Returns data for "Operating Systems" tab.
     *
     * @return  array
     */
    public function getPlatformsData()
    {
        $args = array_merge($this->args, [
            'field'    => 'platform',
            'group_by' => ['platform'],
        ]);

/**
     * Returns data for "Device Models" tab.
     *
     * @return  array
     */
    public function getModelsData()
    {
        $args = array_merge($this->args, [
            'field'    => 'model',
            'group_by' => ['model']
        ]);

$visitors = $this->visitorsModel->getVisitorsDevices($args);

if (! empty($visitors)) {
            $visitors = array_reduce($visitors, function ($carry, $item) {
                // Trim whitespace and default empty models to 'Unknown'
                $model = trim($item->model ?? '');

if ($model === '') {
                    $model = 'Unknown';
                }

if (isset($carry[$model])) {
                    $carry[$model]->visitors += $item->visitors;
                } else {
                    $carry[$model] = (object)[
                        'model'    => $model,
                        'visitors' => $item->visitors
                    ];
                }
                return $carry;
            }, []);
        }

return [
            'visitors' => $visitors,
            'total'    => $this->visitorsModel->countColumnDistinct($args),
            'visits'   => $this->visitorsModel->countColumnDistinct(array_merge($args, ['field' => 'ID'])),
        ];
    }

/**
     * Returns data for "Device Models" tab.
     *
     * @return  array
     */
    public function getCategoriesData()
    {
        $args = array_merge($this->args, [
            'field'    => 'device',
            'group_by' => ['device']
        ]);

$visitors = [];

$data = $this->visitorsModel->getVisitorsDevices($args);
        foreach ($data as $visitor) {
            $device = !empty($visitor->device) ? trim($visitor->device) : '';

if (strtolower($device) != "bot") {
                $device = Helper::getDeviceCategoryName($device);

if (isset($visitors[$device])) {
                    $visitors[$device]->visitors += $visitor->visitors;
                } else {
                    $visitors[$device] = json_decode(json_encode(array(
                        'device'   => ucfirst($device),
                        'visitors' => $visitor->visitors,
                    )));
                }
            }
        }

return [
            'visitors' => array_filter($visitors),
            'total'    => $this->visitorsModel->countColumnDistinct($args),
            'visits'   => $this->visitorsModel->countColumnDistinct(array_merge($args, ['field' => 'ID'])),
        ];
    }

/**
     * Returns data for browser's single page.
     *
     * @param string $selectedBrowser
     *
     * @return  array
     */
    public function getSingleBrowserData()
    {
        $args = array_merge($this->args, [
            'field'     => 'agent',
            'where_col' => 'agent',
            'where_val' => esc_sql($this->args['browser']),
        ]);

return [
            'visitors' => $this->visitorsModel->getVisitorsDevicesVersions($args),
            'total'    => $this->visitorsModel->countColumnDistinct(array_merge($this->args, ['field' => 'agent'])),
            'visits'   => $this->visitorsModel->countColumnDistinct(array_merge($args, ['field' => 'ID'])),
        ];
    }

/**
     * Returns data for platform's single page.
     *
     * @param string $selectedPlatform
     *
     * @return  array
     */
    public function getSinglePlatformData($selectedPlatform)
    {
        $args = array_merge($this->args, [
            'field'     => 'platform',
            'where_col' => 'platform',
            'where_val' => esc_sql($selectedPlatform),
        ]);

return [
            'visitors' => $this->visitorsModel->getVisitorsDevicesVersions($args),
            'total'    => $this->visitorsModel->countColumnDistinct(array_merge($this->args, ['field' => 'platform'])),
            'visits'   => $this->visitorsModel->countColumnDistinct(array_merge($args, ['field' => 'ID'])),
        ];
    }

/**
     * Returns data for model's single page.
     *
     * @param string $selectedModel
     *
     * @return  array
     */
    public function getSingleModelData($selectedModel)
    {
        $args = array_merge($this->args, [
            'field'     => 'model',
            'where_col' => 'model',
            'where_val' => esc_sql($selectedModel),
        ]);

return [
            'visitors' => $this->visitorsModel->getVisitorsDevicesVersions($args),
            'total'    => $this->visitorsModel->countColumnDistinct(array_merge($this->args, ['field' => 'model'])),
            'visits'   => $this->visitorsModel->countColumnDistinct(array_merge($args, ['field' => 'ID'])),
        ];
    }
}