Super Market.py

import tkinter as tk
from prettytable import PrettyTable
from tkinter import messagebox
from tkinter import ttk
from PIL import ImageTk,Image
import mysql.connector as mysql

# importing all data from sql tables

ms=mysql.connect(host='localhost',user='root',passwd='22072003Rraki',database='grocery_list')
cursor=ms.cursor()


# Chaning Background code

main=tk.Tk()
main.state('zoomed')
main.title('Super Market')
main.iconbitmap(r'bucket-clipart-fruit-15.ico')
c=0
def bg():
    global c
    global bg1
    global img
    limg=[r'fruits1.jpg',r'fruits4.jpg',r'fruits5.jpg',r'fruits7.jpg',r'fruits8.jpg',r'fruits9.jpg',]
    img=ImageTk.PhotoImage(Image.open(limg[c%6]))
    bg1.configure(image=img)
    bg1.pack()
    main.after(5000,bg)
    c+=1
main.after(10,bg)
img=ImageTk.PhotoImage(Image.open(r'fruits1.jpg'))
bg1=tk.Label(main,image=img,highlightthickness=0)
bg1.pack()

#---------#---------#---------#---------#

# Heading Company Name

#---------#---------#---------#---------#

#Enter S.No and Name to Search for the item

s_no=tk.Entry(main,width=20,font='large_font')
s_no.place(x=15+30,y=150)
name=tk.Entry(main,width=75,font='large_font')
name.place(x=230+35,y=150)
s_no_text=tk.Label(main,text="S.No",font=("calibre",10,'bold'),height=1)
s_no_text.place(x=0+10,y=150.35)
s_no_text=tk.Label(main,text="Name",font=("calibre",10,'bold'),height=1)
s_no_text.place(x=200+22.5,y=150.35)
def name_focus(event):
    name.focus()
def s_no_focus(event):
    s_no.focus()
s_no.bind('<Right>',name_focus)
name.bind('<Left>',s_no_focus)

#---------#---------#---------#---------#

# Total Box
tt=0
total_box=tk.Canvas(main,height=173,bd=0,highlightthickness=0,width=429)
total_box.place(x=905+40,y=0)
total_l=tk.Label(main,text="₹" + str(tt),fg='red',font=("calibre",75))
total_l.place(x=1000,y=30)

#---------#---------#---------#---------#

# evrything to do with the list of items

ordinate=27
o=27
c1=0
l=[]
l_nolist=[]
l_qty=[]

list_items=tk.Canvas(main,width=0,height=0,bg='white',highlightthickness=0)
'''bar=tk.Scrollbar(list_items) 
bar.pack(side=tk.RIGHT,fill="y") 
   
bar=tk.Scrollbar(list_items,orient=tk.HORIZONTAL)
bar.pack(side=tk.BOTTOM,fill="x")'''

list_items.place(x=10,y=250)


