ETAT GLOBAL DES FACTURATIONS ET PAIEMENTS
GERER LE SECRETARIAT GENERAL
GSG-F07-V0
{{ $now }}
Mise à jour du :            {{ $now->format('d/m/Y') }}
@foreach ($progressStatements as $invoices) @php $subTotalH = 0; $subTotalI = 0; $subTotalJ = 0; $subTotalK = 0; $subTotalL = 0; $subTotalM = 0; $subTotalN = 0; $subTotalO = 0; $subTotalP = 0; $subTotalQ = 0; @endphp @foreach ($invoices as $index => $invoice) @php $aibValue = - $invoice->total_ht * $invoice->aib_value / 100; $amountCollected = $invoice->total_ht + $invoice->invoice_total_tax + $aibValue; $amountReceived = ($invoice->payment_date) ? $amountCollected : 0; $restAmount = $amountCollected - $amountReceived; $amountNetHt = $invoice->total_ht + $aibValue; $amountNetCollected = abs($amountReceived - $invoice->invoice_total_tax); $subTotalH += $invoice->total_ht; $subTotalI += $invoice->invoice_total_tax; $subTotalJ += $aibValue; $subTotalK += $amountNetHt; $subTotalL += $amountCollected; $subTotalM += $amountReceived; $subTotalN += $amountNetCollected; $subTotalO += $restAmount; $subTotalP += $restAmount; $subTotalQ += $restAmount; $dueDate = $invoice->due_date ? \Carbon\Carbon::parse($invoice->due_date) : \Carbon\Carbon::parse($invoice->date_receipt)->addDays(30); @endphp @if ($index === 0) @endif @endforeach @endforeach
NUMERO AFFAIRE N° FACTURE MOIS DATE FACTURATION DATE DEPOT FACTURE DATE DE REGLEMENT MONTANT BRUT HTVA TVA AIB MONTANT NET HT MONTANT NET TTC A PAYER MONTANT TTC ENCAISSE MONTANT NET HT ENCAISSE RESTANT DÛ TTC/FACTURE RESTANT DÛ RÉEL NET TTC RESTANT DÛ NET HT DELAI DE PAIEMENT
{{ $invoice->model?->project?->title }} {{ $invoice->invoice_number }} {{ $invoice->billing_month_value }} {{ \Carbon\Carbon::parse($invoice->invoice_date)->format('d/m/Y') }} {{ \Carbon\Carbon::parse($invoice->date_receipt)->format('d/m/Y') }} {{ \Carbon\Carbon::parse($invoice->payment_date)->format('d/m/Y') }} {{ number_format($invoice->total_ht, 0, '.', ' ') /*H*/}} {{ number_format($invoice->invoice_total_tax, 0, '.', ' ') /*I*/ }} {{ -number_format($aibValue, 0, '.', ' ') /*J*/}} {{ number_format($amountNetHt, 0, '.', ' ') /*K*/}} {{ number_format($amountCollected, 0, '.', ' ') /*L*/ }} {{ number_format($amountReceived, 0, '.', ' ') /*M*/}} {{ number_format($amountNetCollected, 0, '.', ' ') /*N*/}} {{ number_format($restAmount, 0, '.', ' ') /*O*/ }} {{ number_format($restAmount, 0, '.', ' ') /*P*/}} {{ number_format($restAmount, 0, '.', ' ') /*Q*/}} {{ $dueDate->format('d/m/Y') /*R*/}}
Sous total {{ $invoice->model?->project?->client?->fullname }} {{ number_format($subTotalH, 0, '.', ' ') }} {{ number_format($subTotalI, 0, '.', ' ') }} {{ number_format($subTotalJ, 0, '.', ' ') }} {{ number_format($subTotalK, 0, '.', ' ') }} {{ number_format($subTotalL, 0, '.', ' ') }} {{ number_format($subTotalM, 0, '.', ' ') }} {{ number_format($subTotalN, 0, '.', ' ') }} {{ number_format($subTotalO, 0, '.', ' ') }} {{ number_format($subTotalP, 0, '.', ' ') }} {{ number_format($subTotalQ, 0, '.', ' ') }}