平仓日志功能(未完成)

luxiaotao1123

2021-06-21 7077d2aca171525b6f021cd3307788ac7c55dd14

平仓日志功能(未完成)

 src/main/java/com/zy/asrs/entity/LocNoramlLog.java

New file
@@ -0,0 +1,68 @@
package com.zy.asrs.entity;

import com.baomidou.mybatisplus.annotations.TableField;
import com.baomidou.mybatisplus.annotations.TableId;
import com.baomidou.mybatisplus.annotations.TableName;
import com.baomidou.mybatisplus.enums.IdType;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;

import java.math.BigDecimal;
import java.util.Date;

/**
 * Created by vincent on 2021/6/21
 */
@Data
@TableName("asr_loc_normal_log")
public class LocNoramlLog {
    @ApiModelProperty(value= "物料")
    private String matnr;

    @ApiModelProperty(value= "物料描述")
    private String maktx;

    @ApiModelProperty(value= "规格")
    private String lgnum;

    @ApiModelProperty(value= "物料类别")
    private String type;

    @ApiModelProperty(value= "生产单号")
    private String mnemonic;

    @ApiModelProperty(value= "通知单号")
    private String supplier;

    @ApiModelProperty(value= "仓库")
    private String warehouse;

    @TableField(exist = false)
    private String warehouseName;

    @ApiModelProperty(value= "数量")
    private Double anfme;

    @ApiModelProperty(value= "备注")
    private String memo;

    @ApiModelProperty(value= "创建时间")
    @TableField("create_time")
    private Date createTime;

    @ApiModelProperty(value= "修改时间")
    @TableField("update_time")
    private Date update_time;

    @ApiModelProperty(value= "创建者")
    @TableField("create_user")
    private Long createUser;

    @ApiModelProperty(value= "修改者")
    @TableField("update_user")
    private Long updateUser;

    @ApiModelProperty(value= "出入库类型(1入库,2出库, 3删除, 4更新)")
    @TableField("io_type")
    private Integer ioType;
}

 src/main/java/com/zy/asrs/service/impl/LocNormalServiceImpl.java

@@ -6,6 +6,7 @@
import com.baomidou.mybatisplus.service.impl.ServiceImpl;
import com.core.common.Cools;
import com.core.exception.CoolException;
import com.zy.asrs.entity.LocNoramlLog;
import com.zy.asrs.entity.LocNormal;
import com.zy.asrs.entity.WaitPakin;
import com.zy.asrs.entity.WaitPakinLog;
@@ -15,6 +16,7 @@
import com.zy.asrs.service.LocNormalService;
import com.zy.asrs.service.WaitPakinLogService;
import com.zy.asrs.service.WaitPakinService;
import com.zy.asrs.utils.VersionUtils;
import com.zy.common.service.erp.ErpService;
import com.zy.common.service.erp.ErpSqlServer;
import com.zy.common.service.erp.entity.CPICMO;
@@ -245,6 +247,14 @@
                            // cust_wait_pakin转cust_wait_pakin_log，并更新数量
                            custWaitPakinToLog(list.get(i), updateAnfme);
                        }
                        // 生成平仓出入库记录
                        LocNoramlLog log = new LocNoramlLog();
                        VersionUtils.setLocNormalLog(log, list.get(i));
                        log.setAnfme(updateAnfme);
                        log.setIoType(1);
                        log.setCreateTime(new Date());
                        log.setCreateUser(list.get(i).getAppeUser());

                    } else {
                        // erp更新
                        updateCPICMO(list.get(i));
@@ -254,6 +264,14 @@
                            // cust_wait_pakin转cust_wait_pakin_log，并更新数量
                            custWaitPakinToLog(list.get(i), list.get(i).getAnfme().doubleValue());
                        }
                        // 生成平仓出入库记录
                        LocNoramlLog log = new LocNoramlLog();
                        VersionUtils.setLocNormalLog(log, list.get(i));
                        log.setAnfme(list.get(i).getAnfme().doubleValue());
                        log.setIoType(1);
                        log.setCreateTime(new Date());
                        log.setCreateUser(list.get(i).getAppeUser());

                    }
                } else {
                    throw new CoolException("通知单号不可为空");

 src/main/java/com/zy/asrs/utils/VersionUtils.java

@@ -6,6 +6,8 @@
import com.zy.common.service.erp.entity.M_item;
import com.zy.common.utils.excel.matcode.MatCodeExcel;

import java.util.List;

/**
 * Created by vincent on 2020/7/14
 */
@@ -83,6 +85,17 @@
        matCode.setStr2(item.getMtypename()); // 规格型号
    }

    public static void setLocNormalLog(LocNoramlLog log, LocNormal item) {
        log.setMatnr(item.getMatnr());
        log.setMaktx(item.getMaktx());
        log.setLgnum(item.getLgnum());
        log.setType(item.getType());
        log.setMnemonic(item.getMnemonic());
        log.setSupplier(item.getSupplier());
        log.setWarehouse(item.getWarehouse());
        log.setMemo(item.getMemo());
    }

    // excel ----------------------------------------------------------------------

    public static MatCodeExcel getExcel(MatCode matCode) {

 version/v1.0.1/tableChange

New file
@@ -0,0 +1,39 @@
USE [xtyasrs]
GO

/****** Object:  Table [dbo].[asr_loc_normal_log]    Script Date: 2021/6/21 16:27:31 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[asr_loc_normal_log](
    [create_time] [datetime] NULL,
    [update_time] [datetime] NULL,
    [create_user] [bigint] NULL,
    [update_user] [bigint] NULL,
    [warehouse] [varchar](255) NULL,
    [matnr] [varchar](50) NULL,
    [maktx] [varchar](max) NULL,
    [anfme] [decimal](24, 9) NULL,
    [lgnum] [varchar](255) NULL,
    [type] [varchar](50) NULL,
    [mnemonic] [varchar](255) NULL,
    [supplier] [varchar](255) NULL,
    [memo] [varchar](600) NULL,
    [io_type] [int] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'出入库类型(1入库,2出库, 3删除)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'asr_loc_normal_log', @level2type=N'COLUMN',@level2name=N'io_type'
GO