Page 389 - MDP2020-3

················································································ 명장양성프로젝트 【MDP】 과제발표회 자료집 Ⅲ | 383

personNums[i]['Name'], personNums[i]['StartTime'],
personNums[i]['StopTime'], year, month, day,

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

personNums[i]['Name'], year, month, day, "00:00:00",
personNums[i]['Status'])
elif personNums[i]['StopTime'] is None:
dSql = "INSERT INTO time(Name,StartTime,Status) VALUES('%s', '%s',
'%s')" % (

personNums[i]['Name'], personNums[i]['StartTime'],
personNums[i]['Status'])
if dSql != "":
sqlExecute(dSql)
sqlExecute("UPDATE data SET StartTime = null, StopTime = null;")

resetToggle = False
listScroll.delete(0, len(personNums) + 1)
listToggle = True
started = False
person = 0

for i in range(len(personNums)):
if personNums[i]['Status'] == '재실':
person += 1
if personNums[i]['StartTime'] is None:

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'] == '외출':