@extends('layouts.usermain')

@section('main-container')
<script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>

<div class="page-header d-print-none">
    <div class="container-xl">
        <div class="row g-2 align-items-center">
            <div class="col">
                <h2 class="page-title">Baseline Report</h2>
            </div>
            @if(session('success'))
                <div class="alert alert-success">{{ session('success') }}</div>
            @endif
            @if(session('error'))
                <div class="alert alert-danger">{{ session('error') }}</div>
            @endif
        </div>
    </div>
</div>

<div class="page-body">
    <div class="container-xl">
        <div class="card mb-3 shadow-sm">
            <div class="card-body">
                <form method="GET" action="{{ route('prelevel.report.index') }}">
                    <div class="row g-3 align-items-end">

                        {{-- Unit --}}
                        <div class="col-md-3">
                            <label class="form-label">Unit</label>
                            <select name="unit_id" class="form-select">
                                <option value="">All Units</option>
                                @if($unit)
                                    <option value="{{ $unit->id }}" selected>{{ $unit->name }}</option>
                                @endif
                            </select>
                        </div>

                        {{-- State --}}
                        <div class="col-md-2">
                            <label class="form-label">State</label>
                            <select name="state_id" class="form-select">
                                <option value="">All States</option>
                                @if($state)
                                    <option value="{{ $state->id }}" selected>{{ $state->name }}</option>
                                @endif
                            </select>
                        </div>

                        {{-- District --}}
                        <div class="col-md-2">
                            <label class="form-label">District</label>
                            <select name="district_id" class="form-select">
                                <option value="">All Districts</option>
                                @foreach($districts as $district)
                                    <option value="{{ $district->id }}" {{ request('district_id') == $district->id ? 'selected' : '' }}>
                                        {{ $district->name }}
                                    </option>
                                @endforeach
                            </select>
                        </div>

                        {{-- User --}}
                        <div class="col-md-2">
                            <label class="form-label">User</label>
                            <select name="user_id" class="form-select">
                                <option value="">All Users</option>
                                @foreach($users as $u)
                                    <option value="{{ $u->id }}" {{ request('user_id') == $u->id ? 'selected' : '' }}>
                                        {{ $u->name }}
                                    </option>
                                @endforeach
                            </select>
                        </div>

                        {{-- Actions --}}
                        <div class="col-md-3 d-flex gap-2">
                            <button type="submit" class="btn btn-primary w-100">
                                <i class="ti ti-search"></i> Search
                            </button>
                            <a href="{{ route('baseline.report') }}" class="btn btn-outline-secondary w-100">Reset</a>
                        </div>

                    </div>
                </form>
            </div>
        </div>
    </div>
</div>

@php $i = 0; @endphp
    <div class="container-xl">
        <div class="card mb-4 shadow-sm">
            <div class="card-header bg-primary text-white">
                <h5 class="mb-0">Baseline Report</h5>
            </div>

            <div class="table-responsive">
                <table class="table table-bordered table-striped text-center mt-1">
                    <thead class="bg-light text-secondary">
                        <tr>
                            <th class="bg-info-lt">#</th>
                            <th class="bg-info-lt">Unit</th>
                            <th class="bg-info-lt">District</th>
                            <th class="bg-info-lt">Block</th>
                            <th class="bg-info-lt">Village</th>
                            <th class="bg-info-lt">WHS Code</th>
                            <th class="bg-info-lt">WHS - Type</th>
                            <th class="bg-info-lt">Beneficiary Name</th>
                            <th class="bg-info-lt">Category</th>
                            <th class="bg-info-lt">Size (L × W × D)</th>
                            <th class="bg-info-lt">Pre-Level</th>
                            <th class="bg-info-lt">Map</th>
                            <th class="bg-info-lt">Survey Date</th>
                            <th class="bg-info-lt">Status</th>
                            <th class="bg-info-lt">Surveyed By</th>
                            <th class="bg-info-lt">Edit</th>
                            <th class="bg-info-lt">Delete</th>
                        </tr>
                    </thead>
                    <tbody>
                        @forelse($reports as $report)
                        <tr>
                            <td>{{++$i}}</td>
                            <td>{{ $report->unit->name ?? '-' }}</td>
                            <td>{{ $report->district->name ?? '-' }}</td>
                            <td>{{ $report->block->name ?? '-' }}</td>
                            <td>{{ $report->village->name ?? '-' }}</td>
                            <td>{{ $report->application_code ?? '-' }}</td>
                             <td>{{ $report->projectType->name ?? '-' }}</td>
                            <td>{{ $report->name_of_respondent ?? '-' }}</td>
                            <td>{{ $report->households->first()->category ?? '-' }}</td>
                            <td>
                                {{ $report->waterHarvestingStructuresPlanning->pluck('length')->map(fn($v) => (int) $v)->filter()->implode(', ') ?? '-' }} ×
                                {{ $report->waterHarvestingStructuresPlanning->pluck('width')->map(fn($v) => (int) $v)->filter()->implode(', ') ?? '-' }} ×
                                {{ $report->waterHarvestingStructuresPlanning->pluck('depth_or_height')->map(fn($v) => (int) $v)->filter()->implode(', ') ?? '-' }}
                            </td>
                            <td>
                                @if($report->preWorkLevels && $report->preWorkLevels->isNotEmpty())
                                    <a href="{{ route('baseline.storeMbShow', $report->id) }}" class="btn btn-sm btn-success">View</a>
                                @elseif(in_array($report->status, ['Pending','Needs Correction']))
                                    Pending
                                @else
                                    <a href="{{ route('pre_work_levels.addMb', $report->id) }}" class="btn btn-sm btn-primary">Add</a>
                                @endif
                            </td>
                            <td>
                                @php $structure = $report->waterHarvestingStructuresPlanning->first(); @endphp
                                @if($structure)
                                    <a href="{{ route('map.view', ['lat' => $structure->latitude, 'lng' => $structure->longitude]) }}" target="_blank" class="btn btn-sm btn-primary">View</a>
                                @endif
                            </td>
                            <td>{{ $report->date_of_survey ? \Carbon\Carbon::parse($report->date_of_survey)->format('d/m/Y') : '-' }}</td>
                            <td>{{ $report->status ?? '-' }}</td>
                            <td>{{ $report->user->name ?? '-' }}</td>
                            <td>
                                <a href="{{ route('reports.edit', $report->id) }}" class="btn btn-sm btn-warning">Edit</a>
                            </td>
                            <td>
                                <form action="{{ route('reports.destroy', $report->id) }}" method="POST" style="display:inline;">
                                    @csrf
                                    @method('DELETE')
                                    <button type="submit" class="btn btn-sm btn-danger" onclick="return confirm('Are you sure you want to delete this report?')">Delete</button>
                                </form>
                            </td>
                        </tr>
                        @empty
                        <tr>
                            <td colspan="16">No reports found.</td>
                        </tr>
                        @endforelse
                    </tbody>
                </table>

                <div class="d-flex justify-content-center mt-3">
                    {{ $reports->links() }}
                </div>
            </div>
        </div>
    </div>
@endsection