public function searchMedicine(Request $request) { $id = $request->diagnosisRecord; $diagnosisRecord = diagnosisRecord::where('diagRecordId', $id)->join('appointment', 'diagnosisRecord.appointmentId', '=', 'appointment.appointmentId')->join('users', 'appointment.patientId', '=', 'users.userId')->join('patient', 'users.userId', '=', 'patient.userId')->first(); $keyword = $request->medicineId; $medicine = medicine::where('medicineId', 'like', '%' . $keyword . '%')->orwhere('medicineName', 'like', '%' . $keyword . '%')->first(); return view('doctor.diagMedicineResult')->with('medicine', $medicine)->with('diagnosisRecord', $diagnosisRecord); }
public static function addMedicineToPrescription($input) { $diagnosisRecordId = $input['diagnosisRecord']; $diagnosisRecord = diagnosisRecord::where('diagRecordId', $diagnosisRecordId)->first(); $prescription = prescription::where('appointmentId', $diagnosisRecord->appointmentId)->first(); $input['prescriptionId'] = $prescription->prescriptionId; //medicinePrescription::create($input); $medicine = medicinePrescription::where('prescriptionId', $prescription->prescriptionId)->join('medicine', 'medicinePrescription.medicineId', '=', 'medicine.medicineId')->get(); return $medicine; }
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; }
public function addMedicineToPrescription(Request $request) { $input = $request->all(); $id = $request->diagnosisRecord; $diagnosisRecord = diagnosisRecord::where('diagRecordId', $id)->join('appointment', 'diagnosisRecord.appointmentId', '=', 'appointment.appointmentId')->join('users', 'appointment.patientId', '=', 'users.userId')->join('patient', 'users.userId', '=', 'patient.userId')->first(); $medicine = medicinePrescription::addMedicineToPrescription($input); return view('doctor.diagMedicine')->with('medicine', $medicine)->with('diagnosisRecord', $diagnosisRecord); }