场景描述
我需要根据分类、名称这两个个查询条件去取出结果集,这三者的关系是:商品分类 and (商品名称 or 条形码)
错误尝试
第一次写出来的代码是这样的:$limit = $request->query('limit',5);
$keyword = $request->query('keyword','');
$status = $request->query('status','');
$data = $currency
->select(
'tbm_currency.*',
'users.name as username'
)
->leftJoin('users','users.id','=','tbm_currency.user_id')
->when($status,function($query) use($status){
return $query->where('tbm_currency.status',$status);
})
->when($keyword,function ($query) use($keyword){
return $query->where('tbm_currency.name', '