{% 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">Outstanding Report</h4>
        </div>

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

    <div class="card">
        <div class="card-header border-bottom">
            <div class="row mt-2">
                <div class="col-md-3">
                    <label class="form-label">Date Filter</label>
                    <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-3">
                    <label class="form-label">Ledger Type</label>
                    <select class="select2 form-control" id="ledger_type" name="ledger_type"
                        onchange="toggleDropdowns()">
                        <option value="">All Types</option>
                        <option value="customer">Customer</option>
                        <option value="supplier">Supplier</option>
                        <option value="supply_branch">Supply Branch</option>
                    </select>
                </div>

                <div class="col-md-3" id="customer_div" style="display:none;">
                    <label class="form-label">Customer</label>
                    <select class="select2 form-control" id="customer_id" name="customer_id">
                        <option value="">All Customers</option>
                        {% for item in customers %}
                        <option value="{{item.id}}">{{item.name}}</option>
                        {% endfor %}
                    </select>
                </div>

                <div class="col-md-3" id="supplier_div" style="display:none;">
                    <label class="form-label">Supplier</label>
                    <select class="select2 form-control" id="supplier_id" name="supplier_id">
                        <option value="">All Suppliers</option>
                        {% for item in suppliers %}
                        <option value="{{item.id}}">{{item.name}}</option>
                        {% endfor %}
                    </select>
                </div>

                <div class="col-md-3" id="supply_branch_div" style="display:none;">
                    <label class="form-label">Supply Branch</label>
                    <select class="select2 form-control" id="supply_branch_id" name="supply_branch_id">
                        <option value="">All Branches</option>
                        {% for item in supply_branches %}
                        <option value="{{item.id}}">{{item.name}}</option>
                        {% endfor %}
                    </select>
                </div>

                <div class="col-md-2 mt-4">
                    <button type="button" class="btn btn-primary" onclick="refresh_data()">&nbsp; Refresh</button>
                </div>
            </div>
        </div>
        <div class="card-body">
            <div class="card-datatable table-responsive pt-0">
                <table class="datatables-basic table" id="datatable">
                    {% csrf_token %}
                    <thead>
                        <tr>
                            <th>Sl No</th>
                            <th>Name</th>
                            <th>Type</th>
                            <th>Branch</th>
                            <th class="text-end">Payable (₹)</th>
                            <th class="text-end">Receivable (₹)</th>
                            <th class="text-end">Outstanding (₹)</th>
                        </tr>
                    </thead>
                </table>
            </div>
        </div>
    </div>
</div>

{% include 'includes/footer.html' %}
{% include 'includes/common_js.html' %}
{% include 'includes/load_dropdown.html' %}

<script>
    var table;

    $(document).ready(function () {
        initializeDateRangePicker('this_month');
        refresh_data();
    });

    function toggleDropdowns() {
        var type = $('#ledger_type').val();
        $('#customer_div, #supplier_div, #supply_branch_div').hide();

        if (type === 'customer') {
            $('#customer_div').show();
        } else if (type === 'supplier') {
            $('#supplier_div').show();
        } else if (type === 'supply_branch') {
            $('#supply_branch_div').show();
        }
    }

    function initializeDataTable() {
        table = $('#datatable').DataTable({
            processing: true,
            pageLength: 50,
            destroy: true,
            order: [],
            searching: true,
            dom: getDataTableDom(),
            buttons: getExportButtons(),
            columns: [
                { data: "sl_no" },
                { data: "name" },
                { data: "type" },
                { data: "branch" },
                { data: "payable", title: "Payable (₹)", className: "text-end" },
                { data: "receivable", title: "Receivable (₹)", className: "text-end" },
                { data: "outstanding", title: "Outstanding (₹)", className: "text-end fw-bold" }
            ],
            ajax: {
                url: '/ajax_outstanding_report/',
                type: "POST",
                data: function (data) {
                    data.csrfmiddlewaretoken = $('input[name="csrfmiddlewaretoken"]').val();
                    data.ledger_type = $('#ledger_type').val();
                    data.customer_id = $('#customer_id').val();
                    data.supplier_id = $('#supplier_id').val();
                    data.supply_branch_id = $('#supply_branch_id').val();
                    data.from_date = $('#from_date').val();
                    data.to_date = $('#to_date').val();
                },
                dataSrc: function (response) {
                    if (response.message === 'permission') {
                        showSweetAlert('warning', response.error_message || 'You do not have permission.');
                        table.clear().draw();
                        return [];
                    }
                    return response.data || [];
                }
            }
        });
    }

    function refresh_data() {
        if (!table) {
            initializeDataTable();
        } else {
            table.ajax.reload();
        }
    }
</script>