@extends('admin.admin_dashboard')

@section('admin')
<div class="page-content">
    <div class="page-breadcrumb d-flex flex-column flex-sm-row align-items-center mb-3">
        <div class="breadcrumb-title pe-3"><b>MID-SPONSORSHIP</b></div>
        <div class="ps-3">
            <nav aria-label="breadcrumb">
                <ol class="breadcrumb mb-0 p-0">
                    <li class="breadcrumb-item"><a href="{{ route('admin.dashboard') }}"><i class="bx bx-home-alt"></i></a></li>
                    <li class="breadcrumb-item active" aria-current="page">
                        <!-- Dynamically display the selected mid-term year -->
                        Mid-Term Sponsorships {{ request('mid_term_year', now()->year) }}
                    </li>
                </ol>
            </nav>
        </div>
    </div>

    <div class="col-lg-12">
        <div class="card">
            <form method="GET" action="{{ route('all.children.midsponsorship') }}">
                @csrf
                <div class="card-body">
                    <div class="container">
                        <div class="row g-3">
                            <!-- Mid-Term Year Filter -->
                            <div class="col-12 col-md-4">
                                <label for="mid_term_year" class="form-label">Select Mid Sponsorship Year</label>
                                <select class="form-select" id="mid_term_year" name="mid_term_year">
                                    <option value="" disabled>Select a year</option>
                                    @foreach ($midTermYears as $year)
                                        <option value="{{ $year }}" 
                                            @if(request('mid_term_year', now()->year) == $year) selected @endif>
                                            {{ $year }}
                                        </option>
                                    @endforeach
                                </select>
                            </div>

                            <!-- Mid-Term Status Filter -->
                            <div class="col-12 col-md-4">
                                <label for="status" class="form-label">Mid-Sponsorship Status</label>
                                <select class="form-select" id="status" name="status">
                                    <option value="all" @if(request('status', 'all') == 'all') selected @endif>All</option>
                                    <option value="completed" @if(request('status') == 'completed') selected @endif>Completed</option>
                                    <option value="not_completed" @if(request('status') == 'not_completed') selected @endif>Not Completed</option>
                                </select>
                            </div>
                        </div>
                    </div>

                    <!-- Submit Button -->
                    <div class="row mt-3">
                        <div class="col-12 d-flex justify-content-end">
                            <input type="submit" class="btn btn-primary px-4" value="Filter" />
                        </div>
                    </div>
                </div>
            </form>
        </div>
    </div>

    <div class="card mt-4">
        <div class="card-body">
            <div class="table-responsive">
                <table id="example" class="table table-striped table-bordered">
                    <thead>
                        <tr>
                            <th>ID</th>
                            <th>Child</th>
                            <th>Mid-Term Date</th>
                            <th>Status</th>
                            <th>Action</th>
                        </tr>
                    </thead>
                    <tbody>
                        @foreach ($children as $key => $midSponsorship)
                            <tr>
                                <td>{{ $key + 1 }}</td>
                                <td>{{ $midSponsorship->child->child_number }} {{ $midSponsorship->child->child_fname }} {{ $midSponsorship->child->child_lname }}</td>
                                <td>{{ \Carbon\Carbon::parse($midSponsorship->mid_term_date)->format('F jS, Y') }}</td>
                                <td>
                                    @if ($midSponsorship->child->sponsorship->mid_assessment === 0)
                                        <span class="badge bg-danger text-white">Not Completed</span>
                                    @elseif ($midSponsorship->child->sponsorship->mid_assessment === 1)
                                        <span class="badge bg-success text-white">Completed</span>
                                    @else
                                        <span class="badge bg-secondary text-white">Unknown</span>
                                    @endif
                                </td>
                                <td class="d-flex justify-content-center align-items-center">
                                    <div class="dropdown">
                                        <i class="bx bx-dots-vertical-rounded" 
                                           data-bs-toggle="dropdown" 
                                           aria-expanded="false" 
                                           style="cursor: pointer; font-size: 1.5rem;"></i>
                                        <ul class="dropdown-menu">
                                        @if (Auth::user()->can('midsponsorship.view'))
                                            <li>
                                                <a class="dropdown-item" href="{{ route('midsponsorship.show', $midSponsorship->id_sponsorship) }}">
                                                    <i class="bx bx-show"></i> View 
                                                </a>
                                            </li>
                                             @endif

                                             @if (Auth::user()->can('midsponsorship.update'))
                                            <li>
                                                <a class="dropdown-item" href="{{ route('midsponsorship.show', $midSponsorship->id_sponsorship) }}">
                                                    <i class="bx bx-edit"></i> Update
                                                </a>
                                            </li>
                                             @endif
                                        </ul>
                                    </div>
                                </td>
                            </tr>
                        @endforeach
                    </tbody>
                </table>
            </div>
        </div>
    </div>
</div>
@endsection