QR Code based Customer Billing System for Supermarket Shopping Project

ABSTRACT

The objective of this project is to propose a real-time capturing system that helps consumer billing for hypermart shopping using Quick Response (QR) code in Android smartphones.

EXISTING SYSTEM

Nowadays in most hypermart shops, customers have to take a long queue for billing after shopping and it’s a time-consuming process. Also, users will not be aware of the total bill amount at the time of purchase. Increase time spent at the billing counter and reduces customer satisfaction.

PROPOSED SYSTEM

When a customer entered a shopping mall or a hypermart for shopping, his smartphone will be connected to the hypermart’s server. After the successful connection with the server, he can start purchasing. At the time of shopping, the QR code should be read for bill generation. QR code pattern can be read by android smartphones at the time of adding an item to the cart. The QR code will identify the price of the product and it will automatically calculate the total price according to the quantity of the product in the cart. So QR code verifies products by capturing them through a smartphone, then decodes them and sends them to the server for authentication. When the user finishes his shopping, the total amount will be displayed on his phone as well as the cashier’s monitor. You can also visit & download the PHP, My SQL Application project on Supermarket Inventory Management System.

 This will avoid huge queues and waste of time for billing after shopping. The customer can plan his shopping whether to continue or not by viewing the purchase bills so that he can manage the bill and shopping effectively.

The project consists of two main modules.

Admin module

Admin will add the products with their price, manufacturing details, and quantity information. He can view the billing and purchase details of customers and generate daily, weekly, and monthly billing reports. Admin can add the products with their price, manufacturing details, and stock information without any duplication. Based on the arrival of new stock and purchasing the product from the stock, the stock quantity will be updated. He then generates a QR code for each product. He can view the billing and purchase details of customers. Accordingly, he can generate daily, weekly, and monthly billing reports.

User module

User can plan their shopping using this app. The user can register with the app. When he enters a hypermart, he can scan the QR code of the product and can view the corresponding product details. Then submit the quantity to be taken. He can finally submit his items in the cart to generate the bill and also have the facility to cancel items from the cart. 

This Supermarket Management and Billing System are related to the Customer Billing System for Supermarket Shopping Project. You can also visit & download the Java Application project on Supermarket Management and Billing System

SOFTWARE  REQUIREMENTS

  • Operating system:   Microsoft Windows XP/above, Android
  • Platform:   Net Beans, Eclipse
  • Front End:   JSP, Android
  • Back End:   MySQL

TABLES        

Table 1: Login

Primary key: username

Purpose: To store login details

Column

Type

Description

Username

varchar(50)

 Primary Key, Email id

Password

varchar(50)

 Password, unique password

User type

varchar(50)

 user type

Status

varchar(50)

 Status

Table 2: Customer

Primary key: customer_id

Foreign key: emailid

Purpose: To store customer details

Column

Type

Description

customer_id

int(50)

 Primary Key, customer id

customer_name

varchar(50)

Name of customer

emailid

varchar(50)

 Foreign Key , Email id

Phone_number

bigint(50)

 Phone Number of Customer

address

Text

 Address of Customer

appcode

varchar(50)

 App code

 

Table 3: Category

Primary key: category_id

Purpose: To store category details

Column

Type

Description

category_id

int(50)

 Primary Key, Category id

Categoryname

varchar(50)

 Category Name

 Table 4: stock

Primary key: stock_id

Foreign key: product_id

Purpose: To store stock details

Column

Type

Description

stock_id

int(50)

 Primary Key, Stock id

product_id

int(50)

 Foreign Key, Product id

Stockqty

bigint(50)

Quantity of Stock

Stockdate

date

Stock Added Date

Status

varchar(50)

Status

Table 5: product

Primary key: product_id

Foreign key: category_id

Purpose: To store product details 

Column

Type

Description

product_id

int(50)

 Primary Key, Product id

productname

varchar(50)

Product Name

category_id

int(50)

Foreign key, Category id

Quantity

bigint(50)

Quantity of product

manufacturingdate

date

Manufacturing Date

Expirydate

date

Expiry Date

Price

double

Price of Product

manufacturer

varchar(50)

Manufacturing company

Description

text

About the product

Madein

varchar(50)

Country name

Image

varchar(50)

Image of product

Qrcode

varchar(50)

Quick Response code

Status

varchar(50)

Status

Table 6: cart

Primary key: Cartid

Foreign key: Email

Purpose: To store cart details

Column

Type

Description

Cartid

int(11)

 Primary Key, Cart id

Email

varchar(50)

 Foreign Key, Email

Cdate

date

 

Flag

int(11)

 

Table 7: cart_item

