@extends('main.main_back')

@section('title')
    Tableau de bord
@endsection
@section('style-up')
    <link href="{{ asset('vendor/select2/css/select2.min.css') }}" rel="stylesheet">
    <link href="{{ asset('vendor/datatables/css/jquery.dataTables.min.css') }}" rel="stylesheet">
@endsection
@section('pagination')
    Tableau de bord
@endsection

@section('content')
<div class="row">
    <div class="col-xl-12">
        <div class="row">
            <div class="col-xl-12">
                <div class="row">
                    <h3><u>Récapitulatif Bordereau en F CFA</u></h3>
                    @php
                        $agencyId = request()->get('agency');
                        //dd(amountBordereau('toDay',$agencyId));
                    @endphp
                    {{-- @if(isAgency() === false) --}}
                    <div class="col-xl-12 col-lg-12">
                        <div class="card">
                            <div class="card-body">
                                <div class="basic-form">
                                    <select class="form-control select2" name="agency" id="agencySelect">
                                        <option value="">Selectionner une agence</option>
                                        @if(isset($agencies) && COUNT($agencies) > 0)
                                            @foreach ($agencies as $key => $value)
                                                <option value="{{ $value->id }}" {{ $value->id == $agencyId ? 'selected' : '' }}>
                                                    {{ $value->ag_name }}
                                                </option>
                                            @endforeach
                                        @endif
                                    </select>
                                </div>
                            </div>
                        </div>
                    </div>
                    {{-- @endif --}}
                    <div class="col-xl-3 col-sm-6">
                        <div class="card booking">
                            <div class="card-body">
                                <div class="booking-status d-flex align-items-center">
                                    <span>
                                        <svg version="1.1" xmlns="http://www.w3.org/2000/svg" fill="#01adef" viewBox="0 0 50 50" xmlns:xlink="http://www.w3.org/1999/xlink" width="30" height="30"><g><g><path d="M36.318 14.063 46.387 16.709 48.926 6.641l-1.934 -0.508 -1.65 6.279C41.123 5.605 33.594 1.074 25 1.074 11.787 1.074 1.074 11.787 1.074 25s10.713 23.926 23.926 23.926c8.818 0 16.514 -4.766 20.664 -11.865l-1.729 -0.938c-3.818 6.484 -10.869 10.84 -18.936 10.84 -12.129 0 -21.963 -9.834 -21.963 -21.963S12.871 3.037 25 3.037c8.135 0 15.244 4.424 19.033 11.006l-7.207 -1.914z"/>
                                            <path d="M26.055 35.615V33.789c1.729 -0.098 3.047 -0.605 4.063 -1.523S31.641 30.127 31.641 28.711c0 -1.523 -0.41 -2.646 -1.318 -3.359 -0.918 -0.811 -2.236 -1.426 -4.17 -1.826h-0.098V18.848c1.318 0.205 2.441 0.605 3.555 1.426l1.631 -2.236c-1.631 -1.123 -3.359 -1.729 -5.186 -1.826v-1.221h-1.523V16.211c-1.523 0.098 -2.852 0.605 -3.867 1.523S19.141 19.873 19.141 21.289s0.41 2.539 1.318 3.252c0.811 0.713 2.236 1.318 4.063 1.729v4.775c-1.426 -0.205 -2.852 -0.918 -4.268 -2.139l-1.826 2.139c1.826 1.631 3.867 2.539 6.104 2.744v1.826zm0.098 -8.848c1.016 0.303 1.631 0.605 2.031 0.918 0.303 0.41 0.508 0.811 0.508 1.426s-0.205 1.016 -0.713 1.426 -1.123 0.605 -1.826 0.713zm-3.555 -4.365c-0.303 -0.303 -0.508 -0.811 -0.508 -1.318 0 -0.605 0.205 -1.016 0.605 -1.426 0.508 -0.41 1.016 -0.605 1.826 -0.713v4.375c-1.016 -0.313 -1.621 -0.615 -1.924 -0.918"/></g></g>
                                        </svg>
                                    </span>
                                    <div class="ms-4">
                                        <h2 class="mb-0 font-w600">{{ amountBordereau('lastYear',$agencyId) }}</h2>
                                        <p class="mb-0 text-nowrap">Année Dernière</p>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                    <div class="col-xl-3 col-sm-6">
                        <div class="card booking">
                            <div class="card-body">
                                <div class="booking-status d-flex align-items-center">
                                    <span>
                                        <svg version="1.1" xmlns="http://www.w3.org/2000/svg" fill="#01adef" viewBox="0 0 50 50" xmlns:xlink="http://www.w3.org/1999/xlink" width="30" height="30"><g><g><path d="M36.318 14.063 46.387 16.709 48.926 6.641l-1.934 -0.508 -1.65 6.279C41.123 5.605 33.594 1.074 25 1.074 11.787 1.074 1.074 11.787 1.074 25s10.713 23.926 23.926 23.926c8.818 0 16.514 -4.766 20.664 -11.865l-1.729 -0.938c-3.818 6.484 -10.869 10.84 -18.936 10.84 -12.129 0 -21.963 -9.834 -21.963 -21.963S12.871 3.037 25 3.037c8.135 0 15.244 4.424 19.033 11.006l-7.207 -1.914z"/>
                                            <path d="M26.055 35.615V33.789c1.729 -0.098 3.047 -0.605 4.063 -1.523S31.641 30.127 31.641 28.711c0 -1.523 -0.41 -2.646 -1.318 -3.359 -0.918 -0.811 -2.236 -1.426 -4.17 -1.826h-0.098V18.848c1.318 0.205 2.441 0.605 3.555 1.426l1.631 -2.236c-1.631 -1.123 -3.359 -1.729 -5.186 -1.826v-1.221h-1.523V16.211c-1.523 0.098 -2.852 0.605 -3.867 1.523S19.141 19.873 19.141 21.289s0.41 2.539 1.318 3.252c0.811 0.713 2.236 1.318 4.063 1.729v4.775c-1.426 -0.205 -2.852 -0.918 -4.268 -2.139l-1.826 2.139c1.826 1.631 3.867 2.539 6.104 2.744v1.826zm0.098 -8.848c1.016 0.303 1.631 0.605 2.031 0.918 0.303 0.41 0.508 0.811 0.508 1.426s-0.205 1.016 -0.713 1.426 -1.123 0.605 -1.826 0.713zm-3.555 -4.365c-0.303 -0.303 -0.508 -0.811 -0.508 -1.318 0 -0.605 0.205 -1.016 0.605 -1.426 0.508 -0.41 1.016 -0.605 1.826 -0.713v4.375c-1.016 -0.313 -1.621 -0.615 -1.924 -0.918"/></g></g>
                                        </svg>
                                    </span>
                                    <div class="ms-4">
                                        <h2 class="mb-0 font-w600">{{ amountBordereau('year',$agencyId) }}</h2>
                                        <p class="mb-0 text-nowrap">Année Courante</p>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                    <div class="col-xl-3 col-sm-6">
                        <div class="card booking">
                            <div class="card-body">
                                <div class="booking-status d-flex align-items-center">
                                    <span>
                                        <svg version="1.1" xmlns="http://www.w3.org/2000/svg" fill="#01adef" viewBox="0 0 50 50" xmlns:xlink="http://www.w3.org/1999/xlink" width="30" height="30"><g><g><path d="M36.318 14.063 46.387 16.709 48.926 6.641l-1.934 -0.508 -1.65 6.279C41.123 5.605 33.594 1.074 25 1.074 11.787 1.074 1.074 11.787 1.074 25s10.713 23.926 23.926 23.926c8.818 0 16.514 -4.766 20.664 -11.865l-1.729 -0.938c-3.818 6.484 -10.869 10.84 -18.936 10.84 -12.129 0 -21.963 -9.834 -21.963 -21.963S12.871 3.037 25 3.037c8.135 0 15.244 4.424 19.033 11.006l-7.207 -1.914z"/>
                                            <path d="M26.055 35.615V33.789c1.729 -0.098 3.047 -0.605 4.063 -1.523S31.641 30.127 31.641 28.711c0 -1.523 -0.41 -2.646 -1.318 -3.359 -0.918 -0.811 -2.236 -1.426 -4.17 -1.826h-0.098V18.848c1.318 0.205 2.441 0.605 3.555 1.426l1.631 -2.236c-1.631 -1.123 -3.359 -1.729 -5.186 -1.826v-1.221h-1.523V16.211c-1.523 0.098 -2.852 0.605 -3.867 1.523S19.141 19.873 19.141 21.289s0.41 2.539 1.318 3.252c0.811 0.713 2.236 1.318 4.063 1.729v4.775c-1.426 -0.205 -2.852 -0.918 -4.268 -2.139l-1.826 2.139c1.826 1.631 3.867 2.539 6.104 2.744v1.826zm0.098 -8.848c1.016 0.303 1.631 0.605 2.031 0.918 0.303 0.41 0.508 0.811 0.508 1.426s-0.205 1.016 -0.713 1.426 -1.123 0.605 -1.826 0.713zm-3.555 -4.365c-0.303 -0.303 -0.508 -0.811 -0.508 -1.318 0 -0.605 0.205 -1.016 0.605 -1.426 0.508 -0.41 1.016 -0.605 1.826 -0.713v4.375c-1.016 -0.313 -1.621 -0.615 -1.924 -0.918"/></g></g>
                                        </svg>
                                    </span>
                                    <div class="ms-4">
                                        <h2 class="mb-0 font-w600">{{ amountBordereau('month',$agencyId) }}</h2>
                                        <p class="mb-0 text-nowrap">Ce Mois</p>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                    <div class="col-xl-3 col-sm-6">
                        <div class="card booking">
                            <div class="card-body">
                                <div class="booking-status d-flex align-items-center">
                                    <span>
                                        <svg version="1.1" xmlns="http://www.w3.org/2000/svg" fill="#01adef" viewBox="0 0 50 50" xmlns:xlink="http://www.w3.org/1999/xlink" width="30" height="30"><g><g><path d="M36.318 14.063 46.387 16.709 48.926 6.641l-1.934 -0.508 -1.65 6.279C41.123 5.605 33.594 1.074 25 1.074 11.787 1.074 1.074 11.787 1.074 25s10.713 23.926 23.926 23.926c8.818 0 16.514 -4.766 20.664 -11.865l-1.729 -0.938c-3.818 6.484 -10.869 10.84 -18.936 10.84 -12.129 0 -21.963 -9.834 -21.963 -21.963S12.871 3.037 25 3.037c8.135 0 15.244 4.424 19.033 11.006l-7.207 -1.914z"/>
                                            <path d="M26.055 35.615V33.789c1.729 -0.098 3.047 -0.605 4.063 -1.523S31.641 30.127 31.641 28.711c0 -1.523 -0.41 -2.646 -1.318 -3.359 -0.918 -0.811 -2.236 -1.426 -4.17 -1.826h-0.098V18.848c1.318 0.205 2.441 0.605 3.555 1.426l1.631 -2.236c-1.631 -1.123 -3.359 -1.729 -5.186 -1.826v-1.221h-1.523V16.211c-1.523 0.098 -2.852 0.605 -3.867 1.523S19.141 19.873 19.141 21.289s0.41 2.539 1.318 3.252c0.811 0.713 2.236 1.318 4.063 1.729v4.775c-1.426 -0.205 -2.852 -0.918 -4.268 -2.139l-1.826 2.139c1.826 1.631 3.867 2.539 6.104 2.744v1.826zm0.098 -8.848c1.016 0.303 1.631 0.605 2.031 0.918 0.303 0.41 0.508 0.811 0.508 1.426s-0.205 1.016 -0.713 1.426 -1.123 0.605 -1.826 0.713zm-3.555 -4.365c-0.303 -0.303 -0.508 -0.811 -0.508 -1.318 0 -0.605 0.205 -1.016 0.605 -1.426 0.508 -0.41 1.016 -0.605 1.826 -0.713v4.375c-1.016 -0.313 -1.621 -0.615 -1.924 -0.918"/></g></g>
                                        </svg>
                                    </span>
                                    <div class="ms-4">
                                        <h2 class="mb-0 font-w600">{{ amountBordereau('last_7_day',$agencyId) }}</h2>
                                        <p class="mb-0 text-nowrap">7 derniers Jours</p>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                    <div class="col-xl-3 col-sm-6">
                        <div class="card booking">
                            <div class="card-body">
                                <div class="booking-status d-flex align-items-center">
                                    <span>
                                        <svg version="1.1" xmlns="http://www.w3.org/2000/svg" fill="#01adef" viewBox="0 0 50 50" xmlns:xlink="http://www.w3.org/1999/xlink" width="30" height="30"><g><g><path d="M36.318 14.063 46.387 16.709 48.926 6.641l-1.934 -0.508 -1.65 6.279C41.123 5.605 33.594 1.074 25 1.074 11.787 1.074 1.074 11.787 1.074 25s10.713 23.926 23.926 23.926c8.818 0 16.514 -4.766 20.664 -11.865l-1.729 -0.938c-3.818 6.484 -10.869 10.84 -18.936 10.84 -12.129 0 -21.963 -9.834 -21.963 -21.963S12.871 3.037 25 3.037c8.135 0 15.244 4.424 19.033 11.006l-7.207 -1.914z"/>
                                            <path d="M26.055 35.615V33.789c1.729 -0.098 3.047 -0.605 4.063 -1.523S31.641 30.127 31.641 28.711c0 -1.523 -0.41 -2.646 -1.318 -3.359 -0.918 -0.811 -2.236 -1.426 -4.17 -1.826h-0.098V18.848c1.318 0.205 2.441 0.605 3.555 1.426l1.631 -2.236c-1.631 -1.123 -3.359 -1.729 -5.186 -1.826v-1.221h-1.523V16.211c-1.523 0.098 -2.852 0.605 -3.867 1.523S19.141 19.873 19.141 21.289s0.41 2.539 1.318 3.252c0.811 0.713 2.236 1.318 4.063 1.729v4.775c-1.426 -0.205 -2.852 -0.918 -4.268 -2.139l-1.826 2.139c1.826 1.631 3.867 2.539 6.104 2.744v1.826zm0.098 -8.848c1.016 0.303 1.631 0.605 2.031 0.918 0.303 0.41 0.508 0.811 0.508 1.426s-0.205 1.016 -0.713 1.426 -1.123 0.605 -1.826 0.713zm-3.555 -4.365c-0.303 -0.303 -0.508 -0.811 -0.508 -1.318 0 -0.605 0.205 -1.016 0.605 -1.426 0.508 -0.41 1.016 -0.605 1.826 -0.713v4.375c-1.016 -0.313 -1.621 -0.615 -1.924 -0.918"/></g></g>
                                        </svg>
                                    </span>
                                    <div class="ms-4">
                                        <h2 class="mb-0 font-w600">{{ amountBordereau('toDay',$agencyId) }}</h2>
                                        <p class="mb-0 text-nowrap">Ce jour</p>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                    {{-- <div class="col-xl-3 col-sm-6">
                        <div class="card booking">
                            <div class="card-body">
                                <div class="booking-status d-flex align-items-center">
                                    <span>
                                        <svg version="1.1" xmlns="http://www.w3.org/2000/svg" fill="#01adef" viewBox="0 0 50 50" xmlns:xlink="http://www.w3.org/1999/xlink" width="30" height="30"><g><g><path d="M36.318 14.063 46.387 16.709 48.926 6.641l-1.934 -0.508 -1.65 6.279C41.123 5.605 33.594 1.074 25 1.074 11.787 1.074 1.074 11.787 1.074 25s10.713 23.926 23.926 23.926c8.818 0 16.514 -4.766 20.664 -11.865l-1.729 -0.938c-3.818 6.484 -10.869 10.84 -18.936 10.84 -12.129 0 -21.963 -9.834 -21.963 -21.963S12.871 3.037 25 3.037c8.135 0 15.244 4.424 19.033 11.006l-7.207 -1.914z"/>
                                            <path d="M26.055 35.615V33.789c1.729 -0.098 3.047 -0.605 4.063 -1.523S31.641 30.127 31.641 28.711c0 -1.523 -0.41 -2.646 -1.318 -3.359 -0.918 -0.811 -2.236 -1.426 -4.17 -1.826h-0.098V18.848c1.318 0.205 2.441 0.605 3.555 1.426l1.631 -2.236c-1.631 -1.123 -3.359 -1.729 -5.186 -1.826v-1.221h-1.523V16.211c-1.523 0.098 -2.852 0.605 -3.867 1.523S19.141 19.873 19.141 21.289s0.41 2.539 1.318 3.252c0.811 0.713 2.236 1.318 4.063 1.729v4.775c-1.426 -0.205 -2.852 -0.918 -4.268 -2.139l-1.826 2.139c1.826 1.631 3.867 2.539 6.104 2.744v1.826zm0.098 -8.848c1.016 0.303 1.631 0.605 2.031 0.918 0.303 0.41 0.508 0.811 0.508 1.426s-0.205 1.016 -0.713 1.426 -1.123 0.605 -1.826 0.713zm-3.555 -4.365c-0.303 -0.303 -0.508 -0.811 -0.508 -1.318 0 -0.605 0.205 -1.016 0.605 -1.426 0.508 -0.41 1.016 -0.605 1.826 -0.713v4.375c-1.016 -0.313 -1.621 -0.615 -1.924 -0.918"/></g></g>
                                        </svg>
                                    </span>
                                    <div class="ms-4">
                                        <h2 class="mb-0 font-w600">{{ amountBordereau('toDay') }}</h2>
                                        <p class="mb-0 text-nowrap">Ce jour</p>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div> --}}
                    <h3><u>Passagers</u></h3>
                    <div class="col-xl-3 col-sm-6">
                        <div class="card booking">
                            <div class="card-body">
                                <div class="booking-status d-flex align-items-center">
                                    <span>
                                        <svg width="28px" height="28px" viewBox="0 0 0.84 0.84" fill="#01adef" fill="none" xmlns="http://www.w3.org/2000/svg">
                                            <path d="M0.35 0.14a0.14 0.14 0 1 0 0 0.28 0.14 0.14 0 0 0 0 -0.28M0.14 0.28a0.21 0.21 0 1 1 0.42 0A0.21 0.21 0 0 1 0.14 0.28m0.449 -0.149a0.035 0.035 0 0 1 0.05 0 0.21 0.21 0 0 1 0 0.297 0.035 0.035 0 1 1 -0.05 -0.05 0.14 0.14 0 0 0 0 -0.198 0.035 0.035 0 0 1 0 -0.05m0.025 0.455a0.035 0.035 0 0 1 0.042 -0.025c0.046 0.012 0.076 0.041 0.093 0.075 0.016 0.033 0.021 0.069 0.021 0.099a0.035 0.035 0 1 1 -0.07 0c0 -0.023 -0.004 -0.048 -0.014 -0.067 -0.009 -0.019 -0.024 -0.033 -0.047 -0.039a0.035 0.035 0 0 1 -0.025 -0.042zM0.228 0.63C0.183 0.63 0.14 0.672 0.14 0.735a0.035 0.035 0 1 1 -0.07 0c0 -0.092 0.066 -0.175 0.158 -0.175h0.245c0.091 0 0.158 0.083 0.158 0.175a0.035 0.035 0 1 1 -0.07 0c0 -0.063 -0.043 -0.105 -0.088 -0.105z"/>
                                        </svg>
                                    </span>
                                    <div class="ms-4">
                                        <h2 class="mb-0 font-w600">{{ passengersCount('all') }}</h2>
                                        <p class="mb-0 text-nowrap">Global</p>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                    <div class="col-xl-3 col-sm-6">
                        <div class="card booking">
                            <div class="card-body">
                                <div class="booking-status d-flex align-items-center">
                                    <span>
                                        <svg width="28px" height="28px" viewBox="0 0 0.84 0.84" fill="#01adef" fill="none" xmlns="http://www.w3.org/2000/svg">
                                            <path d="M0.35 0.14a0.14 0.14 0 1 0 0 0.28 0.14 0.14 0 0 0 0 -0.28M0.14 0.28a0.21 0.21 0 1 1 0.42 0A0.21 0.21 0 0 1 0.14 0.28m0.449 -0.149a0.035 0.035 0 0 1 0.05 0 0.21 0.21 0 0 1 0 0.297 0.035 0.035 0 1 1 -0.05 -0.05 0.14 0.14 0 0 0 0 -0.198 0.035 0.035 0 0 1 0 -0.05m0.025 0.455a0.035 0.035 0 0 1 0.042 -0.025c0.046 0.012 0.076 0.041 0.093 0.075 0.016 0.033 0.021 0.069 0.021 0.099a0.035 0.035 0 1 1 -0.07 0c0 -0.023 -0.004 -0.048 -0.014 -0.067 -0.009 -0.019 -0.024 -0.033 -0.047 -0.039a0.035 0.035 0 0 1 -0.025 -0.042zM0.228 0.63C0.183 0.63 0.14 0.672 0.14 0.735a0.035 0.035 0 1 1 -0.07 0c0 -0.092 0.066 -0.175 0.158 -0.175h0.245c0.091 0 0.158 0.083 0.158 0.175a0.035 0.035 0 1 1 -0.07 0c0 -0.063 -0.043 -0.105 -0.088 -0.105z"/>
                                        </svg>
                                    </span>
                                    <div class="ms-4">
                                        <h2 class="mb-0 font-w600">{{ passengersCount('year') }}</h2>
                                        <p class="mb-0 text-nowrap">Année Courante</p>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                    <div class="col-xl-3 col-sm-6">
                        <div class="card booking">
                            <div class="card-body">
                                <div class="booking-status d-flex align-items-center">
                                    <span>
                                        <svg width="28px" height="28px" viewBox="0 0 0.84 0.84" fill="#01adef" fill="none" xmlns="http://www.w3.org/2000/svg">
                                            <path d="M0.35 0.14a0.14 0.14 0 1 0 0 0.28 0.14 0.14 0 0 0 0 -0.28M0.14 0.28a0.21 0.21 0 1 1 0.42 0A0.21 0.21 0 0 1 0.14 0.28m0.449 -0.149a0.035 0.035 0 0 1 0.05 0 0.21 0.21 0 0 1 0 0.297 0.035 0.035 0 1 1 -0.05 -0.05 0.14 0.14 0 0 0 0 -0.198 0.035 0.035 0 0 1 0 -0.05m0.025 0.455a0.035 0.035 0 0 1 0.042 -0.025c0.046 0.012 0.076 0.041 0.093 0.075 0.016 0.033 0.021 0.069 0.021 0.099a0.035 0.035 0 1 1 -0.07 0c0 -0.023 -0.004 -0.048 -0.014 -0.067 -0.009 -0.019 -0.024 -0.033 -0.047 -0.039a0.035 0.035 0 0 1 -0.025 -0.042zM0.228 0.63C0.183 0.63 0.14 0.672 0.14 0.735a0.035 0.035 0 1 1 -0.07 0c0 -0.092 0.066 -0.175 0.158 -0.175h0.245c0.091 0 0.158 0.083 0.158 0.175a0.035 0.035 0 1 1 -0.07 0c0 -0.063 -0.043 -0.105 -0.088 -0.105z"/>
                                        </svg>
                                    </span>
                                    <div class="ms-4">
                                        <h2 class="mb-0 font-w600">{{ passengersCount('month') }}</h2>
                                        <p class="mb-0 text-nowrap">Ce Mois</p>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                    <div class="col-xl-3 col-sm-6">
                        <div class="card booking">
                            <div class="card-body">
                                <div class="booking-status d-flex align-items-center">
                                    <span>
                                        <svg width="28px" height="28px" viewBox="0 0 0.84 0.84" fill="#01adef" fill="none" xmlns="http://www.w3.org/2000/svg">
                                            <path d="M0.35 0.14a0.14 0.14 0 1 0 0 0.28 0.14 0.14 0 0 0 0 -0.28M0.14 0.28a0.21 0.21 0 1 1 0.42 0A0.21 0.21 0 0 1 0.14 0.28m0.449 -0.149a0.035 0.035 0 0 1 0.05 0 0.21 0.21 0 0 1 0 0.297 0.035 0.035 0 1 1 -0.05 -0.05 0.14 0.14 0 0 0 0 -0.198 0.035 0.035 0 0 1 0 -0.05m0.025 0.455a0.035 0.035 0 0 1 0.042 -0.025c0.046 0.012 0.076 0.041 0.093 0.075 0.016 0.033 0.021 0.069 0.021 0.099a0.035 0.035 0 1 1 -0.07 0c0 -0.023 -0.004 -0.048 -0.014 -0.067 -0.009 -0.019 -0.024 -0.033 -0.047 -0.039a0.035 0.035 0 0 1 -0.025 -0.042zM0.228 0.63C0.183 0.63 0.14 0.672 0.14 0.735a0.035 0.035 0 1 1 -0.07 0c0 -0.092 0.066 -0.175 0.158 -0.175h0.245c0.091 0 0.158 0.083 0.158 0.175a0.035 0.035 0 1 1 -0.07 0c0 -0.063 -0.043 -0.105 -0.088 -0.105z"/>
                                        </svg>
                                    </span>
                                    <div class="ms-4">
                                        <h2 class="mb-0 font-w600">{{ passengersCount('last_7_day') }}</h2>
                                        <p class="mb-0 text-nowrap">7 derniers Jours</p>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                    <h3><u>Employés</u></h3>
                    <div class="col-xl-3 col-sm-6">
                        <div class="card booking">
                            <div class="card-body">
                                <div class="booking-status d-flex align-items-center">
                                    <span>
                                        <svg width="35px" height="35px" viewBox="0 0 1.12 1.12" fill="#01adef"  version="1.1" xmlns="http://www.w3.org/2000/svg" xmlns:xlink="http://www.w3.org/1999/xlink">
                                            <g id="icomoon-ignore"/><path d="M0.56 0.112C0.313 0.112 0.112 0.313 0.112 0.56S0.313 1.008 0.56 1.008 1.008 0.807 1.008 0.56 0.807 0.112 0.56 0.112m0 0.037c0.226 0 0.411 0.184 0.411 0.411 0 0.1 -0.036 0.191 -0.095 0.262 -0.041 -0.017 -0.138 -0.051 -0.197 -0.068 -0.005 -0.002 -0.006 -0.002 -0.006 -0.023 0 -0.018 0.007 -0.035 0.014 -0.05a0.256 0.256 0 0 0 0.02 -0.068c0.009 -0.011 0.021 -0.031 0.029 -0.071 0.007 -0.035 0.004 -0.048 -0.001 -0.06q-0.001 -0.002 -0.001 -0.004c-0.002 -0.008 0.001 -0.051 0.007 -0.084 0.004 -0.023 -0.001 -0.071 -0.032 -0.111 -0.02 -0.025 -0.057 -0.056 -0.126 -0.06l-0.038 0c-0.068 0.004 -0.105 0.035 -0.125 0.06 -0.031 0.04 -0.036 0.088 -0.032 0.111 0.006 0.033 0.008 0.075 0.007 0.084q-0.001 0.002 -0.001 0.004c-0.005 0.012 -0.008 0.025 -0.001 0.06 0.008 0.04 0.02 0.06 0.029 0.071 0.003 0.025 0.012 0.052 0.02 0.068 0.006 0.012 0.008 0.028 0.008 0.051 0 0.021 -0.001 0.021 -0.006 0.023 -0.062 0.018 -0.16 0.054 -0.197 0.07A0.408 0.408 0 0 1 0.149 0.56C0.149 0.334 0.334 0.149 0.56 0.149M0.273 0.854a2.38 2.38 0 0 1 0.181 -0.063c0.032 -0.01 0.032 -0.037 0.032 -0.059 0 -0.018 -0.001 -0.044 -0.012 -0.067 -0.007 -0.015 -0.015 -0.042 -0.017 -0.062a0.019 0.019 0 0 0 -0.006 -0.012c-0.005 -0.005 -0.016 -0.022 -0.023 -0.056 -0.005 -0.027 -0.003 -0.033 -0.001 -0.039 0.001 -0.002 0.002 -0.005 0.003 -0.008 0.004 -0.016 -0.001 -0.07 -0.006 -0.1 -0.002 -0.013 0.001 -0.05 0.025 -0.081 0.022 -0.028 0.055 -0.043 0.097 -0.046l0.035 0c0.043 0.003 0.076 0.018 0.098 0.046 0.024 0.031 0.027 0.068 0.025 0.081 -0.005 0.03 -0.01 0.084 -0.006 0.1 0.001 0.003 0.002 0.005 0.003 0.008 0.002 0.006 0.005 0.012 -0.001 0.039 -0.007 0.034 -0.018 0.051 -0.023 0.056a0.019 0.019 0 0 0 -0.006 0.012c-0.002 0.021 -0.01 0.047 -0.017 0.062 -0.008 0.018 -0.018 0.041 -0.018 0.066 0 0.022 0 0.049 0.032 0.059a2.765 2.765 0 0 1 0.181 0.062A0.41 0.41 0 0 1 0.56 0.971a0.41 0.41 0 0 1 -0.287 -0.117z"/>
                                        </svg>
                                    </span>
                                    <div class="ms-4">
                                        <h2 class="mb-0 font-w600">{{ employeeCount('all') }}</h2>
                                        <p class="mb-0 text-nowrap">Global</p>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                    <div class="col-xl-3 col-sm-6">
                        <div class="card booking">
                            <div class="card-body">
                                <div class="booking-status d-flex align-items-center">
                                    <span>
                                        <svg width="35px" height="35px" viewBox="0 0 1.12 1.12" fill="#01adef"  version="1.1" xmlns="http://www.w3.org/2000/svg" xmlns:xlink="http://www.w3.org/1999/xlink">
                                            <g id="icomoon-ignore"/><path d="M0.56 0.112C0.313 0.112 0.112 0.313 0.112 0.56S0.313 1.008 0.56 1.008 1.008 0.807 1.008 0.56 0.807 0.112 0.56 0.112m0 0.037c0.226 0 0.411 0.184 0.411 0.411 0 0.1 -0.036 0.191 -0.095 0.262 -0.041 -0.017 -0.138 -0.051 -0.197 -0.068 -0.005 -0.002 -0.006 -0.002 -0.006 -0.023 0 -0.018 0.007 -0.035 0.014 -0.05a0.256 0.256 0 0 0 0.02 -0.068c0.009 -0.011 0.021 -0.031 0.029 -0.071 0.007 -0.035 0.004 -0.048 -0.001 -0.06q-0.001 -0.002 -0.001 -0.004c-0.002 -0.008 0.001 -0.051 0.007 -0.084 0.004 -0.023 -0.001 -0.071 -0.032 -0.111 -0.02 -0.025 -0.057 -0.056 -0.126 -0.06l-0.038 0c-0.068 0.004 -0.105 0.035 -0.125 0.06 -0.031 0.04 -0.036 0.088 -0.032 0.111 0.006 0.033 0.008 0.075 0.007 0.084q-0.001 0.002 -0.001 0.004c-0.005 0.012 -0.008 0.025 -0.001 0.06 0.008 0.04 0.02 0.06 0.029 0.071 0.003 0.025 0.012 0.052 0.02 0.068 0.006 0.012 0.008 0.028 0.008 0.051 0 0.021 -0.001 0.021 -0.006 0.023 -0.062 0.018 -0.16 0.054 -0.197 0.07A0.408 0.408 0 0 1 0.149 0.56C0.149 0.334 0.334 0.149 0.56 0.149M0.273 0.854a2.38 2.38 0 0 1 0.181 -0.063c0.032 -0.01 0.032 -0.037 0.032 -0.059 0 -0.018 -0.001 -0.044 -0.012 -0.067 -0.007 -0.015 -0.015 -0.042 -0.017 -0.062a0.019 0.019 0 0 0 -0.006 -0.012c-0.005 -0.005 -0.016 -0.022 -0.023 -0.056 -0.005 -0.027 -0.003 -0.033 -0.001 -0.039 0.001 -0.002 0.002 -0.005 0.003 -0.008 0.004 -0.016 -0.001 -0.07 -0.006 -0.1 -0.002 -0.013 0.001 -0.05 0.025 -0.081 0.022 -0.028 0.055 -0.043 0.097 -0.046l0.035 0c0.043 0.003 0.076 0.018 0.098 0.046 0.024 0.031 0.027 0.068 0.025 0.081 -0.005 0.03 -0.01 0.084 -0.006 0.1 0.001 0.003 0.002 0.005 0.003 0.008 0.002 0.006 0.005 0.012 -0.001 0.039 -0.007 0.034 -0.018 0.051 -0.023 0.056a0.019 0.019 0 0 0 -0.006 0.012c-0.002 0.021 -0.01 0.047 -0.017 0.062 -0.008 0.018 -0.018 0.041 -0.018 0.066 0 0.022 0 0.049 0.032 0.059a2.765 2.765 0 0 1 0.181 0.062A0.41 0.41 0 0 1 0.56 0.971a0.41 0.41 0 0 1 -0.287 -0.117z"/>
                                        </svg>
                                    </span>
                                    <div class="ms-4">
                                        <h2 class="mb-0 font-w600">{{ employeeCount('year') }}</h2>
                                        <p class="mb-0 text-nowrap">Année Courante</p>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                    <div class="col-xl-3 col-sm-6">
                        <div class="card booking">
                            <div class="card-body">
                                <div class="booking-status d-flex align-items-center">
                                    <span>
                                        <svg width="35px" height="35px" viewBox="0 0 1.12 1.12" fill="#01adef"  version="1.1" xmlns="http://www.w3.org/2000/svg" xmlns:xlink="http://www.w3.org/1999/xlink">
                                            <g id="icomoon-ignore"/><path d="M0.56 0.112C0.313 0.112 0.112 0.313 0.112 0.56S0.313 1.008 0.56 1.008 1.008 0.807 1.008 0.56 0.807 0.112 0.56 0.112m0 0.037c0.226 0 0.411 0.184 0.411 0.411 0 0.1 -0.036 0.191 -0.095 0.262 -0.041 -0.017 -0.138 -0.051 -0.197 -0.068 -0.005 -0.002 -0.006 -0.002 -0.006 -0.023 0 -0.018 0.007 -0.035 0.014 -0.05a0.256 0.256 0 0 0 0.02 -0.068c0.009 -0.011 0.021 -0.031 0.029 -0.071 0.007 -0.035 0.004 -0.048 -0.001 -0.06q-0.001 -0.002 -0.001 -0.004c-0.002 -0.008 0.001 -0.051 0.007 -0.084 0.004 -0.023 -0.001 -0.071 -0.032 -0.111 -0.02 -0.025 -0.057 -0.056 -0.126 -0.06l-0.038 0c-0.068 0.004 -0.105 0.035 -0.125 0.06 -0.031 0.04 -0.036 0.088 -0.032 0.111 0.006 0.033 0.008 0.075 0.007 0.084q-0.001 0.002 -0.001 0.004c-0.005 0.012 -0.008 0.025 -0.001 0.06 0.008 0.04 0.02 0.06 0.029 0.071 0.003 0.025 0.012 0.052 0.02 0.068 0.006 0.012 0.008 0.028 0.008 0.051 0 0.021 -0.001 0.021 -0.006 0.023 -0.062 0.018 -0.16 0.054 -0.197 0.07A0.408 0.408 0 0 1 0.149 0.56C0.149 0.334 0.334 0.149 0.56 0.149M0.273 0.854a2.38 2.38 0 0 1 0.181 -0.063c0.032 -0.01 0.032 -0.037 0.032 -0.059 0 -0.018 -0.001 -0.044 -0.012 -0.067 -0.007 -0.015 -0.015 -0.042 -0.017 -0.062a0.019 0.019 0 0 0 -0.006 -0.012c-0.005 -0.005 -0.016 -0.022 -0.023 -0.056 -0.005 -0.027 -0.003 -0.033 -0.001 -0.039 0.001 -0.002 0.002 -0.005 0.003 -0.008 0.004 -0.016 -0.001 -0.07 -0.006 -0.1 -0.002 -0.013 0.001 -0.05 0.025 -0.081 0.022 -0.028 0.055 -0.043 0.097 -0.046l0.035 0c0.043 0.003 0.076 0.018 0.098 0.046 0.024 0.031 0.027 0.068 0.025 0.081 -0.005 0.03 -0.01 0.084 -0.006 0.1 0.001 0.003 0.002 0.005 0.003 0.008 0.002 0.006 0.005 0.012 -0.001 0.039 -0.007 0.034 -0.018 0.051 -0.023 0.056a0.019 0.019 0 0 0 -0.006 0.012c-0.002 0.021 -0.01 0.047 -0.017 0.062 -0.008 0.018 -0.018 0.041 -0.018 0.066 0 0.022 0 0.049 0.032 0.059a2.765 2.765 0 0 1 0.181 0.062A0.41 0.41 0 0 1 0.56 0.971a0.41 0.41 0 0 1 -0.287 -0.117z"/>
                                        </svg>
                                    </span>
                                    <div class="ms-4">
                                        <h2 class="mb-0 font-w600">{{ employeeCount('month') }}</h2>
                                        <p class="mb-0 text-nowrap">Ce Mois</p>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                    <div class="col-xl-3 col-sm-6">
                        <div class="card booking">
                            <div class="card-body">
                                <div class="booking-status d-flex align-items-center">
                                    <span>
                                        <svg width="35px" height="35px" viewBox="0 0 1.12 1.12" fill="#01adef"  version="1.1" xmlns="http://www.w3.org/2000/svg" xmlns:xlink="http://www.w3.org/1999/xlink">
                                            <g id="icomoon-ignore"/><path d="M0.56 0.112C0.313 0.112 0.112 0.313 0.112 0.56S0.313 1.008 0.56 1.008 1.008 0.807 1.008 0.56 0.807 0.112 0.56 0.112m0 0.037c0.226 0 0.411 0.184 0.411 0.411 0 0.1 -0.036 0.191 -0.095 0.262 -0.041 -0.017 -0.138 -0.051 -0.197 -0.068 -0.005 -0.002 -0.006 -0.002 -0.006 -0.023 0 -0.018 0.007 -0.035 0.014 -0.05a0.256 0.256 0 0 0 0.02 -0.068c0.009 -0.011 0.021 -0.031 0.029 -0.071 0.007 -0.035 0.004 -0.048 -0.001 -0.06q-0.001 -0.002 -0.001 -0.004c-0.002 -0.008 0.001 -0.051 0.007 -0.084 0.004 -0.023 -0.001 -0.071 -0.032 -0.111 -0.02 -0.025 -0.057 -0.056 -0.126 -0.06l-0.038 0c-0.068 0.004 -0.105 0.035 -0.125 0.06 -0.031 0.04 -0.036 0.088 -0.032 0.111 0.006 0.033 0.008 0.075 0.007 0.084q-0.001 0.002 -0.001 0.004c-0.005 0.012 -0.008 0.025 -0.001 0.06 0.008 0.04 0.02 0.06 0.029 0.071 0.003 0.025 0.012 0.052 0.02 0.068 0.006 0.012 0.008 0.028 0.008 0.051 0 0.021 -0.001 0.021 -0.006 0.023 -0.062 0.018 -0.16 0.054 -0.197 0.07A0.408 0.408 0 0 1 0.149 0.56C0.149 0.334 0.334 0.149 0.56 0.149M0.273 0.854a2.38 2.38 0 0 1 0.181 -0.063c0.032 -0.01 0.032 -0.037 0.032 -0.059 0 -0.018 -0.001 -0.044 -0.012 -0.067 -0.007 -0.015 -0.015 -0.042 -0.017 -0.062a0.019 0.019 0 0 0 -0.006 -0.012c-0.005 -0.005 -0.016 -0.022 -0.023 -0.056 -0.005 -0.027 -0.003 -0.033 -0.001 -0.039 0.001 -0.002 0.002 -0.005 0.003 -0.008 0.004 -0.016 -0.001 -0.07 -0.006 -0.1 -0.002 -0.013 0.001 -0.05 0.025 -0.081 0.022 -0.028 0.055 -0.043 0.097 -0.046l0.035 0c0.043 0.003 0.076 0.018 0.098 0.046 0.024 0.031 0.027 0.068 0.025 0.081 -0.005 0.03 -0.01 0.084 -0.006 0.1 0.001 0.003 0.002 0.005 0.003 0.008 0.002 0.006 0.005 0.012 -0.001 0.039 -0.007 0.034 -0.018 0.051 -0.023 0.056a0.019 0.019 0 0 0 -0.006 0.012c-0.002 0.021 -0.01 0.047 -0.017 0.062 -0.008 0.018 -0.018 0.041 -0.018 0.066 0 0.022 0 0.049 0.032 0.059a2.765 2.765 0 0 1 0.181 0.062A0.41 0.41 0 0 1 0.56 0.971a0.41 0.41 0 0 1 -0.287 -0.117z"/>
                                        </svg>
                                    </span>
                                    <div class="ms-4">
                                        <h2 class="mb-0 font-w600">{{ employeeCount('last_7_day') }}</h2>
                                        <p class="mb-0 text-nowrap">7 derniers Jours</p>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
                <div class="row">
                    <h3><u>Récapitulatif des ventes par agences</u></h3>
                    <div class="col-12">
                        <div class="card">
                            <div class="card-header">
                                <h4 class="card-title">Liste des agences</h4>
                            </div>
                            <div class="card-body">
                                <div class="table-responsive">
                                    <table id="example4" class="display" style="min-width: 845px">
                                        <thead>
                                            <tr>
                                                <th>No</th>
                                                <th>Nom</th>
                                                <th>Tickets</th>
                                                <th>Dépenses Voyages</th>
                                                <th>Dépenses F & M</th>
                                            </tr>
                                        </thead>
                                        @php
                                            $tickets_all = 0;
                                            $proofs_all = 0;
                                            $expense_all = 0;
                                        @endphp
                                        <tbody>
                                            @isset($agencies)
                                            @foreach($agencies as $key => $value)
                                            @php
                                                $value_id = $value->id;
                                                $name_chief = $value->ag_name_chief;
                                                $name = $value->ag_name;
                                                $name_replace = str_ireplace("'"," ",$name);
                                                $tickets = amountByAgency("tickets",$value_id);
                                                $travelProofs = amountByAgency("expenses",$value_id);
                                                $expensesAll = amountByAgency("expensesAll",$value_id);

                                                $tickets_all += $tickets;
                                                $proofs_all += $travelProofs;
                                                $expense_all += $expensesAll;
                                            @endphp
                                            <tr id="row_line{{ $value_id }}">
                                                <td>{{ $key+1 }}</td>
                                                <td>{{ $name }}</td>
                                                <td>{{ convert_amount_v2($tickets) }}</td>
                                                <td>{{ convert_amount_v2($travelProofs) }}</td>
                                                <td>
                                                    {{ convert_amount_v2($expensesAll) }}
                                                </td>
                                            </tr>
                                            @endforeach
                                            @endisset
                                        </tbody>
                                        <tfoot>
                                            <tr style="font-weight: bold;font-size:18px;" class="mt-5">
                                                <td colspan="1"></td>
                                                <td>TOTAL</td>
                                                <td>{{ convert_amount_v2($tickets_all) }}</td>
                                                <td>{{ convert_amount_v2($proofs_all) }}</td>
                                                <td>{{ convert_amount_v2($expense_all) }}</td>
                                            </tr>
                                        </tfoot>
                                    </table>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>

        </div>
    </div>
