Contractor Management System

Posted By phpprojectz on August 28, 2017
Backend: 

Objective of Contractor Management System

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

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

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

Modules of Contractor Management System and their descriptions:

  • Contract Module : Manage all the operations of Contract
  • Company Module : Manage all the operations of Company
  • Leave Module : Manage all the operations of Leave
  • Timesheet Module : Manage all the operations of Timesheet
  • Project Module : Manage all the operations of Project
  • Salary Module : Manage all the operations of Salary

Classes and their methods of Contractor Management System:

  • Contract Methods : addContract(), editContract(), deleteContract(), updateContract(), saveContract(), searchContract()
  • Company Methods : addCompany(), editCompany(), deleteCompany(), updateCompany(), saveCompany(), searchCompany()
  • Leave Methods : addLeave(), editLeave(), deleteLeave(), updateLeave(), saveLeave(), searchLeave()
  • Timesheet Methods : addTimesheet(), editTimesheet(), deleteTimesheet(), updateTimesheet(), saveTimesheet(), searchTimesheet()
  • Project Methods : addProject(), editProject(), deleteProject(), updateProject(), saveProject(), searchProject()
  • Salary Methods : addSalary(), editSalary(), deleteSalary(), updateSalary(), saveSalary(), searchSalary()

Database tables and attributes of the Contractor Management System:

  • Contract Entity : Attributes of Contract are contract_id, contract_project_id contract_name, contract_type, contract_description
  • Company Entity : Attributes of Company are company_id, company_name, comapny_type, company_description, company_address
  • Leave Entity : Attributes of Leave are leave_id, leave_employee_id, leave_type, leave_status, leave_to, leave_from, leave_description
  • Timesheet Entity : Attributes of Timesheet are timesheet_id, timesheet_project_id, timesheet_type, timesheet_description
  • Project Entity : Attributes of Project are project_id, project_company_id, project_contract_id, project_name, project_assign, project_last_date, project_type, project_description
  • Salary Entity : Attributes of Salary are salary_id, salary_employee_id, salary_amount, salary_total, salary_type, salary_description

Database definition of Contractor Management System:

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

Super admin functionality of Contractor Management System:

  • Admin can add, edit, delete and view the records of Contract, Project, Leave, Salary
  • Admin can manage all the details of Company, Leave, Timesheet, Project
  • Admin can also generate reports of Contract, Company, Leave, Timesheet
  • Admin can search the details of Contract, Project, Leave, Salary
  • Admin can apply different level of filters on report of Contract, Leave, Salary
  • Admin can tracks the detailed information of Project, Salary, Contract, Company

Report of Contractor Management System:

  • Generates the report on Leave,Timesheet,Contract,Company,Project,Salary,
  • Timesheet,Project,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 Timesheet,Project,Salary
  • Excel Sheet report has also been integrated for Company,Timesheet,Salary
  • You can create the CSV reports for Contract,Project,Leave

Limitation of Contractor Management System

  • Run time report generation is not available in Contractor Management System.
  • We have not implemented the dynamic report for Contract,Timesheet,Project,Company,Leave,Salary
  • This project Contractor 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 Contract, Timesheet, Salary cannot be generated.
  • Crystel report has not been integrated

Input Data and Validation of Contractor Management System

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

Send Message

Vertical Tabs

Latest PHP and MySQL Projects Source Code and Database