Leave Approval System

Posted By phpprojectz on August 28, 2017
Backend: 

Objective of Leave Approval System

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

Functionalities and their descriptions of Leave Approval System are as follows:

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

Modules of Leave Approval System and their descriptions:

  • Leave Module : Manage all the operations of Leave
  • Notification Module : Manage all the operations of Notification
  • Company Module : Manage all the operations of Company
  • Branch Module : Manage all the operations of Branch
  • Report Module : Manage all the operations of Report
  • Employee Module : Manage all the operations of Employee

Classes and their methods of Leave Approval System:

  • Leave Methods : addLeave(), editLeave(), deleteLeave(), updateLeave(), saveLeave(), searchLeave()
  • Notification Methods : addNotification(), editNotification(), deleteNotification(), updateNotification(), saveNotification(), searchNotification()
  • Company Methods : addCompany(), editCompany(), deleteCompany(), updateCompany(), saveCompany(), searchCompany()
  • Branch Methods : addBranch(), editBranch(), deleteBranch(), updateBranch(), saveBranch(), searchBranch()
  • Report Methods : addReport(), editReport(), deleteReport(), updateReport(), saveReport(), searchReport()
  • Employee Methods : addEmployee(), editEmployee(), deleteEmployee(), updateEmployee(), saveEmployee(), searchEmployee()

Database tables and attributes of the Leave Approval System:

  • Leave Entity : Attributes of Leave are leave_id, leave_employee_id, leave_type, leave_status, leave_to, leave_from, leave_description
  • Notification Entity : Attributes of Notification are notification_id, notification_leave_id, notification_title, notification_approval, notification_leave_cancellation, notification_type, notification_description
  • Company Entity : Attributes of Company are company_id, company_name, comapny_type, company_description, company_address
  • Branch Entity : Attributes of Branch are branch_id, branch_name, branch_type, branch_city, branch_address
  • Report Entity : Attributes of Report are report_id, report_name, report_type, report_description
  • Employee Entity : Attributes of Employee are employee_id, employee_name, employee_mobile, employee_email, employee_username, employee_password, employee_address

Database definition of Leave Approval System:

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

Super admin functionality of Leave Approval System:

  • Admin can add, edit, delete and view the records of Leave, Report, Company, Employee
  • Admin can manage all the details of Notification, Company, Branch, Report
  • Admin can also generate reports of Leave, Notification, Company, Branch
  • Admin can search the details of Leave, Report, Company, Employee
  • Admin can apply different level of filters on report of Leave, Company, Employee
  • Admin can tracks the detailed information of Report, Employee, Leave, Notification

Report of Leave Approval System:

  • Generates the report on Company,Branch,Leave,Notification,Report,Employee,
  • Branch,Report,Employee 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 Branch,Report,Employee
  • Excel Sheet report has also been integrated for Notification,Branch,Employee
  • You can create the CSV reports for Leave,Report,Company

Limitation of Leave Approval System

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

Input Data and Validation of Leave Approval System

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

Send Message

Vertical Tabs

Latest PHP and MySQL Projects Source Code and Database