What I want you to create is a flash widget that tracks the order status.
This widget will be placed in the home page of the website.
Based on the customer_id that will be retrieved from the cookie of the user, we will be able to have the order_id and based on the order_id we will be able to find the status of the order inside the MySQL DB.
When the widget loads in the webpage it will check at the MySQL DB of the store if there is any order “pending” for the specific and unique customer_id of the user.
As the order progresses the flash widget bar will gradually change its status.
""PLACE ORDER"" -> REVIEWING ORDER -> PREPERATION
After the order is placed as an order (pending) has been spotted in the DB for the customer_id of the user, then the first step will be finished and continue to the next step.
||ORDER PLACED|| -> ""REVIEWING ORDER"" -> PREPERATION
After that the widget will check the database every 60 sec to see if the status of the order (accepted or rejected) has changed. If it did change then the bar continues to the next step.
||ORDER PLACED|| -> ||ORDER ACCEPTED|| -> ""PREPERATION""
After the second step, the widget will continue to check the DB every minute for a new status (order completed) and then it will show it at the flash widget accordingly.
||ORDER PLACED|| -> ORDER ACCEPTED|| -> ||ORDER SENT||
After the widget has gone to its final step the widget will stop querying the DB for a status change of the order.
Finally, after the order has gone through all the statuses and it is fully loaded, then a button will appear, that will say “Order received?”. The user of the widget will click on this button and then a “customer review” will appear. It will be a five start rating system. This rating will have 2 parameters the first five start rating will be for “Flavour” and the second for “Delivery Time”. These data will be stored to the MySQL DB where the statuses of the orders also exist. After the user has pressed send review, then the widget will go again at the first state, before an order was made.
I should be able to translate every word of the widget in my language (Greek). So a language file with all the words and phrases in the widget should be made and then there I will make the translations of the words and phrases.
The current status will not blink and the next status will blink and when the status changes in the flash bar it will play a sound.
Also it will have a “Cancel Order” button. After pressing this it will just show a notification to call at the store’s telephone number.
At the top of the widget it will show the current store status. If it closed or open right now, or if it has a technical problem and it is closed. It will also show the schedule of the store in the week. The hours that it is open. Also it will show the name, the address and the telephone number of the store. Also it will show the order_id of the order and the last orders in tabs. The date created, the name of the customer, the address. Again all these info will be got form the database fields in the MySQL DB.