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)
