<table class="table">
    <thead class="thead-light">
        <tr>
            <th scope="col" style="font-weight:bold;"> SI. No. </th>
            @if (auth()->user()->user_type_id == 1)
                <th scope="col" style="font-weight:bold;"> Vendor Name </th>
            @endif
            @if (auth()->user()->user_type_id == 1 || auth()->user()->user_type_id == 2 || auth()->user()->user_type_id == 3)
                <th scope="col" style="font-weight:bold;"> Lender Name </th>
            @endif
            <th scope="col" style="font-weight:bold;"> Service Order ID</th>
            <th scope="col" style="font-weight:bold;"> Application No# </th>
            <th scope="col" style="font-weight:bold;"> Borrower/Business Name</th>
            <th scope="col" style="font-weight:bold;"> Property </th>
            <th scope="col" style="font-weight:bold;"> Service Type </th>
            <th scope="col" style="font-weight:bold;"> Added Datetime</th>
            <th scope="col" style="font-weight:bold;"> Completed Date </th>
            <th scope="col" style="font-weight:bold;"> Zone </th>
            <th scope="col" style="font-weight:bold;"> Community </th>
            <th scope="col" style="font-weight:bold;"> Map-Panel</th>
        </tr>
    </thead>
    <tbody>
                @foreach ($reportsDtData as $key => $floodreportsData)
            @php
                if ($floodreportsData['output_response_json'] != null) {
                    if ($floodreportsData['vendor_id'] == 7) {
                        $xmlstring = simplexml_load_string($floodreportsData['output_response_json']);
                        $json = json_encode($xmlstring);
                        $output = json_decode($json, true);

                        if(isset($output['RESPONSE']['RESPONSE_DATA']['FLOOD_RESPONSE']['FLOOD_DETERMINATION']['_BUILDING_INFORMATION']['@attributes']['NFIPFloodZoneIdentifier']) && $output['RESPONSE']['RESPONSE_DATA']['FLOOD_RESPONSE']['FLOOD_DETERMINATION']['_BUILDING_INFORMATION']['@attributes']['NFIPFloodZoneIdentifier'] == "") {
                            $zone = '--';
                        } else if(isset($output['RESPONSE']['RESPONSE_DATA']['FLOOD_RESPONSE']['FLOOD_DETERMINATION']['_BUILDING_INFORMATION']['@attributes']['NFIPFloodZoneIdentifier']) && $output['RESPONSE']['RESPONSE_DATA']['FLOOD_RESPONSE']['FLOOD_DETERMINATION']['_BUILDING_INFORMATION']['@attributes']['NFIPFloodZoneIdentifier'] != "") {
                            $zone = $output['RESPONSE']['RESPONSE_DATA']['FLOOD_RESPONSE']['FLOOD_DETERMINATION']['_BUILDING_INFORMATION']['@attributes']['NFIPFloodZoneIdentifier'];
                        } else {
                            $zone = '--';
                        }

                        if(isset($output['RESPONSE']['RESPONSE_DATA']['FLOOD_RESPONSE']['FLOOD_DETERMINATION']['_COMMUNITY_INFORMATION']['@attributes']['NFIPCommunityIdentifier']) && $output['RESPONSE']['RESPONSE_DATA']['FLOOD_RESPONSE']['FLOOD_DETERMINATION']['_COMMUNITY_INFORMATION']['@attributes']['NFIPCommunityIdentifier'] == "") {
                            $community = '--';
                        } else if(isset($output['RESPONSE']['RESPONSE_DATA']['FLOOD_RESPONSE']['FLOOD_DETERMINATION']['_COMMUNITY_INFORMATION']['@attributes']['NFIPCommunityIdentifier']) && $output['RESPONSE']['RESPONSE_DATA']['FLOOD_RESPONSE']['FLOOD_DETERMINATION']['_COMMUNITY_INFORMATION']['@attributes']['NFIPCommunityIdentifier'] != "") {
                            $community = $output['RESPONSE']['RESPONSE_DATA']['FLOOD_RESPONSE']['FLOOD_DETERMINATION']['_COMMUNITY_INFORMATION']['@attributes']['NFIPCommunityIdentifier'];
                        } else {
                            $community = '--';
                        }

                        if(isset($output['RESPONSE']['RESPONSE_DATA']['FLOOD_RESPONSE']['FLOOD_DETERMINATION']['_BUILDING_INFORMATION']['@attributes']['NFIPMapIdentifier']) && $output['RESPONSE']['RESPONSE_DATA']['FLOOD_RESPONSE']['FLOOD_DETERMINATION']['_BUILDING_INFORMATION']['@attributes']['NFIPMapIdentifier'] == "") {
                            $map_panel = '--';
                        } else if(isset($output['RESPONSE']['RESPONSE_DATA']['FLOOD_RESPONSE']['FLOOD_DETERMINATION']['_BUILDING_INFORMATION']['@attributes']['NFIPMapIdentifier']) && $output['RESPONSE']['RESPONSE_DATA']['FLOOD_RESPONSE']['FLOOD_DETERMINATION']['_BUILDING_INFORMATION']['@attributes']['NFIPMapIdentifier'] != "") {
                            $map_panel = $output['RESPONSE']['RESPONSE_DATA']['FLOOD_RESPONSE']['FLOOD_DETERMINATION']['_BUILDING_INFORMATION']['@attributes']['NFIPMapIdentifier'];
                        } else {
                            $map_panel = '--';
                        }
                    } elseif ($floodreportsData['vendor_id'] == 8) {
                        $responseData = json_decode($floodreportsData['output_response_json'], true);
                        if(isset($responseData['flood_cert_data']['flood_insurance']['flood_zone']) && $responseData['flood_cert_data']['flood_insurance']['flood_zone'] == "") {
                            $zone = '--';
                        } else if(isset($responseData['flood_cert_data']['flood_insurance']['flood_zone']) && $responseData['flood_cert_data']['flood_insurance']['flood_zone'] != "") {
                            $zone = $responseData['flood_cert_data']['flood_insurance']['flood_zone'];
                        } else {
                            $zone = '--';
                        }

                        if(isset($responseData['flood_cert_data']['jurisdiction']['community_num']) && $responseData['flood_cert_data']['jurisdiction']['community_num'] == "") {
                            $community = '--';
                        } else if(isset($responseData['flood_cert_data']['jurisdiction']['community_num']) && $responseData['flood_cert_data']['jurisdiction']['community_num'] != "") {
                            $community = $responseData['flood_cert_data']['jurisdiction']['community_num'];
                        } else {
                            $community = '--';
                        }

                        if(isset($responseData['flood_cert_data']['flood_insurance']['map_num']) && $responseData['flood_cert_data']['flood_insurance']['map_num'] == "") {
                            $map_panel = '--';
                        } else if(isset($responseData['flood_cert_data']['flood_insurance']['map_num']) && $responseData['flood_cert_data']['flood_insurance']['map_num'] != "") {
                            $map_panel = $responseData['flood_cert_data']['flood_insurance']['map_num'];
                        } else {
                            $map_panel = '--';
                        }
                    }
                } else {
                    $zone = '--';
                    $community = '--';
                    $map_panel = '--';
                }

                $businessname = $floodreportsData['lender_loans_data']['business_name'];
                $firstname = $floodreportsData['lender_loans_data']['primary_borrower_first_name'];
                $middlename = $floodreportsData['lender_loans_data']['primary_borrower_middle_name'];
                $lastname = $floodreportsData['lender_loans_data']['primary_borrower_last_name'];
                $secfirstname = $floodreportsData['lender_loans_data']['secondary_borrower_first_name'];
                $secmiddlename = $floodreportsData['lender_loans_data']['secondary_borrower_middle_name'];
                $seclastname = $floodreportsData['lender_loans_data']['secondary_borrower_last_name'];
                $secondname = null;
                if ($middlename != null) {
                    $prborrowername = $firstname . ' ' . $middlename . ' ' . $lastname;
                } else {
                    $prborrowername = $firstname . ' ' . $lastname;
                }

                if($secfirstname != null)
                {
                    $secondname = $secfirstname;
                }
                if($secmiddlename != null)
                {
                    $secondname = $secondname . ' ' . $secmiddlename;
                }
                if($seclastname != null)
                {
                    $secondname = $secondname . ' ' . $seclastname;
                }
            @endphp
            <tr>
                <td>{{ $j++ }}</td>
                @if (auth()->user()->user_type_id == 1)
                    <td>
                        <p class="mb-0">{{ $floodreportsData['lender_loans_data']['lender_data']['vendor']['name'] }}
                        </p>
                    </td>
                @endif
                @if (auth()->user()->user_type_id == 1 || auth()->user()->user_type_id == 2 || auth()->user()->user_type_id == 3)
                    <td>
                        <p class="mb-0">{{ $floodreportsData['lender_loans_data']['lender_data']['lender_name'] }}</p>
                    </td>
                @endif
                <td>
                    <p class="mb-0">{{ $floodreportsData['service_order_id'] }}</p>
                </td>
                <td>
                    <p class="mb-0">{{ $floodreportsData['lender_loans_data']['application_no'] }}</p>
                </td>
                <td>
                    <p class="mb-0">
                                                                                                            {{ $prborrowername }}
                                                                                                </p>
                </td>
                <td>
                    <p class="mb-0">
                        {{ $floodreportsData['lender_loans_data']['property_address'] . ' ' . $floodreportsData['lender_loans_data']['property_city'] . ' ' . $floodreportsData['lender_loans_data']['property_state_data']['short_code'] . ' ' . $floodreportsData['lender_loans_data']['property_zip'] }}
                    </p>
                </td>
                <td>
                    <p class="mb-0">{{ $floodreportsData['vendor_services_data']['vendor_service_name'] }}</p>
                </td>
                <td>
                    <p class="mb-0">{{ date('m-d-Y h:m a', strtotime($floodreportsData['created_at'])) }}</p>
                </td>
                <td>
                    <p class="mb-0">{{ date('m-d-Y h:m a', strtotime($floodreportsData['updated_at'])) }}</p>
                </td>
                <td>
                    <p class="mb-0">{{ $zone }}</p>
                </td>
                <td>
                    <p class="mb-0">{{ $community }}</p>
                </td>
                <td>
                    <p class="mb-0">{{ $map_panel }}</p>
                </td>
            </tr>
        @endforeach
    </tbody>
</table>