@if(session()->has('admin_userid'))
   
@else 
 <script>window.location.href="admin";</script>
@endif

@extends('backend.header')
@section('content')

    <div class="container-fluid">
        <div class="row bg-title">
                    <div class="col-lg-3 col-md-4 col-sm-4 col-xs-12">
                        <h4 class="page-title">City Master Lists</h4> </div>
                     <div class="col-lg-9 col-sm-8 col-md-8 col-xs-12 text-right">
                            <button type="button" class="btn btn-primary" onclick="window.location.href='add-city-master'"><i class="fa fa-plus"></i>Add City</button>
                        </div>
                    <!-- <div class="col-lg-9 col-sm-8 col-md-8 col-xs-12">
                        <ol class="breadcrumb">
                            <li><a href="#">Home</a></li>
                            <li class="active">Dashboard</li>
                        </ol>
                    </div> -->
                    <!-- /.col-lg-12 -->
                </div>
            @php
                $get_city =DB::table('city_master')->get();
                $count = 1;
            @endphp
        <div class="col-sm-12">
            
            <div class="white-box">
                <!-- <div style="display: flex; margin-bottom: 2%;">
                    <h3 class="box-title m-b-0">City Master Lists</h3>
                    <a href="{{'add-city-master'}}" class="btn btn-primary" style="margin-left: 77%; z-index:999;" ><i class="fa fa-plus"></i>&nbsp; Add City</a>
                </div> -->
                <div class="table-responsive">
                    <table id="myTable" class="table table-striped">
                        <thead>
                            <tr>
                                <th>S.No</th>
                                <th>City name</th>
                                <th>Action</th>
                            </tr>
                        </thead>
                        <tbody>
                            @foreach ($get_city as $city)
                            <tr>
                                <td>{{$count}}</td>
                                <td>{{$city->city_name}}</td>
                                <td>
                                    <button class="btn" onclick="window.location.href='edit-city-master&id={{$city->city_id}}'"><i class="fa fa-edit"></i></button>
                                    <button class="btn" onclick="if(confirm('Are you Sure Want to Delete this City?') == true){location.href = 'delete_city&id={{$city->city_id}}';}"><i class="fa fa-trash-o"></i></button>
                                </td>
                            </tr>
                            @php
                             $count++   
                            @endphp
                            @endforeach
                        </tbody>
                    </table>
                </div>
            </div>
        </div>
</div>
    <script src="assets/plugins/bower_components/jquery/dist/jquery.min.js"></script>
    <script src="assets/plugins/bower_components/datatables/jquery.dataTables.min.js"></script>
    <!-- start - This is for export functionality only -->
    <script src="https://cdn.datatables.net/buttons/1.2.2/js/dataTables.buttons.min.js"></script>
    <script src="https://cdn.datatables.net/buttons/1.2.2/js/buttons.flash.min.js"></script>
    <script src="https://cdnjs.cloudflare.com/ajax/libs/jszip/2.5.0/jszip.min.js"></script>
    <script src="https://cdn.rawgit.com/bpampuch/pdfmake/0.1.18/build/pdfmake.min.js"></script>
    <script src="https://cdn.rawgit.com/bpampuch/pdfmake/0.1.18/build/vfs_fonts.js"></script>
    <script src="https://cdn.datatables.net/buttons/1.2.2/js/buttons.html5.min.js"></script>
    <script src="https://cdn.datatables.net/buttons/1.2.2/js/buttons.print.min.js"></script>

    <link href="assets/plugins/bower_components/datatables/jquery.dataTables.min.css" rel="stylesheet" type="text/css" />
    <link href="https://cdn.datatables.net/buttons/1.2.2/css/buttons.dataTables.min.css" rel="stylesheet" type="text/css" />
    <script>
        $(document).ready(function() {
            $('#myTable').DataTable();
            $(document).ready(function() {
                var table = $('#example').DataTable({
                    "columnDefs": [{
                        "visible": false,
                        "targets": 2
                    }],
                    "order": [
                        [2, 'asc']
                    ],
                    "displayLength": 25,
                    "drawCallback": function(settings) {
                        var api = this.api();
                        var rows = api.rows({
                            page: 'current'
                        }).nodes();
                        var last = null;
    
                        api.column(2, {
                            page: 'current'
                        }).data().each(function(group, i) {
                            if (last !== group) {
                                $(rows).eq(i).before(
                                    '<tr class="group"><td colspan="5">' + group + '</td></tr>'
                                );
    
                                last = group;
                            }
                        });
                    }
                });
    
                // Order by the grouping
                $('#example tbody').on('click', 'tr.group', function() {
                    var currentOrder = table.order()[0];
                    if (currentOrder[0] === 2 && currentOrder[1] === 'asc') {
                        table.order([2, 'desc']).draw();
                    } else {
                        table.order([2, 'asc']).draw();
                    }
                });
            });
        });
        $('#example23').DataTable({
            dom: 'Bfrtip',
            buttons: [
                'copy', 'csv', 'excel', 'pdf', 'print'
            ]
        });
        </script>
@endsection