/* 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 * *//** * 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}/** * Reload fields table */function reloadFieldForm() {    $.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);    });    $('#page_content').show();}/** * 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');    $("a.add_index_anchor.ajax").die('click');    $("a.add_unique_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();                    PMA_highlightSQL($('#page_content'));                    $("#result_query .notice").remove();                    reloadFieldForm();                    $form.remove();                    PMA_ajaxRemoveMessage($msg);                    PMA_init_slider();                    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_highlightSQL($('#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_highlightSQL($('#page_content'));                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();        // BUG: CWE-79 Improper Neutralization of Input During Web Page Generation ('Cross-site Scripting')        //         // FIXED:         curr_column_name = escapeHtml(curr_column_name);        /**         * @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');                        PMA_highlightSQL($('#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(), 10) - 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, 'index_change' : 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_highlightSQL($('#page_content'));                            }                        });                        PMA_reloadNavigation();                    }                    if (data.indexes_list) {                        $('.index_info').replaceWith(data.indexes_list);                    }                } else {                    PMA_ajaxShowMessage(PMA_messages.strErrorProcessingRequest + " : " + data.error, false);                }            }); // end $.get()        }); // end $.PMA_confirm()    }); //end Add Primary Key    /**     * Ajax Event handler for 'Add Index'     */    $("a.add_index_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 INDEX(`' + escapeHtml(curr_column_name) + '`);');        $(this).PMA_confirm(question, $(this).attr('href'), function (url) {            var $msg = PMA_ajaxShowMessage(PMA_messages.strAddingIndex, false);            $.get(url                , {'is_js_confirmed' : 1, 'ajax_request' : true, 'index_change' : 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');                        PMA_highlightSQL($('#page_content'));                    }                    if (data.indexes_list) {                        $('.index_info').replaceWith(data.indexes_list);                    }                    PMA_reloadNavigation();                } else {                    PMA_ajaxShowMessage(PMA_messages.strErrorProcessingRequest + " : " + data.error, false);                }            }); // end $.get()        }); // end $.PMA_confirm()    }); //end Add Index    /**     * Ajax Event handler for 'Add Unique'     */    $("a.add_unique_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 UNIQUE(`' + escapeHtml(curr_column_name) + '`);');        $(this).PMA_confirm(question, $(this).attr('href'), function (url) {            var $msg = PMA_ajaxShowMessage(PMA_messages.strAddingUnique, false);            $.get(url                , {'is_js_confirmed' : 1, 'ajax_request' : true, 'index_change' : 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');                        PMA_highlightSQL($('#page_content'));                    }                    if (data.indexes_list) {                        $('.index_info').replaceWith(data.indexes_list);                    }                    PMA_reloadNavigation();                } else {                    PMA_ajaxShowMessage(PMA_messages.strErrorProcessingRequest + " : " + data.error, false);                }            }); // end $.get()        }); // end $.PMA_confirm()    }); //end Add Unique    /**     * 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"),            tolerance: 'pointer'        }).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");            }        });    });});/** 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');        }    }));});