32 Commits

Author SHA1 Message Date
admin dcd845d337 Add audit CSV central source option 2026-06-11 08:57:18 +02:00
admin 43250a4abc Add purchasing full load cache 2026-06-05 12:43:12 +02:00
admin 146c7481e1 Load purchasing dashboard live EKKO data 2026-06-05 08:58:20 +02:00
admin bb5e5150b9 Add purchasing data sources and 3D simulation 2026-06-05 07:45:30 +02:00
admin 6f094fcac6 Add configurable menu structure and purchasing area 2026-06-05 07:03:08 +02:00
admin d853f53df8 Add published HR KPI workflow fixes 2026-05-26 13:33:09 +02:00
admin 5f3c3497b8 Separate admin access from finance lock 2026-05-26 13:33:09 +02:00
admin 9471c5c310 Add admin access and landing dashboard 2026-05-26 13:33:09 +02:00
admin d66074b740 Add configurable finance rules and dashboard basis indicators 2026-05-20 13:10:33 +02:00
admin 5e305ae396 Add DE finance rules and IIS path base 2026-05-20 12:21:06 +02:00
admin 9c544afa20 Protect finance cockpit with login 2026-05-19 09:40:15 +02:00
admin 83e556e89e Refine cockpit navigation and HR access 2026-05-15 11:14:46 +02:00
admin 1cd0ad998f Refactor HR KPI cockpit architecture 2026-05-13 07:30:43 +02:00
admin 20be752adc Add HR KPI cockpit 2026-05-13 07:10:13 +02:00
admin dc3fd77c86 Consolidate mapping and finance configuration 2026-05-07 15:20:54 +02:00
admin 15dec06f31 Add finance reconciliation probe 2026-05-04 09:32:50 +02:00
admin 4a1561d85f Add AD auth and B1 currency fields 2026-04-29 11:07:35 +02:00
admin 3ac03a4782 Enhance management cockpit analysis 2026-04-29 07:00:29 +02:00
Claude 82ac7df0ec DataSourceAdapter-Pattern + SiteExportService schlanker + Page-Services Scoped
- IDataSourceAdapter mit 3 Implementierungen (HANA, SAP_GATEWAY, MANUAL_EXCEL)
  und DataSourceAdapterResolver ersetzen das if/else auf ConnectionKind.
- SiteExportService von 338 auf 187 Zeilen reduziert: Pipeline
  Resolve -> Fetch -> Transform -> Excel -> Central -> SharePoint.
- Page-Services auf Scoped (per Blazor-Circuit); Orchestrator bleibt Singleton
  fuer geteilten Export-Status.
2026-04-17 12:11:35 +00:00
admin 2a56ba53ba umfangreiches refactoring 2026-04-17 13:56:41 +02:00
admin 0d3bd47f7a englisch 2026-04-17 07:08:04 +02:00
admin a25e5900c7 Regelsteuerung grafisch und per C# Templates 2026-04-16 08:47:13 +02:00
admin 264e64bbf5 zentraler export 2026-04-15 14:47:32 +02:00
admin 7891dfb3dd sammelxport 2026-04-15 11:37:47 +02:00
admin 90133cd0e2 diverse Aenderungen 2026-04-15 11:18:26 +02:00
admin 59e195af71 import exxport settings, join over sap hana tables 2026-04-14 11:34:43 +02:00
admin 36a22202bf SAP GWQ 2026-04-14 10:54:52 +02:00
admin cf20bd94d0 RefactoringDI 2026-04-13 14:37:21 +02:00
admin ec827a4ce8 Add connection diagnostics and visual field transformation mapping 2026-04-13 11:52:05 +02:00
Claude efcf7b180c Add SSL, MDC database, and custom HANA connection parameters
Fixes 'error while parsing protocol' HanaException by supporting
SSL/TLS encryption, Multi-Tenant Database Container (MDC) database
name, and arbitrary additional connection parameters.

- HanaServer model: added DatabaseName, UseSsl, ValidateCertificate,
  AdditionalParams fields + BuildConnectionString() helper
- HanaQueryService: accepts HanaServer directly, uses
  BuildConnectionString() for full parameter support
- AppDbContext: added EnsureSchema() method that uses PRAGMA table_info
  + ALTER TABLE ADD COLUMN to add the new fields to existing SQLite
  databases without losing data (EnsureCreated does not update schema)
- Program.cs: calls EnsureSchema on startup before seeding
- Standorte.razor: server dialog now exposes DatabaseName, UseSsl,
  ValidateCertificate, AdditionalParams with helper texts; test
  connection uses new signature

https://claude.ai/code/session_012heAXNMbbyxqYf2S2HrKLj
2026-04-13 08:52:10 +00:00
Claude 8524631508 Convert TrafagSalesExporter from console app to Blazor Server app with MudBlazor UI
- Replaced console app with .NET 8 Blazor Server architecture
- Added EF Core SQLite database (trafag_exporter.db) with auto-seed data
- Models: HanaServer, Site, SharePointConfig, ExportSettings, ExportLog, SalesRecord
- Services: HanaQueryService (with configurable dateFilter), ExcelExportService,
  SharePointUploadService, ExportOrchestrationService (with live status events),
  TimerBackgroundService (scheduled daily export)
- MudBlazor UI pages: Dashboard (export status + manual trigger), Standorte
  (HANA server + site CRUD), Settings (SharePoint + timer config), Logs (filtered view)
- SAP HANA queries unchanged (INV + CRN with exact SAP B1 table joins)
- SharePoint upload via Microsoft Graph with app registration auth

https://claude.ai/code/session_012heAXNMbbyxqYf2S2HrKLj
2026-04-09 14:00:44 +00:00
admin 673bba7298 Add Trafag SAP HANA to Excel SharePoint exporter console app 2026-04-09 15:47:55 +02:00