# harish112k5/billx_v2 architecture

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

- Interactive diagram: https://gitdiagram.com/harish112k5/billx_v2
- Repository: https://github.com/harish112k5/billx_v2

## Overview

BillX V2 is a construction project management platform for BOQ, RA Bills, budgets, expenses, and project intelligence. Users enter through the authenticated React app, select a project, review or manage project records, and can upload an RA Bill workbook for preview and import. The backend routes requests into database-backed services; analytics and schedule engines supply project and time-based measures. The README documents the import workflow and API surface; some page and route implementations were not sampled, so their finer interactions are not asserted.

Main entry points: [`backend/server.js`](https://github.com/harish112k5/billx_v2/blob/main/backend/server.js) (Express server), [`backend/db.js`](https://github.com/harish112k5/billx_v2/blob/main/backend/db.js) (MySQL pool), [`frontend/src/App.jsx`](https://github.com/harish112k5/billx_v2/blob/main/frontend/src/App.jsx) (App router), [`frontend/src/api/axios.js`](https://github.com/harish112k5/billx_v2/blob/main/frontend/src/api/axios.js) (API client)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_web["Web application"]
  node_app["App router<br/>[App.jsx]"]
  node_projectviews["Project views"]
  node_boqview["BOQ view<br/>[BOQPage.jsx]"]
  node_rabillview["RA Bill views<br/>[CreateRABill.jsx]"]
  node_financeviews["Finance views<br/>[BudgetPage.jsx]"]
  node_analyticsview["Analytics views<br/>[AnalyticsPage.jsx]"]
  node_importview["Import view<br/>[ImportPage.jsx]"]
  node_api_client["API client<br/>[axios.js]"]
end

subgraph group_api["API and access"]
  node_server["Express server<br/>[server.js]"]
  node_authroutes["Authentication<br/>[auth.js]"]
  node_projectroutes["Project routes<br/>[projects.js]"]
  node_billroutes["RA Bill routes<br/>[raBills.js]"]
  node_analyticsroutes["Analytics routes<br/>[analytics.js]"]
  node_budgetroutes["Budget routes<br/>[budget.js]"]
end

subgraph group_import["Bill import"]
  node_importroutes["Import routes<br/>[import.js]"]
  node_excelparser["Workbook parser<br/>[excelParser.js]"]
  node_importpipeline["Import pipeline<br/>[importPipeline.js]"]
end

subgraph group_insights["Project insights"]
  node_analyticsengine["Analytics engine<br/>[analyticsEngine.js]"]
  node_scheduleengine["Schedule engine<br/>[scheduleEngine.js]"]
  node_budgetengine["Budget engine<br/>[budgetEngine.js]"]
end

subgraph group_storage["Persistence"]
  node_db["MySQL pool<br/>[db.js]"]
  node_mysql[("MySQL database")]
end

node_user(("Project user"))

node_user -->|"uses"| node_app
node_app -->|"routes to"| node_projectviews
node_app -->|"routes to"| node_boqview
node_app -->|"routes to"| node_rabillview
node_app -->|"routes to"| node_importview
node_projectviews -->|"requests data"| node_api_client
node_boqview -->|"requests data"| node_api_client
node_rabillview -->|"requests data"| node_api_client
node_importview -.->|"uploads workbook"| node_api_client
node_api_client -.->|"calls API"| node_server
node_server -->|"mounts"| node_authroutes
node_server -->|"mounts"| node_projectroutes
node_server -->|"mounts"| node_billroutes
node_server -->|"mounts"| node_analyticsroutes
node_server -->|"mounts"| node_budgetroutes
node_server -->|"mounts"| node_importroutes
node_authroutes -->|"queries"| node_db
node_importroutes -->|"runs import"| node_importpipeline
node_importroutes -->|"parses preview"| node_excelparser
node_importpipeline -->|"parses workbook"| node_excelparser
node_importpipeline -->|"updates schedules"| node_scheduleengine
node_importpipeline -->|"updates budget"| node_budgetengine
node_projectroutes -->|"gets dashboard"| node_analyticsengine
node_analyticsroutes -->|"gets analytics"| node_analyticsengine
node_analyticsengine -->|"gets timeline"| node_scheduleengine
node_budgetroutes -->|"gets summary"| node_budgetengine
node_importroutes -->|"reads and writes"| node_db
node_analyticsengine -->|"queries records"| node_db
node_scheduleengine -->|"queries records"| node_db
node_budgetengine -->|"queries records"| node_db
node_db -->|"connects"| node_mysql

click node_app "https://github.com/harish112k5/billx_v2/blob/main/frontend/src/App.jsx"
click node_projectviews "https://github.com/harish112k5/billx_v2/blob/main/frontend/src/pages/ProjectDashboard.jsx"
click node_boqview "https://github.com/harish112k5/billx_v2/blob/main/frontend/src/pages/BOQPage.jsx"
click node_rabillview "https://github.com/harish112k5/billx_v2/blob/main/frontend/src/pages/CreateRABill.jsx"
click node_financeviews "https://github.com/harish112k5/billx_v2/blob/main/frontend/src/pages/BudgetPage.jsx"
click node_analyticsview "https://github.com/harish112k5/billx_v2/blob/main/frontend/src/pages/AnalyticsPage.jsx"
click node_importview "https://github.com/harish112k5/billx_v2/blob/main/frontend/src/pages/ImportPage.jsx"
click node_api_client "https://github.com/harish112k5/billx_v2/blob/main/frontend/src/api/axios.js"
click node_server "https://github.com/harish112k5/billx_v2/blob/main/backend/server.js"
click node_authroutes "https://github.com/harish112k5/billx_v2/blob/main/backend/routes/auth.js"
click node_projectroutes "https://github.com/harish112k5/billx_v2/blob/main/backend/routes/projects.js"
click node_billroutes "https://github.com/harish112k5/billx_v2/blob/main/backend/routes/raBills.js"
click node_analyticsroutes "https://github.com/harish112k5/billx_v2/blob/main/backend/routes/analytics.js"
click node_budgetroutes "https://github.com/harish112k5/billx_v2/blob/main/backend/routes/budget.js"
click node_importroutes "https://github.com/harish112k5/billx_v2/blob/main/backend/routes/import.js"
click node_excelparser "https://github.com/harish112k5/billx_v2/blob/main/backend/services/excelParser.js"
click node_importpipeline "https://github.com/harish112k5/billx_v2/blob/main/backend/services/importPipeline.js"
click node_analyticsengine "https://github.com/harish112k5/billx_v2/blob/main/backend/services/analyticsEngine.js"
click node_scheduleengine "https://github.com/harish112k5/billx_v2/blob/main/backend/services/scheduleEngine.js"
click node_budgetengine "https://github.com/harish112k5/billx_v2/blob/main/backend/services/budgetEngine.js"
click node_db "https://github.com/harish112k5/billx_v2/blob/main/backend/db.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_app,node_projectviews,node_boqview,node_rabillview,node_financeviews,node_analyticsview,node_importview,node_api_client,node_user toneBlue
class node_server,node_authroutes,node_projectroutes,node_billroutes,node_analyticsroutes,node_budgetroutes toneAmber
class node_importroutes,node_excelparser,node_importpipeline toneMint
class node_analyticsengine,node_scheduleengine,node_budgetengine toneRose
class node_db,node_mysql toneIndigo
```

## Components

### Web application

- [App router](https://github.com/harish112k5/billx_v2/blob/main/frontend/src/App.jsx): `frontend/src/App.jsx`
- [Project views](https://github.com/harish112k5/billx_v2/blob/main/frontend/src/pages/ProjectDashboard.jsx): `frontend/src/pages/ProjectDashboard.jsx`
- [BOQ view](https://github.com/harish112k5/billx_v2/blob/main/frontend/src/pages/BOQPage.jsx): `frontend/src/pages/BOQPage.jsx`
- [RA Bill views](https://github.com/harish112k5/billx_v2/blob/main/frontend/src/pages/CreateRABill.jsx): `frontend/src/pages/CreateRABill.jsx`
- [Finance views](https://github.com/harish112k5/billx_v2/blob/main/frontend/src/pages/BudgetPage.jsx): `frontend/src/pages/BudgetPage.jsx`
- [Analytics views](https://github.com/harish112k5/billx_v2/blob/main/frontend/src/pages/AnalyticsPage.jsx): `frontend/src/pages/AnalyticsPage.jsx`
- [Import view](https://github.com/harish112k5/billx_v2/blob/main/frontend/src/pages/ImportPage.jsx): `frontend/src/pages/ImportPage.jsx`
- [API client](https://github.com/harish112k5/billx_v2/blob/main/frontend/src/api/axios.js): `frontend/src/api/axios.js`

### API and access

- [Express server](https://github.com/harish112k5/billx_v2/blob/main/backend/server.js): `backend/server.js`
- [Authentication](https://github.com/harish112k5/billx_v2/blob/main/backend/routes/auth.js): `backend/routes/auth.js`
- [Project routes](https://github.com/harish112k5/billx_v2/blob/main/backend/routes/projects.js): `backend/routes/projects.js`
- [RA Bill routes](https://github.com/harish112k5/billx_v2/blob/main/backend/routes/raBills.js): `backend/routes/raBills.js`
- [Analytics routes](https://github.com/harish112k5/billx_v2/blob/main/backend/routes/analytics.js): `backend/routes/analytics.js`
- [Budget routes](https://github.com/harish112k5/billx_v2/blob/main/backend/routes/budget.js): `backend/routes/budget.js`

### Bill import

- [Import routes](https://github.com/harish112k5/billx_v2/blob/main/backend/routes/import.js): `backend/routes/import.js`
- [Workbook parser](https://github.com/harish112k5/billx_v2/blob/main/backend/services/excelParser.js): `backend/services/excelParser.js`
- [Import pipeline](https://github.com/harish112k5/billx_v2/blob/main/backend/services/importPipeline.js): `backend/services/importPipeline.js`

### Project insights

- [Analytics engine](https://github.com/harish112k5/billx_v2/blob/main/backend/services/analyticsEngine.js): `backend/services/analyticsEngine.js`
- [Schedule engine](https://github.com/harish112k5/billx_v2/blob/main/backend/services/scheduleEngine.js): `backend/services/scheduleEngine.js`
- [Budget engine](https://github.com/harish112k5/billx_v2/blob/main/backend/services/budgetEngine.js): `backend/services/budgetEngine.js`

### Persistence

- [MySQL pool](https://github.com/harish112k5/billx_v2/blob/main/backend/db.js): `backend/db.js`
- **MySQL database**

### Other components

- **Project user**

## Connections

- Project user → App router: uses (evidence: `frontend/src/App.jsx`)
- App router → Project views: routes to (evidence: `frontend/src/App.jsx`)
- App router → BOQ view: routes to (evidence: `frontend/src/App.jsx`)
- App router → RA Bill views: routes to (evidence: `frontend/src/App.jsx`)
- App router → Import view: routes to (evidence: `frontend/src/App.jsx`)
- Project views → API client: requests data (evidence: `frontend/src/pages/ProjectDashboard.jsx`)
- BOQ view → API client: requests data (evidence: `frontend/src/pages/BOQPage.jsx`)
- RA Bill views → API client: requests data (evidence: `frontend/src/pages/CreateRABill.jsx`)
- Import view → API client: uploads workbook
- API client → Express server: calls API
- Express server → Authentication: mounts (evidence: `backend/server.js`)
- Express server → Project routes: mounts (evidence: `backend/server.js`)
- Express server → RA Bill routes: mounts (evidence: `backend/server.js`)
- Express server → Analytics routes: mounts (evidence: `backend/server.js`)
- Express server → Budget routes: mounts (evidence: `backend/server.js`)
- Express server → Import routes: mounts (evidence: `backend/server.js`)
- Authentication → MySQL pool: queries (evidence: `backend/routes/auth.js`)
- Import routes → Import pipeline: runs import (evidence: `backend/routes/import.js`)
- Import routes → Workbook parser: parses preview (evidence: `backend/routes/import.js`)
- Import pipeline → Workbook parser: parses workbook (evidence: `backend/services/importPipeline.js`)
- Import pipeline → Schedule engine: updates schedules (evidence: `backend/services/importPipeline.js`)
- Import pipeline → Budget engine: updates budget (evidence: `backend/services/importPipeline.js`)
- Project routes → Analytics engine: gets dashboard (evidence: `backend/routes/projects.js`)
- Analytics routes → Analytics engine: gets analytics (evidence: `backend/routes/analytics.js`)
- Analytics engine → Schedule engine: gets timeline (evidence: `backend/services/analyticsEngine.js`)
- Budget routes → Budget engine: gets summary (evidence: `backend/routes/budget.js`)
- Import routes → MySQL pool: reads and writes (evidence: `backend/routes/import.js`)
- Analytics engine → MySQL pool: queries records (evidence: `backend/services/analyticsEngine.js`)
- Schedule engine → MySQL pool: queries records (evidence: `backend/services/scheduleEngine.js`)
- Budget engine → MySQL pool: queries records (evidence: `backend/services/budgetEngine.js`)
- MySQL pool → MySQL database: connects (evidence: `backend/db.js`)
