/*
* DlogDAO.java
*
* This program is free software; you can redistribute it and/or modify
* it under the terms of the GNU General Public License as published by
* the Free Software Foundation; either version 2 of the License, or
* (at your option) any later version.
*
* This program is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU Library General Public License for more details.
*
* You should have received a copy of the GNU General Public License
* along with this program; if not, write to the Free Software
* Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
*
* Author: Winter Lau (javayou@gmail.com)
* http://dlog4j.sourceforge.net
*/
package com.liusoft.dlog4j.dao;
import java.util.ArrayList;
import java.util.List;
import org.hibernate.SQLQuery;
import org.hibernate.Session;
import com.liusoft.dlog4j.base.DlogStatInfo;
/**
* DLOG4Jƽ̨���������ݿ���ʷ���
* @author Winter Lau
*/
public class DlogDAO extends DAO {
/**
* ��ȡ�ƶ���վ�����ŵı�ǩ,�����վûָ��(site=-1)���ѯ������վ
* @param site
* @param count
* @return
*/
public static List listHotTags(int site, int count){
Session ssn = getSession();
StringBuffer sql = new StringBuffer("SELECT tag_name,COUNT(*) FROM dlog_tag");
if(site>0)
sql.append(" WHERE site_id=?");
sql.append(" GROUP BY tag_name ORDER BY 2 DESC");
SQLQuery query = ssn.createSQLQuery(sql.toString());
if(site>0)
query.setInteger(0, site);
query.setMaxResults(count);
List tags = new ArrayList();
List results = query.list();
for(int i=0;results!=null && i<results.size();i++){
tags.add(((Object[])results.get(i))[0]);
}
return tags;
}
/**
* ����ָ����վ��ͳ����Ϣ,���siteֵС��0��ȡ������վ
* @param site
* @return
*/
public static DlogStatInfo getDlogStatInfo(int site){
DlogStatInfo count = new DlogStatInfo();
//============== �ռ���
count.setArticle(DiaryDAO.getDiaryCount(site));
//============== �ռ�������
count.setArticleReply(DiaryDAO.getDiaryReplyCount(site));
//============== ��Ƭ��
count.setPhoto(PhotoDAO.getPhotoCount(site));
//============== ��Ƭ������
count.setPhotoReply(PhotoDAO.getPhotoReplyCount(site));
//============== ��̳������
count.setTopic(BBSTopicDAO.getTopicCount(site));
//============== ��̳������
count.setTopicReply(BBSReplyDAO.getReplyCount(site));
//============== ע���û���
count.setUser(UserDAO.getUserCount(site));
//============== ע����վ��
count.setSite(SiteDAO.getSiteCount());
return count;
}
}