@extends('layouts.master')
@section('title', 'Dashboard')
@section('page-style')
<link rel="stylesheet" href="{{asset('assets/plugins/jvectormap/jquery-jvectormap-2.0.3.min.css')}}"/>
<link rel="stylesheet" href="{{asset('assets/plugins/charts-c3/plugin.css')}}" />
<link rel="stylesheet" href="{{asset('assets/plugins/morrisjs/morris.min.css')}}" />
@stop
@section('content')

<section class="section dashboard">
      <div class="row">

<div class="col-lg-12">
          <div class="row">


    <div class="col-lg-3 col-md-6 col-sm-12">
        <div class="card widget_2">
            <div class="body">
                <h3><strong>Véhicules</strong></h3>
                <h2>{{$tot_vehicules}} <small class="info">Total</small></h2>
                <table class="table">
                    <thead>
                        <th>Lourds : {{$tot_veh_lourds}}</th>
                        <th>Légers: {{$tot_veh_legers}}</th>
                    </thead>
                    <thead>
                        <th>Lourds sans chauff : {{$tot_veh_lourds_sans_chauff}}</th>
                        <th>Lourds sans aide_chauff: {{$tot_veh_lourds_sans_aide_chauff}}</th>
                    </thead>
                    <thead>
                        <th>Légers sans Bénéficiaire : {{$tot_veh_legers_sans_benef}}</th>
                    </thead>
                </table>
                @if(Auth()->user()->roles()->whereIn('role_id', [1])->exists())
                <div class="">
                   <a href="/vehicules" class="btn btn-primary" target="blank">Voir liste</a>
                </div>
                @endif
            </div>
        </div>
    </div>



    <div class="col-lg-3 col-md-6 col-sm-12">
    <div class="card widget_2">
        <div class="body">
            <h3><strong>Stock Carburant</strong></h3>
            <table class="table">
                <thead>
                    <tr>
                        <th>Essence</th>
                        <th>Gasoil</th>
                    </tr>
                </thead>
                <tbody>
                    <tr>
                        <!-- Pour l'essence -->
                        @php
                            $essence_color = 'text-success'; // Vert par défaut
                            if($tot_essence <= 1000) {
                                $essence_color = 'text-danger'; // Rouge si ≤ 1000L
                            } elseif($tot_essence <= 2000) {
                                $essence_color = 'text-warning'; // Orange si ≤ 2000L
                            }
                        @endphp
                        <td class="{{ $essence_color }}"><strong>{{ number_format($tot_essence, 0, ',', ' ') }} Litres</strong></td>
                        
                        <!-- Pour le gasoil -->
                        @php
                            $gasoil_color = 'text-success'; // Vert par défaut
                            if($tot_gasoil <= 1000) {
                                $gasoil_color = 'text-danger'; // Rouge si ≤ 1000L
                            } elseif($tot_gasoil <= 2000) {
                                $gasoil_color = 'text-warning'; // Orange si ≤ 2000L
                            }
                        @endphp
                        <td class="{{ $gasoil_color }}"><strong>{{ number_format($tot_gasoil, 0, ',', ' ') }} Litres</strong></td>
                    </tr>
                     <tr>
                        <th> {{ number_format($cump_essence, 0, ',', ' ') }} BIF/L</th>
                        <th> {{ number_format($cump_gasoil, 0, ',', ' ') }} BIF/L</th>
                    </tr>
                </tbody>
            </table>
            
            @if(Auth()->user()->roles()->whereIn('role_id', [1])->exists())
            <div class="mt-3">
                <a href="/stock_carburant" class="btn btn-primary" target="blank">Voir liste</a>
            </div>
            @endif
        </div>
    </div>
</div>



     <div class="col-lg-3 col-md-6 col-sm-12">
    <div class="card widget_2">
        <div class="body">
            <h4><strong>Dette carburant <span class="text-danger">{{$total_montant_formatted}}</span></strong></h4>
            <table class="table">
                <thead>
                    <tr>
                        <th>Essence</th>
                        <th>Gasoil</th>
                    </tr>
                </thead>
                <tbody>
                   
                    <tr>
                        <td class="text-success"><strong>{{ number_format($montant_essence, 0, ',', ' ') }} BIF</strong></td>
                        <td class="text-success"><strong>{{ number_format($montant_gasoil, 0, ',', ' ') }} BIF</strong></td>
                    </tr>
                </tbody>
            </table>
            
            @if(Auth()->user()->roles()->whereIn('role_id', [1])->exists())
            <div class="mt-2">
                <a href="/recouvrement_carburant" class="btn btn-primary btn-sm" target="blank">Voir liste</a>
            </div>
            @endif
        </div>
    </div>
