@extends('layouts.admin')

@section('title')
    <title>Inspection Reports | Inspectorate</title>
@endsection

@section('content')
<div class="container-fluid">
    <!-- Page Header -->
    <div class="row">
        <div class="col-12">
            <div class="page-title-box d-sm-flex align-items-center justify-content-between">
                <h4 class="mb-sm-0">Inspection Reports</h4>
                <div class="page-title-right">
                    <ol class="breadcrumb m-0">
                        <li class="breadcrumb-item"><a href="{{ route('admin.dashboard') }}">Dashboard</a></li>
                        <li class="breadcrumb-item active">Reports</li>
                    </ol>
                </div>
            </div>
        </div>
    </div>

    <!-- Summary Cards -->
    <div class="row">
        <div class="col-xl-3 col-md-6">
            <div class="card">
                <div class="card-body">
                    <div class="d-flex align-items-center">
                        <div class="avatar-sm flex-shrink-0">
                            <span class="avatar-title bg-primary rounded">
                                <i class="mdi mdi-file-document-outline fs-4"></i>
                            </span>
                        </div>
                        <div class="flex-grow-1 ms-3">
                            <p class="text-muted mb-1">Total Requests</p>
                            <h4 class="mb-0">{{ $totalRequests }}</h4>
                        </div>
                    </div>
                </div>
            </div>
        </div>

        <div class="col-xl-3 col-md-6">
            <div class="card">
                <div class="card-body">
                    <div class="d-flex align-items-center">
                        <div class="avatar-sm flex-shrink-0">
                            <span class="avatar-title bg-success rounded">
                                <i class="mdi mdi-check-circle-outline fs-4"></i>
                            </span>
                        </div>
                        <div class="flex-grow-1 ms-3">
                            <p class="text-muted mb-1">Approved</p>
                            <h4 class="mb-0">{{ $approvedRequests }}</h4>
                        </div>
                    </div>
                </div>
            </div>
        </div>

        <div class="col-xl-3 col-md-6">
            <div class="card">
                <div class="card-body">
                    <div class="d-flex align-items-center">
                        <div class="avatar-sm flex-shrink-0">
                            <span class="avatar-title bg-danger rounded">
                                <i class="mdi mdi-close-circle-outline fs-4"></i>
                            </span>
                        </div>
                        <div class="flex-grow-1 ms-3">
                            <p class="text-muted mb-1">Rejected</p>
                            <h4 class="mb-0">{{ $rejectedRequests }}</h4>
                        </div>
                    </div>
                </div>
            </div>
        </div>

        <div class="col-xl-3 col-md-6">
            <div class="card">
                <div class="card-body">
                    <div class="d-flex align-items-center">
                        <div class="avatar-sm flex-shrink-0">
                            <span class="avatar-title bg-warning rounded">
                                <i class="mdi mdi-clock-outline fs-4"></i>
                            </span>
                        </div>
                        <div class="flex-grow-1 ms-3">
                            <p class="text-muted mb-1">Pending</p>
                            <h4 class="mb-0">{{ $pendingRequests }}</h4>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>

    <!-- Monthly Statistics -->
    <div class="row">
        <div class="col-12">
            <div class="card">
                <div class="card-header">
                    <h4 class="card-title mb-0">Monthly Statistics (Last 12 Months)</h4>
                </div>
                <div class="card-body">
                    @if($monthlyStats->count() > 0)
                        <div class="table-responsive">
                            <table class="table table-hover table-centered table-nowrap mb-0">
                                <thead class="table-light">
                                    <tr>
                                        <th>Month</th>
                                        <th>Total Requests</th>
                                        <th>Approved</th>
                                        <th>Rejected</th>
                                        <th>Approval Rate</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    @foreach($monthlyStats as $stat)
                                        <tr>
                                            <td>
                                                <h6 class="mb-0">{{ date('F Y', strtotime($stat->year . '-' . $stat->month . '-01')) }}</h6>
                                            </td>
                                            <td>{{ $stat->total }}</td>
                                            <td>
                                                <span class="text-success">{{ $stat->approved }}</span>
                                            </td>
                                            <td>
                                                <span class="text-danger">{{ $stat->rejected }}</span>
                                            </td>
                                            <td>
                                                @if($stat->total > 0)
                                                    {{ number_format(($stat->approved / $stat->total) * 100, 1) }}%
                                                @else
                                                    0%
                                                @endif
                                            </td>
                                        </tr>
                                    @endforeach
                                </tbody>
                            </table>
                        </div>
                    @else
                        <div class="text-center py-5">
                            <div class="avatar-md mx-auto mb-3">
                                <div class="avatar-title bg-light rounded-circle">
                                    <i class="mdi mdi-chart-bar fs-2 text-muted"></i>
                                </div>
                            </div>
                            <h5 class="mb-2">No data available</h5>
                            <p class="text-muted">Reports will be available once requests start coming in.</p>
                        </div>
                    @endif
                </div>
            </div>
        </div>
    </div>

    <!-- Overall Statistics -->
    <div class="row">
        <div class="col-12">
            <div class="card">
                <div class="card-header">
                    <h4 class="card-title mb-0">Overall Statistics</h4>
                </div>
                <div class="card-body">
                    <div class="row">
                        <div class="col-md-6">
                            <h5 class="mb-3">Approval Rate</h5>
                            <div class="text-2xl font-bold text-gray-900 mb-2">{{ number_format($approvalRate, 1) }}%</div>
                            <div class="progress mb-3">
                                <div class="progress-bar bg-success" style="width: {{ $approvalRate }}%"></div>
                            </div>
                        </div>
                        <div class="col-md-6">
                            <h5 class="mb-3">Request Types Distribution</h5>
                            <div class="row">
                                <div class="col-12">
                                    <div class="d-flex justify-content-between mb-2">
                                        <span>Document Upload</span>
                                        <span class="badge bg-primary thumb-sm rounded-circle">{{ $documentUploads }}</span>
                                    </div>
                                </div>
                                <div class="col-12">
                                    <div class="d-flex justify-content-between mb-2">
                                        <span>Field Visit</span>
                                        <span class="badge bg-info thumb-sm rounded-circle">{{ $fieldVisits }}</span>
                                    </div>
                                </div>
                                <div class="col-12">
                                    <div class="d-flex justify-content-between mb-2">
                                        <span>Both</span>
                                        <span class="badge bg-secondary thumb-sm rounded-circle">{{ $bothTypes }}</span>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>
@endsection