@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 mr-1"></i>
            Grand livre
        </div>
        <div class="text-gray-500">
            <a href="{{route('cp.grdlibre.index')}}" class=" hover:text-orange-500 mr-2">
                <i class="fal fa-list fa-lg"></i>
            </a>
            {{-- <a href="" class=" hover:text-orange-500 mr-2">
                <i class="fal fa-print fa-lg"></i>
            </a> --}}
            <a href="{{route('cp.grdlivre.export', $plan_compte->id_compte)}}" class=" text-green-600 hover:text-orange-500">
                <i class="fal fa-file-excel fa-lg"></i>
            </a>
        </div>
    </div>
    <div class="card-body">
        <x-alert></x-alert>

        <div class="flex justify-end mb-2 card-content">

            @php
            
                $mvtDebut = !empty($sumGrandLivre->debit)?$sumGrandLivre->debit:0;

                $mvtCredit = !empty($sumGrandLivre->credit)?$sumGrandLivre->credit:0;              

                $mtt_report = 0;

                if(!empty($report->compte_id)){
                    $mtt_report = $report->debit - $report->credit;
                }

                $soldeMvt = $mtt_report + $mvtDebut - $mvtCredit;

                if($plan_compte->classe == 'result' && substr($plan_compte->id_compte,0,1) == '7'){
                    $mtt_report = -1*$mtt_report;
                    $soldeMvt = -1*$soldeMvt;
                }

                if($plan_compte->classe == 'passif'){
                        $mtt_report = -1*$mtt_report;
                        $soldeMvt = -1*$soldeMvt;
                }

            @endphp

            <table class="table">
                <tr class="font-semibold">
                    <td>N° compte</td>
                    <td>Libellé</td>
                    <td>Mvt débit</td>
                    <td>Mvt crédit</td>
                    <td>Solde</td>
                </tr>
                <tr class="font-bold uppercase">
                    <td>{{$plan_compte->id_compte}}</td>
                    <td>{{$plan_compte->libelle_compte}}</td>
                    <td>{{App\Lib\Format::number($mvtDebut)}}</td>
                    <td>{{App\Lib\Format::number($mvtCredit)}}</td>
                    <td>{{App\Lib\Format::number($soldeMvt)}}</td>
                </tr>
            </table>
        </div>
        <div class="mb-2">
            <form method="post" action="{{route('cp.grdlibre.search')}}" class="w-full">
                @csrf
                <input type="hidden" name="compteId" value="{{$plan_compte->id_compte}}">
                <div class="flex justify-end space-x-3 w-full">
                    <div class="flex items-center w-64">
                        <select name="codeAnalytique" class="form-control">
                            @php $id_analytique = !empty($search->codeAnalytique) ? $search->codeAnalytique : '' @endphp
                            <option value="">-- CODE ANALYTIQUE --</option>
                            @foreach ($code_analytiques as $code_analytique)
                                <option value="{{ $code_analytique->id_analytique }}" {{ $code_analytique->id_analytique == $id_analytique ? 'selected' : '' }} >
                                    {{ $code_analytique->id_analytique }}
                                </option>
                            @endforeach
                        </select>
                    </div>
                    <div class="flex items-center space-x-2 w-48">
                        <input type="date" name="dateDebut" value="{{ !empty($search->dateDebut) ? $search->dateDebut : date('Y-m-01') }}" class="form-control"/>
                    </div>
                    <div class="flex items-center space-x-2 w-48">
                        <input type="date" name="dateFin" value="{{ !empty($search->dateFin) ? $search->dateFin : 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">

            <table class="table table-hove">
                <thead>
                    <tr class="">
                        <th style="width: 5%">#</th>
                        <th class="text-left" style="width: 5%">Date</th>
                        <th class="text-left" style="width: 10%">Code</th>
                        <th style="width: 5%">Psce</th>
                        <th class="text-left" style="width: 10%">Réf journal</th>
                        <th class="text-left">Libellé</th>
                        <th class="text-right" style="width: 10%">Débit</th>
                        <th class="text-right" style="width: 10%">Crédit</th>
                        <th class="text-right" style="width: 10%">
                            <span class="block px-4">Solde</span>
                        </th>
                        <th style="width: 5%"></th>
                    </tr>
                </thead>
                <tbody>
                    <tr>
                        <td colspan="10"></td>
                    </tr>
                </tbody>
            </table>
            <div class="overflow-auto" style="max-height: 20rem;">
                <table class="table table-hover table-striped">
                    <tbody style="vertical-align: top;">

                        @php

                            $cumul_debit = 0;
                            $cumul_credit = 0;
                            $solde = 0;
                            $i=0;

                        @endphp

                        @if($mtt_report != 0)

                            <tr>
                                <tr>
                                    <td colspan="8" class="font-bold text-right">
                                        <span class=" text-orange-700">REPORT DE SOLDE</span>
                                    </td>
                                    <td class="text-right font-bold" style="width: 10%">
                                        <span class=" text-orange-700">{{App\Lib\Format::number($mtt_report)}}</span>
                                    </td>
                                    <td></td>
                                </tr>
                            </tr>
                        @endif

                        @foreach ($ecritures as $ecriture)
                            @php
                                $cumul_debit += $ecriture->debit;

                                $cumul_credit += $ecriture->credit;

                                $variation = $cumul_debit - $cumul_credit;

                                if($plan_compte->classe == 'result' && substr($plan_compte->id_compte,0,1) == '7'){
                                    $variation = -1*$variation;
                                }

                                if($plan_compte->classe == 'passif'){
                                    $variation = -1*$variation;
                                }

                                $solde = $variation + $mtt_report;

                                $i++;


                            @endphp
                            <tr>
                                <td style="width: 5%">{{$i}}</td>
                                <td class="text-left" style="width: 5%">{{(new DateTime($ecriture->date_oper))->format(config('myahs')['date_format'])}}</td>
                                <td class="text-left" style="width: 10%">{{$ecriture->code_analytique}}</td>
                                <td class="text-left" style="width: 5%">{{$ecriture->caisse_id}}</td>
                                <td class="text-left" style="width: 10%">{{$ecriture->id_journal}}</td>
                                <td class="text-left">{{mb_strtoupper($ecriture->libelle,'UTF-8')}}</td>
                                <td class="text-right" style="width: 10%">{{App\Lib\Format::number($ecriture->debit)}}</td>
                                <td class="text-right" style="width: 10%">{{App\Lib\Format::number($ecriture->credit)}}</td>
                                <td class="text-right" style="width: 10%">
                                    @if($solde >= 0)
                                        {{App\Lib\Format::number($solde)}}
                                    @else
                                        <span class="text-red-500">({{App\Lib\Format::number($solde)}})</span>
                                    @endif
                                </td>
                                <td class="text-right" style="width: 5%">
                                    <a href="{{route('cp.ecriture.show', $ecriture->id_journal)}}" class="text-gray-500 hover:text-orange-500 mr-2">
                                        <i class="fal fa-book-open fa-lg"></i>
                                    </a>
                                </td>
                            </tr>
                        @endforeach
                    </tbody>
                </table>
            </div>
            {{-- <table class="table">
                <tr>
                    <td colspan="3" class="text-right font-bold">TOTAL</td>
                    <td class="text-right font-bold" style="width: 15%">{{App\Lib\Format::number($sum_debit)}}</td>
                    <td class="text-right font-bold" style="width: 15%">{{App\Lib\Format::number($sum_credit)}}</td>
                    <td style="width: 5%"></td>
                </tr>
            </table> --}}
        </div>
    </div>
</div>
@endsection