Index: lams_central/web/qb/stats.jsp
===================================================================
diff -u -r0580a000d442501fbababd51663f7c03cedfbf20 -r28523d629738623026587908460f0ec8268c5f6f
--- lams_central/web/qb/stats.jsp (.../stats.jsp) (revision 0580a000d442501fbababd51663f7c03cedfbf20)
+++ lams_central/web/qb/stats.jsp (.../stats.jsp) (revision 28523d629738623026587908460f0ec8268c5f6f)
@@ -140,6 +140,34 @@
+
Usage
Index: lams_common/src/java/org/lamsfoundation/lams/qb/dao/IQbDAO.java
===================================================================
diff -u -red9a00f4f59d352ae53b11ba461f12affd12dab0 -r28523d629738623026587908460f0ec8268c5f6f
--- lams_common/src/java/org/lamsfoundation/lams/qb/dao/IQbDAO.java (.../IQbDAO.java) (revision ed9a00f4f59d352ae53b11ba461f12affd12dab0)
+++ lams_common/src/java/org/lamsfoundation/lams/qb/dao/IQbDAO.java (.../IQbDAO.java) (revision 28523d629738623026587908460f0ec8268c5f6f)
@@ -22,5 +22,7 @@
Map geAnswerStatsForQbToolQuestion(long qbToolQuestionUid);
- Map geAnswerStatsForActivity(long activityId);
+ Map getAnswerStatsForActivity(long activityId);
+
+ Map getBurningQuestions(long qbQuestionUid);
}
\ No newline at end of file
Index: lams_common/src/java/org/lamsfoundation/lams/qb/dao/hibernate/QbDAO.java
===================================================================
diff -u -red9a00f4f59d352ae53b11ba461f12affd12dab0 -r28523d629738623026587908460f0ec8268c5f6f
--- lams_common/src/java/org/lamsfoundation/lams/qb/dao/hibernate/QbDAO.java (.../QbDAO.java) (revision ed9a00f4f59d352ae53b11ba461f12affd12dab0)
+++ lams_common/src/java/org/lamsfoundation/lams/qb/dao/hibernate/QbDAO.java (.../QbDAO.java) (revision 28523d629738623026587908460f0ec8268c5f6f)
@@ -1,6 +1,7 @@
package org.lamsfoundation.lams.qb.dao.hibernate;
import java.util.HashMap;
+import java.util.LinkedHashMap;
import java.util.List;
import java.util.Map;
@@ -23,6 +24,8 @@
+ "WHERE a.qbToolQuestion.uid = :qbToolQuestionUid GROUP BY a.qbOption.uid";
private static final String FIND_ANSWER_STATS_BY_ACTIVITY = "SELECT a.qbOption.uid, COUNT(a.uid) FROM QbToolAnswer AS a, "
+ " ToolActivity AS act WHERE a.qbToolQuestion.toolContentId = act.toolContentId AND act.activityId = :activityId GROUP BY a.qbOption.uid";
+ private static final String FIND_BURNING_QUESTIONS = "SELECT bl.burningQuestion.question, COUNT(bl.uid) FROM BurningQuestionLike AS bl "
+ + "WHERE bl.burningQuestion.scratchieItem.qbQuestion.uid = :qbQuestionUid GROUP BY bl.burningQuestion.question ORDER BY COUNT(bl.uid) DESC";
@Override
public int getMaxQuestionId() {
@@ -79,7 +82,7 @@
@Override
@SuppressWarnings("unchecked")
- public Map geAnswerStatsForActivity(long activityId) {
+ public Map getAnswerStatsForActivity(long activityId) {
List