summaryrefslogtreecommitdiffstats
path: root/server/api/groups.js
blob: 40d25913e6d9a6847b6f8e0618e450e286a9925a (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
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
/* global __appdir */
var path = require('path')
var db = require(path.join(__appdir, 'lib', 'sequelize'))
var groupUtil = require(path.join(__appdir, 'lib', 'grouputil'))
var express = require('express')
const { decorateApp } = require('@awaitjs/express')
var router = decorateApp(express.Router())

// ############################################################################
// ###########################  GET requests  #################################

router.getAsync('', async (req, res) => {
  const groups = await db.group.findAll({ order: [['name', 'ASC']] })
  res.send(groups)
})

router.getAsync('/:id', async (req, res) => {
  const all = req.query.all !== undefined && req.query.all !== 'false'
  if (req.params.id > 0) {
    const group = await db.group.findOne({ where: { id: req.params.id }, include: ['parents', 'subgroups', 'clients'] })
    if (group) {
      if (all) res.status(200).send({ ...group.get({ plain: true }), ...await groupUtil.getAllChildren([group]) })
      else res.status(200).send(group)
    } else {
      res.status(404).end()
    }
  } else {
    const [subgroups, clients] = await Promise.all([
      db.group.findAll(all ? {} : { where: { '$parents.id$': null }, include: ['parents'] }),
      db.client.findAll(all ? {} : { where: { '$groups.id$': null }, include: ['groups'] })
    ])
    res.send({ id: 0, subgroups, clients })
  }
})

// ############################################################################
// ##########################  POST requests  #################################

router.postAsync(['', '/:id'], async (req, res) => {
  if (req.query.delete !== undefined && req.query.delete !== 'false') {
    const count = await db.group.destroy({ where: { id: req.body.ids } })
    res.status(200).send({ count })
  } else {
    let group
    if (req.params.id === undefined) group = await db.group.create(req.body.data)
    else {
      group = await db.group.findOne({ where: { id: req.params.id } })
      if (group) await group.update(req.body.data)
    }
    if (group) {
      await group.setParents(req.body.parentIds)
      res.status(200).send({ id: group.id })
    } else {
      res.status(404).end()
    }
  }
})

router.postAsync('/:id/subgroups', async (req, res) => {
  const group = await db.group.findOne({ where: { id: req.params.id } })
  if (group) {
    if (req.query.delete !== undefined && req.query.delete !== 'false') {
      const count = await group.removeSubgroups(req.body.ids)
      res.status(200).send({ count })
    } else {
      const count = await group.addSubgroups(req.body.ids)
      res.status(200).send({ count })
    }
  } else {
    res.status(404).end()
  }
})

router.postAsync('/:id/clients', async (req, res) => {
  const group = await db.group.findOne({ where: { id: req.params.id } })
  if (group) {
    if (req.query.delete !== undefined && req.query.delete !== 'false') {
      const count = await group.removeClients(req.body.ids)
      res.status(200).send({ count })
    } else {
      const count = await group.addClients(req.body.ids)
      res.status(200).send({ count })
    }
  } else {
    res.status(404).end()
  }
})

// ############################################################################
// ##########################  DELETE requests  ###############################

router.delete('/:id', async (req, res) => {
  const count = await db.group.destroy({ where: { id: req.params.id } })
  if (count) res.status(200).end()
  else res.status(404).end()
})

// ############################################################################
// ############################################################################

module.exports.router = router