Analysis, Design and Implementation of an Online Medical Care System Chapter 1 Overview of the Project 1.1 Introduction Internet is an extremely resourceful technology for any organization like hospital of all categories to use to provide several type of information to the patient or users and meet the various health related needs of individuals, in particular, by integrating services. At present, almost everything is starting to be ‘online’ and give the people a chance to do a number of necessary tasks via the Internet and thus save a lot of time. Online Medical Care service is one of those, which has become the demand of the present time and almost all the hospitals are adopting this service to cope up with the present market situation and to be a part of the competition of providing maximum user satisfaction. Also all data are permanently stored in the database and information can be handled efficiently. I have chosen to implement the Online Medical care System as my project. At this moment hospitals feel the need to have common structure of the software for convenience of their operation, providing information about hospital using internet and the software companies are working on this purpose. As a student my objective is to learn about the operation of the hospital and the features of the software which is needed for their operation. I want to learn how to develop database software specially using MySQL. My purpose is to develop a software for online medical care to gain experience so that I can work in database field in my future professional life. So that I have decided to develop the software Online Medical Care System as my project. I am a student of Computer Science and Information Technology and my purpose is to develop a software product for the real use of the hospital. From this project I want to gain knowledge about the functional modules of a hospital and their inter relationship. More over, I want to develop database software that is based on MySQL. The purpose of my project is to develop a software product that will automated all databases of a hospital and user can get information through internet. 1.2 The Objective of this Project Information is the driving force of the current world. It is impossible to think the proper operation of today’s life without current information. So, maintaining proper information securely and make them available from everywhere become a part of our life. The objective of this project is to develop a web interface for a hospital that will provide its users the essential online medical services. The software, which I develop, is efficient in preserving all information and manipulates them efficiently. I selected the following features to include in my project. 1) In my project all the information will be taken through forms, which are designed in user friendly way. 2) I will provide certain level of security through passwords, so no unauthorized persons can access the information. 3) User can get information about doctors available on particular day, necessary service information like blood, ambulance and so on. 4) The software provides the functionality to provide an appointment to doctor according to one’s need. 5) It also gives the opportunity to make a reservation for services. 6) My software will take time and date from computer automatically. As a result it decreases the redundancy of the data and save time and speed up the system.
7) User name and password of each user will be stored in database automatically. Which they can use farther incase of modifying database or canceling appointment. 8) In case of entering any invalid date users will given warning. 9) I shall also manage patient’s total bill for the services which they make use . 10) Users can find out the charge for a particular service also. 11) All the graphical interfaces are easy to handle. To gain a clearer picture of the typical Internet services available at medicals online medical care services is defined. The web site of the medical will have information about the hospital and it’s services and the procedures of being a registered person to access the registered page to make the use of online medical care services. 1.3 Overview of the Dissertation Chapter 1 “Overview of the Dissertation” describes the objective of the project and outline of the dissertation. Chapter 2 “Basic Medical Care System” describes the existing hospital system’s basic structure. Chapter 3 “Online Medical Care” deals with the present system of online medical services. Chapter 4 “Proposed Online Medical Care” defines the design of the proposed system. Chapter 5 “Analysis of the Proposed System” contains the analytical description of the requirements to build the project. It also contains the feasibility analysis and cost-benefit analysis of the proposed system. Chapter 6 “Design of the Proposed System” contains information about the design of the proposed online Medical Care system. It includes the Schema definition, ER diagram, DFD and Flow chart of the proposed system. It also contains information about Apache2Triad design of the MySQL database and user interface. Chapter 7 “Coding, Testing and Implementation” contains information about the coding, testing and implementation of the proposed system and the tools that are used to do so. Chapter 8 “Backup, Security and Maintenance” contains information about the over all security, backup, maintenance of the proposed system. Chapter 9 “Conclusion and Future Works” concludes the dissertation and also includes the future works that can be done for the further development of the system. Chapter 2 Study of Existing System 2.1 Introduction I proposed to implement the Online Medical Care system as my project. As my project is Online Medical Care, I survey on RIC Hospital, Lalmatia, Dhaka. It is a genuine multi-system hospital housed in 7- strayed scientifically planed building. The complex is a multi-hospital system as it is divided into different specialized areas of treatment. 2.2 Present System At present the hospital maintains softwares that are offline software. The software cannot be accessed through internet. These softwares can only be accessed from the different section of the hospital using LAN connection. Patients are not able to get information or reservation using internet. Patient or their guardians have to go to the hospital for booking or appointment. They have to pay a minimum for any service and receive a receipt from the hospital. Before the patient’s release or get the report patients have to pay the total amount of money. 2.2.1 Patient services A general hospital has two types of services Out Patient department and In Patient Department.
2.2.2 Outpatient Services The main hospital starts from the ground floor of the building. Advice and general consultation of all diseases both for male and female as well as children. 2.2.3 In Patient Services Advance in patient services are made available to afford treatment for a wide range of medical and surgical problems.
• • • • • • • • • • • • • • •
Internal medicine Cardiology Gastrology Dermatology Stroke and Neurology Burn and Plastic, Cosmic Surgery Urology Oncology Stock Diabetics Nero Surgery Orthopedic Surgery General and Laparoscopic Surgery ENT
Medicine and Diabetic Service Unit They provide also many important services except that. These are Admission/Discharge, Nursing services, CT Scan, Echo Cardiogram, Doppler, Health Checkup Packages. Blood transfusion and other medical support services. 2.2.4 Surgical Site The Hospital Surgical site comprises of most modern and highly equipped eight Operation Theaters. These Theaters suffice for all kind of surgery including Laparoscopic and Cosmic Surgery o TURP o TURBT o Proctoscopy o Cystoscopy o Sigmoidoscopy o Ureteroscopy 2.2.5 Neonatal Care Unit The unit is equipped with incubators including Open Care Unit, Phototherapy Unit, inhalators, emergency medicine, continuous oxygen flow system and Pulse-Oxymeter. Trained medical and nursing staff attends the patients round the clock Even portable Phototherapy units are also available. 24 hours Emergency Neonatal management services.
2.2.6 Diagnostic Facilities In this section, various diagnostic facilities of the hospital are presented into a number of sections. 2.2.7 Laboratory Advance Laboratory services providing diagnostic facilities in clinical pathology, hematology, biochemistry, immunology and microbiology. 2.2.8 X-Ray Most advanced X-Ray machines are available here. Like; • Digital X-Ray • Mobile X-Ray. 2.2.9 ECG and Ultra sonogram Highly trained personnel are engaged in the unit, supported by advanced ECG machines. A well equipped ultra sonogram Unit available for all kind of ultra sonogram. 2.2.10 Donor The hospital reserved bloods of different type and they provide to patients when necessary. They also keep information about different donor. 2.2.11 Emergency Medical Center In this section, various services provided by the hospital are described. 2.2.12 24-Hour Services A highly equipped Emergency Medical Center works round the clock. 2.2.13 Ambulance Services Modern and luxurious Ambulances are kept ready round the clock for speedy transportation. 2.2.14 Clinical Dietary Services The department provides all the important services of planning therapeutic diets, counseling regarding special and therapeutic diets, nutrient-drug interaction and consultation with physicians on nutritional problems. 2.2.15 Cabin Services The hospital has several types of cabin. Such as cabin for cancer patient, cabin for VIP patient, cabin for general or dengue patient. 2.3 Procedure to Maintain Information: In which way the management manages the patients all type information is describe step by step in below. 2.3.1 Procedure to handle Patient coming to the Doctor The patient who are not admitted, firstly they come to the front desk, the desk manager gives him/her a ‘Patient Information‘ form. The patient or guardian fill-up the form and submit it to the desk manager. The management handle this information like patient Id, patient name, age, gender, date of birth, present address, permanent address, contact.
2.3.2 Procedure to handle Doctor Information After fill-up the form the patient come to the doctor for check up. The doctor can give him/her some medicine or different types of tests. But they store all the doctor information like doctor id, doctor name, contact gender, salary, duty hour, e-mail, field of specialization, joining date, post id, fees, discount etc. 2.3.4 Procedure to maintain Cabin Information In a hospital there are different types of cabin for the patient like VIP, general, cancer, stroke and so on. The management keeps the information, cabin id, cabin name, status and charge. 2.3.5 Procedure to maintain Testing Information There are different types of hospital. In this hospital they store all the date about testing manually suppose testing id, name, price, amount, total price. 2.4 Limitations of Existing System After analyzing the existing system, I found some limitations. These are:
1)
There is no online system. If someone wants to know any information about the hospital, then it becomes hard for him/her to get information from online. 2) The patients have to come to the hospital, when they want to admit themselves. They are not getting the facilities of booking from there home using internet. 3) They are unable to know about the doctors who are present on a particular day or time without going to the hospital. 4) Patients have to present themselves or their guardian for appointment. 2.5 Conclusion In this chapter, I reflect my study on an existing medical care system. Here I focus on various procedures to carry out the day-to-day operation of a hospital. From my study, we identify several shortcomings of off line system. Depending on this study I am going to develop online medical care software to provide several service and information to the user. In my system I am trying to overcome the shortcomings. In the next chapter I am going to present my proposed system. Chapter 3 Online Medical Care 3.1 What is online medical care? The software ‘Online Medical Care’ is used to provide information about a hospital and the facilities like appointment to doctor or booking for services that are available in a particular hospital over the Internet through a hospital’s secure website. This allows users to get several conveniences outside of hospital and from anywhere where Internet access is available instantly. In most cases a web browser such as Internet Explorer or Mozilla Firefox is utilized and any normal Internet connection is suitable. No special software or hardware is usually needed. It uses today's computer technology to give us the option of performing our goal more quickly and efficiently instead of traditional medical care system. 3.2 Origin of Online Medical Care The advent of the Internet and the popularity of personal computers presented both an opportunity for online medical care. For some years, hospitals are using computers in order to automate their everyday jobs, today, often people have to go the hospital or make a telephone call to acquire information. Now that individuals are connected to the Internet via personal computers, so medicals can make such information
available to general people and give the opportunity of appointment or reservation of services and familiarize those from their home. Hospitals view online medical care as a powerful implement to helping people to eliminate timeconsuming paper handling, interactions with the doctors and mitigate our necessities. 3.3 Features Online Medical Care usually offers such features as: • Appointment to doctor. • Reservation for services. • Booking a particular type of cabin. • Find out donor for blood, kidney or eye etc. • Someone can be a donor of the hospital. • Consult with doctor’s • E-mail to doctors for advice. If hospitals offer online medical care, general people will get the facilities from their home which is time saving and cost reducing. Similarly it can serve people more effectively. 3.4 Advantages of Online Medical Care Accessible from Anywhere: People can access Online Medical Care sites somewhere if internet is available. • Faster: Online medical sites generally perform services quicker than traditional medical care services. • Convenience: Online Medical Care sites never close; they're available 24 hours a day, seven days a week and they're only a mouse click away. • Efficiency: One can access and manage all of his/her tasks from one secure site. • Effectiveness: Several users can use the same site at the same time. 3.5 Disadvantages of Online Medical Care •
• • •
In case of, occurring any problem on machine the service may remain closed. If the server crashed then people will be unable to use the website. In this software, we can permit user to have advance booking or appointment but we cannot provide directly payment online for particular service . Chapter 4 Proposed Online Medical Care System 4.1 The Proposed Online Medical Care System The online medical care system is specially meant for patients for the most effective use of getting information about doctor or services provided by a hospital. With the help of this software, we computerize different kinds of activities related to the hospital that a patient needs through online. This includes the complete infrastructure of the hospital activity, to do the work competently and efficiently. The online medical care system that this project proposes is mainly to eliminate the need to maintain a large number of information and getting information in a very time consuming way. This proposed project is to develop and implement a web-site through which the patients or users can get information about a particular doctor that is when a doctor is available in the hospital, doctor’s detail, can appointment to a doctor or booking for several different services. It will speed up the operation of a hospital and it responses to the increasing demand of today’s people. This project is a demo, so it does not show the online medical care system in a vast way, but tries to implement more satisfactory services to the people. 4.1.1 The Proposed System’s Structure
The web site has a general view, which is shown to the public and a registered view registered/administrator, which is shown to the administrator. The administrators are given specific user name and password through which they can log into the web site, only they have the access permission to edit, delete or modify the database. The general users will insert their user name and they will be given a password. They only can get information about doctor/hospital, appointment to a doctor or booking for services. General user can only modify their personal information or cancel appointment. The menu of the web site will have the following items: Main menu: Online Medical Care software has 5 main Buttons, according to which we can perform all kind of tasks, specified by the following Modules. HOME
SERACH
SERVICE
REPORT
ABOUT DEVELOPER
Each of the above menus is described shortly below: General View: When a user chooses the user mode the login form appears and then can login by providing user name. User have no need to insert password, rather they will be given a password, which they can use farther, in case of modifying their personal information and also for some other purposes. Registered View: When an administrator chooses the admin mode, the login form appears and then can login by providing their user name and password. After logging in administrator can access the following menu: 1. Home: When the administrator/user puts the mouse over the Home menu, will find the following sub-menu, HOME
SERACH
SERVICE
REPORT
Administrator Panel
ABOUT DEVELOPER
Doctor Panel
Exit
Insert database Modify database Remove database
• • •
Administrator Panel: Administrator Panel has 3 menus. These are Insert database, Modify database and Remove database. Only the administrator can access to this panel. No user can go through this panel. Doctor Panel: Doctor can modify their personal information, find out the list of patients taken appointment, consult with individual patients. Exit: Used to exit.
General users can access the other menus also.
2. Search: Search menu has 3 sub menus – • Patient Search: User can access to this panel using their previous user name and password to modify their database. • Doctor Search: Users can search for a particular doctor according to their need. • Available Doctor: There are 2 another buttons named • •
HOME
Available doctor- providing information about doctors who are available on the current day and Doctor’s schedule- providing information about doctor’s schedule on a particular day of week. SERACH
Patient Search
SERVICE
REPORT
ABOUT DEVELOPER
Doctor Search
Consult With Doctor
Appointment to Doctor
Available Doctor Doctor’s Schedule 3. Services: Contains information about the services provided by the Hospital. Service menu contains the following sub-menu: • Donor Reservation Service: To find out donor according to patients need • Bed Reservation: Keep bed/cabin information. • Other Service: This includes the following: Diagnosis/ Ambulance: Finding the services providing by the hospital. • Donor Club: If someone wants to be a member of donor association will find a form by clicking on this button. SERACH SERVICE REPORT ABOUT DEVELOPER •
HOME
Donor Reservation Service
Bed Reservation
Ambulance Reservation
Other Service
Diagnosis Donor Club 4. Report: When user place the mouse over the button report will find two sub menus. Following are the sub-menus: • Generate your account Report: This contains 2 different buttons – • Report By Service: Individual reports for particular services. • Total Report: The report for all services taken by a patient. • Your Personal Report: HOME
SERACH
SERVICE
REPORT
ABOUT DEVELOPER
Generate your account Report
Your Personal Report Report By Service Total Report
5. About Developer: Contains the address and contact details of the administrator and the webdevelopment team. 4.1.2 Details of The software: Insert Database: By clinking the Insert Database Button the administrator will find several option to insert database like insert doctor, insert service, insert cabin information: Insert Doctor: • By selecting insert doctor database a form to input information will be appear. • There are 14 text buttons in order to input doctor’s detail information. • One of them bearing the ID number, which is auto generated. • Two option button to specify the specialization field and gender. As a result administrator have no need to type these information. • Another two button, by clicking one of them a window will be appeared to enter schedule for the particular doctor according to the ID number. • The rest one is to input the doctor’s rest information. Insert service: • While admin select insert service, then a form containing two text box to insert service name and per unit cost. • An auto generated service id will be also inserted with other information. Insert cabin information: • In case of selecting cabin information the form containing a text box and an option button will become visible. • While selecting the cabin location and floor number another form will appair to input the room/cabin type, total no of bed on that particular room and per bed cost. • Also a submit button to insert cabin information. • The room and bed ids are auto generated. Modify Database: When administrator clicks on Modify Database button then he/she will find a form having several buttons like modify doctor database, modify patient database. Modify doctor database: • A search engine having a text to write and an option button to select whether it is a user name, password, first name, last name, specialization or anything else. • Each form containing 15 texts will be appear and show all information about doctor. • Without user name and password the other 13 texts can be modify by administrator. • A button named change schedule is to open a new window showing the schedule of each particular doctor and can modify if needed. • There is also a reset button to reset the new given value. • The modify database button is to insert the changed value into database. Search for doctor: • In order to search doctor users have to go to the search menu and click to the doctor search button. • Then they will find two-option buttons to select specialization and gender. • After selecting they will have to click to the search button and will find details of the particular doctor.
• • • • • •
10 texts to show information about the doctor. By clicking on the schedule button user can show doctors schedule and can appointment for a particular day. A send mail button to send e-mail to a doctor if needed. While clicking on the send nail button a window will be opened bearing a message box, a text field to write the senders address and another to write the topic. After clicking on the send button the mail will be send to the corresponding e-mail address. A close button to exit the page.
Doctor’s Schedule: • Contains an option button to select the day and also a button named ’search’. • When users select the day for which they want to find a doctor and click the search button, the lists of doctors who are available on that particular day will be visible. • To show the detail of a doctor a button ‘Doctor Detail’ is there, by clicking which a new window showing the whole information of a doctor will appear. • Another button ‘Appointment’, when users click on this button a form will come into view, which is to fill up with patient’s personal information. • While users click on the ‘Submit’ button an window alert will become visible and clicking on the ok button the appointment will be granted and then the patient will be given a receipt. Available Doctor: • The available doctor button is to show the list of doctor’s available on that particular day that is the log on date. • Patients can appointment to a doctor from here. Donor Reservation Service: • Two option button is there, one of them is to select for which a patient is looking for a donor that is if it is blood, kidney or anything else. Another is to select the blood group of the donor. • If the selected items matches then details about the donor will be seen along with the last donated time. • Patients will find their contact number and mail address and can contact to them when needed. • In case of blood if the last donated time is less then 3 month then the name of donor will not be shown to the users. Bed Reservation: • The total number of available bed in the hospital is first shown to the users. • An option button to select the cabin type like VIP, General, Dengue, Cancer, Diabetics etc whatever a patient need. • After selecting the detail of cabin information will appear. That is the floor no, cabin no, location, bed id and cost of the particular bed. • A ‘Booking’ button on clicking which a form to fill with patient detail will be visible. • Then patients/users have to fill two texts for booking date and probable duration. • A button to generate the receipt, which they need to show to the hospital. Ambulance Reservation: • There are two types of ambulance, local and emergency. • User can make a reservation for ambulance what they need. • If they need ambulance emergency they can send a request to the hospital.
Diagnosis: • The option button is to select service name. After clicking users can show detail of the particular service. They have to insert the booking date and the duration. • After clicking the booking button a receipt will be generated and the service will be booked. Donor Club: • If anyone wants to be a donor then he/she has to click to the donor club button. • Then a form bearing 11 texts to fill donors personal information three option buttons to select the gender, blood group and what a person wants to donate. • The submit button will submit information into the database and generate a receipt, which a donor have to show to the hospital. Report by Service: • While clicking on report by service button users will be ask for their patient id. • Inserting the id users have to click on the ok button and several button in a form bearing the service name will appear. • Users have to click the button for which service they want to show payment details. • After clicking on the button a window will be opened showing patients personal information along with the payment details for the particular service. Total Report: • If user wants to show their total payment for all services they will go to total report and will be asked for patient id. • After providing the id number they could show their payment details along with their advance or due payment. 4.1.3 Procedure to Maintain Information 4.1.3.1 Procedure to Maintain Doctor Information • The software generates a unique number for each doctor of the hospital to easily identify him or her. This number is generated automatically. • The administrator inserts the details of a doctor. 4.1.3.2 Procedure To Preserve Patient Information • The software will automatically generate a unique number for each patient. This number is not editable by the user. • Patient can fill up the admission form of their details from online. And the patient details will be saved in the database. • Each patient or user will be given a user name and a password by which they can access later only to modify their personal information or cancel appointment. 4.1.3.3 Procedure To Save Room Information There may be different types of room like VIP cabin, General cabin, Word and so on. Each room will be given an id number automatically. • Location of the room will be provided. • Total number of bed will be held. • Cost per bed will be kept which differ for various kind of room like VIP, General, Stroke, Diabetic, and Cancer etc. 4.1.3.4 Procedure To Accumulate Bed Information: • •
• • •
Each bed will be given an id number automatically. Booking status of a room will be kept to make a reservation for the rooms by the patient. Booking date for each bed will also be held.
4.1.3.5 Procedure To Save Service Information • •
A service id will be generated automatically. Service charge per unit will be kept
4.1.3.6 Procedure To Accumulate Schedule of doctor • •
A serial number will be given. The time schedule of doctors will be send to database according to their working day.
4.1.3.7 Procedure To Collect Patient Appointment Information • •
A serial number will be generated automatically. The day for which a patient is giving appointment and to which doctor will be reserved.
4.1.3.8 Procedure To Gather Patient Account Information • •
An auto generated account number will be given. Total cost of all the services taken by a patient will be held.
4.1.3.9 Procedure To Save Specialization Information • •
Specific ID number will be given for each specialization. The name of specialization field will be kept.
4.1.3.10 Procedure To Accumulate donor Information • • •
Specific ID number will be given for each donor. The full name of specialization field will be kept. Donors all personal information will be stored, specially their contact number,
Chapter 5 Analysis of the Proposed System 5.1 Introduction Before the project is built and implemented it has to go through phases of Feasibility Analysis, Requirements Analysis and Cost-benefit Analysis. This analysis describes the need to develop a project on Online Medical Care and its benefits and the drawbacks of this project will come out while analyzing it and developing it. 5.1.1 Feasibility Analysis Most analysis agrees that there are four categories of feasibility test: • Operational feasibility is a measure of how well the solution of problems or a specific alternative solution will work in the organization. It is also a measure of how people feel about the system. • Technical feasibility is a measure of the practicality of a specific technical solution and of the availability of technical resources. It is also a measure of schedule feasibility, if deadlines are established. • Schedule feasibility is a measure of how reasonable the system timetable is.
•
Economic feasibility is a measure of the cost-effectiveness of a project or solution.
Operational and technical feasibility criteria measure the worthiness of a problem or a solution. Operational feasibility is people-oriented. On the other hand Technical feasibility is computer-oriented. Schedule feasibility is the determination of whether the time allotted for a project seems accurate. Economic feasibility deals with the costs and benefits of the information system. Actually, few systems are infeasible. Instead, different options tend to be more or less feasible then others. 5.1.1.1 Operational Feasibility Operational feasibility criteria measure the urgency of the problem (survey and study phases) or the acceptability of a solution (definition, selection, acquisition and design phases). We measure operational feasibility to be considered by answering the following questions: 1. Is the problem worth solving, or will the solution to the problem work? 2. How do the end users and management feel about the problem (solution)? We have done surveys and studied the problems to find out the solutions. The surveyquestionnaires are attached at the end of the report. 5.1.1.2 Technical Feasibility Consequently, technical feasibility looks at what is practical and reasonable. Technical feasibility addresses three major issues: 1. Is the proposed technology or solution practical? 2. Do we currently possess the necessary technology? 3. Do we possess the necessary technical expertise, and is the schedule reasonable? 5.1.1.3 Schedule Feasibility Schedule feasibility is defined on the question, given our technical expertise, are the project deadlines reasonable? Some projects are initiated with specific deadlines. We need to determine whether the deadlines are mandatory or desirable. For instance, a project to develop a system to meet new government reporting regulations may have a deadline that coincides with when the reports must be initiated. Penalties associated with missing such a deadline may make meeting it mandatory. If the deadlines are desirable rather than mandatory, the analyst can propose alternative schedules. It is preferable (unless the deadline is absolutely mandatory) to deliver a properly functioning information system two months late than to deliver an error-prone, useless information system on time! Missed schedules are bad. Inadequate systems are worse! It’s a choice between the lesser of two evils. 5.1.1.4 Economic Feasibility The bottom line in many projects is economic feasibility. During the early phases of the project, economic feasibility analysis amounts to little more than judging whether the possible benefits of solving the problem are worthwhile. Costs are practically impossible to estimate at that stage because the end-user’s requirements and alternative technical solutions have not been identified. However, as soon as specific requirements and solutions have been identified, the analyst can weigh the costs and benefits of each alternative. This is called a costs analysis. We also have provided a cost analysis report, with the concern of our supervisor.
5.1.2 Feasibility Analysis of the Proposed System The feasibility analysis of this proposed project of online medical care therefore covers these four categories. 5.1.2.1 Operational feasibility Operational feasibility of this project determines the necessity of such a project like online medical care. At the present time everything is on the World Wide Web. Mostly every task can be done through or on the Internet. More over it can be done more efficiently, more conveniently and in a much lower cost. So every hospital is now providing their patients the easy and low-cost solution of making their appointment, booking, consulting online. So it is obvious that it is worth establishing an online medical care system to cope up with the present world. People will definitely appreciate and welcome this step because it is for their convenience. Hope, this software, will fulfill people’s requirements related to their need. 5.1.2.2 Technical feasibility Addressing the three major issues of technical feasibility it is definite that the proposed technology is practical. The patients/users will be able to give their appointment to doctor according to their need and give booking for several different services from anywhere in no time. In this fast going life of the present world nothing can be more practical than to have an online medical care system. Considering the time period given for this project, the proposal states the project should be done using the web-development tool HTML, PHP. PHP can be used to design and implement a web site in a very short time and it can be linked with MySQL. And all these can be done and managed very easily in a short time. To make a demo web site on online medical care this tool is much practical. 5.1.2.3 Economic feasibility The economic feasibility of this project is much high because this project is based on free technologies. There is practically no expense in the development phase. So, economically this project is very feasible. 5.1.3 Requirements Analysis Requirements analysis is the task of defining and specifying the requirements that is needed to develop the system. After determining how the system will be developed, the requirements to design and develop the system are defined. To develop a demo online medical care project, the requirements are as follows: 1. 2. 3. 4.
Computer Systems. Apache2triad Software PHPMyAdmin JAVA script
Mainframe
Via VSAT Server PC
Via VSAT
Via VSAT Client PC Client PC Figure 5.1 The network setup of a hospital 5.1.4 Cost-Benefit Analysis
It is necessary to go through a cost benefit analysis to determine whether the project will be feasible economically. The primary objective of the cost benefit analysis is to find out whether it is economically worthwhile to invest in the project. To perform the analysis we first list all the cost associated with the project. The following list shows that: 1. Cost of hardware 2. Cost of software 3. Cost of the project team 5.1.4.1 Cost of Hardware This cost includes cost regarding the purchase and installation of the hardware. The hardware needed for the proposed system includes web sever and workstations. Web server is needed for testing our proposed system and workstation are needed for coding our proposed system. But the hospital already has web server running in existing system where we can test our system. 1. Cost of Internet Connection We already have Internet connection in our existing system so we don’t need another Internet connection. 2. Cost of LAN Setup In the existing system all the computer systems are connected to LAN. So there is no cost for LAN setup. 3. Backup Cost There is already UPS for Web server in our existing system. So there is no need to purchase any UPS for our proposed system. So, there is basically no hardware cost for our proposed system. 5.1.4.2 Cost of Software The software needed in our proposed system includes Apache2Triad, where we get phpMyAdmin 2.6.1 and use the MySQL 4.1.11-log to build our database. The forms for the Online Medical Care menu are created with VISTA Buttons to reduce the cost. Both the Apache2Triad and vista buttons are freeware and so there is basically no added software cost. 5.1.4.3 Cost of Project Team The project team consists of 4 members. The project manager guides the whole team and manages the whole project. The system and database administrator does the design and analysis of the project. And the web developer and programmers develop the web site. Duration (Weeks) 10 System Analyst Duration (Weeks) 4
Project Manager Weekly Salary (Tk.) No. of Employees 5000 01
Total (Tk.) 50000
Weekly Salary(Tk) 4000
Total(Tk.) 16000
No.of Employees 01
System & Database Administrator Duration (Weeks) Weekly Salary (Tk.) No. of Employees 9 3500 01 Web Developer & Programmer Duration (Weeks) Weekly Salary (Tk.) No. of Employees 9 2500 04
Total (Tk.) 31500 Total (Tk.) 90,000
Table 5.1 Cost of Project Team 5.1.4.4 Total Expenditure Serial No.
Investment Hardware Cost Software Cost Project Team Cost Miscellaneous Grand Total
01 02 03 04
Cost (Tk.) 0 0 187500 5000 192500
Table 5.2 Total Expenditure 5.1.5 Net benefit The net benefit of this can’t be estimated by price value. If we implement online medical care system, the hospital will gain customer satisfaction and good will. 5.1.6
Project Time Estimation
5.1.6.1 Generation of Activity List for the Project: To provide a listing of the project and depict the essential information about the scheduling of the individual activities and their corresponding interdependencies, a list of the activities involved in the various phases of the project is prepared. There are nine activities in total in our project. They are listed below with their immediate predecessor and mean time. Activity A B C D E F G H I
Description of Activity Planning & Requirement Analysis Preliminary System Design Detail Database Design Database Implementation System Security Design Web Interface Design Web Interface Security Design Interface Module Assembly & Testing System Integration & Testing
Immediate Predecessor --A B C C D D F, G E, H
Mean Time (Week) 4 2 2 1 1 1 1 2 2
Table 5.3 Activity list with duration
Chapter 6 Design of the Proposed System 6.1 Introduction
In this chapter, the design of our proposed system is given in detail. Some screen-shots of the web site are also included. The data flow diagram of the system, the schema definition, ER-diagram and flow chart are used to describe the system-design. 6.2 Dataflow Diagram
A dataflow diagram (DFD) is a graphical representation of the "flow" of data through an information system. A data flow diagram can also be used for the visualization of data processing (structured design). It is common practice for a designer to draw a context-level DFD first, which shows the interaction between the system and outside entities. This context-level DFD is then "exploded" to show more detail of the system being modeled. The DFD of this project is given in the figure 6.1, 6.2 on page number 23.
FiillRequest up and for Send FormDoctor Desired Sent form with
User
Patient Database
yl pe R
Appoinment DB
Admin Process esa bat a Dt nei t a P
id for personal
information Reply with Receipt
User User
Request for Service
Sent form with Patient ID for personal
Reply with Receipt
l pe R y noi t a mr of nI t nei t a P
Fiil up and Send Form
r ot c o Dr of yr e u Q
yl pe R
Doctor database Fig: DFD of online appointment system of the proposed system. Account DB Patient Database
Admin Process
eci vr es r of t s e uqe R
yl pe R
Service Database
Fig: DFD of online booking system of the proposed system 6.3 Schema Definition Entity Sets: 1. doctor(doctor_id, first_name, last_name, user_name, pass, specialization, add1, add2, add3, contact1, contact2, contact3, fax, email, gender, fees) 2. patient (patient_id , patient_name , date_of_birth, age, gender, e_mail, present_address, permanent_address , user, pass, contact1, contact2, contact3, address2, address3, ref, logon_date) 3. schedule (sch_id, doctor_id, sat, sun, mon, tue, wed, thu, fri) 4. patient_account(account_id, patient_id, service_id, duration, total_cost, log_on_time, booking_date, adv_payment, due_payment ) 5. service (service_id , service_type, service_cost) 6. specialization(id, name)
7. room(room_id, floor_id, room_type, location, total_no_of_bed) 8. bed(bed_id, room_id, booking_status, cost) 9. donation( d_id, b_id, full_name, gender, contact1, contact2, contact3, e_mail, add1, add2, add3, fax, last_donated date, DOB) 10. bank( b_id, name,type, avail_quantity) sp_ typ 11. ambulance(type, cost, quantity) id cost na e type status me 12. ambulance_booking(a_id, status, type) specialization a_id Relationship Sets: 1. Appointment [Doctor Patient] (serial, patient_id, doctor_id, day, status) A ambulance ambulance_booking B 2. P_ACK [Patient Account] D _ 3. DS [Doctor Schedule] passwor 4. DA SP[Doctor Appointment] d 5. P_SER [Patient Service] P_A pass que dob User_na 6. PB [Patient Bed] M e-mail ntity me 7. BF [Bed Floor] contact Login_da doctor_ 8. D_SP [Doctor Specialization] te id addre patient_id 9. P_A[Patient Ambulance] patientr_F_nam gend ss e 10. AB[Ambulance Ambulance_booking] er last_nam doctor 6.4 ER-Diagram e gend Entity-relationship model. Databases are used er to store structured data. The structure of this data, patientr_L_nam e_fmail e together with first_nam other constraints, can be designed using a variety of techniques, one of which is age e patient Appo called entity-relationship modeling or ERM. The end product of the ERM process is an entityUser_nam oinm relationship modeling requires a graphical notation for representingelsuch fees diagram or ERD. Data ent fa data models. ER diagram can express the overall logical structure of a database graphically. ER addre x contact da and clear. An ERD is a type of conceptual data model or semantic status diagrams are simple ss data y model. The ER-diagram ofSerial_no our Online Medical Care System is shown in the figure 6.3 on page service_i number 52. account_i d d
service_i d du e
PS R
booking_dat e Pa c
account duratio n
adv_paymen t logon_da te
32
PB
service cost
PD
service_typ e
Booking_dat e
total_cost
bed_i d
Last_don_dat e
bed
dob SD
booking_stat us add
donarion
don_i d
name si d
duratio n BR
conta ct
db sat
thus
room
su n
schedule
type
id
mon tues
fri we d
Room_id
name
bank
roomtype account_numb er
quantity
Figure 6.3The ER-Diagram of Online Medical Care sytem
6.5 Table-Diagram The diagram showing the relationship between different tables. Table-diagram of our Online Medical Care System is shown in the figure 6.4 on page number 52
Figure 6.4 The Table-Diagram of Online Medical Care 6.6 Table Structure To design and implement the database of the proposed system 11 tables are used for the database of the Online Medical Care System system. The structure of the tables are given next : 6.6.1 ‘doctor’ Table This table holds the all information about doctor. The primary key of this table is doctor_id. The doctor_id relates the doctor table to the patient table and the sch_id relates this table to the schedule table. doctor Field
Type
Null
Description
Unique Identifier of doctor. It is the primary key which is
doctor_id
varchar(50)
No
first_name
varchar(20)
Yes
generated automatically. First name of the doctor.
last_name
varchar(20)
Yes
Last name of the doctor.
user_name
varchar(50)
No
User name for a doctor/administrator to log in.
pass
varchar(50)
No
Password for a doctor/administrator to log in.
specialization
int(6)
add1 add2
varchar(50) varchar(50)
code will appear to the user Address of a doctor. Alternate address of a doctor.
add3
varchar(50)
Another address of a doctor.
contact1
varchar(20)
Contact number1 of a doctor.
contact2
varchar(20)
Contact number2 of a doctor.
contact3
varchar(20)
Alternate contact number of a doctor.
fax
varchar(20)
Fax number of a doctor.
email varchar(30) gender varchar(7) fees varchar(15) 6.6.2 ‘patient’ Table
Specialization code is given here. But the specialization
E-mail address of a doctor. Gender of a doctor. Fees of a doctor.
Table 6.1 The ‘doctor’ table
This table contains the all information about patient. The primary key of this table is patient_id. The patient_id relates the patient_account table to the patient table. It also holds the patient’s user name and the password that the user is provided while logging on for the online medical care services. Patient Field Type Null Description Unique Identifier of patient. It is the primary key, which is patient_id varchar(20) No generated automatically. patient_name varchar(30) Yes Name of the patient. date_of_birth varchar(15) Yes Date of birth of a patient. age char(3) No Age of a patient gender varchar(10) No Gender of a patient. e_mail varchar(25) No E-mail address of a patient. present_adderss varchar(50) No Present address of a patient. permanent_addr varchar(50) No Permanent address of a patient. ess user varchar(10) No User name for a patient to log on in user mode. pass varchar(20) No Password for a patient to log on in user mode. contact1 varchar(30) No Contact number1 of a patient. contact2 varchar(30) Yes Contact number2 of a patient. contact3 varchar(30) Yes Alternate contact number of a patient.
address2 address3 ref logon_date
varchar(30) varchar(7) varchar(30) varchar(25)
Yes Yes Yes No
Alternate address of a patient. Another address of a patient.. Reference of a patient. The time of log on.
Table 6.1 The ‘patient’ table
6.6.3 ‘schedule’ Table The table having all the information about doctor’s timetable is named as ‘schedule’. From Saturday to Friday the time schedule for each doctor is given here. schedule Field Type Null Description sch_id varchar(10) No Scrial number for schedule sat varchar(10) No The time schedule for Saturday. sun varchar(10) No The time schedule for Sunday. mon varchar(10) No The time schedule for Monday. tue varchar(10) No The time schedule for Tuesday. wed varchar(10) No The time schedule for Wednesday thu varchar(10) No The time schedule for Thursday. fri varchar(10) No The time schedule for Friday.
Table 6.3 The ‘schedule’ table
6.6.4 ‘patient_appoinment’ Table The ‘patient_appoinment’ table including information about patient’s appointment day, status etc. This is a reltionship table between patient and doctor. patient_appoinment Field Type Null Description Serial varchar(10) No Autometically generated serial number patient_id varchar(10) No Its Foreign Key. doctor_id varchar(10) No Its Foreign Key Day varchar(6) No Name of the appointment day. status varchar(5) No Payment status. 6.6.5 ‘patient_account’ Table Table 6.4 The ‘patient_appoinment’ table The patient_account table holds the information about patient’s total cost for different services and so on. patient_account Field Type Null Description account_id varchar(20) No Primary Key of patient_account table. service_id varchar(20) No Foreign Key duration varchar(10) Yes How long the service will be taken The total cost for each service taken by a total_cost varchar(20) No patient. log_on_time varchar(10) No The time when a patient is logged on. booking_date varchar(10) No The date when the service will be needed adv_payment varchar(10) Yes The amount of money that is paid. due payment varchar(10) No The amount of money if it is due.
Table 6.5 The ‘patient_account’ table
6.6.6 ‘service’ Table’ The ‘service’ table holds the information about different services provide by the hospital. service Field
Type
Null
Description
service_id
varchar(15)
No
Auto generated ID number.
service_type
varchar(10)
No
Service name
service_cost
varchar(10)
No
Per unit cost of the service
Table 6.5 The ‘service’ table
6.6.7 ‘bed’ Table The ‘bed’ table is used to store information about the booking status of a bed, number of bed in different types of room. That is why, people can gather information about hospital beds and give booking through online
Field
bed Null
Type
bed_id
varchar(15)
No
room_id booking_status
varchar(15) varchar(15)
No No
booking_date
varchar(15)
No
duration
varchar(15)
no
Description Auto generated ID number, primary key of the table Indicates the room ID. It’s a foreign key Keep booking information of each bed Cost of a room according to their type, like VIP/ Cancer/ General/ Stroke etc. The probable duration of how long a patient may need the bed.
Table 6.6 The ‘bed’ table
6.6.8 ‘service’ Table’ This table holds the room information that is types of room, how many beds in a room. room Field Type Null Description room_id varchar(10) No An auto generated primary key. floor_id varchar(10) No Indicates the floor number. Indicates what type of room it is, like VIP/ room_type varchar(10) No Cancer/ General/ Stroke etc. location varchar(25) Defines where the room is situate total_no_of_bed varchar(10) Identifies how many beds in each room.
Table 6.6 The ‘room’ table
6.6.9 ‘specialization’ Table The table holds a specific ID number of each specialization field and name of the field. specialization Field
Type
Null
Description
id
varchar(15)
No
Specific ID number. This is the primary key of the table.
name
varchar(10)
No
Specialization name like medicine specialist, Surgery
specialist etc.
Table 6.6 The ‘specialization’ table 6.6.10 ‘donation’ Table’ The table contains personal information about donor.
Field d_id full_name gender contact1 Contact2 Contact3 e_mail add1 add2 add3 fax last_donate_date dob
Type varchar(20) varchar(30) varchar(20) varchar(20) varchar(20) varchar(15) varchar(30) varchar(30) varchar(30) varchar(15) varchar(15) varchar(15)
donation Null Description No Primary Key of danation table. No The full name of a donor No Gender of a donor Yes Contact number of the donor Contact number of the donor No Contact no of a donor No E-mail address of the donor No Address of the donor. Yes Alternate addres of the donor No Another address of the donor Fax number. The late when he/she donated last. Date o birth of the donor.
Table 6.7 The ‘donation’ table 6.6.11 ‘bank’ Table’ The table contains information about donor like what a person donated such as kidney, blood, eye etc and the total number of donor for each type.
Field
bank Null
b_id
Type varchar(10)
No
name
varchar(10)
No
type
varchar(10)
Yes
available_quentity varchar(25)
6.6.12 ‘ambulance’ Table
Description An auto generated primary key. Blood, eye, kidney etc what a donor require or want to donate. The type of donor’s blood what he/she needs to match with the other. Defines the total number of donor in a particular field.
Table 6.6 The ‘bank’ table
Keep information about ambulance. Ambulance type, available quantity etc are available. Field
Type
abmulance Null
Description
Type
varchar(20)
No
cost
varchar(10)
No
available_quentity varchar(10)
Indicate the ambulance type like general, emergency. The cost per ambulance. Defines the total number of ambulance.
Table 6.6 The ‘ambulance’ table
6.6.13 ‘ambulance_booking’ Table
This table contains the booking information of ambulance. Field
Type
Ambulance_booking Null
Description
A_id
varchar(20)
No
Primary key.
type
varchar(10)
No
Indicates ambulance type
status
varchar(10)
Booking status.
Table 6.6 The ‘ambulance’ table 6.7 The Interface of Medical Care System 6.7.1 The Login Page Login page for users and login page for users: This is the login page for general user:
Figure 6.5 Login Page for user Login page for Administrator: Following is the Login Page for Administrator:
Figure 6.6 Login Page for Administrator 6.7.2 The Page to Select Doctor: We provide three separate way to get appointment to doctor. i. By Selecting Doctor Specialization and Gender ii. By Searching Doctor for Particular Day iii. Available Doctor on Current Day The Page to Select Doctor By Selecting Doctor Specialization and Gender : Patients/ Users will choose doctor according to their need. When they select the specialization and gender they will find the specific doctor. Through the following page patient will find their required doctor:
Figure 6.7 The Page to Select Doctor by Specialization and Gender The Page to Find Out Available Doctor On the current Day If patients want to find out the doctors who are available on the current day, they will click to available doctor button. Then the following page will become visible.
Figure 6.8 The Page to show Doctor Available on Current Day 6.7.3 Patients Personal Information: Patient Have to Fill Up the following form with valid information if they desire an appointment or booking for any service:
Figure 6.9 The Page for patient’s personal information entry 6.7.4 The receipt for appointment: If Patient have to show the receipt bellow to the hospital:
Figure 6.10 The Receipt for appointment 6.7.5 The Page for Bed Reservation: Users have to select the cabin according to their necessitate. The page showing cabin information to reserve a bed is given bellow:
Figure 6.11 The Page to make a reservation of a room. 6.7.6 The Page for advance booking for Diagnosis: This page contains an option button showing the lists of diagnosis or other services When user selects the required service name the following form will appear:
Figure 6.12 The Page for booking any service 6.6.7 The receipt for Diagnosis/ Services: Patients or their guardian must show the receipt bellow to the hospital:
Figure 6.13 Receipts for Booking Service 6.7.8 The Page to Find a Donor: By clicking the ‘Donor Reservation Service’ button following the service button users have to select what type of donor they are looking for. The page to find our a donor is given bellow:
Figure 6.14 The Page to find a donor. 6.7.9 Make an Online donation: If someone wants to become a donor by donating blood, kidney heart etc he/she have to follow the following form:
Figure 6.15 The page to be a donor 6.7.10 Modifying Patients Personal Information: In case of changing any personal information patient have to give their previous user name and password:
Figure 6.16 The Page to insert to modify personal information The Page to Modify Personal information and Cancel Appointment: After providing the user name and password the following page will appear to modify patients personal information:
Figure 6.17 The page to modify patient’s personal information 6.7.11 Cancel Appointment: Following is the Page to cancel appointment:
Figure 6.18 The page to cancel appointment. 6.7.12 Call For an ambulance: In case of requiring an ambulance that may be emergency or local users have to choose from the following page:
6.7.13 Online Consult: A user can consult with the consultant by using this software. The following page will appear when a user choose consult option:
Figure 6.19 The page for ambulance reservation
Figure 6.20 The page for online consult The following page is consultant page while he/she consulting with a user or patient:
Figure 6.21 The page for consultant Chapter 7
Coding, Testing & Implementation 7.1 Introduction This chapter includes the codes of the proposed system. There are three types of coding used in this system. The front end uses HTML, PHP, java script. The online medical care forms are created using PHP scripts. These codes are given in this chapter as sample codes. 7.2 The HTML Code Sample The HTML code is used to create the Interface of the website. There are four HTML frame is used to build the front end. Two of them remain same until user or administrator Login. After anyone Login, the main body of the software react as user â&#x20AC;&#x2DC;s action. 7.2.1 Code for Choose User or Admin Mode: <html> <head><title></title></head> <body bgcolor="#CCFFCC" > <marquee style="font-size: 20pt; font-family: Georgia; font-weight: bold; color: #000080; borderstyle: solid" bgcolor="#00FFFF">Welcome</marquee> <form action=login.php method="Post" target="down"> <p><b><font color="Black" size="4">MODE:</font></b> <select name="d1" size="1" onchange="this.form.submit()"> <option value="Master">Admin</option> <option value="Local">User</option> </select> </form> </html>
7.3 The PHP Codes for the Online Medical Care Forms To maintain better security, the online medical care forms are created with PHP. The code is given below: 7.3.1 The login.php File <script type="text\javascript" > function aaa(form){ if(form.user.value!=""){ form.submit(); document.write("<p><hr><hr><h4>Dont forgot Your <p><font color='Red' size='4'>User Name</font><p>and<font color='Red' size='4'><p>Log on PassWord</font>"); document.write("<p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;<img src=DNA.GIF>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<a href='main.php' target=main><b>Log Out</a></p><hr><hr>"); }//if else{ alert("Enter Valid User Name First ! "); } }//fun </script> <? $inf="User Mode"; $val="Password ?"; if($d1=="admin"){ $log="Admin"; $inf=$typ="Password"; } else {
$log="User"; $typ="hidden"; }
?> <html> <body bgcolor="#CCFFCC" text="#0000FF" link="#FF0000" vlink="#00FF00" alink="#800000"> <form action="request.php" target="menu" method="Post" style="background-image: url('_default_gears.jpg'); border-top-style: solid; border-bottom-style: solid"> <hr size="11" noshade color="#0000FF"> <input type="hidden" name="log" value="<?print"$log";?>"> <font size="4" color="Black"><b> <?print "$log Name";?>
<p><input type="text" name="user"><p> <?print"$inf";?>::<p><input type=<?print "$typ"; ?> name="pass" value="" ></p> <input type="Button" Value="Connect" onClick="aaa(this.form)"> <hr size="11" noshade color="#0000FF"></b> </form> </html> 7.3.2 The doc.php File (Search Doctor) This page finds doctor according to patients/ users requirement. The code is as follows: <script type="text\javascript"> function sch(form){ window.open("schdisplay.php? d_id="+form.doc_id.value+"&log_id="+form.log_id.value,"","weight=450,height=500"); } function mail(form){ var m=form.email.value; if(m!=''){ var w=window.open("","","weight=450,height=500"); w.document.write("<font color=#800000><form method=post action=email.php style=borderstyle:solid;background-color:#E6E6FF; ><hr><hr><hr><hr><h3>"); w.document.write("From:::<input style:solid;><p><p><p>");
type=text
name=from
size=50
w.document.write("Topic:::<input type=text name=sub size=20 style:solid;><p><p><p>"); w.document.write("<input type=hidden value="+form.email.value+" name=to >");
style=borderstyle=border-
w.document.write("Message To Doctor::&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp ;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp ;&nbsp&nbsp;&nbsp;&nbsp;&nbsp&nbsp;&nbsp;&nbsp;&nbsp;<input type=submit value=SendMail style=border-style:solid;>"); w.document.write("<p><textarea name=msg rows=10 cols=50 style=border-style:solid;backgroundcolor:#FDFFF2;></textarea><p>"); w.document.write("<input type=Button value=Close onClick=self.close() style=border-style:solid;> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"); w.document.write(" </form> <hr><hr>"); } else alert("Not Available !"); } </script> <? if($log_id==''){ include("warning.php");
} else{ include("contact.php"); print<<<HTM <b><form method="Post" action="doc.php"> <p> <input type="hidden" name="log_id" value="$log_id"> Specialization::<select name="T3" size="1" > HTM; $result=mysql_query("select * from specialization ")or die(mysql_error()); while($row=mysql_fetch_array($result) ) { $u=$row["name"]; $v=$row["id"]; print "<option value=$v>$u</option>"; }// print<<<HTM </select> Gender::<select name="T4" size="1" > <option value=MALE>MALE</option> <option value=FEMALE>FEMALE</option> </select> <input type="Submit" value="SEARCH"> </form> HTM; $result=mysql_query("select * from doctor ")or die(mysql_error()); while($row=mysql_fetch_array($result) ) { if($ID==$row["e_id"] || $T3==$row["specialization"] && $T4==$row["gender"] ){ \ $ID=$row["e_id"];//////////////////////////////docktor Id $a=$row["add1"]; $b=$row["first_name"]; $c=$row["last_name"]; $d=$row["contact1"]; $e=$row["contact2"]; $f=$row["contact3"]; $g=$row["add2"]; $h=$row["add3"]; $i=$row["gender"]; $j=$row["fax"]; $k=$row["email"]; $l=$row["specialization"]; $m=$row["fees"]; $res=mysql_query("select * from specialization WHERE `id`='$l' ")or die(mysql_error()); while($row=mysql_fetch_array($res) ) { $l=$row["name"]; }
print<<<HTM <form style="border-style: solid;background-color: #FDFFF2;" method="post" action="patiadd.php"> <h2>$l &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; VISITING FEE : <input type="text" name="fee" value=$m size="6" style="border-style: solid"> </h2> First Name : <input type="text" value=$b size="10" name="fnam" > Last Name :<input type="text" value=$c size="10" name="lnam" > Gender :<input type="text" value=$i size="6" style="border-style: solid"> <p> Contact 1:<input type="text" value="$d" > Address 1:<input type="text" value="$a" > <input type="hidden" value="$k" name="email"> <input type="Button" value="Send Mail" onClick="mail(this.form)"> <p> <input type="hidden" value="$ID" name="doc_id"> <input type="hidden" value="$log_id" name="log_id"> Contact 2:<input type="text" value="$e" > Address 2:<input type="text" value="$g"><p> Contact 3:<input type="text" value="$f" > Address 3:<input type="text" value="$h" ><p> Fax:<input type="text" value="$j" > <input type="Button" value="Schedule" onClick="sch(this.form)"><p> </form> HTM; } }//while print <<<HTML <form > <input type="button" value="E X I T" style="border-style: solid; border-color: #FXC00" onClick="window.close()"> </form> HTML; } ?> 7.4 7.4.1
Some JAVA Scripts Codes for the Online Medical Care Forms Java script code to input all necessary information
If any patient does not fill any necessary information into the form which are marked by *** sign, then they will be alert to fill the field. The code is as follows: <script type="text\javascript"> function aa(form){ if(form.T1.value==''||form.T5.value=='Select'||form.T7.value==''||form.T11.value==''|| form.T12.value==''){ alert(" Atleast fill the ***Field ! "); } else form.submit(); } </script>
7.4.2
If patient has any previous appointment to the same doctor:
If a patient want to give twice appointment to the same doctor, then he/she will be given alert. print<<<htm <script type="text\javascript"> var a=confirm("YOU ALREADY HAVE AN APPOINMENT TO THIS DOCTOR. DO YOU WANT TO CHANGE THE PREVIOUS???"); if(!a){ self.close(); } </script> 7.5 Testing and Implementation For validation check we ran through the whole system and each form. We checked whether all functions are performed correctly and data are stored securely and retrieved acceptably. For example, in service booking form whether the accurate service is reserved. In case of making an appointment to a doctor, if there is any previous appointment to the same doctor. If the information on the receipt that is generated for a patient to show farther in the hospital is correct. The insertion of the database like doctor, service or cabin information can only be done by the administrator. The total amount for each service is stored securely and shows the users correctly according to their due and advanced payment. If the patients do not confirm their booking within three days these will be automatically deleted. We checked that if the dates that are automatically deleted are correct according to the window date. There are several steps of checking for the smooth running of the system. If users do not fill any compulsory field then they will be alert to fill the required filed. Without filling up these text fields data will not be stored into the database and booking or appointment will not be granted. And also the logged in user can only modify his/her personal information. The system now can be implemented on live server. And then multiple users can use the software through the hospital website at a time as we implement the software for multiple users. Chapter 8 Backup, Security and Maintenance 8.1 Backup of the Proposed System To take the backup of the database, we will use the phpMyAdmin Export option. The procedures are described in the following sections. 8.1.1 Taking Backup of the Database To take the backup of the database we will use the Export option the phpMyAdmin. We will select the tables for backup and check “Add DROP TABLES” and “Add IF NOT EXISTS” from the structure. After that we will check the Save as File and then save the file on the hard disk or other storage devices by clicking on GO. We also provide the opportunity to the administrator to keep a backup of the database that is a copy of the total database in selected drive in a folder. 8.2 Security of the Proposed System: We have used PHP codes to create forms for the online medical care system just to make it more secured. We have given the Password field in the Login
form to ensure that only the concerned user can log in and get appointment or booked for service. Even the logged in user can view and edit only his/her own information. Also the users cannot see all services without log in. We provide strong security for main database. Without the administrator no one can access there. Farther more none but the administrator can modify or change database. We also do not give the chance to enter a password by the user at the log in time. We rather provide a password to them, which is according to their user name by adding a random number. Before giving the password to the user we check the database and if it duplicates then we increase the random number by one. And do the same process again. 8.3 Maintenance The Administrator of the website will be responsible for the maintenance of the data-backup. The hardware team will maintain the smooth operations of the hardware. Chapter 9 Conclusion and Future Works The Online Medical Care will be helpful for the hospital to cope up with the present competition that exists in the medical arena. It will build good will and increase user satisfaction as well as the number of users. This Proposed Online Medical Care System is a demo version that can be run on a test purpose. Then after understanding the requirements of the users more features can be added and the existing features can be more developed. To run the System properly, proper training needs to be given to the administrator and the customer support officers so that they can help the user any time they need that. The System can be upgraded by using higher quality hardware and the Standard edition of DBQ that has to be purchased. There is a lot of scope to expand the features of this System and make it a stable version form this demo version. It will require more time and skill to do so, but this demo System shows the path to it. Instant messaging system can be implement to this software, as a result users can send message to the doctors immediately. Some diagnosis device can be connected with PC so that a patient will get treatment by online simply using online medical care software. Payment system can be added to this software. As a result, account clearance can be possible by online.