lagdo / jaxon-dbadmin

src/DbAdmin/Traits/TableSelectTrait.php

Indentation +1 added lines, -1 removed lines

@@ -261,7 +261,7 @@
      * @return TableSelectEntity
      */
     private function getSelectEntity(string $table, array $columns, array $fields, array $select,
-                                     array $group, array $where, array $order, array $unselected, int $limit, int $page): TableSelectEntity
+                                        array $group, array $where, array $order, array $unselected, int $limit, int $page): TableSelectEntity
     {
         $select2 = $select;
         $group2 = $group;

Spacing +4 added lines, -4 removed lines

@@ -25,7 +25,7 @@ 
     {
         return [
             'select' => $select,
-            'values' => (array)$options["columns"],
+            'values' => (array) $options["columns"],
             'columns' => $columns,
             'functions' => $this->driver->functions(),
             'grouping' => $this->driver->grouping(),
@@ -49,7 +49,7 @@ 
         }
         return [
             // 'where' => $where,
-            'values' => (array)$options["where"],
+            'values' => (array) $options["where"],
             'columns' => $columns,
             'indexes' => $indexes,
             'operators' => $this->driver->operators(),
@@ -68,8 +68,8 @@ 
     private function getSortingOptions(array $columns, array $options): array
     {
         $values = [];
-        $descs = (array)$options["desc"];
-        foreach ((array)$options["order"] as $key => $value) {
+        $descs = (array) $options["desc"];
+        foreach ((array) $options["order"] as $key => $value) {
             $values[] = [
                 'col' => $value,
                 'desc' => $descs[$key] ?? 0,

src/DbAdmin/TableSelectAdmin.php

Spacing +2 added lines, -2 removed lines

@@ -329,8 +329,8 @@
      */
     public function execSelect(string $table, array $queryOptions): array
     {
-        list(, $query, $select, $fields, , , $indexes, $where, $group, , $limit, $page,
-            $textLength, , $unselected) = $this->prepareSelect($table, $queryOptions);
+        list(, $query, $select, $fields,,, $indexes, $where, $group,, $limit, $page,
+            $textLength,, $unselected) = $this->prepareSelect($table, $queryOptions);
 
         list($rows, $duration) = $this->executeQuery($query, $page);
         if (!$rows) {

src/DbAdmin/TableAdmin.php

Spacing +3 added lines, -3 removed lines

@@ -218,14 +218,14 @@ 
                 $target .= '<b>' . $this->util->html($foreignKey->schema) . '</b>.';
             }
             $target = $this->util->html($foreignKey->table) .
-                '(' . implode(', ', array_map(function ($key) {
+                '(' . implode(', ', array_map(function($key) {
                     return $this->util->html($key);
                 }, $foreignKey->target)) . ')';
             $details[] = [
                 'name' => $this->util->html($name),
                 'source' => '<i>' . implode(
                     '</i>, <i>',
-                    array_map(function ($key) {
+                    array_map(function($key) {
                         return $this->util->html($key);
                     }, $foreignKey->source)
                 ) . '</i>',
@@ -369,7 +369,7 @@ 
     private function makeTableAttrs(array $values, string $table = '')
     {
         // From create.inc.php
-        $values['fields'] = (array)$values['fields'];
+        $values['fields'] = (array) $values['fields'];
         if ($values['autoIncrementCol']) {
             $values['fields'][$values['autoIncrementCol']]['autoIncrement'] = true;
         }

src/DbAdmin/Traits/TableTrait.php

Spacing +1 added lines, -2 removed lines

@@ -141,8 +141,7 @@
     {
         $foreignKey = $this->foreignKeys[$field->type] ?? null;
         //! Can collide with user defined type
-        $typeField = ($foreignKey === null ? $field :
-            TableFieldEntity::make($this->referencableTables[$foreignKey]));
+        $typeField = ($foreignKey === null ? $field : TableFieldEntity::make($this->referencableTables[$foreignKey]));
         $processedField = $this->util->processField($field, $typeField);
         $origField = $this->fields[$this->fieldName] ?? null;
         if ($this->fieldName === '') {

src/DbAdmin/TableQueryAdmin.php

Spacing +3 added lines, -7 removed lines

@@ -128,12 +128,8 @@ 
             // }
             $value = ($row !== null ?
                 ($row[$name] != "" && $this->driver->jush() == "sql" && preg_match("~enum|set~", $field->type) ?
-                    (is_array($row[$name]) ? array_sum($row[$name]) : +$row[$name]) :
-                    (is_bool($row[$name]) ? +$row[$name] : $row[$name])) :
-                (!$update && $field->autoIncrement ? "" : (isset($queryOptions["select"]) ? false : $default)));
-            $function = ($queryOptions["save"] ? (string)$queryOptions["function"][$name] :
-                ($update && preg_match('~^CURRENT_TIMESTAMP~i', $field->onUpdate) ? "now" :
-                    ($value === false ? null : ($value !== null ? '' : 'NULL'))));
+                    (is_array($row[$name]) ? array_sum($row[$name]) : +$row[$name]) : (is_bool($row[$name]) ? +$row[$name] : $row[$name])) : (!$update && $field->autoIncrement ? "" : (isset($queryOptions["select"]) ? false : $default)));
+            $function = ($queryOptions["save"] ? (string) $queryOptions["function"][$name] : ($update && preg_match('~^CURRENT_TIMESTAMP~i', $field->onUpdate) ? "now" : ($value === false ? null : ($value !== null ? '' : 'NULL'))));
             if (!$update && $value == $field->default && preg_match('~^[\w.]+\(~', $value)) {
                 $function = "SQL";
             }
@@ -224,7 +220,7 @@ 
      */
     public function insertItem(string $table, array $queryOptions): array
     {
-        list($fields, ,) = $this->getFields($table, $queryOptions);
+        list($fields,,) = $this->getFields($table, $queryOptions);
 
         // From edit.inc.php
         $values = [];

templates/views/bootstrap4/table/query.php

Spacing +5 added lines, -5 removed lines

@@ -1,16 +1,16 @@
 <form id="<?php echo $this->formId ?>">
-<?php foreach($this->fields as $name => $field): ?>
+<?php foreach ($this->fields as $name => $field): ?>
         <div class="form-group row">
             <div class="col-md-3">
                 <label title="<?php echo $field['type'] ?>"><?php echo $field['name'] ?></label>
             </div>
             <div class="col-md-2">
-<?php if($field['functions']['type'] === 'name'): ?>
+<?php if ($field['functions']['type'] === 'name'): ?>
                 <label class=""><?php echo $field['functions']['name'] ?></label>
-<?php elseif($field['functions']['type'] === 'select'): ?>
+<?php elseif ($field['functions']['type'] === 'select'): ?>
                 <select name="<?php echo $field['functions']['name'] ?>" class="form-control">
-<?php foreach($field['functions']['options'] as $function): ?>
-                    <option <?php if($function === $field['functions']['selected']): ?>selected<?php
+<?php foreach ($field['functions']['options'] as $function): ?>
+                    <option <?php if ($function === $field['functions']['selected']): ?>selected<?php
                         endif ?>><?php echo $function ?></option>
 <?php endforeach ?>
                 </select>

templates/views/bootstrap3/table/query.php

Spacing +5 added lines, -5 removed lines

@@ -1,16 +1,16 @@
 <form class="form-horizontal" role="form" id="<?php echo $this->formId ?>">
-<?php foreach($this->fields as $name => $field): ?>
+<?php foreach ($this->fields as $name => $field): ?>
         <div class="form-group">
             <div class="col-md-3">
                 <label title="<?php echo $field['type'] ?>"><?php echo $field['name'] ?></label>
             </div>
             <div class="col-md-2">
-<?php if($field['functions']['type'] === 'name'): ?>
+<?php if ($field['functions']['type'] === 'name'): ?>
                 <label class=""><?php echo $field['functions']['name'] ?></label>
-<?php elseif($field['functions']['type'] === 'select'): ?>
+<?php elseif ($field['functions']['type'] === 'select'): ?>
                 <select name="<?php echo $field['functions']['name'] ?>" class="form-control">
-<?php foreach($field['functions']['options'] as $function): ?>
-                    <option <?php if($function === $field['functions']['selected']): ?>selected<?php
+<?php foreach ($field['functions']['options'] as $function): ?>
+                    <option <?php if ($function === $field['functions']['selected']): ?>selected<?php
                         endif ?>><?php echo $function ?></option>
 <?php endforeach ?>
                 </select>

src/DbAdmin/Traits/QueryInputTrait.php

Spacing +2 added lines, -3 removed lines

@@ -69,7 +69,7 @@ 
                 'text' => '<i>' . $this->trans->lang('original') . '</i>'];
         }
         if ($field->null) {
-            $values[] =  ['value' => '', 'checked' => $value === null && !$select, 'text' => '<i>NULL</i>'];
+            $values[] = ['value' => '', 'checked' => $value === null && !$select, 'text' => '<i>NULL</i>'];
         }
 
         // From functions.inc.php (function enum_input())
@@ -80,8 +80,7 @@ 
         preg_match_all("~'((?:[^']|'')*)'~", $field->fullType, $matches);
         foreach ($matches[1] as $i => $val) {
             $val = stripcslashes(str_replace("''", "'", $val));
-            $checked = (is_int($value) ? $value == $i + 1 :
-                (is_array($value) ? in_array($i+1, $value) : $value === $val));
+            $checked = (is_int($value) ? $value == $i + 1 : (is_array($value) ? in_array($i + 1, $value) : $value === $val));
             $values[] = ['value' => $i + 1, 'checked' => $checked, 'text' => $this->util->html($val)];
         }