{% extends "reportcraft/base.html" %}
{% load reportcraft %}
{% load static %}

{% block extra_css %}
    {{ block.super }}
    <style>
        {% pigments_css "friendly" %}
    </style>
{% endblock %}

{% block page-pretitle %}Edit Data Source{% endblock %}
{% block page-title %}
    {{ object.name }}
{% endblock %}

{% block page-tools %}
    <a href="#rc-off-canvas" data-oc-url="{% url "editor-report-list" %}" data-bs-toggle="offcanvas">
        {% tool_icon label='Reports' icon='list-details' %}
    </a>
    <a href="#rc-off-canvas" data-oc-url="{% url "data-source-list" %}" data-bs-toggle="offcanvas">
        {% tool_icon label='Sources' icon='database' %}
    </a>
    <a href="#!" data-modal-url="{% url "edit-data-source" source.pk %}">
        {% tool_icon label='Edit' icon='pencil' %}
    </a>
    <a href="#!" data-modal-url="{% url "delete-data-source" source.pk %}">
        {% tool_icon label='Delete' icon='trash-x' %}
    </a>
    <a href="#!" data-modal-url="{% url "add-source-model" source=source.pk %}">
        {% tool_icon label='Add Model' icon='database-plus' %}
    </a>
    <a href="#!" data-modal-url="{% url "add-source-field" source=source.pk %}">
        {% tool_icon label='Add Field' icon='table-plus' %}
    </a>
{% endblock %}

{% block page-content %}
    <div class="row report-editor ">
        <div class="col-md-9 col-sm-12 d-flex flex-column">
            <div class="card mb-3">
                <div class="card-header py-2 d-flex align-items-center">
                    <h5>Models</h5>
                    <div class="toolbox ms-auto pr-0">
                        <a href="#0" data-modal-url="{% url "add-source-model" source=source.pk %}"
                           title="Add Model">
                            {% tool_icon icon='database-plus' size='sm' %}
                        </a>
                    </div>
                </div>
                <table class="table">
                    <thead>
                    <tr>
                        <th>Model</th>
                        {% for group_field in source.group_by %}
                            <th>{{ group_field|title }}<span
                                    class="hidden-xs text-muted">&nbsp;&middot;&nbsp;Group</span>
                            </th>
                        {% endfor %}
                        <th>&nbsp;</th>
                    </tr>
                    </thead>
                    <tbody class="text-sm">
                    {% for src_model in source.models.all %}
                        <tr>
                            <td>{{ src_model.name }}</td>
                            {% for field_name, group_field in src_model.get_group_fields.items %}
                                {% if group_field %}
                                    <td class="font-monospace"><a href="#0"
                                                                  data-modal-url="{% url 'edit-source-field' source=source.pk pk=group_field.pk %}">{{ group_field.expression }}</a>
                                    </td>
                                {% else %}
                                    <td class="text-danger"><a href="#0"
                                                               data-modal-url="{% url 'add-group-field' source=source.pk group=field_name %}">Undefined</a>
                                    </td>
                                {% endif %}
                            {% endfor %}
                            <td>
                                <div class="d-flex align-children-end">
                                    <div class="toolbox ms-auto">
                                        <a href="#0"
                                           data-modal-url="{% url 'edit-source-model' source=source.pk pk=src_model.pk %}"
                                           title="Edit">
                                            {% tool_icon icon='pencil' size='sm' %}
                                        </a>
                                    </div>
                                </div>
                            </td>
                        </tr>
                    {% empty %}
                        <tr>
                            <td colspan="5" class="text-center">No models defined</td>
                        </tr>
                    {% endfor %}
                    </tbody>
                </table>
            </div>
            <div class="card mb-3">
                <div class="card-header py-2 d-flex align-items-center">
                    <h5>Fields</h5>
                    <div class="toolbox ms-auto pr-0">
                        <a href="#0" data-modal-url="{% url "add-source-field" source=source.pk %}"
                           title="Add Field">
                            {% tool_icon icon='table-plus' size='sm' %}
                        </a>
                    </div>
                </div>
                <table class="table">
                    <thead>
                    <tr>
                        <th>Name</th>
                        <th>Label</th>
                        <th>Model</th>
                        <th class="d-none d-md-table-cell">Expression</th>
                        <th>&nbsp;</th>
                    </tr>
                    </thead>
                    <tbody class="text-sm">
                    {% for field in source.non_group_fields %}
                        <tr>
                            <td class="font-monospace pl-3">{{ field.name }}</td>
                            <td>{{ field.label }}</td>
                            <td>{{ field.model }}</td>
                            <td class="d-none d-md-table-cell font-monospace">{{ field.expression }}</td>
                            <td>
                                <div class="d-flex align-children-end">
                                    <div class="toolbox ms-auto pr-0">
                                        <a href="#0"
                                           data-modal-url="{% url 'edit-source-field' source=source.pk pk=field.pk %}"
                                           title="Edit">
                                            {% tool_icon icon='pencil' size='sm' %}
                                        </a>
                                    </div>
                                </div>
                            </td>
                        </tr>
                    {% endfor %}
                    </tbody>
                </table>
            </div>
            <div class="card mb-3 flex-grow-1">
                <div class="card-header py-2 d-flex align-items-center">
                    <h4 class="my-0"><span class="text-muted">Data</span></h4>
                    <div class="toolbox ms-auto pr-0">
                        <a download="{{ source.name_slug }}.csv"
                           href="{% url 'source-data' pk=source.pk %}?type=csv" title="Download CSV">
                            {% tool_icon icon='file-type-csv' size='sm' %}
                        </a>
                        <a download="{{ source.name_slug }}.json"
                           href="{% url 'source-data' pk=source.pk %}" title="Download JSON">
                            {% tool_icon icon='file-type-js' size='sm' %}
                        </a>
                    </div>
                </div>
                <div class="card-body">
                    {{ source.snippet|yaml_html }}
                    <code>
                        ...
                    </code>
                </div>
            </div>
        </div>
        <div class="col-md-3 col-sm-12 d-flex flex-column">
            <div class="card mb-3">
                <div class="card-header py-2">
                    <h5 class="my-0"><span class="text-muted">Related Reports</span></h5>
                </div>
                <ul class="list-group list-group-flush">
                    {% for report in source.reports %}
                        <li class="list-group-item bg-transparent">
                            <a href="{% url 'report-editor' pk=report.pk %}">
                                <small>{{ report }}</small>
                            </a>
                        </li>
                    {% endfor %}
                </ul>
            </div>
            <div class="card mb-3 flex-grow-1" >
                <div class="card-header py-2">
                    <h5 class="my-0"><span class="text-muted">DB Records</span></h5>
                </div>
                <div style="min-height: 0;">
                <ul class="list-group-flush list-group small">
                    {% for model in source.models.all %}
                        <li class="fs-6 list-group-item bg-body-secondary">
                        {{ model }}
                        </li>
                        {% for name, type in model.get_model_specs %}
                        <li class="list-group-item  bg-transparent overflow ellipsis" data-bs-toggle="tooltip" title="{{ name }} [{{ type }}]">
                            <code class="font-monospace text-nowrap" >{{ name }}</code>
                        </li>
                        {% endfor %}
                    {% endfor %}
                </ul>
                </div>
            </div>
        </div>
    </div>
{% endblock %}