public function getPatient(Request $request)
{
if (!HospitalEmployee::isStaff()) {
return response()->json(["success" => false, "error" => 'notlogin or notvalid']);
}
$firstname = $request->input('firstname');
$lastname = $request->input('lastname');
if ($firstname && !$lastname) {
$lastname = 'unabletoguess';
}
if (!$firstname && $lastname) {
$firstname = 'unabletoguess';
}
$patients = Patient::where('firstname', 'LIKE', "%{$firstname}%")->orWhere('lastname', 'LIKE', "%{$lastname}%")->get();
$b = [];
foreach ($patients as $patApp) {
// $patApp[] = $a;
$c = $patApp->toArray();
$appointments = $patApp->futureAppointments();
$appointments_array = [];
foreach ($appointments as $appointment) {
$each = $appointment->toArray();
$each['doctor'] = $appointment->doctor->toArray();
$appointments_array[] = $each;
}
$c['appointments'] = $appointments_array;
// echo 'kk';
$b[] = $c;
}
return response()->json(["success" => true, "data" => $b]);
}
public function getPatient(Request $request)
{
if (!HospitalEmployee::isNurse()) {
return response()->json(["success" => false, "error" => 'notlogin or notvalid']);
}
$firstname = $request->input('firstname');
$lastname = $request->input('lastname');
if ($firstname && !$lastname) {
$lastname = 'unabletoguess';
}
if (!$firstname && $lastname) {
$firstname = 'unabletoguess';
}
$patients = Patient::where('firstname', 'LIKE', "%{$firstname}%")->orWhere('lastname', 'LIKE', "%{$lastname}%")->get();
$report = [];
foreach ($patients as $patient) {
$patientReport = PatientReport::orderBy('report_id', 'desc')->where('patient_id', $patient->id)->get();
$each = $patient->toArray();
if (!$patientReport) {
$each['patientReports'] = [];
} else {
$each['patientReports'] = $patientReport;
}
$report[] = $each;
}
return response()->json(["success" => true, "data" => $report]);
}
public function attemptLinkToPatient()
{
if (Patient::where('email', $this->email_address)->count() > 0) {
$patient = Patient::where('email', $this->email_address)->first();
$this->patient_id = $patient->id;
$this->save();
}
}
public function matchToPatient()
{
if (Patient::where('email', $this->sender_address)->count() > 0) {
$patient = Patient::where('email', $this->sender_address)->first();
$this->patient_id = $patient->id;
$this->save();
}
}
public function activateAccount($code)
{
$patient = Patient::where('activation_code', $code)->first();
if ($patient) {
$patient->update(['verified' => 1, 'activation_code' => NULL]);
Auth::login($patient);
return true;
}
}
/**
* 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]);
}
public function doPatientSuggestions(Request $request)
{
$search_str = $request->input('search_str');
$patients = Patient::where('first_name', 'LIKE', '%' . $search_str . '%')->orWhere('last_name', 'LIKE', '%' . $search_str . '%')->orWhere(DB::raw('CONCAT(first_name," ",last_name)'), 'LIKE', '%' . $search_str . '%')->take(10)->get();
$vars = array("patients" => $patients);
if ($request->has('links') && $request->input('links')) {
return view('backend.partials.patient-suggestion-link-list')->with($vars);
} else {
return view('backend.partials.patient-suggestion-list')->with($vars);
}
}
public function show($id)
{
$data = Queue::find($id);
$data->status = 'Consulting';
$data->save();
$ic = $data->pt_ic;
$data2 = Patient::where('pt_ic', $ic)->first();
//$data3 = Record::where('pt_id', $data2);
$inventory = Inventory::all();
return view('doctor.newcase')->with('data', $data)->with('data2', $data2)->with('inventory', $inventory);
//->with('history',$data3);
}
public function getPatient(Request $request)
{
if (!HospitalEmployee::isPharmacist()) {
return response()->json(["success" => false, "error" => 'notlogin or notvalid']);
}
$patients = Patient::where('status', 1)->get();
$result = [];
foreach ($patients as $patient) {
$each = $patient->toArray();
$each['drugRecords'] = DrugRecord::where('patient_id', $patient->id)->where('check', 0)->where('created_at', '>=', new \DateTime('today'))->get();
$result[] = $each;
}
return response()->json(['success' => true, 'data' => $result]);
}
/**
* Search existing patient records.
*
* @return JSON
*/
public function search(SearchPatientsRequest $request)
{
switch ($request->by) {
case "name":
return response()->json(["status" => "success", "patients" => Patient::where('first_name', 'LIKE', '%' . $request->for . '%')->orWhere('last_name', 'LIKE', '%' . $request->for . '%')->orderBy('id', 'desc')->get()->toArray()]);
break;
case "forceptID":
return response()->json(["status" => "success", "patients" => Patient::where('id', '=', $request->for)->where('concrete', '=', 1)->orderBy('id', 'desc')->get()->toArray()]);
break;
case "fieldNumber":
// return response()->json( Patient::where('') )
break;
default:
return response()->json(["status" => "failure", "message" => sprintf("Searching by %s is not supported.", $request->by), "patients" => []], 422);
break;
}
}
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index()
{
//
$gender = Input::get('gender');
//dd($gender);
$verified = Input::get('verified');
$data = array();
if (empty($gender) && empty($verified)) {
//menampilkan semua gender
$data['content'] = \App\Patient::all();
$data['gender'] = null;
$data['verified'] = null;
//dd($data['content']);
} else {
$data['content'] = \App\Patient::where('gender', $gender)->where('verified', $verified)->get();
$data['gender'] = $gender;
$data['verified'] = $verified;
//dd($verified);
}
$data['list_gender'][0] = 'L';
$data['list_gender'][1] = 'P';
return view('pages.admin.patient.index')->with('data', $data);
}
public function dispense($ic, $name)
{
$getID = Patient::where('pt_ic', $ic)->first();
//whole row
$deID = $getID->id;
//get the id from the ic
$getcaseID = Record::where('pt_id', $deID)->first();
$caseID = $getcaseID->id;
$disData = Dispensary::where('case_ref', $caseID)->first();
//xpe pakai first() sbb setiap case unik, case lain xpakai id ni
$arrQty = explode("#", $disData->dispensed_quantity);
$arrDrug = explode("#", $disData->dispensed_drug_code);
//need declare $prices array x?
$prices = array();
for ($x = 0; $x < count($arrDrug) - 1; $x++) {
//get price of each drug into an array
$hehe = Inventory::where('drug_name', $arrDrug[$x])->first();
$prices[$x] = $hehe->spu;
}
// $arrOne = count($arrDrug);
// arr1 = druglist , arr2= respective qty of drug, arr3= respective price of drug
$panel = Panel::all();
return view('staff.dispensary')->with('name', $name)->with('arr2', $arrQty)->with('arr1', $arrDrug)->with('arr3', $prices)->with('panel', $panel)->with('ptid', $deID);
}
/**
* Fetch visits for specified stage ID
*/
public function fetch(Stage $stage)
{
$response;
$visits = Visit::where('stage', '=', $stage->id)->get()->keyBy('id')->toArray();
$rootStageFields = Stage::where('root', true)->first()->inputFields;
foreach ($visits as $visitID => $visitData) {
$models = array();
foreach ($visitData['patients'] as $patientID) {
$patient = Patient::where('id', $patientID);
if ($patient->count() > 0) {
$models[$patientID] = $patient->first()->toArray();
}
}
$visits[$visitID]['patient_models'] = $models;
}
if (count($visits) > 0) {
$response = ["status" => "success", "message" => "Visits found.", "visits" => $visits];
} else {
$response = ["status" => "success", "message" => "No visits are currently at stage " . $stage->name . "."];
}
return response()->json($response);
}
public static function getAppointmentDoctor($doctor_id)
{
// $doctor_id = $doctor->input('doctor_id');
if ($doctor_id == null) {
return ["success" => false, "message" => 'doctor_not_found'];
}
$appointments = Appointment::orderBy('time', 'desc')->where('emp_id', $doctor_id)->get();
$result = [];
foreach ($appointments as $appointment) {
$patient = Patient::where('id', $appointment->patient_id)->first();
$result[] = ["patient" => $patient, "appointment" => $appointment];
}
if (sizeof($appointments) > 0) {
return $result;
} else {
return [];
}
}
public function addToQueue(Request $request)
{
$queue = new Queue();
$queue->pt_ic = $request->input('pt_id');
$data = Patient::where('pt_ic', $request->input('pt_id'))->first();
$queue->name = $data->pt_name;
$queue->status = 'Waiting';
$queue->save();
Alert::success('Added to queue!')->autoclose(2000);
return redirect()->action('StaffController@index');
}
public function getAllPatient()
{
$patientList = Patient::where('boolStatus', 1)->get();
return view('view-patient')->with('patientList', $patientList);
}
public static function wherePID($pid)
{
return $pat = Patient::where('pid', '=', $pid)->firstOrFail();
}
public function getPhoto($patient_id)
{
$patient = Patient::where('id', $patient_id)->first();
$file = Storage::disk('local')->get($patient_id . '.' . $patient->photo_extension);
$ext = $patient->photo_extension;
if ($ext == 'jpeg') {
return (new Response($file, 200))->header('Content-Type', 'image/jpeg');
} else {
if ($ext == 'jpg') {
return (new Response($file, 200))->header('Content-Type', 'image/jpeg');
} else {
if ($ext == 'gif') {
return (new Response($file, 200))->header('Content-Type', 'image/gif');
} else {
if ($ext == 'png') {
return (new Response($file, 200))->header('Content-Type', 'image/png');
}
}
}
}
}
public function incumbentsToAdd()
{
$incumbents = Patient::where('type', '=', 'Titular')->orderBy('firstname')->get();
$vista = view('patients.listOfIncumbents', compact('incumbents'));
return $vista;
}
| Application Routes
|--------------------------------------------------------------------------
|
|
|
*/
use App\Patient;
/**
* routes for the contact and about pages
*/
Route::get('/', 'appController@index');
Route::get('io', 'appController@about');
Route::get('dash', 'patientController@index');
/*
Resourceful controllers.
*/
Route::resource('patient', 'patientController');
Route::resource('nurse', 'nurseController');
Route::resource('doctor', 'doctorController');
Route::resource('admin', 'adminController');
Route::get('doctor/create/{id}', 'doctorController@create');
Route::get('admin/{id}/delete', 'adminController@delete');
/**
* Route for authentication.
*/
Route::controllers(['auth' => 'Auth\\AuthController', 'password' => 'Auth\\PasswordController']);
Route::post('dash', function () {
$keyword = trim(Input::get('keyword'));
$name = Patient::where('firstName', 'LIKE', '%' . $keyword . '%')->get();
return view('patients.search', compact('name'));
});
public function drugAllergic(Request $request, $patientId)
{
if (!HospitalEmployee::isDoctor()) {
return response()->json(["success" => false, "error" => 'notlogin or notvalid']);
}
$drugAllergic = $request->input('drugAllergic');
$error = [];
if (!$drugAllergic) {
$error[] = 'drugAllergic_not_found';
}
if (sizeof($error) != 0) {
return response()->json(["success" => false, "message" => $error]);
}
$drAllergic = Patient::where('id', $patientId)->first();
$drAllergic->drugAllergic = $drugAllergic;
$drAllergic->save();
return response()->json(["success" => true, "message" => 'saved drugAllergic record']);
}
public function deactivatePatient()
{
Patient::where('patientId', $this->patientId)->where('boolStatus', 1)->update(['boolStatus' => 0]);
return "success";
}
