package com.shlanbao.tzsc.pms.cos.brand.service.impl;

import java.util.ArrayList;
import java.util.Hashtable;
import java.util.Iterator;
import java.util.List;

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

import com.shlanbao.tzsc.base.dao.BaseDaoI;
import com.shlanbao.tzsc.base.dao.CosIncompleteCoefficientDaoI;
import com.shlanbao.tzsc.base.dao.CosIncompleteStandardDaoI;
import com.shlanbao.tzsc.base.dao.CosPartWeightDaoI;
import com.shlanbao.tzsc.base.dao.EqmipmentsDaoI;
import com.shlanbao.tzsc.base.dao.MdMatTypeDaoI;
import com.shlanbao.tzsc.base.mapping.MdEquipment;
import com.shlanbao.tzsc.base.model.DataGrid;
import com.shlanbao.tzsc.base.model.PageParams;
import com.shlanbao.tzsc.base.service.BaseService;
import com.shlanbao.tzsc.pms.cos.brand.beans.BrandBean;
import com.shlanbao.tzsc.pms.cos.brand.beans.CostsExamine;
import com.shlanbao.tzsc.pms.cos.brand.beans.SeachBean;
import com.shlanbao.tzsc.pms.cos.brand.service.BrandServiceI;
import com.shlanbao.tzsc.pms.isp.beans.RollerPackerGroup;
import com.shlanbao.tzsc.utils.tools.MathUtil;
import com.shlanbao.tzsc.utils.tools.StringUtil;
import com.shlanbao.tzsc.utils.tools.SystemConstant;
/**
 * @ClassName: BrandServiceImpl 
 * @Description: 成本考核Service实现类
 * @author luo
 * @date 2015年1月21日 下午3:21:17 
 *
 */
@Service
public class BrandServiceImpl extends BaseService implements BrandServiceI {

	//滤棒，卷烟纸，接装纸 物料类型ID
	public static final String LB="4";
	public static final String JYZ="2";
	public static final String JZZ="3";
	//包装机：小盒商标纸，条盒商标纸，小盒烟膜，条盒烟膜，内衬纸；  物料类型ID
	public static final String XHSBZ="7";
	public static final String THSBZ="8";
	public static final String XHYM="5";
	public static final String THYM="6";
	public static final String NCZ="9";
	//成型：盘纸
	public static final String PZ="13";
	
	public static final boolean isCalculate=false;//是否计算消耗为0的奖罚金额
	
	@Autowired
	private BaseDaoI<Object> baseDao;
	
	@Autowired
	private MdMatTypeDaoI mdMatTypeDao; 
	
	@Autowired
	private EqmipmentsDaoI equipmentsDao;
	
	@Autowired
	private CosIncompleteStandardDaoI cosIncompleteStandardDao;
	
	@Autowired
	private CosPartWeightDaoI cosPartWeightDao;
	
	@Autowired
	private CosIncompleteCoefficientDaoI incompleteCoefficientDao;
	
	//残烟丝计算系数
	private Hashtable<String,Double> incompleteCoefficient;
	
	public Hashtable<String, Double> getIncompleteCoefficient() {
		if(incompleteCoefficient==null||incompleteCoefficient.keySet().size()<1){
			return incompleteCoefficientDao.queryModulusHT();
		}
		return incompleteCoefficient;
	}

	//成型机综合成本管理查询
	@Override
	public DataGrid queryBrand_chengxing(boolean isShift,boolean isWorkorder,SeachBean seachBean, PageParams pageParams) throws Exception {
		//获取产量和消耗量
		List<Object[]> list = getProduceByTime(isShift,isWorkorder,seachBean);
		//获取辅料的上下限值、标准值、单价、考核单价信息
		Hashtable<String,String[]> ht=hqlAssembly();
		//根据产量、消耗和标准获取BrandBean
		List<BrandBean> beans = getBradBeansByEqpType(list,ht);
		//BrandBean转CostsExamine
		List<CostsExamine> lists=convertBean(beans);
		//return DataGrid
		return new DataGrid(lists,Long.valueOf(lists.size()));
	}
	
