File size: 3,605 Bytes
7cfdc4c
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
#!/usr/bin/env python3
import asyncio
import sys
from pathlib import Path
from datetime import datetime, timezone, timedelta
from decimal import Decimal

backend_dir = Path(__file__).parent.parent.parent
sys.path.insert(0, str(backend_dir))

from core.services.supabase import DBConnection
from core.utils.logger import logger
from core.billing.credits.manager import credit_manager

async def fix_trial_users():
    """Fix users who incorrectly have trial credits as non-expiring"""
    db = DBConnection()
    await db.initialize()
    client = await db.client
    
    print("\n" + "="*60)
    print("FIXING TRIAL USERS WITH INCORRECT NON-EXPIRING CREDITS")
    print("="*60)
    
    # Find users on trial or recently converted from trial
    result = await client.from_('credit_accounts')\
        .select('*')\
        .in_('trial_status', ['active', 'converted'])\
        .execute()
    
    if not result.data:
        print("No trial users found")
        return
    
    fixed_count = 0
    
    for account in result.data:
        account_id = account['account_id']
        tier = account.get('tier', 'none')
        trial_status = account.get('trial_status')
        non_expiring = Decimal(str(account.get('non_expiring_credits', 0)))
        expiring = Decimal(str(account.get('expiring_credits', 0)))
        balance = Decimal(str(account.get('balance', 0)))
        

        if non_expiring >= Decimal('5') and trial_status in ['active', 'converted']:
            print(f"\nUser {account_id[:8]}... has incorrect trial credits:")
            print(f"  Trial Status: {trial_status}")
            print(f"  Current Balance: ${balance}")
            print(f"  Non-expiring: ${non_expiring} (INCORRECT - includes trial credits)")
            print(f"  Expiring: ${expiring}")
            
            # Calculate the correction
            trial_amount = Decimal('5')
            corrected_non_expiring = non_expiring - trial_amount
            corrected_expiring = expiring + trial_amount
            
            # The total balance should remain the same
            print(f"\n  Correcting to:")
            print(f"  Non-expiring: ${corrected_non_expiring} (removed trial credits)")
            print(f"  Expiring: ${corrected_expiring} (added trial credits)")
            print(f"  Total Balance: ${balance} (unchanged)")
            
            # Update the credit account
            update_result = await client.from_('credit_accounts').update({
                'non_expiring_credits': float(corrected_non_expiring),
                'expiring_credits': float(corrected_expiring),
                'updated_at': datetime.now(timezone.utc).isoformat()
            }).eq('account_id', account_id).execute()
            
            if update_result.data:
                # Add ledger entry for audit trail
                await client.from_('credit_ledger').insert({
                    'account_id': account_id,
                    'amount': 0,  # No balance change, just reclassification
                    'balance_after': float(balance),
                    'type': 'adjustment',
                    'description': 'Fixed trial credits: moved $5 from non-expiring to expiring'
                }).execute()
                
                print(f"  ✅ Fixed credits for user {account_id[:8]}...")
                fixed_count += 1
            else:
                print(f"  ❌ Failed to fix user {account_id[:8]}...")
    
    print(f"\n{'='*60}")
    print(f"COMPLETED: Fixed {fixed_count} users")
    print("="*60)

if __name__ == "__main__":
    asyncio.run(fix_trial_users())