package com.shlanbao.tzsc.pms.cos.param.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.CosMatParamDaoI;
import com.shlanbao.tzsc.base.dao.MdEqpTypeDaoI;
import com.shlanbao.tzsc.base.mapping.CosMatParam;
import com.shlanbao.tzsc.base.mapping.MdEqpType;
import com.shlanbao.tzsc.base.mapping.MdMat;
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.cos.param.beans.CosMatParamBean;
import com.shlanbao.tzsc.pms.cos.param.service.CosMatParamServiceI;
import com.shlanbao.tzsc.pms.md.eqptype.beans.MdEqpTypeBean;
import com.shlanbao.tzsc.utils.tools.BeanConvertor;
import com.shlanbao.tzsc.utils.tools.StringUtil;

@Service
public class CosMatParamServiceImpl extends BaseService implements CosMatParamServiceI{
	
	@Autowired
	private CosMatParamDaoI cosMatParamDao;

	@Autowired
	private MdEqpTypeDaoI mdEqpTypeDao;
	
	@Override
	public void addCosMat(CosMatParamBean bean) throws Exception {
		CosMatParam cosMatParam = new CosMatParam();
		if(StringUtil.notNull(bean.getId())){
			cosMatParam = cosMatParamDao.findById(CosMatParam.class, bean.getId());
			BeanConvertor.copyProperties(bean, cosMatParam);
		}else{
			BeanConvertor.copyProperties(bean, cosMatParam);
			cosMatParam.setMdEqpType(new MdEqpType(bean.getMdEqpTypeId()));
			cosMatParam.setMdMat(new MdMat(bean.getMdMatId()));
			cosMatParam.setId(null);
		}
		cosMatParam.setDel(0L);
		cosMatParamDao.saveOrUpdate(cosMatParam);
	}

	@Override
	public DataGrid queryCosMat(CosMatParamBean cosMatParamBean, PageParams pageParams) throws Exception {
		String hql = "from CosMatParam o where 1=1 and o.del=0 ";
		StringBuffer params = new StringBuffer();
		if(!(StringUtil.notNull(cosMatParamBean.getMdEqpTypeId()) && "null".equals(cosMatParamBean.getMdEqpTypeId()))) params.append(" and o.mdEqpType.id='" + cosMatParamBean.getMdEqpTypeId() + "'");
		
		List<CosMatParam> cmp = cosMatParamDao.queryByPage(hql.concat(params.toString()),pageParams);
		List<CosMatParamBean> beans = new ArrayList<CosMatParamBean>();
		for(CosMatParam c : cmp){
			CosMatParamBean bean = new CosMatParamBean();
			if(null != c.getMdMat()) bean.setMdMatName(c.getMdMat().getName());
			bean.setMdEqpName(c.getMdEqpType().getName());
			BeanConvertor.copyProperties(c, bean);
			beans.add(bean);
		}
		hql = "select count(*) from CosMatParam o where 1=1 and o.del=0 ";
		long total = mdEqpTypeDao.queryTotal(hql.concat(params.toString()));
		
		return new DataGrid(beans,total);
	}

	/**
	 * 辅料考核参数查询
	 */
	public DataGrid queryMdType(MdEqpTypeBean mdTypeBean, PageParams pageParams) throws Exception {
		String hql = "from MdEqpType o where 1=1 and o.del=0 ";
		StringBuffer params = new StringBuffer();
		if(StringUtil.notNull(mdTypeBean.getName())) params.append(" and o.name like '%" + mdTypeBean.getName() +"%'");
		
		if(StringUtil.notNull(mdTypeBean.getCode())) params.append(" and o.code like '%" + mdTypeBean.getCode() +"%'");
		
		//if(StringUtil.notNull(mdTypeBean.getCategoryId())) params.append(" and o.mdEqpCategory.id='"+mdTypeBean.getCategoryId()+"'");
		List<MdEqpType> rows = mdEqpTypeDao.queryByPage(hql.concat(params.toString()),pageParams);
		List<MdEqpTypeBean> beans = new ArrayList<MdEqpTypeBean>();
		for (MdEqpType mdEqpType : rows) {
			MdEqpTypeBean bean = new MdEqpTypeBean();
			BeanConvertor.copyProperties(mdEqpType, bean);
			if(mdEqpType.getMdEqpCategory() != null){
				bean.setCategoryId(mdEqpType.getMdEqpCategory().getId());
				bean.setCategoryName(mdEqpType.getMdEqpCategory().getName());
			}
			beans.add(bean);
		}
		
		List<MdEqpTypeBean> r = BeanConvertor.copyList(rows, MdEqpTypeBean.class);
	/*	for (int i = 0; i < rows.size(); i++) {
			MdEqpTypeBean metb = (MdEqpTypeBean)rows.get(i);
			if("0".equals(metb.getEnable())) {
				metb.setEnableStr("已启用");
				break;
			}
			
			if("1".equals(metb.getEnable())){
				metb.setEnableStr("未启用");
				break;
			}
		}*/
		hql = "select count(*) from MdEqpType o where 1=1 and o.del=0 ";
		long total = mdEqpTypeDao.queryTotal(hql.concat(params.toString()));
		return new DataGrid(beans,total);
	}

	@Override
	public void editCosMat(CosMatParamBean cosMatParamBean) throws Exception {
		CosMatParam cosMatParam = cosMatParamDao.findById(CosMatParam.class, cosMatParamBean.getId());
		BeanConvertor.copyProperties(cosMatParamBean,cosMatParam);
	}

	@Override
	public CosMatParamBean getCosMatById(String id) throws Exception {
		CosMatParam cosMatParam = cosMatParamDao.findById(CosMatParam.class, id);
		
		CosMatParamBean bean = new CosMatParamBean();
		bean.setMdEqpName(cosMatParam.getMdEqpType().getName());
		bean.setMdEqpTypeId(cosMatParam.getMdEqpType().getId());
		bean.setMdMatName(cosMatParam.getMdMat().getName());
		bean.setMdMatId(cosMatParam.getMdMat().getId());

		BeanConvertor.copyProperties(cosMatParam,bean);
		return bean;
	}

	@Override
	public void deleteCosMat(String id) throws Exception {
		cosMatParamDao.findById(CosMatParam.class, id).setDel(1L);
	}
}