产品添加字段

liujiandao

2024-04-16 942642be1995671d65b013e559376ac0bde4e8b9

产品添加字段

 controllers/location_product_amount.go

@@ -167,6 +167,7 @@
        Comment:           "库存盘点",
        BaseOperationType: constvar.BaseOperationTypeAdjust,
        Details:           []*models.OperationDetails{detail},
        LocationID:        location.Id,
    }

    if err := models.WithTransaction(func(tx *gorm.DB) error {

 models/material.go

@@ -78,6 +78,12 @@
        IsStorage               int           `gorm:"type:tinyint(1);default:1;comment:是否存库(1是2否)" json:"isStorage"`   //无库存的在wms以及srm中需要过滤掉
        IsVirtual               int           `json:"isVirtual" gorm:"type:tinyint(1);default:2;comment:是否虚拟物料(1是2否)"` //虚拟物料在MRP计算时跳过该层级直接领用下级物料，虚拟物料不生成工单
        ReorderRuleNum          int64         `json:"reorderRuleNum"`
        MoreUnit                bool            `json:"moreUnit" gorm:"type:tinyint(1);default:false;comment:启动多单位"`
        MoreUnitValue           string          `json:"moreUnitValue" gorm:"type:varchar(255);comment:多单位值"`
        GrossWeight             decimal.Decimal `json:"grossWeight" gorm:"type:decimal(20,3);comment:毛重"`
        NetWeight               decimal.Decimal `json:"netWeight" gorm:"type:decimal(20,3);comment:净重"`
        GrossUnit               string          `json:"grossUnit" gorm:"type:varchar(255);comment:毛重单位"`
        NetUnit                 string          `json:"netUnit" gorm:"type:varchar(255);comment:净重单位"`

        //以下为不存库的字段
        AttachmentIDs    []uint          `json:"attachmentIDs" gorm:"-"`

 models/operation_details.go

@@ -23,6 +23,8 @@
        FromLocation   Location `json:"fromLocation"     gorm:"foreignKey:FromLocationID;references:Id"` //源位置
        ToLocationID   int      `json:"toLocationId"    gorm:"type:int;not null;comment:目标位置id"`         //目标位置id
        ToLocation     Location `json:"toLocation"      gorm:"foreignKey:ToLocationID;references:Id"`    //目标位置
        TotalGrossWeight decimal.Decimal `json:"totalGrossWeight" gorm:"type:decimal(20,3);comment:总毛重"`
        TotalNetWeight   decimal.Decimal `json:"totalNetWeight" gorm:"type:decimal(20,3);comment:总净重"`
    }

    OperationDetailsSearch struct {

 request/operation.go

@@ -47,6 +47,8 @@
    //Product models.Material `json:"product" gorm:"foreignKey:ProductId;references:ID"`
    FromLocationId int `json:"fromLocationId"   gorm:"type:int;not null;comment:源位置id"` //源位置id
    ToLocationId   int `json:"toLocationId"    gorm:"type:int;not null;comment:目标位置id"` //目标位置id
    TotalGrossWeight decimal.Decimal `json:"totalGrossWeight" gorm:"type:decimal(20,3);comment:总毛重"`  //总毛重
    TotalNetWeight   decimal.Decimal `json:"totalNetWeight" gorm:"type:decimal(20,3);comment:总净重"`    //总净重
}

type OperationList struct {