Level 24
$p = Product::whereNull("sold_to_user")
->where(function ($q) use ($university) {
$q ->whereNull("target_university")
->orWhere("target_university", $university->id);
})->whereIn("user_id", $userArray)->get();
Jun 26, 2017
3
Level 1
laravel conditional nested query
I have a table name product having column name taraget_university. I need query somethings like
Product::where("sold_to_user",null)
if target_university == null then continue
if target_university !=null then query->where("target_university",$university -> id) ======================================= ->whereIn("user_id",$userArray) ->get();
How to add those conditional query ??
Level 1
Ouhare, you should use whereNotNull. PRAVASH needs the query for target_university !=null ( $q ->whereNull("target_university"))
Level 13
If target_university is a foreign_key I'd suggest looking a bit more into the magic you can do using eloquent. Not only does it make your code more readable but it's also easier to write.
I'm not sure how the query would look but assuming sold_to_user is also a relation you can use this section of the documentation to kind of construct it.
https://laravel.com/docs/5.4/eloquent-relationships#querying-relationship-existence
Please or to participate in this conversation.