diff options
Diffstat (limited to 'hugo/js/tbl_structure.js')
| -rw-r--r-- | hugo/js/tbl_structure.js | 420 |
1 files changed, 420 insertions, 0 deletions
diff --git a/hugo/js/tbl_structure.js b/hugo/js/tbl_structure.js new file mode 100644 index 0000000..7b1433e --- /dev/null +++ b/hugo/js/tbl_structure.js @@ -0,0 +1,420 @@ +/* vim: set expandtab sw=4 ts=4 sts=4: */ +/** + * @fileoverview functions used on the table structure page + * @name Table Structure + * + * @requires jQuery + * @requires jQueryUI + * @required js/functions.js + */ + +/** + * AJAX scripts for tbl_structure.php + * + * Actions ajaxified here: + * Drop Column + * Add Primary Key + * Drop Primary Key/Index + * + */ + +/** + * Unbind all event handlers before tearing down a page + */ +AJAX.registerTeardown('tbl_structure.js', function() { + $("a.change_column_anchor.ajax").die('click'); + $("button.change_columns_anchor.ajax, input.change_columns_anchor.ajax").die('click'); + $("a.drop_column_anchor.ajax").die('click'); + $("a.add_primary_key_anchor.ajax").die('click'); + $("#move_columns_anchor").die('click'); + $(".append_fields_form.ajax").unbind('submit'); +}); + +AJAX.registerOnload('tbl_structure.js', function() { + + /** + *Ajax action for submitting the "Column Change" and "Add Column" form + */ + $(".append_fields_form.ajax").die().live('submit', function(event) { + event.preventDefault(); + /** + * @var the_form object referring to the export form + */ + var $form = $(this); + + /* + * First validate the form; if there is a problem, avoid submitting it + * + * checkTableEditForm() needs a pure element and not a jQuery object, + * this is why we pass $form[0] as a parameter (the jQuery object + * is actually an array of DOM elements) + */ + if (checkTableEditForm($form[0], $form.find('input[name=orig_num_fields]').val())) { + // OK, form passed validation step + PMA_prepareForAjaxRequest($form); + //User wants to submit the form + $msg = PMA_ajaxShowMessage(); + $.post($form.attr('action'), $form.serialize() + '&do_save_data=1', function(data) { + if ($("#sqlqueryresults").length != 0) { + $("#sqlqueryresults").remove(); + } else if ($(".error:not(.tab)").length != 0) { + $(".error:not(.tab)").remove(); + } + if (data.success == true) { + $("#page_content") + .empty() + .append(data.message) + .append(data.sql_query) + .show(); + $("#result_query .notice").remove(); + $form.remove(); + PMA_ajaxRemoveMessage($msg); + PMA_reloadNavigation(); + } else { + PMA_ajaxShowMessage(data.error, false); + } + }); // end $.post() + } + }); // end change table button "do_save_data" + + /** + * Attach Event Handler for 'Change Column' + */ + $("a.change_column_anchor.ajax").live('click', function(event) { + event.preventDefault(); + var $msg = PMA_ajaxShowMessage(); + $('#page_content').hide(); + $.get($(this).attr('href'), {'ajax_request': true}, function (data) { + PMA_ajaxRemoveMessage($msg); + if (data.success) { + $('<div id="change_column_dialog" class="margin"></div>') + .html(data.message) + .insertBefore('#page_content'); + PMA_showHints(); + PMA_verifyColumnsProperties(); + } else { + PMA_ajaxShowMessage(PMA_messages['strErrorProcessingRequest'] + " : " + data.error, false); + } + }); + }); + + /** + * Attach Event Handler for 'Change multiple columns' + */ + $("button.change_columns_anchor.ajax, input.change_columns_anchor.ajax").live('click', function(event) { + event.preventDefault(); + var $msg = PMA_ajaxShowMessage(); + $('#page_content').hide(); + var $form = $(this).closest('form'); + var params = $form.serialize() + "&ajax_request=true&submit_mult=change"; + $.post($form.prop("action"), params, function (data) { + PMA_ajaxRemoveMessage($msg); + if (data.success) { + $('#page_content') + .empty() + .append( + $('<div id="change_column_dialog"></div>') + .html(data.message) + ) + .show(); + PMA_showHints(); + PMA_verifyColumnsProperties(); + } else { + $('#page_content').show(); + PMA_ajaxShowMessage(data.error); + } + }); + }); + + /** + * Attach Event Handler for 'Drop Column' + */ + $("a.drop_column_anchor.ajax").live('click', function(event) { + event.preventDefault(); + /** + * @var curr_table_name String containing the name of the current table + */ + var curr_table_name = $(this).closest('form').find('input[name=table]').val(); + /** + * @var curr_row Object reference to the currently selected row (i.e. field in the table) + */ + var $curr_row = $(this).parents('tr'); + /** + * @var curr_column_name String containing name of the field referred to by {@link curr_row} + */ + var curr_column_name = $curr_row.children('th').children('label').text(); + /** + * @var $after_field_item Corresponding entry in the 'After' field. + */ + var $after_field_item = $("select[name='after_field'] option[value='" + curr_column_name + "']"); + /** + * @var question String containing the question to be asked for confirmation + */ + var question = $.sprintf(PMA_messages['strDoYouReally'], 'ALTER TABLE `' + escapeHtml(curr_table_name) + '` DROP `' + escapeHtml(curr_column_name) + '`;'); + $(this).PMA_confirm(question, $(this).attr('href'), function(url) { + var $msg = PMA_ajaxShowMessage(PMA_messages['strDroppingColumn'], false); + $.get(url, {'is_js_confirmed' : 1, 'ajax_request' : true, 'ajax_page_request' : true}, function (data) { + if (data.success == true) { + PMA_ajaxRemoveMessage($msg); + if ($('#result_query').length) { + $('#result_query').remove(); + } + if (data.sql_query) { + $('<div id="result_query"></div>') + .html(data.sql_query) + .prependTo('#page_content'); + } + toggleRowColors($curr_row.next()); + // Adjust the row numbers + for (var $row = $curr_row.next(); $row.length > 0; $row = $row.next()) { + var new_val = parseInt($row.find('td:nth-child(2)').text()) - 1; + $row.find('td:nth-child(2)').text(new_val); + } + $after_field_item.remove(); + $curr_row.hide("medium").remove(); + //refresh table stats + if (data.tableStat) { + $('#tablestatistics').html(data.tableStat); + } + // refresh the list of indexes (comes from sql.php) + $('.index_info').replaceWith(data.indexes_list); + PMA_reloadNavigation(); + } else { + PMA_ajaxShowMessage(PMA_messages['strErrorProcessingRequest'] + " : " + data.error, false); + } + }); // end $.get() + }); // end $.PMA_confirm() + }) ; //end of Drop Column Anchor action + + /** + * Ajax Event handler for 'Add Primary Key' + */ + $("a.add_primary_key_anchor.ajax").live('click', function(event) { + event.preventDefault(); + /** + * @var curr_table_name String containing the name of the current table + */ + var curr_table_name = $(this).closest('form').find('input[name=table]').val(); + /** + * @var curr_column_name String containing name of the field referred to by {@link curr_row} + */ + var curr_column_name = $(this).parents('tr').children('th').children('label').text(); + /** + * @var question String containing the question to be asked for confirmation + */ + var question = $.sprintf(PMA_messages['strDoYouReally'], 'ALTER TABLE `' + escapeHtml(curr_table_name) + '` ADD PRIMARY KEY(`' + escapeHtml(curr_column_name) + '`);'); + $(this).PMA_confirm(question, $(this).attr('href'), function(url) { + var $msg = PMA_ajaxShowMessage(PMA_messages['strAddingPrimaryKey'], false); + $.get(url, {'is_js_confirmed' : 1, 'ajax_request' : true}, function(data) { + if (data.success == true) { + PMA_ajaxRemoveMessage($msg); + $(this).remove(); + if (typeof data.reload != 'undefined') { + PMA_commonActions.refreshMain(false, function () { + if ($('#result_query').length) { + $('#result_query').remove(); + } + if (data.sql_query) { + $('<div id="result_query"></div>') + .html(data.sql_query) + .prependTo('#page_content'); + } + }); + PMA_reloadNavigation(); + } + } else { + PMA_ajaxShowMessage(PMA_messages['strErrorProcessingRequest'] + " : " + data.error, false); + } + }); // end $.get() + }); // end $.PMA_confirm() + }); //end Add Primary Key + + /** + * Inline move columns + **/ + $("#move_columns_anchor").live('click', function(e) { + e.preventDefault(); + + if ($(this).hasClass("move-active")) { + return; + } + + /** + * @var button_options Object that stores the options passed to jQueryUI + * dialog + */ + var button_options = {}; + + button_options[PMA_messages['strGo']] = function(event) { + event.preventDefault(); + var $msgbox = PMA_ajaxShowMessage(); + var $this = $(this); + var $form = $this.find("form"); + var serialized = $form.serialize(); + + // check if any columns were moved at all + if (serialized == $form.data("serialized-unmoved")) { + PMA_ajaxRemoveMessage($msgbox); + $this.dialog('close'); + return; + } + + $.post($form.prop("action"), serialized + "&ajax_request=true", function (data) { + if (data.success == false) { + PMA_ajaxRemoveMessage($msgbox); + $this + .clone() + .html(data.error) + .dialog({ + title: $(this).prop("title"), + height: 230, + width: 900, + modal: true, + buttons: button_options_error + }); // end dialog options + } else { + $('#fieldsForm ul.table-structure-actions').menuResizer('destroy'); + // sort the fields table + var $fields_table = $("table#tablestructure tbody"); + // remove all existing rows and remember them + var $rows = $fields_table.find("tr").remove(); + // loop through the correct order + for (var i in data.columns) { + var the_column = data.columns[i]; + var $the_row = $rows + .find("input:checkbox[value=" + the_column + "]") + .closest("tr"); + // append the row for this column to the table + $fields_table.append($the_row); + } + var $firstrow = $fields_table.find("tr").eq(0); + // Adjust the row numbers and colors + for (var $row = $firstrow; $row.length > 0; $row = $row.next()) { + $row + .find('td:nth-child(2)') + .text($row.index() + 1) + .end() + .removeClass("odd even") + .addClass($row.index() % 2 == 0 ? "odd" : "even"); + } + PMA_ajaxShowMessage(data.message); + $this.dialog('close'); + $('#fieldsForm ul.table-structure-actions').menuResizer(PMA_tbl_structure_menu_resizer_callback); + } + }); + }; + button_options[PMA_messages['strCancel']] = function() { + $(this).dialog('close'); + }; + + var button_options_error = {}; + button_options_error[PMA_messages['strOK']] = function() { + $(this).dialog('close').remove(); + }; + + var columns = []; + + $("#tablestructure tbody tr").each(function () { + var col_name = $(this).find("input:checkbox").eq(0).val(); + var hidden_input = $("<input/>") + .prop({ + name: "move_columns[]", + type: "hidden" + }) + .val(col_name); + columns[columns.length] = $("<li/>") + .addClass("placeholderDrag") + .text(col_name) + .append(hidden_input); + }); + + var col_list = $("#move_columns_dialog ul") + .find("li").remove().end(); + for (var i in columns) { + col_list.append(columns[i]); + } + col_list.sortable({ + axis: 'y', + containment: $("#move_columns_dialog div") + }).disableSelection(); + var $form = $("#move_columns_dialog form"); + $form.data("serialized-unmoved", $form.serialize()); + + $("#move_columns_dialog").dialog({ + modal: true, + buttons: button_options, + beforeClose: function () { + $("#move_columns_anchor").removeClass("move-active"); + } + }); + }); +}); + +/** + * Reload fields table + */ +function reloadFieldForm(message) { + $.post($("#fieldsForm").attr('action'), $("#fieldsForm").serialize()+"&ajax_request=true", function(form_data) { + var $temp_div = $("<div id='temp_div'><div>").append(form_data.message); + $("#fieldsForm").replaceWith($temp_div.find("#fieldsForm")); + $("#addColumns").replaceWith($temp_div.find("#addColumns")); + $('#move_columns_dialog ul').replaceWith($temp_div.find("#move_columns_dialog ul")); + $("#moveColumns").removeClass("move-active"); + /* reinitialise the more options in table */ + $('#fieldsForm ul.table-structure-actions').menuResizer(PMA_tbl_structure_menu_resizer_callback); + setTimeout(function() { + PMA_ajaxShowMessage(message); + }, 500); + }); + $('#page_content').show(); +} + +/** + * This function returns the horizontal space available for the menu in pixels. + * To calculate this value we start we the width of the main panel, then we + * substract the margin of the page content, then we substract any cellspacing + * that the table may have (original theme only) and finally we substract the + * width of all columns of the table except for the last one (which is where + * the menu will go). What we should end up with is the distance between the + * start of the last column on the table and the edge of the page, again this + * is the space available for the menu. + * + * In the case where the table cell where the menu will be displayed is already + * off-screen (the table is wider than the page), a negative value will be returned, + * but this will be treated as a zero by the menuResizer plugin. + * + * @return int + */ +function PMA_tbl_structure_menu_resizer_callback() { + var pagewidth = $('body').width(); + var $page = $('#page_content'); + pagewidth -= $page.outerWidth(true) - $page.outerWidth(); + var columnsWidth = 0; + var $columns = $('#tablestructure').find('tr:eq(1)').find('td,th'); + $columns.not(':last').each(function (){ + columnsWidth += $(this).outerWidth(true) + }); + var totalCellSpacing = $('#tablestructure').width(); + $columns.each(function (){ + totalCellSpacing -= $(this).outerWidth(true); + }); + return pagewidth - columnsWidth - totalCellSpacing - 15; // 15px extra margin +} + +/** Handler for "More" dropdown in structure table rows */ +AJAX.registerOnload('tbl_structure.js', function() { + if ($('#fieldsForm').hasClass('HideStructureActions')) { + $('#fieldsForm ul.table-structure-actions').menuResizer(PMA_tbl_structure_menu_resizer_callback); + } +}); +AJAX.registerTeardown('tbl_structure.js', function() { + $('#fieldsForm ul.table-structure-actions').menuResizer('destroy'); +}); +$(function () { + $(window).resize($.throttle(function () { + var $list = $('#fieldsForm ul.table-structure-actions'); + if ($list.length) { + $list.menuResizer('resize'); + } + })); +}); |