How alipppyy/sipandu works
SIPANDU is a web system for RW administration, resident self-service, and public information. The main workflow is staff or residents using a portal to access administrative and community-service features, with API routes enforcing roles and operating on PostgreSQL through Prisma. Major branches cover resident/family records, dues and payments, activities, letters, announcements, and WhatsApp reminders. The README documents these capabilities; sampled route and library excerpts show API-to-storage, authorization, audit, and messaging behavior. UI-to-route wiring is not established by the available excerpts, so those links are omitted.
Main entry points: prisma.ts PostgreSQL via Prisma · wa.ts WhatsApp service · bills/route.ts Bills and dues · residents/route.ts Resident records
Components 25
Portals
- Public portal
src/app/page.tsx - Bill lookup
src/components/public/bill-lookup.tsx - Resident portal
src/app/(warga)/warga/page.tsx - Staff dashboard
src/app/(app)/dashboard/page.tsx
Administration
- Resident records
src/app/api/residents/route.ts - Family records
src/app/api/families/route.ts - RT management
src/app/api/rt/route.ts - User management
src/app/api/users/route.ts - Statistics
src/app/api/stats/route.ts
Community Services
- Bills and dues
src/app/api/bills/route.ts - Payments
src/app/api/payments/route.ts - Payment receipts
src/app/kwitansi/[id]/page.tsx - Activities
src/app/api/activities/route.ts - Letters
src/app/api/letters/route.ts - Announcements
src/app/api/announcements/route.ts - WhatsApp operations
src/app/api/wa/send/route.ts
Runtime Services
- Auth and roles
src/lib/auth.ts - API handling
src/lib/api.ts - Audit logging
src/lib/audit.ts - Reminder scheduler
src/lib/scheduler.ts - WhatsApp service
src/lib/wa.ts - PostgreSQL via Prisma
src/lib/prisma.ts
Other components
- Staff
- Residents
- WhatsApp gateway
Connections 33
- Staff → Staff dashboard: manage services
README.md - Residents → Resident portal: view personal services
README.md - Residents → Public portal: view public information
README.md - Public portal → Bill lookup: check bills
README.md - Resident records → Auth and roles: checks access
src/app/api/residents/route.ts - Resident records → API handling: wraps handlers
src/app/api/residents/route.ts - Resident records → Audit logging: records changes
src/app/api/residents/route.ts - Resident records → PostgreSQL via Prisma: reads and writes
src/app/api/residents/route.ts - Bills and dues → Auth and roles: checks access
src/app/api/bills/route.ts - Bills and dues → API handling: wraps handlers
src/app/api/bills/route.ts - Bills and dues → Audit logging: records changes
src/app/api/bills/route.ts - Bills and dues → PostgreSQL via Prisma: reads and writes
src/app/api/bills/route.ts - Activities → Auth and roles: checks access
src/app/api/activities/route.ts - Activities → API handling: wraps handlers
src/app/api/activities/route.ts - Activities → Audit logging: records changes
src/app/api/activities/route.ts - Activities → PostgreSQL via Prisma: reads and writes
src/app/api/activities/route.ts - Statistics → WhatsApp service: gets message stats
src/app/api/stats/route.ts - Statistics → PostgreSQL via Prisma: queries metrics
src/app/api/stats/route.ts - WhatsApp operations → WhatsApp service: sends messages
src/app/api/wa/send/route.ts - WhatsApp operations → Auth and roles: checks access
src/app/api/wa/send/route.ts - WhatsApp operations → PostgreSQL via Prisma: uses stored data
src/app/api/wa/send/route.ts - Family records → PostgreSQL via Prisma: reads and writes
src/app/api/families/route.ts - RT management → PostgreSQL via Prisma: reads and writes
src/app/api/rt/route.ts - User management → PostgreSQL via Prisma: reads and writes
src/app/api/users/route.ts - Payments → PostgreSQL via Prisma: reads and writes
src/app/api/payments/route.ts - Letters → PostgreSQL via Prisma: reads and writes
src/app/api/letters/route.ts - Announcements → PostgreSQL via Prisma: reads and writes
src/app/api/announcements/route.ts - Reminder scheduler → WhatsApp service: uses messaging
src/lib/scheduler.ts - Reminder scheduler → PostgreSQL via Prisma: queries reminders
src/lib/scheduler.ts - WhatsApp service → PostgreSQL via Prisma: stores message state
src/lib/wa.ts - WhatsApp service → WhatsApp gateway: delivers messages
README.md - Bills and dues → Payment receipts: supports receipts
README.md - WhatsApp service → WhatsApp gateway: supports gateway providers
README.md