SpringBoot 簽到獎勵實現(xiàn)方案的示例代碼
前言
最近在做社交業(yè)務(wù),用戶進入APP后有簽到功能,簽到成功后獲取相應(yīng)的獎勵:
項目狀況:前期嘗試業(yè)務(wù)階段;
特點:
- 快速實現(xiàn)(不需要做太重,滿足初期推廣運營即可)
- 快速投入市場去運營
用戶簽到:
- 用戶在每次啟動時查詢簽到記錄(規(guī)則:連續(xù)7日簽到從0開始,簽到過程中有斷簽從0開始)
- 如果今日未簽到則提示用戶可以進行簽到
- 用戶簽到獲取相應(yīng)的獎勵
提到簽到,腦海中首先浮現(xiàn)特點:
- 需要記錄每位用戶每天的簽到情況
- 查詢時根據(jù)規(guī)則進行簽到記錄情況
需求&流程設(shè)計&技術(shù)實現(xiàn)方案
需求原型圖
查詢簽到記錄
進行簽到
技術(shù)實現(xiàn)方案
- SpringBoot
- MySQL
數(shù)據(jù)庫表結(jié)構(gòu)
簽到記錄最新表
CREATE TABLE `zh_sign_in` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `bu_no` varchar(32) DEFAULT NULL COMMENT '業(yè)務(wù)編碼', `customer_id` varchar(32) DEFAULT NULL COMMENT '簽到用戶編碼', `sign_in_date` datetime DEFAULT NULL COMMENT '簽到日期(單位精確到日)', `reward_money` int(11) DEFAULT NULL COMMENT '本次簽到獎勵金幣個數(shù)', `continuite_day` int(2) DEFAULT '1' COMMENT '連續(xù)簽到天數(shù)(A:7天內(nèi)如果有斷簽從0開始 B:7天簽滿從0開始)', `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '創(chuàng)建時間', `update_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '更新時間', `param1` int(2) DEFAULT NULL COMMENT '預(yù)留字段1', `param2` int(4) DEFAULT NULL COMMENT '預(yù)留字段2', `param3` int(11) DEFAULT NULL COMMENT '預(yù)留字段3', `param4` varchar(20) DEFAULT NULL COMMENT '預(yù)留字段4', `param5` varchar(32) DEFAULT NULL COMMENT '預(yù)留字段5', `param6` varchar(64) DEFAULT NULL COMMENT '預(yù)留字段6', PRIMARY KEY (`id`) USING BTREE, UNIQUE KEY `uk_zh_sign_in_buno` (`bu_no`), UNIQUE KEY `uk_zh_sign_in_cid_signindate` (`customer_id`,`sign_in_date`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='用戶簽到表';
簽到記錄歷史表
CREATE TABLE `zh_sign_in_hist` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `bu_no` varchar(32) DEFAULT NULL COMMENT '業(yè)務(wù)編碼', `customer_id` varchar(32) DEFAULT NULL COMMENT '簽到用戶編碼', `sign_in_date` datetime NULL DEFAULT NULL COMMENT '簽到日期(單位精確到日)', `reward_money` int(11) DEFAULT NULL COMMENT '本次簽到獎勵金幣個數(shù)', `continuite_day` int(2) DEFAULT '1' COMMENT '連續(xù)簽到天數(shù)(A:7天內(nèi)如果有斷簽從0開始 B:7天簽滿從0開始)', `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '創(chuàng)建時間', `update_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '更新時間', `param1` int(2) DEFAULT NULL COMMENT '預(yù)留字段1', `param2` int(4) DEFAULT NULL COMMENT '預(yù)留字段2', `param3` int(11) DEFAULT NULL COMMENT '預(yù)留字段3', `param4` varchar(20) DEFAULT NULL COMMENT '預(yù)留字段4', `param5` varchar(32) DEFAULT NULL COMMENT '預(yù)留字段5', `param6` varchar(64) DEFAULT NULL COMMENT '預(yù)留字段6', PRIMARY KEY (`id`) USING BTREE, UNIQUE KEY `uk_zh_sign_in_hist_cid_signindate` (`customer_id`,`sign_in_date`) USING BTREE, KEY `key_zh_sign_in_hist_buno` (`bu_no`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='用戶簽到歷史表';
代碼實現(xiàn)
完整代碼(GitHub,歡迎大家Star,Fork,Watch)
https://github.com/dangnianchuntian/springboot
主要代碼展示
Controller
/* * Copyright (c) 2020. zhanghan_java@163.com All Rights Reserved. * 項目名稱:Spring Boot實戰(zhàn):簽到獎勵實現(xiàn)方案 * 類名稱:SignInController.java * 創(chuàng)建人:張晗 * 聯(lián)系方式:zhanghan_java@163.com * 開源地址: https://github.com/dangnianchuntian/springboot * 博客地址: https://zhanghan.blog.csdn.net */ package com.zhanghan.zhsignin.controller; import com.zhanghan.zhsignin.controller.request.PostSignInRequest; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.validation.annotation.Validated; import org.springframework.web.bind.annotation.RequestBody; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RequestMethod; import org.springframework.web.bind.annotation.RestController; import com.zhanghan.zhsignin.controller.request.ListSignInDetailRequest; import com.zhanghan.zhsignin.service.SignInService; @RestController public class SignInController { @Autowired private SignInService signInService; /** * 查詢簽到記錄 */ @RequestMapping(value = "/list/sign/in/detail", method = RequestMethod.POST) public Object listSignInDetail(@RequestBody @Validated ListSignInDetailRequest listSignInDetailRequest) { return signInService.listSignInDetail(listSignInDetailRequest); } /** * 用戶進行簽到 */ @RequestMapping(value = "/post/sign/in", method = RequestMethod.POST) public Object postSignIn(@RequestBody @Validated PostSignInRequest postSignInRequest) { return signInService.postSignIn(postSignInRequest); } }
service
/* * Copyright (c) 2020. zhanghan_java@163.com All Rights Reserved. * 項目名稱:Spring Boot實戰(zhàn):簽到獎勵實現(xiàn)方案 * 類名稱:SignInServiceImpl.java * 創(chuàng)建人:張晗 * 聯(lián)系方式:zhanghan_java@163.com * 開源地址: https://github.com/dangnianchuntian/springboot * 博客地址: https://zhanghan.blog.csdn.net */ package com.zhanghan.zhsignin.service.impl; import cn.hutool.core.util.IdUtil; import com.zhanghan.zhsignin.config.SignInRewardMoneyListConfig; import com.zhanghan.zhsignin.constant.SignInConstant; import com.zhanghan.zhsignin.controller.request.ListSignInDetailRequest; import com.zhanghan.zhsignin.controller.request.PostSignInRequest; import com.zhanghan.zhsignin.controller.response.ListSignInDetailResponse; import com.zhanghan.zhsignin.mybatis.entity.XZhSignInEntity; import com.zhanghan.zhsignin.mybatis.entity.XZhSignInHistEntity; import com.zhanghan.zhsignin.mybatis.mapper.XZhSignInHistMapper; import com.zhanghan.zhsignin.mybatis.mapper.XZhSignInMapper; import com.zhanghan.zhsignin.service.SignInService; import com.zhanghan.zhsignin.util.DateUtils; import com.zhanghan.zhsignin.util.wrapper.WrapMapper; import org.springframework.beans.BeanUtils; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.beans.factory.annotation.Value; import org.springframework.stereotype.Service; import org.springframework.util.CollectionUtils; import java.util.Date; import java.util.List; import java.util.stream.Collectors; import static com.zhanghan.zhsignin.constant.SignInConstant.*; @Service public class SignInServiceImpl implements SignInService { @Autowired private XZhSignInMapper xZhSignInMapper; @Autowired private XZhSignInHistMapper xZhSignInHistMapper; //校驗連續(xù)天數(shù)是否為7 @Value("#{T(java.lang.Integer).parseInt('${zh.sign.in.continuite.day.threshold:7}')}") public Integer continuiteDayThreshold; //簽到獎勵金幣集合配置 @Autowired public SignInRewardMoneyListConfig signInRewardMoneyListConfig; /** * 查詢用戶簽到記錄 */ @Override public Object listSignInDetail(ListSignInDetailRequest listSignInDetailRequest) { //若配置文件中未配置簽到獎勵則不展示簽到記錄 List<Integer> signInRewardMoneyListConfigList = signInRewardMoneyListConfig.getList(); if (CollectionUtils.isEmpty(signInRewardMoneyListConfigList)) { return WrapMapper.ok(new ListSignInDetailResponse(false)); } String customerId = listSignInDetailRequest.getCustomerId(); XZhSignInEntity xZhSignInEntity = xZhSignInMapper.findByCustomerId(customerId); List<ListSignInDetailResponse.SignInDetail> signInDetailList = signInRewardMoneyListConfigList.stream().map(aa -> new ListSignInDetailResponse.SignInDetail(0, aa)).collect(Collectors.toList()); //該用戶之前未簽到過 if (null == xZhSignInEntity) { return WrapMapper.ok(new ListSignInDetailResponse(TODAY_NOT_SIGN_IN, SignInConstant.CONTINUITE_DAY_ZERO, signInDetailList)); } long signInDateTime = xZhSignInEntity.getSignInDate().getTime(); //最近一次簽到是否為昨日之前 if (signInDateTime < DateUtils.getYesterdayDateTime()) { return WrapMapper.ok(new ListSignInDetailResponse(TODAY_NOT_SIGN_IN, SignInConstant.CONTINUITE_DAY_ZERO, signInDetailList)); } //最近一次簽到是否為昨日 Integer todaySignStatus = TODAY_YES_SIGN_IN; Integer continuiteDay = xZhSignInEntity.getContinuiteDay(); if (signInDateTime < DateUtils.getTodayDateTime()) { //最近一次簽到是昨日且之前已連續(xù)簽到7日 if (continuiteDay >= continuiteDayThreshold) { return WrapMapper.ok(new ListSignInDetailResponse(TODAY_NOT_SIGN_IN, SignInConstant.CONTINUITE_DAY_ZERO, signInDetailList)); } //最近一次簽到是昨日且之前連續(xù)未超7日 todaySignStatus = TODAY_NOT_SIGN_IN; } //查詢用戶簽到歷史記錄 List<XZhSignInHistEntity> xZhSignInHistEntitieList = xZhSignInHistMapper.listByCustomerIdAndLimit(customerId, continuiteDay); for (XZhSignInHistEntity xZhSignInHistEntity : xZhSignInHistEntitieList) { ListSignInDetailResponse.SignInDetail signInDetail = new ListSignInDetailResponse.SignInDetail(TODAY_YES_SIGN_IN, xZhSignInHistEntity.getRewardMoney()); signInDetailList.remove(xZhSignInHistEntity.getContinuiteDay() - 1); signInDetailList.add(xZhSignInHistEntity.getContinuiteDay() - 1, signInDetail); } return WrapMapper.ok(new ListSignInDetailResponse(todaySignStatus, continuiteDay, signInDetailList)); } /** * 進行簽到 */ @Override public Object postSignIn(PostSignInRequest postSignInRequest) { //若配置文件中未配置簽到獎勵則不展示簽到記錄 List<Integer> signInRewardMoneyListConfigList = signInRewardMoneyListConfig.getList(); if (CollectionUtils.isEmpty(signInRewardMoneyListConfigList)) { return WrapMapper.ok(); } //獲取session用戶對象 String customerId = postSignInRequest.getCustomerId(); //根據(jù)customerId查詢用戶簽到記錄 XZhSignInEntity xZhSignInEntityByCustomerId = xZhSignInMapper.findByCustomerId(customerId); //簽到記錄是否為空 if (null == xZhSignInEntityByCustomerId) { XZhSignInEntity xZhSignInEntity = new XZhSignInEntity(); xZhSignInEntity.setBuNo(IdUtil.simpleUUID()); xZhSignInEntity.setCustomerId(customerId); xZhSignInEntity.setContinuiteDay(CONTINUITE_DAY_ONE); xZhSignInEntity.setRewardMoney(signInRewardMoneyListConfigList.get(0)); xZhSignInEntity.setSignInDate(DateUtils.getTodayDate()); insertSigninAndHist(xZhSignInEntity); return WrapMapper.ok(); } long signInDateTime = xZhSignInEntityByCustomerId.getSignInDate().getTime(); if (signInDateTime == DateUtils.getTodayDateTime()) { return WrapMapper.error("今天已經(jīng)簽到"); } //獲取連續(xù)簽到天數(shù) Integer continuiteDay = continuiteDay(xZhSignInEntityByCustomerId.getContinuiteDay(), signInDateTime); xZhSignInEntityByCustomerId.setSignInDate(DateUtils.getTodayDate()); xZhSignInEntityByCustomerId.setContinuiteDay(continuiteDay); xZhSignInEntityByCustomerId.setRewardMoney(signInRewardMoneyListConfigList.get(continuiteDay - 1)); xZhSignInEntityByCustomerId.setUpdateTime(new Date()); xZhSignInEntityByCustomerId.setBuNo(IdUtil.simpleUUID()); updateSignInAndInsertHist(xZhSignInEntityByCustomerId); return WrapMapper.ok(); } private Integer continuiteDay(Integer continuiteDay, Long signInDateTime) { if (signInDateTime < DateUtils.getYesterdayDateTime()) { return CONTINUITE_DAY_ONE; } if (continuiteDay >= continuiteDayThreshold) { return CONTINUITE_DAY_ONE; } return continuiteDay + 1; } private void insertSigninAndHist(XZhSignInEntity xZhSignInEntity) { xZhSignInMapper.insertSelective(xZhSignInEntity); XZhSignInHistEntity xZhSignInHistEntity = new XZhSignInHistEntity(); BeanUtils.copyProperties(xZhSignInEntity, xZhSignInHistEntity); xZhSignInHistEntity.setId(null); xZhSignInHistMapper.insertSelective(xZhSignInHistEntity); } private void updateSignInAndInsertHist(XZhSignInEntity xZhSignInEntity) { xZhSignInMapper.updateByPrimaryKeySelective(xZhSignInEntity); XZhSignInHistEntity xZhSignInHistEntity = new XZhSignInHistEntity(); BeanUtils.copyProperties(xZhSignInEntity, xZhSignInHistEntity); xZhSignInHistEntity.setId(null); xZhSignInHistMapper.insertSelective(xZhSignInHistEntity); } }
測試
模擬用戶進行簽到
進行請求
查看數(shù)據(jù)庫結(jié)果
模擬用戶查詢簽到記錄
進行請求
總結(jié)
- 亮點:實現(xiàn)業(yè)務(wù)連續(xù)簽到,斷簽以及獎勵的業(yè)務(wù)
- 注意點:基于數(shù)據(jù)庫查詢做的,在進行簽到接口需要用redis鎖防止并發(fā)操作
- 后續(xù)會持續(xù)分享更多業(yè)務(wù)中的亮點
到此這篇關(guān)于SpringBoot 簽到獎勵實現(xiàn)方案的示例代碼的文章就介紹到這了,更多相關(guān)SpringBoot 簽到獎勵內(nèi)容請搜索腳本之家以前的文章或繼續(xù)瀏覽下面的相關(guān)文章希望大家以后多多支持腳本之家!
- 實例詳解Spring Boot實戰(zhàn)之Redis緩存登錄驗證碼
- SpringBoot+Dubbo+Seata分布式事務(wù)實戰(zhàn)詳解
- 詳解Spring Boot實戰(zhàn)之單元測試
- SpringBoot 實戰(zhàn) 之 優(yōu)雅終止服務(wù)的方法
- spring boot實戰(zhàn)之本地jar包引用示例
- spring boot實戰(zhàn)之內(nèi)嵌容器tomcat配置
- Spring Boot緩存實戰(zhàn) Caffeine示例
- spring boot實戰(zhàn)之使用JSP的示例
- Spring Boot緩存實戰(zhàn) EhCache示例
- Spring Boot項目實戰(zhàn)之?dāng)r截器與過濾器
相關(guān)文章
解決IDEA開發(fā)工具右側(cè)沒有Maven工具欄的問題
這篇文章主要給大家解決了IDEA開發(fā)工具右側(cè)沒有Maven工具欄的問題,文中有詳細的解決步驟,如果有遇到一樣問題的小伙伴,可以參考閱讀本文2023-09-09解決java.lang.IllegalArgumentException異常問題
這篇文章主要介紹了解決java.lang.IllegalArgumentException異常問題,具有很好的參考價值,希望對大家有所幫助,如有錯誤或未考慮完全的地方,望不吝賜教2024-04-04SpringMVC JSON數(shù)據(jù)傳輸參數(shù)超詳細講解
有時候參數(shù)的傳遞還需要更多的參數(shù),比如一個獲取用戶信息的請求中既有用戶ID等基本參數(shù),還要求對查詢結(jié)果進行分頁,針對這種場景,一般都會將分頁參數(shù)封裝成一個對象,然后將它和基本參數(shù)一起傳給控制器2023-02-02淺談Java循環(huán)中的For和For-each哪個更快
本文主要介紹了淺談Java循環(huán)中的For和For-each哪個更快,文中通過示例代碼介紹的非常詳細,對大家的學(xué)習(xí)或者工作具有一定的參考學(xué)習(xí)價值,需要的朋友們下面隨著小編來一起學(xué)習(xí)學(xué)習(xí)吧2022-08-08基于Spring Data的AuditorAware審計功能的示例代碼
這篇文章主要介紹了基于Spring Data的AuditorAware審計功能的示例代碼,小編覺得挺不錯的,現(xiàn)在分享給大家,也給大家做個參考。一起跟隨小編過來看看吧2018-03-03java全角、半角字符的關(guān)系以及轉(zhuǎn)換詳解
這篇文章主要介紹了2013-11-11