| | |
| | | |
| | | type ( |
| | | SubOrder 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"` |
| | | MemberId int `json:"memberId" gorm:"column:member_id;type:int;comment:负责人id"` |
| | | MasterOrderId int `json:"masterOrderId" gorm:"column:master_order_id;type:int;comment:销售总单id"` |
| | | Number string `json:"number" gorm:"column:number;type:varchar(255);comment:销售子单号"` |
| | | Products []Product `json:"products" gorm:"many2many:subOrder_product;"` |
| | | 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"` |
| | | MemberId int `json:"memberId" gorm:"column:member_id;type:int;comment:负责人id"` |
| | | Member User `json:"member" gorm:"foreignKey:MemberId"` |
| | | MasterOrderId int `json:"masterOrderId" gorm:"column:master_order_id;type:int;comment:销售总单id"` |
| | | MasterOrder MasterOrder `json:"masterOrder" gorm:"foreignKey:MasterOrderId"` |
| | | Number string `json:"number" gorm:"column:number;type:varchar(255);comment:销售子单号"` |
| | | Products []Product `json:"products" gorm:"many2many:subOrder_product;"` |
| | | gorm.Model `json:"-"` |
| | | } |
| | | |
| | |
| | | db = db.Limit(slf.PageSize).Offset((slf.PageNum - 1) * slf.PageSize) |
| | | } |
| | | |
| | | err := db.Preload("Products").Preload("Client").Order("id desc").Find(&records).Error |
| | | err := db.Preload("MasterOrder").Preload("Member").Preload("Products").Preload("Client").Order("id desc").Find(&records).Error |
| | | return records, total, err |
| | | } |
| | | |