1 /* vim: set expandtab sw=4 ts=4 sts=4: */
3 * @fileoverview functions used on the server databases list page
4 * @name Server Databases
8 * @required js/functions.js
12 * Unbind all event handlers before tearing down a page
14 AJAX.registerTeardown('server_databases.js', function () {
15 $(document).off('submit', "#dbStatsForm");
16 $(document).off('submit', '#create_database_form.ajax');
17 $('#filterText').unbind('keyup');
21 * AJAX scripts for server_databases.php
23 * Actions ajaxified here:
27 AJAX.registerOnload('server_databases.js', function () {
29 * Attach Event Handler for 'Drop Databases'
31 $(document).on('submit', "#dbStatsForm", function (event) {
32 event.preventDefault();
37 * @var selected_dbs Array containing the names of the checked databases
39 var selected_dbs = [];
40 // loop over all checked checkboxes, except the .checkall_box checkbox
41 $form.find('input:checkbox:checked:not(.checkall_box)').each(function () {
42 $(this).closest('tr').addClass('removeMe');
43 selected_dbs[selected_dbs.length] = 'DROP DATABASE `' + escapeHtml($(this).val()) + '`;';
45 if (! selected_dbs.length) {
47 $('<div class="notice" />').text(
48 PMA_messages.strNoDatabasesSelected
55 * @var question String containing the question to be asked for confirmation
57 var question = PMA_messages.strDropDatabaseStrongWarning + ' ' +
58 PMA_sprintf(PMA_messages.strDoYouReally, selected_dbs.join('<br />'));
62 $form.prop('action') + '?' + $(this).serialize() +
63 '&drop_selected_dbs=1&is_js_confirmed=1&ajax_request=true',
65 PMA_ajaxShowMessage(PMA_messages.strProcessingRequest, false);
67 var params = getJSConfirmCommonParam(this);
68 params.token = PMA_commonParams.get('token');
70 $.post(url, params, function (data) {
71 if (typeof data !== 'undefined' && data.success === true) {
72 PMA_ajaxShowMessage(data.message);
74 var $rowsToRemove = $form.find('tr.removeMe');
75 var $databasesCount = $('#databases_count');
76 var newCount = parseInt($databasesCount.text(), 10) - $rowsToRemove.length;
77 $databasesCount.text(newCount);
79 $rowsToRemove.remove();
80 $form.find('tbody').PMA_sort_table('.name');
81 if ($form.find('tbody').find('tr').length === 0) {
82 // user just dropped the last db on this page
83 PMA_commonActions.refreshMain();
85 PMA_reloadNavigation();
87 $form.find('tr.removeMe').removeClass('removeMe');
88 PMA_ajaxShowMessage(data.error, false);
92 ); // end $.PMA_confirm()
93 }); //end of Drop Database action
96 * Attach Ajax event handlers for 'Create Database'.
98 $(document).on('submit', '#create_database_form.ajax', function (event) {
99 event.preventDefault();
103 // TODO Remove this section when all browsers support HTML5 "required" property
104 var newDbNameInput = $form.find('input[name=new_db]');
105 if (newDbNameInput.val() === '') {
106 newDbNameInput.focus();
107 alert(PMA_messages.strFormEmpty);
112 PMA_ajaxShowMessage(PMA_messages.strProcessingRequest);
113 PMA_prepareForAjaxRequest($form);
115 $.post($form.attr('action'), $form.serialize(), function (data) {
116 if (typeof data !== 'undefined' && data.success === true) {
117 PMA_ajaxShowMessage(data.message);
119 var $databases_count_object = $('#databases_count');
120 var databases_count = parseInt($databases_count_object.text(), 10) + 1;
121 $databases_count_object.text(databases_count);
122 PMA_reloadNavigation();
124 // make ajax request to load db structure page - taken from ajax.js
125 var dbStruct_url = data.url_query;
126 dbStruct_url = dbStruct_url.replace(/amp;/ig, '');
127 var params = 'ajax_request=true&ajax_page_request=true';
128 if (! (history && history.pushState)) {
129 params += PMA_MicroHistory.menus.getRequestParam();
131 $.get(dbStruct_url, params, AJAX.responseHandler);
133 PMA_ajaxShowMessage(data.error, false);
136 }); // end $(document).on()
138 /* Don't show filter if number of databases are very few */
139 var databasesCount = $('#databases_count').html();
140 if(databasesCount <= 10) {
141 $('#tableFilter').hide();
144 var $filterField = $('#filterText');
145 /* Event handler for database filter */
146 $filterField.keyup(function (){
147 var textFilter = null, val = $(this).val();
148 if(val.length != 0) {
150 textFilter = new RegExp(val.replace(/_/g, ' '), 'i');
151 $(this).removeClass('error');
153 if (e instanceof SyntaxError) {
154 $(this).addClass('error');
159 filterVariables(textFilter);
162 /* Trigger filtering of the list based on incoming database name */
163 if ($filterField.val()) {
164 $filterField.trigger('keyup').select();
167 /* Filters the rows by the user given regexp */
168 function filterVariables(textFilter) {
169 var $row, databasesCount = 0;
170 $('#tabledatabases').find('.db-row').each(function () {
172 if (textFilter === null ||
173 textFilter.exec($row.find('.name').text())
175 $row.css('display', '');
178 $row.css('display', 'none');
180 $('#databases_count').html(databasesCount);