where('id',$id) ->where('org_id',$this->orgId) ->where('del',0) ->find(); if(!$info){ HelpHander::error('未查询到预约记录'); } $curTime = time(); $info['org_name'] = ''; $info['title'] = ''; $info['day'] = ''; $info['start'] = ''; $info['end'] = ''; $info['org_name'] = db('org')->where('id',$info['org_id'])->value('name'); $info['pass_msg'] = ''; $pass = 0; if($info['status'] == 2){ $info['pass_msg'] = '通行码仅且使用一次,请重新登记预约'; }else if ($info['status'] == 3){ $info['pass_msg'] = '预约已失效,请重新登记预约'; }else if ($info['status'] == 4){ $info['pass_msg'] = '预约未通过审核,请重新登记预约'; }else if ($info['status'] == 0){ $info['pass_msg'] = '预约正在审核中'; }else{ $info['pass_msg'] = '验证成功,允许通过!'; $pass = 1; } if($info['service_time_id'] > 0){ $time = db('service_time')->where('id',$info['service_time_id'])->find(); $info['day'] = $time?$time['day']:''; $info['start'] = date('H:i',strtotime($time['day'].' '.$time['start'])); $info['end'] = date('H:i',strtotime($time['day'].' '.$time['end'])); $info['title'] = db('service')->where('id',$info['service_id'])->value('title'); if($info['status'] == 1 && ($curTime < strtotime($info['day'].' '.$info['start']) || $curTime > strtotime($info['day'].' '.$info['end']))){ $info['pass_msg'] = '您的预约不在使用时间范围内,请确认预约时间'; $pass = 0; } } if($info['type'] == 3 && date('Y-m-d') != date('Y-m-d',strtotime($info['book_time']))){ $info['pass_msg'] = '您的预约不在使用时间范围内,请确认预约时间'; $pass = 0; } $info['pass'] = $pass; if($pass == 1){ // 已使用 db('visitor_order')->where('id',$id)->update(['status'=>2,'scan_time'=>date('Y-m-d H:i:s'),'scan_user_id'=>$this->userId]); } HelpHander::success($info); } // 我审批的 public function apply(){ $lists = db('visitor_order') ->where('from_user_id',$this->userId) ->where('del',0) ->where('type',3) ->order(['status'=>'asc','id'=>'desc']) ->select(); foreach ($lists as $k=>$v){ $lists[$k]['org_name'] = db('org')->where('id',$v['org_id'])->value('name'); $lists[$k]['from_user_name'] = db('user')->where('id',$v['from_user_id'])->value('real_name'); } HelpHander::success($lists); } public function detail(){ $id = input('id',0); $info = db('visitor_order')->where('from_user_id',$this->userId)->where('id',$id)->where('del',0)->find(); if(!$info){ HelpHander::error('记录不存在'); } $info['org_name'] = db('org')->where('id',$info['org_id'])->value('name'); $info['from_user_name'] = db('user')->where('id',$info['from_user_id'])->value('real_name'); $info['qrcode'] = Request::domain().'/admin/Qrcode/qrcode?code='.get_qrcode_str('visitor',$info['id']); HelpHander::success($info); } public function deal(){ $id = input('id',0); $s = input('s'); if($id<=0||!in_array($s,[1,4,5])){ HelpHander::error('参数错误'); } $info = db('visitor_order') ->where('id',$id) ->where('from_user_id',$this->userId) ->where('del',0) ->find(); if(!$info){ HelpHander::error('记录不存在'); } if($info['status'] != 0){ HelpHander::error('记录已处理'); } $res = db('visitor_order') ->where('id',$id) ->update(['status'=>$s,'update_time'=>date('Y-m-d H:i:s')]); if($res){ HelpHander::success([],'操作成功'); }else{ HelpHander::error('操作失败'); } } //获取待审批预约单 public function vistCount(){ $lists = db('visitor_order') ->where('from_user_id',$this->userId) ->where('del',0) ->where('type',3) ->where('status',0) ->count(); HelpHander::success($lists,'操作成功'); } }