public function getIndex()
{
$authUser = Auth::user();
$data['quorumId'] = $authUser->quorum_id;
$data['wardId'] = $authUser->ward_id;
$data['families'] = Member::where('ward_id', '=', $authUser->ward_id)->where('quorum_id', '=', $authUser->quorum_id)->orderBy('last_name', 'asc')->get();
$data['numOfFamilies'] = count($data['families']);
$data['districtList'] = District::where('ward_id', '=', $authUser->ward_id)->where('quorum_id', '=', $authUser->quorum_id)->get();
$data['districtMembers'] = [];
foreach ($data['districtList'] as $key => $district) {
$data['districtMembers'][$key] = Member::find($district->member_id);
}
$data['existingHomeTeachers'] = Companionship::select('companionships.*')->leftJoin('members', 'companionships.ht_one_id', '=', 'members.id')->where('companionships.ward_id', '=', $authUser->wardId)->where('companionships.quorum_id', '=', $authUser->quorumId)->orderBy('members.last_name', 'ASC')->get();
$data['existingHomeTeacherCompanion'] = $this->getExistingHomeTeacherCompanionData($data['existingHomeTeachers']);
$checkForUnassignedMembers = Member::where('ward_id', '=', $authUser->ward_id)->where('quorum_id', '=', $authUser->quorumId)->where('is_jr_comp', '=', false)->get();
$data['unassignedFamilies'] = [];
foreach ($checkForUnassignedMembers as $unassigned) {
$companionshipFamily = CompanionshipFamily::where('member_id', '=', $unassigned->id)->get();
// If family doesn't exist in the comps relationship table
if ($companionshipFamily->isEmpty()) {
$data['unassignedFamilies'][] = Member::find($unassigned->id);
}
}
$data['unassignedHomeTeachers'] = [];
foreach ($data['families'] as $family) {
$companionshipFamily = Companionship::where('ht_one_id', '=', $family->id)->orWhere('ht_two_id', '=', $family->id)->first();
if (empty($companionshipFamily) || empty($companionshipFamily->id)) {
$data['unassignedHomeTeachers'][] = Member::find($family->id);
}
}
return view('companionships', $data);
}
