@@ -48,7 +48,7 @@ discard block |
||
| 48 | 48 | private function correctTableWithQuotesAsFieldPrefix($referenceTable) |
| 49 | 49 | { |
| 50 | 50 | if ($referenceTable != '') { |
| 51 | - return '`' . str_replace('`', '', $referenceTable) . '`.'; |
|
| 51 | + return '`'.str_replace('`', '', $referenceTable).'`.'; |
|
| 52 | 52 | } |
| 53 | 53 | return ''; |
| 54 | 54 | } |
@@ -81,7 +81,7 @@ discard block |
||
| 81 | 81 | private function sGlueFilterValIntoWhereStr($filterValue) |
| 82 | 82 | { |
| 83 | 83 | if (is_array($filterValue)) { |
| 84 | - return 'IN ("' . implode('", "', $filterValue) . '")'; |
|
| 84 | + return 'IN ("'.implode('", "', $filterValue).'")'; |
|
| 85 | 85 | } |
| 86 | 86 | return $this->sGlueFilterValueIntoWhereStringFinal($filterValue); |
| 87 | 87 | } |
@@ -94,13 +94,13 @@ discard block |
||
| 94 | 94 | 'NOT NULL|NULL', |
| 95 | 95 | ]; |
| 96 | 96 | if (in_array($filterValue, explode('|', $kFields[0]))) { |
| 97 | - return '= ' . $filterValue; |
|
| 97 | + return '= '.$filterValue; |
|
| 98 | 98 | } elseif (in_array($filterValue, explode('|', $kFields[1]))) { |
| 99 | 99 | return $filterValue; |
| 100 | 100 | } elseif (in_array($filterValue, explode('|', $kFields[2]))) { |
| 101 | - return 'IS ' . $filterValue; |
|
| 101 | + return 'IS '.$filterValue; |
|
| 102 | 102 | } |
| 103 | - return '= "' . $filterValue . '"'; |
|
| 103 | + return '= "'.$filterValue.'"'; |
|
| 104 | 104 | } |
| 105 | 105 | |
| 106 | 106 | /** |
@@ -111,7 +111,7 @@ discard block |
||
| 111 | 111 | */ |
| 112 | 112 | private function sGlueFiltersIntoWhereArrayFilter($filters) |
| 113 | 113 | { |
| 114 | - return '(' . implode(') AND (', $filters) . ')'; |
|
| 114 | + return '('.implode(') AND (', $filters).')'; |
|
| 115 | 115 | } |
| 116 | 116 | |
| 117 | 117 | /** |
@@ -129,7 +129,7 @@ discard block |
||
| 129 | 129 | $fltr = []; |
| 130 | 130 | unset($filterArray['LIMIT']); |
| 131 | 131 | foreach ($filterArray as $key => $value) { |
| 132 | - $fltr[] = '`' . $tableToApplyFilterTo . '`.`' . $key . '` ' . $this->sGlueFilterValIntoWhereStr($value); |
|
| 132 | + $fltr[] = '`'.$tableToApplyFilterTo.'`.`'.$key.'` '.$this->sGlueFilterValIntoWhereStr($value); |
|
| 133 | 133 | } |
| 134 | 134 | return $this->sManageDynamicFiltersFinal($fltr); |
| 135 | 135 | } |
@@ -138,7 +138,7 @@ discard block |
||
| 138 | 138 | { |
| 139 | 139 | if (count($filters) > 0) { |
| 140 | 140 | $sReturn = ['WHERE', $this->sGlueFiltersIntoWhereArrayFilter($filters)]; |
| 141 | - return implode(' ', $sReturn) . ' '; |
|
| 141 | + return implode(' ', $sReturn).' '; |
|
| 142 | 142 | } |
| 143 | 143 | return ''; |
| 144 | 144 | } |
@@ -159,13 +159,13 @@ discard block |
||
| 159 | 159 | $filterArray = (is_array($filterArray) ? $filterArray : ['' => '']); |
| 160 | 160 | return 'SELECT ' |
| 161 | 161 | . '`C`.`TABLE_SCHEMA`, ' |
| 162 | - . $this->sQueryMySqlColumnsColumns() . ' ' |
|
| 162 | + . $this->sQueryMySqlColumnsColumns().' ' |
|
| 163 | 163 | . 'FROM `information_schema`.`COLUMNS` `C` ' |
| 164 | - . 'LEFT JOIN `information_schema`.`KEY_COLUMN_USAGE` `KCU` ON ((' . implode(') AND (', [ |
|
| 164 | + . 'LEFT JOIN `information_schema`.`KEY_COLUMN_USAGE` `KCU` ON (('.implode(') AND (', [ |
|
| 165 | 165 | '`C`.`TABLE_SCHEMA` = `KCU`.`TABLE_SCHEMA`', |
| 166 | 166 | '`C`.`TABLE_NAME` = `KCU`.`TABLE_NAME`', |
| 167 | 167 | '`C`.`COLUMN_NAME` = `KCU`.`COLUMN_NAME`', |
| 168 | - ]) . ')) ' |
|
| 168 | + ]).')) ' |
|
| 169 | 169 | . $this->sManageDynamicFilters($filterArray, 'C') |
| 170 | 170 | . 'GROUP BY `C`.`TABLE_SCHEMA`, `C`.`TABLE_NAME`, `C`.`COLUMN_NAME` ' |
| 171 | 171 | . 'ORDER BY `C`.`TABLE_SCHEMA`, `C`.`TABLE_NAME`, `C`.`ORDINAL_POSITION` ' |
@@ -192,20 +192,20 @@ discard block |
||
| 192 | 192 | { |
| 193 | 193 | return 'SELECT ' |
| 194 | 194 | . '`KCU`.`CONSTRAINT_SCHEMA`, ' |
| 195 | - . $this->sQueryMySqlIndexesColumns() . ' ' |
|
| 195 | + . $this->sQueryMySqlIndexesColumns().' ' |
|
| 196 | 196 | . 'FROM `information_schema`.`KEY_COLUMN_USAGE` `KCU` ' |
| 197 | - . 'INNER JOIN `information_schema`.`COLUMNS` `C` ON ((' . implode(') AND (', [ |
|
| 197 | + . 'INNER JOIN `information_schema`.`COLUMNS` `C` ON (('.implode(') AND (', [ |
|
| 198 | 198 | '`C`.`TABLE_SCHEMA` = `KCU`.`TABLE_SCHEMA`', |
| 199 | 199 | '`C`.`TABLE_NAME` = `KCU`.`TABLE_NAME`', |
| 200 | 200 | '`C`.`COLUMN_NAME` = `KCU`.`COLUMN_NAME`', |
| 201 | - ]) . ')) ' |
|
| 202 | - . 'LEFT JOIN `information_schema`.`REFERENTIAL_CONSTRAINTS` `RC` ON ((' . implode(') AND (', [ |
|
| 201 | + ]).')) ' |
|
| 202 | + . 'LEFT JOIN `information_schema`.`REFERENTIAL_CONSTRAINTS` `RC` ON (('.implode(') AND (', [ |
|
| 203 | 203 | '`KCU`.`CONSTRAINT_SCHEMA` = `RC`.`CONSTRAINT_SCHEMA`', |
| 204 | 204 | '`KCU`.`CONSTRAINT_NAME` = `RC`.`CONSTRAINT_NAME`', |
| 205 | - ]) . ')) ' |
|
| 205 | + ]).')) ' |
|
| 206 | 206 | . $this->sManageDynamicFilters($filterArray, 'KCU') |
| 207 | 207 | . 'ORDER BY `KCU`.`TABLE_SCHEMA`, `KCU`.`TABLE_NAME`' |
| 208 | - . $this->xtraSoring($filterArray, 'COLUMN_NAME') . ';'; |
|
| 208 | + . $this->xtraSoring($filterArray, 'COLUMN_NAME').';'; |
|
| 209 | 209 | } |
| 210 | 210 | |
| 211 | 211 | private function sQueryMySqlIndexesColumns() |
@@ -221,23 +221,23 @@ discard block |
||
| 221 | 221 | { |
| 222 | 222 | $tblAls = substr($tblName, 0, 1); |
| 223 | 223 | $colName = (is_null($adtnlCol) ? $tblName : $adtnlFltr); |
| 224 | - return '(SELECT COUNT(*) AS `No. of records` FROM `information_schema`.`' . $tblName . '` `' . $tblAls . '` ' |
|
| 225 | - . 'WHERE (`' . $tblAls . '`.`' . $lnkDbCol . '` = `S`.`SCHEMA_NAME`)' |
|
| 226 | - . (!is_null($adtnlCol) ? ' AND (`' . $tblAls . '`.`' . $adtnlCol . '` = "' . $adtnlFltr . '")' : '') |
|
| 227 | - . ') AS `' . ucwords(strtolower($colName)) . '`'; |
|
| 224 | + return '(SELECT COUNT(*) AS `No. of records` FROM `information_schema`.`'.$tblName.'` `'.$tblAls.'` ' |
|
| 225 | + . 'WHERE (`'.$tblAls.'`.`'.$lnkDbCol.'` = `S`.`SCHEMA_NAME`)' |
|
| 226 | + . (!is_null($adtnlCol) ? ' AND (`'.$tblAls.'`.`'.$adtnlCol.'` = "'.$adtnlFltr.'")' : '') |
|
| 227 | + . ') AS `'.ucwords(strtolower($colName)).'`'; |
|
| 228 | 228 | } |
| 229 | 229 | |
| 230 | 230 | protected function sQueryMySqlStatistics($filterArray = null) |
| 231 | 231 | { |
| 232 | 232 | return 'SELECT ' |
| 233 | 233 | . '`S`.`SCHEMA_NAME`, ' |
| 234 | - . $this->sQueryMySqlStatisticPattern('TABLES', 'TABLE_SCHEMA', 'TABLE_TYPE', 'BASE TABLE') . ', ' |
|
| 235 | - . $this->sQueryMySqlStatisticPattern('TABLES', 'TABLE_SCHEMA', 'TABLE_TYPE', 'VIEW') . ', ' |
|
| 236 | - . $this->sQueryMySqlStatisticPattern('COLUMNS', 'TABLE_SCHEMA') . ', ' |
|
| 237 | - . $this->sQueryMySqlStatisticPattern('TRIGGERS', 'EVENT_OBJECT_SCHEMA') . ', ' |
|
| 238 | - . $this->sQueryMySqlStatisticPattern('ROUTINES', 'ROUTINE_SCHEMA', 'ROUTINE_TYPE', 'Function') . ', ' |
|
| 239 | - . $this->sQueryMySqlStatisticPattern('ROUTINES', 'ROUTINE_SCHEMA', 'ROUTINE_TYPE', 'Procedure') . ', ' |
|
| 240 | - . $this->sQueryMySqlStatisticPattern('EVENTS', 'EVENT_SCHEMA') . ' ' |
|
| 234 | + . $this->sQueryMySqlStatisticPattern('TABLES', 'TABLE_SCHEMA', 'TABLE_TYPE', 'BASE TABLE').', ' |
|
| 235 | + . $this->sQueryMySqlStatisticPattern('TABLES', 'TABLE_SCHEMA', 'TABLE_TYPE', 'VIEW').', ' |
|
| 236 | + . $this->sQueryMySqlStatisticPattern('COLUMNS', 'TABLE_SCHEMA').', ' |
|
| 237 | + . $this->sQueryMySqlStatisticPattern('TRIGGERS', 'EVENT_OBJECT_SCHEMA').', ' |
|
| 238 | + . $this->sQueryMySqlStatisticPattern('ROUTINES', 'ROUTINE_SCHEMA', 'ROUTINE_TYPE', 'Function').', ' |
|
| 239 | + . $this->sQueryMySqlStatisticPattern('ROUTINES', 'ROUTINE_SCHEMA', 'ROUTINE_TYPE', 'Procedure').', ' |
|
| 240 | + . $this->sQueryMySqlStatisticPattern('EVENTS', 'EVENT_SCHEMA').' ' |
|
| 241 | 241 | . 'FROM `information_schema`.`SCHEMATA` `S` ' |
| 242 | 242 | . 'WHERE (`S`.`SCHEMA_NAME` NOT IN ("information_schema", "mysql", "performance_schema", "sys")) ' |
| 243 | 243 | . str_replace('WHERE', 'AND', $this->sManageDynamicFilters($filterArray, 'S')) |
@@ -258,7 +258,7 @@ discard block |
||
| 258 | 258 | . ', `T`.`CREATE_OPTIONS`, `T`.`TABLE_COMMENT` ' |
| 259 | 259 | . 'FROM `information_schema`.`TABLES` `T` ' |
| 260 | 260 | . $this->sManageDynamicFilters($filterArray, 'T') |
| 261 | - . $this->xtraSoring($filterArray, 'TABLE_SCHEMA') . ';'; |
|
| 261 | + . $this->xtraSoring($filterArray, 'TABLE_SCHEMA').';'; |
|
| 262 | 262 | } |
| 263 | 263 | |
| 264 | 264 | /** |
@@ -273,8 +273,8 @@ discard block |
||
| 273 | 273 | { |
| 274 | 274 | $filters2 = implode(', ', array_diff($value, [''])); |
| 275 | 275 | if ($filters2 != '') { |
| 276 | - return '(' . $referenceTable . '`' . $key . '` IN ("' |
|
| 277 | - . str_replace(',', '","', str_replace(["'", '"'], '', $filters2)) . '"))'; |
|
| 276 | + return '('.$referenceTable.'`'.$key.'` IN ("' |
|
| 277 | + . str_replace(',', '","', str_replace(["'", '"'], '', $filters2)).'"))'; |
|
| 278 | 278 | } |
| 279 | 279 | return ''; |
| 280 | 280 | } |
@@ -292,7 +292,7 @@ discard block |
||
| 292 | 292 | if ((substr($value, 0, 1) == '%') && (substr($value, -1) == '%')) { |
| 293 | 293 | $fTemp = 'LIKE'; |
| 294 | 294 | } |
| 295 | - return '(`' . $key . '` ' . $fTemp . '"' . $value . '")'; |
|
| 295 | + return '(`'.$key.'` '.$fTemp.'"'.$value.'")'; |
|
| 296 | 296 | } |
| 297 | 297 | |
| 298 | 298 | private function xtraSoring($filterArray, $filterValueToDecide) |
@@ -66,7 +66,7 @@ discard block |
||
| 66 | 66 | */ |
| 67 | 67 | protected function getFieldNameForDisplay($details) |
| 68 | 68 | { |
| 69 | - $tableUniqueId = $details['TABLE_SCHEMA'] . '.' . $details['TABLE_NAME']; |
|
| 69 | + $tableUniqueId = $details['TABLE_SCHEMA'].'.'.$details['TABLE_NAME']; |
|
| 70 | 70 | if ($details['COLUMN_COMMENT'] != '') { |
| 71 | 71 | return $details['COLUMN_COMMENT']; |
| 72 | 72 | } elseif (isset($this->advCache['tableStructureLocales'][$tableUniqueId][$details['COLUMN_NAME']])) { |
@@ -85,8 +85,8 @@ discard block |
||
| 85 | 85 | */ |
| 86 | 86 | protected function getFieldOutputTextFK($foreignKeysArray, $value, $iar) |
| 87 | 87 | { |
| 88 | - $query = $this->sQueryGenericSelectKeyValue([ |
|
| 89 | - '`' . $value['COLUMN_NAME'] . '`', |
|
| 88 | + $query = $this->sQueryGenericSelectKeyValue([ |
|
| 89 | + '`'.$value['COLUMN_NAME'].'`', |
|
| 90 | 90 | $foreignKeysArray[$value['COLUMN_NAME']][2], |
| 91 | 91 | $foreignKeysArray[$value['COLUMN_NAME']][0] |
| 92 | 92 | ]); |
@@ -57,7 +57,7 @@ discard block |
||
| 57 | 57 | return $this->setArrayToJson($aReturn); |
| 58 | 58 | } |
| 59 | 59 | $aReturn = $this->getContentFromUrlThroughCurlRawArray($fullURL, $features); |
| 60 | - return '{ ' . $this->packIntoJson($aReturn, 'info') . ', ' . $this->packIntoJson($aReturn, 'response') . ' }'; |
|
| 60 | + return '{ '.$this->packIntoJson($aReturn, 'info').', '.$this->packIntoJson($aReturn, 'response').' }'; |
|
| 61 | 61 | } |
| 62 | 62 | |
| 63 | 63 | /** |
@@ -117,7 +117,7 @@ discard block |
||
| 117 | 117 | return '<div>No MySQL connection detected</div>'; |
| 118 | 118 | } |
| 119 | 119 | $afRows = $this->mySQLconnection->affected_rows; |
| 120 | - return '<div>' . sprintf($this->lclMsgCmnNumber('i18n_Record', 'i18n_Records', $afRows), $afRows) . '</div>'; |
|
| 120 | + return '<div>'.sprintf($this->lclMsgCmnNumber('i18n_Record', 'i18n_Records', $afRows), $afRows).'</div>'; |
|
| 121 | 121 | } |
| 122 | 122 | |
| 123 | 123 | /** |
@@ -189,9 +189,9 @@ discard block |
||
| 189 | 189 | private function packIntoJson($aReturn, $keyToWorkWith) |
| 190 | 190 | { |
| 191 | 191 | if ($this->isJsonByDanielGP($aReturn[$keyToWorkWith])) { |
| 192 | - return '"' . $keyToWorkWith . '": ' . $aReturn[$keyToWorkWith]; |
|
| 192 | + return '"'.$keyToWorkWith.'": '.$aReturn[$keyToWorkWith]; |
|
| 193 | 193 | } |
| 194 | - return '"' . $keyToWorkWith . '": {' . $aReturn[$keyToWorkWith] . ' }'; |
|
| 194 | + return '"'.$keyToWorkWith.'": {'.$aReturn[$keyToWorkWith].' }'; |
|
| 195 | 195 | } |
| 196 | 196 | |
| 197 | 197 | /** |
@@ -205,7 +205,7 @@ discard block |
||
| 205 | 205 | { |
| 206 | 206 | $postingUrl = filter_var($urlToSendTo, FILTER_VALIDATE_URL); |
| 207 | 207 | if ($postingUrl === false) { |
| 208 | - throw new \Exception('Invalid URL in ' . __FUNCTION__); |
|
| 208 | + throw new \Exception('Invalid URL in '.__FUNCTION__); |
|
| 209 | 209 | } |
| 210 | 210 | if ($params !== []) { |
| 211 | 211 | $cntFailErrMsg = $this->lclMsgCmn('i18n_Error_FailedToConnect'); |
@@ -225,7 +225,7 @@ discard block |
||
| 225 | 225 | } |
| 226 | 226 | $flPointer = fsockopen($pUrlParts['host'], $postingPort, $erN, $erM, 30); |
| 227 | 227 | if ($flPointer === false) { |
| 228 | - throw new \Exception($cntFailErrMsg . ': ' . $erN . ' (' . $erM . ')'); |
|
| 228 | + throw new \Exception($cntFailErrMsg.': '.$erN.' ('.$erM.')'); |
|
| 229 | 229 | } |
| 230 | 230 | fwrite($flPointer, $this->sendBackgroundPrepareData($pUrlParts, $postingString)); |
| 231 | 231 | fclose($flPointer); |
@@ -235,12 +235,12 @@ discard block |
||
| 235 | 235 | { |
| 236 | 236 | $this->initializeSprGlbAndSession(); |
| 237 | 237 | $out = []; |
| 238 | - $out[] = 'POST ' . $pUrlParts['path'] . ' ' . $this->tCmnSuperGlobals->server->get['SERVER_PROTOCOL']; |
|
| 239 | - $out[] = 'Host: ' . $pUrlParts['host']; |
|
| 240 | - $out[] = 'User-Agent: ' . $this->getUserAgentByCommonLib(); |
|
| 238 | + $out[] = 'POST '.$pUrlParts['path'].' '.$this->tCmnSuperGlobals->server->get['SERVER_PROTOCOL']; |
|
| 239 | + $out[] = 'Host: '.$pUrlParts['host']; |
|
| 240 | + $out[] = 'User-Agent: '.$this->getUserAgentByCommonLib(); |
|
| 241 | 241 | $out[] = 'Content-Type: application/x-www-form-urlencoded'; |
| 242 | - $out[] = 'Content-Length: ' . strlen($postingString); |
|
| 243 | - $out[] = 'Connection: Close' . "\r\n"; |
|
| 242 | + $out[] = 'Content-Length: '.strlen($postingString); |
|
| 243 | + $out[] = 'Connection: Close'."\r\n"; |
|
| 244 | 244 | $out[] = $postingString; |
| 245 | 245 | return implode("\r\n", $out); |
| 246 | 246 | } |
@@ -81,7 +81,7 @@ discard block |
||
| 81 | 81 | if ($iar !== []) { |
| 82 | 82 | $inAdtnl = array_merge($inAdtnl, $iar); |
| 83 | 83 | } |
| 84 | - return '<b>' . $this->getFieldValue($value) . '</b>' . $this->setStringIntoShortTag('input', $inAdtnl); |
|
| 84 | + return '<b>'.$this->getFieldValue($value).'</b>'.$this->setStringIntoShortTag('input', $inAdtnl); |
|
| 85 | 85 | } |
| 86 | 86 | |
| 87 | 87 | /** |
@@ -94,8 +94,8 @@ discard block |
||
| 94 | 94 | */ |
| 95 | 95 | private function getFieldOutputNumericNonFK($fkArray, $value, $iar = []) |
| 96 | 96 | { |
| 97 | - $query = $this->sQueryGenericSelectKeyValue([ |
|
| 98 | - '`' . $value['COLUMN_NAME'] . '`', |
|
| 97 | + $query = $this->sQueryGenericSelectKeyValue([ |
|
| 98 | + '`'.$value['COLUMN_NAME'].'`', |
|
| 99 | 99 | $fkArray[$value['COLUMN_NAME']][2], |
| 100 | 100 | $fkArray[$value['COLUMN_NAME']][0], |
| 101 | 101 | ]); |
@@ -151,7 +151,7 @@ discard block |
||
| 151 | 151 | if ($val[$cnm[0]] == $oCol) { |
| 152 | 152 | $vlQ = array_merge($val, ['LIMIT' => 2]); |
| 153 | 153 | $tFd = $this->setMySQLquery2Server($this->getForeignKeysQuery($vlQ), $cnm[1])['result']; |
| 154 | - $tgtFld = '`' . ($tFd[0][$cnm[0]] == $val[$cnm[0]] ? $tFd[1][$cnm[0]] : $tFd[0][$cnm[0]]) . '`'; |
|
| 154 | + $tgtFld = '`'.($tFd[0][$cnm[0]] == $val[$cnm[0]] ? $tFd[1][$cnm[0]] : $tFd[0][$cnm[0]]).'`'; |
|
| 155 | 155 | $aRt[$oCol] = [$this->glueDbTb($val[$cnm[2]], $val[$cnm[3]]), $val[$cnm[2]], $tgtFld]; |
| 156 | 156 | } |
| 157 | 157 | } |
@@ -59,7 +59,7 @@ discard block |
||
| 59 | 59 | } |
| 60 | 60 | $vlSlct = explode(',', $this->getFieldValue($val)); |
| 61 | 61 | $slctOptns = $this->getSetOrEnum2Array($tblSrc, $val['COLUMN_NAME']); |
| 62 | - return $this->setArrayToSelect($slctOptns, $vlSlct, $val['COLUMN_NAME'] . $adnlThings['suffix'], $inAdtnl); |
|
| 62 | + return $this->setArrayToSelect($slctOptns, $vlSlct, $val['COLUMN_NAME'].$adnlThings['suffix'], $inAdtnl); |
|
| 63 | 63 | } |
| 64 | 64 | |
| 65 | 65 | /** |
@@ -190,7 +190,7 @@ discard block |
||
| 190 | 190 | $inM = $this->setStringIntoTag($mCN[$dtl['COLUMN_NAME']], 'span', ['style' => 'font-style:italic;']); |
| 191 | 191 | } |
| 192 | 192 | } |
| 193 | - $lbl = '<span class="fake_label">' . $this->getFieldNameForDisplay($dtl) . '</span>'; |
|
| 193 | + $lbl = '<span class="fake_label">'.$this->getFieldNameForDisplay($dtl).'</span>'; |
|
| 194 | 194 | return ['label' => $lbl, 'input' => $inM]; |
| 195 | 195 | } |
| 196 | 196 | |
@@ -206,7 +206,7 @@ discard block |
||
| 206 | 206 | } elseif (in_array($dtls['DATA_TYPE'], ['date', 'datetime', 'time', 'timestamp', 'year'])) { |
| 207 | 207 | $sReturn = $this->setNeededFieldSingleType($tblName, $dtls, $iar); |
| 208 | 208 | } |
| 209 | - return $this->getFieldCompletionType($dtls) . $sReturn; |
|
| 209 | + return $this->getFieldCompletionType($dtls).$sReturn; |
|
| 210 | 210 | } |
| 211 | 211 | |
| 212 | 212 | private function setNeededFieldSingleType($tblName, $dtls, $iar) |
@@ -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(); |
@@ -85,7 +85,7 @@ discard block |
||
| 85 | 85 | 'class' => 'input_readonly', |
| 86 | 86 | 'value' => $sDefaultValue, |
| 87 | 87 | ]; |
| 88 | - return $this->setStringIntoShortTag('input', $inputFeatures) . $aElements[$sDefaultValue]; |
|
| 88 | + return $this->setStringIntoShortTag('input', $inputFeatures).$aElements[$sDefaultValue]; |
|
| 89 | 89 | } |
| 90 | 90 | return $this->setArrayToSelectNotReadOnly($aElements, $sDefaultValue, $selectName, $featArray); |
| 91 | 91 | } |
@@ -122,21 +122,21 @@ discard block |
||
| 122 | 122 | $sReturn = null; |
| 123 | 123 | $iRecPrPg = min($inRecPrPg, $iAllRec); |
| 124 | 124 | $iStartingPageRecord = $this->setStartingPageRecord($iCrtPgNo, $iRecPrPg, $iAllRec, $bKpFlPg); |
| 125 | - $sReturn .= '<span style="float:left;font-size:smaller;margin-top:1px; margin-right:1px;">' |
|
| 125 | + $sReturn .= '<span style="float:left;font-size:smaller;margin-top:1px; margin-right:1px;">' |
|
| 126 | 126 | . $this->setStringIntoTag($iAllRec, 'b') |
| 127 | 127 | . $this->lclMsgCmn('i18n_RecordsAvailableNowDisplaying') |
| 128 | 128 | . $this->setStringIntoTag(($iStartingPageRecord + 1), 'b') |
| 129 | - . ' - ' . $this->setStringIntoTag(min($iAllRec, ($iStartingPageRecord + $iRecPrPg)), 'b') |
|
| 129 | + . ' - '.$this->setStringIntoTag(min($iAllRec, ($iStartingPageRecord + $iRecPrPg)), 'b') |
|
| 130 | 130 | . ' </span>'; |
| 131 | 131 | switch ($iCrtPgNo) { |
| 132 | 132 | case 'first': |
| 133 | - $iCrtPgNo = ceil(($iStartingPageRecord + 1 ) / $iRecPrPg); |
|
| 133 | + $iCrtPgNo = ceil(($iStartingPageRecord + 1) / $iRecPrPg); |
|
| 134 | 134 | break; |
| 135 | 135 | case 'last': |
| 136 | 136 | $iCrtPgNo = ceil($iAllRec / $iRecPrPg); |
| 137 | 137 | break; |
| 138 | 138 | } |
| 139 | - $sReturn .= '<span style="float:right;font-size:smaller;margin-top:1px; margin-right:1px;">'; |
|
| 139 | + $sReturn .= '<span style="float:right;font-size:smaller;margin-top:1px; margin-right:1px;">'; |
|
| 140 | 140 | $iNumberOfPages = ceil($iAllRec / $iRecPrPg); |
| 141 | 141 | $sAdditionalArguments = ''; |
| 142 | 142 | if (isset($_GET)) { |
@@ -150,7 +150,7 @@ discard block |
||
| 150 | 150 | } |
| 151 | 151 | if ($iCrtPgNo != 1) { |
| 152 | 152 | $sReturn .= $this->setStringIntoTag($this->lclMsgCmn('i18n_Previous'), 'a', [ |
| 153 | - 'href' => ('?page=' . ($iCrtPgNo - 1 ) . $sAdditionalArguments ), |
|
| 153 | + 'href' => ('?page='.($iCrtPgNo - 1).$sAdditionalArguments), |
|
| 154 | 154 | 'class' => 'pagination' |
| 155 | 155 | ]); |
| 156 | 156 | } else { |
@@ -163,7 +163,7 @@ discard block |
||
| 163 | 163 | $pages2display[$counter] = $counter; |
| 164 | 164 | } |
| 165 | 165 | $sReturn .= '<span class="pagination"><form method="get" action="' |
| 166 | - . $this->tCmnSuperGlobals->getScriptName() . '">'; |
|
| 166 | + . $this->tCmnSuperGlobals->getScriptName().'">'; |
|
| 167 | 167 | $sReturn .= $this->setArrayToSelect($pages2display, $this->tCmnSuperGlobals->get('page'), 'page', [ |
| 168 | 168 | 'size' => 1, |
| 169 | 169 | 'autosubmit', |
@@ -176,7 +176,7 @@ discard block |
||
| 176 | 176 | foreach ($value as $value2) { |
| 177 | 177 | $sReturn .= $this->setStringIntoShortTag('input', [ |
| 178 | 178 | 'type' => 'hidden', |
| 179 | - 'name' => $key . '[]', |
|
| 179 | + 'name' => $key.'[]', |
|
| 180 | 180 | 'value' => $value2, |
| 181 | 181 | ]); |
| 182 | 182 | } |
@@ -193,7 +193,7 @@ discard block |
||
| 193 | 193 | $sReturn .= '</form></span>'; |
| 194 | 194 | if ($iCrtPgNo != $iNumberOfPages) { |
| 195 | 195 | $sReturn .= $this->setStringIntoTag($this->lclMsgCmn('i18n_Next'), 'a', [ |
| 196 | - 'href' => ('?page=' . ($iCrtPgNo + 1 ) . $sAdditionalArguments ), |
|
| 196 | + 'href' => ('?page='.($iCrtPgNo + 1).$sAdditionalArguments), |
|
| 197 | 197 | 'class' => 'pagination', |
| 198 | 198 | ]); |
| 199 | 199 | } else { |
@@ -228,9 +228,9 @@ discard block |
||
| 228 | 228 | break; |
| 229 | 229 | } |
| 230 | 230 | } else { |
| 231 | - $iStartingPageRecord = ($this->tCmnSuperGlobals->get('page') - 1 ) * $iRecordsPerPage; |
|
| 231 | + $iStartingPageRecord = ($this->tCmnSuperGlobals->get('page') - 1) * $iRecordsPerPage; |
|
| 232 | 232 | } |
| 233 | - if (($bKeepFullPage ) && (($iStartingPageRecord + $iRecordsPerPage ) > $iAllRecords)) { |
|
| 233 | + if (($bKeepFullPage) && (($iStartingPageRecord + $iRecordsPerPage) > $iAllRecords)) { |
|
| 234 | 234 | $iStartingPageRecord = $iAllRecords - $iRecordsPerPage; |
| 235 | 235 | } |
| 236 | 236 | return max(0, $iStartingPageRecord); |
@@ -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,11 +183,11 @@ discard block |
||
| 183 | 183 | $hostsWithoutCDNrq = []; |
| 184 | 184 | } |
| 185 | 185 | if (in_array($this->getClientRealIpAddress(), $hostsWithoutCDNrq)) { |
| 186 | - return '<script type="text/javascript" src="' . filter_var($jsFileName, FILTER_SANITIZE_STRING) |
|
| 186 | + return '<script type="text/javascript" src="'.filter_var($jsFileName, FILTER_SANITIZE_STRING) |
|
| 187 | 187 | . '"></script>'; |
| 188 | 188 | } |
| 189 | 189 | $patternFound = $this->setJavascriptFileCDN($jsFileName); |
| 190 | - return '<script type="text/javascript" src="' . $patternFound[1] . '"></script>' . $patternFound[2]; |
|
| 190 | + return '<script type="text/javascript" src="'.$patternFound[1].'"></script>'.$patternFound[2]; |
|
| 191 | 191 | } |
| 192 | 192 | |
| 193 | 193 | /** |
@@ -198,14 +198,14 @@ discard block |
||
| 198 | 198 | */ |
| 199 | 199 | protected function setJavascriptFileContent($jsFileName) |
| 200 | 200 | { |
| 201 | - return '<script type="text/javascript">' . file_get_contents($jsFileName, true) . '</script>'; |
|
| 201 | + return '<script type="text/javascript">'.file_get_contents($jsFileName, true).'</script>'; |
|
| 202 | 202 | } |
| 203 | 203 | |
| 204 | 204 | protected function updateDivTitleName($rememberGroupVal, $groupCounter) |
| 205 | 205 | { |
| 206 | 206 | $jsContent = '$(document).ready(function() { $("#tab_' |
| 207 | - . $this->cleanStringForId($rememberGroupVal) . '").attr("title", "' |
|
| 208 | - . $rememberGroupVal . ' (' . $groupCounter . ')"); });'; |
|
| 207 | + . $this->cleanStringForId($rememberGroupVal).'").attr("title", "' |
|
| 208 | + . $rememberGroupVal.' ('.$groupCounter.')"); });'; |
|
| 209 | 209 | return $this->setJavascriptContent($jsContent); |
| 210 | 210 | } |
| 211 | 211 | } |
@@ -62,13 +62,13 @@ discard block |
||
| 62 | 62 | $ditTitle .= ' (0)'; |
| 63 | 63 | } |
| 64 | 64 | $divTab = [ |
| 65 | - 'start' => '<div class="tabbertab tabbertabdefault" id="tab_NoData" title="' . $ditTitle . '">', |
|
| 65 | + 'start' => '<div class="tabbertab tabbertabdefault" id="tab_NoData" title="'.$ditTitle.'">', |
|
| 66 | 66 | 'end' => '</div><!-- from tab_NoData -->', |
| 67 | 67 | ]; |
| 68 | 68 | if (!isset($ftrs['noGlobalTab'])) { |
| 69 | 69 | $divTab = [ |
| 70 | - 'start' => '<div class="tabber" id="tab">' . $divTab['start'], |
|
| 71 | - 'end' => $divTab['end'] . '</div><!-- from global Tab -->', |
|
| 70 | + 'start' => '<div class="tabber" id="tab">'.$divTab['start'], |
|
| 71 | + 'end' => $divTab['end'].'</div><!-- from global Tab -->', |
|
| 72 | 72 | ]; |
| 73 | 73 | } |
| 74 | 74 | } |
@@ -91,14 +91,14 @@ discard block |
||
| 91 | 91 | } |
| 92 | 92 | $checkboxFormId = ''; |
| 93 | 93 | if ((isset($ftrs['actions']['checkbox_inlineEdit'])) || (isset($ftrs['actions']['checkbox']))) { |
| 94 | - $checkboxFormId = 'frm' . date('YmdHis'); |
|
| 95 | - $sReturn .= '<form id="' . $checkboxFormId . '" name="' . $checkboxFormId |
|
| 96 | - . '" method="post" ' . ' action="' . $this->tCmnRequest->server->get('PHP_SELF') . '" >'; |
|
| 94 | + $checkboxFormId = 'frm'.date('YmdHis'); |
|
| 95 | + $sReturn .= '<form id="'.$checkboxFormId.'" name="'.$checkboxFormId |
|
| 96 | + . '" method="post" '.' action="'.$this->tCmnRequest->server->get('PHP_SELF').'" >'; |
|
| 97 | 97 | } |
| 98 | 98 | $tbl = []; |
| 99 | 99 | $tbl['Def'] = '<table' |
| 100 | - . (isset($ftrs['table_style']) ? ' style="' . $ftrs['table_style'] . '"' : '') |
|
| 101 | - . (isset($ftrs['table_class']) ? ' class="' . $ftrs['table_class'] . '"' : '') |
|
| 100 | + . (isset($ftrs['table_style']) ? ' style="'.$ftrs['table_style'].'"' : '') |
|
| 101 | + . (isset($ftrs['table_class']) ? ' class="'.$ftrs['table_class'].'"' : '') |
|
| 102 | 102 | . '>'; |
| 103 | 103 | if (!isset($ftrs['grouping_cell_type'])) { |
| 104 | 104 | $ftrs['grouping_cell_type'] = 'row'; |
@@ -139,7 +139,7 @@ discard block |
||
| 139 | 139 | $sReturn .= $tbl['Head']; |
| 140 | 140 | } |
| 141 | 141 | if (isset($iStartingPageRecord)) { |
| 142 | - $pgn = '' |
|
| 142 | + $pgn = '' |
|
| 143 | 143 | . $this->setPagination($ftrs['limits'][0], $ftrs['limits'][1], $ftrs['limits'][2], $bKpFlPge); |
| 144 | 144 | $sReturn .= $this->setStringIntoTag($this->setStringIntoTag($pgn, 'th', [ |
| 145 | 145 | 'colspan' => $iTableColumns |
@@ -182,22 +182,22 @@ discard block |
||
| 182 | 182 | } |
| 183 | 183 | $remebered_value = $color_column_value; |
| 184 | 184 | } |
| 185 | - $color = ' style="background-color: ' . $ftrs['row_colored_alternated'][$color_no] . ';"'; |
|
| 185 | + $color = ' style="background-color: '.$ftrs['row_colored_alternated'][$color_no].';"'; |
|
| 186 | 186 | } else { |
| 187 | 187 | if (isset($ftrs['RowStyle'])) { |
| 188 | - $color = ' style="' . $aElements[$rCntr][$ftrs['RowStyle']] . '"'; |
|
| 188 | + $color = ' style="'.$aElements[$rCntr][$ftrs['RowStyle']].'"'; |
|
| 189 | 189 | } else { |
| 190 | 190 | $color = ''; |
| 191 | 191 | } |
| 192 | 192 | } |
| 193 | - $tbl['tr_Color'] = '<tr' . $color . '>'; |
|
| 193 | + $tbl['tr_Color'] = '<tr'.$color.'>'; |
|
| 194 | 194 | // Grouping column |
| 195 | 195 | if (isset($ftrs['grouping_cell'])) { |
| 196 | 196 | foreach ($aElements[$rCntr] as $key => $value) { |
| 197 | 197 | if (($ftrs['grouping_cell'] == $key) && ($remindGroupValue != $value)) { |
| 198 | 198 | switch ($ftrs['grouping_cell_type']) { |
| 199 | 199 | case 'row': |
| 200 | - $sReturn .= $tbl['tr_Color'] . '<td ' . 'colspan="' . $iTableColumns . '">' |
|
| 200 | + $sReturn .= $tbl['tr_Color'].'<td '.'colspan="'.$iTableColumns.'">' |
|
| 201 | 201 | . $this->setStringIntoTag($value, 'div', ['class' => 'rowGroup rounded']) |
| 202 | 202 | . '</td></tr>'; |
| 203 | 203 | break; |
@@ -209,7 +209,7 @@ discard block |
||
| 209 | 209 | } else { |
| 210 | 210 | $sReturn .= '</tbody></table>'; |
| 211 | 211 | if (isset($ftrs['showGroupingCounter'])) { |
| 212 | - $sReturn .= $this->updateDivTitleName($remindGroupValue, $groupCounter); |
|
| 212 | + $sReturn .= $this->updateDivTitleName($remindGroupValue, $groupCounter); |
|
| 213 | 213 | $groupCounter = 0; |
| 214 | 214 | } |
| 215 | 215 | $sReturn .= '</div>'; |
@@ -218,9 +218,9 @@ discard block |
||
| 218 | 218 | if (isset($ftrs['grouping_default_tab'])) { |
| 219 | 219 | $sReturn .= ($ftrs['grouping_default_tab'] == $value ? ' tabbertabdefault' : ''); |
| 220 | 220 | } |
| 221 | - $sReturn .= '" id="tab_' . $this->cleanStringForId($value) . '" ' |
|
| 222 | - . 'title="' . $value . '">' |
|
| 223 | - . $tbl['Def'] . $tbl['Head'] . $tbl['Header']; |
|
| 221 | + $sReturn .= '" id="tab_'.$this->cleanStringForId($value).'" ' |
|
| 222 | + . 'title="'.$value.'">' |
|
| 223 | + . $tbl['Def'].$tbl['Head'].$tbl['Header']; |
|
| 224 | 224 | break; |
| 225 | 225 | } |
| 226 | 226 | $remindGroupValue = $value; |
@@ -234,12 +234,12 @@ discard block |
||
| 234 | 234 | } |
| 235 | 235 | } |
| 236 | 236 | } |
| 237 | - $sReturn .= $tbl['tr_Color']; |
|
| 237 | + $sReturn .= $tbl['tr_Color']; |
|
| 238 | 238 | // Action column |
| 239 | 239 | $checkboxName = ''; |
| 240 | 240 | $checkboxNameS = ''; |
| 241 | 241 | if (isset($ftrs['actions'])) { |
| 242 | - $sReturn .= '<td style="white-space:nowrap;">'; |
|
| 242 | + $sReturn .= '<td style="white-space:nowrap;">'; |
|
| 243 | 243 | $action_argument = 0; |
| 244 | 244 | if (isset($ftrs['actions']['key'])) { |
| 245 | 245 | $actionKey = $ftrs['actions']['key']; |
@@ -247,7 +247,7 @@ discard block |
||
| 247 | 247 | $actionKey = 'view'; |
| 248 | 248 | } |
| 249 | 249 | if (isset($ftrs['action_prefix'])) { |
| 250 | - $actPrfx = $ftrs['action_prefix'] . '&'; |
|
| 250 | + $actPrfx = $ftrs['action_prefix'].'&'; |
|
| 251 | 251 | $actionKey = 'view2'; |
| 252 | 252 | } else { |
| 253 | 253 | $actPrfx = ''; |
@@ -258,11 +258,11 @@ discard block |
||
| 258 | 258 | } |
| 259 | 259 | switch ($key) { |
| 260 | 260 | case 'checkbox': |
| 261 | - $checkboxName = $value . '[]'; |
|
| 261 | + $checkboxName = $value.'[]'; |
|
| 262 | 262 | $checkboxNameS = $value; |
| 263 | - $sReturn .= ' <input type="checkbox" name="' . $checkboxName |
|
| 264 | - . '" id="n' . $aElements[$rCntr][$value] |
|
| 265 | - . '" value="' . $aElements[$rCntr][$value] . '" '; |
|
| 263 | + $sReturn .= ' <input type="checkbox" name="'.$checkboxName |
|
| 264 | + . '" id="n'.$aElements[$rCntr][$value] |
|
| 265 | + . '" value="'.$aElements[$rCntr][$value].'" '; |
|
| 266 | 266 | if (!is_null($this->tCmnSuperGlobals->get($checkboxNameS))) { |
| 267 | 267 | $inputToCheck = $this->tCmnSuperGlobals->get($checkboxNameS); |
| 268 | 268 | if (is_array($inputToCheck)) { |
@@ -278,29 +278,29 @@ discard block |
||
| 278 | 278 | if (strpos($this->tCmnSuperGlobals->get('view'), 'multiEdit') !== false) { |
| 279 | 279 | $sReturn .= 'disabled="disabled" '; |
| 280 | 280 | } |
| 281 | - $sReturn .= '/>'; |
|
| 281 | + $sReturn .= '/>'; |
|
| 282 | 282 | break; |
| 283 | 283 | case 'checkbox_inlineEdit': |
| 284 | - $checkboxName = $value . '[]'; |
|
| 284 | + $checkboxName = $value.'[]'; |
|
| 285 | 285 | $checkboxNameS = $value; |
| 286 | - $sReturn .= ' <input type="checkbox" name="' . $checkboxName |
|
| 287 | - . '" id="n' . $aElements[$rCntr][$value] . '" value="' |
|
| 288 | - . $aElements[$rCntr][$value] . '"/>'; |
|
| 286 | + $sReturn .= ' <input type="checkbox" name="'.$checkboxName |
|
| 287 | + . '" id="n'.$aElements[$rCntr][$value].'" value="' |
|
| 288 | + . $aElements[$rCntr][$value].'"/>'; |
|
| 289 | 289 | break; |
| 290 | 290 | case 'delete': |
| 291 | - $sReturn .= '<a href="#" onclick="javascript:setQuest(\'' . $value[0] . '\',\''; |
|
| 292 | - $iActArgs = count($value[1]); |
|
| 291 | + $sReturn .= '<a href="#" onclick="javascript:setQuest(\''.$value[0].'\',\''; |
|
| 292 | + $iActArgs = count($value[1]); |
|
| 293 | 293 | for ($cntr2 = 0; $cntr2 < $iActArgs; $cntr2++) { |
| 294 | - $sReturn .= $value[1][$cntr2] . '=' . $aElements[$rCntr][$value[1][$cntr2]]; |
|
| 294 | + $sReturn .= $value[1][$cntr2].'='.$aElements[$rCntr][$value[1][$cntr2]]; |
|
| 295 | 295 | } |
| 296 | - $sReturn .= '\');" id="' . $key . $rCntr . '"><i class="fa fa-times"> </i></a>'; |
|
| 296 | + $sReturn .= '\');" id="'.$key.$rCntr.'"><i class="fa fa-times"> </i></a>'; |
|
| 297 | 297 | break; |
| 298 | 298 | case 'edit': |
| 299 | 299 | case 'list2': |
| 300 | 300 | case 'schedule': |
| 301 | - $vIc = ($key == 'edit' ? 'pencil' : ($key == 'list2' ? 'list' : 'hourglass-half')); |
|
| 301 | + $vIc = ($key == 'edit' ? 'pencil' : ($key == 'list2' ? 'list' : 'hourglass-half')); |
|
| 302 | 302 | $sReturn .= $this->setDynamicActionToSpecialCell($value, $aElements, [ |
| 303 | - 'vIcon' => 'fa fa-' . $vIc, |
|
| 303 | + 'vIcon' => 'fa fa-'.$vIc, |
|
| 304 | 304 | 'aPrefix' => $actPrfx, |
| 305 | 305 | 'aKey' => $actionKey, |
| 306 | 306 | 'rCounter' => $rCntr, |
@@ -328,7 +328,7 @@ discard block |
||
| 328 | 328 | switch ($value[1]) { |
| 329 | 329 | case '/': |
| 330 | 330 | // next variable is only to avoid a long line |
| 331 | - $shorter = [ |
|
| 331 | + $shorter = [ |
|
| 332 | 332 | $aElements[$rCntr][$value[3]], |
| 333 | 333 | $aElements[$rCntr][$value[4]], |
| 334 | 334 | ]; |
@@ -336,7 +336,7 @@ discard block |
||
| 336 | 336 | break; |
| 337 | 337 | case '+': |
| 338 | 338 | // next variable is only to avoid a long line |
| 339 | - $iTemp = $this->setArrayValuesAsKey([ |
|
| 339 | + $iTemp = $this->setArrayValuesAsKey([ |
|
| 340 | 340 | $value[0], |
| 341 | 341 | $value[1], |
| 342 | 342 | $value[2] |
@@ -353,7 +353,7 @@ discard block |
||
| 353 | 353 | } |
| 354 | 354 | if ($value[0] == '%') { |
| 355 | 355 | $rowComputed[$key] = ($aElements[$rCntr][$key] * 100); |
| 356 | - $dec -= 2; |
|
| 356 | + $dec -= 2; |
|
| 357 | 357 | } else { |
| 358 | 358 | $rowComputed[$key] = $aElements[$rCntr][$key]; |
| 359 | 359 | } |
@@ -365,59 +365,59 @@ discard block |
||
| 365 | 365 | $sReturn .= '</tr>'; |
| 366 | 366 | } |
| 367 | 367 | if (isset($iStartingPageRecord)) { |
| 368 | - $pgn = $this->setPagination($ftrs['limits'][0], $ftrs['limits'][1], $ftrs['limits'][2]); |
|
| 369 | - $sReturn .= '<tr>' . $this->setStringIntoTag($pgn, 'th', ['colspan' => $iTableColumns]) . '</tr>'; |
|
| 368 | + $pgn = $this->setPagination($ftrs['limits'][0], $ftrs['limits'][1], $ftrs['limits'][2]); |
|
| 369 | + $sReturn .= '<tr>'.$this->setStringIntoTag($pgn, 'th', ['colspan' => $iTableColumns]).'</tr>'; |
|
| 370 | 370 | } |
| 371 | 371 | $sReturn .= '</tbody></table>'; |
| 372 | 372 | if ($ftrs['grouping_cell_type'] == 'tab') { |
| 373 | 373 | if (isset($ftrs['showGroupingCounter'])) { |
| 374 | 374 | $sReturn .= $this->updateDivTitleName($remindGroupValue, $groupCounter); |
| 375 | 375 | } |
| 376 | - $sReturn .= '</div><!-- from ' . $remindGroupValue . ' -->'; |
|
| 376 | + $sReturn .= '</div><!-- from '.$remindGroupValue.' -->'; |
|
| 377 | 377 | if (!isset($ftrs['noGlobalTab'])) { |
| 378 | 378 | $sReturn .= '</div><!-- from global tab -->'; |
| 379 | 379 | } |
| 380 | 380 | } |
| 381 | 381 | if (isset($ftrs['actions']['checkbox'])) { |
| 382 | 382 | if (strpos($this->tCmnSuperGlobals->get('view'), 'multiEdit') === false) { |
| 383 | - $sReturn .= '<a href="#" onclick="javascript:checking(\'' . $checkboxFormId |
|
| 384 | - . '\',\'' . $checkboxName . '\',true);">Check All</a> ' |
|
| 385 | - . '<a href="#" onclick="javascript:checking(\'' . $checkboxFormId |
|
| 386 | - . '\',\'' . $checkboxName . '\',false);">Uncheck All</a> ' |
|
| 387 | - . '<input type="hidden" name="action" value="multiEdit_' . $checkboxNameS . '" />'; |
|
| 383 | + $sReturn .= '<a href="#" onclick="javascript:checking(\''.$checkboxFormId |
|
| 384 | + . '\',\''.$checkboxName.'\',true);">Check All</a> ' |
|
| 385 | + . '<a href="#" onclick="javascript:checking(\''.$checkboxFormId |
|
| 386 | + . '\',\''.$checkboxName.'\',false);">Uncheck All</a> ' |
|
| 387 | + . '<input type="hidden" name="action" value="multiEdit_'.$checkboxNameS.'" />'; |
|
| 388 | 388 | if (isset($ftrs['hiddenInput'])) { |
| 389 | 389 | if (is_array($ftrs['hiddenInput'])) { |
| 390 | 390 | foreach ($ftrs['hiddenInput'] as $valueF) { |
| 391 | - $sReturn .= '<input type="hidden" name="' . $valueF |
|
| 392 | - . '" value="' . $this->tCmnSuperGlobals->get($valueF) . '" />'; |
|
| 391 | + $sReturn .= '<input type="hidden" name="'.$valueF |
|
| 392 | + . '" value="'.$this->tCmnSuperGlobals->get($valueF).'" />'; |
|
| 393 | 393 | } |
| 394 | 394 | } else { |
| 395 | - $sReturn .= '<input type="hidden" name="' . $ftrs['hiddenInput'] |
|
| 396 | - . '" value="' . $this->tCmnSuperGlobals->get($ftrs['hiddenInput']) . '" />'; |
|
| 395 | + $sReturn .= '<input type="hidden" name="'.$ftrs['hiddenInput'] |
|
| 396 | + . '" value="'.$this->tCmnSuperGlobals->get($ftrs['hiddenInput']).'" />'; |
|
| 397 | 397 | } |
| 398 | 398 | } |
| 399 | - $sReturn .= '<input style="margin: 0 3em 0 3em;" type="submit" ' . 'value="Edit selected" />'; |
|
| 399 | + $sReturn .= '<input style="margin: 0 3em 0 3em;" type="submit" '.'value="Edit selected" />'; |
|
| 400 | 400 | } |
| 401 | 401 | $sReturn .= '</form>'; |
| 402 | 402 | } |
| 403 | 403 | if (isset($ftrs['actions']['checkbox_inlineEdit'])) { |
| 404 | - $sReturn .= '<a href="#" onclick="javascript:checking(\'' . $checkboxFormId |
|
| 405 | - . '\',\'' . $checkboxName . '\',true);">Check All</a> ' |
|
| 406 | - . '<a href="#" onclick="javascript:checking(\'' . $checkboxFormId |
|
| 407 | - . '\',\'' . $checkboxName . '\',false);">Uncheck All</a> '; |
|
| 404 | + $sReturn .= '<a href="#" onclick="javascript:checking(\''.$checkboxFormId |
|
| 405 | + . '\',\''.$checkboxName.'\',true);">Check All</a> ' |
|
| 406 | + . '<a href="#" onclick="javascript:checking(\''.$checkboxFormId |
|
| 407 | + . '\',\''.$checkboxName.'\',false);">Uncheck All</a> '; |
|
| 408 | 408 | if (isset($ftrs['visibleInput'])) { |
| 409 | 409 | $sReturn .= $ftrs['visibleInput']; |
| 410 | 410 | } |
| 411 | - $sReturn .= '<input type="hidden" name="view" value="save_' . $checkboxNameS . '" />'; |
|
| 411 | + $sReturn .= '<input type="hidden" name="view" value="save_'.$checkboxNameS.'" />'; |
|
| 412 | 412 | if (isset($ftrs['hiddenInput'])) { |
| 413 | 413 | if (is_array($ftrs['hiddenInput'])) { |
| 414 | 414 | foreach ($ftrs['hiddenInput'] as $valueF) { |
| 415 | - $sReturn .= '<input type="hidden" name="' . $valueF . '" value="' |
|
| 416 | - . $this->tCmnSuperGlobals->get($valueF) . '" />'; |
|
| 415 | + $sReturn .= '<input type="hidden" name="'.$valueF.'" value="' |
|
| 416 | + . $this->tCmnSuperGlobals->get($valueF).'" />'; |
|
| 417 | 417 | } |
| 418 | 418 | } else { |
| 419 | - $sReturn .= '<input type="hidden" name="' . $ftrs['hiddenInput'] |
|
| 420 | - . '" value="' . $this->tCmnSuperGlobals->get($ftrs['hiddenInput']) . '" />'; |
|
| 419 | + $sReturn .= '<input type="hidden" name="'.$ftrs['hiddenInput'] |
|
| 420 | + . '" value="'.$this->tCmnSuperGlobals->get($ftrs['hiddenInput']).'" />'; |
|
| 421 | 421 | } |
| 422 | 422 | } |
| 423 | 423 | $sReturn .= '<input style="margin: 0 3em 0 3em;" type="submit" value="Store the modification" />'; |
@@ -429,18 +429,18 @@ discard block |
||
| 429 | 429 | private function setDynamicActionToSpecialCell($val, $aElements, $inP) |
| 430 | 430 | { |
| 431 | 431 | $aArgumemts = []; |
| 432 | - $aArgumemts[] = $this->tCmnSuperGlobals->getScriptName() . '?' . $inP['aPrefix'] . $inP['aKey'] . '=' . $val[0]; |
|
| 432 | + $aArgumemts[] = $this->tCmnSuperGlobals->getScriptName().'?'.$inP['aPrefix'].$inP['aKey'].'='.$val[0]; |
|
| 433 | 433 | $iActArgs = count($val[1]); |
| 434 | 434 | for ($counter = 0; $counter < $iActArgs; $counter++) { |
| 435 | - $aArgumemts[] = $val[1][$counter] . '=' . $aElements[$inP['rCounter']][$val[1][$counter]]; |
|
| 435 | + $aArgumemts[] = $val[1][$counter].'='.$aElements[$inP['rCounter']][$val[1][$counter]]; |
|
| 436 | 436 | } |
| 437 | - $id = $inP['key'] . $inP['rCounter']; |
|
| 437 | + $id = $inP['key'].$inP['rCounter']; |
|
| 438 | 438 | if (isset($inP['Features']['NoAjaxEditing'])) { |
| 439 | - return '<a href="' . implode('&', $aArgumemts) . '" id="' . $id . '"><i class="' |
|
| 440 | - . $inP['vIcon'] . '"> </i></a>'; |
|
| 439 | + return '<a href="'.implode('&', $aArgumemts).'" id="'.$id.'"><i class="' |
|
| 440 | + . $inP['vIcon'].'"> </i></a>'; |
|
| 441 | 441 | } |
| 442 | - return '<a href="#" onclick="javascript:loadAE(\'' . implode('&', $aArgumemts) . '\');"' |
|
| 443 | - . ' id="' . $id . '"><i class="' . $inP['vIcon'] . '"> </i></a>'; |
|
| 442 | + return '<a href="#" onclick="javascript:loadAE(\''.implode('&', $aArgumemts).'\');"' |
|
| 443 | + . ' id="'.$id.'"><i class="'.$inP['vIcon'].'"> </i></a>'; |
|
| 444 | 444 | } |
| 445 | 445 | |
| 446 | 446 | /** |
@@ -462,10 +462,10 @@ discard block |
||
| 462 | 462 | if (isset($features['column_formatting'][$key])) { |
| 463 | 463 | switch ($features['column_formatting'][$key]) { |
| 464 | 464 | case '@': |
| 465 | - $sReturn .= 'style="text-align:left;">' . $value; |
|
| 465 | + $sReturn .= 'style="text-align:left;">'.$value; |
|
| 466 | 466 | break; |
| 467 | 467 | case 'right': |
| 468 | - $sReturn .= 'style="text-align:right;">' . $value; |
|
| 468 | + $sReturn .= 'style="text-align:right;">'.$value; |
|
| 469 | 469 | break; |
| 470 | 470 | default: |
| 471 | 471 | $sReturn .= '???'; |
@@ -479,12 +479,12 @@ discard block |
||
| 479 | 479 | if ((strpos($value, '-') !== false) && (strlen($value) == 10)) { |
| 480 | 480 | if (preg_match("([0-9]{4})-([0-9]{1,2})-([0-9]{1,2})", $value, $regs)) { |
| 481 | 481 | $outputet = true; |
| 482 | - $sReturn .= 'style="text-align:right;width: 10px;">' |
|
| 483 | - . $regs[3] . '.' . $regs[2] . '.' . $regs[1]; |
|
| 482 | + $sReturn .= 'style="text-align:right;width: 10px;">' |
|
| 483 | + . $regs[3].'.'.$regs[2].'.'.$regs[1]; |
|
| 484 | 484 | } |
| 485 | 485 | } |
| 486 | 486 | if (!$outputet) { |
| 487 | - $sReturn .= 'style="text-align:left;">' . $value; |
|
| 487 | + $sReturn .= 'style="text-align:left;">'.$value; |
|
| 488 | 488 | } |
| 489 | 489 | } |
| 490 | 490 | } |
@@ -510,11 +510,11 @@ discard block |
||
| 510 | 510 | { |
| 511 | 511 | $styleToReturn = 'style="text-align: right;">'; |
| 512 | 512 | if (substr($value, 0, 1) === '0') { |
| 513 | - return $styleToReturn . $value; |
|
| 513 | + return $styleToReturn.$value; |
|
| 514 | 514 | } |
| 515 | 515 | $decimals = $this->setTableCellDecimals($key, $features); |
| 516 | 516 | $nDc = ['MinFractionDigits' => $decimals, 'MaxFractionDigits' => $decimals]; |
| 517 | - return $styleToReturn . $this->setNumberFormat($value, $nDc); |
|
| 517 | + return $styleToReturn.$this->setNumberFormat($value, $nDc); |
|
| 518 | 518 | } |
| 519 | 519 | |
| 520 | 520 | /** |