| | |
| | | WmsModel |
| | | Id int `json:"id" gorm:"column:id;primary_key;AUTO_INCREMENT"` |
| | | Number string `json:"number" gorm:"type:varchar(255)"` //单号 |
| | | SourceNumber string `json:"sourceNumber" gorm:"type:varchar(255)"` //源单号 |
| | | SourceNumber string `json:"sourceNumber" gorm:"index;type:varchar(255)"` //源单号 |
| | | OperationTypeId int `json:"operationTypeId" gorm:"type:int;not null;comment:作业类型id"` //作业类型id |
| | | OperationTypeName string `json:"operationTypeName" gorm:"type:varchar(127);comment:作业类型名称"` //作业类型名称 |
| | | Status constvar.OperationStatus `json:"status" gorm:"type:int(11);not null;comment:状态"` //状态 |
| | |
| | | |
| | | OperationSearch struct { |
| | | Operation |
| | | Order string |
| | | PageNum int |
| | | PageSize int |
| | | Keyword string |
| | | Orm *gorm.DB |
| | | Preload bool |
| | | Disuse bool |
| | | Ids []int |
| | | Numbers []string |
| | | Order string |
| | | PageNum int |
| | | PageSize int |
| | | Keyword string |
| | | Orm *gorm.DB |
| | | Preload bool |
| | | Disuse bool |
| | | Ids []int |
| | | SourceNumbers []string |
| | | SalesDetailsNumbers []string |
| | | } |
| | | ) |
| | | |
| | |
| | | return slf |
| | | } |
| | | |
| | | func (slf *OperationSearch) SetSourceNumbers(numbers []string) *OperationSearch { |
| | | slf.SourceNumbers = numbers |
| | | return slf |
| | | } |
| | | |
| | | func (slf *OperationSearch) SetDisuse(disuse bool) *OperationSearch { |
| | | slf.Disuse = disuse |
| | | return slf |
| | |
| | | return slf |
| | | } |
| | | |
| | | func (slf *OperationSearch) SetSalesDetailsNumbers(salesDetailsNumbers []string) *OperationSearch { |
| | | slf.SalesDetailsNumbers = salesDetailsNumbers |
| | | return slf |
| | | } |
| | | |
| | | func (slf *OperationSearch) SetOperationSource(operationSource constvar.OperationSource) *OperationSearch { |
| | | slf.OperationSource = operationSource |
| | | return slf |
| | | } |
| | | |
| | | func (slf *OperationSearch) build() *gorm.DB { |
| | | var db = slf.Orm.Model(&Operation{}) |
| | | |
| | |
| | | |
| | | if slf.SourceNumber != "" { |
| | | db = db.Where("source_number = ?", slf.SourceNumber) |
| | | } |
| | | |
| | | if len(slf.SourceNumbers) > 0 { |
| | | db = db.Where("source_number in (?)", slf.SourceNumbers) |
| | | } |
| | | |
| | | if slf.Number != "" { |
| | |
| | | db = db.Where("sales_details_number = ?", slf.SalesDetailsNumber) |
| | | } |
| | | |
| | | if len(slf.SalesDetailsNumbers) > 0 { |
| | | db = db.Where("sales_details_number in (?)", slf.SalesDetailsNumbers) |
| | | } |
| | | |
| | | if slf.OperationSource != 0 { |
| | | db = db.Where("operation_source = ?", slf.OperationSource) |
| | | } |
| | | |
| | | return db |
| | | } |
| | | |