12 Commits

Author	SHA1	Message	Date
Gan, Jimmy	4fa84fce8a	feat: add resource-level authorization for OPC ... - Add OPCAuthz module with fine-grained access control - Users can only view/modify tasks they created or are assigned to - Admins have full access to all resources - Members can trigger PM agent, only admins can trigger CTO/COO - Only admins can approve CxO-level agent executions - Track task creator in metadata for authorization - Add metadata column with default '{}' to tasks table - Filter task and execution lists based on user permissions - Add 10 integration tests for authorization logic	2026-04-08 01:28:12 +08:00
Gan, Jimmy	b981c06d59	feat: comprehensive test infrastructure improvements ... - Fix unit test imports: add env setup in conftest.py before module imports - Add 24 new auth router tests (RBAC, preferences, password validation) - Add 16 new tests for litellm and chat_summary routers - Apply black formatting and ruff linting across codebase - Add pre-commit hooks configuration (black, ruff, file checks) - Increase CI coverage threshold from 40% to 50% Test Results: - 206 tests passing (91 unit + 115 integration) - Coverage: 58.79% on core modules - auth.py: 57% → 85%, litellm.py: 23% → 87%, chat_summary.py: 41% → 100% - auth_service: 96.51%, config: 100%, rbac: 93.48%	2026-04-08 00:21:32 +08:00
Gan, Jimmy	8c08ae32cc	fix: create agent execution when moving assigned task to in_progress	2026-04-02 21:14:27 +08:00
Gan, Jimmy	d457edab17	debug: add more logging at start of move_task function	2026-04-02 21:03:29 +08:00
Gan, Jimmy	9fcbeca264	debug: add logging to move endpoint to trace execution creation	2026-04-02 10:33:48 +08:00
Gan, Jimmy	2c8f4fcd5c	fix: auto-assign tasks to PM agent when moved to in_progress, fix datetime serialization in WebSocket, add executor logging	2026-04-02 10:22:15 +08:00
Gan, Jimmy	1663535beb	fix: handle datetime serialization in update_task and move endpoint	2026-04-02 01:47:33 +08:00
Gan, Jimmy	f2b490e2e8	fix: strip timezone from datetime fields in task update endpoint	2026-04-02 01:28:18 +08:00
Gan, Jimmy	5d7d774ca1	fix: strip timezone from due_date to match TIMESTAMP column type	2026-04-02 01:27:18 +08:00
Gan, Jimmy	6cffc1f9ff	fix: update OPC routers to use request.state.user instead of Depends(_inject_user)	2026-04-02 00:45:26 +08:00
Gan, Jimmy	1422cc9bc8	feat: complete Phase 1 MVP - add agent executor and WebSocket real-time updates ... Agent Executor Service: - BaseAgent class with LLM integration via LiteLLM proxy - AgentExecutor service that processes pending executions every 5 seconds - Action execution: create_subtask, update_status, send_notification, add_comment - Approval workflow: CxO level agents require user approval before execution - Telegram notifications for approvals and completions - Error handling and execution status tracking WebSocket Real-Time Updates: - WebSocket endpoint at /ws/opc for real-time task updates - ConnectionManager for broadcasting to all connected clients - Frontend WebSocket client with auto-reconnect - Live updates for task create/update/move/delete actions - Agent execution status broadcasts Integration: - Agent executor starts on dashboard startup - Task router broadcasts WebSocket updates on all mutations - Frontend OPC page subscribes to WebSocket and updates UI in real-time - Agents (PM, CTO, COO) can now execute tasks autonomously Phase 1 MVP Complete: ✅ PostgreSQL database with full schema ✅ Task CRUD API with automatic time tracking ✅ Kanban board with drag-and-drop ✅ Agent executor service with LLM integration ✅ WebSocket real-time updates ✅ 3 core agents ready to execute Next: Agent panel UI, email notifications, PDF invoicing	2026-03-31 14:46:44 +08:00
Gan, Jimmy	1ca019fa48	feat: add OPC (One Person Company) management system with Kanban board ... Phase 1 MVP implementation: - PostgreSQL database schema for tasks, agents, executions, time tracking - Backend API: task CRUD, agent management, automatic time tracking - Frontend: Kanban board with drag-and-drop (Parking Lot → In Progress → Done) - Task modal for creating/editing tasks with tags, priority, assignee - 3 core agents seeded: PM, CTO, COO - Agent approval workflow: CxO level requires approval, others auto-execute - Automatic time tracking: starts on in_progress, stops on done - RBAC integration: OPC page accessible to admin/member roles Features: - Drag-and-drop tasks between columns - Assign tasks to humans or AI agents - Priority badges (low, medium, high, urgent) - Tags and due dates - Task history tracking - Time entry tracking with automatic timer - Agent execution records with approval workflow Next steps: - Initialize OPC database on NAS - Implement agent executor service - Add WebSocket for real-time updates - Add email notifications - Add PDF invoice generation	2026-03-31 14:31:31 +08:00