Employee Management System

Posted By phpprojectz on August 28, 2017
Backend: 

Objective of Employee Management System

Employee Management System is a web based application which has been developed over PHP and MySQL and runs on WAMP, XAMP or Apache2 server.. The main modules of the project is Employee,Salary,Experience,Login,Attendance. Admin user can manage all the operations of Login,Attendance,Employee,Leaves,Salary and their details. Admin can create different type of reports of Employee,Salary,Experience,Login,Attendance according to their choise and filters. You can Download PHP and MySQL Project Employee Management System with source code and database from this site. We also provide Project Report of Employee Management System.

Functionalities and their descriptions of Employee Management System are as follows:

  • You can search records on various criterias. Such as Employee, Experience, Login, Attendance
  • Create, read, update and delete (CRUD) application has been implemented on Employee,Salary,Experience,Login,Attendance
  • Keep the track logs of Salary, Leaves, Login ect
  • Advance search has been implemented on Salary,Leaves, Login
  • You can see all the details of the Employee, Experience, Leaves, Login
  • All the modules Leaves, Login, Salary,Attendance, Employee are inter related and tightly coupled
  • It deals with monitoring the information and transactions of Login.
  • All the Salary,Leaves, Login modules has their unique record ID for fast transactions and searching
  • Editing, adding and updating of Records is improved which results in proper resource management of Employee data.

Modules of Employee Management System and their descriptions:

  • Employee Module : Manage all the operations of Employee
  • Salary Module : Manage all the operations of Salary
  • Leaves Module : Manage all the operations of Leaves
  • Experience Module : Manage all the operations of Experience
  • Login Module : Manage all the operations of Login
  • Attendance Module : Manage all the operations of Attendance

Classes and their methods of Employee Management System:

  • Employee Methods : addEmployee(), editEmployee(), deleteEmployee(), updateEmployee(), saveEmployee(), searchEmployee()
  • Salary Methods : addSalary(), editSalary(), deleteSalary(), updateSalary(), saveSalary(), searchSalary()
  • Leaves Methods : addLeaves(), editLeaves(), deleteLeaves(), updateLeaves(), saveLeaves(), searchLeaves()
  • Experience Methods : addExperience(), editExperience(), deleteExperience(), updateExperience(), saveExperience(), searchExperience()
  • Login Methods : addLogin(), editLogin(), deleteLogin(), updateLogin(), saveLogin(), searchLogin()
  • Attendance Methods : addAttendance(), editAttendance(), deleteAttendance(), updateAttendance(), saveAttendance(), searchAttendance()

Database tables and attributes of the Employee Management System:

  • Employee Entity : Attributes of Employee are employee_id, employee_name, employee_mobile, employee_email, employee_username, employee_password, employee_address
  • Salary Entity : Attributes of Salary are salary_id, salary_employee_id, salary_amount, salary_total, salary_type, salary_description
  • Leaves Entity : Attributes of Leaves are leave_id, leave_employee_id, leave_type, leave_status, leave_to, leave_from, leave_description
  • Experience Entity : Attributes of Experience are experience_id, experience_employee_id, experience_year, experience_type, experience_description
  • Login Entity : Attributes of Login are login_id, login_user_id, login_role_id, login_username, login_password, login_lastlogin
  • Attendance Entity : Attributes of Attendance are attendance_id, attendance_employee_id, attendance_student_id, attendance_type, attendance_description

Database definition of Employee Management System:

  • The details of Employee is store into the Employee tables respective with all tables
  • Each entity (Attendance, Leaves, Login, Salary, Employee) contains primary key and unique keys.
  • The entity Leaves, Login has binded with Employee, Salary entities with foreign key
  • There is one-to-one and one-to-many relationships available between Login, Experience, Attendance, Employee
  • All the entities Employee, Login, Leaves, Attendance are normalized and reduce duplicacy of records
  • We have implemented indexing on each tables of Employee Management System tables for fast query execution.

Super admin functionality of Employee Management System:

  • Admin can add, edit, delete and view the records of Employee, Login, Leaves, Attendance
  • Admin can manage all the details of Salary, Leaves, Experience, Login
  • Admin can also generate reports of Employee, Salary, Leaves, Experience
  • Admin can search the details of Employee, Login, Leaves, Attendance
  • Admin can apply different level of filters on report of Employee, Leaves, Attendance
  • Admin can tracks the detailed information of Login, Attendance, Employee, Salary

Report of Employee Management System:

  • Generates the report on Leaves,Experience,Employee,Salary,Login,Attendance,
  • Experience,Login,Attendance has been integrated with the dynamic filter. So you can filter the records run time
  • You can also import the report data into PDF of Experience,Login,Attendance
  • Excel Sheet report has also been integrated for Salary,Experience,Attendance
  • You can create the CSV reports for Employee,Login,Leaves

Limitation of Employee Management System

  • Run time report generation is not available in Employee Management System.
  • We have not implemented the dynamic report for Employee,Experience,Login,Salary,Leaves,Attendance
  • This project Employee Management System has not been developed on Model View Controller architecture, so its very complex to manage
  • Batch mode execution for Off-line reports of Employee, Experience, Attendance cannot be generated.
  • Crystel report has not been integrated

Input Data and Validation of Employee Management System

  • We have added all the validations for input value on the modules Employee,Salary,Leaves
  • Experience,Login,Attendance can not be submited without filling all the inout fields
  • Duplicate values testing has been implemented on Employee,Leaves,Attendance
  • CSRF token has also been implemented on Experience,Salary,Employee, Login,Attendance
  • All the Employee,Experience,Login,Salary,Leaves,Attendance has integrated with captcha for spam protections
  • Access level validation has been implemented on Attendance,Login,Experience
  • Number and character validation has also been implemented on Leaves,Login,Employee

Send Message

Vertical Tabs

Latest PHP and MySQL Projects Source Code and Database