Mercurial > hg > MPIWGWeb
annotate MPIWGStaff.py @ 281:a1edd65c8ab7
updateconeIds hinzuegefuegt, getconeid traegt fehlende ids in die Datenbank ein
author | Dirk Wintergruen <dwinter@mpiwg-berlin.mpg.de> |
---|---|
date | Thu, 21 May 2015 09:27:59 +0200 |
parents | 3f9ba7a8cb27 |
children | 37b89e8a8828 |
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 |
281
a1edd65c8ab7
updateconeIds hinzuegefuegt, getconeid traegt fehlende ids in die Datenbank ein
Dirk Wintergruen <dwinter@mpiwg-berlin.mpg.de>
parents:
275
diff
changeset
|
308 |
a1edd65c8ab7
updateconeIds hinzuegefuegt, getconeid traegt fehlende ids in die Datenbank ein
Dirk Wintergruen <dwinter@mpiwg-berlin.mpg.de>
parents:
275
diff
changeset
|
309 def updateConeIds(self,REQUEST): |
a1edd65c8ab7
updateconeIds hinzuegefuegt, getconeid traegt fehlende ids in die Datenbank ein
Dirk Wintergruen <dwinter@mpiwg-berlin.mpg.de>
parents:
275
diff
changeset
|
310 """holt alle coneids von allen member, die methode getconeid traegt diese dann auch all in die key tabelle ein, falls sie ich fehlen""" |
226 | 311 |
281
a1edd65c8ab7
updateconeIds hinzuegefuegt, getconeid traegt fehlende ids in die Datenbank ein
Dirk Wintergruen <dwinter@mpiwg-berlin.mpg.de>
parents:
275
diff
changeset
|
312 mems= self.getMemberList() |
a1edd65c8ab7
updateconeIds hinzuegefuegt, getconeid traegt fehlende ids in die Datenbank ein
Dirk Wintergruen <dwinter@mpiwg-berlin.mpg.de>
parents:
275
diff
changeset
|
313 cids=[] |
a1edd65c8ab7
updateconeIds hinzuegefuegt, getconeid traegt fehlende ids in die Datenbank ein
Dirk Wintergruen <dwinter@mpiwg-berlin.mpg.de>
parents:
275
diff
changeset
|
314 for mem in mems: |
a1edd65c8ab7
updateconeIds hinzuegefuegt, getconeid traegt fehlende ids in die Datenbank ein
Dirk Wintergruen <dwinter@mpiwg-berlin.mpg.de>
parents:
275
diff
changeset
|
315 cids.append(mem.getConeId()) |
a1edd65c8ab7
updateconeIds hinzuegefuegt, getconeid traegt fehlende ids in die Datenbank ein
Dirk Wintergruen <dwinter@mpiwg-berlin.mpg.de>
parents:
275
diff
changeset
|
316 |
a1edd65c8ab7
updateconeIds hinzuegefuegt, getconeid traegt fehlende ids in die Datenbank ein
Dirk Wintergruen <dwinter@mpiwg-berlin.mpg.de>
parents:
275
diff
changeset
|
317 return cids |
a1edd65c8ab7
updateconeIds hinzuegefuegt, getconeid traegt fehlende ids in die Datenbank ein
Dirk Wintergruen <dwinter@mpiwg-berlin.mpg.de>
parents:
275
diff
changeset
|
318 |
a1edd65c8ab7
updateconeIds hinzuegefuegt, getconeid traegt fehlende ids in die Datenbank ein
Dirk Wintergruen <dwinter@mpiwg-berlin.mpg.de>
parents:
275
diff
changeset
|
319 |
246 | 320 def getConeIDsFromDB(self,REQUEST): |
321 """holt die cone ids aus personalwww und gibt sie als RDF fuer den cone import zurueck""" | |
322 | |
323 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;" | |
324 coneIds = self.executeZSQL(qs) | |
325 | |
326 ret="""<?xml version="1.0" encoding="UTF-8"?> | |
253 | 327 <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 | 328 """ |
329 | |
330 templ=""" | |
331 <rdf:Description rdf:about="%s"> | |
332 <dc:title>%s, %s</dc:title> | |
253 | 333 |
334 <escidoc:position> | |
335 <rdf:Description> | |
336 <dc:identifier>escidoc:14002</dc:identifier> | |
337 <eprints:affiliatedInstitution>Max Planck Institute for the History of Science, Max Planck Society</eprints:affiliatedInstitution> | |
338 </rdf:Description> | |
339 </escidoc:position> | |
340 | |
341 | |
342 | |
246 | 343 </rdf:Description> |
344 """ | |
345 print coneIds.names() | |
346 for coneId in coneIds: | |
347 | |
348 ret+=templ%(coneId["coneid"],coneId["last_name"],coneId["first_name"]) | |
349 | |
350 ret+=""" | |
351 </rdf:RDF> | |
352 """ | |
353 if REQUEST is not None: | |
354 REQUEST.response.setHeader("Content-type", "text/XML") | |
355 return ret | |
356 | |
2 | 357 def manage_addMPIWGStaffFolderForm(self): |
358 """form for adding the project""" | |
359 pt=PageTemplateFile('zpt/addMPIWGStaffFolderForm', globals()).__of__(self) | |
360 return pt() | |
361 | |
362 def manage_addMPIWGStaffFolder(self,id,title,RESPONSE=None): | |
363 """add it""" | |
364 newObj=MPIWGStaffFolder(id,title) | |
365 | |
366 self._setObject(id,newObj) | |
367 | |
368 if RESPONSE is not None: | |
369 RESPONSE.redirect('manage_main') | |
370 | |
3 | 371 |
37 | 372 class MPIWGStaffMember(Folder): |
3 | 373 """MPIWG staff member object from database""" |
374 | |
375 security = ClassSecurityInfo() | |
65 | 376 |
377 # templates | |
378 mainEditFile=PageTemplateFile('zpt/staff/edit_main', globals()) | |
100 | 379 talks_full_html = PageTemplateFile('zpt/staff/talks_full_html', globals()) |
380 teaching_full_html = PageTemplateFile('zpt/staff/teaching_full_html', globals()) | |
381 | |
3 | 382 |
383 def __init__(self, folder, dbresult): | |
86 | 384 """constructor: takes parent MPIWGStaffFolder and content (DB row)""" |
3 | 385 self.folder = folder |
86 | 386 self.content = dbresult |
3 | 387 |
186 | 388 |
389 def index_html(self, REQUEST, RESPONSE): | |
390 """show homepage""" | |
391 # get template /template/member_index_html (with acquisition) | |
392 pt = getattr(self.template, 'member_index_html', None) | |
393 if pt is not None: | |
394 return pt(member=self) | |
395 | |
396 return "No template /template/member_index_html" | |
397 | |
398 | |
3 | 399 def isValid(self): |
400 """returns if this member exists""" | |
401 return len(self.content) > 0 | |
402 | |
79 | 403 def isActive(self): |
404 """Return if this member is visible (published).""" | |
405 return (self.content.publish_the_data == 'yes') | |
406 | |
3 | 407 def getKey(self): |
408 """returns the db key""" | |
409 return self.content.key | |
410 | |
411 def getUsername(self): | |
412 """returns the username""" | |
413 id = re.sub('@mpiwg-berlin\.mpg\.de', '', self.content.e_mail) | |
217 | 414 return str(id) |
3 | 415 |
86 | 416 getId = getUsername |
46 | 417 def getConeId(self): |
418 """return cone ID""" | |
281
a1edd65c8ab7
updateconeIds hinzuegefuegt, getconeid traegt fehlende ids in die Datenbank ein
Dirk Wintergruen <dwinter@mpiwg-berlin.mpg.de>
parents:
275
diff
changeset
|
419 results= self.folder.executeZSQL("SELECT coneid FROM keys WHERE key_main = %s",[self.content.key]) |
a1edd65c8ab7
updateconeIds hinzuegefuegt, getconeid traegt fehlende ids in die Datenbank ein
Dirk Wintergruen <dwinter@mpiwg-berlin.mpg.de>
parents:
275
diff
changeset
|
420 for res in results: |
79 | 421 return res.coneid |
281
a1edd65c8ab7
updateconeIds hinzuegefuegt, getconeid traegt fehlende ids in die Datenbank ein
Dirk Wintergruen <dwinter@mpiwg-berlin.mpg.de>
parents:
275
diff
changeset
|
422 |
a1edd65c8ab7
updateconeIds hinzuegefuegt, getconeid traegt fehlende ids in die Datenbank ein
Dirk Wintergruen <dwinter@mpiwg-berlin.mpg.de>
parents:
275
diff
changeset
|
423 newConeId="http://pubman.mpiwg-berlin.mpg.de/cone/persons/resource/%s"%self.content.key |
a1edd65c8ab7
updateconeIds hinzuegefuegt, getconeid traegt fehlende ids in die Datenbank ein
Dirk Wintergruen <dwinter@mpiwg-berlin.mpg.de>
parents:
275
diff
changeset
|
424 |
a1edd65c8ab7
updateconeIds hinzuegefuegt, getconeid traegt fehlende ids in die Datenbank ein
Dirk Wintergruen <dwinter@mpiwg-berlin.mpg.de>
parents:
275
diff
changeset
|
425 results = self.folder.executeZSQL("INSERT INTO keys (coneid,key_main) values(%s,%s)",[newConeId,self.content.key]) |
a1edd65c8ab7
updateconeIds hinzuegefuegt, getconeid traegt fehlende ids in die Datenbank ein
Dirk Wintergruen <dwinter@mpiwg-berlin.mpg.de>
parents:
275
diff
changeset
|
426 |
a1edd65c8ab7
updateconeIds hinzuegefuegt, getconeid traegt fehlende ids in die Datenbank ein
Dirk Wintergruen <dwinter@mpiwg-berlin.mpg.de>
parents:
275
diff
changeset
|
427 return newConeId |
a1edd65c8ab7
updateconeIds hinzuegefuegt, getconeid traegt fehlende ids in die Datenbank ein
Dirk Wintergruen <dwinter@mpiwg-berlin.mpg.de>
parents:
275
diff
changeset
|
428 |
a1edd65c8ab7
updateconeIds hinzuegefuegt, getconeid traegt fehlende ids in die Datenbank ein
Dirk Wintergruen <dwinter@mpiwg-berlin.mpg.de>
parents:
275
diff
changeset
|
429 |
159 | 430 def getPublishedImageUrl(self, width=None, height=None, showAlways=False): |
3 | 431 """returns the URL to the image if it is published""" |
159 | 432 if self.content.image_p == 'yes' or showAlways: |
3 | 433 url = 'http://digilib.mpiwg-berlin.mpg.de/digitallibrary/Scaler?fn=permanent/mpiwg/staff/%s'%self.getUsername() |
159 | 434 if width is not None: |
435 url += '&dw=%s'%width | |
436 | |
437 if height is not None: | |
438 url += '&dh=%s'%height | |
439 | |
3 | 440 return url |
441 | |
442 return None | |
443 | |
444 def getContent(self): | |
445 """returns the db content of this object""" | |
446 return self.content | |
447 | |
37 | 448 |
3 | 449 # TODO: ugly! |
450 security.declarePublic('sortBibliography') | |
79 | 451 def sortBibliography(self, bib, sortingMode=None, max=None): |
3 | 452 """sort bibliography""" |
453 if not sortingMode: | |
454 sortingMode= "priority" | |
455 | |
456 l = [x for x in bib] | |
457 | |
458 if sortingMode == "year": | |
459 l.sort(key=lambda x: getInt(x.year)) | |
460 else: | |
461 l.sort(key=lambda x: getInt(x.priority)) | |
462 | |
463 if max: | |
79 | 464 return l[0:max] |
3 | 465 else: |
466 return l | |
467 | |
37 | 468 |
86 | 469 getUrl = MPIWGHelper.getUrl |
37 | 470 |
233 | 471 |
472 def getProfile(self, filter=None, length=0): | |
473 """Return the profile""" | |
474 logging.debug("getProfile: self.content=%s"%(repr(self.content))) | |
475 text = self.content.profile | |
476 if filter == 'plaintext': | |
477 # filter out any tags, keep only text | |
478 text = getPlaintext(text, length=length, wordwrap=True, ignoretags=['style']) | |
479 | |
480 return text | |
481 | |
482 | |
100 | 483 def getTalks(self, published=True, sortBy='priority'): |
484 """Return the list of talks""" | |
485 query = "SELECT oid,* FROM talks WHERE key_main = %s" | |
486 if published: | |
487 query += " and published = 'yes'" | |
488 | |
489 if sortBy == 'priority': | |
490 query += " order by priority" | |
491 | |
217 | 492 return self.folder.executeZSQL(query, [self.getKey()]) |
493 | |
494 | |
495 def getTalksCal(self): | |
496 """Return the talks calendar object (MPIWGIcsManager)""" | |
497 try: | |
498 cal = self.folder.get('calendars').get("%s_talks"%self.getUsername()) | |
499 return cal | |
500 except: | |
501 return None | |
502 | |
37 | 503 |
100 | 504 def getTeaching(self, published=True, sortBy='priority'): |
505 """Return the list of teaching activities""" | |
506 query = "SELECT oid,* FROM teaching WHERE key_main = %s" | |
507 if published: | |
508 query += " AND published = 'yes'" | |
509 | |
510 if sortBy == 'priority': | |
511 query += " ORDER BY priority" | |
512 | |
217 | 513 return self.folder.executeZSQL(query,[self.getKey()]) |
37 | 514 |
515 | |
516 def getLastUpdateCV(self): | |
517 """getDate of Last Update""" | |
518 try: | |
217 | 519 ob=self.folder.get("downloadableFiles").get("%s_cv.pdf"%self.getUsername()) |
520 return datetime.datetime.fromtimestamp(ob._p_mtime) | |
37 | 521 except: |
162 | 522 return "No file yet!" |
86 | 523 |
37 | 524 |
525 def getLastUpdatePublications(self): | |
526 """getDate of Last Update""" | |
527 try: | |
217 | 528 ob=self.folder.get("downloadableFiles").get("%s_publications.pdf"%self.getUsername()) |
529 return datetime.datetime.fromtimestamp(ob._p_mtime) | |
37 | 530 except: |
162 | 531 return "No file yet!" |
37 | 532 |
533 | |
534 def downloadCV(self,REQUEST): | |
194 | 535 """download the cv""" |
217 | 536 ob=self.folder.get("downloadableFiles").get("%s_cv.pdf" % self.getUsername()) |
37 | 537 REQUEST.RESPONSE.redirect(ob.absolute_url()) |
538 | |
217 | 539 |
37 | 540 def downloadPublications(self,REQUEST): |
194 | 541 """donwload the publication list""" |
217 | 542 ob=self.folder.get("downloadableFiles").get("%s_publications.pdf"%self.getUsername()) |
37 | 543 REQUEST.RESPONSE.redirect(ob.absolute_url()) |
544 | |
159 | 545 |
546 def getAdditionalLinks(self): | |
208
6d6076e28430
fix deleteField for additionalLink (still ugly though)
casties
parents:
206
diff
changeset
|
547 return self.folder.executeZSQL("SELECT oid,* FROM additionallink WHERE key_main = %s ORDER BY priority",[self.content.key]) |
159 | 548 |
37 | 549 |
550 def getPathStyle(self, path, selected, style=""): | |
551 """returns a string with the given style + 'sel' if path == selected.""" | |
552 if path == selected: | |
553 return style + 'sel' | |
554 else: | |
555 return style | |
556 | |
557 | |
558 security.declareProtected('View management screens','edit') | |
559 def edit(self,REQUEST=None): | |
560 """Edit the basic information""" | |
561 if REQUEST: | |
562 argv=REQUEST.form | |
563 | |
564 if argv.has_key('last_name'): #got data to change | |
149 | 565 self.invalidate_cache() |
37 | 566 self.changeData(argv); |
567 | |
159 | 568 pt=PageTemplateFile('zpt/staff/edit_basic', globals()).__of__(self) |
37 | 569 return pt() |
570 | |
571 | |
159 | 572 security.declareProtected('View management screens','editShortEntry') |
37 | 573 def editShortEntry(self,REQUEST=None): |
574 """Edit the basic information""" | |
575 if REQUEST: | |
576 argv=REQUEST.form | |
577 | |
578 if argv.has_key('current_work'): #got data to change | |
149 | 579 self.invalidate_cache() |
37 | 580 self.changeData(argv); |
581 | |
159 | 582 pt=PageTemplateFile('zpt/staff/edit_shortEntry', globals()).__of__(self) |
37 | 583 return pt() |
584 | |
585 | |
159 | 586 security.declareProtected('View management screens', 'editProfile') |
37 | 587 def editProfile(self, REQUEST=None): |
159 | 588 """edit Profile, new entry replaces CD, current work and research interests""" |
589 if REQUEST: | |
590 kupu = REQUEST.form.get('kupu', None); | |
591 preview = REQUEST.form.get('preview', None); | |
3 | 592 |
159 | 593 if kupu: |
594 start = kupu.find("<body>") | |
595 end = kupu.find("</body>") | |
187 | 596 newcontent = kupu[start+6:end] |
597 query = "UPDATE personal_www SET profile=%s WHERE key=%s" | |
598 self.executeZSQL(query, [newcontent, self.content.key]) | |
37 | 599 |
159 | 600 if preview: |
601 pass | |
602 # TODO: not supported yet | |
603 # if RESPONSE: | |
604 # self.redirect(RESPONSE,"editProfile") | |
605 # return self.preview(newcontent) | |
37 | 606 |
159 | 607 pt = PageTemplateFile('zpt/staff/edit_profile.zpt', globals()).__of__(self) |
608 return pt() | |
37 | 609 |
610 | |
611 security.declareProtected('View management screens','editTalks') | |
612 def editTalks(self,REQUEST): | |
613 """edit talks""" | |
217 | 614 pt=PageTemplateFile('zpt/staff/edit_talks.zpt', globals()).__of__(self) |
615 | |
37 | 616 if REQUEST: |
617 argv=REQUEST.form | |
618 | |
217 | 619 url = argv.get('ics_url', None) |
620 if url: | |
243
980794794bb5
added preferences for number of publications, talks, and teachings on profile page.
casties
parents:
242
diff
changeset
|
621 # |
242
0b7a95c02f68
added preference for number of talks from calendar on profile page.
casties
parents:
238
diff
changeset
|
622 # ICS URL driven talks |
243
980794794bb5
added preferences for number of publications, talks, and teachings on profile page.
casties
parents:
242
diff
changeset
|
623 # |
217 | 624 cal_id = "%s_talks"%self.getUsername() |
625 # use ICS calendar | |
626 cal = self.getTalksCal() | |
238
5f5d7f07c1bd
added "show only upcoming" option for talks from calendar.
casties
parents:
237
diff
changeset
|
627 if cal is None: |
5f5d7f07c1bd
added "show only upcoming" option for talks from calendar.
casties
parents:
237
diff
changeset
|
628 # create new calendar |
251 | 629 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
|
630 self.folder.get('calendars')[cal_id] = cal |
5f5d7f07c1bd
added "show only upcoming" option for talks from calendar.
casties
parents:
237
diff
changeset
|
631 |
5f5d7f07c1bd
added "show only upcoming" option for talks from calendar.
casties
parents:
237
diff
changeset
|
632 else: |
217 | 633 # calendar exists |
238
5f5d7f07c1bd
added "show only upcoming" option for talks from calendar.
casties
parents:
237
diff
changeset
|
634 if cal.url != url: |
5f5d7f07c1bd
added "show only upcoming" option for talks from calendar.
casties
parents:
237
diff
changeset
|
635 # remove and re-create |
217 | 636 del self.folder.get('calendars')[cal_id] |
251 | 637 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
|
638 self.folder.get('calendars')[cal_id] = cal |
217 | 639 |
238
5f5d7f07c1bd
added "show only upcoming" option for talks from calendar.
casties
parents:
237
diff
changeset
|
640 # show only upcoming |
5f5d7f07c1bd
added "show only upcoming" option for talks from calendar.
casties
parents:
237
diff
changeset
|
641 upcoming = argv.get('only_upcoming', None) |
5f5d7f07c1bd
added "show only upcoming" option for talks from calendar.
casties
parents:
237
diff
changeset
|
642 cal.setFlag('only_upcoming', (upcoming == 'yes')) |
242
0b7a95c02f68
added preference for number of talks from calendar on profile page.
casties
parents:
238
diff
changeset
|
643 # number of events |
243
980794794bb5
added preferences for number of publications, talks, and teachings on profile page.
casties
parents:
242
diff
changeset
|
644 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
|
645 self.changeData({'talks_num': talks_num}) |
217 | 646 |
275
3f9ba7a8cb27
fixed fix for: 175: removing the ICS URL in editTalks doesn't work
casties
parents:
274
diff
changeset
|
647 elif argv.has_key('only_upcoming'): |
274
87e7e210968d
fixed: 175: removing the ICS URL in editTalks doesn't work
casties
parents:
263
diff
changeset
|
648 # delete calendar if it exists |
87e7e210968d
fixed: 175: removing the ICS URL in editTalks doesn't work
casties
parents:
263
diff
changeset
|
649 if self.getTalksCal(): |
87e7e210968d
fixed: 175: removing the ICS URL in editTalks doesn't work
casties
parents:
263
diff
changeset
|
650 cal_id = "%s_talks"%self.getUsername() |
87e7e210968d
fixed: 175: removing the ICS URL in editTalks doesn't work
casties
parents:
263
diff
changeset
|
651 del self.folder.get('calendars')[cal_id] |
87e7e210968d
fixed: 175: removing the ICS URL in editTalks doesn't work
casties
parents:
263
diff
changeset
|
652 |
275
3f9ba7a8cb27
fixed fix for: 175: removing the ICS URL in editTalks doesn't work
casties
parents:
274
diff
changeset
|
653 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
|
654 # |
3f9ba7a8cb27
fixed fix for: 175: removing the ICS URL in editTalks doesn't work
casties
parents:
274
diff
changeset
|
655 # manually edited talks |
3f9ba7a8cb27
fixed fix for: 175: removing the ICS URL in editTalks doesn't work
casties
parents:
274
diff
changeset
|
656 # |
3f9ba7a8cb27
fixed fix for: 175: removing the ICS URL in editTalks doesn't work
casties
parents:
274
diff
changeset
|
657 self.invalidate_cache() |
3f9ba7a8cb27
fixed fix for: 175: removing the ICS URL in editTalks doesn't work
casties
parents:
274
diff
changeset
|
658 self.changeAdditionalData(argv); |
3f9ba7a8cb27
fixed fix for: 175: removing the ICS URL in editTalks doesn't work
casties
parents:
274
diff
changeset
|
659 # number of events |
3f9ba7a8cb27
fixed fix for: 175: removing the ICS URL in editTalks doesn't work
casties
parents:
274
diff
changeset
|
660 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
|
661 self.changeData({'talks_num': talks_num}) |
37 | 662 |
663 return pt() | |
664 | |
665 | |
666 security.declareProtected('View management screens','editTeaching') | |
667 def editTeaching(self,REQUEST): | |
668 """edit teaching""" | |
669 if REQUEST: | |
670 argv=REQUEST.form | |
671 | |
672 if argv.has_key('main_fields'): #got data to change | |
149 | 673 self.invalidate_cache() |
37 | 674 self.changeAdditionalData(argv); |
243
980794794bb5
added preferences for number of publications, talks, and teachings on profile page.
casties
parents:
242
diff
changeset
|
675 # number of items |
980794794bb5
added preferences for number of publications, talks, and teachings on profile page.
casties
parents:
242
diff
changeset
|
676 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
|
677 self.changeData({'teachings_num': teachings_num}) |
37 | 678 |
159 | 679 pt=PageTemplateFile('zpt/staff/edit_teaching.zpt', globals()).__of__(self) |
37 | 680 return pt() |
681 | |
682 | |
159 | 683 security.declareProtected('View management screens','editAdditionalLinks') |
37 | 684 def editAdditionalLinks(self,REQUEST): |
159 | 685 """editiere die additional link von der Webseite""" |
37 | 686 if REQUEST: |
687 argv=REQUEST.form | |
688 | |
689 if argv.has_key('main_fields'): #got data to change | |
149 | 690 self.invalidate_cache() |
37 | 691 self.changeAdditionalData(argv); |
692 | |
159 | 693 pt=PageTemplateFile('zpt/staff/edit_additionalLinks.zpt', globals()).__of__(self) |
37 | 694 return pt() |
695 | |
696 | |
86 | 697 security.declareProtected('View management screens','editDownloads') |
37 | 698 def editDownloads(self,REQUEST): |
699 """editiere die Downloads von der Webseite""" | |
700 | |
159 | 701 pt=PageTemplateFile('zpt/staff/edit_downloads.zpt', globals()).__of__(self) |
37 | 702 return pt() |
703 | |
47 | 704 def editPublications(self,REQUEST): |
705 """editiere die Publications von der Webseite""" | |
706 data=REQUEST.form | |
243
980794794bb5
added preferences for number of publications, talks, and teachings on profile page.
casties
parents:
242
diff
changeset
|
707 newData = {} |
47 | 708 |
243
980794794bb5
added preferences for number of publications, talks, and teachings on profile page.
casties
parents:
242
diff
changeset
|
709 if 'selectionMode' in data: |
980794794bb5
added preferences for number of publications, talks, and teachings on profile page.
casties
parents:
242
diff
changeset
|
710 newData['publications_mode'] = data['selectionMode'] |
47 | 711 |
243
980794794bb5
added preferences for number of publications, talks, and teachings on profile page.
casties
parents:
242
diff
changeset
|
712 if 'publications_num' in data: |
980794794bb5
added preferences for number of publications, talks, and teachings on profile page.
casties
parents:
242
diff
changeset
|
713 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
|
714 |
980794794bb5
added preferences for number of publications, talks, and teachings on profile page.
casties
parents:
242
diff
changeset
|
715 if len(newData) > 0: |
980794794bb5
added preferences for number of publications, talks, and teachings on profile page.
casties
parents:
242
diff
changeset
|
716 self.changeData(newData) |
47 | 717 |
159 | 718 pt=PageTemplateFile('zpt/staff/edit_publications.zpt', globals()).__of__(self) |
47 | 719 return pt() |
720 | |
721 | |
159 | 722 security.declareProtected('View management screens','editImage') |
723 def editImage(self,REQUEST=None): | |
724 """Edit the image information""" | |
725 if REQUEST: | |
726 argv=REQUEST.form | |
727 | |
728 if argv.has_key('image_p'): #got data to change | |
729 self.invalidate_cache() | |
730 self.changeData(argv); | |
731 | |
732 pt=PageTemplateFile('zpt/staff/edit_image', globals()).__of__(self) | |
733 return pt() | |
734 | |
735 | |
47 | 736 def refresh_content(self,): |
737 self.content = self.folder.executeZSQL("select * from personal_www where key = %s", [self.getKey()])[0] | |
738 | |
739 | |
37 | 740 def changeDownloads(self,REQUEST): |
741 """"change the downloadable files""" | |
149 | 742 self.invalidate_cache(); |
37 | 743 |
744 data=REQUEST.form | |
745 | |
217 | 746 ob = self.folder.get("downloadableFiles") |
37 | 747 |
748 if data.get('cv_publish',None): | |
749 | |
750 self.changeData({'cv_p':data['cv_publish']}) | |
751 | |
752 if data.get('publications_publish',None): | |
753 self.changeData({'publications_p':data['publications_publish']}) | |
754 | |
755 | |
756 if data.get('cv_pdf',None): | |
757 cvName ="%s_cv.pdf"%self.getUsername() | |
758 cvName=cvName.encode('utf-8') | |
195 | 759 |
37 | 760 if not hasattr(ob,cvName): |
194 | 761 cvFile = ExtFile.ExtFile(cvName,cvName) |
37 | 762 ob._setObject(cvName,cvFile) |
763 | |
764 cvFile = getattr(ob,cvName) | |
765 | |
766 cvFile.manage_upload(file=data['cv_pdf']) | |
767 | |
768 if data.get('publications_pdf',None): | |
769 pdfName="%s_publications.pdf"%self.getUsername() | |
770 pdfName=pdfName.encode('utf-8') | |
771 | |
772 if not hasattr(ob,pdfName): | |
194 | 773 cvFile = ExtFile.ExtFile(pdfName,pdfName) |
37 | 774 ob._setObject(pdfName,cvFile) |
775 | |
776 cvFile = getattr(ob,pdfName) | |
777 | |
778 cvFile.manage_upload(file=data['publications_pdf']) | |
779 | |
780 | |
194 | 781 REQUEST.response.redirect("editDownloads"); |
37 | 782 |
783 | |
188
16d55695f1c8
fix updating staff entries through "Update personal homepages". (creating new entries doesn't work)
casties
parents:
187
diff
changeset
|
784 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
|
785 def changeData(self, changeSet): |
37 | 786 """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
|
787 fields = [] |
16d55695f1c8
fix updating staff entries through "Update personal homepages". (creating new entries doesn't work)
casties
parents:
187
diff
changeset
|
788 values = [] |
37 | 789 for field in changeSet.keys(): |
159 | 790 if hasattr(self.content, field): |
37 | 791 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
|
792 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
|
793 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
|
794 |
16d55695f1c8
fix updating staff entries through "Update personal homepages". (creating new entries doesn't work)
casties
parents:
187
diff
changeset
|
795 if len(fields) == 0: |
16d55695f1c8
fix updating staff entries through "Update personal homepages". (creating new entries doesn't work)
casties
parents:
187
diff
changeset
|
796 return |
16d55695f1c8
fix updating staff entries through "Update personal homepages". (creating new entries doesn't work)
casties
parents:
187
diff
changeset
|
797 |
16d55695f1c8
fix updating staff entries through "Update personal homepages". (creating new entries doesn't work)
casties
parents:
187
diff
changeset
|
798 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
|
799 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
|
800 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
|
801 logging.debug(results) |
16d55695f1c8
fix updating staff entries through "Update personal homepages". (creating new entries doesn't work)
casties
parents:
187
diff
changeset
|
802 |
159 | 803 self.refresh_content() |
804 | |
37 | 805 |
806 security.declareProtected('View management screens','changeAdditionalData') | |
807 def changeAdditionalData(self,data): | |
808 """change the research entries""" | |
809 | |
149 | 810 self.invalidate_cache(); |
37 | 811 |
812 newEntries={} | |
813 | |
814 | |
815 mainfieldL=data['main_fields'].split(",") #fields to be changed | |
816 # format DATABASE__FIELDNAME | |
817 | |
818 mainfield={} | |
819 for x in mainfieldL: | |
820 tmp=x.split('__') | |
821 mainfield[tmp[0]]=tmp[1] | |
822 for field in data: | |
823 splittedField=field.split("__") | |
824 if len(splittedField)<3: | |
825 pass #kein datenbank eintrag | |
826 | |
827 elif splittedField[2]=='new': # store new entries | |
828 if not newEntries.has_key(splittedField[0]): | |
829 newEntries[splittedField[0]]={} | |
830 | |
831 newEntries[splittedField[0]][splittedField[1]]=data[field] | |
832 | |
833 else: | |
834 query="UPDATE %s "%splittedField[0] | |
835 query+="SET %s = '%s' "%(splittedField[1],sql_quote(data[field])) | |
836 query+="WHERE oid = '%s' "%sql_quote(splittedField[2]) | |
837 | |
838 self.executeZSQL(query) | |
839 | |
840 | |
841 #new entries | |
842 for newEntry in newEntries.keys(): | |
843 query="INSERT INTO %s "%newEntry | |
844 keys=['key_main'] | |
845 values=["'"+sql_quote(self.getKey())+"'"] | |
846 for key in newEntries[newEntry].keys(): | |
847 keys.append(key) | |
193
522d32a50c2b
bug with umlauts in editing talks and teachung fixed
dwinter
parents:
191
diff
changeset
|
848 |
522d32a50c2b
bug with umlauts in editing talks and teachung fixed
dwinter
parents:
191
diff
changeset
|
849 val = sql_quote(newEntries[newEntry][key]) |
522d32a50c2b
bug with umlauts in editing talks and teachung fixed
dwinter
parents:
191
diff
changeset
|
850 if not isinstance(val, unicode): |
522d32a50c2b
bug with umlauts in editing talks and teachung fixed
dwinter
parents:
191
diff
changeset
|
851 val = val.decode("utf-8") |
522d32a50c2b
bug with umlauts in editing talks and teachung fixed
dwinter
parents:
191
diff
changeset
|
852 |
522d32a50c2b
bug with umlauts in editing talks and teachung fixed
dwinter
parents:
191
diff
changeset
|
853 values.append("'"+val+"'") |
37 | 854 |
855 | |
856 keystring=",".join(keys) | |
857 | |
858 valuestring=",".join(values) | |
859 | |
860 query+=" (%s) "%keystring | |
861 query+="VALUES (%s)"%valuestring | |
862 if not (newEntries[newEntry][mainfield[newEntry]].lstrip().rstrip()==""): | |
863 self.executeZSQL(query) | |
864 | |
865 | |
38 | 866 |
208
6d6076e28430
fix deleteField for additionalLink (still ugly though)
casties
parents:
206
diff
changeset
|
867 security.declareProtected('View management screens','deleteField') |
37 | 868 def deleteField(self,REQUEST): |
869 """delete entry""" | |
208
6d6076e28430
fix deleteField for additionalLink (still ugly though)
casties
parents:
206
diff
changeset
|
870 # TODO: this is ugly |
6d6076e28430
fix deleteField for additionalLink (still ugly though)
casties
parents:
206
diff
changeset
|
871 CHANGEABLE=['talks','teaching','pubmanbiblio','additionallink'] |
37 | 872 |
873 table = REQUEST.form.get('table',None); | |
874 oid = REQUEST.form.get('oid',None); | |
875 | |
185 | 876 |
877 if not table in CHANGEABLE: | |
878 return | |
879 if oid is None: | |
880 oid = REQUEST.form.get('key',None); | |
881 | |
37 | 882 if table is None or oid is None: |
883 return | |
884 | |
208
6d6076e28430
fix deleteField for additionalLink (still ugly though)
casties
parents:
206
diff
changeset
|
885 query="DELETE FROM %s WHERE oid = %%s"%(table) |
6d6076e28430
fix deleteField for additionalLink (still ugly though)
casties
parents:
206
diff
changeset
|
886 self.executeZSQL(query, [oid]) |
6d6076e28430
fix deleteField for additionalLink (still ugly though)
casties
parents:
206
diff
changeset
|
887 |
37 | 888 REQUEST.response.redirect(self.REQUEST['HTTP_REFERER']) |
889 | |
890 | |
40 | 891 def invalidate_cache(self): |
37 | 892 #TODO: How to invalidate the varnish cache from the member object |
893 pass; | |
894 | |
79 | 895 |
896 # TODO: compat, is this used? | |
897 getStaffURL = getUsername | |
37 | 898 |
191
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 def getBreadcrumbs(self): |
90d44df497a6
updated breadcrumb handling, works for members now.
casties
parents:
190
diff
changeset
|
901 """return list of breadcrumbs from here to the root""" |
90d44df497a6
updated breadcrumb handling, works for members now.
casties
parents:
190
diff
changeset
|
902 crumbs = [] |
90d44df497a6
updated breadcrumb handling, works for members now.
casties
parents:
190
diff
changeset
|
903 label = '%s %s'%(self.content.first_name, self.content.last_name) |
90d44df497a6
updated breadcrumb handling, works for members now.
casties
parents:
190
diff
changeset
|
904 baseUrl = None |
90d44df497a6
updated breadcrumb handling, works for members now.
casties
parents:
190
diff
changeset
|
905 parent = aq_parent(self) |
90d44df497a6
updated breadcrumb handling, works for members now.
casties
parents:
190
diff
changeset
|
906 # get parents breadcrumbs |
90d44df497a6
updated breadcrumb handling, works for members now.
casties
parents:
190
diff
changeset
|
907 if hasattr(parent, 'getBreadcrumbs'): |
90d44df497a6
updated breadcrumb handling, works for members now.
casties
parents:
190
diff
changeset
|
908 crumbs = parent.getBreadcrumbs() |
90d44df497a6
updated breadcrumb handling, works for members now.
casties
parents:
190
diff
changeset
|
909 if len(crumbs) > 0: |
90d44df497a6
updated breadcrumb handling, works for members now.
casties
parents:
190
diff
changeset
|
910 # get base url from crumbs |
90d44df497a6
updated breadcrumb handling, works for members now.
casties
parents:
190
diff
changeset
|
911 baseUrl = crumbs[-1]['url'] + '/members' |
90d44df497a6
updated breadcrumb handling, works for members now.
casties
parents:
190
diff
changeset
|
912 |
90d44df497a6
updated breadcrumb handling, works for members now.
casties
parents:
190
diff
changeset
|
913 if baseUrl is None: |
90d44df497a6
updated breadcrumb handling, works for members now.
casties
parents:
190
diff
changeset
|
914 baseUrl = '/en/staff/members' |
90d44df497a6
updated breadcrumb handling, works for members now.
casties
parents:
190
diff
changeset
|
915 |
90d44df497a6
updated breadcrumb handling, works for members now.
casties
parents:
190
diff
changeset
|
916 # add this |
90d44df497a6
updated breadcrumb handling, works for members now.
casties
parents:
190
diff
changeset
|
917 crumbs.append({'text':label, 'url':self.getUrl(baseUrl=baseUrl), 'object':self}) |
90d44df497a6
updated breadcrumb handling, works for members now.
casties
parents:
190
diff
changeset
|
918 |
90d44df497a6
updated breadcrumb handling, works for members now.
casties
parents:
190
diff
changeset
|
919 return crumbs |
90d44df497a6
updated breadcrumb handling, works for members now.
casties
parents:
190
diff
changeset
|
920 |
90d44df497a6
updated breadcrumb handling, works for members now.
casties
parents:
190
diff
changeset
|
921 |
56 | 922 def getPublicationsFromPubman(self,limit=None,publicationType=None): |
141
45b7b24c8c42
move getPublicationsFromPubman to MPIWGStaffMember.
casties
parents:
134
diff
changeset
|
923 """Return list of publications.""" |
110
b554becd8226
Incomplete - # 74: More Link auf den pers?nlichne Homepages
dwinter
parents:
107
diff
changeset
|
924 if self.content.publications_mode=="year": |
47 | 925 coneId = self.getConeId(); |
926 if coneId: | |
141
45b7b24c8c42
move getPublicationsFromPubman to MPIWGStaffMember.
casties
parents:
134
diff
changeset
|
927 pubs = self.folder.mpiwgPubman.getPublications(coneId,limit=limit,publicationType=publicationType) |
45b7b24c8c42
move getPublicationsFromPubman to MPIWGStaffMember.
casties
parents:
134
diff
changeset
|
928 #pubs= self.folder.getPublicationsFromPubman(coneId,limit=limit,publicationType=publicationType) |
156 | 929 return pubs |
38 | 930 |
47 | 931 elif self.content.publications_mode=="priority": |
932 selPubs= self.getSelectedPublications() | |
933 | |
934 pubs=[] | |
73 | 935 count =0 |
47 | 936 for selPub in selPubs: |
73 | 937 if limit and count >= limit: |
938 break | |
110
b554becd8226
Incomplete - # 74: More Link auf den pers?nlichne Homepages
dwinter
parents:
107
diff
changeset
|
939 |
53 | 940 logging.debug("searchFor:%s"%selPub.escidocid) |
110
b554becd8226
Incomplete - # 74: More Link auf den pers?nlichne Homepages
dwinter
parents:
107
diff
changeset
|
941 entry = self.mpiwgPubman.getEntryFromPubman(selPub.escidocid,extendedData=True); |
b554becd8226
Incomplete - # 74: More Link auf den pers?nlichne Homepages
dwinter
parents:
107
diff
changeset
|
942 |
b554becd8226
Incomplete - # 74: More Link auf den pers?nlichne Homepages
dwinter
parents:
107
diff
changeset
|
943 #TODO getEntryFromPubmanShould return long texts |
b554becd8226
Incomplete - # 74: More Link auf den pers?nlichne Homepages
dwinter
parents:
107
diff
changeset
|
944 typesLongShort={'http://purl.org/eprint/type/Book':'book', |
b554becd8226
Incomplete - # 74: More Link auf den pers?nlichne Homepages
dwinter
parents:
107
diff
changeset
|
945 'http://purl.org/eprint/type/BookItem':'book-item', |
b554becd8226
Incomplete - # 74: More Link auf den pers?nlichne Homepages
dwinter
parents:
107
diff
changeset
|
946 '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
|
947 |
156 | 948 if publicationType is not None: |
949 #publicaitions typ ist gesetzt | |
134 | 950 |
156 | 951 if not ((entry[1] == publicationType) or (entry[1] == typesLongShort.get(publicationType,''))) : |
952 #stimmt nicht dann weiter | |
110
b554becd8226
Incomplete - # 74: More Link auf den pers?nlichne Homepages
dwinter
parents:
107
diff
changeset
|
953 continue; |
202 | 954 |
955 if len(entry)>4: | |
956 pubs.append((selPub.escidocid,entry[0],entry[2],entry[3],entry[4])); | |
957 count+=1 | |
47 | 958 |
46 | 959 return pubs |
156 | 960 |
961 return [] | |
47 | 962 |
963 | |
100 | 964 def publications_full_html(self, REQUEST): |
47 | 965 """show publication""" |
100 | 966 pt=PageTemplateFile('zpt/staff/pubman/show_publications.zpt', globals()).__of__(self) |
47 | 967 return pt(member=self.content) |
968 | |
185 | 969 |
970 security.declareProtected('View management screens','addPublicationsFromPubman') | |
47 | 971 def addPublicationsFromPubman(self,REQUEST): |
972 """addPublications from pubman""" | |
973 | |
974 data=REQUEST.form | |
38 | 975 |
47 | 976 if data.get("method",None) is None: |
159 | 977 pt=PageTemplateFile('zpt/staff/pubman/add_publications.zpt', globals()).__of__(self) |
47 | 978 return pt() |
979 | |
37 | 980 |
981 | |
47 | 982 if data.get("method") == "search": |
73 | 983 |
984 | |
985 | |
201 | 986 entries= self.mpiwgPubman.search(data,contexts=["escidoc:85274","escidoc:38279","escidoc:644427"],resultWithContext=True) |
159 | 987 pt=PageTemplateFile('zpt/staff/pubman/add_publications.zpt', globals()).__of__(self) |
47 | 988 |
989 | |
990 return pt(values=entries) | |
991 | |
992 | |
993 | |
994 if data.get("method") == "add": | |
995 | |
996 return self.addEntriesToPublicationList(data) | |
997 #pt=PageTemplateFile(os.path.join(package_home(globals()),'zpt/staff/pubman','add_publications.zpt')).__of__(self) | |
998 | |
999 | |
1000 | |
1001 def addEntriesToPublicationList(self,data): | |
1002 """fuege eintrage aus data zur publications liste, | |
1003 @param data Map mit escidocID --> value | |
1004 value muss "add" sein damit hinzugefuegt wird""" | |
1005 | |
1006 for key in data.keys(): | |
1007 | |
56 | 1008 if key.startswith('escidoc:'): |
1009 | |
47 | 1010 |
56 | 1011 query="INSERT INTO pubmanbiblio (key_main,escidocId) values (%s,%s)" |
47 | 1012 |
56 | 1013 if data.get(key)=="add": |
1014 self.executeZSQL(query,[self.getKey(),key]) | |
1015 | |
47 | 1016 |
1017 | |
56 | 1018 #selectedPublications = self.getSelectedPublications() |
1019 | |
1020 #pt = PageTemplateFile(os.path.join(package_home(globals()),'zpt/staff/pubman','change_publications.zpt')).__of__(self) | |
47 | 1021 |
56 | 1022 #return pt() |
1023 if hasattr(self,'REQUEST'): | |
1024 return self.REQUEST.response.redirect("changePublications") | |
47 | 1025 |
1026 | |
1027 def changePublications(self,REQUEST): | |
1028 """change published publications""" | |
1029 | |
1030 data=REQUEST.form | |
1031 | |
147 | 1032 if data.get("method","") == "change": |
1033 | |
47 | 1034 for key in data.keys(): |
1035 splitted=key.split("__") #format escidoc_id__p fuer priority, nur escidocid | |
1036 value=data[key] | |
1037 if len(splitted)==1: | |
1038 self.deleteFromPublicationList(key); | |
1039 | |
1040 elif(splitted[1]) == "p": | |
1041 self.setPublicationPriority(splitted[0],value); | |
1042 | |
1043 | |
159 | 1044 pt = PageTemplateFile('zpt/staff/pubman/change_publications', globals()).__of__(self) |
47 | 1045 return pt() |
1046 | |
1047 | |
1048 def deleteFromPublicationList(self,escidocid): | |
1049 """Loessche publication with escidoc id from publication list""" | |
1050 | |
147 | 1051 query ="DELETE FROM pubmanbiblio WHERE escidocid=%s and lower(key_main)=%s" |
47 | 1052 |
147 | 1053 self.executeZSQL(query,[escidocid,self.getKey().lower()]); |
47 | 1054 |
1055 | |
1056 def setPublicationPriority(self,escidocid,value): | |
56 | 1057 try: |
147 | 1058 query="update pubmanbiblio set priority=%s where escidocid=%s and lower(key_main)=%s" |
56 | 1059 |
203 | 1060 try: |
1061 x=int(value) | |
1062 except: | |
1063 logging.error("priority not a number") | |
1064 return | |
1065 | |
147 | 1066 self.executeZSQL(query,[value,escidocid,self.getKey().lower()]); |
56 | 1067 |
1068 except: | |
1069 logging.error("couldn't change:") | |
1070 logging.error(escidocid) | |
1071 logging.error(value) | |
1072 | |
80 | 1073 |
47 | 1074 def getSelectedPublications(self): |
1075 """hole publications aus der datenbank""" | |
100 | 1076 query="select * from pubmanbiblio where lower(key_main) = lower(%s) order by priority ASC" |
47 | 1077 return self.executeZSQL(query,[self.getKey()]) |
68 | 1078 |
1079 | |
233 | 1080 def getProfileHtml(self, REQUEST): |
86 | 1081 """get the profile""" |
233 | 1082 REQUEST.RESPONSE.setHeader('Last-Modified',email.Utils.formatdate().split("-")[0]+'GMT') |
86 | 1083 html="""<html><body>%s</body></html>""" |
1084 if self.content.profile and self.content.profile != "": | |
1085 return html%self.content.profile | |
1086 else: | |
1087 return html%"" | |
1088 | |
1089 | |
68 | 1090 def generateProfileForPerson(self,REQUEST=None): |
1091 """erzeugt ein automatisches Profil aus den alten Eintraegen CV, Current work, und research interests""" | |
1092 | |
1093 ret="" | |
1094 #founds=self.ZSQLInlineSearch(_table='research_interest',key_main=person.getKeyUTF8()) | |
80 | 1095 founds=self.executeZSQL('select * from research_interest where lower(key_main) = %s', [self.getKey().lower()]) |
68 | 1096 if founds: |
236
c90c8333ca8f
fix problem with current_work_p and auto-generated profile.
casties
parents:
234
diff
changeset
|
1097 ret+='<h3>Research interests</h3>\n<p>' |
68 | 1098 for found in self.sortPriority(founds): |
236
c90c8333ca8f
fix problem with current_work_p and auto-generated profile.
casties
parents:
234
diff
changeset
|
1099 ret+=found.interest+'<br/>' |
c90c8333ca8f
fix problem with current_work_p and auto-generated profile.
casties
parents:
234
diff
changeset
|
1100 if founds: |
c90c8333ca8f
fix problem with current_work_p and auto-generated profile.
casties
parents:
234
diff
changeset
|
1101 ret+='</p>\n' |
237 | 1102 if self.content.current_work: |
236
c90c8333ca8f
fix problem with current_work_p and auto-generated profile.
casties
parents:
234
diff
changeset
|
1103 ret+="<h3>Current work</h3>" |
c90c8333ca8f
fix problem with current_work_p and auto-generated profile.
casties
parents:
234
diff
changeset
|
1104 ret+='<p>'+self.content.current_work+'</p>\n' |
c90c8333ca8f
fix problem with current_work_p and auto-generated profile.
casties
parents:
234
diff
changeset
|
1105 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
|
1106 ret+="<h3>Curriculum Vitae</h3>" |
c90c8333ca8f
fix problem with current_work_p and auto-generated profile.
casties
parents:
234
diff
changeset
|
1107 ret+='<p>'+self.formatAscii(self.content.cv)+'</p>' |
68 | 1108 |
1109 return ret | |
47 | 1110 |
189
cc5198541af8
erzeugen neuer eintr?ge auf der homepage mittels updatexml
dwinter
parents:
188
diff
changeset
|
1111 |
cc5198541af8
erzeugen neuer eintr?ge auf der homepage mittels updatexml
dwinter
parents:
188
diff
changeset
|
1112 |
186 | 1113 # initialize security |
1114 InitializeClass(MPIWGStaffFolder) | |
3 | 1115 InitializeClass(MPIWGStaffMember) |