webdivane / table

table_getter.php

Spacing +34 added lines, -43 removed lines

@@ -22,23 +22,22 @@ 
         if (self::$cols) {
             $ths = [];
             $length = sizeof(self::$cols);
-            for ($i = 0; $i<$length; $i++) {
+            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;
+                $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'])&&
-                            false ===strpos($arg['width'], 'width:')
+                    if (!isset($arg['width']) &&
+                            false === strpos($arg['width'], 'width:')
                     ) {
                         $arg['width'] = '1%';
                     }
@@ -47,21 +46,19 @@ 
                 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']);
+                $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');
+                    if ($sort == self::$t['order']['col']) {
+                        $span = self::$t['order']['dir'] === 'desc' ?
+                                self::config('UTF8_DESC_SYMBOL') : self::config('UTF8_ASC_SYMBOL');
                     } else {
                         $span = "";
                     }
@@ -91,9 +88,8 @@ 
     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 ) :
-                '';
+        $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(', ',
@@ -104,8 +100,7 @@ 
                 '';
         //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;
     }
@@ -113,8 +108,7 @@ 
     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'];
@@ -124,14 +118,14 @@ 
         $outFilename = strtr(self::config('EXPORT_FILE_NAME'), $fnReplace);
         $outColumns = $outHeader = [];
         foreach (self::$cols as $c) {
-            if (isset($c[2]['sort'])&&$c[2]['sort'] ===false) {
+            if (isset($c[2]['sort']) && $c[2]['sort'] === false) {
                 continue;
             }
             $outColumns[] = $c[1];
             $outHeader[] = $c[0];
         }
         $eData = [$outHeader];
-        if (count($data)>0) {
+        if (count($data) > 0) {
             foreach ($data as $row) {
                 $rowData = [];
                 foreach ($row as $dbName => $value) {
@@ -159,9 +153,8 @@ 
                 
                 $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");
+                    self::$export === 'CSV' ?
+                    fputcsv($output, $v) : fputs($output, implode("\t", array_map($escape, $v)) . "\r\n");
                 }
                 fclose($output);
                 break;
@@ -174,7 +167,7 @@ 
         foreach (self::$cols as $c) {
             $outColumns[] = isset($c[1]) ? $c[1] : null;
         }
-        if ((self::$t['rows'] = count(self::$data))>0) {
+        if ((self::$t['rows'] = count(self::$data)) > 0) {
             foreach (self::$data as $row) {
                 $rowData = [];
                 foreach ($outColumns as $dbName) {
@@ -193,9 +186,9 @@ 
     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 {
@@ -206,15 +199,14 @@ 
 
             $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['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) {
+            if (self::$exportActive === true) {
                 $url = strtok(self::$t['slug'], "?&") . ".json?table=" .
                         self::$t['items'] . "&export=";
                 $v["export"] = ["url" => $url, "types" => self::config('SAVES')];
@@ -264,10 +256,10 @@ 
     private static function rows($for)
     {
         $trs = '';
-        if ($for ==='body') {
+        if ($for === 'body') {
             foreach (self::jsonGetBodyData() as $r) {
-                if (isset($r[0][1], $r[0][1]['class'])&&
-                        $r[0][1]['class'] ==='no-results'
+                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>';
@@ -276,8 +268,8 @@ 
                             . '</td></tr>';
                 }
             }
-        } else if ($for ==='footer') {
-            if (self::$t['rows']>0) {
+        } 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>';
@@ -299,13 +291,12 @@ 
 
     static function select(string $expression, array $bindings = [])
     {
-        if (is_object(static::$select)&&(static::$select instanceof Closure)) {
+        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;
+            return (count($res) === 1 && count((array)$res[0]) === 1) ?
+                    reset($res[0]) : $res;
         } else {
             die('ERROR: table::$select is not a valid closure. '
                     . __METHOD__ . '() #' . __LINE__);

table.php

Spacing +9 added lines, -12 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,15 +53,15 @@ 
 
         $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);
 
-        $qAll = isset($qTotal) && ! $filter ? $qTotal : $q;
-        $orderAll = ! self::$export ? [] : $order;
+        $qAll = isset($qTotal) && !$filter ? $qTotal : $q;
+        $orderAll = !self::$export ? [] : $order;
         self::$t['qAll'] = self::q($qAll, $filter, $orderAll, 0, true);
 
-        $query = ! self::$export ? self::$t['q'] : self::$t['qAll'];
+        $query = !self::$export ? self::$t['q'] : self::$t['qAll'];
 
         try {
             self::$data = self::select($query);
@@ -81,7 +79,7 @@ 
             ob_get_clean();
             $tableId = filter_input(INPUT_GET, 'table-id') ?: null;
             if ($tableId === self::$t['items'] . '-table') {
-                if ( ! self::$export) {
+                if (!self::$export) {
                     header('Content-Type: application/json');
                     $jsonArr = ['body' => self::jsonGetBodyData(),
                         'footer' => self::jsonGetFooterData()];
@@ -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);
 
@@ -108,7 +105,7 @@ 
         self::$pageExt = strtolower($extension);
 
         if (self::$helper_class::prepare(__METHOD__, $setOrCheck) !== true) {
-            if (self::$pageExt === 'json' && ! isset(self::$t['prepared'])) {
+            if (self::$pageExt === 'json' && !isset(self::$t['prepared'])) {
                 ob_start();
                 self::$t['prepared'] = true;
             }