@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">
                        Baseline Approval
                    </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="#" class="btn btn-1">New view</a>
	                    </span>
                        
                            <a href="{{ url('/print-pdf/' . $baseline->id) }}" target="_blank" class="btn btn-primary btn-5 d-none d-sm-inline-block">Print PDF</a>
                        
                    </div>
                    
                </div>
            </div>
	    </div>
    </div>
</div>



<!-- Page body -->
<div class="page-body">
	<div class="container-xl">      

<div class="card mb-4">
     <div class="card-header bg-info text-white d-flex justify-content-between align-items-center py-2 px-3">
        <h5 class="mb-0">Table no. 1.1 - Farmer Profile</h5>
    <button type="button" class="btn btn-light text-primary" data-bs-toggle="modal" data-bs-target="#actionModal">
        Action
    </button>
</div>




<div class="modal fade" id="actionModal" tabindex="-1" aria-labelledby="actionModalLabel" aria-hidden="true">
    <div class="modal-dialog modal-lg">
        <div class="modal-content">
            <div class="modal-header">
                <h7 class="modal-title" id="actionModalLabel">Action</h7>
                <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
            </div>
            <div class="modal-body">
                {{-- You can either embed details here or load content via AJAX --}}
            <iframe src="{{ url('farmers/baselineAction/' . $baseline->id) }}" width="100%" height="400px" frameborder="0"></iframe>
    
            </div>
        </div>
    </div>
</div>
    


<div class="page-body">
<div class="container-xl mb-4">
    <div class="card shadow-sm">
       

        <div class="card-body">
            <div class="table-responsive">
                <table class="table table-bordered table-striped table-vcenter align-middle">
                    <tbody>
                        <tr>
                            <th style="width: 40%">Application Number</th>
                            <td>{{ $baseline->application_code ?? 'N/A' }}</td>
                            @if($baseline->upload_respondent_photo)
                             <td rowspan="5" class="text-center align-middle" style="width: 200px; vertical-align: middle;">
                                <img src="{{ asset('storage/' . $baseline->upload_respondent_photo) }}"
                                    alt="Respondent Photo"
                                    class="img-thumbnail border border-primary"
                                    style="width: 180px; height: 220px; object-fit: cover; border-radius: 8px;">
                            </td>
                            @endif
                        </tr>
                        <tr>
                            <th>Name of TSF Operational Area/Unit</th>
                            <td>{{ $baseline->unit->name ?? 'N/A' }}</td>
                        </tr>
                        <tr>
                            <th>State Name</th>
                            <td>{{ $baseline->state->name ?? 'N/A' }}</td>
                        </tr>
                        <tr>
                            <th>Date of Survey</th>
                            <td>{{ \Carbon\Carbon::parse($baseline->date_of_survey)->format('d-m-Y') ?? 'N/A' }}</td>
                        </tr>
                        <tr>
                            <th>Year of Baseline Survey</th>
                            <td>{{ $baseline->financialYear->name ?? 'N/A' }}</td>
                        </tr>

                        <!-- Remaining rows (no image column) -->
                        <tr>
                            <th>District Name</th>
                            <td colspan="2">{{ $baseline->district->name ?? 'N/A' }}</td>
                        </tr>
                        <tr>
                            <th>Block Name</th>
                            <td colspan="2">{{ $baseline->block->name ?? 'N/A' }}</td>
                        </tr>
                        <tr>
                            <th>Panchayat Name</th>
                            <td colspan="2">{{ $baseline->panchayat->name ?? 'N/A' }}</td>
                        </tr>
                        <tr>
                            <th>Village Name</th>
                            <td colspan="2">{{ $baseline->village->name ?? 'N/A' }}</td>
                        </tr>
                        <tr>
                            <th>WHS (Project Type)</th>
                            <td colspan="2">{{ $baseline->projectType->name ?? 'N/A' }}</td>
                        </tr>
                        <tr>
                            <th>Name of Respondent</th>
                            <td colspan="2">{{ $baseline->name_of_respondent ?? 'N/A' }}</td>
                        </tr>
                        <tr>
                            <th>Mobile Number</th>
                            <td colspan="2">{{ $baseline->mobile_number ?? 'N/A' }}</td>
                        </tr>
                        <tr>
                            <th>Alternate Mobile Number</th>
                            <td colspan="2">{{ $baseline->alternet_mobile_number ?? 'N/A' }}</td>
                        </tr>
                    </tbody>
                </table>
            </div>
        </div>
    </div>
