Mercurial > hg > MPIWGWeb

comparison MPIWGStaff.py @ 109:f8e914a4992d

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Merge with bf3dc3a12147050b17dfdb0d9e252acbab7e9773
author casties
date Mon, 27 May 2013 23:12:33 +0200
parents bf3dc3a12147
children b554becd8226
comparison
equal deleted inserted replaced
108:782477730916 109:f8e914a4992d
196 return pubs 196 return pubs
197 except: 197 except:
198 return [] 198 return []
199 199
200 200
201 def importSortingModeFromOldStaff(self):
202 """ only used for the migration to the new website """
203 ret=[]
204 for member in self.getMemberList():
205 email = member.content.e_mail
206 un = email.split("@")[0]
207
208 logging.debug(un)
209 olduser = self.www_neu.members.get(un)
210
211 if not olduser is None:
212 mode =olduser.getSortingMode()
213
214
215 if mode.startswith("year"):
216 mode="year"
217
218 query="UPDATE personal_www SET publications_mode=%s WHERE key=%s"
219
220 self.executeZSQL(query,[mode,member.getKey()])
221
222 return ret
223
224
225 def importPublishFotoFromOldStaff(self):
226 """ only used for the migration to the new website """
227 ret=[]
228 for member in self.getMemberList():
229 email = member.content.e_mail
230 un = email.split("@")[0]
231
232 logging.debug(un)
233 olduser = self.www_neu.members.get(un)
234
235 if not olduser is None:
236 mode =olduser.getPublishImage()
237
238
239
240 query="UPDATE personal_www SET image_p=%s WHERE key=%s"
241
242 self.executeZSQL(query,[mode,member.getKey()])
243
244 return ret
245
246 def showDownloadableFiles(self):
247 """copy df to the new"""
248 logging.debug("huh")
249 ret=[]
250
251 for member in self.getMemberList(onlyCurrent=True):
252 email = member.content.e_mail
253 un = email.split("@")[0]
254
255 logging.debug(un)
256 olduser = self.www_neu.members.get(un)
257 if olduser is None:
258 continue;
259 df = olduser.get('downloadableFiles')
260 if df is not None:
261 ret.append(olduser)
262
263 return ret,len(ret)
264
265
266
201 def manage_addMPIWGStaffFolderForm(self): 267 def manage_addMPIWGStaffFolderForm(self):
202 """form for adding the project""" 268 """form for adding the project"""
203 pt=PageTemplateFile('zpt/addMPIWGStaffFolderForm', globals()).__of__(self) 269 pt=PageTemplateFile('zpt/addMPIWGStaffFolderForm', globals()).__of__(self)
204 return pt() 270 return pt()
205 271
317 query += " AND published = 'yes'" 383 query += " AND published = 'yes'"
318 384
319 if sortBy == 'priority': 385 if sortBy == 'priority':
320 query += " ORDER BY priority" 386 query += " ORDER BY priority"
321 387
322 return self.folder.executeZSQL("SELECT oid,* FROM teaching WHERE key_main = %s",[self.content.key]) 388 return self.folder.executeZSQL(query,[self.content.key])
323 389
324 390
325 def getLastUpdateCV(self): 391 def getLastUpdateCV(self):
326 """getDate of Last Update""" 392 """getDate of Last Update"""
327 try: 393 try: