{% extends "support.html" %}


{% block head %}
    {{ block.super }}
    <script>
        function create_diff_view(old_sql, new_sql, type) {
            if (old_sql !== new_sql) {
                let diff = Diff.diffWordsWithSpace(old_sql, new_sql);
                let html = '';
                diff.forEach(function(part) {
                    let color = part.added ? 'lightgreen' :
                                part.removed ? 'salmon' : 'transparent';
                    html += `<span style="background-color:${color}">${part.value}</span>`;
                });


                if (type === 'extdb') {
                    $('#diff-extdb-output').html(html);
                } else if (type === 'dosis') {
                    $('#diff-dosis-output').html(html);
                }
                return true;
            } else {
                return false;
            }
        }

        function get_lookup_id(field, field_name) {
            var lookupid = field.attr("id");
            lookupid = lookupid.replace(field_name, "");
            return lookupid;
        }

        function jump_to_item(){
            if (window.location.hash !== ''){
                let extdb_lookup = $(window.location.hash + '-row');
                extdb_lookup.children().css('background-color', 'lightblue');

                let targetOffset = extdb_lookup.offset().top - $('thead').outerHeight();
                $('html, body').animate({ scrollTop: targetOffset }, 100);
            }
        }

        $(function () {
            $(document).tooltip();
            jump_to_item();

            let original_extdb_sql = $('#id_extdb_sql').val();
            let original_dosisdb_sql = $('#id_d2db_sql').val();

            $(".copyable").click(function (event) {
                const copiedSpan = $(this).find("span");
                const id = $(this).parent().attr('id').replace('-row', '');

                const textArea = document.createElement("textarea");
                textArea.value = window.location.protocol + '//' + location.host + location.pathname + '#' + id;
                history.pushState({}, '', '#' + id);
                document.body.appendChild(textArea);
                textArea.select();

                try {
                    document.execCommand('copy');
                    copiedSpan.css('display', 'inline');
                    setTimeout( function() {
                        copiedSpan.css('display', 'none');
                    }, 1000)
                } catch (err) {
                    console.error('Unable to copy to clipboard', err);
                }
                document.body.removeChild(textArea);
            });

            $("input[id$='-active']").click(function () {
                $.post("{% url 'support:support-update-pms-extdb-request-lookup-active' %}",
                        {'csrfmiddlewaretoken': '{{csrf_token}}',
                            lookup_id: get_lookup_id($(this), "-active"),
                            field_val: $(this).prop("checked")});
            });

            $("#edit-pms-extdb-request-lookup").dialog({
                {% if showAddEdit == 'Y' %}
                    autoOpen: true,
                {% else %}
                    autoOpen: false,
                {% endif %}
                closeOnEscape: false,
                modal: true,
                draggable: false,
                width: 1400,
                buttons: [
                    {
                        text: "Close",
                        "class": 'modal-dialog-button-right',
                        click: function () {
                            $(this).dialog("close");
                            window.location.href = "{% url 'support:support-manage-pms-extdb-request-lookup' pms.id %}?sort={{ current_sort }}";
                        }
                    },
                    {
                        text: "Save",
                        "class": 'modal-dialog-button-left',
                        click: function () {
                            $("#editExtdbRequestLookupForm").validate();
                            if ($("#editExtdbRequestLookupForm").valid()) {
                                let new_extdb_sql = $('#id_extdb_sql').val();
                                let new_dosis_sql = $('#id_d2db_sql').val();
                                let has_extdb_diff = create_diff_view(original_extdb_sql, new_extdb_sql, 'extdb');
                                let has_dosis_diff = create_diff_view(original_dosisdb_sql, new_dosis_sql, 'dosis');
                                if (has_extdb_diff || has_dosis_diff) {
                                    $("#diff-data-modal").dialog("open");
                                } else {
                                    document.editExtdbRequestLookupForm.submit();
                                    $(this).dialog("close");
                                }
                            }
                        }
                    }
                ]
            });

            $("#diff-data-modal").dialog({
                autoOpen: false,
                closeOnEscape: false,
                modal: true,
                draggable: false,
                width: 1600,
                position: { my: "top", at: "top", of: window },
                buttons: [
                    {
                        text: "Close",
                        "class": 'modal-dialog-button-left',
                        click: function () {
                            $(this).dialog("close");
                            $('#diff-dosis-output').html('No Dosis DB changes made');
                            $('#diff-extdb-output').html('No External DB changes made');
                        }
                    },
                    {
                        text: "Save",
                        "class": 'modal-dialog-button-right',
                        click: function () {
                            document.editExtdbRequestLookupForm.submit();
                        }
                    }
                ],
                open: function () {
                    // force page scroll to top
                    $('html, body').scrollTop(0);
                    // then reposition the dialog at the top of the window
                    $(this).dialog("option", "position", { my: "top", at: "top", of: window });
                    // ensure modal itself starts at top
                    $(this).scrollTop(0);
                }
            });

            $("#btn-add-extdb-request-lookup").click(function () {
                window.location.href = "{% url 'support:support-add-pms-extdb-request-lookup' pms.id %}";
            });

            {% if showAddEdit == 'Y' %}
                $("#editExtdbRequestLookupForm").validate({
                    onkeyup: false,
                    errorContainer: $("#edit-extdb-request-lookup-validation-alert"),
                    errorLabelContainer: $("ul", $("#edit-extdb-request-lookup-validation-alert")),
                    wrapper: 'li'
                });

                $("#id_tag").keyup(function () {
                    this.value = this.value.toUpperCase();
                });

                 $("#id_tag").rules('add', {
                    required: true,
                    messages: {
                        required: "External Db Request Lookup tag cannot be blank."
                    }
                });

                 $("#id_description").rules('add', {
                    required: true,
                    messages: {
                        required: "External Db Request Lookup description cannot be blank."
                    }
                });

                $("#id_d2db_fields").rules('add', {
                    required: true,
                    messages: {
                        required: "External Db Request Lookup Dosis database fields cannot be blank."
                    }
                });

                $("#id_extdb_fields").rules('add', {
                    required: true,
                    messages: {
                        required: "External Db Request Lookup external database fields cannot be blank."
                    }
                });

//                $("#id_d2db_sql").rules('add', {
//                    required: true,
//                    messages: {
//                        required: "External Db Request Lookup Dosis database SQL cannot be blank."
//                    }
//                });

//                $("#id_extdb_sql").rules('add', {
//                    required: true,
//                    messages: {
//                        required: "External Db Request Lookup external database SQL cannot be blank."
//                    }
//                });

                $("#id_proc_order").rules('add', {
                    required: true,
                    digits: true,
                    messages: {
                        required: "External Db Request Lookup processing order cannot be blank.",
                        digits: "External Db Request Lookup processing order must be numeric."
                    }
                });

            {% endif %}

        });
    </script>
{% endblock %}

