Page 388 - MDP2020-3

382
| 인천전자마이스터고등학교 ·············································································································

sPerson.set(sSPerson)
numsLabel = Label(numsFrame, bg="White", fg="red", font=numsFont,

textvariable=sPerson)

frameNums.pack(fill="both", expand=True)
shOptionFrame.pack(side="right")

numsFrame.pack(side="top", anchor="center", pady=40)
numsFrame2.pack(anchor="center")
numsButton.pack(side="bottom", anchor="center")
numsLabelS.place(x=120, y=10)
numsLabel.place(x=150, y=60)

scroll.pack(side="right", fill="y")
listScroll.pack(side="left", fill="both")
listScroll.bind('<<ListboxSelect>>', listClick)
scroll.config(command=listScroll.yview)

exitButton.place(x=15, y=635)
listButton.place(x=15, y=540)
extraButton0.place(x=15, y=20)
extraButton1.place(x=15, y=120)
faceButton0.place(x=15, y=220)

while True:
if lPersonNums != personNums:
resetList()
lPersonNums = personNums

if sqlDex:
sqlExecute(query2)
resetList()
if resetToggle or (tm.tm_hour == 24 and tm.tm_min == 0 and tm.tm_sec == 0):
for i in range(len(personNums)):

dSql = ""
year = datetime.today().year
month = datetime.today().month
day = datetime.today().day
if personNums[i]['StartTime'] is not None and personNums[i]['StopTime']

is not None:
tTime = personNums[i]['StopTime'] - personNums[i]['StartTime']
dSql = "INSERT INTO time(Name,StartTime,StopTime,TotalTime,Status)
VALUES('%s','%s','%s','%s-%s-%s %s','%s')" % (