Gecko [ www.utparral.edu.mx ]

Name	Size	Permission
codemirror	[ DIR ]	drwxrwxr-x
jqplot	[ DIR ]	drwxrwxr-x
jquery	[ DIR ]	drwxrwxr-x
openlayers	[ DIR ]	drwxrwxr-x
pmd	[ DIR ]	drwxrwxr-x
tracekit	[ DIR ]	drwxrwxr-x
transformations	[ DIR ]	drwxrwxr-x
ajax.js	29.96 KB	-rwxrwxr-x
chart.js	17.84 KB	-rwxrwxr-x
common.js	18.55 KB	-rwxrwxr-x
config.js	26.25 KB	-rwxrwxr-x
console.js	57.08 KB	-rwxrwxr-x
cross_framing_protection.js	468 B	-rwxrwxr-x
db_central_columns.js	10.56 KB	-rwxrwxr-x
db_operations.js	5.89 KB	-rwxrwxr-x
db_qbe.js	2.04 KB	-rwxrwxr-x
db_search.js	8.53 KB	-rwxrwxr-x
db_structure.js	16.15 KB	-rwxrwxr-x
db_tracking.js	3.35 KB	-rwxrwxr-x
doclinks.js	20.16 KB	-rwxrwxr-x
error_report.js	9.94 KB	-rwxrwxr-x
export.js	33.33 KB	-rwxrwxr-x
functions.js	162.74 KB	-rwxrwxr-x
get_image.js.php	4.59 KB	-rwxrwxr-x
get_scripts.js.php	3.09 KB	-rwxrwxr-x
gis_data_editor.js	14.33 KB	-rwxrwxr-x
import.js	5.49 KB	-rwxrwxr-x
indexes.js	26.36 KB	-rwxrwxr-x
keyhandler.js	3.25 KB	-rwxrwxr-x
line_counts.php	44.13 KB	-rwxrwxr-x
makegrid.js	95.14 KB	-rwxrwxr-x
menu-resizer.js	6.48 KB	-rwxrwxr-x
messages.counts.js.php	460 B	-rwxrwxr-x
messages.php	39.53 KB	-rwxrwxr-x
microhistory.js	11.22 KB	-rwxrwxr-x
multi_column_sort.js	2.83 KB	-rwxrwxr-x
navigation.js	57.71 KB	-rwxrwxr-x
normalization.js	26.38 KB	-rwxrwxr-x
page_settings.js	1.66 KB	-rwxrwxr-x
replication.js	3.17 KB	-rwxrwxr-x
rte.js	46.83 KB	-rwxrwxr-x
server_databases.js	6.6 KB	-rwxrwxr-x
server_plugins.js	497 B	-rwxrwxr-x
server_privileges.js	17.78 KB	-rwxrwxr-x
server_status_advisor.js	3.57 KB	-rwxrwxr-x
server_status_monitor.js	83.52 KB	-rwxrwxr-x
server_status_processes.js	5.97 KB	-rwxrwxr-x
server_status_queries.js	934 B	-rwxrwxr-x
server_status_sorter.js	1.95 KB	-rwxrwxr-x
server_status_variables.js	3.2 KB	-rwxrwxr-x
server_user_groups.js	1.34 KB	-rwxrwxr-x
server_variables.js	5.74 KB	-rwxrwxr-x
shortcuts_handler.js	3.25 KB	-rwxrwxr-x
sprintf.js	7.21 KB	-rwxrwxr-x
sql.js	35.48 KB	-rwxrwxr-x
tbl_change.js	27.8 KB	-rwxrwxr-x
tbl_chart.js	13.61 KB	-rwxrwxr-x
tbl_find_replace.js	1.55 KB	-rwxrwxr-x
tbl_gis_visualization.js	10.64 KB	-rwxrwxr-x
tbl_operations.js	13.31 KB	-rwxrwxr-x
tbl_relation.js	8.46 KB	-rwxrwxr-x
tbl_select.js	15.18 KB	-rwxrwxr-x
tbl_structure.js	20.83 KB	-rwxrwxr-x
tbl_tracking.js	3.71 KB	-rwxrwxr-x
tbl_zoom_plot_jqplot.js	22.09 KB	-rwxrwxr-x
whitelist.php	1.24 KB	-rwxrwxr-x
zxcvbn.js	802.45 KB	-rwxrwxr-x

