Ejemplo n.º 1
0
 public function delete_food($calendar_date)
 {
     $uuid = Session::get('uuid');
     $user_food = HospitalNo::find($uuid)->food_record()->where('calendar_date', '=', $calendar_date)->first();
     DB::beginTransaction();
     try {
         if ($user_food != null) {
             $details = $user_food->food_detail;
             foreach ($details as $detail) {
                 $detail->delete();
             }
             $user_food->delete();
         }
         DB::commit();
         return "success";
     } catch (\Exception $e) {
         DB::rollback();
         return "fail";
     }
 }
Ejemplo n.º 2
0
 public function post_user_soap(Request $request)
 {
     $uuid = Session::get('uuid');
     $uid = Auth::user()->id;
     $calendar_date = Session::get('calendar_date');
     $user_soap = UserSoap::where('hospital_no_uuid', '=', $uuid)->first();
     $user_id = Auth::User()->id;
     $bsugar = HospitalNo::find($uuid)->blood_sugar()->where('calendar_date', '=', $calendar_date)->first();
     DB::beginTransaction();
     try {
         if ($bsugar == null && $calendar_date != null) {
             $bsugar = new BloodSugar();
             $bsugar->calendar_date = $calendar_date;
             $bsugar->early_morning = null;
             $bsugar->morning = null;
             $bsugar->breakfast_before = null;
             $bsugar->breakfast_after = null;
             $bsugar->lunch_before = null;
             $bsugar->lunch_after = null;
             $bsugar->dinner_before = null;
             $bsugar->dinner_after = null;
             $bsugar->sleep_before = null;
             $bsugar->note = null;
             $bsugar->hospital_no_uuid = $uuid;
             $bsugar->user_id = $user_id;
             $bsugar->save();
         } else {
             if ($user_soap == null) {
                 $user_soap = new UserSoap();
             }
             $user_soap->hospital_no_uuid = $uuid;
             $user_soap->s_text = $request->s_text;
             $user_soap->o_text = $request->o_text;
             $user_soap->a_text = $request->a_text;
             $user_soap->p_text = $request->p_text;
             $user_soap->e_text = $request->e_text;
             $user_soap->r_text = $request->r_text;
             $user_soap->health_date = $request->health_date;
             $user_soap->soa_nurse_class_pks = $request->soa_nurse_class_pks;
             if (isset($request["confirm"]) && $request->confirm == "true") {
                 $user_soap->is_finished = true;
             } else {
                 $user_soap->is_finished = false;
             }
             $user_soap->save();
         }
         $user_soap_history = new UserSoapHistory();
         $user_soap_history->s_text = $request->s_text;
         $user_soap_history->o_text = $request->o_text;
         $user_soap_history->a_text = $request->a_text;
         $user_soap_history->p_text = $request->p_text;
         $user_soap_history->e_text = $request->e_text;
         $user_soap_history->r_text = $request->r_text;
         $user_soap_history->health_date = $request->health_date;
         $user_soap_history->user_id = Auth::user()->id;
         $user_soap_history->created_at = $user_soap->created_at;
         $user_soap_history->soa_nurse_class_pks = $request->soa_nurse_class_pks;
         if (isset($request["confirm"]) && $request->confirm == "true") {
             $user_soap_history->is_finished = true;
         } else {
             $user_soap_history->is_finished = false;
         }
         if ($user_soap != null) {
             $user_soap_history->user_soap_pk = $user_soap->user_soap_pk;
         }
         if ($bsugar != null) {
             $user_soap_history->blood_sugar_pk = $bsugar->blood_sugar_pk;
         }
         if (isset($request["history"])) {
             $history = $user_soap->history()->find($request["history"]);
             if ($history != null) {
                 $user_soap_history->old_pk = $history->user_soap_history_pk;
                 $history->is_visible = 0;
                 $history->save();
             }
         }
         $user_soap_history->save();
         if ($user_soap->is_finished == true) {
             // 完成
             $buildcase = Buildcase::where('hospital_no_uuid', '=', $uuid)->orderBy('build_at', 'desc')->first();
             if ($buildcase) {
                 $buildcase->soap_status = 1;
                 $buildcase->save();
             }
             $buildcase = Buildcase::where('hospital_no_uuid', '=', $uuid)->where('duty', '=', $uid)->first();
             if ($buildcase) {
                 $buildcase->duty_status = 2;
                 $buildcase->save();
             }
             $buildcase = Buildcase::where('hospital_no_uuid', '=', $uuid)->where('nurse', '=', $uid)->first();
             if ($buildcase) {
                 $buildcase->nurse_status = 2;
                 $buildcase->save();
             }
             $buildcase = Buildcase::where('hospital_no_uuid', '=', $uuid)->where('dietitian', '=', $uid)->first();
             if ($buildcase) {
                 $buildcase->dietitian_status = 2;
                 $buildcase->save();
             }
         } else {
             // 暫存
             $buildcase = Buildcase::where('hospital_no_uuid', '=', $uuid)->orderBy('build_at', 'desc')->first();
             if ($buildcase) {
                 $buildcase->soap_status = 0;
                 $buildcase->save();
             }
             $buildcase = Buildcase::where('hospital_no_uuid', '=', $uuid)->where('duty', '=', $uid)->first();
             if ($buildcase) {
                 $buildcase->duty_status = 1;
                 $buildcase->save();
             }
             $buildcase = Buildcase::where('hospital_no_uuid', '=', $uuid)->where('nurse', '=', $uid)->first();
             if ($buildcase) {
                 $buildcase->nurse_status = 1;
                 $buildcase->save();
             }
             $buildcase = Buildcase::where('hospital_no_uuid', '=', $uuid)->where('dietitian', '=', $uid)->first();
             if ($buildcase) {
                 $buildcase->dietitian_status = 1;
                 $buildcase->save();
             }
         }
         DB::commit();
         return "success /bdata/{$uuid}";
     } catch (\Exception $e) {
         DB::rollback();
         return "{$e}";
     }
 }
 /**
  * Store a newly created resource in storage.
  *
  * @param Request $request
  * @return Response
  */
 public function store(Request $request)
 {
     // validate
     $this->validate($request, ['account' => 'required|alpha_num|size:18|unique:users,account']);
     $this->validate($request, Patientprofile::rules());
     $this->validate($request, CaseCare::rules());
     DB::beginTransaction();
     try {
         // users
         $user = new User();
         $user->account = trim($request->account);
         $user->name = $request->pp_name;
         $user->password = Hash::make($user->account);
         $user->pid = $request->pp_patientid;
         $user->position = '患者';
         $user->phone = $request->pp_mobile1;
         $user->email = $request->pp_email;
         $user->save();
         // patientprofile1
         $patientprofile = new Patientprofile();
         $patientprofile->user_id = $user->id;
         $patientprofile->pp_patientid = trim($request->pp_patientid);
         $patientprofile->pp_birthday = $request->pp_birthday;
         $patientprofile->pp_age = $request->pp_age;
         $patientprofile->pp_sex = $request->pp_sex;
         $patientprofile->pp_height = $request->pp_height;
         $patientprofile->pp_weight = $request->pp_weight;
         $patientprofile->pp_tel1 = $request->pp_tel1;
         $patientprofile->pp_tel2 = $request->pp_tel2;
         $patientprofile->pp_mobile1 = $request->pp_mobile1;
         $patientprofile->pp_mobile2 = $request->pp_mobile2;
         $patientprofile->pp_area = $request->pp_area;
         $patientprofile->pp_area_other = $request->pp_area_other;
         $patientprofile->pp_doctor = $request->pp_doctor;
         $patientprofile->pp_remark = $request->pp_remark;
         $patientprofile->pp_source = $request->pp_source;
         $patientprofile->pp_source_other = $request->pp_source_other;
         $patientprofile->pp_occupation = $request->pp_occupation;
         $patientprofile->pp_occupation_other = $request->pp_occupation_other;
         $patientprofile->pp_address = $request->pp_address;
         $patientprofile->pp_email = $request->pp_email;
         $patientprofile->educator = Auth::user()->id;
         $patientprofile->save();
         // casecare
         $casecare = new CaseCare();
         $casecare->patientprofile1_id = $patientprofile->id;
         $casecare->cc_patientid = trim($request->pp_patientid);
         $casecare->cc_contactor = $request->cc_contactor;
         $casecare->cc_contactor = $request->cc_contactor;
         $casecare->cc_contactor_tel = $request->cc_contactor_tel;
         $casecare->cc_language = $request->cc_language;
         $casecare->cc_mdate = $request->cc_mdate;
         $casecare->cc_mdatem = $request->cc_mdatem;
         $casecare->cc_type = $request->cc_type;
         $casecare->cc_type_other = $request->cc_type_other;
         $casecare->cc_ibw = $request->cc_ibw;
         $casecare->cc_bmi = $request->cc_bmi;
         $casecare->cc_waist = $request->cc_waist;
         $casecare->cc_butt = $request->cc_butt;
         if ($request->cc_status) {
             $casecare->cc_status = ($request->cc_status_c1 ? "1" : "0") . ($request->cc_status_c2 ? "1" : "0") . ($request->cc_status_c3 ? "1" : "0") . ($request->cc_status_c4 ? "1" : "0") . ($request->cc_status_c5 ? "1" : "0");
             $casecare->cc_status_other = $request->cc_status_other;
         } else {
             $casecare->cc_status = "";
             $casecare->cc_status_other = "";
         }
         $casecare->cc_drink = $request->cc_drink;
         $casecare->cc_wine = $request->cc_wine;
         $casecare->cc_wineq = $request->cc_wineq;
         $casecare->cc_smoke = $request->cc_smoke == 1 && $request->cc_smoke_time > 0 ? $request->cc_smoke_time : $request->cc_smoke;
         $casecare->cc_mh = $request->cc_mh;
         $casecare->cc_fh = $request->cc_fh;
         $casecare->cc_fh_desc = $request->cc_fh_desc;
         $casecare->cc_drug_allergy = $request->cc_drug_allergy;
         $casecare->cc_drug_allergy_name = $request->cc_drug_allergy_name;
         $casecare->cc_activity = $request->cc_activity;
         $casecare->cc_medicaretype = $request->cc_medicaretype;
         $casecare->cc_jobtime = $request->cc_jobtime;
         if ($request->cc_current_use) {
             $casecare->cc_current_use = ($request->cc_current_use1 ? "1" : "0") . ($request->cc_current_use2 ? "1" : "0") . ($request->cc_current_use3 ? "1" : "0") . ($request->cc_current_use4 ? "1" : "0") . ($request->cc_current_use5 ? "1" : "0");
             $casecare->cc_starty = $request->cc_starty;
             $casecare->cc_startm = $request->cc_startm;
         } else {
             $casecare->cc_current_use = "";
             $casecare->cc_starty = -1;
             $casecare->cc_startm = -1;
         }
         if ($request->cc_hinder) {
             $casecare->cc_hinder = ($request->cc_hinder_1 ? "1" : "0") . ($request->cc_hinder_2 ? "1" : "0") . ($request->cc_hinder_3 ? "1" : "0") . ($request->cc_hinder_4 ? "1" : "0") . ($request->cc_hinder_5 ? "1" : "0") . ($request->cc_hinder_6 ? "1" : "0") . ($request->cc_hinder_7 ? "1" : "0") . ($request->cc_hinder_8 ? "1" : "0") . ($request->cc_hinder_9 ? "1" : "0");
             $casecare->cc_hinder_desc = $request->cc_hinder_desc;
         } else {
             $casecare->cc_hinder = "";
             $casecare->cc_hinder_desc = "";
         }
         $casecare->cc_act_time = $request->cc_act_time;
         $casecare->cc_act_times = $request->cc_act_times;
         $casecare->cc_act_kind = $request->cc_act_kind;
         $casecare->cc_act_other = $request->cc_act_other;
         $casecare->cc_edu = $request->cc_edu;
         $casecare->cc_careself = $request->cc_careself;
         $casecare->cc_careself_name = $request->cc_careself_name;
         $casecare->cc_careman = $request->cc_careman;
         $casecare->cc_careman_tel = $request->cc_careman_tel;
         if ($request->cc_usebsm) {
             $casecare->cc_usebsm = $request->cc_usebsm_name;
         }
         $casecare->cc_usebsm_frq = $request->cc_usebsm_frq;
         if ($request->cc_usebsm_frq) {
             // by month
             $casecare->cc_usebsm_unit = $request->cc_usebsm_frq_month;
         } else {
             // by week
             $casecare->cc_usebsm_unit = $request->cc_usebsm_frq_week;
         }
         $casecare->cc_g6pd = $request->cc_g6pd;
         $casecare->cc_deathdate = $request->cc_deathdate;
         $casecare->cc_deathdatem = $request->cc_deathdatem;
         $casecare->cc_smartphone = $request->cc_smartphone;
         $casecare->cc_wifi3g = $request->cc_wifi3g;
         $casecare->cc_smartphone_family = $request->cc_smartphone_family;
         $casecare->cc_familyupload = $request->cc_familyupload;
         $casecare->cc_uploadtodm = $request->cc_uploadtodm;
         $casecare->cc_appexp = $request->cc_appexp;
         $casecare->cc_lastexam = $request->cc_lastexam;
         $casecare->save();
         // bsm 血糖仪新增
         if ($request->cc_usebsm && $request->cc_usebsm_name == 0 && $request->cc_otherbsm) {
             $bsm = new BSM();
             $bsm->bm_name = $request->cc_otherbsm;
             $bsm->bm_model = $request->cc_otherbsm;
             $bsm->save();
             $casecare = CaseCare::where('patientprofile1_id', '=', $patientprofile->id)->firstOrFail();
             $casecare->cc_usebsm = $bsm->id;
             $casecare->save();
         }
         //create the hospital_no
         while (1) {
             $uuid = uniqid('cn_');
             if (HospitalNo::find($uuid) == null) {
                 break;
             }
         }
         $hospital_no = new HospitalNo();
         $hospital_no->hospital_no_uuid = $uuid;
         $hospital_no->patient_profile_id = $patientprofile->id;
         $hospital_no->patient_user_id = $patientprofile->user_id;
         $hospital_no->nurse_user_id = Auth::user()->id;
         $hospital_no->hospital_no_displayname = substr($request->input("pp_patientid"), 0, -6) . 'xxxxxx';
         $hospital_no->save();
         //enable feature
         //            $featurs_id = Feature::where('href', '=', '/bdata') -> first() -> id;
         //            $hasfeatures = new Hasfeature();
         //            $hasfeatures -> user_id =  $patientprofile -> user_id;
         //            $hasfeatures -> feature_id =  $featurs_id;
         //            $hasfeatures -> save();
         $msg = '项目成功创建。';
         DB::commit();
         EventController::SaveEvent('patientprofile', 'store(保存)');
     } catch (\Exception $e) {
         $msg = '项目创建失败。';
         DB::rollback();
     }
     return redirect()->route('patient.index')->with('message', $msg);
 }