</div>





<div class="container">
<div class="card mb-2 ">
    <div class="card-header bg-secondary-lt text-white d-flex justify-content-between align-items-center">
        <h5 class="mb-0">Table 1.2 - Family Members</h5>
    </div>
    <div class="card-body">
        @if($baseline->households->count())
            <div class="table-responsive">
                <table class="table table-bordered table-striped table-sm align-middle text-center">
                    <thead class="table-light">
                        <tr>
                            <th>Name</th>
                            <th>Age</th>
                            <th>Gender</th>
                            <th>Category</th>
                            <th>Education Level</th>
                        </tr>
                    </thead>
                    <tbody>
                        @foreach ($baseline->households as $member)
                            <tr>
                                <td>{{ $member->name ?? 'N/A' }}</td>
                                <td>{{ $member->age ?? 'N/A' }}</td>
                                <td>{{ ucfirst($member->gender) ?? 'N/A' }}</td>
                                <td>{{ $member->category ?? 'N/A' }}</td>
                                <td>{{ $member->education_level ?? 'N/A' }}</td>
                            </tr>
                        @endforeach
                    </tbody>
                </table>
            </div>
        @else
            <p>No family members recorded.</p>
        @endif
    </div>
</div>
</div>






<div class="container">
    

    <!-- WHS Planning Card -->
    <div class="card mb-2">
    
    {{-- Table 1.3: Land Holding Information --}}

        <div class="card-header bg-info  text-white">Table 1.3 - Land Holding Information</div>
        <div class="card-body">
            @if($baseline->lands && $baseline->lands->count())
                <table class="table table-bordered text-center">
                    <thead>
                        <tr>
                            <th>Plot/Khata</th>
                            <th>Type of Land</th>
                            <th>Total Area (Acre)</th>
                            <th>Irrigated Area  (Acre)</th>
                            <th>Non-Irrigated Area  (Acre)</th>
                            <th>Sources of Irrigation</th>
                        </tr>
                    </thead>
                    <tbody>
                        @foreach($baseline->lands as $land)
                        <tr>
                            <td>{{ $land->plot_khata }}</td>
                            <td>{{ $land->land_type }}</td>
                            <td>{{ $land->area }}</td>
                            <td>{{ $land->irrigated_area }}</td>
                            <td>{{ $land->non_irrigated_area }}</td>
                            <td>
                                @if(is_array($land->irrigation_sources))
                                    {{ implode(', ', $land->irrigation_sources) }}
                                @else
                                    {{ $land->irrigation_sources }}
                                @endif
                            </td>
                        </tr>
                        @endforeach
                    </tbody>


                    <tfoot class="bg-light">
                    <tr>
                        <th colspan="5" class="text-end">Total Land:</th>
                        <th colspan="1">{{ number_format($baseline->lands->sum('area'), 2) }} Acre</th>
                    </tr>
                </tfoot>




                </table>
            @else
                <p>No land information available.</p>
            @endif
        </div>



    </div>

    {{-- Repeat similar blocks for livestocks, waterUserGroups, etc. --}}
</div>

</div>




<div class="container">
    

    <!-- WHS Planning Card -->
    <div class="card mb-4">
    <div class="card-header bg-secondary-lt text-white d-flex justify-content-between align-items-center">
        <h5 class="mb-0">Table 1.4 - Water Harvesting Structures Planning</h5>
    </div>
    <div class="card-body">
        <div class="table-responsive">
            <table class="table table-bordered table-striped table-sm align-middle text-center">
                <thead class="table-light">
                    <tr>
                        <th>Type of Structure</th>
                        <th>Length (m)</th>
                        <th>Width (m)</th>
                        <th>Depth/Height (m)</th>
                        <th>Latitude</th>
                        <th>Longitude</th>
                        <th>Geotagged Pre-Photos</th>
                    </tr>
                </thead>
                <tbody>
                    @foreach ($baseline->waterHarvestingStructuresPlanning as $waterHarvesting)
                        <tr>
                            <td>{{ $waterHarvesting->projectType->name ?? '-' }}</td>
                            <td>{{ $waterHarvesting->length ?? 'N/A' }}</td>
                            <td>{{ $waterHarvesting->width ?? 'N/A' }}</td>
                            <td>{{ $waterHarvesting->depth_or_height ?? 'N/A' }}</td>
                            <td>{{ isset($waterHarvesting->latitude) ? number_format($waterHarvesting->latitude, 6) : 'N/A' }}</td>
                            <td>{{ $waterHarvesting->longitude ?? 'N/A' }}</td>
                            <td>
                                @if ($waterHarvesting->geotagged_file)
                                    <a href="{{ asset('storage/' . $waterHarvesting->geotagged_file) }}" target="_blank">View Photo</a>
                                @else
                                    N/A
                                @endif
                            </td>
                        </tr>
                    @endforeach
                </tbody>
            </table>
        </div>
    </div>
