@if ($surveys)
    <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" aria-label="Survey Details">
                    ID Number: {{ $surveys->structure_id ?? 'N/A' }} - {{ $surveys->pap_name ?? 'Unknown' }}
                </h4>
            </div>

            <div class="card-body">
                @if ($surveys->surveyDocuments->isNotEmpty())
                    @foreach ($surveys->surveyDocuments as $docs)
                        @if ($docs->documentType)
                            <div class="card">
                                <div class="card-header bg-light-subtle">
                                    {{ $docs->documentType->name }}
                                </div>
                                <div class="card-body">
                                    <div class="row">
                                        <div class="col-3">
                                            @php
                                                $imagePath = asset(
                                                    "storage/uploads/survey/project_{$docs->project_id}/survey_{$docs->survey_id}/docs/{$docs->document_file_name}",
                                                );
                                                $fileType = pathinfo($imagePath, PATHINFO_EXTENSION);
                                                $supportedDocs = ['Electric Bill'];
                                            @endphp

                                            <a href="javascript:void(0);" class="open-preview" data-bs-toggle="tooltip"
                                                data-bs-placement="top" title="View File"
                                                data-file-url="{{ $imagePath }}"
                                                data-file-type="{{ $fileType }}">
                                                <img src="{{ $imagePath }}" alt="{{ $docs->documentType->name }}"
                                                    class="img-thumbnail" width="150">
                                            </a>
                                        </div>
                                        <div class="col-9">
                                            @php
                                                $hasStatus6 = $project->statuses->contains('status', 6);
                                            @endphp
                                            @if (in_array($docs->documentType->name, $supportedDocs) && $hasStatus6)
                                                <div class="doc-container mt-2">
                                                    <div class="row gy-2 gx-2 align-items-center">
                                                        <div class="col-auto">
                                                            <label class="" for="inlineFormInput">Select
                                                                Provider</label>
                                                            <select class="form-select w-auto provider-dropdown"
                                                                id="provider_dropdown">
                                                                <option value="">-- Select --</option>
                                                                @php
                                                                    $providers = [
                                                                        'Adani',
                                                                        'Mahadiscom',
                                                                        'Tata',
                                                                        'BEST',
                                                                    ];
                                                                @endphp
                                                                @foreach ($providers as $provider)
                                                                    <option value="{{ $provider }}"
                                                                        {{ $docs->provider === $provider ? 'selected' : '' }}>
                                                                        {{ $provider }}
                                                                    </option>
                                                                @endforeach
                                                            </select>
                                                        </div>
                                                        <div class="col-auto">
                                                            <label class="" for="inlineFormInputGroup">Consumer
                                                                No.</label>
                                                            <input type="text"
                                                                class="form-control w-auto consumer-input"
                                                                id="consumer_input" placeholder="Consumer No"
                                                                value="{{ $docs->consumer_no ?? '' }}" />
                                                        </div>



                                                        @php
                                                            $structureUse = $surveys->structure_use;
                                                            $status = null;

                                                            if ($structureUse == '1') {
                                                                $residential = $surveys->SurveyUserResidential->first();
                                                                $status = $residential?->updated_status;
                                                            } elseif ($structureUse == '2') {
                                                                $commercial = $surveys->surveyUserCommercial->first();
                                                                $status = $commercial?->updated_status;
                                                            } elseif ($structureUse == '3') {
                                                                $residential = $surveys->SurveyUserResidential->first();
                                                                $status = $residential?->updated_status;
                                                            } elseif ($structureUse == '4') {
                                                                $other = $surveys->surveyUserOthers->first();
                                                                $status = $other?->updated_status;
                                                            }
                                                        @endphp
                                                        @php
                                                            $hasStatus6 = $project->statuses->contains('status', 6);
                                                        @endphp

                                                        @if (!$status && $hasStatus6)
                                                            <div class="col-auto">
                                                                <button class="btn btn-sm btn-primary fetch-btn"
                                                                    data-docid="{{ $docs->id }}">Fetch
                                                                    Data</button>
                                                            </div>
                                                        @endif

                                                    </div>
                                                </div>
                                                {{-- Consumer Input --}}
                                                <div class="mt-2 consumer-box" id="consumer-box-{{ $docs->id }}">


                                                    @if ($docs->api_response)
                                                        @php
                                                            $savedData = json_decode($docs->api_response, true);
                                                            $provider = $docs->provider ?? null;
                                                            $keysToSkip = [
                                                                'consumptions',
                                                                'internalNotes',
                                                                'extraData',
                                                                'rawJson',
                                                            ];
                                                            $dataArray = [];
                                                            $columns = [];

                                                            if (
                                                                $provider === 'Adani' &&
                                                                isset($savedData['IT_CONSDATA_POST']['item']) &&
                                                                is_array($savedData['IT_CONSDATA_POST']['item'])
                                                            ) {
                                                                $dataArray = $savedData['IT_CONSDATA_POST']['item'];
                                                                $columns = array_keys($dataArray[0] ?? []);
                                                            } elseif (
                                                                $provider === 'Mahadiscom' &&
                                                                isset($savedData['PreviousData']) &&
                                                                is_array($savedData['PreviousData'])
                                                            ) {
                                                                $previousData = $savedData['PreviousData'];
                                                                $currentData = isset($savedData['CurretData'])
                                                                    ? [$savedData['CurretData']]
                                                                    : [];
                                                                $dataArray = array_merge($previousData, $currentData);
                                                                $columns = array_keys($dataArray[0] ?? []);
                                                            } elseif ($provider === 'Tata' && is_array($savedData)) {
                                                                $dataArray = collect($savedData)
                                                                    ->map(function ($record) {
                                                                        $addressParts = collect([
                                                                            $record['HouseNo'] ?? null,
                                                                            $record['Building'] ?? null,
                                                                            $record['Street'] ?? null,
                                                                            $record['Street2'] ?? null,
                                                                            $record['Street3'] ?? null,
                                                                            $record['Street4'] ?? null,
                                                                            $record['Location'] ?? null,
                                                                            $record['District'] ?? null,
                                                                            $record['City'] ?? null,
                                                                            $record['CityPo'] ?? null,
                                                                        ])
                                                                            ->filter(
                                                                                fn($part) => trim($part ?? '') !== '',
                                                                            )
                                                                            ->implode(', ');

                                                                        return [
                                                                            'Tariff' => $record['CustomerClass'] ?? '',
                                                                            'MoveInDate' => $record['MoveInDate'] ?? '',
                                                                            'MoveOutDate' =>
                                                                                $record['MoveOutDate'] ?? '',
                                                                            'FirstName' => $record['FirstName'] ?? '',
                                                                            'LastName' => $record['LastName'] ?? '',
                                                                            'Address' => $addressParts,
                                                                            'Status' => $record['Status'] ?? '',
                                                                        ];
                                                                    })
                                                                    ->values()
                                                                    ->toArray();

                                                                $columns = array_keys($dataArray[0] ?? []);
                                                            } elseif (is_array($savedData)) {
                                                                $dataArray = $savedData;
                                                                if ($provider === 'BEST') {
                                                                    $columns = array_keys(
                                                                        array_diff_key(
                                                                            $dataArray[0] ?? [],
                                                                            array_flip($keysToSkip),
                                                                        ),
                                                                    );
                                                                } else {
                                                                    $columns = array_keys($dataArray[0] ?? []);
                                                                }
                                                            }
                                                        @endphp





                                                        @if (!empty($dataArray))
                                                            <div class="result-box mt-3" id="electicity-result-box">
                                                                <div class="table-responsive mt-3"
                                                                    style="max-height: 300px; overflow: auto;">
                                                                    <table
                                                                        class="table table-bordered table-striped table-sm">
                                                                        <thead>
                                                                            <tr>
                                                                                @foreach ($columns as $col)
                                                                                    <th>{{ $col }}</th>
                                                                                @endforeach
                                                                            </tr>
                                                                        </thead>
                                                                        <tbody>
                                                                            @foreach ($dataArray as $row)
                                                                                <tr>
                                                                                    @foreach ($columns as $col)
                                                                                        @php
                                                                                            $val = $row[$col] ?? '-';
                                                                                            if (
                                                                                                $val === '9999-12-31' ||
                                                                                                $val ===
                                                                                                    '1900-01-01T00:00:00'
                                                                                                    || $val === "9999-12-31T00:00:00Z"
                                                                                            ) {
                                                                                                $val = '';
                                                                                            }
                                                                                        @endphp
                                                                                        <td>{{ $val !== '' ? $val : '' }}
                                                                                        </td>
                                                                                    @endforeach
                                                                                </tr>
                                                                            @endforeach
                                                                        </tbody>
                                                                    </table>
                                                                </div>
                                                            </div>
                                                        @else
                                                            <div class="text-danger mt-3">No valid data to display.
                                                            </div>
                                                        @endif
                                                    @else
                                                        <div class="result-box mt-3" id="electicity-result-box"></div>
                                                    @endif

                                                    @php
                                                        $display = 'display:none;';
                                                        if (
                                                            !is_null($docs->api_response)
                                                            //  && is_null($docs->remarks)
                                                        ) {
                                                            $display = '';
                                                        }
                                                    @endphp

                                                    @php
                                                        $structureUse = $surveys->structure_use;
                                                        $status = null;

                                                        if ($structureUse == '1') {
                                                            $residential = $surveys->SurveyUserResidential->first();
                                                            $status = $residential?->updated_status;
                                                        } elseif ($structureUse == '2') {
                                                            $commercial = $surveys->surveyUserCommercial->first();
                                                            $status = $commercial?->updated_status;
                                                        } elseif ($structureUse == '3') {
                                                            $residential = $surveys->SurveyUserResidential->first();
                                                            $status = $residential?->updated_status;
                                                        } elseif ($structureUse == '4') {
                                                            $other = $surveys->surveyUserOthers->first();
                                                            $status = $other?->updated_status;
                                                        }
                                                    @endphp
                                                    @if (!$status)
                                                        <div class="mt-3 action-section"
                                                            id="electicity-verification-box"
                                                            style="{{ $display }}">
                                                            <label>Remarks <span class="text-danger">*</span>:</label>
                                                            <textarea class="form-control remarks-input" id="electicity_remark" rows="2" placeholder="Enter remarks here...">{{ $docs->remarks }}</textarea>

                                                            <div class="mt-2">
                                                                <button class="btn btn-success btn-sm accept-btn"
                                                                    data-docId="{{ $docs->id }}">Accept</button>
                                                                <button class="btn btn-danger btn-sm reject-btn"
                                                                    data-docId="{{ $docs->id }}">Reject</button>
                                                            </div>
                                                        </div>
                                                    @endif

                                                </div>
                                        </div>
                        @endif

                        @php
                            $structureUse = $surveys->structure_use;
                            $status = null;

                            if ($structureUse == '1') {
                                $residential = $surveys->SurveyUserResidential->first();
                                $status = $residential?->updated_status;
                            } elseif ($structureUse == '2') {
                                $commercial = $surveys->surveyUserCommercial->first();
                                $status = $commercial?->updated_status;
                            } elseif ($structureUse == '3') {
                                $residential = $surveys->SurveyUserResidential->first();
                                $status = $residential?->updated_status;
                            } elseif ($structureUse == '4') {
                                $other = $surveys->surveyUserOthers->first();
                                $status = $other?->updated_status;
                            }
                        @endphp

                        @php
                            $hasStatus6 = $project->statuses->contains('status', 6);
                        @endphp

                        @if ($hasStatus6)
                            @if (!$status)
                                @if ($docs->verification_status && $docs->remarks)
                                    <div class="mt-2 saved-remarks">
                                        <strong>Status:</strong>
                                        @if ($docs->verification_status === 'accepted')
                                            <span class="badge bg-success">Accepted</span>
                                        @else
                                            <span class="badge bg-danger">Rejected</span>
                                        @endif
                                        <br>
                                        <strong>Remarks:</strong> {{ $docs->remarks }}
                                    </div>
                                @endif
                            @else
                                @if ($docs->verification_status && $docs->remarks)
                                    <div class="mt-2 saved-remarks">
                                        <strong>Status:</strong>
                                        @if ($docs->verification_status === 'accepted')
                                            <span class="badge bg-success">Accepted</span>
                                        @else
                                            <span class="badge bg-danger">Rejected</span>
                                        @endif
                                        <br>
                                        <strong>Remarks:</strong> {{ $docs->remarks }}
                                    </div>
                                @endif
                            @endif
                        @endif

            </div>
        </div>
    </div> <!-- end card-body-->
    </div>
