jekkos
8cd9de6220
Fix reference to uploads folder ( #4270 )
2025-08-18 21:07:03 +02:00
jekkos
2eff79a8b6
Fix for suspended sales ( #4283 ) ( #4303 )
2025-08-15 23:12:35 +02:00
Aril Apria Susanto
880fb8faef
Translated using Weblate (Indonesian)
...
Currently translated at 100.0% (327 of 327 strings)
Translation: opensourcepos/config
Translate-URL: https://translate.opensourcepos.org/projects/opensourcepos/config/id/
2025-08-11 10:27:22 +02:00
Aril Apria Susanto
4d2347173b
Translated using Weblate (Indonesian)
...
Currently translated at 100.0% (85 of 85 strings)
Translation: opensourcepos/common
Translate-URL: https://translate.opensourcepos.org/projects/opensourcepos/common/id/
2025-08-11 10:27:22 +02:00
Aril Apria Susanto
82d36d01fb
Translated using Weblate (Indonesian)
...
Currently translated at 100.0% (45 of 45 strings)
Translation: opensourcepos/module
Translate-URL: https://translate.opensourcepos.org/projects/opensourcepos/module/id/
2025-08-11 10:27:22 +02:00
Aril Apria Susanto
13314b7da1
Translated using Weblate (Indonesian)
...
Currently translated at 100.0% (53 of 53 strings)
Translation: opensourcepos/customers
Translate-URL: https://translate.opensourcepos.org/projects/opensourcepos/customers/id/
2025-08-11 10:27:22 +02:00
jekkos
1615ef3832
Set release version to 3.4.2
2025-08-07 21:06:11 +02:00
jekkos
e089dc5e2c
Fix item kits update ( #4294 )
2025-08-06 23:40:00 +02:00
jekkos
e08367aaae
Allow empty tax category id ( #4285 ) ( #4288 )
2025-07-29 23:59:23 +02:00
jekkos
9cd2f685ff
Fix barcode generation in items ( #4270 )
2025-07-29 23:56:50 +02:00
jekkos
d4ab56b742
Fix migration 20250522000000 ( #4284 )
...
* Fix migration errors
Add dropColumnIfExists to migration_helper
* Add config key/values if missing (#4282 )
2025-07-16 23:28:24 +02:00
jekkos
1eb75d6e05
Fix typo in writeable ( #4270 )
2025-07-11 23:23:13 +02:00
jekkos
0d1f4efe3c
Extended payment delete fix ( #4274 )
...
* Create a Base64 URL-Safe encoding and decoding helper
* Rename web_helper to url_helper
---------
Co-authored-by: El_Coloso <diegoramosp@gmail.com >
2025-07-07 13:57:03 +02:00
jekkos
b9e17daac7
Fix writable folder permission check ( #4270 ) ( #4273 )
2025-07-06 22:04:17 +02:00
jekkos
5f395d987b
Set release version to 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