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

import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import java.util.UUID;

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

import com.shlanbao.tzsc.utils.tools.*;
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.EqmMaintainDaoI;
import com.shlanbao.tzsc.base.interceptor.WorkOrderStatChangeInterceptor;
import com.shlanbao.tzsc.base.mapping.SysEqpCategory;
import com.shlanbao.tzsc.base.mapping.SysRole;
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.base.model.SessionInfo;
import com.shlanbao.tzsc.base.service.BaseService;
import com.shlanbao.tzsc.pms.equ.eqpMaintain.bean.EqmMaintainBean;
import com.shlanbao.tzsc.pms.equ.eqpMaintain.service.EqMaintainServiceI;
import com.shlanbao.tzsc.pms.equ.overhaul.beans.RepairCallInfoBean;
import com.shlanbao.tzsc.pms.sys.repairResquest.beans.RepairResquestBean;
import com.shlanbao.tzsc.pms.sys.user.beans.UserBean;
import com.shlanbao.tzsc.base.mapping.EqmMaintain;



@Service
public class EqMaintainServiceImpl extends BaseService implements EqMaintainServiceI {
	@Autowired
	private EqmMaintainDaoI eqmMaintainDao;
	@Autowired
	private BaseDaoI<Object> baseDao;
	@Autowired
	private HttpServletRequest request;
	@LogAnno(operateType = "保养明细数据添加")
	@Override
	public boolean addBean(EqmMaintain bean) {
		bean.setCreateTime(new Date());
		bean.setLastUpdateTime(new Date());
		return eqmMaintainDao.save(bean);
		
	}
	@Override
	public EqmMaintain getBeanById(String id) {
		 return eqmMaintainDao.findById(EqmMaintain.class, id);
	}
	@Override
	public EqmMaintainBean getBeanByIds(String id) throws Exception {
		EqmMaintain eqmMaintain=eqmMaintainDao.findById(EqmMaintain.class, id);
		EqmMaintainBean bean=BeanConvertor.copyProperties(eqmMaintain, EqmMaintainBean.class);
		bean.setCategoryId(eqmMaintain.getSysEqpCategory().getId());
		bean.setCategoryName(eqmMaintain.getSysEqpCategory().getName());
		return bean;		
	}
	@Override
	public DataGrid queryMaintainById(SysEqpCategory bean, PageParams pageParams) {
		List<EqmMaintainBean> beans = new ArrayList<EqmMaintainBean>();
		StringBuffer sb=new StringBuffer();
		long total=0;
		sb.append(" select a.ID,a.NUM,a.SYSTEM_NAME,a.PARTS_NAME,a.SAFETY_WARNING,a.CLEAN_METHOD,a.CLEAN_STANDARDS,a.CYCLE,a.MAIN_METHOD, ");
		sb.append(" a.SPE_PERSON,a.MAIN_STANDARDS,a.ATTR1,a.DES,a.CREATE_TIME,a.LAST_UPDATE_TIME,a.SYS_EC,a.ENABLE,a.SHIFT_ID from EQM_MAINTENANCE a,SYS_EQP_CATEGORY b ");
		sb.append(" where b.maintainace_type='"+bean.getMaintainaceType()+"' and b.id='"+bean.getId()+"' and a.SYS_EC=b.id ");
		if(StringUtil.notEmpty(bean.getCode())&&!"4".equals(bean.getCode())){
			sb.append(" and a.SHIFT_ID ="+StringUtil.convert2Integer(bean.getCode())+"");
		}
		if (StringUtil.notEmpty(bean.getSpePerson())) {
			sb.append(" and a.SPE_PERSON like '%"+bean.getSpePerson()+"%'");
		}
		if (StringUtil.notEmpty(bean.getSystemName())) {
			sb.append(" and a.SYSTEM_NAME like '%"+bean.getSystemName()+"%'");
		}
		sb.append(" order by a.num asc ");
		List<?> list= eqmMaintainDao.queryBySql(sb.toString());
		if(list!=null && list.size()>0){
			EqmMaintainBean eb=null;
			for(Object o:list){
				Object[] temp=(Object[]) o;
				eb=new EqmMaintainBean();
				eb.setId(StringUtil.convertObjToString(temp[0]));
				eb.setNum(StringUtil.convert2Integer(temp[1]));
				eb.setSystemName(StringUtil.convertObjToString(temp[2]));
				eb.setPartsName(StringUtil.convertObjToString(temp[3]));
				eb.setSafetyWarning(StringUtil.convertObjToString(temp[4]));
				eb.setCleanMethod(StringUtil.convertObjToString(temp[5]));
				eb.setCleanStandards(StringUtil.convertObjToString(temp[6]));
				eb.setCycle(StringUtil.convertObjToString(temp[7]));
				eb.setMainMethod(StringUtil.convertObjToString(temp[8]));
				eb.setSpePerson(StringUtil.convertObjToString(temp[9]));
				eb.setMainStandards(StringUtil.convertObjToString(temp[10]));
				eb.setAttr1(StringUtil.convertObjToString(temp[11]));
				eb.setDes(StringUtil.convertObjToString(temp[12]));
				eb.setCreateTime(DateUtil.formatStringToDate(temp[13].toString(), "yyyy-MM-dd HH:mm:ss"));
				eb.setLastUpdateTime(DateUtil.formatStringToDate(temp[14].toString(), "yyyy-MM-dd HH:mm:ss"));
				eb.setCategoryId(StringUtil.convertObjToString(temp[15]));
				eb.setEnable(StringUtil.convertObjToString(temp[16]));
				eb.setShiftId(StringUtil.convert2Integer(temp[17]));
				beans.add(eb);
			}
		}
		return new DataGrid(beans, total);
	}

