# ni9999/business_word_excel_automation architecture

> Architecture diagram of the GitHub repository ni9999/business_word_excel_automation, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-10-02). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/ni9999/business_word_excel_automation
- Repository: https://github.com/ni9999/business_word_excel_automation

## Overview

GFG Wash Lab Report Automator is a browser-based suite for finding wash-report data, reviewing it, and downloading generated reports. Its main workflow searches by report number, presents detected entries for review and editing, then requests DOCX and PDF output; pasted Excel rows can also drive a wash-specific PDF workflow. Separate QC lookup and style-to-SharePoint tools are documented by the client screens and API calls. The excerpts do not show all server handlers or conversion internals, so those connections are limited to visible API calls and documented behavior.

Main entry points: [`client/src/MainApp.jsx`](https://github.com/ni9999/business_word_excel_automation/blob/main/client/src/MainApp.jsx) (Report workspace), [`client/src/App.jsx`](https://github.com/ni9999/business_word_excel_automation/blob/main/client/src/App.jsx) (App router), [`server.js`](https://github.com/ni9999/business_word_excel_automation/blob/main/server.js) (Folder link lookup), [`client/src/QcApp.jsx`](https://github.com/ni9999/business_word_excel_automation/blob/main/client/src/QcApp.jsx) (QC lookup screen)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_report["Wash Reporting"]
  node_router["App router<br/>[App.jsx]"]
  node_mainui["Report workspace<br/>[MainApp.jsx]"]
  node_reportreview["Report review<br/>[MainApp.jsx]"]
end

subgraph group_backend["Report Services"]
  node_reportsearch["Report search<br/>[server.js]"]
  node_excelcache[("Excel cache<br/>[server.js]")]
  node_pasteparse["Pasted-row parser<br/>[server.js]"]
  node_docxgen["DOCX generation<br/>[server.js]"]
  node_pdfgen["PDF generation<br/>[server.js]"]
end

subgraph group_lookup["Lookup Tools"]
  node_sharepointlink["Folder link lookup<br/>[server.js]"]
  node_qcui["QC lookup screen<br/>[QcApp.jsx]"]
  node_qcservice["QC info service<br/>[server.js]"]
  node_linkui["Style link screen<br/>[LinkApp.jsx]"]
end

subgraph group_washpdf["Wash PDF"]
  node_washui["Wash PDF screen<br/>[WashApp.jsx]"]
  node_washrenderer["Wash PDF renderer<br/>[server.js]"]
  node_washtemplate["Image template<br/>[server.js]"]
end

node_user(("Report user"))
node_sharepoint["SharePoint"]

node_user -->|"opens app"| node_router
node_router -->|"routes default"| node_mainui
node_router -->|"routes /qc"| node_qcui
node_router -->|"routes /link"| node_linkui
node_router -->|"routes /wash"| node_washui
node_mainui -->|"requests search"| node_reportsearch
node_reportsearch -->|"searches rows"| node_excelcache
node_mainui -->|"submits pasted rows"| node_pasteparse
node_mainui -->|"requests folder link"| node_sharepointlink
node_mainui -->|"requests DOCX"| node_docxgen
node_mainui -->|"requests PDF"| node_pdfgen
node_qcui -->|"requests file info"| node_qcservice
node_qcui -->|"opens returned link"| node_sharepointlink
node_linkui -->|"requests style link"| node_sharepointlink
node_washui -->|"parses pasted rows"| node_pasteparse
node_washui -->|"requests wash PDF"| node_washrenderer
node_washrenderer -->|"uses template"| node_washtemplate
node_sharepointlink -.->|"resolves folders"| node_sharepoint

click node_router "https://github.com/ni9999/business_word_excel_automation/blob/main/client/src/App.jsx"
click node_mainui "https://github.com/ni9999/business_word_excel_automation/blob/main/client/src/MainApp.jsx"
click node_reportsearch "https://github.com/ni9999/business_word_excel_automation/blob/main/server.js"
click node_excelcache "https://github.com/ni9999/business_word_excel_automation/blob/main/server.js"
click node_pasteparse "https://github.com/ni9999/business_word_excel_automation/blob/main/server.js"
click node_reportreview "https://github.com/ni9999/business_word_excel_automation/blob/main/client/src/MainApp.jsx"
click node_docxgen "https://github.com/ni9999/business_word_excel_automation/blob/main/server.js"
click node_pdfgen "https://github.com/ni9999/business_word_excel_automation/blob/main/server.js"
click node_sharepointlink "https://github.com/ni9999/business_word_excel_automation/blob/main/server.js"
click node_qcui "https://github.com/ni9999/business_word_excel_automation/blob/main/client/src/QcApp.jsx"
click node_qcservice "https://github.com/ni9999/business_word_excel_automation/blob/main/server.js"
click node_linkui "https://github.com/ni9999/business_word_excel_automation/blob/main/client/src/LinkApp.jsx"
click node_washui "https://github.com/ni9999/business_word_excel_automation/blob/main/client/src/WashApp.jsx"
click node_washrenderer "https://github.com/ni9999/business_word_excel_automation/blob/main/server.js"
click node_washtemplate "https://github.com/ni9999/business_word_excel_automation/blob/main/server.js"

classDef toneNeutral fill:#f8fafc,stroke:#334155,stroke-width:1.5px,color:#0f172a
classDef toneBlue fill:#dbeafe,stroke:#2563eb,stroke-width:1.5px,color:#172554
classDef toneAmber fill:#fef3c7,stroke:#d97706,stroke-width:1.5px,color:#78350f
classDef toneMint fill:#dcfce7,stroke:#16a34a,stroke-width:1.5px,color:#14532d
classDef toneRose fill:#ffe4e6,stroke:#e11d48,stroke-width:1.5px,color:#881337
classDef toneIndigo fill:#e0e7ff,stroke:#4f46e5,stroke-width:1.5px,color:#312e81
classDef toneTeal fill:#ccfbf1,stroke:#0f766e,stroke-width:1.5px,color:#134e4a
class node_router,node_mainui,node_reportreview,node_user toneBlue
class node_reportsearch,node_excelcache,node_pasteparse,node_docxgen,node_pdfgen toneAmber
class node_sharepointlink,node_qcui,node_qcservice,node_linkui toneMint
class node_washui,node_washrenderer,node_washtemplate toneRose
class node_sharepoint toneIndigo
```

## Components

### Wash Reporting

- [App router](https://github.com/ni9999/business_word_excel_automation/blob/main/client/src/App.jsx): `client/src/App.jsx`
- [Report workspace](https://github.com/ni9999/business_word_excel_automation/blob/main/client/src/MainApp.jsx): `client/src/MainApp.jsx`
- [Report review](https://github.com/ni9999/business_word_excel_automation/blob/main/client/src/MainApp.jsx): `client/src/MainApp.jsx`

### Report Services

- [Report search](https://github.com/ni9999/business_word_excel_automation/blob/main/server.js): `server.js`
- [Excel cache](https://github.com/ni9999/business_word_excel_automation/blob/main/server.js): `server.js`
- [Pasted-row parser](https://github.com/ni9999/business_word_excel_automation/blob/main/server.js): `server.js`
- [DOCX generation](https://github.com/ni9999/business_word_excel_automation/blob/main/server.js): `server.js`
- [PDF generation](https://github.com/ni9999/business_word_excel_automation/blob/main/server.js): `server.js`

### Lookup Tools

- [Folder link lookup](https://github.com/ni9999/business_word_excel_automation/blob/main/server.js): `server.js`
- [QC lookup screen](https://github.com/ni9999/business_word_excel_automation/blob/main/client/src/QcApp.jsx): `client/src/QcApp.jsx`
- [QC info service](https://github.com/ni9999/business_word_excel_automation/blob/main/server.js): `server.js`
- [Style link screen](https://github.com/ni9999/business_word_excel_automation/blob/main/client/src/LinkApp.jsx): `client/src/LinkApp.jsx`

### Wash PDF

- [Wash PDF screen](https://github.com/ni9999/business_word_excel_automation/blob/main/client/src/WashApp.jsx): `client/src/WashApp.jsx`
- [Wash PDF renderer](https://github.com/ni9999/business_word_excel_automation/blob/main/server.js): `server.js`
- [Image template](https://github.com/ni9999/business_word_excel_automation/blob/main/server.js): `server.js`

### Other components

- **Report user**
- **SharePoint**

## Connections

- Report user → App router: opens app
- App router → Report workspace: routes default (evidence: `client/src/App.jsx`)
- App router → QC lookup screen: routes /qc (evidence: `client/src/App.jsx`)
- App router → Style link screen: routes /link (evidence: `client/src/App.jsx`)
- App router → Wash PDF screen: routes /wash (evidence: `client/src/App.jsx`)
- Report workspace → Report search: requests search (evidence: `client/src/MainApp.jsx`)
- Report search → Excel cache: searches rows (evidence: `server.js`)
- Report workspace → Pasted-row parser: submits pasted rows (evidence: `client/src/MainApp.jsx`)
- Report workspace → Folder link lookup: requests folder link (evidence: `client/src/MainApp.jsx`)
- Report workspace → DOCX generation: requests DOCX (evidence: `client/src/MainApp.jsx`)
- Report workspace → PDF generation: requests PDF (evidence: `client/src/MainApp.jsx`)
- QC lookup screen → QC info service: requests file info (evidence: `client/src/QcApp.jsx`)
- QC lookup screen → Folder link lookup: opens returned link (evidence: `client/src/QcApp.jsx`)
- Style link screen → Folder link lookup: requests style link (evidence: `client/src/LinkApp.jsx`)
- Wash PDF screen → Pasted-row parser: parses pasted rows (evidence: `client/src/WashApp.jsx`)
- Wash PDF screen → Wash PDF renderer: requests wash PDF (evidence: `client/src/WashApp.jsx`)
- Wash PDF renderer → Image template: uses template (evidence: `server.js`)
- Folder link lookup → SharePoint: resolves folders
