fox

zhangqian

2024-05-07 7d06c6472f1acea6b2e49e7b8837bf555e94e219

 models/yield_register.go

@@ -14,7 +14,7 @@
      Number                  string                 `json:"number" gorm:"type:varchar(255);not null;comment:编号"`
      CreateTime              string                 `json:"createTime" gorm:"type:varchar(255);comment:创建时间"`
      MarketId                uint                   `json:"marketId" gorm:"type:int(11);comment:庄口id"`
      WorkshopId              uint                   `json:"workshopId" gorm:"type:int(11);comment:车间id"`
      WorkshopNumber          string                 `json:"workshopNumber" gorm:"type:varchar(255);comment:车间编码"`
      GroupNumber             int                    `json:"groupNumber" gorm:"type:int(11);comment:组别"`
      Spec                    string                 `json:"spec" gorm:"type:varchar(255);comment:规格"`
      JieZhuang               string                 `json:"jieZhuang" gorm:"type:varchar(255);comment:是否结庄"`
@@ -30,6 +30,9 @@
      FallingSilkBucketOne    decimal.Decimal        `json:"fallingSilkBucketOne" gorm:"type:decimal(12,2);comment:落丝桶数1"`
      FallingSilkBucketTwo    decimal.Decimal        `json:"fallingSilkBucketTwo" gorm:"type:decimal(12,2);comment:落丝桶数2"`
      FallingSilkBucketThree  decimal.Decimal        `json:"fallingSilkBucketThree" gorm:"type:decimal(12,2);comment:落丝桶数3"`
      SelectOne               bool                   `json:"selectOne" gorm:"type:int(1);comment:落丝桶数1选中"`
      SelectTwo               bool                   `json:"selectTwo" gorm:"type:int(1);comment:落丝桶数2选中"`
      SelectThree             bool                   `json:"selectThree" gorm:"type:int(1);comment:落丝桶数3选中"`
      TheorySilkAmount        decimal.Decimal        `json:"theorySilkAmount" gorm:"type:decimal(12,2);comment:理论丝量"`
      HourYield               decimal.Decimal        `json:"hourYield" gorm:"type:decimal(12,2);comment:台时产量"`
      OneBack                 string                 `json:"oneBack" gorm:"type:varchar(255);comment:第一回"`
@@ -53,7 +56,7 @@
)

func (slf YieldRegister) TableName() string {
   return "yield_register"
   return "silk_yield_register"
}

func NewYieldRegisterSearch() *YieldRegisterSearch {
@@ -90,8 +93,8 @@
   return slf
}

func (slf *YieldRegisterSearch) SetWorkshopId(workshopId uint) *YieldRegisterSearch {
   slf.WorkshopId = workshopId
func (slf *YieldRegisterSearch) SetWorkshopNumber(workshopNumber string) *YieldRegisterSearch {
   slf.WorkshopNumber = workshopNumber
   return slf
}

@@ -120,8 +123,8 @@
      db = db.Where("create_time = ?", slf.CreateTime)
   }

   if slf.WorkshopId > 0 {
      db = db.Where("workshop_id = ?", slf.WorkshopId)
   if slf.WorkshopNumber != "" {
      db = db.Where("workshop_number = ?", slf.WorkshopNumber)
   }

   if slf.MarketId > 0 {
@@ -213,3 +216,15 @@

   return nil
}

func (slf *YieldRegisterSearch) Count() (int64, error) {
   var (
      total int64
      db    = slf.build()
   )

   if err := db.Count(&total).Error; err != nil {
      return total, fmt.Errorf("find count err: %v", err)
   }
   return total, nil
}