HR Employee Management Portal
HR portal with QR check-in, leave approval, payroll with PDF payslips, reviews and HR insights for three roles. Python, Flask, Bootstrap, SQLite.
- Price: ₹1,999
- Category: Web App
- Technology: Python, Flask, Bootstrap 5, SQLite, Chart.js
- Includes: Source code + database
- Suitable for: BCA / B.Sc CS, MCA / M.Sc CS, B.E / B.Tech CSE & IT
Project overview
This is a full HR website that runs on a normal PC. There are three roles. HR admins manage employees (with department, manager, salary structure, login and QR ID card), departments, the daily attendance register, the check-in kiosk, leave requests, payroll, a notice board, HR insights and the audit log. Managers see their team, approve or reject team leave and write quarterly performance reviews. Employees check in and out, see their leave balance, apply for leave, view their attendance and download payslips. Leave counts only working days (weekends and office holidays are free) and each type has a yearly balance. Payroll is worked out from the salary structure and the attendance of a finished month: loss of pay = gross x absent days / working days, provident fund 12% of basic (capped), professional tax, then the month is finalised and locked so that payslips cannot change. Security: hashed passwords, a lock after 5 wrong passwords, CSRF tokens in every form, role checks on every page and 15-minute idle logout. 15 rule tests (payroll worked out by hand) and 66 web checks are included.
Modules
- Login and roles: HR admin, manager and employee roles; hashed passwords; lock after 5 wrong passwords; password change; HR can reset a password.
- Employees and departments: Add, edit and mark employees as left (their login closes); manager chain without circles; departments with safe delete; QR ID card.
- Attendance: Check in / out on the portal, daily register with late marks and leave, CSV download, monthly view for every employee.
- Check-in kiosk: Scan or type the code on the ID card: first scan checks in, second checks out; shows late arrivals and hours worked.
- Leave: Casual / Sick / Earned balances, working-day counting, overlap and back-date rules, cancel, approve or reject by the manager or HR.
- Payroll: Run a finished month, review, finalise and lock; loss of pay, PF and professional tax; PDF payslips; register CSV.
- Reviews: Quarterly rating 1 to 5 with strengths and improvement points by the manager or HR; shown to the employee.
- HR insights: Attendance % by department, late arrivals, leave by type, employees who need attention, birthdays and work anniversaries.
- Notice board and audit log: HR posts notices that everyone sees; every important action is written to an audit log.
Requirements
- Python 3.11
- Internet once, to install the libraries (about 2 minutes)
- Windows 10 / 11
How to run this project
- Install Python 3.11 from python.org and tick "Add python.exe to PATH" during setup.
- Extract the zip and open the project folder (STUDENT_GUIDE.md explains every step in simple words).
- Double-click `1_INSTALL.bat` once and wait until it says [OK] (about 2 minutes; it downloads the libraries into a private .venv folder).
- Double-click `2_RUN.bat` to start the project. Your browser opens http://127.0.0.1:5000 by itself. If it does not start, double-click `CHECK_SETUP.bat` and read what it says.
- Log in as HR admin / admin123 (manager emp001 / demo123, employee emp006 / demo123).
- Open an employee's QR ID card and the Check-in kiosk (type EMP010), then Payroll and download a payslip PDF. Log in as emp006 to apply for leave and as manager emp001 to approve it; then open HR insights and the Audit log as admin.