From 05d4f801fa8a519e257993cfa5bf1d72cdb7646f Mon Sep 17 00:00:00 2001 From: lonkaars Date: Sun, 21 May 2023 17:23:54 +0200 Subject: admin order editing page added --- public/admin-order.php | 76 ++++++++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 76 insertions(+) create mode 100644 public/admin-order.php (limited to 'public/admin-order.php') diff --git a/public/admin-order.php b/public/admin-order.php new file mode 100644 index 0000000..debde66 --- /dev/null +++ b/public/admin-order.php @@ -0,0 +1,76 @@ + + + +prepare("update `order` set status = ? where id = ?"); + $statement->bind_param("ii", $new_status, $order_id); + $statement->execute(); +} while (false); ?> + + + + $order->id + $order->user_name + $order->product_count + + + + + + + + + EOF; +} +?> + + + + + orders + + + + +
+

bestellingen

+

hier kun je bestellingen zien en de status aanpassen. wijzigingen kunnen doorgevoegd worden door op de 'bijwerken'-knop te drukken na het aanpassen van de status. maar één bestellingen kan aangepast worden per update!!

+ + + + + + + + + query("select `order`.id as id, sum(orderproduct.count) as product_count, user.name as user_name, `order`.status from orderproduct join `order` on `order`.id = orderproduct.`order` join user on user.id = `order`.user where status > 1 group by orderproduct.`order` order by status asc"); + while ($order = $res->fetch_object()) order_template($order); + ?> +
IDbestelleraantal productenstatusupdate
+
+ + + -- cgit v1.2.3