Fix dashboard and global work queue by correcting ticket_name usage, and ensuring overview endpoint returns active assignments.

Add ticket completion fields, integrate project requirements caching via cachetools, update completion service, and implement cache invalidation on project updates.

Fix JSONB journey history not persisting by flagging journey_location_history as modified in update_location service.

Add TicketStatusHistory model and integrate automatic status logging into ticket assignment workflow.

Remove regional assignment restrictions and update services/docs to allow cross-region ticket pickup.

Implement full dynamic ticket action system with enum rename, self-assign auto-accept, updated assignment logic, and new documentation.

Add field/sales agent access to can_user_manage_tickets to fix 403 on ticket detail view

feat: tickets detail view

Allow field agents to see all project tickets by switching filter from assignments to project team membership

fix: Add field/sales agent authorization to list only their assigned tickets and fix 403 error

Fix variable shadowing issue in list_tickets by renaming 'status' parameter to 'ticket_status

feat: field agent dashboard and work queue

fix: resolve 'property has no attribute in_' by querying timeline columns instead of status property

updated meta apps and made overview return just the data needed

feat: add field agent stats and global work queue to user overview endpoint

fix: correct TaskStatus enum usage, update Postgres ENUM definition, and add validator for empty task_scheduled_date

feat(tasks): add comprehensive tasks API with notification integration and documentation

Fix project status filtering to include 'active' across dashboard and analytics endpoints

Add inventory stats to project dashboard, create standalone stats + user overview endpoints, and update related documentation

feat: added notifications icons instructions to metadata

feat: scope notification to a project, added project id to the notifications table as a nullable field

feat(notifications): integrate notification system across core services

fix(tickets): restore scheduled date/time in bulk promotion by adding fallback to sales order preferred visit fields

feat: better sale orders bulk imports with auto linking for regions

Enhance CSV import error handling in sales order processing

feat: add phone number normalization utility and integrate into sales order processing

fix: Remove project status restrictions for invitations

fix: Allow project_manager, dispatcher, and sales_manager to invite users

feat: Add project team management endpoints - Fix team stats to count actual team members - Add filtering to GET /projects/{id}/team (role, region, active status, search) - Add PATCH /projects/{id}/team/{member_id} for updating team members - Add DELETE /projects/{id}/team/{member_id} for removing team members

fix: Decimal validation error in sales order stats

fix: correct NotificationStatsResponse field names

fix: resolve remaining dashboard errors and sales-orders 422 issue

fix: correct remaining schema mismatches in expense and finance queries

fix: correct database schema mismatches in dashboard queries

fix: correct database schema mismatches in Ticket, Notification, and TicketExpense queries

fix: correct ProjectFinance import path in dashboard_service

feat: implement project dashboard with activity feed

feat: introduce ProjectType enum and update project model to use it for improved data integrity

refactor: update project finalization logic to allow transitioning from draft/planning to active status

Refactor project role schemas and service logic

Enhance audit and project services with idempotent behavior and JSON serialization

feat: add additional fields to region creation in ProjectService

feat(project): add HubContactPerson schema and integrate into project region management

feat(project): add complete project setup workflow with service methods and API endpoints for regions, roles, subcontractors, and finalization including validation and authorization

fix(invite): implement project-level invitations with validation and notifications

feat: project setup person at project creation

added invited name to user invitaitons

fix(project): add robust service_type normalization and DB enum error messaging

CRITICAL PERFORMANCE FIX: Database connection optimization - Increased SQLAlchemy connection pool from 5 to 20 - Added connection recycling (5 min TTL) - Made SupabaseAuth singleton to reuse connections - Changed audit logging from commit() to flush() to batch writes - Added comprehensive performance fix documentation See PERFORMANCE_FIX.md for CRITICAL step: Must update DATABASE_URL to use Supabase connection pooler (port 6543)

feat: hub tracking and last active project preference