ruoyi-service/ruoyi-account/src/main/java/com/ruoyi/account/controller/BalanceChangeRecordController.java
@@ -7,6 +7,7 @@ import com.ruoyi.account.service.BalanceChangeRecordService; import com.ruoyi.account.vo.CommissionStatistics; import com.ruoyi.account.vo.WalletStatistics; import com.ruoyi.account.vo.WalletStatisticsDetail; import com.ruoyi.common.core.domain.R; import com.ruoyi.common.core.utils.poi.ExcelUtil; import io.swagger.annotations.ApiOperation; @@ -87,5 +88,18 @@ return R.ok(walletStatistics); } /** * 钱包统计导出 */ @GetMapping("/walletExport") @ApiOperation(value = "钱包统计导出", tags = "管理后台-财务统计-钱包统计") public void walletExport(HttpServletResponse response, BalanceChangeRecord balanceChangeRecord) { WalletStatistics walletStatistics = balanceChangeRecordService.walletStatistics(Page.of(1, Integer.MAX_VALUE), balanceChangeRecord); IPage<WalletStatisticsDetail> userPointPage = walletStatistics.getPage(); List<WalletStatisticsDetail> userPointList = userPointPage.getRecords(); ExcelUtil<WalletStatisticsDetail> util = new ExcelUtil<>(WalletStatisticsDetail.class); util.exportExcel(response, userPointList, "钱包统计"); } } ruoyi-service/ruoyi-account/src/main/java/com/ruoyi/account/vo/WalletStatisticsDetail.java
@@ -15,18 +15,21 @@ * 门店名称 */ @ApiModelProperty(value = "门店名称") @Excel(name = "门店名称") private String shopName; /** * 用户姓名 */ @ApiModelProperty(value = "用户姓名") @Excel(name = "用户姓名") private String userName; /** * 联系电话 */ @ApiModelProperty(value = "联系电话") @Excel(name = "联系电话") private String userPhone; @ApiModelProperty("类型:1充值2提现3红包4分佣5商城购物6订单取消回退7门店提现") @@ -39,11 +42,13 @@ @ApiModelProperty(value = "变更时间") @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss") @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss") @Excel(name = "变更时间", width = 30, dateFormat = "yyyy-MM-dd HH:mm:ss") private LocalDateTime createTime; /** * 变更数量 */ @ApiModelProperty(value = "变更数量") @Excel(name = "变更数量") private BigDecimal changeAmount; }