Index: lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/dao/hibernate/QaUsrRespDAO.java
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/dao/hibernate/QaUsrRespDAO.java,v
diff -u -r1.18.2.12 -r1.18.2.13
--- lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/dao/hibernate/QaUsrRespDAO.java 14 Jul 2016 05:37:47 -0000 1.18.2.12
+++ lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/dao/hibernate/QaUsrRespDAO.java 26 Jul 2016 02:44:49 -0000 1.18.2.13
@@ -107,8 +107,8 @@
}
private static final String SQL_LOAD_ATTEMPT_FOR_SESSION_AND_QUESTION_LIMIT_WITH_NAME_SEARCH_AVG_RATING1 = "SELECT resp.*, AVG(rating.rating) avg_rating"
- + " FROM tl_laqa11_usr_resp resp WHERE resp.answer IS NOT NULL" + " JOIN tl_laqa11_que_usr usr"
- + " ON resp.qa_que_content_id = :questionId AND resp.que_usr_id = usr.uid "
+ + " FROM tl_laqa11_usr_resp resp" + " JOIN tl_laqa11_que_usr usr"
+ + " ON resp.answer IS NOT NULL AND resp.qa_que_content_id = :questionId AND resp.que_usr_id = usr.uid "
+ " AND usr.que_usr_id!=:excludeUserId " + " JOIN tl_laqa11_session sess "
+ " ON usr.qa_session_id = sess.uid AND sess.qa_session_id = :qaSessionId ";
Index: lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/web/QaLearningAction.java
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/web/QaLearningAction.java,v
diff -u -r1.53.2.25 -r1.53.2.26
--- lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/web/QaLearningAction.java 14 Jul 2016 05:37:47 -0000 1.53.2.25
+++ lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/web/QaLearningAction.java 26 Jul 2016 02:44:49 -0000 1.53.2.26
@@ -1097,9 +1097,6 @@
responcedata.put(AttributeNames.ATTR_COUNT_RATED_ITEMS, countRatedQuestions);
}
- // setting date format to ISO8601 for jquery.timeago
- DateFormat dateFormatterTimeAgo = new SimpleDateFormat(DateUtil.ISO8601_FORMAT);
- dateFormatterTimeAgo.setTimeZone(TimeZone.getTimeZone("GMT"));
for (QaUsrResp response : responses) {
QaQueUsr user = response.getQaQueUser();
@@ -1126,7 +1123,7 @@
// in the server time zone.
Date attemptTime = response.getAttemptTime();
responseRow.put("attemptTime", DateUtil.convertToStringForJSON(attemptTime, request.getLocale()));
- responseRow.put("timeAgo", dateFormatterTimeAgo.format(attemptTime));
+ responseRow.put("timeAgo", DateUtil.convertToStringForTimeagoJSON(attemptTime));
if (isAllowRateAnswers) {
Index: lams_tool_laqa/web/monitoring/MonitoringMaincontent.jsp
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_laqa/web/monitoring/MonitoringMaincontent.jsp,v
diff -u -r1.39.2.15 -r1.39.2.16
--- lams_tool_laqa/web/monitoring/MonitoringMaincontent.jsp 14 Jul 2016 05:37:47 -0000 1.39.2.15
+++ lams_tool_laqa/web/monitoring/MonitoringMaincontent.jsp 26 Jul 2016 02:44:49 -0000 1.39.2.16
@@ -91,7 +91,9 @@
+
+