SPSTARPLAST — Manufacturing ERP

Interface

• Next.js 15 (App Router), React 19, TypeScript and Tailwind v4.

Data and integration

• Database — Supabase PostgreSQL, with functions and triggers for document numbering, order totals, mold shot counts, and production-plan sequencing and rollover.
• Sign-in — Supabase Auth with per-user access control.
• Files — documents and assets in Supabase Storage.
• Activity feed — 4,500+ system events, filtered by each user's access and refreshed every 30 seconds.
• LOGO ERP sync — customer, supplier and stock cards come in from LOGO, and accepted quotes go back as sales orders.

System flow

+--------------------------+      +--------------------+
| Next.js 15 (App Router)  |<---->| LOGO ERP           |
|  - UI modules            |      |  cards and         |
|  - API routes            |      |  statements in,    |
+-------------+------------+      |  sales orders out  |
              |                   +--------------------+
              v
+--------------------------+      +------------------+
| Supabase PostgreSQL      |<---->| Supabase Storage |
|  - Auth                  |      |  assets/files    |
|  - triggers/functions    |      +------------------+
|  - activity events       |
+-------------+------------+
              |
              v
        Monitoring and logs

Who sees what

• Per-user access — each user is granted any of 14 functional areas, applied to routes, navigation and the activity feed.
• Role-based permissions — sales, production and admin teams each get the areas they work in.

Every action tracked

• Audit trail — who changed what, and when.
• Error logging — issues are logged with their context.

Performance

• Caching — data is cached on the client to avoid repeat server calls.
• Large lists — screens that display thousands of records.
• Validation — data is checked before it is saved.

Business rules in the database

document numbers   -> numbering functions
order totals       -> totals triggers
mold shot counts   -> update_mold_shot_count
production plan    -> sequencing, plus rollover
                      of unfinished jobs