@extends('admin.layout.master')
@section('title', 'الرئيسية')
@section('content')


    <!-- start page title -->
    <div class="row">
        <div class="col-12">
            <div class="page-title-box">
                <div class="page-title-right">
                    <ol class="breadcrumb m-0">

                    </ol>
                </div>
                <h4 class="page-title">لوحة التحكم</h4>
            </div>
        </div>
    </div>
    <!-- end page title -->

    <div class="row">
        <div class="col-md-6 col-xl-2">
            <div class="card-box tilebox-one">
                <i class="icon-layers float-right m-0 h2 text-muted"></i>
                <a href="#">
                    <h6 class="text-muted text-uppercase mt-0">عدد الطلبات</h6>
                </a>
                <h3 class="my-3" data-plugin="counterup">{{\App\Models\Order::count()}}</h3>
            </div>
        </div>
        <div class="col-md-6 col-xl-2">
            <div class="card-box tilebox-one">
                <i class="icon-layers float-right m-0 h2 text-muted"></i>
                <a href="#">
                    <h6 class="text-muted text-uppercase mt-0">عدد مقدمي الخدمات </h6>
                </a>
                <h3 class="my-3" data-plugin="counterup">{{\App\User::where('type', 'worker')->where('aproved', 'yes')->where('end_date', '>', now())->whereNotNull('end_date')->whereNotNull('package_date')->count()}}</h3>
            </div>
        </div>
                <div class="col-md-6 col-xl-2">
            <div class="card-box tilebox-one">
                <i class="icon-layers float-right m-0 h2 text-muted"></i>
                <a href="#">
                    <h6 class="text-muted text-uppercase mt-0">عدد طلبات التسجيل</h6>
                </a>
                <h3 class="my-3" data-plugin="counterup">{{\App\User::where('type', 'worker')->whereIn('aproved',['pending'])->count()}}</h3>
            </div>
        </div>
        <div class="col-md-6 col-xl-2">
            <div class="card-box tilebox-one">
                <i class="icon-layers float-right m-0 h2 text-muted"></i>
                <a href="#">
                    <h6 class="text-muted text-uppercase mt-0">عدد العملاء </h6>
                </a>
                <h3 class="my-3"
                    data-plugin="counterup">{{\App\User::whereType('client')->count()}}</h3>
            </div>
        </div>

    </div>
@stop