考勤统计与车间修改

liujiandao

2024-04-23 9e864a183115ba2420797a8bda661187b1069e00

 models/fineness_check.go

@@ -18,9 +18,9 @@
      Deviation                decimal.Decimal  `gorm:"type:decimal(12,2);not null;comment:偏差" json:"deviation"`                    //偏差
      TotalDeviation           decimal.Decimal  `gorm:"type:decimal(12,2);not null;comment:总差" json:"totalDeviation"`               //总差
      FinenessGrade            string           `gorm:"type:varchar(255);not null;comment:纤度等级" json:"finenessGrade"`               //纤度等级
      Cleanliness              string           `gorm:"type:varchar(255);not null;comment:清洁度" json:"cleanliness"`                  //清洁度
      Purity                   string           `gorm:"type:varchar(255);not null;comment:洁净度" json:"purity"`                       //洁净度
      TwiceChange              string           `gorm:"type:varchar(255);not null;comment:二度变化" json:"twiceChange"`                 //二度变化
      Cleanliness              decimal.Decimal  `gorm:"type:varchar(255);not null;comment:清洁度" json:"cleanliness"`                  //清洁度
      Purity                   decimal.Decimal  `gorm:"type:varchar(255);not null;comment:洁净度" json:"purity"`                       //洁净度
      TwiceChange              decimal.Decimal  `gorm:"type:varchar(255);not null;comment:二度变化" json:"twiceChange"`                 //二度变化
      MarketProcessOrderNumber string           `gorm:"type:varchar(255);not null;comment:庄口工艺单编号" json:"marketProcessOrderNumber"` //庄口工艺单编号
      Inspector                string           `gorm:"type:varchar(255);not null;comment:检验员" json:"inspector"`                    //检验员
   }
@@ -31,11 +31,12 @@
      PageSize int
      Orm      *gorm.DB
      Preload  bool
      Keyword  string
   }
)

func (slf *FinenessCheck) TableName() string {
   return "fineness_check"
   return "silk_fineness_check"
}

func NewFinenessCheckSearch() *FinenessCheckSearch {
@@ -67,6 +68,16 @@
   return slf
}

func (slf *FinenessCheckSearch) SetFinenessRegisterID(id uint) *FinenessCheckSearch {
   slf.FinenessRegisterID = id
   return slf
}

func (slf *FinenessCheckSearch) SetKeyword(keyword string) *FinenessCheckSearch {
   slf.Keyword = keyword
   return slf
}

func (slf *FinenessCheckSearch) build() *gorm.DB {
   var db = slf.Orm.Table(slf.TableName())

@@ -77,6 +88,15 @@
   if slf.Order != "" {
      db = db.Order(slf.Order)
   }

   if slf.Keyword != "" {
      db = db.Where("number like ?", fmt.Sprintf("%%%s%%", slf.Keyword))
   }

   if slf.FinenessRegisterID != 0 {
      db = db.Where("fineness_register_id = ?", slf.FinenessRegisterID)
   }

   if slf.Preload {
      db = db.Model(&FinenessCheck{}).Preload("FinenessRegister")
   }