package cn.ksource.web.facade.deliverMent;

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.ConvertUtil;
import cn.ksource.core.util.DateUtil;
import cn.ksource.core.util.StringUtil;

/**
 * 交付管理接口实现
 * @author gaofazhan
 *2018-03-20
 */
@Service
public class DeliverMentFacadeImpl implements DeliverMentFacade{
	@Autowired
	private BaseDao baseDao;
	@SuppressWarnings({ "rawtypes", "unchecked" })
	@Override
	public PageInfo getDeliverMentData(Map param, PageInfo pageInfo) {
		String sql="select a.*,b.IS_STATE from sc_deliver a left join deliver_report b on a.id=b.plan_id  where a.state=1 ";
		String plan_name=ConvertUtil.obj2StrBlank(param.get("plan_name"));
		if(StringUtil.notEmpty(plan_name)){
			param.put("plan_name", "%"+plan_name+"%");
			sql+=" AND a.PLAN_NAME like :plan_name ";
		}
		String cusId=ConvertUtil.obj2StrBlank(param.get("cusId"));
		if(StringUtil.notEmpty(cusId)){
			sql+=" AND a.CUSTOMER_ID =:cusId ";
		}
		String subCusId=ConvertUtil.obj2StrBlank(param.get("subCusId"));
		if(StringUtil.notEmpty(subCusId)){
			sql+=" AND a.SUB_CUSTOMER_ID =:subCusId ";
		}
		String jfstate=ConvertUtil.obj2StrBlank(param.get("jfstate"));
		if(StringUtil.notEmpty(jfstate)){
			sql+=" AND a.JFSTATE=:jfstate ";
		}
		String plan_year=ConvertUtil.obj2StrBlank(param.get("plan_year"));
		if(StringUtil.notEmpty(plan_year)){
			sql+=" AND a.PLAN_YEAR=:plan_year ";
		}
		return baseDao.queryforSplitPageInfo(pageInfo, sql, param);
	}

	@SuppressWarnings({ "rawtypes", "unchecked" })
	@Override
	public int getDeliverMentCount(Map param) {
		String sql="select count(a.id) from sc_deliver a where a.state=1 ";
		String plan_name=ConvertUtil.obj2StrBlank(param.get("plan_name"));
		if(StringUtil.notEmpty(plan_name)){
			param.put("plan_name", "%"+plan_name+"%");
			sql+=" AND a.PLAN_NAME like :plan_name ";
		}
		String cusId=ConvertUtil.obj2StrBlank(param.get("cusId"));
		if(StringUtil.notEmpty(cusId)){
			sql+=" AND a.CUSTOMER_ID =:cusId ";
		}
		String subCusId=ConvertUtil.obj2StrBlank(param.get("subCusId"));
		if(StringUtil.notEmpty(subCusId)){
			sql+=" AND a.SUB_CUSTOMER_ID =:subCusId ";
		}
		String jfstate=ConvertUtil.obj2StrBlank(param.get("jfstate"));
		if(StringUtil.notEmpty(jfstate)){
			sql+=" AND a.JFSTATE=:jfstate ";
		}
		String plan_year=ConvertUtil.obj2StrBlank(param.get("plan_year"));
		if(StringUtil.notEmpty(plan_year)){
			sql+=" AND a.PLAN_YEAR=:plan_year ";
		}
		return baseDao.queryForInteger(sql, param);
	}

	@SuppressWarnings("rawtypes")
	@Override
	public Map getDeliverMent(Map param) {
		String sql="select * from sc_deliver where state=1 and id=:id ";
		return baseDao.queryForMap(sql, param);
	}
	@SuppressWarnings("rawtypes")
	@Override
	public Map getMent(Map param) {
		String sql="select * from deliver_report where plan_id=:id ";
		return baseDao.queryForMap(sql, param);
	}

