Laravel eloquent querying with multiple relationships


Product::with(['productdescription'=>function ($query) use ($language_id) {
            $query->where('language_id', '=', $language_id);},'images','productdiscount'])->active()->visibility(1)->order('DESC')->paginate($pagination)


 $orderdetails= OrderDetail::with(['order', 'product' => function ($query) use ($language_id ) {
        $query->with(['images','productdiscount', 'productdescription' => function ($query) use ($language_id) {
            $query->where('language_id',$language_id);
        }])->active();
    },])->distinct('product_id')->latest()->limit(6)->paginate(6);


Comments

Popular posts from this blog

PHP PDO insert query

PHP PDO count row

laravel Query distances between two coordinates with Eloquent