package com.shlanbao.tzsc.pms.equ.lubricate.runTime;

import java.util.Date;
import java.util.List;

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

import com.shlanbao.tzsc.base.mapping.EqmLubricant;
import com.shlanbao.tzsc.base.mapping.EqmLubricantPlan;
import com.shlanbao.tzsc.base.mapping.EqmLubricantPlanParam;
import com.shlanbao.tzsc.base.mapping.MdEquipment;
import com.shlanbao.tzsc.base.mapping.SysEqpType;
import com.shlanbao.tzsc.pms.equ.lubricate.service.EqmLubricantPlanParamServiceI;
import com.shlanbao.tzsc.pms.equ.lubricate.service.EqmLubricantPlanServiceI;
import com.shlanbao.tzsc.pms.equ.lubricate.service.EqmLubricantServiceI;
import com.shlanbao.tzsc.pms.sys.datadict.beans.SysEqpTypeBean;
import com.shlanbao.tzsc.pms.sys.datadict.service.SysEqpTypeServiceI;
import com.shlanbao.tzsc.utils.tools.DateUtil;

public class EqmLubricantPlanCreate {

	@Autowired
	public EqmLubricantServiceI lubricantServiceI;
	
	@Autowired
	public EqmLubricantPlanServiceI lubricantPlanService;
	
	@Autowired
	public EqmLubricantPlanParamServiceI lubricantPlanParamService;
	
	@Autowired
	public SysEqpTypeServiceI sysEqpTypeServiceImpl;
	
	
	public void createLubriPlan(){
		StringBuffer sqlBuffer=new StringBuffer();
		sqlBuffer.append("select l.ID l_id,e.ID e_id,e.EQUIPMENT_CODE e_code,l.CYCLE,lp.ID lp_id from EQM_LUBRICAT l ");
		sqlBuffer.append("left join MD_EQUIPMENT e on l.EQP_TYPE=e.EQP_TYPE_ID ");
		sqlBuffer.append("left join EQM_LUBRICAT_PLAN lp on l.ID=lp.LUB_ID and e.ID=lp.EQP_ID ");
		sqlBuffer.append("where lp.ID is null ");
		List<?> list=lubricantServiceI.getListBySql(sqlBuffer.toString());
		for(Object o:list){
			Object[] temp=(Object[])o;
			String lubri_id=temp[0].toString();
			String eqp_id=temp[1].toString();
			String eqp_code=temp[2].toString();
			createLubriPlan(lubri_id,eqp_id,eqp_code);
		}
		
	}
	
	public void createLubriPlan(String lubri_id,String eqp_id,String eqp_code){
		//查询设备润滑周期表
		EqmLubricant lubri=lubricantServiceI.getBeanById(lubri_id);
		EqmLubricantPlan plan=new EqmLubricantPlan();
		plan.setEqp(new MdEquipment(eqp_id));
		//plan.setDate_p(DateUtil.dateCals(new Date(),lubri.getCycle()));
		plan.setCode(DateUtil.formatDateToString(new Date(), "yyyyMMdd")+"E"+eqp_code);
		plan.setLub_id(lubri_id);
		//plan.setRule_id(lubri.getRule_id());
		plan.setStatus(0);
		//保存至设备润滑计划
		plan=lubricantPlanService.saveBean(plan);
		//获取设备润滑规则详细项
		SysEqpTypeBean sysEqpType=new SysEqpTypeBean();
		//sysEqpType.setCategoryId(lubri.getRule_id());
		//根据润滑规则查找到具体的项
		List<SysEqpType> lists=sysEqpTypeServiceImpl.queryBean(sysEqpType);
		//获取刚创建的设备润滑计划ID
		String plan_id=plan.getId();
		for(SysEqpType sys:lists){
			EqmLubricantPlanParam param=new EqmLubricantPlanParam();
			param.setCode(sys.getCode());
			param.setDes(sys.getDes());
			//润滑剂单位
			if(sys.getFillUnitBean()!=null){
				param.setFill_unit(sys.getFillUnitBean().getName());
			}
			param.setFill_quantity(sys.getFillQuantity());
			//润滑剂名称
			if(sys.getOilIdBean()!=null){
				param.setOiltd(sys.getOilIdBean().getLubricantName());
			}
			param.setName(sys.getName());
			param.setPlan_id(plan_id);
			//润滑方式
			if(sys.getFashionBean()!=null){
				param.setMethods(sys.getFashionBean().getName());
			}
			param.setSysEqpType(new SysEqpType(sys.getId()));
			lubricantPlanParamService.savePlanParams(param);
		}
	}
}