From e691bc7820d1fc7fdb2519ea6ebdedd2b464b91d Mon Sep 17 00:00:00 2001 From: Helius <wangdoubleone@gmail.com> Date: Tue, 03 Nov 2020 11:34:25 +0800 Subject: [PATCH] modify --- src/main/java/com/xcong/excoin/modules/member/entity/TdCoinWallet.java | 73 ++++++++++++++++++ src/main/java/com/xcong/excoin/modules/member/service/impl/MemberServiceImpl.java | 3 src/main/resources/mapper/member/MemberCoinAddressDao.xml | 5 + src/main/resources/application-coin.yml | 114 ++++++++++++++++++++++++++++ src/main/resources/application-prod.yml | 2 src/main/java/com/xcong/excoin/modules/member/dao/MemberCoinAddressDao.java | 3 src/main/resources/application.yml | 2 7 files changed, 199 insertions(+), 3 deletions(-) diff --git a/src/main/java/com/xcong/excoin/modules/member/dao/MemberCoinAddressDao.java b/src/main/java/com/xcong/excoin/modules/member/dao/MemberCoinAddressDao.java index baf9016..27616b3 100644 --- a/src/main/java/com/xcong/excoin/modules/member/dao/MemberCoinAddressDao.java +++ b/src/main/java/com/xcong/excoin/modules/member/dao/MemberCoinAddressDao.java @@ -2,6 +2,7 @@ import java.util.List; +import com.xcong.excoin.modules.member.entity.TdCoinWallet; import org.apache.ibatis.annotations.Param; import com.baomidou.mybatisplus.core.mapper.BaseMapper; @@ -25,4 +26,6 @@ List<String> selectAllSymbolAddress(@Param("symbol")String symbol,@Param("tag") String tag); + TdCoinWallet selectTdCoinWalletByAddress(@Param("address") String address, @Param("symbol") String symbol); + } diff --git a/src/main/java/com/xcong/excoin/modules/member/entity/TdCoinWallet.java b/src/main/java/com/xcong/excoin/modules/member/entity/TdCoinWallet.java new file mode 100644 index 0000000..698b1f5 --- /dev/null +++ b/src/main/java/com/xcong/excoin/modules/member/entity/TdCoinWallet.java @@ -0,0 +1,73 @@ +package com.xcong.excoin.modules.member.entity; + +import com.baomidou.mybatisplus.annotation.IdType; +import com.baomidou.mybatisplus.annotation.TableField; +import com.baomidou.mybatisplus.annotation.TableId; +import com.baomidou.mybatisplus.annotation.TableName; +import lombok.Data; + +import java.math.BigDecimal; + +/** + * 会员资产表 Entity + * + * @author MrBird + * @date 2020-09-26 19:21:08 + */ +@Data +@TableName("td_coin_wallet") +public class TdCoinWallet { + + /** + * 主键 + */ + @TableId(value = "id", type = IdType.AUTO) + private Long id; + + /** + * 会员ID + */ + @TableField("mem_id") + private Long memId; + + /** + * 地址 + */ + @TableField("address") + private String address; + + /** + * 币种 + */ + @TableField("symbol") + private String symbol; + + /** + * 私钥 + */ + @TableField("private_key") + private String privateKey; + + /** + * 币种细类 + */ + @TableField("tag") + private String tag; + + /** + * 用户标识 + */ + @TableField("mem_code") + private String memCode; + + /** + * 可用余额 + */ + @TableField("available_balance") + private BigDecimal availableBalance; + /** + * 冻结金额 + */ + @TableField("frozen_balance") + private BigDecimal frozenBalance; +} diff --git a/src/main/java/com/xcong/excoin/modules/member/service/impl/MemberServiceImpl.java b/src/main/java/com/xcong/excoin/modules/member/service/impl/MemberServiceImpl.java index 7e350ff..7c3ef40 100644 --- a/src/main/java/com/xcong/excoin/modules/member/service/impl/MemberServiceImpl.java +++ b/src/main/java/com/xcong/excoin/modules/member/service/impl/MemberServiceImpl.java @@ -922,7 +922,8 @@ columnMap.put("address", memberSubmitCoinApplyDto.getAddress()); columnMap.put("is_biyict", MemberCoinAddressEntity.IS_BIYICT_YES); List<MemberCoinAddressEntity> selectByMap = memberCoinAddressDao.selectByMap(columnMap); - if (CollUtil.isEmpty(selectByMap)) { + TdCoinWallet tdCoinWallet = memberCoinAddressDao.selectTdCoinWalletByAddress(memberSubmitCoinApplyDto.getAddress(), CoinTypeEnum.USDT.name()); + if (CollUtil.isEmpty(selectByMap) && tdCoinWallet == null) { memberCoinWithdrawEntity.setIsInside(MemberCoinWithdrawEntity.ISINSIDE_NO); } else { memberCoinWithdrawEntity.setIsInside(MemberCoinWithdrawEntity.ISINSIDE_YES); diff --git a/src/main/resources/application-coin.yml b/src/main/resources/application-coin.yml new file mode 100644 index 0000000..550317f --- /dev/null +++ b/src/main/resources/application-coin.yml @@ -0,0 +1,114 @@ +server: + port: 8888 + servlet: + context-path: / + +spring: + profiles: + active: dayline + datasource: + url: jdbc:mysql://180.215.221.145:3306/db_pilot?useUnicode=true&characterEncoding=utf-8&useSSL=false&serverTimezone=GMT%2b8 + username: pilot + password: pilot123!@# + driver-class-name: com.mysql.jdbc.Driver + type: com.alibaba.druid.pool.DruidDataSource + druid: + initial-size: ${spring_datasource_druid_initial_size:10} + max-active: ${spring_datasource_druid_max_active:20} + min-idle: ${spring_datasource_druid_min_idle:3} + #配置获取连接等待超时的时间 + max-wait: 60000 + pool-prepared-statements: true + max-pool-prepared-statement-per-connection-size: 20 + validation-query: SELECT 'x' + test-on-borrow: true + test-on-return: true + test-while-idle: true + #配置间隔多久才进行一次检测,检测需要关闭的空闲连接,单位是毫秒 + time-between-eviction-runs-millis: 60000 + #配置一个连接在池中最小生存的时间,单位是毫秒 + min-evictable-idle-time-millis: 300000 + #spring.datasource.druid.max-evguide.ftlictable-idle-time-millis= + filters: stat,wall + stat-view-servlet: + # 默认true 内置监控页面首页/druid/index.html + enabled: true + url-pattern: /druid/* + # 允许清空统计数据 + reset-enable: true + login-username: root + login-password: 123456 + # IP白名单 多个逗号分隔 + allow: ${spring_datasource_stat_view_servlet_allow:} + # IP黑名单 + deny: ${spring_datasource_stat_view_servlet_deny:} + ## 国际化配置 + messages: + basename: i18n/messages + ## redis配置 + redis: + ## Redis数据库索引(默认为0) + database: 0 + ## Redis服务器地址 + host: 180.215.221.145 + ## Redis服务器连接端口 + port: 6379 + ## Redis服务器连接密码(默认为空) + password: pilot123!@# + jedis: + pool: + ## 连接池最大连接数(使用负值表示没有限制) + #spring.redis.pool.max-active=8 + max-active: 300 + ## 连接池最大阻塞等待时间(使用负值表示没有限制) + #spring.redis.pool.max-wait=-1 + max-wait: -1 + ## 连接池中的最大空闲连接 + #spring.redis.pool.max-idle=8 + max-idle: 100 + ## 连接池中的最小空闲连接 + #spring.redis.pool.min-idle=0 + min-idle: 8 + ## 连接超时时间(毫秒) + timeout: 30000 + rabbitmq: + host: 27.124.4.94 + port: 5672 + username: pilot + password: pilot123 + publisher-confirm-type: correlated + + +#custom: +# rabbitmq: +# host: 120.27.238.55 +# port: 5672 +# username: ct_rabbit +# password: 123456 + +mybatis-plus: + mapper-locations: classpath:mapper/**/*.xml + + +app: + debug: false + redis_expire: 3000 + kline-update-job: false + newest-price-update-job: false + exchange-trade: false + day-line: false + other-job: false + loop-job: false + rabbit-consumer: false + block-job: true + +aliyun: + oss: + end-point: https://oss-cn-hangzhou.aliyuncs.com + bucket-name: https://excoin.oss-cn-hangzhou.aliyuncs.com + access-key-id: LTAI4GBuydqbJ5bTsDP97Lpd + access-key-secret: vbCjQtPxABWjqtUlQfzjlA0qAY96fh + +rsa: + public_key: MIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQCCf8UFZK54AiK4PRu7tNd+Z8qZ77o/QXCnk25DRmygVpOEu5mGNSAvfnWmKp2pEV2RljeXq3Rid/+LQkonaebMJeXKSF0yxL/VgyeT8JaQ5gNbOrdfdlc+mFkXJyzyJt8YkvApEdPRNSU2ENBn7mgRfD0BYPM4vZ6/rv+de38FJwIDAQAB + private_key: MIICdgIBADANBgkqhkiG9w0BAQEFAASCAmAwggJcAgEAAoGBAIJ/xQVkrngCIrg9G7u0135nypnvuj9BcKeTbkNGbKBWk4S7mYY1IC9+daYqnakRXZGWN5erdGJ3/4tCSidp5swl5cpIXTLEv9WDJ5PwlpDmA1s6t192Vz6YWRcnLPIm3xiS8CkR09E1JTYQ0GfuaBF8PQFg8zi9nr+u/517fwUnAgMBAAECgYBhPt9NvpI4wbanvnndLczr2GJkxfzvSE+vwLCJF4C5FusFHVsxZINggQcg1V75bwRgCiXRMyYefreCSdrCditS43PzTOmE4RRrpxLlm8oubJc0C98LQ2qlN9AsUqL5IHpVGgbHDyWAwjc1GBID6nwXKpxq1/VodFqhahG9D5EZsQJBALnkb+5VTxQbiyQI4Uc9NIvAyVcNY1OisbvY6tvNgdBbJkADgAb78M1HWxxYjUqsvzggNHc7cWqWBHMgpnJaqm8CQQCztze4D7uAk7OC9MJHY5eE980J8Kk+GEZKxz4LahzU6V6dcb9GFac3wEtgilj/tOAn9y0/Q8sm9vvCIbMDzgzJAkEAqRYcqhF26LdVDOX25DHMBgLKISDQZFbsjA13M4/usHL4i+mjHrc0BcUOHu59NpuDI65HitzLAUSLr5zXSdUmiQJAW77wOg4GCejdXsB3IhzMsHwU97sdm26nC+vVV9xvJZ6Rx8zW+f9543NOx9U5BCmhuaVtOvvwDU9PTVcI3atmSQJAXAIJ5gGdtXx0DXiX4VvzNFHqgaqHMGvXyjNVkU2FYQbSAd2A6app4uRO+BkZu9dSjh14m+oXMnV2HzAN2rRnjA== diff --git a/src/main/resources/application-prod.yml b/src/main/resources/application-prod.yml index 5645a0d..2276275 100644 --- a/src/main/resources/application-prod.yml +++ b/src/main/resources/application-prod.yml @@ -100,7 +100,7 @@ other-job: true loop-job: false rabbit-consumer: false - block-job: true + block-job: false aliyun: oss: diff --git a/src/main/resources/application.yml b/src/main/resources/application.yml index e2bd03d..c873d74 100644 --- a/src/main/resources/application.yml +++ b/src/main/resources/application.yml @@ -95,7 +95,7 @@ redis_expire: 3000 kline-update-job: false newest-price-update-job: false - exchange-trade: true + exchange-trade: false day-line: false other-job: false loop-job: false diff --git a/src/main/resources/mapper/member/MemberCoinAddressDao.xml b/src/main/resources/mapper/member/MemberCoinAddressDao.xml index 0dc07a9..ca68502 100644 --- a/src/main/resources/mapper/member/MemberCoinAddressDao.xml +++ b/src/main/resources/mapper/member/MemberCoinAddressDao.xml @@ -88,4 +88,9 @@ and tag = #{tag} </if> </select> + + <select id="selectTdCoinWalletByAddress" resultType="com.xcong.excoin.modules.member.entity.TdCoinWallet"> + select * from td_coin_wallet + where address=#{address} and symbol=#{symbol} + </select> </mapper> \ No newline at end of file -- Gitblit v1.9.1