Function getReferralCode

server/src/db/referral-codes-db.ts:126–132

(code: string)

}

export async function getReferralCode(code: string): Promise<ReferralCode | null> {
  const result = await query<ReferralCode>(
    'SELECT * FROM referral_codes WHERE code = $1',
    [code.toUpperCase()]
  );
  return result.rows[0] || null;
}

export async function listReferralCodes(referrerOrgId: string): Promise<ReferralDashboardRow[]> {
  const result = await query<ReferralDashboardRow>(