Payroll Management System

Introduction

The Payroll Management System is a Python-based GUI application for managing employees, tracking attendance, and generating payslips. This application uses Tkinter for its interface and SQLite as the database. SQLAlchemy ORM is used to handle database interactions efficiently, ensuring modularity and maintainability.

Project Structure

payroll_management/
│
├── main.py                      # Main application file to run the system
├── db_setup.py                  # Database creation and setup with sample data
├── connection.py                # Database connection utility
├── employee_module.py           # Employee management module
├── attendance_module.py         # Attendance management module
├── payslip_module.py            # Payslip generation module
├── plus2_payroll.db             # SQLite database
├── favicon.ico                  # Application icon
├── top2.jpg                     # Logo image for the home tab
├── __pycache__/                 # Compiled Python files (automatically generated)

Key Components

main.py

The main.py file orchestrates the entire application by integrating all modules. It uses Tkinter to create tabs for different functionalities:

• Home: Displays the welcome message and logo.
• Employee Management: Manage employee details like name, department, and basic salary.
• Attendance Management: Track daily attendance records.
• Payslip Generation: Generate payslips based on attendance and salary.

Database Setup (db_setup.py)

The db_setup.py script initializes the SQLite database with tables and sample data. It uses SQLAlchemy ORM for defining models and managing schema changes seamlessly. Visit SQLite SQLAlchemy connection to learn more about establishing database connectivity.

Database Connection (connection.py)

The connection.py module simplifies database connectivity by creating and managing sessions for SQLAlchemy. This ensures consistent and secure interactions with the database across different modules of the application.

Modules

• Attendance Module: Handles attendance records for employees.
• Employee Management Module: Manages employee details.
• Payslip Module: Generates monthly payslips with salary breakdowns.

How to Run the Application

1. Ensure Python and necessary libraries are installed (SQLite, SQLAlchemy ORM, Tkinter, Pillow).
2. Run db_setup.py to set up the database with sample data.
3. Execute main.py to start the Payroll Management System.

Explore More

This pillar page serves as an entry point to understand the Payroll Management System. Dive deeper into each module for detailed insights:

• Attendance Management Module
• Employee Management Module
• Payslip Generation Module