package com.shlanbao.tzsc.pms.sch.shiftexchg.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.SchShiftExchgDaoI;
import com.shlanbao.tzsc.base.dao.SchShiftExchgDetDaoI;
import com.shlanbao.tzsc.base.mapping.MdMat;
import com.shlanbao.tzsc.base.mapping.MdShift;
import com.shlanbao.tzsc.base.mapping.MdTeam;
import com.shlanbao.tzsc.base.mapping.MdUnit;
import com.shlanbao.tzsc.base.mapping.SchShiftExchg;
import com.shlanbao.tzsc.base.mapping.SchShiftExchgDet;
import com.shlanbao.tzsc.base.mapping.SchWorkorder;
import com.shlanbao.tzsc.base.mapping.SysUser;
import com.shlanbao.tzsc.base.model.Combobox;
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.sch.shiftexchg.beans.ShiftExchgBean;
import com.shlanbao.tzsc.pms.sch.shiftexchg.beans.ShiftExchgDetBean;
import com.shlanbao.tzsc.pms.sch.shiftexchg.service.ShiftExchgServiceI;

import javax.servlet.http.HttpServletRequest;

@Service
public class ShiftExchgServiceImpl extends BaseService implements ShiftExchgServiceI{
	@Autowired
	private SchShiftExchgDaoI schShiftExchgDao;
	@Autowired
	private SchShiftExchgDetDaoI schShiftExchgDetDao;
	@Autowired
	private HttpServletRequest request;
	@SuppressWarnings("null")
	@Override
	public DataGrid getExchgs(ShiftExchgBean shiftExchgBean,
			PageParams pageParams) {
		StringBuffer hql=new StringBuffer(1000);
		hql.append("from SchShiftExchg o  ");
		hql.append("left join fetch o.hoOrder.mdEquipment.mdWorkshop hoe  ");
		hql.append("left join fetch o.toOrder.mdEquipment toe  ");
		hql.append("left join fetch o.sysUserByHoUser hsu ");
		hql.append("left join fetch o.sysUserByToUser tsu ");
		hql.append("left join fetch o.mdMatByHoMat hmm ");
		hql.append("left join fetch o.mdMatByToMat tmm ");
		hql.append("left join fetch o.mdShiftByHoShift hms ");
		hql.append("left join fetch o.mdShiftByToShift tms ");
		hql.append("left join fetch o.mdTeamByHoTeam hmt ");
		hql.append("left join fetch o.mdTeamByToTeam tmt ");
		hql.append("where o.del=0 ");

		String params="";
		params = params.concat(" and hoe.code ="+shiftExchgBean.getWorkshop());

		params = params.concat(" and o.type ="+shiftExchgBean.getType());

		if(StringUtil.notNull(shiftExchgBean.getHoShift()))
			params = params.concat(" and hms.id="+shiftExchgBean.getHoShift());
		if(StringUtil.notNull(shiftExchgBean.getToShift()))
			params = params.concat(" and tms.id="+shiftExchgBean.getToShift());

		if(StringUtil.notNull(shiftExchgBean.getHoTeam()))
			params = params.concat(" and hmt.id="+shiftExchgBean.getHoTeam());
		if(StringUtil.notNull(shiftExchgBean.getToTeam()))
			params = params.concat(" and tmt.id="+shiftExchgBean.getToTeam());

		if(StringUtil.notNull(shiftExchgBean.getHoMat()))
			params = params.concat(" and hmm.id='"+shiftExchgBean.getHoMat())+"'";
		if(StringUtil.notNull(shiftExchgBean.getToMat()))
			params = params.concat(" and tmm.id='"+shiftExchgBean.getToMat())+"'";

		if(StringUtil.notNull(shiftExchgBean.getDate()))
			params = params.concat(" and to_char(o.date,'yyyy-MM-dd') >= '"+shiftExchgBean.getDate()+"'");
		if(StringUtil.notNull(shiftExchgBean.getDate2()))
			params = params.concat(" and to_char(o.date,'yyyy-MM-dd') <= '"+shiftExchgBean.getDate2()+"'");

		params = params.concat(" order by o.date desc ");
		String hql2=hql.toString();
		List<SchShiftExchg> rows=schShiftExchgDao.queryByPage(hql2.concat(params), pageParams);

		List<ShiftExchgBean> outputBeans = new ArrayList<ShiftExchgBean>();

		ShiftExchgBean bean = null;

		try {
			if(rows.size()>0 && rows!=null){
				for (SchShiftExchg schShiftExchg : rows) {
					bean = BeanConvertor.copyProperties(schShiftExchg, ShiftExchgBean.class);
					if(schShiftExchg.getHoOrder()!=null&&schShiftExchg.getHoOrder().getMdEquipment().getEquipmentName()!=null&&schShiftExchg.getHoOrder().getId()!=null){
						bean.setEquipment(schShiftExchg.getHoOrder().getMdEquipment().getEquipmentName());
						bean.setHoOrderId(schShiftExchg.getHoOrder().getId());
					}
					if(schShiftExchg.getMdMatByHoMat()!=null&&schShiftExchg.getMdMatByHoMat().getName()!=null){
						bean.setHoMat(schShiftExchg.getMdMatByHoMat().getName());
					}
					if(schShiftExchg.getMdShiftByHoShift()!=null&&schShiftExchg.getMdShiftByHoShift().getName()!=null){
						bean.setHoShift(schShiftExchg.getMdShiftByHoShift().getName());
					}
					if(schShiftExchg.getMdTeamByHoTeam()!=null&&schShiftExchg.getMdTeamByHoTeam().getName()!=null){
						bean.setHoTeam(schShiftExchg.getMdTeamByHoTeam().getName());
					}
					if(schShiftExchg.getSysUserByHoUser()!=null&&schShiftExchg.getSysUserByHoUser().getName()!=null){
						bean.setHoUser(schShiftExchg.getSysUserByHoUser().getName());
					}
					if(schShiftExchg.getMdMatByToMat()!=null&&schShiftExchg.getMdMatByToMat().getName()!=null){
						bean.setToMat(schShiftExchg.getMdMatByToMat().getName());
					}
					if(schShiftExchg.getMdShiftByToShift()!=null&&schShiftExchg.getMdShiftByToShift().getName()!=null){
						bean.setToShift(schShiftExchg.getMdShiftByToShift().getName());
					}
					if(schShiftExchg.getMdTeamByToTeam()!=null&&schShiftExchg.getMdTeamByToTeam().getName()!=null){
						bean.setToTeam(schShiftExchg.getMdTeamByToTeam().getName());
					}
					if(schShiftExchg.getSysUserByToUser()!=null&&schShiftExchg.getSysUserByToUser().getName()!=null){
						bean.setToUser(schShiftExchg.getSysUserByToUser().getName());
					}
					FillUserInfoUtil.fillCreateAndUpdateUserInfo(schShiftExchg,bean);
					outputBeans.add(bean);
					bean = null;
				}
			}
			hql2= "select count(o) ".concat(hql2.replace("fetch", ""));
			long total=schShiftExchgDao.queryTotal(hql2.concat(params));
			return new DataGrid(outputBeans, total);
		} catch (Exception e) {
			log.error("POVO转换异常", e);
		}
		return null;
	}
	@Override
	public void addExchg(ShiftExchgBean shiftExchgBean) {
		SchShiftExchg o = new SchShiftExchg();
		o.setDate(DateUtil.formatStringToDate(shiftExchgBean.getDate(), "yyyy-MM-dd"));
		//交班部分
		o.setSysUserByHoUser(new SysUser(shiftExchgBean.getHoUser()));

		o.setMdMatByHoMat(new MdMat(shiftExchgBean.getHoMat()));

		o.setMdShiftByHoShift(new MdShift(shiftExchgBean.getHoShift()));

		o.setMdTeamByHoTeam(new MdTeam(shiftExchgBean.getHoTeam()));

		o.setHoTime(DateUtil.formatStringToDate(shiftExchgBean.getHoTime(), "yyyy-MM-dd HH:mm"));

		o.setHoOrder(new SchWorkorder(shiftExchgBean.getHoOrderId()));
		//接班部分,可能会先填写交班，后填写接班
		if(StringUtil.notNull(shiftExchgBean.getToOrderId())){

			if(StringUtil.notNull(shiftExchgBean.getToUser()))
			o.setSysUserByToUser(new SysUser(shiftExchgBean.getToUser()));

			if(StringUtil.notNull(shiftExchgBean.getToMat()))
			o.setMdMatByToMat(new MdMat(shiftExchgBean.getToMat()));

			if(StringUtil.notNull(shiftExchgBean.getToShift()))
			o.setMdShiftByToShift(new MdShift(shiftExchgBean.getToShift()));

			if(StringUtil.notNull(shiftExchgBean.getToTeam()))
			o.setMdTeamByToTeam(new MdTeam(shiftExchgBean.getToTeam()));

			if(StringUtil.notNull(shiftExchgBean.getToTime()))
			o.setToTime(DateUtil.formatStringToDate(shiftExchgBean.getToTime(), "yyyy-MM-dd HH:mm"));

			if(StringUtil.notNull(shiftExchgBean.getToOrderId()))
			o.setToOrder(new SchWorkorder(shiftExchgBean.getToOrderId()));

		}


		o.setType(shiftExchgBean.getType());

		o.setDel(0L);

		schShiftExchgDao.save(o);
	}
	@LogAnno(operateType = "编辑换班记录")
	@Override
	public void editExchg(ShiftExchgBean shiftExchgBean) {

		SchShiftExchg o = schShiftExchgDao.findById(SchShiftExchg.class, shiftExchgBean.getId());
		if(StringUtil.notNull(shiftExchgBean.getHoTime())){
			o.setHoTime(DateUtil.formatStringToDate(shiftExchgBean.getHoTime(), "yyyy-MM-dd HH:mm"));
		}
		if(StringUtil.notNull(shiftExchgBean.getHoUser())){
			o.setSysUserByHoUser(new SysUser(shiftExchgBean.getHoUser()));
		}
		if(StringUtil.notNull(shiftExchgBean.getToUser())){
			o.setSysUserByToUser(new SysUser(shiftExchgBean.getToUser()));
		}
		if(StringUtil.notNull(shiftExchgBean.getToTime())){
			o.setToTime(DateUtil.formatStringToDate(shiftExchgBean.getToTime(), "yyyy-MM-dd HH:mm"));
		}
		FillUserInfoUtil.fillUpdateUserInfo(o,request);
	}
	@Override
	public void addExchgDet(ShiftExchgDetBean shiftExchgDetBean) {
		SchShiftExchgDet o = new SchShiftExchgDet();

		o.setSchShiftExchg(new SchShiftExchg(shiftExchgDetBean.getExchg()));

		o.setMdMat(new MdMat(shiftExchgDetBean.getMat()));

		o.setMdUnit(new MdUnit(shiftExchgDetBean.getUnit()));

		o.setQty(shiftExchgDetBean.getQty());

		o.setDel(0L);

		schShiftExchgDetDao.save(o);
	}
	@Override
	public void editExchgDet(ShiftExchgDetBean shiftExchgDetBean) {

		SchShiftExchgDet o = schShiftExchgDetDao.findById(SchShiftExchgDet.class, shiftExchgDetBean.getId());

		o.setQty(shiftExchgDetBean.getQty());
	}
	@LogAnno(operateType = "删除换班换牌记录")
	@Override
	public void deleteExchg(String id) {
		schShiftExchgDao.updateByParams("update SchShiftExchg o set o.del=1 where o.id=?", id);
	}
	@Override
	public void deleteExchgDet(String id) {
		schShiftExchgDetDao.updateByParams("update SchShiftExchgDet o set o.del=1 where o.id=?", id);
	}
	@Override
	public DataGrid getExchgDetsByExchgId(String id) throws Exception {
		String hql = "from SchShiftExchgDet o  left join fetch o.mdMat mt left join fetch o.mdUnit mu where o.del=0 and o.schShiftExchg.id=?";
		List<SchShiftExchgDet> list = schShiftExchgDetDao.query(hql, id);
		List<ShiftExchgDetBean> rows = new ArrayList<ShiftExchgDetBean>();
		for (SchShiftExchgDet schShiftExchgDet : list) {
			ShiftExchgDetBean bean = BeanConvertor.copyProperties(schShiftExchgDet, ShiftExchgDetBean.class);
			bean.setMat(schShiftExchgDet.getMdMat().getName());
			bean.setUnit(schShiftExchgDet.getMdUnit().getName());
			rows.add(bean);
		}
		return new DataGrid(rows, 0L);
	}
	@Override
	public List<Combobox> getBomsWorkorderId(String workorderId, String exchgId)
			throws Exception {
		String hql = "select o.mdMat from SchWorkorderBom o where o.schWorkorder.id=? and o.mdMat.id not in (select i.mdMat.id from SchShiftExchgDet i where i.schShiftExchg.id=?)";
		return BeanConvertor.copyList(schShiftExchgDetDao.query(List.class, hql,workorderId,exchgId), Combobox.class);
	}
	@Override
	public ShiftExchgBean getExchgById(String id) throws Exception {
		SchShiftExchg schShiftExchg = schShiftExchgDao.findById(SchShiftExchg.class, id);
		ShiftExchgBean bean =BeanConvertor.copyProperties(schShiftExchg,ShiftExchgBean.class);
		if(schShiftExchg.getHoOrder()!=null){
			bean.setEquipment(schShiftExchg.getHoOrder().getMdEquipment().getEquipmentName());
			bean.setHoOrderId(schShiftExchg.getHoOrder().getCode());
		}
		if(schShiftExchg.getToOrder()!=null){
			bean.setToOrderId(schShiftExchg.getToOrder().getCode());
		}
		if(schShiftExchg.getMdMatByHoMat()!=null){
			bean.setHoMat(schShiftExchg.getMdMatByHoMat().getName());
		}

		if(schShiftExchg.getMdShiftByHoShift()!=null){
			bean.setHoShift(schShiftExchg.getMdShiftByHoShift().getName());
		}

		if(schShiftExchg.getMdTeamByHoTeam()!=null){
			bean.setHoTeam(schShiftExchg.getMdTeamByHoTeam().getName());
		}

		if(schShiftExchg.getSysUserByHoUser()!=null){
			bean.setHoUser(schShiftExchg.getSysUserByHoUser().getName());
		}

		if(schShiftExchg.getMdMatByToMat()!=null){
			bean.setToMat(schShiftExchg.getMdMatByToMat().getName());
		}

		if(schShiftExchg.getMdShiftByToShift()!=null){
			bean.setToShift(schShiftExchg.getMdShiftByToShift().getName());
		}

		if(schShiftExchg.getMdTeamByToTeam()!=null){
			bean.setToTeam(schShiftExchg.getMdTeamByToTeam().getName());
		}

		if(schShiftExchg.getSysUserByToUser()!=null){
			bean.setToUser(schShiftExchg.getSysUserByToUser().getName());
		}

		return bean;
	}
	@Override
	public ShiftExchgDetBean getExchgDetById(String id) throws Exception {
		SchShiftExchgDet det = schShiftExchgDetDao.findById(SchShiftExchgDet.class, id);
		ShiftExchgDetBean bean = new ShiftExchgDetBean();
		bean.setId(det.getId());
		bean.setQty(det.getQty());
		bean.setUnit(det.getMdUnit().getName());
		bean.setMat(det.getMdMat().getName());
		return bean;
	}

	@Override
	public void batchDeleteExchgDet(String ids) {
		String[] id=ids.split(",");
		for (int i = 0; i < id.length; i++) {
			this.deleteExchg(id[i]);
		}
	}

}