AhmadHassan-BTed/Ledgerify

flowchart TD
    subgraph ClientLayer["Client Layer (Browser Runtime)"]
        A["User Upload (.xlsx / .csv)"] --> B["IFileParser (SheetJS Engine)"]
        B --> C["Resilient Normalizer & Header Mapper"]
        C --> D["Domain Entities (NormalizedOrder[])"]
        D --> E["IStorageService (IndexedDB Cache)"]
    end

    subgraph ServiceLayer["Domain & Service Layer (IoC Container)"]
        E --> F["Dependency Injection Container"]
        F --> G1["ExecutiveService"]
        F --> G2["FinanceService"]
        F --> G3["InventoryService"]
        F --> G4["OperationsService"]
        F --> G5["MarketingService"]
        F --> G6["CreativeService"]
        F --> G7["AdminDataQualityService"]
        F --> G8["CompareService"]
    end

    subgraph PresentationLayer["Presentation Layer (Obsidian UI)"]
        G1 & G2 & G3 & G4 & G5 & G6 & G7 & G8 --> H["React Context Providers"]
        H --> I["Departmental View Controllers"]
        I --> J["Interactive Visualizations & Drill-Downs"]
    end

flowchart LR
    A["Raw Workbook Buffer"] --> B["Workbook Sheet Discovery"]
    B --> C["Header Fuzzy Normalization"]
    C --> D["Value Sanitization & Type Coercion"]
    D --> E["Compound Bundle Splitting"]
    E --> F["Flag & Anomaly Tagging"]
    F --> G["NormalizedOrder Schema"]

    subgraph NormalizationLogic["Transformation Rules"]
        C -.- C1["Case & whitespace agnostic regex matching"]
        D -.- D1["Excel serial date to ISO UTC conversion"]
        E -.- E1["Extracts individual bottles from Discovery/Trio sets"]
        F -.- F1["Identifies $0 test orders, missing emails, spike quantities"]
    end

sequenceDiagram
    autonumber
    actor User as Operator
    participant UI as Dashboard UI
    participant Parser as File Parser (SheetJS)
    participant Normalizer as Schema Normalizer
    participant Storage as IndexedDB Storage
    participant DI as IoC Container
    participant Services as Domain Services

    User->>UI: Selects .xlsx / .csv file
    UI->>Parser: Passes ArrayBuffer
    Parser->>Normalizer: Streams raw sheet records
    Normalizer->>Normalizer: Resolves dynamic column mappings
    Normalizer->>Normalizer: Extracts category yields & anomalies
    Normalizer-->>Storage: Persists NormalizedDataset
    Normalizer-->>DI: Injects Active Dataset State
    DI->>Services: Trigger reactive metric calculation
    Services-->>UI: Dispatches aggregated view models
    UI-->>User: Renders Obsidian dashboards with 0ms server latency

classDiagram
    class IFileParser {
        <<interface>>
        +parse(file: File): Promise~NormalizedOrder[]~
    }

    class IStorageService {
        <<interface>>
        +saveDataset(dataset: Dataset): Promise~void~
        +getDatasets(): Promise~Dataset[]~
        +deleteDataset(id: string): Promise~void~
    }

    class ServiceContainer {
        +financeService: FinanceService
        +executiveService: ExecutiveService
        +inventoryService: InventoryService
        +operationsService: OperationsService
        +marketingService: MarketingService
        +creativeService: CreativeService
        +adminService: AdminDataQualityService
        +compareService: CompareService
    }

    class DataProvider {
        +activeDataset: Dataset
        +filteredOrders: NormalizedOrder[]
        +setFilter(filter: FilterState): void
    }

    ServiceContainer --> FinanceService
    ServiceContainer --> ExecutiveService
    ServiceContainer --> InventoryService
    ServiceContainer --> OperationsService
    ServiceContainer --> MarketingService
    DataProvider ..> ServiceContainer : Consumes via Context
    IFileParser <|.. XlsxParser
    IStorageService <|.. IndexedDbStorage

flowchart TD
    subgraph GitRepository["Git Repository"]
        A["Push to main branch"] --> B["GitHub Actions Triggered"]
    end

    subgraph CIWorkflow["CI / CD Pipeline"]
        B --> C["Setup Node.js Runtime"]
        C --> D["npm ci (Deterministic Dependency Tree)"]
        D --> E["tsc --noEmit (Type Integrity Validation)"]
        E --> F["vite build (Production Minification)"]
        F --> G["Upload Artifact (dist/)"]
    end

    subgraph HostingInfrastructure["Edge Hosting"]
        G --> H["Deploy to GitHub Pages Environment"]
        H --> I["Public Release (HTTPS / Global CDN)"]
    end