60 lines
1.9 KiB
Python
Executable File
60 lines
1.9 KiB
Python
Executable File
#!/usr/bin/python
|
|
import ldap, time, operator
|
|
|
|
#
|
|
# globals
|
|
#
|
|
cscUri = "http://csclub.uwaterloo.ca/xsltproc"
|
|
cscTerms = ["Winter", "Spring", "Fall"]
|
|
cscShortTerms = ['w', 's', 'f']
|
|
cscLdapUri = "ldap://ldap1.csclub.uwaterloo.ca ldap://ldap2.csclub.uwaterloo.ca"
|
|
cscLdap = None
|
|
|
|
cscClubBase = 'ou=People, dc=csclub, dc=uwaterloo, dc=ca'
|
|
cscGroupBase = 'ou=Group, dc=csclub, dc=uwaterloo, dc=ca'
|
|
cscPeopleBase = 'ou=People,dc=csclub,dc=uwaterloo,dc=ca'
|
|
|
|
|
|
def cscLdapConnect():
|
|
global cscLdap
|
|
cscLdap = ldap.initialize(cscLdapUri)
|
|
cscLdap.simple_bind_s("", "")
|
|
|
|
cscLdapConnect()
|
|
|
|
curDate = time.strftime('%d-%m-%Y')
|
|
year = time.localtime().tm_year
|
|
term = cscShortTerms[int(time.localtime().tm_mon - 1) / 4]
|
|
term2 = cscTerms[int(time.localtime().tm_mon - 1) / 4]
|
|
|
|
|
|
clubs = cscLdap.search_s(cscClubBase, ldap.SCOPE_SUBTREE, '(&(objectClass=club))')
|
|
groups = cscLdap.search_s(cscGroupBase, ldap.SCOPE_SUBTREE, '(&(objectClass=group))')
|
|
members = cscLdap.search_s(cscPeopleBase, ldap.SCOPE_SUBTREE,'(&(objectClass=member)(|(term=%s%d)(nonMemberTerm=%s%d)))' % (term, year, term, year))
|
|
|
|
|
|
clubs.sort(key=lambda (_, y): y['cn'][0])
|
|
print "<h1>Clubs This Term</h1>"
|
|
print "<center>"
|
|
print "<table>"
|
|
print " <tr><th>Name</th></tr>"
|
|
|
|
|
|
def doshit(club):
|
|
for (_, group) in groups:
|
|
if group['cn'][0] == club['uid'][0] and group.has_key('uniqueMember'):
|
|
for clubrep in group['uniqueMember']:
|
|
clubrepname = clubrep.split(",")[0][4:]
|
|
for (_, member) in members:
|
|
if member['uid'][0] == clubrepname:
|
|
print " <tr>"
|
|
print " <td><a href=\"http://csclub.uwaterloo.ca/~" + club['uid'][0] + "\">" + club['cn'][0] + "</a></td>"
|
|
print " </tr>"
|
|
return
|
|
|
|
for (_, club) in clubs:
|
|
doshit(club)
|
|
|
|
print "</table>"
|
|
print "</center>"
|