public function index() { // Visitor::log(); $cats = Categories::orderBy('sort_id', 'asc')->get(); $products = Products::orderBy('sort_id', 'asc')->get(); Setting::get('config.mainprod', Null) ? $mainProdImg = asset('/files/img/' . Setting::get('config.mainprod')) : ($mainProdImg = asset('dist/img/photo4.jpg')); Setting::get('config.logo', Null) ? $logoMain = asset('/files/img/' . Setting::get('config.logo')) : ($logoMain = asset('dist/img/logo.png')); $topProds = DB::table('order_items')->select('product_id', DB::raw('count(*) as total'))->groupBy('product_id')->orderBy('total', 'desc')->take('5')->get(); $topProdsArr = []; foreach ($topProds as $topprod) { if (!in_array($topprod->product_id, ['fast', 'np', 'gift'])) { if (strpos($topprod->product_id, '0000')) { //dd('consist'); $pID = explode('0000', $topprod->product_id); //$topprod->product_id = $pID[0]; $prodID = $pID[0]; } else { $prodID = $topprod->product_id; } $prodName = Products::findOrFail($prodID); //echo $prodName->name; array_push($topProdsArr, ['name' => $prodName->name, 'cover' => $prodName->cover, 'link' => $prodName->urlhash]); } // code... } //dd(collect($topProdsArr)); $data = ['cats' => $cats, 'products' => $products, 'PageDescr' => Setting::get('config.maindesc'), 'PageWords' => Setting::get('config.mainwords'), 'PageAuthor' => '', 'PageTitle' => Setting::get('config.maintitle'), 'mainProdImg' => $mainProdImg, 'logoMain' => $logoMain, 'topProds' => $topProdsArr, 'totalNavLabel' => $this->totalNavLabel()]; return view('catalogPage')->with($data); }
public function index() { // Visitor::log(); $products = Products::orderBy('sort_id', 'asc')->take(6)->get(); $cats = Categories::orderBy('sort_id', 'asc')->get(); //dd(Setting::get('config.maintitle')); Setting::get('config.mainprod', Null) ? $mainProdImg = asset('/files/img/' . Setting::get('config.mainprod')) : ($mainProdImg = asset('dist/img/photo4.jpg')); Setting::get('config.logo', Null) ? $logoMain = asset('/files/img/' . Setting::get('config.logo')) : ($logoMain = asset('dist/img/logo.png')); $data = ['PageDescr' => Setting::get('config.maindesc'), 'PageWords' => Setting::get('config.mainwords'), 'PageAuthor' => '', 'PageTitle' => Setting::get('config.maintitle'), 'cats' => $cats, 'totalNavLabel' => $this->totalNavLabel(), 'mainProdImg' => $mainProdImg, 'logoMain' => $logoMain, 'products' => $products]; return view('home')->with($data); }
public function ShortLinkCategory($id) { Visitor::log(); $cat = Categories::whereUrlhash($id)->firstorfail(); $cats = Categories::orderBy('sort_id', 'asc')->get(); // Setting::get('config.mainprod', Null) ? $mainProdImg = asset('/files/img/' . Setting::get('config.mainprod')) : ($mainProdImg = asset('dist/img/photo4.jpg')); Setting::get('config.logo', Null) ? $logoMain = asset('/files/img/' . Setting::get('config.logo')) : ($logoMain = asset('dist/img/logo.png')); $topProds = DB::table('order_items')->select('product_id', DB::raw('count(*) as total'))->groupBy('product_id')->orderBy('total', 'desc')->take('5')->get(); $topProdsArr = []; foreach ($topProds as $topprod) { if (!in_array($topprod->product_id, ['fast', 'np', 'gift'])) { $prodName = Products::findOrFail($topprod->product_id); //echo $prodName->name; array_push($topProdsArr, ['name' => $prodName->name, 'cover' => $prodName->cover, 'link' => $prodName->urlhash]); } // code... } $products = Products::orderBy('sort_id', 'asc')->whereCategories_id($cat->id)->get(); //dd($products ); $data = ['cats' => $cats, 'products' => $products, 'PageDescr' => Setting::get('config.maindesc'), 'PageWords' => Setting::get('config.mainwords'), 'PageAuthor' => '', 'PageTitle' => Setting::get('config.maintitle') . ' - ' . $cat->name, 'mainProdImg' => $mainProdImg, 'logoMain' => $logoMain, 'topProds' => $topProdsArr, 'category' => $cat, 'totalNavLabel' => $this->totalNavLabel()]; return view('catalogPageOne')->with($data); }
public function editProduct($id) { // $product = Products::findOrFail($id); //dd($product->recommendProd); $myprod = $product->recommendProd; $myprods_arr = []; foreach ($myprod as $key => $value) { //$myprods_arr[] = $value->id; array_push($myprods_arr, $value->product_id_recommend); } $cats = Categories::orderBy('sort_id', 'asc')->get(); $prods = Products::orderBy('sort_id', 'asc')->get(); $cats_arr = []; foreach ($cats as $key => $value) { $cats_arr[$value->id] = $value->name; } $prods_arr = []; foreach ($prods as $key => $value) { $prods_arr[$value->id] = $value->name; } //dd($prods_arr); $product->isset == 'false' ? $product->isset = Null : $product->isset; //dd($product->isset); $data = ['CatList' => $cats_arr, 'Prods' => $prods_arr, 'myProds' => $myprods_arr, 'product' => $product, 'NewOrderCounter' => Purchase::Neworders()->count()]; return view('admin.content.productEdit')->with($data); }