@if ($filterType !== 'B2')
    <div class="card-header d-flex justify-content-between align-items-center" id="cardHeaderSection">
        <a href="javascript:void(0);" id="downloadSurvey" class="btn btn-success">Download Survey Excel</a>
        {{-- <form class="d-flex ms-auto">
            <input type="text" name="pap_name" class="form-control me-2" placeholder="Occupant Name" value="">
            <button type="submit" class="btn btn-primary me-2">Search</button>
            <button class="btn btn-secondary reset-btn">Reset</button>
        </form> --}}
    </div>
@endif

<div style="overflow-x: auto; width: 100%;">
    <table class="table table-bordered text-center align-middle">
        <thead>
            <tr>
                <th rowspan="3">Sl. No.</th>
                <th rowspan="3">Age Group</th>
                <th colspan="4">Sex</th>
                <th colspan="4">Marital Status</th>
                <th colspan="{{ count($educationLevels) * 2 }}">Education</th>
                <th colspan="4">Status of Employment</th>
            </tr>
            <tr>
                <th colspan="2">Male</th>
                <th colspan="2">Female</th>
                <th colspan="2">Married</th>
                <th colspan="2">Unmarried</th>

                @foreach ($educationLevels as $edu)
                    <th colspan="2">{{ $edu }}</th>
                @endforeach

                <th colspan="2">Employed</th>
                <th colspan="2">Not Employed</th>
            </tr>
            <tr>
                @for ($i = 0; $i < 4; $i++)
                    <th>N</th>
                    <th>%</th>
                @endfor

                @foreach ($educationLevels as $edu)
                    <th>N</th>
                    <th>%</th>
                @endforeach

                {{-- Occupation Columns --}}
                <th>N</th>
                <th>%</th>
                <th>N</th>
                <th>%</th>
            </tr>
        </thead>


        <tbody>
            @foreach ($structuredData as $index => $row)
                <tr>
                    <td>{{ $index + 1 }}</td>
                    <td>{{ $row['age_group'] }}</td>
                    <td>{{ $row['male_n'] }}</td>
                    <td>{{ $row['male_percent'] }}%</td>
                    <td>{{ $row['female_n'] }}</td>
                    <td>{{ $row['female_percent'] }}%</td>
                    <td>{{ $row['married_n'] }}</td>
                    <td>{{ $row['married_percent'] }}%</td>
                    <td>{{ $row['unmarried_n'] }}</td>
                    <td>{{ $row['unmarried_percent'] }}%</td>

                    @foreach ($educationLevels as $edu)
                        <td>{{ $row['education'][$edu]['n'] ?? 0 }}</td>
                        <td>{{ $row['education'][$edu]['percent'] ?? 0 }}%</td>
                    @endforeach

                    <td>{{ $row['occupied_n'] ?? 0 }}</td>
                    <td>{{ $row['occupied_percent'] ?? 0 }}%</td>
                    <td>{{ $row['unoccupied_n'] ?? 0 }}</td>
                    <td>{{ $row['unoccupied_percent'] ?? 0 }}%</td>
                </tr>
            @endforeach

            <tr class="fw-bold bg-light">
                <td colspan="2">Column Total</td>
                <td>{{ $totalCounts['male_n'] }}</td>
                <td>{{ $totalCounts['male_percent'] }}%</td>
                <td>{{ $totalCounts['female_n'] }}</td>
                <td>{{ $totalCounts['female_percent'] }}%</td>
                <td>{{ $totalCounts['married_n'] }}</td>
                <td>{{ $totalCounts['married_percent'] }}%</td>
                <td>{{ $totalCounts['unmarried_n'] }}</td>
                <td>{{ $totalCounts['unmarried_percent'] }}%</td>

                @foreach ($educationLevels as $edu)
                    <td>{{ $totalCounts['education'][$edu]['n'] ?? 0 }}</td>
                    <td>{{ $totalCounts['education'][$edu]['percent'] ?? 0 }}%</td>
                @endforeach

                <td>{{ $totalCounts['occupied_n'] ?? 0 }}</td>
                <td>{{ $totalCounts['occupied_percent'] ?? 0 }}%</td>
                <td>{{ $totalCounts['unoccupied_n'] ?? 0 }}</td>
                <td>{{ $totalCounts['unoccupied_percent'] ?? 0 }}%</td>
            </tr>
        </tbody>

    </table>
</div>


<!-- Pagination -->
{{-- <div class="mt-3 pagination-links">
    {{ $surveys->appends(request()->query())->links('pagination::bootstrap-5') }}
</div> --}}