App\Controller\StatsController

Complexity

Total Complexity

10

Size/Duplication

Total Lines	85
Duplicated Lines	0 %

Test Coverage

Coverage

0%

Importance

Changes	1
Bugs	1	Features	0

3 Methods

Rating	Name	Duplication	Size	Complexity
A	getTimeFilter()	0	11	3
A	initialize()	0	5	1
B	stats()	0	53	6

<?php

/**
 * Stats controller handling stats preview.
 *
 * phpMyAdmin Error reporting server
 * Copyright (c) phpMyAdmin project (https://www.phpmyadmin.net/)
 *
 * Licensed under The MIT License
 * For full copyright and license information, please see the LICENSE.txt
 * Redistributions of files must retain the above copyright notice.
 *
 * @copyright Copyright (c) phpMyAdmin project (https://www.phpmyadmin.net/)
 * @license   https://opensource.org/licenses/mit-license.php MIT License
 *
 * @see      https://www.phpmyadmin.net/
 */

namespace App\Controller;

use App\Model\Table\IncidentsTable;
use Cake\Cache\Cache;
use Cake\ORM\TableRegistry;

use function json_decode;
use function json_encode;

/**
 * Stats controller handling stats preview.
 *
 * @property IncidentsTable $Incidents
 */
class StatsController extends AppController
{
    /**
     * Initialization hook method.
     *
     * Use this method to add common initialization code like loading components.
     *
     * @return void Nothing
     */
    public function initialize(): void
    {
        parent::initialize();
        $this->viewBuilder()->setHelpers(['Reports']);
        $this->loadModel('Incidents');
    }

    public function stats(): void
    {
        $filter = $this->getTimeFilter();
        $relatedEntries = [];
        $filter_string = $this->request->getQuery('filter');
        if (! $filter_string) {
            $filter_string = 'all_time';
        }

        $entriesWithCount = [];
        //Cache::clear();
        foreach ($this->Incidents->summarizableFields as $field) {
            $entriesWithCount = Cache::read($field . '_' . $filter_string);
            if ($entriesWithCount === null) {
                $entriesWithCount = TableRegistry::getTableLocator()->get('Reports')->
                        getRelatedByField($field, 25, false, false, $filter['limit']);
                $entriesWithCount = json_encode($entriesWithCount);
                Cache::write($field . '_' . $filter_string, $entriesWithCount);
            }

            $relatedEntries[$field] = json_decode($entriesWithCount, true);
        }

        $this->set('related_entries', $relatedEntries);
        $this->set('columns', $this->Incidents->summarizableFields);
        $this->set('filter_times', $this->Incidents->filterTimes);
        $this->set('selected_filter', $this->request->getQuery('filter'));

        $query = [
            'group' => 'grouped_by',
            'order' => 'Incidents.created',
        ];

        if (isset($filter['limit'])) {
            $query['conditions'] = [
                'Incidents.created >=' => $filter['limit'],
            ];
        }

        $this->Incidents->recursive = -1;
        $downloadStats = Cache::read('downloadStats_' . $filter_string);
        if ($downloadStats === null) {
            $downloadStats = $this->Incidents->find('all', $query);
            $downloadStats->select([
                'grouped_by' => $filter['group'],
                'date' => "DATE_FORMAT(Incidents.created, '%a %b %d %Y %T')",
                'count' => $downloadStats->func()->count('*'),
            ]);
            $downloadStats = json_encode($downloadStats->toArray());
            Cache::write('downloadStats_' . $filter_string, $downloadStats);
        }

        $this->set('download_stats', json_decode($downloadStats, true));
    }

    /**
     * @return mixed I am not sure about the type
     */
    protected function getTimeFilter()
    {
        if ($this->request->getQuery('filter')) {
            $filter = $this->Incidents->filterTimes[$this->request->getQuery('filter')];
        }

        if (isset($filter)) {
            return $filter;
        }

        return $this->Incidents->filterTimes['all_time'];
    }
}