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_select.js

/* vim: set expandtab sw=4 ts=4 sts=4: */
/**
 * @fileoverview JavaScript functions used on tbl_select.php
 *
 * @requires    jQuery
 * @requires    js/functions.js
 */

/**
 * Ajax event handlers for this page
 *
 * Actions ajaxified here:
 * Table search
 */

/**
 * Checks if given data-type is numeric or date.
 *
 * @param string data_type Column data-type
 *
 * @return bool|string
 */
function PMA_checkIfDataTypeNumericOrDate(data_type)
{
    // To test for numeric data-types.
    var numeric_re = new RegExp(
        'TINYINT|SMALLINT|MEDIUMINT|INT|BIGINT|DECIMAL|FLOAT|DOUBLE|REAL',
        'i'
    );

// To test for date data-types.
    var date_re = new RegExp(
        'DATETIME|DATE|TIMESTAMP|TIME|YEAR',
        'i'
    );

// Return matched data-type
    if (numeric_re.test(data_type)) {
        return numeric_re.exec(data_type)[0];
    }

if (date_re.test(data_type)) {
        return date_re.exec(data_type)[0];
    }

return false;
}

/**
 * Unbind all event handlers before tearing down a page
 */
AJAX.registerTeardown('tbl_select.js', function () {
    $('#togglesearchformlink').unbind('click');
    $(document).off('submit', "#tbl_search_form.ajax");
    $('select.geom_func').unbind('change');
    $(document).off('click', 'span.open_search_gis_editor');
    $('body').off('click', 'select[name*="criteriaColumnOperators"]');
});

