# HG changeset patch # User casties # Date 1367941130 -7200 # Node ID 96b71e761dac5b50edd66ff7bf10b61f2292cd4f # Parent 2d3a7171f3f096d6ee05bc5ea38b21ce4591dd83 more work on project lists. diff -r 2d3a7171f3f0 -r 96b71e761dac MPIWGProjects.py --- a/MPIWGProjects.py Tue May 07 11:14:24 2013 +0200 +++ b/MPIWGProjects.py Tue May 07 17:38:50 2013 +0200 @@ -1599,16 +1599,24 @@ projects = [] # search project numbers res = self.executeZSQL("select * from projects_members where lower(member_key) = %s", [key.lower()]) - tree = self.getProjectTree() - # find projects in tree + # find projects in folder for r in res: - p = tree.get(r.project_number) + p = self.get(r.project_id, None) # check if active if p is not None and p.checkActive(active) and p.checkArchived(archived): projects.append(p) - + + # sort by project number projects.sort(key=lambda p:[int(n) for n in p.getNumber().split('.')]) - return projects + return projects + + + def getMembersWithProjects(self): + """Return a list of all members that have projects. + + Returns a list of member keys. + """ + #res = self.executeZSQL("select * from projects_members where lower(member_key) = %s", [key.lower()]) security.declareProtected('View management screens', 'changeProjectTree')