HealthlinkPro

---

Welcome to HealthlinkPro – a comprehensive healthcare management system designed to streamline clinic operations. This README provides detailed instructions for setting up, using, and understanding the features of the project.

User Credentials

FYI - There is no need to manually enter these values as there is autofill enabled for the buttons.

• Admin Username: root
• Admin Password: root
• Staff Username: root2
• Staff Password: root2
• Unique Pin: 100
• Server Pin: 1999

---

Features

1. Dynamic Bill-Receipt and Medical-Leave Generation

   • Generate receipts dynamically for patients, including treatment and payment details, using React-PDF Render.
   • Effortlessly create medical leave certificates based on patient data.

2. Why not Add a Bunch! -- CSV,XLSX,XLS File Extracter

   • Instead of Entering Records,You can use the CSV/XLSX,XLS Uploader to upload Excel Documents of 100+ Records At the Same Time!

   2.1 Why not Download -- CSV File Export Option -You can use the CSV Downloader to download Excel Documents of 100+ Records!

3. Secure and Protected Subdirectories

   • All dashboard pages use hashed URL subdirectories to ensure secure access to sensitive data.

4. Home Dashboard with Summary Metrics

   • A summary page serves as the dashboard homepage, providing real-time insights:

     • Daily Patients
     • Total Patients
     • Total Revenue
     • Total Staff

5. Staff Management System

   • Manage staff attendance efficiently via the Staff Page.
   • Generate monthly attendance sheets that summarize attendance for all staff members across each month.

6. Built in Search-Engine

   • Built in Search Engine that can filter out from 1000+ Records using the Phone Number

7. Interactive and User-Friendly UI

   • Built with React and styled with TailwindCSS for a responsive, modern interface.
   • Seamless navigation between pages for an intuitive user experience.

---

Project Layout

The project is organized as follows:

.env
.eslintignore
.eslintrc
.gitignore
.prettierignore
.prettierrc
.vercel/
    project.json
    README.txt
CHANGELOG.md
index.html
jsconfig.json
LICENSE.md
main.jsx
package.json
pages/
    pages/
        app.jsx
        ...
postcss.config.js
public/
    _redirects
    assets/
        ...
    favicon/
    manifest.json
README.md
src/
    _mock/
    app.jsx
    assets/
    components/
    global.css
    hooks/
    index.css
    layouts/
    main.jsx
    pages/
    routes/
    sections/
    theme/
    utils/
tailwind.config.js
vercel.json
vite.config.js

---

Database Setup

The project utilizes Supabase as the backend. Use the SQL commands below to create the required tables.

1. Create a organization on Supabase
2. Create a Project on Supabase
3. Navigate the SQL Editor Section As Shown Below

---

5. Paste all the three commands one by one on the Editor and click on Run

clinic Table

CREATE TABLE clinic (
    id SERIAL PRIMARY KEY,
    sno INT,
    phone_number TEXT,
    alternate_number TEXT,
    name TEXT,
    age INT,
    occupation TEXT,
    diagnosis TEXT,
    treatment_plan TEXT,
    staff_attended TEXT,
    medical_history TEXT,
    amount_paid INT,
    days_attended INT,
    visit_1 DATE,
    visit_2 DATE,
    visit_3 DATE,
    visit_4 DATE,
    visit_5 DATE,
    visit_6 DATE,
    visit_7 DATE,
    visit_8 DATE,
    visit_9 DATE,
    visit_10 DATE,
    bloodbank_conf BOOLEAN,
    insurance_conf BOOLEAN
);

creds Table

CREATE TABLE creds (
    sno BIGINT PRIMARY KEY,
    login_user TEXT,
    login_pass TEXT,
    staff_user TEXT,
    staff_pass TEXT,
    pin BIGINT,
    serverpin BIGINT
);

rehab Table

CREATE TABLE rehab (
    id SERIAL PRIMARY KEY,
    sno INT,
    phone_number TEXT,
    alternate_number TEXT,
    name TEXT,
    age INT,
    occupation TEXT,
    diagnosis TEXT,
    treatment_plan TEXT,
    staff_attended TEXT,
    medical_history TEXT,
    amount_paid INT,
    days_attended INT,
    visit_1 DATE,
    visit_2 DATE,
    visit_3 DATE,
    visit_4 DATE,
    visit_5 DATE,
    visit_6 DATE,
    visit_7 DATE,
    visit_8 DATE,
    visit_9 DATE,
    visit_10 DATE,
    rehab_commencement DATE,
    rehab_last_date DATE,
    bloodbank_conf BOOLEAN,
    insurance_conf BOOLEAN
);

staff Table

CREATE TABLE staff (
    sno SERIAL PRIMARY KEY,
    name TEXT NOT NULL,
    days_attended INT,
    days_absent INT,
    mobile_number BIGINT,
    date_joined DATE,
    jan INT,
    feb INT,
    mar INT,
    apr INT,
    may INT,
    jun INT,
    jul INT,
    aug INT,
    sep INT,
    oct INT,
    nov INT,
    dec INT
);

---

Getting Started

Follow these steps to set up the project locally:

1. Clone the repository:

   git clone https://github.com/RJohnPaul/Healthlink.git

2. Navigate to the project directory:

   cd Healthlink

3. Install dependencies:

   npm install

4. Start the development server:

   npm start

5. Open your browser and go to http://localhost:3000.

---

Screenshots

Home Dashboard

Staff Attendance Page

Receipt Generation

---

Additional Features

• Responsive Design: Optimized for desktops, tablets, and mobile devices.
• Fast and Lightweight: Built using Vite.js for improved performance.
• Detailed Logs: Track patient visits, diagnoses, and treatments effortlessly.
• Customizable Configurations: Easily adjust settings via the .env file.

---

License

This project is licensed under the MIT License. Refer to the LICENSE file for details.

---