From c3fb56bd3cc141875b3ff2a6b893e9cbca0d11a9 Mon Sep 17 00:00:00 2001
From: KKSU <15274802129@163.com>
Date: Wed, 01 Nov 2023 17:15:38 +0800
Subject: [PATCH] 用户收益列表
---
src/main/resources/templates/febs/views/modules/chat/chatWithDrawList.html | 3 ++-
src/main/java/cc/mrbird/febs/mall/vo/AdminChatWithDrawVo.java | 1 +
src/main/resources/mapper/modules/ChatUserMapper.xml | 8 ++++++++
3 files changed, 11 insertions(+), 1 deletions(-)
diff --git a/src/main/java/cc/mrbird/febs/mall/vo/AdminChatWithDrawVo.java b/src/main/java/cc/mrbird/febs/mall/vo/AdminChatWithDrawVo.java
index ca7f587..5257001 100644
--- a/src/main/java/cc/mrbird/febs/mall/vo/AdminChatWithDrawVo.java
+++ b/src/main/java/cc/mrbird/febs/mall/vo/AdminChatWithDrawVo.java
@@ -21,6 +21,7 @@
* 提现金额
*/
private BigDecimal amount;
+ private BigDecimal amountUSDT;
private BigDecimal fee;
/**
* 1：内转 2：外转提现
diff --git a/src/main/resources/mapper/modules/ChatUserMapper.xml b/src/main/resources/mapper/modules/ChatUserMapper.xml
index db8bda4..d0d84f6 100644
--- a/src/main/resources/mapper/modules/ChatUserMapper.xml
+++ b/src/main/resources/mapper/modules/ChatUserMapper.xml
@@ -183,6 +183,14 @@
b.phone phone,
a.id id,
(a.amount - a.fee) amount,
+ CASE
+ WHEN a.type = 1 THEN NULL
+ ELSE
+ FORMAT(
+ (a.amount - a.fee) / ( SELECT VALUE FROM data_dictionary WHERE type = 'USDT_TIME' AND CODE = 'USDT_TIME' ),
+ 2
+ )
+ END AS amountUSDT,
a.type type,
a.address address,
a.address_type addressType,
diff --git a/src/main/resources/templates/febs/views/modules/chat/chatWithDrawList.html b/src/main/resources/templates/febs/views/modules/chat/chatWithDrawList.html
index 7991778..6f36a83 100644
--- a/src/main/resources/templates/febs/views/modules/chat/chatWithDrawList.html
+++ b/src/main/resources/templates/febs/views/modules/chat/chatWithDrawList.html
@@ -161,8 +161,9 @@
{field: 'id', title: '', minWidth: 150,align:'center', totalRowText: '合计：',align:'center'},
{field: 'phone', title: '电话号码', minWidth: 150,align:'center'},
{field: 'nickName', title: '昵称', minWidth: 150,align:'center'},
+ {field: 'amount', title: '人民币金额', minWidth: 100,align:'center',align:'center',totalRow: '{{= parseInt(d.amount) }}'},
{field: 'addressType', title: '公链', minWidth: 150,align:'center'},
- {field: 'amount', title: '金额', minWidth: 100,align:'center',align:'center',totalRow: '{{= parseInt(d.amount) }}'},
+ {field: 'amountUSDT', title: 'USDT金额', minWidth: 100,align:'center',align:'center',totalRow: '{{= parseInt(d.amountUSDT) }}'},
{field: 'type', title: '类型',
templet: function (d) {
if (d.type === 1) {
--
Gitblit v1.9.1