Commit Graph

3079 Commits

Author SHA1 Message Date
Sasha Oshurkov 8987bb328e
Full spelling of the word Estimate in Russian locale 2023-03-05 10:46:17 -08:00
Frédéric Guillot 18ed87cbd3 Filtering by category does not show results when the category name is a number
Fixes #4789
2023-03-04 14:50:12 -08:00
sashaoshurkov d3694294a0 Remove semicolon in Russian locale 2023-03-04 14:26:17 -08:00
sashaoshurkov 24f74beabc It is better not to translate the name of the algorithm into Russian (see Wikipedia) 2023-03-04 14:26:17 -08:00
sashaoshurkov 4f64cf8f1d Set correct quotes in Russian locale 2023-03-04 14:26:17 -08:00
Frédéric Guillot b138a99ce3 Better handling of max file upload size according to PHP settings
- Allow unlimited size
- Better parsing of PHP size

Fixes #4896
2023-03-02 20:51:47 -08:00
Tomas Dittmann f945e45ad4
Add dropdown menu on the board to reorder tasks by ID 2023-02-26 16:13:56 -08:00
greyaz 714ea7dfe8
Change the total number of tasks displayed in the table header to match the description
The current value of `$column['column_nb_open_tasks']` represents the number of open tasks in the current column of a swimlane.

But according to the description: "Total number of tasks in this column across all swimlanes", the value of `$column['column_nb_tasks']` should be more appropriate.
2023-02-18 18:54:21 -08:00
peter af8159b4bb Allow full name to be retrieved by SSO ReverseProxy
Expand on #4585 by also getting the user's full name from the Reverse Proxy:
If a ReverseProxy provides more than REMOTE_USER, such as email, it might
as well also provide the user's full name.
2023-02-18 17:28:39 -08:00
Tomas Dittmann bc9535cbdf extract sorting to separate icon 2023-02-16 18:35:31 -08:00
Frédéric Guillot 31408f53aa Add color_id argument to tag API procedures
Fixes #4592
2023-02-14 21:06:50 -08:00
Frédéric Guillot d0941ccd4e Update task time spent/estimated when removing a subtask
Fixes #3811
2023-02-13 20:52:39 -08:00
Frédéric Guillot bd8bcfbc37 Always trim the username before saving changes in the database
Fixes #4742
2023-02-12 19:30:23 -08:00
Frédéric Guillot 5f3225bddc Avoid Postgres SQL error when using project filter with a large integer
Fixes #4845
2023-02-12 18:25:35 -08:00
Frédéric Guillot 5e4d506b28 Enable Sqlite WAL mode by default
WAL provides more concurrency as readers do not block writers and,
a writer does not block readers. Reading and writing can proceed concurrently.

This change might reduce the number of errors related to locked databases.

For reference: https://sqlite.org/wal.html
2023-02-10 20:02:18 -08:00
greyaz 5c25755f9e Update translations.php 2023-01-18 18:35:19 -08:00
Frédéric Guillot bdaa2f585d Sync translations 2023-01-14 11:41:42 -08:00
Chris bb5e45ef69
Fire event after `TaskMoveColumnOnDueDate` action
Fixes #5021
2023-01-12 18:23:53 -08:00
Joe Nahmias 32667285a8 fix: update test for DateTime parse errors to work in php8.2
check if getLastErrors() returns a false bool, rather than specific
array elements, as this throws an error in php8.2 if there are no
errors returned.
2023-01-12 18:13:44 -08:00
Frédéric Guillot 3824e6e9aa Fix potential XSS on the Settings / API page
The CSP policy already prevent the execution of inline Javascript.
2023-01-06 12:25:57 -08:00
Shyam Chaudhary 8902c1448d
Use wildcard operator for tag filter
Fixes #4950
2023-01-06 11:47:31 -08:00
greyaz 372ebcb37e Update translations.php 2023-01-06 06:05:11 -08:00
Pascal Rigaux 3bbf26b169 Fix broken user mentions in popup comment form
This commit partially reverts commit

> commit 61e63ef9e0
> Author: Tomas Dittmann <chaosmeist3r@gmail.com>
> Date:   Sat Feb 5 05:59:33 2022 +0100
>
>   Remove `project_id` from task URLs