</div>







 <div class="card mb-4">
    

 <div class="card-header bg-info text-white d-flex justify-content-between align-items-center">
        <h5 class="mb-0">Uploaded Documents</h3>
    </div>

    <div class="card-body">
        <div class="row g-3">
            <!-- Beneficiary Agreement -->
            <div class="col-md-4">
                <div class="card card-border shadow-sm">
                    <div class="card-body">
                        <label class="form-label">Beneficiary Agreement Form</label>
                        @if(optional($baseline->documentUpload)->beneficiary_agreement)
                                <a href="{{ asset('storage/' . $baseline->documentUpload->beneficiary_agreement) }}"
                                target="_blank" class="btn btn-sm btn-outline-primary w-100 mt-2">
                                    <i class="ti ti-file-description me-1"></i> View PDF
                                </a>
                            @else
                                <p class="text-muted mt-2">Not Uploaded</p>
                            @endif                   
                         </div>
                </div>
            </div>

            <!-- Khata Document -->
            <div class="col-md-4">
                <div class="card card-border shadow-sm">
                    <div class="card-body">
                        <label class="form-label">Plot/Khata Ownership Document</label>
                       @if(optional($baseline->documentUpload)->khata_document)
                        <a href="{{ asset('storage/' . $baseline->documentUpload->khata_document) }}"
                        target="_blank" class="btn btn-sm btn-outline-primary w-100 mt-2">
                            <i class="ti ti-file-description me-1"></i> View PDF
                        </a>
                    @else
                        <p class="text-muted mt-2">Not Uploaded</p>
                    @endif
                    </div>
                </div>
            </div>

            <!-- Other Document -->
            <div class="col-md-4">
                <div class="card card-border shadow-sm">
                    <div class="card-body">
                        <label class="form-label">Other Document</label>
                    @if(optional($baseline->documentUpload)->other_document)
                            <a href="{{ asset('storage/' . $baseline->documentUpload->other_document) }}"
                            target="_blank" class="btn btn-sm btn-outline-primary w-100 mt-2">
                                <i class="ti ti-file-description me-1"></i> View PDF
                            </a>
                        @else
                            <p class="text-muted mt-2">Not Uploaded</p>
                        @endif
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>







    <!-- WHS Feasibility Card -->
     <div class="card mb-4">
    <div class="card-header bg-secondary-lt text-white d-flex justify-content-between align-items-center">
        <h5 class="mb-0">Table 1.5: WHS Technical Feasibility</h4>
    </div>

    <div class="card-body p-2">
        <div class="table-responsive">
            <table class="table table-bordered table-hover text-center">
                <thead class="bg-light">
                    <tr>
                        <th>Catchment Area (ha)</th>
                        <th>Land Slope</th>
                        
                        <th>Geological Location</th>
                                                <th>Hydrological Location</th>
                        <th>Distance from Drainage (m)</th>
                        <th>LULC</th>
                    </tr>
                </thead>
                <tbody>
                    <tr>
                        <td>{{ $baseline->TechnicalFeasibility->catchment_area ?? 'N/A' }}</td>
                        <td>{{ $baseline->TechnicalFeasibility->land_slope ?? 'N/A' }}</td>
                        
                        <td>{{ $baseline->TechnicalFeasibility->geological_location ?? 'N/A' }}</td>
                        
                        <td>{{ $baseline->TechnicalFeasibility->hydrological_location ?? 'N/A' }}</td>
                        <td>{{ $baseline->TechnicalFeasibility->distance_from_drainage_line ?? 'N/A' }}</td>
                        <td>{{ isset($baseline->TechnicalFeasibility->lulc) ? Str::ucfirst($baseline->TechnicalFeasibility->lulc) : 'N/A' }}</td>
                    </tr>
                </tbody>
                <tfoot class="bg-light">
                    <tr>
                        <th colspan="4" class="text-end">Total Score:</th>
                        <th colspan="2">{{ $baseline->TechnicalFeasibility->technical_feasibility_score ?? '0.00' }}</th>
                    </tr>
                </tfoot>
            </table>
        </div>
    </div>
