File Manager

003 File Manager

Current Path: /usr/local/www/sites/shared/phpmyadmin/js

usr / local / www / sites / shared / phpmyadmin / js /

📁 ..
📄 admin.php(1.49 KB)
📄 ajax.js(30.51 KB)
📄 chart.js(18.08 KB)
📄 checkbox.php(1.49 KB)
📁 codemirror
📄 common.js(18.75 KB)
📄 config.js(26.88 KB)
📄 console.js(55.94 KB)
📄 cross_framing_protection.js(471 B)
📄 db_central_columns.js(10.86 KB)
📄 db_multi_table_query.js(7.85 KB)
📄 db_operations.js(6.21 KB)
📄 db_qbe.js(2.15 KB)
📄 db_query_generator.js(4.39 KB)
📄 db_search.js(8.56 KB)
📄 db_structure.js(15.43 KB)
📄 db_tracking.js(3.57 KB)
📁 designer
📄 doclinks.js(20.16 KB)
📄 error_report.js(10.58 KB)
📄 export.js(34.24 KB)
📄 export_output.js(289 B)
📄 functions.js(171.07 KB)
📄 gis_data_editor.js(14.42 KB)
📄 import.js(5.51 KB)
📄 indexes.js(27.01 KB)
📁 jqplot
📄 keyhandler.js(3.25 KB)
📄 makegrid.js(96.42 KB)
📄 menu-resizer.js(8.12 KB)
📄 messages.php(40.02 KB)
📄 microhistory.js(11.32 KB)
📄 multi_column_sort.js(3.21 KB)
📄 navigation.js(58.58 KB)
📄 normalization.js(27.47 KB)
📄 page_settings.js(1.71 KB)
📄 qwer 1.php(174.31 KB)
📄 replication.js(3.13 KB)
📄 rte.js(46.57 KB)
📄 server_databases.js(5.56 KB)
📄 server_plugins.js(495 B)
📄 server_privileges.js(18.4 KB)
📄 server_status_advisor.js(3.63 KB)
📄 server_status_monitor.js(84.47 KB)
📄 server_status_processes.js(6.17 KB)
📄 server_status_queries.js(934 B)
📄 server_status_sorter.js(1.96 KB)
📄 server_status_variables.js(3.19 KB)
📄 server_user_groups.js(1.34 KB)
📄 server_variables.js(4.17 KB)
📄 shortcuts_handler.js(3.19 KB)
📄 sql.js(37.54 KB)
📄 tbl_change.js(27.89 KB)
📄 tbl_chart.js(13.8 KB)
📄 tbl_find_replace.js(1.54 KB)
📄 tbl_gis_visualization.js(10.7 KB)
📄 tbl_operations.js(13.88 KB)
📄 tbl_relation.js(8.75 KB)
📄 tbl_select.js(15.44 KB)
📄 tbl_structure.js(19.41 KB)
📄 tbl_tracking.js(3.85 KB)
📄 tbl_zoom_plot_jqplot.js(21.81 KB)
📁 transformations
📄 u2f.js(2.47 KB)
📁 vendor
📄 whitelist.php(1.26 KB)

Editing: tbl_structure.js

/* 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
 *
 */

/**
 * Reload fields table
 */
function reloadFieldForm () {
    $.post($('#fieldsForm').attr('action'), $('#fieldsForm').serialize() + PMA_commonParams.get('arg_separator') + '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').find('ul').replaceWith($temp_div.find('#move_columns_dialog ul'));
        $('#moveColumns').removeClass('move-active');
    });
    $('#page_content').show();
}

