/** * Get the persons of the family. * * @return \Illuminate\Http\JsonResponse */ public function personData($id) { $records = Person::join('families', 'persons.family_id', '=', 'families.id')->select(['persons.id', 'families.family_code', 'persons.first_name', 'persons.last_name', 'persons.relationship', 'persons.gender', 'persons.age', 'persons.civil_status'])->where('families.id', '=', $id); return Datatables::of($records)->addColumn('action', function ($record) { return '<a title="View" href="/person/' . $record->id . '" class="btn btn-xs blue"><i class="fa fa-search"></i></a> <a title="Edit" href="/person/' . $record->id . '/edit" class="btn btn-xs green"><i class="fa fa-edit"></i></a>'; })->make(true); }
public function exportExcel() { if (Gate::denies('download', Person::class)) { abort(403); } $records = Person::join('families', 'persons.family_id', '=', 'families.id')->join('households', 'families.household_id', '=', 'households.id')->select(['households.household_code', 'families.family_code', 'households.barangay', 'households.zone', \DB::raw("CONCAT(persons.last_name, ', ', persons.first_name) as 'display_name'"), 'persons.first_name', 'persons.middle_name', 'persons.last_name', 'persons.gender', 'persons.age', 'persons.civil_status', 'persons.educational_attaintment', 'persons.distance_to_school', 'persons.skill_possess', 'persons.skill_possess_other', 'persons.occupation', 'persons.specific_occupation', 'persons.relationship', 'persons.vulnerability', 'persons.vulnerability_other', 'persons.specific_vulnerability', 'persons.contact_number', 'persons.photo_url']); if (\Auth::user()->group->assigned_barangay != 'All') { $records = $records->where('households.barangay', '=', \Auth::user()->group->assigned_barangay); } $records = $records->orderBy('families.family_code', 'asc')->get(); $recordsArray = []; $recordsArray[] = ['household_code', 'family_code', 'barangay', 'zone', 'display_name', 'first_name', 'middle_name', 'last_name', 'gender', 'age', 'civil_status', 'educational_attaintment', 'distance_to_school', 'skill_possess', 'skill_possess_other', 'occupation', 'specific_occupation', 'relationship', 'vulnerability', 'vulnerability_other', 'specific_vulnerability', 'contact_number', 'photo_url']; foreach ($records as $record) { $recordsArray[] = $record->toArray(); } $now = Carbon::now('Asia/Manila'); $file_name = 'arp_persons_' . $now->format('Ymd_His'); Excel::create($file_name, function ($excel) use($recordsArray) { $excel->setTitle('ARP Persons'); $excel->setDescription('List of ARP Persons'); $excel->sheet('Persons', function ($sheet) use($recordsArray) { $sheet->fromArray($recordsArray, null, 'A1', false, false); }); })->download('xlsx'); }
public function exportPerson($id) { if (Gate::denies('download', Activity::class)) { abort(403); } $records = Activity::join('activity_subtitles', 'activities.subtitle_id', '=', 'activity_subtitles.id')->join('activity_titles', 'activity_subtitles.title_id', '=', 'activity_titles.id')->select(['activities.date_of_activity', 'activities.barangay', 'activity_titles.title', 'activity_subtitles.subtitle', 'activities.day_of_activity', 'activities.venue_of_activity', 'activities.conducted_by', 'activities.remarks'])->where('activities.id', '=', $id)->get(); $recordsArray = []; foreach ($records as $record) { $recordsArray[] = ['date_of_activity', $record->date_of_activity]; $recordsArray[] = ['barangay', $record->barangay]; $recordsArray[] = ['title', $record->title]; $recordsArray[] = ['subtitle', $record->subtitle]; $recordsArray[] = ['day_of_activity', $record->day_of_activity]; $recordsArray[] = ['venue_of_activity', $record->venue_of_activity]; $recordsArray[] = ['conducted_by', $record->conducted_by]; $recordsArray[] = ['remarks', $record->remarks]; $recordsArray[] = [' ', ' ']; } $records = Person::join('activity_person', 'activity_person.person_id', '=', 'persons.id')->join('families', 'persons.family_id', '=', 'families.id')->select(['families.family_code', 'persons.last_name', 'persons.first_name', 'persons.age', 'persons.gender', 'persons.civil_status', 'persons.contact_number'])->where('activity_person.activity_id', '=', $id)->orderBy('persons.last_name', 'asc')->orderBy('persons.first_name', 'asc')->orderBy('families.family_code', 'asc')->get(); $recordsArray[] = ['family_code', 'last_name', 'first_name', 'age', 'gender', 'civil_status', 'contact_number']; foreach ($records as $record) { $recordsArray[] = $record->toArray(); } $now = Carbon::now('Asia/Manila'); $file_name = 'arp_activity_attendance_' . $now->format('Ymd_His'); Excel::create($file_name, function ($excel) use($recordsArray) { $excel->setTitle('ARP Activity Attendance'); $excel->setDescription('List of ARP Activity Attendance'); $excel->sheet('Activity Attendance', function ($sheet) use($recordsArray) { $sheet->fromArray($recordsArray, null, 'A1', false, false); }); })->download('xlsx'); }
/** * @return \Illuminate\Contracts\View\Factory|\Illuminate\View\View */ public function index() { $people = Person::join('us_states', 'state', '=', 'state_id')->get(); return view('person.index', compact('people')); }