@@ -49,7 +49,7 @@ discard block |
||
| 49 | 49 | private function correctTableWithQuotesAsFieldPrefix($referenceTable) |
| 50 | 50 | { |
| 51 | 51 | if ($referenceTable != '') { |
| 52 | - return '`' . str_replace('`', '', $referenceTable) . '`.'; |
|
| 52 | + return '`'.str_replace('`', '', $referenceTable).'`.'; |
|
| 53 | 53 | } |
| 54 | 54 | return ''; |
| 55 | 55 | } |
@@ -64,8 +64,8 @@ discard block |
||
| 64 | 64 | */ |
| 65 | 65 | protected function getFieldOutputTextFK($foreignKeysArray, $value, $iar) |
| 66 | 66 | { |
| 67 | - $query = $this->sQueryGenericSelectKeyValue([ |
|
| 68 | - '`' . $value['COLUMN_NAME'] . '`', |
|
| 67 | + $query = $this->sQueryGenericSelectKeyValue([ |
|
| 68 | + '`'.$value['COLUMN_NAME'].'`', |
|
| 69 | 69 | $foreignKeysArray[$value['COLUMN_NAME']][2], |
| 70 | 70 | $foreignKeysArray[$value['COLUMN_NAME']][0] |
| 71 | 71 | ]); |
@@ -280,8 +280,8 @@ discard block |
||
| 280 | 280 | { |
| 281 | 281 | $filters2 = implode(', ', array_diff($value, [''])); |
| 282 | 282 | if ($filters2 != '') { |
| 283 | - return '(' . $referenceTable . '`' . $key . '` IN ("' |
|
| 284 | - . str_replace(',', '","', str_replace(["'", '"'], '', $filters2)) . '"))'; |
|
| 283 | + return '('.$referenceTable.'`'.$key.'` IN ("' |
|
| 284 | + . str_replace(',', '","', str_replace(["'", '"'], '', $filters2)).'"))'; |
|
| 285 | 285 | } |
| 286 | 286 | return ''; |
| 287 | 287 | } |
@@ -299,7 +299,7 @@ discard block |
||
| 299 | 299 | if ((substr($value, 0, 1) == '%') && (substr($value, -1) == '%')) { |
| 300 | 300 | $fTemp = 'LIKE'; |
| 301 | 301 | } |
| 302 | - return '(`' . $key . '` ' . $fTemp . '"' . $value . '")'; |
|
| 302 | + return '(`'.$key.'` '.$fTemp.'"'.$value.'")'; |
|
| 303 | 303 | } |
| 304 | 304 | |
| 305 | 305 | /** |
@@ -54,13 +54,13 @@ discard block |
||
| 54 | 54 | $this->sCleanParameters($parameters); |
| 55 | 55 | return implode(' ', [ |
| 56 | 56 | 'SELECT', |
| 57 | - $parameters[0] . ', ' . $parameters[1], |
|
| 57 | + $parameters[0].', '.$parameters[1], |
|
| 58 | 58 | 'FROM', |
| 59 | 59 | $parameters[2], |
| 60 | 60 | 'GROUP BY', |
| 61 | 61 | $parameters[0], |
| 62 | 62 | 'ORDER BY', |
| 63 | - $parameters[1] . ';' |
|
| 63 | + $parameters[1].';' |
|
| 64 | 64 | ]); |
| 65 | 65 | } |
| 66 | 66 | |
@@ -74,7 +74,7 @@ discard block |
||
| 74 | 74 | { |
| 75 | 75 | $sDBs = 'WHERE ' |
| 76 | 76 | . '`SCHEMA_NAME` NOT IN ("' |
| 77 | - . implode('", "', ['information_schema', 'mysql', 'performance_schema', 'sys']) . '") '; |
|
| 77 | + . implode('", "', ['information_schema', 'mysql', 'performance_schema', 'sys']).'") '; |
|
| 78 | 78 | return 'SELECT ' |
| 79 | 79 | . '`SCHEMA_NAME` As `Db`, `DEFAULT_CHARACTER_SET_NAME` AS `DbCharset`, ' |
| 80 | 80 | . '`DEFAULT_COLLATION_NAME` AS `DbCollation` ' |
@@ -128,16 +128,16 @@ discard block |
||
| 128 | 128 | { |
| 129 | 129 | $this->sCleanParameters($parameters); |
| 130 | 130 | return 'SELECT * ' |
| 131 | - . 'FROM `' . $parameters[0] . '` ' |
|
| 132 | - . 'WHERE ' . $parameters[1] . ';'; |
|
| 131 | + . 'FROM `'.$parameters[0].'` ' |
|
| 132 | + . 'WHERE '.$parameters[1].';'; |
|
| 133 | 133 | } |
| 134 | 134 | |
| 135 | 135 | protected function sQueryToDeleteSingleIdentifier($parameters) |
| 136 | 136 | { |
| 137 | 137 | $this->sCleanParameters($parameters); |
| 138 | 138 | return 'DELETE ' |
| 139 | - . 'FROM `' . $parameters[0] . '` ' |
|
| 140 | - . 'WHERE `' . $parameters[1] . '` = "' . $parameters[2] . '";'; |
|
| 139 | + . 'FROM `'.$parameters[0].'` ' |
|
| 140 | + . 'WHERE `'.$parameters[1].'` = "'.$parameters[2].'";'; |
|
| 141 | 141 | } |
| 142 | 142 | |
| 143 | 143 | } |
@@ -66,7 +66,7 @@ discard block |
||
| 66 | 66 | private function sGlueFilterValIntoWhereStr($filterValue) |
| 67 | 67 | { |
| 68 | 68 | if (is_array($filterValue)) { |
| 69 | - return 'IN ("' . implode('", "', $filterValue) . '")'; |
|
| 69 | + return 'IN ("'.implode('", "', $filterValue).'")'; |
|
| 70 | 70 | } |
| 71 | 71 | return $this->sGlueFilterValueIntoWhereStringFinal($filterValue); |
| 72 | 72 | } |
@@ -79,13 +79,13 @@ discard block |
||
| 79 | 79 | 'NOT NULL|NULL', |
| 80 | 80 | ]; |
| 81 | 81 | if (in_array($filterValue, explode('|', $kFields[0]))) { |
| 82 | - return '= ' . $filterValue; |
|
| 82 | + return '= '.$filterValue; |
|
| 83 | 83 | } elseif (in_array($filterValue, explode('|', $kFields[1]))) { |
| 84 | 84 | return $filterValue; |
| 85 | 85 | } elseif (in_array($filterValue, explode('|', $kFields[2]))) { |
| 86 | - return 'IS ' . $filterValue; |
|
| 86 | + return 'IS '.$filterValue; |
|
| 87 | 87 | } |
| 88 | - return '= "' . $filterValue . '"'; |
|
| 88 | + return '= "'.$filterValue.'"'; |
|
| 89 | 89 | } |
| 90 | 90 | |
| 91 | 91 | /** |
@@ -96,7 +96,7 @@ discard block |
||
| 96 | 96 | */ |
| 97 | 97 | private function sGlueFiltersIntoWhereArrayFilter($filters) |
| 98 | 98 | { |
| 99 | - return '(' . implode(') AND (', $filters) . ')'; |
|
| 99 | + return '('.implode(') AND (', $filters).')'; |
|
| 100 | 100 | } |
| 101 | 101 | |
| 102 | 102 | /** |
@@ -115,7 +115,7 @@ discard block |
||
| 115 | 115 | if (is_array($filterArray)) { |
| 116 | 116 | unset($filterArray['LIMIT']); |
| 117 | 117 | foreach ($filterArray as $key => $value) { |
| 118 | - $fltr[] = '`' . $tableToApplyFilterTo . '`.`' . $key . '` ' . $this->sGlueFilterValIntoWhereStr($value); |
|
| 118 | + $fltr[] = '`'.$tableToApplyFilterTo.'`.`'.$key.'` '.$this->sGlueFilterValIntoWhereStr($value); |
|
| 119 | 119 | } |
| 120 | 120 | } |
| 121 | 121 | return $this->sManageDynamicFiltersFinal($fltr); |
@@ -125,7 +125,7 @@ discard block |
||
| 125 | 125 | { |
| 126 | 126 | if (count($filters) > 0) { |
| 127 | 127 | $sReturn = ['WHERE', $this->sGlueFiltersIntoWhereArrayFilter($filters)]; |
| 128 | - return implode(' ', $sReturn) . ' '; |
|
| 128 | + return implode(' ', $sReturn).' '; |
|
| 129 | 129 | } |
| 130 | 130 | return ''; |
| 131 | 131 | } |
@@ -146,13 +146,13 @@ discard block |
||
| 146 | 146 | $filterArray = (is_array($filterArray) ? $filterArray : ['' => '']); |
| 147 | 147 | return 'SELECT ' |
| 148 | 148 | . '`C`.`TABLE_SCHEMA`, ' |
| 149 | - . $this->sQueryMySqlColumnsColumns() . ' ' |
|
| 149 | + . $this->sQueryMySqlColumnsColumns().' ' |
|
| 150 | 150 | . 'FROM `information_schema`.`COLUMNS` `C` ' |
| 151 | - . 'LEFT JOIN `information_schema`.`KEY_COLUMN_USAGE` `KCU` ON ((' . implode(') AND (', [ |
|
| 151 | + . 'LEFT JOIN `information_schema`.`KEY_COLUMN_USAGE` `KCU` ON (('.implode(') AND (', [ |
|
| 152 | 152 | '`C`.`TABLE_SCHEMA` = `KCU`.`TABLE_SCHEMA`', |
| 153 | 153 | '`C`.`TABLE_NAME` = `KCU`.`TABLE_NAME`', |
| 154 | 154 | '`C`.`COLUMN_NAME` = `KCU`.`COLUMN_NAME`', |
| 155 | - ]) . ')) ' |
|
| 155 | + ]).')) ' |
|
| 156 | 156 | . $this->sManageDynamicFilters($filterArray, 'C') |
| 157 | 157 | . 'GROUP BY `C`.`TABLE_SCHEMA`, `C`.`TABLE_NAME`, `C`.`COLUMN_NAME` ' |
| 158 | 158 | . 'ORDER BY `C`.`TABLE_SCHEMA`, `C`.`TABLE_NAME`, `C`.`ORDINAL_POSITION` ' |
@@ -179,20 +179,20 @@ discard block |
||
| 179 | 179 | { |
| 180 | 180 | return 'SELECT ' |
| 181 | 181 | . '`KCU`.`CONSTRAINT_SCHEMA`, ' |
| 182 | - . $this->sQueryMySqlIndexesColumns() . ' ' |
|
| 182 | + . $this->sQueryMySqlIndexesColumns().' ' |
|
| 183 | 183 | . 'FROM `information_schema`.`KEY_COLUMN_USAGE` `KCU` ' |
| 184 | - . 'INNER JOIN `information_schema`.`COLUMNS` `C` ON ((' . implode(') AND (', [ |
|
| 184 | + . 'INNER JOIN `information_schema`.`COLUMNS` `C` ON (('.implode(') AND (', [ |
|
| 185 | 185 | '`C`.`TABLE_SCHEMA` = `KCU`.`TABLE_SCHEMA`', |
| 186 | 186 | '`C`.`TABLE_NAME` = `KCU`.`TABLE_NAME`', |
| 187 | 187 | '`C`.`COLUMN_NAME` = `KCU`.`COLUMN_NAME`', |
| 188 | - ]) . ')) ' |
|
| 189 | - . 'LEFT JOIN `information_schema`.`REFERENTIAL_CONSTRAINTS` `RC` ON ((' . implode(') AND (', [ |
|
| 188 | + ]).')) ' |
|
| 189 | + . 'LEFT JOIN `information_schema`.`REFERENTIAL_CONSTRAINTS` `RC` ON (('.implode(') AND (', [ |
|
| 190 | 190 | '`KCU`.`CONSTRAINT_SCHEMA` = `RC`.`CONSTRAINT_SCHEMA`', |
| 191 | 191 | '`KCU`.`CONSTRAINT_NAME` = `RC`.`CONSTRAINT_NAME`', |
| 192 | - ]) . ')) ' |
|
| 192 | + ]).')) ' |
|
| 193 | 193 | . $this->sManageDynamicFilters($filterArray, 'KCU') |
| 194 | 194 | . 'ORDER BY `KCU`.`TABLE_SCHEMA`, `KCU`.`TABLE_NAME`' |
| 195 | - . $this->xtraSoring($filterArray, 'COLUMN_NAME') . ';'; |
|
| 195 | + . $this->xtraSoring($filterArray, 'COLUMN_NAME').';'; |
|
| 196 | 196 | } |
| 197 | 197 | |
| 198 | 198 | private function sQueryMySqlIndexesColumns() |
@@ -208,23 +208,23 @@ discard block |
||
| 208 | 208 | { |
| 209 | 209 | $tblAls = substr($tblName, 0, 1); |
| 210 | 210 | $colName = (is_null($adtnlCol) ? $tblName : $adtnlFltr); |
| 211 | - return '(SELECT COUNT(*) AS `No. of records` FROM `information_schema`.`' . $tblName . '` `' . $tblAls . '` ' |
|
| 212 | - . 'WHERE (`' . $tblAls . '`.`' . $lnkDbCol . '` = `S`.`SCHEMA_NAME`)' |
|
| 213 | - . (!is_null($adtnlCol) ? ' AND (`' . $tblAls . '`.`' . $adtnlCol . '` = "' . $adtnlFltr . '")' : '') |
|
| 214 | - . ') AS `' . ucwords(strtolower($colName)) . '`'; |
|
| 211 | + return '(SELECT COUNT(*) AS `No. of records` FROM `information_schema`.`'.$tblName.'` `'.$tblAls.'` ' |
|
| 212 | + . 'WHERE (`'.$tblAls.'`.`'.$lnkDbCol.'` = `S`.`SCHEMA_NAME`)' |
|
| 213 | + . (!is_null($adtnlCol) ? ' AND (`'.$tblAls.'`.`'.$adtnlCol.'` = "'.$adtnlFltr.'")' : '') |
|
| 214 | + . ') AS `'.ucwords(strtolower($colName)).'`'; |
|
| 215 | 215 | } |
| 216 | 216 | |
| 217 | 217 | protected function sQueryMySqlStatistics($filterArray = null) |
| 218 | 218 | { |
| 219 | 219 | return 'SELECT ' |
| 220 | 220 | . '`S`.`SCHEMA_NAME`, ' |
| 221 | - . $this->sQueryMySqlStatisticPattern('TABLES', 'TABLE_SCHEMA', 'TABLE_TYPE', 'BASE TABLE') . ', ' |
|
| 222 | - . $this->sQueryMySqlStatisticPattern('TABLES', 'TABLE_SCHEMA', 'TABLE_TYPE', 'VIEW') . ', ' |
|
| 223 | - . $this->sQueryMySqlStatisticPattern('COLUMNS', 'TABLE_SCHEMA') . ', ' |
|
| 224 | - . $this->sQueryMySqlStatisticPattern('TRIGGERS', 'EVENT_OBJECT_SCHEMA') . ', ' |
|
| 225 | - . $this->sQueryMySqlStatisticPattern('ROUTINES', 'ROUTINE_SCHEMA', 'ROUTINE_TYPE', 'Function') . ', ' |
|
| 226 | - . $this->sQueryMySqlStatisticPattern('ROUTINES', 'ROUTINE_SCHEMA', 'ROUTINE_TYPE', 'Procedure') . ', ' |
|
| 227 | - . $this->sQueryMySqlStatisticPattern('EVENTS', 'EVENT_SCHEMA') . ' ' |
|
| 221 | + . $this->sQueryMySqlStatisticPattern('TABLES', 'TABLE_SCHEMA', 'TABLE_TYPE', 'BASE TABLE').', ' |
|
| 222 | + . $this->sQueryMySqlStatisticPattern('TABLES', 'TABLE_SCHEMA', 'TABLE_TYPE', 'VIEW').', ' |
|
| 223 | + . $this->sQueryMySqlStatisticPattern('COLUMNS', 'TABLE_SCHEMA').', ' |
|
| 224 | + . $this->sQueryMySqlStatisticPattern('TRIGGERS', 'EVENT_OBJECT_SCHEMA').', ' |
|
| 225 | + . $this->sQueryMySqlStatisticPattern('ROUTINES', 'ROUTINE_SCHEMA', 'ROUTINE_TYPE', 'Function').', ' |
|
| 226 | + . $this->sQueryMySqlStatisticPattern('ROUTINES', 'ROUTINE_SCHEMA', 'ROUTINE_TYPE', 'Procedure').', ' |
|
| 227 | + . $this->sQueryMySqlStatisticPattern('EVENTS', 'EVENT_SCHEMA').' ' |
|
| 228 | 228 | . 'FROM `information_schema`.`SCHEMATA` `S` ' |
| 229 | 229 | . 'WHERE (`S`.`SCHEMA_NAME` NOT IN ("information_schema", "mysql", "performance_schema", "sys")) ' |
| 230 | 230 | . str_replace('WHERE', 'AND', $this->sManageDynamicFilters($filterArray, 'S')) |
@@ -245,7 +245,7 @@ discard block |
||
| 245 | 245 | . ', `T`.`CREATE_OPTIONS`, `T`.`TABLE_COMMENT` ' |
| 246 | 246 | . 'FROM `information_schema`.`TABLES` `T` ' |
| 247 | 247 | . $this->sManageDynamicFilters($filterArray, 'T') |
| 248 | - . $this->xtraSoring($filterArray, 'TABLE_SCHEMA') . ';'; |
|
| 248 | + . $this->xtraSoring($filterArray, 'TABLE_SCHEMA').';'; |
|
| 249 | 249 | } |
| 250 | 250 | |
| 251 | 251 | private function xtraSoring($filterArray, $filterValueToDecide) |
@@ -98,7 +98,7 @@ discard block |
||
| 98 | 98 | { |
| 99 | 99 | return [ |
| 100 | 100 | true, |
| 101 | - $this->sCloundFlareUrl . 'font-awesome/' . $this->getCmpltVers($cssFileName, 'font-awesome-') |
|
| 101 | + $this->sCloundFlareUrl.'font-awesome/'.$this->getCmpltVers($cssFileName, 'font-awesome-') |
|
| 102 | 102 | . '/css/font-awesome.min.css', |
| 103 | 103 | ]; |
| 104 | 104 | } |
@@ -133,7 +133,7 @@ discard block |
||
| 133 | 133 | 'highcharts' => 'setJavascriptFileCDNforHighCharts', |
| 134 | 134 | 'exporting' => 'setJavascriptFileCDNforHighChartsExporting', |
| 135 | 135 | ]; |
| 136 | - $rootFN = pathinfo($sFileParts[0])['basename']; |
|
| 136 | + $rootFN = pathinfo($sFileParts[0])['basename']; |
|
| 137 | 137 | if (array_key_exists($rootFN, $knownFNs)) { |
| 138 | 138 | return call_user_func([$this, $knownFNs[$rootFN]], pathinfo($jsFileName)['basename']); |
| 139 | 139 | } |
@@ -178,13 +178,13 @@ discard block |
||
| 178 | 178 | private function setJavascriptFileCDNforHighChartsMain($jsFileName, $libName) |
| 179 | 179 | { |
| 180 | 180 | $jsFN = $this->sanitizeString($jsFileName); |
| 181 | - $jsVersionlessFN = str_replace([$libName . '-', '.js'], '', pathinfo($jsFileName)['basename']) |
|
| 181 | + $jsVersionlessFN = str_replace([$libName.'-', '.js'], '', pathinfo($jsFileName)['basename']) |
|
| 182 | 182 | . ($libName === 'exporting' ? '/modules' : ''); |
| 183 | 183 | if (strpos($jsFileName, $libName) !== false) { |
| 184 | 184 | return [ |
| 185 | 185 | true, |
| 186 | - $this->sCloundFlareUrl . 'highcharts/' . $jsVersionlessFN . '/' . $libName . '.js', |
|
| 187 | - '<script>!window.Highcharts && document.write(\'<script src="' . $jsFN . '">\x3C/script>\')</script>', |
|
| 186 | + $this->sCloundFlareUrl.'highcharts/'.$jsVersionlessFN.'/'.$libName.'.js', |
|
| 187 | + '<script>!window.Highcharts && document.write(\'<script src="'.$jsFN.'">\x3C/script>\')</script>', |
|
| 188 | 188 | ]; |
| 189 | 189 | } |
| 190 | 190 | return null; |
@@ -205,8 +205,8 @@ discard block |
||
| 205 | 205 | if (($jQueryPosition !== false) && is_numeric($jQueryMajorVersion) && (substr($jsFileName, -7) == '.min.js')) { |
| 206 | 206 | return [ |
| 207 | 207 | true, |
| 208 | - $this->sCloundFlareUrl . 'jquery/' . $this->getCmpltVers($jsFileName, 'jquery-') . '/jquery.min.js', |
|
| 209 | - '<script>window.jQuery || document.write(\'<script src="' . $this->sanitizeString($jsFileName) |
|
| 208 | + $this->sCloundFlareUrl.'jquery/'.$this->getCmpltVers($jsFileName, 'jquery-').'/jquery.min.js', |
|
| 209 | + '<script>window.jQuery || document.write(\'<script src="'.$this->sanitizeString($jsFileName) |
|
| 210 | 210 | . '">\x3C/script>\')</script>', |
| 211 | 211 | ]; |
| 212 | 212 | } |
@@ -228,8 +228,8 @@ discard block |
||
| 228 | 228 | if (!is_null($eArray['version'])) { |
| 229 | 229 | return [ |
| 230 | 230 | true, |
| 231 | - $this->sCloundFlareUrl . $eArray['version'] . $eArray['justFile'], |
|
| 232 | - '<script>' . $eArray['eVerify'] . ' || document.write(\'<script src="' . $sFN |
|
| 231 | + $this->sCloundFlareUrl.$eArray['version'].$eArray['justFile'], |
|
| 232 | + '<script>'.$eArray['eVerify'].' || document.write(\'<script src="'.$sFN |
|
| 233 | 233 | . '">\x3C/script>\')</script>', |
| 234 | 234 | ]; |
| 235 | 235 | } |
@@ -45,8 +45,8 @@ discard block |
||
| 45 | 45 | } |
| 46 | 46 | $attributes = ''; |
| 47 | 47 | foreach ($features as $key => $value) { |
| 48 | - $val = $this->buildAttributesForTagValueArray($value); |
|
| 49 | - $attributes .= ' ' . $key . '="' . $val . '"'; |
|
| 48 | + $val = $this->buildAttributesForTagValueArray($value); |
|
| 49 | + $attributes .= ' '.$key.'="'.$val.'"'; |
|
| 50 | 50 | } |
| 51 | 51 | return $attributes; |
| 52 | 52 | } |
@@ -57,9 +57,9 @@ discard block |
||
| 57 | 57 | if (is_array($value)) { |
| 58 | 58 | $valA = []; |
| 59 | 59 | foreach ($value as $key2 => $value2) { |
| 60 | - $valA[] = $key2 . ':' . $value2; |
|
| 60 | + $valA[] = $key2.':'.$value2; |
|
| 61 | 61 | } |
| 62 | - $val = implode(';', $valA) . ';'; |
|
| 62 | + $val = implode(';', $valA).';'; |
|
| 63 | 63 | } |
| 64 | 64 | return $val; |
| 65 | 65 | } |
@@ -103,8 +103,8 @@ discard block |
||
| 103 | 103 | protected function setClearBoth1px($height = 1) |
| 104 | 104 | { |
| 105 | 105 | $divStyle = implode('', [ |
| 106 | - 'height:' . $height . 'px;', |
|
| 107 | - 'line-height:' . $height . 'px;', |
|
| 106 | + 'height:'.$height.'px;', |
|
| 107 | + 'line-height:'.$height.'px;', |
|
| 108 | 108 | 'float:none;', |
| 109 | 109 | 'clear:both;', |
| 110 | 110 | 'margin:0px;' |
@@ -128,7 +128,7 @@ discard block |
||
| 128 | 128 | $legend = $this->setStringIntoTag($sTitle, 'legend', ['style' => $this->setFeedbackStyle($sType)]); |
| 129 | 129 | return implode('', [ |
| 130 | 130 | ($skipBr ? '' : '<br/>'), |
| 131 | - $this->setStringIntoTag($legend . $sMsg, 'fieldset', ['style' => $this->setFeedbackStyle($sType)]), |
|
| 131 | + $this->setStringIntoTag($legend.$sMsg, 'fieldset', ['style' => $this->setFeedbackStyle($sType)]), |
|
| 132 | 132 | ]); |
| 133 | 133 | } |
| 134 | 134 | |
@@ -146,10 +146,10 @@ discard block |
||
| 146 | 146 | private function setFeedbackStyleArray($color1, $color2) |
| 147 | 147 | { |
| 148 | 148 | return [ |
| 149 | - 'Title' => 'margin-top:-5px;margin-right:20px;padding:5px;background-color:' . $color1 |
|
| 150 | - . ';color:' . $color2 . 'border:medium solid ' . $color1 . ';', |
|
| 151 | - 'Msg' => 'display:inline;padding-right:5px;padding-bottom:5px;background-color:' . $color2 |
|
| 152 | - . ';color:' . $color1 . ';border:medium solid ' . $color1 . ';', |
|
| 149 | + 'Title' => 'margin-top:-5px;margin-right:20px;padding:5px;background-color:'.$color1 |
|
| 150 | + . ';color:'.$color2.'border:medium solid '.$color1.';', |
|
| 151 | + 'Msg' => 'display:inline;padding-right:5px;padding-bottom:5px;background-color:'.$color2 |
|
| 152 | + . ';color:'.$color1.';border:medium solid '.$color1.';', |
|
| 153 | 153 | ]; |
| 154 | 154 | } |
| 155 | 155 | |
@@ -180,8 +180,8 @@ discard block |
||
| 180 | 180 | $gzipCntntOriginal = ob_get_contents(); |
| 181 | 181 | ob_end_clean(); |
| 182 | 182 | $gzipCntnt = gzcompress($gzipCntntOriginal, 9); |
| 183 | - echo "\x1f\x8b\x08\x00\x00\x00\x00\x00" . substr($gzipCntnt, 0, strlen($gzipCntnt) - 4) |
|
| 184 | - . pack('V', crc32($gzipCntntOriginal)) . pack('V', strlen($gzipCntntOriginal)); |
|
| 183 | + echo "\x1f\x8b\x08\x00\x00\x00\x00\x00".substr($gzipCntnt, 0, strlen($gzipCntnt) - 4) |
|
| 184 | + . pack('V', crc32($gzipCntntOriginal)).pack('V', strlen($gzipCntntOriginal)); |
|
| 185 | 185 | } elseif ($outputType === 'Header') { |
| 186 | 186 | ob_start(); |
| 187 | 187 | ob_implicit_flush(0); |
@@ -205,8 +205,8 @@ discard block |
||
| 205 | 205 | */ |
| 206 | 206 | protected function setHeaderNoCache($contentType = 'application/json') |
| 207 | 207 | { |
| 208 | - header("Content-Type: " . $contentType . "; charset=utf-8"); |
|
| 209 | - header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT"); |
|
| 208 | + header("Content-Type: ".$contentType."; charset=utf-8"); |
|
| 209 | + header("Last-Modified: ".gmdate("D, d M Y H:i:s")." GMT"); |
|
| 210 | 210 | header("Cache-Control: no-store, no-cache, must-revalidate"); |
| 211 | 211 | header("Cache-Control: post-check=0, pre-check=0", false); |
| 212 | 212 | header("Pragma: no-cache"); |
@@ -221,8 +221,8 @@ discard block |
||
| 221 | 221 | */ |
| 222 | 222 | protected function setStringIntoShortTag($sTag, $features = null) |
| 223 | 223 | { |
| 224 | - return '<' . $sTag . $this->buildAttributesForTag($features) |
|
| 225 | - . (isset($features['dont_close']) ? '' : '/') . '>'; |
|
| 224 | + return '<'.$sTag.$this->buildAttributesForTag($features) |
|
| 225 | + . (isset($features['dont_close']) ? '' : '/').'>'; |
|
| 226 | 226 | } |
| 227 | 227 | |
| 228 | 228 | /** |
@@ -235,12 +235,12 @@ discard block |
||
| 235 | 235 | */ |
| 236 | 236 | protected function setStringIntoTag($sString, $sTag, $features = null) |
| 237 | 237 | { |
| 238 | - return '<' . $sTag . $this->buildAttributesForTag($features) . '>' . $sString . '</' . $sTag . '>'; |
|
| 238 | + return '<'.$sTag.$this->buildAttributesForTag($features).'>'.$sString.'</'.$sTag.'>'; |
|
| 239 | 239 | } |
| 240 | 240 | |
| 241 | 241 | protected function setViewModernLinkAdd($identifier, $ftrs = null) |
| 242 | 242 | { |
| 243 | - $btnText = '<i class="fa fa-plus-square"> </i>' . ' ' . $this->lclMsgCmn('i18n_AddNewRecord'); |
|
| 243 | + $btnText = '<i class="fa fa-plus-square"> </i>'.' '.$this->lclMsgCmn('i18n_AddNewRecord'); |
|
| 244 | 244 | $tagFeatures = [ |
| 245 | 245 | 'href' => $this->setViewModernLinkAddUrl($identifier, $ftrs), |
| 246 | 246 | 'style' => 'margin: 5px 0px 10px 0px; display: inline-block;', |
@@ -253,7 +253,7 @@ discard block |
||
| 253 | 253 | $sArgmnts = ''; |
| 254 | 254 | if (isset($ftrs['injectAddArguments'])) { |
| 255 | 255 | foreach ($ftrs['injectAddArguments'] as $key => $value) { |
| 256 | - $sArgmnts .= '&' . $key . '=' . $value; |
|
| 256 | + $sArgmnts .= '&'.$key.'='.$value; |
|
| 257 | 257 | } |
| 258 | 258 | } |
| 259 | 259 | return $sArgmnts; |
@@ -263,9 +263,9 @@ discard block |
||
| 263 | 263 | { |
| 264 | 264 | $sArgmnts = $this->setViewModernLinkAddInjectedArguments($ftrs); |
| 265 | 265 | $this->initializeSprGlbAndSession(); |
| 266 | - $addingUrl = $this->tCmnRequest->server->get('PHP_SELF') . '?view=add_' . $identifier . $sArgmnts; |
|
| 266 | + $addingUrl = $this->tCmnRequest->server->get('PHP_SELF').'?view=add_'.$identifier.$sArgmnts; |
|
| 267 | 267 | if (!isset($ftrs['NoAjax'])) { |
| 268 | - $addingUrl = 'javascript:loadAE(\'' . $addingUrl . '\');'; |
|
| 268 | + $addingUrl = 'javascript:loadAE(\''.$addingUrl.'\');'; |
|
| 269 | 269 | } |
| 270 | 270 | return $addingUrl; |
| 271 | 271 | } |
@@ -67,7 +67,7 @@ discard block |
||
| 67 | 67 | |
| 68 | 68 | protected function getTimestampRaw($returnType) |
| 69 | 69 | { |
| 70 | - return call_user_func([$this, 'getTimestamp' . ucfirst($returnType)], gettimeofday()); |
|
| 70 | + return call_user_func([$this, 'getTimestamp'.ucfirst($returnType)], gettimeofday()); |
|
| 71 | 71 | } |
| 72 | 72 | |
| 73 | 73 | private function getTimestampString($crtTime) |
@@ -106,9 +106,9 @@ discard block |
||
| 106 | 106 | private function handleLocalizationCommon() |
| 107 | 107 | { |
| 108 | 108 | $this->handleLanguageIntoSession(); |
| 109 | - $localizationFile = $this->getCommonLocaleFolder() . '/locale/' |
|
| 110 | - . $this->tCmnSession->get('lang') . '/LC_MESSAGES/' |
|
| 111 | - . $this->commonLibFlags['localization_domain'] . '.mo'; |
|
| 109 | + $localizationFile = $this->getCommonLocaleFolder().'/locale/' |
|
| 110 | + . $this->tCmnSession->get('lang').'/LC_MESSAGES/' |
|
| 111 | + . $this->commonLibFlags['localization_domain'].'.mo'; |
|
| 112 | 112 | $translations = new \Gettext\Translations; |
| 113 | 113 | $translations->addFromMoFile($localizationFile); |
| 114 | 114 | $this->tCmnLb = new \Gettext\Translator(); |
@@ -75,8 +75,8 @@ discard block |
||
| 75 | 75 | } |
| 76 | 76 | } |
| 77 | 77 | } |
| 78 | - return '<style type="text/css" media="' . $attr['media'] . '">' |
|
| 79 | - . $cssContent . '</style>'; |
|
| 78 | + return '<style type="text/css" media="'.$attr['media'].'">' |
|
| 79 | + . $cssContent.'</style>'; |
|
| 80 | 80 | } |
| 81 | 81 | |
| 82 | 82 | /** |
@@ -92,11 +92,11 @@ discard block |
||
| 92 | 92 | } |
| 93 | 93 | if (in_array($this->getClientRealIpAddress(), $hostsWithoutCDNrq)) { |
| 94 | 94 | return '<link rel="stylesheet" type="text/css" href="' |
| 95 | - . filter_var($cssFileName, FILTER_SANITIZE_STRING) . '" />'; |
|
| 95 | + . filter_var($cssFileName, FILTER_SANITIZE_STRING).'" />'; |
|
| 96 | 96 | } |
| 97 | 97 | $patternFound = $this->setCssFileCDN($cssFileName); |
| 98 | 98 | return '<link rel="stylesheet" type="text/css" href="' |
| 99 | - . filter_var($patternFound[1], FILTER_SANITIZE_STRING) . '" />'; |
|
| 99 | + . filter_var($patternFound[1], FILTER_SANITIZE_STRING).'" />'; |
|
| 100 | 100 | } |
| 101 | 101 | |
| 102 | 102 | /** |
@@ -109,19 +109,19 @@ discard block |
||
| 109 | 109 | { |
| 110 | 110 | $cnt = implode(PHP_EOL, [ |
| 111 | 111 | '$(document).ready(function(){', |
| 112 | - '$("form#' . $frmId . '").submit(function(){', |
|
| 113 | - '$("form#' . $frmId . ' input[type=checkbox]").attr("readonly", true);', |
|
| 114 | - '$("form#' . $frmId . ' input[type=password]").attr("readonly", true);', |
|
| 115 | - '$("form#' . $frmId . ' input[type=radio]").attr("readonly", true);', |
|
| 116 | - '$("form#' . $frmId . ' input[type=text]").attr("readonly", true);', |
|
| 117 | - '$("form#' . $frmId . ' textarea").attr("readonly", true);', |
|
| 118 | - '$("form#' . $frmId . ' select").attr("readonly", true);', |
|
| 112 | + '$("form#'.$frmId.'").submit(function(){', |
|
| 113 | + '$("form#'.$frmId.' input[type=checkbox]").attr("readonly", true);', |
|
| 114 | + '$("form#'.$frmId.' input[type=password]").attr("readonly", true);', |
|
| 115 | + '$("form#'.$frmId.' input[type=radio]").attr("readonly", true);', |
|
| 116 | + '$("form#'.$frmId.' input[type=text]").attr("readonly", true);', |
|
| 117 | + '$("form#'.$frmId.' textarea").attr("readonly", true);', |
|
| 118 | + '$("form#'.$frmId.' select").attr("readonly", true);', |
|
| 119 | 119 | '$("input[type=submit]").attr("disabled", "disabled");', |
| 120 | - '$("input[type=submit]").attr("value", "' . $this->lclMsgCmn('i18n_Form_ButtonSaving') . '");', |
|
| 120 | + '$("input[type=submit]").attr("value", "'.$this->lclMsgCmn('i18n_Form_ButtonSaving').'");', |
|
| 121 | 121 | '});', |
| 122 | 122 | '});', |
| 123 | 123 | ]); |
| 124 | - return $this->setJavascriptContent(PHP_EOL . $cnt . PHP_EOL); |
|
| 124 | + return $this->setJavascriptContent(PHP_EOL.$cnt.PHP_EOL); |
|
| 125 | 125 | } |
| 126 | 126 | |
| 127 | 127 | /** |
@@ -133,7 +133,7 @@ discard block |
||
| 133 | 133 | { |
| 134 | 134 | return $this->setJavascriptContent(implode('', [ |
| 135 | 135 | 'function loadAE(action) {', |
| 136 | - 'document.getElementById("' . $tabName . '").tabber.tabShow(1);', |
|
| 136 | + 'document.getElementById("'.$tabName.'").tabber.tabShow(1);', |
|
| 137 | 137 | '$("#DynamicAddEditSpacer").load(action', |
| 138 | 138 | '+"&specialHook[]=noHeader"', |
| 139 | 139 | '+"&specialHook[]=noMenu"', |
@@ -152,7 +152,7 @@ discard block |
||
| 152 | 152 | */ |
| 153 | 153 | protected function setJavascriptContent($javascriptContent) |
| 154 | 154 | { |
| 155 | - return '<script type="text/javascript">' . $javascriptContent . '</script>'; |
|
| 155 | + return '<script type="text/javascript">'.$javascriptContent.'</script>'; |
|
| 156 | 156 | } |
| 157 | 157 | |
| 158 | 158 | /** |
@@ -165,7 +165,7 @@ discard block |
||
| 165 | 165 | return $this->setJavascriptContent('function setQuest(a, b) { ' |
| 166 | 166 | . 'c = a.indexOf("_"); switch(a.slice(0, c)) { ' |
| 167 | 167 | . 'case \'delete\': ' |
| 168 | - . 'if (confirm(\'' . $this->lclMsgCmn('i18n_ActionDelete_ConfirmationQuestion') . '\')) { ' |
|
| 168 | + . 'if (confirm(\''.$this->lclMsgCmn('i18n_ActionDelete_ConfirmationQuestion').'\')) { ' |
|
| 169 | 169 | . 'window.location = document.location.protocol + "//" + ' |
| 170 | 170 | . 'document.location.host + document.location.pathname + ' |
| 171 | 171 | . '"?view=" + a + "&" + b; } break; } }'); |
@@ -183,10 +183,10 @@ discard block |
||
| 183 | 183 | $hostsWithoutCDNrq = []; |
| 184 | 184 | } |
| 185 | 185 | if (in_array($this->getClientRealIpAddress(), $hostsWithoutCDNrq)) { |
| 186 | - return '<script type="text/javascript" src="' . $jsFileName . '"></script>'; |
|
| 186 | + return '<script type="text/javascript" src="'.$jsFileName.'"></script>'; |
|
| 187 | 187 | } |
| 188 | 188 | $patternFound = $this->setJavascriptFileCDN($jsFileName); |
| 189 | - return '<script type="text/javascript" src="' . $patternFound[1] . '"></script>' . $patternFound[2]; |
|
| 189 | + return '<script type="text/javascript" src="'.$patternFound[1].'"></script>'.$patternFound[2]; |
|
| 190 | 190 | } |
| 191 | 191 | |
| 192 | 192 | /** |
@@ -197,14 +197,14 @@ discard block |
||
| 197 | 197 | */ |
| 198 | 198 | protected function setJavascriptFileContent($jsFileName) |
| 199 | 199 | { |
| 200 | - return '<script type="text/javascript">' . file_get_contents($jsFileName, true) . '</script>'; |
|
| 200 | + return '<script type="text/javascript">'.file_get_contents($jsFileName, true).'</script>'; |
|
| 201 | 201 | } |
| 202 | 202 | |
| 203 | 203 | protected function updateDivTitleName($rememberGroupVal, $groupCounter) |
| 204 | 204 | { |
| 205 | 205 | $jsContent = '$(document).ready(function() { $("#tab_' |
| 206 | - . $this->cleanStringForId($rememberGroupVal) . '").attr("title", "' |
|
| 207 | - . $rememberGroupVal . ' (' . $groupCounter . ')"); });'; |
|
| 206 | + . $this->cleanStringForId($rememberGroupVal).'").attr("title", "' |
|
| 207 | + . $rememberGroupVal.' ('.$groupCounter.')"); });'; |
|
| 208 | 208 | return $this->setJavascriptContent($jsContent); |
| 209 | 209 | } |
| 210 | 210 | |
@@ -50,21 +50,21 @@ discard block |
||
| 50 | 50 | $sReturn = null; |
| 51 | 51 | $iRecPrPg = min($iRecPrPg, $iAllRec); |
| 52 | 52 | $iStartingPageRecord = $this->setStartingPageRecord($iCrtPgNo, $iRecPrPg, $iAllRec, $bKpFlPg); |
| 53 | - $sReturn .= '<span style="float:left;font-size:smaller;margin-top:1px; margin-right:1px;">' |
|
| 53 | + $sReturn .= '<span style="float:left;font-size:smaller;margin-top:1px; margin-right:1px;">' |
|
| 54 | 54 | . $this->setStringIntoTag($iAllRec, 'b') |
| 55 | 55 | . $this->lclMsgCmn('i18n_RecordsAvailableNowDisplaying') |
| 56 | 56 | . $this->setStringIntoTag(($iStartingPageRecord + 1), 'b') |
| 57 | - . ' - ' . $this->setStringIntoTag(min($iAllRec, ($iStartingPageRecord + $iRecPrPg)), 'b') |
|
| 57 | + . ' - '.$this->setStringIntoTag(min($iAllRec, ($iStartingPageRecord + $iRecPrPg)), 'b') |
|
| 58 | 58 | . ' </span>'; |
| 59 | 59 | switch ($iCrtPgNo) { |
| 60 | 60 | case 'first': |
| 61 | - $iCrtPgNo = ceil(($iStartingPageRecord + 1 ) / $iRecPrPg); |
|
| 61 | + $iCrtPgNo = ceil(($iStartingPageRecord + 1) / $iRecPrPg); |
|
| 62 | 62 | break; |
| 63 | 63 | case 'last': |
| 64 | 64 | $iCrtPgNo = ceil($iAllRec / $iRecPrPg); |
| 65 | 65 | break; |
| 66 | 66 | } |
| 67 | - $sReturn .= '<span style="float:right;font-size:smaller;margin-top:1px; margin-right:1px;">'; |
|
| 67 | + $sReturn .= '<span style="float:right;font-size:smaller;margin-top:1px; margin-right:1px;">'; |
|
| 68 | 68 | $iNumberOfPages = ceil($iAllRec / $iRecPrPg); |
| 69 | 69 | $sAdditionalArguments = ''; |
| 70 | 70 | if (isset($_GET)) { |
@@ -78,7 +78,7 @@ discard block |
||
| 78 | 78 | } |
| 79 | 79 | if ($iCrtPgNo != 1) { |
| 80 | 80 | $sReturn .= $this->setStringIntoTag($this->lclMsgCmn('i18n_Previous'), 'a', [ |
| 81 | - 'href' => ('?page=' . ($iCrtPgNo - 1 ) . $sAdditionalArguments ), |
|
| 81 | + 'href' => ('?page='.($iCrtPgNo - 1).$sAdditionalArguments), |
|
| 82 | 82 | 'class' => 'pagination' |
| 83 | 83 | ]); |
| 84 | 84 | } else { |
@@ -90,7 +90,7 @@ discard block |
||
| 90 | 90 | for ($counter = 1; $counter <= $iNumberOfPages; $counter++) { |
| 91 | 91 | $pages2display[$counter] = $counter; |
| 92 | 92 | } |
| 93 | - $sReturn .= '<span class="pagination"><form method="get" action="' . $_SERVER['SCRIPT_NAME'] . '">'; |
|
| 93 | + $sReturn .= '<span class="pagination"><form method="get" action="'.$_SERVER['SCRIPT_NAME'].'">'; |
|
| 94 | 94 | $sReturn .= $this->setArrayToSelect($pages2display, @$_REQUEST['page'] |
| 95 | 95 | , 'page', ['size' => 1, 'autosubmit', 'id_no' => mt_rand()]); |
| 96 | 96 | if (isset($_GET)) { |
@@ -100,7 +100,7 @@ discard block |
||
| 100 | 100 | foreach ($value as $value2) { |
| 101 | 101 | $sReturn .= $this->setStringIntoShortTag('input', [ |
| 102 | 102 | 'type' => 'hidden', |
| 103 | - 'name' => $key . '[]', |
|
| 103 | + 'name' => $key.'[]', |
|
| 104 | 104 | 'value' => $value2, |
| 105 | 105 | ]); |
| 106 | 106 | } |
@@ -117,7 +117,7 @@ discard block |
||
| 117 | 117 | $sReturn .= '</form></span>'; |
| 118 | 118 | if ($iCrtPgNo != $iNumberOfPages) { |
| 119 | 119 | $sReturn .= $this->setStringIntoTag($this->lclMsgCmn('i18n_Next'), 'a', [ |
| 120 | - 'href' => ('?page=' . ($iCrtPgNo + 1 ) . $sAdditionalArguments ), |
|
| 120 | + 'href' => ('?page='.($iCrtPgNo + 1).$sAdditionalArguments), |
|
| 121 | 121 | 'class' => 'pagination', |
| 122 | 122 | ]); |
| 123 | 123 | } else { |
@@ -143,7 +143,7 @@ discard block |
||
| 143 | 143 | , $iAllRecords, $bKeepFullPage = true) |
| 144 | 144 | { |
| 145 | 145 | if (isset($_REQUEST['page'])) { |
| 146 | - $iStartingPageRecord = ($_REQUEST['page'] - 1 ) * $iRecordsPerPage; |
|
| 146 | + $iStartingPageRecord = ($_REQUEST['page'] - 1) * $iRecordsPerPage; |
|
| 147 | 147 | } else { |
| 148 | 148 | switch ($sDefaultPageNo) { |
| 149 | 149 | case 'last': |
@@ -155,7 +155,7 @@ discard block |
||
| 155 | 155 | break; |
| 156 | 156 | } |
| 157 | 157 | } |
| 158 | - if (($bKeepFullPage ) && (($iStartingPageRecord + $iRecordsPerPage ) > $iAllRecords)) { |
|
| 158 | + if (($bKeepFullPage) && (($iStartingPageRecord + $iRecordsPerPage) > $iAllRecords)) { |
|
| 159 | 159 | $iStartingPageRecord = $iAllRecords - $iRecordsPerPage; |
| 160 | 160 | } |
| 161 | 161 | return max(0, $iStartingPageRecord); |