签到打卡功能，7天一个周期，中间断签重新开始

表

用户签到表
CREATE TABLE `t_user_sign` (`id` bigint(20) NOT NULL AUTO_INCREMENT,`count` int(11) DEFAULT NULL,`create_time` datetime DEFAULT NULL,`last_modify_time` datetime DEFAULT NULL,`sign_count` int(11) DEFAULT NULL,`user_id` bigint(20) NOT NULL,PRIMARY KEY (`id`),KEY `id` (`id`),KEY `user_id` (`user_id`),KEY `last_modify_time` (`last_modify_time`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;用户签到日志表
CREATE TABLE `t_user_sign_log` (`id` bigint(20) NOT NULL AUTO_INCREMENT,`create_time` datetime DEFAULT NULL,`sign_status` char(1) NOT NULL,`update_time` datetime DEFAULT NULL,`user_sign_id` bigint(20) DEFAULT NULL,PRIMARY KEY (`id`),KEY `user_sign_id` (`user_sign_id`),KEY `sign_status` (`sign_status`,`user_sign_id`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

简单的代码体现

使用的是JPA方式，可以根据情况自己转换*** 描述：** @author 哈哈哈* @date 2019/5/9 13:53*/
@Data
@AllArgsConstructor
@NoArgsConstructor
@Builder
@Entity
@Table(name = "t_user_sign")
public class UserSign {@Id@GeneratedValue(strategy = GenerationType.IDENTITY)private Long id;/*** 关联用户ID*/@Column(nullable = false)private Long userId;/*** 创建时间*/@Columnprivate Date createTime;/*** 最后签到时间*/@Columnprivate Date lastModifyTime;/*** 连续签到次数*/@Columnprivate Integer signCount;/*** 签到次数*/@Columnprivate Integer count;}

/*** 描述：用户签到记录表** @author 哈哈哈* @date 2019/5/9 14:52*/
@Data
@AllArgsConstructor
@NoArgsConstructor
@Builder
@Entity
@Table(name = "t_user_sign_log")
public class UserSignLog {@Id@GeneratedValue(strategy = GenerationType.IDENTITY)private Long id;/*** 关联签到id*/@Columnprivate Long userSignId;@Columnprivate Date createTime;@Columnprivate Date updateTime;/*** 是否可用*/@Column(nullable = false, columnDefinition = "char(1)")@Type(type = "yes_no")private Boolean signStatus;}

DAO层

@Repository
public interface UserSignRepository extends JpaRepository, JpaSpecificationExecutor {UserSign findUserSignByUserId(Long userId);}/*** 描述：** @author * @date 2019/5/9 14:55*/@Repository
public interface UserSignLogRepository extends JpaRepository, JpaSpecificationExecutor {@Modifying@Query("update UserSignLog set signStatus=false  where userSignId =(?1)")int updateUserSignLogSignStatus(Long userSignId);List findUserSignLogsByUserSignIdAndSignStatusIsTrue(Long userSignId);}

service

/*** 描述：用户签到** @author 哈哈哈* @date 2019/5/9 14:00*/
@Service
public class UserSignService {private final UserSignRepository userSignRepository;private final UserSignLogRepository userSignLogRepository;@Autowiredpublic UserSignService(UserSignRepository userSignRepository, UserSignLogRepository userSignLogRepository) {this.userSignRepository = userSignRepository;this.userSignLogRepository = userSignLogRepository;}/***** 打卡* @param userId 用户id* @return*/@Transactional()public int createSign(Long userId) {UserSign userSign = userSignRepository.findUserSignByUserId(userId);Date now = new Date();/*判断是否是第一次签到*/if (userSign == null) {System.out.println("用户第一次签到");userSign = UserSign.builder().createTime(now).lastModifyTime(now).count(1).userId(userId).signCount(1).build();userSignRepository.save(userSign);UserSignLog userSignLog = UserSignLog.builder().createTime(now).updateTime(now).userSignId(userSign.getId()).signStatus(true).build();userSignLogRepository.save(userSignLog);return 1;} else {//今天已经签到过了if (userSign.getLastModifyTime().getTime() > getStartOfDay(now).getTime()&& userSign.getLastModifyTime().getTime() < getEndOfDay(now).getTime()) {System.out.println("用户已经签到过了");return userSign.getSignCount();}Calendar calendar = Calendar.getInstance();calendar.setTime(now);calendar.add(Calendar.DATE, -1);//非连续签到if (userSign.getLastModifyTime().getTime() < getStartOfDay(calendar.getTime()).getTime()) {System.out.println("已经不是连续签到");//签到次数重新开始//修改签到log表中的状态userSignLogRepository.updateUserSignLogSignStatus(userSign.getId());userSign.setCount(userSign.getCount() + 1);userSign.setSignCount(1);userSign.setLastModifyTime(now);UserSignLog userSignLog = UserSignLog.builder().createTime(now).updateTime(now).signStatus(true).userSignId(userSign.getId()).build();userSignLogRepository.save(userSignLog);userSignRepository.save(userSign);return 1;} else {System.out.println("连续签到");//正常打卡userSign.setSignCount(userSign.getSignCount() + 1);userSign.setCount(userSign.getCount() + 1);userSign.setLastModifyTime(now);userSignRepository.save(userSign);UserSignLog userSignLog = UserSignLog.builder().signStatus(true).createTime(now).updateTime(now).userSignId(userSign.getId()).build();userSignLogRepository.save(userSignLog);return userSign.getSignCount();}}}/***** 用户每天第一次进入签到打卡页面初始化一下数据* @param userId*/@Transactional()public void init(Long userId) {UserSign userSign = userSignRepository.findUserSignByUserId(userId);Date now = new Date();//曾经签到过if (userSign != null) {//判断今天是否签到过if (userSign.getLastModifyTime().getTime() > getStartOfDay(now).getTime()&& userSign.getLastModifyTime().getTime() < getEndOfDay(now).getTime()) {System.out.println("用户今天已经签到过了，正常使用");return;}//判断昨天是否签到过Calendar calendar = Calendar.getInstance();calendar.setTime(now);calendar.add(Calendar.DATE, -1);if (userSign.getLastModifyTime().getTime() < getStartOfDay(calendar.getTime()).getTime()) {System.out.println("昨天没有签到");//昨天没有连续签到if (userSign.getSignCount() == 7) {System.out.println("签到次数为7的时候初始化数据");//初始化数据userSign.setSignCount(0);userSignLogRepository.updateUserSignLogSignStatus(userSign.getId());userSignRepository.save(userSign);return;}System.out.println("签到次正常");} else {System.out.println("昨天签到了");//昨天签到过if (userSign.getSignCount() == 7) {System.out.println("签到次数为7的时候初始化数据");//初始化数据userSign.setSignCount(0);userSignLogRepository.updateUserSignLogSignStatus(userSign.getId());userSignRepository.save(userSign);return;}System.out.println("签到次正常");}}}/*根据用户id查询签到list*/public List data(Long userId) {UserSign userSign = userSignRepository.findUserSignByUserId(userId);//没有签到过，返回nullif (userSign != null) {//如果今天签到过return userSignLogRepository.findUserSignLogsByUserSignIdAndSignStatusIsTrue(userSign.getId());}return new ArrayList<>();}public Boolean isOrSign(Long userId) {Date now = new Date();UserSign userSign = userSignRepository.findUserSignByUserId(userId);//没有签到过，返回null//如果今天签到过return userSign != null && userSign.getLastModifyTime().getTime() > getStartOfDay(now).getTime() && userSign.getLastModifyTime().getTime() < getEndOfDay(now).getTime();}/***** 获得某天最大时间 2019-05-09 23:59:59* @param date 日期* @return*/public static Date getEndOfDay(Date date) {LocalDateTime localDateTime = LocalDateTime.ofInstant(Instant.ofEpochMilli(date.getTime()), ZoneId.systemDefault());LocalDateTime endOfDay = localDateTime.with(LocalTime.MAX);return Date.from(endOfDay.atZone(ZoneId.systemDefault()).toInstant());}/***** 获得某天最小时间 2019-05-09 00:00:00* @param date 日期* @return*/public static Date getStartOfDay(Date date) {LocalDateTime localDateTime = LocalDateTime.ofInstant(Instant.ofEpochMilli(date.getTime()), ZoneId.systemDefault());LocalDateTime startOfDay = localDateTime.with(LocalTime.MIN);return Date.from(startOfDay.atZone(ZoneId.systemDefault()).toInstant());}}

接下来就是controller

@RestController
@RequestMapping("/sign")
@Api(tags = {"用户签到打卡API"})
public class UserSignController {private final UserSignService userSignService;@Autowiredpublic UserSignController(UserSignService userSignService) {this.userSignService = userSignService;}@ApiOperation(value = "用户签到")@PostMapping("/createSign")public List createSign(@RequestParam Long userId) {//首先要初始化数据userSignService.init(userId);userSignService.createSign(userId);return userSignService.data(userId);}@ApiOperation(value = "打卡数据")@GetMapping("/data")public List data(@RequestParam Long userId) {userSignService.init(userId);return userSignService.data(userId);}@ApiOperation(value = "判断今天是否已经打过卡")@GetMapping("/isOrSign")public Boolean isOrSign(@RequestParam Long userId) {return userSignService.isOrSign(userId);}}

本文来自互联网用户投稿，文章观点仅代表作者本人，不代表本站立场，不承担相关法律责任。如若转载，请注明出处。 如若内容造成侵权/违法违规/事实不符，请点击【内容举报】进行投诉反馈！