	@SuppressWarnings({ "unchecked", "rawtypes" })
	@Override
	public void saveDeliverMent(Map param) {
		param.put("id", StringUtil.getUUID());
		param.put("create_time", DateUtil.getCurrentDate14());
		String sql="insert into sc_deliver(ID,PLAN_YEAR,CUSTOMER_ID,CUSTOMER_NAME,SUB_CUSTOMER_ID,SUB_CUSTOMER_NAME," +
				"PLAN_NAME,PLAN_ZZ,SY_RANGE,PLAN_ZTGS,PLAN_GLJH,PLAN_RYJH,PLAN_JSGL,PLAN_ZYGL,PLAN_GCGL,STATE," +
				"CREATE_TIME,USER_ID,USER_NAME,JFSTATE) values(:id,:plan_year,:customer_id,:customer_name," +
				":sub_customer_id,:sub_customer_name,:plan_name,:plan_zz,:sy_range,:plan_ztgs,:plan_gljh," +
				":plan_ryjh,:plan_jsgl,:plan_zygl,:plan_gcgl,1,:create_time,:userId,:userName,1)";
		baseDao.execute(sql, param);
	}

	@SuppressWarnings({ "rawtypes", "unchecked" })
	@Override
	public void updateDeliverMent(Map param) {
		param.put("plan_year", ConvertUtil.obj2StrBlank(param.get("plan_year")).substring(0, 4));
		String sql="update sc_deliver set PLAN_YEAR=:plan_year,CUSTOMER_ID=:customer_id," +
				"CUSTOMER_NAME=:customer_name,SUB_CUSTOMER_ID=:sub_customer_id,SUB_CUSTOMER_NAME=:sub_customer_name," +
				"PLAN_NAME=:plan_name,PLAN_ZZ=:plan_zz,SY_RANGE=:sy_range,PLAN_ZTGS=:plan_ztgs,PLAN_GLJH=:plan_gljh," +
				"PLAN_RYJH=:plan_ryjh,PLAN_JSGL=:plan_jsgl,PLAN_ZYGL=:plan_zygl,PLAN_GCGL=:plan_gcgl where id=:id";
		baseDao.execute(sql, param);
	}

	@SuppressWarnings({ "unchecked", "rawtypes" })
	@Override
	public void saveDeliverReport(Map param) {
		param.put("create_time", DateUtil.getCurrentDate14());
		param.put("id", StringUtil.getUUID());
		String sql="insert into deliver_report(ID,PLAN_ID,START_TIME,END_TIME,CUSTOMER_TEXT,PER_TEXT,AC_TEXT," +
				"FILE_TEXT,EPILOGUE_TEXT,CUSTOMER_SQ,PROTECT_AC,CUSTOMER_CHARGE,PROTECT_CHARGE,CUSTOMER_DATE," +
				"PROTECT_DATE,CREATE_TIME,USER_ID,USER_NAME,IS_STATE) values(:id,:plan_id,:start_time,:end_time,:customer_text,:per_text,:ac_text," +
				":file_text,:epilogue_text,:customer_sq,:protect_ac,:customer_charge,:protect_charge," +
				":customer_date,:protect_date,:create_time,:userId,:userName,:is_state)";
		baseDao.execute(sql, param);
		String sqla="update sc_deliver set jfstate=2 where id=:plan_id";
		baseDao.execute(sqla, param);
	}
	@SuppressWarnings({"rawtypes" })
	@Override
	public void updateDeliverReport(Map param) {
		String sql="update deliver_report set START_TIME=:start_time,END_TIME=:end_time,CUSTOMER_TEXT=:customer_text,PER_TEXT=:per_text," +
				"AC_TEXT=:ac_text,FILE_TEXT=:file_text,EPILOGUE_TEXT=:epilogue_text,CUSTOMER_SQ=:customer_sq," +
				"PROTECT_AC=:protect_ac,CUSTOMER_CHARGE=:customer_charge,PROTECT_CHARGE=:protect_charge," +
				"CUSTOMER_DATE=:customer_date,PROTECT_DATE=:protect_date,IS_STATE=:is_state where ID=:id";
		baseDao.execute(sql, param);
	}
	@SuppressWarnings("rawtypes")
	@Override
	public void delEmergencyPlan(Map param) {
		String sql="update sc_deliver set STATE=2 where id=:id ";
		baseDao.execute(sql, param);
	}

	@SuppressWarnings("rawtypes")
	@Override
	public Map getDeliverReport(Map param) {
		String sql="select *,a.USER_NAME userName,a.CREATE_TIME createTime from sc_deliver a left join deliver_report b on a.id=b.plan_id" +
				" where a.id=:id";
		return baseDao.queryForMap(sql, param);
	}

}