{{ route('home') }} {{ route('store-details') }} @php $stores = DB::table('stores')->where('active', 1)->orderBy('id', 'asc')->get(); @endphp @if(!$stores->isEmpty()) @foreach($stores as $store) {{ route('shop-all', $store->slug) }} {{ route('contact-us', $store->slug) }} @php $brands = DB::table('product_brands')->where('active', 1)->where('total_products', '>', 0)->whereNull('deleted_at')->orderBy('name', 'asc')->get(); $products = Helper::getProductsQuery()->where('product_store_data.store_id', $store->id)->groupBy('products.id')->orderBy('products.name', 'asc')->select(['products.slug'])->get(); $categories = Helper::getMainCategories(); @endphp @if(!$categories->isEmpty()) @foreach($categories as $category) @php $sub_categories = Helper::getSubCategories($category->id)->get(); @endphp @if ($sub_categories->isEmpty()) {{ route('category', [$store->slug, $category->slug]) }} @else @foreach($sub_categories as $sub_category) {{ route('category', [$store->slug, $sub_category->slug]) }} @endforeach @endif @endforeach @endif @foreach($brands as $brand) {{ route('brand', [$store->slug, $brand->slug]) }} @endforeach @foreach($products as $product) {{ route('product', [$store->slug, $product->slug]) }} @endforeach {{ route('specials', $store->slug) }} @endforeach @endif @php $ecommerce_pages = DB::table('pages')->where('ecommerce_page', 1)->where('home_page', 0)->where('active', 1)->whereNull('deleted_at')->get(); @endphp @if(!$ecommerce_pages->isEmpty()) @foreach($ecommerce_pages as $ecommerce_page) {{ route('ecommerce-store', $ecommerce_page->slug) }} @endforeach @endif @php $ecommerce_pages = DB::table('pages')->where('ecommerce_page', 0)->where('home_page', 0)->where('active', 1)->whereNull('deleted_at')->get(); @endphp @if(!$ecommerce_pages->isEmpty()) @foreach($ecommerce_pages as $ecommerce_page) {{ route('libra-store', $ecommerce_page->slug) }} @endforeach @endif