ETAT GLOBAL DES FACTURATIONS ET PAIEMENTS
GERER LE SECRETARIAT GENERAL
 GSG-F07-V0
{{ $now }}
Mise à jour du :            {{ $now->format('d/m/Y') }}
@php $totalH = 0; $totalI = 0; $totalJ = 0; $totalK = 0; $totalL = 0; $totalM = 0; $totalN = 0; $totalO = 0; $totalP = 0; $totalQ = 0; $totalR = 0; $totalS = 0; @endphp @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; $subTotalR = 0; $subTotalS = 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; $amountBrutHtCollected = abs($amountReceived - $invoice->invoice_total_tax - $aibValue); $amountNetCollected = abs($amountReceived - $invoice->invoice_total_tax); $restBrut = $invoice->total_ht - $amountBrutHtCollected; $subTotalH += $invoice->total_ht; $subTotalI += $invoice->invoice_total_tax; $subTotalJ += $aibValue; $subTotalK += $amountNetHt; $subTotalL += $amountCollected; $subTotalM += $amountReceived; $subTotalN += $amountBrutHtCollected; $subTotalO += $amountNetCollected; $subTotalP += $restAmount; $subTotalQ += $restAmount; $subTotalR += $restBrut; $subTotalS += $restAmount; $totalH += $subTotalH; $totalI += $subTotalI; $totalJ += $subTotalJ; $totalK += $subTotalK; $totalL += $subTotalL; $totalM += $subTotalM; $totalN += $subTotalN; $totalO += $subTotalO; $totalP += $subTotalP; $totalQ += $subTotalQ; $totalR += $subTotalR; $totalS += $subTotalS; $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 BRUT HT ENCAISSE MONTANT NET HT ENCAISSE RESTANT DÛ TTC/FACTURE RESTANT DÛ RÉEL NET FACTURE RESTANT DÛ BRUT HT 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($amountCollected, 0, '.', ' ') /*M*/}} {{ number_format($amountBrutHtCollected, 0, '.', ' ') /*N*/ }} {{ number_format($amountNetCollected, 0, '.', ' ') /*O*/}} {{ number_format($restAmount, 0, '.', ' ') /*P*/ }} {{ number_format($restAmount, 0, '.', ' ') /*Q*/}} {{ number_format($restBrut, 0, '.', ' ')/*R*/}} {{ number_format($restAmount, 0, '.', ' ') /*S*/}} {{ $dueDate->format('d/m/Y') /*T*/}}
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, '.', ' ') }} {{ number_format($subTotalR, 0, '.', ' ')}} {{ number_format($subTotalS, 0, '.', ' ') }}
TOTAL GENERAL {{ number_format($totalH, 0, '.', ' ') }} {{ number_format($totalI, 0, '.', ' ') }} {{ number_format($totalJ, 0, '.', ' ') }} {{ number_format($totalK, 0, '.', ' ') }} {{ number_format($totalL, 0, '.', ' ') }} {{ number_format($totalM, 0, '.', ' ') }} {{ number_format($totalN, 0, '.', ' ') }} {{ number_format($totalO, 0, '.', ' ') }} {{ number_format($totalP, 0, '.', ' ') }} {{ number_format($totalQ, 0, '.', ' ') }} {{ number_format($totalR, 0, '.', ' ') }} {{ number_format($totalS, 0, '.', ' ') }}