feat(migrations): add initial migration setup and performance indexes

- Introduced .pgmrc.json and migrate.json for node-pg-migrate configuration. - Added multiple migration files to create performance indexes for tasks and related entities. - Implemented functions for optimized task sorting and manual progress tracking. - Updated package.json to include migration scripts and dependencies for node-pg-migrate. - Created README.md for migration guidelines and best practices.
2025-07-22 22:06:07 +05:30
670 changed files with 3669 additions and 22820 deletions
--- a/.claude/settings.local.json
+++ b/.claude/settings.local.json
@@ -0,0 +1,11 @@
+{
+  "permissions": {
+    "allow": [
+      "Bash(find:*)",
+      "Bash(npm run build:*)",
+      "Bash(npm run type-check:*)",
+      "Bash(npm run:*)"
+    ],
+    "deny": []
+  }
+}
--- a/.gitignore
+++ b/.gitignore
@@ -36,8 +36,6 @@ lerna-debug.log*
 .vscode/*
 !.vscode/extensions.json
 .idea/
-.cursor/
-.claude/
 .DS_Store
 *.suo
 *.ntvs*
@@ -78,7 +76,4 @@ $RECYCLE.BIN/
 # TypeScript
 *.tsbuildinfo

-# Claude
-CLAUDE.md
-

--- a/test_sort_fix.sql
+++ b/test_sort_fix.sql
@@ -0,0 +1,41 @@
+-- Test script to verify the sort order constraint fix
+
+-- Test the helper function
+SELECT get_sort_column_name('status');    -- Should return 'status_sort_order'
+SELECT get_sort_column_name('priority');  -- Should return 'priority_sort_order'
+SELECT get_sort_column_name('phase');     -- Should return 'phase_sort_order'
+SELECT get_sort_column_name('members');   -- Should return 'member_sort_order'
+SELECT get_sort_column_name('unknown');   -- Should return 'status_sort_order' (default)
+
+-- Test bulk update function (example - would need real project_id and task_ids)
+/*
+SELECT update_task_sort_orders_bulk(
+    '[
+        {"task_id": "example-uuid", "sort_order": 1, "status_id": "status-uuid"},
+        {"task_id": "example-uuid-2", "sort_order": 2, "status_id": "status-uuid"}
+    ]'::json,
+    'status'
+);
+*/
+
+-- Verify that sort_order constraint still exists and works
+SELECT 
+    tc.constraint_name,
+    tc.table_name,
+    kcu.column_name
+FROM information_schema.table_constraints tc
+JOIN information_schema.key_column_usage kcu 
+    ON tc.constraint_name = kcu.constraint_name
+WHERE tc.constraint_name = 'tasks_sort_order_unique';
+
+-- Check that new sort order columns don't have unique constraints (which is correct)
+SELECT 
+    tc.constraint_name,
+    tc.table_name,
+    kcu.column_name
+FROM information_schema.table_constraints tc
+JOIN information_schema.key_column_usage kcu 
+    ON tc.constraint_name = kcu.constraint_name
+WHERE kcu.table_name = 'tasks'
+  AND kcu.column_name IN ('status_sort_order', 'priority_sort_order', 'phase_sort_order', 'member_sort_order')
+  AND tc.constraint_type = 'UNIQUE';
--- a/test_sort_orders.sql
+++ b/test_sort_orders.sql
@@ -0,0 +1,30 @@
+-- Test script to validate the separate sort order implementation
+
+-- Check if new columns exist
+SELECT column_name, data_type, is_nullable, column_default
+FROM information_schema.columns 
+WHERE table_name = 'tasks' 
+  AND column_name IN ('status_sort_order', 'priority_sort_order', 'phase_sort_order', 'member_sort_order')
+ORDER BY column_name;
+
+-- Check if helper function exists
+SELECT routine_name, routine_type
+FROM information_schema.routines 
+WHERE routine_name IN ('get_sort_column_name', 'update_task_sort_orders_bulk', 'handle_task_list_sort_order_change');
+
+-- Sample test data to verify different sort orders work
+-- (This would be run after the migrations)
+/*
+-- Test: Tasks should have different orders for different groupings
+SELECT 
+  id, 
+  name, 
+  sort_order, 
+  status_sort_order, 
+  priority_sort_order, 
+  phase_sort_order, 
+  member_sort_order
+FROM tasks 
+WHERE project_id = '<test-project-id>'
+ORDER BY status_sort_order;
+*/
--- a/worklenz-backend/.pgmrc.json
+++ b/worklenz-backend/.pgmrc.json
@@ -0,0 +1,3 @@
+{
+  "config-file": "migrate.json"
+}
--- a/worklenz-backend/database/migrations/release-v2.1.4/20250724000000-add-survey-tables.sql
+++ b/worklenz-backend/database/migrations/release-v2.1.4/20250724000000-add-survey-tables.sql
@@ -1,93 +0,0 @@
-- Migration: Add survey tables for account setup questionnaire
-- Date: 2025-07-24
-- Description: Creates tables to store survey questions and user responses for account setup flow
-
-BEGIN;
-
-- Create surveys table to define different types of surveys
-CREATE TABLE IF NOT EXISTS surveys (
-    id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
-    name VARCHAR(255) NOT NULL,
-    description TEXT,
-    survey_type VARCHAR(50) DEFAULT 'account_setup' NOT NULL, -- 'account_setup', 'onboarding', 'feedback'
-    is_active BOOLEAN DEFAULT TRUE NOT NULL,
-    created_at TIMESTAMP DEFAULT now() NOT NULL,
-    updated_at TIMESTAMP DEFAULT now() NOT NULL
-);
-
-- Create survey_questions table to store individual questions
-CREATE TABLE IF NOT EXISTS survey_questions (
-    id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
-    survey_id UUID REFERENCES surveys(id) ON DELETE CASCADE NOT NULL,
-    question_key VARCHAR(100) NOT NULL, -- Used for localization keys
-    question_type VARCHAR(50) NOT NULL, -- 'single_choice', 'multiple_choice', 'text'
-    is_required BOOLEAN DEFAULT FALSE NOT NULL,
-    sort_order INTEGER DEFAULT 0 NOT NULL,
-    options JSONB, -- For choice questions, store options as JSON array
-    created_at TIMESTAMP DEFAULT now() NOT NULL,
-    updated_at TIMESTAMP DEFAULT now() NOT NULL
-);
-
-- Create survey_responses table to track user responses to surveys
-CREATE TABLE IF NOT EXISTS survey_responses (
-    id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
-    survey_id UUID REFERENCES surveys(id) ON DELETE CASCADE NOT NULL,
-    user_id UUID REFERENCES users(id) ON DELETE CASCADE NOT NULL,
-    is_completed BOOLEAN DEFAULT FALSE NOT NULL,
-    started_at TIMESTAMP DEFAULT now() NOT NULL,
-    completed_at TIMESTAMP,
-    created_at TIMESTAMP DEFAULT now() NOT NULL,
-    updated_at TIMESTAMP DEFAULT now() NOT NULL
-);
-
-- Create survey_answers table to store individual question answers
-CREATE TABLE IF NOT EXISTS survey_answers (
-    id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
-    response_id UUID REFERENCES survey_responses(id) ON DELETE CASCADE NOT NULL,
-    question_id UUID REFERENCES survey_questions(id) ON DELETE CASCADE NOT NULL,
-    answer_text TEXT,
-    answer_json JSONB, -- For multiple choice answers stored as array
-    created_at TIMESTAMP DEFAULT now() NOT NULL,
-    updated_at TIMESTAMP DEFAULT now() NOT NULL
-);
-
-- Add performance indexes
-CREATE INDEX IF NOT EXISTS idx_surveys_type_active ON surveys(survey_type, is_active);
-CREATE INDEX IF NOT EXISTS idx_survey_questions_survey_order ON survey_questions(survey_id, sort_order);
-CREATE INDEX IF NOT EXISTS idx_survey_responses_user_survey ON survey_responses(user_id, survey_id);
-CREATE INDEX IF NOT EXISTS idx_survey_responses_completed ON survey_responses(survey_id, is_completed);
-CREATE INDEX IF NOT EXISTS idx_survey_answers_response ON survey_answers(response_id);
-
-- Add constraints
-ALTER TABLE survey_questions ADD CONSTRAINT survey_questions_sort_order_check CHECK (sort_order >= 0);
-ALTER TABLE survey_questions ADD CONSTRAINT survey_questions_type_check CHECK (question_type IN ('single_choice', 'multiple_choice', 'text'));
-
-- Add unique constraint to prevent duplicate responses per user per survey
-ALTER TABLE survey_responses ADD CONSTRAINT unique_user_survey_response UNIQUE (user_id, survey_id);
-
-- Add unique constraint to prevent duplicate answers per question per response
-ALTER TABLE survey_answers ADD CONSTRAINT unique_response_question_answer UNIQUE (response_id, question_id);
-
-- Insert the default account setup survey
-INSERT INTO surveys (name, description, survey_type, is_active) VALUES 
-('Account Setup Survey', 'Initial questionnaire during account setup to understand user needs', 'account_setup', true)
-ON CONFLICT DO NOTHING;
-
-- Get the survey ID for inserting questions
-DO $$
-DECLARE
-    survey_uuid UUID;
-BEGIN
-    SELECT id INTO survey_uuid FROM surveys WHERE survey_type = 'account_setup' AND name = 'Account Setup Survey' LIMIT 1;
-    
-    -- Insert survey questions
-    INSERT INTO survey_questions (survey_id, question_key, question_type, is_required, sort_order, options) VALUES
-    (survey_uuid, 'organization_type', 'single_choice', true, 1, '["freelancer", "startup", "small_medium_business", "agency", "enterprise", "other"]'),
-    (survey_uuid, 'user_role', 'single_choice', true, 2, '["founder_ceo", "project_manager", "software_developer", "designer", "operations", "other"]'),
-    (survey_uuid, 'main_use_cases', 'multiple_choice', true, 3, '["task_management", "team_collaboration", "resource_planning", "client_communication", "time_tracking", "other"]'),
-    (survey_uuid, 'previous_tools', 'text', false, 4, null),
-    (survey_uuid, 'how_heard_about', 'single_choice', false, 5, '["google_search", "twitter", "linkedin", "friend_colleague", "blog_article", "other"]')
-    ON CONFLICT DO NOTHING;
-END $$;
-
-COMMIT;
--- a/worklenz-backend/database/pg-migrations/20250115000000_performance-indexes.js
+++ b/worklenz-backend/database/pg-migrations/20250115000000_performance-indexes.js
@@ -0,0 +1,149 @@
+/* eslint-disable camelcase */
+
+exports.shorthands = undefined;
+
+exports.up = pgm => {
+  // Composite index for main task filtering
+  pgm.sql(`
+    CREATE INDEX CONCURRENTLY IF NOT EXISTS idx_tasks_project_archived_parent 
+    ON tasks(project_id, archived, parent_task_id) 
+    WHERE archived = FALSE
+  `);
+
+  // Index for status joins
+  pgm.sql(`
+    CREATE INDEX CONCURRENTLY IF NOT EXISTS idx_tasks_status_project 
+    ON tasks(status_id, project_id) 
+    WHERE archived = FALSE
+  `);
+
+  // Index for assignees lookup
+  pgm.sql(`
+    CREATE INDEX CONCURRENTLY IF NOT EXISTS idx_tasks_assignees_task_member 
+    ON tasks_assignees(task_id, team_member_id)
+  `);
+
+  // Index for phase lookup
+  pgm.sql(`
+    CREATE INDEX CONCURRENTLY IF NOT EXISTS idx_task_phase_task_phase 
+    ON task_phase(task_id, phase_id)
+  `);
+
+  // Index for subtask counting
+  pgm.sql(`
+    CREATE INDEX CONCURRENTLY IF NOT EXISTS idx_tasks_parent_archived 
+    ON tasks(parent_task_id, archived) 
+    WHERE parent_task_id IS NOT NULL AND archived = FALSE
+  `);
+
+  // Index for labels
+  pgm.sql(`
+    CREATE INDEX CONCURRENTLY IF NOT EXISTS idx_task_labels_task_label 
+    ON task_labels(task_id, label_id)
+  `);
+
+  // Index for comments count
+  pgm.sql(`
+    CREATE INDEX CONCURRENTLY IF NOT EXISTS idx_task_comments_task 
+    ON task_comments(task_id)
+  `);
+
+  // Index for attachments count
+  pgm.sql(`
+    CREATE INDEX CONCURRENTLY IF NOT EXISTS idx_task_attachments_task 
+    ON task_attachments(task_id)
+  `);
+
+  // Index for work log aggregation
+  pgm.sql(`
+    CREATE INDEX CONCURRENTLY IF NOT EXISTS idx_task_work_log_task 
+    ON task_work_log(task_id)
+  `);
+
+  // Index for subscribers check
+  pgm.sql(`
+    CREATE INDEX CONCURRENTLY IF NOT EXISTS idx_task_subscribers_task 
+    ON task_subscribers(task_id)
+  `);
+
+  // Index for dependencies check
+  pgm.sql(`
+    CREATE INDEX CONCURRENTLY IF NOT EXISTS idx_task_dependencies_task 
+    ON task_dependencies(task_id)
+  `);
+
+  // Additional performance indexes
+  pgm.sql(`
+    CREATE INDEX CONCURRENTLY IF NOT EXISTS idx_task_dependencies_related 
+    ON task_dependencies(related_task_id)
+  `);
+
+  // Index for custom column values
+  pgm.sql(`
+    CREATE INDEX CONCURRENTLY IF NOT EXISTS idx_cc_column_values_task 
+    ON cc_column_values(task_id)
+  `);
+
+  // Index for project members lookup
+  pgm.sql(`
+    CREATE INDEX CONCURRENTLY IF NOT EXISTS idx_project_members_team_project 
+    ON project_members(team_member_id, project_id)
+  `);
+
+  // Index for sorting
+  pgm.sql(`
+    CREATE INDEX CONCURRENTLY IF NOT EXISTS idx_tasks_project_sort 
+    ON tasks(project_id, sort_order) 
+    WHERE archived = FALSE
+  `);
+
+  // Index for roadmap sorting
+  pgm.sql(`
+    CREATE INDEX CONCURRENTLY IF NOT EXISTS idx_tasks_project_roadmap_sort 
+    ON tasks(project_id, roadmap_sort_order) 
+    WHERE archived = FALSE
+  `);
+
+  // Index for user lookup in team members
+  pgm.sql(`
+    CREATE INDEX CONCURRENTLY IF NOT EXISTS idx_team_members_user_team 
+    ON team_members(user_id, team_id) 
+    WHERE active = TRUE
+  `);
+
+  // Index for task statuses lookup
+  pgm.sql(`
+    CREATE INDEX CONCURRENTLY IF NOT EXISTS idx_task_statuses_project_category 
+    ON task_statuses(project_id, category_id)
+  `);
+
+  // Index for task priorities lookup
+  pgm.sql(`
+    CREATE INDEX CONCURRENTLY IF NOT EXISTS idx_tasks_priority 
+    ON tasks(priority_id) 
+    WHERE archived = FALSE
+  `);
+};
+
+exports.down = pgm => {
+  // Drop indexes in reverse order
+  pgm.sql('DROP INDEX IF EXISTS idx_tasks_priority');
+  pgm.sql('DROP INDEX IF EXISTS idx_task_statuses_project_category');
+  pgm.sql('DROP INDEX IF EXISTS idx_team_members_user_team');
+  pgm.sql('DROP INDEX IF EXISTS idx_tasks_project_roadmap_sort');
+  pgm.sql('DROP INDEX IF EXISTS idx_tasks_project_sort');
+  pgm.sql('DROP INDEX IF EXISTS idx_project_members_team_project');
+  pgm.sql('DROP INDEX IF EXISTS idx_cc_column_values_task');
+  pgm.sql('DROP INDEX IF EXISTS idx_task_dependencies_related');
+  pgm.sql('DROP INDEX IF EXISTS idx_task_dependencies_task');
+  pgm.sql('DROP INDEX IF EXISTS idx_task_subscribers_task');
+  pgm.sql('DROP INDEX IF EXISTS idx_task_work_log_task');
+  pgm.sql('DROP INDEX IF EXISTS idx_task_attachments_task');
+  pgm.sql('DROP INDEX IF EXISTS idx_task_comments_task');
+  pgm.sql('DROP INDEX IF EXISTS idx_task_labels_task_label');
+  pgm.sql('DROP INDEX IF EXISTS idx_tasks_parent_archived');
+  pgm.sql('DROP INDEX IF EXISTS idx_task_phase_task_phase');
+  pgm.sql('DROP INDEX IF EXISTS idx_tasks_assignees_task_member');
+  pgm.sql('DROP INDEX IF EXISTS idx_tasks_status_project');
+  pgm.sql('DROP INDEX IF EXISTS idx_tasks_project_archived_parent');
+};
--- a/worklenz-backend/database/pg-migrations/20250128000000_fix-window-function-error.js
+++ b/worklenz-backend/database/pg-migrations/20250128000000_fix-window-function-error.js
@@ -0,0 +1,183 @@
+/* eslint-disable camelcase */
+
+exports.shorthands = undefined;
+
+exports.up = pgm => {
+  // Replace the optimized sort functions to avoid CTE usage in UPDATE statements
+  pgm.createFunction(
+    'handle_task_list_sort_between_groups_optimized',
+    [
+      { name: '_from_index', type: 'integer' },
+      { name: '_to_index', type: 'integer' },
+      { name: '_task_id', type: 'uuid' },
+      { name: '_project_id', type: 'uuid' },
+      { name: '_batch_size', type: 'integer', default: 100 }
+    ],
+    { returns: 'void', language: 'plpgsql', replace: true },
+    `
+DECLARE
+    _offset INT := 0;
+    _affected_rows INT;
+BEGIN
+    -- PERFORMANCE OPTIMIZATION: Use direct updates without CTE in UPDATE
+    IF (_to_index = -1)
+    THEN
+        _to_index = COALESCE((SELECT MAX(sort_order) + 1 FROM tasks WHERE project_id = _project_id), 0);
+    END IF;
+
+    -- PERFORMANCE OPTIMIZATION: Batch updates for large datasets
+    IF _to_index > _from_index
+    THEN
+        LOOP
+            UPDATE tasks
+            SET sort_order = sort_order - 1
+            WHERE project_id = _project_id
+              AND sort_order > _from_index
+              AND sort_order < _to_index
+              AND sort_order > _offset
+              AND sort_order <= _offset + _batch_size;
+            
+            GET DIAGNOSTICS _affected_rows = ROW_COUNT;
+            EXIT WHEN _affected_rows = 0;
+            _offset := _offset + _batch_size;
+        END LOOP;
+
+        UPDATE tasks SET sort_order = _to_index - 1 WHERE id = _task_id AND project_id = _project_id;
+    END IF;
+
+    IF _to_index < _from_index
+    THEN
+        _offset := 0;
+        LOOP
+            UPDATE tasks
+            SET sort_order = sort_order + 1
+            WHERE project_id = _project_id
+              AND sort_order > _to_index
+              AND sort_order < _from_index
+              AND sort_order > _offset
+              AND sort_order <= _offset + _batch_size;
+            
+            GET DIAGNOSTICS _affected_rows = ROW_COUNT;
+            EXIT WHEN _affected_rows = 0;
+            _offset := _offset + _batch_size;
+        END LOOP;
+
+        UPDATE tasks SET sort_order = _to_index + 1 WHERE id = _task_id AND project_id = _project_id;
+    END IF;
+END
+    `
+  );
+
+  // Replace the second optimized sort function
+  pgm.createFunction(
+    'handle_task_list_sort_inside_group_optimized',
+    [
+      { name: '_from_index', type: 'integer' },
+      { name: '_to_index', type: 'integer' },
+      { name: '_task_id', type: 'uuid' },
+      { name: '_project_id', type: 'uuid' },
+      { name: '_batch_size', type: 'integer', default: 100 }
+    ],
+    { returns: 'void', language: 'plpgsql', replace: true },
+    `
+DECLARE
+    _offset INT := 0;
+    _affected_rows INT;
+BEGIN
+    -- PERFORMANCE OPTIMIZATION: Batch updates for large datasets without CTE in UPDATE
+    IF _to_index > _from_index
+    THEN
+        LOOP
+            UPDATE tasks
+            SET sort_order = sort_order - 1
+            WHERE project_id = _project_id
+              AND sort_order > _from_index
+              AND sort_order <= _to_index
+              AND sort_order > _offset
+              AND sort_order <= _offset + _batch_size;
+            
+            GET DIAGNOSTICS _affected_rows = ROW_COUNT;
+            EXIT WHEN _affected_rows = 0;
+            _offset := _offset + _batch_size;
+        END LOOP;
+    END IF;
+
+    IF _to_index < _from_index
+    THEN
+        _offset := 0;
+        LOOP
+            UPDATE tasks
+            SET sort_order = sort_order + 1
+            WHERE project_id = _project_id
+              AND sort_order >= _to_index
+              AND sort_order < _from_index
+              AND sort_order > _offset
+              AND sort_order <= _offset + _batch_size;
+            
+            GET DIAGNOSTICS _affected_rows = ROW_COUNT;
+            EXIT WHEN _affected_rows = 0;
+            _offset := _offset + _batch_size;
+        END LOOP;
+    END IF;
+
+    UPDATE tasks SET sort_order = _to_index WHERE id = _task_id AND project_id = _project_id;
+END
+    `
+  );
+
+  // Add simple bulk update function as alternative
+  pgm.createFunction(
+    'update_task_sort_orders_bulk',
+    [{ name: '_updates', type: 'json' }],
+    { returns: 'void', language: 'plpgsql', replace: true },
+    `
+DECLARE
+    _update_record RECORD;
+BEGIN
+    -- Simple approach: update each task's sort_order from the provided array
+    FOR _update_record IN 
+        SELECT 
+            (item->>'task_id')::uuid as task_id,
+            (item->>'sort_order')::int as sort_order,
+            (item->>'status_id')::uuid as status_id,
+            (item->>'priority_id')::uuid as priority_id,
+            (item->>'phase_id')::uuid as phase_id
+        FROM json_array_elements(_updates) as item
+    LOOP
+        UPDATE tasks 
+        SET 
+            sort_order = _update_record.sort_order,
+            status_id = COALESCE(_update_record.status_id, status_id),
+            priority_id = COALESCE(_update_record.priority_id, priority_id)
+        WHERE id = _update_record.task_id;
+        
+        -- Handle phase updates separately since it's in a different table
+        IF _update_record.phase_id IS NOT NULL THEN
+            INSERT INTO task_phase (task_id, phase_id)
+            VALUES (_update_record.task_id, _update_record.phase_id)
+            ON CONFLICT (task_id) DO UPDATE SET phase_id = _update_record.phase_id;
+        END IF;
+    END LOOP;
+END
+    `
+  );
+};
+
+exports.down = pgm => {
+  // Drop the functions if needed to rollback
+  pgm.dropFunction('update_task_sort_orders_bulk', [{ name: '_updates', type: 'json' }], { ifExists: true });
+  pgm.dropFunction('handle_task_list_sort_inside_group_optimized', [
+    { name: '_from_index', type: 'integer' },
+    { name: '_to_index', type: 'integer' },
+    { name: '_task_id', type: 'uuid' },
+    { name: '_project_id', type: 'uuid' },
+    { name: '_batch_size', type: 'integer' }
+  ], { ifExists: true });
+  pgm.dropFunction('handle_task_list_sort_between_groups_optimized', [
+    { name: '_from_index', type: 'integer' },
+    { name: '_to_index', type: 'integer' },
+    { name: '_task_id', type: 'uuid' },
+    { name: '_project_id', type: 'uuid' },
+    { name: '_batch_size', type: 'integer' }
+  ], { ifExists: true });
+};
--- a/worklenz-backend/database/pg-migrations/20250422132400_manual-task-progress.js
+++ b/worklenz-backend/database/pg-migrations/20250422132400_manual-task-progress.js
@@ -0,0 +1,99 @@
+/* eslint-disable camelcase */
+
+exports.shorthands = undefined;
+
+exports.up = pgm => {
+  // Add manual progress fields to tasks table
+  pgm.addColumns('tasks', {
+    manual_progress: {
+      type: 'boolean',
+      default: false,
+      notNull: false
+    },
+    progress_value: {
+      type: 'integer',
+      default: null,
+      notNull: false
+    },
+    weight: {
+      type: 'integer',
+      default: null,
+      notNull: false
+    }
+  }, { ifNotExists: true });
+
+  // Update function to consider manual progress
+  pgm.createFunction(
+    'get_task_complete_ratio',
+    [{ name: '_task_id', type: 'uuid' }],
+    { returns: 'json', language: 'plpgsql', replace: true },
+    `
+DECLARE
+    _parent_task_done FLOAT = 0;
+    _sub_tasks_done   FLOAT = 0;
+    _sub_tasks_count  FLOAT = 0;
+    _total_completed  FLOAT = 0;
+    _total_tasks      FLOAT = 0;
+    _ratio            FLOAT = 0;
+    _is_manual        BOOLEAN = FALSE;
+    _manual_value     INTEGER = NULL;
+BEGIN
+    -- Check if manual progress is set
+    SELECT manual_progress, progress_value 
+    FROM tasks 
+    WHERE id = _task_id
+    INTO _is_manual, _manual_value;
+    
+    -- If manual progress is enabled and has a value, use it directly
+    IF _is_manual IS TRUE AND _manual_value IS NOT NULL THEN
+        RETURN JSON_BUILD_OBJECT(
+            'ratio', _manual_value,
+            'total_completed', 0,
+            'total_tasks', 0,
+            'is_manual', TRUE
+        );
+    END IF;
+    
+    -- Otherwise calculate automatically as before
+    SELECT (CASE
+                WHEN EXISTS(SELECT 1
+                            FROM tasks_with_status_view
+                            WHERE tasks_with_status_view.task_id = _task_id
+                              AND is_done IS TRUE) THEN 1
+                ELSE 0 END)
+    INTO _parent_task_done;
+    SELECT COUNT(*) FROM tasks WHERE parent_task_id = _task_id AND archived IS FALSE INTO _sub_tasks_count;
+
+    SELECT COUNT(*)
+    FROM tasks_with_status_view
+    WHERE parent_task_id = _task_id
+      AND is_done IS TRUE
+    INTO _sub_tasks_done;
+
+    _total_completed = _parent_task_done + _sub_tasks_done;
+    _total_tasks = _sub_tasks_count; -- +1 for the parent task
+    
+    IF _total_tasks > 0 THEN
+        _ratio = (_total_completed / _total_tasks) * 100;
+    ELSE
+        _ratio = _parent_task_done * 100;
+    END IF;
+
+    RETURN JSON_BUILD_OBJECT(
+        'ratio', _ratio,
+        'total_completed', _total_completed,
+        'total_tasks', _total_tasks,
+        'is_manual', FALSE
+    );
+END
+    `
+  );
+};
+
+exports.down = pgm => {
+  // Drop the function first (it depends on the columns)
+  pgm.dropFunction('get_task_complete_ratio', [{ name: '_task_id', type: 'uuid' }], { ifExists: true });
+  
+  // Remove the added columns
+  pgm.dropColumns('tasks', ['manual_progress', 'progress_value', 'weight'], { ifExists: true });
+};
--- a/worklenz-backend/database/pg-migrations/20250715000000_add-grouping-sort-orders.js
+++ b/worklenz-backend/database/pg-migrations/20250715000000_add-grouping-sort-orders.js
@@ -0,0 +1,103 @@
+/* eslint-disable camelcase */
+
+exports.shorthands = undefined;
+
+exports.up = pgm => {
+  // Add new sort order columns for different grouping types
+  pgm.addColumns('tasks', {
+    status_sort_order: {
+      type: 'integer',
+      default: 0,
+      notNull: false
+    },
+    priority_sort_order: {
+      type: 'integer',
+      default: 0,
+      notNull: false
+    },
+    phase_sort_order: {
+      type: 'integer',
+      default: 0,
+      notNull: false
+    },
+    member_sort_order: {
+      type: 'integer',
+      default: 0,
+      notNull: false
+    }
+  }, { ifNotExists: true });
+
+  // Initialize new columns with current sort_order values
+  pgm.sql(`
+    UPDATE tasks SET 
+      status_sort_order = sort_order,
+      priority_sort_order = sort_order,
+      phase_sort_order = sort_order,
+      member_sort_order = sort_order
+    WHERE status_sort_order = 0 
+       OR priority_sort_order = 0 
+       OR phase_sort_order = 0 
+       OR member_sort_order = 0
+  `);
+
+  // Add constraints to ensure non-negative values
+  pgm.addConstraint('tasks', 'tasks_status_sort_order_check', {
+    check: 'status_sort_order >= 0'
+  }, { ifNotExists: true });
+  
+  pgm.addConstraint('tasks', 'tasks_priority_sort_order_check', {
+    check: 'priority_sort_order >= 0'
+  }, { ifNotExists: true });
+  
+  pgm.addConstraint('tasks', 'tasks_phase_sort_order_check', {
+    check: 'phase_sort_order >= 0'
+  }, { ifNotExists: true });
+  
+  pgm.addConstraint('tasks', 'tasks_member_sort_order_check', {
+    check: 'member_sort_order >= 0'
+  }, { ifNotExists: true });
+
+  // Add indexes for performance
+  pgm.createIndex('tasks', ['project_id', 'status_sort_order'], {
+    name: 'idx_tasks_status_sort_order',
+    ifNotExists: true
+  });
+  
+  pgm.createIndex('tasks', ['project_id', 'priority_sort_order'], {
+    name: 'idx_tasks_priority_sort_order',
+    ifNotExists: true
+  });
+  
+  pgm.createIndex('tasks', ['project_id', 'phase_sort_order'], {
+    name: 'idx_tasks_phase_sort_order',
+    ifNotExists: true
+  });
+  
+  pgm.createIndex('tasks', ['project_id', 'member_sort_order'], {
+    name: 'idx_tasks_member_sort_order',
+    ifNotExists: true
+  });
+
+  // Add column comments for documentation
+  pgm.sql("COMMENT ON COLUMN tasks.status_sort_order IS 'Sort order when grouped by status'");
+  pgm.sql("COMMENT ON COLUMN tasks.priority_sort_order IS 'Sort order when grouped by priority'");
+  pgm.sql("COMMENT ON COLUMN tasks.phase_sort_order IS 'Sort order when grouped by phase'");
+  pgm.sql("COMMENT ON COLUMN tasks.member_sort_order IS 'Sort order when grouped by members/assignees'");
+};
+
+exports.down = pgm => {
+  // Drop indexes
+  pgm.dropIndex('tasks', ['project_id', 'member_sort_order'], { name: 'idx_tasks_member_sort_order', ifExists: true });
+  pgm.dropIndex('tasks', ['project_id', 'phase_sort_order'], { name: 'idx_tasks_phase_sort_order', ifExists: true });
+  pgm.dropIndex('tasks', ['project_id', 'priority_sort_order'], { name: 'idx_tasks_priority_sort_order', ifExists: true });
+  pgm.dropIndex('tasks', ['project_id', 'status_sort_order'], { name: 'idx_tasks_status_sort_order', ifExists: true });
+
+  // Drop constraints
+  pgm.dropConstraint('tasks', 'tasks_member_sort_order_check', { ifExists: true });
+  pgm.dropConstraint('tasks', 'tasks_phase_sort_order_check', { ifExists: true });
+  pgm.dropConstraint('tasks', 'tasks_priority_sort_order_check', { ifExists: true });
+  pgm.dropConstraint('tasks', 'tasks_status_sort_order_check', { ifExists: true });
+
+  // Drop columns
+  pgm.dropColumns('tasks', ['status_sort_order', 'priority_sort_order', 'phase_sort_order', 'member_sort_order'], { ifExists: true });
+};
--- a/worklenz-backend/database/pg-migrations/README.md
+++ b/worklenz-backend/database/pg-migrations/README.md
@@ -1,72 +0,0 @@
-# Node-pg-migrate Migrations
-
-This directory contains database migrations managed by node-pg-migrate.
-
-## Migration Commands
-
- `npm run migrate:create -- migration-name` - Create a new migration file
- `npm run migrate:up` - Run all pending migrations
- `npm run migrate:down` - Rollback the last migration
- `npm run migrate:redo` - Rollback and re-run the last migration
-
-## Migration File Format
-
-Migrations are JavaScript files with timestamp prefixes (e.g., `20250115000000_performance-indexes.js`).
-
-Each migration file exports two functions:
- `exports.up` - Contains the forward migration logic
- `exports.down` - Contains the rollback logic
-
-## Best Practices
-
-1. **Always use IF EXISTS/IF NOT EXISTS checks** to make migrations idempotent
-2. **Test migrations locally** before deploying to production
-3. **Include rollback logic** in the `down` function for all changes
-4. **Use descriptive names** for migration files
-5. **Keep migrations focused** - one logical change per migration
-
-## Example Migration
-
-```javascript
-exports.up = pgm => {
-  // Create table with IF NOT EXISTS
-  pgm.createTable('users', {
-    id: 'id',
-    name: { type: 'varchar(100)', notNull: true },
-    created_at: {
-      type: 'timestamp',
-      notNull: true,
-      default: pgm.func('current_timestamp')
-    }
-  }, { ifNotExists: true });
-
-  // Add index with IF NOT EXISTS
-  pgm.createIndex('users', 'name', {
-    name: 'idx_users_name',
-    ifNotExists: true
-  });
-};
-
-exports.down = pgm => {
-  // Drop in reverse order
-  pgm.dropIndex('users', 'name', { 
-    name: 'idx_users_name', 
-    ifExists: true 
-  });
-  
-  pgm.dropTable('users', { ifExists: true });
-};
-```
-
-## Migration History
-
-The `pgmigrations` table tracks which migrations have been run. Do not modify this table manually.
-
-## Converting from SQL Migrations
-
-When converting SQL migrations to node-pg-migrate format:
-
-1. Wrap SQL statements in `pgm.sql()` calls
-2. Use node-pg-migrate helper methods where possible (createTable, addColumns, etc.)
-3. Always include `IF EXISTS/IF NOT EXISTS` checks
-4. Ensure proper rollback logic in the `down` function
--- a/worklenz-backend/database/sql/1_tables.sql
+++ b/worklenz-backend/database/sql/1_tables.sql
@@ -25,6 +25,13 @@ CREATE TABLE IF NOT EXISTS pg_sessions (
    expire TIMESTAMP(6) NOT NULL
 );

