public function postCheckAttendee(Request $request) { $eventvolunteers = ""; $eventvolunteers = \teambernieny\EventVolunteers::with('commitments', 'volunteer')->where('event_id', '=', $request->event_id)->get(); $event = \teambernieny\Event::find($request->event_id); if ($request->type == "Email") { if ($request->Email != "") { $volunteers = \teambernieny\Volunteer::distinct('id')->where('Email', '=', $request->Email)->get(); } } elseif ($request->type == "Phone") { if ($request->Phone != "") { $volunteers = \teambernieny\Volunteer::distinct('id')->where('Phone', '=', $request->Phone)->get(); } } if (sizeof($volunteers) > 0) { $volunteer = \teambernieny\Volunteer::with('neighborhood', 'events', 'commitments')->find($volunteers[0]->id); $eventcommitments = $volunteer->commitments; /* foreach($volunteer->events as $event){ $eventcommitments[$event->id] = \teambernieny\Commitment::where('event_id','=',$event->id)->where('volunteer_id','=',$volunteer->id)->get(); }*/ return view('volunteer.attendance.add')->with(['volunteer' => $volunteers[0], 'event' => $event, 'eventvolunteers' => $eventvolunteers]); } else { if ($request->Email == "") { $request->Email = " "; } if ($request->Phone == "") { $request->Phone = " "; } return view('volunteer.attendee.add')->with(['email' => $request->Email, 'phone' => $request->Phone, 'event' => $event, 'eventvolunteers' => $eventvolunteers]); } }
public function postSearchName(Request $request) { if ($request->type == 'Name') { if ($request->FirstName != "" && $request->LastName != "") { $volunteers = \teambernieny\Volunteer::distinct('id')->with('neighborhood')->with('contactevents')->where('FirstName', '=', $request->FirstName)->where('LastName', '=', $request->LastName)->get(); } elseif ($request->FirstName != "") { $volunteers = \teambernieny\Volunteer::distinct('id')->with('neighborhood')->with('contactevents')->where('FirstName', '=', $request->FirstName)->get(); } elseif ($request->LastName != "") { $volunteers = \teambernieny\Volunteer::distinct('id')->with('neighborhood')->with('contactevents')->where('LastName', '=', $request->LastName)->get(); } else { $volunteers = \teambernieny\Volunteer::distinct('id')->with('neighborhood')->with('contactevents')->where('FirstName', '=', $request->FirstName)->where('LastName', '=', $request->LastName)->get(); } if ($request->search_id == "") { $search = $this->saveSearch($request, "Name"); } else { $search = \teambernieny\Search::find($request->search_id); $search->save(); } } else { if ($request->type == 'Email') { $volunteers = \teambernieny\Volunteer::distinct('id')->with('neighborhood')->with('contactevents')->where('Email', '=', $request->Email)->get(); } elseif ($request->type == 'Phone') { $volunteers = \teambernieny\Volunteer::distinct('id')->with('neighborhood')->with('contactevents')->where('Phone', '=', $request->Phone)->get(); } } if ($request->search_id == "") { $search = $this->saveSearch($request, $request->type); } else { $search = \teambernieny\Search::find($request->search_id); $search->save(); } return $this->returnSearchResults($volunteers, $search->id); }