From bedfbcbe3af9635d15d0cafece60fbd311159fe5 Mon Sep 17 00:00:00 2001 From: liujiandao <274878379@qq.com> Date: 星期三, 10 四月 2024 13:51:08 +0800 Subject: [PATCH] 字段修改 --- models/workshop_manage.go | 45 +++++++++++++++++++++++++++++++++++++++++---- 1 files changed, 41 insertions(+), 4 deletions(-) diff --git a/models/workshop_manage.go b/models/workshop_manage.go index 6d920cb..623308b 100644 --- a/models/workshop_manage.go +++ b/models/workshop_manage.go @@ -13,8 +13,8 @@ gorm.Model WorkshopNumber string `json:"workshopNumber" gorm:"type:varchar(255);comment:杞﹂棿缂栧彿"` GroupNumber int `json:"groupNumber" gorm:"type:int(11);comment:缁勫埆"` - StartCarNumber int `json:"startCarNumber" gorm:"type:int(11);comment:缁勫埆"` - EndCarNumber int `json:"endCarNumber" gorm:"type:int(11);comment:缁勫埆"` + StartCarNumber int `json:"startCarNumber" gorm:"type:int(11);comment:寮�濮嬭溅鍙�"` + EndCarNumber int `json:"endCarNumber" gorm:"type:int(11);comment:缁撴潫杞﹀彿"` CarFlag constvar.CarFlag `json:"carFlag" gorm:"type:int(1);comment:鍗婅溅鏍囧織"` Notes string `json:"notes" gorm:"type:varchar(255);comment:澶囨敞"` } @@ -22,6 +22,7 @@ WorkshopManage PageNum int PageSize int + Order string Orm *gorm.DB } ) @@ -49,11 +50,34 @@ return slf } +func (slf *WorkshopManageSearch) SetWorkshopNumber(workshopNumber string) *WorkshopManageSearch { + slf.WorkshopNumber = workshopNumber + return slf +} + +func (slf *WorkshopManageSearch) SetGroupNumber(groupNumber int) *WorkshopManageSearch { + slf.GroupNumber = groupNumber + return slf +} + +func (slf *WorkshopManageSearch) SetOrder(order string) *WorkshopManageSearch { + slf.Order = order + return slf +} + func (slf *WorkshopManageSearch) build() *gorm.DB { db := slf.Orm.Table(slf.TableName()) if slf.ID > 0 { db = db.Where("id = ?", slf.ID) + } + + if slf.WorkshopNumber != "" { + db = db.Where("workshop_number = ?", slf.WorkshopNumber) + } + + if slf.GroupNumber != 0 { + db = db.Where("group_number = ?", slf.GroupNumber) } return db @@ -82,17 +106,30 @@ if slf.PageNum*slf.PageSize > 0 { db = db.Offset((slf.PageNum - 1) * slf.PageSize).Limit(slf.PageSize) } - if err := db.Find(&records).Error; err != nil { + if err := db.Order("updated_at desc").Find(&records).Error; err != nil { return records, total, fmt.Errorf("find records err: %v", err) } return records, total, nil } +func (slf *WorkshopManageSearch) FindAll() ([]*WorkshopManage, error) { + var ( + records = make([]*WorkshopManage, 0) + db = slf.build() + ) + + if err := db.Find(&records).Error; err != nil { + return records, fmt.Errorf("find records err: %v", err) + } + + return records, nil +} + func (slf *WorkshopManageSearch) Save(record *WorkshopManage) error { var db = slf.build() - if err := db.Save(record).Error; err != nil { + if err := db.Omit("CreatedAt").Save(record).Error; err != nil { return fmt.Errorf("save err: %v, record: %+v", err, record) } -- Gitblit v1.8.0