toArray(); } //备注 public function paitent_remark() { $data['patient_id']= request('patient_id'); $data['org_id'] = request('org_id'); $data['type'] = request('type'); $is_have = PatientRemark::where($data)->first(); $data['remark'] = request('remark'); if(empty($data['remark'])) return redirect('/cdms/nurse_users'); if($is_have){ PatientRemark::where(['id'=>$is_have->id])->update(['remark'=>$data['remark']]); } else { PatientRemark::insert($data); } return redirect('/cdms/nurse_users'); } //发送短信 public function sendmsg(){ $config = [ // 'app_id' => 'wx1c2357232cd25f65', // 'secret' => 'c8cab53e4e52234ed1bc2abbdeaba57d', 'app_id' => 'wx13bedfcc62e9bab0', 'secret' => '175e5518b6426dd12d3096f24ca68fb8', 'response_type' => 'array' // oVxTzvgYlGktIDZXwfLMLQ01Tr5s ]; //3LUhWGlyiljxrT3Jh8orwQZ2LSHjfRs9SIHaB40O6q0 //开发者调用模版消息接口时需提供模版ID //标题 //offer进度提醒 //行业 //IT科技 - 互联网|电子商务 //详细内容 //{{first.DATA}} //人才姓名:{{keyword1.DATA}} //联系方式:{{keyword2.DATA}} //入职职位:{{keyword3.DATA}} //入职公司:{{keyword4.DATA}} //报到时间:{{keyword5.DATA}} //{{remark.DATA}} // oVxTzvgYlGktIDZXwfLMLQ01Tr5s 自己 oVxTzvhu4gs4RyCt4kJDRWOgsUXw周璐 oVxTzvgu4XnI5F2aF7DcrbJIp5fI 间行 oVxTzvl8DYQblYmLCIK3UXW_8jAY 落雨桐 $renyuan = ['o481Y5AtcbnOQef1vc4rL4TwYpDU','oVxTzvgYlGktIDZXwfLMLQ01Tr5s']; //周璐 // $renyuan = ['oVxTzvvTnnbjEE9jsalOYj4mtp6U','oVxTzvgu4XnI5F2aF7DcrbJIp5fI']; //简行 $app = Factory::officialAccount($config ); // $res = $app->broadcasting->status(3147483751); // // "errcode" => 0 // "errmsg" => "send job submission success" // "msg_id" => 3147483751 // "msg_data_id" => 2247484953 // ^ array:2 [▼ // "errcode" => 40003 // "errmsg" => "invalid openid rid: 5fc35ef3-7f3b3ef9-14537bc7" //] $user = $app->user->get('oVxTzvgYlGktIDZXwfLMLQ01Tr5s'); $res = $app->template_message->send([ 'touser' => 'oVxTzvgYlGktIDZXwfLMLQ01Tr5s', 'template_id' => '3LUhWGlyiljxrT3Jh8orwQZ2LSHjfRs9SIHaB40O6q0', // 'url' => 'https://t5.9026.com', 'data' => [ 'first'=>'社区通知', 'keyword1' => '王海军', 'keyword2' => 18719141830, 'keyword3' => '开发工程师', 'keyword4' => '思维定制', 'keyword5' => '2020-12-12', ], ]); dd($res); $res = $app->broadcasting->sendText("测试发送,测试发送",$renyuan); } //获取排班页面 public function getComSchedule() { $set_time = request('time');//时间 $user = Admin::user(); $doc_id = $user->docter_id; $docter_id = request('docter_id'); $role = request('role',1); $is_docter = CdmsUsers::where('docter_id',$doc_id)->where('docter_id','!=','')->first(); if(empty($set_time)){ return json_encode(['code'=>601,'msg'=>'缺少必要参数','data'=>'']); } if($is_docter){ $role =2; $org_id = request('org_id'); } else { $org_id = $user->org_id; } $all_time = explode('至',$set_time); if(count($all_time) <2){ return json_encode(['code'=>601,'msg'=>'缺少必要参数','data'=>'']); } return $this->getWeekSchedule(); $start_time = intval(str_replace('-','',$all_time[0])); $end_time = intval(str_replace('-','',$all_time[1])); $first_day = strtotime($all_time[0]); // DB::enableQueryLog(); $sche_dule = Schedule::whereBetween('schedule_day',[$start_time,$end_time]) ->where(['docter_id'=>$docter_id]) ->pluck('id') ->toArray(); // echo '
'; // print_r(DB::getQueryLog()); // echo ''; //dd($sche_dule); $sche_dule_arr =[ [ 'date'=>"上午", 'monday'=>false, 'tuesday'=>false, 'wednesday'=>false, 'thursday'=>false, 'friday'=>false, 'saturday'=>false, 'sunday'=>false, ], [ 'date'=>"下午", 'monday'=>false, 'tuesday'=>false, 'wednesday'=>false, 'thursday'=>false, 'friday'=>false, 'saturday'=>false, 'sunday'=>false, ], [ 'date'=>"晚上", 'monday'=>false, 'tuesday'=>false, 'wednesday'=>false, 'thursday'=>false, 'friday'=>false, 'saturday'=>false, 'sunday'=>false, ] ]; // return $this->getWeekSchedule(); //周字段映射 $week_arr = ['monday','tuesday','wednesday','thursday','friday','saturday','sunday']; //时段区间id $schedule_config = SystemConfig::get('docter_config'); $times[] = TimePeriod::where('start_time_period','>=',$schedule_config['morning_start'])->where('end_time_period','<=',$schedule_config['morning_end'])->pluck('id')->toArray(); $times[] = TimePeriod::where('start_time_period','>=',$schedule_config['afternoon_start'])->where('end_time_period','<=',$schedule_config['afternoon_end'])->pluck('id')->toArray(); $times[] = TimePeriod::where('start_time_period','>=',$schedule_config['evening_start'])->where('end_time_period','<=',$schedule_config['evening_end'])->pluck('id')->toArray(); if(empty($sche_dule)){ return ['code'=>200,'msg'=>'ok','data'=>['docter'=>$sche_dule_arr,'org_id'=>$org_id,'docter_id'=>$docter_id]]; } if($role == 1){ $ids = DocterOrganization::where(['organization_id'=>$org_id])->pluck('docter_id'); $name = Organization::where('id',$docter_id)->value('name'); $user_id = $org_id; for ($i = 0; $i<6; $i++){ $str_time = date('Y-m-d',($first_day + $i * 86400)); for($j=0;$j<3;$j++){ //dd($sche_dule); // DB::enableQueryLog(); //检测上午 $is_mo_have = SchedulePeriod::whereIn('schedule_id',$sche_dule)->where('schedule_date',$str_time)->whereIn('time_period_id',$times[$j]) ->where('organization_id','!=',$org_id)->where('docter_id',$docter_id)->count(); $is_self = SchedulePeriod::whereIn('schedule_id',$sche_dule)->where('schedule_date',$str_time)->whereIn('time_period_id',$times[$j]) ->where('organization_id','=',$org_id)->where('docter_id',$docter_id)->count(); if($is_self){ $sche_dule_arr[$j][$week_arr[$i]] = true; } if($is_mo_have){ $sche_dule_arr[$j][$week_arr[$i]] = 'other'; } } } } else { $name = Docter::where('id',$docter_id)->value('name'); $user_id = $docter_id; for ($i=0; $i<=6; $i++){ $str_time = date('Y-m-d',($first_day + $i * 86400)); for($j=0;$j<=2;$j++){ $is_mo_have = SchedulePeriod::whereIn('schedule_id',$sche_dule)->where('schedule_date',$str_time)->whereIn('time_period_id',$times[$j]) ->where('organization_id','!=',$org_id)->where('docter_id',$docter_id)->count(); $is_mo_self = SchedulePeriod::whereIn('schedule_id',$sche_dule)->where('schedule_date',$str_time)->whereIn('time_period_id',$times[$j]) ->where('organization_id',$org_id)->where('docter_id',$docter_id)->count(); if($is_mo_self){ $sche_dule_arr[$j][$week_arr[$i]] = true; } if($is_mo_have){ $sche_dule_arr[$j][$week_arr[$i]] = 'other'; } } } } // "morning_start" => "09:00" // "morning_end" => "12:00" // "afternoon_start" => "13:00" // "afternoon_end" => "18:00" // "evening_start" => "19:00" // "evening_end" => "20:00" $data['docter'] = $sche_dule_arr; $data['name'] = $name; $data['role'] = $role; $data['user_id'] = $user_id; return (json_encode(['code'=>200,'msg'=>'ok','data'=>$data])); } //编辑排班 public function setDocChedule() { $docter_id = request('docter_id'); $org_id = request('org_id'); $set_time = request('time'); $data = request('schedulingtime'); // $set_time = '2020-12-07至2020-12-13'; if(empty($set_time) || empty($org_id) || empty($docter_id)){ return json_encode(['status'=>601,'msg'=>'缺少必要参数','data'=>'']); } $all_time = explode('至',$set_time); if(count($all_time) <2) { return json_encode(['status'=>601,'msg'=>'缺少必要参数','data'=>'']); } $first_day = strtotime($all_time[0]); $start_time = intval(str_replace('-','',$all_time[0])); $end_time = intval(str_replace('-','',$all_time[1])); $schedule_id = Schedule::where(['docter_id'=>$docter_id])->whereBetween('schedule_day',[$start_time,$end_time])->pluck('id'); if(empty($schedule_id) || count($schedule_id) < 7){ // Schedule::whereIn('id',$schedule_id)->delete(); // SchedulePeriod::whereIn('schedule_id',$schedule_id); for($i = 0;$i<=6;$i++){ $real_time = $first_day + (86400 * $i); $schedule= [ 'schedule_date'=> date('Y-m-d',$real_time), 'schedule_day'=>intval(str_replace('-','',date('Y-m-d H:i:s',$real_time))), 'docter_id'=>$docter_id ] ; Schedule::Insert($schedule); // echo '日期:'.date('Y-m-d H:i:s',$real_time).'
'; print_r($self_schedule); echo ''; dd($week_schedule); } //获取月排班 public function get_month_schedule() { $date = request('date'); $org_id = intval(request('org_id')); $docter_id = intval(request('docter_id')); $type = intval(request('type')); $role = intval(request('role')); $start_time = strtotime($date); $month_day = date("t",$start_time); $end_time = ($start_time + $month_day * 86400); $start_date = date('Y-m-d',$start_time); $end_date = date('Y-m-d',$end_time); $types = [1=>1,2=>2,3=>3]; if($type == 1){ $schedule_data = Schedule::where(['docter_id'=>$docter_id,'organization_id'=>0]) ->whereBetween('schedule_date',[$start_date,$end_date])->pluck('schedule_date','id')->toArray(); $settingConfig = DocterSetting::where(['docter_id'=>$docter_id])->first(); $serviceConfig = object_array(json_decode($settingConfig['service_time'])); } else { $schedule_data = Schedule::where(['docter_id'=>0,'organization_id'=>$org_id])-> whereBetween('schedule_date',[$start_date,$end_date])->pluck('schedule_date','id')->toArray(); $settingConfig = OrganizationSettings::where(['org_id'=>$org_id])->first(); $serviceConfig = object_array(json_decode($settingConfig['service_time'])); } if(!empty($settingConfig)){ $baseData = [ ['status'=>false,'type'=>1,'start'=>$serviceConfig[1]['amStartTime'],'end'=>$serviceConfig[1]['amEndTime']], ['status'=>false,'type'=>2,'start'=>$serviceConfig[2]['pmStartTime'],'end'=>$serviceConfig[2]['pmEndTime']], ['status'=>false,'type'=>3,'start'=>$serviceConfig[3]['nightStartTime'],'end'=>$serviceConfig[3]['nightEndTime']], ]; } else{ $serviceConfig = ''; $baseData = [ ['status'=>false,'type'=>1,'start'=>$serviceConfig[1]['amStartTime'],'end'=>$serviceConfig[1]['amEndTime']], ['status'=>false,'type'=>2,'start'=>$serviceConfig[2]['pmStartTime'],'end'=>$serviceConfig[2]['pmEndTime']], ['status'=>false,'type'=>3,'start'=>$serviceConfig[3]['nightStartTime'],'end'=>$serviceConfig[3]['nightEndTime']], ]; self::baseMonthSchedule($month_day,$baseData); return []; } for($i=1;$i<=$month_day; $i++){ //$startKey = date('d',time()); $week = date('N',$start_time + ($i-1) * 86400); $scheduleDate = date('Y-m-d',$start_time + ($i-1) * 86400); if(empty($schedule_data)){ $scheduleList[] = [ 'schedulelingList'=>$baseData, 'date'=>$scheduleDate, 'week'=>$week, 'day'=>$scheduleDate ]; } else { if($type == 1){ $today = SchedulePeriod::where(['docter_id'=>$docter_id,'schedule_date'=>$scheduleDate])->where('organization_id','!=',0)->distinct('organization_id') ->distinct('type')->get(['organization_id','type'])->GroupBy('type')->toArray(); if(empty($today)){ $scheduleList[] = [ 'schedulelingList'=>$baseData, 'date'=>$scheduleDate, 'week'=>$week, 'day'=>$scheduleDate ]; } else { foreach ($today as $type => $orginfo){ $orgids = array_column($orginfo,'organization_id'); $idSum = array_sum($orgids); if($org_id == $idSum) $baseData[$type]['status'] = true; if($org_id != $idSum) $baseData[$type]['status'] = 'other'; } $scheduleList[] = [ 'schedulelingList'=>$baseData, 'date'=>$scheduleDate, 'week'=>$week, 'day'=>$scheduleDate ]; } } } //// if(empty( $schedule_data[$scheduleDate])) continue; //// $schedule_id = $schedule_data[$schedule_data]; // if($type == 1){ // $today = SchedulePeriod::where(['docter_id'=>$docter_id,'schedule_date'=>$scheduleDate])->get(['organization_id','type'])->GroupBy('type'); // // dd($today); // } //// date'=>($i+1),'day'=>$now_date,'schedulelingList'=>$arr,'week'=>$week //// dd($scheduleList); // // } // // $status = [1=>true,2=>'other',3=>false]; // // for($i=0;$i<$month_day;$i++){ // $now_time = $start_time + $i*86400; // $now_date = date('Y-m-d',$now_time); // $week = date('N',$now_time); // $arr = [ // ['status'=>false,'type'=>1,'start'=>"09:00",'end'=>'11:30'], // ['status'=>true,'type'=>2,'start'=>'13:30','end'=>'16:30'], // ['status'=>false,'type'=>3,'start'=>'19:30','end'=>'21:00'], // ]; // if($i%2 == 0){ // $arr = [ // ['status'=>false,'type'=>1,'start'=>"09:00",'end'=>'11:30'], // ['status'=>true,'type'=>2,'start'=>'13:30','end'=>'16:30'], // ['status'=>false,'type'=>3,'start'=>'19:30','end'=>'21:00'], // ]; // } // // if($i%3 == 0){ // $arr = [ // ['status'=>true,'type'=>1,'start'=>"09:00",'end'=>'11:30'], // ['status'=>'other','type'=>2,'start'=>'13:30','end'=>'16:30'], // ['status'=>true,'type'=>3,'start'=>'19:30','end'=>'21:00'], // ]; // } // // if($i%4 == 0){ // $arr = [ // ['status'=>'other','type'=>1,'start'=>"09:00",'end'=>'11:30'], // ['status'=>false,'type'=>2,'start'=>'13:30','end'=>'16:30'], // ['status'=>false,'type'=>3,'start'=>'19:30','end'=>'21:00'], // ]; // } // // if($i == 14){ // $arr = [ // ['status'=>false,'type'=>1,'start'=>"09:00",'end'=>'11:30'], // ['status'=>false,'type'=>2,'start'=>'13:30','end'=>'16:30'], // ['status'=>false,'type'=>3,'start'=>'19:30','end'=>'21:00'], // ]; // } // // $all_time[] = ['date'=>($i+1),'day'=>$now_date,'schedulelingList'=>$arr,'week'=>$week]; } return apiReturn(200,'ok',$scheduleList); } public function getDocterSetting() { $docter_id = intval(request('docter_id')); $org_id = intval(request('org_id')); $type = intval(request('type')); $setting = DocterSetting::where(['docter_id'=>$docter_id])->first(); if($type == 1){ $setting = OrganizationSettings::where(['org_id'=>$org_id])->first(); } $docterConfig = SystemConfig::get('docter_config'); if(!empty($setting)){ $setting = $setting->toArray(); } else { $configData = [ 'amStartTime'=>$docterConfig['morning_start'], 'amEndTime'=>$docterConfig['morning_end'], 'amNum'=>0, 'pmStartTime'=>$docterConfig['afternoon_start'], 'pmEndTime'=>$docterConfig['afternoon_start'], 'pmNum'=>0, 'nightStartTime'=>$docterConfig['evening_start'], 'nightEndTime'=>$docterConfig['evening_end'], 'nightNum'=>0, 'serviceNum'=>1, 'showDayNumber'=>7, 'status'=>false, 'timeSpan'=>30, ]; return apiReturn(200,'ok',$configData); } $config = object_array(json_decode($setting['service_time'])); $status = $setting['status'] ? true: false; $configData = [ 'amEndTime'=>$config[1]['amEndTime'], 'amNum'=>$config[1]['amPerson'], 'amStartTime'=>$config[1]['amStartTime'], 'nightEndTime'=>$config[3]['nightEndTime'], 'nightNum'=>$config[3]['nightPerson'], 'nightStartTime'=>$config[3]['nightStartTime'], 'pmEndTime'=>$config[2]['pmEndTime'], 'pmNum'=>$config[2]['pmPerson'], 'pmStartTime'=>$config[2]['pmStartTime'], 'serviceNum'=>$setting['service_num'], 'showDayNumber'=>$setting['show_days'], 'status'=>$status, 'timeSpan'=>$setting['service_times'], ]; return apiReturn(200,'ok',$configData); } //更新用戶設置 public function updateDocterSetting() { $docter_id = intval(request('docter_id')); $configData = request('configData'); $type = intval(request('type'));//医生类型 1 机构 2 医生 $org_id = intval(request('org_id')); $configData = object_array(json_decode($configData)); if(empty($docter_id) || empty($configData)){ return apiReturn(604,'参数错误'); } $setting = DocterSetting::where(['docter_id'=>$docter_id])->first(); if($type != 1){ $setting = OrganizationSettings::where(['org_id'=>$org_id])->first(); } if(empty($setting)){ } $self_config = object_array(json_decode($setting['service_time'])); //改变时间段 $changeTimer = []; //是否改变了服务时长 $changeSeviceTime = false; //同时服务人数 $serviceNum = intval($configData['serviceNum']); //服务时长 $serviceTime = intval($configData['timeSpan']); if(empty($setting) || $serviceTime != intval($setting['service_times'])){ $changeSeviceTime = true; $changeTimer = [1,2,3]; } else { if($configData['amStartTime'] !== $self_config[1]['amStartTime'] || $configData['amEndTime'] !== $self_config[1]['amEndTime']){ $changeTimer[] = 1; } if($configData['pmStartTime'] !== $self_config[2]['pmStartTime'] || $configData['pmEndTime'] !== $self_config[2]['pmEndTime']){ $changeTimer[] = 2; } if($configData['nightStartTime'] !== $self_config[3]['nightStartTime'] || $configData['nightEndTime'] !== $self_config[3]['nightEndTime']){ $changeTimer[] = 3; } } //添加时间段 $countArr = [ 1=>$configData['amNum'], 2=>$configData['pmNum'], 3=>$configData['nightNum'], ]; $c_r = [ 1=>['count'=>$configData['amNum'],'start_time'=>$configData['amStartTime'],'end_time'=>$configData['amEndTime']], 2=>['count'=>$configData['pmNum'],'start_time'=>$configData['pmStartTime'],'end_time'=>$configData['pmEndTime']], 3=>['count'=>$configData['nightNum'],'start_time'=>$configData['nightStartTime'],'end_time'=>$configData['nightEndTime']] ]; $changeTimer = [1,2,3]; //todo 零时关闭排班功能,后续需要解除 if($changeSeviceTime || !empty($changeTimer)){ foreach ($changeTimer as $tType){ DB::beginTransaction(); try { //1.删除旧时间段,并删除排班数据 $type == 1 ? $id = $docter_id : $id = $org_id; //todo 暂时未删除周排班 self::delteScheduleInfo($id,$type); $count = intval($countArr[$tType] / $serviceNum); //2.创建新时间段 self::makeTimePeriod($type,$docter_id,$org_id,$tType,$c_r[$tType],$count,$serviceTime); if($type == 1){ $time_periods = TimePeriod::where(['org_id' => '', 'docter_id' => $docter_id, 'type' => $tType])->pluck('id')->toArray(); $self_schedule = SelfSchedule::where(['docter_id' => $docter_id, 'schedule_type' => $type, 'organization_id'=>0,'type' =>1])->distinct('type') ->orderBy('schedule_date')->get(['schedule_date', 'type', 'week'])->toArray(); $schedule = Schedule::where(['docter_id' => $docter_id, 'organization_id'=>0])->pluck('schedule_date', 'id')->toArray(); $week_schedule = WeekSchedule::where(['docter_id' => $docter_id, 'type' => $tType,'schedule_type'=>$type]) ->distinct('type') ->orderBy('week') ->get(['week','organization_id']) ->GroupBy('week') ->toArray(); } if($type !=1 ){ $time_periods = TimePeriod::where(['org_id' => $org_id, 'docter_id' => 0, 'type' => $tType])->pluck('id')->toArray(); $schedule = Schedule::where(['docter_id' => 0, 'organization_id'=>$org_id])->pluck('schedule_date', 'id')->toArray(); $self_schedule = SelfSchedule::where(['docter_id' => 0, 'schedule_type' => $type,'organization_id'=>$org_id,'type' =>$tType])->distinct('type') ->orderBy('schedule_date')->get(['schedule_date', 'type', 'week'])->toArray(); $week_schedule = WeekSchedule::where(['organization_id' =>$org_id, 'type' => $tType,'schedule_type'=>$type]) ->distinct('type') ->orderBy('week') ->pluck('type') ->GroupBy('week') ->toArray(); } if (empty($week_schedule)) { // Schedule::where(['docter_id' => $docter_id])->delete(); // SelfSchedule::where(['docter_id' => $docter_id])->delete(); } else { //3.以周模板添加2个月的数据 self::makeSchedule($docter_id,$org_id,$type,$schedule,$week_schedule,$time_periods); //4.回复自己设置的排班 self::makeSelfScheeule($docter_id,$org_id,$type,$time_periods,$self_schedule); } DB::commit(); } catch (\Exception $e) { dd($e->getMessage()); DB::rollBack(); } } } // {"1":{"amStartTime":"08:00","amEndTime":"12:00","amPerson":3},"2":{"pmStartTime":"14:00","pmEndTime":"18:00","pmPerson":5},"3":{"nightStartTime":"18:00","nightEndTime":"23:00","nightPerson":4}} $config = [ 1=>['amStartTime'=>$configData['amStartTime'],"amEndTime"=>$configData['amEndTime'],'amPerson'=>$configData['amNum']], 2=>["pmStartTime"=>$configData['pmStartTime'],"pmEndTime"=>$configData['pmEndTime'],'pmPerson'=>$configData['pmNum']], 3=>["nightStartTime"=>$configData['nightStartTime'],"nightEndTime"=>$configData['nightEndTime'],'nightPerson'=>$configData['nightNum']] ]; $setting = [ 'docter_id'=>$docter_id, 'type'=>$type, 'status'=>$configData['status'], 'show_days'=>$configData['showDayNumber'], 'service_num'=>$configData['serviceNum'], 'service_times'=>$configData['timeSpan'], 'service_time'=>json_encode($config) ]; //更新配置 if($type == 1){ $is_have = DocterSetting::where(['docter_id'=>$docter_id])->value('id'); if($is_have){ DocterSetting::where(['docter_id'=>$docter_id])->update($setting); } else { DocterSetting::insert($setting); } } else { unset($setting['docter_id']); $setting['org_id'] = $org_id; $is_have = OrganizationSettings::where(['id'=>$docter_id])->value('id'); if($is_have){ OrganizationSettings::where(['org_id'=>$org_id])->update($setting); } else { OrganizationSettings::insert($setting); } } return apiReturn(200,'ok'); } //获取用户信息 public function getScheduleInfo() { $id = intval(request('id')); $isDocter = CdmsUsers::where('docter_id',$id)->first(); $isOrg = CdmsUsers::where('org_id',$id)->first(); $org_id = null; $role = 1; if(empty($id)){ return json_encode(['status'=>601,'msg'=>'缺少必要参数','data'=>'']); } if($isDocter){ $org_id = $isDocter->org_id; $docter = Docter::where(['id'=>$id])->first(); $role = 2; } else { if(!empty($isOrg->org_id)){ $org_id = $isOrg->org_id; } else { $role = 0; } } $lists =[]; if($role == 1){ $ids = DocterOrganization::where(['organization_id'=>$org_id])->pluck('docter_id')->toArray(); $list = Docter::whereIn('id',$ids)->distinct('id')->get(['id','name']); foreach ($list as $val){ $lists[] = ['value'=>$val->id,'label'=>$val->name]; } $name = Organization::where('id',$org_id)->value('name'); } else if($role == 2){ $ids = DocterOrganization::where(['docter_id'=>$id])->distinct('docter_id')->pluck('organization_id')->toArray(); $list = Organization::whereIn('id',$ids)->get(['id','name']); foreach ($list as $val){ $lists[] = ['value'=>$val->id,'label'=>$val->name]; } $name = Docter::where('id',$id)->value('name'); } else { $name = ''; } $type = 1; $data['user_id'] = $id; $data['name'] = $name; $data['org_id'] = $org_id; $data['docter_type'] = 0; $data['list'] = []; if(!empty($docter)){ $data['docter_type'] = $docter->type; if($docter->type == 1){ $data['list'] = $lists; } } $data['role'] = $role; return (json_encode(['code'=>200,'msg'=>'ok','data'=>$data])); } /* * @param * $id int 医生或社区id * $type int 排班类型 * @descript 删除排班数据 */ public static function delteScheduleInfo($id,$type){ if($type == 1){ TimePeriod::where(['docter_id'=>$id,'type'=>$type])->where('org_id','=',0)->delete(); SchedulePeriod::where(['docter_id'=>$id,'type'=>$type])->where('organization_id','=',0)->delete(); } else { TimePeriod::where(['org_id'=>$id,'type'=>$type])->where('docter_id','=',0)->delete(); SchedulePeriod::where(['organization_id'=>$id,'type'=>$type])->where('docter_id','=',0)->delete(); } return true; } //插入时间段 public static function makeTimePeriod($scheduleType,$docterId,$orgId,$timeType,$timeConfig,$timerCount,$serviceTime) { for($i=1;$i<=$timerCount;$i++){ $timePreiod = [ 'org_id'=>$orgId, 'docter_id'=>$docterId, 'type'=>$timeType, 'start_time_period'=> date('H:i',strtotime($timeConfig['start_time']) + ($i-1)*$serviceTime*60), 'end_time_period'=> date('H:i',strtotime($timeConfig['start_time']) + $i*$serviceTime*60), ]; if($scheduleType == 1){ $timePreiod['org_id'] = 0; $timePreiod['docter_id'] = $docterId; } else { $timePreiod['docter_id'] = 0; $timePreiod['org_id'] = $orgId; } $isHave = TimePeriod::where($timePreiod)->count(); if($isHave) continue; TimePeriod::insert($timePreiod); } return true; } //以周模板进行排班 public static function makeSchedule ($docterId,$orgId,$type,$schedule,$weekSchedule,$timePeriods){ if(empty($schedule) || count($schedule) < 58){ $start = strtotime(date('Y-m-1',time())); $today = date('j',time()); $allDay = date('t',time()); //门诊排班 if($type == 1){ $scheduleData['docter_id']=$docterId; $scheduleData['organization_id']= 0; } else { $scheduleData['docter_id']=0; $scheduleData['organization_id']= $orgId; } //第一个月 for ($i=$today;$i<=$allDay;$i++){ $todayTimer = $start + (($i - 1) *86400); $week = date('N',$todayTimer); $date = date('Y-m-d',$todayTimer); $numDate = date('Ymd',$todayTimer); $scheduleData['schedule_date'] = $date; $scheduleData['schedule_day'] = $numDate; $scheduleIsHave = Schedule::where($scheduleData)->count(); if ($scheduleIsHave) continue; Schedule::insertGetId($scheduleData); } $nextStart = strtotime(date('Y-m-1',strtotime('next month'))); $nextAllDay = date('t',strtotime('nex month')); //第二个月 for($j=1;$j<=$nextAllDay;$j++){ $todayTimer = $nextStart + (($j-1)*86400); $week = date('N',$todayTimer); $date = date('Y-m-d',$todayTimer); $numDate = date('Ymd',$todayTimer); $scheduleData['schedule_date'] = $date; $scheduleData['schedule_day'] = $numDate; $scheduleIsHave = Schedule::where($scheduleData)->count(); if ($scheduleIsHave) continue; Schedule::insertGetId($scheduleData); } $schedule = Schedule::where(['docter_id'=>$docterId,'organization_id'=>0])->where('schedule_date','>',date('Y-m-d',time())) ->distinct('schedule_date')->pluck('schedule_date','id')->toArray(); if($type == 2){ $schedule = Schedule::where(['docter_id'=>0,'organization_id'=>$orgId])->where('schedule_date','>',date('Y-m-d',time())) ->distinct('schedule_date')->pluck('schedule_date','id')->toArray(); } } foreach ($schedule as $id => $date) { $week = intval(date('N', strtotime($date))); foreach ($weekSchedule as $w) { //门诊和儿保,计免排班分开 if($type == 1){ $realWeek = $w[0]['week']; $oId = $w = $w[0]['organization_id']; } else { $realWeek = $w; $oId = $orgId; } if ($week == $realWeek) { foreach ($timePeriods as $idt) { $s_t = [ 'organization_id' => $oId, 'docter_id' => $docterId, 'type' => $type, 'schedule_date' => $date, 'schedule_id' => $id, 'time_period_id' => $idt ]; $scheduleIsHave = SchedulePeriod::where($s_t)->count(); if ($scheduleIsHave) continue; $s_t['created_at'] = Carbon::now(); $s_t['updated_at'] = Carbon::now(); SchedulePeriod::insert($s_t); } } } } return true; } //自己排班 public function makeSelfScheeule($docterId,$orgId,$type,$timesPeriods,$selfSchedule){ if($type == 1){ $orgId = 0; SelfSchedule::where(['type'=>1,'docter_id'=>$docterId,'organization_id'=>0,'schedule_type'=>$type])->whereIn('time_period_id',$timesPeriods)->delete(); } else { SelfSchedule::where(['type'=>1,'docter_id'=>0,'organization_id'=>$orgId,'schedule_type'=>$type])->whereIn('time_period_id',$timesPeriods)->delete(); $docterId = 0; } foreach ($selfSchedule as $val) { $self_data = $val; $self_data['organization_id'] = $orgId; $self_data['docter_id'] = $docterId; foreach ($timesPeriods as $idt) { $self_data['time_period_id'] = $idt; $is_self_have = SelfSchedule::where($self_data)->count(); if ($is_self_have) continue; $self_data['created_at'] = Carbon::now(); $self_data['updated_at'] = Carbon::now(); SelfSchedule::insert($self_data); } } } }