user; $data = Docter::where('phone', $req['phone'])->first(['id', 'name', 'avatar', 'label', 'sign', 'intro', 'service_days', 'service_persons','password', 'eva_num', 'score', 'is_then', 'created_at']); if (!empty($data)) { // 获取标签 $LabFind = []; if ($data['label']!='无'){ if(count($data['label'])!=0){ $labstr = $data['label']; $LabFind = DocterLable::whereIn('id',$labstr)->where('status',1)->select('label_name')->get(); } } $data['label'] = $LabFind; // $counts = Evaluate::where('docter_id', '=', $req['id'])->count(); $evalList = Evaluate::where('docter_id', '=', $req['id'])->get(); $counts = count($evalList); $data['eva_num'] = $counts; $soc = 0; if ($counts != 0) { $evalList = $evalList->toArray(); foreach ($evalList as $k => $v) { $soc += $v['score']; } $data['score'] = upDecimal($soc / $counts, 1); } $data['service_days'] = numDays(date('Y-m-d', strtotime($data['created_at']))); return out($data); } else { return exit_out($data, 1, '参数错误,数据不存在'); } } /** * 医生端个人信息修改 * @return mixed */ public function doctorInfoEdit() { $user = $this->user; $doctor_id = $user['id']; if (request()->isMethod('post')) { $req = request()->post(); $this->validate(request(), [ 'avatar' => 'string', 'sign' => 'max:255', // 'phone|手机号不正确' => 'regex:/^1[3456789][0-9]{9}$/', 'intro' => 'max:2555' ]); $data = []; if (isset($req['avatar']) && !empty($req['avatar'])) { $data['avatar'] = $req['avatar']; } if (isset($req['sign']) && !empty($req['sign'])) { $data['sign'] = $req['sign']; } if (isset($req['intro']) && !empty($req['intro'])) { $data['intro'] = $req['intro']; } if (empty($data)) { return out(); } if ($doctor_id) { $save = Docter::where('id', $doctor_id)->update($data); return out(); } } else { // get提交哈 $list = Docter::where('id', '=', $doctor_id)->first()->toArray(); // 头像,个人标签,服务简介展示 $data = [ 'avatar' => !empty($list['avatar'])?$list['avatar']:'', 'sign' => !empty($list['sign'])?$list['sign']:'', 'intro' => !empty($list['intro'])?$list['intro']:'', ]; return out($data); } } /** * 修改密码 * @return \Illuminate\Http\JsonResponse * @author Liu-Yh * Create By 2020/11/4 18:19 */ public function passwordEdit() { $user = $this->user; $doctor_id = $user['id']; $req = request()->post(); $this->validate(request(), [ 'lis:原密码' => 'string', 'newpassword:新密码' => 'string', ]); $data = []; $data = Docter::where('id', '=', $doctor_id)->first()->toArray(); $password = md5(md5(md5($req['newpassword']))); if ($data['password'] == '' || !$data['password']) { // 说明第一次直接跳过 $save = Docter::where('id', $doctor_id)->update(['password' => $password]); return out(); } else { if(isset($req['lis'])&&!empty($req['lis'])){ $oldpassword = md5(md5(md5($req['lis']))); if ($oldpassword != $data['password']) { return out('', '401', '旧密码错误'); } else { $save = Docter::where('id', $doctor_id)->update(['password' => $password]); return out(); } }else{ return out('', '401', '请输入旧密码'); } } } /** * 基本/更多设置读取(废弃) * @return \Illuminate\Http\JsonResponse * @author Yuanhang Liu */ public function getSettingList() { $req = request()->post(); $this->validate(request(), [ 'type' => 'required|integer|in:1,2', 'service_type' => 'integer' ]); $user = $this->user; $doctor_id = (new Commons)->getUserIdByDoctorId($user['phone']); $finds = Docter::select(['is_chat', 'is_phone', 'is_appoint'])->where('id', $doctor_id)->first()->toArray(); $finds['is_chat'] = $finds['is_chat'] == 0 ? false : true; $finds['is_phone'] = $finds['is_phone'] == 0 ? false : true; $finds['is_appoint'] = $finds['is_appoint'] == 0 ? false : true; $finds['is_chat_status'] = $this->getStyStatus(1); $finds['is_phone_status'] = $this->getStyStatus(2); $finds['is_appoint_status'] = $this->getStyStatus(3); if ($req['type'] == 2) { (array)$list = []; // 获取显示状态: $list['show'] = $finds; // 获取电话咨询时间 $phone_fins = DocterTimes::where(['docter_id' => $doctor_id, 'type' => 1])->first(); if ($phone_fins) { $phone_fins = $phone_fins->toArray(); } else { $phone_fins = []; } $list['list']['phone'] = $phone_fins; // 图文咨询时间 $pic_fins = DocterTimes::where(['docter_id' => $doctor_id, 'type' => 2])->first(); if ($pic_fins) { $pic_fins = $pic_fins->toArray(); } else { $pic_fins = []; } $list['list']['chat'] = $pic_fins; // 门诊咨询时间 $men_fins = DocterTimes::where(['docter_id' => $doctor_id, 'type' => 3])->get(); if ($men_fins) { $men_fins = $men_fins->toArray(); } else { $men_fins = []; } $list['list']['men'] = $men_fins; // 获取医院 $org = DocterOrganization::with('organization')->where('docter_id', $doctor_id)->get(); $org_pre = []; $org_pres = []; if ($org) { $org = $org->toArray(); foreach ($org as $k => $v) { $org_pres[$k]['id'] = $v['organization']['id']; $org_pres[$k]['name'] = $v['organization']['name']; $org_pre[$k]['name'] = $v['organization']['name']; } } $list['org'] = $org_pre; $list['orgs'] = $org_pres; $times = TimePeriod::get(); if ($times) { $times = $times->toArray(); $newTimes = []; foreach ($times as $k => $v) { $newTimes[$k]['id'] = $v['id']; $newTimes[$k]['name'] = $v['start_time_period'] . ' - ' . $v['end_time_period']; $newTimes[$k]['checked'] = false; } $times1 = []; $times2 = []; $times3 = []; foreach ($newTimes as $k => $v) { if ($k >= 0 && $k < 16) { array_push($times1, $v); } else if ($k >= 16 && $k < 32) { array_push($times2, $v); } else { array_push($times3, $v); } } $list['times']['list1'] = $times1; $list['times']['list2'] = $times2; $list['times']['list3'] = $times3; } else { $times = []; } return out($list); } return out($finds); } /** * 更多设置读取,新的 * @return \Illuminate\Http\JsonResponse * @author Liu-Yh * Create By 2020/12/16 11:10 */ public function getSettingListnew() { $req = request()->post(); $this->validate(request(), [ 'type' => 'required|integer|in:1,2', 'service_type' => 'integer' ]); $user = $this->user; $doctor_id = (new Commons)->getUserIdByDoctorId($user['phone']); $finds = Docter::select(['is_chat', 'is_phone', 'is_appoint'])->where('id', $doctor_id)->first()->toArray(); $finds['is_chat'] = $finds['is_chat'] == 0 ? false : true; $finds['is_phone'] = $finds['is_phone'] == 0 ? false : true; $finds['is_appoint'] = $finds['is_appoint'] == 0 ? false : true; $finds['is_chat_status'] = $this->getStyStatus(1); $finds['is_phone_status'] = $this->getStyStatus(2); $finds['is_appoint_status'] = $this->getStyStatus(3); if ($req['type'] == 2) { (array)$list = []; // 获取显示状态: $list['show'] = $finds; // 获取电话咨询时间 $phone_fins = DocterTimes::where(['docter_id' => $doctor_id, 'type' => 1])->first(); if ($phone_fins) { $phone_fins = $phone_fins->toArray(); $phone_fins['service_time'] = json_decode($phone_fins['service_time']); } else { $phone_fins = []; } $list['list']['phone'] = $phone_fins; // 图文咨询时间 $pic_fins = DocterTimes::where(['docter_id' => $doctor_id, 'type' => 2])->first(); if ($pic_fins) { $pic_fins = $pic_fins->toArray(); $pic_fins['service_time'] = json_decode($pic_fins['service_time']); } else { $pic_fins = []; } $list['list']['chat'] = $pic_fins; // 门诊咨询时间 $newLists=[]; $men_fins = DocterSetting::where(['docter_id' => $doctor_id, 'type' => 1])->orderBy('org_id','asc')->get(); $org = DocterOrganization::with('organization')->where(['docter_id'=>$doctor_id,'state'=>1])->orderBy('organization_id','asc')->get(); if ($org) { $org = $org->toArray(); foreach ($org as $k => $v) { $org_pre[$k]['id'] = $v['organization']['id']; $org_pre[$k]['name'] = $v['organization']['name']; } } if ($men_fins) { $men_fins = $men_fins->toArray(); foreach ($men_fins as $k => $v) { $men_fins[$k]['service_time'] = json_decode($v['service_time'],true); } $org_list=[]; foreach ($org as $k=>$v){ $org_list[$k]['docter_id'] = $doctor_id; $org_list[$k]['type'] = 1; $org_list[$k]['status'] = 2; $org_list[$k]['show_days'] = ''; $org_list[$k]['service_times'] = ''; $org_list[$k]['service_num'] = ''; $org_list[$k]['org_id'] = $v['organization']['id']; $org_list[$k]['org_name'] = $v['organization']['name']; $org_list[$k]['appoint_price'] = ''; $org_list[$k]['service_time'] = [ 1=>['amStartTime'=>'','amEndTime'=>'','amPerson'=>''], 2=>['pmStartTime'=>'','pmEndTime'=>'','pmPerson'=>''], 3=>['nightStartTime'=>'','nightEndTime'=>'','nightPerson'=>''], ]; } foreach ($org_list as $k=>$v){ foreach ($men_fins as $kk=>$vv){ if ($v['org_id']==$vv['org_id']){ $org_list[$k]['docter_id'] = $doctor_id; $org_list[$k]['type'] = 1; $org_list[$k]['status'] = 2; $org_list[$k]['show_days'] = $vv['show_days']; $org_list[$k]['service_times'] = $vv['service_times']; $org_list[$k]['service_num'] = $vv['service_num']; $org_list[$k]['org_id'] = $vv['org_id']; $org_list[$k]['org_name'] = $v['org_name']; $org_list[$k]['appoint_price'] = $vv['appoint_price']; $org_list[$k]['service_time'] = [ 1=>['amStartTime'=>$vv['service_time'][1]['amStartTime'],'amEndTime'=>$vv['service_time'][1]['amEndTime'],'amPerson'=>$vv['service_time'][1]['amPerson']], 2=>['pmStartTime'=>$vv['service_time'][2]['pmStartTime'],'pmEndTime'=>$vv['service_time'][2]['pmEndTime'],'pmPerson'=>$vv['service_time'][2]['pmPerson']], 3=>['nightStartTime'=>$vv['service_time'][3]['nightStartTime'],'nightEndTime'=>$vv['service_time'][3]['nightEndTime'],'nightPerson'=>$vv['service_time'][3]['nightPerson']], ]; } } } $newLists = $org_list; } else { $men_fins = []; foreach ($org as $k=>$v){ $newLists[$k]['docter_id'] = $doctor_id; $newLists[$k]['type'] = 1; $newLists[$k]['status'] = 2; $newLists[$k]['show_days'] = ''; $newLists[$k]['service_times'] = ''; $newLists[$k]['service_num'] = ''; $newLists[$k]['org_id'] = $v['organization']['id']; $newLists[$k]['org_name'] = $v['organization']['name']; $newLists[$k]['appoint_price'] = ''; $newLists[$k]['service_time'] = [ 1=>['amStartTime'=>'','amEndTime'=>'','amPerson'=>''], 2=>['pmStartTime'=>'','pmEndTime'=>'','pmPerson'=>''], 3=>['nightStartTime'=>'','nightEndTime'=>'','nightPerson'=>''], ]; } } // 获取医院 // $org_pre = []; $list['list']['men'] = $newLists; // $list['org'] = $org_pre; return out($list); } return out($finds); } /** * 获取审核状态 * @param $type * @return bool */ public function getStyStatus($type) { $user = $this->user; $doctor_id = $user['id']; $where['docter_id'] = $doctor_id; $where['service_type'] = $type; $statusD = ServiceApply::where($where)->first(); if ($statusD) { return $statusD; } else { return false; } } /** * 基本/更多设置修改 * @return \Illuminate\Http\JsonResponse * @author Yuanhang Liu */ public function saveSettingList() { $req = request()->post(); $this->validate(request(), [ 'type' => 'required|integer|in:1,2', ]); $data = json_decode($req['data'], true); $user = $this->user; $doctor_id = $user['id']; $finds = Docter::select(['is_chat', 'is_phone', 'is_appoint'])->where('id', $doctor_id)->first(); $flag = false; if ($req['type'] == 1) { // 修改基本信息 $list = []; isset($data['is_chat']) ? $data['is_chat'] == true ? $list['is_chat'] = 1 : $list['is_chat'] = 0 : ''; isset($data['is_phone']) ? $data['is_phone'] == true ? $list['is_phone'] = 1 : $list['is_phone'] = 0 : ''; isset($data['is_appoint']) ? $data['is_appoint'] == true ? $list['is_appoint'] = 1 : $list['is_appoint'] = 0 : ''; Docter::where('id', $doctor_id)->update($list); return out(); } else if ($req['type'] == 2) { Db::beginTransaction(); try { // 修改更多信息 if ($finds['is_chat'] == 0) { if (isset($data['is_chat']) && !empty($data['is_chat'])) { unset($data['is_chat']); } } else { if (isset($data['is_chat']) && !empty($data['is_chat'])) { DocterServiceTimes::where(['docter_id'=>$doctor_id,'type'=>2])->delete(); $save_data = $data['is_chat']; $newData = []; $serviceData = []; $newData['base_price'] = $save_data['base_price']; $newData['step_price'] = $save_data['step_price']; $serviceData[0]['docter_id']=$doctor_id; $serviceData[0]['type']=2; $serviceData[0]['start_time_period']=$save_data['amStartTime']; $serviceData[0]['end_time_period']=$save_data['amEndTime']; $serviceData[0]['start_time_line']=str_replace(':','',$save_data['amStartTime']); $serviceData[0]['end_time_line']=str_replace(':','',$save_data['amEndTime']); $serviceData[1]['docter_id']=$doctor_id; $serviceData[1]['type']=2; $serviceData[1]['start_time_period']=$save_data['pmStartTime']; $serviceData[1]['end_time_period']=$save_data['pmEndTime']; $serviceData[1]['start_time_line']=str_replace(':','',$save_data['pmStartTime']); $serviceData[1]['end_time_line']=str_replace(':','',$save_data['pmEndTime']); $serviceData[2]['docter_id']=$doctor_id; $serviceData[2]['type']=2; $serviceData[2]['start_time_period']=$save_data['nightStartTime']; $serviceData[2]['end_time_period']=$save_data['nightEndTime']; $serviceData[2]['start_time_line']=str_replace(':','',$save_data['nightStartTime']); $serviceData[2]['end_time_line']=str_replace(':','',$save_data['nightEndTime']); $service_times = [ 1 => ['amStartTime' => $save_data['amStartTime'], 'amEndTime' => $save_data['amEndTime']], 2 => ['pmStartTime' => $save_data['pmStartTime'], 'pmEndTime' => $save_data['pmEndTime']], 3 => ['nightStartTime' => $save_data['nightStartTime'], 'nightEndTime' => $save_data['nightEndTime']], ]; $newData['service_time'] = json_encode($service_times, JSON_UNESCAPED_UNICODE); $newData['person'] = $save_data['person']; $newData['type'] = $save_data['type']; $pic_fins = DocterTimes::where(['docter_id' => $doctor_id, 'type' => 2])->first(); DocterServiceTimes::insert($serviceData); if (empty($pic_fins)) { $newData['docter_id'] = $doctor_id; DocterTimes::create($newData); } else { $pic_fins = $pic_fins->toArray(); DocterTimes::where(['id' => $pic_fins['id']])->update($newData); } } } if ($finds['is_phone'] == 0) { if (isset($data['is_phone']) && !empty($data['is_phone'])) { unset($data['is_phone']); } } else { if (isset($data['is_phone']) && !empty($data['is_phone'])) { // 存入状态为1的操作 DocterServiceTimes::where(['docter_id'=>$doctor_id,'type'=>1])->delete(); $save_data = $data['is_phone']; $newData = []; $serviceData = []; $newData['base_price'] = $save_data['base_price']; $newData['step_price'] = $save_data['step_price']; $serviceData[0]['docter_id']=$doctor_id; $serviceData[0]['type']=1; $serviceData[0]['start_time_period']=$save_data['amStartTime']; $serviceData[0]['end_time_period']=$save_data['amEndTime']; $serviceData[0]['start_time_line']=str_replace(':','',$save_data['amStartTime']); $serviceData[0]['end_time_line']=str_replace(':','',$save_data['amEndTime']); $serviceData[1]['docter_id']=$doctor_id; $serviceData[1]['type']=1; $serviceData[1]['start_time_period']=$save_data['pmStartTime']; $serviceData[1]['end_time_period']=$save_data['pmEndTime']; $serviceData[1]['start_time_line']=str_replace(':','',$save_data['pmStartTime']); $serviceData[1]['end_time_line']=str_replace(':','',$save_data['pmEndTime']); $serviceData[2]['docter_id']=$doctor_id; $serviceData[2]['type']=1; $serviceData[2]['start_time_period']=$save_data['nightStartTime']; $serviceData[2]['end_time_period']=$save_data['nightEndTime']; $serviceData[2]['start_time_line']=str_replace(':','',$save_data['nightStartTime']); $serviceData[2]['end_time_line']=str_replace(':','',$save_data['nightEndTime']); $service_times = [ 1 => ['amStartTime' => $save_data['amStartTime'], 'amEndTime' => $save_data['amEndTime']], 2 => ['pmStartTime' => $save_data['pmStartTime'], 'pmEndTime' => $save_data['pmEndTime']], 3 => ['nightStartTime' => $save_data['nightStartTime'], 'nightEndTime' => $save_data['nightEndTime']], ]; $newData['service_time'] = json_encode($service_times, JSON_UNESCAPED_UNICODE); $newData['person'] = $save_data['person']; $newData['type'] = $save_data['type']; // 图文咨询时间 $phone_fins = DocterTimes::where(['docter_id' => $doctor_id, 'type' => 1])->first(); DocterServiceTimes::insert($serviceData); if (empty($phone_fins)) { $newData['docter_id'] = $doctor_id; DocterTimes::create($newData); } else { $phone_fins = $phone_fins->toArray(); DocterTimes::where(['id' => $phone_fins['id']])->update($newData); } } } if ($finds['is_appoint'] == 0) { if (isset($data['is_appoint']) && !empty($data['is_appoint'])) { unset($data['is_appoint']); } } else { // 此时可能有两个医院,为一个数组,一个一个入库 if (isset($data['is_appoint']) && !empty($data['is_appoint'])) { $save_data = $data['is_appoint']; $setting_data = []; $times_data = []; // 查询除本地来 $edutime = DocterSetting::where(['docter_id' => $doctor_id, 'type' => 1])->get(); if ($edutime) { $newedu = []; foreach ($edutime as $k => $v) { $newedu[$k]['org_id'] = $v['org_id']; $newedu[$k]['service_times'] = $v['service_times']; } $flag_arr = []; foreach ($newedu as $k => $v) { foreach ($save_data as $kk => $vv) { if ($v['org_id'] == $vv['org_id']) { if ($v['service_times'] != $vv['service_times']) { $flag_arr[] = $vv['org_id']; } } } } $flag = !empty($flag_arr) ? $flag_arr : false; } foreach ($save_data as $k => $v) { if (!isset($v['service_times'])||empty($v['service_times'])){ unset($save_data[$k]); }else{ DocterSetting::where('docter_id', '=', $doctor_id)->where('org_id', $v['org_id'])->delete(); TimePeriod::where('docter_id', '=', $doctor_id)->where('org_id', $v['org_id'])->delete(); $setting_data[$k]['docter_id'] = $doctor_id; $setting_data[$k]['type'] = 1; $setting_data[$k]['status'] = 2; $setting_data[$k]['appoint_price'] = $v['base_price']; $setting_data[$k]['show_days'] = $v['show_days']; $setting_data[$k]['service_times'] = $v['service_times']; $setting_data[$k]['service_num'] = $v['service_num']; $setting_data[$k]['org_id'] = $v['org_id']; $service_times = [ 1 => ['amStartTime' => $v['amStartTime'], 'amEndTime' => $v['amEndTime'], 'amPerson' => $v['amPerson']], 2 => ['pmStartTime' => $v['pmStartTime'], 'pmEndTime' => $v['pmEndTime'], 'pmPerson' => $v['pmPerson']], 3 => ['nightStartTime' => $v['nightStartTime'], 'nightEndTime' => $v['nightEndTime'], 'nightPerson' => $v['nightPerson']], ]; $setting_data[$k]['service_time'] = json_encode($service_times, JSON_UNESCAPED_UNICODE); $setting_data[$k]['created_at'] = date('Y-m-d H:i:s', time()); $setting_data[$k]['updated_at'] = date('Y-m-d H:i:s', time()); // 第二步, 根据时长去生成24小时的时间段,也要存id $timeList = $this->getTimeHoures($v['service_times']); foreach ($timeList as $kk => $vv) { $times_data[$k][$kk]['type'] = 2; $times_data[$k][$kk]['docter_id'] = $doctor_id; $times_data[$k][$kk]['start_time_period'] = $vv[0]; $times_data[$k][$kk]['end_time_period'] = $vv[1]; $times_data[$k][$kk]['org_id'] = $v['org_id']; } } } if($times_data&&$setting_data){ foreach ($times_data as $k => $v) { TimePeriod::insert($v); } DocterSetting::insert($setting_data); } } } DB::commit(); } catch (\Exception $e) { DB::rollBack(); return out('', 500, $e->getMessage()); } catch (\PDOException $e) { DB::rollBack(); return out('', 500, $e->getMessage()); } if ($finds['is_appoint'] != 0 && isset($data['is_appoint']) && !empty($data['is_appoint'])) { /*去重新更新,自定义排班表,和排班详情表,因为时间段id发生了变化!*/ if ($flag != false) { $weekList = WeekSchedule::where('docter_id', $doctor_id)->get(); $moth_date = $this->date_bool(); $counts = Schedule::where('schedule_date', '>=', $moth_date[0]['date'])->where('schedule_date', '<=', end($moth_date)['date'])->get(); if ($weekList && $counts) { $weekList = $weekList->toArray(); $selfScheduleList = SelfSchedule::where('docter_id', $doctor_id)->whereIn('organization_id', $flag)->get(); // 修改自定义表 不存在则不管就好 SchedulePeriod::where('docter_id', '=', $doctor_id)->delete(); if ($selfScheduleList) { $selfScheduleList = $selfScheduleList->toArray(); $selfList = []; foreach ($selfScheduleList as $k => $v) { if (!isset($selfList[$v['schedule_date']])) { $selfList[$v['schedule_date']] = $v; if ($v['type'] == 1) { $selfList[$v['schedule_date']]['ident']['zao_id'] = $v['organization_id']; $selfList[$v['schedule_date']]['ident']['xia_id'] = 0; $selfList[$v['schedule_date']]['ident']['wan_id'] = 0; } else if ($v['type'] == 2) { $selfList[$v['schedule_date']]['ident']['zao_id'] = 0; $selfList[$v['schedule_date']]['ident']['xia_id'] = $v['organization_id']; $selfList[$v['schedule_date']]['ident']['wan_id'] = 0; } else { $selfList[$v['schedule_date']]['ident']['zao_id'] = 0; $selfList[$v['schedule_date']]['ident']['xia_id'] = 0; $selfList[$v['schedule_date']]['ident']['wan_id'] = $v['organization_id']; } } else { if ($v['type'] == 1) { $selfList[$v['schedule_date']]['ident']['zao_id'] = $v['organization_id']; } else if ($v['type'] == 2) { $selfList[$v['schedule_date']]['ident']['xia_id'] = $v['organization_id']; } else { $selfList[$v['schedule_date']]['ident']['wan_id'] = $v['organization_id']; } } } // 拼接数据交给saveDay来操作 $saveDatas = []; SelfSchedule::where('docter_id', $doctor_id)->delete(); foreach ($selfList as $k => $v) { $saveDatas[$k]['schedule_date'] = $v['schedule_date']; $saveDatas[$k]['week'] = $v['week']; if ($v['ident']['zao_id']) { $saveDatas[$k]['type'] = 1; $saveDatas[$k]['organization_id'] = $v['ident']['zao_id']; $saveSelf = $this->saveDay($saveDatas[$k]); if (!$saveSelf) { return out('', 500, '修改排班失败!'); } } if ($v['ident']['xia_id']) { $saveDatas[$k]['type'] = 2; $saveDatas[$k]['organization_id'] = $v['ident']['xia_id']; $saveSelf = $this->saveDay($saveDatas[$k]); if (!$saveSelf) { return out('', 500, '修改排班失败!'); } } if ($v['ident']['wan_id']) { $saveDatas[$k]['type'] = 3; $saveDatas[$k]['organization_id'] = $v['ident']['wan_id']; $saveSelf = $this->saveDay($saveDatas[$k]); if (!$saveSelf) { return out('', 500, '修改排班失败!'); } } } } Db::beginTransaction(); try { $selfScheduleList = SelfSchedule::where('docter_id', $doctor_id)->whereIn('organization_id', $flag)->get(); foreach ($counts as $kk => $vv) { $schedule[$kk]['schedule_date'] = $vv['schedule_date']; $schedule[$kk]['week'] = $vv['week']; $sid[$kk] = $vv['id']; } // 占用效率 $scheduleLists = []; foreach ($sid as $kk => $vv) { foreach ($weekList as $k => $v) { if ($schedule[$kk]['week'] == $v['week']) { if ($v['type'] == 1) { $times = $this->num_time($v['organization_id'], 1); if (!$times) { return out('', 500, "请先在排班设置中填写本机构的时间段"); } $maf = $this->getMaf($vv, $times, ['organization_id' => $v['organization_id'], 'schedule_date' => $schedule[$kk]['schedule_date'], 'type' => 1], $doctor_id); if ($maf) { foreach ($maf as $os) { $scheduleLists[] = $os; } } } if ($v['type'] == 2) { $times = $this->num_time($v['organization_id'], 2); if (!$times) { return out('', 500, "请先在排班设置中填写本机构的时间段"); } $maf = $this->getMaf($vv, $times, ['organization_id' => $v['organization_id'], 'schedule_date' => $schedule[$kk]['schedule_date'], 'type' => 2], $doctor_id); if ($maf) { foreach ($maf as $os) { $scheduleLists[] = $os; } } } if ($v['type'] == 3) { $times = $this->num_time($v['organization_id'], 3); if (!$times) { return out('', 500, "请先在排班设置中填写本机构的时间段"); } $maf = $this->getMaf($vv, $times, ['organization_id' => $v['organization_id'], 'schedule_date' => $schedule[$kk]['schedule_date'], 'type' => 3], $doctor_id); if ($maf) { foreach ($maf as $os) { $scheduleLists[] = $os; } } } } } } // 查询重复替换 $chong = []; if ($selfScheduleList && $scheduleLists) { foreach ($scheduleLists as $k => $v) { foreach ($selfScheduleList as $kk => $vv) { if ($v['schedule_date'] == $vv['schedule_date']) { $chong[$kk]['schedule_id'] = $v['schedule_id']; $chong[$kk]['docter_id'] = $v['docter_id']; $chong[$kk]['order_num'] = $v['order_num']; $chong[$kk]['organization_id'] = $vv['organization_id']; $chong[$kk]['time_period_id'] = $vv['time_period_id']; $chong[$kk]['type'] = $vv['type']; $chong[$kk]['schedule_date'] = $vv['schedule_date']; unset($scheduleLists[$k]); } } } } $listPeriod = array_merge($chong, $scheduleLists); SchedulePeriod::insert($listPeriod); DB::commit(); } catch (\Exception $e) { DB::rollBack(); return out('', 500, '2' . $$e->getMessage()); } catch (\PDOException $e) { DB::rollBack(); return out('', 500, '2' . $e->getMessage()); } } } } } return out(); } /** * 计算24小时的时间区间段 * @param $minute 分钟比如:15 * @return array */ public function getTimeHoures($minute) { // 可选10分钟,15分钟,20分钟,30分钟,1个小时 $start = strtotime(date("Y-m-d 00:00:00")); $end = strtotime(date("Y-m-d 23:59:59")); $returnArr = []; for ($time = $start; $time <= $end; $time = $time + $minute * 60) { array_push($returnArr, date("H:i", $time)); } $newList = []; // for($i=0;$ipost(); $data = json_decode($req['data'], true); $user = $this->user; $doctor_id = $user['id']; Db::beginTransaction(); try { if (isset($data) && !empty($data)) { $setting_data = []; $times_data = []; foreach ($data as $k => $v) { DocterSetting::where('docter_id', '=', $doctor_id)->where('org_id', $v['org_id'])->delete(); TimePeriod::where('docter_id', '=', $doctor_id)->where('org_id', $v['org_id'])->delete(); $setting_data[$k]['docter_id'] = $doctor_id; $setting_data[$k]['type'] = 1; $setting_data[$k]['status'] = 2; $setting_data[$k]['show_days'] = $v['show_days']; $setting_data[$k]['service_times'] = $v['service_times']; $setting_data[$k]['service_num'] = $v['service_num']; $setting_data[$k]['org_id'] = $v['org_id']; $service_times = [ 1 => ['amStartTime' => $v['amStartTime'], 'amEndTime' => $v['amEndTime'], 'amPerson' => $v['amPerson']], 2 => ['pmStartTime' => $v['pmStartTime'], 'pmEndTime' => $v['pmEndTime'], 'pmPerson' => $v['pmPerson']], 3 => ['nightStartTime' => $v['nightStartTime'], 'nightEndTime' => $v['nightEndTime'], 'nightPerson' => $v['nightPerson']], ]; $setting_data[$k]['service_time'] = json_encode($service_times, JSON_UNESCAPED_UNICODE); $setting_data[$k]['created_at'] = date('Y-m-d H:i:s', time()); $setting_data[$k]['updated_at'] = date('Y-m-d H:i:s', time()); // 第二步, 根据时长去生成24小时的时间段,也要存id $timeList = $this->getTimeHoures($v['service_times']); foreach ($timeList as $kk => $vv) { $times_data[$k][$kk]['type'] = 2; $times_data[$k][$kk]['docter_id'] = $doctor_id; $times_data[$k][$kk]['start_time_period'] = $vv[0]; $times_data[$k][$kk]['end_time_period'] = $vv[1]; $times_data[$k][$kk]['org_id'] = $v['org_id']; } } foreach ($times_data as $k => $v) { TimePeriod::insert($v); } DocterSetting::insert($setting_data); } DB::commit(); return out(''); } catch (\Exception $e) { DB::rollBack(); return out('', 500, $e->getMessage()); } catch (\PDOException $e) { DB::rollBack(); return out('', 500, $e->getMessage()); } } /** * 提交认证 * Auth:Yuanhang-Liu * Date:2020/10/14 15:08 * * @return \Illuminate\Http\JsonResponse */ public function addthen() { $req = request()->post(); $this->validate(request(), [ 'name|医生姓名' => 'required|max:50', 'sex|性别' => 'required|in:男,女', 'ID|身份证号' => 'required|min:16|max:18', 'works|医院信息' => 'required', 'certificate|医生照片和执业证书' => 'required|string', 'idPhoto|身份证正反面' => 'required|string', 'doctorQualification|照片和资格证书' => 'required|string', ]); if ($req['sex'] == '男') { $req['sex'] = 1; } else { $req['sex'] = 2; } // 首先获取医生姓名,性别,身份证号,照片,身份证,资格证去补全医生表 // 入库organization_ids这个数据是一条字符串,先分割成数组,如果只有一条则医生只选择了一个医院,机构id和医生id入库docter_organization(医生机构关联表) $user = $this->user; $doctor_id = $user['id']; if (!$doctor_id) { return out(null, 500, '医生信息错误!'); } $data = []; $data['name'] = $req['name']; $data['sex'] = $req['sex']; $data['card_id'] = $req['ID']; $data['practice'] = $req['certificate']; $data['card_photo'] = $req['idPhoto']; $data['is_quail'] = $req['doctorQualification']; //处理医院机构id $work = json_decode($req['works'], true); if (!$work) { return out('', '', '缺少医院'); } $off_then = DocterOrganization::where('docter_id', '=', $doctor_id)->get('id')->toArray(); $is_del = false; if ($off_then) { $newids = []; foreach ($off_then as $k => $v) { $newids[$k] = $v['id']; } $is_del = true; } $org_list = []; foreach ($work as $k => $v) { if ($v['hospital']) { $org_list[$k]['docter_id'] = $doctor_id; $org_list[$k]['organization_id'] = $v['hospital']; $org_list[$k]['offices_id'] = $v['department']; $org_list[$k]['qualifications_id'] = $v['qualifications']; $org_list[$k]['state'] = $v['state']; } } DB::beginTransaction();//开启事务 try { //补全医生表 Docter::where('id', $doctor_id)->update($data); if ($is_del) { foreach ($newids as $k => $v) { DocterOrganization::where('id', $v)->delete(); } } // 提交消息; DocterMessage::create([ 'docter_id' => $doctor_id, 'status' => 1, 'type' => 8, 'content' => '您已提交医生资质认证审核材料 ' ]); DocterOrganization::insertOrIgnore($org_list); DB::commit();//提交至数据库 return out(); } catch (\Exception $e) { DB::rollback(); return out(null, 500, $e->getMessage()); } } /** * 获取地区/联动医院 * Auth:Yuanhang-Liu * Date:2020/10/14 17:17 * * @return \Illuminate\Http\JsonResponse */ public function get_city_id() { // 查询机构! $req = request()->post(); $this->validate(request(), [ 'level_type' => 'required|in:4', 'province|省或直辖市id' => 'required_if:level_type,==,4', 'city|市' => 'required_if:level_type,==,4', 'area|区' => 'required_if:level_type,==,4', ]); // 查找下医院 // $ids_string = explode(',',$req['organizations_ids']); $province = trim($req['province']); $city = trim($req['city']); $area = trim($req['area']); $where['province_id'] = $province; $where['city_id'] = $city; $where['area_id'] = $area; $where['type'] = 1; $Organization = Organization::with('offices')->where($where)->get()->toArray(); $qulire = Qualification::where('status', 1)->get(); $newList = []; if ($Organization) { foreach ($Organization as $k => $v) { $newList[$k]['value'] = $v['id']; $newList[$k]['label'] = $v['name']; if ($v['offices']) { foreach ($v['offices'] as $kk => $vv) { $newList[$k]['children'][$kk]['value'] = $vv['id']; $newList[$k]['children'][$kk]['label'] = $vv['name']; if ($qulire) { foreach ($qulire as $p => $c) { $newList[$k]['children'][$kk]['children'][$p]['value'] = $c['id']; $newList[$k]['children'][$kk]['children'][$p]['label'] = $c['name']; } } else { unset($Organization[$k], $newList[$k]); } } } else { unset($Organization[$k], $newList[$k]); } } } return out($newList); } /** * 获取城市联动 * @return \Illuminate\Http\JsonResponse * @author Liu-Yh * Create By 2020/11/4 19:35 */ public function getCityList() { // 查询机构! $req = request()->post(); $where['status'] = 1; $data = Areas::where($where)->get(['id', 'name', 'level', 'parent_id'])->toArray(); $newData = []; foreach ($data as $k => $v) { $newData[$k]['value'] = $v['id']; $newData[$k]['label'] = $v['name']; $newData[$k]['pid'] = $v['parent_id']; } $list = $this->getTrees($newData); $list = $this->getTree($list); return out($list); } /** * 获取城市树 * @param $data * @return array */ protected function getTrees($arr, $pid = 0) { static $list = []; foreach ($arr as $key => $value) { if ($value["pid"] == $pid) { $list[] = $value; unset($arr[$key]); //删除已经排好的数据为了减少遍历的次数,当然递归本身就很费神就是了 $this->getTrees($arr, $value["value"]); } } return $list; } /** * 整合树🌲 * @param $data * @param $pId * @return string */ protected function getTree($data, $pId = 0) { $tree = []; foreach ($data as $k => $v) { if ($v['pid'] == $pId) { //父亲找到儿子 $chid = $this->getTree($data, $v['value']); if ($chid) { $v['children'] = $chid; } $tree[] = $v; unset($data[$k]); } else { unset($data[$k]); } } return $tree; } /* public function getCityList(){ // 查询机构! $req = request()->post(); $this->validate(request(), [ 'type' => 'required|in:1,2,3', 'parent_id|父级id' => 'required_if:type,==,2|required_if:type,==,3|integer', ]);//1=省,2=市,3=区 $where['level'] = $req['type']; $where['status'] = 1; if($req['type']==1){ $cityList = Areas::where($where)->get(['id','name'])->toArray(); }else if ($req['type']==2){ $where['parent_id']= $req['parent_id']; $cityList = Areas::where($where)->get(['id','name'])->toArray(); }else if ($req['type']==3){ $where['parent_id']= $req['parent_id']; $cityList = Areas::where($where)->get(['id','name'])->toArray(); }else{ return out('','','错误请求'); } return out($cityList); }*/ /** * 获取科室和资质 * @return mixed */ public function getOfferList() { // 查询机构! $req = request()->post(); $this->validate(request(), [ 'type' => 'required|in:1,2', ]);//1=科室,2=资质 $type = $req['type']; if ($type == 1) { $List = Office::get(['id', 'name'])->toArray(); } else if ($type == 2) { $List = Qualification::get(['id', 'name'])->toArray(); } else { return out('', '', '错误请求'); } return out($List); } /** * 获取我的患者列表 * Auth:Yuanhang-Liu * Date:2020/10/17 13:21 * @return \Illuminate\Http\JsonResponse */ public function userList() { $req = request()->post(); $this->validate(request(), [ 'userId' => 'integer', 'userType|用户类型' => 'integer|in:1,2,3,4,5,6,7', ]); $user = $this->user; $doctor_id = $user['id']; if (!$doctor_id) { return out(null, 500, '医生信息错误!'); } $returnList = []; $orderList = Order::with(['user'])->where('docter_id', '=', $doctor_id)->groupBy('id', 'product_type', 'user_id')->get()->toArray(); $collections = DocterUser::with('user')->where('docter_id', '=', $doctor_id)->groupBy('user_id')->get()->toArray(); $newList = []; foreach ($orderList as $k => $v) { $newList[$k]['order_id'] = $v['id']; $newList[$k]['user_id'] = $v['user_id']; $newList[$k]['order_sn'] = $v['order_sn']; $newList[$k]['nickname'] = $v['user']['nickname']; $save = UserDocter::where('user_id', '=', $v['user']['id'])->first(); if ($save) { $newList[$k]['remark'] = $save['remark']; } else { $newList[$k]['remark'] = ''; } $newList[$k]['avatar'] = $v['user']['avatar']; $newList[$k]['product_type'] = $v['product_type']; } $newcoll = []; foreach ($collections as $k => $v) { $newcoll[$k]['id'] = $v['id']; $newcoll[$k]['user_id'] = $v['user_id']; $newcoll[$k]['nickname'] = $v['user']['nickname']; $save = UserDocter::where('user_id', '=', $v['user_id'])->first(); if ($save) { $newList[$k]['remark'] = $save['remark']; } else { $newList[$k]['remark'] = ''; } $newcoll[$k]['avatar'] = $v['user']['avatar']; } $user_pic = []; $user_relation = []; $user_vaccines = []; $user_guar = []; $user_pack = []; foreach ($newList as $k => $v) { if ($v['product_type'] == 1 || $v['product_type'] == 2) { // 咨询患者 if (!$this->putusers($user_pic, $v['user_id'])) { array_push($user_pic, $v); } } if ($v['product_type'] == 3) { // 门诊患者 if (!$this->putusers($user_relation, $v['user_id'])) { array_push($user_relation, $v); } } if ($v['product_type'] == 4) { // 疫苗患者 if (!$this->putusers($user_vaccines, $v['user_id'])) { array_push($user_vaccines, $v); } } if ($v['product_type'] == 5) { // 儿保预约 if (!$this->putusers($user_guar, $v['user_id'])) { array_push($user_guar, $v); } } if ($v['product_type'] == 6) { // 服务包 $OrderPacks = OrderPack::where('order_id', '=', $v['order_id'])->first(); if ($OrderPacks) { $teams = Team::with('docter')->where('id', '=', $OrderPacks['team_id'])->first(); if ($teams) { $teams = $teams->toArray(); if ($teams['docter']) { foreach ($teams['docter'] as $kk => $vv) { if ($vv['id'] == $doctor_id) { array_push($user_pack, $v); } } } } } } } $returnList['user_pic']['data'] = $user_pic; $returnList['user_relation']['data'] = $user_relation; $returnList['user_vaccines']['data'] = $user_vaccines; $returnList['user_guar']['data'] = $user_guar; $returnList['user_pack']['data'] = $user_pack; if (empty($newcoll)) { // 关注患者 $returnList['user_collection']['data'] = []; } else { $returnList['user_collection']['data'] = $newcoll; } $returnList['user_pic']['count'] = count($user_pic); $returnList['user_relation']['count'] = count($user_relation); $returnList['user_vaccines']['count'] = count($user_vaccines); $returnList['user_guar']['count'] = count($user_guar); $returnList['user_pack']['count'] = count($user_pack); $returnList['user_collection']['count'] = count($returnList['user_collection']['data']); return out($returnList); } /** * 升级版 in_array * @param $data1 * @param $data2 * @return bool * @author Liu-Yh * Create By 2020/11/27 16:18 */ protected function putusers($data1, $data2) { if (empty($data1)) { return false; } $list = []; foreach ($data1 as $k => $v) { array_push($list, $v['user_id']); } if (in_array($data2, $list)) { return true; } else { return false; } } /** * 上备注 * @return \Illuminate\Http\JsonResponse * @author Liu-Yh * Create By 2020/11/27 16:16 */ public function remacks() { $req = request()->post(); $this->validate(request(), [ 'remak|备注' => 'required', 'id|id' => 'required', ]); $user = $this->user; $user_id = $user['id']; $wheres['docter_id'] = $user_id; $wheres['user_id'] = $req['id']; $save = UserDocter::where($wheres)->first(); if ($save) { UserDocter::where('id', '=', $save['id'])->update([ 'remark' => $req['remak'] ]); } else { UserDocter::create([ 'docter_id' => $user_id, 'user_id' => $req['id'], 'remark' => $req['remak'] ]); } return out([]); } /** * 评价列表 * @return \Illuminate\Http\JsonResponse * @author Liu-Yh * Create By 2020/11/17 17:41 */ public function evaluate() { $req = request()->post(); $this->validate(request(), [ 'curPage' => 'required|integer', 'pageSize' => 'required|integer', ]); $pageSize = ($req['curPage'] - 1) * $req['pageSize']; $user = $this->user; $doctor_id = $user['id']; $wheres['docter_id'] = $doctor_id; $wheres['status'] = 2; $data = Evaluate::with(['order', 'user'])->where($wheres)->skip($pageSize)->take($req['pageSize'])->groupBy('id')->get()->toArray();; if ($data) { $newList = []; foreach ($data as $k => $v) { $newList[$k]['order_id'] = $v['order']['order_sn']; $newList[$k]['user'] = $v['user']['nickname']; $newList[$k]['lv'] = $v['score']; $newList[$k]['time'] = $v['created_at']; $newList[$k]['evaluate'] = $v['content']; } return out($newList); } else { return out([]); } } /** * 我的列表进入详情 * Auth:Yuanhang-Liu * Date:2020/10/18 15:21 * @return \Illuminate\Http\JsonResponse */ public function userListDetile() { $req = request()->post(); $this->validate(request(), [ 'user_id|用户ID' => 'required|integer', 'userType|用户类型' => 'integer|in:1,2,3,4,5,6,7', ]); $user = $this->user; // 查询详情; $finds_patient = User::with('patients')->where('id', '=', $req['user_id'])->first(); $remarks = UserDocter::where('user_id', '=', $req['user_id'])->first(); $finds_order = Order::with('orderPatient')->where('user_id', '=', $req['user_id'])->orderBy('created_at', 'desc')->limit(3)->get(); if ($finds_order) { $finds_order = $finds_order->toArray(); } $userArr = $patientsArr = $orderArr = $fuwArr = []; $patientsArr = []; $ws['user_id'] = $req['user_id']; $ws['product_type'] = 6; $fuw_order = Order::with('orderPack')->where($ws)->orderBy('created_at', 'desc')->get(); if ($fuw_order) { $fuw_order = $fuw_order->toArray(); foreach ($fuw_order as $kk => $vv) { $fuwArr[$kk]['order_id'] = $vv['id']; if ($vv['order_pack']) { foreach ($vv['order_pack'] as $k => $v) { $fuwArr[$kk]['id'] = $v['id']; $fuwArr[$kk]['pack_name'] = $v['pack_name']; $fuwArr[$kk]['pack_intro'] = $v['pack_intro']; $fuwArr[$kk]['pack_price'] = $v['pack_price']; $fuwArr[$kk]['effective_days'] = $v['effective_days']; $fuwArr[$kk]['start_time'] = date('Y-m-d,H:i', $v['start_time']); $fuwArr[$kk]['end_time'] = date('Y-m-d,H:i', $v['end_time']); } } } } if ($finds_patient) { $finds_patient = $finds_patient->toArray(); $userArr['id'] = $finds_patient['id']; if ($remarks) { $userArr['remark'] = $remarks['remark']; //用户备注 } else { $userArr['remark'] = ''; //用户备注 } $userArr['nickname'] = $finds_patient['nickname']; $userArr['avatar'] = $finds_patient['avatar']; if ($finds_patient['patients']) { foreach ($finds_patient['patients'] as $kk => $vv) { $patientsArr[$kk]['id'] = $vv['id']; $patientsArr[$kk]['avatar'] = $vv['avatar']; $patientsArr[$kk]['name'] = $vv['name']; if ($vv['sex'] == 0) { $patientsArr[$kk]['sex'] = '未知'; } elseif ($vv['sex'] == 1) { $patientsArr[$kk]['sex'] = '男'; } else { $patientsArr[$kk]['sex'] = '女'; } $patientsArr[$kk]['age'] = numBirthday($vv['birthday']); } } } if ($finds_order) { foreach ($finds_order as $k => $v) { $orderArr[$k]['id'] = $v['id']; $orderArr[$k]['order_sn'] = $v['order_sn']; if ($v['order_status'] >= 4) { $orderArr[$k]['receiving_time'] = date('Y-m-d H:i', $v['receiving_time']); $orderArr[$k]['outtime'] = date('Y-m-d H:i', $v['end_time']); } else { $orderArr[$k]['receiving_time'] = ''; $orderArr[$k]['outtime'] = ''; } $orderArr[$k]['order_status'] = $v['order_status']; $orderArr[$k]['product_type'] = $v['product_type']; $orderArr[$k]['created_at'] = $v['created_at']; $orderArr[$k]['name'] = $v['order_patient']['name']; $orderArr[$k]['birthday'] = numBirthday($v['order_patient']['birthday']); } } // 拼接服务消息 $wh['user_id'] = $req['user_id']; $wh['order_status'] = ['>', 3]; $wh['product_type'] = 6; $fuwuList = []; $fuwuInfo = Order::where($wh)->get(); $fuwuList['fuwu_num'] = count($fuwuInfo); $whs['user_id'] = $req['user_id']; $whs['order_status'] = ['>', 3]; $order_nums = Order::where($whs)->get(); $fuwuList['order_num'] = count($order_nums); $pati_nums = Patient::where('user_id', '=', $req['user_id'])->get(); $fuwuList['pati_num'] = count($pati_nums); $returnArr = [ 'user_arr' => $userArr, 'patients_arr' => $patientsArr,//患者档案 'order_arr' => $orderArr, //历史问诊 'fuwu_arr' => $fuwArr, //已购服务 'nums' => $fuwuList, ]; return out($returnArr); } /** * 我的列表进入详情 * Auth:Yuanhang-Liu * Date:2020/10/20 23:21 * @return \Illuminate\Http\JsonResponse */ public function patientsDetile() { $req = request()->post(); $this->validate(request(), [ 'patient_id|患者ID' => 'required|integer', ]); $user = $this->user; $finds = Patient::where('id', '=', $req['patient_id'])->first(); if ($finds) { $finds = $finds->toArray(); } if ($finds['sex'] == 0) { $finds['sex'] = '中性'; } elseif ($finds['sex'] == 1) { $finds['sex'] = '男'; } else { $finds['sex'] = '女'; } switch ($finds['relationship_type']) { case 1: $finds['relationship_type'] = '父亲'; break; case 2: $finds['relationship_type'] = '母亲'; break; case 3: $finds['relationship_type'] = '祖父'; break; case 4: $finds['relationship_type'] = '祖母'; break; case 5: $finds['relationship_type'] = '外祖父'; break; case 6: $finds['relationship_type'] = '外祖母'; break; case 7: $finds['relationship_type'] = '叔侄'; break; default: $finds['relationship_type'] = '其他'; } $finds['age'] = numBirthday($finds['birthday']); // 患者单子 $patient_list = OrderPatient::with('order')->where('patient_id', '=', $req['patient_id'])->groupBy('id', 'order_id')->get(); $patient_arr = []; if ($patient_list) { $patient_list = $patient_list->toArray(); foreach ($patient_list as $k => $v) { switch ($v['order']['product_type']) { case 1: $patient_arr[$k]['product_type'] = '电话咨询'; break; case 2: $patient_arr[$k]['product_type'] = '图文咨询'; break; case 3: $patient_arr[$k]['product_type'] = '门诊'; break; case 4: $patient_arr[$k]['product_type'] = '疫苗接种预约'; break; case 5: $patient_arr[$k]['product_type'] = '儿保预约'; break; case 6: $patient_arr[$k]['product_type'] = '服务包'; break; case 7: $patient_arr[$k]['product_type'] = '充值'; break; default: $patient_arr[$k]['product_type'] = '错误'; } switch ($v['order']['order_status']) { case 1: $patient_arr[$k]['order_status'] = '未支付'; break; case 2: $patient_arr[$k]['order_status'] = '待接单'; break; case 3: $patient_arr[$k]['order_status'] = '进行中'; break; case 4: $patient_arr[$k]['order_status'] = '已完成'; break; case 5: $patient_arr[$k]['order_status'] = '已取消'; break; default: $patient_arr[$k]['order_status'] = '未知'; } $patient_arr[$k]['created_at'] = $v['created_at']; } } $returnArr = [ 'patient' => $finds, 'patientOrder' => $patient_arr, ]; return out($returnArr); } /** * 关注用户 * Auth:Yuanhang-Liu * Date:2020/10/21 00:21 * @return \Illuminate\Http\JsonResponse */ public function userFollow() { $req = request()->post(); $this->validate(request(), [ 'user_id|用户ID' => 'required|integer', 'is_ley' => 'required', ]); // 如果ley==false说明要取消关注,反之添加关注 $user = $this->user; $docter_id = $user['id']; if ($req['is_ley'] == 1) { DocterUser::where('user_id', '=', $req['user_id'])->delete(); } else { DocterUser::create([ 'user_id' => $req['user_id'], 'docter_id' => $user['id'], ]); } return out(); } /** * 是否关注用户 * Auth:Yuanhang-Liu * Date:2020/10/21 00:21 * @return \Illuminate\Http\JsonResponse */ public function getFollows() { $req = request()->post(); $this->validate(request(), [ 'user_id|用户ID' => 'required|integer', ]); $user = $this->user; $docter_id = $user['id']; $where['docter_id'] = $docter_id; $where['user_id'] = $req['user_id']; $find = DocterUser::where($where)->first(); if ($find) { $find = $find->toArray(); return out(true); } else { return out(false); } } /** * 获取医生所在机构列表 * Auth:Yuanhang-Liu * Date:2020/10/21 00:21 * @return \Illuminate\Http\JsonResponse */ public function organizationList() { $user = $this->user; $doctor_id = $user['id']; $where['docter_id'] = $doctor_id; $where['state'] = 1; $orgList = DocterOrganization::with('organization')->where($where)->get()->toArray(); $newList = []; foreach ($orgList as $k => $v) { $newList[$k]['value'] = $v['organization']['id']; $newList[$k]['label'] = $v['organization']['name']; } return out($newList); } /** * 获取医院的服务时间 * @return mixed */ public function getOrgTimes() { $req = request()->post(); $this->validate(request(), [ 'org_id|医院id' => 'required', ]); $user = $this->user; $doctor_id = $user['id']; $where['docter_id'] = $doctor_id; $orgList = DocterSetting::where(['docter_id'=>$doctor_id,'type'=>1,'org_id'=>$req['org_id']])->first(); $newList = []; if($orgList){ $time = json_decode($orgList['service_time'],true); $newList['zao']['amStartTime'] = isset($time[1])?$time[1]['amStartTime']:''; $newList['zao']['amEndTime'] = isset($time[1])?$time[1]['amEndTime']:''; $newList['zao']['amPerson'] = isset($time[1])?$time[1]['amPerson']:''; $newList['zhong']['pmStartTime'] = isset($time[2])?$time[2]['pmStartTime']:''; $newList['zhong']['pmEndTime'] = isset($time[2])?$time[2]['pmEndTime']:''; $newList['zhong']['pmPerson'] = isset($time[2])?$time[2]['pmPerson']:''; $newList['wan']['nightStartTime'] = isset($time[3])?$time[3]['nightStartTime']:''; $newList['wan']['nightEndTime'] = isset($time[3])?$time[3]['nightEndTime']:''; $newList['wan']['nightPerson'] = isset($time[3])?$time[3]['nightPerson']:''; } return out($newList); } /** * 获取历史排班时间列表 */ public function getLinsList() { $user = $this->user; $doctor_id = $user['id']; $newData = []; $strim = date('Y-m-d', (time() + (7 - (date('w') == 0 ? 7 : date('w'))) * 24 * 3600)); $wheres['docter_id'] = $doctor_id; $data = Schedule::select(['id', 'schedule_date'])->where($wheres)->whereDate('schedule_date', '>', $strim)->orderBy('schedule_date', 'desc')->get(); if ($data) { $data = $data->toArray(); } else { return out($newData); } // $newDates = []; // foreach ($data as $k=>$v){ // if((time() + (7 - (date('w') == 0 ? 7 : date('w'))) * 24 * 3600) > strtotime($v['schedule_date'])){ // array_push($newDates,$data[$k]); // } // } // $data =$newDates; // $k=1; // foreach ($data as $v){ // $newData[$k]=$v; // $k++; // } $newData = array_values($data); $lab = []; $p = 0; for ($i = count($newData); $i > 0; $i--) { // if ($i%7==0||$i==1){ // // if ($p>=1){ // $lab[$p-1]['end_time'] = $arr[$i-1]; // $lab[$p]['start_time'] = $arr[$i-1]; // if(isset($arr[$i-7])){ // $lab[$p]['end_time'] = isset($arr[$i-7])?$arr[$i-7]:'error'; // // }else{ // unset($lab[$p]); // } //// $lab[$p]['end_time'] = isset($arr[$i-7])?$arr[$i-7]:'error'; // }else{ // $lab[$p]['start_time'] = $arr[$i-1]; // } // ++$p; // }else{ // continue; // } if ($i % 7 == 0 || $i == 1) { if ($p >= 1) { $lab[$p - 1]['end_time'] = $newData[$i - 1]; if (isset($newData[$i - 7])) { $lab[$p]['start_time'] = $newData[$i - 1]; $lab[$p]['end_time'] = $newData[$i - 7]; } else { unset($lab[$p]); } } else { $lab[$p]['start_time'] = $newData[$i - 1]; } ++$p; } else { continue; } } // 审核通过时间拿出来 $wh['docter_id'] = $doctor_id; $wh['service_type'] = 3; $wh['status'] = 2; $service = ServiceApply::where($wh)->first(); if ($service) { $service = $service; } else { $service = 0; } $rtuenList = [ 'list' => $lab, 'service' => $service, ]; return out($rtuenList); } /** * 获取历史排班详情(废弃) */ public function getLinsDetail() { $req = request()->post(); $this->validate(request(), [ 'start_date|开始时间' => 'required', 'end_date|结束时间' => 'required', ]); $user = $this->user; $doctor_id = $user['id']; $newData = []; $req['start_date'] = date("Y-m-d", strtotime($req['start_date'])); $req['end_date'] = date("Y-m-d", strtotime($req['end_date'])); // $data = Schedule::with(['schedulePeriod'])->orderBy('id','desc')->get(); $data = SchedulePeriod::with('organization')->where('docter_id', '=', $doctor_id)->whereBetween('schedule_date', [$req['start_date'], $req['end_date']])->groupBy('schedule_id', 'type')->get(); if ($data) { $data = $data->toArray(); } else { return out($newData); } $lab = []; $datesList = getDateFromList($req['start_date'], $req['end_date']); foreach ($data as $k => $v) { $lab[$k]['schedule_id'] = $v['schedule_id']; $lab[$k]['type'] = $v['type']; // 1=早上,2=下午,3=晚上 switch (date('w', strtotime($v['schedule_date']))) { case "0": $lab[$k]['week'] = '周日'; break; case "1": $lab[$k]['week'] = '周一'; break; case "2": $lab[$k]['week'] = '周二'; break; case "3": $lab[$k]['week'] = '周三'; break; case "4": $lab[$k]['week'] = '周四'; break; case "5": $lab[$k]['week'] = '周五'; break; default: $lab[$k]['week'] = '周六'; } $lab[$k]['schedule_date'] = date('m-d', strtotime($v['schedule_date'])); // 日期 $lab[$k]['name'] = $v['organization']; // 所在医院 $lab[$k]['flag'] = $v['me_sure']; // 所在医院 } $newLists = []; $newReturn = []; foreach ($lab as $k => $v) { if (!isset($newLists[$v['schedule_id']])) { $newLists[$v['schedule_id']] = $v; $newReturn[$v['schedule_id']]['schedule_id'] = $v['schedule_id']; if ($v['type'] == 1) { if ($v['flag'] != 0) { $newReturn[$v['schedule_id']]['type']['zao_flag'] = true; $newReturn[$v['schedule_id']]['type']['xia_flag'] = false; $newReturn[$v['schedule_id']]['type']['wan_flag'] = false; } else { $newReturn[$v['schedule_id']]['type']['zao_flag'] = false; $newReturn[$v['schedule_id']]['type']['xia_flag'] = false; $newReturn[$v['schedule_id']]['type']['wan_flag'] = false; } $newReturn[$v['schedule_id']]['type']['zao'] = $v['name']['name']; $newReturn[$v['schedule_id']]['type']['xia'] = false; $newReturn[$v['schedule_id']]['type']['wan'] = false; $newReturn[$v['schedule_id']]['type']['zao_id'] = $v['name']['id']; $newReturn[$v['schedule_id']]['type']['xia_id'] = 0; $newReturn[$v['schedule_id']]['type']['wan_id'] = 0; } else if ($v['type'] == 2) { if ($v['flag'] != 0) { $newReturn[$v['schedule_id']]['type']['zao_flag'] = false; $newReturn[$v['schedule_id']]['type']['xia_flag'] = true; $newReturn[$v['schedule_id']]['type']['wan_flag'] = false; } else { $newReturn[$v['schedule_id']]['type']['zao_flag'] = false; $newReturn[$v['schedule_id']]['type']['xia_flag'] = false; $newReturn[$v['schedule_id']]['type']['wan_flag'] = false; } $newReturn[$v['schedule_id']]['type']['zao'] = false; $newReturn[$v['schedule_id']]['type']['xia'] = $v['name']['name']; $newReturn[$v['schedule_id']]['type']['wan'] = false; $newReturn[$v['schedule_id']]['type']['zao_id'] = 0; $newReturn[$v['schedule_id']]['type']['xia_id'] = $v['name']['id']; $newReturn[$v['schedule_id']]['type']['wan_id'] = 0; } else { if ($v['flag'] != 0) { $newReturn[$v['schedule_id']]['type']['zao_flag'] = false; $newReturn[$v['schedule_id']]['type']['xia_flag'] = false; $newReturn[$v['schedule_id']]['type']['wan_flag'] = true; } else { $newReturn[$v['schedule_id']]['type']['zao_flag'] = false; $newReturn[$v['schedule_id']]['type']['xia_flag'] = false; $newReturn[$v['schedule_id']]['type']['wan_flag'] = false; } $newReturn[$v['schedule_id']]['type']['zao'] = false; $newReturn[$v['schedule_id']]['type']['xia'] = false; $newReturn[$v['schedule_id']]['type']['wan'] = $v['name']['name']; $newReturn[$v['schedule_id']]['type']['zao_id'] = 0; $newReturn[$v['schedule_id']]['type']['xia_id'] = 0; $newReturn[$v['schedule_id']]['type']['wan_id'] = $v['name']['id']; } $newReturn[$v['schedule_id']]['week'] = $v['week']; $newReturn[$v['schedule_id']]['schedule_date'] = $v['schedule_date']; $newReturn[$v['schedule_id']]['name'] = $v['name']; } else { if ($v['type'] == 1) { if ($v['flag'] != 0) { $newReturn[$v['schedule_id']]['type']['zao_flag'] = true; } else { $newReturn[$v['schedule_id']]['type']['zao_flag'] = false; } $newReturn[$v['schedule_id']]['type']['zao'] = $v['name']['name']; $newReturn[$v['schedule_id']]['type']['zao_id'] = $v['name']['id']; } else if ($v['type'] == 2) { $newReturn[$v['schedule_id']]['type']['xia'] = $v['name']['name']; if ($v['flag'] != 0) { $newReturn[$v['schedule_id']]['type']['xia_flag'] = true; } else { $newReturn[$v['schedule_id']]['type']['xia_flag'] = false; } $newReturn[$v['schedule_id']]['type']['xia_id'] = $v['name']['id']; } else { $newReturn[$v['schedule_id']]['type']['wan'] = $v['name']['name']; if ($v['flag'] != 0) { $newReturn[$v['schedule_id']]['type']['wan_flag'] = true; } else { $newReturn[$v['schedule_id']]['type']['wan_flag'] = false; } $newReturn[$v['schedule_id']]['type']['wan_id'] = $v['name']['id']; } } } $returnLists['list'] = array_values($newReturn); $instartTimes = $req['start_date']; // 判断数据库有没有这个时间段 $whr['docter_id'] = $doctor_id; $whr['schedule_date'] = $instartTimes; $finds = Schedule::where($whr)->first(); if ($finds) { $returnLists['save_flag'] = false; } else { $returnLists['save_flag'] = true; } return out($returnLists); } /** * 获取周模板详情 * @return \Illuminate\Http\JsonResponse * @author Liu-Yh * Create By 2020/12/16 12:09 */ public function getLinsDetailnew() { $req = request()->post(); $user = $this->user; $doctor_id = $user['id']; $newData = []; // $data = Schedule::with(['schedulePeriod'])->orderBy('id','desc')->get(); $data = WeekSchedule::with('organization')->where('docter_id', '=', $doctor_id)->groupBy('type', 'week')->orderBy('week', 'asc')->get(); if ($data) { $data = $data->toArray(); } else { return out($newData); } $lab = []; foreach ($data as $k => $v) { $lab[$k]['id'] = $v['id']; $lab[$k]['type'] = $v['type']; // 1=早上,2=下午,3=晚上 $lab[$k]['organization_id'] = $v['organization_id']; // 1=早上,2=下午,3=晚上 $lab[$k]['flag'] = $v['week']; switch ($v['week']) { case "7": $lab[$k]['week'] = '周日'; break; case "1": $lab[$k]['week'] = '周一'; break; case "2": $lab[$k]['week'] = '周二'; break; case "3": $lab[$k]['week'] = '周三'; break; case "4": $lab[$k]['week'] = '周四'; break; case "5": $lab[$k]['week'] = '周五'; break; default: $lab[$k]['week'] = '周六'; } $lab[$k]['name'] = $v['organization']; // 所在医院 } $weekList = ['周一', '周二', '周三', '周四', '周五', '周六', '周日']; try { $newReturn = []; foreach ($lab as $k => $v) { if (!isset($newReturn[$v['flag']])) { $newReturn[$v['flag']] = $v; if ($v['type'] == 1) { if ($v['flag'] != 0) { $newReturn[$v['flag']]['ident']['zao_flag'] = true; $newReturn[$v['flag']]['ident']['xia_flag'] = false; $newReturn[$v['flag']]['ident']['wan_flag'] = false; } else { $newReturn[$v['flag']]['ident']['zao_flag'] = false; $newReturn[$v['flag']]['ident']['xia_flag'] = false; $newReturn[$v['flag']]['ident']['wan_flag'] = false; } $newReturn[$v['flag']]['ident']['zao'] = $v['name']['name']; $newReturn[$v['flag']]['ident']['xia'] = false; $newReturn[$v['flag']]['ident']['wan'] = false; $newReturn[$v['flag']]['ident']['zao_id'] = $v['name']['id']; $newReturn[$v['flag']]['ident']['xia_id'] = 0; $newReturn[$v['flag']]['ident']['wan_id'] = 0; } else if ($v['type'] == 2) { if ($v['flag'] != 0) { $newReturn[$v['flag']]['ident']['zao_flag'] = false; $newReturn[$v['flag']]['ident']['xia_flag'] = true; $newReturn[$v['flag']]['ident']['wan_flag'] = false; } else { $newReturn[$v['flag']]['ident']['zao_flag'] = false; $newReturn[$v['flag']]['ident']['xia_flag'] = false; $newReturn[$v['flag']]['ident']['wan_flag'] = false; } $newReturn[$v['flag']]['ident']['zao'] = false; $newReturn[$v['flag']]['ident']['xia'] = $v['name']['name']; $newReturn[$v['flag']]['ident']['wan'] = false; $newReturn[$v['flag']]['ident']['zao_id'] = 0; $newReturn[$v['flag']]['ident']['xia_id'] = $v['name']['id']; $newReturn[$v['flag']]['ident']['wan_id'] = 0; } else { if ($v['flag'] != 0) { $newReturn[$v['flag']]['ident']['zao_flag'] = false; $newReturn[$v['flag']]['ident']['xia_flag'] = false; $newReturn[$v['flag']]['ident']['wan_flag'] = true; } else { $newReturn[$v['flag']]['ident']['zao_flag'] = false; $newReturn[$v['flag']]['ident']['xia_flag'] = false; $newReturn[$v['flag']]['ident']['wan_flag'] = false; } $newReturn[$v['flag']]['ident']['zao'] = false; $newReturn[$v['flag']]['ident']['xia'] = false; $newReturn[$v['flag']]['ident']['wan'] = $v['name']['name']; $newReturn[$v['flag']]['ident']['zao_id'] = 0; $newReturn[$v['flag']]['ident']['xia_id'] = 0; $newReturn[$v['flag']]['ident']['wan_id'] = $v['name']['id']; } $newReturn[$v['flag']]['week'] = $v['week']; $newReturn[$v['flag']]['name'] = $v['name']; } else { if ($v['type'] == 1) { if ($v['flag'] != 0) { $newReturn[$v['flag']]['ident']['zao_flag'] = true; } else { $newReturn[$v['flag']]['ident']['zao_flag'] = false; } $newReturn[$v['flag']]['ident']['zao'] = $v['name']['name']; $newReturn[$v['flag']]['ident']['zao_id'] = $v['name']['id']; } else if ($v['type'] == 2) { $newReturn[$v['flag']]['ident']['xia'] = $v['name']['name']; if ($v['flag'] != 0) { $newReturn[$v['flag']]['ident']['xia_flag'] = true; } else { $newReturn[$v['flag']]['ident']['xia_flag'] = false; } $newReturn[$v['flag']]['ident']['xia_id'] = $v['name']['id']; } else { $newReturn[$v['flag']]['ident']['wan'] = $v['name']['name']; if ($v['flag'] != 0) { $newReturn[$v['flag']]['ident']['wan_flag'] = true; } else { $newReturn[$v['flag']]['ident']['wan_flag'] = false; } $newReturn[$v['flag']]['ident']['wan_id'] = $v['name']['id']; } } unset($newReturn[$v['flag']]['name']); } } catch (\Exception $e) { var_dump($e->getMessage() . $e->getFile() . $e->getLine()); } $returnLists['list'] = array_values($newReturn); return out($returnLists); } /** * 门诊排班(废弃) * Auth:Yuanhang-Liu * Date:2020/10/21 00:21 * @return \Illuminate\Http\JsonResponse */ public function scheduling() { $req = request()->post(); $this->validate(request(), [ 'data|数据' => 'required', ]); $user = $this->user; $doctor_id = $user['id']; $data = json_decode($req['data'], true); $schedule = []; $morning = [];//早上 $afternoon = [];//下午 $night = [];//晚上 $zaoTimes = []; $zhongTimes = []; $wanTimes = []; $configs = SystemConfig::get()->toArray(); if (isset($configs[0]['value']) && !empty($configs[0]['value'])) { $zaoTimes[0] = $configs[0]['value']; } else { $zaoTimes[0] = "09:00"; } if (isset($configs[1]['value']) && !empty($configs[1]['value'])) { $zaoTimes[1] = $configs[1]['value']; } else { $zaoTimes[1] = "12:00"; } if (isset($configs[2]['value']) && !empty($configs[2]['value'])) { $zhongTimes[0] = $configs[2]['value']; } else { $zhongTimes[0] = "13:00"; } if (isset($configs[3]['value']) && !empty($configs[3]['value'])) { $zhongTimes[1] = $configs[3]['value']; } else { $zhongTimes[1] = "18:00"; } if (isset($configs[4]['value']) && !empty($configs[4]['value'])) { $wanTimes[0] = $configs[4]['value']; } else { $wanTimes[0] = "19:00"; } if (isset($configs[5]['value']) && !empty($configs[5]['value'])) { $wanTimes[1] = $configs[5]['value']; } else { $wanTimes[1] = "21:00"; } $morningd = TimePeriod::where('start_time_period', '>=', $zaoTimes[0])->where('end_time_period', '<=', $zaoTimes[1])->get()->toArray(); $morning = array_column($morningd, 'id'); $afternoond = TimePeriod::where('start_time_period', '>=', $zhongTimes[0])->where('end_time_period', '<=', $zhongTimes[1])->get()->toArray(); $afternoon = array_column($afternoond, 'id'); $nightd = TimePeriod::where('start_time_period', '>=', $wanTimes[0])->where('end_time_period', '<=', $wanTimes[1])->get()->toArray(); $night = array_column($nightd, 'id'); // 先进行删除 DB::beginTransaction(); try { foreach ($data as $k => $v) { // 删除 Schedule::where('schedule_date', '=', $v["schedule_date"])->delete(); SchedulePeriod::where('schedule_date', '=', $v['schedule_date'])->delete(); $schedule[$k]['schedule_date'] = $v['schedule_date']; $schedule[$k]['schedule_day'] = str_replace('-', '', $v['schedule_date']); $schedule[$k]['docter_id'] = $doctor_id; $schedule[$k]['organization_id'] = 0; $schedule[$k]['per_time_num'] = 10; $sid = Schedule::insertGetId($schedule[$k]); // 插入详情 if ($v['hospital'][0]['organization_id']) { $maf = $this->getMaf($sid, $morning, ['organization_id' => $v['hospital'][0]['organization_id'], 'schedule_date' => $v['schedule_date'], 'type' => 1], $doctor_id); SchedulePeriod::insert($maf); } if ($v['hospital'][1]['organization_id']) { $maf = $this->getMaf($sid, $afternoon, ['organization_id' => $v['hospital'][1]['organization_id'], 'schedule_date' => $v['schedule_date'], 'type' => 2], $doctor_id); SchedulePeriod::insert($maf); } if ($v['hospital'][2]['organization_id']) { $maf = $this->getMaf($sid, $night, ['organization_id' => $v['hospital'][2]['organization_id'], 'schedule_date' => $v['schedule_date'], 'type' => 3], $doctor_id); SchedulePeriod::insert($maf); } } DB::commit(); return out('', '', '成功'); } catch (\Exception $e) { DB::rollBack(); return out('', 500, $e->getFile() . '中的第:' . $e->getLine() . '行报错:' . $e->getCode(), $e->getMessage()); } } /** * 生成时间段 * @param int $org_id 机构id * @param int $type 时间段,1=早上,2=下午,3=晚上 * @return array|bool * @author Liu-Yh * Create By 2020/12/15 18:47 */ protected function num_time($org_id = 0, $type = 1) { $user = $this->user; $doctor_id = $user['id']; $zaoTimes = []; $zhongTimes = []; $wanTimes = []; $where['docter_id'] = $doctor_id; $where['type'] = 1; $where['org_id'] = $org_id; $configs = DocterSetting::where($where)->first(); if ($configs) { $list = json_decode($configs['service_time'], true); if (isset($list[1]['amStartTime']) && !empty($list[1]['amStartTime'])) { $zaoTimes[0] = $list[1]['amStartTime']; } else { $zaoTimes[0] = "08:00"; } if (isset($list[1]['amEndTime']) && !empty($list[1]['amEndTime'])) { $zaoTimes[1] = $list[1]['amEndTime']; } else { $zaoTimes[1] = "12:00"; } if (isset($list[2]['pmStartTime']) && !empty($list[2]['pmStartTime'])) { $zhongTimes[0] = $list[2]['pmStartTime']; } else { $zhongTimes[0] = "13:00"; } if (isset($list[2]['pmEndTime']) && !empty($list[2]['pmEndTime'])) { $zhongTimes[1] = $list[2]['pmEndTime']; } else { $zhongTimes[1] = "18:00"; } if (isset($list[3]['nightStartTime']) && !empty($list[3]['nightStartTime'])) { $wanTimes[0] = $list[3]['nightStartTime']; } else { $wanTimes[0] = "19:00"; } if (isset($list[3]['nightEndTime']) && !empty($list[3]['nightEndTime'])) { $wanTimes[1] = $list[3]['nightEndTime']; } else { $wanTimes[1] = "21:00"; } } else { return false; } if ($type == 1) { $morningWhere[] = ['start_time_period', '>=', $zaoTimes[0]]; $morningWhere[] = ['end_time_period', '<=', $zaoTimes[1]]; $morningWhere['docter_id'] = $doctor_id; $morningWhere['org_id'] = $org_id; $morningd = TimePeriod::where($morningWhere)->get()->toArray(); array_pop($morningd); $morning = array_column($morningd, 'id'); return $morning; } elseif ($type == 2) { $afternoondWhere[] = ['start_time_period', '>=', $zhongTimes[0]]; $afternoondWhere[] = ['end_time_period', '<=', $zhongTimes[1]]; $afternoondWhere['docter_id'] = $doctor_id; $afternoondWhere['org_id'] = $org_id; $afternoond = TimePeriod::where($afternoondWhere)->get()->toArray(); array_pop($afternoond); $afternoon = array_column($afternoond, 'id'); return $afternoon; } elseif ($type == 3) { $nightWhere[] = ['start_time_period', '>=', $wanTimes[0]]; $nightWhere[] = ['end_time_period', '<=', $wanTimes[1]]; $nightWhere['docter_id'] = $doctor_id; $nightWhere['org_id'] = $org_id; $nightd = TimePeriod::where($nightWhere)->get()->toArray(); array_pop($nightd); $night = array_column($nightd, 'id'); return $night; } else { $morningWhere[] = ['start_time_period', '>=', $zaoTimes[0]]; $morningWhere[] = ['end_time_period', '<=', $zaoTimes[1]]; $morningWhere['docter_id'] = $doctor_id; $morningWhere['org_id'] = $org_id; $morningd = TimePeriod::where($morningWhere)->get()->toArray(); array_pop($morningd); $morning = array_column($morningd, 'id'); $afternoondWhere[] = ['start_time_period', '>=', $zhongTimes[0]]; $afternoondWhere[] = ['end_time_period', '<=', $zhongTimes[1]]; $afternoondWhere['docter_id'] = $doctor_id; $afternoondWhere['org_id'] = $org_id; $afternoond = TimePeriod::where($afternoondWhere)->get()->toArray(); array_pop($afternoond); $afternoon = array_column($afternoond, 'id'); $nightWhere[] = ['start_time_period', '>=', $wanTimes[0]]; $nightWhere[] = ['end_time_period', '<=', $wanTimes[1]]; $nightWhere['docter_id'] = $doctor_id; $nightWhere['org_id'] = $org_id; $nightd = TimePeriod::where($nightWhere)->get()->toArray(); array_pop($nightd); $night = array_column($nightd, 'id'); return [$morning, $afternoon, $night]; } } /** * 获取俩月日期 * @return array */ protected function date_bool($start_time = false, $end_time = false) { $weekarray = array(7, 1, 2, 3, 4, 5, 6); $monthDays = []; if ($start_time && $end_time) { $firstDay = $start_time; $lastDay = $end_time; } else { $firstDay = date('Y-m-01', time()); $lastDay = date('Y-m-d', strtotime("$firstDay +2 month -1 day")); } $i = 0; while (date('Y-m-d', strtotime("$firstDay +$i days")) <= $lastDay) { $monthDays[$i]['date'] = date('Y-m-d', strtotime("$firstDay +$i days")); $monthDays[$i]['week'] = $weekarray[date("w", strtotime("$firstDay +$i days"))]; $i++; } return $monthDays; } /** * 新版门诊排班(排班周模板) * @return mixed * @throws \Exception */ public function week_scheduling() { $req = request()->post(); $this->validate(request(), [ 'data|数据' => 'required', ]); $user = $this->user; $doctor_id = $user['id']; $data = json_decode($req['data'], true); $moth_date = $this->date_bool(); // 添加到周模板(不管时间) $weekList = []; $weekModel = new WeekSchedule(); // 先进行删除 $counts = Schedule::where('schedule_date', '>=', $moth_date[0]['date'])->where('docter_id',$doctor_id)->where('schedule_date', '<=', end($moth_date)['date'])->get(); // 12个月平均两个月最短是29天 $selfWhere['docter_id'] = $doctor_id; $selfWhere[] = ['schedule_date','>=',date('Y-m-d',time())]; $selfScheduleList = SelfSchedule::where($selfWhere)->get(); $flag = false; DB::beginTransaction(); try { $weekModel->where('docter_id', '=', $doctor_id)->where('schedule_type', '=', 1)->delete(); $delWhere['docter_id'] = $doctor_id; $delWhere[] = ['schedule_date','>=',date('Y-m-d',time())]; SchedulePeriod::where($delWhere)->delete(); $schedule = []; if (count($counts) < 29) { $flag = true; Schedule::where('docter_id', '=', $doctor_id)->delete(); foreach ($moth_date as $kk => $vv) { $schedule[$kk]['schedule_date'] = $vv['date']; $schedule[$kk]['schedule_day'] = str_replace('-', '', $vv['date']); $schedule[$kk]['docter_id'] = $doctor_id; $schedule[$kk]['organization_id'] = 0; $schedule[$kk]['week'] = $vv['week']; $schedule[$kk]['per_time_num'] = 10; $sid[$kk] = Schedule::insertGetId($schedule[$kk]); } } else { foreach ($counts as $kk => $vv) { if ($vv['schedule_date'] >= date('Y-m-d',time())){ $schedule[$kk]['schedule_date'] = $vv['schedule_date']; $schedule[$kk]['week'] = $vv['week']; $sid[$kk] = $vv['id']; } } } foreach ($data as $k => $v) { // 插入详情 if ($v['identifi']['zao']!=0) { $maf[$k]['schedule_type'] = 1; $maf[$k]['docter_id'] = $doctor_id; $maf[$k]['week'] = $v['week']; $maf[$k]['type'] = 1; $maf[$k]['organization_id'] = $v['identifi']['zao']; $weekList[] = $maf[$k]; // $times = $this->num_time($v['identifi']['zao'],1); // if (!$times){ // return out('',500,"请先在排班设置中填写本机构的时间段"); // } // $zao_maf=$this->week_getMaf($times,['organization_id'=>$v['identifi']['zao'],'week'=>$v['week'],'type'=>1],$doctor_id); // if ($zao_maf){ // foreach ($zao_maf as $o){ // $weekList[]=$o; // } // } } if ($v['identifi']['zhong']!=0) { $maf[$k]['schedule_type'] = 1; $maf[$k]['docter_id'] = $doctor_id; $maf[$k]['week'] = $v['week']; $maf[$k]['type'] = 2; $maf[$k]['organization_id'] = $v['identifi']['zhong']; $weekList[] = $maf[$k]; /* $times = $this->num_time($v['identifi']['zhong'],2); if (!$times){ return out('',500,"请先在排班设置中填写本机构的时间段"); } $zhong_maf=$this->week_getMaf($times,['organization_id'=>$v['identifi']['zhong'],'week'=>$v['week'],'type'=>2],$doctor_id); if ($zhong_maf){ foreach ($zhong_maf as $o){ $weekList[]=$o; } }*/ } if ($v['identifi']['wan']!=0) { $maf[$k]['schedule_type'] = 1; $maf[$k]['docter_id'] = $doctor_id; $maf[$k]['week'] = $v['week']; $maf[$k]['type'] = 3; $maf[$k]['organization_id'] = $v['identifi']['wan']; $weekList[] = $maf[$k]; /*$times = $this->num_time($v['identifi']['wan'],3); if (!$times){ return out('',500,"请先在排班设置中填写本机构的时间段"); } $wan_maf=$this->week_getMaf($times,['organization_id'=>$v['identifi']['wan'],'week'=>$v['week'],'type'=>3],$doctor_id); if ($wan_maf){ foreach ($wan_maf as $o){ $weekList[]=$o; } }*/ } } // 占用效率 $scheduleLists = []; foreach ($sid as $kk => $vv) { foreach ($data as $k => $v) { if ($schedule[$kk]['week'] == $v['week']) { //检查有没有设置时间 // if ($v['identifi']['zao']==0) { // $times = $this->num_time($v['identifi']['zao'], 1); // if (!$times) { // return out('', 500, "请先在排班设置中填写本机构的时间段1"); // } // } if ($v['identifi']['zao']) { $times = $this->num_time($v['identifi']['zao'], 1); if (!$times) { return out('', 500, "请先在排班设置中填写本机构的时间段2"); } $maf = $this->getMaf($vv, $times, ['organization_id' => $v['identifi']['zao'], 'schedule_date' => $schedule[$kk]['schedule_date'], 'type' => 1], $doctor_id); if ($maf) { foreach ($maf as $os) { // array_push($scheduleLists, $os); $scheduleLists[] = $os; } } } if ($v['identifi']['zhong']) { $times = $this->num_time($v['identifi']['zhong'], 2); if (!$times) { return out('', 500, "请先在排班设置中填写本机构的时间段3"); } $maf = $this->getMaf($vv, $times, ['organization_id' => $v['identifi']['zhong'], 'schedule_date' => $schedule[$kk]['schedule_date'], 'type' => 2], $doctor_id); if ($maf) { foreach ($maf as $os) { $scheduleLists[] = $os; } } } if ($v['identifi']['wan']) { $times = $this->num_time($v['identifi']['wan'], 3); if (!$times) { return out('', 500, "请先在排班设置中填写本机构的时间段4"); } $maf = $this->getMaf($vv, $times, ['organization_id' => $v['identifi']['wan'], 'schedule_date' => $schedule[$kk]['schedule_date'], 'type' => 3], $doctor_id); if ($maf) { foreach ($maf as $os) { // array_push($scheduleLists, $os); $scheduleLists[] = $os; } } } } } } // 查询重复替换 $chong = []; if ($selfScheduleList && $scheduleLists) { foreach ($scheduleLists as $k => $v) { foreach ($selfScheduleList as $kk => $vv) { if ($v['schedule_date'] == $vv['schedule_date']) { $chong[$kk]['schedule_id'] = $v['schedule_id']; $chong[$kk]['docter_id'] = $v['docter_id']; $chong[$kk]['order_num'] = $v['order_num']; $chong[$kk]['organization_id'] = $vv['organization_id']; $chong[$kk]['time_period_id'] = $vv['time_period_id']; $chong[$kk]['type'] = $vv['type']; $chong[$kk]['schedule_date'] = $vv['schedule_date']; unset($scheduleLists[$k]); } } } } $listPeriod = array_merge($chong, $scheduleLists); SchedulePeriod::insert($listPeriod); WeekSchedule::insert($weekList); DB::commit(); return out(); } catch (\Exception $e) { DB::rollBack(); return out('', 500, $e->getFile() . '中的第:' . $e->getLine() . '行报错:' . $e->getCode(), $e->getMessage()); } catch (\PDOException $e) { DB::rollBack(); return out('', 500, $e->getFile() . '中的第:' . $e->getLine() . '行报错:' . $e->getCode(), $e->getMessage()); } } /** * 修改某一天的数据 * @author Liu-Yh * Create By 2020/12/16 18:46 */ public function saveDay($data = []) { $flag = false; if (empty($data)) { $req = request()->post(); $this->validate(request(), [ 'schedule_date|日期' => 'required', 'week|日期' => 'required', 'type|类型' => 'required', 'organization_id|日期' => 'required', ]); } else { $flag = true; $req = $data; } $user = $this->user; $doctor_id = $user['id']; $save_data = []; // $type_data = explode(',', $req['type']); DB::beginTransaction(); try { $type_data = json_decode($req['type'],true); $finds = SelfSchedule::where(['schedule_date' => $req['schedule_date'], 'docter_id' => $doctor_id, 'schedule_type' => 1])->delete(); $save_data=[]; if($type_data['mon']!=0) { $mon_times = $this->num_time($type_data['mon'], 1); $mf1 = $this->arrangeDay($mon_times, ['organization_id' => $type_data['mon'], 'week' => $req['week'], 'schedule_date' => $req['schedule_date'], 'type' => 1], $doctor_id); if($mf1){ foreach ($mf1 as $v){ $save_data[] = $v; } } } if($type_data['aft']!=0){ $aft_times = $this->num_time($type_data['aft'], 2); $mf2 = $this->arrangeDay($aft_times, ['organization_id' => $type_data['aft'], 'week' => $req['week'], 'schedule_date' => $req['schedule_date'], 'type' => 2], $doctor_id); if($mf2){ foreach ($mf2 as $v){ $save_data[] = $v; } } } if($type_data['nig']!=0) { $nig_times = $this->num_time($type_data['nig'], 3); $mf3 = $this->arrangeDay($nig_times, ['organization_id' => $type_data['nig'], 'week' => $req['week'], 'schedule_date' => $req['schedule_date'], 'type' => 3], $doctor_id); if($mf3){ foreach ($mf3 as $v){ $save_data[] = $v; } } } if (!$flag){ $lists = Schedule::where(['docter_id'=>$doctor_id,'schedule_date'=>$req['schedule_date']])->first(); if($lists){ SchedulePeriod::where(['docter_id'=>$doctor_id,'schedule_date'=>$req['schedule_date']])->delete(); $chong = []; foreach ($save_data as $k => $v) { $chong[$k]['schedule_id'] = $lists['id']; $chong[$k]['docter_id'] = $v['docter_id']; $chong[$k]['order_num'] = 0; $chong[$k]['organization_id'] = $v['organization_id']; $chong[$k]['time_period_id'] = $v['time_period_id']; $chong[$k]['type'] = $v['type']; $chong[$k]['schedule_date'] = $v['schedule_date']; } SchedulePeriod::insert($chong); } } SelfSchedule::insert($save_data); DB::commit(); if ($flag) { return true; } else { return out(); } } catch (\Exception $e) { DB::rollBack(); if ($flag) { return false; } else { return out('', 500, $e->getFile() . '中的第:' . $e->getLine() . '行报错:' . $e->getCode(), $e->getMessage()); } } catch (\PDOException $e) { DB::rollBack(); if ($flag) { return false; } else { return out('', 500, $e->getFile() . '中的第:' . $e->getLine() . '行报错:' . $e->getCode(), $e->getMessage()); } } } /** * 整理单个修改排班的数据 * @param $time * @param $req * @param $doctor_id * @return array * @author Liu-Yh * Create By 2020/12/16 19:00 */ protected function arrangeDay($time, $req, $doctor_id) { $save_data = []; foreach ($time as $k => $v) { $save_data[$k]['schedule_date'] = $req['schedule_date']; $save_data[$k]['week'] = $req['week']; $save_data[$k]['schedule_type'] = 1; $save_data[$k]['type'] = $req['type']; $save_data[$k]['organization_id'] = $req['organization_id']; $save_data[$k]['docter_id'] = $doctor_id; $save_data[$k]['time_period_id'] = $v; } return $save_data; } /** * 查看月视图 * @author Liu-Yh * Create By 2020/12/16 19:20 */ public function monthDetail() { $req = request()->post(); $this->validate(request(), [ 'start_day|日期' => 'required', 'end_day|日期' => 'required', ]); $user = $this->user; $doctor_id = $user['id']; $selfScheduleList = SelfSchedule::where('docter_id', '=', $doctor_id)->get(); $weekSchduleList = WeekSchedule::with('organization')->where('docter_id', '=', $doctor_id)->groupBy('type', 'week')->orderBy('week', 'asc')->get()->toArray(); // 占用效率 $scheduleLists = []; $moth_date = $this->date_bool($req['start_day'], $req['end_day']); $lab=[]; foreach ($weekSchduleList as $k => $v) { $lab[$k]['id'] = $v['id']; $lab[$k]['type'] = $v['type']; // 1=早上,2=下午,3=晚上 $lab[$k]['organization_id'] = $v['organization_id']; // 1=早上,2=下午,3=晚上 $lab[$k]['flag'] = $v['week']; switch ($v['week']) { case "7": $lab[$k]['week'] = '周日'; break; case "1": $lab[$k]['week'] = '周一'; break; case "2": $lab[$k]['week'] = '周二'; break; case "3": $lab[$k]['week'] = '周三'; break; case "4": $lab[$k]['week'] = '周四'; break; case "5": $lab[$k]['week'] = '周五'; break; default: $lab[$k]['week'] = '周六'; } } $newReturn = []; $weekList = ['周一', '周二', '周三', '周四', '周五', '周六', '周日']; foreach ($lab as $k => $v) { if (!isset($newReturn[$v['flag']])) { $newReturn[$v['flag']] = $v; if ($v['type'] == 1) { $newReturn[$v['flag']]['ident']['zao_id'] = $v['organization_id']; $newReturn[$v['flag']]['ident']['xia_id'] = 0; $newReturn[$v['flag']]['ident']['wan_id'] = 0; } else if ($v['type'] == 2) { $newReturn[$v['flag']]['ident']['zao_id'] = 0; $newReturn[$v['flag']]['ident']['xia_id'] = $v['organization_id']; $newReturn[$v['flag']]['ident']['wan_id'] = 0; } else { $newReturn[$v['flag']]['ident']['zao_id'] = 0; $newReturn[$v['flag']]['ident']['xia_id'] = 0; $newReturn[$v['flag']]['ident']['wan_id'] = $v['organization_id']; } } else { if ($v['type'] == 1) { $newReturn[$v['flag']]['ident']['zao_id'] = $v['organization_id']; } else if ($v['type'] == 2) { $newReturn[$v['flag']]['ident']['xia_id'] = $v['organization_id']; } else { $newReturn[$v['flag']]['ident']['wan_id'] = $v['organization_id']; } } } $newList = []; foreach ($moth_date as $k => $v) { $newList[$k]['date'] = $v['date']; $newList[$k]['ident']['zao'] = 0; $newList[$k]['ident']['xia'] = 0; $newList[$k]['ident']['wan'] = 0; foreach ($newReturn as $kk => $vv) { if ($v['week'] == $vv['flag']) { $newList[$k]['date'] = $v['date']; $newList[$k]['ident']['zao'] = $vv['ident']['zao_id']; $newList[$k]['ident']['xia'] = $vv['ident']['xia_id']; $newList[$k]['ident']['wan'] = $vv['ident']['wan_id']; } } } $selfList = []; if ($selfScheduleList) { // 自定义排班数组 $selfScheduleList = $selfScheduleList->toArray(); foreach ($selfScheduleList as $k => $v) { if (!isset($selfList[$v['schedule_date']])) { $selfList[$v['schedule_date']] = $v; if ($v['type'] == 1) { $selfList[$v['schedule_date']]['ident']['zao_id'] = $v['organization_id']; $selfList[$v['schedule_date']]['ident']['xia_id'] = 0; $selfList[$v['schedule_date']]['ident']['wan_id'] = 0; } else if ($v['type'] == 2) { $selfList[$v['schedule_date']]['ident']['zao_id'] = 0; $selfList[$v['schedule_date']]['ident']['xia_id'] = $v['organization_id']; $selfList[$v['schedule_date']]['ident']['wan_id'] = 0; } else { $selfList[$v['schedule_date']]['ident']['zao_id'] = 0; $selfList[$v['schedule_date']]['ident']['xia_id'] = 0; $selfList[$v['schedule_date']]['ident']['wan_id'] = $v['organization_id']; } } else { if ($v['type'] == 1) { $selfList[$v['schedule_date']]['ident']['zao_id'] = $v['organization_id']; } else if ($v['type'] == 2) { $selfList[$v['schedule_date']]['ident']['xia_id'] = $v['organization_id']; } else { $selfList[$v['schedule_date']]['ident']['wan_id'] = $v['organization_id']; } } } foreach ($selfList as $k => $v) { foreach ($newList as $kk => $vv) { if ($v['schedule_date'] == $vv['date']) { $newList[$kk]['date'] = $vv['date']; $newList[$kk]['ident']['zao'] = $v['ident']['zao_id']; $newList[$kk]['ident']['xia'] = $v['ident']['xia_id']; $newList[$kk]['ident']['wan'] = $v['ident']['wan_id']; } } } } return out($newList); } /** * 获取早中下午的id * @param $sid * @param $time * @param $req * @param $doctor_id * @return array * @author Liu-Yh * Create By 2020/11/6 16:27 */ protected function getMaf($sid, $time, $req, $doctor_id) { $maf = []; foreach ($time as $k => $v) { $maf[$k]['schedule_id'] = $sid; $maf[$k]['organization_id'] = $req['organization_id']; $maf[$k]['time_period_id'] = $v; $maf[$k]['schedule_date'] = $req['schedule_date']; $maf[$k]['docter_id'] = $doctor_id; $maf[$k]['type'] = $req['type']; $maf[$k]['order_num'] = 0; } return $maf; } /** * 周模板添加数据 * @param $time * @param $req * @param $doctor_id * @return array */ protected function week_getMaf($time, $req, $doctor_id) { $maf = []; foreach ($time as $k => $v) { // $maf[$k]['schedule_id']=$sid; // $maf[$k]['schedule_date']=$req['schedule_date']; $maf[$k]['type'] = $req['type']; $maf[$k]['schedule_type'] = 1; $maf[$k]['organization_id'] = $req['organization_id']; $maf[$k]['docter_id'] = $doctor_id; $maf[$k]['time_period_id'] = $v; $maf[$k]['week'] = $req['week']; } return $maf; } /** * 获取会话列表 * @return \Illuminate\Http\JsonResponse * @author Liu-Yh * Create By 2020/11/6 17:11 */ public function getUserListMsg() { $req = request()->post(); $user = $this->user; $doctor_id = $user['id']; $where[] = ['product_type', 2]; $where[] = ['order_status', '>', 2]; $where[] = ['payment_status', 2]; $where[] = ['docter_id', $doctor_id]; $list = Order::with('user')->where($where)->orderBy('receiving_time', 'desc')->get(); $newList = []; if ($list) { $list = $list->toArray(); foreach ($list as $k => $v) { $messages = ImMessage::where(['senderId'=>'doctor_'.$doctor_id,'receiverId'=>'member_'.$v['user_id']])->orWhere(function ($query) use ($req,$doctor_id,$v){ $query->where(['senderId'=>'member_'.$v['user_id'],'receiverId'=>'doctor_'.$doctor_id]); })->orderBy('id','desc')->first(); if($messages){ if($messages['type']=='text'){ $newList[$v['user_id']]['out_message'] = $messages['payload']; }else if ($messages['type'] == 'audio'){ $newList[$v['user_id']]['out_message'] = "[语音消息]"; }else{ $newList[$v['user_id']]['out_message'] = "[图片消息]"; } if (empty($messages['create_time'])){ $newList[$v['user_id']]['out_time'] = ""; }else{ $newList[$v['user_id']]['out_time'] = date('m-d',$messages['create_time']); } }else{ $newList[$v['user_id']]['out_message'] = ''; $newList[$v['user_id']]['out_time'] = ''; } $newList[$v['user_id']]['flag'] = 'member_' . $v['user_id']; $newList[$v['user_id']]['order_status'] = $v['order_status']; $newList[$v['user_id']]['nickname'] = $v['user']['nickname']; $newList[$v['user_id']]['avatar'] = $v['user']['avatar']; $newList[$v['user_id']]['remark'] = !empty($v['user']['remark'])?$v['user']['remark']:''; } $newList = array_values($newList); } return out($newList); } /** * 获取认证信息 * @return mixed */ public function getRenInfo() { $req = request()->post(); $user = $this->user; $doctor_id = $user['id']; // 获取本人认证信息 $returnRes = []; $docter = Docter::where('id', '=', $doctor_id)->first(); if ($docter) { $docter = $docter->toArray(); } else { return $docter; } $returnRes['info'] = $docter; // 获取申请的认证机构 $org = DocterOrganization::with(['organization'])->where('docter_id', '=', $doctor_id)->get(); $oqf = DocterOrganization::with(['office', 'qualification'])->where('docter_id', '=', $doctor_id)->get(); foreach ($org as $k => $v) { $org[$k]['province'] = Areas::where('id', '=', $v['organization']['province_id'])->select('name')->first()['name']; $org[$k]['city'] = Areas::where('id', '=', $v['organization']['city_id'])->select('name')->first()['name']; $org[$k]['area'] = Areas::where('id', '=', $v['organization']['area_id'])->select('name')->first()['name']; $org[$k]['name'] = $v['organization']['name']; } $returnRes['orgList'] = $org; $returnRes['oqf'] = $oqf; return out($returnRes); } /** * 获取通话记录 * @return mixed */ public function callLog(){ $req = request()->post(); $user = $this->user; $doctor_id = $user['id']; $where =[]; if(isset($req['order_id'])&&!empty($req['order_id'])){ $where['order_id'] = $req['order_id']; } $where['docter_id'] = $doctor_id; $list = CallLog::where($where)->get(); return out($list); } /** * 通话列表 * @return mixed */ public function user_call(){ $req = request()->post(); $user = $this->user; $doctor_id = $user['id']; $list=[]; // var_dump($doctor_id); //die(); if(isset($req['user_id'])&&!empty($req['user_id'])){ $ids = []; $orderList = Order::where(['user_id'=>$req['user_id'],'product_type'=>1,'payment_status'=>2])->select('id')->get(); if($orderList){ foreach ($orderList as $k=>$v){ $ids[$k] = $v['id']; } } $lists = CallLog::with('orders')->whereIn('order_id',$ids)->orderBy('call_time', 'desc')->get(); if ($lists){ foreach ($lists as $k=>$v){ $list[$k]['time'] = $v['call_time']; $list[$k]['talk_time'] = $v['talk_time']; $list[$k]['order_sn'] = $v['orders']['order_sn']; } } }else{ $orderList = Order::with(['user','calllog'])->where(['docter_id'=>$doctor_id,'product_type'=>1,'payment_status'=>2])->groupBy(['user_id'])->get(); if ($orderList){ foreach ($orderList as $k=>$v){ $list[$k]['user'] = $v['user']; $calls = CallLog::where('docter_id',$doctor_id)->orderBy('id','desc')->first(); if ($calls){ $list[$k]['user']['dates'] = $calls['call_time']; }else{ $list[$k]['user']['dates'] = '无'; } $save = UserDocter::where(['user_id'=>$v['user']['id'],'docter_id'=>$doctor_id])->first(); if ($save) { $list[$k]['user']['remark'] = $save['remark']; } else { $list[$k]['user']['remark'] = ''; } $list[$k]['user']['log'] = $v['calllog']; // $list[$k]['log']['date'] = date('m/d',strtotime(end($v['calllog'])['call_time'])); } } } return out($list); } /** * 获取聊天记录 * @return mixed */ public function getImList(){ $req = request()->post(); $user = $this->user; $doctor_id = $user['id']; $where =[]; if(!isset($req['flag'])||empty($req['flag'])){ return out("",500,'用户flag不能为空'); } $list = ImMessage::where(['senderId'=>'doctor_'.$doctor_id,'receiverId'=>$req['flag']])->orWhere(function ($query) use ($req,$doctor_id){ $query->where(['senderId'=>$req['flag'],'receiverId'=>'doctor_'.$doctor_id]); })->get(); $newList=[]; if ($list){ foreach ($list as $k=>$v){ $decode = json_decode($v['text'],true); // $newList[$k]['id']=$decode['id']; $newList[$k]['messageId']=$decode[0]['messageId']; $newList[$k]['type']=$decode[0]['type']; $newList[$k]['senderId']=$decode[0]['senderId']; $newList[$k]['receiverId']=$decode[0]['receiverId']; $newList[$k]['timestamp']=$decode[0]['timestamp']; $newList[$k]['payload']= json_decode($decode[0]['payload'],true); } } return out($newList); } }