To develop Cashless Canteen System

General information for the business: Education, International School in Johor Bahru, Malaysia
Database management system (DBMS): MySQL
Description of requirements/functionality: The system objective is to allow students to buy food using their existing student ID card which already have bar-code printed on it. There will be 3 groups of users, which are "Administrator", "Admin Office Staff" and "Canteen" staffs. Software needs to use MYSQL, running on Apache server. Please read my uploaded material for details. Administrator can manage (create, edit, search, delete) Administrator, can manage Admin Office Staff, can manage Canteen staffs. When a student go to canteen, the canteen staff scan the student card to retrieve balance, minus off the purchase amount and save relevant details. Card credit can top up by Admin Office Staff. Need to generate daily transaction report. Admin Office Staff can search for a student's monthly transaction records. Also need reminder to students when credit is low.

Hardware requirement:
1. Bar-code scanner use in capturing students' ID

Descriptions:
1. There are 3 groups of users, Administrator, Admin Staffs, and Canteen Staffs.

Administrator roles:
I. Manage Administrators (Create, Search, Edit, Delete)
II. Manage Admin Staffs (Create, Search, Edit, Delete)
III. Manage Canteen Staffs (Create, Search, Edit, Delete)
IV. Manage Students (Create, Search, Edit, Delete)
V. Manage Canteen Food (Create, Search, Edit, Delete)
VI. Create Daily Top-up Transactions Report - including which Admin Office Staff, amount and receipt number.
VII. Create Daily Canteen Sales Transaction Report - including which canteen staff, sold items and sold to which student, and amount.

Admin Staff roles:
I. Check Cards’ Balance
II. Top-up card amount
III. Check Purchased History of students - including date, time, item purchased, sold by who, sold amount, and total.
IV. List out students with low credit amount - Including students' names, ID and balanced amount.

Canteen Staff roles:
I. Sell Fixed price food - this is to speed up the transaction, canteen staffs just scan the student's ID card and a fixed pre-selected amount will be deducted, can be $5 or $6 for example.
II. Sell Variable prices drinks and snacks - amount is variable, slower transaction, can be $2, $2.5 or $3.
III. Show message warning students with low credit amount - when a student's card is less than $10, show warning message on screen to remind students.
Extra notes: Need to have a Barcode scanner to capture Student ID from existing student cards.

Software use are Apache, MYSQL, PHP, CSS, Javascripts, JQuery, HTML.