Newer
Older
import express from 'express';
import { v4 as uuid, validate } from 'uuid';
import database from '../database';
import { requireVerification, Token } from './auth';
import { isOfType } from '../util';
const team = express();
team.use(requireVerification);
interface CreateTeamBody {
name: string;
token: Token;
}
team.post('/', async (req, res) => {
if (isOfType<CreateTeamBody>(req.body, [['name', 'string']])) {
const team_id = uuid();
const role_id = uuid();
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
const team_name = req.body.name;
try {
await database.transaction(async transaction => {
await transaction('teams').insert({
id: team_id,
name: team_name,
});
await transaction('roles').insert({
id: role_id,
team_id: team_id,
name: 'Default',
});
await transaction('team_members').insert({
user_id: req.body.token.id,
team_id: team_id,
role_id: role_id,
});
});
res.status(200).json({
status: 'success',
id: team_id,
});
} catch (e) {
res.status(400).json({
status: 'error',
message: 'failed create team',
});
}
} else {
res.status(400).json({
status: 'error',
message: 'missing request fields',
});
}
});
interface UpdateTeamBody {
name: string;
token: Token;
}
team.put('/:uuid', async (req, res) => {
if (isOfType<UpdateTeamBody>(req.body, [['name', 'string']])) {
const team_id = req.params.uuid;
if (validate(team_id)) {
const team_name = req.body.name;
const team = await database('teams')
.leftJoin('team_members', 'teams.id', 'team_members.team_id')
.select({ id: 'teams.id' })
.where({
'team_members.user_id': req.body.token.id,
'teams.id': team_id,
if (team.length >= 1) {
await database('teams')
.update({
name: team_name,
})
.where({
'teams.id': team_id,
})
res.status(200).json({
status: 'success',
} else {
res.status(404).json({
status: 'error',
message: 'team not found',
} catch (e) {
res.status(400).json({
status: 'error',
message: 'failed update team',
});
}
} else {
res.status(400).json({
status: 'error',
message: 'malformed uuid',
});
}
} else {
res.status(400).json({
status: 'error',
message: 'missing request fields',
});
}
});
team.get('/', async (req, res) => {
try {
const teams = await database('team_members')
.innerJoin('teams', 'team_members.team_id', 'teams.id')
.select({
id: 'teams.id',
name: 'teams.name',
role: 'team_members.role_id'
})
.where({
'team_members.user_id': req.body.token.id
});
res.status(200).json({
status: 'success',
teams: teams,
});
} catch (e) {
res.status(400).json({
status: 'error',
message: 'failed to get teams',
});
}
});
team.get('/:uuid/', async (req, res) => {
try {
const id = req.params.uuid;
if (validate(id)) {
const teams = await database('teams')
.leftJoin('team_members', 'teams.id', 'team_members.team_id')
.select({
id: 'teams.id',
name: 'teams.name',
role: 'team_members.role_id',
user: 'team_members.user_id',
})
.where({
'teams.id': id,
if (teams.length >= 1) {
const team = teams.find(team => team.user === req.body.token.id) ?? { ...teams[0], role: null };
delete team.user;
res.status(200).json({
status: 'success',
});
} else {
res.status(404).json({
status: 'error',
message: 'team not found',
});
}
} else {
res.status(400).json({
status: 'error',
message: 'malformed uuid',
});
}
} catch (e) {
res.status(400).json({
status: 'error',
message: 'failed get team',
});
}
});
team.get('/:uuid/members', async (req, res) => {
try {
const id = req.params.uuid;
if (validate(id)) {
const members = await database({ ut: 'team_members'})
.innerJoin({ tm: 'team_members'}, 'ut.team_id', 'tm.team_id')
.innerJoin({ members: 'users'}, 'tm.user_id', 'members.id')
.innerJoin('roles', 'tm.role_id', 'roles.id')
.select({
id: 'members.id',
name: 'members.user_name',
email: 'members.email',
realname: 'members.real_name',
role_id: 'roles.id',
role_name: 'roles.name',
'ut.user_id': req.body.token.id,
'ut.team_id': id,
});
if (members.length >= 1) {
res.status(200).json({
status: 'success',
members: members.map(member => ({
id: member.id,
username: member.name,
email: member.email,
realname: member.realname,
role: {
id: member.role_id,
name: member.role_name,
},
})),
// All teams have members
res.status(404).json({
status: 'error',
message: 'team not found',
});
}
} else {
res.status(400).json({
status: 'error',
message: 'malformed uuid',
});
}
} catch (e) {
res.status(400).json({
status: 'error',
message: 'failed get members',
});
}
});
team.get('/:uuid/roles', async (req, res) => {
try {
const id = req.params.uuid;
if (validate(id)) {
const roles = await database('team_members')
.innerJoin('roles', 'team_members.team_id', 'roles.team_id')
.select({
id: 'roles.id',
name: 'roles.name',
})
.where({
'team_members.user_id': req.body.token.id,
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
'team_members.team_id': id,
});
if (roles.length >= 1) {
res.status(200).json({
status: 'success',
roles: roles,
});
} else {
// All teams have at least one role
res.status(404).json({
status: 'error',
message: 'team not found',
});
}
} else {
res.status(400).json({
status: 'error',
message: 'malformed uuid',
});
}
} catch (e) {
res.status(400).json({
status: 'error',
message: 'failed get roles',
});
}
});
team.get('/:uuid/projects', async (req, res) => {
try {
const id = req.params.uuid;
if (validate(id)) {
const projects = await database('team_members')
.innerJoin('team_projects', 'team_members.team_id', 'team_projects.team_id')
.innerJoin('projects', 'team_projects.project_id', 'projects.id')
.select({
id: 'projects.id',
name: 'projects.name',
text: 'projects.text',
color: 'projects.color',
status: 'projects.status',
deadline: 'projects.deadline',
})
.where({
'team_members.user_id': req.body.token.id,
'team_members.team_id': id,
});
res.status(200).json({
status: 'success',
projects: projects.map(project => ({
...project,
deadline: project.deadline && (new Date(project.deadline)).toISOString().substr(0, 10),
})),
});
} else {
res.status(400).json({
status: 'error',
message: 'malformed uuid',
});
}
} catch (e) {
res.status(400).json({
status: 'error',
message: 'failed get projects',
});
}
});
team.get('/:uuid/work', async (req, res) => {
try {
const id = req.params.uuid;
if (validate(id)) {
const since = new Date(parseInt(req.query.since as string ?? 0));
const to = new Date(parseInt(req.query.to as string ?? Date.now()));
const work = await database({ ut: 'team_members' })
.innerJoin('team_members', 'ut.team_id', 'team_members.team_id')
.innerJoin('workhours', 'team_members.user_id', 'workhours.user_id')
.select({
id: 'workhours.id',
task: 'workhours.task_id',
user: 'workhours.user_id',
started: 'workhours.started',
finished: 'workhours.finished',
})
.where({
'ut.user_id': req.body.token.id,
'ut.team_id': id,
})
.andWhere('workhours.started', '>=', since.getTime())
.andWhere('workhours.started', '<=', to.getTime())
.groupBy('workhours.id');
res.status(200).json({
status: 'success',
work: work,
});
} else {
res.status(400).json({
status: 'error',
message: 'malformed uuid',
});
}
} catch (e) {
res.status(400).json({
status: 'error',
message: 'failed get work',
});
}
});
team.get('/:uuid/activity', async (req, res) => {
try {
const id = req.params.uuid;
if (validate(id)) {
const since = new Date(parseInt(req.query.since as string ?? 0));
const to = new Date(parseInt(req.query.to as string ?? Date.now()));
const activity = await database({ ut: 'team_members' })
.innerJoin('team_members', 'ut.team_id', 'team_members.team_id')
.innerJoin('workhours', 'team_members.user_id', 'workhours.user_id')
.select({
day: database.raw('(workhours.started / 1000 / 60 / 60 / 24)'),
.sum({ time: database.raw('(workhours.finished - workhours.started)') })
.where({
'ut.user_id': req.body.token.id,
'ut.team_id': id,
})
.andWhereNot({ 'workhours.finished': null })
.andWhere('workhours.started', '>=', since.getTime())
.andWhere('workhours.started', '<=', to.getTime())
.groupBy('day');
res.status(200).json({
status: 'success',
activity: activity.map((act: any) => ({
...act,
day: (new Date(act.day * 24 * 60 * 60 * 1000)).toISOString().substring(0, 10),
})),
});
} else {
res.status(400).json({
status: 'error',
message: 'malformed uuid',
});
}
} catch (e) {
res.status(400).json({
status: 'error',
message: 'failed get activity',
});
}
});
team.get('/:uuid/completion', async (req, res) => {
try {
const id = req.params.uuid;
if (validate(id)) {
const since = new Date(parseInt(req.query.since as string ?? 0));
const to = new Date(parseInt(req.query.to as string ?? Date.now()));
const completion: any[] = await database(
database('team_members')
.innerJoin('team_projects', 'team_members.team_id', 'team_projects.team_id')
.innerJoin('tasks', 'team_projects.project_id', 'tasks.project_id')
.select({
id: 'tasks.id',
status: database.raw(
`Case When tasks.status = 'open'
And (Select
Sum(task_requirements.time * 60 * 1000)
from task_requirements where task_requirements.task_id = tasks.id)
< (Select
Sum(workhours.finished - workhours.started)
from workhours where workhours.task_id = tasks.id)
Then 'overdue' Else tasks.status End`),
})
.where({
'team_members.user_id': req.body.token.id,
'team_members.team_id': id,
})
.andWhere('tasks.edited', '>=', since.getTime())
.andWhere('tasks.created', '<=', to.getTime())
.groupBy('tasks.id')
.as('task_status')
)
.select({
status: 'task_status.status',
.count({ count: 'task_status.id' })
.groupBy('task_status.status');
res.status(200).json({
status: 'success',
completion: completion.reduce((object, { status, count }) => ({
...object,
[status]: count,
}), { open: 0, closed: 0, suspended: 0, overdue: 0 }),
});
} else {
res.status(400).json({
status: 'error',
message: 'malformed uuid',
});
}
} catch (e) {
res.status(400).json({
status: 'error',
message: 'failed get completion',
});
interface AddRoleBody {
name: string;
token: Token;
}
team.post('/:uuid/roles', async (req, res) => {
if (isOfType<AddRoleBody>(req.body, [['name', 'string']])) {
try {
const team_id = req.params.uuid;
if (validate(team_id)) {
const team = await database('team_members')
.select({ id: 'team_members.team_id' })
.where({
'team_members.user_id': req.body.token.id,
'team_members.team_id': team_id,
});
if (team.length >= 1) {
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
const role_id = uuid();
const role_name = req.body.name;
await database('roles').insert({
id: role_id,
name: role_name,
team_id: team_id,
});
res.status(200).json({
status: 'success',
role: {
id: role_id,
name: role_name,
},
});
} else {
res.status(404).json({
status: 'error',
message: 'team not found',
});
}
} else {
res.status(400).json({
status: 'error',
message: 'malformed uuid',
});
}
} catch (e) {
res.status(400).json({
status: 'error',
message: 'failed to add role',
});
}
} else {
res.status(400).json({
status: 'error',
message: 'missing request fields',
});
}
});
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
interface UpdateRoleBody {
name: string;
token: Token;
}
team.put('/:teamid/roles/:roleid', async (req, res) => {
if (isOfType<UpdateRoleBody>(req.body, [['name', 'string']])) {
try {
const team_id = req.params.teamid;
const role_id = req.params.roleid;
if (validate(team_id) && validate(role_id)) {
const team = await database('team_members')
.select({ id: 'team_members.team_id' })
.where({
'team_members.user_id': req.body.token.id,
'team_members.team_id': team_id,
});
if (team.length >= 1) {
const role_name = req.body.name;
const updated = await database('roles')
.update({
name: role_name,
})
.where({
id: role_id,
team_id: team_id,
});
if (updated >= 1) {
res.status(200).json({
status: 'success',
});
} else {
res.status(404).json({
status: 'error',
message: 'role not found',
});
}
} else {
res.status(404).json({
status: 'error',
message: 'team not found',
});
}
} else {
res.status(400).json({
status: 'error',
message: 'malformed uuid',
});
}
} catch (e) {
res.status(400).json({
status: 'error',
message: 'failed to update role',
});
}
} else {
res.status(400).json({
status: 'error',
message: 'missing request fields',
});
}
});
team.delete('/:teamid/roles/:roleid', async (req, res) => {
try {
const team_id = req.params.teamid;
const role_id = req.params.roleid;
if (validate(team_id) && validate(role_id)) {
const members = await database({ ut: 'team_members' })
.innerJoin('team_members', 'ut.team_id', 'team_members.team_id')
.select({ role: 'team_members.role_id' })
.where({
'ut.user_id': req.body.token.id,
'ut.team_id': team_id,
if (members.find(member => member.role == role_id)) {
res.status(400).json({
status: 'error',
message: 'role is in use',
});
} else if (members.length >= 1) {
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
const deleted = await database('roles')
.delete()
.where({
id: role_id,
team_id: team_id,
});
if (deleted >= 1) {
res.status(200).json({
status: 'success',
});
} else {
res.status(404).json({
status: 'error',
message: 'role not found',
});
}
} else {
res.status(404).json({
status: 'error',
message: 'team not found',
});
}
} else {
res.status(400).json({
status: 'error',
message: 'malformed uuid',
});
}
} catch (e) {
res.status(400).json({
status: 'error',
});
}
});
interface AddMemberBody {
user: string;
role: string;
token: Token;
}
team.post('/:uuid/members', async (req, res) => {
if (isOfType<AddMemberBody>(req.body, [['user', 'string'], ['role', 'string']])) {
try {
const team_id = req.params.uuid;
const user_id = req.body.user;
const role_id = req.body.role;
if (validate(team_id) && validate(user_id) && validate(role_id)) {
const role = await database('team_members')
.innerJoin('roles', 'team_members.team_id', 'roles.team_id')
.select({ id: 'roles.id' })
.where({
'team_members.user_id': req.body.token.id,
'team_members.team_id': team_id,
'roles.id': role_id,
});
if (role.length >= 1) {
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
await database('team_members').insert({
user_id: user_id,
team_id: team_id,
role_id: role_id,
});
res.status(200).json({
status: 'success',
});
} else {
res.status(404).json({
status: 'error',
message: 'role not found',
});
}
} else {
res.status(400).json({
status: 'error',
message: 'malformed uuid',
});
}
} catch (e) {
res.status(400).json({
status: 'error',
message: 'failed to add member',
});
}
} else {
res.status(400).json({
status: 'error',
message: 'missing request fields',
});
}
});
interface UpdateMemberBody {
user: string;
role: string;
token: Token;
}
team.put('/:uuid/members', async (req, res) => {
if (isOfType<UpdateMemberBody>(req.body, [['user', 'string'], ['role', 'string']])) {
try {
const team_id = req.params.uuid;
const user_id = req.body.user;
const role_id = req.body.role;
if (validate(team_id) && validate(user_id) && validate(role_id)) {
const role = await database('team_members')
.innerJoin('roles', 'team_members.team_id', 'roles.team_id')
.select({ id: 'roles.id' })
.where({
'team_members.user_id': req.body.token.id,
'team_members.team_id': team_id,
'roles.id': role_id,
});
if (role.length >= 1) {
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
await database('team_members')
.update({ role_id: role_id })
.where({
user_id: user_id,
team_id: team_id,
});
res.status(200).json({
status: 'success',
});
} else {
res.status(404).json({
status: 'error',
message: 'role not found',
});
}
} else {
res.status(400).json({
status: 'error',
message: 'malformed uuid',
});
}
} catch (e) {
res.status(400).json({
status: 'error',
message: 'failed to update member',
});
}
} else {
res.status(400).json({
status: 'error',
message: 'missing request fields',
});
}
});
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
team.delete('/:teamid/members/:userid', async (req, res) => {
try {
const team_id = req.params.teamid;
const user_id = req.params.userid;
if (validate(team_id) && validate(user_id)) {
const team = await database('team_members')
.select({ id: 'team_members.team_id' })
.where({
'team_members.user_id': req.body.token.id,
'team_members.team_id': team_id,
});
if (team.length >= 1) {
const deleted = await database('team_members')
.delete()
.where({
'team_members.user_id': user_id,
'team_members.team_id': team_id,
});
if (deleted >= 1) {
res.status(200).json({
status: 'success',
});
} else {
res.status(404).json({
status: 'error',
message: 'role not found',
});
}
} else {
res.status(404).json({
status: 'error',
message: 'team not found',
});
}
} else {
res.status(400).json({
status: 'error',
message: 'malformed uuid',
});
}
} catch (e) {
res.status(400).json({
status: 'error',
message: 'failed remove members',
});
}
});
team.delete('/:uuid/', async (req, res) => {
try {
const id = req.params.uuid;
if (validate(id)) {
const deleted = await database('team_members')
.delete()
.where({
'team_members.user_id': req.body.token.id,
'team_members.team_id': id,
});
if (deleted >= 1) {
res.status(200).json({
status: 'success',
});
} else {
res.status(404).json({
status: 'error',
message: 'team not found',
});
}
} else {
res.status(400).json({
status: 'error',
message: 'malformed uuid',
});
}
} catch (e) {
res.status(400).json({
status: 'error',
message: 'failed leave team',
export default team;