+-- Create pgmigrations table for node-pg-migrate
+CREATE TABLE IF NOT EXISTS pgmigrations (
+    id      SERIAL                              PRIMARY KEY,
+    name    VARCHAR(255)                        NOT NULL,
+    run_on  TIMESTAMP WITH TIME ZONE            NOT NULL
+);
+
 CREATE TABLE IF NOT EXISTS project_access_levels (
    id   UUID DEFAULT uuid_generate_v4() NOT NULL,
    name TEXT                            NOT NULL,
@@ -2297,60 +2304,3 @@ ALTER TABLE organization_working_days
 ALTER TABLE organization_working_days
    ADD CONSTRAINT org_organization_id_fk
        FOREIGN KEY (organization_id) REFERENCES organizations;
-
-- Survey tables for account setup questionnaire
-CREATE TABLE IF NOT EXISTS surveys (
-    id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
-    name VARCHAR(255) NOT NULL,
-    description TEXT,
-    survey_type VARCHAR(50) DEFAULT 'account_setup' NOT NULL,
-    is_active BOOLEAN DEFAULT TRUE NOT NULL,
-    created_at TIMESTAMP DEFAULT now() NOT NULL,
-    updated_at TIMESTAMP DEFAULT now() NOT NULL
-);
-
-CREATE TABLE IF NOT EXISTS survey_questions (
-    id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
-    survey_id UUID REFERENCES surveys(id) ON DELETE CASCADE NOT NULL,
-    question_key VARCHAR(100) NOT NULL,
-    question_type VARCHAR(50) NOT NULL,
-    is_required BOOLEAN DEFAULT FALSE NOT NULL,
-    sort_order INTEGER DEFAULT 0 NOT NULL,
-    options JSONB,
-    created_at TIMESTAMP DEFAULT now() NOT NULL,
-    updated_at TIMESTAMP DEFAULT now() NOT NULL
-);
-
-CREATE TABLE IF NOT EXISTS survey_responses (
-    id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
-    survey_id UUID REFERENCES surveys(id) ON DELETE CASCADE NOT NULL,
-    user_id UUID REFERENCES users(id) ON DELETE CASCADE NOT NULL,
-    is_completed BOOLEAN DEFAULT FALSE NOT NULL,
-    started_at TIMESTAMP DEFAULT now() NOT NULL,
-    completed_at TIMESTAMP,
-    created_at TIMESTAMP DEFAULT now() NOT NULL,
-    updated_at TIMESTAMP DEFAULT now() NOT NULL
-);
-
-CREATE TABLE IF NOT EXISTS survey_answers (
-    id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
-    response_id UUID REFERENCES survey_responses(id) ON DELETE CASCADE NOT NULL,
-    question_id UUID REFERENCES survey_questions(id) ON DELETE CASCADE NOT NULL,
-    answer_text TEXT,
-    answer_json JSONB,
-    created_at TIMESTAMP DEFAULT now() NOT NULL,
-    updated_at TIMESTAMP DEFAULT now() NOT NULL
-);
-
-- Survey table indexes
-CREATE INDEX IF NOT EXISTS idx_surveys_type_active ON surveys(survey_type, is_active);
-CREATE INDEX IF NOT EXISTS idx_survey_questions_survey_order ON survey_questions(survey_id, sort_order);
-CREATE INDEX IF NOT EXISTS idx_survey_responses_user_survey ON survey_responses(user_id, survey_id);
-CREATE INDEX IF NOT EXISTS idx_survey_responses_completed ON survey_responses(survey_id, is_completed);
-CREATE INDEX IF NOT EXISTS idx_survey_answers_response ON survey_answers(response_id);
-
-- Survey table constraints
-ALTER TABLE survey_questions ADD CONSTRAINT survey_questions_sort_order_check CHECK (sort_order >= 0);
-ALTER TABLE survey_questions ADD CONSTRAINT survey_questions_type_check CHECK (question_type IN ('single_choice', 'multiple_choice', 'text'));
-ALTER TABLE survey_responses ADD CONSTRAINT unique_user_survey_response UNIQUE (user_id, survey_id);
-ALTER TABLE survey_answers ADD CONSTRAINT unique_response_question_answer UNIQUE (response_id, question_id);
--- a/worklenz-backend/database/sql/2_dml.sql
+++ b/worklenz-backend/database/sql/2_dml.sql
@@ -142,25 +142,3 @@ DROP FUNCTION sys_insert_license_types();
 INSERT INTO timezones (name, abbrev, utc_offset)
 SELECT name, abbrev, utc_offset
 FROM pg_timezone_names;
-
-- Insert default account setup survey
-INSERT INTO surveys (name, description, survey_type, is_active) VALUES 
-('Account Setup Survey', 'Initial questionnaire during account setup to understand user needs', 'account_setup', true)
-ON CONFLICT DO NOTHING;
-
-- Insert survey questions for account setup survey
-DO $$
-DECLARE
-    survey_uuid UUID;
-BEGIN
-    SELECT id INTO survey_uuid FROM surveys WHERE survey_type = 'account_setup' AND name = 'Account Setup Survey' LIMIT 1;
-    
-    -- Insert survey questions
-    INSERT INTO survey_questions (survey_id, question_key, question_type, is_required, sort_order, options) VALUES
-    (survey_uuid, 'organization_type', 'single_choice', true, 1, '["freelancer", "startup", "small_medium_business", "agency", "enterprise", "other"]'),
-    (survey_uuid, 'user_role', 'single_choice', true, 2, '["founder_ceo", "project_manager", "software_developer", "designer", "operations", "other"]'),
-    (survey_uuid, 'main_use_cases', 'multiple_choice', true, 3, '["task_management", "team_collaboration", "resource_planning", "client_communication", "time_tracking", "other"]'),
-    (survey_uuid, 'previous_tools', 'text', false, 4, null),
-    (survey_uuid, 'how_heard_about', 'single_choice', false, 5, '["google_search", "twitter", "linkedin", "friend_colleague", "blog_article", "other"]')
-    ON CONFLICT DO NOTHING;
-END $$;
--- a/worklenz-backend/database/sql/indexes.sql
+++ b/worklenz-backend/database/sql/indexes.sql
@@ -132,139 +132,3 @@ CREATE INDEX IF NOT EXISTS projects_team_id_index
 CREATE INDEX IF NOT EXISTS projects_team_id_name_index
    ON projects (team_id, name);

-- Performance indexes for optimized tasks queries
-- From migration: 20250115000000-performance-indexes.sql
-
-- Composite index for main task filtering
-CREATE INDEX CONCURRENTLY IF NOT EXISTS idx_tasks_project_archived_parent 
-ON tasks(project_id, archived, parent_task_id) 
-WHERE archived = FALSE;
-
-- Index for status joins
-CREATE INDEX CONCURRENTLY IF NOT EXISTS idx_tasks_status_project 
-ON tasks(status_id, project_id) 
-WHERE archived = FALSE;
-
-- Index for assignees lookup
-CREATE INDEX CONCURRENTLY IF NOT EXISTS idx_tasks_assignees_task_member 
-ON tasks_assignees(task_id, team_member_id);
-
-- Index for phase lookup
-CREATE INDEX CONCURRENTLY IF NOT EXISTS idx_task_phase_task_phase 
-ON task_phase(task_id, phase_id);
-
-- Index for subtask counting
-CREATE INDEX CONCURRENTLY IF NOT EXISTS idx_tasks_parent_archived 
-ON tasks(parent_task_id, archived) 
-WHERE parent_task_id IS NOT NULL AND archived = FALSE;
-
-- Index for labels
-CREATE INDEX CONCURRENTLY IF NOT EXISTS idx_task_labels_task_label 
-ON task_labels(task_id, label_id);
-
-- Index for comments count
-CREATE INDEX CONCURRENTLY IF NOT EXISTS idx_task_comments_task 
-ON task_comments(task_id);
-
-- Index for attachments count
-CREATE INDEX CONCURRENTLY IF NOT EXISTS idx_task_attachments_task 
-ON task_attachments(task_id);
-
-- Index for work log aggregation
-CREATE INDEX CONCURRENTLY IF NOT EXISTS idx_task_work_log_task 
-ON task_work_log(task_id);
-
-- Index for subscribers check
-CREATE INDEX CONCURRENTLY IF NOT EXISTS idx_task_subscribers_task 
-ON task_subscribers(task_id);
-
-- Index for dependencies check
-CREATE INDEX CONCURRENTLY IF NOT EXISTS idx_task_dependencies_task 
-ON task_dependencies(task_id);
-
-- Index for timers lookup
-CREATE INDEX CONCURRENTLY IF NOT EXISTS idx_task_timers_task_user 
-ON task_timers(task_id, user_id);
-
-- Index for custom columns
-CREATE INDEX CONCURRENTLY IF NOT EXISTS idx_cc_column_values_task 
-ON cc_column_values(task_id);
-
-- Index for team member info view optimization
-CREATE INDEX CONCURRENTLY IF NOT EXISTS idx_team_members_team_user 
-ON team_members(team_id, user_id) 
-WHERE active = TRUE;
-
-- Index for notification settings
-CREATE INDEX CONCURRENTLY IF NOT EXISTS idx_notification_settings_user_team 
-ON notification_settings(user_id, team_id);
-
-- Index for task status categories
-CREATE INDEX CONCURRENTLY IF NOT EXISTS idx_task_statuses_category 
-ON task_statuses(category_id, project_id);
-
-- Index for project phases
-CREATE INDEX CONCURRENTLY IF NOT EXISTS idx_project_phases_project_sort 
-ON project_phases(project_id, sort_index);
-
-- Index for task priorities
-CREATE INDEX CONCURRENTLY IF NOT EXISTS idx_task_priorities_value 
-ON task_priorities(value);
-
-- Index for team labels
-CREATE INDEX CONCURRENTLY IF NOT EXISTS idx_team_labels_team 
-ON team_labels(team_id);
-
-- Advanced performance indexes for task optimization
-
-- Composite index for task main query optimization (covers most WHERE conditions)
-CREATE INDEX CONCURRENTLY IF NOT EXISTS idx_tasks_performance_main
-ON tasks(project_id, archived, parent_task_id, status_id, priority_id)
-WHERE archived = FALSE;
-
-- Index for sorting by sort_order with project filter
-CREATE INDEX CONCURRENTLY IF NOT EXISTS idx_tasks_project_sort_order
-ON tasks(project_id, sort_order)
-WHERE archived = FALSE;
-
-- Index for email_invitations to optimize team_member_info_view
-CREATE INDEX CONCURRENTLY IF NOT EXISTS idx_email_invitations_team_member
-ON email_invitations(team_member_id);
-
-- Covering index for task status with category information
-CREATE INDEX CONCURRENTLY IF NOT EXISTS idx_task_statuses_covering
-ON task_statuses(id, category_id, project_id);
-
-- Index for task aggregation queries (parent task progress calculation)
-CREATE INDEX CONCURRENTLY IF NOT EXISTS idx_tasks_parent_status_archived
-ON tasks(parent_task_id, status_id, archived)
-WHERE archived = FALSE;
-
-- Index for project team member filtering
-CREATE INDEX CONCURRENTLY IF NOT EXISTS idx_team_members_project_lookup
-ON team_members(team_id, active, user_id)
-WHERE active = TRUE;
-
-- Covering index for tasks with frequently accessed columns
-CREATE INDEX CONCURRENTLY IF NOT EXISTS idx_tasks_covering_main
-ON tasks(id, project_id, archived, parent_task_id, status_id, priority_id, sort_order, name)
-WHERE archived = FALSE;
-
-- Index for task search functionality
-CREATE INDEX CONCURRENTLY IF NOT EXISTS idx_tasks_name_search
-ON tasks USING gin(to_tsvector('english', name))
-WHERE archived = FALSE;
-
-- Index for date-based filtering (if used)
-CREATE INDEX CONCURRENTLY IF NOT EXISTS idx_tasks_dates
-ON tasks(project_id, start_date, end_date)
-WHERE archived = FALSE;
-
-- Index for task timers with user filtering
-CREATE INDEX CONCURRENTLY IF NOT EXISTS idx_task_timers_user_task
-ON task_timers(user_id, task_id);
-
-- Index for sys_task_status_categories lookups
-CREATE INDEX CONCURRENTLY IF NOT EXISTS idx_sys_task_status_categories_covering
-ON sys_task_status_categories(id, color_code, color_code_dark, is_done, is_doing, is_todo);
-
--- a/worklenz-backend/migrate.json
+++ b/worklenz-backend/migrate.json
@@ -0,0 +1,22 @@
+{
+  "migrations-dir": "database/pg-migrations",
+  "migrations-schema": "public",
+  "migrations-table": "pgmigrations",
+  "db": {
+    "user": {
+      "ENV": "DB_USER"
+    },
+    "password": {
+      "ENV": "DB_PASSWORD"
+    },
+    "host": {
+      "ENV": "DB_HOST"
+    },
+    "port": {
+      "ENV": "DB_PORT"
+    },
+    "database": {
+      "ENV": "DB_NAME"
+    }
+  }
+}
--- a/worklenz-backend/package-lock.json
+++ b/worklenz-backend/package-lock.json
@@ -33,7 +33,6 @@
        "express-rate-limit": "^6.8.0",
        "express-session": "^1.17.3",
        "express-validator": "^6.15.0",
-        "grunt-cli": "^1.5.0",
        "helmet": "^6.2.0",
        "hpp": "^0.2.3",
        "http-errors": "^2.0.0",
@@ -116,6 +115,7 @@
        "jest": "^28.1.3",
        "jest-sonar-reporter": "^2.0.0",
        "ncp": "^2.0.0",
+        "node-pg-migrate": "^8.0.3",
        "nodeman": "^1.1.2",
        "rimraf": "^6.0.1",
        "swagger-jsdoc": "^6.2.8",
@@ -126,7 +126,7 @@
        "typescript": "^4.9.5"
      },
      "engines": {
-        "node": ">=16.13.0",
+        "node": ">=20.0.0",
        "npm": ">=8.11.0",
        "yarn": "WARNING: Please use npm package manager instead of yarn"
      }
@@ -6455,30 +6455,12 @@
      "dev": true,
      "license": "Python-2.0"
    },
-    "node_modules/array-each": {
-      "version": "1.0.1",
-      "resolved": "https://registry.npmjs.org/array-each/-/array-each-1.0.1.tgz",
-      "integrity": "sha512-zHjL5SZa68hkKHBFBK6DJCTtr9sfTCPCaph/L7tMSLcTFgy+zX7E+6q5UArbtOtMBCtxdICpfTCspRse+ywyXA==",
-      "license": "MIT",
-      "engines": {
-        "node": ">=0.10.0"
-      }
-    },
    "node_modules/array-flatten": {
      "version": "1.1.1",
      "resolved": "https://registry.npmjs.org/array-flatten/-/array-flatten-1.1.1.tgz",
      "integrity": "sha512-PCVAQswWemu6UdxsDFFX/+gVeYqKAod3D3UVm91jHwynguOwAvYPhx8nNlM++NqRcK6CxxpUafjmhIdKiHibqg==",
      "license": "MIT"
    },
-    "node_modules/array-slice": {
-      "version": "1.1.0",
-      "resolved": "https://registry.npmjs.org/array-slice/-/array-slice-1.1.0.tgz",
-      "integrity": "sha512-B1qMD3RBP7O8o0H2KbrXDyB0IccejMF15+87Lvlor12ONPRHP6gTjXMNkt/d3ZuOGbAe66hFmaCfECI24Ufp6w==",
-      "license": "MIT",
-      "engines": {
-        "node": ">=0.10.0"
-      }
-    },
    "node_modules/array-union": {
      "version": "2.1.0",
      "resolved": "https://registry.npmjs.org/array-union/-/array-union-2.1.0.tgz",
@@ -6951,6 +6933,7 @@
      "version": "3.0.3",
      "resolved": "https://registry.npmjs.org/braces/-/braces-3.0.3.tgz",
      "integrity": "sha512-yQbXgO/OSZVD2IsiLlro+7Hf6Q18EJrKSEsdoMzKePKXct3gvD8oLcOQdIzGupr5Fj+EDe8gO/lxc1BzfMpxvA==",
+      "dev": true,
      "license": "MIT",
      "dependencies": {
        "fill-range": "^7.1.1"
@@ -8056,15 +8039,6 @@
        "npm": "1.2.8000 || >= 1.4.16"
      }
    },
-    "node_modules/detect-file": {
-      "version": "1.0.0",
-      "resolved": "https://registry.npmjs.org/detect-file/-/detect-file-1.0.0.tgz",
-      "integrity": "sha512-DtCOLG98P007x7wiiOmfI0fi3eIKyWiLTGJ2MDnVi/E04lWGbf+JzrRHMm0rgIIZJGtHpKpbVgLWHrv8xXpc3Q==",
-      "license": "MIT",
-      "engines": {
-        "node": ">=0.10.0"
-      }
-    },
    "node_modules/detect-libc": {
      "version": "2.0.4",
      "resolved": "https://registry.npmjs.org/detect-libc/-/detect-libc-2.0.4.tgz",
@@ -8924,18 +8898,6 @@
        "node": ">=6"
      }
    },
-    "node_modules/expand-tilde": {
-      "version": "2.0.2",
-      "resolved": "https://registry.npmjs.org/expand-tilde/-/expand-tilde-2.0.2.tgz",
-      "integrity": "sha512-A5EmesHW6rfnZ9ysHQjPdJRni0SRar0tjtG5MNtm9n5TUvsYU8oozprtRD4AqHxcZWWlVuAmQo2nWKfN9oyjTw==",
-      "license": "MIT",
-      "dependencies": {
-        "homedir-polyfill": "^1.0.1"
-      },
-      "engines": {
-        "node": ">=0.10.0"
-      }
-    },
    "node_modules/expect": {
      "version": "28.1.3",
      "resolved": "https://registry.npmjs.org/expect/-/expect-28.1.3.tgz",
@@ -9088,12 +9050,6 @@
      "integrity": "sha512-Tpp60P6IUJDTuOq/5Z8cdskzJujfwqfOTkrwIwj7IRISpnkJnT6SyJ4PCPnGMoFjC9ddhal5KVIYtAt97ix05A==",
      "license": "MIT"
    },
-    "node_modules/extend": {
-      "version": "3.0.2",
-      "resolved": "https://registry.npmjs.org/extend/-/extend-3.0.2.tgz",
-      "integrity": "sha512-fjquC59cD7CyW6urNXK0FBufkZcoiGG80wTuPujX590cB5Ttln20E2UB4S/WARVqhXffZl2LNgS+gQdPIIim/g==",
-      "license": "MIT"
-    },
    "node_modules/fast-csv": {
      "version": "4.3.6",
      "resolved": "https://registry.npmjs.org/fast-csv/-/fast-csv-4.3.6.tgz",
@@ -9222,6 +9178,7 @@
      "version": "7.1.1",
      "resolved": "https://registry.npmjs.org/fill-range/-/fill-range-7.1.1.tgz",
      "integrity": "sha512-YsGpe3WHLK8ZYi4tWDg2Jy3ebRz2rXowDxnld4bkQB00cc/1Zw9AWnC0i9ztDJitivtQvaI9KaLyKrc+hBW0yg==",
+      "dev": true,
      "license": "MIT",
      "dependencies": {
        "to-regex-range": "^5.0.1"
@@ -9287,46 +9244,6 @@
        "url": "https://github.com/sponsors/sindresorhus"
      }
    },
-    "node_modules/findup-sync": {
-      "version": "4.0.0",
-      "resolved": "https://registry.npmjs.org/findup-sync/-/findup-sync-4.0.0.tgz",
-      "integrity": "sha512-6jvvn/12IC4quLBL1KNokxC7wWTvYncaVUYSoxWw7YykPLuRrnv4qdHcSOywOI5RpkOVGeQRtWM8/q+G6W6qfQ==",
-      "license": "MIT",
-      "dependencies": {
-        "detect-file": "^1.0.0",
-        "is-glob": "^4.0.0",
-        "micromatch": "^4.0.2",
-        "resolve-dir": "^1.0.1"
-      },
-      "engines": {
-        "node": ">= 8"
-      }
-    },
-    "node_modules/fined": {
-      "version": "1.2.0",
-      "resolved": "https://registry.npmjs.org/fined/-/fined-1.2.0.tgz",
-      "integrity": "sha512-ZYDqPLGxDkDhDZBjZBb+oD1+j0rA4E0pXY50eplAAOPg2N/gUBSSk5IM1/QhPfyVo19lJ+CvXpqfvk+b2p/8Ng==",
-      "license": "MIT",
-      "dependencies": {
-        "expand-tilde": "^2.0.2",
-        "is-plain-object": "^2.0.3",
-        "object.defaults": "^1.1.0",
-        "object.pick": "^1.2.0",
-        "parse-filepath": "^1.0.1"
-      },
-      "engines": {
-        "node": ">= 0.10"
-      }
-    },
-    "node_modules/flagged-respawn": {
-      "version": "1.0.1",
-      "resolved": "https://registry.npmjs.org/flagged-respawn/-/flagged-respawn-1.0.1.tgz",
-      "integrity": "sha512-lNaHNVymajmk0OJMBn8fVUAU1BtDeKIqKoVhk4xAALB57aALg6b4W0MfJ/cUE0g9YBXy5XhSlPIpYIJ7HaY/3Q==",
-      "license": "MIT",
-      "engines": {
-        "node": ">= 0.10"
-      }
-    },
    "node_modules/flat-cache": {
      "version": "3.2.0",
      "resolved": "https://registry.npmjs.org/flat-cache/-/flat-cache-3.2.0.tgz",
@@ -9427,27 +9344,6 @@
        }
      }
    },
-    "node_modules/for-in": {
-      "version": "1.0.2",
-      "resolved": "https://registry.npmjs.org/for-in/-/for-in-1.0.2.tgz",
-      "integrity": "sha512-7EwmXrOjyL+ChxMhmG5lnW9MPt1aIeZEwKhQzoBUdTV0N3zuwWDZYVJatDvZ2OyzPUvdIAZDsCetk3coyMfcnQ==",
-      "license": "MIT",
-      "engines": {
-        "node": ">=0.10.0"
-      }
-    },
-    "node_modules/for-own": {
-      "version": "1.0.0",
-      "resolved": "https://registry.npmjs.org/for-own/-/for-own-1.0.0.tgz",
-      "integrity": "sha512-0OABksIGrxKK8K4kynWkQ7y1zounQxP+CWnyclVwj81KW3vlLlGUx57DKGcP/LH216GzqnstnPocF16Nxs0Ycg==",
-      "license": "MIT",
-      "dependencies": {
-        "for-in": "^1.0.1"
-      },
-      "engines": {
-        "node": ">=0.10.0"
-      }
-    },
    "node_modules/foreground-child": {
      "version": "3.3.1",
      "resolved": "https://registry.npmjs.org/foreground-child/-/foreground-child-3.3.1.tgz",
@@ -9845,48 +9741,6 @@
        "node": ">= 0.10"
      }
    },
-    "node_modules/global-modules": {
-      "version": "1.0.0",
-      "resolved": "https://registry.npmjs.org/global-modules/-/global-modules-1.0.0.tgz",
-      "integrity": "sha512-sKzpEkf11GpOFuw0Zzjzmt4B4UZwjOcG757PPvrfhxcLFbq0wpsgpOqxpxtxFiCG4DtG93M6XRVbF2oGdev7bg==",
-      "license": "MIT",
-      "dependencies": {
-        "global-prefix": "^1.0.1",
-        "is-windows": "^1.0.1",
-        "resolve-dir": "^1.0.0"
-      },
-      "engines": {
-        "node": ">=0.10.0"
-      }
-    },
-    "node_modules/global-prefix": {
-      "version": "1.0.2",
-      "resolved": "https://registry.npmjs.org/global-prefix/-/global-prefix-1.0.2.tgz",
-      "integrity": "sha512-5lsx1NUDHtSjfg0eHlmYvZKv8/nVqX4ckFbM+FrGcQ+04KWcWFo9P5MxPZYSzUvyzmdTbI7Eix8Q4IbELDqzKg==",
-      "license": "MIT",
-      "dependencies": {
-        "expand-tilde": "^2.0.2",
-        "homedir-polyfill": "^1.0.1",
-        "ini": "^1.3.4",
-        "is-windows": "^1.0.1",
-        "which": "^1.2.14"
-      },
-      "engines": {
-        "node": ">=0.10.0"
-      }
-    },
-    "node_modules/global-prefix/node_modules/which": {
-      "version": "1.3.1",
-      "resolved": "https://registry.npmjs.org/which/-/which-1.3.1.tgz",
-      "integrity": "sha512-HxJdYWq1MTIQbJ3nw0cqssHoTNU267KlrDuGZ1WYlxDStUtKUhOaJmh112/TZmHxxUfuJqPXSOm7tDyas0OSIQ==",
-      "license": "ISC",
-      "dependencies": {
-        "isexe": "^2.0.0"
-      },
-      "bin": {
-        "which": "bin/which"
-      }
-    },
    "node_modules/globals": {
      "version": "11.12.0",
      "resolved": "https://registry.npmjs.org/globals/-/globals-11.12.0.tgz",
@@ -9943,34 +9797,6 @@
      "dev": true,
      "license": "MIT"
    },
-    "node_modules/grunt-cli": {
-      "version": "1.5.0",
-      "resolved": "https://registry.npmjs.org/grunt-cli/-/grunt-cli-1.5.0.tgz",
-      "integrity": "sha512-rILKAFoU0dzlf22SUfDtq2R1fosChXXlJM5j7wI6uoW8gwmXDXzbUvirlKZSYCdXl3LXFbR+8xyS+WFo+b6vlA==",
-      "license": "MIT",
-      "dependencies": {
-        "grunt-known-options": "~2.0.0",
-        "interpret": "~1.1.0",
-        "liftup": "~3.0.1",
-        "nopt": "~5.0.0",
-        "v8flags": "^4.0.1"
-      },
-      "bin": {
-        "grunt": "bin/grunt"
-      },
-      "engines": {
-        "node": ">=10"
-      }
-    },
-    "node_modules/grunt-known-options": {
-      "version": "2.0.0",
-      "resolved": "https://registry.npmjs.org/grunt-known-options/-/grunt-known-options-2.0.0.tgz",
-      "integrity": "sha512-GD7cTz0I4SAede1/+pAbmJRG44zFLPipVtdL9o3vqx9IEyb7b4/Y3s7r6ofI3CchR5GvYJ+8buCSioDv5dQLiA==",
-      "license": "MIT",
-      "engines": {
-        "node": ">=0.10.0"
-      }
-    },
    "node_modules/has-flag": {
      "version": "4.0.0",
      "resolved": "https://registry.npmjs.org/has-flag/-/has-flag-4.0.0.tgz",
@@ -10042,18 +9868,6 @@
      "dev": true,
      "license": "https://www.highcharts.com/license"
    },
-    "node_modules/homedir-polyfill": {
-      "version": "1.0.3",
-      "resolved": "https://registry.npmjs.org/homedir-polyfill/-/homedir-polyfill-1.0.3.tgz",
-      "integrity": "sha512-eSmmWE5bZTK2Nou4g0AI3zZ9rswp7GRKoKXS1BLUkvPviOqs4YTN1djQIqrXy9k5gEtdLPy86JjRwsNM9tnDcA==",
-      "license": "MIT",
-      "dependencies": {
-        "parse-passwd": "^1.0.0"
-      },
-      "engines": {
-        "node": ">=0.10.0"
-      }
-    },
    "node_modules/hpp": {
      "version": "0.2.3",
      "resolved": "https://registry.npmjs.org/hpp/-/hpp-0.2.3.tgz",
@@ -10263,12 +10077,6 @@
      "integrity": "sha512-JV/yugV2uzW5iMRSiZAyDtQd+nxtUnjeLt0acNdw98kKLrvuRVyB80tsREOE7yvGVgalhZ6RNXCmEHkUKBKxew==",
      "license": "ISC"
    },
-    "node_modules/interpret": {
-      "version": "1.1.0",
-      "resolved": "https://registry.npmjs.org/interpret/-/interpret-1.1.0.tgz",
-      "integrity": "sha512-CLM8SNMDu7C5psFCn6Wg/tgpj/bKAg7hc2gWqcuR9OD5Ft9PhBpIu8PLicPeis+xDd6YX2ncI8MCA64I9tftIA==",
-      "license": "MIT"
-    },
    "node_modules/ipaddr.js": {
      "version": "1.9.1",
      "resolved": "https://registry.npmjs.org/ipaddr.js/-/ipaddr.js-1.9.1.tgz",
@@ -10278,19 +10086,6 @@
        "node": ">= 0.10"
      }
    },
-    "node_modules/is-absolute": {
-      "version": "1.0.0",
-      "resolved": "https://registry.npmjs.org/is-absolute/-/is-absolute-1.0.0.tgz",
-      "integrity": "sha512-dOWoqflvcydARa360Gvv18DZ/gRuHKi2NU/wU5X1ZFzdYfH29nkiNZsF3mp4OJ3H4yo9Mx8A/uAGNzpzPN3yBA==",
-      "license": "MIT",
-      "dependencies": {
-        "is-relative": "^1.0.0",
-        "is-windows": "^1.0.1"
-      },
-      "engines": {
-        "node": ">=0.10.0"
-      }
-    },
    "node_modules/is-arrayish": {
      "version": "0.2.1",
      "resolved": "https://registry.npmjs.org/is-arrayish/-/is-arrayish-0.2.1.tgz",
@@ -10352,6 +10147,7 @@
      "version": "2.1.1",
      "resolved": "https://registry.npmjs.org/is-extglob/-/is-extglob-2.1.1.tgz",
      "integrity": "sha512-SbKbANkN603Vi4jEZv49LeVJMn4yGwsbzZworEoyEiutsN3nJYdbO36zfhGJ6QEDpOZIFkDtnq5JRxmvl3jsoQ==",
+      "dev": true,
      "license": "MIT",
      "engines": {
        "node": ">=0.10.0"
@@ -10380,6 +10176,7 @@
      "version": "4.0.3",
      "resolved": "https://registry.npmjs.org/is-glob/-/is-glob-4.0.3.tgz",
      "integrity": "sha512-xelSayHH36ZgE7ZWhli7pW34hNbNl8Ojv5KVmkJD4hBdD3th8Tfk9vYasLM+mXWOZhFkgZfxhLSnrwRr4elSSg==",
+      "dev": true,
      "license": "MIT",
      "dependencies": {
        "is-extglob": "^2.1.1"
@@ -10392,6 +10189,7 @@
      "version": "7.0.0",
      "resolved": "https://registry.npmjs.org/is-number/-/is-number-7.0.0.tgz",
      "integrity": "sha512-41Cifkg6e8TylSpdtTpeLVMqvSBEVzTttHvERD741+pnZ8ANv0004MRL43QKPDlK9cGvNp6NZWZUBlbGXYxxng==",
+      "dev": true,
      "license": "MIT",
      "engines": {
        "node": ">=0.12.0"
@@ -10407,18 +10205,6 @@
        "node": ">=8"
      }
    },
-    "node_modules/is-plain-object": {
-      "version": "2.0.4",
-      "resolved": "https://registry.npmjs.org/is-plain-object/-/is-plain-object-2.0.4.tgz",
-      "integrity": "sha512-h5PpgXkWitc38BBMYawTYMWJHFZJVnBquFE57xFpjB8pJFiF6gZ+bU+WyI/yqXiFR5mdLsgYNaPe8uao6Uv9Og==",
-      "license": "MIT",
-      "dependencies": {
-        "isobject": "^3.0.1"
-      },
-      "engines": {
-        "node": ">=0.10.0"
-      }
-    },
    "node_modules/is-promise": {
      "version": "2.2.2",
      "resolved": "https://registry.npmjs.org/is-promise/-/is-promise-2.2.2.tgz",
@@ -10443,18 +10229,6 @@
        "url": "https://github.com/sponsors/ljharb"
      }
    },
-    "node_modules/is-relative": {
-      "version": "1.0.0",
-      "resolved": "https://registry.npmjs.org/is-relative/-/is-relative-1.0.0.tgz",
-      "integrity": "sha512-Kw/ReK0iqwKeu0MITLFuj0jbPAmEiOsIwyIXvvbfa6QfmN9pkD1M+8pdk7Rl/dTKbH34/XBFMbgD4iMJhLQbGA==",
-      "license": "MIT",
-      "dependencies": {
-        "is-unc-path": "^1.0.0"
-      },
-      "engines": {
-        "node": ">=0.10.0"
-      }
-    },
    "node_modules/is-stream": {
      "version": "2.0.1",
      "resolved": "https://registry.npmjs.org/is-stream/-/is-stream-2.0.1.tgz",
@@ -10467,27 +10241,6 @@
        "url": "https://github.com/sponsors/sindresorhus"
      }
    },
-    "node_modules/is-unc-path": {
-      "version": "1.0.0",
-      "resolved": "https://registry.npmjs.org/is-unc-path/-/is-unc-path-1.0.0.tgz",
-      "integrity": "sha512-mrGpVd0fs7WWLfVsStvgF6iEJnbjDFZh9/emhRDcGWTduTfNHd9CHeUwH3gYIjdbwo4On6hunkztwOaAw0yllQ==",
-      "license": "MIT",
-      "dependencies": {
-        "unc-path-regex": "^0.1.2"
-      },
-      "engines": {
-        "node": ">=0.10.0"
-      }
-    },
-    "node_modules/is-windows": {
-      "version": "1.0.2",
-      "resolved": "https://registry.npmjs.org/is-windows/-/is-windows-1.0.2.tgz",
-      "integrity": "sha512-eXK1UInq2bPmjyX6e3VHIzMLobc4J94i4AWn+Hpq3OU5KkrRC96OAcR3PRJ/pGu6m8TRnBHP9dkXQVsT/COVIA==",
-      "license": "MIT",
-      "engines": {
-        "node": ">=0.10.0"
-      }
-    },
    "node_modules/isarray": {
      "version": "1.0.0",
      "resolved": "https://registry.npmjs.org/isarray/-/isarray-1.0.0.tgz",
@@ -10498,17 +10251,9 @@
      "version": "2.0.0",
      "resolved": "https://registry.npmjs.org/isexe/-/isexe-2.0.0.tgz",
      "integrity": "sha512-RHxMLp9lnKHGHRng9QFhRCMbYAcVpn69smSGcq3f36xjgVVWThj4qqLbTLlq7Ssj8B+fIQ1EuCEGI2lKsyQeIw==",
+      "dev": true,
      "license": "ISC"
    },
-    "node_modules/isobject": {
-      "version": "3.0.1",
-      "resolved": "https://registry.npmjs.org/isobject/-/isobject-3.0.1.tgz",
-      "integrity": "sha512-WhB9zCku7EGTj/HQQRz5aUQEUeoQZH2bWcltRErOpymJ4boYE6wL9Tbr23krRPSZ+C5zqNSrSw+Cc7sZZ4b7vg==",
-      "license": "MIT",
-      "engines": {
-        "node": ">=0.10.0"
-      }
-    },
    "node_modules/istanbul-lib-coverage": {
      "version": "3.2.2",
      "resolved": "https://registry.npmjs.org/istanbul-lib-coverage/-/istanbul-lib-coverage-3.2.2.tgz",
@@ -11526,15 +11271,6 @@
        "json-buffer": "3.0.1"
      }
    },
-    "node_modules/kind-of": {
-      "version": "6.0.3",
-      "resolved": "https://registry.npmjs.org/kind-of/-/kind-of-6.0.3.tgz",
-      "integrity": "sha512-dcS1ul+9tmeD95T+x28/ehLgd9mENa3LsvDTtzm3vyBEO7RPptvAD+t44WVXaUjTBRcrpFeFlC8WCruUR456hw==",
-      "license": "MIT",
-      "engines": {
-        "node": ">=0.10.0"
-      }
-    },
    "node_modules/kleur": {
      "version": "3.0.3",
      "resolved": "https://registry.npmjs.org/kleur/-/kleur-3.0.3.tgz",
@@ -11626,25 +11362,6 @@
        "immediate": "~3.0.5"
      }
    },
-    "node_modules/liftup": {
-      "version": "3.0.1",
-      "resolved": "https://registry.npmjs.org/liftup/-/liftup-3.0.1.tgz",
-      "integrity": "sha512-yRHaiQDizWSzoXk3APcA71eOI/UuhEkNN9DiW2Tt44mhYzX4joFoCZlxsSOF7RyeLlfqzFLQI1ngFq3ggMPhOw==",
-      "license": "MIT",
-      "dependencies": {
-        "extend": "^3.0.2",
-        "findup-sync": "^4.0.0",
-        "fined": "^1.2.0",
-        "flagged-respawn": "^1.0.1",
-        "is-plain-object": "^2.0.4",
-        "object.map": "^1.0.1",
-        "rechoir": "^0.7.0",
-        "resolve": "^1.19.0"
-      },
-      "engines": {
-        "node": ">=10"
-      }
-    },
    "node_modules/lines-and-columns": {
      "version": "1.2.4",
      "resolved": "https://registry.npmjs.org/lines-and-columns/-/lines-and-columns-1.2.4.tgz",
@@ -11883,18 +11600,6 @@
      "dev": true,
      "license": "ISC"
    },
-    "node_modules/make-iterator": {
-      "version": "1.0.1",
-      "resolved": "https://registry.npmjs.org/make-iterator/-/make-iterator-1.0.1.tgz",
-      "integrity": "sha512-pxiuXh0iVEq7VM7KMIhs5gxsfxCux2URptUQaXo4iZZJxBAzTPOLE2BumO5dbfVYq/hBJFBR/a1mFDmOx5AGmw==",
-      "license": "MIT",
-      "dependencies": {
-        "kind-of": "^6.0.2"
-      },
-      "engines": {
-        "node": ">=0.10.0"
-      }
-    },
    "node_modules/makeerror": {
      "version": "1.0.12",
      "resolved": "https://registry.npmjs.org/makeerror/-/makeerror-1.0.12.tgz",
@@ -11905,15 +11610,6 @@
        "tmpl": "1.0.5"
      }
    },
