@php
    $layout = auth('employee')->check()?'employee':'admin';
@endphp
@extends('layout.'.$layout.'.master')

<style>
    .booking_color {
        color: blue;
    }

    .payment_color {
        color: green;
    }

    .expense_color {
        color: red;
    }
</style>

@section('content')
    <!-- Main Content -->
    <div class="main-content">
        <section class="section">
            <div class="section-body">

                {{-- TOTAL --}}
                <div class="row text-center">
                    @if (
                        !(request()->total_expense ||
                            request()->total_profit ||
                            request()->receivable ||
                            request()->receivable_finished_payment ||
                            request()->outsource_pending_payment ||
                            request()->outsource_profit
                        ))
                        <div class="col-md-3">
                            <div class="card bg-primary text-white shadow">
                                <div class="card-body">
                                    <i data-feather="dollar-sign"></i>
                                    <h4 class="card-title">{{ __('messages.total_debit') }}</h4>
                                    <p class="card-text">
                                        @if (request('outsource_vehicle_amount'))
                                            {{ $bookings->sum('outsource_purchase') }}
                                        @else
                                            {{ $bookings->sum('debit') }}
                                        @endif
                                    </p>
                                </div>
                            </div>
                        </div>
                    @endif

                    @if (
                        !(request()->total_sale ||
                            request()->income ||
                            request()->total_expense ||
                            request()->receivable ||
                            request()->receivable_finished_payment ||
                            request()->outsource_vehicle_amount ||
                            request()->outsource_pending_payment ||
                            request()->on_road_total_debit
                        ))
                        <div class="col-md-3">
                            <div class="card bg-success text-white shadow">
                                <div class="card-body">
                                    <i data-feather="dollar-sign"></i>
                                    <h4 class="card-title">{{ __('messages.total_credit') }}</h4>
                                    <p class="card-text">
                                        @if (request('total_profit'))
                                            {{ $payments->sum('amount') - $expense->sum('expense') }}
                                        @elseif (request('outsource_profit') || request('driver'))
                                            {{ $bookings->sum('debit') - $bookings->sum('outsource_purchase') }}
                                        @else
                                            {{ $payments->sum('amount') }}
                                        @endif
                                    </p>
                                </div>
                            </div>
                        </div>
                    @endif

                    @if (
                        !(request()->total_sale ||
                            request()->income ||
                            request()->total_profit ||
                            request()->receivable ||
                            request()->receivable_finished_payment ||
                            request()->outsource_vehicle_amount ||
                            request()->outsource_pending_payment ||
                            request()->outsource_profit ||
                            request()->on_road_total_debit
                        ))
                        <div class="col-md-3">
                            <div class="card bg-danger text-white shadow">
                                <div class="card-body">
                                    <i data-feather="dollar-sign"></i>
                                    <h4 class="card-title">{{ __('messages.total_expense') }}</h4>
                                    <p class="card-text">{{ $expense->sum('expense') }}</p>
                                </div>
                            </div>
                        </div>
                    @endif

                    @if (
                        !(request()->total_sale ||
                            request()->income ||
                            request()->total_expense ||
                            request()->total_profit ||
                            request()->outsource_vehicle_amount ||
                            request()->outsource_profit ||
                            request()->on_road_total_debit
                        ))
                        <div class="col-md-3">
                            <div class="card bg-warning text-white shadow">
                                <div class="card-body">
                                    <i data-feather="dollar-sign"></i>
                                    <h4 class="card-title">{{ __('messages.balance') }}</h4>
                                    <p class="card-text">
                                        @if (request()->receivable)
                                            {{ $bookings->sum('debit') - $payments->sum('amount') }}
                                        @elseif (request()->receivable_finished_payment)
                                            {{ $bookings->sum('debit') - $payments->sum('amount') }}
                                        @elseif (request()->outsource_pending_payment)
                                            {{ $bookings->sum('outsource_purchase') - $payments->sum('outsource_credit') }}
                                        @else
                                            {{ $bookings->sum('debit') + $expense->sum('expense') - $payments->sum('amount') }}
                                        @endif
                                    </p>
                                </div>
                            </div>
                        </div>
                    @endif
                </div>

                {{-- GENERAL LEDGER --}}
                <div class="row">
                    <div class="col-12">
                        <div class="card">
                            <div class="card-header">
                                <h4>{{ __('messages.general_ledger') }}</h4>

                                <form id="filterForm" method="GET" action="{{ route('general_ledger.index') }}"
                                    class="form-inline">

                                    {{-- FILTER BY PARTNER --}}
                                    <div class="form-group mx-sm-3 mb-2">
                                        <label for="partnerFilter" class="sr-only">{{ __('messages.partner') }}</label>
                                        <select name="partner" id="partnerFilter" class="form-control"
                                            onchange="this.form.submit()">
                                            <option value="" {{ request('partner') ? '' : 'selected' }}>
                                                {{ __('messages.filter_by_partner') }}</option>
                                            @forelse ($partners as $partner)
                                                <option value="{{ $partner->id }}"
                                                    {{ request('partner') == $partner->id ? 'selected' : '' }}>
                                                    {{ $partner->fname . ' ' . $partner->lname }}</option>
                                            @empty
                                                <option value="">{{ __('messages.no_partners_available') }}</option>
                                            @endforelse
                                        </select>
                                    </div>

                                    {{-- FILTER BY DRIVER --}}
                                    <div class="form-group mx-sm-3 mb-2">
                                        <label for="driverFilter" class="sr-only">{{ __('messages.driver') }}</label>
                                        <select name="driver" id="driverFilter" class="form-control"
                                            onchange="this.form.submit()">
                                            <option value="" {{ request('driver') ? '' : 'selected' }}>
                                                {{ __('messages.filter_by_driver') }}</option>
                                            @forelse ($drivers as $driver)
                                                <option value="{{ $driver->id }}"
                                                    {{ request('driver') == $driver->id ? 'selected' : '' }}>
                                                    {{ $driver->fname . ' ' . $driver->lname }}</option>
                                            @empty
                                                <option value="">{{ __('messages.no_drivers_available') }}</option>
                                            @endforelse
                                        </select>
                                    </div>

                                    {{-- FILTER BY VEHICLE --}}
                                    <div class="form-group mx-sm-3 mb-2">
                                        <label for="vehicleFilter" class="sr-only">{{ __('messages.vehicle') }}</label>
                                        <select name="vehicle" id="vehicleFilter" class="form-control"
                                            onchange="this.form.submit()">
                                            <option value="" {{ request('vehicle') ? '' : 'selected' }}>
                                                {{ __('messages.filter_by_vehicle') }}</option>
                                            @forelse ($vehicles as $vehicle)
                                                <option value="{{ $vehicle->id }}"
                                                    {{ request('vehicle') == $vehicle->id ? 'selected' : '' }}>
                                                    {{ $vehicle->name }}</option>
                                            @empty
                                                <option value="">{{ __('messages.no_vehicles_available') }}</option>
                                            @endforelse
                                        </select>
                                    </div>

                                    <div class="form-group mx-sm-3 mb-2">
                                        @if (request('partner') || request('driver') || request('vehicle'))
                                            <a href="{{ route('general_ledger.index') }}"
                                                class="btn btn-secondary mb-2 reset-button">{{ __('messages.reset_filter') }}</a>
                                        @endif

                                        {{-- Export --}}
                                        <a href="{{ route('ledger.export', request()->query()) }}"
                                            class="btn btn-success mb-2">{{ __('messages.export_to_excel') }}</a>
                                    </div>


                                </form>
                            </div>

                            <div class="card-body">
                                <div class="table-responsive">
                                    <div>
                                        <h4>Total Debit:<span id="dt_debit"></span></h4>
                                        <h4>Total Credit:<span id="dt_credit"></span></h4>
                                    </div>
                                    <table class="table table-striped" id="table-1">
                                        <thead>
                                            <tr>
                                                <th class="text-center">#</th>
                                                <th>{{ __('messages.booking_type') }}</th>
                                                <th>{{ __('messages.travel_date') }}</th>
                                                <th>{{ __('messages.partner') }}</th>
                                                <th>{{ __('messages.passenger') }}</th>
                                                <th>{{ __('messages.employee') }}</th>
                                                <th>{{ __('messages.vehicle') }}</th>
                                                <th>{{ __('messages.location') }}</th>
                                                <th id="debit">{{ __('messages.debit') }}</th>
                                                <th>{{ __('messages.credit') }}</th>
                                                <th>{{ __('messages.account') }}</th>
                                                <th>{{ __('messages.expense_type') }}</th>
                                                <th>{{ __('messages.expense_description') }}</th>
                                                <th>{{ __('messages.expense') }}</th>
                                                <th>{{ __('messages.created_at') }}</th>
                                                <th>{{ __('messages.status') }}</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            @if (!request()->total_expense)
                                                @forelse ($bookings as $key => $booking)
                                                    {{-- Booking --}}
                                                    @if ($booking->getTable() == 'bookings')    
                                                        <tr>
                                                            <td>{{ $key + 1 }}</td>
                                                            <td>{{ $booking->on_road ? __('messages.on_road') : ($booking->outsource ? __('messages.outsource') : __('messages.regular')) }}
                                                            </td>
                                                            <td>{{ $booking->travel_date }}</td>
                                                            <td>{{ $booking->partner ? $booking->partner->company : __('messages.no_partner_selected') }}
                                                            </td>
                                                            <td>{{ $booking->passenger_name ?? __('messages.na') }}</td>
                                                            <td>{{ $booking->employee ? $booking->employee->fname . ' ' . $booking->employee->lname : __('messages.no_driver_selected') }}
                                                            </td>
                                                            <td>{{ $booking->vehicle ? $booking->vehicle->name : __('messages.no_vehicle_selected') }}
                                                            </td>
                                                            <td>{{ $booking->pickup_location . ' - ' . $booking->dropoff_location }}
                                                            </td>
                                                            <td style="color: purple; font-weight:bold;">
                                                                {{ $booking->debit }}</td>
                                                            @if ($booking->on_road)
                                                                <td style="color: green; font-weight:bold;">
                                                                    {{ $booking->onRoadPayment ? $booking->onRoadPayment->amount : __('messages.no_payment_added_yet') }}
                                                                    <small>{{ __('messages.on_road_credit') }}</small>
                                                                </td>
                                                            @elseif ($booking->outsource)
                                                                <td style="color: green; font-weight:bold;">
                                                                    {{ $booking->outsource_purchase }}
                                                                    <small>{{ __('messages.outsource_purchase') }}</small>
                                                                </td>
                                                            @else
                                                                <td class="booking_color">{{ __('-') }}</td>
                                                            @endif
                                                            @if ($booking->on_road)
                                                                <td>
                                                                    {{ $booking->onRoadPayment ? $booking->onRoadPayment->account->title . '-' . $booking->onRoadPayment->account->type : __('messages.no_payment_added_yet') }}
                                                                </td>
                                                            @elseif ($booking->outsource)
                                                                <td>{{ __('messages.outsource_account') }}</td>
                                                            @else
                                                                <td class="booking_color">{{ __('-') }}</td>
                                                            @endif
                                                            <td class="booking_color">{{ __('-') }}</td>
                                                            <td class="booking_color">{{ __('-') }}</td>
                                                            <td class="booking_color">{{ __('-') }}</td>
                                                            <td>{{ $booking->created_at->format('d-m-Y') }}</td>
                                                            <td>
                                                                <div
                                                                    class="badge badge-shadow {{ $booking->status == 'pending' ? 'badge-warning' : ($booking->status == 'finished' ? 'badge-success' : ($booking->status == 'on_going' ? 'badge-primary' : ($booking->status == 'cancelled' ? 'badge-danger' : ''))) }}">
                                                                    {{ strtoupper($booking->status) }}
                                                                </div>
                                                            </td>
                                                        </tr>
                                                    @endif
                                                @empty
                                                    <tr>
                                                        <td colspan="14" class="text-center">
                                                            {{ __('messages.no_data_available') }}</td>
                                                    </tr>
                                                @endforelse
                                            @endif


                                            {{-- Expense --}}
                                            @if (
                                                !(request()->total_sale ||
                                                    request()->income ||
                                                    request()->receivable ||
                                                    request()->receivable_finished_payment ||
                                                    request()->outsource_vehicle_amount ||
                                                    request()->outsource_pending_payment ||
                                                    request()->outsource_profit ||
                                                    request()->on_road_total_debit
                                                ))
                                                @foreach ($expense as $exp)
                                                    <tr>
                                                        <td>{{ $key + 1 }}</td>
                                                        <td class="expense_color">{{ __('messages.expense') }}</td>
                                                        <td>{{ $exp->created_at->format('d-m-Y') }}</td>
                                                        <td>{{ $exp->partner ? $exp->partner->company : __('messages.no_partner_selected') }}
                                                        </td>
                                                        <td class="expense_color">{{ __('-') }}</td>
                                                        <td>{{ $exp->employee ? $exp->employee->fname . ' ' . $exp->employee->lname . ' - ' . $exp->employee->type : '-' }}
                                                        </td>
                                                        <td>{{ $exp->vehicle ? $exp->vehicle->name . $exp->vehicle->type : '-' }}
                                                        </td>
                                                        <td class="expense_color">{{ __('-') }}</td>
                                                        <td class="expense_color">{{ __('-') }}</td>
                                                        <td class="expense_color">{{ __('-') }}</td>
                                                        <td>{{ $exp->account->title . '-' . $exp->account->type }}</td>
                                                        <td>{{ $exp->expenseType->type }}</td>
                                                        <td>{{ $exp->description }}</td>
                                                        <td style="color: red; font-weight:bold;">{{ $exp->expense }}</td>
                                                        <td>{{ $exp->created_at->format('d-m-Y') }}</td>
                                                        <td>
                                                            <div
                                                                class="badge badge-shadow {{ $exp->status == 'pending' ? 'badge-warning' : ($exp->status == 'finished' ? 'badge-success' : ($exp->status == 'on_going' ? 'badge-primary' : ($exp->status == 'cancelled' ? 'badge-danger' : ''))) }}">
                                                                {{ strtoupper($exp->status) }}
                                                            </div>
                                                        </td>
                                                    </tr>
                                                @endforeach
                                            @endif

                                        </tbody>
                                    </table>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </section>
    </div>
    <script>
        document.addEventListener('DOMContentLoaded', function() {
            const filterForm = document.getElementById('filterForm');
            const paramsToPreserve = ['total_sale', 'total_cash', 'outsource_vehicle_amount', 'income',
                'total_bank', 'outsource_pending_payment', 'total_expense', 'receivable', 'outsource_profit',
                'total_profit', 'receivable_finished_payment', 'on_road_total_debit'
            ]; // Add more as needed

            filterForm.addEventListener('change', function() {
                const urlParams = new URLSearchParams(window.location.search);
                let redirectParams = new URLSearchParams();

                // Loop through each parameter to check if it exists in the current URL
                paramsToPreserve.forEach(param => {
                    if (urlParams.has(param)) {
                        redirectParams.set(param, urlParams.get(param));
                    }
                });

                // Append the filter form parameters (like partner, driver, vehicle) to the URL
                new FormData(filterForm).forEach((value, key) => {
                    if (value) {
                        redirectParams.set(key, value);
                    }
                });

                // Redirect to the updated URL
                window.location.href = filterForm.action.split('?')[0] + '?' + redirectParams.toString();
            });

            // Reset button logic
            const resetButton = document.querySelector('.reset-button');
            if (resetButton) {
                resetButton.addEventListener('click', function(e) {
                    e.preventDefault();
                    const urlParams = new URLSearchParams(window.location.search);
                    let hasPreservedParam = false;

                    // Check if URL has any of the parameters to preserve
                    paramsToPreserve.forEach(param => {
                        if (urlParams.has(param)) {
                            hasPreservedParam = true;
                        }
                    });

                    if (hasPreservedParam) {
                        let resetParams = new URLSearchParams();

                        // Preserve the parameters
                        paramsToPreserve.forEach(param => {
                            if (urlParams.has(param)) {
                                resetParams.set(param, urlParams.get(param));
                            }
                        });

                        // Redirect to the URL with only preserved parameters
                        window.location.href = filterForm.action.split('?')[0] + '?' + resetParams
                        .toString();
                    } else {
                        // If no parameters to preserve, just reset form and reload
                        filterForm.reset();
                        window.location.href = filterForm.action.split('?')[0];
                    }
                });
            }

            // Destroy any existing DataTable instance (if you're reinitializing)
            $('#table-1').DataTable().destroy();

            // Reinitialize the DataTable
            let table = $('#table-1').DataTable({
                // Your DataTable options
            });

            // Function to update the sum of a column
            function updateSum() {
                let debit = table.column(8, { search: 'applied' }).data()
                    .reduce((a, b) => {
                        // Parse the values to float safely, and ignore invalid data
                        let parsedA = parseFloat(a) || 0;
                        let parsedB = parseFloat(b) || 0;
                        return parsedA + parsedB;
                    }, 0);
                
                let credit = table.column(9, { search: 'applied' }).data()
                .reduce((a, b) => {
                    // Parse the values to float safely, and ignore invalid data
                    let parsedA = parseFloat(a) || 0;
                    let parsedB = parseFloat(b) || 0;
                    return parsedA + parsedB;
                }, 0);
                
                // Display the result in the footer, with a default of 0 if NaN
                $('#dt_debit').html(isNaN(debit) ? '0.00' : debit.toFixed(2));
                $('#dt_credit').html(isNaN(credit) ? '0.00' : credit.toFixed(2));
            }

            // Run the updateSum function when the table is drawn or filtered
            table.on('draw.dt search.dt', function() {
                updateSum();
            });

            // Run the updateSum function on initial load
            updateSum();
        });
    </script>
@endsection