package com.shlanbao.tzsc.pms.qm.packagecp.service.impl;
|
|
import java.util.ArrayList;
|
import java.util.Date;
|
import java.util.List;
|
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.stereotype.Service;
|
|
import com.shlanbao.tzsc.base.dao.QmSelfCheckStripDaoI;
|
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.packagecp.beans.PackageCpBean;
|
import com.shlanbao.tzsc.pms.qm.packagecp.service.PackageCpService;
|
/**
|
* 卷包车间成品物理检验记录实现类
|
* <li>@author luther.zhang
|
* <li>@create 2015-02-26
|
*/
|
@Service
|
public class PackageCpServiceImpl extends BaseService implements PackageCpService{
|
@Autowired
|
private QmSelfCheckStripDaoI qmSelfCheckStripDao;
|
@Override
|
public DataGrid queryList(PackageCpBean bean, PageParams pageParams) throws Exception{
|
StringBuffer hql=new StringBuffer();
|
hql.append("from QmSelfCheckStrip o ");
|
hql.append("left join fetch o.sysUser suser ");//用户信息
|
hql.append("left join fetch o.schWorkorder work ");//工单信息
|
hql.append("left join fetch work.mdUnit dw ");//单位信息
|
hql.append("left join fetch work.mdEquipment sb ");//设备信息
|
hql.append("left join fetch work.mdTeam bz ");//班组信息
|
hql.append("left join fetch work.mdShift bc ");//班次信息
|
hql.append("left join fetch work.mdMat ph ");//牌号信息
|
hql.append("left join fetch sb.mdWorkshop cj ");//车间信息
|
hql.append("where o.del=0 ");//表示没删除
|
|
List<Object> params = new ArrayList<Object>();
|
if(StringUtil.notNull(bean.getTime())){//自检时间
|
hql.append("and o.time >=? ");
|
bean.setTime(bean.getTime()+" 00:00:00");
|
Date dateStr = DateUtil.strToDate(bean.getTime(), "yyyy-MM-dd HH:mm:ss");
|
params.add(dateStr);
|
}
|
if(StringUtil.notNull(bean.getEndTime())){//自检时间
|
hql.append("and o.time <=? ");
|
bean.setEndTime(bean.getEndTime()+" 23:59:59");
|
Date dateStr = DateUtil.strToDate(bean.getEndTime(), "yyyy-MM-dd HH:mm:ss");
|
params.add(dateStr);
|
}
|
|
if(StringUtil.notNull(bean.getMdTeamId())){//mdTeamId 班组
|
hql.append("and bz.id =? ");
|
params.add(bean.getMdTeamId());
|
}
|
if(StringUtil.notNull(bean.getMdWorkshopId())){//车间
|
hql.append("and cj.id =? ");
|
params.add(bean.getMdWorkshopId());
|
}
|
if(StringUtil.notNull(bean.getMdShiftId())){//班次
|
hql.append("and bc.id = ? ");
|
params.add(bean.getMdShiftId());
|
}
|
if(StringUtil.notNull(bean.getMdEquipmentId())){//设备
|
hql.append("and sb.id = ? ");
|
params.add(bean.getMdEquipmentId());
|
}
|
try {
|
long total=qmSelfCheckStripDao.queryTotal("select count(*) "+hql.toString().replaceAll("fetch", ""),params);
|
|
List<PackageCpBean> list= new ArrayList<PackageCpBean>();
|
if(total>0){
|
hql.append("order by o.time asc ");
|
List<QmSelfCheckStrip> rows = qmSelfCheckStripDao.queryByPage(hql.toString(), pageParams.getPage(), pageParams.getRows(), params);
|
for(QmSelfCheckStrip strip:rows){
|
PackageCpBean oneBean = BeanConvertor.copyProperties(strip, PackageCpBean.class);
|
|
if(null!=strip.getSysUser()){//用户信息
|
oneBean.setuId(strip.getSysUser().getId());//用户ID
|
oneBean.setuName(strip.getSysUser().getName());//用户名称
|
}
|
if(null!=strip.getSchWorkorder()&&null!=strip.getSchWorkorder().getMdUnit()){//单位信息
|
oneBean.setMdUnitId(strip.getSchWorkorder().getMdUnit().getId());//单位ID
|
oneBean.setMdMatName(strip.getSchWorkorder().getMdUnit().getName());//单位名称
|
}
|
if(null!=strip.getSchWorkorder()&&null!=strip.getSchWorkorder().getMdTeam()){//班组信息
|
oneBean.setMdTeamId(strip.getSchWorkorder().getMdTeam().getId());//班组ID
|
oneBean.setMdTeamName(strip.getSchWorkorder().getMdTeam().getName());//班组名称
|
}
|
if(null!=strip.getSchWorkorder()&&null!=strip.getSchWorkorder().getMdShift()){//班次信息
|
oneBean.setMdShiftId(strip.getSchWorkorder().getMdShift().getId());//班次ID
|
oneBean.setMdShiftName(strip.getSchWorkorder().getMdShift().getName());//班次名称
|
}
|
if(null!=strip.getSchWorkorder()&&null!=strip.getSchWorkorder().getMdEquipment()){//设备信息
|
oneBean.setMdEquipmentId(strip.getSchWorkorder().getMdEquipment().getId());//设备ID
|
oneBean.setMdEquipmentName(strip.getSchWorkorder().getMdEquipment().getEquipmentName());//设备名称
|
if(null!=strip.getSchWorkorder().getMdEquipment().getMdWorkshop()){//车间信息
|
oneBean.setMdWorkshopId(strip.getSchWorkorder().getMdEquipment().getMdWorkshop().getId());
|
oneBean.setMdWorkshopName(strip.getSchWorkorder().getMdEquipment().getMdWorkshop().getName());
|
}
|
}
|
if(null!=strip.getSchWorkorder()&&null!=strip.getSchWorkorder().getMdMat()){//牌号信息
|
oneBean.setMdMatId(strip.getSchWorkorder().getMdMat().getId());//牌号ID
|
oneBean.setMdMatName(strip.getSchWorkorder().getMdMat().getName());//牌号名称
|
}
|
list.add(oneBean);
|
}
|
}
|
return new DataGrid(list, total);
|
} catch (Exception e) {
|
log.error("POVO转换异常", e);
|
}
|
return null;
|
}
|
|
}
|
