{% extends 'admin/master.html' %}

{% block body %}
<div class="container mt-4">
    <h3>Checkmk Data Quality Check</h3>
    <p>
        Provide a list of hostnames — paste them into the text box or upload a
        CSV — and check them against a Checkmk account's monitoring data. For
        every host you see whether it is present, whether it exists under a
        different name/domain, whether its agent works (the <code>Check_MK</code>
        service), which contact groups may see it and which CMDB template it
        carries in the syncer. Missing hosts can be created as internal CMDB
        objects, and hosts that are already there can be given a template
        afterwards. Checking itself changes nothing in Checkmk.
    </p>

    {% if not accounts %}
    <div class="alert alert-warning">
        No enabled Checkmk (cmkv2) account found. Create one first.
    </div>
    {% endif %}

    <form method="POST" action="{{ url_for('.index') }}" enctype="multipart/form-data"
          class="card app-card mb-4">
        <div class="card-body">
            <input type="hidden" name="csrf_token" value="{{ csrf_token() }}"/>
            <div class="form-group">
                <label for="account">Checkmk account</label>
                <select class="form-control" id="account" name="account" required>
                    <option value="">— select account —</option>
                    {% for account in accounts %}
                    <option value="{{ account }}"
                            {% if account == selected_account %}selected{% endif %}>
                        {{ account }}
                    </option>
                    {% endfor %}
                </select>
            </div>
            <div class="form-group">
                <label for="hostnames_text">Paste hostnames</label>
                <textarea class="form-control" id="hostnames_text" name="hostnames_text"
                          rows="6" placeholder="one per line, or comma-separated"></textarea>
                <small class="form-text text-muted">
                    Paste hostnames here — one per line or separated by commas.
                </small>
            </div>
            <div class="form-group">
                <label for="csv_file">…or upload a CSV</label>
                <input type="file" class="form-control-file" id="csv_file"
                       name="csv_file" accept=".csv,text/csv"/>
                <small class="form-text text-muted">
                    A header column named <code>hostname</code>, <code>host</code>
                    or <code>name</code> is used automatically; otherwise the
                    first column is taken. The pasted text takes precedence if
                    both are filled.
                </small>
            </div>
            <button type="submit" class="btn btn-primary">
                <i class="fa fa-search"></i> Run check
            </button>
        </div>
    </form>

    <hr class="my-4"/>

    {# Account-wide checks — no host list needed, unrelated to the CSV/paste check above. #}
    <form method="POST" action="{{ url_for('.uppercase_scan') }}"
          class="card app-card mb-4">
        <div class="card-header">Account-wide checks</div>
        <div class="card-body">
            <input type="hidden" name="csrf_token" value="{{ csrf_token() }}"/>
            <p class="text-muted">
                Scan a Checkmk account for hosts with uppercase letters or
                without a fully-qualified name.
            </p>
            <div class="form-group">
                <label for="scan_account">Checkmk account</label>
                <select class="form-control" id="scan_account" name="account" required>
                    <option value="">— select account —</option>
                    {% for account in accounts %}
                    <option value="{{ account }}"
                            {% if account == selected_account %}selected{% endif %}>
                        {{ account }}
                    </option>
                    {% endfor %}
                </select>
            </div>
            <button type="submit" class="btn btn-outline-secondary"
                    formaction="{{ url_for('.uppercase_scan') }}">
                <i class="fa fa-font"></i> Find uppercase names
            </button>
            <button type="submit" class="btn btn-outline-secondary"
                    formaction="{{ url_for('.non_fqdn_scan') }}">
                <i class="fa fa-globe"></i> Find hosts without FQDN
            </button>
        </div>
    </form>

    {% if uppercase %}
    <div class="card app-card mb-4">
        <div class="card-header">
            Hosts with uppercase letters in <strong>{{ selected_account }}</strong>
            <span class="badge badge-warning ml-1">{{ uppercase.hosts | length }}</span>
            <span class="text-muted">of {{ uppercase.total }} scanned</span>
        </div>
        <div class="card-body">
            {% if uppercase.hosts %}
            <div class="table-responsive">
                <table class="table table-striped table-hover">
                    <thead>
                        <tr>
                            <th>Name in Checkmk</th>
                            <th>Lowercase</th>
                        </tr>
                    </thead>
                    <tbody>
                        {% for host in uppercase.hosts %}
                        <tr>
                            <td><code>{{ host.name }}</code></td>
                            <td><code class="text-muted">{{ host.suggested }}</code></td>
                        </tr>
                        {% endfor %}
                    </tbody>
                </table>
            </div>
            {% else %}
            <p class="text-muted mb-0">
                No monitored host in this account has uppercase letters in its
                name.
            </p>
            {% endif %}
        </div>
    </div>
    {% endif %}

    {% if non_fqdn %}
    <div class="card app-card mb-4">
        <div class="card-header">
            Hosts without an FQDN in <strong>{{ selected_account }}</strong>
            <span class="badge badge-warning ml-1">{{ non_fqdn.hosts | length }}</span>
            <span class="text-muted">of {{ non_fqdn.total }} scanned</span>
        </div>
        <div class="card-body">
            {% if non_fqdn.hosts %}
            <div class="table-responsive">
                <table class="table table-striped table-hover">
                    <thead>
                        <tr>
                            <th>Name in Checkmk (no domain part)</th>
                        </tr>
                    </thead>
                    <tbody>
                        {% for host in non_fqdn.hosts %}
                        <tr>
                            <td><code>{{ host.name }}</code></td>
                        </tr>
                        {% endfor %}
                    </tbody>
                </table>
            </div>
            {% else %}
            <p class="text-muted mb-0">
                Every monitored host in this account has a fully-qualified name.
            </p>
            {% endif %}
        </div>
    </div>
    {% endif %}

    {% if report %}
    {% set s = report.summary %}
    <div class="card app-card mb-4">
        <div class="card-header">Summary for <strong>{{ selected_account }}</strong></div>
        <div class="card-body">
            <span class="badge badge-secondary mr-1">Checked: {{ s.total }}</span>
            <span class="badge badge-success mr-1">Present: {{ s.found }}</span>
            <span class="badge badge-warning mr-1">Different name: {{ s.domain_mismatch }}</span>
            <span class="badge badge-danger mr-1">Missing: {{ s.missing }}</span>
            <span class="badge badge-light mr-1">·</span>
            <span class="badge badge-success mr-1">Agent OK: {{ s.agent_ok }}</span>
            <span class="badge badge-warning mr-1">Agent problem: {{ s.agent_problem }}</span>
            <span class="badge badge-secondary mr-1">No agent: {{ s.no_agent }}</span>
            <span class="badge badge-light mr-1">·</span>
            <span class="badge badge-info mr-1">In CMDB: {{ s.in_cmdb }}</span>
            <span class="badge badge-success mr-1">With template: {{ s.with_template }}</span>
            <span class="badge badge-warning mr-1">Without template: {{ s.without_template }}</span>
        </div>
    </div>

    <div class="mb-2">
        <button type="button" class="btn btn-sm btn-outline-secondary" id="dq_copy">
            <i class="fa fa-clipboard"></i> Copy result
        </button>
        <button type="button" class="btn btn-sm btn-outline-secondary" id="dq_csv">
            <i class="fa fa-download"></i> Download CSV
        </button>
    </div>

    <div class="table-responsive">
        <table class="table table-striped table-hover" id="dq_table">
            <thead>
                <tr>
                    <th>Host</th>
                    <th>Status</th>
                    <th>Name in Checkmk</th>
                    <th>Host state</th>
                    <th>Agent</th>
                    <th>CMDB template</th>
                    <th>Contact groups</th>
                </tr>
            </thead>
            <tbody>
                {% for row in report.results %}
                <tr>
                    <td><code>{{ row.hostname }}</code></td>
                    <td>
                        {% if row.status == 'found' %}
                        <span class="badge badge-success">Present</span>
                        {% elif row.status == 'domain_mismatch' %}
                        <span class="badge badge-warning">Different name</span>
                        {% else %}
                        <span class="badge badge-danger">Not found</span>
                        {% endif %}
                    </td>
                    <td>
                        {% if row.status == 'domain_mismatch' %}
                        <code>{{ row.matched_names | join(', ') }}</code>
                        {% elif row.status == 'found' %}
                        <span class="text-muted">(same)</span>
                        {% else %}
                        <span class="text-muted">—</span>
                        {% endif %}
                    </td>
                    <td>
                        {% if row.host_state == 'UP' %}
                        <span class="badge badge-success">UP</span>
                        {% elif row.host_state is not none %}
                        <span class="badge badge-danger">{{ row.host_state }}</span>
                        {% else %}
                        <span class="text-muted">—</span>
                        {% endif %}
                    </td>
                    <td>
                        {% if row.agent_state == 'OK' %}
                        <span class="badge badge-success" title="{{ row.agent_output }}">OK</span>
                        {% elif row.agent_state is not none %}
                        <span class="badge badge-warning" title="{{ row.agent_output }}">
                            {{ row.agent_state }}
                        </span>
                        {% elif row.exists %}
                        <span class="badge badge-secondary"
                              title="No Check_MK service found for this host">No agent</span>
                        {% else %}
                        <span class="text-muted">—</span>
                        {% endif %}
                    </td>
                    <td>
                        {% if row.cmdb_name is none %}
                        <span class="text-muted" title="No host of this name in the syncer CMDB">
                            not in CMDB
                        </span>
                        {% elif row.cmdb_templates %}
                        {% for tpl in row.cmdb_templates %}
                        <span class="badge badge-success mr-1">{{ tpl }}</span>
                        {% endfor %}
                        {% else %}
                        <span class="badge badge-warning"
                              title="Host {{ row.cmdb_name }} exists in the CMDB but carries no template">
                            no template
                        </span>
                        {% endif %}
                    </td>
                    <td>
                        {% if row.contact_groups %}
                        {% for group in row.contact_groups %}
                        <span class="badge badge-info mr-1">{{ group }}</span>
                        {% endfor %}
                        {% elif row.exists %}
                        <span class="text-muted">none</span>
                        {% else %}
                        <span class="text-muted">—</span>
                        {% endif %}
                    </td>
                </tr>
                {% endfor %}
            </tbody>
        </table>
    </div>

    {# One list for every template picker on the page — both forms point at it. #}
    <datalist id="dq_templates">
        {% for tpl in templates %}
        <option value="{{ tpl }}"></option>
        {% endfor %}
    </datalist>

    {% set missing = report.results | selectattr('status', 'equalto', 'missing') | list %}
    {% if missing %}
    <div class="card app-card mb-4">
        <div class="card-header">
            Create {{ missing | length }} missing host(s) in the internal CMDB
        </div>
        <div class="card-body">
            <p class="text-muted">
                The selected hosts are created as syncer-managed objects (source
                <code>cmdb</code>). The normal Checkmk export then rolls them out.
                Optionally apply CMDB templates so they inherit their
                labels/attributes.
            </p>
            <form method="POST" action="{{ url_for('.create_missing') }}">
                <input type="hidden" name="csrf_token" value="{{ csrf_token() }}"/>
                <div class="form-row">
                    <div class="form-group col-md-6">
                        <label>CMDB templates (optional)</label>
                        <input class="form-control mb-2" type="search"
                               id="dq_template_search" autocomplete="off"
                               placeholder="type to filter the list"/>
                        <div id="dq_template_choices"
                             style="max-height:160px;overflow-y:auto;">
                            {% for tpl in templates %}
                            <div class="form-check dq-template-choice">
                                <input class="form-check-input" type="checkbox"
                                       name="template" id="tpl-{{ loop.index }}"
                                       value="{{ tpl }}">
                                <label class="form-check-label" for="tpl-{{ loop.index }}">
                                    <code>{{ tpl }}</code>
                                </label>
                            </div>
                            {% endfor %}
                        </div>
                        <small class="form-text text-muted">
                            Pick any number of the {{ templates | length }}
                            available template(s); the new hosts carry all of
                            them. None means no template.
                        </small>
                    </div>
                    <div class="form-group col-md-6">
                        <label for="domain">Domain name (optional)</label>
                        <input class="form-control" type="text" id="domain"
                               name="domain" autocomplete="off"
                               placeholder="example.com"/>
                        <small class="form-text text-muted">
                            Appended to every selected host that has no domain
                            part; hosts already given as an FQDN stay unchanged.
                        </small>
                    </div>
                </div>
                <div class="mb-2">
                    <button type="button" class="btn btn-sm btn-outline-secondary dq-toggle"
                            data-target=".dq-missing">Toggle all</button>
                </div>
                <div class="mb-3" style="max-height:260px;overflow-y:auto;">
                    {% for row in missing %}
                    <div class="form-check">
                        <input class="form-check-input dq-missing" type="checkbox"
                               name="missing_hosts" id="miss-{{ loop.index }}"
                               value="{{ row.hostname }}" checked>
                        <label class="form-check-label" for="miss-{{ loop.index }}">
                            <code>{{ row.hostname }}</code>
                        </label>
                    </div>
                    {% endfor %}
                </div>
                <button type="submit" class="btn btn-primary">
                    <i class="fa fa-plus"></i> Create selected hosts
                </button>
            </form>
        </div>
    </div>
    {% endif %}

    {% set existing = report.results | selectattr('cmdb_name') | list %}
    {% if existing %}
    {% set untemplated = existing | rejectattr('cmdb_templates') | list %}
    <div class="card app-card mb-4">
        <div class="card-header">
            Assign a CMDB template to existing host(s)
            <span class="badge badge-info ml-1">{{ existing | length }} in CMDB</span>
            <span class="badge badge-warning ml-1">{{ untemplated | length }} without template</span>
        </div>
        <div class="card-body">
            <p class="text-muted">
                These hosts are already in the CMDB. The chosen template is
                added to the templates they carry — nothing is replaced or
                removed, and hosts that already have it stay untouched. Only
                the hosts without a template are preselected.
            </p>
            <form method="POST" action="{{ url_for('.assign_template') }}">
                <input type="hidden" name="csrf_token" value="{{ csrf_token() }}"/>
                <div class="form-group">
                    <label for="assign_template">CMDB template</label>
                    <input class="form-control" type="text" id="assign_template"
                           name="template" list="dq_templates" autocomplete="off"
                           placeholder="type to search" required/>
                    <small class="form-text text-muted">
                        Start typing to filter the {{ templates | length }}
                        available template(s).
                    </small>
                </div>
                <div class="mb-2">
                    <button type="button" class="btn btn-sm btn-outline-secondary dq-toggle"
                            data-target=".dq-existing">Toggle all</button>
                </div>
                <div class="mb-3" style="max-height:260px;overflow-y:auto;">
                    {% for row in existing %}
                    <div class="form-check">
                        <input class="form-check-input dq-existing" type="checkbox"
                               name="existing_hosts" id="exist-{{ loop.index }}"
                               value="{{ row.cmdb_name }}"
                               {% if not row.cmdb_templates %}checked{% endif %}>
                        <label class="form-check-label" for="exist-{{ loop.index }}">
                            <code>{{ row.cmdb_name }}</code>
                            {% for tpl in row.cmdb_templates %}
                            <span class="badge badge-success ml-1">{{ tpl }}</span>
                            {% endfor %}
                        </label>
                    </div>
                    {% endfor %}
                </div>
                <button type="submit" class="btn btn-primary">
                    <i class="fa fa-tags"></i> Assign template
                </button>
            </form>
        </div>
    </div>
    {% endif %}

    <script>
        // Type-to-filter for the template checkboxes: the list is short
        // enough to scroll, long enough that scrolling alone is tedious.
        (function () {
            var search = document.getElementById('dq_template_search');
            if (!search) {
                return;
            }
            search.addEventListener('input', function () {
                var needle = search.value.trim().toLowerCase();
                document.querySelectorAll('.dq-template-choice').forEach(
                    function (choice) {
                        var box = choice.querySelector('input');
                        // A ticked template stays visible, otherwise it
                        // would be submitted without being on screen.
                        choice.hidden = !(box.checked || !needle
                            || box.value.toLowerCase().indexOf(needle) !== -1);
                    });
            });
        }());
    </script>

    <script type="application/json" id="dq_data">{{ report.results | tojson }}</script>
    <script>
        (function () {
            var rows = JSON.parse(document.getElementById('dq_data').textContent);
            var headers = ['host', 'status', 'name_in_checkmk', 'host_state',
                           'agent_state', 'agent_output', 'contact_groups',
                           'name_in_cmdb', 'cmdb_templates'];

            function cells(row) {
                return [
                    row.hostname,
                    row.status,
                    row.status === 'domain_mismatch'
                        ? (row.matched_names || []).join(' ')
                        : (row.status === 'found' ? row.hostname : ''),
                    row.host_state || '',
                    row.agent_state || '',
                    row.agent_output || '',
                    (row.contact_groups || []).join(' '),
                    row.cmdb_name || '',
                    (row.cmdb_templates || []).join(' ')
                ];
            }

            function toTable(sep, quote) {
                var lines = [headers.join(sep)];
                rows.forEach(function (row) {
                    lines.push(cells(row).map(function (value) {
                        value = String(value);
                        if (quote && /["\n,;]/.test(value)) {
                            value = '"' + value.replace(/"/g, '""') + '"';
                        }
                        return value;
                    }).join(sep));
                });
                return lines.join('\n');
            }

            function excelCsv() {
                // Make the CSV open straight into Excel: a UTF-8 BOM so Excel
                // detects the encoding (umlauts stay intact), a leading
                // "sep=;" directive so Excel uses ";" as the column separator
                // regardless of the user's locale, and CRLF line endings.
                return '\uFEFF' + 'sep=;\r\n' +
                    toTable(';', true).replace(/\n/g, '\r\n');
            }

            var copyBtn = document.getElementById('dq_copy');
            if (copyBtn) {
                copyBtn.addEventListener('click', function () {
                    // Plain ";"-separated CSV — the "sep="/BOM directives only
                    // help when Excel *opens a file*, not when pasting, and
                    // would show up as literal junk on paste.
                    var text = toTable(';', true);
                    navigator.clipboard.writeText(text).then(function () {
                        copyBtn.innerHTML = '<i class="fa fa-check"></i> Copied';
                        setTimeout(function () {
                            copyBtn.innerHTML =
                                '<i class="fa fa-clipboard"></i> Copy result';
                        }, 1500);
                    });
                });
            }

            var csvBtn = document.getElementById('dq_csv');
            if (csvBtn) {
                csvBtn.addEventListener('click', function () {
                    var blob = new Blob([excelCsv()],
                        {type: 'text/csv;charset=utf-8;'});
                    var url = URL.createObjectURL(blob);
                    var link = document.createElement('a');
                    link.href = url;
                    link.download = 'data_quality.csv';
                    document.body.appendChild(link);
                    link.click();
                    document.body.removeChild(link);
                    URL.revokeObjectURL(url);
                });
            }

            // One handler for every "Toggle all" button; each names the
            // checkbox class it belongs to via data-target.
            Array.prototype.forEach.call(
                document.querySelectorAll('.dq-toggle'), function (toggle) {
                    toggle.addEventListener('click', function () {
                        var boxes = document.querySelectorAll(
                            toggle.getAttribute('data-target'));
                        var anyChecked = Array.prototype.some.call(boxes, function (b) {
                            return b.checked;
                        });
                        Array.prototype.forEach.call(boxes, function (b) {
                            b.checked = !anyChecked;
                        });
                    });
                });
        })();
    </script>
    {% endif %}
</div>
{% endblock %}