package com.shlanbao.tzsc.pms.equ.paul.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.BaseDaoI;
import com.shlanbao.tzsc.base.dao.EqmPaulDayDaoI;
import com.shlanbao.tzsc.base.mapping.EqmPaulDay;
import com.shlanbao.tzsc.base.mapping.EqmProtectRecordBean;
import com.shlanbao.tzsc.base.mapping.MdEqpCategory;
import com.shlanbao.tzsc.base.mapping.MdShift;
import com.shlanbao.tzsc.base.mapping.MdTeam;
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.equ.paul.beans.BatchBean;
import com.shlanbao.tzsc.pms.equ.paul.beans.EqmPaulDayBean;
import com.shlanbao.tzsc.pms.equ.paul.service.PaulDayServiceI;
import com.shlanbao.tzsc.pms.equ.wcplan.beans.EqmWheelCalendar;
import com.shlanbao.tzsc.utils.tools.DateUtil;
import com.shlanbao.tzsc.utils.tools.StringUtil;
@Service
public class PaulDayServiceImpl extends BaseService implements PaulDayServiceI {
	@Autowired
	private EqmPaulDayDaoI paulDayDao;
	@Autowired
	private BaseDaoI<Object> baseDao;
	/**
	 * 日保养查询
	 */
	@Override
	public DataGrid queryList(EqmPaulDayBean seachBean,PageParams pageParams) {
		StringBuffer hql=new StringBuffer();
		hql.append("select o.id,o.name, o.shift.id,");
		hql.append("o.shift.name,");
		hql.append("o.team.id,");
		hql.append("o.team.name,");
		hql.append("o.date_p,");
		hql.append("o.stim,");
		hql.append("o.etim,");
		hql.append("o.eqp_type.id,");
		hql.append("o.eqp_type.name,");
		hql.append("o.paul_id,");
		hql.append("o.del, ");
		hql.append("o.status ");
		hql.append("from EqmPaulDay o where o.del=0 ");
		if(StringUtil.notNull(seachBean.getId())){
			hql.append("and o.id='"+seachBean.getId()+"' ");
		}
		if(StringUtil.notNull(seachBean.getShiftId())){
			hql.append("and o.shift.id="+seachBean.getShiftId()+" ");
		}
		if(StringUtil.notNull(seachBean.getTeamId())){
			hql.append("and o.team.id="+seachBean.getTeamId()+" ");
		}
		if(StringUtil.notNull(seachBean.getEqp_type_id())){
			hql.append("and o.eqp_type.id='"+seachBean.getEqp_type_id()+"' ");
		}
		if(StringUtil.notNull(seachBean.getStim())){
			hql.append("and to_char( o.stim,'yyyy-MM-dd') >='"+seachBean.getStim()+"' ");
		}
		if(StringUtil.notNull(seachBean.getEtim())){
			hql.append("and to_char(o.etim,'yyyy-mm-dd') <='"+seachBean.getEtim()+"' ");
		}
		if(seachBean.getStatus()>-1){
			hql.append("and o.status='"+seachBean.getStatus()+"' ");
		}
		long total=baseDao.query(hql.toString()).size();
		hql.append("order by o.date_p,o.shift.code ");
		List<Object> list=baseDao.queryByPage(hql.toString(), pageParams);
		List<EqmPaulDayBean> returnList=new ArrayList<EqmPaulDayBean>();
		for(Object o:list){
			Object[] temp=(Object[]) o;
			EqmPaulDayBean b=new EqmPaulDayBean();
			b.setId(temp[0].toString());
			b.setName(temp[1].toString());
			b.setShiftId(temp[2].toString());
			b.setShiftName(temp[3].toString());
			b.setTeamId(temp[4].toString());
			b.setTeamName(temp[5].toString());
			b.setDate_p(temp[6].toString());
			b.setStim(temp[7].toString());
			b.setEtim(temp[8].toString());
			b.setEqp_type_id(temp[9].toString());
			b.setEqp_type_name(temp[10].toString());
			b.setPaul_id(temp[11].toString());
			b.setDel(Integer.parseInt(temp[12].toString()));
			b.setStatus(Integer.parseInt(temp[13].toString()));
			returnList.add(b);
		}
		return new DataGrid(returnList,total);
	}
	//新增
	@Override
	public boolean addPaulDayBean(EqmPaulDayBean bean){
		EqmPaulDay eqm=new EqmPaulDay();
		eqm.setEqp_type(new MdEqpCategory(bean.getEqp_type_id()));
		eqm.setStim(DateUtil.formatStringToDate(bean.getStim()));
		eqm.setEtim(DateUtil.formatStringToDate(bean.getEtim()));
		eqm.setName(bean.getName());
		eqm.setPaul_id(bean.getPaul_id());
		eqm.setDate_p(DateUtil.formatStringToDate(bean.getStim(),"yyyy-MM-dd"));
		eqm.setTeam(new MdTeam(bean.getTeamId()));
		eqm.setShift(new MdShift(bean.getShiftId()));
		eqm.setDel(0);
		eqm.setStatus(0);
		return paulDayDao.saveOrUpdate(eqm);
	}
	
