Profile Management

interface UserProfile {
  // Identity
  id: string;                      // Unique user ID
  email: string;                   // Email address
  firstName: string | null;        // First name
  lastName: string | null;         // Last name
  profileImageUrl: string | null;  // Profile picture URL
  
  // Account Status
  role: 'user' | 'admin' | 'super_admin';
  isActive: boolean;               // Account enabled/disabled
  
  // Age Verification
  ageVerified: boolean;            // Completed age verification
  birthDate: string | null;        // YYYY-MM-DD format
  
  // Referral System
  referralCode: string;            // Your unique 8-char code
  referredBy: string | null;       // Who referred you
  
  // Onboarding
  onboardingCompleted: boolean;
  interests: UserInterests | null; // Preferences from onboarding
  
  // Credits
  credits: {
    balance: number;
    tier: string;
    isLowBalance: boolean;
    nextAllocationDate: string | null;
  };
  
  // Timestamps
  createdAt: string;
  updatedAt: string;
}

interface UserInterests {
  contentRole: 'creator' | 'consumer';
  preferredFeatures: string[];     // Max 2 feature slugs
  preferredTags: string[];         // Max 5 tag slugs
  onboardedAt: string;             // ISO timestamp
}

const response = await fetch('/api/auth/user', {
  method: 'PATCH',
  credentials: 'include',
  headers: { 'Content-Type': 'application/json' },
  body: JSON.stringify({
    firstName: 'John',
    lastName: 'Doe',
    profileImageUrl: 'https://example.com/avatar.jpg'
  })
});

const updatedUser = await response.json();

const userProfileUpdateSchema = z.object({
  firstName: z.string().min(1).max(100).optional(),
  lastName: z.string().min(1).max(100).optional(),
  profileImageUrl: z.string().url().optional()
});

{
  "birthDate": "1990-01-15",
  "ageVerified": true
}

{
  "message": "Age verification updated successfully",
  "user": {
    "ageVerified": true,
    "birthDate": "1990-01-15"
  }
}

await storage.logUserActivity({
  userId,
  action: 'age_verification_updated',
  feature: 'user_profile',
  details: {
    birthDate,
    ageVerified,
    timestamp: new Date().toISOString()
  },
  ipAddress: req.ip,
  userAgent: req.get('User-Agent'),
  sessionId: req.sessionID
});

{
  "contentRole": "consumer",
  "preferredFeatures": ["smart-captions", "sessions"],
  "preferredTags": ["joi", "sissy", "femdom", "edging", "cei"]
}

{
  "onboardingCompleted": true,
  "interests": {
    "contentRole": "consumer",
    "preferredFeatures": ["smart-captions", "sessions"],
    "preferredTags": ["joi", "sissy", "femdom", "edging", "cei"],
    "onboardedAt": "2026-03-02T12:00:00.000Z"
  }
}

interface UserCreditsSnapshot {
  balance: number;              // Current credit balance
  tier: string;                 // 'free' | 'joi_curious' | 'full_access' | 'vip'
  isLowBalance: boolean;        // Below threshold (20 credits)
  nextAllocationDate: string | null; // Next monthly allocation
}

import { useAuth } from '@/lib/AuthContext';

function ProfileComponent() {
  const { user } = useAuth();
  
  if (user?.credits) {
    return (
      <div>
        <h3>Credit Balance: {user.credits.balance}</h3>
        <p>Tier: {user.credits.tier}</p>
        {user.credits.isLowBalance && (
          <Alert>Running low on credits! Consider upgrading.</Alert>
        )}
        {user.credits.nextAllocationDate && (
          <p>Next allocation: {new Date(user.credits.nextAllocationDate).toLocaleDateString()}</p>
        )}
      </div>
    );
  }
}

const response = await fetch('/api/credits/transactions?page=1&limit=20');
const { transactions, hasMore, total } = await response.json();

