package com.xh369.daoimpl;

import java.util.List;
import org.hibernate.Query;
import org.hibernate.criterion.Example;
import com.xh369.dto.Articlesviews;
import com.xh369.dto.ArticlesviewsId;
import org.hibernate.*;
import com.xh369.dao.ArticlesviewsDAO;
import com.xh369.actions.HibernateSessionFactory;

public class ArticlesviewsDAOimpl implements ArticlesviewsDAO{

    //按視圖主鍵查詢
    public Articlesviews findById(ArticlesviewsId id) {

        try {
            Session session = HibernateSessionFactory.getSession();
            Articlesviews instance = (Articlesviews) session.get("com.xh369.dto.Articlesviews", id);
            return instance;
        } catch (RuntimeException re) {
            throw re;
        }
    }

    //按視圖實例類查詢(采用Criteria編程)
    public List findByExample(Articlesviews instance) {

        try {
            Session session = HibernateSessionFactory.getSession();
            List results = session.createCriteria("com.xh369.dto.Articlesviews")
                                  .add(Example.create(instance))
                                  .list();
            return results;
        } catch (RuntimeException re) {
            throw re;
        }
    }

    //按視圖編號查詢
    public List findByPropertyId(String propertyName, Object value) {

        try {
         String hql = "from Articlesviews as articlesviews where articlesviews." + propertyName + "= ?";
         Session session = HibernateSessionFactory.getSession();
         List results = session.createQuery(hql)
                               .setParameter(0, value)
                               .list();
         return results;
      } catch (RuntimeException re) {
         throw re;
      }
    }

    //用于分頁查詢(其中int position_index, int pageSize分別為起始索引和頁大小)
    public List findByProperty(Object[][] val, int position_index, int pageSize) {

        try {
         StringBuffer hql = new StringBuffer("from Articlesviews as articlesviews");
         if(Integer.parseInt(val[0][1].toString()) == 0 && !val[1][1].toString().equals("")) hql.append(" where lower(articlesviews." + val[1][0].toString() + ") like '%"+val[1][1].toString().toLowerCase()+"%'");
         if(Integer.parseInt(val[0][1].toString()) != 0 && !val[1][1].toString().equals("")) hql.append(" where articlesviews." + val[0][0].toString() + "=? or lower(articlesviews." + val[1][0].toString() +") like '%"+val[1][1].toString().toLowerCase()+"%'");
         if(Integer.parseInt(val[0][1].toString()) != 0 && val[1][1].toString().equals("")) hql.append(" where articlesviews." + val[0][0].toString() + "=?");
         if(!val[2][1].toString().equals("") && !val[3][1].toString().equals("")) hql.append(" where articlesviews." + val[2][0].toString() + "=? and articlesviews." + val[3][0].toString() + "=?");
         Session session = HibernateSessionFactory.getSession();
         Query query = session.createQuery(hql.toString());
         if(Integer.parseInt(val[0][1].toString()) != 0 && !val[1][1].toString().equals("")) query.setParameter(0, val[0][1], Hibernate.INTEGER);
         if(Integer.parseInt(val[0][1].toString()) != 0 && val[1][1].toString().equals("")) query.setParameter(0, val[0][1]);
         if(!val[2][1].toString().equals("") && !val[3][1].toString().equals("")) query.setParameter(0, val[2][1], Hibernate.STRING)
                                                                                        .setParameter(1, val[3][1]);
         if(position_index == 1){
             return query.setFirstResult(0)
                     .setMaxResults(pageSize)
                     .list();
         }else{
             return query.setFirstResult( (position_index - 1) * pageSize )
                     .setMaxResults(pageSize)
                     .list();
         }
      } catch (RuntimeException re) {
         throw re;
      }
    }

    //得到分頁查詢的總記錄數
    public int getCount(Object[][] val) {

        try {
            StringBuffer hql = new StringBuffer("select count(*) from Articlesviews as articlesviews");
            if(Integer.parseInt(val[0][1].toString()) == 0 && !val[1][1].toString().equals("")) hql.append(" where lower(articlesviews." + val[1][0].toString() + ") like '%"+val[1][1].toString().toLowerCase()+"%'");
            if(Integer.parseInt(val[0][1].toString()) != 0 && !val[1][1].toString().equals("")) hql.append(" where articlesviews." + val[0][0].toString() + "=? or lower(articlesviews." + val[1][0].toString() +") like '%"+val[1][1].toString().toLowerCase()+"%'");
            if(Integer.parseInt(val[0][1].toString()) != 0 && val[1][1].toString().equals("")) hql.append(" where articlesviews." + val[0][0].toString() + "=?");
            if(!val[2][1].toString().equals("") && !val[3][1].toString().equals("")) hql.append(" where articlesviews." + val[2][0].toString() + "=? and articlesviews." + val[3][0].toString() + "=?");
            Session session = HibernateSessionFactory.getSession();
            Query query = session.createQuery(hql.toString());
            if(Integer.parseInt(val[0][1].toString()) != 0 && !val[1][1].toString().equals("")) query.setParameter(0, val[0][1], Hibernate.INTEGER);
            if(Integer.parseInt(val[0][1].toString()) != 0 && val[1][1].toString().equals("")) query.setParameter(0, val[0][1]);
            if(!val[2][1].toString().equals("") && !val[3][1].toString().equals("")) query.setParameter(0, val[2][1], Hibernate.STRING)
                                                                                           .setParameter(1, val[3][1]);
            return Integer.parseInt(
                                      query.list()
                                           .get(0)
                                           .toString());
        } catch (Exception ex) {
            ex.printStackTrace();
            return 0;
        }
    }
    
    //用于分頁查詢(其中int position_index, int pageSize分別為起始索引和頁大小)
	public List findByProperty(int position_index, int pageSize) {
		
		try {
			String hql = "from Articlesviews as articlesviews";
			Session session = HibernateSessionFactory.getSession();
			Query query = session.createQuery(hql);
			if(position_index == 1){
	            return query.setFirstResult(0)
	                    .setMaxResults(pageSize)
	                    .list();
	        }else{
	            return query.setFirstResult( (position_index - 1) * pageSize )
	                    .setMaxResults(pageSize)
	                    .list();
	        }
		} catch (Exception e) {
			e.printStackTrace();
			return null;
		}
	}
	
	//得到分頁查詢的總記錄數
	public int getCount() {
		
		 try {
	            String hql = "select count(*) from Articlesviews as articlesviews";
	            Session session = HibernateSessionFactory.getSession();
	            Query query = session.createQuery(hql);
	            return Integer.parseInt(
	                                      query.list()
	                                           .get(0)
	                                           .toString());
	        } catch (Exception ex) {
	            ex.printStackTrace();
	            return 0;
	        }
	}
}