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

<style>
    #datatable {
        border-collapse: collapse;
        width: 100%;
    }

    #datatable th,
    #datatable td {
        border: 1px solid #ccc;
        padding: 8px;
        text-align: center;
        vertical-align: middle;
    }

    #datatable thead th {
        background-color: #f9faf8;
        font-weight: bold;
    }

    .bg-credit {
        background-color: #d1f7d6 !important;
        /* Light green */
    }

    .bg-debit {
        background-color: #fce4e4 !important;
        /* Light red */
    }

    .bg-balance {
        background-color: #e6f3ff !important;
        /* Light blue */
    }
</style>

<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">Bank Ledger</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">Bank Ledger</li>
            </ol>
        </nav>
    </div>

    <div class="card">
        <div class="card-header border-bottom">
            <div class="row">


                <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-3">
                    <label class="form-label">Bank Account <span class="text-danger">*</span></label>
                    <select class="select2 form-control" id="filter_bank_id" name="filter_bank_id">
                        <option value="">Select Bank</option>
                        {% for bank in banks %}
                        <option value="{{ bank.id }}">{{ bank.name }} - {{ bank.account_number }}</option>
                        {% endfor %}
                    </select>
                </div>


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

                <div class="col-3 offset-1 text-end mt-4">
                    <h6 class="mb-1 text-muted">Closing Bank Balance</h6>
                    <h4 id="closing_balance" class="fw-bold text-success">
                        ₹ 0.00
                    </h4>
                </div>

            </div>
        </div>

        <div class="card-body">
            <div class="card-datatable table-responsive pt-0">
                <div class="ledger-legend mt-2 mb-3">
                    <span class="me-3">
                        <span class="badge bg-label-success">Credit</span> = Bank In (Deposit)
                    </span>

                    <span class="me-3">
                        <span class="badge bg-label-danger">Debit</span> = Bank Out (Withdrawal)
                    </span>

                    <span class="me-3">
                        <span class="badge bg-label-info">Balance</span> = Running Bank Balance
                    </span>
                </div>

                <table class="datatables-basic table" id="datatable">
                    <thead>
                        {% csrf_token %}
                        <tr>
                            <th>S.No</th>
                            <th>Receipt No</th>
                            <th>Date & Time</th>
                            <th>Type</th>
                            <th>Particulars</th>
                            <th>Credit (In) (₹)</th>
                            <th>Debit (Out) (₹)</th>
                            <th class="text-center">Balance (₹)</th>
                            <th>Employee</th>
                        </tr>

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






</div>

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

<script>
    var table;

    $(document).ready(function () {
        initializeDateRangePicker('this_month');
        // Initialize empty table
        initializeDataTable(false);
    });

    function refresh_data(clicked = false) {
        var bankId = $('#filter_bank_id').val();
        if (bankId == '' || bankId == 0 || bankId == null) {
            if (clicked) {
                showSweetAlert('warning', 'Please select a bank account');
            }
            return;
        }

        initializeDataTable(true);
    }

    function initializeDataTable(loadData = false) {
        let options = {
            processing: true,
            pageLength: 100,
            destroy: true,
            order: [],
            searching: true,
            lengthChange: false,
            dom: getDataTableDom(),
            buttons: getExportButtons(),
            columns: [
                { data: "id", title: "S.NO", className: "text-start" },              // 0
                { data: "receipt", title: "Receipt No", className: "text-start" },   // 1
                { data: "date", title: "Date & Time", className: "text-start" },     // 2
                { data: "type", title: "Type", className: "text-start" },             // 3
                { data: "particulars", title: "Particulars", className: "text-start" }, // 4
                { data: "credit", title: "Credit (In) (₹)", className: "text-end" },     // 5
                { data: "debit", title: "Debit (Out) (₹)", className: "text-end" },      // 6
                { data: "balance", title: "Balance (₹)", className: "text-end" },        // 7
                { data: "employee", title: "Employee", className: "text-start" }     // 8
            ],
            rowCallback: function (row, data) {
                $('td:eq(5)', row).addClass('bg-credit');
                $('td:eq(6)', row).addClass('bg-debit');
                $('td:eq(7)', row).addClass('bg-balance');
            }
        };

        if (loadData) {
            options.ajax = {
                url: '/bank_ledger_view/',
                type: "POST",
                data: function (data) {
                    data.csrfmiddlewaretoken = document.getElementsByName("csrfmiddlewaretoken")[0].value;
                    const isDateChecked = $('#is_date').is(":checked");
                    const fromDate = $('#from_date').val();
                    const toDate = $('#to_date').val();
                    const bankId = $('#filter_bank_id').val();

                    data.bank_id = bankId;

                    if (isDateChecked && fromDate && toDate) {
                        data.from_date = fromDate;
                        data.to_date = toDate;
                    }
                },
                dataSrc: function (response) {

                    // Handle permission & bank selection errors
                    if (
                        response.message === 'permission' ||
                        response.message === 'permission_bank' ||
                        !response.data ||
                        response.data.length === 0
                    ) {

                        $('#closing_balance')
                            .text('₹ 0.00')
                            .removeClass('text-danger')
                            .addClass('text-success');

                        if (response.message === 'permission') {
                            showSweetAlert(
                                'warning',
                                response.error_message || 'You do not have permission to view the bank ledger.'
                            );
                        }

                        if (response.message === 'permission_bank') {
                            showSweetAlert(
                                'warning',
                                response.error_message || 'Please Select Bank'
                            );
                        }

                        return [];
                    }

                    // Normal flow
                    let closingBalance = parseFloat(response.closing_balance || 0);

                    $('#closing_balance').text(
                        '₹ ' + closingBalance.toLocaleString('en-IN', {
                            minimumFractionDigits: 2,
                            maximumFractionDigits: 2
                        })
                    );

                    if (closingBalance >= 0) {
                        $('#closing_balance')
                            .removeClass('text-danger')
                            .addClass('text-success');
                    } else {
                        $('#closing_balance')
                            .removeClass('text-success')
                            .addClass('text-danger');
                    }

                    return response.data;
                }

            };
        } else {
            options.data = [];
        }

        table = $('#datatable').DataTable(options);
    }
</script>