Mercurial > hg > MPIWGWeb

changeset 53:e718d9a72f19

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
bibliographie funktionen
author dwinter
date Tue, 30 Apr 2013 16:31:57 +0200
parents f59bdd5f4890
children 4600e31a0431
files MPIWGProjects.py MPIWGRoot.py MPIWGStaff.py
diffstat 3 files changed, 30 insertions(+), 2 deletions(-) [+]
line wrap: on
line diff
--- 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"""
--- 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):
--- 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()])