gloria_app/CHANGELOG.md

Changelog - Gloria Platform

Todos los cambios notables del proyecto Gloria se documentarán en este archivo.

El formato se basa en Keep a Changelog y este proyecto adhiere a Semantic Versioning.

[0.4.0] - 2026-02-01 - Sprint 4: Pagos y Roles (100% Completado)

Added

Database Schema (100% Completado)

• New Models:
  • User - id, email, phone, name, role, password, timestamps
  • Payment - id, appointmentId, userId, amount, status, proofUrl, approvedBy, approvedAt, rejectedReason, rejectedAt, timestamps
  • PatientFile - id, patientId, type (ID_CARD, INSURANCE, OTHER), filename, url, expiresAt, timestamps
• Updated Patient model - Added files relation
  • Updated Appointment model - Added paymentId relation and payment relation

Migrations:

• Database schema updated with prisma db push
• Seed script created with test users (therapist, assistant, patient)

Files:

• prisma/schema.prisma - Updated schema
• prisma/seed.ts - Seed script with test users

RBAC & Authentication (100% Completado)

• src/middleware/auth.ts - Authentication middleware

  • withAuth function - Middleware for authentication
  • setAuthCookies - Set auth cookies
  • clearAuthCookies - Clear auth cookies
  • checkRouteAccess - Route configuration
  • Roles: PATIENT, ASSISTANT, THERAPIST

• src/lib/auth/rbac.ts - RBAC route configuration

Auth Endpoints (100% Completado)

• POST /api/auth/login - Login with phone/password
• POST /api/auth/logout - Logout
• GET /api/users/me - Get current user

Files:

• src/app/api/auth/login/route.ts
• src/app/api/auth/logout/route.ts
• src/app/api/users/me/route.ts

Dashboard Terapeuta (100% Completado)

GET /api/dashboard/patients/[phone]/notes - Patient clinical notes GET /api/dashboard/patients/[phone]/appointments - Patient appointments

Files:

• src/app/api/dashboard/patients/[phone]/notes/route.ts
• src/app/api/dashboard/patients/[phone]/appointments/route.ts
• src/app/dashboard/therapista/page.tsx - Dashboard Therapist UI

Dashboard Asistente (100% Completado)

• GET /api/dashboard/appointments - List upcoming appointments
• GET /api/dashboard/payments/pending - List pending payments
• POST /api/payments/validate - Approve/reject payments

Files:

• src/app/api/dashboard/appointments/route.ts
• src/app/api/dashboard/payments/pending/route.ts
• src/app/api/payments/validate/route.ts
• src/app/dashboard/assistant/page.tsx - Dashboard Assistant UI

Pages (100% Completado)

• Login page (/app/login/page.tsx) - Form with test credentials shown
• Servicios page (/app/servicios/page.tsx) - Detailed services list
• Privacidad page (/app/privacidad/page.tsx) - Privacy policy
• Cursos page (/app/cursos/page.tsx) - Courses and workshops

Files:

• src/app/login/page.tsx
• src/app/servicios/page.tsx
• src/app/privacidad/page.tsx
• src/app/cursos/page.tsx

Header & Footer Updates

Updated:

• src/components/layout/Header.tsx - Added /cursos link to navigation
• src/components/layout/Footer.tsx - Added /servicios, /cursos, /privacidad links to footer

Changed

Infrastructure

• prisma/schema.prisma - Added User, Payment, PatientFile models
• src/middleware/auth.ts - Created auth middleware with RBAC
• src/lib/auth/rbac.ts - Route configuration
• prisma/seed.ts - Seed script

Pages

• src/app/login/page.tsx - Created login page
• src/app/servicios/page.tsx - Created services page
• src/app/privacidad/page.tsx - Created privacy page
• src/app/cursos/page.tsx - Created courses page

Dashboard API

• src/app/api/dashboard/appointments/route.ts - Appointments API
• src/app/api/dashboard/payments/pending/route.ts - Pending payments API
• src/app/api/payments/validate/route.ts - Payment validation API
• src/app/api/dashboard/patients/[phone]/notes/route.ts - Patient notes API
• src/app/api/dashboard/patients/[phone]/appointments/route.ts - Patient appointments API

Dashboard Pages

• src/app/dashboard/assistant/page.tsx - Assistant dashboard
• src/app/dashboard/therapist/page.tsx - Therapist dashboard

Components

• src/components/layout/Hero.tsx - Fixed "Ver Servicios" button colors

Fixed

• Fixed TypeScript errors in auth middleware return types
• Fixed Hero button "Ver Servicios" text color on hover and active states

Tests

• ✅ TypeScript typecheck - No errors
• ✅ Prisma schema valid
• ✅ Database seed executed successfully

---

[Unreleased] - Sprint 5: Voz y Notas Clínicas

Planned

• Audio sandbox implementation
• Clinical notes with rich text editor
• WhatsApp audio integration
• Auto-deletion of audio (7 days)

---

[0.3.0] - 2026-02-01 - Sprint 3: Triaje de Crisis y Agenda

Added

Crisis Evaluation Engine (100% Completado)

• POST /api/crisis/evaluate - Crisis evaluation endpoint
• Keyword detection algorithm with scoring system
• Pre-defined responses per crisis level
• Rate limiting by IP and phone

Google Calendar Integration (100% Completado)

• POST /api/calendar/availability - Get availability
• POST /api/calendar/create-event - Create calendar event
• Distributed lock system with 15min TTL
• Google Calendar API integration (googleapis 140.0.0, google-auth-library 9.7.0)

Frontend Calendar (100% Completado)

• Updated Booking.tsx with Steps 4-6
• Calendar interactive UI with week navigation
• Date input with validation
• Time slots display with status
• Success confirmation screen

Files Created

• src/app/api/crisis/evaluate/route.ts - Crisis evaluation endpoint
• src/app/api/calendar/availability/route.ts - Availability API
• src/app/api/calendar/create-event/route.ts - Event creation API
• src/infrastructure/external/calendar.ts - Google Calendar client
• src/infrastructure/cache/redis.ts - Redis cache and locks
• Updated src/components/layout/Booking.tsx - Steps 4-6 added

Fixed

• Fixed TypeScript errors in crisis/evaluate and calendar routes
• Fixed duplicate score field in crisis evaluation response
• Fixed reminders structure in calendar event creation

---

[0.2.0] - 2026-02-01 - Sprint 2: Identidad Phone-First

Added

Patient Registration (100% Completado)

• POST /api/patients/register - Register new patient
• POST /api/patients/search - Search patient by phone

Landing Page Components (100% Completado)

• Header component with navigation
• Hero section with call-to-action
• About section with Gloria's biography
• Services grid with 3 services
• Testimonials carousel
• Contact form
• Footer with links

Files Created

• src/app/api/patients/register/route.ts
• src/app/api/patients/search/route.ts
• src/components/layout/Header.tsx
• src/components/layout/Hero.tsx
• src/components/layout/About.tsx
• src/components/layout/Services.tsx
• src/components/layout/Testimonials.tsx
• src/components/layout/Contact.tsx
• src/components/layout/Footer.tsx
• src/components/layout/Booking.tsx - Booking flow (Steps 1-3)

Fixed

• Fixed image paths in components
• Fixed TypeScript errors in patient registration
• Fixed Hero button "Ver Servicios" color behavior

---

[0.1.0] - 2026-02-01 - Sprint 1: Cimientos e Infraestructura

Added

Project Setup (100% Completado)

• Next.js 14 with App Router and TypeScript 5.x
• Tailwind CSS with Nano Banana palette
• Prisma ORM with SQLite
• Shadcn/ui components (Radix UI based)
• Framer Motion for animations

Infrastructure (100% Completado)

• Docker multi-stage setup (dev/prod)
• docker-compose configuration
• Non-root user configuration (UID 1001 - appuser)
• Security middleware (Helmet.js, CORS, CSP)

Database (100% Completado)

• Initial Prisma schema (Patient, Appointment, ClinicalNote, VoiceNote)
• Initial migration applied

Documentation (100% Completado)

• PRD.md - Product Requirements Document
• README.md - Project overview
• PROGRESS.md - Sprint tracking
• TASKS.md - Task list
• CHANGELOG.md - Changelog
• site_requirements.md - Style guide and specs
• AGENTS.md - Team roles and personas

Frontend Setup (100% Completado)

• Root layout with global styles
• Home page with all sections
• Component library (Button, Input, Card)

---

[0.5.0] - Próximamente - Sprint 3/4 Completación (Planificado)

Sprint 3 - Pendiente Implementación (10%)

Servicios de Email SMTP

To Add:

• nodemailer integration for SMTP email sending
• TLS transport configuration
• Connection pooling for efficiency
• HTML email templates
• Retry mechanism for failed emails

New Environment Variables:

SMTP_HOST=smtp.gmail.com
SMTP_PORT=587
SMTP_USER=your-email@gmail.com
SMTP_PASS=your-app-password
SMTP_FROM_NAME=Gloria Niño - Terapia
SMTP_FROM_EMAIL=no-reply@glorianino.com
ADMIN_EMAIL=admin@glorianino.com

New Files:

• src/infrastructure/email/smtp.ts - SMTP client
• src/lib/email/templates/ - Email templates directory

