package cn.ksource.web.facade.accountmsg;

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

import javax.servlet.http.HttpServletRequest;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import cn.ksource.core.dao.BaseDao;
import cn.ksource.core.dao.SqlParameter;
import cn.ksource.core.page.PageInfo;
import cn.ksource.core.util.StringUtil;
import cn.ksource.core.web.WebUtil;

@Service("accountMsgFacade")
@SuppressWarnings("unchecked")
public class AccountMsgFacadeImpl implements AccountMsgFacade {
	
	@Autowired
	private BaseDao baseDao;

	@Override
	public Map getPartnerMsgById() {
		//加盟商信息
		String sql ="SELECT A.* FROM SC_PARTNER_INFO A";
		Map paraMap = new HashMap();
		Map map = baseDao.queryForMap(sql, paraMap);
		//加盟商员工
		String sqlUser ="SELECT COUNT(ID) FROM GG_USER WHERE ZT=1  ";
		int userCount = baseDao.queryForInteger(sqlUser, paraMap);
		map.put("userCount", userCount);
		return map;
	}

	@Override
	public Map queryMaxCusNum() {
		Map resultMap = new HashMap();
		SqlParameter sqlParameter = new SqlParameter();
		String selectSql = "SELECT COUNT(ID) FROM CUSTOMER_CONTACTS  WHERE STATE=1  ";
		int count = baseDao.queryForInteger(selectSql,sqlParameter);
		
		//查询该公司下最多可以添加多少客户账户
		String selectUser = "SELECT CUSTOMER_ACCOUNT_NUM FROM SC_PARTNER_INFO ";
		int moreNum = baseDao.queryForInteger(selectUser,sqlParameter);
		
		if(moreNum>count) {
			resultMap.put("result", 1);
		} else {
			resultMap.put("result", 2);
		}
		resultMap.put("nowNum", count);
		resultMap.put("maxNum", moreNum);
		return resultMap;
	}
	
	@Override
	public PageInfo queryGlzhData(Map<String,String> params,PageInfo pageInfo) {
		StringBuilder builder = new StringBuilder("SELECT B.* FROM  GG_USER B  WHERE 1=1 ");
		String name = params.get("name");
		
		if(StringUtil.notEmpty(name)) {
			builder.append(" AND B.ZSXM LIKE :name ");
			params.put("name", "%"+name+"%");
		}
		
		return baseDao.queryforSplitPageInfo(pageInfo, builder.toString(), params);
	}
	@Override
	public int queryGlzhCount(Map<String,String> params) {
		StringBuilder builder = new StringBuilder("SELECT COUNT(B.ID) FROM GG_USER B WHERE 1=1 ");
		String name = params.get("name");
		
		if(StringUtil.notEmpty(name)) {
			builder.append(" AND B.ZSXM LIKE :name ");
			params.put("name", "%"+name+"%");
		}
		
		return baseDao.queryForInteger(builder.toString(),params);
	}
	@Override
	public int queryKhCount(Map<String,String> params) {
		StringBuilder selectSql = new StringBuilder("SELECT COUNT(C.ID) FROM CUSTOMER_CONTACTS C,SC_PARTNER_CUSTOMER_INFO B WHERE C.CUSTOMER_ID = B.ID ");
		String name = params.get("name");
		if(StringUtil.notEmpty(name)) {
			selectSql.append(" AND B.CUSTOMER_NAME LIKE :name ");
			params.put("name", "%"+name+"%");
		}
		int count = baseDao.queryForInteger(selectSql.toString(),params);
		return count;
	}
	@Override
	public PageInfo queryKhData(Map<String,String> params,PageInfo pageInfo) {
		StringBuilder selectSql = new StringBuilder("SELECT C.*,B.CUSTOMER_NAME,B.VALID_BEGIN_DATE,B.VALID_END_DATE FROM CUSTOMER_CONTACTS C ,SC_PARTNER_CUSTOMER_INFO B WHERE C.CUSTOMER_ID = B.ID  ");
		String name = params.get("name");
		if(StringUtil.notEmpty(name)) {
			selectSql.append(" AND B.CUSTOMER_NAME LIKE :name ");
			params.put("name", "%"+name+"%");
		}
		selectSql.append(" ORDER BY C.CONTACT_NAME  ");
		PageInfo info = baseDao.queryforSplitPageInfo(pageInfo,selectSql.toString(),params);
		return info;
	}

}