/**
* Show the form for creating a new resource.
*
* @return \Illuminate\Http\Response
*/
public function create()
{
$doctors = Doctor::select(DB::raw("CONCAT(doctor_fname,' ', doctor_mname,' ',doctor_lname,' - ',(select med_specialty from medspecialties where id = medspecialty_id) ) AS full_name, id"))->lists('full_name', 'id');
$beds = Bed::vacant();
$visit_type = array('in_patient' => 'in patient', 'out_patient' => 'out patient');
//dd($doctors,$beds);
return view('pages.Visit.admit', compact('doctors', 'beds', 'visit_type'));
}
/**
* Display the specified resource.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function show($id)
{
$bed = Bed::findOrFail($id);
$vacant = Visit::select('id')->where('bed_id', '>', $id)->exists();
if ($vacant) {
$vacant = 'available';
} else {
$vacant = 'occupied';
}
return view('pages.beds.show', compact('bed', 'vacant'));
}