tfoot

Complexity

Total Complexity

14

Size/Duplication

Total Lines	76
Duplicated Lines	0 %

Importance

Changes	1
Bugs	0	Features	0

3 Methods

Rating	Name	Duplication	Size	Complexity
B	jsonGetFooterData()	0	39	6
A	rowsTfoot()	0	12	3
A	select()	0	11	5

<?php

class tfoot
{
    use trait_tfoot_setter, trait_tfoot_paging;
    
    /** @param string class name, where $helper::prepare() is expected */
    public static $helper_class;
    /** @param closure to MySql select function (example: db::select()) */
    public static $select;
    
    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')];
            }
            
            $v['errors'] = self::err();

            self::paging($v);

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

            $jsonArrFooter[] = [[$html, ["colspan" => count(self::$cols)]]];
        }
        return $jsonArrFooter;
    }
    
    public static function select(string $expression, array $bindings = [])
    {
        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 {
            throw new Exception('ERROR: table::$select is not a closure. ');
        }
    }
    
    protected static function rowsTfoot()
    {
        $trs = '';
        if (self::$t['rows'] > 0) {
            $ftr = self::jsonGetFooterData()[0][0];
            $trs .= '<tr><td' . self::attributes($ftr[1]) . '>'
                    . $ftr[0] . '</td></tr>';
        } else if(count(self::$errors)>0) {
            $trs .= '<tr><td colspan="'.count(self::$cols).'">' . 
                    self::err() . '</td></tr>';
        }
        return $trs;
    }
}