From f1842bf9b5bb69b5078a215c02cb16b7e33f893a Mon Sep 17 00:00:00 2001 From: zhangqian <zhangqian@123.com> Date: 星期一, 08 一月 2024 14:38:46 +0800 Subject: [PATCH] Merge branch 'master' of http://192.168.5.5:10010/r/aps/crm --- model/quotation.go | 13 ++++++++++++- 1 files changed, 12 insertions(+), 1 deletions(-) diff --git a/model/quotation.go b/model/quotation.go index 1c45c24..c4618ee 100644 --- a/model/quotation.go +++ b/model/quotation.go @@ -3,6 +3,7 @@ import ( "aps_crm/pkg/mysqlx" "fmt" + "github.com/shopspring/decimal" "gorm.io/gorm" ) @@ -27,6 +28,7 @@ SaleChance SaleChance `json:"sale_chance" gorm:"foreignKey:SaleChanceId"` Products []Product `json:"products" gorm:"many2many:quotation_product"` CodeStandID string `json:"codeStandID" gorm:"column:code_stand_id;type:varchar(255);comment:缂栫爜id"` + AmountTotal decimal.Decimal `gorm:"-" json:"amountTotal"` //浠锋牸鍚堣 gorm.Model `json:"-"` } @@ -62,6 +64,9 @@ } if slf.Number != "" { db = db.Where("number = ?", slf.Number) + } + if slf.QuotationStatusId != 0 { + db = db.Where("quotation_status_id = ?", slf.QuotationStatusId) } if len(slf.SearchMap) > 0 { @@ -132,7 +137,7 @@ db = db.Limit(slf.PageSize).Offset((slf.PageNum - 1) * slf.PageSize) } - err := db.Preload("Products").Preload("Member").Preload("QuotationStatus").Preload("Client").Preload("Contact").Order("id desc").Find(&records).Error + err := db.Preload("Products").Preload("Member").Preload("QuotationStatus").Preload("Client").Preload("Contact").Preload("SaleChance").Order("id desc").Find(&records).Error return records, total, err } @@ -189,7 +194,13 @@ slf.Number = number return slf } + func (slf *QuotationSearch) SetIds(ids []int) *QuotationSearch { slf.Orm = slf.Orm.Where("id in (?)", ids) return slf } + +func (slf *QuotationSearch) SetQuotationStatusId(id int) *QuotationSearch { + slf.QuotationStatusId = id + return slf +} -- Gitblit v1.8.0