@extends('admin.layouts.app')

@section('content')
    <section id="column-selectors">
        <div class="row">
            <div class="col-12">
                <div class="card">
                    <div class="card-header">
                        <h4 class="card-title">City</h4>
                        <span>
                            <a href="{{ route('admin.city.create') }}" class="btn btn-primary">
                                <i class="fa fa-plus"></i> Add New
                            </a>
                        </span>
                    </div>
                    <div class="card-content">
                        <div class="card-body card-dashboard">
                            <div class="table-responsive">
                                <table class="table table-striped dataex-html5-selectors">
                                    <thead>
                                        <tr>
                                            <th>Name</th>
                                            <th>State</th>
                                            <th>Country</th>
                                            <th>Created At</th>
                                            <th>Actions</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                        @foreach ($cities as $key => $city)
                                            <tr>
                                                <td>{{ $city->name }}</td>
                                                <td>{{ $city->state->name }}</td>
                                                <td>{{ $city->state->country->name }}</td>
                                                <td>
                                                    <span style="display: none">
                                                        {!! strtotime($city->created_at) !!}
                                                    </span>
                                                    {!! date('m/d/Y H:i:A', strtotime($city->created_at)) !!}
                                                </td>
                                                <td>
                                                    <a href="{{ route('admin.city.edit', $city->id) }}"
                                                        class="btn btn-sm btn-primary waves-effect waves-light">
                                                        <i class="feather icon-edit"></i>
                                                    </a>
                                                </td>
                                            </tr>
                                        @endforeach
                                    </tbody>
                                </table>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </section>
@endsection

@section('footer-js')
    <script>
        $(document).ready(function() {
            $('#datatable').DataTable({
                "order": [
                    [2, "desc"]
                ] // Sort by the fourth column (created_at) in descending order
            });
        });
    </script>
@endsection