You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
376 lines
13 KiB
376 lines
13 KiB
package data
|
|
|
|
import (
|
|
"context"
|
|
"encoding/json"
|
|
"fmt"
|
|
"github.com/shopspring/decimal"
|
|
"matchmaking-system/internal/biz/structure"
|
|
orders "matchmaking-system/internal/data/convert"
|
|
"matchmaking-system/internal/data/tradedeal/share"
|
|
"matchmaking-system/internal/data/tradedeal/virtual"
|
|
"matchmaking-system/internal/pkg/flags"
|
|
"matchmaking-system/internal/pkg/logging/applogger"
|
|
"matchmaking-system/internal/pkg/logging/common"
|
|
models "matchmaking-system/internal/pkg/model"
|
|
"matchmaking-system/internal/pkg/setting"
|
|
"strings"
|
|
"time"
|
|
)
|
|
|
|
// GetBotUserBrlPreStockOrder
|
|
//
|
|
// @Description: 巴西股新股申购列表查詢
|
|
// @receiver uo
|
|
// @param ctx
|
|
// @param id
|
|
// @return []models.BotUserBrlPreStockOrder
|
|
// @return error
|
|
func (uo *userOrderRepo) GetBotUserBrlPreStockOrder(ctx context.Context, id string) ([]models.BotUserBrlPreStockOrder, error) {
|
|
var botSgd []models.BotUserBrlPreStockOrder
|
|
if err := uo.data.mysqlDB.Table(flags.BotUserBrlPreStockOrder).
|
|
Where("pre_stock_id = ?", id).
|
|
Where("status = 3").
|
|
Find(&botSgd); err != nil {
|
|
applogger.Error("%v GetBotUserBrlPreStockOrder Find:%v", common.ErrSharePre, err)
|
|
return nil, err
|
|
}
|
|
|
|
return botSgd, nil
|
|
}
|
|
|
|
// GetBotUserBrlPreStockOrderByOrderNo
|
|
//
|
|
// @Description: 巴西股新股申购列表查詢orderNo
|
|
// @receiver uo
|
|
// @param ctx
|
|
// @param code
|
|
// @return []models.BotUserBrlPreStockOrder
|
|
// @return error
|
|
func (uo *userOrderRepo) GetBotUserBrlPreStockOrderByOrderNo(ctx context.Context, code []string) ([]models.BotUserBrlPreStockOrder, error) {
|
|
var botGbx []models.BotUserBrlPreStockOrder
|
|
if err := uo.data.mysqlDB.Table(flags.BotUserBrlPreStockOrder).
|
|
In("order_no", code).
|
|
Where("trade_status = 0").
|
|
Where("status = 3").
|
|
Find(&botGbx); err != nil {
|
|
applogger.Error("%v GetBotUserBrlPreStockOrderByOrderNo Find:%v", common.ErrSharePre, err)
|
|
return nil, err
|
|
}
|
|
|
|
return botGbx, nil
|
|
}
|
|
|
|
// GetBotUserBrlGiveStockOrders
|
|
//
|
|
// @Description: 巴西股赠股
|
|
// @receiver uo
|
|
// @param ctx
|
|
// @param id
|
|
// @return []models.BotUserBrlGiveStockOrder
|
|
// @return error
|
|
func (uo *userOrderRepo) GetBotUserBrlGiveStockOrders(ctx context.Context, id string) ([]models.BotUserBrlGiveStockOrder, error) {
|
|
var botSgd []models.BotUserBrlGiveStockOrder
|
|
if err := uo.data.mysqlDB.Table(flags.BotUserBrlGiveStockOrder).
|
|
Where("order_no = ?", id).
|
|
Find(&botSgd); err != nil {
|
|
applogger.Error("%v GetBotUserBrlGiveStockOrders Find:%v", common.ErrSharePre, err)
|
|
return nil, err
|
|
}
|
|
|
|
return botSgd, nil
|
|
}
|
|
|
|
// GetBotStockBrlList
|
|
//
|
|
// @Description: 巴西股票代码列表
|
|
// @receiver uo
|
|
// @param ctx
|
|
// @return []models.BotStockBrlList
|
|
// @return error
|
|
func (uo *userOrderRepo) GetBotStockBrlList(ctx context.Context) ([]models.BotStockBrlList, error) {
|
|
var data []models.BotStockBrlList
|
|
if err := uo.data.mysqlDB.Table(flags.BotStockBrlList).Find(&data); err != nil {
|
|
applogger.Error("%v GetBotStockBrlList Find:%v", common.ErrSharePre, err)
|
|
return nil, err
|
|
}
|
|
// 清理股票缓存列表
|
|
for _, value := range data {
|
|
strArray := strings.Split(value.StockCode, ":")
|
|
if len(strArray) >= 2 {
|
|
codeOld := strArray[1]
|
|
Reds.HDel(context.Background(), setting.MarketShareBrl, codeOld)
|
|
Reds.HDel(context.Background(), setting.MarketShareBlkBrl, codeOld)
|
|
}
|
|
}
|
|
|
|
return data, nil
|
|
}
|
|
|
|
// CreateBotUserBrlPreStockOrder
|
|
//
|
|
// @Description: 巴西股新股申购:开仓--持仓
|
|
// @receiver uo
|
|
// @param ctx
|
|
// @param code
|
|
// @param order
|
|
// @return error
|
|
func (uo *userOrderRepo) CreateBotUserBrlPreStockOrder(ctx context.Context, code string, order []structure.ShareOrder) error {
|
|
// 同步写入股票列表缓存
|
|
SubscribeBrlHSetCodeList(code, false)
|
|
// 处理新股申购数据订单
|
|
session := uo.data.mysqlDB.NewSession()
|
|
defer session.Close()
|
|
err := session.Begin()
|
|
if err != nil {
|
|
applogger.Error("%v CreateBotUserBrlPreStockOrder.Begin:%v", common.ErrSharePre, err)
|
|
return flags.ErrMySqlDB
|
|
}
|
|
// 强平阈值
|
|
flatRatio := GetCacheForcedClosure(flags.StockBRLSystemSetUpKey, code)
|
|
system := &structure.ShareSystem{
|
|
StrongFlatRatio: flatRatio.String(),
|
|
}
|
|
// 获取开盘时间
|
|
closingTime := SystemTimeGenerate(flags.StockMarketList, flags.BrlMarket, time.Now())
|
|
// 初始化订单缓存map
|
|
orderMap := make(map[string]share.ShareBrlTallyCache)
|
|
for _, value := range order {
|
|
value.System = system
|
|
// 生成订单ID
|
|
var orderId string
|
|
orderId, err = uo.VerifyBotStockBrlTradeOrderId(session)
|
|
if err != nil {
|
|
applogger.Error("%v CreateBotUserBrlPreStockOrder.VerifyBotStockBrlTradeOrderId:%v", common.ErrSharePre, err)
|
|
continue
|
|
}
|
|
// 查询账户是否存在,再存更新不存在新增
|
|
var check bool
|
|
check, err = uo.CheckStockBrlAmount(ctx, int64(value.UserId), value.StockId, value.OrderNumber, decimal.Zero.String())
|
|
if err != nil || !check {
|
|
applogger.Error("%v CreateBotUserBrlPreStockOrder.CheckStockBrlAmount:%v", common.ErrSharePre, err)
|
|
continue
|
|
}
|
|
// 写入订单数据表
|
|
trade := orders.BotStockBrlTradePre(ctx, int64(value.UserId), orderId, value)
|
|
if err = uo.CreateBotStockBrlTrade(session, trade); err != nil {
|
|
applogger.Error("%v CreateBotUserBrlPreStockOrder.CreateBotStockBrlTrade:%v", common.ErrSharePre, err)
|
|
continue
|
|
}
|
|
// 写入持仓缓存
|
|
resultMsg := share.ShareBrlTallyCache{
|
|
UserId: int64(value.UserId), // 用户Id
|
|
OrderId: orderId, // 订单ID
|
|
Symbol: value.StockId, // 下单交易对
|
|
OpenPrice: value.LimitPrice, // 开仓价格
|
|
Status: flags.Position, // 订单状态
|
|
Order: value, // 下单信息
|
|
ClosingTime: closingTime, // 平仓时间
|
|
}
|
|
orderMap[orderId] = resultMsg
|
|
}
|
|
|
|
if err = session.Commit(); err != nil {
|
|
applogger.Error("%v CreateBotUserBrlPreStockOrder.Commit:%v", common.ErrSharePre, err)
|
|
return flags.ErrMySqlDB
|
|
}
|
|
// 写入持仓缓存、用户订单订阅缓存、管理员订单订阅缓存
|
|
for _, resultMsg := range orderMap {
|
|
var byteStr []byte
|
|
byteStr, err = json.Marshal(resultMsg)
|
|
if err != nil {
|
|
applogger.Error("%v CreateBotUserBrlPreStockOrder.Marshal:%v", common.ErrSharePre, err)
|
|
continue
|
|
}
|
|
// 写入持仓缓存
|
|
if err = Reds.HSet(context.Background(), setting.MarketShareBrlPosition, resultMsg.OrderId, string(byteStr)).Err(); err != nil {
|
|
continue
|
|
}
|
|
// 写入用户订单订阅缓存
|
|
orderIdKey := virtual.OrderIdListKey(setting.ShareBrlSubscribe, resultMsg.UserId)
|
|
if err = share.ShareBrlHashUserOrder(Reds, orderIdKey, &resultMsg); err != nil {
|
|
applogger.Error("%v CreateBotUserBrlPreStockOrder.ShareBrlHashUserOrder:%v", common.ErrSharePre, err)
|
|
return flags.ErrCacheDB
|
|
}
|
|
// 写入管理员订单订阅缓存
|
|
if err = share.ShareBrlHashUserOrder(Reds, setting.AdminShareBrlSubscribe, &resultMsg); err != nil {
|
|
applogger.Error("%v CreateBotUserBrlPreStockOrder.ShareBrlHashUserOrder:%v", common.ErrSharePre, err)
|
|
return flags.ErrCacheDB
|
|
}
|
|
// TODO: 获取IPO未支付订单缓存,并更新缓存中的持仓订单ID
|
|
keyCache := fmt.Sprintf("%v%v", flags.StockIpoList, resultMsg.Order.OrderNo)
|
|
checkInt, err := Reds.Exists(ctx, keyCache).Result()
|
|
if err != nil {
|
|
continue
|
|
}
|
|
if checkInt > 0 {
|
|
if err = Reds.Set(ctx, keyCache, resultMsg.OrderId, 0).Err(); err != nil {
|
|
applogger.Error("CreateBotUserBrlPreStockOrder.Set err:%v", err)
|
|
}
|
|
}
|
|
}
|
|
|
|
return nil
|
|
}
|
|
|
|
// CheckStockBrlAmount
|
|
//
|
|
// @Description: 巴西股新股申购【创建|更新】用戶资产
|
|
// @receiver uo
|
|
// @param ctx
|
|
// @param userId
|
|
// @param stockId
|
|
// @param usableNum
|
|
// @param frozenNum
|
|
// @return bool
|
|
// @return error
|
|
func (uo *userOrderRepo) CheckStockBrlAmount(ctx context.Context, userId int64, stockId, usableNum, frozenNum string) (bool, error) {
|
|
var botUserStockBrl []models.BotUserStockBrl
|
|
if err := uo.data.mysqlDB.Table(flags.BotUserStockBrl).
|
|
Where("user_id = ?", userId).
|
|
Where("stock_id = ?", stockId).
|
|
Find(&botUserStockBrl); err != nil {
|
|
applogger.Error("%v CheckStockBrlAmount Find:%v", common.ErrSharePre, err)
|
|
return false, err
|
|
}
|
|
var usableNumOld, frozenNumOld decimal.Decimal
|
|
for _, value := range botUserStockBrl {
|
|
usableNumOld = decimal.RequireFromString(value.UsableNum)
|
|
frozenNumOld = decimal.RequireFromString(value.FrozenNum)
|
|
}
|
|
|
|
if len(botUserStockBrl) == 0 {
|
|
userStock := orders.CreatBotUserStockBrlPre(ctx, userId, stockId, usableNum, frozenNum)
|
|
_, err := uo.data.mysqlDB.Table(flags.BotUserStockBrl).Insert(&userStock)
|
|
if err != nil {
|
|
applogger.Error("%v CheckStockBrlAmount Insert:%v", common.ErrSharePre, err)
|
|
return false, err
|
|
}
|
|
} else {
|
|
usableNumNew := usableNumOld.Add(decimal.RequireFromString(usableNum))
|
|
frozenNumNew := frozenNumOld.Add(decimal.RequireFromString(frozenNum))
|
|
userStock := orders.UpdateBotUserStockBrlPre(ctx, usableNumNew.String(), frozenNumNew.String())
|
|
_, err := uo.data.mysqlDB.Table(flags.BotUserStockBrl).
|
|
Where("user_id = ?", userId).
|
|
Where("stock_id = ?", stockId).
|
|
Update(&userStock)
|
|
if err != nil {
|
|
applogger.Error("%v CheckStockBrlAmount Update:%v", common.ErrSharePre, err)
|
|
return false, err
|
|
}
|
|
}
|
|
|
|
return true, nil
|
|
}
|
|
|
|
// UpdateShareBrlTradeStockId
|
|
//
|
|
// @Description: 更新-巴西股新股申购股票stockId
|
|
// @receiver uo
|
|
// @param ctx
|
|
// @param code
|
|
// @param codeOld
|
|
// @return error
|
|
func (uo *userOrderRepo) UpdateShareBrlTradeStockId(ctx context.Context, code, codeOld string) error {
|
|
// 同步写入股票列表缓存
|
|
SubscribeBrlHSetCodeList(code, false)
|
|
// 新增到新加坡股缓存列表
|
|
if err := Reds.HSet(context.Background(), setting.MarketShareBrl, code, code).Err(); err != nil {
|
|
applogger.Error("%v UpdateShareBrlTradeStockId.HSet.MarketShareGbx:%v", common.ErrSharePre, err)
|
|
return flags.ErrCacheDB
|
|
}
|
|
|
|
session := uo.data.mysqlDB.NewSession()
|
|
defer session.Close()
|
|
err := session.Begin()
|
|
if err != nil {
|
|
applogger.Error("%v UpdateShareBrlTradeStockId.Begin:%v", common.ErrSharePre, err)
|
|
return flags.ErrMySqlDB
|
|
}
|
|
|
|
// 1、更新订单股票代码
|
|
var userStockTrade []models.BotStockBrlTrade
|
|
if err = session.Table(flags.BotStockBrlTrade).Where("stock_id =?", codeOld).Find(&userStockTrade); err != nil {
|
|
return flags.ErrMySqlDB
|
|
}
|
|
for _, value := range userStockTrade {
|
|
value.StockId = code
|
|
// 1、更新订单信息
|
|
inCheck, err := session.Table(flags.BotStockBrlTrade).Where("trade_id =?", value.TradeId).Update(&value)
|
|
if err != nil || inCheck <= 0 {
|
|
applogger.Error("%v UpdateShareBrlTradeStockId BotStockGbxTrade err:%v", common.ErrSharePre, err)
|
|
continue
|
|
}
|
|
// 2、处理缓存订单
|
|
orderMap, err := Reds.HGet(context.Background(), setting.AdminShareBrlSubscribe, value.OrderId).Result()
|
|
if err != nil {
|
|
continue
|
|
}
|
|
var entrustJson share.ShareBrlTallyCache
|
|
if err = json.Unmarshal([]byte(orderMap), &entrustJson); err != nil {
|
|
continue
|
|
}
|
|
var entrust *share.ShareBrlTallyCache
|
|
entrust = &entrustJson
|
|
if entrust == nil {
|
|
continue
|
|
}
|
|
entrust.Symbol = code
|
|
entrust.Order.StockId = code
|
|
// 3、处理挂单|持仓|用户订阅|管理员订阅缓存数据
|
|
switch value.Status {
|
|
case 0: // 挂单
|
|
if err = share.ShareBrlHashUserOrder(Reds, setting.MarketShareBrlEntrust, entrust); err != nil {
|
|
continue
|
|
}
|
|
case 1: // 持仓
|
|
if err = share.ShareBrlHashUserOrder(Reds, setting.MarketShareBrlPosition, entrust); err != nil {
|
|
continue
|
|
}
|
|
default:
|
|
continue
|
|
}
|
|
// 更新用户订阅缓存
|
|
cacheKey := fmt.Sprintf("%v-%v", setting.ShareBrlSubscribe, entrust.UserId)
|
|
if err = share.ShareBrlHashUserOrder(Reds, cacheKey, entrust); err != nil {
|
|
continue
|
|
}
|
|
// 更新管理员订阅缓存
|
|
if err = share.ShareBrlHashUserOrder(Reds, setting.AdminShareBrlSubscribe, entrust); err != nil {
|
|
continue
|
|
}
|
|
}
|
|
// 2、更新资产表股票代码
|
|
var userStock []models.BotUserStockBrl
|
|
if err = session.Table(flags.BotUserStockBrl).Where("stock_id =?", codeOld).Find(&userStock); err != nil {
|
|
return flags.ErrMySqlDB
|
|
}
|
|
for _, value := range userStock {
|
|
value.StockId = code
|
|
inCheck, err := session.Table(flags.BotUserStockBrl).Where("id =?", value.Id).Update(&value)
|
|
if err != nil || inCheck <= 0 {
|
|
applogger.Error("%v UpdateShareBrlTradeStockId BotUserStockGbx err:%v", common.ErrSharePre, err)
|
|
continue
|
|
}
|
|
}
|
|
// 3、更新资产表日志股票代码
|
|
var userStockLog []models.BotUserStockBrlLog
|
|
if err = session.Table(flags.BotUserStockBrlLog).Where("stock_id =?", codeOld).Find(&userStockLog); err != nil {
|
|
return flags.ErrMySqlDB
|
|
}
|
|
for _, value := range userStockLog {
|
|
value.StockId = code
|
|
inCheck, err := session.Table(flags.BotUserStockBrlLog).Where("id =?", value.Id).Update(&value)
|
|
if err != nil || inCheck <= 0 {
|
|
applogger.Error("%v UpdateShareBrlTradeStockId BotUserStockGbxLog err:%v", common.ErrSharePre, err)
|
|
continue
|
|
}
|
|
}
|
|
|
|
if err = session.Commit(); err != nil {
|
|
applogger.Error("%v UpdateShareBrlTradeStockId.Commit:%v", common.ErrSharePre, err)
|
|
return flags.ErrMySqlDB
|
|
}
|
|
|
|
return nil
|
|
}
|
|
|