webdivane / table

thead.php

<?php

class thead extends tbody
{
    /** @param array Attributes for the table Html tag */
    public static $attributes = [];
    /** @param null|str Extension (from $_SERVER['REQUEST_URI']) */
    public static $pageExt;

    protected static function load()
    {
        $items = self::$t['items'];
        $v = ['items' => $items];

        if (self::config('FILTER_ACTIVE')) {
            self::filterValues($v['f_value'], $v['f_options']);
        }

        $v['div_attributes'] = self::tagAttributes('div', $items);

        $v['table_attributes'] = self::tagAttributes('table', $items);

        $v['ths'] = self::$cols ? self::ths() : null;

        $v['body'] = self::rowsTbody();

        $v['footer'] = self::rowsTfoot();

        return self::view('views/table.html', $v);
    }

    protected static function filterValues(&$f, &$opts = [])
    {
        $f = filter_input(INPUT_GET, 'filter', FILTER_SANITIZE_STRING) ?: null;

        $by = filter_input(INPUT_GET, 'filter-by', FILTER_VALIDATE_INT);
        foreach (self::$cols as $k => $v) {
            if (isset($v[2]['sort']) && $v[2]['sort'] === false) {
                continue;
            }
            $selected = $by === $k ? ' selected' : null;
            $opts[] = "<option value=\"{$k}\"{$selected}>{$v[0]}</option>";
        }
    }

    private static function tagAttributes($tag, $items)
    {
        $attr = $tag === 'div' ?
                ['id' => $items . '-list', 'class' => 'table'] :
                ['id' => $items . '-table', 'data-table' => 'js', 
                'data-sort-a' => self::config('UTF8_ASC_SYMBOL'),
                'data-sort-d' => self::config('UTF8_DESC_SYMBOL')];
        if (array_key_exists($tag, self::$attributes)) {
            $attr += self::$attributes[$tag];
        }
        if (isset(self::$attributes[$tag]['class'])) {
            $attr['class'] .= ' ' . self::$attributes[$tag]['class'];
        }
        return self::attributes($attr);
    }

    protected static function ths()
    {
        $ths = [];
        $length = sizeof(self::$cols);
        for ($i = 0; $i < $length; $i++) {
            list($lbl, $col, $arg) = array_pad(self::$cols[$i], 3, null);

            if (is_null($col)) {
                $arg['sort'] = false;
            }

            $sort = $del = null;

            $attr = self::thAttributes($col, $arg, $sort, $del);

            $ths[] = self::th($i, $attr, $sort, $del, $lbl);
        }
        return implode('', $ths);
    }

    private static function thAttributes($col, $arg, &$sort, &$del)
    {
        if (isset($arg['width'])) { // Width attribute -> style
            $width = 'width:' . $arg['width'] . ';';
            $arg['style'] = isset($arg['style']) ?
                    $width . $arg['style'] :
                    $width;
        }

        if (($del = isset($arg['type']) && $arg['type'] == 'delete')) {
            $sort = false;
        } else {
            $sort = isset($arg['sort']) ? $arg['sort'] : $col;
        }

        return array_diff_key((array) $arg, ['sort', 'type', 'width']);
    }

    private static function th($i, $attr, $sort, $del, $lbl)
    {
        $th = '<th' . self::attributes($attr) . '>';
        if ($sort) {
            $th .= '<a onclick="table.Sort(' . $i . ',this);">';
        }
        if (!$del) {
            if ($sort == self::$t['order']['col']) {
                $span = self::$t['order']['dir'] === 'desc' ?
                        self::config('UTF8_DESC_SYMBOL') :
                        self::config('UTF8_ASC_SYMBOL');
            } else {
                $span = "";
            }
            $th .= '<span>' . $span . '</span>' . $lbl;
        } else {
            $th .= '<input id="' . self::$t['items'] . 'CheckDeleteAll"' .
                    ' onclick=\"checkAllDeleteCheckboxes(this,' .
                    ' \'' . self::$t['items'] . '\')" type="checkbox"/>';
        }
        if ($sort) {
            $th .= '</a>';
        }
        $th .= '</th>';
        return $th;
    }
    
    protected static function request()
    {
        $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');

The call to thead::request() has too many arguments starting with '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();

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