| | |
| | | type ( |
| | | // ProcessModel 工艺参数 |
| | | ProcessModel struct { |
| | | gorm.Model `json:"-"` |
| | | CommonModel |
| | | Number string `gorm:"index;column:number;type:varchar(255);not null;default ''" json:"number"` //工艺模型编号 |
| | | Product string `gorm:"column:product;type:varchar(255);not null;default ''" json:"product"` //产品名称 |
| | | Procedure string `gorm:"column:procedure;type:varchar(255);not null;default ''" json:"procedure"` //工序 |
| | |
| | | Procedures []string |
| | | CurrentNumber string |
| | | Numbers []string |
| | | ProductNot string |
| | | ProcedureNot string |
| | | } |
| | | ) |
| | | |
| | |
| | | return slf |
| | | } |
| | | |
| | | func (slf *ProcessModelSearch) SetProductAndProcedureNot(product string, procedure string) *ProcessModelSearch { |
| | | slf.ProductNot, slf.ProcedureNot = product, procedure |
| | | return slf |
| | | } |
| | | |
| | | func (slf *ProcessModelSearch) SetProcedures(procedures []string) *ProcessModelSearch { |
| | | slf.Procedures = procedures |
| | | return slf |
| | |
| | | db = db.Where("`procedure` = ?", slf.Procedure) |
| | | } |
| | | |
| | | if len(slf.ProductNot) != 0 && len(slf.ProcedureNot) != 0 { |
| | | db = db.Not("product = ? and procedure = ? ", slf.ProductNot, slf.ProcedureNot) |
| | | } |
| | | |
| | | if len(slf.Procedures) != 0 { |
| | | db = db.Where("`procedure` IN (?)", slf.Procedures) |
| | | } |
| | |
| | | } |
| | | |
| | | if len(slf.Numbers) != 0 { |
| | | db = db.Where("number in ?", slf.Numbers) |
| | | db = db.Where("number in (?)", slf.Numbers) |
| | | } |
| | | |
| | | return db |