SYS_ID: sampletrackWEB
SampleTrack Web
Plantation Laboratory Sample Tracking System
// Technologies:
HonoReactDrizzle ORMMySQLBullMQPuppeteerZod
PROJECT SCREENSHOTS (16:9 HD)
[1 / 3]
Overview
Laboratory sample lifecycle management system for testing plant tissue (LSU) and fertilizer samples across multiple locations and suppliers.
// Role:
Fullstack Developer & System Analyst
// Key Contributions:
- Developed the platform from scratch as the full developer for the entire laboratory tracking system, collaborating with the manager and lead staff.
- Designed clean, responsive, and accessible web UI/UX layouts while delivering iterative updates based on user requests.
- Designed the end-to-end laboratory sample lifecycle tracking system for plant tissue (LSU) and fertilizer testing.
- Developed Hono REST APIs with Zod validation, multi-tenant company data scoping, and dynamic QR code/barcode generation engines.
- Engineered BullMQ background queues for high-volume data import/export, automated Excel/PDF reporting (ExcelJS & Puppeteer), and Firebase FCM push notifications.
Key Features
- 1End-to-End Field-to-Lab Sample Lifecycle Tracking
- 2Sample Barcode / QR Code Printing & Labeling
- 3Laboratory Analysis Result & Testing Management
- 4Fertilizer & Plant Tissue (LSU) Quality Reporting
- 5Multi-Location & Multi-Supplier Sample Status Monitoring
System Architecture
// DEEP_TECH_SPECS & INTEGRATION
- >Dynamic QR Code & Barcode Engine (qrcode.react)
- >Hono REST API Engine with Zod Validation Pipeline
- >Drizzle ORM supporting PostgreSQL & MySQL Database
- >BullMQ Job Queue for High-Volume Data Import & Export
- >Automated Excel & PDF Report Export (ExcelJS & Puppeteer)
- >Push Notification Integration via Firebase Cloud Messaging (FCM)
- >Multi-Tenant Company & Plantation Unit Data Scoping System
- >React Query Frontend with TanStack Router Type-Safe Architecture
Screenshots & Visuals

VIEW 1

VIEW 2

VIEW 3