Consignment Tracking System

Posted By phpprojectz on August 28, 2017
Backend: 

Objective of Consignment Tracking System

Consignment Tracking 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 Consignment,Track,Delivery,Payment,Schedule. Admin user can manage all the operations of Payment,Schedule,Consignment,Ship,Track and their details. Admin can create different type of reports of Consignment,Track,Delivery,Payment,Schedule according to their choise and filters. You can Download PHP and MySQL Project Consignment Tracking System with source code and database from this site. We also provide Project Report of Consignment Tracking System.

Functionalities and their descriptions of Consignment Tracking System are as follows:

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

Modules of Consignment Tracking System and their descriptions:

  • Consignment Module : Manage all the operations of Consignment
  • Track Module : Manage all the operations of Track
  • Ship Module : Manage all the operations of Ship
  • Delivery Module : Manage all the operations of Delivery
  • Payment Module : Manage all the operations of Payment
  • Schedule Module : Manage all the operations of Schedule

Classes and their methods of Consignment Tracking System:

  • Consignment Methods : addConsignment(), editConsignment(), deleteConsignment(), updateConsignment(), saveConsignment(), searchConsignment()
  • Track Methods : addTrack(), editTrack(), deleteTrack(), updateTrack(), saveTrack(), searchTrack()
  • Ship Methods : addShip(), editShip(), deleteShip(), updateShip(), saveShip(), searchShip()
  • Delivery Methods : addDelivery(), editDelivery(), deleteDelivery(), updateDelivery(), saveDelivery(), searchDelivery()
  • Payment Methods : addPayment(), editPayment(), deletePayment(), updatePayment(), savePayment(), searchPayment()
  • Schedule Methods : addSchedule(), editSchedule(), deleteSchedule(), updateSchedule(), saveSchedule(), searchSchedule()

Database tables and attributes of the Consignment Tracking System:

  • Consignment Entity : Attributes of Consignment are consignment_id, consignment_customer_id, consignment_item, consignment_type, consignment_description
  • Track Entity : Attributes of Track are track_id, track_consignment_id, track_date, track_place track_type, track_description
  • Ship Entity : Attributes of Ship are ship_id, ship_consignment_id, ship_date, ship_type, ship_description
  • Delivery Entity : Attributes of Delivery are delivery_id, delivery_customer_id, delivery_address, delivery_type, delivery_by, delivery_date, delivery_description
  • Payment Entity : Attributes of Payment are payment_id, payment_customer_id, payment_date, payment_amount, payment_description
  • Schedule Entity : Attributes of Schedule are schedule_id, schedule_name, schedule_type, schedule_description

Database definition of Consignment Tracking System:

  • The details of Consignment is store into the Consignment tables respective with all tables
  • Each entity (Schedule, Ship, Payment, Track, Consignment) contains primary key and unique keys.
  • The entity Ship, Payment has binded with Consignment, Track entities with foreign key
  • There is one-to-one and one-to-many relationships available between Payment, Delivery, Schedule, Consignment
  • All the entities Consignment, Payment, Ship, Schedule are normalized and reduce duplicacy of records
  • We have implemented indexing on each tables of Consignment Tracking System tables for fast query execution.

Super admin functionality of Consignment Tracking System:

  • Admin can add, edit, delete and view the records of Consignment, Payment, Ship, Schedule
  • Admin can manage all the details of Track, Ship, Delivery, Payment
  • Admin can also generate reports of Consignment, Track, Ship, Delivery
  • Admin can search the details of Consignment, Payment, Ship, Schedule
  • Admin can apply different level of filters on report of Consignment, Ship, Schedule
  • Admin can tracks the detailed information of Payment, Schedule, Consignment, Track

Report of Consignment Tracking System:

  • Generates the report on Ship,Delivery,Consignment,Track,Payment,Schedule,
  • Delivery,Payment,Schedule 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 Delivery,Payment,Schedule
  • Excel Sheet report has also been integrated for Track,Delivery,Schedule
  • You can create the CSV reports for Consignment,Payment,Ship

Limitation of Consignment Tracking System

  • Run time report generation is not available in Consignment Tracking System.
  • We have not implemented the dynamic report for Consignment,Delivery,Payment,Track,Ship,Schedule
  • This project Consignment Tracking System has not been developed on Model View Controller architecture, so its very complex to manage
  • Batch mode execution for Off-line reports of Consignment, Delivery, Schedule cannot be generated.
  • Crystel report has not been integrated

Input Data and Validation of Consignment Tracking System

  • We have added all the validations for input value on the modules Consignment,Track,Ship
  • Delivery,Payment,Schedule can not be submited without filling all the inout fields
  • Duplicate values testing has been implemented on Consignment,Ship,Schedule
  • CSRF token has also been implemented on Delivery,Track,Consignment, Payment,Schedule
  • All the Consignment,Delivery,Payment,Track,Ship,Schedule has integrated with captcha for spam protections
  • Access level validation has been implemented on Schedule,Payment,Delivery
  • Number and character validation has also been implemented on Ship,Payment,Consignment

Send Message

Vertical Tabs

Latest PHP and MySQL Projects Source Code and Database