What is a promise in Javascript?

Question

Soy César Mora

Asked: 2020-08-06 20:24:57 +0800 CST 2020-08-06 20:24:57 +0800 CST 2020-08-06 20:24:57 +0800 CST

Aliases for query in two tables with laravel

Is there a shorthand way to identify the columns of each table by creating the query like this?

$product = Product::with(['order'])->where('user_id','=',\Auth::user()->id)->find($id);

For example specifying something like this:

->where('order.user_id','=',\Auth::user()->id)

user_id is a field from the order table, the example doesn't work as it doesn't recognize the user_id field .

Or for these type of queries I need to use if or if the buldier DB::

Shaz · Answer 1 · 2020-08-07T04:50:52+08:00

Best Answer

Shaz

That's what the whereHas function is for, which performs a query on the relation:

->whereHas('order', function ($query) {
    $query->where('user_id', \Auth::user()->id);
})->find($id);