package com.shlanbao.tzsc.pms.equ.sbglplan.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.EqmCheckcatPlanDaoI;
|
import com.shlanbao.tzsc.base.dao.EqmSpotchRecordDaoI;
|
import com.shlanbao.tzsc.base.mapping.EqmCheckcatPlan;
|
import com.shlanbao.tzsc.base.mapping.EqmSpotchRecode;
|
import com.shlanbao.tzsc.base.mapping.MdEquipment;
|
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.equ.sbglplan.beans.EqmSpotchRecodeBean;
|
import com.shlanbao.tzsc.pms.equ.sbglplan.service.EqmCheckcatPlanServiceI;
|
import com.shlanbao.tzsc.utils.tools.DateUtil;
|
import com.shlanbao.tzsc.utils.tools.StringUtil;
|
|
@Service
|
public class EqmCheckcatPlanServiceImpl extends BaseService implements EqmCheckcatPlanServiceI {
|
|
@Autowired
|
private EqmCheckcatPlanDaoI eqmCheckcatPlanDao;
|
@Autowired
|
private EqmSpotchRecordDaoI eqmSpotchRecordDao;
|
/**
|
* 根据id查询到具体的点修记录详情
|
* @param esrBean
|
* @return czgId,wxgId,wxzugId
|
*/
|
|
public DataGrid queryInfoById(String id){
|
//String sql="select eqp_name,shift_name,team_name,ch_location,ch_status,ch_date,create_user_name,update_time,remark from EQM_SPOTCH_RECODE where id='"+id+"'";
|
String hql="from EqmSpotchRecode where id='"+id+"'";
|
List<EqmSpotchRecode> map=eqmSpotchRecordDao.query(hql, null);
|
List<EqmSpotchRecodeBean> rows = new ArrayList<EqmSpotchRecodeBean>();
|
if(map.size()>0){
|
for(EqmSpotchRecode b:map){
|
EqmSpotchRecodeBean bean = new EqmSpotchRecodeBean();
|
bean.setEqpName(b.getEqpName());
|
bean.setShiftName(b.getShiftName());
|
bean.setTeamName(b.getTeamName());
|
bean.setChLocation(b.getChLocation());
|
/*int sta = b.getChStatus();
|
String status="";
|
if(sta==0){//状态，暂时写死，0-未完成，1-已完成，2-有故障
|
status="未完成";
|
}else if(sta==1){
|
status="完成";
|
}else if(sta==2){
|
status="有故障";
|
}*/
|
bean.setChStatus(b.getChStatus());
|
bean.setChDate(b.getChDate().toString());
|
bean.setCreateUserName(b.getCreateUserName());
|
bean.setUpdateTime(b.getUpdateTime().toString());
|
bean.setRemark(b.getRemark());
|
bean.setId(b.getId());
|
bean.setEqmId(b.getEqmId().toString());
|
rows.add(bean);
|
}
|
}
|
return new DataGrid(rows,null);
|
/*String hql=null;
|
List<EqmSpotchRecodeBean> rows=new ArrayList<EqmSpotchRecodeBean>();
|
if (StringUtil.notNull(czgId)&&!czgId.equals("undefined")&&!czgId.equals("null")) {
|
hql="from EqmSpotchRecode o where o.id= ?";
|
EqmSpotchRecode map=(EqmSpotchRecode) eqmCheckcatPlanDao.unique(hql.toString(), czgId);
|
EqmSpotchRecodeBean bean=new EqmSpotchRecodeBean(
|
czgId,
|
map.getEqmId().getId(),
|
map.getEqpName(),
|
map.getShiftId().getId(),
|
map.getShiftName(),
|
map.getTeamId(),
|
map.getTeamName(),
|
map.getChTypeId(),
|
map.getChTypeName(),
|
map.getChLocation(),
|
map.getChStandard(),
|
map.getChMethod(),
|
DateUtil.formatDateToString(map.getChDate(),"yyyy-MM-dd"),
|
map.getCreateUserId(),
|
map.getCreateUserName(),
|
DateUtil.formatDateToString(map.getCreateTime(),"yyyy-MM-dd HH:mm:ss"),
|
map.getChStatus(),
|
map.getBreLocation(),
|
map.getRemark(),
|
map.getBreId(),
|
map.getUpdateUserId(),
|
map.getUpdateUserName(),
|
DateUtil.formatDateToString(map.getUpdateTime(),"yyyy-MM-dd HH:mm:ss"),
|
map.getDel()
|
);
|
rows.add(bean);
|
|
}
|
if (StringUtil.notNull(wxgId)&&!wxgId.equals("undefined")&&!wxgId.equals("null")) {
|
hql="from EqmSpotchRecode o where o.id= ?";
|
EqmSpotchRecode map=(EqmSpotchRecode) eqmCheckcatPlanDao.unique(hql.toString(), wxgId);
|
EqmSpotchRecodeBean bean=new EqmSpotchRecodeBean(
|
czgId,
|
map.getEqmId().getId(),
|
map.getEqpName(),
|
map.getShiftId().getId(),
|
map.getShiftName(),
|
map.getTeamId(),
|
map.getTeamName(),
|
map.getChTypeId(),
|
map.getChTypeName(),
|
map.getChLocation(),
|
map.getChStandard(),
|
map.getChMethod(),
|
DateUtil.formatDateToString(map.getChDate(),"yyyy-MM-dd"),
|
map.getCreateUserId(),
|
map.getCreateUserName(),
|
DateUtil.formatDateToString(map.getCreateTime(),"yyyy-MM-dd HH:mm:ss"),
|
map.getChStatus(),
|
map.getBreLocation(),
|
map.getRemark(),
|
map.getBreId(),
|
map.getUpdateUserId(),
|
map.getUpdateUserName(),
|
DateUtil.formatDateToString(map.getUpdateTime(),"yyyy-MM-dd HH:mm:ss"),
|
map.getDel()
|
);
|
rows.add(bean);
|
|
}
|
if (StringUtil.notNull(wxzugId)&&!wxzugId.equals("undefined")&&!wxzugId.equals("null")) {
|
hql="from EqmSpotchRecode o where o.id= ?";
|
EqmSpotchRecode map=(EqmSpotchRecode) eqmCheckcatPlanDao.unique(hql.toString(), wxzugId);
|
EqmSpotchRecodeBean bean=new EqmSpotchRecodeBean(
|
czgId,
|
map.getEqmId().getId(),
|
map.getEqpName(),
|
map.getShiftId().getId(),
|
map.getShiftName(),
|
map.getTeamId(),
|
map.getTeamName(),
|
map.getChTypeId(),
|
map.getChTypeName(),
|
map.getChLocation(),
|
map.getChStandard(),
|
map.getChMethod(),
|
DateUtil.formatDateToString(map.getChDate(),"yyyy-MM-dd"),
|
map.getCreateUserId(),
|
map.getCreateUserName(),
|
DateUtil.formatDateToString(map.getCreateTime(),"yyyy-MM-dd HH:mm:ss"),
|
map.getChStatus(),
|
map.getBreLocation(),
|
map.getRemark(),
|
map.getBreId(),
|
map.getUpdateUserId(),
|
map.getUpdateUserName(),
|
DateUtil.formatDateToString(map.getUpdateTime(),"yyyy-MM-dd HH:mm:ss"),
|
map.getDel()
|
);
|
rows.add(bean);
|
|
}
|
return new DataGrid(rows, 10L);*/
|
}
|
|
/**
|
* 根据工单查点检记录
|
*/
|
@Override
|
public DataGrid queryPlanInfo(EqmSpotchRecodeBean eSRBean,PageParams pageParams) {
|
StringBuffer sb = new StringBuffer();
|
|
sb.append("(SELECT eqp_name,to_char(create_time,'yyyy-MM-dd') as date_p,");
|
sb.append(" shift_name,ch_date,(SELECT DES from SYS_EQP_TYPE et where et.id=s.set_id) des,(SELECT name from SYS_EQP_TYPE et where et.id=s.set_id) sys_name,ch_type_name,create_user_name,id,s.ch_status,ROW_NUMBER() OVER(ORDER BY s.ch_date DESC) num FROM EQM_SPOTCH_RECODE s where 1=1");
|
if(StringUtil.notNull(eSRBean.getShiftId())){
|
sb.append(" and shift_id='"+eSRBean.getShiftId()+"'");
|
}
|
if(StringUtil.notNull(eSRBean.getEqmId())){
|
sb.append(" and eqp_id='"+eSRBean.getEqmId()+"'");
|
}
|
//执行开始时间
|
if(StringUtil.notNull(eSRBean.getChDate())){
|
sb.append(" and to_char(create_time,'yyyy-MM-dd')>='"+eSRBean.getChDate()+"'");
|
}
|
//执行结束时间
|
if(StringUtil.notNull(eSRBean.getEndChDate())){
|
sb.append(" and to_char(create_time,'yyyy-MM-dd')<='"+eSRBean.getEndChDate()+"'");
|
}
|
sb.append(" ) ");
|
String sta="SELECT * from ";
|
String end="zl where zl.num>"+pageParams.getRows()*(pageParams.getPage()-1)+" and zl.num<="+pageParams.getRows()*pageParams.getPage()+" ORDER BY zl.ch_date DESC";
|
List<?> list= eqmCheckcatPlanDao.queryBySql(sta+sb.toString()+end);
|
List<?> listFY= eqmCheckcatPlanDao.queryBySql(sb.toString());
|
List<EqmSpotchRecodeBean> beans=new ArrayList<EqmSpotchRecodeBean>();
|
if(list.size()>0){
|
for(Object o:list){
|
try {
|
Object[] temp=(Object[]) o;
|
EqmSpotchRecodeBean b= new EqmSpotchRecodeBean();
|
b.setEqpName(temp[0].toString());
|
if(temp[1]!=null){
|
b.setOrderDate(temp[1].toString());
|
}
|
b.setShiftName(temp[2].toString());
|
b.setChDate(temp[3].toString());
|
b.setEqpTypeDes(temp[4].toString());
|
b.setEqpTypeName(temp[5].toString());
|
b.setChTypeName(temp[6].toString());
|
b.setCreateUserName(temp[7].toString());
|
b.setId(temp[8].toString());
|
b.setStatus(Integer.valueOf(temp[9].toString()));
|
beans.add(b);
|
} catch (Exception e) {
|
e.printStackTrace();
|
}
|
}
|
}
|
long total=listFY.size();
|
return new DataGrid(beans, total);
|
}
|
}
|
