1: """This contains the class MPIWG Projects
2: for organizing and maintaining the different project pages
3:
4: """
5: #TODO: mechanismus fur links to personen ueberarbeiten, da jetzt alle e_mails als members auftauchen unabhaenig vom status publish_the_data
6: #TODO: was passiert wenn aenderungen von jochen im filemaker nicht mit den aenderungen im sql uebereinstimmen
7: #TODO: in einzelnen projecte steht als pfad auf die bilder noch wwwneu statt www
8:
9: from Products.PageTemplates.PageTemplateFile import PageTemplateFile
10: from Products.PageTemplates.PageTemplate import PageTemplate
11: from Products.PageTemplates.ZopePageTemplate import ZopePageTemplate
12: from Products.ZSQLExtend.ZSQLExtend import ZSQLExtendFolder
13: from Products.ZCatalog.CatalogPathAwareness import CatalogAware
14: from OFS.Image import Image
15: from Globals import package_home
16: import urllib
17: import MPIWGStaff
18: import string
19: import re
20: import os
21: from types import *
22: import logging
23: import xmlhelper # Methoden zur Verwaltung der projekt xml
24: from OFS.SimpleItem import SimpleItem
25: from OFS.Folder import Folder
26: from Products.ZSQLMethods.SQL import SQLConnectionIDs
27: from AccessControl import ClassSecurityInfo
28: from bibliography import *
29: import time
30: import xml.dom.minidom
31: import sys
32: from Ft.Xml.XPath import Evaluate
33: from Ft.Xml.XPath.Context import Context
34: from Ft.Xml.Domlette import NonvalidatingReader,PrettyPrint, Print
35: from Ft.Xml import EMPTY_NAMESPACE
36: import copy
37: import updatePersonalWWW
38: import MPIWGStaff
39:
40: definedFields=['WEB_title','xdata_01','xdata_02','xdata_03','xdata_04','xdata_05','xdata_06','xdata_07','xdata_08','xdata_09','xdata_10','xdata_11','xdata_12','xdata_13','WEB_project_header','WEB_project_description','WEB_related_pub']
41:
42: checkFields = ['xdata_01']
43:
44: #ersetzt logging
45: def logger(txt,method,txt2):
46: """logging"""
47: logging.info(txt+ txt2)
48:
49: def getTextFromNode(nodename):
50: nodelist=nodename.childNodes
51: rc = ""
52: for node in nodelist:
53: if node.nodeType == node.TEXT_NODE:
54: rc = rc + node.data
55: return rc
56:
57:
58: def sortStopWordsF(self,xo,yo):
59: if not hasattr(self,'_v_stopWords'):
60: self._v_stopWords=self.stopwords_en.data.split("\n")
61:
62: x=str(xo[1])
63: y=str(yo[1])
64:
65: strx=x.split(" ")
66: stry=y.split(" ")
67:
68: for tmp in strx:
69: if tmp.lower() in self._v_stopWords:
70: del strx[strx.index(tmp)]
71:
72: for tmp in stry:
73: if tmp.lower() in self._v_stopWords:
74: del stry[stry.index(tmp)]
75:
76: return cmp(" ".join(strx)," ".join(stry))
77:
78: def sortStopWords(self):
79: return lambda x,y : sortStopWordsF(self,x,y)
80:
81: def sortF(x,y):
82: try:
83: return cmp(x[1],y[1])
84: except:
85: try:
86: return cmp(str(x[1]),str(y[1]))
87: except:
88:
89: return 0
90:
91: def sortI(x,y):
92: xsplit=x[1].split(".")
93: ysplit=y[1].split(".")
94: xret=""
95: yret=""
96: try:
97: for i in range(5):
98: try:
99: yret=yret+"%04i"%int(xsplit[i])
100: except:
101: yret=yret+"%04i"%0
102:
103: try:
104: xret=xret+"%04i"%int(ysplit[i])
105: except:
106: xret=xret+"%04i"%0
107:
108:
109: return cmp(int(yret),int(xret))
110: except:
111: return cmp(x[1],y[1])
112:
113:
114: def unicodify(str):
115: """decode str (utf-8 or latin-1 representation) into unicode object"""
116: if not str:
117: return ""
118: if type(str) is StringType:
119: try:
120: return str.decode('utf-8')
121: except:
122: return str.decode('latin-1')
123: else:
124: return str
125:
126: def utf8ify(str):
127: """encode unicode object or string into byte string in utf-8 representation"""
128: if not str:
129: return ""
130: if type(str) is StringType:
131: return str
132: else:
133: return str.encode('utf-8')
134:
135:
136: class MPIWGLink(SimpleItem):
137: """create a symbolic link to another page"""
138:
139: meta_type="MPIWGLink"
140:
141: def isActiveItem(self):
142: """teste ob ausgewaehlt"""
143: #url1 beim link anstelle von url1, da link jeweils index_html als url hat.
144: if self.absolute_url()==self.REQUEST['URL1']:
145: return "aktiv"
146: else:
147: return ""
148:
149: def __init__(self,id,link,title='',weight=''):
150: """init mpiwglink"""
151: self.id=id
152: self.link=link
153: self.title=title
154: self.weight=weight
155:
156: def getObj(self):
157: """bekomme original"""
158: ## objpath=self.link.replace("/",".")
159: ## if objpath[0]!=".":
160: ## objpath="."+objpath
161:
162: ## print objpath
163: ## return eval("self"+objpath)
164:
165:
166: splitted=self.link.lstrip().split("/")
167: obj=self
168: for x in splitted:
169: if not x=="":
170: obj=getattr(obj,x)
171:
172: return obj
173:
174: def getWeight(self):
175: if self.linkWeight and self.linkWeight!="":
176: return self.linkWeight
177: else:
178: return self.getObj().weight
179:
180: manage_options=(
181: {'label':'main config','action':'changeLinkForm'},
182: )+SimpleItem.manage_options
183:
184:
185: def changeLinkForm(self):
186: """change MPIWG link"""
187: pt=PageTemplateFile(os.path.join(package_home(globals()),'zpt','MPIWGLinkChange.zpt')).__of__(self)
188: return pt()
189:
190: def changeLink(self,link,title,weight,RESPONSE=None):
191: """change links"""
192: self.link=link
193: self.title=title
194: self.weight=weight
195:
196: if RESPONSE is not None:
197: RESPONSE.redirect('manage')
198:
199: def index_html(self,**argv):
200: """index"""
201:
202:
203:
204: try:
205: return self.getObj().pt_render(extra_context={'here':self})
206: except:
207: self.REQUEST.RESPONSE.redirect(self.getObj().absolute_url())
208:
209:
210:
211: def manage_addMPIWGLinkForm(self):
212: """Form for adding link"""
213: pt=PageTemplateFile(os.path.join(package_home(globals()),'zpt/AddMPIWGLink.zpt')).__of__(self)
214: return pt()
215:
216: def manage_addMPIWGLink(self,id,link,title,weight,RESPONSE=None):
217: """add link"""
218: newObj=MPIWGLink(id,link,title,weight)
219:
220: self._setObject(id,newObj)
221:
222: if RESPONSE is not None:
223: RESPONSE.redirect('manage_main')
224:
225:
226: class MPIWGTemplate(ZopePageTemplate):
227: """Create a layout Template for different purposes"""
228:
229: meta_type="MPIWGTemplate"
230:
231: manage_options=ZopePageTemplate.manage_options+(
232: {'label':'Change Weight','action':'changeWeightForm'},
233: )
234:
235: def changeWeightForm(self):
236: """change weight form"""
237: pt=PageTemplateFile(os.path.join(package_home(globals()),'zpt','MPIWGTemplateChangeWeight.zpt')).__of__(self)
238: return pt()
239:
240: def changeWeight(self,weight,RESPONSE=None):
241: """change weight"""
242: self.weight=weight
243: if RESPONSE is not None:
244: RESPONSE.redirect('manage')
245:
246:
247: def __init__(self, id, text=None, content_type=None,MPIWGType=None):
248: self.id = str(id)
249:
250:
251:
252: self.ZBindings_edit(self._default_bindings)
253: if text is None:
254: self._default_content_fn = os.path.join(package_home(globals()),
255: 'zpt/MPIWG_%s_template_standard.zpt'%MPIWGType)
256: text = open(self._default_content_fn).read()
257: self.pt_edit(text, content_type)
258:
259:
260: """change form"""
261:
262: def isActiveItem(self):
263: """teste ob ausgewaehlt"""
264: if self.absolute_url()==self.REQUEST['URL']:
265: return "aktiv"
266: else:
267: return ""
268:
269: def manage_addMPIWGTemplateForm(self):
270: """Form for adding"""
271: pt=PageTemplateFile(os.path.join(package_home(globals()),'zpt/AddMPIWGTemplate.zpt')).__of__(self)
272: return pt()
273:
274: from urllib import quote
275:
276:
277: def manage_addMPIWGTemplate(self, MPIWGType,id, text="",title=None,weight=0,REQUEST=None):
278: "Add a Page Template with optional file content."
279: if type(MPIWGType)==StringType:
280: MPIWGTypes=[MPIWGType]
281: else:
282: MPIWGTypes=MPIWGType
283:
284: for singleType in MPIWGTypes:
285:
286:
287: if REQUEST is None:
288: self._setObject(id, MPIWGTemplate(id, text,EchoType=singleType))
289: ob = getattr(self, id)
290:
291: if title:
292: ob.pt_setTitle(title)
293: return ob
294: else:
295: file = REQUEST.form.get('file')
296: headers = getattr(file, 'headers', None)
297: if headers is None or not file.filename:
298: zpt = MPIWGTemplate(id,MPIWGType=singleType)
299: else:
300: zpt = MPIWGTemplate(id, file, headers.get('content_type'))
301:
302: self._setObject(id, zpt)
303: ob = getattr(self, id)
304: if title:
305: ob.pt_setTitle(title)
306:
307: try:
308: u = self.DestinationURL()
309: except AttributeError:
310: u = REQUEST['URL1']
311:
312: ob = getattr(self, id)
313: ob.weight=weight
314:
315: REQUEST.RESPONSE.redirect(u+'/manage_main')
316: return ''
317:
318:
319: class MPIWGRoot(ZSQLExtendFolder):
320: """Stammordner fuer den Web-Server"""
321:
322: fieldLabels={'WEB_title':'WEB_Title','xdata_01':'Responsible Scientists','xdata_02':'Department',
323: 'xdata_03':'Historical Persons','xdata_04':'Time period',
324: 'xdata_05':'Sorting number','xdata_06':'Keywords','xdata_07':'Short title',
325: 'xdata_08':'Other involved scholars' ,'xdata_09':'Disciplines','xdata_10':'Themes',
326: 'xdata_11':'Object Digitallibrary','xdata_12':'Cooperation partners',
327: 'xdata_13':'Funding institutions','WEB_project_header':'WEB_project_header',
328: 'WEB_project_description':'WEB_project_description','WEB_related_pub':'WEB_related_pub'}
329:
330: folders=['MPIWGProject','Folder','ECHO_Navigation']
331: meta_type='MPIWGRoot'
332:
333:
334: def harvestProjects(self):
335: """harvest"""
336: folder="/tmp"
337: try:
338: os.mkdir("/tmp/harvest_MPIWG")
339: except:
340: pass
341: founds=self.ZopeFind(self.aq_parent.projects,obj_metatypes=['MPIWGProject'],search_sub=1)
342: for found in founds:
343: txt=found[1].harvest_page()
344:
345: if txt and (txt != ""):
346: name=found[0].replace("/","_")
347: fh=file("/tmp/harvest_MPIWG/"+name,"w")
348: fh.write(txt)
349: fh.close()
350:
351: def decode(self,str):
352: """decoder"""
353: if not str:
354: return ""
355: if type(str) is StringType:
356: try:
357: return str.decode('utf-8')
358: except:
359: return str.decode('latin-1')
360: else:
361: return str
362:
363:
364: def getat(self,array,idx=0,default=None):
365: """return array element idx or default (but no exception)"""
366: if len(array) <= idx:
367: return default
368: else:
369: return array[idx]
370:
371:
372: def browserCheck(self):
373: """check the browsers request to find out the browser type"""
374: bt = {}
375: ua = self.REQUEST.get_header("HTTP_USER_AGENT")
376: bt['ua'] = ua
377: bt['isIE'] = False
378: bt['isN4'] = False
379: if string.find(ua, 'MSIE') > -1:
380: bt['isIE'] = True
381: else:
382: bt['isN4'] = (string.find(ua, 'Mozilla/4.') > -1)
383:
384: try:
385: nav = ua[string.find(ua, '('):]
386: ie = string.split(nav, "; ")[1]
387: if string.find(ie, "MSIE") > -1:
388: bt['versIE'] = string.split(ie, " ")[1]
389: except: pass
390:
391: bt['isMac'] = string.find(ua, 'Macintosh') > -1
392: bt['isWin'] = string.find(ua, 'Windows') > -1
393: bt['isIEWin'] = bt['isIE'] and bt['isWin']
394: bt['isIEMac'] = bt['isIE'] and bt['isMac']
395: bt['staticHTML'] = False
396:
397: return bt
398:
399:
400: def versionHeaderEN(self):
401: """version header text"""
402:
403: date= self.REQUEST.get('date',None)
404: if date:
405: txt="""<h2>This pages shows the project which existed at %s</h2>"""%str(date)
406: return txt
407: return ""
408:
409: def versionHeaderDE(self):
410: """version header text"""
411: date= self.REQUEST.get('date',None)
412: if date:
413: txt="""<h2>Auf dieser Seite finden Sie die Projekte mit Stand vom %s</h2>"""%str(date)
414: return ""
415:
416:
417: def createOrUpdateId_raw(self):
418: """create sequence to create ids for bibliography"""
419: debug=None
420: #suche groesste existierende id
421: founds=self.ZSQLQuery("select id from bibliography")
422:
423: if founds:
424: ids=[int(x.id[1:]) for x in founds]
425: maximum=max(ids)
426:
427: id_raw=self.ZSQLQuery("select nextval('id_raw')",debug=debug)
428:
429: if id_raw:
430: self.ZSQLQuery("drop sequence id_raw",debug=debug)
431:
432: self.ZSQLQuery("create sequence id_raw start %i"%(maximum+1),debug=debug)
433:
434:
435: def queryLink(self,link):
436: """append querystring to the link"""
437: return "%s?%s"%(link,self.REQUEST.get('QUERY_STRING',''))
438:
439: def getKategory(self,url):
440: """kategorie"""
441: splitted=url.split("/")
442: return splitted[4]
443:
444: def generateUrlProject(self,url,project=None):
445: """erzeuge aus absoluter url, relative des Projektes"""
446: if project:
447: splitted=url.split("/")
448: length=len(splitted)
449: short=splitted[length-2:length]
450:
451: base=self.REQUEST['URL3']+"/"+"/".join(short)
452:
453: else:
454: findPart=url.find("/projects/")
455: base=self.REQUEST['URL1']+"/"+url[findPart:]
456:
457:
458: return base
459:
460: def isNewCapital(self,text=None,reset=None):
461: if reset:
462: self.REQUEST['capital']="A"
463: return True
464: else:
465: if len(text)>0 and not (text[0]==self.REQUEST['capital']):
466: self.REQUEST['capital']=text[0]
467: return True
468: else:
469: return False
470:
471: def subNavStatic(self,obj):
472: """subnav" von self"""
473: def sortWeight(x,y):
474: x1=int(getattr(x[1],'weight','0'))
475: y1=int(getattr(y[1],'weight','0'))
476: return cmp(x1,y1)
477:
478: subs=self.ZopeFind(obj,obj_metatypes=['MPIWGTemplate','MPIWGLink'])
479: subret=[]
480:
481: for x in subs:
482: if not(x[1].title==""):
483: subret.append(x)
484: subret.sort(sortWeight)
485: return subret
486:
487: def subNav(self,obj):
488: """return subnav elemente"""
489: def sortWeight(x,y):
490: x1=int(getattr(x[1],'weight','0'))
491: y1=int(getattr(y[1],'weight','0'))
492: return cmp(x1,y1)
493: #if obj.meta_type in ['MPIWGTemplate','MPIWGLink']:
494: # id=obj.aq_parent.getId()
495: #else:
496:
497: #id=obj.getId()
498:
499:
500: #suche die zweite ebene
501:
502: if not obj.aq_parent.getId() in ['de','en']:
503: obj=obj.aq_parent
504:
505: while not self.ZopeFind(self,obj_ids=[obj.getId()]):
506: obj=obj.aq_parent
507:
508:
509: if hasattr(self,obj.getId()):
510:
511: subs=self.ZopeFind(getattr(self,obj.getId()),obj_metatypes=['MPIWGTemplate','MPIWGLink'])
512: subret=[]
513:
514: for x in subs:
515: if not(x[1].title==""):
516: subret.append(x)
517: subret.sort(sortWeight)
518: return subret
519: else:
520: return None
521:
522: def isActive(self,name):
523: """teste ob subnavigation aktiv"""
524: for part in self.REQUEST['URL'].split("/"):
525: if part==name:
526: return True
527: return False
528:
529: def getSection(self):
530: """returns the current section name"""
531: root = self.absolute_url()
532: url = self.REQUEST['URL']
533: if not url:
534: return None
535: path = string.replace(url, root, '')
536: paths = path.split('/')
537: if len(paths) > 0:
538: sec = paths[1]
539: if sec.find('.') < 0:
540: return sec
541: else:
542: return None
543: return None
544:
545: def getSectionStyle(self, name, style=""):
546: """returns a string with the given style + '-sel' if the current section == name"""
547: if self.getSection() == name:
548: return style + '-sel'
549: else:
550: return style
551:
552: def MPIWGrootURL(self):
553: """returns the URL to the root"""
554: return self.absolute_url()
555:
556: def upDateSQL(self,fileName):
557: """updates SQL databases using fm.jar"""
558: fmJarPath=os.path.join(package_home(globals()), 'updateSQL/fm.jar')
559: xmlPath=os.path.join(package_home(globals()), "updateSQL/%s"%fileName)
560: logger("MPIWG Web",logging.INFO,"java -classpath %s -Djava.awt.headless=true Convert %s"%(fmJarPath,xmlPath))
561: ret=os.popen("java -classpath %s -Djava.awt.headless=true Convert %s"%(fmJarPath,xmlPath),"r").read()
562: logger("MPIWG Web",logging.INFO,"result convert: %s"%ret)
563: return 1
564:
565: def patchProjects(self,RESPONSE):
566: """patch"""
567: projects=self.ZopeFind(self.projects,obj_metatypes=['MPIWGProject'])
568: for project in projects:
569: tmp=project[1].WEB_project_description[0].replace("/CD/projects/","")[0:]
570: setattr(project[1],'WEB_project_description',[tmp[0:]])
571: RESPONSE.write("<p>%s</p>\n"%project[0])
572:
573: def replaceNotEmpty(self,format,field):
574: """replace not empty"""
575: if field and (not field.lstrip()==''):
576: return format%field
577: else:
578: return ""
579:
580:
581: def isActual(self,project):
582: """checke if project is actual"""
583: actualTime=time.localtime()
584: obj= project.getObject()
585:
586: if getattr(obj,'archiveTime',actualTime)< actualTime:
587: return False
588: else:
589: return True
590:
591: def redirectIndex_html(self,request):
592: #return request['URL1']+'/index_html'
593:
594: return urllib.urlopen(request['URL1']+'/index_html').read()
595:
596:
597: def formatBibliography(self,here,found):
598: """format"""
599: return formatBibliography(here,found)
600:
601: def getValue(self,fieldStr):
602: """Inhalt des Feldes"""
603:
604: if type(fieldStr)==StringType:
605: field=fieldStr
606: else:
607: field=fieldStr[0]
608: try:
609: if field[len(field)-1]==";":
610: field=field[0:len(field)-1]
611: except:
612:
613: """nothing"""
614: field=re.sub(r';([^\s])','; \g<1>',field)
615: return field.encode('utf-8')
616:
617:
618:
619: def sortedNames(self,list):
620: """sort names"""
621:
622: def sortLastName(x_c,y_c):
623: try:
624: x=urllib.unquote(x_c).encode('utf-8','ignore')
625: except:
626: x=urllib.unquote(x_c)
627:
628: try:
629: y=urllib.unquote(y_c).encode('utf-8','ignore')
630: except:
631: x=urllib.unquote(y_c)
632:
633:
634:
635: try:
636: last_x=x.split()[len(x.split())-1]
637: last_y=y.split()[len(y.split())-1]
638:
639: except:
640:
641: last_x=""
642: last_y=""
643:
644:
645:
646: if last_x<last_y:
647: return 1
648: elif last_x>last_y:
649: return -1
650: else:
651: return 0
652:
653: list.sort(sortLastName)
654: list.reverse()
655:
656: return list
657:
658: def __init__(self, id, title):
659: """init"""
660: self.id=id
661: self.title=title
662:
663: def removeStopWords(self,xo):
664: """remove stop words from xo"""
665: if not hasattr(self,'_v_stopWords'):
666: self._v_stopWords=self.stopwords_en.data.split("\n")
667:
668: x=str(xo)
669:
670: strx=x.split(" ")
671:
672: for tmp in strx:
673:
674: if tmp.lower() in self._v_stopWords:
675: del strx[strx.index(tmp)]
676:
677: return " ".join(strx)
678:
679: def urlQuote(self,str):
680: """quote"""
681: return urllib.quote(str)
682:
683: def urlUnQuote(self,str):
684: """quote"""
685: return urllib.unquote(str)
686:
687:
688:
689: def getProjectsByFieldContent(self,fieldName,fieldContentsEntry, date=None):
690: """gib alle Projekte aus mit Value von field mit fieldName enthaelt ein Element der Liste fieldContents"""
691: def sort(x,y):
692: return cmp(x.WEB_title[0],y.WEB_title[0])
693:
694: if type(fieldContentsEntry) is StringType:
695: fieldContentsTmp=[fieldContentsEntry]
696: else:
697: fieldContentsTmp=fieldContentsEntry
698:
699: fieldContents=[]
700: for x in fieldContentsTmp:
701: fieldContents.append(" AND ".join(x.split()))
702: projects=self.ProjectCatalog({fieldName:string.join(fieldContents,' AND')})
703: #print projects
704: #ret=[x for x in projects]
705: ret=[]
706: for x in projects:
707: obj=x.getObject()
708: obj=obj.getActualVersion(date)
709: if obj and (not getattr(obj,'invisible',None)):
710: #if not (x in ret):
711: ret.append(x)
712:
713: ret.sort(sort)
714: return ret
715:
716: def changeMPIWGRootForm(self):
717: """edit"""
718: pt=PageTemplateFile(os.path.join(package_home(globals()),'zpt','changeMPIWGRootForm')).__of__(self)
719: return pt()
720:
721: def changeMPIWGRoot(self,title,disciplineList,themesList,connection_id,RESPONSE=None):
722: """change"""
723: self.title=title
724: self.connection_id=connection_id
725: self.disciplineList=disciplineList
726: self.themesList=themesList
727:
728: if RESPONSE is not None:
729: RESPONSE.redirect('manage_main')
730:
731:
732:
733: def getContexts(self,childs=None,parents=None,depth=None,date=None,onlyActive=True):
734: """childs alle childs, alle parents"""
735: ret=[]
736:
737: if parents:
738: splitted=parents.split(".")
739: parentId=string.join(splitted[0:len(splitted)-1],".")
740:
741: for project in self.getProjectFields('xdata_05',sort='int',date=date):
742: if project[1]==parentId:
743: ret.append(project)
744:
745: if childs:
746: for project in self.getProjectFields('xdata_05',sort='int',date=date):
747: searchStr=childs+"(\..*)"
748:
749: if (onlyActive and project[0].isActiveProject()) or (not onlyActive):
750: if re.match(searchStr,project[1]):
751:
752: if depth:
753:
754: if int(depth)>=len(project[1].split("."))-len(childs.split(".")):
755:
756: ret.append(project)
757: else:
758: ret.append(project)
759: return ret
760:
761: def getProjectFields(self,fieldName,date=None,folder=None,sort=None):
762: """getListofFieldNames"""
763: ret=[]
764:
765: objects=self.ZopeFind(self.projects,obj_metatypes=['MPIWGProject'],search_sub=0)
766:
767:
768: for object in objects:
769: obj=object[1]
770: obj=obj.getActualVersion(date)
771: if obj and (not getattr(obj,'invisible',None)):
772: if fieldName=="WEB_title_or_short":
773:
774: if len(obj.getContent('xdata_07'))<3: # hack weil z.Z. manchmal noch ein Trennzeichen ; oder , im Feld statt leer
775: fieldNameTmp="WEB_title"
776: else:
777: fieldNameTmp="xdata_07"
778: else:
779: fieldNameTmp=fieldName
780:
781: ret.append((obj,obj.getContent(fieldNameTmp)))
782:
783:
784: if sort=="int":
785: ret.sort(sortI)
786: elif sort=="stopWords":
787:
788: ret.sort(sortStopWords(self))
789:
790: else:
791: ret.sort(sortF)
792:
793: return ret
794:
795: def showNewProjects(self):
796: projects=[]
797: for objs in self.getProjectFields('WEB_title_or_short'): # Get all Projets
798: if objs[0].xdata_05 and (objs[0].xdata_05[0] == ""):
799:
800: projects.append(objs)
801:
802: return projects
803:
804:
805: manage_options = Folder.manage_options+(
806: {'label':'Update personal homepages','action':'updatePersonalwww_html'},
807: {'label':'Reindex catalogs','action':'reindexCatalogs'},
808: {'label':'Main config','action':'changeMPIWGRootForm'},
809: {'label':'add e-mails','action':'showNewDBEntries'},
810: {'label':'update the institutsbibliography','action':'updateInstitutsbiliography'},
811: #{'label':'Edit Historical Persons','action':'editHistoricalPersonsForm'},
812: #{'label':'Store Historical Persons','action':'storeHistoricalPersons'},
813: )
814:
815:
816: def updatePublicationDB(self,personId=None):
817: """updates the publication db, i.e. copy year and type into the main table"""
818:
819: if personId:
820: founds = self.ZSQLInlineSearch(_table="publications",key_main=personId)
821: else:
822: founds = self.ZSQLInlineSearch(_table="publications")
823:
824: for found in founds:
825:
826: if found.id_institutsbibliographie and (not found.id_institutsbibliographie =="") and (not found.id_institutsbibliographie =="0"):
827:
828: entries = self.ZSQLInlineSearch(_table="institutsbiblio",id=found.id_institutsbibliographie)
829: for entry in entries:
830: self.ZSQLChange(_table='publications',_identify='oid=%s' % found.oid,year=entry.year,referencetype=entry.reference_type)
831:
832: if found.id_gen_bib and (not found.id_gen_bib ==""):
833: entries = self.ZSQLInlineSearch(_table="bibliography",id=found.id_gen_bib)
834: for entry in entries:
835: self.ZSQLChange(_table='publications',_identify='oid=%s' % found.oid,year=entry.year,referencetype=entry.reference_type)
836:
837: return True
838:
839: def showNewDBEntries(self):
840: """zeige neue Eintraege in der Datenbank ohne e-mail adressen bzw. fuer die noch kein Object angelegt wurde"""
841:
842: qstr="select * from personal_www where web_object_created='no' and not key=''"
843: res=self.ZSQLQuery(qstr)
844:
845: pt=PageTemplateFile(os.path.join(package_home(globals()),'zpt','showNewDBEntries.zpt')).__of__(self)
846: return pt(newEntries=res)
847:
848: def createNewStaffObjects(self,RESPONSE):
849: """create new staff object"""
850:
851: memberFolder=getattr(self,'members')
852: args=self.REQUEST.form
853: arg_k=args.keys()
854: arg_k.remove("submit")
855: ret=""
856: for key in arg_k:
857: k=self.urlUnQuote(key)
858:
859: qstr="select * from personal_www where key=%s"%self.ZSQLQuote(k)
860: res=self.ZSQLQuery(qstr)[0]
861: if args[key]!="": #email-adresse wurde eingetragen
862: #create the object
863: e_mail=args[key]
864: try:
865: newObj=MPIWGStaff.MPIWGStaff(e_mail,res.last_name,res.first_name,k)
866: memberFolder._setObject(e_mail,newObj)
867: obj=getattr(memberFolder,e_mail)
868: obj.reindex_object()
869: ret+="Created %s \n"%e_mail
870: created=True
871: except:
872: msg="Cannot create new user %s (%s %s)"%(e_mail,sys.exc_info()[0],sys.exc_info()[1])
873: logging.error(msg)
874: ret+=msg+"\n"
875: created=False
876:
877: if created:
878: qstr="update personal_www set web_object_created='yes',e_mail='%s@mpiwg-berlin.mpg.de' where key=%s"%(e_mail,self.ZSQLQuote(k))
879: self.ZSQLQuery(qstr)
880:
881: return ret
882:
883:
884: def generateNewPersonEntry(self,data):
885: """generate a new person entry for data, neue personen werden zunaechst nur in der datenbank angelegt """
886:
887: #memberFolder=getattr(self,'members')
888: #create the object
889:
890: # try:
891: # newObj=MPIWGStaff.MPIWGStaff(urllib.quote(data['key']),data['last_name'].encode('utf-8'),data['first_name'].encode('utf-8'))
892: # memberFolder._setObject(urllib.quote(data['key']),newObj)
893: # except:
894: # return False, "Cannot create new user %s (%s %s)"%(data['key'],sys.exc_info()[0],sys.exc_info()[1])
895: #
896:
897: #create the new entry in the database
898:
899:
900: result,msg=MPIWGStaff.createNewDBEntry(self,data['publish_the_data'],data['key'],data['last_name'],
901: data['first_name'],data['title'],data['status'],"",
902: "",data['date_from'],data['date_to'],
903: data['department'],data['home_inst'],data['funded_by'],
904: data['e_mail2'],data['current_work'],"yes",data['date_stay_at_mpiwg'],data['group'],"no",data['current_work'])
905:
906: return result,msg
907:
908: def updatePersonEntry(self,data,ignoreEntries=[]):
909: """update an person entry from data. but ignore all fields in ignore Entries"""
910:
911: ignoreEntries.append('current_work') # TODO:updatecurrent work
912:
913: if data['date_to']=="": # wenn date_to leer
914: data['date_to']="date_none"
915:
916: if data['date_from']=="": # wenn date_fromleer
917: data['date_from']="date_none"
918: msg=""
919:
920:
921: #eintragen
922:
923: columns=data.keys()
924: for x in ignoreEntries:
925: logging.info("ign rem: %s"%x)
926: try: #falls in ignore entries felder sind, die nicht in columns sind, fange den fehler ab
927: columns.remove(x)
928: except:
929: pass
930:
931:
932: insert=[]
933: for key in columns:
934: if data[key]=="date_none": # date_none eintrag wird zu null uebersetzt
935: insert.append('%s=null'%key)
936: else:
937: insert.append(""" "%s"=%s"""%(key,self.ZSQLQuote(data[key])))
938:
939: insertStr=",".join(insert)
940: queryStr="update personal_www SET %s where key='%s'"%(insertStr,data['key'])
941: self.ZSQLQuery("SET DATESTYLE TO 'German'")
942: self.ZSQLQuery(queryStr)
943:
944: #currentwork
945: #if not (txt==""):
946: # queryStr="INSERT INTO current_work (id_main,current,publish) VALUES ('%s','%s','%s')"%(id,txt,txt_p)
947: #
948: # self.ZSQLQuery(queryStr)
949:
950: return True,msg
951:
952:
953: def updatePersonalwww_doIt(self):
954: """do the update"""
955: args=self.REQUEST.form
956: resultSet=self.REQUEST.SESSION['personal_www']['resultSet']
957: news=self.REQUEST.SESSION['personal_www']['news']
958: conflicts=self.REQUEST.SESSION['personal_www']['conflicts']
959: ret="<html><body>"
960: # generate the new entry
961:
962: if news and (len(news)>0):
963: ret+="<h2>Hinzugefügt</h2>"
964: ret+="<p>Neueinträge erscheinen erst auf der Homepage, wenn ihnen eine e-mail Adresse zugeordnet wurde.</p>"
965: ret+="<ul>"
966: for new in news:
967:
968: if args.has_key(self.urlQuote(new.encode('utf-8'))): # entry was selected
969: result,msg=self.generateNewPersonEntry(resultSet[new])
970: if not result:
971: logging.error("Error (generateNewPersonEntry) %s"%msg)
972: ret+="<li>ERROR: %s %s"%(new.encode('utf-8'),msg)
973: else:
974: ret+="<li>OK: %s"%(new.encode('utf-8'))
975: if news and (len(news)>0):
976: ret+="<p>Neueinträge erscheinen erst auf der Homepage, wenn ihnen eine e-mail Adresse zugeordnet wurde.</p>"
977: ret+="</ul>"
978:
979: # update
980:
981: if len(conflicts.keys())>0:
982: ret+="<h2>Änderung des Benutzers übernehmen</h2>"
983: ret+="<p>Wenn nötig in Filemaker-db ändern:</p>"
984:
985: # konflicte
986: for conflict in conflicts.keys():
987: ignoreEntries=[]
988: displayIgnored=[]
989: for cf in conflicts[conflict]:
990: if args[conflict.encode('utf-8')+'_'+cf[0]]=="stored": #use the stored one
991: ignoreEntries.append(cf[0]) #so ignore field cf[0]
992: displayIgnored.append(cf)
993: if len(displayIgnored)>0:
994: ret+="<h3>%s</h3>"%conflict.encode('utf-8')
995:
996: ret+="<table border='1'>"
997: for iE in displayIgnored:
998: ret+="<tr><td>%s</td><td>%s</td><td>%s</td>"%(iE[0].encode('utf-8'),iE[1].encode('utf-8'),iE[2].encode('utf-8'))
999: ret+="</tabel>"
1000:
1001: self.updatePersonEntry(resultSet[conflict],ignoreEntries=ignoreEntries)
1002:
1003: # rest
1004: cl=list(conflicts.keys())
1005:
1006: for key in resultSet.keys():
1007: if key not in cl:
1008: self.updatePersonEntry(resultSet[key])
1009: return ret+"</body></html>"
1010:
1011:
1012: def updateInstitutsbiliography(self):
1013: """update the Institutsbibliogrpahy"""
1014: self.upDateSQL('personalwww.xml')
1015: return "<html><body>DONE</body></html>"
1016:
1017:
1018: def updatePersonalwww_html(self):
1019: """update form for the homepages web form"""
1020: pt=PageTemplateFile(os.path.join(package_home(globals()),'zpt','updatePersonalwww.zpt')).__of__(self)
1021: return pt()
1022:
1023:
1024: def updatePersonalwww(self,uploadfile):
1025: """update personalwww
1026: @param uploadfile: file handle auf das file
1027: """
1028: dsn=self.getConnectionObj().connection_string
1029: #dsn="dbname=personalwww"
1030: resultSet=updatePersonalWWW.importFMPXML(uploadfile)
1031: news,conflicts=updatePersonalWWW.checkImport(dsn, resultSet)
1032:
1033: self.REQUEST.SESSION['personal_www']={}
1034: self.REQUEST.SESSION['personal_www']['resultSet']=resultSet
1035: self.REQUEST.SESSION['personal_www']['news']=news
1036: self.REQUEST.SESSION['personal_www']['conflicts']=conflicts
1037:
1038: pt=PageTemplateFile(os.path.join(package_home(globals()),'zpt','updatePersonalwww_check.zpt')).__of__(self)
1039: return pt()
1040:
1041:
1042:
1043: def reindexCatalogs(self,RESPONSE=None):
1044: """reindex members and project catalog"""
1045:
1046:
1047: try:
1048:
1049: self.ProjectCatalog.manage_catalogReindex(self.REQUEST,RESPONSE,self.REQUEST['URL1'])
1050: except:
1051: logger("MPIWG Root (updatehomepage)",logging.WARNING," %s %s"%sys.exc_info()[:2])
1052:
1053:
1054:
1055:
1056:
1057: if RESPONSE:
1058: RESPONSE.redirect('manage_main')
1059:
1060:
1061:
1062:
1063: def getAllMembers(self):
1064: #ret=[]
1065:
1066: results=self.MembersCatalog({'isPublished':True})
1067:
1068: ret=[", ".join([proj.lastName, proj.firstName]).decode('utf-8') for proj in results]
1069:
1070: ret.sort()
1071: return ret
1072: def printAllMembers(self):
1073: """print"""
1074: members=self.getAllMembers()
1075: ret=""
1076: for x in members:
1077: ret+="<p>%s</p>"%x
1078: return ret
1079:
1080:
1081: def makeList(self,entry):
1082: """makes a list out of one entry or repeat a list"""
1083: if type(entry) is StringType:
1084: return [entry]
1085: else:
1086: return entry
1087:
1088:
1089: def getTree(self,dep=None,date=None,onlyActive=0,onlyArchived=0):
1090: """generate Tree from project list
1091: als Liste, jeder Eintrag ist ein Tupel ,(Tiefe, ProjektNummer,ProjektObject
1092: onlyActive = 0 : alle Projekte
1093: onlyActive = 1 : nur active Projekte
1094: onlyActive = 2: nur inactive Projekte
1095:
1096: onlyArchived=0: alle Projekte
1097: onlyArchived= 1 : nur aktuelle Projekte
1098: onlyArchived = 2: nur archivierte Projekte
1099: """
1100:
1101: returnListTmp=[]
1102: returnList=[]
1103:
1104: for project in self.getProjectFields('xdata_05',sort="int",date=date): # get Projects sorted by xdata_05
1105:
1106: for idNr in project[1].split(";"): # more than one number
1107: if not idNr=="":
1108: splittedId=idNr.split(".")
1109: depth=len(splittedId)
1110: nr=idNr
1111: #title=project[0].WEB_title
1112: title=[project[0].getContent('WEB_title')]
1113: #print title
1114:
1115: if idNr[0]=="x": # kompatibilitaet mit alter Konvention, x vor der Nummer macht project inactive
1116: project[0].setActiveFlag(False)
1117:
1118: if (not dep) or (idNr[0]==dep): #falls dep gesetzt ist nur dieses hinzufuegen.
1119:
1120: if (onlyActive==0):
1121: returnListTmp.append((depth,nr,title,project[0]))
1122: elif (onlyActive==1) and project[0].isActiveProject(): #nur active projekte
1123: returnListTmp.append((depth,nr,title,project[0]))
1124: elif (onlyActive==2) and (not project[0].isActiveProject()): #nur active projekte
1125: returnListTmp.append((depth,nr,title,project[0]))
1126:
1127:
1128: #filter jetzt die Liste nach Archived oder nicht
1129: for entry in returnListTmp:
1130: if (onlyArchived==0):
1131: returnList.append(entry)
1132: elif (onlyArchived==1) and (not entry[3].isArchivedProject()): #nur active projekte
1133: returnList.append(entry)
1134: elif (onlyArchived==2) and (entry[3].isArchivedProject()): #nur active projekte
1135: returnList.append(entry)
1136:
1137:
1138: return returnList
1139:
1140:
1141:
1142: def changePosition(self,treeId,select,RESPONSE=None):
1143: """Change Postion Entry"""
1144: numbers=[]
1145:
1146: # Suche hoechste bisherige nummer
1147: projects=self.getProjectFields('xdata_05') # get Projects sorted by xdata_05
1148: #print "pj",projects
1149: for project in projects: #suche alle subtrees der treeId
1150: #print treeId
1151:
1152: founds=re.match(treeId+"\.(.*)",project[1].split(";")[0])
1153: if founds:
1154: #print "x",founds.group(0),len(founds.group(0).split("."))
1155: if len(founds.group(0).split("."))==len(treeId.split("."))+1: # nur ein punkt mehr, d.h. untere ebene
1156: try:
1157: numbers.append(int(founds.group(0).split(".")[len(founds.group(0).split("."))-1]))
1158: except:
1159: numbers.append(int(0))
1160:
1161: try:
1162: highest=max(numbers)
1163: except:
1164: highest=0
1165: projects=self.showNewProjects()
1166: for i in self.makeList(select):
1167: highest+=10
1168: projects[int(i)][0].xdata_05=treeId+"."+str(highest)
1169:
1170:
1171: if RESPONSE is not None:
1172: RESPONSE.redirect('showTree')
1173:
1174: def changeTree(self,RESPONSE=None):
1175: """change the complete tree"""
1176: form=self.REQUEST.form
1177: hashList={}
1178: onlyArchived=int(form.get("onlyArchived",0))
1179: onlyActive=int(form.get("onlyActive",0))
1180:
1181:
1182: fields=self.getTree(onlyArchived=onlyArchived,onlyActive=onlyActive)
1183:
1184: logging.info("GOT TREE!----------------------------------------------------")
1185: for field in form.keys():
1186:
1187: splitted=field.split('_')
1188: if (len(splitted)>1) and (splitted[1]=="runningNumber"): #feld hat die Form Nummer_name und runnignNumber
1189:
1190:
1191: nr=int(splitted[0]) # nummer des Datensatzes
1192: currentEntry = fields[nr]
1193:
1194: if form.has_key(str(nr)+'_active'): # active flag is set
1195: fields[nr][3].setActiveFlag(True)
1196: else:
1197: fields[nr][3].setActiveFlag(False)
1198:
1199: #nummer hat sich geŠndert
1200:
1201: entryChanged = False;
1202:
1203:
1204: if not (fields[nr][3].xdata_05==form[str(nr)+'_number']):
1205: logging.info("Changed!Number+++++++++++++++++++++++++++++++++")
1206: fields[nr][3].xdata_05=form[str(nr)+'_number']
1207: entryChanged = True
1208:
1209: #completed har sich geaendert
1210:
1211: if not (fields[nr][3].getCompletedAt()==fields[nr][3].transformDate(form[str(nr)+'_completed'])):
1212: fields[nr][3].setCompletedAt(form[str(nr)+'_completed'])
1213: logging.info("Changed!Completed+++++++++++++++++++++++++++++++++")
1214: entryChanged = True
1215:
1216:
1217: if entryChanged:
1218: logging.info("Changed!+++++++++++++++++++++++++++++++++")
1219: fields[nr][3].copyObjectToArchive()
1220:
1221:
1222: if RESPONSE is not None:
1223: RESPONSE.redirect('showTree')
1224:
1225: def getProjectWithId(self,id):
1226: fields=self.getProjectFields('xdata_05')
1227: for field in fields:
1228: if field[1]==id:
1229: return field[0]
1230:
1231: return None
1232:
1233:
1234:
1235:
1236: def getRelativeUrlFromPerson(self,list):
1237: """get urls to person list"""
1238: ret=[]
1239: persons=list.split(";")
1240: for person in persons:
1241:
1242: if len(person)>1: #nicht nur Trennzeichen
1243: splitted=person.split(",")
1244: if len(splitted)==1:
1245: splitted=person.split(" ")
1246: splittedNew=[re.sub(r'\s(.*)','$1',split) for split in splitted]
1247: if splittedNew[0]=='':
1248: del splittedNew[0]
1249: search=string.join(splittedNew,' AND ')
1250:
1251: if not search=='':
1252:
1253: try:
1254: proj=self.MembersCatalog({'title':search})
1255: except:
1256: proj=None
1257:
1258: if proj:
1259: #ret.append("<a href=%s >%s</a>"%(proj[0].absolute_url,person.encode('utf-8')))
1260: ret.append("<a href=%s >%s</a>"%('members/'+proj[0].id+'/index.html',person))
1261: else:
1262: #ret.append("%s"%person.encode('utf-8'))
1263: ret.append("%s"%person)
1264: return string.join(ret,";")
1265:
1266:
1267: def getMembersFromList(self,list):
1268: """get member names from person full text list"""
1269: memberlist=[]
1270: persons=list.split(";")
1271: for person in persons:
1272: if len(person)>1: #nicht nur Trennzeichen
1273: splitted=person.split(",")
1274: if len(splitted)==1:
1275: splitted=person.lstrip().rstrip().split(" ")
1276: splittedNew=[re.sub(r'\s(.*)','$1',split) for split in splitted]
1277: if splittedNew[0]=='':
1278: del splittedNew[0]
1279: search=string.join(splittedNew,' AND ')
1280:
1281: if not search=='':
1282: try:
1283:
1284: member=self.MembersCatalog({'title':search})
1285:
1286: except:
1287: member=None
1288: if member:
1289: logging.error("search publ %s:"%member[0].getObject().isPublished())
1290: if member and (member[0].getObject().isPublished()):
1291: if person =="Otto Sibum" : person="H. Otto Sibum"
1292: if person =="Norton Wise" : person="M. Norton Wise"
1293:
1294: #memberlist.append("<a href=%s >%s</a>"%(member[0].absolute_url,person.encode('utf-8')))
1295: memberlist.append((person, member[0].getObject().getId()))
1296: else:
1297: #memberlist.append("%s"%person.encode('utf-8'))
1298: memberlist.append((person,None))
1299: return memberlist
1300:
1301: def getUrlFromPerson(self,list):
1302: """get urls to person list"""
1303: ret=[]
1304: persons=list.split(";")
1305: for person in persons:
1306:
1307: if len(person)>1: #nicht nur Trennzeichen
1308: splitted=person.split(",")
1309: if len(splitted)==1:
1310: splitted=person.lstrip().rstrip().split(" ")
1311: splittedNew=[re.sub(r'\s(.*)','$1',split) for split in splitted]
1312: if splittedNew[0]=='':
1313: del splittedNew[0]
1314: search=string.join(splittedNew,' AND ')
1315:
1316: if not search=='':
1317:
1318: try:
1319: proj=self.MembersCatalog({'title':search})
1320: except:
1321: proj=None
1322:
1323: if proj and (proj[0].getObject().isPublished()):
1324: if person =="Otto Sibum" : person="H. Otto Sibum"
1325: if person =="Norton Wise" : person="M. Norton Wise"
1326: #ret.append("<a href=%s >%s</a>"%(proj[0].absolute_url,person.encode('utf-8')))
1327: if self.MPIWGrootURL().split("/")[-1]=='en':
1328: tmpPath="/en/staff/members/"
1329: else:
1330: tmpPath="/de/mitarbeiter/members/"
1331: ret.append("<a href=%s >%s</a>"%(tmpPath+proj[0].getObject().getId()+"/index.html",person))
1332: else:
1333: #ret.append("%s"%person.encode('utf-8'))
1334: ret.append("%s"%person)
1335: return string.join(ret,";")
1336:
1337: def getProjectsOfMembers(self,date=None):
1338: """give tuple member /projects"""
1339: ret=[]
1340: members=self.getAllMembers()
1341:
1342: #return str(members)
1343: for x in members:
1344:
1345: ret+=self.getProjectsOfMember(name=x,date=date)
1346:
1347: return ret
1348:
1349: def getProjectsOfMember(self,name=None,key=None,date=None,onlyArchived=1):
1350: """get projects of a member
1351: @param name: (optional)Vorname + Nachname
1352: @param key: (optional) Key zur Idenfikation des Benutzer
1353: @param date: (optional) Version die zum Zeitpunkt date gueltig war
1354: @param onlyArchived:
1355: onlyArchived=0: alle Projekte
1356: onlyArchived= 1 : nur aktuelle Projekte
1357: onlyArchived = 2: nur archivierte Projekte
1358: """
1359: # TODO: Die ganze Loesung
1360: def sortP(x,y):
1361: """sort by sorting number"""
1362: return cmp(x.WEB_title,y.WEB_title)
1363:
1364: ret=[]
1365: if key:
1366:
1367: members=self.MembersCatalog({'getKey':key})
1368: if len(members)==0:
1369: return ret
1370: splitted = [members[0].lastName,members[0].firstName]
1371:
1372: elif name:
1373:
1374: splitted=name.split(",")
1375: else:
1376: return ret # name oder key mussen definiert sein
1377:
1378:
1379: splitNeu=["\'"+splitted[1]+" "+splitted[0]+"\'"]
1380:
1381: search=string.join(splitNeu,' AND ')
1382:
1383: proj=self.ProjectCatalog({'xdata_01':search})
1384:
1385: if proj:
1386: proj2=[]
1387: for x in proj:
1388: if (not getattr(x.getObject(),'invisible',None)) and (getattr(x.getObject(),'archiveTime','')==''):
1389: # furchtbarer hack um sicher zustellen dass christoph hoffmann nicht mit Dieter Hoffmann verwechselt wird.
1390:
1391: if not((splitted[1]=="Christoph") and (splitted[0]=="Hoffmann") and ( (("%s"%x.WEB_title).find('Einstein')>0) or (("%s"%x.WEB_title).find('Quantum')>0))):
1392: logging.info("XXXXXXXXXXXXXXXXXXXXXXXX")
1393: proj2.append(x)
1394:
1395: else:
1396: proj2=[]
1397:
1398: proj=self.ProjectCatalog({'xdata_08':search})
1399: if proj:
1400: names=[x.WEB_title for x in proj]
1401: for x in proj:
1402:
1403: if (not x.WEB_title in names) and (getattr(x.getObject(),'archiveTime','')==''):
1404: proj2.append(x)
1405:
1406:
1407: proj2.sort(sortP)
1408:
1409: projectListe=[]
1410:
1411: for proj in proj2:
1412: obj=proj.getObject()
1413: if onlyArchived==1: #nur aktuell projecte
1414: if not obj.isArchivedProject():
1415: projectListe.append(proj)
1416: elif onlyArchived==2: #nur archivierte
1417: if obj.isArchivedProject():
1418: projectListe.append(proj)
1419: else: #alle
1420: projectListe.append(proj)
1421:
1422:
1423:
1424: if len(projectListe)>0:
1425: ret.append((name,projectListe))
1426:
1427: return ret
1428:
1429: def givePersonList(self,name):
1430: """check if person is in personfolder and return list of person objects"""
1431:
1432: splitted=name.split(",")
1433: if len(splitted)==1:
1434: splitted=name.lstrip().rstrip().split(" ")
1435: splittedNew=[split.lstrip() for split in splitted]
1436:
1437: if splittedNew[0]=='':
1438: del splittedNew[0]
1439: search=string.join(splittedNew,' AND ')
1440:
1441: if not search=='':
1442: proj=self.MembersCatalog({'title':search})
1443:
1444: if proj:
1445: return [[x.lastName,x.firstName] for x in proj]
1446: else:
1447: return []
1448:
1449: ## splitted=name.split(",") # version nachname, vorname...
1450: ## if len(splitted)>1:
1451: ## lastName=splitted[0]
1452: ## firstName=splitted[1]
1453: ## else:
1454: ## splitted=name.split(" ") #version vorname irgenwas nachnamae
1455:
1456: ## lastName=splitted[len(splitted)-1]
1457: ## firstName=string.join(splitted[0:len(splitted)-1])
1458:
1459: ## objs=[]
1460:
1461: #print self.members
1462: ## for x in self.members.__dict__:
1463: ## obj=getattr(self.members,x)
1464: ## if hasattr(obj,'lastName') and hasattr(obj,'firstName'):
1465:
1466: ## if (re.match(".*"+obj.lastName+".*",lastName) or re.match(".*"+lastName+".*",obj.lastName)) and (re.match(".*"+obj.firstName+".*",firstName) or re.match(".*"+firstName+".*",obj.firstName)):
1467:
1468: ## objs.append((obj,lastName+", "+firstName))
1469:
1470:
1471: ## return objs
1472:
1473:
1474: def personCheck(self,names):
1475: """all persons for list"""
1476: #print "names",names
1477: splitted=names.split(";")
1478: ret={}
1479: for name in splitted:
1480:
1481: if not (name==""):
1482: try:
1483: ret[name]=self.givePersonList(name)
1484: except:
1485: """NOTHIHN"""
1486: #print "RET",ret
1487: return ret
1488:
1489: def giveCheckList(self,person,fieldname):
1490: """return checklist"""
1491: #print "GCL",fieldname
1492: if fieldname=='xdata_01':
1493: x=self.personCheck(person.getContent(fieldname))
1494: #print "GCLBACKX",x
1495: return x
1496:
1497:
1498: def isCheckField(self,fieldname):
1499: """return chechfield"""
1500:
1501: return (fieldname in checkFields)
1502:
1503:
1504: def generateNameIndex(self):
1505: """erzeuge einen index verwendeter personen"""
1506: import psycopg
1507: o = psycopg.connect('dbname=authorities user=dwinter password=3333',serialize=0)
1508: results={}
1509: print self.fulltext.historicalNames.items()
1510: for nameItem in self.fulltext.historicalNames.items(): #gehe durch alle namen des lexikons
1511:
1512: c = o.cursor()
1513: name=nameItem[0]
1514: print "check",name
1515: c.execute("select lastname,firstname from persons where lower(lastname) = '%s'"%quote(name))
1516: tmpres=c.fetchall()
1517: firstnames=[result[1] for result in tmpres] # find all firstnames
1518: if tmpres:
1519: lastname=tmpres[0][0]
1520:
1521: for found in self.fulltext({'names':name}):
1522: if found.getObject().isActual():
1523: for nh in found.getObject().getGetNeighbourhood(name, length=50,tagging=False): #hole umgebung
1524: #schaue nun ob der vorname hinter oder vor dem name ist
1525: position=nh.find(lastname)
1526: # vorher
1527: #print "NH",nh
1528: bevorS=nh[0:position].split()
1529: #print "BV",bevorS
1530: if len(bevorS)>1:
1531: try:
1532: bevor=[bevorS[-1],bevorS[-2]]
1533: except:
1534: bevor=[bevorS[0]]
1535: else:
1536: bevor=[]
1537: #nachher
1538: behindS= re.split("[,|;| ]",nh[position:])
1539: #print "BH",behindS
1540: if len(behindS)>2:
1541: try:
1542: behind=behindS[1:3]
1543: except:
1544: behind=[bevorS[1]]
1545: else:
1546: behind=[]
1547: for firstname in firstnames:
1548: if firstname in bevor+behind: #Namen wie mit Adelspraedikaten werden so erstmal nich gefunden
1549: id="%s,%s"%(lastname,firstname)
1550: if not results.has_key(id):
1551: results[id]=[]
1552: objId=found.getObject().getId()
1553: if not (objId in results[id]):
1554: print "d %s for %s"%(id,objId)
1555: results[id].append(objId)
1556: self.nameIndex=results
1557: return results
1558:
1559: def editNameIndexHTML(self):
1560: """edit the name index"""
1561: if not hasattr(self,'nameIndexEdited'): # falls editierter index noch nicht existiert, kopiere automatisch erstellten
1562: self.nameIndexEdited=copy.copy(self.nameIndex)
1563: print "huh"
1564: #self.nameIndexEdited=copy.copy(self.nameIndex)
1565: #print self.nameIndexEdited
1566: pt=PageTemplateFile(os.path.join(package_home(globals()),'zpt','editHistoricalNames.zpt')).__of__(self)
1567: return pt()
1568:
1569: def getNamesInProject(self,projectId):
1570: """get all names ofnameIndexEdited which are references in projec with projectId"""
1571:
1572: ret=[]
1573: for name in self.nameIndexEdited.keys():
1574: if projectId in self.nameIndexEdited[name]:
1575: ret.append(name)
1576:
1577: return ret
1578:
1579: def editNameIndex(self,RESPONSE=None,name=None,occurrances=None,submit=None):
1580: """edit the index"""
1581: nI=self.nameIndexEdited # mI introduced to make sure that changes to nameIndexEdited are know to ZODB
1582: if submit=="delete":
1583:
1584:
1585: dh=getattr(self,'deletedHistoricalNames',{})
1586:
1587: if type(dh) is ListType:
1588: dh={}
1589: if not dh.has_key(name):
1590: dh[name]=occurrances.split("\n")
1591: else:
1592: dh[name]+=occurrances.split("\n")
1593:
1594: self.deletedHistoricalNames=dh
1595:
1596: del self.nameIndexEdited[name]
1597:
1598:
1599: elif (submit=="change"):
1600:
1601: nI[name]=occurrances.split("\n")[0:]
1602:
1603: elif (submit=="add"):
1604: if not nI.has_key(name):
1605: nI[name]=occurrances.split("\n")
1606: else:
1607: nI[name]+=occurrances.split("\n")
1608:
1609: self.nameIndexEdited=nI
1610:
1611:
1612: if RESPONSE is not None:
1613: RESPONSE.redirect('editNameIndexHTML')
1614:
1615:
1616:
1617: def restoreIndex(self):
1618: """restore"""
1619: self.nameIndexEdited=self.nameIndex
1620: return "done"
1621:
1622:
1623:
1624: def manage_addMPIWGRootForm(self):
1625: """form for adding the root"""
1626: pt=PageTemplateFile(os.path.join(package_home(globals()),'zpt','addMPIWGRootForm.zpt')).__of__(self)
1627: return pt()
1628:
1629: def manage_addMPIWGRoot(self,id,title,connection_id="",RESPONSE=None):
1630: """add a root folder"""
1631: newObj=MPIWGRoot(id,title)
1632: self._setObject(id,newObj)
1633: ob=getattr(self,id)
1634: setattr(ob,'connection_id',connection_id)
1635: if RESPONSE is not None:
1636: RESPONSE.redirect('manage_main')
1637:
1638:
1639: class MPIWGProject_publication(SimpleItem):
1640: """publications object fuer project"""
1641:
1642: meta_type="MPIWGProject_publication"
1643:
1644: def editPublication(self,text=None,RESPONSE=None):
1645: """edit a publication"""
1646:
1647: if (not text):
1648: pt=PageTemplateFile(os.path.join(package_home(globals()),'zpt','edit_publicationForm.zpt')).__of__(self)
1649: return pt()
1650:
1651:
1652: self.text=text[0:]
1653:
1654: if RESPONSE:
1655: RESPONSE.redirect("../managePublications")
1656:
1657: class MPIWGProject_image(Image):
1658: """Images for Projects"""
1659:
1660: meta_type="MPIWGProject_image"
1661:
1662: def showImage(self,imageUrl=None):
1663: """show Images at an extra page"""
1664: self.getContent('WEB_project_description',filter='yes') #get the content and store image infos into session
1665: pt=PageTemplateFile(os.path.join(package_home(globals()),'zpt','projectImageView.zpt')).__of__(self)
1666: return pt()
1667:
1668: def editImage(self,file=None,caption=None,RESPONSE=None):
1669: """edit the Image"""
1670: if (not file) and (not caption):
1671: pt=PageTemplateFile(os.path.join(package_home(globals()),'zpt','edit_imageForm.zpt')).__of__(self)
1672: return pt()
1673:
1674: if file and (not file.filename.lstrip().rstrip()==""):
1675: self.manage_upload(file)
1676:
1677: if caption:
1678: self.caption=caption[0:]
1679:
1680: if RESPONSE:
1681: RESPONSE.redirect("../manageImages")
1682:
1683: class MPIWGProject(CatalogAware,Folder):
1684: """Class for Projects"""
1685:
1686:
1687: security=ClassSecurityInfo()
1688: meta_type='MPIWGProject'
1689: default_catalog='ProjectCatalog'
1690:
1691: def decode(self,str):
1692: """return unicode object"""
1693: return unicodify(str)
1694:
1695: def sortedByPlace(self,metatype):
1696: """find metatype and sort by place"""
1697: def sort(x,y):
1698: return cmp(getattr(x[1],'place',0),getattr(y[1],'place',0))
1699:
1700: founds=self.ZopeFind(self,obj_metatypes=[metatype]);
1701:
1702: founds.sort(sort)
1703:
1704: return founds
1705:
1706:
1707: def copyPublicationsToList(self,RESPONSE=None):
1708: """copy publications in to list"""
1709:
1710: publicationTxt=self.getContent('WEB_related_pub')
1711:
1712: pubSplits=publicationTxt.split("<p>")
1713:
1714: for pubSplit in pubSplits:
1715: pubSplit=pubSplit.replace("</p>","")
1716: self.addPublication(pubSplit)
1717:
1718: if RESPONSE:
1719: RESPONSE.redirect('managePublications')
1720:
1721:
1722: def copyImageToMargin(self,RESPONSE=None):
1723: """copy inline images to marginal images"""
1724:
1725:
1726: #getImages from WEB_project_description
1727: description=self.getContent('WEB_project_description')
1728:
1729: text2=description
1730: splitted=text2.split("""<p class="picture">""")
1731:
1732: imageURLs=[]
1733: imageCaptions=[]
1734: for split in splitted[1:]:
1735: tmp=split.split("</p>")
1736: #return repr(splitted[1])
1737:
1738: try:
1739: imageURLs.append(tmp[0].split("\"")[1].encode('utf-8'))
1740: except:
1741:
1742: try:
1743: imageURLs.append(tmp[0].split("src=")[1].split(" ")[0].encode('utf-8'))
1744: except:
1745: imageURLs.append("")
1746:
1747: split2="</p>".join(tmp[1:])
1748:
1749:
1750: splitted=split2.split("""<p class="picturetitle">""")
1751: if len(splitted)>1:
1752: tmp=splitted[1].split("</p>")
1753: imageCaptions.append(tmp[0].encode('utf-8'))
1754:
1755:
1756: else:
1757: #keine caption
1758:
1759: imageCaptions.append("")
1760:
1761:
1762: #eintragen:
1763: for imageURL in imageURLs:
1764: filename=imageURL.split("/")[-1]
1765: #lege neues images object an, mit leerem bild
1766:
1767: if self.ZopeFind(self,obj_ids=[filename]):
1768: #existiert das bild schon, dann neuen filenamen
1769: filename="project_image_"+filename
1770:
1771: self.addImage(None,imageCaptions[imageURLs.index(imageURL)],filename=filename)
1772: #hole die bilddaten aus der url
1773: url=self.absolute_url()+"/"+imageURL
1774: #url=self.absolute_url()+"/"+filename
1775:
1776: try:#relative url
1777: data=urllib.urlopen(url).read()
1778: except:
1779: try:#absolute
1780: data=urllib.urlopen(self.imageURL).read()
1781: except:
1782: logger("MPIWG Project",logging.ERROR,"can't open: %s"%url)
1783:
1784: obj=getattr(self,filename)
1785: obj.update_data(data)
1786:
1787: if RESPONSE:
1788: RESPONSE.redirect('manageImages')
1789:
1790: def manageImages(self,imageName=None,op=None):
1791: """managage images"""
1792:
1793:
1794: if imageName and op:
1795: if op=='up':
1796: images=self.getImages()
1797: for image in images:
1798: if image[0]==imageName:
1799: nr=images.index(image)
1800: if not nr==0:
1801: images[nr-1][1].place+=1
1802: images[nr][1].place-=1
1803: pass
1804: elif op=='down':
1805: images=self.getImages()
1806: for image in images:
1807: if image[0]==imageName:
1808: nr=images.index(image)
1809: if not (nr==len(images)-1):
1810: images[nr+1][1].place-=1
1811: images[nr][1].place+=1
1812: pass
1813:
1814:
1815: pt=PageTemplateFile(os.path.join(package_home(globals()),'zpt','MPIWGProject_manageImagesForm.zpt')).__of__(self)
1816: return pt()
1817:
1818: def managePublications(self,pubName=None,op=None):
1819: """managage images"""
1820:
1821:
1822: if pubName and op:
1823: if op=='up':
1824: publications=self.getPublications()
1825: for publication in publications:
1826: if publication[0]==pubName:
1827: nr=publications.index(publication)
1828: if not nr==0:
1829: publications[nr-1][1].place+=1
1830: publications[nr][1].place-=1
1831: pass
1832: elif op=='down':
1833: publications=self.getPublications()
1834: for publication in publications:
1835: if publication[0]==pubName:
1836: nr=publications.index(publication)
1837: if not (nr==len(publications)-1):
1838: publications[nr+1][1].place-=1
1839: publications[nr][1].place+=1
1840: pass
1841:
1842:
1843: pt=PageTemplateFile(os.path.join(package_home(globals()),'zpt','MPIWGProject_managePublicationsForm.zpt')).__of__(self)
1844: return pt()
1845:
1846: def getPublications(self):
1847: """get all Publications"""
1848: def sort_images(x,y):
1849: return cmp(getattr(x[1],'place',0),getattr(y[1],'place',0))
1850:
1851: publications=self.ZopeFind(self,obj_metatypes=['MPIWGProject_publication'])
1852:
1853: publications.sort(sort_images)
1854: return publications
1855:
1856: def addPublication(self,text,RESPONSE=None):
1857: """add an MPIWG_Publication"""
1858:
1859: name="publication_"+str(self.getLastPublicationNumber()+1)
1860:
1861: newPublication=MPIWGProject_publication(name)
1862:
1863: self._setObject(name,newPublication)
1864: obj=getattr(self,name)
1865: obj.text=text[0:]
1866: obj.enabled=True;
1867: obj.place=self.getLastPublicationNumber()+1
1868: obj.id=name
1869:
1870: if RESPONSE is not None:
1871: RESPONSE.redirect('managePublications')
1872:
1873:
1874: def getLastPublicationNumber(self):
1875: publications=self.getPublications()
1876:
1877: if not publications:
1878: return 0
1879: else:
1880: return getattr(publications[-1][1],'place',0)
1881:
1882: def deletePublication(self,id,RESPONSE=None):
1883: """delete Publication id"""
1884: self.manage_delObjects([id])
1885: if RESPONSE:
1886: RESPONSE.redirect('managePublications')
1887:
1888: def getImages(self):
1889: """get all Images"""
1890:
1891: def sort_images(x,y):
1892: return cmp(getattr(x[1],'place',0),getattr(y[1],'place',0))
1893:
1894:
1895: if (getattr(self,'imageURL','')!='') or (getattr(self,'imagecap','')!='') :
1896: try:
1897: self.addImage(None,getattr(self,'imagecap',''),RESPONSE=None,filename=getattr(self,'imageURL',''))
1898: except:
1899: pass
1900: self.imageURL=''
1901: self.imagecap=''
1902:
1903: images=self.ZopeFind(self,obj_metatypes=['MPIWGProject_image'])
1904:
1905: images.sort(sort_images)
1906: return images
1907:
1908: def getLastImageNumber(self):
1909: images=self.getImages()
1910:
1911: if not images:
1912: return 0
1913: else:
1914: return getattr(images[-1][1],'place',0)
1915:
1916: def deleteImage(self,id,RESPONSE=None):
1917: """delete Image id"""
1918: self.manage_delObjects([id])
1919: if RESPONSE:
1920: RESPONSE.redirect('manageImages')
1921:
1922:
1923: def hasChildren(self,date=None,onlyActive=1,onlyArchived=1):
1924: """check if project has children"""
1925: ct=self.getContexts(childs=self.getContent('xdata_05'),
1926: depth=1,date=date,onlyActive=onlyActive)
1927:
1928: if ct and len(ct)>0:
1929: return True
1930: else:
1931: return False
1932:
1933:
1934: def addImage(self,fileHd,caption,RESPONSE=None,filename=None):
1935: """add an MPIWG_Project_image"""
1936:
1937: if not filename:
1938: filename=fileHd.filename
1939:
1940: if not fileHd:
1941: fileHd=file(os.path.join(package_home(globals()),'blank.gif'))
1942:
1943: newImage=MPIWGProject_image(filename,filename,fileHd)
1944:
1945: self._setObject(filename,newImage)
1946: obj=getattr(self,filename)
1947: obj.caption=caption[0:]
1948: obj.enabled=True;
1949: obj.place=self.getLastImageNumber()+1
1950: obj.id=filename
1951:
1952: if RESPONSE is not None:
1953: RESPONSE.redirect('manageImages')
1954:
1955: def PrincipiaSearchSource(self):
1956: """Return cataloguable key for ourselves."""
1957: return str(self)
1958:
1959: def versionHeader(self):
1960: """version Header, gibt header text entsprechend der aktuellen version aus"""
1961:
1962: actualTime=time.localtime()
1963: retTXT="""<h2>This is an outdated version, for the actual version please refer to <a href="%s">%s</a></h2>"""
1964: s=self.aq_parent.absolute_url()
1965: #print getattr(self,'archiveTime',actualTime)
1966: if getattr(self,'archiveTime',actualTime)< actualTime:
1967: return retTXT%(s,s)
1968: else:
1969: return ""
1970:
1971: def getActualVersion(self,date=None):
1972: """actuelle version"""
1973: def sortProjectsByTime(x,y):
1974: return cmp(x[1].archiveTime,y[1].archiveTime)
1975:
1976: if not date:
1977: if self.isActual():
1978: return self
1979: else:
1980: return None
1981:
1982: #suche ob aeltere versionen vorhanden sind
1983:
1984: finds=self.ZopeFind(self,obj_metatypes=['MPIWGProject'])
1985: if not finds: #wenn nicht dann teste ob die aktuelle version schon existiert hat.
1986: ad=getattr(self,'creationTime','20050101000000')
1987: if int(date)>int(ad):
1988: return self
1989: else:
1990: return None
1991:
1992:
1993: else:
1994: finds.sort(sortProjectsByTime)
1995:
1996: for find in finds:
1997: #gehe durch die alten Projekte und finde das entprechende
1998: if (int(find[1].archiveTime) > int(date)) and (int(date)>int(getattr(find[1],'creationTime','20050101000000'))):
1999: return find[1]
2000:
2001: #kein passendes gefunden, dann teste ob das aktuelle in frage kommt
2002: ad=getattr(self,'creationTime','20050101000000')
2003:
2004: if int(date)>int(ad):
2005:
2006: return self
2007: else:
2008: return None
2009:
2010:
2011: def isActual(self):
2012: """gibt 1 zurueck wenn aktuell, 0 sonst"""
2013: actualTime=time.localtime()
2014:
2015:
2016: #print getattr(self,'archiveTime',actualTime)
2017: if getattr(self,'archiveTime',actualTime)< actualTime:
2018: return 0
2019: else:
2020: return 1
2021:
2022: def copyObjectToArchive(self):
2023: """kopiere aktuelles objekt ins archiv"""
2024: cb=self.aq_parent.manage_copyObjects(self.getId())
2025: self.manage_pasteObjects(cb)
2026: actualTime=time.localtime()
2027:
2028: self.manage_renameObject(self.getId(),self.getId()+"_"+time.strftime("%Y%m%d%H%M%S",actualTime))
2029: obj=getattr(self,self.getId()+"_"+time.strftime("%Y%m%d%H%M%S",actualTime))
2030: obj.setArchiveTime(time.strftime("%Y%m%d%H%M%S",actualTime))
2031: ids=[x[0] for x in self.ZopeFind(obj,obj_metatypes=['MPIWGProject'])]
2032: obj.manage_delObjects(ids)
2033:
2034: def setArchiveTime(self,time):
2035: """set Archive Time"""
2036: self.archiveTime=time[0:]
2037:
2038: def versionManageForm(self):
2039: """version Manage form:currently only set to invisible"""
2040: pt=PageTemplateFile(os.path.join(package_home(globals()),'zpt','MPIWGProject_versionManageForm.zpt')).__of__(self)
2041: return pt()
2042:
2043: def versionManage(self,invisible=None,RESPONSE=None):
2044: """version Manage form:currently only set to invisible"""
2045: self.invisible=invisible
2046:
2047: if RESPONSE is not None:
2048: RESPONSE.redirect('manage_main')
2049:
2050:
2051: def crossLinker(self):
2052: """experimental crosslinker"""
2053: splitted=self.WEB_project_description[0].split()
2054: new=[]
2055: for split in splitted:
2056: try:
2057: found=self.DescriptionCatalog({'fulltext':split})
2058:
2059: if len(found)>1:
2060:
2061: new.append("<a href=%s>%s</a>"%(split,split))
2062: else:
2063: new.append(split)
2064: except:
2065: new.append(split)
2066: return string.join(new)
2067:
2068:
2069:
2070:
2071: def generateTemplate(self,RESPONSE=None):
2072: """Erzeuge Template fuer defined fields not_used"""
2073:
2074: id="index_html"
2075: title=id
2076: if self._getOb('index_html'):
2077: self._delObject('index_html')
2078:
2079:
2080: newObj=ZopePageTemplate(id,'TEXT')
2081: self._setObject(id,newObj)
2082: #self.manage_addPageTemplate(id,title)
2083: if RESPONSE is not None:
2084: RESPONSE.redirect('manage_main')
2085:
2086: def __init__(self, id, argv=None):
2087: """initiere classe"""
2088:
2089: self.creationTime=time.strftime("%Y%m%d%H%M%S",time.localtime())[0:]
2090: self.id=id
2091: self.title=id
2092: self.isActiveFlag=True #Flag is true is the project is still active, False if accomplished
2093:
2094: if argv:
2095: for arg in definedFields:
2096: try:
2097: setattr(self,arg,argv[arg])
2098: except:
2099: setattr(self,arg,"")
2100: else:
2101: for arg in definedFields:
2102: setattr(self,arg,'')
2103:
2104: manage_options = Folder.manage_options+(
2105: {'label':'Load New File','action':'loadNewFileForm'},
2106: {'label':'Edit ProjectInfo','action':'editMPIWGProjectForm'},
2107: {'label':'Edit BasisInfo','action':'editMPIWGBasisForm'},
2108: {'label':'Edit Publications','action':'editMPIWGRelatedPublicationsForm'},
2109: {'label':'Edit Themes & Disciplines','action':'editMPIWGDisciplinesThemesForm'},
2110: {'label':'Versionmanager','action':'versionManageForm'},
2111: )
2112:
2113:
2114: def isActiveProject(self):
2115: """check if the project is still active, default is true, set to false is the project is accomplished"""
2116: return getattr(self,'isActiveFlag',True)
2117:
2118: def isArchivedProject(self):
2119: """check if the project is archived"""
2120:
2121: completed=getattr(self,'completedAt',0)
2122:
2123: #completed leer
2124: if completed=="" :
2125: return False;
2126: if completed == 0:
2127: return False;
2128:
2129:
2130: return True
2131:
2132:
2133: def setActiveFlag(self,status=True):
2134: """set the active flag"""
2135: self.isActiveFlag=status
2136:
2137: def setCompletedAt(self,date):
2138: """set the date of completion, date should be in the form DD.MM.YYYY or MM.YYYY or YYYY"""
2139: logging.info("DATE:"+repr(date))
2140: transformedDate=self.transformDate(date);
2141: logging.info("transformed"+repr(transformedDate))
2142: if transformedDate is not None:
2143: setattr(self,"completedAt",transformedDate)
2144: return True;
2145: else:
2146: return False;
2147:
2148: def getCompletedAt(self):
2149: """gibt das transformierte Datum zurŸck"""
2150: date=getattr(self,'completedAt','')
2151: if date:
2152: return self.reTransformDate(date);
2153: else:
2154: return '';
2155:
2156: def reTransformDate(self,date):
2157: """transformiert , transformdate zurueck"""
2158: year=int(date/10000)
2159: month=int((date-year*10000)/100)
2160: day=int((date-year*10000-month*100))
2161: return """%s.%s.%s"""%(day,month,year);
2162:
2163:
2164: def transformDate(self,date):
2165: """transformiert ein Datum von DD.MM.YYYY, MM.YYYY,YYYY nach YYYYMMDD, alle nicht angebebenn Werte
2166: werden auf 0 gesetzt, es wird null zurŸckgegeben falls das Datum ungueltig ist"""
2167:
2168: if (date=="" ) :
2169: return "";
2170:
2171: if (date==None):
2172: return None;
2173:
2174: splitted=date.split(".")
2175: length=len(splitted)
2176: year=0
2177: month=0
2178: day=0
2179: if length > 3:
2180: return "";
2181: if length==3:
2182: day = int(splitted[0])
2183: if length>1:
2184: month=int(splitted[length-2])
2185:
2186: if length > 0:
2187: try:
2188: year = int(splitted[length-1])
2189: except:
2190: pass
2191:
2192: ## logging.info("month:"+(month))
2193: if not (0<=month<13):
2194: return None;
2195:
2196: if not(0<=day<32):
2197: return None;
2198:
2199: if (year>0) and (year<1900): #jahr nicht vierstellig eingegeben
2200: year=2000+year;
2201: return year*10000+month*100+day
2202:
2203:
2204:
2205: def checkDate(self,date):
2206: """teste ob zum Zeitpunkt date eine andere version existierte"""
2207:
2208:
2209: def sortProjectsByTime(x,y):
2210: return cmp(x[1].archiveTime,y[1].archiveTime)
2211:
2212: #suche ob aeltere versionen vorhanden sind
2213:
2214: finds=self.ZopeFind(self,obj_metatypes=['MPIWGProject'])
2215: if not finds: #wenn nicht dann teste ob die aktuelle version schon existiert hat.
2216: ad=getattr(self,'creationTime','20050101000000')
2217: if int(date)>int(ad):
2218: return self.REQUEST['URL1']+"/"+self.getId()
2219: else:
2220: return self.REQUEST['URL1']+"/no_project"
2221:
2222:
2223: else:
2224: finds.sort(sortProjectsByTime)
2225:
2226: for find in finds:
2227: #gehe durch die alten Projekte und finde das entprechende
2228: if (int(find[1].archiveTime) > int(date)) and (int(date)>int(getattr(find[1],'creationTime','20050101000000'))):
2229: return self.REQUEST['URL1']+"/"+find[1].getId()
2230:
2231: #kein passendes gefunden, dann teste ob das aktuelle in frage kommt
2232: ad=getattr(self,'creationTime','20050101000000')
2233:
2234: if int(date)>int(ad):
2235:
2236: return self.REQUEST['URL1']+"/"+self.getId()
2237: else:
2238: return self.REQUEST['URL1']+"/no_project"
2239:
2240:
2241: def no_project(self):
2242: """warnung: project noch nicht existent"""
2243: pt=PageTemplateFile(os.path.join(package_home(globals()),'zpt','no_project')).__of__(self)
2244: return pt()
2245:
2246: def getGetNeighbourhood(self,wordStr, length=100,tagging=True):
2247: """finde umgebung um die worte in wordStr, zurueckgegeben wird eine Array mit den Umgebungen von Fundstellen der Worte
2248: alle Tags werden entfernt, die Fundstellen werden mit <span class="found">XX</span> getaggt, die Umgebungen werden
2249: case insensitive gesucht
2250: @param wordStr: string mit Worten getrennt durch Leerzeichen, Phrasen sind mit " gekennzeichnet
2251: "eine phrase", "*" bezeichnet wildcards und wird ignoriert"
2252: @param length: optional, default wert 100, 2*length ist die groesse der Umgebung
2253: @param tagging: optional default wert true, kein span tag wird erzweugt falls tag=false
2254: """
2255:
2256: ret=[] # nimmt das Array auf, dass spaeter zurueckgegeben wird
2257: ranges=[] #Array mit tupeln x,y wobei x die Position des Anfang und y des Endes der i-ten Umgebung angiebt
2258:
2259: def isInRanges(nr,length):
2260: """test ob eine gegeben Position nr schon irgendwo in einer Umgebung ist, gibt den Index des ersten Wertes aus ranges zurueck,
2261: -1, wenn kein Treffer
2262:
2263: @param nr: Position die geprueft werden soll
2264: @param length: Laenge des Wortes das geprueft werden soll
2265: """
2266: for x in ranges:
2267: if (x[0]<=nr) and (nr < (x[1]-length)):
2268: return ranges.index(x)
2269: return -1
2270:
2271: # deal with phrases, in Phrasen werden die Leerzeichen durch "_" ersetzt.
2272: def rep_empty(str):
2273: x= re.sub(" ","_",str.group(0))
2274: return re.sub("\"","",x)
2275:
2276: wordStr=re.sub("\".*?\"", rep_empty,wordStr)#ersetze leerzeichen in " " durch "_" und loesche "
2277:
2278: #deal with wildcards, for our purposes it is enough to delete the wildcard
2279: wordStr=wordStr.replace("*","")
2280:
2281: words=wordStr.split(" ")
2282: #if not words is ListType:
2283: # words=[words]
2284:
2285: txt=self.harvest_page()
2286: if not txt:
2287: return ret
2288: txt=re.sub("<.*?>", "", txt) # loesche alle Tags
2289: for word in words:
2290: word=re.sub("_"," ",word) # ersetze zurueck "_" durch " "
2291: pos=0
2292:
2293: n=txt.lower().count(word.lower()) # wie oft tritt das Wort auf
2294:
2295: for i in range(n):
2296: pos=txt.lower().find(word.lower(),pos)
2297:
2298: if pos > 0:
2299: x=max(0,pos-length)
2300: y=min(len(txt),pos+length)
2301:
2302:
2303: #is word already in one of the results
2304: nr=isInRanges(pos,len(word))
2305: if nr >=0:# word ist in einer schon gefunden Umgebung, dann vergroessere diese
2306: x=min(ranges[nr][0],x)
2307: y=max(ranges[nr][1],y)
2308:
2309: str=txt[x:y]
2310:
2311: if nr >=0: # word ist in einer schon gefunden Umgebung
2312: ranges[nr]=(x,y) # neue Position der Umgebung
2313:
2314: ret[nr]=str # neue Umgebung
2315: else: # andernfalls neue Umgebung hinzufuegen
2316: ranges.append((x,y))
2317:
2318: ret.append(str)
2319:
2320: pos=pos+len(word)
2321: else:
2322: break;
2323:
2324: # now highlight everything
2325: if tagging:
2326: for x in range(len(ret)):
2327: for word in words:
2328: repl=re.compile(word,re.IGNORECASE)
2329: ret[x]=repl.sub(""" <span class="found">%s</span>"""%word.upper(),ret[x])
2330:
2331: return ret
2332:
2333: def harvest_page(self,context=None):
2334: """seite fuer harvesting fuer die Projektsuche"""
2335: if not context:
2336: context=self
2337:
2338: if self.isActiveProject() and self.isActual():
2339: ext=getattr(self,"harvest_main",None)
2340: if ext:
2341: return getattr(self,ext.getId())()
2342:
2343: pt=PageTemplateFile(os.path.join(package_home(globals()),'zpt','harvest_main')).__of__(context)
2344:
2345:
2346: return pt()
2347:
2348: def index_html(self,request=True,context=None):
2349: """show homepage"""
2350: if not context:
2351: context=self
2352: if request:
2353: if self.REQUEST.has_key('date') and self.REQUEST.SESSION.get('MPI_redirected',None)==None:
2354: self.REQUEST.SESSION['MPI_redirected']=1
2355: self.REQUEST.RESPONSE.redirect(self.checkDate(self.REQUEST['date'])+"?date="+self.REQUEST['date'])
2356: else:
2357: self.REQUEST.SESSION['MPI_redirected']=None
2358:
2359: #ext=self.ZopeFind(self.aq_parent,obj_ids=["project_main"])
2360: ext=getattr(self,"project_main",None)
2361: if ext:
2362: return getattr(self,ext.getId())()
2363:
2364: pt=PageTemplateFile(os.path.join(package_home(globals()),'zpt','project_main')).__of__(context)
2365:
2366: return pt()
2367:
2368:
2369: def getDataFields(self):
2370: """giveListofDatafields"""
2371: ret=[]
2372: for x in range(1,14):
2373: if not x in [6,10,9]: # not used fields
2374: ret.append('xdata_%02i'%x)
2375: return ret
2376:
2377: def getDefinedFields(self):
2378: """show all defined fields"""
2379:
2380: return definedFields
2381:
2382: def getAttribute(self,field):
2383: """get attrbiute"""
2384: return getattr(self,field)
2385:
2386: def getContent(self,field,filter=None):
2387: """Inhalt des Feldes"""
2388:
2389: text=u''
2390:
2391: for x in getattr(self,field):
2392:
2393: try:
2394: text +=x
2395: except:
2396: text = x
2397:
2398:
2399:
2400: try:
2401: if text[len(text)-1]==";":
2402: text=text[0:len(text)-1]
2403:
2404:
2405: except:
2406: pass
2407:
2408: if text=='':
2409: text2=text
2410: else:
2411: text2=re.sub(r';([^\s])','; \g<1>',text)
2412:
2413: #teste ob ergebnis leer und header dann nehme title
2414:
2415: if (text2=='') and (field=='WEB_project_header'):
2416: return self.getContent('WEB_title')
2417:
2418: if filter:
2419: splitted=text2.split("""<p class="picture">""")
2420: if len(splitted)>1:
2421: tmp=splitted[1].split("</p>")
2422: #return repr(splitted[1])
2423: try:
2424: self.imageURL=tmp[0].split("\"")[1].encode('utf-8')
2425: except:
2426: try:
2427: self.imageURL=tmp[0].split("src=")[1].split(" ")[0].encode('utf-8')
2428: except:
2429: self.imageURL=""
2430:
2431: split2="</p>".join(tmp[1:])
2432:
2433: text3=splitted[0]+split2
2434:
2435: splitted=text3.split("""<p class="picturetitle">""")
2436: if len(splitted)>1:
2437: tmp=splitted[1].split("</p>")
2438: self.imagecap=tmp[0].encode('utf-8')
2439:
2440: split4="".join(tmp[1:])
2441:
2442: text5=splitted[0]+split4
2443: else:
2444: #keine caption
2445: text5=text3
2446: else:
2447: #kein bild
2448: text5=text2
2449: else:
2450: text5=text2
2451:
2452: #teste ob WEB_project_description und keine fuehrenden p tags
2453: if (len(text5)>4) and (not text5[0:3]=='<p>') and (field=='WEB_project_description'):
2454: text5= "<p>"+text5+"</p>"
2455:
2456:
2457: #filter image
2458:
2459: text5=text5.lstrip().rstrip() #loescher leerzeichen und einzelndes br
2460: if (text5=="<br>") or (text5=="<br/>"):
2461: text5=""
2462:
2463: logging.debug("getcontent: field=%s filter=%s -> %s"%(field,filter,repr(text5)))
2464: #return unicodify(text5)
2465: return utf8ify(text5) # return as utf-8 byte string
2466:
2467:
2468: def showImagesOfPage(self,imageUrl=None):
2469: """show Images of project"""
2470: self.getContent('WEB_project_description',filter='yes') #get the content and store image infos into session
2471: pt=PageTemplateFile(os.path.join(package_home(globals()),'zpt','projectImageView.zpt')).__of__(self)
2472: return pt()
2473:
2474:
2475: def show_html(self):
2476: """simple index"""
2477: #return "HI"
2478: pt=PageTemplateFile(os.path.join(package_home(globals()),'zpt','MPIWGProject_index.zpt')).__of__(self)
2479: return pt()
2480:
2481: def saveFromPreview(self):
2482: """save content aus preview"""
2483: self.WEB_project_description=self.previewTemplate.WEB_project_description[0:]
2484: self.REQUEST.RESPONSE.redirect("./index.html")
2485:
2486: def saveEditedContent(self,kupu=None,preview=None):
2487: """save Edited content"""
2488:
2489: if preview:
2490: kupu=preview
2491: #find content of body tags
2492: start=kupu.find("<body>")
2493: end=kupu.find("</body>")
2494: newcontent= kupu[start+6:end]
2495:
2496: if preview:
2497:
2498: return self.preview(newcontent)
2499:
2500: self.copyObjectToArchive()
2501: self.WEB_project_description=newcontent[0:]
2502:
2503: self.REQUEST.RESPONSE.redirect("./index.html")
2504:
2505: return True
2506:
2507: security.declareProtected('View management screens','edit')
2508: def edit(self,western=None):
2509: """Edit pages"""
2510: if western:
2511: self.REQUEST.RESPONSE.setCookie("MP_debug_code","western",path="/")
2512:
2513:
2514: pt=PageTemplateFile(os.path.join(package_home(globals()),'zpt','edit_MPIWGProjectNeu.zpt')).__of__(self)
2515: return pt()
2516:
2517: edit_MPIWGProject_main = PageTemplateFile('zpt/edit_MPIWGProject_main', globals())
2518:
2519: def getPathStyle(self, path, selected, style=""):
2520: """returns a string with the given style + 'sel' if path == selected."""
2521:
2522: if path == selected:
2523: return style + 'sel'
2524: else:
2525: return style
2526:
2527: def preview(self,description):
2528: """preview"""
2529: tmpPro=getattr(self,"previewTemplate",None)
2530: if not tmpPro:
2531: tmpPro=MPIWGProject("previewTemplate")
2532: self._setObject("previewTemplate",tmpPro)
2533: for field in definedFields:
2534: setattr(tmpPro,field,getattr(self,field))
2535: tmpPro.WEB_project_description=description[0:]
2536: tmpPro.invisible=True
2537: pt=PageTemplateFile(os.path.join(package_home(globals()),'zpt','previewFrame.zpt')).__of__(self)
2538: return pt()
2539:
2540: #return self.REQUEST.RESPONSE.redirect(self.REQUEST['URL1']+"/previewTemplate")
2541:
2542:
2543: def getWebProject_description(self):
2544: """get description"""
2545: debug= self.REQUEST.cookies.get("MP_debug_code",None)
2546:
2547: if debug and debug=="western":
2548: return """
2549: <html>
2550: <head>
2551: <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
2552: </head>
2553: <body>%s
2554: </html></body>
2555: """%self.WEB_project_description[0]
2556:
2557: return """
2558: <html>
2559: <head>
2560: <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
2561: </head>
2562: <body>%s
2563: </html></body>
2564: """%self.getContent('WEB_project_description')
2565:
2566:
2567:
2568: def editMPIWGProjectForm(self):
2569: """editform"""
2570: pt=PageTemplateFile(os.path.join(package_home(globals()),'zpt','edit_MPIWGProject.zpt')).__of__(self)
2571: return pt()
2572:
2573:
2574: def editMPIWGProject(self,RESPONSE=None,fromEdit=None):
2575: """edit the project and archive the old version"""
2576:
2577: self.copyObjectToArchive() # archive the object
2578:
2579:
2580: for x in definedFields:
2581: if self.REQUEST.has_key(x):
2582:
2583: setattr(self,x,[self.REQUEST[x].decode('utf-8')])
2584:
2585:
2586: completedAt = self.REQUEST.get('completedAt')
2587: if not self.setCompletedAt(completedAt):
2588: RESPONSE.redirect('./editMPIWGBasisEditor?error="dateWrong')
2589:
2590: if self.REQUEST.has_key('historicalNames'):
2591: self.en.changeHistoricalNames(self.getId(),self.REQUEST['historicalNames'].split("\n"))
2592:
2593: if self.REQUEST.has_key('active'):
2594: self.setActiveFlag(True)
2595: else:
2596: self.setActiveFlag(False)
2597: if fromEdit and (RESPONSE is not None):
2598: RESPONSE.redirect('./editMPIWGBasisEditor')
2599:
2600: else:
2601: if RESPONSE is not None:
2602: RESPONSE.redirect('manage_main')
2603:
2604:
2605:
2606: security.declareProtected('View managment screens','editMPIWGDisciplinesThemesEditor')
2607: def editMPIWGDisciplinesThemesEditor(self):
2608: """edit from edit"""
2609: pt=PageTemplateFile(os.path.join(package_home(globals()),'zpt','edit_MPIWGDisciplinesThemesNeu.zpt')).__of__(self)
2610: return pt()
2611:
2612:
2613: def editMPIWGDisciplinesThemesForm(self):
2614: """edit the disciplines and themes Form"""
2615:
2616: pt=PageTemplateFile(os.path.join(package_home(globals()),'zpt','edit_MPIWGDisciplinesThemes.zpt')).__of__(self)
2617: return pt()
2618:
2619: def editMPIWGDisciplinesThemes(self,disciplines=None,themes=None,RESPONSE=None,fromEdit=None):
2620: """edit disciplin and form"""
2621: if disciplines:
2622: if type(disciplines) is StringType:
2623: self.xdata_09=disciplines
2624: else:
2625: self.xdata_09=string.join(disciplines,";")
2626: else:
2627: self.xdata_09=""
2628: if themes:
2629: if type(themes) is StringType:
2630: self.xdata_10=themes
2631: else:
2632: self.xdata_10=string.join(themes,";")
2633: else:
2634: self.xdata_10=""
2635:
2636: if fromEdit and (RESPONSE is not None):
2637: RESPONSE.redirect('./editMPIWGDisciplinesThemesEditor')
2638:
2639: else:
2640: if RESPONSE is not None:
2641: RESPONSE.redirect('manage_main')
2642:
2643:
2644: def isChecked(self,wert,list):
2645: """check if wert is in ; seperated list"""
2646:
2647: #felder sind manchmnal als liste mit einem element definiert
2648: if type(list) is StringType or UnicodeType:
2649: splitted=list.split(";")
2650: else:
2651: splitted=list[0].split(";")
2652:
2653: splitted=[y.rstrip().lstrip() for y in splitted]
2654:
2655: for x in splitted:
2656: x=re.sub(r"[^A-z ]","",x)
2657: if (not x==u'') and x in wert:
2658: return 1
2659: return 0
2660:
2661: security.declareProtected('View management screens','editMPIWGBasisEditor')
2662: def editMPIWGBasisEditor(self):
2663: """editform"""
2664: pt=PageTemplateFile(os.path.join(package_home(globals()),'zpt','edit_MPIWGBasisNeu.zpt')).__of__(self)
2665: return pt()
2666:
2667: security.declareProtected('View management screens','editMPIWGBasisForm')
2668: def editMPIWGBasisForm(self):
2669: """editform"""
2670: pt=PageTemplateFile(os.path.join(package_home(globals()),'zpt','edit_MPIWGBasis.zpt')).__of__(self)
2671: return pt()
2672:
2673: security.declareProtected('View management screens','editMPIWGRelatedPublicationsForm')
2674: def editMPIWGRelatedPublicationsForm(self):
2675: """Edit related Publications"""
2676: pt=PageTemplateFile(os.path.join(package_home(globals()),'zpt','edit_MPIWGRelatedPublications.zpt')).__of__(self)
2677: return pt()
2678:
2679:
2680: def loadNewFileForm(self):
2681: """Neues XML-File einlesen"""
2682: pt=PageTemplateFile(os.path.join(package_home(globals()),'zpt','MPIWGProject_newfile.zpt')).__of__(self)
2683: return pt()
2684:
2685: def loadNewFile(self,RESPONSE=None):
2686: """einlesen des neuen files"""
2687: fileupload=self.REQUEST['fileupload']
2688: if fileupload:
2689: file_name=fileupload.filename
2690: filedata=fileupload.read()
2691:
2692: argv=xmlhelper.proj2hash(filedata)
2693: #print argv.keys()
2694: for arg in definedFields:
2695:
2696: #print arg,argv[arg],getattr(self,arg)
2697: try:
2698: temp=argv[arg][0:]
2699: #old=getattr(self,arg)
2700: setattr(self,arg,temp)
2701: #print old,getattr(self,arg)
2702: except:
2703: """nothing"""
2704:
2705: if RESPONSE is not None:
2706: RESPONSE.redirect('manage_main')
2707:
2708: def manage_addMPIWGProjectForm(self):
2709: """form for adding the project"""
2710: pt=PageTemplateFile(os.path.join(package_home(globals()),'zpt','addMPIWGProjectForm.zpt')).__of__(self)
2711: return pt()
2712:
2713: def manage_addMPIWGProject(self,id,RESPONSE=None):
2714: """method to add a project"""
2715: #print argv
2716: fileupload=self.REQUEST.get('fileupload',None)
2717: if fileupload:
2718:
2719: file_name=fileupload.filename
2720: filedata=fileupload.read()
2721:
2722: argv=xmlhelper.proj2hash(filedata)
2723:
2724: #print argv
2725: newObj=MPIWGProject(id,argv)
2726: else:
2727: newObj=MPIWGProject(id)
2728:
2729: self._setObject(id,newObj)
2730:
2731:
2732: if RESPONSE is not None:
2733: RESPONSE.redirect('manage_main')
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>
![[BACK]](/cvs/cvsweb/icons/back.gif){kind=icon}
Return to MPIWGProjects.py CVS log ![[TXT]](/cvs/cvsweb/icons/text.gif){kind=icon}
![[DIR]](/cvs/cvsweb/icons/dir.gif){kind=icon}
Up to [Repository] / MPIWGWeb