Code Editor : tbl_relation.js

/* vim: set expandtab sw=4 ts=4 sts=4: */
/**
 * for tbl_relation.php
 *
 */
function show_hide_clauses($thisDropdown)
{
    if ($thisDropdown.val() === '') {
        $thisDropdown.parent().nextAll('span').hide();
    } else {
        if ($thisDropdown.is('select[name^="destination_foreign_column"]')) {
            $thisDropdown.parent().nextAll('span').show();
        }
    }
}

/**
 * Sets dropdown options to values
 */
function setDropdownValues($dropdown, values, selectedValue) {
    $dropdown.empty();
    var optionsAsString = '';
    // add an empty string to the beginning for empty selection
    values.unshift('');
    $.each(values, function () {
        optionsAsString += "<option value='" + escapeHtml(this) + "'" + (selectedValue == this ? " selected='selected'" : "") + ">" + escapeHtml(this) + "</option>";
    });
    $dropdown.append($(optionsAsString));
}

/**
 * Retrieves and populates dropdowns to the left based on the selected value
 *
 * @param $dropdown the dropdown whose value got changed
 */
function getDropdownValues($dropdown) {
    var foreignDb = null, foreignTable = null;
    var $databaseDd, $tableDd, $columnDd;
    var foreign = '';
    // if the changed dropdown is for foreign key constraints
    if ($dropdown.is('select[name^="destination_foreign"]')) {
        $databaseDd = $dropdown.parent().parent().parent().find('select[name^="destination_foreign_db"]');
        $tableDd    = $dropdown.parent().parent().parent().find('select[name^="destination_foreign_table"]');
        $columnDd   = $dropdown.parent().parent().parent().find('select[name^="destination_foreign_column"]');
        foreign = '_foreign';
    } else { // internal relations
        $databaseDd = $dropdown.parent().find('select[name^="destination_db"]');
        $tableDd    = $dropdown.parent().find('select[name^="destination_table"]');
        $columnDd   = $dropdown.parent().find('select[name^="destination_column"]');
    }

// if the changed dropdown is a database selector
    if ($dropdown.is('select[name^="destination' + foreign + '_db"]')) {
        foreignDb = $dropdown.val();
        // if no database is selected empty table and column dropdowns
        if (foreignDb === '') {
            setDropdownValues($tableDd, []);
            setDropdownValues($columnDd, []);
            return;
        }
    } else { // if a table selector
        foreignDb = $databaseDd.val();
        foreignTable = $dropdown.val();
         // if no table is selected empty the column dropdown
        if (foreignTable === '') {
            setDropdownValues($columnDd, []);
            return;
        }
    }
    var $msgbox = PMA_ajaxShowMessage();
    var $form = $dropdown.parents('form');
    var url = 'tbl_relation.php?getDropdownValues=true&ajax_request=true' +
        '&token=' + $form.find('input[name="token"]').val() +
        '&db=' + $form.find('input[name="db"]').val() +
        '&table=' + $form.find('input[name="table"]').val() +
        '&foreign=' + (foreign !== '') +
        '&foreignDb=' + encodeURIComponent(foreignDb) +
        (foreignTable !== null ?
            '&foreignTable=' + encodeURIComponent(foreignTable) : ''
        );
    var $server = $form.find('input[name="server"]');
    if ($server.length > 0) {
        url += '&server=' + $form.find('input[name="server"]').val();
    }
    $.ajax({
        url: url,
        datatype: 'json',
        success: function (data) {
            PMA_ajaxRemoveMessage($msgbox);
            if (typeof data !== 'undefined' && data.success) {
                // if the changed dropdown is a database selector
                if (foreignTable === null) {
                    // set values for table and column dropdowns
                    setDropdownValues($tableDd, data.tables);
                    setDropdownValues($columnDd, []);
                } else { // if a table selector
                    // set values for the column dropdown
                    var primary = null;
                    if (typeof data.primary !== 'undefined'
                        && 1 === data.primary.length
                    ) {
                        primary = data.primary[0];
                    }
                    setDropdownValues($columnDd.first(), data.columns, primary);
                    setDropdownValues($columnDd.slice(1), data.columns);
                }
            } else {
                PMA_ajaxShowMessage(data.error, false);
            }
        }
    });
}

