<?
session_start();


/* Change path info depending on your file locations */
require_once '../includes/mobile-detect.php';
$detect = new Mobile_Detect;
if ((isset($_COOKIE['app']) and ($_COOKIE['app']) == 'true') || $detect->isMobile()) {
    //header('Location: /brewzeit/www/index.html#/app/brew/' . $_GET['id']);
}


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

$beer = $_GET['id'];
$beerID = $_GET['id'];
$data = mysql_query("SELECT * FROM beers WHERE id  = '$beer'");


$picData = mysql_query("SELECT picName,id,LENGTH(cheers) - LENGTH(REPLACE(cheers, ',', '')) AS popular FROM beerreel WHERE beer = '$beer' AND picName != '' ORDER BY id DESC LIMIT 1");
if (mysql_num_rows($picData) > 0) {
    $picture = mysql_fetch_object($picData);
    $picName = $picture->picName;
    $picName = "url(https://brewzeit.com/images/thumbs_lg/" . $picName . "); background: -moz-linear-gradient(top, rgba(0, 0, 0, 0) 0%, rgba(0, 0, 0, 0) 15%, rgba(0, 0, 0, 1) 100%), url(https://brewzeit.com/images/thumbs_lg/" . $picName . ") no-repeat;background: -webkit-gradient(linear, left top, left bottom, color-stop(0%, rgba(0, 0, 0, 0)), color-stop(15%, rgba(0, 0, 0, 0)), color-stop(100%, rgba(0, 0, 0, 1))), url(https://brewzeit.com/images/thumbs_lg/" . $picName . ") no-repeat; background: -webkit-linear-gradient(top, rgba(0, 0, 0, 0) 0%, rgba(0, 0, 0, 0) 15%, rgba(0, 0, 0, 1) 100%), url(https://brewzeit.com/images/thumbs_lg/" . $picName . ") no-repeat; background-position: center; background-size: 100% auto;";
} else {
    $picName = "#111";
}


$post = mysql_fetch_array($data);


$type = $post['type'];
$title = $post['maker'] . " " . $post['name'] . " (" . $type . ")";
$m = $post['maker'];
$n = $post['name'];
$nameURL = $post['maker'] . " " . $post['name'];
$a = array("", " ");
$a2 = array("'", ".", "&");
$replacedURL = strtolower(str_replace($a, "-", $nameURL));
$replacedURL = str_replace($a2, "", $replacedURL);

$canonical = "https://brewzeit.com/brew/" . $beerID . "/" . $replacedURL . "/";
$t = $post['maker'] . " " . $post['name'];


if (substr(strtolower($type), 0, 1) == 'a' || substr(strtolower($type), 0, 1) == 'e' || substr(strtolower($type), 0, 1) == 'i' || substr(strtolower($type), 0, 1) == 'o' || substr(strtolower($type), 0, 1) == 'u') {
    $a = "an";
} else {
    $a = "a";
}
$metaMaker = $post['name'] . " is " . $a . " " . $type . " by " . $post['maker'] . ". ";
if ($post['abv'] != '') {
    $metaABV = "It has an ABV of " . $post['abv'] . ". ";
} else {
    $metaABV = '';
}

$reviewData = mysql_query("SELECT SUM(rating),COUNT(rating) FROM beerreel WHERE beer  = '$beer' AND rating != '0'");
$conData = mysql_query("SELECT * FROM beerreel WHERE beer  = '$beer'");
$consumedRows = mysql_num_rows($conData);
if ($consumedRows == 1) {
    $metaConsumed = "It has been consumed 1 time.";
} else {
    $metaConsumed = "It has been consumed " . $consumedRows . " times.";
}

while ($reviews = mysql_fetch_array($reviewData)) {
    if ($reviews['COUNT(rating)'] > 0) {
        $rating = $reviews['SUM(rating)'] / $reviews['COUNT(rating)'];
        $rating = round($rating, 1);
        if ($reviews['COUNT(rating)'] == 1) {
            $metaRating = "It has a rating of " . $rating . " out of 5 with 1 review.";
        } else {
            $metaRating = "It has a rating of " . $rating . " out of 5 with " . $reviews['COUNT(rating)'] . " reviews.";
        }
    } else {
        $metaRating = '';
    }

}
if ($post['grains'] != '') {
    $metaMalt = " The malt bill consists of " . $post['grains'] . ". ";
}
if ($post['hops'] != '') {
    $metaMalt .= "The hops used are " . $post['hops'] . ". ";
}
if ($post['yeast'] != '') {
    $metaMalt .= "The yeast is " . $post['yeast'] . ". ";
}
$meta = $metaMaker . $metaABV . $metaRating . $metaMalt;
$type = $post['type'];

