Index: lams_tool_daco/src/java/org/lamsfoundation/lams/tool/daco/dao/DacoAnswerDAO.java =================================================================== RCS file: /usr/local/cvsroot/lams_tool_daco/src/java/org/lamsfoundation/lams/tool/daco/dao/DacoAnswerDAO.java,v diff -u -r1.6 -r1.7 --- lams_tool_daco/src/java/org/lamsfoundation/lams/tool/daco/dao/DacoAnswerDAO.java 14 Nov 2008 04:05:26 -0000 1.6 +++ lams_tool_daco/src/java/org/lamsfoundation/lams/tool/daco/dao/DacoAnswerDAO.java 8 Nov 2010 11:52:49 -0000 1.7 @@ -17,13 +17,11 @@ List getQuestionSummaries(Long userUid, List blankSummary); /** - * Gets the number of records in the group. + * Gets the number of records entered by user. * * @param sessionId * session ID of the group - * @return number of records in that group + * @return number of records for that user */ - Integer getGroupRecordCount(Long sessionId); - Integer getUserRecordCount(Long userId, Long sessionId); } \ No newline at end of file Index: lams_tool_daco/src/java/org/lamsfoundation/lams/tool/daco/dao/hibernate/DacoAnswerDAOHibernate.java =================================================================== RCS file: /usr/local/cvsroot/lams_tool_daco/src/java/org/lamsfoundation/lams/tool/daco/dao/hibernate/DacoAnswerDAOHibernate.java,v diff -u -r1.7 -r1.8 --- lams_tool_daco/src/java/org/lamsfoundation/lams/tool/daco/dao/hibernate/DacoAnswerDAOHibernate.java 2 Dec 2009 06:02:02 -0000 1.7 +++ lams_tool_daco/src/java/org/lamsfoundation/lams/tool/daco/dao/hibernate/DacoAnswerDAOHibernate.java 8 Nov 2010 11:52:49 -0000 1.8 @@ -39,9 +39,6 @@ private static final String FIND_ANSWER_COUNT = "SELECT COUNT(*) FROM " + DacoAnswer.class.getName() + " AS a WHERE a.question.uid=? AND a.answer IS NOT NULL"; - private static final String FIND_TOTAL_RECORD_COUNT = "SELECT COUNT (DISTINCT a.recordId) FROM " - + DacoAnswer.class.getName() + " AS a WHERE a.user.session.sessionId=?"; - private static final String FIND_USER_RECORD_COUNT = "SELECT COUNT (DISTINCT a.recordId) FROM " + DacoAnswer.class.getName() + " AS a WHERE a.user.userId=:userId AND a.user.session.sessionId=:sessionId"; @@ -157,11 +154,6 @@ return row; } - public Integer getGroupRecordCount(Long sessionId) { - return ((Number) getHibernateTemplate().find(DacoAnswerDAOHibernate.FIND_TOTAL_RECORD_COUNT, sessionId).get(0)) - .intValue(); - } - public Integer getUserRecordCount(Long userId, Long sessionId) { return ((Number) getHibernateTemplate().findByNamedParam(DacoAnswerDAOHibernate.FIND_USER_RECORD_COUNT, new String[] { "userId", "sessionId" }, new Object[] { userId, sessionId }).get(0)).intValue(); Index: lams_tool_daco/src/java/org/lamsfoundation/lams/tool/daco/model/DacoAnswer.hbm.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_daco/src/java/org/lamsfoundation/lams/tool/daco/model/Attic/DacoAnswer.hbm.xml,v diff -u -r1.3 -r1.4 --- lams_tool_daco/src/java/org/lamsfoundation/lams/tool/daco/model/DacoAnswer.hbm.xml 31 Jul 2008 03:51:05 -0000 1.3 +++ lams_tool_daco/src/java/org/lamsfoundation/lams/tool/daco/model/DacoAnswer.hbm.xml 8 Nov 2010 11:52:49 -0000 1.4 @@ -95,6 +95,14 @@ column="file_name" /> + +