package cn.ksource.web.facade.wechat.ewyw;

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

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

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

@Service("ewInformationFacade")
public class EwInformationFacadeImpl implements EwInformationFacade {
	
	@Autowired
    BaseDao baseDao;
	
	@Override
	public PageInfo queryMainufacturerData(PageInfo pageInfo,Map<String, String> params) {
		String type = params.get("type");
		String cusId = params.get("cusId");
		String mainufacturerName=params.get("mainufacturerName");//厂商/集成商名称
		StringBuilder buffer= new StringBuilder("SELECT * FROM CMDB_MAINUFACTURER c WHERE c.STATE=1 ");
		if(StringUtil.notEmpty(mainufacturerName)){
			buffer.append(" AND c.ZH_NAME LIKE :mainufacturerName");
		}
		if(StringUtil.notEmpty(cusId)){
			buffer.append(" AND c.CUSTOMER_ID = :cusId ");
		}
		if(StringUtil.isNotBlank(type)){
			buffer.append(" AND c.TYPE=:type ");
		}
		return baseDao.queryforSplitPageInfo(pageInfo,buffer.toString(), params);
	}

	@Override
	public int queryMainufacturerCount(Map<String, String> params) {
		String type = params.get("type");
		String cusId = params.get("cusId");
		String mainufacturerName=params.get("mainufacturerName");//厂商/集成商名称
		params.put("mainufacturerName", "%"+mainufacturerName+"%");
		StringBuilder buffer= new StringBuilder("SELECT count(*) FROM CMDB_MAINUFACTURER c WHERE c.STATE=1 ");
		if(StringUtil.notEmpty(mainufacturerName)){
			buffer.append(" AND c.ZH_NAME LIKE :mainufacturerName");
		}
		if(StringUtil.notEmpty(cusId)){
			buffer.append(" AND c.CUSTOMER_ID = :cusId ");
		}
		if(StringUtil.isNotBlank(type)){
			buffer.append(" AND c.TYPE=:type ");
		}
		return baseDao.queryForInteger(buffer.toString(),params);
	}
	
	@Override
	public PageInfo queryContactPersonData(PageInfo pageInfo,Map<String, String> params) {
		String cusId = params.get("cusId");
		String id = params.get("id");//公司编号
		StringBuilder buffer= new StringBuilder("SELECT p.*,c.TYPE,c.ZH_NAME ");
		buffer.append("FROM CMDB_MAINUFACTURER_CONTACTS p,CMDB_MAINUFACTURER c WHERE p.MAINUFACTUREERID=c.ID AND p.DEL_FLAG=1 AND c.STATE=1");
		if(StringUtil.notEmpty(id)){
			buffer.append(" AND c.ID = :id");
		}
		if(StringUtil.notEmpty(cusId)){
			buffer.append(" AND c.CUSTOMER_ID = :cusId ");
		}
		return baseDao.queryforSplitPageInfo(pageInfo, buffer.toString(), params);
	}
	@Override
	public int queryContactPersonCount(Map<String, String> params) {
		String cusId = params.get("cusId");
		String id = params.get("id");//公司编号
		params.put("id", id);
		StringBuilder buffer= new StringBuilder("SELECT count(*) FROM CMDB_MAINUFACTURER_CONTACTS p,CMDB_MAINUFACTURER c WHERE p.MAINUFACTUREERID=c.ID ");
		buffer.append(" AND p.DEL_FLAG=1 AND c.STATE=1");
		if(StringUtil.notEmpty(id)){
			buffer.append(" AND c.ID = :id");
		}
		if(StringUtil.notEmpty(cusId)){
			buffer.append(" AND c.CUSTOMER_ID = :cusId ");
		}
		return baseDao.queryForInteger(buffer.toString(),params);
	}
	
	@Override
	public PageInfo queryContactsData(PageInfo pageInfo,Map<String, String> params) {
		String cusId=params.get("cusId");
		String contactName=params.get("contactName");//通讯录人员名称
		params.put("contactName", "%"+contactName+"%");
		StringBuilder buffer=new StringBuilder("SELECT C.*,A.CUSTOMER_NAME FROM CUSTOMER_CONTACTS C,SC_PARTNER_CUSTOMER_INFO A  WHERE C.CUSTOMER_ID = A.ID AND C.STATE=1");
		if(StringUtil.notEmpty(contactName)){
			buffer.append(" AND C.CONTACT_NAME LIKE :contactName");
		}
		if(StringUtil.notEmpty(cusId)){
			buffer.append(" AND C.CUSTOMER_ID = :cusId ");
		}
		
		
		return baseDao.queryforSplitPageInfo(pageInfo,buffer.toString(), params);
	}
	@Override
	public int queryConttactsCount(Map<String, String> params) {
		String cusId=params.get("cusId");
		String contactName=params.get("contactName");//通讯录人员名称
		params.put("contactName", "%"+contactName+"%");
		StringBuilder buffer=new StringBuilder("SELECT count(*) FROM CUSTOMER_CONTACTS c WHERE c.STATE=1");
		if(StringUtil.notEmpty(contactName)){
			buffer.append(" AND c.CONTACT_NAME LIKE :contactName");
		}
		if(StringUtil.notEmpty(cusId)){
			buffer.append(" AND C.CUSTOMER_ID = :cusId ");
		}
		
		
		return baseDao.queryForInteger(buffer.toString(), params);
	}

	@Override
	public Map getcontactPersonDetail(String id) {
		String sql = "SELECT P.* ,C.MANUFACTURERNAME,C.TYPE FROM CMDB_MAINUFACTURER_CONTACTS P,CMDB_MAINUFACTURER C WHERE P.MAINUFACTUREERID=C.ID AND P.ID = :id ";
	    Map param = new HashMap();
	    param.put("id", id);
	    Map msg = baseDao.queryForMap(sql, param);
		return msg;
	}

}