Как я могу получить данные о продукте с другим шаблоном маршрутизации в laravel ⇐ Php

[Гость]

Функция контроллера для получения продуктов по категории:

Категория общедоступной функции (Запрос $request, $slug = null, $slug1 = null, $slug2 = null) { if (Session::has('currency')) { $curr = Currency::find(Session::get('currency')); } еще { $curr = Валюта::where('is_default', '=', 1)->first(); } $ кот = ноль; $subcat = ноль; $childcat = ноль; $minprice = (isset($request->min)) ? $request->мин: 0; $maxprice = (isset($request->max)) ? $запрос->макс: 0; $сортировка = $запрос->сортировка; $minprice = round(($minprice / $curr->value), 2); $maxprice = round(($maxprice / $curr->value), 2); if (!empty($slug)) { $cat = Категория::where('slug', $slug)->firstOrFail(); $data['cat'] = $cat; $prodcs = Продукт::select( "*", DB::raw('(СЛУЧАЙ, КОГДА размер равен NULL, ТОГДА цена ELSE size_base_price END) AS Price_filter') ); $prodcss = Продукт::select( "*", DB::raw('(СЛУЧАЙ, КОГДА размер равен NULL, ТОГДА цена ELSE size_base_price END) AS Price_filter') ); $minamount = $prodcs->where('category_id', $cat->id)->orderBy('price_filter', 'ASC')->first()->price_filter; $maxamount = $prodcss->where('category_id', $cat->id)->orderBy('price_filter', 'DESC')->first()->price_filter; // $maxamount = $maxamount + 1; } если (!empty($slug1)) { $subcat = Подкатегория::where('slug', $slug1)->firstOrFail(); $data['subcat'] = $subcat; $minamount = @Product::where('subcategory_id', $subcat->id)->orderBy('price', 'ASC')->first()->price; $maxamount = @Product::where('subcategory_id', $subcat->id)->orderBy('price', 'DESC')->first()->price; } если (!empty($slug2)) { $childcat = Childcategory::where('slug', $slug2)->firstOrFail(); $data['childcat'] = $childcat; $minamount = @Product::where('childcategory_id', $childcat->id)->orderBy('price', 'ASC')->first()->price; $maxamount = @Product::where('childcategory_id', $childcat->id)->orderBy('price', 'DESC')->first()->price; } $firstPrice = (isset($request->price[0])) ? $request->price[0] : ""; $ SecondPrice = (isset ($ request-> цена [1])) ? взорваться('-', $request->price[1]): ""; $ ThirdPrice = (isset ($ request-> цена [2])) ? взорвать('-', $request->price[2]): ""; $fourthPrice = (isset($request->price[3])) ? $request->price[3] : ""; $prods = Продукт::выбрать( "*", DB::raw('(СЛУЧАЙ, КОГДА размер равен NULL, ТОГДА цена ELSE size_base_price END) AS Price_filter') ); $prods->when($cat, function ($query, $cat) { вернуть $query->where('category_id', $cat->id); })->when($subcat, function ($query, $subcat) { вернуть $query->where('subcategory_id', $subcat->id); })->when($childcat, function ($query, $childcat) { return $query->where('childcategory_id', $childcat->id); }); if (isset($request->price[0]) || isset($request->price[1]) || isset($request->price[2]) || isset($request->price[3] ])) { $prods->where(function ($query) use ($firstPrice, $ SecondPrice, $ ThirdPrice, $ FourthPrice) { если ($firstPrice != "") { $query->having('price_filter', '', $fourthPrice); } }); } if (!isset($request->price[0]) && !isset($request->price[1]) && !isset($request->price[2]) && !isset($request->price[3])) { $prods->when($minprice, function ($query, $minprice) { return $query->having('price_filter', '>=', $minprice); }); $prods->when($maxprice, function ($query, $maxprice) { return $query->having('price_filter', '