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/sql_console_form.php | 45 ++++++++++++++++++++++++++++++++++++
 1 file changed, 45 insertions(+)
 create mode 100644 templates/admin/sql_console_form.php

(limited to 'templates/admin/sql_console_form.php')

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
-- 
cgit v1.3