/*
 *  TagDAO.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.Query;

import com.liusoft.dlog4j.base._BeanBase;
import com.liusoft.dlog4j.beans.SiteBean;
import com.liusoft.dlog4j.beans.TagBean;

/**
 * 訪問標簽的數據庫接口
 * @author Winter Lau
 */
public class TagDAO extends DAO {

	/**
	 * 獲取標簽數
	 * @param site
	 * @return
	 */
	public static int getTagCount(SiteBean site){
		String hql = "SELECT COUNT(*) FROM TagBean t";
		if(site!=null){
			hql += " WHERE t.site.id = ?";
			return executeStatAsInt(hql, site.getId());
		}

		return executeStatAsInt(hql, null);
	}
	
	/**
	 * 按照熱門程度列出標簽
	 * @param site
	 * @param fromIdx
	 * @param count
	 * @return
	 */
	public static List listTags(SiteBean site, int fromIdx, int count){
		StringBuffer hql = new StringBuffer("SELECT t.name,COUNT(*) FROM TagBean t");
		if(site!=null)
			hql.append(" WHERE t.site.id = ?");
		hql.append(" GROUP BY t.name ORDER BY 2 DESC");
		Query query = getSession().createQuery(hql.toString());
		if(site!=null)
			query.setInteger(0,site.getId());
		if(fromIdx>0)
			query.setFirstResult(fromIdx);
		if(count > 0)
			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;
	}
	
	/**
	 * 刪除某個對象的標簽列表
	 * @param ref_id
	 * @param ref_type
	 * @see com.liusoft.dlog4j.dao.DiaryDAO#update(DiaryBean, boolean)
	 * @see com.liusoft.dlog4j.dao.PhotoDAO#update(int, PhotoBean, String)
	 * @see com.liusoft.dlog4j.dao.BBSTopicDAO#update(TopicBean)
	 */
	public static void deleteTagByRefId(int ref_id, int ref_type){
		executeNamedUpdate("DELETE_TAG", ref_id, ref_type);
	}
	
	/**
	 * 列出熱門的標簽
	 * @param site 如果該參數為null則列出所有的標簽
	 * @return
	 */
	public static List listHotTags(SiteBean site, int count){
		StringBuffer hql = new StringBuffer("SELECT t.name,COUNT(*) FROM TagBean t");
		if(site!=null)
			hql.append(" WHERE t.site.id = ?");
		hql.append(" GROUP BY t.name ORDER BY 2 DESC");
		Query query = getSession().createQuery(hql.toString());
		if(site!=null)
			query.setInteger(0,site.getId());
		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;
	}
	
	/**
	 * 獲取指向某個標簽的日記數
	 * @param site
	 * @param tag
	 * @return
	 */
	public static int getDiaryCountForTag(SiteBean site, String tag){
		if(site!=null)
			return gettObjectCountForTag(site, TagBean.TYPE_DIARY, tag);
		return getObjectCountForTag(TagBean.TYPE_DIARY, tag);
	}

	/**
	 * 獲取指向某個標簽的照片數
	 * @param site
	 * @param tag
	 * @return
	 */
	public static int getPhotoCountForTag(SiteBean site, String tag){
		if(site!=null)
			return gettObjectCountForTag(site, TagBean.TYPE_PHOTO, tag);
		return getObjectCountForTag(TagBean.TYPE_PHOTO, tag);
	}

	/**
	 * 獲取指向某個標簽的討論數
	 * @param site
	 * @param tag
	 * @return
	 */
	public static int getTopicCountForTag(SiteBean site, String tag){
		if(site!=null)
			return gettObjectCountForTag(site, TagBean.TYPE_BBS, tag);
		return getObjectCountForTag(TagBean.TYPE_BBS, tag);
	}
	
	/**
	 * 列出指定標簽的所有日記
	 * @param site
	 * @param tagname
	 * @return
	 */
	public static List listDiaryForTag(SiteBean site, String tagname, int fromIdx, int count){
		return listObjectsForTags(site,"DiaryOutlineBean",TagBean.TYPE_DIARY,tagname,fromIdx,count);
	}
	
