| | |
| | | PageSize int |
| | | Orm *gorm.DB |
| | | Preload bool |
| | | Keyword string |
| | | } |
| | | ) |
| | | |
| | | func (slf *FinenessCheck) TableName() string { |
| | | return "fineness_check" |
| | | return "silk_fineness_check" |
| | | } |
| | | |
| | | func NewFinenessCheckSearch() *FinenessCheckSearch { |
| | |
| | | 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()) |
| | | |
| | |
| | | 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") |
| | | } |