Jan Böhmer
e223078af9
Added a custom function to make PostgresSQL searches case insensitive
...
This is required only for postgres as every other database is case invariant by default. But to achieve a portable way, we implement it via a custom DQL function.
This fixes issue #784
2024-12-02 00:17:54 +01:00
Jan Böhmer
235d572f8c
Use DatetimeImmutable instead of DateTime wherever possible
2024-06-22 17:36:54 +02:00
Jan Böhmer
8c45a40f9e
Explicitly configure some deprecated configuration options
2024-06-19 23:47:38 +02:00
Jan Böhmer
0a482da93e
Use postgres native array_position function instead of our FIELD function and pass it as array literal instead of variadic function
...
Otherwise we will run into errors, that we can not give more than 100 arguments to a function
2024-06-17 23:13:04 +02:00
Jan Böhmer
9db822eabd
Use natural sorting for string datatables columns when using postgres
...
The natural sorting solution is quite portable, so this should be possible for other database types too later
2024-06-17 21:38:16 +02:00
Jan Böhmer
6e9b337b49
Fixed regex function for postgres
2024-06-13 23:18:25 +02:00
Jan Böhmer
c58ff5861d
Replaced the non standard IFNULL function which postgres does not know with the COALSCE function
2024-06-13 23:01:53 +02:00
Jan Böhmer
971bb92a8c
Fixed error caused by ArrayType fields which is required by the webauthn bundle but was removed in doctrine/orm 4.0
...
We simple forward port the ArrayType class from orm 3.8 to fix this error
2024-06-10 21:11:11 +02:00
Jan Böhmer
1911c62edd
Upgraded DAMA doctrine test bundle
2023-12-03 23:58:19 +01:00
Jan Böhmer
abc554c7b8
Updated doctrine recipe
2023-12-03 22:44:55 +01:00
Jan Böhmer
62b1e33616
Fixed field ordering on SQLite
2023-07-29 16:42:27 +02:00
Jan Böhmer
d3ead8742e
Implement a special field2 function, to migitiate the argument count limit in sqlite
...
This fixes issue #332 on SQLite DBs
2023-07-26 23:23:25 +02:00
Jan Böhmer
a4d411656b
Added a field extension for SQLite and let the database sort the elements by the given ID order directly
2023-07-23 01:19:48 +02:00
Jan Böhmer
affed459df
Updated recipe of doctrine/doctrine-bundle
2023-06-11 13:49:21 +02:00
Jan Böhmer
7191ece7a5
Configure doctrine to use attributes instead of annotations
2023-05-28 01:55:30 +02:00
Jan Böhmer
1a3f0675bf
Updated doctrine bundle recipe
2023-05-27 20:51:05 +02:00
Jan Böhmer
342ed382e3
Properly mark the tinyint column with a comment, so that migrations can properly detect that no changes are needed
2023-04-09 00:04:13 +02:00
Jan Böhmer
c75cdecbe8
Upgraded doctrine-bundle recipe
2023-02-11 22:27:51 +01:00
Jan Böhmer
f62937096f
Moved doctrine custom type definitions to Doctrine\Types namespace
2022-12-31 18:42:56 +01:00
Jan Böhmer
f8aee65d9e
Simplified the available permissions
2022-10-31 21:13:27 +01:00
Jan Böhmer
687ee80255
Save permissions as JSON in user/group entities.
2022-10-30 21:51:24 +01:00
Jan Böhmer
8f94a58c71
Allow to order and filter by the amount sum of parts.
2022-09-04 03:37:54 +02:00
Jan Böhmer
f3680ea7de
Parse markdown using stimulus controller.
2022-03-06 14:54:08 +01:00
Jan Böhmer
08267b88b0
Use BigDecimal object type for Supplier shipping costs, instead of bcmath string.
2020-05-18 22:07:09 +02:00
Jan Böhmer
86ee10e582
Search options now working. Added Regex search.
2020-03-08 13:05:53 +01:00
Jan Böhmer
d5f018a738
Added an database migration to improve the log schema.
2020-01-26 20:27:37 +01:00
Jan Böhmer
64cf8097bc
Updated doctrine recipes.
2020-01-07 18:48:34 +01:00
Jan Böhmer
311a342634
Fixed deprecation caused by datatype declaration.
2020-01-01 18:19:40 +01:00
Jan Böhmer
9c22149afd
Let doctrine detect its driver and db_version automatically.
2019-11-23 18:01:45 +01:00
Jan Böhmer
1ae905ae78
Use number aware naming strategy for doctrine.
...
Fixes a deprecation notice.
2019-11-23 17:48:24 +01:00
Jan Böhmer
01da705b54
Collect backtrace for each doctrine query.
2019-09-18 17:53:48 +02:00
Jan Böhmer
c94d3cdc68
Explicitly set that our utc datetypes does not need an comment
...
This fixes an deprecation warning.
2019-09-17 14:02:30 +02:00
Jan Böhmer
d2bae3a4f2
Use the users timezone for showing dates from the database.
...
In the database the values are now saved in UTC.
2019-09-12 22:16:33 +02:00
Jan Böhmer
0ec73618ac
Set the correct database version, otherwise we get messy migrations.
2019-09-02 14:21:40 +02:00
Jan Böhmer
2f39ac90a2
Added migration from old Database to new database.
2019-08-06 13:18:29 +02:00
Jan Böhmer
42c8222e35
Protect internal table against the doctrine migration system.
2019-08-03 13:25:49 +02:00
Jan Böhmer
cd4a1470e3
Protect internal table against the doctrine migration system
2019-08-02 16:19:15 +02:00
Jan Böhmer
e5bec36c80
Initial commit
2019-02-23 16:49:38 +01:00