From 9e864a183115ba2420797a8bda661187b1069e00 Mon Sep 17 00:00:00 2001 From: liujiandao <274878379@qq.com> Date: 星期二, 23 四月 2024 11:46:41 +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