Mercurial > hg > MPIWGWeb

comparison MPIWGStaff.py @ 40:fd8e78bbc5ed

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
more work on projects. new member template uses new getProjectsOfMember. new isActiveMember in MPIWGStaffFolder.
author casties
date Fri, 26 Apr 2013 21:18:01 +0200
parents 3c98cc79dd14
children f59bdd5f4890
comparison
equal deleted inserted replaced
39:bbad6a092861 40:fd8e78bbc5ed
1091 content = self.executeZSQL("select * from personal_www where e_mail = %s", [email]) 1091 content = self.executeZSQL("select * from personal_www where e_mail = %s", [email])
1092 if len(content) > 0: 1092 if len(content) > 0:
1093 member = MPIWGStaffMember(self, dbresult=content) 1093 member = MPIWGStaffMember(self, dbresult=content)
1094 1094
1095 elif key is not None: 1095 elif key is not None:
1096 content = folder.executeZSQL("select * from personal_www where key = %s", [key]) 1096 # TODO: sometimes key is lowercased (e.g. responsibleScientistsList), we should fix the data
1097 content = self.executeZSQL("select * from personal_www where lower(key) = %s", [key.lower()])
1097 if len(content) > 0: 1098 if len(content) > 0:
1098 member = MPIWGStaffMember(self, dbresult=content) 1099 member = MPIWGStaffMember(self, dbresult=content)
1099 1100
1100 return member 1101 return member
1101 1102
1103
1104 def isActiveMember(self, key):
1105 """returns if member key is active"""
1106 res = self.executeZSQL("select * from personal_www where lower(key) = %s and publish_the_data = 'yes'", [key.lower()])
1107 return len(res) > 0
1108
1102 1109
1103 def sortPriority(self,list): 1110 def sortPriority(self,list):
1104 def sort(x,y): 1111 def sort(x,y):
1105 try: 1112 try:
1106 xInt=int(x.priority) 1113 xInt=int(x.priority)
1542 1549
1543 self.executeZSQL(query) 1550 self.executeZSQL(query)
1544 REQUEST.response.redirect(self.REQUEST['HTTP_REFERER']) 1551 REQUEST.response.redirect(self.REQUEST['HTTP_REFERER'])
1545 1552
1546 1553
1547 def invalidate_chache(self): 1554 def invalidate_cache(self):
1548 #TODO: How to invalidate the varnish cache from the member object 1555 #TODO: How to invalidate the varnish cache from the member object
1549 pass; 1556 pass;
1550 1557
1551 1558
1552 def getStaffURL(self): 1559 def getStaffURL(self):