package com.shlanbao.tzsc.pms.qm.qmOutWord.service.impl;

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

import com.shlanbao.tzsc.utils.tools.LogAnno;
import org.apache.commons.lang.StringUtils;
import org.hibernate.Query;
import org.hibernate.Session;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import com.shlanbao.tzsc.base.dao.QmOutwardDefectItemDaoI;
import com.shlanbao.tzsc.base.dao.QmSelfCheckStripDaoI;
import com.shlanbao.tzsc.base.mapping.QmOutwardDefectItem;
import com.shlanbao.tzsc.base.mapping.QmSelfCheckStrip;
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.utils.tools.BeanConvertor;
import com.shlanbao.tzsc.utils.tools.DateUtil;
import com.shlanbao.tzsc.utils.tools.StringUtil;

import com.shlanbao.tzsc.pms.qm.qmOutWord.beans.QmOutwardDefectItemBean;
import com.shlanbao.tzsc.pms.qm.qmOutWord.service.QmOutwardDefectItemService;
/**
 * 缺陷定义查询实现类
 * <li>@author luther.zhang
 * <li>@create 2015-02-27
 */
@Service
public class QmOutwardDefectItemServiceImpl extends BaseService implements QmOutwardDefectItemService{
	@Autowired
	private QmOutwardDefectItemDaoI qmOutwardDefectItemDao;
	private QmSelfCheckStripDaoI qmSelfCheckStripDao;
	@Override
	public DataGrid queryList(QmOutwardDefectItemBean bean, PageParams pageParams) throws Exception{
		StringBuffer hql=new StringBuffer();
		hql.append("from QmOutwardDefectItem q ");

		hql.append("where q.del=0 ");//表示没删除

		List<Object> params = new ArrayList<Object>();

		if(StringUtil.notNull(bean.getCode())){//缺陷名称
			hql.append(" and q.code like '%"+bean.getCode()+"%'");
			 //params.add(bean.getName());
		}
		if(StringUtil.notNull(bean.getName())){//缺陷名称
			hql.append(" and q.name like '%"+bean.getName()+"%'");
			 //params.add(bean.getName());
		}
		if(StringUtil.notNull(bean.getType())){//缺陷类型
			hql.append("and q.type = ? ");
			params.add(bean.getType());
		}
		if(StringUtil.notNull(bean.getLvl())){//缺陷等级
			hql.append("and q.lvl = ? ");
			params.add(bean.getLvl());
		}

		try {
			long total=qmOutwardDefectItemDao.queryTotal("select count(*) "+hql.toString(),params);

			List<QmOutwardDefectItemBean> list= new ArrayList<QmOutwardDefectItemBean>();
			if(total>0){
				//hql.append("order by q.lvl asc ");
				List<QmOutwardDefectItem> rows = qmOutwardDefectItemDao.queryByPage(hql.toString(), pageParams.getPage(), pageParams.getRows(), params);
				for(QmOutwardDefectItem strip:rows){
					QmOutwardDefectItemBean qmBean = BeanConvertor.copyProperties(strip, QmOutwardDefectItemBean.class);
					list.add(qmBean);
				}
			}
			return new DataGrid(list, total);
		} catch (Exception e) {
			log.error("POVO转换异常", e);
		}
		return null;
	}

	@LogAnno(operateType = "批量删除缺陷定义数据")
	@Override
	public void deleteDefectDefinition(String ids) {
		String[] split = ids.split(",");
		for (int i = 0; i < split.length; i++) {
			qmOutwardDefectItemDao.deleteByParams("update QmOutwardDefectItem set del='1' where id=?", split[i]);
		}
	}

}