@@ -76,7 +76,7 @@ discard block |
||
| 76 | 76 | 'class' => 'input_readonly', |
| 77 | 77 | 'value' => $sDefaultValue, |
| 78 | 78 | ]; |
| 79 | - return $this->setStringIntoShortTag('input', $inputFeatures) . $aElements[$sDefaultValue]; |
|
| 79 | + return $this->setStringIntoShortTag('input', $inputFeatures).$aElements[$sDefaultValue]; |
|
| 80 | 80 | } |
| 81 | 81 | return $this->setArrayToSelectNotReadOnly($aElements, $sDefaultValue, $selectName, $featArray); |
| 82 | 82 | } |
@@ -122,13 +122,13 @@ discard block |
||
| 122 | 122 | $ditTitle .= ' (0)'; |
| 123 | 123 | } |
| 124 | 124 | $divTab = [ |
| 125 | - 'start' => '<div class="tabbertab tabbertabdefault" id="tab_NoData" title="' . $ditTitle . '">', |
|
| 125 | + 'start' => '<div class="tabbertab tabbertabdefault" id="tab_NoData" title="'.$ditTitle.'">', |
|
| 126 | 126 | 'end' => '</div><!-- from tab_NoData -->', |
| 127 | 127 | ]; |
| 128 | 128 | if (!isset($ftrs['noGlobalTab'])) { |
| 129 | 129 | $divTab = [ |
| 130 | - 'start' => '<div class="tabber" id="tab">' . $divTab['start'], |
|
| 131 | - 'end' => $divTab['end'] . '</div><!-- from global Tab -->', |
|
| 130 | + 'start' => '<div class="tabber" id="tab">'.$divTab['start'], |
|
| 131 | + 'end' => $divTab['end'].'</div><!-- from global Tab -->', |
|
| 132 | 132 | ]; |
| 133 | 133 | } |
| 134 | 134 | } |
@@ -151,14 +151,14 @@ discard block |
||
| 151 | 151 | } |
| 152 | 152 | $checkboxFormId = ''; |
| 153 | 153 | if ((isset($ftrs['actions']['checkbox_inlineEdit'])) || (isset($ftrs['actions']['checkbox']))) { |
| 154 | - $checkboxFormId = 'frm' . date('YmdHis'); |
|
| 155 | - $sReturn .= '<form id="' . $checkboxFormId . '" name="' . $checkboxFormId |
|
| 156 | - . '" method="post" ' . ' action="' . $this->tCmnRequest->server->get('PHP_SELF') . '" >'; |
|
| 154 | + $checkboxFormId = 'frm'.date('YmdHis'); |
|
| 155 | + $sReturn .= '<form id="'.$checkboxFormId.'" name="'.$checkboxFormId |
|
| 156 | + . '" method="post" '.' action="'.$this->tCmnRequest->server->get('PHP_SELF').'" >'; |
|
| 157 | 157 | } |
| 158 | 158 | $tbl = []; |
| 159 | 159 | $tbl['Def'] = '<table' |
| 160 | - . (isset($ftrs['table_style']) ? ' style="' . $ftrs['table_style'] . '"' : '') |
|
| 161 | - . (isset($ftrs['table_class']) ? ' class="' . $ftrs['table_class'] . '"' : '') |
|
| 160 | + . (isset($ftrs['table_style']) ? ' style="'.$ftrs['table_style'].'"' : '') |
|
| 161 | + . (isset($ftrs['table_class']) ? ' class="'.$ftrs['table_class'].'"' : '') |
|
| 162 | 162 | . '>'; |
| 163 | 163 | if (!isset($ftrs['grouping_cell_type'])) { |
| 164 | 164 | $ftrs['grouping_cell_type'] = 'row'; |
@@ -199,7 +199,7 @@ discard block |
||
| 199 | 199 | $sReturn .= $tbl['Head']; |
| 200 | 200 | } |
| 201 | 201 | if (isset($iStartingPageRecord)) { |
| 202 | - $pgn = $this->setPagination($ftrs['limits'][0], $ftrs['limits'][1], $ftrs['limits'][2], $bKpFlPge); |
|
| 202 | + $pgn = $this->setPagination($ftrs['limits'][0], $ftrs['limits'][1], $ftrs['limits'][2], $bKpFlPge); |
|
| 203 | 203 | $sReturn .= $this->setStringIntoTag($this->setStringIntoTag($pgn, 'th', [ |
| 204 | 204 | 'colspan' => $iTableColumns |
| 205 | 205 | ]), 'tr'); |
@@ -241,22 +241,22 @@ discard block |
||
| 241 | 241 | } |
| 242 | 242 | $remebered_value = $color_column_value; |
| 243 | 243 | } |
| 244 | - $color = ' style="background-color: ' . $ftrs['row_colored_alternated'][$color_no] . ';"'; |
|
| 244 | + $color = ' style="background-color: '.$ftrs['row_colored_alternated'][$color_no].';"'; |
|
| 245 | 245 | } else { |
| 246 | 246 | if (isset($ftrs['RowStyle'])) { |
| 247 | - $color = ' style="' . $aElements[$rCntr][$ftrs['RowStyle']] . '"'; |
|
| 247 | + $color = ' style="'.$aElements[$rCntr][$ftrs['RowStyle']].'"'; |
|
| 248 | 248 | } else { |
| 249 | 249 | $color = ''; |
| 250 | 250 | } |
| 251 | 251 | } |
| 252 | - $tbl['tr_Color'] = '<tr' . $color . '>'; |
|
| 252 | + $tbl['tr_Color'] = '<tr'.$color.'>'; |
|
| 253 | 253 | // Grouping column |
| 254 | 254 | if (isset($ftrs['grouping_cell'])) { |
| 255 | 255 | foreach ($aElements[$rCntr] as $key => $value) { |
| 256 | 256 | if (($ftrs['grouping_cell'] == $key) && ($remindGroupValue != $value)) { |
| 257 | 257 | switch ($ftrs['grouping_cell_type']) { |
| 258 | 258 | case 'row': |
| 259 | - $sReturn .= $tbl['tr_Color'] . '<td ' . 'colspan="' . $iTableColumns . '">' |
|
| 259 | + $sReturn .= $tbl['tr_Color'].'<td '.'colspan="'.$iTableColumns.'">' |
|
| 260 | 260 | . $this->setStringIntoTag($value, 'div', ['class' => 'rowGroup rounded']) |
| 261 | 261 | . '</td></tr>'; |
| 262 | 262 | break; |
@@ -268,7 +268,7 @@ discard block |
||
| 268 | 268 | } else { |
| 269 | 269 | $sReturn .= '</tbody></table>'; |
| 270 | 270 | if (isset($ftrs['showGroupingCounter'])) { |
| 271 | - $sReturn .= $this->updateDivTitleName($remindGroupValue, $groupCounter); |
|
| 271 | + $sReturn .= $this->updateDivTitleName($remindGroupValue, $groupCounter); |
|
| 272 | 272 | $groupCounter = 0; |
| 273 | 273 | } |
| 274 | 274 | $sReturn .= '</div>'; |
@@ -277,9 +277,9 @@ discard block |
||
| 277 | 277 | if (isset($ftrs['grouping_default_tab'])) { |
| 278 | 278 | $sReturn .= ($ftrs['grouping_default_tab'] == $value ? ' tabbertabdefault' : ''); |
| 279 | 279 | } |
| 280 | - $sReturn .= '" id="tab_' . $this->cleanStringForId($value) . '" ' |
|
| 281 | - . 'title="' . $value . '">' |
|
| 282 | - . $tbl['Def'] . $tbl['Head'] . $tbl['Header']; |
|
| 280 | + $sReturn .= '" id="tab_'.$this->cleanStringForId($value).'" ' |
|
| 281 | + . 'title="'.$value.'">' |
|
| 282 | + . $tbl['Def'].$tbl['Head'].$tbl['Header']; |
|
| 283 | 283 | break; |
| 284 | 284 | } |
| 285 | 285 | $remindGroupValue = $value; |
@@ -293,12 +293,12 @@ discard block |
||
| 293 | 293 | } |
| 294 | 294 | } |
| 295 | 295 | } |
| 296 | - $sReturn .= $tbl['tr_Color']; |
|
| 296 | + $sReturn .= $tbl['tr_Color']; |
|
| 297 | 297 | // Action column |
| 298 | 298 | $checkboxName = ''; |
| 299 | 299 | $checkboxNameS = ''; |
| 300 | 300 | if (isset($ftrs['actions'])) { |
| 301 | - $sReturn .= '<td style="white-space:nowrap;">'; |
|
| 301 | + $sReturn .= '<td style="white-space:nowrap;">'; |
|
| 302 | 302 | $action_argument = 0; |
| 303 | 303 | if (isset($ftrs['actions']['key'])) { |
| 304 | 304 | $actionKey = $ftrs['actions']['key']; |
@@ -306,7 +306,7 @@ discard block |
||
| 306 | 306 | $actionKey = 'view'; |
| 307 | 307 | } |
| 308 | 308 | if (isset($ftrs['action_prefix'])) { |
| 309 | - $actPrfx = $ftrs['action_prefix'] . '&'; |
|
| 309 | + $actPrfx = $ftrs['action_prefix'].'&'; |
|
| 310 | 310 | $actionKey = 'view2'; |
| 311 | 311 | } else { |
| 312 | 312 | $actPrfx = ''; |
@@ -317,11 +317,11 @@ discard block |
||
| 317 | 317 | } |
| 318 | 318 | switch ($key) { |
| 319 | 319 | case 'checkbox': |
| 320 | - $checkboxName = $value . '[]'; |
|
| 320 | + $checkboxName = $value.'[]'; |
|
| 321 | 321 | $checkboxNameS = $value; |
| 322 | - $sReturn .= ' <input type="checkbox" name="' . $checkboxName |
|
| 323 | - . '" id="n' . $aElements[$rCntr][$value] |
|
| 324 | - . '" value="' . $aElements[$rCntr][$value] . '" '; |
|
| 322 | + $sReturn .= ' <input type="checkbox" name="'.$checkboxName |
|
| 323 | + . '" id="n'.$aElements[$rCntr][$value] |
|
| 324 | + . '" value="'.$aElements[$rCntr][$value].'" '; |
|
| 325 | 325 | if (isset($_REQUEST[$checkboxNameS])) { |
| 326 | 326 | if (is_array($_REQUEST[$checkboxNameS])) { |
| 327 | 327 | if (in_array($aElements[$rCntr][$value], $_REQUEST[$checkboxNameS])) { |
@@ -336,29 +336,29 @@ discard block |
||
| 336 | 336 | if (strpos($_REQUEST['view'], 'multiEdit') !== false) { |
| 337 | 337 | $sReturn .= 'disabled="disabled" '; |
| 338 | 338 | } |
| 339 | - $sReturn .= '/>'; |
|
| 339 | + $sReturn .= '/>'; |
|
| 340 | 340 | break; |
| 341 | 341 | case 'checkbox_inlineEdit': |
| 342 | - $checkboxName = $value . '[]'; |
|
| 342 | + $checkboxName = $value.'[]'; |
|
| 343 | 343 | $checkboxNameS = $value; |
| 344 | - $sReturn .= ' <input type="checkbox" name="' . $checkboxName |
|
| 345 | - . '" id="n' . $aElements[$rCntr][$value] . '" value="' |
|
| 346 | - . $aElements[$rCntr][$value] . '"/>'; |
|
| 344 | + $sReturn .= ' <input type="checkbox" name="'.$checkboxName |
|
| 345 | + . '" id="n'.$aElements[$rCntr][$value].'" value="' |
|
| 346 | + . $aElements[$rCntr][$value].'"/>'; |
|
| 347 | 347 | break; |
| 348 | 348 | case 'delete': |
| 349 | - $sReturn .= '<a href="#" onclick="javascript:setQuest(\'' . $value[0] . '\',\''; |
|
| 350 | - $iActArgs = count($value[1]); |
|
| 349 | + $sReturn .= '<a href="#" onclick="javascript:setQuest(\''.$value[0].'\',\''; |
|
| 350 | + $iActArgs = count($value[1]); |
|
| 351 | 351 | for ($cntr2 = 0; $cntr2 < $iActArgs; $cntr2++) { |
| 352 | - $sReturn .= $value[1][$cntr2] . '=' . $aElements[$rCntr][$value[1][$cntr2]]; |
|
| 352 | + $sReturn .= $value[1][$cntr2].'='.$aElements[$rCntr][$value[1][$cntr2]]; |
|
| 353 | 353 | } |
| 354 | - $sReturn .= '\');" id="' . $key . $rCntr . '"><i class="fa fa-times"> </i></a>'; |
|
| 354 | + $sReturn .= '\');" id="'.$key.$rCntr.'"><i class="fa fa-times"> </i></a>'; |
|
| 355 | 355 | break; |
| 356 | 356 | case 'edit': |
| 357 | 357 | case 'list2': |
| 358 | 358 | case 'schedule': |
| 359 | - $vIc = ($key == 'edit' ? 'pencil' : ($key == 'list2' ? 'list' : 'hourglass-half')); |
|
| 359 | + $vIc = ($key == 'edit' ? 'pencil' : ($key == 'list2' ? 'list' : 'hourglass-half')); |
|
| 360 | 360 | $sReturn .= $this->setDynamicActionToSpecialCell($value, $aElements, [ |
| 361 | - 'vIcon' => 'fa fa-' . $vIc, |
|
| 361 | + 'vIcon' => 'fa fa-'.$vIc, |
|
| 362 | 362 | 'aPrefix' => $actPrfx, |
| 363 | 363 | 'aKey' => $actionKey, |
| 364 | 364 | 'rCounter' => $rCntr, |
@@ -386,7 +386,7 @@ discard block |
||
| 386 | 386 | switch ($value[1]) { |
| 387 | 387 | case '/': |
| 388 | 388 | // next variable is only to avoid a long line |
| 389 | - $shorter = [ |
|
| 389 | + $shorter = [ |
|
| 390 | 390 | $aElements[$rCntr][$value[3]], |
| 391 | 391 | $aElements[$rCntr][$value[4]], |
| 392 | 392 | ]; |
@@ -394,7 +394,7 @@ discard block |
||
| 394 | 394 | break; |
| 395 | 395 | case '+': |
| 396 | 396 | // next variable is only to avoid a long line |
| 397 | - $iTemp = $this->setArrayValuesAsKey([ |
|
| 397 | + $iTemp = $this->setArrayValuesAsKey([ |
|
| 398 | 398 | $value[0], |
| 399 | 399 | $value[1], |
| 400 | 400 | $value[2] |
@@ -411,7 +411,7 @@ discard block |
||
| 411 | 411 | } |
| 412 | 412 | if ($value[0] == '%') { |
| 413 | 413 | $rowComputed[$key] = ($aElements[$rCntr][$key] * 100); |
| 414 | - $dec -= 2; |
|
| 414 | + $dec -= 2; |
|
| 415 | 415 | } else { |
| 416 | 416 | $rowComputed[$key] = $aElements[$rCntr][$key]; |
| 417 | 417 | } |
@@ -423,59 +423,59 @@ discard block |
||
| 423 | 423 | $sReturn .= '</tr>'; |
| 424 | 424 | } |
| 425 | 425 | if (isset($iStartingPageRecord)) { |
| 426 | - $pgn = $this->setPagination($ftrs['limits'][0], $ftrs['limits'][1], $ftrs['limits'][2]); |
|
| 427 | - $sReturn .= '<tr>' . $this->setStringIntoTag($pgn, 'th', ['colspan' => $iTableColumns]) . '</tr>'; |
|
| 426 | + $pgn = $this->setPagination($ftrs['limits'][0], $ftrs['limits'][1], $ftrs['limits'][2]); |
|
| 427 | + $sReturn .= '<tr>'.$this->setStringIntoTag($pgn, 'th', ['colspan' => $iTableColumns]).'</tr>'; |
|
| 428 | 428 | } |
| 429 | 429 | $sReturn .= '</tbody></table>'; |
| 430 | 430 | if ($ftrs['grouping_cell_type'] == 'tab') { |
| 431 | 431 | if (isset($ftrs['showGroupingCounter'])) { |
| 432 | 432 | $sReturn .= $this->updateDivTitleName($remindGroupValue, $groupCounter); |
| 433 | 433 | } |
| 434 | - $sReturn .= '</div><!-- from ' . $remindGroupValue . ' -->'; |
|
| 434 | + $sReturn .= '</div><!-- from '.$remindGroupValue.' -->'; |
|
| 435 | 435 | if (!isset($ftrs['noGlobalTab'])) { |
| 436 | 436 | $sReturn .= '</div><!-- from global tab -->'; |
| 437 | 437 | } |
| 438 | 438 | } |
| 439 | 439 | if (isset($ftrs['actions']['checkbox'])) { |
| 440 | 440 | if (strpos($_REQUEST['view'], 'multiEdit') === false) { |
| 441 | - $sReturn .= '<a href="#" onclick="javascript:checking(\'' . $checkboxFormId |
|
| 442 | - . '\',\'' . $checkboxName . '\',true);">Check All</a> ' |
|
| 443 | - . '<a href="#" onclick="javascript:checking(\'' . $checkboxFormId |
|
| 444 | - . '\',\'' . $checkboxName . '\',false);">Uncheck All</a> ' |
|
| 445 | - . '<input type="hidden" name="action" value="multiEdit_' . $checkboxNameS . '" />'; |
|
| 441 | + $sReturn .= '<a href="#" onclick="javascript:checking(\''.$checkboxFormId |
|
| 442 | + . '\',\''.$checkboxName.'\',true);">Check All</a> ' |
|
| 443 | + . '<a href="#" onclick="javascript:checking(\''.$checkboxFormId |
|
| 444 | + . '\',\''.$checkboxName.'\',false);">Uncheck All</a> ' |
|
| 445 | + . '<input type="hidden" name="action" value="multiEdit_'.$checkboxNameS.'" />'; |
|
| 446 | 446 | if (isset($ftrs['hiddenInput'])) { |
| 447 | 447 | if (is_array($ftrs['hiddenInput'])) { |
| 448 | 448 | foreach ($ftrs['hiddenInput'] as $valueF) { |
| 449 | - $sReturn .= '<input type="hidden" name="' . $valueF |
|
| 450 | - . '" value="' . $_REQUEST[$valueF] . '" />'; |
|
| 449 | + $sReturn .= '<input type="hidden" name="'.$valueF |
|
| 450 | + . '" value="'.$_REQUEST[$valueF].'" />'; |
|
| 451 | 451 | } |
| 452 | 452 | } else { |
| 453 | - $sReturn .= '<input type="hidden" name="' . $ftrs['hiddenInput'] |
|
| 454 | - . '" value="' . $_REQUEST[$ftrs['hiddenInput']] . '" />'; |
|
| 453 | + $sReturn .= '<input type="hidden" name="'.$ftrs['hiddenInput'] |
|
| 454 | + . '" value="'.$_REQUEST[$ftrs['hiddenInput']].'" />'; |
|
| 455 | 455 | } |
| 456 | 456 | } |
| 457 | - $sReturn .= '<input style="margin: 0 3em 0 3em;" type="submit" ' . 'value="Edit selected" />'; |
|
| 457 | + $sReturn .= '<input style="margin: 0 3em 0 3em;" type="submit" '.'value="Edit selected" />'; |
|
| 458 | 458 | } |
| 459 | 459 | $sReturn .= '</form>'; |
| 460 | 460 | } |
| 461 | 461 | if (isset($ftrs['actions']['checkbox_inlineEdit'])) { |
| 462 | - $sReturn .= '<a href="#" onclick="javascript:checking(\'' . $checkboxFormId |
|
| 463 | - . '\',\'' . $checkboxName . '\',true);">Check All</a> ' |
|
| 464 | - . '<a href="#" onclick="javascript:checking(\'' . $checkboxFormId |
|
| 465 | - . '\',\'' . $checkboxName . '\',false);">Uncheck All</a> '; |
|
| 462 | + $sReturn .= '<a href="#" onclick="javascript:checking(\''.$checkboxFormId |
|
| 463 | + . '\',\''.$checkboxName.'\',true);">Check All</a> ' |
|
| 464 | + . '<a href="#" onclick="javascript:checking(\''.$checkboxFormId |
|
| 465 | + . '\',\''.$checkboxName.'\',false);">Uncheck All</a> '; |
|
| 466 | 466 | if (isset($ftrs['visibleInput'])) { |
| 467 | 467 | $sReturn .= $ftrs['visibleInput']; |
| 468 | 468 | } |
| 469 | - $sReturn .= '<input type="hidden" name="view" value="save_' . $checkboxNameS . '" />'; |
|
| 469 | + $sReturn .= '<input type="hidden" name="view" value="save_'.$checkboxNameS.'" />'; |
|
| 470 | 470 | if (isset($ftrs['hiddenInput'])) { |
| 471 | 471 | if (is_array($ftrs['hiddenInput'])) { |
| 472 | 472 | foreach ($ftrs['hiddenInput'] as $valueF) { |
| 473 | - $sReturn .= '<input type="hidden" name="' . $valueF |
|
| 474 | - . '" value="' . $_REQUEST[$valueF] . '" />'; |
|
| 473 | + $sReturn .= '<input type="hidden" name="'.$valueF |
|
| 474 | + . '" value="'.$_REQUEST[$valueF].'" />'; |
|
| 475 | 475 | } |
| 476 | 476 | } else { |
| 477 | - $sReturn .= '<input type="hidden" name="' . $ftrs['hiddenInput'] |
|
| 478 | - . '" value="' . $_REQUEST[$ftrs['hiddenInput']] . '" />'; |
|
| 477 | + $sReturn .= '<input type="hidden" name="'.$ftrs['hiddenInput'] |
|
| 478 | + . '" value="'.$_REQUEST[$ftrs['hiddenInput']].'" />'; |
|
| 479 | 479 | } |
| 480 | 480 | } |
| 481 | 481 | $sReturn .= '<input style="margin: 0 3em 0 3em;" type="submit" value="Store the modification" />'; |
@@ -495,12 +495,12 @@ discard block |
||
| 495 | 495 | { |
| 496 | 496 | return $this->setStringIntoTag(' ', 'span', [ |
| 497 | 497 | 'onclick' => implode('', [ |
| 498 | - 'javascript:NewCssCal(\'' . $controlName, |
|
| 498 | + 'javascript:NewCssCal(\''.$controlName, |
|
| 499 | 499 | '\',\'yyyyMMdd\',\'dropdown\',false,\'24\',false);', |
| 500 | 500 | ]), |
| 501 | 501 | 'class' => 'fa fa-calendar', |
| 502 | - 'id' => $controlName . '_picker', |
|
| 503 | - 'style' => 'cursor:pointer;' . $additionalStyle, |
|
| 502 | + 'id' => $controlName.'_picker', |
|
| 503 | + 'style' => 'cursor:pointer;'.$additionalStyle, |
|
| 504 | 504 | ]); |
| 505 | 505 | } |
| 506 | 506 | |
@@ -515,30 +515,30 @@ discard block |
||
| 515 | 515 | { |
| 516 | 516 | return $this->setStringIntoTag(' ', 'span', [ |
| 517 | 517 | 'onclick' => implode('', [ |
| 518 | - 'javascript:NewCssCal(\'' . $controlName, |
|
| 518 | + 'javascript:NewCssCal(\''.$controlName, |
|
| 519 | 519 | '\',\'yyyyMMdd\',\'dropdown\',true,\'24\',true);', |
| 520 | 520 | ]), |
| 521 | 521 | 'class' => 'fa fa-calendar', |
| 522 | - 'id' => $controlName . '_picker', |
|
| 523 | - 'style' => 'cursor:pointer;' . $additionalStyle, |
|
| 522 | + 'id' => $controlName.'_picker', |
|
| 523 | + 'style' => 'cursor:pointer;'.$additionalStyle, |
|
| 524 | 524 | ]); |
| 525 | 525 | } |
| 526 | 526 | |
| 527 | 527 | private function setDynamicActionToSpecialCell($val, $aElements, $inP) |
| 528 | 528 | { |
| 529 | 529 | $aArgumemts = []; |
| 530 | - $aArgumemts[] = $this->tCmnSuperGlobals->getScriptName() . '?' . $inP['aPrefix'] . $inP['aKey'] . '=' . $val[0]; |
|
| 530 | + $aArgumemts[] = $this->tCmnSuperGlobals->getScriptName().'?'.$inP['aPrefix'].$inP['aKey'].'='.$val[0]; |
|
| 531 | 531 | $iActArgs = count($val[1]); |
| 532 | 532 | for ($counter = 0; $counter < $iActArgs; $counter++) { |
| 533 | - $aArgumemts[] = $val[1][$counter] . '=' . $aElements[$inP['rCounter']][$val[1][$counter]]; |
|
| 533 | + $aArgumemts[] = $val[1][$counter].'='.$aElements[$inP['rCounter']][$val[1][$counter]]; |
|
| 534 | 534 | } |
| 535 | - $id = $inP['key'] . $inP['rCounter']; |
|
| 535 | + $id = $inP['key'].$inP['rCounter']; |
|
| 536 | 536 | if (isset($inP['Features']['NoAjaxEditing'])) { |
| 537 | - return '<a href="' . implode('&', $aArgumemts) . '" id="' . $id . '"><i class="' |
|
| 538 | - . $inP['vIcon'] . '"> </i></a>'; |
|
| 537 | + return '<a href="'.implode('&', $aArgumemts).'" id="'.$id.'"><i class="' |
|
| 538 | + . $inP['vIcon'].'"> </i></a>'; |
|
| 539 | 539 | } |
| 540 | - return '<a href="#" onclick="javascript:loadAE(\'' . implode('&', $aArgumemts) . '\');"' |
|
| 541 | - . ' id="' . $id . '"><i class="' . $inP['vIcon'] . '"> </i></a>'; |
|
| 540 | + return '<a href="#" onclick="javascript:loadAE(\''.implode('&', $aArgumemts).'\');"' |
|
| 541 | + . ' id="'.$id.'"><i class="'.$inP['vIcon'].'"> </i></a>'; |
|
| 542 | 542 | } |
| 543 | 543 | |
| 544 | 544 | /** |
@@ -553,7 +553,7 @@ discard block |
||
| 553 | 553 | if (!is_null($sHK) && (in_array('noHeader', $sHK))) { |
| 554 | 554 | return ''; |
| 555 | 555 | } |
| 556 | - return $this->setFooterCommonInjected($footerInjected) . '</body></html>'; |
|
| 556 | + return $this->setFooterCommonInjected($footerInjected).'</body></html>'; |
|
| 557 | 557 | } |
| 558 | 558 | |
| 559 | 559 | protected function setFooterCommonInjected($footerInjected = null) |
@@ -586,11 +586,11 @@ discard block |
||
| 586 | 586 | 'lang' => '<html lang="en-US">', |
| 587 | 587 | 'head' => '<head>', |
| 588 | 588 | 'charset' => '<meta charset="utf-8" />', |
| 589 | - 'viewport' => '<meta name="viewport" content="' . implode(', ', [ |
|
| 589 | + 'viewport' => '<meta name="viewport" content="'.implode(', ', [ |
|
| 590 | 590 | 'width=device-width', |
| 591 | 591 | 'height=device-height', |
| 592 | 592 | 'initial-scale=1', |
| 593 | - ]) . '" />', |
|
| 593 | + ]).'" />', |
|
| 594 | 594 | ]; |
| 595 | 595 | if (!is_null($headerFeatures)) { |
| 596 | 596 | if (is_array($headerFeatures)) { |
@@ -618,11 +618,11 @@ discard block |
||
| 618 | 618 | break; |
| 619 | 619 | case 'lang': |
| 620 | 620 | $fixedHeaderElements['lang'] = '<html lang="' |
| 621 | - . filter_var($value, FILTER_SANITIZE_STRING) . '">'; |
|
| 621 | + . filter_var($value, FILTER_SANITIZE_STRING).'">'; |
|
| 622 | 622 | break; |
| 623 | 623 | case 'title': |
| 624 | - $aFeatures[] = '<title>' |
|
| 625 | - . filter_var($value, FILTER_SANITIZE_STRING) . '</title>'; |
|
| 624 | + $aFeatures[] = '<title>' |
|
| 625 | + . filter_var($value, FILTER_SANITIZE_STRING).'</title>'; |
|
| 626 | 626 | break; |
| 627 | 627 | } |
| 628 | 628 | } |
@@ -635,7 +635,7 @@ discard block |
||
| 635 | 635 | . '</head>' |
| 636 | 636 | . '<body>' |
| 637 | 637 | . '<p style="background-color:red;color:#FFF;">The parameter sent to ' |
| 638 | - . __FUNCTION__ . ' must be an array</p>' |
|
| 638 | + . __FUNCTION__.' must be an array</p>' |
|
| 639 | 639 | . $this->setFooterCommon(); |
| 640 | 640 | throw new \Exception($sReturn); |
| 641 | 641 | } |
@@ -663,10 +663,10 @@ discard block |
||
| 663 | 663 | if (isset($features['column_formatting'][$key])) { |
| 664 | 664 | switch ($features['column_formatting'][$key]) { |
| 665 | 665 | case '@': |
| 666 | - $sReturn .= 'style="text-align:left;">' . $value; |
|
| 666 | + $sReturn .= 'style="text-align:left;">'.$value; |
|
| 667 | 667 | break; |
| 668 | 668 | case 'right': |
| 669 | - $sReturn .= 'style="text-align:right;">' . $value; |
|
| 669 | + $sReturn .= 'style="text-align:right;">'.$value; |
|
| 670 | 670 | break; |
| 671 | 671 | default: |
| 672 | 672 | $sReturn .= '???'; |
@@ -680,12 +680,12 @@ discard block |
||
| 680 | 680 | if ((strpos($value, '-') !== false) && (strlen($value) == 10)) { |
| 681 | 681 | if (preg_match("([0-9]{4})-([0-9]{1,2})-([0-9]{1,2})", $value, $regs)) { |
| 682 | 682 | $outputet = true; |
| 683 | - $sReturn .= 'style="text-align:right;width: 10px;">' |
|
| 684 | - . $regs[3] . '.' . $regs[2] . '.' . $regs[1]; |
|
| 683 | + $sReturn .= 'style="text-align:right;width: 10px;">' |
|
| 684 | + . $regs[3].'.'.$regs[2].'.'.$regs[1]; |
|
| 685 | 685 | } |
| 686 | 686 | } |
| 687 | 687 | if (!$outputet) { |
| 688 | - $sReturn .= 'style="text-align:left;">' . $value; |
|
| 688 | + $sReturn .= 'style="text-align:left;">'.$value; |
|
| 689 | 689 | } |
| 690 | 690 | } |
| 691 | 691 | } |
@@ -711,11 +711,11 @@ discard block |
||
| 711 | 711 | { |
| 712 | 712 | $styleToReturn = 'style="text-align: right;">'; |
| 713 | 713 | if (substr($value, 0, 1) === '0') { |
| 714 | - return $styleToReturn . $value; |
|
| 714 | + return $styleToReturn.$value; |
|
| 715 | 715 | } |
| 716 | 716 | $decimals = $this->setTableCellDecimals($key, $features); |
| 717 | 717 | $nDc = ['MinFractionDigits' => $decimals, 'MaxFractionDigits' => $decimals]; |
| 718 | - return $styleToReturn . $this->setNumberFormat($value, $nDc); |
|
| 718 | + return $styleToReturn.$this->setNumberFormat($value, $nDc); |
|
| 719 | 719 | } |
| 720 | 720 | |
| 721 | 721 | /** |
@@ -751,7 +751,7 @@ discard block |
||
| 751 | 751 | $this->handleLanguageIntoSession(); |
| 752 | 752 | return '<div class="upperRightBox">' |
| 753 | 753 | . '<div style="text-align:right;">' |
| 754 | - . '<span class="flag-icon flag-icon-' . strtolower(substr($this->tCmnSession->get('lang'), -2)) |
|
| 754 | + . '<span class="flag-icon flag-icon-'.strtolower(substr($this->tCmnSession->get('lang'), -2)) |
|
| 755 | 755 | . '" style="margin-right:2px;"> </span>' |
| 756 | 756 | . $aAvailableLanguages[$this->tCmnSession->get('lang')] |
| 757 | 757 | . '</div><!-- default Language -->' |
@@ -764,17 +764,17 @@ discard block |
||
| 764 | 764 | $linkWithoutLanguage = ''; |
| 765 | 765 | $alR = $this->tCmnSuperGlobals->query->all(); |
| 766 | 766 | if (count($alR) > 0) { |
| 767 | - $linkWithoutLanguage = $this->setArrayToStringForUrl('&', $alR, ['lang']) . '&'; |
|
| 767 | + $linkWithoutLanguage = $this->setArrayToStringForUrl('&', $alR, ['lang']).'&'; |
|
| 768 | 768 | } |
| 769 | 769 | $sReturn = []; |
| 770 | 770 | foreach ($aAvailableLanguages as $key => $value) { |
| 771 | 771 | if ($this->tCmnSession->get('lang') !== $key) { |
| 772 | - $sReturn[] = '<a href="?' . $linkWithoutLanguage . 'lang=' . $key . '" style="display:block;">' |
|
| 773 | - . '<span class="flag-icon flag-icon-' . strtolower(substr($key, -2)) |
|
| 774 | - . '" style="margin-right:2px;"> </span>' . $value . '</a>'; |
|
| 772 | + $sReturn[] = '<a href="?'.$linkWithoutLanguage.'lang='.$key.'" style="display:block;">' |
|
| 773 | + . '<span class="flag-icon flag-icon-'.strtolower(substr($key, -2)) |
|
| 774 | + . '" style="margin-right:2px;"> </span>'.$value.'</a>'; |
|
| 775 | 775 | } |
| 776 | 776 | } |
| 777 | - return '<div id="visibleOnHover">' . implode('', $sReturn) . '</div><!-- visibleOnHover end -->'; |
|
| 777 | + return '<div id="visibleOnHover">'.implode('', $sReturn).'</div><!-- visibleOnHover end -->'; |
|
| 778 | 778 | } |
| 779 | 779 | |
| 780 | 780 | } |
@@ -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(); |