{% extends "layouts/base.twig" %}

{% block title %}{{ translations.waste_evidence }}{% endblock %}

{% block head %}
    <style>
        .filter-badge {
            background-color: #e9ecef;
            color: #495057;
            padding: .4rem .7rem;
            font-weight: 500;
            cursor: pointer;
            user-select: none;
        }
        .filter-badge.active {
            background-color: var(--bs-primary);
            color: #fff;
            box-shadow: 0 0 0 .2rem rgba(13,110,253,.25);
        }
        /* ukrywamy standardową wyszukiwarkę */
        #evidence_table_filter {
            display: none !important;
        }
        /* styl selecta */
        .dataTables_length select {
            width: 90px !important;
        }
    </style>
{% endblock %}

{% block page_heading %}
    <div class="page-heading">
        <h3>{{ translations.waste_evidence }}</h3>
        <p class="text-subtitle text-muted">{{ translations.waste_evidence_subtitle }}</p>
    </div>
{% endblock %}


{% block content %}
    <div class="page-content">

        <!-- FILTRY GÓRNE – W CARD -->
        <section class="row">
            <div class="col-12">
                <div class="card shadow-sm">
                    <div class="card-header d-flex justify-content-between align-items-center">
                        <h5 class="mb-0 fs-4 flex-shrink-0">{{ translations.filters }}</h5>
                    </div>

                    <div class="card-body">
                        <div class="row g-3 align-items-end">

                            <div class="col-md-3">
                                <label for="date_from" class="form-label">{{ translations.date_from }}</label>
                                <input type="date" id="date_from" name="date_from" class="form-control"
                                       value="{{ date_from|date("Y-m-d") }}">
                            </div>

                            <div class="col-md-3">
                                <label for="date_to" class="form-label">{{ translations.date_to }}</label>
                                <input type="date" id="date_to" name="date_to" class="form-control"
                                       value="{{ date_to|date("Y-m-d") }}">
                            </div>

                            <div class="col-md-2">
                                <button class="btn btn-primary w-100 text-sm">
                                    <i class="bi bi-search"></i> {{ translations.apply_filters }}
                                </button>
                            </div>

                            <div class="col-md-1">

                            </div>

                            <div class="col-md-3 d-flex flex-wrap">

                                <button class="btn btn-outline-primary w-100 text-sm mx-3"
                                        onclick="getGeneralPDF('{{ date_from }}', '{{ date_to }}', this)">
                                    <span class="button-spinner spinner-border spinner-border-sm me-2"
                                          style="display: none"></span>
                                    <span class="button-text">
                                        <i class="bi bi-file-earmark-pdf"></i> {{ translations.get_general_waste_pdf }}
                                    </span>
                                </button>

                                <button class="btn btn-outline-secondary w-100 text-sm mx-3 mt-2"
                                        onclick="getFullPDF('{{ date_from }}', '{{ date_to }}', this)">
                                    <span class="button-spinner spinner-border spinner-border-sm me-2"
                                          style="display: none"></span>
                                    <span class="button-text">
                                        <i class="bi bi-file-earmark-pdf"></i> {{ translations.get_full_waste_pdf }}
                                    </span>
                                </button>
                            </div>
                        </div>

                        <div class="row g-3 mt-3">
                            <div class="d-flex gap-2">
                            <span class="badge rounded bg-danger text-light"
                                  style="cursor:pointer;"
                                  onclick="setQuickRange('today')">
                                {{ translations.today|default('today') }}
                            </span>
                                <span class="badge rounded bg-secondary text-light"
                                      style="cursor:pointer;"
                                      onclick="setQuickRange('week')">
                                {{ translations.this_week|default('this_week') }}
                            </span>
                                <span class="badge rounded bg-info text-light"
                                      style="cursor:pointer;"
                                      onclick="setQuickRange('month')">
                                {{ translations.this_month|default('this_month') }}
                            </span>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </section>


        <!-- PODSUMOWANIE – W CARD -->
        <section class="row">
            <div class="col-12">
                <div class="card shadow-sm">

                    <div class="card-header">
                        <h5>{{ translations.date_range_summary }}</h5>
                    </div>

                    <div class="card-body">
                        <div class="row">
                            <div class="col-md-4 mb-2">
                                <div class="p-3 border rounded">
                                    <h6 class="text-muted mb-3">{{ translations.total_wasted }}</h6>
                                    <h4 class="fw-bold">{{ evidence.getPeriodSummary().getTotalWasteQuantity()|default("0") }}</h4>
                                </div>
                            </div>

                            <div class="col-md-4 mb-2">
                                <div class="p-3 border rounded">
                                    <h6 class="text-muted mb-3">{{ translations.total_sold_products }}</h6>
                                    <h4 class="fw-bold">{{ evidence.getPeriodSummary().getTotalSoldProductsQuantity()|default("0") }}</h4>
                                </div>
                            </div>

                            <div class="col-md-4 mb-2">
                                <div class="p-3 border rounded">
                                    {% set top = evidence.getGlobalTopReason() %}
                                    <h6 class="text-muted mb-3">{{ translations.most_common_reason }}</h6>

                                    {% if top %}
                                        <h6 class="fw-bold">{{ attribute(translations, 'waste_reason_' ~ top.reason) }}
                                            ({{ top.count }}x)</h6>
                                    {% else %}
                                        <h4 class="fw-bold">{{ translations.no_data_about_reasons }}</h4>
                                    {% endif %}
                                </div>
                            </div>
                        </div>
                        <div class="row mt-3">
                            <div class="col-md-3 mb-2">
                                <div class="p-3 border rounded">
                                    <h6 class="text-muted mb-3">{{ translations.net_turnover }}</h6>
                                    <h4 class="fw-bold">{{ evidence.getPeriodSummary().getNetTunrover()|default("0") }} {{ app_currency_symbol }}</h4>
                                </div>
                            </div>

                            <div class="col-md-3 mb-2">
                                <div class="p-3 border rounded">
                                    <h6 class="text-muted mb-3">{{ translations.ca_waste_net }}</h6>
                                    <h4 class="fw-bold text-danger">{{ evidence.getPeriodSummary().getTotalCaWasteNet()|default("0") }} {{ app_currency_symbol }}</h4>
                                </div>
                            </div>

                            <div class="col-md-3 mb-2">
                                <div class="p-3 border rounded">
                                    <h6 class="text-muted mb-3">{{ translations.recipe_waste_gross }}</h6>
                                    <h4 class="fw-bold text-danger">{{ evidence.getPeriodSummary().getTotalRecipeWasteGross()|default("0") }} {{ app_currency_symbol }}</h4>
                                </div>
                            </div>

                            <div class="col-md-3 mb-2">
                                <div class="p-3 border rounded">
                                    <h6 class="text-muted mb-3">{{ translations.pct_window_ca_over_recipe }}</h6>
                                    <h4 class="fw-bold text-danger">{{ evidence.getPeriodSummary().getPctWindowCaOverRecipe()|default("0") }}
                                        %</h4>
                                </div>
                            </div>
                        </div>
                    </div>

                </div>
            </div>
        </section>

        <!-- TABELA STRAT – W CARD -->
        <section class="row">
            <div class="col-12">
                <div class="card shadow-sm">

                    <div class="card-header">
                        <h5>{{ translations.detailed_list_of_wastage }}</h5>
                    </div>

                    <div class="card-body">
                        <div class="row">
                            <div class="col-8"></div>
                            <div class="col-4">
                                <div class="mb-3 d-flex gap-2 flex-wrap float-end">
                                    <span class="badge rounded-pill filter-badge active" data-range="all"  style="cursor:pointer;">All</span>
                                    <span class="badge rounded-pill filter-badge"        data-range="0-2"  style="cursor:pointer;">0–2%</span>
                                    <span class="badge rounded-pill filter-badge"        data-range="2-5"  style="cursor:pointer;">2–5%</span>
                                    <span class="badge rounded-pill filter-badge"        data-range="5plus" style="cursor:pointer;">&gt;5%</span>
                                </div>
                            </div>
                        </div>
                        <div class="col-12">
                            <div class="table-responsive">
                                <table class="table table-hover align-middle text-sm" id="evidence_table">
                                    <thead>
                                    <tr>
                                        <th>{{ translations.category }}</th>
                                        <th>{{ translations.product }}</th>
                                        <th class="text-end">{{ translations.sold }}</th>
                                        <th class="text-end">{{ translations.ca_waste_net }}</th>
                                        <th class="text-end">{{ translations.wasted }}</th>
                                        <th class="text-end">{{ translations.recipe_waste_gross }}</th>
                                        <th class="text-end">{{ translations.share_in_sales }}</th>
                                    </tr>
                                    </thead>

                                    <tbody>
                                    {% for category in evidence.getWasteCategories() %}
                                        {% for product in category.getProducts() %}

                                            <tr>
                                                <td>{{ category.getName() }}</td>
                                                <td>{{ product.getName() }}</td>
                                                <td class="text-end">
                                                    {{ product.getSoldQuantity|number_format(0) }}
                                                </td>
                                                <td class="text-end text-danger fw-bold">
                                                    {{ product.getCaWasteNet|number_format(2, ".") }} {{ app_currency_symbol }}
                                                </td>
                                                <td class="text-end text-danger fw-bold">
                                                    {{ product.getWasteQty|number_format(0) }}
                                                </td>
                                                <td class="text-end text-danger fw-bold">
                                                    {{ product.getRecipeWasteGross|number_format(2, ".") }} {{ app_currency_symbol }}
                                                </td>
                                                <td class="text-end text-danger fw-bold">
                                                    {{ product.getPctWasteToSold|number_format(2) }}%
                                                </td>
                                            </tr>

                                        {% endfor %}
                                    {% endfor %}
                                    </tbody>
                                </table>
                                <div id="entries_selector_container" class="mt-3"></div>

                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </section>

    </div>

