From cc7c2094568ea8f9d1697da5ed0a2c759ca81abd Mon Sep 17 00:00:00 2001
From: yinbentan <yinbentan@live.com>
Date: 星期五, 30 八月 2024 17:18:30 +0800
Subject: [PATCH] 方法修改，修改薪资列表，添加分页查询
---
models/attendance_manage.go | 20 ++++++++++++++++++++
1 files changed, 20 insertions(+), 0 deletions(-)
diff --git a/models/attendance_manage.go b/models/attendance_manage.go
index 6663197..412bf42 100644
--- a/models/attendance_manage.go
+++ b/models/attendance_manage.go
@@ -26,6 +26,7 @@
WorkType WorkTypeManage `json:"workType" gorm:"foreignKey:WorkTypeId"`
Status constvar.AttendanceStatus `json:"status" gorm:"type:int(11);comment:鐘舵��"`
OverTimeDuration decimal.Decimal `json:"overTimeDuration" gorm:"type:decimal(20,2);comment:鍔犵彮鏃堕暱"`
+ PhoneNum string `gorm:"type:varchar(191);comment:鎵嬫満鍙�" json:"phoneNum"`
}
AttendanceManageSearch struct {
AttendanceManage
@@ -34,6 +35,8 @@
Preload bool
Ids []uint
Month string
+ Keyword string
+ Order string
Orm *gorm.DB
}
)
@@ -81,6 +84,16 @@
return slf
}
+func (slf *AttendanceManageSearch) SetKeyword(keyword string) *AttendanceManageSearch {
+ slf.Keyword = keyword
+ return slf
+}
+
+func (slf *AttendanceManageSearch) SetOrder(order string) *AttendanceManageSearch {
+ slf.Order = order
+ return slf
+}
+
func (slf *AttendanceManageSearch) build() *gorm.DB {
var db = slf.Orm.Table(slf.TableName())
@@ -104,6 +117,13 @@
db = db.Where("worker_id = ?", slf.WorkerId)
}
+ if slf.Keyword != "" {
+ db = db.Where("worker_name like ? or worker_id like ?", "%"+slf.Keyword+"%", "%"+slf.Keyword+"%")
+ }
+ if slf.Order != "" {
+ db = db.Order(slf.Order)
+ }
+
return db
}
--
Gitblit v1.8.0