BILL MAKER IN PYTHON
It has now been seven years since I am exploring my ways in the world of New Age technology. In all these years, what is my favourite thing in the whole world? I would say my keyboard! If it’s a war, I got my code as the skill and my keyboard as the weapon. When I was a kid, I wondered what it would feel like to be a hacker. I kept feeding my curiosity in the bits and pieces. I was getting introduced with new things everyday and over time. All this passion has made me targeted towards my main objective, that is, to learn everything which is out there about computer. For now, I have got a good grip over Python, JavaScript, C and C++. I think the main reason for my motivation is that I strongly believe, if you keep your mind clear and devote yourself to pure learning, there will come a time when your own reality will get surrounded by your self-made uniqueness.
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:
