package cc.mrbird.febs.job;
|
|
import cc.mrbird.febs.common.utils.RedisUtils;
|
import cc.mrbird.febs.dapp.entity.*;
|
import cc.mrbird.febs.dapp.mapper.*;
|
import cn.hutool.core.collection.CollUtil;
|
import cn.hutool.core.date.DateTime;
|
import cn.hutool.core.date.DateUtil;
|
import cn.hutool.core.util.ObjectUtil;
|
import cn.hutool.core.util.RandomUtil;
|
import cn.hutool.core.util.StrUtil;
|
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
|
import lombok.extern.slf4j.Slf4j;
|
import org.jline.utils.Log;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.scheduling.annotation.Scheduled;
|
import org.springframework.stereotype.Component;
|
|
import java.math.BigDecimal;
|
import java.text.DecimalFormat;
|
import java.text.Format;
|
import java.text.SimpleDateFormat;
|
import java.util.List;
|
|
@Slf4j
|
@Component
|
public class OnHookPlanJob {
|
|
@Autowired
|
private IgtOnHookPlanOrderItemDao igtOnHookPlanOrderItemDao;
|
|
@Autowired
|
private IgtOnHookPlanOrderDao igtOnHookPlanOrderDao;
|
|
@Autowired
|
private DappWalletCoinDao dappWalletCoinDao;
|
|
@Autowired
|
private DappAccountMoneyChangeDao dappAccountMoneyChangeDao;
|
|
@Autowired
|
private DappMemberDao dappMemberDao;
|
|
@Autowired
|
private DappOnHookAwardDao dappOnHookAwardDao;
|
|
@Autowired
|
private RedisUtils redisUtils;
|
|
/**
|
* 五分钟更新一次数据
|
* 让挂机字表的状态为1:已生效
|
* 更新挂机主表的挂机剩余金额总收益
|
* 如果挂机主表的状态为1开始,但是挂机子表中已经没有对应数据,则更新挂机主表的状态
|
*/
|
|
// @Scheduled(cron = "0/5 * * * * ? ")
|
@Scheduled(cron = "0 0/5 * * * ? ")
|
public void updatePlanOrderItem(){
|
Log.info("开始更新挂机子表状态");
|
List<IgtOnHookPlanOrder> igtOnHookPlanOrders = igtOnHookPlanOrderDao.selectByState(1);
|
if(CollUtil.isEmpty(igtOnHookPlanOrders)){
|
return;
|
}
|
for(IgtOnHookPlanOrder igtOnHookPlanOrder : igtOnHookPlanOrders){
|
//让挂机子表的状态为1:已生效
|
Long orderId = igtOnHookPlanOrder.getId();
|
Long memberId = igtOnHookPlanOrder.getMemberId();
|
IgtOnHookPlanOrderItem igtOnHookPlanOrderItem = igtOnHookPlanOrderItemDao.selectByOrderIdAndMemberIdAndState(orderId,memberId,2);
|
if(ObjectUtil.isNotEmpty(igtOnHookPlanOrderItem)){
|
igtOnHookPlanOrderItem.setState(1);
|
igtOnHookPlanOrderItemDao.updateById(igtOnHookPlanOrderItem);
|
if(BigDecimal.ZERO.compareTo(igtOnHookPlanOrderItem.getProfit()) < 0){
|
//增加挂机主表的挂机总收益和增加挂机剩余金额
|
Integer updateCount = igtOnHookPlanOrderDao.addAvaAmountAddProfitById(igtOnHookPlanOrder.getId()
|
,igtOnHookPlanOrderItem.getProfit()
|
,igtOnHookPlanOrderItem.getAmount());
|
}else{
|
//增加挂机主表的挂机总收益和减少挂机剩余金额
|
Integer updateCount = igtOnHookPlanOrderDao.updateAvaAmountById(igtOnHookPlanOrder.getId()
|
,igtOnHookPlanOrderItem.getProfit()
|
,igtOnHookPlanOrderItem.getAmount());
|
}
|
}
|
|
}
|
|
}
|
|
/**
|
* 根据订单主表获取订单主表中还在开始状态的订单
|
* 查询相关关联的子表
|
* 如果子表中的关联数据都已经 生效状态 1:已生效,则
|
* 1、更新主表状态为结束
|
* 2、计算总盈利
|
* 3、更新用户的余额和总额
|
* 4、生成一条资金流水记录
|
* 5、TODO
|
* 根据会员等级计算其他的流水,比如分佣金这类操作
|
*/
|
|
|
// @Scheduled(cron = "0/5 * * * * ? ")
|
@Scheduled(cron = "0 0/1 * * * ? ")
|
public void updatePlanOrder(){
|
Log.info("开始更新挂机主表状态");
|
|
List<IgtOnHookPlanOrder> igtOnHookPlanOrders = igtOnHookPlanOrderDao.selectByState(1);
|
if(CollUtil.isEmpty(igtOnHookPlanOrders)){
|
return;
|
}
|
for(IgtOnHookPlanOrder igtOnHookPlanOrder : igtOnHookPlanOrders){
|
Long orderId = igtOnHookPlanOrder.getId();
|
Long memberId = igtOnHookPlanOrder.getMemberId();
|
BigDecimal planAmount = igtOnHookPlanOrder.getPlanAmount();
|
BigDecimal avaAmount = igtOnHookPlanOrder.getAvaAmount();
|
IgtOnHookPlanOrderItem igtOnHookPlanOrderItem = igtOnHookPlanOrderItemDao.selectByOrderIdAndMemberIdAndState(orderId,memberId,2);
|
if(ObjectUtil.isEmpty(igtOnHookPlanOrderItem)){
|
BigDecimal totalProfit = igtOnHookPlanOrderItemDao.selectTotalProfitByByOrderIdAndMemberIdAndState(orderId,memberId,1,2);
|
BigDecimal totalAmount = igtOnHookPlanOrderItemDao.selectTotalAmountByByOrderIdAndMemberIdAndState(orderId,memberId,1,2);
|
igtOnHookPlanOrder.setState(2);
|
//一次挂机剩余的全部金额
|
BigDecimal totalMoney = totalAmount.add(totalProfit).add(avaAmount);
|
if(totalMoney.compareTo(planAmount)<=0){
|
igtOnHookPlanOrder.setProfitState(2);
|
}else{
|
igtOnHookPlanOrder.setProfitState(1);
|
}
|
igtOnHookPlanOrderDao.updateById(igtOnHookPlanOrder);
|
|
DappMemberEntity dappMemberEntity = dappMemberDao.selectById(memberId);
|
dappMemberEntity.setIsOnHook(3);
|
dappMemberDao.updateById(dappMemberEntity);
|
|
DappWalletCoinEntity dappWalletCoinEntity = dappWalletCoinDao.selectByMemberId(memberId);
|
BigDecimal availableAmount = dappWalletCoinEntity.getAvailableAmount();
|
//如果中奖,返回本金加收益加剩余投注金额
|
BigDecimal total = totalProfit.add(totalAmount).add(igtOnHookPlanOrder.getAvaAmount()).setScale(2, BigDecimal.ROUND_DOWN);
|
dappWalletCoinDao.addTotalAndaddAvailableById(memberId,total);
|
|
BigDecimal add = availableAmount.add(total);
|
|
DappAccountMoneyChangeEntity dappAccountMoneyChangeEntity = new DappAccountMoneyChangeEntity(memberId, availableAmount, total, add, "投注盈利", 5);
|
dappAccountMoneyChangeDao.insert(dappAccountMoneyChangeEntity);
|
}
|
|
}
|
}
|
|
@Scheduled(cron = "0 0/1 * * * ? ")
|
public void updateMemberIsOnHook(){
|
Log.info("开始更新用户是否挂机状态");
|
dappMemberDao.updateIsOnHook();
|
|
}
|
|
@Scheduled(cron = "0 0/1 * * * ? ")
|
public void createAwardInfo(){
|
Log.info("挂架开奖记录");
|
/**
|
* 每天跑一次,直接生成全部的记录
|
* 产生中奖记录
|
*/
|
//每天开奖次数 288次
|
DateTime date = DateUtil.date();
|
|
String aWardTime = DateUtil.format(date, "yyyy-MM-dd");
|
DateTime aWardTimeStart = DateUtil.parseDateTime(aWardTime + " 00:00:00");
|
// DateTime dateTime = DateUtil.offsetMinute(aWardTimeStart, 5);
|
|
|
SimpleDateFormat sdf = new SimpleDateFormat("yyyyMMdd");
|
String yyyyMMdd = sdf.format(date);
|
QueryWrapper<DappOnHookAward> dappOnHookAwardQueryWrapper = new QueryWrapper();
|
dappOnHookAwardQueryWrapper.like("record_num",yyyyMMdd);
|
Integer selectCount = dappOnHookAwardDao.selectCount(dappOnHookAwardQueryWrapper);
|
if(0 < selectCount){
|
return;
|
}
|
Format formatCount = new DecimalFormat("000");
|
//一般都是将累加的数字当做一些单号的一部分,format要求string
|
int dayMillise = (24 * 60) / 5;
|
for(int i= 1;i <= dayMillise;i++){
|
DappOnHookAward dappOnHookAward = new DappOnHookAward();
|
int randomInt = RandomUtil.randomInt(10000, 99999);
|
dappOnHookAward.setAwardNum(Integer.toString(randomInt));
|
dappOnHookAward.setState(2);
|
String str = formatCount.format(i);
|
dappOnHookAward.setRecordNum(yyyyMMdd+str);
|
dappOnHookAward.setAwardTime(aWardTimeStart);
|
dappOnHookAwardDao.insert(dappOnHookAward);
|
aWardTimeStart = DateUtil.offsetMinute(aWardTimeStart, 5);
|
}
|
}
|
|
@Scheduled(cron = "0 0/5 * * * ? ")
|
public void updateAwardInfo(){
|
Log.info("更新挂架开奖记录");
|
DateTime date = DateUtil.date();
|
|
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm");
|
String yyyyMMddHHMM = sdf.format(date);
|
DappOnHookAward dappOnHookAward = dappOnHookAwardDao.selectByByAwardTime(yyyyMMddHHMM);
|
dappOnHookAward.setState(1);
|
dappOnHookAwardDao.updateById(dappOnHookAward);
|
String redisKey = "on_hook_award_id";
|
String onHookAwardRedisId = redisUtils.getString(redisKey);
|
if(StrUtil.isBlank(onHookAwardRedisId)){
|
redisUtils.set(redisKey,dappOnHookAward.getId().toString(),0L);
|
}
|
redisUtils.set(redisKey,dappOnHookAward.getId().toString(),0L);
|
|
}
|
|
public static void main(String[] args) {
|
DateTime date = DateUtil.date();
|
System.out.println(date);
|
String yyyyMMddHHMM = DateUtil.format(date, "yyyy-MM-dd hh:mm");
|
System.out.println(yyyyMMddHHMM);
|
|
SimpleDateFormat sdf = new SimpleDateFormat("yyyyMMdd");
|
String yyyyMMdd = sdf.format(date);
|
System.out.println(yyyyMMdd);
|
}
|
|
}
|