@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: 35px !important;
            width: 70px !important;
            border-radius: 5px !important;
        }

        .buttons-colvis {
            background: #405189 !important;
            color: #fff !important;
        }

        .dt-button-collection button.active {
            background: #405189 !important;
            color: #fff !important;

        }

        .form-input-box {
            text-align: center !important;
            height: 36px !important;
            padding: 0px !important;
        }
    </style>
@endsection
@section('title')
    Collection Settlement - {{ $user->name }}
@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"> Collection Settlement - {{ $user->name }}</h4>
                    @if (Auth::user()->can('collection settlement'))
                        <button id="multi-settle" class="btn btn-soft-primary" style="margin-right: 5px;">Settle</button>
                    @endif
                </div>
                @if (Session::has('success'))
                    <div class="alert alert-success alert-dismissible alert-label-icon label-arrow fade show"
                        role="alert">
                        <i class="ri-notification-line label-icon"></i><strong>Success</strong> -
                        {{ Session::get('success') }}
                    </div>
                @elseif(Session::has('error'))
                    <div class="alert alert-danger alert-dismissible alert-label-icon label-arrow fade show" role="alert">
                        <i class="ri-notification-line label-icon"></i><strong>Error</strong> -
                        {{ Session::get('error') }}
                    </div>
                @endif
                <div class="card-body">
                    <div class="row mb-3">
                        <div class="col-md-2">
                            <label for="start date">Settlement Date</label>
                            <input class="form-control" type="date" name="date" id="date"
                                value="{{ date('Y-m-d') }}">
                        </div>
                        <div class="col-md-2">
                            <label for="ledger">Ledger</label>
                            <select name="ledger" id="ledger" multiple>
                                <option value="">Select ledger</option>
                                @foreach ($ledgers as $ledger)
                                    <option value="{{ $ledger->id }}">{{ $ledger->name }}</option>
                                @endforeach
                            </select>
                        </div>
                        <div class="col-md-2">
                            <label for="ledger">Route</label>
                            <select name="route" id="route" multiple>
                                <option value="">Select a route</option>
                                @foreach ($routes as $route)
                                    <option value="{{ $route->id }}">{{ $route->name }}</option>
                                @endforeach
                            </select>
                        </div>
                        <div class="col-md-2">
                            <label for="ledger">Sub Route</label>
                            <select name="route" id="sub_route" multiple>
                                <option value="">Select a sub route</option>
                                @foreach ($subroutes as $route)
                                    <option value="{{ $route->id }}">{{ $route->name }}</option>
                                @endforeach
                            </select>
                        </div>
                        <div class="col-md-2">
                            <label for="ledger">Discount</label>
                            <select name="discount" id="discount">
                                <option value="">Select Discount</option>
                                <option value="yes">Cash Discount</option>
                                <option value="no">No Discount</option>
                            </select>
                        </div>
                        <div class="col-md-2 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>
                    <div class="row mb-3">
                        <div class="col-md-12 text-end" style="display: flex; justify-content: flex-end;">
                            <h4 style="margin-right: 20px;">Total Amount:</h4>
                            <h4 id="totalAmount">0</h4>
                        </div>
                    </div>
                    <table id="fixed-header" class="table table-bordered dt-responsive nowrap table-striped align-middle"
                        style="width:100%">
                        <thead>
                            <tr>
                                <th><input type="checkbox" id="select-all-checkbox"></th>
                                <th>Date</th>
                                <th>Reciept#</th>
                                <th>Customer</th>
                                <th>Discount</th>
                                <th>Amount</th>
                                <th>Payment Mode</th>
                                <th>Remarks</th>
                                {{-- <th>Action</th> --}}
                            </tr>
                        </thead>
                        <tbody>
                        </tbody>
                        <tfoot>
                            <tr>
                                <th colspan="4">Total</th>
                                <th></th>
                                <th></th>
                                <th></th>
                                <th></th>
                            </tr>
                        </tfoot>
                    </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">Settle Collections</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') }}" method="POST" class="tablelist-form"
                            autocomplete="off" id="settleCollectionForm">
                            @csrf
                            <input type="hidden" name="selectedItem" id="selectedItem">
                            <input type="hidden" name="userId" id="userId" value="{{ $user->id }}">
                            <input type="hidden" name="date" id="settlingDate">
                            <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.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="https://cdn.jsdelivr.net/npm/select2@4.1.0-rc.0/dist/js/select2.min.js"></script>
    <script src="https://cdnjs.cloudflare.com/ajax/libs/jquery-validate/1.19.5/jquery.validate.min.js"
        integrity="sha512-rstIgDs0xPgmG6RX1Aba4KV5cWJbAMcvRCVmglpam9SoHZiUCyQVDdH2LPlxoHtrv17XWblE/V/PP+Tr04hbtA=="
        crossorigin="anonymous" referrerpolicy="no-referrer"></script>
    <script src="https://cdn.datatables.net/buttons/2.4.1/js/buttons.colVis.min.js"></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();
        });

        $('#ledger').select2({
            placeholder: 'Select ledger',
        });
        $('#route').select2({
            placeholder: 'Select route',

        });
        $('#discount').select2({
            placeholder: 'Select discount type',

        });

        $('#sub_route').select2({
            placeholder: 'select sub route',
        });





        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: [1, 2, 3, 4, 5, 6, 7, 8]
                    }
                }, 'colvis'],
                ajax: {
                    url: '/admin/collection-settlement/' + {{ $user->id }},
                    type: 'GET',
                    data: function(d) {
                        d.date = $("#date").val();
                        d.ledger = $("#ledger").val();
                        d.route = $("#route").val();
                        d.discount = $("#discount").val();
                        d.sub_route = $("#sub_route").val();
                    }
                },
                columns: [{
                        data: 'select',
                        name: 'select',
                        orderable: false,
                        searchable: false
                    },
                    {
                        data: 'date',
                        name: 'date',
                    },
                    {
                        data: 'receipt_code',
                        name: 'receipt_code',
                    },
                    {
                        data: 'customer',
                        name: 'customer',
                    },
                    {
                        data: 'cash_discount',
                        name: 'cash_discount',
                    },
                    {
                        data: 'amount',
                        name: 'amount',
                    },
                    {
                        data: 'payment_mode',
                        name: 'payment_mode',
                    },
                    {
                        data: 'remarks',
                        name: 'remarks',
                    },
                    // {
                    //     data: 'action',
                    //     name: 'action',
                    //     orderable: false,
                    //     searchable: false
                    // },
                ],
                "footerCallback": function(row, data, start, end, display) {
                    var api = this.api(),
                        data;

                    // converting to interger to find total
                    var intVal = function(i) {
                        return typeof i === 'string' ?
                            i.replace(/[\$,]/g, '') * 1 :
                            typeof i === 'number' ?
                            i : 0;
                    };

                    var monTotal = 0;
                    for (var i = 0; i < data.length; i++) {
                        if (data[i].status !==
                            '<span class="badge rounded-pill bg-danger font-size-12">Cancelled</span>'
                        ) {
                            monTotal += intVal(data[i].amount);
                        }
                    }
                    var discTotal = 0;
                    for (var i = 0; i < data.length; i++) {
                        if (data[i].status !==
                            '<span class="badge rounded-pill bg-danger font-size-12">Cancelled</span>'
                        ) {
                            discTotal += intVal(data[i].cash_discount);
                        }
                    }
                    $(api.column(4).footer()).html(discTotal.toFixed(3));
                    $(api.column(5).footer()).html(monTotal.toFixed(3));
                }
            });
        }



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

        $('#refresh').click(function(e) {
            e.preventDefault();
            $('#from_date').val('');
            $('#to_date').val('');
            $('#ledger').val('').trigger('change');
            $('#discount').val('').trigger('change');
            $('#route').val('').trigger('change');
            $('#sub_route').val('').trigger('change');
            $('#fixed-header').DataTable().ajax.reload();
        });


        $('#select-all-checkbox').click(function(e) {
            if ($(this).prop('checked') == true) {
                $('.checkbox').prop('checked', true);
            } else {
                $('.checkbox').prop('checked', false);
            }
            var totalAmt = 0;
            $('.checkbox').each(function() {
                if ($(this).prop('checked') == true) {
                    totalAmt += parseFloat($(this).data('amount'));
                }
            });
            $('#totalAmount').html(totalAmt.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'));
                }
            });
            $('#totalAmount').html(totalAmt.toFixed(3));
        })

        $('#multi-settle').click(function(e) {
            $('#expenseList').html('');
            $('#collectionList').html('');
            e.preventDefault();
            let selectedItem = [];
            let check = $('.checkbox:checked').length;
            if (check < 1) {
                alert('Please select atleast one item.');
            } else if (check > 101) {
                alert('Do not select more than 100 items');
            } else {
                $(".checkbox:checked").each(function() {
                    selectedItem.push($(this).data('id'));
                });
                $("#selectedItem").val(selectedItem);
                $('#totalSelectedAmount').html($('#totalAmount').html());
                $('#settlingDate').val($("#date").val());
                $.ajax({
                    type: "POST",
                    url: "/admin/get-advance-payment-balance",
                    data: {
                        _token: "{{ csrf_token() }}",
                        "date": $("#date").val(),
                        "user_id": {{ $user->id }},
                        "ids": selectedItem
                    },
                    success: function(response) {
                        if (response.status == "success") {
                            $("#advancePaymentAmount").html(response.balance + " " + response
                                .balance_dr_cr);
                            $('#totalExpenseAmount').html(response.expense_amount);
                            var collectionTotal = response.collectionTotal;
                            var totalAmountToCollected = 0;
                            var collectionPlusAdvance = 0;
                            if (response.balance_dr_cr != 'Cr') {
                                collectionPlusAdvance = parseFloat(response.collectionTotal) +
                                    parseFloat(
                                        response
                                        .balance
                                    );
                                totalAmountToCollected = parseFloat(collectionTotal) + parseFloat(
                                    response.balance) - parseFloat(response
                                    .expense_amount);
                            } else {
                                collectionPlusAdvance = parseFloat(response.collectionTotal) -
                                    parseFloat(
                                        response
                                        .balance
                                    );
                                totalAmountToCollected = parseFloat(collectionTotal) - parseFloat(
                                    response.balance) - parseFloat(response
                                    .expense_amount);
                            }
                            $('#collectionList').append(response.html);
                            $('#expenseList').html(response.html1);
                            $('#collectionPlusAdvance').html(collectionPlusAdvance.toFixed(3));
                            $('#totalAmountToCollected').html(totalAmountToCollected.toFixed(3));
                            $('#amount_collected').val(totalAmountToCollected.toFixed(3));
                            $('#balanceAmount').html(0);
                        }
                    }
                });
                $("#settleCollectionModal").modal('show');
            }
        });

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



        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');
                            $('#totalAmount').html(0);
                            $('#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