DOUBLE=0
def rows(event):
       global tt,total_l
       global t
       if s_no.get()!="":
           num=s_no.get()       # mysql fetch vraiable for sno
           all_details=cursor.execute("select * from items where s_no=" + num)      
           data=cursor.fetchall()
       elif name.get()!="":
           name_initial=name_list.curselection()[0]    # mysql fetch vraiable for name
           name_final=name_list.get(name_initial)
           all_details=cursor.execute("select * from items where name='" + name_final + "'")      
           data=cursor.fetchall()
           name_list.destroy()
           rate_list.destroy()
       elif data_state:
            all_details=cursor.execute("select * from items where s_no=" + data_req.decode('utf-8')[0][-1:-6])
            data=cursor.fetchall()
            data.pop(-1)
        
       global ordinate
       global o
       global c1
       global l_nolist
       if (s_no.get() > str(25000) and s_no.get() < str(25101) and int(s_no.get()) not in l_nolist) or (name.get()!=""):

               
               name.delete(0,'end')
               n=ordinate
               l.append(data[0])
               fake=[]
               
               for no in l:
                   fake.append(no[0])
               l_nolist=fake
               fake=[]
               s_no.delete(0,'end')

               main_frame=tk.Frame(list_items)
               
               if len(l)<=3:
                   list_items.config(width=950,height=ordinate)

               elif len(l)==4:
                   def on_config(event):
                       list_items.configure(scrollregion=list_items.bbox('all'))
                   
                   main_frame.bind('<Configure>',on_config)
                   list_items.create_window((0,0), window=main_frame)
                   bar=tk.Scrollbar(list_items, command=list_items.yview) 
                   bar.place(x=200,y=200,relheight=1,anchor='ne')
                   list_items.configure(yscrollcommand=bar.set)
                   
               stuff1_sno=tk.Entry(list_items,width=16,font=('calibre',15))
               stuff1_sno.insert(0,data[0][0])
               stuff1_sno.config(state='disabled')
               stuff1_sno.place(x=0,y=ordinate-27)
               #grid(row=0,column=0)
               #place(x=0,y=ordinate-27)
               stuff1_name=tk.Entry(list_items,width=57,font=('calibre',15))
               stuff1_name.insert(0,data[0][1])
               stuff1_name.config(state='disabled')
               stuff1_name.place(x=74+40,y=ordinate-27)
               #grid(row=0,column=1)
               #place(x=74+40,y=ordinate-27)
               stuff1_rate=tk.Entry(list_items,width=25,font=('calibre',15))
               stuff1_rate.insert(0,data[0][2])
               stuff1_rate.config(state='disabled')
               stuff1_rate.place(x=64+404,y=ordinate-27)
               #grid(row=0,column=2)
               #place(x=64+404,y=ordinate-27)
               def quantity(event):
                   global main_frame
                   l_qty.append(float(stuff1_qty.get()))
                   global tt
                   s_no.focus()
                   def total(stuff1_sno, stuff1_name, stuff1_rate, stuff1_qty, stuff1_price):
                       global tt
                       global ordinate
                       global list_items
                       times=0
                       list_items.place_forget()
                       list_items=tk.Canvas(main,width=0,height=0,bg='white',highlightthickness=0)
                       list_items.place(x=10,y=250)
                       
                       if c1<=7:
                           h=list_items.winfo_height()
                       for bleh in l:
                           if str(stuff1_sno.get())==str(bleh[0]):
                               l.remove(bleh)
                               l_qty.remove(float(stuff1_qty.get()))
                       quan=stuff1_qty.get()
                       pri=stuff1_price.get()
                       tt-=float(pri[1:])
                       total_l.config(text="₹" + str(tt))
                       stuff1_sno.destroy()
                       stuff1_name.destroy()
                       stuff1_rate.destroy()
                       stuff1_qty.destroy()
                       stuff1_price.destroy()
                       n_=len(l)
                       ordinate=0
                       times=0
                       def redefining(times):
                           global ordinate
                           if times<len(l):
                               list_items.config(width=950)
                               n_1=len(l)
                               cursor.execute("select * from items where s_no=" + str(l[times][0]))
                               data_new=cursor.fetchall()
                               stuff1_sno=tk.Entry(list_items,width=16,font=('calibre',15))
                               stuff1_sno.insert(0,data_new[0][0])
                               stuff1_sno.config(state='disabled')
                               stuff1_sno.place(x=0,y=ordinate)
                               stuff1_name=tk.Entry(list_items,width=57,font=('calibre',15))
                               stuff1_name.insert(0,data_new[0][1])
                               stuff1_name.config(state='disabled')
                               stuff1_name.place(x=74+40,y=ordinate)
                               stuff1_rate=tk.Entry(list_items,width=25,font=('calibre',15))
                               stuff1_rate.insert(0,data_new[0][2])
                               stuff1_rate.config(state='disabled')
                               stuff1_rate.place(x=64+404,y=ordinate)

                               n=ordinate
                               def twofns1():
                                   dlt.destroy()
                                   total(stuff1_sno, stuff1_name, stuff1_rate, stuff1_qty, stuff1_price)
                                   
                               stuff1_qty=tk.Entry(list_items,width=10,font=('calibre',15))
                               stuff1_qty.insert(0,str(float(l[times][-1])))
                               stuff1_qty.config(state='disabled')
                               stuff1_qty.focus()
                               stuff1_qty.place(x=378+264,y=ordinate)
                               stuff1_qty.bind('<Return>',quantity)
                               stuff1_price=tk.Entry(list_items,width=12,font=('calibre',15))
                               stuff1_price.insert(0,str(int(data_new[0][2])*float(l[times][-1])))
                               stuff1_price.config(state='disabled')
                               stuff1_price.place(x=378+220+154,y=ordinate)
                               dlt=tk.Button(list_items,state="normal",width=2,height=1,relief='raised',command=twofns1,highlightthickness=0)
                               dlt.place(x=598+290+50,y=ordinate+2.25)
                               ordinate+=27
                               print(ordinate,'2')
                               list_items.config(height=ordinate)
                               times+=1
                               redefining(times)
                       redefining(times)
                       ordinate+=27
                       
                   if stuff1_qty.get()=="":
                       popup1=tk.Tk()
                       popup1.focus_set()
                       popup1.title('Error')
                       message=tk.Label(popup1,text='Please check the quantity entered',font=('calibre',10,'bold'))
                       message.pack()
                       ok1=tk.Button(popup1,text='Ok',command=lambda : [popup1.destroy(),stuff1_qty.focus()])
                       ok1.pack()
                       ok1.focus()
                   else:
                       print(l)
                       l[-1]+=(stuff1_qty.get(),)
                       print(l)
                       def twofns():
                           global ordinate
                           dlt.destroy()
                           total(stuff1_sno, stuff1_name, stuff1_rate, stuff1_qty, stuff1_price)
                           
                       stuff1_qty.config(state='disabled')
                       stuff1_price.config(state='normal')
                       stuff1_price.insert(0,"₹" + str(int(data[0][2])*float(stuff1_qty.get())))
                       total_l.config(text="₹" + str(tt+int(data[0][2])*float(stuff1_qty.get())))
                       stuff1_price.config(state='disabled')
                       tt+=int(data[0][2])*float(stuff1_qty.get())
                       dlt=tk.Button(list_items,state='normal',width=2,height=1,command=twofns,highlightthickness=0)
                       dlt.place(x=598+290,y=ordinate-24.75-27) 
 
               stuff1_qty=tk.Entry(main_frame,width=10,font=('calibre',15))
               stuff1_qty.focus()
               stuff1_qty.place(x=378+264,y=ordinate-27)
               stuff1_qty.bind('<Return>',quantity)
               stuff1_price=tk.Entry(main_frame,width=12,font=('calibre',15),state='disabled')
               stuff1_price.config(state='disabled')
               stuff1_price.place(x=378+220+154,y=ordinate-27)
    
               def double(event):
                   stuff1_qty.config(state='normal',bg='sky blue')
                   stuff1_qty.focus()

               ordinate+=27
               o+=27
               c1+=1

       else:
           messagebox.showerror("Name error","Please check the serial number entered")
           s_no.delete(0,'end')
           '''def dest(event):
                  popup.destroy()                  
              popup=tk.Tk()
              popup.focus_set()
              popup.title('Error')
              message=tk.Label(popup,text='Please check the serial number entered',font=('calibre',10,'bold'))
              message.pack()
              ok=tk.Button(popup,text='Ok',command=lambda : [popup.destroy(),clear(event)])
              ok.focus()
              ok.pack()
              ok.bind('<Return>',clear)
              ok.bind('<Return>',dest)'''
 
