How harish112k5/billx_v2 works
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: server.js Express server · db.js MySQL pool · App.jsx App router · axios.js API client
Components 23
Web application
- App router
frontend/src/App.jsx - Project views
frontend/src/pages/ProjectDashboard.jsx - BOQ view
frontend/src/pages/BOQPage.jsx - RA Bill views
frontend/src/pages/CreateRABill.jsx - Finance views
frontend/src/pages/BudgetPage.jsx - Analytics views
frontend/src/pages/AnalyticsPage.jsx - Import view
frontend/src/pages/ImportPage.jsx - API client
frontend/src/api/axios.js
API and access
- Express server
backend/server.js - Authentication
backend/routes/auth.js - Project routes
backend/routes/projects.js - RA Bill routes
backend/routes/raBills.js - Analytics routes
backend/routes/analytics.js - Budget routes
backend/routes/budget.js
Bill import
- Import routes
backend/routes/import.js - Workbook parser
backend/services/excelParser.js - Import pipeline
backend/services/importPipeline.js
Project insights
- Analytics engine
backend/services/analyticsEngine.js - Schedule engine
backend/services/scheduleEngine.js - Budget engine
backend/services/budgetEngine.js
Persistence
- MySQL pool
backend/db.js - MySQL database
Other components
- Project user
Connections 31
- Project user → App router: uses
frontend/src/App.jsx - App router → Project views: routes to
frontend/src/App.jsx - App router → BOQ view: routes to
frontend/src/App.jsx - App router → RA Bill views: routes to
frontend/src/App.jsx - App router → Import view: routes to
frontend/src/App.jsx - Project views → API client: requests data
frontend/src/pages/ProjectDashboard.jsx - BOQ view → API client: requests data
frontend/src/pages/BOQPage.jsx - RA Bill views → API client: requests data
frontend/src/pages/CreateRABill.jsx - Import view → API client: uploads workbook
- API client → Express server: calls API
- Express server → Authentication: mounts
backend/server.js - Express server → Project routes: mounts
backend/server.js - Express server → RA Bill routes: mounts
backend/server.js - Express server → Analytics routes: mounts
backend/server.js - Express server → Budget routes: mounts
backend/server.js - Express server → Import routes: mounts
backend/server.js - Authentication → MySQL pool: queries
backend/routes/auth.js - Import routes → Import pipeline: runs import
backend/routes/import.js - Import routes → Workbook parser: parses preview
backend/routes/import.js - Import pipeline → Workbook parser: parses workbook
backend/services/importPipeline.js - Import pipeline → Schedule engine: updates schedules
backend/services/importPipeline.js - Import pipeline → Budget engine: updates budget
backend/services/importPipeline.js - Project routes → Analytics engine: gets dashboard
backend/routes/projects.js - Analytics routes → Analytics engine: gets analytics
backend/routes/analytics.js - Analytics engine → Schedule engine: gets timeline
backend/services/analyticsEngine.js - Budget routes → Budget engine: gets summary
backend/routes/budget.js - Import routes → MySQL pool: reads and writes
backend/routes/import.js - Analytics engine → MySQL pool: queries records
backend/services/analyticsEngine.js - Schedule engine → MySQL pool: queries records
backend/services/scheduleEngine.js - Budget engine → MySQL pool: queries records
backend/services/budgetEngine.js - MySQL pool → MySQL database: connects
backend/db.js