<?
session_start();

include('../includes/config.php');

$typePar = $_GET['t'];

$r = str_replace("~", "/",$typePar);
$array = array("'"," ","-");
$replaced = str_replace($array, " ",$r);

$type = ucwords($replaced);
$t = ucwords($replaced);
if ($type == "Ipa") {
    $type = "India Pale Ale";
}
if ($type == "Double Ipa") {
    $type = "Double India Pale Ale";
}
if ($type == "Imperial Ipa") {
    $type = "Imperial India Pale Ale";
}
if ($type == "Black Ipa") {
    $type = "Black India Pale Ale";
}
if ($type == "American Ipa") {
    $type = "American India Pale Ale";
}
if ($type == "West Coast Ipa") {
    $type = "West Coast India Pale Ale";
}
if ($type == "Session Ipa") {
    $type = "Session India Pale Ale";
}
if ($type == "Nwpa") {
    $type = "West Coast Pale Ale";
}
if ($type == "Black Rye Ipa") {
    $type = "Black Rye India Pale Ale";
}
if ($type == "Extra Ipa") {
    $type = "Extra India Pale Ale";
}
if ($type == "Apa") {
    $type = "American Pale Ale";
}
if ($type == "Belgian Ipa") {
    $type = "Belgian IPA";
}
if ($type == "Ne Ipa") {
    $type = "New England IPA";
}
if ($type == "Fresh Hop Ipa") {
    $type = "Fresh Hop IPA";
}
if ($type == "American Double Ipa") {
    $type = "American Double IPA";
}
if ($type == 'American Double / Imperial Ipa') {
    $type = "American Double / Imperial IPA";
}
if ($type == 'Double Dry Hopped Ipa') {
    $type = 'Double Dry-Hopped IPA';
}
if ($type == 'Hazy Ipa') {
    $type = 'Hazy IPA';
}

if ($_GET['state'] != "") {
    $state = "AND breweries.brewery_state = '" . $_GET['state'] . "'";
    $stateCopy = " from " . $_GET['state'];
}
else if ($_GET['from'] != "") {
    $state = "AND beerreel.state = '" . $_GET['from'] . "'";
    $stateCopy = " Enjoyed in " . $_GET['from'];
}
else{
    $state = '';
    $stateCopy = '';
}

$title = "Best " . $type . "s" . $stateCopy;

