package com.shlanbao.tzsc.pms.md.FilterCount.service.impl;


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

import com.shlanbao.tzsc.base.dao.SchFilterCountDaoI;
import com.shlanbao.tzsc.base.mapping.SchFilterCount;
import com.shlanbao.tzsc.base.model.DataGrid;
import com.shlanbao.tzsc.base.service.BaseService;
import com.shlanbao.tzsc.pms.md.FilterCount.SchFilterCountBean;
import com.shlanbao.tzsc.pms.md.FilterCount.service.FilterCountServiceI;
import com.shlanbao.tzsc.utils.tools.BeanConvertor;
import com.shlanbao.tzsc.utils.tools.StringUtil;

import javax.servlet.http.HttpServletRequest;
import java.util.List;

@Service
public class FilterCountServiceImpl extends BaseService implements
		FilterCountServiceI {
	@Autowired
	private SchFilterCountDaoI filterCountDaoI;
	@Autowired
	private HttpServletRequest request;

	@Override
	public DataGrid getAllFilterCount(SchFilterCountBean filterCount) throws Exception {
		String hql = "from SchFilterCount o where 1=1 ";
		if (StringUtil.notEmpty(filterCount.getStim())&&StringUtil.notEmpty(filterCount.getEtim())) {
			hql+="and to_char(o.stim,'yyyy-mm-dd')>='"+filterCount.getStim()+"'&& to_char(o.etim,'yyyy-mm-dd')<='"+filterCount.getEtim()+"'";
		}
		List<SchFilterCount> query = filterCountDaoI.query(hql);
		List<SchFilterCountBean> rows = BeanConvertor.copyList(query, SchFilterCountBean.class);
		FillUserInfoUtil.fillCreateAndUpdateUserInfoByLists(query,rows);
		return new DataGrid(rows, 0L);
	}
	@LogAnno(operateType = "新增成型配盘数量")
	@Override
	public void addFilterCount(SchFilterCountBean filterCount) throws Exception {
		SchFilterCount o = BeanConvertor.copyProperties(filterCount, SchFilterCount.class);
		o.setMatName(filterCountDaoI.queryBySql("select name from md_mat where id = ?", o.getMat()).get(0).toString());
		FillUserInfoUtil.fillCreateUserInfo(o,request);
		filterCountDaoI.save(o);
	}
	@LogAnno(operateType = "编辑成型配盘数量")
	@Override
	public void editFilterCount(SchFilterCountBean filterCount) throws Exception {
		SchFilterCount o = BeanConvertor.copyProperties(filterCount, SchFilterCount.class);
		SchFilterCount schFilterCount = filterCountDaoI.findById(SchFilterCount.class, filterCount.getId());
		BeanConvertor.copyProperties(o,schFilterCount);
		schFilterCount.setMatName(filterCountDaoI.queryBySql("select name from md_mat where id = ?", schFilterCount.getMat()).get(0).toString());
		FillUserInfoUtil.fillUpdateUserInfo(schFilterCount,request);
		filterCountDaoI.update(schFilterCount);
	}
	@LogAnno(operateType = "删除成型配盘数量")
	@Override
	public void deleteFilterCount(String id) throws Exception {
		filterCountDaoI.deleteById(id, SchFilterCount.class);
		
	}
	@Override
	public SchFilterCountBean getFilterCountById(String id) throws Exception {
		return BeanConvertor.copyProperties(filterCountDaoI.findById(SchFilterCount.class, id),SchFilterCountBean.class);
	}

	@Override
	public void batchDdeleteFilterCount(String ids) {
		String[] split = ids.split(",");
		for (int i = 0; i < split.length; i++) {
			filterCountDaoI.deleteById(split[i], SchFilterCount.class);
		}
	}

}