@extends('layouts.admin')
@section('content')
<title> LISTE DES COMMANDE CLIENTS </title> 
    <div style="margin-bottom: 10px;" class="row">
        <div class="col-lg-12">
            <a class="btn btn-square btn-success text-white" href="{{ route('admin.commande_client.create') }}">
                Nouvelle Commande Client
            </a>
            @can('fournisseur_liste')
                <button type="button" class="btn btn-square btn-primary" data-toggle="modal" data-target="#basicModal">Faire un Bon d'Achat</button>
            @endcan 
        </div>
    </div>
<div class="card">
    <div class="card-header">
        LISTE DES COMMANDES CLIENTS
    </div>

    <div class="card-body">
       
            <table class="table table-bordered table-striped table-hover datatable datatable-Client" id="table" style="width: 100%;">
                <thead>
                    <tr>
                        <th width="5">

                        </th>

                        <th>
                            Réf.
                        </th>

                        <th>
                            Date
                        </th>

                        <th>
                            Client
                        </th>

                        <th>
                            Téléphone
                        </th>

                        <th>
                            Produit => Quantité
                        </th>

                        <th>
                            Montant 
                        </th>
                        <th>
                            Complément
                        </th>
                        @can('commission_voire')
                            <th>
                                Commission
                            </th>
                        @endcan
                        <th>
                            Agence
                        </th>

                        <th>
                            Echéance
                        </th>

                        <th>
                             Banque
                        </th>

                        <th> 
                            Auteur 
                        </th> 

                        <th> Commercial </th> 

                        <th>
                            Livraison
                        </th>

                        <th>
                            Action
                        </th>
                    </tr>
                </thead>
                <tbody>
                    @foreach($commandes as $key => $commande)
    
                        <tr data-entry-id="{{ $commande->rowid }}">
                            <td>

                            </td>

                            <td>
                                <a href="{{ route('admin.commande_client.show', $commande->rowid) }}" class="text-primary link-primary"> {{ $commande->ref ?? '' }} </a> 
                            </td>

                            <td data-sort='"  "'>
                                {{ Carbon\Carbon::parse($commande->date_commande)->format('d/m/Y') }}
                            </td>

                            <td>
                                <a href="{{ route('admin.clients.show', $commande->client_id) }}" class="bg-secondary" style=" font-size: 13px; padding: 4px; border: 1px solid transparent; border-radius: 6px; color: #fff;"> {{ $commande->nom ?? '' }} </a> 
                            </td>
                            
                            <td>
                                {{ $commande->phone ?? '' }}
                            </td>
                            
                            <td>
                                <span style=" font-size: 13px; padding: 4px; border: 1px solid transparent; border-radius: 6px; background-color: #2c3e50; color: #fff;">   
                                    @foreach($commande->fk_product as $prod)
                                        {{ $prod . ' / '  }}
                                    @endforeach 
                                </span>
                            </td>
 
                            <td>
                                {{ number_format(($commande->total_ttc > 250000 ) ? 250000 : $commande->total_ttc, 0 , '', ' ') ?? '' }}
                            </td>
                            
                            <td>
                                <span  class="badge @if($commande->total_ttc > 250000) @if($commande->avaibility >= $commande->total_ttc) bg-label-success @endif @if($commande->avaibility < $commande->total_ttc) bg-label-danger @endif @endif " style=" font-size: 13px; padding: 5px; border: 1px solid transparent; border-radius: 6px;"> 
                                    {{ number_format( ($commande->total_ttc > 250000 ) ? $commande->total_ttc - 250000 : 0, 0 , '', ' ') ?? '' }}
                                </span>
                            </td>

                            @can('commission_voire')
                                <td>
                                    {{ number_format($commande->commission, 0 , '', ' ') ?? '' }}
                                </td>
                            @endcan

                            <td>
                                {{ $commande->agence ?? '' }}
                            </td>
                            
                            <td>
                                {{ $commande->echeance ?? '' }}
                            </td>

                            <td>
                                <span class=" {{ $commande->color }}" style=" font-size: 13px; padding: 4px; border: 1px solid transparent; border-radius: 6px;">   
                                    {{ $commande->avis_banque ?? '' }}
                                </span> 
                            </td>

                            <td>
                                {{ $commande->name ?? '' }}
                            </td>
                                     
                            <td>
                                {{ $commande->numcom ?? '' }}
                            </td>

                            <td>
                                <span class="badge {{ $commande->fk_currency }}" style=" font-size: 13px; padding: 4px; border: 1px solid transparent; border-radius: 6px;">   
                                    {{ $commande->fk_statut ?? '' }}
                                </span>
                            </td>
                         
                            <td>
                                @can('commande_voire')
                                    <a class="btn btn-xs btn-primary fa fa-eye" href="{{ route('admin.commande_client.show', $commande->rowid) }}">
                                        
                                    </a>
                                @endcan

                                @can('commande_modifier')
                                    <a class="btn btn-xs btn-info fa fa-edit" href="{{ route('admin.commande_client.edit', $commande->rowid) }}">
                                     
                                    </a>
                                @endcan

                                @can('commande_supprimer')
                                    <form action="{{ route('admin.commande_client.destroy', $commande->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="btn btn-xs btn-danger">
                                            <i class="fa fa-trash"> </i> 
                                        </button> 
                                    </form>
                                @endcan
                            </td>

                        </tr>
                    @endforeach
                </tbody>
                <tfoot>
                    <tr  style="text-align:center;" >
                        <th colspan="4" style="text-align:right;"></th>
                        <th></th>
                    </tr>
                </tfoot>
            </table>
      
    </div>
    <!-- Modal -->
    <div class="modal fade" id="basicModal">
        <div class="modal-dialog" role="document">
            <div class="modal-content">
                <div class="modal-header">
                    <h5 class="modal-title">Bon d'Achat </h5>
                    <button type="button" class="close" data-dismiss="modal"><span>&times;</span>
                    </button>
                </div>
                <div class="modal-body">
                <form id="BAForm" enctype="multipart/form-data">
                    @csrf
                    <div class="form-group {{ $errors->has('fournisseur') ? 'has-error' : '' }}">
                        <label for="first_name">FOURNISSEUR *</label>
                        <select class="form-control select2" name="fournisseur" id="fournisseur"> 
                            <option> Sélectionner un fournisseur </option>
                            @foreach(\DB::table('llx_societe')->select('rowid', 'nom',  'phone', 'address', 'datec')->where('fournisseur', '=', 1)->get() as $f)
                                <option value="{{ $f->rowid }}"> {{ $f->nom . ' ' . $f->phone }} </option> 
                            @endforeach
                        <select>  
                        @if($errors->has('founisseur'))
                            <p class="help-block">
                                {{ $errors->first('founisseur') }}
                            </p>
                        @endif
                        <p class="helper-block">
                            {{ trans('cruds.client.fields.first_name_helper') }}
                        </p>
                    </div>
            
                    <div class="form-group {{ $errors->has('date') ? 'has-error' : '' }}">
                        <label for="last_name">Date</label>
                        <input type="text" id="date" name="date" class="form-control date" value="{{ old('date') }}">
                    
                        @if($errors->has('date'))
                            <p class="help-block">
                                {{ $errors->first('date') }}
                            </p>
                        @endif
                        <p class="helper-block">
                            
                        </p>
                    </div>
                    
                    <div class="form-group {{ $errors->has('email') ? 'has-error' : '' }}">
                        <label for="email">Note</label>
                        <textarea  id="note" name="note" class="form-control" rows="8" cols="8"> </textarea> 
                        @if($errors->has('email'))
                            <p class="help-block">
                                {{ $errors->first('email') }}
                            </p>
                        @endif
                        <p class="helper-block">
                        
                        </p>
                    </div>
                    <input type="hidden" name="user_id" value="{{ Auth::user()->id }}" /> 
                    <div>
                        <input type="submit" id="enregistrer" class="btn btn-secondary" value="Enregistrer">
                        <button type="button" class="btn btn-danger" data-dismiss="modal">Fermer</button>
                    </div>
                </form>
                </div>
            </div>
        </div>
    </div>
