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

{% if request.session.user_type == 'stores' %}
    {% include 'includes/store_sidebar.html' %}
{% endif %}

{% if request.session.user_type == 'wholesale' %}
    {% include 'includes/wholesale_sidebar.html' %}
{% endif %}

{% 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">Expense</h4>
            <button type="button" class="btn btn-success btn-sm" data-bs-toggle="modal"
                data-bs-target="#add_modal">Add</button> &nbsp
        </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 active" aria-current="page">Expense</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-3 mb-5">
                    <label for="name" class="form-label">Expense Type</label>
                    <select class="select2  form-control" id="filter_expense_id" name="expense_id" required>
                        <option value="">Select</option>
                        {% for k in expense %}
                        <option value="{{k.id}}">{{k.name}}</option>
                        {% endfor %}
                    </select>
                </div>



                <div class="col-2 mt-6">
                    <button type="button" class="btn btn-primary" onclick="refresh_data()">Refresh</button>

                </div>
            </div>
        </div>
        <div class="card-body">
            <div class="card-datatable table-responsive">
                <table class="datatables-basic table table-bordered" id="datatable">
                    <thead>
                        <tr>
                            <th>Id</th>
                            <th>Action</th>
                            <th>Date</th>
                            <th>Expense Type</th>
                            <th>bank</th>
                            <th>Amount</th>
                            <th>Cash</th>
                            <th>Bank</th>
                            <th>Description</th>
                            <th>Status</th>
                        </tr>
                    </thead>
                    <tbody></tbody>
                    <tfoot>
                        <th colspan="5" class="text-end fw-bold">Total :</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_desciption" class="text-end fw-bold"></th>
                        <th id="footer_status" class="text-end fw-bold"></th>


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


    <!-- add modal -->
    <div id="add_modal" class="modal fade" tabindex="-1" role="dialog" aria-labelledby="exampleModalLiveLabel"
        aria-hidden="true">
        <div class="modal-dialog" role="document">
            <div class="modal-content">
                <div class="modal-header">
                    <h5 class="modal-title" id="exampleModalLiveLabel">Add Expense</h5>
                    <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
                </div>
                <form id="add_form">
                    <div class="modal-body">
                        {% csrf_token %}
                        <div class="row">
                            <div class="col-6 mb-5">
                                <label for="name" class="form-label"><span style="color: red;">*</span> Date</label>
                                <input class="form-control" type="date" id="date" name="date" required>
                            </div>
                            <div class="col-6 mb-5">
                                <label for="name" class="form-label"><span style="color: red;">*</span> Expense
                                    Type</label>
                                <select class="select2  form-control" id="expense_id" name="expense_id" required>
                                    <option value="">Select</option>
                                    {% for k in expense %}
                                    <option value="{{k.id}}">{{k.name}}</option>
                                    {% endfor %}
                                </select>
                            </div>

                            <div class="col-6 mb-5">
                                <label for="name" class="form-label"><span style="color: red;">*</span> Amount(₹)</label>
                                <input class="form-control" type="number" id="amount" name="amount" required>
                                <small class="text-danger d-none" id="amountError"></small>
                            </div>



                            <div class="col-6 mb-5">
                                <label for="name" class="form-label">Bank</label>
                                <select class="select2  form-control" id="bank_id" name="bank_id">
                                    <option value="">Select</option>
                                    {% for k in bank %}
                                    <option value="{{k.id}}">{{k.name}}</option>
                                    {% endfor %}
                                </select>
                            </div>

                            <div class="col-6 mb-5">
                                <label for="name" class="form-label"> Cash(₹)</label>
                                <input class="form-control" type="number" id="cash" name="cash">
                            </div>


                            <div class="col-6 mb-5">
                                <label for="name" class="form-label"> Bank(₹)</label>
                                <input class="form-control" type="number" id="bank" name="bank">
                                <small class="text-danger d-none" id="bankError"></small>
                            </div>
                           <div class="col-12 mb-3 d-none" id="balanceDisplay">
                                <div style="font-weight:600; color:#000;">
                                    Available Cash:
                                    <span id="cashBalanceText" style="color:red;">0.00</span>
                                    &nbsp;&nbsp;|&nbsp;&nbsp;
                                    Bank Balance:
                                    <span id="bankBalanceText" style="color:red;">0.00</span>
                                </div>
                            </div>





                            <div class="col-12 mb-5">
                                <label for="description" class="form-label">Description</label>
                                <textarea class="form-control" id="description" rows="3" name="description"></textarea>
                            </div>
                        </div>
                    </div>
                    <div class="modal-footer">
                        <input type="hidden" name="is_active" value="1">
                        <input type="hidden" name="is_wholesale" value="{{is_wholesale}}">
                        <button type="button" class="btn btn-danger" data-bs-dismiss="modal">Close</button>
                        <button type="submit" id="submitBtn" class="btn btn-success">Add</button>
                    </div>
                </form>
            </div>
        </div>
    </div>


    <div id="edit_modal" class="modal fade" tabindex="-1" role="dialog" aria-labelledby="exampleModalLiveLabel"
        aria-hidden="true">
        <div class="modal-dialog" role="document">
            <div class="modal-content">
                <div class="modal-header">
                    <h5 class="modal-title" id="exampleModalLiveLabel">Edit Expense</h5>
                    <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
                </div>
                <form id="edit_form">
                    <div class="modal-body">
                        {% csrf_token %}
                        <div class="row">
                            <div class="col-6 mb-5">
                                <label for="name" class="form-label">Date</label>
                                <input class="form-control" type="date" id="edit_date" name="date" required>
                            </div>
                            <div class="col-6 mb-5">
                                <label for="name" class="form-label">Expense Type</label>
                                <select class="select2  form-control" id="edit_expense_id" name="expense_id" required>
                                    <option value="">Select</option>
                                    {% for k in expense %}
                                    <option value="{{k.id}}">{{k.name}}</option>
                                    {% endfor %}
                                </select>
                            </div>
                           
                            
                            <div class="col-6 mb-5">
                                <label for="name" class="form-label"><span style="color: red;">*</span> Amount(₹)</label>
                                <input class="form-control" type="number" id="edit_amount" name="amount" required>
                            </div>
                            <div class="col-6 mb-5">
                                <label for="name" class="form-label">Bank</label>
                                <select class="select2  form-control" id="edit_bank_id" name="bank_id">
                                    <option value="">Select</option>
                                    {% for k in bank %}
                                    <option value="{{k.id}}">{{k.name}}</option>
                                    {% endfor %}
                                </select>
                            </div>
                            <div class="col-6 mb-5">
                                <label for="name" class="form-label"> Cash(₹)</label>
                                <input class="form-control" type="number" id="edit_cash" name="cash">
                            </div>


                            <div class="col-6 mb-5">
                                <label for="name" class="form-label"> Bank(₹)</label>
                                <input class="form-control" type="number" id="edit_bank" name="bank">
                            </div>
                            <div class="col-12 mb-3 d-none" id="editBalanceDisplay">
                                <div style="font-weight:600; color:#000;">
                                    Available Cash:
                                    <span id="editcashBalanceText" style="color:red;">0.00</span>
                                    &nbsp;&nbsp;|&nbsp;&nbsp;
                                    Bank Balance:
                                    <span id="editBnakBalanceText" style="color:red;">0.00</span>
                                </div>
                            </div>


                            <div class="col-12 mb-5">
                                <label for="description" class="form-label">Description</label>
                                <textarea class="form-control" id="edit_description" rows="3"
                                    name="description"></textarea>
                            </div>
                        </div>
                    </div>
                    <div class="modal-footer">
                        <input type="hidden" id="edit_id" name="id">
                        <button type="button" class="btn btn-danger" data-bs-dismiss="modal">Close</button>
                        <button type="submit" class="btn btn-success">Update</button>
                    </div>
                </form>
            </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 );
        initDatePickerFlow();

        CurrentDate('date'); // set current date (function in common_js)
        refresh_data();
        preventNegativeInput('cash');
        preventNegativeInput('bank');
        preventNegativeInput('amount');
        preventNegativeInput('edit_cash');
        preventNegativeInput('edit_bank');
        preventNegativeInput('edit_amount');

        // setupAmountCashBankHandlers('amount', 'cash', 'bank', 'add_form');
        // setupAmountCashBankHandlers('edit_amount', 'edit_cash', 'edit_bank', 'edit_form');
        validatePaymentSplit({
            total: '#amount',
            cash: '#cash',
            bank: '#bank',
            bankSelect: '#bank_id',
            submitBtn: '#submitBtn',
            amountError: '#amountError',
            bankError: '#bankError'
        });




    });






    // datatable 
    function initializeDataTable() {
        table = $('#datatable').DataTable({
            "processing": true,
            "pageLength": 50,
            "destroy": true,
            "order": [],
            "searching": true,
            "dom": getDataTableDom(),
            "buttons": getExportButtons(),
            "columns": [
                { "data": "id", "title": " ID #" },
                { "data": "action", "title": "Action" },
                { "data": "date", "title": "Date" },
                { "data": "expense", "title": "Expense Type" },
                { "data": "bank_name", "title": "Bank" },
                { "data": "amount", "title": "Amount (₹)", "className": "text-end" },
                { "data": "cash", "title": "cash (₹)", "className": "text-end" },
                { "data": "bank", "title": "bank (₹)", "className": "text-end" },
                { "data": "description", "title": " Description" },
                { "data": "status", "title": "Status" }
            ],
            "ajax": {
                "url": '/expense_view/',
                "type": "POST",
                "data": function (data) {
                    data.csrfmiddlewaretoken = document.getElementsByName("csrfmiddlewaretoken")[0].value;
                    data.expense = $('#filter_expense_id').val();
                    data.branch = $('#filter_store_id').val();
                    if ($('#is_date').is(":checked")) {
                        data.from_date = $('#from_date').val();
                        data.to_date = $('#to_date').val();
                        console.log('from_date', data.from_date)
                        console.log('to_date', data.to_date)
                    }

                },
                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 Amount = data.reduce((sum, row) => sum + intVal(row.amount), 0);
                const Cash = data.reduce((sum, row) => sum + intVal(row.cash), 0);
                const Bank = data.reduce((sum, row) => sum + intVal(row.bank), 0);


                // Upate footer cells
                $('#footer_amount').html(Amount.toLocaleString(undefined, { minimumFractionDigits: 2 }));
                $('#footer_cash').html(Cash.toLocaleString(undefined, { minimumFractionDigits: 2 }));
                $('#footer_bank').html(Bank.toLocaleString(undefined, { minimumFractionDigits: 2 }));
                $('#footer_desciption').html('-');
                $('#footer_status').html('-');


            },
        });
    }


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



    // add 
    $("#add_form").submit(function (e) {
        e.preventDefault();
        handleFormSubmit(this, '/expense_add/', 'add_modal', 'add_form', true, 'Expense');
    });


    // edit
    function edit_data(id, name) {
        var tkn = document.getElementsByName("csrfmiddlewaretoken")[0].value;

        $.post('/expense_edit/', { id: id, csrfmiddlewaretoken: tkn }, function (res) {

            $('#edit_id').val(res.id);
            $('#edit_date').val(res.date);
            $('#edit_expense_id').val(res.expense_id).trigger('change');
            $('#edit_name').val(res.name);
            $('#edit_amount').val(res.amount);
            $('#edit_cash').val(res.cash);
            $('#edit_bank').val(res.bank);
            $('#edit_description').val(res.description);
            $('#edit_bank_id').val(res.bank_id).trigger("change");

            $('#edit_modal').modal('show');

            // 🔥 THIS LINE makes balance visible on open
            editExpenseHandler.refreshBalances();
        });
    }



    // update
    $("#edit_form").submit(function (e) {
        e.preventDefault();
        handleFormSubmit(this, '/expense_update/', 'edit_modal', 'edit_form', false, 'Expense');
    });


    // delete
    function delete_data(id) {
        deleteEntity('/expense_delete/', id, '{{ csrf_token }}', 'Expense');
    }


    function validatePaymentSplit(config) {
        const totalEl = document.querySelector(config.total);
        const cashEl = document.querySelector(config.cash);
        const bankEl = document.querySelector(config.bank);
        const bankSelectEl = document.querySelector(config.bankSelect);
        const submitBtn = document.querySelector(config.submitBtn);

        const amountError = document.querySelector(config.amountError);
        const bankError = document.querySelector(config.bankError);

        let hasInteracted = false;

        function validate(e) {
            if (e && (e.target === cashEl || e.target === bankEl)) {
                hasInteracted = true;
            }

            let total = parseFloat(totalEl.value) || 0;
            let cash = parseFloat(cashEl.value) || 0;
            let bank = parseFloat(bankEl.value) || 0;

            let valid = true;

            // 🔄 Reset errors every time
            amountError.classList.add('d-none');
            bankError.classList.add('d-none');
            amountError.textContent = '';
            bankError.textContent = '';

            // ❌ Cash + Bank must equal total
            if ((cash + bank) !== total) {
                if (hasInteracted) {
                    amountError.textContent = (cash + bank) > total
                        ? 'Cash + Bank exceeds Total Amount'
                        : 'Cash + Bank must equal Total Amount';
                    amountError.classList.remove('d-none');
                }
                valid = false;
            }

            // ❌ Bank amount entered but bank not selected
            if (bank > 0 && !bankSelectEl.value) {
                bankError.textContent = 'Please select a bank';
                bankError.classList.remove('d-none');
                valid = false;
            }

            // ✅ Enable / Disable submit
            submitBtn.disabled = !valid;
        }

        // Standard inputs
        [totalEl, cashEl, bankEl].forEach(el => {
            if (el) el.addEventListener('input', validate);
        });

        // 🔥 SELECT2 COMPATIBILITY: use jQuery change event
        if (bankSelectEl) {
            $(bankSelectEl).on('change', function () {
                validate();
            });
        }
    }