	//修改
	@Override
	public int updatePaulDayBean(EqmPaulDayBean bean){
		EqmPaulDay eqm=new EqmPaulDay();
		/*eqm.setEqp_type(new MdEqpCategory(bean.getEqp_type_id()));
		eqm.setName(bean.getName());
		eqm.setPaul_id(bean.getPaul_id());
		eqm.setTeam(new MdTeam(bean.getTeamId()));
		eqm.setShift(new MdShift(bean.getShiftId()));
		eqm.setDel(bean.getDel());
		eqm.setStatus(bean.getStatus());
		eqm.setId(bean.getId());
		eqm.setStim(DateUtil.formatStringToDate(bean.getStim()));
		eqm.setEtim(DateUtil.formatStringToDate(bean.getEtim()));
		eqm.setDate_p(DateUtil.formatStringToDate(bean.getDate_p(),"yyyy-MM-dd"));*/
		String sql = "update EQM_PAULDAY SET NAME='"+bean.getName()+"',to_char(DATE_P,'yyyy-MM-dd')='"+bean.getDate_p()+"',to_char(STIM,'yyyy-MM-dd')='"+bean.getStim()+"',to_char(ETIM,'yyyy-MM-dd')='"+bean.getEtim()+"' where ID='"+bean.getId()+"'";
		return paulDayDao.updateBySql(sql, null);
		//return paulDayDao.saveOrUpdate(eqm);
	}
	//修改
	@Override
	public boolean updatePaulDay(EqmPaulDay bean){
		return paulDayDao.saveOrUpdate(bean);
	}
	//根据id查询
	@Override
	public EqmPaulDay getBeanById(String id){
		return paulDayDao.findById(EqmPaulDay.class, id);
	}
	
	//根据id查询
	@Override
	public void checkWork(String ids,int stats){
		for(String id:StringUtil.splitToStringList(ids, ",")){
			if(StringUtil.notNull(id)){
				EqmPaulDay bean=getBeanById(id);
				bean.setStatus(stats);
				paulDayDao.saveOrUpdate(bean);
			}
		}
	}
	//根据id查询
	@Override
	public boolean updateBean(EqmPaulDay bean){
		return paulDayDao.saveOrUpdate(bean);
	}
	