</div>
@endsection
@section('scripts')
@parent
<script>
    $(function () {
        let dtButtons = $.extend(true, [], $.fn.dataTable.defaults.buttons)

        @can('role_delete')
            let deleteButtonTrans = 'Banque : Validé'
            let deleteButton = {
                text: deleteButtonTrans,
                url: "{{ route('admin.commande_client_massvalidation') }}",
                className: 'btn-square btn-success text-white mr-1',
                action: function (e, dt, node, config) {
                    var ids = $.map(dt.rows({ selected: true }).nodes(), function (entry) {
                        return $(entry).data('entry-id')
                    });
                  
                    if (ids.length === 0) {
                        alert('Veuillez sélectionner de ligne !')
                        return
                    }

                    if (confirm('Etes-vous sur de vouloir les valider ?')) {
                        $.ajax({
                        headers: {'x-csrf-token': _token},
                        method: 'PUT',
                        url: config.url,
                        data: { ids: ids, _method: 'PUT' }})
                    .done(function () { location.reload() })
                    }
                }
            }
            dtButtons.push(deleteButton)
        @endcan
    
        @can('role_delete')
            let confirmButtonTrans = 'Livraison : Oui'
            let confirmButton = {
                text: confirmButtonTrans,
                url: "{{ route('admin.commande_client_massconfirmlivraison') }}",
                className: 'btn-square btn-success text-white mr-1',
                action: function (e, dt, node, config) {
                    var ids = $.map(dt.rows({ selected: true }).nodes(), function (entry) {
                        return $(entry).data('entry-id')
                    });

                    if (ids.length === 0) {
                        alert('Veuillez sélectionner de ligne !')
                        return
                    }

                    if (confirm('Êtes-vous sur de vouloir confirmer la livraison ? ')) {
                        $.ajax({
                            headers: {'x-csrf-token': _token},
                            method: 'POST',
                            url: config.url,
                            data: { ids: ids, _method: 'PUT' }
                        }).done(function () { location.reload() })
                    }
                }
            }
            dtButtons.push(confirmButton)
        @endcan


        @can('role_delete')
            let noButtonTrans = 'Livraison : Non'
            let noButton = {
                text: noButtonTrans,
                url: "{{ route('admin.commande_client_massnoconfirmlivraison') }}",
                className: 'btn-square btn-danger text-white',
                action: function (e, dt, node, config) {

                    var ids = $.map(dt.rows({ selected: true }).nodes(), function (entry) {
                        return $(entry).data('entry-id')
                    });

                    if (ids.length === 0) {
                        alert('Veuillez sélectionner de ligne !')
                        return
                    }

                    if (confirm('Êtes-vous sûr de vouloir les classer non livré ?')) {
                        $.ajax({
                        headers: {'x-csrf-token': _token},
                        method: 'POST',
                        url: config.url,
                        data: { ids: ids, _method: 'PUT' }})
                        .done(function () { location.reload() })
                    }
                }
            }
            dtButtons.push(noButton)
        @endcan


  $.extend(true, $.fn.dataTable.defaults, {
    order: [[ 1, 'desc' ]],
   
    lengthMenu: [0, 5, 10, 20, 50, 100, 200, 500],
  });
  
    $('.datatable-Client:not(.ajaxTable)').DataTable({ buttons: dtButtons, 
        drawCallback: function () {
            var api = this.api();
            $( api.table().footer() ).html( '<strong>Total Montant : ' +
                api.column( 6, {page:'current'} ).data().sum() +
                ' FCFA <br/>Total Commission : ' +
                api.column( 8, {page:'current'} ).data().sum() + ' FCFA</strong>'
            );
        },
        
    });
     
  //console.log('Sum : ' + table.column( 4 ).data().sum())
/*
    $('a[data-toggle="tab"]').on('shown.bs.tab', function(e){
        $($.fn.dataTable.tables(true)).DataTable()
            .columns.adjust();
    }).column( 4 ).data().sum();*/


})

    $.ajaxSetup({
        headers: {
            'X-CSRF-TOKEN': $('meta[name="csrf-token"]').attr('content')
        }
    });
      
    $('#enregistrer').click(function (e) {

        e.preventDefault();
        $(this).html('Sending..');
        var dt = $('#table').DataTable();

        var ids = $.map(dt.rows({ selected: true }).nodes(), function (entry) {
            return $(entry).data('entry-id')
        });

        if (ids.length === 0) {
            alert('Veuillez sélectionner de ligne !')
            return
        }
// $('#BAForm').serialize(), 

        $.ajax({
          data: { 
                    fournisseur_id : $('#fournisseur').val(),
                    date : $('#date').val(),
                    note : $('#note').val(),
                    ids: ids
                },  
          url: "{{ route('admin.commande_fournisseur_masscommandef') }}",
          type: "POST",
          dataType: 'json',  
 
          success: function (data) {
            console.log(data[0]); 
            window.location = '/admin/commande_fournisseur/' + data;
          },
          error: function (data) {
            
          }
      });
    });
  
</script>
@endsection