table_getter

Complexity

Total Complexity

72

Size/Duplication

Total Lines	305
Duplicated Lines	0 %

Importance

Changes	1
Bugs	0	Features	0

9 Methods

Rating	Name	Duplication	Size	Complexity
B	jsonGetFooterData()	0	37	6
A	reset()	0	8	2
B	q()	0	20	8
A	load()	0	30	5
F	ths()	0	61	18
B	jsonGetBodyData()	0	20	7
B	rows()	0	23	7
A	select()	0	12	5
C	exportData()	0	51	14

<?php

class table_getter extends table_setter
{
    /** @param string @example: env('APP_NAME', 'APP_NAME') | APP_NAME */
    public static $app = 'App';
    /** @param array Attributes for the table Html tag */
    public static $attributes = [];
    /** @param array Query result, allows altering before table::load() */
    public static $data;
    /** @param bool Export is allowed (shows buttons in the tfoot) */
    public static $exportActive = true;
    /** @param bool Export data altered (use false for pure result) */
    public static $exportDataAsDisplayed = true;
    /** @param bool Filter (shown before the table) is allowed */
    public static $filterActive = true;
    /** @param null|str Extension (from $_SERVER['REQUEST_URI']) */
    public static $pageExt;

    protected static function ths()
    {
        if (self::$cols) {
            $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;
                }

                $sortable = !isset($arg['sort'])||$arg['sort'] !==false;

                $sort = $sortable ?
                        (isset($arg['sort']) ? $arg['sort'] : $col) :
                        null;

                if (($del = isset($arg['type'])&&$arg['type'] =='delete')) {
                    $sortable = false;
                    if (!isset($arg['width'])&&
                            false ===strpos($arg['width'], 'width:')
                    ) {
                        $arg['width'] = '1%';
                    }
                }

                if (isset($arg['width'])) { // Width attribute -> style
                    $width = 'width:' . $arg['width'] . ';';
                    $arg['style'] = isset($arg['style']) ?
                            $width . $arg['style'] :
                            $width;
                }

                $attr = array_diff_key((array) $arg, ['sort', 'type', 'width']);

                $th = '<th' . self::attributes($attr) . '>';
                if ($sortable) {
                    $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 ($sortable) {
                    $th .= '</a>';
                }
                $th .= '</th>';
                $ths[] = $th;
            }
            return implode('', $ths);
        }
    }

    /** Adds conditions, orderBy and Limits to query.
     * @param string $q
     * @param string $cond
     * @param arr $order
     * @param mixed $limit -> 5 or [$start, $count]
     * @param bool $h Having flag - to use HAVING instead of WHERE
     * @return (string) */
    protected static function q($q, $cond = null, array $order = [], $limit = 0, $h = false)
    {
        //Condition: '' | '(HAVING|WHERE|AND) ' . $cond
        $c = !empty($cond)&&!strpos($q, ($cl = !$h ? 'WHERE' : 'HAVING')) ?
                (' ' . (!strpos($q, $cl) ? $cl : ' AND ') . ' ' . $cond ) :
                '';
        //Order: '' | 'ORDER BY ' . array_keys($order)[0] . ' ' . $order[0]
        $o = !empty($order) ?
                ' ORDER BY ' . implode(', ',
                        array_map(function(&$v, $k) {
                            return $k . ' ' . strtoupper($v);
                        }, $order, array_keys($order))
                ) :
                '';
        //Limit: '' | ' LIMIT ' . '(20, 40|20)'
        $l = !empty($limit) ?
                (' LIMIT ' . (is_array($limit) ? implode(', ', $limit) : $limit)) :
                '';

        return $q . $c . $o . $l;
    }

    protected static function exportData()
    {
        $data = self::$exportDataAsDisplayed ?
                self::$data :
                self::select(self::$t['q']);
        $fnReplace = [];
        $fnReplace[':app'] = self::$app;
        $fnReplace[':items'] = self::$t['items'];
        $format = str_replace(':', '.', '%d.%m.%Y  %H:%i:%s');
        $timeQuery = 'SELECT DATE_FORMAT(Now(), "' . $format . '") AS `now`;';
        $fnReplace[':datetime'] = self::select($timeQuery);
        $outFilename = strtr(self::config('EXPORT_FILE_NAME'), $fnReplace);
        $outColumns = $outHeader = [];
        foreach (self::$cols as $c) {
            if (isset($c[2]['sort'])&&$c[2]['sort'] ===false) {
                continue;
            }
            $outColumns[] = $c[1];
            $outHeader[] = $c[0];
        }
        $eData = [$outHeader];
        if (count($data)>0) {
            foreach ($data as $row) {
                $rowData = [];
                foreach ($row as $dbName => $value) {
                    if (in_array($dbName, $outColumns)) {
                        $rowData[] = is_array($value) ? $value[0] : $value;
                    }
                }
                $eData[] = $rowData;
            }
        }

        switch (self::$export) {
            case 'Excel':
            case 'CSV':
                $escape = function($v) {
                    return str_replace("\t", "&#9;", $v);
                };
                header('Content-Type:application/csv');
                header('Content-Disposition:attachment; filename=' .
                        $outFilename . '.csv');
                
                $output = fopen('php://output', 'w');
                foreach ($eData as $v) {
                    self::$export ==='CSV' ?
                                    fputcsv($output, $v) :
                                    fputs($output, implode("\t", array_map($escape, $v)) . "\r\n");
                }
                fclose($output);
                break;
        }
    }

    protected static function jsonGetBodyData()
    {
        $json = $outColumns = [];
        foreach (self::$cols as $c) {
            $outColumns[] = isset($c[1]) ? $c[1] : null;
        }
        if ((self::$t['rows'] = count(self::$data))>0) {
            foreach (self::$data as $row) {
                $rowData = [];
                foreach ($outColumns as $dbName) {
                    $rowData[] = array_key_exists($dbName, $row) ?
                            $row[$dbName] : '';
                }
                $json[] = $rowData;
            }
        } else {
            $attr = ['colspan' => count(self::$cols), 'class' => 'no-results'];
            $json[] = [[self::config('EMPTY_TABLE_MSG'), $attr]];
        }
        return $json;
    }

    protected static function jsonGetFooterData()
    {
        $jsonArrFooter = [];
        if (count(self::$data)>0) {
            $pageNo = self::$t['page'];
            if ($pageNo ===1&&count(self::$data)<self::$t['paging']) {
                //Skips total count query
                self::$t['rows'] = count(self::$data);
            } else {
                $q = 'SELECT COUNT(*) FROM (' . self::$t['qAll'] . ') AS dt';
                self::$t['rows'] = self::select($q);
            }
            self::$t['pages'] = ceil(self::$t['rows']/self::$t['paging']);

            $v = [];

            $v['from'] = ($pageNo-1)*self::$t['paging']+1;
            $v['upto'] = ($pageNo*self::$t['paging']<self::$t['rows']) ?
                    $pageNo*self::$t['paging'] :
                    self::$t['rows'];

            $v["total"] = self::$t['rows'];
            $v["items"] = self::$t['items'];

            if (self::$exportActive ===true) {
                $url = strtok(self::$t['slug'], "?&") . ".json?table=" .
                        self::$t['items'] . "&export=";
                $v["export"] = ["url" => $url, "types" => self::config('SAVES')];
            }

            self::paging($v);

            $html = self::view('views/table.footer.html', $v);

            $jsonArrFooter[] = [[$html, ["colspan" => count(self::$cols)]]];
        }
        return $jsonArrFooter;
    }

    protected static function load()
    {
        $items = self::$t['items'];
        $v = ['items' => $items];
        $div_attr = ['id' => $items . '-list', 'class' => 'table'];
        if (array_key_exists('div', self::$attributes)) {
            $div_attr += self::$attributes['div'];
        }
        if (isset(self::$attributes['div']['class'])) {
            $div_attr['class'] .= ' ' . self::$attributes['div']['class'];
        }
        $v['div_attributes'] = self::attributes($div_attr);

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

        $tbl_attr = ['id' => $items . '-table', 'data-table' => 'js'];
        if (array_key_exists('table', self::$attributes)) {
            $tbl_attr += self::$attributes['table'];
        }
        $v['table_attributes'] = self::attributes($tbl_attr);

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

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

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

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

    private static function rows($for)
    {
        $trs = '';
        if ($for ==='body') {
            foreach (self::jsonGetBodyData() as $r) {
                if (isset($r[0][1], $r[0][1]['class'])&&
                        $r[0][1]['class'] ==='no-results'
                ) {
                    $trs .= '<tr><td' . self::attributes($r[0][1]) . '>'
                            . $r[0][0] . '</td></tr>';
                } else {
                    $trs .= '<tr><td>' . implode('</td><td>', $r)
                            . '</td></tr>';
                }
            }
        } else if ($for ==='footer') {
            if (self::$t['rows']>0) {
                $ftr = self::jsonGetFooterData()[0][0];
                $trs .= '<tr><td' . self::attributes($ftr[1]) . '>'
                        . $ftr[0] . '</td></tr>';
            }
        }
        return $trs;
    }

    protected static function reset($tableId)
    {
        if (!in_array($tableId, self::$t["tables"])) {
            self::$t["tables"][] = $tableId;
            self::$cols = [];
            self::$t['rows'] = null;
        } else {
            die('Existing table-id used in a table::create(): ' . $tableId);

Using exit here is not recommended.

        }
    }

    static function select(string $expression, array $bindings = [])

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

    {
        if (is_object(static::$select)&&(static::$select instanceof Closure)) {
            $select = static::$select;
            $res = $select($expression, $bindings);
            //if result is single cell value ($res[0]->value), return the value
            return (count($res) ===1&&count((array) $res[0]) ===1) ?
                    reset($res[0]) :
                    $res;
        } else {
            die('ERROR: table::$select is not a valid closure. '

Using exit here is not recommended.

                    . __METHOD__ . '() #' . __LINE__);
        }
    }
}