diff options
| author | Ran Guin <[email protected]> | 2021-07-05 15:29:37 -0700 |
|---|---|---|
| committer | Ran Guin <[email protected]> | 2021-07-05 15:29:37 -0700 |
| commit | 9bf4080d67d6342624c8f1fb543acab00191f730 (patch) | |
| tree | 7be21e9e19b90581bbde4ff19221e0a3fbb9011a | |
| parent | d0d8ae8f6d6624f3e08f2ff29d1448e9c320ebd3 (diff) | |
| download | coinos-server-9bf4080d67d6342624c8f1fb543acab00191f730.tar.gz coinos-server-9bf4080d67d6342624c8f1fb543acab00191f730.zip | |
generate distinct counts for payment types
| -rw-r--r-- | routes/admin.js | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/routes/admin.js b/routes/admin.js index a2d07178..a2055c7c 100644 --- a/routes/admin.js +++ b/routes/admin.js @@ -207,7 +207,7 @@ router.get( transactions = transactions .select( - knex.raw('COUNT(' + types[i] + '.id) as ' + types[i]), + knex.raw('COUNT(DISTINCT ' + types[i] + '.id) as ' + types[i]), knex.raw('LEFT(MAX(' + types[i] + '.updatedAt), 10) as ' + stamp) ) .leftJoin(types[i], 'users.id', types[i] + '.user_id') |