import $ from 'jquery';
import * as bootstrap from 'bootstrap';
import { AJAX } from '../modules/ajax.ts';
import { addDatepicker } from '../modules/functions.ts';
import { CommonParams } from '../modules/common.ts';
import highlightSql from '../modules/sql-highlight.ts';
import { ajaxRemoveMessage, ajaxShowMessage } from '../modules/ajax-message.ts';

/**
 * @fileoverview JavaScript functions used on /table/search
 */

/**
 * Checks if given data-type is numeric or date.
 *
 * @param {string} dataType Column data-type
 *
 * @return {boolean | string}
 */
const checkIfDataTypeNumericOrDate = function (dataType) {
    // To test for numeric data-types.
    const numericRegExp = new RegExp(
        'TINYINT|SMALLINT|MEDIUMINT|INT|BIGINT|DECIMAL|FLOAT|DOUBLE|REAL',
        'i',
    );

    // To test for date data-types.
    const 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;
};

const TableSelect = {
    checkIfDataTypeNumericOrDate: checkIfDataTypeNumericOrDate,
};
const UNARY_OPERATORS = [
    'IS NULL',
    'IS NOT NULL',
    '= \'\'',
    '!= \'\''
];

const opIsUnary = (op) => UNARY_OPERATORS.includes(op);

