Cargo Management System

Posted By phpprojectz on August 28, 2017
Backend: 

Objective of Cargo Management System

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

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

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

Modules of Cargo Management System and their descriptions:

  • Customer Module : Manage all the operations of Customer
  • Cargo Module : Manage all the operations of Cargo
  • Transaction Module : Manage all the operations of Transaction
  • Billing Module : Manage all the operations of Billing
  • Enquiry Module : Manage all the operations of Enquiry
  • Payment Module : Manage all the operations of Payment

Classes and their methods of Cargo Management System:

  • Customer Methods : addCustomer(), editCustomer(), deleteCustomer(), updateCustomer(), saveCustomer(), searchCustomer()
  • Cargo Methods : addCargo(), editCargo(), deleteCargo(), updateCargo(), saveCargo(), searchCargo()
  • Transaction Methods : addTransaction(), editTransaction(), deleteTransaction(), updateTransaction(), saveTransaction(), searchTransaction()
  • Billing Methods : addBilling(), editBilling(), deleteBilling(), updateBilling(), saveBilling(), searchBilling()
  • Enquiry Methods : addEnquiry(), editEnquiry(), deleteEnquiry(), updateEnquiry(), saveEnquiry(), searchEnquiry()
  • Payment Methods : addPayment(), editPayment(), deletePayment(), updatePayment(), savePayment(), searchPayment()

Database tables and attributes of the Cargo Management System:

  • Customer Entity : Attributes of Customer are customer_id, customer_name, customer_mobile, customer_email, customer_username, customer_password, customer_address
  • Cargo Entity : Attributes of Cargo are cargo_id, cargo_customer_id, cargo_type, cargo_sales, cargo_order, caro_description
  • Transaction Entity : Attributes of Transaction are transaction_id, transaction_customer_id, transaction_amount, transaction_bill, transaction_number, transaction_type, transaction_history, transaction_description
  • Billing Entity : Attributes of Billing are bill_id, bill_customer_id, bill_number, bill_type, bill_receipt, bill_description
  • Enquiry Entity : Attributes of Enquiry are enquiry,_id, enquiry,_title, enquiry,_type, enquiry,_date, enquiry,_description
  • Payment Entity : Attributes of Payment are payment_id, payment_customer_id, payment_date, payment_bill, payment_type, payment_description

Database definition of Cargo Management System:

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

Super admin functionality of Cargo Management System:

  • Admin can add, edit, delete and view the records of Customer, Enquiry, Transaction, Payment
  • Admin can manage all the details of Cargo, Transaction, Billing, Enquiry
  • Admin can also generate reports of Customer, Cargo, Transaction, Billing
  • Admin can search the details of Customer, Enquiry, Transaction, Payment
  • Admin can apply different level of filters on report of Customer, Transaction, Payment
  • Admin can tracks the detailed information of Enquiry, Payment, Customer, Cargo

Report of Cargo Management System:

  • Generates the report on Transaction,Billing,Customer,Cargo,Enquiry,Payment,
  • Billing,Enquiry,Payment 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 Billing,Enquiry,Payment
  • Excel Sheet report has also been integrated for Cargo,Billing,Payment
  • You can create the CSV reports for Customer,Enquiry,Transaction

Limitation of Cargo Management System

  • Run time report generation is not available in Cargo Management System.
  • We have not implemented the dynamic report for Customer,Billing,Enquiry,Cargo,Transaction,Payment
  • This project Cargo 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 Customer, Billing, Payment cannot be generated.
  • Crystel report has not been integrated

Input Data and Validation of Cargo Management System

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

Send Message

Vertical Tabs

Latest PHP and MySQL Projects Source Code and Database