Bill Maker is a program that calculate the bill of a product just by inserting any product in it. It is efficient in making bills a bit faster and more arranged.
Modules used in Bill Maker :-
from tkinter import *
import xlsxwriter
from datetime import date
tkinter: It is used to create graphical user interface based application in python.
xlsxwriter: It is used to create Microsoft Excel files in python.
datetime: It is used for manipulating dates and times.
Firstly, just create a simple gray screen
if __name__ == '__main__':
root = Tk()
#cannot be resizable
root.resizable(0, 0)
#title of the application
root.title("BILL MAKER ver 1.0 @dx4iot")
root.config(background="gray10")
root.mainloop()
Output:
Now create some entry boxes and button for entering the necessary details like bill number, date, customer name, quantity of a product, etc.
#Heading of the project
enter_label = Label(root,text="BILL MAKER",font="Forte 20 bold",bg="gray10",fg="white",width=20)
enter_label.pack()
#entrybox bill number
enter_billNo = Entry(root,font="Forte 20 bold",width=20)
enter_billNo.insert(0,'Enter Bill No')
on_click_id = enter_billNo.bind('<Button-1>',onclick)
enter_billNo.pack()
#entrybox for date
enter_date = Entry(root,font="Forte 20 bold",width=20)
enter_date.insert(0,date.today())
enter_date.pack()
#fentrybox for customer name
enter_customerName = Entry(root,font="Forte 20 bold",width=20)
enter_customerName.insert(0,'Enter Customer Name')
on_click_id_1 = enter_customerName.bind('<Button-1>',onclick1)
enter_customerName.pack()
#entrybox for no of peices
enter_peices = Entry(root,font="Forte 20 bold",width=20)
enter_peices.insert(0,'Enter Pieces')
on_click_id_2 = enter_peices.bind('<Button-1>',onclick2)
enter_peices.pack()
#entrybox for quantity
enter_quan = Entry(root,font="Forte 20 bold",width=20)
enter_quan.insert(0,'Enter Quantity')
on_click_id_3 = enter_quan.bind('<Button-1>',onclick3)
enter_quan.pack()
#entrybox for name of product
enter_name = Entry(root,font="Forte 20 bold",width=20)
enter_name.insert(0,'Enter Name')
on_click_id_4 = enter_name.bind('<Button-1>',onclick4)
enter_name.pack()
#entrybox for price of a product
enter_prize = Entry(root,font="Forte 20 bold",width=20)
enter_prize.insert(0,'Enter Price')
on_click_id_5 = enter_prize.bind('<Button-1>',onclick5)
enter_prize.pack()
#insert button
button = Button(root, text='INSERT', command=getentryvalue,fg='white',font='Forte 20',bg="gray10",width=20)
button.pack(pady=10)
Output:
Now create a function getentryvalue() for handling the data
from tkinter import *
import xlsxwriter
from datetime import date
append_name = []
append_quan = []
append_prize = []
append_prize = []
append_peices = []
def onclick(event):
enter_billNo.delete(0,END)
def onclick1(event):
enter_customerName.delete(0,END)
def onclick2(event):
enter_peices.delete(0,END)
def onclick3(event):
enter_quan.delete(0,END)
def onclick4(event):
enter_name.delete(0,END)
def onclick5(event):
enter_prize.delete(0,END)
def getentryvalue():
append_quan.append(enter_quan.get())
append_name.append(enter_name.get())
append_prize.append(enter_prize.get())
append_peices.append(enter_peices.get())
enter_quan.delete(0,END)
enter_name.delete(0,END)
enter_prize.delete(0,END)
enter_peices.delete(0,END)
enter_peices.insert(0,"Enter Peices")
enter_quan.insert(0,'Enter Quantity')
enter_name.insert(0,'Enter Name')
enter_prize.insert(0,"Enter Price")
new_file = f"{enter_billNo.get()}.{enter_customerName.get()}.xlsx"
excel_sheet = xlsxwriter.Workbook(new_file)
new_sheet = excel_sheet.add_worksheet()
tot_billNo = f"BILL NO: {enter_billNo.get()}"
tot_date = f"DATE: {enter_date.get()}"
enter_customerName.get()
new_sheet.write("B2",enter_customerName.get())
new_sheet.write("E1",tot_date)
new_sheet.write("E2",tot_billNo)
new_sheet.write("A4,","Pieces")
new_sheet.write("B4","Quantity")
new_sheet.write("C4","Names")
new_sheet.write("D4","Prize")
new_sheet.write("E4","Total")
for item in range(len(append_peices)):
item_pieces = int(append_peices[item])
new_sheet.write(item+4,0,item_pieces)
for item in range(len(append_quan)):
j = int(append_quan[item])
new_sheet.write(item+4,1, j)
for item in range(len(append_name)):
new_sheet.write(item+4,2,append_name[item])
for item in range(len(append_prize)):
i = float(append_prize[item])
new_sheet.write(item+4,3,i)
try:
val_i = 5
for item in range(len(append_quan)):
forMula = f"=A{val_i}*B{val_i}*D{val_i}"
new_sheet.write_formula(item+4,4,forMula)
val_i += 1
new_val_1 = val_i
finally:
new_val_2 = f"E{new_val_1+1}"
forMula_1 = f"=SUM(E5:E{str(new_val_1)})"
new_sheet.write_formula(new_val_2,forMula_1)
excel_sheet.close()
if __name__ == '__main__':
root = Tk()
root.iconbitmap('icon.ico')
root.resizable(0, 0)
root.title("BILL MAKER ver 1.0 @dx4iot")
root.config(background="gray10")
enter_label = Label(root,text="BILL MAKER",font="Forte 20 bold",bg="gray10",fg="white",width=20)
enter_label.pack()
enter_billNo = Entry(root,font="Forte 20 bold",width=20)
enter_billNo.insert(0,'Enter Bill No')
on_click_id = enter_billNo.bind('<Button-1>',onclick)
enter_billNo.pack()
enter_date = Entry(root,font="Forte 20 bold",width=20)
enter_date.insert(0,date.today())
enter_date.pack()
enter_customerName = Entry(root,font="Forte 20 bold",width=20)
enter_customerName.insert(0,'Enter Customer Name')
on_click_id_1 = enter_customerName.bind('<Button-1>',onclick1)
enter_customerName.pack()
enter_peices = Entry(root,font="Forte 20 bold",width=20)
enter_peices.insert(0,'Enter Pieces')
on_click_id_2 = enter_peices.bind('<Button-1>',onclick2)
enter_peices.pack()
enter_quan = Entry(root,font="Forte 20 bold",width=20)
enter_quan.insert(0,'Enter Quantity')
on_click_id_3 = enter_quan.bind('<Button-1>',onclick3)
enter_quan.pack()
enter_name = Entry(root,font="Forte 20 bold",width=20)
enter_name.insert(0,'Enter Name')
on_click_id_4 = enter_name.bind('<Button-1>',onclick4)
enter_name.pack()
enter_prize = Entry(root,font="Forte 20 bold",width=20)
enter_prize.insert(0,'Enter Price')
on_click_id_5 = enter_prize.bind('<Button-1>',onclick5)
enter_prize.pack()
button = Button(root, text='INSERT', command=getentryvalue,fg='white',font='Forte 20',bg="gray10",width=20)
button.pack(pady=10)
root.mainloop()
Now for testing let's insert some values
Result:
