Laravel Query Joins with Condition
Copy Below Code
View As A Text File
Show Text Only
Show API
Edit Code
$dataQ = $this->myModArr['model']::where($searchArr)
->select('pb_business.*','pb_business.id as busId')
->groupBy('busId');
if($email){
$dataQ->join('pb_users',function($join) use ($email){
$join->on('pb_business.id','=','pb_users.business_id')
->where('pb_users.email','=',$email);
});
}
if($phone){
$dataQ->join('pb_users',function($join) use ($phone){
$join->on('pb_business.id','=','pb_users.business_id')
->where('pb_users.phone','=',$phone);
});
}
if($package){
$dataQ->join('pb_payment_business_subscriptions',function($join) use ($package){
$join->on('pb_business.id','=','pb_payment_business_subscriptions.business_id')
->where('pb_payment_business_subscriptions.package_id','=',$package);
});
}