File was renamed from models/job_type.go |
| | |
| | | ) |
| | | |
| | | type ( |
| | | // JobType 作业类型 |
| | | JobType struct { |
| | | // OperationType 作业类型 |
| | | OperationType struct { |
| | | WmsModel |
| | | Id int `json:"id" gorm:"column:id;primary_key;AUTO_INCREMENT"` |
| | | Name string `json:"name" gorm:"index;type:varchar(255);not null;comment:仓库名称"` //仓库名称 |
| | | BaseJobType constvar.BaseJobType `json:"baseJobType" gorm:"type:tinyint;not null;comment:基础作业类型"` //基础作业类型 |
| | | CompanyId int `json:"companyId" gorm:"type:int;not null;comment:公司id"` //公司id |
| | | Company Company `json:"company" gorm:"foreignKey:CompanyId"` //公司 |
| | | WarehouseId int `json:"warehouseId" gorm:"type:int;not null;comment:仓库id"` //仓库id |
| | | Warehouse Warehouse `json:"warehouse" gorm:"foreignKey:WarehouseId"` //仓库 |
| | | Id int `json:"id" gorm:"column:id;primary_key;AUTO_INCREMENT"` |
| | | Name string `json:"name" gorm:"index;type:varchar(255);not null;comment:仓库名称"` //仓库名称 |
| | | BaseOperationType constvar.BaseOperationType `json:"baseOperationType" gorm:"type:tinyint;not null;comment:基础作业类型"` //基础作业类型 |
| | | CompanyId int `json:"companyId" gorm:"type:int;not null;comment:公司id"` //公司id |
| | | Company Company `json:"company" gorm:"foreignKey:CompanyId"` //公司 |
| | | WarehouseId int `json:"warehouseId" gorm:"type:int;not null;comment:仓库id"` //仓库id |
| | | Warehouse Warehouse `json:"warehouse" gorm:"foreignKey:WarehouseId"` //仓库 |
| | | |
| | | DefaultLocationSrcId int `json:"defaultLocationSrcId" gorm:"type:int;not null;comment:默认源位置id"` //默认源位置id |
| | | DefaultLocationSrc Location `json:"defaultLocationSrc" gorm:"foreignKey:DefaultLocationSrcId"` //默认源位置 |
| | |
| | | ReservationDaysBeforePriority int `json:"ReservationDaysBeforePriority" gorm:"type:int;"` //在优先级的前几天 |
| | | ShowOperations bool `json:"showOperations" gorm:"column:show_operations;type:int"` //显示作业详情 |
| | | CreateBackorder constvar.WhetherType `json:"createBackorder" gorm:"column:create_backorder"` //创建欠单 |
| | | ReturnJobTypeID int `json:"returnJobTypeID" gorm:"column:return_job_type_id"` //退货类型ID |
| | | ReturnJobType string `json:"returnJobType" gorm:"-"` //退货类型名称 |
| | | ReturnOperationTypeID int `json:"returnOperationTypeID" gorm:"column:return_job_type_id"` //退货类型ID |
| | | ReturnOperationType string `json:"returnOperationType" gorm:"-"` //退货类型名称 |
| | | } |
| | | |
| | | JobTypeSearch struct { |
| | | JobType |
| | | OperationTypeSearch struct { |
| | | OperationType |
| | | Order string |
| | | PageNum int |
| | | PageSize int |
| | |
| | | } |
| | | ) |
| | | |
| | | func (slf *JobType) TableName() string { |
| | | func (slf *OperationType) TableName() string { |
| | | return "job_type" |
| | | } |
| | | |
| | | func NewJobTypeSearch() *JobTypeSearch { |
| | | return &JobTypeSearch{Orm: mysqlx.GetDB()} |
| | | func NewOperationTypeSearch() *OperationTypeSearch { |
| | | return &OperationTypeSearch{Orm: mysqlx.GetDB()} |
| | | } |
| | | |
| | | func (slf *JobTypeSearch) SetOrm(tx *gorm.DB) *JobTypeSearch { |
| | | func (slf *OperationTypeSearch) SetOrm(tx *gorm.DB) *OperationTypeSearch { |
| | | slf.Orm = tx |
| | | return slf |
| | | } |
| | | |
| | | func (slf *JobTypeSearch) SetPage(page, size int) *JobTypeSearch { |
| | | func (slf *OperationTypeSearch) SetPage(page, size int) *OperationTypeSearch { |
| | | slf.PageNum, slf.PageSize = page, size |
| | | return slf |
| | | } |
| | | |
| | | func (slf *JobTypeSearch) SetOrder(order string) *JobTypeSearch { |
| | | func (slf *OperationTypeSearch) SetOrder(order string) *OperationTypeSearch { |
| | | slf.Order = order |
| | | return slf |
| | | } |
| | | |
| | | func (slf *JobTypeSearch) SetID(id uint) *JobTypeSearch { |
| | | func (slf *OperationTypeSearch) SetID(id uint) *OperationTypeSearch { |
| | | slf.ID = id |
| | | return slf |
| | | } |
| | | |
| | | func (slf *JobTypeSearch) SetName(name string) *JobTypeSearch { |
| | | func (slf *OperationTypeSearch) SetName(name string) *OperationTypeSearch { |
| | | slf.Name = name |
| | | return slf |
| | | } |
| | | |
| | | func (slf *JobTypeSearch) SetKeyword(keyword string) *JobTypeSearch { |
| | | func (slf *OperationTypeSearch) SetKeyword(keyword string) *OperationTypeSearch { |
| | | slf.Keyword = keyword |
| | | return slf |
| | | } |
| | | |
| | | func (slf *JobTypeSearch) SetPreload(preload bool) *JobTypeSearch { |
| | | func (slf *OperationTypeSearch) SetPreload(preload bool) *OperationTypeSearch { |
| | | slf.Preload = preload |
| | | return slf |
| | | } |
| | | |
| | | func (slf *JobTypeSearch) build() *gorm.DB { |
| | | var db = slf.Orm.Model(&JobType{}) |
| | | func (slf *OperationTypeSearch) build() *gorm.DB { |
| | | var db = slf.Orm.Model(&OperationType{}) |
| | | |
| | | if slf.ID != 0 { |
| | | db = db.Where("id = ?", slf.ID) |
| | |
| | | } |
| | | |
| | | // Create 单条插入 |
| | | func (slf *JobTypeSearch) Create(record *JobType) error { |
| | | func (slf *OperationTypeSearch) Create(record *OperationType) error { |
| | | var db = slf.build() |
| | | |
| | | if err := db.Create(record).Error; err != nil { |
| | |
| | | } |
| | | |
| | | // CreateBatch 批量插入 |
| | | func (slf *JobTypeSearch) CreateBatch(records []*JobType) error { |
| | | func (slf *OperationTypeSearch) CreateBatch(records []*OperationType) error { |
| | | var db = slf.build() |
| | | |
| | | if err := db.Create(&records).Error; err != nil { |
| | |
| | | return nil |
| | | } |
| | | |
| | | func (slf *JobTypeSearch) Update(record *JobType) error { |
| | | func (slf *OperationTypeSearch) Update(record *OperationType) error { |
| | | var db = slf.build() |
| | | |
| | | if err := db.Omit("CreatedAt").Updates(record).Error; err != nil { |
| | |
| | | return nil |
| | | } |
| | | |
| | | func (slf *JobTypeSearch) UpdateByMap(upMap map[string]interface{}) error { |
| | | func (slf *OperationTypeSearch) UpdateByMap(upMap map[string]interface{}) error { |
| | | var ( |
| | | db = slf.build() |
| | | ) |
| | |
| | | return nil |
| | | } |
| | | |
| | | func (slf *JobTypeSearch) UpdateByQuery(query string, args []interface{}, upMap map[string]interface{}) error { |
| | | func (slf *OperationTypeSearch) UpdateByQuery(query string, args []interface{}, upMap map[string]interface{}) error { |
| | | var ( |
| | | db = slf.Orm.Table(slf.TableName()).Where(query, args...) |
| | | ) |
| | |
| | | return nil |
| | | } |
| | | |
| | | func (slf *JobTypeSearch) Delete() error { |
| | | func (slf *OperationTypeSearch) Delete() error { |
| | | var db = slf.build() |
| | | return db.Delete(&JobType{}).Error |
| | | return db.Delete(&OperationType{}).Error |
| | | } |
| | | |
| | | func (slf *JobTypeSearch) First() (*JobType, error) { |
| | | func (slf *OperationTypeSearch) First() (*OperationType, error) { |
| | | var ( |
| | | record = new(JobType) |
| | | record = new(OperationType) |
| | | db = slf.build() |
| | | ) |
| | | |
| | |
| | | return record, nil |
| | | } |
| | | |
| | | func (slf *JobTypeSearch) Find() ([]*JobType, int64, error) { |
| | | func (slf *OperationTypeSearch) Find() ([]*OperationType, int64, error) { |
| | | var ( |
| | | records = make([]*JobType, 0) |
| | | records = make([]*OperationType, 0) |
| | | total int64 |
| | | db = slf.build() |
| | | ) |
| | |
| | | return records, total, nil |
| | | } |
| | | |
| | | func (slf *JobTypeSearch) FindNotTotal() ([]*JobType, error) { |
| | | func (slf *OperationTypeSearch) FindNotTotal() ([]*OperationType, error) { |
| | | var ( |
| | | records = make([]*JobType, 0) |
| | | records = make([]*OperationType, 0) |
| | | db = slf.build() |
| | | ) |
| | | |
| | |
| | | } |
| | | |
| | | // FindByQuery 指定条件查询. |
| | | func (slf *JobTypeSearch) FindByQuery(query string, args []interface{}) ([]*JobType, int64, error) { |
| | | func (slf *OperationTypeSearch) FindByQuery(query string, args []interface{}) ([]*OperationType, int64, error) { |
| | | var ( |
| | | records = make([]*JobType, 0) |
| | | records = make([]*OperationType, 0) |
| | | total int64 |
| | | db = slf.Orm.Table(slf.TableName()).Where(query, args...) |
| | | ) |
| | |
| | | } |
| | | |
| | | // FindByQueryNotTotal 指定条件查询&不查询总条数. |
| | | func (slf *JobTypeSearch) FindByQueryNotTotal(query string, args []interface{}) ([]*JobType, error) { |
| | | func (slf *OperationTypeSearch) FindByQueryNotTotal(query string, args []interface{}) ([]*OperationType, error) { |
| | | var ( |
| | | records = make([]*JobType, 0) |
| | | records = make([]*OperationType, 0) |
| | | db = slf.Orm.Table(slf.TableName()).Where(query, args...) |
| | | ) |
| | | |