$where=[];
$page['page']=input('page');
Db::table('think_order')->alias('o')->where($where)
->join('think_work w','o.id = w.artist_id')
->join('think_card c','o.card_id = c.id')
->field('o.*,w.work,c.card')
->order('o.id','desc')
->paginate(input('limit'),false,$page)->each(function ($item, $key) {
$item['create_time'] = date("Y-m-d H:i",$item['create_time']);
if($item['status']=='0'){$item['status']='未审核';}else{$item['status']='已审核';}
return $item;
});
tp5.1多表联查
最新推荐文章于 2023-03-27 14:04:30 发布