| | |
| | | RawSilkPriceStandard struct { |
| | | gorm.Model |
| | | MarketId uint `json:"marketId" gorm:"type:int(11);comment:庄口id"` |
| | | MarketNumber string `json:"marketNumber" gorm:"type:varchar(255);comment:庄口编码"` |
| | | MarketName string `json:"marketName" gorm:"type:varchar(255);comment:庄口名称"` |
| | | RawSilkGrade string `json:"rawSilkGrade" gorm:"type:varchar(255);comment:生丝等级"` |
| | | PayStandard decimal.Decimal `json:"payStandard" gorm:"type:decimal(20,3);comment:薪酬标准"` |
| | |
| | | return slf |
| | | } |
| | | |
| | | func (slf *RawSilkPriceStandardSearch) SetMarketNumber(marketNumber string) *RawSilkPriceStandardSearch { |
| | | slf.MarketNumber = marketNumber |
| | | return slf |
| | | } |
| | | |
| | | func (slf *RawSilkPriceStandardSearch) SetMarketNames(names []string) *RawSilkPriceStandardSearch { |
| | | slf.MarketNames = names |
| | | return slf |
| | |
| | | |
| | | if slf.ID > 0 { |
| | | db = db.Where("id = ?", slf.ID) |
| | | } |
| | | |
| | | if len(slf.MarketNumber) > 0 { |
| | | db = db.Where("market_number = ", slf.MarketNumber) |
| | | } |
| | | |
| | | if len(slf.MarketNames) > 0 { |
| | |
| | | return records, total, nil |
| | | } |
| | | |
| | | func (slf *RawSilkPriceStandardSearch) FindNotTotal() ([]*RawSilkPriceStandard, error) { |
| | | var ( |
| | | records = make([]*RawSilkPriceStandard, 0) |
| | | db = slf.build() |
| | | ) |
| | | |
| | | if slf.PageNum*slf.PageSize > 0 { |
| | | db = db.Offset((slf.PageNum - 1) * slf.PageSize).Limit(slf.PageSize) |
| | | } |
| | | if err := db.Order("updated_at desc").Find(&records).Error; err != nil { |
| | | return records, fmt.Errorf("find records err: %v", err) |
| | | } |
| | | |
| | | return records, nil |
| | | } |
| | | |
| | | func (slf *RawSilkPriceStandardSearch) Save(record *RawSilkPriceStandard) error { |
| | | var db = slf.build() |
| | | |