| | |
| | | ControlStrategy constvar.InvoicingStrategy `gorm:"type:int(11);comment:控制策略" json:"controlStrategy"` //控制策略 |
| | | BuyExplain string `gorm:"type:varchar(512);comment:采购说明" json:"buyExplain"` //采购说明 |
| | | Principal string `gorm:"type:varchar(255);comment:负责人" json:"principal"` //负责人 |
| | | Weight decimal.Decimal `gorm:"type:decimal(20,2);comment:重量" json:"weight"` //重量 |
| | | Weight decimal.Decimal `gorm:"type:decimal(20,3);comment:重量" json:"weight"` //重量 |
| | | Volume decimal.Decimal `gorm:"type:decimal(20,2);comment:体积" json:"volume"` //体积 |
| | | MakeAdvanceTime decimal.Decimal `gorm:"type:decimal(20,2);comment:制造前置时间" json:"makeAdvanceTime"` //制造前置时间(天) |
| | | OrderAdvanceTime decimal.Decimal `gorm:"type:decimal(20,2);comment:订单准备天数" json:"orderAdvanceTime"` //订单准备天数(天) |
| | |
| | | } |
| | | |
| | | func NewMaterialSearch() *MaterialSearch { |
| | | return &MaterialSearch{Orm: mysqlx.GetDB().Where("is_storage = ", 1)} //只查询有库存的 |
| | | return &MaterialSearch{Orm: mysqlx.GetDB().Where("is_storage = ?", 1)} //只查询有库存的 |
| | | } |
| | | |
| | | func (slf *MaterialSearch) SetOrm(tx *gorm.DB) *MaterialSearch { |
| | |
| | | return slf |
| | | } |
| | | |
| | | //func (slf *MaterialSearch) SetIsSale(isSale bool) *MaterialSearch { |
| | | // slf.IsSale = isSale |
| | | // return slf |
| | | //} |
| | | func (slf *MaterialSearch) SetIsSale(isSale bool) *MaterialSearch { |
| | | slf.IsSale = isSale |
| | | return slf |
| | | } |
| | | |
| | | func (slf *MaterialSearch) SetIDs(ids []string) *MaterialSearch { |
| | | slf.Ids = ids |
| | |
| | | if len(slf.Ids) > 0 { |
| | | db = db.Where("id in ?", slf.Ids) |
| | | } |
| | | //if slf.IsSale { |
| | | // db = db.Where("is_sale = ?", 1) |
| | | //} |
| | | if slf.IsSale { |
| | | db = db.Where("is_sale = ?", 1) |
| | | } |
| | | if slf.CategoryId > 0 { |
| | | db = db.Where("category_id = ?", slf.CategoryId) |
| | | } |