@extends('admin.admin_dashboard')
@section('admin')

<link href="https://cdn.jsdelivr.net/npm/select2@4.1.0-rc.0/dist/css/select2.min.css" rel="stylesheet" />

<div class="page-content">
    <div class="container-fluid">
        <h4 class="mb-4 fw-bold">Farmers TR Report</h4>

        {{-- Filter Form --}}
        <form method="GET" action="{{ route('trReports.index') }}" class="card p-3 shadow-sm mb-4">
            <div class="row g-3 align-items-end">

                <div class="col-md-3">
                    <label class="form-label">Report Type</label>
                    <select name="report_type" class="form-select select2-single">
                        <option value="">All</option>
                        <option value="active" {{ $reportType == 'active' ? 'selected' : '' }}>Active</option>
                        <option value="inactive" {{ $reportType == 'inactive' ? 'selected' : '' }}>Inactive</option>
                    </select>
                </div>

                <div class="col-md-2">
                    <label class="form-label">Gender</label>
                    <select name="farmer_gender" class="form-select select2-single">
                        <option value="">All</option>
                        <option value="male" {{ $farmer_gender == 'male' ? 'selected' : '' }}>Male</option>
                        <option value="female" {{ $farmer_gender == 'female' ? 'selected' : '' }}>Female</option>
                    </select>
                </div>

                <div class="col-md-3">
                    <label class="form-label">Group</label>
                    <select name="group" class="form-select select2-single">
                        <option value="">All</option>
                        @foreach($groups as $id => $name)
                            <option value="{{ $id }}" {{ $group == $id ? 'selected' : '' }}>{{ $name }}</option>
                        @endforeach
                    </select>
                </div>

                <div class="col-md-3">
                    <label class="form-label">Age Group</label>
                    <select name="age_group" class="form-select select2-single">
                        <option value="">All</option>
                        <option value="18-25" {{ $age_group == '18-25' ? 'selected' : '' }}>18 - 25</option>
                        <option value="26-35" {{ $age_group == '26-35' ? 'selected' : '' }}>26 - 35</option>
                        <option value="36-50" {{ $age_group == '36-50' ? 'selected' : '' }}>36 - 50</option>
                        <option value="51-100" {{ $age_group == '51-100' ? 'selected' : '' }}>51+</option>
                    </select>
                </div>

                <div class="col-md-4">
                    <label class="form-label">Fields to Display</label>
                    <select name="fields[]" class="form-select select2-multiple" multiple>
                        <option value="farmer_fname" {{ in_array('farmer_fname', $fields ?? []) ? 'selected' : '' }}>Farmer First Name</option>
                        <option value="farmer_lname" {{ in_array('farmer_lname', $fields ?? []) ? 'selected' : '' }}>Farmer Last Name</option>
                        <option value="farmer_gender" {{ in_array('farmer_gender', $fields ?? []) ? 'selected' : '' }}>Gender</option>
                        <option value="group" {{ in_array('group', $fields ?? []) ? 'selected' : '' }}>Group</option>
                        <option value="age" {{ in_array('age', $fields ?? []) ? 'selected' : '' }}>Age</option>
                        <option value="status" {{ in_array('status', $fields ?? []) ? 'selected' : '' }}>Status</option>
                    </select>
                </div>

                <div class="col-md-1">
                    <button type="submit" class="btn btn-primary w-100">View</button>
                </div>
            </div>
        </form>

        {{-- Download PDF --}}
        <div class="mb-3">
            <form method="GET" action="{{ route('reports.tr.pdf') }}" target="_blank">
                @foreach(request()->all() as $key => $value)
                    @if(is_array($value))
                        @foreach($value as $v)
                            <input type="hidden" name="{{ $key }}[]" value="{{ $v }}">
                        @endforeach
                    @else
                        <input type="hidden" name="{{ $key }}" value="{{ $value }}">
                    @endif
                @endforeach
                <button type="submit" class="btn btn-sm btn-outline-secondary">
                    <i class="bx bx-download me-1"></i> Download PDF
                </button>
            </form>
        </div>

        {{-- Results Table --}}
        @if($farmers->count())
            <div class="card shadow-sm">
                <div class="card-body">
                    <h5 class="card-title">{{ $label }} ({{ number_format($farmers->count(), 0) }} Records)</h5>

                    <div class="table-responsive">
                        <table class="table table-bordered align-middle">
                            <thead class="table-light">
                                <tr>
                                    @foreach($fields as $field)
                                        <th>{{ ucfirst(str_replace('_',' ', $field)) }}</th>
                                    @endforeach
                                </tr>
                            </thead>
                          <tbody>
                            @foreach($farmers as $farmer)
                                <tr>
                                    @foreach($fields as $field)
                                        <td>
                                            @if($field == 'group')
                                                {{ $farmer->group->group_name ?? 'N/A' }}
                                            @elseif($field == 'age')
                                                {{ $farmer->age ?? 'N/A' }}
                                            @elseif($field == 'd_o_b')
                                                {{ $farmer->d_o_b ? \Carbon\Carbon::parse($farmer->d_o_b)->format('d-M-Y') : 'N/A' }}
                                            @else
                                                {{ $farmer->$field ?? 'N/A' }}
                                            @endif
                                        </td>
                                    @endforeach
                                </tr>
                            @endforeach
                          </tbody>
                        </table>
                    </div>
                </div>
            </div>
        @else
            <div class="alert alert-info">No data found for selected filters.</div>
        @endif

    </div>
</div>

<script src="https://cdn.jsdelivr.net/npm/select2@4.1.0-rc.0/dist/js/select2.min.js"></script>
<script>
    $(document).ready(function() {
        $('.select2-single').select2({ width: '100%' });
        $('.select2-multiple').select2({ width: '100%' });
    });
</script>

@endsection