SunYF
1cc93795ce
- 在main.go中添加定时任务每10分钟同步可生产数量到WMS系统 - 为BomItem实体添加relatedStandard字段及相关CRUD方法 - 为InspectionRecord实体添加reportNo、materialCode、materialName等字段 - 更新ent schema确保新字段的验证和默认值设置 - 添加必要的数据库迁移和字段映射逻辑
257 lines
8.9 KiB
Go
257 lines
8.9 KiB
Go
// Code generated by ent, DO NOT EDIT.
|
|
|
|
package ent
|
|
|
|
import (
|
|
"bj_power_mes/ent/bomitem"
|
|
"encoding/json"
|
|
"fmt"
|
|
"strings"
|
|
"time"
|
|
|
|
"entgo.io/ent"
|
|
"entgo.io/ent/dialect/sql"
|
|
)
|
|
|
|
// BomItem is the model entity for the BomItem schema.
|
|
type BomItem struct {
|
|
config `json:"-"`
|
|
// ID of the ent.
|
|
ID int `json:"id,omitempty"`
|
|
// 产品编码
|
|
ProductCode string `json:"productCode,omitempty"`
|
|
// BOM名称：同一型号多份并存（如 厂家A/厂家B/含半成品），工单按名选用
|
|
BomName string `json:"bomName,omitempty"`
|
|
// 物料编码
|
|
MaterialCode string `json:"materialCode,omitempty"`
|
|
// MaterialName holds the value of the "materialName" field.
|
|
MaterialName string `json:"materialName,omitempty"`
|
|
// Spec holds the value of the "spec" field.
|
|
Spec string `json:"spec,omitempty"`
|
|
// Unit holds the value of the "unit" field.
|
|
Unit string `json:"unit,omitempty"`
|
|
// ManageMode holds the value of the "manageMode" field.
|
|
ManageMode string `json:"manageMode,omitempty"`
|
|
// 装配工序 1~12，0=不参与工位绑定
|
|
ProcessCode int `json:"processCode,omitempty"`
|
|
// 单台用量
|
|
UnitQty float64 `json:"unitQty,omitempty"`
|
|
// 损耗率%
|
|
LossRate float64 `json:"lossRate,omitempty"`
|
|
// 相关标准(检验细则)
|
|
RelatedStandard string `json:"relatedStandard,omitempty"`
|
|
// 需求总量=总台数*单台*(1+损耗)
|
|
RequiredQty float64 `json:"requiredQty,omitempty"`
|
|
// 电气件SN下发列表(可选)
|
|
SerialSns []string `json:"serialSns,omitempty"`
|
|
// CreatedAt holds the value of the "createdAt" field.
|
|
CreatedAt time.Time `json:"createdAt,omitempty"`
|
|
selectValues sql.SelectValues
|
|
}
|
|
|
|
// scanValues returns the types for scanning values from sql.Rows.
|
|
func (*BomItem) scanValues(columns []string) ([]any, error) {
|
|
values := make([]any, len(columns))
|
|
for i := range columns {
|
|
switch columns[i] {
|
|
case bomitem.FieldSerialSns:
|
|
values[i] = new([]byte)
|
|
case bomitem.FieldUnitQty, bomitem.FieldLossRate, bomitem.FieldRequiredQty:
|
|
values[i] = new(sql.NullFloat64)
|
|
case bomitem.FieldID, bomitem.FieldProcessCode:
|
|
values[i] = new(sql.NullInt64)
|
|
case bomitem.FieldProductCode, bomitem.FieldBomName, bomitem.FieldMaterialCode, bomitem.FieldMaterialName, bomitem.FieldSpec, bomitem.FieldUnit, bomitem.FieldManageMode, bomitem.FieldRelatedStandard:
|
|
values[i] = new(sql.NullString)
|
|
case bomitem.FieldCreatedAt:
|
|
values[i] = new(sql.NullTime)
|
|
default:
|
|
values[i] = new(sql.UnknownType)
|
|
}
|
|
}
|
|
return values, nil
|
|
}
|
|
|
|
// assignValues assigns the values that were returned from sql.Rows (after scanning)
|
|
// to the BomItem fields.
|
|
func (_m *BomItem) 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 bomitem.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 bomitem.FieldProductCode:
|
|
if value, ok := values[i].(*sql.NullString); !ok {
|
|
return fmt.Errorf("unexpected type %T for field productCode", values[i])
|
|
} else if value.Valid {
|
|
_m.ProductCode = value.String
|
|
}
|
|
case bomitem.FieldBomName:
|
|
if value, ok := values[i].(*sql.NullString); !ok {
|
|
return fmt.Errorf("unexpected type %T for field bomName", values[i])
|
|
} else if value.Valid {
|
|
_m.BomName = value.String
|
|
}
|
|
case bomitem.FieldMaterialCode:
|
|
if value, ok := values[i].(*sql.NullString); !ok {
|
|
return fmt.Errorf("unexpected type %T for field materialCode", values[i])
|
|
} else if value.Valid {
|
|
_m.MaterialCode = value.String
|
|
}
|
|
case bomitem.FieldMaterialName:
|
|
if value, ok := values[i].(*sql.NullString); !ok {
|
|
return fmt.Errorf("unexpected type %T for field materialName", values[i])
|
|
} else if value.Valid {
|
|
_m.MaterialName = value.String
|
|
}
|
|
case bomitem.FieldSpec:
|
|
if value, ok := values[i].(*sql.NullString); !ok {
|
|
return fmt.Errorf("unexpected type %T for field spec", values[i])
|
|
} else if value.Valid {
|
|
_m.Spec = value.String
|
|
}
|
|
case bomitem.FieldUnit:
|
|
if value, ok := values[i].(*sql.NullString); !ok {
|
|
return fmt.Errorf("unexpected type %T for field unit", values[i])
|
|
} else if value.Valid {
|
|
_m.Unit = value.String
|
|
}
|
|
case bomitem.FieldManageMode:
|
|
if value, ok := values[i].(*sql.NullString); !ok {
|
|
return fmt.Errorf("unexpected type %T for field manageMode", values[i])
|
|
} else if value.Valid {
|
|
_m.ManageMode = value.String
|
|
}
|
|
case bomitem.FieldProcessCode:
|
|
if value, ok := values[i].(*sql.NullInt64); !ok {
|
|
return fmt.Errorf("unexpected type %T for field processCode", values[i])
|
|
} else if value.Valid {
|
|
_m.ProcessCode = int(value.Int64)
|
|
}
|
|
case bomitem.FieldUnitQty:
|
|
if value, ok := values[i].(*sql.NullFloat64); !ok {
|
|
return fmt.Errorf("unexpected type %T for field unitQty", values[i])
|
|
} else if value.Valid {
|
|
_m.UnitQty = value.Float64
|
|
}
|
|
case bomitem.FieldLossRate:
|
|
if value, ok := values[i].(*sql.NullFloat64); !ok {
|
|
return fmt.Errorf("unexpected type %T for field lossRate", values[i])
|
|
} else if value.Valid {
|
|
_m.LossRate = value.Float64
|
|
}
|
|
case bomitem.FieldRelatedStandard:
|
|
if value, ok := values[i].(*sql.NullString); !ok {
|
|
return fmt.Errorf("unexpected type %T for field relatedStandard", values[i])
|
|
} else if value.Valid {
|
|
_m.RelatedStandard = value.String
|
|
}
|
|
case bomitem.FieldRequiredQty:
|
|
if value, ok := values[i].(*sql.NullFloat64); !ok {
|
|
return fmt.Errorf("unexpected type %T for field requiredQty", values[i])
|
|
} else if value.Valid {
|
|
_m.RequiredQty = value.Float64
|
|
}
|
|
case bomitem.FieldSerialSns:
|
|
if value, ok := values[i].(*[]byte); !ok {
|
|
return fmt.Errorf("unexpected type %T for field serialSns", values[i])
|
|
} else if value != nil && len(*value) > 0 {
|
|
if err := json.Unmarshal(*value, &_m.SerialSns); err != nil {
|
|
return fmt.Errorf("unmarshal field serialSns: %w", err)
|
|
}
|
|
}
|
|
case bomitem.FieldCreatedAt:
|
|
if value, ok := values[i].(*sql.NullTime); !ok {
|
|
return fmt.Errorf("unexpected type %T for field createdAt", values[i])
|
|
} else if value.Valid {
|
|
_m.CreatedAt = value.Time
|
|
}
|
|
default:
|
|
_m.selectValues.Set(columns[i], values[i])
|
|
}
|
|
}
|
|
return nil
|
|
}
|
|
|
|
// Value returns the ent.Value that was dynamically selected and assigned to the BomItem.
|
|
// This includes values selected through modifiers, order, etc.
|
|
func (_m *BomItem) Value(name string) (ent.Value, error) {
|
|
return _m.selectValues.Get(name)
|
|
}
|
|
|
|
// Update returns a builder for updating this BomItem.
|
|
// Note that you need to call BomItem.Unwrap() before calling this method if this BomItem
|
|
// was returned from a transaction, and the transaction was committed or rolled back.
|
|
func (_m *BomItem) Update() *BomItemUpdateOne {
|
|
return NewBomItemClient(_m.config).UpdateOne(_m)
|
|
}
|
|
|
|
// Unwrap unwraps the BomItem 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 *BomItem) Unwrap() *BomItem {
|
|
_tx, ok := _m.config.driver.(*txDriver)
|
|
if !ok {
|
|
panic("ent: BomItem is not a transactional entity")
|
|
}
|
|
_m.config.driver = _tx.drv
|
|
return _m
|
|
}
|
|
|
|
// String implements the fmt.Stringer.
|
|
func (_m *BomItem) String() string {
|
|
var builder strings.Builder
|
|
builder.WriteString("BomItem(")
|
|
builder.WriteString(fmt.Sprintf("id=%v, ", _m.ID))
|
|
builder.WriteString("productCode=")
|
|
builder.WriteString(_m.ProductCode)
|
|
builder.WriteString(", ")
|
|
builder.WriteString("bomName=")
|
|
builder.WriteString(_m.BomName)
|
|
builder.WriteString(", ")
|
|
builder.WriteString("materialCode=")
|
|
builder.WriteString(_m.MaterialCode)
|
|
builder.WriteString(", ")
|
|
builder.WriteString("materialName=")
|
|
builder.WriteString(_m.MaterialName)
|
|
builder.WriteString(", ")
|
|
builder.WriteString("spec=")
|
|
builder.WriteString(_m.Spec)
|
|
builder.WriteString(", ")
|
|
builder.WriteString("unit=")
|
|
builder.WriteString(_m.Unit)
|
|
builder.WriteString(", ")
|
|
builder.WriteString("manageMode=")
|
|
builder.WriteString(_m.ManageMode)
|
|
builder.WriteString(", ")
|
|
builder.WriteString("processCode=")
|
|
builder.WriteString(fmt.Sprintf("%v", _m.ProcessCode))
|
|
builder.WriteString(", ")
|
|
builder.WriteString("unitQty=")
|
|
builder.WriteString(fmt.Sprintf("%v", _m.UnitQty))
|
|
builder.WriteString(", ")
|
|
builder.WriteString("lossRate=")
|
|
builder.WriteString(fmt.Sprintf("%v", _m.LossRate))
|
|
builder.WriteString(", ")
|
|
builder.WriteString("relatedStandard=")
|
|
builder.WriteString(_m.RelatedStandard)
|
|
builder.WriteString(", ")
|
|
builder.WriteString("requiredQty=")
|
|
builder.WriteString(fmt.Sprintf("%v", _m.RequiredQty))
|
|
builder.WriteString(", ")
|
|
builder.WriteString("serialSns=")
|
|
builder.WriteString(fmt.Sprintf("%v", _m.SerialSns))
|
|
builder.WriteString(", ")
|
|
builder.WriteString("createdAt=")
|
|
builder.WriteString(_m.CreatedAt.Format(time.ANSIC))
|
|
builder.WriteByte(')')
|
|
return builder.String()
|
|
}
|
|
|
|
// BomItems is a parsable slice of BomItem.
|
|
type BomItems []*BomItem
|