trait_request

Complexity

Total Complexity

23

Size/Duplication

Total Lines	79
Duplicated Lines	0 %

Importance

Changes

0

7 Methods

Rating	Name	Duplication	Size	Complexity
A	order_col()	0	8	3
A	filter()	0	17	6
A	order_dir()	0	6	4
A	filter_by_all()	0	10	4
A	page()	0	5	3
A	set_export()	0	4	2
A	request()	0	14	1

<?php

trait trait_request
{

    protected static function request(&$export)
    {
        $export = self::set_export();

        $t = [
            'order' => [
                'dir' => self::order_dir(),
                'col' => self::order_col()
            ],
            'filter' => self::filter(),
            'page' => self::page()
        ];

        return array_merge(self::$t, $t);
    }

    private static function 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::filter_by_all();
            } 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 filter_by_all()
    {
        $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 order_col()
    {
        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 order_dir()
    {
        $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 set_export()
    {
        $exp = filter_input(INPUT_GET, 'export', FILTER_SANITIZE_STRING);
        return in_array($exp, self::config('SAVES')) ? $exp : false;
    }

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