El_Coloso
f280fc79f6
Upgrade github workflow ( #3708 )
2025-07-11 08:12:34 +02:00
jekkos
5f395d987b
Set release version to 3.4.1
3.4.1
2025-06-05 21:28:32 +02:00
objecttothis
6f587498e6
Migration fix for MariaDB databases
...
- This fix properly creates Primary Keys on both MariaDB and MySQL
Signed-off-by: objecttothis <objecttothis@gmail.com >
2025-06-01 10:15:57 +02:00
jekkos
29c3c55fcc
Fix item number lookup in sales/receivings ( #4212 ) ( #4250 )
...
* Fix item number lookup in sales/receivings (#4212 )
* Remove item_number check in exists()
2025-05-30 22:29:35 +02:00
objecttothis
e1fedab9b7
Bugfix: constraint migration fixes ( #4230 )
...
- Refactored function names for PSR-12 compliance
- Programmatically cascade delete attribute_link rows when a drop-down attribute is deleted but leave attribute_link rows associated with transactions.
- Added `WHERE item_id IS NOT NULL` to migration to prevent failure on MySQL databases during migration
- Retroactive correction of migration to prevent MySQL databases from failing.
- Refactored generic functions to helper
- Reverted attribute_links foreign key to ON DELETE RESTRICT which is required for a unique constraint on this table. Cascading deletes are now handled programmatically.
- Migration Session table to match Code Igniter 4.6
- Add index to attribute_links to prevent query timeout in items view on large databases
- Added overridePrefix() function to the migration_helper. Any time QueryBuilder is adding a prefix to the query when we don't want it to, this query can be used to override the prefix then set it back after you're done.
- Added dropAllForeignKeyConstraints() helper function.
- Added deleteIndex() helper function.
- Added indexExists() helper function.
- Added primaryKeyExists() helper function.
- Added recreateForeignKeyConstraints() helper function.
- Added CRUD section headings to the Attribute model.
- Replaced `==` with `===` to prevent type juggling.
- Removed unused delete_value function.
- Reworked deleteDefinition() and deleteDefinitionList() functions to delete rows from the attribute_links table which are associated.
- Added deleteAttributeLinksByDefinitionId() function
Implement Cascading Delete
- Function to delete attribute links with one or more attribute definitions.
- Call function to implement an effective cascading delete.
- Refactor function naming to meet PSR-12 conventions
Fix Migration
- Add drop of Generated Column to prevent failure of migration on MySQL databases.
Fix Migration
- Removed blank lines
- Refactored function naming for PSR compliance
- Reformatted code for PSR compliance
- Added logic to drop dependent foreign key constraints before deleting an index then recreating them.
Migrate ospos_sessions table
- DROP and CREATE session table to prevent migration problems on populated databases
Fixed Bug in Migration
- In the event that item_id = null (e.g., it's a dropdown) it should not be included in the results.
Fixed bug in Dropdown deletes
- Removed delete_value function in Attributes Controller as it is unused.
- Renamed postDelete_attribute_value function for PSR-12 compliance.
- Renamed delete_value Attribute model function for PSR-12 compliance.
- Refactored out function to getAttributeIdByValue
- Replaced == with === to prevent type juggling
- Reorganized parts of model to make it easier to find CRUD functions.
Refactoring
- PSR-12 Compliance formatting changes
- Refactored several generic functions into the migration_helper.php
- First check if primary key exists before attempting to create it.
- Grouped functions together in migration_helper.php
- phpdoc commenting functions
Optimizing Indices
- There are two queries run while opening the Items view which time out on large databases with weak hardware. These indices cut the query execution in half or better.
Add Unique constraint back into attribute_links
- This migration reverts ospos_attribute_links_ibfk_1 and 2 to ON DELETE RESTRICT. Cascade delete is done programmatically. This is needed to have a unique column on the attribute_links table which prevents duplicate attributes from begin created with the same item_id-attribute_id-definition_id combination
Correct spacing after if for PSR-12
Minor code cleanup.
- Removed Comments separating sections of code in Attribute model
- Removed extra log line to prevent cluttering of the log
2025-05-29 15:24:08 +04:00
Maxime
3c846e6324
Fixed broken escape string for success & warning messages ( #4253 )
...
* Fixed broken escape string for success & warning messages
* Fixed issue in sales register
---------
Co-authored-by: Franchovy <franchovy@pm.me >
2025-05-27 23:27:27 +02:00
diego-ramos
85120fa4be
Fix encoding issue for payment types with special characters ( #4232 )
2025-05-22 22:34:39 +02:00
Mohamed-Qadir
7ba60ba58b
Translated using Weblate (Kurdish (Central))
...
Currently translated at 100.0% (38 of 38 strings)
Translation: opensourcepos/item_kits
Translate-URL: https://translate.opensourcepos.org/projects/opensourcepos/item_kits/ckb/
2025-05-10 02:04:32 +02:00
Mohamed-Qadir
64f34933c4
Translated using Weblate (Kurdish (Central))
...
Currently translated at 100.0% (145 of 145 strings)
Translation: opensourcepos/reports
Translate-URL: https://translate.opensourcepos.org/projects/opensourcepos/reports/ckb/
2025-05-10 02:04:32 +02:00
Mohamed-Qadir
1c0442c4f6
Translated using Weblate (Kurdish (Central))
...
Currently translated at 100.0% (68 of 68 strings)
Translation: opensourcepos/giftcards
Translate-URL: https://translate.opensourcepos.org/projects/opensourcepos/giftcards/ckb/
2025-05-10 02:04:32 +02:00
Mohamed-Qadir
8bc4ee3792
Translated using Weblate (Kurdish (Central))
...
Currently translated at 100.0% (45 of 45 strings)
Translation: opensourcepos/module
Translate-URL: https://translate.opensourcepos.org/projects/opensourcepos/module/ckb/
2025-05-10 02:04:31 +02:00
Mohamed-Qadir
c200561eb5
Translated using Weblate (Kurdish (Central))
...
Currently translated at 100.0% (117 of 117 strings)
Translation: opensourcepos/items
Translate-URL: https://translate.opensourcepos.org/projects/opensourcepos/items/ckb/
2025-05-10 02:04:19 +02:00
Mohamed-Qadir
a55d5b415e
Translated using Weblate (Kurdish (Central))
...
Currently translated at 73.3% (33 of 45 strings)
Translation: opensourcepos/module
Translate-URL: https://translate.opensourcepos.org/projects/opensourcepos/module/ckb/
2025-05-09 19:33:42 +02:00
Mohamed-Qadir
f31d004fb7
Translated using Weblate (Kurdish (Central))
...
Currently translated at 55.2% (21 of 38 strings)
Translation: opensourcepos/item_kits
Translate-URL: https://translate.opensourcepos.org/projects/opensourcepos/item_kits/ckb/
2025-05-09 19:33:41 +02:00
Mohamed-Qadir
40e4ad3d38
Translated using Weblate (Kurdish (Central))
...
Currently translated at 35.8% (42 of 117 strings)
Translation: opensourcepos/items
Translate-URL: https://translate.opensourcepos.org/projects/opensourcepos/items/ckb/
2025-05-09 19:33:41 +02:00
Mohamed-Qadir
7658ca8dd2
Translated using Weblate (Kurdish (Central))
...
Currently translated at 100.0% (68 of 68 strings)
Translation: opensourcepos/giftcards
Translate-URL: https://translate.opensourcepos.org/projects/opensourcepos/giftcards/ckb/
2025-05-09 19:33:41 +02:00
Mohamed-Qadir
f38272cb59
Translated using Weblate (Kurdish (Central))
...
Currently translated at 100.0% (12 of 12 strings)
Translation: opensourcepos/login
Translate-URL: https://translate.opensourcepos.org/projects/opensourcepos/login/ckb/
2025-05-09 19:33:40 +02:00
Mohamed-Qadir
dca3cdeaf5
Translated using Weblate (Kurdish (Central))
...
Currently translated at 31.1% (14 of 45 strings)
Translation: opensourcepos/module
Translate-URL: https://translate.opensourcepos.org/projects/opensourcepos/module/ckb/
2025-05-09 19:11:03 +02:00
Mohamed-Qadir
41eb07caec
Translated using Weblate (Kurdish (Central))
...
Currently translated at 100.0% (145 of 145 strings)
Translation: opensourcepos/reports
Translate-URL: https://translate.opensourcepos.org/projects/opensourcepos/reports/ckb/
2025-05-09 19:11:03 +02:00
Mohamed-Qadir
766c9bb0f2
Translated using Weblate (Kurdish (Central))
...
Currently translated at 33.3% (39 of 117 strings)
Translation: opensourcepos/items
Translate-URL: https://translate.opensourcepos.org/projects/opensourcepos/items/ckb/
2025-05-09 19:11:02 +02:00
Mohamed-Qadir
7113e1167c
Translated using Weblate (Kurdish (Central))
...
Currently translated at 100.0% (55 of 55 strings)
Translation: opensourcepos/receivings
Translate-URL: https://translate.opensourcepos.org/projects/opensourcepos/receivings/ckb/
2025-05-09 19:11:02 +02:00
Mohamed-Qadir
eaeb9cb426
Translated using Weblate (Kurdish (Central))
...
Currently translated at 89.7% (61 of 68 strings)
Translation: opensourcepos/giftcards
Translate-URL: https://translate.opensourcepos.org/projects/opensourcepos/giftcards/ckb/
2025-05-09 19:11:01 +02:00
Mohamed-Qadir
1971519629
Translated using Weblate (Kurdish (Central))
...
Currently translated at 31.5% (12 of 38 strings)
Translation: opensourcepos/item_kits
Translate-URL: https://translate.opensourcepos.org/projects/opensourcepos/item_kits/ckb/
2025-05-09 19:11:00 +02:00
Mohamed-Qadir
b4e010dab8
Translated using Weblate (Kurdish (Central))
...
Currently translated at 33.8% (23 of 68 strings)
Translation: opensourcepos/giftcards
Translate-URL: https://translate.opensourcepos.org/projects/opensourcepos/giftcards/ckb/
2025-05-09 17:52:39 +02:00
Mohamed-Qadir
75e709d0b5
Translated using Weblate (Kurdish (Central))
...
Currently translated at 51.7% (75 of 145 strings)
Translation: opensourcepos/reports
Translate-URL: https://translate.opensourcepos.org/projects/opensourcepos/reports/ckb/
2025-05-09 17:52:39 +02:00
Mohamed-Qadir
605f550666
Translated using Weblate (Kurdish (Central))
...
Currently translated at 20.0% (9 of 45 strings)
Translation: opensourcepos/module
Translate-URL: https://translate.opensourcepos.org/projects/opensourcepos/module/ckb/
2025-05-09 17:52:38 +02:00
Mohamed-Qadir
bc55908af2
Translated using Weblate (Kurdish (Central))
...
Currently translated at 20.5% (24 of 117 strings)
Translation: opensourcepos/items
Translate-URL: https://translate.opensourcepos.org/projects/opensourcepos/items/ckb/
2025-05-09 17:52:38 +02:00
Mohamed-Qadir
707339f3b5
Translated using Weblate (Kurdish (Central))
...
Currently translated at 27.9% (19 of 68 strings)
Translation: opensourcepos/giftcards
Translate-URL: https://translate.opensourcepos.org/projects/opensourcepos/giftcards/ckb/
2025-05-09 16:40:06 +02:00
Mohamed-Qadir
d0bb7998a9
Translated using Weblate (Kurdish (Central))
...
Currently translated at 18.8% (22 of 117 strings)
Translation: opensourcepos/items
Translate-URL: https://translate.opensourcepos.org/projects/opensourcepos/items/ckb/
2025-05-09 16:40:06 +02:00
Mohamed-Qadir
c47ea659bc
Translated using Weblate (Kurdish (Central))
...
Currently translated at 100.0% (12 of 12 strings)
Translation: opensourcepos/messages
Translate-URL: https://translate.opensourcepos.org/projects/opensourcepos/messages/ckb/
2025-05-09 16:40:06 +02:00
Mohamed-Qadir
9b8d6acb79
Translated using Weblate (Kurdish (Central))
...
Currently translated at 16.2% (19 of 117 strings)
Translation: opensourcepos/items
Translate-URL: https://translate.opensourcepos.org/projects/opensourcepos/items/ckb/
2025-05-07 22:48:28 +02:00
Mohamed-Qadir
640bdfd0f9
Translated using Weblate (Kurdish (Central))
...
Currently translated at 100.0% (21 of 21 strings)
Translation: opensourcepos/suppliers
Translate-URL: https://translate.opensourcepos.org/projects/opensourcepos/suppliers/ckb/
2025-05-07 22:48:27 +02:00
Mohamed-Qadir
0ea4fcd474
Translated using Weblate (Kurdish (Central))
...
Currently translated at 42.0% (61 of 145 strings)
Translation: opensourcepos/reports
Translate-URL: https://translate.opensourcepos.org/projects/opensourcepos/reports/ckb/
2025-05-07 22:48:27 +02:00
Mohamed-Qadir
056add7979
Translated using Weblate (Kurdish (Central))
...
Currently translated at 11.7% (8 of 68 strings)
Translation: opensourcepos/giftcards
Translate-URL: https://translate.opensourcepos.org/projects/opensourcepos/giftcards/ckb/
2025-05-07 22:48:27 +02:00
Mohamed-Qadir
4577525566
Translated using Weblate (Kurdish (Central))
...
Currently translated at 100.0% (19 of 19 strings)
Translation: opensourcepos/expenses_categories
Translate-URL: https://translate.opensourcepos.org/projects/opensourcepos/expenses_categories/ckb/
2025-05-07 22:48:27 +02:00
Mohamed-Qadir
75d4d894a4
Translated using Weblate (Kurdish (Central))
...
Currently translated at 100.0% (41 of 41 strings)
Translation: opensourcepos/employees
Translate-URL: https://translate.opensourcepos.org/projects/opensourcepos/employees/ckb/
2025-05-07 22:48:27 +02:00
Mohamed-Qadir
e4b07125d6
Translated using Weblate (Kurdish (Central))
...
Currently translated at 89.4% (17 of 19 strings)
Translation: opensourcepos/expenses_categories
Translate-URL: https://translate.opensourcepos.org/projects/opensourcepos/expenses_categories/ckb/
2025-05-07 22:48:27 +02:00
Mohamed-Qadir
2d35346d16
Translated using Weblate (Kurdish (Central))
...
Currently translated at 100.0% (47 of 47 strings)
Translation: opensourcepos/expenses
Translate-URL: https://translate.opensourcepos.org/projects/opensourcepos/expenses/ckb/
2025-05-04 15:27:04 +02:00
Mohamed-Qadir
e0969a8c2b
Translated using Weblate (Kurdish (Central))
...
Currently translated at 100.0% (20 of 20 strings)
Translation: opensourcepos/datepicker
Translate-URL: https://translate.opensourcepos.org/projects/opensourcepos/datepicker/ckb/
2025-05-03 23:45:43 +02:00
Mohamed-Qadir
965f3706da
Translated using Weblate (Kurdish (Central))
...
Currently translated at 36.3% (20 of 55 strings)
Translation: opensourcepos/receivings
Translate-URL: https://translate.opensourcepos.org/projects/opensourcepos/receivings/ckb/
2025-05-03 23:45:00 +02:00
BudsieBuds
e83c23cf0c
Improve code style and PSR-12 compliance ( #4204 )
...
* Improve code style and PSR-12 compliance
- refactored code formatting to adhere to PSR-12 guidelines
- standardized coding conventions across the codebase
- added missing framework files and reverted markup changes
- reformatted arrays for enhanced readability
- updated language files for consistent styling and clarity
- minor miscellaneous improvements
2025-05-02 19:37:06 +02:00
Mohamed-Qadir
1456feae58
Translated using Weblate (Kurdish (Central))
...
Currently translated at 75.0% (15 of 20 strings)
Translation: opensourcepos/datepicker
Translate-URL: https://translate.opensourcepos.org/projects/opensourcepos/datepicker/ckb/
2025-05-02 12:54:14 +02:00
Mohamed-Qadir
32c0b74e0a
Translated using Weblate (Kurdish (Central))
...
Currently translated at 35.0% (7 of 20 strings)
Translation: opensourcepos/datepicker
Translate-URL: https://translate.opensourcepos.org/projects/opensourcepos/datepicker/ckb/
2025-05-02 12:05:16 +02:00
Mohamed-Qadir
9ecbe5770c
Translated using Weblate (Kurdish (Central))
...
Currently translated at 100.0% (327 of 327 strings)
Translation: opensourcepos/config
Translate-URL: https://translate.opensourcepos.org/projects/opensourcepos/config/ckb/
2025-05-02 11:31:10 +02:00
Mohamed-Qadir
cedcbf459e
Translated using Weblate (Kurdish (Central))
...
Currently translated at 41.6% (5 of 12 strings)
Translation: opensourcepos/messages
Translate-URL: https://translate.opensourcepos.org/projects/opensourcepos/messages/ckb/
2025-05-02 11:31:09 +02:00
Mohamed-Qadir
73df6db4f8
Translated using Weblate (Kurdish (Central))
...
Currently translated at 94.4% (309 of 327 strings)
Translation: opensourcepos/config
Translate-URL: https://translate.opensourcepos.org/projects/opensourcepos/config/ckb/
2025-05-02 10:55:23 +02:00
Mohamed-Qadir
b0e0b5b429
Translated using Weblate (Kurdish (Central))
...
Currently translated at 94.1% (308 of 327 strings)
Translation: opensourcepos/config
Translate-URL: https://translate.opensourcepos.org/projects/opensourcepos/config/ckb/
2025-05-02 10:50:44 +02:00
Mohamed-Qadir
36f41db6aa
Translated using Weblate (Kurdish (Central))
...
Currently translated at 15.5% (7 of 45 strings)
Translation: opensourcepos/module
Translate-URL: https://translate.opensourcepos.org/projects/opensourcepos/module/ckb/
2025-05-02 10:50:44 +02:00
Mohamed-Qadir
a6c9011954
Translated using Weblate (Kurdish (Central))
...
Currently translated at 16.2% (19 of 117 strings)
Translation: opensourcepos/items
Translate-URL: https://translate.opensourcepos.org/projects/opensourcepos/items/ckb/
2025-05-02 10:50:43 +02:00
Mohamed-Qadir
9f19a15845
Translated using Weblate (Kurdish (Central))
...
Currently translated at 11.7% (8 of 68 strings)
Translation: opensourcepos/giftcards
Translate-URL: https://translate.opensourcepos.org/projects/opensourcepos/giftcards/ckb/
2025-05-02 10:50:34 +02:00