How jakubpechoucek-glitch/project_tracker works
Project Tracker is a React time-tracking application backed by an Express API and SQLite. PMs sign in, record and submit weekly time, while admins manage projects, assignments and users, review entries, and inspect reports and audit history; suggestions are shared across roles. The graph separates browser workflows, API handling, domain services, persistence, and scheduled reporting. The README documents the product capabilities and API; selected source excerpts show routing and service/repository calls, but not every feature’s implementation or browser-to-server request wiring.
Main entry points: App.jsx Role-based app · controllers Request handlers · repositories SQL repositories · routes API routes
Components 24
Web application
- Role-based app
client/src/App.jsx - Sign-in
client/src/pages/Login.jsx - Weekly timesheet
client/src/pages/pm/Timesheet.jsx - PM workspace
client/src/pages/pm - Admin workspace
client/src/pages/admin - Report views
client/src/pages/admin/reports - Suggestions
client/src/pages/shared/Suggestions.jsx - API client
client/src/services/api.js
API and access
- Express app
server/index.js - API routes
server/routes - Authentication
server/middleware/auth.middleware.js - Role checks
server/middleware/role.middleware.js - Request handlers
server/controllers
Domain services
- Sign-in service
server/services/auth.service.js - Entry workflow
server/services/entries.service.js - Assignments
server/services/assignments.service.js - User management
server/services/users.service.js
Persistence
- SQL repositories
server/repositories - SQLite database
db/db.js
Reporting and audit
- Report calculations
server/services/reports.service.js - Weekly email job
server/jobs/weeklyReport.js - Audit logging
server/utils/audit.js
Other components
- Project manager
- Administrator
Connections 31
- Project manager → Role-based app: uses
- Administrator → Role-based app: uses
- Role-based app → Sign-in: routes to
client/src/App.jsx - Role-based app → Weekly timesheet: routes to
client/src/App.jsx - Role-based app → PM workspace: routes to
client/src/App.jsx - Role-based app → Admin workspace: routes to
client/src/App.jsx - Role-based app → Report views: routes to
client/src/App.jsx - Role-based app → Suggestions: routes to
client/src/App.jsx - Sign-in → API client: uses
client/src/pages/Login.jsx - Weekly timesheet → API client: uses
client/src/pages/pm/Timesheet.jsx - API client → Express app: requests API
- Express app → API routes: mounts
server/index.js - API routes → Request handlers: dispatches
server/routes/entries.routes.js - API routes → Authentication: authenticates
server/routes/entries.routes.js - API routes → Role checks: checks role
server/routes/entries.routes.js - Request handlers → Entry workflow: calls
server/controllers/entries.controller.js - Request handlers → Report calculations: calls
server/controllers/reports.controller.js - Request handlers → Sign-in service: calls
- Request handlers → Assignments: calls
server/controllers/assignments.controller.js - Request handlers → User management: calls
server/controllers/users.controller.js - Entry workflow → SQL repositories: reads and writes
server/services/entries.service.js - Assignments → SQL repositories: reads and writes
server/services/assignments.service.js - User management → SQL repositories: reads and writes
server/services/users.service.js - Sign-in service → SQL repositories: reads and updates
server/services/auth.service.js - Report calculations → SQLite database: queries
server/services/reports.service.js - SQL repositories → SQLite database: queries
server/repositories/assignments.repository.js - Entry workflow → Audit logging: logs changes
server/services/entries.service.js - Sign-in service → Audit logging: logs events
server/services/auth.service.js - Assignments → Audit logging: logs changes
server/services/assignments.service.js - Express app → Weekly email job: registers
server/index.js - Weekly email job → SQLite database: queries
server/jobs/weeklyReport.js