| | |
| | | import com.whyc.mapper.ProductBomMapper; |
| | | import com.whyc.mapper.ProductHistoryMapper; |
| | | import com.whyc.mapper.ProductMapper; |
| | | import com.whyc.pojo.Material; |
| | | import com.whyc.pojo.Product; |
| | | import com.whyc.pojo.ProductHistory; |
| | | import com.whyc.pojo.ProductLockLog; |
| | |
| | | } |
| | | //历史版本可用性设定 |
| | | @Transactional |
| | | public Response setpHistoryEnable(String parentCode, String customCode, int version, int enabled, String reason) { |
| | | public Response setpHistoryEnable(String parentCode, String customCode, int version, int enabled, String reason, String versionTime) { |
| | | UpdateWrapper wrapper=new UpdateWrapper(); |
| | | wrapper.eq("parent_code",parentCode); |
| | | wrapper.eq("custom_code",customCode); |
| | |
| | | }else{ |
| | | wrapper.eq("version",version); |
| | | wrapper.set("enabled",0); |
| | | //设为不可用版本为-1 |
| | | wrapper.eq("version",-1); |
| | | flag=mapper.update(null,wrapper); |
| | | |
| | | //3:prodcut中产品版本设置为-1 |
| | | UpdateWrapper uWrapper=new UpdateWrapper(); |
| | | uWrapper.eq("parent_code",parentCode); |
| | | uWrapper.eq("custom_code",customCode); |
| | | //设为不可用版本为-1 |
| | | uWrapper.set("version",-1); |
| | | productMapper.update(null,uWrapper); |
| | | |
| | | //4.查询产品是否存在物料时钣金件的产品 |
| | | Material material_0120=productMapper.selectMaterial_0120(parentCode,customCode); |
| | | //如果存在则锁定 |
| | | if(material_0120!=null){ |
| | | //先锁定历史 |
| | | UpdateWrapper wrapperHistory_0120=new UpdateWrapper(); |
| | | wrapperHistory_0120.eq("parent_code",material_0120.getSubCode()); |
| | | wrapperHistory_0120.set("enabled",0); |
| | | mapper.update(null,wrapperHistory_0120); |
| | | //再设置实时为-1 |
| | | UpdateWrapper wrapper_0120=new UpdateWrapper(); |
| | | wrapper_0120.eq("parent_code",material_0120.getSubCode()); |
| | | //设为不可用版本为-1 |
| | | wrapper_0120.set("version",-1); |
| | | productMapper.update(null,wrapper_0120); |
| | | } |
| | | /*if(flag>0){ |
| | | // |
| | | QueryWrapper qWrapper=new QueryWrapper(); |
| | |
| | | lockLog.setParentCode(parentCode); |
| | | lockLog.setCustomCode(customCode); |
| | | lockLog.setVersion(version); |
| | | lockLog.setVersionTime(versionTime); |
| | | lockLog.setReason(reason); |
| | | lockLog.setOwner(ActionUtil.getUser().getName()); |
| | | lockLog.setCreateTime(new Date()); |