Commit Graph

695 Commits

Author SHA1 Message Date
9cc273d9bd
fix(views): move all tasks to the default bucket when deleting a bucket 2024-03-19 00:47:51 +01:00
0f60a92873
fix(views): make kanban tests work again 2024-03-19 00:47:51 +01:00
24fa3b206f
fix(views): create view 2024-03-19 00:47:50 +01:00
433584813a
fix(views): view deletion 2024-03-19 00:47:50 +01:00
3ec3bb76af
fix(views): make parsing work 2024-03-19 00:47:50 +01:00
004f1e06bb
fix(views): do not return kanban tasks multiple times 2024-03-19 00:47:50 +01:00
27cb6e3372
fix(views): make bucket edit work 2024-03-19 00:47:50 +01:00
445f1c06fa
fix(views): make bucket creation work again 2024-03-19 00:47:50 +01:00
7368a51f18
fix(views): make setting task position in saved filters work 2024-03-19 00:47:49 +01:00
e1774cc49a
feat(views): show tasks on kanban board in saved filter 2024-03-19 00:47:49 +01:00
61e27ae3eb
feat(views): create task bucket relation when creating a new bucket 2024-03-19 00:47:49 +01:00
7f1788eba9
fix(views): get tasks in saved filter 2024-03-19 00:47:49 +01:00
5451ddf58d
fix(views): return tasks directly or in buckets, no matter if accessing via user or link share 2024-03-19 00:47:49 +01:00
f364f3bec8
feat(views): return position when retriving tasks 2024-03-19 00:47:48 +01:00
786e67f692
feat(views): save task position 2024-03-19 00:47:48 +01:00
398c9f1056
fix(views): return tasks in their buckets 2024-03-19 00:47:48 +01:00
cb111df2b7
fix(views): make fetching tasks in kanban buckets through view actually work 2024-03-19 00:47:48 +01:00
73e5483e87
fix(views): do not break filters when combining them with view filters 2024-03-19 00:47:48 +01:00
6913334b17
fix(views): correctly fetch project when fetching tasks 2024-03-19 00:47:48 +01:00
ee6ea03506
feat(views): sort by position 2024-03-19 00:47:47 +01:00
43f24661d7
feat(views): save view and position in Typesense 2024-03-19 00:47:47 +01:00
5641da27f7
feat(views): save position in Typesense 2024-03-19 00:47:47 +01:00
14353b24d7
feat(views): set default position 2024-03-19 00:47:47 +01:00
ca4e3e01c5
feat(views): recalculate all positions when updating 2024-03-19 00:47:47 +01:00
8ce476491e
feat(views): only update the bucket when necessary 2024-03-19 00:47:47 +01:00
f2a0d69670
feat(views)!: make updating a bucket work again 2024-03-19 00:47:47 +01:00
a13276e28e
feat(views)!: decouple bucket <-> task relationship 2024-03-19 00:47:47 +01:00
9cf84646a1
feat(views)!: move done and default bucket setting to view 2024-03-19 00:47:47 +01:00
006f932dc4
feat(views)!: decouple bucket CRUD from projects 2024-03-19 00:47:47 +01:00
0a3f45ab11
feat(views): decouple buckets from projects 2024-03-19 00:47:47 +01:00
d1d07f462c
feat(views): sort tasks by their position relative to the view they're in 2024-03-19 00:47:46 +01:00
2502776460
feat(views)!: move task position handling to its own crud entity
BREAKING CHANGE: the position of tasks now can't be updated anymore via the task update endpoint. Instead, there is a new endpoint which takes the project view into account as well.
2024-03-19 00:47:46 +01:00
238baf86f7
feat(views)!: return tasks in buckets by view
BREAKING CHANGE: tasks in their bucket are now only retrievable via their view. The /project/:id/buckets endpoint now only returns the buckets for that project, which is more in line with the other endpoints
2024-03-19 00:47:46 +01:00
652bf4b4ed
feat(views): (un)marshal custom project view mode types 2024-03-19 00:47:46 +01:00
a9020e976d
feat(views): add bucket configuration mode 2024-03-19 00:47:46 +01:00
38457aaca5
feat(views): use project id when fetching views 2024-03-19 00:47:46 +01:00
98b7cc9254
feat(views): do not override filters in view 2024-03-19 00:47:46 +01:00
4149ebed3a
feat(views): create default views when creating a filter 2024-03-19 00:47:46 +01:00
2096fc5274
feat(views): return tasks in a view 2024-03-19 00:47:46 +01:00
e4b1a5d2db
feat(views): create default 4 default view for projects 2024-03-19 00:47:46 +01:00
2fa3e2c2f5
feat(views): return views with their projects 2024-03-19 00:47:46 +01:00
b39c5580c2
feat(views): add crud handlers and routes for views 2024-03-19 00:47:45 +01:00
6bdb33fb46
feat(views): add new model and migration 2024-03-19 00:47:45 +01:00
8c826c44d2
fix(webhooks): fire webhooks set on parent projects as well 2024-03-13 19:41:34 +01:00
5b2b7f7bdc
fix(kanban): reset done and default bucket when the bucket itself is deleted
Resolves https://github.com/go-vikunja/vikunja/issues/234
2024-03-12 22:23:35 +01:00
a5c51d4b1e feat: emoji reactions for tasks and comments (#2196)
This PR adds reactions for tasks and comments, similar to what you can do on Gitea, GitHub, Slack and plenty of other tools.

Reviewed-on: vikunja/vikunja#2196
Co-authored-by: kolaente <k@knt.li>
Co-committed-by: kolaente <k@knt.li>
2024-03-12 19:25:58 +00:00
09d5128050
fix(filters): don't escape valid escaped in queries 2024-03-11 17:02:04 +01:00
a66e26678e
feat(filters): pass timezone down when filtering with relative date math
Resolves https://community.vikunja.io/t/my-vikunja-instance-creates-tasks-with-due-date-time-of-9am-for-tasks-with-the-word-today-word-in-it/2105/8
2024-03-11 16:28:25 +01:00
6fc3d1e98f
fix: lint 2024-03-11 15:42:09 +01:00
3896c680d3
fix(filters): do not require string for in comparator 2024-03-11 14:36:59 +01:00
6c98052176 fix(teams): fix duplicate teams being shown when new public team visibility feature is enabled (#2187)
Due to the `INNER JOIN` on the `team_members` table and the new `OR` conditions allowing teams with the `isPublic` flag set to `true`, teams are returned multiple times. As we're only after the teams, a simple distinct query should fix the issue.

Co-authored-by: Daniel Herrmann <daniel.herrmann1@gmail.com>
Reviewed-on: vikunja/vikunja#2187
Co-authored-by: waza-ari <daniel.herrmann@makerspace-darmstadt.de>
Co-committed-by: waza-ari <daniel.herrmann@makerspace-darmstadt.de>
2024-03-10 21:42:34 +00:00
ffa82556e0 feat(teams): add public flags to teams to allow easier sharing with other teams (#2179)
Resolves #2173
Co-authored-by: Daniel Herrmann <daniel.herrmann1@gmail.com>
Reviewed-on: vikunja/vikunja#2179
Reviewed-by: konrad <k@knt.li>
Co-authored-by: waza-ari <daniel.herrmann@makerspace-darmstadt.de>
Co-committed-by: waza-ari <daniel.herrmann@makerspace-darmstadt.de>
2024-03-10 14:04:32 +00:00
d7fdefcead chore(deps): update golangci/golangci-lint docker tag to v1.56.2 (#2099)
Co-authored-by: kolaente <k@knt.li>
Reviewed-on: vikunja/vikunja#2099
Co-authored-by: renovate <renovatebot@kolaente.de>
Co-committed-by: renovate <renovatebot@kolaente.de>
2024-03-10 13:47:19 +00:00
654e95d99f
fix(filters): test fixture 2024-03-09 20:21:05 +01:00
4e6e0608c7
fix(filters): lint 2024-03-09 20:08:17 +01:00
05d3bb4fb6
fix(filters): swagger docs for kanban buckets 2024-03-09 19:07:31 +01:00
d0b762d761
docs(filter): add filter query explanation 2024-03-09 19:07:31 +01:00
28fa2c517a
feat(filters): make new filter syntax work with Typesense 2024-03-09 19:06:48 +01:00
bc6d812eb0
fix(filters): lint 2024-03-09 19:06:35 +01:00
87c027aafd
chore(filters): cleanup old variables 2024-03-09 19:06:35 +01:00
65e1357705
fix(tests): make filter tests work again 2024-03-09 19:06:35 +01:00
eebfee73d3
fix(filter): correctly filter for buckets 2024-03-09 19:06:35 +01:00
ef1cc9720c
feat(filter): add in keyword 2024-03-09 19:06:35 +01:00
c6b682507a
feat(filter): add better error message when passing an invalid filter expression 2024-03-09 19:06:35 +01:00
9d3fb6f81d
chore(filter): cleanup 2024-03-09 19:06:35 +01:00
76ed2cff5f
feat(filter): nesting 2024-03-09 19:06:35 +01:00
e43349618b
feat(filter): more tests 2024-03-09 19:06:35 +01:00
9624cc9e97
fix(filter): translate all tests 2024-03-09 19:06:35 +01:00
764bc15d49
fix(filter): allow filtering for "project" 2024-03-09 19:06:34 +01:00
3fc4aaa2a1
fix(filter): allow filtering on "in" condition 2024-03-09 19:06:34 +01:00
9f73e2c5f9
fix(filter): don't crash on empty filter 2024-03-09 19:06:34 +01:00
c1e137d8ee
fix(filter): make sure single filter condition works 2024-03-09 19:06:34 +01:00
de320aac72
feat(filters): basic text filter works now 2024-03-09 19:06:34 +01:00
307ffe11c4
feat(filters): very basic filter parsing 2024-03-09 19:06:31 +01:00
d69fc28125 fix(openid): OIDC teams should not have admins (#2161)
This PR fixes an issue discussed in #2152. Before this PR, the user who triggered team creation automatically got the admin flag set for this group, which makes perfect sense for the normal UI workflow. OIDC managed teams cannot be edited in Vikunja, and they're created automatically by the first user logging in having this team assigned. This PR therefore makes sure that OIDC managed team members do not receive the admin flag.

Co-authored-by: Daniel Herrmann <daniel.herrmann1@gmail.com>
Reviewed-on: vikunja/vikunja#2161
Reviewed-by: konrad <k@knt.li>
Co-authored-by: waza-ari <daniel.herrmann@makerspace-darmstadt.de>
Co-committed-by: waza-ari <daniel.herrmann@makerspace-darmstadt.de>
2024-03-05 22:08:39 +00:00
a3154e805c fix(auth): use (issuer, name) to check for uniqueness of oidc teams (#2152)
The change introduced in #2150 introduces a bug where a Team would be re-created every time a user logs in, as the check if a team already exists was based on both the unique `oidcID` and the `name`. This PR proposes to only base the check on the ID, as this should be unique.

Co-authored-by: Daniel Herrmann <daniel.herrmann1@gmail.com>
Reviewed-on: vikunja/vikunja#2152
Reviewed-by: konrad <k@knt.li>
Co-authored-by: waza-ari <daniel.herrmann@makerspace-darmstadt.de>
Co-committed-by: waza-ari <daniel.herrmann@makerspace-darmstadt.de>
2024-03-04 20:26:45 +00:00
ac8751e1be
fix(task): move done tasks to the done bucket when they are moved between projects and the new project has a done bucket 2024-03-03 18:13:47 +01:00
fe27dd59ad
feat(subscription): use a recursive cte to fetch subscriptions of parent projects
Testing this locally resulted in improved response times from ~50ms to ~20ms when creating a project. It looks like even though the code running these sql queries uses different go routines, they affect each other (caused by IO or context switching?)
2024-03-03 15:34:18 +01:00
22933dac4a
fix(project): typo in table name 2024-03-03 12:47:00 +01:00
fe02f4da2c
fix(project): check for project nesting cycles with a single recursive cte instead of a loop 2024-03-03 11:40:43 +01:00
4f1f96f1e9
chore(auth): refactor openid team creation 2024-03-02 15:22:37 +01:00
10ff864e0c
fix(projects): load projects only one when fetching subscriptions for a bunch of projects at once
This change ensures already loaded projects are passed down when fetching their subscription  instead of re-loading each project with a single sql statement. When loading all projects, this meant all projects were loaded twice, which was highly inefficient. This roughly added 25ms to each request, assuming the per page limit was maxed out at 50 projects.

Empirical testing shows this change reduces load times by ~20ms. Because the request is already pretty fast, this is ~30% of the overall request time, making the loading of projects now even faster
2024-03-02 14:27:11 +01:00
a3932a0a19
fix(projects): return correct project pagination count 2024-03-02 13:30:34 +01:00
ed4da96ab1 feat: assign users to teams via OIDC claims (#1393)
This change adds the ability to sync teams via a custom openid claim. Vikunja will automatically create and delete teams as necessary, it will also add and remove users when they log in. These teams are fully managed by Vikunja and cannot be updated by a user.

Co-authored-by: kolaente <k@knt.li>
Reviewed-on: vikunja/vikunja#1393
Resolves vikunja/vikunja#1279
Resolves https://github.com/go-vikunja/vikunja/issues/42
Resolves vikunja/vikunja#950
Co-authored-by: viehlieb <pf@pragma-shift.net>
Co-committed-by: viehlieb <pf@pragma-shift.net>
2024-03-02 08:47:10 +00:00
5b70609ba7
fix: usage of limit and order by usage in recursive cte 2024-02-28 14:35:09 +01:00
6b1e67485b
feat: fetch all projects with a recursive cte instead of recursive query
This change modifies the fetching of all projects to use a recursive common table expression instead of recursively calling the method.
2024-02-28 13:42:45 +01:00
415c6380a5
feat(api tokens): add task attachment to api scopes
This explicitly adds download and upload of task attachments. Because these are not handled with the usual CRUDables, they were not picked up automatically.

Resolves https://github.com/go-vikunja/vikunja/issues/112
2024-02-14 15:00:16 +01:00
8752ae2a0b
fix(webhook): fetch all event details before sending the webhook
Resolves https://community.vikunja.io/t/webhook-comment-data-issues/1952
2024-02-10 14:15:32 +01:00
7edb53ca12
fix(export): don't crash when an exported file does not exist
Related to https://github.com/go-vikunja/vikunja/issues/110
2024-02-10 13:45:12 +01:00
5ab9fb89bb
fix(tasks): check for cycles during creation of task relations and prevent them 2024-02-10 13:30:41 +01:00
119c68be9d
feat: rename frontend url config to public url 2024-02-09 14:41:55 +01:00
b95b92a23a
fix(filters): add explicit check for string slice filter
Resolves https://github.com/go-vikunja/api/issues/109
2024-02-05 22:08:17 +01:00
8efdc96d02
chore(filters): log type if unknown filter type 2024-02-01 16:19:22 +01:00
7f46914d5e
fix(project): pass user id to error message 2024-01-31 13:50:21 +01:00
96b4f2d1db
fix(projects): don't remove parent project id if the parent project is available in the same run
Resolves https://github.com/go-vikunja/frontend/issues/139
2024-01-28 15:28:08 +01:00
d9875e476c
fix(assignees): make sure task assignee created event contains the full task 2024-01-28 13:23:27 +01:00
e4fec01d52
fix(assignees): subscribe assigned users directly to the task, not async
Resolves https://community.vikunja.io/t/richer-email-notifications/1891
2024-01-28 13:15:43 +01:00
b2970c6c04
fix(assignees): prevent double notifications for assignees 2024-01-28 13:11:50 +01:00
e03920b84a
fix(assignees): improve wording for assignee emails 2024-01-28 13:11:37 +01:00
a20f6ac815
fix(task): delete the task after all related attributes to prevent task not found errors 2024-01-28 12:23:25 +01:00