phpmyadmin working

1 files changed, 409 insertions, 0 deletions

diff --git a/srcs/phpmyadmin/js/table/select.js b/srcs/phpmyadmin/js/table/select.js
new file mode 100644
index 0000000..3050e3c
--- /dev/null
+++ b/srcs/phpmyadmin/js/table/select.js
@@ -0,0 +1,409 @@
+/* vim: set expandtab sw=4 ts=4 sts=4: */
+/**
+ * @fileoverview JavaScript functions used on tbl_select.php
+ *
+ * @requires    jQuery
+ * @requires    js/functions.js
+ */
+
+/* global changeValueFieldType */ // js/table/change.js
+/* global openGISEditor, gisEditorLoaded, loadJSAndGISEditor, loadGISEditor */ // js/gis_data_editor.js
+
+var TableSelect = {};
+
+/**
+ * Checks if given data-type is numeric or date.
+ *
+ * @param {string} dataType Column data-type
+ *
+ * @return {(boolean|string)}
+ */
+TableSelect.checkIfDataTypeNumericOrDate = function (dataType) {
+    // To test for numeric data-types.
+    var numericRegExp = new RegExp(
+        'TINYINT|SMALLINT|MEDIUMINT|INT|BIGINT|DECIMAL|FLOAT|DOUBLE|REAL',
+        'i'
+    );
+
+    // To test for date data-types.
+    var dateRegExp = new RegExp(
+        'DATETIME|DATE|TIMESTAMP|TIME|YEAR',
+        'i'
+    );
+
+    // Return matched data-type
+    if (numericRegExp.test(dataType)) {
+        return numericRegExp.exec(dataType)[0];
+    }
+
+    if (dateRegExp.test(dataType)) {
+        return dateRegExp.exec(dataType)[0];
+    }
+
+    return false;
+};
+
+/**
+ * Unbind all event handlers before tearing down a page
+ */
+AJAX.registerTeardown('table/select.js', function () {
+    $('#togglesearchformlink').off('click');
+    $(document).off('submit', '#tbl_search_form.ajax');
+    $('select.geom_func').off('change');
+    $(document).off('click', 'span.open_search_gis_editor');
+    $('body').off('change', 'select[name*="criteriaColumnOperators"]'); // Fix for bug #13778, changed 'click' to 'change'
+});
+
+AJAX.registerOnload('table/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(Messages.strShowSearchCriteria)
+        .on('click', function () {
+            var $link = $(this);
+            $('#tbl_search_form').slideToggle();
+            if ($link.text() === Messages.strHideSearchCriteria) {
+                $link.text(Messages.strShowSearchCriteria);
+            } else {
+                $link.text(Messages.strHideSearchCriteria);
+            }
+            // avoid default click action
+            return false;
+        });
+
+    var tableRows = $('#fieldset_table_qbe select');
+    $.each(tableRows, function (index, item) {
+        $(item).on('change', function () {
+            changeValueFieldType(this, index);
+        });
+    });
+
+    /**
+     * 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 $searchForm = $(this);
+        event.preventDefault();
+
+        // empty previous search results while we are waiting for new results
+        $('#sqlqueryresultsouter').empty();
+        var $msgbox = Functions.ajaxShowMessage(Messages.strSearching, false);
+
+        Functions.prepareForAjaxRequest($searchForm);
+
+        var values = {};
+        $searchForm.find(':input').each(function () {
+            var $input = $(this);
+            if ($input.attr('type') === 'checkbox' || $input.attr('type') === 'radio') {
+                if ($input.is(':checked')) {
+                    values[this.name] = $input.val();
+                }
+            } else {
+                values[this.name] = $input.val();
+            }
+        });
+        var columnCount = $('select[name="columnsToDisplay[]"] option').length;
+        // Submit values only for the columns that have unary column operator or a search criteria
+        for (var a = 0; a < columnCount; a++) {
+            if ($.inArray(values['criteriaColumnOperators[' + a + ']'], unaryFunctions) >= 0) {
+                continue;
+            }
+
+            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;
+        }
+
+        $.post($searchForm.attr('action'), values, function (data) {
+            Functions.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(Messages.strShowSearchCriteria);
+                $('#togglesearchformdiv')
+                    // now it's time to show the div containing the link
+                    .show();
+                // needed for the display options slider in the results
+                Functions.initSlider();
+                $('html, body').animate({ scrollTop: 0 }, 'fast');
+            } else {
+                $('#sqlqueryresultsouter').html(data.error);
+            }
+            Functions.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').on('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();
+
+        var $span = $(this);
+        // Current value
+        var value = $span.parent('td').children('input[type=\'text\']').val();
+        // Field name
+        var field = 'Parameter';
+        // Column type
+        var geomFunc = $span.parents('tr').find('.geom_func').val();
+        var type;
+        if (geomFunc === 'Envelope') {
+            type = 'polygon';
+        } else if (geomFunc === 'ExteriorRing') {
+            type = 'linestring';
+        } else {
+            type = 'point';
+        }
+        // Names of input field and null checkbox
+        var inputName = $span.parent('td').children('input[type=\'text\']').attr('name');
+        // Token
+
+        openGISEditor();
+        if (!gisEditorLoaded) {
+            loadJSAndGISEditor(value, field, type, inputName);
+        } else {
+            loadGISEditor(value, field, type, inputName);
+        }
+    });
+
+    /**
+     * Ajax event handler for Range-Search.
+     */
+    $('body').on('change', 'select[name*="criteriaColumnOperators"]', function () { // Fix for bug #13778, changed 'click' to 'change'
+        var $sourceSelect = $(this);
+        // Get the column name.
+        var columnName = $(this)
+            .closest('tr')
+            .find('th:first')
+            .text();
+
+        // Get the data-type of column excluding size.
+        var dataType = $(this)
+            .closest('tr')
+            .find('td[data-type]')
+            .attr('data-type');
+        dataType = TableSelect.checkIfDataTypeNumericOrDate(dataType);
+
+        // Get the operator.
+        var operator = $(this).val();
+
+        if ((operator === 'BETWEEN' || operator === 'NOT BETWEEN') && dataType) {
+            var $msgbox = Functions.ajaxShowMessage();
+            $.ajax({
+                url: 'tbl_select.php',
+                type: 'POST',
+                data: {
+                    'server': CommonParams.get('server'),
+                    'ajax_request': 1,
+                    'db': $('input[name="db"]').val(),
+                    'table': $('input[name="table"]').val(),
+                    'column': columnName,
+                    'range_search': 1
+                },
+                success: function (response) {
+                    Functions.ajaxRemoveMessage($msgbox);
+                    if (response.success) {
+                        // Get the column min value.
+                        var min = response.column_data.min
+                            ? '(' + Messages.strColumnMin +
+                                ' ' + response.column_data.min + ')'
+                            : '';
+                        // Get the column max value.
+                        var max = response.column_data.max
+                            ? '(' + Messages.strColumnMax +
+                                ' ' + response.column_data.max + ')'
+                            : '';
+                        var buttonOptions = {};
+                        buttonOptions[Messages.strGo] = function () {
+                            var minValue = $('#min_value').val();
+                            var maxValue = $('#max_value').val();
+                            var finalValue = '';
+                            if (minValue.length && maxValue.length) {
+                                finalValue = minValue + ', ' +
+                                    maxValue;
+                            }
+                            var $targetField = $sourceSelect.closest('tr')
+                                .find('[name*="criteriaValues"]');
+
+                            // If target field is a select list.
+                            if ($targetField.is('select')) {
+                                $targetField.val(finalValue);
+                                var $options = $targetField.find('option');
+                                var $closestMin = null;
+                                var $closestMax = null;
+                                // Find closest min and max value.
+                                $options.each(function () {
+                                    if (
+                                        $closestMin === null
+                                        || Math.abs($(this).val() - minValue) < Math.abs($closestMin.val() - minValue)
+                                    ) {
+                                        $closestMin = $(this);
+                                    }
+
+                                    if (
+                                        $closestMax === null
+                                        || Math.abs($(this).val() - maxValue) < Math.abs($closestMax.val() - maxValue)
+                                    ) {
+                                        $closestMax = $(this);
+                                    }
+                                });
+
+                                $closestMin.attr('selected', 'selected');
+                                $closestMax.attr('selected', 'selected');
+                            } else {
+                                $targetField.val(finalValue);
+                            }
+                            $(this).dialog('close');
+                        };
+                        buttonOptions[Messages.strCancel] = function () {
+                            $(this).dialog('close');
+                        };
+
+                        // Display dialog box.
+                        $('<div></div>').append(
+                            '<fieldset>' +
+                            '<legend>' + operator + '</legend>' +
+                            '<label for="min_value">' + Messages.strMinValue +
+                            '</label>' +
+                            '<input type="text" id="min_value">' + '<br>' +
+                            '<span class="small_font">' + min + '</span>' + '<br>' +
+                            '<label for="max_value">' + Messages.strMaxValue +
+                            '</label>' +
+                            '<input type="text" id="max_value">' + '<br>' +
+                            '<span class="small_font">' + max + '</span>' +
+                            '</fieldset>'
+                        ).dialog({
+                            width: 'auto',
+                            maxHeight: 400,
+                            modal: true,
+                            buttons: buttonOptions,
+                            title: Messages.strRangeSearch,
+                            open: function () {
+                                // Add datepicker wherever required.
+                                Functions.addDatepicker($('#min_value'), dataType);
+                                Functions.addDatepicker($('#max_value'), dataType);
+                            },
+                            close: function () {
+                                $(this).remove();
+                            }
+                        });
+                    } else {
+                        Functions.ajaxShowMessage(response.error);
+                    }
+                },
+                error: function () {
+                    Functions.ajaxShowMessage(Messages.strErrorProcessingRequest);
+                }
+            });
+        }
+    });
+    var windowWidth = $(window).width();
+    $('.jsresponsive').css('max-width', (windowWidth - 69) + 'px');
+});