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