Employee Attendance System

Posted By phpprojectz on August 28, 2017

Objective of Employee Attendance System

Employee Attendance 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 Attendance,Employees,Leave,Login,salary. Admin user can manage all the operations of Login,salary,Attendance,Holidays,Employees and their details. Admin can create different type of reports of Attendance,Employees,Leave,Login,salary according to their choise and filters. You can Download PHP and MySQL Project Employee Attendance System with source code and database from this site. We also provide Project Report of Employee Attendance System.

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

  • You can search records on various criterias. Such as Attendance, Leave, Login, salary
  • Create, read, update and delete (CRUD) application has been implemented on Attendance,Employees,Leave,Login,salary
  • Keep the track logs of Employees, Holidays, Login ect
  • Advance search has been implemented on Employees,Holidays, Login
  • You can see all the details of the Attendance, Leave, Holidays, Login
  • All the modules Holidays, Login, Employees,salary, Attendance are inter related and tightly coupled
  • It deals with monitoring the information and transactions of Login.
  • All the Employees,Holidays, 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 Attendance data.

Modules of Employee Attendance System and their descriptions:

  • Attendance Module : Manage all the operations of Attendance
  • Employees Module : Manage all the operations of Employees
  • Holidays Module : Manage all the operations of Holidays
  • Leave Module : Manage all the operations of Leave
  • Login Module : Manage all the operations of Login
  • salary Module : Manage all the operations of salary

Classes and their methods of Employee Attendance System:

  • Attendance Methods : addAttendance(), editAttendance(), deleteAttendance(), updateAttendance(), saveAttendance(), searchAttendance()
  • Employees Methods : addEmployees(), editEmployees(), deleteEmployees(), updateEmployees(), saveEmployees(), searchEmployees()
  • Holidays Methods : addHolidays(), editHolidays(), deleteHolidays(), updateHolidays(), saveHolidays(), searchHolidays()
  • Leave Methods : addLeave(), editLeave(), deleteLeave(), updateLeave(), saveLeave(), searchLeave()
  • Login Methods : addLogin(), editLogin(), deleteLogin(), updateLogin(), saveLogin(), searchLogin()
  • salary Methods : addsalary(), editsalary(), deletesalary(), updatesalary(), savesalary(), searchsalary()

Database tables and attributes of the Employee Attendance System:

  • Attendance Entity : Attributes of Attendance are attendance_id, attendance_employee_id, attendance_student_id, attendance_type, attendance_description
  • Employees Entity : Attributes of Employees are employee_id, employee_name, employee_mobile, employee_email, employee_username, employee_password, employee_address
  • Holidays Entity : Attributes of Holidays are holidays_id, holidays_employee_id, holidays_date, holidays_duration, holidays_description
  • Leave Entity : Attributes of Leave are leave_id, leave_employee_id, leave_type, leave_status, leave_to, leave_from, leave_description
  • Login Entity : Attributes of Login are login_id, login_user_id, login_role_id, login_username, login_password, login_lastlogin
  • salary Entity : Attributes of salary are salary_id, salary_employee_id, salary_amount, salary_total, salary_type, salary_description

Database definition of Employee Attendance System:

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

Super admin functionality of Employee Attendance System:

  • Admin can add, edit, delete and view the records of Attendance, Login, Holidays, salary
  • Admin can manage all the details of Employees, Holidays, Leave, Login
  • Admin can also generate reports of Attendance, Employees, Holidays, Leave
  • Admin can search the details of Attendance, Login, Holidays, salary
  • Admin can apply different level of filters on report of Attendance, Holidays, salary
  • Admin can tracks the detailed information of Login, salary, Attendance, Employees

Report of Employee Attendance System:

  • Generates the report on Holidays,Leave,Attendance,Employees,Login,salary,
  • Leave,Login,salary 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 Leave,Login,salary
  • Excel Sheet report has also been integrated for Employees,Leave,salary
  • You can create the CSV reports for Attendance,Login,Holidays

Limitation of Employee Attendance System

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

Input Data and Validation of Employee Attendance System

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

Send Message

Vertical Tabs

Latest PHP and MySQL Projects Source Code and Database