@extends('layouts.order-master')
@section('css')
    <link href="https://cdn.jsdelivr.net/npm/select2@4.1.0-rc.0/dist/css/select2.min.css" rel="stylesheet" type="text/css" />
    <link href="{{ URL::asset('assets/libs/sweetalert2/sweetalert2.min.css') }}" rel="stylesheet" type="text/css" />
    <link href="https://cdn.datatables.net/1.11.5/css/dataTables.bootstrap5.min.css" rel="stylesheet" type="text/css" />
    <!--datatable responsive css-->
    <link href="https://cdn.datatables.net/responsive/2.2.9/css/responsive.bootstrap.min.css" rel="stylesheet"
        type="text/css" />
    <link href="https://cdn.datatables.net/buttons/2.4.1/css/buttons.dataTables.min.css" rel="stylesheet" type="text/css" />
    <style>
        .buttons-html5,
        .buttons-print {
            background: #405189 !important;
            color: white !important;
            margin: 5px !important;
            height: 31px !important;
            width: 70px !important;
            border-radius: 5px !important;
        }

        .form-input-box {
            text-align: center !important;
            height: 36px !important;
            padding: 0px !important;
        }
        .dt-buttons button {
            border-radius: 5px !important;
        }
    </style>
@endsection
@section('title')
    Settlements
@endsection
@section('content')
    <div class="row">
        <div class="col-lg-12">
            <div class="card">
                <div class="card-header d-flex align-items-center">
                    <h4 class="card-title mb-0 flex-grow-1">Settlements</h4>
                </div>
                <div class="card-body">
                    <div class="row mb-3">
                        <div class="col-md-3">
                            <label for="start date">From Date</label>
                            <input class="form-control" type="date" name="from_date" id="from_date">
                        </div>
                        <div class="col-md-3">
                            <label for="start date">To Date</label>
                            <input class="form-control" type="date" name="to_date" id="to_date">
                        </div>
                        <div class="col-md-3">
                            <label for="start date">Sales Executive</label>
                            <select name="sales_executive" id="sales_executive" class="form-control">
                                <option value="">Select Sales Executive</option>
                                @foreach ($sales_executives as $sales_executive)
                                    <option value="{{ $sales_executive->id }}">{{ $sales_executive->name }}
                                    </option>
                                @endforeach
                            </select>
                        </div>
                        <div class="col-md-3 text-end" style="margin-top: 28px;">
                            <button type="button" name="filter" id="filter" class="btn btn-sm btn-primary"><i
                                    class="ri-search-line fs-6"></i></button>
                            <button type="button" name="refresh" id="refresh" class="btn btn-sm btn-danger"><i
                                    class="ri-refresh-line fs-6"></i></button>
                        </div>
                    </div>
                    <table id="fixed-header" class="table table-bordered dt-responsive table-striped align-middle"
                        style="width:100%">
                        <thead>
                            <tr>
                                <th>Date</th>
                                <th>Staff</th>
                                <th>Advance Amount</th>
                                <th>Collection Amount</th>
                                <th>Expense Amount</th>
                                <th>Total Amount</th>
                                <th>Amount Collected</th>
                                <th>Advance Return Voucher</th>
                                <th>Balance Allocation Voucher</th>
                                <th>Balance Amount</th>
                                <th>Action</th>
                            </tr>
                        </thead>
                        <tbody>
                        </tbody>
                    </table>
                </div>
            </div>
        </div>
    </div>

    {{-- Settle Collection Modal --}}
    <div class="modal fade modal-xl" id="settleCollectionModal" tabindex="-1" aria-labelledby="exampleModalLabel"
        aria-hidden="true">
        <div class="modal-dialog modal-dialog-centered">
            <div class="modal-content">
                <div class="modal-header bg-light p-3">
                    <h5 class="modal-title" id="exampleModalLabel">Update Settlement</h5>
                    <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"
                        id="close-modal"></button>
                </div>
                <div class="modal-body">
                    <div class="mt-2">
                        <form action="{{ route('cash-collection-settlement-update') }}" method="POST"
                            class="tablelist-form" autocomplete="off" id="settleCollectionForm">
                            @csrf
                            <input type="hidden" name="settlementId" id="settlementId" value="">
                            <div class="row mb-3">
                                <div class="col-md-6">
                                    <h4>Advance Amount</h4>
                                </div>
                                <div class="col-md-6 text-end">
                                    <h4 id="advancePaymentAmount">0</h4>
                                </div>
                            </div>
                            <div id="collectionList"></div>
                            <div class="row mb-3">
                                <div class="col-md-6">
                                    <h4>Selected Collection Amount</h4>
                                </div>
                                <div class="col-md-6  text-end">
                                    <h4 id="totalSelectedAmount">0</h4>
                                </div>
                            </div>
                            <div class="row mb-3">
                                <div class="col-md-6">
                                    <h4>Sub Total</h4>
                                </div>
                                <div class="col-md-6  text-end">
                                    <h4 id="collectionPlusAdvance">0</h4>
                                </div>
                            </div>
                            <div id="expenseList"></div>
                            <div class="row mb-3">
                                <div class="col-md-6">
                                    <h4>Total Expense</h4>
                                </div>
                                <div class="col-md-6  text-end">
                                    <h4 id="totalExpenseAmount">0</h4>
                                </div>
                            </div>
                            <div class="row mb-3">
                                <div class="col-md-6">
                                    <h4>Settlement Amount</h4>
                                </div>
                                <div class="col-md-6  text-end">
                                    <h4 id="totalAmountToCollected">0</h4>
                                </div>
                            </div>
                            <div class="row mb-3">
                                <div class="col-md-10">
                                    <h4>Amount Collected</h4>
                                </div>
                                <div class="col-md-2  text-end">
                                    <input type="number" name="amount_collected" id="amount_collected"
                                        class="form-control" required>
                                </div>
                            </div>
                            <div class="row mb-3">
                                <div class="col-md-4">
                                    <h4>Balance Amount</h4><br>
                                    <h4 id="balanceAmount">0</h4>
                                </div>
                                <div class="col-md-4">
                                    <h4>Add Balance To Advance</h4><br>
                                    <input type="checkbox" class="form-control form-check-input form-input-box"
                                        style="width: 36px;" name="add_balance_to_advance" id="add_balance_to_advance"
                                        checked>
                                </div>
                            </div>

                        </form>
                    </div>
                    <div class="modal-footer">
                        <div class="hstack gap-2 justify-content-end">
                            <button type="button" class="btn btn-light" data-bs-dismiss="modal">Close</button>
                            <button type="button" class="btn btn-primary" id="settle-collection-btn">Settlement</button>
                        </div>
                    </div>
                    </form>
                </div>
            </div>
        </div>
    </div>
@endsection
@section('script')
    <script src="https://cdn.jsdelivr.net/npm/select2@4.1.0-rc.0/dist/js/select2.min.js"></script>
    <script src="https://cdn.datatables.net/1.11.5/js/jquery.dataTables.min.js"></script>
    <script src="https://cdn.datatables.net/1.11.5/js/dataTables.bootstrap5.min.js"></script>
    <script src="https://cdn.datatables.net/buttons/2.3.2/js/dataTables.buttons.min.js" type="text/javascript"></script>
    <script src="https://cdnjs.cloudflare.com/ajax/libs/jszip/3.1.3/jszip.min.js" type="text/javascript"></script>
    <script src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.53/pdfmake.min.js" type="text/javascript"></script>
    <script src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.53/vfs_fonts.js" type="text/javascript"></script>
    <script src="https://cdn.datatables.net/buttons/2.3.2/js/buttons.html5.min.js" type="text/javascript"></script>
    <script src="https://cdn.datatables.net/buttons/2.3.2/js/buttons.print.min.js" type="text/javascript"></script>
    <script src="{{ URL::asset('/assets/libs/sweetalert2/sweetalert2.min.js') }}"></script>
    <script src="{{ URL::asset('/assets/js/app.min.js') }}"></script>
    <script>
        $(document).ready(function() {
            loadData();
        });

        $('#sales_executive').select2({
            placeholder: 'Select Sales Executive',
            allowClear: true,
        });

        function loadData() {
            var dataTable = $('#fixed-header').DataTable({
                processing: true,
                serverSide: true,
                "scrollX": true,
                autoWidth: true,
                stateSave: true,
                ordering: false,
                pageLength: 10,
                lengthMenu: [
                    [10, 50, 100, -1],
                    [10, 50, 100, "All"]
                ],
                dom: 'lBfrtip',
                buttons: [{
                        extend: 'excelHtml5',
                        exportOptions: {
                            columns: [0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10]
                        },
                    },
                    {
                        extend: 'pdfHtml5',
                        exportOptions: {
                            columns: [0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10]
                        },
                    },
                    {
                        extend: 'print',
                        exportOptions: {
                            columns: [0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10]
                        },
                    }, 'colvis'
                ],
                ajax: {
                    url: '/admin/collection-settlements',
                    type: 'GET',
                    data: function(d) {
                        d.from_date = $("#from_date").val();
                        d.to_date = $("#to_date").val();
                        d.sales_executive = $("#sales_executive").val();
                    }
                },
                columns: [{
                        data: 'date',
                        name: 'date'
                    },
                    {
                        data: 'user',
                        name: 'user',
                    },
                    {
                        data: 'advance_amount',
                        name: 'advance_amount',
                    },
                    {
                        data: 'collection_amount',
                        name: 'collection_amount',
                    },
                    {
                        data: 'expense_amount',
                        name: 'expense_amount',
                    },
                    {
                        data: 'total_amount',
                        name: 'total_amount',
                    },
                    {
                        data: 'amount_collected',
                        name: 'amount_collected',
                    },
                    {
                        data: 'advance_return_voucher',
                        name: 'advance_return_voucher',
                    },
                    {
                        data: 'balance_allocation_voucher',
                        name: 'balance_allocation_voucher',
                    },
                    {
                        data: 'balance_allocation_amount',
                        name: 'balance_allocation_amount',
                    },
                    {
                        data: 'action',
                        name: 'action',
                        orderable: false,
                        searchable: false
                    },
                ],
            });
        }

        $('#filter').click(function(e) {
            e.preventDefault();
            $('#fixed-header').DataTable().ajax.reload();
        });

        $('#refresh').click(function(e) {
            e.preventDefault();
            $('#from_date').val('');
            $('#to_date').val('');
            $('#sales_executive').val('').trigger('change');
            $('#fixed-header').DataTable().ajax.reload();
        });
        $(document).on('click', '.edit-list', function(e) {
            e.preventDefault();
            var id = $(this).data('id');
            $('#settlementId').val(id);
            $.ajax({
                headers: {
                    'X-CSRF-TOKEN': $('meta[name="csrf-token"]').attr('content')
                },
                type: "post",
                url: "/admin/collection-settlement/" + id + "/edit",
                success: function(response) {
                    $('#collectionList').html('');
                    $('#collectionList').html(response.html);
                    $('#expenseList').html('');
                    $('#expenseList').html(response.html1);
                    $('#advancePaymentAmount').html(response.advance_payment_return_amount);
                    $('#collectionPlusAdvance').html(parseFloat(response.collectionTotal) + parseFloat(
                        response
                        .advance_payment_return_amount));
                    $('#totalAmountToCollected').html(parseFloat(response.collectionTotal) + parseFloat(
                        response
                        .advance_payment_return_amount) - parseFloat(response.expense_amount));
                    $('#totalExpenseAmount').html(response.expense_amount);
                    $('#totalSelectedAmount').html(response.collectionTotal);
                    $('#amount_collected').val(response.amount_collected);
                    $('#balanceAmount').html(response.balance_amount);
                    if (response.is_added_to_balance == 1) {
                        $('#add_balance_to_advance').prop('checked', true);
                    } else {
                        $('#add_balance_to_advance').prop('checked', false);
                    }

                }
            });
            $('#settleCollectionModal').modal('show');
        });

        $('#amount_collected').on('keyup', function() {
            var totalAmountToCollected = $('#totalAmountToCollected').html();
            var amount_collected = $(this).val();
            if (amount_collected == '' || amount_collected == null) {
                amount_collected = 0;
            }
            var balanceAmount = parseFloat(totalAmountToCollected) - parseFloat(amount_collected);
            $('#balanceAmount').html(balanceAmount.toFixed(3));
        });

        $(document).on('click', '.checkbox', function(e) {
            if ($(this).prop('checked') == true) {
                $(this).prop('checked', true);
            } else {
                $(this).prop('checked', false);
            }
            var totalAmt = 0;
            $('.checkbox').each(function() {
                if ($(this).prop('checked') == true) {
                    totalAmt += parseFloat($(this).data('amount'));
                }
            });
            $('#totalSelectedAmount').html(totalAmt.toFixed(3));
            calculateTotalAmount();
        })

        function calculateTotalAmount() {
            var totalCollection = $('#totalSelectedAmount').html();
            var totalExpense = $('#totalExpenseAmount').html();
            var advanceAmount = $('#advancePaymentAmount').html();
            var totalAmountToCollected = parseFloat(totalCollection) + parseFloat(advanceAmount) -
                parseFloat(totalExpense);
            $('#collectionPlusAdvance').html(parseFloat(totalCollection) + parseFloat(advanceAmount));
            $('#totalAmountToCollected').html(totalAmountToCollected.toFixed(3));
            if ($('#amount_collected').val() == '' || $('#amount_collected').val() == null) {
                $('#amount_collected').val(totalAmountToCollected.toFixed(3));
            }
            $('#amount_collected').trigger('keyup');
        }

        var debounceTimeout;
        let isRequestInProgress = false;
        $(document).on('click', '#settle-collection-btn', function(e) {
            e.preventDefault();
            $('#settleCollectionModal').modal('hide');
            $('#settle-collection-btn').prop('disabled', true);
            if (isRequestInProgress) return;
            isRequestInProgress = true;
            var form = $('#settleCollectionForm');
            var url = form.attr('action');
            var formData = new FormData(form[0]);
            debounceTimeout = setTimeout(() => {
                $.ajax({
                    type: "POST",
                    url: url,
                    data: formData,
                    contentType: false,
                    processData: false,
                    success: function(response) {
                        isRequestInProgress = false;
                        $('#settle-collection-btn').prop('disabled', false);
                        if (response.status == "success") {
                            const Toast = Swal.mixin({
                                toast: true,
                                position: 'top-end',
                                showConfirmButton: false,
                                timer: 3000,
                                timerProgressBar: true,
                            })

                            Toast.fire({
                                icon: 'success',
                                title: response.message,
                            })
                            $('#settleCollectionModal').modal('hide');
                            $('#fixed-header').DataTable().ajax.reload();
                        } else {
                            const Toast = Swal.mixin({
                                toast: true,
                                position: 'top-end',
                                showConfirmButton: false,
                                timer: 3000,
                                timerProgressBar: true,
                            })

                            Toast.fire({
                                icon: 'error',
                                title: response.message,
                            })
                        }
                    },
                })
            }, 300);
        })
    </script>
@endsection