@extends('admin.index')
@section('content')
<!-- Page Content Start -->
<div class="content-page">

    <div class="content">
        <div class="container-fluid">
            <!-- Page title box -->
            <div class="page-title-box">
                <ol class="breadcrumb float-right">
                    <li class="breadcrumb-item"><a href="javascript:void(0);">الرئيسية</a></li>
                    <li class="breadcrumb-item"><a href="javascript:void(0);">الاشتراكات</a></li>
                    <li class="breadcrumb-item active">عرض الاشتراكات</li>
                </ol>
                <h4 class="page-title">عرض الاشتراكات</h4>
            </div><!-- End page title box -->
            <div class="row">

                <div class="col-md-12">
                    @if (session('success'))
                    <div class="alert alert-success">
                        {{ session('success') }}
                    </div>
                    @endif
                </div>

                <div class="col-md-12">
                    @if (session('error'))
                    <div class="alert alert-danger">
                        {{ session('error') }}
                    </div>
                    @endif
                </div>

                <div class="col-md-12">
                    <div class="card-box">
                        <form action="">
                            <div class="row">
                                <div class="col-md-3 mt-3">
                                    <input class="form-control" type="number" name="id" value="{{request('id')}}" placeholder="الرقم المدني">
                                </div>
                                <div class="col-md-3 mt-3">
                                    <input class="form-control" type="text" name="username" value="{{request('username')}}" placeholder="اسم المستخدم">
                                </div>
                                <!-- <div class="col-md-3 mt-3">
                                    <input class="form-control" type="email" name="email" value="{{request('email')}}" placeholder="البريد الالكتروني">
                                </div> -->
                                <div class="col-md-3 mt-3">
                                    <select class="form-control" name="nationality_id">
                                        <option value="">اختر الجنسية</option>
                                        @foreach(\App\Nationality::get() as $val)
                                        <option value="{{$val->id}}" {{request('nationality_id') == $val->id ? 'selected' : ''}}>{{$val->name_ar}}</option>
                                        @endforeach
                                    </select>
                                </div>
                                <div class="col-md-3 mt-3">
                                    <select class="form-control" name="name_id">
                                        <option value="">اختر الفئة</option>
                                        @foreach(\App\SubscriptionsName::get() as $val)
                                        <option value="{{$val->id}}" {{request('name_id') == $val->id ? 'selected' : ''}}>{{$val->name_ar}}</option>
                                        @endforeach
                                    </select>
                                </div>
                                <div class="col-md-3 mt-3">
                                    <select class="form-control" name="type">
                                        <option value="">نوع الترتيب</option>
                                        <option value="winner" {{request('type') == 'winner' ? 'selected' : ''}}>الفائزون</option>
                                        <option value="name_id" {{request('type') == 'name_id' ? 'selected' : ''}}>الفئة</option>
                                        <option value="level" {{request('type') == 'level' ? 'selected' : ''}}>المركز</option>
                                        <option value="degree" {{request('type') == 'degree' ? 'selected' : ''}}>الدرجة</option>
                                    </select>
                                </div>

                                <div class="col-md-3 mt-3">
                                    <select class="form-control" name="winner">
                                        <option value="">اختر نوع الفائزون</option>
                                        <option value="1" {{request('winner') == '1' ? 'selected' : ''}}>الفائزون</option>
                                        <option value="2" {{request('winner') == '2' ? 'selected' : ''}}>الغير فائزون</option>
                                    </select>
                                </div>
                                <div class="col-md-3 mt-3">
                                    <select class="form-control" name="gender">
                                        <option value="">اخترا الجنس</option>
                                        <option value="male" {{request('gender') == 'male' ? 'selected' : ''}}>ذكر</option>
                                        <option value="female" {{request('gender') == 'female' ? 'selected' : ''}}>أنثى</option>
                                    </select>
                                </div>
                                <div class="col-md-3 mt-3">
                                    <select class="form-control" name="city_id">
                                        <option value="">اخترا المحافظة</option>
                                        @foreach(\App\City::get() as $val)
                                        <option value="{{$val->id}}" {{request('city_id') == $val->id ? 'selected' : ''}}>{{$val->name_ar}}</option>
                                        @endforeach
                                    </select>
                                </div>
                                <div class="col-md-3 mt-3">
                                    <select class="form-control" name="order_type">
                                        <option value="">طريقة الترتيب</option>
                                        <option value="asc" {{request('order_type') == 'asc' ? 'selected' : ''}}>تصاعدي</option>
                                        <option value="desc" {{request('order_type') == 'desc' ? 'selected' : ''}}>تنازلي</option>
                                    </select>
                                </div>
                                <div class="col-md-3 mt-3">
                                    <input class="form-control" type="number" placeholder="السنة" name="date" value="{{request('date')}}">
                                </div>
                                <div class="col-md-3 mt-3">
                                    <input class="btn btn-info" type="submit" value="فلترة">
                                </div>
                            </div>
                        </form>
                    </div>
                </div>


                <div class="col-12">
                    <div class="card-box">

                        <div class="row" style="margin-bottom: 15px">
                            <h4 class="header-title col-md-8">عرض الاشتراكات ({{$count}})</h4>
                            <div class="col-md-4 mr-auto text-right">
                                <a href="{{url('admin/subscriptions/excel/export?' . $_SERVER['QUERY_STRING'] )}}" class="btn btn-icon btn-info">
                                    <i class="fas fa-print"></i> تصدير اكسل
                                </a>
                                <a href="{{url('admin/subscriptions/excel/import')}}" class="btn btn-icon btn-success">
                                    <i class="mdi mdi-plus"></i> استيراد اكسل
                                </a>
                            </div>
                        </div>

                        <div class="table-responsive">
                            <table class="table table-bordered">
                                <thead>
                                    <tr class="text-center">
                                        <th>
                                            مسلسل
                                        </th>
                                        <th>اسم المستخدم</th>
                                        <th>الجنس</th>
                                        <th>الرقرم المدني</th>
                                        <th>رقم الهاتف</th>
                                        <th>رقم الهاتف 2</th>
                                        <th class="text-center">اسم الفئة</th>
                                        <th class="text-center">السنة</th>
                                        <th class="text-center">المركز</th>
                                        <th class="text-center">الدرجة</th>
                                        <th class="text-center">التحكم</th>
                                    </tr>
                                </thead>
                                <tbody>

                                    @foreach($data as $key => $val)
                                    @if(!empty($val->user->username))
                                    <tr>
                                        <td class="text-center">
                                            {{$key + 1}}
                                        </td>

                                        <td style="color: blue;">{{$val->user->username}}</td>
                                        <td>{{$val->user->gender == 'male' ? "ذكر" : "أنثى"}}</td>
                                        <td>{{$val->user->identify}}</td>
                                        <td>{{$val->user->mobile}}</td>
                                        <td>{{$val->user->mobile2}}</td>
                                        <td class="text-center">{{$val->s_name->name_ar}}</td>
                                        <td class="text-center">{{$val->date}}</td>
                                        <td class="text-center">{{$val->level}}</td>
                                        <td class="text-center">{{$val->degree}}</td>


                                        <td class="text-center">

                                            <a href="{{url('/')}}/admin/subscriptions/edit/{{$val->id}}" class="btn btn-icon btn-info" title="تعديل">
                                                <i class="mdi mdi-square-edit-outline"></i>
                                            </a>

                                        </td>
                                    </tr>
                                    @endif
                                    @endforeach
                                </tbody>
                            </table>
                        </div>
                        @if (empty(request('username')) and empty(request('id')) and empty(request('email')) and empty(request('gender')) and empty(request('city_id')) and empty(request('nationality_id')) and empty(request('name_id')) and empty(request('date')) and empty(request('type')))
                        {{$data->links()}}
                        @endif

                    </div><!-- end card-box -->
                </div>
                <!-- end col -->
            </div><!-- end row -->


        </div><!-- end container-fluid-->
    </div><!-- end contant-->
</div>
<!-- End Page Content-->


<!-- Modal -->
<div class="modal fade" id="exampleModal" tabindex="-1" role="dialog" aria-labelledby="exampleModalLabel" aria-hidden="true">
    <div class="modal-dialog" role="document">
        <div class="modal-content">
            <div class="modal-header">
                <h5 class="modal-title" id="exampleModalLabel">حذف</h5>
                <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                    <span aria-hidden="true">&times;</span>
                </button>
            </div>
            <div class="modal-body">
                هل أنت متأكد من عملية الحذف
            </div>
            <div class="modal-footer">
                <button type="button" class="btn btn-secondary" data-dismiss="modal">إلغاء</button>
                <button type="button" class="btn btn-danger delete-yes">حذف</button>
            </div>
        </div>
    </div>
</div>

@endsection