Mercurial > hg > MPIWGWeb
changeset 57:84879a3f91a6
getLastArrivals
| author | dwinter |
|---|---|
| date | Tue, 30 Apr 2013 22:34:00 +0200 |
| parents | a6ace48c2bf2 |
| children | 09900782c855 |
| files | MPIWGProjects.py MPIWGRoot.py MPIWGStaff.py |
| diffstat | 3 files changed, 25 insertions(+), 4 deletions(-) [+] |
line wrap: on
line diff
--- 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"""
--- 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)
--- 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)