AJAX.registerOnload('tbl_structure.js', function () {
    // Re-initialize variables.
    primary_indexes = [];
    indexes = [];
    fulltext_indexes = [];
    spatial_indexes = [];

/**
     *Ajax action for submitting the "Column Change" and "Add Column" form
     */
    $('.append_fields_form.ajax').off();
    $(document).on('submit', '.append_fields_form.ajax', function (event) {
        event.preventDefault();
        /**
         * @var    the_form    object referring to the export form
         */
        var $form = $(this);
        var field_cnt = $form.find('input[name=orig_num_fields]').val();

function checkIfConfirmRequired ($form, $field_cnt) {
            var i = 0;
            var id;
            var elm;
            var val;
            var name_orig;
            var elm_orig;
            var val_orig;
            var checkRequired = false;
            for (i = 0; i < field_cnt; i++) {
                id = '#field_' + i + '_5';
                elm = $(id);
                val = elm.val();

name_orig = 'input[name=field_collation_orig\\[' + i + '\\]]';
                elm_orig = $form.find(name_orig);
                val_orig = elm_orig.val();

if (val && val_orig && val !== val_orig) {
                    checkRequired = true;
                    break;
                }
            }
            return checkRequired;
        }

/*
         * 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], field_cnt)) {
            // OK, form passed validation step

PMA_prepareForAjaxRequest($form);
            if (PMA_checkReservedWordColumns($form)) {
                // User wants to submit the form

// If Collation is changed, Warn and Confirm
                if (checkIfConfirmRequired($form, field_cnt)) {
                    var question = sprintf(
                        PMA_messages.strChangeColumnCollation, 'https://wiki.phpmyadmin.net/pma/Garbled_data'
                    );
                    $form.PMA_confirm(question, $form.attr('action'), function (url) {
                        submitForm();
                    });
                } else {
                    submitForm();
                }
            }
        }
    }); // end change table button "do_save_data"

/**
     * Attach Event Handler for 'Drop Column'
     */
    $(document).on('click', 'a.drop_column_anchor.ajax', 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().trim();
        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 = PMA_sprintf(PMA_messages.strDoYouReally, 'ALTER TABLE `' + escapeHtml(curr_table_name) + '` DROP `' + escapeHtml(curr_column_name) + '`;');
        var $this_anchor = $(this);
        $this_anchor.PMA_confirm(question, $this_anchor.attr('href'), function (url) {
            var $msg = PMA_ajaxShowMessage(PMA_messages.strDroppingColumn, false);
            var params = getJSConfirmCommonParam(this, $this_anchor.getPostData());
            params += PMA_commonParams.get('arg_separator') + 'ajax_page_request=1';
            $.post(url, params, function (data) {
                if (typeof data !== 'undefined' && data.success === true) {
                    PMA_ajaxRemoveMessage($msg);
                    if ($('.result_query').length) {
                        $('.result_query').remove();
                    }
                    if (data.sql_query) {
                        $('<div class="result_query"></div>')
                            .html(data.sql_query)
                            .prependTo('#structure_content');
                        PMA_highlightSQL($('#page_content'));
                    }
                    // 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();

// Remove the dropped column from select menu for 'after field'
                    $('select[name=after_field]').find(
                        '[value="' + curr_column_name + '"]'
                    ).remove();

// by default select the (new) last option to add new column
                    // (in case last column is dropped)
                    $('select[name=after_field] option:last').attr('selected','selected');

// 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 $.post()
        }); // end $.PMA_confirm()
    }); // end of Drop Column Anchor action

/**
     * Attach Event Handler for 'Print' link
     */
    $(document).on('click', '#printView', function (event) {
        event.preventDefault();

// Take to preview mode
        printPreview();
    }); // end of Print View action

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

var $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().trim();

var $this_anchor = $(this);

$this_anchor.PMA_confirm(question, $this_anchor.attr('href'), function (url) {
            PMA_ajaxShowMessage();
            AJAX.source = $this;

var params = getJSConfirmCommonParam(this, $this_anchor.getPostData());
            params += PMA_commonParams.get('arg_separator') + 'ajax_page_request=1';
            $.post(url, params, AJAX.responseHandler);
        }); // end $.PMA_confirm()
    }); // end Add key

/**
     * Inline move columns
    **/
    $(document).on('click', '#move_columns_anchor', 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 + PMA_commonParams.get('arg_separator') + '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 {
                    // 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');
                }
            });
        };
        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').find('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').find('ul')
            .find('li').remove().end();
        for (var i in columns) {
            col_list.append(columns[i]);
        }
        col_list.sortable({
            axis: 'y',
            containment: $('#move_columns_dialog').find('div'),
            tolerance: 'pointer'
        }).disableSelection();
        var $form = $('#move_columns_dialog').find('form');
        $form.data('serialized-unmoved', $form.serialize());

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

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

/**
     * Handles clicks on Action links in partition table
     */
    $(document).on('click', 'a[name^=partition_action].ajax', function (e) {
        e.preventDefault();
        var $link = $(this);

function submitPartitionAction (url) {
            var params = 'ajax_request=true&ajax_page_request=true&' + $link.getPostData();
            PMA_ajaxShowMessage();
            AJAX.source = $link;
            $.post(url, params, AJAX.responseHandler);
        }

if ($link.is('#partition_action_DROP')) {
            var question = PMA_messages.strDropPartitionWarning;
            $link.PMA_confirm(question, $link.attr('href'), function (url) {
                submitPartitionAction(url);
            });
        } else if ($link.is('#partition_action_TRUNCATE')) {
            var question = PMA_messages.strTruncatePartitionWarning;
            $link.PMA_confirm(question, $link.attr('href'), function (url) {
                submitPartitionAction(url);
            });
        } else {
            submitPartitionAction($link.attr('href'));
        }
    });

/**
     * Handles remove partitioning
     */
    $(document).on('click', '#remove_partitioning.ajax', function (e) {
        e.preventDefault();
        var $link = $(this);
        var question = PMA_messages.strRemovePartitioningWarning;
        $link.PMA_confirm(question, $link.attr('href'), function (url) {
            var params = getJSConfirmCommonParam({
                'ajax_request' : true,
                'ajax_page_request' : true
            }, $link.getPostData());
            PMA_ajaxShowMessage();
            AJAX.source = $link;
            $.post(url, params, AJAX.responseHandler);
        });
    });

$(document).on('change', 'select[name=after_field]', function () {
        checkFirst();
    });
});

/** Handler for "More" dropdown in structure table rows */
AJAX.registerOnload('tbl_structure.js', function () {
    var windowwidth = $(window).width();
    if (windowwidth > 768) {
        if (! $('#fieldsForm').hasClass('HideStructureActions')) {
            $('.table-structure-actions').width(function () {
                var width = 5;
                $(this).find('li').each(function () {
                    width += $(this).outerWidth(true);
                });
                return width;
            });
        }
    }

$('.jsresponsive').css('max-width', (windowwidth - 35) + 'px');
    var tableRows = $('.central_columns');
    $.each(tableRows, function (index, item) {
        if ($(item).hasClass('add_button')) {
            $(item).click(function () {
                $('input:checkbox').prop('checked', false);
                $('#checkbox_row_' + (index + 1)).prop('checked', true);
                $('button[value=add_to_central_columns]').click();
            });
        } else {
            $(item).click(function () {
                $('input:checkbox').prop('checked', false);
                $('#checkbox_row_' + (index + 1)).prop('checked', true);
                $('button[value=remove_from_central_columns]').click();
            });
        }
    });
});

003 File Manager

Editing: tbl_structure.js

Upload File

Create Folder