public static function doctorSortByName() { return doctor::join('users', 'doctor.userId', '=', 'users.userId')->orderBy('name', 'asc')->orderBy('surname', 'asc')->join('hospitalStaff', 'doctor.userId', '=', 'hospitalStaff.userId')->join('department', 'hospitalStaff.departmentId', '=', 'department.departmentId'); }