-    "node_modules/map-cache": {
-      "version": "0.2.2",
-      "resolved": "https://registry.npmjs.org/map-cache/-/map-cache-0.2.2.tgz",
-      "integrity": "sha512-8y/eV9QQZCiyn1SprXSrCmqJN0yNRATe+PO8ztwqrvrbdRLA3eYJF0yaR0YayLWkMbsQSKWS9N2gPcGEc4UsZg==",
-      "license": "MIT",
-      "engines": {
-        "node": ">=0.10.0"
-      }
-    },
    "node_modules/math-intrinsics": {
      "version": "1.1.0",
      "resolved": "https://registry.npmjs.org/math-intrinsics/-/math-intrinsics-1.1.0.tgz",
@@ -11971,6 +11667,7 @@
      "version": "4.0.8",
      "resolved": "https://registry.npmjs.org/micromatch/-/micromatch-4.0.8.tgz",
      "integrity": "sha512-PXwfBhYu0hBCPw8Dn0E+WDYb7af3dSLVWKi3HGv84IdF4TyFoC0ysxFd0Goxw7nSv4T/PzEJQxsYsEiFCKo2BA==",
+      "dev": true,
      "license": "MIT",
      "dependencies": {
        "braces": "^3.0.3",
@@ -12318,6 +12015,32 @@
      "dev": true,
      "license": "MIT"
    },
+    "node_modules/node-pg-migrate": {
+      "version": "8.0.3",
+      "resolved": "https://registry.npmjs.org/node-pg-migrate/-/node-pg-migrate-8.0.3.tgz",
+      "integrity": "sha512-oKzZyzTULTryO1jehX19VnyPCGf3G/3oWZg3gODphvID56T0WjPOShTVPVnxGdlcueaIW3uAVrr7M8xLZq5TcA==",
+      "dev": true,
+      "license": "MIT",
+      "dependencies": {
+        "glob": "~11.0.0",
+        "yargs": "~17.7.0"
+      },
+      "bin": {
+        "node-pg-migrate": "bin/node-pg-migrate.js"
+      },
+      "engines": {
+        "node": ">=20.11.0"
+      },
+      "peerDependencies": {
+        "@types/pg": ">=6.0.0 <9.0.0",
+        "pg": ">=4.3.0 <9.0.0"
+      },
+      "peerDependenciesMeta": {
+        "@types/pg": {
+          "optional": true
+        }
+      }
+    },
    "node_modules/node-releases": {
      "version": "2.0.19",
      "resolved": "https://registry.npmjs.org/node-releases/-/node-releases-2.0.19.tgz",
@@ -12418,46 +12141,6 @@
        "url": "https://github.com/sponsors/ljharb"
      }
    },
-    "node_modules/object.defaults": {
-      "version": "1.1.0",
-      "resolved": "https://registry.npmjs.org/object.defaults/-/object.defaults-1.1.0.tgz",
-      "integrity": "sha512-c/K0mw/F11k4dEUBMW8naXUuBuhxRCfG7W+yFy8EcijU/rSmazOUd1XAEEe6bC0OuXY4HUKjTJv7xbxIMqdxrA==",
-      "license": "MIT",
-      "dependencies": {
-        "array-each": "^1.0.1",
-        "array-slice": "^1.0.0",
-        "for-own": "^1.0.0",
-        "isobject": "^3.0.0"
-      },
-      "engines": {
-        "node": ">=0.10.0"
-      }
-    },
-    "node_modules/object.map": {
-      "version": "1.0.1",
-      "resolved": "https://registry.npmjs.org/object.map/-/object.map-1.0.1.tgz",
-      "integrity": "sha512-3+mAJu2PLfnSVGHwIWubpOFLscJANBKuB/6A4CxBstc4aqwQY0FWcsppuy4jU5GSB95yES5JHSI+33AWuS4k6w==",
-      "license": "MIT",
-      "dependencies": {
-        "for-own": "^1.0.0",
-        "make-iterator": "^1.0.0"
-      },
-      "engines": {
-        "node": ">=0.10.0"
-      }
-    },
-    "node_modules/object.pick": {
-      "version": "1.3.0",
-      "resolved": "https://registry.npmjs.org/object.pick/-/object.pick-1.3.0.tgz",
-      "integrity": "sha512-tqa/UMy/CCoYmj+H5qc07qvSL9dqcs/WZENZ1JbtWBlATP+iVOe778gE6MSijnyCnORzDuX6hU+LA4SZ09YjFQ==",
-      "license": "MIT",
-      "dependencies": {
-        "isobject": "^3.0.1"
-      },
-      "engines": {
-        "node": ">=0.10.0"
-      }
-    },
    "node_modules/on-finished": {
      "version": "2.4.1",
      "resolved": "https://registry.npmjs.org/on-finished/-/on-finished-2.4.1.tgz",
@@ -12620,20 +12303,6 @@
        "node": ">=6"
      }
    },
-    "node_modules/parse-filepath": {
-      "version": "1.0.2",
-      "resolved": "https://registry.npmjs.org/parse-filepath/-/parse-filepath-1.0.2.tgz",
-      "integrity": "sha512-FwdRXKCohSVeXqwtYonZTXtbGJKrn+HNyWDYVcp5yuJlesTwNH4rsmRZ+GrKAPJ5bLpRxESMeS+Rl0VCHRvB2Q==",
-      "license": "MIT",
-      "dependencies": {
-        "is-absolute": "^1.0.0",
-        "map-cache": "^0.2.0",
-        "path-root": "^0.1.1"
-      },
-      "engines": {
-        "node": ">=0.8"
-      }
-    },
    "node_modules/parse-json": {
      "version": "5.2.0",
      "resolved": "https://registry.npmjs.org/parse-json/-/parse-json-5.2.0.tgz",
@@ -12653,15 +12322,6 @@
        "url": "https://github.com/sponsors/sindresorhus"
      }
    },
-    "node_modules/parse-passwd": {
-      "version": "1.0.0",
-      "resolved": "https://registry.npmjs.org/parse-passwd/-/parse-passwd-1.0.0.tgz",
-      "integrity": "sha512-1Y1A//QUXEZK7YKz+rD9WydcE1+EuPr6ZBgKecAB8tmoW6UFv0NREVJe1p+jRxtThkcbbKkfwIbWJe/IeE6m2Q==",
-      "license": "MIT",
-      "engines": {
-        "node": ">=0.10.0"
-      }
-    },
    "node_modules/parse-srcset": {
      "version": "1.0.2",
      "resolved": "https://registry.npmjs.org/parse-srcset/-/parse-srcset-1.0.2.tgz",
@@ -12800,27 +12460,6 @@
      "integrity": "sha512-LDJzPVEEEPR+y48z93A0Ed0yXb8pAByGWo/k5YYdYgpY2/2EsOsksJrq7lOHxryrVOn1ejG6oAp8ahvOIQD8sw==",
      "license": "MIT"
    },
-    "node_modules/path-root": {
-      "version": "0.1.1",
-      "resolved": "https://registry.npmjs.org/path-root/-/path-root-0.1.1.tgz",
-      "integrity": "sha512-QLcPegTHF11axjfojBIoDygmS2E3Lf+8+jI6wOVmNVenrKSo3mFdSGiIgdSHenczw3wPtlVMQaFVwGmM7BJdtg==",
-      "license": "MIT",
-      "dependencies": {
-        "path-root-regex": "^0.1.0"
-      },
-      "engines": {
-        "node": ">=0.10.0"
-      }
-    },
-    "node_modules/path-root-regex": {
-      "version": "0.1.2",
-      "resolved": "https://registry.npmjs.org/path-root-regex/-/path-root-regex-0.1.2.tgz",
-      "integrity": "sha512-4GlJ6rZDhQZFE0DPVKh0e9jmZ5egZfxTkp7bcRDuPlJXbAwhxcl2dINPUAsjLdejqaLsCeg8axcLjIbvBjN4pQ==",
-      "license": "MIT",
-      "engines": {
-        "node": ">=0.10.0"
-      }
-    },
    "node_modules/path-scurry": {
      "version": "2.0.0",
      "resolved": "https://registry.npmjs.org/path-scurry/-/path-scurry-2.0.0.tgz",
@@ -12968,6 +12607,7 @@
      "version": "2.3.1",
      "resolved": "https://registry.npmjs.org/picomatch/-/picomatch-2.3.1.tgz",
      "integrity": "sha512-JU3teHTNjmE2VCGFzuY8EXzCDVwEqB2a8fsIvwaStHhAWJEeVd1o1QD80CU6+ZdEXXSLbSsuLwJjkCBWqRQUVA==",
+      "dev": true,
      "license": "MIT",
      "engines": {
        "node": ">=8.6"
@@ -13563,18 +13203,6 @@
        "node": ">=8.10.0"
      }
    },
-    "node_modules/rechoir": {
-      "version": "0.7.1",
-      "resolved": "https://registry.npmjs.org/rechoir/-/rechoir-0.7.1.tgz",
-      "integrity": "sha512-/njmZ8s1wVeR6pjTZ+0nCnv8SpZNRMT2D1RLOJQESlYFDBvwpTA4KWJpZ+sBJ4+vhjILRcK7JIFdGCdxEAAitg==",
-      "license": "MIT",
-      "dependencies": {
-        "resolve": "^1.9.0"
-      },
-      "engines": {
-        "node": ">= 0.10"
-      }
-    },
    "node_modules/redis": {
      "version": "4.7.1",
      "resolved": "https://registry.npmjs.org/redis/-/redis-4.7.1.tgz",
@@ -13726,19 +13354,6 @@
        "node": ">=8"
      }
    },
-    "node_modules/resolve-dir": {
-      "version": "1.0.1",
-      "resolved": "https://registry.npmjs.org/resolve-dir/-/resolve-dir-1.0.1.tgz",
-      "integrity": "sha512-R7uiTjECzvOsWSfdM0QKFNBVFcK27aHOUwdvK53BcW8zqnGdYp0Fbj82cy54+2A4P2tFM22J5kRfe1R+lM/1yg==",
-      "license": "MIT",
-      "dependencies": {
-        "expand-tilde": "^2.0.0",
-        "global-modules": "^1.0.0"
-      },
-      "engines": {
-        "node": ">=0.10.0"
-      }
-    },
    "node_modules/resolve-from": {
      "version": "4.0.0",
      "resolved": "https://registry.npmjs.org/resolve-from/-/resolve-from-4.0.0.tgz",
@@ -14974,6 +14589,7 @@
      "version": "5.0.1",
      "resolved": "https://registry.npmjs.org/to-regex-range/-/to-regex-range-5.0.1.tgz",
      "integrity": "sha512-65P7iz6X5yEr1cwcgvQxbbIw7Uk3gOy5dIdtZ4rDveLqhrdJP+Li/Hx6tyK0NEb+2GCyneCMJiGqrADCSNk8sQ==",
+      "dev": true,
      "license": "MIT",
      "dependencies": {
        "is-number": "^7.0.0"
@@ -15494,15 +15110,6 @@
      "integrity": "sha512-IevTus0SbGwQzYh3+fRsAMTVVPOoIVufzacXcHPmdlle1jUpq7BRL+mw3dgeLanvGZdwwbWhRV6XrcFNdBmjWA==",
      "license": "MIT"
    },
-    "node_modules/unc-path-regex": {
-      "version": "0.1.2",
-      "resolved": "https://registry.npmjs.org/unc-path-regex/-/unc-path-regex-0.1.2.tgz",
-      "integrity": "sha512-eXL4nmJT7oCpkZsHZUOJo8hcX3GbsiDOa0Qu9F646fi8dT3XuSVopVqAcEiVzSKKH7UoDti23wNX3qGFxcW5Qg==",
-      "license": "MIT",
-      "engines": {
-        "node": ">=0.10.0"
-      }
-    },
    "node_modules/undici-types": {
      "version": "5.26.5",
      "resolved": "https://registry.npmjs.org/undici-types/-/undici-types-5.26.5.tgz",
@@ -15732,15 +15339,6 @@
        "node": ">=10.12.0"
      }
    },
-    "node_modules/v8flags": {
-      "version": "4.0.1",
-      "resolved": "https://registry.npmjs.org/v8flags/-/v8flags-4.0.1.tgz",
-      "integrity": "sha512-fcRLaS4H/hrZk9hYwbdRM35D0U8IYMfEClhXxCivOojl+yTRAZH3Zy2sSy6qVCiGbV9YAtPssP6jaChqC9vPCg==",
-      "license": "MIT",
-      "engines": {
-        "node": ">= 10.13.0"
-      }
-    },
    "node_modules/validator": {
      "version": "13.15.15",
      "resolved": "https://registry.npmjs.org/validator/-/validator-13.15.15.tgz",
--- a/worklenz-backend/package.json
+++ b/worklenz-backend/package.json
@@ -35,7 +35,12 @@
    "inline-queries": "node ./cli/inline-queries",
    "sonar": "sonar-scanner -Dproject.settings=sonar-project-dev.properties",
    "tsc": "tsc",
-    "test:watch": "jest --watch --setupFiles dotenv/config"
+    "test:watch": "jest --watch --setupFiles dotenv/config",
+    "migrate": "node-pg-migrate",
+    "migrate:up": "npm run migrate up",
+    "migrate:down": "npm run migrate down",
+    "migrate:create": "npm run migrate create",
+    "migrate:redo": "npm run migrate redo"
  },
  "jestSonar": {
    "reportPath": "coverage",
@@ -150,6 +155,7 @@
    "jest": "^28.1.3",
    "jest-sonar-reporter": "^2.0.0",
    "ncp": "^2.0.0",
+    "node-pg-migrate": "^8.0.3",
    "nodeman": "^1.1.2",
    "rimraf": "^6.0.1",
    "swagger-jsdoc": "^6.2.8",
--- a/worklenz-backend/src/controllers/gantt-controller.ts
+++ b/worklenz-backend/src/controllers/gantt-controller.ts
@@ -94,194 +94,4 @@ export default class GanttController extends WorklenzControllerBase {
    }
    return res.status(200).send(new ServerResponse(true, result.rows));
  }
-
-  @HandleExceptions()
-  public static async getRoadmapTasks(req: IWorkLenzRequest, res: IWorkLenzResponse): Promise<IWorkLenzResponse> {
-    const projectId = req.query.project_id;
-    
-    const q = `
-      SELECT 
-        t.id,
-        t.name,
-        t.start_date,
-        t.end_date,
-        t.done,
-        t.roadmap_sort_order,
-        t.parent_task_id,
-        CASE WHEN t.done THEN 100 ELSE 0 END as progress,
-        ts.name as status_name,
-        tsc.color_code as status_color,
-        tp.name as priority_name,
-        tp.value as priority_value,
-        tp.color_code as priority_color,
-        (
-          SELECT COALESCE(ARRAY_TO_JSON(ARRAY_AGG(ROW_TO_JSON(assignee_info))), '[]'::JSON)
-          FROM (
-            SELECT 
-              tm.id as team_member_id,
-              u.name as assignee_name,
-              u.avatar_url
-            FROM tasks_assignees ta
-            JOIN team_members tm ON ta.team_member_id = tm.id
-            JOIN users u ON tm.user_id = u.id
-            WHERE ta.task_id = t.id
-          ) assignee_info
-        ) as assignees,
-        (
-          SELECT COALESCE(ARRAY_TO_JSON(ARRAY_AGG(ROW_TO_JSON(phase_info))), '[]'::JSON)
-          FROM (
-            SELECT 
-              pp.id as phase_id,
-              pp.name as phase_name,
-              pp.color_code as phase_color
-            FROM task_phase tp
-            JOIN project_phases pp ON tp.phase_id = pp.id
-            WHERE tp.task_id = t.id
-          ) phase_info
-        ) as phases,
-        (
-          SELECT COALESCE(ARRAY_TO_JSON(ARRAY_AGG(ROW_TO_JSON(dependency_info))), '[]'::JSON)
-          FROM (
-            SELECT 
-              td.related_task_id,
-              td.dependency_type,
-              rt.name as related_task_name
-            FROM task_dependencies td
-            JOIN tasks rt ON td.related_task_id = rt.id
-            WHERE td.task_id = t.id
-          ) dependency_info
-        ) as dependencies
-      FROM tasks t
-      LEFT JOIN task_statuses ts ON t.status_id = ts.id
-      LEFT JOIN sys_task_status_categories tsc ON ts.category_id = tsc.id
-      LEFT JOIN task_priorities tp ON t.priority_id = tp.id
-      WHERE t.project_id = $1 
-        AND t.archived = FALSE
-        AND t.parent_task_id IS NULL
-      ORDER BY t.roadmap_sort_order, t.created_at DESC;
-    `;
-    
-    const result = await db.query(q, [projectId]);
-    
-    // Get subtasks for each parent task
-    for (const task of result.rows) {
-      const subtasksQuery = `
-        SELECT 
-          id,
-          name,
-          start_date,
-          end_date,
-          done,
-          roadmap_sort_order,
-          parent_task_id,
-          CASE WHEN done THEN 100 ELSE 0 END as progress
-        FROM tasks 
-        WHERE parent_task_id = $1 
-          AND archived = FALSE
-        ORDER BY roadmap_sort_order, created_at DESC;
-      `;
-      
-      const subtasksResult = await db.query(subtasksQuery, [task.id]);
-      task.subtasks = subtasksResult.rows;
-    }
-    
-    return res.status(200).send(new ServerResponse(true, result.rows));
-  }
-
-  @HandleExceptions()
-  public static async getProjectPhases(req: IWorkLenzRequest, res: IWorkLenzResponse): Promise<IWorkLenzResponse> {
-    const projectId = req.query.project_id;
-    
-    const q = `
-      SELECT 
-        pp.id,
-        pp.name,
-        pp.color_code,
-        pp.start_date,
-        pp.end_date,
-        pp.sort_index,
-        -- Calculate task counts by status category for progress
-        COALESCE(
-          (SELECT COUNT(*) 
-           FROM tasks t 
-           JOIN task_phase tp ON t.id = tp.task_id 
-           JOIN task_statuses ts ON t.status_id = ts.id
-           JOIN sys_task_status_categories stsc ON ts.category_id = stsc.id
-           WHERE tp.phase_id = pp.id 
-             AND t.archived = FALSE 
-             AND stsc.is_todo = TRUE), 0
-        ) as todo_count,
-        COALESCE(
-          (SELECT COUNT(*) 
-           FROM tasks t 
-           JOIN task_phase tp ON t.id = tp.task_id 
-           JOIN task_statuses ts ON t.status_id = ts.id
-           JOIN sys_task_status_categories stsc ON ts.category_id = stsc.id
-           WHERE tp.phase_id = pp.id 
-             AND t.archived = FALSE 
-             AND stsc.is_doing = TRUE), 0
-        ) as doing_count,
-        COALESCE(
-          (SELECT COUNT(*) 
-           FROM tasks t 
-           JOIN task_phase tp ON t.id = tp.task_id 
-           JOIN task_statuses ts ON t.status_id = ts.id
-           JOIN sys_task_status_categories stsc ON ts.category_id = stsc.id
-           WHERE tp.phase_id = pp.id 
-             AND t.archived = FALSE 
-             AND stsc.is_done = TRUE), 0
-        ) as done_count,
-        COALESCE(
-          (SELECT COUNT(*) 
-           FROM tasks t 
-           JOIN task_phase tp ON t.id = tp.task_id 
-           WHERE tp.phase_id = pp.id 
-             AND t.archived = FALSE), 0
-        ) as total_count
-      FROM project_phases pp
-      WHERE pp.project_id = $1
-      ORDER BY pp.sort_index, pp.created_at;
-    `;
-    
-    const result = await db.query(q, [projectId]);
-    
-    // Calculate progress percentages for each phase
-    const phasesWithProgress = result.rows.map(phase => {
-      const total = parseInt(phase.total_count) || 0;
-      const todoCount = parseInt(phase.todo_count) || 0;
-      const doingCount = parseInt(phase.doing_count) || 0;
-      const doneCount = parseInt(phase.done_count) || 0;
-      
-      return {
-        id: phase.id,
-        name: phase.name,
-        color_code: phase.color_code,
-        start_date: phase.start_date,
-        end_date: phase.end_date,
-        sort_index: phase.sort_index,
-        // Calculate progress percentages
-        todo_progress: total > 0 ? Math.round((todoCount / total) * 100) : 0,
-        doing_progress: total > 0 ? Math.round((doingCount / total) * 100) : 0,
-        done_progress: total > 0 ? Math.round((doneCount / total) * 100) : 0,
-        total_tasks: total
-      };
-    });
-    
-    return res.status(200).send(new ServerResponse(true, phasesWithProgress));
-  }
-
-  @HandleExceptions()
-  public static async updateTaskDates(req: IWorkLenzRequest, res: IWorkLenzResponse): Promise<IWorkLenzResponse> {
-    const { task_id, start_date, end_date } = req.body;
-    
-    const q = `
-      UPDATE tasks 
-      SET start_date = $2, end_date = $3, updated_at = NOW()
-      WHERE id = $1
-      RETURNING id, start_date, end_date;
-    `;
-    
-    const result = await db.query(q, [task_id, start_date, end_date]);
-    return res.status(200).send(new ServerResponse(true, result.rows[0]));
-  }
 }
--- a/worklenz-backend/src/controllers/project-members-controller.ts
+++ b/worklenz-backend/src/controllers/project-members-controller.ts
@@ -9,7 +9,7 @@ import {getColor} from "../shared/utils";
 import TeamMembersController from "./team-members-controller";
 import {checkTeamSubscriptionStatus} from "../shared/paddle-utils";
 import {updateUsers} from "../shared/paddle-requests";
