import UserModel from '../models/User';
import { SubscriptionHelper } from './subscriptionHelper';

/**
 * Migration script to add free subscriptions to existing users
 * Run this once to migrate existing users to the new subscription system
 */
export async function migrateExistingUsersToFreeSubscription() {
  try {
    console.log('Starting migration: Adding free subscriptions to existing users...');

    // Find all active users without a subscription_tier
    const usersWithoutTier = await UserModel.find({
      is_delete: false,
      $or: [{ subscription_tier: { $exists: false } }, { subscription_tier: null }],
    });

    console.log(`Found ${usersWithoutTier.length} users without subscription tier`);

    let successCount = 0;
    let errorCount = 0;

    for (const user of usersWithoutTier) {
      try {
        // Create free subscription for the user
        const result = await SubscriptionHelper.createFreeSubscription(user._id);

        if (result.success) {
          successCount++;
          console.log(`✓ Created free subscription for user: ${user.email}`);
        } else {
          errorCount++;
          console.error(
            `✗ Failed to create subscription for user ${user.email}: ${result.message}`
          );
        }
      } catch (error: any) {
        errorCount++;
        console.error(`✗ Error processing user ${user.email}:`, error.message);
      }
    }

    console.log('\n=== Migration Complete ===');
    console.log(`Total users processed: ${usersWithoutTier.length}`);
    console.log(`Successfully migrated: ${successCount}`);
    console.log(`Errors: ${errorCount}`);

    return {
      success: true,
      total: usersWithoutTier.length,
      migrated: successCount,
      errors: errorCount,
    };
  } catch (error: any) {
    console.error('Migration failed:', error);
    return {
      success: false,
      error: error.message,
    };
  }
}

/**
 * Update all users to have default subscription_tier = 'free' if not set
 */
export async function updateUserSubscriptionTierField() {
  try {
    console.log('Updating user subscription_tier field...');

    const result = await UserModel.updateMany(
      {
        is_delete: false,
        $or: [{ subscription_tier: { $exists: false } }, { subscription_tier: null }],
      },
      {
        $set: { subscription_tier: 'free' },
      }
    );

    console.log(`Updated ${result.modifiedCount} users with default subscription_tier`);

    return {
      success: true,
      modifiedCount: result.modifiedCount,
    };
  } catch (error: any) {
    console.error('Failed to update subscription_tier field:', error);
    return {
      success: false,
      error: error.message,
    };
  }
}
