From 5f0934acc0f7dde119be9f0a42a42742ec128377 Mon Sep 17 00:00:00 2001 From: Mohamed Bassem Date: Sun, 23 Nov 2025 00:54:38 +0000 Subject: feat: Add invitation approval for shared lists (#2152) * feat: Add invitation approval system for collaborative lists - Add database schema changes to support pending invitations - Add status field (pending/accepted/declined) to listCollaborators - Add invitedAt and invitedEmail fields for tracking - Add index on status for efficient queries - Update List model with invitation workflow methods - Modify addCollaboratorByEmail to create pending invitations - Add acceptInvitation() for users to accept invites - Add declineInvitation() for users to decline invites - Add revokeInvitation() for owners to revoke pending invites - Add getPendingInvitations() to get user's pending invites - Implement privacy protection for pending invitations - Mask user names as "Pending User" until invitation is accepted - Only show email to list owner for pending invitations - Update getSharedWithUser to only include accepted collaborations - Ensures lists only appear after invitation is accepted * feat: Add tRPC procedures and email notifications for list invitations - Add new tRPC procedures for invitation workflow - acceptInvitation: Allow users to accept pending invitations - declineInvitation: Allow users to decline invitations - revokeInvitation: Allow owners to revoke pending invitations - getPendingInvitations: Get all pending invitations for current user - Update getCollaborators output schema - Add status, invitedAt fields to collaborator objects - Support privacy-masked user info for pending invitations - Add sendListInvitationEmail function - Email notification when user is invited to collaborate - Includes list name, inviter name, and link to view invitation - Gracefully handles missing SMTP configuration - Integrate email sending into invitation workflow - Send email when new invitation is created - Send email when declined invitation is renewed - Catch and log errors without failing the invitation * feat: Add UI for list invitation approval workflow - Update ManageCollaboratorsModal to support pending invitations - Show "Pending" badge for pending invitations - Add revoke button for owners to cancel pending invitations - Update success message to reflect invitation sent - Disable role change and remove buttons for pending invitations - Create PendingInvitationsCard component - Display all pending invitations for the current user - Show list name, description, inviter, and role - Provide Accept and Decline buttons - Auto-hide when no pending invitations exist - Add PendingInvitationsCard to lists page - Show at the top of the lists page - Only renders when user has pending invitations * fix: Add missing translation keys and fix TypeScript errors - Add translation keys for invitation system - lists.collaborators.invitation_sent - lists.collaborators.pending - lists.collaborators.revoke - lists.collaborators.invitation_revoked - lists.collaborators.failed_to_revoke - lists.invitations.* (all invitation-related keys) - Fix TypeScript errors in email sending - Handle optional user.name with fallback to 'A user' * wip * fixes * more fixes * fix revoke * more improvements * comment fix * fix email url * fix schemas * split pending invites into components * more fixes * test * test fixes --------- Co-authored-by: Claude --- packages/db/schema.ts | 53 +++++++++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 53 insertions(+) (limited to 'packages/db/schema.ts') diff --git a/packages/db/schema.ts b/packages/db/schema.ts index 0479bb52..d5fd162d 100644 --- a/packages/db/schema.ts +++ b/packages/db/schema.ts @@ -453,6 +453,39 @@ export const listCollaborators = sqliteTable( ], ); +export const listInvitations = sqliteTable( + "listInvitations", + { + id: text("id") + .notNull() + .primaryKey() + .$defaultFn(() => createId()), + listId: text("listId") + .notNull() + .references(() => bookmarkLists.id, { onDelete: "cascade" }), + userId: text("userId") + .notNull() + .references(() => users.id, { onDelete: "cascade" }), + role: text("role", { enum: ["viewer", "editor"] }).notNull(), + status: text("status", { enum: ["pending", "declined"] }) + .notNull() + .default("pending"), + invitedAt: integer("invitedAt", { mode: "timestamp" }) + .notNull() + .$defaultFn(() => new Date()), + invitedEmail: text("invitedEmail"), + invitedBy: text("invitedBy").references(() => users.id, { + onDelete: "set null", + }), + }, + (li) => [ + unique().on(li.listId, li.userId), + index("listInvitations_listId_idx").on(li.listId), + index("listInvitations_userId_idx").on(li.userId), + index("listInvitations_status_idx").on(li.status), + ], +); + export const customPrompts = sqliteTable( "customPrompts", { @@ -733,6 +766,7 @@ export const userRelations = relations(users, ({ many, one }) => ({ subscription: one(subscriptions), importSessions: many(importSessions), listCollaborations: many(listCollaborators), + listInvitations: many(listInvitations), })); export const bookmarkRelations = relations(bookmarks, ({ many, one }) => ({ @@ -803,6 +837,7 @@ export const bookmarkListsRelations = relations( ({ one, many }) => ({ bookmarksInLists: many(bookmarksInLists), collaborators: many(listCollaborators), + invitations: many(listInvitations), user: one(users, { fields: [bookmarkLists.userId], references: [users.id], @@ -846,6 +881,24 @@ export const listCollaboratorsRelations = relations( }), ); +export const listInvitationsRelations = relations( + listInvitations, + ({ one }) => ({ + list: one(bookmarkLists, { + fields: [listInvitations.listId], + references: [bookmarkLists.id], + }), + user: one(users, { + fields: [listInvitations.userId], + references: [users.id], + }), + invitedByUser: one(users, { + fields: [listInvitations.invitedBy], + references: [users.id], + }), + }), +); + export const webhooksRelations = relations(webhooksTable, ({ one }) => ({ user: one(users, { fields: [webhooksTable.userId], -- cgit v1.2.3-70-g09d2