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