|
@@ -2538,7 +2538,7 @@ discard block |
|
|
block discarded – undo |
|
2538
|
2538
|
if (in_array('table', $enableArr) && !($userTsConfig['mod.']['dbint.']['disableSelectATable'] ?? false)) { |
|
2539
|
2539
|
$out[] = '<div class="form-group">'; |
|
2540
|
2540
|
$out[] = ' <label for="SET[queryTable]">Select a table:</label>'; |
|
2541
|
|
- $out[] = $this->mkTableSelect('SET[queryTable]', $this->table); |
|
|
2541
|
+ $out[] = $this->mkTableSelect('SET[queryTable]', $this->table); |
|
2542
|
2542
|
$out[] = '</div>'; |
|
2543
|
2543
|
} |
|
2544
|
2544
|
if ($this->table) { |
|
@@ -2578,19 +2578,19 @@ discard block |
|
|
block discarded – undo |
|
2578
|
2578
|
if (in_array('fields', $enableArr) && !($userTsConfig['mod.']['dbint.']['disableSelectFields'] ?? false)) { |
|
2579
|
2579
|
$out[] = '<div class="form-group form-group-with-button-addon">'; |
|
2580
|
2580
|
$out[] = ' <label for="SET[queryFields]">Select fields:</label>'; |
|
2581
|
|
- $out[] = $this->mkFieldToInputSelect('SET[queryFields]', $this->extFieldLists['queryFields']); |
|
|
2581
|
+ $out[] = $this->mkFieldToInputSelect('SET[queryFields]', $this->extFieldLists['queryFields']); |
|
2582
|
2582
|
$out[] = '</div>'; |
|
2583
|
2583
|
} |
|
2584
|
2584
|
if (in_array('query', $enableArr) && !($userTsConfig['mod.']['dbint.']['disableMakeQuery'] ?? false)) { |
|
2585
|
2585
|
$out[] = '<div class="form-group">'; |
|
2586
|
2586
|
$out[] = ' <label>Make Query:</label>'; |
|
2587
|
|
- $out[] = $queryCode; |
|
|
2587
|
+ $out[] = $queryCode; |
|
2588
|
2588
|
$out[] = '</div>'; |
|
2589
|
2589
|
} |
|
2590
|
2590
|
if (in_array('group', $enableArr) && !($userTsConfig['mod.']['dbint.']['disableGroupBy'] ?? false)) { |
|
2591
|
2591
|
$out[] = '<div class="form-group form-inline">'; |
|
2592
|
2592
|
$out[] = ' <label for="SET[queryGroup]">Group By:</label>'; |
|
2593
|
|
- $out[] = $this->mkTypeSelect('SET[queryGroup]', $this->extFieldLists['queryGroup'], ''); |
|
|
2593
|
+ $out[] = $this->mkTypeSelect('SET[queryGroup]', $this->extFieldLists['queryGroup'], ''); |
|
2594
|
2594
|
$out[] = '</div>'; |
|
2595
|
2595
|
} |
|
2596
|
2596
|
if (in_array('order', $enableArr) && !($userTsConfig['mod.']['dbint.']['disableOrderBy'] ?? false)) { |
|
@@ -2598,20 +2598,20 @@ discard block |
|
|
block discarded – undo |
|
2598
|
2598
|
$orderBy = []; |
|
2599
|
2599
|
$orderBy[] = $this->mkTypeSelect('SET[queryOrder]', $orderByArr[0], ''); |
|
2600
|
2600
|
$orderBy[] = '<div class="form-check">'; |
|
2601
|
|
- $orderBy[] = BackendUtility::getFuncCheck(0, 'SET[queryOrderDesc]', $modSettings['queryOrderDesc'] ?? '', '', '', 'id="checkQueryOrderDesc"'); |
|
|
2601
|
+ $orderBy[] = BackendUtility::getFuncCheck(0, 'SET[queryOrderDesc]', $modSettings['queryOrderDesc'] ?? '', '', '', 'id="checkQueryOrderDesc"'); |
|
2602
|
2602
|
$orderBy[] = ' <label class="form-check-label" for="checkQueryOrderDesc">Descending</label>'; |
|
2603
|
2603
|
$orderBy[] = '</div>'; |
|
2604
|
2604
|
|
|
2605
|
2605
|
if ($orderByArr[0]) { |
|
2606
|
2606
|
$orderBy[] = $this->mkTypeSelect('SET[queryOrder2]', $orderByArr[1], ''); |
|
2607
|
2607
|
$orderBy[] = '<div class="form-check">'; |
|
2608
|
|
- $orderBy[] = BackendUtility::getFuncCheck(0, 'SET[queryOrder2Desc]', $modSettings['queryOrder2Desc'], '', '', 'id="checkQueryOrder2Desc"') . ' Descending'; |
|
|
2608
|
+ $orderBy[] = BackendUtility::getFuncCheck(0, 'SET[queryOrder2Desc]', $modSettings['queryOrder2Desc'], '', '', 'id="checkQueryOrder2Desc"') . ' Descending'; |
|
2609
|
2609
|
$orderBy[] = ' <label class="form-check-label" for="checkQueryOrder2Desc">Descending</label>'; |
|
2610
|
2610
|
$orderBy[] = '</div>'; |
|
2611
|
2611
|
} |
|
2612
|
2612
|
$out[] = '<div class="form-group form-inline">'; |
|
2613
|
2613
|
$out[] = ' <label>Order By:</label>'; |
|
2614
|
|
- $out[] = implode(LF, $orderBy); |
|
|
2614
|
+ $out[] = implode(LF, $orderBy); |
|
2615
|
2615
|
$out[] = '</div>'; |
|
2616
|
2616
|
} |
|
2617
|
2617
|
if (in_array('limit', $enableArr) && !($userTsConfig['mod.']['dbint.']['disableLimit'] ?? false)) { |
|
@@ -2645,10 +2645,10 @@ discard block |
|
|
block discarded – undo |
|
2645
|
2645
|
$out[] = '<div class="form-group">'; |
|
2646
|
2646
|
$out[] = ' <label>Limit:</label>'; |
|
2647
|
2647
|
$out[] = ' <div class="form-inline">'; |
|
2648
|
|
- $out[] = implode(LF, $limit); |
|
|
2648
|
+ $out[] = implode(LF, $limit); |
|
2649
|
2649
|
$out[] = ' <div class="btn-group t3js-limit-submit">'; |
|
2650
|
|
- $out[] = $prevButton; |
|
2651
|
|
- $out[] = $nextButton; |
|
|
2650
|
+ $out[] = $prevButton; |
|
|
2651
|
+ $out[] = $nextButton; |
|
2652
|
2652
|
$out[] = ' </div>'; |
|
2653
|
2653
|
$out[] = ' <div class="btn-group t3js-limit-submit">'; |
|
2654
|
2654
|
$out[] = ' <input type="button" class="btn btn-default" data-value="10" value="10">'; |