@extends('base')

@section('content')
    <div class="alert alert-success text-center" id="entete" style="background:#000000 !important; color: white !important">
        <h1>LIGNES DE BL NON FACTURABLES (SERVICES ET AJOUTS)</h1>
    </div>

    <div class="card shadow-sm mb-4">
        <div class="card-body">
            <h5 class="card-title text-success mb-3"><i class="fas fa-filter"></i> Filtres</h5>
            <div class="form-row">
                <div class="form-group col-md-3">
                    <label for="date_debut">Date début:</label>
                    <input type="date" class="form-control" id="date_debut" value="{{ date('Y-m-01') }}">
                </div>
                <div class="form-group col-md-3">
                    <label for="date_fin">Date fin:</label>
                    <input type="date" class="form-control" id="date_fin" value="{{ date('Y-m-t') }}">
                </div>
                <div class="form-group col-md-3">
                    <label for="societe_id">Société:</label>
                    <select id="societe_id" class="form-control">
                        <option value="">Toutes</option>
                        @foreach($societes as $societe)
                            <option value="{{ $societe->ID_Societe }}">{{ $societe->Societe_Code }} ->
                                {{ $societe->Societe_Nom_Societe }}
                            </option>
                        @endforeach
                    </select>
                </div>
                <div class="form-group col-md-3">
                    <label for="centrale_id">Centrale:</label>
                    <select id="centrale_id" class="form-control">
                        <option value="">Toutes</option>
                        @foreach($centrales as $centrale)
                            <option value="{{ $centrale->id_centrale }}">{{ $centrale->centrale_code }} ->
                                {{ $centrale->centrale_nom }}
                            </option>
                        @endforeach
                    </select>
                </div>
            </div>
            <button class="btn btn-success" id="btn_filtrer">
                <i class="fas fa-search"></i> Rechercher
            </button>
        </div>
    </div>

    <div class="table-responsive">
        <table class="table table-striped table-hover table-bordered" id="table_lignes_bl">
            <thead style="background-color:#28a745; color:white">
                <tr>
                    <th>Société</th>
                    <th>Centrale</th>
                    <th>BL</th>
                    <th>Date</th>
                    <th>Client</th>
                    <th>Chantier</th>
                    <th>Article</th>
                    <th>Quantité</th>
                    <th>Prix</th>
                </tr>
            </thead>
        </table>
    </div>

    <script>
        $(document).ready(function () {
            var table = $('#table_lignes_bl').DataTable({
                processing: true,
                serverSide: true,
                dom: 'Bfrtip',
                buttons: [
                    { "extend": 'excel', "text": 'Export excel', "className": 'btn_export_excel', title: 'Lignes de BL non facturables', "attr": { "style": "color: rgb(255, 255, 255); background-color: rgb(33, 136, 56);" } }
                ],
                ajax: {
                    url: "{{ route('lignes_non_facturables.table') }}",
                    data: function (d) {
                        d.date_debut = $('#date_debut').val();
                        d.date_fin = $('#date_fin').val();
                        d.societe_id = $('#societe_id').val();
                        d.centrale_id = $('#centrale_id').val();
                    }
                },
                columns: [
                    { data: 'societe_libelle', orderable: false },
                    { data: 'centrale_libelle', orderable: false },
                    { data: 'bl_code' },
                    { data: 'bl_date_livraison_formatee', orderable: false },
                    { data: 'client_libelle', orderable: false },
                    { data: 'chantier_libelle', orderable: false },
                    { data: 'article_complet', orderable: false },
                    { data: 'quantite_formatee', orderable: false },
                    { data: 'prix_formate', orderable: false }
                ],
                language: {
                    url: "//cdn.datatables.net/plug-ins/1.10.24/i18n/French.json"
                }
            });

            $('#btn_filtrer').click(function () {
                table.ajax.reload();
            });
        });
    </script>
@endsection