From 83751617ac342e4168cb714106bc009e3f25f99c Mon Sep 17 00:00:00 2001
From: phpcjl <phpcjl@gmail.com>
Date: 星期三, 18 十二月 2024 09:32:02 +0800
Subject: [PATCH] 1

---
 ruoyi-service/ruoyi-account/src/main/java/com/ruoyi/account/controller/BalanceChangeRecordController.java |   83 +++++++++++++++++++++++++++++++++++++++--
 1 files changed, 79 insertions(+), 4 deletions(-)

diff --git a/ruoyi-service/ruoyi-account/src/main/java/com/ruoyi/account/controller/BalanceChangeRecordController.java b/ruoyi-service/ruoyi-account/src/main/java/com/ruoyi/account/controller/BalanceChangeRecordController.java
index eb01dad..e43b425 100644
--- a/ruoyi-service/ruoyi-account/src/main/java/com/ruoyi/account/controller/BalanceChangeRecordController.java
+++ b/ruoyi-service/ruoyi-account/src/main/java/com/ruoyi/account/controller/BalanceChangeRecordController.java
@@ -1,14 +1,23 @@
 package com.ruoyi.account.controller;
 
+import com.baomidou.mybatisplus.core.metadata.IPage;
+import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
 import com.ruoyi.account.api.model.BalanceChangeRecord;
+import com.ruoyi.account.dto.BalanceQuery;
+import com.ruoyi.account.excel.BalanceChangeRecordEX;
 import com.ruoyi.account.service.BalanceChangeRecordService;
+import com.ruoyi.account.vo.CommissionStatistics;
 import com.ruoyi.common.core.domain.R;
-import org.springframework.web.bind.annotation.PostMapping;
-import org.springframework.web.bind.annotation.RequestBody;
-import org.springframework.web.bind.annotation.RequestMapping;
-import org.springframework.web.bind.annotation.RestController;
+import com.ruoyi.common.core.utils.poi.ExcelUtil;
+import io.swagger.annotations.ApiOperation;
+import io.swagger.annotations.ApiParam;
+import org.springframework.web.bind.annotation.*;
 
 import javax.annotation.Resource;
+import javax.servlet.http.HttpServletResponse;
+import java.time.format.DateTimeFormatter;
+import java.util.ArrayList;
+import java.util.List;
 
 /**
  * @author zhibing.pu
@@ -32,6 +41,72 @@
 		balanceChangeRecordService.save(balanceChangeRecord);
 		return R.ok();
 	}
+
+	@PostMapping("/page")
+	@ApiOperation(value = "余额变更明细", tags = {"后台"})
+	public R<IPage<BalanceChangeRecord>> page(@RequestBody BalanceQuery agentQuery) {
+
+		return R.ok(balanceChangeRecordService.pageList(agentQuery));
+	}
+
+	/**
+	 * 用户分佣统计
+	 */
+	@GetMapping("/commissionStatistics")
+	@ApiOperation(value = "用户分佣统计", tags = "管理后台-财务统计-用户分佣统计")
+	public R<CommissionStatistics> commissionStatistics(@ApiParam("页码") @RequestParam Integer pageNum,
+														@ApiParam("每一页数据大小") Integer pageSize,
+														BalanceChangeRecord balanceChangeRecord) {
+		CommissionStatistics commissionStatistics1 = balanceChangeRecordService.commissionStatistics(Page.of(pageNum, pageSize), balanceChangeRecord);
+		return R.ok(commissionStatistics1);
+	}
+//
+//	/**
+//	 * 导出用户分佣统计
+//	 */
+	@GetMapping("/commissionExport")
+	@ApiOperation(value = "用户分佣统计导出", tags = "管理后台-财务统计-用户分佣统计")
+	public void commissionExport(HttpServletResponse response, BalanceChangeRecord balanceChangeRecord) {
+		CommissionStatistics commissionStatistics1 = balanceChangeRecordService.commissionStatistics(Page.of(1, Integer.MAX_VALUE), balanceChangeRecord);
+		IPage<BalanceChangeRecord> userPointPage = commissionStatistics1.getUserPointPage();
+		List<BalanceChangeRecord> userPointList = userPointPage.getRecords();
+		List<BalanceChangeRecordEX> userPointExList = new ArrayList<>();
+		for (BalanceChangeRecord balanceChangeRecord1 : userPointList) {
+			BalanceChangeRecordEX balanceChangeRecordEX = new BalanceChangeRecordEX();
+			balanceChangeRecordEX.setUserName(balanceChangeRecord1.getUserName());
+			balanceChangeRecordEX.setPhone(balanceChangeRecord1.getUserPhone());
+			balanceChangeRecordEX.setChangeTime(balanceChangeRecord1.getCreateTime().format(DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss")));
+			balanceChangeRecordEX.setChangeNum(balanceChangeRecord1.getAfterAmount().toString());
+			Integer type = balanceChangeRecord1.getChangeType();
+			// 类型:1充值2提现3红包4分佣5商城购物6订单取消回退
+			switch (type) {
+				case 1:
+					balanceChangeRecordEX.setType("充值");
+					break;
+				case 2:
+					balanceChangeRecordEX.setType("提现");
+					break;
+				case 3:
+					balanceChangeRecordEX.setType("红包");
+					break;
+				case 4:
+					balanceChangeRecordEX.setType("分佣");
+					break;
+				case 5:
+					balanceChangeRecordEX.setType("商城购物");
+					break;
+				case 6:
+					balanceChangeRecordEX.setType("订单取消回退");
+					break;
+				default:
+					balanceChangeRecordEX.setType("未知积分");
+			}
+			userPointExList.add(balanceChangeRecordEX);
+		}
+		ExcelUtil<BalanceChangeRecordEX> util = new ExcelUtil<>(BalanceChangeRecordEX.class);
+		util.exportExcel(response, userPointExList, "用户分佣统计");
+	}
+
 	
 	
 }

--
Gitblit v1.7.1