← All projects
Operations / Workflow PlatformDeployed · In production

Mercury Embroidery

An internal design-task tracker for Mercury Embroidery. The manager assigns work to 10–15 designers, measures actual active time across every revision round, reviews submissions and exports operational reports without losing the original design files.

  • Java 23
  • Spring Boot 3.4
  • Spring Security
  • Spring Data JPA
  • PostgreSQL 16
  • Flyway
  • JWT
  • STOMP WebSocket
  • Apache POI
  • React 19
  • TypeScript
  • Vite
  • TanStack Query
  • Zustand
  • Tailwind CSS
  • Radix UI
  • Recharts
  • Local or S3/R2 storage
01The Problem

Task assignment, revision history, designer timing and submitted artwork need to live in one reliable workflow. Manual tracking cannot show the true time spent per designer, client and period or safely preserve every version of the work.

02The Approach

A React SPA backed by a secure Spring Boot modular monolith. REST remains the source of truth, STOMP WebSocket events trigger live refetches, PostgreSQL stores the complete workflow history, and local or S3-compatible storage retains submitted files.

03Engineering Challenge

Keeping timing correct through concurrent task opens, approved breaks, manager pauses, submissions and multiple revision rounds — while ensuring each designer can have only one active round and can access only their own work.

04The Solution

Server-time calculations merge every pause window before subtracting it from elapsed time. Database constraints enforce one active round, submission is the only event that stops the timer, and task totals are recalculated as the sum of every completed round.

05Key Features
  • Manager and designer authentication flows
  • Task assignment for 10–15 designers
  • Active-time tracking with no countdown or artificial time limit
  • Revision rounds with complete history
  • Manager approval and revision requests
  • Break requests and manager pause/resume
  • Employee Work and My Work galleries
  • Permanent file retention
  • File preview and authorized download
  • Streamed ZIP exports organized by designer and work type
  • Dashboards and Excel reports
  • Realtime update notifications
  • Append-only audit history
06Result

Deployed and in production use at Mercury Embroidery, where it runs the company's production control: assigning, timing, reviewing and reporting embroidery design work, with permanent file history, role-secured work galleries, ZIP exports and Excel reporting.

Role — Developer — product architecture, backend, frontend, security, testing and deployment design.

Next projectNexus CRM →