public function showParcelsEventsForm(Request $request)
{
$user = $request->user;
$daterange = $request->daterange;
$dateStart = $request->dateStart;
$dateEnd = $request->dateEnd;
$events = Event::where('idUser', $user)->where('idUser', $user)->whereBetween('dateGps', [$dateStart, $dateEnd])->get();
$users = User::all();
$parcels = Parcel::all();
$parcelsGpsArray = [];
foreach ($parcels as $key => $value) {
$parcelsGps = ParcelGps::where('idparcel', $value->id)->orderBy('number')->select('lat', 'long')->get();
array_push($parcelsGpsArray, $parcelsGps);
}
// load the view and pass the parcels
return View::make('app.parcel.showevent')->with('parcels', $parcelsGpsArray)->with('events', $events)->with('users', $users)->with('user', $user);
}