/**
 * Unbind all event handlers before tearing down a page
 */
AJAX.registerTeardown('tbl_relation.js', function () {
    $('body').off('change',
        'select[name^="destination_db"], ' +
        'select[name^="destination_table"], ' +
        'select[name^="destination_foreign_db"], ' +
        'select[name^="destination_foreign_table"]'
    );
    $('body').off('click', 'a.add_foreign_key_field');
    $('body').off('click', 'a.add_foreign_key');
    $('a.drop_foreign_key_anchor.ajax').off('click');
});

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

/**
     * Ajax event handler to fetch table/column dropdown values.
     */
    $('body').on('change',
        'select[name^="destination_db"], ' +
        'select[name^="destination_table"], ' +
        'select[name^="destination_foreign_db"], ' +
        'select[name^="destination_foreign_table"]',
        function () {
            getDropdownValues($(this));
        }
    );

/**
     * Ajax event handler to add a column to a foreign key constraint.
     */
    $('body').on('click', 'a.add_foreign_key_field', function (event) {
        event.preventDefault();
        event.stopPropagation();

// Add field.
        $(this)
        .prev('span')
        .clone(true, true)
        .insertBefore($(this))
        .find('select')
        .val('');

// Add foreign field.
        var $source_elem = $('select[name^="destination_foreign_column[' +
            $(this).attr('data-index') + ']"]:last').parent();
        $source_elem
        .clone(true, true)
        .insertAfter($source_elem)
        .find('select')
        .val('');
    });

/**
     * Ajax event handler to add a foreign key constraint.
     */
    $('body').on('click', 'a.add_foreign_key', function (event) {
        event.preventDefault();
        event.stopPropagation();

var $prev_row = $(this).closest('tr').prev('tr');
        var $new_row = $prev_row.clone(true, true);

// Update serial number.
        var curr_index = $new_row
            .find('a.add_foreign_key_field')
            .attr('data-index');
        var new_index = parseInt(curr_index) + 1;
        $new_row.find('a.add_foreign_key_field').attr('data-index', new_index);

// Update form parameter names.
        $new_row.find('select[name^="foreign_key_fields_name"]:not(:first), ' +
            'select[name^="destination_foreign_column"]:not(:first)'
        ).each(function () {
            $(this).parent().remove();
        });
        $new_row.find('input, select').each(function () {
            $(this).attr('name',
                $(this).attr('name').replace(/\d/, new_index)
            );
        });

// Finally add the row.
        $new_row.insertAfter($prev_row);
    });

/**
     * Ajax Event handler for 'Drop Foreign key'
     */
    $('a.drop_foreign_key_anchor.ajax').on('click', function (event) {
        event.preventDefault();
        var $anchor = $(this);

// Object containing reference to the current field's row
        var $curr_row = $anchor.parents('tr');

var drop_query = escapeHtml(
            $curr_row.children('td')
                .children('.drop_foreign_key_msg')
                .val()
        );

var question = PMA_sprintf(PMA_messages.strDoYouReally, drop_query);

$anchor.PMA_confirm(question, $anchor.attr('href'), function (url) {
            var $msg = PMA_ajaxShowMessage(PMA_messages.strDroppingForeignKey, false);
            var params = {
                'is_js_confirmed': 1,
                'ajax_request': true,
                'token': PMA_commonParams.get('token')
            };
            $.post(url, params, function (data) {
                if (data.success === true) {
                    PMA_ajaxRemoveMessage($msg);
                    PMA_commonActions.refreshMain(false, function () {
                        // Do nothing
                    });
                } else {
                    PMA_ajaxShowMessage(PMA_messages.strErrorProcessingRequest + " : " + data.error, false);
                }
            }); // end $.post()
        }); // end $.PMA_confirm()
    }); //end Drop Foreign key
});

${this.title}

Code Editor : tbl_relation.js