-import {statusExclude, TRIAL_MEMBER_LIMIT} from "../shared/constants";
+import {statusExclude} from "../shared/constants";
 import {NotificationsService} from "../services/notifications/notifications.service";

 export default class ProjectMembersController extends WorklenzControllerBase {
@@ -118,17 +118,6 @@ export default class ProjectMembersController extends WorklenzControllerBase {
      return res.status(200).send(new ServerResponse(false, null, "Maximum number of life time users reached."));
    }

-    /**
-   * Checks trial user team member limit
-   */
-    if (subscriptionData.subscription_status === "trialing") {
-      const currentTrialMembers = parseInt(subscriptionData.current_count) || 0;
-      
-      if (currentTrialMembers + 1 > TRIAL_MEMBER_LIMIT) {
-        return res.status(200).send(new ServerResponse(false, null, `Trial users cannot exceed ${TRIAL_MEMBER_LIMIT} team members. Please upgrade to add more members.`));
-      }
-    }
-
    // if (subscriptionData.status === "trialing") break;
    if (!userExists && !subscriptionData.is_credit && !subscriptionData.is_custom && subscriptionData.subscription_status !== "trialing") {
      // if (subscriptionData.subscription_status === "active") {
--- a/worklenz-backend/src/controllers/projects-controller.ts
+++ b/worklenz-backend/src/controllers/projects-controller.ts
@@ -71,7 +71,7 @@ export default class ProjectsController extends WorklenzControllerBase {
        return res.status(200).send(new ServerResponse(false, [], `Sorry, the free plan cannot have more than ${projectsLimit} projects.`));
      }
    }
-
+    
    const q = `SELECT create_project($1) AS project`;

    req.body.team_id = req.user?.team_id || null;
@@ -317,58 +317,65 @@ export default class ProjectsController extends WorklenzControllerBase {
  @HandleExceptions()
  public static async getMembersByProjectId(req: IWorkLenzRequest, res: IWorkLenzResponse): Promise<IWorkLenzResponse> {
    const {sortField, sortOrder, size, offset} = this.toPaginationOptions(req.query, "name");
-    const search = (req.query.search || "").toString().trim();
-
-    let searchFilter = "";
-    const params = [req.params.id, req.user?.team_id ?? null, size, offset];
-    if (search) {
-      searchFilter = `
-        AND (
-          (SELECT name FROM team_member_info_view WHERE team_member_info_view.team_member_id = tm.id) ILIKE '%' || $5 || '%'
-          OR (SELECT email FROM team_member_info_view WHERE team_member_info_view.team_member_id = tm.id) ILIKE '%' || $5 || '%'
-        )
-      `;
-      params.push(search);
-    }

    const q = `
-      WITH filtered_members AS (
-        SELECT project_members.id,
-               team_member_id,
-               (SELECT name FROM team_member_info_view WHERE team_member_info_view.team_member_id = tm.id) AS name,
-               (SELECT email FROM team_member_info_view WHERE team_member_info_view.team_member_id = tm.id) AS email,
-               u.avatar_url,
-               (SELECT COUNT(*) FROM tasks WHERE archived IS FALSE AND project_id = project_members.project_id AND id IN (SELECT task_id FROM tasks_assignees WHERE tasks_assignees.project_member_id = project_members.id)) AS all_tasks_count,
-               (SELECT COUNT(*) FROM tasks WHERE archived IS FALSE AND project_id = project_members.project_id AND id IN (SELECT task_id FROM tasks_assignees WHERE tasks_assignees.project_member_id = project_members.id) AND status_id IN (SELECT id FROM task_statuses WHERE category_id = (SELECT id FROM sys_task_status_categories WHERE is_done IS TRUE))) AS completed_tasks_count,
-               EXISTS(SELECT email FROM email_invitations WHERE team_member_id = project_members.team_member_id AND email_invitations.team_id = $2) AS pending_invitation,
-               (SELECT project_access_levels.name FROM project_access_levels WHERE project_access_levels.id = project_members.project_access_level_id) AS access,
-               (SELECT name FROM job_titles WHERE id = tm.job_title_id) AS job_title
-        FROM project_members
-        INNER JOIN team_members tm ON project_members.team_member_id = tm.id
-        LEFT JOIN users u ON tm.user_id = u.id
-        WHERE project_id = $1
-        ${search ? searchFilter : ""}
-      )
-      SELECT
-        (SELECT COUNT(*) FROM filtered_members) AS total,
-        (SELECT COALESCE(ARRAY_TO_JSON(ARRAY_AGG(ROW_TO_JSON(t))), '[]'::JSON)
-           FROM (
-             SELECT * FROM filtered_members
-             ORDER BY ${sortField} ${sortOrder}
-             LIMIT $3 OFFSET $4
-           ) t
-        ) AS data
+      SELECT ROW_TO_JSON(rec) AS members
+      FROM (SELECT COUNT(*) AS total,
+                   (SELECT COALESCE(ARRAY_TO_JSON(ARRAY_AGG(ROW_TO_JSON(t))), '[]'::JSON)
+                    FROM (SELECT project_members.id,
+                                 team_member_id,
+                                 (SELECT name
+                                  FROM team_member_info_view
+                                  WHERE team_member_info_view.team_member_id = tm.id),
+                                 (SELECT email
+                                  FROM team_member_info_view
+                                  WHERE team_member_info_view.team_member_id = tm.id) AS email,
+                                 u.avatar_url,
+                                 (SELECT COUNT(*)
+                                  FROM tasks
+                                  WHERE archived IS FALSE
+                                    AND project_id = project_members.project_id
+                                    AND id IN (SELECT task_id
+                                               FROM tasks_assignees
+                                               WHERE tasks_assignees.project_member_id = project_members.id)) AS all_tasks_count,
+                                 (SELECT COUNT(*)
+                                  FROM tasks
+                                  WHERE archived IS FALSE
+                                    AND project_id = project_members.project_id
+                                    AND id IN (SELECT task_id
+                                               FROM tasks_assignees
+                                               WHERE tasks_assignees.project_member_id = project_members.id)
+                                    AND status_id IN (SELECT id
+                                                      FROM task_statuses
+                                                      WHERE category_id = (SELECT id
+                                                                           FROM sys_task_status_categories
+                                                                           WHERE is_done IS TRUE))) AS completed_tasks_count,
+                                 EXISTS(SELECT email
+                                        FROM email_invitations
+                                        WHERE team_member_id = project_members.team_member_id
+                                          AND email_invitations.team_id = $2) AS pending_invitation,
+                                 (SELECT project_access_levels.name
+                                  FROM project_access_levels
+                                  WHERE project_access_levels.id = project_members.project_access_level_id) AS access,
+                                 (SELECT name FROM job_titles WHERE id = tm.job_title_id) AS job_title
+                          FROM project_members
+                                 INNER JOIN team_members tm ON project_members.team_member_id = tm.id
+                                 LEFT JOIN users u ON tm.user_id = u.id
+                          WHERE project_id = $1
+                          ORDER BY ${sortField} ${sortOrder}
+                          LIMIT $3 OFFSET $4) t) AS data
+            FROM project_members
+            WHERE project_id = $1) rec;
    `;
-
-    const result = await db.query(q, params);
+    const result = await db.query(q, [req.params.id, req.user?.team_id ?? null, size, offset]);
    const [data] = result.rows;

-    for (const member of data?.data || []) {
+    for (const member of data?.members.data || []) {
      member.progress = member.all_tasks_count > 0
        ? ((member.completed_tasks_count / member.all_tasks_count) * 100).toFixed(0) : 0;
    }

-    return res.status(200).send(new ServerResponse(true, data || this.paginatedDatasetDefaultStruct));
+    return res.status(200).send(new ServerResponse(true, data?.members || this.paginatedDatasetDefaultStruct));
  }

  @HandleExceptions()
@@ -772,7 +779,7 @@ export default class ProjectsController extends WorklenzControllerBase {
    let groupJoin = "";
    let groupByFields = "";
    let groupOrderBy = "";
-
+    
    switch (groupBy) {
      case "client":
        groupField = "COALESCE(projects.client_id::text, 'no-client')";
@@ -881,13 +888,13 @@ export default class ProjectsController extends WorklenzControllerBase {
                                             ELSE p2.updated_at END) AS updated_at
                            FROM projects p2
                            ${groupJoin.replace("projects.", "p2.")}
-                            WHERE p2.team_id = $1
+                            WHERE p2.team_id = $1 
                              AND ${groupField.replace("projects.", "p2.")} = ${groupField}
-                              ${categories.replace("projects.", "p2.")}
-                              ${statuses.replace("projects.", "p2.")}
-                              ${isArchived.replace("projects.", "p2.")}
-                              ${isFavorites.replace("projects.", "p2.")}
-                              ${filterByMember.replace("projects.", "p2.")}
+                              ${categories.replace("projects.", "p2.")} 
+                              ${statuses.replace("projects.", "p2.")} 
+                              ${isArchived.replace("projects.", "p2.")} 
+                              ${isFavorites.replace("projects.", "p2.")} 
+                              ${filterByMember.replace("projects.", "p2.")} 
                              ${searchQuery.replace("projects.", "p2.")}
                            ORDER BY ${innerSortField} ${sortOrder}
                          ) project_data
--- a/worklenz-backend/src/controllers/reporting/reporting-allocation-controller-updated.ts
+++ b/worklenz-backend/src/controllers/reporting/reporting-allocation-controller-updated.ts
@@ -1,179 +0,0 @@
-// Example of updated getMemberTimeSheets method with timezone support
-// This shows the key changes needed to handle timezones properly
-
-import moment from "moment-timezone";
-import db from "../../config/db";
-import { IWorkLenzRequest } from "../../interfaces/worklenz-request";
-import { IWorkLenzResponse } from "../../interfaces/worklenz-response";
-import { ServerResponse } from "../../models/server-response";
-import { DATE_RANGES } from "../../shared/constants";
-
-export async function getMemberTimeSheets(req: IWorkLenzRequest, res: IWorkLenzResponse): Promise<IWorkLenzResponse> {
-  const archived = req.query.archived === "true";
-  const teams = (req.body.teams || []) as string[];
-  const teamIds = teams.map(id => `'${id}'`).join(",");
-  const projects = (req.body.projects || []) as string[];
-  const projectIds = projects.map(p => `'${p}'`).join(",");
-  const {billable} = req.body;
-  
-  // Get user timezone from request or database
-  const userTimezone = req.body.timezone || await getUserTimezone(req.user?.id || "");
-  
-  if (!teamIds || !projectIds.length)
-    return res.status(200).send(new ServerResponse(true, { users: [], projects: [] }));
-    
-  const { duration, date_range } = req.body;
-  
-  // Calculate date range with timezone support
-  let startDate: moment.Moment;
-  let endDate: moment.Moment;
-  
-  if (date_range && date_range.length === 2) {
-    // Convert user's local dates to their timezone's start/end of day
-    startDate = moment.tz(date_range[0], userTimezone).startOf("day");
-    endDate = moment.tz(date_range[1], userTimezone).endOf("day");
-  } else if (duration === DATE_RANGES.ALL_TIME) {
-    const minDateQuery = `SELECT MIN(COALESCE(start_date, created_at)) as min_date FROM projects WHERE id IN (${projectIds})`;
-    const minDateResult = await db.query(minDateQuery, []);
-    const minDate = minDateResult.rows[0]?.min_date;
-    startDate = minDate ? moment.tz(minDate, userTimezone) : moment.tz("2000-01-01", userTimezone);
-    endDate = moment.tz(userTimezone);
-  } else {
-    // Calculate ranges based on user's timezone
-    const now = moment.tz(userTimezone);
-    
-    switch (duration) {
-      case DATE_RANGES.YESTERDAY:
-        startDate = now.clone().subtract(1, "day").startOf("day");
-        endDate = now.clone().subtract(1, "day").endOf("day");
-        break;
-      case DATE_RANGES.LAST_WEEK:
-        startDate = now.clone().subtract(1, "week").startOf("isoWeek");
-        endDate = now.clone().subtract(1, "week").endOf("isoWeek");
-        break;
-      case DATE_RANGES.LAST_MONTH:
-        startDate = now.clone().subtract(1, "month").startOf("month");
-        endDate = now.clone().subtract(1, "month").endOf("month");
-        break;
-      case DATE_RANGES.LAST_QUARTER:
-        startDate = now.clone().subtract(3, "months").startOf("day");
-        endDate = now.clone().endOf("day");
-        break;
-      default:
-        startDate = now.clone().startOf("day");
-        endDate = now.clone().endOf("day");
-    }
-  }
-  
-  // Convert to UTC for database queries
-  const startUtc = startDate.utc().format("YYYY-MM-DD HH:mm:ss");
-  const endUtc = endDate.utc().format("YYYY-MM-DD HH:mm:ss");
-  
-  // Calculate working days in user's timezone
-  const totalDays = endDate.diff(startDate, "days") + 1;
-  let workingDays = 0;
-  
-  const current = startDate.clone();
-  while (current.isSameOrBefore(endDate, "day")) {
-    if (current.isoWeekday() >= 1 && current.isoWeekday() <= 5) {
-      workingDays++;
-    }
-    current.add(1, "day");
-  }
-  
-  // Updated SQL query with proper timezone handling
-  const billableQuery = buildBillableQuery(billable);
-  const archivedClause = archived ? "" : `AND projects.id NOT IN (SELECT project_id FROM archived_projects WHERE project_id = projects.id AND user_id = '${req.user?.id}')`;
-  
-  const q = `
-    WITH project_hours AS (
-      SELECT 
-        id,
-        COALESCE(hours_per_day, 8) as hours_per_day
-      FROM projects
-      WHERE id IN (${projectIds})
-    ),
-    total_working_hours AS (
-      SELECT 
-        SUM(hours_per_day) * ${workingDays} as total_hours
-      FROM project_hours
-    )
-    SELECT 
-      u.id,
-      u.email,
-      tm.name,
-      tm.color_code,
-      COALESCE(SUM(twl.time_spent), 0) as logged_time,
-      COALESCE(SUM(twl.time_spent), 0) / 3600.0 as value,
-      (SELECT total_hours FROM total_working_hours) as total_working_hours,
-      CASE 
-        WHEN (SELECT total_hours FROM total_working_hours) > 0 
-        THEN ROUND((COALESCE(SUM(twl.time_spent), 0) / 3600.0) / (SELECT total_hours FROM total_working_hours) * 100, 2)
-        ELSE 0 
-      END as utilization_percent,
-      ROUND(COALESCE(SUM(twl.time_spent), 0) / 3600.0, 2) as utilized_hours,
-      ROUND(COALESCE(SUM(twl.time_spent), 0) / 3600.0 - (SELECT total_hours FROM total_working_hours), 2) as over_under_utilized_hours,
-      '${userTimezone}' as user_timezone,
-      '${startDate.format("YYYY-MM-DD")}' as report_start_date,
-      '${endDate.format("YYYY-MM-DD")}' as report_end_date
-    FROM team_members tm
-      LEFT JOIN users u ON tm.user_id = u.id
-      LEFT JOIN task_work_log twl ON twl.user_id = u.id
-      LEFT JOIN tasks t ON twl.task_id = t.id ${billableQuery}
-      LEFT JOIN projects p ON t.project_id = p.id
-    WHERE tm.team_id IN (${teamIds})
-      AND (
-        twl.id IS NULL 
-        OR (
-          p.id IN (${projectIds})
-          AND twl.created_at >= '${startUtc}'::TIMESTAMP 
-          AND twl.created_at <= '${endUtc}'::TIMESTAMP
-          ${archivedClause}
-        )
-      )
-    GROUP BY u.id, u.email, tm.name, tm.color_code
-    ORDER BY logged_time DESC`;
-    
-  const result = await db.query(q, []);
-  
-  // Add timezone context to response
-  const response = {
-    data: result.rows,
-    timezone_info: {
-      user_timezone: userTimezone,
-      report_period: {
-        start: startDate.format("YYYY-MM-DD HH:mm:ss z"),
-        end: endDate.format("YYYY-MM-DD HH:mm:ss z"),
-        working_days: workingDays,
-        total_days: totalDays
-      }
-    }
-  };
-  
-  return res.status(200).send(new ServerResponse(true, response));
-}
-
-async function getUserTimezone(userId: string): Promise<string> {
-  const q = `SELECT tz.name as timezone 
-             FROM users u 
-             JOIN timezones tz ON u.timezone_id = tz.id 
-             WHERE u.id = $1`;
-  const result = await db.query(q, [userId]);
-  return result.rows[0]?.timezone || "UTC";
-}
-
-function buildBillableQuery(billable: { billable: boolean; nonBillable: boolean }): string {
-  if (!billable) return "";
-  
-  const { billable: isBillable, nonBillable } = billable;
-  
-  if (isBillable && nonBillable) {
-    return "";
-  } else if (isBillable) {
-    return " AND tasks.billable IS TRUE";
-  } else if (nonBillable) {
-    return " AND tasks.billable IS FALSE";
-  }
-  
-  return "";
-}
--- a/worklenz-backend/src/controllers/reporting/reporting-controller-base-with-timezone.ts
+++ b/worklenz-backend/src/controllers/reporting/reporting-controller-base-with-timezone.ts
@@ -1,140 +0,0 @@
-import WorklenzControllerBase from "../worklenz-controller-base";
-import { IWorkLenzRequest } from "../../interfaces/worklenz-request";
-import db from "../../config/db";
-import moment from "moment-timezone";
-import { DATE_RANGES } from "../../shared/constants";
-
-export default abstract class ReportingControllerBaseWithTimezone extends WorklenzControllerBase {
-  
-  /**
-   * Get the user's timezone from the database or request
-   * @param userId - The user ID
-   * @returns The user's timezone or 'UTC' as default
-   */
-  protected static async getUserTimezone(userId: string): Promise<string> {
-    const q = `SELECT tz.name as timezone 
-               FROM users u 
-               JOIN timezones tz ON u.timezone_id = tz.id 
-               WHERE u.id = $1`;
-    const result = await db.query(q, [userId]);
-    return result.rows[0]?.timezone || "UTC";
-  }
-
-  /**
-   * Generate date range clause with timezone support
-   * @param key - Date range key (e.g., YESTERDAY, LAST_WEEK)
-   * @param dateRange - Array of date strings
-   * @param userTimezone - User's timezone (e.g., 'America/New_York')
-   * @returns SQL clause for date filtering
-   */
-  protected static getDateRangeClauseWithTimezone(key: string, dateRange: string[], userTimezone: string) {
-    // For custom date ranges
-    if (dateRange.length === 2) {
-      try {
-        // Handle different date formats that might come from frontend
-        let startDate, endDate;
-        
-        // Try to parse the date - it might be a full JS Date string or ISO string
-        if (dateRange[0].includes("GMT") || dateRange[0].includes("(")) {
-          // Parse JavaScript Date toString() format
-          startDate = moment(new Date(dateRange[0]));
-          endDate = moment(new Date(dateRange[1]));
-        } else {
-          // Parse ISO format or other formats
-          startDate = moment(dateRange[0]);
-          endDate = moment(dateRange[1]);
-        }
-        
-        // Convert to user's timezone and get start/end of day
-        const start = startDate.tz(userTimezone).startOf("day");
-        const end = endDate.tz(userTimezone).endOf("day");
-        
-        // Convert to UTC for database comparison
-        const startUtc = start.utc().format("YYYY-MM-DD HH:mm:ss");
-        const endUtc = end.utc().format("YYYY-MM-DD HH:mm:ss");
-        
-        if (start.isSame(end, "day")) {
-          // Single day selection
-          return `AND twl.created_at >= '${startUtc}'::TIMESTAMP AND twl.created_at <= '${endUtc}'::TIMESTAMP`;
-        }
-        
-        return `AND twl.created_at >= '${startUtc}'::TIMESTAMP AND twl.created_at <= '${endUtc}'::TIMESTAMP`;
-      } catch (error) {
-        console.error("Error parsing date range:", error, { dateRange, userTimezone });
-        // Fallback to current date if parsing fails
-        const now = moment.tz(userTimezone);
-        const startUtc = now.clone().startOf("day").utc().format("YYYY-MM-DD HH:mm:ss");
-        const endUtc = now.clone().endOf("day").utc().format("YYYY-MM-DD HH:mm:ss");
-        return `AND twl.created_at >= '${startUtc}'::TIMESTAMP AND twl.created_at <= '${endUtc}'::TIMESTAMP`;
-      }
-    }
-
-    // For predefined ranges, calculate based on user's timezone
-    const now = moment.tz(userTimezone);
-    let startDate, endDate;
-
-    switch (key) {
-      case DATE_RANGES.YESTERDAY:
-        startDate = now.clone().subtract(1, "day").startOf("day");
-        endDate = now.clone().subtract(1, "day").endOf("day");
-        break;
-      case DATE_RANGES.LAST_WEEK:
-        startDate = now.clone().subtract(1, "week").startOf("week");
-        endDate = now.clone().subtract(1, "week").endOf("week");
-        break;
-      case DATE_RANGES.LAST_MONTH:
-        startDate = now.clone().subtract(1, "month").startOf("month");
-        endDate = now.clone().subtract(1, "month").endOf("month");
-        break;
-      case DATE_RANGES.LAST_QUARTER:
-        startDate = now.clone().subtract(3, "months").startOf("day");
-        endDate = now.clone().endOf("day");
-        break;
-      default:
-        return "";
-    }
-
-    if (startDate && endDate) {
-      const startUtc = startDate.utc().format("YYYY-MM-DD HH:mm:ss");
-      const endUtc = endDate.utc().format("YYYY-MM-DD HH:mm:ss");
-      return `AND twl.created_at >= '${startUtc}'::TIMESTAMP AND twl.created_at <= '${endUtc}'::TIMESTAMP`;
-    }
-
-    return "";
-  }
-
-  /**
-   * Format dates for display in user's timezone
-   * @param date - Date to format
-   * @param userTimezone - User's timezone
-   * @param format - Moment format string
-   * @returns Formatted date string
-   */
-  protected static formatDateInTimezone(date: string | Date, userTimezone: string, format = "YYYY-MM-DD HH:mm:ss") {
-    return moment.tz(date, userTimezone).format(format);
-  }
-
-  /**
-   * Get working days count between two dates in user's timezone
-   * @param startDate - Start date
-   * @param endDate - End date
-   * @param userTimezone - User's timezone
-   * @returns Number of working days
-   */
-  protected static getWorkingDaysInTimezone(startDate: string, endDate: string, userTimezone: string): number {
-    const start = moment.tz(startDate, userTimezone);
-    const end = moment.tz(endDate, userTimezone);
-    let workingDays = 0;
-    
-    const current = start.clone();
-    while (current.isSameOrBefore(end, "day")) {
-      // Monday = 1, Friday = 5
-      if (current.isoWeekday() >= 1 && current.isoWeekday() <= 5) {
-        workingDays++;
-      }
-      current.add(1, "day");
-    }
-    
-    return workingDays;
-  }
-}
--- a/worklenz-backend/src/controllers/reporting/reporting-members-controller.ts
+++ b/worklenz-backend/src/controllers/reporting/reporting-members-controller.ts
@@ -6,69 +6,10 @@ import { IWorkLenzResponse } from "../../interfaces/worklenz-response";
 import { ServerResponse } from "../../models/server-response";
 import { DATE_RANGES, TASK_PRIORITY_COLOR_ALPHA } from "../../shared/constants";
 import { formatDuration, getColor, int } from "../../shared/utils";
-import ReportingControllerBaseWithTimezone from "./reporting-controller-base-with-timezone";
+import ReportingControllerBase from "./reporting-controller-base";
 import Excel from "exceljs";

-export default class ReportingMembersController extends ReportingControllerBaseWithTimezone {
-
-  protected static getPercentage(n: number, total: number) {
-    return +(n ? (n / total) * 100 : 0).toFixed();
-  }
-
-  protected static getCurrentTeamId(req: IWorkLenzRequest): string | null {
-    return req.user?.team_id ?? null;
-  }
-
-  public static convertMinutesToHoursAndMinutes(totalMinutes: number) {
-    const hours = Math.floor(totalMinutes / 60);
-    const minutes = totalMinutes % 60;
-    return `${hours}h ${minutes}m`;
-  }
-
-  public static convertSecondsToHoursAndMinutes(seconds: number) {
-    const hours = Math.floor(seconds / 3600);
-    const minutes = Math.floor((seconds % 3600) / 60);
-    return `${hours}h ${minutes}m`;
-  }
-
-  protected static formatEndDate(endDate: string) {
-    const end = moment(endDate).format("YYYY-MM-DD");
-    const fEndDate = moment(end);
-    return fEndDate;
-  }
-
-  protected static formatCurrentDate() {
-    const current = moment().format("YYYY-MM-DD");
-    const fCurrentDate = moment(current);
-    return fCurrentDate;
-  }
-
-  protected static getDaysLeft(endDate: string): number | null {
-    if (!endDate) return null;
-
-    const fCurrentDate = this.formatCurrentDate();
-    const fEndDate = this.formatEndDate(endDate);
-
-    return fEndDate.diff(fCurrentDate, "days");
-  }
-
-  protected static isOverdue(endDate: string): boolean {
-    if (!endDate) return false;
-
-    const fCurrentDate = this.formatCurrentDate();
-    const fEndDate = this.formatEndDate(endDate);
-
-    return fEndDate.isBefore(fCurrentDate);
-  }
-
-  protected static isToday(endDate: string): boolean {
-    if (!endDate) return false;
-
-    const fCurrentDate = this.formatCurrentDate();
-    const fEndDate = this.formatEndDate(endDate);
-
-    return fEndDate.isSame(fCurrentDate);
-  }
+export default class ReportingMembersController extends ReportingControllerBase {

  private static async getMembers(
    teamId: string, searchQuery = "",
@@ -546,9 +487,7 @@ export default class ReportingMembersController extends ReportingControllerBaseW
      dateRange = date_range.split(",");
    }

-    // Get user timezone for proper date filtering
-    const userTimezone = await this.getUserTimezone(req.user?.id as string);
-    const durationClause = this.getDateRangeClauseWithTimezone(duration as string || DATE_RANGES.LAST_WEEK, dateRange, userTimezone);
+    const durationClause = ReportingMembersController.getDateRangeClauseMembers(duration as string || DATE_RANGES.LAST_WEEK, dateRange, "twl");
    const minMaxDateClause = this.getMinMaxDates(duration as string || DATE_RANGES.LAST_WEEK, dateRange, "task_work_log");
    const memberName = (req.query.member_name as string)?.trim() || null;

@@ -1099,9 +1038,7 @@ export default class ReportingMembersController extends ReportingControllerBaseW
  public static async getMemberTimelogs(req: IWorkLenzRequest, res: IWorkLenzResponse): Promise<IWorkLenzResponse> {
    const { team_member_id, team_id, duration, date_range, archived, billable } = req.body;

-    // Get user timezone for proper date filtering
-    const userTimezone = await this.getUserTimezone(req.user?.id as string);
-    const durationClause = this.getDateRangeClauseWithTimezone(duration || DATE_RANGES.LAST_WEEK, date_range, userTimezone);
+    const durationClause = ReportingMembersController.getDateRangeClauseMembers(duration || DATE_RANGES.LAST_WEEK, date_range, "twl");
    const minMaxDateClause = this.getMinMaxDates(duration || DATE_RANGES.LAST_WEEK, date_range, "task_work_log");

    const billableQuery = this.buildBillableQuery(billable);
@@ -1293,8 +1230,8 @@ public static async getSingleMemberProjects(req: IWorkLenzRequest, res: IWorkLen
    row.actual_time = int(row.actual_time);
    row.estimated_time_string = this.convertMinutesToHoursAndMinutes(int(row.estimated_time));
    row.actual_time_string = this.convertSecondsToHoursAndMinutes(int(row.actual_time));
-    row.days_left = this.getDaysLeft(row.end_date);
-    row.is_overdue = this.isOverdue(row.end_date);
+    row.days_left = ReportingControllerBase.getDaysLeft(row.end_date);
+    row.is_overdue = ReportingControllerBase.isOverdue(row.end_date);
    if (row.days_left && row.is_overdue) {
      row.days_left = row.days_left.toString().replace(/-/g, "");
    }
--- a/worklenz-backend/src/controllers/survey-controller.ts
+++ b/worklenz-backend/src/controllers/survey-controller.ts
@@ -1,201 +0,0 @@
-import { IWorkLenzRequest } from "../interfaces/worklenz-request";
-import { IWorkLenzResponse } from "../interfaces/worklenz-response";
-import { ServerResponse } from "../models/server-response";
-import WorklenzControllerBase from "./worklenz-controller-base";
-import HandleExceptions from "../decorators/handle-exceptions";
-import { ISurveySubmissionRequest } from "../interfaces/survey";
-import db from "../config/db";
-
-export default class SurveyController extends WorklenzControllerBase {
-  @HandleExceptions()
-  public static async getAccountSetupSurvey(req: IWorkLenzRequest, res: IWorkLenzResponse): Promise<IWorkLenzResponse> {
-    const q = `
-      SELECT 
-        s.id,
-        s.name,
-        s.description,
-        s.survey_type,
-        s.is_active,
-        COALESCE(
-          json_agg(
-            json_build_object(
-              'id', sq.id,
-              'survey_id', sq.survey_id,
-              'question_key', sq.question_key,
-              'question_type', sq.question_type,
-              'is_required', sq.is_required,
-              'sort_order', sq.sort_order,
-              'options', sq.options
-            ) ORDER BY sq.sort_order
-          ) FILTER (WHERE sq.id IS NOT NULL), 
-          '[]'
-        ) AS questions
-      FROM surveys s
-      LEFT JOIN survey_questions sq ON s.id = sq.survey_id
-      WHERE s.survey_type = 'account_setup' AND s.is_active = true
-      GROUP BY s.id, s.name, s.description, s.survey_type, s.is_active
-      LIMIT 1;
-    `;
-
-    const result = await db.query(q);
-    const [survey] = result.rows;
-
-    if (!survey) {
-      return res.status(200).send(new ServerResponse(false, null, "Account setup survey not found"));
-    }
-
-    return res.status(200).send(new ServerResponse(true, survey));
-  }
-
-  @HandleExceptions()
-  public static async submitSurveyResponse(req: IWorkLenzRequest, res: IWorkLenzResponse): Promise<IWorkLenzResponse> {
-    const userId = req.user?.id;
-    const body = req.body as ISurveySubmissionRequest;
-
-    if (!userId) {
-      return res.status(200).send(new ServerResponse(false, null, "User not authenticated"));
-    }
-
-    if (!body.survey_id || !body.answers || !Array.isArray(body.answers)) {
-      return res.status(200).send(new ServerResponse(false, null, "Invalid survey submission data"));
-    }
-
-    // Check if user has already submitted a response for this survey
-    const existingResponseQuery = `
-      SELECT id FROM survey_responses 
-      WHERE user_id = $1 AND survey_id = $2;
-    `;
-    const existingResult = await db.query(existingResponseQuery, [userId, body.survey_id]);
-
-    let responseId: string;
-
-    if (existingResult.rows.length > 0) {
-      // Update existing response
-      responseId = existingResult.rows[0].id;
-      
-      const updateResponseQuery = `
-        UPDATE survey_responses 
-        SET is_completed = true, completed_at = NOW(), updated_at = NOW()
-        WHERE id = $1;
-      `;
-      await db.query(updateResponseQuery, [responseId]);
-
-      // Delete existing answers
-      const deleteAnswersQuery = `DELETE FROM survey_answers WHERE response_id = $1;`;
-      await db.query(deleteAnswersQuery, [responseId]);
-    } else {
-      // Create new response
-      const createResponseQuery = `
-        INSERT INTO survey_responses (survey_id, user_id, is_completed, completed_at)
-        VALUES ($1, $2, true, NOW())
-        RETURNING id;
-      `;
-      const responseResult = await db.query(createResponseQuery, [body.survey_id, userId]);
-      responseId = responseResult.rows[0].id;
-    }
-
-    // Insert new answers
-    if (body.answers.length > 0) {
-      const answerValues: string[] = [];
-      const params: any[] = [];
-      
-      body.answers.forEach((answer, index) => {
-        const baseIndex = index * 4;
-        answerValues.push(`($${baseIndex + 1}, $${baseIndex + 2}, $${baseIndex + 3}, $${baseIndex + 4})`);
-        
-        params.push(
-          responseId,
-          answer.question_id,
-          answer.answer_text || null,
-          answer.answer_json ? JSON.stringify(answer.answer_json) : null
-        );
-      });
-
-      const insertAnswersQuery = `
-        INSERT INTO survey_answers (response_id, question_id, answer_text, answer_json)
-        VALUES ${answerValues.join(', ')};
-      `;
-
-      await db.query(insertAnswersQuery, params);
-    }
-
-    return res.status(200).send(new ServerResponse(true, { response_id: responseId }));
-  }
-
-  @HandleExceptions()
-  public static async getUserSurveyResponse(req: IWorkLenzRequest, res: IWorkLenzResponse): Promise<IWorkLenzResponse> {
-    const userId = req.user?.id;
-    const surveyId = req.params.survey_id;
-
-    if (!userId) {
-      return res.status(200).send(new ServerResponse(false, null, "User not authenticated"));
-    }
-
-    const q = `
-      SELECT 
-        sr.id,
-        sr.survey_id,
-        sr.user_id,
-        sr.is_completed,
-        sr.started_at,
-        sr.completed_at,
-        COALESCE(
-          json_agg(
-            json_build_object(
-              'question_id', sa.question_id,
-              'answer_text', sa.answer_text,
-              'answer_json', sa.answer_json
-            )
-          ) FILTER (WHERE sa.id IS NOT NULL),
-          '[]'
-        ) AS answers
-      FROM survey_responses sr
-      LEFT JOIN survey_answers sa ON sr.id = sa.response_id
-      WHERE sr.user_id = $1 AND sr.survey_id = $2
-      GROUP BY sr.id, sr.survey_id, sr.user_id, sr.is_completed, sr.started_at, sr.completed_at;
-    `;
-
-    const result = await db.query(q, [userId, surveyId]);
-    const [response] = result.rows;
-
-    if (!response) {
-      return res.status(200).send(new ServerResponse(false, null, "Survey response not found"));
-    }
-
-    return res.status(200).send(new ServerResponse(true, response));
-  }
-
-  @HandleExceptions()
-  public static async checkAccountSetupSurveyStatus(req: IWorkLenzRequest, res: IWorkLenzResponse): Promise<IWorkLenzResponse> {
-    const userId = req.user?.id;
-
-    if (!userId) {
-      return res.status(200).send(new ServerResponse(false, null, "User not authenticated"));
-    }
-
-    const q = `
-      SELECT EXISTS(
-        SELECT 1 
-        FROM survey_responses sr
-        INNER JOIN surveys s ON sr.survey_id = s.id
-        WHERE sr.user_id = $1 
-        AND s.survey_type = 'account_setup'
-        AND sr.is_completed = true
-      ) as is_completed,
-      (
-        SELECT sr.completed_at
-        FROM survey_responses sr
-        INNER JOIN surveys s ON sr.survey_id = s.id
-        WHERE sr.user_id = $1 
-        AND s.survey_type = 'account_setup'
-        AND sr.is_completed = true
-        LIMIT 1
-      ) as completed_at;
-    `;
-
-    const result = await db.query(q, [userId]);
-    const status = result.rows[0] || { is_completed: false, completed_at: null };
-
-    return res.status(200).send(new ServerResponse(true, status));
-  }
-}
--- a/worklenz-backend/src/controllers/team-members-controller.ts
+++ b/worklenz-backend/src/controllers/team-members-controller.ts
@@ -13,7 +13,7 @@ import { SocketEvents } from "../socket.io/events";
 import WorklenzControllerBase from "./worklenz-controller-base";
 import HandleExceptions from "../decorators/handle-exceptions";
 import { formatDuration, getColor } from "../shared/utils";
-import { statusExclude, TEAM_MEMBER_TREE_MAP_COLOR_ALPHA, TRIAL_MEMBER_LIMIT } from "../shared/constants";
+import { statusExclude, TEAM_MEMBER_TREE_MAP_COLOR_ALPHA } from "../shared/constants";
 import { checkTeamSubscriptionStatus } from "../shared/paddle-utils";
 import { updateUsers } from "../shared/paddle-requests";
 import { NotificationsService } from "../services/notifications/notifications.service";
@@ -141,17 +141,6 @@ export default class TeamMembersController extends WorklenzControllerBase {
      return res.status(200).send(new ServerResponse(false, null, "Cannot exceed the maximum number of life time users."));
    }

-    /**
-   * Checks trial user team member limit
-   */
-    if (subscriptionData.subscription_status === "trialing") {
-      const currentTrialMembers = parseInt(subscriptionData.current_count) || 0;
-      
-      if (currentTrialMembers + incrementBy > TRIAL_MEMBER_LIMIT) {
-        return res.status(200).send(new ServerResponse(false, null, `Trial users cannot exceed ${TRIAL_MEMBER_LIMIT} team members. Please upgrade to add more members.`));
-      }
-    }
-
    /**
   * Checks subscription details and updates the user count if applicable.
   * Sends a response if there is an issue with the subscription.
@@ -1092,18 +1081,6 @@ export default class TeamMembersController extends WorklenzControllerBase {
      return res.status(200).send(new ServerResponse(false, "Please check your subscription status."));
    }

-    /**
-   * Checks trial user team member limit
-   */
-    if (subscriptionData.subscription_status === "trialing") {
-      const currentTrialMembers = parseInt(subscriptionData.current_count) || 0;
-      const emailsToAdd = req.body.emails?.length || 1;
-      
-      if (currentTrialMembers + emailsToAdd > TRIAL_MEMBER_LIMIT) {
-        return res.status(200).send(new ServerResponse(false, null, `Trial users cannot exceed ${TRIAL_MEMBER_LIMIT} team members. Please upgrade to add more members.`));
-      }
-    }
-
    // if (subscriptionData.status === "trialing") break;
    if (!subscriptionData.is_credit && !subscriptionData.is_custom) {
      if (subscriptionData.subscription_status === "active") {
--- a/worklenz-backend/src/controllers/user-activity-logs-controller.ts
+++ b/worklenz-backend/src/controllers/user-activity-logs-controller.ts
@@ -1,117 +0,0 @@
-import moment from "moment";
-import { IWorkLenzRequest } from "../interfaces/worklenz-request";
-import { IWorkLenzResponse } from "../interfaces/worklenz-response";
-
-import db from "../config/db";
-
-import { ServerResponse } from "../models/server-response";
-import WorklenzControllerBase from "./worklenz-controller-base";
-import HandleExceptions from "../decorators/handle-exceptions";
-import { formatDuration, formatLogText, getColor } from "../shared/utils";
-
-interface IUserRecentTask {
-    task_id: string;
-    task_name: string;
-    project_id: string;
-    project_name: string;
-    last_activity_at: string;
-    activity_count: number;
-    project_color?: string;
-    task_status?: string;
-    status_color?: string;
-}
-
-interface IUserTimeLoggedTask {
-    task_id: string;
-    task_name: string;
-    project_id: string;
-    project_name: string;
-    total_time_logged: number;
-    total_time_logged_string: string;
-    last_logged_at: string;
-    logged_by_timer: boolean;
-    project_color?: string;
-    task_status?: string;
-    status_color?: string;
-    log_entries_count?: number;
-    estimated_time?: number;
-}
-
-export default class UserActivityLogsController extends WorklenzControllerBase {
-    @HandleExceptions()
-    public static async getRecentTasks(req: IWorkLenzRequest, res: IWorkLenzResponse): Promise<IWorkLenzResponse> {
-        if (!req.user) {
-            return res.status(401).send(new ServerResponse(false, null, "Unauthorized"));
-        }
-
-        const { id: userId, team_id: teamId } = req.user;
-        const { offset = 0, limit = 10 } = req.query;
-
-        // Optimized query with better performance and team filtering
-        const q = `
-        SELECT DISTINCT tal.task_id, t.name AS task_name, tal.project_id, p.name AS project_name,
-               MAX(tal.created_at) AS last_activity_at,
-               COUNT(DISTINCT tal.id) AS activity_count,
-               p.color_code AS project_color,
-               (SELECT name FROM task_statuses WHERE id = t.status_id) AS task_status,
-               (SELECT color_code 
-                FROM sys_task_status_categories 
-                WHERE id = (SELECT category_id FROM task_statuses WHERE id = t.status_id)) AS status_color
-        FROM task_activity_logs tal
-        INNER JOIN tasks t ON tal.task_id = t.id AND t.archived = FALSE
-        INNER JOIN projects p ON tal.project_id = p.id AND p.team_id = $1
-        WHERE tal.user_id = $2
-          AND tal.created_at >= NOW() - INTERVAL '30 days'
-        GROUP BY tal.task_id, t.name, tal.project_id, p.name, p.color_code, t.status_id
-        ORDER BY MAX(tal.created_at) DESC
-        LIMIT $3 OFFSET $4;
-        `;
-
-        const result = await db.query(q, [teamId, userId, limit, offset]);
-        const tasks: IUserRecentTask[] = result.rows;
-
-        return res.status(200).send(new ServerResponse(true, tasks));
-    }
-
-    @HandleExceptions()
-    public static async getTimeLoggedTasks(req: IWorkLenzRequest, res: IWorkLenzResponse): Promise<IWorkLenzResponse> {
-        if (!req.user) {
-            return res.status(401).send(new ServerResponse(false, null, "Unauthorized"));
-        }
-
-        const { id: userId, team_id: teamId } = req.user;
-        const { offset = 0, limit = 10 } = req.query;
-
-        // Optimized query with better performance, team filtering, and useful additional data
-        const q = `
-        SELECT twl.task_id, t.name AS task_name, t.project_id, p.name AS project_name,
-               SUM(twl.time_spent) AS total_time_logged,
-               MAX(twl.created_at) AS last_logged_at,
-               MAX(twl.logged_by_timer::int)::boolean AS logged_by_timer,
-               p.color_code AS project_color,
-               (SELECT name FROM task_statuses WHERE id = t.status_id) AS task_status,
-               (SELECT color_code 
-                FROM sys_task_status_categories 
-                WHERE id = (SELECT category_id FROM task_statuses WHERE id = t.status_id)) AS status_color,
-               COUNT(DISTINCT twl.id) AS log_entries_count,
-               (t.total_minutes * 60) AS estimated_time
-        FROM task_work_log twl
-        INNER JOIN tasks t ON twl.task_id = t.id AND t.archived = FALSE
-        INNER JOIN projects p ON t.project_id = p.id AND p.team_id = $1
-        WHERE twl.user_id = $2
-          AND twl.created_at >= NOW() - INTERVAL '90 days'
-        GROUP BY twl.task_id, t.name, t.project_id, p.name, p.color_code, t.status_id, t.total_minutes
-        HAVING SUM(twl.time_spent) > 0
-        ORDER BY MAX(twl.created_at) DESC
-        LIMIT $3 OFFSET $4;
-        `;
-
-        const result = await db.query(q, [teamId, userId, limit, offset]);
-        const tasks: IUserTimeLoggedTask[] = result.rows.map(task => ({
-            ...task,
-            total_time_logged_string: formatDuration(moment.duration(task.total_time_logged, "seconds")),
-        }));
-
-        return res.status(200).send(new ServerResponse(true, tasks));
-    }
-}
--- a/worklenz-backend/src/interfaces/survey.ts
+++ b/worklenz-backend/src/interfaces/survey.ts
@@ -1,37 +0,0 @@
-export interface ISurveyQuestion {
-  id: string;
-  survey_id: string;
-  question_key: string;
-  question_type: 'single_choice' | 'multiple_choice' | 'text';
-  is_required: boolean;
-  sort_order: number;
-  options?: string[];
-}
-
-export interface ISurvey {
-  id: string;
-  name: string;
-  description?: string;
-  survey_type: 'account_setup' | 'onboarding' | 'feedback';
-  is_active: boolean;
-  questions?: ISurveyQuestion[];
-}
-
-export interface ISurveyAnswer {
-  question_id: string;
-  answer_text?: string;
-  answer_json?: string[];
-}
-
-export interface ISurveyResponse {
-  id?: string;
-  survey_id: string;
-  user_id?: string;
-  is_completed: boolean;
-  answers: ISurveyAnswer[];
-}
-
-export interface ISurveySubmissionRequest {
-  survey_id: string;
-  answers: ISurveyAnswer[];
-}
--- a/worklenz-backend/src/middlewares/validators/survey-submission-validator.ts
+++ b/worklenz-backend/src/middlewares/validators/survey-submission-validator.ts
@@ -1,53 +0,0 @@
-import { NextFunction } from "express";
-import { IWorkLenzRequest } from "../../interfaces/worklenz-request";
-import { IWorkLenzResponse } from "../../interfaces/worklenz-response";
-import { ServerResponse } from "../../models/server-response";
-import { ISurveySubmissionRequest } from "../../interfaces/survey";
-
-export default function surveySubmissionValidator(req: IWorkLenzRequest, res: IWorkLenzResponse, next: NextFunction): IWorkLenzResponse | void {
-  const body = req.body as ISurveySubmissionRequest;
-
-  if (!body) {
-    return res.status(200).send(new ServerResponse(false, null, "Request body is required"));
-  }
-
-  if (!body.survey_id || typeof body.survey_id !== 'string') {
-    return res.status(200).send(new ServerResponse(false, null, "Survey ID is required and must be a string"));
-  }
-
-  if (!body.answers || !Array.isArray(body.answers)) {
-    return res.status(200).send(new ServerResponse(false, null, "Answers are required and must be an array"));
-  }
-
-  // Validate each answer
-  for (let i = 0; i < body.answers.length; i++) {
-    const answer = body.answers[i];
-    
-    if (!answer.question_id || typeof answer.question_id !== 'string') {
-      return res.status(200).send(new ServerResponse(false, null, `Answer ${i + 1}: Question ID is required and must be a string`));
-    }
-
-    // answer_text and answer_json are both optional - users can submit empty answers
-
-    // Validate answer_text if provided
-    if (answer.answer_text && typeof answer.answer_text !== 'string') {
-      return res.status(200).send(new ServerResponse(false, null, `Answer ${i + 1}: answer_text must be a string`));
-    }
-
-    // Validate answer_json if provided
-    if (answer.answer_json && !Array.isArray(answer.answer_json)) {
-      return res.status(200).send(new ServerResponse(false, null, `Answer ${i + 1}: answer_json must be an array`));
-    }
-
-    // Validate answer_json items are strings
-    if (answer.answer_json) {
-      for (let j = 0; j < answer.answer_json.length; j++) {
-        if (typeof answer.answer_json[j] !== 'string') {
-          return res.status(200).send(new ServerResponse(false, null, `Answer ${i + 1}: answer_json items must be strings`));
-        }
-      }
-    }
-  }
-
-  return next();
-}
--- a/worklenz-backend/src/public/locales/alb/task-list-filters.json
+++ b/worklenz-backend/src/public/locales/alb/task-list-filters.json
@@ -81,12 +81,5 @@
  "delete": "Fshi",
  "enterStatusName": "Shkruani emrin e statusit",
  "selectCategory": "Zgjidh kategorinë",
-  "close": "Mbyll",
-  "clearSort": "Pastro Renditjen",
-  "sortAscending": "Rendit në Rritje",
-  "sortDescending": "Rendit në Zbritje",
-  "sortByField": "Rendit sipas {{field}}",
-  "ascendingOrder": "Rritës",
-  "descendingOrder": "Zbritës",
-  "currentSort": "Renditja aktuale: {{field}} {{order}}"
+  "close": "Mbyll"
 }
--- a/worklenz-backend/src/public/locales/de/task-list-filters.json
+++ b/worklenz-backend/src/public/locales/de/task-list-filters.json
@@ -81,12 +81,5 @@
  "delete": "Löschen",
  "enterStatusName": "Statusnamen eingeben",
  "selectCategory": "Kategorie auswählen",
-  "close": "Schließen",
-  "clearSort": "Sortierung löschen",
-  "sortAscending": "Aufsteigend sortieren",
-  "sortDescending": "Absteigend sortieren",
-  "sortByField": "Sortieren nach {{field}}",
-  "ascendingOrder": "Aufsteigend",
-  "descendingOrder": "Absteigend",
-  "currentSort": "Aktuelle Sortierung: {{field}} {{order}}"
+  "close": "Schließen"
 }
--- a/worklenz-backend/src/public/locales/en/account-setup.json
+++ b/worklenz-backend/src/public/locales/en/account-setup.json
@@ -1,7 +1,7 @@
 {
  "continue": "Continue",

-  "setupYourAccount": "Setup Your Account.",
+  "setupYourAccount": "Setup Your Worklenz Account.",
  "organizationStepTitle": "Name Your Organization",
  "organizationStepLabel": "Pick a name for your Worklenz account.",

--- a/worklenz-backend/src/public/locales/en/task-list-filters.json
+++ b/worklenz-backend/src/public/locales/en/task-list-filters.json
@@ -81,12 +81,5 @@
  "delete": "Delete",
  "enterStatusName": "Enter status name",
  "selectCategory": "Select category",
-  "close": "Close",
-  "clearSort": "Clear Sort",
-  "sortAscending": "Sort Ascending",
-  "sortDescending": "Sort Descending",
-  "sortByField": "Sort by {{field}}",
-  "ascendingOrder": "Ascending",
-  "descendingOrder": "Descending",
-  "currentSort": "Current sort: {{field}} {{order}}"
+  "close": "Close"
 }
--- a/worklenz-backend/src/public/locales/es/task-list-filters.json
+++ b/worklenz-backend/src/public/locales/es/task-list-filters.json
@@ -77,12 +77,5 @@
  "delete": "Eliminar",
  "enterStatusName": "Introducir nombre del estado",
  "selectCategory": "Seleccionar categoría",
-  "close": "Cerrar",
-  "clearSort": "Limpiar Ordenamiento",
-  "sortAscending": "Ordenar Ascendente",
-  "sortDescending": "Ordenar Descendente",
-  "sortByField": "Ordenar por {{field}}",
-  "ascendingOrder": "Ascendente",
-  "descendingOrder": "Descendente",
-  "currentSort": "Ordenamiento actual: {{field}} {{order}}"
+  "close": "Cerrar"
 }
--- a/worklenz-backend/src/public/locales/pt/task-list-filters.json
+++ b/worklenz-backend/src/public/locales/pt/task-list-filters.json
@@ -78,12 +78,5 @@
  "delete": "Excluir",
  "enterStatusName": "Digite o nome do status",
  "selectCategory": "Selecionar categoria",
-  "close": "Fechar",
-  "clearSort": "Limpar Ordenação",
-  "sortAscending": "Ordenar Crescente",
-  "sortDescending": "Ordenar Decrescente",
-  "sortByField": "Ordenar por {{field}}",
-  "ascendingOrder": "Crescente",
-  "descendingOrder": "Decrescente",
-  "currentSort": "Ordenação atual: {{field}} {{order}}"
+  "close": "Fechar"
 }
--- a/worklenz-backend/src/public/locales/zh/task-list-filters.json
+++ b/worklenz-backend/src/public/locales/zh/task-list-filters.json
@@ -75,12 +75,5 @@
  "delete": "删除",
  "enterStatusName": "输入状态名称",
  "selectCategory": "选择类别",
-  "close": "关闭",
-  "clearSort": "清除排序",
-  "sortAscending": "升序排列",
-  "sortDescending": "降序排列",
-  "sortByField": "按{{field}}排序",
-  "ascendingOrder": "升序",
-  "descendingOrder": "降序",
-  "currentSort": "当前排序：{{field}} {{order}}"
+  "close": "关闭"
 }
--- a/worklenz-backend/src/routes/apis/gantt-api-router.ts
+++ b/worklenz-backend/src/routes/apis/gantt-api-router.ts
@@ -12,9 +12,4 @@ ganttApiRouter.get("/project-phases/:id", safeControllerFunction(GanttController

 ganttApiRouter.get("/project-workload", safeControllerFunction(GanttController.getWorkload));

-// New roadmap Gantt APIs
-ganttApiRouter.get("/roadmap-tasks", safeControllerFunction(GanttController.getRoadmapTasks));
-ganttApiRouter.get("/project-phases", safeControllerFunction(GanttController.getProjectPhases));
-ganttApiRouter.post("/update-task-dates", safeControllerFunction(GanttController.updateTaskDates));
-
 export default ganttApiRouter;
--- a/worklenz-backend/src/routes/apis/index.ts
+++ b/worklenz-backend/src/routes/apis/index.ts
@@ -1,125 +1,120 @@
-import express from "express";
-
-import AccessControlsController from "../../controllers/access-controls-controller";
-import AuthController from "../../controllers/auth-controller";
-import LogsController from "../../controllers/logs-controller";
-import OverviewController from "../../controllers/overview-controller";
-import TaskPrioritiesController from "../../controllers/task-priorities-controller";
-
-import attachmentsApiRouter from "./attachments-api-router";
-import clientsApiRouter from "./clients-api-router";
-import jobTitlesApiRouter from "./job-titles-api-router";
-import notificationsApiRouter from "./notifications-api-router";
-import personalOverviewApiRouter from "./personal-overview-api-router";
-import projectMembersApiRouter from "./project-members-api-router";
-import projectsApiRouter from "./projects-api-router";
-import settingsApiRouter from "./settings-api-router";
-import statusesApiRouter from "./statuses-api-router";
-import subTasksApiRouter from "./sub-tasks-api-router";
-import taskCommentsApiRouter from "./task-comments-api-router";
-import taskWorkLogApiRouter from "./task-work-log-api-router";
-import tasksApiRouter from "./tasks-api-router";
-import teamMembersApiRouter from "./team-members-api-router";
-import teamsApiRouter from "./teams-api-router";
-import timezonesApiRouter from "./timezones-api-router";
-import todoListApiRouter from "./todo-list-api-router";
-import projectStatusesApiRouter from "./project-statuses-api-router";
-import labelsApiRouter from "./labels-api-router";
-import sharedProjectsApiRouter from "./shared-projects-api-router";
-import resourceAllocationApiRouter from "./resource-allocation-api-router";
-import taskTemplatesApiRouter from "./task-templates-api-router";
-import projectInsightsApiRouter from "./project-insights-api-router";
-import passwordValidator from "../../middlewares/validators/password-validator";
-import adminCenterApiRouter from "./admin-center-api-router";
-import reportingApiRouter from "./reporting-api-router";
-import activityLogsApiRouter from "./activity-logs-api-router";
-import safeControllerFunction from "../../shared/safe-controller-function";
-import projectFoldersApiRouter from "./project-folders-api-router";
-import taskPhasesApiRouter from "./task-phases-api-router";
-import projectCategoriesApiRouter from "./project-categories-api-router";
-import homePageApiRouter from "./home-page-api-router";
-import ganttApiRouter from "./gantt-api-router";
-import projectCommentsApiRouter from "./project-comments-api-router";
-import reportingExportApiRouter from "./reporting-export-api-router";
-import projectHealthsApiRouter from "./project-healths-api-router";
-import ptTasksApiRouter from "./pt-tasks-api-router";
-import projectTemplatesApiRouter from "./project-templates-api";
-import ptTaskPhasesApiRouter from "./pt_task-phases-api-router";
-import ptStatusesApiRouter from "./pt-statuses-api-router";
-import workloadApiRouter from "./gannt-apis/workload-api-router";
-import roadmapApiRouter from "./gannt-apis/roadmap-api-router";
-import scheduleApiRouter from "./gannt-apis/schedule-api-router";
-import scheduleApiV2Router from "./gannt-apis/schedule-api-v2-router";
-import projectManagerApiRouter from "./project-managers-api-router";
-import surveyApiRouter from "./survey-api-router";
-
-import billingApiRouter from "./billing-api-router";
-import taskDependenciesApiRouter from "./task-dependencies-api-router";
-
-import taskRecurringApiRouter from "./task-recurring-api-router";
-
-import customColumnsApiRouter from "./custom-columns-api-router";
-import userActivityLogsApiRouter from "./user-activity-logs-api-router";
-
-const api = express.Router();
-
-api.use("/projects", projectsApiRouter);
-api.use("/team-members", teamMembersApiRouter);
-api.use("/job-titles", jobTitlesApiRouter);
-api.use("/clients", clientsApiRouter);
-api.use("/teams", teamsApiRouter);
-api.use("/tasks", tasksApiRouter);
-api.use("/settings", settingsApiRouter);
-api.use("/personal-overview", personalOverviewApiRouter);
-api.use("/statuses", statusesApiRouter);
-api.use("/todo-list", todoListApiRouter);
-api.use("/notifications", notificationsApiRouter);
-api.use("/attachments", attachmentsApiRouter);
-api.use("/sub-tasks", subTasksApiRouter);
-api.use("/project-members", projectMembersApiRouter);
-api.use("/task-time-log", taskWorkLogApiRouter);
-api.use("/task-comments", taskCommentsApiRouter);
-api.use("/timezones", timezonesApiRouter);
-api.use("/project-statuses", projectStatusesApiRouter);
-api.use("/labels", labelsApiRouter);
-api.use("/resource-allocation", resourceAllocationApiRouter);
-api.use("/shared/projects", sharedProjectsApiRouter);
-api.use("/task-templates", taskTemplatesApiRouter);
-api.use("/project-insights", projectInsightsApiRouter);
-api.use("/admin-center", adminCenterApiRouter);
-api.use("/reporting", reportingApiRouter);
-api.use("/activity-logs", activityLogsApiRouter);
-api.use("/projects-folders", projectFoldersApiRouter);
-api.use("/task-phases", taskPhasesApiRouter);
-api.use("/project-categories", projectCategoriesApiRouter);
-api.use("/home", homePageApiRouter);
-api.use("/gantt", ganttApiRouter);
-api.use("/project-comments", projectCommentsApiRouter);
-api.use("/reporting-export", reportingExportApiRouter);
-api.use("/project-healths", projectHealthsApiRouter);
-api.use("/project-templates", projectTemplatesApiRouter);
-api.use("/pt-tasks", ptTasksApiRouter);
-api.use("/pt-task-phases", ptTaskPhasesApiRouter);
-api.use("/pt-statuses", ptStatusesApiRouter);
-api.use("/workload-gannt", workloadApiRouter);
-api.use("/roadmap-gannt", roadmapApiRouter);
-api.use("/schedule-gannt", scheduleApiRouter);
-api.use("/schedule-gannt-v2", scheduleApiV2Router);
-api.use("/project-managers", projectManagerApiRouter);
-api.use("/surveys", surveyApiRouter);
-
-api.get("/overview/:id", safeControllerFunction(OverviewController.getById));
-api.get("/task-priorities", safeControllerFunction(TaskPrioritiesController.get));
-api.post("/change-password", passwordValidator, safeControllerFunction(AuthController.changePassword));
-api.get("/access-controls/roles", safeControllerFunction(AccessControlsController.getRoles));
-api.get("/logs/my-dashboard", safeControllerFunction(LogsController.getActivityLog));
-
-api.use("/billing", billingApiRouter);
-api.use("/task-dependencies", taskDependenciesApiRouter);
-
-api.use("/task-recurring", taskRecurringApiRouter);
+import express from "express";
+
+import AccessControlsController from "../../controllers/access-controls-controller";
+import AuthController from "../../controllers/auth-controller";
+import LogsController from "../../controllers/logs-controller";
+import OverviewController from "../../controllers/overview-controller";
+import TaskPrioritiesController from "../../controllers/task-priorities-controller";
+
+import attachmentsApiRouter from "./attachments-api-router";
+import clientsApiRouter from "./clients-api-router";
+import jobTitlesApiRouter from "./job-titles-api-router";
+import notificationsApiRouter from "./notifications-api-router";
+import personalOverviewApiRouter from "./personal-overview-api-router";
+import projectMembersApiRouter from "./project-members-api-router";
+import projectsApiRouter from "./projects-api-router";
+import settingsApiRouter from "./settings-api-router";
+import statusesApiRouter from "./statuses-api-router";
+import subTasksApiRouter from "./sub-tasks-api-router";
+import taskCommentsApiRouter from "./task-comments-api-router";
+import taskWorkLogApiRouter from "./task-work-log-api-router";
+import tasksApiRouter from "./tasks-api-router";
+import teamMembersApiRouter from "./team-members-api-router";
+import teamsApiRouter from "./teams-api-router";
+import timezonesApiRouter from "./timezones-api-router";
+import todoListApiRouter from "./todo-list-api-router";
+import projectStatusesApiRouter from "./project-statuses-api-router";
+import labelsApiRouter from "./labels-api-router";
+import sharedProjectsApiRouter from "./shared-projects-api-router";
+import resourceAllocationApiRouter from "./resource-allocation-api-router";
+import taskTemplatesApiRouter from "./task-templates-api-router";
+import projectInsightsApiRouter from "./project-insights-api-router";
+import passwordValidator from "../../middlewares/validators/password-validator";
+import adminCenterApiRouter from "./admin-center-api-router";
+import reportingApiRouter from "./reporting-api-router";
+import activityLogsApiRouter from "./activity-logs-api-router";
+import safeControllerFunction from "../../shared/safe-controller-function";
+import projectFoldersApiRouter from "./project-folders-api-router";
+import taskPhasesApiRouter from "./task-phases-api-router";
+import projectCategoriesApiRouter from "./project-categories-api-router";
+import homePageApiRouter from "./home-page-api-router";
+import ganttApiRouter from "./gantt-api-router";
+import projectCommentsApiRouter from "./project-comments-api-router";
+import reportingExportApiRouter from "./reporting-export-api-router";
+import projectHealthsApiRouter from "./project-healths-api-router";
+import ptTasksApiRouter from "./pt-tasks-api-router";
+import projectTemplatesApiRouter from "./project-templates-api";
+import ptTaskPhasesApiRouter from "./pt_task-phases-api-router";
+import ptStatusesApiRouter from "./pt-statuses-api-router";
+import workloadApiRouter from "./gannt-apis/workload-api-router";
+import roadmapApiRouter from "./gannt-apis/roadmap-api-router";
+import scheduleApiRouter from "./gannt-apis/schedule-api-router";
+import scheduleApiV2Router from "./gannt-apis/schedule-api-v2-router";
+import projectManagerApiRouter from "./project-managers-api-router";
+
+import billingApiRouter from "./billing-api-router";
+import taskDependenciesApiRouter from "./task-dependencies-api-router";
+
+import taskRecurringApiRouter from "./task-recurring-api-router";
+
 import customColumnsApiRouter from "./custom-columns-api-router";
+
+const api = express.Router();
+
+api.use("/projects", projectsApiRouter);
+api.use("/team-members", teamMembersApiRouter);
+api.use("/job-titles", jobTitlesApiRouter);
+api.use("/clients", clientsApiRouter);
+api.use("/teams", teamsApiRouter);
+api.use("/tasks", tasksApiRouter);
+api.use("/settings", settingsApiRouter);
+api.use("/personal-overview", personalOverviewApiRouter);
+api.use("/statuses", statusesApiRouter);
+api.use("/todo-list", todoListApiRouter);
+api.use("/notifications", notificationsApiRouter);
+api.use("/attachments", attachmentsApiRouter);
+api.use("/sub-tasks", subTasksApiRouter);
+api.use("/project-members", projectMembersApiRouter);
+api.use("/task-time-log", taskWorkLogApiRouter);
+api.use("/task-comments", taskCommentsApiRouter);
+api.use("/timezones", timezonesApiRouter);
+api.use("/project-statuses", projectStatusesApiRouter);
+api.use("/labels", labelsApiRouter);
+api.use("/resource-allocation", resourceAllocationApiRouter);
+api.use("/shared/projects", sharedProjectsApiRouter);
+api.use("/task-templates", taskTemplatesApiRouter);
+api.use("/project-insights", projectInsightsApiRouter);
+api.use("/admin-center", adminCenterApiRouter);
+api.use("/reporting", reportingApiRouter);
+api.use("/activity-logs", activityLogsApiRouter);
+api.use("/projects-folders", projectFoldersApiRouter);
+api.use("/task-phases", taskPhasesApiRouter);
+api.use("/project-categories", projectCategoriesApiRouter);
+api.use("/home", homePageApiRouter);
+api.use("/gantt", ganttApiRouter);
+api.use("/project-comments", projectCommentsApiRouter);
+api.use("/reporting-export", reportingExportApiRouter);
+api.use("/project-healths", projectHealthsApiRouter);
+api.use("/project-templates", projectTemplatesApiRouter);
+api.use("/pt-tasks", ptTasksApiRouter);
+api.use("/pt-task-phases", ptTaskPhasesApiRouter);
+api.use("/pt-statuses", ptStatusesApiRouter);
+api.use("/workload-gannt", workloadApiRouter);
+api.use("/roadmap-gannt", roadmapApiRouter);
+api.use("/schedule-gannt", scheduleApiRouter);
+api.use("/schedule-gannt-v2", scheduleApiV2Router);
+api.use("/project-managers", projectManagerApiRouter);
+
+api.get("/overview/:id", safeControllerFunction(OverviewController.getById));
+api.get("/task-priorities", safeControllerFunction(TaskPrioritiesController.get));
+api.post("/change-password", passwordValidator, safeControllerFunction(AuthController.changePassword));
+api.get("/access-controls/roles", safeControllerFunction(AccessControlsController.getRoles));
+api.get("/logs/my-dashboard", safeControllerFunction(LogsController.getActivityLog));
+
+api.use("/billing", billingApiRouter);
+api.use("/task-dependencies", taskDependenciesApiRouter);
+
+api.use("/task-recurring", taskRecurringApiRouter);

 api.use("/custom-columns", customColumnsApiRouter);
-api.use("/logs", userActivityLogsApiRouter);
-export default api;
+
--- a/worklenz-backend/src/routes/apis/survey-api-router.ts
+++ b/worklenz-backend/src/routes/apis/survey-api-router.ts
@@ -1,20 +0,0 @@
-import express from "express";
-import SurveyController from "../../controllers/survey-controller";
-import surveySubmissionValidator from "../../middlewares/validators/survey-submission-validator";
-import safeControllerFunction from "../../shared/safe-controller-function";
-
-const surveyApiRouter = express.Router();
-
-// Get account setup survey with questions
-surveyApiRouter.get("/account-setup", safeControllerFunction(SurveyController.getAccountSetupSurvey));
-
-// Check if user has completed account setup survey
-surveyApiRouter.get("/account-setup/status", safeControllerFunction(SurveyController.checkAccountSetupSurveyStatus));
-
-// Submit survey response
-surveyApiRouter.post("/responses", surveySubmissionValidator, safeControllerFunction(SurveyController.submitSurveyResponse));
-
-// Get user's survey response for a specific survey
-surveyApiRouter.get("/responses/:survey_id", safeControllerFunction(SurveyController.getUserSurveyResponse));
-
-export default surveyApiRouter;
--- a/worklenz-backend/src/routes/apis/user-activity-logs-api-router.ts
+++ b/worklenz-backend/src/routes/apis/user-activity-logs-api-router.ts
@@ -1,11 +0,0 @@
-import express from 'express';
-
-import UserActivityLogsController from '../../controllers/user-activity-logs-controller';
-import safeControllerFunction from "../../shared/safe-controller-function";
-
-const userActivityLogsApiRouter = express.Router();
-
-userActivityLogsApiRouter.get('/user-recent-tasks', safeControllerFunction(UserActivityLogsController.getRecentTasks));
-userActivityLogsApiRouter.get('/user-time-logged-tasks', safeControllerFunction(UserActivityLogsController.getTimeLoggedTasks));
-
-export default userActivityLogsApiRouter;
--- a/worklenz-backend/src/shared/constants.ts
+++ b/worklenz-backend/src/shared/constants.ts
@@ -160,9 +160,6 @@ export const PASSWORD_POLICY = "Minimum of 8 characters, with upper and lowercas
 // paddle status to exclude
 export const statusExclude = ["past_due", "paused", "deleted"];

-// Trial user team member limit
-export const TRIAL_MEMBER_LIMIT = 10;
-
 export const HTML_TAG_REGEXP = /<\/?[^>]+>/gi;

 export const UNMAPPED = "Unmapped";
--- a/worklenz-frontend/.env.development
+++ b/worklenz-frontend/.env.development
@@ -15,8 +15,4 @@ VITE_RECAPTCHA_SITE_KEY=recaptcha-site-key
 VITE_WORKLENZ_SESSION_ID=worklenz-session-id

 # Google Login
-VITE_ENABLE_GOOGLE_LOGIN=false
-
-# Survey Modal Configuration
-# Set to true to enable the survey modal, false to disable it
-VITE_ENABLE_SURVEY_MODAL=false
+VITE_ENABLE_GOOGLE_LOGIN=false
--- a/worklenz-frontend/.env.example
+++ b/worklenz-frontend/.env.example
@@ -1,22 +0,0 @@
-VITE_API_URL=http://localhost:3000
-VITE_SOCKET_URL=ws://localhost:3000
-
-VITE_APP_TITLE=Worklenz
-VITE_APP_ENV=development
-
-# Mixpanel
-VITE_MIXPANEL_TOKEN=mixpanel-token
-
-# Recaptcha
-VITE_ENABLE_RECAPTCHA=false
-VITE_RECAPTCHA_SITE_KEY=recaptcha-site-key
-
-# Session ID
-VITE_WORKLENZ_SESSION_ID=worklenz-session-id
-
-# Google Login
-VITE_ENABLE_GOOGLE_LOGIN=false
-
-# Survey Modal Configuration
-# Set to true to enable the survey modal, false to disable it
-VITE_ENABLE_SURVEY_MODAL=false
--- a/worklenz-frontend/index.html
+++ b/worklenz-frontend/index.html
@@ -57,15 +57,116 @@
    <!-- Environment configuration -->
    <script src="/env-config.js"></script>
    
-    <!-- Analytics Module -->
-    <script src="/js/analytics.js"></script>
+    <!-- Optimized Google Analytics with reduced blocking -->
+    <script>
+      // Function to initialize Google Analytics asynchronously
+      function initGoogleAnalytics() {
+        // Use requestIdleCallback to defer analytics loading
+        const loadAnalytics = () => {
+          // Determine which tracking ID to use based on the environment
+          const isProduction = window.location.hostname === 'app.worklenz.com';
+
+          const trackingId = isProduction ? 'G-7KSRKQ1397' : 'G-3LM2HGWEXG'; // Open source tracking ID
+
+          // Load the Google Analytics script
+          const script = document.createElement('script');
+          script.async = true;
+          script.src = `https://www.googletagmanager.com/gtag/js?id=${trackingId}`;
+          document.head.appendChild(script);
+
+          // Initialize Google Analytics
+          window.dataLayer = window.dataLayer || [];
+          function gtag() {
+            dataLayer.push(arguments);
+          }
+          gtag('js', new Date());
+          gtag('config', trackingId);
+        };
+
+        // Use requestIdleCallback if available, otherwise setTimeout
+        if ('requestIdleCallback' in window) {
+          requestIdleCallback(loadAnalytics, { timeout: 2000 });
+        } else {
+          setTimeout(loadAnalytics, 1000);
+        }
+      }
+
+      // Initialize analytics after a delay to not block initial render
+      initGoogleAnalytics();
+
+      // Function to show privacy notice
+      function showPrivacyNotice() {
+        const notice = document.createElement('div');
+        notice.style.cssText = `
+          position: fixed;
+          bottom: 16px;
+          right: 16px;
+          background: #222;
+          color: #f5f5f5;
+          padding: 12px 16px 10px 16px;
+          border-radius: 7px;
+          box-shadow: 0 2px 8px rgba(0,0,0,0.18);
+          z-index: 1000;
+          max-width: 320px;
+          font-family: Inter, sans-serif;
+          border: 1px solid #333;
+          font-size: 0.95rem;
+        `;
+        notice.innerHTML = `
+          <div style="margin-bottom: 6px; font-weight: 600; color: #fff; font-size: 1rem;">Analytics Notice</div>
+          <div style="margin-bottom: 8px; color: #f5f5f5;">This app uses Google Analytics for anonymous usage stats. No personal data is tracked.</div>
+          <button id="analytics-notice-btn" style="padding: 5px 14px; background: #1890ff; color: white; border: none; border-radius: 3px; cursor: pointer; font-size: 0.95rem;">Got it</button>
+        `;
+        document.body.appendChild(notice);
+        // Add event listener to button
+        const btn = notice.querySelector('#analytics-notice-btn');
+        btn.addEventListener('click', function (e) {
+          e.preventDefault();
+          localStorage.setItem('privacyNoticeShown', 'true');
+          notice.remove();
+        });
+      }
+
+      // Wait for DOM to be ready
+      document.addEventListener('DOMContentLoaded', function () {
+        // Check if we should show the notice
+        const isProduction =
+          window.location.hostname === 'worklenz.com' ||
+          window.location.hostname === 'app.worklenz.com';
+        const noticeShown = localStorage.getItem('privacyNoticeShown') === 'true';
+
+        // Show notice if not in production and not shown before
+        if (!isProduction && !noticeShown) {
+          showPrivacyNotice();
+        }
+      });
+    </script>
  </head>

  <body>
    <noscript>You need to enable JavaScript to run this app.</noscript>
    <div id="root"></div>
    <script type="module" src="./src/index.tsx"></script>
-    <!-- HubSpot Integration Module -->
-    <script src="/js/hubspot.js"></script>
+    <script type="text/javascript">
+      // Load HubSpot script asynchronously and only for production
+      if (window.location.hostname === 'app.worklenz.com') {
+        // Use requestIdleCallback to defer HubSpot loading
+        const loadHubSpot = () => {
+          var hs = document.createElement('script');
+          hs.type = 'text/javascript';
+          hs.id = 'hs-script-loader';
+          hs.async = true;
+          hs.defer = true;
+          hs.src = '//js.hs-scripts.com/22348300.js';
+          document.body.appendChild(hs);
+        };
+
+        if ('requestIdleCallback' in window) {
+          requestIdleCallback(loadHubSpot, { timeout: 3000 });
+        } else {
+          setTimeout(loadHubSpot, 2000);
+        }
+      }
+    </script>
  </body>
 </html>
--- a/worklenz-frontend/package-lock.json
+++ b/worklenz-frontend/package-lock.json
--- a/worklenz-frontend/package.json
+++ b/worklenz-frontend/package.json
@@ -9,11 +9,7 @@
    "build": "vite build",
    "dev-build": "vite build",
    "serve": "vite preview",
-    "format": "prettier --write .",
-    "test": "vitest",
-    "test:run": "vitest run",
-    "test:coverage": "vitest run --coverage",
-    "test:ui": "vitest --ui"
+    "format": "prettier --write ."
  },
  "dependencies": {
    "@ant-design/colors": "^7.1.0",
@@ -81,10 +77,7 @@
    "@types/react-dom": "19.0.0",
    "@types/react-window": "^1.8.8",
    "@vitejs/plugin-react": "^4.3.4",
-    "@vitest/coverage-v8": "^3.2.4",
-    "@vitest/ui": "^3.2.4",
    "autoprefixer": "^10.4.21",
-    "jsdom": "^26.1.0",
    "postcss": "^8.5.2",
    "prettier-plugin-tailwindcss": "^0.6.13",
    "rollup": "^4.40.2",
--- a/worklenz-frontend/public/js/analytics.js
+++ b/worklenz-frontend/public/js/analytics.js
@@ -1,97 +0,0 @@
-/**
- * Google Analytics initialization module
- * Handles analytics loading and privacy notices
- */
-
-class AnalyticsManager {
-  constructor() {
-    this.isProduction = window.location.hostname === 'app.worklenz.com';
-    this.trackingId = this.isProduction ? 'G-7KSRKQ1397' : 'G-3LM2HGWEXG';
-  }
-
-  /**
-   * Initialize Google Analytics asynchronously
-   */
-  init() {
-    const loadAnalytics = () => {
-      // Load the Google Analytics script
-      const script = document.createElement('script');
-      script.async = true;
-      script.src = `https://www.googletagmanager.com/gtag/js?id=${this.trackingId}`;
-      document.head.appendChild(script);
-
-      // Initialize Google Analytics
-      window.dataLayer = window.dataLayer || [];
-      function gtag() {
-        dataLayer.push(arguments);
-      }
-      gtag('js', new Date());
-      gtag('config', this.trackingId);
-    };
-
-    // Use requestIdleCallback if available, otherwise setTimeout
-    if ('requestIdleCallback' in window) {
-      requestIdleCallback(loadAnalytics, { timeout: 2000 });
-    } else {
-      setTimeout(loadAnalytics, 1000);
-    }
-  }
-
-  /**
-   * Show privacy notice for non-production environments
-   */
-  showPrivacyNotice() {
-    const notice = document.createElement('div');
-    notice.style.cssText = `
-      position: fixed;
-      bottom: 16px;
-      right: 16px;
-      background: #222;
-      color: #f5f5f5;
-      padding: 12px 16px 10px 16px;
-      border-radius: 7px;
-      box-shadow: 0 2px 8px rgba(0,0,0,0.18);
-      z-index: 1000;
-      max-width: 320px;
-      font-family: Inter, sans-serif;
-      border: 1px solid #333;
-      font-size: 0.95rem;
-    `;
-    notice.innerHTML = `
-      <div style="margin-bottom: 6px; font-weight: 600; color: #fff; font-size: 1rem;">Analytics Notice</div>
-      <div style="margin-bottom: 8px; color: #f5f5f5;">This app uses Google Analytics for anonymous usage stats. No personal data is tracked.</div>
-      <button id="analytics-notice-btn" style="padding: 5px 14px; background: #1890ff; color: white; border: none; border-radius: 3px; cursor: pointer; font-size: 0.95rem;">Got it</button>
-    `;
-    document.body.appendChild(notice);
-
-    // Add event listener to button
-    const btn = notice.querySelector('#analytics-notice-btn');
-    btn.addEventListener('click', (e) => {
-      e.preventDefault();
-      localStorage.setItem('privacyNoticeShown', 'true');
-      notice.remove();
-    });
-  }
-
-  /**
-   * Check if privacy notice should be shown
-   */
-  checkPrivacyNotice() {
-    const isProduction = 
-      window.location.hostname === 'worklenz.com' ||
-      window.location.hostname === 'app.worklenz.com';
-    const noticeShown = localStorage.getItem('privacyNoticeShown') === 'true';
-
-    // Show notice if not in production and not shown before
-    if (!isProduction && !noticeShown) {
-      this.showPrivacyNotice();
-    }
-  }
-}
-
-// Initialize analytics when DOM is ready
-document.addEventListener('DOMContentLoaded', () => {
-  const analytics = new AnalyticsManager();
-  analytics.init();
-  analytics.checkPrivacyNotice();
-});
--- a/worklenz-frontend/public/js/hubspot.js
+++ b/worklenz-frontend/public/js/hubspot.js
@@ -1,132 +0,0 @@
-/**
- * HubSpot Chat Widget integration module
- * Handles widget loading and dark mode theming
- */
-
-class HubSpotManager {
-  constructor() {
-    this.isProduction = window.location.hostname === 'app.worklenz.com';
-    this.scriptId = 'hs-script-loader';
-    this.scriptSrc = '//js.hs-scripts.com/22348300.js';
-    this.styleId = 'hubspot-dark-mode-override';
-  }
-
-  /**
-   * Load HubSpot script with dark mode support
-   */
-  init() {
-    // if (!this.isProduction) return;
-
-    const loadHubSpot = () => {
-      const script = document.createElement('script');
-      script.type = 'text/javascript';
-      script.id = this.scriptId;
-      script.async = true;
-      script.defer = true;
-      script.src = this.scriptSrc;
-      
-      // Configure dark mode after script loads
-      script.onload = () => this.setupDarkModeSupport();
-      
-      document.body.appendChild(script);
-    };
-
-    // Use requestIdleCallback for better performance
-    if ('requestIdleCallback' in window) {
-      requestIdleCallback(loadHubSpot, { timeout: 3000 });
-    } else {
-      setTimeout(loadHubSpot, 2000);
-    }
-  }
-
-  /**
-   * Setup dark mode theme switching for HubSpot widget
-   */
-  setupDarkModeSupport() {
-    const applyTheme = () => {
-      const isDark = document.documentElement.classList.contains('dark');
-      
-      // Remove existing theme styles
-      const existingStyle = document.getElementById(this.styleId);
-      if (existingStyle) {
-        existingStyle.remove();
-      }
-      
-      // Apply dark mode CSS if dark theme is active
-      if (isDark) {
-        this.injectDarkModeCSS();
-      }
-    };
-    
-    // Apply initial theme after delay to ensure widget is loaded
-    setTimeout(applyTheme, 1000);
-    
-    // Watch for theme changes
-    const observer = new MutationObserver(applyTheme);
-    observer.observe(document.documentElement, {
-      attributes: true,
-      attributeFilter: ['class']
-    });
-  }
-
-  /**
-   * Inject CSS for dark mode styling
-   */
-  injectDarkModeCSS() {
-    const style = document.createElement('style');
-    style.id = this.styleId;
-    style.textContent = `
-      /* HubSpot Chat Widget Dark Mode Override */
-      /*
-        Note: We can only style the container backgrounds, not the widget UI inside the iframe.
-        HubSpot does not currently support external dark mode theming for the chat UI itself.
-      */
-      #hubspot-conversations-inline-parent,
-      #hubspot-conversations-iframe-container {
-        background: #141414 !important;
-      }
-      /* Target HubSpot widget container backgrounds */
-      #hubspot-conversations-inline-parent div,
-      #hubspot-conversations-iframe-container div,
-      [data-test-id="chat-widget"] div {
-        background-color: transparent !important;
-      }
-      /* Ensure Worklenz app elements are not affected by HubSpot styles */
-      .ant-menu,
-      .ant-menu *,
-      [class*="settings"],
-      [class*="sidebar"],
-      .worklenz-app *:not([id*="hubspot"]):not([class*="widget"]) {
-        filter: none !important;
-      }
-    `;
-    document.head.appendChild(style);
-  }
-
-  /**
-   * Remove HubSpot widget and associated styles
-   */
-  cleanup() {
-    const script = document.getElementById(this.scriptId);
-    const style = document.getElementById(this.styleId);
-    
-    if (script) script.remove();
-    if (style) style.remove();
-  }
-}
-
-// Initialize HubSpot integration
-document.addEventListener('DOMContentLoaded', () => {
-  const hubspot = new HubSpotManager();
-  hubspot.init();
-  
-  // Make available globally for potential cleanup
-  window.HubSpotManager = hubspot;
-});
-
-// Add this style to ensure the chat widget uses the light color scheme
-(function() {
-  var style = document.createElement('style');
-  style.innerHTML = '#hubspot-messages-iframe-container { color-scheme: light !important; }';
-  document.head.appendChild(style);
-})();
--- a/worklenz-frontend/public/locales/alb/account-setup.json
+++ b/worklenz-frontend/public/locales/alb/account-setup.json
@@ -1,194 +1,31 @@
 {
  "continue": "Vazhdo",

-  "setupYourAccount": "Konfiguro llogarinë tënde.",
-  "organizationStepTitle": "Emërto organizatën tënde",
-  "organizationStepLabel": "Zgjidh një emër për llogarinë tënde në Worklenz.",
-  "organizationStepWelcome": "Konfiguro llogarinë tënde në Worklenz.",
-  "organizationStepDescription": "Le të fillojmë duke konfiguruar organizatën tënde. Kjo do të jetë hapësira kryesore e punës për ekipin tënd.",
-  "organizationStepTooltip": "Ky emër do të shfaqet në hapësirën tënde të punës dhe mund të ndryshohet më vonë në cilësime.",
-  "organizationStepNeedIdeas": "Keni nevojë për ide?",
-  "organizationStepUseDetected": "Përdorimi i zbuluar:",
-  "organizationStepCharacters": "karaktere",
-  "organizationStepGoodLength": "Gjatësi e mirë",
-  "organizationStepTooShort": "Shumë i shkurtër",
-  "organizationStepNamingTips": "Këshilla për emërtimin",
-  "organizationStepTip1": "Mbaje të thjeshtë dhe të lehtë për t'u mbajtur mend",
-  "organizationStepTip2": "Përfaqëso industrinë ose vlerat e tua",
-  "organizationStepTip3": "Mendo për rritjen në të ardhmen",
-  "organizationStepTip4": "Bëje unik dhe të përshtatshëm për markë",
-  "organizationStepSuggestionsTitle": "Sugjerime për emra",
-  "organizationStepCategory1": "Kompani Teknologjie",
-  "organizationStepCategory2": "Agjenci Kreative",
-  "organizationStepCategory3": "Konsulencë",
-  "organizationStepCategory4": "Startupe",
-  "organizationStepSuggestionsNote": "Këto janë vetëm shembuj për të të ndihmuar të fillosh. Zgjidh diçka që përfaqëson organizatën tënde.",
-  "organizationStepPrivacyNote": "Emri i organizatës tënde është privat dhe i dukshëm vetëm për anëtarët e ekipit.",
-  "projectStepTitle": "Krijo projektin tënd të parë",
-  "projectStepLabel": "Në cilin projekt po punon tani?",
+  "setupYourAccount": "Konfiguro Llogarinë Tënde në Worklenz.",
+  "organizationStepTitle": "Emërtoni Organizatën Tuaj",
+  "organizationStepLabel": "Zgjidhni një emër për llogarinë tuaj në Worklenz.",
+
+  "projectStepTitle": "Krijoni projektin tuaj të parë",
+  "projectStepLabel": "Në cilin projekt po punoni aktualisht?",
  "projectStepPlaceholder": "p.sh. Plani i Marketingut",
-  "tasksStepTitle": "Krijo detyrat e tua të para",
-  "tasksStepLabel": "Shkruaj disa detyra që do të kryesh në",
+
+  "tasksStepTitle": "Krijoni detyrat tuaja të para",
+  "tasksStepLabel": "Shkruani disa detyra që do të kryeni në",
  "tasksStepAddAnother": "Shto një tjetër",
-  "emailPlaceholder": "Adresa e emailit",
-  "invalidEmail": "Ju lutem vendosni një adresë emaili të vlefshme",
+
+  "emailPlaceholder": "Adresa email",
+  "invalidEmail": "Ju lutemi vendosni një adresë email të vlefshme",
  "or": "ose",
  "templateButton": "Importo nga shablloni",
-  "goBack": "Kthehu mbrapa",
+  "goBack": "Kthehu Mbrapa",
  "cancel": "Anulo",
  "create": "Krijo",
  "templateDrawerTitle": "Zgjidh nga shabllonet",
  "step3InputLabel": "Fto me email",
  "addAnother": "Shto një tjetër",
-  "skipForNow": "Kalo për tani",
-  "skipping": "Duke kaluar...",
-  "formTitle": "Krijo detyrën tënde të parë.",
-  "step3Title": "Fto ekipin tënd për të punuar së bashku",
+  "skipForNow": "Kalo tani për tani",
+  "formTitle": "Krijoni detyrën tuaj të parë.",
+  "step3Title": "Fto ekipin tënd të punojë me",
  "maxMembers": " (Mund të ftoni deri në 5 anëtarë)",
-  "maxTasks": " (Mund të krijoni deri në 5 detyra)",
-  "membersStepTitle": "Fto ekipin tënd",
-  "membersStepDescription": "Shto anëtarë ekipi në \"{{organizationName}}\" dhe filloni bashkëpunimin",
-  "memberPlaceholder": "Anëtari i ekipit {{index}} - Shkruani adresën e emailit",
-  "validEmailAddress": "Adresë emaili e vlefshme",
-  "addAnotherTeamMember": "Shto një anëtar tjetër të ekipit ({{current}}/{{max}})",
-  "canInviteLater": "Gjithmonë mund të ftoni anëtarë të ekipit më vonë",
-  "skipStepDescription": "Nuk i keni adresat e emailit gati? Asnjë problem! Mund ta kaloni këtë hap dhe të ftoni anëtarë nga paneli i projektit më vonë.",
-  "orgCategoryTech": "Kompani Teknologjie",
-  "orgCategoryCreative": "Agjenci Kreative",
-  "orgCategoryConsulting": "Konsulencë",
-  "orgCategoryStartups": "Startupe",
-  "namingTip1": "Mbaje të thjeshtë dhe të lehtë për t'u mbajtur mend",
-  "namingTip2": "Përfaqëso industrinë ose vlerat e tua",
-  "namingTip3": "Mendo për rritjen në të ardhmen",
-  "namingTip4": "Bëje unik dhe të përshtatshëm për markë",
-  "aboutYouTitle": "Na trego për veten tënde",
-  "aboutYouDescription": "Na ndihmo të personalizojmë përvojën tënde",
-  "orgTypeQuestion": "Cila përshkruan më mirë organizatën tënde?",
-  "userRoleQuestion": "Cili është roli yt?",
-  "yourNeedsTitle": "Cilat janë nevojat e tua kryesore?",
-  "yourNeedsDescription": "Zgjidh të gjitha që aplikohen për të na ndihmuar të konfigurojmë hapësirën tënde të punës",
-  "yourNeedsQuestion": "Si do ta përdorësh kryesisht Worklenz?",
-  "useCaseTaskOrg": "Organizo dhe ndiq detyrat",
-  "useCaseTeamCollab": "Puno së bashku pa pengesa",
-  "useCaseResourceMgmt": "Menaxho kohën dhe burimet",
-  "useCaseClientComm": "Qëndro i lidhur me klientët",
-  "useCaseTimeTrack": "Monitoro orët e projektit",
-  "useCaseOther": "Diçka tjetër",
-  "selectedText": "zgjedhur",
-  "previousToolsQuestion": "Çfarë mjetesh ke përdorur më parë? (Opsionale)",
-  "discoveryTitle": "Edhe një gjë e fundit...",
-  "discoveryDescription": "Na ndihmo të kuptojmë si e zbulove Worklenz",
-  "discoveryQuestion": "Si dëgjove për ne?",
-  "allSetTitle": "Çdo gjë gati!",
-  "allSetDescription": "Le të krijojmë projektin tënd të parë dhe të fillojmë me Worklenz",
-  "surveyCompleteTitle": "Faleminderit!",
-  "surveyCompleteDescription": "Përgjigjet tuaja na ndihmojnë të përmirësojmë Worklenz për të gjithë",
-  "aboutYouStepName": "Rreth teje",
-  "yourNeedsStepName": "Nevojat e tua",
-  "discoveryStepName": "Zbulimi",
-  "stepProgress": "Hapi {step} nga 3: {title}",
-  "projectStepHeader": "Le të krijojmë projektin tënd të parë",
-  "projectStepSubheader": "Fillo nga e para ose përdor një shabllon për të filluar më shpejt",
-  "startFromScratch": "Fillo nga e para",
-  "templateSelected": "Shablloni i zgjedhur më poshtë",
-  "quickSuggestions": "Sugjerime të shpejta:",
-  "orText": "OSE",
-  "startWithTemplate": "Fillo me një shabllon",
-  "clearToSelectTemplate": "Pastro emrin e projektit më sipër për të zgjedhur një shabllon",
-  "templateHeadStart": "Fillo më shpejt me struktura të gatshme projekti",
-  "browseAllTemplates": "Shfleto të gjitha shabllonet",
-  "templatesAvailable": "15+ shabllone të specializuara sipas industrisë në dispozicion",
-  "chooseTemplate": "Zgjidh një shabllon që i përshtatet llojit të projektit tënd",
-  "createProject": "Krijo projekt",
-  "templateSoftwareDev": "Zhvillim Softueri",
-  "templateSoftwareDesc": "Sprint-e agile, ndjekje gabimesh, lëshime",
-  "templateMarketing": "Fushatë Marketingu",
-  "templateMarketingDesc": "Planifikim fushate, kalendar përmbajtjesh",
-  "templateConstruction": "Projekt Ndërtimi",
-  "templateConstructionDesc": "Faza, leje, kontraktorë",
-  "templateStartup": "Lansim Startup-i",
-  "templateStartupDesc": "Zhvillim MVP, financim, rritje",
-  "tasksStepDescription": "Ndaji \"{{projectName}}\" në detyra të veprueshme për të filluar",
-  "taskPlaceholder": "Detyra {{index}} - p.sh., Çfarë duhet bërë?",
-  "addAnotherTask": "Shto një detyrë tjetër ({{current}}/{{max}})",
-  "surveyStepTitle": "Na trego për veten tënde",
-  "surveyStepLabel": "Na ndihmo të personalizojmë përvojën tënde në Worklenz duke iu përgjigjur disa pyetjeve.",
-  "organizationType": "Cila përshkruan më mirë organizatën tënde?",
-  "organizationTypeFreelancer": "Freelancer",
-  "organizationTypeStartup": "Startup",
-  "organizationTypeSmallMediumBusiness": "Biznes i Vogël ose i Mesëm",
-  "organizationTypeAgency": "Agjenci",
-  "organizationTypeEnterprise": "Ndërmarrje",
-  "organizationTypeOther": "Tjetër",
-  "userRole": "Cili është roli yt?",
-  "userRoleFounderCeo": "Themelues / CEO",
-  "userRoleProjectManager": "Menaxher Projekti",
-  "userRoleSoftwareDeveloper": "Zhvillues Softueri",
-  "userRoleDesigner": "Dizajner",
-  "userRoleOperations": "Operacionet",
-  "userRoleOther": "Tjetër",
-  "mainUseCases": "Për çfarë do ta përdorësh kryesisht Worklenz?",
-  "mainUseCasesTaskManagement": "Menaxhim detyrash",
-  "mainUseCasesTeamCollaboration": "Bashkëpunim ekipi",
-  "mainUseCasesResourcePlanning": "Planifikim burimesh",
-  "mainUseCasesClientCommunication": "Komunikim & raportim me klientët",
-  "mainUseCasesTimeTracking": "Ndjekje kohe",
-  "mainUseCasesOther": "Tjetër",
-  "previousTools": "Çfarë mjetesh ke përdorur para Worklenz?",
-  "previousToolsPlaceholder": "p.sh. Trello, Asana, Monday.com",
-  "howHeardAbout": "Si dëgjove për Worklenz?",
-  "howHeardAboutGoogleSearch": "Kërkim në Google",
-  "howHeardAboutTwitter": "Twitter",
-  "howHeardAboutLinkedin": "LinkedIn",
-  "howHeardAboutFriendColleague": "Një mik ose koleg",
-  "howHeardAboutBlogArticle": "Një blog ose artikull",
-  "howHeardAboutOther": "Tjetër",
-
-  "aboutYouStepTitle": "Na trego për veten",
-  "aboutYouStepDescription": "Na ndihmo të personalizojmë përvojën tënde",
-  "yourNeedsStepTitle": "Cilat janë nevojat e tua kryesore?",
-  "yourNeedsStepDescription": "Zgjidh të gjitha që aplikohen për të na ndihmuar të konfigurojmë hapësirën tënde të punës",
-  "selected": "zgjedhur",
-  "previousToolsLabel": "Çfarë mjetesh ke përdorur më parë? (Opsionale)",
-
-  "roleSuggestions": {
-    "designer": "UI/UX, Grafikë, Kreativ",
-    "developer": "Frontend, Backend, Full-stack",
-    "projectManager": "Planifikim, Koordinim",
-    "marketing": "Përmbajtje, Media Sociale, Rritje",
-    "sales": "Zhvillim Biznesi, Marrëdhënie me Klientë",
-    "operations": "Administratë, HR, Financa"
-  },
-
-  "languages": {
-    "en": "Anglisht",
-    "es": "Spanjisht",
-    "pt": "Portugalisht",
-    "de": "Gjermanisht",
-    "alb": "Shqip",
-    "zh": "Kinezçe"
-  },
-
-  "orgSuggestions": {
-    "tech": ["TechCorp", "DevStudio", "CodeCraft", "PixelForge"],
-    "creative": ["Creative Hub", "Design Studio", "Brand Works", "Visual Arts"],
-    "consulting": ["Strategy Group", "Business Solutions", "Expert Advisors", "Growth Partners"],
-    "startup": ["Innovation Labs", "Future Works", "Venture Co", "Next Gen"]
-  },
-
-  "projectSuggestions": {
-    "freelancer": ["Projekti i Klientit", "Përditësim Portfolio", "Markë Personale"],
-    "startup": ["Zhvillim MVP", "Lansim Produkti", "Kërkim Tregu"],
-    "agency": ["Fushatë Klienti", "Strategji Markë", "Ridizajnim Website"],
-    "enterprise": ["Migrim Sistemi", "Optimizim Procesesh", "Trajnim Ekipi"]
-  },
-
-  "useCaseDescriptions": {
-    "taskManagement": "Organizoj dhe ndjek detyrat",
-    "teamCollaboration": "Punojmë së bashku pa probleme",
-    "resourcePlanning": "Menaxhoj kohën dhe burimet",
-    "clientCommunication": "Qëndroj i lidhur me klientët",
-    "timeTracking": "Monitoroj orët e projektit",
-    "other": "Diçka tjetër"
-  }
+  "maxTasks": " (Mund të krijoni deri në 5 detyra)"
 }
--- a/worklenz-frontend/public/locales/alb/common.json
+++ b/worklenz-frontend/public/locales/alb/common.json
@@ -5,13 +5,5 @@
  "signup-failed": "Regjistrimi dështoi. Ju lutemi sigurohuni që të gjitha fushat e nevojshme janë plotësuar dhe provoni përsëri.",
  "reconnecting": "Jeni shkëputur nga serveri.",
  "connection-lost": "Lidhja me serverin dështoi. Ju lutemi kontrolloni lidhjen tuaj me internet.",
-  "connection-restored": "U lidhët me serverin me sukses",
-  "cancel": "Anulo",
-  "update-available": "Worklenz u përditesua!",
-  "update-description": "Një version i ri i Worklenz është i disponueshëm me karakteristikat dhe përmirësimet më të fundit.",
-  "update-instruction": "Për eksperiencën më të mirë, ju lutemi rifreskoni faqen për të aplikuar ndryshimet e reja.",
-  "update-whats-new": "💡 <1>Çfarë ka të re:</1> Përmirësim i performancës, rregullime të gabimeve dhe eksperiencön e përmirësuar e përdoruesit",
-  "update-now": "Përditeso tani",
-  "update-later": "Më vonë",
-  "updating": "Duke u përditesuar..."
+  "connection-restored": "U lidhët me serverin me sukses"
 }
--- a/worklenz-frontend/public/locales/alb/gantt/phase-details-modal.json
+++ b/worklenz-frontend/public/locales/alb/gantt/phase-details-modal.json
@@ -1,36 +0,0 @@
-{
-  "title": "Phase Details",
-  "overview": {
-    "title": "Overview",
-    "totalTasks": "Total Tasks",
-    "completion": "Completion",
-    "progress": "Progress"
-  },
-  "timeline": {
-    "title": "Timeline",
-    "startDate": "Start Date",
-    "endDate": "End Date",
-    "status": "Status",
-    "notSet": "Not set",
-    "statusLabels": {
-      "upcoming": "Upcoming",
-      "active": "In Progress",
-      "overdue": "Overdue",
-      "notScheduled": "Not Scheduled"
-    }
-  },
-  "taskBreakdown": {
-    "title": "Task Breakdown",
-    "completed": "Completed",
-    "pending": "Pending",
-    "overdue": "Overdue"
-  },
-  "phaseColor": {
-    "title": "Phase Color",
-    "description": "Phase identifier color"
-  },
-  "tasksInPhase": {
-    "title": "Tasks in this Phase",
-    "noTasks": "No tasks in this phase"
-  }
-}
--- a/worklenz-frontend/public/locales/alb/home.json
+++ b/worklenz-frontend/public/locales/alb/home.json
@@ -41,22 +41,6 @@
    "list": "Listë",
    "calendar": "Kalendar",
    "tasks": "Detyrat",
-    "refresh": "Rifresko",
-    "recentActivity": "Aktiviteti i Fundit",
-    "recentTasks": "Detyrat e Fundit",
-    "recentTasksSegment": "Detyrat e Fundit",
-    "timeLogged": "Koha e Regjistruar",
-    "timeLoggedSegment": "Koha e Regjistruar",
-    "noRecentTasks": "Asnjë detyrë e fundit",
-    "noTimeLoggedTasks": "Asnjë detyrë me kohë të regjistruar",
-    "activityTag": "Aktiviteti",
-    "timeLogTag": "Regjistrim Kohe",
-    "timerTag": "Kohëmatës",
-    "activitySingular": "aktivitet",
-    "activityPlural": "aktivitete",
-    "recentTaskAriaLabel": "Detyrë e fundit:",
-    "timeLoggedTaskAriaLabel": "Detyrë me kohë të regjistruar:",
-    "errorLoadingRecentTasks": "Gabim në ngarkimin e detyrave të fundit",
-    "errorLoadingTimeLoggedTasks": "Gabim në ngarkimin e detyrave me kohë të regjistruar"
+    "refresh": "Rifresko"
  }
 }
--- a/worklenz-frontend/public/locales/alb/kanban-board.json
+++ b/worklenz-frontend/public/locales/alb/kanban-board.json
@@ -10,17 +10,6 @@
  "deleteConfirmationOk": "Po",
  "deleteConfirmationCancel": "Anulo",

-  "deleteTaskTitle": "Fshi Detyrën",
-  "deleteTaskContent": "Jeni i sigurt që doni të fshini këtë detyrë? Kjo veprim nuk mund të zhbëhet.",
-  "deleteTaskConfirm": "Fshi",
-  "deleteTaskCancel": "Anulo",
-
-  "deleteStatusTitle": "Fshi Statusin",
-  "deleteStatusContent": "Jeni i sigurt që doni të fshini këtë status? Kjo veprim nuk mund të zhbëhet.",
-
-  "deletePhaseTitle": "Fshi Fazen",
-  "deletePhaseContent": "Jeni i sigurt që doni të fshini këtë fazë? Kjo veprim nuk mund të zhbëhet.",
-
  "dueDate": "Data e përfundimit",
  "cancel": "Anulo",

@@ -37,17 +26,5 @@
  "noDueDate": "Pa datë përfundimi",
  "save": "Ruaj",
  "clear": "Pastro",
-  "nextWeek": "Javën e ardhshme",
-  "noSubtasks": "Pa nëndetyra",
-  "showSubtasks": "Shfaq nëndetyrat",
-  "hideSubtasks": "Fshih nëndetyrat",
-  
-  "errorLoadingTasks": "Gabim gjatë ngarkimit të detyrave",
-  "noTasksFound": "Nuk u gjetën detyra",
-  "loadingFilters": "Duke ngarkuar filtra...",
-  "failedToUpdateColumnOrder": "Dështoi përditësimi i rendit të kolonave",
-  "failedToUpdatePhaseOrder": "Dështoi përditësimi i rendit të fazave",
-  "pleaseTryAgain": "Ju lutemi provoni përsëri",
-  "taskNotCompleted": "Detyra nuk është përfunduar",
-  "completeTaskDependencies": "Ju lutemi përfundoni varësitë e detyrës para se të vazhdoni"
+  "nextWeek": "Javën e ardhshme"
 }
--- a/worklenz-frontend/public/locales/alb/project-view-members.json
+++ b/worklenz-frontend/public/locales/alb/project-view-members.json
@@ -13,6 +13,5 @@
  "deleteButtonTooltip": "Hiq nga projekti",
  "memberCount": "Anëtar",
  "membersCountPlural": "Anëtarë",
-  "emptyText": "Nuk ka bashkëngjitje në projekt.",
-  "searchPlaceholder": "Kërko anëtarë"
+  "emptyText": "Nuk ka bashkëngjitje në projekt."
 }
--- a/worklenz-frontend/public/locales/alb/project-view/project-member-drawer.json
+++ b/worklenz-frontend/public/locales/alb/project-view/project-member-drawer.json
@@ -3,9 +3,5 @@
  "searchLabel": "Shtoni anëtarë duke shkruar emrin ose email-in e tyre",
  "searchPlaceholder": "Shkruani emrin ose email-in",
  "inviteAsAMember": "Fto si anëtar",
-  "inviteNewMemberByEmail": "Fto anëtar të ri me email",
-  "members": "Anëtarë",
-  "copyProjectLink": "Kopjo lidhjen e projektit",
-  "inviteMember": "Fto anëtar",
-  "alsoInviteToProject": "Fto edhe në projekt"
+  "inviteNewMemberByEmail": "Fto anëtar të ri me email"
 }
--- a/worklenz-frontend/public/locales/alb/settings/team-members.json
+++ b/worklenz-frontend/public/locales/alb/settings/team-members.json
@@ -28,7 +28,7 @@
  "jobTitleLabel": "Titulli i Punës",
  "jobTitlePlaceholder": "Zgjidh ose kërko titull pune (Opsionale)",
  "memberAccessLabel": "Niveli i Qasjes",
-  "addToTeamButton": "Dërgo ftesën",
+  "addToTeamButton": "Shto Anëtar në Ekip",
  "updateButton": "Ruaj Ndryshimet",
  "resendInvitationButton": "Dërgo Përsëri Email-in e Ftesës",
  "invitationSentSuccessMessage": "Ftesa për ekip u dërgua me sukses!",
@@ -43,6 +43,5 @@
  "updatedText": "Përditësuar",
  "noResultFound": "Shkruani një adresë email dhe shtypni Enter...",
  "jobTitlesFetchError": "Dështoi marrja e titujve të punës",
-  "invitationResent": "Ftesa u dërgua sërish me sukses!",
-  "copyTeamLink": "Kopjo lidhjen e ekipit"
+  "invitationResent": "Ftesa u dërgua sërish me sukses!"
 }
