| | |
| | | //YieldRegisterItem 产量登记详情表 |
| | | YieldRegisterItem struct { |
| | | gorm.Model |
| | | YieldRegisterId uint `json:"yieldRegisterId" gorm:"type:int(11);comment:产量登记表id"` |
| | | YieldRegisterId uint `json:"yieldRegisterId" gorm:"type:int(11);not null;comment:产量登记表id"` |
| | | CarNumber int `json:"carNumber" gorm:"type:int(11);comment:车号"` |
| | | OneYield decimal.Decimal `json:"oneYield" gorm:"type:decimal(12,2);comment:台产量"` |
| | | PeopleYield decimal.Decimal `json:"peopleYield" gorm:"type:decimal(12,2);comment:个人产量"` |
| | |
| | | } |
| | | YieldRegisterItemSearch struct { |
| | | YieldRegisterItem |
| | | Orm *gorm.DB |
| | | YieldRegisterIds []uint |
| | | CarNumbers []int |
| | | Orm *gorm.DB |
| | | } |
| | | ) |
| | | |
| | | func (slf YieldRegisterItem) TableName() string { |
| | | return "yield_register_item" |
| | | return "silk_yield_register_item" |
| | | } |
| | | |
| | | func NewYieldRegisterItemSearch() *YieldRegisterItemSearch { |
| | |
| | | return slf |
| | | } |
| | | |
| | | func (slf *YieldRegisterItemSearch) SetYieldRegisterIds(ids []uint) *YieldRegisterItemSearch { |
| | | slf.YieldRegisterIds = ids |
| | | return slf |
| | | } |
| | | func (slf *YieldRegisterItemSearch) SetCarNumbers(carNumbers []int) *YieldRegisterItemSearch { |
| | | slf.CarNumbers = carNumbers |
| | | return slf |
| | | } |
| | | |
| | | func (slf *YieldRegisterItemSearch) build() *gorm.DB { |
| | | db := slf.Orm.Table(slf.TableName()) |
| | | |
| | |
| | | db = db.Where("yield_register_id = ?", slf.YieldRegisterId) |
| | | } |
| | | |
| | | if len(slf.YieldRegisterIds) > 0 { |
| | | db = db.Where("yield_register_id in (?)", slf.YieldRegisterIds) |
| | | } |
| | | |
| | | if len(slf.CarNumbers) > 0 { |
| | | db = db.Where("car_number in (?)", slf.CarNumbers) |
| | | } |
| | | |
| | | return db |
| | | } |
| | | |