@foreach ($depensesGroupedByMonthAndCategory as $month => $categories)
{{ \Carbon\Carbon::parse($month . '-01')->locale('fr')->isoFormat('MMMM YYYY') }}
@foreach ($categories as $category => $expenses)
@if($category == 'personnel')
Personnel
| Nom |
Prénom |
Heures travaillées |
Coût horaire |
Zone |
Total |
Date |
@foreach ($expenses as $expense)
@php
$depenseDetails = $expense->depensePersonnel;
$personnel = $depenseDetails->personnel;
$totalCost = $depenseDetails->heures_travaillees * $personnel->taux_horaire;
@endphp
| {{ $personnel->nom }} |
{{ $personnel->prenom }} |
{{ $depenseDetails->heures_travaillees }} |
{{ $personnel->taux_horaire }} |
{{ $depenseDetails->zone_id ? $depenseDetails->zone_price : 'N/A' }} |
{{ number_format($totalCost, 2) }} € |
{{ \Carbon\Carbon::parse($expense->date)->format('d/m/Y') }} |
@endforeach
@elseif($category == 'materiel')
Matériel
| Description |
Coût |
Quantité |
Total |
Date |
@foreach ($expenses as $expense)
@php
$depenseDetails = $expense->depenseMateriel;
$totalCost = $depenseDetails->cout * $depenseDetails->quantite;
@endphp
| {{ $expense->description }} |
{{ $depenseDetails->cout }} |
{{ $depenseDetails->quantite }} |
{{ number_format($totalCost, 2) }} € |
{{ \Carbon\Carbon::parse($expense->date)->format('d/m/Y') }} |
@endforeach
@elseif($category == 'fournitures')
Fournitures
| Nom du bien |
Description |
Coût |
Quantité |
Total |
Date |
@foreach ($expenses as $expense)
@php
$depenseDetails = $expense->depenseFourniture;
$totalCost = $depenseDetails->cout * $depenseDetails->quantite;
@endphp
| {{ $depenseDetails->bien->libelle }} |
{{ $expense->description }} |
{{ $depenseDetails->cout }} |
{{ $depenseDetails->quantite }} |
{{ number_format($totalCost, 2) }} € |
{{ \Carbon\Carbon::parse($expense->date)->format('d/m/Y') }} |
@endforeach
@elseif($category == 'location')
Location
| Fournisseur |
Catégorie de location |
Prix |
Quantité |
Total |
Description |
Date |
@foreach ($expenses as $expense)
@php
$depenseDetails = $expense->depensesLocation;
$totalCost = $depenseDetails->prix * $depenseDetails->quantite;
@endphp
| {{$depenseDetails->fournisseur->nom}} |
{{$depenseDetails->categorie->libelle}} |
{{ $depenseDetails->prix }} |
{{ $depenseDetails->quantite }} |
{{ number_format($totalCost, 2) }} € |
{{ $expense->description }} |
{{ \Carbon\Carbon::parse($expense->date)->format('d/m/Y') }} |
@endforeach
@elseif($category == 'soustraitant')
Sous-traitant
| Nom du prestataire |
Description |
Prix |
Date |
@foreach ($expenses as $expense)
@php
$depenseDetails = $expense->depensesSousTraitant;
@endphp
| {{ $depenseDetails->sous_traitant->nom }} |
{{ $expense->description }} |
{{ number_format($depenseDetails->prix, 2) }} € |
{{ \Carbon\Carbon::parse($expense->date)->format('d/m/Y') }} |
@endforeach
@endif
@endforeach
@endforeach
Résumé des dépenses
| Catégorie |
Total Coût |
@php
$totalCosts = [
'fournitures' => 0,
'materiel' => 0,
'personnel' => 0,
'location' => 0,
'soustraitant' => 0
];
@endphp
@foreach ($depensesGroupedByMonthAndCategory as $categories)
@foreach ($categories as $category => $expenses)
@foreach ($expenses as $expense)
@if($category == 'fournitures')
@php
$depenseDetails = $expense->depenseFourniture;
$totalCosts[$category] += $depenseDetails->cout * $depenseDetails->quantite;
@endphp
@elseif($category == 'materiel')
@php
$depenseDetails = $expense->depenseMateriel;
$totalCosts[$category] += $depenseDetails->cout * $depenseDetails->quantite;
@endphp
@elseif($category == 'personnel')
@php
$depenseDetails = $expense->depensePersonnel;
$personnel = $depenseDetails->personnel;
$totalCosts[$category] += $depenseDetails->heures_travaillees * $personnel->taux_horaire;
@endphp
@elseif($category == 'location')
@php
$depenseDetails = $expense->depensesLocation;
$totalCosts[$category] += $depenseDetails->cout * $depenseDetails->quantite;
@endphp
@elseif($category == 'soustraitant')
@php
$depenseDetails = $expense->depensesSousTraitant;
$totalCosts[$category] += $depenseDetails->prix;
@endphp
@endif
@endforeach
@endforeach
@endforeach
@foreach ($totalCosts as $category => $totalCost)
| {{ ucfirst($category) }} |
{{ number_format($totalCost, 2) }} € |
@endforeach
@php
$totalExpenses = array_sum($totalCosts);
$projectProfit = $chantier->montant_vendu - $totalExpenses;
@endphp
Total des dépenses : {{ number_format($totalExpenses, 2) }} €
Profit du projet : {{ number_format($projectProfit, 2) }} €
Le projet est {{ $projectProfit >= 0 ? 'rentable' : 'non rentable' }}.