{% endblock %}

{% block scripts %}
    <script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>
    <link href="https://cdn.datatables.net/1.13.8/css/jquery.dataTables.min.css" rel="stylesheet"/>
    <script src="https://cdn.datatables.net/1.13.8/js/jquery.dataTables.min.js"></script>

    <script>

        let activeRange = 'all';

        /* -----------------------------
           ✅ Filtrowanie procentów
        --------------------------------*/
        $.fn.dataTable.ext.search.push(function(settings, data) {
            if (settings.nTable.id !== 'evidence_table') return true;

            let pct = (data[6] || "0")
                .toString()
                .replace("%","")
                .replace(",", ".")
                .trim();

            pct = parseFloat(pct) || 0;

            switch (activeRange) {
                case '0-2':   return pct >= 0 && pct <= 2;
                case '2-5':   return pct > 2 && pct <= 5;
                case '5plus': return pct > 5;
                default:      return true;
            }
        });

        /* -----------------------------
           ✅ Inicjalizacja DataTables
        --------------------------------*/
        function initEvidenceTable() {

            if ($.fn.DataTable.isDataTable('#evidence_table')) {
                $('#evidence_table').DataTable().destroy();
            }

            window.evidenceTable = $('#evidence_table').DataTable({
                paging: true,
                pageLength: 25,
                ordering: true,
                info: true,
                searching: true,     // wyszukiwarka ukryta CSS, ale działa dla badge
                order: [[2, "asc"]],

                language: {
                    search: "{{ translations.search_for_name }}:",
                    lengthMenu: "{{ translations.showing }} _MENU_",
                    info: " {{ translations.showing }} _START_–_END_ {{ translations.of }} _TOTAL_ {{ translations.entries }}",
                    zeroRecords: "{{ translations.no_data_found }}"
                },

                initComplete: function () {
                    // przeniesienie selecta pod tabelę
                    $("#entries_selector_container").append($("#evidence_table_length"));
                }
            });
        }

        function colorizePercentCells() {
            $('#evidence_table tbody tr').each(function () {
                const cell = $(this).find('td').eq(6); // kolumna %
                if (!cell.length) return;

                let value = cell.text()
                    .replace('%', '')
                    .replace(',', '.')
                    .trim();

                const pct = parseFloat(value) || 0;

                cell.removeClass('text-success text-warning text-danger');

                if (pct <= 1) {
                    cell.addClass('text-success');
                } else if (pct > 1 && pct <= 2) {
                    cell.addClass('text-warning');
                } else {
                    cell.addClass('text-danger');
                }
            });
        }

        $(document).ready(function () {

            initEvidenceTable();

            // ✅ kolorowanie przy starcie
            colorizePercentCells();

            // ✅ kolorowanie po każdym redraw DataTables
            window.evidenceTable.on('draw', function () {
                colorizePercentCells();
            });

            // ✅ Obsługa badge
            $(document).on('click', '.filter-badge', function () {
                $('.filter-badge').removeClass('active');
                $(this).addClass('active');

                activeRange = $(this).data('range');
                window.evidenceTable.draw();
            });
        });


        document.addEventListener("DOMContentLoaded", function () {

            const btn = document.querySelector(".btn-primary");
            const dateFromInput = document.getElementById("date_from");
            const dateToInput = document.getElementById("date_to");

            btn.addEventListener("click", function () {

                const dateFrom = dateFromInput.value;
                const dateTo = dateToInput.value;

                const url = new URL(window.location.href);
                url.searchParams.set("date_from", dateFrom);
                url.searchParams.set("date_to", dateTo);
                window.location.href = url.toString();

            });
        });

        async function getGeneralPDF(dateFrom, dateTo, btn) {

            toggleButtonLoading(btn, true);

            try {
                await downloadPdf(
                    '/ajax/products/waste-evidence/general/pdf',
                    {date_from: dateFrom, date_to: dateTo},
                    `waste_product_evidence_${dateFrom}_${dateTo}.pdf`
                );
            } catch (err) {
                console.error(err);
                showSnack(false, err.message || 'Something went wrong.');
            } finally {
                toggleButtonLoading(btn, false);
            }
        }

        async function getFullPDF(dateFrom, dateTo, btn) {

            toggleButtonLoading(btn, true);

            try {
                await downloadPdf(
                    '/ajax/products/waste-evidence/full/pdf',
                    {date_from: dateFrom, date_to: dateTo},
                    `waste_product_evidence_full_${dateFrom}_${dateTo}.pdf`
                );
            } catch (err) {
                console.error(err);
                showSnack(false, err.message || 'Something went wrong.');
            } finally {
                toggleButtonLoading(btn, false);
            }
        }

        function setQuickRange(range) {
            const today = new Date();

            let from, to;

            if (range === 'today') {
                from = to = today;
            }

            if (range === 'week') {
                // poniedziałek
                const firstDay = new Date(today);
                firstDay.setDate(today.getDate() - today.getDay() + 1);
                // niedziela
                const lastDay = new Date(firstDay);
                lastDay.setDate(firstDay.getDate() + 6);

                from = firstDay;
                to = lastDay;
            }

            if (range === 'month') {
                from = new Date(today.getFullYear(), today.getMonth(), 1);
                to = new Date(today.getFullYear(), today.getMonth() + 1, 0);
            }

            // format Y-m-d
            const fmt = d => d.toISOString().split('T')[0];

            document.getElementById("date_from").value = fmt(from);
            document.getElementById("date_to").value = fmt(to);

            // odśwież widok
            const url = new URL(window.location.href);
            url.searchParams.set("date_from", fmt(from));
            url.searchParams.set("date_to", fmt(to));
            window.location.href = url.toString();
        }

        function toggleButtonLoading(button, isLoading) {
            const spinner = button.querySelector('.button-spinner');
            const text = button.querySelector('.button-text');

            if (isLoading) {
                spinner.style.display = 'inline-block';
                text.style.display = 'none';
                button.disabled = true;
            } else {
                spinner.style.display = 'none';
                text.style.display = 'inline';
                button.disabled = false;
            }
        }
    </script>
{% endblock %}