AJAX.registerOnload('tbl_select.js', function () {
    /**
     * Prepare a div containing a link, otherwise it's incorrectly displayed
     * after a couple of clicks
     */
    $('<div id="togglesearchformdiv"><a id="togglesearchformlink"></a></div>')
        .insertAfter('#tbl_search_form')
        // don't show it until we have results on-screen
        .hide();

$('#togglesearchformlink')
        .html(PMA_messages.strShowSearchCriteria)
        .bind('click', function () {
            var $link = $(this);
            $('#tbl_search_form').slideToggle();
            if ($link.text() == PMA_messages.strHideSearchCriteria) {
                $link.text(PMA_messages.strShowSearchCriteria);
            } else {
                $link.text(PMA_messages.strHideSearchCriteria);
            }
            // avoid default click action
            return false;
        });

/**
     * Ajax event handler for Table search
     */
    $(document).on('submit', "#tbl_search_form.ajax", function (event) {
        var unaryFunctions = [
            'IS NULL',
            'IS NOT NULL',
            "= ''",
            "!= ''"
        ];

var geomUnaryFunctions = [
            'IsEmpty',
            'IsSimple',
            'IsRing',
            'IsClosed',
        ];

// jQuery object to reuse
        var $search_form = $(this);
        event.preventDefault();

// empty previous search results while we are waiting for new results
        $("#sqlqueryresultsouter").empty();
        var $msgbox = PMA_ajaxShowMessage(PMA_messages.strSearching, false);

PMA_prepareForAjaxRequest($search_form);

if (values['geom_func[' + a + ']'] &&
                $.isArray(values['geom_func[' + a + ']'], geomUnaryFunctions) >= 0) {
            	continue;
            }

if (values['criteriaValues[' + a + ']'] === '' || values['criteriaValues[' + a + ']'] === null) {
                delete values['criteriaValues[' + a + ']'];
                delete values['criteriaColumnOperators[' + a + ']'];
                delete values['criteriaColumnNames[' + a + ']'];
                delete values['criteriaColumnTypes[' + a + ']'];
                delete values['criteriaColumnCollations[' + a + ']'];
            }
        }
        // If all columns are selected, use a single parameter to indicate that
        if (values['columnsToDisplay[]'] !== null) {
            if (values['columnsToDisplay[]'].length == columnCount) {
                delete values['columnsToDisplay[]'];
                values.displayAllColumns = true;
            }
        } else {
            values.displayAllColumns = true;
        }
        values.token = PMA_commonParams.get('token');

$.post($search_form.attr('action'), values, function (data) {
            PMA_ajaxRemoveMessage($msgbox);
            if (typeof data !== 'undefined' && data.success === true) {
                if (typeof data.sql_query !== 'undefined') { // zero rows
                    $("#sqlqueryresultsouter").html(data.sql_query);
                } else { // results found
                    $("#sqlqueryresultsouter").html(data.message);
                    $(".sqlqueryresults").trigger('makegrid').trigger('stickycolumns');
                }
                $('#tbl_search_form')
                    // workaround for bug #3168569 - Issue on toggling the "Hide search criteria" in chrome.
                    .slideToggle()
                    .hide();
                $('#togglesearchformlink')
                    // always start with the Show message
                    .text(PMA_messages.strShowSearchCriteria);
                $('#togglesearchformdiv')
                    // now it's time to show the div containing the link
                    .show();
                // needed for the display options slider in the results
                PMA_init_slider();
                $('html, body').animate({scrollTop: 0}, 'fast');
            } else {
                $("#sqlqueryresultsouter").html(data.error);
            }
            PMA_highlightSQL($('#sqlqueryresultsouter'));
        }); // end $.post()
    });

// Following section is related to the 'function based search' for geometry data types.
    // Initialy hide all the open_gis_editor spans
    $('span.open_search_gis_editor').hide();

$('select.geom_func').bind('change', function () {
        var $geomFuncSelector = $(this);

var binaryFunctions = [
            'Contains',
            'Crosses',
            'Disjoint',
            'Equals',
            'Intersects',
            'Overlaps',
            'Touches',
            'Within',
            'MBRContains',
            'MBRDisjoint',
            'MBREquals',
            'MBRIntersects',
            'MBROverlaps',
            'MBRTouches',
            'MBRWithin',
            'ST_Contains',
            'ST_Crosses',
            'ST_Disjoint',
            'ST_Equals',
            'ST_Intersects',
            'ST_Overlaps',
            'ST_Touches',
            'ST_Within'
        ];

var tempArray = [
            'Envelope',
            'EndPoint',
            'StartPoint',
            'ExteriorRing',
            'Centroid',
            'PointOnSurface'
        ];
        var outputGeomFunctions = binaryFunctions.concat(tempArray);

// If the chosen function takes two geometry objects as parameters
        var $operator = $geomFuncSelector.parents('tr').find('td:nth-child(5)').find('select');
        if ($.inArray($geomFuncSelector.val(), binaryFunctions) >= 0) {
            $operator.prop('readonly', true);
        } else {
            $operator.prop('readonly', false);
        }

// if the chosen function's output is a geometry, enable GIS editor
        var $editorSpan = $geomFuncSelector.parents('tr').find('span.open_search_gis_editor');
        if ($.inArray($geomFuncSelector.val(), outputGeomFunctions) >= 0) {
            $editorSpan.show();
        } else {
            $editorSpan.hide();
        }

});

$(document).on('click', 'span.open_search_gis_editor', function (event) {
        event.preventDefault();

openGISEditor();
        if (!gisEditorLoaded) {
            loadJSAndGISEditor(value, field, type, input_name, token);
        } else {
            loadGISEditor(value, field, type, input_name, token);
        }
    });

/**
     * Ajax event handler for Range-Search.
     */
    $('body').on('click', 'select[name*="criteriaColumnOperators"]', function () {
        $source_select = $(this);
        // Get the column name.
        var column_name = $(this)
            .closest('tr')
            .find('th:first')
            .text();

// Get the data-type of column excluding size.
        var data_type = $(this)
            .closest('tr')
            .find('td[data-type]')
            .attr('data-type');
        data_type = PMA_checkIfDataTypeNumericOrDate(data_type);

// Get the operator.
        var operator = $(this).val();

if ((operator == 'BETWEEN' || operator == 'NOT BETWEEN')
            && data_type
        ) {
            var $msgbox = PMA_ajaxShowMessage();
            $.ajax({
                url: 'tbl_select.php',
                type: 'POST',
                data: {
                    server: PMA_commonParams.get('server'),
                    token: PMA_commonParams.get('token'),
                    ajax_request: 1,
                    db: $('input[name="db"]').val(),
                    table: $('input[name="table"]').val(),
                    column: column_name,
                    range_search: 1
                },
                success: function (response) {
                    PMA_ajaxRemoveMessage($msgbox);
                    if (response.success) {
                        // Get the column min value.
                        var min = response.column_data.min
                            ? '(' + PMA_messages.strColumnMin +
                                ' ' + response.column_data.min + ')'
                            : '';
                        // Get the column max value.
                        var max = response.column_data.max
                            ? '(' + PMA_messages.strColumnMax +
                                ' ' + response.column_data.max + ')'
                            : '';
                        var button_options = {};
                        button_options[PMA_messages.strGo] = function () {
                            var min_value = $('#min_value').val();
                            var max_value = $('#max_value').val();
                            var final_value = '';
                            if (min_value.length && max_value.length) {
                                final_value = min_value + ', ' +
                                    max_value;
                            }
                            var $target_field = $source_select.closest('tr')
                                .find('[name*="criteriaValues"]');

// If target field is a select list.
                            if ($target_field.is('select')) {
                                $target_field.val(final_value);
                                var $options = $target_field.find('option');
                                var $closest_min = null;
                                var $closest_max = null;
                                // Find closest min and max value.
                                $options.each(function () {
                                    if (
                                        $closest_min === null
                                        || Math.abs($(this).val() - min_value) < Math.abs($closest_min.val() - min_value)
                                    ) {
                                        $closest_min = $(this);
                                    }

if (
                                        $closest_max === null
                                        || Math.abs($(this).val() - max_value) < Math.abs($closest_max.val() - max_value)
                                    ) {
                                        $closest_max = $(this);
                                    }
                                });

$closest_min.attr('selected', 'selected');
                                $closest_max.attr('selected', 'selected');
                            } else {
                                $target_field.val(final_value);
                            }
                            $(this).dialog("close");
                        };
                        button_options[PMA_messages.strCancel] = function () {
                            $(this).dialog("close");
                        };

// Display dialog box.
                        $('<div/>').append(
                            '<fieldset>' +
                            '<legend>' + operator + '</legend>' +
                            '<label for="min_value">' + PMA_messages.strMinValue +
                            '</label>' +
                            '<input type="text" id="min_value" />' + '<br>' +
                            '<span class="small_font">' + min + '</span>' + '<br>' +
                            '<label for="max_value">' + PMA_messages.strMaxValue +
                            '</label>' +
                            '<input type="text" id="max_value" />' + '<br>' +
                            '<span class="small_font">' + max + '</span>' +
                            '</fieldset>'
                        ).dialog({
                            minWidth: 500,
                            maxHeight: 400,
                            modal: true,
                            buttons: button_options,
                            title: PMA_messages.strRangeSearch,
                            open: function () {
                                // Add datepicker wherever required.
                                PMA_addDatepicker($('#min_value'), data_type);
                                PMA_addDatepicker($('#max_value'), data_type);
                            },
                            close: function () {
                                $(this).remove();
                            }
                        });
                    } else {
                        PMA_ajaxShowMessage(response.error);
                    }
                },
                error: function (response) {
                    PMA_ajaxShowMessage(PMA_messages.strErrorProcessingRequest);
                }
            });
        }
    });
});

${this.title}

Code Editor : tbl_select.js