database

type AddOrUpdateEmailParams struct {
	UserID           uint32
	TwoFactorEmail   sql.NullString
	TwoFactorEmail_2 sql.NullString
}

type AddUserAutoUserIdParams struct {
	UserAccount          string
	UserNickname         sql.NullString
	UserAvatar           sql.NullString
	UserState            uint8
	UserMobile           sql.NullString
	UserGender           sql.NullInt16
	UserBirthday         sql.NullTime
	UserEmail            sql.NullString
	UserIsAuthentication uint8
}

type AddUserBaseParams struct {
	UserAccount  string
	UserPassword string
	UserSalt     string
}

type AddUserHaveUserIdParams struct {
	UserID               uint64
	UserAccount          string
	UserNickname         sql.NullString
	UserAvatar           sql.NullString
	UserState            uint8
	UserMobile           sql.NullString
	UserGender           sql.NullInt16
	UserBirthday         sql.NullTime
	UserEmail            sql.NullString
	UserIsAuthentication uint8
}

type DBTX interface {
	ExecContext(context.Context, string, ...interface{}) (sql.Result, error)
	PrepareContext(context.Context, string) (*sql.Stmt, error)
	QueryContext(context.Context, string, ...interface{}) (*sql.Rows, error)
	QueryRowContext(context.Context, string, ...interface{}) *sql.Row
}

type DecreaseTicketV1Params struct {
	StockAvailable   int32
	ID               int64
	StockAvailable_2 int32
}

type DecreaseTicketV2Params struct {
	StockAvailable   int32
	ID               int64
	StockAvailable_2 int32
}

type DisableTwoFactorParams struct {
	UserID            uint32
	TwoFactorAuthType PreGoAccUserTwoFactor9999TwoFactorAuthType
}

type EditUserByUserIdParams struct {
	UserNickname sql.NullString
	UserAvatar   sql.NullString
	UserMobile   sql.NullString
	UserGender   sql.NullInt16
	UserBirthday sql.NullTime
	UserEmail    sql.NullString
	UserID       uint64
}

type EnableTwoFactorTypeEmailParams struct {
	UserID            uint32
	TwoFactorAuthType PreGoAccUserTwoFactor9999TwoFactorAuthType
	TwoFactorEmail    sql.NullString
}

type FindUsersParams struct {
	UserAccount  string
	UserNickname sql.NullString
}

type GetInfoOTPRow struct {
	VerifyID      int32
	VerifyOtp     string
	VerifyKey     string
	VerifyKeyHash string
	VerifyType    sql.NullInt32
	IsVerified    sql.NullInt32
	IsDeleted     sql.NullInt32
}

type GetOneUserInfoAdminRow struct {
	UserID         int32
	UserAccount    string
	UserPassword   string
	UserSalt       string
	UserLoginTime  sql.NullTime
	UserLogoutTime sql.NullTime
	UserLoginIp    sql.NullString
	UserCreatedAt  sql.NullTime
	UserUpdatedAt  sql.NullTime
}

type GetOneUserInfoRow struct {
	UserID       int32
	UserAccount  string
	UserPassword string
	UserSalt     string
}

type GetTicketItemByIdRow struct {
	ID             int64
	Name           string
	StockInitial   int32
	StockAvailable int32
}

type GetTwoFactorMethodByIDAndByTypeParams struct {
	UserID            uint32
	TwoFactorAuthType PreGoAccUserTwoFactor9999TwoFactorAuthType
}

type GetTwoFactorMethodByIDAndByTypeRow struct {
	UserID              uint32
	TwoFactorAuthType   PreGoAccUserTwoFactor9999TwoFactorAuthType
	TwoFactorAuthSecret string
	TwoFactorEmail      sql.NullString
	TwoFactorPhone      sql.NullString
	TwoFactorIsActive   bool
	TwoFactorCreatedAt  sql.NullTime
	TwoFactorUpdatedAt  sql.NullTime
}

type GetTwoFactorMethodByIDRow struct {
	UserID              uint32
	TwoFactorAuthType   PreGoAccUserTwoFactor9999TwoFactorAuthType
	TwoFactorAuthSecret string
	TwoFactorEmail      sql.NullString
	TwoFactorPhone      sql.NullString
	TwoFactorIsActive   bool
	TwoFactorCreatedAt  sql.NullTime
	TwoFactorUpdatedAt  sql.NullTime
}

type GetTwoFactorStatusParams struct {
	UserID            uint32
	TwoFactorAuthType PreGoAccUserTwoFactor9999TwoFactorAuthType
}

type GetUserByEmailSQLCRow struct {
	UsrEmail string
	UsrID    uint32
}

type GetUserTwoFactoryMethodsRow struct {
	UserID              uint32
	TwoFactorAuthType   PreGoAccUserTwoFactor9999TwoFactorAuthType
	TwoFactorAuthSecret string
	TwoFactorEmail      sql.NullString
	TwoFactorPhone      sql.NullString
	TwoFactorIsActive   bool
	TwoFactorCreatedAt  sql.NullTime
	TwoFactorUpdatedAt  sql.NullTime
}

type GetValidOtpRow struct {
	VerifyOtp     string
	VerifyKeyHash string
	VerifyKey     string
	VerifyID      int32
}

type GoCrmUser struct {
	// Account ID
	UsrID uint32
	// Email
	UsrEmail string
	// Phone Number
	UsrPhone string
	// Username
	UsrUsername string
	// Password
	UsrPassword string
	// Created Time
	UsrCreatedAt int32
	// Updated Time
	UsrUpdatedAt int32
	// Created IP
	UsrCreateIpAt string
	// Last Login Time
	UsrLastLoginAt int32
	// Last Login IP
	UsrLastLoginIpAt string
	// Login Times
	UsrLoginTimes int32
	// Status
	UsrStatus bool
}

