<?
include("../config.inc.php");
include("../menu1.inc.php");
include("../sidebar.inc.php");

$sidecatlink = "none";
$sidestorelink = "yes";

$_SESSION['ref'] = "$sslbase/store/";
$_SESSION['pageref'] = "store";
$oops = rtrim($_SESSION['oops']);

$total = "0";
$billname = rtrim($billname);
$shipname = rtrim($shipname);


if(isset($_COOKIE['ID_my_site'])) {

	include("../auth.inc.php");

}

else {

	$guest = 1;

}


//this checks for guest

if ($guest == 1) {
	

	if ($billname == '') {
	
	$username = '';
	
	}
	

}

else {

	if ($pass != $realpass AND $pass != $realtoken) {

		header("Location: ../guest/");

	}
	
	else {

		$passstatus = "okay";
	
	}

}
	
//END checks for guest


//otherwise they are shown the admin area
		
		if ($passstatus == "okay" OR $guest == 1) {

			$cart = $_COOKIE['cart'];

			$cart = unserialize($cart);

			if (isset($_POST['add']))  {
			
				$item = $_POST['item'];
				$quantity = $_POST['quantity'];		
				
				$quanquery = mysqli_query($conn,"SELECT quan FROM store_items WHERE id = '$item'");
				
				while ($rowq = $quanquery->fetch_assoc()) {
				
					$quantest = $rowq['quan'];
				
				}	
				

				if (is_array($cart)) {

					$cartnum = count($cart);
					
				}
				
				else {
					
					$cartnum = 0;
					
				}

				$added = 0;

				if ($cartnum > 0) {

					$cartkeys = array_keys($cart);
					
					sort($cartkeys);

					$j = 0;

					while ($j < $cartnum) {

						$key = $cartkeys[$j];
						
						$typequery = mysqli_query($conn,"SELECT type FROM store_items WHERE id = $item");
						
						while ($rowt = $typequery->fetch_assoc()) {
						
							$type = $rowt['type'];
						
						}
						
						if ($key == $item AND $type != 'pot') {

						$oldquan = $cart[$key];
						$newquan = $oldquan + $quantity;
						
						if ($newquan > $quantest) {
						
							$newquan = $quantest;
						
						}
						
						if ($quantest > 0) {
						
							$cart[$key] = "$newquan";
							$added = 1;
						
						}
						
						else {
						
							unset($cart[$key]);
						
						}
						
							}

						$j++;

					}


					if ($added != 1) {

						$cart[$item] = $quantity;

					}


				}

				else {
				
					if ($quantest > 0) {

						if ($quantity > $quantest) {
							
								$quantity = $quantest;
							
						}
	
						$cart[$item] = $quantity;
						
					}
				}


				$crt = serialize($cart);
				$hour = time() + 60*60*24*10;
				setcookie(cart, $crt, $hour, '/');
//if (isset($_POST['add'])) {
			 }


		if (isset($_POST['submit'])) {

				if (is_array($cart)) {

					$cartnum = count($cart);
				}


				else {
					
					$cartnum = 0;
				
				}

				
				if ($cartnum > 0) {

					$cartkeys = array_keys($cart);
					sort($cartkeys);
					$j = 0;

					while ($j < $cartnum) {

							$key = $cartkeys[$j];
							$delete = $_POST['item_delete_'.$key];

						if ($delete == 1) {

							unset($cart[$key]);
						
						}

						else {

							$newquan = $_POST['item_quantity_'.$key];
							
							
							$quanquery2 = mysqli_query($conn,"SELECT quan FROM store_items WHERE id = '$key'");
				
							while ($rowq2 = $quanquery2->fetch_assoc()) {
							
								$quantest = $rowq2['quan'];
							
							}

							if ($newquan == 0 OR $quantest < 1) {
							
								unset($cart[$key]);
							
							}
							
							else {
							
								if ($newquan > $quantest) {
								
									$newquan = $quantest;
								
								}
							
								
								$cart[$key] = $newquan;
							
							}

						}

					$j++;
					
					}
				
				
				$crt = serialize($cart);
				$hour = time() + 60*60*24*10;
				setcookie(cart, $crt, $hour, '/');


//if ($cartnum > 0) {
				}
				
//if (isset($_POST['submit'])) {
		
		}

if (is_array($cart)) {
$cartnum = count($cart);
}
else {
$cartnum = 0;
}

if ($cartnum > 0) {

$cartkeys = array_keys($cart);
sort($cartkeys);
$j = 0;

while ($j < $cartnum) {
$key = $cartkeys[$j];

$orderquery = mysqli_query($conn,"SELECT price,ship FROM store_items WHERE id ='$key'");

	while ($rowo = $orderquery->fetch_assoc()) {
	
		$price = $rowo['price'];
		$ship = $rowo['ship'];
		
	}

if ($ship == "Y") {
	
	$shipquery = mysqli_query($conn,"SELECT price FROM store_shipping WHERE id = '1'");
	
	while ($rows = $shipquery->fetch_assoc()) {
	
		$newshipprice = $rows['price'];
	
	}
	
	$shipprice = $shipprice + $newshipprice;

}


  $sub = ($cart[$key] * $price);
  $total = $total + $sub;

  $shipprice = number_format($shipprice,2,'.',''); 
  $total = number_format($total,2,'.','');

$j++;
}

}


setcookie(total, $total, $hour, '/');
setcookie(shipprice, $shipprice, $hour, '/');

$total = '';
$sub = '';
$shipprice = '';


?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta charset="utf-8">
<meta name="Description" CONTENT="Crocker Farm store, shopping cart.">
<title>Shopping Cart - Crocker Farm Stoneware Auction</title>
<meta name="viewport" content="width=device-width, initial-scale=1.0">

<style>

<? echo "$gen_all_style"; ?>

<? echo "$info_all_style"; ?>

#contacthead div {
	display: block;
	margin: 1vw 0 0 2vw;
    padding: 0;
    font-size: 10vw;
	line-height: normal;
    text-align: center;
    color: #596153;
    text-align: left;
}

