webdivane / table

TraitQuery.php

Spacing +5 added lines, -5 removed lines

@@ -36,17 +36,17 @@ 
         if (!empty($cond)) {
             $clause = !$useHaving ? 'WHERE' : 'HAVING';
             $clue = !strpos($query, $clause) ? $clause : 'AND';
-            $query .= (' '.$clue.' '.$cond);
+            $query .= (' ' . $clue . ' ' . $cond);
         }
     }
 
     private static function queryOrder(&$query, $order)
     {
         if (!empty($order)) {
-            $arr = array_map(function (&$value, $key) {
-                return $key.' '.strtoupper($value);
+            $arr = array_map(function(&$value, $key) {
+                return $key . ' ' . strtoupper($value);
             }, $order, array_keys($order));
-            $query .= (' ORDER BY '.implode(', ', $arr));
+            $query .= (' ORDER BY ' . implode(', ', $arr));
         }
     }
 
@@ -54,7 +54,7 @@ 
     {
         if (!empty($limit)) {
             $value = (is_array($limit) ? implode(', ', $limit) : $limit);
-            $query .= (' LIMIT '.$value);
+            $query .= (' LIMIT ' . $value);
         }
     }
 }

Tfoot.php

Spacing +12 added lines, -14 removed lines

@@ -17,8 +17,8 @@ 
             $vars = [];
             self::showingMessageVars($vars);
             if (self::$exportActive === true) {
-                $url = strtok(self::$t['slug'], '?&').'.json?table='.
-                    self::$t['items'].'&export=';
+                $url = strtok(self::$t['slug'], '?&') . '.json?table=' .
+                    self::$t['items'] . '&export=';
                 $vars['export']['url'] = $url;
                 $vars['export']['types'] = self::config('SAVES');
             }
@@ -38,15 +38,14 @@ 
             //Skips total count query
             self::$t['rows'] = count(self::$data);
         } else {
-            $query = 'SELECT COUNT(*) FROM ('.self::$t['qAll'].') AS dt';
+            $query = 'SELECT COUNT(*) FROM (' . self::$t['qAll'] . ') AS dt';
             self::$t['rows'] = self::select($query);
         }
-        self::$t['pages'] = ceil(self::$t['rows'] / self::$t['paging']);
+        self::$t['pages'] = ceil(self::$t['rows']/self::$t['paging']);
 
-        $vars['from'] = ($pageNo - 1) * self::$t['paging'] + 1;
-        $vars['upto'] = ($pageNo * self::$t['paging'] < self::$t['rows']) ?
-            $pageNo * self::$t['paging'] :
-            self::$t['rows'];
+        $vars['from'] = ($pageNo - 1)*self::$t['paging'] + 1;
+        $vars['upto'] = ($pageNo*self::$t['paging'] < self::$t['rows']) ?
+            $pageNo*self::$t['paging'] : self::$t['rows'];
 
         $vars['total'] = self::$t['rows'];
         $vars['items'] = self::$t['items'];
@@ -57,11 +56,11 @@ 
         $trs = '';
         if (self::$t['rows'] > 0) {
             $ftr = self::jsonTfoot()[0][0];
-            $trs .= '<tr><td'.self::attributes($ftr[1]).'>'
-                .$ftr[0].'</td></tr>';
+            $trs .= '<tr><td' . self::attributes($ftr[1]) . '>'
+                .$ftr[0] . '</td></tr>';
         } elseif (count(self::$errors) > 0) {
-            $trs .= '<tr><td colspan="'.count(self::$cols).'">'.
-                self::error().'</td></tr>';
+            $trs .= '<tr><td colspan="' . count(self::$cols) . '">' .
+                self::error() . '</td></tr>';
         }
 
         return $trs;
@@ -74,8 +73,7 @@ 
             $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 {
             throw new Exception('ERROR: table::$select is not a closure. ');
         }

Thead.php

Spacing +12 added lines, -16 removed lines

