Rogo Portal
An admissions portal that keeps student applications, documents and payments together.
Used by For education-consultancy staff managing student applications.
An application is more than a form. It has documents to collect, universities to track, review steps to follow and payments to reconcile. Rogo Portal organizes that work around a student file.
The Next.js interface connects to tRPC procedures with Zod validation. Drizzle handles the PostgreSQL data model for files, documents, checklists, timelines and payments.
- Context
- Company project, Techsfera
- API
- tRPC procedures with Zod validation
- Data
- PostgreSQL and Drizzle
- Workflow
- Student files, documents, checklists and timeline entries
- Payments
- SQL calculation of paid amounts and outstanding dues
Keeping the workflow connected
Student files link to universities, documents and supporting admissions records. tRPC connects the screens to server procedures, and Zod checks the incoming data before those procedures run.
Knowing what is still due
Student-file queries calculate outstanding dues in SQL. A CTE totals paid credits and subtracts them from the required payment, so staff can retrieve file details and payment totals together.
Following an application’s progress
Timeline entries record application progress, while checklists track individual requirements. Authentication, administrative checks and resource permissions control access to the underlying operations.