From d8ac88cfb72e3aac3a89c3cfe77774be3024a24c Mon Sep 17 00:00:00 2001
From: zhangqian <zhangqian@123.com>
Date: 星期五, 11 八月 2023 17:54:43 +0800
Subject: [PATCH] update
---
model/orderManage.go | 195 +++++++++++++++++++++++++++++-------------------
1 files changed, 116 insertions(+), 79 deletions(-)
diff --git a/model/orderManage.go b/model/orderManage.go
index 8dde20b..228118c 100644
--- a/model/orderManage.go
+++ b/model/orderManage.go
@@ -1,79 +1,116 @@
-package model
-
-import (
- "aps_crm/pkg/mysqlx"
- "gorm.io/gorm"
-)
-
-type (
- OrderManage struct {
- Id int `json:"id" gorm:"column:id;primary_key;AUTO_INCREMENT"`
- Name string `json:"name" gorm:"column:name;type:varchar(255);comment:鍚堝悓鍚嶇О"`
- ClientId int `json:"clientId" gorm:"column:client_id;type:int;comment:瀹㈡埛id"`
- Number string `json:"number" gorm:"column:number;type:varchar(255);comment:鍚堝悓缂栧彿"`
- ContactId int `json:"contactId" gorm:"column:contact_id;type:int;comment:鑱旂郴浜篿d"`
- OrderType int `json:"orderType" gorm:"column:order_type;type:int;comment:宸ュ崟绫诲瀷"`
- ReportSourceId int `json:"reportSourceId" gorm:"column:report_source_id;type:int;comment:鎶ュ鏉ユ簮id"`
- SourceSheet int `json:"sourceSheet" gorm:"column:source_sheet;type:int;comment:鏉ユ簮鍗曟嵁"`
- ProblemDescription string `json:"problemDescription" gorm:"column:problem_description;type:text;comment:闂鎻忚堪"`
- File string `json:"file" gorm:"column:file;type:varchar(255);comment:闄勪欢"`
- }
-
- OrderManageSearch struct {
- OrderManage
- Orm *gorm.DB
- }
-)
-
-func (OrderManage) TableName() string {
- return "order_manage"
-}
-
-func NewOrderManageSearch() *OrderManageSearch {
- return &OrderManageSearch{
- Orm: mysqlx.GetDB(),
- }
-}
-
-func (slf *OrderManageSearch) build() *gorm.DB {
- var db = slf.Orm.Model(&OrderManage{})
- if slf.Id != 0 {
- db = db.Where("id = ?", slf.Id)
- }
-
- return db
-}
-
-func (slf *OrderManageSearch) Create(record *OrderManage) error {
- var db = slf.build()
- return db.Create(record).Error
-}
-
-func (slf *OrderManageSearch) Update(record *OrderManage) error {
- var db = slf.build()
- return db.Updates(record).Error
-}
-
-func (slf *OrderManageSearch) Delete() error {
- var db = slf.build()
- return db.Delete(&OrderManage{}).Error
-}
-
-func (slf *OrderManageSearch) Find() (*OrderManage, error) {
- var db = slf.build()
- var record = new(OrderManage)
- err := db.First(record).Error
- return record, err
-}
-
-func (slf *OrderManageSearch) FindAll() ([]*OrderManage, error) {
- var db = slf.build()
- var record = make([]*OrderManage, 0)
- err := db.Find(&record).Error
- return record, err
-}
-
-func (slf *OrderManageSearch) SetId(id int) *OrderManageSearch {
- slf.Id = id
- return slf
-}
+package model
+
+import (
+ "aps_crm/pkg/mysqlx"
+ "gorm.io/gorm"
+)
+
+type (
+ OrderManage struct {
+ Id int `json:"id" gorm:"column:id;primary_key;AUTO_INCREMENT"`
+ Name string `json:"name" gorm:"column:name;type:varchar(255);comment:鍚堝悓鍚嶇О"`
+ ClientId int `json:"clientId" gorm:"column:client_id;type:int;comment:瀹㈡埛id"`
+ Client Client `json:"client" gorm:"foreignKey:ClientId"`
+ Number string `json:"number" gorm:"column:number;type:varchar(255);comment:鍚堝悓缂栧彿"`
+ ContactId int `json:"contactId" gorm:"column:contact_id;type:int;comment:鑱旂郴浜篿d"`
+ OrderType int `json:"orderType" gorm:"column:order_type;type:int;comment:宸ュ崟绫诲瀷"`
+ ReportSourceId int `json:"reportSourceId" gorm:"column:report_source_id;type:int;comment:鎶ュ鏉ユ簮id"`
+ SourceSheet int `json:"sourceSheet" gorm:"column:source_sheet;type:int;comment:鏉ユ簮鍗曟嵁"`
+ ProblemDescription string `json:"problemDescription" gorm:"column:problem_description;type:text;comment:闂鎻忚堪"`
+ File string `json:"file" gorm:"column:file;type:varchar(255);comment:闄勪欢"`
+ gorm.Model `json:"-"`
+ }
+
+ OrderManageSearch struct {
+ OrderManage
+
+ Orm *gorm.DB
+ Keyword string
+ OrderBy string
+ PageNum int
+ PageSize int
+ }
+)
+
+func (OrderManage) TableName() string {
+ return "order_manage"
+}
+
+func NewOrderManageSearch() *OrderManageSearch {
+ return &OrderManageSearch{
+ Orm: mysqlx.GetDB(),
+ }
+}
+
+func (slf *OrderManageSearch) build() *gorm.DB {
+ var db = slf.Orm.Model(&OrderManage{})
+ if slf.Keyword != "" {
+ db = db.Where("name LIKE ?", "%"+slf.Keyword+"%")
+ }
+ if slf.Id != 0 {
+ db = db.Where("id = ?", slf.Id)
+ }
+
+ return db
+}
+
+func (slf *OrderManageSearch) Create(record *OrderManage) error {
+ var db = slf.build()
+ return db.Create(record).Error
+}
+
+func (slf *OrderManageSearch) Update(record *OrderManage) error {
+ var db = slf.build()
+ return db.Updates(record).Error
+}
+
+func (slf *OrderManageSearch) Delete() error {
+ var db = slf.build()
+ return db.Delete(&OrderManage{}).Error
+}
+
+func (slf *OrderManageSearch) Find() (*OrderManage, error) {
+ var db = slf.build()
+ var record = new(OrderManage)
+ err := db.First(record).Error
+ return record, err
+}
+
+func (slf *OrderManageSearch) FindAll() ([]*OrderManage, int64, error) {
+ var db = slf.build()
+ var records = make([]*OrderManage, 0)
+ var total int64
+ if err := db.Count(&total).Error; err != nil {
+ return records, total, err
+ }
+ if slf.PageNum > 0 && slf.PageSize > 0 {
+ db = db.Limit(slf.PageSize).Offset((slf.PageNum - 1) * slf.PageSize)
+ }
+
+ err := db.Preload("Client").Find(&records).Error
+ return records, total, err
+}
+
+func (slf *OrderManageSearch) SetId(id int) *OrderManageSearch {
+ slf.Id = id
+ return slf
+}
+
+func (slf *OrderManageSearch) SetKeyword(keyword string) *OrderManageSearch {
+ slf.Keyword = keyword
+ return slf
+}
+
+func (slf *OrderManageSearch) SetPage(page, size int) *OrderManageSearch {
+ slf.PageNum, slf.PageSize = page, size
+ return slf
+}
+
+func (slf *OrderManageSearch) SetOrder(order string) *OrderManageSearch {
+ slf.OrderBy = order
+ return slf
+}
+func (slf *OrderManageSearch) SetIds(ids []int) *OrderManageSearch {
+ slf.Orm = slf.Orm.Where("id in (?)", ids)
+ return slf
+}
--
Gitblit v1.8.0