lagdo / jaxon-dbadmin

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)];
         }
 

src/DbAdmin/ExportAdmin.php

Spacing +2 added lines, -3 removed lines

@@ -285,8 +285,7 @@ 
                 $row[$key] = '"' . str_replace('"', '""', $val) . '"';
             }
         }
-        $separator = $this->options['format'] == 'csv' ? ',' :
-            ($this->options['format'] == 'tsv' ? "\t" : ';');
+        $separator = $this->options['format'] == 'csv' ? ',' : ($this->options['format'] == 'tsv' ? "\t" : ';');
         $this->queries[] = implode($separator, $row);
     }
 
@@ -395,7 +394,7 @@ 
         } else {
             if (!$this->insert) {
                 $this->insert = 'INSERT INTO ' . $this->driver->table($table) . ' (' .
-                    implode(', ', array_map(function ($key) {
+                    implode(', ', array_map(function($key) {
                         return $this->driver->escapeId($key);
                     }, $keys)) . ') VALUES';
             }

Braces +1 added lines, -2 removed lines

@@ -619,8 +619,7 @@
         foreach (array_unique(array_merge($databases['list'], $databases['data'])) as $database) {
             try {
                 $this->dumpDatabase($database);
-            }
-            catch (Exception $e) {
+            } catch (Exception $e) {
                 return $e->getMessage();
             }
         }