Index: lams_tool_sbmt/src/java/org/lamsfoundation/lams/tool/sbmt/dao/ISubmitFilesSessionDAO.java =================================================================== diff -u -rb496f01cb0de2c2968b080bced80c36ce24bb323 -r837aa6d15c08f6d4b1cd80b7b4cc3d56e494c9ed --- lams_tool_sbmt/src/java/org/lamsfoundation/lams/tool/sbmt/dao/ISubmitFilesSessionDAO.java (.../ISubmitFilesSessionDAO.java) (revision b496f01cb0de2c2968b080bced80c36ce24bb323) +++ lams_tool_sbmt/src/java/org/lamsfoundation/lams/tool/sbmt/dao/ISubmitFilesSessionDAO.java (.../ISubmitFilesSessionDAO.java) (revision 837aa6d15c08f6d4b1cd80b7b4cc3d56e494c9ed) @@ -6,6 +6,8 @@ */ package org.lamsfoundation.lams.tool.sbmt.dao; +import java.util.List; + import org.lamsfoundation.lams.learningdesign.dao.IBaseDAO; import org.lamsfoundation.lams.tool.sbmt.SubmitFilesSession; @@ -28,5 +30,5 @@ */ public void createSession(SubmitFilesSession submitSession); - + public List getSubmitFilesSessionByContentID(Long contentID); } Index: lams_tool_sbmt/src/java/org/lamsfoundation/lams/tool/sbmt/dao/hibernate/SubmitFilesSessionDAO.java =================================================================== diff -u -rb496f01cb0de2c2968b080bced80c36ce24bb323 -r837aa6d15c08f6d4b1cd80b7b4cc3d56e494c9ed --- lams_tool_sbmt/src/java/org/lamsfoundation/lams/tool/sbmt/dao/hibernate/SubmitFilesSessionDAO.java (.../SubmitFilesSessionDAO.java) (revision b496f01cb0de2c2968b080bced80c36ce24bb323) +++ lams_tool_sbmt/src/java/org/lamsfoundation/lams/tool/sbmt/dao/hibernate/SubmitFilesSessionDAO.java (.../SubmitFilesSessionDAO.java) (revision 837aa6d15c08f6d4b1cd80b7b4cc3d56e494c9ed) @@ -6,6 +6,8 @@ */ package org.lamsfoundation.lams.tool.sbmt.dao.hibernate; +import java.util.List; + import org.lamsfoundation.lams.learningdesign.dao.hibernate.BaseDAO; import org.lamsfoundation.lams.tool.sbmt.SubmitFilesSession; import org.lamsfoundation.lams.tool.sbmt.dao.ISubmitFilesSessionDAO; @@ -16,6 +18,11 @@ public class SubmitFilesSessionDAO extends BaseDAO implements ISubmitFilesSessionDAO { + private static final String FIND_LEARNER_BY_CONTENT_ID = + " from SubmitFilesSession session " + + " where session.content.contentID = :contentID"; + + /** * (non-Javadoc) * @see org.lamsfoundation.lams.tool.sbmt.dao.ISubmitFilesSessionDAO#getSessionByID(java.lang.Long) @@ -30,5 +37,14 @@ public void createSession(SubmitFilesSession submitSession) { this.getHibernateTemplate().save(submitSession); } + + public List getSubmitFilesSessionByContentID(Long contentID){ + if ( contentID != null ) { + return this.getSession().createQuery(FIND_LEARNER_BY_CONTENT_ID) + .setLong("contentID", contentID.longValue()) + .list(); + } + return null; + } } Index: lams_tool_sbmt/src/java/org/lamsfoundation/lams/tool/sbmt/service/ISubmitFilesService.java =================================================================== diff -u -rc6b6b6b37a75598d144929e5757c4270d704141f -r837aa6d15c08f6d4b1cd80b7b4cc3d56e494c9ed --- lams_tool_sbmt/src/java/org/lamsfoundation/lams/tool/sbmt/service/ISubmitFilesService.java (.../ISubmitFilesService.java) (revision c6b6b6b37a75598d144929e5757c4270d704141f) +++ lams_tool_sbmt/src/java/org/lamsfoundation/lams/tool/sbmt/service/ISubmitFilesService.java (.../ISubmitFilesService.java) (revision 837aa6d15c08f6d4b1cd80b7b4cc3d56e494c9ed) @@ -193,4 +193,12 @@ * @return the default content id */ public Long getToolDefaultContentIdBySignature(String toolSignature); + + /** + * This method retrieves a list of SubmitFileSession from the contentID. + * @param contentID + * @return a list of SubmitFileSession + */ + //public List getSubmitFilesSessionsByContentID(Long contentID); + public List getSubmitFilesSessionByContentID(Long contentID); } Index: lams_tool_sbmt/src/java/org/lamsfoundation/lams/tool/sbmt/service/SubmitFilesService.java =================================================================== diff -u -rc6b6b6b37a75598d144929e5757c4270d704141f -r837aa6d15c08f6d4b1cd80b7b4cc3d56e494c9ed --- lams_tool_sbmt/src/java/org/lamsfoundation/lams/tool/sbmt/service/SubmitFilesService.java (.../SubmitFilesService.java) (revision c6b6b6b37a75598d144929e5757c4270d704141f) +++ lams_tool_sbmt/src/java/org/lamsfoundation/lams/tool/sbmt/service/SubmitFilesService.java (.../SubmitFilesService.java) (revision 837aa6d15c08f6d4b1cd80b7b4cc3d56e494c9ed) @@ -825,4 +825,11 @@ return content; } + + public List getSubmitFilesSessionByContentID(Long contentID) { + List learners = submitFilesSessionDAO.getSubmitFilesSessionByContentID(contentID); + if(learners == null) + learners = new ArrayList(); //return sized 0 list rather than null value + return learners; + } } \ No newline at end of file