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