Project is 2 parts.
1. Add Order Delivery Type. (Pickup , Delivery … Other (Table Driven)
2. Reservation Module
Based on the Order delivery type. And store Set up. Customer needs the ability to pick a delivery date and time.
Below is basic Outline …
1. Administration will be done by Admin
1. Each Store will Have Days open, Start and stop Time, order type Interval size and Interval Amount And Delay time.
eg
Store Type Day Open Close Interval Amount Delay
*ALL Dlvr Mon 7 am 8 pm 1hr 6 1 hr
*ALL DLVR Mon 7 am 8 pm 1hr 6 1 hr
*ALL DLVR Tue 7 am 8 Pm 1hr 6 1 hr
*ALL DLVR Wed 7 am 8 Pm 1hr 6 1 hr
*ALL DLVR Thu 7 am 8 Pm 1hr 6 1 hr
*ALL DLVR Fri 7 am 8 Pm 1hr 6 1 hr
*ALL DLVR Sun 7 am 8 Pm 1hr 6 1 hr
*ALL DLVR Sat 10am 5 pm 1hr 3 2 hr
Storea DLVR Mon 7 am 8 pm 1hr 6 1 hr
Storea DLVR Tue 7 am 8 Pm 1hr 6 1 hr
Storea DLVR Wed 7 am 8 Pm 1hr 6 1 hr
Storea DLVR Thu 7 am 8 Pm 1hr 6 1 hr
Storea DLVR Fri 7 am 8 Pm 1hr 6 1 hr
Storea DLVR Sun 7 am 8 Pm 1hr 6 1 hr
Storea DLVR Sat 10am 5 pm 1hr 6 1 hr
Storea PKUP Mon 9 am 8 pm 1hr 66 .25 hr
Storea PKUP Tue 9 am 8 Pm 1hr 66 .25 hr
Storea PKUP Wed 9 am 8 Pm 1hr 66 .25 hr
Storea PKUP Thu 9 am 8 Pm 1hr 66 .25 hr
Storea PKUP Fri 9 am 8 Pm 1hr 66 .25 hr
Storea PKUP Sun 9 am 8 Pm 1hr 66 .25 hr
Storea PKUP Sat 10am 5 pm 1hr 36 .25 hr
Example
On Monday Store is open From 7am to 8:pm for delivery for pickup the store opens at 9am. And every hour It is open it can Allocate or prepare 6 Orders to be delivered in that hour for pickup it can prepare 66 orders . If order is at 7:30 the First time available to me is 9:00 am since there is a hour delay for preparation
2. Admin would be able to set start up and end date & time of the store. Store will be visible at the start up time and be closed at end time.
3. You will also be able to define order delivery interval time for the order placed on the store. This time will remain fixed for selected store. Order delivery time will change each time when one interval is over. For example, you have set interval of 2 hrs. So if the store gets started at 8 AM, it will show delivery time up to 10 AM. Then after 10 AM it will show 12:00 noon etc. You will also be able to define number of orders to be delivered or can be processed in one interval on first come first server basis. Once exceed that time period is blocked. They can only reserve to future time.
Information will be displayed on orders on columns for store administrators, they would be able to change dates and times on each order if needed. Order Look up would contain a columns to be sorted by date time and order type. So store can process first come first done and request
Customers will have the ability to pick Order type and beginning and modify when checking out. and picking date and Time for order delivery times based on what is open.
This must be an extention since I wish to continue upgrading software.