	//根据id查询
	@Override
	public EqmPaulDayBean getBeanByIds(String id){
		StringBuffer hql=new StringBuffer();
		hql.append("select o.id,o.name, o.shift.id,");
		hql.append("o.shift.name,");
		hql.append("o.team.id,");
		hql.append("o.team.name,");
		hql.append("o.date_p,");
		hql.append("o.stim,");
		hql.append("o.etim,");
		hql.append("o.eqp_type.id,");
		hql.append("o.eqp_type.name,");
		hql.append("o.paul_id,");
		hql.append("o.del, ");
		hql.append("o.status ");
		hql.append("from EqmPaulDay o where o.del=0 ");
		if(StringUtil.notNull(id)){
			hql.append("and o.id='"+id+"' ");
		}
		List<Object> list=baseDao.query(hql.toString());
		EqmPaulDayBean b=null;
		if(list.size()>0){
			b=new EqmPaulDayBean();
			Object o=list.get(0);
			Object[] temp=(Object[]) o;
			b.setId(temp[0].toString());
			b.setName(temp[1].toString());
			b.setShiftId(temp[2].toString());
			b.setShiftName(temp[3].toString());
			b.setTeamId(temp[4].toString());
			b.setTeamName(temp[5].toString());
			b.setDate_p(temp[6].toString());
			b.setStim(temp[7].toString());
			b.setEtim(temp[8].toString());
			b.setEqp_type_id(temp[9].toString());
			b.setEqp_type_name(temp[10].toString());
			b.setPaul_id(temp[11].toString());
			b.setDel(Integer.parseInt(temp[12].toString()));
			b.setStatus(Integer.parseInt(temp[13].toString()));
		}
		return b;
	}
	/**
	 * 日保日历
	 */
	@Override
	public List<EqmWheelCalendar> queryListCal(String date1,String date2) {
		StringBuffer hql=new StringBuffer();
		hql.append("select o.id,o.name, o.shift.id,");
		hql.append("o.shift.name,");
		hql.append("o.team.id,");
		hql.append("o.team.name,");
		hql.append("o.date_p,");
		hql.append("o.stim,");
		hql.append("o.etim,");
		hql.append("o.eqp_type.id,");
		hql.append("o.eqp_type.name,");
		hql.append("o.paul_id,");
		hql.append("o.del, ");
		hql.append("o.status ");
		hql.append("from EqmPaulDay o where o.del=0 ");
		if(StringUtil.notNull(date1)){
			hql.append(" and o.date_p >= to_date('"+date1+"','yyyy-MM-dd')");
		}
		if(StringUtil.notNull(date2)){
			hql.append(" and o.date_p <= to_date('"+date2+"','yyyy-MM-dd')");
		}
		hql.append("order by o.date_p,o.shift.code  ");
		List<Object> list=baseDao.query(hql.toString());
		List<EqmWheelCalendar> returnList=new ArrayList<EqmWheelCalendar>();
		for(Object o:list){
			Object[] temp=(Object[]) o;
			EqmWheelCalendar b=new EqmWheelCalendar();
			b.setId(temp[0].toString());
			b.setName(temp[1].toString());
			b.setStart(temp[7].toString());
			b.setEnd(temp[8].toString());
			b.setTitle(temp[1].toString());
			// 0\新增 1、审核通过2、运行3、停止运行4、操作工操作完毕5、轮保工操作完毕6、操作工、轮保工操作完毕7、审核完毕8、计划完成
			if(Integer.parseInt(temp[13].toString())==8){
				b.setColor("GREEN");
			}else{
				b.setColor("Red");
			}
			returnList.add(b);
		}
		return returnList;
	}
	
