Mercurial > hg > MPIWGWeb

comparison MPIWGStaff.py @ 100:f4ac675b2031

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
more members pages.
author casties
date Tue, 21 May 2013 18:50:05 +0200
parents 48e88706cfc3
children 7dd264f9b728
comparison
equal deleted inserted replaced
99:84fa3f62ed85 100:f4ac675b2031
218 218
219 security = ClassSecurityInfo() 219 security = ClassSecurityInfo()
220 220
221 # templates 221 # templates
222 mainEditFile=PageTemplateFile('zpt/staff/edit_main', globals()) 222 mainEditFile=PageTemplateFile('zpt/staff/edit_main', globals())
223 223 talks_full_html = PageTemplateFile('zpt/staff/talks_full_html', globals())
224 teaching_full_html = PageTemplateFile('zpt/staff/teaching_full_html', globals())
225
224 226
225 def __init__(self, folder, dbresult): 227 def __init__(self, folder, dbresult):
226 """constructor: takes parent MPIWGStaffFolder and content (DB row)""" 228 """constructor: takes parent MPIWGStaffFolder and content (DB row)"""
227 self.folder = folder 229 self.folder = folder
228 self.content = dbresult 230 self.content = dbresult
295 return "NOT FOUND" 297 return "NOT FOUND"
296 298
297 299
298 getUrl = MPIWGHelper.getUrl 300 getUrl = MPIWGHelper.getUrl
299 301
300 def getTalks(self): 302 def getTalks(self, published=True, sortBy='priority'):
301 return self.folder.executeZSQL("SELECT oid,* FROM talks WHERE key_main = %s",[self.content.key]) 303 """Return the list of talks"""
302 #return self.folder.ZSQLInlineSearch(_table='talks',key_main=self.content.key) 304 query = "SELECT oid,* FROM talks WHERE key_main = %s"
303 305 if published:
304 306 query += " and published = 'yes'"
305 def getTeaching(self): 307
306 return self.folder.executeZSQL("SELECT oid,* FROM teaching WHERE key_main = %s",[self.content.key]) 308 if sortBy == 'priority':
309 query += " order by priority"
310
311 return self.folder.executeZSQL(query, [self.content.key])
312
313 def getTeaching(self, published=True, sortBy='priority'):
314 """Return the list of teaching activities"""
315 query = "SELECT oid,* FROM teaching WHERE key_main = %s"
316 if published:
317 query += " AND published = 'yes'"
318
319 if sortBy == 'priority':
320 query += " ORDER BY priority"
321
322 return self.folder.executeZSQL("SELECT oid,* FROM teaching WHERE key_main = %s",[self.content.key])
307 323
308 324
309 def getLastUpdateCV(self): 325 def getLastUpdateCV(self):
310 """getDate of Last Update""" 326 """getDate of Last Update"""
311 try: 327 try:
666 682
667 return pubs 683 return pubs
668 return {} 684 return {}
669 685
670 686
671 def publicationsFull(self,REQUEST): 687 def publications_full_html(self, REQUEST):
672 """show publication""" 688 """show publication"""
673 pt=PageTemplateFile(os.path.join(package_home(globals()),'zpt/staff/pubman','show_publications.zpt')).__of__(self) 689 pt=PageTemplateFile('zpt/staff/pubman/show_publications.zpt', globals()).__of__(self)
674 return pt(member=self.content) 690 return pt(member=self.content)
675
676
677
678 691
679 692
680 def addPublicationsFromPubman(self,REQUEST): 693 def addPublicationsFromPubman(self,REQUEST):
681 """addPublications from pubman""" 694 """addPublications from pubman"""
682 695
774 logging.error(value) 787 logging.error(value)
775 788
776 789
777 def getSelectedPublications(self): 790 def getSelectedPublications(self):
778 """hole publications aus der datenbank""" 791 """hole publications aus der datenbank"""
779 query="select * from pubmanbiblio where lower(key_main) = lower(%s) order by priority DESC" 792 query="select * from pubmanbiblio where lower(key_main) = lower(%s) order by priority ASC"
780 return self.executeZSQL(query,[self.getKey()]) 793 return self.executeZSQL(query,[self.getKey()])
781 794
782 795
783 def getProfile(self,REQUEST): 796 def getProfile(self,REQUEST):
784 """get the profile""" 797 """get the profile"""