VJEGY_SYS

Category: B2B SaaS / Workflow Management / ERP Status: Release Candidate (RC) / Closed Beta Testing

Project Overview

VJEGY_sys is a cloud-based, multi-tenant service management system designed specifically to digitize workflows for service centers and repair shops (e.g., watchmakers, GSM repair, electronics labs). Unlike off-the-shelf “boxed” software, VJEGY_sys breaks away from rigid data structures.

The core philosophy is industry-independent flexibility: using a built-in Dynamic Field Engine, users can define exactly what data points (e.g., carat, serial number, password, condition) they wish to record. This allows the software to adapt to any repair activity without requiring code modification.

Key Features & Modules

  • Dynamic Field Definitions (Dynamic Schema): The heart of the system. Administrators can create custom forms and data fields via a drag-and-drop interface. Data is stored in JSONB structures but remains queryable like relational data.
  • Kiosk Mode & Customer Portal: A dedicated interface for in-store tablets allowing customers to perform Self Check-in and track their repair status independently.
  • End-to-End Workflow: Covers the entire lifecycle: Intake -> Diagnostics -> Parts Ordering -> Repair -> Quality Assurance (QA) -> Payment (Stripe integration) -> Handover.
  • Subcontracting Management: Manages work outsourced to external partners, automatically generating delivery notes and tracking external repair statuses.
  • Intelligent Inventory Management: Tracks material usage, performs automatic deduction during repairs, and forecasts stock shortages.
  • Business Intelligence (BI) Dashboard: Real-time analytics on revenue, technician workload, and Revenue Forecasts.

Technical Specifications

The project is built on modern, scalable web technologies with a focus on data security and performance.

Frontend Framework: Next.js 14 (App Router)
  • Server Side Rendering (SSR): Optimized for fast loading times and SEO.
  • Type-safe Development: Built entirely on TypeScript.
  • UI Library: Tailwind CSS + Shadcn/ui for a modern, clean aesthetic.

Backend & Database: Supabase (PostgreSQL)
  • Multi-tenancy: Architecture secured by Row Level Security (RLS) policies, guaranteeing strict isolation of client data.
  • JSONB Storage: Leveraging PostgreSQL JSONB data types for dynamic field storage.
  • Real-time Subscriptions: For instant UI updates upon status changes.

Infrastructure & DevOps
  • Vercel: Hosting for the frontend (Edge Network).
  • GitHub Actions: Automated CI/CD pipelines.
  • Stripe: Integration for subscription handling and service fee processing.

 

Challenges & Solutions

The biggest technical challenge was reconciling searchability with a dynamic data structure. Since users can create arbitrary fields, traditional SQL queries were insufficient.

Solution: We applied PostgreSQL GIN (Generalized Inverted Index) indexing on JSONB columns and wrote custom RPC (Remote Procedure Call) functions in the database layer. This allows sub-millisecond searching across thousands of “unique” parameters (e.g., a watch model number or a laptop CPU type) as if they were traditional database columns.

Summary

VJEGY_sys is more than just an administration interface; it is a digital framework that lifts the organizational burden from service businesses. The project successfully combines the robustness of Enterprise ERP systems with the fluid user experience of modern SaaS applications.