package model
|
|
import (
|
"aps_crm/pkg/mysqlx"
|
"github.com/shopspring/decimal"
|
"gorm.io/gorm"
|
)
|
|
type (
|
DeliveryOrder struct {
|
Id int `json:"id" gorm:"column:id;primary_key;AUTO_INCREMENT"`
|
MemberId int `json:"memberId" gorm:"column:member_id;type:int;comment:服务人员id"`
|
SalesDetailsId int `json:"salesDetailsId" gorm:"column:sales_details_id;type:int;comment:销售明细id"`
|
ProductID uint `json:"productID" gorm:"column:product_id"`
|
Name string `json:"name" gorm:"column:name;type:varchar(255);comment:产品名称"`
|
Number string `json:"number" gorm:"column:number;type:varchar(255);comment:产品编号"` //产品编号
|
Amount decimal.Decimal `json:"amount" gorm:"column:amount;type:decimal(12,2);comment:产品数量"` //订单数量
|
FinishAmount decimal.Decimal `json:"finishAmount" gorm:"-"` //订单完成数量
|
AvailableAmount decimal.Decimal `json:"availableAmount" gorm:"-"` //可用库存
|
DeliveryAmount decimal.Decimal `json:"deliveryAmount" gorm:"-"` //本次发货数量
|
LeftAmount decimal.Decimal `json:"leftAmount" gorm:"column:left_amount;type:decimal(12,2);comment:剩余发货数量"`
|
gorm.Model `json:"-"`
|
}
|
|
DeliveryOrderSearch struct {
|
DeliveryOrder
|
Orm *gorm.DB
|
}
|
)
|
|
func (DeliveryOrder) TableName() string {
|
return "delivery_order"
|
}
|
|
func NewDeliveryOrderSearch() *DeliveryOrderSearch {
|
return &DeliveryOrderSearch{
|
Orm: mysqlx.GetDB(),
|
}
|
}
|
|
func (css *DeliveryOrderSearch) build() *gorm.DB {
|
var db = css.Orm.Model(&DeliveryOrder{})
|
if css.Id != 0 {
|
db = db.Where("id = ?", css.Id)
|
}
|
if css.SalesDetailsId != 0 {
|
db = db.Where("sales_details_id = ?", css.SalesDetailsId)
|
}
|
|
return db
|
}
|
|
func (css *DeliveryOrderSearch) Create(record *DeliveryOrder) error {
|
var db = css.build()
|
return db.Create(record).Error
|
}
|
|
func (css *DeliveryOrderSearch) Update(record *DeliveryOrder) error {
|
var db = css.build()
|
return db.Updates(record).Error
|
}
|
|
func (css *DeliveryOrderSearch) Delete() error {
|
var db = css.build()
|
return db.Delete(&DeliveryOrder{}).Error
|
}
|
|
func (css *DeliveryOrderSearch) Find() (*DeliveryOrder, error) {
|
var db = css.build()
|
var record = &DeliveryOrder{}
|
err := db.First(record).Error
|
return record, err
|
}
|
|
func (css *DeliveryOrderSearch) FindAll() ([]*DeliveryOrder, error) {
|
var db = css.build()
|
var records = make([]*DeliveryOrder, 0)
|
err := db.Find(&records).Error
|
return records, err
|
}
|
|
func (css *DeliveryOrderSearch) SetId(id int) *DeliveryOrderSearch {
|
css.Id = id
|
return css
|
}
|
|
func (css *DeliveryOrderSearch) SetSalesDetailsID(id int) *DeliveryOrderSearch {
|
css.SalesDetailsId = id
|
return css
|
}
|