@extends('layouts.app')

@section('content')
<!-- start page title -->
<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 font-size-18">Summary Report</h4>

            <div class="page-title-right">
                <ol class="breadcrumb m-0">
                    <li class="breadcrumb-item"><a href="#">Reports</a></li>
                    <li class="breadcrumb-item active">Summary Report</li>
                </ol>
            </div>

        </div>
    </div>
</div>
<!-- end page title -->

<div class="row">
    <div class="col-lg-12">
        <div class="card">
            <div class="card-body">
                <form action="{{ route('sumreports') }}" method="GET">

                    <div class="row">

                        <div class="col-md-4 mb-3">
                            <label class="form-label">Province</label>
                            <select name="province_id" class="form-control">
                                <option value="" disabled selected>Select province</option>
                                @foreach($provinces as $id => $provinceName)
                                <option value="{{ $id }}">{{ $provinceName }}</option>
                                @endforeach
                            </select>
                            @error('Province')
                            <span class="invalid-feedback" role="alert">
                                <strong>{{ $message }}</strong>
                            </span>
                            @enderror
                        </div>

                        <div class="col-md-4 mb-3">
                            <label class="form-label">District</label>
                            <select name="district_id" class="form-control">
                                <option value="" disabled selected>Select district</option>
                                @foreach($districts as $id => $districtName)
                                <option value="{{ $id }}">{{ $districtName }}</option>
                                @endforeach
                            </select>
                            @error('district')
                            <span class="invalid-feedback" role="alert">
                                <strong>{{ $message }}</strong>
                            </span>
                            @enderror
                        </div>

                        <div class="col-md-4 mb-3">
                            <label class="form-label">LocalLevel</label>
                            <select name="locallevel_id" class="form-control">
                                <option value="" disabled selected>Select Municipality/Rural Municipality</option>
                                @foreach($locallevels as $id => $locallevelName)
                                <option value="{{ $id }}">{{ $locallevelName }}</option>
                                @endforeach
                            </select>
                            @error('locallevel')
                            <span class="invalid-feedback" role="alert">
                                <strong>{{ $message }}</strong>
                            </span>
                            @enderror
                        </div>

                    </div>
                    <!-- Add more input fields for other criteria if needed -->
                    <div class="mb-3">
                        <button class="btn btn-primary w-100 waves-effect waves-light" type="submit">Search</button>
                    </div>
                </form>

                <!-- end table responsive -->
            </div>
            <!-- end card body -->
        </div>
        <!-- end card -->
    </div>
    <!-- end col -->
</div>
<!-- end row -->

<div class="container">
    <h1>Search Results</h1>

    @if($showingReport)
    <table class="table">
        <thead>
            <tr>
                <th>S.No</th>
                <th>Specialization</th>
                <th>Level</th>
                <th>No. of members</th>
            </tr>
        </thead>
        <tbody>
            @foreach($results as $key => $member)
            <tr>
                <td>{{ $key + 1 }}</td>
                <td>{{ $member->specialization->specialization }}</td>
                <td>{{ $member->level->level }}</td>
                @if ($key == 0)
                <td rowspan="{{ $results->count() }}">
                    <a href="{{ route('members.list') }}">{{ $results->count() }}</a>
                </td>
                @endif
            </tr>
            @endforeach
        </tbody>
    </table>

    @else
    <p>No members found.</p>

    @endif
</div>



@endsection