# PDKBSBU Web Final Checkpoint

Exported at: 2026-05-18T12:41:09.689Z

## Status

Aplikasi sudah siap sebagai AppSheet-compatible web preview dengan local draft workflow, operational DB readiness, dan handover runbook. Belum ada operasi tulis DB yang dijalankan.

## Modules & Routes

### Core Dashboard — READY
- Routes: /, /dashboard
- Summary: Landing/dashboard KPI, shortcuts, latest WO, material/report summary.

### Work Orders — READY
- Routes: /work-orders, /work-orders/[id], /work-orders/map
- Summary: Rekap, detail, map, filters, status badge, material usage, SP2B/report relation.

### Draft WO — READY_LOCAL
- Routes: /work-orders/new, /work-orders/drafts, /work-orders/drafts/[id]/edit, /work-orders/drafts/audit
- Summary: Create/edit/delete/ready/exported/submitted lifecycle, local cache persistence, audit, export.

### Materials — READY
- Routes: /materials/stock, /materials/usage, /materials/additions
- Summary: Stock, usage, additions, filters, WO relation, stock minus.

### Documents — READY
- Routes: /sp2b, /sp2b/[id], /reports, /reports/[id]
- Summary: SP2B/report list + detail + relation to WO/maps.

### Users/Profile — READY
- Routes: /users, /profile
- Summary: User management preview, role badges, access simulation, profile access summary.

### Charts — READY
- Routes: /charts/[dimension]
- Summary: Interactive drilldown for status, regu, lokasi, bagian, kategori, kelompok, jenis.

### Database Readiness — READY_READONLY
- Routes: /database/readiness, /database/schema, /database/counts
- Summary: DB connection, schema review, count comparison, required tables including work_order_drafts.

### Seed Operations — READY_READONLY
- Routes: /database/seed-readiness, /database/seed-history, /api/database/seed-history/export
- Summary: Seed readiness, local seed history log, JSON/CSV export.

### Draft DB Readiness — READY_READONLY
- Routes: /database/draft-readiness, /api/database/draft-readiness/export
- Summary: Local draft readiness mapping to PostgreSQL candidate rows, export NEEDS_FIX/READY_FOR_DB.

### DB Command Center — READY_READONLY
- Routes: /database/command-center, /api/database/command-center/export
- Summary: Operational DB dashboard and JSON snapshot export.

### DB Handover — READY_READONLY
- Routes: /database/handover, /api/database/handover/export
- Summary: Go-live handover runbook and Markdown export.

### Scale-Up — READY_READONLY
- Routes: /database/scale-up
- Summary: Scale-up strategy and roadmap.

### VPS Readiness — READY_READONLY
- Routes: /vps-readiness, /api/vps-readiness/export
- Summary: Deployment readiness checklist, minimum VPS spec, safe command sequence, and hard stop rules.

## Reusable Components

- MetricCard
- DataTable
- EmptyState
- CommandCard
- FieldCard
- SectionCard
- WorkOrderStatusBadge
- DraftStatusBadge
- RoleBadge

## Safety Rules

- npm run db:generate belum dijalankan untuk perubahan terbaru work_order_drafts.
- npm run db:migrate tidak boleh dijalankan sebelum DATABASE_URL benar dan Boss approve.
- npm run db:seed:cache -- --execute tidak boleh dijalankan sebelum dry-run aman dan Boss approve.
- Submit draft DB hanya untuk draft READY_FOR_DB / Siap Final / Exported.
- Gunakan /database/command-center dan /database/handover sebelum operasi tulis DB.

## Validation

- npm run typecheck: passed at latest checkpoint
- npm run build: passed at latest checkpoint

## Next DB Go-Live Sequence

1. Open /vps-readiness and export VPS readiness Markdown.
2. Verify DATABASE_URL.
3. Open /database/command-center.
4. Open /database/handover and export Markdown.
5. If Boss approves schema migration, run npm run db:generate.
6. Review generated SQL.
7. If safe and Boss approves, run npm run db:migrate.
8. Run seed dry-runs.
9. If safe and Boss approves, execute seed.
10. Compare counts.
11. Submit ready drafts per item.