moralis_sdk.js 54 KB

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