public function checkSubcatNameExist($category_id, $sub_catname) { try { $ifExist = subcategory::where('category_id', '=', $category_id)->where('sub_category_name', $sub_catname)->get(); //$ifExist = subcategory::where('category_id','=','1')->where('sub_category_name','=','Office Partition')->get(); // return $ifExist; if (count($ifExist) <= 0) { return '0'; //no data } else { return '1'; //with data } } catch (\Exception $e) { return '0'; } }
public function showProducts(Request $request) { try { //return $this->checkUserLevel(); if ($request->isMethod('GET')) { if ($this->checkUserLevel() == 'authFailed') { return redirect('/HMadmin/login'); } else { if ($this->checkUserLevel() == 'authErr') { return redirect('/HMadmin/login'); } else { if ($this->checkUserLevel() == 'empty') { return 'no indicator'; } else { foreach ($this->checkUserLevel() as $indicatorInfo) { $indicator_id = $indicatorInfo->id; $indicator_name = $indicatorInfo->indicator_name; $indicator_for = $indicatorInfo->indicator_for; } if ($indicator_name == 'STORE ADMIN') { $userLogin = Auth::user(); $storeowner = storeowner::where('store_id', '=', $userLogin->login_id)->with('showStoreInfo')->get(); $category = category::all(); $sub_category = subcategory::where('store_id', '=', $userLogin->login_id)->orWhere('store_id', '=', '0')->get(); $productinformation = productinformation::where('store_id', '=', $userLogin->login_id)->get(); $brand = brand::all(); $market = market::all(); $variants = variants::all(); $indicator = indicator::where('indicator_for', '=', 'PRODUCT STATUS')->get(); $product_status = indicator::where('indicator_for', '=', 'PRODUCT PRICE')->get(); //return json_encode($productinformation); return view('admin.products.products')->with('userLevel', $indicator_name)->with('userinfo', $storeowner)->with('market_info', $market)->with('category_info', $category)->with('sub_cat', $sub_category)->with('indicator', $indicator)->with('product_status', $product_status)->with('variants', $variants)->with('brand_info', $brand)->with('productinformation', $productinformation); } else { $userLogin = Auth::user(); $storeowner = storeowner::where('store_id', '=', $userLogin->login_id)->with('showStoreInfo')->get(); return view('admin.products.products')->with('userLevel', $indicator_name)->with('userinfo', $storeowner); } } } } } else { //err method err } } catch (\Exception $e) { } }