Primary key: cart_item_id

Foreign key: Cartid , product_id

Purpose: To store cart item details

Column

Type

Description

cart_item_id

int(8)

 Primary Key, Cart item id

Cartid

int(8)

 Foreign Key, Cart id

product_id

int(8)

 Foreign Key, Product id

no_of_quantity

int(8)

 Quantity of product

 Table 8: purchase

Primary key: purchase_id

Foreign key: bill_no, Emailed, product_id

Purpose: To store  purchase details

Column

Type

Description

purchase_id

int(8)

 Primary Key, Purchase id

bill_no

int(8)

 Foreign Key, Bill No

Emailed

varchar(50)

 Foreign Key, Emailed

product_id

int(8)

 Foreign Key, Product id

purchase_date

date

 Product Purchased Date

Quantity

bigint(15)

 Quantity of product

Table 9: bill

Primary key: bill_no

Foreign key: Emailed

Purpose: To store bill details

Column

Type

Description

bill_no

int(50)

 Primary Key, Bill No

Emailed

varchar(50)

  Foreign Key, Emailed

Amount

int(50)

 Total Amount

bill_generate_date

date

Date of bill generated

Status

varchar(50)

 Status

Table 10: feedback

Primary key: feedback_id

Purpose: To store feedback details

Column

Type

Description

feedback_id

int(8)

 Primary key, Feedback id

from_id

varchar(50)

 Sender’s id

Message

varchar(50)

 Message

send_date

date

 Feedback send date

Download the complete Android app project on QR Code based Customer Billing System for Supermarket Shopping Project.

Also, Read this Sales Management System for Hypermarkets PHP & MySQL Web Application Project.

Student Housing System Web Site Project using PHP CodeIgniter and MYSQL

Our Student Housing System will include the following operations:

  • Application and room booking
  • Room inventory management
  • Tenancy management. (Landlord properties)
  • Rules of Conduct.
  • Account management by super admin.

Our vision implies that the student accommodation system should also be digitalized with the fast-growing generation and make accommodation more flexible and reliable.

Super Admin

  • Super Admin will have all the rights over users on the portal, he/she will be managing roles for different types of users.
  • Also, there will be a provision where he/she will be able to check the total financial details that are carried away by the portal.

Admin

  • Admin has his own personal login and his main task is to check all the inquiries and charge fees from the students as well as from the Owner when needed.
  • Approval system for new users in students and landlord (Owner).
  • Also, he has the right to validate the property that the landlord might have posted on the portal.

Users

  • Users have to register themselves and log in with their usernames and passwords into the system.
  • Users can search for houses for rent near their respected universities.

Owner

  • Owners have to register themselves and log in with their usernames and passwords into the system.
  • Owners who want to give their property for rent to students have to upload photos of their property and basic amenities for the students must be fulfilled like a study table, cupboard, etc.

Objectives:

  • Our Project can be used by individuals to provide a platform for the new Hostels & PGs for Students & employees. Using this system Users can easily get information about Hostels & PG.
  • Provide Easily Finding Homes or PGs in Other Cities
  • Easy Finding Rental House

Context Level Diagram:

Output Application Working Procedure:

  • Login Form For User
  • Login Form With Validation At the User side
  • Registration Form For User side
  • Registration Form With Validation At the User side
  • Forgot Password For User
  • Forgot Password With Validation At User side
  • Searching of Hostel & PG For User
  • Feedback Form For User side
  • Feedback Form With Validation At the User side
  • Booking Form With Validation At the User side
  • Inquiry Form With Validation At the User side
  • Change the Password On the User side
  • Payment Methods On the User side
  • Tiffin Service Booking Form
  • User Profile
  • Login Form For Admins
  • Login Form With Validation At Admin side
  • Add New Owner On Admin side
  • Super Admin Profile
  • Edit Admin Details On the Admin side
  • Hostel Admin Profile Edit Details
  • Searching Result According to User
  • Latest PGs And Hostels At Home Page on the User side
  • About Us At User Side
  • Tiffin Profile At User side
  • Our Terms & Conditions
  • User Booking Details On the User side
  • Admins List Display On the Admin side
  • View Room Details On the Admin side
  • Update Block Details On the Admin side
  • Delete Hostel Details On the Admin side
  • Admin Profile Updated Message
  • Admin Listing On the Admin side
  • Hostel Admin Profile

FUTURE ENHANCEMENT

  • There is a possibility to create a chat server, though users can directly communicate with PG owners.
  • Improve the system security level of database & data transactions.
  • Allow others to give an advertisement in the system.

Download the complete project code, report, and PPT on Student Housing System Project using PHP & MySQL.