public function demo5(){
//使用hasWhere根据article的条件查询(注:comment与article有关联),同时使用with把article查询出来:
$list = Comment::hasWhere('article',[["title","like","%美国%"]])->with("article")->select()->toArray();
//或者,效果一样
$list = Comment::with(['article'=>function($query){
$query->where("title","like","%量子%");
}])->select();
}
$enInRefundList = Bill::hasWhere('agent',[["id","like","%1%"]])->where('cname', 'like', '%' . Request::param('cname') . '%')->where('ctel', 'like', '%' . Request::param('tel') . '%')->where('iname', 'like', '%' . Request::param('iname') . '%')->where('project', 'like', '%' . Request::param('project') . '%')->where('del','eq','0')->order('id', 'desc')->paginate(50,false,
[
'type' => 'Bootstrap',
'var_page' => 'page',
//第一种方法,使用数组方式传入参数
//'query' => ['iname'=>Request::param('iname')],
//第二种方法,使用函数助手传入参数
'query' => request()->param(),
]
);