public function post(Step2Request $request)
{
// if id is found, update advisor
if ($advisor_id = $request->input('id')) {
$advisor = Advisor::find($advisor_id);
$advisor->update($request->all());
} else {
// create new advisor
$advisor = new Advisor($request->all());
$advisor->school_id = Session::get('school')->id;
$advisor->event_id = Session::get('event')->id;
$advisor->save();
}
Session::set('advisor', Advisor::find($advisor->id));
if (!$request->input('other_school')) {
// auto create first advisor
$attendee = new Attendee();
// split up the attending advisor name
$attendee_name = explode(' ', $request->input('attending_advisor'));
if (is_array($attendee_name) && count($attendee_name) > 1) {
$attendee->first_name = $attendee_name[0];
$attendee->last_name = $attendee_name[1];
} else {
$attendee->first_name = $request->input('attending_advisor');
$attendee->last_name = '';
}
$attendee->event_id = Session::get('event')->id;
$attendee->school_id = Session::get('school')->id;
$attendee->role_id = Role::where(['name' => 'Advisor', 'event_id' => Session::get('event')->id])->first()->id;
$attendee->advisor_id = Session::get('advisor')->id;
$attendee->save();
Flash::info(trans('notifications.edit_as_needed'));
}
return redirect('/event/' . Session::get('event')->slug . '/step/3');
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function destroy(AttendeeRequest $request, Attendee $attendee)
{
$attendee->delete();
if ($request->ajax() || $request->wantsJson()) {
return new JsonResponse($attendee);
}
return redirect('attendees');
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
$faker = Faker::create();
foreach (range(1, 30) as $index) {
Attendee::create(['first_name' => $faker->firstNameMale(), 'last_name' => $faker->lastName(), 'suffix' => $index % 5 ? NULL : $faker->suffix(), 'identifier' => $faker->regexify('[A-Z]?[0-9]{3}/[0-9]{3}')]);
}
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
Attendee::create(['event_id' => 1, 'school_id' => 1, 'role_id' => 1, 'last_name' => 'Testerman', 'first_name' => 'Test', 'gender' => 'M', 'grade' => 0, 'special_diet' => 'Test diet', 'bringing_meds' => 1, 'special_needs' => 'Testing needs', 'advisor_id' => 1]);
Attendee::create(['event_id' => 1, 'school_id' => 1, 'role_id' => 2, 'last_name' => 'Testerman 2', 'first_name' => 'Test 2', 'gender' => 'F', 'grade' => 9, 'special_diet' => 'Test diet 2', 'bringing_meds' => 0, 'special_needs' => 'Testing needs 2', 'advisor_id' => 1]);
Attendee::create(['event_id' => 1, 'school_id' => 1, 'role_id' => 1, 'last_name' => 'Testerman', 'first_name' => 'Test', 'gender' => 'M', 'grade' => 0, 'special_diet' => 'Test diet', 'bringing_meds' => 1, 'special_needs' => 'Testing needs', 'advisor_id' => 2]);
Attendee::create(['event_id' => 1, 'school_id' => 1, 'role_id' => 1, 'last_name' => 'Testerman', 'first_name' => 'Test', 'gender' => 'M', 'grade' => 0, 'special_diet' => 'Test diet', 'bringing_meds' => 1, 'special_needs' => 'Testing needs', 'advisor_id' => 2]);
}
/**
* Define your route model bindings, pattern filters, etc.
*
* @param \Illuminate\Routing\Router $router
* @return void
*/
public function boot(Router $router)
{
$router->bind('attendees', function ($id) {
return \App\Attendee::where('id', $id)->firstOrFail();
});
parent::boot($router);
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
$faker = Faker::create();
$attendeeIds = Attendee::lists('id')->all();
$counselorIds = Counselor::lists('id')->all();
foreach ($attendeeIds as $attendeeId) {
DB::table('attendee_counselor')->insert(['attendee_id' => $attendeeId, 'counselor_id' => $faker->randomElement($counselorIds), 'created_at' => Carbon::now()]);
}
}
public static function total()
{
$total = 0;
$attendees = Attendee::where(['event_id' => Session::get('event')->id, 'school_id' => Session::get('school')->id])->get();
foreach ($attendees as $attendee) {
// add to total
$total += $attendee->role->cost;
}
return $total;
}
/**
* Get the validation rules that apply to the request.
*
* @return array
*/
public function rules()
{
$attendee = Attendee::find($this->attendees);
switch ($this->method()) {
case 'GET':
case 'DELETE':
return [];
case 'POST':
return ['event_id' => 'required|not_in:0', 'fname' => 'required', 'lname' => 'required', 'email' => 'required|email|unique:attendees,email'];
case 'PUT':
case 'PATCH':
return ['event_id' => 'required|not_in:0', 'fname' => 'required', 'lname' => 'required', 'email' => 'required|email|unique:attendees,email,' . $attendee->id];
default:
break;
}
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
$faker = Faker::create();
$attendeeIds = Attendee::lists('id')->all();
$programIds = Program::lists('id')->all();
$counter = 0;
foreach ($attendeeIds as $attendeeId) {
$completion_date = $termination_date = NULL;
if (($counter + 1) % 6 == 0) {
$completion_date = $faker->dateTimeBetween($startDate = '-6 months');
} else {
if (($counter + 1) % 13 == 0) {
$termination_date = $faker->dateTimeBetween($startDate = '-6 months');
}
}
DB::table('enrollments')->insert(['attendee_id' => $attendeeId, 'program_id' => $faker->randomElement($programIds), 'start_date' => $faker->dateTimeBetween($startDate = '-12 months'), 'completion_date' => $completion_date, 'termination_date' => $termination_date, 'created_at' => Carbon::now()]);
$counter++;
}
}
/**
* Store a newly created resource in storage.
*
* @return \Illuminate\Http\Response
*/
public function store()
{
if (!Input::get('attendee_id') or !Input::get('program_id')) {
return $this->respondUnprocessableEntity('Parameters failed validation for an enrollment.');
}
try {
$attendee = Attendee::findOrFail(Input::get('attendee_id'));
} catch (ModelNotFoundException $e) {
return $this->respondUnprocessableEntity('Attendee provided does not exist.');
}
try {
$program = Program::findOrFail(Input::get('program_id'));
} catch (ModelNotFoundException $e) {
return $this->respondUnprocessableEntity('Program provided does not exist.');
}
$existingEnrollment = Enrollment::where('attendee_id', $attendee->id)->where('program_id', $program->id)->whereNull('enrollments.deleted_at')->get();
if (count($existingEnrollment)) {
return $this->respondUnprocessableEntity('The enrollment of the attendee to the program already exists.');
}
//We pass validation. Now add the enrollment.
Enrollment::create(Input::all());
return $this->respondCreated('Enrollment created successfully.');
}
public function postLogin(LoginRequest $request, Attendee $attendee)
{
// Pagina waar wordt gecheckt of het opgegeven emailadres voorkomt in de tabel 'attendees'
$deattendee = $attendee->where('email', $request->get('email'))->first();
if ($deattendee == null) {
$newattendee = new $attendee(['email' => $request->get('email'), 'ref' => $request->get('ref')]);
$newattendee->save();
$data = ['voornaam' => null, 'achternaam' => null, 'email' => $request->get('email')];
// Verstuur kopie naar Digitus
Mail::send('includes.email.webinars.superboost', $data, function ($message) use($data) {
$message->from('*****@*****.**', 'Digitus Marketing');
$message->to('*****@*****.**', 'Digitus Marketing')->subject('Iemand heeft zich zojuist aangemeld voor het Superboost je bereik Webinar');
});
// Doe iets omdat $deattendee niet bestaat
return redirect()->back()->with(['message' => 'Het lijkt er op dat je je niet hebt aangemeld voor dit online event. We hebben je ingeschreven, je kunt je nu aanmelden voor dit online event! Probeer het nogmaals :)']);
// dd($deattendee);
} else {
// Doe iets omdat $deattendee bestaat
\Session::put('deattendee', $deattendee);
return redirect('/superboost/onlineevent')->with(['message' => 'Succes']);
// dd($deattendee);
}
}
public function manage()
{
$attendees = Attendee::paginate(5);
return view('attendees.manage', compact('attendees'));
}
public function removeAttendee(RemoveAttendeeRequest $request)
{
Attendee::find($request->input('attendee_id'))->delete();
return redirect('/event/' . Session::get('event')->slug . '/step/3');
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function destroy($id)
{
$attendee = Attendee::find($id);
if (!$attendee) {
return $this->respondNotFound('Attendee does not exist.');
}
if ($attendee->delete()) {
return $this->respond(['message' => 'The attendee has been deleted.']);
} else {
return $this->respondUnprocessableEntity('There was a problem deleting the attendee.');
}
}
/**
* Displays the counselor that an attendee is assigned to.
*
* @return \Illuminate\Http\Response
*/
public function byAttendee($attendeeId = null)
{
$counselor = $attendeeId ? Attendee::findOrFail($attendeeId)->counselor : null;
return $this->respond(['data' => $this->counselorTransformer->transform($counselor)]);
}
public function postHerhalingLogin($slug, Webinar $w, Webinarherhaling $wh, Attendee $a, LoginRequest $request)
{
$webinar = $w->where('slug', $slug)->first();
$hetwebinar = $webinar->webinarherhaling->first();
// Pagina waar wordt gecheckt of het opgegeven emailadres voorkomt in de tabel 'attendees'
$deattendee = $a->where('email', $request->get('email'))->first();
if ($deattendee == null) {
$newattendee = new $a(['email' => $request->get('email'), 'ref' => $request->get('ref')]);
$newattendee->save();
$newattendee->webinars()->attach($hetwebinar->webinars->first()->id);
$data = ['voornaam' => null, 'achternaam' => null, 'email' => $request->get('email'), 'webinartitel' => $hetwebinar->webinars->first()->titel];
// Verstuur kopie naar Digitus
Mail::send('includes.email.webinars.aanmeld', $data, function ($message) use($data) {
$message->from('*****@*****.**', 'Digitus Marketing');
$message->to('*****@*****.**', 'Digitus Marketing')->subject('Iemand heeft zich zojuist aangemeld voor het ' . $data['webinartitel'] . ' Webinar');
});
// Doe iets omdat $deattendee niet bestaat
return redirect()->back()->with(['message' => 'Het lijkt er op dat je je niet hebt aangemeld voor dit online event. We hebben je ingeschreven, je kunt je nu aanmelden voor dit online event! Probeer het nogmaals :)']);
// dd($deattendee);
} else {
// Doe iets omdat $deattendee bestaat
if ($deattendee->webinars->contains($hetwebinar->webinars->first()->id)) {
$deattendee->update(['ref' => $request->get('ref')]);
\Session::put('deattendee', $deattendee);
return redirect()->action('WebinarController@getHerhaling', array($hetwebinar->webinars->first()->slug))->with(['message' => 'Succes']);
} else {
$deattendee->update(['ref' => $request->get('ref')]);
$deattendee->webinars()->attach($hetwebinar->webinars->first()->id);
return redirect()->back()->with(['message' => 'Het lijkt er op dat er iets mis is gegaan.. Probeer het opnieuw']);
}
}
}
/**
* Output table data as csv.
*/
public function export($format = 'csv')
{
// grab data
$data = Attendee::select('attendees.id as AttendeeID', 'attendees.created_at as RegTime', 'schools.region as Region', 'roles.name as Role', 'attendees.last_name as NameLast', 'attendees.first_name as NameFirst', 'attendees.gender as Gender', 'attendees.grade as Grade', 'attendees.special_diet as SpecialDiet', 'attendees.bringing_meds as BringingMeds', 'attendees.special_needs as SpecialNeeds', 'advisors.name as RegisteredBy', 'attendees.housing_code as HousingCode', 'attendees.shirt_size as TShirtSize')->leftJoin('roles', 'roles.id', '=', 'attendees.role_id')->leftJoin('advisors', 'advisors.id', '=', 'attendees.advisor_id')->join('schools', 'schools.id', '=', 'advisors.school_id')->get();
// create empty file
$csv = Writer::createFromFileObject(new \SplTempFileObject());
// create header
$csv->insertOne(['AttendeeID', 'RegTime', 'Region', 'Role', 'NameLast', 'NameFirst', 'Gender', 'Grade', 'SpecialDiet', 'BringingMeds', 'SpecialNeeds', 'RegisteredBy', 'HousingCode', 'TShirtSize']);
// insert rows as associative array
$csv->insertAll($data->toArray());
$csv->output('attendees_' . \Carbon\Carbon::now()->timestamp . '.csv');
}
