Exemple #1
0
 public function show($id)
 {
     $inquiry_id = $id;
     $inquiry = Inquiry::find($inquiry_id);
     if (is_null($inquiry)) {
         return redirect()->back()->with('status', 'Could not locate reference to Inquiry');
     }
     $episode_id = $inquiry->episode_id;
     $demographics = DB::table('demographics')->where('eie', '!=', '1')->where('inquiry_id', '=', $inquiry_id)->orderBy('id', 'desc')->get();
     $payors = DB::table('payors')->where('eie', '!=', '1')->where('inquiry_id', '=', $inquiry_id)->orderBy('id', 'desc')->get();
     $contacts = DB::table('contacts')->where('eie', '!=', '1')->where('inquiry_id', '=', $inquiry_id)->where('isrefsrc', '!=', '1')->orderBy('id', 'desc')->get();
     $refsrcs = DB::table('contacts')->where('eie', '!=', '1')->where('isrefsrc', '=', '1')->where('inquiry_id', '=', $inquiry_id)->orderBy('id', 'desc')->get();
     $assessments = DB::table('assessments')->where('eie', '!=', '1')->where('inquiry_id', '=', $inquiry_id)->orderBy('id', 'desc')->get();
     $admissions = DB::table('admissions')->where('eie', '!=', '1')->where('inquiry_id', '=', $inquiry_id)->orderBy('id', 'desc')->get();
     $ice = Ice::find($episode_id);
     $ices = DB::table('ice')->where('eie', '!=', '1')->where('inquiry_id', '=', $inquiry_id)->orderBy('id', 'desc')->get();
     return view('inquiry/index')->with('inquiry', $inquiry)->with('demographics', $demographics)->with('payors', $payors)->with('ice', $ice)->with('contacts', $contacts)->with('refsrcs', $refsrcs)->with('assessments', $assessments)->with('admissions', $admissions)->with('ices', $ices);
 }
Exemple #2
0
 public function edit($id)
 {
     $ice_id = $id;
     //the ice_id is the same as the episode_id
     $ice = Ice::find($ice_id);
     if (is_null($ice)) {
         return redirect()->back()->with('status', 'Missing Reference');
     }
     return view('ice.edit')->with('ice', $ice);
 }