summaryrefslogtreecommitdiffstats
path: root/server/api/user.js
blob: 9aba1fc7e22aa48111d5a4fcddaa7e4515ef7614 (plain) (blame)
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
/* global __appdir */
var path = require('path')
// var db = require(path.join(__appdir, 'lib', 'database')).connectionPool;
var db = require(path.join(__appdir, 'lib', 'sequelize'))
var jwt = require('jsonwebtoken')

module.exports = {
  info: function (req, res) {
    // Because veryfyToken was succesfully excecuted the request has the attribute token.
    const token = req.token
    // Decode the token.
    var decoded = jwt.decode(token, {complete: true})
    var userid = decoded.payload.user.id

    // db.query('SELECT * FROM users WHERE id=?', [userid], function(err, rows) {
    db.user.findOne({ where: { id: userid } }).then(userDb => {
      // if (err) return res.status(500).send({ auth: false, status: 'DATABASE_ERROR', error_message: 'SQL query failed.' });
      // user.id = rows[0].id;
      // user.username = rows[0].username;
      // user.email = rows[0].email;
      // user.name = rows[0].name;
      var user = { }
      user.id = userDb.id
      user.username = userDb.username
      user.email = userDb.email
      user.name = userDb.name
      res.status(200).send(user)
    })
  },

  getUserList: function(req, res) {
    db.user.findAll({
      attributes: ['id', 'username', 'name'],
      include: [{model: db.role, as: 'roles', attributes: ['name'] }]
    }).then(function (users) {
      res.status(200).send(users)
    })
  },

  grantRoles: function(req, res) {
    const roleIds = req.body.roleIds
    const userIds = req.body.userIds

    db.user.findAll({ where: { id: userIds } }).then(users => {
      users.forEach(user => {
        user.addRoles(roleIds)
      })
      res.status(200).send('success')
    })
  },

  revokeRoles: function(req, res) {
    const roleIds = req.body.roleIds
    const userIds = req.body.userIds

    db.user.findAll({ where: { id: userIds } }).then(users => {
      users.forEach(user => {
        user.removeRoles(roleIds)
      })
      res.status(200).send('success')
    })
  }
}