let AVAILABLE_CASH = 0;
let AVAILABLE_BANK = 0;
function initExpenseBalanceHandler(config) {
    let AVAILABLE_CASH = 0;
    let AVAILABLE_BANK = 0;

    const amountEl      = $(config.amount);
    const cashEl        = $(config.cash);
    const bankEl        = $(config.bank);
    const bankSelectEl  = $(config.bankSelect);
    const displayEl     = $(config.display);
    const cashTextEl    = $(config.cashText);
    const bankTextEl    = $(config.bankText);

    displayEl.addClass('d-none');

    function fetchCashBalance() {
        return $.get("/ajax_get_balance/", function (res) {
            AVAILABLE_CASH = parseFloat(res.cash_balance) || 0;
            cashTextEl.text(`₹${AVAILABLE_CASH}`);
            displayEl.removeClass('d-none');
        });
    }

    function fetchBankBalance(bankId) {
        if (!bankId) {
            bankTextEl.text('--');
            return;
        }

        $.get("/ajax_get_balance/", { bank_id: bankId }, function (res) {
            AVAILABLE_BANK = parseFloat(res.bank_balance) || 0;
            bankTextEl.text(`₹${AVAILABLE_BANK}`);
        });
    }

    // amount input
    amountEl.on('input', function () {
        let amount = parseFloat(this.value) || 0;
        if (amount <= 0) {
            displayEl.addClass('d-none');
            return;
        }

        fetchCashBalance().done(() => {
            cashEl.val(amount);
            bankEl.val(0);
        });
    });

    // bank change
    bankSelectEl.on('change', function () {
        fetchBankBalance($(this).val());
    });

    // cash → bank
    cashEl.on('input', function () {
        let total = parseFloat(amountEl.val()) || 0;
        let cash  = parseFloat(this.value) || 0;
        if (cash > total) cash = total;
        bankEl.val(Math.max(total - cash, 0));
    });

    // bank → cash
    bankEl.on('input', function () {
        let total = parseFloat(amountEl.val()) || 0;
        let bank  = parseFloat(this.value) || 0;
        if (bank > total) bank = total;
        cashEl.val(Math.max(total - bank, 0));
    });

    // 🔓 expose manual refresh for EDIT
    return {
        refreshBalances: function () {
            let bankId = bankSelectEl.val();
            fetchCashBalance().done(() => {
                fetchBankBalance(bankId);
            });
        }
    };
}
const addExpenseHandler = initExpenseBalanceHandler({
    amount: '#amount',
    cash: '#cash',
    bank: '#bank',
    bankSelect: '#bank_id',
    display: '#balanceDisplay',
    cashText: '#cashBalanceText',
    bankText: '#bankBalanceText'
});

const editExpenseHandler = initExpenseBalanceHandler({
    amount: '#edit_amount',
    cash: '#edit_cash',
    bank: '#edit_bank',
    bankSelect: '#edit_bank_id',
    display: '#editBalanceDisplay',
    cashText: '#editcashBalanceText',
    bankText: '#editBnakBalanceText'
});


</script>