@php $data = []; $pricet = 0; $total_prix_estime = 0; // Calculate the total budget from articles and ouvrier data foreach ($articles_chantiers as $art) { foreach ($ch_ar_mt_fr as $row) { if ($row->article_chantier_id == $art->id && $art->chantier_id == $chantier->id) { $pricet += $row->prix * $row->qte; // price * quantity from a different dataset } } } // Adding salaries for workers based on days worked foreach ($ouvrier_chantiers as $ouvrier_chantier) { $startDate = \Carbon\Carbon::parse($ouvrier_chantier->pivot->date_debut); $endDate = \Carbon\Carbon::parse($ouvrier_chantier->pivot->date_fin); $daysWorked = $endDate->diffInDays($startDate); $totalPrice = $daysWorked * $ouvrier_chantier->salaire_journalier; $pricet += $totalPrice; } // Calculate the total estimated price for articles in the current chantier foreach ($articles_chantiers as $art) { if ($art->chantier_id == $chantier->id) { $total_prix_estime += $art->prix_estime; } } @endphp