|
@@ -1429,7 +1429,7 @@ discard block |
|
|
block discarded – undo |
|
1429
|
1429
|
if (in_array('table', $enableArr) && !$userTsConfig['mod.']['dbint.']['disableSelectATable']) { |
|
1430
|
1430
|
$out[] = '<div class="form-group">'; |
|
1431
|
1431
|
$out[] = ' <label for="SET[queryTable]">Select a table:</label>'; |
|
1432
|
|
- $out[] = $this->mkTableSelect('SET[queryTable]', $this->table); |
|
|
1432
|
+ $out[] = $this->mkTableSelect('SET[queryTable]', $this->table); |
|
1433
|
1433
|
$out[] = '</div>'; |
|
1434
|
1434
|
} |
|
1435
|
1435
|
if ($this->table) { |
|
@@ -1469,19 +1469,19 @@ discard block |
|
|
block discarded – undo |
|
1469
|
1469
|
if (in_array('fields', $enableArr) && !$userTsConfig['mod.']['dbint.']['disableSelectFields']) { |
|
1470
|
1470
|
$out[] = '<div class="form-group form-group-with-button-addon">'; |
|
1471
|
1471
|
$out[] = ' <label for="SET[queryFields]">Select fields:</label>'; |
|
1472
|
|
- $out[] = $this->mkFieldToInputSelect('SET[queryFields]', $this->extFieldLists['queryFields']); |
|
|
1472
|
+ $out[] = $this->mkFieldToInputSelect('SET[queryFields]', $this->extFieldLists['queryFields']); |
|
1473
|
1473
|
$out[] = '</div>'; |
|
1474
|
1474
|
} |
|
1475
|
1475
|
if (in_array('query', $enableArr) && !$userTsConfig['mod.']['dbint.']['disableMakeQuery']) { |
|
1476
|
1476
|
$out[] = '<div class="form-group">'; |
|
1477
|
1477
|
$out[] = ' <label>Make Query:</label>'; |
|
1478
|
|
- $out[] = $queryCode; |
|
|
1478
|
+ $out[] = $queryCode; |
|
1479
|
1479
|
$out[] = '</div>'; |
|
1480
|
1480
|
} |
|
1481
|
1481
|
if (in_array('group', $enableArr) && !$userTsConfig['mod.']['dbint.']['disableGroupBy']) { |
|
1482
|
1482
|
$out[] = '<div class="form-group form-inline">'; |
|
1483
|
1483
|
$out[] = ' <label for="SET[queryGroup]">Group By:</label>'; |
|
1484
|
|
- $out[] = $this->mkTypeSelect('SET[queryGroup]', $this->extFieldLists['queryGroup'], ''); |
|
|
1484
|
+ $out[] = $this->mkTypeSelect('SET[queryGroup]', $this->extFieldLists['queryGroup'], ''); |
|
1485
|
1485
|
$out[] = '</div>'; |
|
1486
|
1486
|
} |
|
1487
|
1487
|
if (in_array('order', $enableArr) && !$userTsConfig['mod.']['dbint.']['disableOrderBy']) { |
|
@@ -1491,7 +1491,7 @@ discard block |
|
|
block discarded – undo |
|
1491
|
1491
|
$orderBy[] = $this->mkTypeSelect('SET[queryOrder]', $orderByArr[0], ''); |
|
1492
|
1492
|
$orderBy[] = '<div class="checkbox">'; |
|
1493
|
1493
|
$orderBy[] = ' <label for="checkQueryOrderDesc">'; |
|
1494
|
|
- $orderBy[] = BackendUtility::getFuncCheck($module->id, 'SET[queryOrderDesc]', $modSettings['queryOrderDesc'], '', '', 'id="checkQueryOrderDesc"') . ' Descending'; |
|
|
1494
|
+ $orderBy[] = BackendUtility::getFuncCheck($module->id, 'SET[queryOrderDesc]', $modSettings['queryOrderDesc'], '', '', 'id="checkQueryOrderDesc"') . ' Descending'; |
|
1495
|
1495
|
$orderBy[] = ' </label>'; |
|
1496
|
1496
|
$orderBy[] = '</div>'; |
|
1497
|
1497
|
|
|
@@ -1499,13 +1499,13 @@ discard block |
|
|
block discarded – undo |
|
1499
|
1499
|
$orderBy[] = $this->mkTypeSelect('SET[queryOrder2]', $orderByArr[1], ''); |
|
1500
|
1500
|
$orderBy[] = '<div class="checkbox">'; |
|
1501
|
1501
|
$orderBy[] = ' <label for="checkQueryOrder2Desc">'; |
|
1502
|
|
- $orderBy[] = BackendUtility::getFuncCheck($module->id, 'SET[queryOrder2Desc]', $modSettings['queryOrder2Desc'], '', '', 'id="checkQueryOrder2Desc"') . ' Descending'; |
|
|
1502
|
+ $orderBy[] = BackendUtility::getFuncCheck($module->id, 'SET[queryOrder2Desc]', $modSettings['queryOrder2Desc'], '', '', 'id="checkQueryOrder2Desc"') . ' Descending'; |
|
1503
|
1503
|
$orderBy[] = ' </label>'; |
|
1504
|
1504
|
$orderBy[] = '</div>'; |
|
1505
|
1505
|
} |
|
1506
|
1506
|
$out[] = '<div class="form-group form-inline">'; |
|
1507
|
1507
|
$out[] = ' <label>Order By:</label>'; |
|
1508
|
|
- $out[] = implode(LF, $orderBy); |
|
|
1508
|
+ $out[] = implode(LF, $orderBy); |
|
1509
|
1509
|
$out[] = '</div>'; |
|
1510
|
1510
|
} |
|
1511
|
1511
|
if (in_array('limit', $enableArr) && !$userTsConfig['mod.']['dbint.']['disableLimit']) { |
|
@@ -1539,10 +1539,10 @@ discard block |
|
|
block discarded – undo |
|
1539
|
1539
|
$out[] = '<div class="form-group">'; |
|
1540
|
1540
|
$out[] = ' <label>Limit:</label>'; |
|
1541
|
1541
|
$out[] = ' <div class="form-inline">'; |
|
1542
|
|
- $out[] = implode(LF, $limit); |
|
|
1542
|
+ $out[] = implode(LF, $limit); |
|
1543
|
1543
|
$out[] = ' <div class="btn-group t3js-limit-submit">'; |
|
1544
|
|
- $out[] = $prevButton; |
|
1545
|
|
- $out[] = $nextButton; |
|
|
1544
|
+ $out[] = $prevButton; |
|
|
1545
|
+ $out[] = $nextButton; |
|
1546
|
1546
|
$out[] = ' </div>'; |
|
1547
|
1547
|
$out[] = ' <div class="btn-group t3js-limit-submit">'; |
|
1548
|
1548
|
$out[] = ' <input type="button" class="btn btn-default" data-value="10" value="10">'; |