From 3ae25318873c7175aedc529f05bacde8005d8b50 Mon Sep 17 00:00:00 2001 From: liujiandao <274878379@qq.com> Date: 星期二, 23 四月 2024 17:52:30 +0800 Subject: [PATCH] 获取模版信息与考勤修改 --- models/fineness_check.go | 22 +++++++++++++++++++++- 1 files changed, 21 insertions(+), 1 deletions(-) diff --git a/models/fineness_check.go b/models/fineness_check.go index ebe9d70..278189c 100644 --- a/models/fineness_check.go +++ b/models/fineness_check.go @@ -31,11 +31,12 @@ PageSize int Orm *gorm.DB Preload bool + Keyword string } ) func (slf *FinenessCheck) TableName() string { - return "fineness_check" + return "silk_fineness_check" } func NewFinenessCheckSearch() *FinenessCheckSearch { @@ -67,6 +68,16 @@ 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()) @@ -77,6 +88,15 @@ 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") } -- Gitblit v1.8.0