← Back to branch summary

~ubuntu-branches/ubuntu/saucy/phpmyadmin/saucy-proposed

« back to all changes in this revision

Viewing changes to js/tbl_structure.js

  • Committer: Package Import Robot
  • Author(s): Thijs Kinkhorst
  • Date: 2013-08-04 13:24:37 UTC
  • mfrom: (1.2.44)
  • Revision ID: package-import@ubuntu.com-20130804132437-jznw8efwy4hr1nms
Tags: 4:4.0.5-1
* New upstream release.
  - Fixes security issue PMASA-2013-10.

Show diffs side-by-side

added added

removed removed

Lines of Context:
js/tbl_structure.js
1
 
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(){$(".append_fields_form.ajax").die().live("submit",function(b){b.preventDefault();var a=$(this);if(checkTableEditForm(a[0],a.find("input[name=orig_num_fields]").val())){PMA_prepareForAjaxRequest(a);$msg=PMA_ajaxShowMessage();$.post(a.attr("action"),a.serialize()+"&do_save_data=1",function(c){if($("#sqlqueryresults").length!=0){$("#sqlqueryresults").remove()}else{if($(".error:not(.tab)").length!=0){$(".error:not(.tab)").remove()}}if(c.success==true){$("#page_content").empty().append(c.message).append(c.sql_query).show();$("#result_query .notice").remove();a.remove();PMA_ajaxRemoveMessage($msg);PMA_reloadNavigation()}else{PMA_ajaxShowMessage(c.error,false)}})}});$("a.change_column_anchor.ajax").live("click",function(b){b.preventDefault();var a=PMA_ajaxShowMessage();$("#page_content").hide();$.get($(this).attr("href"),{ajax_request:true},function(c){PMA_ajaxRemoveMessage(a);if(c.success){$('<div id="change_column_dialog" class="margin"></div>').html(c.message).insertBefore("#page_content");PMA_verifyColumnsProperties()}else{PMA_ajaxShowMessage(PMA_messages.strErrorProcessingRequest+" : "+c.error,false)}})});$("button.change_columns_anchor.ajax, input.change_columns_anchor.ajax").live("click",function(c){c.preventDefault();var a=PMA_ajaxShowMessage();$("#page_content").hide();var b=$(this).closest("form");var d=b.serialize()+"&ajax_request=true&submit_mult=change";$.post(b.prop("action"),d,function(e){PMA_ajaxRemoveMessage(a);if(e.success){$("#page_content").empty().append($('<div id="change_column_dialog"></div>').html(e.message)).show();PMA_verifyColumnsProperties()}else{$("#page_content").show();PMA_ajaxShowMessage(e.error)}})});$("a.drop_column_anchor.ajax").live("click",function(c){c.preventDefault();var f=$(this).closest("form").find("input[name=table]").val();var b=$(this).parents("tr");var d=b.children("th").children("label").text();var e=$("select[name='after_field'] option[value='"+d+"']");var a=$.sprintf(PMA_messages.strDoYouReally,"ALTER TABLE `"+escapeHtml(f)+"` DROP `"+escapeHtml(d)+"`;");$(this).PMA_confirm(a,$(this).attr("href"),function(h){var g=PMA_ajaxShowMessage(PMA_messages.strDroppingColumn,false);$.get(h,{is_js_confirmed:1,ajax_request:true,ajax_page_request:true},function(k){if(k.success==true){PMA_ajaxRemoveMessage(g);if($("#result_query").length){$("#result_query").remove()}if(k.sql_query){$('<div id="result_query"></div>').html(k.sql_query).prependTo("#page_content")}toggleRowColors(b.next());for(var j=b.next();j.length>0;j=j.next()){var i=parseInt(j.find("td:nth-child(2)").text())-1;j.find("td:nth-child(2)").text(i)}e.remove();b.hide("medium").remove();if(k.tableStat){$("#tablestatistics").html(k.tableStat)}$(".index_info").replaceWith(k.indexes_list);PMA_reloadNavigation()}else{PMA_ajaxShowMessage(PMA_messages.strErrorProcessingRequest+" : "+k.error,false)}})})});$("a.add_primary_key_anchor.ajax").live("click",function(b){b.preventDefault();var d=$(this).closest("form").find("input[name=table]").val();var c=$(this).parents("tr").children("th").children("label").text();var a=$.sprintf(PMA_messages.strDoYouReally,"ALTER TABLE `"+escapeHtml(d)+"` ADD PRIMARY KEY(`"+escapeHtml(c)+"`);");$(this).PMA_confirm(a,$(this).attr("href"),function(f){var e=PMA_ajaxShowMessage(PMA_messages.strAddingPrimaryKey,false);$.get(f,{is_js_confirmed:1,ajax_request:true},function(g){if(g.success==true){PMA_ajaxRemoveMessage(e);$(this).remove();if(typeof g.reload!="undefined"){PMA_commonActions.refreshMain(false,function(){if($("#result_query").length){$("#result_query").remove()}if(g.sql_query){$('<div id="result_query"></div>').html(g.sql_query).prependTo("#page_content")}});PMA_reloadNavigation()}}else{PMA_ajaxShowMessage(PMA_messages.strErrorProcessingRequest+" : "+g.error,false)}})})});$("#move_columns_anchor").live("click",function(g){g.preventDefault();if($(this).hasClass("move-active")){return}var b={};b[PMA_messages.strGo]=function(i){i.preventDefault();var l=PMA_ajaxShowMessage();var k=$(this);var e=k.find("form");var j=e.serialize();if(j==e.data("serialized-unmoved")){PMA_ajaxRemoveMessage(l);k.dialog("close");return}$.post(e.prop("action"),j+"&ajax_request=true",function(t){if(t.success==false){PMA_ajaxRemoveMessage(l);k.clone().html(t.error).dialog({title:$(this).prop("title"),height:230,width:900,modal:true,buttons:f})}else{$("#fieldsForm ul.table-structure-actions").menuResizer("destroy");var o=$("table#tablestructure tbody");var q=o.find("tr").remove();for(var r in t.columns){var s=t.columns[r];var p=q.find("input:checkbox[value="+s+"]").closest("tr");o.append(p)}var n=o.find("tr").eq(0);for(var m=n;m.length>0;m=m.next()){m.find("td:nth-child(2)").text(m.index()+1).end().removeClass("odd even").addClass(m.index()%2==0?"odd":"even")}PMA_ajaxShowMessage(t.message);k.dialog("close");$("#fieldsForm ul.table-structure-actions").menuResizer(PMA_tbl_structure_menu_resizer_callback)}})};b[PMA_messages.strCancel]=function(){$(this).dialog("close")};var f={};f[PMA_messages.strOK]=function(){$(this).dialog("close").remove()};var d=[];$("#tablestructure tbody tr").each(function(){var i=$(this).find("input:checkbox").eq(0).val();var e=$("<input/>").prop({name:"move_columns[]",type:"hidden"}).val(i);d[d.length]=$("<li/>").addClass("placeholderDrag").text(i).append(e)});var h=$("#move_columns_dialog ul").find("li").remove().end();for(var c in d){h.append(d[c])}h.sortable({axis:"y",containment:$("#move_columns_dialog div")}).disableSelection();var a=$("#move_columns_dialog form");a.data("serialized-unmoved",a.serialize());$("#move_columns_dialog").dialog({modal:true,buttons:b,beforeClose:function(){$("#move_columns_anchor").removeClass("move-active")}})})});function reloadFieldForm(a){$.post($("#fieldsForm").attr("action"),$("#fieldsForm").serialize()+"&ajax_request=true",function(c){var b=$("<div id='temp_div'><div>").append(c.message);$("#fieldsForm").replaceWith(b.find("#fieldsForm"));$("#addColumns").replaceWith(b.find("#addColumns"));$("#move_columns_dialog ul").replaceWith(b.find("#move_columns_dialog ul"));$("#moveColumns").removeClass("move-active");$("#fieldsForm ul.table-structure-actions").menuResizer(PMA_tbl_structure_menu_resizer_callback);setTimeout(function(){PMA_ajaxShowMessage(a)},500)});$("#page_content").show()}function PMA_tbl_structure_menu_resizer_callback(){var c=$("body").width();var b=$("#page_content");c-=b.outerWidth(true)-b.outerWidth();var d=0;var a=$("#tablestructure").find("tr:eq(1)").find("td,th");a.not(":last").each(function(){d+=$(this).outerWidth(true)});var e=$("#tablestructure").width();a.each(function(){e-=$(this).outerWidth(true)});return c-d-e-15}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 a=$("#fieldsForm ul.table-structure-actions");if(a.length){a.menuResizer("resize")}}))});
 
 
b'\\ No newline at end of file'
 