</div>





 
 <div class="card mb-4">
    <div class="card-header bg-info text-white d-flex justify-content-between align-items-center">
        <h5 class="mb-0">Table 1.6: Water User Group</h3>
    </div>

    <div class="card-body p-2">
        <div class="table-responsive">
            <table class="table table-bordered table-hover text-center">
                <thead class="bg-light">
                    <tr>
                        <th>S.No.</th>
                        <th>Name of Beneficiary</th>
                        <th>Category</th>
                        <th>Plot/Khata No.</th>
                        <th>Land Area (Acre)</th>
                        <th>Type of Farmer</th>
                        <th>Potential Irrigation (Acre)</th>
                    </tr>
                </thead>
                <tbody>
                    @php
                        $totalLand = 0;
                    @endphp
                    @foreach ($baseline->waterUserGroups as $index => $group)
                        @php
                            $landArea = $group->land_comment ?? 0;
                            $totalLand += $landArea;
                        @endphp
                        <tr>
                            <td>{{ $index + 1 }}</td>
                            <td>{{ \Illuminate\Support\Str::title($group->name_of_beneficiary ?? 'N/A') }}</td>
                            <td>{{ $group->category ?? 'N/A' }}</td>
                            <td>{{ $group->plot_khata_no ?? 'N/A' }}</td>
                            <td>{{ number_format($landArea, 2) }}</td>



                    
                                <td>
    @if($landArea > 0 && $landArea <= 2.5)
        Marginal Farmer
    @elseif($landArea > 2.5 && $landArea <= 5)
        Small Farmer
    @elseif($landArea > 5 && $landArea <= 10)
        Medium Farmer
    @elseif($landArea > 10)
        Big Farmer
    @else
        N/A
    @endif
</td>
                            
                            <td>{{ number_format($group->potential_irrigation ?? 0, 2) }}</td>
                        </tr>
                    @endforeach
                </tbody>
                <tfoot class="bg-light">
                    <tr>
                        <th colspan="5" class="text-end">Total Land (Acre)</th>
                        <th colspan="2">{{ number_format($totalLand, 2) }}</th>
                    </tr>
                </tfoot>
            </table>
        </div>
    </div>
</div>




 <div class="card mb-4">
    <div class="card-header bg-secondary-lt text-white d-flex justify-content-between align-items-center">
        <h5 class="mb-0">Table 1.7: Crop Details</h3>
    </div>

    <div class="card-body p-2">
        <div class="table-responsive">
            <table class="table table-bordered table-hover text-center align-middle">
                <thead class="bg-light">
                    <tr>
                        <th>S.No.</th>
                        <th>Farmer's name</th>
                        <th>Season</th>
                        <th>Category</th>
                        <th>Crop</th>
                        <th>Area (Acre)</th>
                        <th>Production (Qtl)</th>
                        <th>Productivity</th>
                        <th>Market Rate (₹/Qtl)</th>
                        <th>Total Income (₹)</th>
                        <th>Cost (₹)</th>
                        <th>Net Income (₹)</th>
                    </tr>
                </thead>
                <tbody>
@php
    $totalIncome = 0;
    // Group crops by beneficiary
    $groupedCrops = $baseline->croppings->groupBy(function($item) {
        return $item->WaterUserGroup->name_of_beneficiary ?? 'N/A';
    });
    $serial = 1;
@endphp

@foreach($groupedCrops as $beneficiary => $crops)
    @php $rowspan = $crops->count(); $first = true; @endphp
    @foreach($crops as $crop)
        @php $totalIncome += $crop->profit ?? 0; @endphp
        <tr>
            @if($first)
                <td rowspan="{{ $rowspan }}">{{ $serial++ }}</td>
                <td rowspan="{{ $rowspan }}">{{ $beneficiary }}</td>
                @php $first = false; @endphp
            @endif
            <td>{{ $crop->season->name ?? 'N/A' }}</td>
            <td>{{ $crop->category->name ?? 'N/A' }}</td>
            <td>{{ $crop->crop->name ?? 'N/A' }}</td>
            <td>{{ $crop->cultivation ?? 'N/A' }}</td>
            <td>{{ $crop->production ?? 'N/A' }}</td>
            <td>{{ $crop->productivity ?? 'N/A' }}</td>
            <td>{{ $crop->market_rate ?? 'N/A' }}</td>
            <td>{{ number_format($crop->total_income ?? 0, 2) }}</td>
            <td>{{ number_format($crop->cost ?? 0, 2) }}</td>
            <td>{{ number_format($crop->profit ?? 0, 2) }}</td>
        </tr>
    @endforeach
