/**
* 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');
}