/**
 * 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');
    $('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"><button class="btn btn-sm btn-secondary" type="button" id="togglesearchformlink"></button></div>')
        .insertAfter('#tbl_search_form')
        // don't show it until we have results on-screen
        .hide();

    $('#togglesearchformlink')
        .html(window.Messages.strShowSearchCriteria)
        .on('click', function () {
            const $link = $(this);
            $('#tbl_search_form').slideToggle();
            if ($link.text() === window.Messages.strHideSearchCriteria) {
                $link.text(window.Messages.strShowSearchCriteria);
            } else {
                $link.text(window.Messages.strHideSearchCriteria);
            }

            // avoid default click action
            return false;
        });

    const tableRows = $('#fieldset_table_qbe select.column-operator');
    $.each(tableRows, function (index, item) {
        $(item).on('change', function () {
            window.changeValueFieldType(this, index);
            window.verifyAfterSearchFieldChange(index, '#tbl_search_form');
        });
    });

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

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

        // jQuery object to reuse
        const $searchForm = $(this);
        event.preventDefault();

        // Dispose tooltips. See #19950
        $('input.datefield, input.timefield').each(function () {
            const tooltipInstance = bootstrap.Tooltip.getInstance(this);
            tooltipInstance?.dispose();
        });

        // empty previous search results while we are waiting for new results
        $('#sqlqueryresultsouter').empty();
        const $msgbox = ajaxShowMessage(window.Messages.strSearching, false);

        const values: { [k: string]: any } = {};
        ($searchForm.find(':input') as JQuery<HTMLInputElement>).each(function () {
            const $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();
            }
        });

        const columnCount = $('select[name="columnsToDisplay[]"] option').length;
        // Submit values only for the columns that have unary column operator or a search criteria
        for (let a = 0; a < columnCount; a++) {
            if ($.inArray(values['criteriaColumnOperators[' + a + ']'], unaryFunctions) >= 0) {
                continue;
            }

            if (values['geom_func[' + a + ']'] &&
                $.inArray(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) {
            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');
                }

                $('#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(window.Messages.strShowSearchCriteria);

                $('#togglesearchformdiv')
                    // now it's time to show the div containing the link
                    .show();

                $('html, body').animate({ scrollTop: 0 }, 'fast');
            } else {
                $('#sqlqueryresultsouter').html(data.error);
            }

            highlightSql($('#sqlqueryresultsouter'));
        }); // end $.post()
    });

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

    $('select.geom_func').on('change', function () {
        const $geomFuncSelector = $(this);

        const 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',
        ];

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

        // If the chosen function takes two geometry objects as parameters
        const $operator = $geomFuncSelector.parents('tr').find('td').eq(4).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
        const $editorSpan = $geomFuncSelector.parents('tr').find('.open_search_gis_editor');
        if ($.inArray($geomFuncSelector.val(), outputGeomFunctions) >= 0) {
            $editorSpan.show();
        } else {
            $editorSpan.hide();
        }
    });

    const gisEditorModal = document.querySelector('#gisEditorModal.editor-for-search');
    gisEditorModal?.addEventListener('show.bs.modal', event => {
        // @ts-ignore
        const button = $(event.relatedTarget as HTMLButtonElement);
        // Current value
        let value = button.parent('td').children('input[type=\'text\']').val();
        // Field name
        const field = 'Parameter';
        // Column type
        const geomFunc = button.parents('tr').find('.geom_func').val();
        const type = 'GEOMETRY';
        if (!value) {
            if (geomFunc === 'Envelope') {
                value = 'POLYGON()';
            } else if (geomFunc === 'ExteriorRing') {
                value = 'LINESTRING()';
            } else {
                value = 'POINT()';
            }
        }

        // Names of input field and null checkbox
        const inputName = button.parent('td').children('input[type=\'text\']').attr('name');

        window.openGISEditor(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'
        // Get the column name.
        const columnName = $(this)
            .closest('tr')
            .find('th')
            .first()
            .text();

        // Get the data-type of column excluding size.
        let dataType: string | false = $(this)
            .closest('tr')
            .find('td[data-type]')
            .attr('data-type');
        dataType = TableSelect.checkIfDataTypeNumericOrDate(dataType);

        // Get the operator.
        const operator = ($(this).val() as string);
        const $targetField = $(this).closest('tr').find('[name*="criteriaValues"]');

        $targetField.prop('disabled', opIsUnary(operator));
        $targetField.siblings('.ui-datepicker-trigger').eq(0).toggle(!opIsUnary(operator));

        if ((operator === 'BETWEEN' || operator === 'NOT BETWEEN') && dataType) {
            const $msgbox = ajaxShowMessage();
            $.ajax({
                url: 'index.php?route=/table/search',
                type: 'POST',
                data: {
                    'server': CommonParams.get('server'),
                    'db': $('input[name="db"]').val(),
                    'table': $('input[name="table"]').val(),
                    'column': columnName,
                    'range_search': 1
                },
                success: function (response) {
                    ajaxRemoveMessage($msgbox);
                    if (response.success) {
                        // Get the column min value.
                        const min = response.column_data.min
                            ? '(' + window.Messages.strColumnMin +
                            ' ' + response.column_data.min + ')'
                            : '';
                        // Get the column max value.
                        const max = response.column_data.max
                            ? '(' + window.Messages.strColumnMax +
                            ' ' + response.column_data.max + ')'
                            : '';
                        $('#rangeSearchModal').modal('show');
                        $('#rangeSearchLegend').first().html(operator);
                        $('#rangeSearchMin').first().text(min);
                        $('#rangeSearchMax').first().text(max);
                        // Reset input values on reuse
                        $('#min_value').first().val('');
                        $('#max_value').first().val('');
                        // Add datepicker wherever required.
                        addDatepicker($('#min_value'), dataType);
                        addDatepicker($('#max_value'), dataType);
                        $('#rangeSearchModalGo').on('click', function () {
                            const minValue = ($('#min_value').val() as string);
                            const maxValue = ($('#max_value').val() as string);
                            let finalValue = '';
                            if (minValue.length && maxValue.length) {
                                finalValue = minValue + ', ' +
                                    maxValue;
                            }

                            // If target field is a select list.
                            if ($targetField.is('select')) {
                                $targetField.val(finalValue);
                                const $options = $targetField.find('option');
                                let $closestMin: JQuery<HTMLOptionElement> | null = null;
                                let $closestMax: JQuery<HTMLOptionElement> | null = null;
                                // Find closest min and max value.
                                $options.each(function () {
                                    if (
                                        $closestMin === null
                                        || Math.abs(Number($(this).val()) - Number(minValue)) < Math.abs(Number($closestMin.val()) - Number(minValue))
                                    ) {
                                        $closestMin = $(this);
                                    }

                                    if (
                                        $closestMax === null
                                        || Math.abs(Number($(this).val()) - Number(maxValue)) < Math.abs(Number($closestMax.val()) - Number(maxValue))
                                    ) {
                                        $closestMax = $(this);
                                    }
                                });

                                $closestMin.attr('selected', 'selected');
                                $closestMax.attr('selected', 'selected');
                            } else {
                                $targetField.val(finalValue);
                            }

                            $('#rangeSearchModal').modal('hide');
                            $(this).off('click');
                        });
                    } else {
                        ajaxShowMessage(response.error);
                    }
                },
                error: function () {
                    ajaxShowMessage(window.Messages.strErrorProcessingRequest);
                }
            });
        }
    });

    const windowWidth = $(window).width();
    $('.jsresponsive').css('max-width', (windowWidth - 69) + 'px');
});