danielgp / common-lib

source/MySQLiByDanielGPstructures.php

Spacing +7 added lines, -7 removed lines

@@ -51,7 +51,7 @@ 
     private function correctTableWithQuotesAsFieldPrefix($referenceTable)
     {
         if ($referenceTable != '') {
-            return '`' . str_replace('`', '', $referenceTable) . '`.';
+            return '`'.str_replace('`', '', $referenceTable).'`.';
         }
         return '';
     }
@@ -81,7 +81,7 @@ 
      */
     protected function getFieldNameForDisplay($details)
     {
-        $tableUniqueId = $details['TABLE_SCHEMA'] . '.' . $details['TABLE_NAME'];
+        $tableUniqueId = $details['TABLE_SCHEMA'].'.'.$details['TABLE_NAME'];
         if ($details['COLUMN_COMMENT'] != '') {
             return $details['COLUMN_COMMENT'];
         } elseif (isset($this->advCache['tableStructureLocales'][$tableUniqueId][$details['COLUMN_NAME']])) {
@@ -100,8 +100,8 @@ 
      */
     protected function getFieldOutputTextFK($foreignKeysArray, $value, $iar)
     {
-        $query   = $this->sQueryGenericSelectKeyValue([
-            '`' . $value['COLUMN_NAME'] . '`',
+        $query = $this->sQueryGenericSelectKeyValue([
+            '`'.$value['COLUMN_NAME'].'`',
             $foreignKeysArray[$value['COLUMN_NAME']][2],
             $foreignKeysArray[$value['COLUMN_NAME']][0]
         ]);
@@ -316,8 +316,8 @@ 
     {
         $filters2 = implode(', ', array_diff($value, ['']));
         if ($filters2 != '') {
-            return '(' . $referenceTable . '`' . $key . '` IN ("'
-                . str_replace(',', '","', str_replace(["'", '"'], '', $filters2)) . '"))';
+            return '('.$referenceTable.'`'.$key.'` IN ("'
+                . str_replace(',', '","', str_replace(["'", '"'], '', $filters2)).'"))';
         }
         return '';
     }
@@ -335,7 +335,7 @@ 
         if ((substr($value, 0, 1) == '%') && (substr($value, -1) == '%')) {
             $fTemp = 'LIKE';
         }
-        return '(`' . $key . '` ' . $fTemp . '"' . $value . '")';
+        return '(`'.$key.'` '.$fTemp.'"'.$value.'")';
     }
 
     /**

source/MySQLiAdvancedOutput.php

Spacing +7 added lines, -7 removed lines

@@ -59,7 +59,7 @@ 
         }
         $vlSlct    = explode(',', $this->getFieldValue($val));
         $slctOptns = $this->getSetOrEnum2Array($tblSrc, $val['COLUMN_NAME']);
-        return $this->setArrayToSelect($slctOptns, $vlSlct, $val['COLUMN_NAME'] . $adnlThings['suffix'], $inAdtnl);
+        return $this->setArrayToSelect($slctOptns, $vlSlct, $val['COLUMN_NAME'].$adnlThings['suffix'], $inAdtnl);
     }
 
     /**
@@ -105,7 +105,7 @@ 
         if ($iar !== []) {
             $inAdtnl = array_merge($inAdtnl, $iar);
         }
-        return '<b>' . $this->getFieldValue($value) . '</b>' . $this->setStringIntoShortTag('input', $inAdtnl);
+        return '<b>'.$this->getFieldValue($value).'</b>'.$this->setStringIntoShortTag('input', $inAdtnl);
     }
 
     /**
@@ -118,8 +118,8 @@ 
      */
     private function getFieldOutputNumericNonFK($fkArray, $value, $iar = [])
     {
-        $query         = $this->sQueryGenericSelectKeyValue([
-            '`' . $value['COLUMN_NAME'] . '`',
+        $query = $this->sQueryGenericSelectKeyValue([
+            '`'.$value['COLUMN_NAME'].'`',
             $fkArray[$value['COLUMN_NAME']][2],
             $fkArray[$value['COLUMN_NAME']][0],
         ]);
@@ -260,7 +260,7 @@ 
                 if ($val[$cnm[0]] == $oCol) {
                     $vlQ        = array_merge($val, ['LIMIT' => 2]);
                     $tFd        = $this->setMySQLquery2Server($this->getForeignKeysQuery($vlQ), $cnm[1])['result'];
-                    $tgtFld     = '`' . ($tFd[0][$cnm[0]] == $val[$cnm[0]] ? $tFd[1][$cnm[0]] : $tFd[0][$cnm[0]]) . '`';
+                    $tgtFld     = '`'.($tFd[0][$cnm[0]] == $val[$cnm[0]] ? $tFd[1][$cnm[0]] : $tFd[0][$cnm[0]]).'`';
                     $aRt[$oCol] = [$this->glueDbTb($val[$cnm[2]], $val[$cnm[3]]), $val[$cnm[2]], $tgtFld];
                 }
             }
@@ -311,7 +311,7 @@ 
                 $inM = $this->setStringIntoTag($mCN[$dtl['COLUMN_NAME']], 'span', ['style' => 'font-style:italic;']);
             }
         }
-        $lbl = '<span class="fake_label">' . $this->getFieldNameForDisplay($dtl) . '</span>';
+        $lbl = '<span class="fake_label">'.$this->getFieldNameForDisplay($dtl).'</span>';
         return ['label' => $lbl, 'input' => $inM];
     }
 
@@ -327,7 +327,7 @@ 
         } elseif (in_array($dtls['DATA_TYPE'], ['date', 'datetime', 'time', 'timestamp', 'year'])) {
             $sReturn = $this->setNeededFieldSingleType($tblName, $dtls, $iar);
         }
-        return $this->getFieldCompletionType($dtls) . $sReturn;
+        return $this->getFieldCompletionType($dtls).$sReturn;
     }
 
     private function setNeededFieldSingleType($tblName, $dtls, $iar)