s_no.bind('<Return>', rows)                    

# search by name

l1=['']
space=25
e1=0
double=0
e2=0

def name_search(event):                     # main function for searching by name
    global down
    global e2
    down=0
    #print('whatup')
    global name_list
    global rate_list
    DOUBLE=1
    global n_s
    n_s=name.get()
    cursor.execute("select * from items where name like '" + str(n_s) + "%'")
    data_name_search=cursor.fetchall()
    data_name_search=sorted(data_name_search,key= lambda x: x[1])
    l1.append(name.get())
    '''if len(name.get())==2:
        print(n_s)
        n_s=n_s[0:-2]
        print(n_s)'''
    if name.get()!="" and len(name.get())==1 and "" in l1 :         # creating the listbox at the start of search
        
        name_list=tk.Listbox(main,bg='white',height=len(data_name_search)*1,width=50,font=('calibre',13,'bold'),highlightthickness=0)
        name_list.place(x=266,y=172)
        rate_list=tk.Listbox(main,bg='white',height=len(data_name_search)*1,width=10,font=('calibre',13,'bold'),highlightthickness=0)
        rate_list.place(x=718,y=172)
        def double_change(event):
            global e2
            global double
            double=0
        name_list.bind('<Return>',rows)
        for stuff in data_name_search:
            name_list.insert('end',stuff[1])
            rate_list.insert('end',stuff[2])
        double=1
        l1.clear()


    
    elif (name.get()!="" and len(name.get())>1 and "" not in l1) or (e2==1):     # continuing listbox data display
        l1.append(name.get())
        name_list.delete(0,'end')
        rate_list.delete(0,'end')
        name_list.config(height=len(data_name_search)*1)
        rate_list.config(height=len(data_name_search)*1)
        for stuff in data_name_search:
            name_list.insert('end',stuff[1])
            rate_list.insert('end',stuff[2])
        l1.clear()
        e2=0
        
    def binding(event):
        selection=name_list.curselection()
        t=name_list.get(selection[0])
        return t
    
    
    def godown(event):
        global down
        name_list.selection_set(down)
        name_list.activate(down)
        down+=1
        name_list.focus()
        
    def backspace(event):
        global e2
        if len(name.get())==2:
            e2=1
        if len(name.get())==1:
            name_list.destroy()
            rate_list.destroy()


    name.bind('<Down>',godown)              # binding key to name 
    name.bind('<BackSpace>',backspace)
    #name.bind('<>',act)
    return DOUBLE



    if len(data_name_search)==0:                 # if wrongly typed
        messagebox.showerror("Name Error","Please check your Entry")
        name.delete(0,'end')
        '''popup=tk.Tk()
        popup.title('ERROR')
        label_error=tk.Label(popup,text='Please check your Entry',font=('calibre',15,'bold'))
        label_error.pack()
        button_error=tk.Button(popup,text='ok',font=('calibre',15,'bold'),command=popup.destroy())
        button_error.pack()
        button_error.focus()
        name.delete(0,'end') '''  

name.bind('<KeyRelease>',name_search)

# MEMBERSHIP

def member():
    #bill()
    def checking(data_member):
        
        list_of_users=[]
        list_of_no=[]
        for i in data_member:
            list_of_users.append(i[0])
            list_of_no.append(i[1])
        print(list_of_users,list_of_no)
            
        if entry_member_name.get() in list_of_users or entry_member_no.get() in list_of_no:
            print('t')
            if entry_member_name.get()=="":
                print('y')
                for p in data_member:
                    if p[1]==entry_member_no.get():
                        user_Name=p[0]
                        entry_member_name.insert(0,p[0])
                        entry_member_name.config(state="disabled")
            else:
                print('yy')
                for p in data_member:
                    if p[0]==entry_member_name.get():
                        user_No=p[1]
                        entry_member_no.insert(0,user_No)
                        entry_member_no.config(state="disabled")
                
            def discount_total():
                ttt=float(total_l.cget("text")[1:])
                print(data_member)
                if ttt>1500 and float(data_member[0][2])>0:
                    ttt-=(float(data_member[0][2]/100))*ttt
                    print(ttt)
                    cursor.execute("update users set discount=discount+0.7 where mobile_number='" + data_member[0][1] + "'")
                    ms.commit()
                elif ttt>1000 and ttt<=1500 and float(data_member[0][2])>0:
                    ttt-=(float(data_member[0][2]/100))*ttt
                    print(ttt)
                    cursor.execute("update users set discount=discount+0.5 where mobile_number='" + data_member[0][1] + "'")
                    ms.commit()
                elif ttt>500 and ttt<=1000 and float(data_member[0][2])>0:
                    ttt-=(float(data_member[0][2]/100))*ttt
                    print(ttt)
                    cursor.execute("update users set discount=discount+0.2 where mobile_number='" + data_member[0][1] + "'")
                    ms.commit()
                total_p2.config(text="TOTAL : " + str(ttt))
                
            ok2.destroy()
            ok3=tk.Button(popup2,text="OK",font=('calibre',15,'bold'),command=discount_total)
            ok3.grid(row=3,column=2,sticky='e')

        
        else:
            print('h',data_member)
            def doublefns():
                popup2.destroy()
                member()
            msg=messagebox.askquestion("Error","please check the username entered or does the cudtomer wants his name to be registered")
            popup2.lift()
            if msg=='yes':
                ok2.destroy()
                def adding():
                    cursor.execute("insert into users (name,mobile_number,points,discount) values('" + entry_member_name.get() + "','" + entry_member_no.get() + "',0,0)")
                    ms.commit()
                    msg2=messagebox.showinfo(" ","successfully stored")
                    popup2.lift()
                    entry_member_name.delete(0,'end')
                    entry_member_no.delete(0,'end')
                ok4=tk.Button(popup2,text="OK",font=('calibre',15,'bold'),command=adding)
                ok4.grid(row=5,column=2,sticky='e')
                
            else:
                entry_member_name.delete(0,'end')
                entry_member_no.delete(0,'end')
                
                

    def users():
        global data_member
        if entry_member_name.get()!="":
            cursor.execute("select* from users where name=" + "'" + entry_member_name.get().lower() + "'" + ";")
            data_member=cursor.fetchall()
        else:
            cursor.execute("select* from users where mobile_number=" + "'" + entry_member_no.get().lower() + "'" + ";")
            data_member=cursor.fetchall()
    def doub():
        users()
        checking(data_member)
    def card_use():
        print("hey")
    popup2=tk.Tk()
    name_m=tk.Label(popup2,text="Name:",font=('verdana'))
    name_m.grid(row=0,column=1)
    entry_member_name=tk.Entry(popup2,width=50)
    entry_member_name.grid(row=0,column=2)
    entry_member_name.bind('<Return>',users)
    number=tk.Label(popup2,text="Phone Number:",font=('verdana'))
    number.grid(row=1,column=1)
    entry_member_no=tk.Entry(popup2,width=25)
    entry_member_no.grid(row=1,column=2,sticky='w')
    entry_member_no.bind('<Return>',users)
    ok2=tk.Button(popup2,text="CHECK",font=('calibre',15,'bold'),command=doub)
    ok2.grid(row=3,column=2,sticky='e')
    bill_final=PrettyTable()
    bill_final.field_names = ("PRODUCTS","RATE","QUANTITY","PRICE")
    for bill_items in l:
        bill_items+=(float(bill_items[-1])*float(bill_items[2]),)
        bill_final.add_row(list(bill_items)[1:])

    prdt=tk.Label(popup2,text=bill_final,font=('courier new',10))
    prdt.pack()
   
    def card_use(ttt):
        ttt=float(total_l.cget("text")[1:])
        phonenumber=input("enter your number")
        usage=int(input("enter amount to be deducted"))
        cursor.execute("select * from members where contact_number='" + phonenumber + "'")
        data_card=cursor.fetchall()
        print(len(data_card))
        amt_acc=data_card[0][4]
        amt_acc-=usage
        cursor.execute("update members set amt=amt-" + str(usage) + " where contact_number='" + phonenumber + "';")
        ms.commit()
        ttt-=usage
        total_p2.config(text="TOTAL : " + str(ttt))

    
    
    
    use_card=tk.Button(popup2,text="USE CARD",font=('verdana',20),command=lambda : card_use(ttt)).grid(row=1,column=3,stick='e')
    heading_bill=tk.Label(popup2,text="BILL",font=('verdana',30)).grid(row=0,column=0,sticky='s')
    total_p2=tk.Label(popup2,text="TOTAL : " + str(total_l.cget('text')[1:]),font=('verdana',20))
    total_p2.grid(row=5,column=0)

    

    '''bar=tk.Scrollbar(popup2) 
    bar.pack(side=tk.RIGHT,fill="y") 
   
    bar=tk.Scrollbar(popup2,orient=tk.HORIZONTAL)
    bar.pack(side=tk.BOTTOM,fill="x") '''
    
