Farm Management System

Posted By phpprojectz on August 28, 2017
Backend: 

Objective of Farm Management System

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

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

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

Modules of Farm Management System and their descriptions:

  • Farm Module : Manage all the operations of Farm
  • Plants Module : Manage all the operations of Plants
  • Treatments Module : Manage all the operations of Treatments
  • Medicines Module : Manage all the operations of Medicines
  • Employees Module : Manage all the operations of Employees
  • Login Module : Manage all the operations of Login

Classes and their methods of Farm Management System:

  • Farm Methods : addFarm(), editFarm(), deleteFarm(), updateFarm(), saveFarm(), searchFarm()
  • Plants Methods : addPlants(), editPlants(), deletePlants(), updatePlants(), savePlants(), searchPlants()
  • Treatments Methods : addTreatments(), editTreatments(), deleteTreatments(), updateTreatments(), saveTreatments(), searchTreatments()
  • Medicines Methods : addMedicines(), editMedicines(), deleteMedicines(), updateMedicines(), saveMedicines(), searchMedicines()
  • Employees Methods : addEmployees(), editEmployees(), deleteEmployees(), updateEmployees(), saveEmployees(), searchEmployees()
  • Login Methods : addLogin(), editLogin(), deleteLogin(), updateLogin(), saveLogin(), searchLogin()

Database tables and attributes of the Farm Management System:

  • Farm Entity : Attributes of Farm are farm_id, farm_name, farm_type, farm_description
  • Plants Entity : Attributes of Plants are plant_id, plant_name, plant_type, plant_description
  • Treatments Entity : Attributes of Treatments are treatment_id, treatment_name, treatment_method, treatment_type, treatment_description
  • Medicines Entity : Attributes of Medicines are medicine_id, medicine_name, medicine_company, medicine_composition, medicine_cost, medicine_type, medicine_dose, medicine_description
  • Employees Entity : Attributes of Employees are employee_id, employee_name, employee_mobile, employee_email, employee_username, employee_password, employee_address
  • Login Entity : Attributes of Login are login_id, login_user_id, login_role_id, login_username, login_password, login_lastlogin

Database definition of Farm Management System:

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

Super admin functionality of Farm Management System:

  • Admin can add, edit, delete and view the records of Farm, Employees, Treatments, Login
  • Admin can manage all the details of Plants, Treatments, Medicines, Employees
  • Admin can also generate reports of Farm, Plants, Treatments, Medicines
  • Admin can search the details of Farm, Employees, Treatments, Login
  • Admin can apply different level of filters on report of Farm, Treatments, Login
  • Admin can tracks the detailed information of Employees, Login, Farm, Plants

Report of Farm Management System:

  • Generates the report on Treatments,Medicines,Farm,Plants,Employees,Login,
  • Medicines,Employees,Login 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 Medicines,Employees,Login
  • Excel Sheet report has also been integrated for Plants,Medicines,Login
  • You can create the CSV reports for Farm,Employees,Treatments

Limitation of Farm Management System

  • Run time report generation is not available in Farm Management System.
  • We have not implemented the dynamic report for Farm,Medicines,Employees,Plants,Treatments,Login
  • This project Farm 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 Farm, Medicines, Login cannot be generated.
  • Crystel report has not been integrated

Input Data and Validation of Farm Management System

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

Send Message

Vertical Tabs

Latest PHP and MySQL Projects Source Code and Database