webdivane / table

table_getter.php

Indentation +5 added lines, -5 removed lines

@@ -18,7 +18,7 @@ 
     public static $pageExt;
 
     protected static function ths() {
-		if (self::$cols) {
+        if (self::$cols) {
             $ths = [];
             for ($i = 0; $i < sizeof(self::$cols); $i++) {
                 list($lbl, $col, $arg) = array_pad(self::$cols[$i], 3, null);
@@ -74,8 +74,8 @@ 
                 $ths[] = $th;
             }
             return implode('', $ths);
-		}
-	}
+        }
+    }
 
     /** Adds conditions, orderBy and Limits to query.
      * @param string $q
@@ -103,7 +103,7 @@ 
                 '';
 
         return $q . $c . $o . $l;
-	}
+    }
 
     protected static function exportData(){
         $data = self::$exportDataAsDisplayed ?
@@ -200,7 +200,7 @@ 
 
             if(self::$exportActive === true){
                 $url = strtok(self::$t['slug'],"?&") . ".json?table=" .
-                       self::$t['items'] . "&export=";
+                        self::$t['items'] . "&export=";
                 $v["export"] = ["url"=>$url, "types"=>self::config('SAVES')];
             }
 

Spacing +57 added lines, -66 removed lines

@@ -23,51 +23,48 @@ 
             for ($i = 0; $i < sizeof(self::$cols); $i++) {
                 list($lbl, $col, $arg) = array_pad(self::$cols[$i], 3, null);
 
-                if(is_null($col)){ $arg['sort']=false;}
+                if (is_null($col)) { $arg['sort'] = false; }
 
                 $sortable = !isset($arg['sort']) || $arg['sort'] !== false;
 
                 $sort = $sortable ?
-                        (isset($arg['sort']) ? $arg['sort'] : $col) :
-                        null;
+                        (isset($arg['sort']) ? $arg['sort'] : $col) : null;
 
-                if(($del = isset($arg['type']) && $arg['type'] == 'delete')){
+                if (($del = isset($arg['type']) && $arg['type'] == 'delete')) {
                     $sortable = false;
-                    if(!isset($arg['width']) &&
+                    if (!isset($arg['width']) &&
                         false === strpos($arg['width'], 'width:')
                     ) {
                         $arg['width'] = '1%';
                     }
                 }
 
-                if(isset($arg['width'])) { // Width attribute -> style
+                if (isset($arg['width'])) { // Width attribute -> style
                     $width = 'width:' . $arg['width'] . ';';
                     $arg['style'] = isset($arg['style']) ?
-                                    $width . $arg['style'] :
-                                    $width;
+                                    $width . $arg['style'] : $width;
                 }
 
                 $attr = array_diff_key((array)$arg, ['sort', 'type', 'width']);
 
                 $th = '<th' . self::attributes($attr) . '>';
-                if($sortable){
+                if ($sortable) {
                     $th .= '<a onclick="table.Sort(' . $i . ',this);">';
                 }
                 if (!$del) {
-                    if($sort == self::$t['order']['col']) {
+                    if ($sort == self::$t['order']['col']) {
                         $span = self::$t['order']['dir'] === 'desc' ?
-                                self::config('UTF8_DESC_SYMBOL') :
-                                self::config('UTF8_ASC_SYMBOL');
+                                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"' .
+                    $th .= '<input id="' . self::$t['items'] . 'CheckDeleteAll"' .
                             ' onclick=\"checkAllDeleteCheckboxes(this,' .
-                            ' \''.self::$t['items'].'\')" type="checkbox"/>';
+                            ' \'' . self::$t['items'] . '\')" type="checkbox"/>';
                 }
-                if($sortable){
+                if ($sortable) {
                     $th .= '</a>';
                 }
                 $th .= '</th>';
@@ -84,11 +81,10 @@ 
      * @param int|arr $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, $order=[], $limit=0, $h=false){
+    protected static function q($q, $cond = null, $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 ) :
-                '';
+        $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(', ',
@@ -99,35 +95,33 @@ 
                 '';
         //Limit: '' | ' LIMIT ' . '(20, 40|20)'
         $l = !empty($limit) ?
-                (' LIMIT ' . (is_array($limit) ? implode(', ',$limit) : $limit)) :
-                '';
+                (' LIMIT ' . (is_array($limit) ? implode(', ', $limit) : $limit)) : '';
 
         return $q . $c . $o . $l;
 	}
 
-    protected static function exportData(){
+    protected static function exportData() {
         $data = self::$exportDataAsDisplayed ?
-                self::$data :
-                self::select(self::$t['q']);
+                self::$data : self::select(self::$t['q']);
         $fnReplace = [];
-        $fnReplace[':app']= self::$app;
-        $fnReplace[':items']= self::$t['items'];
+        $fnReplace[':app'] = self::$app;
+        $fnReplace[':items'] = self::$t['items'];
         $format = str_replace(':', ' ', GLOBAL_MYSQL_DATETIME_LONG);
         $timeQuery = 'SELECT DATE_FORMAT(Now(), "' . $format . '") AS `now`;';
         $fnReplace[':datetime'] = self::select($timeQuery);
         $outFilename = strtr(self::config('EXPORT_FILE_NAME'), $fnReplace);
         $outColumns = [];
-        foreach(self::$cols as $c){
-            if(isset($c[2]['sort']) && $c[2]['sort']===false){continue;}
+        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 $k => $row){
+        if (count($data) > 0) {
+            foreach ($data as $k => $row) {
                 $rowData = [];
-                foreach($row as $dbName => $value){
-                    if(in_array($dbName,$outColumns)){
+                foreach ($row as $dbName => $value) {
+                    if (in_array($dbName, $outColumns)) {
                         $rowData[] = is_array($value) ? $value[0] : $value;
                     }
                 }
@@ -135,71 +129,69 @@ 
             }
         }
 
-        switch(self::$export){
+        switch (self::$export) {
             case 'Excel':
             case 'CSV':
-                $escape = function($v){ return str_replace("\t", "&#9;" ,$v); };
+                $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')
+                $output = fopen('php://output', 'w')
                           or die('Can\'t open php://output');
-                foreach($eData as $v){
+                foreach ($eData as $v) {
                     self::$export === 'CSV' ?
-                    fputcsv($output, $v) :
-                    fputs($output, implode("\t",array_map($escape, $v))."\r\n");
+                    fputcsv($output, $v) : fputs($output, implode("\t", array_map($escape, $v)) . "\r\n");
                 }
                 fclose($output) or die('Can\'t close php://output');
                 break;
         }
     }
 
-    protected static function jsonGetBodyData(){
+    protected static function jsonGetBodyData() {
         $json = $outColumns = [];
-        foreach(self::$cols as $c){
+        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){
+        if ((self::$t['rows'] = count(self::$data)) > 0) {
+            foreach (self::$data as $row) {
                 $rowData = [];
-                foreach($outColumns as $dbName){
+                foreach ($outColumns as $dbName) {
                         $rowData[] = array_key_exists($dbName, $row) ?
                                      $row[$dbName] : '';
                 }
                 $json[] = $rowData;
             }
         } else {
-            $attr = ['colspan'=>count(self::$cols),'class'=>'no-results'];
+            $attr = ['colspan'=>count(self::$cols), 'class'=>'no-results'];
             $json[] = [[self::config('EMPTY_TABLE_MSG'), $attr]];
         }
         return $json;
     }
 
-    protected static function jsonGetFooterData(){
+    protected static function jsonGetFooterData() {
         $jsonArrFooter = [];
-        if(count(self::$data) > 0) {
+        if (count(self::$data) > 0) {
             $pageNo = self::$t['page'];
-            if($pageNo === 1 && count(self::$data) < self::$t['paging'] ){
+            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';
+                $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['from'] = ($pageNo - 1)*self::$t['paging'] + 1;
             $v['upto'] = ($pageNo*self::$t['paging'] < self::$t['rows']) ?
-                         $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=" .
+            if (self::$exportActive === true) {
+                $url = strtok(self::$t['slug'], "?&") . ".json?table=" .
                        self::$t['items'] . "&export=";
                 $v["export"] = ["url"=>$url, "types"=>self::config('SAVES')];
             }
@@ -208,7 +200,7 @@ 
 
             $html = self::view('views/table.footer.html', $v);
 
-            $jsonArrFooter[] = [[$html,["colspan"=>count(self::$cols)]]];
+            $jsonArrFooter[] = [[$html, ["colspan"=>count(self::$cols)]]];
         }
         return $jsonArrFooter;
     }
@@ -217,20 +209,20 @@ 
         $items = self::$t['items'];
         $v = ['items' => $items];
         $div_attr = ['id'=>$items . '-list', 'class'=>'table'];
-        if(array_key_exists('div', self::$attributes)){
+        if (array_key_exists('div', self::$attributes)) {
             $div_attr += self::$attributes['div'];
         }
-        if(isset(self::$attributes['div']['class'])){
+        if (isset(self::$attributes['div']['class'])) {
             $div_attr['class'] .= ' ' . self::$attributes['div']['class'];
         }
         $v['div_attributes'] = self::attributes($div_attr);
 
-        if(self::$filterActive){
+        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)){
+        if (array_key_exists('table', self::$attributes)) {
             $tbl_attr += self::$attributes['table'];
         }
         $v['table_attributes'] = self::attributes($tbl_attr);
@@ -259,7 +251,7 @@ 
                             . '</td></tr>';
                 }
             }
-        } else if($for === 'footer') {
+        } else if ($for === 'footer') {
             if (self::$t['rows'] > 0) {
                 $ftr = self::jsonGetFooterData()[0][0];
                 $trs .= '<tr><td' . self::attributes($ftr[1]) . '>'
@@ -269,8 +261,8 @@ 
         return $trs;
     }
 
-    protected static function reset($tableId){
-        if(!in_array($tableId, self::$t["tables"])){
+    protected static function reset($tableId) {
+        if (!in_array($tableId, self::$t["tables"])) {
             self::$t["tables"][] = $tableId;
             self::$cols = [];
             self::$t['rows'] = null;
@@ -279,17 +271,16 @@ 
         }
     }
 
-    static function select(string $expression, array $bindings = []){
-        if(is_object(static::$select) && (static::$select instanceof Closure)){
+    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;
+                    reset($res[0]) : $res;
         } else {
             die('ERROR: table::$select is not a valid closure. '
-                .__METHOD__.'() #'.__LINE__);
+                .__METHOD__ . '() #' . __LINE__);
         }
     }
 }

table_setter.php

Spacing +44 added lines, -47 removed lines

@@ -12,12 +12,12 @@ 
     /** @param array Re-settable values for current table call*/
     protected static $config;
 
