public static function getEloquentQuery(): Builder
{
return parent::getEloquentQuery()
->join('enrollments', 'users.id', '=', 'enrollments.user_id')
->leftJoin('applications', 'users.id', '=', 'applications.user_id')
->select(
'users.*',
'enrollments.section_id',
'enrollments.school_class_id',
'enrollments.status',
'applications.application_id',
'applications.class_of_entry_id',
'applications.screening_mark',
'applications.screening_status'
)
->where('users.role_id', Role::STUDENT);
}
public static function getEloquentQuery(): Builder
{
return parent::getEloquentQuery()
->join('enrollments', 'users.id', '=', 'enrollments.user_id')
->leftJoin('applications', 'users.id', '=', 'applications.user_id')
->select(
'users.*',
'enrollments.section_id',
'enrollments.school_class_id',
'enrollments.status',
'applications.application_id',
'applications.class_of_entry_id',
'applications.screening_mark',
'applications.screening_status'
)
->where('users.role_id', Role::STUDENT);
}