create-test-portal-user.js

Go to the documentation of this file.

const { Pool } = require('pg');
const bcrypt = require('bcrypt');
const fs = require('fs');
 
// Manually parse .env file
const envContent = fs.readFileSync('.env', 'utf8');
const envVars = {};
envContent.split('\n').forEach(line => {
    const match = line.match(/^([^=]+)=(.*)$/);
    if (match) envVars[match[1]] = match[2];
});
 
const dbUrl = envVars.DATABASE_URL.replace('sslmode=require', 'sslmode=no-verify');
const pool = new Pool({ 
    connectionString: dbUrl, 
    ssl: { rejectUnauthorized: false } 
});
 
async function createTestUser() {
    const client = await pool.connect();
    
    try {
        console.log('🔍 Checking for existing customers...\n');
        
        // Get first customer
        const customerResult = await client.query(`
            SELECT customer_id, tenant_id, name, email 
            FROM customers 
            WHERE status = 'active'
            LIMIT 1
        `);
        
        if (customerResult.rows.length === 0) {
            console.log('📝 No customers found. Creating test customer...\n');
            
            const insertResult = await client.query(`
                INSERT INTO customers (
                    tenant_id, 
                    name, 
                    email, 
                    phone, 
                    status, 
                    allow_portal_access
                )
                VALUES (
                    'root-tenant',
                    'Test Customer Company',
                    'customer@precisewebhosting.com.au',
                    '0400 123 456',
                    'active',
                    true
                )
                RETURNING customer_id, tenant_id, name, email
            `);
            
            const customer = insertResult.rows[0];
            console.log('✅ Customer created:');
            console.log('   ID:', customer.customer_id);
            console.log('   Name:', customer.name);
            console.log('   Email:', customer.email);
            console.log();
            
            // Create portal user
            const passwordHash = await bcrypt.hash('password123', 10);
            
            const userResult = await client.query(`
                INSERT INTO customer_users (
                    tenant_id,
                    customer_id,
                    email,
                    password_hash,
                    first_name,
                    last_name,
                    phone,
                    is_primary,
                    is_active
                )
                VALUES ($1, $2, $3, $4, 'Test', 'User', '0400 123 456', true, true)
                RETURNING customer_user_id, email, first_name, last_name
            `, [customer.tenant_id, customer.customer_id, 'test@precisewebhosting.com.au', passwordHash]);
            
            console.log('✅ Portal user created:');
            console.log('   Email: test@precisewebhosting.com.au');
            console.log('   Password: password123');
            console.log('   Name:', userResult.rows[0].first_name, userResult.rows[0].last_name);
            console.log();
            
        } else {
            const customer = customerResult.rows[0];
            console.log('✅ Found customer:');
            console.log('   ID:', customer.customer_id);
            console.log('   Name:', customer.name);
            console.log('   Email:', customer.email);
            console.log();
            
            // Check if portal user already exists
            const existingUserResult = await client.query(`
                SELECT customer_user_id, email, first_name, last_name, is_active
                FROM customer_users
                WHERE customer_id = $1
            `, [customer.customer_id]);
            
            if (existingUserResult.rows.length > 0) {
                console.log('⚠️  Portal user already exists:');
                existingUserResult.rows.forEach((user, index) => {
                    console.log(`   ${index + 1}. ${user.email} - ${user.first_name} ${user.last_name} (${user.is_active ? 'Active' : 'Inactive'})`);
                });
                console.log();
                console.log('💡 Use these credentials to log in, or contact admin to reset password.');
            } else {
                console.log('📝 Creating portal user for this customer...\n');
                
                // Update customer to allow portal access
                await client.query(`
                    UPDATE customers 
                    SET allow_portal_access = true 
                    WHERE customer_id = $1
                `, [customer.customer_id]);
                
                // Create portal user
                const passwordHash = await bcrypt.hash('password123', 10);
                
                const userResult = await client.query(`
                    INSERT INTO customer_users (
                        tenant_id,
                        customer_id,
                        email,
                        password_hash,
                        first_name,
                        last_name,
                        phone,
                        is_primary,
                        is_active
                    )
                    VALUES ($1, $2, $3, $4, 'Portal', 'User', '0400 123 456', true, true)
                    RETURNING customer_user_id, email, first_name, last_name
                `, [customer.tenant_id, customer.customer_id, 'portal@precisewebhosting.com.au', passwordHash]);
                
                console.log('✅ Portal user created:');
                console.log('   Email: portal@precisewebhosting.com.au');
                console.log('   Password: password123');
                console.log('   Name:', userResult.rows[0].first_name, userResult.rows[0].last_name);
                console.log();
            }
        }
        
        console.log('━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━');
        console.log('🎉 Test customer user setup complete!');
        console.log('━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━');
        console.log();
        console.log('🔗 Portal URL: (checking deployment...)');
        console.log('📧 Test Email: test@precisewebhosting.com.au (or portal@precisewebhosting.com.au)');
        console.log('🔑 Test Password: password123');
        console.log();
        
    } catch (err) {
        console.error('❌ Error:', err.message);
        console.error(err.stack);
    } finally {
        client.release();
        await pool.end();
    }
}
 
createTestUser();