Group 1 Full Docu. Revised
Group 1 Full Docu. Revised
Group 1 Full Docu. Revised
A Capstone Project
Presented to the Faculty of the
College of Technology
Lyceum of the Philippines University
In Partial Fulfillment
Of the Requirements for the Degree of
Bachelor of Science in Information Technology
By:
Cortez, Wilbert Webb R.
Noblado, Paolo M.
Sanguer, Martee Piolo C.
Adviser
Dr. Arlene R. Caballero
In the midst of the pandemic period, scheduling a vaccination might be troublesome because a
schedule might be cut off sometimes and even disregarded in the system or log book that a
vaccination is using. A possibility of walk-in patient might result into an overloading in the site
wherein too much people might lead to spreading of diseases which is the Covid-19. The
researchers proposed a scheduling system that has geo-mapping feature wherein the staff can
locate patient that has been vaccinated using their designated address that they inputted. The
system will have 2 modules, for admins/staff, and students. The admin/staff can view, edit, and
delete a patient’s information in the module and also put a new vaccination location. As for the
patient they can only view their records and edit their photo. The geo-mapping feature is only used
when there is specific patient that they want to locate or ask questions about. Also, the address that
they inputted will be stored privately and only admins/staff will be the only one who can see it.
ii
RECOMMENDATIONS
The Capstone Project entitled “iVacTrack: A Web- based Scheduling System for Covid-
19 Vaccination Sites with Patient Tracking Through Geo-mapping” developed and submitted by:
Wilbert Webb R. Cortez, Paolo M. Noblado, Martee Piolo C. Sanguer in partial fulfillment of the
requirements for the degree of Bachelor of Science in Information Technology, has been examined
and endorsed for title defense as bounded by the stipulated objectives, scopes and delimitations.
iii
APPROVAL SHEET
This thesis entitled “iVacTrack: A Web- based Scheduling System for Covid-19 Vaccination
Sites with Patient Tracking Through Geo-mapping” prepared and submitted by Cortez,
Wilbert Webb R., Noblado, Paolo M. And Sanguer, Martee Piolo C.has been reviewed and
recommended as partial fulfillment of the requirements for the degree of Bachelor of Science in
Information Technology.
Accepted and approved by the panel of examiners following a successful Oral Defense and
Presentation on June 26, 2022 with a grade of _______.
Accepted and approved in partial fulfillment of the requirements for the degree Bachelor of
Science in Computer Science.
Date:__________
iv
ACKNOWLEDGEMENT
This study would not have been possible without the researchers that help each other to
make this study become more efficient. The researchers would also like to thank for the panelists
for letting the defense become an enjoyable moment, and for your wonderful comments and
suggestions. The researchers would like to thank the previous researchers because without their
studies they will not accomplish this research and the researchers would like to thank their advisers
because without them their study might be in terrible accomplishment. Lastly, the researchers
would also like to show a deep appreciation to the people who helped finalize the research.
v
DEDICATION
This study is full of sacrifices and countless effort. Through the researchers’ effort, this
study is proudly dedicated to the people who serves as an inspiration. From classmates to mentors,
to the friends of our beloved programmers, and circle of friends whom extended their assist in the
middle of their work while doing this study. This research dedicates this to efficiently schedule
patient that will be having their 1st and 2nd dose and also to monitor each person that appoint their
own schedule. The researchers would like to dedicate this study for some who would like to book
vi
TABLE OF CONTENTS
PRELIMINARIES
ACKNOWLEDGEMENT .............................................................................................................v
DEDICATION.............................................................................................................................. vi
1.1 INTRODUCTION..................................................................................................................14
vii
1.6 DEFINITION OF TERMS.............................................................................................. 18-20
c. CLASS DIAGRAM................................................................................................................35
viii
d. ACTIVITY DIAGRAM .........................................................................................................36
ix
APPENDICES
x
LIST OF FIGURES
xi
Figure 3.19 Code Generator Form ............................................................................................48
xii
LIST OF TABLES
xiii
CHAPTER 1
1.1.INTRODUCTION
certain time that the users can be publicly on their calendars. This allows you to set up tasks in
order of you want and to focus more on your daily reminder. In today’s occurrence, the world is
surrounded by people who have facemasks, and they carry on whenever they would like to go.
Facing the challenges of today’s pandemic, which is the COVID-19, and slowly reducing
the lives of many people around the world. One year has passed, the vaccines are already making
in some known pharmaceutical companies, and they are already being spread across the globe to
cure the patients. In Caloocan City, some vaccines are already ordered by the DOH (Department
of Health) and getting ready for deployment in the other parts of the country, Caloocan is one
example of this. This region is one of the most high-risk cities for the coronavirus, and up until
now, it is facing more problems with the arrival of a new delta variant. So, before the researchers
state the hypothesis, let’s look around some of the problems in the “Scheduling System” during
the pandemic.
The queue might be the main problem because there are an ongoing pandemic and people
must not be around outside of their homes. In conclusion, the Scheduling System that are currently
in used by the country is not as effective as the scheduling system in other countries. Wherein
some of the barangays in the country are using only manual scheduling, which is the walk-in
scheduling. Also locating patient when it comes to these programs are difficult to monitor, thus,
14
creating a new feature in our website that helps locate the patient exact location using geo-
mapping. This will help vaccination staff to fully monitor every patient that will be present and
not present for the vaccine on the day of their patients’ schedule.
Manual scheduling has become of a part of our past ancestors that are still in use as of
today. Health care industries are having a hard time dealing with the cost of each medicine, demand
that exceeds supplies and staff that are dealing with fatigue because of overworking that’s taking
toll on their bodies. Then there are patient that wait for a very long time in the waiting list. Cox III
and Boyd (2020). Locating a patient is a also a big problem because sometimes that specific
location is to help track patient that are disregarding their physical and mental health. This study
aims to access the scheduling system of the vaccination project in terms of flawlessness, efficiency,
systematic. The researchers’ “Scheduling System” is an accessible website which can be used in
mobile devices or computers that aids people who are going to queue in line for long hours.
The “Scheduling System” goal is to befits the patient for their own vaccination schedule
and also to monitor the incoming patients, and to verify the schedule upon the patient’s arrival.
The researchers created a system that will monitor the patient records and the incoming patients
that will use within the system. The researchers used the geo-mapping, which is a digital map to
analyze the location between regions, like a city or in a certain barangay. It helps them to navigate
easily their location on where are they going to be vaccinated. It also reduces the overpopulated
people and the long waiting hours. The system will choose your preferred location site on where
you will be vaccinated. When you are impatient to queue in line and wait for many hours, the
15
system will be highly recommended. As for the existing system here in manila they have no way
of providing information about available vaccines until the city hall announces what available
vaccines are available on each site. Also, patient cannot know whether a vaccination site is packed
or not on the day of their vaccination because they are appointed their own date of vaccination but,
➢ Email notification/SMS
Notification
With the use of analytics, the admin will look after the records of each patient that
registered in the system, and their records on where they are going to be vaccinated in a certain
barangay. The interface will display the data on which fills the detailed information of the patient
The proposed system aims to efficiently schedule patient that will be having their 1st to 2nd
dose and booster shots, also to monitor each person that appoint their own schedule:
16
1.3.2. Specific Objectives:
vaccination site.
This study aims to benefit people who have trouble choosing a date of their schedule for a
vaccination. It is also to help vaccination sites for a better way of communicating with their patient
The Students
To help them understand more about scheduling system and how it was implemented by
the use of our website. It will also help them with their future research paper if they plan to tackle
this subject.
17
The Patient
The Government
This study will be mainly focus on the city of Caloocan. This involves every vaccination
site that are in Caloocan. The selection of respondents will be only based on vaccination sites.
This study is designed to know if vaccination site within Caloocan city are using any
scheduling system for their patient and help them solve their problem with the use of our system
that can be used for scheduling patient/user for a vaccination, keeping tracks of person that are
getting their vaccines, and also give them change to check availability of a vaccines.
1.6.DEFINITION OF TERMS
Digital Records – It shows the information about a certain person. These records are being
Geo mapping – it tells where the specific location of each individual that shown in a certain
device. This will help locate patient location that can be search by the admin of the system.
18
GUI (Graphical User Interface) – A website design that was created to befit with non-tech-savvy
users. A communicator to make the users and computer to communicate with each other.
iVacTrack – A scheduling system that can monitor patients name and locate their location through
Mobile-Responsive – A feature that helps the website be optimize to different sized devices or
gadgets. Website will change the view to fit for a mobile phone.
code – A number code that are automatically generated when schedule is done. It is used for
Scheduling - The chosen time and date that the patient created to fit in their own schedule to be
vaccinated.
System – A website that was developed by the researcher to benefit a company, organization,
Tracker – It tells the exact location of a person you are trying to locate. Putting the exact address
Waiting-List – It will automatically put a queued patient if a person on that day backed out on the
day of schedule. If a patient cancels their schedule a slot will be available for another patient to
schedule.
Dell Inspiron 15 7000 – Gaming laptop. It is a device that the researcher used for checking and
19
PHP – A scripting language used for web development that are embedded by HTML. This is used
for coding the system that the researcher are currently developing.
Pharmaceutical Companies – A place where they discovered and developed pharmaceutical drug
for use to medication. They provide vaccines that will reduce the spread of the virus or pandemic.
Records – It shows the private information about every individual that was scheduled in the site.
Social Distancing – It’s a way to reduce the spread of contagious virus or diseases. This event
starts when covid-19 starts to spread increasingly to every place around the globe.
Time Management – Managing own time spent on a specific activity. Time that they will do the
activity on the exact day that they are given to finished that task.
User-Friendly – The user/individual that uses the website can easily understand and can be easily
used in their needs. User can decide if the software or application is easy to understand or hard to
use.
Web-Based – Software that can be accessed through any device by a HTTP (Hypertext Transfer
Protocol). Using PHP, the systems design and functions are coded for the user to access the
website.
Website – A collection of web pages that are connected to each other and can be identified by a
Vaccine – A synthetic substance that was produced to acquire immunity. It is provided by the
pharmaceutical company that created the brand of the vaccines for the people to be vaccinated
with.
20
CHAPTER 2
2.1.CONCEPTUAL FRAMEWORK
This chapter will discuss about studies that are related about the on-development system that the
researcher is developing:
Figure 2.1 shows the process that the system will do. In input you can see that the admin and user
have its own functionality. Admin needs to put his log-in credentials and user has to schedule
his/her vaccination. In process this shows that Individual user only has the ability to schedule a
vaccination and guest user only has the ability to just view available dates. Admin on the other
hand can manage individuals that has been scheduled, vaccination locations, vaccines, check the
21
code provided by users for vaccination history, and locate users using specified address. In output
this is where the details like scheduled patient, locations, vaccination can be viewed by
administrators. Wherein User must provide the code to check his/her information about the
vaccination.
2.2.FOREIGN LITERATURE
2.2.1. Covid-19
Several elderly individuals or persons with disabilities may face significant barriers to
accessibility to any vaccine (Centers for Disease Control and, 2021). Distribution of vaccines
would be scheduled based on the test results. In addition, an actual case study is analyzed in this
paper using the proposed technique for better illumination (Alipour-Vaezi et al., 2021). High or
more dosages have likewise been examined with variable outcomes. the contrasted antibody plan
and a higher portion yet less shots to the standard plan (Kourkounti et al., 2018). Example of this
as discussed in the study it simply expected to check consistency with the inoculation plan, we
were unable to characterize the immunological status a child after immunization, which is a limit
the review. Kids with pneumonia, paying little mind to arrangement, may even have a refreshed
yet not well produced information about the schedule, which result the child to be helpless (Silva
et al., 2018).
The foundation that is expressed in the review are being called for expanded examination into
the security of the whole youth immunization plan. even if it regards the pre-and post-licensure
22
studies that have been inspected the wellbeing and adequacy of individual immunizations
independently and in blend with different antibodies, the investigations that they implemented
didn't look at the security of the general timetable (Kirstein et al., 2018). scheduling system used
is for patient that has a contaminated or infectious disease to prevent them from going to places
that are overpopulated and stop the spread of the disease. The study aims to have a proper
scheduling system for the immunization program for people with infectious diseases and arrange
their own date and time for the vaccination (García-Serrano et al., 2020). When HPV was present
people are required to take a dose for HPV contaminated illness the study was working on the
proper way to utilize each schedule for the dose of every person that has contaminated illness or
disease. It prevents the people with disease to set the schedule preventing other people to be
infected (Gilca et al., 2018). Optimized scheduling system is a big help to big hospitals because in
the study it states that not only, they can track basic information about the person. It also helps
them record every dose of antigen and injections that the patient has took. This information can
become helpful for a hospital because they will know the history of vaccination of the person that
can lead them to know whether a person has any kind of side effects for taking that vaccine or not
(Popa et al., 2020). It is important to understand how public funding for routine vaccines affects
adherence to the vaccination schedule. The study’s objective aims to characterize impacts for
public financing of the pneumococcal vaccine on vaccination coverage and compliance with the
regimen in the child population of the Community of Madrid (MC) (Carbajo et al., 2021).
which the leader possesses to decide an arrangement energy for every client in the principal stage
to limit the complete expected weighted expenses of clients' holding up occasions and specialist
organizations' inactive occasions over different stages (Zhou et al., 2019). Assist clinical experts
23
with finding and detach tainted people and high-hazard people, forestalling additionally spread
A hypothesis of imperatives thinking processes (TP) examination was led on the scholastic
exploration utilizing an essential consideration practice to approve both substance and causality
presence. From this coordinated examination, a vigorous cycle for planning a PASS came about.
Last, we show that Goldratt's TP gives an intelligent, thorough structure for subjective examination
and plan science (Cox & Boyd, 2020). Outcomes might add to continuous general wellbeing and
local area drew in endeavors to forestall the spread of disease and moderate the lopsided death toll
among these networks because of Coronavirus just as feature the critical need to comprehensively
target area disservice as a reason for unavoidable racial disparities throughout everyday life and
wellbeing (Pierce et al., 2021).The utilization of current method for handling and breaking down
gullible guides permitted to distinguish spatial conditions between geoconcepts, their plausible
restriction zones, and position comparative with one another on the geomental map space
(Zelianskaia et al., 2020). In this exhibit, we present our framework, Respond, for Ongoing Contact
tracing and hazard observing by means of security improved following of clients' areas.
Distinguishing proof about the problem in the area, individual danger observing dependent on the
areas they visit and their contact with others (Xiong et al., 2020). Tracking means watching
individuals that has side effects. Be that as it may, assembling Enormous Information. This helps
the project to be more effective with numerous different expectations that let a person observe and
24
control (McCall et al., 2021). Area based ways to deal with tracking don't need Bluetooth. All
things considered, they use mobile phone network information, Worldwide Situating Framework
(GPS), Wi-Fi signals and other cell phone sensors to distinguish the geolocations of application
clients and area data is utilized to decide closeness to contaminated people. Barcoding procedures
are an elective way to deal with computerized contact following. Speedy Reaction (QR) codes
(standardized tags that can be checked by telephones) can be put out in the open spaces, for
example, transport entryways and store doorways, permitting clients to log visited areas (Kleinman
et al., 2020). Permission to clients to decide with complete protection when they have been inside
a brief distance of somebody that is tainted. We recognize and demonstrate the protection ensures
2.3.LOCAL STUDIES
Patient satisfaction and comfort are the priorities of every hospital. With the traditional
appointment system, patients experience long wait times that lead to dissatisfaction. It is aimed at
patients (appointment booking), medical secretaries (patient list management), doctors and
management (patient monitoring) (Mendoza et al., 2018).This takes a long time and is sometimes
a disaster if the result is not efficient. It is a fact that the organization of class schedules, the number
of teachers and the occupation of rooms for students and faculties in each department is one of the
many activities that every department head must prepare before class begins (Benedict et al.,
2020). Systems can easily create lesson plans and load courses within seconds. It can likewise
anticipate whether a course will be isolated into areas dependent on information from the past
semester. The aftereffects of the assessment of the product show that the framework meets the
25
targets for the review it can be a school’s greatest tool to help it grow (Agustin et al., 2018). The
system that they are discussing in the study are a part of an AI system can determine a fixed
knowledge about a person. The only problem that they encounter are not being able to generate
new information because the system only focuses on what it hears in the Q&A that they were fixed
to natural language. It only circles around a fixed knowledge only (Sanchez et al., 2019).
A complete map of the road network is currently not available. Management can hardly be
achievable without transparency. Smartphones as a tool for large infrastructure investment projects
for tracking and gathering of information, data, and resources (May et al., 2019). Using the GPS,
it identifies the difference between a living and non-living tree that are presented on the map. The
map identifies the red dots as living trees. The only problem about the system is that it only
identifies living trees and not any other living things that can be seen through the map. The
information gathered and put away in the GPS was changed over into credits, which were put away
in a table and connected to the trademark utilizing a remarkable identifier. At the point when an
information base construction was created, the connections between the spatial element classes
and the non-spatial element classes in the elastic tree exhibit ranch were set up effectively (Talosig
et al., 2019). Ongoing mechanical progressions have prompted the improvement of cell phones
and portable applications. Moreover, various assignments are performed using a portable
application, and every application that focus on capacity. Numerous talented specialists in
Philippines that have a great variety of administrations in the local area neighborhood.
Notwithstanding, hand looking for administrations on offer is a drawn-out task (Nabong et al.,
2020). Sea Wave is a boundless wellspring of energy. Whenever utilized proficiently, it very well
may be an ideal force source. While the potential outcomes are boundless, there are inconceivable
26
risks, particularly when encircled by enormous waterways. They used Geo-Mapping to determine
upcoming storms and storm surge within the area. It also stores every information in the database
through the cloud. The study promotes the data and information that they can gather through ocean
waves and transmitting it to predict incoming storms (Balbin et al., 2021). Advancing interpersonal
organizations and versatile advances are assuming a vital part in different areas of society. In the
study it stated that, they performed crowdsourcing to map emergency situations and gather relevant
information using GPS technology (Jr et al., 2019). The findings that they gathered by the
researcher indicated that the geographic data was achieved. It also helps them improved prediction
trained using self-owned satellite images that will help them gather information about a person’s
wealth, education level, accessibility to electricity and water (Tingzon et al., 2020).
2.4.Synthesis
By the reason of advance and innovative systems or software, scheduling system has so many
functions or features that may be used. But, keeping up for the improvement might be too much
for older versions of software or computers. As all of us are experiencing the global pandemic
there are many ups and downs that all of us encountered, but there are also lessons that we learned.
Although there are many systems that can cover for that it may not prevent the overpopulation of
a vaccination site. Lastly. The researchers found out that we can reduce the amount of people
coming in and out of the vaccination site if there is a limit that will be given each day that only the
admin can access or manage. Geo-mapping is used as a temporary locator for the admin to locate
each patient. The patients address of course is saved and secured by the admin and cannot be
spread.
27
CHAPTER 3
This paper should expect the following design and methods to be discussed with. This
section discusses about the schematic diagram of the system, and the website design.
The researcher in the system used the method of Observational Design, to generalize the real-
life situations in a particular behavior and introduce the new discoveries of what variables may be
important. The researchers used this type of research methodology because it allows us to observe
the incoming patient that are setting a schedule for their vaccination that will be recorded in the
website’s system and database, and also to make up a schedule for their certain location and time.
This system also helps the staff to be able to locate every patient’s location depending on where
they will be going to be vaccinated. Hence, monitoring the patient’s location through geo-mapping.
This study will help the people who need the assistance of queueing in line for taking the
vaccine in a specific location. This study will help the community to help them to choose schedule
for their convenient time. This study also helps the community to easily locate the nearest
vaccination sites available in their area. This will help the future researchers for their chosen topic.
28
3.3.Requirement Specification of the Study
This study is created to aid vaccination site to record every person’s information and location
✓ Username and password – it is used to access the website. The admin will manage
and update the records of every person that are scheduled depending on the site
✓ Auto Generated Code – The system will give a person a unique code that they
a. Scope of Modules
Admin module – this will be the main storage of the patient’s record or
information.
Patient module – this will help the patient to monitor their records if they are
Framework prerequisites are the setup a framework needs to have to work without a
hitch and successfully the made framework. Inability to fulfill these requests can prompt
29
Table 3.1 System Requirements
ordinary desk.
and CSS.
30
HTML This is a text-based approach to explain how
Table 3.1 shows the tools and application use and make a proper system. Also, the table
31
System Architecture
Figure 3.1 shows how the system works and what function it can do for the users and administrator
that will be using it. The process that it will take to provide a specific information to the user and
administrator.
32
3.4.Design Analysis
a. Context Diagram
Individual/Patient Database
iVacTrack
Scheduling
System with
Patient Tracking
User/Admin
The figure shown above are the attributes and important context on how the on-development
system work. Also, it shows the control of administrator to the said system.
33
b. Use Case Diagram
Update Patient
Information.
Patient/Individual Administrator
System
Maintenance
The Figure shows how the Individual and administrator can interact with the system using the
34
c. Class Diagram
schedules
id
individual_id
location_id
status
Users/admin
Id
Username
{ Fields
Password
Email
Vaccine_history_list
Id
Location System_info
User_id
Id Id
Individual_id
Location Meta_field Vaccine_list
Vaccine_id
Description Meta_value Id
Location_id
Vaccination_type Max_a_day Name
Vaccinated_by status
Patient/Individual must submit specific information needed to schedule a vaccination. Admin can
manage the individuals schedule status and edit it as primary or fully vaccinated individual. Only
viewing and changing status of individuals record can be done by the admin.
35
d. Activity Diagram
START
No
Patient Scheduling
System initialized
Yes
Pick Schedule
Fill-up
form
36
e. Sequence Diagram
The figure above it demonstrates the organized relationship sequentially to be able to pinpoint the
37
f. Entity Relationship Diagram
The diagram above shows the relationship of each table within the database. It relates one another
with each table, and it shows the function of each table. The diagram specifies the number of
instances of one entity that are related to one example from another entity. The vaccine history is
in the middle of the diagram which connects to all other tables such as users, individuals,
schedules, location and the vaccine list. Schedules can be edited by the individual to know of their
schedule, and at the same time, you can input your preferred vaccine location site. You can also
38
g. Database Design
Figure 3.8 shows the list of scheduled individuals information that they inputted in
the form in the system. Basic Information like firstname, middlename, lastname,
and etc.
Figure 3.9 shows the information about the individual based on their individual_id,
meta_field and date_created. It will gather the information that was inputted in the
form by an individual.
39
Figure 3.10 location
Figure 3.10 shows the list of location for vaccination that was created by the admin.
Figure 3.11 shows the list of scheduled individuals in the system. This will identify
the patient or individuals scheduled based on date scheduled and by status 0 means
40
Figure 3.12 system_info
Figure 3.12 shows the system information about the system. Like the name of the
Figure 3.13 shows the users list that can manage the system.
Figure 3.14 shows the vaccine history list to verify if the code of a patient does exist
in the database.
41
Figure 3.15 vaccine_list
Figure 3.15 shows the vaccine list that are listed in the database.
h. Data Dictionary
individuals
42
individual_meta
location
schedules
43
system_info
users
44
vaccine_history_list
vaccine_list
45
i. System Storyboard
Website
This is the index for patients/users to schedule their specific date of vaccination. Also, you can
select (left to right) Home, About, and Admin Login. This will also be the homepage of our
website.
46
Figure 3.17 About page
This index is to only show the about information about the system.
In the figure users must fill up the form to be able to submit their chosen schedule. All textfields
must be filled-up to be able to proceed to get the code that will be used for your vaccination.
47
Figure 3.19 Code Generator Form
After submitting the schedule, a form will pop out and auto generated code with your name will
be shown.
As shown in the figure above it will let the admin login to the website. To check specific
information about the vaccination sites, vaccine available, and scheduled patient.
If the admin pressed the I forgot the password button they will be redirected to the index shown
above.
48
Figure 3.22 Reset Password Page
In the figure above after the admin clicked the link that was sent into his email address this index
After the login the admin will be redirected to his account. They can view the dashboard and
checked the available slots and how many are scheduled on a specific location and date.
49
Figure 3.24 Individual list
This will show the scheduled individuals list. Admin can view and delete a record if it’s due to
their specified schedule and if the patient is not present on the day of the schedule.
This will show the information about the individual or patient that was scheduled. It will show if
the patient/individual are partially vaccinated or fully vaccinated. This can also be converted into
pdf file which individuals/patient can use for their 2nd dose and booster shots.
50
Figure 3.26 Vaccination Details List
This will show the information on when does the 1st dose and 2nd dose of vaccine took place and,
admin can print the information in the view’s tab. Admin/staff must create a new record for 1st
dose, 2nd dose, and booster shots for the individuals vaccination history to be updated.
This tab will be for verification if the individual has the code they can present, and the admin
This will show the vaccines that are available based on the status. Admin can edit or delete a
Admin can add new vaccine name and status if the vaccines are available or not. To be shown in
52
Figure 3.30 Location List
This will show the vaccination location that admin can create, edit, delete specific location they
want.
Admin can add new location, description, maximum individual per day, and status to be shown
53
Figure 3.32 Locator
The figure shown above is a tracker where admin can search an individual by typing they’re
specific address.
The figure above shows my accounts tab wherein admin can edit they’re information. All
information can be updated like username, email, and password for security.
54
3.5.System Development Plan
Project Planning
Phase
Analysis Phase
Design Phase
Implementation
Phase
Maintenance
Phase
In figure 3.34 the system development cycle was used so it very easy to understand and very
straight forward. The first phase which is the project planning phase. All possible means for design
and functionalities are discussed. Second phase analysis the gathered information and data about
the vaccination sites are being monitored within their homes. In the third phase which is the design
phase this is where designing of the system takes place also the specification needed. The fourth
phase is the implementation phase is where testing phase are being done to test if the system has
a. Test Plan
The test plan for the Web based Scheduling System is through accessing the website and
login to the website itself. The function of each module is to specify the main objectives in the
researchers’ website. Then joining the outcomes with the cooperation of the final assessment and
Hardware Components
Web-based System
Admin Module Input and Output Test and Check the website and its
the module.
56
b. Test Case Document
Hardware Test
Test Case Test Case Test Case Steps Test Case Expected Results Actual Pass/Fai
main will be
website. live.
57
Web-based Test
Test Case Test Case Test Case Steps Test Case Expected Results Actual Pass/Fai
the XAMPP
in admin 2. Go to
module. Admin
Login.
3. Fill the
required
fields.
c. Evaluation Plan
In the year of 2022, the pandemic is still increasing with the cases and it won’t stop
until the cure of the virus has been spread around the area of Caloocan. And today in the
Philippines, the cases have been skyrocketed due to some gathering in some Filipinos and due to
also alert level 2, which is less strict than the other days. Of course, the vaccination sites are also
being ready around the country to control the increasing number of cases. But the problem is the
manual signing up the detailed information in a sheet of paper and ballpen. We are avoiding to use
58
this to prevent the face to face contact with each other, even if you are wearing facemask or face
shield.
This Web based Scheduling System is used to set your schedule and to find your
appropriate vaccination site and make a choice for your preferred vaccine. All you have to do is
login in the website, set your vaccination schedule, pick your preferred vaccine, and confirm your
appointment. This kind of technology will help most of us in setting up a schedule, and the best
d. Deployment plan
appoint and find the nearest vaccination site around of the user. The next is to release the website
to the target audience to determine if the website meets the researcher feedbacks and the web
developers will fix errors before the official release of the website.
59
e. Deployment Process
A
Start
Deploy
Adapt Website
Plan
Study the area and analyze the process
Validate
Check for errors and review process
Prepare
Configure the Website
Manage
Maintain the Website
The figure above shows the preparation to creating the system and how they can prevent
60
f. Technical, Operational, and Economic Feasibility
Technical
The Researchers have developed and have maximized the effectiveness of the insert, edit, delete,
and with addition of scheduling calendar. Technical expertise is not a problem since there are
already in some local governments. For testing the website is based on the feedback of the user to
Operational
The website is designed by users for scheduling and a convenient finding a nearest vaccination
sites. The Continual feedback of its users is needed for the development of the website for the
Economic
As a student based webiste development, the researchers found out that the scheduling website can
help then country by raising the number of vaccinated per day and to prevent the over populated
in the vaccination sites. The Website are accesible for anyone most specifically patient that wants
61
CHAPTER 4
This chapter presents the data gathered the results of the statistical analysis done and interpretation
of findings. These are presented in tables following the research with the specific problem with
reference to iVacTrack: A Web- based Scheduling System for Covid-19 Vaccination Sites with
Profile of Respondents
Table 4.1
Age. Table 1 presents the frequency and percent distribution of the respondents according
to age.
Age f Percentage
TOTAL 65 100%
This table shows that 65 respondents, most of the respondents are coming from the 18 years old to
23 years old that has a total mean of 48 with the 73.85% while 23.08% came from the 24 years old
62
to 30 years old from the total mean of 12, 1.54% each from 31 years old up to 37 years old and 37
Table 4.2
Gender. The table shows the distribution of gender between male and female.
Gender f Percentage
Female 37 56.92%
Male 28 43.08%
TOTAL 65 100%
This table shows that out of 65 respondents, most of the respondents are female that has a total
mean of 37 and the percentage of 56.92% while the male has a total mean of 28 and the percentage
of 43.08%.
63
Table 4.3
Educational Attainment
The table shows the percentage and the distribution of each respondent according to their
educational attainment.
Undergraduate 47 72.31%
TOTAL 65 100%
This table shows that out of 65 respondents, most of the respondents are undergraduate that has a
total mean of 47 and a percentage of 72.31% followed by the bachelor's degree that has a total
mean of 12 and a percentage of 18.46%. While the High school graduate has a total mean of 4 and
a percentage of 6.15% and the master’s degree that has a mean of 1 and a percentage of 1.54%.
Lastly, with the mean of 1, the Doctor of Medicine (M.D.) has a percentage of 1.54%.
64
Table 4.4
Nature of Work
The table shows the percentage and the distribution of each respondent according to their nature
of work.
Category f Percentage
Education 30 46.15%
IT Expert 8 12.31%
Science 4 6.15%
Healthcare 4 6.15%
Travel 4 6.15%
Student 3 4.62%
Government 3 4.62%
Instructor 1 1.54%
Retail 1 1.54%
Telecommunications 1 1.54%
TOTAL 65 100%
This table shows that the most number of respondents’ nature of work is the Education. The
Education has a mean of 30 and with a percentage of 46.15%. Followed by the IT Experts, with
65
the mean of 8 and the percentage of 12.31. The categories Science, Healthcare, and Travel have
the same mean of 4 and as well as the same percentage of 6.15% each. Call Center, Student, and
Government categories have also the same mean of 3 and the percentage of 4.62% each. Human
Resource is also one of the category that isn’t has the same results as other categories. Human
Resource has a mean of 2 and the percentage of 3.08%. Four categories such as Instructor, Retail,
Real Estate, and Telecommunications, have the same mean of 1 and also the each percentage of
1.54%.
Table 4.5
The table shows that the Functionality in the system is proven to be very good, in terms of the
shows a verbal interpretation of Excellent with a mean of 4.84, the indicator “Accurateness” shows
a verbal interpretation of Very Good and a mean of 4.04, and lastly the indicator “Interoperability”
shows a verbal interpretation of Very Good, as well, and a mean of 4. The total of the mean with
As indicated in the table that all of its three indicators shown “Very Good”. Free from errors has a
mean of 4.10 and shows the verbal interpretation of Very Good, Amendable has a mean of 3.81
and shows the verbal interpretation of Very Good, and Attainability shows the mean of 3.92 and
shows the verbal interpretation of Very Good. The total mean of the three indicators is 3.94. It
67
Table 4.7
The table shows that the indicators of Understandability, Learnability, and Operability shows a
“Very Good” interpretation, with their means of 4.26, 4.06, 3.70, respectively and a total of 4.01
percentage of the three. This means that the Web based Scheduling System proves that it is very
convenient to use.
68
Table 4.8
The table shows the Very Good interpretation with these 3 indicators such as Time Behavior,
Resource Behavior, Intended Outcomes. The indicator “Time Behavior” shows the mean of 4.27,
the indicator “Resource Behavior” shows a mean of 4.04, and the indicator “Intended Outcomes”
shows the mean of 4, with the total mean of 4.10 and with a Very Good result. It means that the
69
Table 4.9
As indicated in the table, all the indicators show Very Good interpretation. The Analysis has a
mean of 4.16 and a “Very Good” verbal interpretation, Changeability has a mean of 4.18 as well,
and verbal interpretation of “Very Good”, Stability has a mean of 4 with a verbal interpretation of
“Very Good”, and Testability has mean of 3.83 and shows the verbal interpretation of “Very
Good”. This means that the Scheduling System has a very good maintain to deal with.
70
Table 4.10
As indicated in the table, all the indicators have proven to be Very Good. The indicator
“Adaptability” shows a mean of 4.35 and a Very Good interpretation, the indicator “Installation”
shows a mean of 4.27 and a Very Good interpretation, the indicator “Conformance” shows a mean
of 4.07 and a Very Good interpretation, and lastly, the indicator “Replaceability” shows a mean of
4.10 and a Very Good interpretation. With the total of 4.20 mean, the indicators Adaptability,
Installation, Conformance, Replaceability has proven to be very good score to each other. This
71
Table 4.11
The table shows that all the indicators are proven to be Very Good interpretation. Functionality
has a total mean of 4.29 and a Very Good interpretation, Reliability has a total mean of 3.94 and a
Very Good interpretation, Usability has a total mean of 4.01 and a Very Good interpretation,
Efficiency has a total mean of 4.10 and a Very Good interpretation, Maintainability has a total
mean of 4.06 and a Very Good interpretation, and Portability has a total mean of 4.20 and a Very
Good interpretation. With the total mean of 4.10, it means that the feedback from the respondents
72
CHAPTER 5
5.1. SUMMARY
The iVacTrack: A Web- based Scheduling System for Covid-19 Vaccination Sites with
Patient Tracking Through Geo-mapping had proven the system can be used for all the people who
wants to make an or schedule for their vaccines in their preferred vaccination sites. Users will login
The system will provide the different types of vaccines that they would like to take, also
their specific vaccination sites, and their preferred date of their schedule.
5.2. CONCLUSION
Based on the research questions and the results of the development and analysis, the
2. The proposed system met the needs for the user to analyze the system.
3. The proposed system answered the problems encountered by patient that scheduled their
73
5.3. RECOMMENDATION
The iVacTrack: A Web- based Scheduling System for Covid-19 Vaccination Sites with
Patient Tracking Through Geo-mapping recommend some plans in the future such as putting the
specific street or municipality on the address part and needs more improvement for awareness.
Also, the researchers recommend having more validations, like locating options since its
Lastly, the researchers recommend including descriptions on some parts of the system to
provide user the needed information. Additional recommendations like renaming and changing
74
APPENDICES
A. REFERENCES:
Agustin, L., Agustin, L. F., Kevin Losito, J. A., Mendoza, A. R., & Factoriza, A. T. (2018).
PREDICTIVE ANALYTICS IMPLEMENTING GENETIC ALGORITHM ON CLASS
SCHEDULING SYSTEM. International Journal of Advanced Research in Computer
Science. https://doi.org/10.26483/ijarcs.v9i6.6333
Alipour-Vaezi, M., … R. T.-M.-J. of I., & 2022, undefined. (2021). Scheduling the COVID-19
vaccine distribution based on data-driven decision-making methods. Jiems.Icms.Ac.Ir, 8(2),
196–206. https://doi.org/10.22116/JIEMS.2022.138130
Balbin, J. R., Jr., C. F. O., Fernando, R. F., Hernandez, J. J. V., & Jose, R. Y. Z. S. (2021). Local
Instrument with Geo-Tagging for Area Storm Surges (LIGTASS): a detection and
monitoring system for marine vessels. Https://Doi.Org/10.1117/12.2605060, 11913, 52–56.
https://doi.org/10.1117/12.2605060
Benedict, J., Legaspi, C., De Angel, R. M., Lagman, A. C., Heland, J., & Ortega, J. C. (2020).
Web based Course Scheduling System using Greedy Algorithm. Ijssst.Info.
https://doi.org/10.5013/IJSSST.a.20.S2.14
Carbajo, L., Publica, A. J.-R. E. de S., & 2021, undefined. (2021). Public funding impact of the
pneumococcal vaccine on compliance with the vaccination schedule. Europepmc.Org.
https://europepmc.org/article/med/34259229
Centers for Disease Control and, P. (2021). Guidance for Vaccinating Older Adults and People
with Disabilities at Vaccination Sites. https://www.cdc.gov/vaccines/covid-19/clinical-
considerations/older-adults-and-disability.html
Chen, H., Yang, B., Pei, H., Access, J. L.-I., & 2018, undefined. (2018). Next generation
technology for epidemic prevention and control: data-driven contact tracking.
Ieeexplore.Ieee.Org. https://ieeexplore.ieee.org/abstract/document/8587238/
Cox, J. F., & Boyd, L. H. (2020). Using the theory of constraints’ processes of ongoing
improvement to address the provider appointment scheduling system design problem.
Health Systems, 9(2), 124–158. https://doi.org/10.1080/20476965.2018.1471439
García-Serrano, C., Mirada, G., Marsal, J. R., Ortega, M., Sol, J., Solano, R., Artigues, E. M., &
Estany, P. (2020). Compliance with the guidelines on recommended immunization schedule
in patients with inflammatory bowel disease: Implications on public health policies. BMC
Public Health, 20(1). https://doi.org/10.1186/S12889-020-08850-Y
Gilca, V., Salmerón-Castro, J., Sauvageau, C., Vaccine, G. O.-, & 2018, undefined. (2018).
Early use of the HPV 2-dose vaccination schedule: Leveraging evidence to support policy
for accelerated impact. Elsevier.
https://www.sciencedirect.com/science/article/pii/S0264410X18301683
Hekmati, A., … G. R.-2021 I., & 2021, undefined. (2021). CONTAIN: Privacy-oriented contact
tracing protocols for epidemics. Ieeexplore.Ieee.Org.
75
https://ieeexplore.ieee.org/abstract/document/9464051/
Jr, J. Y., Simulation--Systems, P. M.-J. of, & S., & 2019, undefined. (2019). A Mobile
Application of a Geo-map Informatics Blast for Emergency Response. Ijssst.Info.
https://doi.org/10.5013/IJSSST.a.20.S2.17
Kirstein, J., Douglas, W., Thakur, M., Boaz, M., Papa, T., Skipetrova, A., & Plennevaux, E.
(2018). Immunogenicity of the CYD tetravalent dengue vaccine using an accelerated
schedule: randomised phase II study in US adults. BMC Infectious Diseases, 18(1).
https://doi.org/10.1186/S12879-018-3389-X
Kleinman, R., CMAJ, C. M.-, & 2020, undefined. (2020). Digital contact tracing for COVID-19.
Can Med Assoc. https://www.cmaj.ca/content/192/24/E653.short
Kourkounti, S., Retsas, T., Paparizos, V., Vaccine, A. T.-, & 2018, undefined. (2018).
Evaluation of a convenient vaccination schedule against hepatitis B in HIV-patients with
undetectable HIV viral load. Elsevier.
https://www.sciencedirect.com/science/article/pii/S0264410X18301920
May, A., Wilson, G., & Pym, A. (2019). Development of geo-tagging video app to assist road
development projects in the Philippines. Proceedings of the Institution of Civil Engineers:
Transport, 172(2), 94–101. https://doi.org/10.1680/JTRAN.16.00150
McCall, M., … M. S.-I. J. of E., & 2021, undefined. (2021). Surveillance in the COVID-19
normal: Tracking, tracing, and snooping–trade-offs in safety and autonomy in the e-city.
Igi-Global.Com, 10(2). https://doi.org/10.4018/IJEPR.20210401.oa3
Mendoza, S., Padpad, R., Vael, A., … C. A.-W. C. on, & 2018, undefined. (2018). A web-based
“InstaSked” appointment scheduling system at perpetual help medical center outpatient
department. Springer. https://doi.org/10.1007/978-3-030-20904-9_7
Nabong, A., … A. C.-S. S., & 2020, undefined. (2020). Hire a Service App: An Android-based
Home Service Mobile Application with Geomapping using Dijkstra’s Algorithm.
Solidstatetechnology.Us. http://solidstatetechnology.us/index.php/JSST/article/view/1137
Pierce, J., Harrington, K., McCabe, M., place, L. P.-H. &, & 2021, undefined. (2021).
Racial/ethnic minority and neighborhood disadvantage leads to disproportionate mortality
burden and years of potential life lost due to COVID-19 in Chicago, Illinois. Elsevier.
https://www.sciencedirect.com/science/article/pii/S1353829221000368
Popa, X., García, B., Fuentes, K. P., Huerta, V., Alvarez, K., Viada, C. E., Neninger, E.,
Rodríguez, P. C., González, Z., González, A., Crombet, T., & Mazorra, Z. (2020). Anti-
EGF antibodies as surrogate biomarkers of clinical efficacy in stage IIIB/IV non-small-cell
lung cancer patients treated with an optimized CIMAvax-EGF vaccination. Taylor &
Francis, 9(1). https://doi.org/10.1080/2162402X.2020.1762465
Sanchez, K., … J. P.-2019 2nd I., & 2019, undefined. (2019). RECall: A Scheduling System and
Question Answering System with User Knowledge Base on a Mobile Application for
Remembering and Recovering information. Ieeexplore.Ieee.Org.
https://ieeexplore.ieee.org/abstract/document/8726896/
Silva, A., Lima, E., … M. C.-R. de S., & 2018, undefined. (2018). Compliance with the
76
vaccination schedule in children hospitalized with pneumonia and associated factors.
SciELO Brasil.
https://www.scielo.br/j/rsp/a/4WKwrzdTbGcXpSKXhs9fq3x/?lang=en&format=html
Talosig, E., Adriatico, C., Journal, F. Y.-O. A. L., & 2019, undefined. (2019). Profiling and
Geo-Tagging of Rubber Tree Plantation through Geographic Information System.
Scirp.Org. https://www.scirp.org/journal/paperinformation.aspx?paperid=93882
Tingzon, I., Orden, A., Sy, S., Sekara, V., Weber, I., Fatehkia, M., Garcia Herranz, M., & Kim,
D. (2020). Mapping poverty in the Philippines using machine learning, satellite imagery,
and crowd-sourced geospatial information. Pdfs.Semanticscholar.Org.
https://pdfs.semanticscholar.org/9d96/bbd1bab6f66015096336052bd86662e14c6d.pdf
Xiong, L., Shahabi, C., Da, Y., Ahuja, R., Hertzberg, V., Waller, L., Jiang, X., & Franklin, A.
(2020). REACT: Real-time contact tracing and risk monitoring using privacy-enhanced
mobile tracking. Dl.Acm.Org. https://dl.acm.org/doi/abs/10.1145/3431843.3431845
Zelianskaia, N., Belousov, K., Heliyon, T. G.-, & 2020, undefined. (2020). Naive geography:
geoconceptology and topology of geomental maps. Elsevier.
https://www.sciencedirect.com/science/article/pii/S2405844020324877
Zhou, S., Research, Q. Y.-C. & O., & 2019, undefined. (2019). Appointment scheduling for
multi-stage sequential service systems with stochastic service durations. Elsevier.
https://www.sciencedirect.com/science/article/pii/S0305054819301911
77
B. Gantt Chart
78
C. ISO 9126
EVALUATION
INSTRUMENT
79
D. Software Evaluation and Result Table
ISO 9126 Software (5) (4) (3) (2) (1) Total Mean Interpretation
Evaluation Criteria
1. FUNCTIONALITY
1.1 Functions required 32 21 4 2 0 59 4.84 Excellent
for the system are
implemented
(suitability)
1.2 Functionality 29 21 4 3 0 57 4.04 Very Good
accuracy is provided
(accurateness)
1.3 Ease of connecting 30 17 7 3 0 57 4.04 Very Good
with other systems is
provided
(interoperability)
2. RELIABILITY
2.1 Software is fault 25 24 10 0 1 59 4.10 Very Good
tolerant (free from
errors)
2.2 Modules and files 27 16 10 1 1 55 3.81 Very Good
are recoverable.
2.3 The modules are 28 18 8 1 1 56 3.92 Very Good
reliably compliant
3. USABILITY
3.1 Easy to operate 32 21 4 2 0 59 4.26 Very Good
(understandability)
3.2 Easy to remember 29 21 4 3 0 57 4.06 Very Good
(learnability)
3.3 Allows easy 26 17 7 3 0 53 3.70 Very Good
operation management
(operability)
4. EFFICIENCY
4.1 Provides good 32 20 5 3 0 60 4.27 Very Good
responses high
throughput (time
behavior)
4.2 Allows effective 30 17 9 1 0 57 4.04 Very Good
use of system resources
(resource behavior)
4.3 Did the program 27 22 5 3 0 57 4.0 Very Good
produce or contribute
to the intended
outcomes in the short,
medium and long
term?
80
5.
MAINTAINABILITY
5.1 Allows easy 25 28 4 3 0 60 4.17 Very Good
analysis of design
documents and
programs when a bug
is found.
5.2 Allows easy 27 25 6 1 0 63 4.18 Very Good
expansion and
modification of the
system (changeability)
5.3 Modification of the 24 25 6 3 1 63 4.0 Very Good
system does not affect
others (stability)
5.4 Laborious tests are 25 17 11 3 1 61 3.83 Very Good
not required after a
modification is made
(testability)
6. PORTABILITY
6.1 Provides flexible 39 14 4 2 0 63 4.35 Very Good
environment
(adaptability)
6.2 Providing easy 35 16 7 1 0 63 4.28 Very Good
installation work
(installability)
6.3 Complying with 26 24 7 1 0 62 4.1 Very Good
porting specifications
(conformance)
6.4 Allows easy 30 19 8 1 0 62 4.11 Very Good
replacement with other
software
(replaceability)
81
E. List of Tables
Table 3.2 Representation of Data Dictionary
individuals
individual_meta
location
82
schedules
system_info
users
83
vaccine_history_list
vaccine_list
Table 4.1
Age. Table 1 presents the frequency and percent distribution of the respondents according
to age.
Age f Percentage
84
24 – 30 years old 15 23.08%
TOTAL 65 100%
Table 4.2
Gender. The table shows the distribution of gender between male and female.
Gender f Percentage
Female 37 56.92%
Male 28 43.08%
TOTAL 65 100%
Table 4.3
Educational Attainment
The table shows the percentage and the distribution of each respondent according to their
educational attainment.
Undergraduate 47 72.31%
85
Bachelor’s Degree 12 18.46%
TOTAL 65 100%
Table 4.4
Nature of Work
The table shows the percentage and the distribution of each respondent according to their nature
of work.
Category f Percentage
Education 30 46.15%
IT Expert 8 12.31%
Science 4 6.15%
Healthcare 4 6.15%
Travel 4 6.15%
Student 3 4.62%
Government 3 4.62%
Instructor 1 1.54%
Retail 1 1.54%
86
Real Estate 1 1.54%
Telecommunications 1 1.54%
TOTAL 65 100%
Table 4.5
Table 4.6
87
TOTAL 3.94 VERY GOOD
Table 4.7
Table 4.8
88
Table 4.9
Table 4.10
Table 4.11
89
Functionality 4.29 Very Good
F. List of Figures
91
Individual/Patient Database
iVacTrack
Scheduling
System with
Patient Tracking
User/Admin
93
Individual/Patient Table Name
Id
Name
Code
schedules
id
individual_id
location_id
status
Users/admin
Id
Username
{ Fields
Password
Email
Vaccine_history_list
Id
Location System_info
User_id
Id Id
Individual_id
Location Meta_field Vaccine_list
Vaccine_id
Description Meta_value Id
Location_id
Vaccination_type Max_a_day Name
Vaccinated_by status
a. Activity Diagram
START 94
No
Yes
95
Number Code Database Display Website
User
1.2.Code validated
96
Figure 3.7 Entity Relationship Diagram
97
Figure 3.8 individuals
98
Figure 3.11 schedules
99
Figure 3.14 vaccine_history_list
Website
100
Figure 3.17 About page
101
Figure 3.20 Administrator
102
Figure 3.23 Dashboard
103
Figure 3.25 Individuals Details and Vaccination History
104
Figure 3.27 Create Vaccination History
105
Figure 3.29 Vaccine Create Form
106
Figure 3.31 Create Location Form
107
Figure 3.33 Edit User Information Page
Project Planning
Phase
Analysis Phase
Design Phase
Implementation
Phase
Maintenance
Phase
108
A
Start
Deploy
Adapt Website
Plan
Study the area and analyze the process
Validate
Check for errors and review process
Prepare
Configure the Website
Manage
Maintain the Website
109
G. Source Code
<?php
require_once('config.php');
$location_qry = $conn->query("SELECT * FROM `location` where id = ".$_GET['lid']);
if($location_qry->num_rows > 0){
foreach($location_qry->fetch_assoc() as $k => $v){
$meta[$k] = $v;
}
}
if(isset($meta['description']))
$meta['description'] = stripslashes(html_entity_decode($meta['description']));
?>
<style>
#uni_modal .modal-content>.modal-header,#uni_modal .modal-content>.modal-footer{
display:none;
}
#uni_modal .modal-body{
padding-top:0 !important;
}
#location_modal{
direction:rtl !important;
}
#location_modal>*{
direction:ltr !important;
}
</style>
<div class="modal-header border-0">
<button type="button" class="close" data-dismiss="modal"><i class="fa fa-
times"></i></button>
110
</div>
<div class="container-fluid">
<div class="row" id="location_modal">
<div class="col-6 border-left" id="frm-field">
<h3>Schedule Form: (<?php echo $_GET['d'] ?>)</h3>
<hr>
<form action="sentMail.php" id="schedule_form" method="post">
<input type="hidden" name="lid" value="<?php echo $_GET['lid'] ?>">
<input type="hidden" name="date_sched" value="<?php echo $_GET['d'] ?>">
<div class="form-group">
<label for="name" class="control-label">First Name</label>
<input type="text" class="form-control" name="fname" required>
</div>
<div class="form-group">
<label for="name" class="control-label">Middle Name</label>
<input type="text" class="form-control" name="mname" required>
</div>
<div class="form-group">
<label for="name" class="control-label">Last Name</label>
<input type="text" class="form-control" name="lname" required>
</div>
<div class="form-group">
<label for="contact" class="control-label">Contact</label>
<input type="text" class="form-control" name="contact" required>
</div>
<div class="form-group">
<label for="contact" class="control-label">Email Address</label>
<input type="email" class="form-control" name="email" required>
111
</div>
<div class="form-group">
<label for="gender" class="control-label">Gender</label>
<select type="text" class="custom-select" name="gender" required>
<option>Male</option>
<option>Female</option>
</select>
</div>
<div class="form-group">
<label for="dob" class="control-label">Date of Birth</label>
<input type="date" class="form-control" name="dob" required>
</div>
<div class="form-group">
<label for="address" class="control-label">Address</label>
<textarea class="form-control" name="address" rows="3" required></textarea>
</div>
<div class="form-group d-flex justify-content-end">
<button id="submit" name="submit" type="submit" class="btn-dark btn">Submit
Schedule</button>
</div>
</form>
</div>
<div class="col-6">
<p><b>Location: </b><?php echo $meta['location'] ?></p>
<hr class="border-primary">
<div><?php echo $meta['description'] ?></div>
</div>
</div>
</div>
112
<script>
$(function(){
$('#schedule_form').submit(function(e){
e.preventDefault();
var _this = $(this)
$('.err-msg').remove();
start_loader();
$.ajax({
url:_base_url_+"classes/Master.php?f=save_schedule",
data: new FormData($(this)[0]),
cache: false,
contentType: false,
processData: false,
method: 'POST',
type: 'POST',
dataType: 'json',
error:err=>{
console.log(err)
alert_toast("An error occured",'error');
end_loader();
},
success:function(resp){
if(typeof resp =='object' && resp.status == 'success'){
var fname = "<h4><b>"+resp.fname+"</b></h4>";
var code = "<h3><b>"+resp.code+"</b></h3>";
var ins = "<small><i>Copy or take a snapshot of the code below your name. The
code will serve as your ticlet number for vaccination schedule. Please bring atleast 1 ID to verify
your schedule information.</i></small>";
113
$('#frm-
field').html("<div>"+fname+code+ins+"</div>")
$('#frm-field').addClass("text-center d-flex justify-content-center align-items-
center")
<?php
?>
}else if(resp.status == 'failed' && !!resp.msg){
var el = $('<div>')
el.addClass("alert alert-danger err-msg").text(resp.msg)
_this.prepend(el)
el.show('slow')
$("html, body").animate({ scrollTop: $('#uni_modal').offset().top }, "fast");
}else{
alert_toast("An error occured",'error');
console.log(resp)
}
end_loader();
}
})
})
$('#uni_modal').on('hidden.bs.modal', function (e) {
if($('#schedule_form').length <= 0)
location.reload()
})
})
</script>
114
<Geolocate>
<?php
if(isset($_POST["submit_address"])){
$address = $_POST["address"];
?>
<?php
}
?>
<form method = "POST">
<p>
<center><input class = "control-label" type = "text" name = "address" placeholder
= "Enter Address">
</p>
<input class = "btn btn-flat btn-primary" type = "submit"
name="submit_address"></center>
</form>
<History>
<div class="card card-outline card-primary">
<div class="card-header">
<h3 class="card-title">Vaccination History</h3>
<div class="card-tools">
<a href="?page=history/manage_record" class="btn btn-flat btn-
primary"><span class="fas fa-plus"></span> Create New</a>
</div>
</div>
115
<div class="card-body">
<div class="container-fluid">
<div class="container-fluid">
<table class="table table-bordered table-striped">
<colgroup>
<col width="5%">
<col width="20%">
<col width="25%">
<col width="25%">
<col width="15%">
<col width="10%">
</colgroup>
<thead>
<tr>
<th>#</th>
<th>Date Created</th>
<th>Individual</th>
<th>Vaccination Info</th>
<th>Encoder</th>
<th>Action</th>
</tr>
</thead>
<tbody>
<?php
$i = 1;
$where = "";
if($_settings->userdata('type') != 1){
$where = " where h.location_id =
'{$_settings->userdata('location_id')}'";
116
}
$users = $conn->query("SELECT * FROM users");
$result = $users->fetch_all(MYSQLI_ASSOC);
$user_arr = array_column($result,'username','id');
$vaccine = $conn->query("SELECT * FROM
vaccine_list");
$vresult = $vaccine->fetch_all(MYSQLI_ASSOC);
$vax_arr = array_column($vresult,'name','id');
$qry = $conn->query("SELECT
h.*,concat(i.lname,', ',i.fname,' ', i.mname) as iname,i.code FROM `vaccine_history_list` h inner
join individuals i on h.individual_id = i.id {$where} order by unix_timestamp(h.date_created)
desc");
while($row = $qry->fetch_assoc()):
?>
<tr>
<td class="text-center py-1 px-2"><?php
echo $i++; ?></td>
<td class="py-1 px-1"><?php echo date("M
d,Y",strtotime($row['date_created'])) ; ?></td>
<td class="py-1 px-2">
<small><span class="text-
muted">Code:</span> <b><?php echo $row['code'] ?></b></small> <br>
<small><span class="text-
muted">Name:</span> <b><?php echo $row['iname'] ?></b></small>
</td>
<td class="py-1 px-2">
<small><span class="text-
muted">Vaccine:</span> <b><?php echo isset($vax_arr[$row['vaccine_id']]) ?
$vax_arr[$row['vaccine_id']] : 'Vaccine was Deleted' ; ?></b></small> <br>
<small><span class="text-
muted">Type:</span> <b><?php echo $row['vaccination_type'] ?></b></small>
</td>
117
<td class=""><?php echo
isset($user_arr[$row['user_id']]) ? $user_arr[$row['user_id']] : 'User was Deleted' ; ?></td>
<td align="center">
<button type="button" class="btn
btn-flat btn-default btn-sm dropdown-toggle dropdown-icon" data-toggle="dropdown">
Action
<span class="sr-only">Toggle Dropdown</span>
</button>
<div class="dropdown-menu" role="menu">
<a class="dropdown-item"
href="./?page=history/view_details&id=<?php echo $row['id'] ?>" data-id="<?php echo
$row['id'] ?>"><span class="fa fa-info-circle text-primary"></span> View</a>
<div class="dropdown-divider"></div>
<a class="dropdown-item"
href="?page=history/manage_record&id=<?php echo $row['id'] ?>"><span class="fa fa-edit
text-primary"></span> Edit</a>
<div class="dropdown-divider"></div>
<a class="dropdown-item delete_data"
href="javascript:void(0)" data-id="<?php echo $row['id'] ?>"><span class="fa fa-trash text-
danger"></span> Delete</a>
</div>
</td>
</tr>
<?php endwhile; ?>
</tbody>
</table>
</div>
</div>
</div>
</div>
<script>
118
$(document).ready(function(){
$('.delete_data').click(function(){
_conf("Are you sure to delete this Vaccination Record
permanently?","delete_history",[$(this).attr('data-id')])
})
$('.table td,.table th').addClass('py-1 px-2 align-middle')
$('.table').dataTable();
})
function delete_history($id){
start_loader();
$.ajax({
url:_base_url_+"classes/Master.php?f=delete_history",
method:"POST",
data:{id: $id},
dataType:"json",
error:err=>{
console.log(err)
alert_toast("An error occured.",'error');
end_loader();
},
success:function(resp){
if(typeof resp== 'object' && resp.status == 'success'){
location.reload();
}else{
alert_toast("An error occured.",'error');
end_loader();
}
}
})
119
}
</script>
<individuals>
<?php if($_settings->chk_flashdata('success')): ?>
<script>
alert_toast("<?php echo $_settings->flashdata('success') ?>",'success')
</script>
<?php endif;?>
<style>
#selectAll{
top:0
}
</style>
<div class="card card-outline card-primary">
<div class="card-header">
<h3 class="card-title">List of Individual</h3>
<!-- <div class="card-tools">
<a href="?page=individual/manage_individual" class="btn btn-flat btn-
primary"><span class="fas fa-plus"></span> Create New</a>
</div> -->
</div>
<div class="card-body">
<div class="container-fluid">
<div class="row" style="display:none" id="selected_opt">
<div class="w-100 d-flex">
<div class="col-2">
<label for="" class="controllabel"> With
Selected:</label>
120
</div>
<div class="col-3">
<select id="w_selected" class="custom-select
select" >
<option value="partial">Mark as Partially
Vaccinated</option>
<option value="full">Mark as Fully
Vaccinated</option>
<option value="delete">Delete</option>
</select>
</div>
<div class="col">
<button class="btn btn-primary" type="button"
id="selected_go">Go</button>
</div>
</div>
</div>
<table class="table table-bordered table-stripped" id="indi-list">
<colgroup>
<col width="5%">
<col width="5%">
<col width="10%">
<col width="20%">
<col width="15%">
<col width="25%">
<col width="10%">
<col width="10%">
</colgroup>
<thead>
<tr>
121
<td class="text-center"><div class="form-check">
<input type="checkbox" class="form-check-
input" id="selectAll">
</div></td>
<th class="text-center">#</th>
<th>Code</th>
<th>First Name</th>
<th>Middle Initial</th>
<th>Last Name</th>
<th>Schedule</th>
<th>Location</th>
<th>Status</th>
<th>Action</th>
</tr>
</thead>
<tbody>
<?php
$i = 1;
$qry = $conn->query("SELECT
i.*,s.date_sched,s.status,l.`location` from `individuals` i inner join `schedules` s on i.id =
s.individual_id inner join `location` l on l.id = s.location_id order by
unix_timestamp(s.date_sched) desc ");
while($row = $qry->fetch_assoc()):
?>
<tr>
<td class="text-center">
<div class="form-check">
<input type="checkbox"
class="form-check-input invCheck" value="<?php echo $row['id'] ?>">
</div>
122
</td>
<td class="text-center"><?php echo $i++;
?></td>
<td><?php echo $row['code'] ?></td>
<td><?php echo $row['fname'] ?></td>
<td><?php echo $row['mname'] ?></td>
<td><?php echo $row['lname'] ?></td>
<td><?php echo $row['date_sched'] ?></td>
<td class=""><p class='m-0'><?php echo
$row['location'] ?></p></td>
<td class="text-center">
<?php if($row['status'] == 1): ?>
<span class="badge badge-primary rounded-pill">Partially
Vaccinated</span>
<?php elseif($row['status'] == 2): ?>
<span class="badge badge-success rounded-pill">Fully
Vaccinated</span>
<?php else: ?>
<span class="badge badge-light text-dark rounded-pill">Pending</span>
<?php endif; ?>
</td>
<td align="center">
<button type="button" class="btn
btn-flat btn-default btn-sm dropdown-toggle dropdown-icon" data-toggle="dropdown">
Action
<span class="sr-only">Toggle Dropdown</span>
</button>
<div class="dropdown-menu" role="menu">
<a class="dropdown-item"
href="?page=individual/view_details&id=<?php echo $row['id'] ?>"><span class="fa fa-eye
text-light"></span> View</a>
123
</div>
</td>
</td>
</tr>
<?php endwhile; ?>
</tbody>
</table>
</div>
</div>
</div>
<script>
var indiList;
$(document).ready(function(){
$('.view_data').click(function(){
uni_modal("Indiviual
Details","individual/view_details.php?code="+$(this).attr('data-id'))
})
$('#selectAll').change(function(){
// if($(this).is(":checked") == true){
// $('.invCheck').prop("checked",true)
// }else{
// $('.invCheck').prop("checked",false)
// }
var _this = $(this)
count = indiList.api().rows().data().length
for($i = 0 ; $i < count; $i++){
var node = indiList.api().row($i).node()
console.log($(node).find('.invCheck'))
if(_this.is(":checked") == true){
124
$(node).find('.invCheck').prop("checked",true)
$('#selected_opt').show('slow')
}else{
$(node).find('.invCheck').prop("checked",false)
$('#selected_opt').hide('slow')
}
}
})
})
$(function(){
indiList = $('#indi-list').dataTable({
columnDefs:[{
targets:[0,7],
orderable:false
}],
order:[[1,'asc']],
});
// console.log(indiList)
$(indiList.fnGetNodes()).find('.invCheck').change(function(){
if($(this).is(":checked")==true){
if($('#selected_opt').is(':visible') == false){
$('#selected_opt').show('slow')
}
}else{
if($(indiList.fnGetNodes()).find('.invCheck:checked').length <=
0){
if($('#selected_opt').is(':visible') == true){
125
$('#selected_opt').hide('slow')
}
}
}
if($(indiList.fnGetNodes()).find('.invCheck:checked').length ==
$(indiList.fnGetNodes()).find('.invCheck').length){
$('#selectAll').prop('checked',true)
}else if($(indiList.fnGetNodes()).find('.invCheck:checked').length <= 0){
$('#selectAll').prop('checked',false)
}else{
$('#selectAll').prop('checked',false)
}
})
$('#selected_go').click(function(){
start_loader();
var ids = [];
$(indiList.fnGetNodes()).find('.invCheck:checked').each(function(){
ids.push($(this).val())
})
var _action = $('#w_selected').val()
$.ajax({
url:_base_url_+'classes/Master.php?f=multiple_action',
method:"POST",
data:{ids:ids,_action:_action},
dataType:'json',
error:err=>{
console.log(err)
alert_toast("An error occured",'error');
126
end_loader();
},
success:function(resp){
if(typeof resp =='object' && resp.status == 'success'){
location.reload();
}else if(resp.status == 'failed' && !!resp.msg){
alert_toast(resp.msg,'error');
end_loader()
}else{
alert_toast("An error occured",'error');
end_loader();
console.log(resp)
}
}
})
})
})
</script>
127
<div class="card-tools">
<a href="?page=location/manage_location" class="btn btn-flat btn-
primary"><span class="fas fa-plus"></span> Create New</a>
</div>
</div>
<div class="card-body">
<div class="container-fluid">
<div class="container-fluid">
<table class="table table-bordered table-stripped">
<colgroup>
<col width="5%">
<col width="30%">
<col width="35%">
<col width="10%">
<col width="10%">
</colgroup>
<thead>
<tr>
<th>#</th>
<th>Location</th>
<th>Description</th>
<th>Max</th>
<th>Status</th>
<th>Action</th>
</tr>
</thead>
<tbody>
<?php
$i = 1;
128
$qry = $conn->query("SELECT * from `location`
order by `location` asc ");
while($row = $qry->fetch_assoc()):
$row['description'] =
strip_tags(stripslashes(html_entity_decode($row['description'])));
?>
<tr>
<td class="text-center"><?php echo $i++;
?></td>
<td><?php echo $row['location'] ?></td>
<td ><p class="truncate-1 m-0"><?php echo
$row['description'] ?></p></td>
<td class="text-center"><?php echo
number_format($row['max_a_day']) ?></td>
<td class="text-center">
<?php if($row['status'] == 1): ?>
<span class="badge badge-success">Active</span>
<?php else: ?>
<span class="badge badge-danger">Inactive</span>
<?php endif; ?>
</td>
<td align="center">
<button type="button" class="btn
btn-flat btn-default btn-sm dropdown-toggle dropdown-icon" data-toggle="dropdown">
Action
<span class="sr-only">Toggle Dropdown</span>
</button>
<div class="dropdown-menu" role="menu">
<a class="dropdown-item"
href="?page=location/manage_location&id=<?php echo $row['id'] ?>"><span class="fa fa-edit
text-primary"></span> Edit</a>
129
<div class="dropdown-divider"></div>
<a class="dropdown-item delete_data"
href="javascript:void(0)" data-id="<?php echo $row['id'] ?>"><span class="fa fa-trash text-
danger"></span> Delete</a>
</div>
</td>
</tr>
<?php endwhile; ?>
</tbody>
</table>
</div>
</div>
</div>
</div>
<script>
$(document).ready(function(){
$('.delete_data').click(function(){
_conf("Are you sure to delete this location
permanently?","delete_location",[$(this).attr('data-id')])
})
$('.table').dataTable();
})
function delete_location($id){
start_loader();
$.ajax({
url:_base_url_+"classes/Master.php?f=delete_location",
method:"POST",
data:{id: $id},
dataType:"json",
130
error:err=>{
console.log(err)
alert_toast("An error occured.",'error');
end_loader();
},
success:function(resp){
if(typeof resp== 'object' && resp.status == 'success'){
location.reload();
}else{
alert_toast("An error occured.",'error');
end_loader();
}
}
})
}
</script>
<script>
$(document).ready(function(){
window.viewer_modal = function($src = ''){
start_loader()
var t = $src.split('.')
t = t[1]
if(t =='mp4'){
var view = $("<video src='"+$src+"' controls autoplay></video>")
}else{
var view = $("<img src='"+$src+"' />")
}
$('#viewer_modal .modal-content video,#viewer_modal .modal-content img').remove()
131
$('#viewer_modal .modal-content').append(view)
$('#viewer_modal').modal({
show:true,
backdrop:'static',
keyboard:false,
focus:true
})
end_loader()
}
window.uni_modal = function($title = '' , $url='',$size=""){
start_loader()
$.ajax({
url:$url,
error:err=>{
console.log()
alert("An error occured")
},
success:function(resp){
if(resp){
$('#uni_modal .modal-title').html($title)
$('#uni_modal .modal-body').html(resp)
if($size != ''){
$('#uni_modal .modal-dialog').addClass($size+' modal-dialog-centered')
}else{
$('#uni_modal .modal-dialog').removeAttr("class").addClass("modal-dialog
modal-md modal-dialog-centered")
}
$('#uni_modal').modal({
132
show:true,
backdrop:'static',
keyboard:false,
focus:true
})
end_loader()
}
}
})
}
window._conf = function($msg='',$func='',$params = []){
$('#confirm_modal #confirm').attr('onclick',$func+"("+$params.join(',')+")")
$('#confirm_modal .modal-body').html($msg)
$('#confirm_modal').modal('show')
}
})
</script>
<footer class="main-footer text-sm">
<strong>Copyright © <?php echo date('Y') ?>.
<!-- <a href=""></a> -->
</strong>
All rights reserved.
<div class="float-right d-none d-sm-inline-block">
<b><?php echo $_settings->info('short_name') ?> (by: <a
href="mailto:sanguermartee@gmail.com" target="blank">itbankraze19</a> )</b> v1.5
</div>
</footer>
</div>
<!-- ./wrapper -->
133
<!-- Resolve conflict in jQuery UI tooltip with Bootstrap tooltip -->
<script>
$.widget.bridge('uibutton', $.ui.button)
</script>
<!-- Bootstrap 4 -->
<script src="<?php echo base_url ?>plugins/bootstrap/js/bootstrap.bundle.min.js"></script>
<!-- ChartJS -->
<script src="<?php echo base_url ?>plugins/chart.js/Chart.min.js"></script>
<!-- Sparkline -->
<script src="<?php echo base_url ?>plugins/sparklines/sparkline.js"></script>
<!-- Select2 -->
<script src="<?php echo base_url ?>plugins/select2/js/select2.full.min.js"></script>
<!-- JQVMap -->
<script src="<?php echo base_url ?>plugins/jqvmap/jquery.vmap.min.js"></script>
<script src="<?php echo base_url ?>plugins/jqvmap/maps/jquery.vmap.usa.js"></script>
<!-- jQuery Knob Chart -->
<script src="<?php echo base_url ?>plugins/jquery-knob/jquery.knob.min.js"></script>
<!-- daterangepicker -->
<script src="<?php echo base_url ?>plugins/moment/moment.min.js"></script>
<script src="<?php echo base_url ?>plugins/daterangepicker/daterangepicker.js"></script>
<!-- Tempusdominus Bootstrap 4 -->
<script src="<?php echo base_url ?>plugins/tempusdominus-bootstrap-4/js/tempusdominus-
bootstrap-4.min.js"></script>
<!-- Summernote -->
<script src="<?php echo base_url ?>plugins/summernote/summernote-bs4.min.js"></script>
<script src="<?php echo base_url ?>plugins/datatables/jquery.dataTables.min.js"></script>
<script src="<?php echo base_url ?>plugins/datatables-
bs4/js/dataTables.bootstrap4.min.js"></script>
134
<script src="<?php echo base_url ?>plugins/datatables-
responsive/js/dataTables.responsive.min.js"></script>
<script src="<?php echo base_url ?>plugins/datatables-
responsive/js/responsive.bootstrap4.min.js"></script>
<script src="<?php echo base_url ?>plugins/datatables-
select/js/select.bootstrap4.min.js"></script>
<!-- overlayScrollbars -->
<!-- <script src="<?php echo base_url
?>plugins/overlayScrollbars/js/jquery.overlayScrollbars.min.js"></script> -->
<!-- AdminLTE App -->
<script src="<?php echo base_url ?>dist/js/adminlte.js"></script>
<div class="daterangepicker ltr show-ranges opensright">
<div class="ranges">
<ul>
<li data-range-key="Today">Today</li>
<li data-range-key="Yesterday">Yesterday</li>
<li data-range-key="Last 7 Days">Last 7 Days</li>
<li data-range-key="Last 30 Days">Last 30 Days</li>
<li data-range-key="This Month">This Month</li>
<li data-range-key="Last Month">Last Month</li>
<li data-range-key="Custom Range">Custom Range</li>
</ul>
</div>
<div class="drp-calendar left">
<div class="calendar-table"></div>
<div class="calendar-time" style="display: none;"></div>
</div>
<div class="drp-calendar right">
<div class="calendar-table"></div>
<div class="calendar-time" style="display: none;"></div>
135
</div>
<div class="drp-buttons"><span class="drp-selected"></span><button class="cancelBtn btn
btn-sm btn-default" type="button">Cancel</button><button class="applyBtn btn btn-sm btn-
primary" disabled="disabled" type="button">Apply</button> </div>
</div>
<div class="jqvmap-label" style="display: none; left: 1093.83px; top:
394.361px;">Idaho</div>
136
H. Researchers Profile
Phone: (+63) 9453210887 632 B. Santos Street Isla San Juan Gagalangin
Martee.sanguer@lpunetwork.edu.ph Tondo Manila
Manila,
To obtain skills that I am still lacking and learn from it through different company to
experience competitive job trainings and make it as a motivation to hone skills. Through
the use of my experiences, I will continue to help and contribute to the company that I
will be working on.
Education
137
Professional Training
Seminar or Workshop
Sololearn – PHP Certificate
Sololearn – Java Programming Certificate
Languages
Computer Skills
It may be useful to provide a summary of your relevant skills, such as your computer
skills. You could list your skills using a consistent format such as
Other
References
138
CORTEZ, WILBERT WEBB R.
To obtain skills that I am still lacking and learn and make it as a motivation to hone skills. Using
my experiences, I will continue to help and contribute to the company that I will be working on
and can work under pressure.
Education
Professional Training
Seminar or Workshop
139
Name of Institution, Location, Date
Description: Include a brief description, if necessary.
Languages
Computer Skills
It may be useful to provide a summary of your relevant skills, such as your computer skills. You
could list your skills using a consistent format such as
Applications: Notepad++, eclipse, NetBeans, Dev C++, Microsoft PowerPoint, Microsoft Word
Other
Filipino Citizen
References
140
Phone: (+63) 9422687423 126 Aquino St. Sta. Quiteria
Paolo.noblado@lpunetwork.edu.ph Caloocan City
I am a punctual and motivated individual who is able to work in a busy environment and produce
high standards of work. I am an excellent team worker and am able to take instructions from all
levels and build up good working relationships with all colleagues. I am flexible, reliable and
possess excellent time keeping skills.
Education
Professional Training
CREOTEC Immersion
Creotec Company, Remedios St., Taft Ave, Malate, Manila, Metro Manila, Sept. 2017
Description: This course covers the orientation necessary for the preparation of the trainees for
their actual work assignments.
141
Languages
Computer Skills
It may be useful to provide a summary of your relevant skills, such as your computer skills. You
could list your skills using a consistent format such as
Other
Filipino Citizen
References
142