envelopes

package
v0.0.0-...-6d8854b Latest Latest
Warning

This package is not in the latest version of its module.

Go to latest
Published: Oct 27, 2019 License: MIT Imports: 15 Imported by: 0

Documentation

Index

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个退款流程

func (*ExpiredEnvelopeDomain) Next

func (e *ExpiredEnvelopeDomain) Next() (ok bool)

查询出过期红包

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

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

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

Jump to

Keyboard shortcuts

? : This menu
/ : Search site
f or F : Jump to
y or Y : Canonical URL
⌂ 换网址