Tuck-shop Online
Users Experience
Data / SQL
Devices
Functionality
Robust example pages. Adobe XD
Uses Bootstrap, Adaptable to Phone, I-pad, laptop, etc...
Basic concept of website (Limited Pages)
Convener Views
Admin Views
Student Views
User Signup View
Special area that requires a key on the primary database. School admin will use this account. Login via main page but will have an access key given by the database.
Menu Management View
User / Convener Login View
Easy Access to Log-In Webpage. Saves Users information once Signed in. Convener Login will not save.
Convener View Will Not have a signup page. They will be created by Admin
User must Sign in with School Email and School Password.
Automatically Saves information, and autofill username.
System automatically checks if school email and hashed school password match the chosen person via tass.
User Menu Page
Live Menu changes, Student orders chosen meal here.
There is also a maximum amount of food a person can order. Orders are capped at 1 but can be edited in User History Page to add more.
Website adds studentnumber to database and stores it along with the ordered food name.
When Student purchases food they can scan card or give their name to a Convener. The Database tracks their studentnumber and shows if they have purchased food. Convener receives this information and sees if they have purchased the correct food or not.
User History Page
Track past orders here, and find current wallet balance + daily expenses limits
Can Edit ordered meals here. There will be a certain time limit before edits are turned off.
Delayed Order pickup must be notified to staff, must notify conveners before half time of Lunch or start of morning tea depending on original purchase time.
non-delayed ordered food not picked up at half bell will be taken to the public pickup area. Delayed Ordered Food must also be taken before final bell of Lunch (max).
Webpage shows when, what, how many and how much each particular is that is being sold that day.
Conveners can see upcoming orders and purchases in more detail if they choose.
Meta Data and Statistics Page
Live Webpage that updates everyday that changes to past purchases and past events.
Main Convener Page
Tuckshop: Profit, $amount due to school, etc...
An add convener function + A backup / System Maintenance function.
Tuck-shop statistics: See how good the sales are
Customer
Security
Prevent Routs
Website Security
Secure Log-in's + purchase buttons
click to edit
https://
Sha-1, Clean-Up, Stripslashes, trim, htmlspecialchars
Purchase Student Safety
FoodWaste
Track Users who actively troll the system.
Create an eat later button for late pickup.
Limit Certain amounts of orders from a single child. (4 different items per break. Only 5 of the same order of food)
Track Sales and Wastage / Metadata and statistics.
Items
orderlist
Worker
Final Order
order_id
item_id
orderitems_id
order_id
user_id
worker_id
status
dateorder
user_id
username
password
email
scode
phone_number
grade
behaviour
worker_id
worker_name
worker_email
role
item_id
item_name
item_description
item_price
item_image