<?php
	include 'top.php';
	
	$Home = $Services = $Gallery = $About = $Contact = $Reviews = 0;
	
	$ServerName = "localhost";
	$ServerUserName = "root";
	$ServerPassword = "root";
	
	$conDataBase = new mysqli($ServerName, $ServerUserName, $ServerPassword);
	if ($conDataBase->connect_error) {
		die("Connection Failed: " . $conDataBase->connect_error);
	}
	
	$tmp = "Home";
	$sql = "SELECT * from brentswelding.stats where page='".$tmp."';";
	$result = mysqli_query($conDataBase, $sql);
	$row = mysqli_fetch_array($result, MYSQLI_ASSOC);
	$Home = mysqli_num_rows($result);
	
	$tmp = "Services";
	$sql = "SELECT * from brentswelding.stats where page='".$tmp."';";
	$result = mysqli_query($conDataBase, $sql);
	$row = mysqli_fetch_array($result, MYSQLI_ASSOC);
	$Services = mysqli_num_rows($result);
	
	$tmp = "Gallery";
	$sql = "SELECT * from brentswelding.stats where page='".$tmp."';";
	$result = mysqli_query($conDataBase, $sql);
	$row = mysqli_fetch_array($result, MYSQLI_ASSOC);
	$Gallery = mysqli_num_rows($result);
	
	$tmp = "About";
	$sql = "SELECT * from brentswelding.stats where page='".$tmp."';";
	$result = mysqli_query($conDataBase, $sql);
	$row = mysqli_fetch_array($result, MYSQLI_ASSOC);
	$About = mysqli_num_rows($result);
	
	$tmp = "ContactUs";
	$sql = "SELECT * from brentswelding.stats where page='".$tmp."';";
	$result = mysqli_query($conDataBase, $sql);
	$row = mysqli_fetch_array($result, MYSQLI_ASSOC);
	$Contact = mysqli_num_rows($result);
	
	$tmp = "Reviews";
	$sql = "SELECT * from brentswelding.stats where page='".$tmp."';";
	$result = mysqli_query($conDataBase, $sql);
	$row = mysqli_fetch_array($result, MYSQLI_ASSOC);
	$Reviews = mysqli_num_rows($result);
	
	$conDataBase->close();
	
	$OverAllPercent = $Home + $Services + $Gallery + $About + $Contact + $Reviews;
	
	$tmp2 = 0;
	$Diff = $OverAllPercent - $Home;
	$tmp2 = $Diff / $OverAllPercent;
	$Home = $tmp2 * 100;
	
	$tmp2 = 0;
	$Diff = $OverAllPercent - $Services;
	$tmp2 = $Diff / $OverAllPercent;
	$Services = $tmp2 * 100;
	
	$tmp2 = 0;
	$Diff = $OverAllPercent - $Gallery;
	$tmp2 = $Diff / $OverAllPercent;
	$Gallery = $tmp2 * 100;
	
	$tmp2 = 0;
	$Diff = $OverAllPercent - $About;
	$tmp2 = $Diff / $OverAllPercent;
	$About = $tmp2 * 100;
	
	$tmp2 = 0;
	$Diff = $OverAllPercent - $Contact;
	$tmp2 = $Diff / $OverAllPercent;
	$Contact = $tmp2 * 100;
	
	$tmp2 = 0;
	$Diff = $OverAllPercent - $Reviews;
	$tmp2 = $Diff / $OverAllPercent;
	$Reviews = $tmp2 * 100;
?>
<!DOCTYPE html>
<html>
	<head>
    	<link rel="stylesheet" type="text/css" href="body.css">
        <link rel="stylesheet" type="text/css" href="AdminSideBar.css">
        <style>
			div.Container {width: 600px; height: 400px; margin: 0px auto; background-color: rgba(0,0,0,0.4); border: 5px solid white; overflow: auto;}
			div.BarsContainer {float: left; width: 16.3%; height: 99.2%; background-color: red; border: 1px solid white;}
			div.Bars {width: 100%; background-color: black;}
			
			table, td {border: 1px solid white; border-collapse: collapse; color: white;}
		</style>
    </head>
    <body class="background">
    	<div class="sidebar">
            <div class="infoContainer"><a href="AccountManager.php">Account Manager</a></div>
            <div class="infoContainer"><a href="APhotoManager.php">Photos</a></div>
            <div class="infoContainer"><a href="MarketStats.php">Market Stats</a></div>
            <div class="infoContainer"><a href="ALogOut.php">LogOut</a></div>
        </div>
        <div style="float: left; width: 75%; border: 1px solid grey; background-color: black; line-height: 150%; text-align: center;">
        	<div class="Container">
            	<div class="BarsContainer">
                	<div class="Bars" style="height: <?php echo($Home . "%");?>;">
                    </div>
                </div>
                <div class="BarsContainer">
                	<div class="Bars" style="height: <?php echo($Services . "%");?>;">
                    </div>
                </div>
                <div class="BarsContainer">
                	<div class="Bars" style="height: <?php echo($Gallery . "%");?>;">
                    </div>
                </div>
                <div class="BarsContainer">
                	<div class="Bars" style="height: <?php echo($About . "%");?>;">
                    </div>
                </div>
                <div class="BarsContainer">
                	<div class="Bars" style="height: <?php echo($Contact . "%");?>;">
                    </div>
                </div>
                <div class="BarsContainer">
                	<div class="Bars" style="height: <?php echo($Reviews . "%");?>;">
                    </div>
                </div>
            </div>
        </div>
    </body>
</html>