member_button=tk.Button(main,bg='snow',height=3,width=10,text="PAY BILL",font=('verdana',20),command=member)
member_button.place(x=1140+45,y=545+39)

# ACCOUNT CARD

def register():
    popup4=tk.Tk()
    popup4.title("REGISTRATION")
    popup4.geometry("300x170")
    ue=tk.StringVar()
    ae=tk.StringVar()
    pe=tk.StringVar()
    Pe=tk.StringVar()
    heading=tk.Label(popup4,text="REGISTERATION",font=("verdana",10,"bold")).grid(row=0,column=1,sticky="w")
    username_label=tk.Label(popup4,text="First Name         : ",font=("verdana",10)).grid(row=1,column=0,sticky="w")
    username_entry=tk.Entry(popup4,width=25)
    username_entry.grid(row=1,column=1)
    id_label=tk.Label(popup4,text="Password          : ",font=("verdana",10)).grid(row=2,column=0,sticky="w")
    id_entry=tk.Entry(popup4,width=25)
    id_entry.grid(row=2,column=1)
    address_label=tk.Label(popup4,text="Address            : ",font=("verdana",10)).grid(row=3,column=0,sticky="w")
    address_entry=tk.Entry(popup4,width=25)
    address_entry.grid(row=3,column=1)
    PHONE_label=tk.Label(popup4,text="Contact Number : ",font=("verdana",10)).grid(row=4,column=0)
    PHONE_entry=tk.Entry(popup4,width=25)
    PHONE_entry.grid(row=4,column=1)
    amt_label=tk.Label(popup4,text="Initial amount : ",font=("verdana",10)).grid(row=5,column=0)
    amt_entry=tk.Entry(popup4,width=25)
    amt_entry.grid(row=5,column=1)

    def store():
        try:
            cursor.execute("insert into members values('" + id_entry.get() + "','" + username_entry.get() + "','" + address_entry.get() + "','" + PHONE_entry.get() + "'," + amt_entry.get() + ")")
            ms.commit()
            r=messagebox.showinfo("SAVED","Your account has been saved")
            popup4.destroy()
        except:
            messagebox.showerror("data error","please enter limited data")
            
            
    button_register=tk.Button(popup4,text="Register",bg="snow",command=store).grid(row=6,column=1,sticky="ew")
    
acc_button=tk.Button(main,text="REGISTER",bg="snow",height=3,width=10,font=('verdana',20),command=register).place(x=1000,y=545+39)

def scanner():
    vid=cv2.VideoCapture(0)
    vid.set(3,640)
    vid.set(4,480)
    c=0

    while True:
        success, img=vid.read()
        for code in decode(img):
            if c==1:
                break
            else:
                data_req=code
                pts=np.array([code.polygon],np.int32)
                pts=pts.reshape(-1,1,2)
                cv2.polylines(img,[pts],True,(255,0,255),5)
                c=1

        cv2.imshow('Result',img)
        if cv2.waitKey(1) == 27:
            break
        elif c==1:
            break
    vid.release()
    cv2.destroyAllWindows()
    
scan=tk.Button(main,text="SCANNER",command=scanner,font=('verdana',20))
scan.place(x=1000,y=400)








tk.mainloop()