{% load static %}
{% include 'includes/header.html' %}
{% include 'includes/store_sidebar.html' %}
{% include 'includes/navbar.html' %}
{% include 'includes/datatable_css.html' %}

<div class="container-xxl flex-grow-1 container-p-y">
    <div class="d-flex justify-content-between align-items-center mb-4">
        <div class="d-flex align-items-center">
            <h4 class="mb-0 me-3">Invoice Summary</h4>
        </div>

        <nav aria-label="breadcrumb">
            <ol class="breadcrumb mb-0">
                <li class="breadcrumb-item">
                    <a href="/store/dashboard" class="d-flex align-items-center text-decoration-none">
                        <i class="ti tabler-home me-1"></i>
                    </a>
                </li>
                <li class="breadcrumb-item " aria-current="page">Reports</li>
                <li class="breadcrumb-item active" aria-current="page">Invoice Summary</li>
            </ol>
        </nav>
    </div>

    <div class="card">
        <div class="card-header border-bottom">
            <div class="row mt-2">
                <div class="col-3">
                    <label class="form-label">Date Filter</label>
                    <input type="checkbox" id="is_date" checked>
                    <input type="text" id="date_filter" class="form-control" style="cursor: pointer;" />
                    <input type="hidden" id="from_date" name="from_date">
                    <input type="hidden" id="to_date" name="to_date">
                </div>






                <div class="col-2 mt-6">
                    <button type="button" class="btn btn-primary" onclick="refresh_data()"><i
                            class="fas fa-search"></i>&nbsp; Search</button>

                </div>
            </div>
        </div>
        <div class="card-body">
            <div class="card-datatable table-responsive pt-0">
                <table class="datatables-basic table table-bordered" id="datatable">
                    <thead>
                        {% csrf_token %}
                        <tr>
                            <th>Id</th>
                            <th>INV No</th>
                            <th>INV Date</th>
                            <th>Customer</th>
                            <th>Phone</th>
                            <th>Customer Type</th>
                            <th>SKU</th>
                            <th>IMEI</th>
                            <th>QTY</th>
                            <th>Rate (₹)</th>
                            <th>Discount(%)</th>
                            <th>Discount (₹)</th>
                            <th>Amount (₹)</th>
                        </tr>

                    </thead>
                    <tbody></tbody>

                </table>
            </div>
        </div>
    </div>




</div>

