lundi 26 septembre 2016

whereHas query in Laravel

Hello guys,

        $filterArray = explode("_", $filters);

        $data['articles'] = \DB::table('products')->join('product_category', function ($q) {
            $q->on('product_category.product_id', '=', 'products.id');
        })->where('product_category.category_id', '=', $id)
            ->select('products.*')
            ->whereBetween('price_retail_1', array($priceFrom, $priceTo))
            ->whereHas('filters', function ($query, $filterArray) {
                $query->whereIn('filter_id', $filterArray);
            })
            ->orderBy('products.' . $sort, $sortOrder)
            ->get();
    }

I have the following query and I'm having some issues on the whereHas method. I'm getting an error

Unknown column 'has' in 'where clause

most likely because the $filterArray variable is out of scope for the function ( or at least that is what I am guessing. Any help on how to solve the issue is appreciated.



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire