Système de gestion de vente au détail Python 3 Tkinter utilisant l'application de bureau de l'interface graphique de la base de données MySQL
login.py
from tkinter import*
from tkinter import font
from PIL import ImageTk,ImageDraw
import mysql.connector as connector
from tkinter import ttk,messagebox
class Login_window:
def __init__(self,root):
self.root=root
self.root.title("Login Window")
self.root.geometry("1350x700+0+0")
self.root.config(bg="#021e2f")
#============background colour===============#
left_lbl=Label(self.root,bg="#08A3D2",bd=0)
left_lbl.place(x=0,y=0,relheight=1,width=600)
#===========Frames====================#
login_frame=Frame(self.root,bg="white")
login_frame.place(x=250,y=100,width=800,height=500)
#============Title==================#
title=Label(login_frame,text="LOGIN HERE",font=("times new roman",30,"bold"),bg="white",fg="#08A3D2").place(x=250,y=50)
#==============Email=================#
email=Label(login_frame,text="EMAIL ADDRESS",font=("times new roman",20,"bold"),bg="white",fg="gray").place(x=250,y=150)
self.txt_email=Entry(login_frame,font=("times new roman",18,"bold"),bg="lightgray")
self.txt_email.place(x=250,y=190,width=350,height=35)
#==============Password================#
pass_=Label(login_frame,text="PASSWORD",font=("times new roman",20,"bold"),bg="white",fg="gray").place(x=250,y=250)
self.txt_pass=Entry(login_frame,font=("times new roman",18,"bold"),bg="lightgray")
self.txt_pass.place(x=250,y=290,width=350,height=35)
#=============Register button for new user================#
btn_reg=Button(login_frame,text="Register new Account?",command=self.register_window,font=("times new roman",14),bg="white",bd=0,fg="#B00857",cursor="hand2").place(x=250,y=330)
#=============Login=====================#
btn_login=Button(login_frame,text="Login",command=self.login,font=("times new roman",20,"bold"),fg="white",bg="#B00857",cursor="hand2").place(x=250,y=380,width=180,height=40)
def register_window(self):
#code to switch from current window to new window
self.root.destroy()
import register
def login(self):
if self.txt_email.get()=="" or self.txt_pass.get()=="":
messagebox.showerror("Error","All fields are required",parent=self.root)
else:
try:
con=connector.connect(host='localhost',port='3306',user='root',password='123456',database='retail')
cur=con.cursor()
cur.execute("select * from customer where email=%s and password=%s",(self.txt_email.get(),self.txt_pass.get()))
row=cur.fetchone()
if row==None:
messagebox.showerror("Error","Invalid Username and Password",parent=self.root)
else:
messagebox.showinfo("success","welcome",parent=self.root)
self.root.destroy()
import bill
con.close()
except Exception as es:
messagebox.showerror("Error",f"Error due to: {str(es)}",parent=self.root)
root=Tk()
obj=Login_window(root)
root.mainloop()registre.py
from tkinter import*
from PIL import Image,ImageTk
from tkinter import ttk,messagebox
import mysql.connector as connector
class Register:
def __init__(self,root):
self.root=root
self.root.title("Registration Window")
self.root.geometry("1350x700+0+0")
self.root.config(bg="#808080")
#====Bg Image===#
self.bg=ImageTk.PhotoImage(file="images/background.jpg")
bg=Label(self.root,image=self.bg).pack()
#====Register Frame===#
frame1=Frame(self.root,bg="white")
frame1.place(x=330,y=100,width=700,height=500)
title=Label(frame1,text="REGISTER HERE",font=("times new roman",20,"bold"),bg="white",fg="green").place(x=250,y=30)
#====First row========#
uname=Label(frame1,text="User Name",font=("times new roman",15,"bold"),bg="white",fg="gray").place(x=50,y=100)
self.txt_uname=Entry(frame1,font=("times new roman",15),bg="lightgray")
self.txt_uname.place(x=50,y=130,width=250)
gender=Label(frame1,text="Gender",font=("times new roman",15,"bold"),bg="white",fg="gray").place(x=370,y=100)
self.cmb_gender=ttk.Combobox(frame1,font=("times new roman",13),state='readonly',justify=CENTER)
self.cmb_gender['values']=("Select","Male","Female","Other")
self.cmb_gender.place(x=370,y=130,width=250)
self.cmb_gender.current(0)
#=====Second row====#
contact=Label(frame1,text="Contact No.",font=("times new roman",15,"bold"),bg="white",fg="gray").place(x=50,y=170)
self.txt_contact=Entry(frame1,font=("times new roman",15),bg="lightgray")
self.txt_contact.place(x=50,y=200,width=250)
email=Label(frame1,text="Email",font=("times new roman",15,"bold"),bg="white",fg="gray").place(x=370,y=170)
self.txt_email=Entry(frame1,font=("times new roman",15),bg="lightgray")
self.txt_email.place(x=370,y=200,width=250)
#=====Third row===#
password=Label(frame1,text="Password",font=("times new roman",15,"bold"),bg="white",fg="gray").place(x=50,y=240)
self.txt_password=Entry(frame1,font=("times new roman",15),bg="lightgray")
self.txt_password.place(x=50,y=270,width=250)
cpassword=Label(frame1,text="Conform Password",font=("times new roman",15,"bold"),bg="white",fg="gray").place(x=370,y=240)
self.txt_cpassword=Entry(frame1,font=("times new roman",15),bg="lightgray")
self.txt_cpassword.place(x=370,y=270,width=250)
#=======fourth row====#
btn_register=Button(frame1,text="Register Now ",font=("times new roman",13,"bold"),command=self.register_data,cursor="hand2",bg="green",fg="white").place(x=150,y=360)
self.btn_login=Button(frame1,text="Login",font=("times new roman",13,"bold"),command=self.login_window,cursor="hand2",bg="green",fg="white")
self.btn_login.place(x=370,y=360)
def login_window(self):
#code to switch from current window to new window
self.root.destroy()
import login
def clear(self):
self.txt_uname.delete(0,END)
self.cmb_gender.current(0)
self.txt_contact.delete(0,END)
self.txt_email.delete(0,END)
self.txt_password.delete(0,END)
self.txt_cpassword.delete(0,END)
#====fetch data to database=====#
def register_data(self):
if self.txt_uname.get()==""or self.cmb_gender.get()=="Select" or self.txt_contact.get()=="" or self.txt_email.get()=="" or self.txt_password.get()=="" or self.txt_cpassword.get()=="":
messagebox.showerror("Error","All Fields are Required",parent=self.root)
elif self.txt_password.get()!= self.txt_cpassword.get():
messagebox.showerror("Error","Password does not match with Conform Password",parent=self.root)
else:
try:
con=connector.connect(host='localhost',port='3306',user='root',password='123456',database='retail')
cur=con.cursor()
cur.execute("select * from customer where email =%s or phone=%s",(self.txt_email.get(),self.txt_contact.get()))
row=cur.fetchone()
#print(row)
if row!=None:
messagebox.showerror("Error","User already exist,please try another contact number and Email",parent=self.root)
else:
cur.execute("insert into customer (name,gender,phone,email,password) values(%s,%s,%s,%s,%s)",
(self.txt_uname.get(),
self.cmb_gender.get(),
self.txt_contact.get(),
self.txt_email.get(),
self.txt_password.get()
))
con.commit()
con.close()
messagebox.showinfo("success","Register successful",parent=self.root)
self.clear()
except Exception as es:
messagebox.showerror("Error",f"Error due to: {str(es)}",parent=self.root)
root=Tk()
obj=Register(root)
root.mainloop()facture.py
from tkinter import*
import math,random
from tkinter import messagebox
import mysql.connector as connector
class Bill_App:
def __init__(self,root):
self.root=root
self.root.geometry("1350x700+0+0")
self.root.title("Billing Software")
bg_color="#7E3817"
title=Label(self.root,text="Welcome",bd=12,relief=GROOVE,bg=bg_color,fg="white",font=("times new roman",30,"bold"),pady=2).pack(fill=X)
#=======================Variable===================
#=======================Cosmetics==================
self.soap=IntVar()
self.face_wash=IntVar()
self.cream=IntVar()
self.shampoo=IntVar()
#=======================Grocery=====================
self.wheat=IntVar()
self.rice=IntVar()
self.oats=IntVar()
self.sugar=IntVar()
#=======================Snacks======================
self.lays=IntVar()
self.frooti=IntVar()
self.chocolate=IntVar()
self.colddrink=IntVar()
#======================Total========================
self.total_Cosmetics=StringVar()
self.tota_Grocery=StringVar()
self.total_Snacks=StringVar()
#==================function for customer name===========
self.c_bank=StringVar()
self.c_account=StringVar()
self.bill_no=StringVar()
x=random.randint(1000,9999)
self.bill_no.set(str(x))
self.cphone=StringVar()
#==================Customer Detail Frame=================
F1=LabelFrame(self.root,bd=10,relief=GROOVE,text="Bank Details",font=("times new roman",12,"bold"),fg="gold",bg=bg_color)
F1.place(x=0,y=80,relwidth=1)
cname_lbl=Label(F1,text="Bank Name",bg=bg_color,fg="white",font=("times new roman",18,"bold")).grid(row=0,column=0,padx=20,pady=5)
cname_txt=Entry(F1,width=15,textvariable=self.c_bank,font="arial 15",bd=7,relief=SUNKEN).grid(row=0,column=1,pady=5,padx=10)
cphn_lbl=Label(F1,text="Account No.",bg=bg_color,fg="white",font=("times new roman",18,"bold")).grid(row=0,column=2,padx=20,pady=5)
cname_txt=Entry(F1,width=20,textvariable=self.c_account,font="arial 15",bd=7,relief=SUNKEN).grid(row=0,column=3,padx=10,pady=5)
cphone=Label(F1,text="Phone Number",bg=bg_color,fg="white",font=("times new roman",18,"bold")).grid(row=0,column=4,padx=20,pady=5)
cname_txt=Entry(F1,width=20,textvariable=self.cphone,font="arial 15",bd=7,relief=SUNKEN).grid(row=0,column=5,padx=10,pady=5)
#bill_btn=Button(F1,text="Search",width=10,bd=7,font="arial 12 bold").grid(row=0,column=6,padx=10,pady=10)
# #===================Cosmetic Frame========================
F2=LabelFrame(self.root,bd=10,relief=GROOVE,text="Cosmetics",font=("times new roman",15,"bold"),fg="gold",bg=bg_color)
F2.place(x=5,y=180,width=325,height=380)
soap_lbl=Label(F2,text="Soap",bg=bg_color,fg="lightgreen",font=("times new roman",18,"bold")).grid(row=0,column=0,padx=10,pady=10,sticky="w")
soap_txt=Entry(F2,width=10,textvariable=self.soap,font=("times new roman",18,"bold"),bd=5,relief=SUNKEN).grid(row=0,column=1,padx=10,pady=10)
face_wash_lbl=Label(F2,text="Face Wash",bg=bg_color,fg="lightgreen",font=("times new roman",18,"bold")).grid(row=1,column=0,padx=10,pady=10,sticky="w")
face_wash_txt=Entry(F2,width=10,textvariable=self.face_wash,font=("times new roman",18,"bold"),bd=7,relief=SUNKEN).grid(row=1,column=1,padx=10,pady=10)
cream_lbl=Label(F2,text="Cream",bg=bg_color,fg="lightgreen",font=("times new roman",18,"bold")).grid(row=2,column=0,padx=10,pady=10,sticky="w")
cream_txt=Entry(F2,width=10,textvariable=self.cream,font=("times new roman",18,"bold"),bd=7,relief=SUNKEN).grid(row=2,column=1,padx=10,pady=10)
shampoo_lbl=Label(F2,text="Shampoo",bg=bg_color,fg="lightgreen",font=("times new roman",18,"bold")).grid(row=3,column=0,padx=10,pady=10,sticky="w")
shampoo_txt=Entry(F2,width=10,textvariable=self.shampoo,font=("times new roman",18,"bold"),bd=7,relief=SUNKEN).grid(row=3,column=1,padx=10,pady=10)
# #====================Grocery Frame=======================================
F3=LabelFrame(self.root,bd=10,relief=GROOVE,text="Grocery",font=("times new roman",15,"bold"),fg="gold",bg=bg_color)
F3.place(x=340,y=180,width=325,height=380)
g1_lbl=Label(F3,text="Wheat",bg=bg_color,fg="lightgreen",font=("times new roman",18,"bold")).grid(row=0,column=0,padx=10,pady=10,sticky="w")
g1_txt=Entry(F3,width=10,textvariable=self.wheat,font=("times new roman",18,"bold"),bd=7,relief=SUNKEN).grid(row=0,column=1,padx=10,pady=10)
g2_lbl=Label(F3,text="Rice",bg=bg_color,fg="lightgreen",font=("times new roman",18,"bold")).grid(row=1,column=0,padx=10,pady=10,sticky="w")
g2_txt=Entry(F3,width=10,textvariable=self.rice,font=("times new roman",18,"bold"),bd=7,relief=SUNKEN).grid(row=1,column=1,padx=10,pady=10)
g3_lbl=Label(F3,text="Oats",bg=bg_color,fg="lightgreen",font=("times new roman",18,"bold")).grid(row=2,column=0,padx=10,pady=10,sticky="w")
g3_txt=Entry(F3,width=10,textvariable=self.oats,font=("times new roman",18,"bold"),bd=7,relief=SUNKEN).grid(row=2,column=1,padx=10,pady=10)
g4_lbl=Label(F3,text="Sugar",bg=bg_color,fg="lightgreen",font=("times new roman",18,"bold")).grid(row=3,column=0,padx=10,pady=10,sticky="w")
g4_txt=Entry(F3,width=10,textvariable=self.sugar,font=("times new roman",18,"bold"),bd=7,relief=SUNKEN).grid(row=3,column=1,padx=10,pady=10)
# #===================Snacks Frame============================================
F4=LabelFrame(self.root,bd=10,relief=GROOVE,text="Snacks",font=("times new roman",15,"bold"),fg="gold",bg=bg_color)
F4.place(x=670,y=180,width=325,height=380)
c1_lbl=Label(F4,text="lays",bg=bg_color,fg="lightgreen",font=("times new roman",18,"bold")).grid(row=0,column=0,padx=10,pady=10,sticky="w")
c1_txt=Entry(F4,width=10,textvariable=self.lays,font=("times new roman",18,"bold"),bd=7,relief=SUNKEN).grid(row=0,column=1,padx=10,pady=10)
c2_lbl=Label(F4,text="frooti",bg=bg_color,fg="lightgreen",font=("times new roman",18,"bold")).grid(row=1,column=0,padx=10,pady=10,sticky="w")
c2_txt=Entry(F4,width=10,textvariable=self.frooti,font=("times new roman",18,"bold"),bd=7,relief=SUNKEN).grid(row=1,column=1,padx=10,pady=10)
c3_lbl=Label(F4,text="chocolate",bg=bg_color,fg="lightgreen",font=("times new roman",18,"bold")).grid(row=2,column=0,padx=10,pady=10,sticky="w")
c3_txt=Entry(F4,width=10,textvariable=self.chocolate,font=("times new roman",18,"bold"),bd=7,relief=SUNKEN).grid(row=2,column=1,padx=5,pady=10)
c4_lbl=Label(F4,text="colddrink",bg=bg_color,fg="lightgreen",font=("times new roman",18,"bold")).grid(row=3,column=0,padx=10,pady=10,sticky="w")
c4_txt=Entry(F4,width=10,textvariable=self.colddrink,font=("times new roman",18,"bold"),bd=7,relief=SUNKEN).grid(row=3,column=1,padx=10,pady=10)
# #===========================Bill Area=========================================
F5=Frame(self.root,bd=10,relief=GROOVE)
F5.place(x=1010,y=180,width=350,height=380)
bill_title=Label(F5,text="Bill Area",font=("arial",15,"bold"),bd=7,relief=GROOVE).pack(fill=X)
scrol_y=Scrollbar(F5,orient=VERTICAL)
self.txtarea=Text(F5,yscrollcommand=scrol_y.set)
scrol_y.pack(side=RIGHT,fill=Y)
scrol_y.config(command=self.txtarea.yview)
self.txtarea.pack(fill=BOTH,expand=1)
# #==========================Button Frame=======================================
F6=LabelFrame(self.root,bd=10,relief=GROOVE,text="Bill menu",font=("times new roman",15,"bold"),fg="gold",bg=bg_color)
F6.place(x=0,y=560,relwidth=1,height=140)
m1_lbl=Label(F6,text="Total Cosmetic Price",bg=bg_color,fg="white",font=("times new roman",18,"bold")).grid(row=0,column=0,padx=10,pady=1,sticky="w")
m1_txt=Entry(F6,width=18,textvariable=self.total_Cosmetics,font="arial 10 bold",bd=7,relief=SUNKEN).grid(row=0,column=1,padx=10,pady=1)
m2_lbl=Label(F6,text="Total Grocery Price",bg=bg_color,fg="white",font=("times new roman",18,"bold")).grid(row=1,column=0,padx=10,pady=1,sticky="w")
m2_txt=Entry(F6,width=18,textvariable=self.tota_Grocery,font="arial 10 bold",bd=7,relief=SUNKEN).grid(row=1,column=1,padx=10,pady=1)
m3_lbl=Label(F6,text="Total snacks Price",bg=bg_color,fg="white",font=("times new roman",18,"bold")).grid(row=2,column=0,padx=10,pady=1,sticky="w")
m3_txt=Entry(F6,width=18,textvariable=self.total_Snacks,font="arial 10 bold",bd=7,relief=SUNKEN).grid(row=2,column=1,padx=10,pady=1)
btn_F=Frame(F6,bd=7,relief=GROOVE)
btn_F.place(x=450,width=820,height=105)
total_btn=Button(btn_F,command=self.total,text="Total",bg="cadetblue",fg="white",bd=2,pady=15,width=15,font="arial 15 bold").grid(row=0,column=0,padx=5,pady=10)
Gbill_btn=Button(btn_F,text="Generate bill",command=self.bill_area,bg="cadetblue",fg="white",bd=2,pady=15,width=15,font="arial 15 bold").grid(row=0,column=1,padx=5,pady=10)
clear_btn=Button(btn_F,text="clear",command=self.clear_data,bg="cadetblue",fg="white",bd=2,pady=15,width=15,font="arial 15 bold").grid(row=0,column=2,padx=5,pady=10)
Exit_btn=Button(btn_F,text="Exit",command=self.Exit_app,bg="cadetblue",fg="white",bd=2,pady=15,width=15,font="arial 15 bold").grid(row=0,column=3,padx=5,pady=10)
self.welcome_bill()
def total(self):
self.c_s_p=self.soap.get()*40
self.c_fw_p=self.face_wash.get()*120
self.c_c_p=self.cream.get()*60
self.c_sh_p=self.shampoo.get()*180
self.total_Cosmetic_price=(
self.c_s_p+
self.c_fw_p+
self.c_c_p+
self.c_sh_p
)
self.total_Cosmetics.set("Rs " + str(self.total_Cosmetic_price))
self.g_w_p=self.wheat.get()*30
self.g_r_p=self.rice.get()*60
self.g_o_p=self.oats.get()*80
self.g_s_p=self.sugar.get()*40
self.tota_Grocery_price=(
self.g_w_p+
self.g_r_p+
self.g_o_p+
self.g_s_p
)
self.tota_Grocery.set("Rs " + str(self.tota_Grocery_price))
self.s_l_p=self.lays.get()*40
self.s_f_p=self.frooti.get()*120
self.s_ch_p=self.chocolate.get()*60
self.s_c_p=self.colddrink.get()*180
self.total_Snacks_price=(
self.s_l_p+
self.s_f_p+
self.s_ch_p+
self.s_c_p
)
self.total_Snacks.set("Rs " + str(self.total_Snacks_price))
self.Total_bill=self.total_Cosmetic_price+self.tota_Grocery_price+self.total_Snacks_price
def welcome_bill(self):
self.txtarea.delete('1.0',END)
self.txtarea.insert(END,"t tVISIT AGAIN n")
self.txtarea.insert(END,f"n Bill Number : {self.bill_no.get()}")
self.txtarea.insert(END,f"n Bank Name : {self.c_bank.get()}")
self.txtarea.insert(END,f"n Account Number : {self.c_account.get()}")
self.txtarea.insert(END,"n######################################")
self.txtarea.insert(END,"t ProductttQTYttprice")
self.txtarea.insert(END,"n######################################")
def bill_area(self):
if self.c_bank.get()=="" or self.c_account.get()=="":
messagebox.showerror("Error","Enter details")
elif self.total_Cosmetics.get()=="Rs 0" and self.tota_Grocery.get()=="Rs 0" and self.total_Snacks.get()=="Rs 0":
messagebox.showerror("Error","No item purchased")
else:
self.welcome_bill()
con=connector.connect(host='localhost',port='3306',user='root',password='123456',database='retail')
cur=con.cursor()
#=============costmatics details =================
if self.soap.get()!=0:
self.txtarea.insert(END,f"n Soaptt{self.soap.get()}tt{self.c_s_p}")
cur.execute("insert into pro_bill (billno,pid) values(%s,%s)",
(self.bill_no.get(),
1001
))
con.commit()
cur.execute("update product set stock = stock - %s where pid = %s and stock > %s",
(
self.soap.get(),
1001,0)
)
con.commit()
if self.face_wash.get()!=0:
self.txtarea.insert(END,f"n face washtt{self.face_wash.get()}tt{self.c_fw_p}")
cur.execute("insert into pro_bill (billno,pid) values(%s,%s)",
(self.bill_no.get(),
1002
))
con.commit()
cur.execute("update product set stock = stock - %s where pid = %s and stock > %s",
(
self.soap.get(),
1002,0)
)
con.commit()
if self.cream.get()!=0:
self.txtarea.insert(END,f"n Creamtt{self.cream.get()}tt{self.c_c_p}")
cur.execute("insert into pro_bill (billno,pid) values(%s,%s)",
(self.bill_no.get(),
1003
))
con.commit()
cur.execute("update product set stock = stock - %s where pid = %s and stock > %s",
(
self.soap.get(),
1003,0)
)
con.commit()
if self.shampoo.get()!=0:
self.txtarea.insert(END,f"n Shampoott{self.shampoo.get()}tt{self.c_sh_p}")
cur.execute("insert into pro_bill (billno,pid) values(%s,%s)",
(self.bill_no.get(),
1004
))
con.commit()
cur.execute("update product set stock = stock - %s where pid = %s and stock > %s",
(
self.soap.get(),
1004,0)
)
con.commit()
#========================grocery===================
if self.wheat.get()!=0:
self.txtarea.insert(END,f"n Wheattt{self.wheat.get()}tt{self.g_w_p}")
cur.execute("insert into pro_bill (billno,pid) values(%s,%s)",
(self.bill_no.get(),
1005
))
con.commit()
cur.execute("update product set stock = stock - %s where pid = %s and stock > %s",
(
self.soap.get(),
1005,0)
)
con.commit()
if self.rice.get()!=0:
self.txtarea.insert(END,f"n ricett{self.rice.get()}tt{self.g_r_p}")
cur.execute("insert into pro_bill (billno,pid) values(%s,%s)",
(self.bill_no.get(),
1006
))
con.commit()
cur.execute("update product set stock = stock - %s where pid = %s and stock > %s",
(
self.soap.get(),
1006,0)
)
con.commit()
if self.oats.get()!=0:
self.txtarea.insert(END,f"n Oatstt{self.oats.get()}tt{self.g_o_p}")
cur.execute("insert into pro_bill (billno,pid) values(%s,%s)",
(self.bill_no.get(),
1007
))
con.commit()
cur.execute("update product set stock = stock - %s where pid = %s and stock > %s",
(
self.soap.get(),
1007,0)
)
con.commit()
if self.sugar.get()!=0:
self.txtarea.insert(END,f"n Sugertt{self.sugar.get()}tt{self.g_s_p}")
cur.execute("insert into pro_bill (billno,pid) values(%s,%s)",
(self.bill_no.get(),
1008
))
con.commit()
cur.execute("update product set stock = stock - %s where pid = %s and stock > %s",
(
self.soap.get(),
1008,0)
)
con.commit()
#=============snacks details =================
if self.lays.get()!=0:
self.txtarea.insert(END,f"n Laystt{self.lays.get()}tt{self.s_l_p}")
cur.execute("insert into pro_bill (billno,pid) values(%s,%s)",
(self.bill_no.get(),
1009
))
con.commit()
cur.execute("update product set stock = stock - %s where pid = %s and stock > %s",
(
self.soap.get(),
1009,0)
)
con.commit()
if self.frooti.get()!=0:
self.txtarea.insert(END,f"n frootitt{self.frooti.get()}tt{self.s_f_p}")
cur.execute("insert into pro_bill (billno,pid) values(%s,%s)",
(self.bill_no.get(),
1010
))
con.commit()
cur.execute("update product set stock = stock - %s where pid = %s and stock > %s",
(
self.soap.get(),
1010,0)
)
con.commit()
if self.chocolate.get()!=0:
self.txtarea.insert(END,f"n Chocalatett{self.chocolate.get()}tt{self.s_ch_p}")
cur.execute("insert into pro_bill (billno,pid) values(%s,%s)",
(self.bill_no.get(),
1011
))
con.commit()
cur.execute("update product set stock = stock - %s where pid = %s and stock > %s",
(
self.soap.get(),
1011,0)
)
con.commit()
if self.colddrink.get()!=0:
self.txtarea.insert(END,f"n Coldrinktt{self.colddrink.get()}tt{self.s_c_p}")
cur.execute("insert into pro_bill (billno,pid) values(%s,%s)",
(self.bill_no.get(),
1012
))
con.commit()
cur.execute("update product set stock = stock - %s where pid = %s and stock > %s",
(
self.soap.get(),
1012,0)
)
con.commit()
self.txtarea.insert(END,"n======================================")
if self.total_Cosmetics.get()!="Rs 0":
self.txtarea.insert(END,f"n Cosmetic Totalttt{self.total_Cosmetics.get()}")
cur.execute("insert into sup_bill (billno,sid) values(%s,%s)",
(self.bill_no.get(),
100
))
con.commit()
if self.tota_Grocery.get()!="Rs 0":
self.txtarea.insert(END,f"n Grocery Totalttt{self.tota_Grocery.get()}")
cur.execute("insert into sup_bill (billno,sid) values(%s,%s)",
(self.bill_no.get(),
200
))
con.commit()
if self.total_Snacks.get()!="Rs 0":
self.txtarea.insert(END,f"n Snacks Totalttt{self.total_Snacks.get()}")
cur.execute("insert into sup_bill (billno,sid) values(%s,%s)",
(self.bill_no.get(),
300
))
con.commit()
self.txtarea.insert(END,"n======================================")
self.txtarea.insert(END,f"n Total Bill: ttt Rs. {self.Total_bill}")
cur.execute("insert into bill (billno,total,c_phone) values(%s,%s,%s)",
(self.bill_no.get(),
self.Total_bill,
self.cphone.get()
))
cur.execute("insert into bank (acc_no,bankname,billno) values(%s,%s,%s)",
(
self.c_account.get(),
self.c_bank.get(),
self.bill_no.get()
))
con.commit()
con.close()
messagebox.showinfo("success","data stored successfully",parent=self.root)
def clear_data(self):
op=messagebox.askyesno("Clear","Do you really want to clear?")
if op>0:
self.soap.set(0)
self.face_wash.set(0)
self.cream.set(0)
self.shampoo.set(0)
self.wheat.set(0)
self.rice.set(0)
self.oats.set(0)
self.sugar.set(0)
self.lays.set(0)
self.frooti.set(0)
self.chocolate.set(0)
self.colddrink.set(0)
self.total_Cosmetics.set("")
self.tota_Grocery.set("")
self.total_Snacks.set("")
self.c_bank.set("")
self.c_account.set("")
self.bill_no.set("")
x=random.randint(1000,9999)
self.bill_no.set(str(x))
self.cphone.set("")
self.welcome_bill()
def Exit_app(self):
op=messagebox.askyesno("Exit","Do you really want to exit?")
if op>0:
self.root.destroy()
root=Tk()
obj=Bill_App(root)
root.mainloop()
