public function loadTable() { $products = Product::orderBy('name', 'asc')->with('category')->get(); $products->updated_at = '100'; $products_f = ['data' => $products]; echo json_encode($products_f); }
public function getAdd(Request $request) { $lastProduct = Product::orderBy('created_at', 'DESC')->first(); $perpage = 12; $imgs = Img::where('img_block', '=', 'public')->orderBy('created_at', 'DESC')->simplePaginate($perpage); return view('manage.product.add', ['TITLE' => '新增商品', 'META_KEYWORDS' => META_KEYWORDS, 'META_DESC' => META_DESC, 'PAGE_CODE' => '/manage/product/add', 'lastProduct' => $lastProduct, 'imgs' => $imgs]); }
/** * Display a listing of the resource. * * @return Response */ public function index() { $products = Product::orderBy('name', 'asc')->paginate(); $products->setPath(route('products.index')); //dd($products); return view("products.lista", compact('products')); }
/** * Save a new snapshot. * * @param Request $request * @return Response */ public function store(Request $request) { $snapshotUrl = $request->file('snapshot_url'); if ($snapshotUrl) { $filename = time() . '.' . $snapshotUrl->getClientOriginalExtension(); $filepath = '/snapshots/' . $filename; if (!Storage::disk('s3')->put($filepath, file_get_contents($snapshotUrl), 'public')) { $filename = ''; } } $this->validate($request, ['store_id' => 'required']); if (!$request->id) { $snapshot = Snapshot::create(['store_id' => $request->store_id, 'notes' => $request->notes, 'snapshot_url' => isset($filepath) ? $filepath : '']); } else { $snapshot = Snapshot::find($request->id); $snapshot->store_id = $request->store_id; $snapshot->notes = $request->notes; if ($snapshotUrl) { $snapshot->snapshot_url = $filepath; } $snapshot->save(); } $for_sale = Product::orderBy('name')->where('store_id', $request->store_id)->where('product_status', 1)->get(); foreach ($for_sale as $item) { $snapshot->products()->attach($item->id); } return redirect('/snapshot'); }
public function getIndex() { $posts = Post::orderBy('created_at', 'desc')->take(5)->get(); $products = Product::orderBy('created_at', 'desc')->take(5)->get(); $references = Reference::orderBy('created_at', 'desc')->take(5)->get(); return view('admin/index', ['posts' => $posts, 'products' => $products, 'references' => $references]); }
/** * Display the details and order form of a product * * @param $id * @param string $slug */ public function showProduct($id, $slug = '') { $bests = Product::orderBy('score', 'desc')->orderBy('price', 'desc')->take(4)->get(); $product = Product::findOrFail($id); $title = "Product {$product->name}"; return view('front.prod', compact('product', 'bests', 'title', 'customer_id')); }
/** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function index(Request $request) { $products = Product::orderBy('priority')->get(); if ($request->ajax()) { return $products->toArray(); } return view('admin.products.index', ['products' => $products]); }
public function productManagement() { $page = 'partials.admin-productManagement'; $users = User::all(); $products = Product::orderBy('created_at', 'desc')->paginate(8); $products->setPath(''); return view('quantri/admin', compact('page', 'users', 'products')); }
public function index($id = null) { if ($id == null) { return Product::orderBy('id', 'asc')->get(); } else { return $this->show($id); } }
public function home() { if ($this->isCrawler()) { $products = Product::orderBy('created_at', 'desc')->limit(20)->get(); return view('crawler.home', ['products' => $products]); } else { return view('beta'); } }
public function index() { $count_hodon = Hoadon::count(); $count_sanpham = Product::count(); $count_danhgia = Danhgia::count(); $product = Product::orderBy('id', 'DESC')->take(3)->get()->toArray(); $donhang = Hoadon::orderBy('id', 'DESC')->take(4)->get(); return view('backend.home', compact('count_hodon', 'count_sanpham', 'count_danhgia', 'product', 'donhang')); }
public function products(Request $request) { if ($request->sort && $request->orderby) { $products = Product::orderBy($request->sort, $request->orderby)->paginate(15); } else { $products = Product::orderBy('created_at', 'desc')->paginate(15); } return view('admin.products', compact('products')); }
/** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function index(Request $request) { $page = $request->input('page', null); $perpage = 10; $skip = ($page - 1) * $perpage; $orderBy = $request->input('sort', null) == 'DESC' ? 'DESC' : 'ASC'; $products = Product::orderBy('name', $orderBy)->skip($skip)->take($perpage)->get()->toArray(); return Response::json(array('error' => false, 'products' => $products), 200); }
/** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function index() { $sliders = Slider::all(); $categories = Category::all(); $products = Product::orderBy('id', 'desc')->take(12)->get(); $discount_products = Product::where('discount', '=', 'true')->take(12)->get(); $random_products = Product::orderByRaw("RAND()")->take(10)->get(); return view('home', compact('sliders', 'categories', 'products', 'discount_products', 'random_products')); }
public function postSearch() { $products = Product::orderBy('id', 'DESC')->paginate(25); $categories = new Category(); $categoryAll = $categories->getCategoriesDropDown(); $category_id = Input::get('category_id'); $product_id = Input::get('product_id'); $productsName = Product::where('category_id', '=', $category_id)->where('id', '=', $product_id)->get(); return view('Products.list', compact('products'))->with('categoryAll', $categoryAll)->with('productsName', $productsName); }
/** * Show the application welcome screen to the user. * * @return Response */ public function index(Request $request) { if ($request->has('q')) { $q = $request->get('q'); $products = Product::where('name', 'like', "%{$q}%")->orWhere('sku', 'like', "%{$q}%")->orWhere('price', 'like', "%{$q}%")->orWhere('tags', 'like', "%{$q}%")->paginate(15); } else { //$products = Product::all(); $products = Product::orderBy('id', 'desc')->paginate(15); } return view('admin.products.index')->with('products', $products); }
public function view_products() { $data = []; if (Product::count() > 0) { $data['results'] = Product::orderBy('caption', 'asc')->get(); return response()->json($data, 200); } else { $data['results'] = "No data fund"; return response()->json($data, 404); } }
public function index() { $new_products = Product::orderBy('created_at', 'desc')->take(12)->get(); $get_best_sellers = App\OrderProduct::select('product_id', \DB::raw('COUNT(product_id) as count'))->groupBy('product_id')->orderBy('count', 'desc')->take(8)->get(); $best_sellers = []; foreach ($get_best_sellers as $product) { $best_sellers[] = $product->product; } helperFunctions::getPageInfo($sections, $cart, $total); return view('site.index', compact('new_products', 'best_sellers', 'sections', 'cart', 'total')); }
public function showAllProducts() { $user = Auth::user(); if ($user != null && $user->hasRole('admin')) { $products = Product::orderBy('created_at', 'DESC')->orderBy('votes', 'DESC')->paginate(10); $products = Product::add_created_by_and_category($products); return view('admin.products')->with('allproducts', $products); } else { return view('admin.login'); } }
/** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function index() { $limit = Input::get('limit') ? Input::get('limit') : 10; $query = Input::get('q'); if ($query) { $products = Product::where('product_code', 'LIKE', "%{$query}%")->simplePaginate($limit); } else { $products = Product::orderBy('id', 'desc')->simplePaginate($limit); #orderBy('added_time','desc')-> } return view('product.index', compact(['products', 'query'])); }
public function index(Request $request) { //search query if ($request->get('query')) { $this->validate($request, ['query' => 'required']); $search = $request->get('query'); $products = Product::orderBy('name', 'asc')->where('name', 'LIKE', '%' . $search . '%')->get(); return view('product.index', compact('products')); } $products = Product::orderBy('name', 'asc')->get(); return view('product.index', compact('products')); }
public function ProductOfCate($slug) { $cate_id = Category::where('slug', '=', $slug)->first(); $categories = Category::all(); $productOfcate = Product::where('category_id', $cate_id->id)->orderBy('created_at', 'DESC')->get(); $featured_products = FeaturedProduct::orderBy('rank', 'ASC')->get(); foreach ($featured_products as $i) { $id[] = $i->product_id; } $featured_photo = Photo::whereIn('product_id', $id)->get(); $lastest_product = Product::orderBy('created_at', 'DESC')->limit(8)->get(); return view('pages.category', compact('productOfcate', 'cate_id', 'categories', 'featured_products', 'featured_photo', 'lastest_product')); }
/** * Run the migrations. * * @return void */ public function up() { Schema::table('products', function (Blueprint $table) { $table->integer('source_id')->default(0); }); // update all of the products to have the source id of their purchase $products = Product::orderBy('name', 'asc')->get(); foreach ($products as $product) { if ($product->purchase && $product->purchase->source_id > 0) { $product->source_id = $product->purchase->source_id; $product->save(); } } }
/** * Display a listing of the resource. * * @return Response */ public function index() { // // return view("wd.admin.product.index")->withData([ // 'products' => Product::orderBy('created_at', 'desc')->paginate(16), // 'keywords' => '', // ]); $keywords = Input::get('keywords'); if (is_null($keywords) || $keywords == '') { return view("wd.admin.product.index")->withData(['products' => Product::orderBy('created_at', 'desc')->paginate(16), 'keywords' => '']); } else { return view("wd.admin.product.index")->withData(['products' => Product::where('name', 'like', '%' . $keywords . '%')->orderBy('created_at', 'desc')->paginate(16), 'keywords' => $keywords]); } }
/** * Bootstrap any application services. * * @return void */ public function boot() { view()->composer('*', function ($view) { $maxPrice = Product::orderBy('price', 'DESC')->first()->price; $minPrice = Product::orderBy('price', 'ASC')->first()->price; $colors = Color::all(); $types = Type::all(); $heartBag = User::getHeartBag(); if (Auth::check()) { $view->with('bagContent', Auth::user()->bags->where('inBag', 1))->with('colors', $colors)->with('types', $types)->with('maxPrice', $maxPrice)->with('minPrice', $minPrice)->with('heartBag', $heartBag); } else { $view->with('bagContent', 0)->with('heartBag', 0)->with('minPrice', $minPrice)->with('maxPrice', $maxPrice)->with('colors', $colors)->with('types', $types); } }); }
/** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function index(Request $request) { $limit = $request->get('limit', 10); // $products = Cache::remember('products', 15/60, function() use($limit) { // return Product::orderBy('created_at', 'desc')->paginate($limit); // return Product::all(); // }); $products = Product::orderBy('created_at', 'desc')->paginate($limit); // trigger to expose all the variants foreach ($products as $product) { $product->channels; foreach ($product->variants as $variant) { $variant->channels; } } return response()->json(array_merge($products->toArray(), ['code' => 200]), 200); }
public function statistics() { // Getting data about top 3 products $products = App\Product::orderBy('clicks', 'desc')->limit(3)->select(['id', 'item_id', 'clicks', 'views'])->get()->toArray(); foreach ($products as $key => $product) { $products[$key]['img'] = App\Product::find($product['id'])->images()->first()->toArray()['url']; } // Total clicks and earned money $total['clicks'] = App\Product::sum('clicks'); $total['earned'] = 0; // Getting data about shops + clicks per shop $shops_query = App\Shop::orderBy('name', 'desc')->select(['id', 'name', 'earned'])->get(); $shops = []; foreach ($shops_query as $shop) { $shops[] = ['id' => $shop->id, 'name' => $shop->name, 'earned' => $shop->earned, 'clicks' => round(App\Product::where('shop_id', '=', $shop->id)->sum('clicks'), 2)]; $total['earned'] += $shop->earned; } return \View::make('admin/statistics', ['title' => 'Statistiky', 'top_products' => $products, 'shops' => $shops, 'total' => $total]); }
public function postIndex(Request $request, $pid, $mode) { if ($mode == 'Delete') { // use DB facade to delete the row matching $pid \App\Product::destroy($pid); $request->session()->flash('message', 'Product ID ' . $request->input('productID') . ' Deleted'); } else { // validate that the product ID is at least 5 characters $this->validate($request, ['productID' => 'required|min:5', 'productName' => 'required|min:5', 'category' => 'required', 'price' => 'required|numeric|min:3|max:100000', 'discount' => 'required|numeric|min:0|max:30', 'active' => 'required']); // create a model and set the values, then session_save_path if ($mode == 'Edit') { // get the model from the db $products = \App\Product::where('id', '=', $pid)->get(); $product = $products->first(); } else { // instantiate a new model $product = new \App\Product(); } // now set the model attributes $product->product_id = $request->input('productID'); $product->product_name = $request->input('productName'); $product->category_id = $request->input('category'); $product->price = $request->input('price'); $product->max_discount = $request->input('discount'); $product->active = $request->input('active'); if ($mode == 'Edit') { $product->id = $pid; } $product->save(); $request->session()->flash('message', 'Product ID ' . $product->product_id . ' Updated / Added'); } $pcol = $request->session()->get('pcol'); $pord = $request->session()->get('pord'); $pord = $pord == 'A' ? 'D' : 'A'; $request->session()->put('pord', $pord); // need to refresh the products collection after changes $products = \App\Product::orderBy('product_name')->get(); // now put the collection in the session variable $request->session()->put('products', $products); // now direct to the sort route to retain the sort the user had before editing return redirect('products/sort/' . $pcol); }
public function postIndex(Request $request) { // first retrieve the product catalog $products = \App\Product::orderBy('product_name')->get(); // now filter the collection as needed based on user input //first filter on name / id if user entered a string $pmatch = strtolower($request->input('product')); if (isset($pmatch) && $pmatch != '') { $filtered = $products->filter(function ($item) use($pmatch) { return is_int(strpos(strtolower($item->product_name), $pmatch)) || is_int(strpos(strtolower($item->product_id), $pmatch)); }); $products = $filtered; } //now filter on active if not set to "Both" $active = $request->input('active'); if ($active == 1) { // show only active $filtered = $products->filter(function ($item) { return $item->active == 1; }); $products = $filtered; } elseif ($active == 0) { // show only active $filtered = $products->filter(function ($item) { return $item->active == 0; }); $products = $filtered; } // now filter by category $cat = $request->input('cat'); if (isset($cat) && $cat > 0) { $filtered = $products->filter(function ($item) use($cat) { return $item->category_id == $cat; }); $products = $filtered; } // now return the view with the filtered list $request->session()->put('products', $products); $pcol = $request->session()->get('pcol'); return view('products', ['sortOrder' => $pcol], ['products' => $products]); }
/** * Returns products based on given filters * * @param string regex * @return json result */ public function loadProducts(Request $request) { if ($request->isMethod('post')) { if (null == ($order = explode("-", $request->order)) || count($order) != 2) { $order = ['views', 'desc']; } $query = App\Product::orderBy($order[0], $order[1]); if (null != ($pattern = urldecode($request->input('pattern')))) { $query->where('product_name', 'regexp', $pattern); } if (null != ($min = $request->input('min')) && null != ($max = $request->input('max'))) { $query->where('price', '>=', $min)->where('price', '<=', $max); } if (null != ($section = urldecode($request->input('section')))) { $query->where('section_id', $section); } $products = $query->skip((int) $request->input('offset'))->take((int) $request->input('limit'))->get()->toArray(); foreach ($products as $key => $product) { $products[$key]['img'] = App\Product::find($product['id'])->images()->first()->toArray()['url']; } return json_encode($products); } return '403'; }