601,'msg'=>'缺少必要参数','data'=>'']);
} else{
// echo 'what happend';
}
$all_time = explode('至',$set_time);
if(count($all_time) <2){
return json_encode(['status'=>601,'msg'=>'缺少必要参数','data'=>'']);
}
$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,
]
];
//周字段映射
$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 ['status'=>200,'msg'=>'ok','data'=>['docter'=>$sche_dule_arr,'org_id'=>$org_id,'docter_id'=>$docter_id]];
}
$role = 2;
if($role == 1){
$ids = DocterOrganization::where(['organization_id'=>$org_id])->pluck('docter_id');
$list = Docter::whereIn('id',$ids)->get(['id as value','name as label'])->toArray();
$name = Organization::where('id',$docter_id)->value('name');
$user_id = $org_id;
for ($i = 1; $i<7; $i++){
$str_time = date('Y-m-d',($first_day + $i * 86400));
for($j=0;$j<3;$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)->count();
['schedule_id'=>$sche_dule,'schedule_date'=>$str_time,'organization_id'=>$org_id,'docter_id'=>$docter_id];
$is_self = SchedulePeriod::whereIn('schedule_id',$sche_dule)->where('schedule_date',$str_time)->whereIn('time_period_id',$times[$j])
->where('organization_id',$org_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 {
$ids = DocterOrganization::where(['docter_id'=>$docter_id])->pluck('organization_id');
$list = Organization::whereIn('id',$ids)->get(['id as value','name as label'])->toArray();
$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();
// echo $i.'--'.$j.'is_self---'.$is_mo_self.'
';
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['list'] = $list;
$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);
$schedule_id = Schedule::where(['organization_id'=>$org_id,'docter_id'=>$docter_id,'schedule_date'=>$all_time[0]])->value('id');
if(count($all_time) <2) {
return json_encode(['status'=>601,'msg'=>'缺少必要参数','data'=>'']);
}
$start_time = intval(str_replace('-','',$all_time[0]));
$end_time = intval(str_replace('-','',$all_time[1]));
$first_day = strtotime($start_time);
//周字段映射
$week_arr = ['monday','tuesday','wednesday','thursday','friday','saturday','sunday'];
// $data = [
// [
// 'date'=>"上午",
// 'monday'=>false,
// 'tuesday'=>false,
// 'wednesday'=>false,
// 'thursday'=>true,
// 'friday'=>false,
// 'saturday'=>false,
// 'sunday'=>false,
// ],
// [
// 'date'=>"下午",
// 'monday'=>false,
// 'tuesday'=>true,
// 'wednesday'=>false,
// 'thursday'=>false,
// 'friday'=>false,
// 'saturday'=>false,
// 'sunday'=>false,
// ],
// [
// 'date'=>"晚上",
// 'monday'=>false,
// 'tuesday'=>false,
// 'wednesday'=>true,
// 'thursday'=>false,
// 'friday'=>false,
// 'saturday'=>false,
// 'sunday'=>false,
// ]
// ];
//时段区间id
$schedule_config = SystemConfig::get('docter_config');
$times[1] = TimePeriod::where('start_time_period','>=',$schedule_config['morning_start'])
->where('end_time_period','<=',$schedule_config['morning_end'])
->pluck('id')->toArray();
$times[2] = TimePeriod::where('start_time_period','>=',$schedule_config['afternoon_start'])
->where('end_time_period','<=',$schedule_config['afternoon_end'])
->pluck('id')->toArray();
$times[3] = TimePeriod::where('start_time_period','>=',$schedule_config['evening_start'])
->where('end_time_period','<=',$schedule_config['evening_end'])
->pluck('id')->toArray();
foreach ($times as $val){
foreach ($val as $t){
$time_period[] = $t;
}
}
$data[0] = array_values(object_array(json_decode($data[0])));
$data[1] = array_values(object_array(json_decode($data[1])));
$data[2] = array_values(object_array(json_decode($data[2])));
$mo_schedule = array_values($data[0]);
$af_schedule = array_values($data[1]);
$ev_schedule = array_values($data[2]);
DB::beginTransaction();
try {
$schedule_insert = [
'organization_id'=>$org_id,
'docter_id'=>$docter_id,
'schedule_date'=>$all_time[0],
'schedule_day'=>$start_time,
'created_at'=>Carbon::now(),
'updated_at'=>Carbon::now(),
];
if(!$schedule_id){
$schedule_id = Schedule::insertGetId($schedule_insert);
}
unset($schedule_insert['schedule_day']);
$schedule_insert['schedule_id'] =$schedule_id;
$info = [];
for ($i = 1 ;$i<=3;$i++){
$mo_schedule = array_values($data[$i-1]);
foreach ($mo_schedule as $key=>$val){
if($key==0) continue;
$schedule_date = $start_time + $key;
$strtime = "$schedule_date";
$time_insert = $schedule_insert;
$time_insert['type'] = $i;
$schedule_time = $times[$i];
$real_time = date('Y-m-d',($first_day + ($key-1)*86400));
$time_insert['schedule_date'] = $real_time;
$time_insert['me_sure'] = 1;
if($val == true){
$data['schedule_date'] = $start_time ;
foreach ($schedule_time as $time_id){
$is_have = SchedulePeriod::where(['time_period_id'=>$time_id,'type'=>($i),'docter_id'=>$docter_id,'schedule_date'=>$real_time,'organization_id'=>$org_id,'docter_id'=>$docter_id,'schedule_id'=>$schedule_id])->value('id');
if($is_have) break;
$time_insert['time_period_id'] = $time_id;
$info[] = $time_insert;
SchedulePeriod::insert($time_insert);
}
} else {
$data['schedule_date'] = $start_time;
foreach ($schedule_time as $time_id){
$is_have = SchedulePeriod::where(['time_period_id'=>$time_id,'type'=>($i),'docter_id'=>$docter_id,'schedule_date'=>$real_time,'organization_id'=>$org_id,'docter_id'=>$docter_id,'schedule_id'=>$schedule_id])->value('id');
if($is_have) SchedulePeriod::where(['time_period_id'=>$time_id,'type'=>($i),'docter_id'=>$docter_id,'schedule_date'=>$real_time,'organization_id'=>$org_id,'docter_id'=>$docter_id,'schedule_id'=>$schedule_id])->delete();
}
}
}
}
DB::commit();
} catch (Exception $e){
DB::rollBack();
Log::info($e->getMessage());
}
return json_encode(['status'=>200,'msg'=>'插入成功','data'=>count($info)]);
}
//获取用户信息
public function getScheduleInfo()
{
$docter_id = request('id');
$org_id = request('org_id');
$is_docter = CdmsUsers::where('docter_id',$docter_id)->first();
if(empty($org_id) && empty($docter_id)){
return json_encode(['status'=>601,'msg'=>'缺少必要参数','data'=>'']);
}
$role = 1;
if($is_docter){
$role = 2;
}
$lists =[];
if($role == 1){
$ids = DocterOrganization::where(['organization_id'=>$org_id])->pluck('docter_id')->toArray();
$list = Docter::whereIn('id',$ids)->get(['id','name']);
foreach ($list as $val){
$lists[] = ['value'=>$val->id,'label'=>$val->name];
}
$name = Organization::where('id',$org_id)->value('name');
$user_id = $org_id;
} else {
$ids = DocterOrganization::where(['docter_id'=>$docter_id])->pluck('organization_id');
$list = Organization::whereIn('id',$ids)->get(['id','name']);
foreach ($list as $val){
$lists[] = ['value'=>$val->id,'label'=>$val->name];
}
$name = Docter::where('id',$docter_id)->value('name');
$user_id = $docter_id;
}
$data['user_id'] = $user_id;
$data['name'] = $name;
$data['role'] = $role;
$data['list'] = $lists;
return (json_encode(['code'=>200,'msg'=>'ok','data'=>$data]));
}
//获取图文订单
public function get_chat_order()
{
$org_id = 1;
// $docter_id = 1;
$docter_id = request('docter_id');
if(empty($docter_id)){
return json_encode(['status'=>601,'msg'=>'缺少必要参数','data'=>'']);
}
$list = Order::where(['organization_id'=>$org_id,'docter_id'=>$docter_id,'order_status'=>3])->with('orderUser')->distinct('user_id')->get('user_id');
$user_list = [];
foreach ($list as $val){
$user_list[] = [
'id'=>$val->user_id,
'avatar'=>$val->orderUser->avatar,
'name'=>$val->orderUser->nickname,
];
}
$data['docter'] = Docter::where('id',$docter_id)->first(['id','avatar','name']);
$data['order_list'] = $user_list;
return (json_encode(['code'=>200,'msg'=>'ok','data'=>$data]));
}
}