trait_table_request

Complexity

Total Complexity

14

Size/Duplication

Total Lines	127
Duplicated Lines	0 %

Importance

Changes	3
Bugs	0	Features	0

1 Method

Rating	Name	Duplication	Size	Complexity
C	request()	0	62	14

<?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'];
    }*/

    protected static function request($make = null)

The parameter $make is not used and could be removed.

    {
        $export = function()
        {
            $exp = filter_input(INPUT_GET, 'export', FILTER_SANITIZE_STRING);
            return in_array($exp, self::config('SAVES')) ? $exp : false;
        };
        $order_dir = function()
        {
            $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']);
        };
        $order_col = function()
        {
            $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'];
        };
        $filter = function()
        {
            $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::request('FilterByAll');
                } 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;
        };
        $page = function()
        {
            return  filter_has_var(INPUT_GET, 'pg') && self::$export == false ?
                (int)filter_input(INPUT_GET, 'pg', FILTER_SANITIZE_NUMBER_INT) :
                self::$t['page'];
        };
        
        self::$export = $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' => $order_dir(),
                    'col' => $order_col()
                ],
            'filter' => $filter(),
            'page' => $page()
        ];
        //dd(array_merge(self::$t, $t));
        return array_merge(self::$t, $t);
    }
}