| | |
| | | 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"` |
| | | Client Client `json:"client" gorm:"foreignKey:ClientId"` |
| | | MemberId int `json:"member_id" gorm:"column:member_id;type:int;comment:负责人id"` |
| | | Member User `json:"member" gorm:"foreignKey:MemberId"` |
| | | StartTime *CustomTime `json:"start_time" gorm:"column:start_time;type:datetime;comment:开始时间"` |
| | | EndTime *CustomTime `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:"-"` |
| | | 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"` |
| | | Client Client `json:"client" gorm:"foreignKey:ClientId"` |
| | | MemberId int `json:"member_id" gorm:"column:member_id;type:int;comment:负责人id"` |
| | | Member User `json:"member" gorm:"foreignKey:MemberId"` |
| | | StartTime *CustomTime `json:"start_time" gorm:"column:start_time;type:datetime;comment:开始时间"` |
| | | EndTime *CustomTime `json:"end_time" gorm:"column:end_time;type:datetime;comment:结束时间"` |
| | | Money float64 `json:"money" gorm:"column:money;type:decimal(10,2);comment:总金额"` |
| | | CodeStandID string `json:"codeStandID" gorm:"column:code_stand_id;type:varchar(255);comment:编码id"` |
| | | gorm.Model `json:"-"` |
| | | } |
| | | |
| | | // MasterOrderSearch 销售总单搜索条件 |
| | |
| | | if key == "member_name" { |
| | | db = db.Joins("Member").Where("Member.username = ?", v) |
| | | } |
| | | case int: |
| | | case float64: |
| | | case int, float64: |
| | | if key == "client_id" || key == "member_id" || key == "money" { |
| | | db = db.Where(key+" = ?", v) |
| | | } |
| | |
| | | slf.Orm = slf.Orm.Where("id in (?)", ids) |
| | | return slf |
| | | } |
| | | |
| | | func (slf *MasterOrderSearch) UpdateByMap(data map[string]interface{}) error { |
| | | var db = slf.build() |
| | | return db.Updates(data).Error |
| | | } |