	//批量添加日保养计划
	@Override
	public void batchAdd(BatchBean bean){
		int workshop=1;
		StringBuffer hql=new StringBuffer();
//		String date=bean.getDate();
//		int year=Integer.parseInt(date.substring(0, 4));
//		int month=Integer.parseInt(date.substring(5, 7));
		hql.append("delete from EQM_PAULDAY where 1=1 ");
//		hql.append("and DATEPART(YEAR,DATE_p)="+year+" ");
//		hql.append("and DATEPART(MONTH,DATE_p)="+month+" ");
		
		hql.append("and DATE_p >= to_date('"+bean.getDate()+"','yyyy-MM-dd')");
		hql.append(" and DATE_p <= to_date('"+bean.getDate2()+"','yyyy-MM-dd')");
		
		hql.append(" and eqp_type='"+bean.getEqp_type_id()+"' ");
		baseDao.updateInfo(hql.toString(),null);
		//早 不包含周一的早班
		hql=new StringBuffer();
		hql.append("insert into EQM_PAULDAY (ID,SHIFT,TEAM,DATE_P,STIM,ETIM,PAUL_ID,DEL,NAME,eqp_type,status) ");
		hql.append(" select SYS_GUID(),SHIFT,TEAM,DATE_,STIM,to_date(STIM,'yyyy-MM-dd hh24:mi:ss')+"+bean.getZao()+"/(24*60),");
		hql.append("'"+bean.getPaul_category()+"', ");
		hql.append("0,");
		hql.append("(select cate.name from MD_EQP_CATEGORY cate where cate.ID='"+bean.getEqp_type_id()+"' ) || '日保', ");
		hql.append("'"+bean.getEqp_type_id()+"', ");
		hql.append("2");
		hql.append(" from SCH_CALENDAR where 1=1 ");
//		hql.append("DATEPART(YEAR,DATE)="+year+" ");
//		hql.append("and DATEPART(MONTH,DATE)="+month+" ");
		
		hql.append(" and DATE_ >= to_date('"+bean.getDate()+"','yyyy-MM-dd')");
		hql.append(" and DATE_ <= to_date('"+bean.getDate2()+"','yyyy-MM-dd')");
		
		hql.append(" and WORKSHOP= "+workshop+" and DEL=0 ");
		hql.append(" and SHIFT=1 ");
//		hql.append("and DATEPART(WEEKDAY,DATE)<>1 ");
		
		hql.append(" and to_char(DATE_,'d')<> "+bean.getZaoTD());//这里是判断特殊早班日
		//hql.append(" and DATEPART(WEEKDAY,DATE)<> "+bean.getZaoTD());//这里是判断特殊早班日
		
		baseDao.updateInfo(hql.toString(),null);
		hql=new StringBuffer();
		//周一早班轮保使用 zaoT时间
		hql.append("insert into EQM_PAULDAY (ID,SHIFT,TEAM,DATE_P,STIM,ETIM,PAUL_ID,DEL,NAME,eqp_type,status) ");
		hql.append("select SYS_GUID(),SHIFT,TEAM,DATE_,STIM,to_date(STIM,'yyyy-MM-dd hh24:mi:ss')+"+bean.getZaoT()+"/(24*60),");
//		hql.append("'"+bean.getPaul_category()+"', ");
		//如果有周就是周保养
		if(StringUtil.notNull(bean.getPaul_category2())){
			hql.append("'"+bean.getPaul_category2()+"', ");
		}else{
			hql.append("'"+bean.getPaul_category()+"', ");
		}
		hql.append("0,");
		hql.append("(select cate.name from MD_EQP_CATEGORY cate where cate.ID='"+bean.getEqp_type_id()+"' ) || '日保', ");
		hql.append("'"+bean.getEqp_type_id()+"', ");
		hql.append("2");
		hql.append(" from SCH_CALENDAR where 1=1 ");
//		hql.append("DATEPART(YEAR,DATE)="+year+" ");
//		hql.append("and DATEPART(MONTH,DATE)="+month+" ");
		
		hql.append(" and DATE_ >= to_date('"+bean.getDate()+"','yyyy-MM-dd')");
		hql.append(" and DATE_ <= to_date('"+bean.getDate2()+"','yyyy-MM-dd')");
		
		hql.append(" and WORKSHOP="+workshop+" and DEL=0");
		hql.append(" and SHIFT=1 ");
//		hql.append("and DATEPART(WEEKDAY,DATE)=1 ");//特殊早班日时间
		
		//hql.append(" and DATEPART(WEEKDAY,DATE) = "+bean.getZaoTD());
		hql.append(" and TO_CHAR (DATE_, 'd') = "+bean.getZaoTD());
		
		baseDao.updateInfo(hql.toString(),null);
		
		//中  不包含周四的中班
		hql=new StringBuffer();
		hql.append("insert into EQM_PAULDAY (ID,SHIFT,TEAM,DATE_P,STIM,ETIM,PAUL_ID,DEL,NAME,eqp_type,status) ");
		hql.append("select SYS_GUID(),SHIFT,TEAM,DATE_,STIM,to_date(STIM,'yyyy-MM-dd hh24:mi:ss')+"+bean.getZhong()+"/(24*60),");
		hql.append("'"+bean.getPaul_category()+"', ");
		hql.append("0,");
		hql.append("(select cate.name from MD_EQP_CATEGORY cate where cate.ID='"+bean.getEqp_type_id()+"' ) || '日保', ");
		hql.append("'"+bean.getEqp_type_id()+"', ");
		hql.append("2");
		hql.append(" from SCH_CALENDAR where 1=1 ");
//		hql.append("DATEPART(YEAR,DATE)="+year+" ");
//		hql.append("and DATEPART(MONTH,DATE)="+month+" ");
		
		hql.append(" and DATE_ >= to_date('"+bean.getDate()+"','yyyy-MM-dd')");
		hql.append(" and DATE_ <= to_date('"+bean.getDate2()+"','yyyy-MM-dd')");
		
		
		hql.append(" and WORKSHOP="+workshop+" and DEL=0");
		hql.append(" and SHIFT=2 ");
//		hql.append("and DATEPART(WEEKDAY,DATE)<>5 ");//特殊中班日
		
		hql.append(" and TO_CHAR (DATE_, 'd') <> "+bean.getZhongTD());
		
		baseDao.updateInfo(hql.toString(),null);
		hql=new StringBuffer();
		//特殊中班
		hql.append("insert into EQM_PAULDAY (ID,SHIFT,TEAM,DATE_P,STIM,ETIM,PAUL_ID,DEL,NAME,eqp_type,status) ");
		hql.append("select SYS_GUID(),SHIFT,TEAM,DATE_,STIM,to_date(STIM,'yyyy-MM-dd hh24:mi:ss')+"+bean.getZhongT()+"/(24*60),");
		//hql.append("'"+bean.getPaul_category()+"', ");
		//如果有精细就是精细保养
		if(StringUtil.notNull(bean.getPaul_category3())){
			hql.append("'"+bean.getPaul_category3()+"', ");
		}else{
			hql.append("'"+bean.getPaul_category()+"', ");
		}
		hql.append("0,");
		hql.append("(select cate.name from MD_EQP_CATEGORY cate where cate.ID='"+bean.getEqp_type_id()+"' ) || '日保', ");
		hql.append("'"+bean.getEqp_type_id()+"', ");
		hql.append("2");
		hql.append(" from SCH_CALENDAR where 1=1 ");
//		hql.append("DATEPART(YEAR,DATE)="+year+" ");
//		hql.append("and DATEPART(MONTH,DATE)="+month+" ");
		
		hql.append(" and DATE_ >= to_date('"+bean.getDate()+"','yyyy-MM-dd')");
		hql.append(" and DATE_ <= to_date('"+bean.getDate2()+"','yyyy-MM-dd')");
		
		
		hql.append(" and WORKSHOP="+workshop+" and DEL=0");
		hql.append(" and SHIFT=2 ");
//		hql.append("and DATEPART(WEEKDAY,DATE)=5 ");//特殊中班日时间
		
		hql.append(" and TO_CHAR (DATE_, 'd') = "+bean.getZhongTD());
		
		
		baseDao.updateInfo(hql.toString(),null);
		
		//晚
		hql=new StringBuffer();
		hql.append("insert into EQM_PAULDAY (ID,SHIFT,TEAM,DATE_P,STIM,ETIM,PAUL_ID,DEL,NAME,eqp_type,status) ");
		hql.append("select SYS_GUID(),SHIFT,TEAM,DATE_,STIM,to_date(STIM,'yyyy-MM-dd hh24:mi:ss')+"+bean.getWan()+"/(24*60),");
		hql.append("'"+bean.getPaul_category()+"', ");
		hql.append("0,");
		hql.append("(select cate.name from MD_EQP_CATEGORY cate where cate.ID='"+bean.getEqp_type_id()+"' ) || '日保', ");
		hql.append("'"+bean.getEqp_type_id()+"', ");
		hql.append("2");
		hql.append(" from SCH_CALENDAR where 1=1 ");
//		hql.append("DATEPART(YEAR,DATE)="+year+" ");
//		hql.append("and DATEPART(MONTH,DATE)="+month+" ");
		
		hql.append(" and DATE_ >= to_date('"+bean.getDate()+"','yyyy-MM-dd')");
		hql.append(" and DATE_ <= to_date('"+bean.getDate2()+"','yyyy-MM-dd')");
		
		
		
		hql.append(" and WORKSHOP="+workshop+" and DEL=0");
		hql.append(" and SHIFT=3 ");
		baseDao.updateInfo(hql.toString(),null);
	}
	
	
	/**
     *  功能说明：设备日保历史查询-查询
     *  
     *  @param pageParams 分页实体对象
     *  @param bean 数据实体对象
     *  @return
     *  @author 张璐
     *  @time 2015年9月29日
     *  
     * */
	@Override
	public DataGrid queryProtectRecordByList(EqmProtectRecordBean seachBean,
			PageParams pageParams) {
		String shif=""; //班组
		String tem=""; // 班次
		String eqpId=""; //设备类型ID
		Integer start=1;
		Integer ednum=10;
		//起始页-每页多少条
		/*if(pageParams.getPage()==1){// 1-10  10-20  20-30
			start=1;
			ednum=pageParams.getRows();
		}else{
			ednum=pageParams.getPage()*pageParams.getRows();
			start=ednum-pageParams.getRows();
		}*/
		
		int page=pageParams.getPage();
		int row=pageParams.getRows();
	    String sql=getSqlToStr(2,seachBean)+" AND bh >  "+(page-1)*row+" AND bh <="+page*row;
	    String sql2=getSqlToStr(1,seachBean);
	    //总条数
    	List<?> tl= baseDao.queryBySql(sql2);
    	
    	String t=tl.get(0).toString();
		long total=Long.parseLong(t);
		//对象集合
		List<?> list=baseDao.queryBySql(sql);
		List<EqmProtectRecordBean> returnList=new ArrayList<EqmProtectRecordBean>();
		if(list.size()>0){
			for(Object o:list){
				Object[] temp=(Object[]) o;
				EqmProtectRecordBean b=new EqmProtectRecordBean();
				try {
					b.setId(temp[1].toString());
					b.setEqu_name(temp[2].toString());
					if(null!=temp[3]&&!temp[3].equals("")){
						b.setEp_shift(temp[3].toString());
					}
					if(null!=temp[4]&&!temp[4].equals("")){
						b.setEqpTypeName(temp[4].toString());
					}
					if(null!=temp[5]&&!temp[5].equals("")){
						b.setEqpTypeDES(temp[5].toString());
					}
					b.setEp_stime(temp[6].toString());
					b.setEp_etime(temp[7].toString());
					b.setEpr_time(temp[8].toString());
					b.setEpr_username(temp[9].toString());
					b.setStatus(temp[10].toString());
				} catch (Exception e) {
					e.printStackTrace();
				}
				returnList.add(b);
			}
		}
		return new DataGrid(returnList,total);
	}
	
	
	/**
	 * 日保历史记录查询 sql拼接
	 * type 1- 查询对象  2-查询总条数
	 * @author 张璐
     * @time 2015年9月29日
	 * */
	public static String getSqlToStr(int type,EqmProtectRecordBean seachBean){
		StringBuffer sql=new StringBuffer();
		if(type==1){
			sql.append("select count(*) ");
		}else{
			sql.append("SELECT * ");
		}
		
		/*sql.append("FROM ( SELECT ROW_NUMBER () OVER ( ORDER BY tab.equ_name, tab.epr_time, tab.ep_shiftId ) bh, tab.* FROM ( ");
		sql.append("SELECT DISTINCT table_1.equ_name, table_1.ep_shift, table_1.ep_team, table_1.ep_stim AS ep_stime, table_1.ep_etim AS ep_etime, table_1.ep_name, table_1.epr_time, table_1.epr_username, table_1.ep_shiftId ");			
		sql.append("FROM SCH_WORKORDER wo LEFT JOIN ( SELECT ep.ID ep_id, shift.NAME ep_shift, shift.id ep_shiftId, team.NAME ep_team, ep.STIM ep_STIM, ep.ETIM ep_etim, ep.NAME ep_name, epr.create_time epr_time, ");			
		sql.append("sys_u.NAME epr_username, equ.ID equ_id, equ.EQUIPMENT_NAME equ_name, epr.id epr_id FROM EQM_PAULDAY ep LEFT JOIN MD_EQP_CATEGORY mec ON ep.EQP_TYPE = mec.ID LEFT JOIN MD_EQP_TYPE et ON et.CID = mec.ID LEFT JOIN MD_EQUIPMENT equ ON et.ID = equ.EQP_TYPE_ID ");					
		sql.append("LEFT JOIN EQM_PROTECT_RECORD epr ON equ.id = epr.eqp_id AND epr.paulday_id = ep.ID LEFT JOIN MD_SHIFT shift ON shift.ID = ep.SHIFT LEFT JOIN MD_TEAM team ON team.ID = ep.TEAM LEFT JOIN SYS_USER sys_u ON sys_u.ID = epr.create_user_id ");				
		*/
		sql.append(" from (");
		sql.append("SELECT ROW_NUMBER () OVER ( ORDER BY r.create_time DESC) bh, r.id,");
		sql.append("(SELECT EQUIPMENT_NAME from MD_EQUIPMENT e where e.id=r.eqp_id) as eqp_name,");
		sql.append("(SELECT NAME from MD_SHIFT s where s.id=r.shift_id) as shift_name,et.NAME,et.DES,");
		sql.append("(select stim from EQM_PAULDAY p where p.id=r.paulday_id) as stim,");
		sql.append("(select etim from EQM_PAULDAY p where p.id=r.paulday_id) as etim,");
		sql.append("r.create_time,");
		sql.append("(SELECT NAME from SYS_USER u where u.id=r.create_user_id)as create_name,");
		sql.append("r.status ");
		sql.append(" from EQM_PROTECT_RECORD r LEFT JOIN EQM_PAULDAY p ON r.paulday_id=p.id LEFT JOIN SYS_EQP_TYPE et ON r.paul_id = et.id WHERE 1 = 1 ");
		//班次
		if(StringUtil.notNull(seachBean.getEp_shift())){
			sql.append(" AND r.shift_id='"+seachBean.getEp_shift()+"'  ");
		}  
		/*//班组
		if(StringUtil.notNull(seachBean.getEp_team())){
			sql.append("AND team.id='"+seachBean.getEp_team()+"'  ");
		}*/
		//设备类型
		if(StringUtil.notNull(seachBean.getEqu_id())){
			sql.append(" AND r.eqp_id='"+seachBean.getEqu_id()+"'  ");
		}
		
		//时间
		if(StringUtil.notNull(seachBean.getStime())){
			sql.append(" AND to_char( p.stim, 'yyyy-MM-dd') >= '"+seachBean.getStime()+"'  ");
		}  
		if(StringUtil.notNull(seachBean.getEtime())){
			sql.append(" AND to_char( p.etim, 'yyyy-MM-dd') <= '"+seachBean.getEtime()+"' ");
		}
		
		//sql.append("AND equ.DEL = 0 ) table_1 ON wo.EQP = table_1.equ_id WHERE 1=1 and table_1.equ_name IS NOT NULL ");
		//时间
		/*if(StringUtil.notNull(seachBean.getStime())){
			sql.append("AND CONVERT (VARCHAR(32), wo. DATE, 23) >= '"+seachBean.getStime()+"'   ");
		}  
		if(StringUtil.notNull(seachBean.getEtime())){
			sql.append("AND CONVERT (VARCHAR(32), wo. DATE, 23) <= '"+seachBean.getEtime()+"'  ");
		}*/
		sql.append(" ) zl where 1=1");
		return sql.toString();
	}
	@Override
	public void delete(String id) throws Exception{
		paulDayDao.deleteById(id, EqmPaulDay.class);
		//paulDayDao.updateInfo(sql, obj);
	}
	@Override
	public void deletePaul(String ids) throws Exception {
		for (String id : StringUtil.splitToStringList(ids, ",")) {			
			this.delete(id);
		}
	}	
}