redirect(url('/h5/index/errortxt')); } $arr = get_qrcode_arr($nCode); if(!isset($arr['type'])){ $this->redirect(url('/h5/index/errortxt')); } $this->deviceId = $arr['id']; } public function index(){ $info = Db::name('device') ->where('id',$this->deviceId) ->find(); $info['imgs'] = $info['imgs']?explode(',',$info['imgs']):[]; $df = $info['device_form']?explode(',',$info['device_form']):[]; $deviceForm = Db::name('device_form')->whereIn('id',$df)->column('title'); $info['device_form'] = $deviceForm ? implode(',',$deviceForm):''; $users = Db::name('device_user') ->alias('du') ->join('user u','u.id=du.user_id') ->where('u.enable',1) ->where('u.del',0) ->where('du.device_id',$info['id']) ->column('u.real_name'); $info['device_form'] = $deviceForm ? implode(',',$deviceForm):''; $info['users'] = $users ? implode(',',$users):''; $lists = Db::name('device_record') ->where('device_id',$this->deviceId) ->order('id desc') ->field('id,user_id,create_time') ->paginate(10,true) ->each(function($item,$key){ $item['userName'] = Db::name('user')->where('id',$item['user_id'])->value('real_name'); return $item; }); $page = $lists->render(); $this->assign('page',$page); $this->assign('lists',$lists); $this->assign('info',$info); return $this->fetch(); } public function detail($id){ $info = Db::name('device_record')->where('id',$id)->find(); $info['userName'] = Db::name('user')->where('id',$info['user_id'])->value('real_name'); $info['images'] = $info['images'] ? explode(',',$info['images']):[]; $info['content'] = strip_tags($info['content']); $info['check_json'] = json_decode($info['check_json'],true); $this->assign('info',$info); return $this->fetch(); } }