Dynamic query eloquent

Question

I have these 2 linked models: jobs and job_translations. A job have many translations. So in my job model, there is :

/**
 * Get the translations for the job.
 */
public function translations()
{
    return $this->hasMany('App\Models\JobTranslation');
}

In my controller, I want to build a query dynamically like that :

$query = Job::query();
if ($request->has('translation')) {
            $query->translations()->where('external_translation', 'ilike', '%'.$request->translation.'%');
        }

$jobs = $query->paginate(10);

I have this error :

Call to undefined method Illuminate\Database\Eloquent\Builder::translations()

Is it possible to do such a dynamic query with Eloquent?

Namoshek · Accepted Answer · 2019-09-12 14:42:13Z

1

Yes, it is possible. What you are looking for is whereHas('translations', $callback) instead of translations():

$query = Job::query();
if ($request->has('translation')) {
    $query->whereHas('translations', function ($query) use ($request) {
        $query->where('external_translation', 'ilike', '%'.$request->translation.'%');
    });
}

$jobs = $query->paginate(10);

Your query can be improved further by using when($condition, $callback) instead of an if:

$jobs = Job::query()
    ->when($request->translation, function ($query, $translation) {
        $query->whereHas('translations', function ($query) use ($translation) {
            $query->where('external_translation', 'ilike', "%{$translation}%");
        });
    })
    ->paginate(10);

edited Sep 12, 2019 at 14:42

answered Sep 12, 2019 at 14:15

Namoshek

6,5562 gold badges21 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Dom Over a year ago

Hello Namoshek. GREAT, it works exactly as expected. You saved my day . Merci beaucoup. Dom

Ahmed Atoui · Accepted Answer · 2019-09-12 14:14:15Z

0

the issue you should do eager loading to detected on next chained query like this:

$query = Job::with('translations')->query();

answered Sep 12, 2019 at 14:14

Ahmed Atoui

1,5661 gold badge10 silver badges11 bronze badges

Collectives™ on Stack Overflow

Dynamic query eloquent

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related