SunYF
1cc93795ce
- 在main.go中添加定时任务每10分钟同步可生产数量到WMS系统 - 为BomItem实体添加relatedStandard字段及相关CRUD方法 - 为InspectionRecord实体添加reportNo、materialCode、materialName等字段 - 更新ent schema确保新字段的验证和默认值设置 - 添加必要的数据库迁移和字段映射逻辑
423 lines
16 KiB
Go
423 lines
16 KiB
Go
// Code generated by ent, DO NOT EDIT.
|
|
|
|
package ent
|
|
|
|
import (
|
|
"bj_power_wms/ent/inventory"
|
|
"fmt"
|
|
"strings"
|
|
|
|
"entgo.io/ent"
|
|
"entgo.io/ent/dialect/sql"
|
|
)
|
|
|
|
// Inventory is the model entity for the Inventory schema.
|
|
type Inventory struct {
|
|
config `json:"-"`
|
|
// ID of the ent.
|
|
ID int `json:"id,omitempty"`
|
|
// 管理粒度 1=结构件(批次) 2=电气件(SN)
|
|
ManageMode int `json:"manageMode,omitempty"`
|
|
// 品类 1=原材料 2=半成品 3=成品
|
|
Category int `json:"category,omitempty"`
|
|
// 物料编码(关联 materials 表)
|
|
MaterialCode string `json:"materialCode,omitempty"`
|
|
// 物料名称(冗余，便于直接展示)
|
|
MaterialName string `json:"materialName,omitempty"`
|
|
// 批次号(系统生成)；电气件可关联所属批次
|
|
BatchNo string `json:"batchNo,omitempty"`
|
|
// 序列号(SN，仅电气件)；全局唯一，空值表示非 SN 行
|
|
SnCode string `json:"snCode,omitempty"`
|
|
// 数量：结构件=批次余量；电气件=1
|
|
Quantity int `json:"quantity,omitempty"`
|
|
// 已锁定数量(库存占用)：结构件=件数；电气件=0/1
|
|
LockedQty int `json:"lockedQty,omitempty"`
|
|
// 检验状态 未检/合格/不合格
|
|
QualityStatus string `json:"qualityStatus,omitempty"`
|
|
// 所在区域(Z01~Z04 大分区)
|
|
ZoneCode string `json:"zoneCode,omitempty"`
|
|
// 货架号(手填，如 A)
|
|
ShelfNo string `json:"shelfNo,omitempty"`
|
|
// 第几层(手填，如 3)
|
|
LayerNo string `json:"layerNo,omitempty"`
|
|
// 位置号(手填，如 12)
|
|
PositionNo string `json:"positionNo,omitempty"`
|
|
// 生命周期：在库/锁定/出库/使用/报废(电气件用；结构件恒在库)
|
|
Status string `json:"status,omitempty"`
|
|
// 生产日期
|
|
ProductionDate string `json:"productionDate,omitempty"`
|
|
// 供应商
|
|
Supplier string `json:"supplier,omitempty"`
|
|
// 关联入库单号
|
|
InboundNo string `json:"inboundNo,omitempty"`
|
|
// 关联工单号(半成品/成品回流)
|
|
OrderNo string `json:"orderNo,omitempty"`
|
|
// 已完成工序(半成品用，如 135)
|
|
CompletedProcess string `json:"completedProcess,omitempty"`
|
|
// 归属类型 workorder/project/other
|
|
OwnershipType string `json:"ownershipType,omitempty"`
|
|
// 归属编号(工单号/科技项目号/其他)
|
|
OwnershipNo string `json:"ownershipNo,omitempty"`
|
|
// 产品状态 已通过/部分通过/返修(成品用)
|
|
ProductStatus string `json:"productStatus,omitempty"`
|
|
// 相关标准(试验方案号)
|
|
RelatedStandard string `json:"relatedStandard,omitempty"`
|
|
// 试验记录单号
|
|
TestRecordNo string `json:"testRecordNo,omitempty"`
|
|
// 记录员
|
|
RecordedBy string `json:"recordedBy,omitempty"`
|
|
// 记录日期(unix 秒)
|
|
RecordedAt int64 `json:"recordedAt,omitempty"`
|
|
// 出库原因(半成品/成品出库用)
|
|
OutboundReason string `json:"outboundReason,omitempty"`
|
|
// 备注
|
|
Remark string `json:"remark,omitempty"`
|
|
// CreatedAt holds the value of the "created_at" field.
|
|
CreatedAt int64 `json:"createdAt,omitempty"`
|
|
// UpdatedAt holds the value of the "updated_at" field.
|
|
UpdatedAt int64 `json:"updatedAt,omitempty"`
|
|
selectValues sql.SelectValues
|
|
}
|
|
|
|
// scanValues returns the types for scanning values from sql.Rows.
|
|
func (*Inventory) scanValues(columns []string) ([]any, error) {
|
|
values := make([]any, len(columns))
|
|
for i := range columns {
|
|
switch columns[i] {
|
|
case inventory.FieldID, inventory.FieldManageMode, inventory.FieldCategory, inventory.FieldQuantity, inventory.FieldLockedQty, inventory.FieldRecordedAt, inventory.FieldCreatedAt, inventory.FieldUpdatedAt:
|
|
values[i] = new(sql.NullInt64)
|
|
case inventory.FieldMaterialCode, inventory.FieldMaterialName, inventory.FieldBatchNo, inventory.FieldSnCode, inventory.FieldQualityStatus, inventory.FieldZoneCode, inventory.FieldShelfNo, inventory.FieldLayerNo, inventory.FieldPositionNo, inventory.FieldStatus, inventory.FieldProductionDate, inventory.FieldSupplier, inventory.FieldInboundNo, inventory.FieldOrderNo, inventory.FieldCompletedProcess, inventory.FieldOwnershipType, inventory.FieldOwnershipNo, inventory.FieldProductStatus, inventory.FieldRelatedStandard, inventory.FieldTestRecordNo, inventory.FieldRecordedBy, inventory.FieldOutboundReason, inventory.FieldRemark:
|
|
values[i] = new(sql.NullString)
|
|
default:
|
|
values[i] = new(sql.UnknownType)
|
|
}
|
|
}
|
|
return values, nil
|
|
}
|
|
|
|
// assignValues assigns the values that were returned from sql.Rows (after scanning)
|
|
// to the Inventory fields.
|
|
func (_m *Inventory) assignValues(columns []string, values []any) error {
|
|
if m, n := len(values), len(columns); m < n {
|
|
return fmt.Errorf("mismatch number of scan values: %d != %d", m, n)
|
|
}
|
|
for i := range columns {
|
|
switch columns[i] {
|
|
case inventory.FieldID:
|
|
value, ok := values[i].(*sql.NullInt64)
|
|
if !ok {
|
|
return fmt.Errorf("unexpected type %T for field id", value)
|
|
}
|
|
_m.ID = int(value.Int64)
|
|
case inventory.FieldManageMode:
|
|
if value, ok := values[i].(*sql.NullInt64); !ok {
|
|
return fmt.Errorf("unexpected type %T for field manage_mode", values[i])
|
|
} else if value.Valid {
|
|
_m.ManageMode = int(value.Int64)
|
|
}
|
|
case inventory.FieldCategory:
|
|
if value, ok := values[i].(*sql.NullInt64); !ok {
|
|
return fmt.Errorf("unexpected type %T for field category", values[i])
|
|
} else if value.Valid {
|
|
_m.Category = int(value.Int64)
|
|
}
|
|
case inventory.FieldMaterialCode:
|
|
if value, ok := values[i].(*sql.NullString); !ok {
|
|
return fmt.Errorf("unexpected type %T for field material_code", values[i])
|
|
} else if value.Valid {
|
|
_m.MaterialCode = value.String
|
|
}
|
|
case inventory.FieldMaterialName:
|
|
if value, ok := values[i].(*sql.NullString); !ok {
|
|
return fmt.Errorf("unexpected type %T for field material_name", values[i])
|
|
} else if value.Valid {
|
|
_m.MaterialName = value.String
|
|
}
|
|
case inventory.FieldBatchNo:
|
|
if value, ok := values[i].(*sql.NullString); !ok {
|
|
return fmt.Errorf("unexpected type %T for field batch_no", values[i])
|
|
} else if value.Valid {
|
|
_m.BatchNo = value.String
|
|
}
|
|
case inventory.FieldSnCode:
|
|
if value, ok := values[i].(*sql.NullString); !ok {
|
|
return fmt.Errorf("unexpected type %T for field sn_code", values[i])
|
|
} else if value.Valid {
|
|
_m.SnCode = value.String
|
|
}
|
|
case inventory.FieldQuantity:
|
|
if value, ok := values[i].(*sql.NullInt64); !ok {
|
|
return fmt.Errorf("unexpected type %T for field quantity", values[i])
|
|
} else if value.Valid {
|
|
_m.Quantity = int(value.Int64)
|
|
}
|
|
case inventory.FieldLockedQty:
|
|
if value, ok := values[i].(*sql.NullInt64); !ok {
|
|
return fmt.Errorf("unexpected type %T for field locked_qty", values[i])
|
|
} else if value.Valid {
|
|
_m.LockedQty = int(value.Int64)
|
|
}
|
|
case inventory.FieldQualityStatus:
|
|
if value, ok := values[i].(*sql.NullString); !ok {
|
|
return fmt.Errorf("unexpected type %T for field quality_status", values[i])
|
|
} else if value.Valid {
|
|
_m.QualityStatus = value.String
|
|
}
|
|
case inventory.FieldZoneCode:
|
|
if value, ok := values[i].(*sql.NullString); !ok {
|
|
return fmt.Errorf("unexpected type %T for field zone_code", values[i])
|
|
} else if value.Valid {
|
|
_m.ZoneCode = value.String
|
|
}
|
|
case inventory.FieldShelfNo:
|
|
if value, ok := values[i].(*sql.NullString); !ok {
|
|
return fmt.Errorf("unexpected type %T for field shelf_no", values[i])
|
|
} else if value.Valid {
|
|
_m.ShelfNo = value.String
|
|
}
|
|
case inventory.FieldLayerNo:
|
|
if value, ok := values[i].(*sql.NullString); !ok {
|
|
return fmt.Errorf("unexpected type %T for field layer_no", values[i])
|
|
} else if value.Valid {
|
|
_m.LayerNo = value.String
|
|
}
|
|
case inventory.FieldPositionNo:
|
|
if value, ok := values[i].(*sql.NullString); !ok {
|
|
return fmt.Errorf("unexpected type %T for field position_no", values[i])
|
|
} else if value.Valid {
|
|
_m.PositionNo = value.String
|
|
}
|
|
case inventory.FieldStatus:
|
|
if value, ok := values[i].(*sql.NullString); !ok {
|
|
return fmt.Errorf("unexpected type %T for field status", values[i])
|
|
} else if value.Valid {
|
|
_m.Status = value.String
|
|
}
|
|
case inventory.FieldProductionDate:
|
|
if value, ok := values[i].(*sql.NullString); !ok {
|
|
return fmt.Errorf("unexpected type %T for field production_date", values[i])
|
|
} else if value.Valid {
|
|
_m.ProductionDate = value.String
|
|
}
|
|
case inventory.FieldSupplier:
|
|
if value, ok := values[i].(*sql.NullString); !ok {
|
|
return fmt.Errorf("unexpected type %T for field supplier", values[i])
|
|
} else if value.Valid {
|
|
_m.Supplier = value.String
|
|
}
|
|
case inventory.FieldInboundNo:
|
|
if value, ok := values[i].(*sql.NullString); !ok {
|
|
return fmt.Errorf("unexpected type %T for field inbound_no", values[i])
|
|
} else if value.Valid {
|
|
_m.InboundNo = value.String
|
|
}
|
|
case inventory.FieldOrderNo:
|
|
if value, ok := values[i].(*sql.NullString); !ok {
|
|
return fmt.Errorf("unexpected type %T for field order_no", values[i])
|
|
} else if value.Valid {
|
|
_m.OrderNo = value.String
|
|
}
|
|
case inventory.FieldCompletedProcess:
|
|
if value, ok := values[i].(*sql.NullString); !ok {
|
|
return fmt.Errorf("unexpected type %T for field completed_process", values[i])
|
|
} else if value.Valid {
|
|
_m.CompletedProcess = value.String
|
|
}
|
|
case inventory.FieldOwnershipType:
|
|
if value, ok := values[i].(*sql.NullString); !ok {
|
|
return fmt.Errorf("unexpected type %T for field ownership_type", values[i])
|
|
} else if value.Valid {
|
|
_m.OwnershipType = value.String
|
|
}
|
|
case inventory.FieldOwnershipNo:
|
|
if value, ok := values[i].(*sql.NullString); !ok {
|
|
return fmt.Errorf("unexpected type %T for field ownership_no", values[i])
|
|
} else if value.Valid {
|
|
_m.OwnershipNo = value.String
|
|
}
|
|
case inventory.FieldProductStatus:
|
|
if value, ok := values[i].(*sql.NullString); !ok {
|
|
return fmt.Errorf("unexpected type %T for field product_status", values[i])
|
|
} else if value.Valid {
|
|
_m.ProductStatus = value.String
|
|
}
|
|
case inventory.FieldRelatedStandard:
|
|
if value, ok := values[i].(*sql.NullString); !ok {
|
|
return fmt.Errorf("unexpected type %T for field related_standard", values[i])
|
|
} else if value.Valid {
|
|
_m.RelatedStandard = value.String
|
|
}
|
|
case inventory.FieldTestRecordNo:
|
|
if value, ok := values[i].(*sql.NullString); !ok {
|
|
return fmt.Errorf("unexpected type %T for field test_record_no", values[i])
|
|
} else if value.Valid {
|
|
_m.TestRecordNo = value.String
|
|
}
|
|
case inventory.FieldRecordedBy:
|
|
if value, ok := values[i].(*sql.NullString); !ok {
|
|
return fmt.Errorf("unexpected type %T for field recorded_by", values[i])
|
|
} else if value.Valid {
|
|
_m.RecordedBy = value.String
|
|
}
|
|
case inventory.FieldRecordedAt:
|
|
if value, ok := values[i].(*sql.NullInt64); !ok {
|
|
return fmt.Errorf("unexpected type %T for field recorded_at", values[i])
|
|
} else if value.Valid {
|
|
_m.RecordedAt = value.Int64
|
|
}
|
|
case inventory.FieldOutboundReason:
|
|
if value, ok := values[i].(*sql.NullString); !ok {
|
|
return fmt.Errorf("unexpected type %T for field outbound_reason", values[i])
|
|
} else if value.Valid {
|
|
_m.OutboundReason = value.String
|
|
}
|
|
case inventory.FieldRemark:
|
|
if value, ok := values[i].(*sql.NullString); !ok {
|
|
return fmt.Errorf("unexpected type %T for field remark", values[i])
|
|
} else if value.Valid {
|
|
_m.Remark = value.String
|
|
}
|
|
case inventory.FieldCreatedAt:
|
|
if value, ok := values[i].(*sql.NullInt64); !ok {
|
|
return fmt.Errorf("unexpected type %T for field created_at", values[i])
|
|
} else if value.Valid {
|
|
_m.CreatedAt = value.Int64
|
|
}
|
|
case inventory.FieldUpdatedAt:
|
|
if value, ok := values[i].(*sql.NullInt64); !ok {
|
|
return fmt.Errorf("unexpected type %T for field updated_at", values[i])
|
|
} else if value.Valid {
|
|
_m.UpdatedAt = value.Int64
|
|
}
|
|
default:
|
|
_m.selectValues.Set(columns[i], values[i])
|
|
}
|
|
}
|
|
return nil
|
|
}
|
|
|
|
// Value returns the ent.Value that was dynamically selected and assigned to the Inventory.
|
|
// This includes values selected through modifiers, order, etc.
|
|
func (_m *Inventory) Value(name string) (ent.Value, error) {
|
|
return _m.selectValues.Get(name)
|
|
}
|
|
|
|
// Update returns a builder for updating this Inventory.
|
|
// Note that you need to call Inventory.Unwrap() before calling this method if this Inventory
|
|
// was returned from a transaction, and the transaction was committed or rolled back.
|
|
func (_m *Inventory) Update() *InventoryUpdateOne {
|
|
return NewInventoryClient(_m.config).UpdateOne(_m)
|
|
}
|
|
|
|
// Unwrap unwraps the Inventory entity that was returned from a transaction after it was closed,
|
|
// so that all future queries will be executed through the driver which created the transaction.
|
|
func (_m *Inventory) Unwrap() *Inventory {
|
|
_tx, ok := _m.config.driver.(*txDriver)
|
|
if !ok {
|
|
panic("ent: Inventory is not a transactional entity")
|
|
}
|
|
_m.config.driver = _tx.drv
|
|
return _m
|
|
}
|
|
|
|
// String implements the fmt.Stringer.
|
|
func (_m *Inventory) String() string {
|
|
var builder strings.Builder
|
|
builder.WriteString("Inventory(")
|
|
builder.WriteString(fmt.Sprintf("id=%v, ", _m.ID))
|
|
builder.WriteString("manage_mode=")
|
|
builder.WriteString(fmt.Sprintf("%v", _m.ManageMode))
|
|
builder.WriteString(", ")
|
|
builder.WriteString("category=")
|
|
builder.WriteString(fmt.Sprintf("%v", _m.Category))
|
|
builder.WriteString(", ")
|
|
builder.WriteString("material_code=")
|
|
builder.WriteString(_m.MaterialCode)
|
|
builder.WriteString(", ")
|
|
builder.WriteString("material_name=")
|
|
builder.WriteString(_m.MaterialName)
|
|
builder.WriteString(", ")
|
|
builder.WriteString("batch_no=")
|
|
builder.WriteString(_m.BatchNo)
|
|
builder.WriteString(", ")
|
|
builder.WriteString("sn_code=")
|
|
builder.WriteString(_m.SnCode)
|
|
builder.WriteString(", ")
|
|
builder.WriteString("quantity=")
|
|
builder.WriteString(fmt.Sprintf("%v", _m.Quantity))
|
|
builder.WriteString(", ")
|
|
builder.WriteString("locked_qty=")
|
|
builder.WriteString(fmt.Sprintf("%v", _m.LockedQty))
|
|
builder.WriteString(", ")
|
|
builder.WriteString("quality_status=")
|
|
builder.WriteString(_m.QualityStatus)
|
|
builder.WriteString(", ")
|
|
builder.WriteString("zone_code=")
|
|
builder.WriteString(_m.ZoneCode)
|
|
builder.WriteString(", ")
|
|
builder.WriteString("shelf_no=")
|
|
builder.WriteString(_m.ShelfNo)
|
|
builder.WriteString(", ")
|
|
builder.WriteString("layer_no=")
|
|
builder.WriteString(_m.LayerNo)
|
|
builder.WriteString(", ")
|
|
builder.WriteString("position_no=")
|
|
builder.WriteString(_m.PositionNo)
|
|
builder.WriteString(", ")
|
|
builder.WriteString("status=")
|
|
builder.WriteString(_m.Status)
|
|
builder.WriteString(", ")
|
|
builder.WriteString("production_date=")
|
|
builder.WriteString(_m.ProductionDate)
|
|
builder.WriteString(", ")
|
|
builder.WriteString("supplier=")
|
|
builder.WriteString(_m.Supplier)
|
|
builder.WriteString(", ")
|
|
builder.WriteString("inbound_no=")
|
|
builder.WriteString(_m.InboundNo)
|
|
builder.WriteString(", ")
|
|
builder.WriteString("order_no=")
|
|
builder.WriteString(_m.OrderNo)
|
|
builder.WriteString(", ")
|
|
builder.WriteString("completed_process=")
|
|
builder.WriteString(_m.CompletedProcess)
|
|
builder.WriteString(", ")
|
|
builder.WriteString("ownership_type=")
|
|
builder.WriteString(_m.OwnershipType)
|
|
builder.WriteString(", ")
|
|
builder.WriteString("ownership_no=")
|
|
builder.WriteString(_m.OwnershipNo)
|
|
builder.WriteString(", ")
|
|
builder.WriteString("product_status=")
|
|
builder.WriteString(_m.ProductStatus)
|
|
builder.WriteString(", ")
|
|
builder.WriteString("related_standard=")
|
|
builder.WriteString(_m.RelatedStandard)
|
|
builder.WriteString(", ")
|
|
builder.WriteString("test_record_no=")
|
|
builder.WriteString(_m.TestRecordNo)
|
|
builder.WriteString(", ")
|
|
builder.WriteString("recorded_by=")
|
|
builder.WriteString(_m.RecordedBy)
|
|
builder.WriteString(", ")
|
|
builder.WriteString("recorded_at=")
|
|
builder.WriteString(fmt.Sprintf("%v", _m.RecordedAt))
|
|
builder.WriteString(", ")
|
|
builder.WriteString("outbound_reason=")
|
|
builder.WriteString(_m.OutboundReason)
|
|
builder.WriteString(", ")
|
|
builder.WriteString("remark=")
|
|
builder.WriteString(_m.Remark)
|
|
builder.WriteString(", ")
|
|
builder.WriteString("created_at=")
|
|
builder.WriteString(fmt.Sprintf("%v", _m.CreatedAt))
|
|
builder.WriteString(", ")
|
|
builder.WriteString("updated_at=")
|
|
builder.WriteString(fmt.Sprintf("%v", _m.UpdatedAt))
|
|
builder.WriteByte(')')
|
|
return builder.String()
|
|
}
|
|
|
|
// Inventories is a parsable slice of Inventory.
|
|
type Inventories []*Inventory
|