$nameURL = $post['maker'] . " " . $post['name'];
$a = array("", " ");
$a2 = array("'", ".", "&");
$replacedURL = strtolower(str_replace($a, "-", $nameURL));
$replacedURL = str_replace($a2, "", $replacedURL);

$ogUrl = "https://brewzeit.com/brew/" . $beerID . "/" . $replacedURL . "/";

if ($picture->picName != '') {
    $ogImage = "https://brewzeit.com/images/thumbs_lg/" . $picture->picName;
} else {
    $ogImage = "https://brewzeit.com/images/brewzeit-square.png";
}

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

<div id="main_content" itemscope itemtype="http://schema.org/Product">
    <? echo "<div id=\"profile-header\" style=\"background:" . $picName . "\"><h1 itemprop='name' class=\"center\">" . $post['maker'] . " " . $post['name'] . "</h1></div>"; ?>

    <div style="display:none" itemprop="description"><? echo $meta ?></div>


    <div id="left-content">
        <? $data = mysql_query("SELECT * FROM beers WHERE id  = '$beer'");
        while ($post = mysql_fetch_array($data))
        {
        $style = $post['type'];
        $style = strtolower($style);
        $style = str_replace("'", "", $style);
        $style = str_replace("/", "~", $style);
        $style = str_replace(" ", "-", $style);

        $m = $post['maker'];
        $data = mysql_query("SELECT id,name FROM breweries WHERE name = \"$m\" LIMIT 1");
        $b = mysql_fetch_object($data);

        $brewery = $b->maker;
        //$d = mysql_query("SELECT name,id FROM breweries WHERE name = \"$brewery\"");
        //if(mysql_num_rows($d) > 0){

        //}
        //else{
        //mysql_query("INSERT INTO breweries (name) VALUES (\"{$b->maker}\")");
        //}

        $makerN = strtolower($b->name);
        $makerN = str_replace("'", "", $makerN);
        $a = array(" ", ".");
        $makerN = str_replace($a, "-", $makerN);
        $makerURL = "/breweries/" . $b->id . "/" . $makerN . "/";
        ?>


        <div itemprop="aggregateRating" itemscope itemtype="http://schema.org/AggregateRating">
            <?
            echo "<div id='breadcrumbs' style='margin-bottom:10px'><a href='/feed/'>Feed</a> > <a href='/style/" . $style . "/'>" . $post['type'] . "</a> > <a href='$makerURL'>" . $post['maker'] . "</a></div>";


            $reviewData = mysql_query("SELECT SUM(rating),COUNT(rating) FROM beerreel WHERE beer  = '$beer' AND rating != '0'");
            while ($reviews = mysql_fetch_array($reviewData)) {
                //echo $reviews['SUM(rating)'];
                //echo $reviews['COUNT(rating)'];
                //echo $rating;
                if ($reviews['COUNT(rating)'] > 0) {
                    $rating = $reviews['SUM(rating)'] / $reviews['COUNT(rating)'];
                    $ratingPercent = ($reviews['SUM(rating)'] / $reviews['COUNT(rating)']) / 5 * 100;
                    ?>
                    <div class="star-rating-control-brew">
                        <div class="ratings-bg">
                            <div class="ratings-img" style="width:<? echo $ratingPercent ?>%"></div>
                        </div>
                        &nbsp;<?
                        if ($reviews['COUNT(rating)'] == '1') {
                            echo "<div style='padding-top:10px'><span itemprop='ratingValue'>" . round($rating, 2) . "</span> out of <span itemprop=\"bestRating\">5</span> - Based on <span itemprop='ratingCount'>" . $reviews['COUNT(rating)'] . "</span> review</div>";
                        } else if ($reviews['COUNT(rating)'] == '0') {
                            //echo "<div style='padding-top:10px'><span itemprop='ratingValue'>" . round($rating,1) . "</span> out of <span itemprop=\"bestRating\">5</span> - Based on <span itemprop='ratingCount'>" . $reviews['COUNT(rating)'] . "</span> review</div>";
                        } else {
                            echo "<div style='padding-top:10px'><span itemprop='ratingValue'>" . round($rating, 2) . "</span> out of <span itemprop=\"bestRating\">5</span> - Based on <span itemprop='ratingCount'>" . $reviews['COUNT(rating)'] . "</span> reviews</div>";
                        }

                        $reviewersCount = mysql_query("SELECT COUNT(author_id) FROM beerreel WHERE beer  = '$beer' AND rating != '0' GROUP BY author_id");
                        $reviewers = mysql_num_rows($reviewersCount);
                        //echo "<meta itemprop=\"count\" content=\"" . $reviewers . "\">";

                        ?>
                    </div>

                    <div style="clear:left"></div>
                    <?
                } else {
                    echo "<div style='padding-top:10px; display:none'><span itemprop='ratingValue'>0</span> out of <span itemprop=\"bestRating\">5</span><span itemprop=\"worstRating\">0</span> - Based on <span itemprop='ratingCount'>0</span> review</div>";

                }
                echo "</div>";
            }

            echo "<p>";
            if ($post['abv'] != '') {
                echo "<strong>ABV:</strong> " . $post['abv'] . "&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;";
            }
            if ($post['og'] != '') {
                echo "<p><strong>OG:</strong> " . $post['og'] . "&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;";
            }
            if ($post['ibu'] != '') {
                echo "<strong>IBU:</strong> " . $post['ibu'] . "&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;";
            }
            echo "<strong>Style:</strong> <a style='color:#555' href='/style/" . $style . "/'>" . $post['type'] . "</a></p>";
            if ($post['description'] != '') {
                echo "<p><strong>Description:</strong> " . $post['description'] . "</p>";
            }

            if ($post['yeast'] != '' || $post['hops'] != '' || $post['grains'] != '') {
                echo "<h4 style='padding-top:20px;'><strong>Ingredients:</strong></h4><p>";
                if ($post['grains'] != '') {
                    echo "<strong>Malts:</strong> " . $post['grains'] . "<br />";
                }
                if ($post['hops'] != '') {
                    echo "<strong>Hops:</strong> " . $post['hops'] . "<br />";
                }
                if ($post['yeast'] != '') {
                    echo "<strong>Yeast:</strong> " . $post['yeast'];
                }
                echo "</p>";
            }

            } ?>


            <p id="count" style='border-top:1px solid #ccc; padding-top:20px; margin-top:20px'>No one is drinking this
                beer right now.</p>

            <p><? echo getBrewTotal($beer); ?></p>

            <form method="post" action="/share.php">
                <input name="posting" value="true" type="hidden"/>
                <input name="beer" value="<? echo $beer ?>" type="hidden"/>
                <p>
                    <button type="submit" id="havingOne">Having One Now</button>
                </p>
            </form>

            <? echo getPics($beer); ?>


            <h2 style="padding-top:15px; clear:both;color:#333;font-size:17px; line-height: 22px"><strong><? echo $t ?>
                    Reviews</strong></h2>

            <ul id="latest" class="onecolumn">
                <?

                $data = mysql_query("SELECT * FROM beerreel WHERE beer = '$beer' AND hide != 'true' ORDER BY id DESC LIMIT 0,30");
                $numRows = mysql_num_rows($data);
                if ($numRows < 1) {
                    echo "<p>There are no ratings or comments yet for this brew.</p>";
                }
                while ($post = mysql_fetch_array($data)) {
                    $beerID = $post['beer'];
                    $date = $post['date'];
                    $city = $post['city'];
                    $state = $post['state'];
                    $place = explode(',', $post['place']);
                    $comment = $post['comment'];
                    $rating = $post['rating'];
                    $pic = $post['picName'];
                    $streamID = $post['id'];
                    $author = $post['author_id'];
                    $buddies = $post['buddies'];
                    $flavor = $post['flavor'];
                    $aroma = $post['aroma'];

                    $beerInfo = mysql_query("SELECT * FROM beers WHERE id = '$beerID'");
                    while ($beer = mysql_fetch_array($beerInfo)) {
                        echo "<li class='beerPage' data-review-id=\"" . $streamID . "\" itemprop=\"review\" itemscope=\"\" itemtype=\"http://schema.org/Review\" >";
                        echo "<meta itemprop=\"itemreviewed\" content=\"" . $beer['maker'] . " " . $beer['name'] . "\">";
                        if ($rating != 0) { ?>
                            <span itemprop="reviewRating" itemscope itemtype="http://schema.org/Rating">
              <meta itemprop="ratingValue" content="<? echo $rating ?>">
             <div style="margin-top: 8px">
            	<img src="/brewzeit/www/img/<? echo $rating ?>-star-lg.png"
                     style="height: auto; width: 100%; max-width: 100px">
            </div>
            </span>
                        <? }


                        if ($comment != '') {
                            echo "<div class='comment five-padding' itemprop=\"description\" lang=\"en\">\"" . $comment . "\"</div>";
                        }


                        echo "<div class='name five-padding'><a style='font-size:13px' href='/profile/" . $author . "/' itemprop='author' itemscope itemtype='http://schema.org/Person'><span itemprop='name'>" . $post['name'] . "</span></a>";
                        if ($buddies != '' && $buddies != ',,') {
                            echo withList($buddies);
                        }
                        $date = relative_date(strtotime($date));

                        if ($aroma != 0 && $flavor != 0) {
                            $d = " Aroma: " . $aroma . " out of 5 - Flavor: " . $flavor . " out of 5 - " . $date;
                        } else if ($aroma != 0) {
                            $d = " Aroma: " . $aroma . " out of 5 - " . $date;
                        } else if ($flavor != 0) {
                            $d = " Flavor: " . $flavor . " out of 5 - " . $date;
                        } else {
                            $d = $date;
                        }

                        echo " - " . $d;
                        if ($post['place'] != '') {

                            $placeName = $post['place'];
                            $placeData = mysql_query("SELECT * FROM brewzeit_places WHERE name = \"$placeName\"");
                            if (mysql_num_rows($placeData) > 0) {
                                while ($placed = mysql_fetch_array($placeData)) {
                                    echo " from <a style='font-size:13px; color:#666' href='/place/" . $placed['id'] . "/'>" . $place[0] . "</a> ";
                                }
                            } else {
                                echo " from " . $place[0] . " ";
                            }

                        }
                        if ($city != '') {

                            $cityUrl = str_replace(" ", "+", $city);
                            echo " near <a style='font-size:13px; color:#666' href='/places/" . $state . "/" . $cityUrl . "/'>" . $city . ", " . $state . "</a>";
                        }
                        echo "</div>";
                        echo "<div class='name five-padding' style='font-size:11px;'><a style='color:#060; text-decoration:underline' href='/stream/" . $streamID . "/'>View details</a></div></li>";
                    }
                }

                ?>
            </ul>


        </div>

        <script type="text/javascript" src="https://www.google.com/jsapi"></script>
        <script type="text/javascript">

            function getCurrentCount() {
                $.ajax({
                    url: '/includes/current-stat.php?b=<? echo $_GET['id'] ?>',
                    success: function (data) {
                        $("#count").html(data);
                        if (data == 0) {
                            $("#count").html('No one is drinking this beer right now.');
                        }
                        else if (data == 1) {
                            $("#count").html('1 person is drinking this beer right now.');
                        }
                        else if (data > 1) {
                            $("#count").html(data + ' people are drinking this beer right now.');
                        }
                        //setTimeout("getCurrentCount()", 30000);
                    }
                });
            }

            getCurrentCount();
        </script>


        <div id="right-sidebar">

            <div class="sidebar-list">
                <? echo getRelatedPosts($_GET['id'], $type, $m, $n); ?>
            </div>

            <div class="sidebar-list">
                <? echo getSimilarBrews($type, $_GET['id'], $t, $m); ?>
            </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">
                <? if (isset($_SESSION['city'])) {
                    echo brewFromPlaces($_SESSION['city'], $_SESSION['state'], $_GET['id'], $t);
                } else {
                    echo brewFromAllPlaces($_GET['id'], $t);
                }
                ?>
            </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 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 Lower -->
                <ins class="adsbygoogle" style="width:300px; height:250px" data-ad-client="ca-pub-0775488133273258"
                     data-ad-slot="6921599159"></ins>
                <script>
                    (adsbygoogle = window.adsbygoogle || []).push({});
                </script>
            </div>

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