	/**
	 * 保养数据批量删除
	 * @param ids
	 */
	@LogAnno(operateType = "批量删除保养明细数据")
	@Override
	public void batchDeleteMaintain(String ids) {
		String[] split = ids.split(",");
		try {
			for (int i = 0; i <split.length; i++) {
				eqmMaintainDao.deleteById(split[i], EqmMaintain.class);
			}

		}catch (Exception e ){
			e.printStackTrace();
		}

	}

	@LogAnno(operateType = "保养明细数据编辑")
	@Override
	public boolean updateBean(EqmMaintainBean bean) {
		EqmMaintain o=eqmMaintainDao.findById(EqmMaintain.class, bean.getId());		
		o.setNum(bean.getNum());
		o.setSystemName(bean.getSystemName());
		o.setPartsName(bean.getPartsName());
		o.setSafetyWarning(bean.getSafetyWarning());
		o.setCleanMethod(bean.getCleanMethod());
		o.setCleanStandards(bean.getCleanStandards());
		o.setCycle(bean.getCycle());
		o.setMainMethod(bean.getMainMethod());
		o.setSpePerson(bean.getSpePerson());
		o.setMainStandards(bean.getMainStandards());
		o.setRoleId(bean.getRoleId());
		o.setAttr1(bean.getAttr1());
		o.setDes(bean.getDes());
		o.setEnable(bean.getEnable());
		o.setLastUpdateTime(bean.getLastUpdateTime());
		o.setShiftId(bean.getShiftId());
		return eqmMaintainDao.saveOrUpdate(o);
	}
	
	
	@Override
	public List<SysRole> getRoleAll() {
		try {
			String sql="select id,name from SYS_ROLE where del=0";
			List<?> list=baseDao.queryBySql(sql);
			List<SysRole> srlist=new ArrayList<SysRole>();
			if(list!=null && list.size()>0){
				SysRole sr=null;
				for(Object o:list){
					Object[] temp=(Object[]) o;
					sr=new SysRole();
					sr.setId(StringUtil.convertObjToString(temp[0]));
					sr.setName(StringUtil.convertObjToString(temp[1]));
					srlist.add(sr);
				}
			}
			return srlist;
		} catch (Exception e) {
			e.printStackTrace();
		}
		return null;
	}
	@LogAnno(operateType = "保养明细数据删除")
	@Override
	public void deleteMaintain(String id) {
		eqmMaintainDao.deleteById(id, EqmMaintain.class);		
	}
	
	
}