purrform-backend / src / scripts / loyaltyPointsLedger.ts

// packages
import { writeFile } from 'node:fs/promises';

// helpers
import getAllBcCustomerAttributeValues from '../helpers/getAllBcCustomerAttributeValues';
import getAllBcCustomersByCustomerGroup from '../helpers/getAllBcCustomersByCustomerGroup';

interface Ledger {
    customerId: number;
    customerName: string;
    customerEmail: string;
    loyaltyPoints: string;
}

export default async function loyaltyPointsLedger(): Promise<void> {
    console.log('Starting loyalty points ledger');

    const ledger: Ledger[] = [];

    const personalCustomers =
        await getAllBcCustomersByCustomerGroup('personal');

    for (const personalCustomer of personalCustomers) {
        let currentLoyaltyPoints = await getAllBcCustomerAttributeValues(
            1,
            personalCustomer.id
        );
        if (currentLoyaltyPoints === null) {
            currentLoyaltyPoints = '0';
        }

        ledger.push({
            customerId: personalCustomer.id,
            customerName: `${personalCustomer.first_name} ${personalCustomer.last_name}`,
            customerEmail: personalCustomer.email,
            loyaltyPoints: currentLoyaltyPoints,
        });
    }

    console.log('Writing ledger to file');
    await writeFile(
        'data/loyalty-points-ledger.json',
        JSON.stringify(ledger, null, 4)
    );
}