public function run() { $volunteers = \teambernieny\VDBVolunteer::all(); //Top ten data conversion for now for ($x = 0; $x < sizeof($volunteers); $x++) { $volunteer = $volunteers[$x]; //clean out the 999s $volunteer = $this->validate($volunteer); //add neighborhood if doesn't exist $neighborhoods = \teambernieny\Neighborhood::where('Name', '=', $volunteer->Neighborhood)->get(); if (sizeof($neighborhoods) == 0 && $volunteer->Neighborhood != "") { DB::table('neighborhoods')->insert(['created_at' => Carbon\Carbon::now()->toDateTimeString(), 'updated_at' => Carbon\Carbon::now()->toDateTimeString(), 'Name' => $volunteer->Neighborhood, 'Borough' => $volunteer->City]); $neighborhood_id = \teambernieny\Neighborhood::max('id'); } else { if ($volunteer->Neighborhood == "") { $neighborhood_id = "1"; } else { $neighborhood_id = $neighborhoods[0]->id; } } // add volunteer DB::table('volunteers')->insert(['created_at' => Carbon\Carbon::now()->toDateTimeString(), 'updated_at' => Carbon\Carbon::now()->toDateTimeString(), 'FirstName' => $volunteer->FirstName, 'LastName' => $volunteer->LastName, 'Email' => $volunteer->EMail1, 'Phone' => $volunteer->Phone1, 'neighborhood_id' => $neighborhood_id, 'Zip' => $volunteer->Zip, 'Street' => $volunteer->Street, 'City' => $volunteer->City, 'State' => $volunteer->State, 'user_id' => "1", 'BadPhone' => $volunteer->Phone1Broken, 'BadEmail' => $volunteer->Email1Broken, 'DoNotContact' => $volunteer->DoNotContact]); $volunteerid = \teambernieny\Volunteer::max('id'); DB::table('event_volunteers')->insert(['created_at' => Carbon\Carbon::now()->toDateTimeString(), 'updated_at' => Carbon\Carbon::now()->toDateTimeString(), 'event_id' => '1', 'volunteer_id' => $volunteerid, 'Relationship' => 'Attendee']); $eventvolunteers_id = \teambernieny\EventVolunteers::max('id'); if ($volunteer->AttendEvent == "1") { DB::table('commitments')->insert(['created_at' => Carbon\Carbon::now()->toDateTimeString(), 'updated_at' => Carbon\Carbon::now()->toDateTimeString(), 'event_volunteers_id' => $eventvolunteers_id, 'Type' => "Attend"]); } if ($volunteer->HostEvent == "1") { DB::table('commitments')->insert(['created_at' => Carbon\Carbon::now()->toDateTimeString(), 'updated_at' => Carbon\Carbon::now()->toDateTimeString(), 'event_volunteers_id' => $eventvolunteers_id, 'Type' => "Host"]); } } }