@extends('components.customer_layout')
@section('customer-content')

    @php
//        use App\Models\CustomerApplication;
//        use App\Models\Office;
//        use Illuminate\Support\Facades\DB;

        $selectedOffice = request('office');
        $selectedStatus = request('status');

        $applicationsQuery = App\Models\CustomerApplications::query();

        if ($selectedOffice && $selectedOffice != '0') {
            $applicationsQuery->where('office_id', $selectedOffice);
        }

//        if ($selectedStatus && $selectedStatus != '0') {
//            $applicationsQuery->where('status', $selectedStatus);
//        }

        $applicationsOverTime = (clone $applicationsQuery)
            ->selectRaw('DATE(created_at) as date, COUNT(*) as total')
            ->groupBy('date')
            ->orderBy('date')
            ->get();

        $applicationsByModel = (clone $applicationsQuery)
            ->select('model', DB::raw('count(*) as total'))
            ->groupBy('model')
            ->get();

        $applicationsByService = (clone $applicationsQuery)
            ->select('service_id', DB::raw('count(*) as total'))
            ->groupBy('service_id')
            ->get();

        $applicationsByOffice = (clone $applicationsQuery)
            ->select('office_id', DB::raw('count(*) as total'))
            ->groupBy('office_id')
            ->get();

        $offices = \App\Models\Office::orderBy('name')->get();

        $applications = App\Models\CustomerApplications::with(['model', 'office','service'])->paginate(10);

    @endphp

    <div class="main-content">
        <!-- Filter Section -->
        <div class="col-lg-12 col-md-12 col-sm-6 mb-3">
            <div class="card">
                <div class="card-body">
                    <form method="GET">
                        @csrf
                        <div class="row">
                            <div class="col-md-3 mb-3">
                                <h5>Offices</h5>
                                <select class="form-control" name="office">
                                    <option value="0">All Offices</option>
                                    @foreach($offices as $office)
                                        <option value="{{ $office->id }}" {{ request('office') == $office->id ? 'selected' : '' }}>
                                            {{ $office->name }}
                                        </option>
                                    @endforeach
                                </select>
                            </div>
                            <div class="col-md-3 mb-3">
                                <h5>Status</h5>
                                <select class="form-control" name="status">
                                    <option value="0">All Status</option>
                                    <option value="request" {{ request('status') == 'request' ? 'selected' : '' }}>Tajaajila Gaafatame</option>
                                    <option value="accepted" {{ request('status') == 'accepted' ? 'selected' : '' }}>Tajaajila Fudhatama Argate</option>
                                    <option value="follow_up" {{ request('status') == 'follow_up' ? 'selected' : '' }}>Tajaajila Hordoffii Irra Jiru</option>
                                    <option value="approved" {{ request('status') == 'approved' ? 'selected' : '' }}>Mirkaneesse</option>
                                    <option value="rejected" {{ request('status') == 'rejected' ? 'selected' : '' }}>Tjaajila Fudhatama Hin Argatin</option>
                                    <option value="completed" {{ request('status') == 'completed' ? 'selected' : '' }}>Tajaajila Xumurame</option>
                                </select>
                            </div>
                            <div class="col-md-2 d-flex align-items-end">
                                <button class="btn btn--primary text-capitalize w-100" type="submit">Filter</button>
                            </div>
                        </div>
                    </form>
                </div>
            </div>
        </div>
        <table class="table table-bordered table-striped">
            <thead>
            <tr>
                <th>Office</th>
                <th>Services</th>
                <th>Created At</th>
                <th>Status</th>
            </tr>
            </thead>
            <tbody>
            @foreach($applications as $app)
                @php
                    $status = $app->model->status ?? 'Unknown';
                    $statusClass = $status === 'rejected' ? 'text-danger fw-bold' : '';
                    $appType = class_basename($app->model_type); // e.g. "Land", "Business"
                @endphp
                <tr>
                    <td>{{ $app->office->name ?? 'N/A' }}</td>
                    <td>{{ $app->service->name }}</td>
                    <td>{{ $app->created_at}}</td>
                    <td class="{{ $statusClass }}">{{ ucfirst($status) }}</td>
                </tr>
            @endforeach
            </tbody>
        </table>
        <div class="mt-3 d-flex justify-content-center">
            {{ $applications->links('pagination::bootstrap-4') }}
        </div>
        <!-- Data Table -->
        <div class="col-lg-12 col-md-12 col-sm-6 mb-4">
            <div class="card">
                <div class="card-body">
                    <h4>Gaaffii Tajaajilaa waajjiraalee</h4>
                    <table class="table table-bordered table-striped">
                        <thead>
                        <tr>
                            <th>Maqaa Waajjira</th>
                            <th>Waliigala</th>
                        </tr>
                        </thead>
                        <tbody>
                        @foreach($applicationsByOffice as $item)
                            @php
                                $officeName = optional($offices->firstWhere('id', $item->office_id))->name ?? 'Unknown';
                            @endphp
                            <tr>
                                <td>{{ $officeName }}</td>
                                <td class="bold">{{ $item->total }}</td>
                            </tr>
                        @endforeach
                        </tbody>
                    </table>
                </div>
            </div>
        </div>

        <!-- Charts -->
        <div class="row mt-4">
            <div class="col-md-6 mb-4">
                <div class="card">
                    <div class="card-header">📈 Applications Over Time</div>
                    <div class="card-body">
                        <canvas id="lineChart"></canvas>
                    </div>
                </div>
            </div>
            <div class="col-md-6 mb-4">
                <div class="card">
                    <div class="card-header">🍩 Applications by Model</div>
                    <div class="card-body">
                        <canvas id="donutChart"></canvas>
                    </div>
                </div>
            </div>
            <div class="col-md-6 mb-4">
                <div class="card">
                    <div class="card-header">📊 Applications by Service</div>
                    <div class="card-body">
                        <canvas id="barServiceChart"></canvas>
                    </div>
                </div>
            </div>
            <div class="col-md-6 mb-4">
                <div class="card">
                    <div class="card-header">🏢 Applications by Office</div>
                    <div class="card-body">
                        <canvas id="barOfficeChart"></canvas>
                    </div>
                </div>
            </div>
        </div>
    </div>

    <!-- Chart.js -->
    <script src="https://cdn.jsdelivr.net/npm/chart.js"></script>
    <script>
        new Chart(document.getElementById('lineChart').getContext('2d'), {
            type: 'line',
            data: {
                labels: {!! json_encode($applicationsOverTime->pluck('date')) !!},
                datasets: [{
                    label: 'Applications',
                    data: {!! json_encode($applicationsOverTime->pluck('total')) !!},
                    borderColor: '#36A2EB',
                    fill: false
                }]
            }
        });

        new Chart(document.getElementById('donutChart').getContext('2d'), {
            type: 'doughnut',
            data: {
                labels: {!! json_encode($applicationsByModel->pluck('model')) !!},
                datasets: [{
                    data: {!! json_encode($applicationsByModel->pluck('total')) !!},
                    backgroundColor: ['#FF6384', '#36A2EB', '#FFCE56', '#4BC0C0']
                }]
            }
        });

        new Chart(document.getElementById('barServiceChart').getContext('2d'), {
            type: 'bar',
            data: {
                labels: {!! json_encode($applicationsByService->pluck('service_id')) !!},
                datasets: [{
                    label: 'Applications',
                    data: {!! json_encode($applicationsByService->pluck('total')) !!},
                    backgroundColor: '#4BC0C0'
                }]
            }
        });

        new Chart(document.getElementById('barOfficeChart').getContext('2d'), {
            type: 'bar',
            data: {
                labels: {!! json_encode($applicationsByOffice->map(fn($o) => optional($offices->firstWhere('id', $o->office_id))->name ?? 'Unknown')) !!},
                datasets: [{
                    label: 'Applications',
                    data: {!! json_encode($applicationsByOffice->pluck('total')) !!},
                    backgroundColor: '#FF9F40'
                }]
            }
        });
    </script>

@endsection