--- a/worklenz-frontend/public/locales/alb/survey.json
+++ b/worklenz-frontend/public/locales/alb/survey.json
@@ -1,14 +0,0 @@
-{
-  "modalTitle": "Ndihmoni të përmirësojmë përvojën tuaj",
-  "skip": "Kalo për tani",
-  "previous": "Prapa",
-  "next": "Tjetra",
-  "completeSurvey": "Përfundo Anketën",
-  "submitting": "Duke dërguar përgjigjet tuaja...",
-  "submitSuccessTitle": "Faleminderit!",
-  "submitSuccessSubtitle": "Feedback-u juaj na ndihmon të përmirësojmë Worklenz për të gjithë.",
-  "submitSuccessMessage": "Faleminderit që plotësuat anketën!",
-  "submitErrorMessage": "Dështoi dërgimi i anketës. Ju lutemi provoni përsëri.",
-  "submitErrorLog": "Dështoi dërgimi i anketës",
-  "fetchErrorLog": "Dështoi marrja e anketës"
-} 
--- a/worklenz-frontend/public/locales/alb/task-list-filters.json
+++ b/worklenz-frontend/public/locales/alb/task-list-filters.json
@@ -84,12 +84,5 @@
  "close": "Mbyll",
  "cannotMoveStatus": "Nuk mund të lëvizet statusi",
  "cannotMoveStatusMessage": "Nuk mund të lëvizet ky status sepse do të linte kategorinë '{{categoryName}}' bosh. Çdo kategori duhet të ketë të paktën një status.",