{% block pagehead %}
    {% include 'pagehead.html' %}
{% endblock %}

{% block content %}
    <p><a href="{% url 'support:support-manage-interface' %}">Back To Manage PMIS Interface</a></p>
    <form id="pmsExtdbRequestLookupForm" name="pmsExtdbRequestLookupForm" method="POST">
    {% csrf_token %}
    <div>
        <table class="table table-bordered table-striped">
            <thead style="position: sticky; top: 0;">
            <tr class="dosis-report-header">
                {% include 'report-table-header.html' %}
                <th><i class="icon-list"></i></th>
            </tr>
            </thead>
            <tbody>
            {% for lookup in lookup_list %}
                <tr id="{{ lookup.id }}-row">
                    <td style="padding-bottom: 2px;" class="copyable">{{ lookup.tag }}<span style="display: none; margin-left: -70px; padding: 5px 12px; background-color: #000000df; border-radius: 4px; color: #fff; position: absolute;">Link to Extdb Lookup Copied!</span></td>
                    <td style="padding-bottom: 2px;">{{ lookup.description }}</td>
                    <td style="padding-bottom: 2px;">{{ lookup.extdb_request_type}}</td>
                    <td style="padding-bottom: 2px;">{{ lookup.extdb_conn_type }}</td>
                    <td style="padding-bottom: 2px;">{% for itm in lookup.d2db_fields %}{% if not forloop.first %}, {% endif %}{{ itm }}{% endfor %}</td>
                    <td style="padding-bottom: 2px;">{% for itm in lookup.extdb_fields %}{% if not forloop.first %}, {% endif %}{{ itm }}{% endfor %}</td>
                    <td style="padding-bottom: 2px;">{{ lookup.proc_order }}</td>
                    <td style="padding-bottom: 2px;"><input type="checkbox" id="{{ lookup.id }}-active" name="{{ lookup.id }}-active" {% if lookup.active %}checked{% endif %}/></td>
                    <td><a href="{% url 'support:support-edit-pms-extdb-request-lookup' pms.id lookup.id %}?sort={{ current_sort }}">
                        <i title="Edit Extdb Request Lookup" class="icon-pencil"></i></a></td>
                </tr>
            {% endfor %}
            </tbody>
        </table>
    </div>
    <div>
            <span><button style="float: left;" type="button" name="btn-add-extdb-request-lookup"
                          id="btn-add-extdb-request-lookup" class="btn">Add
                Extdb Request Lookup
            </button>
            </span>
    </div>
    </form>
    <div id="edit-pms-extdb-request-lookup" title="Edit PMIS Extdb Request Lookup" style="margin-left: 2px;">
        <form id="editExtdbRequestLookupForm" name="editExtdbRequestLookupForm" method="POST">
            {% csrf_token %}
            <div class="alert alert-error" id="edit-extdb-request-lookup-validation-alert" style="display: none;">
                <button type="button" class="close" data-dismiss="alert">&times;</button>
                <ul id="edit-extdb-request-lookup-validation-error-list">
                </ul>
            </div>
            <table style="width: 100%;">
                <tr>
                    <td class="site-drug-edit-td">{{ edit_form.interface }}Tag: {{ edit_form.tag }}</td>
                </tr>
                <tr>
                    <td class="site-drug-edit-td">Description: {{ edit_form.description }}</td>
                </tr>
                <tr>
                    <td class="site-drug-edit-td">External Db Request Type: {{ edit_form.extdb_request_type }}</td>
                </tr>
                <tr>
                    <td class="site-drug-edit-td">External Db Connection Type: {{ edit_form.extdb_conn_type }}</td>
                </tr>
                <tr>
                    <td class="site-drug-edit-td">Process Order: {{ edit_form.proc_order }}&nbsp;&nbsp;&nbsp;
                    {{ edit_form.active }} Active?</td>
                </tr>
                <tr>
                    <td class="site-drug-edit-td">Dosis Db Fields: {{ edit_form.d2db_fields }}</td>
                </tr>
                <tr>
                    <td class="site-drug-edit-td">External Db Fields: {{ edit_form.extdb_fields }}</td>
                </tr>
                <tr>
                    <td class="site-drug-edit-td">Dosis Db SQL: {{ edit_form.d2db_sql }}</td>
                </tr>
                <tr>
                    <td class="site-drug-edit-td">External Db SQL: {{ edit_form.extdb_sql }}</td>
                </tr>
            </table>
        </form>
    </div>

    <div id="diff-data-modal" title="ExtDBlookup diff" style="margin-left: 2px;">
        <div id="diff-dosis-output" style="white-space: pre; overflow-x: auto; font-family: monospace; padding: 4px;">No Dosis DB changes made</div>
        <hr style="margin: 8px 0; border: 0; border-top: 3px solid black;">
        <div id="diff-extdb-output" style="white-space: pre; overflow-x: auto; font-family: monospace; padding: 4px;">No External DB changes made</div>
    </div>
{% endblock %}