aboutsummaryrefslogtreecommitdiffstats
path: root/routes
diff options
context:
space:
mode:
Diffstat (limited to 'routes')
-rw-r--r--pre { line-height: 125%; } td.linenos .normal { color: inherit; background-color: transparent; padding-left: 5px; padding-right: 5px; } span.linenos { color: inherit; background-color: transparent; padding-left: 5px; padding-right: 5px; } td.linenos .special { color: #000000; background-color: #ffffc0; padding-left: 5px; padding-right: 5px; } span.linenos.special { color: #000000; background-color: #ffffc0; padding-left: 5px; padding-right: 5px; } .highlight .hll { background-color: #ffffcc } .highlight .c { color: #888 } /* Comment */ .highlight .err { color: #A61717; background-color: #E3D2D2 } /* Error */ .highlight .k { color: #080; font-weight: bold } /* Keyword */ .highlight .ch { color: #888 } /* Comment.Hashbang */ .highlight .cm { color: #888 } /* Comment.Multiline */ .highlight .cp { color: #C00; font-weight: bold } /* Comment.Preproc */ .highlight .cpf { color: #888 } /* Comment.PreprocFile */ .highlight .c1 { color: #888 } /* Comment.Single */ .highlight .cs { color: #C00; font-weight: bold; background-color: #FFF0F0 } /* Comment.Special */ .highlight .gd { color: #000; background-color: #FDD } /* Generic.Deleted */ .highlight .ge { font-style: italic } /* Generic.Emph */ .highlight .ges { font-weight: bold; font-style: italic } /* Generic.EmphStrong */ .highlight .gr { color: #A00 } /* Generic.Error */ .highlight .gh { color: #333 } /* Generic.Heading */ .highlight .gi { color: #000; background-color: #DFD } /* Generic.Inserted */ .highlight .go { color: #888 } /* Generic.Output */ .highlight .gp { color: #555 } /* Generic.Prompt */ .highlight .gs { font-weight: bold } /* Generic.Strong */ .highlight .gu { color: #666 } /* Generic.Subheading */ .highlight .gt { color: #A00 } /* Generic.Traceback */ .highlight .kc { color: #080; font-weight: bold } /* Keyword.Constant */ .highlight .kd { color: #080; font-weight: bold } /* Keyword.Declaration */ .highlight .kn { color: #080; font-weight: bold } /* Keyword.Namespace */ .highlight .kp { color: #080 } /* Keyword.Pseudo */ .highlight .kr { color: #080; font-weight: bold } /* Keyword.Reserved */ .highlight .kt { color: #888; font-weight: bold } /* Keyword.Type */ .highlight .m { color: #00D; font-weight: bold } /* Literal.Number */ .highlight .s { color: #D20; background-color: #FFF0F0 } /* Literal.String */ .highlight .na { color: #369 } /* Name.Attribute */ .highlight .nb { color: #038 } /* Name.Builtin */ .highlight .nc { color: #B06; font-weight: bold } /* Name.Class */ .highlight .no { color: #036; font-weight: bold } /* Name.Constant */ .highlight .nd { color: #555 } /* Name.Decorator */ .highlight .ne { color: #B06; font-weight: bold } /* Name.Exception */ .highlight .nf { color: #06B; font-weight: bold } /* Name.Function */ .highlight .nl { color: #369; font-style: italic } /* Name.Label */ .highlight .nn { color: #B06; font-weight: bold } /* Name.Namespace */ .highlight .py { color: #369; font-weight: bold } /* Name.Property */ .highlight .nt { color: #B06; font-weight: bold } /* Name.Tag */ .highlight .nv { color: #369 } /* Name.Variable */ .highlight .ow { color: #080 } /* Operator.Word */ .highlight .w { color: #BBB } /* Text.Whitespace */ .highlight .mb { color: #00D; font-weight: bold } /* Literal.Number.Bin */ .highlight .mf { color: #00D; font-weight: bold } /* Literal.Number.Float */ .highlight .mh { color: #00D; font-weight: bold } /* Literal.Number.Hex */ .highlight .mi { color: #00D; font-weight: bold } /* Literal.Number.Integer */ .highlight .mo { color: #00D; font-weight: bold } /* Literal.Number.Oct */ .highlight .sa { color: #D20; background-color: #FFF0F0 } /* Literal.String.Affix */ .highlight .sb { color: #D20; background-color: #FFF0F0 } /* Literal.String.Backtick */ .highlight .sc { color: #D20; background-color: #FFF0F0 } /* Literal.String.Char */ .highlight .dl { color: #D20; background-color: #FFF0F0 } /* Literal.String.Delimiter */ .highlight .sd { color: #D20; background-color: #FFF0F0 } /* Literal.String.Doc */ .highlight .s2 { color: #D20; background-color: #FFF0F0 } /* Literal.String.Double */ .highlight .se { color: #04D; background-color: #FFF0F0 } /* Literal.String.Escape */ .highlight .sh { color: #D20; background-color: #FFF0F0 } /* Literal.String.Heredoc */ .highlight .si { color: #33B; background-color: #FFF0F0 } /* Literal.String.Interpol */ .highlight .sx { color: #2B2; background-color: #F0FFF0 } /* Literal.String.Other */ .highlight .sr { color: #080; background-color: #FFF0FF } /* Literal.String.Regex */ .highlight .s1 { color: #D20; background-color: #FFF0F0 } /* Literal.String.Single */ .highlight .ss { color: #A60; background-color: #FFF0F0 } /* Literal.String.Symbol */ .highlight .bp { color: #038 } /* Name.Builtin.Pseudo */ .highlight .fm { color: #06B; font-weight: bold } /* Name.Function.Magic */ .highlight .vc { color: #369 } /* Name.Variable.Class */ .highlight .vg { color: #D70 } /* Name.Variable.Global */ .highlight .vi { color: #33B } /* Name.Variable.Instance */ .highlight .vm { color: #369 } /* Name.Variable.Magic */ .highlight .il { color: #00D; font-weight: bold } /* Literal.Number.Integer.Long */
<svg
  class="w-5"
  width="24"
  height="24"
  viewBox="0 0 24 24"
  fill="none"
  xmlns="http://www.w3.org/2000/svg"
>
  <path
    d="M15 19L8 12L15 5"
    stroke="currentColor"
    stroke-width="2"
    stroke-linecap="round"
    stroke-linejoin="round"
  />
</svg>
generated by cgit v1.2.3 (git 2.51.0) at 2026-10-27 10:18:03 +0000
add'>+ )
+ .from('orders')
+ .leftJoin('accounts as a1', 'a1.id', 'orders.a1_id')
+ .leftJoin('accounts as a2', 'a2.id', 'orders.a2_id')
+ .leftJoin('users as u1', 'a1.user_id', 'u1.id')
+ .leftJoin('users as u2', 'a2.user_id', 'u2.id')
if (since) {
- transactions = transactions
- .where(type + '.updatedAt', '>=', since)
+ orders = orders
+ .where('orders.updatedAt', '>=', since)
}
- debug(type + ' since ' + since)
- // .leftJoin('accounts', 'users.id', 'accounts.user_id')
- // .leftJoin('invoices', 'invoices.account_id', 'accounts.id')
- // .leftJoin('payments', 'payments.account_id', 'accounts.id')
- // .leftJoin('orders', 'orders.user_id', 'users.id')
- // .groupBy('users.id')
+ debug('orders since ' + since)
- // Alternative Sequelize query syntax (returns sub-tables as hash)
- // var referrals = await db.Referral.findAll({
- // include: [
- // {model: db.User, as: 'user', attributes: [['username', 'user']]},
- // {model: db.User, as: 'sponsor', attributes: [['username', 'sponsor']]}
- // ]
- // })
+ var found = await orders
+ debug('orders: ' + JSON.stringify(found))
+ return res.send({orders: found})
+ })
+);
- // var transactions = await db.User.findAll({
- // include: [
- // { model: db.Invoice, as: 'invoices' },
- // { model: db.Payment, as: 'payments' },
- // { model: db.Order, as: 'orders'}
- // ]
- // })
+/**
+ * @api {get} /invoices Retrieve summary of invoices
+ *
+ * @apiName invoices
+ * @apiGroup Admin
+ *
+ * @apiPermission admin
+ *
+ * @apiSuccess returns list of invoices
+ * @apiSuccessExample {json} Success-Response:
+ * HTTP/1.1 200 OK
+ * {
+ * "invoices" : [
+ * { "seller": 'Adam', "buyer": 'bob' ... },
+ ...
+ * ]
+ * }
+ */
+router.get(
+ "/invoices",
+ auth,
+ ah(async (req, res) => {
+ const {type, since} = req.query
- var found = await transactions
- debug('transactions: ' + JSON.stringify(found))
- return res.send({transactions: found})
+ var invoices = knex
+ .select(
+ 'username',
+ 'users.email',
+ 'invoices.currency',
+ 'invoices.amount',
+ 'accounts.network',
+ knex.raw('Left(invoices.updatedAt,16) as updated')
+ )
+ .from('invoices')
+ .leftJoin('accounts', 'invoices.account_id', 'accounts.id')
+ .leftJoin('users', 'accounts.user_id', 'users.id')
+
+ if (since) {
+ invoices = invoices
+ .where('invoices.updatedAt', '>=', since)
+ }
+
+ debug('invoices since ' + since)
+
+ var found = await invoices
+ debug('invoices: ' + JSON.stringify(found))
+ return res.send({invoices: found})
+ })
+);
+
+
+/**
+ * @api {get} /deposits Retrieve summary of deposits
+ *
+ * @apiName deposits
+ * @apiGroup Admin
+ *
+ * @apiPermission admin
+ *
+ * @apiSuccess returns list of deposits
+ * @apiSuccessExample {json} Success-Response:
+ * HTTP/1.1 200 OK
+ * {
+ * "deposits" : [
+ * { "seller": 'Adam', "buyer": 'bob' ... },
+ ...
+ * ]
+ * }
+ */
+router.get(
+ "/deposits",
+ auth,
+ ah(async (req, res) => {
+ const {type, since} = req.query
+
+ var deposits = knex
+ .select(
+ 'username',
+ 'users.email',
+ 'amount',
+ 'credited',
+ knex.raw('Left(deposits.updatedAt,16) as deposited')
+ )
+ .from('deposits')
+ .leftJoin('users', 'deposits.user_id', 'users.id')
+
+ if (since) {
+ deposits = deposits
+ .where('deposits.updatedAt', '>=', since)
+ }
+
+ debug('deposits since ' + since)
+
+ var found = await deposits
+ debug('deposits: ' + JSON.stringify(found))
+ return res.send({deposits: found})
+ })
+);
+
+/**
+ * @api {get} /withdrawals Retrieve summary of withdrawals
+ *
+ * @apiName withdrawals
+ * @apiGroup Admin
+ *
+ * @apiPermission admin
+ *
+ * @apiSuccess returns list of withdrawals
+ * @apiSuccessExample {json} Success-Response:
+ * HTTP/1.1 200 OK
+ * {
+ * "withdrawals" : [
+ * { "seller": 'Adam', "buyer": 'bob' ... },
+ ...
+ * ]
+ * }
+ */
+router.get(
+ "/withdrawals",
+ auth,
+ ah(async (req, res) => {
+ const {type, since} = req.query
+
+ var withdrawals = knex
+ .select(
+ 'username',
+ 'users.email',
+ 'amount',
+ 'notes',
+ knex.raw('Left(withdrawals.updatedAt,16) as withdrawn')
+ )
+ .from('withdrawals')
+ .leftJoin('users', 'withdrawals.user_id', 'users.id')
+
+ if (since) {
+ withdrawals = withdrawals
+ .where('withdrawals.updatedAt', '>=', since)
+ }
+
+ debug('withdrawals since ' + since)
+
+ var found = await withdrawals
+ debug('withdrawals: ' + JSON.stringify(found))
+ return res.send({withdrawals: found})
+ })
+);
+
+/**
+ * @api {get} /payments Retrieve summary of payments
+ *
+ * @apiName payments
+ * @apiGroup Admin
+ *
+ * @apiPermission admin
+ *
+ * @apiSuccess returns list of payments
+ * @apiSuccessExample {json} Success-Response:
+ * HTTP/1.1 200 OK
+ * {
+ * "payments" : [
+ * { "seller": 'Adam', "buyer": 'bob' ... },
+ ...
+ * ]
+ * }
+**/
+router.get(
+ "/payments",
+ auth,
+ ah(async (req, res) => {
+ const {type, since} = req.query
+
+ var payments = knex
+ .select(
+ 'username',
+ 'users.email',
+ 'amount',
+ 'payments.network',
+ knex.raw('LEFT(hash,20) as hash'),
+ knex.raw('Left(payments.updatedAt,16) as deposited')
+ )
+ .from('payments')
+ .leftJoin('accounts', 'payments.account_id', 'accounts.id')
+ .leftJoin('users', 'accounts.user_id', 'users.id')
+
+ if (since) {
+ payments = payments
+ .where('payments.updatedAt', '>=', since)
+ }
+
+ debug('payments since ' + since)
+
+ var found = await payments
+ debug('payments: ' + JSON.stringify(found))
+ return res.send({payments: found})
})
);
generated by cgit v1.2.3 (git 2.51.0) at 2026-10-27 10:18:03 +0000