Funcionalidad de Reacomodar Citas

To Add:

• "Reacomodar" button in assistant and therapist dashboards
• Modal for selecting new date/time
• Availability check with Google Calendar API
• Update event in Google Calendar and SQLite
• Invalidate availability cache in Redis
• Send confirmation email to patient

New Files:

• src/app/api/calendar/reschedule/route.ts - API endpoint
• src/components/dashboard/RescheduleModal.tsx - Modal component
• src/lib/email/templates/reschedule-confirmation.ts - Email template

Modified Files:

• src/app/dashboard/asistente/page.tsx - Add "Reacomodar" button
• src/app/dashboard/terapeuta/page.tsx - Add "Reacomodar" button
• src/infrastructure/external/calendar.ts - Add updateEvent() function
• src/infrastructure/email/smtp.ts - Add sendRescheduleConfirmation() function

Job Programado - Email Diario 10 PM

To Add:

• Scheduled job with node-cron (0 22 * * *)
• Query next day's appointments from SQLite
• Send daily agenda email to admin (Gloria) only
• HTML table format with: Time, Patient name, Phone, Type, Payment status
• Logging of each execution

New Files:

• src/jobs/send-daily-agenda.ts - Scheduled job
• src/lib/email/templates/daily-agenda.ts - HTML template
• src/app/api/jobs/trigger-agenda/route.ts - Manual trigger for testing

Modified Files:

• src/app/layout.tsx - Initialize job on server start
• src/infrastructure/email/smtp.ts - Add sendDailyAgenda() function

---

Sprint 4 - Pendiente Implementación (15%)

Upload de Comprobantes con OCR (Híbrido)

To Add:

• Upload endpoint for payment proofs (PDF, JPG, PNG, max 5MB)
• Client-side preprocessing (grayscale, contrast, resize)
• Server-side OCR processing with tesseract.js
• PDF text extraction with pdf-parse
• Regex patterns to extract data from any bank:
  • Amount
  • Transfer date
  • Reference/Key
  • Sender name
  • Sender bank
• Unique filename generation: payment_{appointmentId}_{timestamp}.{ext}
• Store in /public/uploads/payments/
• Save extracted data in Payment model
• Return file URL and extracted data with confidence percentage

New Dependencies:

pnpm add tesseract.js sharp pdf-parse @types/nodemailer

New Files:

• src/app/api/payments/upload-proof/route.ts - Upload API endpoint
• src/lib/ocr/processor.ts - OCR processor (server)
• src/lib/ocr/templates.ts - Extraction templates
• src/components/dashboard/PaymentUpload.tsx - Upload component with drag & drop
• src/lib/utils/ocr-client.ts - Client-side preprocessing (optional)

Modified Files:

• prisma/schema.prisma - Add OCR-extracted fields to Payment model:

  model Payment {
    // ... existing fields
  
    // Datos extraídos por OCR
    extractedDate        DateTime?
    extractedAmount      Float?
    extractedReference   String? // Clave de transferencia
    extractedSenderName  String?
    extractedSenderBank  String?
  }
  

• src/app/dashboard/asistente/page.tsx - Integrate PaymentUpload component

Botón "Ver Más Servicios" en Landing

To Change:

• Update "Agenda tu Primera Sesión" button in Services component
• Change to "Ver Más Servicios" button
• Link to /servicios page
• Maintain Nano Banana design and animations

Modified Files:

• src/components/layout/Services.tsx - Line 136-144

Contacto Específico para Cursos

To Add:

• Contact form in /cursos page
• Fields: Name, Email, Course of interest (dropdown), Message
• Save record in SQLite
• Send notification email to admin
• Consistent Nano Banana design
• Smooth animations with Framer Motion
• Update "Más Información" buttons to open modal or scroll to contact section

New Files:

• src/app/api/contact/courses/route.ts - API endpoint for course inquiries
• src/lib/email/templates/course-inquiry.ts - HTML notification template

Modified Files:

• src/app/cursos/page.tsx - Add contact section at the end

---

Dependencies to Add

pnpm add nodemailer node-cron tesseract.js sharp pdf-parse @types/nodemailer

Package	Use	Sprint
nodemailer	Send emails via SMTP	3
node-cron	Scheduled job for daily emails	3
tesseract.js	OCR for extracting text from images	4
sharp	Pre-process images (optimize for OCR)	4
pdf-parse	Extract text from PDFs	4
@types/nodemailer	TypeScript definitions	3

---

Estimated Timeline

Phase	Task	Priority	Estimated
1.1	Configure SMTP	High	1-2 hours
1.2	Reschedule appointments	High	3-4 hours
1.3	Daily email 10 PM	High	2-3 hours
2.1	Services button	Low	30 min
2.2	Courses contact	Medium	2-3 hours
2.3	Upload with OCR	High	4-5 hours

