public function index(){ $tj="1"; $keywords=""; // 搜索 if(Request::instance()->isGet()){ $keywords=input('get.keywords'); $tj.=" and a.campusername like '%".$keywords."%'"; } //查询 $a=config('database.prefix')."clothes_order"; $b=config('database.prefix')."school_class"; $c=config('database.prefix')."class"; $d=config('database.prefix')."sex"; $arr=$this->db->table("$a a") ->where($tj) ->join("$b b ", "a.schoolclassid=b.id and b.del=0", 'LEFT') ->join("$c c ", "b.classid=c.id and c.del=0", 'LEFT') ->join("$d d ", "a.sex=d.id", 'LEFT') ->group('a.uid') ->field('a.uid,a.campusername,a.height,a.weight,a.schoolname,c.name as classname,d.sex as sexname') ->paginate(10,false,['query'=>request()->param()])->each(function($item){ $uid= $item['uid']; //获取数据集中的id $addressinfo=Db::name('order_address')->where('uid',$uid)->limit(1)->find(); $item['username']=$addressinfo['username']; $item['address']=$addressinfo['address']; $item['phone']=$addressinfo['phone']; return $item; }); return view('list',['keywords'=>$keywords,'arr'=>$arr]); }
TP5 paginate()分页后给结果集追加字段和数据
最新推荐文章于 2021-05-25 18:04:47 发布