Commit graph

290 commits

Author SHA1 Message Date
Jan
f68a6b30a5 Bulk operation:
- Fixed empty kilometer rates and container rates
2025-09-23 23:11:51 +02:00
Jan
ef76bf382f Bulk operation:
- Material import implemented
2025-09-23 18:30:35 +02:00
Jan
afb72e4d44 Bulk operations errors fixed:
- changed container rate order
- allow blank rows
2025-09-23 18:13:21 +02:00
Jan
aa054ab706 Bulk operations errors fixed:
- outbound countries db lookup fixed
- node lookup by mapping id fixed
- allowing blank excel cells (outbound countries and pre-node list)
Fix:
- missing properties added again
2025-09-23 17:42:03 +02:00
Jan
55e072146f Merge remote-tracking branch 'origin/main' 2025-09-23 16:47:52 +02:00
Jan
fa01115c03 Intermediate commit:
- bulk operations
2025-09-23 16:47:39 +02:00
Anja Guenther
dc983d52da Überarbeitung der Beschreibung, kürzer. 2025-09-23 10:57:09 +02:00
Anja Guenther
4bad5379c4 Reihenfolge der Properties angepasst 2025-09-23 09:44:12 +02:00
Anja Guenther
3f5e3cb115 Merge branch 'main' of git.avatic.de:avatic/lcc_tool
# Conflicts:
#	src/main/resources/master_data/01-properties.sql
2025-09-22 21:16:11 +02:00
Anja Guenther
dba0e69586 Korrektur von Beschreibung der Properties, Änderung der Reihenfolge innerhalb der Gruppen 2025-09-22 21:00:58 +02:00
Jan
ac85db0064 Fixed:
- property descriptions integrated
- booking_klt property added to calculations.
2025-09-22 20:20:44 +02:00
Jan
64ec4f2d11 Fixed:
- size and weight check before calculation
- part numbers search in assistant
2025-09-22 18:56:43 +02:00
Anja Guenther
9fe7da4a33 Merge branch 'main' of git.avatic.de:avatic/lcc_tool 2025-09-21 21:18:21 +02:00
Anja Guenther
5fc05b6383 Beschreibung der Properties im Schema eingeführt; Sort ID eingeführt;Properties gruppiert 2025-09-21 21:17:53 +02:00
Jan
e809ae0130 Fixed:
- show price with 2 fixed decimal places
2025-09-21 15:00:19 +02:00
Jan
cf4392ded2 Fixed:
- search instead of list in "create calculation"
- overflow in modal
2025-09-21 14:48:55 +02:00
Jan
0501c99903 Added errors to database and simple error view in frontend 2025-09-21 13:29:12 +02:00
Jan
5e114ce859 Added errors to database and simple error view in frontend 2025-09-19 17:00:18 +02:00
Jan
e5bd56d3a9 FRONTEND: bulk download working.
Added views for nodes, materials and rates
2025-09-16 20:44:41 +02:00
Jan
3b683018de FRONTEND: bulk download mostly working 2025-09-13 22:03:51 +02:00
Jan
ad5a97ec74 BACKEND: fixed near_by routing bug
FRONTEND: added bulk menu
2025-09-13 21:35:46 +02:00
Jan
a2822666a6 BACKEND: fixed near_by routing bug
FRONTEND: added bulk menu
2025-09-13 20:09:01 +02:00
Jan
02249d2da4 FRONTEND: further bugfixing:
- start from scratch fixed.
- resetting report store if reporting page is called.
- destination incomplete warning fixed for d2d
- price edit formatting fixed
- report: differentiating between d2d, transport with/without mainrun.

