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

import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Calendar;
import java.util.Date;
import java.util.List;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpSession;

import org.apache.log4j.Logger;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;

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.base.model.DataGrid;
import com.shlanbao.tzsc.base.model.Json;
import com.shlanbao.tzsc.base.model.PageParams;
import com.shlanbao.tzsc.pms.equ.lubricate.beans.EqmBubricantfBean;
import com.shlanbao.tzsc.pms.equ.lubricate.beans.EqmLubricantPlanBean;
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.params.SysEqpTypeBase;
import com.shlanbao.tzsc.utils.tools.DateUtil;
import com.shlanbao.tzsc.utils.tools.StringUtil;
/**
 * 
* @ClassName: EqmLubricantController 
* @Description: 设备润滑计划 
* @author luo
* @date 2015年7月8日 下午3:58:32 
*
 */
@Controller
@RequestMapping("/pms/lubrplan")
public class EqmLubricantPlanController {

	protected Logger log = Logger.getLogger(this.getClass());
	
	@Autowired
	public EqmLubricantPlanServiceI eqmLubricantPlanServiceI;
	
	
	@Autowired
	public EqmLubricantServiceI lubricantServiceI;
	
	@Autowired
	public EqmLubricantPlanServiceI lubricantPlanService;
	
	@Autowired
	public EqmLubricantPlanParamServiceI lubricantPlanParamService;
	
	@Autowired
	public SysEqpTypeServiceI sysEqpTypeServiceImpl;
	
	
	@RequestMapping("/goToAddLubiPlan")
	public String goToAddLubiPlan()throws Exception{
		return "/pms/equ/lubriplan/addLubriPlan";
	}
	@RequestMapping("/goToEditLubiPlan")
	public String goToEditLubiPlan(String id,HttpServletRequest request)throws Exception{
		if(StringUtil.notNull(id)){
			EqmLubricantPlanBean bean=eqmLubricantPlanServiceI.getBeanByIds(id);
			request.setAttribute("bean", bean);
			return "/pms/equ/lubriplan/editLubriPlan";
		}else{
			return "";
		}
	}
	
	/**
	 * 设备润滑计划新增
	 * @param object
	 * @return
	 * @throws Exception
	 */
	@ResponseBody
	@RequestMapping("/addLubrplan")
	public Json addLubrplan(EqmLubricantPlanBean bean,HttpServletRequest request,HttpSession session)throws Exception{
		Json json = new Json();
		try {
			
			json.setMsg("操作成功!");
			json.setSuccess(true);
		} catch (Exception e) {
			e.printStackTrace();
			json.setMsg("操作失败!");
			json.setSuccess(false);
		}
		return json;
	}
	
	/**
	 * 设备润滑计划修改
	 * @param object
	 * @return
	 * @throws Exception
	 */
	@ResponseBody
	@RequestMapping("/editLubrplan")
	public Json editLubrplan(EqmLubricantPlanBean bean,HttpServletRequest request)throws Exception{
		Json json = new Json();
		try {
			eqmLubricantPlanServiceI.updateBean(bean);
			json.setMsg("操作成功!");
			json.setSuccess(true);
		} catch (Exception e) {
			e.printStackTrace();
			json.setMsg("操作失败!");
			json.setSuccess(false);
		}
		return json;
	}
	
	@ResponseBody
	@RequestMapping("/queryLubrplan")
	public DataGrid queryLubrplan(EqmLubricantPlanBean bean,PageParams pageParams){
		try {
			return eqmLubricantPlanServiceI.queryDataGrid(bean,pageParams);
		} catch (Exception e) {
			e.printStackTrace();
			return null;
		}
	}
	
	
	/**
	 * 功能说明：设备润滑计划管理-添加
	 * @author wanchanghuang
	 * @time 2015年8月21日16:35:42
	 * 
	 * */
	@ResponseBody
	@RequestMapping("/addEqmLubricatPlan")
	public Json addEqmLubricatPlan(EqmBubricantfBean bean){
		Json json = new Json();
		SimpleDateFormat sdf=new SimpleDateFormat("yyyy-MM-dd");
		try {
			//日集合
			List<Date> dayDt=findDates(sdf.parse(bean.getDate_plan1()),sdf.parse( bean.getDate_plan2()));
			//月集合
			List<Date> periodDt=getMouthDay(bean.getDate_plan1(),bean.getDate_plan2());
			/*for(Date d: periodDt){
				System.out.println(sdf.format(d)+"  =================================");
			}*/
			//日润滑计划生成    天
			if(!"".equals(bean.getRuleId())){
				addDayLubricantPan(bean,dayDt); 
			}
			//周期性润滑-生成    周，月，年
			if(!"".equals(bean.getRuleIdf())){
				addPeriodLubricantPan(bean,dayDt,periodDt,sdf); //周期性润滑
			}   
			json.setMsg("操作成功!");
			json.setSuccess(true);
		} catch (Exception e) {
			e.printStackTrace();
			json.setMsg("操作失败!");
			json.setSuccess(false);
		}
		return json;
	}
	
	//周期性润滑-早，中，晚
	public void addPeriodLubricantPan(EqmBubricantfBean bean,List<Date> dayDt,List<Date> periodDt,SimpleDateFormat sdf) throws ParseException{
		SysEqpTypeBean sysEqpType=new SysEqpTypeBean();
		sysEqpType.setCategoryId(bean.getRuleIdf());
		//查询具体项周期值
		//List<SysEqpType> lists=sysEqpTypeServiceImpl.queryBean(sysEqpType);
		List<SysEqpTypeBean> lists=sysEqpTypeServiceImpl.querySysEqmTypeByCid(sysEqpType);
		if(lists.size()>0){
			for(SysEqpTypeBean s:lists){
				String unit_id=s.getUnit_id();
				if(SysEqpTypeBase.period_3.equals(unit_id)){ //月
						int lt=periodDt.size(); //日期数
						int f=2; //默认倍数
						int period=s.getPeriod(); //周期
						if(period==0){
							continue;
						}
						int dx=period;
						while(lt>=dx){
							Date d=periodDt.get(dx-1);
							System.out.println(new SimpleDateFormat("yyyy-MM-dd").format(d)+"  ===月===需要添加的值");
							if(d!=null){
								String shift_id=bean.getShift_id();
								if(shift_id.equals(SysEqpTypeBase.shift_0)){
									//早
									bean.setShift_id(SysEqpTypeBase.shift_1);
									saveEqmLubricantPlan(bean,s,sdf.format(d),unit_id);
									//中
									bean.setShift_id(SysEqpTypeBase.shift_2);
									saveEqmLubricantPlan(bean,s,sdf.format(d),unit_id);
									//晚
									bean.setShift_id(SysEqpTypeBase.shift_3);
									saveEqmLubricantPlan(bean,s,sdf.format(d),unit_id);
								}else{
								   saveEqmLubricantPlan(bean,s,sdf.format(d),unit_id);
								}
							}
							dx=f*period;
							f++;
						}
				}else if(SysEqpTypeBase.period_4.equals(unit_id)){ //年
						int lt=periodDt.size(); //日期数
						int f=2; //默认倍数
						int period=s.getPeriod()*12; //周期  12
						int dx=period;
						while(lt>=dx){
							Date d=periodDt.get(dx-1);
							//System.out.println(new SimpleDateFormat("yyyy-MM-dd").format(d)+"  ===年===需要添加的值");
							if(d!=null){
								String shift_id=bean.getShift_id();
								if(shift_id.equals(SysEqpTypeBase.shift_0)){
									//早
									bean.setShift_id(SysEqpTypeBase.shift_1);
									saveEqmLubricantPlan(bean,s,sdf.format(d),unit_id);
									//中
									bean.setShift_id(SysEqpTypeBase.shift_2);
									saveEqmLubricantPlan(bean,s,sdf.format(d),unit_id);
									//晚
									bean.setShift_id(SysEqpTypeBase.shift_3);
									saveEqmLubricantPlan(bean,s,sdf.format(d),unit_id);
								}else{
								   saveEqmLubricantPlan(bean,s,sdf.format(d),unit_id);
								}
							}
							dx=f*period;
							f++;
						}
				}else if(SysEqpTypeBase.period_2.equals(unit_id)){ //周
						int lt=dayDt.size(); //日期数
						int f=2; //默认倍数
						int period=s.getPeriod()*7; //周期  7
						int dx=period;
						while(lt>=dx){
							Date d=dayDt.get(dx-1);
							System.out.println(new SimpleDateFormat("yyyy-MM-dd").format(d)+"  ===周===需要添加的值");
							if(d!=null){
								String shift_id=bean.getShift_id();
								if(shift_id.equals(SysEqpTypeBase.shift_0)){
									//早
									bean.setShift_id(SysEqpTypeBase.shift_1);
									saveEqmLubricantPlan(bean,s,sdf.format(d),unit_id);
									//中
									bean.setShift_id(SysEqpTypeBase.shift_2);
									saveEqmLubricantPlan(bean,s,sdf.format(d),unit_id);
									//晚
									bean.setShift_id(SysEqpTypeBase.shift_3);
									saveEqmLubricantPlan(bean,s,sdf.format(d),unit_id);
								}else{
								   saveEqmLubricantPlan(bean,s,sdf.format(d),unit_id);
								}
							}
							dx=f*period;
							f++;
						}
				}
			}
		}
	}
	
	//周期性润滑- 插入EQM_LUBRICAT_PLAN表  {d-日期   unit_id周期表示} 
	public void saveEqmLubricantPlan(EqmBubricantfBean bean,SysEqpTypeBean s,String date,String unit_id) throws ParseException{
		String shift_id=bean.getShift_id();
		EqmLubricantPlanParam param=new EqmLubricantPlanParam();
		EqmLubricantPlan epl=new EqmLubricantPlan();
		/**
         * 日期，时间，班次，设备，周期类型，查询该条数据是否已经生成，
         *    如果没有生成，插入后返回Id，再插入 EQM_LUBRICAT_PLAN_PARAM 表
         *    如果已生成，直接获取ID，插入 EQM_LUBRICAT_PLAN_PARAM 表
		 * 
		 */
		List<?> listMdEquipMent=eqmLubricantPlanServiceI.addEqmLubricatPlan(bean);
		for(Object o:listMdEquipMent){
			Object[] temp=(Object[]) o;
			String eqp_id= temp[0].toString();
			EqmBubricantfBean ebf=sysEqpTypeServiceImpl.queryEqmLubricantPlanByPar(bean,date,unit_id,shift_id,eqp_id);
			if(ebf!=null){
				//直接插入子表
				param.setCode(DateUtil.formatDateToString(new Date(), "ss")+Math.random());
				param.setName(s.getName());
				param.setDes(s.getDes());
				param.setOiltd(s.getOilId());
				param.setFill_quantity(s.getFillQuantity());
				param.setFill_unit(s.getFillUnitName());
				param.setPlan_id(ebf.getId());
				param.setMethods(s.getFashionName());
				SysEqpType setf=new SysEqpType();
				setf.setId(s.getId());
				param.setSysEqpType(setf);
				lubricantPlanParamService.savePlanParams(param);
				
			}else{
				MdEquipment met=new MdEquipment();
				met.setId(eqp_id);
				epl.setEqp(met);
				epl.setDate_p(new SimpleDateFormat("yyyy-MM-dd").parse(date));
				epl.setLub_id(unit_id);
				epl.setCode(DateUtil.formatDateToString(new Date(), "ss")+Math.random());
				epl.setShift_id(shift_id);
				epl.setRule_id(bean.getRuleIdf());
				
				EqmLubricantPlan plan=lubricantPlanService.saveBean(epl);
				param.setCode(DateUtil.formatDateToString(new Date(), "ss")+Math.random());
				param.setName(s.getName());
				param.setDes(s.getDes());
				param.setOiltd(s.getOilId());
				param.setFill_quantity(s.getFillQuantity());
				param.setFill_unit(s.getFillUnitName());
				param.setPlan_id(plan.getId());
				param.setMethods(s.getFashionName());
				SysEqpType setf=new SysEqpType();
				setf.setId(s.getId());
				param.setSysEqpType(setf);
				lubricantPlanParamService.savePlanParams(param);
			}
		}
		
		
		
	}
	
