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: if not((splitted[1]==" Christoph") and (splitted[0]=="Hoffmann") and (str(x.WEB_title).find('Einstein')>0)):
1391: proj2.append(x)
1392:
1393: else:
1394: proj2=[]
1395:
1396: proj=self.ProjectCatalog({'xdata_08':search})
1397: if proj:
1398: names=[x.WEB_title for x in proj]
1399: for x in proj:
1400:
1401: if (not x.WEB_title in names) and (getattr(x.getObject(),'archiveTime','')==''):
1402: proj2.append(x)
1403:
1404:
1405: proj2.sort(sortP)
1406:
1407: projectListe=[]
1408:
1409: for proj in proj2:
1410: obj=proj.getObject()
1411: if onlyArchived==1: #nur aktuell projecte
1412: if not obj.isArchivedProject():
1413: projectListe.append(proj)
1414: elif onlyArchived==2: #nur archivierte
1415: if obj.isArchivedProject():
1416: projectListe.append(proj)
1417: else: #alle
1418: projectListe.append(proj)
1419:
1420:
1421:
1422: if len(projectListe)>0:
1423: ret.append((name,projectListe))
1424:
1425: return ret
1426:
1427: def givePersonList(self,name):
1428: """check if person is in personfolder and return list of person objects"""
1429:
1430: splitted=name.split(",")
1431: if len(splitted)==1:
1432: splitted=name.lstrip().rstrip().split(" ")
1433: splittedNew=[split.lstrip() for split in splitted]
1434:
1435: if splittedNew[0]=='':
1436: del splittedNew[0]
1437: search=string.join(splittedNew,' AND ')
1438:
1439: if not search=='':
1440: proj=self.MembersCatalog({'title':search})
1441:
1442: if proj:
1443: return [[x.lastName,x.firstName] for x in proj]
1444: else:
1445: return []
1446:
1447: ## splitted=name.split(",") # version nachname, vorname...
1448: ## if len(splitted)>1:
1449: ## lastName=splitted[0]
1450: ## firstName=splitted[1]
1451: ## else:
1452: ## splitted=name.split(" ") #version vorname irgenwas nachnamae
1453:
1454: ## lastName=splitted[len(splitted)-1]
1455: ## firstName=string.join(splitted[0:len(splitted)-1])
1456:
1457: ## objs=[]
1458:
1459: #print self.members
1460: ## for x in self.members.__dict__:
1461: ## obj=getattr(self.members,x)
1462: ## if hasattr(obj,'lastName') and hasattr(obj,'firstName'):
1463:
1464: ## if (re.match(".*"+obj.lastName+".*",lastName) or re.match(".*"+lastName+".*",obj.lastName)) and (re.match(".*"+obj.firstName+".*",firstName) or re.match(".*"+firstName+".*",obj.firstName)):
1465:
1466: ## objs.append((obj,lastName+", "+firstName))
1467:
1468:
1469: ## return objs
1470:
1471:
1472: def personCheck(self,names):
1473: """all persons for list"""
1474: #print "names",names
1475: splitted=names.split(";")
1476: ret={}
1477: for name in splitted:
1478:
1479: if not (name==""):
1480: try:
1481: ret[name]=self.givePersonList(name)
1482: except:
1483: """NOTHIHN"""
1484: #print "RET",ret
1485: return ret
1486:
1487: def giveCheckList(self,person,fieldname):
1488: """return checklist"""
1489: #print "GCL",fieldname
1490: if fieldname=='xdata_01':
1491: x=self.personCheck(person.getContent(fieldname))
1492: #print "GCLBACKX",x
1493: return x
1494:
1495:
1496: def isCheckField(self,fieldname):
1497: """return chechfield"""
1498:
1499: return (fieldname in checkFields)
1500:
1501:
1502: def generateNameIndex(self):
1503: """erzeuge einen index verwendeter personen"""
1504: import psycopg
1505: o = psycopg.connect('dbname=authorities user=dwinter password=3333',serialize=0)
1506: results={}
1507: print self.fulltext.historicalNames.items()
1508: for nameItem in self.fulltext.historicalNames.items(): #gehe durch alle namen des lexikons
1509:
1510: c = o.cursor()
1511: name=nameItem[0]
1512: print "check",name
1513: c.execute("select lastname,firstname from persons where lower(lastname) = '%s'"%quote(name))
1514: tmpres=c.fetchall()
1515: firstnames=[result[1] for result in tmpres] # find all firstnames
1516: if tmpres:
1517: lastname=tmpres[0][0]
1518:
1519: for found in self.fulltext({'names':name}):
1520: if found.getObject().isActual():
1521: for nh in found.getObject().getGetNeighbourhood(name, length=50,tagging=False): #hole umgebung
1522: #schaue nun ob der vorname hinter oder vor dem name ist
1523: position=nh.find(lastname)
1524: # vorher
1525: #print "NH",nh
1526: bevorS=nh[0:position].split()
1527: #print "BV",bevorS
1528: if len(bevorS)>1:
1529: try:
1530: bevor=[bevorS[-1],bevorS[-2]]
1531: except:
1532: bevor=[bevorS[0]]
1533: else:
1534: bevor=[]
1535: #nachher
1536: behindS= re.split("[,|;| ]",nh[position:])
1537: #print "BH",behindS
1538: if len(behindS)>2:
1539: try:
1540: behind=behindS[1:3]
1541: except:
1542: behind=[bevorS[1]]
1543: else:
1544: behind=[]
1545: for firstname in firstnames:
1546: if firstname in bevor+behind: #Namen wie mit Adelspraedikaten werden so erstmal nich gefunden
1547: id="%s,%s"%(lastname,firstname)
1548: if not results.has_key(id):
1549: results[id]=[]
1550: objId=found.getObject().getId()
1551: if not (objId in results[id]):
1552: print "d %s for %s"%(id,objId)
1553: results[id].append(objId)
1554: self.nameIndex=results
1555: return results
1556:
1557: def editNameIndexHTML(self):
1558: """edit the name index"""
1559: if not hasattr(self,'nameIndexEdited'): # falls editierter index noch nicht existiert, kopiere automatisch erstellten
1560: self.nameIndexEdited=copy.copy(self.nameIndex)
1561: print "huh"
1562: #self.nameIndexEdited=copy.copy(self.nameIndex)
1563: #print self.nameIndexEdited
1564: pt=PageTemplateFile(os.path.join(package_home(globals()),'zpt','editHistoricalNames.zpt')).__of__(self)
1565: return pt()
1566:
1567: def getNamesInProject(self,projectId):
1568: """get all names ofnameIndexEdited which are references in projec with projectId"""
1569:
1570: ret=[]
1571: for name in self.nameIndexEdited.keys():
1572: if projectId in self.nameIndexEdited[name]:
1573: ret.append(name)
1574:
1575: return ret
1576:
1577: def editNameIndex(self,RESPONSE=None,name=None,occurrances=None,submit=None):
1578: """edit the index"""
1579: nI=self.nameIndexEdited # mI introduced to make sure that changes to nameIndexEdited are know to ZODB
1580: if submit=="delete":
1581:
1582:
1583: dh=getattr(self,'deletedHistoricalNames',{})
1584:
1585: if type(dh) is ListType:
1586: dh={}
1587: if not dh.has_key(name):
1588: dh[name]=occurrances.split("\n")
1589: else:
1590: dh[name]+=occurrances.split("\n")
1591:
1592: self.deletedHistoricalNames=dh
1593:
1594: del self.nameIndexEdited[name]
1595:
1596:
1597: elif (submit=="change"):
1598:
1599: nI[name]=occurrances.split("\n")[0:]
1600:
1601: elif (submit=="add"):
1602: if not nI.has_key(name):
1603: nI[name]=occurrances.split("\n")
1604: else:
1605: nI[name]+=occurrances.split("\n")
1606:
1607: self.nameIndexEdited=nI
1608:
1609:
1610: if RESPONSE is not None:
1611: RESPONSE.redirect('editNameIndexHTML')
1612:
1613:
1614:
1615: def restoreIndex(self):
1616: """restore"""
1617: self.nameIndexEdited=self.nameIndex
1618: return "done"
1619:
1620:
1621:
1622: def manage_addMPIWGRootForm(self):
1623: """form for adding the root"""
1624: pt=PageTemplateFile(os.path.join(package_home(globals()),'zpt','addMPIWGRootForm.zpt')).__of__(self)
1625: return pt()
1626:
1627: def manage_addMPIWGRoot(self,id,title,connection_id="",RESPONSE=None):
1628: """add a root folder"""
1629: newObj=MPIWGRoot(id,title)
1630: self._setObject(id,newObj)
1631: ob=getattr(self,id)
1632: setattr(ob,'connection_id',connection_id)
1633: if RESPONSE is not None:
1634: RESPONSE.redirect('manage_main')
1635:
1636:
1637: class MPIWGProject_publication(SimpleItem):
1638: """publications object fuer project"""
1639:
1640: meta_type="MPIWGProject_publication"
1641:
1642: def editPublication(self,text=None,RESPONSE=None):
1643: """edit a publication"""
1644:
1645: if (not text):
1646: pt=PageTemplateFile(os.path.join(package_home(globals()),'zpt','edit_publicationForm.zpt')).__of__(self)
1647: return pt()
1648:
1649:
1650: self.text=text[0:]
1651:
1652: if RESPONSE:
1653: RESPONSE.redirect("../managePublications")
1654:
1655: class MPIWGProject_image(Image):
1656: """Images for Projects"""
1657:
1658: meta_type="MPIWGProject_image"
1659:
1660: def showImage(self,imageUrl=None):
1661: """show Images at an extra page"""
1662: self.getContent('WEB_project_description',filter='yes') #get the content and store image infos into session
1663: pt=PageTemplateFile(os.path.join(package_home(globals()),'zpt','projectImageView.zpt')).__of__(self)
1664: return pt()
1665:
1666: def editImage(self,file=None,caption=None,RESPONSE=None):
1667: """edit the Image"""
1668: if (not file) and (not caption):
1669: pt=PageTemplateFile(os.path.join(package_home(globals()),'zpt','edit_imageForm.zpt')).__of__(self)
1670: return pt()
1671:
1672: if file and (not file.filename.lstrip().rstrip()==""):
1673: self.manage_upload(file)
1674:
1675: if caption:
1676: self.caption=caption[0:]
1677:
1678: if RESPONSE:
1679: RESPONSE.redirect("../manageImages")
1680:
1681: class MPIWGProject(CatalogAware,Folder):
1682: """Class for Projects"""
1683:
1684:
1685: security=ClassSecurityInfo()
1686: meta_type='MPIWGProject'
1687: default_catalog='ProjectCatalog'
1688:
1689: def decode(self,str):
1690: """return unicode object"""
1691: return unicodify(str)
1692:
1693: def sortedByPlace(self,metatype):
1694: """find metatype and sort by place"""
1695: def sort(x,y):
1696: return cmp(getattr(x[1],'place',0),getattr(y[1],'place',0))
1697:
1698: founds=self.ZopeFind(self,obj_metatypes=[metatype]);
1699:
1700: founds.sort(sort)
1701:
1702: return founds
1703:
1704:
1705: def copyPublicationsToList(self,RESPONSE=None):
1706: """copy publications in to list"""
1707:
1708: publicationTxt=self.getContent('WEB_related_pub')
1709:
1710: pubSplits=publicationTxt.split("<p>")
1711:
1712: for pubSplit in pubSplits:
1713: pubSplit=pubSplit.replace("</p>","")
1714: self.addPublication(pubSplit)
1715:
1716: if RESPONSE:
1717: RESPONSE.redirect('managePublications')
1718:
1719:
1720: def copyImageToMargin(self,RESPONSE=None):
1721: """copy inline images to marginal images"""
1722:
1723:
1724: #getImages from WEB_project_description
1725: description=self.getContent('WEB_project_description')
1726:
1727: text2=description
1728: splitted=text2.split("""<p class="picture">""")
1729:
1730: imageURLs=[]
1731: imageCaptions=[]
1732: for split in splitted[1:]:
1733: tmp=split.split("</p>")
1734: #return repr(splitted[1])
1735:
1736: try:
1737: imageURLs.append(tmp[0].split("\"")[1].encode('utf-8'))
1738: except:
1739:
1740: try:
1741: imageURLs.append(tmp[0].split("src=")[1].split(" ")[0].encode('utf-8'))
1742: except:
1743: imageURLs.append("")
1744:
1745: split2="</p>".join(tmp[1:])
1746:
1747:
1748: splitted=split2.split("""<p class="picturetitle">""")
1749: if len(splitted)>1:
1750: tmp=splitted[1].split("</p>")
1751: imageCaptions.append(tmp[0].encode('utf-8'))
1752:
1753:
1754: else:
1755: #keine caption
1756:
1757: imageCaptions.append("")
1758:
1759:
1760: #eintragen:
1761: for imageURL in imageURLs:
1762: filename=imageURL.split("/")[-1]
1763: #lege neues images object an, mit leerem bild
1764:
1765: if self.ZopeFind(self,obj_ids=[filename]):
1766: #existiert das bild schon, dann neuen filenamen
1767: filename="project_image_"+filename
1768:
1769: self.addImage(None,imageCaptions[imageURLs.index(imageURL)],filename=filename)
1770: #hole die bilddaten aus der url
1771: url=self.absolute_url()+"/"+imageURL
1772: #url=self.absolute_url()+"/"+filename
1773:
1774: try:#relative url
1775: data=urllib.urlopen(url).read()
1776: except:
1777: try:#absolute
1778: data=urllib.urlopen(self.imageURL).read()
1779: except:
1780: logger("MPIWG Project",logging.ERROR,"can't open: %s"%url)
1781:
1782: obj=getattr(self,filename)
1783: obj.update_data(data)
1784:
1785: if RESPONSE:
1786: RESPONSE.redirect('manageImages')
1787:
1788: def manageImages(self,imageName=None,op=None):
1789: """managage images"""
1790:
1791:
1792: if imageName and op:
1793: if op=='up':
1794: images=self.getImages()
1795: for image in images:
1796: if image[0]==imageName:
1797: nr=images.index(image)
1798: if not nr==0:
1799: images[nr-1][1].place+=1
1800: images[nr][1].place-=1
1801: pass
1802: elif op=='down':
1803: images=self.getImages()
1804: for image in images:
1805: if image[0]==imageName:
1806: nr=images.index(image)
1807: if not (nr==len(images)-1):
1808: images[nr+1][1].place-=1
1809: images[nr][1].place+=1
1810: pass
1811:
1812:
1813: pt=PageTemplateFile(os.path.join(package_home(globals()),'zpt','MPIWGProject_manageImagesForm.zpt')).__of__(self)
1814: return pt()
1815:
1816: def managePublications(self,pubName=None,op=None):
1817: """managage images"""
1818:
1819:
1820: if pubName and op:
1821: if op=='up':
1822: publications=self.getPublications()
1823: for publication in publications:
1824: if publication[0]==pubName:
1825: nr=publications.index(publication)
1826: if not nr==0:
1827: publications[nr-1][1].place+=1
1828: publications[nr][1].place-=1
1829: pass
1830: elif op=='down':
1831: publications=self.getPublications()
1832: for publication in publications:
1833: if publication[0]==pubName:
1834: nr=publications.index(publication)
1835: if not (nr==len(publications)-1):
1836: publications[nr+1][1].place-=1
1837: publications[nr][1].place+=1
1838: pass
1839:
1840:
1841: pt=PageTemplateFile(os.path.join(package_home(globals()),'zpt','MPIWGProject_managePublicationsForm.zpt')).__of__(self)
1842: return pt()
1843:
1844: def getPublications(self):
1845: """get all Publications"""
1846: def sort_images(x,y):
1847: return cmp(getattr(x[1],'place',0),getattr(y[1],'place',0))
1848:
1849: publications=self.ZopeFind(self,obj_metatypes=['MPIWGProject_publication'])
1850:
1851: publications.sort(sort_images)
1852: return publications
1853:
1854: def addPublication(self,text,RESPONSE=None):
1855: """add an MPIWG_Publication"""
1856:
1857: name="publication_"+str(self.getLastPublicationNumber()+1)
1858:
1859: newPublication=MPIWGProject_publication(name)
1860:
1861: self._setObject(name,newPublication)
1862: obj=getattr(self,name)
1863: obj.text=text[0:]
1864: obj.enabled=True;
1865: obj.place=self.getLastPublicationNumber()+1
1866: obj.id=name
1867:
1868: if RESPONSE is not None:
1869: RESPONSE.redirect('managePublications')
1870:
1871:
1872: def getLastPublicationNumber(self):
1873: publications=self.getPublications()
1874:
1875: if not publications:
1876: return 0
1877: else:
1878: return getattr(publications[-1][1],'place',0)
1879:
1880: def deletePublication(self,id,RESPONSE=None):
1881: """delete Publication id"""
1882: self.manage_delObjects([id])
1883: if RESPONSE:
1884: RESPONSE.redirect('managePublications')
1885:
1886: def getImages(self):
1887: """get all Images"""
1888:
1889: def sort_images(x,y):
1890: return cmp(getattr(x[1],'place',0),getattr(y[1],'place',0))
1891:
1892:
1893: if (getattr(self,'imageURL','')!='') or (getattr(self,'imagecap','')!='') :
1894: try:
1895: self.addImage(None,getattr(self,'imagecap',''),RESPONSE=None,filename=getattr(self,'imageURL',''))
1896: except:
1897: pass
1898: self.imageURL=''
1899: self.imagecap=''
1900:
1901: images=self.ZopeFind(self,obj_metatypes=['MPIWGProject_image'])
1902:
1903: images.sort(sort_images)
1904: return images
1905:
1906: def getLastImageNumber(self):
1907: images=self.getImages()
1908:
1909: if not images:
1910: return 0
1911: else:
1912: return getattr(images[-1][1],'place',0)
1913:
1914: def deleteImage(self,id,RESPONSE=None):
1915: """delete Image id"""
1916: self.manage_delObjects([id])
1917: if RESPONSE:
1918: RESPONSE.redirect('manageImages')
1919:
1920:
1921: def hasChildren(self,date=None,onlyActive=1,onlyArchived=1):
1922: """check if project has children"""
1923: ct=self.getContexts(childs=self.getContent('xdata_05'),
1924: depth=1,date=date,onlyActive=onlyActive)
1925:
1926: if ct and len(ct)>0:
1927: return True
1928: else:
1929: return False
1930:
1931:
1932: def addImage(self,fileHd,caption,RESPONSE=None,filename=None):
1933: """add an MPIWG_Project_image"""
1934:
1935: if not filename:
1936: filename=fileHd.filename
1937:
1938: if not fileHd:
1939: fileHd=file(os.path.join(package_home(globals()),'blank.gif'))
1940:
1941: newImage=MPIWGProject_image(filename,filename,fileHd)
1942:
1943: self._setObject(filename,newImage)
1944: obj=getattr(self,filename)
1945: obj.caption=caption[0:]
1946: obj.enabled=True;
1947: obj.place=self.getLastImageNumber()+1
1948: obj.id=filename
1949:
1950: if RESPONSE is not None:
1951: RESPONSE.redirect('manageImages')
1952:
1953: def PrincipiaSearchSource(self):
1954: """Return cataloguable key for ourselves."""
1955: return str(self)
1956:
1957: def versionHeader(self):
1958: """version Header, gibt header text entsprechend der aktuellen version aus"""
1959:
1960: actualTime=time.localtime()
1961: retTXT="""<h2>This is an outdated version, for the actual version please refer to <a href="%s">%s</a></h2>"""
1962: s=self.aq_parent.absolute_url()
1963: #print getattr(self,'archiveTime',actualTime)
1964: if getattr(self,'archiveTime',actualTime)< actualTime:
1965: return retTXT%(s,s)
1966: else:
1967: return ""
1968:
1969: def getActualVersion(self,date=None):
1970: """actuelle version"""
1971: def sortProjectsByTime(x,y):
1972: return cmp(x[1].archiveTime,y[1].archiveTime)
1973:
1974: if not date:
1975: if self.isActual():
1976: return self
1977: else:
1978: return None
1979:
1980: #suche ob aeltere versionen vorhanden sind
1981:
1982: finds=self.ZopeFind(self,obj_metatypes=['MPIWGProject'])
1983: if not finds: #wenn nicht dann teste ob die aktuelle version schon existiert hat.
1984: ad=getattr(self,'creationTime','20050101000000')
1985: if int(date)>int(ad):
1986: return self
1987: else:
1988: return None
1989:
1990:
1991: else:
1992: finds.sort(sortProjectsByTime)
1993:
1994: for find in finds:
1995: #gehe durch die alten Projekte und finde das entprechende
1996: if (int(find[1].archiveTime) > int(date)) and (int(date)>int(getattr(find[1],'creationTime','20050101000000'))):
1997: return find[1]
1998:
1999: #kein passendes gefunden, dann teste ob das aktuelle in frage kommt
2000: ad=getattr(self,'creationTime','20050101000000')
2001:
2002: if int(date)>int(ad):
2003:
2004: return self
2005: else:
2006: return None
2007:
2008:
2009: def isActual(self):
2010: """gibt 1 zurueck wenn aktuell, 0 sonst"""
2011: actualTime=time.localtime()
2012:
2013:
2014: #print getattr(self,'archiveTime',actualTime)
2015: if getattr(self,'archiveTime',actualTime)< actualTime:
2016: return 0
2017: else:
2018: return 1
2019:
2020: def copyObjectToArchive(self):
2021: """kopiere aktuelles objekt ins archiv"""
2022: cb=self.aq_parent.manage_copyObjects(self.getId())
2023: self.manage_pasteObjects(cb)
2024: actualTime=time.localtime()
2025:
2026: self.manage_renameObject(self.getId(),self.getId()+"_"+time.strftime("%Y%m%d%H%M%S",actualTime))
2027: obj=getattr(self,self.getId()+"_"+time.strftime("%Y%m%d%H%M%S",actualTime))
2028: obj.setArchiveTime(time.strftime("%Y%m%d%H%M%S",actualTime))
2029: ids=[x[0] for x in self.ZopeFind(obj,obj_metatypes=['MPIWGProject'])]
2030: obj.manage_delObjects(ids)
2031:
2032: def setArchiveTime(self,time):
2033: """set Archive Time"""
2034: self.archiveTime=time[0:]
2035:
2036: def versionManageForm(self):
2037: """version Manage form:currently only set to invisible"""
2038: pt=PageTemplateFile(os.path.join(package_home(globals()),'zpt','MPIWGProject_versionManageForm.zpt')).__of__(self)
2039: return pt()
2040:
2041: def versionManage(self,invisible=None,RESPONSE=None):
2042: """version Manage form:currently only set to invisible"""
2043: self.invisible=invisible
2044:
2045: if RESPONSE is not None:
2046: RESPONSE.redirect('manage_main')
2047:
2048:
2049: def crossLinker(self):
2050: """experimental crosslinker"""
2051: splitted=self.WEB_project_description[0].split()
2052: new=[]
2053: for split in splitted:
2054: try:
2055: found=self.DescriptionCatalog({'fulltext':split})
2056:
2057: if len(found)>1:
2058:
2059: new.append("<a href=%s>%s</a>"%(split,split))
2060: else:
2061: new.append(split)
2062: except:
2063: new.append(split)
2064: return string.join(new)
2065:
2066:
2067:
2068:
2069: def generateTemplate(self,RESPONSE=None):
2070: """Erzeuge Template fuer defined fields not_used"""
2071:
2072: id="index_html"
2073: title=id
2074: if self._getOb('index_html'):
2075: self._delObject('index_html')
2076:
2077:
2078: newObj=ZopePageTemplate(id,'TEXT')
2079: self._setObject(id,newObj)
2080: #self.manage_addPageTemplate(id,title)
2081: if RESPONSE is not None:
2082: RESPONSE.redirect('manage_main')
2083:
2084: def __init__(self, id, argv=None):
2085: """initiere classe"""
2086:
2087: self.creationTime=time.strftime("%Y%m%d%H%M%S",time.localtime())[0:]
2088: self.id=id
2089: self.title=id
2090: self.isActiveFlag=True #Flag is true is the project is still active, False if accomplished
2091:
2092: if argv:
2093: for arg in definedFields:
2094: try:
2095: setattr(self,arg,argv[arg])
2096: except:
2097: setattr(self,arg,"")
2098: else:
2099: for arg in definedFields:
2100: setattr(self,arg,'')
2101:
2102: manage_options = Folder.manage_options+(
2103: {'label':'Load New File','action':'loadNewFileForm'},
2104: {'label':'Edit ProjectInfo','action':'editMPIWGProjectForm'},
2105: {'label':'Edit BasisInfo','action':'editMPIWGBasisForm'},
2106: {'label':'Edit Publications','action':'editMPIWGRelatedPublicationsForm'},
2107: {'label':'Edit Themes & Disciplines','action':'editMPIWGDisciplinesThemesForm'},
2108: {'label':'Versionmanager','action':'versionManageForm'},
2109: )
2110:
2111:
2112: def isActiveProject(self):
2113: """check if the project is still active, default is true, set to false is the project is accomplished"""
2114: return getattr(self,'isActiveFlag',True)
2115:
2116: def isArchivedProject(self):
2117: """check if the project is archived"""
2118:
2119: completed=getattr(self,'completedAt',0)
2120:
2121: #completed leer
2122: if completed=="" :
2123: return False;
2124: if completed == 0:
2125: return False;
2126:
2127:
2128: return True
2129:
2130:
2131: def setActiveFlag(self,status=True):
2132: """set the active flag"""
2133: self.isActiveFlag=status
2134:
2135: def setCompletedAt(self,date):
2136: """set the date of completion, date should be in the form DD.MM.YYYY or MM.YYYY or YYYY"""
2137: logging.info("DATE:"+repr(date))
2138: transformedDate=self.transformDate(date);
2139: logging.info("transformed"+repr(transformedDate))
2140: if transformedDate is not None:
2141: setattr(self,"completedAt",transformedDate)
2142: return True;
2143: else:
2144: return False;
2145:
2146: def getCompletedAt(self):
2147: """gibt das transformierte Datum zurŸck"""
2148: date=getattr(self,'completedAt','')
2149: if date:
2150: return self.reTransformDate(date);
2151: else:
2152: return '';
2153:
2154: def reTransformDate(self,date):
2155: """transformiert , transformdate zurueck"""
2156: year=int(date/10000)
2157: month=int((date-year*10000)/100)
2158: day=int((date-year*10000-month*100))
2159: return """%s.%s.%s"""%(day,month,year);
2160:
2161:
2162: def transformDate(self,date):
2163: """transformiert ein Datum von DD.MM.YYYY, MM.YYYY,YYYY nach YYYYMMDD, alle nicht angebebenn Werte
2164: werden auf 0 gesetzt, es wird null zurŸckgegeben falls das Datum ungueltig ist"""
2165:
2166: if (date=="" ) :
2167: return "";
2168:
2169: if (date==None):
2170: return None;
2171:
2172: splitted=date.split(".")
2173: length=len(splitted)
2174: year=0
2175: month=0
2176: day=0
2177: if length > 3:
2178: return "";
2179: if length==3:
2180: day = int(splitted[0])
2181: if length>1:
2182: month=int(splitted[length-2])
2183:
2184: if length > 0:
2185: try:
2186: year = int(splitted[length-1])
2187: except:
2188: pass
2189:
2190: ## logging.info("month:"+(month))
2191: if not (0<=month<13):
2192: return None;
2193:
2194: if not(0<=day<32):
2195: return None;
2196:
2197: if (year>0) and (year<1900): #jahr nicht vierstellig eingegeben
2198: year=2000+year;
2199: return year*10000+month*100+day
2200:
2201:
2202:
2203: def checkDate(self,date):
2204: """teste ob zum Zeitpunkt date eine andere version existierte"""
2205:
2206:
2207: def sortProjectsByTime(x,y):
2208: return cmp(x[1].archiveTime,y[1].archiveTime)
2209:
2210: #suche ob aeltere versionen vorhanden sind
2211:
2212: finds=self.ZopeFind(self,obj_metatypes=['MPIWGProject'])
2213: if not finds: #wenn nicht dann teste ob die aktuelle version schon existiert hat.
2214: ad=getattr(self,'creationTime','20050101000000')
2215: if int(date)>int(ad):
2216: return self.REQUEST['URL1']+"/"+self.getId()
2217: else:
2218: return self.REQUEST['URL1']+"/no_project"
2219:
2220:
2221: else:
2222: finds.sort(sortProjectsByTime)
2223:
2224: for find in finds:
2225: #gehe durch die alten Projekte und finde das entprechende
2226: if (int(find[1].archiveTime) > int(date)) and (int(date)>int(getattr(find[1],'creationTime','20050101000000'))):
2227: return self.REQUEST['URL1']+"/"+find[1].getId()
2228:
2229: #kein passendes gefunden, dann teste ob das aktuelle in frage kommt
2230: ad=getattr(self,'creationTime','20050101000000')
2231:
2232: if int(date)>int(ad):
2233:
2234: return self.REQUEST['URL1']+"/"+self.getId()
2235: else:
2236: return self.REQUEST['URL1']+"/no_project"
2237:
2238:
2239: def no_project(self):
2240: """warnung: project noch nicht existent"""
2241: pt=PageTemplateFile(os.path.join(package_home(globals()),'zpt','no_project')).__of__(self)
2242: return pt()
2243:
2244: def getGetNeighbourhood(self,wordStr, length=100,tagging=True):
2245: """finde umgebung um die worte in wordStr, zurueckgegeben wird eine Array mit den Umgebungen von Fundstellen der Worte
2246: alle Tags werden entfernt, die Fundstellen werden mit <span class="found">XX</span> getaggt, die Umgebungen werden
2247: case insensitive gesucht
2248: @param wordStr: string mit Worten getrennt durch Leerzeichen, Phrasen sind mit " gekennzeichnet
2249: "eine phrase", "*" bezeichnet wildcards und wird ignoriert"
2250: @param length: optional, default wert 100, 2*length ist die groesse der Umgebung
2251: @param tagging: optional default wert true, kein span tag wird erzweugt falls tag=false
2252: """
2253:
2254: ret=[] # nimmt das Array auf, dass spaeter zurueckgegeben wird
2255: ranges=[] #Array mit tupeln x,y wobei x die Position des Anfang und y des Endes der i-ten Umgebung angiebt
2256:
2257: def isInRanges(nr,length):
2258: """test ob eine gegeben Position nr schon irgendwo in einer Umgebung ist, gibt den Index des ersten Wertes aus ranges zurueck,
2259: -1, wenn kein Treffer
2260:
2261: @param nr: Position die geprueft werden soll
2262: @param length: Laenge des Wortes das geprueft werden soll
2263: """
2264: for x in ranges:
2265: if (x[0]<=nr) and (nr < (x[1]-length)):
2266: return ranges.index(x)
2267: return -1
2268:
2269: # deal with phrases, in Phrasen werden die Leerzeichen durch "_" ersetzt.
2270: def rep_empty(str):
2271: x= re.sub(" ","_",str.group(0))
2272: return re.sub("\"","",x)
2273:
2274: wordStr=re.sub("\".*?\"", rep_empty,wordStr)#ersetze leerzeichen in " " durch "_" und loesche "
2275:
2276: #deal with wildcards, for our purposes it is enough to delete the wildcard
2277: wordStr=wordStr.replace("*","")
2278:
2279: words=wordStr.split(" ")
2280: #if not words is ListType:
2281: # words=[words]
2282:
2283: txt=self.harvest_page()
2284: if not txt:
2285: return ret
2286: txt=re.sub("<.*?>", "", txt) # loesche alle Tags
2287: for word in words:
2288: word=re.sub("_"," ",word) # ersetze zurueck "_" durch " "
2289: pos=0
2290:
2291: n=txt.lower().count(word.lower()) # wie oft tritt das Wort auf
2292:
2293: for i in range(n):
2294: pos=txt.lower().find(word.lower(),pos)
2295:
2296: if pos > 0:
2297: x=max(0,pos-length)
2298: y=min(len(txt),pos+length)
2299:
2300:
2301: #is word already in one of the results
2302: nr=isInRanges(pos,len(word))
2303: if nr >=0:# word ist in einer schon gefunden Umgebung, dann vergroessere diese
2304: x=min(ranges[nr][0],x)
2305: y=max(ranges[nr][1],y)
2306:
2307: str=txt[x:y]
2308:
2309: if nr >=0: # word ist in einer schon gefunden Umgebung
2310: ranges[nr]=(x,y) # neue Position der Umgebung
2311:
2312: ret[nr]=str # neue Umgebung
2313: else: # andernfalls neue Umgebung hinzufuegen
2314: ranges.append((x,y))
2315:
2316: ret.append(str)
2317:
2318: pos=pos+len(word)
2319: else:
2320: break;
2321:
2322: # now highlight everything
2323: if tagging:
2324: for x in range(len(ret)):
2325: for word in words:
2326: repl=re.compile(word,re.IGNORECASE)
2327: ret[x]=repl.sub(""" <span class="found">%s</span>"""%word.upper(),ret[x])
2328:
2329: return ret
2330:
2331: def harvest_page(self,context=None):
2332: """seite fuer harvesting fuer die Projektsuche"""
2333: if not context:
2334: context=self
2335:
2336: if self.isActiveProject() and self.isActual():
2337: ext=getattr(self,"harvest_main",None)
2338: if ext:
2339: return getattr(self,ext.getId())()
2340:
2341: pt=PageTemplateFile(os.path.join(package_home(globals()),'zpt','harvest_main')).__of__(context)
2342:
2343:
2344: return pt()
2345:
2346: def index_html(self,request=True,context=None):
2347: """show homepage"""
2348: if not context:
2349: context=self
2350: if request:
2351: if self.REQUEST.has_key('date') and self.REQUEST.SESSION.get('MPI_redirected',None)==None:
2352: self.REQUEST.SESSION['MPI_redirected']=1
2353: self.REQUEST.RESPONSE.redirect(self.checkDate(self.REQUEST['date'])+"?date="+self.REQUEST['date'])
2354: else:
2355: self.REQUEST.SESSION['MPI_redirected']=None
2356:
2357: #ext=self.ZopeFind(self.aq_parent,obj_ids=["project_main"])
2358: ext=getattr(self,"project_main",None)
2359: if ext:
2360: return getattr(self,ext.getId())()
2361:
2362: pt=PageTemplateFile(os.path.join(package_home(globals()),'zpt','project_main')).__of__(context)
2363:
2364: return pt()
2365:
2366:
2367: def getDataFields(self):
2368: """giveListofDatafields"""
2369: ret=[]
2370: for x in range(1,14):
2371: if not x in [6,10,9]: # not used fields
2372: ret.append('xdata_%02i'%x)
2373: return ret
2374:
2375: def getDefinedFields(self):
2376: """show all defined fields"""
2377:
2378: return definedFields
2379:
2380: def getAttribute(self,field):
2381: """get attrbiute"""
2382: return getattr(self,field)
2383:
2384: def getContent(self,field,filter=None):
2385: """Inhalt des Feldes"""
2386:
2387: text=u''
2388:
2389: for x in getattr(self,field):
2390:
2391: try:
2392: text +=x
2393: except:
2394: text = x
2395:
2396:
2397:
2398: try:
2399: if text[len(text)-1]==";":
2400: text=text[0:len(text)-1]
2401:
2402:
2403: except:
2404: pass
2405:
2406: if text=='':
2407: text2=text
2408: else:
2409: text2=re.sub(r';([^\s])','; \g<1>',text)
2410:
2411: #teste ob ergebnis leer und header dann nehme title
2412:
2413: if (text2=='') and (field=='WEB_project_header'):
2414: return self.getContent('WEB_title')
2415:
2416: if filter:
2417: splitted=text2.split("""<p class="picture">""")
2418: if len(splitted)>1:
2419: tmp=splitted[1].split("</p>")
2420: #return repr(splitted[1])
2421: try:
2422: self.imageURL=tmp[0].split("\"")[1].encode('utf-8')
2423: except:
2424: try:
2425: self.imageURL=tmp[0].split("src=")[1].split(" ")[0].encode('utf-8')
2426: except:
2427: self.imageURL=""
2428:
2429: split2="</p>".join(tmp[1:])
2430:
2431: text3=splitted[0]+split2
2432:
2433: splitted=text3.split("""<p class="picturetitle">""")
2434: if len(splitted)>1:
2435: tmp=splitted[1].split("</p>")
2436: self.imagecap=tmp[0].encode('utf-8')
2437:
2438: split4="".join(tmp[1:])
2439:
2440: text5=splitted[0]+split4
2441: else:
2442: #keine caption
2443: text5=text3
2444: else:
2445: #kein bild
2446: text5=text2
2447: else:
2448: text5=text2
2449:
2450: #teste ob WEB_project_description und keine fuehrenden p tags
2451: if (len(text5)>4) and (not text5[0:3]=='<p>') and (field=='WEB_project_description'):
2452: text5= "<p>"+text5+"</p>"
2453:
2454:
2455: #filter image
2456:
2457: text5=text5.lstrip().rstrip() #loescher leerzeichen und einzelndes br
2458: if (text5=="<br>") or (text5=="<br/>"):
2459: text5=""
2460:
2461: logging.debug("getcontent: field=%s filter=%s -> %s"%(field,filter,repr(text5)))
2462: #return unicodify(text5)
2463: return utf8ify(text5) # return as utf-8 byte string
2464:
2465:
2466: def showImagesOfPage(self,imageUrl=None):
2467: """show Images of project"""
2468: self.getContent('WEB_project_description',filter='yes') #get the content and store image infos into session
2469: pt=PageTemplateFile(os.path.join(package_home(globals()),'zpt','projectImageView.zpt')).__of__(self)
2470: return pt()
2471:
2472:
2473: def show_html(self):
2474: """simple index"""
2475: #return "HI"
2476: pt=PageTemplateFile(os.path.join(package_home(globals()),'zpt','MPIWGProject_index.zpt')).__of__(self)
2477: return pt()
2478:
2479: def saveFromPreview(self):
2480: """save content aus preview"""
2481: self.WEB_project_description=self.previewTemplate.WEB_project_description[0:]
2482: self.REQUEST.RESPONSE.redirect("./index.html")
2483:
2484: def saveEditedContent(self,kupu=None,preview=None):
2485: """save Edited content"""
2486:
2487: if preview:
2488: kupu=preview
2489: #find content of body tags
2490: start=kupu.find("<body>")
2491: end=kupu.find("</body>")
2492: newcontent= kupu[start+6:end]
2493:
2494: if preview:
2495:
2496: return self.preview(newcontent)
2497:
2498: self.copyObjectToArchive()
2499: self.WEB_project_description=newcontent[0:]
2500:
2501: self.REQUEST.RESPONSE.redirect("./index.html")
2502:
2503: return True
2504:
2505: security.declareProtected('View management screens','edit')
2506: def edit(self,western=None):
2507: """Edit pages"""
2508: if western:
2509: self.REQUEST.RESPONSE.setCookie("MP_debug_code","western",path="/")
2510:
2511:
2512: pt=PageTemplateFile(os.path.join(package_home(globals()),'zpt','edit_MPIWGProjectNeu.zpt')).__of__(self)
2513: return pt()
2514:
2515: edit_MPIWGProject_main = PageTemplateFile('zpt/edit_MPIWGProject_main', globals())
2516:
2517: def getPathStyle(self, path, selected, style=""):
2518: """returns a string with the given style + 'sel' if path == selected."""
2519:
2520: if path == selected:
2521: return style + 'sel'
2522: else:
2523: return style
2524:
2525: def preview(self,description):
2526: """preview"""
2527: tmpPro=getattr(self,"previewTemplate",None)
2528: if not tmpPro:
2529: tmpPro=MPIWGProject("previewTemplate")
2530: self._setObject("previewTemplate",tmpPro)
2531: for field in definedFields:
2532: setattr(tmpPro,field,getattr(self,field))
2533: tmpPro.WEB_project_description=description[0:]
2534: tmpPro.invisible=True
2535: pt=PageTemplateFile(os.path.join(package_home(globals()),'zpt','previewFrame.zpt')).__of__(self)
2536: return pt()
2537:
2538: #return self.REQUEST.RESPONSE.redirect(self.REQUEST['URL1']+"/previewTemplate")
2539:
2540:
2541: def getWebProject_description(self):
2542: """get description"""
2543: debug= self.REQUEST.cookies.get("MP_debug_code",None)
2544:
2545: if debug and debug=="western":
2546: return """
2547: <html>
2548: <head>
2549: <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
2550: </head>
2551: <body>%s
2552: </html></body>
2553: """%self.WEB_project_description[0]
2554:
2555: return """
2556: <html>
2557: <head>
2558: <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
2559: </head>
2560: <body>%s
2561: </html></body>
2562: """%self.getContent('WEB_project_description')
2563:
2564:
2565:
2566: def editMPIWGProjectForm(self):
2567: """editform"""
2568: pt=PageTemplateFile(os.path.join(package_home(globals()),'zpt','edit_MPIWGProject.zpt')).__of__(self)
2569: return pt()
2570:
2571:
2572: def editMPIWGProject(self,RESPONSE=None,fromEdit=None):
2573: """edit the project and archive the old version"""
2574:
2575: self.copyObjectToArchive() # archive the object
2576:
2577:
2578: for x in definedFields:
2579: if self.REQUEST.has_key(x):
2580:
2581: setattr(self,x,[self.REQUEST[x].decode('utf-8')])
2582:
2583:
2584: completedAt = self.REQUEST.get('completedAt')
2585: if not self.setCompletedAt(completedAt):
2586: RESPONSE.redirect('./editMPIWGBasisEditor?error="dateWrong')
2587:
2588: if self.REQUEST.has_key('historicalNames'):
2589: self.en.changeHistoricalNames(self.getId(),self.REQUEST['historicalNames'].split("\n"))
2590:
2591: if self.REQUEST.has_key('active'):
2592: self.setActiveFlag(True)
2593: else:
2594: self.setActiveFlag(False)
2595: if fromEdit and (RESPONSE is not None):
2596: RESPONSE.redirect('./editMPIWGBasisEditor')
2597:
2598: else:
2599: if RESPONSE is not None:
2600: RESPONSE.redirect('manage_main')
2601:
2602:
2603:
2604: security.declareProtected('View managment screens','editMPIWGDisciplinesThemesEditor')
2605: def editMPIWGDisciplinesThemesEditor(self):
2606: """edit from edit"""
2607: pt=PageTemplateFile(os.path.join(package_home(globals()),'zpt','edit_MPIWGDisciplinesThemesNeu.zpt')).__of__(self)
2608: return pt()
2609:
2610:
2611: def editMPIWGDisciplinesThemesForm(self):
2612: """edit the disciplines and themes Form"""
2613:
2614: pt=PageTemplateFile(os.path.join(package_home(globals()),'zpt','edit_MPIWGDisciplinesThemes.zpt')).__of__(self)
2615: return pt()
2616:
2617: def editMPIWGDisciplinesThemes(self,disciplines=None,themes=None,RESPONSE=None,fromEdit=None):
2618: """edit disciplin and form"""
2619: if disciplines:
2620: if type(disciplines) is StringType:
2621: self.xdata_09=disciplines
2622: else:
2623: self.xdata_09=string.join(disciplines,";")
2624: else:
2625: self.xdata_09=""
2626: if themes:
2627: if type(themes) is StringType:
2628: self.xdata_10=themes
2629: else:
2630: self.xdata_10=string.join(themes,";")
2631: else:
2632: self.xdata_10=""
2633:
2634: if fromEdit and (RESPONSE is not None):
2635: RESPONSE.redirect('./editMPIWGDisciplinesThemesEditor')
2636:
2637: else:
2638: if RESPONSE is not None:
2639: RESPONSE.redirect('manage_main')
2640:
2641:
2642: def isChecked(self,wert,list):
2643: """check if wert is in ; seperated list"""
2644:
2645: #felder sind manchmnal als liste mit einem element definiert
2646: if type(list) is StringType or UnicodeType:
2647: splitted=list.split(";")
2648: else:
2649: splitted=list[0].split(";")
2650:
2651: splitted=[y.rstrip().lstrip() for y in splitted]
2652:
2653: for x in splitted:
2654: x=re.sub(r"[^A-z ]","",x)
2655: if (not x==u'') and x in wert:
2656: return 1
2657: return 0
2658:
2659: security.declareProtected('View management screens','editMPIWGBasisEditor')
2660: def editMPIWGBasisEditor(self):
2661: """editform"""
2662: pt=PageTemplateFile(os.path.join(package_home(globals()),'zpt','edit_MPIWGBasisNeu.zpt')).__of__(self)
2663: return pt()
2664:
2665: security.declareProtected('View management screens','editMPIWGBasisForm')
2666: def editMPIWGBasisForm(self):
2667: """editform"""
2668: pt=PageTemplateFile(os.path.join(package_home(globals()),'zpt','edit_MPIWGBasis.zpt')).__of__(self)
2669: return pt()
2670:
2671: security.declareProtected('View management screens','editMPIWGRelatedPublicationsForm')
2672: def editMPIWGRelatedPublicationsForm(self):
2673: """Edit related Publications"""
2674: pt=PageTemplateFile(os.path.join(package_home(globals()),'zpt','edit_MPIWGRelatedPublications.zpt')).__of__(self)
2675: return pt()
2676:
2677:
2678: def loadNewFileForm(self):
2679: """Neues XML-File einlesen"""
2680: pt=PageTemplateFile(os.path.join(package_home(globals()),'zpt','MPIWGProject_newfile.zpt')).__of__(self)
2681: return pt()
2682:
2683: def loadNewFile(self,RESPONSE=None):
2684: """einlesen des neuen files"""
2685: fileupload=self.REQUEST['fileupload']
2686: if fileupload:
2687: file_name=fileupload.filename
2688: filedata=fileupload.read()
2689:
2690: argv=xmlhelper.proj2hash(filedata)
2691: #print argv.keys()
2692: for arg in definedFields:
2693:
2694: #print arg,argv[arg],getattr(self,arg)
2695: try:
2696: temp=argv[arg][0:]
2697: #old=getattr(self,arg)
2698: setattr(self,arg,temp)
2699: #print old,getattr(self,arg)
2700: except:
2701: """nothing"""
2702:
2703: if RESPONSE is not None:
2704: RESPONSE.redirect('manage_main')
2705:
2706: def manage_addMPIWGProjectForm(self):
2707: """form for adding the project"""
2708: pt=PageTemplateFile(os.path.join(package_home(globals()),'zpt','addMPIWGProjectForm.zpt')).__of__(self)
2709: return pt()
2710:
2711: def manage_addMPIWGProject(self,id,RESPONSE=None):
2712: """method to add a project"""
2713: #print argv
2714: fileupload=self.REQUEST.get('fileupload',None)
2715: if fileupload:
2716:
2717: file_name=fileupload.filename
2718: filedata=fileupload.read()
2719:
2720: argv=xmlhelper.proj2hash(filedata)
2721:
2722: #print argv
2723: newObj=MPIWGProject(id,argv)
2724: else:
2725: newObj=MPIWGProject(id)
2726:
2727: self._setObject(id,newObj)
2728:
2729:
2730: if RESPONSE is not None:
2731: RESPONSE.redirect('manage_main')
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>