	/**
	 * 列出指定標簽的所有相片
	 * @param site
	 * @param tagname
	 * @param fromIdx
	 * @param count
	 * @return
	 */
	public static List listPhotosForTag(SiteBean site, String tagname, int fromIdx, int count){
		return listObjectsForTags(site,"PhotoOutlineBean",TagBean.TYPE_PHOTO,tagname,fromIdx,count);
	}

	/**
	 * 列出指定標簽的所有論壇帖子
	 * @param site
	 * @param tagname
	 * @param fromIdx
	 * @param count
	 * @return
	 */
	public static List listTopicsForTag(SiteBean site, String tagname, int fromIdx, int count){
		return listObjectsForTags(site,"TopicOutlineBean",TagBean.TYPE_BBS,tagname,fromIdx,count);
	}
	
	/**
	 * 列出指定標簽的所有日記
	 * @param site
	 * @param tagname
	 * @return
	 */
	public static List listDiaryForTag(String tagname, int fromIdx, int count){
		return listObjectsForTags("DiaryOutlineBean",TagBean.TYPE_DIARY,tagname,fromIdx,count);
	}
	
	/**
	 * 列出指定標簽的所有相片
	 * @param site
	 * @param tagname
	 * @param fromIdx
	 * @param count
	 * @return
	 */
	public static List listPhotosForTag(String tagname, int fromIdx, int count){
		return listObjectsForTags("PhotoOutlineBean",TagBean.TYPE_PHOTO,tagname,fromIdx,count);
	}

	/**
	 * 列出指定標簽的所有論壇帖子
	 * @param site
	 * @param tagname
	 * @param fromIdx
	 * @param count
	 * @return
	 */
	public static List listTopicsForTag(String tagname, int fromIdx, int count){
		return listObjectsForTags("TopicOutlineBean",TagBean.TYPE_BBS,tagname,fromIdx,count);
	}

	/**
	 * 列出標簽所指向的對象
	 * @param site
	 * @param beanName
	 * @param tagname
	 * @param fromIdx
	 * @param count
	 * @return
	 */
	protected static List listObjectsForTags(SiteBean site, String beanName,
			int objType, String tagname, int fromIdx, int count) {
		StringBuffer hql = new StringBuffer("FROM ");
		hql.append(beanName);
		hql.append(" AS d WHERE d.status=? AND d.site.id=? AND d.id IN (SELECT t.refId FROM TagBean AS t WHERE t.site.id=? AND t.refType=? AND t.name=?) ORDER BY d.id DESC");
		Integer siteId = new Integer(site.getId());
		return executeQuery(hql.toString(), fromIdx, count, new Object[] {
				_BeanBase.I_STATUS_NORMAL, siteId, siteId,
				new Integer(objType), tagname });
	}

	/**
	 * 列出標簽所指向的對象
	 * @param beanName
	 * @param tagname
	 * @param fromIdx
	 * @param count
	 * @return
	 */
	protected static List listObjectsForTags(String beanName,
			int objType, String tagname, int fromIdx, int count) {
		StringBuffer hql = new StringBuffer("FROM ");
		hql.append(beanName);
		hql.append(" AS d WHERE d.status=? AND d.id IN (SELECT t.refId FROM TagBean AS t WHERE t.refType=? AND t.name=?) ORDER BY d.id DESC");
		return executeQuery(hql.toString(), fromIdx, count, new Object[] {
				_BeanBase.I_STATUS_NORMAL, new Integer(objType), tagname });
	}

	/**
	 * 列出標簽所指向的對象個數
	 * @param site
	 * @param beanName
	 * @param tagname
	 * @param fromIdx
	 * @param count
	 * @return
	 */
	protected static int gettObjectCountForTag(SiteBean site, int objType, String tagname) {
		return executeNamedStatAsInt("TAG_COUNT_OF_SITE", new Object[] {
				new Integer(site.getId()), new Integer(objType), tagname });
	}

	/**
	 * 列出標簽所指向的對象個數
	 * @param beanName
	 * @param tagname
	 * @param fromIdx
	 * @param count
	 * @return
	 */
	protected static int getObjectCountForTag(int objType, String tagname) {
		return executeNamedStatAsInt("TAG_COUNT", new Object[]{new Integer(objType), tagname});
	}
}