|
@@ -1436,7 +1436,7 @@ discard block |
|
|
block discarded – undo |
|
1436
|
1436
|
if (in_array('table', $enableArr) && !$userTsConfig['mod.']['dbint.']['disableSelectATable']) { |
|
1437
|
1437
|
$out[] = '<div class="form-group">'; |
|
1438
|
1438
|
$out[] = ' <label for="SET[queryTable]">Select a table:</label>'; |
|
1439
|
|
- $out[] = $this->mkTableSelect('SET[queryTable]', $this->table); |
|
|
1439
|
+ $out[] = $this->mkTableSelect('SET[queryTable]', $this->table); |
|
1440
|
1440
|
$out[] = '</div>'; |
|
1441
|
1441
|
} |
|
1442
|
1442
|
if ($this->table) { |
|
@@ -1476,19 +1476,19 @@ discard block |
|
|
block discarded – undo |
|
1476
|
1476
|
if (in_array('fields', $enableArr) && !$userTsConfig['mod.']['dbint.']['disableSelectFields']) { |
|
1477
|
1477
|
$out[] = '<div class="form-group form-group-with-button-addon">'; |
|
1478
|
1478
|
$out[] = ' <label for="SET[queryFields]">Select fields:</label>'; |
|
1479
|
|
- $out[] = $this->mkFieldToInputSelect('SET[queryFields]', $this->extFieldLists['queryFields']); |
|
|
1479
|
+ $out[] = $this->mkFieldToInputSelect('SET[queryFields]', $this->extFieldLists['queryFields']); |
|
1480
|
1480
|
$out[] = '</div>'; |
|
1481
|
1481
|
} |
|
1482
|
1482
|
if (in_array('query', $enableArr) && !$userTsConfig['mod.']['dbint.']['disableMakeQuery']) { |
|
1483
|
1483
|
$out[] = '<div class="form-group">'; |
|
1484
|
1484
|
$out[] = ' <label>Make Query:</label>'; |
|
1485
|
|
- $out[] = $queryCode; |
|
|
1485
|
+ $out[] = $queryCode; |
|
1486
|
1486
|
$out[] = '</div>'; |
|
1487
|
1487
|
} |
|
1488
|
1488
|
if (in_array('group', $enableArr) && !$userTsConfig['mod.']['dbint.']['disableGroupBy']) { |
|
1489
|
1489
|
$out[] = '<div class="form-group form-inline">'; |
|
1490
|
1490
|
$out[] = ' <label for="SET[queryGroup]">Group By:</label>'; |
|
1491
|
|
- $out[] = $this->mkTypeSelect('SET[queryGroup]', $this->extFieldLists['queryGroup'], ''); |
|
|
1491
|
+ $out[] = $this->mkTypeSelect('SET[queryGroup]', $this->extFieldLists['queryGroup'], ''); |
|
1492
|
1492
|
$out[] = '</div>'; |
|
1493
|
1493
|
} |
|
1494
|
1494
|
if (in_array('order', $enableArr) && !$userTsConfig['mod.']['dbint.']['disableOrderBy']) { |
|
@@ -1497,7 +1497,7 @@ discard block |
|
|
block discarded – undo |
|
1497
|
1497
|
$orderBy[] = $this->mkTypeSelect('SET[queryOrder]', $orderByArr[0], ''); |
|
1498
|
1498
|
$orderBy[] = '<div class="checkbox">'; |
|
1499
|
1499
|
$orderBy[] = ' <label for="checkQueryOrderDesc">'; |
|
1500
|
|
- $orderBy[] = BackendUtility::getFuncCheck(0, 'SET[queryOrderDesc]', $modSettings['queryOrderDesc'], '', '', 'id="checkQueryOrderDesc"') . ' Descending'; |
|
|
1500
|
+ $orderBy[] = BackendUtility::getFuncCheck(0, 'SET[queryOrderDesc]', $modSettings['queryOrderDesc'], '', '', 'id="checkQueryOrderDesc"') . ' Descending'; |
|
1501
|
1501
|
$orderBy[] = ' </label>'; |
|
1502
|
1502
|
$orderBy[] = '</div>'; |
|
1503
|
1503
|
|
|
@@ -1505,13 +1505,13 @@ discard block |
|
|
block discarded – undo |
|
1505
|
1505
|
$orderBy[] = $this->mkTypeSelect('SET[queryOrder2]', $orderByArr[1], ''); |
|
1506
|
1506
|
$orderBy[] = '<div class="checkbox">'; |
|
1507
|
1507
|
$orderBy[] = ' <label for="checkQueryOrder2Desc">'; |
|
1508
|
|
- $orderBy[] = BackendUtility::getFuncCheck(0, 'SET[queryOrder2Desc]', $modSettings['queryOrder2Desc'], '', '', 'id="checkQueryOrder2Desc"') . ' Descending'; |
|
|
1508
|
+ $orderBy[] = BackendUtility::getFuncCheck(0, 'SET[queryOrder2Desc]', $modSettings['queryOrder2Desc'], '', '', 'id="checkQueryOrder2Desc"') . ' Descending'; |
|
1509
|
1509
|
$orderBy[] = ' </label>'; |
|
1510
|
1510
|
$orderBy[] = '</div>'; |
|
1511
|
1511
|
} |
|
1512
|
1512
|
$out[] = '<div class="form-group form-inline">'; |
|
1513
|
1513
|
$out[] = ' <label>Order By:</label>'; |
|
1514
|
|
- $out[] = implode(LF, $orderBy); |
|
|
1514
|
+ $out[] = implode(LF, $orderBy); |
|
1515
|
1515
|
$out[] = '</div>'; |
|
1516
|
1516
|
} |
|
1517
|
1517
|
if (in_array('limit', $enableArr) && !$userTsConfig['mod.']['dbint.']['disableLimit']) { |
|
@@ -1545,10 +1545,10 @@ discard block |
|
|
block discarded – undo |
|
1545
|
1545
|
$out[] = '<div class="form-group">'; |
|
1546
|
1546
|
$out[] = ' <label>Limit:</label>'; |
|
1547
|
1547
|
$out[] = ' <div class="form-inline">'; |
|
1548
|
|
- $out[] = implode(LF, $limit); |
|
|
1548
|
+ $out[] = implode(LF, $limit); |
|
1549
|
1549
|
$out[] = ' <div class="btn-group t3js-limit-submit">'; |
|
1550
|
|
- $out[] = $prevButton; |
|
1551
|
|
- $out[] = $nextButton; |
|
|
1550
|
+ $out[] = $prevButton; |
|
|
1551
|
+ $out[] = $nextButton; |
|
1552
|
1552
|
$out[] = ' </div>'; |
|
1553
|
1553
|
$out[] = ' <div class="btn-group t3js-limit-submit">'; |
|
1554
|
1554
|
$out[] = ' <input type="button" class="btn btn-default" data-value="10" value="10">'; |