diff MPIWGStaff.py @ 40:fd8e78bbc5ed

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
line wrap: on
line diff
--- a/MPIWGStaff.py	Fri Apr 26 20:31:21 2013 +0200
+++ b/MPIWGStaff.py	Fri Apr 26 21:18:01 2013 +0200
@@ -1093,13 +1093,20 @@
                 member = MPIWGStaffMember(self, dbresult=content)
         
         elif key is not None:
-            content = folder.executeZSQL("select * from personal_www where key = %s", [key])
+            # TODO: sometimes key is lowercased (e.g. responsibleScientistsList), we should fix the data
+            content = self.executeZSQL("select * from personal_www where lower(key) = %s", [key.lower()])
             if len(content) > 0:
                 member = MPIWGStaffMember(self, dbresult=content)             
          
         return member
     
 
+    def isActiveMember(self, key):
+        """returns if member key is active"""
+        res = self.executeZSQL("select * from personal_www where lower(key) = %s and publish_the_data = 'yes'", [key.lower()])
+        return len(res) > 0
+
+
     def sortPriority(self,list):
         def sort(x,y):
             try:
@@ -1544,7 +1551,7 @@
         REQUEST.response.redirect(self.REQUEST['HTTP_REFERER'])
  
    
-    def invalidate_chache(self):
+    def invalidate_cache(self):
         #TODO: How to invalidate the varnish cache from the member object
         pass;