#contacthead div#links {
	display: none;
}

.cartpic, .cartbreakdown, .addupd {
    display: inline-block;
    vertical-align: middle;
}

#sub {
    font-weight: bold;
}

input, select, option {
    -webkit-box-sizing: border-box;
    -moz-box-sizing: border-box;
    box-sizing: border-box;  
}

input {
	vertical-align: middle;
    width: 12vw;
    height: 14vw;
    margin: 0 2vw 8vw;
    font-size: 2em;
    font-size: 8vw;
    font-family: 'Andada',serif;
}

input[type="submit"] {
	width: 60vw;
	margin: 1vw 0 0 0;
}

input[type="submit"].smaller {
	width: 35vw;
	font-size: 5vw;
}

input[type="submit"].button {
	width: auto;
	-webkit-appearance: none;
    background: aliceblue;
	border-radius: 20px;
}

.addupd input {
    margin: 0;
}

@media screen and (min-width:1000px){

<? echo "$gen_lg_style"; ?>

<? echo "$info_lg_style"; ?>

#contacthead {
    margin: 2vw 0 0;
}

#contacthead div {
	display: inline-block;
	font-size: 4vw;
	margin: 0;
}

#contacthead div#links {
	display: inline-block;
	font-size: 2vw;
	margin: 0 0 0 .75vw;
}

#contacthead div#links a {
	margin: 0 0 0 .75vw;
}

.cartpic, .cartbreakdown {
    margin: 0 2vw 0 0;
}

#sub {
    margin: 1vw;
    font-size: 2vw;
}

input {
    width: 2vw;
	height: 3vw;
	margin: 0 10px;
    font-size: .8em;
    font-size: 1.35vw;
}

input[type="submit"] {
	height: 3vw;
	width: 9vw;
}

input[type="submit"].smaller {
	width: 8vw;
	font-size: 6vw;
}

