/**
 * 該文件由自動生成代碼器生成
 */
package com.xunlei.callcenter.dao;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import org.springframework.jdbc.core.RowCallbackHandler;

import com.xunlei.common.facade.FacadeCommonImpl;
import com.xunlei.common.facade.IFacadeCommon;
import com.xunlei.common.util.*;
import com.xunlei.callcenter.vo.Groups;

/**
 * @author Administrator
 * @date 2008-03-20 20:48:55
 * 
 */
public class GroupsDaoImpl extends BaseDao implements IGroupsDao {
	/**
	 * 可以根據(jù)其他字段的查詢條件來獲取唯一的數(shù)據(jù)
	 */
	public Groups findGroups(Groups data) {
		String sql = "select * from groups";
		String countsql = "select count(1) from groups";
		StringBuilder where = new StringBuilder(" where 1=1");
		if (null != data) {
			if (data.getSeqid() > 0) {
				return this.getGroupsById(data.getSeqid());
			}
			// TODO: 添加你的代碼，查詢條件

			countsql += where.toString();
			sql += where.toString();
			if (this.getSingleInt(countsql) == 1) {
				return this.queryOne(Groups.class, sql);
			}
		}
		return null;
	}
	
	public String getAbleGroupId(final String pGroupIdId){
    	 final List<String> datas = new ArrayList<String>(1);
    	 String sql = "select count(*) from groups g where g.groupid != '99' and g.pGroupIdId ='"+pGroupIdId+"' ";
    	 int count= IFacadeCommon.INSTANCE.getRecordCount(sql);
    	 String s = ""; 
    	 if(count==0)
    	 {
    		 if("-1".equals(pGroupIdId))
        		 s="00";
        	 else if("00".equals(pGroupIdId))
        		 s="0001";
        	 else
        		 s=pGroupIdId + "01";
    	 }
    	 else
    	 {
    		 String sql1 = "select g.groupid from groups g where g.groupid != '99' and g.pGroupIdId ='"+pGroupIdId+"' order by g.groupid ";
    		 getJdbcTemplate().query(sql1,new RowCallbackHandler(){
    	            public void processRow(ResultSet rs) throws SQLException {
    	                String s = rs.getString(1);
    	                datas.add(s);
    	            }
    	        });
    		 if(datas.size()==1&&datas.get(0)!=null&&!datas.get(0).equals(""))
			 {
				 String p = pGroupIdId;
                 try {
                     s = p + fomartInt(Integer.parseInt(datas.get(0).substring(p.length())) + 1);
                 } catch (NumberFormatException ex) {
                     ex.printStackTrace();
                 }
               
			 } 
    		 for(int i=0; i<datas.size()-1;i++)
    		 {
    			 if(datas.get(i)!=null&&!datas.get(i).equals("")&&datas.get(i+1)!=null&&!datas.get(i+1).equals(""))
    			 {
    				 int flag=Integer.parseInt(datas.get(i+1))-Integer.parseInt(datas.get(i));
        			 if(flag!=1){
        				 String p = pGroupIdId;
                         try {
                             s = p + fomartInt(Integer.parseInt(datas.get(i).substring(p.length())) + 1);
                         } catch (NumberFormatException ex) {
                             ex.printStackTrace();
                         }
                         break;
        			 } 
        			 else{
        				 String p = pGroupIdId;
                         try {
                             s = p + fomartInt(Integer.parseInt(datas.get(i+1).substring(p.length())) + 1);
                         } catch (NumberFormatException ex) {
                             ex.printStackTrace();
                         }
        			 }
    			 }
    			 if((datas.get(i)==null||datas.get(i).equals("")))
    			 {
    				 if("-1".equals(pGroupIdId))
    	        		 s="00";
    	        	 else if("00".equals(pGroupIdId))
    	        		 s="0001";
    	        	 else
    	        		 s=pGroupIdId + "01"; 
    			 }
    				 
    		 }
    		 
    	 }
         return s;
    }
    private static String fomartInt(int i){
        String s = "00"+i;
        return s.substring(s.length() -2);
    }

	public Groups getGroupsByGroupId(String groupid) {
		String sql = "select g from Groups as g where g.groupid = ?";
		List<Groups> list = getHibernateTemplate().find(sql, groupid);
		return (list.size() == 0) ? null : list.get(0);
	}

	public List<Groups> getAllGroups(){
		String sql = "select g from Groups as g order by g.groupid ";
	    return getHibernateTemplate().find(sql);
	}
	
	public Sheet<Groups> queryGroups(Groups data, PagedFliper fliper) {
		String sql = "select * from groups";
		String countsql = "select count(1) from groups";
		StringBuilder where = new StringBuilder(" where 1=1 ");
		if (null != data) {
			// TODO: 添加你的代碼，查詢條件
		}
		countsql += where.toString();
		int rowcount = this.getSingleInt(countsql);
		if (rowcount <= 0) {
			return Sheet.EMPTY;
		}
		sql += where.toString();
		if (null != fliper) {
			if (isNotEmpty(fliper.getSortColumn())) {
				sql += " order by " + fliper.getSortColumn();
			}
			sql += fliper.limitsql(rowcount);
		}
		return new Sheet<Groups>(rowcount, this.query(Groups.class, sql));
	}

	/**
	 * 根據(jù)傳入的對象,刪除相應的數(shù)據(jù)
	 * 
	 */
	public void deleteGroups(Groups data) {
		if (null != data) {
			if (data.getSeqid() > 0) {
				this.deleteGroupsById(data.getSeqid());
			}
			// TODO: 添加你的代碼，刪除符合條件的記錄
		}
	}

	public Groups getGroupsById(long seqid) {
		return findObject(Groups.class, seqid);
	}

	public void insertGroups(Groups data) {
		insertObject(data);
	}

	public void updateGroups(Groups data) {
		updateObject(data);
	}

	public void deleteGroupsById(long seqids) {
		this.deleteObject("groups", seqids);
	}

	 public int getGroupCountByGroupName(String groupName){
	    	String sql = " select count(*) from groups where GroupIdName ='"+groupName+"'";
	    	return FacadeCommonImpl.INSTANCE.getRecordCount(sql);
	    }

	public int getGroupCountByGroupId(String groupid) {
		String sql = " select count(*) from groups where pgroupidid ='"+groupid+"'";
    	return FacadeCommonImpl.INSTANCE.getRecordCount(sql);
	}
	
	public int getEmployeesCountByGroupId(String groupid) {
		String sql = " select count(*) from usertogroup where groupid ='"+groupid+"'";
    	return FacadeCommonImpl.INSTANCE.getRecordCount(sql);
	}
}