a0206dc8cb
Add logging for model synchronization and cache handling in syncDatabase.js
Torsten Schulz (local)
2025-12-18 16:34:10 +01:00
bf0eed3b03
Update model synchronization in sequelize.js to prevent automatic foreign key creation by adding constraints: false, ensuring foreign keys are managed through migrations only.
Torsten Schulz (local)
2025-12-18 16:14:53 +01:00
c8072b8052
Refactor multiple models to remove foreign key references while maintaining required fields, enhancing data integrity and simplifying model definitions.
Torsten Schulz (local)
2025-12-18 16:08:30 +01:00
c66fbf1a62
Enhance syncDatabase function to include cleanup for orphaned child_relation entries with invalid father_character_id, mother_character_id, or child_character_id references, improving data integrity and logging consistency.
Torsten Schulz (local)
2025-12-18 15:59:35 +01:00
e13a711a60
Refactor user_house model to remove default values for houseTypeId and userId fields, and enhance syncDatabase function to include cleanup for orphaned user_house entries with invalid house_type_id or user_id references, improving data integrity and logging.
Torsten Schulz (local)
2025-12-18 15:57:39 +01:00
346a326bfd
Enhance syncDatabase function to include cleanup for orphaned promotional_gift entries, removing invalid sender and recipient character references, and improve logging for orphaned entry detection.
Torsten Schulz (local)
2025-12-18 15:49:34 +01:00
addb8e9a6d
Refactor Notification model to remove VIRTUAL field definition for characterName and implement a getter method for improved data handling and synchronization.
Torsten Schulz (local)
2025-12-18 15:43:54 +01:00
ea8b9e661d
Refactor VIRTUAL field detection logic in sequelize.js to improve accuracy and add special handling for Notification model's characterName field, addressing a Sequelize bug related to field mapping.
Torsten Schulz (local)
2025-12-18 15:37:52 +01:00
339ae844e9
Enhance VIRTUAL field detection in sequelize.js by implementing multiple identification methods, ensuring accurate model synchronization and preventing unintended field removals.
Torsten Schulz (local)
2025-12-18 15:34:26 +01:00
a0a7e81927
Add socket notification for status bar updates in FalukantService and enhance model sync by handling VIRTUAL fields in sequelize.js
Torsten Schulz (local)
2025-12-18 15:25:24 +01:00
31c23a0c40
Refactor syncDatabase function to improve orphaned entry cleanup for knowledge and notification, ensuring data integrity and consistent logging.
Torsten Schulz (local)
2025-12-18 15:20:09 +01:00
c1f22246ea
Add cleanup for orphaned notification entries in syncDatabase functions to remove invalid user_id references, improving data integrity and logging consistency.
Torsten Schulz (local)
2025-12-18 15:18:21 +01:00
0a1388bf06
Add cleanup for orphaned knowledge entries in syncDatabase functions to remove invalid character_id and product_id references, enhancing data integrity and logging.
Torsten Schulz (local)
2025-12-18 15:17:01 +01:00
1a69b83983
Refactor stock cleanup logic in syncDatabase functions to remove orphaned stock entries with invalid branch_id and streamline logging for orphaned entries.
Torsten Schulz (local)
2025-12-18 15:13:24 +01:00
63f9443b77
Implement cleanup of orphaned user_param_visibility entries before schema updates in syncDatabase functions
Torsten Schulz (local)
2025-12-18 15:11:50 +01:00
6a9b2b8d1d
Add index on (user_id, shown) in notification table to optimize markNotificationsShown queries and prevent deadlocks. Implement transaction handling in markNotificationsShown method for atomic updates.
Torsten Schulz (local)
2025-12-18 15:04:37 +01:00
8e1e0968ae
Refactor product model by removing unused sellCostMinNeutral and sellCostMaxNeutral fields, and simplify product insertion logic in initialization script.
Torsten Schulz (local)
2025-12-18 14:41:56 +01:00
a486292880
Activate pgcrypto extension for digest() function in database initialization and migration scripts
Torsten Schulz (local)
2025-12-18 14:11:15 +01:00
ee4b0ee7c2
Füge Spalte product_quality zur Tabelle stock hinzu und erstelle Migration für weather_type_id in production
Torsten Schulz (local)
2025-12-16 13:00:29 +01:00
43d86cce18
Implement tax handling for branches by adding tax percent to regions, updating product sell costs, and enhancing UI for tax summaries in BranchView
Torsten Schulz (local)
2025-12-09 16:16:08 +01:00
25d7c70058
Enhance transport mode handling by adding localized labels and updating related components in MapRegionsView and BranchView
Torsten Schulz (local)
2025-12-09 11:53:56 +01:00
71c62cf5e8
Enhance vehicle speed display by adding localized labels in DirectorInfo, SaleSection, and BranchView components
Torsten Schulz (local)
2025-12-09 11:45:35 +01:00
a7350282ee
Enhance parameter extraction in MessagesDialog by merging nested parameters for improved notification handling
Torsten Schulz (local)
2025-12-09 00:12:05 +01:00
676629bd8d
Enhance notification enrichment by recursively collecting character IDs and attaching character names
Torsten Schulz (local)
2025-12-09 00:06:09 +01:00
1892877b11
Enhance notification handling by enriching notifications with character names
Torsten Schulz (local)
2025-12-08 23:55:50 +01:00
be218aabf7
Add character_name field and trigger for notifications in Falukant module
Torsten Schulz (local)
2025-12-08 23:37:07 +01:00
856f7d56bf
Enhance parameter extraction for notifications in MessagesDialog component
Torsten Schulz (local)
2025-12-08 16:12:05 +01:00
3c885b6ab9
Add detailed debug logging in loadPricesForAllProducts method of RevenueSection
Torsten Schulz (local)
2025-12-03 16:22:08 +01:00
6b3b30108b
Refactor betterPricesMap updates in RevenueSection for Vue 3 reactivity
Torsten Schulz (local)
2025-12-03 16:15:01 +01:00
7fab23d22b
Refactor betterPricesMap handling in RevenueSection for Vue 3 compatibility
Torsten Schulz (local)
2025-12-03 16:03:06 +01:00
def88f6486
Add debug logging in RevenueSection for better price retrieval tracking
Torsten Schulz (local)
2025-12-03 15:59:15 +01:00
1797ae3e58
Remove debug logging from getProductPricesInCities method in FalukantService
Torsten Schulz (local)
2025-12-03 15:55:30 +01:00
f768ba3b27
Add debug logging for priceInCity in getProductPricesInCities method of FalukantService
Torsten Schulz (local)
2025-12-03 15:39:57 +01:00
b3e48a0b06
Refine price comparison logic in getProductPricesInCities method of FalukantService
Torsten Schulz (local)
2025-12-03 15:35:19 +01:00
3f56939421
Add detailed debug logging in getProductPricesInCities method of FalukantService
Torsten Schulz (local)
2025-12-03 13:39:09 +01:00
87c720c3fe
Refactor RevenueSection to utilize a betterPricesMap for improved price handling
Torsten Schulz (local)
2025-12-03 13:32:02 +01:00
90fbcaf31d
Refactor and remove debug logging in FalukantService and RevenueSection for cleaner code
Torsten Schulz (local)
2025-12-03 11:35:13 +01:00
56c3569b68
Refactor debug logging in FalukantService for improved clarity and consistency
Torsten Schulz (local)
2025-12-03 11:32:06 +01:00
e2969c1837
Enhance RevenueSection to conditionally load product prices based on currentRegionId
Torsten Schulz (local)
2025-12-03 09:19:46 +01:00
fe14c7b9f5
Add debug logging for product price retrieval in FalukantService and RevenueSection
Torsten Schulz (local)
2025-12-03 08:58:07 +01:00
5d01b24c2d
Add debug logging for carrot product pricing in FalukantService
Torsten Schulz (local)
2025-12-03 08:44:45 +01:00
4eeb5021ee
Enhance product price retrieval by including currentRegionId in FalukantController and FalukantService
Torsten Schulz (local)
2025-12-03 08:39:30 +01:00
6ec62af606
Add debug logging to FalukantService and RevenueSection for better price tracking
Torsten Schulz (local)
2025-12-03 08:30:59 +01:00
3d6fdc65d2
Refine price comparison logic in FalukantService to include a tolerance for rounding errors
Torsten Schulz (local)
2025-12-02 15:57:29 +01:00
956418f5f3
Enhance weather model and service logic; improve money history translation handling
Torsten Schulz (local)
2025-12-02 14:05:25 +01:00
e57de7f983
Fix typo in healthDrunkOfLife method and enhance health change logic in FalukantService; refactor health measures localization structure in English and German JSON files for better organization.
Torsten Schulz (local)
2025-12-02 13:05:39 +01:00
08e2c87de8
Enhance branch selection with weather information and localization updates
Torsten Schulz (local)
2025-12-02 12:53:02 +01:00
Torsten Schulz (local)