{% extends "engineering-tools-container.html" %}

{% block head %}
    {{ block.super }}
    <script>
        $(function () {
            function copy_text(text) {
                let $textarea = $('<textarea>')
                    .val(text)
                    .css({
                        position: 'fixed',
                        top: '-1000px',
                        left: '-1000px'
                    })
                    .appendTo('body');

                $textarea.select();
                document.execCommand('copy');
                $textarea.remove();
            }

            $('.copy-btn').on('click', function () {
                let $btn = $(this);
                let target_id = $btn.data('copy-target');
                let $pre = $('#' + target_id);

                if (!$pre.length) {
                    return;
                }

                copy_text($pre.text());

                let original_text = $btn.text();
                $btn
                    .addClass('copied')
                    .text('Copied');

                setTimeout(function () {
                    $btn
                        .removeClass('copied')
                        .text(original_text);
                }, 1500);
            });

            $('.analysis-btn').on('click', function (e) {
                e.preventDefault();

                let analysis_id = $(this).data('analysis-id');
                let target = document.getElementById('analysis-' + analysis_id);
                let original_id = target.id;

                target.id = '';
                window.location.hash = 'analysis-' + analysis_id;
                target.id = original_id;

                $('.analysis-block').hide();
                $('#analysis-' + analysis_id).show();

                $('#explain-analyze-header-tabs li').removeClass('active');
                $(this).closest('li').addClass('active');
            });

            let hash = window.location.hash;
            if (hash) {
                let analysis_id = hash.replace('#analysis-', '');
                let analysis_btn = $('.analysis-btn[data-analysis-id="' + analysis_id + '"]');

                if (!analysis_btn.length) {
                    analysis_btn = $('.analysis-btn[data-analysis-id="1"]');
                }

                if (analysis_btn.length) {
                    analysis_btn.trigger('click');
                }
            }
        });
    </script>

    <style>
        h2 {
            margin-top: 30px;
            display: flex;
            align-items: center;
            justify-content: space-between;
        }

        pre {
            background-color: #f8f8f8;
            padding: 15px;
            border: 1px solid #ccc;
            overflow-x: auto;
            white-space: pre;
            position: relative;
        }

        .copy-btn {
            font-size: 12px;
            padding: 4px 8px;
            cursor: pointer;
        }

        .copy-btn.copied {
            color: green;
        }

        .helper-row {
            display: flex;
            align-items: center;
            justify-content: space-between;
            margin-bottom: 4px;
        }

        .helper {
            font-size: 12px;
            color: #666;
            margin-bottom: 6px;
        }

        .no-analyses {
            display: flex;
            justify-content: center;
            align-items: center;
            height: 60vh;
        }
    </style>
{% endblock %}

{% block sub-content %}
{% if analyses %}
    <div class="analysis-buttons">
        <ul id="explain-analyze-header-tabs" class="nav nav-tabs">
            {% for analysis in analyses %}
                <li {% if analysis.id == 1 %}class="active"{% endif %}><a class="analysis-btn" data-analysis-id="{{ analysis.id }}">{{ analysis.id }}</a></li>
            {% endfor %}
        </ul>
    </div>
{% else %}
    <div class="no-analyses">
        <h1>No Saved Explain Analyze Outputs</h1>
    </div>
{% endif %}

{% for analysis in analyses %}
    <div class="analysis-block" id="analysis-{{ analysis.id }}" {% if analysis.id != 1 %}style="display: none;"{% endif %}>
        <h2>Query Ran at: {{ analysis.time_ran|date:"Y-m-d H:i:s A" }}</h2>
        <h2>Search Path ({{ analysis.id }})</h2>

        <div class="helper-row">
            <div class="helper">Use before running the query manually:</div>
            <button class="copy-btn" data-copy-target="search-path-set-{{ analysis.id }}">Copy</button>
        </div>
        <pre id="search-path-set-{{ analysis.id }}">SET search_path TO {{ analysis.search_path }};</pre>

        <div class="helper-row">
            <div class="helper">Reset after testing:</div>
            <button class="copy-btn" data-copy-target="search-path-reset-{{ analysis.id }}">Copy</button>
        </div>
        <pre id="search-path-reset-{{ analysis.id }}">RESET search_path;</pre>

        <h2>
            SQL ({{ analysis.id }})
            <button class="copy-btn" data-copy-target="sql-pre-{{ analysis.id }}">Copy</button>
        </h2>
        <pre id="sql-pre-{{ analysis.id }}">{{ analysis.sql_block }}</pre>

        <h2>
            EXPLAIN ANALYZE ({{ analysis.id }})
            <button class="copy-btn" data-copy-target="explain-pre-{{ analysis.id }}">Copy</button>
        </h2>
        <pre id="explain-pre-{{ analysis.id }}">{{ analysis.explain }}</pre>
    </div>
{% endfor %}
{% endblock %}