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

<div class="container mt-4">
<div class="row row-deck row-cards mb-4">

    <!-- Total Surveys -->
    <div class="col-sm-6 col-lg-2">
        <div class="card border-0">
            <div class="card-body  bg-info text-center">
                <div class="mb-0 text-white">{{ $totalSurveys }}</div>
                <div class="text-white">Total Surveys</div>
            </div>
        </div>
    </div>

    <!-- Unique Applications -->
    <div class="col-sm-6 col-lg-2">
        <div class="card border-0">
            <div class="card-body text-center">
                <div class="    mb-0">{{ $uniqueApplications }}</div>
                <div class="text-muted">Applications</div>
            </div>
        </div>
    </div>

    <!-- Pending -->
    <div class="col-sm-6 col-lg-2">
        <div class="card border-0">
            <div class="card-body bg-success text-center">
                <div class="mb-0">{{ $statusCounts['Pending'] ?? 0 }}</div>
                <div class="text-white">Pending</div>
            </div>
        </div>
    </div>

    <!-- Approved -->
    <div class="col-sm-6 col-lg-2">
        <div class="card border-0">
            <div class="card-body text-center">
                <div class="h3 mb-0 text-green">{{ $statusCounts['Approved'] ?? 0 }}</div>
                <div class="text-muted">Approved</div>
            </div>
        </div>
    </div>

    <!-- Needs Correction -->
    <div class="col-sm-6 col-lg-2">
        <div class="card border-0">
            <div class="card-body bg-danger text-center">
                <div class="mb-0 ">{{ $statusCounts['Needs Correction'] ?? 0 }}</div>
                <div class="">Needs Correction</div>
            </div>
        </div>
    </div>

    <!-- Rejected -->
    <div class="col-sm-6 col-lg-2">
        <div class="card border-0">
            <div class="card-body  text-center">
                
                <div class="h3 mb-0 ">{{ $statusCounts['Rejected'] ?? 0 }}</div>
                <div class="">Rejected</div>
            </div>
        </div>
    </div>

