test-create-payment-data.js

Go to the documentation of this file.

/**
 * Create test invoices and contracts for Stripe payment testing
 */
require('dotenv').config();
const pool = require('./services/db');
 
const TENANT_ID = '00000000-0000-0000-0000-000000000001';
 
async function createTestData() {
  try {
    console.log('Creating test payment data...\n');
 
    // Get a customer to use
    const customerResult = await pool.query(
      'SELECT customer_id, name, email FROM customers WHERE tenant_id = $1 LIMIT 1',
      [TENANT_ID]
    );
 
    let customerId;
    if (customerResult.rows.length === 0) {
      // Create a test customer
      console.log('Creating test customer...');
      const newCustomer = await pool.query(
        `INSERT INTO customers (name, email, phone, tenant_id, created_by)
         VALUES ($1, $2, $3, $4, 1)
         RETURNING customer_id, name, email`,
        ['Acme Corporation', 'billing@acme-test.com', '555-0123', TENANT_ID]
      );
      customerId = newCustomer.rows[0].customer_id;
      console.log('✅ Created customer:', newCustomer.rows[0].name, `(ID: ${customerId})\n`);
    } else {
      customerId = customerResult.rows[0].customer_id;
      console.log('Using existing customer:', customerResult.rows[0].name, `(ID: ${customerId})\n`);
    }
 
    // Create some test invoices
    console.log('Creating test invoices...');
    const invoices = [
      {
        customer_id: customerId,
        description: 'Monthly IT Support - March 2026',
        subtotal: 500.00,
        tax_total: 50.00,
        total: 550.00,
        due_date: '2026-03-31',
        payment_status: 'unpaid',
        currency: 'usd'
      },
      {
        customer_id: customerId,
        description: 'Website Hosting & Maintenance',
        subtotal: 150.00,
        tax_total: 15.00,
        total: 165.00,
        due_date: '2026-03-25',
        payment_status: 'unpaid',
        currency: 'usd'
      },
      {
        customer_id: customerId,
        description: 'Cloud Storage Subscription',
        subtotal: 75.00,
        tax_total: 7.50,
        total: 82.50,
        due_date: '2026-03-20',
        payment_status: 'unpaid',
        currency: 'usd'
      }
    ];
 
    const createdInvoices = [];
    for (const inv of invoices) {
      const result = await pool.query(
        `INSERT INTO invoices (
          customer_id, description, subtotal, tax_total, total, 
          due_date, payment_status, currency, tenant_id, created_by,
          issued_date
        ) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, 1, CURRENT_DATE)
        RETURNING invoice_id, description, total, payment_status`,
        [
          inv.customer_id, inv.description, inv.subtotal, inv.tax_total, inv.total,
          inv.due_date, inv.payment_status, inv.currency, TENANT_ID
        ]
      );
      createdInvoices.push(result.rows[0]);
      console.log(`  ✅ Invoice #${result.rows[0].invoice_id}: $${result.rows[0].total} - ${result.rows[0].description}`);
    }
 
    // Check contracts table schema
    const contractColumns = await pool.query(`
      SELECT column_name 
      FROM information_schema.columns 
      WHERE table_name = 'contracts'
      ORDER BY ordinal_position
    `);
 
    console.log('\n📋 Contracts table columns:', contractColumns.rows.map(r => r.column_name).join(', '));
 
    // Create test contract (if table exists and has expected structure)
    const hasContract = contractColumns.rows.some(r => r.column_name === 'customer_id');
    if (hasContract) {
      console.log('\nCreating test contract...');
      const contractResult = await pool.query(
        `INSERT INTO contracts (
          customer_id, title, description, start_date, end_date,
          billing_interval, status, tenant_id, labor_rate
        ) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9)
        RETURNING contract_id, title, labor_rate, billing_interval`,
        [
          customerId,
          'Managed IT Services Contract',
          'Full IT support and management services including helpdesk, monitoring, and maintenance',
          '2026-01-01',
          '2026-12-31',
          'monthly',
          'active',
          TENANT_ID,
          500.00  // labor_rate as monthly value
        ]
      );
      console.log(`  ✅ Contract #${contractResult.rows[0].contract_id}: ${contractResult.rows[0].title} - $${contractResult.rows[0].labor_rate}/month`);
    }
 
    console.log('\n✅ Test data created successfully!');
    console.log('\n📊 Summary:');
    console.log(`  - Customer ID: ${customerId}`);
    console.log(`  - Invoices created: ${createdInvoices.length}`);
    console.log(`  - Total invoice value: $${createdInvoices.reduce((sum, inv) => sum + parseFloat(inv.total), 0).toFixed(2)}`);
 
    console.log('\n🧪 Stripe Test Cards:');
    console.log('  - 4242 4242 4242 4242 (Visa - always succeeds)');
    console.log('  - 5555 5555 5555 4444 (Mastercard - always succeeds)');
    console.log('  - 4000 0025 0000 3155 (Visa - requires authentication)');
    console.log('  - 4000 0000 0000 9995 (Visa - declined - insufficient funds)');
    console.log('  Exp: any future date, CVV: any 3 digits, ZIP: any 5 digits');
 
    await pool.end();
    process.exit(0);
 
  } catch (error) {
    console.error('❌ Error:', error.message);
    console.error(error);
    await pool.end();
    process.exit(1);
  }
}
 
createTestData();