@extends('layouts.app')


@section('content')
    <div class="card w-full">
        <div class="card-head">
            <div class="font-semibold text-cyan-900 uppercase">
                <i class="fal fa-book-open mr-1"></i>
                BALANCE EPARGNE
            </div>
            <div class="space-x-2 text-gray-500">
                <a href="{{route('jr.epargne.index', ['list'=>'on'])}}" class="hover:text-orange-500">
                    <i class="fal fa-list fa-lg"></i>
                </a>
                <a href="{{route('jr.epargne.show', $journal->id_journal)}}" class="hover:text-orange-500">
                    <i class="fal fa-book-open fa-lg"></i>
                </a>
                <a href="#" class="search text-green-500 hover:text-green-700">
                    <i class="fal fa-file-excel fa-lg"></i>
                </a>
                <a href="#" class="search hover:text-orange-500">
                    <i class="fal fa-print fa-lg"></i>
                </a>
            </div>
        </div>
        <div class="card-body">
            <x-alert/>
            <div class="flex flex-col space-y-4">
                <div class="card-content mt-3">
                    <table class="table-simple table-hover">
                        <thead>
                            <tr>
                                <th class="text-center">Agence</th>
                                <th class="text-center">Caissee</th>
                                <th class="text-center">Réf Journal</th>
                                <th class="text-center">Date</th>
                                <th class="text-left">Employé</th>
                                <th></th>
                            </tr>
                        </thead>
                        <tbody>
                            <tr class="font-bold ">
                                <td class="text-center">{{$journal->nom_agence}}</td>
                                <td class="text-center">{{$journal->id_caisse}}</td>
                                <td class="text-center">{{$journal->id_journal}}</td>
                                <td class="text-center">{{(new DateTime($journal->date_oper))->format(config('myahs')['date_format'])}}</td>
                                <td>{{$journal->nom_employe}} {{$journal->prenom_employe}}</td>
                                <td>
                                    <a href="{{route('gt.journal.show', $journal->id_journal)}}" class="text-gray-500 hover:text-orange-500" title="Afficher le journal">
                                        <i class="fal fa-search-plus fa-lg"></i>
                                    </a>
                                </td>
                            </tr>
                        </tbody>
                    </table>
                </div>
                <div class="card-content">
                    <div class="overflow-auto" style="max-height: 23rem;">
                    <table class="table table-hover table-striped">
                        <thead>
                            <tr>
                                <th>N°</th>
                                <th>N° Compte</th>
                                <th>Nom et prénoms</th>
                                <th>N° Pièce manuel</th>
                                <th>Libelle</th>
                                <th class="text-right">Solde AV</th>
                                <th class="text-right">Retrait</th>
                                <th class="text-right">Dépôt</th>
                                <th class="text-right">Solde AP</th>
                                <th></th>

                            </tr>
                        </thead>
                        <tbody>

                            @php $i = 0 @endphp

                            @foreach ($sous_totals as $sous_total)

                                @php
                                    $total_solde_av = 0;
                                    $total_solde_ap = 0;
                                    $i = 1;
                                @endphp

                                <tr>
                                    <td colspan="10" class="font-bold text-center"><span class="text-cyan-700 ">{{ $sous_total->libelle }}</span></td>
                                </tr>

                                @foreach ($operations as $operation)

                                    @if($sous_total->produit_id == $operation->produit_id)

                                        @php
                                            $i++ ;
                                            $solde_avant = $operation->solde + $operation->debit - $operation->credit;

                                            $total_solde_av += $solde_avant;
                                            $total_solde_ap += $operation->solde;

                                        @endphp

                                        <tr>
                                            <td>{{$i}}</td>
                                            <td>{{$operation->id_compte}}</td>
                                            <td>{{substr($operation->nom_tiers.' '.$operation->prenom_tiers,0,30)}}</td>
                                            <td>{{$operation->num_piece}}</td>
                                            <td>{{$operation->description}}</td>
                                            <td class="text-right">{{App\Lib\Format::number($solde_avant)}}</td>
                                            <td class="text-right">{{App\Lib\Format::number($operation->debit)}}</td>
                                            <td class="text-right">{{App\Lib\Format::number($operation->credit)}}</td>
                                            <td class="text-right">{{App\Lib\Format::number($operation->solde)}}</td>
                                            <td class="text-right">
                                                <a href="" class="mr-2" title="Afficher les écritures">
                                                    <i class="fal fa-file-spreadsheet fa-lg"></i>
                                                </a>
                                                <a href="" class="mr-2 text-gray-500 hover:text-gray-700">
                                                    <i class="fal fa-print fa-lg"></i>
                                                </a>
                                            </td>
                                        </tr>

                                    @endif

                                @endforeach

                                <tr>
                                    <td colspan="3" class="font-bold"><span class="text-cyan-700 ">SOUS-TOTAL DE {{ $sous_total->libelle }}</></td>
                                    <td colspan="2"  class="text-right font-bold">
                                        <span class="text-cyan-700 ">NOMBRE D'OPERATION : {{ $sous_total->nb_produit }}</span>
                                    </td>
                                    <td class="text-right font-bold">{{ number_format($total_solde_av, 2, ',',' ') }}</td>
                                    <td class="text-right font-bold">{{ number_format($sous_total->debit, 2, ',',' ') }}</td>
                                    <td class="text-right font-bold">{{ number_format($sous_total->credit, 2, ',',' ') }}</td>
                                    <td class="text-right font-bold">{{ number_format($total_solde_ap, 2, ',',' ') }}</td>
                                    <td></td>
                                </tr>

                            @endforeach

                            @if($i==0)
                                <tr>
                                    <td colspan="10" class="text-center">Aucun compte n'a été sélectionné</td>
                                </tr>
                            @endif
                        </tbody>
                    </table>
                    </div>
                </div>
            </div>
        </div>
    </div>
@endsection

@section('script')
    <script>

    </script>
@endsection