</div>



















    <!-- Project Wise Table -->
    <div class="card mb-3 shadow-sm">
        <div class="card-header bg-light  fw-bold">
            Project-wise Surveys
        </div>
        <div class="card-body p-0">
            <table class="table table-striped table-hover table-bordered mb-0 text-center">
                <thead class="table-dark">
                    <tr>
                        <th>Project Type</th>
                        <th>Total Surveys</th>
                    </tr>
                </thead>
                <tbody>
                    @forelse($projectWise as $project)
                        <tr>
                            <td>{{ $project->projectType->name }}</td>
                            <td>{{ $project->total }}</td>
                        </tr>
                    @empty
                        <tr><td colspan="2" class="text-center">No data available</td></tr>
                    @endforelse
                </tbody>
            </table>
        </div>
    </div>

    <!-- Block Wise Table -->
    <div class="card mb-3 shadow-sm">
        <div class="card-header bg-info text-white fw-bold">
            Block-wise Surveys
        </div>
        <div class="card-body p-0">
            <table class="table table-striped table-hover table-bordered mb-0 text-center">
                <thead class="table-dark">
                    <tr>
                        <th>Block</th>
                        <th>Total Surveys</th>
                    </tr>
                </thead>
                <tbody>
                    @forelse($blockWise as $block)
                        <tr>
                            <td>{{ $block->block->name }}</td>
                            <td>{{ $block->total }}</td>
                        </tr>
                    @empty
                        <tr><td colspan="2" class="text-center">No data available</td></tr>
                    @endforelse
                </tbody>
            </table>
        </div>
    </div>

    <!-- Year Wise Table -->
    <div class="card mb-3 shadow-sm">
        <div class="card-header bg-light fw-bold">
            Financial Year-wise Surveys
        </div>
        <div class="card-body p-0">
            <table class="table table-striped table-hover table-bordered mb-0 text-center">
                <thead class="table-dark">
                    <tr>
                        <th>Financial Year</th>
                        <th>Total Surveys</th>
                    </tr>
                </thead>
                <tbody>
                    @forelse($yearWise as $year)
                        <tr>
                            <td>{{ $year->financialYear->name }}</td>
                            <td>{{ $year->total }}</td>
                        </tr>
                    @empty
                        <tr><td colspan="2" class="text-center">No data available</td></tr>
                    @endforelse
                </tbody>
            </table>
        </div>
    </div>

    <!-- Gender Distribution -->
    <div class="card mb-3 shadow-sm">
            <div class="card-header bg-info text-white fw-bold">
            Gender Distribution
        </div>
        <div class="card-body p-0">
            <table class="table table-striped table-hover table-bordered mb-0 text-center">
                <thead class="table-dark">
                    <tr>
                        <th>Male</th>
                        <th>Female</th>
                        <th>Other</th>
                        <th>Total</th>

                    
                    </tr>
                </thead>
                <tbody>
                    <tr><td>{{ $genderWise['male'] ?? 0 }}</td>
                    <td>{{ $genderWise['female'] ?? 0 }}</td>
                    <td>{{ $genderWise['other'] ?? 0 }}</td>
                        <td>{{ array_sum($genderWise) }}</td>
                    </tr>
                </tbody>
            </table>
        </div>
    </div>

    <!-- Category Distribution -->
    <div class="card mb-3 shadow-sm">
        <div class="card-header bg-light fw-bold">
            Caste Category Distribution
        </div>
        <div class="card-body p-0">
            <table class="table table-striped table-hover table-bordered mb-0 text-center">
                <thead class="table-dark">
                    <tr>
                        <th>SC</th>
                        <th>ST</th>
                        <th>OBC</th>
                        <th>Others</th>
                        <th>TOTAL</th>
                    </tr>
                </thead>
                <tbody>
                    <tr><td>{{ $categoryWise['SC'] ?? 0 }}</td>
                    <td>{{ $categoryWise['ST'] ?? 0 }}</td>
                    <td>{{ $categoryWise['OBC'] ?? 0 }}</td>
                    <td>{{ $categoryWise['Others'] ?? 0 }}</td>
                    
                        <td>{{ array_sum($categoryWise) }}</td>
                    </tr>
                </tbody>
            </table>
        </div>
    </div>

    <!-- Education Level Distribution -->
    <div class="card mb-3 shadow-sm">
        <div class="card-header bg-info text-white fw-bold">
            Education Level Distribution
        </div>
        <div class="card-body p-0">
            <table class="table table-striped table-hover table-bordered mb-0 text-center">
                <thead class="table-dark">
                    <tr>
                        <th>Illiterate</th>
                        <th>Primary</th>
                        <th>Matric</th>
                        <th>Graduate</th>
                        <th>Others</th>
                        
                    </tr>
                </thead>
                <tbody>
                    <tr><td>{{ $educationWise['Illiterate'] ?? 0 }}</td>
                    <td>{{ $educationWise['Primary'] ?? 0 }}</td>
                    <td>{{ $educationWise['Matric'] ?? 0 }}</td>
                    <td>{{ $educationWise['Graduate'] ?? 0 }}</td>
                    <td>{{ $educationWise['Others'] ?? 0 }}</td></tr>
                </tbody>
            </table>
        </div>
    </div>

    <!-- Average Age -->
    <div class="card shadow-sm mb-5">
        <div class="card-header bg-light  fw-bold">
            Average Age of Members
        </div>
        <div class="card-body">
            <h5 class="mb-0">{{ $averageAge ?? 0 }} Years</h5>
        </div>
    </div>

    <!-- Land & Irrigation Summary -->
    <div class="card mb-3 shadow-sm">
        <div class="card-body text-center">
            <div class="row fw-bold">
                <div class="col-md-4 bg-info text-white p-2">Total Area</div>
                <div class="col-md-4 bg-success text-white p-2">Irrigated Area</div>
                <div class="col-md-4 bg-danger text-white p-2">Non-Irrigated Area</div>
            </div>
            <div class="row">
                <div class="col-md-4">{{ number_format($totalLandArea, 2) }} acres</div>
                <div class="col-md-4">{{ number_format($totalIrrigated, 2) }} acres</div>
                <div class="col-md-4">{{ number_format($totalNonIrrigated, 2) }} acres</div>
            </div>
        </div>
    </div>

    <!-- Land Type-wise Area -->
    <div class="card mb-3 shadow-sm">
        <div class="card-header bg-info text-white fw-bold">Land Type-wise Area</div>
        <div class="card-body p-0">
            <table class="table table-striped table-hover table-bordered mb-0 text-center">
                <thead class="table-dark">
                    <tr>
                        <th>Land Type</th>
                        <th>Total Area (acres)</th>
                    </tr>
                </thead>
                <tbody>
                    @foreach($landTypeWise as $type => $area)
                        <tr>
                            <td>{{ $type }}</td>
                            <td>{{ number_format($area, 2) }}</td>
                        </tr>
                    @endforeach
                    <tr class="fw-bold table-info">
                        <td>Total</td>
                        <td>{{ number_format(array_sum($landTypeWise), 2) }}</td>
                    </tr>
                </tbody>
            </table>
        </div>
    </div>

    <!-- Irrigation Sources Wise Count -->
    <div class="card mb-3 shadow-sm">
        <div class="card-header bg-light  fw-bold">Irrigation Sources Wise Count</div>
        <div class="card-body p-0">
            <table class="table table-bordered table-striped text-center mb-0">
                <thead class="table-dark">
                    <tr>
                        <th>Irrigation Sources</th>
                        <th>Total Count</th>
                    </tr>
                </thead>
                <tbody>
                    @foreach($irrigationSources as $source)
                        @php
                            $decoded = json_decode($source->irrigation_sources, true);
                            if (is_string($decoded)) { $decoded = json_decode($decoded, true); }
                            $formattedSources = is_array($decoded) ? implode(', ', array_map('ucfirst', $decoded)) : ucfirst($source->irrigation_sources);
                        @endphp
                        <tr>
                            <td>{{ $formattedSources }}</td>
                            <td>{{ $source->total }}</td>
                        </tr>
                    @endforeach
                </tbody>
            </table>
        </div>
    </div>

    <!-- Dimensions and Counts -->



    <div class="card mb-3 shadow-sm">
    <div class="card-header bg-info text-white fw-bold">
        Dimensions and Their Counts
    </div>
    <div class="card-body p-0">
        <table class="table table-bordered table-striped text-center mb-0">
            <thead class="table-dark">
                <tr>
                    <th>Length (m)</th>
                    <th>Width (m)</th>
                    <th>Depth/Height (m)</th>
                    <th>Count</th>
                </tr>
            </thead>
            <tbody>
                @forelse($measurementGroups as $group)
                    <tr>
                        <td>{{ number_format($group->length, 2) }}</td>
                        <td>{{ number_format($group->width, 2) }}</td>
                        <td>{{ number_format($group->depth_or_height, 2) }}</td>
                        <td><span class="badge bg-success">{{ $group->total_count }}</span></td>
                    </tr>
                @empty
                    <tr>
                        <td colspan="4" class="text-center text-muted">No data available</td>
                    </tr>
                @endforelse
            </tbody>
        </table>
    </div>
