Health Assistant System

Submitted by

Souvik Ghosh (Roll No. 183223-21-0035 -, Regn. No. – 223-1111-0241-18)

in fulfillment for the award of the degree of

Bachelor of Science (Honours)

in

COMPUTER SCIENCE

Under the supervision of

Mrs. Moumita Banerjee
Department of Computer Science
of Calcutta
Kolkata, India

1
 CERTIFICATE

This is to Certify that the research project entitled

Health Assistant System

is a bonafide record of the work done by Souvik

Ghosh, CU Roll no :- 183223-21-0035, Registration no :-

223-1111-0241-18 of under our supervision, in

fulfillment of the requirements for the award of Degree

of Bachelor of Science (Honours) with specialization in

Computer Science from Scottish Church College,

University of Calcutta in the year 2021, at the

examination under CBCS semester system.

Mrs. Moumita Banerjee Mr. Arun Kumar Chakrabarti

Project Guide Head of Department

Department of Computer Science Department of Computer Science.

(Scottish Church College, C.U.) (Scottish Church College, C.U.)

Date: 05-08-2021

2
 ACKNOWLEDGEMENT

I take this opportunity to express profound sense of gratitude and

respect to all those who helped me throughout the duration of this project.

First and foremost, I would like to thank my supervisor of this project,

Mrs. Moumita Banerjee , for her valuable time and guidance. Her willingness
to motivate me has contributed tremendously to my project.

I would also like to thank Mr. Arun Kumar Chakrabarti, Head of

Department of Computer Science, for providing with a good environment
and facilities to work on this project.

I regret any inadvertent omissions.

Souvik Ghosh – 183223-21-0035

Semester VI (Hons.)
Scottish Church College
Calcutta University,
Kolkata – 700 006

3
 TABLE OF CONTENT

Sl. NO. TITLE PAGE NO.

Certificate 02

Acknowledgement 03

1. Abstract 05

2. Introduction 06

2.1 Domain Description 07

2.2 Motivation and Scope of the work 07

3. Background/Review of Related work 09

4. Methodology 10

4.1 Problem Formulation 11

4.2 Algorithm Description and other Design description 12

5. Implementation 15

6. Results and Discussion 20

7. Conclusion 29

8. References 30

4
 ABSTRACT

As the Covid-19 pandemic unfolds across the India, one of the greatest barriers
we are encountering is the absence of credible and consistent data of resources.

The purpose of the project entitled as "HEALTH ASSISTANT SYSTEM" is to

give all the health related information to the people in one platform and to develop software which is user
friendly simple, fast and cost - effective. The project "HEALTH ASSISTANT SYSTEM" has mainly
two parts-- (a) Hospital related issue, (b) Covid related issue. The Hospital related web page deals with
the collection of patients information like book appointment, search nearest hospital along with bed
availability at that hospital, search nearest blood bank along with the blood available at that blood bank
etc. On the other hand the Covid related web page will show you how to prevent the disease , what are
the symptoms of COVID , how to wash hand etc. It also provide oxygen supplier near you, medical shop
near you and also provide ambulance details etc.

The main function of the system is to store all the health related required information and retrieve these
details as and when required, and also to manipulate these details meaningfully. In the main page anyone
can registered himself as "volunteer" also as a "blood donor". Here he/she can be entered using a id and
a password. It is accessible by an Admin and can be retrieved easily. The data are well protected for
personal use and makes the data processing very fast.

Moreover "HEALTH ASSISTANT SYSTEM" is custom built to meet the

specific requirement of people in this pandemic situation.

5
INTRODUCTION

6
1.1 Introduction:
Health Assistant System is an organized computerized all in one system designed and
programmed to deal with the present crisis health issue.

The project Health Assistant System includes registration of volunteers, storing their details into the
system, book an appointment in a particular hospital, show blood bank details and also about Ambulance
information. The software has the search facility to know the nearest oxygen supplier details, medical
shop details, nearest vaccination centre details etc. User can search availability of various type of bed
and the details of available of blood in a particular hospital or blood bank respectively by using and
searching their nearest location. In TELE- MEDICINE One can find doctors information and contact
number by using which he/ she can get proper treatment from home.

1.2 Domain Description:

Specifications should describe the domain explicitly; they should distinguish domain
properties that are independent of the system from those that the system is required to enforce. A
common semantics based on a simple phenomenology allows composition of partial specifications
expressed in different languages. Descriptions should be based on explicit identification of relevant
domain phenomena, and so separate assertion from definition of terminology. Explicit structures over
descriptions are of interest in their own right. Current formal specification techniques are deficient in
some important respects.

Health Assistant System is powerful, flexible, and easy to use and is designed and
developed to deliver reliable and consistent information to the people in this pandemic situation.

It is a Health related web page from which people can easily found any essential information regarding
Hospital, Doctor, Ambulance, vaccination centre, Medical shop, Oxygen supplier etc. Here anyone can
registered himself as "volunteer" to help people who has critical situation in this pandemic. The
volunteer can register himself as a blood donor to donate blood in any camp. User can book appointment
in any hospital. In this pandemic situation all peoples are stuck in home and some are self isolated on
their home, so from this point they can consult with doctors by phone call by using the Tele medicine
facilities. In this web page user can easily find how to prevent the COVID-19 disease , what are the
symptoms of COVID-19 , how to wash hand etc. Users can also find the information about what to do
and what not to do if he/she get infected by the disease.

More specifically it is a HEALTH related system which is designed and programmed to deal with
the present crisis health issue.

1.3 Motivation & Scope of the Work :

As the Covid-19 pandemic unfolds across the India, one of the greatest barriers we are
encountering is the absence of credible and consistent data of health resources. And it is very difficult to

7
get any important information about oxygen supplier, vaccination centre, blood bank, medical
shop, Ambulance etc.

"HEALTH ASSISTANT SYSTEM" is custom built to meet the specific requirement of people in this
pandemic situation. The purpose of the project is to give all the health related information to the people under
one platform and to develop software which is user friendly simple, fast and cost - effective.

The Scope of the project:

1) Information about Hospital along with the various bed availability of that hospital is stored in
the database so anyone can show his nearest hospital status easily.

2) Information about Blood bank along with the various type of blood available in that Blood bank
is stored in the database so anyone can easily show his nearest Blood bank status.

3) Oxygen supplier details and their location, Medicine shop details and the location of that medicine
shop, Vaccination centre details and the location of that centre is shown on the Google map; so users can
easily recognise that particular details by seeing the map. Also they can contact with the provided contact
details on the map.

4) By using TELE - MEDICINE facilities any one can consult with doctors vertually.

5) User can book appointment in hospital and and will get notified by message one day before their
appointment time.

6) From news bulletin user will aware about what is happening around their society.

7) Information about 'how to wash hand', 'how to prevent diseases', 'what are the symptoms of COVID',
what to do and what not to do if anyone get infected by COVID etc will help people to acquire
knowledge about COVID. And by using this knowledge then can stop the spread of the disease.

8
 Background/Review of Related Work

The COVID-19 pandemic has had a major impact on the capacity of health systems to
continue the delivery of essential health services. While health systems around the world are being
challenged by increasing demand for care of COVID-19 patients, it is critical to maintain preventive and
curative services, especially for the most vulnerable populations, such as children, older persons, people
living with chronic conditions, minorities and people living with disabilities.

Countries need to achieve the optimal balance between fighting the COVID-19 pandemic
and maintenance of essential health services.

And in this pandemic situation we all are stucked in home. And in this crisis situation
it is very difficult to retrieve the information and find particular information like- E.g.- To find out about
the vaccination centre, medicine shop, from where anyone can get Oxygen cylinder, blood availability at
a particular blood bank, bed availability at a particular Hospital etc. From this point of view the system
namely "HEALTH ASSISTANT SYSTEM" is very useful. The purpose of the project entitled as
"HEALTH ASSISTANT SYSTEM" is to give all the health related information to the people in one
platform and to develop software which is user friendly simple, fast and cost - effective. Here anyone can
easily get the information about hospital, blood bank, oxygen supplier, medicine shop, vaccination centre,
ambulance etc.

9
METHODOLOGY

10
3.1. Problem Formulation:

Lack of immediate retrievals: -

The information is very difficult to retrieve and to find particular information like- E.g. - To find out
about the vaccination centre, medicine shop, Oxygen cylinder, blood availability at a particular blood
bank, bed availability at a particular Hospital etc., the user has to go through various contact and
website. This results inconvenience and wastage of time.

Lack of immediate information: -

Getting the information from various website and contact person takes time and efforts to be stored
at right place.

--This type of lack of information may cause risk for someone's life in a critical situaion. In this scenario
this system may help someone. We visualize the Health Assistant concept to be one of the most
successful services list by the will of the almighty GOD. Of course this aim will take time , user
feedback , our professional growth etc

3.2. Algorithm Description and Other Design Description:

System Architecture:

11
 Web Source

Database Web Application

Algorithm Description:

12
Entity-Relationship diagram(ERD):

Data Flow Diagram:

A data flow diagram (DFD) maps out the flow of information for any process or system. It uses
defined symbols like rectangles, circles and arrows, plus short text labels, to show data inputs, outputs,
storage points and the routes between each destination

Context free diagram:

13
Level-1 DFD:

Level-2 DFD:

14
 IMPLEMENTATION

Implementation is the stage of the project when the theoretical design is turned out into a
working system. Thus , it can be considered to be the most critical stage in achieving a successful new
system and in giving the user , confidence that the new system will work and be effective. The
implementation stage involves careful planning, investigation of the existing system and its constraints
on implementation, designing of methods to achieve changeover and evaluation of changeover methods.

Sample source for Main screen(index.php):

<?php

include 'config.php';

session_start();

$err = "";

if(isset($_POST['submit']))

$err = "";

$name = $_POST['name'];

$date = $_POST['date'];

$phone = $_POST['phone'];

$time = $_POST['time'];

$hospital = $_POST['hospital'];

$city = $_POST['city'];

$message = $_POST['message'];

$query = "SELECT * FROM appointment WHERE DATE = '$date'

"; $query_result = mysqli_query($conn,$query); if ( $query_result-

>num_rows > 0)

$err = " You already have an appointment booked on $date $time";

else

15
 {

$sql = "INSERT INTO appointment(Name,Phone,Date,Time_Slot,Hospital,City,Message)

VALUES('$name','$phone','$date','$time','$hospital','$city','$message')";

$result = mysqli_query($conn, $sql);

if($result)

echo "<script>alert('Appointment Booked for $name') </script>";

$name = "";

$date = "";

$time = "";

$hospital = "";

$city = "";

$message = "";

else

echo "<script>alert('OOPS! Something went wrong')</script>";

session_destroy();

?>

Sample source of java script for google map(googlemap.js):

var map;

var geocoder;

16
function loadMap() {

var kolkata = {lat: 22.578005, lng: 88.358536};

map = new google.maps.Map(document.getElementById('map'), {

zoom: 12,

center: kolkata

});

var marker = new google.maps.Marker({

position: kolkata,

map: map

});

var cdata = JSON.parse(document.getElementById('data').innerHTML);

geocoder = new google.maps.Geocoder(); codeAddress(cdata);

var allData = JSON.parse(document.getElementById('allData').innerHTML);

showAllOxyzen(allData)

function showAllOxyzen(allData) {

var infoWind = new google.maps.InfoWindow;

Array.prototype.forEach.call(allData, function(data){

var content = document.createElement('div');

var strong = document.createElement('strong');

strong.textContent = "Name: "+ data.name+ ' <!&!> ' +"contact: "+ data.contact;

content.appendChild(strong);

var img = document.createElement('img');

img.src = 'images/medi.png';

img.style.width = '20px';

17
 content.appendChild(img);

var marker = new google.maps.Marker({

position: new google.maps.LatLng(data.lat, data.lng),

map: map

});

marker.addListener('mouseover', function(){

infoWind.setContent(content);

infoWind.open(map, marker);

})

})

function codeAddress(cdata) {

Array.prototype.forEach.call(cdata, function(data){

var address = data.name + ' ' + data.address;

geocoder.geocode( { 'address': address}, function(results, status) {

if (status == 'OK') {

map.setCenter(results[0].geometry.location);

var points = {};

points.id = data.id;

points.lat = map.getCenter().lat();

points.lng = map.getCenter().lng();

updateOxyzenWithLatLng(points);

} else {

alert('Geocode was not successful for the following reason: ' + status);

});

});

18
function updateOxyzenWithLatLng(points) {

$.ajax({

url:"action.php",

method:"post",

data: points,

success: function(res) {

console.log(res)

})

Sample source of connect the php with google map(DbConnect.php):

<?php

class DbConnect {

private $host = 'localhost';

private $dbName = 'health';

private $user = 'root';

private $pass = ' ';

public function connect() {

try {

$conn = new PDO('mysql:host=' . $this->host . '; dbname=' . $this->dbName,

$this->user, $this->pass);

$conn->setAttribute(PDO::ATTR_ERRMODE,
PDO::ERRMODE_EXCEPTION);

return $conn;

} catch( PDOException $e) {

echo 'Database Error: ' . $e->getMessage(); }

?>

19
 RESULTS and DISCUSSION

Results:

Home page:

Book an appointment at a hospital OPD:

20
21
22
23
24
Covid-19 page:

25
26
27
Discussion:

In the present COVID scenario when people were dying being deprived of oxygen , some of them lost
their lives requesting for a hospital bed as hospitals were flooded with COVID patients . People
suffering from other fatal diseases couldn’t get themselves treated . So , there was a dire need of a portal
where people would get the necessary information about Oxygen Parlors , medicine shops and even the
availability of beds in hospitals which could save many lives . Thus , Health Assistant comes with all the
above facilities which will be of immense help to mankind .

Moreover , Health Assistant also assists citizens getting themselves in the vaccination drive carried out
by the Union Ministry at their doorstep . Also , it comes with the option to locate the nearest vaccination
centers .

Thus , Health Assistant is a complete web application that can solve the problems of the common
people that has arised during the COVID – 19 pandemic.

28
 CONCLUSION

Health Assistant provides assistance in a wide – variety of areas starting from Locating a Blood
Bank to check for availability of beds in hospitals. The system has been implemented as a Central
database of all health services in a state which can be extended to country-wise and even universal
extension is also possible . Look for a system provider that wants to work with you to ensure
improvement and long term success for your meetings and events.

Our goal is to provide a useful platform of Health Services at personal level to the end user.
Personalize their searches based on their needs and share it on social networking platform to extend
the helping hands of the system.

29
 REFERENCES

PHP: A Beginner’s Guide by Vikram Vaswani

A Smarter Way to Learn HTML & CSS: Learn it faster. Remember it longer – by Mark Myers
➢
https://getbootstrap.com/
➢
https://en.wikipedia.org/wiki/Main_Page
➢
https://developers.google.com/
➢
https://console.cloud.google.com/apis/credentials?folder=&organizationId=&project=ascendant-
choir-315614

30