RFID Hospital Tracking and Management System

longtermsingularInternet και Εφαρμογές Web

4 Δεκ 2013 (πριν από 3 χρόνια και 4 μήνες)

56 εμφανίσεις

Done By:

Salem Husain Al Refaei


200312018

Mosab Khair



200235751

Abdalla Eisa Al Mazam


200308403

Mehdi Haidar




200235907

RFID Hospital Tracking and
Management System

Project Code:
EEM
1
-
9

Coordinator: Dr. Osama Abu
-
Zeid

Supervisor:
Dr. Qurban Memon

United Arab Emirates University

College of Engineering

Graduation Project Unit

Final Presentation

GPII

Presentation outline


Introduction.


What is the project About?


Last semester design specification.


Design Flow Chart.


Software Implementation.


MySQL

&
PHPMyAdmin
.


PHP
-
MySQL
.


WCMS
joomla
.


RFID gateway Software.


Visual Basic 8 software.


Hardware Implementation.


RFID Kit.


Door frame.


Final Prototype Design.


Results.


Conclusion.


Cost Estimation


Problems & Challenges.


Feasibility Study.


Conclusion.


Introduction


In the last semester, current hospital system has been discussed
in (Twam Hospital).


problems faced in the current system have been stated.


A proposed solution has been disposed in order to achieve these
objectives:


Increase the
Efficiency
,
Quality

and
Speed

by:



Facilitate the patient to reduce his content time in hospital.



Improve the hospital efficiency by reducing the patient’s transaction.



Minimize the operational cost of the hospital by deploying user friendly
technology.



Introduction


Technology picked was contactless smartcards.



We had RFID technology overview.



System specification of the following consideration have been
discussed:


Sensor
\
Tags Considerations.


Readers Considerations.


Management Consideration.


Patients Consideration.


Database Example.


Introduction


Flow Chart

Software Test & Design Implementation


PHP_MyAdmin
:


PHPMyAdmin

is

a

tool

written

in

PHP

intended

to

handle

the

administration

of

MySQL

over

the

WebCurrently

it

can

create

and

drop

databases,

create/drop/alter

tables,

delete/edit/add

fields,

execute

any

SQL

statement,

manage

keys

on

fields,

manage

privileges,

export

data

into

various

formats

and

is

available

in

55

languages
.


What is PHP?


PHP is a widely
-
used general
-
purpose scripting language that is
especially suited for Web development and can be embedded into
HTML


What is MySQL?


The MySQL Enterprise subscription is the only comprehensive
offering of production support, monitoring tools and MySQL
database software to deliver optimal performance, reliability,
security, and uptime. MySQL Enterprise includes:

1.
MySQL Enterprise Server

2.
MySQL Enterprise Monitor

3.
MySQL Production Support



Software Test & Design Implementation

Software Test & Design Implementation

Software Test & Design Implementation

VB Program

Software Test & Design Implementation

PHP coding


Input/output the data from our database to a web page.




Config code.


Open
/
Close

db codes.


Presenting data

code.


Entering data
code.

Software Test & Design Implementation

Alien RFID Gateway

Software Test & Design Implementation

Alien RFID Gateway

Software Test & Design Implementation

Alien RFID Gateway

Software Test & Design Implementation

Alien RFID Gateway

Software Test & Design Implementation

PHP Software Pages Outlines


Pages Needed:


Physician Pages.


This page will be dedicated and visible to the physician only.



Nurses Pages.


This page will be dedicated and visible to the nurses only.



Pharmacist Pages.


This page will be dedicated and visible to the pharmacist only.



Receptionist Pages.


This page will be dedicated and visible to the receptionist only.



Administrator Pages.


The administrator is the one who can manage every thing.


Software Test & Design Implementation

Physician pages

First Page

Second Page

Today's Appointment


< 1 2 3 4 (5) > 22


Nov


2008, 10:35am



N

Name

IS

HERE?

Time

Done?

1

Mosab

Khair

Not here

8:00 am

Yes/No

2

Mehdy

Haidar

HERE

8:30am

DONE

3

Abdallah

Al
Mazm

HERE

9:00am

Yes/No

File Search

Sear by:

ID

Name

Phone Number:

Search

Patient’s ID : 228221


Name: Salem Al Refaei


Age: 23


More Info…

Description:


< 1 2 3 4 (5) > 22


Nov


2008, 10:35am

……….

Submit

Welcome Dr. Thomas

Needs Appointment?


Period Example: 3 weeks

Send

Medication:


< 1 2 3 4 (5) > 22


Nov


2008, 10:35am

……….

Submit

Pharmacist Pages

First Page

Second Page

Medical Description for Today:


< 1 2 3 4 (5) > 22


Nov


2008, 10:35am



N

Name

IS

HERE?

Medical

Done?

1

Mosab

Khair

Not here

Click here

Yes/No

2

Mehdy

Haidar

HERE

Click here

DONE

3

Abdallah

Al
Mazm

HERE

Click here

Yes/No

File Search

Sear by:

ID

Name

Phone Number:

Search

Patient’s ID :
228221


Name: Salem Al Refaei


Age:
23


More Info…

Physician Medical Description:


<
1 2 3 4
(
5
) >
22


Nov


2008
,
10
:
35
am



Physician name.

……….

Welcome Mr. Thomas

Notes:


< 1 2 3 4 (5) > 22


Nov


2008, 10:35am

……….

Submit

Nurses pages

First Page

Second Page

Today's Appointment


< 1 2 3 4 (5) > 22


Nov


2008, 10:35am



N

Name

IS

HERE?

Time

Done?

1

Mosab

Khair

Not here

8:00 am

Yes/No

2

Mehdy

Haidar

HERE

8:30am

DONE

3

Abdallah

Al
Mazm

