diff options
| author | Adam Soltys <[email protected]> | 2021-07-29 11:50:23 -0700 |
|---|---|---|
| committer | Adam Soltys <[email protected]> | 2021-07-29 11:50:23 -0700 |
| commit | 097001f82bcd2da328c1dd0bf61aec879814a1a5 (patch) | |
| tree | 8cdd3c857daa0ae21004605bf8ab72c3b51269e9 /routes | |
| parent | 9bb2eb1dbaaddbd92427705bc2d4747cbf5710a6 (diff) | |
| parent | ed68ee893ae7bb3540f0731c3ccf21a26bc6ac1f (diff) | |
| download | coinos-server-097001f82bcd2da328c1dd0bf61aec879814a1a5.tar.gz coinos-server-097001f82bcd2da328c1dd0bf61aec879814a1a5.zip | |
Merge branch 'dev'
Diffstat (limited to 'routes')
| -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}) |