From aabdaea1acc49023ac3802d15feb56c8dd5f8042 Mon Sep 17 00:00:00 2001
From: zj <1772600164@qq.com>
Date: Fri, 23 Aug 2024 02:21:18 +0800
Subject: [PATCH] 1
---
src/main/java/project/web/api/UserWalletAddressController.java | 27 ++++++++++++++++++++++++---
1 files changed, 24 insertions(+), 3 deletions(-)
diff --git a/src/main/java/project/web/api/UserWalletAddressController.java b/src/main/java/project/web/api/UserWalletAddressController.java
index 442bc5e..d33b6e9 100644
--- a/src/main/java/project/web/api/UserWalletAddressController.java
+++ b/src/main/java/project/web/api/UserWalletAddressController.java
@@ -9,7 +9,9 @@
import kernel.exception.BusinessException;
import kernel.util.StringUtils;
+import kernel.web.ApplicationUtil;
import kernel.web.Page;
+import kernel.web.PagedQueryDao;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.beans.factory.annotation.Autowired;
@@ -45,8 +47,6 @@
private final String action = "/api/user!";
- @Autowired
- private AdminChannelBlockchainService adminChannelBlockchainService;
/**
* 未生成钱包地址的用户
@@ -94,7 +94,7 @@
int pageSize=300;
try {
pageNo=checkAndSetPageNo(pageNoStr);
- page = this.adminChannelBlockchainService.pagedQuery(pageNo, pageSize, name_para, coin_para);
+ page = pagedQuery(pageNo, pageSize, name_para, coin_para);
} catch (BusinessException e) {
logger.error(" error ", e);
resultObject.setCode("1");
@@ -146,4 +146,25 @@
}
}
+ public Page pagedQuery(int pageNo, int pageSize, String name_para, String coin_para) {
+ PagedQueryDao pagedQueryDao = ApplicationUtil.getBean(PagedQueryDao.class);
+ StringBuffer queryString = new StringBuffer(
+ " SELECT channelblockchain.UUID id,channelblockchain.BLOCKCHAIN_NAME blockchain_name,"
+ + "channelblockchain.IMG img ,channelblockchain.COIN coin, "
+ + " channelblockchain.ADDRESS address ");
+
+ queryString.append(" FROM T_CHANNEL_BLOCKCHAIN channelblockchain WHERE 1 = 1 ");
+ Map<String, Object> parameters = new HashMap<>();
+ if (!StringUtils.isNullOrEmpty(name_para)) {
+ queryString.append(" and channelblockchain.BLOCKCHAIN_NAME like :name ");
+ parameters.put("name", "%" + name_para + "%");
+ }
+ if (!StringUtils.isNullOrEmpty(coin_para)) {
+ queryString.append(" and channelblockchain.COIN like :coin ");
+ parameters.put("coin", "%" + coin_para + "%");
+ }
+ Page page = pagedQueryDao.pagedQuerySQL(pageNo, pageSize, queryString.toString(), parameters);
+ return page;
+ }
+
}
--
Gitblit v1.9.3