input[type="submit"].button {
	font-size: 2vw;
    padding: 0 1vw;
}

#contact {
	width: 79%;
}

<?
echo "$menu_style";
?>	

}
</style>

<?
include('../head.inc.php');
?>

</head>

<? echo "$design_banner"; ?>


<div id="contactdetail">

	<div id="contact">

	<div id="contacthead">

    <div>Cart</div>

	</div>

	<div id="contactinfo">

		<div id="container">

<?


if ($cartnum > 0) {

    echo "<div id=\"checkout\"><form action=\"$sslbase/members/checkout/\" enctype=\"multipart/form-data\" method=\"post\" name=\"update_form\"><input type=\"hidden\" name=\"username\" value=\"$username\"> 
    <input type=\"hidden\" name=\"gocart\" value=\"1\">
    <input type=\"submit\" name=\"submit\" value=\"Proceed to Checkout\" class=\"button\"></form></div>";

}


if ($guest != 1) {

  $userquery = mysqli_query($conn,"SELECT firstname,lastname,city,state FROM users WHERE username = '$username'");
  
  while ($rowu = $userquery->fetch_assoc()) {
  
      $firstname = $rowu['firstname'];
      $lastname = $rowu['lastname'];
      $city = $rowu['city'];
      $state = $rowu['state'];
  
  }
  
  
  //echo "<p>$firstname $lastname<br>$city, $state</p><hr>";

}

if ($cartnum > 0) {

  
  if ($shipping == 1) {
  
  $shipprice = number_format($shipprice,2,'.','');

  }

  else {
  
      $shipprice = "0.00";
  
  }

  $grandtotal = $total + $shipprice;


  echo "</p>";


  if ($state == "MD") {
  
      $tax = $total * .06;
      $tax = number_format($tax,2,'.','');
      //echo "<hr class=\"breakdown\"><p class=\"breakdown\">6% MD Sales Tax: $$tax</p>";
      $grandtotal = $grandtotal + $tax;
  
  }

  if ($state == "PA") {
  
    $tax = $total * .06;
    $tax = number_format($tax,2,'.','');
    //echo "<hr class=\"breakdown\"><p class=\"breakdown\">6% PA Sales Tax: $$tax</p>";
    $grandtotal = $grandtotal + $tax;

}

  $grandtotal = number_format($grandtotal,2,'.','');
  
  //THIS makes $guest = 0 just to reset everything if we come back to this page as a logged-in person; not positive that this is needed--haven't tested it
  
  $guest = 0;

}


echo "<form action=\"\" enctype=\"multipart/form-data\" method=\"post\" name=\"update_form\">";

if ($oops != '') {

	echo "<div class=\"oops2\"><img src=\"/images/oops2.png\" /></div>";
	
	echo "<span>";
	
	$oops = unserialize($oops);
	$oopsnum = count($oops);
	$oi = 0;
	
	if ($oopsnum == 1) {
	
		echo "One";
	
	}
	
	else {
	
		echo "Some";
	
	}
	
	echo " of your items ";
	
	if ($oopsnum == 1) {
	
		echo "is";
		
	}
	
	else {
	
		echo "are";
	
	}
	
	echo " now Out of Stock:</span><br /><br />";
		
		for ($oi = 0;$oi < $oopsnum;$oi++){
		
			$oopsid = $oops[$oi];
		
			$oopstitlequery = mysqli_query($conn,"SELECT title FROM store_items WHERE id = $oopsid");
			
			while ($rowoops = $oopstitlequery->fetch_assoc()) {
		
				$oopstitle = $rowoops['title'];
			
			}
		
			echo "<span class=\"blue2\">&#8226; $oopstitle</span>";
			
			if ($oi < $oopsnum - 1) {
			
			echo "<br />";
			
			}
		
		}
	
	echo "<br /><br /><span class=\"bold ital\">How Did This Happen?</span> If an item is low in stock or one-of-a-kind, someone else purchased the last one between the time you added it to your cart and when you actually tried to pay for it.";
	
	echo "<div class=\"clearfloat\"></div><br /><br />";
	
	unset($_SESSION['oops']);


}


