zhangqian
2024-04-29 440392a932fb2dc8118caf1f4996e7d8b72574a1
models/fineness.go
@@ -11,10 +11,11 @@
   // FinenessRegister 纤度登记
   FinenessRegister struct {
      gorm.Model
      Number          string          `gorm:"type:varchar(255);not null;comment:编号" json:"number"`             //编号
      FinenessCheckID uint            `gorm:"not null;comment:纤度检验表ID" json:"finenessCheckID"`                 //纤度检验表ID
      FinishDate      string          `gorm:"type:varchar(255);not null;comment:落丝时间" json:"finishDate"`       //落丝时间
      Workshop        string          `gorm:"type:varchar(255);not null;comment:车间" json:"name"`               //车间
      Number          string          `gorm:"type:varchar(255);not null;comment:编号" json:"number"`       //编号
      FinenessCheckID uint            `gorm:"not null;comment:纤度检验表ID" json:"finenessCheckID"`           //纤度检验表ID
      FinishDate      string          `gorm:"type:varchar(255);not null;comment:落丝时间" json:"finishDate"` //落丝时间
      WorkshopNumber  string          `json:"workshopNumber" gorm:"type:varchar(255);comment:车间编号"`
      WorkshopName    string          `json:"workshopName" gorm:"type:varchar(255);comment:车间名称"`
      WorkshopGroup   int             `gorm:"type:int(11);not null;default:0;comment:车组" json:"workshopGroup"` //车组
      Market          string          `gorm:"type:varchar(255);not null;comment:庄口" json:"market"`             //庄口
      Spec            string          `gorm:"type:varchar(255);not null;comment:规格" json:"spec"`               //规格
@@ -37,7 +38,7 @@
)
func (slf *FinenessRegister) TableName() string {
   return "fineness_register"
   return "silk_fineness_register"
}
func NewFinenessRegisterSearch() *FinenessRegisterSearch {
@@ -79,6 +80,21 @@
   return slf
}
func (slf *FinenessRegisterSearch) SetWorkshopName(workshop string) *FinenessRegisterSearch {
   slf.WorkshopName = workshop
   return slf
}
func (slf *FinenessRegisterSearch) SetMarket(market string) *FinenessRegisterSearch {
   slf.Market = market
   return slf
}
func (slf *FinenessRegisterSearch) SetWorkshopGroup(group int) *FinenessRegisterSearch {
   slf.WorkshopGroup = group
   return slf
}
func (slf *FinenessRegisterSearch) build() *gorm.DB {
   var db = slf.Orm.Table(slf.TableName())
@@ -102,6 +118,18 @@
      db = db.Where("number like ?", fmt.Sprintf("%%%s%%", slf.Keyword))
   }
   if slf.WorkshopName != "" {
      db = db.Where("workshop_name = ?", slf.WorkshopName)
   }
   if slf.Market != "" {
      db = db.Where("market = ?", slf.Market)
   }
   if slf.WorkshopGroup > 0 {
      db = db.Where("workshop_group = ?", slf.WorkshopGroup)
   }
   return db
}