diff options
| author | Ran Guin <[email protected]> | 2021-07-28 21:56:24 -0700 |
|---|---|---|
| committer | Adam Soltys <[email protected]> | 2021-07-29 11:55:26 -0700 |
| commit | b9c885e262038b9bddb3f4ec1a6721ac1cd2c520 (patch) | |
| tree | e67755ef0825863cd309520e9592206b561faa8e | |
| parent | cddf4922df8d32de7d104a18816c3935a71d9bad (diff) | |
| download | coinos-server-b9c885e262038b9bddb3f4ec1a6721ac1cd2c520.tar.gz coinos-server-b9c885e262038b9bddb3f4ec1a6721ac1cd2c520.zip | |
remove network & currency from kyc output; reduce threshold to 200k SAT
| -rw-r--r-- | routes/admin.js | 12 |
1 files changed, 7 insertions, 5 deletions
diff --git a/routes/admin.js b/routes/admin.js index fd65474a..c401c724 100644 --- a/routes/admin.js +++ b/routes/admin.js @@ -646,14 +646,16 @@ router.get( ah(async (req, res) => { var {since, search, starts_with, contains} = req.query + var threshold = '0.2' + var kyc = knex .select( knex.raw("CONCAT( FORMAT(Max(amount)/1000000, 1), ' M') as max"), 'username', 'users.email', 'users.verified as kyc_verified', - 'payments.currency', - 'payments.network', + // 'payments.currency', + // 'payments.network', // knex.raw('LEFT(hash,20) as hash'), // knex.raw('Left(payments.updatedAt,16) as transferred') ) @@ -661,8 +663,8 @@ router.get( .leftJoin('accounts', 'payments.account_id', 'accounts.id') .leftJoin('users', 'payments.user_id', 'users.id') // should really point to accounts .groupBy('users.id') - .groupBy('payments.currency') - .groupBy('payments.network') + // .groupBy('payments.currency') + // .groupBy('payments.network') if (since) { kyc = kyc @@ -684,7 +686,7 @@ router.get( this.orWhere('users.username', 'like', search) }) } - var found = await kyc.having('max', '>=', 2.1) + var found = await kyc.having('max', '>=', threshold) debug('payments: ' + JSON.stringify(found)) return res.send({kyc_transactions: found}) |