更新excel日期格式判断

whycxzp

2022-09-15 788f57c0f36ce4e625b068b5891c35ed8f8da2c7

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

@@ -9,14 +9,14 @@
import com.whyc.mapper.ProductHistoryMapper;
import com.whyc.mapper.ProductMapper;
import com.whyc.pojo.Product;
import com.whyc.pojo.ProductBom;
import com.whyc.pojo.ProductBomHistory;
import com.whyc.pojo.ProductHistory;
import org.apache.poi.hssf.record.ProtectionRev4Record;
import com.whyc.pojo.ProductLockLog;
import com.whyc.util.ActionUtil;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

import java.awt.print.PrinterJob;
import java.util.Date;
import java.util.List;

@Service
@@ -32,6 +32,9 @@

    @Autowired(required = false)
    private ProductBomHistoryMapper productBomHistoryMapper;

    @Autowired
    private ProductLockLogService lockLogService;

    //产品详情查看版本信息
    public Response getProductVersion(String parentCode,String customCode) {
@@ -79,7 +82,8 @@
        return mapper.selectOne(query);
    }
    //历史版本可用性设定
    public Response setpHistoryEnable(String parentCode, String customCode, int version, int enabled) {
    @Transactional
    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);
@@ -116,17 +120,27 @@
                    // 5.在product中插入设定可用的pHistory
                    productMapper.insertPselectPH(pHistory.getId());
                    //6.在productBom中插入pHsitoryBom查询出的数据
                    productBomMapper.insertBomSelectBomH(pHistory.getId());
                    productBomMapper.insertBomSelectBomH(pHistory.getId(),pHistory.getSubVersionMax());
                }
            }
        }else{
            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);
            /*if(flag>0){
                //
                QueryWrapper qWrapper=new QueryWrapper();
                qWrapper.eq("parent_code",parentCode);
                qWrapper.eq("custom_code",customCode);

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

@@ -143,9 +157,26 @@
                    productBomMapper.delete(bomWrapper);
                }

            }
            }*/

        }
        //锁定和解锁记录添加
        if(flag>0){ //操作成功
            ProductLockLog lockLog = new ProductLockLog();
            lockLog.setParentCode(parentCode);
            lockLog.setCustomCode(customCode);
            lockLog.setVersion(version);
            lockLog.setVersionTime(versionTime);
            lockLog.setReason(reason);
            lockLog.setOwner(ActionUtil.getUser().getName());
            lockLog.setCreateTime(new Date());
            if(enabled==0){ //锁定
                lockLog.setLockFlag(1);
            }else{ //解锁
                lockLog.setLockFlag(0);
            }
            lockLogService.insert(lockLog);
        }
        return new Response().set(1,flag>0,"历史版本可用性设定");
    }