</div>
@endsection
@section("script-up")
<script src="{{ asset('vendor/select2/js/select2.full.min.js') }}"></script>
<script src="{{ asset('vendor/datatables/js/jquery.dataTables.min.js') }}"></script>
@endsection
@section("script-down")
{{-- <script>
    window.onload = function() {
        window.print();
    };
</script> --}}
<script>
    function updateUrlParameter(url, param, paramValue) {
        var newAdditionalURL = "";
        var tempArray = url.split("?");
        var baseURL = tempArray[0];
        var additionalURL = tempArray[1];
        var temp = "";
        if (additionalURL) {
            tempArray = additionalURL.split("&");
            for (i = 0; i < tempArray.length; i++) {
                if (tempArray[i].split('=')[0] !== param) {
                    newAdditionalURL += temp + tempArray[i];
                    temp = "&";
                }
            }
        }

        var newParam = temp + param + "=" + paramValue;
        return baseURL + "?" + newAdditionalURL + newParam;
    }

    $(document).ready(function(){
        $('#agencySelect').on('change', function() {
            var selectedValue = $(this).val();
            if (selectedValue) {
                // Récupérer l'URL actuelle
                var currentUrl = window.location.href;

                // Ajouter ou mettre à jour le paramètre "agency" dans l'URL
                var newUrl = updateUrlParameter(currentUrl, 'agency', selectedValue);

                // Rediriger vers la nouvelle URL
                window.location.href = newUrl;
            }
            else if(selectedValue == ""){
                window.location = "{{ route('get.backend.dashboard') }}";
            }
        });
    });
</script>
@endsection