PSA/server/seeds/dev/25_contract_line_services.cjs

exports.seed = async function (knex) {
    const tenant = await knex('tenants').select('tenant').first();
    if (!tenant) return;

    // Get contract lines
    const wonderlandBasic = await knex('contract_lines')
        .where({ tenant: tenant.tenant, contract_line_name: 'Wonderland Basic' })
        .select('contract_line_id')
        .first();

    const ozPremium = await knex('contract_lines')
        .where({ tenant: tenant.tenant, contract_line_name: 'Oz Premium' })
        .select('contract_line_id')
        .first();

    // Get services
    const rabbitTracking = await knex('service_catalog')
        .where({ tenant: tenant.tenant, service_name: 'Rabbit Tracking' })
        .select('service_id')
        .first();

    const lookingGlass = await knex('service_catalog')
        .where({ tenant: tenant.tenant, service_name: 'Looking Glass Maintenance' })
        .select('service_id')
        .first();

    const yellowBrick = await knex('service_catalog')
        .where({ tenant: tenant.tenant, service_name: 'Yellow Brick Road Repair' })
        .select('service_id')
        .first();

    const emeraldSecurity = await knex('service_catalog')
        .where({ tenant: tenant.tenant, service_name: 'Emerald City Security' })
        .select('service_id')
        .first();

    const recordsToInsert = [];

    if (wonderlandBasic && rabbitTracking) {
        recordsToInsert.push({
            tenant: tenant.tenant,
            contract_line_id: wonderlandBasic.contract_line_id,
            service_id: rabbitTracking.service_id,
            quantity: 10,
            custom_rate: null
        });
    }

    if (wonderlandBasic && lookingGlass) {
        recordsToInsert.push({
            tenant: tenant.tenant,
            contract_line_id: wonderlandBasic.contract_line_id,
            service_id: lookingGlass.service_id,
            quantity: 1,
            custom_rate: null
        });
    }

    if (ozPremium && yellowBrick) {
        recordsToInsert.push({
            tenant: tenant.tenant,
            contract_line_id: ozPremium.contract_line_id,
            service_id: yellowBrick.service_id,
            quantity: 20,
            custom_rate: null
        });
    }

    if (ozPremium && emeraldSecurity) {
        recordsToInsert.push({
            tenant: tenant.tenant,
            contract_line_id: ozPremium.contract_line_id,
            service_id: emeraldSecurity.service_id,
            quantity: 1,
            custom_rate: null
        });
    }

    if (recordsToInsert.length > 0) {
        await knex('contract_line_services').insert(recordsToInsert);
    }
};