@endforeach
</tbody>

                <tfoot class="bg-light">
                    <tr>
                        <th colspan="10" class="text-end">Total Net Income (₹)</th>
                        <th colspan="2">{{ number_format($totalIncome, 2) }}</th>
                    </tr>
                </tfoot>
            </table>
        </div>
    </div>
</div>





 <div class="card mb-4">
    <div class="card-header bg-info text-white d-flex justify-content-between align-items-center">
        <h5 class="mb-0">Table 1.8: Livestock Details</h3>
    </div>

    <div class="card-body p-2">
        <div class="table-responsive">
            <table class="table table-bordered table-hover text-center align-middle">
    <thead class="bg-light">
        <tr>
            <th>S.No.</th>
            <th>Farmer's Name</th>
            <th>Name of Livestock</th>
            <th>Number</th>
            <th>Purpose of Rearing</th>
            <th>Total Income (₹)</th>
            <th>Cost of Rearing (₹)</th>
            <th>Net Income (₹)</th>
        </tr>
    </thead>
    <tbody>
        @php
            $totalNetIncome = 0;
            $serial = 1;

            // Group livestocks by beneficiary
            $groupedLivestocks = $baseline->livestocks->groupBy(function($item) {
                return $item->WaterUserGroup->name_of_beneficiary ?? 'N/A';
            });
        @endphp

        @foreach($groupedLivestocks as $beneficiary => $livestocks)
            @php $rowCount = $livestocks->count(); @endphp

            @foreach($livestocks as $index => $livestock)
                @php
                    $netIncome = ($livestock->total_income ?? 0) - ($livestock->cost_rearing ?? 0);
                    $totalNetIncome += $netIncome;
                @endphp
                <tr>
                    @if($index === 0)
                        <td rowspan="{{ $rowCount }}">{{ $serial++ }}</td>
                        <td rowspan="{{ $rowCount }}">{{ $beneficiary }}</td>
                    @endif
                    <td>{{ $livestock->name ?? 'N/A' }}</td>
                    <td>{{ $livestock->number ?? 'N/A' }}</td>
                    <td>{{ $livestock->purpose_rearing ?? 'N/A' }}</td>
                    <td>{{ number_format($livestock->total_income ?? 0, 2) }}</td>
                    <td>{{ number_format($livestock->cost_rearing ?? 0, 2) }}</td>
                    <td>{{ number_format($netIncome, 2) }}</td>
                </tr>
            @endforeach
        @endforeach
    </tbody>
    <tfoot class="bg-light">
        <tr>
            <th colspan="7" class="text-end">Total Net Income (₹)</th>
            <th>{{ number_format($totalNetIncome, 2) }}</th>
        </tr>
    </tfoot>
</table>

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




<div class="card mb-4">
    <div class="card-header  bg-secondary-lt text-white d-flex justify-content-between align-items-center">
        <h5 class="mb-0">Table 1.9: Other Allied Sector Report</h5>
    </div>

    <div class="card-body p-2">
        <div class="table-responsive">
            <table class="table table-bordered table-hover text-center align-middle">
                <thead class="bg-light">
                    <tr>
                        <th>S.No.</th>
                        <th>Farmer's Name</th>

                        <th>Allied Sector</th>
                        <th>Annual Production</th>
                        <th>Unit of Measurement</th>
                        <th>Market Rate (₹)</th>
                        <th>Total Income (₹)</th>
                        <th>Annual Expenditure (₹)</th>
                        <th>Net Income (₹)</th>
                    </tr>
                </thead>
                <tbody>
    @php
        $serial = 1;
        $grouped = $baseline->alliedsectors->groupBy(function($item) {
            return optional($item->WaterUserGroup)->name_of_beneficiary;
        });
    @endphp

    @foreach($grouped as $beneficiary => $sectors)
        @foreach($sectors as $rowIndex => $sector)
            <tr>
                @if($rowIndex === 0)
                    <td rowspan="{{ $sectors->count() }}">{{ $serial++ }}</td>
                    <td rowspan="{{ $sectors->count() }}">{{ $beneficiary ?? 'N/A' }}</td>
                @endif
                <td>{{ $sector->sector_name ?? 'N/A' }}</td>
                <td>{{ $sector->annual_production ?? 'N/A' }}</td>
                <td>{{ $sector->unit_of_measurement ?? 'N/A' }}</td>
                <td>{{ number_format($sector->market_rate ?? 0, 2) }}</td>
                <td>{{ number_format($sector->total_income ?? 0, 2) }}</td>
                <td>{{ number_format($sector->annual_expenditure ?? 0, 2) }}</td>
                <td>{{ number_format($sector->net_income ?? 0, 2) }}</td>
            </tr>
        @endforeach
    @endforeach
