public function MemberQuery($id)
{
if ($id == 0) {
$user_details = RegisterDetails::with(['users', 'reg1', 'reg2', 'reg1.sList', 'reg2.sList', 'habits'])->where('phone', '<>', '')->orderby('id')->paginate(75);
return view('console.member-query', compact('user_details', 'id'));
} else {
$count = RegisterDetails::with(['users', 'reg1', 'reg2', 'reg1.sList', 'reg2.sList', 'habits'])->whereHas('reg1', function ($query) use($id) {
$query->where('reg_subject_1', $id)->where('already_pick_1', 1)->orderBy('stu_id', 'ASC');
})->orWhereHas('reg2', function ($query) use($id) {
$query->where('reg_subject_2', $id)->where('already_pick_2', 1)->orderBy('stu_id', 'ASC');
})->count();
$user_details = RegisterDetails::with(['users', 'reg1', 'reg2', 'reg1.sList', 'reg2.sList', 'habits'])->whereHas('reg1', function ($query) use($id) {
$query->where('reg_subject_1', $id)->where('already_pick_1', 1)->orderBy('stu_id', 'ASC');
})->orWhereHas('reg2', function ($query) use($id) {
$query->where('reg_subject_2', $id)->where('already_pick_2', 1)->orderBy('stu_id', 'ASC');
})->paginate(300);
$user_details_secondary = RegisterDetails::with(['users', 'reg1', 'reg2', 'reg1.sList', 'reg2.sList', 'habits'])->whereHas('reg1', function ($query) use($id) {
$query->where('reg_subject_1', $id)->where('already_pick_1', 0);
})->orWhereHas('reg2', function ($query) use($id) {
$query->where('reg_subject_2', $id)->where('already_pick_2', 0);
})->orderby('id')->paginate(300);
return view('console.member-query', compact('user_details', 'user_details_secondary', 'id', 'count'));
}
}
