Mercurial > hg > MPIWGWeb
annotate MPIWGStaff.py @ 275:3f9ba7a8cb27
fixed fix for: 175: removing the ICS URL in editTalks doesn't work
Task-Url: https://it-dev.mpiwg-berlin.mpg.de/tracs/webpage/ticket/175
| author | casties |
|---|---|
| date | Wed, 08 Oct 2014 15:18:19 +0200 |
| parents | 87e7e210968d |
| children | a1edd65c8ab7 d83971b49b26 |
| rev | line source |
|---|---|
|
0
bca61e893fcc
first checkin of MPIWGWeb r2 branch from CVS into mercurial
casties
parents:
diff
changeset
|
1 """This file contains the classes for the organization of the staff""" |
|
bca61e893fcc
first checkin of MPIWGWeb r2 branch from CVS into mercurial
casties
parents:
diff
changeset
|
2 |
|
bca61e893fcc
first checkin of MPIWGWeb r2 branch from CVS into mercurial
casties
parents:
diff
changeset
|
3 from OFS.Folder import Folder |
|
bca61e893fcc
first checkin of MPIWGWeb r2 branch from CVS into mercurial
casties
parents:
diff
changeset
|
4 from Products.PageTemplates.PageTemplateFile import PageTemplateFile |
|
bca61e893fcc
first checkin of MPIWGWeb r2 branch from CVS into mercurial
casties
parents:
diff
changeset
|
5 |
| 186 | 6 from zope.interface import implements |
| 7 from zope.publisher.interfaces import IPublishTraverse | |
| 8 from ZPublisher.BaseRequest import DefaultPublishTraverse | |
|
191
90d44df497a6
updated breadcrumb handling, works for members now.
casties
parents:
190
diff
changeset
|
9 from Acquisition import aq_parent |
| 186 | 10 |
| 3 | 11 from AccessControl import ClassSecurityInfo |
| 12 from App.class_init import InitializeClass | |
| 159 | 13 from App.ImageFile import ImageFile |
| 86 | 14 from Products.PythonScripts.standard import sql_quote |
| 15 from Products.ExtFile import ExtFile | |
|
0
bca61e893fcc
first checkin of MPIWGWeb r2 branch from CVS into mercurial
casties
parents:
diff
changeset
|
16 import logging |
|
bca61e893fcc
first checkin of MPIWGWeb r2 branch from CVS into mercurial
casties
parents:
diff
changeset
|
17 import email |
|
bca61e893fcc
first checkin of MPIWGWeb r2 branch from CVS into mercurial
casties
parents:
diff
changeset
|
18 import re |
| 217 | 19 import datetime |
| 86 | 20 |
| 21 from Products.ZDBInterface.ZDBInterfaceFolder import ZDBInterfaceFolder | |
| 251 | 22 from Products.MPIWGManager import MPIWGIcsManager |
| 2 | 23 |
| 233 | 24 from SrvTxtUtils import getInt, unicodify, utf8ify, sqlName, getPlaintext |
| 86 | 25 import MPIWGHelper |
|
0
bca61e893fcc
first checkin of MPIWGWeb r2 branch from CVS into mercurial
casties
parents:
diff
changeset
|
26 |
| 86 | 27 # |
| 28 # compatibility | |
| 29 # TODO: should be removed when done | |
| 30 import MPIWGStaff_old | |
|
0
bca61e893fcc
first checkin of MPIWGWeb r2 branch from CVS into mercurial
casties
parents:
diff
changeset
|
31 |
|
189
cc5198541af8
erzeugen neuer eintr?ge auf der homepage mittels updatexml
dwinter
parents:
188
diff
changeset
|
32 #createNewDBEntry = MPIWGStaff_old.createNewDBEntry |
|
0
bca61e893fcc
first checkin of MPIWGWeb r2 branch from CVS into mercurial
casties
parents:
diff
changeset
|
33 |
| 86 | 34 class MPIWGStaff(MPIWGStaff_old.MPIWGStaff): |
| 35 """Staff""" | |
| 36 pass | |
|
0
bca61e893fcc
first checkin of MPIWGWeb r2 branch from CVS into mercurial
casties
parents:
diff
changeset
|
37 |
| 86 | 38 manage_addMPIWGStaffForm = MPIWGStaff_old.manage_addMPIWGStaffForm |
| 39 manage_addMPIWGStaff = MPIWGStaff_old.manage_addMPIWGStaff | |
|
0
bca61e893fcc
first checkin of MPIWGWeb r2 branch from CVS into mercurial
casties
parents:
diff
changeset
|
40 |
|
bca61e893fcc
first checkin of MPIWGWeb r2 branch from CVS into mercurial
casties
parents:
diff
changeset
|
41 |
| 2 | 42 class MPIWGStaffFolder(ZDBInterfaceFolder): |
| 43 """Folder of staff objects""" | |
| 186 | 44 implements(IPublishTraverse) |
| 2 | 45 |
| 46 meta_type="MPIWGStaffFolder" | |
| 47 security=ClassSecurityInfo() | |
| 3 | 48 |
| 49 # | |
| 50 # templates | |
| 51 # | |
| 52 member_index_html = PageTemplateFile('zpt/staff/member_index_html', globals()) | |
| 159 | 53 edit_css = ImageFile('css/edit.css', globals()) |
| 3 | 54 |
| 55 | |
| 56 # | |
| 57 # hook into traversal to create folder of virtual staff objects | |
| 58 # like /members/$username/index_html | |
| 59 # | |
| 186 | 60 def publishTraverse(self, request, name): |
| 61 """change the traversal""" | |
| 62 # get stored path | |
| 63 logging.debug("publishtraverse: name=%s"%(name)) | |
| 3 | 64 |
| 186 | 65 # try name as username |
| 66 member = self.getMember(username=name) | |
| 67 if member is not None: | |
| 68 # traverse to MPIWGStaffMember object | |
| 69 member = member.__of__(self) | |
| 70 return member | |
| 71 | |
| 72 # use default traverser | |
| 73 tr = DefaultPublishTraverse(self, request) | |
| 74 ob = tr.publishTraverse(request, name) | |
| 75 return ob | |
| 76 | |
| 3 | 77 |
| 78 def getMember(self, username=None, key=None): | |
| 79 """returns a MPIWGStaffMember object if the username exists""" | |
| 80 member = None | |
| 81 if username is not None: | |
| 82 # TODO: we should have a username column | |
| 83 email = '%s@mpiwg-berlin.mpg.de'%username | |
| 84 content = self.executeZSQL("select * from personal_www where e_mail = %s", [email]) | |
| 85 if len(content) > 0: | |
| 86 | 86 member = MPIWGStaffMember(self, dbresult=content[0]) |
| 3 | 87 |
| 88 elif key is not None: | |
|
222
95e0087b9e19
removed some comparisons that ignore person-id case.
casties
parents:
217
diff
changeset
|
89 content = self.executeZSQL("select * from personal_www where key = %s", [key]) |
| 3 | 90 if len(content) > 0: |
| 86 | 91 member = MPIWGStaffMember(self, dbresult=content[0]) |
| 3 | 92 |
| 93 return member | |
| 94 | |
| 2 | 95 |
| 40 | 96 def isActiveMember(self, key): |
| 97 """returns if member key is active""" | |
|
222
95e0087b9e19
removed some comparisons that ignore person-id case.
casties
parents:
217
diff
changeset
|
98 res = self.executeZSQL("select * from personal_www where key = %s and publish_the_data = 'yes'", [key]) |
| 40 | 99 return len(res) > 0 |
| 100 | |
| 101 | |
| 206 | 102 def getMemberList(self, department=None, sortBy='last_name', onlyCurrent=False, arrivedWithin=None, |
| 263 | 103 onlyPublished=True, onlyWithEmail=True, onlyScholar=True, status=None, limit=0): |
| 86 | 104 """Return the list of members. |
| 105 | |
| 106 Returns a list of MPIWGStaffMember objects. | |
| 107 """ | |
| 108 members = [] | |
| 206 | 109 args = [] |
| 110 wheres = [] | |
|
189
cc5198541af8
erzeugen neuer eintr?ge auf der homepage mittels updatexml
dwinter
parents:
188
diff
changeset
|
111 |
| 206 | 112 if onlyPublished: |
| 113 wheres.append("publish_the_data = 'yes'") | |
| 114 | |
| 115 if onlyWithEmail: | |
| 116 wheres.append("e_mail <> ''") | |
| 117 | |
| 118 if onlyScholar: | |
| 119 wheres.append("is_scholar = 'yes'") | |
| 120 | |
| 93 | 121 if department is not None: |
| 206 | 122 wheres.append("department ilike %s") |
| 93 | 123 args.append('%%%s%%'%department) |
| 86 | 124 |
| 125 if onlyCurrent: | |
| 206 | 126 wheres.append("date_from < CURRENT_DATE") |
| 86 | 127 |
| 175 | 128 if arrivedWithin is not None: |
| 206 | 129 wheres.append("date_from > CURRENT_DATE - interval %s") |
| 175 | 130 args.append(arrivedWithin) |
| 263 | 131 |
| 132 if status is not None: | |
| 133 wheres.append("status ilike %s") | |
| 134 args.append('%%%s%%'%status) | |
| 206 | 135 |
| 136 # assemble query | |
| 137 query = "SELECT * FROM personal_www_list" | |
| 138 if len(wheres) > 0: | |
| 139 query += " WHERE " + " AND ".join(wheres) | |
| 175 | 140 |
| 86 | 141 if sortBy == 'last_name': |
| 206 | 142 query += " ORDER BY lower(last_name)" |
| 86 | 143 elif sortBy == 'date_from': |
| 206 | 144 query += " ORDER BY date_from DESC" |
| 233 | 145 elif sortBy: |
| 146 query += ' ORDER BY "%s"'%sqlName(sortBy) | |
| 86 | 147 |
| 148 if limit > 0: | |
| 206 | 149 query += " LIMIT %s"%int(limit) |
| 86 | 150 |
| 93 | 151 result = self.executeZSQL(query, args) |
| 86 | 152 for res in result: |
| 153 members.append(MPIWGStaffMember(self, dbresult=res)) | |
| 154 | |
| 155 return members | |
| 156 | |
| 157 | |
| 37 | 158 def sortPriority(self,list): |
| 159 def sort(x,y): | |
| 160 try: | |
| 161 xInt=int(x.priority) | |
| 162 except: | |
| 163 xInt=0 | |
| 164 try: | |
| 165 yInt=int(y.priority) | |
| 166 except: | |
| 167 yInt=0 | |
| 168 | |
| 169 return cmp(xInt,yInt) | |
| 170 | |
| 171 if not list: | |
| 172 return [] | |
| 173 tmp=[x for x in list] | |
| 174 tmp.sort(sort) | |
| 175 | |
| 176 return tmp | |
| 177 | |
| 86 | 178 |
| 106 | 179 def importSortingModeFromOldStaff(self): |
| 180 """ only used for the migration to the new website """ | |
| 181 ret=[] | |
| 182 for member in self.getMemberList(): | |
| 183 email = member.content.e_mail | |
| 184 un = email.split("@")[0] | |
| 185 | |
| 186 logging.debug(un) | |
| 122 | 187 olduser = self.members_old.get(un) |
| 106 | 188 |
| 189 if not olduser is None: | |
| 190 mode =olduser.getSortingMode() | |
| 191 | |
| 192 | |
| 193 if mode.startswith("year"): | |
| 194 mode="year" | |
| 195 | |
| 196 query="UPDATE personal_www SET publications_mode=%s WHERE key=%s" | |
| 197 | |
| 198 self.executeZSQL(query,[mode,member.getKey()]) | |
| 199 | |
| 200 return ret | |
| 201 | |
| 202 | |
| 203 def importPublishFotoFromOldStaff(self): | |
| 204 """ only used for the migration to the new website """ | |
| 205 ret=[] | |
| 206 for member in self.getMemberList(): | |
| 207 email = member.content.e_mail | |
| 208 un = email.split("@")[0] | |
| 209 | |
| 210 logging.debug(un) | |
| 122 | 211 olduser = self.members_old.get(un) |
| 106 | 212 |
| 213 if not olduser is None: | |
| 214 mode =olduser.getPublishImage() | |
| 215 | |
| 216 | |
| 217 | |
| 218 query="UPDATE personal_www SET image_p=%s WHERE key=%s" | |
| 219 | |
| 220 self.executeZSQL(query,[mode,member.getKey()]) | |
| 221 | |
| 222 return ret | |
| 223 | |
| 224 def showDownloadableFiles(self): | |
| 225 """copy df to the new""" | |
| 226 logging.debug("huh") | |
| 227 ret=[] | |
| 228 | |
| 229 for member in self.getMemberList(onlyCurrent=True): | |
| 230 email = member.content.e_mail | |
| 231 un = email.split("@")[0] | |
| 232 | |
| 233 logging.debug(un) | |
| 234 olduser = self.www_neu.members.get(un) | |
| 235 if olduser is None: | |
| 236 continue; | |
| 237 df = olduser.get('downloadableFiles') | |
| 238 if df is not None: | |
| 239 ret.append(olduser) | |
| 240 | |
| 241 return ret,len(ret) | |
| 242 | |
| 243 | |
| 226 | 244 security.declareProtected('View management screens','createNewDBEntry') |
| 234 | 245 def createNewDBEntry(self,publish_the_data,key,name,vorname,titles_new,position,e_mail,e_mail_p,date_from,date_to,abteilung,heimat_inst, |
| 246 funded_by="",e_mail2="",txt="",txt_p="no",stay_at_mpiwg="",group="",web_object_created="no",current_work=""): | |
|
189
cc5198541af8
erzeugen neuer eintr?ge auf der homepage mittels updatexml
dwinter
parents:
188
diff
changeset
|
247 """lege person in der datenbank an""" |
|
cc5198541af8
erzeugen neuer eintr?ge auf der homepage mittels updatexml
dwinter
parents:
188
diff
changeset
|
248 |
|
cc5198541af8
erzeugen neuer eintr?ge auf der homepage mittels updatexml
dwinter
parents:
188
diff
changeset
|
249 if date_to=="": # wenn date_to leer |
| 234 | 250 date_to="date_none" |
| 106 | 251 |
|
189
cc5198541af8
erzeugen neuer eintr?ge auf der homepage mittels updatexml
dwinter
parents:
188
diff
changeset
|
252 if date_from=="": # wenn date_fromleer |
| 234 | 253 date_from="date_none" |
|
189
cc5198541af8
erzeugen neuer eintr?ge auf der homepage mittels updatexml
dwinter
parents:
188
diff
changeset
|
254 msg="" |
|
cc5198541af8
erzeugen neuer eintr?ge auf der homepage mittels updatexml
dwinter
parents:
188
diff
changeset
|
255 #test ob id schon existiert |
| 226 | 256 #if self.ZSQLQuery("select key from personal_www where key='%s'"%id): |
| 234 | 257 if self.getMember(key=key) is not None: |
|
189
cc5198541af8
erzeugen neuer eintr?ge auf der homepage mittels updatexml
dwinter
parents:
188
diff
changeset
|
258 return False,"ERROR:key%s already exists"%key |
|
cc5198541af8
erzeugen neuer eintr?ge auf der homepage mittels updatexml
dwinter
parents:
188
diff
changeset
|
259 |
|
cc5198541af8
erzeugen neuer eintr?ge auf der homepage mittels updatexml
dwinter
parents:
188
diff
changeset
|
260 #eintragen |
|
cc5198541af8
erzeugen neuer eintr?ge auf der homepage mittels updatexml
dwinter
parents:
188
diff
changeset
|
261 columnlist="""publish_the_data,key,last_name,first_name,titles_new,status,e_mail,e_mail_p,date_from,date_to,department,home_inst,funded_by,e_mail2,date_stay_at_mpiwg,web_object_created,"group",current_work,current_work_p """ |
| 234 | 262 insertTuple=(publish_the_data,key,name,vorname,titles_new,position,e_mail,e_mail_p,date_from,date_to,abteilung,heimat_inst, |
| 263 funded_by,e_mail2,stay_at_mpiwg,web_object_created,group,current_work,"yes") | |
|
189
cc5198541af8
erzeugen neuer eintr?ge auf der homepage mittels updatexml
dwinter
parents:
188
diff
changeset
|
264 |
|
cc5198541af8
erzeugen neuer eintr?ge auf der homepage mittels updatexml
dwinter
parents:
188
diff
changeset
|
265 insert=[] |
|
cc5198541af8
erzeugen neuer eintr?ge auf der homepage mittels updatexml
dwinter
parents:
188
diff
changeset
|
266 for element in insertTuple: |
|
cc5198541af8
erzeugen neuer eintr?ge auf der homepage mittels updatexml
dwinter
parents:
188
diff
changeset
|
267 if element=="date_none": # date_none eintrag wird zu null uebersetzt |
| 226 | 268 insert.append(None) |
|
189
cc5198541af8
erzeugen neuer eintr?ge auf der homepage mittels updatexml
dwinter
parents:
188
diff
changeset
|
269 else: |
| 226 | 270 insert.append(element) |
|
189
cc5198541af8
erzeugen neuer eintr?ge auf der homepage mittels updatexml
dwinter
parents:
188
diff
changeset
|
271 |
| 226 | 272 #insertStr=",".join(insert) |
| 273 insertStr=("%s," * len(insert))[:-1] | |
|
189
cc5198541af8
erzeugen neuer eintr?ge auf der homepage mittels updatexml
dwinter
parents:
188
diff
changeset
|
274 queryStr="INSERT INTO personal_www (%s) VALUES (%s)"%(columnlist,insertStr) |
|
210
7791d4fc8a0e
remove "set datestyle" as it confuses psycopg date parsing. make sure postgresql default is set accordingly.
casties
parents:
208
diff
changeset
|
275 #self.ZSQLQuery("SET DATESTYLE TO 'German'") |
| 226 | 276 #self.ZSQLQuery(queryStr) |
| 234 | 277 # TODO: is there a better way for dates? |
| 278 self.executeZSQL("SET DATESTYLE TO 'German'") | |
| 226 | 279 self.executeZSQL(queryStr, insert) |
|
189
cc5198541af8
erzeugen neuer eintr?ge auf der homepage mittels updatexml
dwinter
parents:
188
diff
changeset
|
280 logging.info("createNewDBEntry %s:"%queryStr) |
|
cc5198541af8
erzeugen neuer eintr?ge auf der homepage mittels updatexml
dwinter
parents:
188
diff
changeset
|
281 #currentwork |
|
cc5198541af8
erzeugen neuer eintr?ge auf der homepage mittels updatexml
dwinter
parents:
188
diff
changeset
|
282 #if not (current_work==""): |
|
cc5198541af8
erzeugen neuer eintr?ge auf der homepage mittels updatexml
dwinter
parents:
188
diff
changeset
|
283 # queryStr="INSERT INTO current_work (key_main,current,publish) VALUES ('%s',%s,'%s')"%(key,self.ZSQLQuote(current_work),"yes") |
|
cc5198541af8
erzeugen neuer eintr?ge auf der homepage mittels updatexml
dwinter
parents:
188
diff
changeset
|
284 |
|
cc5198541af8
erzeugen neuer eintr?ge auf der homepage mittels updatexml
dwinter
parents:
188
diff
changeset
|
285 # self.ZSQLQuery(queryStr) |
|
cc5198541af8
erzeugen neuer eintr?ge auf der homepage mittels updatexml
dwinter
parents:
188
diff
changeset
|
286 |
|
cc5198541af8
erzeugen neuer eintr?ge auf der homepage mittels updatexml
dwinter
parents:
188
diff
changeset
|
287 return True,msg |
|
cc5198541af8
erzeugen neuer eintr?ge auf der homepage mittels updatexml
dwinter
parents:
188
diff
changeset
|
288 |
| 226 | 289 |
| 290 security.declareProtected('View management screens','addEmails') | |
|
189
cc5198541af8
erzeugen neuer eintr?ge auf der homepage mittels updatexml
dwinter
parents:
188
diff
changeset
|
291 def addEmails(self,RESPONSE): |
|
cc5198541af8
erzeugen neuer eintr?ge auf der homepage mittels updatexml
dwinter
parents:
188
diff
changeset
|
292 """add emails to the members from form""" |
|
cc5198541af8
erzeugen neuer eintr?ge auf der homepage mittels updatexml
dwinter
parents:
188
diff
changeset
|
293 args=self.REQUEST.form |
|
cc5198541af8
erzeugen neuer eintr?ge auf der homepage mittels updatexml
dwinter
parents:
188
diff
changeset
|
294 arg_k=args.keys() |
|
cc5198541af8
erzeugen neuer eintr?ge auf der homepage mittels updatexml
dwinter
parents:
188
diff
changeset
|
295 arg_k.remove("submit") |
|
cc5198541af8
erzeugen neuer eintr?ge auf der homepage mittels updatexml
dwinter
parents:
188
diff
changeset
|
296 ret="<html><body>" |
|
cc5198541af8
erzeugen neuer eintr?ge auf der homepage mittels updatexml
dwinter
parents:
188
diff
changeset
|
297 for key in arg_k: |
|
cc5198541af8
erzeugen neuer eintr?ge auf der homepage mittels updatexml
dwinter
parents:
188
diff
changeset
|
298 if args[key]!="": #email-adresse wurde eingetragen |
|
cc5198541af8
erzeugen neuer eintr?ge auf der homepage mittels updatexml
dwinter
parents:
188
diff
changeset
|
299 #create the object |
|
cc5198541af8
erzeugen neuer eintr?ge auf der homepage mittels updatexml
dwinter
parents:
188
diff
changeset
|
300 e_mail=args[key] |
| 226 | 301 qstr="update personal_www set web_object_created='yes', e_mail=%s where key=%s" |
| 302 self.executeZSQL(qstr, ["%s@mpiwg-berlin.mpg.de"%e_mail, key]) | |
|
189
cc5198541af8
erzeugen neuer eintr?ge auf der homepage mittels updatexml
dwinter
parents:
188
diff
changeset
|
303 |
| 226 | 304 ret+="<p>Added: %s</p>"%key |
|
189
cc5198541af8
erzeugen neuer eintr?ge auf der homepage mittels updatexml
dwinter
parents:
188
diff
changeset
|
305 |
|
cc5198541af8
erzeugen neuer eintr?ge auf der homepage mittels updatexml
dwinter
parents:
188
diff
changeset
|
306 return ret+"</body></html>" |
| 226 | 307 |
| 308 | |
| 246 | 309 def getConeIDsFromDB(self,REQUEST): |
| 310 """holt die cone ids aus personalwww und gibt sie als RDF fuer den cone import zurueck""" | |
| 311 | |
| 312 qs = "select personal_www.last_name, personal_www.first_name, keys.coneid from personal_www inner join keys on personal_www.key = keys.key_main;" | |
| 313 coneIds = self.executeZSQL(qs) | |
| 314 | |
| 315 ret="""<?xml version="1.0" encoding="UTF-8"?> | |
| 253 | 316 <rdf:RDF xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:escidoc="http://purl.org/escidoc/metadata/terms/0.1/" xmlns:eprints="http://purl.org/eprint/terms/"> |
| 246 | 317 """ |
| 318 | |
| 319 templ=""" | |
| 320 <rdf:Description rdf:about="%s"> | |
| 321 <dc:title>%s, %s</dc:title> | |
| 253 | 322 |
| 323 <escidoc:position> | |
| 324 <rdf:Description> | |
| 325 <dc:identifier>escidoc:14002</dc:identifier> | |
| 326 <eprints:affiliatedInstitution>Max Planck Institute for the History of Science, Max Planck Society</eprints:affiliatedInstitution> | |
| 327 </rdf:Description> | |
| 328 </escidoc:position> | |
| 329 | |
| 330 | |
| 331 | |
| 246 | 332 </rdf:Description> |
| 333 """ | |
| 334 print coneIds.names() | |
| 335 for coneId in coneIds: | |
| 336 | |
| 337 ret+=templ%(coneId["coneid"],coneId["last_name"],coneId["first_name"]) | |
| 338 | |
| 339 ret+=""" | |
| 340 </rdf:RDF> | |
| 341 """ | |
| 342 if REQUEST is not None: | |
| 343 REQUEST.response.setHeader("Content-type", "text/XML") | |
| 344 return ret | |
| 345 | |
| 2 | 346 def manage_addMPIWGStaffFolderForm(self): |
| 347 """form for adding the project""" | |
| 348 pt=PageTemplateFile('zpt/addMPIWGStaffFolderForm', globals()).__of__(self) | |
| 349 return pt() | |
| 350 | |
| 351 def manage_addMPIWGStaffFolder(self,id,title,RESPONSE=None): | |
| 352 """add it""" | |
| 353 newObj=MPIWGStaffFolder(id,title) | |
| 354 | |
| 355 self._setObject(id,newObj) | |
| 356 | |
| 357 if RESPONSE is not None: | |
| 358 RESPONSE.redirect('manage_main') | |
| 359 | |
| 3 | 360 |
| 37 | 361 class MPIWGStaffMember(Folder): |
| 3 | 362 """MPIWG staff member object from database""" |
| 363 | |
| 364 security = ClassSecurityInfo() | |
| 65 | 365 |
| 366 # templates | |
| 367 mainEditFile=PageTemplateFile('zpt/staff/edit_main', globals()) | |
| 100 | 368 talks_full_html = PageTemplateFile('zpt/staff/talks_full_html', globals()) |
| 369 teaching_full_html = PageTemplateFile('zpt/staff/teaching_full_html', globals()) | |
| 370 | |
| 3 | 371 |
| 372 def __init__(self, folder, dbresult): | |
| 86 | 373 """constructor: takes parent MPIWGStaffFolder and content (DB row)""" |
| 3 | 374 self.folder = folder |
| 86 | 375 self.content = dbresult |
| 3 | 376 |
| 186 | 377 |
| 378 def index_html(self, REQUEST, RESPONSE): | |
| 379 """show homepage""" | |
| 380 # get template /template/member_index_html (with acquisition) | |
| 381 pt = getattr(self.template, 'member_index_html', None) | |
| 382 if pt is not None: | |
| 383 return pt(member=self) | |
| 384 | |
| 385 return "No template /template/member_index_html" | |
| 386 | |
| 387 | |
| 3 | 388 def isValid(self): |
| 389 """returns if this member exists""" | |
| 390 return len(self.content) > 0 | |
| 391 | |
| 79 | 392 def isActive(self): |
| 393 """Return if this member is visible (published).""" | |
| 394 return (self.content.publish_the_data == 'yes') | |
| 395 | |
| 3 | 396 def getKey(self): |
| 397 """returns the db key""" | |
| 398 return self.content.key | |
| 399 | |
| 400 def getUsername(self): | |
| 401 """returns the username""" | |
| 402 id = re.sub('@mpiwg-berlin\.mpg\.de', '', self.content.e_mail) | |
| 217 | 403 return str(id) |
| 3 | 404 |
| 86 | 405 getId = getUsername |
| 406 | |
| 46 | 407 def getConeId(self): |
| 408 """return cone ID""" | |
| 86 | 409 results= self.folder.executeZSQL("SELECT coneid FROM keys WHERE key_main = %s",[self.content.key]) |
| 46 | 410 for res in results: |
| 79 | 411 return res.coneid |
| 46 | 412 return None |
| 413 | |
| 159 | 414 def getPublishedImageUrl(self, width=None, height=None, showAlways=False): |
| 3 | 415 """returns the URL to the image if it is published""" |
| 159 | 416 if self.content.image_p == 'yes' or showAlways: |
| 3 | 417 url = 'http://digilib.mpiwg-berlin.mpg.de/digitallibrary/Scaler?fn=permanent/mpiwg/staff/%s'%self.getUsername() |
| 159 | 418 if width is not None: |
| 419 url += '&dw=%s'%width | |
| 420 | |
| 421 if height is not None: | |
| 422 url += '&dh=%s'%height | |
| 423 | |
| 3 | 424 return url |
| 425 | |
| 426 return None | |
| 427 | |
| 428 def getContent(self): | |
| 429 """returns the db content of this object""" | |
| 430 return self.content | |
| 431 | |
| 37 | 432 |
| 3 | 433 # TODO: ugly! |
| 434 security.declarePublic('sortBibliography') | |
| 79 | 435 def sortBibliography(self, bib, sortingMode=None, max=None): |
| 3 | 436 """sort bibliography""" |
| 437 if not sortingMode: | |
| 438 sortingMode= "priority" | |
| 439 | |
| 440 l = [x for x in bib] | |
| 441 | |
| 442 if sortingMode == "year": | |
| 443 l.sort(key=lambda x: getInt(x.year)) | |
| 444 else: | |
| 445 l.sort(key=lambda x: getInt(x.priority)) | |
| 446 | |
| 447 if max: | |
| 79 | 448 return l[0:max] |
| 3 | 449 else: |
| 450 return l | |
| 451 | |
| 37 | 452 |
| 86 | 453 getUrl = MPIWGHelper.getUrl |
| 37 | 454 |
| 233 | 455 |
| 456 def getProfile(self, filter=None, length=0): | |
| 457 """Return the profile""" | |
| 458 logging.debug("getProfile: self.content=%s"%(repr(self.content))) | |
| 459 text = self.content.profile | |
| 460 if filter == 'plaintext': | |
| 461 # filter out any tags, keep only text | |
| 462 text = getPlaintext(text, length=length, wordwrap=True, ignoretags=['style']) | |
| 463 | |
| 464 return text | |
| 465 | |
| 466 | |
| 100 | 467 def getTalks(self, published=True, sortBy='priority'): |
| 468 """Return the list of talks""" | |
| 469 query = "SELECT oid,* FROM talks WHERE key_main = %s" | |
| 470 if published: | |
| 471 query += " and published = 'yes'" | |
| 472 | |
| 473 if sortBy == 'priority': | |
| 474 query += " order by priority" | |
| 475 | |
| 217 | 476 return self.folder.executeZSQL(query, [self.getKey()]) |
| 477 | |
| 478 | |
| 479 def getTalksCal(self): | |
| 480 """Return the talks calendar object (MPIWGIcsManager)""" | |
| 481 try: | |
| 482 cal = self.folder.get('calendars').get("%s_talks"%self.getUsername()) | |
| 483 return cal | |
| 484 except: | |
| 485 return None | |
| 486 | |
| 37 | 487 |
| 100 | 488 def getTeaching(self, published=True, sortBy='priority'): |
| 489 """Return the list of teaching activities""" | |
| 490 query = "SELECT oid,* FROM teaching WHERE key_main = %s" | |
| 491 if published: | |
| 492 query += " AND published = 'yes'" | |
| 493 | |
| 494 if sortBy == 'priority': | |
| 495 query += " ORDER BY priority" | |
| 496 | |
| 217 | 497 return self.folder.executeZSQL(query,[self.getKey()]) |
| 37 | 498 |
| 499 | |
| 500 def getLastUpdateCV(self): | |
| 501 """getDate of Last Update""" | |
| 502 try: | |
| 217 | 503 ob=self.folder.get("downloadableFiles").get("%s_cv.pdf"%self.getUsername()) |
| 504 return datetime.datetime.fromtimestamp(ob._p_mtime) | |
| 37 | 505 except: |
| 162 | 506 return "No file yet!" |
| 86 | 507 |
| 37 | 508 |
| 509 def getLastUpdatePublications(self): | |
| 510 """getDate of Last Update""" | |
| 511 try: | |
| 217 | 512 ob=self.folder.get("downloadableFiles").get("%s_publications.pdf"%self.getUsername()) |
| 513 return datetime.datetime.fromtimestamp(ob._p_mtime) | |
| 37 | 514 except: |
| 162 | 515 return "No file yet!" |
| 37 | 516 |
| 517 | |
| 518 def downloadCV(self,REQUEST): | |
| 194 | 519 """download the cv""" |
| 217 | 520 ob=self.folder.get("downloadableFiles").get("%s_cv.pdf" % self.getUsername()) |
| 37 | 521 REQUEST.RESPONSE.redirect(ob.absolute_url()) |
| 522 | |
| 217 | 523 |
| 37 | 524 def downloadPublications(self,REQUEST): |
| 194 | 525 """donwload the publication list""" |
| 217 | 526 ob=self.folder.get("downloadableFiles").get("%s_publications.pdf"%self.getUsername()) |
| 37 | 527 REQUEST.RESPONSE.redirect(ob.absolute_url()) |
| 528 | |
| 159 | 529 |
| 530 def getAdditionalLinks(self): | |
|
208
6d6076e28430
fix deleteField for additionalLink (still ugly though)
casties
parents:
206
diff
changeset
|
531 return self.folder.executeZSQL("SELECT oid,* FROM additionallink WHERE key_main = %s ORDER BY priority",[self.content.key]) |
| 159 | 532 |
| 37 | 533 |
| 534 def getPathStyle(self, path, selected, style=""): | |
| 535 """returns a string with the given style + 'sel' if path == selected.""" | |
| 536 if path == selected: | |
| 537 return style + 'sel' | |
| 538 else: | |
| 539 return style | |
| 540 | |
| 541 | |
| 542 security.declareProtected('View management screens','edit') | |
| 543 def edit(self,REQUEST=None): | |
| 544 """Edit the basic information""" | |
| 545 if REQUEST: | |
| 546 argv=REQUEST.form | |
| 547 | |
| 548 if argv.has_key('last_name'): #got data to change | |
| 149 | 549 self.invalidate_cache() |
| 37 | 550 self.changeData(argv); |
| 551 | |
| 159 | 552 pt=PageTemplateFile('zpt/staff/edit_basic', globals()).__of__(self) |
| 37 | 553 return pt() |
| 554 | |
| 555 | |
| 159 | 556 security.declareProtected('View management screens','editShortEntry') |
| 37 | 557 def editShortEntry(self,REQUEST=None): |
| 558 """Edit the basic information""" | |
| 559 if REQUEST: | |
| 560 argv=REQUEST.form | |
| 561 | |
| 562 if argv.has_key('current_work'): #got data to change | |
| 149 | 563 self.invalidate_cache() |
| 37 | 564 self.changeData(argv); |
| 565 | |
| 159 | 566 pt=PageTemplateFile('zpt/staff/edit_shortEntry', globals()).__of__(self) |
| 37 | 567 return pt() |
| 568 | |
| 569 | |
| 159 | 570 security.declareProtected('View management screens', 'editProfile') |
| 37 | 571 def editProfile(self, REQUEST=None): |
| 159 | 572 """edit Profile, new entry replaces CD, current work and research interests""" |
| 573 if REQUEST: | |
| 574 kupu = REQUEST.form.get('kupu', None); | |
| 575 preview = REQUEST.form.get('preview', None); | |
| 3 | 576 |
| 159 | 577 if kupu: |
| 578 start = kupu.find("<body>") | |
| 579 end = kupu.find("</body>") | |
| 187 | 580 newcontent = kupu[start+6:end] |
| 581 query = "UPDATE personal_www SET profile=%s WHERE key=%s" | |
| 582 self.executeZSQL(query, [newcontent, self.content.key]) | |
| 37 | 583 |
| 159 | 584 if preview: |
| 585 pass | |
| 586 # TODO: not supported yet | |
| 587 # if RESPONSE: | |
| 588 # self.redirect(RESPONSE,"editProfile") | |
| 589 # return self.preview(newcontent) | |
| 37 | 590 |
| 159 | 591 pt = PageTemplateFile('zpt/staff/edit_profile.zpt', globals()).__of__(self) |
| 592 return pt() | |
| 37 | 593 |
| 594 | |
| 595 security.declareProtected('View management screens','editTalks') | |
| 596 def editTalks(self,REQUEST): | |
| 597 """edit talks""" | |
| 217 | 598 pt=PageTemplateFile('zpt/staff/edit_talks.zpt', globals()).__of__(self) |
| 599 | |
| 37 | 600 if REQUEST: |
| 601 argv=REQUEST.form | |
| 602 | |
| 217 | 603 url = argv.get('ics_url', None) |
| 604 if url: | |
|
243
980794794bb5
added preferences for number of publications, talks, and teachings on profile page.
casties
parents:
242
diff
changeset
|
605 # |
|
242
0b7a95c02f68
added preference for number of talks from calendar on profile page.
casties
parents:
238
diff
changeset
|
606 # ICS URL driven talks |
|
243
980794794bb5
added preferences for number of publications, talks, and teachings on profile page.
casties
parents:
242
diff
changeset
|
607 # |
| 217 | 608 cal_id = "%s_talks"%self.getUsername() |
| 609 # use ICS calendar | |
| 610 cal = self.getTalksCal() | |
|
238
5f5d7f07c1bd
added "show only upcoming" option for talks from calendar.
casties
parents:
237
diff
changeset
|
611 if cal is None: |
|
5f5d7f07c1bd
added "show only upcoming" option for talks from calendar.
casties
parents:
237
diff
changeset
|
612 # create new calendar |
| 251 | 613 cal = MPIWGIcsManager.MPIWGIcsManager(cal_id, '', url, defaultProps=MPIWGIcsManager.calendar_props) |
|
238
5f5d7f07c1bd
added "show only upcoming" option for talks from calendar.
casties
parents:
237
diff
changeset
|
614 self.folder.get('calendars')[cal_id] = cal |
|
5f5d7f07c1bd
added "show only upcoming" option for talks from calendar.
casties
parents:
237
diff
changeset
|
615 |
|
5f5d7f07c1bd
added "show only upcoming" option for talks from calendar.
casties
parents:
237
diff
changeset
|
616 else: |
| 217 | 617 # calendar exists |
|
238
5f5d7f07c1bd
added "show only upcoming" option for talks from calendar.
casties
parents:
237
diff
changeset
|
618 if cal.url != url: |
|
5f5d7f07c1bd
added "show only upcoming" option for talks from calendar.
casties
parents:
237
diff
changeset
|
619 # remove and re-create |
| 217 | 620 del self.folder.get('calendars')[cal_id] |
| 251 | 621 cal = MPIWGIcsManager.MPIWGIcsManager(cal_id, '', url, defaultProps=MPIWGIcsManager.calendar_props) |
|
238
5f5d7f07c1bd
added "show only upcoming" option for talks from calendar.
casties
parents:
237
diff
changeset
|
622 self.folder.get('calendars')[cal_id] = cal |
| 217 | 623 |
|
238
5f5d7f07c1bd
added "show only upcoming" option for talks from calendar.
casties
parents:
237
diff
changeset
|
624 # show only upcoming |
|
5f5d7f07c1bd
added "show only upcoming" option for talks from calendar.
casties
parents:
237
diff
changeset
|
625 upcoming = argv.get('only_upcoming', None) |
|
5f5d7f07c1bd
added "show only upcoming" option for talks from calendar.
casties
parents:
237
diff
changeset
|
626 cal.setFlag('only_upcoming', (upcoming == 'yes')) |
|
242
0b7a95c02f68
added preference for number of talks from calendar on profile page.
casties
parents:
238
diff
changeset
|
627 # number of events |
|
243
980794794bb5
added preferences for number of publications, talks, and teachings on profile page.
casties
parents:
242
diff
changeset
|
628 talks_num = int(argv.get('talks_num', 5)) |
|
980794794bb5
added preferences for number of publications, talks, and teachings on profile page.
casties
parents:
242
diff
changeset
|
629 self.changeData({'talks_num': talks_num}) |
| 217 | 630 |
|
275
3f9ba7a8cb27
fixed fix for: 175: removing the ICS URL in editTalks doesn't work
casties
parents:
274
diff
changeset
|
631 elif argv.has_key('only_upcoming'): |
|
274
87e7e210968d
fixed: 175: removing the ICS URL in editTalks doesn't work
casties
parents:
263
diff
changeset
|
632 # delete calendar if it exists |
|
87e7e210968d
fixed: 175: removing the ICS URL in editTalks doesn't work
casties
parents:
263
diff
changeset
|
633 if self.getTalksCal(): |
|
87e7e210968d
fixed: 175: removing the ICS URL in editTalks doesn't work
casties
parents:
263
diff
changeset
|
634 cal_id = "%s_talks"%self.getUsername() |
|
87e7e210968d
fixed: 175: removing the ICS URL in editTalks doesn't work
casties
parents:
263
diff
changeset
|
635 del self.folder.get('calendars')[cal_id] |
|
87e7e210968d
fixed: 175: removing the ICS URL in editTalks doesn't work
casties
parents:
263
diff
changeset
|
636 |
|
275
3f9ba7a8cb27
fixed fix for: 175: removing the ICS URL in editTalks doesn't work
casties
parents:
274
diff
changeset
|
637 elif argv.has_key('main_fields'): #got data to change |
|
3f9ba7a8cb27
fixed fix for: 175: removing the ICS URL in editTalks doesn't work
casties
parents:
274
diff
changeset
|
638 # |
|
3f9ba7a8cb27
fixed fix for: 175: removing the ICS URL in editTalks doesn't work
casties
parents:
274
diff
changeset
|
639 # manually edited talks |
|
3f9ba7a8cb27
fixed fix for: 175: removing the ICS URL in editTalks doesn't work
casties
parents:
274
diff
changeset
|
640 # |
|
3f9ba7a8cb27
fixed fix for: 175: removing the ICS URL in editTalks doesn't work
casties
parents:
274
diff
changeset
|
641 self.invalidate_cache() |
|
3f9ba7a8cb27
fixed fix for: 175: removing the ICS URL in editTalks doesn't work
casties
parents:
274
diff
changeset
|
642 self.changeAdditionalData(argv); |
|
3f9ba7a8cb27
fixed fix for: 175: removing the ICS URL in editTalks doesn't work
casties
parents:
274
diff
changeset
|
643 # number of events |
|
3f9ba7a8cb27
fixed fix for: 175: removing the ICS URL in editTalks doesn't work
casties
parents:
274
diff
changeset
|
644 talks_num = int(argv.get('talks_num', 5)) |
|
3f9ba7a8cb27
fixed fix for: 175: removing the ICS URL in editTalks doesn't work
casties
parents:
274
diff
changeset
|
645 self.changeData({'talks_num': talks_num}) |
| 37 | 646 |
| 647 return pt() | |
| 648 | |
| 649 | |
| 650 security.declareProtected('View management screens','editTeaching') | |
| 651 def editTeaching(self,REQUEST): | |
| 652 """edit teaching""" | |
| 653 if REQUEST: | |
| 654 argv=REQUEST.form | |
| 655 | |
| 656 if argv.has_key('main_fields'): #got data to change | |
| 149 | 657 self.invalidate_cache() |
| 37 | 658 self.changeAdditionalData(argv); |
|
243
980794794bb5
added preferences for number of publications, talks, and teachings on profile page.
casties
parents:
242
diff
changeset
|
659 # number of items |
|
980794794bb5
added preferences for number of publications, talks, and teachings on profile page.
casties
parents:
242
diff
changeset
|
660 teachings_num = int(argv.get('teachings_num', 5)) |
|
980794794bb5
added preferences for number of publications, talks, and teachings on profile page.
casties
parents:
242
diff
changeset
|
661 self.changeData({'teachings_num': teachings_num}) |
| 37 | 662 |
| 159 | 663 pt=PageTemplateFile('zpt/staff/edit_teaching.zpt', globals()).__of__(self) |
| 37 | 664 return pt() |
| 665 | |
| 666 | |
| 159 | 667 security.declareProtected('View management screens','editAdditionalLinks') |
| 37 | 668 def editAdditionalLinks(self,REQUEST): |
| 159 | 669 """editiere die additional link von der Webseite""" |
| 37 | 670 if REQUEST: |
| 671 argv=REQUEST.form | |
| 672 | |
| 673 if argv.has_key('main_fields'): #got data to change | |
| 149 | 674 self.invalidate_cache() |
| 37 | 675 self.changeAdditionalData(argv); |
| 676 | |
| 159 | 677 pt=PageTemplateFile('zpt/staff/edit_additionalLinks.zpt', globals()).__of__(self) |
| 37 | 678 return pt() |
| 679 | |
| 680 | |
| 86 | 681 security.declareProtected('View management screens','editDownloads') |
| 37 | 682 def editDownloads(self,REQUEST): |
| 683 """editiere die Downloads von der Webseite""" | |
| 684 | |
| 159 | 685 pt=PageTemplateFile('zpt/staff/edit_downloads.zpt', globals()).__of__(self) |
| 37 | 686 return pt() |
| 687 | |
| 47 | 688 def editPublications(self,REQUEST): |
| 689 """editiere die Publications von der Webseite""" | |
| 690 data=REQUEST.form | |
|
243
980794794bb5
added preferences for number of publications, talks, and teachings on profile page.
casties
parents:
242
diff
changeset
|
691 newData = {} |
| 47 | 692 |
|
243
980794794bb5
added preferences for number of publications, talks, and teachings on profile page.
casties
parents:
242
diff
changeset
|
693 if 'selectionMode' in data: |
|
980794794bb5
added preferences for number of publications, talks, and teachings on profile page.
casties
parents:
242
diff
changeset
|
694 newData['publications_mode'] = data['selectionMode'] |
| 47 | 695 |
|
243
980794794bb5
added preferences for number of publications, talks, and teachings on profile page.
casties
parents:
242
diff
changeset
|
696 if 'publications_num' in data: |
|
980794794bb5
added preferences for number of publications, talks, and teachings on profile page.
casties
parents:
242
diff
changeset
|
697 newData['publications_num'] = int(data['publications_num']) |
|
980794794bb5
added preferences for number of publications, talks, and teachings on profile page.
casties
parents:
242
diff
changeset
|
698 |
|
980794794bb5
added preferences for number of publications, talks, and teachings on profile page.
casties
parents:
242
diff
changeset
|
699 if len(newData) > 0: |
|
980794794bb5
added preferences for number of publications, talks, and teachings on profile page.
casties
parents:
242
diff
changeset
|
700 self.changeData(newData) |
| 47 | 701 |
| 159 | 702 pt=PageTemplateFile('zpt/staff/edit_publications.zpt', globals()).__of__(self) |
| 47 | 703 return pt() |
| 704 | |
| 705 | |
| 159 | 706 security.declareProtected('View management screens','editImage') |
| 707 def editImage(self,REQUEST=None): | |
| 708 """Edit the image information""" | |
| 709 if REQUEST: | |
| 710 argv=REQUEST.form | |
| 711 | |
| 712 if argv.has_key('image_p'): #got data to change | |
| 713 self.invalidate_cache() | |
| 714 self.changeData(argv); | |
| 715 | |
| 716 pt=PageTemplateFile('zpt/staff/edit_image', globals()).__of__(self) | |
| 717 return pt() | |
| 718 | |
| 719 | |
| 47 | 720 def refresh_content(self,): |
| 721 self.content = self.folder.executeZSQL("select * from personal_www where key = %s", [self.getKey()])[0] | |
| 722 | |
| 723 | |
| 37 | 724 def changeDownloads(self,REQUEST): |
| 725 """"change the downloadable files""" | |
| 149 | 726 self.invalidate_cache(); |
| 37 | 727 |
| 728 data=REQUEST.form | |
| 729 | |
| 217 | 730 ob = self.folder.get("downloadableFiles") |
| 37 | 731 |
| 732 if data.get('cv_publish',None): | |
| 733 | |
| 734 self.changeData({'cv_p':data['cv_publish']}) | |
| 735 | |
| 736 if data.get('publications_publish',None): | |
| 737 self.changeData({'publications_p':data['publications_publish']}) | |
| 738 | |
| 739 | |
| 740 if data.get('cv_pdf',None): | |
| 741 cvName ="%s_cv.pdf"%self.getUsername() | |
| 742 cvName=cvName.encode('utf-8') | |
| 195 | 743 |
| 37 | 744 if not hasattr(ob,cvName): |
| 194 | 745 cvFile = ExtFile.ExtFile(cvName,cvName) |
| 37 | 746 ob._setObject(cvName,cvFile) |
| 747 | |
| 748 cvFile = getattr(ob,cvName) | |
| 749 | |
| 750 cvFile.manage_upload(file=data['cv_pdf']) | |
| 751 | |
| 752 if data.get('publications_pdf',None): | |
| 753 pdfName="%s_publications.pdf"%self.getUsername() | |
| 754 pdfName=pdfName.encode('utf-8') | |
| 755 | |
| 756 if not hasattr(ob,pdfName): | |
| 194 | 757 cvFile = ExtFile.ExtFile(pdfName,pdfName) |
| 37 | 758 ob._setObject(pdfName,cvFile) |
| 759 | |
| 760 cvFile = getattr(ob,pdfName) | |
| 761 | |
| 762 cvFile.manage_upload(file=data['publications_pdf']) | |
| 763 | |
| 764 | |
| 194 | 765 REQUEST.response.redirect("editDownloads"); |
| 37 | 766 |
| 767 | |
|
188
16d55695f1c8
fix updating staff entries through "Update personal homepages". (creating new entries doesn't work)
casties
parents:
187
diff
changeset
|
768 security.declareProtected('View management screens','changeData') |
|
16d55695f1c8
fix updating staff entries through "Update personal homepages". (creating new entries doesn't work)
casties
parents:
187
diff
changeset
|
769 def changeData(self, changeSet): |
| 37 | 770 """changes the data in the database, changeset expects field --> value.""" |
|
188
16d55695f1c8
fix updating staff entries through "Update personal homepages". (creating new entries doesn't work)
casties
parents:
187
diff
changeset
|
771 fields = [] |
|
16d55695f1c8
fix updating staff entries through "Update personal homepages". (creating new entries doesn't work)
casties
parents:
187
diff
changeset
|
772 values = [] |
| 37 | 773 for field in changeSet.keys(): |
| 159 | 774 if hasattr(self.content, field): |
| 37 | 775 logging.debug("Changing: %s"%field) |
|
188
16d55695f1c8
fix updating staff entries through "Update personal homepages". (creating new entries doesn't work)
casties
parents:
187
diff
changeset
|
776 fields.append('"'+sqlName(field)+'" = %s') |
|
16d55695f1c8
fix updating staff entries through "Update personal homepages". (creating new entries doesn't work)
casties
parents:
187
diff
changeset
|
777 values.append(changeSet.get(field)) |
|
16d55695f1c8
fix updating staff entries through "Update personal homepages". (creating new entries doesn't work)
casties
parents:
187
diff
changeset
|
778 |
|
16d55695f1c8
fix updating staff entries through "Update personal homepages". (creating new entries doesn't work)
casties
parents:
187
diff
changeset
|
779 if len(fields) == 0: |
|
16d55695f1c8
fix updating staff entries through "Update personal homepages". (creating new entries doesn't work)
casties
parents:
187
diff
changeset
|
780 return |
|
16d55695f1c8
fix updating staff entries through "Update personal homepages". (creating new entries doesn't work)
casties
parents:
187
diff
changeset
|
781 |
|
16d55695f1c8
fix updating staff entries through "Update personal homepages". (creating new entries doesn't work)
casties
parents:
187
diff
changeset
|
782 query = "update personal_www set " + ', '.join(fields) + " where key = %s" |
|
236
c90c8333ca8f
fix problem with current_work_p and auto-generated profile.
casties
parents:
234
diff
changeset
|
783 values.append(self.getKey()) |
|
188
16d55695f1c8
fix updating staff entries through "Update personal homepages". (creating new entries doesn't work)
casties
parents:
187
diff
changeset
|
784 results = self.folder.executeZSQL(query, values) |
|
16d55695f1c8
fix updating staff entries through "Update personal homepages". (creating new entries doesn't work)
casties
parents:
187
diff
changeset
|
785 logging.debug(results) |
|
16d55695f1c8
fix updating staff entries through "Update personal homepages". (creating new entries doesn't work)
casties
parents:
187
diff
changeset
|
786 |
| 159 | 787 self.refresh_content() |
| 788 | |
| 37 | 789 |
| 790 security.declareProtected('View management screens','changeAdditionalData') | |
| 791 def changeAdditionalData(self,data): | |
| 792 """change the research entries""" | |
| 793 | |
| 149 | 794 self.invalidate_cache(); |
| 37 | 795 |
| 796 newEntries={} | |
| 797 | |
| 798 | |
| 799 mainfieldL=data['main_fields'].split(",") #fields to be changed | |
| 800 # format DATABASE__FIELDNAME | |
| 801 | |
| 802 mainfield={} | |
| 803 for x in mainfieldL: | |
| 804 tmp=x.split('__') | |
| 805 mainfield[tmp[0]]=tmp[1] | |
| 806 for field in data: | |
| 807 splittedField=field.split("__") | |
| 808 if len(splittedField)<3: | |
| 809 pass #kein datenbank eintrag | |
| 810 | |
| 811 elif splittedField[2]=='new': # store new entries | |
| 812 if not newEntries.has_key(splittedField[0]): | |
| 813 newEntries[splittedField[0]]={} | |
| 814 | |
| 815 newEntries[splittedField[0]][splittedField[1]]=data[field] | |
| 816 | |
| 817 else: | |
| 818 query="UPDATE %s "%splittedField[0] | |
| 819 query+="SET %s = '%s' "%(splittedField[1],sql_quote(data[field])) | |
| 820 query+="WHERE oid = '%s' "%sql_quote(splittedField[2]) | |
| 821 | |
| 822 self.executeZSQL(query) | |
| 823 | |
| 824 | |
| 825 #new entries | |
| 826 for newEntry in newEntries.keys(): | |
| 827 query="INSERT INTO %s "%newEntry | |
| 828 keys=['key_main'] | |
| 829 values=["'"+sql_quote(self.getKey())+"'"] | |
| 830 for key in newEntries[newEntry].keys(): | |
| 831 keys.append(key) | |
|
193
522d32a50c2b
bug with umlauts in editing talks and teachung fixed
dwinter
parents:
191
diff
changeset
|
832 |
|
522d32a50c2b
bug with umlauts in editing talks and teachung fixed
dwinter
parents:
191
diff
changeset
|
833 val = sql_quote(newEntries[newEntry][key]) |
|
522d32a50c2b
bug with umlauts in editing talks and teachung fixed
dwinter
parents:
191
diff
changeset
|
834 if not isinstance(val, unicode): |
|
522d32a50c2b
bug with umlauts in editing talks and teachung fixed
dwinter
parents:
191
diff
changeset
|
835 val = val.decode("utf-8") |
|
522d32a50c2b
bug with umlauts in editing talks and teachung fixed
dwinter
parents:
191
diff
changeset
|
836 |
|
522d32a50c2b
bug with umlauts in editing talks and teachung fixed
dwinter
parents:
191
diff
changeset
|
837 values.append("'"+val+"'") |
| 37 | 838 |
| 839 | |
| 840 keystring=",".join(keys) | |
| 841 | |
| 842 valuestring=",".join(values) | |
| 843 | |
| 844 query+=" (%s) "%keystring | |
| 845 query+="VALUES (%s)"%valuestring | |
| 846 if not (newEntries[newEntry][mainfield[newEntry]].lstrip().rstrip()==""): | |
| 847 self.executeZSQL(query) | |
| 848 | |
| 849 | |
| 38 | 850 |
|
208
6d6076e28430
fix deleteField for additionalLink (still ugly though)
casties
parents:
206
diff
changeset
|
851 security.declareProtected('View management screens','deleteField') |
| 37 | 852 def deleteField(self,REQUEST): |
| 853 """delete entry""" | |
|
208
6d6076e28430
fix deleteField for additionalLink (still ugly though)
casties
parents:
206
diff
changeset
|
854 # TODO: this is ugly |
|
6d6076e28430
fix deleteField for additionalLink (still ugly though)
casties
parents:
206
diff
changeset
|
855 CHANGEABLE=['talks','teaching','pubmanbiblio','additionallink'] |
| 37 | 856 |
| 857 table = REQUEST.form.get('table',None); | |
| 858 oid = REQUEST.form.get('oid',None); | |
| 859 | |
| 185 | 860 |
| 861 if not table in CHANGEABLE: | |
| 862 return | |
| 863 if oid is None: | |
| 864 oid = REQUEST.form.get('key',None); | |
| 865 | |
| 37 | 866 if table is None or oid is None: |
| 867 return | |
| 868 | |
|
208
6d6076e28430
fix deleteField for additionalLink (still ugly though)
casties
parents:
206
diff
changeset
|
869 query="DELETE FROM %s WHERE oid = %%s"%(table) |
|
6d6076e28430
fix deleteField for additionalLink (still ugly though)
casties
parents:
206
diff
changeset
|
870 self.executeZSQL(query, [oid]) |
|
6d6076e28430
fix deleteField for additionalLink (still ugly though)
casties
parents:
206
diff
changeset
|
871 |
| 37 | 872 REQUEST.response.redirect(self.REQUEST['HTTP_REFERER']) |
| 873 | |
| 874 | |
| 40 | 875 def invalidate_cache(self): |
| 37 | 876 #TODO: How to invalidate the varnish cache from the member object |
| 877 pass; | |
| 878 | |
| 79 | 879 |
| 880 # TODO: compat, is this used? | |
| 881 getStaffURL = getUsername | |
| 37 | 882 |
|
191
90d44df497a6
updated breadcrumb handling, works for members now.
casties
parents:
190
diff
changeset
|
883 |
|
90d44df497a6
updated breadcrumb handling, works for members now.
casties
parents:
190
diff
changeset
|
884 def getBreadcrumbs(self): |
|
90d44df497a6
updated breadcrumb handling, works for members now.
casties
parents:
190
diff
changeset
|
885 """return list of breadcrumbs from here to the root""" |
|
90d44df497a6
updated breadcrumb handling, works for members now.
casties
parents:
190
diff
changeset
|
886 crumbs = [] |
|
90d44df497a6
updated breadcrumb handling, works for members now.
casties
parents:
190
diff
changeset
|
887 label = '%s %s'%(self.content.first_name, self.content.last_name) |
|
90d44df497a6
updated breadcrumb handling, works for members now.
casties
parents:
190
diff
changeset
|
888 baseUrl = None |
|
90d44df497a6
updated breadcrumb handling, works for members now.
casties
parents:
190
diff
changeset
|
889 parent = aq_parent(self) |
|
90d44df497a6
updated breadcrumb handling, works for members now.
casties
parents:
190
diff
changeset
|
890 # get parents breadcrumbs |
|
90d44df497a6
updated breadcrumb handling, works for members now.
casties
parents:
190
diff
changeset
|
891 if hasattr(parent, 'getBreadcrumbs'): |
|
90d44df497a6
updated breadcrumb handling, works for members now.
casties
parents:
190
diff
changeset
|
892 crumbs = parent.getBreadcrumbs() |
|
90d44df497a6
updated breadcrumb handling, works for members now.
casties
parents:
190
diff
changeset
|
893 if len(crumbs) > 0: |
|
90d44df497a6
updated breadcrumb handling, works for members now.
casties
parents:
190
diff
changeset
|
894 # get base url from crumbs |
|
90d44df497a6
updated breadcrumb handling, works for members now.
casties
parents:
190
diff
changeset
|
895 baseUrl = crumbs[-1]['url'] + '/members' |
|
90d44df497a6
updated breadcrumb handling, works for members now.
casties
parents:
190
diff
changeset
|
896 |
|
90d44df497a6
updated breadcrumb handling, works for members now.
casties
parents:
190
diff
changeset
|
897 if baseUrl is None: |
|
90d44df497a6
updated breadcrumb handling, works for members now.
casties
parents:
190
diff
changeset
|
898 baseUrl = '/en/staff/members' |
|
90d44df497a6
updated breadcrumb handling, works for members now.
casties
parents:
190
diff
changeset
|
899 |
|
90d44df497a6
updated breadcrumb handling, works for members now.
casties
parents:
190
diff
changeset
|
900 # add this |
|
90d44df497a6
updated breadcrumb handling, works for members now.
casties
parents:
190
diff
changeset
|
901 crumbs.append({'text':label, 'url':self.getUrl(baseUrl=baseUrl), 'object':self}) |
|
90d44df497a6
updated breadcrumb handling, works for members now.
casties
parents:
190
diff
changeset
|
902 |
|
90d44df497a6
updated breadcrumb handling, works for members now.
casties
parents:
190
diff
changeset
|
903 return crumbs |
|
90d44df497a6
updated breadcrumb handling, works for members now.
casties
parents:
190
diff
changeset
|
904 |
|
90d44df497a6
updated breadcrumb handling, works for members now.
casties
parents:
190
diff
changeset
|
905 |
| 56 | 906 def getPublicationsFromPubman(self,limit=None,publicationType=None): |
|
141
45b7b24c8c42
move getPublicationsFromPubman to MPIWGStaffMember.
casties
parents:
134
diff
changeset
|
907 """Return list of publications.""" |
|
110
b554becd8226
Incomplete - # 74: More Link auf den pers?nlichne Homepages
dwinter
parents:
107
diff
changeset
|
908 if self.content.publications_mode=="year": |
| 47 | 909 coneId = self.getConeId(); |
| 910 if coneId: | |
|
141
45b7b24c8c42
move getPublicationsFromPubman to MPIWGStaffMember.
casties
parents:
134
diff
changeset
|
911 pubs = self.folder.mpiwgPubman.getPublications(coneId,limit=limit,publicationType=publicationType) |
|
45b7b24c8c42
move getPublicationsFromPubman to MPIWGStaffMember.
casties
parents:
134
diff
changeset
|
912 #pubs= self.folder.getPublicationsFromPubman(coneId,limit=limit,publicationType=publicationType) |
| 156 | 913 return pubs |
| 38 | 914 |
| 47 | 915 elif self.content.publications_mode=="priority": |
| 916 selPubs= self.getSelectedPublications() | |
| 917 | |
| 918 pubs=[] | |
| 73 | 919 count =0 |
| 47 | 920 for selPub in selPubs: |
| 73 | 921 if limit and count >= limit: |
| 922 break | |
|
110
b554becd8226
Incomplete - # 74: More Link auf den pers?nlichne Homepages
dwinter
parents:
107
diff
changeset
|
923 |
| 53 | 924 logging.debug("searchFor:%s"%selPub.escidocid) |
|
110
b554becd8226
Incomplete - # 74: More Link auf den pers?nlichne Homepages
dwinter
parents:
107
diff
changeset
|
925 entry = self.mpiwgPubman.getEntryFromPubman(selPub.escidocid,extendedData=True); |
|
b554becd8226
Incomplete - # 74: More Link auf den pers?nlichne Homepages
dwinter
parents:
107
diff
changeset
|
926 |
|
b554becd8226
Incomplete - # 74: More Link auf den pers?nlichne Homepages
dwinter
parents:
107
diff
changeset
|
927 #TODO getEntryFromPubmanShould return long texts |
|
b554becd8226
Incomplete - # 74: More Link auf den pers?nlichne Homepages
dwinter
parents:
107
diff
changeset
|
928 typesLongShort={'http://purl.org/eprint/type/Book':'book', |
|
b554becd8226
Incomplete - # 74: More Link auf den pers?nlichne Homepages
dwinter
parents:
107
diff
changeset
|
929 'http://purl.org/eprint/type/BookItem':'book-item', |
|
b554becd8226
Incomplete - # 74: More Link auf den pers?nlichne Homepages
dwinter
parents:
107
diff
changeset
|
930 'http://purl.org/escidoc/metadata/ves/publication-types/article':'article'}; |
|
b554becd8226
Incomplete - # 74: More Link auf den pers?nlichne Homepages
dwinter
parents:
107
diff
changeset
|
931 |
| 156 | 932 if publicationType is not None: |
| 933 #publicaitions typ ist gesetzt | |
| 134 | 934 |
| 156 | 935 if not ((entry[1] == publicationType) or (entry[1] == typesLongShort.get(publicationType,''))) : |
| 936 #stimmt nicht dann weiter | |
|
110
b554becd8226
Incomplete - # 74: More Link auf den pers?nlichne Homepages
dwinter
parents:
107
diff
changeset
|
937 continue; |
| 202 | 938 |
| 939 if len(entry)>4: | |
| 940 pubs.append((selPub.escidocid,entry[0],entry[2],entry[3],entry[4])); | |
| 941 count+=1 | |
| 47 | 942 |
| 46 | 943 return pubs |
| 156 | 944 |
| 945 return [] | |
| 47 | 946 |
| 947 | |
| 100 | 948 def publications_full_html(self, REQUEST): |
| 47 | 949 """show publication""" |
| 100 | 950 pt=PageTemplateFile('zpt/staff/pubman/show_publications.zpt', globals()).__of__(self) |
| 47 | 951 return pt(member=self.content) |
| 952 | |
| 185 | 953 |
| 954 security.declareProtected('View management screens','addPublicationsFromPubman') | |
| 47 | 955 def addPublicationsFromPubman(self,REQUEST): |
| 956 """addPublications from pubman""" | |
| 957 | |
| 958 data=REQUEST.form | |
| 38 | 959 |
| 47 | 960 if data.get("method",None) is None: |
| 159 | 961 pt=PageTemplateFile('zpt/staff/pubman/add_publications.zpt', globals()).__of__(self) |
| 47 | 962 return pt() |
| 963 | |
| 37 | 964 |
| 965 | |
| 47 | 966 if data.get("method") == "search": |
| 73 | 967 |
| 968 | |
| 969 | |
| 201 | 970 entries= self.mpiwgPubman.search(data,contexts=["escidoc:85274","escidoc:38279","escidoc:644427"],resultWithContext=True) |
| 159 | 971 pt=PageTemplateFile('zpt/staff/pubman/add_publications.zpt', globals()).__of__(self) |
| 47 | 972 |
| 973 | |
| 974 return pt(values=entries) | |
| 975 | |
| 976 | |
| 977 | |
| 978 if data.get("method") == "add": | |
| 979 | |
| 980 return self.addEntriesToPublicationList(data) | |
| 981 #pt=PageTemplateFile(os.path.join(package_home(globals()),'zpt/staff/pubman','add_publications.zpt')).__of__(self) | |
| 982 | |
| 983 | |
| 984 | |
| 985 def addEntriesToPublicationList(self,data): | |
| 986 """fuege eintrage aus data zur publications liste, | |
| 987 @param data Map mit escidocID --> value | |
| 988 value muss "add" sein damit hinzugefuegt wird""" | |
| 989 | |
| 990 for key in data.keys(): | |
| 991 | |
| 56 | 992 if key.startswith('escidoc:'): |
| 993 | |
| 47 | 994 |
| 56 | 995 query="INSERT INTO pubmanbiblio (key_main,escidocId) values (%s,%s)" |
| 47 | 996 |
| 56 | 997 if data.get(key)=="add": |
| 998 self.executeZSQL(query,[self.getKey(),key]) | |
| 999 | |
| 47 | 1000 |
| 1001 | |
| 56 | 1002 #selectedPublications = self.getSelectedPublications() |
| 1003 | |
| 1004 #pt = PageTemplateFile(os.path.join(package_home(globals()),'zpt/staff/pubman','change_publications.zpt')).__of__(self) | |
| 47 | 1005 |
| 56 | 1006 #return pt() |
| 1007 if hasattr(self,'REQUEST'): | |
| 1008 return self.REQUEST.response.redirect("changePublications") | |
| 47 | 1009 |
| 1010 | |
| 1011 def changePublications(self,REQUEST): | |
| 1012 """change published publications""" | |
| 1013 | |
| 1014 data=REQUEST.form | |
| 1015 | |
| 147 | 1016 if data.get("method","") == "change": |
| 1017 | |
| 47 | 1018 for key in data.keys(): |
| 1019 splitted=key.split("__") #format escidoc_id__p fuer priority, nur escidocid | |
| 1020 value=data[key] | |
| 1021 if len(splitted)==1: | |
| 1022 self.deleteFromPublicationList(key); | |
| 1023 | |
| 1024 elif(splitted[1]) == "p": | |
| 1025 self.setPublicationPriority(splitted[0],value); | |
| 1026 | |
| 1027 | |
| 159 | 1028 pt = PageTemplateFile('zpt/staff/pubman/change_publications', globals()).__of__(self) |
| 47 | 1029 return pt() |
| 1030 | |
| 1031 | |
| 1032 def deleteFromPublicationList(self,escidocid): | |
| 1033 """Loessche publication with escidoc id from publication list""" | |
| 1034 | |
| 147 | 1035 query ="DELETE FROM pubmanbiblio WHERE escidocid=%s and lower(key_main)=%s" |
| 47 | 1036 |
| 147 | 1037 self.executeZSQL(query,[escidocid,self.getKey().lower()]); |
| 47 | 1038 |
| 1039 | |
| 1040 def setPublicationPriority(self,escidocid,value): | |
| 56 | 1041 try: |
| 147 | 1042 query="update pubmanbiblio set priority=%s where escidocid=%s and lower(key_main)=%s" |
| 56 | 1043 |
| 203 | 1044 try: |
| 1045 x=int(value) | |
| 1046 except: | |
| 1047 logging.error("priority not a number") | |
| 1048 return | |
| 1049 | |
| 147 | 1050 self.executeZSQL(query,[value,escidocid,self.getKey().lower()]); |
| 56 | 1051 |
| 1052 except: | |
| 1053 logging.error("couldn't change:") | |
| 1054 logging.error(escidocid) | |
| 1055 logging.error(value) | |
| 1056 | |
| 80 | 1057 |
| 47 | 1058 def getSelectedPublications(self): |
| 1059 """hole publications aus der datenbank""" | |
| 100 | 1060 query="select * from pubmanbiblio where lower(key_main) = lower(%s) order by priority ASC" |
| 47 | 1061 return self.executeZSQL(query,[self.getKey()]) |
| 68 | 1062 |
| 1063 | |
| 233 | 1064 def getProfileHtml(self, REQUEST): |
| 86 | 1065 """get the profile""" |
| 233 | 1066 REQUEST.RESPONSE.setHeader('Last-Modified',email.Utils.formatdate().split("-")[0]+'GMT') |
| 86 | 1067 html="""<html><body>%s</body></html>""" |
| 1068 if self.content.profile and self.content.profile != "": | |
| 1069 return html%self.content.profile | |
| 1070 else: | |
| 1071 return html%"" | |
| 1072 | |
| 1073 | |
| 68 | 1074 def generateProfileForPerson(self,REQUEST=None): |
| 1075 """erzeugt ein automatisches Profil aus den alten Eintraegen CV, Current work, und research interests""" | |
| 1076 | |
| 1077 ret="" | |
| 1078 #founds=self.ZSQLInlineSearch(_table='research_interest',key_main=person.getKeyUTF8()) | |
| 80 | 1079 founds=self.executeZSQL('select * from research_interest where lower(key_main) = %s', [self.getKey().lower()]) |
| 68 | 1080 if founds: |
|
236
c90c8333ca8f
fix problem with current_work_p and auto-generated profile.
casties
parents:
234
diff
changeset
|
1081 ret+='<h3>Research interests</h3>\n<p>' |
| 68 | 1082 for found in self.sortPriority(founds): |
|
236
c90c8333ca8f
fix problem with current_work_p and auto-generated profile.
casties
parents:
234
diff
changeset
|
1083 ret+=found.interest+'<br/>' |
|
c90c8333ca8f
fix problem with current_work_p and auto-generated profile.
casties
parents:
234
diff
changeset
|
1084 if founds: |
|
c90c8333ca8f
fix problem with current_work_p and auto-generated profile.
casties
parents:
234
diff
changeset
|
1085 ret+='</p>\n' |
| 237 | 1086 if self.content.current_work: |
|
236
c90c8333ca8f
fix problem with current_work_p and auto-generated profile.
casties
parents:
234
diff
changeset
|
1087 ret+="<h3>Current work</h3>" |
|
c90c8333ca8f
fix problem with current_work_p and auto-generated profile.
casties
parents:
234
diff
changeset
|
1088 ret+='<p>'+self.content.current_work+'</p>\n' |
|
c90c8333ca8f
fix problem with current_work_p and auto-generated profile.
casties
parents:
234
diff
changeset
|
1089 if (self.content.cv_p == 'yes') and self.content.cv: |
|
c90c8333ca8f
fix problem with current_work_p and auto-generated profile.
casties
parents:
234
diff
changeset
|
1090 ret+="<h3>Curriculum Vitae</h3>" |
|
c90c8333ca8f
fix problem with current_work_p and auto-generated profile.
casties
parents:
234
diff
changeset
|
1091 ret+='<p>'+self.formatAscii(self.content.cv)+'</p>' |
| 68 | 1092 |
| 1093 return ret | |
| 47 | 1094 |
|
189
cc5198541af8
erzeugen neuer eintr?ge auf der homepage mittels updatexml
dwinter
parents:
188
diff
changeset
|
1095 |
|
cc5198541af8
erzeugen neuer eintr?ge auf der homepage mittels updatexml
dwinter
parents:
188
diff
changeset
|
1096 |
| 186 | 1097 # initialize security |
| 1098 InitializeClass(MPIWGStaffFolder) | |
| 3 | 1099 InitializeClass(MPIWGStaffMember) |