package com.shlanbao.tzsc.pms.md.matparam.service.impl;
|
|
import java.util.*;
|
|
import com.shlanbao.tzsc.base.dao.impl.SchWorkorderBomDaoImpl;
|
import com.shlanbao.tzsc.base.dao.impl.SchWorkorderDaoImpl;
|
import com.shlanbao.tzsc.utils.tools.*;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.stereotype.Service;
|
|
import com.shlanbao.tzsc.base.dao.MdMatParamDaoI;
|
import com.shlanbao.tzsc.base.mapping.MdMat;
|
import com.shlanbao.tzsc.base.mapping.MdMatParam;
|
import com.shlanbao.tzsc.base.model.DataGrid;
|
import com.shlanbao.tzsc.base.service.BaseService;
|
import com.shlanbao.tzsc.pms.md.matparam.beans.MatParamBean;
|
import com.shlanbao.tzsc.pms.md.matparam.service.MatParamServiceI;
|
|
import javax.servlet.http.HttpServletRequest;
|
|
@Service
|
public class MatParamServiceImpl extends BaseService implements MatParamServiceI{
|
@Autowired
|
private MdMatParamDaoI mdMatParamDao;
|
@Autowired
|
private HttpServletRequest request;
|
@Autowired
|
private SchWorkorderDaoImpl schWorkorderDao;
|
@Autowired
|
private SchWorkorderBomDaoImpl schWorkorderBomDao;
|
|
@LogAnno(operateType = "新增辅料系数")
|
@Override
|
public void addMatParam(MatParamBean MatParamBean) throws Exception {
|
MdMatParam o = new MdMatParam();
|
BeanConvertor.copyProperties(MatParamBean, o);
|
o.setMdMat(new MdMat(MatParamBean.getMat()));
|
FillUserInfoUtil.fillCreateUserInfo(o,request);
|
mdMatParamDao.save(o);
|
}
|
@LogAnno(operateType = "编辑辅料系数")
|
@Override
|
public void editMatParam(MatParamBean MatParamBean) throws Exception {
|
MdMatParam o = mdMatParamDao.findById(MdMatParam.class, MatParamBean.getId());
|
BeanConvertor.copyProperties(MatParamBean, o);
|
o.setMdMat(new MdMat(MatParamBean.getMat()));
|
mdMatParamDao.save(o);
|
FillUserInfoUtil.fillUpdateUserInfo(o,request);
|
}
|
@LogAnno(operateType = "删除辅料系数")
|
@Override
|
public void deleteMatParam(String id) throws Exception {
|
mdMatParamDao.deleteById(id, MdMatParam.class);
|
}
|
@Override
|
public DataGrid getAllMatParams(MatParamBean matParamBean) throws Exception {
|
|
String hql = "from MdMatParam o where 1=1 ";
|
|
if(StringUtil.notNull(matParamBean.getMatType())){
|
|
hql = hql.concat(" and o.mdMat.mdMatType.id='"+matParamBean.getMatType()+"'");
|
|
}
|
//and o.name like '%"+MatParam.getName()+"%' order by o.seq asc";
|
List<MatParamBean> list = new ArrayList<MatParamBean>();
|
List<MdMatParam> ts=mdMatParamDao.query(hql);
|
for (MdMatParam mdMatParam :ts) {
|
MatParamBean bean = new MatParamBean();
|
bean.setId(mdMatParam.getId());
|
bean.setLength(mdMatParam.getLength());
|
bean.setWidth(mdMatParam.getWidth());
|
bean.setDensity(mdMatParam.getDensity());
|
bean.setVal(mdMatParam.getVal());
|
bean.setDes(mdMatParam.getDes());
|
if(mdMatParam.getMdMat()!=null){
|
bean.setMatName(mdMatParam.getMdMat().getId()); // 辅料ID
|
bean.setMat(mdMatParam.getMdMat().getName());//辅料
|
bean.setMatType(mdMatParam.getMdMat().getMdMatType().getId());
|
}
|
/*MatParamBean bean = BeanConvertor.copyProperties(mdMatParam, MatParamBean.class);
|
if(mdMatParam.getMdMat()!=null){
|
bean.setMatName(mdMatParam.getMdMat().getId());
|
bean.setMat(mdMatParam.getMdMat().getName());//辅料
|
}*/
|
FillUserInfoUtil.fillCreateAndUpdateUserInfo(mdMatParam,bean);
|
list.add(bean);
|
|
}
|
|
return new DataGrid(list, 0L);
|
}
|
@Override
|
public MatParamBean getMatParamById(String id) throws Exception{
|
|
MdMatParam MdMatParam = mdMatParamDao.findById(MdMatParam.class, id);
|
|
MatParamBean bean = BeanConvertor.copyProperties(MdMatParam, MatParamBean.class);
|
|
if(MdMatParam.getMdMat()!= null){
|
|
bean.setMat(MdMatParam.getMdMat().getId());//辅料
|
bean.setMatName(MdMatParam.getMdMat().getName());//辅料
|
|
}
|
|
return bean;
|
|
}
|
@LogAnno(operateType = "批量删除辅料系数")
|
@Override
|
public void batchDeleteMatParam(String ids) {
|
String[] split = ids.split(",");
|
for (int i = 0; i < split.length; i++) {
|
mdMatParamDao.deleteById(split[i], MdMatParam.class);
|
}
|
|
}
|
|
@Override
|
public void initCalcValue(){
|
StringBuilder sb=new StringBuilder();
|
sb.append("select ")
|
.append(" id,type,shift,team,eqp,mat,date_ ,bom_version, ")
|
.append(" (select code from MD_EQP_TYPE where id=(select eqp_type_id from MD_EQUIPMENT where id=eqp) ) as eqptype, ")
|
.append(" ( select equipment_code from MD_EQUIPMENT where id=eqp) as eqpcode ")
|
.append(" from SCH_WORKORDER ")
|
.append(" where del=0 ")
|
.append(" and to_char(date_,'yyyy-MM-dd')= to_char(sysdate,'yyyy-MM-dd') ")
|
.append(" and shift in (select shift from SCH_CALENDAR where 1=1 and del=0 and sysdate between stim and etim) ");
|
//查询当前班次所有工单
|
List<Object[]> schWorkorders=(List<Object[]>)schWorkorderDao.queryBySql(sb.toString());
|
List<Object[]> listfl=null;
|
if( schWorkorders!=null && schWorkorders.size()>0 ) {
|
for (Object[] s : schWorkorders) {
|
Map<String, String> map = new HashMap<>();
|
if (s[9] != null) {
|
RedisUtil.del(s[9] + "CC");
|
//查询当前工单的辅料系数 、设备类型、辅料类型
|
StringBuilder sb2 = new StringBuilder();
|
sb2.append("select ")
|
.append(" mp.val as flxsVal, ")
|
.append(" MP.EQP_TYPE as eqptype, ")
|
.append(" ( ")
|
.append(" select code from MD_MAT_TYPE where id=(select tid from MD_MAT where id=mp.mat) ")
|
.append(" ) as matTypeCode ")
|
.append(" from Sch_Workorder_Bom bom,Md_Mat_Param mp where 1=1 ")
|
.append(" and bom.del=0 ")
|
.append(" and bom.mat=mp.mat ")
|
.append(" and bom_lot_id= '" + s[7] + "'");
|
listfl = (List<Object[]>) schWorkorderBomDao.queryBySql(sb2.toString());
|
|
if ("1".equals(StringUtil.convertObjToString(s[1]))) {
|
Double shuisongzhiValue = null; //水松纸系数
|
if (listfl != null && listfl.size() > 0) {
|
for (Object[] fl : listfl) {
|
if ("3".equals(StringUtil.convertObjToString(fl[2]))) {
|
String flxsVal = StringUtil.convertObjToString(fl[0]);
|
if (!"" .equals(flxsVal)) {
|
shuisongzhiValue = Double.valueOf(flxsVal);
|
}
|
}
|
}
|
}
|
//判断是否配置完整
|
if (shuisongzhiValue == null) {
|
shuisongzhiValue = 1D;
|
log.error("工单ID:" + s[0] + " 水松纸转换参数未配置");
|
}
|
map.put("ssz", shuisongzhiValue.toString());
|
}
|
|
if ("2".equals(StringUtil.convertObjToString(s[1]))) { //包装机
|
if (listfl != null && listfl.size() > 0) {
|
Double xiaohemoValue = null; //小盒膜系数
|
Double tiaohemoValue = null; //条盒膜系数
|
Double neichenzhiValue = null;//内衬纸系数
|
for (Object[] fl : listfl) { //7-小盒纸 8-条盒纸 5小盒膜 6条盒膜9内衬纸
|
if ("5".equals(StringUtil.convertObjToString(fl[2]))) {
|
String flxsVal = StringUtil.convertObjToString(fl[0]);
|
if (!"" .equals(flxsVal)) {
|
xiaohemoValue = Double.valueOf(flxsVal);
|
}
|
} else if ("6".equals(StringUtil.convertObjToString(fl[2]))) {
|
String flxsVal = StringUtil.convertObjToString(fl[0]);
|
if (!"" .equals(flxsVal)) {
|
tiaohemoValue = Double.valueOf(flxsVal);
|
}
|
} else if ("9".equals(StringUtil.convertObjToString(fl[2]))) {
|
String flxsVal = StringUtil.convertObjToString(fl[0]);
|
if (!"" .equals(flxsVal)) {
|
neichenzhiValue = Double.valueOf(flxsVal);
|
}
|
}
|
}
|
//判断是否配置完整
|
if (xiaohemoValue == null) {
|
xiaohemoValue = 1D;
|
log.error("工单ID:" + s[0] + " 小盒膜辅料计数参数未配置");
|
}
|
if (tiaohemoValue == null) {
|
tiaohemoValue = 1D;
|
log.error("工单ID:" + s[0] + " 条盒膜辅料计数参数未配置");
|
}
|
if (neichenzhiValue == null) {
|
neichenzhiValue = 1D;
|
log.error("工单ID:" + s[0] + " 内衬纸辅料计数参数未配置");
|
}
|
map.put("xhm", xiaohemoValue.toString());
|
map.put("thm", tiaohemoValue.toString());
|
map.put("ncz", neichenzhiValue.toString());
|
}
|
}
|
RedisUtil.setMap(s[9]+"CC",map);
|
}
|
}
|
}
|
}
|
|
}
|
