历史版本可用性设定解锁逻辑修改

lxw

2023-09-21 cf1a9fd8a407dc2e26edd59f571a5370bf8fd657

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

@@ -8,6 +8,7 @@
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;
@@ -83,18 +84,28 @@
    }
    //历史版本可用性设定
    @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);
        int flag=0;
        //查出最新上传的版本
        QueryWrapper qhisWrapper=new QueryWrapper();
        qhisWrapper.eq("parent_code",parentCode);
        qhisWrapper.eq("custom_code",customCode);
        qhisWrapper.eq("enabled",-1);
        ProductHistory pHistory=mapper.selectOne(qhisWrapper);
        if(enabled==1){
            //先将所有的锁定
            wrapper.set("enabled",0);
            flag=mapper.update(null,wrapper);
            //再将选中的设为可用
            wrapper.eq("version",version);
            wrapper.set("enabled",1);
            //再将选中的设为可用(最新上传的找enabled=-1)
            if(version==-1){
                wrapper.eq("enabled",-1);
            }else{
                wrapper.eq("version",version);
                wrapper.set("enabled",1);
            }
            flag=mapper.update(null,wrapper);
            if(flag>0){
                QueryWrapper qWrapper=new QueryWrapper();
@@ -103,8 +114,6 @@
                //1.查询当前product中的信息
                Product product=productMapper.selectOne(qWrapper);
                //2.将选中的版本的历史信息查询出来
                qWrapper.eq("version",version);
                ProductHistory pHistory=mapper.selectOne(qWrapper);
                //3:prodcut中删除旧的产品信息
                UpdateWrapper deleteWrapper=new UpdateWrapper();
                deleteWrapper.eq("parent_code",parentCode);
@@ -127,10 +136,37 @@
            wrapper.eq("version",version);
            wrapper.set("enabled",0);
            flag=mapper.update(null,wrapper);
            if(flag>0){

            //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();
                qWrapper.eq("parent_code",parentCode);
                qWrapper.eq("custom_code",customCode);

                //1.查询当前product中的信息
                Product product=productMapper.selectOne(qWrapper);

@@ -147,7 +183,7 @@
                    productBomMapper.delete(bomWrapper);
                }

            }
            }*/

        }
        //锁定和解锁记录添加
@@ -156,6 +192,7 @@
            lockLog.setParentCode(parentCode);
            lockLog.setCustomCode(customCode);
            lockLog.setVersion(version);
            lockLog.setVersionTime(versionTime);
            lockLog.setReason(reason);
            lockLog.setOwner(ActionUtil.getUser().getName());
            lockLog.setCreateTime(new Date());
@@ -172,4 +209,22 @@
    public void insert(ProductHistory his) {
        mapper.insert(his);
    }

    /**
     *  获取标准产品
     * @param parentCode
     * @return
     */
    public ProductHistory getStandard(String parentCode) {
        QueryWrapper<ProductHistory> query = Wrappers.query();
        query.eq("parent_code",parentCode);
        List<ProductHistory> historyList = mapper.selectList(query);
        for (ProductHistory history : historyList) {
            String customCode = history.getCustomCode();
            if(customCode == null || customCode.trim().equals("")){ //不存在定制表单号,是标准产品
                return history;
            }
        }
        return null;
    }
}