Database System in Automatic Billing for Supermarket
by Aye Thandar Htway | Aye Wint Mon "Database System in Automatic Billing for Supermarket"
Published in International Journal of Trend in Scientific Research and Development (ijtsrd), ISSN: 2456-6470, Volume-3 | Issue-1, December 2018,
URL: http://www.ijtsrd.com/papers/ijtsrd19104.pdf
Direct Link: http://www.ijtsrd.com/engineering/electrical-engineering/19104/ database-system-in-automatic-billing-for-supermarket/aye-thandar-htway
open access journal of engineering, ugc approved journals for engineering, call for paper engineering
Now-a-day shopping in city-mark and mall is increasing rapidly. While shopping, customers have to face some difficulties. First, they go at the billing counter for payments their total expenditure but there are many people standing in queue for billing purpose. This is unnecessary waste time for customer because cashier scans each item bought with barcode. Barcode technology is time consuming process. Second, customer can't predict their total expenditure so overall purchase total is greater than their budget. Thus, the system overcomes all of these drawbacks faced by customers in shopping malls. This system has been introduced to avoid waiting in billing queue. The system consists of a RFID reader, Arduino Uno, LCD display and wireless Zigbee transmitter in the customer site and software programming language is Arduino IDE. At the counter computer, Zigbee receiver is connected to billing PC using serial communication. Visual Basic 6.0 is used for Graphical User Interface GUI to get display customer bill and Microsoft Access database system is used to know about details of purchasing products on the counter computer.
Design and Implementation of Smart Trolley for Automatic Billing System
by Aye Thandar Htway | Aye Wint Mon" Design and Implementation of Smart Trolley for Automatic Billing System"
Published in International Journal of Trend in Scientific Research and Development (ijtsrd), ISSN: 2456-6470, Volume-2 | Issue-5 , August 2018,
URL: http://www.ijtsrd.com/papers/ijtsrd18347.pdf
Direct URL: http://www.ijtsrd.com/engineering/electrical-engineering/18347/design-and-implementation-of-smart-trolley-for-automatic-billing-system/aye-thandar-htway
international journals in engineering, call for paper engineering, paper publication for engineering
Now-a-day shopping in supermarket and mall is increasing rapidly. While shopping, customers have to face some difficulties. First, they go at the billing counter for payments their total expenditure but there are many people standing in queue for billing purpose. This is unnecessary waste time for customer because cashier scans each item bought with barcode. Barcode technology is time consuming process. Second, customers can"™t predict their total expenditure so, overall purchase total is greater than their budged. Thus, the proposed system overcomes all of these drawbacks faced by customers in shopping malls. To reduce customer' waste time, the system uses RFID (Radio Frequency Identification) technology. The proposed system will be implemented into two parts. First part is the customer side which initialize arduino for the set ups of RFID reader and zigbee. In this part, contains the tag detection of products by RFID reader which are placed in the trolley and sending of product information from trolley to central billing unit through zigbee transmitter. Second part is counter side which contain zigbee receiver is connected to billing PC using serial communication. It receives billing data and gives it to the PC by using Visual Basic 6.0 software and maintains daily record by Microsoft Access database system.
Private Sub Command2_Click()
Dim Cedula
Cedula = InputBox("Ingrese Cedula a Consultar")
If Cedula = Empty Then
Exit Sub
End If
Adodc1.Refresh
With Adodc1.Recordset
.Filter = ("Cedula='" & Cedula & "'")
If Not .EOF Then
Text1 = .Fields!Cedula
Text2 = .Fields!Nombre
Text3 = .Fields!apellido
DTPicker1 = .Fields!fecha_nac
Text4 = .Fields!telefono
Text12 = .Fields!edad
Combo1 = .Fields!sexo
Combo3 = .Fields!cargo
Text5 = .Fields!direccion
band = 1
Else
MsgBox "No Existe el Registro", vbCritical
End If
End With
End Sub
