jiangshuai
2023-12-28 6ae9a1f35f59d13075ac931558bc38a11b7a6e54
models/material.go
@@ -67,11 +67,17 @@
      //HSCode                  string                     `gorm:"type:varchar(255);comment:HS编码" json:"HSCode"`                    //HS编码
      //OriginCountryId         int                        `gorm:"type:int(11);comment:原产地id" json:"originCountryId"`               //原产地id
      //OriginCountryName       string                     `gorm:"type:varchar(255);comment:原产地名称" json:"originCountryName"`        //原产地名称
      InStorageExplain        string        `gorm:"type:varchar(512);comment:入库说明" json:"inStorageExplain"`          //入库说明
      OutStorageExplain       string        `gorm:"type:varchar(512);comment:出库说明" json:"outStorageExplain"`         //出库说明
      InternalTransferExplain string        `gorm:"type:varchar(512);comment:内部调拨说明" json:"internalTransferExplain"` //内部调拨说明
      AttachmentList          []*Attachment `json:"attachmentList" gorm:"many2many:material_attachment"`
      AttachmentIDs           []uint        `json:"attachmentIDs" gorm:"-"`
      InStorageExplain        string          `gorm:"type:varchar(512);comment:入库说明" json:"inStorageExplain"`          //入库说明
      OutStorageExplain       string          `gorm:"type:varchar(512);comment:出库说明" json:"outStorageExplain"`         //出库说明
      InternalTransferExplain string          `gorm:"type:varchar(512);comment:内部调拨说明" json:"internalTransferExplain"` //内部调拨说明
      AttachmentList          []*Attachment   `json:"attachmentList" gorm:"many2many:material_attachment"`
      AttachmentIDs           []uint          `json:"attachmentIDs" gorm:"-"`
      PredictionAmount        decimal.Decimal `json:"predictionAmount" gorm:"-"`
      InputAmount             decimal.Decimal `json:"inputAmount" gorm:"-"`
      OutputAmount            decimal.Decimal `json:"outputAmount" gorm:"-"`
      MinInventoryRule        decimal.Decimal `json:"minInventoryRule" gorm:"-"` //最小库存
      MaxInventoryRule        decimal.Decimal `json:"maxInventoryRule" gorm:"-"` //最大库存
      ReorderRuleNum          int64           `json:"reorderRuleNum"`
   }
   MaterialSearch struct {
@@ -185,6 +191,8 @@
func (slf *MaterialSearch) build() *gorm.DB {
   var db = slf.Orm.Table(slf.TableName())
   db = db.Where("material_type != ", constvar.MaterialTypeVirtual) //虚拟物料无库存,不进行出入库
   if slf.ID != "" {
      db = db.Where("id = ?", slf.ID)
   }