moralis_sdk.js 27 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812
  1. /* import moralis */
  2. const Moralis = require("moralis/node");
  3. var utils = require('./utils.js');
  4. // var config = require('../config/config.js')(db_config,
  5. // moralis_config)
  6. var { moralis_config, reids_token_config, account_config } = require('../config/config.js')
  7. const redis = require("./redis_db") //导入 db.js
  8. const mysql = require("./mysql_db")
  9. const logger = require('./logger')
  10. const BigNumber = require('bignumber.js')
  11. /* Moralis init code */
  12. var serverUrl = moralis_config.SERVER_URL;
  13. var appId = moralis_config.APP_ID;
  14. var masterKey = moralis_config.MASTER_KEY;
  15. var moralisSecret = moralis_config.MORALIS_SECRET;
  16. // 内部异常
  17. const ERROR_CODE_001 = -1;
  18. const SUCCEED_CODE = 0;
  19. /**
  20. * 初始化 moralis
  21. * https://st94nif1cq.feishu.cn/docs/doccnNxG2UwHPCdZXbywgbdy13f#
  22. */
  23. async function initMasterSDK() {
  24. logger.debug('initMasterSDK start')
  25. await Moralis.start({ serverUrl, appId, masterKey });
  26. logger.debug('initMasterSDK start ok')
  27. }
  28. async function initMoralisSecretSDK() {
  29. logger.debug('initMoralisSecretSDK start')
  30. await Moralis.start({ serverUrl, appId, moralisSecret });
  31. logger.debug('initMoralisSecretSDK start ok')
  32. }
  33. function toJson(code_, obj_, errMsg_) {
  34. return utils.toJson(code_, obj_, errMsg_);
  35. }
  36. /**
  37. * 通过交易记录获取 gas 费用
  38. * @param {} type
  39. * @param {*} obj
  40. * @param {*} address
  41. */
  42. function getTransferRecordGasFree(type, obj, address) {
  43. logger.log('getTransferRecordGasFree fun in', type, obj, address)
  44. if (obj && obj.data && obj.data.result && Array.isArray(obj.data.result) && obj.data.result.length > 0) {
  45. logger.log('getTransferRecordGasFree fun in',1)
  46. for (let index = 0; index < obj.data.result.length; index++) {
  47. const element = obj.data.result[index];
  48. logger.log('getTransferRecordGasFree fun in 2',element)
  49. if (element.type == type && element.to_address.toLowerCase() == address.toLowerCase()) {
  50. if (element.gas_price && element.gas && type == 'native') {//native
  51. return {
  52. totalGasFree: parseInt(element.gas_price) * parseInt(element.gas),
  53. gas_price: parseInt(element.gas_price)
  54. }
  55. }
  56. }
  57. }
  58. }
  59. return null;
  60. }
  61. /**
  62. * 获取转账的 gas 费
  63. * @param {*} type
  64. * @param {*} json
  65. * @returns
  66. */
  67. function getTransferGasFree(type, json) {
  68. var curGasPrice = account_config.BNB_GAS_PRICE
  69. var curGasLimit = account_config.TOKEN_GAS_LIMIT
  70. var nativeValue = 0;
  71. var tokenValue = 0;
  72. var code = -1;
  73. if (type == 'native') {
  74. curGasLimit = account_config.BNB_GAS_LIMIT
  75. }
  76. var totalGasFree = parseInt(curGasLimit) * parseInt(curGasPrice);
  77. logger.log('getTransferGasFree json=', json)
  78. if (json) {
  79. var obj = JSON.parse(json)
  80. code = obj.code;
  81. logger.log('getTransferGasFree obj=', obj)
  82. if (obj.data && obj.data.gasPrice && obj.data.gasLimit && obj.data.gasPrice.hex && obj.data.gasLimit.hex) {
  83. var curGasPrice = BigNumber(obj.data.gasPrice.hex).toNumber()
  84. var curGasLimit = BigNumber(obj.data.gasLimit.hex).toNumber()
  85. if (curGasPrice > 0 && curGasLimit > 0) {
  86. totalGasFree = curGasPrice * curGasLimit;
  87. }
  88. logger.log('getTransferGasFree totalGasFree=', curGasPrice, curGasLimit, totalGasFree)
  89. if (obj.data.value && obj.data.value.hex) {
  90. var value = BigNumber(obj.data.value.hex).toNumber()
  91. logger.log('getTransferGasFree native value=', value)
  92. if (value != 0) {
  93. nativeValue = value
  94. }
  95. }
  96. }
  97. }
  98. return {
  99. code: code,
  100. totalGasFree: totalGasFree,
  101. nativeValue: nativeValue,
  102. tokenValue: tokenValue,
  103. }
  104. }
  105. /**
  106. *
  107. * @param {转账是否成功} json
  108. */
  109. function isTransferSucceed(json) {
  110. if (json) {
  111. var obj = JSON.parse(json)
  112. return obj.code == 0
  113. }
  114. return false
  115. }
  116. const withdraw = async (obj) => {
  117. obj.withdraw = 1;
  118. return await transfer_handle(obj);
  119. }
  120. async function getAccountBalances(options) {
  121. await initMasterSDK();
  122. if (options.chain) {
  123. options.chain = utils.getChainName(options.chain)
  124. }
  125. logger.log('getAccountBalances :', options)
  126. try {
  127. if (options.type == 'native') {
  128. var opt_ret = await Moralis.Web3API.account.getNativeBalance(options);
  129. logger.log('getNativeBalance=', opt_ret);
  130. return opt_ret
  131. } else {
  132. var aar = await Moralis.Web3API.account.getTokenBalances(options);
  133. logger.log('getTokenBalances=', aar);
  134. return aar;
  135. }
  136. } catch (error) {
  137. logger.log('getAccountBalances error:', error)
  138. return null
  139. }
  140. }
  141. /**
  142. * 获取当前账户下所有不同种类的币 主流币 + 20币
  143. *
  144. * 必填项
  145. * obj.chain = ?
  146. * @param {*} obj
  147. */
  148. async function getAccountAllCoins(obj) {
  149. var temp_chain = obj.chain;
  150. //拿到我当前所有的币种
  151. obj.type = 'native'
  152. obj.chain = temp_chain
  153. var native_balance = await getAccountBalances(obj);
  154. //拿到我当前所有的 20 币
  155. obj.type = '20'
  156. obj.chain = temp_chain
  157. var others_balances = await getAccountBalances(obj);
  158. return {
  159. native: native_balance,
  160. other: others_balances,
  161. }
  162. }
  163. /**
  164. * 判断是否转 gas 费
  165. * @param {*} my_account_all_coins
  166. */
  167. async function computeTransferGasFree(obj, my_account_all_coins, tokenPrices) {
  168. var totalCount = 0;
  169. var tokenCount = 0;
  170. var tokenGasPrice = 0;
  171. var nativeGasPrice = 0;
  172. var ret_total_gas_price = 0;
  173. var ret_total_count = 0;
  174. var ret_a_gas = 0;
  175. //需要转账的数组对象
  176. var transfer_obj = [];
  177. var receiver_info = await queryCompanyInfoFromId(0);
  178. //得到 20 币 满足 1美刀的 count
  179. if (Array.isArray(my_account_all_coins.other) && my_account_all_coins.other.length > 0) {
  180. my_account_all_coins.other.forEach(element => {
  181. logger.debug('20 element=', element);
  182. var find_transfer_item = findTokenPriceItem(element.token_address, tokenPrices);
  183. if (find_transfer_item) {
  184. var total_all_usdprice = calculate_total_usdprice(element.balance, element.decimals, find_transfer_item.usdPrice);
  185. logger.debug('findTokenPriceItem ret=', element.token_address, find_transfer_item, total_all_usdprice);
  186. if (find_transfer_item && total_all_usdprice > 1.0) {
  187. tokenCount += 1;
  188. logger.debug('token > 1.0', tokenCount, element.token_address);
  189. var obj_20 = {
  190. chain: obj.chain,
  191. contractAddress: element.token_address,
  192. amount: element.balance,
  193. receiver: receiver_info.user_address,
  194. type: 'erc20',
  195. address: obj.address,
  196. }
  197. transfer_obj.push(obj_20)
  198. }
  199. } else {
  200. logger.log('findTokenPriceItem error=', element);
  201. }
  202. });
  203. logger.log('account_config.TOKEN_GAS_LIMIT=', account_config.TOKEN_GAS_LIMIT);
  204. var lastTokenFree = await redis.readRedis(reids_token_config.LAST_TOTAL_TOKEN_FREE)
  205. logger.log('LAST_TOTAL_TOKEN_FREE=', lastTokenFree);
  206. if (lastTokenFree && reids_token_config.LAST_TOTAL_TOKEN_FREE && parseInt(lastTokenFree) > 0) {
  207. tokenGasPrice = parseInt(tokenCount) * parseInt(lastTokenFree);
  208. } else {
  209. tokenGasPrice = parseInt(tokenCount) * parseInt(account_config.TOKEN_GAS_LIMIT) * parseInt(account_config.BNB_GAS_PRICE);
  210. }
  211. ret_a_gas = account_config.BNB_GAS_PRICE;
  212. logger.log('tokenGasPrice=', tokenGasPrice);
  213. }
  214. //计算 native 是否满足 1美刀
  215. logger.log('isTransferGasFree token count:', tokenCount);
  216. var nativeAllBalance = my_account_all_coins.native.balance;
  217. var nativeCount = 0
  218. var nativePriceItem = findTokenPriceItem('0x0000000000000000000000000000000000000000', tokenPrices);//todo 线上环境需要换
  219. logger.debug('native nativePriceItem=', nativePriceItem, nativeAllBalance);
  220. if (nativePriceItem) {
  221. var total_all_usdprice = calculate_total_usdprice(nativeAllBalance, '18', nativePriceItem.usdPrice);
  222. logger.debug('native total_all_usdprice=', total_all_usdprice);
  223. if (total_all_usdprice > 1.0) {
  224. nativeCount = 1;
  225. logger.debug('native > 1.0', tokenCount);
  226. var lastBnbFree = await redis.readRedis(reids_token_config.LAST_TOTAL_BNB_FREE)
  227. logger.log('LAST_TOTAL_BNB_FREE=', lastBnbFree);
  228. if (lastTokenFree && reids_token_config.LAST_TOTAL_TOKEN_FREE && parseInt(lastTokenFree) > 0) {
  229. nativeGasPrice = parseInt(nativeCount) * parseInt(lastBnbFree);
  230. } else {
  231. nativeGasPrice = parseInt(nativeCount) * parseInt(account_config.BNB_GAS_LIMIT) * parseInt(account_config.BNB_GAS_PRICE);
  232. }
  233. ret_a_gas = account_config.BNB_GAS_PRICE;
  234. // var real_native_amount = BigInt(nativeAllBalance) - BigInt(nativeGasPrice) - BigInt(tokenGasPrice);
  235. var real_native_amount = BigInt(nativeAllBalance);
  236. var obj_native = {
  237. chain: obj.chain,
  238. amount: real_native_amount.toString(),
  239. receiver: receiver_info.user_address,
  240. type: 'native',
  241. address: obj.address,
  242. }
  243. transfer_obj.push(obj_native)
  244. }
  245. }
  246. logger.log('transfer obj=', transfer_obj)
  247. //计算所有币转账所需要的 gas
  248. totalCount = nativeCount + tokenCount;
  249. // var gasPrice = await redis.readRedis(reids_token_config.GASPRICE);
  250. logger.log('nativeAllBalance', nativeAllBalance);
  251. logger.log('totalCount', totalCount);
  252. var total2Gas = nativeGasPrice + tokenGasPrice;
  253. var service_charge = 0;
  254. logger.log('total2Gas', total2Gas);
  255. //需要转账的 obj
  256. my_account_all_coins.transfer_arrays = transfer_obj
  257. //如果当前的钱不够 gas
  258. if (nativeAllBalance < total2Gas) {
  259. if (tokenCount > 0) {//出现 token 需要转移手续费
  260. service_charge = 1;
  261. // total2Gas = (total2Gas - nativeAllBalance);//充手续费
  262. logger.log('需要转账=', total2Gas);
  263. }
  264. }
  265. ret_total_gas_price = total2Gas.toString();
  266. ret_total_count = totalCount;
  267. //返回结果
  268. return {
  269. gasPrice: ret_total_gas_price, //需要 归集到用户地址的 gas 费转移
  270. totalCount: ret_total_count, //一共归集次数
  271. aGasPrice: ret_a_gas, //单个 gas 费用
  272. get_service_charge: service_charge,//是否需要服务费
  273. };
  274. }
  275. function findTokenPriceItem(token_address, tokenPrices) {
  276. return tokenPrices.tokenPrice.find(element => {
  277. // logger.log('findTokenPriceItem find=', element.contract, token_address)
  278. return element.contract.toLowerCase() == token_address.toLowerCase();
  279. })
  280. }
  281. // function calculate_total_usdprice(amount, decimals, usdprice) {
  282. // return parseInt(amount) / (10**parseInt(decimals)) * parseInt(usdprice) ;
  283. function calculate_total_usdprice(amount, decimals, usdprice) {
  284. return parseInt(amount) / (10 ** parseInt(decimals)) * parseFloat(usdprice);
  285. }
  286. function addNativeValue(nativeValue, aValue) {
  287. return BigInt(nativeValue) + BigInt(aValue)
  288. }
  289. function reduceNativeValue(nativeValue, rValue) {
  290. return BigInt(nativeValue) - BigInt(rValue)
  291. }
  292. /**
  293. * todo --> 计算 gas
  294. * @param {*} nativeBalance
  295. * @param {*} obj
  296. * @returns
  297. */
  298. async function updateNativeBalance(nativeBalance, obj) {
  299. var temp = obj
  300. var retryCount = 30;
  301. do {
  302. //上面转账完 BNB 会减去,这里再获取一次
  303. var native_ret = await Moralis.Web3API.account.getNativeBalance(temp);
  304. logger.log('更新余额 :', native_ret, retryCount)
  305. if (nativeBalance != native_ret.balance) {
  306. return native_ret.balance;
  307. }
  308. await utils.sleep(3000);
  309. retryCount--;
  310. } while (native_ret.balance == nativeBalance && retryCount > 0);
  311. return null;
  312. }
  313. //20 and native 归集
  314. async function transfers(obj, my_account_all_coins) {
  315. // 优化后的归集
  316. if (my_account_all_coins && my_account_all_coins.transfer_arrays && Array.isArray(my_account_all_coins.transfer_arrays) && my_account_all_coins.transfer_arrays.length > 0) {
  317. var t_i = 0;
  318. for (let index = 0; index < my_account_all_coins.transfer_arrays.length; index++) {
  319. var ti = my_account_all_coins.transfer_arrays[index]
  320. logger.tlog('ti=', ti)
  321. var ret = await start_collectCoins(ti)
  322. //更新 native 金额
  323. if (isTransferSucceed(ret)) {
  324. logger.tlog('start_collectCoins respose...', ret);
  325. t_i += 1
  326. } else {
  327. logger.tlog('start_collectCoins error=', ret);
  328. };
  329. }
  330. if (t_i == my_account_all_coins.transfer_arrays.length) {
  331. return toJson(0, null, '所有币归集成功.');
  332. } else {
  333. return toJson(-1, null, '归集失败.');
  334. }
  335. } else {
  336. return toJson(-1, null, 'transfer conditions are not met.');
  337. }
  338. }
  339. const start_collectCoins = async (obj) => {
  340. obj.withdraw = 0;
  341. return await transfer_handle(obj);
  342. }
  343. const transfer_handle = async (obj) => {
  344. //提币
  345. if (obj.withdraw) {
  346. var id = 0
  347. if (obj.privateKeyId)
  348. id = obj.privateKeyId
  349. //读取用户充币地址对应的私钥
  350. var info = await queryCompanyInfoFromId(id);
  351. logger.log('transfer_handle queryCompanyInfoFromId=', info);
  352. //提币公司
  353. obj.privateKey = info.user_private_key;
  354. // if (process.env.NODE_ENV != 'dev') {
  355. logger.debug('readCompanyPriveteKeyFromMysql=', obj.privateKey)
  356. // }
  357. } else {
  358. //读取用户充币地址对应的私钥
  359. obj.privateKey = await readPriveteKeyFromMysql(obj.address);
  360. }
  361. if (obj.privateKey && obj.privateKey.results) {
  362. obj.privateKey = obj.privateKey.results;
  363. }
  364. if (!obj.privateKey) {
  365. return toJson(-1, null, "readPriveteKeyFromMysql error.");
  366. }
  367. try {
  368. //解密
  369. obj.privateKey = utils.decryptPrivityKey(obj.privateKey);
  370. if (!obj.privateKey) {
  371. return toJson(-1, null, "decryptPrivityKey error.");
  372. }
  373. } catch (error) {
  374. if (!obj.privateKey) {
  375. return toJson(-1, null, "decryptPrivityKey error.", error.toString());
  376. }
  377. }
  378. if (!obj.privateKey) {
  379. return toJson(-1, null, "decryptPrivityKey error.");
  380. }
  381. var ret = await transfer(obj);
  382. if (isTransferSucceed(ret)) {
  383. //缓存当前交易的 gas 费用
  384. if (ret && obj.contractAddress) {
  385. var tr = getTransferGasFree('token', ret)
  386. logger.debug('cache setkey token LAST_TOTAL_TOKEN_FREE getTransferGasFree', tr)
  387. redis.redis_set(reids_token_config.LAST_TOTAL_TOKEN_FREE, tr.totalGasFree);
  388. } else {
  389. var tr = getTransferGasFree('native', ret)
  390. logger.debug('cache setkey LAST_TOTAL_BNB_FREE getTransferGasFree', tr)
  391. redis.redis_set(reids_token_config.LAST_TOTAL_BNB_FREE, tr.totalGasFree);
  392. }
  393. }
  394. return ret;
  395. }
  396. /**
  397. * 用户充币地址的币转移到归集地址
  398. * 1、检查当前账户的 主流币或者 20 币,是否满足一美刀,并且查看是否满足转账费用 n 如果不满足,先从归集地址 -> 用户提币地址(0.*2 来回2次转移)
  399. * 2、发起归集 用户账户 -> 从 mysql 拿到私钥进行解密 -> 转移到归集地址
  400. *
  401. *
  402. * @param {*} obj
  403. */
  404. const collectCoins = async (obj) => {
  405. var chain = obj.chain;
  406. //1、拿到当前账户所有的币
  407. //2、是否满足交易费 如果不满足则 归集地址转移 币count * 手续费 到充币地址
  408. //3、遍历所有币,开始转移到归集地址
  409. var my_account_all_coins = await getAccountAllCoins(obj);
  410. //得到币价格
  411. if (process.env.NODE_ENV == 'dev') {
  412. var test_json = '{"tokenPrice": [{"contract": "0x0000000000000000000000000000000000000000", "usdPrice": 400}, {"contract": "0x03716F32f72c692a0B355fa04639669E3341B94e", "usdPrice": 0.1}]}'
  413. obj.tokenPrices = JSON.parse(test_json);
  414. logger.log('dev tokenPrices=', obj.tokenPrices)
  415. } else {
  416. obj.tokenPrices = await redis.readRedis(reids_token_config.TOKENPRICE)
  417. if (!obj.tokenPrices) return 'readRedis error'
  418. if (typeof obj.tokenPrices == 'string')
  419. obj.tokenPrices = JSON.parse(obj.tokenPrices);
  420. }
  421. obj.chain = chain;
  422. //计算 gas 费用 是否需要归集
  423. var transFerGasFree = await computeTransferGasFree(obj, my_account_all_coins, obj.tokenPrices);
  424. logger.log('computeTransferGasFree=', transFerGasFree)
  425. if (transFerGasFree) {
  426. // return
  427. }
  428. //是否需要归集
  429. if (transFerGasFree.totalCount > 0) {
  430. //需要转移 gas 费
  431. //每次都需要充值 gas 费
  432. if (account_config.TRANSFER_GAS || (parseInt(transFerGasFree.gasPrice) > 0 && transFerGasFree.get_service_charge == 1)) {
  433. var info = await queryCompanyInfoFromId(0);
  434. var obj_wd = {
  435. chain: chain,
  436. amount: transFerGasFree.gasPrice,
  437. receiver: obj.address,
  438. type: 'native',
  439. // address: account_config.WELLET_PUBLIC_KEY, //todo 正式环境需要替换从 mysql read
  440. address: info.user_address, //todo 正式环境需要替换从 mysql read
  441. }
  442. logger.log('开始充值 gas ', obj_wd)
  443. var ret = await withdraw(obj_wd)
  444. logger.log('充值完成 gas ', ret)
  445. if (!isTransferSucceed(ret)) return ret;
  446. var transfer = getTransferGasFree('native', ret)
  447. logger.log('getTransferGasFree transfer =', transfer)
  448. if (transfer && transfer.nativeValue > 0) {
  449. logger.log('tempNativeValue=', my_account_all_coins.native.balance)
  450. var tempNativeValue = addNativeValue(my_account_all_coins.native.balance, transfer.nativeValue)
  451. my_account_all_coins.native.balance = tempNativeValue.toString();
  452. logger.log('udpateNativeValue=', tempNativeValue);
  453. } else return "get native value error."
  454. }
  455. obj.chain = chain;
  456. obj.transFerGasFree = transFerGasFree;
  457. logger.log('transfers--->', obj);
  458. var ret = await transfers(obj, my_account_all_coins);
  459. logger.log('归集结果=', ret);
  460. return ret;
  461. }
  462. return obj.address + ':不满足归集条件';
  463. }
  464. var collectCoinsArrays = [];
  465. var lastCollectCoinsAddress;
  466. var isExecCollect = false;
  467. async function execCollectCoinsTask() {
  468. if (isExecCollect) return
  469. isExecCollect = true;
  470. while (collectCoinsArrays.length > 0) {
  471. var obj = collectCoinsArrays.pop();
  472. //开始收集用户地址里面的币到归集地址
  473. var ret = await collectCoins(obj);
  474. // await utils.sleep(3000)
  475. logger.log('execCollectCoinsTask=', collectCoinsArrays.length, ret)
  476. }
  477. isExecCollect = false;
  478. lastCollectCoinsAddress = ''
  479. }
  480. function pushCollectConisObj(obj) {
  481. logger.debug('collectCoinsArrays length=', collectCoinsArrays.length, lastCollectCoinsAddress)
  482. if (collectCoinsArrays.length > 0) {
  483. var findItem = collectCoinsArrays.find(element => {
  484. return (obj.address == element.address) || (!lastCollectCoinsAddress && lastCollectCoinsAddress == element.address)
  485. })
  486. if (findItem) {
  487. logger.log('当前任务正在处理中...', obj.address)
  488. return;
  489. }
  490. }
  491. collectCoinsArrays.push(obj)
  492. execCollectCoinsTask();
  493. lastCollectCoinsAddress = obj.address;
  494. }
  495. async function readPriveteKeyFromMysql(address) {
  496. return new Promise(resolve => {
  497. mysql.queryUserPrivateKeyFromUserAddress(address).then(ret => {
  498. logger.log('readPriveteKeyFromMysql=', ret);
  499. resolve(ret);
  500. })
  501. })
  502. }
  503. async function queryCompanyInfoFromId(id) {
  504. return new Promise(resolve => {
  505. mysql.queryCompanyInfoFromId(id).then(ret => {
  506. logger.log('queryCompanyInfoFromId=', ret, ret.results, ret.results.user_address, ret.results.user_private_key);
  507. resolve(ret.results);
  508. })
  509. })
  510. }
  511. const transfer = async (obj) => {
  512. logger.debug("fun transfer serverUrl ", serverUrl);
  513. logger.debug("fun transfer appId ", serverUrl);
  514. logger.debug("fun transfer moralisSecret ", moralisSecret);
  515. await initMoralisSecretSDK();
  516. // initSDK(moralisSecret);
  517. logger.debug("fun transfer start ok ");
  518. const opts = {};
  519. opts.chainId = 'bsc_testnet';
  520. opts.privateKey = moralis_config.DEFAULT_PRIVATE_KEY;
  521. opts.type = "erc20"; //native erc20
  522. if (!obj.receiver || !obj.amount || parseInt(obj.amount) <= 0) {
  523. logger.error("transfer fun transfer parameter error.", obj.receiver, obj.amount, obj.amount);
  524. return toJson(ERROR_CODE_001, null, "please check receiver or amount parameter is ok ?");
  525. }
  526. if (obj.chain != null) {
  527. opts.chainId = utils.getChainId(obj.chain);
  528. console.log("chainId:", opts.chainId);
  529. }
  530. if (obj.type != null) {
  531. opts.type = obj.type;
  532. }
  533. if (obj.from_block != null) {
  534. opts.from_block = obj.from_block;
  535. }
  536. if (obj.to_block != null) {
  537. opts.to_block = obj.to_block;
  538. }
  539. opts.contractAddress = obj.contractAddress;
  540. opts.receiver = obj.receiver;
  541. //调用者传入
  542. // opts.amount = Moralis.Units.Token(obj.amount, 18);
  543. opts.amount = obj.amount;
  544. if (obj.privateKey != null) {
  545. opts.privateKey = obj.privateKey;
  546. }
  547. try {
  548. // sending 0.5 DAI tokens with 18 decimals on BSC testnet
  549. var options;
  550. if (opts.contractAddress) { //如果存在就是代币
  551. options = Moralis.TransferOptions = {
  552. type: opts.type,
  553. amount: opts.amount,
  554. receiver: opts.receiver, //接收钱包地址
  555. contractAddress: opts.contractAddress //用户合约地址
  556. };
  557. logger.tlog("options 20 =", options);
  558. } else { //ETH or BNB
  559. options = Moralis.TransferOptions = {
  560. type: opts.type,
  561. amount: opts.amount,
  562. receiver: opts.receiver, //接收钱包地址
  563. };
  564. logger.tlog("options native =", options, opts.chainId);
  565. }
  566. // Enable web3
  567. await Moralis.enableWeb3({
  568. //BSC mainnet = 0x38-56 testnet:0x61-97
  569. chainId: opts.chainId,
  570. privateKey: opts.privateKey,
  571. });
  572. logger.tlog("options id =", opts.chainId);
  573. var ret = await Moralis.transfer(options);
  574. logger.tlog("transfer 结果 =", ret);
  575. return toJson(SUCCEED_CODE, ret, "");
  576. } catch (error) {
  577. logger.tlog('transfer error:', error);
  578. if (error.reason != null) {
  579. return toJson(ERROR_CODE_001, null, error.toString());
  580. } else {
  581. return toJson(ERROR_CODE_001, null, error);;
  582. }
  583. }
  584. };
  585. const getAllTokenWithdrawInfoLists = async (obj) => {
  586. try {
  587. var key = reids_token_config.TOKENWITHDRAW;
  588. var ret = await redis.readRedis(key);
  589. return toJson(SUCCEED_CODE, ret, null);
  590. } catch (error) {
  591. console.error("getAllTokenWithdrawInfoLists=", error);
  592. return toJson(ERROR_CODE_001, null, error.toString());
  593. }
  594. }
  595. /**
  596. * 获取代币价格 -> usdPrice
  597. */
  598. const getAllTotkenPrice = async () => {
  599. try {
  600. logger.log('当前环境:', process.env.NODE_ENV);
  601. logger.log("getAllTotkenPrice in", reids_token_config); // Prints "value"
  602. var token_price_key = reids_token_config.TOKENPRICE;
  603. logger.log("getAllTotkenPrice token_price_key=", token_price_key);
  604. return await redis.readRedis(token_price_key)
  605. } catch (error) {
  606. logger.error("getTotkenPrice=", error);
  607. return toJson(ERROR_CODE_001, null, error.toString());
  608. }
  609. }
  610. function setTransfersDataType(type, ret) {
  611. if (ret && Array.isArray(ret) && ret.length > 0) {
  612. ret.forEach(element => {
  613. element.type = type;
  614. });
  615. }
  616. }
  617. //获取交易记录
  618. //hash 0xe09ba3a4c9f7a8902e01af68d0f1f91906f3f7db1195227e61c45c0e86b2630a
  619. async function getTokenTransfers(opt) {
  620. await initMasterSDK();
  621. logger.debug("fun getTokenTransfers in ", opt);
  622. const options = {};
  623. options.type = 'all';
  624. options.chain = 'bsc_mainnet';
  625. if (opt.chain != null) {
  626. options.chain = utils.getChainName(opt.chain);
  627. logger.log('getTokenTransfers=', options.chain);
  628. }
  629. if (opt.order != null) {
  630. options.order = opt.order;
  631. }
  632. if (opt.startTime != null) {
  633. options.from_date = opt.startTime;
  634. }
  635. if (opt.endTime != null) {
  636. options.to_date = opt.endTime;
  637. }
  638. if (opt.from_block != null) {
  639. options.from_block = opt.from_block;
  640. }
  641. if (opt.to_block != null) {
  642. options.to_block = opt.to_block;
  643. }
  644. if (opt.transaction_hash) {
  645. options.transaction_hash = opt.transaction_hash;
  646. options.type = 'transaction_hash';
  647. }
  648. logger.debug('getTokenTransfers-->>>', options);
  649. if (options.type == 'all') {//查询主流币和 20 币所有的交易
  650. try {
  651. if (opt.address != null) {
  652. options.address = opt.address;
  653. } else {
  654. return toJson(ERROR_CODE_001, null, "please check address parameter is ok ?");
  655. }
  656. //主流币
  657. var t_1 = await Moralis.Web3API.account.getTransactions(options);
  658. setTransfersDataType('native', t_1.result)
  659. //20币
  660. var t_2 = await Moralis.Web3API.account.getTokenTransfers(options);
  661. setTransfersDataType('token', t_2.result)
  662. let arr = t_1.result;
  663. let arr1 = t_2.result;
  664. if (Array.isArray(arr1) && Array.isArray(arr)) {
  665. let arr2 = arr.concat(arr1);
  666. t_1.result = arr2;
  667. }
  668. //将结果排序
  669. t_1.result.sort((a, b) => {
  670. let t1 = new Date(Date.parse(a.block_timestamp))
  671. let t2 = new Date(Date.parse(b.block_timestamp))
  672. return t2.getTime() - t1.getTime()
  673. })
  674. return toJson(SUCCEED_CODE, t_1, null);
  675. } catch (error) {
  676. logger.error("getTransactions error:", error)
  677. return toJson(ERROR_CODE_001, null, error);;
  678. }
  679. } else if (options.type == 'transaction_hash') {//根据哈希查询
  680. try {
  681. //native
  682. const transaction = await Moralis.Web3API.native.getTransaction(options);
  683. var arr = [];
  684. if (transaction)
  685. arr.push(transaction)
  686. var obj = { result: arr }
  687. return toJson(SUCCEED_CODE, obj, null);
  688. } catch (error) {
  689. logger.error("native getTransaction error:", error)
  690. return toJson(ERROR_CODE_001, null, error);
  691. }
  692. } else {
  693. return toJson(ERROR_CODE_001, null, "This type is not supported.");;
  694. }
  695. }
  696. module.exports = {
  697. transfer,
  698. getTokenTransfers,
  699. toJson,
  700. getAllTokenWithdrawInfoLists,
  701. getAllTotkenPrice,
  702. withdraw,
  703. collectCoins,
  704. isTransferSucceed,
  705. getTransferRecordGasFree,
  706. pushCollectConisObj,
  707. }