public function reportPage($id) { $report = Reports::find($id); if ($report) { $recommendation = Recommendation::where('report_id', $report->id)->join('users', 'users.id', '=', 'recommendations.doctor_id')->first(); $conversations = Conversation::where('report_id', $report->id)->where('patient_id', auth()->user()->id)->get(); $data = ['report' => $report, 'recommendation' => $recommendation, 'conversations' => $conversations]; return view('frontend.user.report_page', $data); } else { abort(404); } }
public function report($id) { $doctor = auth()->user(); //Get all reports assigned to this doctor if ($reports = Reports::where('assigned_doctor_id', $doctor->id)->where('reports.id', $id)->join('users', 'user_id', '=', 'users.id')->first(['*', 'reports.updated_at AS report_date', 'reports.id AS reportID'])) { $previous_complaints = Reports::where('user_id', $reports->user_id)->where('id', '!=', $reports->reportID)->get(); $recommendation = Recommendation::where('report_id', $id)->orderBy('id', 'DESC')->first(); //Get current recommendation(s) for this post $doctors = ['--Select Specialization--'] + DoctorsSpecialization::lists('name', 'id')->toArray(); $data = ['report' => $reports, 'id' => $id, 'recommendation' => $recommendation, 'doctors' => $doctors, 'previous_complaints' => $previous_complaints]; return view('frontend.doctor.report', $data); } else { abort(404); } }