Index: lams_tool_chat/src/java/org/lamsfoundation/lams/tool/chat/dao/IChatMessageDAO.java =================================================================== RCS file: /usr/local/cvsroot/lams_tool_chat/src/java/org/lamsfoundation/lams/tool/chat/dao/IChatMessageDAO.java,v diff -u -r1.2 -r1.3 --- lams_tool_chat/src/java/org/lamsfoundation/lams/tool/chat/dao/IChatMessageDAO.java 8 Jun 2006 01:51:11 -0000 1.2 +++ lams_tool_chat/src/java/org/lamsfoundation/lams/tool/chat/dao/IChatMessageDAO.java 14 Jun 2006 23:50:02 -0000 1.3 @@ -26,6 +26,7 @@ package org.lamsfoundation.lams.tool.chat.dao; import java.util.List; +import java.util.Map; import org.lamsfoundation.lams.dao.IBaseDAO; import org.lamsfoundation.lams.tool.chat.model.ChatMessage; @@ -45,4 +46,8 @@ ChatMessage getByUID(Long uid); List getLatest(ChatSession chatSession, int max); + + Map getCountBySession(Long chatUID); + + Map getCountByFromUser(Long sessionUID); } Index: lams_tool_chat/src/java/org/lamsfoundation/lams/tool/chat/dao/hibernate/ChatMessageDAO.java =================================================================== RCS file: /usr/local/cvsroot/lams_tool_chat/src/java/org/lamsfoundation/lams/tool/chat/dao/hibernate/ChatMessageDAO.java,v diff -u -r1.2 -r1.3 --- lams_tool_chat/src/java/org/lamsfoundation/lams/tool/chat/dao/hibernate/ChatMessageDAO.java 8 Jun 2006 01:51:11 -0000 1.2 +++ lams_tool_chat/src/java/org/lamsfoundation/lams/tool/chat/dao/hibernate/ChatMessageDAO.java 14 Jun 2006 23:50:02 -0000 1.3 @@ -25,13 +25,15 @@ package org.lamsfoundation.lams.tool.chat.dao.hibernate; +import java.util.HashMap; +import java.util.Iterator; import java.util.List; +import java.util.Map; import org.hibernate.HibernateException; import org.hibernate.Query; import org.lamsfoundation.lams.dao.hibernate.BaseDAO; import org.lamsfoundation.lams.tool.chat.dao.IChatMessageDAO; -import org.lamsfoundation.lams.tool.chat.model.Chat; import org.lamsfoundation.lams.tool.chat.model.ChatMessage; import org.lamsfoundation.lams.tool.chat.model.ChatSession; import org.lamsfoundation.lams.tool.chat.model.ChatUser; @@ -55,6 +57,14 @@ + ChatMessage.class.getName() + " as f where f.chatSession=? order by f.sendDate desc"; + public static final String SQL_QUERY_FIND_MESSAGE_COUNT_BY_FROM_USER = "select f.fromUser.uid, count(*) from " + + ChatMessage.class.getName() + + " as f where f.chatSession=? group by f.fromUser"; + + public static final String SQL_QUERY_FIND_MESSAGE_COUNT_BY_SESSION = "select f.chatSession.uid, count(*) from " + + ChatMessage.class.getName() + + " as f where f.chatSession.chat=? group by f.chatSession"; + public void saveOrUpdate(ChatMessage chatMessage) { this.getHibernateTemplate().saveOrUpdate(chatMessage); this.getHibernateTemplate().flush(); @@ -91,4 +101,30 @@ return null; } } + + public Map getCountBySession(Long chatUID) { + List list = this.getHibernateTemplate().find( + SQL_QUERY_FIND_MESSAGE_COUNT_BY_SESSION, + new Object[] { chatUID }); + + Map resultMap = new HashMap(); + for (Iterator iter = list.iterator(); iter.hasNext();) { + Object[] row = (Object[]) iter.next(); + resultMap.put((Long) row[0], (Integer) row[1]); + } + return resultMap; + } + + public Map getCountByFromUser(Long sessionUID) { + List list = this.getHibernateTemplate().find( + SQL_QUERY_FIND_MESSAGE_COUNT_BY_FROM_USER, + new Object[] { sessionUID }); + + Map resultMap = new HashMap(); + for (Iterator iter = list.iterator(); iter.hasNext();) { + Object[] row = (Object[]) iter.next(); + resultMap.put((Long) row[0], (Integer) row[1]); + } + return resultMap; + } } Index: lams_tool_chat/web/pages/monitoring/statistics.jsp =================================================================== RCS file: /usr/local/cvsroot/lams_tool_chat/web/pages/monitoring/statistics.jsp,v diff -u -r1.1 -r1.2 --- lams_tool_chat/web/pages/monitoring/statistics.jsp 3 Apr 2006 08:30:07 -0000 1.1 +++ lams_tool_chat/web/pages/monitoring/statistics.jsp 14 Jun 2006 23:50:02 -0000 1.2 @@ -1 +1,55 @@ -

this is statistics

\ No newline at end of file +<%@ include file="/common/taglibs.jsp"%> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
+ +
+ heading.totalLearners + +

+ TODO. +

+
+ heading.totalMessages + +

+ +

+
+ Learner + + No of Posts +
+ + + +
+
Index: lams_tool_chat/web/pages/monitoring/summary.jsp =================================================================== RCS file: /usr/local/cvsroot/lams_tool_chat/web/pages/monitoring/summary.jsp,v diff -u -r1.3 -r1.4 --- lams_tool_chat/web/pages/monitoring/summary.jsp 8 Jun 2006 02:32:52 -0000 1.3 +++ lams_tool_chat/web/pages/monitoring/summary.jsp 14 Jun 2006 23:50:02 -0000 1.4 @@ -1,7 +1,7 @@ <%@ include file="/common/taglibs.jsp"%> - + - - - - - - + + +
@@ -10,41 +10,45 @@
+ heading.totalLearners -

+

+

TODO.

+ heading.totalMessages -

- TODO +

+

+

+ heading.recentMessages +   +
- + message.noChatMessages - +