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);
}
