A small restaurant called “PaPa Burger” needs to hire programmer to build the system for the restaurant. They need to record all the transaction everyday. The Cash Receipt will be given to their customer with the following layout
************************************
“PaPa Burger Restaurant”
Inv No: _______________
Inv Date: ______________
2pcs Small Burger $4.90 … $9.80
2pcs Ice Lemon Tea $0.90 … $1.80
_____
T.O.T.A.L $11.60
Paid $12.00
Change $0.40
Thank you for your business
You’re special served by: HARTONO
**************************************
The Interface for cashier
The interface needs to made as simple as possible. Several users might be able to access the same menu, therefore a user authentication is required. When the user has successfully logged on, the user can input the order of customer, such as choose the food from drop down list, entering the quantity, and it will calculated automatically. The user will also enter the amount of money that the customer pay, then the change will also calculated automatically. The cash receipt will then appear on the screen – ready to be printed
The Interface for administrator
Administrator will have several menu, which is can input the type of the food, display the history of the transaction, create a report for the monthly or certain period transaction
Technical Requirements
The database will be MySQL and the software should be build using PHP with JavaScript/AJAX for optimization. Sample of the database structure will be as follows:
Cashier
IDCashier
CashierName
LastLogin
Remarks
Item
IDItem
ItemName
SellingPrice
Remarks
Transaction
InvNo
InvDate
Total
Paid
Change
IDCashier
Transaction_Detail
InvNo
IDItem
Qty
SubTotal