</tbody>
<tfoot class="bg-light">
    <tr>
        <th colspan="8" class="text-end">Total Net Income (₹)</th>
        <th>{{ number_format($baseline->alliedsectors->sum('net_income'), 2) }}</th>
    </tr>
</tfoot>

            </table>
        </div>
    </div>
</div>








<div class="card mb-4">
    <div class="card-header bg-info text-white d-flex justify-content-between align-items-center">
        <h5 class="mb-0">Table 1.9 - Micro Enterprises / Small Business</h5>
    </div>

    <div class="card-body">
        @if($baseline->microEnterprises->count())
            <div class="table-responsive">
                <table class="table table-bordered table-striped table-sm align-middle text-center">
                    <thead class="table-light">
                        <tr>
                            <th>S.No.</th>
                            <th>Farmer's Name</th>
                            <th>Business Name</th>
                            <th>Entrepreneur Name</th>
                            <th>Persons Employed</th>
                            <th>Total Income</th>
                            <th>Annual Expenditure</th>
                            <th>Net Income</th>
                            <th>Registration Status</th>
                        </tr>
                    </thead>
                    <tbody>
    @php
        $serial = 1;
        $grouped = $baseline->microEnterprises->groupBy(function($item) {
            return optional($item->waterUserGroup)->name_of_beneficiary;
        });
    @endphp

    @foreach($grouped as $beneficiary => $enterprises)
        @foreach($enterprises as $index => $enterprise)
            <tr>
                @if($index === 0)
                    <td rowspan="{{ $enterprises->count() }}">{{ $serial++ }}</td>
                    <td rowspan="{{ $enterprises->count() }}">{{ $beneficiary ?? 'N/A' }}</td>
                @endif
                <td>{{ $enterprise->business_name ?? 'N/A' }}</td>
                <td>{{ $enterprise->entrepreneur_name ?? 'N/A' }}</td>
                <td>{{ $enterprise->persons_employed ?? 'N/A' }}</td>
                <td>{{ number_format($enterprise->total_income ?? 0, 2) }}</td>
                <td>{{ number_format($enterprise->annual_expenditure ?? 0, 2) }}</td>
                <td>{{ number_format($enterprise->net_income ?? 0, 2) }}</td>
                <td>{{ $enterprise->registration_status ?? 'N/A' }}</td>
            </tr>
        @endforeach
    @endforeach
</tbody>
<tfoot>
    <tr>
        <th colspan="8" class="text-end">Total Net Income (₹)</th>
        <th>{{ number_format(optional($baseline->microEnterprises)->sum('net_income') ?? 0, 2) }}</th>
    </tr>
</tfoot>
                </table>
            </div>
        @else
            <div class="alert alert-warning mb-0">
                No data available. This household is <strong>not engaged in any Micro Enterprises or Small Business</strong>.
            </div>
        @endif
    </div>
