diff options
| -rw-r--r-- | lib/promo.php | 13 | ||||
| -rw-r--r-- | public/admin-promo.php | 98 | ||||
| -rw-r--r-- | public/admin.css | 6 | ||||
| -rw-r--r-- | public/index.php | 12 |
4 files changed, 117 insertions, 12 deletions
diff --git a/lib/promo.php b/lib/promo.php new file mode 100644 index 0000000..ae200fa --- /dev/null +++ b/lib/promo.php @@ -0,0 +1,13 @@ +<?php + +function promobuff2str($price_buff, $count_buff) { + if ($count_buff == 1) return ((1-$price_buff)*100)."% korting"; + if ($count_buff <= 4) { + for ($i = $count_buff-1; $i > 0; $i--) + if (abs((($i/$count_buff)-$price_buff)/$price_buff) < 0.001) + return $i."+".($count_buff - $i)." gratis"; + } + return ((1-$price_buff)*100)."% korting per ".$count_buff."-pack"; +} + +?> diff --git a/public/admin-promo.php b/public/admin-promo.php new file mode 100644 index 0000000..83103e3 --- /dev/null +++ b/public/admin-promo.php @@ -0,0 +1,98 @@ +<!DOCTYPE html> +<?php require "../lib/login.php"; ?> +<?php if_privileged(PRIVILEGE_ADMIN, "/") ?> +<?php require "../lib/promo.php"; ?> +<?php do { + if ($_SERVER['REQUEST_METHOD'] !== 'POST') break; + if (!$_POST['type']) break; + + switch($_POST['type']) { + case "delete": { + $statement = $cursor->prepare("delete from promotion where id = ?"); + $statement->bind_param("i", $_POST['id']); + $statement->execute(); + break; + } + case "add": { + $statement = $cursor->prepare("insert into webs.promotion (`product`, `price_buff`, `count_buff`) values (?, ?, ?)"); + $statement->bind_param("idi", $_POST['product_id'], $_POST['price_buff'], $_POST['count_buff']); + $statement->execute(); + break; + } + } + + $promo_id = $_POST['id']; + $new_status = $_POST['status']; + if (!$promo_id) break; + if (!$new_status) break; + + $statement = $cursor->prepare("update `promo` set status = ? where id = ?"); + $statement->bind_param("ii", $new_status, $promo_id); + $statement->execute(); +} while (false); ?> +<?php +function promo_template($promo) { + $promo_str = promobuff2str($promo->price_buff, $promo->count_buff); + echo <<<"EOF" + <form method="post"> + <input type="hidden" name="type" value="delete"> + <input type="hidden" name="id" value="$promo->id"> + <tr> + <td>$promo->product_id</td> + <td>$promo->name</td> + <td>$promo->count_buff</td> + <td>$promo->price_buff</td> + <td>$promo_str</td> + <td> + <input type="submit" value="verwijderen"> + </td> + </tr> + </form> + EOF; +} +?> + +<html> +<head> + <?php include 'head.php' ?> + <title>aanbiedingen</title> + <link rel="stylesheet" href="admin.css"> +</head> +<body> + <?php include 'navbar.php' ?> + <div class="main limwidth"> + <h2>aanbieding toevoegen</h2> + <form action="/admin-promo.php" method="post"> + <input type="hidden" name="type" value="add"> + <label for="product_id">Product</label> + <select id="product_id" name="product_id"> + <?php + $res = $cursor->query("select id, name from webs.product"); + while ($c = $res->fetch_object()) echo "<option value='$c->id'>$c->name</option>"; + ?> + </select> + <label for="count_buff">Per aantal</label> + <input id="count_buff" name="count_buff" type="number" min=1 step=1> + <label for="price_buff">Vermenigvuldigingsfactor</label> + <input id="price_buff" name="price_buff" type="number" step="any"> + <input id="submit" type="submit" value="Toevoegen"> + </form> + <h2>huidige aanbiedingen</h2> + <table class="promo-table"> + <tr> + <th>product id</th> + <th>product naam</th> + <th>per aantal</th> + <th>ver­menig­vuldigings­factor</th> + <th>zichtbaar als</th> + <th>verwijderen</th> + </tr> + <?php + $res = $cursor->query("select promotion.id, product.id as product_id, product.name, count_buff, price_buff from promotion join product on product.id = promotion.product"); + while ($promo = $res->fetch_object()) promo_template($promo); + ?> + </table> + </div> + <?php include 'footer.php' ?> +</body> +</html> diff --git a/public/admin.css b/public/admin.css index bc1d821..8adeb79 100644 --- a/public/admin.css +++ b/public/admin.css @@ -34,9 +34,13 @@ table td { border: 2px solid var(--bg-alt); } +table td input { width: 100%; } + .order-table td:nth-child(1) { text-align: center; } .order-table td:nth-child(3) { text-align: right; } .order-table td:nth-child(4) { text-align: right; } .order-table td select, -.order-table td input { width: 100%; } +.promo-table td:nth-child(1) { text-align: center; } +.promo-table td:nth-child(3) { text-align: right; } +.promo-table td:nth-child(4) { text-align: right; } diff --git a/public/index.php b/public/index.php index fecf624..3540692 100644 --- a/public/index.php +++ b/public/index.php @@ -1,16 +1,6 @@ <!DOCTYPE html> <?php require "../lib/db.php"; ?> -<?php -function promobuff2str($price_buff, $count_buff) { - if ($count_buff == 1) return ((1-$price_buff)*100)."% korting"; - if ($count_buff <= 4) { - for ($i = $count_buff-1; $i > 0; $i--) - if (abs((($i/$count_buff)-$price_buff)/$price_buff) < 0.001) - return $i."+".($count_buff - $i)." gratis"; - } - return ((1-$price_buff)*100)."% korting per ".$count_buff."-pack"; -} -?> +<?php require "../lib/promo.php"; ?> <html> <head> <?php include 'head.php' ?> |