1
/* vim: set expandtab sw=4 ts=4 sts=4: */
 
2
/**
 
3
 * @fileoverview    functions used on the table structure page
 
4
 * @name            Table Structure
 
5
 *
 
6
 * @requires    jQuery
 
7
 * @requires    jQueryUI
 
8
 * @required    js/functions.js
 
9
 */
 
10
 
 
11
/**
 
12
 * AJAX scripts for tbl_structure.php
 
13
 *
 
14
 * Actions ajaxified here:
 
15
 * Drop Column
 
16
 * Add Primary Key
 
17
 * Drop Primary Key/Index
 
18
 *
 
19
 */
 
20
 
 
21
/**
 
22
 * Unbind all event handlers before tearing down a page
 
23
 */
 
24
AJAX.registerTeardown('tbl_structure.js', function() {
 
25
    $("a.change_column_anchor.ajax").die('click');
 
26
    $("button.change_columns_anchor.ajax, input.change_columns_anchor.ajax").die('click');
 
27
    $("a.drop_column_anchor.ajax").die('click');
 
28
    $("a.add_primary_key_anchor.ajax").die('click');
 
29
    $("#move_columns_anchor").die('click');
 
30
    $(".append_fields_form.ajax").unbind('submit');
 
31
});
 
32
 
 
33
AJAX.registerOnload('tbl_structure.js', function() {
 
34
 
 
35
    /**
 
36
     *Ajax action for submitting the "Column Change" and "Add Column" form
 
37
     */
 
38
    $(".append_fields_form.ajax").die().live('submit', function(event) {
 
39
        event.preventDefault();
 
40
        /**
 
41
         * @var    the_form    object referring to the export form
 
42
         */
 
43
        var $form = $(this);
 
44
 
 
45
        /*
 
46
         * First validate the form; if there is a problem, avoid submitting it
 
47
         *
 
48
         * checkTableEditForm() needs a pure element and not a jQuery object,
 
49
         * this is why we pass $form[0] as a parameter (the jQuery object
 
50
         * is actually an array of DOM elements)
 
51
         */
 
52
        if (checkTableEditForm($form[0], $form.find('input[name=orig_num_fields]').val())) {
 
53
            // OK, form passed validation step
 
54
            PMA_prepareForAjaxRequest($form);
 
55
            //User wants to submit the form
 
56
            $msg = PMA_ajaxShowMessage();
 
57
            $.post($form.attr('action'), $form.serialize() + '&do_save_data=1', function(data) {
 
58
                if ($("#sqlqueryresults").length != 0) {
 
59
                    $("#sqlqueryresults").remove();
 
60
                } else if ($(".error:not(.tab)").length != 0) {
 
61
                    $(".error:not(.tab)").remove();
 
62
                }
 
63
                if (data.success == true) {
 
64
                    $("#page_content")
 
65
                        .empty()
 
66
                        .append(data.message)
 
67
                        .append(data.sql_query)
 
68
                        .show();
 
69
                    $("#result_query .notice").remove();
 
70
                    $form.remove();
 
71
                    PMA_ajaxRemoveMessage($msg);
 
72
                    PMA_reloadNavigation();
 
73
                } else {
 
74
                    PMA_ajaxShowMessage(data.error, false);
 
75
                }
 
76
            }); // end $.post()
 
77
        }
 
78
    }); // end change table button "do_save_data"
 
79
 
 
80
    /**
 
81
     * Attach Event Handler for 'Change Column'
 
82
     */
 
83
    $("a.change_column_anchor.ajax").live('click', function(event) {
 
84
        event.preventDefault();
 
85
        var $msg = PMA_ajaxShowMessage();
 
86
        $('#page_content').hide();
 
87
        $.get($(this).attr('href'), {'ajax_request': true}, function (data) {
 
88
            PMA_ajaxRemoveMessage($msg);
 
89
            if (data.success) {
 
90
                $('<div id="change_column_dialog" class="margin"></div>')
 
91
                    .html(data.message)
 
92
                    .insertBefore('#page_content');
 
93
                PMA_verifyColumnsProperties();
 
94
            } else {
 
95
                PMA_ajaxShowMessage(PMA_messages['strErrorProcessingRequest'] + " : " + data.error, false);
 
96
            }
 
97
        });
 
98
    });
 
99
 
 
100
    /**
 
101
     * Attach Event Handler for 'Change multiple columns'
 
102
     */
 
103
    $("button.change_columns_anchor.ajax, input.change_columns_anchor.ajax").live('click', function(event) {
 
104
        event.preventDefault();
 
105
        var $msg = PMA_ajaxShowMessage();
 
106
        $('#page_content').hide();
 
107
        var $form = $(this).closest('form');
 
108
        var params = $form.serialize() + "&ajax_request=true&submit_mult=change";
 
109
        $.post($form.prop("action"), params, function (data) {
 
110
            PMA_ajaxRemoveMessage($msg);
 
111
            if (data.success) {
 
112
                $('#page_content')
 
113
                    .empty()
 
114
                    .append(
 
115
                        $('<div id="change_column_dialog"></div>')
 
116
                            .html(data.message)
 
117
                    )
 
118
                    .show();
 
119
                PMA_verifyColumnsProperties();
 
120
            } else {
 
121
                $('#page_content').show();
 
122
                PMA_ajaxShowMessage(data.error);
 
123
            }
 
124
        });
 
125
    });
 
126
 
 
127
    /**
 
128
     * Attach Event Handler for 'Drop Column'
 
129
     */
 
130
    $("a.drop_column_anchor.ajax").live('click', function(event) {
 
131
        event.preventDefault();
 
132
        /**
 
133
         * @var curr_table_name String containing the name of the current table
 
134
         */
 
135
        var curr_table_name = $(this).closest('form').find('input[name=table]').val();
 
136
        /**
 
137
         * @var curr_row    Object reference to the currently selected row (i.e. field in the table)
 
138
         */
 
139
        var $curr_row = $(this).parents('tr');
 
140
        /**
 
141
         * @var curr_column_name    String containing name of the field referred to by {@link curr_row}
 
142
         */
 
143
        var curr_column_name = $curr_row.children('th').children('label').text();
 
144
        /**
 
145
         * @var $after_field_item    Corresponding entry in the 'After' field.
 
146
         */
 
147
        var $after_field_item = $("select[name='after_field'] option[value='" + curr_column_name + "']");
 
148
        /**
 
149
         * @var question    String containing the question to be asked for confirmation
 
150
         */
 
151
        var question = $.sprintf(PMA_messages['strDoYouReally'], 'ALTER TABLE `' + escapeHtml(curr_table_name) + '` DROP `' + escapeHtml(curr_column_name) + '`;');
 
152
        $(this).PMA_confirm(question, $(this).attr('href'), function(url) {
 
153
            var $msg = PMA_ajaxShowMessage(PMA_messages['strDroppingColumn'], false);
 
154
            $.get(url, {'is_js_confirmed' : 1, 'ajax_request' : true, 'ajax_page_request' : true}, function (data) {
 
155
                if (data.success == true) {
 
156
                    PMA_ajaxRemoveMessage($msg);
 
157
                    if ($('#result_query').length) {
 
158
                        $('#result_query').remove();
 
159
                    }
 
160
                    if (data.sql_query) {
 
161
                        $('<div id="result_query"></div>')
 
162
                            .html(data.sql_query)
 
163
                            .prependTo('#page_content');
 
164
                    }
 
165
                    toggleRowColors($curr_row.next());
 
166
                    // Adjust the row numbers
 
167
                    for (var $row = $curr_row.next(); $row.length > 0; $row = $row.next()) {
 
168
                        var new_val = parseInt($row.find('td:nth-child(2)').text()) - 1;
 
169
                        $row.find('td:nth-child(2)').text(new_val);
 
170
                    }
 
171
                    $after_field_item.remove();
 
172
                    $curr_row.hide("medium").remove();
 
173
                    //refresh table stats
 
174
                    if (data.tableStat) {
 
175
                        $('#tablestatistics').html(data.tableStat);
 
176
                    }
 
177
                    // refresh the list of indexes (comes from sql.php)
 
178
                    $('.index_info').replaceWith(data.indexes_list);
 
179
                    PMA_reloadNavigation();
 
180
                } else {
 
181
                    PMA_ajaxShowMessage(PMA_messages['strErrorProcessingRequest'] + " : " + data.error, false);
 
182
                }
 
183
            }); // end $.get()
 
184
        }); // end $.PMA_confirm()
 
185
    }) ; //end of Drop Column Anchor action
 
186
 
 
187
    /**
 
188
     * Ajax Event handler for 'Add Primary Key'
 
189
     */
 
190
    $("a.add_primary_key_anchor.ajax").live('click', function(event) {
 
191
        event.preventDefault();
 
192
        /**
 
193
         * @var curr_table_name String containing the name of the current table
 
194
         */
 
195
        var curr_table_name = $(this).closest('form').find('input[name=table]').val();
 
196
        /**
 
197
         * @var curr_column_name    String containing name of the field referred to by {@link curr_row}
 
198
         */
 
199
        var curr_column_name = $(this).parents('tr').children('th').children('label').text();
 
200
        /**
 
201
         * @var question    String containing the question to be asked for confirmation
 
202
         */
 
203
        var question = $.sprintf(PMA_messages['strDoYouReally'], 'ALTER TABLE `' + escapeHtml(curr_table_name) + '` ADD PRIMARY KEY(`' + escapeHtml(curr_column_name) + '`);');
 
204
        $(this).PMA_confirm(question, $(this).attr('href'), function(url) {
 
205
            var $msg = PMA_ajaxShowMessage(PMA_messages['strAddingPrimaryKey'], false);
 
206
            $.get(url, {'is_js_confirmed' : 1, 'ajax_request' : true}, function(data) {
 
207
                if (data.success == true) {
 
208
                    PMA_ajaxRemoveMessage($msg);
 
209
                    $(this).remove();
 
210
                    if (typeof data.reload != 'undefined') {
 
211
                        PMA_commonActions.refreshMain(false, function () {
 
212
                            if ($('#result_query').length) {
 
213
                                $('#result_query').remove();
 
214
                            }
 
215
                            if (data.sql_query) {
 
216
                                $('<div id="result_query"></div>')
 
217
                                    .html(data.sql_query)
 
218
                                    .prependTo('#page_content');
 
219
                            }
 
220
                        });
 
221
                        PMA_reloadNavigation();
 
222
                    }
 
223
                } else {
 
224
                    PMA_ajaxShowMessage(PMA_messages['strErrorProcessingRequest'] + " : " + data.error, false);
 
225
                }
 
226
            }); // end $.get()
 
227
        }); // end $.PMA_confirm()
 
228
    }); //end Add Primary Key
 
229
 
 
230
    /**
 
231
     * Inline move columns
 
232
    **/
 
233
    $("#move_columns_anchor").live('click', function(e) {
 
234
        e.preventDefault();
 
235
 
 
236
        if ($(this).hasClass("move-active")) {
 
237
            return;
 
238
        }
 
239
 
 
240
        /**
 
241
         * @var    button_options  Object that stores the options passed to jQueryUI
 
242
         *                          dialog
 
243
         */
 
244
        var button_options = {};
 
245
 
 
246
        button_options[PMA_messages['strGo']] = function(event) {
 
247
            event.preventDefault();
 
248
            var $msgbox = PMA_ajaxShowMessage();
 
249
            var $this = $(this);
 
250
            var $form = $this.find("form");
 
251
            var serialized = $form.serialize();
 
252
 
 
253
            // check if any columns were moved at all
 
254
            if (serialized == $form.data("serialized-unmoved")) {
 
255
                PMA_ajaxRemoveMessage($msgbox);
 
256
                $this.dialog('close');
 
257
                return;
 
258
            }
 
259
 
 
260
            $.post($form.prop("action"), serialized + "&ajax_request=true", function (data) {
 
261
                if (data.success == false) {
 
262
                    PMA_ajaxRemoveMessage($msgbox);
 
263
                    $this
 
264
                    .clone()
 
265
                    .html(data.error)
 
266
                    .dialog({
 
267
                        title: $(this).prop("title"),
 
268
                        height: 230,
 
269
                        width: 900,
 
270
                        modal: true,
 
271
                        buttons: button_options_error
 
272
                    }); // end dialog options
 
273
                } else {
 
274
                    $('#fieldsForm ul.table-structure-actions').menuResizer('destroy');
 
275
                    // sort the fields table
 
276
                    var $fields_table = $("table#tablestructure tbody");
 
277
                    // remove all existing rows and remember them
 
278
                    var $rows = $fields_table.find("tr").remove();
 
279
                    // loop through the correct order
 
280
                    for (var i in data.columns) {
 
281
                        var the_column = data.columns[i];
 
282
                        var $the_row = $rows
 
283
                            .find("input:checkbox[value=" + the_column + "]")
 
284
                            .closest("tr");
 
285
                        // append the row for this column to the table
 
286
                        $fields_table.append($the_row);
 
287
                    }
 
288
                    var $firstrow = $fields_table.find("tr").eq(0);
 
289
                    // Adjust the row numbers and colors
 
290
                    for (var $row = $firstrow; $row.length > 0; $row = $row.next()) {
 
291
                        $row
 
292
                        .find('td:nth-child(2)')
 
293
                        .text($row.index() + 1)
 
294
                        .end()
 
295
                        .removeClass("odd even")
 
296
                        .addClass($row.index() % 2 == 0 ? "odd" : "even");
 
297
                    }
 
298
                    PMA_ajaxShowMessage(data.message);
 
299
                    $this.dialog('close');
 
300
                    $('#fieldsForm ul.table-structure-actions').menuResizer(PMA_tbl_structure_menu_resizer_callback);
 
301
                }
 
302
            });
 
303
        };
 
304
        button_options[PMA_messages['strCancel']] = function() {
 
305
            $(this).dialog('close');
 
306
        };
 
307
 
 
308
        var button_options_error = {};
 
309
        button_options_error[PMA_messages['strOK']] = function() {
 
310
            $(this).dialog('close').remove();
 
311
        };
 
312
 
 
313
        var columns = [];
 
314
 
 
315
        $("#tablestructure tbody tr").each(function () {
 
316
            var col_name = $(this).find("input:checkbox").eq(0).val();
 
317
            var hidden_input = $("<input/>")
 
318
                .prop({
 
319
                    name: "move_columns[]",
 
320
                    type: "hidden"
 
321
                })
 
322
                .val(col_name);
 
323
            columns[columns.length] = $("<li/>")
 
324
                .addClass("placeholderDrag")
 
325
                .text(col_name)
 
326
                .append(hidden_input);
 
327
        });
 
328
 
 
329
        var col_list = $("#move_columns_dialog ul")
 
330
            .find("li").remove().end();
 
331
        for (var i in columns) {
 
332
            col_list.append(columns[i]);
 
333
        }
 
334
        col_list.sortable({
 
335
            axis: 'y',
 
336
            containment: $("#move_columns_dialog div")
 
337
        }).disableSelection();
 
338
        var $form = $("#move_columns_dialog form");
 
339
        $form.data("serialized-unmoved", $form.serialize());
 
340
 
 
341
        $("#move_columns_dialog").dialog({
 
342
            modal: true,
 
343
            buttons: button_options,
 
344
            beforeClose: function () {
 
345
                $("#move_columns_anchor").removeClass("move-active");
 
346
            }
 
347
        });
 
348
    });
 
349
});
 
