@extends('layouts.main')
@section('main-container')

<div class="page-header d-print-none mb-3">
    <div class="container-xl">
        <div class="row g-2 align-items-center">
            <div class="col">
                <h2 class="page-title">Measurement Book – Bill Approval</h2>
            </div>
            <div class="col-auto ms-auto d-print-none">
                <div class="btn-list">
                    <a href="{{ route('export.excel') }}" class="btn btn-outline-success">
                        <i class="ti ti-file-spreadsheet me-1"></i> Download Excel
                    </a>
                    <a href="{{ route('farmers.create') }}" class="btn btn-primary">
                        <i class="ti ti-plus me-1"></i> Baseline
                    </a>
                </div>
            </div>
        </div>
    </div>
</div>

<!-- Flash Messages -->
<div class="container">
    @if(session('success'))
        <div class="alert alert-success alert-dismissible fade show">
            {{ session('success') }}
        </div>
    @endif

    @if(session('error'))
        <div class="alert alert-danger alert-dismissible fade show">
            {{ session('error') }}
        </div>
    @endif
</div>

<div class="container-xl">
    <div class="card mb-3 shadow-sm">

        <div class="card-body bg-light">
           <form method="GET" action="{{ route('bill.approval.admin.index') }}" class="mb-3">
                <div class="row g-3 align-items-end">

                    <div class="col-md-3">
                        <label class="form-label fw-semibold">Unit</label>
                        <select name="unit_id" class="form-select">
                            <option value="">All Units</option>
                            @foreach($units as $unit)
                                <option value="{{ $unit->id }}"
                                    {{ request('unit_id') == $unit->id ? 'selected' : '' }}>
                                    {{ $unit->name }}
                                </option>
                            @endforeach
                        </select>
                    </div>

                    <div class="col-md-2">
                        <label class="form-label fw-semibold">State</label>
                        <select name="state_id" class="form-select">
                            <option value="">All States</option>
                            @foreach($states as $state)
                                <option value="{{ $state->id }}"
                                    {{ request('state_id') == $state->id ? 'selected' : '' }}>
                                    {{ $state->name }}
                                </option>
                            @endforeach
                        </select>
                    </div>

                    <div class="col-md-2">
                        <label class="form-label fw-semibold">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>

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


                    <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('bill.approval.admin.index') }}"class="btn btn-outline-secondary w-100">
                            Reset
                        </a>
                    </div>

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



    <div class="card shadow-sm">
        <div class="card-header bg-primary text-white">
            <h5 class="mb-0">W.H.S – Measurement Book List</h5>
        </div>

        <div class="card-body p-0">

            @if($query->count() === 0)
                <div class="alert alert-warning text-center m-3">
                    No data available. Please complete the quantity calculations first.
                </div>
            @else

            <div class="table-responsive">
                <table class="table table-bordered table-striped align-middle text-center">
                    <thead class="table-primary">
                        <tr>
                            <th>#</th>
                            <th>Unit</th>
                            <th>State</th>
                            <th>District</th>
                            <th>Block</th>
                            <th>App Code</th>
                            <th>Respondent Name</th>
                            <th>Mobile Number</th>
                            <th>Verification</th>
                            <th>Approval</th>
                            <th>Delete</th>
                            
                        </tr>
                    </thead>
                    <tbody>
                    @foreach($query as $index => $item)
                        <tr>
                            <td>{{ $query->firstItem() + $index }}</td>
                            <td>{{ $item->baseline->unit->name ?? 'N/A' }}</td>
                            <td>{{ $item->baseline->state->name ?? 'N/A' }}</td>
                            <td>{{ $item->baseline->district->name ?? 'N/A' }}</td>
                            <td>{{ $item->baseline->blocks->name ?? 'N/A' }}</td>
                            <td>{{ $item->baseline->application_code ?? 'N/A' }}</td>
                            <td>{{ $item->baseline->name_of_respondent ?? 'N/A' }}</td>
                            <td>{{ $item->baseline->mobile_number ?? 'N/A' }}</td>

                            {{-- Verification --}}
                            <td>
                                @if(Auth::user()->role_id == 2)
                                    @if(!isset($existingBaselineIds[$item->baseline_id]))
                                        <a href="{{ route('bill-approval.create', ['id' => $item->baseline_id]) }}"
                                           class="btn btn-sm btn-outline-success">Add</a>
                                    @else
                                        <a href="{{ route('bill-approval.show', $item->baseline_id) }}"
                                           class="btn btn-sm btn-outline-primary">View</a>
                                    @endif
                                @else
                                    @if(isset($existingBaselineIds[$item->baseline_id]) && $existingBaselineIds[$item->baseline_id]->present_status === 'Approved')
                                        <span class="badge bg-success  text-white">Approved</span>
                                    @elseif(isset($existingBaselineIds[$item->baseline_id]))
                                        <span class="badge bg-warning text-white">Pending</span>
                                    @else
                                       <span class="badge bg-red" style="color:white;">Unverified</span>

                                    @endif
                                @endif
                            </td>

                            {{-- Actions --}}
                
                        
                    <td>
                        @if(in_array($item->baseline_id, $approvedBaselineIds))
                            <a href="{{ route('bill-approval.show', $item->baseline_id) }}"
                            class="btn btn-sm btn-primary">
                                View
                            </a>
                        @else
                        @if($item->baseline_id)
                            <a href="{{ route('bill-approval.edit', $item->baseline_id) }}"
                            class="btn btn-sm btn-danger">
                                Approval
                            </a>
                            @endif
                        @endif
                    </td>
                    <td>
                    @if($item->baseline_id)
                        <form action="{{ route('bill-approval.destroy', $item->baseline_id) }}"
                            method="POST"
                            onsubmit="return confirm('Are you sure you want to delete this record?');"
                            style="display:inline;">
                            @csrf
                            @method('DELETE')

                            <button type="submit" class="btn btn-sm btn-danger">
                                Delete
                            </button>
                        </form>
                    @endif
                    </td>
                                
                    
                        </tr>
                    @endforeach
                    </tbody>
                </table>
            </div>

            {{-- Pagination --}}
            <div class="card-footer d-flex justify-content-between align-items-center">
                <div class="text-muted">
                    Showing {{ $query->firstItem() }}
                    to {{ $query->lastItem() }}
                    of {{ $query->total() }} records
                </div>

                <div>
                    {{ $query->withQueryString()->links('pagination::bootstrap-5') }}
                </div>
            </div>
            @endif
        </div>
    </div>
</div>
@endsection