← Back to projects
Internal System 2026 In progress
Muebles JYN Control
Before this system, operations depended on spreadsheets and scattered records. The platform brings project tracking, payments, documents, and calendar management into one place to improve operational control and reduce manual work.
Challenge
The administrative workflow depended on spreadsheets and manual controls, with data-loss risk and poor visibility into project progress and payment tracking.
Solution
Built an internal platform with a visual dashboard, status filters, progress logs, project-level payment tracking, and Google Drive integration. Added role-based access and action auditing to improve control and traceability.
Results
- Centralized project, client, and delivery control instead of disconnected spreadsheets
- Better administrative visibility over project status and payment flow
- Lower information-loss risk and less time spent on manual searches
- Per-project financial summary with clearer payment tracking
- Stable functional base for real day-to-day operations
Technical details
Stack and technologies
- - Next.js (App Router)
- - React 19
- - Tailwind CSS
- - Prisma
- - PostgreSQL
- - Better Auth
- - Google Drive API OAuth2
How it is organized
- - src/app: routes and screen composition
- - src/features: domain modules (projects/customers/events/auth/audit)
- - src/lib: shared infrastructure (auth, prisma, drive)
- - src/shared/server-actions: authorization and result wrappers
Key modules
- - Projects: CRUD, payments, progress logs, files, financial dashboard
- - Customers: create, update, archive, tax data
- - Calendar: project deliveries plus manual events
- - Auth/Admin: login, ADMIN/OPERATIVO roles, user management
- - Audit: traceability for critical actions
Risks / technical debt
- - Possible partial states if Drive or DB fails mid-operation
- - Some actions return limited error feedback
- - No visible active scheduler for EventReminder
- - Missing deeper e2e/integration test coverage
Need to build or improve a system?
I help turn the need into a clear technical direction and a clean execution plan.