@extends('layouts.app')
@section('addhead')
    <link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/1.13.5/css/jquery.dataTables.min.css">
    <link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/buttons/2.4.1/css/buttons.bootstrap5.min.css">
    <link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/buttons/2.4.1/css/buttons.dataTables.min.css">
@endsection

@section('content')
    <section class="banner-hero-little mb-2 bg-blue">
        <div class="banner-content-title">
            <h5 class="text-yellow">Balance</h5>
        </div>
    </section>

    @if(Auth::user()->roles_id == 2 )
        <div class="container mb-5 mt-5">
             <div class="row justify-content-center">
                <div class="col-md-12">
                    <div class="card">
                        <div class="card-header bg-blue text-white" align="center">
                            <h5>Choisir une periode pour voir les opérations de l'entreprise</h5>
                            @if (session('message'))
                                <div class="alert alert-warning" role="alert">
                                    {{ session('message') }}
                                </div>
                            @endif

                            @if (session('success'))
                                <div class="alert alert-success" role="alert">
                                    {{ session('success') }}
                                </div>
                            @endif</span> <br> 
                        </div>
                        <div class="card-body">
                            <form method="POST" action="{{route('voir_mouvement')}}">
                                @csrf
                                <div class="row justify-content-center">

                                    <div class="col-md-4">
                                        <div class="mb-3">
                                            <label class="form-label">date de début</label>
                                            <input type="date"  class="form-control @error('ddebut') is-invalid @enderror" name="ddebut" value="{{ old('ddebut') }}" required autocomplete="ddebut" autofocus>                                                
                                            @error('ddebut')
                                                <span class="invalid-feedback" role="alert">
                                                    <strong>{{ $message }}</strong>
                                                </span>
                                            @enderror
                                        </div>
                                    </div>

                                    <div class="col-md-4">
                                        <div class="mb-3">
                                            <label class="form-label">date de fin</label>
                                            <input type="date"  class="form-control @error('dfin') is-invalid @enderror" name="dfin" value="{{ old('dfin') }}" required autocomplete="dfin" autofocus>                                                
                                            @error('dfin')
                                                <span class="invalid-feedback" role="alert">
                                                    <strong>{{ $message }}</strong>
                                                </span>
                                            @enderror
                                        </div>
                                    </div>

                                    <div class="col-md-3">
                                        <div class="mb-3">
                                            <label class="form-label">Type d'opération</label>
                                            <select type="text"  class="form-select @error('typeopera') is-invalid @enderror" name="typeopera" value="{{ old('typeopera') }}" required autocomplete="typeopera" autofocus>

                                                @foreach($typeopera as $type)
                                                    <option value="{{$type->id}}">{{$type->type}}</option>
                                                @endforeach
                                               
                                            </select>

                                            @error('typeopera')
                                                <span class="invalid-feedback" role="alert">
                                                    <strong>{{ $message }}</strong>
                                                </span>
                                            @enderror
                                        </div>
                                    </div>   
                                </div>

                                <div class="row justify-content-center mb-0">
                                    <button type="submit" class="btn btn-primary bg-yellow text-white">Voir</button>
                                </div>
                            </form> 
                        </div>
                    </div>
                </div>

                @if(isset($listMouvements))
                <div class="col-md-12">
                    <div class="card">
                        <div class="card-header">
                            <h5>Résultats de la recherche : Balance du {{date('d-m-Y', strtotime ($debut))}} au {{date('d-m-Y', strtotime ($fin))}} pout le type d'opération {{$typeoperaEncours}}</h5>        
                        </div>
                        <div class="card-body table-responsive">
                            <table id="balance" class="cell-border" style="width:100%">
                                <thead>
                                    <tr align="center">
                                        <th style="text-align: center; border: solid 0.1px black;">Date</th>
                                        <th style="text-align: center; border: solid 0.1px black;" width="40%">Libelle</th>
                                        <th style="text-align: center; border: solid 0.1px black;">Entrée</th>
                                        <th style="text-align: center; border: solid 0.1px black;">Sortie</th>
                                        <th style="text-align: center; border: solid 0.1px black;">Solde</th>
                                        
                                    </tr>

                                </thead>
                                <tbody>

                                    @php 
                                        $solde = $soldeAvBa;
                                        $tdebit = 0;
                                        $tcredit = 0;
                                    @endphp

                                    @foreach($listMouvements as $lm)
                                       <tr>
                                            <td>{{date('d-m-Y', strtotime($lm->date_enre))}}</td>
                                            <td>{{$lm->libelle}}</td>

                                            @if($lm->debit == 0)
                                                <td></td>
                                            @else
                                                <td>{{number_format($lm->debit, 0, ',', ' ')}}</td>
                                            @endif

                                            @if($lm->credit == 0)
                                                <td></td>
                                            @else
                                            <td>{{number_format($lm->credit, 0, ',', ' ')}}</td>
                                            @endif

                                            @php
                                                $solde = $solde + ($lm->debit - $lm->credit);
                                                $tdebit = $tdebit + $lm->debit;
                                                $tcredit = $tcredit + $lm->credit;
                                                
                                            @endphp

                                            <td>{{number_format($solde, 0, ',', ' ')}}</td>
                                               
                                       </tr>
                                   @endforeach
                                        <tr style="font-weight: bold">
                                            <td>Totaux</td>
                                            <td>Totaux sur la période</td>
                                            <td>{{number_format($tdebit, 0, ',', ' ')}}</td>
                                            <td>{{number_format($tcredit, 0, ',', ' ')}}</td>
                                            <td>{{number_format($tdebit - $tcredit , 0, ',', ' ')}}</td>
                                        </tr>
                                </tbody>      
                            </table>
                        </div>
                    </div>
                </div>
                @endif
            </div>
        </div>
    @endif
@endsection
@section('footerjs')
    <script src="https://cdn.datatables.net/1.13.5/js/jquery.dataTables.min.js"></script>
    <script src="https://cdn.datatables.net/buttons/2.4.1/js/dataTables.buttons.min.js"></script>
    <script src="https://cdn.datatables.net/buttons/2.4.1/js/buttons.bootstrap5.min.js"></script>
    <script src="https://cdn.datatables.net/buttons/2.4.1/js/buttons.colVis.min.js"></script>
    <script src="https://cdn.datatables.net/buttons/2.4.1/js/buttons.print.min.js"></script>
    <script src="https://cdn.datatables.net/buttons/2.4.1/js/buttons.html5.min.js"></script>
    <script src="https://cdnjs.cloudflare.com/ajax/libs/jszip/3.1.3/jszip.min.js"></script>
    <script src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.2.7/pdfmake.min.js"></script>
    <script src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.2.7/vfs_fonts.min.js"></script>
    

    <script type="text/javascript">
        $(document).ready(function() {
            $('#balance').DataTable( { 
                "ordering": false,
                dom: 'Bfrtip',
                buttons: [
                    'copyHtml5', 'csvHtml5', 'excelHtml5', 'pdfHtml5', 'printHtml5'
                ],

                responsive: true,
            } ); 
        } );
    </script>
@endsection