if ($_GET['state'] != "") {
    $pData = mysql_query("SELECT beers.type,beerreel.picName,breweries.brewery_state,beerreel.rating FROM beers LEFT JOIN beerreel ON beerreel.beer = beers.id LEFT JOIN breweries ON breweries.name = beers.maker WHERE beers.type LIKE '%$t%' AND beerreel.picName != '' AND beerreel.rating > 3 $state ORDER BY beerreel.id DESC");
    $picData = mysql_fetch_object($pData);

    $cData = mysql_query("SELECT beers.*,COUNT(beerreel.beer) AS c,breweries.brewery_state FROM beers LEFT JOIN beerreel ON beerreel.beer = beers.id LEFT JOIN breweries ON breweries.name = beers.maker WHERE beers.type LIKE '%$t%' AND beerreel.rating != 0 $state");

    if ($_GET['order'] == 'highest') {
        $data = mysql_query("SELECT beers.*,COUNT(beerreel.beer) AS c,SUM(beerreel.rating) AS r,SUM(beerreel.rating)/(5*COUNT(beerreel.beer)) AS t,(SUM(beerreel.rating)/(5*COUNT(beerreel.beer)))*COUNT(beerreel.beer) AS o, breweries.brewery_state FROM beers LEFT JOIN beerreel ON beerreel.beer = beers.id LEFT JOIN breweries ON breweries.name = beers.maker WHERE beers.type LIKE '%$t%' AND beerreel.rating != 0 $state GROUP BY beers.id ORDER BY t DESC, c DESC, o DESC, beers.id DESC LIMIT 100");
    } else {
        $data = mysql_query("SELECT beers.*,COUNT(beerreel.beer) AS c,SUM(beerreel.rating) AS r,(SUM(beerreel.rating)/(5*COUNT(beerreel.beer)))*COUNT(beerreel.beer) AS o,breweries.brewery_state FROM beers LEFT JOIN beerreel ON beerreel.beer = beers.id LEFT JOIN breweries ON breweries.name = beers.maker WHERE beers.type LIKE '%$t%' AND beerreel.rating != 0 $state GROUP BY beers.id ORDER BY o DESC, beers.id DESC, beers.id DESC LIMIT 100");
    }
}
else {
    $pData = mysql_query("SELECT beers.type,beerreel.picName,beerreel.state,beerreel.rating FROM beers LEFT JOIN beerreel ON beerreel.beer = beers.id WHERE beers.type LIKE '%$t%' AND beerreel.picName != '' AND beerreel.rating > 3 $state ORDER BY beerreel.id DESC");
    $picData = mysql_fetch_object($pData);

    $cData = mysql_query("SELECT beers.*,COUNT(beerreel.beer) AS c,beerreel.state FROM beers LEFT JOIN beerreel ON beerreel.beer = beers.id WHERE beers.type LIKE '%$t%' AND beerreel.rating != 0 $state");

    if ($_GET['order'] == 'highest') {
        $data = mysql_query("SELECT beers.*,COUNT(beerreel.beer) AS c,SUM(beerreel.rating) AS r,SUM(beerreel.rating)/(5*COUNT(beerreel.beer)) AS t,(SUM(beerreel.rating)/(5*COUNT(beerreel.beer)))*COUNT(beerreel.beer) AS o, beerreel.state FROM beers LEFT JOIN beerreel ON beerreel.beer = beers.id WHERE beers.type LIKE '%$t%' AND beerreel.rating != 0 $state GROUP BY beers.id ORDER BY t DESC,c DESC, o DESC, beers.id DESC LIMIT 100");
    } else {
        $data = mysql_query("SELECT beers.*,COUNT(beerreel.beer) AS c,SUM(beerreel.rating) AS r,(SUM(beerreel.rating)/(5*COUNT(beerreel.beer)))*COUNT(beerreel.beer) AS o,beerreel.state FROM beers LEFT JOIN beerreel ON beerreel.beer = beers.id WHERE beers.type LIKE '%$t%' AND beerreel.rating != 0 $state GROUP BY beers.id ORDER BY o DESC, beers.id DESC LIMIT 100");
    }
}

$ogImage = "https://brewzeit.com/images/thumbs_lg/" . $picData->picName;

$reviewCount = mysql_fetch_object($cData);

$meta = "Here are the Best " . $type . "s".$stateCopy." based on " . number_format($reviewCount->c) . " reviews on Brewzeit. Download the Brewzeit app and start rating beers.";
$smallCard = true;

include('../includes/header.php'); ?>

  
<div id="main_content">

<div id="left-content">


<style>
.top-slot { width: 290px; height: 50px; margin-bottom: 0px; margin-top: 5px }
@media(min-width: 350px) { .top-slot { width: 330px; height: 60px;} }
@media(min-width: 375px) { .top-slot { width: 350px; height: 50px; } }
@media(min-width: 414px) { .top-slot { width: 390px; height: 60px; } }
@media(min-width: 500px) { .top-slot { width: 468px; height: 60px; } }
@media(min-width: 800px) { .top-slot { width: 100%; height: 90px; margin-bottom: 10px; margin-top:20px  } }
</style>

<div style="margin: 0 auto 20px; text-align: center">
<script async src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
<!-- Header -->
<ins class="adsbygoogle top-slot"
     style="display:inline-block;"
     data-ad-client="ca-pub-0775488133273258"
     data-ad-slot="6518155379"></ins>
<script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script>
</div>

<h1>Best <? echo $type . "s" . $stateCopy ?></h1>

    <p style="margin: 25px 0">Here are the Best <? echo $type . "s" .$stateCopy ?> based on <? echo number_format($reviewCount->c) ?> reviews on Brewzeit.  View all other styles <a href="/style/">here</a>. Download the Brewzeit app and start rating beers. Order by <a href="?order=highest&state=<? echo $_GET['state'] ?>">highest rating</a> or <a href="?order=average&state=<? echo $_GET['state'] ?>">average rating</a>.</p>
<ul id="best-list">

<?
while($post = mysql_fetch_array($data))
{	 
	$type = $post['type'];
	$beerID = $post['id'];
	$picData = mysql_query("SELECT picName FROM beerreel WHERE beer = '$beerID' AND picName != '' ORDER BY id DESC");
	$postData = mysql_fetch_array($picData);
	
	$nameURL = $post['maker'] . " " . $post['name'];
	$a = array(""," ");
	$a2 = array("'",".");
	$replacedURL = strtolower(str_replace($a, "-",$nameURL));
	$replacedURL = str_replace($a2,"",$replacedURL);	
	
	if($postData['picName'] == ''){
		$beerPicName = "bottle.jpg";
	}
	else{
		$beerPicName = $postData['picName'];
	}
	
	
	echo "<li class='clear' style='min-height:65px'><a href='/brew/" . $post['id'] . "/" . $replacedURL . "/'><img src='/images/thumbs_lg/" . $beerPicName . "' class='circle-pic' style='width:60px; height:60px'/>" . $post['maker']  ." ". $post['name'] ."</a>";
	if($post['c'] == 1){
		$reviews = "review";
	}
	else{
		$reviews = "reviews";
	}
	
	$ratingPercent = ($post[r]/$post[c])/5*100; ?>
	
	
    <?
	echo "<div style='font-weight:normal; padding-top:5px; font-size:14px'>Rating of ". round($post['r']/$post['c'],2). " <span style='font-size:13px'>(" . number_format($post['c']) . " " . $reviews .")</span></div>";
	echo "</li>";
}

//$b = new beer();
//echo $b->beerMaker();
//echo $b->beerName();
//echo beer::beerName();
?>
 </ul>
 <? if ($_GET['order'] == 'highest') { ?>
 <p style="margin: 25px 0">Formula used: (sum of ratings/total possible rating points)*number of ratings.</p>
<? } ?>
 </div>   
<div id="right-sidebar">
	
<div class="sidebar-list">
<h3><a href="/blog/">Latest Posts</a></h3>
<ul>
	<? echo getLatestPosts(); ?>
</ul>
</div>

<? if(isset($_SESSION['city'] )){ ?>
<a id="places"></a>
<div class="sidebar-list">
<h3>Trending Brews in <? echo $_SESSION['city'] ?></h3>
<ul>
	<? echo topTrendingCity($_SESSION['city'],$_SESSION['state']); ?>
</ul>
</div>


<div class="sidebar-list">
<h3>Trending Places in <? echo $_SESSION['city'] ?></h3>
<ul>
	<? echo topTrendingPlaces($_SESSION['city'],$_SESSION['state']); ?>
</ul>
<p style="text-align:center"><a style="font-size:13px; font-weight:normal; color:#060; text-decoration:underline" href="/data/brewzeiters.php">Find Local Brewzeiters</a></p>
</div>


<div style="clear:both; margin:15px 0 25px; padding-top:15px; text-align: center">

<script async src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
<!-- Hobo Mid Ad -->
<ins class="adsbygoogle"
     style="display:inline-block;width:300px;height:250px"
     data-ad-client="ca-pub-0775488133273258"
     data-ad-slot="6947385775"></ins>
<script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script>
</div>


<? } else{ ?>

<div class="sidebar-list">
<h3>Trending Brews <span style="font-size:11px; font-weight:normal"><a href="<? $_SERVER['PHP_SELF'] ?>?location=update">Update location</a></span>
</h3>
<ul>
	<? echo topTrending(); ?>
</ul>
</div>

<div style="clear:both; margin:15px 0 25px; padding-top:15px; text-align: center">

<script async src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
<!-- Hobo Mid Ad -->
<ins class="adsbygoogle"
     style="display:inline-block;width:300px;height:250px"
     data-ad-client="ca-pub-0775488133273258"
     data-ad-slot="6947385775"></ins>
<script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script>
</div>


<? } ?>

<div class="sidebar-list">
<h3>Top 10 Brews of All-Time</h3>
<ul>
	<? echo topTen(); ?>
</ul>
</div>

<div style="clear:both; margin:15px 0 25px; padding-top:15px; text-align: center">
<script async src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
<!-- 300 X 250 Right Column -->
<ins class="adsbygoogle" style="width:300px; height:250px" data-ad-client="ca-pub-0775488133273258"
     data-ad-slot="8648026208"></ins>
<script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script>
</div>


</div>

  
</div><!-- end of content -->
<? include('../includes/footer.php'); ?>