@include('layouts.header', ['title' => isset($project) ? 'Project Survey Details' : 'Add Project'])
<div class="wrapper">
    @include('layouts.navbar')
    @include('layouts.sidebar')

    <div class="content-page">
        <div class="content">
            <div class="container-fluid">
                <div class="row">
                    <div class="col-12">
                        <div class="page-title-box">
                            <div class="page-title-right"></div>
                        </div>
                    </div>
                </div>

                @include('components.project-details', ['project' => $project])

                <!-- Survey Buttons -->
                <div class="row">
                    <div class="col-md-6 mb-3">

                            <button id="btn-residential-a1" class="btn btn-primary">A1</button>
                            <button id="btn-residential-a2" class="btn btn-primary">A2</button>

                    </div>
                    <div class="col-md-6 mb-3">
                        <form method="GET"
                            action="{{ route('admin.rnrprojectsurvey.index', ['projectId' => encrypt($project->id)]) }}"
                            class="row">
                            <input type="hidden" name="projectId" value="{{ $project->id }}">

                            <div class="col-md-4">
                                <input type="text" name="pap_name" class="form-control"
                                    placeholder="PAP Name"
                                    value="{{ request()->query('pap_name') }}">
                            </div>

                            <!-- Search and Reset Buttons -->
                            <div class="col-md-2 d-flex">
                                <button type="submit"
                                    class="btn btn-primary me-2">Search</button>
                                <a href="{{ route('admin.rnrprojectsurvey.index', ['projectId' => encrypt($project->id)]) }}"
                                    class="btn btn-secondary">Reset</a>
                            </div>
                        </form>
                    </div>
                </div>

                <div class="row">
                    @if ($structure_use == '1')
                        <div id="residential-a1" class="survey-contents">
                            <div class="col-12">
                                <div class="card">
                                    <div class="card-header d-flex justify-content-between align-items-center">
                                        <h4 class="header-title mb-0">Survey Lists</h4>
                                    </div>
                                    <div class="card-body">
                                        <div class="table-wrapper">
                                            <table id="basic-datatable residential-a1-table"
                                                class="table table-striped dt-responsive nowrap w-100">
                                                <thead>
                                                    <tr>
                                                        <th>Sl. No.</th>
                                                        <th>Map No.</th>
                                                        <th>Identification No.</th>
                                                        <th>Name of the Owner</th>
                                                        <th>Name of the Occupant of structure</th>
                                                        <th>Type of Structure</th>
                                                        <th>Carpet Area(In Sq.mtr.)</th>
                                                        <th>Type of Use</th>
                                                        <th>Occupancy Status</th>
                                                        <th>Year of Settlement</th>
                                                        <th>Zopdi No.</th>
                                                        <th>PAP Name</th>
                                                        <th>Survey Date</th>
                                                        <th>Action</th>
                                                    </tr>
                                                </thead>
                                                <tbody>
                                                    @if ($surveys->isEmpty())
                                                        <tr>
                                                            <td colspan="13" class="text-center">No Records Found</td>
                                                        </tr>
                                                    @else
                                                        @foreach ($surveys as $survey)
                                                            @if ($survey->structure_use == '1')
                                                                <tr>
                                                                    <td>{{ $loop->iteration + ($surveys->currentPage() - 1) * $surveys->perPage() }}
                                                                    </td>
                                                                    <td>1</td>
                                                                    <td>1</td>

                                                                    <td>
                                                                        @if ($survey->SurveyUserResidential->isNotEmpty())
                                                                            {{ $survey->SurveyUserResidential->pluck('structure_owner_name')->implode(', ') }}
                                                                        @else
                                                                            N/A
                                                                        @endif
                                                                    </td>

                                                                    <td>
                                                                        @if ($survey->SurveyUserResidential->isNotEmpty())
                                                                            {{ $survey->SurveyUserResidential->pluck('name_occupant_structure')->implode(', ') }}
                                                                        @else
                                                                            N/A
                                                                        @endif
                                                                    </td>

                                                                    <td>
                                                                        @if ($survey->SurveyUserResidentialSocioEconomicIndicator->isNotEmpty())
                                                                            {{ $survey->SurveyUserResidentialSocioEconomicIndicator->map(function ($item) {
                                                                                    return $item->structureRoof->name . ', ' . $item->structureWall->name . ', ' . $item->structureFloor->name;
                                                                                })->implode(', ') ?? 'N/A' }}
                                                                        @else
                                                                            N/A
                                                                        @endif
                                                                    </td>

                                                                    <td>
                                                                        @if ($survey->SurveyUserResidential->isNotEmpty())
                                                                            {{ $survey->SurveyUserResidential->pluck('total_area')->implode(', ') }}
                                                                        @else
                                                                            N/A
                                                                        @endif
                                                                    </td>

                                                                    <td>
                                                                        @if ($survey->structure_use == '1')
                                                                            Residential
                                                                        @else
                                                                            N/A
                                                                        @endif
                                                                    </td>

                                                                    <td>
                                                                        @if ($survey->SurveyUserResidential->isNotEmpty())
                                                                            {{ $survey->SurveyUserResidential->pluck('structureHolder.name')->implode(', ') ?? 'N/A' }}
                                                                        @else
                                                                            N/A
                                                                        @endif
                                                                    </td>

                                                                    <td>2000002</td>

                                                                    <td>{{ $survey->structure_id ?? 'N/A' }}</td>
                                                                    <td>{{ $survey->pap_name ?? 'N/A' }}</td>
                                                                    <td>{{ $survey->survey_date ? date('d M Y', strtotime($survey->survey_date)) : 'N/A' }}
                                                                    </td>
                                                                    <td>
                                                                        <a href="{{ route('admin.projectsurveydetails.index', ['projectId' => encrypt($project->id), 'surveyId' => encrypt($survey->id)]) }}"
                                                                            class="text-reset fs-16 px-1"
                                                                            data-bs-toggle="tooltip"
                                                                            data-bs-placement="top"
                                                                            title="View Survey Project">
                                                                            <i class="bi bi-eye-fill"></i>
                                                                        </a>
                                                                    </td>
                                                                </tr>
                                                            @endif
                                                        @endforeach
                                                    @endif
                                                </tbody>
                                            </table>
                                        </div>
                                    </div>
                                    <!-- Pagination Links -->
                                    <div class="mt-3">
                                        {{ $surveys->appends(request()->query())->links('pagination::bootstrap-5') }}
                                    </div>

                                </div> <!-- end card body-->
                            </div> <!-- end card -->
                        </div><!-- end col-->

                        <div id="residential-a2" class="survey-content" style="display: none;">
                            <div class="col-12">
                                <div class="card">
                                    <div class="card-header d-flex justify-content-between align-items-center">
                                        <h4 class="header-title mb-0">Survey Lists</h4>
                                    </div>

                                    <div class="card-body">

                                        <table id="basic-datatable residential-a2-table"
                                            class="table table-striped dt-responsive nowrap w-100">
                                            <thead>
                                                <tr>
                                                    <th>Sl. No.</th>
                                                    <th>Zopdi No.</th>
                                                    <th>PAP Name</th>
                                                    <th>Survey Date</th>
                                                    <th>Action</th>

                                                </tr>
                                            </thead>

                                            <tbody>
                                                @foreach ($surveys as $key => $survey)
                                                    @if ($survey->structure_use == '1')
                                                        <tr>
                                                            <td>{{ $loop->index + 1 + ($surveys->currentPage() - 1) * $surveys->perPage() }}
                                                            </td>
                                                            <td>{{ $survey->structure_id }}</td>
                                                            <td>PAP</td>
                                                            <td>{{ $survey->survey_date ? date('d M Y', strtotime($survey->survey_date)) : 'N/A' }}
                                                            </td>
                                                            <td>
                                                                <a href="{{ route('admin.projectsurveydetails.index', ['projectId' => encrypt($project->id), 'surveyId' => encrypt($survey->id)]) }}"
                                                                    class="text-reset fs-16 px-1"
                                                                    data-bs-toggle="tooltip" data-bs-placement="top"
                                                                    title="View Survey Project">
                                                                    <i class="bi bi-eye-fill"></i>
                                                                </a>
                                                            </td>
                                                        </tr>
                                                    @endif
                                                @endforeach
                                            </tbody>
                                        </table>
                                    </div>
                                    <!-- Pagination Links -->
                                    <div class="mt-3">
                                        {{ $surveys->appends(request()->query())->links('pagination::bootstrap-5') }}
                                    </div>

                                </div> <!-- end card body-->
                            </div> <!-- end card -->
                        </div><!-- end col-->

                    @endif
                    {{-- other --}}
                    @if ($structure_use == '4')
                    <div id="other-a1" class="survey-contents">

                        <div class="col-12">
                            <div class="card">
                                <div class="card-header d-flex justify-content-between align-items-center">
                                    <h4 class="header-title mb-0">Survey Lists</h4>
                                </div>

                                <div class="card-body">

                                    <table id="basic-datatable other-a1-table"
                                        class="table table-striped dt-responsive nowrap w-100">
                                        <thead>
                                            <tr>
                                                <th>Sl. No.</th>
                                                <th>Zopdi No.</th>
                                                <th>PAP Name</th>
                                                <th>Survey Date</th>
                                                <th>Action</th>

                                            </tr>
                                        </thead>

                                        <tbody>
                                            @foreach ($surveys as $key => $survey)
                                                @if ($survey->structure_use == '4')
                                                    <tr>
                                                        <td>{{ $loop->index + 1 + ($surveys->currentPage() - 1) * $surveys->perPage() }}
                                                        </td>
                                                        <td>{{ $survey->structure_id }}</td>
                                                        <td>{{ $survey->pap_name }}</td>
                                                        <td>{{ $survey->survey_date ? date('d M Y', strtotime($survey->survey_date)) : 'N/A' }}
                                                        </td>
                                                        <td>
                                                            <a href="{{ route('admin.projectsurveydetails.index', ['projectId' => encrypt($project->id), 'surveyId' => encrypt($survey->id)]) }}"
                                                                class="text-reset fs-16 px-1"
                                                                data-bs-toggle="tooltip" data-bs-placement="top"
                                                                title="View Survey Project">
                                                                <i class="bi bi-eye-fill"></i>
                                                            </a>
                                                        </td>
                                                    </tr>
                                                @endif
                                            @endforeach
                                        </tbody>
                                    </table>
                                </div>
                                <!-- Pagination Links -->
                                <div class="mt-3">
                                    {{ $surveys->appends(request()->query())->links('pagination::bootstrap-5') }}
                                </div>

                            </div> <!-- end card body-->
                        </div> <!-- end card -->
                    </div><!-- end col-->

                @endif
                </div> <!-- end row-->


            </div>
        </div>

        @include('layouts.footer')
    </div>
