Compare commits
1 Commits
feature/cu
...
chore/adde
| Author | SHA1 | Date | |
|---|---|---|---|
|
b105661623 |
11
.claude/settings.local.json
Normal file
11
.claude/settings.local.json
Normal file
@@ -0,0 +1,11 @@
|
||||
{
|
||||
"permissions": {
|
||||
"allow": [
|
||||
"Bash(find:*)",
|
||||
"Bash(npm run build:*)",
|
||||
"Bash(npm run type-check:*)",
|
||||
"Bash(npm run:*)"
|
||||
],
|
||||
"deny": []
|
||||
}
|
||||
}
|
||||
5
.gitignore
vendored
5
.gitignore
vendored
@@ -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
|
||||
|
||||
|
||||
|
||||
41
test_sort_fix.sql
Normal file
41
test_sort_fix.sql
Normal file
@@ -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';
|
||||
30
test_sort_orders.sql
Normal file
30
test_sort_orders.sql
Normal file
@@ -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;
|
||||
*/
|
||||
3
worklenz-backend/.pgmrc.json
Normal file
3
worklenz-backend/.pgmrc.json
Normal file
@@ -0,0 +1,3 @@
|
||||
{
|
||||
"config-file": "migrate.json"
|
||||
}
|
||||
@@ -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;
|
||||
@@ -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');
|
||||
};
|
||||
@@ -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 });
|
||||
};
|
||||
@@ -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 });
|
||||
};
|
||||
@@ -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 });
|
||||
};
|
||||
@@ -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
|
||||
@@ -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);
|
||||
|
||||
@@ -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 $$;
|
||||
|
||||
@@ -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);
|
||||
|
||||
|
||||
22
worklenz-backend/migrate.json
Normal file
22
worklenz-backend/migrate.json
Normal file
@@ -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"
|
||||
}
|
||||
}
|
||||
}
|
||||
476
worklenz-backend/package-lock.json
generated
476
worklenz-backend/package-lock.json
generated
@@ -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",
|
||||
|
||||
@@ -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",
|
||||
|
||||
@@ -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]));
|
||||
}
|
||||
}
|
||||
|
||||
@@ -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") {
|
||||
|
||||
@@ -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,
|
||||
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) AS name,
|
||||
(SELECT email FROM team_member_info_view WHERE team_member_info_view.team_member_id = tm.id) AS email,
|
||||
(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 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
|
||||
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()
|
||||
|
||||
@@ -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 "";
|
||||
}
|
||||
@@ -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;
|
||||
}
|
||||
}
|
||||
@@ -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, "");
|
||||
}
|
||||
|
||||
@@ -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));
|
||||
}
|
||||
}
|
||||
@@ -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") {
|
||||
|
||||
@@ -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));
|
||||
}
|
||||
}
|
||||
@@ -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[];
|
||||
}
|
||||
@@ -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();
|
||||
}
|
||||
@@ -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"
|
||||
}
|
||||
|
||||
@@ -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"
|
||||
}
|
||||
|
||||
@@ -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.",
|
||||
|
||||
|
||||
@@ -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"
|
||||
}
|
||||
|
||||
@@ -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"
|
||||
}
|
||||
|
||||
@@ -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"
|
||||
}
|
||||
|
||||
@@ -75,12 +75,5 @@
|
||||
"delete": "删除",
|
||||
"enterStatusName": "输入状态名称",
|
||||
"selectCategory": "选择类别",
|
||||
"close": "关闭",
|
||||
"clearSort": "清除排序",
|
||||
"sortAscending": "升序排列",
|
||||
"sortDescending": "降序排列",
|
||||
"sortByField": "按{{field}}排序",
|
||||
"ascendingOrder": "升序",
|
||||
"descendingOrder": "降序",
|
||||
"currentSort": "当前排序：{{field}} {{order}}"
|
||||
"close": "关闭"
|
||||
}
|
||||
@@ -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;
|
||||
@@ -51,15 +51,12 @@ 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 userActivityLogsApiRouter from "./user-activity-logs-api-router";
|
||||
import customColumnsApiRouter from "./custom-columns-api-router";
|
||||
|
||||
const api = express.Router();
|
||||
@@ -106,7 +103,6 @@ api.use("/roadmap-gannt", roadmapApiRouter);
|
||||
api.use("/roadmap-gannt", roadmapApiRouter);
|
||||
api.use("/schedule-gannt", scheduleApiRouter);
|
||||
api.use("/schedule-gannt-v2", scheduleApiV2Router);
|
||||
api.use("/surveys", surveyApiRouter);
|
||||
api.use("/project-managers", projectManagerApiRouter);
|
||||
|
||||
api.get("/overview/:id", safeControllerFunction(OverviewController.getById));
|
||||
@@ -121,5 +117,4 @@ api.use("/task-recurring", taskRecurringApiRouter);
|
||||
api.use("/task-recurring", taskRecurringApiRouter);
|
||||
|
||||
api.use("/custom-columns", customColumnsApiRouter);
|
||||
api.use("/logs", userActivityLogsApiRouter);
|
||||
|
||||
|
||||
@@ -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;
|
||||
@@ -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;
|
||||
@@ -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";
|
||||
|
||||
@@ -16,7 +16,3 @@ 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
|
||||
@@ -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
|
||||
@@ -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>
|
||||
|
||||
554
worklenz-frontend/package-lock.json
generated
554
worklenz-frontend/package-lock.json
generated
File diff suppressed because it is too large
Load Diff
@@ -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",
|
||||
|
||||
@@ -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();
|
||||
});
|
||||
@@ -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);
|
||||
})();
|
||||
@@ -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)"
|
||||
}
|
||||
|
||||
@@ -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"
|
||||
}
|
||||
|
||||
@@ -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"
|
||||
}
|
||||
}
|
||||
@@ -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"
|
||||
}
|
||||
}
|
||||
|
||||
@@ -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"
|
||||
}
|
||||
|
||||
@@ -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."
|
||||
}
|
||||
|
||||
@@ -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"
|
||||
}
|
||||
|
||||
@@ -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!"
|
||||
}
|
||||
|
||||
@@ -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"
|
||||
}
|
||||
@@ -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"
|
||||
}
|
||||
|
||||
@@ -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"
|
||||
}
|
||||
}
|
||||
|
||||
@@ -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)"
|
||||
}
|
||||
|
||||
@@ -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"
|
||||
}
|
||||
@@ -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.",
|
||||
|
||||
@@ -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"
|
||||
}
|
||||
|
||||
@@ -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"
|
||||
}
|
||||
}
|
||||
@@ -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"
|
||||
}
|
||||
}
|
||||
|
||||
@@ -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"
|
||||
}
|
||||
|
||||
@@ -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."
|
||||
}
|
||||
|
||||
@@ -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"
|
||||
}
|
||||
|
||||
@@ -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!"
|
||||
}
|
||||
|
||||
@@ -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"
|
||||
}
|
||||
@@ -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"
|
||||
}
|
||||
|
||||
@@ -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"
|
||||
}
|
||||
}
|
||||
|
||||
@@ -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)"
|
||||
}
|
||||
|
||||
@@ -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"
|
||||
}
|
||||
@@ -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"
|
||||
}
|
||||
|
||||
@@ -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"
|
||||
}
|
||||
|
||||
@@ -5,6 +5,5 @@
|
||||
"user": "User",
|
||||
"email": "Email",
|
||||
"lastActivity": "Last Activity",
|
||||
"refresh": "Refresh users",
|
||||
"name": "Name"
|
||||
"refresh": "Refresh users"
|
||||
}
|
||||
|
||||
@@ -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"
|
||||
}
|
||||
|
||||
@@ -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"
|
||||
}
|
||||
}
|
||||
@@ -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"
|
||||
}
|
||||
}
|
||||
|
||||
@@ -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"
|
||||
}
|
||||
|
||||
@@ -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."
|
||||
}
|
||||
|
||||
@@ -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"
|
||||
}
|
||||
|
||||
@@ -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!"
|
||||
}
|
||||
|
||||
@@ -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"
|
||||
}
|
||||
@@ -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"
|
||||
}
|
||||
|
||||
@@ -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"
|
||||
}
|
||||
}
|
||||
|
||||
@@ -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)"
|
||||
}
|
||||
|
||||
@@ -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.",
|
||||
|
||||
@@ -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..."
|
||||
}
|
||||
|
||||
@@ -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"
|
||||
}
|
||||
}
|
||||
@@ -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"
|
||||
}
|
||||
}
|
||||
|
||||
@@ -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"
|
||||
}
|
||||
|
||||
@@ -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."
|
||||
}
|
||||
|
||||
@@ -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"
|
||||
}
|
||||
|
||||
@@ -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!"
|
||||
}
|
||||
|
||||
@@ -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"
|
||||
}
|
||||
@@ -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"
|
||||
}
|
||||
|
||||
@@ -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"
|
||||
}
|
||||
}
|
||||
|
||||
@@ -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)"
|
||||
}
|
||||
|
||||
@@ -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..."
|
||||
}
|
||||
|
||||
Some files were not shown because too many files have changed in this diff Show More
Reference in New Issue
Block a user