package com.shlanbao.tzsc.pms.cos.maintain.service.impl;

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

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

import com.shlanbao.tzsc.base.dao.CosMatPriceMaintainDaoI;
import com.shlanbao.tzsc.base.dao.MdUnitDaoI;
import com.shlanbao.tzsc.base.mapping.CosMatPriceMaintain;
import com.shlanbao.tzsc.base.mapping.MdMat;
import com.shlanbao.tzsc.base.mapping.MdUnit;
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.maintain.beans.MaintainBean;
import com.shlanbao.tzsc.pms.cos.maintain.beans.UnitBean;
import com.shlanbao.tzsc.pms.cos.maintain.service.MaintainServiceI;

import javax.servlet.http.HttpServletRequest;

@Service
public class MaintainServiceImpl extends BaseService implements MaintainServiceI {
	@Autowired
	private MdUnitDaoI mdUnitDao;
	@Autowired
	private CosMatPriceMaintainDaoI cosMatPriceMaintainDao;
	@Autowired
	private HttpServletRequest request;

	@Override
	public DataGrid queryCosMaintain(MaintainBean maintainBean,PageParams pageParams) throws Exception {
		String hql = "from CosMatPriceMaintain o where 1=1 and o.del=0 ";
		StringBuffer params = new StringBuffer();
		if (StringUtil.notNull(maintainBean.getMatType())){
			params.append(" and o.mdMat.mdMatType.id = '"+maintainBean.getMatType()+"'");
		}
		//辅料名称
		if(StringUtil.notNull(maintainBean.getMatName())&&!"全部".equals(maintainBean.getMatName())) {
			params.append(" and o.mdMat.name like '%"+maintainBean.getMatName()+"%'");
		}

		//时间
		if(StringUtil.notNull(maintainBean.getDate1())){
			hql = hql.concat(" and to_char(o.takeeffectDate,'yyyy-mm-dd') >= '" + maintainBean.getDate1()+"'");
		}
		if(StringUtil.notNull(maintainBean.getDate2())){
			hql = hql.concat(" and to_char(o.takeeffectDate,'yyyy-mm-dd') <= '" + maintainBean.getDate2()+"'");
		}
		//hql = hql.concat(StringUtil.fmtDateBetweenParams("o.takeeffectDate", maintainBean.getDate1(), maintainBean.getDate2()));

		List<CosMatPriceMaintain> cmp = cosMatPriceMaintainDao.queryByPage(hql.concat(params.toString()),pageParams);
		List<MaintainBean> beans = new ArrayList<MaintainBean>();
		for(CosMatPriceMaintain c : cmp){
			if (HbUtils.isProxy(c)){
				c = HbUtils.deproxy(c);
			}
			MaintainBean bean = new MaintainBean();
			if(null != c.getMdMat()) {//辅料
				bean.setMatId(c.getMdMat().getId());
				 bean.setMatName(c.getMdMat().getName());
			}
			if(null != c.getMdShift()) //班次
				bean.setShiftName(c.getMdShift().getName());

			if(null != c.getMdUnit())//单位
				bean.setUnitName(c.getMdUnit().getName());
			BeanConvertor.copyProperties(c, bean);
			FillUserInfoUtil.fillCreateAndUpdateUserInfo(c,bean);
			beans.add(bean);
		}
		hql = "select count(*) from CosMatPriceMaintain o where 1=1 and o.del=0 ";

		long total = cosMatPriceMaintainDao.queryTotal(hql.concat(params.toString()));

		return new DataGrid(beans,total);
	}

	@LogAnno(operateType = "添加物料成本维护信息")
	@Override
	public void addCosMaintain(MaintainBean maintainBean) throws Exception {
		CosMatPriceMaintain cosMatPriceMaintain = new CosMatPriceMaintain();
		BeanConvertor.copyProperties(maintainBean,cosMatPriceMaintain);
		cosMatPriceMaintain.setMdMat(new MdMat(maintainBean.getMatId()));
		/*if(!StringUtils.isEmpty(maintainBean.getShiftId())){
			cosMatPriceMaintain.setMdShift(new MdShift(maintainBean.getShiftId()));
		}*/
		cosMatPriceMaintain.setMdUnit(new MdUnit(maintainBean.getUnitId()));
		cosMatPriceMaintain.setDel(0L);
		FillUserInfoUtil.fillCreateUserInfo(cosMatPriceMaintain,request);
		cosMatPriceMaintainDao.save(cosMatPriceMaintain);
	}

	@LogAnno(operateType = "编辑物料成本维护信息")
	@Override
	public void editCosMaintain(MaintainBean maintainBean) throws Exception {
		CosMatPriceMaintain cosMatPriceMaintain = cosMatPriceMaintainDao.findById(CosMatPriceMaintain.class, maintainBean.getId());
		cosMatPriceMaintain.setMdUnit(new MdUnit(maintainBean.getUnitId()));
		cosMatPriceMaintain.setMdMat(new MdMat(maintainBean.getMatId()));
		/*cosMatPriceMaintain.setMdShift(new MdShift(maintainBean.getShiftId()));*/
		FillUserInfoUtil.fillUpdateUserInfo(cosMatPriceMaintain,request);
		BeanConvertor.copyProperties(maintainBean,cosMatPriceMaintain);
	}

	@Override
	public void delCosMaintain(String id) throws Exception {
		cosMatPriceMaintainDao.findById(CosMatPriceMaintain.class, id).setDel(1L);
	}

	/**
	* @Title: getMaintainListByBean
	* @Description: 根据Bean获取List
	* @param  maintainBean
	* @return List<CosMatPriceMaintain>    返回类型
	* @throws
	 */
	@Override
	public List<CosMatPriceMaintain> getMaintainListByBean(MaintainBean maintainBean){
		StringBuffer hql=new StringBuffer();
		hql.append("from CosMatPriceMaintain o where 1=1 and o.del=0 ");
		if(StringUtil.notNull(maintainBean.getMatName())){
			hql.append("and  o.mdMat.name='"+maintainBean.getMatName()+"' ");
		}
		return cosMatPriceMaintainDao.query(hql.toString());
	}

	@Override
	public MaintainBean getMaintainBean(String id) throws Exception {
		CosMatPriceMaintain cosMatPriceMaintain = cosMatPriceMaintainDao.findById(CosMatPriceMaintain.class, id);
		MaintainBean bean = new MaintainBean();
		if(null != cosMatPriceMaintain.getMdMat()) bean.setMatName(cosMatPriceMaintain.getMdMat().getName());

		if(null != cosMatPriceMaintain.getMdMat()) bean.setMatId(cosMatPriceMaintain.getMdMat().getId());

		if(null != cosMatPriceMaintain.getMdShift()) bean.setShiftId(cosMatPriceMaintain.getMdShift().getId());

		if(null != cosMatPriceMaintain.getMdUnit()) bean.setUnitId(cosMatPriceMaintain.getMdUnit().getId());

		if(null != cosMatPriceMaintain.getMdUnit()) bean.setUnitName(cosMatPriceMaintain.getMdUnit().getName());

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

	@Override
	public List<UnitBean> queryAllUtil() throws Exception {
		return BeanConvertor.copyList(mdUnitDao.query("from MdUnit o where o.del='0' and o.enable=1"), UnitBean.class);
	}
}