package model
|
|
import (
|
"aps_crm/pkg/mysqlx"
|
"gorm.io/gorm"
|
"time"
|
)
|
|
type (
|
SalesDetails struct {
|
Id int `json:"id" gorm:"column:id;primary_key;AUTO_INCREMENT"`
|
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:销售子单号"`
|
SaleChanceId int `json:"saleChanceId" gorm:"column:sale_chance_id;type:int;comment:销售机会id"`
|
SaleType int `json:"saleType" gorm:"column:sale_type;type:int;comment:销售类型"`
|
SignTime time.Time `json:"signTime" gorm:"column:sign_time;type:datetime;comment:签单时间"`
|
MemberId int `json:"memberId" gorm:"column:member_id;type:int;comment:负责人id"`
|
DeliveryDate time.Time `json:"deliveryDate" gorm:"column:delivery_date;type:datetime;comment:交货日期"`
|
WechatOrderStatus int `json:"wechatOrderStatus" gorm:"column:wechat_order_status;type:int;comment:微信订单状态"`
|
Address string `json:"address" gorm:"column:address;type:varchar(255);comment:地址"`
|
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:条件"`
|
Remark string `json:"remark" gorm:"column:remark;type:text;comment:备注"`
|
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:物流费用"`
|
gorm.Model `json:"-"`
|
}
|
|
SalesDetailsSearch struct {
|
SalesDetails
|
|
Orm *gorm.DB
|
Keyword string
|
OrderBy string
|
PageNum int
|
PageSize int
|
|
}
|
)
|
|
func (SalesDetails) TableName() string {
|
return "sales_details"
|
}
|
|
func NewSalesDetailsSearch() *SalesDetailsSearch {
|
return &SalesDetailsSearch{
|
Orm: mysqlx.GetDB(),
|
}
|
}
|
|
func (slf *SalesDetailsSearch) build() *gorm.DB {
|
var db = slf.Orm.Model(&SalesDetails{})
|
if slf.Keyword != "" {
|
db = db.Where("name LIKE ?", "%"+slf.Keyword+"%")
|
}
|
if slf.Id != 0 {
|
db = db.Where("id = ?", slf.Id)
|
}
|
|
return db
|
}
|
|
func (slf *SalesDetailsSearch) Create(record *SalesDetails) error {
|
var db = slf.build()
|
return db.Create(record).Error
|
}
|
|
func (slf *SalesDetailsSearch) Delete() error {
|
var db = slf.build()
|
return db.Delete(&SalesDetails{}).Error
|
}
|
|
func (slf *SalesDetailsSearch) Update(record *SalesDetails) error {
|
var db = slf.build()
|
return db.Updates(record).Error
|
}
|
|
func (slf *SalesDetailsSearch) SetId(id int) *SalesDetailsSearch {
|
slf.Id = id
|
return slf
|
}
|
|
func (slf *SalesDetailsSearch) Find() (*SalesDetails, error) {
|
var db = slf.build()
|
var record = new(SalesDetails)
|
err := db.First(record).Error
|
return record, err
|
}
|
|
func (slf *SalesDetailsSearch) FindAll() ([]*SalesDetails, int64, error) {
|
var db = slf.build()
|
var records = make([]*SalesDetails, 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)
|
}
|
|
if slf.PageNum > 0 && slf.PageSize > 0 {
|
db = db.Limit(slf.PageSize).Offset((slf.PageNum - 1) * slf.PageSize)
|
}
|
|
err := db.Preload("Products").Preload("Client").Find(&records).Error
|
return records, total, err
|
}
|
|
func (slf *SalesDetailsSearch) SetKeyword(keyword string) *SalesDetailsSearch {
|
slf.Keyword = keyword
|
return slf
|
}
|
|
func (slf *SalesDetailsSearch) SetPage(page, size int) *SalesDetailsSearch {
|
slf.PageNum, slf.PageSize = page, size
|
return slf
|
}
|
|
func (slf *SalesDetailsSearch) SetOrder(order string) *SalesDetailsSearch {
|
slf.OrderBy = order
|
return slf
|
}
|
