Posted By phpprojectz on August 28, 2017

Objective of Customer

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

Functionalities and their descriptions of Customer are as follows:

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

  • Customer Module : Manage all the operations of Customer
  • Order Module : Manage all the operations of Order
  • Food Item Module : Manage all the operations of Food Item
  • Sales Module : Manage all the operations of Sales
  • Category Module : Manage all the operations of Category
  • Payment Module : Manage all the operations of Payment

Classes and their methods of Customer:

  • Customer Methods : addCustomer(), editCustomer(), deleteCustomer(), updateCustomer(), saveCustomer(), searchCustomer()
  • Order Methods : addOrder(), editOrder(), deleteOrder(), updateOrder(), saveOrder(), searchOrder()
  • Food Item Methods : addFood Item(), editFood Item(), deleteFood Item(), updateFood Item(), saveFood Item(), searchFood Item()
  • Sales Methods : addSales(), editSales(), deleteSales(), updateSales(), saveSales(), searchSales()
  • Category Methods : addCategory(), editCategory(), deleteCategory(), updateCategory(), saveCategory(), searchCategory()
  • Payment Methods : addPayment(), editPayment(), deletePayment(), updatePayment(), savePayment(), searchPayment()

Database tables and attributes of the Customer:

  • Customer Entity : Attributes of Customer are customer_id, customer_name, customer_mobile, customer_email, customer_username, customer_password, customer_address
  • Order Entity : Attributes of Order are order_id, order_customer_id order_type, order_number, order_description
  • Food Item Entity : Attributes of Food Item are food_id, food_customer_id, food_order, food_category, food_price, food_name, food_type, food_description
  • Sales Entity : Attributes of Sales are sales_id, sales_customer_id, sales_amount, sales_type, sales_description
  • Category Entity : Attributes of Category are category_id, category_name, category_type, category_description
  • Payment Entity : Attributes of Payment are payment_id, payment_customer_id, payment_date, payment_amount, payment_description

Database definition of Customer:

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

Super admin functionality of Customer:

  • Admin can add, edit, delete and view the records of Customer, Category, Food Item, Payment
  • Admin can manage all the details of Order, Food Item, Sales, Category
  • Admin can also generate reports of Customer, Order, Food Item, Sales
  • Admin can search the details of Customer, Category, Food Item, Payment
  • Admin can apply different level of filters on report of Customer, Food Item, Payment
  • Admin can tracks the detailed information of Category, Payment, Customer, Order

Report of Customer:

  • Generates the report on Food Item,Sales,Customer,Order,Category,Payment,
  • Sales,Category,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 Sales,Category,Payment
  • Excel Sheet report has also been integrated for Order,Sales,Payment
  • You can create the CSV reports for Customer,Category,Food Item

Limitation of Customer

  • Run time report generation is not available in Customer.
  • We have not implemented the dynamic report for Customer,Sales,Category,Order,Food Item,Payment
  • This project Customer has not been developed on Model View Controller architecture, so its very complex to manage
  • Batch mode execution for Off-line reports of Customer, Sales, Payment cannot be generated.
  • Crystel report has not been integrated

Input Data and Validation of Customer

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

Send Message

Vertical Tabs

Latest PHP and MySQL Projects Source Code and Database