0336c55560
Enhance socket.io URL handling for production environments
Torsten Schulz (local)
2026-01-05 16:26:23 +01:00
8e618ab443
Implement TLS support in WebSocket server for secure connections
Torsten Schulz (local)
2026-01-05 16:06:37 +01:00
352d672bdd
Add keyboard handling in VocabPracticeDialog for improved user interaction
Torsten Schulz (local)
2025-12-30 20:22:04 +01:00
df64c0a4b5
Update VocabPracticeDialog and VocabChapterView components to manage practice dialog state
Torsten Schulz (local)
2025-12-30 18:44:35 +01:00
83597d9e02
Add Vocab Trainer feature with routing, database schema, and translations
Torsten Schulz (local)
2025-12-30 18:34:32 +01:00
a09220b881
Add translations for reputation action school funding in German and English locales
Torsten Schulz (local)
2025-12-23 14:37:33 +01:00
5623f3af09
Refactor error handling in FalukantService and enhance user feedback in HealthView
Torsten Schulz (local)
2025-12-23 12:20:37 +01:00
820b5e8570
Enhance health management in FalukantService to improve user feedback and error handling
Torsten Schulz (local)
2025-12-23 10:51:22 +01:00
dc72ed2feb
Add taxFromSaleProduct translation and enhance MoneyHistoryView for product loading
Torsten Schulz (local)
2025-12-22 15:17:51 +01:00
ea468c9878
Improve conditionLabel method in BranchView component to handle edge cases and ensure accurate state representation. Added checks for null and undefined values, and clarified the return value for zero or negative conditions.
Torsten Schulz (local)
2025-12-22 14:54:51 +01:00
d1b683344e
Update condition handling in FalukantService and syncDatabase utility for legacy data
Torsten Schulz (local)
2025-12-22 13:20:16 +01:00
a82ec7de3f
Add cooldown feature for reputation actions in FalukantService and update UI components
Torsten Schulz (local)
2025-12-21 22:18:29 +01:00
560a9efc69
Refactor ReputationView component to streamline action display and remove deprecated tab
Torsten Schulz (local)
2025-12-21 21:37:22 +01:00
4f8b1e33fa
Update message dialog parameters in ReputationView component for improved clarity
Torsten Schulz (local)
2025-12-21 21:14:06 +01:00
38f23cc6ae
Enhance getFalukantUserOrFail and createParty methods in FalukantService to support transaction options
Torsten Schulz (local)
2025-12-20 23:30:10 +01:00
6cf8fa8a9c
Add reputation attribute to FalukantCharacter model and update related services and views
Torsten Schulz (local)
2025-12-20 23:00:31 +01:00
f9ea4715d7
Refactor BranchView component to replace JavaScript alerts with a message dialog for success and error notifications. This improves user experience by providing a more integrated feedback mechanism within the UI.
Torsten Schulz (local)
2025-12-20 22:14:39 +01:00
b34b374f76
Refactor sellAllProducts method in FalukantService to ensure atomic transactions for selling products, updating inventory, and handling financial transactions. Implement batch processing for sell items and enhance error handling for inventory deletions. Update updateFalukantUserMoney function to support transactions, improving consistency and reliability in financial operations.
Torsten Schulz (local)
2025-12-20 22:04:29 +01:00
83d1168f26
Refactor speedLabel method in SaleSection component to move it from computed properties to methods for better compatibility with Vue3. This change ensures the function is callable and maintains its intended functionality.
Torsten Schulz (local)
2025-12-20 21:32:53 +01:00
91009f52cd
Refactor SaleSection component to utilize direct property assignment for betterPrices, enhancing reactivity in Vue3. Update inventory mapping to ensure betterPrices is always an array.
Torsten Schulz (local)
2025-12-20 21:28:01 +01:00
c6dfca7052
Enhance SaleSection component to improve UI responsiveness during sales. Reset selling state immediately after sell actions and update inventory handling to ensure user feedback is timely and accurate.
Torsten Schulz (local)
2025-12-20 21:09:10 +01:00
aaeaeeed24
Add request and SQL performance logging features to backend
Torsten Schulz (local)
2025-12-20 16:35:30 +01:00
c5804f764c
Optimize getInventory method in FalukantService by replacing nested includes with a single SQL query for improved performance. Add error handling for invalid branchId input.
Torsten Schulz (local)
2025-12-20 16:13:33 +01:00
fbe0d1bcd1
Add error handling for missing branches in sell batch processing in FalukantService. Ensure that missing branch IDs trigger an error to prevent accounting mismatches.
Torsten Schulz (local)
2025-12-20 16:01:18 +01:00
2fb440f033
Implement synchronous price calculation for batch operations in FalukantService, optimizing performance by reducing database queries. Update inventory handling to batch delete items and enhance revenue calculations. Fix translation formatting in German locale for sellAllSuccess message.
Torsten Schulz (local)
2025-12-20 15:37:16 +01:00
a8a136a9ce
Enhance SaleSection component to manage selling state with improved user feedback. Disable buttons during selling, show status messages for sellAll actions, and update translations for new statuses.
Torsten Schulz (local)
2025-12-20 15:35:20 +01:00
ac45a2ba26
Refactor SQL joins in calcRegionalSellPrice function of FalukantService to use updated region type table for improved clarity and consistency in tax calculations.
Torsten Schulz (local)
2025-12-20 15:03:03 +01:00
afe15dd4f5
Refactor tax calculation in calcRegionalSellPrice function of FalukantService to convert exemptTypes Set to PostgreSQL array string for improved query performance and clarity.
Torsten Schulz (local)
2025-12-20 14:54:32 +01:00
e3df88bea0
Enhance getCumulativeTaxPercentWithExemptions function in FalukantService to first retrieve the character associated with the userId, ensuring accurate filtering of political offices by characterId for regional tax calculations.
Torsten Schulz (local)
2025-12-20 11:09:03 +01:00
c69a414f78
Fix cumulative tax calculation in FalukantService by using falukantUser.id instead of user.id for accurate regional tax assessments.
Torsten Schulz (local)
2025-12-20 11:04:21 +01:00
66e6fab663
Refactor getCumulativeTaxPercentWithExemptions function in falukantService.js to filter political offices by userId through the FalukantCharacter model. Update query structure to enhance clarity and ensure accurate data retrieval for regional tax calculations.
Torsten Schulz (local)
2025-12-20 10:48:56 +01:00
4da572822e
Merge pull request 'Update dependency nodemon to v3.1.11' (#3) from renovate/nodemon-3.x-lockfile into main
Torsten Schulz2025-12-19 16:16:21 +01:00
ee23bb3ba3
Merge pull request 'Replace dependency npm-run-all with npm-run-all2 ^5.0.0' (#2) from renovate/npm-run-all-replacement into main
Torsten Schulz2025-12-19 16:16:12 +01:00
a0aa678e7d
Implement logic to create tables without Foreign Key constraints in sequelize.js when referenced tables do not exist. Enhance error handling and logging to provide clear feedback during synchronization attempts, improving robustness in model management.
origin/main
origin/HEAD
Torsten Schulz (local)
2025-12-19 08:37:40 +01:00
a1b6e6ab59
Enhance error handling in sequelize.js for Foreign Key Constraint Errors by adding logging for orphaned records and skipping problematic models during synchronization. Update syncDatabase.js to include cleanup logic for orphaned political_office entries, improving database integrity and user feedback during sync operations.
Torsten Schulz (local)
2025-12-19 08:34:04 +01:00
73acf1d1cd
Refactor error handling in sequelize.js to skip model synchronization for cases with duplicate pg_description entries or multiple tables with the same name. Update logging to provide clearer feedback on sync failures and the reasons for skipping models, enhancing user understanding of potential issues.
Torsten Schulz (local)
2025-12-19 08:13:52 +01:00
48110e9a6f
Improve error handling and logging for duplicate pg_description cleanup in sequelize.js. Update comments for clarity on permission requirements and provide detailed instructions for manual cleanup by database administrators. Enhance user feedback during synchronization attempts to address potential permission issues.
Torsten Schulz (local)
2025-12-19 07:56:07 +01:00
642e215c69
Refactor duplicate entry cleanup in sequelize.js by replacing DO $$ blocks with direct parameter substitution in SQL queries. This change enhances performance and security while maintaining the logic for cleaning up duplicate pg_description entries before and after model synchronization.
Torsten Schulz (local)
2025-12-19 07:53:34 +01:00
091b9ff70a
Enhance model synchronization in sequelize.js by adding logic to clean up duplicate pg_description entries before and after sync attempts. Implement error handling for potential sync failures related to duplicate entries, improving robustness and clarity in foreign key management during model synchronization.
Torsten Schulz (local)
2025-12-18 17:53:24 +01:00
86f753c745
Refactor associations in models to include constraints: false, preventing automatic foreign key creation. Update sequelize.js to enhance foreign key management during model synchronization, ensuring associations are restored correctly after sync operations.
Torsten Schulz (local)
2025-12-18 17:44:17 +01:00
c28f8b1384
Enhance foreign key management in sequelize.js by refining schema handling and improving logging for foreign key removal during model synchronization. Add detailed console outputs for better visibility on foreign key operations and error handling.
Torsten Schulz (local)
2025-12-18 16:45:56 +01:00
9b36297171
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
7beed235d7
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
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
Torsten Schulz (local)
Torsten Schulz