Reseller Management System

Posted By phpprojectz on August 28, 2017
Backend: 

Objective of Reseller Management System

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

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

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

Modules of Reseller Management System and their descriptions:

  • Reseller Module : Manage all the operations of Reseller
  • Order Module : Manage all the operations of Order
  • Customer Module : Manage all the operations of Customer
  • Company Module : Manage all the operations of Company
  • Sold License Module : Manage all the operations of Sold License
  • Company Type Module : Manage all the operations of Company Type

Classes and their methods of Reseller Management System:

  • Reseller Methods : addReseller(), editReseller(), deleteReseller(), updateReseller(), saveReseller(), searchReseller()
  • Order Methods : addOrder(), editOrder(), deleteOrder(), updateOrder(), saveOrder(), searchOrder()
  • Customer Methods : addCustomer(), editCustomer(), deleteCustomer(), updateCustomer(), saveCustomer(), searchCustomer()
  • Company Methods : addCompany(), editCompany(), deleteCompany(), updateCompany(), saveCompany(), searchCompany()
  • Sold License Methods : addSold License(), editSold License(), deleteSold License(), updateSold License(), saveSold License(), searchSold License()
  • Company Type Methods : addCompany Type(), editCompany Type(), deleteCompany Type(), updateCompany Type(), saveCompany Type(), searchCompany Type()

Database tables and attributes of the Reseller Management System:

  • Reseller Entity : Attributes of Reseller are reseller_id, reseller_licence_id, reseller_name, reseller_type, reseller_description
  • Order Entity : Attributes of Order are order_id, order_customer_id order_type, order_number, order_description
  • Customer Entity : Attributes of Customer are customer_id, customer_name, customer_mobile, customer_email, customer_username, customer_password, customer_address
  • Company Entity : Attributes of Company are company_id, company_name, comapny_type, company_description, company_address
  • Sold License Entity : Attributes of Sold License are license_id, license_name, license_type, license_description
  • Company Type Entity : Attributes of Company Type are company_type_id, company_type_name, company_type_description

Database definition of Reseller Management System:

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

Super admin functionality of Reseller Management System:

  • Admin can add, edit, delete and view the records of Reseller, Sold License, Customer, Company Type
  • Admin can manage all the details of Order, Customer, Company, Sold License
  • Admin can also generate reports of Reseller, Order, Customer, Company
  • Admin can search the details of Reseller, Sold License, Customer, Company Type
  • Admin can apply different level of filters on report of Reseller, Customer, Company Type
  • Admin can tracks the detailed information of Sold License, Company Type, Reseller, Order

Report of Reseller Management System:

  • Generates the report on Customer,Company,Reseller,Order,Sold License,Company Type,
  • Company,Sold License,Company Type 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,Sold License,Company Type
  • Excel Sheet report has also been integrated for Order,Company,Company Type
  • You can create the CSV reports for Reseller,Sold License,Customer

Limitation of Reseller Management System

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

Input Data and Validation of Reseller Management System

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

Send Message

Vertical Tabs

Latest PHP and MySQL Projects Source Code and Database