package model

import (
	"gitee.com/lzzandlyx/balance/db/mysql"
	"gitee.com/lzzandlyx/balance/internal/svc"
	"gorm.io/gorm"
)

type UserBalanceLog struct {
	gorm.Model
	UserBalanceID   int64  `json:"record_id"        gorm:"type:int(11);not null;comment:订单金额"`
	UserID          int64  `json:"user_id"          gorm:"type:int(11);index;not null;comment:用户id"`
	Amount          string `json:"amount"           gorm:"type:decimal(10,2);comment:变动金额"`
	Sn              string `json:"sn"               gorm:"type:varchar(48);comment:充值编号"`
	TransactionType int32  `json:"transaction_type" gorm:"type:tinyint(1);not null;comment: 1消费 2提现 3退款 4充值"`
}

func GetUserBalanceLogs(svc *svc.ServiceContext, userId int64, size, pageSize int64) (userBalanceLog []UserBalanceLog, err error) {
	err = mysql.WithMySQLClient(svc, func(db *gorm.DB) error {
		if size <= 0 || pageSize <= 0 {
			db = db.Limit(0).Offset(10)
		} else {
			db = db.Limit(int(size)).Offset(int(pageSize))
		}
		return db.Where("user_id = ?", userId).Find(&userBalanceLog).Error
	})
	return
}