1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
|
const sequelize = require("sequelize");
app.get("/balances", async (req, res) => {
const balances = {
bitcoin: parseInt((await bc.getBalance()) * SATS),
liquid: parseInt((await lq.getBalance()).bitcoin * SATS),
channel: (await lna.channelBalance({})).balance,
wallet: (await lna.walletBalance({})).total_balance,
user: (await db['User'].findAll({
attributes: [[sequelize.fn('sum', sequelize.col('balance')), 'total']],
raw: true,
order: sequelize.literal('total DESC')
}))[0].total,
};
const { bitcoin, liquid, channel, user, wallet } = balances;
balances.ratio = ((parseInt(bitcoin) + parseInt(liquid) + parseInt(channel) + parseInt(wallet))/parseInt(user)).toFixed(2);
res.send(balances);
});
|
