public function index(Request $request)
{
$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, '-'));
}
$products = Products::orderBy('name', 'asc');
$categoryChosen = "";
$categoryChosenSlug = "";
if (isset($request->slug)) {
$productsCategory = ProductsCategories::where('productsCategoriesSlug', '=', $request->slug)->first();
if (!empty($productsCategory->productsCategoriesId)) {
$categoryChosen = $productsCategory->productsCategoriesName;
$categoryChosenSlug = $request->slug;
$products = $products->where('productsCategoriesId', '=', $productsCategory->productsCategoriesId);
}
}
if (isset($request->activePrincipleSlug)) {
$products = $products->where('activePrinciple', 'LIKE', str_replace('-', ' ', $request->activePrincipleSlug));
}
$activePrincipleChosenSlug = isset($request->activePrincipleSlug) ? $request->activePrincipleSlug : null;
$products = $products->paginate(15);
return view('website.products.index')->with(compact('page', 'pages', 'websiteSettings', 'productsCategories', 'products', 'categoryChosen', 'categoryChosenSlug', 'activePrinciples', 'activePrincipleChosenSlug'));
}
public function getEdit($productsId)
{
if (!ACL::hasPermission('products', 'edit')) {
return redirect(route('products'))->withErrors(['Você não pode editar produtos.']);
}
$imageDetails = ['folder' => $this->folder, 'folderBull' => $this->folderBull, 'imageWidth' => $this->imageWidth, 'imageHeight' => $this->imageHeight];
$categories = ['' => 'Escolher...'];
$productsCategories = ProductsCategories::where('type', '=', 0)->orderBy('sortorder', 'ASC')->get();
foreach ($productsCategories as $productsCategory) {
$categories[$productsCategory['productsCategoriesId']] = $productsCategory['productsCategoriesName'];
}
$product = Products::where('productsId', '=', $productsId)->first();
return view('admin.products.edit')->with(compact('product', 'imageDetails', 'categories'));
}
