Provident Fund System

Posted By phpprojectz on August 28, 2017
Backend: 

Objective of Provident Fund System

Provident Fund 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 Provident Fund,Employees,Registration,Contributions,Users. Admin user can manage all the operations of Contributions,Users,Provident Fund,Compnay Shares,Employees and their details. Admin can create different type of reports of Provident Fund,Employees,Registration,Contributions,Users according to their choise and filters. You can Download PHP and MySQL Project Provident Fund System with source code and database from this site. We also provide Project Report of Provident Fund System.

Functionalities and their descriptions of Provident Fund System are as follows:

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

Modules of Provident Fund System and their descriptions:

  • Provident Fund Module : Manage all the operations of Provident Fund
  • Employees Module : Manage all the operations of Employees
  • Compnay Shares Module : Manage all the operations of Compnay Shares
  • Registration Module : Manage all the operations of Registration
  • Contributions Module : Manage all the operations of Contributions
  • Users Module : Manage all the operations of Users

Classes and their methods of Provident Fund System:

  • Provident Fund Methods : addProvident Fund(), editProvident Fund(), deleteProvident Fund(), updateProvident Fund(), saveProvident Fund(), searchProvident Fund()
  • Employees Methods : addEmployees(), editEmployees(), deleteEmployees(), updateEmployees(), saveEmployees(), searchEmployees()
  • Compnay Shares Methods : addCompnay Shares(), editCompnay Shares(), deleteCompnay Shares(), updateCompnay Shares(), saveCompnay Shares(), searchCompnay Shares()
  • Registration Methods : addRegistration(), editRegistration(), deleteRegistration(), updateRegistration(), saveRegistration(), searchRegistration()
  • Contributions Methods : addContributions(), editContributions(), deleteContributions(), updateContributions(), saveContributions(), searchContributions()
  • Users Methods : addUsers(), editUsers(), deleteUsers(), updateUsers(), saveUsers(), searchUsers()

Database tables and attributes of the Provident Fund System:

  • Provident Fund Entity : Attributes of Provident Fund are provident_fund_id, provident_fund_name, provident_fund_type, provident_fund_description
  • Employees Entity : Attributes of Employees are employee_id, employee_name, employee_mobile, employee_email, employee_username, employee_password, employee_address
  • Compnay Shares Entity : Attributes of Compnay Shares are company_shares_id, company_shares_name, company_shares_type, company_shares_description
  • Registration Entity : Attributes of Registration are registration_id, registration_employee_id, registration_name, registration_type, registration_number, registration_date, registration_description
  • Contributions Entity : Attributes of Contributions are contribution_id, contribution_name, contribution_type, vdescription
  • Users Entity : Attributes of Users are user_id, user_name, user_mobile, user_email, user_username, user_password, user_address

Database definition of Provident Fund System:

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

Super admin functionality of Provident Fund System:

  • Admin can add, edit, delete and view the records of Provident Fund, Contributions, Compnay Shares, Users
  • Admin can manage all the details of Employees, Compnay Shares, Registration, Contributions
  • Admin can also generate reports of Provident Fund, Employees, Compnay Shares, Registration
  • Admin can search the details of Provident Fund, Contributions, Compnay Shares, Users
  • Admin can apply different level of filters on report of Provident Fund, Compnay Shares, Users
  • Admin can tracks the detailed information of Contributions, Users, Provident Fund, Employees

Report of Provident Fund System:

  • Generates the report on Compnay Shares,Registration,Provident Fund,Employees,Contributions,Users,
  • Registration,Contributions,Users 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 Registration,Contributions,Users
  • Excel Sheet report has also been integrated for Employees,Registration,Users
  • You can create the CSV reports for Provident Fund,Contributions,Compnay Shares

Limitation of Provident Fund System

  • Run time report generation is not available in Provident Fund System.
  • We have not implemented the dynamic report for Provident Fund,Registration,Contributions,Employees,Compnay Shares,Users
  • This project Provident Fund System has not been developed on Model View Controller architecture, so its very complex to manage
  • Batch mode execution for Off-line reports of Provident Fund, Registration, Users cannot be generated.
  • Crystel report has not been integrated

Input Data and Validation of Provident Fund System

  • We have added all the validations for input value on the modules Provident Fund,Employees,Compnay Shares
  • Registration,Contributions,Users can not be submited without filling all the inout fields
  • Duplicate values testing has been implemented on Provident Fund,Compnay Shares,Users
  • CSRF token has also been implemented on Registration,Employees,Provident Fund, Contributions,Users
  • All the Provident Fund,Registration,Contributions,Employees,Compnay Shares,Users has integrated with captcha for spam protections
  • Access level validation has been implemented on Users,Contributions,Registration
  • Number and character validation has also been implemented on Compnay Shares,Contributions,Provident Fund

Send Message

Vertical Tabs

Latest PHP and MySQL Projects Source Code and Database