From 086a293cfc5fdf56cf25fc5989332ec40e319940 Mon Sep 17 00:00:00 2001
From: phpcjl <phpcjl@gmail.com>
Date: 星期二, 17 十二月 2024 14:03:41 +0800
Subject: [PATCH] 1
---
ruoyi-service/ruoyi-account/src/main/java/com/ruoyi/account/controller/UserPointController.java | 60 ++++++++++++++++++++++++++++++
ruoyi-service/ruoyi-other/src/main/resources/mapper/other/GoodsMapper.xml | 4 +
ruoyi-service/ruoyi-account/src/main/java/com/ruoyi/account/excel/UserPointEx.java | 38 +++++++++++++++++++
3 files changed, 101 insertions(+), 1 deletions(-)
diff --git a/ruoyi-service/ruoyi-account/src/main/java/com/ruoyi/account/controller/UserPointController.java b/ruoyi-service/ruoyi-account/src/main/java/com/ruoyi/account/controller/UserPointController.java
index 708193d..3b282f2 100644
--- a/ruoyi-service/ruoyi-account/src/main/java/com/ruoyi/account/controller/UserPointController.java
+++ b/ruoyi-service/ruoyi-account/src/main/java/com/ruoyi/account/controller/UserPointController.java
@@ -4,6 +4,7 @@
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.ruoyi.account.api.model.UserPoint;
+import com.ruoyi.account.excel.UserPointEx;
import com.ruoyi.account.service.AppUserService;
import com.ruoyi.account.service.UserPointService;
import com.ruoyi.account.vo.CommissionStatistics;
@@ -29,6 +30,8 @@
import java.time.LocalDateTime;
import java.time.LocalTime;
import java.time.YearMonth;
+import java.time.format.DateTimeFormatter;
+import java.util.ArrayList;
import java.util.List;
/**
@@ -159,6 +162,63 @@
return R.ok(commissionStatistics);
}
+ /**
+ * 导出用户分佣统计
+ */
+ @GetMapping("/commissionExport")
+ @ApiOperation(value = "用户分佣统计导出", tags = "管理后台-财务统计-用户分佣统计")
+ public void commissionExport(HttpServletResponse response, UserPoint userPoint) {
+ userPoint.setType(2);
+ IPage<UserPoint> userPointPage = userPointService.getUserPointPage(Page.of(1, Integer.MAX_VALUE), userPoint);
+ List<UserPoint> userPointList = userPointPage.getRecords();
+ List<UserPointEx> userPointExList = new ArrayList<>();
+ for (UserPoint point : userPointList) {
+ UserPointEx userPointEx = new UserPointEx();
+ userPointEx.setUserName(point.getUserName());
+ userPointEx.setPhone(point.getPhone());
+ userPointEx.setChangeTime(point.getCreateTime().format(DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss")));
+ userPointEx.setChangeNum(point.getVariablePoint().toString());
+ Integer type = point.getType();
+ switch (type) {
+ case 1:
+ userPointEx.setType("消费积分");
+ break;
+ case 2:
+ userPointEx.setType("返佣积分");
+ break;
+ case 3:
+ userPointEx.setType("拉新人积分");
+ break;
+ case 4:
+ userPointEx.setType("兑换商品");
+ break;
+ case 5:
+ userPointEx.setType("门店业绩");
+ break;
+ case 6:
+ userPointEx.setType("门店返佣");
+ break;
+ case 7:
+ userPointEx.setType("技师业绩");
+ break;
+ case 8:
+ userPointEx.setType("转赠积分");
+ break;
+ case 9:
+ userPointEx.setType("做工积分");
+ break;
+ case 10:
+ userPointEx.setType("注册积分");
+ break;
+ default:
+ userPointEx.setType("未知积分");
+ }
+ userPointExList.add(userPointEx);
+ }
+ ExcelUtil<UserPointEx> util = new ExcelUtil<>(UserPointEx.class);
+ util.exportExcel(response, userPointExList, "用户分佣统计");
+ }
+
}
diff --git a/ruoyi-service/ruoyi-account/src/main/java/com/ruoyi/account/excel/UserPointEx.java b/ruoyi-service/ruoyi-account/src/main/java/com/ruoyi/account/excel/UserPointEx.java
new file mode 100644
index 0000000..7932861
--- /dev/null
+++ b/ruoyi-service/ruoyi-account/src/main/java/com/ruoyi/account/excel/UserPointEx.java
@@ -0,0 +1,38 @@
+package com.ruoyi.account.excel;
+
+import com.ruoyi.common.core.annotation.Excel;
+import lombok.Data;
+
+@Data
+public class UserPointEx {
+
+ /**
+ * 用户名称
+ */
+ @Excel(name = "用户名称")
+ private String userName;
+
+ /**
+ * 联系电话
+ */
+ @Excel(name = "联系电话")
+ private String phone;
+
+ /**
+ * 变更类型
+ */
+ @Excel(name = "变更类型")
+ private String type;
+
+ /**
+ * 变更时间
+ */
+ @Excel(name = "变更时间")
+ private String changeTime;
+
+ /**
+ * 变更数量
+ */
+ @Excel(name = "变更数量")
+ private String changeNum;
+}
diff --git a/ruoyi-service/ruoyi-other/src/main/resources/mapper/other/GoodsMapper.xml b/ruoyi-service/ruoyi-other/src/main/resources/mapper/other/GoodsMapper.xml
index da58bb9..303a37e 100644
--- a/ruoyi-service/ruoyi-other/src/main/resources/mapper/other/GoodsMapper.xml
+++ b/ruoyi-service/ruoyi-other/src/main/resources/mapper/other/GoodsMapper.xml
@@ -33,7 +33,9 @@
tg.shop_cost,
tg.`status`,
tg.purchase_limit,
- tg.sale_num
+ tg.sale_num,
+ tg.cash_payment,
+ tg.point_payment
FROM
t_goods tg
LEFT JOIN t_goods_category tgc ON tg.goods_category_id = tgc.id
--
Gitblit v1.7.1