Page 286 - MDP2020-3

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

sqlExecute("UPDATE data SET StartTime = CURTIME() WHERE NO = "
+ str(i + 1) + ";")

if started:
listScroll.itemconfig(i + 1, bg="Lightgreen",
selectbackground="Lightgreen")
elif personNums[i]['Status'] == '퇴근':
if personNums[i]['StartTime'] is not None and personNums[i]['StopTime']

is None:
sqlExecute("UPDATE data SET StopTime = CURTIME() WHERE NO = "
+ str(i + 1) + ";")
if started:
listScroll.itemconfig(i + 1, bg="deep pink", selectbackground="deep

pink")
elif personNums[i]['Status'] == '외출':
if started:
listScroll.itemconfig(i + 1, bg="aqua", selectbackground="aqua")
elif personNums[i]['Status'] == '출장':

if started:
listScroll.itemconfig(i + 1, bg="light gray", selectbackground="light
gray")

if listToggle:

strE = " {0:<26s} {1:<13s}".format("이름", "상태")
listScroll.insert(0, strE)
for i in range(len(personNums)): # 표시용 포문
name = personNums[i]['Name']
status = str(personNums[i]['Status'])

strF = " {0:<25s} {1:<s}".format(name, status)
listScroll.insert(i + 1, strF)
listToggle = False

sSPerson = str(person)

sPerson.set(sSPerson)
started = True
personNums = sqlExcute(query)
try:
frame.update()

except TclError:
pass

frame.mainloop()