danielgp / common-lib

source/MySQLiByDanielGPstructures.php

Spacing +6 added lines, -6 removed lines

@@ -49,7 +49,7 @@ 
     private function correctTableWithQuotesAsFieldPrefix($referenceTable)
     {
         if ($referenceTable != '') {
-            return '`' . str_replace('`', '', $referenceTable) . '`.';
+            return '`'.str_replace('`', '', $referenceTable).'`.';
         }
         return '';
     }
@@ -64,8 +64,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]
         ]);
@@ -280,8 +280,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 '';
     }
@@ -299,7 +299,7 @@ 
         if ((substr($value, 0, 1) == '%') && (substr($value, -1) == '%')) {
             $fTemp = 'LIKE';
         }
-        return '(`' . $key . '` ' . $fTemp . '"' . $value . '")';
+        return '(`'.$key.'` '.$fTemp.'"'.$value.'")';
     }
 
     /**

source/MySQLiByDanielGPqueriesBasic.php

Spacing +7 added lines, -7 removed lines

@@ -54,13 +54,13 @@ 
         $this->sCleanParameters($parameters);
         return implode(' ', [
             'SELECT',
-            $parameters[0] . ', ' . $parameters[1],
+            $parameters[0].', '.$parameters[1],
             'FROM',
             $parameters[2],
             'GROUP BY',
             $parameters[0],
             'ORDER BY',
-            $parameters[1] . ';'
+            $parameters[1].';'
         ]);
     }
 
@@ -74,7 +74,7 @@ 
     {
         $sDBs = 'WHERE '
             . '`SCHEMA_NAME` NOT IN ("'
-            . implode('", "', ['information_schema', 'mysql', 'performance_schema', 'sys']) . '") ';
+            . implode('", "', ['information_schema', 'mysql', 'performance_schema', 'sys']).'") ';
         return 'SELECT '
             . '`SCHEMA_NAME` As `Db`, `DEFAULT_CHARACTER_SET_NAME` AS `DbCharset`, '
             . '`DEFAULT_COLLATION_NAME` AS `DbCollation` '
@@ -128,16 +128,16 @@ 
     {
         $this->sCleanParameters($parameters);
         return 'SELECT * '
-            . 'FROM `' . $parameters[0] . '` '
-            . 'WHERE ' . $parameters[1] . ';';
+            . 'FROM `'.$parameters[0].'` '
+            . 'WHERE '.$parameters[1].';';
     }
 
     protected function sQueryToDeleteSingleIdentifier($parameters)
     {
         $this->sCleanParameters($parameters);
         return 'DELETE '
-            . 'FROM `' . $parameters[0] . '` '
-            . 'WHERE `' . $parameters[1] . '` = "' . $parameters[2] . '";';
+            . 'FROM `'.$parameters[0].'` '
+            . 'WHERE `'.$parameters[1].'` = "'.$parameters[2].'";';
     }
 
 }

source/MySQLiByDanielGPqueries.php

Spacing +28 added lines, -28 removed lines

@@ -66,7 +66,7 @@ 
     private function sGlueFilterValIntoWhereStr($filterValue)
     {
         if (is_array($filterValue)) {
-            return 'IN ("' . implode('", "', $filterValue) . '")';
+            return 'IN ("'.implode('", "', $filterValue).'")';
         }
         return $this->sGlueFilterValueIntoWhereStringFinal($filterValue);
     }
@@ -79,13 +79,13 @@ 
             'NOT NULL|NULL',
         ];
         if (in_array($filterValue, explode('|', $kFields[0]))) {
-            return '= ' . $filterValue;
+            return '= '.$filterValue;
         } elseif (in_array($filterValue, explode('|', $kFields[1]))) {
             return $filterValue;
         } elseif (in_array($filterValue, explode('|', $kFields[2]))) {
-            return 'IS ' . $filterValue;
+            return 'IS '.$filterValue;
         }
-        return '= "' . $filterValue . '"';
+        return '= "'.$filterValue.'"';
     }
 
     /**
@@ -96,7 +96,7 @@ 
      */
     private function sGlueFiltersIntoWhereArrayFilter($filters)
     {
-        return '(' . implode(') AND (', $filters) . ')';
+        return '('.implode(') AND (', $filters).')';
     }
 
     /**
@@ -115,7 +115,7 @@ 
         if (is_array($filterArray)) {
             unset($filterArray['LIMIT']);
             foreach ($filterArray as $key => $value) {
-                $fltr[] = '`' . $tableToApplyFilterTo . '`.`' . $key . '` ' . $this->sGlueFilterValIntoWhereStr($value);
+                $fltr[] = '`'.$tableToApplyFilterTo.'`.`'.$key.'` '.$this->sGlueFilterValIntoWhereStr($value);
             }
         }
         return $this->sManageDynamicFiltersFinal($fltr);
@@ -125,7 +125,7 @@ 
     {
         if (count($filters) > 0) {
             $sReturn = ['WHERE', $this->sGlueFiltersIntoWhereArrayFilter($filters)];
-            return implode(' ', $sReturn) . ' ';
+            return implode(' ', $sReturn).' ';
         }
         return '';
     }
@@ -146,13 +146,13 @@ 
         $filterArray = (is_array($filterArray) ? $filterArray : ['' => '']);
         return 'SELECT '
             . '`C`.`TABLE_SCHEMA`, '
-            . $this->sQueryMySqlColumnsColumns() . ' '
+            . $this->sQueryMySqlColumnsColumns().' '
             . 'FROM `information_schema`.`COLUMNS` `C` '
-            . 'LEFT JOIN `information_schema`.`KEY_COLUMN_USAGE` `KCU` ON ((' . implode(') AND (', [
+            . 'LEFT JOIN `information_schema`.`KEY_COLUMN_USAGE` `KCU` ON (('.implode(') AND (', [
                 '`C`.`TABLE_SCHEMA` = `KCU`.`TABLE_SCHEMA`',
                 '`C`.`TABLE_NAME` = `KCU`.`TABLE_NAME`',
                 '`C`.`COLUMN_NAME` = `KCU`.`COLUMN_NAME`',
-            ]) . ')) '
+            ]).')) '
             . $this->sManageDynamicFilters($filterArray, 'C')
             . 'GROUP BY `C`.`TABLE_SCHEMA`, `C`.`TABLE_NAME`, `C`.`COLUMN_NAME` '
             . 'ORDER BY `C`.`TABLE_SCHEMA`, `C`.`TABLE_NAME`, `C`.`ORDINAL_POSITION` '
@@ -179,20 +179,20 @@ 
     {
         return 'SELECT '
             . '`KCU`.`CONSTRAINT_SCHEMA`, '
-            . $this->sQueryMySqlIndexesColumns() . ' '
+            . $this->sQueryMySqlIndexesColumns().' '
             . 'FROM `information_schema`.`KEY_COLUMN_USAGE` `KCU` '
-            . 'INNER JOIN `information_schema`.`COLUMNS` `C` ON ((' . implode(') AND (', [
+            . 'INNER JOIN `information_schema`.`COLUMNS` `C` ON (('.implode(') AND (', [
                 '`C`.`TABLE_SCHEMA` = `KCU`.`TABLE_SCHEMA`',
                 '`C`.`TABLE_NAME` = `KCU`.`TABLE_NAME`',
                 '`C`.`COLUMN_NAME` = `KCU`.`COLUMN_NAME`',
-            ]) . ')) '
-            . 'LEFT JOIN `information_schema`.`REFERENTIAL_CONSTRAINTS` `RC` ON ((' . implode(') AND (', [
+            ]).')) '
+            . 'LEFT JOIN `information_schema`.`REFERENTIAL_CONSTRAINTS` `RC` ON (('.implode(') AND (', [
                 '`KCU`.`CONSTRAINT_SCHEMA` = `RC`.`CONSTRAINT_SCHEMA`',
                 '`KCU`.`CONSTRAINT_NAME` = `RC`.`CONSTRAINT_NAME`',
-            ]) . ')) '
+            ]).')) '
             . $this->sManageDynamicFilters($filterArray, 'KCU')
             . 'ORDER BY `KCU`.`TABLE_SCHEMA`, `KCU`.`TABLE_NAME`'
-            . $this->xtraSoring($filterArray, 'COLUMN_NAME') . ';';
+            . $this->xtraSoring($filterArray, 'COLUMN_NAME').';';
     }
 
     private function sQueryMySqlIndexesColumns()
@@ -208,23 +208,23 @@ 
     {
         $tblAls  = substr($tblName, 0, 1);
         $colName = (is_null($adtnlCol) ? $tblName : $adtnlFltr);
-        return '(SELECT COUNT(*) AS `No. of records` FROM `information_schema`.`' . $tblName . '` `' . $tblAls . '` '
-            . 'WHERE (`' . $tblAls . '`.`' . $lnkDbCol . '` = `S`.`SCHEMA_NAME`)'
-            . (!is_null($adtnlCol) ? ' AND (`' . $tblAls . '`.`' . $adtnlCol . '` = "' . $adtnlFltr . '")' : '')
-            . ') AS `' . ucwords(strtolower($colName)) . '`';
+        return '(SELECT COUNT(*) AS `No. of records` FROM `information_schema`.`'.$tblName.'` `'.$tblAls.'` '
+            . 'WHERE (`'.$tblAls.'`.`'.$lnkDbCol.'` = `S`.`SCHEMA_NAME`)'
+            . (!is_null($adtnlCol) ? ' AND (`'.$tblAls.'`.`'.$adtnlCol.'` = "'.$adtnlFltr.'")' : '')
+            . ') AS `'.ucwords(strtolower($colName)).'`';
     }
 
     protected function sQueryMySqlStatistics($filterArray = null)
     {
         return 'SELECT '
             . '`S`.`SCHEMA_NAME`, '
-            . $this->sQueryMySqlStatisticPattern('TABLES', 'TABLE_SCHEMA', 'TABLE_TYPE', 'BASE TABLE') . ', '
-            . $this->sQueryMySqlStatisticPattern('TABLES', 'TABLE_SCHEMA', 'TABLE_TYPE', 'VIEW') . ', '
-            . $this->sQueryMySqlStatisticPattern('COLUMNS', 'TABLE_SCHEMA') . ', '
-            . $this->sQueryMySqlStatisticPattern('TRIGGERS', 'EVENT_OBJECT_SCHEMA') . ', '
-            . $this->sQueryMySqlStatisticPattern('ROUTINES', 'ROUTINE_SCHEMA', 'ROUTINE_TYPE', 'Function') . ', '
-            . $this->sQueryMySqlStatisticPattern('ROUTINES', 'ROUTINE_SCHEMA', 'ROUTINE_TYPE', 'Procedure') . ', '
-            . $this->sQueryMySqlStatisticPattern('EVENTS', 'EVENT_SCHEMA') . ' '
+            . $this->sQueryMySqlStatisticPattern('TABLES', 'TABLE_SCHEMA', 'TABLE_TYPE', 'BASE TABLE').', '
+            . $this->sQueryMySqlStatisticPattern('TABLES', 'TABLE_SCHEMA', 'TABLE_TYPE', 'VIEW').', '
+            . $this->sQueryMySqlStatisticPattern('COLUMNS', 'TABLE_SCHEMA').', '
+            . $this->sQueryMySqlStatisticPattern('TRIGGERS', 'EVENT_OBJECT_SCHEMA').', '
+            . $this->sQueryMySqlStatisticPattern('ROUTINES', 'ROUTINE_SCHEMA', 'ROUTINE_TYPE', 'Function').', '
+            . $this->sQueryMySqlStatisticPattern('ROUTINES', 'ROUTINE_SCHEMA', 'ROUTINE_TYPE', 'Procedure').', '
+            . $this->sQueryMySqlStatisticPattern('EVENTS', 'EVENT_SCHEMA').' '
             . 'FROM `information_schema`.`SCHEMATA` `S` '
             . 'WHERE (`S`.`SCHEMA_NAME` NOT IN ("information_schema", "mysql", "performance_schema", "sys")) '
             . str_replace('WHERE', 'AND', $this->sManageDynamicFilters($filterArray, 'S'))
@@ -245,7 +245,7 @@ 
             . ', `T`.`CREATE_OPTIONS`, `T`.`TABLE_COMMENT` '
             . 'FROM `information_schema`.`TABLES` `T` '
             . $this->sManageDynamicFilters($filterArray, 'T')
-            . $this->xtraSoring($filterArray, 'TABLE_SCHEMA') . ';';
+            . $this->xtraSoring($filterArray, 'TABLE_SCHEMA').';';
     }
 
     private function xtraSoring($filterArray, $filterValueToDecide)

source/DomCssAndJavascriptByDanielGPwithCDN.php

Spacing +9 added lines, -9 removed lines

@@ -98,7 +98,7 @@ 
     {
         return [
             true,
-            $this->sCloundFlareUrl . 'font-awesome/' . $this->getCmpltVers($cssFileName, 'font-awesome-')
+            $this->sCloundFlareUrl.'font-awesome/'.$this->getCmpltVers($cssFileName, 'font-awesome-')
             . '/css/font-awesome.min.css',
         ];
     }
@@ -133,7 +133,7 @@ 
             'highcharts' => 'setJavascriptFileCDNforHighCharts',
             'exporting'  => 'setJavascriptFileCDNforHighChartsExporting',
         ];
-        $rootFN     = pathinfo($sFileParts[0])['basename'];
+        $rootFN = pathinfo($sFileParts[0])['basename'];
         if (array_key_exists($rootFN, $knownFNs)) {
             return call_user_func([$this, $knownFNs[$rootFN]], pathinfo($jsFileName)['basename']);
         }
@@ -178,13 +178,13 @@ 
     private function setJavascriptFileCDNforHighChartsMain($jsFileName, $libName)
     {
         $jsFN            = $this->sanitizeString($jsFileName);
-        $jsVersionlessFN = str_replace([$libName . '-', '.js'], '', pathinfo($jsFileName)['basename'])
+        $jsVersionlessFN = str_replace([$libName.'-', '.js'], '', pathinfo($jsFileName)['basename'])
             . ($libName === 'exporting' ? '/modules' : '');
         if (strpos($jsFileName, $libName) !== false) {
             return [
                 true,
-                $this->sCloundFlareUrl . 'highcharts/' . $jsVersionlessFN . '/' . $libName . '.js',
-                '<script>!window.Highcharts && document.write(\'<script src="' . $jsFN . '">\x3C/script>\')</script>',
+                $this->sCloundFlareUrl.'highcharts/'.$jsVersionlessFN.'/'.$libName.'.js',
+                '<script>!window.Highcharts && document.write(\'<script src="'.$jsFN.'">\x3C/script>\')</script>',
             ];
         }
         return null;
@@ -205,8 +205,8 @@ 
         if (($jQueryPosition !== false) && is_numeric($jQueryMajorVersion) && (substr($jsFileName, -7) == '.min.js')) {
             return [
                 true,
-                $this->sCloundFlareUrl . 'jquery/' . $this->getCmpltVers($jsFileName, 'jquery-') . '/jquery.min.js',
-                '<script>window.jQuery || document.write(\'<script src="' . $this->sanitizeString($jsFileName)
+                $this->sCloundFlareUrl.'jquery/'.$this->getCmpltVers($jsFileName, 'jquery-').'/jquery.min.js',
+                '<script>window.jQuery || document.write(\'<script src="'.$this->sanitizeString($jsFileName)
                 . '">\x3C/script>\')</script>',
             ];
         }
@@ -228,8 +228,8 @@ 
         if (!is_null($eArray['version'])) {
             return [
                 true,
-                $this->sCloundFlareUrl . $eArray['version'] . $eArray['justFile'],
-                '<script>' . $eArray['eVerify'] . ' || document.write(\'<script src="' . $sFN
+                $this->sCloundFlareUrl.$eArray['version'].$eArray['justFile'],
+                '<script>'.$eArray['eVerify'].' || document.write(\'<script src="'.$sFN
                 . '">\x3C/script>\')</script>',
             ];
         }

source/DomBasicComponentsByDanielGP.php

Spacing +22 added lines, -22 removed lines

@@ -45,8 +45,8 @@ 
         }
         $attributes = '';
         foreach ($features as $key => $value) {
-            $val        = $this->buildAttributesForTagValueArray($value);
-            $attributes .= ' ' . $key . '="' . $val . '"';
+            $val = $this->buildAttributesForTagValueArray($value);
+            $attributes .= ' '.$key.'="'.$val.'"';
         }
         return $attributes;
     }
@@ -57,9 +57,9 @@ 
         if (is_array($value)) {
             $valA = [];
             foreach ($value as $key2 => $value2) {
-                $valA[] = $key2 . ':' . $value2;
+                $valA[] = $key2.':'.$value2;
             }
-            $val = implode(';', $valA) . ';';
+            $val = implode(';', $valA).';';
         }
         return $val;
     }
@@ -103,8 +103,8 @@ 
     protected function setClearBoth1px($height = 1)
     {
         $divStyle = implode('', [
-            'height:' . $height . 'px;',
-            'line-height:' . $height . 'px;',
+            'height:'.$height.'px;',
+            'line-height:'.$height.'px;',
             'float:none;',
             'clear:both;',
             'margin:0px;'
@@ -128,7 +128,7 @@ 
         $legend = $this->setStringIntoTag($sTitle, 'legend', ['style' => $this->setFeedbackStyle($sType)]);
         return implode('', [
             ($skipBr ? '' : '<br/>'),
-            $this->setStringIntoTag($legend . $sMsg, 'fieldset', ['style' => $this->setFeedbackStyle($sType)]),
+            $this->setStringIntoTag($legend.$sMsg, 'fieldset', ['style' => $this->setFeedbackStyle($sType)]),
         ]);
     }
 
@@ -146,10 +146,10 @@ 
     private function setFeedbackStyleArray($color1, $color2)
     {
         return [
-            'Title' => 'margin-top:-5px;margin-right:20px;padding:5px;background-color:' . $color1
-            . ';color:' . $color2 . 'border:medium solid ' . $color1 . ';',
-            'Msg'   => 'display:inline;padding-right:5px;padding-bottom:5px;background-color:' . $color2
-            . ';color:' . $color1 . ';border:medium solid ' . $color1 . ';',
+            'Title' => 'margin-top:-5px;margin-right:20px;padding:5px;background-color:'.$color1
+            . ';color:'.$color2.'border:medium solid '.$color1.';',
+            'Msg'   => 'display:inline;padding-right:5px;padding-bottom:5px;background-color:'.$color2
+            . ';color:'.$color1.';border:medium solid '.$color1.';',
         ];
     }
 
@@ -180,8 +180,8 @@ 
             $gzipCntntOriginal = ob_get_contents();
             ob_end_clean();
             $gzipCntnt         = gzcompress($gzipCntntOriginal, 9);
-            echo "\x1f\x8b\x08\x00\x00\x00\x00\x00" . substr($gzipCntnt, 0, strlen($gzipCntnt) - 4)
-            . pack('V', crc32($gzipCntntOriginal)) . pack('V', strlen($gzipCntntOriginal));
+            echo "\x1f\x8b\x08\x00\x00\x00\x00\x00".substr($gzipCntnt, 0, strlen($gzipCntnt) - 4)
+            . pack('V', crc32($gzipCntntOriginal)).pack('V', strlen($gzipCntntOriginal));
         } elseif ($outputType === 'Header') {
             ob_start();
             ob_implicit_flush(0);
@@ -205,8 +205,8 @@ 
      */
     protected function setHeaderNoCache($contentType = 'application/json')
     {
-        header("Content-Type: " . $contentType . "; charset=utf-8");
-        header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT");
+        header("Content-Type: ".$contentType."; charset=utf-8");
+        header("Last-Modified: ".gmdate("D, d M Y H:i:s")." GMT");
         header("Cache-Control: no-store, no-cache, must-revalidate");
         header("Cache-Control: post-check=0, pre-check=0", false);
         header("Pragma: no-cache");
@@ -221,8 +221,8 @@ 
      */
     protected function setStringIntoShortTag($sTag, $features = null)
     {
-        return '<' . $sTag . $this->buildAttributesForTag($features)
-            . (isset($features['dont_close']) ? '' : '/') . '>';
+        return '<'.$sTag.$this->buildAttributesForTag($features)
+            . (isset($features['dont_close']) ? '' : '/').'>';
     }
 
     /**
@@ -235,12 +235,12 @@ 
      */
     protected function setStringIntoTag($sString, $sTag, $features = null)
     {
-        return '<' . $sTag . $this->buildAttributesForTag($features) . '>' . $sString . '</' . $sTag . '>';
+        return '<'.$sTag.$this->buildAttributesForTag($features).'>'.$sString.'</'.$sTag.'>';
     }
 
     protected function setViewModernLinkAdd($identifier, $ftrs = null)
     {
-        $btnText     = '<i class="fa fa-plus-square">&nbsp;</i>' . '&nbsp;' . $this->lclMsgCmn('i18n_AddNewRecord');
+        $btnText     = '<i class="fa fa-plus-square">&nbsp;</i>'.'&nbsp;'.$this->lclMsgCmn('i18n_AddNewRecord');
         $tagFeatures = [
             'href'  => $this->setViewModernLinkAddUrl($identifier, $ftrs),
             'style' => 'margin: 5px 0px 10px 0px; display: inline-block;',
@@ -253,7 +253,7 @@ 
         $sArgmnts = '';
         if (isset($ftrs['injectAddArguments'])) {
             foreach ($ftrs['injectAddArguments'] as $key => $value) {
-                $sArgmnts .= '&amp;' . $key . '=' . $value;
+                $sArgmnts .= '&amp;'.$key.'='.$value;
             }
         }
         return $sArgmnts;
@@ -263,9 +263,9 @@ 
     {
         $sArgmnts  = $this->setViewModernLinkAddInjectedArguments($ftrs);
         $this->initializeSprGlbAndSession();
-        $addingUrl = $this->tCmnRequest->server->get('PHP_SELF') . '?view=add_' . $identifier . $sArgmnts;
+        $addingUrl = $this->tCmnRequest->server->get('PHP_SELF').'?view=add_'.$identifier.$sArgmnts;
         if (!isset($ftrs['NoAjax'])) {
-            $addingUrl = 'javascript:loadAE(\'' . $addingUrl . '\');';
+            $addingUrl = 'javascript:loadAE(\''.$addingUrl.'\');';
         }
         return $addingUrl;
     }

source/CommonLibLocale.php

Spacing +4 added lines, -4 removed lines

@@ -67,7 +67,7 @@ 
 
     protected function getTimestampRaw($returnType)
     {
-        return call_user_func([$this, 'getTimestamp' . ucfirst($returnType)], gettimeofday());
+        return call_user_func([$this, 'getTimestamp'.ucfirst($returnType)], gettimeofday());
     }
 
     private function getTimestampString($crtTime)
@@ -106,9 +106,9 @@ 
     private function handleLocalizationCommon()
     {
         $this->handleLanguageIntoSession();
-        $localizationFile = $this->getCommonLocaleFolder() . '/locale/'
-            . $this->tCmnSession->get('lang') . '/LC_MESSAGES/'
-            . $this->commonLibFlags['localization_domain'] . '.mo';
+        $localizationFile = $this->getCommonLocaleFolder().'/locale/'
+            . $this->tCmnSession->get('lang').'/LC_MESSAGES/'
+            . $this->commonLibFlags['localization_domain'].'.mo';
         $translations     = new \Gettext\Translations;
         $translations->addFromMoFile($localizationFile);
         $this->tCmnLb     = new \Gettext\Translator();