{% 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">Sales Return</h4> 
            <a href="/sales-return/add"><button type="button" class="btn btn-success btn-sm">Add</button></a>  &nbsp
        </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 active" aria-current="page">Saled Order</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-md-2 mb-5  form-control-validation">
                    <label class="form-label" for="customer_id">Customer</label>
                    <select class="select2  form-control" id="filter_customer_id" name="customer_id">
                        <option value="">Select</option>
                        {% for k in customer %}
                        <option value="{{k.id}}">{{k.name}}</option>
                        {% endfor %}
                    </select>
                </div>

                <div class="col-md-2 mb-5  form-control-validation">
                    <label class="form-label" for="supplier_id">Store</label>
                    <select class="select2  form-control" id="filter_store_id" name="store_id" >
                        <option value="">Select</option>
                        {% for k in branch %}
                        <option value="{{k.id}}">{{k.name}}</option>
                        {% endfor %}
                    </select>
                </div>
                
                
                
                <div class="col-2 mt-6">
                    <input type="hidden" name="sales_id" id="sales_id" value="{{decoded_id}}">
                    <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" id="datatable">
                  <thead>
                        {% csrf_token %}
                    <tr>
                        <th rowspan="2">Id</th>
                        <th rowspan="2">Action</th>
                        <th rowspan="2">SR No</th>
                        <th rowspan="2">SR Date</th>
                        <th rowspan="2">Customer</th>
                        <th rowspan="2">Total Quantity</th>
                        <th rowspan="2">Total Amount</th>
                        <th colspan="5">Payments</th>                        
                        <th rowspan="2">Balance</th>
                        <th rowspan="2">Remarks</th>                       
                        <th rowspan="2">Status</th>                       
                    </tr>
                     <tr>
                        <th>Cash</th>
                        <th>Bank</th>
                        <th>Exchange</th>
                        <th>Finance</th>
                        <th>Bank</th>
                    </tr>
                  </thead>
                  <tbody></tbody>
                    <tfoot>
                        <th colspan="5" class="text-end fw-bold">Total :</th>
                        <th id="footer_qty" class="text-end fw-bold"></th>
                        <th id="footer_amount" class="text-end fw-bold"></th>
                        <th id="footer_cash" class="text-end fw-bold"></th>
                        <th id="footer_bank" class="text-end fw-bold"></th>
                        <th id="footer_exchange" class="text-end fw-bold"></th>
                        <th id="footer_finance" class="text-end fw-bold"></th>
                        <th id="footer_card" class="text-end fw-bold"></th>
                        <th id="footer_balance" class="text-end fw-bold"></th>
                        <th id="footer_remarks" class="text-end fw-bold"></th>
                        <th id="footer_status" class="text-end fw-bold"></th>
                  </tfoot>
                </table>
              </div>          
        </div>
    </div>
    
    
  

</div>

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

    

    $(document).ready(function(){
        // initializeDateRangePicker('this_month');
        setupDateRangeWithLocalStorage("profit_loss_nav_date", "{{ decode_date|default:'' }}", true );

        refresh_data();

        if (sessionStorage.getItem('addSuccessMessage')) {            
            showToast('success',"Sales Return Saved successfully")
            sessionStorage.removeItem('addSuccessMessage');
        }

        if (sessionStorage.getItem('editSuccessMessage')) {
            showToast('success',"Sales Return Updated successfully")           
            sessionStorage.removeItem('editSuccessMessage');
        }


    });

   


  

    // datatable 
    function initializeDataTable() {
        table = $('#datatable').DataTable({
            "processing": true,
            "pageLength": 50,
            "destroy": true,
            "order": [],  
            "dom": getDataTableDom(),
            "buttons": getExportButtons(),            
            "columns": [
                { "data": "id", "title": " ID #" },
                { "data": "action", "title": "Action" },
                { "data": "inv_no", "title": "INV No" },
                { "data": "date", "title": "INV Date" },
                { "data": "customer", "title": "Customer" },
                { "data": "quantity", "title": "Total Quantity","className": "text-end" },
                { "data": "amount", "title": "Total Amount","className": "text-end" },
                { "data": "cash", "title": "Cash","className": "text-end" },
                { "data": "bank", "title": "Bank","className": "text-end" },
                { "data": "exchange", "title": "Exchange","className": "text-end" },
                { "data": "finance", "title": "Finance","className": "text-end" },
                { "data": "card", "title": "Card","className": "text-end" },
                { "data": "balance", "title": "Balance","className": "text-end" }, 
                { "data": "remarks", "title": "Remarks" },
                { "data": "status", "title": "Status" }
            ],
            "ajax": {
                "url": '/ajax_sales_return_view/',
                "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();
                    const salesId = $('#sales_id').val();


                    if (keyword) data.keyword_search = keyword;
                    if (storeId) data.filter_store_id = storeId;
                    if (salesId && salesId !== '0') {
                        data.sales_id = salesId;
                        // ❌ do NOT send date filters
                    } else {
                        // ✅ apply date filter only when sales_id is 0 / empty
                        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-return/edit/?id=' + encodedId;
    }


     function delete_data(id) {
        deleteEntity('/delete_tm_sales_return/', id, '{{ csrf_token }}', 'Sales Return');
    }








</script>