	//日润滑
	public void addDayLubricantPan(EqmBubricantfBean bean,List<Date> dateLists) throws ParseException{
		//获得选中的所有设备
		/**
		 * id:4028998449c0f9650149c0fc428b0005	
		 * eqp_type_id:4028998449bcb4b10149bcb558780002	
		 * equipment_cde:31	
		 * equipment_name:1号包装机
		 * 
		 * */
		List<?> listMdEquipMent=eqmLubricantPlanServiceI.addEqmLubricatPlan(bean);
		for(Date d :dateLists){
			for(Object o:listMdEquipMent){
				Object[] temp=(Object[]) o;
				EqmLubricantPlan plan=new EqmLubricantPlan();
				plan.setEqp(new MdEquipment(temp[0].toString()));
				plan.setDate_p(d);//计划开始日期
				plan.setCode(DateUtil.formatDateToString(new Date(), "yyyyMMdd")+"E"+temp[2].toString());
				plan.setLub_id("1");//表示日润滑，周润滑，月润滑，年润滑
				plan.setRule_id(bean.getRuleId());
				plan.setStatus(0);
				String shift_id=bean.getShift_id();
				if(shift_id.equals(SysEqpTypeBase.shift_0)){ // 0表示 全部   
					//早
					plan.setShift_id(SysEqpTypeBase.shift_1);
					plan=lubricantPlanService.saveBean(plan);
					addLubricantPlanParam(bean,plan);
					//中
					plan.setShift_id(SysEqpTypeBase.shift_2);
					plan=lubricantPlanService.saveBean(plan);
					addLubricantPlanParam(bean,plan);
					//晚
					plan.setShift_id(SysEqpTypeBase.shift_3);
					plan=lubricantPlanService.saveBean(plan);
					addLubricantPlanParam(bean,plan);
				}else{
					plan.setShift_id(shift_id);
					//保存至设备润滑计划
					plan=lubricantPlanService.saveBean(plan);
					addLubricantPlanParam(bean,plan);
				}
				
			}
		}
	}
	
	//日润滑-插入计划子表
	public void addLubricantPlanParam(EqmBubricantfBean bean,EqmLubricantPlan plan){
		//获取设备润滑规则详细项
		SysEqpTypeBean sysEqpType=new SysEqpTypeBean();
		sysEqpType.setCategoryId(bean.getRuleId());
		//根据润滑规则查找到具体的项
		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);
		}
	}
		
	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);
		}
	}
	
	//获得两时间段所有日期集合
	public static List<Date> findDates(Date dBegin, Date dEnd) {  
		System.out.println(dBegin+"     "+dEnd);
        List<Date> lDate = new ArrayList<Date>();  
        lDate.add(dBegin);  
        Calendar calBegin = Calendar.getInstance();  
        // 使用给定的 Date 设置此 Calendar 的时间    
        calBegin.setTime(dBegin);  
        Calendar calEnd = Calendar.getInstance();  
        // 使用给定的 Date 设置此 Calendar 的时间    
        calEnd.setTime(dEnd);  
        // 测试此日期是否在指定日期之后    
        while (dEnd.after(calBegin.getTime())) {  
            // 根据日历的规则，为给定的日历字段添加或减去指定的时间量    
            calBegin.add(Calendar.DAY_OF_MONTH, 1);  
            lDate.add(calBegin.getTime());  
        }  
        return lDate;  
    }  
	
	public static List<Date> getMouthDay(String date1,String date2){
		SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
		List<Date> list= new ArrayList<Date>();
		try {
			Date d1= sdf.parse(date1);
			Date d2= sdf.parse(date2);
			Calendar dd= Calendar.getInstance();
			dd.setTime(d1);
			while(dd.getTime().before(d2)){
				Date str=dd.getTime();
				list.add(str);
				dd.add(Calendar.MONTH, 1);
			}
			Date str=dd.getTime();
			list.add(str);
			dd.add(Calendar.MONTH, 1);
		} catch (Exception e) {
			// TODO: handle exception
		}
		return list;
	}
	
	
	/**
	 * 批量删除用户
	 */
	@ResponseBody
	@RequestMapping("/deleteCycle")
	public Json deleteCycle(String ids){
		Json json=new Json();
		try {
			lubricantPlanService.deleteCycle(ids);
			json.setMsg("批量删除数据成功!");
			json.setSuccess(true);
		} catch (Exception e) {
			json.setMsg("批量删除数据失败!");
			json.setSuccess(false);
		}
		return json;
	}
	
	/**
	 * 返回日期列表
	 * @param date1
	 * @param date2
	 * @return
	 * @throws Exception
	 */
	public static List<Date> getMonthSpace(String date1, String date2,int d)
			throws Exception {
			List<Date> dates=new ArrayList<Date>();
			SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
			Calendar c1 = Calendar.getInstance();
			Calendar c2 = Calendar.getInstance();
			c1.setTime(sdf.parse(date1));
			c2.setTime(sdf.parse(date2));
			int result = (c2.get(Calendar.YEAR)-c1.get(Calendar.YEAR))*12+(c2.get(Calendar.MONTH) - c1.get(Calendar.MONTH));
			if(result==0){
				result=1;
			}
			for (int i = 0; i < result; i++) {
				c1.add(Calendar.MONTH, d);
				dates.add(c1.getTime());
			}
			return dates;
		}
	}