package com.shlanbao.tzsc.pms.md.eqpStopMaintain.service.impl;
|
|
import java.util.ArrayList;
|
import java.util.List;
|
|
import com.shlanbao.tzsc.base.mapping.*;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.stereotype.Service;
|
|
|
import com.shlanbao.tzsc.base.dao.BaseDaoI;
|
import com.shlanbao.tzsc.base.dao.EqpStopMaintainDaoI;
|
import com.shlanbao.tzsc.base.model.DataGrid;
|
import com.shlanbao.tzsc.base.service.BaseService;
|
import com.shlanbao.tzsc.pms.md.eqpStopMaintain.EqpStopMaintainBean;
|
import com.shlanbao.tzsc.pms.md.eqpStopMaintain.service.EqpStopMaintainServiceI;
|
import com.shlanbao.tzsc.utils.tools.BeanConvertor;
|
import com.shlanbao.tzsc.utils.tools.DateUtil;
|
import com.shlanbao.tzsc.utils.tools.StringUtil;
|
|
@Service
|
public class EqpStopMaintainServiceImpl extends BaseService implements
|
EqpStopMaintainServiceI {
|
|
@Autowired
|
private EqpStopMaintainDaoI eqpStopMaintainDaoI;
|
|
@Autowired
|
private BaseDaoI<Object> baseDao;
|
|
@Override
|
public DataGrid getAllStopMaintain(EqpStopMaintainBean eqpStopMaintainBean) throws Exception {
|
String hql="from EqpStopMaintain o left join fetch o.mdteam t left join fetch o.mdeqp e join fetch o.mdca s where 1=1";//1 deleted data is not visible
|
String params="";
|
if(StringUtil.notEmpty(eqpStopMaintainBean.getsDate())){
|
params = params.concat(" and to_char(o.actualDate,'yyyy-MM') = '" + eqpStopMaintainBean.getsDate() + "'");
|
}
|
if(StringUtil.notEmpty(eqpStopMaintainBean.getTeamId())){
|
params = params.concat(" and t.code = '" + eqpStopMaintainBean.getTeamId() + "'");
|
}
|
if(StringUtil.notEmpty(eqpStopMaintainBean.getEqptype())){
|
params = params.concat(" and s.id = '" + eqpStopMaintainBean.getEqptype() + "'");
|
}
|
if(StringUtil.notEmpty(eqpStopMaintainBean.getEqpId())){
|
params = params.concat(" and e.id = '" + eqpStopMaintainBean.getEqpId() + "'");
|
}
|
if(StringUtil.notEmpty(eqpStopMaintainBean.getContent())){
|
params = params.concat(" and o.content = '" + eqpStopMaintainBean.getContent() + "'");
|
}
|
|
params = params.concat(" order by to_char(o.actualDate,'yyyy-MM-dd')");
|
|
List<EqpStopMaintain> rows=eqpStopMaintainDaoI.query(hql.concat(params));
|
List<EqpStopMaintainBean> orderBeans = new ArrayList<EqpStopMaintainBean>();
|
|
EqpStopMaintainBean bean = null;
|
try {
|
|
for (EqpStopMaintain eqpStopMaintain : rows) {
|
|
bean = BeanConvertor.copyProperties(eqpStopMaintain, EqpStopMaintainBean.class);
|
String realStim = DateUtil.datetoStr(eqpStopMaintain.getActualDate(), "yyyy-MM-dd");
|
bean.setActualDate(realStim);
|
if (eqpStopMaintain.getMdteam()!=null) {
|
bean.setTeamname(eqpStopMaintain.getMdteam().getName());
|
bean.setTeamId(eqpStopMaintain.getMdteam().getId());
|
}
|
if (eqpStopMaintain.getMdShift()!=null) {
|
bean.setShiftName(eqpStopMaintain.getMdShift().getName());
|
bean.setShiftId(eqpStopMaintain.getMdShift().getId());
|
}
|
if (eqpStopMaintain.getMdeqp()!=null) {
|
bean.setEqpId(eqpStopMaintain.getMdeqp().getId());
|
bean.setEqptype(eqpStopMaintain.getMdeqp().getMdEqpType().getMdEqpCategory().getCode());
|
bean.setEquipment(eqpStopMaintain.getMdeqp().getEquipmentName());
|
}
|
bean.setContent(eqpStopMaintain.getContent());
|
bean.setNum(eqpStopMaintain.getNum());
|
bean.setFree(eqpStopMaintain.getFree());
|
bean.setFree2(eqpStopMaintain.getFree2());
|
bean.setFree1(eqpStopMaintain.getFree1());
|
orderBeans.add(bean);
|
|
bean = null;
|
}
|
return new DataGrid(orderBeans, 0L);
|
|
} catch (Exception e) {
|
|
log.error("POVO转换异常", e);
|
|
}
|
|
return null;
|
|
}
|
|
@Override
|
public void addStopMaintain(EqpStopMaintainBean eqpStopMaintainBean) throws Exception {
|
EqpStopMaintain o = BeanConvertor.copyProperties(eqpStopMaintainBean, EqpStopMaintain.class);
|
|
List<?> shiftId = eqpStopMaintainDaoI.queryBySql("select shift from sch_calendar where to_char(date_,'yyyy-mm-dd') = '"+eqpStopMaintainBean.getActualDate()+"' and team = "+eqpStopMaintainBean.getTeamId()+" and workshop = 1 ");
|
|
|
if (shiftId!=null && shiftId.size()>0) {
|
o.setMdShift(new MdShift(shiftId.get(0).toString()));
|
}
|
|
/*Date abc=DateUtil.strToDate(eqpStopMaintainBean.getActualDate()+" 00:00:00","yyyy-MM-dd HH:mm:ss");
|
o.setActualDate(abc);*/
|
|
o.setMdteam(new MdTeam(eqpStopMaintainBean.getTeamId()));
|
o.setMdeqp(new MdEquipment(eqpStopMaintainBean.getEqpId()));
|
/* String ceh=eqpStopMaintainDaoI.queryBySql("select EQP_TYPE_ID from MD_EQUIPMENT where code = ?", eqpStopMaintainBean.getEqptype()).get(0).toString();
|
o.setMdca(new MdEqpCategory(ceh));*/
|
o.setMdca(new MdEqpCategory(eqpStopMaintainBean.getEqptype()));
|
eqpStopMaintainDaoI.save(o);
|
|
}
|
|
|
|
@Override
|
public void editStopMaintain(EqpStopMaintainBean eqpStopMaintainBean) throws Exception {
|
EqpStopMaintain o = BeanConvertor.copyProperties(eqpStopMaintainBean, EqpStopMaintain.class);
|
List<?> shiftId = eqpStopMaintainDaoI.queryBySql("select shift from sch_calendar where to_char(date_,'yyyy-mm-dd') = '"+eqpStopMaintainBean.getActualDate()+"' and team = "+eqpStopMaintainBean.getTeamId()+" and workshop = 1 ");
|
|
|
if (shiftId!=null && shiftId.size()>0) {
|
o.setMdShift(new MdShift(shiftId.get(0).toString()));
|
}
|
o.setMdteam(new MdTeam(eqpStopMaintainBean.getTeamId()));
|
o.setMdeqp(new MdEquipment(eqpStopMaintainBean.getEqpId()));
|
o.setMdca(new MdEqpCategory(eqpStopMaintainBean.getEqptype()));
|
EqpStopMaintain s;
|
s=o;
|
eqpStopMaintainDaoI.update(s);
|
|
}
|
|
|
@Override
|
public EqpStopMaintainBean getStopMaintainById(String id) throws Exception {
|
/* return BeanConvertor.copyProperties(eqpStopMaintainDaoI.findById(EqpStopMaintain.class, id),EqpStopMaintainBean.class);
|
*/
|
EqpStopMaintain eqpStopMaintain = eqpStopMaintainDaoI.findById(EqpStopMaintain.class, id);
|
|
EqpStopMaintainBean bean = BeanConvertor.copyProperties(eqpStopMaintain, EqpStopMaintainBean.class);
|
bean.setEqptype(eqpStopMaintain.getMdca().getId());
|
bean.setTeamname(eqpStopMaintain.getMdteam().getName());
|
bean.setTeamId(eqpStopMaintain.getMdteam().getId());
|
bean.setEquipment(eqpStopMaintain.getMdeqp().getEquipmentName());
|
bean.setEqpId(eqpStopMaintain.getMdeqp().getId());
|
bean.setFree2(eqpStopMaintain.getMdca().getName());
|
|
return bean;
|
|
}
|
|
@Override
|
public void deleteStopMaintain(String id) throws Exception {
|
eqpStopMaintainDaoI.deleteById(id, EqpStopMaintain.class);
|
|
}
|
|
@Override
|
public void enableStopMaintain(String id,int enable) {
|
List<Object> list = new ArrayList<>();
|
list.add(enable);
|
list.add(id);
|
eqpStopMaintainDaoI.updateBySql("update EQP_STOP_MAINTAIN set free1 = ? where id = ?", list);
|
|
}
|
|
|
|
}
|
