public function digitalCatalogs() { $page = 'produtos'; $websiteSettings = \App\Exceptions\Handler::readFile("websiteSettings.json"); $pages = Pages::where('slug', '=', $page)->first(); $productsCategories = ProductsCategories::orderBy('sortorder', 'asc')->get(); $activePrinciples = Products::addSelect(DB::raw('DISTINCT(activePrinciple)'))->where('activePrinciple', '!=', '')->orderBy('activePrinciple', 'asc')->get(); foreach ($activePrinciples as $activePrinciple) { array_add($activePrinciple, 'activePrincipleSlug', str_slug($activePrinciple->activePrinciple, '-')); } $digitalCatalogs = DigitalCatalogs::orderBy('sortorder', 'asc')->paginate(3); $categoryChosen = "Catálogos Digitais"; $categoryChosenSlug = "catalogos-digitais"; return view('website.products.digitalCatalogs')->with(compact('page', 'pages', 'websiteSettings', 'productsCategories', 'digitalCatalogs', 'categoryChosen', 'categoryChosenSlug', 'activePrinciples', 'activePrincipleChosenSlug')); }
public function getOrder() { if (!ACL::hasPermission('digitalCatalogs', 'edit')) { return redirect(route('digitalCatalogs'))->withErrors(['Você não tem permissão para editar a ordem dos catálogos.']); } $items = DigitalCatalogs::orderBy('sortorder', 'ASC')->addSelect('digitalCatalogsId')->addSelect('title')->addSelect('sortorder')->get(); return view('admin.digitalCatalogs.order')->with(compact('items')); }