@extends('layouts.app')

@section('content')
<div class="container-fluid py-4">
    <style>
        body {
            background-color: #f4fdf6;
        }
        .card, .card-body {
            border-radius: 12px;
        }
        .table thead {
            background-color: #388e3c;
            color: #fff;
        }
        tbody tr:hover {
            background-color: #e8f5e9;
        }
        .btn-success, .btn-outline-success {
            transition: all 0.3s;
        }
        .btn-success:hover {
            background-color: #256a28;
            border-color: #256a28;
        }
    </style>

    <div class="row">
        {{-- Main Content --}}
        <main class="col-md-12 px-3">

            {{-- Page Header --}}
            <div class="d-flex justify-content-between align-items-center mb-4 flex-wrap">
                <h2 class="border-start border-4 ps-3 border-success text-success mb-0">
                    👨‍🏫 Trainers
                </h2>
                <div class="d-flex gap-2 flex-wrap">
                    <a href="{{ route('coordinator.dashboard') }}" class="btn btn-outline-success">
                        <i class="bi bi-arrow-left"></i> Back to Dashboard
                    </a>
                    <a href="{{ route('coordinator.trainers.export') }}" class="btn btn-success">
                        <i class="bi bi-download"></i> Export to CSV
                    </a>
                </div>
            </div>

            {{-- Summary Cards --}}
            <div class="row mb-4">
                <div class="col-md-3 mb-3">
                    <div class="card shadow-sm text-center">
                        <div class="card-body">
                            <h5>Total Trainers</h5>
                            <h3 class="text-success">{{ $totalTrainers }}</h3>
                        </div>
                    </div>
                </div>
                <div class="col-md-3 mb-3">
                    <div class="card shadow-sm text-center">
                        <div class="card-body">
                            <h5>Total Payment Due</h5>
                            <h3 class="text-danger">
                                Ksh {{ number_format($totalDue, 2) }}
                            </h3>
                        </div>
                    </div>
                </div>
                <div class="col-md-3 mb-3">
                    <div class="card shadow-sm text-center">
                        <div class="card-body">
                            <h5>Total Paid</h5>
                            <h3 class="text-primary">
                                Ksh {{ number_format($totalPaid, 2) }}
                            </h3>
                        </div>
                    </div>
                </div>
            </div>

            {{-- Filters Card --}}
            <div class="card mb-4 shadow-sm">
                <div class="card-body">
                    <form action="{{ route('coordinator.trainers') }}" method="GET" class="row g-3 align-items-end">
                        <div class="col-md-3">
                            <label class="form-label">Trainer Name</label>
                            <input type="text" name="name" class="form-control" placeholder="Search by name" value="{{ request('name') }}">
                        </div>
                        <div class="col-md-2">
                            <label class="form-label">County</label>
                            <select name="county" id="county_id" class="form-select">
                                <option value="">All Counties</option>
                                @foreach($counties as $county)
                                    <option value="{{ $county->id }}" {{ request('county') == $county->id ? 'selected' : '' }}>
                                        {{ $county->name }}
                                    </option>
                                @endforeach
                            </select>
                        </div>
                        <div class="col-md-2">
                            <label class="form-label">Sub-County</label>
                            <select name="sub_county" id="sub_county_id" class="form-select">
                                <option value="">All Sub-Counties</option>
                                @foreach($subCounties as $sub)
                                    <option value="{{ $sub->id }}" {{ request('sub_county') == $sub->id ? 'selected' : '' }}>
                                        {{ $sub->name }}
                                    </option>
                                @endforeach
                            </select>
                        </div>
                        <div class="col-md-2">
                            <label class="form-label">Center</label>
                            <select name="center" id="center_id" class="form-select">
                                <option value="">All Centers</option>
                                @foreach($centers as $center)
                                    <option value="{{ $center->id }}" {{ request('center') == $center->id ? 'selected' : '' }}>
                                        {{ $center->name }}
                                    </option>
                                @endforeach
                            </select>
                        </div>
                        <div class="col-md-2">
                            <label class="form-label">Class</label>
                            <select name="classroom" id="class_id" class="form-select">
                                <option value="">All Classes</option>
                                @foreach($classes as $class)
                                    <option value="{{ $class->id }}" {{ request('classroom') == $class->id ? 'selected' : '' }}>
                                        {{ $class->name }}
                                    </option>
                                @endforeach
                            </select>
                        </div>
                        <div class="col-md-1 d-grid">
                            <button type="submit" class="btn btn-success mt-2">
                                <i class="bi bi-funnel"></i> Filter
                            </button>
                        </div>
                    </form>
                </div>
            </div>

            {{-- Trainers Table --}}
            @if($trainers->isEmpty())
                <div class="alert alert-info shadow-sm">
                    No trainers found.
                </div>
            @else
                <div class="card shadow-sm">
                    <div class="card-body p-0">
                        <div class="table-responsive">
                            <table id="trainersTable" class="table table-hover table-bordered mb-0">
                                <thead class="table-success">
                                    <tr>
                                        <th>#</th>
                                        <th>Name</th>
                                        <th>Phone</th>
                                        <th>Email</th>
                                        <th>County</th>
                                        <th>Sub-County</th>
                                        <th>Center</th>
                                        <th>Classes</th>
                                        <th>Total (Ksh)</th>
                                        <th>Paid (Ksh)</th>
                                        <th>Due (Ksh)</th>
                                        <th class="text-center">Actions</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    @foreach($trainers as $trainer)
                                    <tr>
                                        <td>{{ $loop->iteration }}</td>
                                        <td>{{ $trainer->name }}</td>
                                        <td>{{ $trainer->phone ?? 'N/A' }}</td>
                                        <td>{{ $trainer->email ?? 'N/A' }}</td>
                                        <td>{{ $trainer->county->name ?? '-' }}</td>
                                        <td>{{ $trainer->subCounty->name ?? '-' }}</td>
                                        <td>{{ $trainer->center->name ?? '-' }}</td>
                                        <td>
                                            @if($trainer->classes && $trainer->classes->isNotEmpty())
                                                {{ $trainer->classes->join(', ') }}
                                            @else
                                                -
                                            @endif
                                        </td>
                                        <td>{{ number_format($trainer->total_assigned ?? 0, 2) }}</td>
                                        <td>{{ number_format($trainer->total_paid ?? 0, 2) }}</td>
                                        <td>{{ number_format($trainer->total_due ?? 0, 2) }}</td>
                                        <td class="text-center">
                                            <a href="{{ route('trainer.show', $trainer->id) }}" class="btn btn-sm btn-success">
                                                <i class="bi bi-eye"></i> View
                                            </a>
                                        </td>
                                    </tr>
                                    @endforeach
                                </tbody>
                            </table>
                        </div>
                    </div>
                </div>
            @endif

            {{-- Footer --}}
            <div class="text-center mt-4 text-muted">
                NYOTA System © {{ date('Y') }}
            </div>
        </main>
    </div>
