[Treebase-guts] SF.net SVN: treebase:[836] trunk/treebase-core/src/main/java/org/cipres/ treebase/dao/study/StudyDAO.java

[<rv...@us...>]

Revision: 836
          http://treebase.svn.sourceforge.net/treebase/?rev=836&view=rev
Author:   rvos
Date:     2011-05-12 12:03:54 +0000 (Thu, 12 May 2011)

Log Message:
-----------
implemented findByPublicationDateRange

Modified Paths:
--------------
    trunk/treebase-core/src/main/java/org/cipres/treebase/dao/study/StudyDAO.java

Modified: trunk/treebase-core/src/main/java/org/cipres/treebase/dao/study/StudyDAO.java
===================================================================
--- trunk/treebase-core/src/main/java/org/cipres/treebase/dao/study/StudyDAO.java	2011-05-12 12:03:04 UTC (rev 835)
+++ trunk/treebase-core/src/main/java/org/cipres/treebase/dao/study/StudyDAO.java	2011-05-12 12:03:54 UTC (rev 836)
@@ -3,6 +3,7 @@
 
 import java.util.ArrayList;
 import java.util.Collection;
+import java.util.Date;
 import java.util.HashSet;
 import java.util.List;
 import java.util.Set;
@@ -12,6 +13,7 @@
 import org.cipres.treebase.dao.AbstractDAO;
 import org.cipres.treebase.domain.admin.Person;
 import org.cipres.treebase.domain.admin.User;
+import org.cipres.treebase.domain.study.Citation;
 import org.cipres.treebase.domain.study.Study;
 import org.cipres.treebase.domain.study.StudyCriteria;
 import org.cipres.treebase.domain.study.StudyHome;
@@ -399,5 +401,18 @@
 		return studies;
 	}
 
+	public Collection<Study> findByPublicationDateRange(Date from, Date until) {
+		Query q = getSession().createQuery(
+		"from Citation where publishyear between :begin and :end");
+		q.setInteger("begin", from.getYear());
+		q.setInteger("end", until.getYear());
+		Collection<Citation> citations = q.list();
+		Set<Study> results = new HashSet<Study>();
+		for ( Citation citation : citations ) {
+			results.add(citation.getStudy());
+		}
+		return results;
+	}
 
+
 }


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.