@extends(empty($main) ? 'credits.main' : $main)

@section('content')
    <div class="w-full">
        <div class="card-head">
            <div class="font-semibold text-cyan-900 uppercase">
                <i class="fal fa-list mr-1"></i>
                Suivi quotidien de remboursement
            </div>
            <div class="space-x-2">
                <a href="{{route('cd.suivi-remb.export')}}" class="search text-green-600 hover:text-green-500" title="Télécharger au format CSV">
                    <i class="fal fa-file-excel fa-lg"></i>
                </a>
                {{-- <a href="#" class="search">
                    <i class="fal fa-print"></i>
                </a> --}}
            </div>
        </div>
        <div class="card-body">
            <x-alert/>
            <div class="flex justify-end">
                <form method="post" action="{{route('cd.suivi-remb.search')}}" class="w-full">
                    @csrf
                    <div class="flex justify-end space-x-3 w-full">
                        <div class="flex items-center w-36">
                            <select name="caisse" class="form-control">
                                @php $id_caisse = !empty($search->caisse) ? $search->caisse : '' @endphp
                                <option value="">-- CAISSE --</option>
                                @foreach ($caisses as $caisse)
                                    <option value="{{ $caisse->id_caisse }}" {{ $caisse->id_caisse == $id_caisse ? 'selected' : '' }} >
                                        {{ $caisse->id_caisse }}
                                    </option>
                                @endforeach
                            </select>
                        </div>
                        <div class="flex items-center space-x-2 w-48">
                            <input type="date" name="date_debut" value="{{ !empty($search->date_debut) ? $search->date_debut : date('Y-m-01') }}" class="form-control"/>
                        </div>
                        <div class="flex items-center space-x-2 w-48">
                            <input type="date" name="date_fin" value="{{ !empty($search->date_fin) ? $search->date_fin : date('Y-m-d') }}" class="form-control" />
                        </div>
                        <div>
                            <button type="submit" class="btn btn-warning">
                                <i class="fal fa-search"></i>
                            </button>
                        </div>
                    </div>
                </form>
            </div>
            <div class="card-content mt-3">
                <table class="table table-striped table-hover">
                    <thead>
                        <tr class="bg-gray-500 text-gray-200">
                            <th class="border-gray-400"></th>
                            <th colspan="3" class="text-center border-r border-gray-400">IDENTIFICATION DU PRET</th>
                            <th colspan="3" class="text-center border-r border-gray-400">PREVISION</th>
                            <th colspan="4" class="text-center border-gray-400">REALISATION</th>
                            <th class="border-gray-400"></th>
                        </tr>
                        <tr>
                            <th>#</th>
                            <th class="text-center">ID Tiers</th>
                            <th class="text-center">Réf de prêt</th>
                            <th>Nom et prénoms</th>
                            <th class="text-center">Date</th>
                            <th class="text-right">Capital</th>
                            <th class="text-right">Intérêt</th>
                            <th class="text-center">Date</th>
                            <th class="text-right">Capital</th>
                            <th class="text-right">Intérêt</th>
                            <th class="text-right">Ecart</th>
                            <th></th>
                        </tr>
                    </thead>
                    <tbody>
                        @php
                            $i = 0;
                        @endphp
                        @if(count($echeanciers )>0)
                            @foreach ($echeanciers  as $echeancier)
                                @php

                                    $i++;

                                    $mtt_diff =  $echeancier->cumul_remb - $echeancier->remb_reel;

                                    // $part_capital = ($mtt_diff + $echeancier->capital) > 0 ? ($mtt_diff + $echeancier->capital) : 0;
                                    $part_capital = $mtt_diff > 0 ? $mtt_diff : 0;

                                    $encours = $echeancier->debit - $echeancier->credit;

                                    $interet = \App\Lib\Echeancier::interet($encours,
                                                $echeancier->date_dernier_oper,
                                                $echeancier->date_oper,
                                                $echeancier->taux_interet);

                                    $mtt_payer = $part_capital + $interet;

                                    $mtt_encaisse =  $echeancier->remb_capital + $echeancier->remb_interet;

                                    $ecart = $mtt_encaisse - $mtt_payer;

                                @endphp
                                <tr>
                                    <td>
                                        <x-line-number :item="$i" :nombre="$per_page"></x-line-number>
                                    </td>
                                    <td class="text-center">{{ $echeancier->tiers_id}}</td>
                                    <td class="text-center">{{ $echeancier->id_pret}}</td>
                                    <td>{{ substr($echeancier->nom_tiers.' '.$echeancier->prenom_tiers, 0,40) }}</td>
                                    <td class="text-center">{{ (new DateTime($echeancier->date_oper))->format(config('myahs.date_format')) }}</td>
                                    <td class="text-right">{{ number_format($part_capital,2,',',' ') }}</td>
                                    <td class="text-right">{{ number_format($interet,2,',',' ') }}</td>
                                    <td class="text-center">{{ (new DateTime($echeancier->date_dernier_remb))->format('d/m/Y') }}</td>
                                    <td class="text-right">{{ number_format($echeancier->remb_capital,2,',',' ') }}</td>
                                    <td class="text-right">{{ number_format($echeancier->remb_interet,2,',',' ') }}</td>
                                    <td class="text-right">
                                        @if($ecart < 0)
                                            <span class="text-red-500">({{ number_format($ecart,2,',',' ') }})</span>
                                        @else
                                            <span class="text-green-600">{{ number_format($ecart,2,',',' ') }}</span>
                                        @endif
                                    </td>
                                    <td class="text-right">
                                        <a href="{{route('cd.contrat.show', $echeancier->id_pret)}}" title="Contrat de prêt" class="mr-2">
                                            <i class="fal fa-file-certificate  fa-lg"></i>
                                        </a>
                                        <a href="{{route('cd.calendrier.show', $echeancier->id_pret)}}" title="Contrat de prêt" class="mr-2">
                                            <i class="fal fa-calendar-alt  fa-lg"></i>
                                        </a>
                                        <a href="{{route('cd.fiche.show', $echeancier->id_pret)}}" title="Fiche de prêt">
                                            <i class="fal fa-file-spreadsheet fa-lg"></i>
                                        </a>
                                    </td>
                                </tr>
                            @endforeach
                        @else
                            <tr>
                                <td colspan="12" class="text-center">
                                    La liste est vide.
                                </td>
                            </tr>
                        @endif
                        {{-- <tr class="font-bold">
                            <td colspan="6" class="text-right">TOTAL</td>
                            <td class="text-right">{{ number_format(!empty($sum_remb->debit)?$sum_remb->credit:0,2,',',' ') }}</td>
                            <td class="text-right">{{ number_format(!empty($sum_remb->credit)?$sum_remb->credit:0,2,',',' ') }}</td>
                            <td class="text-right">{{ number_format(!empty($sum_remb->interet)?$sum_remb->interet:0,2,',',' ') }}</td>
                            <td class="text-right">{{ number_format(!empty($sum_remb->penalite)?$sum_remb->penalite:0,2,',',' ') }}</td>
                            <td></td>
                        </tr> --}}
                    </tbody>
                </table>
            </div>
            <div class="flex justify-between mt-3">
                <div></div>
                @if(!empty($echeanciers))
                    <div class="pagination">
                        {{ $echeanciers->links() }}
                    </div>
                @endif
            </div>
        </div>
    </div>
@endsection