Electronic Food Ordering System for Restaurants

aniseedsplashSoftware and s/w Development

Aug 15, 2012 (4 years and 10 months ago)

349 views

Electronic Food Ordering
System for Restaurants

Supervisor

: Dr. Mak Man Wai

Co
-
examiner

: Dr. YOU Jane

Student Name

: Kwok Ka Yan

Student Id

: 04038574d

Date


: 4
th

May,2007

Comp 401 Final Year Project

Overview


Problem statement and objective


System Requirement


Deployment Diagram of the system


Database Design


Use case of the system


Implementation


Summary of achievement


Demo


Q & A


Overview

Overview


High Operation Cost (Time, material and human resource)


High error rate (Human manipulation)


In
-
convenience


All Problems need to be solved by human (Make
judgement)


Untraceable mistake


Problem

statement

Overview


Decrease the operation cost (Time, material and
human resource)


Decrease error rate (Standardize input format,
orders being read before send)


Reduce human manipulation (Enhance stock alert
and price checking)


Able to handle synchronization (Prevent stock
dispute)


Can trace the mistake


Objective

Overview

System

Requirement

Operating System :

Palm OS Garnet v5.4

Database Server :

Access 2003

Web Server :

Tomcat 5.0

Runtime Environment :

IBM’s WebSphere Everyplace Micro
Environment (CLDC 1.1/MIDP 2.0)

Development tool :

NetBeans, Dreamweaver

Web Browser :

Internet Explorer xp

Overview

Deployment

Diagram

DataBase Server
Application Server
WorkStation
Web Browser
PDA
Access DataBase
J
2
ME
JSP
Servlet
Overview

Database

Design

Overview

Use Case

Overview

Implementation

of Send Order

in PDA

Steps:

1. Check if that table or take away number has bill yet.

2. For every ordered dish, Check if the ordered quantity >= stock

3.
Acquire the lock

4.
Add order in database

5. Reduce the stock of main ingredients.

6. Release the lock

7. Return response message to mobile terminal.



Synchronization :

Reason: Prevent concurrent.

it is possible that if two requests are made to

send order at the same time but the stock are

only capable for one.

Overview

Steps:

1.
Allocate a timer

2.
Allocate a task

3.
Schedule the timer to execute the
task in specific time and repeat
every specific time interval .


Task includes:

1. Stock of ingredient checking

2. Stock of dish estimating

3. Ticker creating

4. Ticker appending

Implementation

of Low Stock

Alert in PDA

Feature:

Background process that runs automatically and repeats after
specific time interval to estimate the stock of dish.

Overview

Summary of

achievement

Interface (PDA):

1. Representative login page (Logo is added)

2. More user friendly and easy to communicate


(All inputs are standardize. Waiter only has to click button instead of write down.
Human error and time used can be reduced)

3. Every Function are reduced to one screen only.


(Operation time is shorten)

Interface (Web Browser):

1. More interesting interface.

2. More necessary Data is shown


(e.g. Order time, the staff Id of the waiter who make order, so that mistake can
be trace back)

Overview

Summary of

achievement

New Feature (PDA) :

1. Free food function

2. Take away order. (Orders can be stay or take out)

3. Change password (More Security)

4. Synchronization in server when send order.

5. Order based on the stock of ingredient.


(the system is redesigned so that it estimates the stock of the dish with the stock
of ingredient and reduce the stock of ingredients after ordered)

6. Low Stock Alert (Background Process)

7. Check the stock of ingredient (People on floor can know the condition in kitchen)

New Feature (Web Browser):

1. New section in Ingredient.

2. Check Ready in Kitchen


(Human error made in changing ordered food status)

3. Change password (More secure)

4. Low Stock Alert (Background Process)

Overview

Demo

Overview

Q & A

Comparison of

the old and

new system

Function

Take Order

Existing
Feature

-

Handle basic order taking

Approach:

Waiter/waitress orders the dish directly. The stock of
the dish is reduced with the ordered quantity.

New/ Add on
feature

-

Handle take away order
-

Free Food

-

Standardized remark list
-

Make order with 1 screen

-

Estimate the stock of dish

-

Get the stock of main ingredient every time the waiter
select the category of the dish

Approach:

The stock of the dish is estimated by the stock of its
main ingredient. When the order is sent, the system
would estimate if the stock is enough and then reduce
the stock of main ingredient of that dish.

Comparison of

the old and

new system

Function :

Send order

Existing Feature :

-

Prompt confirm message once the order is sent

New/ Add on
feature :

-

Synchronization in server.

-

Stock of main ingredient reduction.

-

Prompt message when ordered can not be made
due to lack of stock.

Approach:

Different dish may have the same main ingredient.

Function :

Check and void order

Existing Feature :

-

Handle basic check and void order

New/ Add on
feature :

-

Check by take away number

-

View the ordering staff
-

Calculate the total

Advantage :

-

Waiter can report the total without traveling.

-

Mistake can be trace back.

Comparison of

the old and

new system

Function :

Check order (Fix terminal)

Existing Feature :

-

View ordered dish with quantity and remark

New/ Add on
feature :

-

View ordered dish with Table number/ Take away
number, quantity, Remark and order time

Advantage :

Mistake can be trace back.

Function :

Close Bill
(Fix terminal)

Existing Feature :

-

Check by table number
-

View bill

New/ Add on
feature :

-

Check by take away number
-

Discount given

-

View ordered information

-

Add payment method

Advantage :

Cashier can fast count the taking.

Comparison of

the old and

new system

New Function :

Check Main ingredient

Feature :

-

Check the stock of main ingredient by group

Approach :

Allow manager to monitor the stock of main
ingredient. The estimated stock of dish can be
view in the take order function.

New Function :

Change password

Feature :

-

Double entry of new password

-

Field checking

Approach:

Allow administrator to change the password of all
users to control the access right. Wireless
handhold user can change their password in the
PDA.

Comparison of

the old and

new system

New Function :

Low stock alert

Feature :

-

Background process running to keep estimating
the stock of dish.

-

Report the low stock dish information in the form
of ticker on the top of screen.

Approach :

Use an active way to give information.

New Function :

Check Ready

Feature :

-

Check the ordered dish which has been changed
the state to “Ready” with the ready time.

Approach:

Consider the human mistake that might be made
in changing the status of dish.

Comparison of

the old and

new system

New Function :

Edit user in system

Feature :


-

Add user
-

Remove user


-

Change password


-

View user information


(Staff Name, Department, Staff ID, Username)

Approach :


Allow administrator to control the access right and

renew password for all user.

New Function :

Edit dish in system

Feature :


-

Delete Dish
-

Add Dish


-

View dish information (Category, Dish Id, Dish


Name, Price and Main Integrant)

Approach:

Dish information can be review and updated.

Comparison of

the old and

new system

New Function :

Edit stock of main ingredient

Feature :


-

View main ingredient information (Category,


Ingredient ID, Name, Unit and Stock)

-

Update main ingredient information (Name, unit,


stock)

Approach :

The stock of the dish is estimated by the stock of

main ingredient. Therefore, the stock of dish and

main ingredient can be updated with this function.