Page 278 - MDP2020-3

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

listTimeNums = sqlExcute("SELECT * FROM time")

str2Extra = " {0:<15s} {1:<23s} {2:<s}".format("이름", "상태", "총시간")
listList2.insert(0, str2Extra)
for k in range(len(listTimeNums)): # 표시용 포문
name2Extra = listTimeNums[k]['Name']

status2Extra = str(listTimeNums[k]['Status'])
totalTime2Extra = str(listTimeNums[k]['TotalTime'])
str2ExtraT = " {0:<15s} {1:<9s} {2:<s}".format(name2Extra,
status2Extra, totalTime2Extra)
listList2.insert(k + 1, str2ExtraT)

listFrame = Frame(listWindow, relief="solid", bd=3)
listFrame.place(x=60, y=90)
listScrollBar = Scrollbar(listFrame)
listList = Listbox(listFrame, yscrollcommand=scroll.set, width=50, height=17,

font=l2Font, selectbackground="white",
bg="white", selectforeground="black", activestyle="none")
listScrollBar.pack(side="right", fill="y")
listList.pack(side="left", fill="both")

strExtra = " {0:<15s} {1:<10s} {2:<15s} {3:<14s} {4:<s}".format("이름", "상
태", "입장시간", "퇴장시간", "총시간")
listList.insert(0, strExtra)
for j in range(len(personNums)): # 표시용 포문
nameExtra = personNums[j]['Name']

startTimeExtra = str(personNums[j]['StartTime'])
stopTimeExtra = str(personNums[j]['StopTime'])
statusExtra = str(personNums[j]['Status'])
strExtraT = ""
if personNums[j]['StartTime'] is not None and personNums[j]['StopTime'] is

not None:
totalTimeExtra = str(personNums[j]['StopTime'] -
personNums[j]['StartTime'])
strExtraT += " {0:<15s} {1:<9s} {2:<18s} {3:<16s}
{4:<s}".format(nameExtra, statusExtra,

startTimeExtra, stopTimeExtra,

totalTimeExtra)