350
 
 
351
/**
 
352
 * Reload fields table
 
353
 */
 
354
function reloadFieldForm(message) {
 
355
    $.post($("#fieldsForm").attr('action'), $("#fieldsForm").serialize()+"&ajax_request=true", function(form_data) {
 
356
        var $temp_div = $("<div id='temp_div'><div>").append(form_data.message);
 
357
        $("#fieldsForm").replaceWith($temp_div.find("#fieldsForm"));
 
358
        $("#addColumns").replaceWith($temp_div.find("#addColumns"));
 
359
        $('#move_columns_dialog ul').replaceWith($temp_div.find("#move_columns_dialog ul"));
 
360
        $("#moveColumns").removeClass("move-active");
 
361
        /* reinitialise the more options in table */
 
362
        $('#fieldsForm ul.table-structure-actions').menuResizer(PMA_tbl_structure_menu_resizer_callback);
 
363
        setTimeout(function() {
 
364
            PMA_ajaxShowMessage(message);
 
365
        }, 500);
 
366
    });
 
367
    $('#page_content').show();
 
368
}
 
369
 
 
370
/**
 
371
 * This function returns the horizontal space available for the menu in pixels.
 
372
 * To calculate this value we start we the width of the main panel, then we
 
373
 * substract the margin of the page content, then we substract any cellspacing
 
374
 * that the table may have (original theme only) and finally we substract the
 
375
 * width of all columns of the table except for the last one (which is where
 
376
 * the menu will go). What we should end up with is the distance between the
 
377
 * start of the last column on the table and the edge of the page, again this
 
378
 * is the space available for the menu.
 
379
 *
 
380
 * In the case where the table cell where the menu will be displayed is already
 
381
 * off-screen (the table is wider than the page), a negative value will be returned,
 
382
 * but this will be treated as a zero by the menuResizer plugin.
 
383
 *
 
384
 * @return int
 
385
 */
 