if (is_array($cart)) {

	$cartnum = count($cart);

}

else {

	$cartnum = 0;

}


if ($cartnum > 0) {

    $cartkeys = array_keys($cart);
    sort($cartkeys);
    $j = 0;

	while ($j < $cartnum) {

		$key = $cartkeys[$j];

		$orderquery2 = mysqli_query($conn,"SELECT id,title,price,ship,type FROM store_items WHERE id ='$key'");

		while ($rowo2 = $orderquery2->fetch_assoc()) {

			$id = $rowo2['id'];
			$title = $rowo2['title'];
			$price = $rowo2['price'];
			$ship = $rowo2['ship'];
			$type = $rowo2['type'];

			if ($ship == "Y") {

				$shipping = 1;
				$shipquery = mysqli_query($conn,"SELECT price FROM store_shipping WHERE id = '1'");

                while ($rowship = $shipquery->fetch_assoc()) {
                
                    $newshipprice = $rowship['price'];
                
                }

				$shipprice = $shipprice + $newshipprice;

			}
        
	
			$photoquery = mysqli_query($conn,"SELECT photo_tag,file_num FROM store_photos WHERE item_id='$key' ORDER BY rank, file_num LIMIT 1");

			while ($rowph = $photoquery->fetch_assoc()) {
	
				$phototag = $rowph['photo_tag'];
				$photonum = $rowph['file_num'];

			}
	
			$filename = "$phototag.$photonum";

            $size = GetImageSize( "../store/images/tb_".$filename );
                        
            $width = ceil($size[0] / 2);
            $width = $width.'px';
                
            $height = ceil($size[1] / 2);
            $height = $height.'px';
	 
			echo "<div class=\"cart ";
		  
			if ($catrow % 2 == 1) {
		  
			  echo "catrowwhite\">";
		  
			}
		  
			else {
		  
			  echo "catrowcream\">";
		  
			}
	  
			echo "<div class=\"cartpic\"><img src=\"/store/images/tb_$filename\" style=\"height:$height;width:$width\"></div>";
			echo "<div class=\"cartbreakdown\">";

            echo "<div>$title</div>";

			echo "<div class=\"bold\">$$price</div>";
	  
			$sub = ($cart[$key] * $price);
			$total = $total + $sub;  
	  
            echo "<div>";
		  
			echo "<div class=\"addupd\"><input type=\"text\" size=\"1\" name=\"item_quantity_{$key}\" value=\"$cart[$key]\"></div>";
			  
		  		  
			if ($cartnum - $j == 1) {
		  
				  echo "<div class=\"addupd\"><input type=\"submit\" name=\"submit\" value=\"Update Cart\" class=\"smaller\"></form></div>";
		  
			}

            echo "</div>";
		  
			echo "</div></div>";
		  
			if ($cartnum - $j > 1) {
		  
				 echo "<hr>";
		  
			}
  
			$count++;
			$catrow++;
  
 		 }
		
  
    	$j++;
	
    }
 	
    $totalformatted = number_format($total,2,'.','');

    echo "<div id=\"sub\">Subtotal: $$totalformatted</div>";

//ends if cartnum > 0  -> I THINK!?!?!?
} 


else {

echo "<h3 class=\"addupd\">There Are No Items In Your Cart.</h3>";

}


echo "<p><a href='../../store/'><< Back to Store</a></p>";
  
?>


</div>


<?


//IF there's items in cart, it shows the green bar on right side

//if ($cartnum > 0) {


echo "</div>";

echo "</div>";

echo "<div style='clear:both'></div>";

echo "</div>";

echo "</div>";


echo "$design_footer</div></div>";


//if pass == info or username == guest ????
}

else

//if the cookie does not exist, they are taken to the login screen
{
header("Location: ../guest/");
}


?>