trait_table_request

Complexity

Total Complexity

23

Size/Duplication

Total Lines	130
Duplicated Lines	0 %

Importance

Changes	1
Bugs	0	Features	0

1 Method

Rating	Name	Duplication	Size	Complexity
D	request()	0	65	23

<?php

trait trait_table_request
{

    /*private static function requestFilter()
    {
        $filter = filter_input(INPUT_GET, 'filter') ?: false;
        if ($filter) {
            $by = filter_input(INPUT_GET, 'filter-by', FILTER_VALIDATE_INT);
            if ($by === false || is_null($by)) {
                $by = self::requestFilterByAll();
            } else {
                $by = self::$cols[$by][1];
            }
            $by = 'CONCAT(" ",' . $by . ', " ")';
            if (self::config('FILTER_CASE_SENSITIVE') !== true) {
                $by .= ' COLLATE ' . self::config('DB_COLLATION_CI');
            }
            $filter = $by . ' LIKE ' . '"%' . $filter . '%"';
        }
        return $filter;
    }

    private static function requestFilterByAll()
    {
        $by = [];
        foreach (self::$cols as $v) {
            if (isset($v[2]['sort']) && $v[2]['sort'] === false) {
                continue;
            }
            $by[] = 'IFNULL(' . $v[1] . ', "")';
        }
        return 'CONCAT(' . implode(',', $by) . ')';
    }

    private static function requestOrderCol()
    {
        if (($col = filter_input(INPUT_GET, 'col', FILTER_VALIDATE_INT))) {
            return isset(self::$cols[$col][2]['sort']) ?
                    self::$cols[$col][2]['sort'] :
                    self::$cols[$col][1];
        }
        return self::$t['order']['col'];
    }

    private static function requestOrderDir()
    {
        $reset = filter_has_var(INPUT_GET, 'col') ? 'asc' : null;
        return in_array(filter_input(INPUT_GET, 'ord'), ['asc', 'desc']) ?
                filter_input(INPUT_GET, 'ord') :
                ($reset ?: self::$t['order']['dir']);
    }

    private static function requestExport()
    {
        $exp = filter_input(INPUT_GET, 'export', FILTER_SANITIZE_STRING);
        return in_array($exp, self::config('SAVES')) ? $exp : false;
    }

    private static function requestPage()
    {
        return filter_has_var(INPUT_GET, 'pg') && self::$export == false ?
                (int)filter_input(INPUT_GET, 'pg', FILTER_SANITIZE_NUMBER_INT) :
                self::$t['page'];
    }*/

    final static function request($make = null)

It is generally recommended to explicitly declare the visibility for methods.

    {
        switch ($make) {
            default:

                self::$export = self::request('Export');

The property export does not exist. Although not strictly required by PHP, it is generally a best practice to declare properties explicitly.

                $t = [
                    'order' => [
                            'dir' => self::request('OrderDir'),
                            'col' => self::request('OrderCol')
                        ],
                    'filter' => self::request('Filter'),
                    'page' => self::request('Page')
                ];
                //dd(array_merge(self::$t, $t));
                return array_merge(self::$t, $t);

            case 'Filter':
                $filter = filter_input(INPUT_GET, 'filter') ?: false;
                if ($filter) {
                    $by = filter_input(INPUT_GET, 'filter-by', FILTER_VALIDATE_INT);
                    if ($by === false || is_null($by)) {
                        $by = self::requestFilterByAll();

The method requestFilterByAll() does not exist on trait_table_request. Did you maybe mean request()?

                    } else {
                        $by = self::$cols[$by][1];
                    }
                    $by = 'CONCAT(" ",' . $by . ', " ")';
                    if (self::config('FILTER_CASE_SENSITIVE') !== true) {
                        $by .= ' COLLATE ' . self::config('DB_COLLATION_CI');
                    }
                    $filter = $by . ' LIKE ' . '"%' . $filter . '%"';
                }
                return $filter;
            case 'FilterByAll':
                $by = [];
                foreach (self::$cols as $v) {
                    if (isset($v[2]['sort']) && $v[2]['sort'] === false) {
                        continue;
                    }
                    $by[] = 'IFNULL(' . $v[1] . ', "")';
                }
                return 'CONCAT(' . implode(',', $by) . ')';
            case 'OrderCol':
                $col = filter_input(INPUT_GET, 'col', FILTER_VALIDATE_INT);
                if ($col) {
                    return isset(self::$cols[$col][2]['sort']) ?
                            self::$cols[$col][2]['sort'] :
                            self::$cols[$col][1];
                }
                return self::$t['order']['col'];
            case 'OrderDir':
                $reset = filter_has_var(INPUT_GET, 'col') ? 'asc' : null;
                return
                        in_array(filter_input(INPUT_GET, 'ord'), ['asc', 'desc']) ?
                        filter_input(INPUT_GET, 'ord') :
                        ($reset ?: self::$t['order']['dir']);
            case 'Page':
                return
                        filter_has_var(INPUT_GET, 'pg') && self::$export == false ?
                        (int)filter_input(INPUT_GET, 'pg', FILTER_SANITIZE_NUMBER_INT) :
                        self::$t['page'];
            case 'Export':
                $exp = filter_input(INPUT_GET, 'export', FILTER_SANITIZE_STRING);
                return in_array($exp, self::config('SAVES')) ? $exp : false;
        }
    }
}