@extends('Admin.layouts.app')
@section('title', 'Providers')

@section('content')
<!-- Page Heading -->
<div class="card-header py-3">
    <h3 class="font-22 font-bolder">Service Provider</h3>
</div>

<div class="card shadow mb-4">
    <div class="">
        @if(Session::has('done'))
            <div class="alert alert-success">{{ Session::get('done') }}</div>
        @endif
        @if(Session::has('delete'))
            <div class="alert alert-success">{{ Session::get('delete') }}</div>
        @endif

        <div class="table-responsive">
            <table class="table" id="laravel_datatable" width="100%" cellspacing="0">
                <thead>
                    <tr>
                        {{-- <th>S.No</th> --}}
                        <th>Service ID</th>
                        <th>Name</th>
                        <th>Total Booking</th>
                        {{-- <th>Email</th> --}}
                        {{-- <th>Status</th> --}}
                        <th>Approval</th>
                        <th width="105px">Action</th>
                    </tr>
                </thead>
            </table>
        </div>
    </div>
</div>
@endsection

@push('body-scripts')
<script src="//code.jquery.com/jquery-3.5.1.js"></script>
<script src="//cdn.datatables.net/1.10.24/js/jquery.dataTables.min.js"></script>

<script>
$(document).ready(function(){
    $('#laravel_datatable').DataTable({
        processing: true,
        serverSide: true,
        ajax: "{{ route('admin.providers') }}",
        columns: [
            {data: 'service_id', name: 'provider_services.id'}, // real DB column
            {data: 'name', name: 'users.name'}, // real DB column
            {data: 'total_bookings', name: 'bookings.id', orderable: false, searchable: false}, // COUNT(bookings.id)
            {data: 'is_admin_approved', name: 'users.is_admin_approved', orderable: false, searchable: false},
            {data: 'action', name: 'action', orderable: false, searchable: false}
        ],
        order: [[0, 'asc']] // sort by service_id
    });
});
</script>
@endpush