产品上传后将所有历史版本都状态设置为不可用0

whycxzp

2023-09-22 90b526ef4e3fd4f20546128bf058fbfb5f1051e4

产品上传后将所有历史版本都状态设置为不可用0

 src/main/java/com/whyc/service/ProductHistoryService.java

@@ -19,6 +19,7 @@
import org.springframework.transaction.annotation.Transactional;

import java.util.Date;
import java.util.LinkedList;
import java.util.List;

@Service
@@ -53,25 +54,33 @@
    public void insertAndUpdateEnabled(ProductHistory productHistory) {
        QueryWrapper<ProductHistory> query = Wrappers.query();
        query.eq("parent_code",productHistory.getParentCode())
                .eq("custom_code",productHistory.getCustomCode()).eq("enabled",1);
        ProductHistory productEnabled = mapper.selectOne(query);
                .eq("custom_code",productHistory.getCustomCode()).ne("enabled",0);
        List<ProductHistory> productNoZeroList = mapper.selectList(query);
        //添加新增日志到tb_product_lock_log表
        ProductLockLog lockLog = new ProductLockLog();
        lockLog.setParentCode(productEnabled.getParentCode());
        lockLog.setCustomCode(productEnabled.getCustomCode());
        lockLog.setVersion(productEnabled.getVersion());
        lockLog.setVersionTime(DateUtil.YYYY_MM_DD_HH_MM_SS.format(productEnabled.getVersionTime()));
        lockLog.setReason("产品bom上传,原生效版本锁定");
        lockLog.setOwner(ActionUtil.getUser().getName());
        lockLog.setCreateTime(new Date());
        //1代表日志类型为:锁定
        lockLog.setLockFlag(1);
        List<ProductLockLog> lockLogs = new LinkedList<>();
        for (ProductHistory historyNoZero : productNoZeroList) {
            ProductLockLog lockLog = new ProductLockLog();
            lockLog.setParentCode(historyNoZero.getParentCode());
            lockLog.setCustomCode(historyNoZero.getCustomCode());
            lockLog.setVersion(historyNoZero.getVersion());
            lockLog.setVersionTime(DateUtil.YYYY_MM_DD_HH_MM_SS.format(historyNoZero.getVersionTime()));
            if(historyNoZero.getEnabled() == 1) {
                lockLog.setReason("产品bom上传,原生效版本锁定");
            }else{
                lockLog.setReason("产品bom上传,原待审核版本锁定");
            }
            lockLog.setOwner(ActionUtil.getUser().getName());
            lockLog.setCreateTime(new Date());
            //1代表日志类型为:锁定
            lockLog.setLockFlag(1);

        lockLogService.insert(lockLog);
            lockLogs.add(lockLog);
        }
        lockLogService.insertBatch(lockLogs);

        UpdateWrapper<ProductHistory> update = Wrappers.update();
        update.set("enabled",0).eq("parent_code",productHistory.getParentCode())
                .eq("custom_code",productHistory.getCustomCode()).eq("enabled",1);
                .eq("custom_code",productHistory.getCustomCode()).ne("enabled",0);
        mapper.update(null,update);

        mapper.insert(productHistory);

 src/main/java/com/whyc/service/ProductLockLogService.java

@@ -19,6 +19,10 @@
        mapper.insert(lockLog);
    }

    public void insertBatch(List<ProductLockLog> lockLogs){
        mapper.insertBatchSomeColumn(lockLogs);
    }

    public List<ProductLockLog> getListByParentCodeAndCustomCode(String parentCode, String customCode) {
        QueryWrapper<ProductLockLog> query = Wrappers.query();
        query.eq("parent_code",parentCode).eq("custom_code",customCode).orderByDesc("id");