</div>


    <div class="col-lg-3 col-md-6 col-sm-12">
        <div class="card widget_2">
            <div class="body">
                <h3><strong>Bénéficiaires</strong></h3>
                <h2>{{$tot_beneficiaires}}</h2>
                @if(Auth()->user()->roles()->whereIn('role_id', [1])->exists())
                <a href="/beneficiaires" class="btn btn-primary" target="blank">Voir liste</a>
                @endif
            </div>
        </div>
    </div>
    <div class="col-lg-3 col-md-6 col-sm-12">
        <div class="card widget_2">
            <div class="body">
                <h3><strong>Propriétaires</strong></h3>
                <h2>{{$tot_proprietaires}}</h2>
                @if(Auth()->user()->roles()->whereIn('role_id', [1])->exists())
                <a href="/proprietaires" class="btn btn-primary" target="blank">Voir liste</a>
                @endif
        </div>
    </div>
</div>
    <div class="col-lg-3 col-md-6 col-sm-12">
        <div class="card widget_2">
            <div class="body">
                <h3><strong>Tous utilisateurs</strong></h3>
                <h2>{{$tot_users}}</h2>
                @if(Auth()->user()->roles()->whereIn('role_id', [1])->exists())
                <a href="/utilisateurs" class="btn btn-primary" target="blank">Voir liste</a>
                @endif
            </div>
        </div>
    </div>
    <div class="col-lg-3 col-md-6 col-sm-12">
        <div class="card widget_2">
            <div class="body">
                <h3><strong>Tous Chauffeurs</strong></h3>
                <h2>{{$tot_chauffeurs}}</h2>
                @if(Auth()->user()->roles()->whereIn('role_id', [1])->exists())
                <a href="/chauffeurs" class="btn btn-primary" target="blank">Voir liste</a>
                @endif
            </div>
        </div>
    </div>
    <div class="col-lg-3 col-md-6 col-sm-12">
        <div class="card widget_2">
            <div class="body">
                <h3><strong>Tous Aide-chauffeurs</strong></h3>
                <h2>{{$tot_aide_chauffeurs}}</h2>
                @if(Auth()->user()->roles()->whereIn('role_id', [1])->exists())
                <a href="/aide_chauffeurs" class="btn btn-primary" target="blank">Voir liste</a>
                @endif
            </div>
        </div>
    </div>
    <div class="col-lg-3 col-md-6 col-sm-12">
        <div class="card widget_2">
            <div class="body">
                <h3><strong>Tous charrois</strong></h3>
                <h2>{{$tot_charrois}}</h2>
                @if(Auth()->user()->roles()->whereIn('role_id', [1])->exists())
                <a href="/charrois" class="btn btn-primary" target="blank">Voir liste</a>
                @endif
            </div>
        </div>
    </div>
     <div class="col-lg-3 col-md-6 col-sm-12">
        <div class="card widget_2">
            <div class="body">
                <h3><strong>Assurances</strong></h3>
                <p>Dont la date fin inférieur ou égale à 30 Jours</p>
                <h2>{{$tot_assurances}}</h2>
                @if(Auth()->user()->roles()->whereIn('role_id', [1])->exists())
                <a href="/perio_assurances" class="btn btn-primary" target="blank">Voir liste</a>
                @endif
            </div>
        </div>
    </div>
     <div class="col-lg-3 col-md-6 col-sm-12">
        <div class="card widget_2">
            <div class="body">
                <h3><strong>Controles techiques</strong></h3>
                <p>Dont la date fin inférieur ou égale à 30 Jours</p>
                <h2>{{$tot_control}}</h2>
                @if(Auth()->user()->roles()->whereIn('role_id', [1])->exists())
                <a href="/perio_controles" class="btn btn-primary" target="blank">Voir liste</a>
                @endif
            </div>
        </div>
    </div>
</div>
</div>

<!-- Right side columns -->
        <div class="col-lg-12">
          <div class="card">
            <div class="card-body pb-0">
              <h5 class="card-title">Les statistiques DB</h5>
              <div id="trafficChart" style="min-height: 400px;" class="echart"></div>
              <script>
                document.addEventListener("DOMContentLoaded", () => {
                  echarts.init(document.querySelector("#trafficChart")).setOption({
                    tooltip: {
                      trigger: 'item'
                    },
                    legend: {
                      top: '5%',
                      left: 'center'
                    },
                    series: [{
                      name: 'Total',
                      type: 'pie',
                      radius: ['40%', '70%'],
                      avoidLabelOverlap: false,
                      label: {
                        show: false,
                        position: 'center'
                      },
                      emphasis: {
                        label: {
                          show: true,
                          fontSize: '18',
                          fontWeight: 'bold'
                        }
                      },
                      labelLine: {
                        show: false
                      },
                      data: [{
                          value: {{$tot_veh_lourds}},
                          name: 'Total vehicules Lourds'
                        },
                        {
                          value: {{$tot_veh_legers}},
                          name: 'Total vehicules Legers'
                        }
                      ]
                    }]
                  });
                });
              </script>

            </div>
          </div>
        </div>

      </div>
    </section>

@stop
@section('page-script')
<script type="text/javascript">
  setTimeout(function(){
    location = ''
  },60000)
</script>
@stop