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

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

import com.shlanbao.tzsc.utils.tools.*;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import com.shlanbao.tzsc.base.dao.EqmLubricantMaintainDaoI;
import com.shlanbao.tzsc.base.dao.SysEqpTypeDaoI;
import com.shlanbao.tzsc.base.mapping.EqmLubricantMaintain;
import com.shlanbao.tzsc.base.mapping.SysEqpType;
import com.shlanbao.tzsc.base.mapping.SysUser;
import com.shlanbao.tzsc.base.model.DataGrid;
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.lubricate.beans.EquLubricantMaintainBean;
import com.shlanbao.tzsc.pms.equ.lubricate.service.EqmLubricantMaintainServiceI;

import javax.servlet.http.HttpServletRequest;

@Service
public class EqmLubricantMaintainServiceImpl extends BaseService implements EqmLubricantMaintainServiceI {
	@Autowired
	protected EqmLubricantMaintainDaoI lubriCateDao;
	@Autowired
	private SysEqpTypeDaoI sysEqpTypeDao;
	@Autowired
	private HttpServletRequest request;

	@LogAnno(operateType = "添加或编辑润滑管理")
	@Override
	public void addLubricate(EqmLubricantMaintain equLubricantMaintain) throws Exception {
		EqmLubricantMaintain equLubricant = new EqmLubricantMaintain();
		//判断是否存在ID 如果存在则更新数据，如果不存在则添加
		if(StringUtil.notNull(equLubricantMaintain.getId())){
			equLubricantMaintain.setDel("0");
			//设置创建用户
			if(equLubricantMaintain.getSysUser()==null){
				SessionInfo sessionInfo = (SessionInfo) WebContextUtil.getObjectFromSession();
				equLubricantMaintain.setSysUser(new SysUser(sessionInfo.getUser().getId()));
			}
			equLubricant=equLubricantMaintain;
			FillUserInfoUtil.fillUpdateUserInfo(equLubricant,request);
		}else{
			if(!StringUtil.notNull(equLubricantMaintain.getDel()))
				equLubricantMaintain.setDel("0");
			//设置创建用户
			if(equLubricantMaintain.getSysUser()==null){
				SessionInfo sessionInfo = (SessionInfo) WebContextUtil.getObjectFromSession();
				equLubricantMaintain.setSysUser(new SysUser(sessionInfo.getUser().getId()));
			}
			equLubricant = equLubricantMaintain;
			FillUserInfoUtil.fillCreateUserInfo(equLubricant,request);
		}
		lubriCateDao.saveOrUpdate(equLubricant);
	}

	@Override
	public DataGrid queryLubricate(EqmLubricantMaintain equLubricantMaintain, PageParams pageParams)throws Exception {
		String hql="from EqmLubricantMaintain o where 1=1 and o.del=0";//1 deleted data is not visible
		String params="";
		if(StringUtil.notNull(equLubricantMaintain.getLubricantCode())){
			params+=" and (o.lubricantCode like '%"+equLubricantMaintain.getLubricantCode()+"%')";
		}
		if(StringUtil.notNull(equLubricantMaintain.getLubricantName())){
			params+=" and o.lubricantName like '%"+equLubricantMaintain.getLubricantName()+"%'";
		}
		List<EqmLubricantMaintain> rows=lubriCateDao.queryByPage(hql.concat(params), pageParams);
		hql="select count(*) " + hql;
		try {
			List<EquLubricantMaintainBean> equLubricantMaintainBeans = new ArrayList<EquLubricantMaintainBean>();
			for (EqmLubricantMaintain eqmLubricantMaintain : rows) {
				EquLubricantMaintainBean bean = new EquLubricantMaintainBean();
				beanConvertor.copyProperties(eqmLubricantMaintain, bean);
				FillUserInfoUtil.fillCreateAndUpdateUserInfo(eqmLubricantMaintain,bean);
				equLubricantMaintainBeans.add(bean);
			}
			//equLubricantMaintainBeans = BeanConvertor.copyList(rows, EquLubricantMaintainBean.class);
			long total=lubriCateDao.queryTotal(hql.concat(params));
			return new DataGrid(equLubricantMaintainBeans, total);
		} catch (Exception e) {
			log.error("POVO转换异常", e);
		}
		return null;
	}

	@Override
	public EqmLubricantMaintain getLubricateById(String id) throws Exception {
		return lubriCateDao.findById(EqmLubricantMaintain.class, id);
	}

	@LogAnno(operateType = "根据ID删除设备润滑管理")
	@Override
	public void deleteLuricateById(String id) throws Exception {
		//lubriCateDao.deleteById(id, EqmLubricantMaintain.class);
		EqmLubricantMaintain eqmLubricantMaintain = lubriCateDao.findById(EqmLubricantMaintain.class, id);
		eqmLubricantMaintain.setDel("1");
	}

	@LogAnno(operateType = "批量删除设备润滑管理")
	@Override
	public void batchDeleteLubricant(String ids) {
		String[] split = ids.split(",");
		try {
			for (int i = 0; i < split.length; i++) {
				EqmLubricantMaintain eqmLubricantMaintain = lubriCateDao.findById(EqmLubricantMaintain.class, split[i]);
				eqmLubricantMaintain.setDel("1");
			}
		}catch (Exception e){
			e.printStackTrace();
		}

	}

	@Override
	public List<EquLubricantMaintainBean> queryAllLubricant(String type) throws Exception {
		String hql="from EqmLubricantMaintain o where 1=1 and o.del=0";
		List<EqmLubricantMaintain> eqmLubricantMaintains = lubriCateDao.query(hql, new Object[]{});
		List<EquLubricantMaintainBean> lastList= beanConvertor.copyList(eqmLubricantMaintains, EquLubricantMaintainBean.class);
		if("all".equals(type)){
			EquLubricantMaintainBean bean = new EquLubricantMaintainBean();
			bean.setId("");
			bean.setLubricantCode("");
			bean.setLubricantName("请选择");
			lastList.add(0, bean);
		}
		return lastList;
	}
	/**
	 * 获取所有的润滑剂
	 * @return
	 * @throws Exception
	 */

	@Override
	public List<EquLubricantMaintainBean> queryListById(String key,String type) throws Exception {
		String hql="from SysEqpType o where o.del=0 and o.sysEqpCategory.id=? ";
		Map<String,String> idMap=Mes2DASParams.SysEqpCategoryMap();
		String mapKey=null;
		if(StringUtil.notNull(key)){
			mapKey=idMap.get(key);
		}
		if(mapKey!=null){
			key=mapKey;
		}
		List<SysEqpType> eqpList = sysEqpTypeDao.query(hql, new Object[]{key});
		List<EquLubricantMaintainBean> lastBean = new ArrayList<EquLubricantMaintainBean>();
		if(null!=eqpList&&eqpList.size()>0){
			for(int i=0;i<eqpList.size();i++){
				SysEqpType oneBean = eqpList.get(i);
				EquLubricantMaintainBean bean = new EquLubricantMaintainBean();
				bean.setId(oneBean.getId());
				bean.setLubricantCode(oneBean.getCode());
				bean.setLubricantName(oneBean.getName());
				lastBean.add(bean);
			}
		}
		if("all".equals(type)){
			EquLubricantMaintainBean bean = new EquLubricantMaintainBean();
			bean.setId("");
			bean.setLubricantCode("");
			bean.setLubricantName("请选择");
			lastBean.add(0, bean);
		}
		return lastBean;
	}

	
}