-  "ok": "OK",
-  "clearSort": "Pastro Renditjen",
-  "sortAscending": "Rendit në Rritje",
-  "sortDescending": "Rendit në Zbritje",
-  "sortByField": "Rendit sipas {{field}}",
-  "ascendingOrder": "Rritës",
-  "descendingOrder": "Zbritës",
-  "currentSort": "Renditja aktuale: {{field}} {{order}}"
+  "ok": "OK"
 }
--- a/worklenz-frontend/public/locales/alb/task-list-table.json
+++ b/worklenz-frontend/public/locales/alb/task-list-table.json
@@ -57,9 +57,6 @@

  "contextMenu": {
    "assignToMe": "Cakto mua",
-    "copyLink": "Kopjo lidhjen e detyrës",
-    "linkCopied": "Lidhja u kopjua në clipboard",
-    "linkCopyFailed": "Dështoi kopjimi i lidhjes",
    "moveTo": "Zhvendos në",
    "unarchive": "Ç'arkivizo",
    "archive": "Arkivizo",
@@ -136,11 +133,5 @@
      "dependencies": "Detyra ka varësi",
      "recurring": "Detyrë përsëritëse"
    }
-  },
-
-  "timer": {
-    "conflictTitle": "Kronómetr Tashë Në Ecuri",
-    "conflictMessage": "Ju keni një kronómetr në ecuri për \"{{taskName}}\" në projektin \"{{projectName}}\". Dëshironi ta ndaloni atë kronómetr dhe të filloni një të ri për këtë detyrë?",
-    "stopAndStart": "Ndalo & Fillo Kronómetr të Ri"
  }
 }
--- a/worklenz-frontend/public/locales/de/account-setup.json
+++ b/worklenz-frontend/public/locales/de/account-setup.json
@@ -3,28 +3,7 @@

  "setupYourAccount": "Richten Sie Ihr Worklenz-Konto ein.",
  "organizationStepTitle": "Organisation benennen",
-  "organizationStepWelcome": "Willkommen bei Worklenz!",
-  "organizationStepDescription": "Beginnen wir mit der Einrichtung Ihrer Organisation. Dies wird der Hauptarbeitsplatz für Ihr Team.",
-  "organizationStepLabel": "Organisationsname",
-  "organizationStepPlaceholder": "z.B. Acme Corporation",
-  "organizationStepTooltip": "Dieser Name wird in Ihrem Arbeitsbereich angezeigt und kann später in den Einstellungen geändert werden.",
-  "organizationStepNeedIdeas": "Brauchen Sie Ideen?",
-  "organizationStepUseDetected": "Erkannt verwenden:",
-  "organizationStepCharacters": "Zeichen",
-  "organizationStepGoodLength": "Gute Länge",
-  "organizationStepTooShort": "Zu kurz",
-  "organizationStepNamingTips": "Namensgebungstipps",
-  "organizationStepTip1": "Halten Sie es einfach und einprägsam",
-  "organizationStepTip2": "Spiegeln Sie Ihre Branche oder Werte wider",
-  "organizationStepTip3": "Denken Sie an zukünftiges Wachstum",
-  "organizationStepTip4": "Machen Sie es einzigartig und markenfähig",
-  "organizationStepSuggestionsTitle": "Namensvorschläge",
-  "organizationStepCategory1": "Tech-Unternehmen",
-  "organizationStepCategory2": "Kreativagenturen",
-  "organizationStepCategory3": "Beratung",
-  "organizationStepCategory4": "Startups",
-  "organizationStepSuggestionsNote": "Dies sind nur Beispiele für den Einstieg. Wählen Sie etwas, das Ihre Organisation repräsentiert.",
-  "organizationStepPrivacyNote": "Ihr Organisationsname ist privat und nur für Ihre Teammitglieder sichtbar.",
+  "organizationStepLabel": "Wählen Sie einen Namen für Ihr Worklenz-Konto.",

  "projectStepTitle": "Erstellen Sie Ihr erstes Projekt",
  "projectStepLabel": "An welchem Projekt arbeiten Sie gerade?",
@@ -45,170 +24,8 @@
  "step3InputLabel": "Per E-Mail einladen",
  "addAnother": "Weitere hinzufügen",
  "skipForNow": "Jetzt überspringen",
-  "skipping": "Überspringen...",
  "formTitle": "Erstellen Sie Ihre erste Aufgabe.",
  "step3Title": "Laden Sie Ihr Team zur Zusammenarbeit ein",
  "maxMembers": " (Sie können bis zu 5 Mitglieder einladen)",
-  "maxTasks": " (Sie können bis zu 5 Aufgaben erstellen)",
-
-  "membersStepTitle": "Laden Sie Ihr Team ein",
-  "membersStepDescription": "Teammitglieder zu \"{{organizationName}}\" hinzufügen und mit der Zusammenarbeit beginnen",
-  "memberPlaceholder": "Teammitglied {{index}} - E-Mail-Adresse eingeben",
-  "validEmailAddress": "Gültige E-Mail-Adresse",
-  "addAnotherTeamMember": "Weiteres Teammitglied hinzufügen ({{current}}/{{max}})",
-  "canInviteLater": "Sie können Teammitglieder jederzeit später einladen",
-  "skipStepDescription": "Haben Sie keine E-Mail-Adressen bereit? Kein Problem! Sie können diesen Schritt überspringen und Teammitglieder später über Ihr Projekt-Dashboard einladen.",
-
-  "orgCategoryTech": "Technologieunternehmen",
-  "orgCategoryCreative": "Kreativagenturen", 
-  "orgCategoryConsulting": "Beratung",
-  "orgCategoryStartups": "Startups",
-  "namingTip1": "Halten Sie es einfach und einprägsam",
-  "namingTip2": "Spiegeln Sie Ihre Branche oder Werte wider",
-  "namingTip3": "Denken Sie an zukünftiges Wachstum",
-  "namingTip4": "Machen Sie es einzigartig und markenfähig",
-
-  "aboutYouTitle": "Erzählen Sie uns von sich",
-  "aboutYouDescription": "Helfen Sie uns, Ihre Erfahrung zu personalisieren",
-  "orgTypeQuestion": "Was beschreibt Ihre Organisation am besten?",
-  "userRoleQuestion": "Was ist Ihre Rolle?",
-  
-  "yourNeedsTitle": "Was sind Ihre Hauptbedürfnisse?",
-  "yourNeedsDescription": "Wählen Sie alle zutreffenden aus, um uns bei der Einrichtung Ihres Arbeitsbereichs zu helfen",
-  "yourNeedsQuestion": "Wie werden Sie Worklenz hauptsächlich nutzen?",
-  "useCaseTaskOrg": "Aufgaben organisieren und verfolgen",
-  "useCaseTeamCollab": "Nahtlos zusammenarbeiten", 
-  "useCaseResourceMgmt": "Zeit und Ressourcen verwalten",
-  "useCaseClientComm": "Mit Kunden in Verbindung bleiben",
-  "useCaseTimeTrack": "Projektstunden überwachen",
-  "useCaseOther": "Etwas anderes",
-  "selectedText": "ausgewählt",
-  "previousToolsQuestion": "Welche Tools haben Sie zuvor verwendet? (Optional)",
-  "previousToolsPlaceholder": "z.B. Asana, Trello, Jira, Monday.com, etc.",
-  
-  "discoveryTitle": "Eine letzte Sache...",
-  "discoveryDescription": "Helfen Sie uns zu verstehen, wie Sie Worklenz entdeckt haben",
-  "discoveryQuestion": "Wie haben Sie von uns erfahren?",
-  "allSetTitle": "Sie sind bereit!",
-  "allSetDescription": "Lassen Sie uns Ihr erstes Projekt erstellen und mit Worklenz beginnen",
-  "surveyCompleteTitle": "Vielen Dank!",
-  "surveyCompleteDescription": "Ihr Feedback hilft uns, Worklenz für alle zu verbessern",
-  "aboutYouStepName": "Über Sie",
-  "yourNeedsStepName": "Ihre Bedürfnisse", 
-  "discoveryStepName": "Entdeckung",
-  "stepProgress": "Schritt {step} von 3: {title}",
-
-  "projectStepHeader": "Lassen Sie uns Ihr erstes Projekt erstellen",
-  "projectStepSubheader": "Von Grund auf beginnen oder eine Vorlage verwenden, um schneller voranzukommen",
-  "startFromScratch": "Von Grund auf beginnen",
-  "templateSelected": "Vorlage unten ausgewählt",
-  "quickSuggestions": "Schnelle Vorschläge:",
-  "orText": "ODER",
-  "startWithTemplate": "Mit einer Vorlage beginnen",
-  "clearToSelectTemplate": "Projektname oben löschen, um eine Vorlage auszuwählen",
-  "templateHeadStart": "Verschaffen Sie sich einen Vorsprung mit vorgefertigten Projektstrukturen",
-  "browseAllTemplates": "Alle Vorlagen durchsuchen",
-  "templatesAvailable": "15+ branchenspezifische Vorlagen verfügbar",
-  "chooseTemplate": "Wählen Sie eine Vorlage, die zu Ihrem Projekttyp passt",
-  "createProject": "Projekt erstellen",
-
-  "templateSoftwareDev": "Softwareentwicklung",
-  "templateSoftwareDesc": "Agile Sprints, Fehlerverfolgung, Releases",
-  "templateMarketing": "Marketing-Kampagne", 
-  "templateMarketingDesc": "Kampagnenplanung, Content-Kalender",
-  "templateConstruction": "Bauprojekt",
-  "templateConstructionDesc": "Phasen, Genehmigungen, Auftragnehmer",
-  "templateStartup": "Startup-Launch",
-  "templateStartupDesc": "MVP-Entwicklung, Finanzierung, Wachstum",
-
-  "tasksStepTitle": "Fügen Sie Ihre ersten Aufgaben hinzu",
-  "tasksStepDescription": "Unterteilen Sie \"{{projectName}}\" in umsetzbare Aufgaben, um zu beginnen",
-  "taskPlaceholder": "Aufgabe {{index}} - z.B., Was muss getan werden?",
-  "addAnotherTask": "Weitere Aufgabe hinzufügen ({{current}}/{{max}})",
-
-  "surveyStepTitle": "Erzählen Sie uns von sich",
-  "surveyStepLabel": "Helfen Sie uns, Ihre Worklenz-Erfahrung zu personalisieren, indem Sie ein paar Fragen beantworten.",
-  
-  "organizationType": "Was beschreibt Ihre Organisation am besten?",
-  "organizationTypeFreelancer": "Freelancer",
-  "organizationTypeStartup": "Startup",
-  "organizationTypeSmallMediumBusiness": "Kleines oder mittleres Unternehmen",
-  "organizationTypeAgency": "Agentur",
-  "organizationTypeEnterprise": "Unternehmen",
-  "organizationTypeOther": "Andere",
-  
-  "userRole": "Was ist Ihre Rolle?",
-  "userRoleFounderCeo": "Gründer / CEO",
-  "userRoleProjectManager": "Projektmanager",
-  "userRoleSoftwareDeveloper": "Software-Entwickler",
-  "userRoleDesigner": "Designer",
-  "userRoleOperations": "Betrieb",
-  "userRoleOther": "Andere",
-  
-  "mainUseCases": "Wofür werden Sie Worklenz hauptsächlich verwenden?",
-  "mainUseCasesTaskManagement": "Aufgabenverwaltung",
-  "mainUseCasesTeamCollaboration": "Teamzusammenarbeit",
-  "mainUseCasesResourcePlanning": "Ressourcenplanung",
-  "mainUseCasesClientCommunication": "Kundenkommunikation & Berichterstattung",
-  "mainUseCasesTimeTracking": "Zeiterfassung",
-  "mainUseCasesOther": "Andere",
-  
-  "previousTools": "Welche Tools haben Sie vor Worklenz verwendet?",
-  "previousToolsPlaceholder": "z.B. Trello, Asana, Monday.com",
-  
-  "howHeardAbout": "Wie haben Sie von Worklenz erfahren?",
-  "howHeardAboutGoogleSearch": "Google-Suche",
-  "howHeardAboutTwitter": "Twitter",
-  "howHeardAboutLinkedin": "LinkedIn",
-  "howHeardAboutFriendColleague": "Ein Freund oder Kollege",
-  "howHeardAboutBlogArticle": "Ein Blog oder Artikel",
-  "howHeardAboutOther": "Andere",
-  
-  "aboutYouStepTitle": "Erzählen Sie uns von sich",
-  "aboutYouStepDescription": "Helfen Sie uns, Ihre Erfahrung zu personalisieren",
-  "yourNeedsStepTitle": "Was sind Ihre Hauptbedürfnisse?",
-  "yourNeedsStepDescription": "Wählen Sie alle zutreffenden aus, um uns bei der Einrichtung Ihres Arbeitsbereichs zu helfen",
-  "selected": "ausgewählt",
-  "previousToolsLabel": "Welche Tools haben Sie zuvor verwendet? (Optional)",
-  
-  "roleSuggestions": {
-    "designer": "UI/UX, Grafiken, Kreativ",
-    "developer": "Frontend, Backend, Full-stack", 
-    "projectManager": "Planung, Koordination",
-    "marketing": "Inhalt, Social Media, Wachstum",
-    "sales": "Geschäftsentwicklung, Kundenbeziehungen",
-    "operations": "Admin, HR, Finanzen"
-  },
-  
-  "languages": {
-    "en": "English",
-    "es": "Español", 
-    "pt": "Português",
-    "de": "Deutsch",
-    "alb": "Shqip",
-    "zh": "简体中文"
-  },
-  
-  "orgSuggestions": {
-    "tech": ["TechCorp", "DevStudio", "CodeCraft", "PixelForge"],
-    "creative": ["Creative Hub", "Design Studio", "Brand Works", "Visual Arts"],
-    "consulting": ["Strategy Group", "Business Solutions", "Expert Advisors", "Growth Partners"],
-    "startup": ["Innovation Labs", "Future Works", "Venture Co", "Next Gen"]
-  },
-  
-  "projectSuggestions": {
-    "freelancer": ["Kundenprojekt", "Portfolio-Update", "Persönliche Marke"],
-    "startup": ["MVP-Entwicklung", "Produktlaunch", "Marktforschung"],
-    "agency": ["Kundenkampagne", "Markenstrategie", "Website-Redesign"],
-    "enterprise": ["Systemumstellung", "Prozessoptimierung", "Teamschulung"]
-  },
-  
-  "useCaseDescriptions": {
-    "taskManagement": "Aufgaben organisieren und verfolgen",
-    "teamCollaboration": "Nahtlos zusammenarbeiten",
-    "resourcePlanning": "Zeit und Ressourcen verwalten", 
-    "clientCommunication": "Mit Kunden in Verbindung bleiben",
-    "timeTracking": "Projektstunden überwachen",
-    "other": "Etwas anderes"
-  }
+  "maxTasks": " (Sie können bis zu 5 Aufgaben erstellen)"
 }
--- a/worklenz-frontend/public/locales/de/admin-center/configuration.json
+++ b/worklenz-frontend/public/locales/de/admin-center/configuration.json
@@ -1,26 +0,0 @@
-{
-  "billingDetails": "Abrechnungsdetails",
-  "name": "Name",
-  "namePlaceholder": "Name",
-  "emailAddress": "E-Mail-Adresse",
-  "emailPlaceholder": "E-Mail-Adresse",
-  "contactNumber": "Telefonnummer",
-  "phoneNumberPlaceholder": "Telefonnummer",
-  "phoneValidationError": "Telefonnummer muss genau 10 Ziffern haben",
-  "companyDetails": "Firmendetails",
-  "companyName": "Firmenname",
-  "companyNamePlaceholder": "Firmenname",
-  "addressLine01": "Adresszeile 01",
-  "addressLine01Placeholder": "Adresszeile 01",
-  "addressLine02": "Adresszeile 02",
-  "addressLine02Placeholder": "Adresszeile 02",
-  "country": "Land",
-  "countryPlaceholder": "Land",
-  "city": "Stadt",
-  "cityPlaceholder": "Stadt",
-  "state": "Bundesland",
-  "statePlaceholder": "Bundesland",
-  "postalCode": "Postleitzahl",
-  "postalCodePlaceholder": "Postleitzahl",
-  "save": "Speichern"
-}
--- a/worklenz-frontend/public/locales/de/auth/signup.json
+++ b/worklenz-frontend/public/locales/de/auth/signup.json
@@ -7,12 +7,12 @@
  "emailLabel": "E-Mail",
  "emailPlaceholder": "Ihre E-Mail-Adresse eingeben",
  "emailRequired": "Bitte geben Sie Ihre E-Mail-Adresse ein!",
-  "passwordLabel": "Passwort",
-  "passwordGuideline": "Das Passwort muss mindestens 8 Zeichen lang sein und Groß- und Kleinbuchstaben, eine Zahl und ein Sonderzeichen enthalten.",
-  "passwordPlaceholder": "Geben Sie Ihr Passwort ein",
+  "passwordLabel": "Password",
+  "passwordGuideline": "Password must be at least 8 characters, include uppercase and lowercase letters, a number, and a special character.",
+  "passwordPlaceholder": "Enter your password",
  "passwordRequired": "Bitte geben Sie Ihr Passwort ein!",
  "passwordMinCharacterRequired": "Das Passwort muss mindestens 8 Zeichen lang sein!",
-  "passwordMaxCharacterRequired": "Das Passwort darf maximal 32 Zeichen lang sein!",
+  "passwordMaxCharacterRequired": "Password must be at most 32 characters!",
  "passwordPatternRequired": "Das Passwort entspricht nicht den Anforderungen!",
  "strongPasswordPlaceholder": "Ein stärkeres Passwort eingeben",
  "passwordValidationAltText": "Das Passwort muss mindestens 8 Zeichen enthalten, mit Groß- und Kleinbuchstaben, einer Zahl und einem Sonderzeichen.",
