@extends('layouts.app')
@section('content')
<div class="page-wrapper">
    <div class="row page-titles">
        <div class="col-md-5 align-self-center">
            <h3 class="text-themecolor">{{ trans('lang.driver')}} {{trans('lang.payment_plural')}}</h3>
        </div>
        <div class="col-md-7 align-self-center">
            <ol class="breadcrumb">
                <li class="breadcrumb-item"><a href="{{url('/dashboard')}}">{{trans('lang.dashboard')}}</a></li>
                <li class="breadcrumb-item active">{{ trans('lang.driver')}} {{trans('lang.payment_plural')}}</li>
            </ol>
        </div>
        <div>
        </div>
    </div>
    <div class="container-fluid">
       <div class="admin-top-section"> 
        <div class="row">
            <div class="col-12">
                <div class="d-flex top-title-section pb-4 justify-content-between">
                    <div class="d-flex top-title-left align-self-center">
                        <span class="icon mr-3"><img src="{{ asset('images/payment.png') }}"></span>
                        <h3 class="mb-0">{{ trans('lang.driver')}} {{trans('lang.payment_plural')}}</h3>
                        <span class="counter ml-3 total_count"></span>
                    </div>
                    <div class="d-flex top-title-right align-self-center">
                        <div class="select-box pl-3">
                          
                        </div>
                    </div>
                </div>
            </div>
        </div> 
        <div class="row ">
            <div class="col-12">
                <div class="card border">
                    <div class="card-body">
                        <div class="row">
                            <div class="col-md-3">
                                <div class="card card-box-with-icon bg--1">
                                    <div class="card-body d-flex justify-content-between align-items-center">
                                       <div class="card-box-with-content">
                                        <h4 class="text-dark-2 mb-1 h4 rest_count">00</h4>
                                        <p class="mb-0 small text-dark-2">{{ trans('lang.dashboard_total_drivers')}}</p>
                                       </div>
                                        <span class="box-icon ab"><img src="{{ asset('images/restaurant_icon.png') }}"></span>
                                    </div>
                                </div>
                            </div>
                            <div class="col-md-3">
                                <div class="card card-box-with-icon bg--2">
                                    <div class="card-body d-flex justify-content-between align-items-center">
                                       <div class="card-box-with-content">
                                        <h4 class="text-dark-2 mb-1 h4 total_payments">00</h4>
                                        <p class="mb-0 small text-dark-2">{{ trans('lang.total_payments')}}</p>
                                       </div>
                                        <span class="box-icon ab"><img src="{{ asset('images/total_earning.png') }}"></span>
                                    </div>
                                </div>
                            </div>
                            <div class="col-md-3">
                                <div class="card card-box-with-icon bg--3">
                                    <div class="card-body d-flex justify-content-between align-items-center">
                                       <div class="card-box-with-content">
                                        <h4 class="text-dark-2 mb-1 h4 total_paid_amounts">00</h4>
                                        <p class="mb-0 small text-dark-2">{{ trans('lang.total_paid_amount')}}</p>
                                       </div>
                                        <span class="box-icon ab"><img src="{{ asset('images/total_payment.png') }}"></span>
                                    </div>
                                </div>
                            </div>
                            <div class="col-md-3">
                                <div class="card card-box-with-icon bg--5">
                                    <div class="card-body d-flex justify-content-between align-items-center">
                                       <div class="card-box-with-content">
                                        <h4 class="text-dark-2 mb-1 h4 total_remaining_amounts">00</h4>
                                        <p class="mb-0 small text-dark-2">{{ trans('lang.remaining_amounts')}}</p>
                                       </div>
                                        <span class="box-icon ab"><img src="{{ asset('images/remaining_payment.png') }}"></span>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
       </div>
       <div class="table-list">
       <div class="row">
           <div class="col-12">
               <div class="card border">
                 <div class="card-header d-flex justify-content-between align-items-center border-0">
                   <div class="card-header-title">
                    <h3 class="text-dark-2 mb-2 h4">{{ trans('lang.driver')}} {{trans('lang.payment_plural')}}</h3>
                    <p class="mb-0 text-dark-2">{{trans('lang.driver_payments_table_text')}}</p>
                   </div>
                   <div class="card-header-right d-flex align-items-center">
                    <div class="card-header-btn mr-3"> 
                        <!-- <a class="btn-primary btn rounded-full" href="{!! route('users.create') !!}"><i class="mdi mdi-plus mr-2"></i>{{trans('lang.user_create')}}</a> -->
                     </div>
                   </div>                
                 </div>
                 <div class="card-body">
                        <div class="table-responsive m-t-10">
                            <table id="driverPaymentTable" class="display nowrap table table-hover table-striped table-bordered table table-striped" cellspacing="0" width="100%">
                                <thead>
                                    <tr>
                                        <th>{{ trans('lang.driver')}}</th>
                                        <th>{{ trans('lang.total_amount')}}</th>
                                        <th>{{trans('lang.paid_amount')}}</th>
                                        <th>{{trans('lang.remaining_amount')}}</th>
                                    </tr>
                                </thead>
                                <tbody id="append_list1">
                                </tbody>
                            </table>
                        </div>
                    </div>
                </div>
            </div>
        </div>
        </div>
    </div>