-    static function assets($path = "/public/table"){
+    static function assets($path = "/public/table") {
         return  "<script src=\"{$path}/table.js\"></script>\n\t" .
                 "<link href=\"{$path}/table.css\" rel=\"stylesheet\">\n";
     }
 
-    public static function config($c){
+    public static function config($c) {
         self::$config = self::$config ?: [
             'DB_COLLATION_CI' => 'utf8mb4_general_ci', //UTF8_GENERAL_CI
             'EMPTY_TABLE_MSG' => 'No results found.',
@@ -29,9 +29,9 @@ 
             'UTF8_LEFT_SYMBOL' => '&lsaquo;',
             'UTF8_RIGHT_SYMBOL' => '&rsaquo;'
         ];
-        switch(gettype($c)){
+        switch (gettype($c)) {
             case 'array';
-                foreach($c as $k => $v){
+                foreach ($c as $k => $v) {
                     self::$config[$k] = $v;
                 }
                 break;
@@ -43,36 +43,36 @@ 
     /** Converts array to space separated key value list
      * @param array $attributes
      * @return string */
-    protected static function attributes(array $attributes){
+    protected static function attributes(array $attributes) {
         $list = [];
-        foreach($attributes as $key => $value){
-            if(is_bool($value)) {
-                if((bool)$value){
+        foreach ($attributes as $key => $value) {
+            if (is_bool($value)) {
+                if ((bool)$value) {
                     $list[] = $key;
                 }
             } else if (empty($value) && !is_int($value)) {
                 $list[] = $key;
             } else {
-                $list[] = $key.'="'.$value.'"';
+                $list[] = $key . '="' . $value . '"';
             }
         }
-        return (count($list)>0 ? ' ': '') . join(' ', $list);
+        return (count($list) > 0 ? ' ' : '') . join(' ', $list);
     }
 
     /** Parses view to string
      * @param string $template
      * @param array $vars
      * @return string */
-    protected static function view($template, $vars = []){
+    protected static function view($template, $vars = []) {
         extract($vars);
         ob_start();
         require $template;
-        return (string) ob_get_clean();
+        return (string)ob_get_clean();
     }
 
     protected static function paging(&$v) {
-        if(self::$t['pages'] > 1){
-            $v['pages']= self::$t['pages'];
+        if (self::$t['pages'] > 1) {
+            $v['pages'] = self::$t['pages'];
             $v['page'] = self::$t['page'];
             $v['jumpL'] = self::pagingJumps();
             $v['jumpR'] = self::pagingJumps();
@@ -81,11 +81,11 @@ 
 
             $limit = 10;
 
-            $v['start'] =  $v['page'] > ($limit/2) ? ($v['page']-$limit/2) : 1;
+            $v['start'] = $v['page'] > ($limit/2) ? ($v['page'] - $limit/2) : 1;
 
-            if($v['page'] > ($v['pages']-($limit/2))){
+            if ($v['page'] > ($v['pages'] - ($limit/2))) {
                 $v['final'] = $v['pages'];
-            } else if($v['page'] > ($limit/2)){
+            } else if ($v['page'] > ($limit/2)) {
                 $v['final'] = $v['start'] + $limit;
             } else {
                 $v['final'] = $limit;
@@ -100,58 +100,58 @@ 
     protected static function pagingJumps($html = '', $m = null) {
         static $direction;
 
-        if(is_null($m)){ //on self::createPaginationLinks() calls only
+        if (is_null($m)) { //on self::createPaginationLinks() calls only
             $direction = !isset($direction) ? '-' : '+';
             $m = 100;
         }
         $jump2show = function($m) use ($direction){
-            if(    $m>=1000000){    return ($direction . ($m/1000000)."M");
-            } else if($m>=1000){    return ($direction . ($m/1000)."K");
+            if ($m >= 1000000) {    return ($direction . ($m/1000000) . "M");
+            } else if ($m >= 1000) {    return ($direction . ($m/1000) . "K");
             } else {                return ($direction . $m); }
         };
         $add = '<li class="jump"><a>' . $jump2show($m) . '</a></li>';
 
-        if($direction === '-'){
+        if ($direction === '-') {
             $jump_exists = (self::$t['page'] - $m) > 0;
         } else {
             $jump_exists = (self::$t['page'] + $m) <= self::$t['pages'];
         }
 
-        if($jump_exists){
+        if ($jump_exists) {
             $html = $direction === '-' ? $add . $html : $html . $add;
         }
 
-        return $jump_exists ? self::pagingJumps($html, ($m * 10)) : $html;
+        return $jump_exists ? self::pagingJumps($html, ($m*10)) : $html;
     }
 
-    protected static function filterValues(&$f, &$opts=[]){
+    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;}
-            if(empty($v)){ $v=[null]; } // fix for column requested as []
+        foreach (self::$cols as $k => $v) {
+            if (isset($v[2]['sort']) && $v[2]['sort'] === false) {continue; }
+            if (empty($v)) { $v = [null]; } // fix for column requested as []
             $selected = $by === $k ? ' selected' : null;
             $opts[] = "<option value=\"{$k}\"{$selected}>{$v[0]}</option>";
         }
     }
 
-    protected static function requestFilter(){
+    protected static function requestFilter() {
         $filter = filter_input(INPUT_GET, 'filter') ?: false;
-        if($filter){
+        if ($filter) {
             $by = filter_input(INPUT_GET, 'filter-by', FILTER_VALIDATE_INT);
-            if($by === false || is_null($by)){
+            if ($by === false || is_null($by)) {
                 $by = [];
-                foreach(self::$cols as $v){
-                    if(isset($v[2]['sort']) && $v[2]['sort']===false){continue;}
+                foreach (self::$cols as $v) {
+                    if (isset($v[2]['sort']) && $v[2]['sort'] === false) {continue; }
                     $by[] = 'IFNULL(' . $v[1] . ', "")';
                 }
-                $by = 'CONCAT('.implode(',',$by).')';
+                $by = 'CONCAT(' . implode(',', $by) . ')';
             } else {
                 $by = self::$cols[$by][1];
             }
-            $by = 'CONCAT(" ",'.$by.', " ")';
-            if(self::config('FILTER_CASE_SENSITIVE') !== true) {
+            $by = 'CONCAT(" ",' . $by . ', " ")';
+            if (self::config('FILTER_CASE_SENSITIVE') !== true) {
                 $by .= ' COLLATE ' . self::config('DB_COLLATION_CI');
             }
             $filter = $by . ' LIKE ' . '"%' . $filter . '%"';
@@ -159,30 +159,27 @@ 
         return $filter;
     }
 
-    protected static function requestOrderCol(){
-        if(($col = filter_input(INPUT_GET, 'col', FILTER_VALIDATE_INT))){
+    protected static function requestOrderCol() {
+        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];
+                    self::$cols[$col][2]['sort'] : self::$cols[$col][1];
         }
         return self::$t['order']['col'];
     }
 
-    protected static function requestOrderDir(){
+    protected static function requestOrderDir() {
         $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']);
+                filter_input(INPUT_GET, 'ord') : ($reset ?: self::$t['order']['dir']);
     }
 
-    protected static function requestExport(){
-        $exp = filter_input(INPUT_GET,'export', FILTER_SANITIZE_STRING);
+    protected static function requestExport() {
+        $exp = filter_input(INPUT_GET, 'export', FILTER_SANITIZE_STRING);
         return  in_array($exp, self::config('SAVES')) ? $exp : false;
     }
 
-    protected static function requestPage(){
+    protected static function requestPage() {
         return filter_has_var(INPUT_GET, 'pg') && self::$export == false ?
-                (int)filter_input(INPUT_GET, 'pg', FILTER_SANITIZE_NUMBER_INT) :
-                self::$t['page'];
+                (int)filter_input(INPUT_GET, 'pg', FILTER_SANITIZE_NUMBER_INT) : self::$t['page'];
     }
 }

table.php

Spacing +4 added lines, -7 removed lines

@@ -33,10 +33,8 @@ 
         self::prepare(true);
         self::$t['order']['col'] = $orderBy;
         $dir = strtolower($orderDir);
-        self::$t['order']['dir'] = in_array($dir, ['asc', 'desc']) ? $dir :
-                die('Invalid orderDir(Asc/Desc): ' . $orderDir);
-        self::$t['paging'] = ($p = abs($paging)) > 10 ? $p :
-                die('Invalid paging(>10): ' . $paging);
+        self::$t['order']['dir'] = in_array($dir, ['asc', 'desc']) ? $dir : die('Invalid orderDir(Asc/Desc): ' . $orderDir);
+        self::$t['paging'] = ($p = abs($paging)) > 10 ? $p : die('Invalid paging(>10): ' . $paging);
     }
 
     /** #2. Execute (queries)
@@ -55,7 +53,7 @@ 
 
         $filter = self::requestFilter();
         $order = [self::$t['order']['col'] => self::$t['order']['dir']];
-        $offset = (self::$t['page'] - 1) * self::$t['paging'];
+        $offset = (self::$t['page'] - 1)*self::$t['paging'];
         $limit = [$offset, self::$t['paging']];
         self::$t['q'] = self::q($q, $filter, $order, $limit, true);
 
@@ -99,8 +97,7 @@ 
     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);
+        $uri = filter_input(INPUT_SERVER, 'REQUEST_URI', FILTER_SANITIZE_URL) ?: filter_var($_SERVER['REQUEST_URI'], FILTER_SANITIZE_URL);
 
         $extension = pathinfo(strtok($uri, '?'), PATHINFO_EXTENSION);