table_request

Complexity

Total Complexity

22

Size/Duplication

Total Lines	62
Duplicated Lines	0 %

Importance

Changes	1
Bugs	0	Features	1

6 Methods

Rating	Name	Duplication	Size	Complexity
A	requestPage()	0	5	3
A	requestOrderCol()	0	8	3
A	requestOrderDir()	0	6	4
A	requestExport()	0	4	2
A	requestFilterByAll()	0	10	4
A	requestFilter()	0	17	6

<?php

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