{% include 'includes/footer.html' %}
{% include 'includes/common_js.html' %}
<script>

    var table;




    $(document).ready(function () {
        initializeDateRangePicker('this_month'); // date range picker (function in common_js)
        refresh_data();

    });






    // datatable 
    function initializeDataTable() {
        table = $('#datatable').DataTable({
            "processing": true,
            "pageLength": 50,
            "destroy": true,
            "order": [],
            "dom": getDataTableDom(),
            "buttons": getExportButtons(),
            "columns": [
                { "data": "id", "title": " ID #" },
                { "data": "inv_no", "title": "INV No" },
                { "data": "date", "title": "INV Date" },
                { "data": "customer", "title": "Customer" },
                { "data": "phone", "title": "Phone" },
                { "data": "customer_type", "title": "Customer Type" },
                { "data": "sku", "title": "SKU" },
                { "data": "imei", "title": "IMEI" },
                { "data": "quantity", "title": "QTY" },
                { "data": "rate", "title": "Rate (₹)" , className: "text-end"},
                { "data": "discount_percent", "title": "Discount(%)" , className: "text-end"},
                { "data": "discount_amount", "title": "Discount (₹)" , className: "text-end"},
                { "data": "amount", "title": "Amount (₹)" , className: "text-end"},


            ],
            "ajax": {
                "url": '/ajax_invoice_summary/',
                "type": "POST",

                "data": function (data) {
                    data.csrfmiddlewaretoken = document.getElementsByName("csrfmiddlewaretoken")[0].value;
                    const keyword = $('#keyword_search').val();
                    const isDateChecked = $('#is_date').is(":checked");
                    const fromDate = $('#from_date').val();
                    const toDate = $('#to_date').val();
                    const storeId = $('#filter_store_id').val();

                    if (keyword) data.keyword_search = keyword;
                    if (storeId) data.filter_store_id = storeId;

                    if (isDateChecked && fromDate && toDate) {
                        data.from_date = fromDate;
                        data.to_date = toDate;
                    }
                },
                dataSrc: function (response) {
                    if (response.message === 'permission') {
                        showSweetAlert('warning', response.error_message || 'You do not have permission to view the user role.');
                        table.clear().draw();
                        return [];
                    }

                    return response.data || [];
                }
            },
            footerCallback: function (row, data, start, end, display) {
                const api = this.api();

                const intVal = function (i) {
                    return typeof i === 'string'
                        ? parseFloat(i.replace(/[^0-9.-]+/g, '')) || 0
                        : typeof i === 'number'
                            ? i
                            : 0;
                };

                const Quantity = data.reduce((sum, row) => sum + intVal(row.quantity), 0);
                const Amount = data.reduce((sum, row) => sum + intVal(row.amount), 0);
                const Claim = data.reduce((sum, row) => sum + intVal(row.claim), 0);
                const Collection = data.reduce((sum, row) => sum + intVal(row.collection), 0);
                const Exchange = data.reduce((sum, row) => sum + intVal(row.exchange), 0);
                const Balance = data.reduce((sum, row) => sum + intVal(row.balance), 0);
                const Cash = data.reduce((sum, row) => sum + intVal(row.cash), 0);
                const Bank = data.reduce((sum, row) => sum + intVal(row.bank), 0);
                const Finance = data.reduce((sum, row) => sum + intVal(row.finance), 0);
                const Card = data.reduce((sum, row) => sum + intVal(row.card), 0);


                // Upate footer cells
                $('#footer_qty').html(Quantity.toLocaleString(undefined, { minimumFractionDigits: 2 }));
                $('#footer_amount').html(Amount.toLocaleString(undefined, { minimumFractionDigits: 2 }));
                $('#footer_claim').html(Claim.toLocaleString(undefined, { minimumFractionDigits: 2 }));
                $('#footer_collection').html(Collection.toLocaleString(undefined, { minimumFractionDigits: 2 }));
                $('#footer_exchange').html(Exchange.toLocaleString(undefined, { minimumFractionDigits: 2 }));
                $('#footer_balance').html(Balance.toLocaleString(undefined, { minimumFractionDigits: 2 }));
                $('#footer_cash').html(Cash.toLocaleString(undefined, { minimumFractionDigits: 2 }));
                $('#footer_bank').html(Bank.toLocaleString(undefined, { minimumFractionDigits: 2 }));
                $('#footer_finance').html(Finance.toLocaleString(undefined, { minimumFractionDigits: 2 }));
                $('#footer_card').html(Card.toLocaleString(undefined, { minimumFractionDigits: 2 }));
                $('#footer_remarks').html('-');
                $('#footer_status').html('-');


            },
        });
    }


    function refresh_data() {
        if (!table) {
            initializeDataTable();
        } else {
            table.ajax.reload();
        }
    }


    function edit_data(id) {
        var encodedId = btoa(id);
        window.location.href = '/sales/edit/?id=' + encodedId;
    }


    function delete_data(id) {
        deleteEntity('/tm_sales_delete/', id, '{{ csrf_token }}', 'Sales Order');
    }


    function print_data(id) {
        var url = '/sales_invoice/?k=' + window.btoa(id);
        printExternal(url);
    }




    function thermal_print(id) {
        var url = '/sales_invoice_thermal/?k=' + window.btoa(id);
        printExternal(url);
    }



    function printExternal(url) {
        var printWindow = window.open(url, 'Print', 'left=200,top=200,width=950,height=500,toolbar=0,resizable=0');

        if (!printWindow) {
            showToast('info', 'Pop-up blocked! Please allow pop-ups for this site.');
            return;
        }

        printWindow.onload = function () {
            printWindow.focus();
            printWindow.print();

            // Close after printing
            printWindow.onafterprint = function () {
                printWindow.close();
            };
        };
    }


</script>