🚀 DNB Pay System – Modern Attendance & Payroll Management

🌟 Project Overview

DNB Pay System is a robust, secure, and scalable web application built with Django and MySQL, designed to modernize attendance and payroll workflows for Sector 9 Hospital, BSP.
It replaces legacy systems with a user-friendly, role-based platform that automates HR processes, ensures data integrity, and supports efficient payroll management.

🎯 Key Features

• Role-Based Access Control
  Secure authentication for DNB, CSR, Contractual, Finance, and Super Admin users.
• Dynamic Dashboards
  Personalized dashboards with real-time stats and navigation for each role.
• Employee Master Management
  Add, edit, and view employee details with category-specific logic.
• Attendance Automation
  Quick entry, editing, and auto-calculation of absents based on month and leave types.
• Payroll Processing
  Automated salary computation and adjustments from attendance data.
• Comprehensive Reporting
  Built-in reports and checklists for compliance and audits.
• Modern UI
  Responsive, clean Bootstrap interface with intuitive forms and tables.
• Security
  Strong authentication, session management, and restricted access to sensitive operations.

🛠️ Project Flow

🛠️ Tech Stack

Layer	Technology
Backend	Django (Python 3.x)
Database	MySQL 8.x (or Oracle 19c)
Frontend	HTML5, Bootstrap, JS
ORM/Drivers	Django ORM, PyMySQL
Utilities	python-decouple, Pillow, crispy-forms, cryptography

📸 Screenshots & Demo

• Login Page

---

• Superuser Dashboard

---

• Superuser master table

---

• Add new user button

---

• Category

---

• Edit button

---

• User admin option (superuser)

---

• Attendance (superuser)

---

• Adjustments

---

• Processing

---

• Reports

---

• Enquiry

---

• Checklist

---

• Admin dashboard

---

• Admin user admin view

---

• DNB dashboard

---

• DNB (attendance view)

---

• CSR login page

---

• CSR master view

---

• CSR attendance view

---

• CONTRACTUAL dashboard

---

• CONTRACTUAL attendance view

---

• DNB master view

---

• DNB attendance view

---

• Login page (light view)

---

📝 Detailed Features & Modules

1. Authentication & Authorization

• Secure login for all user roles.
• Session management and password security.
• Role-based dashboard and navigation.

2. Employee Master

• Add/edit/view employee records.
• Filter by category (DNB, CSR, Contractual).
• Data validation and integrity checks.

3. Attendance Management

• Enter and edit monthly attendance.
• Auto-calculate absents based on the month (supports leap years).
• Validation: sum of all days matches days in month.
• Role-based edit permissions.

4. Payroll Module

• Automated stipend and adjustment calculations.
• Tax and deduction handling.
• Payroll reports for finance/admin.

5. Reporting & Compliance

• Downloadable reports (CSV, PDF).
• Audit logs and change tracking.
• Checklist for compliance.

🚦 Setup & Installation Guide

1. Prerequisites

• Python 3.8+
• MySQL 8.x (or Oracle 19c, if using Oracle backend)
• Git (optional)
• Visual Studio Code or any IDE

2. Clone the Repository

git clone https://github.com/yourusername/dnb_pay_system.git
cd dnb_pay_system

3. Create & Activate Virtual Environment

python -m venv venv
# On Windows PowerShell:
.\venv\Scripts\Activate.ps1
# On Linux/macOS:
source venv/bin/activate

4. Install Dependencies

pip install -r requirements.txt

5. Database Setup

• Create a MySQL database (e.g., mydb) and user (bspadmin/bsp123).
• Grant privileges:

  CREATE DATABASE mydb CHARACTER SET utf8mb4;
  CREATE USER 'bspadmin'@'localhost' IDENTIFIED BY 'bsp123';
  GRANT ALL PRIVILEGES ON mydb.* TO 'bspadmin'@'localhost';
  FLUSH PRIVILEGES;

• Update settings.py:

  DATABASES = {
      'default': {
          'ENGINE': 'django.db.backends.mysql',
          'NAME': 'mydb',
          'USER': 'bspadmin',
          'PASSWORD': 'bsp123',
          'HOST': 'localhost',
          'PORT': '3306',
      }
  }

6. Apply Migrations

python manage.py migrate

7. Create Superuser (Optional)

python manage.py createsuperuser

8. Run the Server

python manage.py runserver

Visit http://127.0.0.1:8000/ in your browser.

🔑 Default Login Credentials

Role	Username	Password
Super	admin_dnb4	sprint456
(Or create your own using createsuperuser)

🧑‍💻 Developer

• Piyush Kumar Tiwari :- https://github.com/stealthinator45

📚 Learnings & Impact

• Migrated a legacy system to a modern web platform.
• Implemented real-world security and authentication.
• Automated complex HR workflows and payroll calculations.
• Enhanced data integrity and reporting for compliance.

📢 License and Acknowledgement

This project was developed as part of a Vocational Training Program at Bhilai Steel Plant (BSP), under the mentorship and guidance of the C&IT Department. All work was carried out exclusively for educational and internal demonstration purposes.

Ownership of project objectives, data, and direction remains with BSP. This repository serves as a non-commercial academic showcase and is not intended for public or production deployment.

Please do not reuse or distribute this project for commercial or sensitive applications without prior written permission from the respective authorities at BSP.

🚀 Let’s Connect!

My linkedin :- https://www.linkedin.com/in/piyush-kumar-tiwari-a6a800256/ My mail :- tpiyush2626@gmail.com