1, 'd.doctor_status' => 1, 'info.video_switch' => 1, 'info.video_model' => 2,//只要即时的 ]; $keshi_ids = Db::name('doctor')->alias('d') ->join('doctor_info info','d.id = info.doctor_id','LEFT') ->where($where)->column('keshi_id'); //所有科室,没医生的科室就不要了 $list = Db::name('keshi')->where('is_show',1)->where('id','IN',$keshi_ids)->order('weigh','desc')->select(); $this->success(1,$list); } //医生列表 //首页推荐,搜索 public function doctor_list(){ $where = [ 'd.status' => 1, 'd.doctor_status' => 1, 'info.video_switch' => 1, 'info.video_model' => 2,//只要即时的 ]; //科室id $keshi_id = input('keshi_id',0); if($keshi_id){ $where['d.keshi_id'] = $keshi_id; } //关注 $folllow = input('follow',0); if($folllow){ $my_follow_ids = controller('Userfollow')->my_follow_uids(); $where['d.id'] = ['IN',$my_follow_ids]; } $field = [ 'd.id','d.nickname','d.avatar','d.keshi_id','d.level_id','d.hospital','d.goodat','d.job_status','d.is_online', 'keshi.name as keshi_name', 'level.name as level_name', 'info.video_model', ]; $list = Db::name('doctor')->alias('d') ->field($field) ->join('doctor_level level','d.level_id = level.id','LEFT') ->join('keshi','d.keshi_id = keshi.id','LEFT') ->join('doctor_info info','d.id = info.doctor_id','LEFT') ->where($where)->order('d.ordernum desc')->autopage()->select(); $list = list_domain_image($list,['avatar']); if(!empty($list)){ foreach($list as $key => &$val){ if($val['is_online'] != 1){ $val['job_status'] = 0; } } } $this->success(1,$list); } //医生详情 public function doctor_info(){ $id = input('id',0); $field = [ 'd.id','d.nickname','d.avatar','d.keshi_id','d.level_id','d.hospital','d.goodat','d.info','d.job_status','d.is_online', 'info.video_model', 'keshi.name as keshi_name', 'level.name as level_name', ]; $info = Db::name('doctor')->alias('d') ->field($field) ->join('doctor_level level','d.level_id = level.id','LEFT') ->join('keshi','d.keshi_id = keshi.id','LEFT') ->join('doctor_info info','d.id = info.doctor_id','LEFT') ->where('d.id',$id)->find(); $info = info_domain_image($info,['avatar']); if($info['is_online'] != 1){ $info['job_status'] = 0; } //是否关注 $info['is_follow'] = $this->is_follow($this->auth->id,$id); //视频说明 $info['tv_wenzhen_video_serverrule'] = config('site.tv_wenzhen_video_serverrule'); $this->success(1,$info); } //医生排班 public function doctor_paiban(){ $doctor_id = input('doctor_id',0); if(!$doctor_id){ $this->error(); } //正式用数据 $list = Db::name('doctor_paiban')->where('doctor_id',$doctor_id)->where('active',1)->where('activetime','gt',time()+7200)->order('activetime asc')->select(); //测试用数据 // $list = Db::name('doctor_paiban')->where('doctor_id',$doctor_id)->where('active',1)->where('activetime','gt',time())->order('activetime asc')->select(); $newlist = []; if(!empty($list)){ //预约到此刻后面的订单 $need_unset = []; $map = [ 'doctor_id' => $doctor_id, 'ordertype' => 2, 'status' => ['IN','10,20,25,30'],//有效订单 'book_time'=> ['gt',time()], 'video_model' => 1, //预约模式 ]; $order_booked = Db::name('wenzhen_order')->where($map)->group('book_time')->column('book_time,count(id) as count_number'); if(!empty($order_booked)){ foreach($order_booked as $bk => $bv){ if($bv >= 4){ $need_unset[] = $bk; } } } //重组时间数据 foreach($list as $key => $val){ //排除接满4单的 if(in_array($val['activetime'],$need_unset)){ continue; } $newlist[] = date('Y-m-d H:i',$val['activetime']); } } $this->success(1,$newlist); } //关注某人,取关 public function follow_one(){ $follow_uid = input('doctor_id',0); if(!$follow_uid){ $this->error(__('Invalid parameters')); } $checkuser = Db::name('doctor')->find($follow_uid); if(empty($checkuser)){ $this->error('此医生不存在'); } $map = [ 'uid' => $this->auth->id, 'follow_uid' => $follow_uid, ]; $check = Db::name('user_follow')->where($map)->find(); if($check){ //取关 $rs = Db::name('user_follow')->where($map)->delete(); $this->success('操作成功'); } $id = Db::name('user_follow')->insertGetId($map); $this->success('操作成功',$id); } }