@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">
                W.H.S
                
                <h2 class="page-title">
                     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</a>
                    </span>
                    <a href="/farmers/create" class="btn btn-primary btn-5 d-none d-sm-inline-block">
                        Add
                    </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-light text-secondary text-center">Unit</th>
                                <th scope="col"  class="bg-light text-secondary text-center">District</th>
                                <th scope="col"  class="bg-light text-secondary text-center">Block</th>
                                <th scope="col"  class="bg-light text-secondary text-center">Village</th>
                                
                                <th scope="col"  class="bg-light text-secondary text-center">WHS Code</th>
                                <th scope="col"  class="bg-light text-secondary text-center">WHS Type</th>
                                <th scope="col"  class="bg-light text-secondary text-center">Beneficiary Name</th>
                                <th scope="col"  class="bg-light text-secondary text-center">Category</th>

                                <th scope="col"  class="bg-light text-secondary text-center">Survey Date</th>
                                <th scope="col"  class="bg-light text-secondary text-center">Size (L x W x D in m)</th>
                                <th scope="col"  class="bg-light text-secondary text-center">Status</th>
                                <th scope="col"  class="bg-light text-secondary text-center">Edit</th>
                                <th scope="col"  class="bg-light text-secondary text-center">Base L-View</th>
                                <th scope="col"  class="bg-light text-secondary text-center">Pre-Level</th>
                                <th scope="col"  class="bg-light text-secondary text-center">Map</th>
                                <th scope="col"  class="bg-light text-secondary text-center">Surveyed By</th>

                            </tr>
                        </thead>
                        <tbody class="text-center">
                            @foreach($reports as $report)
                                <tr>
                                    <td> {{ $report->unit->name ?? '-' }}</td>
                                    <td>{{ $report->district->name ? ucfirst(strtolower($report->district->name)) : '-' }}</td>
                                    <td>{{ $report->block->name ? ucfirst(strtolower($report->block->name)) : '-' }}</td>
                                    <td>{{ $report->village->name ? ucfirst(strtolower($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 ? \Carbon\Carbon::parse($report->date_of_survey)->format('d/m/y') : '-' }}</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->status ?? '-' }}</td>

                                    <td>
                                       @if($report->status === 'Pending' || $report->status === 'Needs Correction') 

                                                                                <a href="{{ route('baseline.edit', $report->id) }}" class="btn btn-sm btn-primary">
                                            <i class="fas fa-edit"></i> Edit
                                        </a>
                                        @else
                                            <button class="btn btn-sm btn-secondary" disabled>
                                                <i class="fas fa-edit"></i> Edit
                                            </button>
                                        @endif
                                    </td>



                                    <td>

                                        <a href="{{ url('user/reports/baseline', $report->id) }}" class="btn btn-sm btn-info">View</a>

                                    </td>
                                    
                                  <td>
                                    @if ($report->preWorkLevels && $report->preWorkLevels->isNotEmpty())
                                        <a href="{{ route('baseline.storeMbShow', $report->id) }}" class="btn btn-sm btn-success">View</a>
                                    @else 
                                        @if(($report->status === 'Pending' || $report->status === 'Needs Correction'))
                                         Pending
                                        @else
                                        <a href="{{ route('pre_work_levels.addMb', $report->id) }}" class="btn btn-sm btn-primary">Add</a>
                                    @endif
                                     @endif
                                </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">View</a>
                                        @endif
                                    </td>
                                    <td>{{ $report->user->name }}</td>
                                </tr>
                            @endforeach
                        </tbody>
                    </table>

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

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