public function addMedicalRecordCreate()
{
$validator = Validator::make(Input::all(), array('HN' => 'min:8|hn_exist|have_appointment_with_me|already_addmedicalrecord'), array('HN.min' => 'ท่านกรอก HN ของผู้ป่วยไม่ครบ', 'HN.hn_exist' => 'HN ที่ท่านกรอกไม่ตรงกับผู้ป่วยใดของโรงพยาบาล', 'HN.have_appointment_with_me' => 'ผู้ป่วยคนนี้ไม่ได้นัดกับท่านไว้ในช่วงเวลานี้', 'HN.already_addmedicalrecord' => 'ท่านได้ทำการบันทึกการรักษาผู้ป่วยคนนี้ไปแล้ว'));
if ($validator->passes()) {
$n = Input::get('ICD10');
$diseases = DB::table('ICD10_Disease')->get();
$i = 0;
foreach ($diseases as $disease) {
if ($i++ == $n) {
$ICD10 = $disease->ICD10;
break;
}
}
date_default_timezone_set('Asia/Bangkok');
$date = date("Y-m-d", time());
$time = date("H:i:s", time());
$morning = 1;
if ((int) date("H", time()) < 12) {
$morning = 0;
}
DB::table('appointments')->where('HN', Input::get('HN'))->where('appointmentDate', $date)->where('morning', $morning)->update(array('addMedicalRecordTime' => $time));
$addMedicalRecord = new MedicalRecord();
$addMedicalRecord->HN = Input::get('HN');
$addMedicalRecord->doctorEmpID = Session::get('username');
date_default_timezone_set('Asia/Bangkok');
$addMedicalRecord->date = $date;
$addMedicalRecord->time = $time;
$addMedicalRecord->symptom = Input::get('symptom');
$addMedicalRecord->ICD10 = $ICD10;
$addMedicalRecord->save();
return Redirect::to('doctor/addMedicalRecord')->with('flash_notice', 'ดำเนินการบันทึกการรักษาสำเร็จ');
} else {
return Redirect::to('doctor/addMedicalRecord')->withErrors($validator)->withInput();
}
}
public function createMedicalRecord(Request $request)
{
try {
$strStatus;
$medicalRecord = new MedicalRecord();
$medicalRecord->patientIdFK = $request->patientId_diagnosis;
$medicalRecord->txtDiagnosis = $request->txtDiagnosis;
$strStatus = $medicalRecord->createMedicalRecord();
} catch (Exception $e) {
dd($e);
$strStatus = "error";
}
if ($strStatus === "success") {
return redirect()->action('PatientController@getAllPatient');
}
}
public function update(Request $request, $id)
{
$member = Member::find($id);
$medicalrecord = MedicalRecord::firstOrCreate(['member_id' => $member->id]);
$medicalrecord->fill($request->all());
$medicalrecord->member()->associate($member);
$medicalrecord->save();
Flash::success("<b>¡Se ha actualizado la ficha medica de " . $member->first_name . " de manera exitosa!</b>");
return redirect()->route('admin.member.show', $member->id);
}
public static function getAllMedicalRecord($id)
{
return MedicalRecord::where('patientIdFK', $id)->get();
}
public function viewMedicalHistory(Request $request)
{
$patient = Patient::getPatient($request->patientId);
$medicalRecords = MedicalRecord::getAllMedicalRecord($patient->patientId);
return response()->json($medicalRecords);
}
public function addMedicalRecordAndPrescribeCreate()
{
date_default_timezone_set('Asia/Bangkok');
$date = date("Y-m-d", time());
$time = date("H:i:s", time());
$morning = 1;
if ((int) date("H", time()) < 12) {
$morning = 0;
}
$Drugs = Input::get('D');
if (count($Drugs) > 0) {
foreach ($Drugs as $Drug) {
$i = 0;
foreach ($Drug as $D) {
$i++;
if ($i == 1) {
$HN = $D;
} else {
if ($i == 6) {
$drugName = $D;
} else {
if ($i == 7) {
$quantity = $D;
} else {
if ($i == 8) {
$description = $D;
}
}
}
}
}
$addPrescribedDrug = new PrescribedDrug();
$addPrescribedDrug->HN = $HN;
$addPrescribedDrug->doctorEmpID = Session::get('username');
$addPrescribedDrug->date = $date;
$addPrescribedDrug->time = $time;
$addPrescribedDrug->drugName = $drugName;
$addPrescribedDrug->quantity = $quantity;
$addPrescribedDrug->description = $description;
$addPrescribedDrug->save();
}
}
$pharmacists = DB::table('pharmacistQueue')->get();
$prev = 0;
foreach ($pharmacists as $pharmacist) {
$firstPharmacist = $pharmacist->pharmacistEmpID;
break;
}
foreach ($pharmacists as $pharmacist) {
if ($prev == 1) {
$pharmacistEmpID = $pharmacist->pharmacistEmpID;
$prev = 0;
break;
}
$prev = $pharmacist->queue;
}
if ($prev == 1) {
$pharmacistEmpID = $firstPharmacist;
}
DB::table('pharmacistQueue')->where('queue', 1)->update(array('queue' => 0));
DB::table('pharmacistQueue')->where('pharmacistEmpID', $pharmacistEmpID)->update(array('queue' => 1));
DB::table('appointments')->where('HN', Input::get("patientHN"))->where('doctorEmpID', Session::get('username'))->where('appointmentDate', $date)->where('morning', $morning)->update(array('addMedicalRecordTime' => $time, 'prescribedTime' => $time, 'pharmacistEmpID' => $pharmacistEmpID));
$addMedicalRecord = new MedicalRecord();
$addMedicalRecord->HN = Input::get("patientHN");
$addMedicalRecord->doctorEmpID = Session::get('username');
$addMedicalRecord->date = $date;
$addMedicalRecord->time = $time;
$addMedicalRecord->symptom = Input::get('symptom');
$addMedicalRecord->ICD10 = substr(Input::get('ICD10'), 0, strpos(Input::get('ICD10'), " "));
$addMedicalRecord->save();
return Redirect::to('doctor/addMedicalRecordAndPrescribe')->with('flash_notice', 'ดำเนินการบันทึกการรักษาและสั่งยาสำเร็จ');
}