</div>

<!-- Vendor JS -->
<script src="{{ asset('assets/js/vendor.min.js') }}"></script>
<script src="https://code.jquery.com/ui/1.12.1/jquery-ui.min.js"></script>
<link rel="stylesheet" href="https://code.jquery.com/ui/1.12.1/themes/base/jquery-ui.css">

<script src="{{ asset('assets/js/app.min.js') }}"></script>

<script>
    $(document).ready(function() {
        // Hide all survey sections initially
        $('.survey-content').hide();

        // For Residential Structure (use 1) with A1 and A2 buttons
        $('#btn-residential-a1').click(function() {
            $('#residential-a1').show();
            $('#residential-a2').hide();
        });

        $('#btn-residential-a2').click(function() {
            $('#residential-a2').show();
            $('#residential-a1').hide();
        });

        // For Other Structure (use 4) with only A1 button
        $('#btn-other-a1').click(function() {
            $('#other-a1').show();
        });
    });
</script>

</body>



public function projectSurveyLists(Request $request, $projectId)
    {
        $projectId = decrypt($projectId);
        $project = $this->rnrRepo->getProjectById($projectId);

        // Check if the user is authorized
        if (Auth::user()->user_role_id !== 1 && $project->sdc_officer_user_id !== Auth::id()) {
            abort(403, 'Unauthorized access.');
        }

        $searchName = request()->query('pap_name');
        $filterType = $request->query('filter_type'); // Get filter type from AJAX

        // Paginate surveys
        $surveys = Survey::where('project_id', $projectId)
            ->when($searchName, function ($query) use ($searchName) {
                $query->where('pap_name', 'like', '%' . $searchName . '%');
            })

            ->paginate(5);

        // Set structure_use based on the first survey or default to a value
        $structure_use = $surveys->isNotEmpty() ? $surveys->first()->structure_use : null;

        // Loop over actual items, not the paginator
        foreach ($surveys->items() as $survey) {
            if ($filterType == 'A5') {
                $survey->load('surveyUserOthers.structureType');
            } elseif ($filterType == 'A2') {
                $survey->load(['surveyUserCommercial.shopType', 'surveyUserCommercial.workersType']);
            } elseif ($filterType == 'A1') {
                $survey->load([
                    'surveyUserResidential.structureHolder',
                    'surveyUserResidential.motherTongue',
                    'surveyUserResidential.casteGroup',
                    'surveyUserResidential.religion',
                    // 'surveyUserResidentialHouseholdMembers.relation',
                    // 'surveyUserResidentialHouseholdMembers.gender',
                    // 'surveyUserResidentialVulnerability',
                    // 'SurveyUserResidentialSocioEconomicIndicator.typesOfStructures',
                    // 'SurveyUserResidentialSocioEconomicIndicator.floors',
                    // 'SurveyUserResidentialSocioEconomicIndicator.rooms',
                    'SurveyUserResidentialSocioEconomicIndicator.structureRoof',
                    'SurveyUserResidentialSocioEconomicIndicator.structureWall',
                    'SurveyUserResidentialSocioEconomicIndicator.structureFloor',
                    // 'SurveyUserResidentialSocioEconomicIndicator.toiletType',
                    // 'SurveyUserResidentialSocioEconomicIndicator.WaterType',
                    // 'SurveyUserResidentialSocioEconomicIndicator.EstimateAnnualExpenditure',
                    // 'SurveyUserResidentialSocioEconomicIndicator.CookingFuel'
                ]);
            }
        }

        // dd(json_encode($surveys));

        $users = User::whereHas('designated', function ($query) {
            $query->where('status', '1');
        })->with('designated')->get();

        return view('admin.RnRProjects.project-survey-list', compact('project', 'surveys', 'users', 'structure_use'));
    }