qdy
/
go-svc-mercury
Sledovat 1
Oblíbit 0
Rozštěpit 0
Zdrojový kód Úkoly 0 Požadavky na natažení 0 Vydání 10 Wiki Activity
Bez popisu
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
5 Revize
1 Větev
Větev: master
Větve Značky
${ item.name }
Create branch ${ searchTerm }
from 'master'
${ noResults }
go-svc-mercury/internal/tables/bill_purchase_plan.go

bill_purchase_plan.go 9.2KB
Trvalý odkaz Historie Surový

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134 
  1. package tables

  2. 

  3. import (

  4. 	"time"

  5. 

  6. 	"git.x2erp.com/qdy/go-db/sqldef"

  7. )

  8. 

  9. func init() {

  10. 	sqldef.AddRegistration(func(r *sqldef.Registry) {

  11. 		tb := sqldef.NewTable("bill_purchase_plan", "采购计划单据表 - 记录商品采购计划信息，用于指导采购活动").

  12. 		ChineseName("采购计划单据表").Aliases("采购计划单据").

  13. 			ID("id", 50).NotNull().Comment("主键ID").ChineseName("主键ID").End().

  14. 			String("bill_id", 50).NotNull().Comment("单据编号").ChineseName("单据编号").End().

  15. 			String("tenant_id", 50).NotNull().Comment("租户ID").ChineseName("租户ID").End().

  16. 			String("bill_type", 20).NotNull().Default("'PURCHASE_PLAN'").Comment("单据类型 (PURCHASE_PLAN采购计划)").ChineseName("单据类型").End().

  17. 			String("bill_status", 20).NotNull().Comment("单据状态 (DRAFT草稿/APPROVED已审核/CONFIRMED已确认/CLOSED已关闭/CANCELLED已取消)").ChineseName("单据状态").End().

  18. 			String("from_store_id", 50).Comment("发货门店ID").ChineseName("发货门店ID").End().

  19. 			String("to_store_id", 50).NotNull().Comment("收货门店ID").ChineseName("收货门店ID").End().

  20. 			String("from_company_id", 50).Comment("发货方公司ID").ChineseName("发货方公司ID").End().

  21. 			String("to_company_id", 50).Comment("收货方公司ID").ChineseName("收货方公司ID").End().

  22. 			String("product_id", 50).NotNull().Comment("商品ID").ChineseName("商品ID").End().

  23. 			String("size_code", 100).Comment("尺寸编码").ChineseName("尺寸编码").End().

  24. 			String("color_code", 100).Comment("颜色编码").ChineseName("颜色编码").End().

  25. 			Decimal("settlement_qty", 12, 4).NotNull().Default("0").Comment("结算数量").ChineseName("结算数量").End().

  26. 			Decimal("settlement_price", 12, 2).NotNull().Default("0").Comment("结算单价").ChineseName("结算单价").End().

  27. 			Decimal("discount_rate", 5, 4).NotNull().Default("0").Comment("折扣率").ChineseName("折扣率").End().

  28. 			Decimal("settlement_amount", 12, 2).NotNull().Default("0").Comment("结算金额").ChineseName("结算金额").End().

  29. 			Date("expected_delivery_date").Comment("预计交货日期").ChineseName("预计交货日期").Aliases("时间").End().

  30. 			String("business_type_id", 50).Comment("业务类型ID").ChineseName("业务类型ID").End().

  31. 			String("business_type_name", 100).Comment("业务类型名称").ChineseName("业务类型名称").End().

  32. 			String("price_type_id", 50).Comment("价格类型ID").ChineseName("价格类型ID").End().

  33. 			String("price_type_name", 100).Comment("价格类型名称").ChineseName("价格类型名称").End().

  34. 			String("finance_type_id", 50).Comment("财务类型ID").ChineseName("财务类型ID").End().

  35. 			String("finance_type_name", 100).Comment("财务类型名称").ChineseName("财务类型名称").End().

  36. 			Int("sure_status").NotNull().Default("0").Comment("登账标识 (0:草稿, 1:已登账)").ChineseName("登账标识").Aliases("ID").End().

  37. 			Date("sure_date").Comment("登账日期").ChineseName("登账日期").Aliases("时间").End().

  38. 			String("remark", 500).Comment("备注").ChineseName("备注").End().

  39. 			String("creator", 32).NotNull().Comment("创建人").ChineseName("创建人").End().

  40. 			DateTime("created_at").NotNull().Default("CURRENT_TIMESTAMP").Comment("创建时间").ChineseName("创建时间").Aliases("时间").End().

  41. 			DateTime("updated_at").NotNull().Default("CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP").Comment("更新时间").ChineseName("更新时间").Aliases("时间").End()

  42. 

  43. 		tb.AddUniqueIndex("idx_bill_id_product", "bill_id", "product_id", "size_code", "color_code")

  44. 		tb.AddIndex("idx_bill_status", "bill_status")

  45. 		tb.AddIndex("idx_from_store_id", "from_store_id")

  46. 		tb.AddIndex("idx_to_store_id", "to_store_id")

  47. 		tb.AddIndex("idx_from_company_id", "from_company_id")

  48. 		tb.AddIndex("idx_to_company_id", "to_company_id")

  49. 		tb.AddIndex("idx_product_id", "product_id")

  50. 

  51. 		tb.AddIndex("idx_sure_status", "sure_status")

  52. 		tb.AddIndex("idx_tenant_id_bill_status", "tenant_id", "bill_status")

  53. 		tb.AddIndex("idx_tenant_id_from_store", "tenant_id", "from_store_id")

  54. 		tb.AddIndex("idx_tenant_id_sure_status", "tenant_id", "sure_status")

  55. 		tb.AddIndex("idx_created_at", "created_at")

  56. 

  57. 		r.RegisterTable(tb.Build())

  58. 	})

  59. }

  60. 

  61. type BillPurchasePlan struct {

  62. 	ID            string `gorm:"column:id;type:varchar(50);not null;primaryKey;comment:主键ID"`

  63. 	BillID        string `gorm:"column:bill_id;type:varchar(50);not null;comment:单据编号"`

  64. 	TenantID      string `gorm:"column:tenant_id;type:varchar(50);not null;comment:租户ID"`

  65. 	BillType      string `gorm:"column:bill_type;type:varchar(20);not null;default:PURCHASE_PLAN;comment:单据类型 (PURCHASE_PLAN采购计划)"`

  66. 	BillStatus    string `gorm:"column:bill_status;type:varchar(20);not null;comment:单据状态 (DRAFT草稿/APPROVED已审核/CONFIRMED已确认/CLOSED已关闭/CANCELLED已取消)"`

  67. 	FromStoreID   string `gorm:"column:from_store_id;type:varchar(50);comment:发货门店ID"`

  68. 	ToStoreID     string `gorm:"column:to_store_id;type:varchar(50);not null;comment:收货门店ID"`

  69. 	FromCompanyID string `gorm:"column:from_company_id;type:varchar(50);comment:发货方公司ID"`

  70. 	ToCompanyID   string `gorm:"column:to_company_id;type:varchar(50);comment:收货方公司ID"`

  71. 	ProductID     string `gorm:"column:product_id;type:varchar(50);not null;comment:商品ID"`

  72. 	SizeCode      string `gorm:"column:size_code;type:varchar(10);comment:尺寸编码"`

  73. 	ColorCode     string `gorm:"column:color_code;type:varchar(10);comment:颜色编码"`

  74. 

  75. 	SettlementQty    float64 `gorm:"column:settlement_qty;type:decimal(12,4);not null;default:0;comment:结算数量"`

  76. 	SettlementPrice  float64 `gorm:"column:settlement_price;type:decimal(12,2);not null;default:0;comment:结算单价"`

  77. 	DiscountRate     float64 `gorm:"column:discount_rate;type:decimal(5,4);not null;default:0;comment:折扣率"`

  78. 	SettlementAmount float64 `gorm:"column:settlement_amount;type:decimal(12,2);not null;default:0;comment:结算金额"`

  79. 

  80. 	ExpectedDeliveryDate *time.Time `gorm:"column:expected_delivery_date;type:date;comment:预计交货日期"`

  81. 

  82. 	BusinessTypeID   string     `gorm:"column:business_type_id;type:varchar(50);comment:业务类型ID"`

  83. 	BusinessTypeName string     `gorm:"column:business_type_name;type:varchar(100);comment:业务类型名称"`

  84. 	PriceTypeID      string     `gorm:"column:price_type_id;type:varchar(50);comment:价格类型ID"`

  85. 	PriceTypeName    string     `gorm:"column:price_type_name;type:varchar(100);comment:价格类型名称"`

  86. 	FinanceTypeID    string     `gorm:"column:finance_type_id;type:varchar(50);comment:财务类型ID"`

  87. 	FinanceTypeName  string     `gorm:"column:finance_type_name;type:varchar(100);comment:财务类型名称"`

  88. 	SureStatus       int32      `gorm:"column:sure_status;type:int;not null;default:0;comment:登账标识 (0:草稿, 1:已登账)"`

  89. 	SureDate         *time.Time `gorm:"column:sure_date;type:date;comment:登账日期"`

  90. 	Remark           string     `gorm:"column:remark;type:varchar(500);comment:备注"`

  91. 	Creator          string     `gorm:"column:creator;type:varchar(32);not null;comment:创建人"`

  92. 	CreatedAt        time.Time  `gorm:"column:created_at;not null;default:CURRENT_TIMESTAMP;comment:创建时间"`

  93. 	UpdatedAt        time.Time  `gorm:"column:updated_at;not null;default:CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP;comment:更新时间"`

  94. }

  95. 

  96. type BillPurchasePlanDB struct {

  97. 	ID            string `db:"id" json:"id"`

  98. 	BillID        string `db:"bill_id" json:"billID"`

  99. 	TenantID      string `db:"tenant_id" json:"tenantID"`

  100. 	BillType      string `db:"bill_type" json:"billType"`

  101. 	BillStatus    string `db:"bill_status" json:"billStatus"`

  102. 	FromStoreID   string `db:"from_store_id" json:"fromStoreID"`

  103. 	ToStoreID     string `db:"to_store_id" json:"toStoreID"`

  104. 	FromCompanyID string `db:"from_company_id" json:"fromCompanyID"`

  105. 	ToCompanyID   string `db:"to_company_id" json:"toCompanyID"`

  106. 

  107. 	ProductID string `db:"product_id" json:"productID"`

  108. 

  109. 	SizeCode         string  `db:"size_code" json:"sizeCode"`

  110. 	ColorCode        string  `db:"color_code" json:"colorCode"`

  111. 	SettlementQty    float64 `db:"settlement_qty" json:"settlementQty"`

  112. 	SettlementPrice  float64 `db:"settlement_price" json:"settlementPrice"`

  113. 	DiscountRate     float64 `db:"discount_rate" json:"discountRate"`

  114. 	SettlementAmount float64 `db:"settlement_amount" json:"settlementAmount"`

  115. 

  116. 	ExpectedDeliveryDate *time.Time `db:"expected_delivery_date" json:"expectedDeliveryDate"`

  117. 

  118. 	BusinessTypeID   string     `db:"business_type_id" json:"businessTypeID"`

  119. 	BusinessTypeName string     `db:"business_type_name" json:"businessTypeName"`

  120. 	PriceTypeID      string     `db:"price_type_id" json:"priceTypeID"`

  121. 	PriceTypeName    string     `db:"price_type_name" json:"priceTypeName"`

  122. 	FinanceTypeID    string     `db:"finance_type_id" json:"financeTypeID"`

  123. 	FinanceTypeName  string     `db:"finance_type_name" json:"financeTypeName"`

  124. 	SureStatus       int32      `db:"sure_status" json:"sureStatus"`

  125. 	SureDate         *time.Time `db:"sure_date" json:"sureDate"`

  126. 	Remark           string     `db:"remark" json:"remark"`

  127. 	Creator          string     `db:"creator" json:"creator"`

  128. 	CreatedAt        time.Time  `db:"created_at" json:"createdAt"`

  129. 	UpdatedAt        time.Time  `db:"updated_at" json:"updatedAt"`

  130. }

  131. 

  132. func (BillPurchasePlan) TableName() string {

  133. 	return "bill_purchase_plan"

  134. }