public static function userLog($user_id, $beer_id, $type_id, $place_id = 0, $img_id = 0) { $user_meta = new \App\UserBeer(); $user_meta->user_id = $user_id; $user_meta->beer_id = $beer_id; $user_meta->type_id = $type_id; $user_meta->place_id = $place_id; $user_meta->img_id = $img_id; $user_meta->save(); }
public function beer($slug) { $page_title = "Beerhit!"; $page_descs = "what hit you?"; $beer = Beer::where('beers.slug', $slug)->join('beer_style', 'beers.style_id', '=', 'beer_style.id')->join('brewery', 'beers.brewery_id', '=', 'brewery.id')->select('beers.*', 'beer_style.id as beer_style_id', 'beer_style.id as beer_style_style,', 'brewery.slug as b_slug', 'brewery.id as b_id', 'brewery.name as b_name', 'brewery.city as b_city')->first(); $similar_style = Beer::where('beers.style_id', $beer->style_id)->take(10)->get(); $beer_id = $beer->id; DB::table('beers')->where('id', $beer_id)->increment('views'); //Get other beers from the same brewery $from_brewery = Beer::where('beers.brewery_id', $beer->brewery_id)->take(10)->get(); $beer_drink = UserBeer::userBeerCnt($beer_id); //ppl who drink this $beer_checkin = Checkin::checkinBeer($beer_id); //checkin locations with this beer $beerImg = BeerImg::getBeerImg($beer_id); //get all uploaded beer images return view('beer.beer', compact('page_title', 'page_descs', 'beer', 'beerImg', 'beer_drink', 'beer_ratings', 'similar_style', 'from_brewery', 'beer_checkin')); }
/** * Display the specified resource. */ public function show($slug) { $page_title = "Beerhit!"; $page_descs = "what hit you?"; $location = Location::get(); //data to display on profile page $user = User::where('username', $slug)->first(); if (!$user) { return redirect(404); } else { $user_checkin = User::getUserCheckIn($user->id); $uploaded = BeerImg::userUploaded($user->id); $drink_log = UserBeer::userDrinkLog($user->id); $userLike = UserBeer::userBeerLike($user->id); $drink_cnt = UserBeer::where('user_id', $user->id)->count(); $user_flg = isset(Auth::user()->id) ? TRUE : FALSE; $data = array('page_title' => $page_title, 'page_descs' => $page_descs, 'user' => $user, 'drink_cnt' => $drink_cnt, 'drink_log' => $drink_log, 'drink_uploaded' => $uploaded, 'user_flg' => $user_flg, 'user_like' => $userLike, 'user_checkin' => $user_checkin, 'location' => $location); return view('pages.user', $data); } }
public static function checkUserLog($user_id, $beer_id, $type_id) { $check = \App\UserBeer::where('user_id', $user_id)->where('beer_id', $beer_id)->where('type_id', $type_id)->count(); return $check; }