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