</div>







 <div class="card mb-4">
    <div class="card-header bg-secondary-lt text-white d-flex justify-content-between align-items-center">
        <h5 class="mb-0">Table 1.10: Daily Wage Labor</h5>
    </div>

    <div class="card-body p-2">
        @if($baseline->dailyWageLabors->count())
            <div class="table-responsive">
                <table class="table table-bordered table-hover align-middle text-center">
                    <thead class="bg-light">
                        <tr>
                             <th>S.No.</th>
                            <th>Farmer's Name</th>
                            <th>No. of Family Members</th>
                            <th>Working Days</th>
                            <th>Seasonal / Year-round</th>
                            <th>Distance from Home (km)</th>
                            <th>Wage Rate (₹)</th>
                            <th>Net Income (₹)</th>
                        </tr>
                    </thead>
                    <tbody>
    @php
        $serial = 1;
        $totalNetIncome = 0;

        // Group labor records by beneficiary name
        $grouped = $baseline->dailyWageLabors->groupBy(function($item) {
            return optional($item->waterUserGroup)->name_of_beneficiary;
        });
    @endphp

    @foreach($grouped as $beneficiary => $labors)
        @foreach($labors as $index => $labor)
            @php
                $totalNetIncome += $labor->net_income ?? 0;
            @endphp
            <tr>
                @if($index === 0)
                    <td rowspan="{{ $labors->count() }}">{{ $serial++ }}</td>
                    <td rowspan="{{ $labors->count() }}">{{ $beneficiary ?? 'N/A' }}</td>
                @endif
                  
                <td>{{ $labor->no_of_family_members ?? 'N/A' }}</td>
                <td>{{ $labor->working_days ?? 'N/A' }}</td>
                <td>{{ $labor->seasonal_or_year_round ?? 'N/A' }}</td>
                <td>{{ $labor->distance_from_home_km ?? 'N/A' }}</td>
                <td>{{ number_format($labor->wage_rate ?? 0, 2) }}</td>
                <td>{{ number_format($labor->net_income ?? 0, 2) }}</td>
            </tr>
        @endforeach
    @endforeach

    <tr>
        <th colspan="7" class="text-end">Total Net Income (₹)</th>
        <th>{{ number_format($totalNetIncome, 2) }}</th>
    </tr>
</tbody>

                </table>
            </div>
        @else
            <div class="alert alert-warning mb-0">
                <strong>No data available:</strong> This household has no Daily Wage Labor records.
            </div>
        @endif
    </div>
</div>













 <div class="card mb-4">
    <div class="card-header bg-info text-white d-flex justify-content-between align-items-center">
        <h5 class="mb-0">Table 1.11 - Source of Family Income</h5>
    </div>
    <div class="card-body">
    @if($baseline->sourceOfFamilyIncome->count())
        <div class="table-responsive">
@php
    // Group income sources by beneficiary name
    $groupedSources = $baseline->sourceOfFamilyIncome->groupBy(function($item) {
        return $item->waterUserGroup->name_of_beneficiary ?? 'N/A';
    });

    $serial = 1;

    // Calculate total annual income
    $totalAnnualIncome = $baseline->sourceOfFamilyIncome->sum('annual_income');
@endphp

<table class="table table-bordered table-striped table-sm align-middle text-center">
    <thead class="table-light">
        <tr>
            <th>S.No.</th>
            <th>Farmer's Name</th>
            <th>Occupation</th>
            <th>Source Type</th>
            <th>No of Days Engagement</th>
            <th>Member Involved</th>
            <th>Annual Income (₹)</th>
        </tr>
    </thead>
    <tbody>
        @foreach($groupedSources as $beneficiary => $sources)
            @php $rowspan = $sources->count(); $first = true; @endphp
            @foreach($sources as $source)
                <tr>
                    @if($first)
                        <td rowspan="{{ $rowspan }}">{{ $serial++ }}</td>
                        <td rowspan="{{ $rowspan }}">{{ $beneficiary }}</td>
                        @php $first = false; @endphp
                    @endif
                    <td>{{ $source->occupation ?? 'N/A' }}</td>
                    <td>{{ $source->source_type ?? 'N/A' }}</td>
                    <td>{{ $source->no_of_days_engagement ?? 'N/A' }}</td>
                    <td>{{ $source->member_involved ?? 'N/A' }}</td>
                    <td>{{ number_format($source->annual_income ?? 0, 2) }}</td>
                </tr>
            @endforeach
        @endforeach
    </tbody>
    <tfoot class="bg-light">
        <tr>
            <th colspan="6" class="text-end">Total Income (₹)</th>
            <th>{{ number_format($totalAnnualIncome, 2) }}</th>
        </tr>
    </tfoot>
</table>
        </div>
    @else
        <div class="alert alert-warning mb-0">
            No data available. This household has <strong>no sources of family income</strong>.
        </div>
    @endif
</div>

</div>





@endsection