diff options
Diffstat (limited to 'srcs/phpmyadmin/js/database')
| -rw-r--r-- | srcs/phpmyadmin/js/database/central_columns.js | 241 | ||||
| -rw-r--r-- | srcs/phpmyadmin/js/database/multi_table_query.js | 222 | ||||
| -rw-r--r-- | srcs/phpmyadmin/js/database/operations.js | 167 | ||||
| -rw-r--r-- | srcs/phpmyadmin/js/database/qbe.js | 87 | ||||
| -rw-r--r-- | srcs/phpmyadmin/js/database/query_generator.js | 131 | ||||
| -rw-r--r-- | srcs/phpmyadmin/js/database/search.js | 248 | ||||
| -rw-r--r-- | srcs/phpmyadmin/js/database/structure.js | 429 | ||||
| -rw-r--r-- | srcs/phpmyadmin/js/database/tracking.js | 93 |
8 files changed, 0 insertions, 1618 deletions
diff --git a/srcs/phpmyadmin/js/database/central_columns.js b/srcs/phpmyadmin/js/database/central_columns.js deleted file mode 100644 index 15f95de..0000000 --- a/srcs/phpmyadmin/js/database/central_columns.js +++ /dev/null @@ -1,241 +0,0 @@ -/* vim: set expandtab sw=4 ts=4 sts=4: */ -/** - * @fileoverview events handling from central columns page - * @name Central columns - * - * @requires jQuery - */ - -/** - * AJAX scripts for db_central_columns.php - * - * Actions ajaxified here: - * Inline Edit and save of a result row - * Delete a row - * Multiple edit and delete option - * - */ - -AJAX.registerTeardown('database/central_columns.js', function () { - $('.edit').off('click'); - $('.edit_save_form').off('click'); - $('.edit_cancel_form').off('click'); - $('.del_row').off('click'); - $(document).off('keyup', '.filter_rows'); - $('.edit_cancel_form').off('click'); - $('#table-select').off('change'); - $('#column-select').off('change'); - $('#add_col_div').find('>a').off('click'); - $('#add_new').off('submit'); - $('#multi_edit_central_columns').off('submit'); - $('select.default_type').off('change'); - $('button[name=\'delete_central_columns\']').off('click'); - $('button[name=\'edit_central_columns\']').off('click'); -}); - -AJAX.registerOnload('database/central_columns.js', function () { - $('#tableslistcontainer input,#tableslistcontainer select,#tableslistcontainer .default_value,#tableslistcontainer .open_enum_editor').hide(); - $('#tableslistcontainer').find('.checkall').show(); - $('#tableslistcontainer').find('.checkall_box').show(); - if ($('#table_columns').find('tbody tr').length > 0) { - $('#table_columns').tablesorter({ - headers: { - 0: { sorter: false }, - 1: { sorter: false }, // hidden column - 4: { sorter: 'integer' } - } - }); - } - $('#tableslistcontainer').find('button[name="delete_central_columns"]').on('click', function (event) { - event.preventDefault(); - var multiDeleteColumns = $('.checkall:checkbox:checked').serialize(); - if (multiDeleteColumns === '') { - Functions.ajaxShowMessage(Messages.strRadioUnchecked); - return false; - } - Functions.ajaxShowMessage(); - $('#del_col_name').val(multiDeleteColumns); - $('#del_form').trigger('submit'); - }); - $('#tableslistcontainer').find('button[name="edit_central_columns"]').on('click', function (event) { - event.preventDefault(); - var editColumnList = $('.checkall:checkbox:checked').serialize(); - if (editColumnList === '') { - Functions.ajaxShowMessage(Messages.strRadioUnchecked); - return false; - } - var argsep = CommonParams.get('arg_separator'); - var editColumnData = editColumnList + '' + argsep + 'edit_central_columns_page=true' + argsep + 'ajax_request=true' + argsep + 'ajax_page_request=true' + argsep + 'db=' + encodeURIComponent(CommonParams.get('db')); - Functions.ajaxShowMessage(); - AJAX.source = $(this); - $.post('db_central_columns.php', editColumnData, AJAX.responseHandler); - }); - $('#multi_edit_central_columns').submit(function (event) { - event.preventDefault(); - event.stopPropagation(); - var argsep = CommonParams.get('arg_separator'); - var multiColumnEditData = $('#multi_edit_central_columns').serialize() + argsep + 'multi_edit_central_column_save=true' + argsep + 'ajax_request=true' + argsep + 'ajax_page_request=true' + argsep + 'db=' + encodeURIComponent(CommonParams.get('db')); - Functions.ajaxShowMessage(); - AJAX.source = $(this); - $.post('db_central_columns.php', multiColumnEditData, AJAX.responseHandler); - }); - $('#add_new').find('td').each(function () { - if ($(this).attr('name') !== 'undefined') { - $(this).find('input,select:first').attr('name', $(this).attr('name')); - } - }); - $('#field_0_0').attr('required','required'); - $('#add_new input[type="text"], #add_new input[type="number"], #add_new select') - .css({ - 'width' : '10em', - '-moz-box-sizing' : 'border-box' - }); - window.scrollTo(0, 0); - $(document).on('keyup', '.filter_rows', function () { - // get the column names - var cols = $('th.column_heading').map(function () { - return $.trim($(this).text()); - }).get(); - $.uiTableFilter($('#table_columns'), $(this).val(), cols, null, 'td span'); - }); - $('.edit').on('click', function () { - var rownum = $(this).parent().data('rownum'); - $('#save_' + rownum).show(); - $(this).hide(); - $('#f_' + rownum + ' td span').hide(); - $('#f_' + rownum + ' input, #f_' + rownum + ' select, #f_' + rownum + ' .open_enum_editor').show(); - var attributeVal = $('#f_' + rownum + ' td[name=col_attribute] span').html(); - $('#f_' + rownum + ' select[name=field_attribute\\[' + rownum + '\\] ] option[value="' + attributeVal + '"]').attr('selected','selected'); - if ($('#f_' + rownum + ' .default_type').val() === 'USER_DEFINED') { - $('#f_' + rownum + ' .default_type').siblings('.default_value').show(); - } else { - $('#f_' + rownum + ' .default_type').siblings('.default_value').hide(); - } - }); - $('.del_row').on('click', function (event) { - event.preventDefault(); - event.stopPropagation(); - var $td = $(this); - var question = Messages.strDeleteCentralColumnWarning; - $td.confirm(question, null, function () { - var rownum = $td.data('rownum'); - $('#del_col_name').val('selected_fld%5B%5D=' + $('#checkbox_row_' + rownum).val()); - $('#del_form').trigger('submit'); - }); - }); - $('.edit_cancel_form').on('click', function (event) { - event.preventDefault(); - event.stopPropagation(); - var rownum = $(this).data('rownum'); - $('#save_' + rownum).hide(); - $('#edit_' + rownum).show(); - $('#f_' + rownum + ' td span').show(); - $('#f_' + rownum + ' input, #f_' + rownum + ' select,#f_' + rownum + ' .default_value, #f_' + rownum + ' .open_enum_editor').hide(); - $('#tableslistcontainer').find('.checkall').show(); - }); - $('.edit_save_form').on('click', function (event) { - event.preventDefault(); - event.stopPropagation(); - var rownum = $(this).data('rownum'); - $('#f_' + rownum + ' td').each(function () { - if ($(this).attr('name') !== 'undefined') { - $(this).find(':input[type!="hidden"],select:first') - .attr('name', $(this).attr('name')); - } - }); - - if ($('#f_' + rownum + ' .default_type').val() === 'USER_DEFINED') { - $('#f_' + rownum + ' .default_type').attr('name','col_default_sel'); - } else { - $('#f_' + rownum + ' .default_value').attr('name','col_default_val'); - } - - var datastring = $('#f_' + rownum + ' :input').serialize(); - $.ajax({ - type: 'POST', - url: 'db_central_columns.php', - data: datastring + CommonParams.get('arg_separator') + 'ajax_request=true', - dataType: 'json', - success: function (data) { - if (data.message !== '1') { - Functions.ajaxShowMessage( - '<div class="error">' + - data.message + - '</div>', - false - ); - } else { - $('#f_' + rownum + ' td input[id=checkbox_row_' + rownum + ']').val($('#f_' + rownum + ' input[name=col_name]').val()).html(); - $('#f_' + rownum + ' td[name=col_name] span').text($('#f_' + rownum + ' input[name=col_name]').val()).html(); - $('#f_' + rownum + ' td[name=col_type] span').text($('#f_' + rownum + ' select[name=col_type]').val()).html(); - $('#f_' + rownum + ' td[name=col_length] span').text($('#f_' + rownum + ' input[name=col_length]').val()).html(); - $('#f_' + rownum + ' td[name=collation] span').text($('#f_' + rownum + ' select[name=collation]').val()).html(); - $('#f_' + rownum + ' td[name=col_attribute] span').text($('#f_' + rownum + ' select[name=col_attribute]').val()).html(); - $('#f_' + rownum + ' td[name=col_isNull] span').text($('#f_' + rownum + ' input[name=col_isNull]').is(':checked') ? 'Yes' : 'No').html(); - $('#f_' + rownum + ' td[name=col_extra] span').text($('#f_' + rownum + ' input[name=col_extra]').is(':checked') ? 'auto_increment' : '').html(); - $('#f_' + rownum + ' td[name=col_default] span').text($('#f_' + rownum + ' :input[name=col_default]').val()).html(); - } - $('#save_' + rownum).hide(); - $('#edit_' + rownum).show(); - $('#f_' + rownum + ' td span').show(); - $('#f_' + rownum + ' input, #f_' + rownum + ' select,#f_' + rownum + ' .default_value, #f_' + rownum + ' .open_enum_editor').hide(); - $('#tableslistcontainer').find('.checkall').show(); - }, - error: function () { - Functions.ajaxShowMessage( - '<div class="error">' + - Messages.strErrorProcessingRequest + - '</div>', - false - ); - } - }); - }); - $('#table-select').on('change', function () { - var selectValue = $(this).val(); - var defaultColumnSelect = $('#column-select').find('option:first'); - var href = 'db_central_columns.php'; - var params = { - 'ajax_request' : true, - 'server' : CommonParams.get('server'), - 'db' : CommonParams.get('db'), - 'selectedTable' : selectValue, - 'populateColumns' : true - }; - $('#column-select').html('<option value="">' + Messages.strLoading + '</option>'); - if (selectValue !== '') { - $.post(href, params, function (data) { - $('#column-select').empty().append(defaultColumnSelect); - $('#column-select').append(data.message); - }); - } - }); - $('#add_column').submit(function (e) { - var selectvalue = $('#column-select').val(); - if (selectvalue === '') { - e.preventDefault(); - e.stopPropagation(); - } - }); - $('#add_col_div').find('>a').on('click', function () { - $('#add_new').slideToggle('slow'); - var $addColDivLinkSpan = $('#add_col_div').find('>a span'); - if ($addColDivLinkSpan.html() === '+') { - $addColDivLinkSpan.html('-'); - } else { - $addColDivLinkSpan.html('+'); - } - }); - $('#add_new').submit(function () { - $('#add_new').toggle(); - }); - $('#tableslistcontainer').find('select.default_type').on('change', function () { - if ($(this).val() === 'USER_DEFINED') { - $(this).siblings('.default_value').attr('name','col_default'); - $(this).attr('name','col_default_sel'); - } else { - $(this).attr('name','col_default'); - $(this).siblings('.default_value').attr('name','col_default_val'); - } - }); -}); diff --git a/srcs/phpmyadmin/js/database/multi_table_query.js b/srcs/phpmyadmin/js/database/multi_table_query.js deleted file mode 100644 index 34b793c..0000000 --- a/srcs/phpmyadmin/js/database/multi_table_query.js +++ /dev/null @@ -1,222 +0,0 @@ -/* 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 - * @requires js/database/query_generator.js - * - */ - -/* global generateFromBlock, generateWhereBlock */ // js/database/query_generator.js - -/** - * js file for handling AJAX and other events in db_multi_table_query.php - */ - -/** - * Unbind all event handlers before tearing down a page - */ -AJAX.registerTeardown('database/multi_table_query.js', function () { - $('.tableNameSelect').each(function () { - $(this).off('change'); - }); - $('#update_query_button').off('click'); - $('#add_column_button').off('click'); -}); - -AJAX.registerOnload('database/multi_table_query.js', function () { - var editor = Functions.getSqlEditor($('#MultiSqlquery'), {}, 'both'); - $('.CodeMirror-line').css('text-align', 'left'); - editor.setSize(-1, 50); - - var columnCount = 3; - Functions.initSlider(); - addNewColumnCallbacks(); - - $('#update_query_button').on('click', function () { - var columns = []; - var tableAliases = {}; - $('.tableNameSelect').each(function () { - var $show = $(this).siblings('.show_col').first(); - if ($(this).val() !== '' && $show.prop('checked')) { - var tableAlias = $(this).siblings('.table_alias').first().val(); - var columnAlias = $(this).siblings('.col_alias').first().val(); - - if (tableAlias !== '') { - columns.push([tableAlias, $(this).siblings('.columnNameSelect').first().val()]); - } else { - columns.push([$(this).val(), $(this).siblings('.columnNameSelect').first().val()]); - } - - columns[columns.length - 1].push(columnAlias); - - if ($(this).val() in tableAliases) { - if (!(tableAliases[$(this).val()].includes(tableAlias))) { - tableAliases[$(this).val()].push(tableAlias); - } - } else { - tableAliases[$(this).val()] = [tableAlias]; - } - } - }); - if (Object.keys(tableAliases).length === 0) { - Functions.ajaxShowMessage('Nothing selected', false, 'error'); - return; - } - - var foreignKeys; - $.ajax({ - type: 'GET', - async: false, - url: 'db_multi_table_query.php', - data: { - 'server': sessionStorage.server, - 'db': $('#db_name').val(), - 'tables': Object.keys(tableAliases), - 'ajax_request': '1', - 'token': CommonParams.get('token') - }, - success: function (response) { - foreignKeys = response.foreignKeyConstrains; - } - }); - - var query = 'SELECT ' + '`' + Functions.escapeBacktick(columns[0][0]) + '`.'; - if (columns[0][1] === '*') { - query += '*'; - } else { - query += '`' + Functions.escapeBacktick(columns[0][1]) + '`'; - } - if (columns[0][2] !== '') { - query += ' AS ' + columns[0][2]; - } - for (var i = 1; i < columns.length; i++) { - query += ', `' + Functions.escapeBacktick(columns[i][0]) + '`.'; - if (columns[i][1] === '*') { - query += '*'; - } else { - query += '`' + Functions.escapeBacktick(columns[i][1]) + '`'; - } - if (columns[i][2] !== '') { - query += ' AS `' + Functions.escapeBacktick(columns[0][2]) + '`'; - } - } - query += '\nFROM '; - - query += generateFromBlock(tableAliases, foreignKeys); - - var $criteriaColCount = $('.criteria_col:checked').length; - if ($criteriaColCount > 0) { - query += '\nWHERE '; - query += generateWhereBlock(); - } - - query += ';'; - editor.getDoc().setValue(query); - }); - - $('#submit_query').on('click', function () { - var query = editor.getDoc().getValue(); - // Verifying that the query is not empty - if (query === '') { - Functions.ajaxShowMessage(Messages.strEmptyQuery, false, 'error'); - return; - } - var data = { - 'db': $('#db_name').val(), - 'sql_query': query, - 'ajax_request': '1', - 'token': CommonParams.get('token') - }; - $.ajax({ - type: 'POST', - url: 'db_multi_table_query.php', - data: data, - success: function (data) { - var $resultsDom = $(data.message); - $resultsDom.find('.ajax:not(.pageselector)').each(function () { - $(this).on('click', function (event) { - event.preventDefault(); - }); - }); - $resultsDom.find('.autosubmit, .pageselector, .showAllRows, .filter_rows').each(function () { - $(this).on('change click select focus', function (event) { - event.preventDefault(); - }); - }); - $('#sql_results').html($resultsDom); - $('#page_content').find('a').first().trigger('click'); - } - }); - }); - - $('#add_column_button').on('click', function () { - columnCount++; - var $newColumnDom = $($('#new_column_layout').html()).clone(); - $newColumnDom.find('div').first().find('div').first().attr('id', columnCount.toString()); - $newColumnDom.find('a').first().remove(); - $newColumnDom.find('.pma_auto_slider').first().unwrap(); - $newColumnDom.find('.pma_auto_slider').first().attr('title', 'criteria'); - $('#add_column_button').parent().before($newColumnDom); - Functions.initSlider(); - addNewColumnCallbacks(); - }); - - function addNewColumnCallbacks () { - $('.tableNameSelect').each(function () { - $(this).on('change', function () { - var $sibs = $(this).siblings('.columnNameSelect'); - if ($sibs.length === 0) { - $sibs = $(this).parent().parent().find('.columnNameSelect'); - } - $sibs.first().html($('#' + $.md5($(this).val())).html()); - }); - }); - - $('.removeColumn').each(function () { - $(this).on('click', function () { - $(this).parent().remove(); - }); - }); - - $('a.ajax').each(function () { - $(this).on('click', function (event, from) { - if (from === null) { - var $checkbox = $(this).siblings('.criteria_col').first(); - $checkbox.prop('checked', !$checkbox.prop('checked')); - } - var $criteriaColCount = $('.criteria_col:checked').length; - if ($criteriaColCount > 1) { - $(this).siblings('.slide-wrapper').first().find('.logical_operator').first().css('display','table-row'); - } - }); - }); - - $('.criteria_col').each(function () { - $(this).on('change', function () { - var $anchor = $(this).siblings('a.ajax').first(); - $anchor.trigger('click', ['Trigger']); - }); - }); - - $('.criteria_rhs').each(function () { - $(this).on('change', function () { - var $rhsCol = $(this).parent().parent().siblings('.rhs_table').first(); - var $rhsText = $(this).parent().parent().siblings('.rhs_text').first(); - if ($(this).val() === 'text') { - $rhsCol.css('display', 'none'); - $rhsText.css('display', 'table-row'); - } else if ($(this).val() === 'anotherColumn') { - $rhsText.css('display', 'none'); - $rhsCol.css('display', 'table-row'); - } else { - $rhsText.css('display', 'none'); - $rhsCol.css('display', 'none'); - } - }); - }); - } -}); diff --git a/srcs/phpmyadmin/js/database/operations.js b/srcs/phpmyadmin/js/database/operations.js deleted file mode 100644 index e8f927c..0000000 --- a/srcs/phpmyadmin/js/database/operations.js +++ /dev/null @@ -1,167 +0,0 @@ -/* vim: set expandtab sw=4 ts=4 sts=4: */ -/** - * @fileoverview function used in server privilege pages - * @name Database Operations - * - * @requires jQuery - * @requires jQueryUI - * @requires js/functions.js - * - */ - -/** - * Ajax event handlers here for db_operations.php - * - * Actions Ajaxified here: - * Rename Database - * Copy Database - * Change Charset - * Drop Database - */ - -/** - * Unbind all event handlers before tearing down a page - */ -AJAX.registerTeardown('database/operations.js', function () { - $(document).off('submit', '#rename_db_form.ajax'); - $(document).off('submit', '#copy_db_form.ajax'); - $(document).off('submit', '#change_db_charset_form.ajax'); - $(document).off('click', '#drop_db_anchor.ajax'); -}); - -AJAX.registerOnload('database/operations.js', function () { - /** - * Ajax event handlers for 'Rename Database' - */ - $(document).on('submit', '#rename_db_form.ajax', function (event) { - event.preventDefault(); - - var oldDbName = CommonParams.get('db'); - var newDbName = $('#new_db_name').val(); - - if (newDbName === oldDbName) { - Functions.ajaxShowMessage(Messages.strDatabaseRenameToSameName, false, 'error'); - return false; - } - - var $form = $(this); - - var question = Functions.escapeHtml('CREATE DATABASE ' + newDbName + ' / DROP DATABASE ' + oldDbName); - - Functions.prepareForAjaxRequest($form); - - $form.confirm(question, $form.attr('action'), function (url) { - Functions.ajaxShowMessage(Messages.strRenamingDatabases, false); - $.post(url, $('#rename_db_form').serialize() + CommonParams.get('arg_separator') + 'is_js_confirmed=1', function (data) { - if (typeof data !== 'undefined' && data.success === true) { - Functions.ajaxShowMessage(data.message); - CommonParams.set('db', data.newname); - - Navigation.reload(function () { - $('#pma_navigation_tree') - .find('a:not(\'.expander\')') - .each(function () { - var $thisAnchor = $(this); - if ($thisAnchor.text() === data.newname) { - // simulate a click on the new db name - // in navigation - $thisAnchor.trigger('click'); - } - }); - }); - } else { - Functions.ajaxShowMessage(data.error, false); - } - }); // end $.post() - }); - }); // end Rename Database - - /** - * Ajax Event Handler for 'Copy Database' - */ - $(document).on('submit', '#copy_db_form.ajax', function (event) { - event.preventDefault(); - Functions.ajaxShowMessage(Messages.strCopyingDatabase, false); - var $form = $(this); - Functions.prepareForAjaxRequest($form); - $.post($form.attr('action'), $form.serialize(), function (data) { - // use messages that stay on screen - $('div.success, div.error').fadeOut(); - if (typeof data !== 'undefined' && data.success === true) { - if ($('#checkbox_switch').is(':checked')) { - CommonParams.set('db', data.newname); - CommonActions.refreshMain(false, function () { - Functions.ajaxShowMessage(data.message); - }); - } else { - CommonParams.set('db', data.db); - Functions.ajaxShowMessage(data.message); - } - Navigation.reload(); - } else { - Functions.ajaxShowMessage(data.error, false); - } - }); // end $.post() - }); // end copy database - - /** - * Change tables columns visible only if change tables is checked - */ - $('#span_change_all_tables_columns_collations').hide(); - $('#checkbox_change_all_tables_collations').on('click', function () { - $('#span_change_all_tables_columns_collations').toggle(); - }); - - /** - * Ajax Event handler for 'Change Charset' of the database - */ - $(document).on('submit', '#change_db_charset_form.ajax', function (event) { - event.preventDefault(); - var $form = $(this); - Functions.prepareForAjaxRequest($form); - Functions.ajaxShowMessage(Messages.strChangingCharset); - $.post($form.attr('action'), $form.serialize() + CommonParams.get('arg_separator') + 'submitcollation=1', function (data) { - if (typeof data !== 'undefined' && data.success === true) { - Functions.ajaxShowMessage(data.message); - } else { - Functions.ajaxShowMessage(data.error, false); - } - }); // end $.post() - }); // end change charset - - /** - * Ajax event handlers for Drop Database - */ - $(document).on('click', '#drop_db_anchor.ajax', function (event) { - event.preventDefault(); - var $link = $(this); - /** - * @var question String containing the question to be asked for confirmation - */ - var question = Messages.strDropDatabaseStrongWarning + ' '; - question += Functions.sprintf( - Messages.strDoYouReally, - 'DROP DATABASE `' + Functions.escapeHtml(CommonParams.get('db') + '`') - ); - var params = Functions.getJsConfirmCommonParam(this, $link.getPostData()); - - $(this).confirm(question, $(this).attr('href'), function (url) { - Functions.ajaxShowMessage(Messages.strProcessingRequest); - $.post(url, params, function (data) { - if (typeof data !== 'undefined' && data.success) { - // Database deleted successfully, refresh both the frames - Navigation.reload(); - CommonParams.set('db', ''); - CommonActions.refreshMain( - 'server_databases.php', - function () { - Functions.ajaxShowMessage(data.message); - } - ); - } else { - Functions.ajaxShowMessage(data.error, false); - } - }); - }); - }); -}); diff --git a/srcs/phpmyadmin/js/database/qbe.js b/srcs/phpmyadmin/js/database/qbe.js deleted file mode 100644 index 358c67c..0000000 --- a/srcs/phpmyadmin/js/database/qbe.js +++ /dev/null @@ -1,87 +0,0 @@ -/* 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'); -}); diff --git a/srcs/phpmyadmin/js/database/query_generator.js b/srcs/phpmyadmin/js/database/query_generator.js deleted file mode 100644 index 854686c..0000000 --- a/srcs/phpmyadmin/js/database/query_generator.js +++ /dev/null @@ -1,131 +0,0 @@ -/* 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 - * - */ - -/* global sprintf */ // js/vendor/sprintf.js - -function getFormatsText () { - return { - '=': ' = \'%s\'', - '>': ' > \'%s\'', - '>=': ' >= \'%s\'', - '<': ' < \'%s\'', - '<=': ' <= \'%s\'', - '!=': ' != \'%s\'', - 'LIKE': ' LIKE \'%s\'', - 'LIKE %...%': ' LIKE \'%%%s%%\'', - 'NOT LIKE': ' NOT LIKE \'%s\'', - 'BETWEEN': ' BETWEEN \'%s\'', - 'NOT BETWEEN': ' NOT BETWEEN \'%s\'', - 'IS NULL': ' \'%s\' IS NULL', - 'IS NOT NULL': ' \'%s\' IS NOT NULL', - 'REGEXP': ' REGEXP \'%s\'', - 'REGEXP ^...$': ' REGEXP \'^%s$\'', - 'NOT REGEXP': ' NOT REGEXP \'%s\'' - }; -} - -function generateCondition (criteriaDiv, table) { - var query = '`' + Functions.escapeBacktick(table.val()) + '`.'; - query += '`' + Functions.escapeBacktick(table.siblings('.columnNameSelect').first().val()) + '`'; - if (criteriaDiv.find('.criteria_rhs').first().val() === 'text') { - var formatsText = getFormatsText(); - query += sprintf(formatsText[criteriaDiv.find('.criteria_op').first().val()], Functions.escapeSingleQuote(criteriaDiv.find('.rhs_text_val').first().val())); - } else { - query += ' ' + criteriaDiv.find('.criteria_op').first().val(); - query += ' `' + Functions.escapeBacktick(criteriaDiv.find('.tableNameSelect').first().val()) + '`.'; - query += '`' + Functions.escapeBacktick(criteriaDiv.find('.columnNameSelect').first().val()) + '`'; - } - return query; -} - -// eslint-disable-next-line no-unused-vars -function generateWhereBlock () { - var count = 0; - var query = ''; - $('.tableNameSelect').each(function () { - var criteriaDiv = $(this).siblings('.slide-wrapper').first(); - var useCriteria = $(this).siblings('.criteria_col').first(); - if ($(this).val() !== '' && useCriteria.prop('checked')) { - if (count > 0) { - criteriaDiv.find('input.logical_op').each(function () { - if ($(this).prop('checked')) { - query += ' ' + $(this).val() + ' '; - } - }); - } - query += generateCondition(criteriaDiv, $(this)); - count++; - } - }); - return query; -} - -function generateJoin (newTable, tableAliases, fk) { - var query = ''; - query += ' \n\tLEFT JOIN ' + '`' + Functions.escapeBacktick(newTable) + '`'; - if (tableAliases[fk.TABLE_NAME][0] !== '') { - query += ' AS `' + Functions.escapeBacktick(tableAliases[newTable][0]) + '`'; - query += ' ON `' + Functions.escapeBacktick(tableAliases[fk.TABLE_NAME][0]) + '`'; - } else { - query += ' ON `' + Functions.escapeBacktick(fk.TABLE_NAME) + '`'; - } - query += '.`' + fk.COLUMN_NAME + '`'; - if (tableAliases[fk.REFERENCED_TABLE_NAME][0] !== '') { - query += ' = `' + Functions.escapeBacktick(tableAliases[fk.REFERENCED_TABLE_NAME][0]) + '`'; - } else { - query += ' = `' + Functions.escapeBacktick(fk.REFERENCED_TABLE_NAME) + '`'; - } - query += '.`' + fk.REFERENCED_COLUMN_NAME + '`'; - return query; -} - -function existReference (table, fk, usedTables) { - var isReferredBy = fk.TABLE_NAME === table && usedTables.includes(fk.REFERENCED_TABLE_NAME); - var isReferencedBy = fk.REFERENCED_TABLE_NAME === table && usedTables.includes(fk.TABLE_NAME); - return isReferredBy || isReferencedBy; -} - -function tryJoinTable (table, tableAliases, usedTables, foreignKeys) { - for (var i = 0; i < foreignKeys.length; i++) { - var fk = foreignKeys[i]; - if (existReference(table, fk, usedTables)) { - return generateJoin(table, tableAliases, fk); - } - } - return ''; -} - -function appendTable (table, tableAliases, usedTables, foreignKeys) { - var query = tryJoinTable (table, tableAliases, usedTables, foreignKeys); - if (query === '') { - if (usedTables.length > 0) { - query += '\n\t, '; - } - query += '`' + Functions.escapeBacktick(table) + '`'; - if (tableAliases[table][0] !== '') { - query += ' AS `' + Functions.escapeBacktick(tableAliases[table][0]) + '`'; - } - } - usedTables.push(table); - return query; -} - -// eslint-disable-next-line no-unused-vars -function generateFromBlock (tableAliases, foreignKeys) { - var usedTables = []; - var query = ''; - for (var table in tableAliases) { - if (tableAliases.hasOwnProperty(table)) { - query += appendTable(table, tableAliases, usedTables, foreignKeys); - } - } - return query; -} diff --git a/srcs/phpmyadmin/js/database/search.js b/srcs/phpmyadmin/js/database/search.js deleted file mode 100644 index 19e64e4..0000000 --- a/srcs/phpmyadmin/js/database/search.js +++ /dev/null @@ -1,248 +0,0 @@ -/* vim: set expandtab sw=4 ts=4 sts=4: */ -/** - * JavaScript functions used on Database Search page - * - * @requires jQuery - * @requires js/functions.js - * - * @package PhpMyAdmin - */ - -/* global makeGrid */ // js/makegrid.js - -/** - * AJAX script for the Database Search page. - * - * Actions ajaxified here: - * Retrieve result of SQL query - */ - -/** - * Unbind all ev |