Customer Track System

Posted By phpprojectz on August 28, 2017
Backend: 

Objective of Customer Track System

Customer Track 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,Documents,Login,Charges,Payments. Admin user can manage all the operations of Charges,Payments,Customer,Cards,Documents and their details. Admin can create different type of reports of Customer,Documents,Login,Charges,Payments according to their choise and filters. You can Download PHP and MySQL Project Customer Track System with source code and database from this site. We also provide Project Report of Customer Track System.

Functionalities and their descriptions of Customer Track System are as follows:

  • You can search records on various criterias. Such as Customer, Login, Charges, Payments
  • Create, read, update and delete (CRUD) application has been implemented on Customer,Documents,Login,Charges,Payments
  • Keep the track logs of Documents, Cards, Charges ect
  • Advance search has been implemented on Documents,Cards, Charges
  • You can see all the details of the Customer, Login, Cards, Charges
  • All the modules Cards, Charges, Documents,Payments, Customer are inter related and tightly coupled
  • It deals with monitoring the information and transactions of Charges.
  • All the Documents,Cards, Charges 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 Customer Track System and their descriptions:

  • Customer Module : Manage all the operations of Customer
  • Documents Module : Manage all the operations of Documents
  • Cards Module : Manage all the operations of Cards
  • Login Module : Manage all the operations of Login
  • Charges Module : Manage all the operations of Charges
  • Payments Module : Manage all the operations of Payments

Classes and their methods of Customer Track System:

  • Customer Methods : addCustomer(), editCustomer(), deleteCustomer(), updateCustomer(), saveCustomer(), searchCustomer()
  • Documents Methods : addDocuments(), editDocuments(), deleteDocuments(), updateDocuments(), saveDocuments(), searchDocuments()
  • Cards Methods : addCards(), editCards(), deleteCards(), updateCards(), saveCards(), searchCards()
  • Login Methods : addLogin(), editLogin(), deleteLogin(), updateLogin(), saveLogin(), searchLogin()
  • Charges Methods : addCharges(), editCharges(), deleteCharges(), updateCharges(), saveCharges(), searchCharges()
  • Payments Methods : addPayments(), editPayments(), deletePayments(), updatePayments(), savePayments(), searchPayments()

Database tables and attributes of the Customer Track System:

  • Customer Entity : Attributes of Customer are customer_id, customer_name, customer_mobile, customer_email, customer_username, customer_password, customer_address
  • Documents Entity : Attributes of Documents are document_id, document_name, document_type, document_description
  • Cards Entity : Attributes of Cards are card_id, card_customer_id, card_name, card_type, card_description
  • Login Entity : Attributes of Login are login_id, login_user_id, login_role_id, login_username, login_password, login_lastlogin
  • Charges Entity : Attributes of Charges are charge_id, charge_card_id, charge_amount, charge_type, charge_description
  • Payments Entity : Attributes of Payments are payment_id, payment_customer_id, payment_date, payment_amount, payment_description

Database definition of Customer Track System:

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

Super admin functionality of Customer Track System:

  • Admin can add, edit, delete and view the records of Customer, Charges, Cards, Payments
  • Admin can manage all the details of Documents, Cards, Login, Charges
  • Admin can also generate reports of Customer, Documents, Cards, Login
  • Admin can search the details of Customer, Charges, Cards, Payments
  • Admin can apply different level of filters on report of Customer, Cards, Payments
  • Admin can tracks the detailed information of Charges, Payments, Customer, Documents

Report of Customer Track System:

  • Generates the report on Cards,Login,Customer,Documents,Charges,Payments,
  • Login,Charges,Payments 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 Login,Charges,Payments
  • Excel Sheet report has also been integrated for Documents,Login,Payments
  • You can create the CSV reports for Customer,Charges,Cards

Limitation of Customer Track System

  • Run time report generation is not available in Customer Track System.
  • We have not implemented the dynamic report for Customer,Login,Charges,Documents,Cards,Payments
  • This project Customer Track 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, Login, Payments cannot be generated.
  • Crystel report has not been integrated

Input Data and Validation of Customer Track System

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

Send Message

Vertical Tabs

Latest PHP and MySQL Projects Source Code and Database