- This work is the management and execution of back end database for the RoTF ordering and serving system.
- The website framework is based on 'Flask' and Database Management System is 'MySql'.
- There are three tables in a single database-
1.Ordered - contains the columns
* the entries are old and I am lazy to update them ;)
* order_no is the unique key and must be kept unique while entering new data for order.
* Order Name and ID can be selected with the table in 'over-coded' form.html which appears at home page : form.html needs update
2.Kitchen -the columns are
* this database is displayed at the kitchen and the chef can select items which are prep
3.Scheduled - the columns are
* When the virtual env is created the first page that appears is '/' which is form.html. Users can enter their order here by giving a unique order no.(which ideally should be maintained internally and kept unique.).
* After entering the order, we are redirected to same page again and can order again.
other pages are-
/ordered -this page displays the entire ordered table which contains all the orders
/kitchen - this page displays the kitchen table which contains all the pending orders that are to be made including the OrderTime. This can be displayed in the kitchen are.
/delete - this page is accessible to the chef. It contains the kitchen table and a order no. entry form. The order prepared and ready to be served is entered and is deleted form the kitchen table. The page is redirected to itself after the entry. form2.html is used here.
/scheduled - this page displays the scheduled table which contains the WaitingTime. waiting time for a dish is the time it is left unserved after it is prepared. The priority order of serving is decided on basis of the waiting time.
The priority information can further be used by the networking team to command the RoTF to carry out the respective orders in their priority order.
SIDE NOTE-
- The database needs to be created on the host computer and database details can be modified at the top of code.
- For better functioning a free online database can be used for the RoTF .