def createCheck(frame): water = ttk.Label(frame, text="Water: ") water.grid(column=1, row=1, sticky=(N)) waterEntry = ttk.Entry(frame) waterEntry.grid(column=3, row=1, sticky=(N)) waterEntry.insert(END, "(Litres)") temp = ttk.Label(frame, text="Temperature: ") temp.grid(column=1, row=3, sticky=(N)) tempEntry = ttk.Entry(frame) tempEntry.grid(column=3, row=3, sticky=(N)) tempEntry.insert(END, "(°C)") rating = ttk.Label(frame, text="Rating of Cleanliness: ") rating.grid(column=1, row=5, sticky=(N)) ratingEntry = ttk.Entry(frame) ratingEntry.grid(column=3, row=5, sticky=(N)) ratingEntry.insert(END, "(from 1 to 10)") time = ttk.Label(frame, text="Time Taken: ") time.grid(column=1, row=7, sticky=(N)) timeEntry = ttk.Entry(frame) timeEntry.grid(column=3, row=7, sticky=(N)) timeEntry.insert(END, "(Whole Minutes)") content.grid_columnconfigure(0, weight=1) content.grid_columnconfigure(2, weight=1) content.grid_columnconfigure(4, weight=1) content.grid_rowconfigure(0, weight=1) content.grid_rowconfigure(2, weight=1) content.grid_rowconfigure(4, weight=1) content.grid_rowconfigure(6, weight=1) content.grid_rowconfigure(8, weight=1)
def make_line_song(self, grid): play_now = Button(grid, text='>', bg='#444444', command=lambda: self.parent.play_now(self.track)) play_now.grid(row=self.i, column=0, sticky='nsew') title = Button(grid, text=self.track.name, bg='#444444', command=lambda: self.parent.queue(self.track)) title.grid(row=self.i, column=1, sticky='nsew') artist = Button(grid, text=self.track.artists[0].name, bg='#444444', command=lambda: self.parent.queue(result[i])) artist.grid(row=self.i, column=2, sticky='nsew') track_millis = self.track.duration/1000 track_time = '%d:%02d' %(track_millis/60, track_millis%60) time = Button(grid, text=track_time, bg='#444444', command=lambda: self.parent.queue(self.track)) time.grid(row=self.i, column=3, sticky='nsew')
def create_play_frame(self): self.play_frame = ttk.Frame(self.main_frame, padding=10, borderwidth=5, relief="ridge") self.play_frame.grid() speed_label = ttk.Label(self.play_frame, text='Speed:', font=("Times New Roman", 15), padding=30) scale = tkinter.Scale(self.play_frame, orient='horizontal', from_=0, to=100, command=self.print_value) energy_label = tkinter.Label(self.play_frame, text='Energy Remaing:', font=("Times New Roman", 15)) energy = ttk.Label(self.play_frame, text='100%', font=("Times New Roman", 15), padding=30) time_label = ttk.Label(self.play_frame, text='Time elapsed: ', font=("Times New Roman", 15), padding=30) time = ttk.Label(self.play_frame, text='0', font=("Times New Roman", 15), padding=30) laps_label = ttk.Label(self.play_frame, text='Laps to go:', font=("Times New Roman", 15), padding=30) laps = ttk.Label(self.play_frame, text='3', font=("Times New Roman", 15), padding=30) speed_label.grid(row=0, column=0) scale.grid(row=0, column=1) energy_label.grid(row=1, column=0) energy.grid(row=1, column=1) time_label.grid(row=3, column=0) time.grid(row=3, column=1) laps_label.grid(row=4, column=0) laps.grid(row=4, column=1)
def make_line_song(self, grid): play_now = Button(grid, text='>', bg='#444444', command=lambda: self.parent.play_now(self.track)) play_now.grid(row=self.i, column=0, sticky='nsew') title = Button(grid, text=self.track.name, bg='#444444', command=lambda: self.parent.queue(self.track)) title.grid(row=self.i, column=1, sticky='nsew') artist = Button(grid, text=self.track.artists[0].name, bg='#444444', command=lambda: self.parent.queue(result[i])) artist.grid(row=self.i, column=2, sticky='nsew') track_millis = self.track.duration / 1000 track_time = '%d:%02d' % (track_millis / 60, track_millis % 60) time = Button(grid, text=track_time, bg='#444444', command=lambda: self.parent.queue(self.track)) time.grid(row=self.i, column=3, sticky='nsew')
def home(): window = Tk() window.title("HOME") window.geometry("520x440") window.configure(background="#8e5f3a") topframe = Frame(window) topframe.pack() bottomframe = Frame(window) bottomframe.pack(side=BOTTOM) ########################################MAIN FRAME########################################### notebook = ttk.Notebook(topframe) frame1 = ttk.Frame(notebook) frame2 = ttk.Frame(notebook) frame3 = ttk.Frame(notebook) frame4 = ttk.Frame(notebook) frame5 = ttk.Frame(notebook) notebook.add(frame1, text="Security") notebook.add(frame2, text='Flat occupancy') notebook.add(frame3, text='Bill') notebook.add(frame4, text='Parking') notebook.add(frame5, text='Register') ##########################################PARKING####################################### parkingframe = Frame(frame4) parkingframe.pack() parkingframeb = Frame(frame4) parkingframeb.pack(side=BOTTOM) pflatno = Label(parkingframe, text="Vehicle no") pflatno.pack() pentryflat = Entry(parkingframe) pentryflat.pack() def parkingsubmit(): mydb = mysql.connector.connect(host="localhost", database="Flat", user="******", passwd="4270307l") pdata1 = pentryflat.get() mycursor = mydb.cursor() sql = "SELECT * FROM flat WHERE vno=%s and vno1=%s" val = (pdata1, pdata1) mycursor.execute(sql, val) for i in mycursor: data = Label(parkingframeb, text="Vehicle Type") data.grid(row=1, column=0) data = Label(parkingframeb, text=i[7]) data.grid(row=1, column=1) data = Label(parkingframeb, text="Flat no") data.grid(row=2, column=0) data = Label(parkingframeb, text=i[0]) data.grid(row=2, column=1) data = Label(parkingframeb, text="Name") data.grid(row=3, column=0) data = Label(parkingframeb, text=i[1]) data.grid(row=3, column=1) data = Label(parkingframeb, text="Address") data.grid(row=4, column=0) data = Label(parkingframeb, text=i[2]) data.grid(row=4, column=1) data = Label(parkingframeb, text="Office address") data.grid(row=5, column=0) data = Label(parkingframeb, text=i[3]) data.grid(row=5, column=1) data = Label(parkingframeb, text="Phone") data.grid(row=6, column=0) data = Label(parkingframeb, text=i[4]) data.grid(row=6, column=1) data = Label(parkingframeb, text="Gov Id type") data.grid(row=7, column=0) data = Label(parkingframeb, text=i[5]) data.grid(row=7, column=1) data = Label(parkingframeb, text="Gov Id no.") data.grid(row=8, column=0) data = Label(parkingframeb, text=i[6]) data.grid(row=8, column=1) parking = Button(parkingframe, text="Submit", height=2, width=15, command=parkingsubmit) parking.pack() notebook.pack() #########################################REGISTER######################################## registerframe = Frame(frame5) registerframe.pack() enterusername = Label(registerframe, text="Enter Username") enterusername.pack() userentry = Entry(registerframe) userentry.pack() enterpass = Label(registerframe, text="Enter Password") enterpass.pack() passentry = Entry(registerframe) passentry.pack() def registersubmit(): mydb = mysql.connector.connect(host="localhost", database="Flat", user="******", passwd="4270307l") userdata = userentry.get() passdata = passentry.get() mycursor = mydb.cursor() if len(userdata) >= 4 and len(passdata) >= 4: messagebox.showinfo("REGISTER", "Kudos!! Successfully Registered") sql = "INSERT INTO login (username,pass) VALUES(%s,%s)" val = (userdata, passdata) mycursor.execute(sql, val) mydb.commit() else: messagebox.showinfo( "REGISTER", "Enter Username and password of length greater than or equal to 4 " ) registerbutton = Button(registerframe, text="Register", height=2, width=15, command=registersubmit) registerbutton.pack() notebook.pack() ########################################################################################## notebook = ttk.Notebook(frame1) frame11 = ttk.Frame(notebook) frame22 = ttk.Frame(notebook) frame33 = ttk.Frame(notebook) notebook.add(frame11, text="Guest Entry") notebook.add(frame22, text='Guest Exit ') notebook.add(frame33, text='Guest Details') #############################################GUEST ENTRY################################ flatno = Label(frame11, text="Flat") flatno.grid(row=2, column=0) entryflat = ttk.Combobox(frame11, values=[ "101", "102", "103", "104", "105", "106", "107", "108", "109", "110" ]) entryflat.set("Choose flat no") entryflat.grid(row=2, column=1) entrypersonname = Label(frame11, text="Enter Name of Guest") entrypersonname.grid(row=3, column=0) entrypersonnameentry = Entry(frame11) entrypersonnameentry.grid(row=3, column=1) entryphone = Label(frame11, text="Phone") entryphone.grid(row=6, column=0) entryphoneentry = Entry(frame11) entryphoneentry.grid(row=6, column=1) entryaddress = Label(frame11, text="Enter Address Of Guest") entryaddress.grid(row=4, column=0) entryaddressentry = Entry(frame11) entryaddressentry.grid(row=4, column=1) entrypurpose = Label(frame11, text="Purpose Of visit") entrypurpose.grid(row=5, column=0) entrypurposeentry = Entry(frame11) entrypurposeentry.grid(row=5, column=1) import time localtime = time.asctime(time.localtime(time.time())) intime = Label(frame11, text="In time is ") intime.grid(row=8, column=0) time = Label(frame11, text=localtime) time.grid(row=8, column=1) def guestsubmit(): mydb = mysql.connector.connect(host="localhost", database="Flat", user="******", passwd="4270307l") entry1 = entryflat.get() entry2 = entrypersonnameentry.get() entry3 = entryphoneentry.get() entry4 = entryaddressentry.get() entry5 = entrypurposeentry.get() mycursor = mydb.cursor() sql = "INSERT INTO GUEST (name,idflat,phone,address,purpose,intime,idflat2) VALUES(%s,%s,%s,%s,%s,%s,%s)" val = (entry2, entry1, entry3, entry4, entry5, localtime, entry1) mycursor.execute(sql, val) mydb.commit() submitguest = Button(frame11, text="submit", height=2, width=15, command=guestsubmit) submitguest.grid(row=10, column=1) #################################GUEST EXIT########################################################## guestexittop = Frame(frame22) guestexittop.pack() guestexitbottom = Frame(frame22) guestexitbottom.pack(side=BOTTOM) exitflatno = Label(guestexittop, text="Flat") exitflatno.grid(row=0, column=0) exitflat = ttk.Combobox(guestexittop, values=[ "101", "102", "103", "104", "105", "106", "107", "108", "109", "110" ]) exitflat.set("Choose flat no") exitflat.grid(row=0, column=1) def submitexit(): mydb = mysql.connector.connect(host="localhost", database="Flat", user="******", passwd="4270307l") exitdata = exitflat.get() mycursor = mydb.cursor() mycursor.execute( "SELECT * FROM guest WHERE idflat=%s and idflat2=%s and outtime is null", (exitdata, exitdata)) a = 0 for widget in guestexitbottom.winfo_children(): widget.grid_remove() radiobuttons = [] def shell(): for i in radiobuttons: print(i.get()) var = IntVar() for i in mycursor: import time localtime = time.asctime(time.localtime(time.time())) a += 1 for x in [i[0]]: Rbutton = Radiobutton(guestexitbottom, text=i[1], variable=var, value=x, command=shell) Rbutton.grid(row=a, column=0) radiobuttons.append(var) ################################### outtimelabel = Label(guestexittop, text="Out time") outtimelabel.grid(row=1, column=0) outtime = Label(guestexittop, text=localtime) outtime.grid(row=1, column=1) exitbutton = Button(guestexittop, text="Guest leaving", height=2, width=10) exitbutton.grid(row=1, column=2) ###################################### submitexitbutton = Button(guestexittop, text="submit", height=2, width=10, command=submitexit) submitexitbutton.grid(row=0, column=2) #####################################GUEST DETAILS#################################################### guestdetails = Frame(frame33) guestdetails.pack() guestdetailsbottom = Frame(frame33) guestdetailsbottom.pack(side=BOTTOM) guestD = Label(guestdetails, text="Flat") guestD.grid(row=0, column=0) flatdetails = ttk.Combobox(guestdetails, values=[ "101", "102", "103", "104", "105", "106", "107", "108", "109", "110" ], height=2, width=6) flatdetails.set("Choose") flatdetails.grid(row=1, column=0) fdateentry = Label(guestdetails, text="Date") fdateentry.grid(row=0, column=2) fdateentry = Entry(guestdetails, width="10") fdateentry.grid(row=1, column=2) monentry = Label(guestdetails, text="Month") monentry.grid(row=0, column=3) monthentry = ttk.Combobox(guestdetails, values=[ "jan", "feb", "mar", "apr", "may", "jun", "jul", "aug", "sep", "oct", "nov", "dec" ], height=2, width=6) monthentry.set("Month") monthentry.grid(row=1, column=3) yearentry = Label(guestdetails, text="Year") yearentry.grid(row=0, column=4) yearentry = Entry(guestdetails, width="10") yearentry.grid(row=1, column=4) def GDsubmit(): mydb = mysql.connector.connect(host="localhost", database="Flat", user="******", passwd="4270307l") GDentry1 = flatdetails.get() GDentry2 = fdateentry.get() GDentry3 = monthentry.get() GDentry4 = yearentry.get() mycursor = mydb.cursor() mycursor.execute( "SELECT * FROM guest WHERE intime LIKE %s and intime LIKE %s and intime LIKE %s and idflat=%s", ('%' + str(GDentry4), '%' + str(GDentry3) + '%', '%' + str(GDentry2) + '%', GDentry1)) found = mycursor.fetchone() if found: a = 1 namelabel = Label(guestdetailsbottom, text="name") namelabel.grid(row=0, column=0) for i in mycursor: a += 1 namelabel = Label(guestdetailsbottom, text=i[1]) namelabel.grid(row=a, column=0) else: messagebox.showinfo("GUEST DETAILS", "No guest came for this date for this flat") mydb.commit() submitguestdetails = Button(guestdetails, text="submit", height=2, width=6, command=GDsubmit) submitguestdetails.grid(row=2, column=4) notebook.pack() ####################################FLAT OCCUPANCY######################################################## notebook = ttk.Notebook(frame2) frame111 = ttk.Frame(notebook) frame222 = ttk.Frame(notebook) frame333 = ttk.Frame(notebook) notebook.add(frame111, text="Fill Flat") notebook.add(frame222, text='Vacant Flat ') notebook.add(frame333, text='Flat Details') ##########################################FILL FLAT##################################### chooseflat = Label(frame111, text="Flat") chooseflat.grid(row=2, column=0) flatfill = ttk.Combobox(frame111, values=[ "101", "102", "103", "104", "105", "106", "107", "108", "109", "110" ]) flatfill.set("Choose flat no") flatfill.grid(row=2, column=1) personnamefill = Label(frame111, text="Enter Name of person") personnamefill.grid(row=3, column=0) personnameentryfill = Entry(frame111) personnameentryfill.grid(row=3, column=1) addressfill = Label(frame111, text="Enter Address") addressfill.grid(row=4, column=0) addressentryfill = Entry(frame111) addressentryfill.grid(row=4, column=1) oaddfill = Label(frame111, text="Enter Office Address") oaddfill.grid(row=5, column=0) oaddentryfill = Entry(frame111) oaddentryfill.grid(row=5, column=1) phonefill = Label(frame111, text="Phone") phonefill.grid(row=6, column=0) phoneentryfill = Entry(frame111) phoneentryfill.grid(row=6, column=1) govidfill = Label(frame111, text="Govt Id Type") govidfill.grid(row=7, column=0) govidtypefill = ttk.Combobox( frame111, values=["DL", "Aadhar", "PAN", "Voter ID", "Ration Card"]) govidtypefill.set("Choose Govt Id") govidtypefill.grid(row=7, column=1) gov = Label(frame111, text="Govt Id no.") gov.grid(row=8, column=0) goventryfill = Entry(frame111) goventryfill.grid(row=8, column=1) Vtype = Label(frame111, text="Vehicle Type") Vtype.grid(row=9, column=0) VtypeEntry = ttk.Combobox(frame111, values=[ "2 Wheeler", "4 Wheeler", ]) VtypeEntry.set("Choose") VtypeEntry.grid(row=9, column=1) vno = Label(frame111, text="Vehicle no.") vno.grid(row=10, column=0) vnoentry = Entry(frame111) vnoentry.grid(row=10, column=1) def fillsubmit(): print("hi") mydb = mysql.connector.connect(host="localhost", database="Flat", user="******", passwd="4270307l") entry1 = flatfill.get() entry2 = personnameentryfill.get() entry3 = addressentryfill.get() entry4 = oaddentryfill.get() entry5 = phoneentryfill.get() entry6 = govidtypefill.get() entry7 = goventryfill.get() entry8 = VtypeEntry.get() entry9 = vnoentry.get() mycursor = mydb.cursor() sql = "UPDATE flat SET name = %s, address=%s, officeadd=%s, phone=%s, govid=%s, govidno=%s, vtype=%s, vno=%s WHERE idflat= %s" val = (entry2, entry3, entry4, int(entry5), entry6, entry7, entry8, entry9, int(entry1)) mycursor.execute(sql, val) mydb.commit() submitfillflat = Button(frame111, text="submit", height=2, width=15, command=fillsubmit) submitfillflat.grid(row=11, column=1) ##########################################VACANT FLAT################################### flat = ttk.Combobox(frame222, values=[ "101", "102", "103", "104", "105", "106", "107", "108", "109", "110" ]) flat.set("Choose Flat No To Vaccant") flat.grid(row=1, column=0) def submit(): if int(flat.get()) >= 101: headingLabel = Label(frame222, text="Successfully Vacant !!!!") headingLabel.grid(row=2, column=0) mydb = mysql.connector.connect(host="localhost", database="Flat", user="******", passwd="4270307l") entry = flat.get() mycursor = mydb.cursor() sql = "UPDATE flat SET name = %s, address=%s, officeadd=%s, phone=%s, govid=%s, govidno=%s WHERE idflat= %s" val = (None, None, None, None, "None", "None", int(entry)) mycursor.execute(sql, val) mydb.commit() else: headingLabel = Label(frame222, text="Please Select flat no to vacant") headingLabel.grid(row=2, column=0) submit = Button(frame222, text="submit", height=2, width=15, command=submit) submit.grid(row=1, column=2) ########################################FLAT DETAILS################################ headingLabel = Label(frame333, text="Enter Flat No:") headingLabel.grid(row=1, column=0) flatEntry = Entry(frame333) flatEntry.grid(row=1, column=1) def buttonFlatOcupancy(): mydb = mysql.connector.connect(host="localhost", database="Flat", user="******", passwd="4270307l") mycursor = mydb.cursor() mycursor.execute("select * from flat ") entry = flatEntry.get() for i in mycursor: if i[0] == int(entry): if i[1] != None: data = Label(frame333, text="|Flat no|") data.grid(row=2, column=0) data = Label(frame333, text=i[0]) data.grid(row=2, column=1) data = Label(frame333, text="|Name|") data.grid(row=3, column=0) data = Label(frame333, text=i[1]) data.grid(row=3, column=1) data = Label(frame333, text="|Address|") data.grid(row=4, column=0) data = Label(frame333, text=i[2]) data.grid(row=4, column=1) data = Label(frame333, text="|Office address|") data.grid(row=5, column=0) data = Label(frame333, text=i[3]) data.grid(row=5, column=1) data = Label(frame333, text="|Phone|") data.grid(row=6, column=0) data = Label(frame333, text=i[4]) data.grid(row=6, column=1) data = Label(frame333, text="|Gov Id type|") data.grid(row=7, column=0) data = Label(frame333, text=i[5]) data.grid(row=7, column=1) data = Label(frame333, text="|Gov Id no.|") data.grid(row=8, column=0) data = Label(frame333, text=i[6]) data.grid(row=8, column=1) else: data = Label(frame333, text="Flat is empty!!") data.grid(row=2, column=1) buttonFlatOcupancy = Button(frame333, text="Submit", command=buttonFlatOcupancy) buttonFlatOcupancy.grid(row=1, column=3) notebook.pack() #######################################BILL############################################ notebook = ttk.Notebook(frame3) frame1111 = ttk.Frame(notebook) frame2222 = ttk.Frame(notebook) frame3333 = ttk.Frame(notebook) frame4444 = ttk.Frame(notebook) notebook.add(frame1111, text="Water Bill") notebook.add(frame2222, text='Electricity Bill') notebook.add(frame3333, text='Gas Bill') notebook.add(frame4444, text='View bill') wbflat = Label(frame1111, text="Flat") wbflat.grid(row=0, column=0) wbflat = ttk.Combobox(frame1111, values=[ "101", "102", "103", "104", "105", "106", "107", "108", "109", "110" ], height=2, width=6) wbflat.set("Choose") wbflat.grid(row=1, column=0) wbamountentry = Label(frame1111, text="Amount") wbamountentry.grid(row=0, column=2) wbamountentry = Entry(frame1111, width="10") wbamountentry.grid(row=1, column=2) wbmonentry = Label(frame1111, text="Month") wbmonentry.grid(row=0, column=3) wbmonthentry = ttk.Combobox(frame1111, values=[ "jan", "feb", "mar", "apr", "may", "jun", "jul", "aug", "sep", "oct", "nov", "dec" ], height=2, width=6) wbmonthentry.set("Month") wbmonthentry.grid(row=1, column=3) wbyearentry = Label(frame1111, text="Year") wbyearentry.grid(row=0, column=4) wbyearentry = Entry(frame1111, width="10") wbyearentry.grid(row=1, column=4) def WBsubmit(): mydb = mysql.connector.connect(host="localhost", database="Flat", user="******", passwd="4270307l") WBentry1 = wbflat.get() WBentry2 = wbamountentry.get() WBentry3 = wbmonthentry.get() WBentry4 = wbyearentry.get() WBentry5 = "W" mycursor = mydb.cursor() sql = "INSERT INTO bill (billtype,month,year,amount,idflat) VALUES(%s,%s,%s,%s,%s)" val = (WBentry5, WBentry3, WBentry4, WBentry2, WBentry1) mycursor.execute(sql, val) mydb.commit() messagebox.showinfo("WATER BILL", "Bill successfully updated") submitWB = Button(frame1111, text="submit", height=2, width=6, command=WBsubmit) submitWB.grid(row=2, column=4) ########################################ELECTRICITY BILL################################### ebflat = Label(frame2222, text="Flat") ebflat.grid(row=0, column=0) ebflat = ttk.Combobox(frame2222, values=[ "101", "102", "103", "104", "105", "106", "107", "108", "109", "110" ], height=2, width=6) ebflat.set("Choose") ebflat.grid(row=1, column=0) ebamountentry = Label(frame2222, text="Amount") ebamountentry.grid(row=0, column=2) ebamountentry = Entry(frame2222, width="10") ebamountentry.grid(row=1, column=2) ebmonentry = Label(frame2222, text="Month") ebmonentry.grid(row=0, column=3) ebmonthentry = ttk.Combobox(frame2222, values=[ "jan", "feb", "mar", "apr", "may", "jun", "jul", "aug", "sep", "oct", "nov", "dec" ], height=2, width=6) ebmonthentry.set("Month") ebmonthentry.grid(row=1, column=3) ebyearentry = Label(frame2222, text="Year") ebyearentry.grid(row=0, column=4) ebyearentry = Entry(frame2222, width="10") ebyearentry.grid(row=1, column=4) def EBsubmit(): mydb = mysql.connector.connect(host="localhost", database="Flat", user="******", passwd="4270307l") EBentry1 = ebflat.get() EBentry2 = ebamountentry.get() EBentry3 = ebmonthentry.get() EBentry4 = ebyearentry.get() EBentry5 = "E" mycursor = mydb.cursor() sql = "INSERT INTO bill (billtype,month,year,amount,idflat) VALUES(%s,%s,%s,%s,%s)" val = (EBentry5, EBentry3, EBentry4, EBentry2, EBentry1) mycursor.execute(sql, val) mydb.commit() messagebox.showinfo("ELECTRICITY BILL", "Bill successfully updated") submitEB = Button(frame2222, text="submit", height=2, width=6, command=EBsubmit) submitEB.grid(row=2, column=4) ########################################GAS########################################### gbflat = Label(frame3333, text="Flat") gbflat.grid(row=0, column=0) gbflat = ttk.Combobox(frame3333, values=[ "101", "102", "103", "104", "105", "106", "107", "108", "109", "110" ], height=2, width=6) gbflat.set("Choose") gbflat.grid(row=1, column=0) gbamountentry = Label(frame3333, text="Amount") gbamountentry.grid(row=0, column=2) gbamountentry = Entry(frame3333, width="10") gbamountentry.grid(row=1, column=2) gbmonentry = Label(frame3333, text="Month") gbmonentry.grid(row=0, column=3) gbmonthentry = ttk.Combobox(frame3333, values=[ "jan", "feb", "mar", "apr", "may", "jun", "jul", "aug", "sep", "oct", "nov", "dec" ], height=2, width=6) gbmonthentry.set("Month") gbmonthentry.grid(row=1, column=3) gbyearentry = Label(frame3333, text="Year") gbyearentry.grid(row=0, column=4) gbyearentry = Entry(frame3333, width="10") gbyearentry.grid(row=1, column=4) def GBsubmit(): mydb = mysql.connector.connect(host="localhost", database="Flat", user="******", passwd="4270307l") GBentry1 = gbflat.get() GBentry2 = gbamountentry.get() GBentry3 = gbmonthentry.get() GBentry4 = gbyearentry.get() GBentry5 = "G" mycursor = mydb.cursor() sql = "INSERT INTO bill (billtype,month,year,amount,idflat) VALUES(%s,%s,%s,%s,%s)" val = (GBentry5, GBentry3, GBentry4, GBentry2, GBentry1) mycursor.execute(sql, val) mydb.commit() messagebox.showinfo("GAS BILL", "Bill successfully updated") submitGB = Button(frame3333, text="submit", height=2, width=6, command=GBsubmit) submitGB.grid(row=2, column=4) #######################################BILL DETAILS##################################### dbtopframe = Frame(frame4444) dbtopframe.pack() dbbottomframe = Frame(frame4444) dbbottomframe.pack(side=BOTTOM) Dbflat = Label(dbtopframe, text="Flat") Dbflat.grid(row=0, column=0) Dbflat = ttk.Combobox(dbtopframe, values=[ "101", "102", "103", "104", "105", "106", "107", "108", "109", "110" ], height=2, width=6) Dbflat.set("Choose") Dbflat.grid(row=1, column=0) Dbmonentry = Label(dbtopframe, text="Month") Dbmonentry.grid(row=0, column=1) Dbmonthentry = ttk.Combobox(dbtopframe, values=[ "jan", "feb", "mar", "apr", "may", "jun", "jul", "aug", "sep", "oct", "nov", "dec" ], height=2, width=6) Dbmonthentry.set("Month") Dbmonthentry.grid(row=1, column=1) Dbyearentry = Label(dbtopframe, text="Year") Dbyearentry.grid(row=0, column=2) Dbyearentry = Entry(dbtopframe, width="10") Dbyearentry.grid(row=1, column=2) def submitDB(): mydb = mysql.connector.connect(host="localhost", database="Flat", user="******", passwd="4270307l") DBentry1 = Dbflat.get() DBentry3 = Dbmonthentry.get() DBentry4 = Dbyearentry.get() mycursor = mydb.cursor() sql = "SELECT * FROM bill where idflat=%s and month=%s and year= %s " val = (DBentry1, DBentry3, DBentry4) mycursor.execute(sql, val) value = [] for i in mycursor: if i[1] == 'W': waterbill = Label(dbbottomframe, text="Water bill") waterbill.grid(row=0, column=0, sticky="W") waterbill = Label(dbbottomframe, text=i[4]) waterbill.grid(row=0, column=1, sticky="W") value.append(int(i[4])) if i[1] == 'E': waterbill = Label(dbbottomframe, text="Electricity bill") waterbill.grid(row=1, column=0, sticky="W") waterbill = Label(dbbottomframe, text=i[4]) waterbill.grid(row=1, column=1, sticky="W") value.append(int(i[4])) if i[1] == 'G': waterbill = Label(dbbottomframe, text="Gas bill") waterbill.grid(row=2, column=0, sticky="W") waterbill = Label(dbbottomframe, text=i[4]) waterbill.grid(row=2, column=1, sticky="W") value.append(int(i[4])) line = Label(dbbottomframe, text="--------") line.grid(row=3, column=0, sticky="W") line = Label(dbbottomframe, text="--------") line.grid(row=3, column=1, sticky="W") total = Label(dbbottomframe, text="Total bill") total.grid(row=4, column=0, sticky="W") total = Label(dbbottomframe, text=sum(value)) total.grid(row=4, column=1, sticky="W") submitDB = Button(dbtopframe, text="submit", height=2, width=6, command=submitDB) submitDB.grid(row=1, column=3) notebook.pack() exitbutton = Button(bottomframe, text="EXIT", height=2, width=20, command=window.destroy) exitbutton.pack() window.mainloop()
fg='Steel Blue', bg='powder blue', bd=10, anchor='w') name.grid(row=0, column=0) LocalTime = time.asctime(time.localtime(time.time())) time = Label(TopFrame, text=LocalTime, font=('arial', 20, 'bold'), fg='steel blue', bg='powder blue', bd=10, anchor='w') time.grid(row=1, column=0) #################################### Left Part: order details ###################################################### ##### Methods ##### ''' f=open('ref_number.txt','r+') ref=f.read() ref_number =int(ref,10) f.truncate(0) f.seek(0) f.write(ref_number)''' ref_number = 1001
def make_window(self): var = { 'timestamp': StringVar(), 'dealmodel': StringVar(), 'maker': StringVar(), 'field1': StringVar(), 'field2': StringVar(), 'field3': StringVar() } self.app_frame = Frame(self.parent) output_frame = Frame(self.app_frame) text_frame = Frame(output_frame) data_frame = Frame(output_frame) output_frame.grid_rowconfigure(0) output_frame.grid_rowconfigure(1) output_frame.grid_rowconfigure(2) output_frame.grid_rowconfigure(3) output_frame.grid_columnconfigure(0, weight=1) output_frame.grid_columnconfigure(1, weight=1) text_frame.grid_rowconfigure(0) # timestamp text_frame.grid_rowconfigure(1) # DealModel addr text_frame.grid_rowconfigure(2) # maker addr text_frame.grid_rowconfigure(4) # field1 text_frame.grid_rowconfigure(5) # field2 text_frame.grid_rowconfigure(6) # field3 data_frame.grid_rowconfigure(0) # timestamp data_frame.grid_rowconfigure(1) # DealModel addr data_frame.grid_rowconfigure(2) # maker addr data_frame.grid_rowconfigure(3) # field1 data_frame.grid_rowconfigure(4) # field2 data_frame.grid_rowconfigure(5) # field3 data_frame.grid_rowconfigure(6) data_frame.grid_rowconfigure(7) time_lb = Label(text_frame, text='Timestamp:') # row 0 dm_lb = Label(text_frame, text='DealModel:') # row 1 mk_lb = Label(text_frame, text='Maker Adr:') # row 2 d1_lb = Label(text_frame, text='data_field1:') # row 3 d2_lb = Label(text_frame, text='data_field2:') # row 4 d3_lb = Label(text_frame, text='data_field3:') # row 5 time = Label(data_frame, textvariable=var['timestamp']) dm = Label(data_frame, textvariable=var['dealmodel']) mk = Label(data_frame, textvariable=var['maker']) d1 = Label(data_frame, textvariable=var['field1']) d2 = Label(data_frame, textvariable=var['field2']) d3 = Label(data_frame, textvariable=var['field3']) txid_label = Label(output_frame, text='TXID: ') txid_input = Entry(output_frame) go_btn = Button(output_frame, text='Load Data', command=lambda: self.get_order(txid_input.get(), var)) time_lb.grid(row=0, column=0, sticky=E) dm_lb.grid(row=1, column=0, sticky=E) mk_lb.grid(row=2, column=0, sticky=E) d1_lb.grid(row=3, column=0, sticky=E) d2_lb.grid(row=4, column=0, sticky=E) d3_lb.grid(row=5, column=0, sticky=E) time.grid(row=0, column=0, sticky=W) dm.grid(row=1, column=0, sticky=W) mk.grid(row=2, column=0, sticky=W) d1.grid(row=3, column=0, sticky=W) d2.grid(row=4, column=0, sticky=W) d3.grid(row=5, column=0, sticky=W) text_frame.grid(row=1, column=0) data_frame.grid(row=1, column=1) txid_label.grid(row=2, column=0) txid_input.grid(row=2, column=1) go_btn.grid(row=3, column=0) output_frame.pack() self.app_frame.pack() self.app_frame.mainloop()
def __init__(self, parent, controller): tk.Frame.__init__(self, parent) self.grid_columnconfigure(0, weight=1, minsize=MINSIZECOLUMN) self.grid_columnconfigure(1, weight=1, minsize=MINSIZECOLUMN) self.grid_columnconfigure(2, weight=1, minsize=MINSIZECOLUMN) self.grid_rowconfigure(2, weight=3, minsize=MINSIZEROW2) self.grid_rowconfigure(3, weight=1, minsize=MINSIZEROW3) title = tk.Label(self, text="Statistics", font=controller.headerFont) title.grid(pady=10, padx=10, columnspan=3, sticky="w") separator = ttk.Separator(self, orient=tk.HORIZONTAL) separator.grid(row=1, column=0, columnspan=3, sticky="ew") display = tk.Frame(self) display.grid(row=2, column=0) buttons = tk.Frame(self) #, borderwidth=5, relief=tk.GROOVE) buttons.grid(row=3, column=0, pady=0, padx=BUTTONFRAMEPADX, columnspan=3, sticky="w") grid1 = tk.Frame(display) grid1.pack() grid1.grid_columnconfigure(0, weight=1, minsize=250) grid1.grid_columnconfigure(1, weight=1, minsize=250) grid1.grid_columnconfigure(2, weight=1, minsize=250) global date, time, rrrr, ssss, div date = tk.Label(grid1, text="DD/MM/YYYY", font=controller.defaultFont) time = tk.Label(grid1, text="HH/MM", font=controller.defaultFont) rrrr = tk.Label(grid1, text="RRRR", font=controller.defaultFont) div = tk.Label(grid1, text="DIV", font=controller.defaultFont) ssss = tk.Label(grid1, text="SSSS", font=controller.defaultFont) date.grid(row=0, column=0, pady=20) time.grid(row=0, column=2, pady=20) rrrr.grid(row=1, column=0, pady=20) div.grid(row=1, column=1, pady=20) ssss.grid(row=1, column=2, pady=20) grid2 = tk.Frame(display) grid2.pack(pady=40) temp = tk.Label(grid2, text="TEMPERATURE :", font=controller.defaultFont) mxtemp = tk.Label(grid2, text="MAX TEMPERATURE :", font=controller.defaultFont) mntemp = tk.Label(grid2, text="MIN TEMPERATURE :", font=controller.defaultFont) global t1, t2, t3 t1 = tk.Label(grid2, text="XXX", font=controller.defaultFont) t2 = tk.Label(grid2, text="XXX", font=controller.defaultFont) t3 = tk.Label(grid2, text="XXX", font=controller.defaultFont) degree1 = tk.Label(grid2, text="*C", font=controller.defaultFont) degree2 = tk.Label(grid2, text="*C", font=controller.defaultFont) degree3 = tk.Label(grid2, text="*C", font=controller.defaultFont) temp.grid(row=0, column=0, sticky="e", pady=10) mxtemp.grid(row=1, column=0, sticky="e", pady=10) mntemp.grid(row=2, column=0, sticky="e", pady=10) t1.grid(row=0, column=1) t2.grid(row=1, column=1) t3.grid(row=2, column=1) degree1.grid(row=0, column=2) degree2.grid(row=1, column=2) degree3.grid(row=2, column=2) menuButton = ttk.Button(buttons, text="Menu", command=lambda: controller.show_frame(Menu)) menuButton.grid()
def configSingulersum(self, top): row = 0 column = 0 if top!=self and isinstance(top, Toplevel) is True: # coming from menu, settings placed in a Toplevel (new Window) top.title("configure Singulersum object") top.geometry( "{:d}x{:d}".format(800, int(800/4*2)) ) top.bind('<Escape>', lambda e: top.destroy()) else: # in settingsPanel, set title l=Label(top, text="settings panel") l.grid(row=row, column=column, sticky=W) row+=2 entries = [] label = Label(top, text="") label.grid(row=row, column=column, sticky=W) row+=1 label = Label(top, text="set time") label.grid(row=row, column=column, sticky=W) column+=1 time = Entry(top) time.insert(0, self.sg.time) entries.append( { "object":self.sg, "name":"time", "value":time, "type":"f" } ) time.grid(row=row, column=column, sticky=W) column=0 row+=1 label = Label(top, text="show coordinate system") label.grid(row=row, column=column, sticky=W) column+=1 coord = IntVar() coord.set(self.sg.showCoordinateSystem) coordck = Checkbutton(top, variable=coord) entries.append( { "object":self.sg, "name":"showCoordinateSystem", "value":coord, "type":"b" } ) coordck.grid(row=row, column=column, sticky=W) column=0 row+=1 label = Label(top, text="show bounding boxes") label.grid(row=row, column=column, sticky=W) column+=1 bbs = IntVar() bbs.set(self.sg.showBoundingBox) bbsck = Checkbutton(top, variable=bbs) entries.append( { "object":self.sg, "name":"showBoundingBox", "value":bbs, "type":"b" } ) bbsck.grid(row=row, column=column, sticky=W) column=0 row+=1 label = Label(top, text="show backside") label.grid(row=row, column=column, sticky=W) column+=1 bs = IntVar() bs.set(self.sg.showBackside) bsck = Checkbutton(top, variable=bs) entries.append( { "object":self.sg, "name":"showBackside", "value":bs, "type":"b" } ) bsck.grid(row=row, column=column, sticky=W) column=0 row+=1 column=0 row+=1 label = Label(top, text="polyOnlyGrid") label.grid(row=row, column=column, sticky=W) column+=1 po = IntVar() po.set(self.sg.polyOnlyGrid) pock = Checkbutton(top, variable=po) entries.append( { "object":self.sg, "name":"polyOnlyGrid", "value":po, "type":"b" } ) pock.grid(row=row, column=column, sticky=W) column=0 row+=1 button = Button(top, text="Apply", command=lambda: self.apply(top, entries, True)) button.grid(row=row, column=column, sticky=W) column+=1 button = Button(top, text="Cancel", command=lambda: self.apply(top, entries, False)) button.grid(row=row, column=column, sticky=W)
def createWidgets(self): #Dead Frame deadFrame = LabelFrame(self, text="Dead List") deadFrame.grid(row=50, column=0) for i in range(1,16): #Generate role variables temp = IntVar() temp.set(0) self.gui_deadList[i]['role'] = temp #Display Role Numbers role = Label(deadFrame, textvariable=self.gui_deadList[i]['role']) role.grid(row=i, column=0, sticky=W) #Generate role name variables temp = StringVar() temp.set("Unknown") self.gui_deadList[i]['rolename'] = temp #Display Role Names roleName = Label(deadFrame, textvariable=self.gui_deadList[i]['rolename']) roleName.grid(row=i, column=1, sticky=W) #Generate Name variables temp = StringVar() temp.set("playerName") self.gui_deadList[i]['name'] = temp #Display Name Labels name = Label(deadFrame, textvariable=self.gui_deadList[i]['name']) name.grid(row=i, column=2, sticky=W) #Generate LW variables temp = StringVar() temp.set("") self.gui_deadList[i]['lw'] = temp #Display LW Buttons LW = Button(deadFrame, text='LW') LW.grid(row=i, column=3, sticky=W) #Generate DN variables temp = StringVar() temp.set("") self.gui_deadList[i]['dn'] = temp #Display DN Buttons DN = Button(deadFrame, text='DN') DN.grid(row=i, column=4, sticky=W) #Generate Tooltip variables temp = StringVar() temp.set("") self.gui_deadList[i]['killers'] = temp #Enable Tooltip on player's name Tooltip = ListboxToolTip(name, ["Hello"]) #Chat Frame chatFrame = LabelFrame(self, text="Chat") chatFrame.grid(row=50, column=25) if True: self.chat = tkst.ScrolledText(chatFrame, wrap=WORD, width=30, height=23) self.chat.config(state=DISABLED) self.chat.grid(row=1, column=0, sticky=W) chatEntry = Entry(chatFrame, width=40, textvariable = self.chatBox) chatEntry.grid(row=10, column=0, sticky=W) #Time Frame timeFrame = LabelFrame(self, text="Time") timeFrame.grid(row=0, column=50) if True: time = Label(timeFrame, textvariable = self.time) time.grid(row=0, column=1, sticky=W) day = Label(timeFrame, textvariable = self.day) day.grid(row=0, column=2, sticky=W) spacer = Label(timeFrame, text=" | ") spacer.grid(row=0, column=3, sticky=W) timer = Label(timeFrame, textvariable = self.timeLeft) timer.grid(row=0, column=4, sticky=W) #Playerlist Frame playerlist = LabelFrame(self, text="Player List") playerlist.grid(row=50, column=50) for i in range(1,16): #Display Player Number num = Label(playerlist, text=i) num.grid(row=i+50, column=50, sticky=W) #Generate Name Variables temp = StringVar() temp.set("Player " + str(i) ) self.gui_playerList[i]['name'] = temp #Display Player Name Buttons nameBtn = Button(playerlist, textvariable = self.gui_playerList[i]['name']) nameBtn.config(width=20) nameBtn.grid(row=i+50, column=51, sticky=W) #Generate Vote Variables temp = IntVar() temp.set(0) self.gui_playerList[i]['votes'] = temp #Display Vote Counts voteZone = Label(playerlist, textvariable=self.gui_playerList[i]['votes']) voteZone.config(width=3) voteZone.grid(row=i+50, column=52, sticky=W) #Generate Action Variable temp = StringVar() temp.set("") self.gui_playerList[i]['choose'] = temp #Display Action Button actn = Button(playerlist, textvariable=self.gui_playerList[i]['choose']) actn.config(width=2) actn.grid(row=i+50, column=53) self.gui_playerList[i]['choosebutton'] = actn #Generate Role Variable temp = StringVar() temp.set("??") self.gui_playerList[i]['role'] = temp #Display Role / edit field. roleZone = Label(playerlist, textvariable=self.gui_playerList[i]['role']) roleZone.config(width=13) roleZone.grid(row=i+50, column=54, sticky=W)
hours = [ '00', '01', '02', '03', '04', '05', '06', '07', '08', '09', '10', '11', '12', '13', '14', '15', '16', '17', '18', '19', '20', '21', '22', '23' ] minutes = [ '00', '01', '02', '03', '04', '05', '06', '07', '08', '09', '10', '11', '12', '13', '14', '15', '16', '17', '18', '19', '20', '21', '22', '23', '24', '25', '26', '27', '28', '29', '30', '31', '32', '33', '34', '35', '36', '37', '38', '39', '40', '41', '42', '43', '44', '45', '46', '47', '48', '49', '50', '51', '52', '53', '54', '55', '56', '57', '58', '59', '60' ] root = tk.Tk() root.geometry('300x50') root.resizable(width=False, height=False) time = tk.Label(root, text=time_update()) time.grid() def update_text(): time['text'] = time_update() root.after(1000, update_text) root.after(1, update_text) root.mainloop()
start.grid(row=4, padx=20, pady=20) else: time.after(1000, countdown) root = Tk() root.title("COLOUR-GAME") root.geometry("500x500") l1 = Label(root, fg='red', text="Type the colour of word not colour of text", font=('Helventica', 18)) l1.grid(row=1, padx=20, pady=20) l2 = Label(root) l2.grid(row=5, padx=20, pady=20) score = Label(root, fg='blue', text="Press enter to start", font=('Helventica', 20)) score.grid(row=3, padx=20, pady=20) time = Label(root, text="Time left", font=('Helventica', 20)) time.grid(row=2, padx=20, pady=20) e = Entry(root) root.bind('<Return>', startgame) e.focus_set() e.grid(row=6, padx=20, pady=20) root.mainloop()
def newTab(self, location, deletable=True): widgets = {} if len(self.notebook.tabs()) > 0: self.notebook.forget(len(self.notebook.tabs()) - 1) page = Frame(self.notebook) try: info = self.getInfo(location) except WeatherError: self.locations.append(location) tabText = " Error " error = Label(page, text="Error loading content", font=(None, self.smallFontSize)) error.grid(row=0, column=0, padx=self.padding, pady=self.padding) widgets["error"] = error else: if deletable: self.locations.append(info["location"]) tabText = " " + info["city"] + " " locationFrame = Frame(page) locationFrame.grid(row=0, column=0, sticky="NSEW", pady=self.padding) location = Label(locationFrame, text=info["location"], font=(None, self.mediumFontSize)) location.grid(row=0, column=0, columnspan=4) widgets["location"] = location status = Label(locationFrame, text=info["status"], font=(None, self.smallFontSize)) status.grid(row=1, column=0, columnspan=4) widgets["status"] = status temperature = Label(locationFrame, text=info["temperature"], font=(None, self.largeFontSize)) temperature.grid(row=2, column=0, columnspan=4) widgets["temperature"] = temperature time = Label(locationFrame, text=info["time"], font=(None, self.smallFontSize)) time.grid(row=3, column=0, columnspan=4) widgets["time"] = time for i in range(locationFrame.grid_size()[0]): locationFrame.columnconfigure(i, weight=1) for i in range(locationFrame.grid_size()[1]): locationFrame.rowconfigure(i, weight=1) forecastFrame = Frame(page) forecastFrame.grid(row=1, column=0, sticky="NSEW", pady=self.padding) dateLabel = Label(forecastFrame, text="Date", font=(None, self.smallFontSize, "bold")) dateLabel.grid(row=0, column=0, sticky="W", padx=self.infoPadding) statusLabel = Label(forecastFrame, text="Status", font=(None, self.smallFontSize, "bold")) statusLabel.grid(row=0, column=1, sticky="W", padx=self.infoPadding) highLabel = Label(forecastFrame, text="High", font=(None, self.smallFontSize, "bold")) highLabel.grid(row=0, column=2, sticky="W", padx=self.infoPadding) lowLabel = Label(forecastFrame, text="Low", font=(None, self.smallFontSize, "bold")) lowLabel.grid(row=0, column=3, sticky="W", padx=self.infoPadding) forecast = [] for i in range(len(info["forecast"])): day = info["forecast"][i] date = Label(forecastFrame, text=day["date"], font=(None, self.smallFontSize)) date.grid(row=1 + i, column=0, sticky="W", padx=self.infoPadding) status = Label(forecastFrame, text=day["status"], font=(None, self.smallFontSize)) status.grid(row=1 + i, column=1, sticky="W", padx=self.infoPadding) high = Label(forecastFrame, text=day["high"], font=(None, self.smallFontSize)) high.grid(row=1 + i, column=2, sticky="W", padx=self.infoPadding) low = Label(forecastFrame, text=day["low"], font=(None, self.smallFontSize)) low.grid(row=1 + i, column=3, sticky="W", padx=self.infoPadding) forecast.append({ "date": date, "status": status, "high": high, "low": low }) widgets["forecast"] = forecast for i in range(forecastFrame.grid_size()[0]): forecastFrame.columnconfigure(i, weight=1) for i in range(forecastFrame.grid_size()[1]): forecastFrame.rowconfigure(i, weight=1) statsFrame = Frame(page) statsFrame.grid(row=2, column=0, sticky="NSEW", pady=self.padding) sunriseLabel = Label(statsFrame, text="Sunrise", font=(None, self.smallFontSize, "bold")) sunriseLabel.grid(row=0, column=0, sticky="W", padx=self.infoPadding) sunrise = Label(statsFrame, text=info["sunrise"], font=(None, self.smallFontSize)) sunrise.grid(row=1, column=0, sticky="W", padx=self.infoPadding) widgets["sunrise"] = sunrise sunsetLabel = Label(statsFrame, text="Sunset", font=(None, self.smallFontSize, "bold")) sunsetLabel.grid(row=0, column=1, sticky="W", padx=self.infoPadding) sunset = Label(statsFrame, text=info["sunset"], font=(None, self.smallFontSize)) sunset.grid(row=1, column=1, sticky="W", padx=self.infoPadding) widgets["sunset"] = sunset windLabel = Label(statsFrame, text="Wind", font=(None, self.smallFontSize, "bold")) windLabel.grid(row=0, column=2, sticky="W", padx=self.infoPadding) wind = Label(statsFrame, text=info["wind"], font=(None, self.smallFontSize)) wind.grid(row=1, column=2, sticky="W", padx=self.infoPadding) widgets["wind"] = wind humidityLabel = Label(statsFrame, text="Humidity", font=(None, self.smallFontSize, "bold")) humidityLabel.grid(row=0, column=3, sticky="W", padx=self.infoPadding) humidity = Label(statsFrame, text=info["humidity"], font=(None, self.smallFontSize)) humidity.grid(row=1, column=3, sticky="W", padx=self.infoPadding) widgets["humidity"] = humidity pressureLabel = Label(statsFrame, text="Pressure", font=(None, self.smallFontSize, "bold")) pressureLabel.grid(row=2, column=0, sticky="W", padx=self.infoPadding) pressure = Label(statsFrame, text=info["pressure"], font=(None, self.smallFontSize)) pressure.grid(row=3, column=0, sticky="W", padx=self.infoPadding) widgets["pressure"] = pressure visibilityLabel = Label(statsFrame, text="Visibility", font=(None, self.smallFontSize, "bold")) visibilityLabel.grid(row=2, column=1, sticky="W", padx=self.infoPadding) visibility = Label(statsFrame, text=info["visibility"], font=(None, self.smallFontSize)) visibility.grid(row=3, column=1, sticky="W", padx=self.infoPadding) widgets["visibility"] = visibility latitudeLabel = Label(statsFrame, text="Latitude", font=(None, self.smallFontSize, "bold")) latitudeLabel.grid(row=2, column=2, sticky="W", padx=self.infoPadding) latitude = Label(statsFrame, text=info["latitude"], font=(None, self.smallFontSize)) latitude.grid(row=3, column=2, sticky="W", padx=self.infoPadding) widgets["latitude"] = latitude longitudeLabel = Label(statsFrame, text="Longitude", font=(None, self.smallFontSize, "bold")) longitudeLabel.grid(row=2, column=3, sticky="W", padx=self.infoPadding) longitude = Label(statsFrame, text=info["longitude"], font=(None, self.smallFontSize)) longitude.grid(row=3, column=3, sticky="W", padx=self.infoPadding) widgets["longitude"] = longitude for i in range(statsFrame.grid_size()[0]): statsFrame.columnconfigure(i, weight=1) for i in range(statsFrame.grid_size()[1]): statsFrame.rowconfigure(i, weight=1) if deletable: closeImage = PhotoImage(file=self.closeiconfile) closeButton = Button(page, image=closeImage) closeButton.config(command=lambda p=page: self.deleteTab(p)) closeButton.grid(row=0, column=0, sticky="NE") closeButton.image = closeImage for i in range(page.grid_size()[0]): page.columnconfigure(i, weight=1) for i in range(page.grid_size()[1]): page.rowconfigure(i, weight=1) self.widgets.append(widgets) self.notebook.add(page, text=tabText) self.addPlusTab()
def createCheck(frame): water = ttk.Label(frame, text="Water: ") water.grid(column=1, row=1, sticky=(N)) waterEntry = ttk.Entry(frame) waterEntry.grid(column=3, row=1, sticky=(N)) waterEntry.insert(END, "(Litres)") temp = ttk.Label(frame, text="Temperature: ") temp.grid(column=1, row=3, sticky=(N)) tempEntry = ttk.Entry(frame) tempEntry.grid(column=3, row=3, sticky=(N)) tempEntry.insert(END, "(°C)") rating = ttk.Label(frame, text="Rating of Cleanliness: ") rating.grid(column=1, row=5, sticky=(N)) ratingEntry = ttk.Entry(frame) ratingEntry.grid(column=3, row=5, sticky=(N)) ratingEntry.insert(END, "(from 1 to 10)") time = ttk.Label(frame, text="Time Taken: ") time.grid(column=1, row=7, sticky=(N)) timeEntry = ttk.Entry(frame) timeEntry.grid(column=3, row=7, sticky=(N)) timeEntry.insert(END, "(Whole Minutes)") def addButtonFunction(): getWater = waterEntry.get() getTemp = tempEntry.get() getRating = ratingEntry.get() getTime = timeEntry.get() check = ('Water:', getWater, 'Temperature:', getTemp, 'Rating:', getRating, 'Time:', getTime) if checkNum(getWater) == True and checkNum(getTemp) == True and checkNum(getRating) == True and checkNum(getTime) == True: confirm = messagebox.askquestion( "Are you sure you want to add this check?", check, icon='warning') if confirm == 'yes': cW = float(getWater) cTe = float(getTemp) cR = int(getRating) cTi = int(getTime) conn = sqlite3.connect('Punjab Meat Shop.db') c = conn.cursor() c.execute("INSERT INTO Cooler (Water_Bucket, Temperature, Rating, Time_Taken) VALUES (?, ?, ?, ?)", (cW, cTe, cR, cTi)) conn.commit() conn.close() messagebox.showinfo("Success!", "Your check was successfully added.") buildCooler() else: messagebox.showinfo("Unsuccessful!", "Your check was not added.") buildCooler() addButton = ttk.Button(frame, text="Add Check", command=addButtonFunction) addButton.grid(column=4, row=8, sticky=(E)) content.grid_columnconfigure(0, weight=1) content.grid_columnconfigure(2, weight=1) content.grid_columnconfigure(4, weight=1) content.grid_rowconfigure(0, weight=1) content.grid_rowconfigure(2, weight=1) content.grid_rowconfigure(4, weight=1) content.grid_rowconfigure(6, weight=1) content.grid_rowconfigure(8, weight=1)