--- a/worklenz-frontend/public/locales/de/common.json
+++ b/worklenz-frontend/public/locales/de/common.json
@@ -5,13 +5,5 @@
  "signup-failed": "Registrierung fehlgeschlagen. Bitte füllen Sie alle erforderlichen Felder aus und versuchen Sie es erneut.",
  "reconnecting": "Vom Server getrennt.",
  "connection-lost": "Verbindung zum Server fehlgeschlagen. Bitte überprüfen Sie Ihre Internetverbindung.",
-  "connection-restored": "Erfolgreich mit dem Server verbunden",
-  "cancel": "Abbrechen",
-  "update-available": "Worklenz aktualisiert!",
-  "update-description": "Eine neue Version von Worklenz ist verfügbar mit den neuesten Funktionen und Verbesserungen.",
-  "update-instruction": "Für die beste Erfahrung laden Sie bitte die Seite neu, um die neuen Änderungen zu übernehmen.",
-  "update-whats-new": "💡 <1>Was ist neu:</1> Verbesserte Leistung, Fehlerbehebungen und verbesserte Benutzererfahrung",
-  "update-now": "Jetzt aktualisieren",
-  "update-later": "Später",
-  "updating": "Wird aktualisiert..."
+  "connection-restored": "Erfolgreich mit dem Server verbunden"
 }
--- a/worklenz-frontend/public/locales/de/gantt/phase-details-modal.json
+++ b/worklenz-frontend/public/locales/de/gantt/phase-details-modal.json
@@ -1,36 +0,0 @@
-{
-  "title": "Phase Details",
-  "overview": {
-    "title": "Overview",
-    "totalTasks": "Total Tasks",
-    "completion": "Completion",
-    "progress": "Progress"
-  },
-  "timeline": {
-    "title": "Timeline",
-    "startDate": "Start Date",
-    "endDate": "End Date",
-    "status": "Status",
-    "notSet": "Not set",
-    "statusLabels": {
-      "upcoming": "Upcoming",
-      "active": "In Progress",
-      "overdue": "Overdue",
-      "notScheduled": "Not Scheduled"
-    }
-  },
-  "taskBreakdown": {
-    "title": "Task Breakdown",
-    "completed": "Completed",
-    "pending": "Pending",
-    "overdue": "Overdue"
-  },
-  "phaseColor": {
-    "title": "Phase Color",
-    "description": "Phase identifier color"
-  },
-  "tasksInPhase": {
-    "title": "Tasks in this Phase",
-    "noTasks": "No tasks in this phase"
-  }
-}
--- a/worklenz-frontend/public/locales/de/home.json
+++ b/worklenz-frontend/public/locales/de/home.json
@@ -41,22 +41,6 @@
    "list": "Liste",
    "calendar": "Kalender",
    "tasks": "Aufgaben",
-    "refresh": "Aktualisieren",
-    "recentActivity": "Aktuelle Aktivitäten",
-    "recentTasks": "Aktuelle Aufgaben",
-    "recentTasksSegment": "Aktuelle Aufgaben",
-    "timeLogged": "Erfasste Zeit",
-    "timeLoggedSegment": "Erfasste Zeit",
-    "noRecentTasks": "Keine aktuellen Aufgaben",
-    "noTimeLoggedTasks": "Keine Aufgaben mit erfasster Zeit",
-    "activityTag": "Aktivität",
-    "timeLogTag": "Zeiterfassung",
-    "timerTag": "Timer",
-    "activitySingular": "Aktivität",
-    "activityPlural": "Aktivitäten",
-    "recentTaskAriaLabel": "Aktuelle Aufgabe:",
-    "timeLoggedTaskAriaLabel": "Aufgabe mit erfasster Zeit:",
-    "errorLoadingRecentTasks": "Fehler beim Laden aktueller Aufgaben",
-    "errorLoadingTimeLoggedTasks": "Fehler beim Laden der Zeiterfassung"
+    "refresh": "Aktualisieren"
  }
 }
--- a/worklenz-frontend/public/locales/de/kanban-board.json
+++ b/worklenz-frontend/public/locales/de/kanban-board.json
@@ -10,17 +10,6 @@
  "deleteConfirmationOk": "Ja",
  "deleteConfirmationCancel": "Abbrechen",

-  "deleteTaskTitle": "Aufgabe löschen",
-  "deleteTaskContent": "Sind Sie sicher, dass Sie diese Aufgabe löschen möchten? Diese Aktion kann nicht rückgängig gemacht werden.",
-  "deleteTaskConfirm": "Löschen",
-  "deleteTaskCancel": "Abbrechen",
-
-  "deleteStatusTitle": "Status löschen",
-  "deleteStatusContent": "Sind Sie sicher, dass Sie diesen Status löschen möchten? Diese Aktion kann nicht rückgängig gemacht werden.",
-
-  "deletePhaseTitle": "Phase löschen",
-  "deletePhaseContent": "Sind Sie sicher, dass Sie diese Phase löschen möchten? Diese Aktion kann nicht rückgängig gemacht werden.",
-
  "dueDate": "Fälligkeitsdatum",
  "cancel": "Abbrechen",

@@ -37,17 +26,5 @@
  "noDueDate": "Kein Fälligkeitsdatum",
  "save": "Speichern",
  "clear": "Löschen",
-  "nextWeek": "Nächste Woche",
-  "noSubtasks": "Keine Unteraufgaben",
-  "showSubtasks": "Unteraufgaben anzeigen",
-  "hideSubtasks": "Unteraufgaben ausblenden",
-  
-  "errorLoadingTasks": "Fehler beim Laden der Aufgaben",
-  "noTasksFound": "Keine Aufgaben gefunden",
-  "loadingFilters": "Filter werden geladen...",
-  "failedToUpdateColumnOrder": "Fehler beim Aktualisieren der Spaltenreihenfolge",
-  "failedToUpdatePhaseOrder": "Fehler beim Aktualisieren der Phasenreihenfolge",
-  "pleaseTryAgain": "Bitte versuchen Sie es erneut",
-  "taskNotCompleted": "Aufgabe ist nicht abgeschlossen",
-  "completeTaskDependencies": "Bitte schließen Sie die Aufgabenabhängigkeiten ab, bevor Sie fortfahren"
+  "nextWeek": "Nächste Woche"
 }
--- a/worklenz-frontend/public/locales/de/project-view-members.json
+++ b/worklenz-frontend/public/locales/de/project-view-members.json
@@ -13,6 +13,5 @@
  "deleteButtonTooltip": "Aus Projekt entfernen",
  "memberCount": "Mitglied",
  "membersCountPlural": "Mitglieder",
-  "emptyText": "Es gibt keine Anhänge in diesem Projekt.",
-  "searchPlaceholder": "Mitglieder suchen"
+  "emptyText": "Es gibt keine Anhänge in diesem Projekt."
 }
--- a/worklenz-frontend/public/locales/de/project-view/project-member-drawer.json
+++ b/worklenz-frontend/public/locales/de/project-view/project-member-drawer.json
@@ -3,9 +3,5 @@
  "searchLabel": "Mitglieder hinzufügen durch Eingabe von Name oder E-Mail",
  "searchPlaceholder": "Name oder E-Mail eingeben",
  "inviteAsAMember": "Als Mitglied einladen",
-  "inviteNewMemberByEmail": "Neues Mitglied per E-Mail einladen",
-  "members": "Mitglieder",
-  "copyProjectLink": "Projektlink kopieren",
-  "inviteMember": "Mitglied einladen",
-  "alsoInviteToProject": "Auch zum Projekt einladen"
+  "inviteNewMemberByEmail": "Neues Mitglied per E-Mail einladen"
 }
--- a/worklenz-frontend/public/locales/de/settings/team-members.json
+++ b/worklenz-frontend/public/locales/de/settings/team-members.json
@@ -28,7 +28,7 @@
  "jobTitleLabel": "Jobtitel",
  "jobTitlePlaceholder": "Jobtitel auswählen oder suchen (optional)",
  "memberAccessLabel": "Zugriffslevel",
-  "addToTeamButton": "Einladung senden",
+  "addToTeamButton": "Mitglied zum Team hinzufügen",
  "updateButton": "Änderungen speichern",
  "resendInvitationButton": "Einladungs-E-Mail erneut senden",
  "invitationSentSuccessMessage": "Team-Einladung erfolgreich versendet!",
@@ -43,6 +43,5 @@
  "updatedText": "Aktualisiert",
  "noResultFound": "Geben Sie eine E-Mail-Adresse ein und drücken Sie Enter...",
  "jobTitlesFetchError": "Fehler beim Abrufen der Jobtitel",
-  "invitationResent": "Einladung erfolgreich erneut gesendet!",
-  "copyTeamLink": "Team-Link kopieren"
+  "invitationResent": "Einladung erfolgreich erneut gesendet!"
 }
--- a/worklenz-frontend/public/locales/de/survey.json
+++ b/worklenz-frontend/public/locales/de/survey.json
@@ -1,14 +0,0 @@
-{
-  "modalTitle": "Helfen Sie uns, Ihre Erfahrung zu verbessern",
-  "skip": "Für jetzt überspringen",
-  "previous": "Zurück",
-  "next": "Weiter",
-  "completeSurvey": "Umfrage abschließen",
-  "submitting": "Ihre Antworten werden übermittelt...",
-  "submitSuccessTitle": "Danke!",
-  "submitSuccessSubtitle": "Ihr Feedback hilft uns, Worklenz für alle zu verbessern.",
-  "submitSuccessMessage": "Danke, dass Sie die Umfrage abgeschlossen haben!",
-  "submitErrorMessage": "Umfrage konnte nicht übermittelt werden. Bitte versuchen Sie es erneut.",
-  "submitErrorLog": "Umfrageübermittlung fehlgeschlagen",
-  "fetchErrorLog": "Umfrageabruf fehlgeschlagen"
-} 
--- a/worklenz-frontend/public/locales/de/task-list-filters.json
+++ b/worklenz-frontend/public/locales/de/task-list-filters.json
@@ -84,12 +84,5 @@
  "close": "Schließen",
  "cannotMoveStatus": "Status kann nicht verschoben werden",
  "cannotMoveStatusMessage": "Dieser Status kann nicht verschoben werden, da die Kategorie '{{categoryName}}' leer bleiben würde. Jede Kategorie muss mindestens einen Status haben.",
-  "ok": "OK",
-  "clearSort": "Sortierung löschen",
-  "sortAscending": "Aufsteigend sortieren",
-  "sortDescending": "Absteigend sortieren",
-  "sortByField": "Sortieren nach {{field}}",
-  "ascendingOrder": "Aufsteigend",
-  "descendingOrder": "Absteigend",
-  "currentSort": "Aktuelle Sortierung: {{field}} {{order}}"
+  "ok": "OK"
 }
--- a/worklenz-frontend/public/locales/de/task-list-table.json
+++ b/worklenz-frontend/public/locales/de/task-list-table.json
@@ -57,9 +57,6 @@

  "contextMenu": {
    "assignToMe": "Mir zuweisen",
-    "copyLink": "Link zur Aufgabe kopieren",
-    "linkCopied": "Link in die Zwischenablage kopiert",
-    "linkCopyFailed": "Fehler beim Kopieren des Links",
    "moveTo": "Verschieben nach",
    "unarchive": "Dearchivieren",
    "archive": "Archivieren",
@@ -136,11 +133,5 @@
      "dependencies": "Aufgabe hat Abhängigkeiten",
      "recurring": "Wiederkehrende Aufgabe"
    }
-  },
-
-  "timer": {
-    "conflictTitle": "Timer läuft bereits",
-    "conflictMessage": "Sie haben einen Timer für \"{{taskName}}\" im Projekt \"{{projectName}}\" laufen. Möchten Sie diesen Timer stoppen und einen neuen für diese Aufgabe starten?",
-    "stopAndStart": "Stoppen & Neuen Timer starten"
  }
 }
--- a/worklenz-frontend/public/locales/en/account-setup.json
+++ b/worklenz-frontend/public/locales/en/account-setup.json
@@ -1,35 +1,15 @@
 {
  "continue": "Continue",

-  "setupYourAccount": "Setup Your Account.",
+  "setupYourAccount": "Setup Your Worklenz Account.",
  "organizationStepTitle": "Name Your Organization",
-  "organizationStepWelcome": "Welcome to Worklenz!",
-  "organizationStepDescription": "Let's start by setting up your organization. This will be the main workspace for your team.",
-  "organizationStepLabel": "Organization name",
-  "organizationStepPlaceholder": "e.g. Acme Corporation",
-  "organizationStepTooltip": "This name will appear in your workspace and can be changed later in settings.",
-  "organizationStepNeedIdeas": "Need ideas?",
-  "organizationStepUseDetected": "Use detected:",
-  "organizationStepCharacters": "characters",
-  "organizationStepGoodLength": "Good length",
-  "organizationStepTooShort": "Too short",
-  "organizationStepNamingTips": "Naming Tips",
-  "organizationStepTip1": "Keep it simple and memorable",
-  "organizationStepTip2": "Reflect your industry or values", 
-  "organizationStepTip3": "Think about future growth",
-  "organizationStepTip4": "Make it unique and brandable",
-  "organizationStepSuggestionsTitle": "Name Suggestions",
-  "organizationStepCategory1": "Tech Companies",
-  "organizationStepCategory2": "Creative Agencies", 
-  "organizationStepCategory3": "Consulting",
-  "organizationStepCategory4": "Startups",
-  "organizationStepSuggestionsNote": "These are just examples to get you started. Choose something that represents your organization.",
-  "organizationStepPrivacyNote": "Your organization name is private and only visible to your team members.",
+  "organizationStepLabel": "Pick a name for your Worklenz account.",

  "projectStepTitle": "Create your first project",
  "projectStepLabel": "What project are you working on right now?",
  "projectStepPlaceholder": "e.g. Marketing Plan",

+  "tasksStepTitle": "Create your first tasks",
  "tasksStepLabel": "Type a few tasks that you are going to do in",
  "tasksStepAddAnother": "Add another",

@@ -44,169 +24,8 @@
  "step3InputLabel": "Invite with email",
  "addAnother": "Add another",
  "skipForNow": "Skip for now",
-  "skipping": "Skipping...",
  "formTitle": "Create your first task.",
  "step3Title": "Invite your team to work with",
  "maxMembers": " (You can invite up to 5 members)",
-  "maxTasks": " (You can create up to 5 tasks)",
-
-  "membersStepTitle": "Invite your team",
-  "membersStepDescription": "Add team members to \"{{organizationName}}\" and start collaborating",
-  "memberPlaceholder": "Team member {{index}} - Enter email address",
-  "validEmailAddress": "Valid email address",
-  "addAnotherTeamMember": "Add another team member ({{current}}/{{max}})",
-  "canInviteLater": "You can always invite team members later",
-  "skipStepDescription": "Don't have email addresses ready? No problem! You can skip this step and invite team members from your project dashboard later.",
-
-  "orgCategoryTech": "Tech Companies",
-  "orgCategoryCreative": "Creative Agencies", 
-  "orgCategoryConsulting": "Consulting",
-  "orgCategoryStartups": "Startups",
-  "namingTip1": "Keep it simple and memorable",
-  "namingTip2": "Reflect your industry or values",
-  "namingTip3": "Think about future growth",
-  "namingTip4": "Make it unique and brandable",
-
-  "aboutYouTitle": "Tell us about yourself",
-  "aboutYouDescription": "Help us personalize your experience",
-  "orgTypeQuestion": "What best describes your organization?",
-  "userRoleQuestion": "What's your role?",
-  
-  "yourNeedsTitle": "What are your main needs?",
-  "yourNeedsDescription": "Select all that apply to help us set up your workspace",
-  "yourNeedsQuestion": "How will you primarily use Worklenz?",
-  "useCaseTaskOrg": "Organize and track tasks",
-  "useCaseTeamCollab": "Work together seamlessly", 
-  "useCaseResourceMgmt": "Manage time and resources",
-  "useCaseClientComm": "Stay connected with clients",
-  "useCaseTimeTrack": "Monitor project hours",
-  "useCaseOther": "Something else",
-  "selectedText": "selected",
-  "previousToolsQuestion": "What tools have you used before? (Optional)",
-  
-  "discoveryTitle": "One last thing...",
-  "discoveryDescription": "Help us understand how you discovered Worklenz",
-  "discoveryQuestion": "How did you hear about us?",
-  "allSetTitle": "You're all set!",
-  "allSetDescription": "Let's create your first project and get started with Worklenz",
-  "surveyCompleteTitle": "Thank you!",
-  "surveyCompleteDescription": "Your feedback helps us improve Worklenz for everyone",
-  "aboutYouStepName": "About You",
-  "yourNeedsStepName": "Your Needs", 
-  "discoveryStepName": "Discovery",
-  "stepProgress": "Step {step} of 3: {title}",
-
-  "projectStepHeader": "Let's create your first project",
-  "projectStepSubheader": "Start from scratch or use a template to get going faster",
-  "startFromScratch": "Start from scratch",
-  "templateSelected": "Template selected below",
-  "quickSuggestions": "Quick suggestions:",
-  "orText": "OR",
-  "startWithTemplate": "Start with a template",
-  "clearToSelectTemplate": "Clear project name above to select a template",
-  "templateHeadStart": "Get a head start with pre-built project structures",
-  "browseAllTemplates": "Browse All Templates",
-  "templatesAvailable": "15+ industry-specific templates available",
-  "chooseTemplate": "Choose a template that matches your project type",
-  "createProject": "Create Project",
-
-  "templateSoftwareDev": "Software Development",
-  "templateSoftwareDesc": "Agile sprints, bug tracking, releases",
-  "templateMarketing": "Marketing Campaign", 
-  "templateMarketingDesc": "Campaign planning, content calendar",
-  "templateConstruction": "Construction Project",
-  "templateConstructionDesc": "Phases, permits, contractors",
-  "templateStartup": "Startup Launch",
-  "templateStartupDesc": "MVP development, funding, growth",
-
-  "tasksStepTitle": "Add your first tasks",
-  "tasksStepDescription": "Break down \"{{projectName}}\" into actionable tasks to get started",
-  "taskPlaceholder": "Task {{index}} - e.g., What needs to be done?",
-  "addAnotherTask": "Add another task ({{current}}/{{max}})",
-
-  "surveyStepTitle": "Tell us about yourself",
-  "surveyStepLabel": "Help us personalize your Worklenz experience by answering a few questions.",
-  
-  "organizationType": "What best describes your organization?",
-  "organizationTypeFreelancer": "Freelancer",
-  "organizationTypeStartup": "Startup",
-  "organizationTypeSmallMediumBusiness": "Small or Medium Business",
-  "organizationTypeAgency": "Agency",
-  "organizationTypeEnterprise": "Enterprise",
-  "organizationTypeOther": "Other",
-  
-  "userRole": "What is your role?",
-  "userRoleFounderCeo": "Founder / CEO",
-  "userRoleProjectManager": "Project Manager",
-  "userRoleSoftwareDeveloper": "Software Developer",
-  "userRoleDesigner": "Designer",
-  "userRoleOperations": "Operations",
-  "userRoleOther": "Other",
-  
-  "mainUseCases": "What will you mainly use Worklenz for?",
-  "mainUseCasesTaskManagement": "Task management",
-  "mainUseCasesTeamCollaboration": "Team collaboration",
-  "mainUseCasesResourcePlanning": "Resource planning",
-  "mainUseCasesClientCommunication": "Client communication & reporting",
-  "mainUseCasesTimeTracking": "Time tracking",
-  "mainUseCasesOther": "Other",
-  
-  "previousTools": "What tool(s) were you using before Worklenz?",
-  "previousToolsPlaceholder": "e.g. Trello, Asana, Monday.com",
-  
-  "howHeardAbout": "How did you hear about Worklenz?",
-  "howHeardAboutGoogleSearch": "Google Search",
-  "howHeardAboutTwitter": "Twitter",
-  "howHeardAboutLinkedin": "LinkedIn",
-  "howHeardAboutFriendColleague": "A friend or colleague",
-  "howHeardAboutBlogArticle": "A blog or article",
-  "howHeardAboutOther": "Other",
-  
-  "aboutYouStepTitle": "Tell us about yourself",
-  "aboutYouStepDescription": "Help us personalize your experience",
-  "yourNeedsStepTitle": "What are your main needs?",
-  "yourNeedsStepDescription": "Select all that apply to help us set up your workspace",
-  "selected": "selected",
-  "previousToolsLabel": "What tools have you used before? (Optional)",
-  
-  "roleSuggestions": {
-    "designer": "UI/UX, Graphics, Creative",
-    "developer": "Frontend, Backend, Full-stack", 
-    "projectManager": "Planning, Coordination",
-    "marketing": "Content, Social Media, Growth",
-    "sales": "Business Development, Client Relations",
-    "operations": "Admin, HR, Finance"
-  },
-  
-  "languages": {
-    "en": "English",
-    "es": "Español", 
-    "pt": "Português",
-    "de": "Deutsch",
-    "alb": "Shqip",
-    "zh": "简体中文"
-  },
-  
-  "orgSuggestions": {
-    "tech": ["TechCorp", "DevStudio", "CodeCraft", "PixelForge"],
-    "creative": ["Creative Hub", "Design Studio", "Brand Works", "Visual Arts"],
-    "consulting": ["Strategy Group", "Business Solutions", "Expert Advisors", "Growth Partners"],
-    "startup": ["Innovation Labs", "Future Works", "Venture Co", "Next Gen"]
-  },
-  
-  "projectSuggestions": {
-    "freelancer": ["Client Project", "Portfolio Update", "Personal Brand"],
-    "startup": ["MVP Development", "Product Launch", "Market Research"],
-    "agency": ["Client Campaign", "Brand Strategy", "Website Redesign"],
-    "enterprise": ["System Migration", "Process Optimization", "Team Training"]
-  },
-  
-  "useCaseDescriptions": {
-    "taskManagement": "Organize and track tasks",
-    "teamCollaboration": "Work together seamlessly",
-    "resourcePlanning": "Manage time and resources", 
-    "clientCommunication": "Stay connected with clients",
-    "timeTracking": "Monitor project hours",
-    "other": "Something else"
-  }
+  "maxTasks": " (You can create up to 5 tasks)"
 }
--- a/worklenz-frontend/public/locales/en/admin-center/configuration.json
+++ b/worklenz-frontend/public/locales/en/admin-center/configuration.json
@@ -1,26 +0,0 @@
-{
-  "billingDetails": "Billing Details",
-  "name": "Name",
-  "namePlaceholder": "Name",
-  "emailAddress": "Email Address",
-  "emailPlaceholder": "Email Address",
-  "contactNumber": "Contact Number",
-  "phoneNumberPlaceholder": "Phone Number",
-  "phoneValidationError": "Phone number must be exactly 10 digits",
-  "companyDetails": "Company Details",
-  "companyName": "Company Name",
-  "companyNamePlaceholder": "Company Name",
-  "addressLine01": "Address Line 01",
-  "addressLine01Placeholder": "Address Line 01",
-  "addressLine02": "Address Line 02",
-  "addressLine02Placeholder": "Address Line 02",
-  "country": "Country",
-  "countryPlaceholder": "Country",
-  "city": "City",
-  "cityPlaceholder": "City",
-  "state": "State",
-  "statePlaceholder": "State",
-  "postalCode": "Postal Code",
-  "postalCodePlaceholder": "Postal Code",
-  "save": "Save"
-}
--- a/worklenz-frontend/public/locales/en/admin-center/current-bill.json
+++ b/worklenz-frontend/public/locales/en/admin-center/current-bill.json
@@ -117,26 +117,5 @@
  "currentSeatsText": "You currently have {{seats}} seats available.",
  "selectSeatsText": "Please select the number of additional seats to purchase.",
  "purchase": "Purchase",
-  "contactSales": "Contact sales",
-  "submitSuccess": "Code redeemed successfully!",
-  "submitSuccessDescription": "Your account has been updated with the new credits.",
-  "percentUsed": "% Used",
-  "sizeUnits": {
-    "bytes": "Bytes",
-    "kb": "KB", 
-    "mb": "MB",
-    "gb": "GB",
-    "tb": "TB"
-  },
-  "seatPerMonth": "seat / month",
-  "totalPrice": "Total $",
-  "tryForFree": "Try for free",
-  "subscriptionUpdateSuccess": "Subscription updated successfully!",
-  "paymentProcessorError": "Failed to load payment processor",
-  "seatsLabel": "Seats:",
-  "requiredField": "*",
-  "purchaseSeatsTextSingle": "To continue, you'll need to purchase an additional seat.",
-  "singleUserNote": "You currently have 1 seat available.",
-  "selectSeatsTextSingle": "Please select the number of additional seats to purchase.",
-  "phoneNumberPattern": "07xxxxxxxx"
+  "contactSales": "Contact sales"
 }
--- a/worklenz-frontend/public/locales/en/admin-center/overview.json
+++ b/worklenz-frontend/public/locales/en/admin-center/overview.json
@@ -4,8 +4,5 @@
  "owner": "Organization Owner",
  "admins": "Organization Admins",
  "contactNumber": "Add Contact Number",
-  "edit": "Edit",
-  "emailAddress": "Email Address",
-  "enterOrganizationName": "Enter organization name",
-  "ownerSuffix": " (Owner)"
+  "edit": "Edit"
 }
--- a/worklenz-frontend/public/locales/en/admin-center/users.json
+++ b/worklenz-frontend/public/locales/en/admin-center/users.json
@@ -5,6 +5,5 @@
  "user": "User",
  "email": "Email",
  "lastActivity": "Last Activity",
-  "refresh": "Refresh users",
-  "name": "Name"
+  "refresh": "Refresh users"
 }
--- a/worklenz-frontend/public/locales/en/common.json
+++ b/worklenz-frontend/public/locales/en/common.json
@@ -5,13 +5,5 @@
  "signup-failed": "Signup failed. Please ensure all required fields are filled and try again.",
  "reconnecting": "Disconnected from server.",
  "connection-lost": "Failed to connect to server. Please check your internet connection.",
-  "connection-restored": "Connected to server successfully",
-  "cancel": "Cancel",
-  "update-available": "Worklenz Updated!",
-  "update-description": "A new version of Worklenz is available with the latest features and improvements.",
-  "update-instruction": "To get the best experience, please reload the page to apply the new changes.",
-  "update-whats-new": "💡 <1>What's new:</1> Enhanced performance, bug fixes, and improved user experience",
-  "update-now": "Update Now",
-  "update-later": "Later",
-  "updating": "Updating..."
+  "connection-restored": "Connected to server successfully"
 }
--- a/worklenz-frontend/public/locales/en/gantt/phase-details-modal.json
+++ b/worklenz-frontend/public/locales/en/gantt/phase-details-modal.json
@@ -1,42 +0,0 @@
-{
-  "title": "Phase Details",
-  "overview": {
-    "title": "Overview",
-    "totalTasks": "Total Tasks",
-    "completion": "Completion",
-    "progress": "Progress"
-  },
-  "timeline": {
-    "title": "Timeline",
-    "startDate": "Start Date",
-    "endDate": "End Date",
-    "status": "Status",
-    "notSet": "Not set",
-    "statusLabels": {
-      "upcoming": "Upcoming",
-      "active": "In Progress",
-      "overdue": "Overdue",
-      "notScheduled": "Not Scheduled"
-    }
-  },
-  "taskBreakdown": {
-    "title": "Task Breakdown",
-    "completed": "Completed",
-    "pending": "Pending",
-    "overdue": "Overdue"
-  },
-  "phaseColor": {
-    "title": "Phase Color",
-    "description": "Phase identifier color"
-  },
-  "tasksInPhase": {
-    "title": "Tasks in this Phase",
-    "noTasks": "No tasks in this phase",
-    "priority": "Priority",
-    "assignees": "Assignees",
-    "dueDate": "Due Date",
-    "startDate": "Start Date",
-    "noAssignees": "Unassigned",
-    "noDueDate": "No due date"
-  }
-}
--- a/worklenz-frontend/public/locales/en/home.json
+++ b/worklenz-frontend/public/locales/en/home.json
@@ -41,22 +41,6 @@
    "list": "List",
    "calendar": "Calendar",
    "tasks": "Tasks",
-    "refresh": "Refresh",
-    "recentActivity": "Recent Activity",
-    "recentTasks": "Recent Tasks",
-    "recentTasksSegment": "Recent Tasks",
-    "timeLogged": "Time Logged",
-    "timeLoggedSegment": "Time Logged",
-    "noRecentTasks": "No recent tasks",
-    "noTimeLoggedTasks": "No time logged tasks",
-    "activityTag": "Activity",
-    "timeLogTag": "Time Log", 
-    "timerTag": "Timer",
-    "activitySingular": "activity",
-    "activityPlural": "activities",
-    "recentTaskAriaLabel": "Recent task:",
-    "timeLoggedTaskAriaLabel": "Time logged task:",
-    "errorLoadingRecentTasks": "Error loading recent tasks",
-    "errorLoadingTimeLoggedTasks": "Error loading time logged tasks"
+    "refresh": "Refresh"
  }
 }
--- a/worklenz-frontend/public/locales/en/kanban-board.json
+++ b/worklenz-frontend/public/locales/en/kanban-board.json
@@ -10,17 +10,6 @@
  "deleteConfirmationOk": "Yes",
  "deleteConfirmationCancel": "Cancel",

-  "deleteTaskTitle": "Delete Task",
-  "deleteTaskContent": "Are you sure you want to delete this task? This action cannot be undone.",
-  "deleteTaskConfirm": "Delete",
-  "deleteTaskCancel": "Cancel",
-
-  "deleteStatusTitle": "Delete Status",
-  "deleteStatusContent": "Are you sure you want to delete this status? This action cannot be undone.",
-
-  "deletePhaseTitle": "Delete Phase",
-  "deletePhaseContent": "Are you sure you want to delete this phase? This action cannot be undone.",
-
  "dueDate": "Due date",
  "cancel": "Cancel",

@@ -40,14 +29,5 @@
  "nextWeek": "Next week",
  "noSubtasks": "No subtasks",
  "showSubtasks": "Show subtasks",
-  "hideSubtasks": "Hide subtasks",
-  
-  "errorLoadingTasks": "Error loading tasks",
-  "noTasksFound": "No tasks found",
-  "loadingFilters": "Loading filters...",
-  "failedToUpdateColumnOrder": "Failed to update column order",
-  "failedToUpdatePhaseOrder": "Failed to update phase order",
-  "pleaseTryAgain": "Please try again",
-  "taskNotCompleted": "Task is not completed",
-  "completeTaskDependencies": "Please complete the task dependencies before proceeding"
+  "hideSubtasks": "Hide subtasks"
 }
--- a/worklenz-frontend/public/locales/en/project-view-members.json
+++ b/worklenz-frontend/public/locales/en/project-view-members.json
@@ -13,6 +13,5 @@
  "deleteButtonTooltip": "Remove from project",
  "memberCount": "Member",
  "membersCountPlural": "Members",
-  "emptyText": "There are no attachments in the project.",
-  "searchPlaceholder": "Search members"
+  "emptyText": "There are no attachments in the project."
 }
--- a/worklenz-frontend/public/locales/en/project-view/project-member-drawer.json
+++ b/worklenz-frontend/public/locales/en/project-view/project-member-drawer.json
@@ -1,11 +1,7 @@
 {
-  "title": "Share Project",
+  "title": "Project Members",
  "searchLabel": "Add members by adding their name or email",
  "searchPlaceholder": "Type name or email",
  "inviteAsAMember": "Invite as a member",
-  "inviteNewMemberByEmail": "Invite new member by email",
-  "members": "Members",
-  "copyProjectLink": "Copy project link",
-  "inviteMember": "Invite Member",
-  "alsoInviteToProject": "Also invite to project"
+  "inviteNewMemberByEmail": "Invite new member by email"
 }
--- a/worklenz-frontend/public/locales/en/settings/team-members.json
+++ b/worklenz-frontend/public/locales/en/settings/team-members.json
@@ -19,7 +19,7 @@
  "cancelText": "No, cancel",
  "deactivatedText": "(Currently deactivated)",
  "pendingInvitationText": "(Invitation pending)",
-  "addMemberDrawerTitle": "Invite Team Members",
+  "addMemberDrawerTitle": "Add New Team Member",
  "updateMemberDrawerTitle": "Update Team Member",
  "addMemberEmailHint": "Members will be added to the team regardless of invitation acceptance status",
  "memberEmailLabel": "Email(s)",
@@ -28,7 +28,7 @@
  "jobTitleLabel": "Job Title",
  "jobTitlePlaceholder": "Select or search job title (Optional)",
  "memberAccessLabel": "Access Level",
-  "addToTeamButton": "Send Invitation",
+  "addToTeamButton": "Add Member to Team",
  "updateButton": "Save Changes",
  "resendInvitationButton": "Resend Invitation Email",
  "invitationSentSuccessMessage": "Team invitation sent successfully!",
@@ -43,6 +43,5 @@
  "updatedText": "Updated",
  "noResultFound": "Type an email address and hit enter...",
  "jobTitlesFetchError": "Failed to fetch job titles",
-  "invitationResent": "Invitation resent successfully!",
-  "copyTeamLink": "Copy team link"
+  "invitationResent": "Invitation resent successfully!"
 }
--- a/worklenz-frontend/public/locales/en/survey.json
+++ b/worklenz-frontend/public/locales/en/survey.json
@@ -1,14 +0,0 @@
-{
-  "modalTitle": "Help Us Improve Your Experience",
-  "skip": "Skip for now",
-  "previous": "Previous",
-  "next": "Next",
-  "completeSurvey": "Complete Survey",
-  "submitting": "Submitting your responses...",
-  "submitSuccessTitle": "Thank you!",
-  "submitSuccessSubtitle": "Your feedback helps us improve Worklenz for everyone.",
-  "submitSuccessMessage": "Thank you for completing the survey!",
-  "submitErrorMessage": "Failed to submit survey. Please try again.",
-  "submitErrorLog": "Failed to submit survey",
-  "fetchErrorLog": "Failed to fetch survey"
-} 
--- a/worklenz-frontend/public/locales/en/task-list-filters.json
+++ b/worklenz-frontend/public/locales/en/task-list-filters.json
@@ -84,12 +84,5 @@
  "close": "Close",
  "cannotMoveStatus": "Cannot Move Status",
  "cannotMoveStatusMessage": "Cannot move this status because it would leave the '{{categoryName}}' category empty. Each category must have at least one status.",
-  "ok": "OK",
-  "clearSort": "Clear Sort",
-  "sortAscending": "Sort Ascending",
-  "sortDescending": "Sort Descending",
-  "sortByField": "Sort by {{field}}",
-  "ascendingOrder": "Ascending",
-  "descendingOrder": "Descending",
-  "currentSort": "Current sort: {{field}} {{order}}"
+  "ok": "OK"
 }
--- a/worklenz-frontend/public/locales/en/task-list-table.json
+++ b/worklenz-frontend/public/locales/en/task-list-table.json
@@ -57,9 +57,6 @@

  "contextMenu": {
    "assignToMe": "Assign to me",
-    "copyLink": "Copy link to task",
-    "linkCopied": "Link copied to clipboard",
-    "linkCopyFailed": "Failed to copy link",
    "moveTo": "Move to",
    "unarchive": "Unarchive",
    "archive": "Archive",
@@ -136,11 +133,5 @@
      "dependencies": "Task has dependencies",
      "recurring": "Recurring task"
    }
-  },
-
-  "timer": {
-    "conflictTitle": "Timer Already Running",
-    "conflictMessage": "You have a timer running for \"{{taskName}}\" in project \"{{projectName}}\". Would you like to stop that timer and start a new one for this task?",
-    "stopAndStart": "Stop & Start New Timer"
  }
 }
--- a/worklenz-frontend/public/locales/es/account-setup.json
+++ b/worklenz-frontend/public/locales/es/account-setup.json
@@ -3,28 +3,7 @@

  "setupYourAccount": "Configura tu cuenta.",
  "organizationStepTitle": "Nombra tu organización",
