From 07d1f1236c11b4261ab2b954a91278711a24901c Mon Sep 17 00:00:00 2001
From: winter
Date: Sun, 11 May 2025 20:25:11 +0100
Subject: sql console in admin menu + other misc

---
 templates/admin/overview_page.php    |  4 ++++
 templates/admin/sql_console_form.php | 45 ++++++++++++++++++++++++++++++++++++
 templates/admin/sql_console_page.php |  4 ++++
 3 files changed, 53 insertions(+)
 create mode 100644 templates/admin/sql_console_form.php
 create mode 100644 templates/admin/sql_console_page.php

(limited to 'templates')

diff --git a/templates/admin/overview_page.php b/templates/admin/overview_page.php
index d3325ef..6906e3c 100644
--- a/templates/admin/overview_page.php
+++ b/templates/admin/overview_page.php
@@ -8,6 +8,10 @@
             'icon' => 'extension-outline',
             'label' => __('admin.plugins.pageTitle'),
             'href' => '/admin/plugins'
+        ], [
+            'icon' => 'database-search-outline',
+            'label' => __('admin.sqlConsole.pageTitle'),
+            'href' => '/admin/sql-console'
         ]
     ]]);
 });
\ No newline at end of file
diff --git a/templates/admin/sql_console_form.php b/templates/admin/sql_console_form.php
new file mode 100644
index 0000000..3b27daa
--- /dev/null
+++ b/templates/admin/sql_console_form.php
@@ -0,0 +1,45 @@
+<form class="sqlQueryForm" hx-post="/fragment/admin/sql-console/query" hx-target="this" hx-swap="outerHTML"
+    hx-disabled-elt="find button">
+    <div class="row">
+        <div class="column">
+            <label for="sqlQueryInput"><?= __('admin.sqlConsole.query.label') ?></label>
+            <textarea id="sqlQueryInput" name="query" class="codeEdit"
+                autocomplete="off"><?= $_POST['query'] ?? '' ?></textarea>
+        </div>
+        <div class="column">
+            <button type="submit" class="primary"><?= __('admin.sqlConsole.query.action') ?></button>
+        </div>
+    </div>
+
+    <?php if (isset($error)) {
+        call_template('alertbox', ['variety' => 'error', 'message' => $error->getMessage()]);
+    } ?>
+
+    <?php if (isset($results)): ?>
+        <div class="row tableContainer">
+            <h3><?= __f('admin.sqlConsole.results.heading', count($results)) ?></h3>
+            <?php if (count($results) > 0): ?>
+                <div class="tableContainer">
+                    <table>
+                        <thead>
+                            <tr>
+                                <?php foreach ($results[0] as $header => $_): ?>
+                                    <th><?= htmlspecialchars($header) ?></th>
+                                <?php endforeach; ?>
+                            </tr>
+                        </thead>
+                        <tbody>
+                            <?php foreach ($results as $row): ?>
+                                <tr>
+                                    <?php foreach ($row as $value): ?>
+                                        <td><?= htmlspecialchars($value); ?></td>
+                                    <?php endforeach; ?>
+                                </tr>
+                            <?php endforeach; ?>
+                        </tbody>
+                    </table>
+                </div>
+            <?php endif; ?>
+        </div>
+    <?php endif; ?>
+</form>
\ No newline at end of file
diff --git a/templates/admin/sql_console_page.php b/templates/admin/sql_console_page.php
new file mode 100644
index 0000000..110e3ab
--- /dev/null
+++ b/templates/admin/sql_console_page.php
@@ -0,0 +1,4 @@
+<?php call_template('skeleton', ['pageTitle' => __('admin.sqlConsole.pageTitle')], function () {
+    call_template('alertbox', ['variety' => 'info', 'message' => __('admin.sqlConsole.info')]);
+    call_template('admin/sql_console_form');
+});
\ No newline at end of file
-- 
cgit v1.3