	/**
	* @Title: getBradBeansByEqpType 
	* @Description: 根据产量、消耗量和标准获取BrandBean集合 
	* @param  list 产量和消耗量
	* @param  ht   标准  key=牌号+机型+辅料  value=String[]
	* @return List<BrandBean>    返回类型 
	* @throws
	 */
	public List<BrandBean> getBradBeansByEqpType(List<Object[]> list,Hashtable<String,String[]> ht){
		List<BrandBean> beans = new ArrayList<BrandBean>();
		for (Object[] objects : list) {
			BrandBean bb=new BrandBean();
			//牌号+机型+辅料
			String key=String.valueOf(objects[0])+String.valueOf(objects[2])+String.valueOf(objects[7]);
			//获取标准
			String[] standard=ht.get(key);
			//object 转 string
			String[] temp = new String[objects.length];
			for(int i=0;i<objects.length;i++){
				temp[i]=String.valueOf(objects[i]);
			}
			// 牌号 0、设备名称1、设备机型2、工单号3、批次号4、工单日期5、总产量6、辅料的名称7、消耗量8
			//辅料单位9、工单类型10、班组11、辅料类型12、牌号单位13、辅料类型ID14
			bb.setEqdType(temp[1]);
			bb.setMatName(temp[0]);
			bb.setBatch(temp[4]);
			bb.setQty(pasetDouble(temp[6]));
			bb.setFmatName(temp[7]);
			bb.setFqty(pasetDouble(temp[8]));
			bb.setFunit(temp[9]);
			bb.setTeam(temp[11]);
			bb.setTeamName(temp[11]);
			if(StringUtil.notNull(temp[5])&&temp[5].length()>12){
				bb.setTime(temp[5].substring(0, 11));
			}
			bb.setWorkOrderId(temp[3]);
			bb.setFmatType(temp[12]);
			bb.setFmatTypeID(temp[14]);
			bb.setEqdID(temp[15]);
			bb.setEqdCode(temp[16]);
			bb.setShiftId(temp[17]);
			bb.setShiftName(temp[18]);
			bb.setExcluding(pasetDouble(temp[19]));
			Hashtable<String,String[]> h=new Hashtable<String,String[]>();
			//辅料类型
			String k=temp[12];
			//单耗/单位/标准单耗/单位/消耗量/单价/总成本/单箱成本/奖罚单价/奖罚金额
			String[] t=new String[10];
			if(bb.getQty()>0)
				t[0]=String.valueOf(MathUtil.roundHalfUp((bb.getFqty()*1.00)/bb.getQty(),2));
			t[1]=temp[9]+"/"+temp[13];
			if(standard!=null){
				t[2]=standard[8];
				t[3]=standard[11];
				t[5]=standard[6];
				t[6]=String.valueOf(pasetDouble(standard[6])*bb.getFqty());
				if(bb.getQty()>0)
					t[7]=String.valueOf(MathUtil.roundHalfUp(bb.getFqty()*pasetDouble(standard[6])*1.00/bb.getQty(),2));
				t[8]=standard[7];
				//辅料奖罚金额=(定额单耗*产量-消耗量)*奖罚金额
				
				if(isCalculate||bb.getFqty()>0){
					t[9]=String.valueOf(MathUtil.roundHalfUp((pasetDouble(standard[8])*bb.getQty()-bb.getFqty())*pasetDouble(standard[7]),2));
				}
			}
			t[4]=String.valueOf(bb.getFqty());
			h.put(k,t);
			bb.setHt(h);
			beans.add(bb);
		}
		return beans;
	}
	//卷包机组
	@Override
	public DataGrid queryBrandCos_juanbao(boolean isDisabled,boolean isWorkorder,SeachBean seachBean, PageParams pageParams,List<RollerPackerGroup> rollerPackerGroup) throws Exception {
		//获取设备集合
		List<MdEquipment> equipments = equipmentsDao.query("from MdEquipment o where o.mdWorkshop.id='1'");
		Hashtable<String,String> equipmentHT=new Hashtable<String,String>();
		for(MdEquipment e:equipments){
			equipmentHT.put(e.getEquipmentCode(),e.getEquipmentName());
		}
		//卷接机数据集合
		seachBean.seteType("1");
		DataGrid dg=queryBrand_chengxing(true,isWorkorder,seachBean,new PageParams());
		List<CostsExamine> costs1=dg.getRows();
		//包装机数据集合
		seachBean.seteType("2");
		DataGrid dg2=queryBrand_chengxing(true,isWorkorder,seachBean,new PageParams());
		List<CostsExamine> costs2=dg2.getRows();
		//bean 转 Hashtable 
		Hashtable<String,CostsExamine> ht=new Hashtable<String,CostsExamine>();
		for(CostsExamine c:costs2){
			//key=设备+牌号+班组+班次
			String key=c.getEqdType()+c.getMatName()+c.getTeam()+c.getShiftName();
			ht.put(key,c);
		}
		//key 卷接机 code value RollerPackerGroup
		Hashtable<String,RollerPackerGroup> roolerHT=new Hashtable<String,RollerPackerGroup>();
		//卷接机和包装机的对应关系
		for(RollerPackerGroup roller: rollerPackerGroup){
			roolerHT.put(roller.getrCode(), roller);
		}
		List<CostsExamine> returnBean=new ArrayList<CostsExamine>();
		for(CostsExamine c:costs1){
			//根据卷接机设备code获取包装机设备code
			RollerPackerGroup pCode=roolerHT.get(c.getEqdCode());
			String key="";
			if(pCode!=null){
				//根据设备code查找设备名称
				String equName=equipmentHT.get(pCode.getpCode());
				c.setEqdType(pCode.getGroupName());
				if(equName==null){
					log.error("根据卷接机设备Code"+c.getEqdID()+"/"+c.getEqdType()+",获取包装机Code异常,group.xml配置信息错误。");
				}
				key+=equName;
			}else{
				log.error("根据卷接机设备Code"+c.getEqdID()+"/"+c.getEqdType()+",不能获取包装机Code,group.xml配置信息错误。");
			}
			key+=c.getMatName()+c.getTeam()+c.getShiftName();
			//根据key值取出 包装机的数据
			CostsExamine bean=ht.get(key);
			if(bean!=null){
				//把包装机的数据bean保存到卷烟机bean
				c=saveToBean(isDisabled,c,bean);
			}else{
				c.setJqty(c.getQty());//卷烟机产量
				c.setJunit(c.getUnit());//卷烟机产量单位
				//获取不到包装机时，机组产量为0
				c.setQty(0);//包装机产量
				c.setUnit("");//包装机单位
			}
			returnBean.add(c);
		}
		return new DataGrid(returnBean,Long.parseLong(returnBean.size()+""));
	}
	/**
	 * @description 查询产量和消耗
	 * @param bean
	 * @param isWorkorder 是否显示工单
	 * @param isShift 是否显示班次
	 * @return
	 */
	private List<Object[]> getProduceByTime(boolean isShift,boolean isWorkorder,SeachBean seachBean){
		//
		StringBuffer hql = new StringBuffer();
		hql.append("select o.schStatOutput.schWorkorder.mdMat.name,");// 牌号 0
		hql.append(" o.schStatOutput.schWorkorder.mdEquipment.equipmentName,");//设备名称1
		hql.append(" o.schStatOutput.schWorkorder.mdEquipment.mdEqpType.name,");//设备机型2
		if(isWorkorder){
			hql.append(" o.schStatOutput.schWorkorder.code,");//工单号3
			hql.append(" o.schStatOutput.schWorkorder.bth,");//批次号4
			hql.append(" o.schStatOutput.schWorkorder.date,");//工单日期5
		}else{
			hql.append(" '工单',");//工单号3
			hql.append(" '批次',");//批次号4
			hql.append(" '工单日期',");//工单日期5
		}
		hql.append(" sum(o.schStatOutput.qty-o.schStatOutput.badQty), ");   //总产量6
		hql.append(" o.mdMat.name, ");   //辅料的名称7
		hql.append(" sum(o.qty), ");   //消耗量8
		hql.append(" o.mdUnit.name ");   //单位9
		hql.append(",o.schStatOutput.schWorkorder.type ");//工单类型  1卷烟机工单、2包装机工单、3封箱机工单、4成型机工单10
		hql.append(",o.schStatOutput.schWorkorder.mdTeam.name ");//班组11
		hql.append(",o.mdMat.mdMatType.name ");   //辅料类型12
		hql.append(",o.schStatOutput.schWorkorder.mdUnit.name ");   //牌号单位13
		hql.append(",o.mdMat.mdMatType.id ");   //辅料类型ID 14
		hql.append(",o.schStatOutput.schWorkorder.mdEquipment.id ");//设备ID15
		hql.append(",o.schStatOutput.schWorkorder.mdEquipment.equipmentCode ");//设备codeID16
		if(isShift){
			hql.append(",o.schStatOutput.schWorkorder.mdShift.id ");//班次ID 17
			hql.append(",o.schStatOutput.schWorkorder.mdShift.name ");//班次名称 18
		}else{
			hql.append(",'班次ID' ");//班次ID 
			hql.append(",'班次名称' ");//班次名称
		}
		hql.append(",sum(o.schStatOutput.badQty) ");//剔除量19
		hql.append(" from SchStatInput o ");
		hql.append("where 1=1 and o.schStatOutput.del=0 ");//卷烟机和包装机
		if(StringUtil.notNull(seachBean.getMdMatId())){
			hql.append("and o.schStatOutput.schWorkorder.mdMat.id = '"+seachBean.getMdMatId()+"' ");
		}
		//机组code,可多匹配
		if(StringUtil.notNull(seachBean.geteName())){
			if(StringUtil.notNull(parseString(seachBean.geteName()))){
				hql.append("and o.schStatOutput.schWorkorder.mdEquipment.id in ("+parseString(seachBean.geteName())+") ");
			}
		}
		//车间
		if(StringUtil.notNull(seachBean.getWorkshop())){
			hql.append("and o.schStatOutput.schWorkorder.mdEquipment.mdWorkshop ='"+seachBean.getWorkshop()+"' ");
		}
		//开始时间
		if(StringUtil.notNull(seachBean.getStartTime())){
			hql.append("and o.schStatOutput.schWorkorder.date >= to_date('"+seachBean.getStartTime()+"','yyyy-MM-dd') ");
		}
		//结束时间
		if(StringUtil.notNull(seachBean.getEndTime())){
				hql.append("and o.schStatOutput.schWorkorder.date <= to_date('"+seachBean.getEndTime()+"','yyyy-MM-dd') ");
		}
		//班组
		if(StringUtil.notNull(seachBean.getTeam())){
			if(StringUtil.notNull(parseString(seachBean.getTeam()))){
				hql.append("and o.schStatOutput.schWorkorder.mdTeam.id in ("+parseString(seachBean.getTeam())+") ");
			}
		}
		//卷接工单、包装工单、成型工单
		if(StringUtil.notNull(seachBean.geteType())){
			hql.append("and o.schStatOutput.schWorkorder.type = '"+seachBean.geteType()+"' ");
		}
		//hql.append("order by o.schStatOutput.schWorkorder.mdEquipment.mdEqpType.name,o.schStatOutput.schWorkorder.mdMat.name ");
		hql.append("group by o.schStatOutput.schWorkorder.mdMat.name ");
		if(isWorkorder){
			hql.append(",o.schStatOutput.schWorkorder.code ");//工单号3
			hql.append(",o.schStatOutput.schWorkorder.bth ");//批次号4
			hql.append(",o.schStatOutput.schWorkorder.date ");//工单日期5
		}
		if(isShift){
			hql.append(",o.schStatOutput.schWorkorder.mdShift.id ");//班次ID 17
			hql.append(",o.schStatOutput.schWorkorder.mdShift.name ");//班次名称 18
		}
		hql.append(",o.mdMat.name,o.mdUnit.name,o.schStatOutput.schWorkorder.type ");
		hql.append(",o.schStatOutput.schWorkorder.mdEquipment.equipmentName,o.schStatOutput.schWorkorder.mdEquipment.mdEqpType.name ");
		hql.append(",o.schStatOutput.schWorkorder.mdTeam.name,o.mdMat.mdMatType.name,o.schStatOutput.schWorkorder.mdUnit.name ");
		hql.append(",o.mdMat.mdMatType.id,o.schStatOutput.schWorkorder.mdEquipment.id ");
		hql.append(",o.schStatOutput.schWorkorder.mdEquipment.equipmentCode ");
		return baseDao.queryObjectArray(String.valueOf(hql));
	}
	//Object to double
	private double pasetDouble(Object value){
		try{
			return Double.parseDouble(value+"");
		}catch(Exception e){
			return 0.0;
		}
	}
	//数据转换 1,2,3,4 转换成 '1','2','3','4'
	private String parseString(String value){
		String[] obj=value.split(",");
		String temp="";
		for(String o:obj){
			if(o.equals("")){continue;} 
			temp+=",'"+o+"'";
		}
		if(temp.length()<2){return "";}
		return temp.substring(1, temp.length());
	}
	
