aboutsummaryrefslogtreecommitdiff
path: root/public/cart.php
blob: d4dfcc6e69f9f5f141b552d88f3c63fa8b74df1b (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
<!DOCTYPE html>
<?php require "../lib/db.php" ?>
<?php require "../lib/login.php" ?>
<?php if_logged_in(false, "/login.php", true) ?>
<?php do {
	if ($_SERVER['REQUEST_METHOD'] !== 'POST') break;
	if (!$_POST['type']) break;
	if (!$_POST['product_id']) break;

	switch($_POST['type']) {
		case "delete": {
			$statement = $cursor->prepare("delete from orderproduct where product = ? and `order` = cart(?)");
			$statement->bind_param("ii", $_POST['product_id'], $user_id);
			$statement->execute();
			break;
		}
		case "add": {
			// ik wou deze functie eigenlijk in een stored procedure doen maar het
			// schijnt dat de knappe koppen bij mysql het geen goed idee vonden om
			// gewoon 'return' toe te staan binnen de body van een stored
			// procedure???
			$statement = $cursor->prepare("select add_to_cart(?, ?)");
			$statement->bind_param("ii", $_POST['product_id'], $user_id);
			$statement->execute();
			$statement->get_result()/*->fetch_object()*/;
			break;
		}
	}
} while (false); ?>
<?php 
function item_template($item) {
	$image_path = $item->image ? "/img/product/$item->id-thumb.jpg" : "/img/placeholder.png";
	echo <<<"EOF"
	<div class="product">
		<img src="$image_path" alt="productafbeelding">
		<span class="name">$item->name</span>
		<label for="$item->id-count">hoeveelheid:</label>
		<input type="number" value="$item->count" min="1" max="20" id="$item->id-count" disabled>
		<button type="submit" value="$item->id" name="product_id">weghalen</button>
		<span class="price">$item->price</span>
	</div>
EOF;
}
?>
<html>
<head>
	<?php include 'head.php' ?>
	<title>mand</title>
	<link rel="stylesheet" href="cart.css">
</head>
<body>
	<?php include 'navbar.php' ?>
	<div class="main limwidth">
	<h2>dingen in de mand van <?php echo $username ?></h2>
		<?php do {
			global $username;
			$statement = $cursor->prepare("select product.id, product.name, product.price, product.image, orderproduct.count from orderproduct join product on product.id = orderproduct.product where `order` = cart(?)");
			$statement->bind_param("i", $user_id);
			if (!$statement->execute()) break;
			$res = $statement->get_result();
			if (!mysqli_num_rows($res)) {
				echo "mandje leeg";
				break;
			}
			echo <<<"EOF"
				<form class="products" method="post">
					<input type="hidden" name="type" value="delete">
			EOF;
			while ($product = $res->fetch_object()) item_template($product);
			echo <<<"EOF"
				</form>
				<form class="product-footer" method="post" action="/order-complete.php">
					<input type="submit" value="Bestellen" class="buttonstyle filled">
				</form>
			EOF;
		} while (false); ?>
	</div>
	<?php include 'footer.php' ?>
</body>
</html>