Total Estimated: 13-18 hours

---

Testing Checklist

Sprint 3

• SMTP test: send test email
• Reschedule test: change appointment and verify email sent
• Manual job test: trigger endpoint and verify daily email
• Scheduled job test: wait for 10 PM and verify automatic email

Sprint 4

• Services button test: navigate to /servicios
• Courses contact test: send inquiry and verify email
• Upload PDF test: upload, OCR, data extraction
• Upload JPG test: upload, OCR, data extraction
• Validation test: attempt to upload invalid file (type/size)
• Drag & drop test: drag file to upload component

---

Important Notes

1. WhatsApp Reminders: NOT implementing to avoid Meta bans. Reminders are handled through:

   • Google Calendar (email 24h before - already implemented in Sprint 3)
   • Daily email at 10 PM to admin with next day's agenda (pending)

2. Reschedule Appointments: Flow with confirmation sent (email to patient). The change is automatic upon receiving the email.

3. Payment Proof Upload: Hybrid approach (client-side preprocessing, server-side OCR) to extract data from any bank without specific templates.

4. Daily Email: Sent only to admin (Gloria), NOT to assistant. Time: 10 PM (configurable for timezone).

5. Data to Extract from Proof: Amount, Transfer date, Reference/Key, Sender name, Sender bank.

---

[0.5.0] - 2026-02-02 - Sprint 3/4 Completado

Added

Email SMTP Service (Sprint 3)

• SMTP configuration with nodemailer (TLS transport, connection pooling)
• Email templates HTML:
  • Reschedule confirmation (src/lib/email/templates/reschedule-confirmation.ts)
  • Daily agenda report (src/lib/email/templates/daily-agenda.ts)
  • Course inquiry notification (src/lib/email/templates/course-inquiry.ts)
• Email client with retry logic and exponential backoff (src/infrastructure/email/smtp.ts)

Reschedule Appointments (Sprint 3)

• API endpoint POST /api/calendar/reschedule
• Reschedule modal component (src/components/dashboard/RescheduleModal.tsx)
• Google Calendar updateEvent() function
• Email confirmation to patient on reschedule
• Availability validation before rescheduling

Daily Agenda Job (Sprint 3)

• Scheduled job with node-cron (src/jobs/send-daily-agenda.ts)
• Manual trigger endpoint POST /api/jobs/trigger-agenda
• Daily email at 10 PM to admin with next day's agenda
• HTML table with: time, patient name, phone, type, payment status

Payment Proof Upload with OCR (Sprint 4)

• API endpoint POST /api/payments/upload-proof
• OCR processor with tesseract.js (src/lib/ocr/processor.ts)
• Regex patterns for data extraction:
  • Amount
  • Transfer date
  • Reference/Key
  • Sender name
  • Sender bank
• PDF text extraction with pdf-parse
• Drag & drop upload component (src/components/dashboard/PaymentUpload.tsx)
• Extracted data displayed with edit option

Database Schema Updates (Sprint 4)

• Added eventId field to Appointment model
• Added OCR-extracted fields to Payment model:
  • extractedDate - DateTime
  • extractedAmount - Float
  • extractedReference - String
  • extractedSenderName - String
  • extractedSenderBank - String
  • confidence - Float

Course Contact Form (Sprint 4)

• API endpoint POST /api/contact/courses
• Contact form component (src/components/forms/CourseContactForm.tsx)
• Course inquiry form on /cursos page
• Email notification to admin on course inquiry

Dashboard Updates (Sprint 3/4)

• Added "Reacomodar" button to Assistant dashboard
• Added "Reacomodar" button to Therapist dashboard
• Integrated PaymentUpload component in Assistant dashboard for pending payments
• Updated /cursos page with contact form section

Other Changes

• Updated Services component "Ver Más Servicios" button to navigate to /servicios
• Added new environment variables for SMTP configuration
• Imported daily agenda job in layout.tsx for automatic initialization

Changed

• Updated Prisma schema with new fields
• Updated env validation schema with SMTP variables
• Updated dashboard UI for better UX with reschedule and upload features

Fixed

• Fixed pdf-parse import issue (using require for CommonJS module)
• Fixed TypeScript errors in new components

Tests

• ✅ TypeScript typecheck - No errors
• ✅ ESLint - Only warnings (img tags, react-hooks)
• ✅ Production build successful

---

[0.0.1] - 2026-01-15 - Initial Release

Initial Release

• Project scaffolding with Next.js 14
• Database schema definition
• Basic authentication structure
• Landing page implementation
• Docker configuration

---

Full Changelog: See CHANGELOG.md