transactions.forEach(tx => {
  console.log(`${tx.type}: ${tx.amount} credits (${tx.description})`);
});

const response = await fetch('/api/referrals/link');
const { code, referralUrl } = await response.json();

console.log('Your code:', code);        // e.g., "K7M2P9X4"
console.log('Share this:', referralUrl); // e.g., "https://joip.app?r=..."

const response = await fetch('/api/referrals/stats');
const stats = await response.json();

console.log({
  totalReferrals: stats.totalReferrals,      // Number of successful referrals
  creditsEarned: stats.creditsEarned,        // Total credits from referrals
  referralCode: stats.referralCode,          // Your code
  isProgramActive: stats.isProgramActive     // Program status
});

if (user.referredBy) {
  console.log('You were referred by user:', user.referredBy);
  // Note: Referrer's identity (email, name) is not exposed for privacy
}

SELECT 
  sessions_created,
  smart_captions_generated,
  babecock_images_created,
  media_uploaded,
  login_count,
  last_activity_at
FROM user_usage_stats
WHERE user_id = 'your-user-id';

const response = await fetch('/api/user/stats');
const stats = await response.json();

interface UserActivityLog {
  id: number;
  userId: string;
  action: string;          // e.g., 'session_created', 'caption_generated'
  feature: string;         // e.g., 'sessions', 'smart_captions'
  details: object;         // Action-specific metadata
  ipAddress: string;
  userAgent: string;
  sessionId: string;       // Browser session ID
  createdAt: timestamp;
}

-- Recent activity
SELECT action, feature, created_at
FROM user_activity_logs
WHERE user_id = 'your-user-id'
ORDER BY created_at DESC
LIMIT 50;

-- Activity by feature
SELECT feature, COUNT(*) as count
FROM user_activity_logs
WHERE user_id = 'your-user-id'
GROUP BY feature
ORDER BY count DESC;

// Admin-only endpoints
app.get('/api/admin/users', isAdmin, handler);
app.get('/api/admin/analytics', isAdmin, handler);

// Admin check middleware
function isAdmin(req, res, next) {
  const userId = getUserId(req);
  const user = await storage.getUser(userId);
  
  if (!user || (user.role !== 'admin' && user.role !== 'super_admin')) {
    return res.status(403).json({ error: 'Admin access required' });
  }
  
  next();
}

function sanitizeUserForClient(user: User) {
  const { password, ...safeUser } = user;
  return safeUser;
}

-- Sessions deleted when user deleted
ALTER TABLE content_sessions
ADD CONSTRAINT fk_user
FOREIGN KEY (user_id) REFERENCES users(id)
ON DELETE CASCADE;

-- Media deleted when user deleted
ALTER TABLE user_media
ADD CONSTRAINT fk_user
FOREIGN KEY (user_id) REFERENCES users(id)
ON DELETE CASCADE;

import { useAuth } from '@/lib/AuthContext';

function UserProfile() {
  const { user, refreshUser } = useAuth();
  const [isEditing, setIsEditing] = useState(false);
  
  const handleUpdate = async (updates) => {
    const response = await fetch('/api/auth/user', {
      method: 'PATCH',
      credentials: 'include',
      headers: { 'Content-Type': 'application/json' },
      body: JSON.stringify(updates)
    });
    
    if (response.ok) {
      await refreshUser(); // Refresh auth context
      setIsEditing(false);
    }
  };
  
  return (
    <div>
      <h1>{user.firstName} {user.lastName}</h1>
      <img src={user.profileImageUrl} alt="Profile" />
      <p>Email: {user.email}</p>
      <p>Credits: {user.credits.balance}</p>
      <p>Tier: {user.credits.tier}</p>
      {isEditing ? (
        <EditForm onSave={handleUpdate} onCancel={() => setIsEditing(false)} />
      ) : (
        <button onClick={() => setIsEditing(true)}>Edit Profile</button>
      )}
    </div>
  );
}