Категории по полочкам

<div class="panel-body">
    <ul class="nav nav-pills nav-stacked category-menu">
        @foreach($categories as $cat)
            @if($cat->category_id == 49 || $cat->category_id ==58)
                <li class="@if(Route::current()->id == $cat->category_id) active @endif">
                    <a href="{{url('category/'.$cat->category_id)}}">{{$cat->title}}</a>
                </li>
            @else
                <li class="@if(Route::current()->id == $cat->category_id) active @endif">
                    {{----}}
                    <a class="nav-a" href="javascript:void(0)">{{$cat->title}}<b class="caret"></b></a>
                    <ul class="nav nav-pills nav-stacked category-menu nav-ul">
 
                    @foreach($sub_categories as $sub)
                            @if($cat->category_id == $sub->description)
 
                                <li @if(Route::current()->id == $sub->category_id) class="active"  @endif>
                                    <a href="{{url('category/'.$sub->category_id)}}"> - {{$sub->title}}</a>
                                </li>
                            @endif
                    @endforeach
                    </ul>
 
                </li>
            @endif
        @endforeach
    </ul>
</div>

    public function main_get(Request $request, $id, $count = 9, $orderBy = 'id', $sort = 'desc'){
        $languages = Languages::all()->first();
        if (!$langId = $request->cookie('language')) {
            $langId = $languages->id;
        }
        $segments = str_replace(url('/'), '', url()->current());
        $segments = array_filter(explode('/', $segments));
        if (isset($segments[1])) {
 
            $a = $segments[1];
            if ($a == 'fa' || $a == 'ru' || $a == "en" || $a == 'am') {
                App::setLocale($a);
                $langId = Languages::where('shortName', $a)->first()->id;
            }
        }
        $category = CategoriesTranslate::where(['language_id' => $langId, 'category_id' => $id])->first();
        $categories = CategoriesTranslate::where('language_id', $langId)->whereNull("description")->whereNull("hide")->get();
        $sub_categories = CategoriesTranslate::where('language_id', $langId)->whereNotNull("description")->whereNull("hide")->get();
        $sub_categories_id = CategoriesTranslate::where('language_id', $langId)->where("description", $id)->whereNull("hide")->get(['category_id']);
//        dd($sub_categories_id);
        $items = DB::table('items')->join('items_translates', 'items.id', '=', 'items_translates.item_id')
            ->select('items.*', 'items_translates.*')->where('language_id', $langId)->whereIn('category_id' , $sub_categories_id)->whereNull('items_translates.hide')->orderBy('items.' . $orderBy, $sort)->paginate($count);
        $currencyController = new CurrencyController();
        if (!$currency = $request->cookie('currency')) {
            $currency = "AMD";
        }
        $c = $currencyController->convert($currency);
        foreach ($items as $item) {
            $item->price = round($c * $item->price,2) . " " . $currency;
            $item->old_price = round($c * $item->old_price,2) . " " . $currency;
        }
 
        return view("front.category")->with([
            "title" => $category->title,
            'category' => $category,
            'categories' => $categories,
            'sub_categories' => $sub_categories,
            'languages' => $languages,
            'items' => $items,
        ]);
    }
 
    public function get(Request $request, $id, $count = 9, $orderBy = 'id', $sort = 'desc')
    {
        $languages = Languages::all()->first();
        if (!$langId = $request->cookie('language')) {
            $langId = $languages->id;
        }
        $segments = str_replace(url('/'), '', url()->current());
        $segments = array_filter(explode('/', $segments));
        if (isset($segments[1])) {
 
            $a = $segments[1];
            if ($a == 'fa' || $a == 'ru' || $a == "en" || $a == 'am') {
                App::setLocale($a);
                $langId = Languages::where('shortName', $a)->first()->id;
            }
        }
        $category = CategoriesTranslate::where(['language_id' => $langId, 'category_id' => $id])->first();
        $categories = CategoriesTranslate::where('language_id', $langId)->whereNull("description")->whereNull("hide")->get();
        $sub_categories = CategoriesTranslate::where('language_id', $langId)->whereNotNull("description")->whereNull("hide")->get();
        $items = DB::table('items')->join('items_translates', 'items.id', '=', 'items_translates.item_id')
            ->select('items.*', 'items_translates.*')->where(['language_id' => $langId, 'category_id' => $id])->whereNull('items_translates.hide')->orderBy('items.' . $orderBy, $sort)->paginate($count);
        $currencyController = new CurrencyController();
        if (!$currency = $request->cookie('currency')) {
            $currency = "AMD";
        }
        $c = $currencyController->convert($currency);
        foreach ($items as $item) {
            $item->price = round($c * $item->price,2) . " " . $currency;
            $item->old_price = round($c * $item->old_price,2) . " " . $currency;
        }
 
        return view("front.category")->with([
            "title" => $category->title,
            'category' => $category,
            'categories' => $categories,
            'sub_categories' => $sub_categories,
            'languages' => $languages,
            'items' => $items,
        ]);
    }

$items = DB::table('items')->join('items_translates', 'items.id', '=', 'items_translates.item_id')
            ->select('items.*', 'items_translates.*')->where('language_id', $langId)->whereIn('category_id' , $sub_categories_id)->whereNull('items_translates.hide')->orderBy('items.' . $orderBy, $sort)->paginate($count);