Commit graph

66 commits

Author SHA1 Message Date
AeThex
7fec93e05c feat: Authentik SSO, nav systems, project pages, and schema fixes
Some checks are pending
Build / build (push) Waiting to run
Deploy / deploy (push) Waiting to run
Lint & Type Check / lint (push) Waiting to run
Security Scan / dependency-check (push) Waiting to run
Security Scan / semgrep (push) Waiting to run
Test / test (18.x) (push) Waiting to run
Test / test (20.x) (push) Waiting to run
Auth & SSO
- Wire Authentik (auth.aethex.tech) as OIDC PKCE SSO provider
- Server-side only flow with HMAC-signed stateless state token
- Account linking via authentik_sub in user metadata
- AeThex ID connection card in Dashboard connections tab
- Unlink endpoint POST /api/auth/authentik/unlink
- Fix node:https helper to bypass undici DNS bug on Node 18
- Fix resolv.conf to use 1.1.1.1/8.8.8.8 in container

Schema & types
- Regenerate database.types.ts from live Supabase schema (23k lines)
- Fix 511 TypeScript errors caused by stale 582-line types file
- Fix UserProfile import in aethex-database-adapter.ts
- Add notifications migration (title, message, read columns)

Server fixes
- Remove badge_color from achievements seed/upsert (column doesn't exist)
- Rename name→title, add slug field in achievements seed
- Remove email from all user_profiles select queries (column doesn't exist)
- Fix email-based achievement target lookup via auth.admin.listUsers
- Add GET /api/projects/:projectId endpoint
- Fix import.meta.dirname → fileURLToPath for Node 18 compatibility
- Expose VITE_APP_VERSION from package.json at build time

Navigation systems
- DevPlatformNav: reorganize into Learn/Build grouped dropdowns with descriptions
- Migrate all 11 dev-platform pages from main Layout to DevPlatformLayout
- Remove dead isDevMode context nav swap from main Layout
- EthosLayout: purple-accented tab bar (Library, Artists, Licensing, Settings)
  with member-only gating and guest CTA — migrate 4 Ethos pages
- GameForgeLayout: orange-branded sidebar with Studio section and lock icons
  for unauthenticated users — migrate GameForge + GameForgeDashboard
- SysBar: live latency ping, status dot (green/yellow/red), real version

Layout dropdown
- Role-gate Admin (owner/admin/founder only) and Internal Docs (+ staff)
- Add Internal section label with separator
- Fix settings link from /dashboard?tab=profile#settings to /dashboard?tab=settings

Project pages
- Add ProjectDetail page at /projects/:projectId
- Fix ProfilePassport "View mission" link from /projects/new to /projects/:id

Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
2026-04-12 05:01:10 +00:00
MrPiglr
f2823e2cd1
Merge branch 'main' into claude/find-unfinished-flows-vKjsD 2026-01-26 15:50:36 -07:00
Claude
ebf62ec80e
Add OKR management and time tracking features
OKR Management:
- Database tables for OKRs, key results, and check-ins
- Full CRUD API with progress auto-calculation
- UI with quarter/year filtering, create/edit dialogs
- Key result progress tracking with status indicators
- Trigger to auto-update OKR progress from key results

Time Tracking:
- Database tables for time entries and timesheets
- API with timer start/stop, manual entry creation
- Week/month/all view with grouped entries by date
- Stats for total hours, billable hours, avg per day
- Real-time timer with running indicator

Both features include RLS policies and proper indexes.
2026-01-26 22:36:16 +00:00
Claude
f1efc97c86
Add staff feature APIs and update 2 pages to use real data
- Add database migration for staff features (announcements, expenses,
  courses, reviews, knowledge base, projects, marketplace, handbook)
- Add 8 new API endpoints: announcements, expenses, courses, reviews,
  knowledge-base, projects, marketplace, handbook
- Update StaffAnnouncements.tsx to use real API with read tracking
- Update StaffExpenseReports.tsx to use real API with submit dialog

More staff pages to be updated in next commit.
2026-01-26 22:25:14 +00:00
Claude
0674a282b0
Add Candidate Portal foundation - API and core pages
- Add database migration for candidate_profiles, candidate_interviews,
  and candidate_offers tables with RLS policies
- Add API endpoints: /api/candidate/profile, /api/candidate/interviews,
  /api/candidate/offers
- Add CandidatePortal.tsx main dashboard with stats, quick actions,
  upcoming interviews, and pending offers
- Add CandidateProfile.tsx profile builder with tabs for basic info,
  work experience, education, and portfolio links
2026-01-26 21:58:45 +00:00
Claude
0136d3d8a4
Build complete Staff Onboarding Portal
- Add StaffOnboarding.tsx main hub with welcome banner, progress ring,
  and quick action cards
- Add StaffOnboardingChecklist.tsx with interactive Day 1/Week 1/Month 1
  checklist that saves progress to database
- Add database migration for staff_onboarding_progress and
  staff_onboarding_metadata tables with RLS policies
- Add API endpoint /api/staff/onboarding for fetching and updating
  onboarding progress with admin view for managers
- Add routes to App.tsx for /staff/onboarding and /staff/onboarding/checklist
2026-01-26 21:14:44 +00:00
MrPiglr
25d584fd46
feat: Complete database migration and developer platform
- Applied all 31 pending Supabase migrations successfully
- Fixed 100+ policy/trigger/index duplication errors for shared database
- Resolved foundation_contributions schema mismatch (added user_id, contribution_type, resource_id, points columns)
- Added DROP IF EXISTS statements for all policies, triggers, and indexes
- Wrapped storage.objects operations in permission-safe DO blocks

Developer Platform (10 Phases Complete):
- API key management dashboard with RLS and SHA-256 hashing
- Complete API documentation (8 endpoint categories)
- 9 template starters + 9 marketplace products + 12 code examples
- Quick start guide and SDK distribution
- Testing framework and QA checklist

Database Schema Now Includes:
- Ethos: Artist/guild tracking, verification, tracks, storage
- GameForge: Games, assets, monetization
- Foundation: Courses, mentorship, resources, contributions
- Nexus: Creator marketplace, portfolios, contracts, escrow
- Corp Hub: Invoices, contracts, team management, projects
- Developer: API keys, usage logs, profiles

Platform Status: Production Ready 
2026-01-10 02:05:15 +00:00
sirpiglr
baee7b6787 Strengthen security policies for escrow and payouts
Update RLS policies in `20251213_strengthen_nexus_rls.sql` to enforce legal entity separation, restricting access to escrow ledgers and payouts to clients/admins only, and adding admin-only policies for managing payouts and viewing compliance events.

Replit-Commit-Author: Agent
Replit-Commit-Session-Id: 9203795e-937a-4306-b81d-b4d5c78c240e
Replit-Commit-Checkpoint-Type: intermediate_checkpoint
Replit-Commit-Event-Id: 247c2875-7388-4bf9-a0cf-3283ed5fcf36
Replit-Commit-Screenshot-Url: https://storage.googleapis.com/screenshot-production-us-central1/7c94b7a0-29c7-4f2e-94ef-44b2153872b7/9203795e-937a-4306-b81d-b4d5c78c240e/aPpJgbb
Replit-Helium-Checkpoint-Created: true
2025-12-13 03:20:49 +00:00
sirpiglr
e60e71476f Add core architecture, API endpoints, and UI components for NEXUS
Introduces NEXUS Core architecture documentation, new API endpoints for escrow, payroll, talent profiles, time logs, and UI components for financial dashboards and compliance tracking.

Replit-Commit-Author: Agent
Replit-Commit-Session-Id: 9203795e-937a-4306-b81d-b4d5c78c240e
Replit-Commit-Checkpoint-Type: intermediate_checkpoint
Replit-Commit-Event-Id: e82c1588-4c11-4961-b289-6ab581ed9691
Replit-Commit-Screenshot-Url: https://storage.googleapis.com/screenshot-production-us-central1/7c94b7a0-29c7-4f2e-94ef-44b2153872b7/9203795e-937a-4306-b81d-b4d5c78c240e/aPpJgbb
Replit-Helium-Checkpoint-Created: true
2025-12-13 03:01:54 +00:00
sirpiglr
a4cf099b2c Update AI personas to include new subscription tiers and unlockable badges
Introduce a new 'Pro' tier for AI personas, update database schemas with tier and Stripe fields, and create a 'badges' table to manage persona access through earned badges.

Replit-Commit-Author: Agent
Replit-Commit-Session-Id: 9203795e-937a-4306-b81d-b4d5c78c240e
Replit-Commit-Checkpoint-Type: intermediate_checkpoint
Replit-Commit-Event-Id: 66a80a5c-6d47-429a-93e1-cf315013edf0
Replit-Commit-Screenshot-Url: https://storage.googleapis.com/screenshot-production-us-central1/7c94b7a0-29c7-4f2e-94ef-44b2153872b7/9203795e-937a-4306-b81d-b4d5c78c240e/LFvmEVc
Replit-Helium-Checkpoint-Created: true
2025-12-12 23:12:45 +00:00
Builder.io
ee59b17859 Create provider_identities table for OAuth federation to Foundation Passports
cgen-b79736960bf448c29552233ade19338b
2025-11-17 08:38:20 +00:00
Builder.io
fd673c07e4 Add Foundation passport cache tracking columns
cgen-ce44ca53fefb42ebb720613170e4ead2
2025-11-17 03:54:34 +00:00
Builder.io
f372d248e7 CORP Client Hub schema for invoicing and contracts
cgen-a6404a00b3b041d2b9c61fa935d68ef4
2025-11-15 19:31:52 +00:00
Builder.io
3a67836c25 completionId: cgen-c8f28d9d2be94d73b1fb2544f80647ae
cgen-c8f28d9d2be94d73b1fb2544f80647ae
2025-11-15 19:31:06 +00:00
Builder.io
8409c0fbcf Add Stripe payment fields to NEXUS tables
cgen-7740cad298bf4f2cbe57be2d75e99518
2025-11-15 19:30:50 +00:00
Builder.io
d821441005 Add GameForge sprints and tasks functionality
cgen-5531fa58665046dc892bcac60954d8b9
2025-11-15 17:02:11 +00:00
Builder.io
017fa8324e Add onboarded column to user_profiles table
cgen-370e192718ad494db53d1689a348f458
2025-11-15 16:53:18 +00:00
Builder.io
c2423fb952 Create migration to expand user_profile fields
cgen-28e05c5ef8444b54a38182f426b59305
2025-11-15 16:37:12 +00:00
Builder.io
e9133cd1f9 Add wallet_address field to user_profiles for wallet verification
cgen-e1e8eec4fb7c45c8aa3ad1bd11ccdef9
2025-11-15 01:34:14 +00:00
Builder.io
4933692480 Feed Phase 1: arm_affiliation and arm_follows schema
cgen-5f80fb1966e44ce4b6d3ad9c2c8055a9
2025-11-14 22:24:02 +00:00
Builder.io
db97bb6952 Add Fourthwall integration tables
cgen-332d9be5d81d4b7ba1478ad638262e39
2025-11-13 08:54:43 +00:00
Builder.io
bb31916815 Create user_follows table for social follow functionality
cgen-b60250f6bd65488391df858996643cbb
2025-11-13 06:53:19 +00:00
Builder.io
7a2dad81bc Create community_post_likes and community_comments tables
cgen-57af89b9a9704661a257932aa9b1cff8
2025-11-13 06:53:09 +00:00
Builder.io
a81280e23a Create community_posts table with all necessary columns for feed functionality
cgen-fc9372861d734071b6db013825b59fb2
2025-11-13 06:53:04 +00:00
Builder.io
ead70c550d Create migration for community post notifications system
cgen-6028cf6607c14f558c8d3972d9c4b51c
2025-11-13 06:35:33 +00:00
Builder.io
457ed6da8e Create migration for collaboration posts and multi-author support
cgen-28a4f491a39b4e3b962b5d4f5044eb85
2025-11-13 06:35:05 +00:00
Builder.io
666278baca Create migration for Discord channel webhook configuration
cgen-aab9f2b9c9154fca8a9e787a3af01f96
2025-11-13 06:34:22 +00:00
Builder.io
f35c5c892a Create migration for community posts likes and comments counters
cgen-ec7c0a488e3142738797a2bed6725053
2025-11-13 06:32:43 +00:00
Builder.io
2eeff17695 Add arm_affiliation to community_posts and create user_followed_arms table
cgen-f67c4f07c9314289bf922ce565446703
2025-11-13 06:19:11 +00:00
Builder.io
2c96aa5aaf Add rating column to ethos_tracks table
cgen-3560d4cfc90a45ed8bd4d672140e9895
2025-11-12 05:46:15 +00:00
Builder.io
325c6cf525 completionId: cgen-381c869efb4d419bba612587c3fff4d2
cgen-381c869efb4d419bba612587c3fff4d2
2025-11-12 05:41:21 +00:00
Builder.io
1075909e70 Add Spotify portfolio URL to aethex_creators
cgen-30736dda5db542099e4ec99d38e75ddd
2025-11-12 05:41:13 +00:00
Builder.io
c788675a3c Add Spotify portfolio URL to artist profiles
cgen-d4876cd0aa9d4f81b5f6f8dae20e87b1
2025-11-12 05:38:37 +00:00
Builder.io
813b33437c Nexus - Full Talent Marketplace System
cgen-8b270903186d4504a665f8736c70ab1c
2025-11-12 03:32:29 +00:00
Builder.io
2e7a74bee8 Foundation - Complete Education & Mentorship System
cgen-5055edce0fe341c28f6ca2241a4d4240
2025-11-12 03:31:57 +00:00
Builder.io
6276433828 Create GameForge studio management schema with projects, builds, team, and metrics
cgen-4ce1324db8d84b03a78e2d734fa5a91a
2025-11-12 03:08:27 +00:00
Builder.io
6749b26c8d Create ethos_service_requests table for artist commission tracking
cgen-b38a296273e34e39bda13eb5bfe943d6
2025-11-12 02:40:40 +00:00
Builder.io
b8d093842e Add service pricing and ecosystem license tracking to Ethos artists
cgen-e42e33def43e40dab4363bf7c157e173
2025-11-12 02:31:58 +00:00
Builder.io
58d201efd1 Set up Supabase Storage bucket for Ethos tracks
cgen-2cbf75c2ebe24d57bce3f72f3f311a9c
2025-11-11 23:27:00 +00:00
Builder.io
ead01a34e3 Create Ethos artist verification tracking tables
cgen-10489769eb804fa9842f1b063967c0c5
2025-11-11 23:24:15 +00:00
Builder.io
59926547fa Fix blog_posts migration - remove non-existent sequence grant
cgen-32392745fc664f0084092624f35c013d
2025-11-11 22:59:49 +00:00
Builder.io
733ccf2df6 completionId: cgen-a48df6046fc248f6b36cc72b455e51a2
cgen-a48df6046fc248f6b36cc72b455e51a2
2025-11-11 22:09:03 +00:00
Builder.io
b8f367e8ab Add email linking system for account unification
cgen-2b636a35c5ec4e31a77cc4b25df383f9
2025-11-11 22:08:14 +00:00
Builder.io
da0bdb7091 Ethos Guild - Database Schema (Tracks & Artist Profiles)
cgen-52cc030d8717465eb861f3fb42bdd3d5
2025-11-11 21:00:52 +00:00
Builder.io
71d420b4c8 Create blog_posts table for blog management
cgen-29a5256304a947bb8de019a1fdad262c
2025-11-11 03:23:04 +00:00
Builder.io
c7f2056073 Add location column to staff_members table
cgen-a0881347e7af47fc8c9d0c5dea113bec
2025-11-11 03:03:50 +00:00
Builder.io
35fb1b11b1 completionId: cgen-9154af170710432593fffd5bd89bbc90
cgen-9154af170710432593fffd5bd89bbc90
2025-11-11 03:03:47 +00:00
Builder.io
db0593ce8d completionId: cgen-57730e6e529247b6afde2b23b621f923
cgen-57730e6e529247b6afde2b23b621f923
2025-11-11 02:31:39 +00:00
Builder.io
f7f6e9e9aa completionId: cgen-973e77ecc6594b2b836d94a41d6f394c
cgen-973e77ecc6594b2b836d94a41d6f394c
2025-11-11 02:31:36 +00:00
Builder.io
4780f26838 Create database migration for staff members and contractors
cgen-52057812f0ed4e9db8bc747f52cc676e
2025-11-10 04:48:53 +00:00