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