@else
    <div class="card">
        <div class="card-header bg-light-subtle">N/A</div>
        <div class="card-body">N/A</div>
    </div>
@endif
@endforeach
@else
No documents available.
@endif
</div>
</div>
{{-- </div> --}}
@else
<div class="col-12">
    <div class="alert alert-warning text-center">
        No survey found for this project.
    </div>
</div>
@endif

@php
    $structureUse = $surveys->structure_use;
    $status = null;
    $comment = null;

    if ($structureUse == '1') {
        $residential = $surveys->SurveyUserResidential->first();
        $status = $residential?->updated_status;
        $comment = $residential?->updated_status_comment;
    } elseif ($structureUse == '2') {
        $commercial = $surveys->surveyUserCommercial->first();
        $status = $commercial?->updated_status;
        $comment = $commercial?->updated_status_comment;
    } elseif ($structureUse == '3') {
        $residential = $surveys->SurveyUserResidential->first();
        $status = $residential?->updated_status;
        $comment = $residential?->updated_status_comment;
    } elseif ($structureUse == '4') {
        $other = $surveys->surveyUserOthers->first();
        $status = $other?->updated_status;
        $comment = $other?->updated_status_comment;
    }
@endphp

<div class="col-12">
    @php
        $hasStatus6 = $project->statuses->contains('status', 6);
    @endphp

    @if ($hasStatus6)
        <div class="card">
            <div class="card-body">
                <div style="overflow-x: auto; width: 100%;">
                    <h4 class="header-title mb-0">Document Remarks</h4>
                    <table id="basic-datatable" class="table table-striped dt-responsive nowrap w-100">
                        <thead>
                            <tr>
                                <th>Sl. No.</th>
                                <th>Document Type</th>
                                <th>Remarks</th>
                                <th>Status</th>
                            </tr>
                        </thead>
                        <tbody>
                            @php $sl = 1; @endphp
                            @foreach ($surveys->surveyDocuments as $docs)
                                @if ($docs->remarks)
                                    <tr>
                                        <td>{{ $sl++ }}</td>
                                        <td>{{ $docs->documentType->name ?? 'N/A' }}</td>
                                        <td>{{ $docs->remarks }}</td>
                                        <td>
                                            @if ($docs->verification_status === 'accepted')
                                                <span class="badge bg-success">Accepted</span>
                                            @elseif ($docs->verification_status === 'rejected')
                                                <span class="badge bg-danger">Rejected</span>
                                            @else
                                                <span class="badge bg-secondary">Pending</span>
                                            @endif
                                        </td>
                                    </tr>
                                @endif
                            @endforeach

                            @if ($sl === 1)
                                <tr>
                                    <td colspan="6" class="text-center">No records found.</td>
                                </tr>
                            @endif
                        </tbody>
                    </table>

                    {{-- Show this only if no dynamic remarks exist --}}
                    @if (!$status)
                        <div class="mt-4">
                            <div class="mt-3" id="eligibility-action-box">
                                <label for="final-remarks" class="form-label">Final Remarks <span
                                        class="text-danger">*</span></label>
                                <textarea class="form-control" id="final-remarks" rows="3" placeholder="Enter final remarks..."></textarea>

                                <div class="mt-2 d-flex gap-2">
                                    <button class="btn btn-success" onclick="submitEligibility('Eligible')">Mark as
                                        Eligible</button>
                                    <button class="btn btn-danger" onclick="submitEligibility('Non-Eligible')">Mark as
                                        Non-Eligible</button>
                                </div>
                            </div>
                        </div>
                    @endif

                    {{-- Optional status display --}}
                    @if (isset($status))
                        <div class="alert alert-info mt-3">
                            <strong>Status:</strong>
                            @if ($status === 'Eligible')
                                <span class="badge bg-success">Eligible</span>
                            @else
                                <span class="badge bg-danger">Non-Eligible</span>
                            @endif
                            <br>
                            <strong>Remarks:</strong> {{ $comment }}
                        </div>
                    @endif

                </div>
            </div>
        </div>
    @endif



</div>

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


@php
    $structureUse = $surveys->structure_use;
@endphp


<input type="hidden" id="structure_use" value="{{ $structureUse }}">
<input type="hidden" id="survey_id" value="{{ $surveys->id }}">
<input type="hidden" id="project_id" value="{{ $surveys->project_id }}">

</div>


@push('scripts')
    <script>
        const providerAPIs = {
            'Adani': '{{ route('adaniApi') }}',
            'Mahadiscom': '{{ route('mahadiscomApi') }}',
            'Torrent': '{{ url('/api/fetch-torrent') }}',
            'Tata': '{{ route('tataApi') }}',
            'BEST': '{{ route('bestApi') }}',
        };



        // 🚀 Main Fetch Handler
        $(document).on('click', '.fetch-btn', function() {
            let $_this = $(this);
            let consumerNo = $('#consumer_input').val().trim();
            let provider = $('#provider_dropdown').val();
            let docId = $_this.data('docid');
            let resultArea = $('#electicity-result-box');

            if (!provider || !consumerNo) {
                alert('Please select provider and enter consumer number.');
                return;
            }

            const apiUrl = providerAPIs[provider];
            $_this.text('Fetching...').prop('disabled', true);

            $.ajax({
                url: apiUrl,
                method: 'POST',
                data: {
                    AccountNo: consumerNo,
                    docId: docId,
                    provider: provider,
                    _token: $('meta[name="csrf-token"]').attr('content')
                },
                success: function(response) {
                    console.log(response);
                    const html = renderProviderTable(response, provider);
                    resultArea.html(html);
                    $('#electicity-verification-box').show();
                },
                error: function(xhr) {
                    let msg = 'Failed to fetch data';
                    if (xhr.responseJSON?.error) {
                        msg = xhr.responseJSON.error;
                    }
                    alert(msg);
                    console.error(xhr.responseText);
                },
                complete: function() {
                    $_this.text('Fetch Data').prop('disabled', false);
                }
            });
        });


        const renderStrategies = {
            'Mahadiscom': function(data) {
                if (!data?.IsSuccess) {
                    return `<div class="text-danger">Mahadiscom Error: ${data?.Message || 'Unknown error'}</div>`;
                }

                let html = '';

                let combinedData = [];

                if (Array.isArray(data.PreviousData) && data.PreviousData.length > 0) {
                    combinedData = [...data.PreviousData];
                }

                if (data.CurretData) {
                    combinedData.push(data.CurretData);
                }

                if (combinedData.length > 0) {
                    html += generateTable(combinedData, 'Mahadiscom');
                } else {
                    html += `<div class="text-danger">No Mahadiscom data available.</div>`;
                }

                return html;
            },

            'Adani': function(data) {
                const items = data?.IT_CONSDATA_POST?.item ?? [];
                return generateTable(items, 'Adani');
            },

            'BEST': function(data) {
                const cleanedData = Array.isArray(data) ? data : [];
                return generateTable(cleanedData, 'BEST');
            },

            'Tata': function(data) {
                const rawRecords = Array.isArray(data?.records) ? data.records : [];

                const simplifiedRecords = rawRecords.map(record => {
                    const {
                        CustomerClass,
                        MoveInDate,
                        MoveOutDate,
                        FirstName,
                        LastName,
                        Status,
                        HouseNo,
                        Building,
                        Street,
                        Street2,
                        Street3,
                        Street4,
                        Location,
                        District,
                        City,
                        CityPo
                    } = record;

                    const addressParts = [HouseNo, Building, Street, Street2, Street3, Street4, Location,
                            District, City, CityPo
                        ]
                        .filter(part => part && part.trim() !== '');

                    return {
                        Tariff: CustomerClass,
                        MoveInDate,
                        MoveOutDate,
                        FirstName,
                        LastName,
                        Address: addressParts.join(', '),
                        Status
                    };
                });

                return generateTable(simplifiedRecords, 'Tata');
            },

            'Reliance': function(data) {
                const customers = Array.isArray(data?.customers) ? data.customers : [];
                return generateTable(customers, 'Reliance');
            }
        };

        function renderProviderTable(data, provider) {
            const strategy = renderStrategies[provider];

            if (typeof strategy === 'function') {
                return strategy(data); // Use specific render logic
            }

            // Default fallback for simple arrays
            if (!Array.isArray(data) || data.length === 0) {
                return '<div class="text-danger">No valid data to display.</div>';
            }

            return generateTable(data, provider); // Generic table render
        }

        function generateTable(dataArray, provider) {
            if (!Array.isArray(dataArray) || dataArray.length === 0) {
                return '<div class="text-danger">No valid data to display.</div>';
            }

            let keys = Object.keys(dataArray[0]);

            if (provider === 'BEST') {
                const keysToSkip = ['consumptions', 'internalNotes', 'rawJson', 'extraData'];
                keys = keys.filter(k => !keysToSkip.includes(k));
            }

            let html = `<div class="table-responsive mt-3" style="max-height:300px; overflow:auto;">
        <table class="table table-bordered table-striped table-sm">
        <thead><tr>`;

            keys.forEach(k => {
                html += `<th>${k}</th>`;
            });

            html += `</tr></thead><tbody>`;

            dataArray.forEach(row => {
                html += `<tr>`;
                keys.forEach(k => {
                    let value = row[k];
                    if (value === "9999-12-31" || value === "1900-01-01T00:00:00" || value === "9999-12-31T00:00:00Z") value = '';
                    html +=
                        `<td>${(value !== null && value !== undefined && value !== '') ? value : ''}</td>`;
                });
                html += `</tr>`;
            });

            html += `</tbody></table></div>`;
            return html;
        }

        // Accept / Reject buttons
        $(document).on('click', '.accept-btn, .reject-btn', function() {
            let $_this = $(this);
            const docId = $_this.data('docid');
            const remarks = $('#electicity_remark').val().trim();
            const status = $_this.hasClass('accept-btn') ? 'accepted' : 'rejected';

            if (!remarks) {
                alert("Please enter remarks before proceeding.");
                return;
            }
            $.ajax({
                url: '{{ route('storeApiResult') }}',
                method: 'POST',
                data: {
                    _token: $('meta[name="csrf-token"]').attr('content'),
                    document_id: docId,
                    remarks: remarks,
                    status: status,

                },
                success: function(res) {
                    alert("Remarks added successfully!");
                    location.reload();
                },
                error: function(xhr) {
                    console.error(xhr.responseText);
                    alert("Something went wrong!");
                }
            });
        });

        function submitEligibility(status) {
            const comment = document.getElementById('final-remarks').value;
            const structure_use = document.getElementById('structure_use').value;
            const survey_id = document.getElementById('survey_id').value;
            const project_id = document.getElementById('project_id').value;

            if (!comment.trim()) {
                alert('Please enter remarks before submitting.');
                return;
            }

            fetch('{{ route('survey.update_statuses') }}', {
                    method: 'POST',
                    headers: {
                        'Content-Type': 'application/json',
                        'X-CSRF-TOKEN': '{{ csrf_token() }}'
                    },
                    body: JSON.stringify({
                        survey_id,
                        project_id,
                        structure_use,
                        status,
                        comment
                    })
                })
                .then(res => res.json())
                .then(data => {
                    if (data.success) {
                        alert('Status updated!');
                        location.reload();
                    } else {
                        alert(data.message || 'Error occurred!');
                    }
                })
                .catch(error => {
                    console.error(error);
                    alert('Something went wrong!');
                });
        }
    </script>
@endpush