where those things should have been kept

(cf FormHelper::textEditor for the need for $values['project_id'])
2023-01-06 06:03:54 -08:00
ScarletBlizzard 7c0a239ec3
Correct and add translation in ru_RU/translations.php (#5106) 2022-12-13 20:55:35 -08:00
greyaz f91cdfe420
Update a wrong translation in zh_CN/translations.php (#5105) 2022-12-13 20:26:04 -08:00
mundry ac94004ea9 feat: add functionality to import tasks from a project 2022-11-15 20:41:16 -08:00
Frédéric Guillot 63f3216447 Update German translation 2022-11-12 17:08:51 -08:00
Frédéric Guillot 2b4e02c974 Fix incorrect placeholder in documentation link 2022-11-12 17:08:02 -08:00
Frédéric Guillot 80c073432f Update links to the new documentation website 2022-11-12 11:49:19 -08:00
Joe Nahmias 33852e9ea0 feature: add Microsoft SQL Server database support
can be used via the pdo_dblib or pdo_odbc extensions.
requires Microsoft SQL Server 2016 or later.

* add schema/migrations
* add database provider
* add setup check for pdo module needed by selected driver (dblib/odbc)
* add default config doc
2022-10-29 21:11:15 -07:00
Joe Nahmias 3df89f9df2 fix(mssql): when updating an object by id, omit the id itself
It is a useless update and id is an identity column in MSSQL,
which is not updatable and throws an error if you try.

This affects the following seven objects (Models):
- Category
- CustomFilter
- Group
- Project
- Subtask
- TaskExternalLink
- User
2022-10-29 18:17:35 -07:00
Joe Nahmias 29df527979 fix(mssql): do not needlessly qualify columns in ProjectRoleRestrictionModel
this allows the ORM to properly escape the rule column
needed on MSSQL as it is a reserved word
2022-10-29 18:17:35 -07:00
Joe Nahmias cf739273d5 fix(mssql): do not needlessly qualify columns in ColumnRestrictionModel
this allows the ORM to properly escape the rule column, as needed on MSSQL
2022-10-29 18:17:35 -07:00
Joe Nahmias 70bc427470 fix(mssql): use picodb ORM for subtask timer query, rather than hardcoded SQL
the hardcoded SQL was failing on MSSQL because 'end' is a reserved keyword
and thus must be escaped
escape identifiers within subtask timer subquery conditions
serialize and interpolate values into text after generation
2022-10-29 18:17:35 -07:00
Joe Nahmias c39932050c fix(mssql): omit ORDER BY in Task WithoutTags & WithGivenTag subqueries
MSSQL does not allow ORDER BY in subquery without TOP or FETCH/LIMIT
2022-10-29 18:17:35 -07:00
Joe Nahmias 81caabbc74 fix: do not hardcode link_id of 'is a milestone of' in TaskFinderModel
instead lookup which link_id was automatically assigned by the databsae
based on the label
2022-10-29 18:17:35 -07:00
Frédéric Guillot 669b5c7e2e Avoid deprecation warning when the task description is null 2022-10-09 15:44:25 -07:00
greyaz 1664f4c304
Update zh_CN translations 2022-10-09 15:17:10 -07:00
Frédéric Guillot 11edef20d2 No internal link creation on subtask to task conversion if language is not English 2022-09-28 20:28:16 -07:00
Marco van Duijvenbode 55a3b242bf
Move version.txt to app folder 2022-09-28 19:42:35 -07:00
greyaz 8443f60748 Update translations.php
some translations of colors are wrong
2022-09-21 17:33:08 -07:00
irdc 4b76bc5b32
Use a HMAC to sign and validate CSRF tokens, instead of generating random ones and storing them in the session data
* Use a HMAC to sign and validate CSRF tokens, instead of generating random
ones and storing them in the session data. Reduces number of writes to
sessions table and fixes kanboard issue #4942.
* Added missing CSRF check for starting/stopping subtask timers.

Co-authored-by: Willemijn Coene <willemijn@irdc.nl>
2022-09-17 17:23:41 -07:00
greyaz edf31ab20b Update TaskAssignDueDateOnMoveColumn.php 2022-09-15 21:08:59 -07:00
greyaz b7761b05e1 More precise zh_CN translations 2022-09-15 20:30:50 -07:00
Frédéric Guillot 29e434b4d6 Update Croatian translations 2022-09-13 20:17:47 -07:00
Rafael de Camargo 3c5cafc8eb Fixes warning when project description is null
Fixes #5059
2022-09-13 19:37:28 -07:00
Frédéric Guillot f3966c99fc Open SVG files in browser 2022-09-04 16:40:05 -07:00
Frédéric Guillot d7a4b59db3 Open videos in browser 2022-09-04 16:12:14 -07:00
Frédéric Guillot 1c8b278116 Open Ogg file attachments in browser 2022-09-04 15:51:27 -07:00
Frédéric Guillot 84c7692710 Update jQuery to latest stable version 2022-09-04 15:08:20 -07:00
Frédéric Guillot b433519686 Rename default branch from master to main 2022-08-11 21:57:19 -07:00
Jack Williams c53bee4a08
Translate subtask status on demand
Fixes #4476
2022-07-11 20:45:06 -07:00
Tomas Dittmann 6308ac41cd add projectoverview document template hook 2022-07-10 17:03:18 -07:00
Eskiso 4112f55219 Added more extensions to FileHelper - Fixes #5024
Added more video, music, code and excel extensions to show a more correct icon on the attachments.
2022-06-27 17:40:29 +02:00
Eskiso aac2f93264 Updated PT translations. 2022-06-27 17:36:56 +02:00
korlikiangel fe42db9ea5
Update pl_PL translations 2022-06-02 15:34:22 +02:00
evrix 1b5bb826b6
Updated Italian translation 2022-05-15 14:24:41 -07:00
greyaz 29786682e1
Update zh_CN translations 2022-03-19 13:24:59 -07:00
emojized 178e2eaf63
Fix `General error: 1 no such table: main.task_has_subtasks`
See: https://kanboard.discourse.group/t/error-no-such-table-main-task-has-subtasks/1664/15

> The `subtask_time_tracking table` has a wrong foreign key constraint. The constraints references the no-longer-existing table `task_has_subtasks`.
2022-03-17 18:10:52 -07:00
Tomas Dittmann c4f9c34f75
Reordering of subtask is not saved 2022-03-17 17:25:46 -07:00
greyaz 05f85a8f59
Update zh_CN / zh_TW translations 2022-03-10 19:33:32 -08:00
Frédéric Guillot 69c51fdf50 Change minimum requirement to PHP 7.4
- PHP versions < 7.4 are EOL: https://www.php.net/supported-versions.php
- Libraries used by Kanboard have dropped support for older versions of PHP
2022-02-18 20:28:23 -08:00
Ole Carlsen 0287140034
Update da_DK translation 2022-02-14 20:44:58 -08:00
Frédéric Guillot 4bf3b0d459 Fix various compatibility issues with PHP 8 2022-02-08 22:20:20 -08:00
Frédéric Guillot f5bb55bdb8
PHP 8 Compatibility 2022-02-05 11:49:03 -08:00
Tomas Dittmann 61e63ef9e0
Remove `project_id` from task URLs 2022-02-04 20:59:33 -08:00
Ole Carlsen 2150ca73b9
Update da_DK translations 2022-02-02 17:12:02 -08:00
colttt a70cf9ab71
Add automatic action to set the due date when the task is moved away from a specific column 2022-01-28 21:22:24 -08:00
Jake G d0347fa30e
Condense wording on inferred action and update translations
These two items on the left menu for tasks are significantly larger than the rest of the items on the list.
By removing the word "another", the left sidebar can be made narrower and it is still clear what these actions do.
2022-01-28 20:47:39 -08:00
dmorlitz 3651c8d0c2
Add EVENT_CREATE and EVENT_CREATE_UPDATE events to TaskMoveColumnCategoryChange action 2022-01-28 20:42:51 -08:00
Tomas Dittmann 3e139ab6f4 Add hook for document-attachments 2021-12-13 19:17:22 -08:00
Jake G e745f8a235
Fix board column header alignment 2021-12-10 16:34:02 -08:00
Tomas Dittmann a40da29a0e don't look for project_id for files
it is only used for late accessibility checking (it was already checked in middleware).

With this, you can create stable file links (as long as the file exists)

I need this change for my [inline image plugin](https://github.com/Chaosmeister/PITM)
2021-12-03 17:28:48 -08:00
András Németh 51db5767ce Update Hungarian translation
It is admittedly more clumsy, but Hungarian does not naturally use passive form, so this may avoid some confusion.
2021-11-09 19:32:10 -08:00
Frédéric Guillot 090a409a56 Fix wrong internal link when converting a subtask to task (MySQL)
Fixes #4409
2021-10-22 15:48:10 -07:00
Tomas Dittmann cc0745542a switch to helper->text
use the available and overridable markdownparser for previews
2021-10-22 14:27:09 -07:00
Tomas Dittmann f8c8d78b53 solve PHP 8 named parameter impact 2021-10-22 14:23:40 -07:00
Erwan Colin 76a81d0675 Enable external group synchronization deactivation. 2021-09-24 13:38:41 -07:00
حمید کرد d5d655c10a Persian translation, correct typo and enhancement 2021-09-10 17:36:03 -07:00
korlikiangel 91d33b8dcb
Update pl_PL translations 2021-08-24 19:59:11 -07:00
Ars Kurd 80c8d87451 Update ru_RU translation 2021-08-02 19:29:06 -07:00
Slavko 4b9cfaa1bb Update Slovak (sk-SK) translation 2021-08-01 21:04:15 -07:00
Johannes Claesson cbfc9edaaf
Update sv_SE translation 2021-07-18 13:43:32 -07:00
José Aponte add701d8d7 Position parameter for Subtask Api proc. update
The objective of this PR is to add support for:

- [ ]  Adding "Position" parameter for Subtask Api Procedure "updateSubtask" method.

Background: I'm working on an Android Client for Kanboard using Flutter Framework. In order to update subtasks positions, I added the "position" parameter and managed the rest of the logic in the App.

Best Regards!
2021-07-17 10:30:47 -07:00
renothing b638604e4c update zh_CN translation 2021-06-13 14:26:08 -07:00
Libin Pan c6ae9f3f24
Duplicate tags when moving and duplicating tasks to another project 2021-06-07 19:36:08 -07:00
Frédéric Guillot cc6f1db846 Avoid user enumeration by using avatar image url 2021-06-05 17:07:43 -07:00
Frédéric Guillot 728ba61450 Invalidate captcha after it is used 2021-06-05 15:30:03 -07:00
Frédéric Guillot 3c85d35485 Avoid user enumeration using password reset functionality 2021-06-05 15:14:11 -07:00
Frédéric Guillot 71123b0f37 Add missing CSRF checks 2021-06-05 14:59:12 -07:00
Jeremy Lance Uy 41102ec161 fix "+" bug in filtering 2021-06-05 13:06:40 -07:00
rivten 4fa9de8390 Add a min="0" attribute to task_list form input 2021-05-11 21:04:06 -07:00
Balázs Úr 280d1e2c6f Update Hungarian translation 2021-05-08 22:02:47 -07:00
Ole Carlsen ac2c4477ed
Update DK_da translation 2021-04-28 20:33:18 -07:00
sfahrenholz 82d1909fce
Update German translation 2021-04-25 15:36:26 -07:00
Martin Krejčí 9ac39b77ee
Fix incorrect cs_CZ translation
The word "me" here is a [dative case!](https://en.wikipedia.org/wiki/Dative_case) but the current translation would be used for genitive or accusative cases, thus it is incorrect and should be changed to "mně".
2021-04-23 20:21:09 -07:00
Manfred Hoffmann 3c6df7a6c6
Keep swimlane headers at the top 2021-04-23 20:18:46 -07:00
Manfred Hoffmann e41254ed74
Use consistent swimlane and column headers
Column headers now always appear above the swimlane header to allow the collapsing to work correctly.

Having the swimlane headers above column headers should be better but the current HTML/CSS implementation is limited.
2021-04-21 20:29:58 -07:00
Manfred Hoffmann ae39544e10
Catch error when trying to upload empty or invalid avatar 2021-04-19 22:42:58 -07:00
Manfred Hoffmann 6f8f5aff33
Added new template hooks 2021-04-19 20:09:26 -07:00