commonCartridgeList = new ArrayList<>(getCommonCartridgeItemList(sessionMap));
item = commonCartridgeList.get(itemIdx);
Index: lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/dao/hibernate/McUserDAO.java
===================================================================
diff -u -ra1064a52a646aa043ea1fe371726537fd305c5de -rcb01d2d8c064728cb0e2ac524d2f89622a534e39
--- lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/dao/hibernate/McUserDAO.java (.../McUserDAO.java) (revision a1064a52a646aa043ea1fe371726537fd305c5de)
+++ lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/dao/hibernate/McUserDAO.java (.../McUserDAO.java) (revision cb01d2d8c064728cb0e2ac524d2f89622a534e39)
@@ -27,7 +27,6 @@
import org.hibernate.query.NativeQuery;
import org.hibernate.query.Query;
-import org.hibernate.type.FloatType;
import org.hibernate.type.StandardBasicTypes;
import org.lamsfoundation.lams.dao.hibernate.LAMSBaseDAO;
import org.lamsfoundation.lams.tool.mc.dao.IMcUserDAO;
@@ -38,34 +37,37 @@
/**
* @author Ozgur Demirtas
- *
- * Hibernate implementation for database access to Mc users (learners) for the mc tool.
- *
+ *
+ * Hibernate implementation for database access to Mc users (learners) for the mc tool.
+ *
*/
@Repository
public class McUserDAO extends LAMSBaseDAO implements IMcUserDAO {
private static final String GET_USER_BY_USER_ID_SESSION = "from mcQueUsr in class McQueUsr where mcQueUsr.queUsrId=:queUsrId and mcQueUsr.mcSession.uid=:mcSessionUid";
- private static final String LOAD_MARKS_FOR_SESSION = "SELECT last_attempt_total_mark "
- + " FROM tl_lamc11_que_usr usr " + " JOIN tl_lamc11_session sess ON usr.mc_session_id = sess.uid "
- + " WHERE responseFinalised = 1 AND sess.mc_session_id = :sessionId";
- private static final String FIND_MARK_STATS_FOR_SESSION = "SELECT MIN(last_attempt_total_mark) min_grade, AVG(last_attempt_total_mark) avg_grade, "
- + " MAX(last_attempt_total_mark) max_grade FROM tl_lamc11_que_usr usr "
- + " JOIN tl_lamc11_session sess ON usr.mc_session_id = sess.uid "
- + " WHERE responseFinalised = 1 AND sess.mc_session_id = :sessionId";
+ private static final String LOAD_MARKS_FOR_SESSION =
+ "SELECT last_attempt_total_mark " + " FROM tl_lamc11_que_usr usr "
+ + " JOIN tl_lamc11_session sess ON usr.mc_session_id = sess.uid "
+ + " WHERE responseFinalised = 1 AND sess.mc_session_id = :sessionId";
+ private static final String FIND_MARK_STATS_FOR_SESSION =
+ "SELECT MIN(last_attempt_total_mark) min_grade, AVG(last_attempt_total_mark) avg_grade, "
+ + " MAX(last_attempt_total_mark) max_grade FROM tl_lamc11_que_usr usr "
+ + " JOIN tl_lamc11_session sess ON usr.mc_session_id = sess.uid "
+ + " WHERE responseFinalised = 1 AND sess.mc_session_id = :sessionId";
- private static final String LOAD_MARKS_FOR_LEADERS = "SELECT usr.last_attempt_total_mark "
- + " FROM tl_lamc11_que_usr usr "
- + " JOIN tl_lamc11_session sess ON usr.mc_session_id = sess.uid AND usr.uid = sess.mc_group_leader_uid "
- + " JOIN tl_lamc11_content mcq ON sess.mc_content_id = mcq.uid "
- + " WHERE responseFinalised = 1 AND mcq.content_id = :toolContentId";
- private static final String FIND_MARK_STATS_FOR_LEADERS = "SELECT MIN(usr.last_attempt_total_mark) min_grade, AVG(usr.last_attempt_total_mark) avg_grade, "
- + " MAX(usr.last_attempt_total_mark) max_grade, COUNT(usr.last_attempt_total_mark) num_complete "
- + " FROM tl_lamc11_que_usr usr "
- + " JOIN tl_lamc11_session sess ON usr.mc_session_id = sess.uid AND usr.uid = sess.mc_group_leader_uid "
- + " JOIN tl_lamc11_content mcq ON sess.mc_content_id = mcq.uid "
- + " WHERE responseFinalised = 1 AND mcq.content_id = :toolContentId";
+ private static final String LOAD_MARKS_FOR_LEADERS =
+ "SELECT usr.last_attempt_total_mark " + " FROM tl_lamc11_que_usr usr "
+ + " JOIN tl_lamc11_session sess ON usr.mc_session_id = sess.uid AND usr.uid = sess.mc_group_leader_uid "
+ + " JOIN tl_lamc11_content mcq ON sess.mc_content_id = mcq.uid "
+ + " WHERE responseFinalised = 1 AND mcq.content_id = :toolContentId";
+ private static final String FIND_MARK_STATS_FOR_LEADERS =
+ "SELECT MIN(usr.last_attempt_total_mark) min_grade, AVG(usr.last_attempt_total_mark) avg_grade, "
+ + " MAX(usr.last_attempt_total_mark) max_grade, COUNT(usr.last_attempt_total_mark) num_complete "
+ + " FROM tl_lamc11_que_usr usr "
+ + " JOIN tl_lamc11_session sess ON usr.mc_session_id = sess.uid AND usr.uid = sess.mc_group_leader_uid "
+ + " JOIN tl_lamc11_content mcq ON sess.mc_content_id = mcq.uid "
+ + " WHERE responseFinalised = 1 AND mcq.content_id = :toolContentId";
@Override
public McQueUsr getMcUserByUID(Long uid) {
@@ -98,10 +100,11 @@
@Override
@SuppressWarnings("unchecked")
public List