As I am trying to build a shopping app, I have the following tables in my database to work with orders.
1. Orders - keeps all orders with corresponding information like date, status, number etc.
2. Order_Products - product IDs related to its corresponding order with Order_Id field.
So, if I have 1 order with 3 products in it, then I will have 1 record in Orders and 3 records in Order_Products with the same Order_Id field value.
I wanted to figure out how I could build an Admin panel to show a list of Orders, and after I click the specific order I would be redirected to a "Order View" page where it would show both the Order fields (date, status, number) and the list of its corresponding orders.
I would then have some buttons to change the status of the order and also I would be able to change products list for this order (add or delete products and change their amount).
Let me know if this ispossible to setup and how I would approach this configuration, please?