| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081 |
- <?php
- namespace app\h5\controller;
- use think\Controller;
- use think\Db;
- use think\facade\Cookie;
- class Device extends Controller
- {
- protected $deviceId = 0;
- public function __construct()
- {
- parent::__construct();
- $code = input('code','','trim');
- if($code){
- Cookie::set('code',$code);
- }
- $nCode = Cookie::get('code');
- if(!$nCode){
- $this->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();
- }
- }
|