type InsertOTPVerifyParams struct {
	VerifyOtp     string
	VerifyKey     string
	VerifyKeyHash string
	VerifyType    sql.NullInt32
}

type ListUsersParams struct {
	Limit  int32
	Offset int32
}

type LoginUserBaseParams struct {
	UserLoginIp  sql.NullString
	UserAccount  string
	UserPassword string
}

type NullPreGoAccUserTwoFactor9999TwoFactorAuthType struct {
	PreGoAccUserTwoFactor9999TwoFactorAuthType PreGoAccUserTwoFactor9999TwoFactorAuthType
	Valid                                      bool // Valid is true if PreGoAccUserTwoFactor9999TwoFactorAuthType is not NULL
}

type PreGoAccUserBase9999 struct {
	// User ID
	UserID int32
	// User account
	UserAccount string
	// User password
	UserPassword string
	// Salt for hashing
	UserSalt string
	// Last login timestamp
	UserLoginTime sql.NullTime
	// Last logout timestamp
	UserLogoutTime sql.NullTime
	// IP address of last login
	UserLoginIp sql.NullString
	// Creation timestamp
	UserCreatedAt sql.NullTime
	// Update timestamp
	UserUpdatedAt sql.NullTime
	// authentication two factor enabled for the user
	IsTwoFactorEnabled sql.NullInt32
}

type PreGoAccUserInfo9999 struct {
	// User  ID
	UserID uint64
	// User  account
	UserAccount string
	// User  nickname
	UserNickname sql.NullString
	// User  avatar
	UserAvatar sql.NullString
	// User  state: 0-Locked, 1-Activated, 2-Not Activated
	UserState uint8
	// Mobile phone number
	UserMobile sql.NullString
	// User  gender: 0-Secret, 1-Male, 2-Female
	UserGender sql.NullInt16
	// User  birthday
	UserBirthday sql.NullTime
	// User  email address
	UserEmail sql.NullString
	// Authentication status: 0-Not Authenticated, 1-Pending, 2-Authenticated, 3-Failed
	UserIsAuthentication uint8
	// Record creation time
	CreatedAt sql.NullTime
	// Record update time
	UpdatedAt sql.NullTime
}

type PreGoAccUserTwoFactor9999 struct {
	// Khoa chinh tu dong tang
	TwoFactorID uint32
	// Khoa ngoai lien ket voi bang nguoi dung
	UserID uint32
	// Loai xac thuc 2fa
	TwoFactorAuthType PreGoAccUserTwoFactor9999TwoFactorAuthType
	// Ma bi mat xac thuc 2fa
	TwoFactorAuthSecret string
	// So dien thoai xac thuc 2fa
	TwoFactorPhone sql.NullString
	// Email xac thuc 2fa
	TwoFactorEmail sql.NullString
	// Trang thai kich hoat xac thuc 2fa
	TwoFactorIsActive bool
	// Thoi gian tao xac thuc 2fa
	TwoFactorCreatedAt sql.NullTime
	// Thoi gian cap nhat xac thuc 2fa
	TwoFactorUpdatedAt sql.NullTime
}

type PreGoAccUserTwoFactor9999TwoFactorAuthType string

type PreGoAccUserVerify9999 struct {
	// Verification ID
	VerifyID int32
	// One-time password
	VerifyOtp string
	// Verification key - email address, phone number, ....
	VerifyKey string
	// Hash of the verification key
	VerifyKeyHash string
	// Verification type (e.g., 1 for email)
	VerifyType sql.NullInt32
	// Verification status: 1 for verified, 0 for not verified
	IsVerified sql.NullInt32
	// Deletion flag: 1 for deleted, 0 for not deleted
	IsDeleted sql.NullInt32
	// Record creation time
	VerifyCreatedAt sql.NullTime
	// Record update time
	VerifyUpdatedAt sql.NullTime
}

type Queries struct {
	// contains filtered or unexported fields
}

type ReactivateTwoFactorParams struct {
	UserID            uint32
	TwoFactorAuthType PreGoAccUserTwoFactor9999TwoFactorAuthType
}

type RemoveTwoFactorParams struct {
	UserID            uint32
	TwoFactorAuthType PreGoAccUserTwoFactor9999TwoFactorAuthType
}

type TicketItem struct {
	// Primary key
	ID int64
	// Ticket title
	Name string
	// Ticket description
	Description sql.NullString
	// Initial stock quantity (e.g., 1000 tickets)
	StockInitial int32
	// Current available stock (e.g., 900 tickets)
	StockAvailable int32
	// Indicates if stock is pre-warmed (0/1)
	IsStockPrepared bool
	// Original ticket price
	PriceOriginal int64
	// Discounted price during flash sale
	PriceFlash int64
	// Flash sale start time
	SaleStartTime time.Time
	// Flash sale end time
	SaleEndTime time.Time
	// Ticket status (e.g., active/inactive)
	Status int32
	// ID of associated activity
	ActivityID int64
	// Timestamp of the last update
	UpdatedAt time.Time
	// Creation timestamp
	CreatedAt time.Time
}

type UpdatePasswordParams struct {
	UserPassword string
	UserID       int32
}

type UpdateTwoFactorStatusParams struct {
	UserID            uint32
	TwoFactorAuthType PreGoAccUserTwoFactor9999TwoFactorAuthType
}

type VerifyTwoFactorParams struct {
	UserID            uint32
	TwoFactorAuthType PreGoAccUserTwoFactor9999TwoFactorAuthType
}