Codex

Enterprise production Solo full-stack engineer

JHCSC document management — faculty/staff submission portal, admin compliance review, and analytics after database refactoring.

Problem

University campuses still route faculty submissions through email, USB drives, and paper sign-offs. Codex (project-jhcsc-mis, with related svene-codex / aidrecabrera-codex repos) digitizes the document lifecycle: upload, track status, receive feedback, and give administrators compliance dashboards and bulk workflow tools.

Capabilities

Next.js 14+ App Router with TypeScript, shadcn/ui, and Tailwind
Supabase PostgreSQL with Auth, Storage, RLS, and local migration workflow
Feature areas: admin, dashboard, submissions (per repo tree)
Post-refactor architecture: analytics and workflow logic moved from PostgreSQL functions to application services
AnalyticsService (cached department compliance, submission trends) and WorkflowService (bulk approve, withdraw, submit on behalf)
Admin bootstrap/promote CLI scripts; Vercel deployment target

Layered architecture after DB refactor

MIS-Based File and Document Submission, Tracking, and Monitoring System for the
Faculty and Staff of JHCSC Dumingag Campus.

Screenshot placeholder — faculty submission status and admin compliance breakdown.