diff options
| author | Charles <sircharlesaze@gmail.com> | 2020-01-09 10:55:03 +0100 |
|---|---|---|
| committer | Charles <sircharlesaze@gmail.com> | 2020-01-09 13:09:38 +0100 |
| commit | 04d6d5ca99ebfd1cebb8ce06618fb3811fc1a8aa (patch) | |
| tree | 5c691241355c943a3c68ddb06b8cf8c60aa11319 /srcs/phpmyadmin/js/server/databases.js | |
| parent | 7e0d85db834d6351ed85d01e5126ac31dc510b86 (diff) | |
| download | ft_server-04d6d5ca99ebfd1cebb8ce06618fb3811fc1a8aa.tar.gz ft_server-04d6d5ca99ebfd1cebb8ce06618fb3811fc1a8aa.tar.bz2 ft_server-04d6d5ca99ebfd1cebb8ce06618fb3811fc1a8aa.zip | |
phpmyadmin working
Diffstat (limited to 'srcs/phpmyadmin/js/server/databases.js')
| -rw-r--r-- | srcs/phpmyadmin/js/server/databases.js | 152 |
1 files changed, 152 insertions, 0 deletions
diff --git a/srcs/phpmyadmin/js/server/databases.js b/srcs/phpmyadmin/js/server/databases.js new file mode 100644 index 0000000..1a943ce --- /dev/null +++ b/srcs/phpmyadmin/js/server/databases.js @@ -0,0 +1,152 @@ +/* vim: set expandtab sw=4 ts=4 sts=4: */ +/** + * @fileoverview functions used on the server databases list page + * @name Server Databases + * + * @requires jQuery + * @requires jQueryUI + * @required js/functions.js + */ + +/* global MicroHistory */ // js/microhistory.js + +/** + * Unbind all event handlers before tearing down a page + */ +AJAX.registerTeardown('server/databases.js', function () { + $(document).off('submit', '#dbStatsForm'); + $(document).off('submit', '#create_database_form.ajax'); +}); + +/** + * AJAX scripts for server_databases.php + * + * Actions ajaxified here: + * Drop Databases + * + */ +AJAX.registerOnload('server/databases.js', function () { + /** + * Attach Event Handler for 'Drop Databases' + */ + $(document).on('submit', '#dbStatsForm', function (event) { + event.preventDefault(); + + var $form = $(this); + + /** + * @var selected_dbs Array containing the names of the checked databases + */ + var selectedDbs = []; + // loop over all checked checkboxes, except the .checkall_box checkbox + $form.find('input:checkbox:checked:not(.checkall_box)').each(function () { + $(this).closest('tr').addClass('removeMe'); + selectedDbs[selectedDbs.length] = 'DROP DATABASE `' + Functions.escapeHtml($(this).val()) + '`;'; + }); + if (! selectedDbs.length) { + Functions.ajaxShowMessage( + $('<div class="notice"></div>').text( + Messages.strNoDatabasesSelected + ), + 2000 + ); + return; + } + /** + * @var question String containing the question to be asked for confirmation + */ + var question = Messages.strDropDatabaseStrongWarning + ' ' + + Functions.sprintf(Messages.strDoYouReally, selectedDbs.join('<br>')); + + var argsep = CommonParams.get('arg_separator'); + $(this).confirm( + question, + $form.prop('action') + '?' + $(this).serialize() + + argsep + 'drop_selected_dbs=1', + function (url) { + Functions.ajaxShowMessage(Messages.strProcessingRequest, false); + + var parts = url.split('?'); + var params = Functions.getJsConfirmCommonParam(this, parts[1]); + + $.post(parts[0], params, function (data) { + if (typeof data !== 'undefined' && data.success === true) { + Functions.ajaxShowMessage(data.message); + + var $rowsToRemove = $form.find('tr.removeMe'); + var $databasesCount = $('#filter-rows-count'); + var newCount = parseInt($databasesCount.text(), 10) - $rowsToRemove.length; + $databasesCount.text(newCount); + + $rowsToRemove.remove(); + $form.find('tbody').sortTable('.name'); + if ($form.find('tbody').find('tr').length === 0) { + // user just dropped the last db on this page + CommonActions.refreshMain(); + } + Navigation.reload(); + } else { + $form.find('tr.removeMe').removeClass('removeMe'); + Functions.ajaxShowMessage(data.error, false); + } + }); // end $.post() + } + ); + }); // end of Drop Database action + + /** + * Attach Ajax event handlers for 'Create Database'. + */ + $(document).on('submit', '#create_database_form.ajax', function (event) { + event.preventDefault(); + + var $form = $(this); + + // TODO Remove this section when all browsers support HTML5 "required" property + var newDbNameInput = $form.find('input[name=new_db]'); + if (newDbNameInput.val() === '') { + newDbNameInput.trigger('focus'); + alert(Messages.strFormEmpty); + return; + } + // end remove + + Functions.ajaxShowMessage(Messages.strProcessingRequest); + Functions.prepareForAjaxRequest($form); + + $.post($form.attr('action'), $form.serialize(), function (data) { + if (typeof data !== 'undefined' && data.success === true) { + Functions.ajaxShowMessage(data.message); + + var $databasesCountObject = $('#filter-rows-count'); + var databasesCount = parseInt($databasesCountObject.text(), 10) + 1; + $databasesCountObject.text(databasesCount); + Navigation.reload(); + + // make ajax request to load db structure page - taken from ajax.js + var dbStructUrl = data.url_query; + dbStructUrl = dbStructUrl.replace(/amp;/ig, ''); + var params = 'ajax_request=true' + CommonParams.get('arg_separator') + 'ajax_page_request=true'; + if (! (history && history.pushState)) { + params += MicroHistory.menus.getRequestParam(); + } + $.get(dbStructUrl, params, AJAX.responseHandler); + } else { + Functions.ajaxShowMessage(data.error, false); + } + }); // end $.post() + }); // end $(document).on() + + /* Don't show filter if number of databases are very few */ + var databasesCount = $('#filter-rows-count').html(); + if (databasesCount <= 10) { + $('#tableFilter').hide(); + } + + var tableRows = $('.server_databases'); + $.each(tableRows, function () { + $(this).on('click', function () { + CommonActions.setDb($(this).attr('data')); + }); + }); +}); // end $() |
