public function postAdd(Request $request)
{
$volunteers = \teambernieny\Volunteer::where('Email', '=', $request->Email)->get();
if (sizeof($volunteers) > 0) {
return $this->returnEdit($volunteers[0], "");
} else {
$volunteer = new \teambernieny\Volunteer();
$neighborhoods = \teambernieny\Neighborhood::select('id')->where('Name', '=', $request->Neighborhood)->get();
if (sizeof($neighborhoods) > 0) {
$neighborhood = $neighborhoods->first();
} else {
$neighborhood = new \teambernieny\Neighborhood();
$neighborhood->Name = $request->Neighborhood;
$neighborhood->Borough = $request->City;
$neighborhood->save();
}
$neighborhood_id = $neighborhood->id;
$volunteer->FirstName = $request->FirstName;
$volunteer->LastName = $request->LastName;
$volunteer->Email = $request->Email;
$volunteer->Phone = $request->Phone;
$volunteer->Zip = $request->Zip;
$volunteer->neighborhood_id = $neighborhood_id;
$volunteer->Street = $request->Street;
$volunteer->neighborhood->Borough = $request->City;
$volunteer->City = $request->City;
$volunteer->save();
return view('volunteer.check')->with('message', 'Volunteer Added');
}
}
private function checkNeighborhood(Request $request)
{
$neighborhoods = \teambernieny\Neighborhood::select('id')->where('Name', '=', $request->Neighborhood)->get();
if (sizeof($neighborhoods) > 0) {
$neighborhood = $neighborhoods->first();
$neighborhood_id = $neighborhood->id;
} else {
$neighborhood = new \teambernieny\Neighborhood();
$neighborhood->Name = $request->Neighborhood;
$neighborhood->Borough = $request->City;
$neighborhood->save();
$neighborhood_id = $neighborhood->id;
}
return $neighborhood_id;
}
private function checkNeighborhood($name, $city)
{
$neighborhoods = \teambernieny\Neighborhood::select('id')->where('Name', '=', $name)->get();
if (sizeof($neighborhoods) > 0) {
$neighborhood = $neighborhoods->first();
} else {
$neighborhood = new \teambernieny\Neighborhood();
$neighborhood->Name = $name;
$neighborhood->Borough = $city;
$neighborhood->save();
}
return $neighborhood->id;
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
$file = fopen("/uploads/20160113.csv", "r");
$line = fgets($file);
## Get the header line = Event(0),Date(1),FirstName(2),LastName(3),Gender(4),Phone(5),Zip(6),Neighborhood(7),Email(8),Street(9),City(10),State(11),HostEvent(12),AttendEvent(13),Comment(14)
while (($line = fgets($handle)) !== false) {
$data = explode(",", $line);
if ($data[0] != "") {
//check for event
$events = \teambernieny\Event::where('Name', '=', $data[0])->get();
if (sizeof($events) > 0) {
$event = $events[0];
} else {
//add if doesn't exist
$event = new \teambernieny\Event();
$event->Name = $data[0];
$event->neighborhood_id = "1";
$event->Date = "2016-01-13";
$event->save();
}
} else {
// add to migration if no event indicated
$event = \teambernieny\Event::find('1');
}
if ($data[8] != "") {
// if there is an email
$volunteers = \teambernieny\Volunteer::where('Email', '=', $data[8])->get();
} elseif ($data[5] != "") {
$volunteers = \teambernieny\Volunteer::where('Phone', '=', $data[5])->get();
} else {
continue;
}
if (sizeof($volunteers) == 0) {
$volunteer = new \teambernieny\Volunteer();
$neighborhoods = \teambernieny\Neighborhood::select('id')->where('Name', '=', $data[7])->get();
if (sizeof($neighborhoods) > 0) {
$neighborhood = $neighborhoods->first();
} else {
$neighborhood = new \teambernieny\Neighborhood();
$neighborhood->Name = $data[7];
$neighborhood->Borough = $data[10];
$neighborhood->save();
}
$volunteer->FirstName = $data[2];
$volunteer->LastName = $data[3];
$volunteer->Phone = $data[5];
$volunteer->Zip = $data[6];
$volunteer->neighborhood_id = $neighborhood->id;
$volunteer->Email = $data[8];
$volunteer->Street = $data[9];
$volunteer->City = $data[10];
$volunteer->State = $data[11];
} else {
$volunteer = $volunteers[0];
}
//Add attendance
$attendance = new \teambernieny\EventVolunteers();
$attendance->event_id = $event->id;
$attendance->volunteer_id = $volunteer->id;
$attendance->Relationship = "Attendee";
$attendance->save();
if ($data[12] == "1") {
$newcommitment = new \teambernieny\Commitment();
$newcommitment->event_volunteers_id = $attendance->id;
$newcommitment->Type = "Host";
$newcommitment->save();
}
if ($data[13] == "1") {
$newcommitment = new \teambernieny\Commitment();
$newcommitment->event_volunteers_id = $attendance->id;
$newcommitment->Type = "Attend";
$newcommitment->save();
}
}
fclose($file);
}
