@extends('layouts.main')

@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">
                <!-- Page pre-title -->
                
                <h2 class="page-title">
                    W.H.S Baseline Report
                </h2>
            </div>
            <!-- Page title actions -->
            <div class="col-auto ms-auto d-print-none">
                <div class="btn-list">
                    <span class="d-none d-sm-inline">
                        <a href="{{ route('export.excel') }}" class="btn btn-1">Download Excel Report</a>
                    </span>
                    <a href="/farmers/create" class="btn btn-primary btn-5 d-none d-sm-inline-block">
                        <svg xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="2" stroke-linecap="round" stroke-linejoin="round" class="icon icon-2">
                            <path d="M12 5l0 14" />
                            <path d="M5 12l14 0" />
                        </svg>
                        Add Baselline
                    </a>  
                </div>
            </div>
        </div>
    </div>
</div>

<!-- Page body -->
<div class="page-body">
    <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="card-body">
                <div class="table-responsive">
                    <!-- Filters -->
                    <form method="GET" action="{{ route('baseline.report') }}" class="row mb-4">
                        <div class="col">
                            <select name="unit_id" class="form-control">
                                <option value="">Unit wise</option>
                                @foreach ($units as $unit)
                                    <option value="{{ $unit->id }}" {{ request('unit_id') == $unit->id ? 'selected' : '' }}>
                                        {{ $unit->name }}
                                    </option>
                                @endforeach
                            </select>
                        </div>
                        <div class="col">
                            <select name="state_id" class="form-control">
                                <option value="">State wise</option>
                                @foreach ($states as $state)
                                    <option value="{{ $state->id }}" {{ request('state_id') == $state->id ? 'selected' : '' }}>
                                        {{ $state->name }}
                                    </option>
                                @endforeach
                            </select>
                        </div>
                        <div class="col">
                            <input type="text" name="surveyed_by" class="form-control" placeholder="Surveyed By" value="{{ request('surveyed_by') }}">
                        </div>
                        <div class="col">
                            <select name="status" class="form-control">
                                <option value="">Status</option>
                                <option value="pending" {{ request('status') == 'pending' ? 'selected' : '' }}>Pending</option>
                                <option value="approved" {{ request('status') == 'approved' ? 'selected' : '' }}>Approved</option>
                                <option value="rejected" {{ request('status') == 'rejected' ? 'selected' : '' }}>Rejected</option>
                            </select>
                        </div>
                        <div class="col">
                            <input type="date" name="date_from" class="form-control" placeholder="Date From" value="{{ request('date_from') }}">
                        </div>
                        <div class="col">
                            <input type="date" name="date_to" class="form-control" placeholder="Date To" value="{{ request('date_to') }}">
                        </div>
                        <div class="col">
                            <button type="submit" class="btn btn-primary">Filter</button>
                        </div>
                        <div class="col">
                            <a href="{{ route('baseline.report') }}" class="btn btn-secondary">Reset</a>
                        </div>
                    </form>

                    <!-- Table -->
                    <table class="table table-bordered table-striped">
                        <thead class="bg-primary text-white">
                            <tr>
                                
                                <th scope="col" class="bg-primary text-light">Unit</th>
                                <th scope="col" class="bg-primary text-light">District</th>
                                <th scope="col" class="bg-primary text-light">Block</th>
                                <th scope="col" class="bg-primary text-light">Village Name</th>
                                
                                <th scope="col" class="bg-primary text-light">WHS Code</th>
                                <th scope="col" class="bg-primary text-light">WHS Type</th>
                                <th scope="col" class="bg-primary text-light">Beneficiary Name</th>
                                <th scope="col" class="bg-primary text-light">Category</th>

                                <th scope="col" class="bg-primary text-light">Date of Survey</th>
                                <th scope="col" class="bg-primary text-light">Size (L x W x D in m)</th>
                                <th scope="col" class="bg-primary text-light">Surveyed By</th>
                                <th scope="col" class="bg-primary text-light">Status</th>
                                <th scope="col" class="bg-primary text-light">View Details</th>
                                <th scope="col" class="bg-primary text-light">Technical Parameters</th>
                                <th scope="col" class="bg-primary text-light">Action</th>
                            </tr>
                        </thead>
                        <tbody>
                            @foreach($reports as $report)
                                <tr>
                                    <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->date_of_survey ?? '-' }}</td>
                                    <td>{{ $report->waterHarvestingStructuresPlanning->pluck('length')->map(fn($l) => (int) $l)->filter()->implode(', ') ?? '-' }} × 
                                        {{ $report->waterHarvestingStructuresPlanning->pluck('width')->map(fn($w) => (int) $w)->filter()->implode(', ') ?? '-' }}× 
                                        {{ $report->waterHarvestingStructuresPlanning->pluck('depth_or_height')->map(fn($w) => (int) $w)->filter()->implode(', ') ?? '-' }}
                                    </td>
                                    <td>{{ $report->user->name }}</td>
                                    <td>{{ $report->status ?? '-' }}</td>
                                    <td>
                                        <a href="{{ route('admin.baseline.show', $report->id) }}" class="btn btn-sm btn-info">View</a>

                                    </td>
                                    <td>
                                        <a href="#" class="btn btn-sm btn-secondary">Show</a>
                                    </td>
                                    <td>
                                     @php
    $structure = $report->waterHarvestingStructuresPlanning->first();
@endphp

@if ($structure)
    <a href="{{ route('map.view', [
        'lat' => $structure->latitude,
        'lng' => $structure->longitude
    ]) }}" class="btn btn-sm btn-primary" target="_blank">Map View</a>
@endif



                            
                                    </td>
                                </tr>
                            @endforeach
                        </tbody>
                    </table>

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

                </div>
            </div>
        </div>
    </div>
</div>
@endsection