31e60b8eb1
Implement foreign key removal before model synchronization in sequelize.js to prevent conflicts during sync. Add error handling and logging for better visibility on foreign key management.
Torsten Schulz (local)
2025-12-18 16:39:34 +01:00
366fa68cc3
Improve model synchronization in sequelize.js by temporarily removing associations to prevent automatic foreign key creation. Add logging for association management during the sync process, ensuring clarity in model handling.
Torsten Schulz (local)
2025-12-18 16:36:26 +01:00
d34d0667c3
Add logging for model synchronization and cache handling in syncDatabase.js
Torsten Schulz (local)
2025-12-18 16:34:10 +01:00
30627b318b
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
57ca664b51
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
a15e017ed0
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
b6c4d62ecc
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
6703c0c390
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
ccee65aa2e
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
fd14bd6081
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
a1bf9fedce
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
a8eeb1f683
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
252c19fa58
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
431f3fa08d
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
1f5860ee40
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
ad0d7f6f1e
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
b25698b120
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
95fc20318f
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
04626b25c9
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
0b2317906b
Activate pgcrypto extension for digest() function in database initialization and migration scripts
Torsten Schulz (local)
2025-12-18 14:11:15 +01:00
5b3ce93d56
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
cb3510bbff
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
2a182ef921
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
2d408bb93e
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
490f0d14f3
Enhance parameter extraction in MessagesDialog by merging nested parameters for improved notification handling
Torsten Schulz (local)
2025-12-09 00:12:05 +01:00
3e381ef750
Enhance notification enrichment by recursively collecting character IDs and attaching character names
Torsten Schulz (local)
2025-12-09 00:06:09 +01:00
eccf2b2688
Enhance notification handling by enriching notifications with character names
Torsten Schulz (local)
2025-12-08 23:55:50 +01:00
4794ee2198
Add character_name field and trigger for notifications in Falukant module
Torsten Schulz (local)
2025-12-08 23:37:07 +01:00
bed65c30dd
Enhance parameter extraction for notifications in MessagesDialog component
Torsten Schulz (local)
2025-12-08 16:12:05 +01:00
60678ede59
Add detailed debug logging in loadPricesForAllProducts method of RevenueSection
Torsten Schulz (local)
2025-12-03 16:22:08 +01:00
c1a90654c0
Refactor betterPricesMap updates in RevenueSection for Vue 3 reactivity
Torsten Schulz (local)
2025-12-03 16:15:01 +01:00
c17d4d3e0e
Refactor betterPricesMap handling in RevenueSection for Vue 3 compatibility
Torsten Schulz (local)
2025-12-03 16:03:06 +01:00
ca753d3bcf
Add debug logging in RevenueSection for better price retrieval tracking
Torsten Schulz (local)
2025-12-03 15:59:15 +01:00
53eac301be
Remove debug logging from getProductPricesInCities method in FalukantService
Torsten Schulz (local)
2025-12-03 15:55:30 +01:00
2227564a6d
Add debug logging for priceInCity in getProductPricesInCities method of FalukantService
Torsten Schulz (local)
2025-12-03 15:39:57 +01:00
5b0a19545b
Refine price comparison logic in getProductPricesInCities method of FalukantService
Torsten Schulz (local)
2025-12-03 15:35:19 +01:00
46c4cb7f1a
Add detailed debug logging in getProductPricesInCities method of FalukantService
Torsten Schulz (local)
2025-12-03 13:39:09 +01:00
27f4ea8b0a
Refactor RevenueSection to utilize a betterPricesMap for improved price handling
Torsten Schulz (local)
2025-12-03 13:32:02 +01:00
cb3cd2208a
Refactor and remove debug logging in FalukantService and RevenueSection for cleaner code
Torsten Schulz (local)
2025-12-03 11:35:13 +01:00
84ede5c7a6
Refactor debug logging in FalukantService for improved clarity and consistency
Torsten Schulz (local)
2025-12-03 11:32:06 +01:00
fdb67e41fa
Enhance RevenueSection to conditionally load product prices based on currentRegionId
Torsten Schulz (local)
2025-12-03 09:19:46 +01:00
11cd100447
Add debug logging for product price retrieval in FalukantService and RevenueSection
Torsten Schulz (local)
2025-12-03 08:58:07 +01:00
e70ece7455
Add debug logging for carrot product pricing in FalukantService
Torsten Schulz (local)
2025-12-03 08:44:45 +01:00
c609396ef2
Enhance product price retrieval by including currentRegionId in FalukantController and FalukantService
Torsten Schulz (local)
2025-12-03 08:39:30 +01:00
79d7760920
Add debug logging to FalukantService and RevenueSection for better price tracking
Torsten Schulz (local)
2025-12-03 08:30:59 +01:00
e5fe2256ad
Refine price comparison logic in FalukantService to include a tolerance for rounding errors
Torsten Schulz (local)
2025-12-02 15:57:29 +01:00
1a2d3b494e
Enhance weather model and service logic; improve money history translation handling
Torsten Schulz (local)
2025-12-02 14:05:25 +01:00
b4a3d6d45f
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
ed4b1030ec
Enhance branch selection with weather information and localization updates
Torsten Schulz (local)
2025-12-02 12:53:02 +01:00
Torsten Schulz (local)