@extends('layouts.app')

@section('title', __('dashboard.Transactions'))
@section('page_heading', __('dashboard.Transactions'))

@section('breadcrumb')
    <li class="bc-item">
        <a href="{{ route('dashboard.home') }}">{{ __('dashboard.Home') }}</a>
    </li>
    <li class="bc-item active">{{ __('dashboard.Transactions') }}</li>
@endsection

@section('content')
<div class="statistics-page">
@include('dashboard.statistics.partials.nav')

    <div class="app-card">
        <div class="app-card__header">
            <h3 class="app-card__title">{{ __('dashboard.Transactions Statistics') }}</h3>
            <div class="app-card__toolbar">
                {{-- Form for filtering --}}
                <form action="{{ route('dashboard.statistics.treasury') }}" method="GET" class="flex items-center">

                    {{-- Single Date Input --}}
                    <div class="me-2">
                        <label for="date" class="app-label text-sm">{{ __('dashboard.Date') }}</label>
                        <input type="date" name="date" id="date" value="{{ $startDate->format('Y-m-d') }}" class="app-input app-input--sm">
                    </div>

                    {{-- Date Range Inputs --}}
                    <div class="me-2">
                        <label for="start_date" class="app-label text-sm">{{ __('dashboard.Start Date') }}</label>
                        <input type="date" name="start_date" id="start_date" value="{{ request('start_date') }}" class="app-input app-input--sm">
                    </div>
                    <div class="me-2">
                        <label for="end_date" class="app-label text-sm">{{ __('dashboard.End Date') }}</label>
                        <input type="date" name="end_date" id="end_date" value="{{ request('end_date') }}" class="app-input app-input--sm">
                    </div>

                    {{-- Transaction Type Dropdown --}}
                    <select name="transaction_type" class="app-input app-select app-input--sm me-2" style="width: auto;">
                        <option value="all" @selected($transactionType == 'all')>{{ __('dashboard.All') }}</option>
                        <option value="sales" @selected($transactionType == 'sales')>{{ __('dashboard.Sales') }}</option>
                        <option value="reservations" @selected($transactionType == 'reservations')>{{ __('dashboard.Reservations') }}</option>
                    </select>

                    {{-- Admin Dropdown --}}
                    <select name="admin_id" class="app-input app-select app-input--sm me-2" style="width: auto;">
                        <option value="">{{ __('dashboard.All Moderators') }}</option>
                        @foreach($admins as $admin)
                            <option value="{{ $admin->id }}" @selected($adminId == $admin->id)>
                                {{ $admin->name }}
                            </option>
                        @endforeach
                    </select>

                    <button type="submit" class="app-btn app-btn--sm app-btn--primary me-2">{{ __('dashboard.Filter') }}</button>
                    <a href="{{ route('dashboard.statistics.treasury.export', request()->all()) }}" class="app-btn app-btn--sm app-btn--success">{{ __('dashboard.Export') }}</a>
                </form>
            </div>
        </div>
        <div class="app-card__body">

          {{-- Overall Summary --}}
            <div class="app-grid mb-5">
                <div class="md:col-span-4">
                    <div class="app-card border border-blue-200 shadow-sm">
                      <div class="app-card__body">
                        <h5 class="app-card__title text-blue-600 dark:text-blue-400">{{ __('dashboard.Total Sales') }}</h5>
                        <p class="app-card__text font-black text-xl">
                            {{-- Use the collection method sum() only if $sales is not empty --}}
                            {{ number_format($sales ? $sales->sum('final_total') : 0, 2) }}
                        </p>
                      </div>
                    </div>
                </div>
                  <div class="md:col-span-4">
                    <div class="app-card border border-emerald-200 shadow-sm">
                        <div class="app-card__body">
                        <h5 class="app-card__title text-emerald-600 dark:text-emerald-400">{{ __('dashboard.Total Reservation Deposits') }}</h5>
                        <p class="app-card__text font-black text-xl">
                            {{-- اجمالي المقدم --}}
                            {{ number_format($reservationsDeposits ? $reservationsDeposits->sum('deposit') : 0, 2) }}
                        </p>
                        </div>
                    </div>
                  </div>
                  <div class="md:col-span-4">
                    <div class="app-card border border-blue-200 shadow-sm">
                        <div class="app-card__body">
                        <h5 class="app-card__title text-sky-600 dark:text-sky-400">{{ __('dashboard.Total Reservation Final Payments') }}</h5>
                        <p class="app-card__text font-black text-xl">
                            {{-- اجمالي المتبقي --}}
                            {{ number_format($reservationsFinalPayments->sum(function($reservation) {
                                return $reservation->price - $reservation->deposit;
                            }), 2) }}
                        </p>
                        </div>
                    </div>
                  </div>
            </div>



            {{-- Payment Method Summary (Aggregated) --}}
            <div class="app-grid mb-5">
                @php
                    $paymentMethodsSummary = [];

                    // Aggregate sales
                    foreach ($sales as $sale) {
                         $method = __("dashboard." . ($sale->payment_method ?: 'none'));
                        if (!isset($paymentMethodsSummary[$method])) {
                            $paymentMethodsSummary[$method] = 0;
                        }
                        $paymentMethodsSummary[$method] += $sale->final_total;
                    }

                    // Aggregate reservation deposits
                    foreach ($reservationsDeposits as $reservation) {
                         $method = __("dashboard." . ($reservation->payment_method ?: 'none'));
                        if (!isset($paymentMethodsSummary[$method])) {
                            $paymentMethodsSummary[$method] = 0;
                        }
                        $paymentMethodsSummary[$method] += $reservation->deposit;
                    }

                    // Aggregate reservation final payments
                    foreach ($reservationsFinalPayments as $reservation) {
                         $method = __("dashboard." . ($reservation->final_payment_method ?: 'none'));
                        if (!isset($paymentMethodsSummary[$method])) {
                            $paymentMethodsSummary[$method] = 0;
                        }
                         $paymentMethodsSummary[$method] += ($reservation->price - $reservation->deposit);

                    }


                    // Sort by amount descending, only if the array is not empty
                    if (!empty($paymentMethodsSummary)) {
                        arsort($paymentMethodsSummary);
                    }
                @endphp

                <div class="md:col-span-6">
                    <div class="app-card shadow-sm">
                        <div class="app-card__body">
                            <h5 class="app-card__title">{{ __('dashboard.Payment Methods Summary') }}</h5>
                            <ul class="grid gap-2 m-0 ps-0">
                                @forelse ($paymentMethodsSummary as $method => $amount)
                                    <li class="app-list-item flex justify-between items-center">
                                        {{ $method }}:
                                        <span class="app-badge app-badge--primary">{{ number_format($amount, 2) }}</span>
                                    </li>
                                @empty
                                    <li class="app-list-item">{{ __('dashboard.No data available') }}</li>
                                @endforelse
                            </ul>
                        </div>
                    </div>
                </div>
            </div>

            @if($transactionType == 'all' || $transactionType == 'sales')
                <h4 class="mb-3">{{ __('dashboard.Sales') }}</h4>
                @if($sales->isEmpty())
                    <p>{{ __('dashboard.No sales data available.') }}</p>
                @else
                    <div class="app-table-wrap">
                        <table class="app-table align-middle">
                            <thead>
                                <tr class="font-bold text-slate-500 dark:text-slate-400">
                                    <th>{{ __('dashboard.Date') }}</th>
                                    <th>{{ __('dashboard.Sale ID') }}</th>
                                    <th>{{ __('dashboard.Total') }}</th>
                                    <th>{{ __('dashboard.Payment Method') }}</th>
                                    <th>{{ __('dashboard.Reference') }}</th>
                                    <th>{{ __('dashboard.Created By') }}</th>
                                </tr>
                            </thead>
                            <tbody>
                            @php $totalSales = 0; @endphp
                            @foreach($sales as $sale)
                                <tr>
                                    <td>{{ $sale->created_at->format('Y-m-d') }}</td>
                                    <td>
                                        <a href="{{ route('dashboard.sales.show', $sale->id) }}">
                                            {{ $sale->id }}
                                        </a>
                                    </td>
                                    <td>{{ $sale->final_total }}</td>
                                     <td>{{ __("dashboard." . ($sale->payment_method ?: 'none')) }}</td>
                                    <td>{{ $sale->payment_reference ?? '-' }}</td>
                                    <td>{{ $sale->creator ? $sale->creator->name : '-' }}</td>
                                </tr>
                                @php $totalSales += $sale->final_total; @endphp
                            @endforeach
                            </tbody>
                            <tfoot>
                                <tr class="font-bold text-slate-500 dark:text-slate-400 bg-slate-50">
                                    <td colspan="2">{{ __('dashboard.Total') }}</td>
                                    <td>{{ number_format($totalSales, 2) }}</td>
                                    <td colspan="3"></td> {{-- Empty cells for alignment --}}
                                </tr>

                                {{-- Payment Method Summary for Sales --}}
                                @if(!empty($salesPaymentSummary))
                                <tr>
                                    <td colspan="6">
                                        <h6 class="mt-2">{{__("dashboard.Payment Methods Summary")}}:</h6>
                                        <ul class="flex flex-wrap gap-3">
                                            @foreach($salesPaymentSummary as $method => $amount)
                                             <li class="text-sm">
                                                <strong>{{ $method }}:</strong> {{ number_format($amount, 2) }}
                                             </li>
                                            @endforeach
                                        </ul>
                                    </td>
                                </tr>
                                @endif
                            </tfoot>
                        </table>
                    </div>
                @endif
            @endif


            @if($transactionType == 'all' || $transactionType == 'reservations')
                <h4 class="mb-3">{{ __('dashboard.Reservation Deposits') }}</h4>
                @if($reservationsDeposits->isEmpty())
                    <p>{{ __('dashboard.No reservation deposit data available.') }}</p>
                @else
                    <div class="app-table-wrap">
                        <table class="app-table align-middle">
                            <thead>
                                <tr class="font-bold text-slate-500 dark:text-slate-400">
                                    <th>{{ __('dashboard.Date') }}</th>
                                    <th>{{ __('dashboard.Reservation ID') }}</th>
                                    <th>{{ __('dashboard.Deposit') }}</th>
                                    <th>{{ __('dashboard.Payment Method') }}</th>
                                    <th>{{ __('dashboard.Reference') }}</th>
                                    <th>{{ __('dashboard.Created By') }}</th>
                                </tr>
                            </thead>
                            <tbody>
                            @php $totalDeposits = 0; @endphp
                            @foreach($reservationsDeposits as $reservation)
                                <tr>
                                    <td>{{ $reservation->created_at->format('Y-m-d') }}</td>
                                    <td>
                                        <a href="{{ route('dashboard.reservations.show', $reservation->id) }}">
                                            {{ $reservation->id }}
                                        </a>
                                    </td>
                                    <td>{{ $reservation->deposit }}</td>
                                   <td>{{ __("dashboard." . ($reservation->payment_method ?: 'none')) }}</td>
                                    <td>{{ $reservation->payment_reference ?? '-' }}</td>
                                    <td>{{ $reservation->creator ? $reservation->creator->name : '-' }}</td>
                                </tr>
                                @php $totalDeposits += $reservation->deposit; @endphp
                            @endforeach
                            </tbody>
                            <tfoot>
                                <tr class="font-bold text-slate-500 dark:text-slate-400 bg-slate-50">
                                    <td colspan="2">{{ __('dashboard.Total') }}</td>
                                    <td>{{ number_format($totalDeposits, 2) }}</td>
                                    <td colspan="3"></td> {{-- Empty cells for alignment --}}
                                </tr>
                                {{-- Payment Method Summary for Deposits --}}
                                @if(!empty($depositsPaymentSummary))
                                    <tr>
                                        <td colspan="6">
                                            <h6 class="mt-2">{{__("dashboard.Payment Methods Summary")}}:</h6>
                                            <ul class="flex flex-wrap gap-3">
                                                @foreach($depositsPaymentSummary as $method => $amount)
                                                    <li class="text-sm">
                                                        <strong>{{ $method }}:</strong> {{ number_format($amount, 2) }}
                                                    </li>
                                                @endforeach
                                            </ul>
                                        </td>
                                    </tr>
                                @endif
                            </tfoot>
                        </table>
                    </div>
                @endif

                <h4 class="mt-5 mb-3">{{ __('dashboard.Reservation Final Payments') }}</h4>
                @if($reservationsFinalPayments->isEmpty())
                    <p>{{ __('dashboard.No reservation final payment data available.') }}</p>
                @else
                    <div class="app-table-wrap">
                        <table class="app-table align-middle">
                            <thead>
                                <tr class="font-bold text-slate-500 dark:text-slate-400">
                                    <th>{{ __('dashboard.Date') }}</th>
                                    <th>{{ __('dashboard.Reservation ID') }}</th>
                                    <th>{{ __('dashboard.Remaining Amount') }}</th>
                                    <th>{{ __('dashboard.Payment Method') }}</th>
                                    <th>{{ __('dashboard.Reference') }}</th>
                                    <th>{{__('dashboard.Created By')}}</th>
                                    <th>{{ __('dashboard.Delivered By') }}</th>
                                    <th>{{ __('dashboard.Finished By') }}</th>
                                </tr>
                            </thead>
                            <tbody>
                            @php $totalFinalPayments = 0; @endphp
                            @foreach($reservationsFinalPayments as $reservation)
                                <tr>
                                   <td>{{ $reservation->actual_delivered_date->format('Y-m-d') }}</td>
                                    <td>
                                        <a href="{{ route('dashboard.reservations.show', $reservation->id) }}">
                                            {{ $reservation->id }}
                                        </a>
                                    </td>
                                    <td>{{ $reservation->price - $reservation->deposit }}</td>
                                     <td>{{ __("dashboard." . ($reservation->final_payment_method ?: 'none')) }}</td>
                                    <td>{{ $reservation->final_payment_reference ?? '-' }}</td>
                                    <td>{{ $reservation->creator ? $reservation->creator->name : '-' }}</td>
                                    <td>{{ $reservation->deliverer ? $reservation->deliverer->name : '-' }}</td>
                                     <td>{{ $reservation->finisher ? $reservation->finisher->name : '-' }}</td>
                                </tr>
                                @php $totalFinalPayments += ($reservation->price - $reservation->deposit); @endphp
                            @endforeach
                            </tbody>
                            <tfoot>
                                <tr class="font-bold text-slate-500 dark:text-slate-400 bg-slate-50">
                                    <td colspan="2">{{ __('dashboard.Total') }}</td>
                                    <td>{{ number_format($totalFinalPayments, 2) }}</td>
                                    <td colspan="5"></td> {{-- Empty cells for alignment --}}
                                </tr>
                                {{-- Payment Method Summary for Final Payments --}}
                                @if(!empty($finalPaymentsSummary))
                                    <tr>
                                        <td colspan="8">
                                            <h6 class="mt-2">{{ __("dashboard.Payment Methods Summary") }}:</h6>
                                            <ul class="flex flex-wrap gap-3">
                                                @foreach($finalPaymentsSummary as $method => $amount)
                                                    <li class="text-sm">
                                                        <strong>{{ $method }}:</strong> {{ number_format($amount, 2) }}
                                                    </li>
                                                @endforeach
                                            </ul>
                                        </td>
                                    </tr>
                                @endif
                            </tfoot>
                        </table>
                    </div>
                @endif
            @endif

        </div>
    </div>

</div>
@endsection

@section('scripts')
    <script>
        document.addEventListener('DOMContentLoaded', function () {
            var dateInput = document.getElementById('date');
            var startDateInput = document.getElementById('start_date');
            var endDateInput = document.getElementById('end_date');

            function updateInputVisibility() {
                if (dateInput.value) {
                    startDateInput.style.display = 'none';
                    endDateInput.style.display = 'none';
                    startDateInput.value = '';
                    endDateInput.value = '';

                } else {
                    startDateInput.style.display = 'inline-block';
                    endDateInput.style.display = 'inline-block';
                }
            }
            updateInputVisibility();
            dateInput.addEventListener('change', updateInputVisibility);
        });
    </script>
@endsection