| | |
| | | package model |
| | | |
| | | import ( |
| | | "aps_crm/constvar" |
| | | "aps_crm/pkg/mysqlx" |
| | | "errors" |
| | | "fmt" |
| | | "gorm.io/gorm" |
| | | "sync" |
| | | ) |
| | | |
| | | type ( |
| | | // ServiceContractStatus 商机阶段 |
| | | // ServiceContractStatus 合同状态 |
| | | ServiceContractStatus struct { |
| | | Id int `json:"id" gorm:"column:id;primary_key;AUTO_INCREMENT"` |
| | | Name string `json:"name" gorm:"column:name;type:varchar(255);comment:商机阶段名称"` |
| | | Id int `json:"id" gorm:"column:id;type:int;primary_key;AUTO_INCREMENT"` |
| | | Name string `json:"name" gorm:"column:name;type:varchar(255);not null;default:'';comment:名称"` |
| | | } |
| | | |
| | | // ServiceContractStatusSearch 合同状态搜索条件 |
| | | ServiceContractStatusSearch struct { |
| | | ServiceContractStatus |
| | | Orm *gorm.DB |
| | | Orm *gorm.DB |
| | | QueryClass constvar.ServiceContractStatusQueryClass |
| | | KeywordType constvar.ServiceContractStatusKeywordType |
| | | Keyword string |
| | | PageNum int |
| | | PageSize int |
| | | } |
| | | ) |
| | | |
| | |
| | | if slf.Id != 0 { |
| | | db = db.Where("id = ?", slf.Id) |
| | | } |
| | | if slf.Name != "" { |
| | | db = db.Where("name = ?", slf.Name) |
| | | } |
| | | |
| | | return db |
| | | } |
| | |
| | | func (slf *ServiceContractStatusSearch) Create(record *ServiceContractStatus) error { |
| | | var db = slf.build() |
| | | return db.Create(record).Error |
| | | } |
| | | |
| | | func (slf *ServiceContractStatusSearch) CreateBatch(records []*ServiceContractStatus) error { |
| | | var db = slf.build() |
| | | return db.Create(records).Error |
| | | } |
| | | |
| | | func (slf *ServiceContractStatusSearch) Delete() error { |
| | |
| | | return db.Updates(record).Error |
| | | } |
| | | |
| | | func (slf *ServiceContractStatusSearch) Find() (*ServiceContractStatus, error) { |
| | | var db = slf.build() |
| | | var record = new(ServiceContractStatus) |
| | | err := db.First(record).Error |
| | | return record, err |
| | | } |
| | | |
| | | func (slf *ServiceContractStatusSearch) FindAll() ([]*ServiceContractStatus, error) { |
| | | var db = slf.build() |
| | | var records = make([]*ServiceContractStatus, 0) |
| | | err := db.Find(&records).Error |
| | | return records, err |
| | | var record = make([]*ServiceContractStatus, 0) |
| | | err := db.Find(&record).Error |
| | | return record, err |
| | | } |
| | | |
| | | func (slf *ServiceContractStatusSearch) SetId(id int) *ServiceContractStatusSearch { |
| | |
| | | return slf |
| | | } |
| | | |
| | | func (slf *ServiceContractStatusSearch) SetName(name string) *ServiceContractStatusSearch { |
| | | slf.Name = name |
| | | func (slf *ServiceContractStatusSearch) SetPage(page, size int) *ServiceContractStatusSearch { |
| | | slf.PageNum, slf.PageSize = page, size |
| | | return slf |
| | | } |
| | | |
| | | func (slf *ServiceContractStatusSearch) Updates(data map[string]interface{}) error { |
| | | var db = slf.build() |
| | | return db.Updates(data).Error |
| | | func (slf *ServiceContractStatusSearch) SetOrm(tx *gorm.DB) *ServiceContractStatusSearch { |
| | | slf.Orm = tx |
| | | return slf |
| | | } |
| | | |
| | | func (slf *ServiceContractStatusSearch) CreateBatch(records []*ServiceContractStatus) error { |
| | | func (slf *ServiceContractStatusSearch) First() (*ServiceContractStatus, error) { |
| | | var db = slf.build() |
| | | return db.Create(records).Error |
| | | var record = new(ServiceContractStatus) |
| | | err := db.First(record).Error |
| | | return record, err |
| | | } |
| | | |
| | | func (slf *ServiceContractStatusSearch) Updates(values interface{}) error { |
| | | var db = slf.build() |
| | | return db.Updates(values).Error |
| | | } |
| | | |
| | | func (slf *ServiceContractStatusSearch) Save(record *ServiceContractStatus) error { |
| | | if record.Id == 0 { |
| | | return errors.New("id为空") |
| | | } |
| | | var db = slf.build() |
| | | |
| | | if err := db.Save(record).Error; err != nil { |
| | | return fmt.Errorf("save err: %v, record: %+v", err, record) |
| | | } |
| | | |
| | | return nil |
| | | } |
| | | |
| | | func (slf *ServiceContractStatusSearch) Find() ([]*ServiceContractStatus, int64, error) { |
| | | var db = slf.build() |
| | | var records = make([]*ServiceContractStatus, 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) |
| | | } |
| | | |
| | | err := db.Find(&records).Error |
| | | return records, total, err |
| | | } |
| | | |
| | | // InitDefaultData 初始化数据 |