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
| // RECUPERATION DES INFOS POUR AFFICHER DATE DE DEBUT ET DATE DE FIN DANS LE DASHBOARD
$madatedeb=date_create($request->input('m_start'));
$madatedeb_fdate = $madatedeb;
$madatedeb = $madatedeb->format('Y-m-d');
$madatefin=date_create($request->input('m_end'));
//AJOUT 23h59 pour la fin du jour
$madatefin=date_add($madatefin,date_interval_create_from_date_string("23 hours"));
$madatefin=date_add($madatefin,date_interval_create_from_date_string("59 minutes"));
$madatefin_fdate = $madatefin;
$madatefin = $madatefin->format('Y-m-d');
//RECUP DES EVENEMENTS DE L'UTILISATEUR
$evenements = Evenement::where('user_id', $id_user)->where('date_debut','>=',
date('Y-m-d 00:00:00', strtotime($date_debut)))->get();
$evenementscalendar = Evenement::where('user_id', $id_user)
->where('date_debut', '>=', $madatedeb_fdate)
->where('date_fin', '<=', $madatefin_fdate)->get();
....
$data = [
'evenements' => $evenements,
'users' => $users,
'societes' => $societes,
'services' => $services,
'lst_dates' => $lst_dates,
'lst_clients_perdus' => $lst_clients_perdus,
'vendeur_code' => $vendeur_code,
'lst_vendeurs' => $lst_vendeurs,
'vendeur_recherche' => $vendeur_recherche,
'lst_commerciaux' => $lst_commerciaux,
'periode_selected' => $periode_selected,
'cde_checked' => $cde_checked,
'utilisateur_recherche' => $utilisateur_recherche,
'service_recherche' => $service_recherche,
'societe_recherche' => $societe_recherche,
'lst_users' => $users_etat,
'add_vend_gms' => $is_add_gms,
'add_vend_rhd' => $is_add_rhd,
'm_start' => $madatedeb,
'm_end' => $madatefin,
'evenementscalendar' => $evenementscalendar,
];
//Envoie la vue
return view('dashboard')->with($data); |