def make_navbar(): str = cgi_utils_sda.file_contents("navbar.html") type = session.getStatus() team = session.getTeamName() #TODO if team is deleted, fix header if type == "m" or type == "c" and (team != "None" or team != "NULL" or team != None): dashboard = "<li><a href='managerDashboard.cgi'>Manage Team: "+team+"</a></li>" switch = "<li><a href='viewTeams.cgi'>Switch Team </a></li>" elif type == "p" and (team != "None" or team != None): dashboard = "<li><a href='playerDashboard.cgi'>View Team: "+team+"</a></li>" switch = "<li><a href='viewTeams.cgi'>Switch Team </a></li>" else: dashboard = "" switch = "" #logged status printed so capital L on l abel, lower l on URL if logged_status(): status = "ogout" userdash = "<li><a href='userDashboard.cgi'>My Dashboard</a></li>" settings ="<li><a href='userSettings.cgi'>Settings</a></li>" index = "#" else: status = "ogin" userdash = "" index = "index.cgi" settings = "" return str.format(index=index,userdash=userdash,dashboard=dashboard,status=status,team=team,switch=switch,settings=settings)
def getRoster(id): curs = session.cursor(session.connect()) name = session.getTeamName() curs.execute('select name,PID from player inner join user where PID=UID and team=%s',(id,)) header = "<div class=\"panel panel-default\"><div class='panel-heading'> Roster for team " + str(name) + "</div>" tableHead = "<table class=\"table table-striped\"> <thead><tr> \n <th> PID </th> \n <th> Player Name </th> \n </tr></thead>" tableEnd = "</table></div>" lines = [] while True: row = curs.fetchone() if row == None: return header + tableHead + "\n".join(lines) + tableEnd lines.append("<tr>" + "<td>" + str(row.get('PID')) + "</td>") lines.append("<td>" + row.get('name') + "</td>" + "</tr>")