@foreach($featured_collections as $featured_collection) @php $featured_products = Helper::getProductsQuery()->where('product_store_data.store_id', $store_id)->whereIn('products.id', json_decode($featured_collection->ids, true))->groupBy('products.id')->orderBy('products.name', 'asc')->select(['products.*', 'product_brands.name as brand_name', 'product_brands.slug as brand_slug', 'product_brands.on_sale as brand_on_sale', 'product_brands.sale_percentage as brand_sale_percentage', 'product_brands.sale_starts_at as brand_sale_starts_at', 'product_brands.sale_ends_at as brand_sale_ends_at', 'stores.slug as store_slug', 'product_store_data.selling_price', 'product_store_data.instock', 'product_store_data.original_price'])->get(); @endphp @if(!$featured_products->isEmpty()) @endif @endforeach