基于 SpringBoot + Vue的学生服务平台设计与实现（源码+数据库+文档+部署讲 - ToB企服应用市场:ToB评测及商务社交产业平台

@GetMapping("page")
public ApiRes page() {
ApplyRefundDeposit reqParams = getObject(ApplyRefundDeposit.class);
LambdaQueryWrapper<ApplyRefundDeposit> lambdaQueryWrapper = new LambdaQueryWrapper();
lambdaQueryWrapper.eq(StringUtils.isNotBlank(reqParams.getMchNo()), ApplyRefundDeposit::getMchNo, reqParams.getMchNo());
lambdaQueryWrapper.eq(StringUtils.isNotBlank(reqParams.getMerchantName()), ApplyRefundDeposit::getMerchantName, reqParams.getMerchantName());
lambdaQueryWrapper.eq(StringUtils.isNotBlank(reqParams.getChannelNo()), ApplyRefundDeposit::getChannelNo, reqParams.getChannelNo());
lambdaQueryWrapper.eq(null != reqParams.getApplyState(), ApplyRefundDeposit::getApplyState, reqParams.getApplyState());
lambdaQueryWrapper.orderByDesc(ApplyRefundDeposit::getApplyTime);
// 时间范围条件，1查询申请时间，2查询处理时间
String timeType = reqParams.buildTimeType();
if ("1".equals(timeType)) {
Date[] queryDateRangeArray = reqParams.buildQueryDateRange();
if (queryDateRangeArray[0] != null) {
lambdaQueryWrapper.ge(ApplyRefundDeposit::getApplyTime, queryDateRangeArray[0]);
}
if (queryDateRangeArray[1] != null) {
lambdaQueryWrapper.le(ApplyRefundDeposit::getApplyTime, queryDateRangeArray[1]);
}
} else {
Date[] queryDateRangeArray = reqParams.buildQueryDateRange();
if (queryDateRangeArray[0] != null) {
lambdaQueryWrapper.ge(ApplyRefundDeposit::getProcessTime, queryDateRangeArray[0]);
}
if (queryDateRangeArray[1] != null) {
lambdaQueryWrapper.le(ApplyRefundDeposit::getProcessTime, queryDateRangeArray[1]);
}
}
return ApiRes.ok(applyRefundDepositService.page(getIPage(true), lambdaQueryWrapper));
}

复制代码

CREATE TABLE `yonghu` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`yonghuming` varchar(200) NOT NULL COMMENT '用户名',
`mima` varchar(200) NOT NULL COMMENT '密码',
`xingming` varchar(200) DEFAULT NULL COMMENT '姓名',
`xingbie` varchar(200) DEFAULT NULL COMMENT '性别',
`touxiang` varchar(200) DEFAULT NULL COMMENT '头像',
`shouji` varchar(200) DEFAULT NULL COMMENT '手机',
`shenfenzheng` varchar(200) DEFAULT NULL COMMENT '身份证',
PRIMARY KEY (`id`),
UNIQUE KEY `yonghuming` (`yonghuming`)
) ENGINE=InnoDB AUTO_INCREMENT=1616222324596 DEFAULT CHARSET=utf8mb3 COMMENT='用户';
CREATE TABLE `messages` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`userid` bigint NOT NULL COMMENT '留言人id',
`username` varchar(200) DEFAULT NULL COMMENT '用户名',
`content` longtext NOT NULL COMMENT '留言内容',
`reply` longtext COMMENT '回复内容',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1616222424131 DEFAULT CHARSET=utf8mb3 COMMENT='留言板';
CREATE TABLE `token` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
`userid` bigint NOT NULL COMMENT '用户id',
`username` varchar(100) NOT NULL COMMENT '用户名',
`tablename` varchar(100) DEFAULT NULL COMMENT '表名',
`role` varchar(100) DEFAULT NULL COMMENT '角色',
`token` varchar(200) NOT NULL COMMENT '密码',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '新增时间',
`expiratedtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '过期时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb3 COMMENT='token表';

复制代码