# HG changeset patch
# User dwinter
# Date 1367332317 -7200
# Node ID e718d9a72f19ea783a080e9f44530238a0ca7b9a
# Parent  f59bdd5f489095571fe74f5fa6bcb1177ed5d28b
bibliographie funktionen

diff -r f59bdd5f4890 -r e718d9a72f19 MPIWGProjects.py
--- a/MPIWGProjects.py	Mon Apr 29 16:02:24 2013 +0200
+++ b/MPIWGProjects.py	Tue Apr 30 16:31:57 2013 +0200
@@ -1935,7 +1935,9 @@
     # cached HashTree with project hierarchy
     _v_projectTree = None
 
-
+    
+   
+                    
     def getProjectTree(self):
         """Return the project hierarchy tree (and cache it).
         
@@ -2084,6 +2086,7 @@
         return "updated %s projects!" % cnt
                 
 
+      
         
 def manage_addMPIWGProjectFolderForm(self):
     """form for adding a MPIWGProjectFolder"""
diff -r f59bdd5f4890 -r e718d9a72f19 MPIWGRoot.py
--- a/MPIWGRoot.py	Mon Apr 29 16:02:24 2013 +0200
+++ b/MPIWGRoot.py	Tue Apr 30 16:31:57 2013 +0200
@@ -1314,6 +1314,30 @@
         
         logging.debug(ret)
         return ret
+    
+    
+    def getAllProjectPublications(self):
+            """get all publications"""
+            fw=file("/tmp/allProjectPublications","w")
+            projects =self.projects.getProjectsAsList(None,active=0,archived=0)
+           
+            for project in projects:
+                logging.debug(project)
+                if hasattr(project,'publicationList'):
+                    try:
+                        x =project.publicationList.bibliolist.data
+                    
+                    except:
+                        logging.error("Can't do: %s"%project.absolute_url())
+                        continue
+                
+                    id=project.getId()
+                    for l in x.split("\n"):
+                        fw.write("%s,%s\n"%(id,l))
+                    fw.flush()
+                
+            fw.close()
+                
         
             
 def manage_addMPIWGRootForm(self):
diff -r f59bdd5f4890 -r e718d9a72f19 MPIWGStaff.py
--- a/MPIWGStaff.py	Mon Apr 29 16:02:24 2013 +0200
+++ b/MPIWGStaff.py	Tue Apr 30 16:31:57 2013 +0200
@@ -1609,6 +1609,7 @@
             
             pubs=[]
             for selPub in selPubs:
+                logging.debug("searchFor:%s"%selPub.escidocid)
                 pubs.append((selPub.escidocid,self.mpiwgPubman.getEntryFromPubman(selPub.escidocid)))
                 
             return pubs
@@ -1712,7 +1713,7 @@
         """hole publications aus der datenbank"""
     
     
-        query="select * from pubmanbiblio where key_main = %s order by priority"
+        query="select * from pubmanbiblio where lower(key_main) = lower(%s) order by priority DESC"
             
            
         return self.executeZSQL(query,[self.getKey()])