Documentation
¶
Index ¶
- type ExpiredEnvelopeDomain
- type RedEnvelopeGoods
- type RedEnvelopeGoodsDao
- func (dao *RedEnvelopeGoodsDao) Find(po *RedEnvelopeGoods, offset, limit int) []RedEnvelopeGoods
- func (dao *RedEnvelopeGoodsDao) FindByUser(userId string, offset, limit int) []RedEnvelopeGoods
- func (dao *RedEnvelopeGoodsDao) FindExpired(offset, size int) []RedEnvelopeGoods
- func (dao *RedEnvelopeGoodsDao) GetOne(envelopeNo string) *RedEnvelopeGoods
- func (dao *RedEnvelopeGoodsDao) Insert(po *RedEnvelopeGoods) (int64, error)
- func (dao *RedEnvelopeGoodsDao) ListReceivable(offset, size int) []RedEnvelopeGoods
- func (dao *RedEnvelopeGoodsDao) UpdateBalance(envelopeNo string, amount decimal.Decimal) (int64, error)
- func (dao *RedEnvelopeGoodsDao) UpdateOrderStatus(envelopeNo string, status services.OrderStatus) (int64, error)
- type RedEnvelopeItem
- type RedEnvelopeItemDao
- func (dao *RedEnvelopeItemDao) FindItems(envelopeNo string) []*RedEnvelopeItem
- func (dao *RedEnvelopeItemDao) GetByUser(envelopeNo, userId string) *RedEnvelopeItem
- func (dao *RedEnvelopeItemDao) GetOne(itemNo string) *RedEnvelopeItem
- func (dao *RedEnvelopeItemDao) Insert(data *RedEnvelopeItem) (int64, error)
- func (dao *RedEnvelopeItemDao) ListReceivedItems(userId string, offset, limit int) []*RedEnvelopeItem
Constants ¶
This section is empty.
Variables ¶
This section is empty.
Functions ¶
This section is empty.
Types ¶
type ExpiredEnvelopeDomain ¶
type ExpiredEnvelopeDomain struct {
// contains filtered or unexported fields
}
func (*ExpiredEnvelopeDomain) Expired ¶
func (e *ExpiredEnvelopeDomain) Expired() (err error)
func (*ExpiredEnvelopeDomain) ExpiredOne ¶
func (e *ExpiredEnvelopeDomain) ExpiredOne(goods RedEnvelopeGoods) (err error)
针对1个红包 发起1个退款流程
type RedEnvelopeGoods ¶
type RedEnvelopeGoods struct {
Id int64 `db:"id,omitempty"`
EnvelopeNo string `db:"envelope_no,unique"`
EnvelopeType int `db:"envelope_type"`
Username sql.NullString `db:"username"`
UserId string `db:"user_id"`
Blessing sql.NullString `db:"blessing"`
Amount decimal.Decimal `db:"amount"`
AmountOne decimal.Decimal `db:"amount_one"`
Quantity int `db:"quantity"`
RemainAmount decimal.Decimal `db:"remain_amount"`
RemainQuantity int `db:"remain_quantity"`
ExpiredAt time.Time `db:"expired_at"`
Status services.OrderStatus `db:"status"`
OrderType services.OrderType `db:"order_type"`
PayStatus services.PayStatus `db:"pay_status"`
CreatedAt time.Time `db:"created_at,omitempty"`
UpdatedAt time.Time `db:"updated_at,omitempty"`
OriginEnvelopeNo string `db:"origin_envelope_no"` // 原关联订单号
}
红包商品 映射 red_envelope_goods 表 dbx的ORM映射tag是 `db`
func (*RedEnvelopeGoods) FromDTO ¶
func (po *RedEnvelopeGoods) FromDTO(dto *services.RedEnvelopeGoodsDTO)
func (*RedEnvelopeGoods) ToDTO ¶
func (po *RedEnvelopeGoods) ToDTO() *services.RedEnvelopeGoodsDTO
type RedEnvelopeGoodsDao ¶
type RedEnvelopeGoodsDao struct {
// contains filtered or unexported fields
}
func (*RedEnvelopeGoodsDao) Find ¶
func (dao *RedEnvelopeGoodsDao) Find(po *RedEnvelopeGoods, offset, limit int) []RedEnvelopeGoods
func (*RedEnvelopeGoodsDao) FindByUser ¶
func (dao *RedEnvelopeGoodsDao) FindByUser(userId string, offset, limit int) []RedEnvelopeGoods
func (*RedEnvelopeGoodsDao) FindExpired ¶
func (dao *RedEnvelopeGoodsDao) FindExpired(offset, size int) []RedEnvelopeGoods
过期 把所有的过期红包都查询出来 分页 limit offset size
func (*RedEnvelopeGoodsDao) GetOne ¶
func (dao *RedEnvelopeGoodsDao) GetOne(envelopeNo string) *RedEnvelopeGoods
根据红包编号查询红包商品
func (*RedEnvelopeGoodsDao) Insert ¶
func (dao *RedEnvelopeGoodsDao) Insert(po *RedEnvelopeGoods) (int64, error)
插入 返回红包商品id
func (*RedEnvelopeGoodsDao) ListReceivable ¶
func (dao *RedEnvelopeGoodsDao) ListReceivable(offset, size int) []RedEnvelopeGoods
func (*RedEnvelopeGoodsDao) UpdateBalance ¶
func (dao *RedEnvelopeGoodsDao) UpdateBalance(envelopeNo string, amount decimal.Decimal) (int64, error)
TODO:NOTICE 更新红包余额和数量 [乐观锁] unsigned 标识 无符号整型 从数据库层面避免写入负数
`remain_amount` decimal(30,6) unsigned not null default '0.000000' comment '红包剩余金额', `remain_quantity` int(10) unsigned not null comment '红包剩余数量', [乐观锁] 核心部分SQL " and remain_quantity > 0 and remain_amount >= CAST(? as DECIMAL(30,6)) " 不再使用事务行锁来更新红包余额和数量,避免锁竞争,避免死锁 改用乐观锁来保证更新操作的安全性 避免 红包金额 剩余数量 负库存问题 通过where子句来判断红包剩余金额和数量来解决2个问题 1.负库存问题 避免红包金额和数量不足时进行扣减 2.减少实际的库存更新 当红包剩余金额和数量不足时不去更新数据库不操作磁盘 过滤掉无效的更新 提高总体性能 在100人的微信群,发个红包,数量10个,如果100人都抢,只有10个人能抢到,过滤掉无效的90次更新数据库操作 整体性能提升 30%
返回 影响行数
func (*RedEnvelopeGoodsDao) UpdateOrderStatus ¶
func (dao *RedEnvelopeGoodsDao) UpdateOrderStatus(envelopeNo string, status services.OrderStatus) (int64, error)
更新订单状态
type RedEnvelopeItem ¶
type RedEnvelopeItem struct {
Id int64 `db:"id,omitempty"` // 自增id
ItemNo string `db:"item_no,unique"` // 红包订单详情编号
EnvelopeNo string `db:"envelope_no"` // 红包编号
RecvUsername sql.NullString `db:"recv_username"` // 接收者用户名
RecvUserId string `db:"recv_user_id"` // 接收者用户id
Amount decimal.Decimal `db:"amount"` // 收到金额
Quantity int `db:"quantity"` // 收到数量
RemainAmount decimal.Decimal `db:"remain_amount"` // 剩余金额
AccountNo string `db:"account_no"` // 红包接收者账户ID
PayStatus int `db:"pay_status"` // 支付状态
Desc string `db:"desc"`
CreatedAt time.Time `db:"created_at,omitempty"` // 创建时间
UpdatedAt time.Time `db:"updated_at,omitempty"` // 修改时间
}
func (*RedEnvelopeItem) FromDTO ¶
func (po *RedEnvelopeItem) FromDTO(dto *services.RedEnvelopeItemDTO)
func (*RedEnvelopeItem) ToDTO ¶
func (po *RedEnvelopeItem) ToDTO() *services.RedEnvelopeItemDTO
type RedEnvelopeItemDao ¶
type RedEnvelopeItemDao struct {
// contains filtered or unexported fields
}
func (*RedEnvelopeItemDao) FindItems ¶
func (dao *RedEnvelopeItemDao) FindItems(envelopeNo string) []*RedEnvelopeItem
func (*RedEnvelopeItemDao) GetByUser ¶
func (dao *RedEnvelopeItemDao) GetByUser(envelopeNo, userId string) *RedEnvelopeItem
func (*RedEnvelopeItemDao) GetOne ¶
func (dao *RedEnvelopeItemDao) GetOne(itemNo string) *RedEnvelopeItem
func (*RedEnvelopeItemDao) Insert ¶
func (dao *RedEnvelopeItemDao) Insert(data *RedEnvelopeItem) (int64, error)
func (*RedEnvelopeItemDao) ListReceivedItems ¶
func (dao *RedEnvelopeItemDao) ListReceivedItems(userId string, offset, limit int) []*RedEnvelopeItem
Click to show internal directories.
Click to hide internal directories.