EmployeePayrollManagementSystem

This is a web-based employee payroll system built for a fictional company called SmartPark. It lets a company track employees, departments, and monthly salary records from a browser interface. The project is a learning exercise or portfolio piece that covers the full range of a typical business web app: a database, a server, and a front-end user interface all working together.

The database side uses MySQL and stores four tables: departments, employees, salaries, and user accounts. Departments have a gross salary and deduction amount attached to them, employees belong to a department, and each month a salary record is generated per employee with the net pay calculated automatically by subtracting deductions from the gross. The backend is a Node.js server that exposes an API for logging in, managing employees and departments, handling salary records, and generating a monthly payroll report.

The front end is a React application styled with Tailwind CSS, a utility-based approach to visual design that makes pages adapt to different screen sizes. It connects to the backend using Axios, which is a library for making HTTP requests from the browser. Login is session-based, meaning the server remembers who you are via a cookie until you log out.

The system covers five main screens: employees, departments, salaries, monthly reports, and logout. The salary page allows full create, update, and delete operations. The reports page shows a table of all employees with their position, department, and net pay for a given month.

Setup requires installing Node.js, MySQL, and running a SQL script to create the database and load the default admin account. There is no cloud deployment described; it is intended to run locally.