</div>
@endsection
@section('scripts')
<script>
    var database = firebase.firestore();
    var ref = database.collection('users').where('role', '==', 'driver').orderBy('firstName');
    var currentCurrency = '';
    var currencyAtRight = false;
    var decimal_degits = 0;
    var refCurrency = database.collection('currencies').where('isActive', '==', true);
    refCurrency.get().then(async function (snapshots) {
        var currencyData = snapshots.docs[0].data();
        currentCurrency = currencyData.symbol;
        currencyAtRight = currencyData.symbolAtRight;
        if (currencyData.decimal_degits) {
            decimal_degits = currencyData.decimal_degits;
        }
    });
    $(document).ready(function () {
        $(document.body).on('click', '.redirecttopage', function () {
            var url = $(this).attr('data-url');
            window.location.href = url;
        });
        $(document).on('click', '.dt-button-collection .dt-button', function () {
            $('.dt-button-collection').hide();
            $('.dt-button-background').hide();
        });
        $(document).on('click', function (event) {
            if (!$(event.target).closest('.dt-button-collection, .dt-buttons').length) {
                $('.dt-button-collection').hide();
                $('.dt-button-background').hide();
            }
        });
        var fieldConfig = {
            columns: [
                { key: 'fullName', header: "{{ trans('lang.driver')}}" },
                { key: 'total', header: "{{ trans('lang.total_amount')}}" },
                { key: 'paid', header: "{{trans('lang.paid_amount')}}" },
                { key: 'remaining', header: "{{trans('lang.remaining_amount')}}" },
            ],
            fileName: "{{ trans('lang.driver')}} {{trans('lang.payment_plural')}}",
        };
        const table = $('#driverPaymentTable').DataTable({
            pageLength: 10, // Number of rows per page
            processing: false, // Show processing indicator
            serverSide: true, // Enable server-side processing
            responsive: true,
            ajax: async function (data, callback, settings) {
                const start = data.start;
                const length = data.length;
                const searchValue = data.search.value.toLowerCase();
                const orderColumnIndex = data.order[0].column;
                const orderDirection = data.order[0].dir;
                const orderableColumns = ['fullName', 'totalAmount', 'paidAmount', 'remainingAmount']; // Ensure this matches the actual column names
                const orderByField = orderableColumns[orderColumnIndex]; // Adjust the index to match your table
                if (searchValue.length >= 3 || searchValue.length === 0) {
                    $('#data-table_processing').show();
                }
                await ref.get().then(async function (querySnapshot) {
                    if (querySnapshot.empty) {
                        $('.total_count').text(0);
                        console.error("No data found in Firestore.");
                        $('#data-table_processing').hide(); // Hide loader
                        callback({
                            draw: data.draw,
                            recordsTotal: 0,
                            recordsFiltered: 0,
                            filteredData: [],
                            data: [] // No data
                        });
                        return;
                    }
                    let records = [];
                    let filteredRecords = [];
                    await Promise.all(querySnapshot.docs.map(async (doc) => {
                        let childData = doc.data();
                        var data = await remainingPrice(childData.id);
                        var total = remaining_val = paid_price_val = 0;
                        total = data.total;
                        remaining_val = data.remaining_val;
                        paid_price_val = data.paid_price_val;
                        childData.totalAmount = total;
                        childData.paidAmount = paid_price_val;
                        childData.remainingAmount = remaining_val;
                        if (currencyAtRight) {
                            childData.total = parseFloat(childData.totalAmount).toFixed(decimal_degits) + "" + currentCurrency;
                            childData.paid = parseFloat(childData.paidAmount).toFixed(decimal_degits) + "" + currentCurrency;
                            childData.remaining = parseFloat(childData.remainingAmount).toFixed(decimal_degits) + "" + currentCurrency;
                        } else {
                            childData.total = currentCurrency + "" + parseFloat(childData.totalAmount).toFixed(decimal_degits);
                            childData.paid = currentCurrency + "" + parseFloat(childData.paidAmount).toFixed(decimal_degits);
                            childData.remaining = currentCurrency + "" + parseFloat(childData.remainingAmount).toFixed(decimal_degits);
                        }
                        childData.fullName=childData.firstName+' '+childData.lastName;
                        childData.id = doc.id; // Ensure the document ID is included in the data              
                        if (total != 0) {
                            if (searchValue) {
                                if (
                                    (childData.fullName && childData.fullName.toLowerCase().toString().includes(searchValue)) ||
                                    (total && total.toString().includes(searchValue)) ||
                                    (remaining_val && remaining_val.toString().includes(searchValue)) ||
                                    (paid_price_val && paid_price_val.toString().includes(searchValue))
                                ) {
                                    filteredRecords.push(childData);
                                }
                            } else {
                                filteredRecords.push(childData);
                            }
                        }
                    }));
                    filteredRecords.sort((a, b) => {
                        let aValue = a[orderByField] ? a[orderByField].toString().toLowerCase() : '';
                        let bValue = b[orderByField] ? b[orderByField].toString().toLowerCase() : '';
                        if (orderByField === 'totalAmount') {
                            aValue = a[orderByField] ? parseInt(a[orderByField]) : 0;
                            bValue = b[orderByField] ? parseInt(b[orderByField]) : 0;
                        }
                        if (orderByField === 'paidAmount') {
                            aValue = a[orderByField] ? parseInt(a[orderByField]) : 0;
                            bValue = b[orderByField] ? parseInt(b[orderByField]) : 0;
                        }
                        if (orderByField === 'remainingAmount') {
                            aValue = a[orderByField] ? parseInt(a[orderByField]) : 0;
                            bValue = b[orderByField] ? parseInt(b[orderByField]) : 0;
                        }
                        if (orderDirection === 'asc') {
                            return (aValue > bValue) ? 1 : -1;
                        } else {
                            return (aValue < bValue) ? 1 : -1;
                        }
                    });
                    const totalRecords = filteredRecords.length;
                    $('.total_count').text(totalRecords);
                    let total_payments = 00;
                    let total_paid_amounts = 00;
                    let total_remaining_amounts = 00; 
                    filteredRecords.forEach((childData) => {
                        if (childData && Math.abs(childData.totalAmount) != 0) {
                            total_payments += parseFloat(childData.totalAmount);
                            total_paid_amounts += parseFloat(childData.paidAmount);
                            total_remaining_amounts += parseFloat(childData.remainingAmount);
                        }
                    });
                    if (currencyAtRight) {
                        total_payments = parseFloat(total_payments).toFixed(decimal_degits) + "" + currentCurrency;
                        total_paid_amounts = parseFloat(total_paid_amounts).toFixed(decimal_degits) + "" + currentCurrency;
                        total_remaining_amounts = parseFloat(total_remaining_amounts).toFixed(decimal_degits) + "" + currentCurrency;
                    } else {
                        total_payments = currentCurrency + "" + parseFloat(total_payments).toFixed(decimal_degits);
                        total_paid_amounts = currentCurrency + "" + parseFloat(total_paid_amounts).toFixed(decimal_degits);
                        total_remaining_amounts = currentCurrency + "" + parseFloat(total_remaining_amounts).toFixed(decimal_degits);
                    }
                    $('.rest_count').text(totalRecords);
                    $('.total_payments').text(total_payments);
                    $('.total_paid_amounts').text(total_paid_amounts);
                    $('.total_remaining_amounts').text(total_remaining_amounts);
                    const paginatedRecords = filteredRecords.slice(start, start + length);
                    await Promise.all(paginatedRecords.map(async (childData) => {
                        var getData = await buildHTML(childData);
                        records.push(getData);
                    }));
                    $('#data-table_processing').hide(); // Hide loader
                    callback({
                        draw: data.draw,
                        recordsTotal: totalRecords, // Total number of records in Firestore
                        recordsFiltered: totalRecords, // Number of records after filtering (if any)
                        filteredData: filteredRecords,
                        data: records // The actual data to display in the table
                    });
                }).catch(function (error) {
                    console.error("Error fetching data from Firestore:", error);
                    $('#data-table_processing').hide(); // Hide loader
                    callback({
                        draw: data.draw,
                        recordsTotal: 0,
                        recordsFiltered: 0,
                        filteredData: [],
                        data: [] // No data due to error
                    });
                });
            },
            order: [[0, 'asc']],
            columnDefs: [
                {
                    targets: [1, 2, 3],
                    type: 'num-fmt',
                    render: function (data, type, row, meta) {
                        if (type === 'display') {
                            return data;
                        }
                        return parseFloat(data.replace(/[^0-9.-]+/g, ""));
                    }
                },
            ],
            "language": datatableLang,
            dom: 'lfrtipB',
            buttons: [
                {
                    extend: 'collection',
                    text: '<i class="mdi mdi-cloud-download"></i> {{trans("lang.export_as")}}',
                    className: 'btn btn-info',
                    buttons: [
                        {
                            extend: 'excelHtml5',
                            text: '{{trans("lang.export_excel")}}',
                            action: function (e, dt, button, config) {
                                exportData(dt, 'excel',fieldConfig);
                            }
                        },
                        {
                            extend: 'pdfHtml5',
                            text: '{{trans("lang.export_pdf")}}',
                            action: function (e, dt, button, config) {
                                exportData(dt, 'pdf',fieldConfig);
                            }
                        },   
                        {
                            extend: 'csvHtml5',
                            text: '{{trans("lang.export_csv")}}',
                            action: function (e, dt, button, config) {
                                exportData(dt, 'csv',fieldConfig);
                            }
                        }
                    ]
                }
            ],
            initComplete: function() {
                $(".dataTables_filter").append($(".dt-buttons").detach());
                $('.dataTables_filter input').attr('placeholder', '{{trans("lang.search_here")}}').attr('autocomplete','new-password').val('');
                $('.dataTables_filter label').contents().filter(function() {
                    return this.nodeType === 3; 
                }).remove();
            }
        });
        function debounce(func, wait) {
            let timeout;
            const context = this;
            return function (...args) {
                clearTimeout(timeout);
                timeout = setTimeout(() => func.apply(context, args), wait);
            };
        }
        $('#search-input').on('input', debounce(function () {
            const searchValue = $(this).val();
            if (searchValue.length >= 3) {
                $('#data-table_processing').show();
                table.search(searchValue).draw();
            } else if (searchValue.length === 0) {
                $('#data-table_processing').show();
                table.search('').draw();
            }
        }, 300));
    });
    async function buildHTML(val) {
        var html = [];
        newdate = '';
        var id = val.id;
        var route1 = '{{route("drivers.view", ":id")}}';
        route1 = route1.replace(':id', id);
        var data = {};
        data.total = val.totalAmount;
        data.paid_price_val = val.paidAmount;
        data.remaining_val = val.remainingAmount;
        var total = Math.abs(val.totalAmount);
        var remaining_val = Math.abs(val.remainingAmount);
        var paid_price_val = Math.abs(val.paidAmount);
        if (Math.abs(data.total) != 0) {
            html.push('<a href="' + route1 + '" class="redirecttopage">' + val.firstName + ' ' + val.lastName + '</a>');
            var total_class = 'text-green';
            var paid_price_val_class = 'text-green';
            var remaining_val_class = 'text-green';
            if (currencyAtRight) {
                if (data.total < 0) {
                    total_class = 'text-red';
                    total = Math.abs(data.total);
                    data.total = '(-' + parseFloat(total).toFixed(decimal_degits) + "" + currentCurrency + ')';
                } else {
                    data.total = parseFloat(data.total).toFixed(decimal_degits) + "" + currentCurrency;
                }
                if (data.paid_price_val < 0) {
                    paid_price_val_class = 'text-red';
                    paid_price_val = Math.abs(data.paid_price_val);
                    data.paid_price_val = '(-' + parseFloat(paid_price_val).toFixed(decimal_degits) + "" + currentCurrency + ')';
                } else {
                    data.paid_price_val = parseFloat(data.paid_price_val).toFixed(decimal_degits) + "" + currentCurrency;
                }
                if (data.remaining_val < 0) {
                    remaining_val_class = 'text-red';
                    remaining_val = Math.abs(data.remaining_val);
                    data.remaining_val = '(-' + parseFloat(remaining_val).toFixed(decimal_degits) + "" + currentCurrency + ')';
                } else {
                    data.remaining_val = parseFloat(data.remaining_val).toFixed(decimal_degits) + "" + currentCurrency;
                }
            } else {
                if (data.total < 0) {
                    total_class = 'text-red';
                    total = Math.abs(data.total);
                    data.total = '(-' + currentCurrency + "" + parseFloat(total).toFixed(decimal_degits) + ')';
                } else {
                    data.total = currentCurrency + "" + parseFloat(data.total).toFixed(decimal_degits);
                }
                if (data.paid_price_val < 0) {
                    paid_price_val_class = 'text-red';
                    paid_price_val = Math.abs(data.paid_price_val);
                    data.paid_price_val = '(-' + currentCurrency + "" + parseFloat(paid_price_val).toFixed(decimal_degits) + ')';
                } else {
                    data.paid_price_val = currentCurrency + "" + parseFloat(data.paid_price_val).toFixed(decimal_degits);
                }
                if (data.remaining_val < 0) {
                    remaining_val_class = 'text-red';
                    remaining_val = Math.abs(data.remaining_val);
                    data.remaining_val = '(-' + currentCurrency + "" + parseFloat(remaining_val).toFixed(decimal_degits) + ')';
                } else {
                    data.remaining_val = currentCurrency + "" + parseFloat(data.remaining_val).toFixed(decimal_degits);
                }
            }
            html.push('<span class="' + total_class + '">' + data.total + '</span>');
            html.push('<span class="' + paid_price_val_class + '">' + data.paid_price_val + '</span>');
            html.push('<span class="' + remaining_val_class + '">' + data.remaining_val + '</span>');
        }
        return html;
    }
    async function remainingPrice(driverID) {
        var paid_price = 0;
        var total_price = 0;
        var remaining = 0;
        var data = {};
        await database.collection('driver_payouts').where('driverID', '==', driverID).get().then(async function (payoutSnapshots) {
            payoutSnapshots.docs.forEach((payout) => {
                var payoutData = payout.data();
                paid_price = parseFloat(paid_price) + parseFloat(payoutData.amount);
            });
            await database.collection('users').where('id', '==', driverID).get().then(async function (driverSnapshots) {
                var driver = [];
                var wallet_amount = 0;
                if (driverSnapshots.docs.length) {
                    driver = driverSnapshots.docs[0].data();
                    if (isNaN(driver.wallet_amount) || driver.wallet_amount == undefined) {
                        wallet_amount = 0;
                    } else {
                        wallet_amount = driver.wallet_amount;
                    }
                }
                remaining = wallet_amount;
                total_price = wallet_amount + paid_price;
                if (Number.isNaN(paid_price)) {
                    paid_price = 0;
                }
                if (Number.isNaN(total_price)) {
                    total_price = 0;
                }
                if (Number.isNaN(remaining)) {
                    remaining = 0;
                }
                data = {
                    'total': total_price,
                    'paid_price_val': paid_price,
                    'remaining_val': remaining,
                };
            });
        });
        return data;
    }
</script>
@endsection