webdivane / table

table_getter.php

Spacing +35 added lines, -44 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) {
@@ -157,11 +151,10 @@ 
                 header('Content-Disposition:attachment; filename=' .
                         $outFilename . '.csv');
                 
-                if(($output = fopen('php://output', 'w'))){
+                if (($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);
                 }
@@ -175,7 +168,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) {
@@ -194,9 +187,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 {
@@ -207,15 +200,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')];
@@ -265,10 +257,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>';
@@ -277,8 +269,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>';
@@ -300,13 +292,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__);