| | |
| | | ProcessModelSearch struct { |
| | | ProcessModel |
| | | Order string |
| | | PageNum int |
| | | PageSize int |
| | | Limit int |
| | | Offset int |
| | | Orm *gorm.DB |
| | | Procedures []string |
| | | CurrentNumber string |
| | |
| | | return slf |
| | | } |
| | | |
| | | func (slf *ProcessModelSearch) SetPage(page, size int) *ProcessModelSearch { |
| | | slf.PageNum, slf.PageSize = page, size |
| | | func (slf *ProcessModelSearch) SetPage(offset, limit int) *ProcessModelSearch { |
| | | slf.Offset, slf.Limit = offset, limit |
| | | return slf |
| | | } |
| | | |
| | |
| | | if err := db.Count(&total).Error; err != nil { |
| | | return records, total, fmt.Errorf("find count err: %v", err) |
| | | } |
| | | if slf.PageNum*slf.PageSize > 0 { |
| | | db = db.Offset((slf.PageNum - 1) * slf.PageSize).Limit(slf.PageSize) |
| | | if slf.Offset > 0 || slf.Limit > 0 { |
| | | db = db.Offset(slf.Offset).Limit(slf.Limit) |
| | | } |
| | | if err := db.Find(&records).Error; err != nil { |
| | | return records, total, fmt.Errorf("find records err: %v", err) |
| | |
| | | db = slf.build() |
| | | ) |
| | | |
| | | if slf.PageNum*slf.PageSize > 0 { |
| | | db = db.Offset((slf.PageNum - 1) * slf.PageSize).Limit(slf.PageSize) |
| | | if slf.Offset > 0 || slf.Limit > 0 { |
| | | db = db.Offset(slf.Offset).Limit(slf.Limit) |
| | | } |
| | | if err := db.Find(&records).Error; err != nil { |
| | | return records, fmt.Errorf("find records err: %v", err) |
| | |
| | | if err := db.Count(&total).Error; err != nil { |
| | | return records, total, fmt.Errorf("find by query count err: %v", err) |
| | | } |
| | | if slf.PageNum*slf.PageSize > 0 { |
| | | db = db.Offset((slf.PageNum - 1) * slf.PageSize).Limit(slf.PageSize) |
| | | if slf.Offset > 0 || slf.Limit > 0 { |
| | | db = db.Offset(slf.Offset).Limit(slf.Limit) |
| | | } |
| | | if err := db.Find(&records).Error; err != nil { |
| | | return records, total, fmt.Errorf("find by query records err: %v, query: %s, args: %+v", err, query, args) |
| | |
| | | db = slf.Orm.Table(slf.TableName()).Where(query, args...) |
| | | ) |
| | | |
| | | if slf.PageNum*slf.PageSize > 0 { |
| | | db = db.Offset((slf.PageNum - 1) * slf.PageSize).Limit(slf.PageSize) |
| | | if slf.Offset > 0 || slf.Limit > 0 { |
| | | db = db.Offset(slf.Offset).Limit(slf.Limit) |
| | | } |
| | | if err := db.Find(&records).Error; err != nil { |
| | | return records, fmt.Errorf("find by query records err: %v, query: %s, args: %+v", err, query, args) |