@extends('layouts.admin')
@section('content')
<script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/select2/4.0.5/js/select2.full.min.js"></script>

<!-- end page title --> 
<div class="row">
    <div class="col-12">
        <div class="card">
            <div class="card-body">
                <h2 class="text-center"> LA LISTE DES COMMANDES CLIENTS </h2>  
            </div>

            <div class="card-body">
                <div class="row mb-2">
                    <div class="col-sm-4">
                        <a href="{{ route('admin.commande_client.create') }}" class="btn btn-danger mb-2"><i class="mdi mdi-plus-circle me-2"></i> Nouvelle Commande</a>
                    </div>
                </div>
                    <form action="{{ route('admin.commande_client_rechercher') }}" method="GET" class="row">
                        @csrf 
                        <div class="col-md-1">
                            <select name="pagination" class="form-control">
                                <option value="10">10</option>
                                <option value="25">25</option>
                                <option value="50">50</option>
                                <option value="100">100</option>
                                <option value="250">250</option>
                                <option value="500">500</option>
                            </select>
                        </div>

                        <div class="col-md-2 from-group"> 
                            <label> Date Commande </label> 
                            <input type="month" name="date_commande" class="form-control" value="{{ old('month') }}" />
                        </div>

                        <div class="col-md-2 from-group"> 
                            <label> Date Validation </label> 
                            <input type="month" name="date_validation" class="form-control" value="{{ old('date') }}" />
                        </div>
                    
                        <div class="col-md-2 from-group"> 
                            <input type="text" name="donnee" class="form-control" value="{{ old('donnee') }}" placeholder="Rechercher Client "/>
                        </div>

                        <div class="col-md-2 from-group"> 
                            <select name="commerciale" id="" class="form-control select2">
                                <option value="">Commerciale</option>
                                @foreach($users as $u)
                                    <option value="{{ $u->id }}">{{ $u->name . ' ' . $u->email }}</option>
                                @endforeach 
                            </select>
                        </div>
                            <!--
                        <div class="col-md-2 from-group"> 
                            <select name="agence" id=""  class="form-control select2">
                                <option value="">Agence</option>
                                @foreach($agences as $a)
                                    <option value="{{ $a->id }}">{{ $a->agence }}</option>
                                @endforeach 
                            </select>
                        </div> --> 

                        <div class="col-md-1 from-group text-center"> 
                            <input type="submit" class="btn btn-primary" value="Rechercher"/>
                        </div>
                        
                    </form>
                <div class="table-responsive">
                    <table  id="scroll-horizontal-datatables1" class="table w-100 nowrap table-index datatable datatable-Client">

                        <thead class="table-light">
                            <tr>
                                <th>Réf.</th>
                                <th>Date</th>
                                <th>Date Validation</th>
                                <th>Client</th>
                                <th>Commande</th>
                                <th>Montant</th>
                                <th>Agence</th>
                                <th>Avis</th>
                                <th>Statut</th>
                                <th>Action</th>
                            </tr>
                        </thead>
                        <tbody>
                                                        @foreach($commandes as $c)
                                                                <tr>
                                    
                                    <td>
                                        <a href="{{ route('admin.commande_client.show', $c->rowid) }}" class="badge bg-primary">
                                            {{ $c->ref ?? ''}}
                                        </a>
                                    </td>
                                    
                                    <td>
                                        {{ Carbon\Carbon::parse($c->date_commande)->format('d/m/Y') ?? ''}}
                                    </td>

                                    <td>
                                        {{ $c->date_validation_banque ? Carbon\Carbon::parse($c->date_validation_banque)->format('d/m/Y') : '' }}
                                    </td>

                                    <td>
                                        <a href="{{ route('admin.clients.show', $c->client_id ?? 0) }}" class="badge bg-secondary">
                                            {{ $c->nom ?? '' }}
                                        </a>
                                    </td>
                                    <td>
                                        @if($c->commandedet)
                                            @foreach($c->commandedet as $p)
                                                {{ $p->label ?? App\Product::find($p->fk_product)->label ?? '' . ' => '. $p->qty ?? ''}}
                                            @endforeach
                                        @endif
                                    </td>

                                    <td>
                                        {{ number_format($c->total_ttc, 0, ' ', ' ') ?? '' }}
                                    </td>
                                    <td>
                                        {{ $c->agence ?? ''}}
                                    </td>
                                
                                    <td>
                                    
                                        @if($c->avis_banque  == 1)
                                            <span class="badge bg-warning"> En Cours <span class="ms-1 fas fa-stream"></span> </span> 
                                                                                         
                                        @elseif($c->avis_banque  == 2)
                                            <span class="badge bg-success"> Validé <span class="ms-1 fa fa-check"></span> </span> 
                                                                                         
                                        @elseif($c->avis_banque  == 3)
                                            <span class="badge bg-warning"> Rejeté </span> 
                                                                                         
                                        @elseif($c->avis_banque  == 5)
                                            <span class="badge bg-primary"> EMC-LIBRE </span> 
                                                                                         
                                        @endif 
                                     
                                       
                                    </td>

                                    <td>
                                        @if($c->fk_statut  == 1)
                                            <span class="badge bg-danger"> Non Expédiée <span class="ms-1 fas fa-stream"></span> </span>
                                              
                                        @elseif($c->fk_statut  == 2)
                                            <span class="badge bg-warning"> En Cours <span class="ms-1 fa fa-check"></span> </span> 
                                             
                                        @elseif($c->fk_statut  == 3)
                                            <span class="badge bg-success"> Expédié </span> 
                                             
                                        @elseif($c->fk_statut  == 4)
                                            <span class="badge bg-success"> Cloturé </span> 
                                        @endif 
                                        
                                    </td>

                                    <td class="table-action">
                                        <a href="{{ route('admin.commande_client.show', $c->rowid) }}" class="action-icon"> <i class="mdi mdi-eye text-primary"></i></a>
                                        <!--<a href="javascript:void(0);" class="action-icon"> <i class="mdi mdi-square-edit-outline"></i></a> --> 
                                        @can('commande_supprimer')
                                            <form action="{{ route('admin.commande_client.destroy', $c->rowid) }}" method="POST" onsubmit="return confirm('Etes-vous sûr de vouloir supprimer définitvement la commande la client ?');" style="display: inline-block;">
                                                <input type="hidden" name="_method" value="DELETE">
                                                <input type="hidden" name="_token" value="{{ csrf_token() }}">
                                                <button type="submit" class="">
                                                    <i class="mdi mdi-delete text-danger"> </i> 
                                                </button> 
                                            </form>
                                        @endcan
                                    </td>
                                </tr>
                            @endforeach
                        </tbody>
                        <h3 class=""> 
                            Total Commande :  <span class="badge bg-primary"> {{ number_format($ct, 0, '',  ' ')  }} </span>  
                            Commande Validé :  <span class="badge bg-success"> {{ number_format($cv, 0, '',  ' ')  }} </span>  
                            Commande En cours :  <span class="badge bg-warning">  {{ number_format($ce, 0, '',  ' ')  }}  </span>  
                            Commande Rejeté :  <span class="badge bg-danger">  {{ number_format($cr, 0, '',  ' ')  }}  </span>  
                            EMC Libre :  <span class="badge bg-secondary">  {{ number_format($cl, 0, '',  ' ')  }}  </span>  
                        </h3>

                        <h3 class=""> 
                            Total Montant :  <span class="badge bg-primary">  {{ number_format($totaux, 0, '',  ' ')  }} FCFA </span> 
                            Montant Validé:  <span class="badge bg-success"> {{ number_format($totaux_valide, 0, '',  ' ')  }} FCFA </span>  
                            Montant En cours :  <span class="badge bg-warning"> {{ number_format($totaux_encours, 0, '',  ' ')  }} FCFA </span> 
                            Montant Rejeté :  <span class="badge bg-danger">  {{ number_format($totaux_rejete, 0, '',  ' ')  }}  FCFA </span>  
                            Montant EMC Libre :  <span class="badge bg-secondary">  {{ number_format($totaux_libre, 0, '',  ' ')  }} FCFA </span>  
                        </h3>

                        <h3 class=""> 
                            Commande Expédié :  <span class="badge bg-success"> {{ number_format($oui_exp, 0, '',  ' ')  }} </span>  
                            Commande En cours d'expédition :  <span class="badge bg-warning"> {{ number_format($encours_exp, 0, '',  ' ')  }} </span> 
                            Commande Non Expédié:  <span class="badge bg-danger">  {{ number_format($non_exp, 0, '',  ' ')  }} </span>  
                        </h3>
                    </table>
                
                
                    <tfoot>
                            {{ $commandes->links('pagination::bootstrap-4') }}
                    </tfoot>
                </div>
            </div> <!-- end card-body-->
        </div> <!-- end card-->
    </div> <!-- end col -->
</div>

<!---
<script>
       $('.datatable-Client:not(.ajaxTable)').DataTable({ buttons: dtButtons });
</script>
-->
<script type="text/javascript">
    $(".select2").select2();
</script>
@endsection