package model
|
|
import (
|
"aps_crm/pkg/mysqlx"
|
"gorm.io/gorm"
|
)
|
|
type (
|
OrderManage struct {
|
Id int `json:"id" gorm:"column:id;primary_key;AUTO_INCREMENT"`
|
Name string `json:"name" gorm:"column:name;type:varchar(255);comment:合同名称"`
|
ClientId int `json:"clientId" gorm:"column:client_id;type:int;comment:客户id"`
|
Number string `json:"number" gorm:"column:number;type:varchar(255);comment:合同编号"`
|
ContactId int `json:"contactId" gorm:"column:contact_id;type:int;comment:联系人id"`
|
OrderType int `json:"orderType" gorm:"column:order_type;type:int;comment:工单类型"`
|
ReportSourceId int `json:"reportSourceId" gorm:"column:report_source_id;type:int;comment:报备来源id"`
|
SourceSheet int `json:"sourceSheet" gorm:"column:source_sheet;type:int;comment:来源单据"`
|
ProblemDescription string `json:"problemDescription" gorm:"column:problem_description;type:text;comment:问题描述"`
|
File string `json:"file" gorm:"column:file;type:varchar(255);comment:附件"`
|
gorm.Model `json:"-"`
|
}
|
|
OrderManageSearch struct {
|
OrderManage
|
Orm *gorm.DB
|
}
|
)
|
|
func (OrderManage) TableName() string {
|
return "order_manage"
|
}
|
|
func NewOrderManageSearch() *OrderManageSearch {
|
return &OrderManageSearch{
|
Orm: mysqlx.GetDB(),
|
}
|
}
|
|
func (slf *OrderManageSearch) build() *gorm.DB {
|
var db = slf.Orm.Model(&OrderManage{})
|
if slf.Id != 0 {
|
db = db.Where("id = ?", slf.Id)
|
}
|
|
return db
|
}
|
|
func (slf *OrderManageSearch) Create(record *OrderManage) error {
|
var db = slf.build()
|
return db.Create(record).Error
|
}
|
|
func (slf *OrderManageSearch) Update(record *OrderManage) error {
|
var db = slf.build()
|
return db.Updates(record).Error
|
}
|
|
func (slf *OrderManageSearch) Delete() error {
|
var db = slf.build()
|
return db.Delete(&OrderManage{}).Error
|
}
|
|
func (slf *OrderManageSearch) Find() (*OrderManage, error) {
|
var db = slf.build()
|
var record = new(OrderManage)
|
err := db.First(record).Error
|
return record, err
|
}
|
|
func (slf *OrderManageSearch) FindAll() ([]*OrderManage, error) {
|
var db = slf.build()
|
var record = make([]*OrderManage, 0)
|
err := db.Find(&record).Error
|
return record, err
|
}
|
|
func (slf *OrderManageSearch) SetId(id int) *OrderManageSearch {
|
slf.Id = id
|
return slf
|
}
|