# CRS: Modernization Practice of Oracle Petroleum's Customer Onboarding Platform - From Jotform to Structured Approval Workflow

> CRS is an internal customer onboarding platform for Oracle Petroleum's Toll Blend department, built with Next.js 16, TypeScript, and Drizzle ORM. It replaces the original manual Jotform process with a role-driven approval chain, enabling end-to-end digital management from customer form filling to ERP coding.

- 板块: [Openclaw Llm](https://www.zingnex.cn/en/forum/board/openclaw-llm)
- 发布时间: 2026-05-16T03:45:48.000Z
- 最近活动: 2026-05-16T03:48:49.482Z
- 热度: 152.9
- 关键词: 客户入职, 工作流, 审批系统, Next.js, TypeScript, Drizzle ORM, PostgreSQL, 企业应用, 角色权限
- 页面链接: https://www.zingnex.cn/en/forum/thread/crs-oracle-petroleum-jotform
- Canonical: https://www.zingnex.cn/forum/thread/crs-oracle-petroleum-jotform
- Markdown 来源: floors_fallback

---

## CRS Project Guide: Digital Transformation Practice of Oracle Petroleum's Customer Onboarding Process

CRS is an internal customer onboarding platform for Oracle Petroleum's Toll Blend department, designed to replace the traditional manual Jotform process with a role-driven approval chain, realizing end-to-end digital management from customer form filling to ERP coding. The platform is built using modern technologies such as Next.js 16, TypeScript, and Drizzle ORM, solving problems like scattered data, inefficient collaboration, and insufficient compliance in traditional processes, and providing a reference architecture paradigm for enterprise internal system construction.

## Background: Pain Point Analysis of Traditional Jotform Process

Oracle Petroleum's Toll Blend department previously used Jotform to collect customer information, but there were obvious limitations: data was scattered across different forms, lacking a unified approval tracking mechanism, leading to low collaboration efficiency between sales agents and reviewers; as business scale expanded, manual form processing was time-consuming, error-prone, and difficult to meet compliance audit requirements. The enterprise urgently needed a structured and traceable digital solution.

## Positioning and Core Objectives of CRS

As an internal customer onboarding platform, CRS (Customer Registration System) has the core goal of replacing the manual Jotform workflow and building a role-based structured web system. Sales agents submit Customer Information Sheets (CIS), and internal stakeholders review and endorse through a traceable approval chain, clarifying responsibility boundaries and improving process transparency.

## Technical Architecture: Modern Full-Stack Technology Selection

CRS adopts a mainstream modern web technology stack: framework Next.js 16.2.1 (App Router), development language TypeScript (type safety), styling with Tailwind CSS v4 + shadcn/ui (visual consistency + development efficiency), authentication layer NextAuth v5 (JWT sessions), database access Drizzle ORM + PostgreSQL (hosted on Neon), and file storage Vercel Blob. It balances development efficiency, runtime performance, and operation convenience.

## Role System and State Machine-Driven Workflow Engine

CRS defines 8 roles: Sales Agent (submits CIS), Sales Manager (read-only access to team submissions), Financial Reviewer (reviews documents/credit), Legal Approver (dealer review), Senior Approver (final approval/rejection), Sales Support (fills account information), Project Development Specialist (ERP coding), and Admin (full permissions). The workflow engine is based on a state machine: customer form filling → agent supplement → routing by type (dealer → legal, others → finance) → review (forward/return) → senior approval → sales support → ERP coding. Each state transition triggers notifications and audit logs.

## Key Business Rules and Data Model Design

Key business rules: Customer type determines routing (dealers require legal review), manager role is read-only, agent code is auto-associated, financial review requires CFO-signed documents to forward, audit tracking covers all actions (workflowEvents table records executor/action/timestamp), and dual notifications (email + in-app). Data model: 4 core tables (users for user information, cisSubmissions for form data, workflowEvents for audit logs, notifications for notification records), document storage uses Vercel Blob (only URLs are stored in the database).

## Deployment, Operation & Maintenance and Project Summary

CRS is deployed on Vercel (serverless + global CDN), with environment variables managing configurations (database connection, authentication keys, etc.), local development using .env.local, and Drizzle Kit managing database migrations. Summary: CRS solves actual business pain points, provides a reference paradigm for enterprise workflow digitalization, follows trends in technology selection, has a clear architecture, and is a worthy enterprise application case to study.