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 addMedicine($input)
 {
     $medicineName = $input['medicineName'];
     $medicine = medicine::where('medicineName', $medicineName)->first();
     $medicineId = $medicine->medicineId;
     $input['medicineId'] = $medicineId;
     $medicinePrescription = medicinePrescription::create($input);
     return $medicinePrescription;
 }