COVID-19 Hospital Bed Management System

An application which provides real-time statistics for COVID-19 bed availability status

Table of Contents

• Motivation
• Real-time bed availability status
• Gallery
• Tech Stack
• Functionalities
• To Do and Further Improvements
• Requirements
• Run Locally
• License
• Contributors

Motivation

During the COVID-19 pandemic, finding beds in hospitals was an uphill task and in order to assist patients in finding beds easily this app has been developed. The app allows users to easily view the current bed availability status (as provided by BBMP) and also previous trends for a given hospital/COVID Care Centre

Real-time bed availability status

The crux of this solution lies in collecting real-time bed availability status from BBMP. BBMP have currently stopped updating the statistics on their website, post the pandemic

Gallery

Home Page

About

Brief overview for a class of hospitals

Detailed statistics for a hospital

Login history

Light theme

Tech Stack

• Tkinter has been used for the front-end
• MySQL has been used as a back-end database server
• The application has been developed using Python

Functionalities

• Show real-time statistics for bed status in various hospitals
• Show various illustrative graphs
• Allow administrators to change the bed availbaility statuses

To Do and Further Improvements

• Using matplotlib, seaborn to plot trends for various hospitals
• Develop an app with light and dark themes
• Allow administrators to update the bed availability status
• Show trends for hospitals upto the date available in the database
• Updating the size of the hospital overview graphs

Requirements

The following dependencies and modules (python) are required, to run this locally

• SQLAlchemy==1.4.41
• pyplot-themes==0.2.2
• matplotlib==3.5.3
• pillow==9.2.0
• pandas==1.5.0
• lxml==4.9.1
• progressbar==2.5
• seaborn==0.12.1
• tk==0.1.0

Run Locally

• Clone the GitHub repository

$ git clone git@github.com:prabhav5112/CHBMS-app.git

• Move to the Project Directory

$ cd CHBMS-app

• Create a Virtual Environment (Optional)

  • Install Virtualenv using pip (If it is not installed)

   $ pip install virtualenv

  • Create the Virtual Environment

  $ virtualenv chbms

  • Activate the Virtual Environment

    • In MAC OS/Linux

    $ source chbms/bin/activate

    • In Windows

    $ source chbms\Scripts\activate

• Install the requirements

(chbms) $ pip install -r requirements.txt

• Load the database from the MySQL file

(chbms) $ mysql project < Project_db_Nov_27.sql -p

• Run the python script main.py

(chbms) $ python3 main.py

• Dectivate the Virtual Environment (after you are done)

(chbms) $ deactivate

License

This project is under the Apache-2.0 License License. See LICENSE for Details.

Contributors

Prabhav B Kashyap