mirror of
https://github.com/tiennm99/goclaw.git
synced 2026-10-14 10:18:42 +00:00
Viet TranandNam Nguyen Ngoc
1a42dc93a6
* feat(workspace): add team shared workspace for file collaboration
- Add workspace_write and workspace_read tools for agents to share files across team members
- Create team_workspaces DB table with migration 000017 (file metadata, pinning, tags)
- Implement PostgreSQL store layer for workspace CRUD operations
- Add RPC handlers for workspace list/read/delete from web UI
- Build React workspace tab with file listing, content preview, and delete
- Propagate workspace channel/chatID scope through delegation chain
- Auto-allow workspace tools in agent tool policy when agent belongs to a team
- Inject team workspace guidance into system prompt for team agents
- Add /reset command handler for clearing session history
- Harden MCP bridge context middleware to reject headers when no gateway token
- Add i18n strings for workspace UI in en/vi/zh locales
* feat(teams): add comprehensive task management with followup reminders and recovery
- Add task followup/reminder system with auto-set on lead agent reply and auto-clear when user responds on channel
- Add task recovery ticker to re-dispatch stale/pending tasks periodically
- Add task scopes, filtering by status/channel/chatID, and task events
- Add WS RPC handlers for task CRUD, assignments, comments, events, and bulk operations (teams_tasks.go)
- Add task detail dialog, settings UI for followup config, and scope filtering in web dashboard
- Add migrations 000018 (team_tasks_v2) and 000019 (task_followup)
- Extend team_tasks_tool with await_reply, clear_followup actions
- Auto-complete/fail team tasks when delegate agent finishes
- Add workspace file listing and team tool manager enhancements
* docs(teams): add team system architecture and playbook ideas documentation
- Add TEAM_SYSTEM.md with full architecture design covering task management, shared workspace, and delegation engine subsystems
- Add TEAM_PLAYBOOK_IDEAS.md outlining future team coordination layers (playbook, member capabilities, auto-learned patterns)
- Document data models, status flows, tool actions, followup reminder system, task ticker, execution locking, and workspace scope model
* fix(teams): resolve 6 critical bugs in team task system
- Fix unblock SQL: check array_length after array_remove (not before)
- Enforce single-team leadership in team creation
- Add requireLead() for approve/reject tool actions
- Validate cross-team dependency references in blocked_by
- Add team_id to handoff route for multi-team isolation
- Set blocked_by DEFAULT '{}' to prevent NULL array issues
* refactor(workspace): use stable userID as scope key instead of connection UUID
Workspace scope changed from (team_id, channel, chat_id) to (team_id, userID).
Fixes workspace fragmentation across WS tab refreshes and reconnections.
* feat(teams): add V1/V2 versioning with feature gating and optimized prompts
- IsTeamV2() helper gates advanced features (locking, followup, review, audit)
- V2 tool actions rejected for V1 teams with clear error message
- Ticker, gateway consumer, delegation hooks respect version flag
- TEAM.md renders v1/v2 sections conditionally
- Tool descriptions and params optimized (~38% token reduction)
- UI: version toggle in settings, V2 Beta badge, conditional rendering
- i18n: version modal keys for en/vi/zh
* fix(migration): use VARCHAR(255) for user ID columns and add metadata JSONB
- assignee_user_id, user_id, actor_id: TEXT → VARCHAR(255)
- Add metadata JSONB to team_task_comments and team_task_attachments
---------
Co-authored-by: Nam Nguyen Ngoc <namnn.0911@gmail.com>
41 lines
1.6 KiB
SQL
41 lines
1.6 KiB
SQL
-- Part 5: handoff team_id
|
|
DROP INDEX IF EXISTS idx_hr_team;
|
|
ALTER TABLE handoff_routes DROP COLUMN IF EXISTS team_id;
|
|
|
|
-- Part 3: followup
|
|
DROP INDEX IF EXISTS idx_tt_followup;
|
|
ALTER TABLE team_tasks DROP COLUMN IF EXISTS followup_chat_id;
|
|
ALTER TABLE team_tasks DROP COLUMN IF EXISTS followup_channel;
|
|
ALTER TABLE team_tasks DROP COLUMN IF EXISTS followup_message;
|
|
ALTER TABLE team_tasks DROP COLUMN IF EXISTS followup_max;
|
|
ALTER TABLE team_tasks DROP COLUMN IF EXISTS followup_count;
|
|
ALTER TABLE team_tasks DROP COLUMN IF EXISTS followup_at;
|
|
|
|
-- Part 2: team tasks v2
|
|
DROP TABLE IF EXISTS team_task_attachments;
|
|
DROP TABLE IF EXISTS team_task_events;
|
|
DROP TABLE IF EXISTS team_task_comments;
|
|
|
|
DROP INDEX IF EXISTS idx_tt_parent;
|
|
DROP INDEX IF EXISTS idx_tt_scope;
|
|
DROP INDEX IF EXISTS idx_tt_type;
|
|
DROP INDEX IF EXISTS idx_tt_lock;
|
|
DROP INDEX IF EXISTS idx_tt_identifier;
|
|
|
|
ALTER TABLE team_tasks DROP COLUMN IF EXISTS task_type;
|
|
ALTER TABLE team_tasks DROP COLUMN IF EXISTS task_number;
|
|
ALTER TABLE team_tasks DROP COLUMN IF EXISTS identifier;
|
|
ALTER TABLE team_tasks DROP COLUMN IF EXISTS created_by_agent_id;
|
|
ALTER TABLE team_tasks DROP COLUMN IF EXISTS assignee_user_id;
|
|
ALTER TABLE team_tasks DROP COLUMN IF EXISTS parent_id;
|
|
ALTER TABLE team_tasks DROP COLUMN IF EXISTS chat_id;
|
|
ALTER TABLE team_tasks DROP COLUMN IF EXISTS locked_at;
|
|
ALTER TABLE team_tasks DROP COLUMN IF EXISTS lock_expires_at;
|
|
ALTER TABLE team_tasks DROP COLUMN IF EXISTS progress_percent;
|
|
ALTER TABLE team_tasks DROP COLUMN IF EXISTS progress_step;
|
|
|
|
-- Part 1: workspace
|
|
DROP TABLE IF EXISTS team_workspace_comments;
|
|
DROP TABLE IF EXISTS team_workspace_file_versions;
|
|
DROP TABLE IF EXISTS team_workspace_files;
|