Exemplos de app diagnosisRecord::join em PHP

Exemplo n.º 1

Arquivo: diagnosisRecord.php Projeto: princemaw/iHospital

 public static function viewDiagnosisHistoryDoctor($input)
 {
     $diagnosisRecords = diagnosisRecord::join('appointment', 'diagnosisRecord.appointmentId', '=', 'appointment.appointmentId')->join('schedule', 'appointment.scheduleId', '=', 'schedule.scheduleId')->join('scheduleLog', 'schedule.scheduleLogId', '=', 'scheduleLog.scheduleLogId')->where('doctorId', $input['doctorId'])->get();
     return $diagnosisRecords;
 }