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