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"]);
}
}
}
private function saveVolunteer(Request $request, \teambernieny\Volunteer $volunteer, $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->City = $request->City;
$volunteer->save();
}
public function getAll(Request $request)
{
$volunteers = \teambernieny\Volunteer::with('neighborhood')->with('contactevents')->orderby('FirstName')->get();
return view('volunteer.search.all')->with(['volunteers' => $volunteers]);
}
public function postCityProcess(Request $request)
{
ini_set('auto_detect_line_endings', TRUE);
$file = fopen(Config::get('app.filepath') . $request->FileName, "r");
## Get the header line = FirstName(0),LastName(1),Phone(2),Neighborhood(3),Borough(4),Caller(5),Called(6),
## VM(7),Texted(8),RSVP(9),Event(10),Date(11),DoNotContact(12),BadPhone(13),Comments(14)
$x = 0;
while (($data = fgetcsv($file)) !== FALSE) {
if ($x == 0) {
$x = $x + 1;
continue;
}
#; Find Volunteer or add if does not exist
if ($data[2] != "") {
// check first by phone number
$volunteers = \teambernieny\Volunteer::where('Phone', '=', $data[2])->get();
}
if (sizeof($volunteers) == 0) {
$volunteer = new \teambernieny\Volunteer();
$volunteer->FirstName = $data[0];
$volunteer->LastName = $data[1];
$volunteer->Phone = $data[2];
$volunteer->County = $data[4];
$volunteer->neighborhood_id = $this->checkNeighborhood($data[3], $data[4]);
if ($request->CDistrict != "") {
$volunteer->CDistrict = $request->CDistrict;
}
$volunteer->user_id = "1";
$volunteer->save();
$volunteer_id = $volunteer->id;
} else {
$volunteer_id = $volunteers[0]->id;
$volunteer = $volunteers[0];
}
if ($data[12] == "1") {
$volunteer->DoNotContact = true;
}
if ($data[13] == "1") {
$volunteer->BadPhone = true;
}
#; Check to see if volunteer was Called or texted -- add contact event if so
$data[6] = strtoupper($data[6]);
$data[7] = strtoupper($data[7]);
$data[8] = strtoupper($data[8]);
$data[9] = strtoupper($data[9]);
if ($data[6] == "Y" || $data[8] == "Y" || $data[6] == "YES" || $data[8] == "YES") {
if ($data[10] != "") {
//get event info if there is a name in the event column
$events = \teambernieny\Event::where('Name', '=', $data[10])->get();
if (sizeof($events) > 0) {
$event_id = $events[0]->id;
} else {
//add if event doesn't exist
$event = new \teambernieny\Event();
$event->Name = $data[12];
$event->neighborhood_id = "1";
$event->Date = date('Y/m/d');
$event->save();
$event_id = $event->id;
}
} else {
$event_id = null;
//no event indicated
}
#; create contact event
$contactevent = new \teambernieny\Contactevent();
$contactevent->volunteer_id = $volunteer_id;
$contactevent->event_id = $event_id;
$contactevent->Purpose = "Invitation";
// if RSVPed
if ($data[9] == "Y" || $data[9] == "SENT" || $data[9] == "YES") {
$contactevent->RSVP = true;
} else {
$contactevent->RSVP = false;
}
// if Called
if ($data[6] == "Y" || $data[6] == "YES") {
$contactevent->Call = true;
} else {
$contactevent->Call = false;
}
// if Texted
if ($data[8] == "Y" || $data[8] == "YES") {
$contactevent->Text = true;
} else {
$contactevent->Text = false;
}
//if left a voicemail
if ($data[7] == "Y" || $data[7] == "YES") {
$contactevent->VoiceMail = true;
} else {
$contactevent->VoiceMail = false;
}
$contactevent->Date = date('Y-m-d', strtotime($data[11]));
$contactevent->Comment = $data[14];
$contactevent->Caller = $data[5];
$contactevent->Completed = true;
$contactevent->user_id = null;
$contactevent->save();
}
}
fclose($file);
return view('contactevent.process')->with(['message' => "File Processed"]);
}
/**
* 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);
}