Supply Chain Management System

Posted By phpprojectz on August 28, 2017
Backend: 

Objective of Supply Chain Management System

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

Functionalities and their descriptions of Supply Chain Management System are as follows:

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

Modules of Supply Chain Management System and their descriptions:

  • Supply Chain Module : Manage all the operations of Supply Chain
  • Customer Module : Manage all the operations of Customer
  • Product Module : Manage all the operations of Product
  • Company Module : Manage all the operations of Company
  • Order Module : Manage all the operations of Order
  • Supplier Module : Manage all the operations of Supplier

Classes and their methods of Supply Chain Management System:

  • Supply Chain Methods : addSupply Chain(), editSupply Chain(), deleteSupply Chain(), updateSupply Chain(), saveSupply Chain(), searchSupply Chain()
  • Customer Methods : addCustomer(), editCustomer(), deleteCustomer(), updateCustomer(), saveCustomer(), searchCustomer()
  • Product Methods : addProduct(), editProduct(), deleteProduct(), updateProduct(), saveProduct(), searchProduct()
  • Company Methods : addCompany(), editCompany(), deleteCompany(), updateCompany(), saveCompany(), searchCompany()
  • Order Methods : addOrder(), editOrder(), deleteOrder(), updateOrder(), saveOrder(), searchOrder()
  • Supplier Methods : addSupplier(), editSupplier(), deleteSupplier(), updateSupplier(), saveSupplier(), searchSupplier()

Database tables and attributes of the Supply Chain Management System:

  • Supply Chain Entity : Attributes of Supply Chain are supply_chain_id, supply_chain_product_id, supply_chain_name, supply_chain_type, supply_chain_description
  • Customer Entity : Attributes of Customer are customer_id, customer_name, customer_mobile, customer_email, customer_username, customer_password, customer_address
  • Product Entity : Attributes of Product are product_id, product_customer_id product_items, product_number, product_type, product_description
  • Company Entity : Attributes of Company are company_id, company_name, comapny_type, company_description, company_address
  • Order Entity : Attributes of Order are order_id, order_customer_id order_type, order_number, order_description
  • Supplier Entity : Attributes of Supplier are supplier_id, supplier_name, supplier_mobile, supplier_email, supplier_username, supplier_password, supplier_address

Database definition of Supply Chain Management System:

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

Super admin functionality of Supply Chain Management System:

  • Admin can add, edit, delete and view the records of Supply Chain, Order, Product, Supplier
  • Admin can manage all the details of Customer, Product, Company, Order
  • Admin can also generate reports of Supply Chain, Customer, Product, Company
  • Admin can search the details of Supply Chain, Order, Product, Supplier
  • Admin can apply different level of filters on report of Supply Chain, Product, Supplier
  • Admin can tracks the detailed information of Order, Supplier, Supply Chain, Customer

Report of Supply Chain Management System:

  • Generates the report on Product,Company,Supply Chain,Customer,Order,Supplier,
  • Company,Order,Supplier 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 Company,Order,Supplier
  • Excel Sheet report has also been integrated for Customer,Company,Supplier
  • You can create the CSV reports for Supply Chain,Order,Product

Limitation of Supply Chain Management System

  • Run time report generation is not available in Supply Chain Management System.
  • We have not implemented the dynamic report for Supply Chain,Company,Order,Customer,Product,Supplier
  • This project Supply Chain 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 Supply Chain, Company, Supplier cannot be generated.
  • Crystel report has not been integrated

Input Data and Validation of Supply Chain Management System

  • We have added all the validations for input value on the modules Supply Chain,Customer,Product
  • Company,Order,Supplier can not be submited without filling all the inout fields
  • Duplicate values testing has been implemented on Supply Chain,Product,Supplier
  • CSRF token has also been implemented on Company,Customer,Supply Chain, Order,Supplier
  • All the Supply Chain,Company,Order,Customer,Product,Supplier has integrated with captcha for spam protections
  • Access level validation has been implemented on Supplier,Order,Company
  • Number and character validation has also been implemented on Product,Order,Supply Chain

Send Message

Vertical Tabs

Latest PHP and MySQL Projects Source Code and Database