<table class="table">
    <thead class="thead-light">
        <tr>
            <th scope="col" style="font-weight:bold;"> SI. No. </th>
            <th scope="col" style="font-weight:bold;"> Service Order ID</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;"> Document </th>
            <th scope="col" style="font-weight:bold;"> Flood Hazard Area </th>
            <th scope="col" style="font-weight:bold;"> State </th>
            <th scope="col" style="font-weight:bold;"> County </th>
            <th scope="col" style="font-weight:bold;"> NFIP Community Number </th>
            <th scope="col" style="font-weight:bold;"> NFIP Community Name </th>
            <th scope="col" style="font-weight:bold;"> Case No </th>
            <th scope="col" style="font-weight:bold;"> Date </th>
            <th scope="col" style="font-weight:bold;"> NFIP Map Panel </th>
            <th scope="col" style="font-weight:bold;"> No NFIP Map </th>
            <th scope="col" style="font-weight:bold;"> NFIP Map Number </th>
            <th scope="col" style="font-weight:bold;"> Flood Zone </th>
            <th scope="col" style="font-weight:bold;"> Map Change(LOMC) </th>
            <th scope="col" style="font-weight:bold;"> Regular Program </th>
            <th scope="col" style="font-weight:bold;"> Designation Date </th>
            <th scope="col" style="font-weight:bold;"> Emergency Program </th>
            <th scope="col" style="font-weight:bold;"> Insurance Available </th>
            <th scope="col" style="font-weight:bold;"> Flood Insurance </th>
            <th scope="col" style="font-weight:bold;"> Insurance Not Available </th>
            <th scope="col" style="font-weight:bold;"> Loan Amount </th>
            <th scope="col" style="font-weight:bold;"> Lender/Servicer ID </th>
            <th scope="col" style="font-weight:bold;"> Lender/Servicer Name </th>
            <th scope="col" style="font-weight:bold;"> Lender/Servicer Address </th>
            <th scope="col" style="font-weight:bold;"> Collateral Description </th>
            <th scope="col" style="font-weight:bold;"> Loan Identifier </th>
            <th scope="col" style="font-weight:bold;"> Preparer's Name </th>
            <th scope="col" style="font-weight:bold;"> Preparer's Contact </th>
            <th scope="col" style="font-weight:bold;"> Preparer's Address </th>
            <th scope="col" style="font-weight:bold;"> Preparer's Date of Determination </th>
            <th scope="col" style="font-weight:bold;"> Added Datetime</th>
            <th scope="col" style="font-weight:bold;"> Completed Date </th>
        </tr>
    </thead>
    <tbody>
                @foreach ($reportsDtData as $key => $floodreportsData)
            @php
                if ($floodreportsData['output_response_json'] != null) {
                    $responseData = json_decode($floodreportsData['output_response_json'], true);

                    if (
                        isset($responseData['flood_cert_data']['determination']['in_special_flood_hazard_area']) &&
                        $responseData['flood_cert_data']['determination']['in_special_flood_hazard_area'] == ''
                    ) {
                        $flood_hazard_area = '--';
                    } elseif (
                        isset($responseData['flood_cert_data']['determination']['in_special_flood_hazard_area']) &&
                        $responseData['flood_cert_data']['determination']['in_special_flood_hazard_area'] != ''
                    ) {
                        $flood_hazard_area =
                            $responseData['flood_cert_data']['determination']['in_special_flood_hazard_area'] == '1'
                                ? 'Yes'
                                : 'No';
                    } else {
                        $flood_hazard_area = '--';
                    }

                    if (
                        isset($responseData['flood_cert_data']['jurisdiction']['state']) &&
                        $responseData['flood_cert_data']['jurisdiction']['state'] == ''
                    ) {
                        $state = '--';
                    } elseif (
                        isset($responseData['flood_cert_data']['jurisdiction']['state']) &&
                        $responseData['flood_cert_data']['jurisdiction']['state'] != ''
                    ) {
                        $state = $responseData['flood_cert_data']['jurisdiction']['state'];
                    } else {
                        $state = '--';
                    }

                    if (
                        isset($responseData['flood_cert_data']['jurisdiction']['county']) &&
                        $responseData['flood_cert_data']['jurisdiction']['county'] == ''
                    ) {
                        $county = '--';
                    } elseif (
                        isset($responseData['flood_cert_data']['jurisdiction']['county']) &&
                        $responseData['flood_cert_data']['jurisdiction']['county'] != ''
                    ) {
                        $county = $responseData['flood_cert_data']['jurisdiction']['county'];
                    } else {
                        $county = '--';
                    }

                    if (
                        isset($responseData['flood_cert_data']['jurisdiction']['community_num']) &&
                        $responseData['flood_cert_data']['jurisdiction']['community_num'] == ''
                    ) {
                        $community = '--';
                    } elseif (
                        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']['jurisdiction']['community_name']) &&
                        $responseData['flood_cert_data']['jurisdiction']['community_name'] == ''
                    ) {
                        $community_name = '--';
                    } elseif (
                        isset($responseData['flood_cert_data']['jurisdiction']['community_name']) &&
                        $responseData['flood_cert_data']['jurisdiction']['community_name'] != ''
                    ) {
                        $community_name = $responseData['flood_cert_data']['jurisdiction']['community_name'];
                    } else {
                        $community_name = '--';
                    }

                    if (
                        isset($responseData['flood_cert_data']['flood_insurance']['case_no']) &&
                        $responseData['flood_cert_data']['flood_insurance']['case_no'] == ''
                    ) {
                        $case_no = '--';
                    } elseif (
                        isset($responseData['flood_cert_data']['flood_insurance']['case_no']) &&
                        $responseData['flood_cert_data']['flood_insurance']['case_no'] != ''
                    ) {
                        $case_no = $responseData['flood_cert_data']['flood_insurance']['case_no'];
                    } else {
                        $case_no = '--';
                    }

                    if (
                        isset($responseData['flood_cert_data']['flood_insurance']['date']) &&
                        $responseData['flood_cert_data']['flood_insurance']['date'] == ''
                    ) {
                        $date = '--';
                    } elseif (
                        isset($responseData['flood_cert_data']['flood_insurance']['date']) &&
                        $responseData['flood_cert_data']['flood_insurance']['date'] != ''
                    ) {
                        $date = date('m/d/Y', strtotime($responseData['flood_cert_data']['flood_insurance']['date']));
                    } else {
                        $date = '--';
                    }

                    if (
                        isset($responseData['flood_cert_data']['flood_insurance']['map_panel']) &&
                        $responseData['flood_cert_data']['flood_insurance']['map_panel'] == ''
                    ) {
                        $map_panel = '--';
                    } elseif (
                        isset($responseData['flood_cert_data']['flood_insurance']['map_panel']) &&
                        $responseData['flood_cert_data']['flood_insurance']['map_panel'] != ''
                    ) {
                        $map_panel = date(
                            'm/d/Y',
                            strtotime($responseData['flood_cert_data']['flood_insurance']['map_panel']),
                        );
                    } else {
                        $map_panel = '--';
                    }

                    if (
                        isset($responseData['flood_cert_data']['flood_insurance']['map']) &&
                        $responseData['flood_cert_data']['flood_insurance']['map'] == ''
                    ) {
                        $map = '--';
                    } elseif (
                        isset($responseData['flood_cert_data']['flood_insurance']['map']) &&
                        $responseData['flood_cert_data']['flood_insurance']['map'] != ''
                    ) {
                        $map = $responseData['flood_cert_data']['flood_insurance']['map'];
                    } else {
                        $map = '--';
                    }

                    if (
                        isset($responseData['flood_cert_data']['flood_insurance']['map_num']) &&
                        $responseData['flood_cert_data']['flood_insurance']['map_num'] == ''
                    ) {
                        $map_num = '--';
                    } elseif (
                        isset($responseData['flood_cert_data']['flood_insurance']['map_num']) &&
                        $responseData['flood_cert_data']['flood_insurance']['map_num'] != ''
                    ) {
                        $map_num = $responseData['flood_cert_data']['flood_insurance']['map_num'];
                    } else {
                        $map_num = '--';
                    }

                    if (
                        isset($responseData['flood_cert_data']['flood_insurance']['flood_zone']) &&
                        $responseData['flood_cert_data']['flood_insurance']['flood_zone'] == ''
                    ) {
                        $zone = '--';
                    } elseif (
                        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']['flood_insurance']['map_change']) &&
                        $responseData['flood_cert_data']['flood_insurance']['map_change'] == ''
                    ) {
                        $map_change = '--';
                    } elseif (
                        isset($responseData['flood_cert_data']['flood_insurance']['map_change']) &&
                        $responseData['flood_cert_data']['flood_insurance']['map_change'] != ''
                    ) {
                        $map_change =
                            $responseData['flood_cert_data']['flood_insurance']['map_change'] == 2 ? 'Yes' : 'No';
                    } else {
                        $map_change = '--';
                    }

                    if (
                        isset($responseData['flood_cert_data']['ffi_availability']['regular_program']) &&
                        $responseData['flood_cert_data']['ffi_availability']['regular_program'] == ''
                    ) {
                        $regular_program = '--';
                    } elseif (
                        isset($responseData['flood_cert_data']['ffi_availability']['regular_program']) &&
                        $responseData['flood_cert_data']['ffi_availability']['regular_program'] != ''
                    ) {
                        $regular_program = $responseData['flood_cert_data']['ffi_availability']['regular_program'];
                    } else {
                        $regular_program = '--';
                    }

                    if (
                        isset($responseData['flood_cert_data']['ffi_availability']['designation_date']) &&
                        $responseData['flood_cert_data']['ffi_availability']['designation_date'] == ''
                    ) {
                        $designation_date = '--';
                    } elseif (
                        isset($responseData['flood_cert_data']['ffi_availability']['designation_date']) &&
                        $responseData['flood_cert_data']['ffi_availability']['designation_date'] != ''
                    ) {
                        $designation_date = date(
                            'm/d/Y',
                            strtotime($responseData['flood_cert_data']['ffi_availability']['designation_date']),
                        );
                    } else {
                        $designation_date = '--';
                    }

                    if (
                        isset($responseData['flood_cert_data']['ffi_availability']['emergency_program']) &&
                        $responseData['flood_cert_data']['ffi_availability']['emergency_program'] == ''
                    ) {
                        $emergency_program = '--';
                    } elseif (
                        isset($responseData['flood_cert_data']['ffi_availability']['emergency_program']) &&
                        $responseData['flood_cert_data']['ffi_availability']['emergency_program'] != ''
                    ) {
                        $emergency_program = date(
                            'm/d/Y',
                            strtotime($responseData['flood_cert_data']['ffi_availability']['emergency_program']),
                        );
                    } else {
                        $emergency_program = '--';
                    }

                    if (
                        isset($responseData['flood_cert_data']['ffi_availability']['insurance_available']) &&
                        $responseData['flood_cert_data']['ffi_availability']['insurance_available'] == ''
                    ) {
                        $insurance_available = '--';
                    } elseif (
                        isset($responseData['flood_cert_data']['ffi_availability']['insurance_available']) &&
                        $responseData['flood_cert_data']['ffi_availability']['insurance_available'] != ''
                    ) {
                        $insurance_available = date(
                            'm/d/Y',
                            strtotime($responseData['flood_cert_data']['ffi_availability']['insurance_available']),
                        );
                    } else {
                        $insurance_available = '--';
                    }

                    if (
                        isset($responseData['flood_cert_data']['ffi_availability']['federal_flood_insurance']) &&
                        $responseData['flood_cert_data']['ffi_availability']['federal_flood_insurance'] == ''
                    ) {
                        $federal_flood_insurance = '--';
                    } elseif (
                        isset($responseData['flood_cert_data']['ffi_availability']['federal_flood_insurance']) &&
                        $responseData['flood_cert_data']['ffi_availability']['federal_flood_insurance'] != ''
                    ) {
                        $federal_flood_insurance = date(
                            'm/d/Y',
                            strtotime($responseData['flood_cert_data']['ffi_availability']['federal_flood_insurance']),
                        );
                    } else {
                        $federal_flood_insurance = '--';
                    }

                    if (
                        isset($responseData['flood_cert_data']['ffi_availability']['insurance_not_available']) &&
                        $responseData['flood_cert_data']['ffi_availability']['insurance_not_available'] == ''
                    ) {
                        $insurance_not_available = '--';
                    } elseif (
                        isset($responseData['flood_cert_data']['ffi_availability']['insurance_not_available']) &&
                        $responseData['flood_cert_data']['ffi_availability']['insurance_not_available'] != ''
                    ) {
                        $insurance_not_available = date(
                            'm/d/Y',
                            strtotime($responseData['flood_cert_data']['ffi_availability']['insurance_not_available']),
                        );
                    } else {
                        $insurance_not_available = '--';
                    }

                    if (
                        isset($responseData['flood_cert_data']['loan_information']['amount_of_flood_insurance']) &&
                        $responseData['flood_cert_data']['loan_information']['amount_of_flood_insurance'] == ''
                    ) {
                        $amount_of_flood_insurance = '--';
                    } elseif (
                        isset($responseData['flood_cert_data']['loan_information']['amount_of_flood_insurance']) &&
                        $responseData['flood_cert_data']['loan_information']['amount_of_flood_insurance'] != ''
                    ) {
                        $amount_of_flood_insurance =
                            $responseData['flood_cert_data']['loan_information']['amount_of_flood_insurance'];
                    } else {
                        $amount_of_flood_insurance = '--';
                    }

                    if (
                        isset($responseData['flood_cert_data']['loan_information']['lender_id']) &&
                        $responseData['flood_cert_data']['loan_information']['lender_id'] == ''
                    ) {
                        $lender_id = '--';
                    } elseif (
                        isset($responseData['flood_cert_data']['loan_information']['lender_id']) &&
                        $responseData['flood_cert_data']['loan_information']['lender_id'] != ''
                    ) {
                        $lender_id = $responseData['flood_cert_data']['loan_information']['lender_id'];
                    } else {
                        $lender_id = '--';
                    }

                    if (
                        isset($responseData['flood_cert_data']['loan_information']['lender_name']) &&
                        $responseData['flood_cert_data']['loan_information']['lender_name'] == ''
                    ) {
                        $lender_name = '--';
                    } elseif (
                        isset($responseData['flood_cert_data']['loan_information']['lender_name']) &&
                        $responseData['flood_cert_data']['loan_information']['lender_name'] != ''
                    ) {
                        $lender_name = $responseData['flood_cert_data']['loan_information']['lender_name'];
                    } else {
                        $lender_name = '--';
                    }

                    if (
                        isset($responseData['flood_cert_data']['loan_information']['lender_address']) &&
                        $responseData['flood_cert_data']['loan_information']['lender_address'] == ''
                    ) {
                        $lender_address = '--';
                    } elseif (
                        isset($responseData['flood_cert_data']['loan_information']['lender_address']) &&
                        $responseData['flood_cert_data']['loan_information']['lender_address'] != ''
                    ) {
                        $lender_address = $responseData['flood_cert_data']['loan_information']['lender_address'];
                    } else {
                        $lender_address = '--';
                    }

                    if (
                        isset($responseData['flood_cert_data']['loan_information']['collateral_desc']) &&
                        $responseData['flood_cert_data']['loan_information']['collateral_desc'] == ''
                    ) {
                        $collateral_desc = '--';
                    } elseif (
                        isset($responseData['flood_cert_data']['loan_information']['collateral_desc']) &&
                        $responseData['flood_cert_data']['loan_information']['collateral_desc'] != ''
                    ) {
                        $collateral_desc = $responseData['flood_cert_data']['loan_information']['collateral_desc'];
                    } else {
                        $collateral_desc = '--';
                    }

                    if (
                        isset($responseData['flood_cert_data']['loan_information']['loan_identifier']) &&
                        $responseData['flood_cert_data']['loan_information']['loan_identifier'] == ''
                    ) {
                        $loan_identifier = '--';
                    } elseif (
                        isset($responseData['flood_cert_data']['loan_information']['loan_identifier']) &&
                        $responseData['flood_cert_data']['loan_information']['loan_identifier'] != ''
                    ) {
                        $loan_identifier = $responseData['flood_cert_data']['loan_information']['loan_identifier'];
                    } else {
                        $loan_identifier = '--';
                    }

                    if (
                        isset($responseData['flood_cert_data']['preparer_information']['name']) &&
                        $responseData['flood_cert_data']['preparer_information']['name'] == ''
                    ) {
                        $name = '--';
                    } elseif (
                        isset($responseData['flood_cert_data']['preparer_information']['name']) &&
                        $responseData['flood_cert_data']['preparer_information']['name'] != ''
                    ) {
                        $name = $responseData['flood_cert_data']['preparer_information']['name'];
                    } else {
                        $name = '--';
                    }

                    if (
                        isset($responseData['flood_cert_data']['preparer_information']['number']) &&
                        $responseData['flood_cert_data']['preparer_information']['number'] == ''
                    ) {
                        $number = '--';
                    } elseif (
                        isset($responseData['flood_cert_data']['preparer_information']['number']) &&
                        $responseData['flood_cert_data']['preparer_information']['number'] != ''
                    ) {
                        $number = $responseData['flood_cert_data']['preparer_information']['number'];
                    } else {
                        $number = '--';
                    }

                    if (
                        isset($responseData['flood_cert_data']['preparer_information']['address']) &&
                        $responseData['flood_cert_data']['preparer_information']['address'] == ''
                    ) {
                        $street_address = '--';
                    } elseif (
                        isset($responseData['flood_cert_data']['preparer_information']['address']) &&
                        $responseData['flood_cert_data']['preparer_information']['address'] != ''
                    ) {
                        $street_address = $responseData['flood_cert_data']['preparer_information']['address'];
                    } else {
                        $street_address = '--';
                    }

                    if (
                        isset($responseData['flood_cert_data']['preparer_information']['date_of_determination']) &&
                        $responseData['flood_cert_data']['preparer_information']['date_of_determination'] == ''
                    ) {
                        $date_of_determination = '--';
                    } elseif (
                        isset($responseData['flood_cert_data']['preparer_information']['date_of_determination']) &&
                        $responseData['flood_cert_data']['preparer_information']['date_of_determination'] != ''
                    ) {
                        $date_of_determination = date(
                            'm/d/Y',
                            strtotime(
                                $responseData['flood_cert_data']['preparer_information']['date_of_determination'],
                            ),
                        );
                    } else {
                        $date_of_determination = '--';
                    }
                } else {
                    $flood_hazard_area = '--';
                    $state = '--';
                    $county = '--';
                    $community = '--';
                    $community_name = '--';
                    $case_no = '--';
                    $date = '--';
                    $map_panel = '--';
                    $map = '--';
                    $map_num = '--';
                    $zone = '--';
                    $map_change = '--';
                    $regular_program = '--';
                    $designation_date = '--';
                    $emergency_program = '--';
                    $insurance_available = '--';
                    $federal_flood_insurance = '--';
                    $insurance_not_available = '--';
                    $amount_of_flood_insurance = '--';
                    $lender_id = '--';
                    $lender_name = '--';
                    $lender_address = '--';
                    $collateral_desc = '--';
                    $loan_identifier = '--';
                    $name = '--';
                    $number = '--';
                    $street_address = '--';
                    $date_of_determination = '--';
                }

            @endphp
            <tr>
                <td>{{ $j++ }}</td>
                <td>
                    <p class="mb-0">{{ $floodreportsData['service_order_id'] }}</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">{{ asset('storage/docs/' . $floodreportsData['document']) }}</p>
                </td>
                <td>
                    <p class="mb-0">{{ $flood_hazard_area }}</p>
                </td>
                <td>
                    <p class="mb-0">{{ $state }}</p>
                </td>
                <td>
                    <p class="mb-0">{{ $county }}</p>
                </td>
                <td>
                    <p class="mb-0">{{ $community }}</p>
                </td>
                <td>
                    <p class="mb-0">{{ $community_name }}</p>
                </td>
                <td>
                    <p class="mb-0">{{ $case_no }}</p>
                </td>
                <td>
                    <p class="mb-0">{{ $date }}</p>
                </td>
                <td>
                    <p class="mb-0">{{ $map_panel }}</p>
                </td>
                <td>
                    <p class="mb-0">{{ $map }}</p>
                </td>
                <td>
                    <p class="mb-0">{{ $map_num }}</p>
                </td>
                <td>
                    <p class="mb-0">{{ $zone }}</p>
                </td>
                <td>
                    <p class="mb-0">{{ $map_change }}</p>
                </td>
                <td>
                    <p class="mb-0">{{ $regular_program }}</p>
                </td>
                <td>
                    <p class="mb-0">{{ $designation_date }}</p>
                </td>
                <td>
                    <p class="mb-0">{{ $emergency_program }}</p>
                </td>
                <td>
                    <p class="mb-0">{{ $insurance_available }}</p>
                </td>
                <td>
                    <p class="mb-0">{{ $federal_flood_insurance }}</p>
                </td>
                <td>
                    <p class="mb-0">{{ $insurance_not_available }}</p>
                </td>
                <td>
                    <p class="mb-0">{{ $amount_of_flood_insurance }}</p>
                </td>
                <td>
                    <p class="mb-0">{{ $lender_id }}</p>
                </td>
                <td>
                    <p class="mb-0">{{ $lender_name }}</p>
                </td>
                <td>
                    <p class="mb-0">{{ $lender_address }}</p>
                </td>
                <td>
                    <p class="mb-0">{{ $collateral_desc }}</p>
                </td>
                <td>
                    <p class="mb-0">{{ $loan_identifier }}</p>
                </td>
                <td>
                    <p class="mb-0">{{ $name }}</p>
                </td>
                <td>
                    <p class="mb-0">{{ $number }}</p>
                </td>
                <td>
                    <p class="mb-0">{{ $street_address }}</p>
                </td>
                <td>
                    <p class="mb-0">{{ $date_of_determination }}</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>
            </tr>
        @endforeach
    </tbody>
</table>