From 04d6d5ca99ebfd1cebb8ce06618fb3811fc1a8aa Mon Sep 17 00:00:00 2001
From: Charles <sircharlesaze@gmail.com>
Date: Thu, 9 Jan 2020 10:55:03 +0100
Subject: phpmyadmin working

---
 srcs/phpmyadmin/js/database/qbe.js | 87 ++++++++++++++++++++++++++++++++++++++
 1 file changed, 87 insertions(+)
 create mode 100644 srcs/phpmyadmin/js/database/qbe.js

(limited to 'srcs/phpmyadmin/js/database/qbe.js')

diff --git a/srcs/phpmyadmin/js/database/qbe.js b/srcs/phpmyadmin/js/database/qbe.js
new file mode 100644
index 0000000..358c67c
--- /dev/null
+++ b/srcs/phpmyadmin/js/database/qbe.js
@@ -0,0 +1,87 @@
+/* vim: set expandtab sw=4 ts=4 sts=4: */
+/**
+ * @fileoverview    function used in QBE for DB
+ * @name            Database Operations
+ *
+ * @requires    jQuery
+ * @requires    jQueryUI
+ * @requires    js/functions.js
+ *
+ */
+
+/**
+ * Ajax event handlers here for db_qbe.php
+ *
+ * Actions Ajaxified here:
+ * Select saved search
+ */
+
+/**
+ * Unbind all event handlers before tearing down a page
+ */
+AJAX.registerTeardown('database/qbe.js', function () {
+    $(document).off('change', 'select[name^=criteriaColumn]');
+    $(document).off('change', '#searchId');
+    $(document).off('click', '#saveSearch');
+    $(document).off('click', '#updateSearch');
+    $(document).off('click', '#deleteSearch');
+});
+
+AJAX.registerOnload('database/qbe.js', function () {
+    Functions.getSqlEditor($('#textSqlquery'), {}, 'none');
+
+    $('#tblQbe').width($('#tblQbe').parent().width());
+    $('#tblQbeFooters').width($('#tblQbeFooters').parent().width());
+    $('#tblQbe').resize(function () {
+        var newWidthTblQbe = $('#textSqlquery').next().width();
+        $('#tblQbe').width(newWidthTblQbe);
+        $('#tblQbeFooters').width(newWidthTblQbe);
+    });
+
+    /**
+     * Ajax handler to check the corresponding 'show' checkbox when column is selected
+     */
+    $(document).on('change', 'select[name^=criteriaColumn]', function () {
+        if ($(this).val()) {
+            var index = (/\d+/).exec($(this).attr('name'));
+            $('input[name=criteriaShow\\[' + index + '\\]]').prop('checked', true);
+        }
+    });
+
+    /**
+     * Ajax event handlers for 'Select saved search'
+     */
+    $(document).on('change', '#searchId', function () {
+        $('#action').val('load');
+        $('#formQBE').trigger('submit');
+    });
+
+    /**
+     * Ajax event handlers for 'Create bookmark'
+     */
+    $(document).on('click', '#saveSearch', function () {
+        $('#action').val('create');
+    });
+
+    /**
+     * Ajax event handlers for 'Update bookmark'
+     */
+    $(document).on('click', '#updateSearch', function () {
+        $('#action').val('update');
+    });
+
+    /**
+     * Ajax event handlers for 'Delete bookmark'
+     */
+    $(document).on('click', '#deleteSearch', function () {
+        var question = Functions.sprintf(Messages.strConfirmDeleteQBESearch, $('#searchId').find('option:selected').text());
+        if (!confirm(question)) {
+            return false;
+        }
+
+        $('#action').val('delete');
+    });
+
+    var windowwidth = $(window).width();
+    $('.jsresponsive').css('max-width', (windowwidth - 35) + 'px');
+});
-- 
cgit