@extends('layout.app')

@php
$formatter = new \NumberFormatter('fr-FR', \NumberFormatter::DECIMAL);
$formatter2 = new \NumberFormatter('fr-FR', \NumberFormatter::DECIMAL);
$formatter->setAttribute(NumberFormatter::MIN_FRACTION_DIGITS, 2);
$formatter->setAttribute(NumberFormatter::MAX_FRACTION_DIGITS, 2);
$formatter2->setAttribute(NumberFormatter::MAX_FRACTION_DIGITS, 1);
$formatter->setAttribute(NumberFormatter::GROUPING_SIZE, 3);
$formatter->setSymbol(NumberFormatter::GROUPING_SEPARATOR_SYMBOL, ' ');
$mois = \Carbon\Carbon::parse($paie->mois->mois);
$finMois = $mois->copy()->endOfMonth()->format('d/m/Y');
$nrows = 0;
@endphp
@section('content')
<div class="max-w-5xl mx-auto border border-base-200 bg-white p-9 shadow-sm">
    <div class="w-48 mx-auto p-1 mb-1 border border-black bg-base-200 text-center font-bold">BULLETIN DE PAIE</div>
    <div class="mb-1 text-center uppercase italic">Pour faire valoir vos droits, conservez ce bulletin sans limitation de durée</div>
    <div class="grid grid-cols-1 md:grid-cols-3 border border-black">
        <div class="p-2">
            <div class="px-1 font-bold">EMPLOYEUR</div>
            <img src="/img/cesa.png" alt="" width="250" class="mx-auto" />
            <table>
                <tr>
                    <td>Lot III S 307 K Madera Namontana</td>
                </tr>
                <tr>
                    <td>Antananarivo 101</td>
                </tr>
                <tr>
                    <td>Stat 64 10 2112 006 010 699</td>
                </tr>
                <tr>
                    <td>NIF 3000150589</td>
                </tr>
            </table>
        </div>
        <div class="p-2 space-y-1 md:col-span-2">
            <div class="px-1 font-bold">EMPLOYÉ</div>
            <table class="table-paie">
                <tr>
                    <td class="w-1/5"><strong>Matricule :</strong></td>
                    <td class="text-xl">{{ $paie->employe->matricule }}</td>
                    <td class="w-1/5"><strong>N° CNaPS :</strong></td>
                    <td>{{ $paie->employe->cnaps }}</td>
                </tr>
                <tr>
                    <td><strong>Nom :</strong></td>
                    <td colspan="3">{{ $paie->employe->nom }}</td>
                </tr>
                <tr>
                    <td><strong>Prénom :</strong></td>
                    <td colspan="3">{{ $paie->employe->prenom }}</td>
                </tr>
                <tr>
                    <td><strong>Adresse :</strong></td>
                    <td colspan="3">{{ $paie->employe->adresse }}</td>
                </tr>
                <tr>
                    <td><strong>Fonction :</strong></td>
                    <td colspan="3">{{ $paie->employe->fonction->nom }}</td>
                </tr>
                <tr>
                    <td><strong>Qualification :</strong></td>
                    <td colspan="3">{{ $paie->employe->grille->nom }}</td>
                </tr>
                <tr>
                    <td><strong>Ancienneté (ans) :</td>
                    <td>{{ $paie->anciennete ? $paie->anciennete[0] : '' }} {{ $paie->anciennete && $paie->anciennete[0] > 1 ? 'ans' : 'an' }}</td>
                    <td><strong>Date d'embauche :</strong></td>
                    <td>{{ \Carbon\Carbon::parse($paie->employe->date_embauche)->format('d/m/Y') }}</td>
                </tr>
                <tr>
                    <td></td>
                    <td>{{ $paie->anciennete ? $paie->anciennete[1] : '' }} mois</td>
                    <td><strong>Enfants à charge :</strong></td>
                    <td>{{ $paie->employe->enfants }}</td>
                </tr>
            </table>
        </div>
    </div>
    <table class="table-paie border-l border-r border-black">
        <tr>
            <td class="w-1/4"><strong>Paie du :</strong> {{ $mois->copy()->startOfMonth()->format('d/m/Y') }}</td>
            <td class="w-1/4"><strong>au :</strong> {{ $finMois }}</td>
            <td class="w-1/4"><strong>Date de paie :</strong> {{ $finMois }}</td>
            <td class="w-1/4"><strong>Mode de paiement :</strong> {{ $paie->banque ? 'Virement' : 'Espèces' }}</td>
        </tr>
    </table>
    <table class="table-paie half-bordered">
        <thead>
            <tr>
                <th rowspan="2">Désignation</th>
                <th rowspan="2">Nombre ou Base</th>
                <th colspan="3">Part salariale</th>
                <th colspan="2">Part patronale</th>
            </tr>
            <tr>
                <th>Taux Salar</th>
                <th>Gains</th>
                <th>Ret. Sal</th>
                <th>Taux Pat</th>
                <th>Ret. Pat</th>
            </tr>
        </thead>
        <tbody>
            <tr>
                <td class="w-[30%]">Salaire mensuel</td>
                <td class="w-[15%] text-right">{{ $formatter->format($paie->salaire_base / $paie->mois->nombre_jours) }}</td>
                <td class="w-[5%] text-center">{{ $paie->mois->nombre_jours }}</td>
                <td class="w-[15%] text-right">{{ $formatter->format($paie->salaire_base) }}</td>
                <td class="w-[15%]"></td>
                <td class="w-[5%]"></td>
                <td class="w-[15%]"></td>
            </tr>
            @if($paie->prime_anciennete > 0)
            <tr>
                <td>Prime d'ancienneté</td>
                <td class="text-right">{{ $formatter->format($paie->salaire_base) }}</td>
                <td class="text-center">{{ $formatter->format($paie->prime_anciennete / $paie->salaire_base) }}</td>
                <td class="text-right">{{ $formatter->format($paie->prime_anciennete) }}</td>
                <td></td>
                <td></td>
                <td></td>
            </tr>
            @endif
            @if($paie->heures_dimanche > 0)
            <tr>
                <td>Majoration dimanche</td>
                <td class="text-right">{{ $formatter->format($paie->majoration_dimanche / $paie->heures_dimanche) }}</td>
                <td class="text-center">{{ $paie->heures_dimanche }}</td>
                <td class="text-right">{{ $formatter->format($paie->majoration_dimanche) }}</td>
                <td></td>
                <td></td>
                <td></td>
            </tr>
            @endif
            @if($paie->heures_nuit > 0)
            <tr>
                <td>Majoration de nuit</td>
                <td class="text-right">{{ $formatter->format($paie->majoration_nuit / $paie->heures_nuit) }}</td>
                <td class="text-center">{{ $paie->heures_nuit }}</td>
                <td class="text-right">{{ $formatter->format($paie->majoration_nuit) }}</td>
                <td></td>
                <td></td>
                <td></td>
            </tr>
            @endif
            @if ($paie->indemnite_logement > 0)
            <tr>
                <td>Indemnité de logement</td>
                <td class="text-right"></td>
                <td class="text-center"></td>
                <td class="text-right">{{ $formatter->format($paie->indemnite_logement) }}</td>
                <td></td>
                <td></td>
                <td></td>
            </tr>
            @endif
            @if ($paie->indemnite_electricite > 0)
            <tr>
                <td>Indemnité d'électricité</td>
                <td class="text-right"></td>
                <td class="text-center"></td>
                <td class="text-right">{{ $formatter->format($paie->indemnite_electricite) }}</td>
                <td></td>
                <td></td>
                <td></td>
            </tr>
            @endif
            @if(floatval($paie->rappels) > 0)
            @foreach ($paie->rappels_details as $rappel)
            <tr>
                <td>{{ $rappel['libelle'] }}</td>
                <td class="text-right">{{ $formatter->format($rappel['montant']) }}</td>
                <td></td>
                <td class="text-right">{{ $formatter->format($rappel['montant']) }}</td>
                <td></td>
                <td></td>
                <td></td>
            </tr>
            @endforeach
            @endif
            @if ($paie->avance_special > 0)
            <tr>
                <td>Avance spéciale</td>
                <td class="text-right"></td>
                <td class="text-center"></td>
                <td></td>
                <td class="text-right">{{ $formatter->format($paie->avance_special) }}</td>
                <td></td>
                <td></td>
            </tr>
            @endif
            @if ($paie->avance_quinzaine > 0)
            <tr>
                <td>Avance 15</td>
                <td class="text-right"></td>
                <td class="text-center"></td>
                <td></td>
                <td class="text-right">{{ $formatter->format($paie->avance_quinzaine) }}</td>
                <td></td>
                <td></td>
            </tr>
            @endif
            @if ($paie->retenue_absence > 0)
            <tr>
                <td>Retenue sur absences</td>
                <td class="text-right"></td>
                <td class="text-center"></td>
                <td></td>
                <td class="text-right">{{ $formatter->format($paie->retenue_absence) }}</td>
                <td></td>
                <td></td>
            </tr>
            @endif
            @if ($paie->retenue_retard > 0)
            <tr>
                <td>Avance 15</td>
                <td class="text-right"></td>
                <td class="text-center"></td>
                <td></td>
                <td class="text-right">{{ $formatter->format($paie->retenue_retard) }}</td>
                <td></td>
                <td></td>
            </tr>
            @endif
            @if ($paie->retenues > 0)
            @foreach ($paie->retenues_details as $retenue)
            <tr>
                <td>{{ $retenue['libelle'] }}</td>
                <td></td>
                <td></td>
                <td></td>
                <td class="text-right">{{ $formatter->format($retenue['montant']) }}</td>
                <td></td>
                <td class="text-right">{{ $formatter->format($retenue['montant']) }}</td>
            </tr>
            @endforeach
            @endif
            @if ($paie->cnaps_salarie > 0)
            <tr>
                <td>Cotisation CNaPS</td>
                <td class="text-right">{{ $formatter->format($paie->salaire_brut) }}</td>
                <td class="text-center">{{ $formatter->format(floatval($paie->mois->parametres['t_cnaps_sal']) * 100) }}</td>
                <td class="text-right">{{ $formatter->format($paie->cnaps_salarie) }}</td>
                <td></td>
                <td class="text-center">{{ $formatter->format(floatval($paie->mois->parametres['t_cnaps_pat']) * 100) }}</td>
                <td class="text-right">{{ $formatter->format($paie->cnaps_patron) }}</td>
            </tr>
            @endif
            @if ($paie->ostie_salarie > 0)
            <tr>
                <td>Cotisation OSIE</td>
                <td class="text-right">{{ $formatter->format($paie->salaire_brut) }}</td>
                <td class="text-center">{{ $formatter->format(floatval($paie->mois->parametres['t_ostie_sal']) * 100) }}</td>
                <td class="text-right">{{ $formatter->format($paie->ostie_salarie) }}</td>
                <td class="text-right"></td>
                <td class="text-center">{{ $formatter->format(floatval($paie->mois->parametres['t_ostie_pat']) * 100) }}</td>
                <td class="text-right">{{ $formatter->format($paie->ostie_patron) }}</td>
            </tr>
            @endif
            @if ($paie->irsa_declare > 0)
            <tr>
                <td>IRSA</td>
                <td class="text-right">{{ $formatter->format($paie->irsa_declare) }}</td>
                <td class="text-center">100</td>
                <td class="text-right">{{ $formatter->format($paie->irsa_declare) }}</td>
                <td></td>
                <td></td>
                <td></td>
            </tr>
            @endif
            @for ($i = $paie->nombre_lignes; $i < 20; $i++) <tr>
                <td>&nbsp;</td>
                <td></td>
                <td></td>
                <td></td>
                <td></td>
                <td></td>
                <td></td>
                </tr>
                @endfor
        </tbody>
    </table>

    <div class="flex flex-row w-full mt-4 gap-9">
        <div class="w-2/3">
            <table class="table-paie bordered">
                <tr class="font-bold">
                    <td class="w-1/2 text-center">Situation de congés</td>
                    <td class="w-1/4 text-center">Congés pris</td>
                    <td class="w-1/4 text-center">Solde</td>
                </tr>
                <tr>
                    <td class="text-center">{{ $formatter2->format($paie->conges + $paie->jours_conges) }}</td>
                    <td class="text-center">{{ $formatter2->format($paie->jours_conges) }}</td>
                    <td class="text-center">{{ $formatter2->format($paie->conges) }}</td>
                </tr>
            </table>
        </div>
        <div class="w-1/3">
            <div class="flex flex-row justify-between">
                <div class="font-bold text-lg">Net à payer :</div>
                <div class="font-bold text-lg">{{ $formatter->format($paie->salaire_net) }}</div>
            </div>
        </div>
    </div>

    <div class="mt-6 p-2 border border-black">
        <div class="mb-1">Antananarivo, le {{ today()->format('d/m/Y') }}</div>
        <div class="grid grid-cols-1 md:grid-cols-2">
            <div class="h-32 text-center">
                L'employeur
            </div>
            <div class="flex flex-col justify-between text-center">
                <div>Le salarié</div>
                <div>{{ $paie->employe->full_name }}</div>
            </div>
        </div>
    </div>
</div>
@endsection