moralis_sdk.js 53 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453
  1. /* import moralis */
  2. const Moralis = require("moralis/node");
  3. // const Moralis = require("../Moralis_JS_SDK/node");
  4. var utils = require('./utils.js');
  5. // var config = require('../config/config.js')(db_config,
  6. // moralis_config)
  7. var { moralis_config, reids_token_config, account_config } = require('../config/config.js')
  8. const redis = require("./db/redis_db") //导入 db.js
  9. const mysql = require("./db/mysql_db")
  10. const account_mysql = require("../model/db/account_info_db") //导入 db.js
  11. const logger = require('./logger')
  12. const report = require("./report") //导入 db.js
  13. const BigNumber = require('bignumber.js')
  14. const collect_coins_db = require('./db/collect_coins_db')
  15. /* Moralis init code */
  16. var serverUrl = moralis_config.SERVER_URL;
  17. var appId = moralis_config.APP_ID;
  18. var masterKey = moralis_config.MASTER_KEY;
  19. var moralisSecret = moralis_config.MORALIS_SECRET;
  20. // 内部异常
  21. const ERROR_CODE_001 = -1;
  22. const SUCCEED_CODE = 0;
  23. // 归集队列
  24. var collectCoinsArrays = [];
  25. // 是否执行归集
  26. var isExecCollect = false;
  27. var masterInit = false
  28. var secretInit = false
  29. // 对 shib 做限制
  30. const SHIB_AMOUNT_LIMIT = 20000
  31. const SHIB_AMOUNT_FEE_LIMIT = 10000
  32. const SHIB_ADDRESS = '0x2859e4544C4bB03966803b044A93563Bd2D0DD4D'
  33. /**
  34. * 初始化 moralis
  35. * https://st94nif1cq.feishu.cn/docs/doccnNxG2UwHPCdZXbywgbdy13f#
  36. */
  37. async function initMasterSDK() {
  38. logger.debug('initMasterSDK start')
  39. if (masterInit) {
  40. logger.log('initMasterSDK', masterInit)
  41. return
  42. }
  43. await Moralis.start({ serverUrl, appId, masterKey });
  44. logger.debug('initMasterSDK start ok')
  45. masterInit = true
  46. setWeb3apiRateLimit()
  47. }
  48. async function initMoralisSecretSDK() {
  49. if (secretInit) {
  50. logger.log('initMoralisSecretSDK', secretInit)
  51. return
  52. }
  53. logger.debug('initMoralisSecretSDK start')
  54. await Moralis.start({ serverUrl, appId, moralisSecret });
  55. logger.debug('initMoralisSecretSDK start ok')
  56. secretInit = true
  57. setWeb3apiRateLimit()
  58. }
  59. /**
  60. * 设置 web3 云函数
  61. */
  62. async function setWeb3apiRateLimit() {
  63. const params = {};
  64. const ret = await Moralis.Cloud.run("setWeb3apiRateLimit", params);
  65. if (!ret)
  66. logger.error('setWeb3apiRateLimit error')
  67. }
  68. function toJson(code_, obj_, errMsg_) {
  69. return utils.toJson(code_, obj_, errMsg_);
  70. }
  71. /**
  72. * 通过交易记录获取 gas 费用
  73. * @param {} type
  74. * @param {*} obj
  75. * @param {*} address
  76. */
  77. function getTransferRecordGasFree(type, obj, address) {
  78. logger.log('getTransferRecordGasFree fun in', type, obj, address)
  79. if (obj && obj.data && obj.data.result && Array.isArray(obj.data.result) && obj.data.result.length > 0) {
  80. logger.log('getTransferRecordGasFree fun in', 1)
  81. for (let index = 0; index < obj.data.result.length; index++) {
  82. const element = obj.data.result[index];
  83. logger.log('getTransferRecordGasFree fun in 2', element)
  84. if (element.type == type && element.to_address.toLowerCase() == address.toLowerCase()) {
  85. if (element.gas_price && element.gas && type == 'native') {//native
  86. return {
  87. totalGasFree: parseInt(element.gas_price) * parseInt(element.gas),
  88. gas_price: parseInt(element.gas_price),
  89. gas_limit: parseInt(element.gas),
  90. }
  91. }
  92. }
  93. }
  94. }
  95. return null;
  96. }
  97. function changeJsonHexBignumberToString(json) {
  98. if (json) {
  99. var obj = JSON.parse(json)
  100. var code = obj.code;
  101. logger.log('changeJsonHexBignumberToString obj=', obj)
  102. try {
  103. if (obj.data && obj.data.gasPrice && obj.data.gasLimit && obj.data.gasPrice.hex && obj.data.gasLimit.hex) {
  104. var curGasPrice = BigNumber(obj.data.gasPrice.hex).toNumber()
  105. var curGasLimit = BigNumber(obj.data.gasLimit.hex).toNumber()
  106. obj.data.gasPrice.number = curGasPrice.toString()
  107. obj.data.gasLimit.number = curGasLimit.toString()
  108. logger.log('getTransferGasFree totalGasFree=', curGasPrice, curGasLimit)
  109. if (obj.data.value && obj.data.value.hex) {
  110. var value = BigNumber(obj.data.value.hex).toNumber()
  111. logger.log('getTransferGasFree native value=', value)
  112. if (value != 0) {
  113. obj.data.value.number = value.toString()
  114. }
  115. }
  116. }
  117. logger.log('changeJsonHexBignumberToString ret=', obj.data)
  118. return JSON.stringify(obj.data)
  119. } catch (error) {
  120. logger.error('changeJsonHexBignumberToString error', error.toString())
  121. return json;
  122. }
  123. }
  124. return json;
  125. }
  126. /**
  127. * 获取转账的 gas 费
  128. * @param {*} type
  129. * @param {*} json
  130. * @returns
  131. */
  132. function getTransferGasFree(type, json) {
  133. var curGasPrice = account_config.BNB_GAS_PRICE
  134. var curGasLimit = account_config.TOKEN_GAS_LIMIT
  135. var nativeValue = 0;
  136. var tokenValue = 0;
  137. var code = -1;
  138. if (type == 'native') {
  139. curGasLimit = account_config.BNB_GAS_LIMIT
  140. }
  141. var totalGasFree = parseInt(curGasLimit) * parseInt(curGasPrice);
  142. var gas_fee
  143. var gas_limit
  144. logger.log('getTransferGasFree json=', json)
  145. if (json) {
  146. var obj = JSON.parse(json)
  147. code = obj.code;
  148. logger.log('getTransferGasFree obj=', obj)
  149. if (obj.data && obj.data.gasPrice && obj.data.gasLimit && obj.data.gasPrice.hex && obj.data.gasLimit.hex) {
  150. var curGasPrice = BigNumber(obj.data.gasPrice.hex).toNumber()
  151. var curGasLimit = BigNumber(obj.data.gasLimit.hex).toNumber()
  152. if (curGasPrice > 0 && curGasLimit > 0) {
  153. totalGasFree = curGasPrice * curGasLimit;
  154. }
  155. gas_fee = curGasPrice
  156. gas_limit = gas_limit
  157. logger.log('getTransferGasFree totalGasFree=', curGasPrice, curGasLimit, totalGasFree)
  158. if (obj.data.value && obj.data.value.hex) {
  159. var value = BigNumber(obj.data.value.hex).toNumber()
  160. logger.log('getTransferGasFree native value=', value)
  161. if (value != 0) {
  162. nativeValue = value
  163. }
  164. }
  165. }
  166. }
  167. return {
  168. code: code,
  169. totalGasFree: totalGasFree,
  170. nativeValue: nativeValue,
  171. tokenValue: tokenValue,
  172. gasFee: gas_fee,
  173. gasLimit: gas_limit,
  174. }
  175. }
  176. /**
  177. *
  178. * @param {转账是否成功} json
  179. */
  180. function isTransferSucceed(json) {
  181. if (json) {
  182. var obj = JSON.parse(json)
  183. return obj.code == 0
  184. }
  185. return false
  186. }
  187. const withdraw = async (obj) => {
  188. obj.withdraw = 1;
  189. return await transfer_handle(obj);
  190. }
  191. async function getAccountBalances(options) {
  192. await initMasterSDK();
  193. if (options.chain) {
  194. options.chain = utils.getChainName(options.chain)
  195. }
  196. //做 3次 重试,每次间隔 1s+=
  197. //Error: Request failed with status code 524
  198. //Error: Request failed with status code 500
  199. var tryCount = 4;
  200. var delay = 1000
  201. var interval = 500
  202. var result;
  203. var balance_opts = {
  204. address: options.address,
  205. chain: options.chain
  206. }
  207. logger.log('getAccountBalances :', options, balance_opts)
  208. do {
  209. try {
  210. if (options.type == 'native') {
  211. // result = await Moralis.Web3API.account.getNativeBalance(balance_opts);
  212. result = await getBalances(balance_opts, 'native')
  213. logger.log('getNativeBalance=', result);
  214. } else {
  215. result = await getBalances(balance_opts, 'token')
  216. // result = await Moralis.Web3API.account.getTokenBalances(balance_opts);
  217. logger.log('getTokenBalances=', result);
  218. }
  219. if (tryCount < 4) {
  220. logger.error('getBalances succeed:', JSON.stringify(balance_opts), " 已重试:" + tryCount + "次")
  221. }
  222. break
  223. } catch (error) {
  224. if (tryCount == 1) {
  225. logger.error('getBalances error:', error.toString(), JSON.stringify(balance_opts), JSON.stringify(options))
  226. result = null;
  227. break
  228. }
  229. tryCount -= 1;
  230. await utils.sleep(delay)
  231. delay += interval
  232. logger.error('getBalances error:', JSON.stringify(balance_opts), "重试:" + tryCount + "次")
  233. }
  234. } while (tryCount >= 1);
  235. return result
  236. }
  237. /**
  238. * 获取当前账户下所有不同种类的币 主流币 + 20币
  239. *
  240. * 必填项
  241. * obj.chain = ?
  242. * @param {*} obj
  243. */
  244. async function getAccountAllCoins(obj) {
  245. var temp_chain = obj.chain;
  246. //拿到我当前所有的币种
  247. obj.type = 'native'
  248. obj.chain = temp_chain
  249. var native_balance = await getAccountBalances(obj);
  250. //拿到我当前所有的 20 币
  251. obj.type = '20'
  252. obj.chain = temp_chain
  253. var others_balances = await getAccountBalances(obj);
  254. return {
  255. native: native_balance,
  256. other: others_balances,
  257. }
  258. }
  259. /**
  260. * 判断是否转 gas 费
  261. * @param {*} my_account_all_coins
  262. */
  263. async function computeTransferGasFree(obj, my_account_all_coins, tokenPrices) {
  264. var totalCount = 0;
  265. var tokenCount = 0;
  266. var tokenGasPrice = 0;
  267. var nativeGasPrice = 0;
  268. var ret_total_gas_price = 0;
  269. var ret_total_count = 0;
  270. var ret_a_gas = 0;
  271. //需要转账的数组对象
  272. var transfer_obj = [];
  273. var receiver_info = await queryCompanyInfoFromId(0);
  274. //得到 20 币 满足 1美刀的 count
  275. if (Array.isArray(my_account_all_coins.other) && my_account_all_coins.other.length > 0) {
  276. for (let index = 0; index < my_account_all_coins.other.length; index++) {
  277. const element = my_account_all_coins.other[index];
  278. // my_account_all_coins.other.forEach(element => {
  279. logger.log('20 element=', element);
  280. var find_transfer_item = findTokenPriceItem(element.token_address, tokenPrices);
  281. if (element.token_address == SHIB_ADDRESS) {
  282. if (parseInt(element.balance) < SHIB_AMOUNT_LIMIT) {
  283. logger.warn('不满足归集条件', element);
  284. continue
  285. }
  286. }
  287. if (find_transfer_item) {
  288. var total_all_usdprice = calculate_total_usdprice(element.balance, element.decimals, find_transfer_item.usdPrice);
  289. logger.log('findTokenPriceItem ret=', element.token_address, find_transfer_item, total_all_usdprice);
  290. if (find_transfer_item && total_all_usdprice > 1.0) {
  291. tokenCount += 1;
  292. logger.log('token > 1.0', tokenCount, element.token_address);
  293. var obj_20 = {
  294. chain: obj.chain,
  295. contractAddress: element.token_address,
  296. amount: element.balance,
  297. receiver: receiver_info.user_address,
  298. type: 'erc20',
  299. address: obj.address,
  300. usdPrice: find_transfer_item.usdPrice
  301. }
  302. transfer_obj.push(obj_20)
  303. }
  304. } else {
  305. logger.log('findTokenPriceItem not fount =', element);
  306. }
  307. // });
  308. }
  309. logger.log('account_config.TOKEN_GAS_LIMIT=', account_config.TOKEN_GAS_LIMIT);
  310. var lastTokenFree = await redis.readRedis(reids_token_config.LAST_TOTAL_TOKEN_FREE)
  311. logger.log('LAST_TOTAL_TOKEN_FREE=', lastTokenFree);
  312. if (lastTokenFree && reids_token_config.LAST_TOTAL_TOKEN_FREE && parseInt(lastTokenFree) > 0) {
  313. tokenGasPrice = parseInt(tokenCount) * parseInt(lastTokenFree);
  314. } else {
  315. tokenGasPrice = parseInt(tokenCount) * parseInt(account_config.TOKEN_GAS_LIMIT) * parseInt(account_config.BNB_GAS_PRICE);
  316. }
  317. ret_a_gas = account_config.BNB_GAS_PRICE;
  318. logger.log('tokenGasPrice=', tokenGasPrice);
  319. }
  320. //计算 native 是否满足 1美刀
  321. logger.log('isTransferGasFree token count:', tokenCount);
  322. var nativeAllBalance = 0;
  323. if (my_account_all_coins.native && my_account_all_coins.native.balance)
  324. nativeAllBalance = my_account_all_coins.native.balance
  325. var nativeCount = 0
  326. var nativePriceItem = findTokenPriceItem('0x0000000000000000000000000000000000000000', tokenPrices);//todo 线上环境需要换
  327. logger.log('native nativePriceItem=', nativePriceItem, nativeAllBalance);
  328. if (nativePriceItem) {
  329. var total_all_usdprice = calculate_total_usdprice(nativeAllBalance, '18', nativePriceItem.usdPrice);
  330. logger.log('native total_all_usdprice=', total_all_usdprice);
  331. if (total_all_usdprice > 1.0) {
  332. nativeCount = 1;
  333. logger.log('native > 1.0', tokenCount);
  334. var lastBnbFree = await redis.readRedis(reids_token_config.LAST_TOTAL_BNB_FREE)
  335. logger.log('LAST_TOTAL_BNB_FREE=', lastBnbFree);
  336. if (lastBnbFree && parseInt(lastBnbFree) > 0) {
  337. nativeGasPrice = parseInt(nativeCount) * parseInt(lastBnbFree);
  338. } else {
  339. nativeGasPrice = parseInt(nativeCount) * parseInt(account_config.BNB_GAS_LIMIT) * parseInt(account_config.BNB_GAS_PRICE);
  340. }
  341. ret_a_gas = account_config.BNB_GAS_PRICE;
  342. // var real_native_amount = BigInt(nativeAllBalance) - BigInt(nativeGasPrice) - BigInt(tokenGasPrice);
  343. var real_native_amount = BigInt(nativeAllBalance);
  344. var obj_native = {
  345. chain: obj.chain,
  346. amount: real_native_amount.toString(),
  347. receiver: receiver_info.user_address,
  348. type: 'native',
  349. address: obj.address,
  350. usdPrice: nativePriceItem.usdPrice
  351. }
  352. transfer_obj.push(obj_native)
  353. }
  354. }
  355. logger.log('transfer obj=', transfer_obj)
  356. //计算所有币
  357. totalCount = nativeCount + tokenCount;
  358. // var gasPrice = await redis.readRedis(reids_token_config.GASPRICE);
  359. logger.log('nativeAllBalance', nativeAllBalance);
  360. logger.log('totalCount', totalCount);
  361. //计算所有币转账所需要的 gas
  362. var total2Gas = nativeGasPrice + tokenGasPrice;
  363. var service_charge = 0;
  364. logger.log('total2Gas', total2Gas);
  365. //需要转账的 obj
  366. my_account_all_coins.transfer_arrays = transfer_obj
  367. //如果当前的钱不够 gas
  368. if (nativeAllBalance < total2Gas) {
  369. if (tokenCount > 0) {//出现 token 需要转移手续费
  370. service_charge = 1;
  371. // total2Gas = (total2Gas - nativeAllBalance);//充手续费
  372. logger.log('需要转账=', total2Gas);
  373. }
  374. }
  375. ret_total_gas_price = total2Gas.toString();
  376. ret_total_count = totalCount;
  377. //返回结果
  378. return {
  379. gasPrice: ret_total_gas_price, //需要 归集到用户地址的 gas 费转移
  380. totalCount: ret_total_count, //一共归集次数
  381. aGasPrice: ret_a_gas, //单个 gas 费用
  382. get_service_charge: service_charge,//是否需要服务费
  383. transfer_obj: transfer_obj,
  384. };
  385. }
  386. function findTokenPriceItem(token_address, tokenPrices) {
  387. return tokenPrices.tokenPrice.find(element => {
  388. // logger.log('findTokenPriceItem find=', element.contract, token_address)
  389. return element.contract.toLowerCase() == token_address.toLowerCase();
  390. })
  391. }
  392. // function calculate_total_usdprice(amount, decimals, usdprice) {
  393. // return parseInt(amount) / (10**parseInt(decimals)) * parseInt(usdprice) ;
  394. function calculate_total_usdprice(amount, decimals, usdprice) {
  395. // if(usdprice.toString().indexOf("e") != -1 ){
  396. // return parseInt(amount) / (10 ** parseInt(decimals)) * parseFloat(usdprice);
  397. // }else {
  398. // return parseInt(amount) / (10 ** parseInt(decimals)) * parseFloat(usdprice);
  399. // }
  400. return parseInt(amount) / (10 ** parseInt(decimals)) * parseFloat(usdprice);
  401. }
  402. function addNativeValue(nativeValue, aValue) {
  403. return BigInt(nativeValue) + BigInt(aValue)
  404. }
  405. function reduceNativeValue(nativeValue, rValue) {
  406. return BigInt(nativeValue) - BigInt(rValue)
  407. }
  408. /**
  409. * todo --> 计算 gas
  410. * @param {*} nativeBalance
  411. * @param {*} obj
  412. * @returns
  413. */
  414. async function updateNativeBalance(nativeBalance, obj) {
  415. var temp = { ...obj }
  416. console.log('updateNativeBalance before', temp, nativeBalance)
  417. var retryCount = 15;
  418. if (temp.chain) {
  419. temp.chain = utils.getChainName(temp.chain)
  420. }
  421. console.log('updateNativeBalance after', temp, nativeBalance)
  422. var balance_opts = {
  423. address: temp.address,
  424. chain: temp.chain
  425. }
  426. try {
  427. do {
  428. //上面转账完 BNB 会减去,这里再获取一次
  429. // var native_ret = await Moralis.Web3API.account.getNativeBalance(temp);
  430. var native_ret = await getBalances(balance_opts, 'native');
  431. logger.log('更新余额 :', nativeBalance, native_ret, retryCount)
  432. if (nativeBalance != native_ret.balance && BigInt(nativeBalance) < BigInt(native_ret.balance)) {
  433. return native_ret.balance;
  434. }
  435. await utils.sleep(3000);
  436. retryCount--;
  437. } while (native_ret.balance == nativeBalance && retryCount > 0);
  438. } catch (error) {
  439. logger.error('updateNativeBalance error :', nativeBalance, JSON.stringify(obj))
  440. }
  441. return null;
  442. }
  443. //20 and native 归集
  444. async function transfers(obj, my_account_all_coins, logParams) {
  445. // 优化后的归集
  446. 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) {
  447. var t_i = 0;
  448. var totalGasFee = 0;
  449. var collects = []
  450. var collects_error = []
  451. var collects_mysql = []
  452. for (let index = 0; index < my_account_all_coins.transfer_arrays.length; index++) {
  453. var ti = my_account_all_coins.transfer_arrays[index]
  454. logger.tlog('ti=', ti, index)
  455. //fix 归集失败的问题
  456. //线上环境和测试环境由于访问快,导致余额未来得及更新,这里做一个 延迟判断
  457. if (ti.type == 'native') {
  458. await updateNativeBalance(ti.amount, ti);
  459. }
  460. var ret = await start_collectCoins(ti)
  461. //更新 native 金额
  462. if (isTransferSucceed(ret)) {
  463. logger.tlog('start_collectCoins respose...', ret);
  464. t_i += 1
  465. collects.push(ret);
  466. //缓存当前交易的 gas 费用
  467. if (ret && ti.contractAddress) {
  468. var tr = getTransferGasFree('token', ret)
  469. // tr.totalGasFree
  470. totalGasFee += parseInt(tr.totalGasFree);
  471. } else {
  472. var tr = getTransferGasFree('native', ret)
  473. // tr.totalGasFree
  474. totalGasFee += parseInt(tr.totalGasFree);
  475. }
  476. collects_mysql.push(changeJsonHexBignumberToString(ret))
  477. } else {
  478. //缓存当前交易的 gas 费用
  479. try {
  480. if (ret && ti.contractAddress) {
  481. var tr = getTransferGasFree('token', ret)
  482. // tr.totalGasFree
  483. totalGasFee += parseInt(tr.totalGasFree);
  484. } else {
  485. var tr = getTransferGasFree('native', ret)
  486. // tr.totalGasFree
  487. totalGasFee += parseInt(tr.totalGasFree);
  488. }
  489. try {
  490. collects_error.push(JSON.parse(ret).errMsg)
  491. } catch (error) {
  492. logger.error('collects_error json parse error', ret)
  493. }
  494. } catch (error) {
  495. logger.error('start_collectCoins 获取 gas fee=', error.toString(), JSON.stringify(ti));
  496. }
  497. logger.tlog('start_collectCoins error=', ret);
  498. var tmp_ti = { ...ti }
  499. tmp_ti.privateKey = ''
  500. logger.error('start_collectCoins 归集 error=', ret, JSON.stringify(tmp_ti));
  501. };
  502. }
  503. //日志埋点-归集全部所花费的 gas 费用
  504. logParams.collectCoinsTotalGasFee = totalGasFee.toString();
  505. //日志埋点-归集的响应
  506. logParams.results = collects
  507. logParams.collects = JSON.stringify(collects_mysql)
  508. logParams.createTime = obj.createTime
  509. if (obj.address)
  510. logParams.user_address = obj.address
  511. if (t_i == my_account_all_coins.transfer_arrays.length) {
  512. logger.log('归集日志上报:', logParams);
  513. logParams.type = report.REPORT_TYPE.collect_coins
  514. var info = await queryCompanyInfoFromId(0);
  515. logParams.receiver_address_total_balance_after = await queryCollectBalance(info.user_address, obj.chain)
  516. //归集入库
  517. logParams.status = 0
  518. try {
  519. await collect_coins_db.create_collect_coins_task({ ...logParams })
  520. } catch (error) {
  521. logger.error('create_collect_coins_task', error.toString(), JSON.stringify(logParams))
  522. }
  523. //日志埋点-日志上报
  524. report.logReport(logParams)
  525. return toJson(0, null, '所有币归集成功.');
  526. } else {
  527. //归集入库
  528. logParams.status = -1
  529. try {
  530. logger.error('归集失败 : ', JSON.stringify(collects_error))
  531. logParams.errMsg = JSON.stringify(collects_error)
  532. await collect_coins_db.create_collect_coins_task({ ...logParams })
  533. } catch (error) {
  534. logger.error('归集失败 error: ', error.toString())
  535. }
  536. return toJson(-1, null, JSON.stringify(collects_error));
  537. }
  538. } else {
  539. return toJson(-1, null, 'transfer conditions are not met.');
  540. }
  541. }
  542. const start_collectCoins = async (obj) => {
  543. obj.withdraw = 0;
  544. return await transfer_handle(obj);
  545. }
  546. const transfer_handle = async (obj) => {
  547. //提币
  548. if (obj.withdraw) {
  549. var id = 0
  550. if (obj.privateKeyId)
  551. id = obj.privateKeyId
  552. //读取用户充币地址对应的私钥
  553. var info = await queryCompanyInfoFromId(id);
  554. logger.log('transfer_handle queryCompanyInfoFromId=', info);
  555. //提币公司
  556. obj.privateKey = info.user_private_key;
  557. // if (process.env.NODE_ENV != 'dev') {
  558. logger.log('readCompanyPriveteKeyFromMysql=', obj.privateKey)
  559. // }
  560. } else {
  561. //读取用户充币地址对应的私钥
  562. obj.privateKey = await readPriveteKeyFromMysql(obj.address);
  563. }
  564. if (obj.privateKey && obj.privateKey.results) {
  565. obj.privateKey = obj.privateKey.results;
  566. }
  567. if (!obj.privateKey) {
  568. logger.error('readPriveteKeyFromMysql error.', obj);
  569. //提币公司
  570. return toJson(-1, null, "readPriveteKeyFromMysql error.");
  571. }
  572. try {
  573. //解密
  574. obj.privateKey = utils.decryptPrivityKey(obj.privateKey);
  575. if (!obj.privateKey) {
  576. logger.error('decryptPrivityKey error', obj);
  577. return toJson(-1, null, "decryptPrivityKey error.");
  578. }
  579. } catch (error) {
  580. logger.error('decryptPrivityKey error', error.toString(), JSON.stringify(obj));
  581. if (!obj.privateKey) {
  582. return toJson(-1, null, "decryptPrivityKey error.", error.toString());
  583. }
  584. }
  585. var ret = await transfer(obj);
  586. if (isTransferSucceed(ret)) {
  587. //缓存当前交易的 gas 费用
  588. if (ret && obj.contractAddress) {
  589. var tr = getTransferGasFree('token', ret)
  590. logger.debug('cache setkey token LAST_TOTAL_TOKEN_FREE getTransferGasFree', tr)
  591. redis.redis_set(reids_token_config.LAST_TOTAL_TOKEN_FREE, tr.totalGasFree);
  592. } else {
  593. var tr = getTransferGasFree('native', ret)
  594. logger.debug('cache setkey LAST_TOTAL_BNB_FREE getTransferGasFree', tr)
  595. redis.redis_set(reids_token_config.LAST_TOTAL_BNB_FREE, tr.totalGasFree);
  596. }
  597. } else {
  598. var tm_obj = { ...obj }
  599. tm_obj.privateKey = '不对外暴露'
  600. logger.error('transfer_handle transfer error', JSON.stringify(tm_obj));
  601. }
  602. return ret;
  603. }
  604. async function queryCollectBalance(address, chain) {
  605. // var t_chain = utils.getChainName(chain)
  606. try {
  607. var queryCollectBalance = {
  608. address: address,
  609. chain: chain
  610. }
  611. logger.log('queryCollectBalance', queryCollectBalance)
  612. // 查询归集地址余额
  613. // return await getAccountBalances(queryCollectBalance);
  614. return await getAccountAllCoins(queryCollectBalance);
  615. } catch (error) {
  616. logger.error('queryCollectBalance error', error.toString(), address, chain);
  617. return 0;
  618. }
  619. }
  620. /**
  621. * 用户充币地址的币转移到归集地址
  622. * 1、检查当前账户的 主流币或者 20 币,是否满足一美刀,并且查看是否满足转账费用 n 如果不满足,先从归集地址 -> 用户提币地址(0.*2 来回2次转移)
  623. * 2、发起归集 用户账户 -> 从 mysql 拿到私钥进行解密 -> 转移到归集地址
  624. *
  625. *
  626. * @param {*} obj
  627. */
  628. const collectCoins = async (obj) => {
  629. var chain = obj.chain;
  630. //1、拿到当前账户所有的币
  631. //2、是否满足交易费 如果不满足则 归集地址转移 币count * 手续费 到充币地址
  632. //3、遍历所有币,开始转移到归集地址
  633. // 日志上报的参数
  634. var logParams = {};
  635. obj.createTime = utils.getCurrentDate()
  636. logger.log('fun collectCoins in =', obj)
  637. var my_account_all_coins = await getAccountAllCoins(obj);
  638. logger.log('collectCoins getAccountAllCoins=', my_account_all_coins)
  639. if (!my_account_all_coins.native && !my_account_all_coins.other) {
  640. return 'getAccountAllCoins error.' + my_account_all_coins
  641. }
  642. //埋点日志-转账之前的充币地址余额
  643. logParams.addressBalances = { ...my_account_all_coins };
  644. //得到币价格
  645. if (process.env.NODE_ENV == 'dev') {
  646. var test_json = '{"tokenPrice": [{"contract": "0x0000000000000000000000000000000000000000", "usdPrice": 400}, {"contract": "0x03716F32f72c692a0B355fa04639669E3341B94e", "usdPrice": 0.1}]}'
  647. obj.tokenPrices = JSON.parse(test_json);
  648. } else {
  649. obj.tokenPrices = await redis.readRedis(reids_token_config.TOKENPRICE)
  650. if (!obj.tokenPrices) {
  651. logger.error('readRedis TOKENPRICE error')
  652. return 'readRedis error'
  653. }
  654. if (typeof obj.tokenPrices == 'string')
  655. obj.tokenPrices = JSON.parse(obj.tokenPrices);
  656. }
  657. logger.log('tokenPrices=', obj.tokenPrices)
  658. obj.chain = chain;
  659. //计算 gas 费用 是否需要归集
  660. var transFerGasFree = await computeTransferGasFree(obj, my_account_all_coins, obj.tokenPrices);
  661. //埋点日志- 需要归集的 native token
  662. if (transFerGasFree.transfer_obj && Array.isArray(transFerGasFree.transfer_obj)) {
  663. logParams.transfers = []
  664. for (let index = 0; index < transFerGasFree.transfer_obj.length; index++) {
  665. const element = transFerGasFree.transfer_obj[index];
  666. logParams.transfers.push({ ...element })
  667. }
  668. }
  669. logger.log('computeTransferGasFree=', transFerGasFree)
  670. logger.log(' logParams.transfers=', logParams.transfers)
  671. //是否需要归集
  672. if (transFerGasFree.totalCount > 0) {
  673. //需要转移 gas 费
  674. //每次都需要充值 gas 费
  675. if (account_config.TRANSFER_GAS || (parseInt(transFerGasFree.gasPrice) > 0 && transFerGasFree.get_service_charge == 1)) {
  676. var info = await queryCompanyInfoFromId(0);
  677. var obj_wd = {
  678. chain: chain,
  679. amount: transFerGasFree.gasPrice,
  680. receiver: obj.address,
  681. type: 'native',
  682. // address: account_config.WELLET_PUBLIC_KEY, //todo 正式环境需要替换从 mysql read
  683. address: info.user_address, //todo 正式环境需要替换从 mysql read
  684. }
  685. //埋点日志-预存 gas 付费
  686. logParams.prestore_gas_fee = { ...obj_wd };
  687. logParams.receiver_address_total_balance_before = await queryCollectBalance(info.user_address, chain)
  688. logParams.company_public_key = info.user_address
  689. logger.log('开始充值 gas ', obj_wd)
  690. var ret = await withdraw(obj_wd)
  691. logger.log('充值完成 gas ', ret)
  692. if (!isTransferSucceed(ret)) return ret;
  693. var transfer = getTransferGasFree('native', ret)
  694. logger.log('getTransferGasFree transfer =', transfer)
  695. if (transfer && transfer.nativeValue > 0) {
  696. logger.log('tempNativeValue=', my_account_all_coins.native.balance)
  697. await updateNativeBalance(my_account_all_coins.native.balance, obj);
  698. var tempNativeValue = addNativeValue(my_account_all_coins.native.balance, transfer.nativeValue)
  699. my_account_all_coins.native.balance = tempNativeValue.toString();
  700. logger.log('udpateNativeValue=', tempNativeValue);
  701. } else return "get native value error."
  702. }
  703. obj.chain = chain;
  704. obj.transFerGasFree = transFerGasFree;
  705. logger.log('transfers--->', obj);
  706. var ret = await transfers(obj, my_account_all_coins, logParams);
  707. logger.log('归集结果=', ret);
  708. return ret;
  709. }
  710. return obj.address + ':不满足归集条件';
  711. }
  712. async function execCollectCoinsTask() {
  713. logger.log('execCollectCoinsTask in', collectCoinsArrays.length)
  714. if (isExecCollect) return
  715. isExecCollect = true;
  716. while (collectCoinsArrays.length > 0) {
  717. var obj = collectCoinsArrays.pop();
  718. //开始收集用户地址里面的币到归集地址
  719. var ret = await collectCoins(obj);
  720. // await utils.sleep(3000)
  721. logger.log('execCollectCoinsTask=', collectCoinsArrays.length, ret)
  722. }
  723. isExecCollect = false;
  724. logger.log('execCollectCoinsTask out', collectCoinsArrays.length)
  725. }
  726. function pushCollectConisObj(obj) {
  727. logger.log('collectCoinsArrays length=', collectCoinsArrays.length, collectCoinsArrays)
  728. if (collectCoinsArrays.length > 0) {
  729. var findItem = collectCoinsArrays.find(element => {
  730. return (obj.address == element.address)
  731. })
  732. if (findItem) {
  733. logger.log('当前任务正在处理中...', obj.address)
  734. return;
  735. }
  736. }
  737. collectCoinsArrays.push(obj)
  738. execCollectCoinsTask();
  739. }
  740. async function readPriveteKeyFromMysql(address) {
  741. return new Promise(resolve => {
  742. mysql.queryUserPrivateKeyFromUserAddress(address).then(ret => {
  743. logger.log('readPriveteKeyFromMysql=', ret);
  744. resolve(ret);
  745. })
  746. })
  747. }
  748. async function queryCompanyInfoFromId(id) {
  749. return new Promise(resolve => {
  750. mysql.queryCompanyInfoFromId(id).then(ret => {
  751. logger.log('queryCompanyInfoFromId=', ret, ret.results, ret.results.user_address, ret.results.user_private_key);
  752. resolve(ret.results);
  753. })
  754. })
  755. }
  756. const transfer = async (obj) => {
  757. logger.debug("fun transfer serverUrl ", serverUrl);
  758. logger.debug("fun transfer appId ", serverUrl);
  759. logger.debug("fun transfer moralisSecret ", moralisSecret);
  760. await initMoralisSecretSDK();
  761. // initSDK(moralisSecret);
  762. logger.debug("fun transfer start ok ");
  763. const opts = {};
  764. opts.chainId = 'bsc_testnet';
  765. opts.privateKey = moralis_config.DEFAULT_PRIVATE_KEY;
  766. opts.type = "erc20"; //native erc20
  767. if (!obj.receiver || !obj.amount || parseInt(obj.amount) <= 0) {
  768. logger.error("transfer fun transfer parameter error.", obj.receiver, obj.amount, obj.amount);
  769. return toJson(ERROR_CODE_001, null, "please check receiver or amount parameter is ok ?");
  770. }
  771. if (obj.chain != null) {
  772. opts.chainId = utils.getChainId(obj.chain);
  773. console.log("chainId:", opts.chainId);
  774. }
  775. if (obj.type != null) {
  776. opts.type = obj.type;
  777. }
  778. if (obj.from_block != null) {
  779. opts.from_block = obj.from_block;
  780. }
  781. if (obj.to_block != null) {
  782. opts.to_block = obj.to_block;
  783. }
  784. opts.contractAddress = obj.contractAddress;
  785. opts.receiver = obj.receiver;
  786. //调用者传入
  787. // opts.amount = Moralis.Units.Token(obj.amount, 18);
  788. opts.amount = obj.amount;
  789. if (obj.privateKey != null) {
  790. opts.privateKey = obj.privateKey;
  791. }
  792. var options;
  793. try {
  794. // sending 0.5 DAI tokens with 18 decimals on BSC testnet
  795. if (opts.contractAddress) { //如果存在就是代币
  796. // if (opts.contractAddress == SHIB_ADDRESS) {
  797. // //提币金额必须大于 20000 ,手续费 10000
  798. // if (parseInt(opts.amount) >= SHIB_AMOUNT_LIMIT) {
  799. // opts.amount = (parseInt(opts.amount) - SHIB_AMOUNT_FEE_LIMIT).toString()
  800. // } else {
  801. // return toJson(-1, null, "最低限额为 20000 个token.");
  802. // }
  803. // }
  804. options = Moralis.TransferOptions = {
  805. type: opts.type,
  806. amount: opts.amount,
  807. receiver: opts.receiver, //接收钱包地址
  808. contractAddress: opts.contractAddress //用户合约地址
  809. };
  810. logger.tlog("options 20 =", options);
  811. } else { //ETH or BNB
  812. options = Moralis.TransferOptions = {
  813. type: opts.type,
  814. amount: opts.amount,
  815. receiver: opts.receiver, //接收钱包地址
  816. };
  817. logger.tlog("options native =", options, opts.chainId);
  818. }
  819. // Enable web3
  820. await Moralis.enableWeb3({
  821. //BSC mainnet = 0x38-56 testnet:0x61-97
  822. chainId: opts.chainId,
  823. privateKey: opts.privateKey,
  824. });
  825. logger.tlog("options id =", opts.chainId);
  826. var ret = await Moralis.transfer(options);
  827. logger.tlog("transfer 结果 =", ret);
  828. return toJson(SUCCEED_CODE, ret, "");
  829. } catch (error) {
  830. logger.tlog('transfer error:', error);
  831. logger.error('重要消息-重要消息-重要消息 transfer error:', error.toString(), JSON.stringify(options))
  832. if (error.reason != null) {
  833. return toJson(ERROR_CODE_001, null, error.toString());
  834. } else {
  835. return toJson(ERROR_CODE_001, null, error.toString());
  836. }
  837. }
  838. };
  839. const getAllTokenWithdrawInfoLists = async (obj) => {
  840. try {
  841. var key = reids_token_config.TOKENWITHDRAW;
  842. var ret = await redis.readRedis(key);
  843. return toJson(SUCCEED_CODE, ret, null);
  844. } catch (error) {
  845. console.error("getAllTokenWithdrawInfoLists=", error);
  846. return toJson(ERROR_CODE_001, null, error.toString());
  847. }
  848. }
  849. /**
  850. * 获取代币价格 -> usdPrice
  851. */
  852. const getAllTotkenPrice = async () => {
  853. try {
  854. logger.log('当前环境:', process.env.NODE_ENV);
  855. logger.log("getAllTotkenPrice in", reids_token_config); // Prints "value"
  856. var token_price_key = reids_token_config.TOKENPRICE;
  857. logger.log("getAllTotkenPrice token_price_key=", token_price_key);
  858. return await redis.readRedis(token_price_key)
  859. } catch (error) {
  860. logger.error("getTotkenPrice=", error);
  861. return toJson(ERROR_CODE_001, null, error.toString());
  862. }
  863. }
  864. function setTransfersDataType(type, ret) {
  865. if (ret && Array.isArray(ret) && ret.length > 0) {
  866. ret.forEach(element => {
  867. element.type = type;
  868. });
  869. }
  870. }
  871. //获取交易记录
  872. //hash 0xe09ba3a4c9f7a8902e01af68d0f1f91906f3f7db1195227e61c45c0e86b2630a
  873. async function getTokenTransfers(opt) {
  874. await initMasterSDK();
  875. logger.log("fun getTokenTransfers in ", opt);
  876. const options = {};
  877. options.type = 'all';
  878. options.chain = 'bsc_mainnet';
  879. if (opt.chain != null) {
  880. options.chain = utils.getChainName(opt.chain);
  881. logger.log('getTokenTransfers getChainName =', options.chain);
  882. }
  883. if (opt.order != null) {
  884. options.order = opt.order;
  885. }
  886. if (opt.startTime != null) {
  887. options.from_date = opt.startTime;
  888. }
  889. if (opt.endTime != null) {
  890. options.to_date = opt.endTime;
  891. }
  892. if (opt.from_block != null) {
  893. options.from_block = opt.from_block;
  894. }
  895. if (opt.to_block != null) {
  896. options.to_block = opt.to_block;
  897. }
  898. if (opt.transaction_hash) {
  899. options.transaction_hash = opt.transaction_hash;
  900. options.type = 'transaction_hash';
  901. }
  902. logger.log('getTokenTransfers >>>>>', options);
  903. if (options.type == 'all') {//查询主流币和 20 币所有的交易
  904. if (opt.address != null) {
  905. options.address = opt.address;
  906. } else {
  907. logger.error('getTokenTransfers error please check address parameter is ok ?', options);
  908. return toJson(ERROR_CODE_001, null, "please check address parameter is ok ?");
  909. }
  910. var t_1
  911. var t_2
  912. // Error: Request failed with status code 524
  913. // 做一次重试
  914. var tryCount = 4;
  915. var delay = 1000
  916. var interval = 500
  917. do {
  918. //主流币
  919. try {
  920. logger.log('getTokenTransfers account getTransactions>>>>>', options);
  921. t_1 = await Moralis.Web3API.account.getTransactions(options);
  922. logger.log('getTokenTransfers native ret -->>> t_1', t_1);
  923. setTransfersDataType('native', t_1.result)
  924. break
  925. } catch (error) {
  926. if (tryCount == 1) {
  927. logger.error("getTransactions error:", '主流币:', error.toString(), JSON.stringify(options))
  928. return toJson(ERROR_CODE_001, null, error.toString());
  929. }
  930. tryCount -= 1;
  931. await utils.sleep(delay)
  932. delay += interval
  933. }
  934. } while (tryCount >= 1);
  935. // Error: Request failed with status code 524
  936. tryCount = 4
  937. delay = 1000
  938. interval = 500
  939. do {
  940. //20币
  941. try {
  942. //token 获取交易记录如果没有时间有些地址会失败
  943. if (!options.to_block) {
  944. options.to_block = '10000000000'
  945. }
  946. logger.log('getTokenTransfers account getTokenTransfers>>>>>', options);
  947. t_2 = await Moralis.Web3API.account.getTokenTransfers(options);
  948. logger.log('getTokenTransfers token ret -->>> t_2', t_2);
  949. setTransfersDataType('token', t_2.result)
  950. break
  951. } catch (error) {
  952. if (tryCount == 1) {
  953. logger.error("getTransactions error:", 'token币:', error.toString(), JSON.stringify(options))
  954. return toJson(ERROR_CODE_001, null, error.toString());
  955. }
  956. tryCount -= 1;
  957. await utils.sleep(delay)
  958. delay += interval
  959. }
  960. } while (tryCount >= 1);
  961. //异常
  962. if (t_2 && t_2.total > 0 && Array.isArray(t_2.result) && t_2.result.length <= 0) {
  963. logger.error('getTokenTransfers token 数据异常 -->>>', t_2.toString(), JSON.stringify(options));
  964. return toJson(ERROR_CODE_001, null, 'token 数据异常.');
  965. }
  966. //排序组合
  967. try {
  968. let arr = t_1.result;
  969. let arr1 = t_2.result;
  970. if (Array.isArray(arr1) && Array.isArray(arr)) {
  971. let arr2 = arr.concat(arr1);
  972. t_1.result = arr2;
  973. logger.log('getTokenTransfers-->>>concat t_1', t_1, t_1.result.length);
  974. if (t_1.total != null) {
  975. t_1.total = t_1.result.length
  976. logger.log('getTokenTransfers-->>>concat total', t_1.total);
  977. }
  978. }
  979. //将结果排序
  980. t_1.result.sort((a, b) => {
  981. let t1 = new Date(Date.parse(a.block_timestamp))
  982. let t2 = new Date(Date.parse(b.block_timestamp))
  983. return t2.getTime() - t1.getTime()
  984. })
  985. logger.log('getTokenTransfers-->>> sort t_1', t_1);
  986. return toJson(SUCCEED_CODE, t_1, null);
  987. } catch (error) {
  988. logger.error("getTransactions 排序组合 error :", error.toString(), JSON.stringify(options), JSON.stringify(t_1), JSON.stringify(t_2))
  989. return toJson(ERROR_CODE_001, null, error.toString());
  990. }
  991. } else if (options.type == 'transaction_hash') {//根据哈希查询
  992. var tryCount = 2
  993. do {
  994. try {
  995. logger.log('transaction_hash getTransaction options-->>> ', options);
  996. //native
  997. const transaction = await Moralis.Web3API.native.getTransaction(options);
  998. var arr = [];
  999. if (transaction)
  1000. arr.push(transaction)
  1001. var obj = { result: arr }
  1002. logger.log('transaction_hash getTransaction ret-->>> ', transaction, obj);
  1003. return toJson(SUCCEED_CODE, obj, null);
  1004. } catch (error) {
  1005. if (tryCount == 1) {
  1006. logger.error("native getTransaction error:", error.toString(), JSON.stringify(options))
  1007. return toJson(ERROR_CODE_001, null, error.toString());
  1008. }
  1009. tryCount -= 1;
  1010. }
  1011. } while (tryCount >= 1);
  1012. } else {
  1013. return toJson(ERROR_CODE_001, null, "This type is not supported.");;
  1014. }
  1015. }
  1016. //获取交易记录
  1017. //hash 0xe09ba3a4c9f7a8902e01af68d0f1f91906f3f7db1195227e61c45c0e86b2630a
  1018. async function getTokenTransfersV2(opt) {
  1019. await initMasterSDK();
  1020. logger.log("fun getTokenTransfersV2 in ", opt);
  1021. const options = {};
  1022. options.type = 'all';
  1023. options.chain = 'bsc_mainnet';
  1024. if (opt.chain != null) {
  1025. options.chain = utils.getChainName(opt.chain);
  1026. logger.log('getTokenTransfersV2 getChainName =', options.chain);
  1027. }
  1028. if (opt.order != null) {
  1029. options.order = opt.order;
  1030. }
  1031. if (opt.startTime != null) {
  1032. options.from_date = opt.startTime;
  1033. }
  1034. if (opt.endTime != null) {
  1035. options.to_date = opt.endTime;
  1036. }
  1037. if (opt.from_block != null) {
  1038. options.from_block = opt.from_block;
  1039. }
  1040. if (opt.to_block != null) {
  1041. options.to_block = opt.to_block;
  1042. }
  1043. if (opt.transaction_hash) {
  1044. options.transaction_hash = opt.transaction_hash;
  1045. options.type = 'transaction_hash';
  1046. }
  1047. logger.log('getTokenTransfersV2 >>>>>', options);
  1048. if (options.type == 'all') {//查询主流币和 20 币所有的交易
  1049. if (opt.address != null) {
  1050. options.address = opt.address;
  1051. } else {
  1052. logger.error('getTokenTransfersV2 error please check address parameter is ok ?', options);
  1053. return toJson(ERROR_CODE_001, null, "please check address parameter is ok ?");
  1054. }
  1055. var t_1
  1056. var t_2
  1057. // Error: Request failed with status code 524
  1058. // 做一次重试
  1059. var tryCount = 4;
  1060. var delay = 1000
  1061. var interval = 500
  1062. do {
  1063. //主流币
  1064. try {
  1065. logger.log('getTokenTransfersV2 account getTransactions>>>>>', options);
  1066. t_1 = await getTransferRecord(options, 'native', 1);
  1067. logger.log('getTokenTransfersV2 native ret -->>> t_1', t_1);
  1068. break
  1069. } catch (error) {
  1070. if (tryCount == 1) {
  1071. t_1 = await getTransferRecord(options, 'native', 0);
  1072. if (t_1) {
  1073. logger.error('sync-node-native-data', JSON.stringify(t_1))
  1074. break
  1075. } else {
  1076. logger.error('sync-node-native-data error', JSON.stringify(options))
  1077. }
  1078. logger.error("getTokenTransfersV2 error:", '主流币:', error.toString(), JSON.stringify(options))
  1079. return toJson(ERROR_CODE_001, null, error.toString());
  1080. }
  1081. tryCount -= 1;
  1082. await utils.sleep(delay)
  1083. delay += interval
  1084. }
  1085. } while (tryCount >= 1);
  1086. // Error: Request failed with status code 524
  1087. tryCount = 4
  1088. delay = 1000
  1089. interval = 500
  1090. do {
  1091. //20币
  1092. try {
  1093. //token 获取交易记录如果没有时间有些地址会失败
  1094. if (!options.to_block) {
  1095. options.to_block = '10000000000'
  1096. }
  1097. logger.log('getTokenTransfersV2 account getTokenTransfers>>>>>', options);
  1098. t_2 = await getTransferRecord(options, 'token', 1);
  1099. logger.log('getTokenTransfersV2 token ret -->>> t_2', t_2);
  1100. break
  1101. } catch (error) {
  1102. if (tryCount == 1) {
  1103. t_2 = await getTransferRecord(options, 'token', 0);
  1104. if (t_2) {
  1105. logger.error('sync-node-token-data', JSON.stringify(t_2))
  1106. break
  1107. } else {
  1108. logger.error('sync-node-token-data error', JSON.stringify(options))
  1109. }
  1110. logger.error("getTokenTransfersV2 error:", 'token币:', error.toString(), JSON.stringify(options))
  1111. return toJson(ERROR_CODE_001, null, error.toString());
  1112. }
  1113. tryCount -= 1;
  1114. await utils.sleep(delay)
  1115. delay += interval
  1116. }
  1117. } while (tryCount >= 1);
  1118. //异常
  1119. if (t_2 && t_2.data.total > 0 && Array.isArray(t_2.data.results) && t_2.data.results.length <= 0) {
  1120. logger.error('getTokenTransfersV2 token 数据异常 -->>>', t_2.toString(), JSON.stringify(options));
  1121. return toJson(ERROR_CODE_001, null, 'token 数据异常.');
  1122. }
  1123. //排序组合
  1124. try {
  1125. let arr = t_1.data.results;
  1126. let arr1 = t_2.data.results;
  1127. if (Array.isArray(arr1) && Array.isArray(arr)) {
  1128. let arr2 = arr.concat(arr1);
  1129. t_1.data.results = arr2;
  1130. logger.log('getTokenTransfersV2-->>>concat t_1', t_1, t_1.data.results.length);
  1131. if (t_1.data.total != null) {
  1132. t_1.data.total = t_1.data.results.length
  1133. logger.log('getTokenTransfersV2-->>>concat total', t_1.data.total);
  1134. }
  1135. }
  1136. //将结果排序
  1137. t_1.data.results.sort((a, b) => {
  1138. let t1 = new Date(Date.parse(a.block_timestamp))
  1139. let t2 = new Date(Date.parse(b.block_timestamp))
  1140. return t2.getTime() - t1.getTime()
  1141. })
  1142. logger.log('getTokenTransfersV2-->>> sort t_1', t_1);
  1143. return toJson(SUCCEED_CODE, t_1.data, null);
  1144. } catch (error) {
  1145. logger.error("getTokenTransfersV2 排序组合 error :", error.toString(), JSON.stringify(options), JSON.stringify(t_1), JSON.stringify(t_2))
  1146. return toJson(ERROR_CODE_001, null, error.toString());
  1147. }
  1148. } else if (options.type == 'transaction_hash') {//根据哈希查询
  1149. var tryCount = 2
  1150. do {
  1151. try {
  1152. logger.log('getTokenTransfersV2 getTransaction options-->>> ', options);
  1153. const transaction = await getTransferRecord(options, 'hash', 1);
  1154. logger.log('getTokenTransfersV2 getTransaction ret-->>> ', transaction);
  1155. return transaction;
  1156. } catch (error) {
  1157. if (tryCount == 1) {
  1158. logger.error("native getTokenTransfersV2 error:", error.toString(), JSON.stringify(options))
  1159. var transaction = await getTransferRecord(options, 'hash', 0);
  1160. if (transaction) {
  1161. logger.error('sync-node-hash-data', JSON.stringify(transaction))
  1162. logger.log('getTokenTransfersV2 getTransaction ret-->>> ', transaction);
  1163. return transaction;
  1164. }
  1165. return toJson(ERROR_CODE_001, null, error.toString());
  1166. }
  1167. tryCount -= 1;
  1168. }
  1169. } while (tryCount >= 1);
  1170. } else {
  1171. return toJson(ERROR_CODE_001, null, "This type is not supported.");;
  1172. }
  1173. }
  1174. /**
  1175. * 获取交易记录 token,native
  1176. * @param {} opts
  1177. */
  1178. async function getTransferRecord(opts, type, use_moralis_sdk_) {
  1179. logger.info('getTransferRecord>>>>>>>>', opts, type)
  1180. //是否使用 moralis sdk 进行查询
  1181. var use_moralis_sdk = use_moralis_sdk_
  1182. var temp_opts = { ...opts }
  1183. if (use_moralis_sdk) {
  1184. var results = []
  1185. if (type == 'native') {
  1186. var ret = await Moralis.Web3API.account.getTransactions(temp_opts)
  1187. if (ret.total > 0 && Array.isArray(ret.result) && ret.result.length > 0) {
  1188. for (let index = 0; index < ret.result.length; index++) {
  1189. const element = ret.result[index];
  1190. results.push({
  1191. type: 'native',
  1192. from_address: element.from_address,
  1193. to_address: element.to_address,
  1194. token_address: null,
  1195. block_number: element.block_number,
  1196. value: element.value,
  1197. gas: element.gas,
  1198. gas_price: element.gas_price,
  1199. block_timestamp: element.block_timestamp,
  1200. trx_hash: element.hash,
  1201. responseType:'moralis'
  1202. })
  1203. }
  1204. }
  1205. } else if (type == 'token') {
  1206. var ret = await Moralis.Web3API.account.getTokenTransfers(temp_opts);
  1207. if (ret.total > 0 && Array.isArray(ret.result) && ret.result.length > 0) {
  1208. for (let index = 0; index < ret.result.length; index++) {
  1209. const element = ret.result[index];
  1210. results.push({
  1211. type: 'token',
  1212. from_address: element.from_address,
  1213. to_address: element.to_address,
  1214. token_address: element.address,
  1215. block_number: element.block_number,
  1216. value: element.value,
  1217. block_timestamp: element.block_timestamp,
  1218. trx_hash: element.transaction_hash,
  1219. responseType:'moralis'
  1220. })
  1221. }
  1222. }
  1223. } else if (type == 'hash') {
  1224. var ret = await Moralis.Web3API.native.getTransaction(temp_opts);
  1225. if (ret)
  1226. results.push({
  1227. type: 'hash',
  1228. from_address: ret.from_address,
  1229. to_address: ret.to_address,
  1230. token_address: null,
  1231. block_number: ret.block_number,
  1232. value: ret.value,
  1233. gas: ret.gas,
  1234. gas_price: ret.gas_price,
  1235. block_timestamp: ret.block_timestamp,
  1236. trx_hash: ret.hash,
  1237. responseType:'moralis'
  1238. })
  1239. }
  1240. return {
  1241. code: 0,
  1242. data: {
  1243. total: results.length,
  1244. results: results
  1245. },
  1246. errMsg: null,
  1247. }
  1248. } else { //使用自建节点缓存 mysql 查询
  1249. if (type == 'native') {
  1250. temp_opts.type = 'native'
  1251. return await account_mysql.getAccountTransactions(temp_opts)
  1252. } else if (type == 'token') {
  1253. temp_opts.type = 'token'
  1254. return await account_mysql.getAccountTransactions(temp_opts)
  1255. } else if (type == 'hash') {
  1256. temp_opts.type = 'hash'
  1257. return await account_mysql.getAccountTransactions(temp_opts)
  1258. }
  1259. }
  1260. }
  1261. /**
  1262. * 获取 token or native 余额
  1263. * @param {*} opts
  1264. */
  1265. async function getBalances(opts, type) {
  1266. logger.info('getBalances>>>>>>>>', opts, type)
  1267. //是否使用 moralis sdk 进行查询
  1268. var use_moralis_sdk = 1
  1269. var temp_opts = { ...opts }
  1270. if (use_moralis_sdk) {
  1271. if (type == 'native') {
  1272. return await Moralis.Web3API.account.getNativeBalance(temp_opts);
  1273. } else if (type == 'token') {
  1274. return await Moralis.Web3API.account.getTokenBalances(temp_opts);
  1275. }
  1276. } else {
  1277. }
  1278. }
  1279. module.exports = {
  1280. transfer,
  1281. getTokenTransfers,
  1282. getTokenTransfersV2,
  1283. toJson,
  1284. getAllTokenWithdrawInfoLists,
  1285. getAllTotkenPrice,
  1286. withdraw,
  1287. collectCoins,
  1288. isTransferSucceed,
  1289. getTransferRecordGasFree,
  1290. pushCollectConisObj,
  1291. getTransferGasFree,
  1292. queryCollectBalance,
  1293. queryCompanyInfoFromId,
  1294. }