HERE

9:00am

Yes/No

File Search

Sear by:

ID

Name

Phone Number:

Search

Patient’s ID : 228221


Name: Salem Al Refaei


Age: 23


More Info…

Description:


< 1 2 3 4 (5) > 22


Nov


2008, 10:35am

……….

Submit

Welcome Nurse Mehdy

Physician Treating: Dr. Thomas

Receptionist Pages

First Page

Today's Appointment


< 1 2 3 4 (5) > 22


Nov


2008, 10:35am



N

Name

IS

HERE?

Time

Done?

1

Mosab

Khair

Not here

8:00 am

Yes/No

2

Mehdy

Haidar

HERE

8:30am

DONE

3

Abdallah

Al
Mazm

HERE

9:00am

Yes/No

File Search

Sear by:

ID

Name

Phone Number:

Search

Welcome Mr. Abdallah

To the Appointment System

Who is Available


< 1 2 3 4 (5) > 22


Nov


2008, 10:35am



N

Name

1

Mosab

Khair

2

Mehdy

Haidar

3

Abdallah

Al
Mazm

Patients Need appointments


< 1 2 3 4 (5) > 22


Nov


2008, 10:35am



N

Name

Period

Done?

1

Mosab

Khair

3 weeks

Yes/No

2

Mehdy

Haidar

6 days

DONE

3

Abdallah

Al
Mazm

1

month

Yes/No

Receptionist Pages

Second Page

Patient’s ID :
228221


Name: Salem Al Refaei


Age:
23


More Info…

Appointments:

< 1 2 3 4 (5) >

The Last Need Appointment?




22


Nov


2008, 10:35am

Period : 3 weeks

Physician: Dr. Thomas

Fast New Appointment:

Submit

N

Date

Time

Done?

1

10
-
11
-
2008

9:30am

Done

2

21
-
11
-
2008

3:45pm

Missed

3

28
-
11
-
2008

11:00am

After 3 days.


Date:

Appointment System:

Date

Physician

N

Name

Time

1

Ali

8:00am

2

Abdallah

8:15am

3

Ahmed

8:30am

4

Khalid

8:45am

5

Add

9:00am

6

Add

9:15am

7

Add

9:30am

8

Add

9:45am

9

Add

10:00am

10

Add

10:15am

11

Add

10:30am

12

Add

10:45am

13

Add

11:00am

14

Add

11:15am

Hardware Implementation

Hardware Implementation

Hardware Implementation

Hardware Software Integration & Results

Budget Estimation and Equipments

Components

Specification

Unit Price in $

# Units

Total Price in DHS

Alien ALR 8800
developer Kit

A Reader + 2 Antennas +
Sample Tags + Ethernet Cable
+ Serial Cable + Power Supply
+ CD Developers Kit + Alien
RFID Bag

3323$

1

12,480

Door Frame

Metallic Door Frame

-----

1

350

Total

12,850 (DHS)

Conclusion


Problems and challenges:


Finding a sponsor for our project wasn’t that easy since our project
was going to cost about 13000 Dhs in order to get our equipments.



Connecting the RFID kit was not an easy part but at the end it was
connected and started reading the tags.



Defining the direction of the patient as in programming view wasn’t
easy also. To do such thing perfectly we need better antenna
designed specifically for that case.


Problems & Challenges



It was very hard to find a UHF RFID smart card supplier in the
Middle East.



Designing a final Hospital WCMS that interacts with this sort of
a solution needs a lot of time and considerations. Plus it isn’t in
our specialty major.



Budget considerations caused a challenge because we have to get
the required budget to meet our project’s goals.


Conclusion


The objectives of this phase of the project were met.




A lot of new experiences gained with other software and
databases.



To finalize this project, a direction detector method should
be studied.



This prototype may turn to be a useful and user friendly tool
for tracking patients and managing operational environment
of the hospital in a developing country, like UAE.


Target Market:

Our target market is the government’s hospitals and also it can be
applied to the big private hospitals that they need improve their
system. But first of all, we will try design a prototype suitable for
the case of
Twam

Hospital.


Feasibility study

Projected Supply:


Considering the case of a hospital, and assuming the availability of
the other equipments needed such as computers networks and
server, the only extra device that will be considered is the RFID kit.



Unfortunately, there is no company in UAE sells and fixes any RFID
device. Or also supply the other needs. All of them are agencies for
other international company.



That’s why to get or receive any equipment needed. We have to
wait for minimum 3 weeks.



Which means we have to consider 1 month to wait for hardware.

Competitions:



In the world there is only one company which provide such a
solution for such a problem. This company is SONITOR
technologies.



There is no information available about trying to apply such a
solution in the near future.



No competition is available for such a project in the UAE.




Organizational Issue:


Organizational Structure:




The prototype needs only our group (4 people).




The whole project to be applied will need a fully
structured team.





Technological Issues:

Technology needs:


Hardware:

(1) PC. Available.

(2) Reader.

(3) Antenna.

(4) Tags.

(5) Door Frame.


Software:






Fig1: Project Prototype

(5) PHP My Admin.

(6) Visual Basic.

(7)
Joomla
.

(8)My SQL.

(9) Internet. Available.

(10)Wireless Network. Available
.








Fig2: components


Cost:

Total

Price (In

DHS
)

Unit Price (US
dollar)

Specification

Components

12,480

3323 $

Alien
8800
EPC Multiprotocol RFID
Fixed Reader (ALR
-
9800)

RFID Reader +
Antennas + Tags

350

-----

Door Frame

12,850 (DHS)

Total

There is no cost for software because all of them are free wares open
source.


To apply this project in the hospital there will be
19 readers

which will
cost: 237,130 Dhs.




There will be other costs such as labors salary.


New other Network Equipments.


IT Technicians.