386
function PMA_tbl_structure_menu_resizer_callback() {
 
387
    var pagewidth = $('body').width();
 
388
    var $page = $('#page_content');
 
389
    pagewidth -= $page.outerWidth(true) - $page.outerWidth();
 
390
    var columnsWidth = 0;
 
391
    var $columns = $('#tablestructure').find('tr:eq(1)').find('td,th');
 
392
    $columns.not(':last').each(function (){
 
393
        columnsWidth += $(this).outerWidth(true)
 
394
    });
 
395
    var totalCellSpacing = $('#tablestructure').width();
 
396
    $columns.each(function (){
 
397
        totalCellSpacing -= $(this).outerWidth(true);
 
398
    });
 
399
    return pagewidth - columnsWidth - totalCellSpacing - 15; // 15px extra margin
 
400
}
 
401
 
 
402
/** Handler for "More" dropdown in structure table rows */
 
403
AJAX.registerOnload('tbl_structure.js', function() {
 
404
    if ($('#fieldsForm').hasClass('HideStructureActions')) {
 
405
        $('#fieldsForm ul.table-structure-actions').menuResizer(PMA_tbl_structure_menu_resizer_callback);
 
406
    }
 
407
});
 
408
AJAX.registerTeardown('tbl_structure.js', function() {
 
409
    $('#fieldsForm ul.table-structure-actions').menuResizer('destroy');
 
410
});
 
411
$(function () {
 
412
    $(window).resize($.throttle(function () {
 
413
        var $list = $('#fieldsForm ul.table-structure-actions');
 
414
        if ($list.length) {
 
415
            $list.menuResizer('resize');
 
416
        }
 
417
    }));
 
418
});