1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46
| public function index()
{
$resultatPeriode = DB::select('select vehicule.dateTraitement as dateTraitement,count(vehicule.Immatriculation) as totVe,sum(relier.prix) as total
from relier,vehicule,type_vehicule,traitement
where (relier.codeTraitement = vehicule.codeTraitement)
and (relier.codeTypeVehicule = vehicule.codeTypeVehicule)
and (traitement.codeTraitement = vehicule.codeTraitement)
and (type_vehicule.codeTypeVehicule = vehicule.codeTypeVehicule)
group by vehicule.dateTraitement');
//return view('vehicule.bilan',compact('resultatJour','resultatPeriode'));
$events = [];
$data = $resultatPeriode;
//dd($donne->dateTraitement)
//if($data->count() > 0){
foreach ($data as $key => $donne) {
//dd($donne->dateTraitement);
$events[] = Calendar::event(
$donne->totVe,
$donne->total,
true,
new \DateTime($donne->dateTraitement),
new \DateTime($donne->dateTraitement)
);
}
//}
$calendar = Calendar::addEvents($events);
//dd($calendar);
return view('vehicule.bilan', compact('calendar'));
} |
Partager