How to use whereHas() and with() in laravel 8?

Laravel is very famous and widely used PHP Framework. Nowadays, I am doing development in Laravel 8 along with other RoR and Java projects.

I was working on a Laravel 8 project in which I had to show related records and also by any criteria if related record doesn’t exist then don’t show main any record.

To achieve required results, I used whereHas() and with() eloquent methods. For this, there must be hasMany() and belongTo() method defined in models.

For example, I had two models Customer and Order.

In Customer Model.

public function orders() {
 $this->hasMany("Order");
} 

In Order Model.

public function customer() {
 $this->belongsTo("Cutomer");
}

Then, I created a repository file where I write all queries.

public function fetchCustomerOrders($where) {
 $callBack = function ($query) use($where) {
 $query->where(“customer_id”, “=”, $where[“customer_id”])
}
$customers = Customer::whereHas(“orders”, $callback)
->with([‘order’ => $callback])->get();
return $customers;
}

To make code clean, I made a where clause function in “$callback” variable, you can also create a separate private function in which you can define all your where clause and then call it in whereHas and with clauses.

I hope this will help.