| | |
| | | // OperationDetails 操作明细表 |
| | | OperationDetails struct { |
| | | WmsModel |
| | | |
| | | Id int `json:"id" gorm:"column:id;primary_key;AUTO_INCREMENT"` |
| | | OperationId int `json:"OperationId" gorm:"type:int;not null;comment:操作记录id"` //操作id |
| | | OperationID int `json:"operationId" gorm:"type:int;not null;comment:操作记录id"` //操作id |
| | | ProductId string `json:"productId" gorm:"type:varchar(191);not null;comment:产品id"` //产品id |
| | | ProductName string `json:"productName" gorm:"type:varchar(255);not null;comment:产品名称"` //产品名称 |
| | | Quantity decimal.Decimal `json:"quantity" gorm:"type:decimal(20,2);not null;comment:数量"` //数量 |
| | | Amount decimal.Decimal `json:"amount" gorm:"type:decimal(20,2);not null;comment:数量"` //数量 |
| | | Unit string `json:"unit" gorm:"type:varchar(31);comment:单位"` |
| | | } |
| | | |
| | |
| | | return slf |
| | | } |
| | | |
| | | func (slf *OperationDetailsSearch) SetID(id uint) *OperationDetailsSearch { |
| | | slf.ID = id |
| | | func (slf *OperationDetailsSearch) SetID(ID int) *OperationDetailsSearch { |
| | | slf.Id = ID |
| | | return slf |
| | | } |
| | | |
| | |
| | | } |
| | | |
| | | func (slf *OperationDetailsSearch) SetOperationId(operationId int) *OperationDetailsSearch { |
| | | slf.OperationId = operationId |
| | | slf.OperationID = operationId |
| | | return slf |
| | | } |
| | | |
| | |
| | | db = db.Where("product_name like ?", fmt.Sprintf("%%%v%%", slf.Keyword)) |
| | | } |
| | | |
| | | if slf.OperationId != 0 { |
| | | db = db.Where("operation_id = ?", slf.OperationId) |
| | | if slf.OperationID != 0 { |
| | | db = db.Where("operation_id = ?", slf.OperationID) |
| | | } |
| | | |
| | | return db |