示例#1
0
 /**
  * Display the specified resource.
  *
  * @param  int $id
  * @return \Illuminate\Http\Response
  */
 public function show($id)
 {
     $name = Patient::where(DB::raw('CONCAT_WS(" ", last, first, middle)'), 'LIKE', '%' . $id . '%')->orWhere(DB::raw('CONCAT_WS(" ", first, middle, last)'), 'LIKE', '%' . $id . '%')->orWhere(DB::raw('CONCAT_WS(" ", first, last)'), 'LIKE', '%' . $id . '%');
     $pos = Patient::where('position', 'LIKE', '%' . $id . '%');
     $ags = Patient::select('patients.*')->join('agencies', 'agencies.id', '=', 'patients.agency_id')->where('agencies.code', 'LIKE', '%' . $id . '%')->orWhere('agencies.name', 'LIKE', '%' . $id . '%');
     $patients = Patient::with('agency')->where('pid', '=', $id)->union($name)->union($pos)->union($ags)->simplePaginate($this->recPerPage);
     $pageTitle = 'ODRMS - Patient Dental Records';
     return view('patient.index', ['pats' => $patients, 'pageTitle' => $pageTitle]);
 }
示例#2
0
 /**
  * Get all patient records [within a range].
  *
  * @return JSON
  */
 public function fetch(Request $request)
 {
     return response()->json(["status" => "success", "patients" => Patient::with('visit')->concrete()->limit(50)->orderBy('id', 'desc')->get()->toArray()]);
 }
示例#3
0
 /**
  * Show the form for editing the specified resource.
  *
  * @param  int $id
  * @return \Illuminate\Http\Response
  */
 public function edit($pid, $tno)
 {
     $pat = Patient::with('agency')->where('pid', '=', $pid)->firstOrFail();
     $dents = Auth::user()->dentists_options;
     $result = Dental::whereTNO($tno);
     $data = array('pat' => $pat, 'dentists' => $dents, 'result' => $result, 'pageTitle' => 'ODRMS - Patient Dental Records - ' . $pat->name . ' - Edit :' . $result->trans_no);
     return view('patient.results.dental.edit', $data);
 }