@@ -31,8 +31,7 @@ 
 
     protected static function filterValues(&$filter, &$opts = [])
     {
-        $filter = filter_input(INPUT_GET, 'filter', FILTER_SANITIZE_STRING) ?:
-            null;
+        $filter = filter_input(INPUT_GET, 'filter', FILTER_SANITIZE_STRING) ?: null;
 
         $filterBy = filter_input(INPUT_GET, 'filter-by', FILTER_VALIDATE_INT);
         foreach (self::$cols as $key => $value) {
@@ -47,15 +46,14 @@ 
     private static function tagAttributes($tag, $items)
     {
         $attr = $tag === 'div' ?
-            ['id' => $items.'-list', 'class' => 'table'] :
-            ['id'         => $items.'-table', 'data-table' => 'js',
+            ['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'];
+            $attr['class'] .= ' ' . self::$attributes[$tag]['class'];
         }
 
         return self::attributes($attr);
@@ -85,10 +83,9 @@ 
     private static function thAttributes($col, $arg, &$sort, &$del)
     {
         if (isset($arg['width'])) { // Width attribute -> style
-            $width = 'width:'.$arg['width'].';';
+            $width = 'width:' . $arg['width'] . ';';
             $arg['style'] = isset($arg['style']) ?
-                $width.$arg['style'] :
-                $width;
+                $width . $arg['style'] : $width;
         }
 
         if (($del = isset($arg['type']) && $arg['type'] == 'delete')) {
@@ -102,23 +99,22 @@ 
 
     private static function thTag($index, $attr, $sort, $del, $lbl)
     {
-        $tag = '<th'.self::attributes($attr).'>';
+        $tag = '<th' . self::attributes($attr) . '>';
         if ($sort) {
-            $tag .= '<a onclick="table.Sort('.$index.',this);">';
+            $tag .= '<a onclick="table.Sort(' . $index . ',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');
+                    self::config('UTF8_DESC_SYMBOL') : self::config('UTF8_ASC_SYMBOL');
             } else {
                 $span = '';
             }
-            $tag .= '<span>'.$span.'</span>'.$lbl;
+            $tag .= '<span>' . $span . '</span>' . $lbl;
         } else {
-            $tag .= '<input id="'.self::$t['items'].'CheckDeleteAll"'.
-                ' onclick=\"checkAllDeleteCheckboxes(this,'.
-                ' \''.self::$t['items'].'\')" type="checkbox"/>';
+            $tag .= '<input id="' . self::$t['items'] . 'CheckDeleteAll"' .
+                ' onclick=\"checkAllDeleteCheckboxes(this,' .
+                ' \'' . self::$t['items'] . '\')" type="checkbox"/>';
         }
         if ($sort) {
             $tag .= '</a>';

TraitConfig.php

Spacing +3 added lines, -3 removed lines

@@ -38,7 +38,7 @@ 
                     throw new Exception('Invalid value type.');
             }
         } catch (Exception $e) {
-            self::error('ERROR: '.$e->getMessage());
+            self::error('ERROR: ' . $e->getMessage());
         }
     }
 
@@ -48,14 +48,14 @@ 
             self::$errors[] = $message;
         } else {
             return empty(self::$errors) ? null :
-                '<p class="tbl-err">'.implode('</br>', self::$errors).'</p>';
+                '<p class="tbl-err">' . implode('</br>', self::$errors) . '</p>';
         }
     }
 
     private static function valid($key, $val = null)
     {
         if (!array_key_exists($key, self::$config)) {
-            throw new Exception('Request to undefined value: '.$key);
+            throw new Exception('Request to undefined value: ' . $key);
         }
 
         if ($val !== null) {

TraitPaging.php

Spacing +11 added lines, -13 removed lines

@@ -14,13 +14,12 @@ 
 
             $limit = 10;
 
-            $vars['start'] = $vars['page'] > ($limit / 2) ?
-                ($vars['page'] - $limit / 2) :
-                1;
+            $vars['start'] = $vars['page'] > ($limit/2) ?
+                ($vars['page'] - $limit/2) : 1;
 
-            if ($vars['page'] > ($vars['pages'] - ($limit / 2))) {
+            if ($vars['page'] > ($vars['pages'] - ($limit/2))) {
                 $vars['final'] = $vars['pages'];
-            } elseif ($vars['page'] > ($limit / 2)) {
+            } elseif ($vars['page'] > ($limit/2)) {
                 $vars['final'] = $vars['start'] + $limit;
             } else {
                 $vars['final'] = $limit;
@@ -43,16 +42,15 @@ 
         }
 
         $jump = self::jump($multiplier, $direction);
-        $add = '<li class="jump"><a>'.$jump.'</a></li>';
+        $add = '<li class="jump"><a>' . $jump . '</a></li>';
 
         $jumpExists = $direction === '-' ?
-            (self::$t['page'] - $multiplier) > 0 :
-            (self::$t['page'] + $multiplier) <= self::$t['pages'];
+            (self::$t['page'] - $multiplier) > 0 : (self::$t['page'] + $multiplier) <= self::$t['pages'];
 
         if ($jumpExists) {
-            $html = $direction === '-' ? $add.$html : $html.$add;
+            $html = $direction === '-' ? $add . $html : $html . $add;
 
-            return self::jumps($html, ($multiplier * 10));
+            return self::jumps($html, ($multiplier*10));
         }
 
         return $html;
@@ -61,11 +59,11 @@ 
     private static function jump($multiplier, $direction)
     {
         if ($multiplier >= 1000000) {
-            return $direction.($multiplier / 1000000).'M';
+            return $direction . ($multiplier/1000000) . 'M';
         } elseif ($multiplier >= 1000) {
-            return $direction.($multiplier / 1000).'K';
+            return $direction . ($multiplier/1000) . 'K';
         } else {
-            return $direction.$multiplier;
+            return $direction . $multiplier;
         }
     }
 }

TraitHelper.php

Spacing +8 added lines, -8 removed lines

@@ -17,8 +17,8 @@ 
 
     public static function assets($path = '/public/table')
     {
-        return "<script src=\"{$path}/table_helper.js\" defer></script>\n\t".
-            "<script src=\"{$path}/table.js\" defer></script>\n\t".
+        return "<script src=\"{$path}/table_helper.js\" defer></script>\n\t" .
+            "<script src=\"{$path}/table.js\" defer></script>\n\t" .
             "<link href=\"{$path}/table.css\" rel=\"stylesheet\">\n";
     }
 
@@ -35,7 +35,7 @@ 
             if ($value === true || (empty($value) && $value != 0)) {
                 $list[] = $key;
             } else {
-                $list[] = $key.'="'.$value.'"';
+                $list[] = $key . '="' . $value . '"';
             }
         }
 
@@ -71,7 +71,7 @@ 
             self::$cols = [];
             self::$t['rows'] = null;
         } else {
-            echo 'Existing table-id used in table::create(): '.$items;
+            echo 'Existing table-id used in table::create(): ' . $items;
         }
     }
 
