@extends('backend.app')
@section('title')  عملائي @stop
@push('cssFiles')
    <link rel="stylesheet" type="text/css" href="{{asset('backend/assets/css/jquery.dataTables.min.css')}}">
    <link rel="stylesheet" type="text/css" href="{{asset('backend/assets/css/buttons.dataTables.min.css')}}">
@endpush
@section('content')
    <!-- Page Content -->
    <div class="content container-fluid">
        <!-- Page Header -->
        <div class="page-header">
            <div class="row align-items-center">
                <div class="col">
                    <h3 class="page-title">عملائي</h3>
                    <ul class="breadcrumb">
                        <li class="breadcrumb-item"><a href="{{url('/')}}">لوحة التحكم</a></li>
                        <li class="breadcrumb-item active">عملائي</li>
                    </ul>
                </div>

            </div>
        </div>
        <!-- /Page Header -->


        <!-- Search Filter -->
        <div class="row filter-row no-print">

            <div class="col-sm-6 col-md-6">
                <div class="form-group form-focus">
                    <form action="" id="filter">
                        @csrf
                        <select class="form-control   " name="name"  id="clientSelect" required>
                            <option value="" disabled selected>اختر العميل</option>
                            @foreach(\DB::table('clients')->whereIn('governorate_id',auth()->user()->governorates)->select('id','name')->get() as $key => $client)
                                <option value="{{$client->name}}"  @if(isset($_GET['name']) && $_GET['name'] == $client->name ) selected @endif>{{$client->name}}</option>
                            @endforeach
                        </select>
                    </form>
                </div>
            </div>
            <div class="col-sm-3 col-md-2">
                <a href="#" onclick="$('#filter').submit()" class="btn btn-success btn-sm btn-block"> بحث </a>
            </div>
            @if(isset($_GET['name']))

                <div class="col-sm-3 col-md-2">
                    <a href="{{route('user_clients_all')}}"  class="btn btn-primary btn-sm btn-block"> عرض الكل </a>
                </div>
            @endif

        </div>
        <!-- Search Filter -->

        <div class="row">
            <div class="col-md-12">
                <div class="table-responsive">
                    <div id="DataTables_Table_0_wrapper" class="dataTables_wrapper dt-bootstrap4 no-footer">
                        <div class="row">
                            <div class="col-sm-12">
                                <table id="example" class="display nowrap table" style="width:100%">
                                    <thead class="bg-primary">
                                    <tr role="row">
                                        <th class="sorting_asc" tabindex="0"
                                            aria-controls="DataTables_Table_0" rowspan="1" colspan="1"
                                            aria-sort="ascending"
                                            aria-label="Name: activate to sort column descending"
                                            style="width: 201px;">الاسم</th>
                                        <th class="sorting" tabindex="0"
                                            aria-controls="DataTables_Table_0" rowspan="1" colspan="1"
                                            aria-label="Client ID: activate to sort column ascending"
                                            style="width: 104px;">الهاتف</th>
                                        <th class="sorting" tabindex="0"
                                            aria-controls="DataTables_Table_0" rowspan="1" colspan="1"
                                            aria-label="Mobile: activate to sort column ascending"
                                            style="width: 92px;">المحافظة</th>
                                        <th class="sorting" tabindex="0"
                                            aria-controls="DataTables_Table_0" rowspan="1" colspan="1"
                                            aria-label="Status: activate to sort column ascending"
                                            style="width: 212px;">العنوان</th>
                                        <th class="text-right sorting no-print" tabindex="0"
                                            aria-controls="DataTables_Table_0" rowspan="1" colspan="1"
                                            aria-label="Action: activate to sort column ascending"
                                            style="width: 83px;">الموقع</th>
                                    </tr>
                                    </thead>
                                    <tbody>
                                    @if(count($data))
                                        @foreach($data as  $key=>$item)
                                            <tr role="row" class="odd">
                                                <td class="sorting_1">
                                                    <h2 class="table-avatar">
                                                        {{$item->name}}
                                                    </h2>
                                                </td>
                                                <td>{{$item->phone}}</td>
                                                <td>{{$item->governorateName}}</td>
                                                <td>{{$item->address}}</td>
                                                <td class="text-right no-print">
                                                    @if($item->location && !empty($item->location['lat']))
                                                    <a href=" https://maps.google.com/maps?q=loc:{{$item->location['lat'].','.$item->location['lng']}}" class="btn btn-info btn-sm" target="_blank"> عرض</a>
                                                    @else
                                                        <span class="text-danger">لم يتم حفظ موقع له</span>
                                                    @endif
                                                </td>

                                            </tr>

                                        @endforeach
                                    @else
                                        <tr>
                                            <td colspan="5" class="text-muted text-center"> لا يوجد بيانات .. </td>
                                        </tr>
                                    @endif

                                    </tbody>
                                </table>

                            </div>
                        </div>


                        <div class="row no-print">

                            <div class="col-sm-12 col-md-7">
                                <div class="dataTables_paginate paging_simple_numbers"
                                     id="DataTables_Table_0_paginate">
                                    {{$data->onEachSide(1)->links()}}
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>

    </div>
    <!-- /Page Content -->


@stop
@push('footerScripts')

    <link href="https://cdnjs.cloudflare.com/ajax/libs/select2/4.0.3/css/select2.min.css" rel="stylesheet" />
    <script src="https://cdnjs.cloudflare.com/ajax/libs/select2/4.0.3/js/select2.min.js"></script>
    <script>
        $.fn.select2.defaults.set("dir", "rtl");
        $.fn.select2.defaults.set("theme", "bootstrap");

        $("#clientSelect").select2();
    </script>
    <script>
        $(document).ready(function() {

            var table =  $('#example').DataTable( {
                dom: 'Bfrtip',
                "paging": false,
                "sDom": 'C<"clear">lfrtip',
                "oColVis": {
                    "aiExclude": [ 0 ]
                },
                "info": false,
                "searching": false,
                buttons: [


                    {
                        "extend": "excel",
                        "text": "تصدير Excel",
                        "filename": "العملاء",
                        "className": "btn btn-green",
                        "charset": "utf-8",
                        "bom": "true",
                        init: function(api, node, config) {
                            $(node).removeClass("btn-default");
                        },
                        exportOptions: {
                            columns: ':visible',
                        },
                    },{
                        "extend": "csv",
                        "text": "تصدير CSV",
                        "filename": "العملاء",
                        "className": "btn btn-green",
                        "charset": "utf-8",
                        "bom": "true",
                        init: function(api, node, config) {
                            $(node).removeClass("btn-default");
                        },
                        exportOptions: {
                            columns: ':visible',
                        },
                    },
                    {
                        extend: 'print',
                        text: 'طباعة و PDF',
                        exportOptions: {
                            columns: ':visible',
                        },
                    }
                    ,{
                        extend: 'collection',
                        text:"حذف أعمدة للتصدير",
                        buttons:[
                            'columnsToggle',
                            {
                                extend: 'colvisRestore',
                                text:"إعادة كل الأعمدة"
                            },
                        ]
                    }
                ],



            } );

        } );

    </script>
    <script src="{{asset('backend/assets/js/jquery.dataTables.min.js')}}"></script>
    <script src="{{asset('backend/assets/js/dataTables.buttons.min.js')}}"></script>
    <script src="{{asset('backend/assets/js/jsZip.min.js')}}"></script>
    <script src="{{asset('backend/assets/js/buttons.colVis.min.js')}}"></script>
    <script src="{{asset('backend/assets/js/buttons.html5.min.js')}}"></script>
    <script src="{{asset('backend/assets/js/buttons.print.min.js')}}"></script>
@endpush