From c5a0eb549cba2cd358a2d0496c44f3a289f15d9c Mon Sep 17 00:00:00 2001 From: wangpengfei <274878379@qq.com> Date: 星期一, 28 八月 2023 14:22:06 +0800 Subject: [PATCH] fix --- model/salesDetails.go | 21 +++++++++++++++++---- 1 files changed, 17 insertions(+), 4 deletions(-) diff --git a/model/salesDetails.go b/model/salesDetails.go index 25211e3..ed81fab 100644 --- a/model/salesDetails.go +++ b/model/salesDetails.go @@ -20,6 +20,7 @@ SaleType int `json:"saleType" gorm:"column:sale_type;type:int;comment:閿�鍞被鍨�"` SignTime string `json:"signTime" gorm:"column:sign_time;type:varchar(255);comment:绛惧崟鏃堕棿"` MemberId int `json:"memberId" gorm:"column:member_id;type:int;comment:璐熻矗浜篿d"` + Member User `json:"Member" gorm:"foreignKey:MemberId"` DeliveryDate string `json:"deliveryDate" gorm:"column:delivery_date;type:varchar(255);comment:浜よ揣鏃ユ湡"` WechatOrderStatusId int `json:"wechatOrderStatusId" gorm:"column:wechat_order_status;type:int;comment:寰俊璁㈠崟鐘舵��"` WechatOrderStatus WechatOrderStatus `json:"wechatOrderStatus" gorm:"foreignKey:WechatOrderStatusId"` @@ -27,8 +28,9 @@ Phone string `json:"phone" gorm:"column:phone;type:varchar(255);comment:鐢佃瘽"` Addressee string `json:"addressee" gorm:"column:addressee;type:varchar(255);comment:鏀朵欢浜�"` Conditions string `json:"conditions" gorm:"column:conditions;type:text;comment:鏉′欢"` + CreatorId int `json:"creatorId" gorm:"column:creator_id;type:int;comment:鍒涘缓浜篿d"` Remark string `json:"remark" gorm:"column:remark;type:text;comment:澶囨敞"` - Products []*Product `json:"products" gorm:"many2many:sales_details_product;"` + Products []*Product `json:"products" gorm:"many2many:SalesDetails_Product;"` LogisticCompany string `json:"logisticCompany" gorm:"column:logistic_company;type:varchar(255);comment:鐗╂祦鍏徃"` LogisticNumber string `json:"logisticNumber" gorm:"column:logistic_number;type:varchar(255);comment:鐗╂祦鍗曞彿"` LogisticCost float64 `json:"logisticCost" gorm:"column:logistic_cost;type:decimal(10,2);comment:鐗╂祦璐圭敤"` @@ -37,7 +39,7 @@ AmountInvoiced decimal.Decimal `gorm:"column:amount_invoiced;type:decimal(12,2);comment:宸插紑绁ㄩ噾棰�" json:"amountInvoiced"` // 宸插紑绁ㄩ噾棰� AmountUnInvoiced decimal.Decimal `gorm:"column:amount_not_invoiced;type:decimal(12,2);comment:鏈紑绁ㄩ噾棰�" json:"amountUnInvoiced"` // 鏈紑绁ㄩ噾棰� AmountTotal decimal.Decimal `gorm:"column:amount_total;type:decimal(12,2);comment:浠风◣鍚堣" json:"amountTotal"` // 浠风◣鍚堣 - gorm.Model `json:"-"` + CrmModel } SalesDetailsSearch struct { @@ -83,7 +85,7 @@ } if slf.Preload { db = db.Preload("Products"). - Preload("Client"). + Preload("Member"). Preload("SaleChance"). Preload("WechatOrderStatus"). Preload("Client") @@ -99,6 +101,12 @@ func (slf *SalesDetailsSearch) Delete() error { var db = slf.build() + return db.Delete(&SalesDetails{}).Error +} + +func (slf *SalesDetailsSearch) DeleteByIds(ids []int) error { + var db = slf.build() + db = db.Where("id in ?", ids) return db.Delete(&SalesDetails{}).Error } @@ -134,7 +142,7 @@ db = db.Limit(slf.PageSize).Offset((slf.PageNum - 1) * slf.PageSize) } - err := db.Find(&records).Error + err := db.Order("id desc").Find(&records).Error return records, total, err } @@ -216,3 +224,8 @@ amount = record.AmountUnInvoiced.Add(amount) return slf.UpdateByMap(map[string]interface{}{"amount_not_invoiced": amount}) } + +func (slf *SalesDetailsSearch) UpdateProducts(record *SalesDetails, newProducts, removedProducts []*Product) error { + var db = slf.build() + return db.Updates(record).Error +} -- Gitblit v1.8.0