Web Integrated Quotation System
Integrated pricing system automation with real-time Lark Base data synchronization.
Web Integrated Quotation System
The previous quotation process was manual and spread across multiple platforms, leading to the risk of price inconsistencies, difficulty tracking technical product revisions (FAS/FMP), and unsynchronized data between the sales team and the central database.
I built a SPA (Single Page Application) architecture using Inertia.js to connect Laravel and React. I designed a complex database schema (>40 tables) to handle highly detailed product specifications, and implemented a Service Layer and Background Jobs (Queues) to ensure data synchronization to Lark Base worked without hindering application performance.
Real-time Lark Synchronization

01Real-time Lark Synchronization

Using a custom Service Layer to automatically push and pull data between MySQL and Lark Base databases.

Dynamic Multi-Business Quotation

02Dynamic Multi-Business Quotation

Smart forms that dynamically adjust input based on Chemical, Equipment, or Site Visit categories.

Automated Revision & History Tracking

03Automated Revision & History Tracking

An automated logging system that records every change in price and technical specifications for a transparent audit trail.

Successfully integrated 3 business lines (Chemical, Equipment, Site Visit) into a single platform, automated PDF/Excel report generation, and ensured 100% data accuracy between the web application and Lark Base through an automatic synchronization system.
I learned to manage state management on very complex nested forms and delved into optimizing third-party API synchronization to maintain data integrity at enterprise scale.