CODEWITHSUNDEEP
phplaraveleloquent
majjade
majjade

Reputation: 38

Laravel Eloquent, where query on child model with if statement

Can someone help me out, I'm trying to do a where query on a Child Model. Everything seems fine when I have a value for the id but it returns nothing when no id is supplied.

My goal is to get all data when no id is supplied and get specific data when id supplied.

Here's my code

Report::with(['project'])
->whereHas('project' function($q) use($programId){ 
   if($programId){
    $q->where('program_id', $programId);
   }
})->get();

Is there a better way to achieve my goal? or I just lack something on the query? Thank you in advance.

Upvotes: 1

Views: 899

Answers (2)

Paos
Paos

Reputation: 673

You can use when method for this.
The when method only executes the given closure when the first argument is true. If the first argument is false, the closure will not be executed.

Report::with('project')
->when($programId, function ($query) use ($programId) {
   $query->whereHas('project' function($q) use($programId){ 
      $q->where('project.program_id', $programId);
   });
})->get();

Upvotes: 1

dz0nika
dz0nika

Reputation: 1031

So I have a little complex answer for this type of questions where you can create a query and do every logic to it.

// Initialise the model
$query = new Report;

// Start building the query
$query->with('project');

// Check if project Id exists
if ($projectId) {
    return $query->whereHas('project', function ($subQuery) use ($projectId) {
         $subQuery->where('program_id', $programId);
    })->get();
} else {
    return $query->get();
}

Upvotes: 1

Related Questions