-  "organizationStepWelcome": "¡Bienvenido a Worklenz!",
-  "organizationStepDescription": "Comencemos configurando tu organización. Este será el espacio de trabajo principal para tu equipo.",
-  "organizationStepLabel": "Nombre de la organización",
-  "organizationStepPlaceholder": "ej. Corporación Acme",
-  "organizationStepTooltip": "Este nombre aparecerá en tu espacio de trabajo y se puede cambiar más tarde en la configuración.",
-  "organizationStepNeedIdeas": "¿Necesitas ideas?",
-  "organizationStepUseDetected": "Usar detectado:",
-  "organizationStepCharacters": "caracteres",
-  "organizationStepGoodLength": "Buena longitud",
-  "organizationStepTooShort": "Demasiado corto",
-  "organizationStepNamingTips": "Consejos para nombrar",
-  "organizationStepTip1": "Manténlo simple y memorable",
-  "organizationStepTip2": "Refleja tu industria o valores",
-  "organizationStepTip3": "Piensa en el crecimiento futuro",
-  "organizationStepTip4": "Hazlo único y reconocible",
-  "organizationStepSuggestionsTitle": "Sugerencias de nombres",
-  "organizationStepCategory1": "Empresas tecnológicas",
-  "organizationStepCategory2": "Agencias creativas",
-  "organizationStepCategory3": "Consultoría",
-  "organizationStepCategory4": "Startups",
-  "organizationStepSuggestionsNote": "Estos son solo ejemplos para empezar. Elige algo que represente a tu organización.",
-  "organizationStepPrivacyNote": "El nombre de tu organización es privado y solo visible para los miembros de tu equipo.",
+  "organizationStepLabel": "Elige un nombre para tu cuenta de Worklenz.",

  "projectStepTitle": "Crea tu primer proyecto",
  "projectStepLabel": "¿En qué proyecto estás trabajando ahora?",
@@ -45,171 +24,9 @@
  "step3InputLabel": "Invitar por correo electrónico",
  "addAnother": "Agregar otro",
  "skipForNow": "Omitir por ahora",
-  "skipping": "Omitiendo...",
  "formTitle": "Crea tu primera tarea.",
  "step3Title": "Invita a tu equipo a trabajar",

  "maxMembers": " (Puedes invitar hasta 5 miembros)",
-  "maxTasks": " (Puedes crear hasta 5 tareas)",
-
-  "membersStepTitle": "Invita a tu equipo",
-  "membersStepDescription": "Añade miembros del equipo a \"{{organizationName}}\" y comienza a colaborar",
-  "memberPlaceholder": "Miembro del equipo {{index}} - Ingresa dirección de correo",
-  "validEmailAddress": "Dirección de correo válida",
-  "addAnotherTeamMember": "Añadir otro miembro del equipo ({{current}}/{{max}})",
-  "canInviteLater": "Siempre puedes invitar miembros del equipo más tarde",
-  "skipStepDescription": "¿No tienes direcciones de correo listas? ¡No hay problema! Puedes omitir este paso e invitar miembros del equipo desde tu panel de proyecto más tarde.",
-
-  "orgCategoryTech": "Empresas Tecnológicas",
-  "orgCategoryCreative": "Agencias Creativas", 
-  "orgCategoryConsulting": "Consultoría",
-  "orgCategoryStartups": "Startups",
-  "namingTip1": "Manténlo simple y memorable",
-  "namingTip2": "Refleja tu industria o valores",
-  "namingTip3": "Piensa en el crecimiento futuro",
-  "namingTip4": "Hazlo único y reconocible",
-
-  "aboutYouTitle": "Cuéntanos sobre ti",
-  "aboutYouDescription": "Ayúdanos a personalizar tu experiencia",
-  "orgTypeQuestion": "¿Qué describe mejor tu organización?",
-  "userRoleQuestion": "¿Cuál es tu rol?",
-  
-  "yourNeedsTitle": "¿Cuáles son tus principales necesidades?",
-  "yourNeedsDescription": "Selecciona todas las que apliquen para ayudarnos a configurar tu espacio de trabajo",
-  "yourNeedsQuestion": "¿Cómo usarás principalmente Worklenz?",
-  "useCaseTaskOrg": "Organizar y hacer seguimiento de tareas",
-  "useCaseTeamCollab": "Trabajar juntos sin problemas", 
-  "useCaseResourceMgmt": "Gestionar tiempo y recursos",
-  "useCaseClientComm": "Mantenerse conectado con clientes",
-  "useCaseTimeTrack": "Monitorear horas de proyecto",
-  "useCaseOther": "Algo más",
-  "selectedText": "seleccionado",
-  "previousToolsQuestion": "¿Qué herramientas has usado antes? (Opcional)",
-  "previousToolsPlaceholder": "ej., Asana, Trello, Jira, Monday.com, etc.",
-  
-  "discoveryTitle": "Una última cosa...",
-  "discoveryDescription": "Ayúdanos a entender cómo descubriste Worklenz",
-  "discoveryQuestion": "¿Cómo te enteraste de nosotros?",
-  "allSetTitle": "¡Ya estás listo!",
-  "allSetDescription": "Vamos a crear tu primer proyecto y comenzar con Worklenz",
-  "surveyCompleteTitle": "¡Gracias!",
-  "surveyCompleteDescription": "Tu retroalimentación nos ayuda a mejorar Worklenz para todos",
-  "aboutYouStepName": "Sobre ti",
-  "yourNeedsStepName": "Tus necesidades", 
-  "discoveryStepName": "Descubrimiento",
-  "stepProgress": "Paso {step} de 3: {title}",
-
-  "projectStepHeader": "Vamos a crear tu primer proyecto",
-  "projectStepSubheader": "Empieza desde cero o usa una plantilla para ir más rápido",
-  "startFromScratch": "Empezar desde cero",
-  "templateSelected": "Plantilla seleccionada abajo",
-  "quickSuggestions": "Sugerencias rápidas:",
-  "orText": "O",
-  "startWithTemplate": "Comenzar con una plantilla",
-  "clearToSelectTemplate": "Borra el nombre del proyecto arriba para seleccionar una plantilla",
-  "templateHeadStart": "Obtén una ventaja inicial con estructuras de proyecto pre-construidas",
-  "browseAllTemplates": "Explorar todas las plantillas",
-  "templatesAvailable": "15+ plantillas específicas de industria disponibles",
-  "chooseTemplate": "Elige una plantilla que coincida con tu tipo de proyecto",
-  "createProject": "Crear proyecto",
-
-  "templateSoftwareDev": "Desarrollo de Software",
-  "templateSoftwareDesc": "Sprints ágiles, seguimiento de errores, lanzamientos",
-  "templateMarketing": "Campaña de Marketing", 
-  "templateMarketingDesc": "Planificación de campaña, calendario de contenido",
-  "templateConstruction": "Proyecto de Construcción",
-  "templateConstructionDesc": "Fases, permisos, contratistas",
-  "templateStartup": "Lanzamiento de Startup",
-  "templateStartupDesc": "Desarrollo MVP, financiación, crecimiento",
-
-  "tasksStepTitle": "Añade tus primeras tareas",
-  "tasksStepDescription": "Desglosa \"{{projectName}}\" en tareas accionables para comenzar",
-  "taskPlaceholder": "Tarea {{index}} - ej., ¿Qué necesita hacerse?",
-  "addAnotherTask": "Añadir otra tarea ({{current}}/{{max}})",
-
-  "surveyStepTitle": "Cuéntanos sobre ti",
-  "surveyStepLabel": "Ayúdanos a personalizar tu experiencia de Worklenz respondiendo algunas preguntas.",
-  
-  "organizationType": "¿Qué describe mejor tu organización?",
-  "organizationTypeFreelancer": "Freelancer",
-  "organizationTypeStartup": "Startup",
-  "organizationTypeSmallMediumBusiness": "Pequeña o Mediana Empresa",
-  "organizationTypeAgency": "Agencia",
-  "organizationTypeEnterprise": "Empresa",
-  "organizationTypeOther": "Otro",
-  
-  "userRole": "¿Cuál es tu rol?",
-  "userRoleFounderCeo": "Fundador / CEO",
-  "userRoleProjectManager": "Gerente de Proyecto",
-  "userRoleSoftwareDeveloper": "Desarrollador de Software",
-  "userRoleDesigner": "Diseñador",
-  "userRoleOperations": "Operaciones",
-  "userRoleOther": "Otro",
-  
-  "mainUseCases": "¿Para qué usarás principalmente Worklenz?",
-  "mainUseCasesTaskManagement": "Gestión de tareas",
-  "mainUseCasesTeamCollaboration": "Colaboración de equipo",
-  "mainUseCasesResourcePlanning": "Planificación de recursos",
-  "mainUseCasesClientCommunication": "Comunicación con clientes e informes",
-  "mainUseCasesTimeTracking": "Seguimiento de tiempo",
-  "mainUseCasesOther": "Otro",
-  
-  "previousTools": "¿Qué herramienta(s) usabas antes de Worklenz?",
-  "previousToolsPlaceholder": "ej. Trello, Asana, Monday.com",
-  
-  "howHeardAbout": "¿Cómo conociste Worklenz?",
-  "howHeardAboutGoogleSearch": "Búsqueda de Google",
-  "howHeardAboutTwitter": "Twitter",
-  "howHeardAboutLinkedin": "LinkedIn",
-  "howHeardAboutFriendColleague": "Un amigo o colega",
-  "howHeardAboutBlogArticle": "Un blog o artículo",
-  "howHeardAboutOther": "Otro",
-  
-  "aboutYouStepTitle": "Cuéntanos sobre ti",
-  "aboutYouStepDescription": "Ayúdanos a personalizar tu experiencia",
-  "yourNeedsStepTitle": "¿Cuáles son tus principales necesidades?",
-  "yourNeedsStepDescription": "Selecciona todas las que apliquen para ayudarnos a configurar tu espacio de trabajo",
-  "selected": "seleccionado",
-  "previousToolsLabel": "¿Qué herramientas has usado antes? (Opcional)",
-  
-  "roleSuggestions": {
-    "designer": "UI/UX, Gráficos, Creativo",
-    "developer": "Frontend, Backend, Full-stack", 
-    "projectManager": "Planificación, Coordinación",
-    "marketing": "Contenido, Redes Sociales, Crecimiento",
-    "sales": "Desarrollo de Negocios, Relaciones con Clientes",
-    "operations": "Administración, RRHH, Finanzas"
-  },
-  
-  "languages": {
-    "en": "English",
-    "es": "Español", 
-    "pt": "Português",
-    "de": "Deutsch",
-    "alb": "Shqip",
-    "zh": "简体中文"
-  },
-  
-  "orgSuggestions": {
-    "tech": ["TechCorp", "DevStudio", "CodeCraft", "PixelForge"],
-    "creative": ["Creative Hub", "Design Studio", "Brand Works", "Visual Arts"],
-    "consulting": ["Strategy Group", "Business Solutions", "Expert Advisors", "Growth Partners"],
-    "startup": ["Innovation Labs", "Future Works", "Venture Co", "Next Gen"]
-  },
-  
-  "projectSuggestions": {
-    "freelancer": ["Proyecto Cliente", "Actualización Portfolio", "Marca Personal"],
-    "startup": ["Desarrollo MVP", "Lanzamiento Producto", "Investigación Mercado"],
-    "agency": ["Campaña Cliente", "Estrategia Marca", "Rediseño Website"],
-    "enterprise": ["Migración Sistema", "Optimización Procesos", "Capacitación Equipo"]
-  },
-  
-  "useCaseDescriptions": {
-    "taskManagement": "Organizar y rastrear tareas",
-    "teamCollaboration": "Trabajar juntos sin problemas",
-    "resourcePlanning": "Gestionar tiempo y recursos", 
-    "clientCommunication": "Mantenerse conectado con clientes",
-    "timeTracking": "Monitorear horas de proyecto",
-    "other": "Algo más"
-  }
+  "maxTasks": " (Puedes crear hasta 5 tareas)"
 }
--- a/worklenz-frontend/public/locales/es/auth/signup.json
+++ b/worklenz-frontend/public/locales/es/auth/signup.json
@@ -7,12 +7,12 @@
  "emailLabel": "Correo electrónico",
  "emailPlaceholder": "Ingresa tu correo electrónico",
  "emailRequired": "¡Por favor ingresa tu correo electrónico!",
-  "passwordLabel": "Contraseña",
-  "passwordGuideline": "La contraseña debe tener al menos 8 caracteres, incluir letras mayúsculas y minúsculas, un número y un carácter especial.",
-  "passwordPlaceholder": "Ingresa tu contraseña",
+  "passwordLabel": "Password",
+  "passwordGuideline": "Password must be at least 8 characters, include uppercase and lowercase letters, a number, and a special character.",
+  "passwordPlaceholder": "Enter your password",
  "passwordRequired": "¡Por favor ingresa tu contraseña!",
  "passwordMinCharacterRequired": "¡La contraseña debe tener al menos 8 caracteres!",
-  "passwordMaxCharacterRequired": "¡La contraseña debe tener como máximo 32 caracteres!",
+  "passwordMaxCharacterRequired": "Password must be at most 32 characters!",
  "passwordPatternRequired": "¡La contraseña no cumple con los requisitos!",
  "strongPasswordPlaceholder": "Ingresa una contraseña más segura",
  "passwordValidationAltText": "La contraseña debe incluir al menos 8 caracteres con letras mayúsculas y minúsculas, un número y un símbolo.",
--- a/worklenz-frontend/public/locales/es/common.json
+++ b/worklenz-frontend/public/locales/es/common.json
@@ -5,13 +5,5 @@
  "signup-failed": "Error al registrarse. Por favor asegúrate de llenar todos los campos requeridos e intenta nuevamente.",
  "reconnecting": "Reconectando al servidor...",
  "connection-lost": "Conexión perdida. Intentando reconectarse...",
-  "connection-restored": "Conexión restaurada. Reconectando al servidor...",
-  "cancel": "Cancelar",
-  "update-available": "¡Worklenz actualizado!",
-  "update-description": "Una nueva versión de Worklenz está disponible con las últimas funciones y mejoras.",
-  "update-instruction": "Para obtener la mejor experiencia, por favor recarga la página para aplicar los nuevos cambios.",
-  "update-whats-new": "💡 <1>Qué hay de nuevo:</1> Rendimiento mejorado, correcciones de errores y experiencia de usuario mejorada",
-  "update-now": "Actualizar ahora",
-  "update-later": "Más tarde",
-  "updating": "Actualizando..."
+  "connection-restored": "Conexión restaurada. Reconectando al servidor..."
 }
--- a/worklenz-frontend/public/locales/es/gantt/phase-details-modal.json
+++ b/worklenz-frontend/public/locales/es/gantt/phase-details-modal.json
@@ -1,36 +0,0 @@
-{
-  "title": "Phase Details",
-  "overview": {
-    "title": "Overview",
-    "totalTasks": "Total Tasks",
-    "completion": "Completion",
-    "progress": "Progress"
-  },
-  "timeline": {
-    "title": "Timeline",
-    "startDate": "Start Date",
-    "endDate": "End Date",
-    "status": "Status",
-    "notSet": "Not set",
-    "statusLabels": {
-      "upcoming": "Upcoming",
-      "active": "In Progress",
-      "overdue": "Overdue",
-      "notScheduled": "Not Scheduled"
-    }
-  },
-  "taskBreakdown": {
-    "title": "Task Breakdown",
-    "completed": "Completed",
-    "pending": "Pending",
-    "overdue": "Overdue"
-  },
-  "phaseColor": {
-    "title": "Phase Color",
-    "description": "Phase identifier color"
-  },
-  "tasksInPhase": {
-    "title": "Tasks in this Phase",
-    "noTasks": "No tasks in this phase"
-  }
-}
--- a/worklenz-frontend/public/locales/es/home.json
+++ b/worklenz-frontend/public/locales/es/home.json
@@ -40,22 +40,6 @@
    "list": "Lista",
    "calendar": "Calendario",
    "tasks": "Tareas",
-    "refresh": "Actualizar",
-    "recentActivity": "Actividad Reciente",
-    "recentTasks": "Tareas Recientes",
-    "recentTasksSegment": "Tareas Recientes",
-    "timeLogged": "Tiempo Registrado",
-    "timeLoggedSegment": "Tiempo Registrado",
-    "noRecentTasks": "No hay tareas recientes",
-    "noTimeLoggedTasks": "No hay tareas con tiempo registrado",
-    "activityTag": "Actividad",
-    "timeLogTag": "Registro de Tiempo",
-    "timerTag": "Temporizador",
-    "activitySingular": "actividad",
-    "activityPlural": "actividades",
-    "recentTaskAriaLabel": "Tarea reciente:",
-    "timeLoggedTaskAriaLabel": "Tarea con tiempo registrado:",
-    "errorLoadingRecentTasks": "Error al cargar tareas recientes",
-    "errorLoadingTimeLoggedTasks": "Error al cargar tareas con tiempo registrado"
+    "refresh": "Actualizar"
  }
 }
--- a/worklenz-frontend/public/locales/es/kanban-board.json
+++ b/worklenz-frontend/public/locales/es/kanban-board.json
@@ -10,17 +10,6 @@
  "deleteConfirmationOk": "Sí",
  "deleteConfirmationCancel": "Cancelar",

-  "deleteTaskTitle": "Eliminar tarea",
-  "deleteTaskContent": "¿Estás seguro de que deseas eliminar esta tarea? Esta acción no se puede deshacer.",
-  "deleteTaskConfirm": "Eliminar",
-  "deleteTaskCancel": "Cancelar",
-
-  "deleteStatusTitle": "Eliminar estado",
-  "deleteStatusContent": "¿Estás seguro de que deseas eliminar este estado? Esta acción no se puede deshacer.",
-
-  "deletePhaseTitle": "Eliminar fase",
-  "deletePhaseContent": "¿Estás seguro de que deseas eliminar esta fase? Esta acción no se puede deshacer.",
-
  "dueDate": "Fecha de vencimiento",
  "cancel": "Cancelar",

@@ -37,17 +26,5 @@
  "noDueDate": "Sin fecha de vencimiento",
  "save": "Guardar",
  "clear": "Limpiar",
-  "nextWeek": "Próxima semana",
-  "noSubtasks": "Sin subtareas",
-  "showSubtasks": "Mostrar subtareas",
-  "hideSubtasks": "Ocultar subtareas",
-  
-  "errorLoadingTasks": "Error al cargar tareas",
-  "noTasksFound": "No se encontraron tareas",
-  "loadingFilters": "Cargando filtros...",
-  "failedToUpdateColumnOrder": "Error al actualizar el orden de las columnas",
-  "failedToUpdatePhaseOrder": "Error al actualizar el orden de las fases",
-  "pleaseTryAgain": "Por favor, inténtalo de nuevo",
-  "taskNotCompleted": "La tarea no está completada",
-  "completeTaskDependencies": "Por favor, completa las dependencias de la tarea antes de continuar"
+  "nextWeek": "Próxima semana"
 }
--- a/worklenz-frontend/public/locales/es/project-view-members.json
+++ b/worklenz-frontend/public/locales/es/project-view-members.json
@@ -13,6 +13,5 @@
  "deleteButtonTooltip": "Eliminar del proyecto",
  "memberCount": "Miembro",
  "membersCountPlural": "Miembros",
-  "emptyText": "No hay archivos adjuntos en el proyecto.",
-  "searchPlaceholder": "Buscar miembros"
+  "emptyText": "No hay archivos adjuntos en el proyecto."
 }
--- a/worklenz-frontend/public/locales/es/project-view/project-member-drawer.json
+++ b/worklenz-frontend/public/locales/es/project-view/project-member-drawer.json
@@ -3,9 +3,5 @@
  "searchLabel": "Agregar miembros ingresando su nombre o correo electrónico",
  "searchPlaceholder": "Escriba nombre o correo electrónico",
  "inviteAsAMember": "Invitar como miembro",
-  "inviteNewMemberByEmail": "Invitar nuevo miembro por correo electrónico",
-  "members": "Miembros",
-  "copyProjectLink": "Copiar enlace del proyecto",
-  "inviteMember": "Invitar miembro",
-  "alsoInviteToProject": "También invitar al proyecto"
+  "inviteNewMemberByEmail": "Invitar nuevo miembro por correo electrónico"
 }
--- a/worklenz-frontend/public/locales/es/settings/team-members.json
+++ b/worklenz-frontend/public/locales/es/settings/team-members.json
@@ -28,7 +28,7 @@
  "jobTitleLabel": "Cargo",
  "jobTitlePlaceholder": "Seleccione o busque cargo (Opcional)",
  "memberAccessLabel": "Nivel de acceso",
-  "addToTeamButton": "Enviar invitación",
+  "addToTeamButton": "Agregar miembro al equipo",
  "updateButton": "Guardar cambios",
  "resendInvitationButton": "Reenviar correo de invitación",
  "invitationSentSuccessMessage": "¡Invitación al equipo enviada exitosamente!",
@@ -43,6 +43,5 @@
  "updatedText": "Actualizado",
  "noResultFound": "Escriba una dirección de correo electrónico y presione enter...",
  "jobTitlesFetchError": "Error al obtener los cargos",
-  "invitationResent": "¡Invitación reenviada exitosamente!",
-  "copyTeamLink": "Copiar enlace del equipo"
+  "invitationResent": "¡Invitación reenviada exitosamente!"
 }
--- a/worklenz-frontend/public/locales/es/survey.json
+++ b/worklenz-frontend/public/locales/es/survey.json
@@ -1,14 +0,0 @@
-{
-  "modalTitle": "Ayúdanos a mejorar tu experiencia",
-  "skip": "Omitir por ahora",
-  "previous": "Anterior",
-  "next": "Siguiente",
-  "completeSurvey": "Completar encuesta",
-  "submitting": "Enviando tus respuestas...",
-  "submitSuccessTitle": "¡Gracias!",
-  "submitSuccessSubtitle": "Tus comentarios nos ayudan a mejorar Worklenz para todos.",
-  "submitSuccessMessage": "¡Gracias por completar la encuesta!",
-  "submitErrorMessage": "No se pudo enviar la encuesta. Por favor, inténtalo de nuevo.",
-  "submitErrorLog": "Error al enviar la encuesta",
-  "fetchErrorLog": "Error al obtener la encuesta"
-} 
--- a/worklenz-frontend/public/locales/es/task-list-filters.json
+++ b/worklenz-frontend/public/locales/es/task-list-filters.json
@@ -84,12 +84,5 @@
  "close": "Cerrar",
  "cannotMoveStatus": "No se puede mover el estado",
  "cannotMoveStatusMessage": "No se puede mover este estado porque dejaría vacía la categoría '{{categoryName}}'. Cada categoría debe tener al menos un estado.",
-  "ok": "OK",
-  "clearSort": "Limpiar Ordenamiento",
-  "sortAscending": "Ordenar Ascendente",
-  "sortDescending": "Ordenar Descendente",
-  "sortByField": "Ordenar por {{field}}",
-  "ascendingOrder": "Ascendente",
-  "descendingOrder": "Descendente",
-  "currentSort": "Ordenamiento actual: {{field}} {{order}}"
+  "ok": "OK"
 }
--- a/worklenz-frontend/public/locales/es/task-list-table.json
+++ b/worklenz-frontend/public/locales/es/task-list-table.json
@@ -57,9 +57,6 @@

  "contextMenu": {
    "assignToMe": "Asignar a mí",
-    "copyLink": "Copiar enlace a la tarea",
-    "linkCopied": "Enlace copiado al portapapeles",
-    "linkCopyFailed": "Error al copiar el enlace",
    "moveTo": "Mover a",
    "unarchive": "Desarchivar",
    "archive": "Archivar",
@@ -136,11 +133,5 @@
      "dependencies": "La tarea tiene dependencias",
      "recurring": "Tarea recurrente"
    }
-  },
-
-  "timer": {
-    "conflictTitle": "Temporizador Ya En Ejecución",
-    "conflictMessage": "Tiene un temporizador ejecutándose para \"{{taskName}}\" en el proyecto \"{{projectName}}\". ¿Le gustaría detener ese temporizador e iniciar uno nuevo para esta tarea?",
-    "stopAndStart": "Detener e Iniciar Nuevo Temporizador"
  }
 }
--- a/worklenz-frontend/public/locales/pt/account-setup.json
+++ b/worklenz-frontend/public/locales/pt/account-setup.json
@@ -3,28 +3,7 @@

  "setupYourAccount": "Configure sua conta.",
  "organizationStepTitle": "Nomeie sua organização",
-  "organizationStepWelcome": "Bem-vindo ao Worklenz!",
-  "organizationStepDescription": "Vamos começar configurando sua organização. Este será o espaço de trabalho principal para sua equipe.",
-  "organizationStepLabel": "Nome da organização",
-  "organizationStepPlaceholder": "ex. Corporação Acme",
-  "organizationStepTooltip": "Este nome aparecerá em seu espaço de trabalho e pode ser alterado posteriormente nas configurações.",
-  "organizationStepNeedIdeas": "Precisa de ideias?",
-  "organizationStepUseDetected": "Usar detectado:",
-  "organizationStepCharacters": "caracteres",
-  "organizationStepGoodLength": "Bom comprimento",
-  "organizationStepTooShort": "Muito curto",
-  "organizationStepNamingTips": "Dicas de nomenclatura",
-  "organizationStepTip1": "Mantenha simples e memorável",
-  "organizationStepTip2": "Reflita sua indústria ou valores",
-  "organizationStepTip3": "Pense no crescimento futuro",
-  "organizationStepTip4": "Torne único e marcante",
-  "organizationStepSuggestionsTitle": "Sugestões de nomes",
-  "organizationStepCategory1": "Empresas de tecnologia",
-  "organizationStepCategory2": "Agências criativas",
-  "organizationStepCategory3": "Consultoria",
-  "organizationStepCategory4": "Startups",
-  "organizationStepSuggestionsNote": "Estes são apenas exemplos para começar. Escolha algo que represente sua organização.",
-  "organizationStepPrivacyNote": "O nome da sua organização é privado e visível apenas para os membros da sua equipe.",
+  "organizationStepLabel": "Escolha um nome para sua conta Worklenz.",

  "projectStepTitle": "Crie seu primeiro projeto",
  "projectStepLabel": "Em qual projeto você está trabalhando agora?",
@@ -45,171 +24,9 @@
  "step3InputLabel": "Convidar por email",
  "addAnother": "Adicionar outro",
  "skipForNow": "Pular por enquanto",
-  "skipping": "Pulando...",
  "formTitle": "Crie sua primeira tarefa.",
  "step3Title": "Convide sua equipe para trabalhar",

  "maxMembers": " (Você pode convidar até 5 membros)",
-  "maxTasks": " (Você pode criar até 5 tarefas)",
-
-  "membersStepTitle": "Convide sua equipe",
-  "membersStepDescription": "Adicione membros da equipe ao \"{{organizationName}}\" e comece a colaborar",
-  "memberPlaceholder": "Membro da equipe {{index}} - Digite o endereço de email",
-  "validEmailAddress": "Endereço de email válido",
-  "addAnotherTeamMember": "Adicionar outro membro da equipe ({{current}}/{{max}})",
-  "canInviteLater": "Você sempre pode convidar membros da equipe mais tarde",
-  "skipStepDescription": "Não tem endereços de email prontos? Sem problema! Você pode pular esta etapa e convidar membros da equipe do seu painel de projeto mais tarde.",
-
-  "orgCategoryTech": "Empresas de Tecnologia",
-  "orgCategoryCreative": "Agências Criativas", 
-  "orgCategoryConsulting": "Consultoria",
-  "orgCategoryStartups": "Startups",
-  "namingTip1": "Mantenha simples e memorável",
-  "namingTip2": "Reflita sua indústria ou valores",
-  "namingTip3": "Pense no crescimento futuro",
-  "namingTip4": "Torne único e marcante",
-
-  "aboutYouTitle": "Conte-nos sobre você",
-  "aboutYouDescription": "Ajude-nos a personalizar sua experiência",
-  "orgTypeQuestion": "O que melhor descreve sua organização?",
-  "userRoleQuestion": "Qual é seu papel?",
-  
-  "yourNeedsTitle": "Quais são suas principais necessidades?",
-  "yourNeedsDescription": "Selecione todas que se aplicam para nos ajudar a configurar seu espaço de trabalho",
-  "yourNeedsQuestion": "Como você usará principalmente o Worklenz?",
-  "useCaseTaskOrg": "Organizar e acompanhar tarefas",
-  "useCaseTeamCollab": "Trabalhar juntos perfeitamente", 
-  "useCaseResourceMgmt": "Gerenciar tempo e recursos",
-  "useCaseClientComm": "Manter-se conectado com clientes",
-  "useCaseTimeTrack": "Monitorar horas do projeto",
-  "useCaseOther": "Algo mais",
-  "selectedText": "selecionado",
-  "previousToolsQuestion": "Que ferramentas você usou antes? (Opcional)",
-  "previousToolsPlaceholder": "ex., Asana, Trello, Jira, Monday.com, etc.",
-  
-  "discoveryTitle": "Uma última coisa...",
-  "discoveryDescription": "Ajude-nos a entender como você descobriu o Worklenz",
-  "discoveryQuestion": "Como você soube sobre nós?",
-  "allSetTitle": "Você está pronto!",
-  "allSetDescription": "Vamos criar seu primeiro projeto e começar com o Worklenz",
-  "surveyCompleteTitle": "Obrigado!",
-  "surveyCompleteDescription": "Seu feedback nos ajuda a melhorar o Worklenz para todos",
-  "aboutYouStepName": "Sobre você",
-  "yourNeedsStepName": "Suas necessidades", 
-  "discoveryStepName": "Descoberta",
-  "stepProgress": "Passo {step} de 3: {title}",
-
-  "projectStepHeader": "Vamos criar seu primeiro projeto",
-  "projectStepSubheader": "Comece do zero ou use um modelo para ir mais rápido",
-  "startFromScratch": "Começar do zero",
-  "templateSelected": "Modelo selecionado abaixo",
-  "quickSuggestions": "Sugestões rápidas:",
-  "orText": "OU",
-  "startWithTemplate": "Começar com um modelo",
-  "clearToSelectTemplate": "Limpe o nome do projeto acima para selecionar um modelo",
-  "templateHeadStart": "Obtenha uma vantagem inicial com estruturas de projeto pré-construídas",
-  "browseAllTemplates": "Navegar por todos os modelos",
-  "templatesAvailable": "15+ modelos específicos da indústria disponíveis",
-  "chooseTemplate": "Escolha um modelo que corresponda ao seu tipo de projeto",
-  "createProject": "Criar projeto",
-
-  "templateSoftwareDev": "Desenvolvimento de Software",
-  "templateSoftwareDesc": "Sprints ágeis, rastreamento de bugs, lançamentos",
-  "templateMarketing": "Campanha de Marketing", 
-  "templateMarketingDesc": "Planejamento de campanha, calendário de conteúdo",
-  "templateConstruction": "Projeto de Construção",
-  "templateConstructionDesc": "Fases, licenças, empreiteiros",
-  "templateStartup": "Lançamento de Startup",
-  "templateStartupDesc": "Desenvolvimento MVP, financiamento, crescimento",
-
-  "tasksStepTitle": "Adicione suas primeiras tarefas",
-  "tasksStepDescription": "Divida \"{{projectName}}\" em tarefas acionáveis para começar",
-  "taskPlaceholder": "Tarefa {{index}} - ex., O que precisa ser feito?",
-  "addAnotherTask": "Adicionar outra tarefa ({{current}}/{{max}})",
-
-  "surveyStepTitle": "Conte-nos sobre você",
-  "surveyStepLabel": "Ajude-nos a personalizar sua experiência no Worklenz respondendo algumas perguntas.",
-  
-  "organizationType": "O que melhor descreve sua organização?",
-  "organizationTypeFreelancer": "Freelancer",
-  "organizationTypeStartup": "Startup",
-  "organizationTypeSmallMediumBusiness": "Pequena ou Média Empresa",
-  "organizationTypeAgency": "Agência",
-  "organizationTypeEnterprise": "Empresa",
-  "organizationTypeOther": "Outro",
-  
-  "userRole": "Qual é o seu papel?",
-  "userRoleFounderCeo": "Fundador / CEO",
-  "userRoleProjectManager": "Gerente de Projeto",
-  "userRoleSoftwareDeveloper": "Desenvolvedor de Software",
-  "userRoleDesigner": "Designer",
-  "userRoleOperations": "Operações",
-  "userRoleOther": "Outro",
-  
-  "mainUseCases": "Para que você usará principalmente o Worklenz?",
-  "mainUseCasesTaskManagement": "Gerenciamento de tarefas",
-  "mainUseCasesTeamCollaboration": "Colaboração em equipe",
-  "mainUseCasesResourcePlanning": "Planejamento de recursos",
-  "mainUseCasesClientCommunication": "Comunicação com clientes e relatórios",
-  "mainUseCasesTimeTracking": "Controle de tempo",
-  "mainUseCasesOther": "Outro",
-  
-  "previousTools": "Que ferramenta(s) você usava antes do Worklenz?",
-  "previousToolsPlaceholder": "ex. Trello, Asana, Monday.com",
-  
-  "howHeardAbout": "Como você soube do Worklenz?",
-  "howHeardAboutGoogleSearch": "Busca no Google",
-  "howHeardAboutTwitter": "Twitter",
-  "howHeardAboutLinkedin": "LinkedIn",
-  "howHeardAboutFriendColleague": "Um amigo ou colega",
-  "howHeardAboutBlogArticle": "Um blog ou artigo",
-  "howHeardAboutOther": "Outro",
-  
-  "aboutYouStepTitle": "Conte-nos sobre você",
-  "aboutYouStepDescription": "Ajude-nos a personalizar sua experiência",
-  "yourNeedsStepTitle": "Quais são suas principais necessidades?",
-  "yourNeedsStepDescription": "Selecione todas que se aplicam para nos ajudar a configurar seu espaço de trabalho",
-  "selected": "selecionado",
-  "previousToolsLabel": "Que ferramentas você usou antes? (Opcional)",
-  
-  "roleSuggestions": {
-    "designer": "UI/UX, Gráficos, Criativo",
-    "developer": "Frontend, Backend, Full-stack", 
-    "projectManager": "Planejamento, Coordenação",
-    "marketing": "Conteúdo, Mídias Sociais, Crescimento",
-    "sales": "Desenvolvimento de Negócios, Relacionamento com Clientes",
-    "operations": "Administração, RH, Finanças"
-  },
-  
-  "languages": {
-    "en": "English",
-    "es": "Español", 
-    "pt": "Português",
-    "de": "Deutsch",
-    "alb": "Shqip",
-    "zh": "简体中文"
-  },
-  
-  "orgSuggestions": {
-    "tech": ["TechCorp", "DevStudio", "CodeCraft", "PixelForge"],
-    "creative": ["Creative Hub", "Design Studio", "Brand Works", "Visual Arts"],
-    "consulting": ["Strategy Group", "Business Solutions", "Expert Advisors", "Growth Partners"],
-    "startup": ["Innovation Labs", "Future Works", "Venture Co", "Next Gen"]
-  },
-  
-  "projectSuggestions": {
-    "freelancer": ["Projeto Cliente", "Atualização Portfolio", "Marca Pessoal"],
-    "startup": ["Desenvolvimento MVP", "Lançamento Produto", "Pesquisa Mercado"],
-    "agency": ["Campanha Cliente", "Estratégia Marca", "Redesign Website"],
-    "enterprise": ["Migração Sistema", "Otimização Processos", "Treinamento Equipe"]
-  },
-  
-  "useCaseDescriptions": {
-    "taskManagement": "Organizar e rastrear tarefas",
-    "teamCollaboration": "Trabalhar juntos perfeitamente",
-    "resourcePlanning": "Gerenciar tempo e recursos", 
-    "clientCommunication": "Manter-se conectado com clientes",
-    "timeTracking": "Monitorar horas do projeto",
-    "other": "Algo mais"
-  }
+  "maxTasks": " (Você pode criar até 5 tarefas)"
 }
--- a/worklenz-frontend/public/locales/pt/common.json
+++ b/worklenz-frontend/public/locales/pt/common.json
@@ -5,13 +5,5 @@
  "signup-failed": "Falha no cadastro. Por favor, certifique-se de que todos os campos obrigatórios estão preenchidos e tente novamente.",
  "reconnecting": "Reconectando ao servidor...",
  "connection-lost": "Conexão perdida. Tentando reconectar...",
-  "connection-restored": "Conexão restaurada. Reconectando ao servidor...",
-  "cancel": "Cancelar",
-  "update-available": "Worklenz atualizado!",
-  "update-description": "Uma nova versão do Worklenz está disponível com os recursos e melhorias mais recentes.",
-  "update-instruction": "Para obter a melhor experiência, por favor recarregue a página para aplicar as novas mudanças.",
-  "update-whats-new": "💡 <1>O que há de novo:</1> Performance aprimorada, correções de bugs e experiência do usuário melhorada",
-  "update-now": "Atualizar agora",
-  "update-later": "Mais tarde",
-  "updating": "Atualizando..."
+  "connection-restored": "Conexão restaurada. Reconectando ao servidor..."
 }
--- a/Show More
+++ b/Show More