	/**
	 * 卷烟机辅料 单耗上下限值、单价、奖罚单价
	 * @param workOrderId 工单id
	 * @param pageParams
	 * @return
	 * @throws Exception 
	 * 1、牌号名称
	 * 2、机型ID
	 * 3、设备名称
	 * 4、机型
	 * 5、辅料名称
	 * 6、辅料类型
	 * 7、辅料单价
	 * 8、奖罚单价
	 * 9、辅料单耗标准值
	 * 10、辅料单耗上限
	 * 11、辅料单耗下限
	 * 12、单耗单位
	 */
	private Hashtable<String ,String[]> hqlAssembly() throws Exception{
		StringBuffer hql = new StringBuffer();
		hql.append("select cosp.cid.mdMat.name ");//牌号名称0
		hql.append(",cosp.cid.eqpType.id ");//机型ID1
		hql.append(",eq.equipmentName ");//设备名称2
		hql.append(",cosp.cid.eqpType.name ");//机型3
		hql.append(",cosp.mat.name ");//辅料名称4
		hql.append(",cosp.mat.mdMatType.code ");//辅料类型5
		hql.append(",mpm.matPrice ");//辅料单价6
		hql.append(",cosp.unitprice ");//奖罚单价7
		hql.append(",cosp.val ");//辅料单耗标准值8
		hql.append(",cosp.uval ");//辅料单耗上限9
		hql.append(",cosp.lval ");//辅料单耗下限10
		hql.append(",cosp.stdID.des ");//单耗单位11
		hql.append("from CosMatAssessParam cosp ");
		hql.append(", MdEquipment eq ");
		hql.append(", CosMatPriceMaintain mpm ");
		hql.append("where cosp.cid.eqpType.id =eq.mdEqpType.id ");
		hql.append("and mpm.mdMat.id=cosp.mat.id ");
		hql.append("and cosp.cid.status='生效' ");
		List<Object[]> list = baseDao.queryObjectArray(String.valueOf(hql));
		Hashtable<String ,String[]> ht=new Hashtable<String,String[]>();
		for(Object[] objects : list){
			String[] temp = new String[objects.length];
			for(int i=0;i<temp.length;i++){
				temp[i]=String.valueOf(objects[i]);
			}
			//key=牌号+机型+辅料
			ht.put(temp[0]+temp[3]+temp[4], temp);
		}
		return ht;
	}
	//bean转换
	public List<CostsExamine> convertBean(List<BrandBean> list){
		//key牌号 value Bean
		Hashtable<String,CostsExamine> h=new Hashtable<String,CostsExamine>();
		
		for(BrandBean bb:list){
			CostsExamine costs=new CostsExamine();
			//工单+批次+牌号+机组+班组+班次
			String key=bb.getWorkOrderId()+bb.getBatch()+bb.getMatName()+bb.getEqdType()+bb.getTeamName()+bb.getShiftName();
			if(h.get(key)!=null){
				costs=h.get(key);
			}else{
				costs.setEqdID(bb.getEqdID());
				costs.setEqdType(bb.getEqdType());
				costs.setMatName(bb.getMatName());
				costs.setQty(bb.getQty());
				costs.setUnit(bb.getUnit());
				costs.setTeam(bb.getTeam());
				costs.setTeamName(bb.getTeamName());
				costs.setTime(bb.getTime());
				costs.setWorkOrderId(bb.getWorkOrderId());
				costs.setBatch(bb.getBatch());
				costs.setEqdCode(bb.getEqdCode());
				costs.setShiftID(bb.getShiftId());
				costs.setShiftName(bb.getShiftName());
				costs.setExcluding_B(bb.getExcluding());
			}
			Hashtable<String,String[]> ht=bb.getHt();
			//根据辅料类型 获取单耗成本信息
			String[] standard=ht.get(bb.getFmatType());
			if(standard==null){
				h.put(bb.getWorkOrderId()+bb.getBatch(),costs);
				continue;
			}		
			//单耗/单位/标准单耗/单位/消耗量/单价/总成本
			if(bb.getFmatTypeID().equals(LB)){
				costs.setConsumption1(pasetDouble(standard[0]));
				costs.setUnit1(standard[1]);
				costs.setConsumStand1(pasetDouble(standard[2]));
				costs.setCunit1(standard[3]);
				costs.setConsumQty1(pasetDouble(standard[4]));
				costs.setUnitPrice1(pasetDouble(standard[5]));
				costs.setCountPrice1(pasetDouble(standard[6]));
				costs.setSingleCost1(pasetDouble(standard[7]));
				costs.setAward1(pasetDouble(standard[8]));
				costs.setAwardCount1(pasetDouble(standard[9]));
				costs.setFname1(bb.getFmatName());
				costs.setFunit1(bb.getFunit());
			}
			if(bb.getFmatTypeID().equals(JYZ)){
				costs.setConsumption2(pasetDouble(standard[0]));
				costs.setUnit2(standard[1]);
				costs.setConsumStand2(pasetDouble(standard[2]));
				costs.setCunit2(standard[3]);
				costs.setConsumQty2(pasetDouble(standard[4]));
				costs.setUnitPrice2(pasetDouble(standard[5]));
				costs.setCountPrice2(pasetDouble(standard[6]));
				costs.setSingleCost2(pasetDouble(standard[7]));
				costs.setAward2(pasetDouble(standard[8]));
				costs.setAwardCount2(pasetDouble(standard[9]));
				costs.setFname2(bb.getFmatName());
				costs.setFunit2(bb.getFunit());
			}
			if(bb.getFmatTypeID().equals(JZZ)){
				costs.setConsumption3(pasetDouble(standard[0]));
				costs.setUnit3(standard[1]);
				costs.setConsumStand3(pasetDouble(standard[2]));
				costs.setCunit3(standard[3]);
				costs.setConsumQty3(pasetDouble(standard[4]));
				costs.setUnitPrice3(pasetDouble(standard[5]));
				costs.setCountPrice3(pasetDouble(standard[6]));
				costs.setSingleCost3(pasetDouble(standard[7]));
				costs.setAward3(pasetDouble(standard[8]));
				costs.setAwardCount3(pasetDouble(standard[9]));
				costs.setFname3(bb.getFmatName());
				costs.setFunit3(bb.getFunit());
			}
			if(bb.getFmatTypeID().equals(XHSBZ)){
				costs.setConsumption4(pasetDouble(standard[0]));
				costs.setUnit4(standard[1]);
				costs.setConsumStand4(pasetDouble(standard[2]));
				costs.setCunit4(standard[3]);
				costs.setConsumQty4(pasetDouble(standard[4]));
				costs.setUnitPrice4(pasetDouble(standard[5]));
				costs.setCountPrice4(pasetDouble(standard[6]));
				costs.setSingleCost4(pasetDouble(standard[7]));
				costs.setAward4(pasetDouble(standard[8]));
				costs.setAwardCount4(pasetDouble(standard[9]));
				costs.setFname4(bb.getFmatName());
				costs.setFunit4(bb.getFunit());
			}
			if(bb.getFmatTypeID().equals(THSBZ)){
				costs.setConsumption5(pasetDouble(standard[0]));
				costs.setUnit5(standard[1]);
				costs.setConsumStand5(pasetDouble(standard[2]));
				costs.setCunit5(standard[3]);
				costs.setConsumQty5(pasetDouble(standard[4]));
				costs.setUnitPrice5(pasetDouble(standard[5]));
				costs.setCountPrice5(pasetDouble(standard[6]));
				costs.setSingleCost5(pasetDouble(standard[7]));
				costs.setAward5(pasetDouble(standard[8]));
				costs.setAwardCount5(pasetDouble(standard[9]));
				costs.setFname5(bb.getFmatName());
				costs.setFunit5(bb.getFunit());
			}
			if(bb.getFmatTypeID().equals(XHYM)){
				costs.setConsumption6(pasetDouble(standard[0]));
				costs.setUnit6(standard[1]);
				costs.setConsumStand6(pasetDouble(standard[2]));
				costs.setCunit6(standard[3]);
				costs.setConsumQty6(pasetDouble(standard[4]));
				costs.setUnitPrice6(pasetDouble(standard[5]));
				costs.setCountPrice6(pasetDouble(standard[6]));
				costs.setSingleCost6(pasetDouble(standard[7]));
				costs.setAward6(pasetDouble(standard[8]));
				costs.setAwardCount6(pasetDouble(standard[9]));
				costs.setFname6(bb.getFmatName());
				costs.setFunit6(bb.getFunit());
			}
			if(bb.getFmatTypeID().equals(THYM)){
				costs.setConsumption7(pasetDouble(standard[0]));
				costs.setUnit7(standard[1]);
				costs.setConsumStand7(pasetDouble(standard[2]));
				costs.setCunit7(standard[3]);
				costs.setConsumQty7(pasetDouble(standard[4]));
				costs.setUnitPrice7(pasetDouble(standard[5]));
				costs.setCountPrice7(pasetDouble(standard[6]));
				costs.setSingleCost7(pasetDouble(standard[7]));
				costs.setAward7(pasetDouble(standard[8]));
				costs.setAwardCount7(pasetDouble(standard[9]));
				costs.setFname7(bb.getFmatName());
				costs.setFunit7(bb.getFunit());
			}
			if(bb.getFmatTypeID().equals(NCZ)){
				costs.setConsumption8(pasetDouble(standard[0]));
				costs.setUnit8(standard[1]);
				costs.setConsumStand8(pasetDouble(standard[2]));
				costs.setCunit8(standard[3]);
				costs.setConsumQty8(pasetDouble(standard[4]));
				costs.setUnitPrice8(pasetDouble(standard[5]));
				costs.setCountPrice8(pasetDouble(standard[6]));
				costs.setSingleCost8(pasetDouble(standard[7]));
				costs.setAward8(pasetDouble(standard[8]));
				costs.setAwardCount8(pasetDouble(standard[9]));
				costs.setFname8(bb.getFmatName());
				costs.setFunit8(bb.getFunit());
			}
			if(bb.getFmatTypeID().equals(PZ)){
				costs.setConsumption9(pasetDouble(standard[0]));
				costs.setUnit9(standard[1]);
				costs.setConsumStand9(pasetDouble(standard[2]));
				costs.setCunit9(standard[3]);
				costs.setConsumQty9(pasetDouble(standard[4]));
				costs.setUnitPrice9(pasetDouble(standard[5]));
				costs.setCountPrice9(pasetDouble(standard[6]));
				costs.setSingleCost9(pasetDouble(standard[7]));
				costs.setAward9(pasetDouble(standard[8]));
				costs.setAwardCount9(pasetDouble(standard[9]));
				costs.setFname9(bb.getFmatName());
				costs.setFunit9(bb.getFunit());
			}
			h.put(key,costs);
		}
		List<CostsExamine> costsList=new ArrayList<CostsExamine>();
		for(Iterator itr = h.keySet().iterator(); itr.hasNext();){
			String key = (String) itr.next();
			CostsExamine value = h.get(key);
			if(value!=null){
				costsList.add(value);
			}
		}
		return costsList;
	}
	/**
	* @Title: saveToBean 
	* @Description: costs2部分熟悉熟悉添加到costs中
	* @param  isDisabled 是否统计残烟量
	* @param  costs output
	* @param  costs2 input
	* @return CostsExamine    返回类型 
	* @throws
	 */
	private CostsExamine saveToBean(boolean isDisabled,CostsExamine costs,CostsExamine costs2){
		
		costs.setExcluding_J(costs.getExcluding_B());
		costs.setExcluding_B(costs2.getExcluding_B());
		costs.setJqty(costs.getQty());//卷烟机产量
		costs.setJunit(costs.getUnit());//卷烟机产量单位
		costs.setQty(costs2.getQty());//包装机产量
		costs.setUnit(costs2.getUnit());//包装机单位
		if(isDisabled){
			if(StringUtil.notNull(costs.getMatName())){
				//根据牌号获取单支重量
				double weightMat=cosPartWeightDao.queryWeightByMatCode(costs.getMatName());
				if(weightMat==0.0){
					log.error("成本考核统计时，获取牌号“"+costs.getMatName()+"”烟支重量失败，请查找烟支重量设置界面确认。");
				}else{
					//根据班次ID和设备ID获取储烟量， 单位：支
					double f=cosIncompleteStandardDao.queryBeanByShiftAndEqpType(costs.getShiftID(), costs.getEqdID());
					if(f==0.0){
						log.error("成本考核统计时，根据班次“"+costs.getShiftID()+"”，设备ID“"+costs.getEqdID()+"”获取储烟量失败，请查找机台储烟量设置界面确认。");
					}
					//残烟量=卷烟机烟支总数 +综合残烟量-包装机产量-包装机剔除产量   ，单位：支
					double disabled=costs.getJqty()*SystemConstant.BOX_CIGARETTE_NUMBER+f-costs.getQty()*SystemConstant.BOX_CIGARETTE_NUMBER;
					//残烟量 公斤=支*单支重量
					disabled=disabled*weightMat;
					costs.setDisabled(disabled);
					//机台残烟率=（卷烟机烟支总数+综合残烟量-包装机产量）*烟支重量/包装机产量 
					//2015年1月22日09:01:36 此处按照设计文档来，但是 公斤除以箱 ，还需与客户确认或者现场进行调整
					if(costs.getQty()!=0.0){
						double disabledRate = MathUtil.roundHalfUp(disabled/costs.getQty(),2);
						costs.setDisabledRate(disabledRate);
						//残烟丝考核金额
						Hashtable<String,Double> ht=getIncompleteCoefficient();
						double rated=ht.get(SystemConstant.RATED_SINGLE_DISABLED_CODE);
						double award=ht.get(SystemConstant.RATED_SINGLE_DISABLED_AWARD_CODE);
						double punish=ht.get(SystemConstant.RATED_SINGLE_DISABLED_PUNISH_CODE);
						if(rated==0.0){
							log.error("根据编码“"+SystemConstant.RATED_SINGLE_DISABLED_CODE+"”获取残烟丝考核标准失败。");
						}
						if(award==0.0){
							log.error("根据编码“"+SystemConstant.RATED_SINGLE_DISABLED_AWARD_CODE+"”获取残烟丝考核奖励金额失败。");
						}
						if(punish==0.0){
							log.error("根据编码“"+SystemConstant.RATED_SINGLE_DISABLED_PUNISH_CODE+"”获取残烟丝考核处罚金额失败。");
						}
						//单箱残烟标准
						costs.setDisabledStandard(rated);
						//残烟一公斤奖励标准
						costs.setRewardStandard(award);
						//残烟一公斤处罚标准
						costs.setPunishStandard(punish);
						if(costs.getQty()!=0){
							//单箱残烟量=残烟量/产量
							costs.setSingleDisabled(MathUtil.roundHalfUp(disabled/costs.getQty(),2));
						}
						//如果单箱残烟量小于单箱残烟量标准值，则奖励，否则处罚。
						if(rated-costs.getSingleDisabled()>0){
							costs.setDisabledCheck(MathUtil.roundHalfUp((rated-costs.getSingleDisabled())*costs.getQty()*award,2));
						}else{
							costs.setDisabledCheck(MathUtil.roundHalfUp((rated-costs.getSingleDisabled())*costs.getQty()*punish,2));
						}
						//卷接机残烟率=（卷烟机烟支总数+综合残烟量-包装机产量-包装机剔除量）*烟支重量 /包装机产量
						costs.setDisabledRate_J(costs.getDisabledCheck());
						//包装机残烟率=包装机剔除量*烟支重量/包装机产量
						costs.setDisabledRate_B(MathUtil.roundHalfUp(costs.getExcluding_B()*weightMat/costs.getQty(),2));
						
					}else{
						log.error("成本考核中，产量为0。");
						costs.setDisabledRate(0.0);
					}
				}
			}else{
				log.error("成本考核统计时，牌号名称不存在。");
			}
		}
		
		costs.setConsumption4(costs2.getConsumption4());
		costs.setUnit4(costs2.getUnit4());
		costs.setConsumStand4(costs2.getConsumStand4());
		costs.setCunit4(costs2.getCunit4());
		costs.setConsumQty4(costs2.getConsumQty4());
		costs.setUnitPrice4(costs2.getUnitPrice4());
		costs.setCountPrice4(costs2.getCountPrice4());
		costs.setSingleCost4(costs2.getSingleCost4());
		costs.setAward4(costs2.getAward4());
		costs.setAwardCount4(costs2.getAwardCount4());
		costs.setFname4(costs2.getFname4());
		costs.setFunit4(costs2.getFunit4());
	
		costs.setConsumption5(costs2.getConsumption5());
		costs.setUnit5(costs2.getUnit5());
		costs.setConsumStand5(costs2.getConsumStand5());
		costs.setCunit5(costs2.getCunit5());
		costs.setConsumQty5(costs2.getConsumQty5());
		costs.setUnitPrice5(costs2.getUnitPrice5());
		costs.setCountPrice5(costs2.getCountPrice5());
		costs.setSingleCost5(costs2.getSingleCost5());
		costs.setAward5(costs2.getAward5());
		costs.setAwardCount5(costs2.getAwardCount5());
		costs.setFname5(costs2.getFname5());
		costs.setFunit5(costs2.getFunit5());
	
		costs.setConsumption6(costs2.getConsumption6());
		costs.setUnit6(costs2.getUnit6());
		costs.setConsumStand6(costs2.getConsumStand6());
		costs.setCunit6(costs2.getCunit6());
		costs.setConsumQty6(costs2.getConsumQty6());
		costs.setUnitPrice6(costs2.getUnitPrice6());
		costs.setCountPrice6(costs2.getCountPrice6());
		costs.setSingleCost6(costs2.getSingleCost6());
		costs.setAward6(costs2.getAward6());
		costs.setAwardCount6(costs2.getAwardCount6());
		costs.setFname6(costs2.getFname6());
		costs.setFunit6(costs2.getFunit6());
	
		costs.setConsumption7(costs2.getConsumption7());
		costs.setUnit7(costs2.getUnit7());
		costs.setConsumStand7(costs2.getConsumStand7());
		costs.setCunit7(costs2.getCunit7());
		costs.setConsumQty7(costs2.getConsumQty7());
		costs.setUnitPrice7(costs2.getUnitPrice7());
		costs.setCountPrice7(costs2.getCountPrice7());
		costs.setSingleCost7(costs2.getSingleCost7());
		costs.setAward7(costs2.getAward7());
		costs.setAwardCount7(costs2.getAwardCount7());
		costs.setFname7(costs2.getFname7());
		costs.setFunit7(costs2.getFunit7());
	
		costs.setConsumption8(costs2.getConsumption8());
		costs.setUnit8(costs2.getUnit8());
		costs.setConsumStand8(costs2.getConsumStand8());
		costs.setCunit8(costs2.getCunit8());
		costs.setConsumQty8(costs2.getConsumQty8());
		costs.setUnitPrice8(costs2.getUnitPrice8());
		costs.setCountPrice8(costs2.getCountPrice8());
		costs.setSingleCost8(costs2.getSingleCost8());
		costs.setAward8(costs2.getAward8());
		costs.setAwardCount8(costs2.getAwardCount8());
		costs.setFname8(costs2.getFname8());
		costs.setFunit8(costs2.getFunit8());
		
		return costs;
	}
}