Page 285 - MDP2020-3

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

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')" % (
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: