laravel When的使用

最新推荐文章于 2023-05-03 15:42:19 发布

m0_73295033

最新推荐文章于 2023-05-03 15:42:19 发布

阅读量399

点赞数

文章标签： servlet html javascript

本文链接：https://blog.csdn.net/m0_73295033/article/details/127407373

版权

单个条件

model::when($data,function ($query,$data){
$query->where("搜索字段",$data['搜索字段']);
})->get();
多个条件

$searchData = model::when($data,function ($query,$data){
$query->where("搜索字段",$data['搜索字段']);
})->when($data,function ($query,$data){
$query->where("搜索字段",$data['搜索字段');
})->when($data,function ($query,$data){
$query->where("搜索字段",$data['搜索字段']);
})->get();
多个条件+模型关联+保留分页

$searchData = model::with([关联模型])->when($data,function ($query,$data){
if($data['is_reply'] != ""){
$query->where("is_reply",$data['is_reply']);
}
})->when($data,function ($query,$data){
if($data['store_name'] != ""){
$id = model::where('store_name','like',$data['store_name']."%")->get('id')->toArray();
foreach ($id as $k=>$v){
$query->where("product_id",$v);
}
}
})->when($data,function ($query,$data){
if($data['real_name'] != ""){
$uid = model::where('real_name','like',$data['real_name']."%")->get('uid')->toArray();
foreach ($uid as $k=>$v){
$query->where("uid",$v);
}
}
})->paginate(5);