From 5e15dc38b6ded37d6645e15aa187c370ffa23352 Mon Sep 17 00:00:00 2001
From: zhangqian <zhangqian@123.com>
Date: 星期日, 13 八月 2023 15:53:37 +0800
Subject: [PATCH] 完善退款单查询

---
 model/salesRefund.go |   62 ++++++++++++++++++++++++++----
 1 files changed, 53 insertions(+), 9 deletions(-)

diff --git a/model/salesRefund.go b/model/salesRefund.go
index 0874372..c3bea82 100644
--- a/model/salesRefund.go
+++ b/model/salesRefund.go
@@ -3,7 +3,10 @@
 import (
 	"aps_crm/constvar"
 	"aps_crm/pkg/mysqlx"
+	"fmt"
+	"github.com/shopspring/decimal"
 	"gorm.io/gorm"
+	"gorm.io/gorm/clause"
 )
 
 type (
@@ -15,6 +18,7 @@
 		SourceType    constvar.RefundSourceType `gorm:"column:source_type;type:int;not null;default 0;comment:鏉ユ簮绫诲瀷锛�1閿�鍞槑缁嗗崟2鏈嶅姟鍚堝悓3閿�鍞彂绁�4鏀舵璁″垝5鍑哄簱鍗曪級" json:"sourceType"` // 鏉ユ簮绫诲瀷锛�1閿�鍞槑缁嗗崟2鏈嶅姟鍚堝悓3閿�鍞彂绁�4鏀舵璁″垝5鍑哄簱鍗曪級
 		SourceId      int                       `gorm:"column:source_id;type:int;not null;default 0;comment:婧愬崟id " json:"sourceId"`                               // 婧愬崟id
 		MemberId      int                       `json:"memberId" gorm:"column:member_id;type:int;comment:璐熻矗浜篿d"`
+		Member        User                      `json:"member" gorm:"foreignKey:MemberId"`
 		RefundDate    string                    `json:"refundDate" gorm:"column:refund_date;type:datetime;comment:閫�娆炬棩鏈�"`
 		PaymentTypeId int                       `gorm:"column:payment_type_id;type:int;not null;default 0;comment:鏀舵鏂瑰紡ID" json:"paymentTypeId"` // 鏀舵鏂瑰紡ID
 		PaymentType   PaymentType               `gorm:"foreignKey:PaymentTypeId" json:"paymentType"`
@@ -23,17 +27,20 @@
 		IsInvoice     int                       `json:"isInvoice" gorm:"column:is_invoice;type:int;comment:鏄惁寮�绁�"`
 		Reason        string                    `json:"reason" gorm:"column:reason;type:varchar(255);comment:閫�娆惧師鍥�"`
 		Products      []*Product                `json:"products" gorm:"many2many:salesRefund_product;"`
-		gorm.Model    `json:"-"`
+		AmountTotal   decimal.Decimal           `gorm:"column:amount_total;type:decimal(12,2);comment:浠风◣鍚堣" json:"amountTotal"` // 浠风◣鍚堣
+		CrmModel
 	}
 
 	SalesRefundSearch struct {
 		SalesRefund
 
-		Orm      *gorm.DB
-		Keyword  string
-		OrderBy  string
-		PageNum  int
-		PageSize int
+		Orm         *gorm.DB
+		KeywordType constvar.SalesRefundKeywordType
+		Keyword     string
+		OrderBy     string
+		PageNum     int
+		PageSize    int
+		Preload     bool
 	}
 )
 
@@ -49,11 +56,38 @@
 
 func (slf *SalesRefundSearch) build() *gorm.DB {
 	var db = slf.Orm.Model(&SalesRefund{})
-	if slf.Keyword != "" {
-		db = db.Where("name LIKE ?", "%"+slf.Keyword+"%")
-	}
 	if slf.Id != 0 {
 		db = db.Where("id = ?", slf.Id)
+	}
+
+	if slf.Preload {
+		db = db.Preload("Client").
+			Preload("PaymentType").
+			Preload("BankAccount").
+			Preload("Products")
+	}
+	if slf.KeywordType != "" {
+		switch slf.KeywordType {
+		case constvar.SalesRefundKeywordRefundNumber:
+			db = db.Where("number like ?", fmt.Sprintf("%%%s%%", slf.Keyword))
+		case constvar.SalesRefundKeywordClientName:
+			db = db.Joins("Client", clause.LeftJoin).Where("Client.name like ?", fmt.Sprintf("%%%s%%", slf.Keyword))
+		case constvar.SalesRefundKeywordRefundDate:
+			db = db.Where("refund_date like ?", fmt.Sprintf("%%%s%%", slf.Keyword))
+		case constvar.SalesRefundKeywordAccount:
+			db = db.Joins("BankAccount").Where("BankAccount name like ?", fmt.Sprintf("%%%s%%", slf.Keyword))
+		case constvar.SalesRefundKeywordIsInvoice:
+			db = db.Where("is_invoice like ?", fmt.Sprintf("%%%s%%", slf.Keyword))
+		case constvar.SalesRefundKeywordPaymentType:
+			db = db.Joins("PaymentType").Where("PaymentType.name like ?", fmt.Sprintf("%%%s%%", slf.Keyword))
+		case constvar.SalesRefundKeywordPrincipal:
+			db = db.Joins("left join user on user.id = sales_refund.member_id").Where("user.username like ?", fmt.Sprintf("%%%s%%", slf.Keyword))
+		case constvar.SalesRefundKeywordUpdateAt:
+			db = db.Where("updated_at like ?", fmt.Sprintf("%%%s%%", slf.Keyword))
+		case constvar.SalesRefundKeywordPriceTotal:
+			db = db.Where("amount_total like ?", fmt.Sprintf("%%%s%%", slf.Keyword))
+
+		}
 	}
 
 	return db
@@ -105,6 +139,16 @@
 	return slf
 }
 
+func (slf *SalesRefundSearch) SetPreload(preload bool) *SalesRefundSearch {
+	slf.Preload = preload
+	return slf
+}
+
+func (slf *SalesRefundSearch) SetKeywordType(keywordType constvar.SalesRefundKeywordType) *SalesRefundSearch {
+	slf.KeywordType = keywordType
+	return slf
+}
+
 func (slf *SalesRefundSearch) SetKeyword(keyword string) *SalesRefundSearch {
 	slf.Keyword = keyword
 	return slf

--
Gitblit v1.8.0