# HG changeset patch
# User dwinter
# Date 1367354040 -7200
# Node ID 84879a3f91a6d8d1b4c11b72ab422c0777144ca8
# Parent  a6ace48c2bf256bfa77fe5cc88e13e1051702f0b
getLastArrivals

diff -r a6ace48c2bf2 -r 84879a3f91a6 MPIWGProjects.py
--- a/MPIWGProjects.py	Tue Apr 30 18:35:08 2013 +0200
+++ b/MPIWGProjects.py	Tue Apr 30 22:34:00 2013 +0200
@@ -2065,7 +2065,15 @@
             return fulllog
                 
 
-      
+    def getLastArrivals(self,REQUEST,RESPONSE):
+        """getlast arrivals"""
+        selectStr="select * from personal_www_list_web where publish_the_data = 'yes' and is_scholar='yes' order by date_from"
+        
+        res=self.members.executeZSQL(selectStr)
+        
+        return res
+
+            
         
 def manage_addMPIWGProjectFolderForm(self):
     """form for adding a MPIWGProjectFolder"""
diff -r a6ace48c2bf2 -r 84879a3f91a6 MPIWGRoot.py
--- a/MPIWGRoot.py	Tue Apr 30 18:35:08 2013 +0200
+++ b/MPIWGRoot.py	Tue Apr 30 22:34:00 2013 +0200
@@ -757,9 +757,8 @@
                     fw.flush()
                 
             fw.close()
+    
 
-     
-            
 def manage_addMPIWGRootForm(self):
     """form for adding the root"""
     pt=PageTemplateFile(os.path.join(package_home(globals()),'zpt','addMPIWGRootForm.zpt')).__of__(self)
diff -r a6ace48c2bf2 -r 84879a3f91a6 MPIWGStaff.py
--- a/MPIWGStaff.py	Tue Apr 30 18:35:08 2013 +0200
+++ b/MPIWGStaff.py	Tue Apr 30 22:34:00 2013 +0200
@@ -1054,7 +1054,8 @@
                 raise Redirect(self.absolute_url())  # redirects to `/members`, adjust as needed
             
         
-                
+ 
+        
     def index_html(self,REQUEST,RESPONSE):
         """show homepage"""
         logging.debug("MPIWGStaffFolder: index_html!")
@@ -1136,6 +1137,19 @@
             return pubs
         except:
             return []
+    
+    def getLastArrivals(self,limit=None):
+        """getlast arrivals"""
+        if not limit:
+            selectStr="select * from personal_www_list_web where publish_the_data = 'yes' and is_scholar='yes' order by date_from DESC"
+        else:
+            selectStr="select * from personal_www_list_web where publish_the_data = 'yes' and is_scholar='yes' order by date_from DESC limit %s"%limit  
+        
+        res=self.members.executeZSQL(selectStr)
+        
+        return res
+
+ 
 def manage_addMPIWGStaffFolderForm(self):
     """form for adding the project"""
     pt=PageTemplateFile('zpt/addMPIWGStaffFolderForm', globals()).__of__(self)