package com.shlanbao.tzsc.pms.equ.wcplan.service.impl;

import java.util.ArrayList;
import java.util.List;

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

import com.shlanbao.tzsc.base.dao.EqmWheelCovelParamDaoI;
import com.shlanbao.tzsc.base.mapping.EqmWheelCovelParam;
import com.shlanbao.tzsc.base.mapping.EqmWheelCovelPlan;
import com.shlanbao.tzsc.base.model.DataGrid;
import com.shlanbao.tzsc.pms.equ.wcplan.beans.EqmWheelCovelParamBean;
import com.shlanbao.tzsc.pms.equ.wcplan.service.EqmWheelCovelParamServiceI;
import com.shlanbao.tzsc.utils.tools.DateUtil;
import com.shlanbao.tzsc.utils.tools.StringUtil;

@Service
public class EqmWheelCovelParamServiceImpl implements EqmWheelCovelParamServiceI{

	@Autowired
	private EqmWheelCovelParamDaoI eqmWheelCovelParamDaoI;
	
	//查询
	@Override
	public DataGrid queryBeanList(EqmWheelCovelParamBean bean){
		StringBuffer hql=new StringBuffer();
		hql.append("from EqmWheelCovelParam o where 1=1 ");
		//班次
		if(StringUtil.notNull(bean.getShiftName())){
			hql.append("and o.pid.mdShift.id = '"+bean.getShiftName()+"' ");
		}
		//保养名称
		if(StringUtil.notNull(bean.getJobName())){
			hql.append("and o.pid.planName = '"+bean.getJobName()+"' ");
		}
		if(StringUtil.notNull(bean.getPid())){
			hql.append("and o.pid.id = '"+bean.getPid()+"' ");
		}
		//保养类型
		if(StringUtil.notNull(bean.getJobType())){
			hql.append("and o.pid.maintenanceType = '"+bean.getJobType()+"' ");
		}
		//时间比较
		if(bean.getStartTime()!=null){
			hql.append("and convert(varchar(23),o.planTime,23) >= '"+DateUtil.formatDateToString(bean.getStartTime(),"yyyy-MM-dd")+"' ");
		}
		if(bean.getEndTime()!=null){
			hql.append("and convert(varchar(23),o.planTime,23) <= '"+DateUtil.formatDateToString(bean.getEndTime(),"yyyy-MM-dd")+"' ");
		}
		List<EqmWheelCovelParam> list=eqmWheelCovelParamDaoI.query(hql.toString()+" order by o.planTime desc ");
		List<EqmWheelCovelParamBean> returnList=new ArrayList<EqmWheelCovelParamBean>();
		for(EqmWheelCovelParam param:list){
			returnList.add(mappingBean(param));
		}
		hql.insert(0,"select count(*) ");
		long total=eqmWheelCovelParamDaoI.queryTotal(hql.toString());
		return new DataGrid(returnList,total);
	}
	
	@Override
	public boolean updateBean(EqmWheelCovelParamBean bean){
		
		return false;
	}
	
	@Override
	public boolean addWheelCovelParam(EqmWheelCovelParam bean){
		return eqmWheelCovelParamDaoI.saveOrUpdate(bean);
	}
	
	/**
	 * 
	* @Title: mappingBean 
	* @Description: EqmWheelCovelParam Convert to EqmWheelCovelParamBean  
	* @param  param
	* @return EqmWheelCovelParamBean    返回类型 
	* @throws
	 */
	private EqmWheelCovelParamBean mappingBean(EqmWheelCovelParam param){
		/*EqmWheelCovelParamBean newBean=new EqmWheelCovelParamBean();
		newBean.setActualTime(param.getActualTime());
		newBean.setEnable(param.getEnable());
		newBean.setId(param.getId());
		newBean.setPlanTime(param.getPlanTime());
		if(param.getPid()!=null){
			newBean.setJobContext(param.getPid().getMaintenanceContent());
			newBean.setJobName(param.getPid().getPlanName());
			newBean.setJobType(param.getPid().getMaintenanceType());
			newBean.setPid(param.getPid().getId());
			if(param.getPid().getMdShift()!=null){
				newBean.setShiftName(param.getPid().getMdShift().getName());
			}
		}
		if(param.getUser()!=null)
		newBean.setUserName(param.getUser().getName());
		return newBean;
		*/
		return null;
	}
	//根据日期生产维保计划
	@Override
	public void buildWheelCovelPlan(){
		StringBuffer sqlBuffer=new StringBuffer();
		sqlBuffer.append("select ");
		sqlBuffer.append("GETDATE()+ cast(o.PERIOD as int) ");//计划执行日期0
		sqlBuffer.append(",o.EQU_ID ");//设备编号1
		sqlBuffer.append(",o.SHIFT ");//计划班次2
		sqlBuffer.append(",o.MAINTENANCE_TYPE ");//保养类型3
		sqlBuffer.append(",o.WHEEL_PARTS ");//保养部位4
		sqlBuffer.append(",PLAN_NAME ");//保养名称5
		sqlBuffer.append(",o.MAINTENANCE_CONTENT ");//保养内容6
		sqlBuffer.append(",o.id ");//ID7
		sqlBuffer.append(",o.PERIOD ");//周期8
		sqlBuffer.append("from EQM_WHEEL_COVEL_PLAN o ");
		sqlBuffer.append("where 1=1 and o.del=0  ");
		sqlBuffer.append("and o.SCHEDULE_DATE<=GETDATE() ");
		sqlBuffer.append("and o.SCHEDULE_end_DATE>=GETDATE() ");
		sqlBuffer.append("and o.WHEEL_COVER_TYPE='运行' ");
		//计划开始日期+周期=当前日期
		sqlBuffer.append("and ( CONVERT(nvarchar(21),o.SCHEDULE_DATE+CAST(o.PERIOD as int),23)=CONVERT(nvarchar(21),GETDATE(),23) ");
		//(当前日期-计划开始日期)%周期=0
		sqlBuffer.append("or datediff(DAY,getdate(),o.SCHEDULE_DATE)%cast(o.PERIOD as int)=0 )");
		List<?> list=eqmWheelCovelParamDaoI.queryBySql(sqlBuffer.toString());
		for(Object o:list){
			Object[] temp=(Object[])o;
			/*if(queryParamByPid(temp[7].toString(),Integer.parseInt(temp[8].toString()))){
				EqmWheelCovelParam bean=new EqmWheelCovelParam();
				bean.setPlanTime(temp[0].toString());
				bean.setEnable("0");
				//bean.setPid(new EqmWheelCovelPlan(temp[7].toString()));
				eqmWheelCovelParamDaoI.save(bean);
			}*/
		}		
	}
	/**
	 * 
	* @Title: queryParamByPid 
	* @Description: 根据Pid和周期查看是否已经生成维保计划  ，计划时间=当天时间+周期
	* @param  pid
	* @param  period
	* @return boolean    返回类型 
	* @throws
	 */
	private boolean queryParamByPid(String pid,int period){
		String sql="select count(*) from EqmWheelCovelParam o where pid='"+pid
				+"' and convert(nvarchar(23),getdate()+"+period+",23)=convert(nvarchar(23),o.planTime,23) ";
		long total=eqmWheelCovelParamDaoI.queryTotal(sql);
		if(total>0)
			return false;
		else
			return true;
	}
}