public function getStore($id) { $store = Store::select('stores.*')->join('products', 'products.store_id', '=', 'stores.id')->where('products.id', $id)->first(); return $store->name; }
/** * @param Request $request * @return string */ public function findprice(Request $request) { $inputUrl = $request->get('url'); $checkUrl = new CheckUrl(); $provider = $checkUrl->checkurl($inputUrl); $priceFinder = new PriceFinder(); $productInfo = $priceFinder->{$provider}($inputUrl); //insert Data into stores table $store = new Store(); $store->name = $provider; $store->save(); $storeGet = Store::orderBy('id', 'desc')->first()->toArray(); //gets last inserted row $storeId = $storeGet['id']; //gets store id of last inserted row //insert Data into products table // $alreadyProduct = Product::select('products.*') // ->join('user_product', 'user_product.products_id', '=', 'products.id') // ->join('users', 'users.id', '=', 'user_product.user_id') // ->where('user_product.user_id', Auth::user()->id) // ->where('url', $inputUrl) // ->first(); $alreadyProduct = Product::where('url', $inputUrl)->first(); if ($alreadyProduct) { $alreadyProduct->name = $productInfo['name']; $alreadyProduct->image = $productInfo['image']; $alreadyProduct->save(); } else { $product = new Product(); $product->store_id = $storeId; $product->name = $productInfo['name']; $product->url = $inputUrl; $product->image = $productInfo['image']; $product->save(); } //insert data into price_history table if ($alreadyProduct) { $alreadyPriceHistory = Price_History::where('products_id', $alreadyProduct->id)->first(); $alreadyPriceHistory->price = $productInfo['price']; $alreadyPriceHistory->save(); } else { $price_history = new Price_History(); $price_history->products_id = $product->id; $price_history->price = $productInfo['price']; $price_history->save(); } $userId = Auth::user()->id; $user_product = new User_Product(); $user_product->user_id = $userId; $user_product->products_id = $alreadyProduct ? $alreadyProduct->id : $product->id; $user_product->save(); if ($alreadyProduct) { return Redirect::route('target-price', $alreadyProduct->id); } return Redirect::route('target-price', $product->id); }