BACKEND:
- user/groups: fixed the "/api/groups" <-> /api/groups/" error
- added missing d2d result in a calculation result.
- reporting: allow only valid calculations within reporting.
- routing: fixing remove duplicate method.
- replacing doubles with big decimals
- ... etc
2025-09-12 18:09:22 +02:00
Jan
f885704dc9 BACKEND:
- Moved calculation to worker threads.
- Added pre-calculation checks so that a calculation isn't started with insufficient data.
- Missing lead time for D2D added.
- Grouping for reporting works now as expected.
FRONTEND:
- Reporting implemented. Material and Valid period added to report.
- Fixed Workflow for the calculation user. Archive/Delete functionality is added.
- Missing lead time for D2D added.
2025-09-11 20:29:45 +02:00
Jan
849d31bc8e FRONTEND: Add stacked bar chart integration with error bars using Chart.js in ReportChart; include Chart.js dependency and enhance ReportRoute with updated icons 2025-09-09 21:52:39 +02:00
Jan
abed6b82e5 FRONTEND/BACKEND: Enriching informations in report. Added route widget to destinations 2025-09-09 19:10:05 +02:00
Jan
ca3c15ecd2 BACKEND: several bugfixing in calculation and reporting
FRONTEND: Start implementing reporting
2025-09-07 23:48:51 +02:00
Jan
c47531a335 FRONTEND/BACKEND: fixing bugs in schema contstraints. Fixing performance issues in mass calculation (frontend) 2025-09-05 19:38:07 +02:00
Jan
32feeb06a0 BACKEND: Introduce AzureMapsController for managing Azure Maps configuration with Entra ID integration; add endpoints for configuration retrieval, health checks, and role-based permissions; enhance country dataset in alldata.sql with names for better clarity. 2025-09-04 16:43:02 +02:00
Jan
45742d731d FRONTEND/BACKEND: Refactor destination editing and input components; add startCalculation method to PremiseEditStore, implement Properties and BulkUpload components, introduce case-insensitive deserialization for DimensionUnit and WeightUnit, improve UI handling and modularity across input fields, and revise DTO and repository logic for improved state handling and validation. 2025-09-03 15:59:02 +02:00
Jan
f5c4e1159f Working on MassEdit and SingleEdit 2025-08-28 21:55:02 +02:00
Jan
0061d01b75 FRONTEND/BACKEND: Add batch destination editing with DestinationSetDTO support; refactor DestinationService to handle bulk updates and enhance validation; update PremiseEditStore with batch processing methods (finishMassEdit, cancelMassEdit); implement conditional UI behavior for bulk edit mode in CalculationMassEdit.vue and DestinationListView.vue; introduce new DTOs (DestinationSetDTO, DestinationSetListItemDTO) and repository methods (getByPremiseIdsAndNodeIds). 2025-08-26 16:20:34 +02:00
Jan
1690d869d6 FRONTEND/BACKEND: Refactor and extend error-handling capabilities; update ErrorStore with new actions like clearErrors and expanded error fields (traceCombined); rework PremiseEditStore for enhanced destination and premise state management; introduce mass destination editing functionality; modify UI components (CalculationListItem.vue) for improved styling and base64-encoded route handling; backend adjustments include adding support for externalMappingId in NodeTransformer and RouteNodeRepository. 2025-08-26 09:54:37 +02:00
Jan
6eaf3d4abc FRONTEND/BACKEND: Add comprehensive error capturing and reporting functionality; implement ErrorController and FrontendErrorDTO for backend handling; introduce useErrorStore in frontend for collecting and transmitting errors; integrate error handling into PremiseEditStore, MaterialStore, and other related components; enhance DestinationListView and destination editing workflow with new modal behavior and user-defined cost handling. 2025-08-21 14:10:35 +02:00
Jan
b13f5db876 FRONTEND: Add destination editing functionality with modal support; integrate RadioOption and TabContainer reusable UI components; extend PremiseEditStore with destination management methods (addDestination, deleteDestination, editDestination); refactor components (DestinationItem, DestinationListView) to support editing and deletion events. Fix minor console log issues in PriceEdit. 2025-08-18 21:01:59 +02:00
Jan
918ea98d1c FRONTEND: Downgrade vite to 7.0.6 and rollup dependency to 4.40.0; remove unused logger import from PremiseEditStore. 2025-08-17 14:01:13 +02:00
Jan
155ad018c9 FRONTEND/BACKEND: Add support for setting material details (hsCode, tariffRate, materialCost, etc.) in PremiseTransformer and PremiseDetailDTO; implement useMaterialStore and useCustomsStore for querying and managing state; enhance supplier and material editing views with new UI components (SelectNode), a map placeholder, and modal dialogs; update schema for premise_route_node and enhance repository queries; upgrade dependencies (vite, rollup) and introduce initial Google Maps integration. 2025-08-17 12:41:18 +02:00
Jan
7e9a437f8f FRONTEND/BACKEND: Refactored PremiseController to use @RequestParam for premises fetching; enhanced destination and supplier editing views with new UI components (DestinationItem, MaterialEdit, PackagingEdit) and styling updates; introduced PremiseEditStore for managing premise state. Added handling for unmatched routes with fallback redirection. 2025-08-12 21:05:04 +02:00
Jan
e7bcab5ae3 FRONTEND: Add new UI components (ModalDialog, Dropdown, InputField) and store modules (AssistantStore, NodeStore) with comprehensive state management; refactor styles for consistency across buttons, input fields, and search components; enhance calculation and node creation workflows. 2025-08-12 15:20:34 +02:00
Jan
7280a1208f BACKEND: Enhance search and query functionalities in repositories and controllers. Refactor string decoding in PremiseController, add support for multiple part number filters in MaterialRepository, and improve query flexibility in NodeRepository and UserNodeRepository. Adjust NodeController and DTO validations. 2025-08-12 15:20:11 +02:00
Jan
dd56a539ef FRONTEND: Enhance calculation search functionality with debounce support, filter toggles, and new input handling; add AutoSuggestSearchBar component and Spinner UI for improved UX; update checkbox styles and introduce PremiseStore for state management.
BACKEND: Added filter to allow CORS. To be removed for prod
2025-08-07 11:20:43 +02:00
Jan
3486ef6123 add frontend 2025-08-03 21:08:22 +02:00
Jan
7da9374578 add frontend 2025-08-03 21:07:27 +02:00
Jan
a7029b67ed Bugfixing (3) 2025-08-03 21:06:10 +02:00
Jan
7cc4d894f5 Bugfixing (2) 2025-07-31 21:24:51 +02:00
Jan
259b46ec84 Bugfixing 2025-07-28 13:36:04 +02:00
Jan
eab6ed2e1b Refactor packaging and material update logic in ChangeSupplierService and PremiseCreationService, optimize repository method calls, and simplify PremiseControllerIntegrationTest by utilizing PremiseTestsHelper. 2025-07-25 12:39:08 +02:00
Jan
c03cbfb774 Add Python script for converting container rates from Excel to SQL
Bugfixing Destination Creation
2025-07-22 23:16:28 +02:00
Jan
ad30f00492 Add Excel-to-SQL conversion scripts for nodes and node predecessor chains
Introduce Python scripts to convert node and node predecessor data from Excel files into SQL INSERT statements. Includes support for ISO code mappings, geo-position parsing, node type determination, and automated chain creation. Also added sample Excel files (`nodes.xlsx`, `pre_nodes.xlsx`) for testing and reference.
2025-07-19 22:11:58 +02:00
Jan
a9275a012a Added Premise Controller Integration Tests 2025-07-19 22:10:24 +02:00