@php $mobile_category = App\Category::findOrFail(1); $mobile_sub_category_order = $mobile_category->childrenCategories()->whereNotNull('positon_display')->orderBy('positon_display', 'asc')->get(); $mobile_sub_category_unorder = $mobile_category->childrenCategories()->where('positon_display', null)->get(); $mobile_sub_sub_category_order = App\Category::whereIn('category_id',$mobile_sub_category_order->pluck('id'))->pluck('id'); $mobile_sub_sub_category_unorder = App\Category::whereIn('category_id',$mobile_sub_category_unorder->pluck('id'))->pluck('id'); $phone_news_products_order = App\Product::whereIn('category_id',$mobile_sub_sub_category_order)->where('brand_status',2)->get(); $phone_news_products_unorder = App\Product::whereIn('category_id',$mobile_sub_sub_category_unorder)->where('brand_status',2)->get(); $tablets_order = App\Category::where('slug','tablet')->first()->childrenCategories()->whereNotNull('positon_display')->orderBy('positon_display', 'asc')->get(); $tablets_unorder = App\Category::where('slug','tablet')->first()->childrenCategories()->where('positon_display', null)->get(); $wearable_accessories_order = App\Category::where('slug','wearable-accessories')->first()->childrenCategories()->whereNotNull('positon_display')->orderBy('positon_display', 'asc')->get(); $wearable_accessories_unorder = App\Category::where('slug','wearable-accessories')->first()->childrenCategories()->where('positon_display', null)->get(); $consumer_electronics_order = App\Category::where('slug','consumer-electronic')->first()->childrenCategories()->whereNotNull('positon_display')->orderBy('positon_display', 'asc')->get(); $consumer_electronics_unorder = App\Category::where('slug','consumer-electronic')->first()->childrenCategories()->where('positon_display', null)->get(); $tvav = App\Category::where('slug','tvav')->first()->childrenCategories()->where('positon_display', null)->get(); $tvav_order = App\Category::where('slug','tvav')->first()->childrenCategories()->whereNotNull('positon_display')->orderBy('positon_display', 'asc')->get(); $home_appliance = App\Category::where('slug','home-appliance')->first()->childrenCategories()->where('positon_display', null)->get(); $home_appliance_order = App\Category::where('slug','home-appliance')->first()->childrenCategories()->whereNotNull('positon_display')->orderBy('positon_display', 'asc')->get(); @endphp