Commit graph

357 commits

Author SHA1 Message Date
Jan
b708af177f Merge remote-tracking branch 'origin/feature/frontend-optimization' into dev 2026-02-01 11:09:39 +01:00
Jan
f86e2fb1d8 using "!mssql" instead of "mysql" for MySQLDialectProvider so that if no database profile is set, the MySQLDialectProvider is used. 2026-01-31 18:04:11 +01:00
Jan
ae83b0845c using mysql as default config if no profile is active. 2026-01-31 17:54:11 +01:00
Jan
8794a8a193 created db.sh script to start mysql or mssql in container. --clean deletes previous volumens and --users creates dummy users for debugging 2026-01-30 13:45:39 +01:00
Jan
15854e1076 Add part number chips feature to CalculationMassEdit modal
- Display selected part numbers as chips with a count summary.
- Add logic to extract and display unique part numbers from edit IDs.
- Update modal and style components to support the new feature.
2026-01-28 22:07:16 +01:00
Jan
21d00b8756 Refactored PackagingPropertiesRepositoryIntegrationTest 2026-01-28 20:56:50 +01:00
Jan
96715562e6 Added integration tests for CalculationJobDestinationRepository and CalculationJobRouteSectionRepository for MySQL and MSSQL; 2026-01-28 17:53:42 +01:00
Jan
8d08fedbc4 Added integration tests for RouteRepository and RouteNodeRepository for MySQL and MSSQL; Marked DestinationRepository as @Repository. 2026-01-28 12:18:52 +01:00
Jan
a381ca7ef8 Improved removeOld method in BulkOperationRepository to fix subquery limitations in MySQL and optimize deletion logic. 2026-01-28 11:21:00 +01:00
Jan
ffc08ebff6 Added integration tests for BulkOperationRepository and CalculationJobRepository for MySQL and MSSQL. 2026-01-28 11:20:39 +01:00
Jan
52116be1c3 Added integration tests for ContainerRateRepository, GroupRepository, and UserRepository for MySQL and MSSQL. Improved test coverage for pagination, filtering, UPSERT operations, and data cleanup methods. 2026-01-28 10:36:24 +01:00
Jan
5c8165c60e Added MatrixRateRepositoryIntegrationTest for MySQL and MSSQL; ensured data cleanup, improved test coverage for rate operations, and adjusted SQL logic for validation and copying between periods. 2026-01-28 09:12:27 +01:00
Jan
a5fd03cc68 Refactored integration tests for NomenclatureRepository to ensure test data cleanup and alignment with updated table structure. Removed unused beans and dependencies in RepositoryTestConfig. 2026-01-28 00:15:02 +01:00
Jan
3f8453f93b Refactored and extended integration tests for repositories; added data cleanup methods, improved test coverage for property date handling, and adjusted SQL queries for validity and property set logic. Removed unused dependencies in NomenclatureRepository. 2026-01-27 22:58:39 +01:00
Jan
1a5a00e111 Removed MSSQL-specific test skips and fixed buildInsertIgnoreStatement by replacing IF NOT EXISTS logic with MERGE syntax. Adjusted SQL query to include missing GROUP BY fields in CountryPropertyRepository. 2026-01-27 22:10:17 +01:00
Jan
861c5e7bbc Added integration tests for CountryPropertyRepository, SysErrorRepository, and PropertyRepository for MySQL and MSSQL. 2026-01-27 21:21:44 +01:00
Jan
6fc0839320 Added integration tests for UserNodeRepository, MaterialRepository, NomenclatureRepository, and PackagingDimensionRepository for MySQL and MSSQL. 2026-01-27 20:05:11 +01:00
Jan
919c9d0499 Added PackagingRepositoryIntegrationTest for MySQL and MSSQL; extended PackagingRepository with additional fields in SELECT query and improved SQL pagination logic. 2026-01-27 19:27:13 +01:00
Jan
c25f00bb01 Added CountryRepositoryIntegrationTest for MySQL and MSSQL, updated CountryRepository to support dialect-specific boolean literals. 2026-01-27 18:20:54 +01:00
Jan
8e6cc8cf07 Added TestContainers-based testing configuration for MySQL and MSSQL integration tests. Added module test for DialectProviders, Smoketests for TestContainers-based integration tests. NodeRepositoryIntegrationTest. Other Repository integration tests still missing. 2026-01-27 18:04:08 +01:00
Jan
5fb025e4b3 further sql fixes. frontend fix height of help system 2026-01-27 13:16:07 +01:00
Jan
e53f865210 further sql fixes 2026-01-27 12:40:11 +01:00
Jan
b1d46c1057 Updated migration scripts to ensure Unicode compatibility by using N-prefixed strings in MSSQL SQL INSERT statements. 2026-01-27 12:10:06 +01:00
Jan
1baf3111aa Updated migration scripts to ensure Unicode compatibility by using N-prefixed strings in MSSQL SQL INSERT statements. 2026-01-27 11:06:47 +01:00
Jan
cd411d8b01 Updated MSSQL schema migration script to use NVARCHAR for Unicode support. 2026-01-27 10:57:01 +01:00
Jan
48ce77dad3 Added missing boolean values to dialectProvider 2026-01-27 10:43:40 +01:00
Jan
5b2018c9e0 Fixed "TRUE/FALSE" => "0/1" mssql 2026-01-27 10:00:48 +01:00
Jan
28ee19d654 Ported flyway migration steps to mssql. Add initial MSSQL support with Docker scripts and SQL initialization. 2026-01-27 09:15:40 +01:00
Jan
0d4fb1f04f Step 2.3 - Add MSSQLDialectProvider Implementation 2026-01-26 21:08:04 +01:00
Jan
5866f8edc8 Fixed build errors 2026-01-25 19:41:52 +01:00
Jan
eff5d26ea3 Step 2.3 - Finalize Repositories with SqlDialectProvider Integration 2026-01-25 19:30:45 +01:00
Jan
1084c5b1cd Step 2.2 - Mid-Priority Repositories 2026-01-25 19:16:22 +01:00
Jan
29675f9ff4 Step 2.1: Kritische Repositories (3 Tasks) 2026-01-25 18:42:31 +01:00
Jan
10a8cfa72b Step 1 - Foundation & Infrastruktur (SqlDialectProvider Interface, Maven Dependencies, Konfiguration) 2026-01-25 18:30:51 +01:00
Jan
417221eca8 Fix: More stable bulk geocoding. Added @Transactional to outer bulk service call, to revert all changes to database if anything fails 2026-01-23 16:57:06 +01:00
Jan
605bcfe0fc Improve Excel mapper geocoding: Add fuzzy search fallback for failed addresses, introduce better cell value handling, and enhance error logging. 2026-01-22 17:25:40 +01:00
03cd1274e9 src/main/java/de/avatic/lcc/service/api/BatchGeoApiService.java aktualisiert
Fixed nullpointer exception in batch geo coding
2026-01-22 09:35:12 +00:00
Jan
462a960c68 Implemented deactivated container types, CalculationExecutionService to handle container type activation logic. Fix destinationEdit store to handle null values in data. 2026-01-20 09:53:58 +01:00
Jan
b66ac66b54 Bugfixing: Clean up existing drafts in PremisesService and include annual repacking cost in CalculationExecutionService. 2026-01-18 21:24:24 +01:00
Jan
11d32a665e Rename pages-change event to page-change in Pagination component and update related references. 2026-01-18 18:37:07 +01:00
Jan
b5f2df8be7 Rename helppages-change event to pages-change in Pagination component. 2026-01-18 18:15:45 +01:00
Jan
bdfaef3365 Fixed isWeightExceeded value in database. Fixed shipping freqency rounding in database 2026-01-18 18:11:22 +01:00
Jan
8742d24b62 Add help system with markdown-based content, video support, and help menu integration; update related UI components, backend services, and frontend store to enable contextual help functionality. 2026-01-10 19:19:38 +01:00
Jan
22051135ad Fix supplier item layout and styling, 2026-01-06 20:39:07 +01:00
Jan
23bc00d33c Improve logging in DistanceApiService and DistanceMatrixRepository: Add fallback to names when external mapping IDs are null, fix inconsistent spacing, and enhance error messages with better node ID resolution. 2026-01-06 18:17:28 +01:00
Jan
8ef279e735 Enhance error handling in massSetDestinations: Add notifications for failures, logging support, and update modal behavior to prevent data clearing on errors. 2026-01-06 17:40:07 +01:00
Jan
81233db437 Fixing wrong modal title if edited over toolbar 2026-01-06 17:20:46 +01:00
Jan
8d85e4c692 Refactor ShippingFrequencyCalculationService: Adjust container calculation logic to ensure minAnnualFrequency is respected when fillContainer is true. 2026-01-06 16:37:46 +01:00
Jan
9b13261a20 Fixed "Oversea share" -> "Overseas share". Dont show partnumber/Supplier in error message when in single edit mode 2026-01-06 12:34:43 +01:00
Jan
eb5aecb1b5 Bugfix shippingfrequency 2026-01-05 14:10:56 +01:00