{% load static %}
{% include 'includes/header.html' %}
{% include 'includes/sidebar.html' %}
{% include 'includes/navbar.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-3 mb-5">
                    <label for="name" class="form-label">Store</label>
                    <select class="select2  form-control" id="filter_store_id" name="store_id" required>
                        <option value="">Select</option>
                        {% for k in branch %}
                        <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 pt-0">
                <table class="datatables-basic table table-bordered" id="datatable">
                    <thead>
                        <tr>
                            <th>Id</th>
                            <th>Action</th>
                            <th>Date</th>
                            <th>Store</th>
                            <th>Expense Type</th>
                            <th>Bank Name</th>
                            <th>Amount (₹)</th>
                            <th>Cash (₹)</th>
                            <th>Bank (₹)</th>
                            <th>Description</th>
                            <th>Status</th>
                        </tr>
                    </thead>
                </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-12 mb-5">
                                <label for="name" class="form-label"><span style="color: red;">*</span> Name</label>
                                <input class="form-control" type="text" id="name" name="name" required>
                            </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-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">
                        <button type="button" class="btn btn-danger" data-bs-dismiss="modal">Close</button>
                        <button type="submit" id="submitBtn" class="btn btn-success">Add</button>
                        <input type="hidden" name="is_wholesale" value="{{is_wholesale}}">
                    </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"><span style="color: red;">*</span> Date</label>
                                <input class="form-control" type="date" id="edit_date" name="date">
                            </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="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> Name</label>
                                <input class="form-control" type="text" id="edit_name" name="name" required>
                            </div>
                            <div class="col-6 mb-5">
                                <label for="name" class="form-label">Status</label>
                                <select class="select2  form-control" id="edit_is_active" name="is_active">
                                    <option value="">Select</option>
                                    <option value="1">Active</option>
                                    <option value="0">Inactive</option>
                                </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-3 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-3 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-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;

    var expenseId = '{{expense_id}}';

    if (expenseId != 0 || expenseId != '') {
        $('#filter_expense_id').val(expenseId).trigger('change');
    }



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

        validatePaymentSplit({
            total: '#amount',
            cash: '#cash',
            bank: '#bank',
            bankSelect: '#bank_id',
            submitBtn: '#submitBtn',
            amountError: '#amountError',
            bankError: '#bankError'
        });

        validatePaymentSplit({
            total: '#edit_amount',
            cash: '#edit_cash',
            bank: '#edit_bank',
            bankSelect: '#edit_filter_expense_id',
            submitBtn: '#editSubmitBtn',
            amountError: '#amountError',
            bankError: '#bankError'
        });

        CurrentDate('date'); // set current date (function in common_js)
        refresh_data();





    });






    // datatable 
    function initializeDataTable() {
        table = $('#datatable').DataTable({
            "processing": true,
            "pageLength": 50,
            "destroy": true,
            "order": [],
            "searching": false,
            "dom": getDataTableDom(),
            "buttons": getExportButtons(),
            "columns": [
                { "data": "id", "title": " ID #" },
                { "data": "action", "title": "Action" },
                { "data": "date", "title": "Date" },
                { "data": "store", "title": "Store" },
                { "data": "expense", "title": "Expense Type" },
                { "data": "bank_name", "title": "Bank Name" },
                { "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_id = $('#filter_expense_id').val();
                    data.store_id = $('#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 || [];
                }
            }
        });
    }


    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');
        setCurrentDate('date');
        $('#expense_id').val('').trigger('change')
    });


    // 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_description').val(res.description);
            $('#edit_is_active').val(res.is_active).trigger("change");
            $('#edit_modal').modal('show');
        });
    }


    // 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
            if (amountError) {
                amountError.classList.add('d-none');
                amountError.textContent = '';
            }
            if (bankError) {
                bankError.classList.add('d-none');
                bankError.textContent = '';
            }

            // ❌ Cash + Bank must equal total
            if ((cash + bank) !== total) {
                if (hasInteracted && amountError) {
                    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 && !bankSelectEl.value) {
                if (bankError) {
                    bankError.textContent = 'Please select a bank';
                    bankError.classList.remove('d-none');
                }
                valid = false;
            }

            if (submitBtn) 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();
            });
        }
    }

</script>