Fix: Use partial index name idx_timesheets_user_date_unique in ON CONFLICT to align with soft-delete unique constraint

Fix: Update ON CONFLICT to use (user_id, work_date) and align reconciliation logic with deployed migrations

Fix: Remove invalid enum values and rewrite reconciliation filters using valid AssignmentAction enums for reliable real-time updates

Fix: Replace ANY() array binding with explicit IN() params to resolve mixed parameter style errors in reconciliation SQL

Fix: Cast user_ids to UUID array in reconciliation SQL to resolve uuid=text ANY() errors

Fix: Correct expense relationship usage and add missing real-time reconciliation on ticket completion

Fix: Standardize time tracking fields and add migration to rename clock_in/clock_out to check_in/check_out

Made /stats accessible to field agents by removing restrictive permission decorator and cleaned up debug logging.

Fixed /stats 422 error by moving the endpoint before /{timesheet_id} to correct FastAPI route ordering.

Updated /me/timesheets default range to last 7 days plus all future dates so upcoming leave requests are included.

Added deleted_at=None filtering across TimesheetService and converted deletes to soft-deletes to fix empty /me/timesheets results.

Fixed /me/timesheets endpoint by adding missing project_id parameter and enabling proper project-based filtering.

Fixed leave application endpoint by removing .value access on string statuses and ensuring consistent enum value handling.

Corrected Timesheet enum storage by configuring SQLAlchemy Enum to persist .value strings and preventing unwanted enum coercion.

Forced enum serialization to lowercase DB values by explicitly converting TimesheetStatus to .value before model creation.

Fixed enum casing issue by switching model_dump to JSON mode to ensure lowercase status values are persisted.

Fixed enum-case mismatch by allowing string-based status values and passing lowercase status directly to DB.

Fixed enum mismatch by updating schema and endpoints to use lowercase TimesheetStatus string values aligning with DB enum

Implemented leave application endpoint and added self-service timesheet views for agents and performance tracking for managers

Fix audit logging by replacing invalid AuditAction values with UPDATE across all user management operations

Expand manage_org_users permissions and update org-based checks so managers can manage users within their organization

Enhance profile endpoint with full project team details including roles, regions, and subcontractor info

Fix profile endpoint by aligning financial and asset fields with actual model definitions

Fix profile endpoint by replacing mime_type with file_type and removing nonexistent is_verified field

Fix 403 error by updating user view permissions for project managers, sales managers, and dispatchers

fix(reconciliation): convert async DB logic to sync, update endpoints, and align with existing session architecture

reconcilliation endpoints

fix-imports: resolved missing Ticket import and validated notification model imports

fix: Moved /stats and /stats/summary routes BEFORE the /{expense_id} route

Fix dashboard expense stats to filter by incurred_by_user_id instead of assignment-based query

Fix expense approval notifications by replacing asyncio.create_task with FastAPI BackgroundTasks

Use TicketCommentService._to_response() in ticket detail endpoint to include comment attachments

fix(expenses): replace nonexistent ticket_reference usage and add robust error handling for bulk export

fix(bulk-export): add missing imports, improve error handling, and add logging

feat(expenses): add bulk-export-by-ids endpoint and update docs to fix frontend/export mismatch

fix(notifications): update service to use correct filter fields (from_date/to_date) to prevent AttributeError

fix(sqlalchemy): replace deprecated subquery() usages with select().scalar_subquery() across services to eliminate warnings

refactor(filters): migrate remaining endpoints (customers, notifications, inventory) to unified Query-based filter parsing system

fix(filters): replace Pydantic Depends with custom Query-based parsers to correctly handle multi-value API filters

fix(api): replace Pydantic Depends model with custom query parser to correctly handle multi-value filters

chore(logging): add debug logs to ticket filtering to inspect query param parsing and filter behavior

fix(filters): correctly parse comma-separated query params into lists for multi-value filters

feat(filtering): implement complete end-to-end server-side filtering infrastructure and migrate tickets/projects to new system

Fix ProjectSubcontractor import scope in dashboard_service.py

fix: add missing ProjectTeam import in dashboard_service to resolve endpoint error

Reorder document routes so /users/me endpoints take precedence over generic entity routes

Add dedicated /users/me document and profile photo endpoints to avoid UUID parsing errors

Make account_name optional and auto-populate it for mobile money and bank accounts

Filter disallowed profile fields instead of rejecting request to prevent 403 errors

Fix backend permissions to allow field agents to update full basic profile info