@@ -37,8 +37,7 @@ discard block |
||
| 37 | 37 | { |
| 38 | 38 | if (($col = filter_input(INPUT_GET, 'col', FILTER_VALIDATE_INT))) { |
| 39 | 39 | return isset(self::$cols[$col][2]['sort']) ? |
| 40 | - self::$cols[$col][2]['sort'] : |
|
| 41 | - self::$cols[$col][1]; |
|
| 40 | + self::$cols[$col][2]['sort'] : self::$cols[$col][1]; |
|
| 42 | 41 | } |
| 43 | 42 | return self::$t['order']['col']; |
| 44 | 43 | } |
@@ -47,8 +46,7 @@ discard block |
||
| 47 | 46 | { |
| 48 | 47 | $reset = filter_has_var(INPUT_GET, 'col') ? 'asc' : null; |
| 49 | 48 | return in_array(filter_input(INPUT_GET, 'ord'), ['asc', 'desc']) ? |
| 50 | - filter_input(INPUT_GET, 'ord') : |
|
| 51 | - ($reset ?: self::$t['order']['dir']); |
|
| 49 | + filter_input(INPUT_GET, 'ord') : ($reset ?: self::$t['order']['dir']); |
|
| 52 | 50 | } |
| 53 | 51 | |
| 54 | 52 | private static function requestExport() |
@@ -60,7 +58,6 @@ discard block |
||
| 60 | 58 | private static function requestPage() |
| 61 | 59 | { |
| 62 | 60 | return filter_has_var(INPUT_GET, 'pg') && self::$export == false ? |
| 63 | - (int) filter_input(INPUT_GET, 'pg', FILTER_SANITIZE_NUMBER_INT) : |
|
| 64 | - self::$t['page']; |
|
| 61 | + (int)filter_input(INPUT_GET, 'pg', FILTER_SANITIZE_NUMBER_INT) : self::$t['page']; |
|
| 65 | 62 | } |
| 66 | 63 | } |
@@ -25,8 +25,7 @@ discard block |
||
| 25 | 25 | public static function prepare($setOrCheck = false) |
| 26 | 26 | { |
| 27 | 27 | //@see http://php.net/manual/es/function.filter-input.php#77307 |
| 28 | - $uri = filter_input(INPUT_SERVER, 'REQUEST_URI', FILTER_SANITIZE_URL) ?: |
|
| 29 | - filter_var($_SERVER['REQUEST_URI'], FILTER_SANITIZE_URL); |
|
| 28 | + $uri = filter_input(INPUT_SERVER, 'REQUEST_URI', FILTER_SANITIZE_URL) ?: filter_var($_SERVER['REQUEST_URI'], FILTER_SANITIZE_URL); |
|
| 30 | 29 | |
| 31 | 30 | $extension = pathinfo(strtok($uri, '?'), PATHINFO_EXTENSION); |
| 32 | 31 | |
@@ -79,7 +78,7 @@ discard block |
||
| 79 | 78 | |
| 80 | 79 | $filter = self::requestFilter(); |
| 81 | 80 | $order = [self::$t['order']['col'] => self::$t['order']['dir']]; |
| 82 | - $offset = (self::$t['page'] - 1) * self::$t['paging']; |
|
| 81 | + $offset = (self::$t['page'] - 1)*self::$t['paging']; |
|
| 83 | 82 | $limit = [$offset, self::$t['paging']]; |
| 84 | 83 | self::$t['q'] = self::q($q, $filter, $order, $limit, true); |
| 85 | 84 | |
@@ -14,13 +14,12 @@ discard block |
||
| 14 | 14 | |
| 15 | 15 | $limit = 10; |
| 16 | 16 | |
| 17 | - $v['start'] = $v['page'] > ($limit / 2) ? |
|
| 18 | - ($v['page'] - $limit / 2) : |
|
| 19 | - 1; |
|
| 17 | + $v['start'] = $v['page'] > ($limit/2) ? |
|
| 18 | + ($v['page'] - $limit/2) : 1; |
|
| 20 | 19 | |
| 21 | - if ($v['page'] > ($v['pages'] - ($limit / 2))) { |
|
| 20 | + if ($v['page'] > ($v['pages'] - ($limit/2))) { |
|
| 22 | 21 | $v['final'] = $v['pages']; |
| 23 | - } else if ($v['page'] > ($limit / 2)) { |
|
| 22 | + } else if ($v['page'] > ($limit/2)) { |
|
| 24 | 23 | $v['final'] = $v['start'] + $limit; |
| 25 | 24 | } else { |
| 26 | 25 | $v['final'] = $limit; |
@@ -44,12 +43,11 @@ discard block |
||
| 44 | 43 | $add = '<li class="jump"><a>' . self::jumps($m, $direction) . '</a></li>'; |
| 45 | 44 | |
| 46 | 45 | $jump_exists = $direction === '-' ? |
| 47 | - (self::$t['page'] - $m) > 0 : |
|
| 48 | - (self::$t['page'] + $m) <= self::$t['pages']; |
|
| 46 | + (self::$t['page'] - $m) > 0 : (self::$t['page'] + $m) <= self::$t['pages']; |
|
| 49 | 47 | |
| 50 | 48 | if ($jump_exists) { |
| 51 | 49 | $html = $direction === '-' ? $add . $html : $html . $add; |
| 52 | - return self::pagingJumps($html, ($m * 10)); |
|
| 50 | + return self::pagingJumps($html, ($m*10)); |
|
| 53 | 51 | } |
| 54 | 52 | |
| 55 | 53 | return $html; |
@@ -58,9 +56,9 @@ discard block |
||
| 58 | 56 | private static function jumps($m, $direction) |
| 59 | 57 | { |
| 60 | 58 | if ($m >= 1000000) { |
| 61 | - return ($direction . ($m / 1000000) . "M"); |
|
| 59 | + return ($direction . ($m/1000000) . "M"); |
|
| 62 | 60 | } else if ($m >= 1000) { |
| 63 | - return ($direction . ($m / 1000) . "K"); |
|
| 61 | + return ($direction . ($m/1000) . "K"); |
|
| 64 | 62 | } else { |
| 65 | 63 | return ($direction . $m); |
| 66 | 64 | } |
@@ -62,7 +62,7 @@ discard block |
||
| 62 | 62 | switch (gettype($c)) { |
| 63 | 63 | case 'array'; |
| 64 | 64 | foreach ($c as $k => $v) { |
| 65 | - self::$config[$k] = $getValid((string) $k, $v); |
|
| 65 | + self::$config[$k] = $getValid((string)$k, $v); |
|
| 66 | 66 | } |
| 67 | 67 | break; |
| 68 | 68 | case 'string': |
@@ -86,8 +86,7 @@ discard block |
||
| 86 | 86 | { |
| 87 | 87 | //Condition: '' | '(HAVING|WHERE|AND) ' . $cond |
| 88 | 88 | $c = !empty($cond) && !strpos($q, ($cl = !$h ? 'WHERE' : 'HAVING')) ? |
| 89 | - (' ' . (!strpos($q, $cl) ? $cl : ' AND ') . ' ' . $cond ) : |
|
| 90 | - ''; |
|
| 89 | + (' ' . (!strpos($q, $cl) ? $cl : ' AND ') . ' ' . $cond) : ''; |
|
| 91 | 90 | //Order: '' | 'ORDER BY ' . array_keys($order)[0] . ' ' . $order[0] |
| 92 | 91 | $o = !empty($order) ? |
| 93 | 92 | ' ORDER BY ' . implode(', ', |
@@ -98,8 +97,7 @@ discard block |
||
| 98 | 97 | ''; |
| 99 | 98 | //Limit: '' | ' LIMIT ' . '(20, 40|20)' |
| 100 | 99 | $l = !empty($limit) ? |
| 101 | - (' LIMIT ' . (is_array($limit) ? implode(', ', $limit) : $limit)) : |
|
| 102 | - ''; |
|
| 100 | + (' LIMIT ' . (is_array($limit) ? implode(', ', $limit) : $limit)) : ''; |
|
| 103 | 101 | |
| 104 | 102 | return $q . $c . $o . $l; |
| 105 | 103 | } |
@@ -122,7 +120,7 @@ discard block |
||
| 122 | 120 | $list = []; |
| 123 | 121 | foreach ($attributes as $key => $value) { |
| 124 | 122 | if (is_bool($value)) { |
| 125 | - if ((bool) $value) { |
|
| 123 | + if ((bool)$value) { |
|
| 126 | 124 | $list[] = $key; |
| 127 | 125 | } |
| 128 | 126 | } else if (empty($value) && !is_int($value)) { |
@@ -143,6 +141,6 @@ discard block |
||
| 143 | 141 | extract($vars); |
| 144 | 142 | ob_start(); |
| 145 | 143 | require $template; |
| 146 | - return (string) ob_get_clean(); |
|
| 144 | + return (string)ob_get_clean(); |
|
| 147 | 145 | } |
| 148 | 146 | } |
@@ -21,14 +21,13 @@ discard block |
||
| 21 | 21 | $q = 'SELECT COUNT(*) FROM (' . self::$t['qAll'] . ') AS dt'; |
| 22 | 22 | self::$t['rows'] = self::select($q); |
| 23 | 23 | } |
| 24 | - self::$t['pages'] = ceil(self::$t['rows'] / self::$t['paging']); |
|
| 24 | + self::$t['pages'] = ceil(self::$t['rows']/self::$t['paging']); |
|
| 25 | 25 | |
| 26 | 26 | $v = []; |
| 27 | 27 | |
| 28 | - $v['from'] = ($pageNo - 1) * self::$t['paging'] + 1; |
|
| 29 | - $v['upto'] = ($pageNo * self::$t['paging'] < self::$t['rows']) ? |
|
| 30 | - $pageNo * self::$t['paging'] : |
|
| 31 | - self::$t['rows']; |
|
| 28 | + $v['from'] = ($pageNo - 1)*self::$t['paging'] + 1; |
|
| 29 | + $v['upto'] = ($pageNo*self::$t['paging'] < self::$t['rows']) ? |
|
| 30 | + $pageNo*self::$t['paging'] : self::$t['rows']; |
|
| 32 | 31 | |
| 33 | 32 | $v["total"] = self::$t['rows']; |
| 34 | 33 | $v["items"] = self::$t['items']; |
@@ -57,8 +56,8 @@ discard block |
||
| 57 | 56 | $ftr = self::jsonTfoot()[0][0]; |
| 58 | 57 | $trs .= '<tr><td' . self::attributes($ftr[1]) . '>' |
| 59 | 58 | . $ftr[0] . '</td></tr>'; |
| 60 | - } else if(count(self::$errors)>0) { |
|
| 61 | - $trs .= '<tr><td colspan="'.count(self::$cols).'">' . |
|
| 59 | + } else if (count(self::$errors) > 0) { |
|
| 60 | + $trs .= '<tr><td colspan="' . count(self::$cols) . '">' . |
|
| 62 | 61 | self::err() . '</td></tr>'; |
| 63 | 62 | } |
| 64 | 63 | return $trs; |
@@ -70,9 +69,8 @@ discard block |
||
| 70 | 69 | $select = static::$select; |
| 71 | 70 | $res = $select($expression, $bindings); |
| 72 | 71 | //if result is single cell value ($res[0]->value), return the value |
| 73 | - return (count($res) === 1 && count((array) $res[0]) === 1) ? |
|
| 74 | - reset($res[0]) : |
|
| 75 | - $res; |
|
| 72 | + return (count($res) === 1 && count((array)$res[0]) === 1) ? |
|
| 73 | + reset($res[0]) : $res; |
|
| 76 | 74 | } else { |
| 77 | 75 | throw new Exception('ERROR: table::$select is not a closure. '); |
| 78 | 76 | } |
@@ -43,8 +43,7 @@ discard block |
||
| 43 | 43 | protected static function export() |
| 44 | 44 | { |
| 45 | 45 | $data = self::$exportDataAsDisplayed ? |
| 46 | - self::$data : |
|
| 47 | - self::select(self::$t['q']); |
|
| 46 | + self::$data : self::select(self::$t['q']); |
|
| 48 | 47 | $outColumns = $outHeader = []; |
| 49 | 48 | foreach (self::$cols as $c) { |
| 50 | 49 | if (isset($c[2]['sort']) && $c[2]['sort'] === false) { |
@@ -84,8 +83,7 @@ discard block |
||
| 84 | 83 | if (($output = fopen('php://output', 'w'))) { |
| 85 | 84 | foreach ($eData as $v) { |
| 86 | 85 | self::$export === 'CSV' ? |
| 87 | - fputcsv($output, $v) : |
|
| 88 | - fputs($output, implode("\t", array_map($escape, $v)) . "\r\n"); |
|
| 86 | + fputcsv($output, $v) : fputs($output, implode("\t", array_map($escape, $v)) . "\r\n"); |
|
| 89 | 87 | } |
| 90 | 88 | fclose($output); |
| 91 | 89 | } |
@@ -45,9 +45,8 @@ discard block |
||
| 45 | 45 | |
| 46 | 46 | private static function tagAttributes($tag, $items) |
| 47 | 47 | { |
| 48 | - $attr = $tag==='div' ? |
|
| 49 | - ['id' => $items . '-list', 'class' => 'table'] : |
|
| 50 | - ['id' => $items . '-table', 'data-table' => 'js']; |
|
| 48 | + $attr = $tag === 'div' ? |
|
| 49 | + ['id' => $items . '-list', 'class' => 'table'] : ['id' => $items . '-table', 'data-table' => 'js']; |
|
| 51 | 50 | if (array_key_exists($tag, self::$attributes)) { |
| 52 | 51 | $attr += self::$attributes[$tag]; |
| 53 | 52 | } |
@@ -82,21 +81,19 @@ discard block |
||
| 82 | 81 | if (isset($arg['width'])) { // Width attribute -> style |
| 83 | 82 | $width = 'width:' . $arg['width'] . ';'; |
| 84 | 83 | $arg['style'] = isset($arg['style']) ? |
| 85 | - $width . $arg['style'] : |
|
| 86 | - $width; |
|
| 84 | + $width . $arg['style'] : $width; |
|
| 87 | 85 | } |
| 88 | 86 | |
| 89 | 87 | $sortable = !isset($arg['sort']) || $arg['sort'] !== false; |
| 90 | 88 | |
| 91 | 89 | $sort = $sortable ? |
| 92 | - (isset($arg['sort']) ? $arg['sort'] : $col) : |
|
| 93 | - null; |
|
| 90 | + (isset($arg['sort']) ? $arg['sort'] : $col) : null; |
|
| 94 | 91 | |
| 95 | 92 | if (($del = isset($arg['type']) && $arg['type'] == 'delete')) { |
| 96 | 93 | $sort = null; |
| 97 | 94 | } |
| 98 | 95 | |
| 99 | - return array_diff_key((array) $arg, ['sort', 'type', 'width']); |
|
| 96 | + return array_diff_key((array)$arg, ['sort', 'type', 'width']); |
|
| 100 | 97 | } |
| 101 | 98 | |
| 102 | 99 | private static function th($i, $attr, $sort, $del, $lbl) |
@@ -108,8 +105,7 @@ discard block |
||
| 108 | 105 | if (!$del) { |
| 109 | 106 | if ($sort == self::$t['order']['col']) { |
| 110 | 107 | $span = self::$t['order']['dir'] === 'desc' ? |
| 111 | - self::config('UTF8_DESC_SYMBOL') : |
|
| 112 | - self::config('UTF8_ASC_SYMBOL'); |
|
| 108 | + self::config('UTF8_DESC_SYMBOL') : self::config('UTF8_ASC_SYMBOL'); |
|
| 113 | 109 | } else { |
| 114 | 110 | $span = ""; |
| 115 | 111 | } |