listuję sobie produkty. Na listą mam filtr: pokaż produkty z lub bez kategorii. Opcja "nie przypisane" nie działa
$product = Products::select('products.id', 'products.name', 'products.type', 'products.product_code', 'products.manufacturers_code', 'products.active', 'manufacturers.name as manufacturer')->leftJoin('manufacturers', function ($join)
{
$join->on('products.manufacturers_id', '=', 'manufacturers.id');
});
tutaj kod po wybraniu filtra z dropdowna
if($catetoryFilter != 'W' && $categoryFilter != '')
{
if($categoryFilter == 'N')
{
// problem jest tutaj, bo gdy produkt nie ma kategorii to to podzapytanie zwraca pusty wynik.
$productsDB->where(DB::raw("(SELECT COUNT(products_categories.products_id) FROM products_categories
WHERE products_categories.products_id = products.id
GROUP BY products_categories.products_id)"), '=', 0);
}
else
{
// tutaj jest ok, działa
$productsDB->where(DB::raw("(SELECT COUNT(products_categories.products_id) FROM products_categories
WHERE products_categories.products_id = products.id
GROUP BY products_categories.products_id)"), '>', 0);
}
}