Covid-19 Individual Tracing Web Application with QR Code ID (PHP PDO Prepare Statement)

The purpose of this website is to help our country fight the covid-19 virus. So this website was made to have contact tracing by entering the personal information of an individual who visited or went to a public place or private establishment such as mall, grocery, fastfood, market and so on. By registering with this web application, it is able to generate a QR Code that is scanned by security personnel via mobile phone to identify who are the visitors to this place with the stated date and time. This will help to limit the possible spread of this virus in our country.

========Login Role(Different login section)========

-User

-Guard or whoever wants to be assigned to scan the QR Code.

-Admin

==============User Section===================

-Has its own registration for them only.

-It also has its own login part.

-And self -logout.

-when the user is logged in, he will see this part inside his dashboard.

Contact Tracing ID = This ID when he loses the ID he can still get it back through his account by using the login inside the dashboard there is still a duplicate ID of his left that can be re - printed/laminated.

Take Note: This ID of yours will be used at the entrances of the mall, grocery, building, bank or any department that is assigned to scan your QR code, for example the guard.

Covid-19 Updates = Here he can see what is the status of covid-19 in their area every day admin can post updates about covid-19 in its area and can also get news outside the area or country post.

About Us = Here you can see what this web application is about and how it can help our country or place.

My Profile = Here you can see your profile and you can also change your old password if you don't want it anymore and if someone already knows.

=====Guard or whoever wants to be assigned to scan the QR Code======

-It has its own login just for him.

-It has its own logout.

-It has its own dashboard where what can be seen here is the scan of the QR Code ID that will be used by the guard or whoever is assigned.

===========Admin Section==========

-It also has its own login part.

-And self -logout.

-when the Admin is logged in, he will see this part inside his dashboard.

Dashboard = The number of Members, Regions, Cities, Barangays, QR Code Scan Result, Logged History and banner image below can be seen immediately here when your admin login is successful.

Members = Here we can see in the table the members who have registered with our web application have the ability to view, edit, delete.

Regions = Here we can see in the table the Regions that we want to add there on the front page of the registration in the part region dropdown menu it also has the ability to view, edit, delete.

Cities = Here we can see in the table the Cities that we want to add there on the front page of the registration in the part City dropdown menu it also has the ability to view, edit, delete.

Barangay = Here we can see in the table the Barangays that we want to add there on the front page of the registration in the part Barangay dropdown menu it also has the ability to view, edit, delete.

Covid19 Updates = Admin can post daily updates about covid-19 and he can also post other news not only in their area but also about our country on covid status and his post can only be seen on wall of user member only.

QR Code Result = Its Content is Qr Code Ramdom letter and number to make each members' QR code unique.

Reports = Here we can filter using the date from and date to the scanned QR Code IDs placed here and with their info and you can print it in pdf, excel, csv, copy, print.

History logged = Here you will see in this table the list of those who logged in and logged out on the same day in the village you will also know here what IP, HOST NAME they used.

Authorized Personnel = Here we can see in this table if the lists of guard members are the only admin authorized to create their own account to be able to scan the entrances on the doors or whatever and who else is will be assigned to another.

Admin = It has the ability to add new admins for authorized and it also has the ability to view, edit, delete and control the entire admin dashboard.

My Profile = Here you can see your profile and you can also change your old password if you don't want it anymore and if someone already knows.

===========FRONT END===============

-HTML5

-CSS3

-MDBOOTSTRAP

-NATIVE JAVASCRIPT/ES6

-JQUERY AND OTHER IS PLUGIN

-JSON

===========BACK END===============

-PHP PDO(PREPARE STATEMENT)

-MYSQLI CLASS OOP FOR PRINT AREA ONLY

-SERVER SIDE TABLE.

-SQL QUERY

-HASH PASSWORD

===========FOR DATABASE================

- covid19_individualtracing.sql

-XAMPP(MARIADB) Version - 7.3 up 

Sourcecode: Not free sorry...

Please Watch this Complete tutorials: https://www.youtube.com/watch?v=PIQ0u_7YRaU

-It is not free the whole sourcecode if you want to buy it you can contact me here on my facebook account.

Facebook link: https://web.facebook.com/jonel.toledo.71/

 for price, please contact me.

-or smart number: 09991050748