</div>






<div class="container mt-4">
    <div class="row g-4">

        <!-- Land Slope Card -->
        <div class="col-md-4">
            <div class="card shadow-lg border-0 rounded-4">
                <div class="card-header text-center fw-bold" 
                     style="background: linear-gradient(45deg, #4facfe, #00f2fe); color: #ffffff; font-size: 1.1rem; letter-spacing: 0.5px;">
                    Land Slope
                </div>
                <div class="card-body p-0">
                    <table class="table table-hover table-bordered text-center mb-0">
                        <thead style="background-color: #e3f2fd; font-weight: bold;">
                            <tr>
                                <th>Range</th>
                                <th>Count</th>
                            </tr>
                        </thead>
                        <tbody>
                            <tr class="table-primary">
                                <td>1% - 4%</td>
                                <td>{{ $landSlopeCounts->slope_1_to_4 }}</td>
                            </tr>
                            <tr class="table-info">
                                <td>4% - 7%</td>
                                <td>{{ $landSlopeCounts->slope_4_to_7 }}</td>
                            </tr>
                            <tr class="table-success">
                                <td>> 7%</td>
                                <td>{{ $landSlopeCounts->slope_above_7 }}</td>
                            </tr>
                        </tbody>
                    </table>
                </div>
            </div>
        </div>

        <!-- Geological Location Card -->
        <div class="col-md-4">
            <div class="card shadow-lg border-0 rounded-4">
                <div class="card-header text-center fw-bold" 
                     style="background: linear-gradient(45deg, #43e97b, #38f9d7); color: #ffffff; font-size: 1.1rem; letter-spacing: 0.5px;">
                    Geological Location
                </div>
                <div class="card-body p-0">
                    <table class="table table-hover table-bordered text-center mb-0">
                        <thead style="background-color: #e8f5e9; font-weight: bold;">
                            <tr>
                                <th>Type</th>
                                <th>Count</th>
                            </tr>
                        </thead>
                        <tbody>
                            <tr class="table-success">
                                <td>Low Land</td>
                                <td>{{ $geologicalCounts->low_land }}</td>
                            </tr>
                            <tr class="table-warning">
                                <td>Mid Land</td>
                                <td>{{ $geologicalCounts->mid_land }}</td>
                            </tr>
                            <tr class="table-info">
                                <td>Up Land</td>
                                <td>{{ $geologicalCounts->up_land }}</td>
                            </tr>
                        </tbody>
                    </table>
                </div>
            </div>
        </div>

        <!-- Hydrological Location Card -->
        <div class="col-md-4">
            <div class="card shadow-lg border-0 rounded-4">
                <div class="card-header text-center fw-bold" 
                     style="background: linear-gradient(45deg, #ff9966, #ff5e62); color: #ffffff; font-size: 1.1rem; letter-spacing: 0.5px;">
                    Hydrological Location
                </div>
                <div class="card-body p-0">
                    <table class="table table-hover table-bordered text-center mb-0">
                        <thead style="background-color: #fff3e0; font-weight: bold;">
                            <tr>
                                <th>Zone</th>
                                <th>Count</th>
                            </tr>
                        </thead>
                        <tbody>
                            <tr class="table-warning">
                                <td>Discharge Zone</td>
                                <td>{{ $hydrologicalCounts->discharge }}</td>
                            </tr>
                            <tr class="table-primary">
                                <td>Transition Zone</td>
                                <td>{{ $hydrologicalCounts->transition }}</td>
                            </tr>
                            <tr class="table-danger">
                                <td>Recharge Zone</td>
                                <td>{{ $hydrologicalCounts->recharge }}</td>
                            </tr>
                        </tbody>
                    </table>
                </div>
            </div>
        </div>



    <div class="card mb-3 shadow-sm">
        <div class="card-header bg-info text-white fw-bold">Water User Group</div>
        <div class="card-body p-0">
            <table class="table table-striped table-hover table-bordered mb-0 text-center">
                <thead class="table-dark">
                    <tr>
                        <th>Land Area (acres)</th>
                        <th>potential_irrigation (acres)</th>
                    </tr>
                </thead>
                <tbody>
            
                        <tr>
                            <td>{{ $land_comment }}</td>
                            <td>{{ number_format($potential_irrigation, 2) }}</td>
                        </tr>

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



        



    </div>
</div>



</div>

@endsection