@if(sizeof($orders) > 0)
<form action="{{ URL::to('city_fix') }}" method="POST">
    @csrf
    <table>
        <thead>
            <tr>
                <th>Order #</th>
                <th>Address</th>
                <th>Current City</th>
                <th>New City</th>
            </tr>
        </thead>
        @php 
            $cities = DB::table('shipping_cities')->get();
        @endphp
        @foreach($orders as $order)
            @php
                $data = DB::table('orders')->where('order_name', $order)
                ->join('order_customer_details', 'order_customer_details.parent_id', 'orders.id')
                ->select('orders.id', 'city', 'address')
                ->first();
            @endphp
            @if($data)
            <tbody>
                <tr>
                    <td>
                        {{ $order }}
                        <input type="hidden" name="order_id[]" value="{{ $data->id }}">
                    </td>
                    <td>
                        <input type="text" value="{{ $data->address }}" readonly> 
                    </td>
                    <td>
                        <input type="text" value="{{ $data->city }}" readonly> 
                    </td>
                    <td>
                        <input type="text" name="new_city[]" list="new_city">
                        <datalist id="new_city">
                            @foreach($cities as $city)
                                <option value="{{ $city->city }}">
                            @endforeach
                        </datalist>
                    </td>
                </tr>
            </tbody>
            @endif
        @endforeach
    </table>
    <button type="submit">FIX</button>
</form>
@endif