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