- ProGeek, ProGeek 2021, Project, Web Technologies

Project Idea | Web app that facilitates easy discovery of crucial medicines in nearby pharmacy

Project Title : SehathIntroduction : Domain: HealthcarePurpose:Sehath is meant to be a web app that provides people with the help of finding crucial life-saving drugs such as Remdesivir in their nearby pharmacies as soon as it becomes available. We came up with the idea during the second wave of covid pandemic in India where the majority of the affected population struggled to find anti-viral drugs and medical oxygen cylinders. We, therefore, developed a web interface that provides people with a single point of information for the availability of covid as well as non-covid drugs in their nearby pharmacies.This app also allows people to register themselves as volunteers to help people who can’t move out of their homes to buy the drugs due to reasons such as quarantine.The app also serves the purpose of increasing the business of local pharmacies by enabling them to cater to the demand from their surrounding user base.Current Status: The project has been partially implemented.The detailed working of implemented components:1. Home Page: When the users access the public URL of the website they will be directed to the homepage which looks as below – HomepageAs seen above, the homepage has three points of entry: Public Page, Shopkeeper Page, and Volunteer Page.a) Public Page: This is the entry point to the Public.php page, where users will be able to search for the medicines according to the name of the medicine and the location in which they live. It works like below –In this page, the users can also request a volunteer. After clicking the button ‘Request Volunteer’, users will be provided with a form embedded in a modal. After filling in the details, an email will be sent to the volunteers who have registered themselves on the website. The below given image describes the form – Volunteer Request Formb) Shopkeeper Page: This is the entry point to the Shop Keeper login page. Here the local pharmacy owners can register an account and can list and manage their inventory. The shopkeeper dashboard will show all the available products as well as an option to edit existing items and add new items. It works like below –The registration page looks like this – Shopkeeper Registration Pagec) Volunteer Page: The volunteer page directs users to the volunteer registration page where people can sign up for volunteering for other people who are physically unable to get their own medicines due to reasons such as quarantine, bad health, etc. The process is displayed below –The database is updated as follows – Database snapshotComponents that will be incorporated in the future:Public Page: The functionality to the button ‘Alert Medicine’ will be implemented such that when users click on this button they can request to receive a notification about the availability of a particular medicine. For example, whenever the inventory of a shopkeeper is updated at least 10 times, then a notification will be sent out to the users if the changes made were in regard to the medicine that they requested.Shopkeeper Page: Mozilla’s barcode scanner API will be implemented to provide the shopkeepers with an automated inventory management system that they can use to quickly update their inventory database. They will also be provided with an option to upload a spreadsheet of their products for ease of populating their inventory database. This is being thought of because most of the pharmacies in India keep an Excel sheet for their product management instead of a dedicated database.Technologies Used:HTML/CSSPHPJavaScriptPHP MailerMySQL Bootstrap 5Any free hosting serviceDetailed technical explanation of the features implemented till date: The partially implemented website can be checked out at this link.Note: The GitHub repository of the project will soon be made available here once more changes are published.The components included are:Homepage.html and Homepage.css — This contains the three entry point buttons as well as the general style of the homepage.SHOPKEEPER_REGISTRATION.php and corresponding CSS file — This page contains the layout for the shopkeeper registration form and after successful registration, it redirects to the Shopkeeper_Login.php page.SHOPKEEPER_LOGIN.php and corresponding CSS file — This page contains the layout and functionality of the login page. After successful login, the user is redirected to the Shopkeeper_Main.php page.SHOPKEEPER_MAIN.php and corresponding CSS file — This page connects to the MySQL database to extract, add, delete or modify shopkeeper’s inventory.VOLUNTEER_REGISTRATION.php and corresponding CSS file — It connects with the MySQL database to store the registration information of volunteers on successful registration. This database will be used on Public.php page to send requests to volunteers if a request for medicine is made by the user.PUBLIC.php and corresponding CSS file — On this page, the functionality to search medicine according to name and location is implemented. An AJAX request is made to the items table in the MySQL database to retrieve the medicine. The medicines are displayed in the increasing order of distance. So this page also contains a distance algorithm implemented in JavaScript. This page also implements the functionality for the “Request Volunteer” and “Alert Medicine” buttons. When the “Request Volunteer” button is clicked, a form embedded in a Bootstrap5 modal will be displayed, and the form details will be sent to the volunteers as an email through Gmail’s SMTP server by using the PHP Mailer module.UML Diagrams: Object Diagram Actor DiagramTeam Members:Avhijit NairTaha Junaid