@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">W.H.S Pre-level Report</h2>
            </div>
            <div class="col-auto ms-auto d-print-none">
                <div class="btn-list">

                <a href="{{ url('/billapproval-pdf/' . $baseline->id) }}" class="btn btn-1">PDF-Download</a>
                    
                    <a href="{{ route('export.excel') }}" class="btn btn-outline-success">
                        <i class="ti ti-file-spreadsheet me-1"></i> Download Excel Report
                    </a>
                </div>
            </div>
        </div>
    </div>
</div>
<div class="page-body">
    <div class="container-xl">
        <div class="card mb-4 shadow-sm">
            <div class="card-header bg-primary text-white">
                Bill Approval Report
            </div>

            <div class="card-body">
                <!-- Section: Project & Location -->
                <div class="text-center border rounded py-3 mb-4 bg-light">
                    <h5 class="mb-1 text-uppercase fw-bold">Water Harvesting Structure</h5>
                    <span class="text-secondary">Details for Bill Approval - Farm Pond</span>
                </div>

                <div class="row mb-3">
                    <div class="col-md-4"><strong>Name of PIA:</strong> {{ $baseline->baseline->project->pia->name ?? 'N/A' }}</div>
                    <div class="col-md-2"><strong>Village:</strong> {{ $baseline->baseline->village->name ?? 'N/A' }}</div>
                    <div class="col-md-2"><strong>Panchayat:</strong> {{ $baseline->baseline->panchayat->name ?? 'N/A' }}</div>
                    <div class="col-md-2"><strong>Block:</strong> {{ $baseline->baseline->block->name ?? 'N/A' }}</div>
                    <div class="col-md-2"><strong>District:</strong> {{ $baseline->baseline->district->name ?? 'N/A' }}</div>
                </div>

                <div class="row mb-3">
                    <div class="col-md-3"><strong>Unit:</strong> {{ $baseline->unit_id ?? 'N/A' }}</div>
                    <div class="col-md-3"><strong>State:</strong> {{ $baseline->state_id }}</div>
                    <div class="col-md-3"><strong>Application Code:</strong> {{ $baseline->application_code }}</div>
                    <div class="col-md-3"><strong>Financial Year:</strong> {{ $baseline->financial_year_id }}</div>
                </div>

                <!-- Beneficiary Info -->
                <div class="row mb-4">
                    <div class="col-md-6"><strong>Beneficiary Name:</strong> {{ $baseline->baseline->name_of_respondent ?? 'N/A' }}</div>
                    <div class="col-md-6"><strong>Plot No:</strong> {{ $baseline->baseline->land->plot_khata ?? 'N/A' }}</div>
                </div>

                <!-- Activity Table -->
                <div class="table-responsive">
                    <table class="table table-bordered table-sm align-middle text-center">
                        <thead class="table-info">
                            <tr>
                                <th rowspan="2">Sl.No.</th>
                                <th rowspan="2">Activity Name</th>
                                <th colspan="3">Estimated</th>
                                <th rowspan="2">Unit</th>
                                <th colspan="3">Actual</th>
                                <th rowspan="2">Bill Date</th>
                                <th rowspan="2">GPS Reading</th>
                                <th rowspan="2">Present Status</th>
                                <th rowspan="2">Remarks</th>
                            </tr>
                            <tr>
                                <th>Qty</th><th>Rate</th><th>Amount</th>
                                <th>Qty</th><th>Rate</th><th>Amount</th>
                            </tr>
                        </thead>
                        <tbody>
                            @foreach ($readings as $index => $item)
                            <tr>
                                <td>{{ $item['serial_no'] ?? $index+1 }}</td>
                                <td class="text-start">{{ $item['activity_name'] ?? 'N/A' }}</td>
                                <td>{{ $item['estimated_quantity'] ?? 0 }}</td>
                                <td>{{ $item['estimated_rate'] ?? 0 }}</td>
                                <td>{{ $item['estimated_amount'] ?? 0 }}</td>
                                <td>{{ $item['unit'] ?? '' }}</td>
                                <td>{{ $item['qty'] ?? 0 }}</td>
                                <td>{{ $item['rate'] ?? 0 }}</td>
                                <td>{{ $item['amount'] ?? 0 }}</td>
                                @if ($loop->first)
                                <td rowspan="{{ count($readings) }}">{{ $bill->bill_date ?? 'N/A' }}</td>
                                <td rowspan="{{ count($readings) }}">{{ $bill->gps_reading ?? 'N/A' }}</td>
                                <td rowspan="{{ count($readings) }}">{{ $bill->present_status ?? 'N/A' }}</td>
                                <td rowspan="{{ count($readings) }}">{{ $bill->remarks ?? 'N/A' }}</td>
                                @endif
                            </tr>
                            @endforeach

                            @if ($measurementBook)
                            <tr><td colspan="8" class="text-end fw-bold">Total</td><td>{{ number_format($measurementBook->total, 2) }}</td></tr>
                            <tr><td colspan="8" class="text-end fw-bold">GST (18%)</td><td>{{ number_format($measurementBook->gst, 2) }}</td></tr>
                            <tr><td colspan="8" class="text-end fw-bold">Grand Total</td><td class="fw-bold">{{ number_format($measurementBook->grand_total, 2) }}</td></tr>
                            @endif
                        </tbody>
                    </table>
                </div>

                <!-- Photographs -->
                <div class="row mt-4">
                    @php
                        $photos = [
                            'Earthwork Photograph' => $baseline->earthwork_photograph,
                            'Inlet Photograph' => $baseline->inlet,
                            'Masonry Outlet Photograph' => $baseline->masonry_outlet,
                            'Masonry Outlet Outer Photograph' => $baseline->masonry_outlet_outer,
                            'Display Board Photograph' => $baseline->display_board,
                        ];
                    @endphp
                    @foreach ($photos as $title => $path)
                        <div class="col-md-6 mb-4">
                            <div class="card">
                                <div class="card-header"><h5 class="card-title">{{ $title }}</h5></div>
                                 <div class="card-body text-center">
                                    @if ($path)
                                        <img src="{{ asset('storage/' . $path) }}" alt="{{ $title }}" class="img-fluid rounded shadow-sm">
                                    @else
                                        <p class="text-muted">No image available</p>
                                    @endif
                                </div>
                            </div>
                        </div>
                    @endforeach
                </div>

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