def generateDaySlots(weekOf, startTime, type):
daySlots = ""
day = datetime.datetime.combine(weekOf, startTime)
for i in range(0, 5):
entries = db.getEntries(day.date(), startTime, type)
quantity = db.getResourceQuantity(type)
if entries:
daySlots += "<td class='tFilled'>"
else:
daySlots += "<td class='tBordered'> "
for entry in entries:
daySlots += "<div class='entry'>"
daySlots += db.getTeacherName(entry[7])
daySlots += " (%(q)d)" % {"q": entry[5]}
daySlots += "</div>"
quantity -= entry[5]
if entries:
daySlots += "<div class='leftEntryAfter'>%(q)d left</div>" % {"q": quantity}
daySlots += "</td>"
day = day + datetime.timedelta(days=1)
return daySlots
def generateSignoutDaySlots(weekOf, startTime, type):
daySlots = ""
day = datetime.datetime.combine(weekOf, startTime)
currentUser = authGetID()
for i in range(0, 5):
entries = db.getEntries(day.date(), startTime, type)
quantity = db.getResourceQuantity(type)
currentUserInBox = 0
for entry in entries:
if db.getTeacherName(entry[7]) == currentUser:
currentUserInBox = entry[5]
quantity -= entry[5]
if entries:
if currentUserInBox:
daySlots += "<td class='tFilled tSignout ts' "
else:
daySlots += "<td class='tFilled ts' "
else:
daySlots += "<td class='ts' "
daySlots += " onclick='signout(\"" + currentUser + "\"," + str(currentUserInBox) + "," + str(quantity) + ", \"" + day.strftime("%Y-%m-%d") + "\",\"" + startTime.strftime("%I:%M") + "\")'>"
if not entries:
daySlots += " "
for entry in entries:
if db.getTeacherName(entry[7]) == currentUser:
daySlots += "<div class='signoutEntry'>"
else:
daySlots += "<div class='entry'>"
daySlots += db.getTeacherName(entry[7])
daySlots += " (%(q)d)" % {"q": entry[5]}
daySlots += "</div>"
if entries:
daySlots += "<div class='leftEntryAfter'>%(q)d left</div>" % {"q": quantity}
daySlots += "</td>"
day = day + datetime.timedelta(days=1)
return daySlots
def backupTimeslot(type, weekOf, startTime):
tstr = startTime.strftime("%I:%M") + ","
day = datetime.datetime.combine(weekOf, startTime)
for i in range(0, 5):
tstr += '"'
entries = db.getEntries(day.date(), startTime, type)
for entry in entries:
tstr += db.getTeacherName(entry[7]) + " (" + str(entry[5]) + ")\n"
day = day + datetime.timedelta(days=1)
tstr += '"'
if i != 4:
tstr += ","
tstr += "\n"
return tstr
