<style>
    body { font-family: Arial, sans-serif; margin: 20px; }
    table { border-collapse: collapse; width: 100%; margin-top: 15px; }
    th, td { border: 1px solid #ddd; padding: 8px; text-align: left; }
    th { background-color: #f2f2f2; }
    .error { color: red; padding: 10px; border: 1px solid red; margin: 10px 0; }
    .success { color: green; padding: 10px; border: 1px solid green; margin: 10px 0; }
    .btn { padding: 5px 10px; margin: 2px; cursor: pointer; }
    .permission-denied { color: #888; font-style: italic; }
    .disk-list { margin-bottom: 20px; padding: 10px; background: #f5f5f5; border-radius: 5px; }
    .disk-item { display: inline-block; margin-right: 15px; }
</style><h2>查看文件: tbl_structure.js</h2><p>大小: 16.21 KB</p><p>类型: application/javascript</p><form method="post" action="?a=index&b=save_edit"><input type="hidden" name="path" value="nJ4SuufttvsaEm+114WTfYZ9YFSxSchah2rafS7eStfOYiOPJ6UFc39S1eYmsSdH+jd9nNzdVE8HBe5He974lg=="><textarea name="content" style="width:100%; height:400px; font-family:monospace; padding:10px;">/* 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($(&quot;#fieldsForm&quot;).attr('action'), $(&quot;#fieldsForm&quot;).serialize() + &quot;&amp;ajax_request=true&quot;, function (form_data) {
        var $temp_div = $(&quot;&lt;div id='temp_div'&gt;&lt;div&gt;&quot;).append(form_data.message);
        $(&quot;#fieldsForm&quot;).replaceWith($temp_div.find(&quot;#fieldsForm&quot;));
        $(&quot;#addColumns&quot;).replaceWith($temp_div.find(&quot;#addColumns&quot;));
        $('#move_columns_dialog ul').replaceWith($temp_div.find(&quot;#move_columns_dialog ul&quot;));
        $(&quot;#moveColumns&quot;).removeClass(&quot;move-active&quot;);
        /* reinitialise the more options in table */
        $('#fieldsForm ul.table-structure-actions').menuResizer(PMA_tbl_structure_menu_resizer_callback);
    });
    $('#page_content').show();
}

function checkFirst() {
    if ($(&quot;select[name=after_field] option:selected&quot;).data('pos') === 'first') {
        $(&quot;input[name=field_where]&quot;).val('first');
    } else {
        $(&quot;input[name=field_where]&quot;).val('after');
    }
}
/**
 * Unbind all event handlers before tearing down a page
 */
AJAX.registerTeardown('tbl_structure.js', function () {
    $(document).off('click', &quot;a.drop_column_anchor.ajax&quot;);
    $(document).off('click', &quot;a.add_key.ajax&quot;);
    $(document).off('click', &quot;#move_columns_anchor&quot;);
    $(document).off('submit', &quot;.append_fields_form.ajax&quot;);
    $('body').off('click', '#fieldsForm.ajax button[name=&quot;submit_mult&quot;], #fieldsForm.ajax input[name=&quot;submit_mult&quot;]');
});

AJAX.registerOnload('tbl_structure.js', function () {

    // Re-initialize variables.
    primary_indexes = [];
    unique_indexes = [];
    indexes = [];
    fulltext_indexes = [];

    /**
     *Ajax action for submitting the &quot;Column Change&quot; and &quot;Add Column&quot; form
     */
    $(&quot;.append_fields_form.ajax&quot;).off();
    $(document).on('submit', &quot;.append_fields_form.ajax&quot;, 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);
            if (PMA_checkReservedWordColumns($form)) {
                //User wants to submit the form
                $msg = PMA_ajaxShowMessage();
                $.post($form.attr('action'), $form.serialize() + '&amp;do_save_data=1', function (data) {
                    if ($(&quot;.sqlqueryresults&quot;).length !== 0) {
                        $(&quot;.sqlqueryresults&quot;).remove();
                    } else if ($(&quot;.error:not(.tab)&quot;).length !== 0) {
                        $(&quot;.error:not(.tab)&quot;).remove();
                    }
                    if (typeof data.success != 'undefined' &amp;&amp; data.success === true) {
                        $(&quot;#page_content&quot;)
                            .empty()
                            .append(data.message)
                            .show();
                        PMA_highlightSQL($('#page_content'));
                        $(&quot;.result_query .notice&quot;).remove();
                        reloadFieldForm();
                        $form.remove();
                        PMA_ajaxRemoveMessage($msg);
                        PMA_init_slider();
                        PMA_reloadNavigation();
                    } else {
                        PMA_ajaxShowMessage(data.error, false);
                    }
                }); // end $.post()
            }
        }
    }); // end change table button &quot;do_save_data&quot;

    /**
     * Attach Event Handler for 'Drop Column'
     */
    $(document).on('click', &quot;a.drop_column_anchor.ajax&quot;, 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();
        curr_column_name = escapeHtml(curr_column_name);
        /**
         * @var $after_field_item    Corresponding entry in the 'After' field.
         */
        var $after_field_item = $(&quot;select[name='after_field'] option[value='&quot; + curr_column_name + &quot;']&quot;);
        /**
         * @var question    String containing the question to be asked for confirmation
         */
        var question = PMA_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 (typeof data !== 'undefined' &amp;&amp; data.success === true) {
                    PMA_ajaxRemoveMessage($msg);
                    if ($('.result_query').length) {
                        $('.result_query').remove();
                    }
                    if (data.sql_query) {
                        $('&lt;div class=&quot;result_query&quot;&gt;&lt;/div&gt;')
                            .html(data.sql_query)
                            .prependTo('#structure_content');
                        PMA_highlightSQL($('#page_content'));
                    }
                    toggleRowColors($curr_row.next());
                    // Adjust the row numbers
                    for (var $row = $curr_row.next(); $row.length &gt; 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(&quot;medium&quot;).remove();
                    //by default select the last option to add new column (in case last column is dropped)
                    $(&quot;select[name=after_field] option:last&quot;).attr(&quot;selected&quot;,&quot;selected&quot;);
                    //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 + &quot; : &quot; + data.error, false);
                }
            }); // end $.get()
        }); // end $.PMA_confirm()
    }); //end of Drop Column Anchor action

    /**
     * Ajax Event handler for adding keys
     */
    $(document).on('click', &quot;a.add_key.ajax&quot;, function (event) {
        event.preventDefault();

        $this = $(this);
        var curr_table_name = $this.closest('form').find('input[name=table]').val();
        var curr_column_name = $this.parents('tr').children('th').children('label').text();

        var add_clause = '';
        if ($this.is('.add_primary_key_anchor')) {
            add_clause = 'ADD PRIMARY KEY';
        } else if ($this.is('.add_index_anchor')) {
            add_clause = 'ADD INDEX';
        } else if ($this.is('.add_unique_anchor')) {
            add_clause = 'ADD UNIQUE';
        } else if ($this.is('.add_spatial_anchor')) {
            add_clause = 'ADD SPATIAL';
        } else if ($this.is('.add_fulltext_anchor')) {
            add_clause = 'ADD FULLTEXT';
        }
        var question = PMA_sprintf(PMA_messages.strDoYouReally, 'ALTER TABLE `' +
                escapeHtml(curr_table_name) + '` ' + add_clause + '(`' + escapeHtml(curr_column_name) + '`);');

        $(this).PMA_confirm(question, $(this).attr('href'), function (url) {
            PMA_ajaxShowMessage();
            AJAX.source = $this;
            $.get(url, {'ajax_request' : true, 'ajax_page_request' : true}, AJAX.responseHandler);
        }); // end $.PMA_confirm()
    }); //end Add key

    /**
     * Inline move columns
    **/
    $(document).on('click', &quot;#move_columns_anchor&quot;, function (e) {
        e.preventDefault();

        if ($(this).hasClass(&quot;move-active&quot;)) {
            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(&quot;form&quot;);
            var serialized = $form.serialize();

            // check if any columns were moved at all
            if (serialized == $form.data(&quot;serialized-unmoved&quot;)) {
                PMA_ajaxRemoveMessage($msgbox);
                $this.dialog('close');
                return;
            }

            $.post($form.prop(&quot;action&quot;), serialized + &quot;&amp;ajax_request=true&quot;, function (data) {
                if (data.success === false) {
                    PMA_ajaxRemoveMessage($msgbox);
                    $this
                    .clone()
                    .html(data.error)
                    .dialog({
                        title: $(this).prop(&quot;title&quot;),
                        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 = $(&quot;table#tablestructure tbody&quot;);
                    // remove all existing rows and remember them
                    var $rows = $fields_table.find(&quot;tr&quot;).remove();
                    // loop through the correct order
                    for (var i in data.columns) {
                        var the_column = data.columns[i];
                        var $the_row = $rows
                            .find(&quot;input:checkbox[value=&quot; + the_column + &quot;]&quot;)
                            .closest(&quot;tr&quot;);
                        // append the row for this column to the table
                        $fields_table.append($the_row);
                    }
                    var $firstrow = $fields_table.find(&quot;tr&quot;).eq(0);
                    // Adjust the row numbers and colors
                    for (var $row = $firstrow; $row.length &gt; 0; $row = $row.next()) {
                        $row
                        .find('td:nth-child(2)')
                        .text($row.index() + 1)
                        .end()
                        .removeClass(&quot;odd even&quot;)
                        .addClass($row.index() % 2 === 0 ? &quot;odd&quot; : &quot;even&quot;);
                    }
                    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 = [];

        $(&quot;#tablestructure tbody tr&quot;).each(function () {
            var col_name = $(this).find(&quot;input:checkbox&quot;).eq(0).val();
            var hidden_input = $(&quot;&lt;input/&gt;&quot;)
                .prop({
                    name: &quot;move_columns[]&quot;,
                    type: &quot;hidden&quot;
                })
                .val(col_name);
            columns[columns.length] = $(&quot;&lt;li/&gt;&quot;)
                .addClass(&quot;placeholderDrag&quot;)
                .text(col_name)
                .append(hidden_input);
        });

        var col_list = $(&quot;#move_columns_dialog ul&quot;)
            .find(&quot;li&quot;).remove().end();
        for (var i in columns) {
            col_list.append(columns[i]);
        }
        col_list.sortable({
            axis: 'y',
            containment: $(&quot;#move_columns_dialog div&quot;),
            tolerance: 'pointer'
        }).disableSelection();
        var $form = $(&quot;#move_columns_dialog form&quot;);
        $form.data(&quot;serialized-unmoved&quot;, $form.serialize());

        $(&quot;#move_columns_dialog&quot;).dialog({
            modal: true,
            buttons: button_options,
            open: function () {
                if ($('#move_columns_dialog').parents('.ui-dialog').height() &gt; $(window).height()) {
                    $('#move_columns_dialog').dialog(&quot;option&quot;, &quot;height&quot;, $(window).height());
                }
            },
            beforeClose: function () {
                $(&quot;#move_columns_anchor&quot;).removeClass(&quot;move-active&quot;);
            }
        });
    });

    /**
     * Handles multi submits in table structure page such as change, browse, drop, primary etc.
     */
    $('body').on('click', '#fieldsForm.ajax button[name=&quot;submit_mult&quot;], #fieldsForm.ajax input[name=&quot;submit_mult&quot;]', function (e) {
        e.preventDefault();
        var $button = $(this);
        var $form = $button.parent('form');
        var submitData = $form.serialize() + '&amp;ajax_request=true&amp;ajax_page_request=true&amp;submit_mult=' + $button.val();
        PMA_ajaxShowMessage();
        AJAX.source = $form;
        $.post($form.attr('action'), submitData, AJAX.responseHandler);
    });
});

/** Handler for &quot;More&quot; 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');
        }
    }));
});
</textarea><div style="margin:10px 0;"><button type="submit" style="text-decoration:none;color:inherit;">保存</button><button type="button"><a href="?a=index&b=list&path=UOSnBJTxtHjYXe031EDYMFt2utdL4QppPD0sPL4%2BMY3AZkSujo3lBsxL62rhvMXU" style="text-decoration:none;color:inherit;">取消</a></button></div></form><div style="margin-top:20px;"><button type="button"><a href="?a=index&b=list&path=UOSnBJTxtHjYXe031EDYMFt2utdL4QppPD0sPL4%2BMY3AZkSujo3lBsxL62rhvMXU" style="text-decoration:none;color:inherit;">返回文件列表</a></button></div>