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;
}