</div>
@endsection

@section('scripts')
<script>
    $(document).ready(function() {
        $('#trainersTable').DataTable({
            "pageLength": 25,
            "lengthChange": true,
            "ordering": true,
            "order": [[ 1, "asc" ]],
            "columnDefs": [
                { "orderable": false, "targets": [11] }
            ]
        });

        // Dynamic dropdowns
        $('#county_id').change(function(){
            let countyId = $(this).val();
            $('#sub_county_id').html('<option value="">All Sub-Counties</option>');
            $('#center_id').html('<option value="">All Centers</option>');
            $('#class_id').html('<option value="">All Classes</option>');

            if(countyId){
                fetch(`/trainer-assignments/subcounties/${countyId}`)
                .then(res => res.json())
                .then(data => {
                    data.forEach(sub => {
                        $('#sub_county_id').append(`<option value="${sub.id}">${sub.name}</option>`);
                    });
                });
            }
        });

        $('#sub_county_id').change(function(){
            let subId = $(this).val();
            $('#center_id').html('<option value="">All Centers</option>');
            $('#class_id').html('<option value="">All Classes</option>');

            if(subId){
                fetch(`/trainer-assignments/centers/${subId}`)
                .then(res => res.json())
                .then(data => {
                    data.forEach(center => {
                        $('#center_id').append(`<option value="${center.id}">${center.name}</option>`);
                    });
                });
            }
        });

        $('#center_id').change(function(){
            let centerId = $(this).val();
            $('#class_id').html('<option value="">All Classes</option>');

            if(centerId){
                fetch(`/trainer-assignments/classes/${centerId}`)
                .then(res => res.json())
                .then(data => {
                    data.forEach(cls => {
                        $('#class_id').append(`<option value="${cls.id}">${cls.name}</option>`);
                    });
                });
            }
        });
    });
</script>
@endsection