Esempio n. 1
0
 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');
 }