@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">Enregistrement d'opérations</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 shadow-sm">
                        <div class="card-header bg-blue text-white">
                            <h5 align="center">Enregistrer une opération</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 <br>
                        </div>
                        <div class="card-body">  
                            <form method="POST" action="{{route('save_mouvement')}}">
                                @csrf
                                <div class="row ">

                                    <div class="col-md-2">
                                        <div class="mb-3">
                                            <label class="form-label">Type d'opération</label>
                                            <select type="text" id="typeopera"  class="form-select @error('typeopera') is-invalid @enderror" name="typeopera" value="{{ old('typeopera') }}" required autocomplete="typeopera" autofocus>
                                                <option value="novalue">Selectionner</option>
                                                @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 class="col-md-2">
                                        <div class="mb-3">
                                            <label class="form-label">Charges ?</label>
                                            <select type="text" id="qcharge"  class="form-select @error('qcharge') is-invalid @enderror" name="qcharge" value="{{ old('qcharge') }}" required autocomplete="qcharge" autofocus>
                                                <option value="0">Selectionner</option>
                                                <option value="1">Oui</option>
                                                <option value="0">Non</option>
                                            </select>

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

                                    <div class="col-md-2 not-display" id="charge">
                                        <div class="mb-3">
                                            <label class="form-label">Type de charges</label>
                                            <select type="text"  class="form-select @error('charge') is-invalid @enderror" name="charge" value="{{ old('charge') }}" required autocomplete="charge" autofocus>
                                                <option value="novalue">Selectionner</option>
                                                @foreach($charges as $charge)
                                                    <option value="{{$charge->id}}">{{$charge->nom_charge}}</option>
                                                @endforeach
                                                
                                               
                                            </select>

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

                                    <div class="col-md-6">
                                        <div class="mb-3">
                                            <label class="form-label">Libelle</label>
                                            <input type="text" class="form-control @error('libelle') is-invalid @enderror" placeholder="libelle" name="libelle" value="{{ old('libelle') }}"  autocomplete="libelle" autofocus>

                                            @error('libelle')
                                                <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">Débit ou Crédit </label>
                                            <select type="text"  class="form-select @error('debitCredit') is-invalid @enderror" name="debitCredit" value="{{ old('debitCredit') }}" required autocomplete="debitCredit" autofocus>

                                                
                                                <option value="1">Entrée +</option>
                                                <option value="2">Sortie -</option>
                                               
                                            </select>

                                            @error('debitCredit')
                                                <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">Montant (FCFA)</label>
                                            <input type="number" step=".01" class="form-control @error('montant') is-invalid @enderror" min="0" placeholder="montant" name="montant" value="{{ old('montant') }}" required autocomplete="montant" autofocus>

                                            @error('montant')
                                                <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">Enregistrée le</label>
                                            <input type="date" class="form-control @error('registered') is-invalid @enderror" name="registered" required autocomplete="registered" autofocus>

                                            @error('registered')
                                                <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">Enregistrer</button>
                                </div>
                            </form>  
                        </div>
                    </div>
                </div>
            </div>
        </div>


        <div class="container mb-5">
            <nav class="nav nav-tabs" id="myTabs" role="tablist">
                <a class="nav-link active" id="tab1-tab" data-toggle="tab" href="#tab1" role="tab" aria-controls="tab1" aria-selected="true">
                    <div class="card">
                        <div class="card-header bg-blue text-white" align="center">Toutes les operations</div>
                    </div>
                </a>
                   
                {{--<a class="nav-link" id="tab2-tab" data-toggle="tab" href="#tab2" role="tab" aria-controls="tab2" aria-selected="false">
                    <div class="card">
                        <div class="card-header bg-green text-white" align="center">Charges</div>
                    </div>
                </a>--}}

                <a class="nav-link" id="tab3-tab" data-toggle="tab" href="#tab3" role="tab" aria-controls="tab3" aria-selected="false">
                    <div class="card">
                        <div class="card-header bg-orange text-white" align="center">Banque</div>
                    </div>
                </a>

                <a class="nav-link" id="tab4-tab" data-toggle="tab" href="#tab4" role="tab" aria-controls="tab4" aria-selected="false">
                    <div class="card">
                        <div class="card-header bg-red text-white" align="center">Caisse</div>
                    </div>
                </a>

                <a class="nav-link" id="tab5-tab" data-toggle="tab" href="#tab5" role="tab" aria-controls="tab5" aria-selected="false">
                    <div class="card">
                        <div class="card-header bg-yellow text-white" align="center">Ventes</div>
                    </div>
                </a>
            </nav>

            <div class="tab-content" id="myTabsContent">

                <div class="tab-pane fade show active" id="tab1" role="tabpanel" aria-labelledby="tab1-tab">
                    <div class="card">
                        <div class="card-body table-responsive">
                            <table id="ttoperation" class="cell-border" style="width:100%">
                                <thead>
                                    <tr>
                                        <th rowspan="2" style="text-align: center; border: solid 0.1px black;">Date</th>
                                        <th rowspan="2" width="30%" style="text-align: center; border: solid 0.1px black;">Libelle</th>
                                         <th rowspan="2" style="text-align: center; border: solid 0.1px black;">Type d'operation</th>
                                        <th colspan="2" style="text-align: center; border: solid 0.1px black;">Toutes les opérations</th>
                                        {{--<th rowspan="2" style="text-align: center; border: solid 0.1px black;">Solde</th>--}}
                                    </tr>
                                    <tr >
                                        <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>
                                    </tr>
                                </thead>

                                <tbody>
                                    @php $solde = 0; @endphp
                                    
                                    @foreach($mouvements as $m)


                                        <tr>
                                            <td>{{date('d-m-Y', strtotime($m->date_enre))}}</td>
                                            <td>{{$m->libelle}}</td>
                                            <td>
                                                {{$m->type}} 
                                            </td>   

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

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


                                            {{--@php
                                                $solde = $solde + ($m->debit - $m->credit);
                                                
                                            @endphp

                                            <td>{{number_format($solde, 0, ',', ' ') }}</td>--}}
                                        </tr>
                                    @endforeach 
                                </tbody>
                            </table>
                        </div>
                    </div>
                </div>

                {{--<div class="tab-pane fade" id="tab2" role="tabpanel" aria-labelledby="tab2-tab">
                    <div class="card">
                        <div class="card-body table-responsive">
                            <table id="charges" class="cell-border" style="width:100%">
                                <thead>
                                    <tr>
                                        <th rowspan="2" style="text-align: center; border: solid 0.1px black;">Date</th>
                                        <th rowspan="2" width="30%" style="text-align: center; border: solid 0.1px black;">Libelle</th>
                                         <th rowspan="2" style="text-align: center; border: solid 0.1px black;">Type d'operation</th>
                                        <th colspan="2" style="text-align: center; border: solid 0.1px black;">Charges</th>
                                        <th rowspan="2" style="text-align: center; border: solid 0.1px black;">Solde</th>

                                        <th rowspan="2" style="text-align: center; border: solid 0.1px black;">Actions</th> 
                                    </tr>
                                    <tr >
                                        <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>
                                    </tr>
                                </thead>

                                <tbody>
                                    @php $solde = 0; @endphp
                                    
                                    @foreach($mouvementCharges as $m)


                                        <tr>
                                            <td>{{date('d-m-Y', strtotime($m->date_enre))}}</td>
                                            <td>{{$m->libelle}}</td>
                                            <td>
                                                {{$m->type }} {{$m->nom_charge }} 
                                            </td>   

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

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


                                            @php
                                                $solde = $solde + ($m->debit - $m->credit);
                                                
                                            @endphp

                                            <td>{{number_format($solde, 0, ',', ' ') }}</td>

                                            <td align="center">
                                                <a class="btn btn-primary" href="{{ url('edit_mouv/'.$m->id) }}"><i class="fa-solid fa-pen" style="color: white;"></i></a>

                                                <a class="btn btn-danger" data-confirm="Voulez-vous vraiment supprimer cet élement ?"  href="{{ url('delete_mouv/'.$m->id) }}"><i class="fa-solid fa-trash-can" style="color: white;"></i></a>
                                            </td>

                                        </tr>
                                    @endforeach 
                                </tbody>
                            </table>
                        </div>
                    </div>
                </div>--}}

                <div class="tab-pane fade" id="tab3" role="tabpanel" aria-labelledby="tab3-tab">
                    <div class="card">
                        <div class="card-body table-responsive">
                            <table id="banque" class="cell-border" style="width:100%">
                                <thead>
                                    <tr>
                                        <th rowspan="2" style="text-align: center; border: solid 0.1px black;">Date</th>
                                        <th rowspan="2" width="30%" style="text-align: center; border: solid 0.1px black;">Libelle</th>
                                         <th rowspan="2" style="text-align: center; border: solid 0.1px black;">Type d'operation</th>
                                        <th colspan="2" style="text-align: center; border: solid 0.1px black;">Banque</th>
                                        <th rowspan="2" style="text-align: center; border: solid 0.1px black;">Solde</th>

                                        <th rowspan="2" style="text-align: center; border: solid 0.1px black;">Actions</th> 
                                    </tr>
                                    <tr >
                                        <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>
                                    </tr>
                                </thead>

                                <tbody>
                                    @php $solde = 0; @endphp
                                    
                                    @foreach($mouvementBanques as $m)


                                        <tr>
                                            <td>{{date('d-m-Y', strtotime($m->date_enre))}}</td>
                                            <td>{{$m->libelle}}</td>
                                            <td>
                                                {{$m->type}} 
                                            </td>   

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

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


                                            @php
                                                $solde = $solde + ($m->debit - $m->credit);
                                                
                                            @endphp

                                            <td>{{number_format($solde, 0, ',', ' ') }}</td>

                                            <td align="center">
                                                <a class="btn btn-primary" href="{{ url('edit_mouv/'.$m->id) }}"><i class="fa-solid fa-pen" style="color: white;"></i></a>

                                                <a class="btn btn-danger" data-confirm="Voulez-vous vraiment supprimer cet élement ?"  href="{{ url('delete_mouv/'.$m->id) }}"><i class="fa-solid fa-trash-can" style="color: white;"></i></a>
                                            </td>
                                            
                                        </tr>
                                    @endforeach 
                                </tbody>
                            </table>
                        </div>
                    </div>
                </div>

                <div class="tab-pane fade" id="tab4" role="tabpanel" aria-labelledby="tab4-tab">
                    <div class="card">
                        <div class="card-body table-responsive">
                            <table id="caisse" class="cell-border" style="width:100%">
                                <thead>
                                    <tr>
                                        <th rowspan="2" style="text-align: center; border: solid 0.1px black;">Date</th>
                                        <th rowspan="2" width="30%" style="text-align: center; border: solid 0.1px black;">Libelle</th>
                                         <th rowspan="2" style="text-align: center; border: solid 0.1px black;">Type d'operation</th>
                                        <th colspan="2" style="text-align: center; border: solid 0.1px black;">Caisse</th>
                                        <th rowspan="2" style="text-align: center; border: solid 0.1px black;">Solde</th>

                                        <th rowspan="2" style="text-align: center; border: solid 0.1px black;">Actions</th> 
                                    </tr>
                                    <tr >
                                        <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>
                                    </tr>
                                </thead>

                                <tbody>
                                    @php $solde = 0; @endphp
                                    
                                    @foreach($mouvementCaisses as $m)


                                        <tr>
                                            <td>{{date('d-m-Y', strtotime($m->date_enre))}}</td>
                                            <td>{{$m->libelle}}</td>
                                            <td>
                                                {{$m->type}} 
                                            </td>   

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

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


                                            @php
                                                $solde = $solde + ($m->debit - $m->credit);
                                                
                                            @endphp

                                            <td>{{number_format($solde, 0, ',', ' ') }}</td>

                                            <td align="center">
                                                <a class="btn btn-primary" href="{{ url('edit_mouv/'.$m->id) }}"><i class="fa-solid fa-pen" style="color: white;"></i></a>

                                                <a class="btn btn-danger" data-confirm="Voulez-vous vraiment supprimer cet élement ?"  href="{{ url('delete_mouv/'.$m->id) }}"><i class="fa-solid fa-trash-can" style="color: white;"></i></a>
                                            </td> 
                                            
                                        </tr>
                                    @endforeach 
                                </tbody>
                            </table>
                        </div>
                    </div>
                </div>

                <div class="tab-pane fade" id="tab5" role="tabpanel" aria-labelledby="tab5-tab">
                    <div class="card">
                        <div class="card-body table-responsive">
                            <table id="vente" class="cell-border" style="width:100%">
                                <thead>
                                    <tr>
                                        <th rowspan="2" style="text-align: center; border: solid 0.1px black;">Date</th>
                                        <th rowspan="2" width="30%" style="text-align: center; border: solid 0.1px black;">Libelle</th>
                                         <th rowspan="2" style="text-align: center; border: solid 0.1px black;">Type d'operation</th>
                                        <th colspan="2" style="text-align: center; border: solid 0.1px black;">Vente</th>
                                        <th rowspan="2" style="text-align: center; border: solid 0.1px black;">Solde</th>

                                        <th rowspan="2" style="text-align: center; border: solid 0.1px black;">Actions</th> 
                                    </tr>
                                    <tr >
                                        <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>
                                    </tr>
                                </thead>

                                <tbody>
                                    @php $solde = 0; @endphp
                                    
                                    @foreach($mouvementVentes as $m)


                                        <tr>
                                            <td>{{date('d-m-Y', strtotime($m->date_enre))}}</td>
                                            <td>{{$m->libelle}}</td>
                                            <td>
                                                {{$m->type}} 
                                            </td>   

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

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


                                            @php
                                                $solde = $solde + ($m->debit - $m->credit);
                                                
                                            @endphp

                                            <td>{{number_format($solde, 0, ',', ' ') }}</td>

                                            <td align="center">
                                                <a class="btn btn-primary" href="{{ url('edit_mouv/'.$m->id) }}"><i class="fa-solid fa-pen" style="color: white;"></i></a>

                                                <a class="delete btn btn-danger" data-confirm="Voulez-vous vraiment supprimer cet élement ?"  href="{{ url('delete_mouvements/'.$m->id.'/'.$m->factures_id) }}"><i class="fa-solid fa-trash-can" style="color: white;"></i></a>
                                            </td>  
                                        </tr>
                                    @endforeach 
                                </tbody>
                            </table>
                        </div>
                    </div>
                </div>
            </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() {
            $('#ttoperation').DataTable( { 
                "ordering": false,
                dom: 'Bfrtip',
                buttons: [
                    'copyHtml5', 'csvHtml5', 'excelHtml5', 'pdfHtml5', 'printHtml5'
                ],

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

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

                responsive: true,
            } ); 
        } );
    </script> -->

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

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

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

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

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

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

    <script>
        // Activer les onglets Bootstrap
        $('#myTabs a').click(function (e) {
            e.preventDefault();
            $(this).tab('show');
        });
    </script>

    <script>
        const typeSelect = document.getElementById('typeopera');
        const qCharge = document.getElementById('qcharge');
        const charge = document.getElementById('charge');
        
        typeSelect.addEventListener('change', (event) => {
        const selectedType = event.target.value;
            if (selectedType == 4) {
                window.location.href = "{{route('list_facture')}}";
            }
        });

        qCharge.addEventListener('change', (event) => {
        const qCharge = event.target.value;
            if (qCharge == 1){
                charge.style.display = 'block';
            }else{
                charge.style.display = 'none';
            }

          });
    </script>
@endsection