@@ -84,7 +84,7 @@ 
             $nodes = explode('.', $property);
             $name = array_shift($nodes);
             if (property_exists(__CLASS__, $name)) {
-                $val = function (&$val) use ($nodes) {
+                $val = function(&$val) use ($nodes) {
                     $temp = &$val;
                     foreach ($nodes as $key) {
                         if ($key === 'last') {
@@ -100,12 +100,12 @@ 
                     return $v === $value;
                 }
 
-                throw new Exception('Missing value ('.implode($nodes).').');
+                throw new Exception('Missing value (' . implode($nodes) . ').');
             }
 
-            throw new Exception('Undefined property ('.$name.').');
+            throw new Exception('Undefined property (' . $name . ').');
         } catch (Exception $e) {
-            echo 'Caught exception: ',  $e->getMessage(), "\n";
+            echo 'Caught exception: ', $e->getMessage(), "\n";
         }
 
         return false;

Table.php

Spacing +6 added lines, -7 removed lines

@@ -38,8 +38,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);
 
@@ -73,9 +72,9 @@ 
         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);
+            $dir : self::error('Invalid orderDir (Asc/Desc): ' . $orderDir);
         self::$t['paging'] = ($num = abs($paging)) >= 10 ?
-            $num : self::error('Invalid paging (<10): '.$paging);
+            $num : self::error('Invalid paging (<10): ' . $paging);
     }
 
     /**
@@ -94,7 +93,7 @@ 
         self::$t = self::request(self::$export);
 
         $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::query($query, self::$t['filter'], $order, $limit, true);
 
@@ -107,7 +106,7 @@ 
         try {
             self::$data = self::select($q);
         } catch (Exception $e) {
-            self::error('ERROR: '.$q.'<br />'.$e->getMessage());
+            self::error('ERROR: ' . $q . '<br />' . $e->getMessage());
         }
     }
 
@@ -121,7 +120,7 @@ 
         } else {
             $tableId = filter_input(INPUT_GET, 'table-id') ?: //4 testing
                        filter_var($_GET['table-id'], FILTER_SANITIZE_STRING);
-            if ($tableId === self::$t['items'].'-table') {
+            if ($tableId === self::$t['items'] . '-table') {
                 //ob_get_clean();
                 //ob_start('ob_gzhandler');
                 if (!self::$export) {

TraitRequest.php

Spacing +9 added lines, -13 removed lines

@@ -28,11 +28,11 @@ 
             } else {
                 $filterBy = self::$cols[$filterBy][1];
             }
-            $filterBy = 'CONCAT(" ",'.$filterBy.', " ")';
+            $filterBy = 'CONCAT(" ",' . $filterBy . ', " ")';
             if (self::config('FILTER_CASE_SENSITIVE') !== true) {
-                $filterBy .= ' COLLATE '.self::config('DB_COLLATION_CI');
+                $filterBy .= ' COLLATE ' . self::config('DB_COLLATION_CI');
             }
-            $filter = $filterBy.' LIKE '.'"%'.$filter.'%"';
+            $filter = $filterBy . ' LIKE ' . '"%' . $filter . '%"';
         }
 
         return $filter;
@@ -45,18 +45,17 @@ 
             if (isset($v[2]['sort']) && $v[2]['sort'] === false) {
                 continue;
             }
-            $all[] = 'IFNULL('.$v[1].', "")';
+            $all[] = 'IFNULL(' . $v[1] . ', "")';
         }
 
-        return 'CONCAT('.implode(',', $all).')';
+        return 'CONCAT(' . implode(',', $all) . ')';
     }
 
     private static function orderCol()
     {
         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'];
@@ -67,14 +66,12 @@ 
         $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']);
     }
 
     private static function setExport()
     {
-        $exp = filter_input(INPUT_GET, 'export', FILTER_SANITIZE_STRING) ?:
-               filter_var(@$_GET['export'], FILTER_SANITIZE_STRING); //4 testing
+        $exp = filter_input(INPUT_GET, 'export', FILTER_SANITIZE_STRING) ?: filter_var(@$_GET['export'], FILTER_SANITIZE_STRING); //4 testing
 
         return in_array($exp, self::config('SAVES')) ? $exp : false;
     }
@@ -82,7 +79,6 @@ 
     private static function page()
     {
         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'];
     }
 }

Tbody.php

Spacing +11 added lines, -14 removed lines

@@ -31,10 +31,10 @@ 
             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>';
+                $trs .= '<tr><td' . self::attributes($r[0][1]) . '>'
+                    .$r[0][0] . '</td></tr>';
             } else {
-                $trs .= '<tr><td>'.implode('</td><td>', $r)
+                $trs .= '<tr><td>' . implode('</td><td>', $r)
                     .'</td></tr>';
             }
         }
@@ -49,16 +49,14 @@ 
         $rows = [$header];
 
         $data = self::$exportDataAsDisplayed ?
-            self::$data :
-            self::select(self::$t['q']);
+            self::$data : self::select(self::$t['q']);
 
         if (count($data) > 0) {
             foreach ($data as $row) {
                 $cells = [];
                 foreach ($columns as $column) {
                     $cells[] = is_array($row[$column]) ?
-                        $row[$column][0] :
-                        $row[$column];
+                        $row[$column][0] : $row[$column];
                 }
                 $rows[] = $cells;
             }
@@ -87,21 +85,20 @@ 
         switch (self::$export) {
             case 'Excel':
             case 'CSV':
-                $escape = function ($value) {
+                $escape = function($value) {
                     return str_replace("\t", '&#9;', $value);
                 };
 
                 $output = fopen('php://output', 'w');
                 if (substr($filename, -2) !== '()') { //4 testing
                     header('Content-Type:application/csv');
-                    header('Content-Disposition:attachment; filename='.
-                            $filename.'.csv');
+                    header('Content-Disposition:attachment; filename=' .
+                            $filename . '.csv');
                 }
                 foreach ($eData as $v) {
                     self::$export === 'CSV' ?
-                            fputcsv($output, $v) :
-                            fwrite($output,
-                                implode("\t", array_map($escape, $v))."\r\n");
+                            fputcsv($output, $v) : fwrite($output,
+                                implode("\t", array_map($escape, $v)) . "\r\n");
                 }
 
                 return fclose($output);
@@ -114,7 +111,7 @@ 
         $fnReplace[':app'] = self::config('APP');
         $fnReplace[':items'] = self::$t['items'];
         $format = str_replace(':', '.', '%d.%m.%Y  %H:%i:%s');
-        $timeQuery = 'SELECT DATE_FORMAT(Now(), "'.$format.'") AS `now`;';
+        $timeQuery = 'SELECT DATE_FORMAT(Now(), "' . $format . '") AS `now`;';
         $fnReplace[':datetime'] = self::select($timeQuery);
 
         return strtr((string) self::config('EXPORT_FILE_NAME'), $fnReplace);