webdivane / table

table.php

<?php

/**
 * Note: table::prepare() - call must come before `headers_sent()`;
 *     1. Create (initial setup):
 *        <code>table::create('tableId', 'sortByDbCol', 'sortDirection');</code>
 *     1.1. Set columns to be displayed: <code>
 *          table::$cols[] = ['innerHtml', 'dbColumn|Name',
 *                                      ['width'=>'?px','sort'=>false]];</code>
 *     2. Execute (data query)
 *        <code>table::execute(sqlQuery);</code>
 *     2.1. Alter loaded data, before table load <code>
 *          foreach(table::$data as $r => &$cells){
 *              $cells['id'] = $cells['id']==3 ?
 *                              [$cells['id'] ,['class'=>'red']] : $cells['id'];
 *          }</code>
 *     3. Loads the markup, or json data (on sort/page/export etc. actions).
 *        <code>table::load();</code>
 */
class Table extends Thead
{

    use trait_request;

    /**
     * Adds needed JavaScript and CSS into the page header, it has to be
     * included before "headers_sent()".
     *
     * @param string|bool $setOrCheck - uses helper class to verify own load */
    public static function prepare($setOrCheck = false)
    {
        //@see  http://php.net/manual/es/function.filter-input.php#77307
        $uri = filter_input(INPUT_SERVER, 'REQUEST_URI', FILTER_SANITIZE_URL) ?:
            filter_var($_SERVER['REQUEST_URI'], FILTER_SANITIZE_URL);

        $extension = pathinfo(strtok($uri, '?'), PATHINFO_EXTENSION);

        self::$t['slug'] = pathinfo($uri, PATHINFO_BASENAME);
        self::$pageExt = strtolower($extension);

        if (self::$helperClass::prepare(__METHOD__, $setOrCheck) !== true) {
            if (self::$pageExt === 'json' && !isset(self::$t['prepared'])) {
                ob_start();
                self::$t['prepared'] = true;
            }
        }
    }

    /**
     * #1. Create (setup)
     * @param string $items - The items name
     * @param string $orderBy - a db column name
     * @param string $orderDir - (Default: self::DEFAULT_SORT_ORDER)
     * @param int $paging - Rows per page */
    public static function create(
        $items,
        $orderBy,
        $orderDir = 'asc',
        $paging = 10
    )
    {
        self::reset((self::$t['items'] = (string) $items));

self::t['items'] = (string)$items of type string is incompatible with the type strings expected by parameter $items of Tfoot::reset().

        self::prepare(true);
        self::$t['order']['col'] = $orderBy;
        $dir = strtolower($orderDir);
        self::$t['order']['dir'] = in_array($dir, ['asc', 'desc']) ?
                $dir : self::error('Invalid orderDir (Asc/Desc): ' . $orderDir);
        self::$t['paging'] = ($num = abs($paging)) > 10 ?
                $num : self::error('Invalid paging (>10): ' . $paging);
    }

    /**
     * #2. Execute (queries)
     * @param string        $query - query for the table data;
     * @param (null)|string $qTotal - simple version of $sql if applicable
     *                          (used only for Total count in the table footer).
     *
     * Example: <pre>$sql = 'SELECT `id`, ... FROM `table` WHERE ...'</pre>
     * For query to many thousands results, will be faster to have:
     * <pre>$sqlTotals = 'SELECT `id` FROM `table` WHERE ...'</pre> */
    public static function execute($query, $qTotal = null)
    {
        self::$t = self::request(self::$export);

        $order = [self::$t['order']['col'] => self::$t['order']['dir']];
        $offset = (self::$t['page'] - 1) * self::$t['paging'];
        $limit = [$offset, self::$t['paging']];
        self::$t['q'] = self::query($query, self::$t['filter'], $order, $limit, true);

        $qAll = isset($qTotal) && !self::$t['filter'] ? $qTotal : $query;
        $ordAll = !self::$export ? [] : $order;
        self::$t['qAll'] = self::query($qAll, self::$t['filter'], $ordAll, 0, true);

        $query = !self::$export ? self::$t['q'] : self::$t['qAll'];

        try {
            self::$data = self::select($query);
        } catch (Exception $e) {
            self::error('ERROR: ' . $query . '<br />' . $e->getMessage());
        }
    }

    /**
     * #3. Loads output (HTML, JSON or CSV file) */
    public static function load()
    {
        if (self::$pageExt !== 'json') {
            echo parent::load();
        } else {
            $tableId = filter_input(INPUT_GET, 'table-id') ?: null;
            if ($tableId === self::$t['items'] . '-table') {
                ob_get_clean();
                ob_start("ob_gzhandler");
                if (!self::$export) {
                    header('Content-Type: application/json');
                    $jsonArr = ['body' => self::jsonTbody(),
                        'footer' => self::jsonTfoot()];
                    echo json_encode($jsonArr);
                } else {
                    self::export();
                }
                ob_end_flush();
            }
        }
    }
}