How urosptrvc/levelup-project-tracking works
Main System Components
a) Frontend Layer:
• Next.js Client Components
• Authentication UI (Login/Register)
• Shipment Management Interface
• File Upload Interface
• Theme System (Dark/Light)
b) Backend Layer:
• Next.js API Routes
• Authentication System (NextAuth)
• File Processing Service
• Data Mapping Service
c) Database Layer:
• MySQL Database (via Prisma ORM)
• Shipment Data Storage
• User Management
Component Relationships
[Client Layer] <-> [API Layer] <-> [Database Layer]
• ↑ ↑
[Auth Provider] <-> [Auth API]
Detailed Component Breakdown
Frontend Components:
[Pages]
• Auth Pages (Login/Register)
• Shipment List
• Shipment Details
• Upload Interface
[Components]
• Navigation
• Data Tables
• Search
• UI Components
Backend Services:
[API Routes]
• Auth Service
• Login
• Register
• Shipment Service
• Upload
• Retrieve
• Delete
Data Flow:
[XLSX Files] -> [Upload API] -> [Data Mapping] -> [Database]
• ↓
• [Formatted Response]
Key Technical Elements to Highlight
• NextAuth Integration with Prisma
• Role-based Access Control (User/Admin)
• File Processing Pipeline
• Data Mapping System for Different Carriers
Integration Points
Clear integration between:
• NextAuth and Prisma
• TanStack Query for data fetching
• XLSX.js for file processing
• Tailwind CSS and Shadcn/ui components
• The role-based access control system
• The file processing pipeline for different courier services
• The data transformation and mapping logic
• The client-side state management with TanStack Query
This system design should emphasize the application's focus on secure file processing, data transformation, and role-based access control while maintaining a clean and intuitive user interface.