lib/utils.js



e166ab2c ^

c8c2b9df ^
fae6e8b5 ^
e166ab2c ^
fae6e8b5 ^

fae6e8b5 ^


e166ab2c ^


994dd93f ^
e166ab2c ^


63c18105 ^


e166ab2c ^


fae6e8b5 ^


994dd93f ^
fae6e8b5 ^

fae6e8b5 ^


e166ab2c ^


994dd93f ^
e166ab2c ^


63c18105 ^


e166ab2c ^


c8c2b9df ^

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80


const sequelize = require("sequelize");
const { Op } = sequelize;

getUser = async username => {
  let user = await db.User.findOne({
    include: [
      {
        model: db.Account,
        as: "accounts"
      },
      {
        model: db.Account,
        as: "account"
      }
    ],
    where: { username }
  });

  user = user.get({ plain: true });

  user.payments = await db.Payment.findAll({
    order: [["id", "DESC"]],
    where: {
      user_id: user.id,
      account_id: user.account_id,
      [Op.or]: {
        received: true,
        amount: {
          [Op.lt]: 0
        }
      }
    },
    limit: 12,
    include: {
      model: db.Account,
      as: "account"
    }
  });

  return user;
};

getUserById = async id => {
  let user = await db.User.findOne({
    include: [
      {
        model: db.Account,
        as: "accounts"
      },
      {
        model: db.Account,
        as: "account"
      }
    ],
    where: { id }
  });

  user = user.get({ plain: true });

  user.payments = await db.Payment.findAll({
    order: [["id", "DESC"]],
    where: {
      user_id: user.id,
      account_id: user.account_id,
      [Op.or]: {
        received: true,
        amount: {
          [Op.lt]: 0
        }
      }
    },
    limit: 12,
    include: {
      model: db.Account,
      as: "account"
    }
  });

  return user;
};