models

type BaseModel struct {
	CreateTime string `json:"create_time,omitempty" db:"create_time" gorm:"column:create_time;default:CURRENT_TIMESTAMP;autoCreateTime"` //创建时间
	CreateId   uint64 `json:"create_id,omitempty" db:"create_id" gorm:"column:create_id"`                                                //创建人ID
	CreateName string `json:"create_name,omitempty" db:"create_name" gorm:"column:create_name"`                                          //创建人姓名
	UpdateId   uint64 `json:"update_id,omitempty" db:"update_id" gorm:"column:update_id"`                                                //更新人ID
	UpdateName string `json:"update_name,omitempty" db:"update_name" gorm:"column:update_name"`                                          //更新人姓名
	UpdateTime string `json:"update_time,omitempty" db:"update_time" gorm:"column:update_time;default:CURRENT_TIMESTAMP;autoUpdateTime"` //更新时间
}

type FrozenState int

type InventoryData struct {
	BaseModel
	Id           uint64            `json:"id,omitempty" db:"id" gorm:"column:id;primaryKey;autoIncrement"`                        //产品ID
	IsFrozen     FrozenState       `json:"is_frozen,omitempty" db:"is_frozen" gorm:"column:is_frozen"`                            //冻结状态(0: 未冻结 1: 已冻结)
	Name         string            `json:"name,omitempty" db:"name" gorm:"column:name"`                                           //产品名称
	SerialNo     string            `json:"serial_no,omitempty" db:"serial_no" gorm:"column:serial_no"`                            //产品编号
	Quantity     float64           `json:"quantity,omitempty" db:"quantity" gorm:"column:quantity"`                               //产品库存
	Price        *float64          `json:"price,omitempty" db:"price" gorm:"column:price"`                                        //产品均价
	ProductExtra *ProductExtraData `json:"product_extra,omitempty" db:"product_extra" gorm:"column:product_extra" sqlca:"isnull"` //产品附带数据(JSON文本)
	Location     sqlca.Point       `json:"location,omitempty" db:"location" gorm:"column:location" sqlca:"isnull"`                //地理位置
}

type InventoryIn struct {
	BaseModel
	Id         uint64        `json:"id,omitempty" db:"id" gorm:"column:id;primaryKey;autoIncrement"`                  //主键ID
	IsDeleted  int8          `json:"is_deleted,omitempty" db:"is_deleted" gorm:"column:is_deleted"`                   //删除状态(0: 未删除 1: 已删除)
	DeleteTime string        `json:"delete_time,omitempty" db:"delete_time" gorm:"column:delete_time" sqlca:"isnull"` //删除时间
	ProductId  uint64        `json:"product_id,omitempty" db:"product_id" gorm:"column:product_id"`                   //产品ID
	OrderNo    string        `json:"order_no,omitempty" db:"order_no" gorm:"column:order_no"`                         //入库单号
	UserId     uint64        `json:"user_id,omitempty" db:"user_id" gorm:"column:user_id"`                            //交货人ID
	UserName   string        `json:"user_name,omitempty" db:"user_name" gorm:"column:user_name"`                      //交货人姓名
	Quantity   float64       `json:"quantity,omitempty" db:"quantity" gorm:"column:quantity"`                         //数量
	Weight     sqlca.Decimal `json:"weight,omitempty" db:"weight" gorm:"column:weight"`                               //净重
	Remark     string        `json:"remark,omitempty" db:"remark" gorm:"column:remark"`                               //备注
}

type InventoryOut struct {
	BaseModel
	Id         uint64        `json:"id,omitempty" db:"id" gorm:"column:id;primaryKey;autoIncrement"`                  //主键ID
	IsDeleted  int8          `json:"is_deleted,omitempty" db:"is_deleted" gorm:"column:is_deleted"`                   //删除状态(0: 未删除 1: 已删除)
	DeleteTime string        `json:"delete_time,omitempty" db:"delete_time" gorm:"column:delete_time" sqlca:"isnull"` //删除时间
	ProductId  uint64        `json:"product_id,omitempty" db:"product_id" gorm:"column:product_id"`                   //产品ID
	OrderNo    string        `json:"order_no,omitempty" db:"order_no" gorm:"column:order_no"`                         //出库单号
	UserId     uint64        `json:"user_id,omitempty" db:"user_id" gorm:"column:user_id"`                            //收货人ID
	UserName   string        `json:"user_name,omitempty" db:"user_name" gorm:"column:user_name"`                      //收货人姓名
	Quantity   float64       `json:"quantity,omitempty" db:"quantity" gorm:"column:quantity"`                         //数量
	Weight     sqlca.Decimal `json:"weight,omitempty" db:"weight" gorm:"column:weight"`                               //净重
	Remark     string        `json:"remark,omitempty" db:"remark" gorm:"column:remark"`                               //备注
}

type ProductExtraData struct {
	AvgPrice   sqlca.Decimal `json:"avg_price"`   //均价
	SpecsValue string        `json:"specs_value"` //规格
}