package com.vci.server.framework.systemConfig.stafforgmanage.combination;

import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import org.hibernate.HibernateException;
import org.hibernate.type.Type;

import com.vci.server.base.persistence.dao.BaseService;
import com.vci.server.base.persistence.dao.HibernateCallback;
import com.vci.server.base.persistence.dao.HibernateTemplate;
import com.vci.server.framework.systemConfig.stafforgmanage.passwordStrategy.PasswordStrategyDaoImpl;
import com.vci.server.framework.systemConfig.stafforgmanage.role.RoleDAOImpl;

public class CombinationService extends BaseService {
	/**
	 * 获取所有密码组合方式
	 * <p>Description: </p>
	 * 
	 * @author wangxl
	 * @time 2013-1-3
	 * @return
	 */
	@SuppressWarnings("rawtypes")
	public List getAllList() {
		return (List)new HibernateTemplate().run(new HibernateCallback() {
			public Object execute() throws HibernateException {
				CombinationDAOImpl impl = new CombinationDAOImpl();
				return impl.loadAll();
			}
		});
	}
	@SuppressWarnings("rawtypes")
	public List fetchCombinationsByPstId(final String pstId) {
		return (List)new HibernateTemplate().run(new HibernateCallback() {
			public Object execute() throws HibernateException {
				CombinationDAOImpl impl = new CombinationDAOImpl();
				String sql = "select c.* from PLCOMBINATION c where c.PLUID in " +
						"(select t.PLCOMBINATIONUID " +
						"from PLCOMBINATIONPASSWORDSTRATEGY t " +
						"where t.PLPASSWORDSTRATEGYUID = '"+pstId+"')";
				Object[] values = new Object[0];
				List<Combination> list = impl.findEntites(sql, values, "c", Combination.class);
				return list;
			}
		});
	}
	/**
	 * 分页查询组合方式
	 */
	
	public List fetchCombinationsToPage(final int pageIndex, final int pageSize){
		return (List)new HibernateTemplate().run(new HibernateCallback() {
			public Object execute() throws HibernateException {
				CombinationDAOImpl impl = new CombinationDAOImpl();
				String hsql = "select * from plcombination p order by p.PLNAME";
				String sql = getPageSQL(hsql,pageSize,pageIndex);
				Object [] o = {};
				return impl.findEntites(sql,o, "", Combination.class);
				//return impl.loadAll();
			}
		});
		
		
	}
	public List getCombinationsObjById(final String id) {
		return (List)new HibernateTemplate().run(new HibernateCallback() {
			public Object execute() throws HibernateException {
				PasswordStrategyDaoImpl impl = new PasswordStrategyDaoImpl();
				String sql = " select * from plcombination u where u.pluid = '"+id+"' ";				
				Object [] o = {};
				return impl.findEntites(sql,o, "", Combination.class);
			}
		});
	}
	/**
	 * 添加密码组合方式
	 * <p>Description: </p>
	 * 
	 * @author wangxl
	 * @time 2013-1-3
	 * @param comb
	 */
	public void saveCombination(final Combination comb){
		new HibernateTemplate().run(new HibernateCallback() {
			public Object execute() throws HibernateException {
				CombinationDAOImpl impl = new CombinationDAOImpl();
				comb.setUserEntity(userEntity);
				impl.save(comb);
				return comb;
			}
		});
	}

    public boolean updateCombination(final Combination comb){
    	return (Boolean)new HibernateTemplate().run(new HibernateCallback() {
			public Object execute() throws HibernateException {
				CombinationDAOImpl impl = new CombinationDAOImpl();
				Combination cComb = impl.getById(comb.getId());
				if (cComb == null) {
					comb.setUserEntity(userEntity);
					impl.saveOrUpdate(comb);
				} else {
					cComb.setName(comb.getName());
					cComb.setDesc(comb.getDesc());
					cComb.setUpdateTime(comb.getUpdateTime() );
					cComb.setUpdateUser(comb.getUpdateUser());
					cComb.setUserEntity(userEntity);
					impl.saveOrUpdate(cComb);
				}
				return true;
			}
		});
	}
    public boolean deleteCombinationByMQL(final String[] ids) {
		return (Boolean)new HibernateTemplate().run(new HibernateCallback() {
			public Object execute() throws HibernateException {
				int len = ids.length;
				String inStr = "";
				for (int i = 0; i < len; i++) {
					inStr += "?";
					if (i != len - 1) {
						inStr += ",";
					}
				}
				CombinationDAOImpl impl = new CombinationDAOImpl();
				String hql = "delete Combination c where c.id in (" + inStr + ")";
				impl.deleteQueryObject(hql, ids, userEntity);
				
				CombinationValueDAOImpl valIImpl = new CombinationValueDAOImpl();
				String shql = "delete CombinationValue cv where cv.parentId in (" + inStr + ")";
				valIImpl.deleteQueryObject(shql, ids, userEntity);
				return true;
			}
		});
	}
	//分页查询
	public String getPageSQL(String sql, int pageSize, int pageIndex ){
		if(pageIndex <= 0){
			pageIndex = 1;
		}
		int startRownum = (pageIndex - 1) * pageSize + 1;
		int endRownum = pageIndex * pageSize;
		String partionSql = "" +
				"SELECT * FROM( " + 
				"	SELECT A.*,ROWNUM RN FROM( " +
				sql +
				"	) A " +
				") WHERE RN <= " + String.valueOf(endRownum) + " AND RN >= " + String.valueOf(startRownum);
		return partionSql;
	}
	
	public int checkCombinationIsquotedCount(final String id ){
		return (Integer)new HibernateTemplate().run(new HibernateCallback() {
			public Object execute() throws HibernateException {
				int count = 0;
				RoleDAOImpl impl = new RoleDAOImpl();
				String hsql = "select count(*) from plcombinationpasswordstrategy u where u.PLCOMBINATIONUID = '"+id+"'" ;
				List list = new ArrayList();
				Object[] values = new Object[0];
				Map<String,Type> map = new HashMap<String,Type>();
				list = impl.findEntitesBySQL(hsql, values,map);
				if (list != null){
					count = Integer.valueOf(String.valueOf(list.get(0))).intValue();
				}
				return count;
			}
		});
	}
}