package model import ( "aps_crm/pkg/mysqlx" "gorm.io/gorm" "time" ) type ( // MasterOrder 销售总单 MasterOrder struct { Id int `json:"id" gorm:"column:id;primary_key;AUTO_INCREMENT"` Number string `json:"number" gorm:"column:number;type:varchar(255);comment:销售总单号"` ClientId int `json:"client_id" gorm:"column:client_id;type:int;comment:客户id"` MemberId int `json:"member_id" gorm:"column:member_id;type:int;comment:负责人id"` StartTime time.Time `json:"start_time" gorm:"column:start_time;type:datetime;comment:开始时间"` EndTime time.Time `json:"end_time" gorm:"column:end_time;type:datetime;comment:结束时间"` Money float64 `json:"money" gorm:"column:money;type:decimal(10,2);comment:总金额"` gorm.Model `json:"-"` } // MasterOrderSearch 销售总单搜索条件 MasterOrderSearch struct { MasterOrder Orm *gorm.DB } ) func (MasterOrder) TableName() string { return "master_order" } func NewMasterOrderSearch() *MasterOrderSearch { return &MasterOrderSearch{ Orm: mysqlx.GetDB(), } } func (slf *MasterOrderSearch) build() *gorm.DB { var db = slf.Orm.Model(&MasterOrder{}) if slf.Id != 0 { db = db.Where("id = ?", slf.Id) } return db } func (slf *MasterOrderSearch) Create(record *MasterOrder) error { var db = slf.build() return db.Create(record).Error } func (slf *MasterOrderSearch) Delete() error { var db = slf.build() return db.Delete(&MasterOrder{}).Error } func (slf *MasterOrderSearch) Update(record *MasterOrder) error { var db = slf.build() return db.Updates(record).Error } func (slf *MasterOrderSearch) Find() (*MasterOrder, error) { var db = slf.build() var record = new(MasterOrder) err := db.First(record).Error return record, err } func (slf *MasterOrderSearch) FindAll() ([]*MasterOrder, error) { var db = slf.build() var records = make([]*MasterOrder, 0) err := db.Find(&records).Error return records, err } func (slf *MasterOrderSearch) SetId(id int) *MasterOrderSearch { slf.Id = id return slf }