Data Functions

var c = getCustomer();
if (c && c.email) {
  console.log('Customer:', c.email);
}

var user = getUser();
if (user.email) {
  setVariable('greeting', 'Welcome, ' + user.name);
}

var orders = getOrders('newest', 10);

if (orders.length > 0) {
  setVariable('has_orders', true);
  setVariable('latest_order', orders[0].order_number);

  console.log('Found', orders.length, 'orders');
}

{
  order_number: 'ORD-12345',
  created_at: '2025-01-15T10:30:00Z',
  billing_address: '...',
  billing_city: '...',
  billing_state: '...',
  billing_zip: '...',
  billing_country: 'US',
  shipping_address: '...',
  shipping_city: '...',
  shipping_state: '...',
  shipping_zip: '...',
  shipping_country: 'US',
  currency: 'USD',
  customer_name: 'John Doe',
  customer_email: 'john@example.com',
  products: [
    { name: 'Premium Plan', price: 49.99, quantity: 1, image_url: '...', currency_code: 'USD' }
  ],
  tracking: [
    { tracking_number: '1Z999AA10123456784', tracking_url: '...', carrier: 'UPS' }
  ]
}

var order = getOrder(request.query.order);
if (order) {
  setVariable('order', order);
}

var f = getOrderFulfillment(request.query.order);
if (f) {
  setVariable('fulfillment', f);
}

var shipments = getOrderFulfillments();
setVariable('shipments', shipments);

var bonuses = getBonusProducts();

if (bonuses.length > 0) {
  setVariable('bonuses', bonuses);
  setVariable('has_bonuses', true);
}

{
  id: 123,                        // product ID (from brand_products)
  code: 'bonus-ebook',            // product code
  title: 'Free Bonus eBook',      // product title
  description: 'A bonus guide…',  // product description
  image_url: 'https://…/img.jpg', // product image
  bonus_url: 'https://…/file',    // download URL
  price: 0,                       // price (typically 0 for bonuses)
  type: 'digital',                // product type
  classification: 'bonus'         // product classification
}

var catalogBonuses = getAllBonusProducts();
setVariable('all_bonus_skus', catalogBonuses);

var purchasedProducts = getPurchasedProducts('newest');
setVariable('purchased_products', purchasedProducts);

{
  id: 100,
  code: 'theta-clear',
  title: 'Theta Clear',           // checkout_title preferred when present
  checkout_title: '',
  description: '...',
  image: 'https://cdn/theta.png',
  type: 'digital',
  classification: 'main',
  price: 39,                       // catalog price
  retail_price: 99,
  currency: 'USD',

  // Decorated catalog fields (same shape as getProducts)
  product_files: [ /* normalized file rows with `kind` */ ],
  digital_files: [ /* product_files filtered by type='digital' */ ],
  bonus_files:   [ /* product_files filtered by type='bonus' */ ],
  bonus_file: 'https://cdn/...',
  digital_file: 'https://cdn/...',
  primary_download_url: 'https://cdn/...',

  // Pre-rolled-up downloads — one flat list, deduped by URL, each tagged
  // with kind ('audio' | 'video' | 'document' | 'image' | 'archive' | 'file').
  // Use this instead of walking product_files / digital_files / bonus_files
  // by hand. See the productDownloads helper section above.
  downloads: [
    { url: '...', title: 'Theta Clear Vocal Guidance', kind: 'audio',
      purpose: 'digital', extension: 'mp3', mime_type: 'audio/mpeg',
      size: null, is_primary: true, sort_order: 0 },
  ],

  // Purchase context (flat — matches the fields used in member-area templates)
  order_number: 'A0FZ2V0A',
  conversion_code: 'CONV-1',
  created_at: '2026-04-28T10:00:00Z',
  line_price: 39,                  // amount paid for this line
  line_currency: 'USD',
  quantity: 1,
  has_shipping: false,             // true if the order has a shipping address

  // Bonuses received in the SAME order — every is_bonus line, no string
  // filtering. Each entry is catalog-enriched and carries its own
  // `downloads[]` rollup plus a direct `bonus_url`.
  included_bonuses: [
    {
      id: 200,
      code: 'integration-journal',
      title: 'The Theta Clear Integration Journal',
      classification: 'bonus',
      bonus_url: 'https://cdn/journal.pdf',
      downloads: [ /* same shape as above */ ],
      // ...full catalog fields
    },
    // ... all other bonus lines from the same order
  ]
}

// Member-area library — render every purchased product with its bonuses
// and downloads already prepared. No string heuristics, no manual joins.
var library = getPurchasedProducts('newest');

setVariable('library', library);
setVariable('library_count', library.length);
setVariable('has_library', library.length > 0);

var all = getSubscriptions();
var active = getSubscriptions('active', 25);

setVariable('subscriptions', all);
setVariable('has_active_subscription', active.length > 0);

{
  id: 'sub_abc123',
  status: 'active',                      // active | paused | canceled | past_due | trial
  customer_email: 'jane@example.com',
  customer_name: 'Jane Doe',
  products: [
    { code: 'monthly-plan', name: 'Monthly Plan', price: 29.99, quantity: 1, type: 'main' }
  ],
  amount: 29.99,
  currency_code: 'USD',
  tax_amount: 0,
  shipping_amount: 0,
  discount_amount: 0,
  frequency: 1,
  frequency_unit: 'month',               // day | week | month | year
  next_charge_at: '2026-05-12T00:00:00Z',
  started_at: '2026-04-12T00:00:00Z',
  paused_at: null,
  resume_at: null,
  canceled_at: null,
  cancel_reason: null,
  cycle_number: 2,
  trial_days: 0,
  first_charge_free: false,
  original_transaction_id: 'txn_xyz789',
  gateway: 'stripe',
  card_last4: '4242',
  card_brand: 'visa',
  created_at: '2026-04-12T00:00:00Z',
  updated_at: '2026-05-01T00:00:00Z'
}

var sub = getSubscription(request.query.id);
if (sub) {
  setVariable('subscription', sub);
}

// First active subscription for a specific product
var sub = getSubscription({ code: 'monthly-plan' });

// Most recent canceled subscription (win-back flow)
var canceled = getSubscription({ code: 'monthly-plan', status: 'canceled' });
if (canceled) {
  setVariable('canceled_at', canceled.canceled_at);
  setVariable('show_winback', true);
}

// First subscription regardless of code, any status
var any = getSubscription({ status: 'any' });

// Does the customer have any active subscription?
var isSubscribed = hasSubscription();

// Active subscription for a specific product (content gate)
if (hasSubscription({ code: 'premium-plan' })) {
  setVariable('show_premium', true);
}

// Was the customer subscribed on a specific date? (date-based gate)
if (hasSubscription({ code: 'premium-plan', date: '2026-01-01' })) {
  setVariable('can_view_jan_content', true);
}

// Does the customer have a past-due subscription? (dunning banner)
if (hasSubscription({ status: 'past_due' })) {
  setVariable('show_billing_warning', true);
}

var activeCount = countSubscriptions();
setVariable('active_sub_count', activeCount);

var totalCount = countSubscriptions({ status: 'any' });
var canceledCount = countSubscriptions({ status: 'canceled' });

var result = cancelSubscription('txn_xyz789', 'Too expensive');
if (!result.ok) {
  setVariable('error_message', result.error);
}

pauseSubscription('txn_xyz789');
pauseSubscription('txn_xyz789', '2026-08-01T00:00:00Z');

resumeSubscription('txn_xyz789');

var result = skipSubscription('txn_xyz789');
if (result.ok) {
  setVariable('next_charge', result.next_charge_at);
}

var result = changeSubscriptionFrequency('txn_xyz789', 'month', 2);
// → { ok: true, frequency_unit: 'month', frequency: 2, next_charge_at: '2026-06-12T...' }

var conversions = getConversions('john@example.com');

if (conversions.length > 0) {
  setVariable('returning_customer', true);
}

var product = getProduct('premium-plan');

if (product) {
  setVariable('product_name', product.name);
  setVariable('product_price', product.price);
}

// All products
var all = getProducts();

// Filtered
var physical = getProducts({ type: 'physical' });
var subscriptions = getProducts({ classification: 'subscription' });
var specific = getProducts({ codes: 'plan-a,plan-b,plan-c' });

var products = getAllProducts();
console.log('Total products:', products.length);

var product = getProductByCode('stripe', 'price_1234');

var p = getProduct('my-sku');

if (p && (p.bonus_file || p.primary_download_url)) {
  setVariable('bonus_href', p.bonus_file || p.primary_download_url);
}

if (p && p.digital_files && p.digital_files.length) {
  for (var i = 0; i < p.digital_files.length; i++) {
    var row = p.digital_files[i];
    console.log(
      row.title,
      row.file,
      'kind:', row.kind,
      'ext:', row.metadata && row.metadata.extension,
      'mime:', row.metadata && row.metadata.mime_type
    );
  }
}

var bonuses = getProducts({ classification: 'bonus' });

for (var i = 0; i < bonuses.length; i++) {
  var b = bonuses[i];
  console.log(b.title, '→', b.bonus_file || b.primary_download_url);
}

var p = getProduct('my-sku');
var files = productDownloads(p);

for (var i = 0; i < files.length; i++) {
  var f = files[i];
  switch (f.kind) {
    case 'audio':    console.log('🎧', f.title, f.url); break;
    case 'video':    console.log('🎬', f.title, f.url); break;
    case 'document': console.log('📄', f.title, f.url); break;
    case 'image':    console.log('🖼️', f.title, f.url); break;
    case 'archive':  console.log('📦', f.title, f.url); break;
    default:         console.log('📁', f.title, f.url);
  }
}

var product = getProduct('premium-plan');
var savings = productSavings(product);

// savings = {
//   amount: 20,
//   percent: 25,
//   amountFormatted: '$20.00',
//   percentFormatted: '25%'
// }

if (savings.percent > 0) {
  setVariable('discount_badge', 'Save ' + savings.percentFormatted);
}

var product = getProduct('monthly-plan');
var label = subscriptionSummary(product);
// e.g. "7-day free trial · Every 1 month"

setVariable('subscription_label', label);

var formatted = formatPrice(49.99, 'USD');
// "$49.99"
setVariable('display_price', formatted);

var course = getCourse(42);
if (course) {
  setVariable('course_title', course.title);
  setVariable('lesson_count', course.total_lesson_count);
}

var course = getCourseBySlug('javascript-basics');

var module = getModuleBySlug('javascript-basics', 'variables');
if (module) {
  setVariable('module_title', module.title);
}

var courses = getCourses();
setVariable('course_count', courses.length);

var marketingCourses = getCoursesByCategorySlug('marketing');
setVariable('marketing_course_count', marketingCourses.length);

var categories = getCategoriesWithCourses();
// [
//   { category_slug: 'marketing', category_name: 'Marketing', courses: [...] },
//   { category_slug: 'design', category_name: 'Design', courses: [...] },
// ]

setVariable('category_count', categories.length);

var course = getCourseForCustomer('javascript-basics');
if (course && course.is_assigned) {
  setVariable('progress', course.progress_percent);
}

var myCourses = getCoursesForCustomer();

var marketing = getCoursesForCustomerByCategorySlug('marketing');
setVariable('marketing_courses', marketing);

var categories = getCategoriesWithCoursesForCustomer();
// [
//   { category_slug: 'marketing', category_name: 'Marketing', courses: [...] },
//   { category_slug: 'design',    category_name: 'Design',    courses: [...] }
// ]

var totalDone = getCompletedLessonsCount();
var courseDone = getCompletedLessonsCount({ course: 'javascript-basics' });

var progress = getCourseProgress();
// progress.completedLessons  → 12
// progress.totalLessons      → 48
// progress.courses → [{ slug, title, completedLessons, totalLessons, progressPercent }]

var blog = getBlog();
if (blog) {
  setVariable('blog_name', blog.name);
}

// Or by specific ID
var specific = getBlog(5);

var blog = getBlog();
if (blog) {
  var articles = getBlogArticles(blog.id, 1, 10);
  setVariable('article_count', articles.length);
  setVariable('articles', articles);
}

var article = getBlogArticle(1, 'getting-started');
if (article) {
  setVariable('article_title', article.title);
  setVariable('article_body', article.body);
}

var categories = getBlogCategories(1);
setVariable('blog_categories', categories);

var related = getRelatedArticles(1, 42, 3);
setVariable('related_articles', related);

var link = buy('premium-plan');
setVariable('buy_url', link);

var link = upsell('vip-addon');
setVariable('upsell_url', link);

var link = downsell('basic-addon');
setVariable('downsell_url', link);

var link = decline('vip-addon');
setVariable('decline_url', link);

var link = upsellUpgrade('monthly_basic', 'monthly_premium');
setVariable('upgrade_url', link);

var link = upsellCancel();
setVariable('cancel_url', link);

var cssUrl = asset('/main.css');
var imgUrl = asset('/images/hero.jpg');

setVariable('css_url', cssUrl);

var customer = getCustomer();
if (customer.email === 'admin@example.com') {
  whitelistVisitor();
}

if (request.query.block === 'true') {
  blacklistVisitor();
  redirect('/blocked');
}

setSessionItem('preferred_plan', 'premium');
setSessionItem('quiz_score', '85');

var plan = getSessionItem('preferred_plan');
if (plan === 'premium') {
  setVariable('show_premium_banner', true);
}

clearSessionItem('preferred_plan');

getCrmField({ slug: 'weight-tracker', fieldKey: 'current_weight' });

getCrmFields({ slug: 'weight-tracker', fieldKeys: ['current_weight', 'goal_weight'] });

setCrmField({ slug: 'weight-tracker', fieldKey: 'current_weight', value: 182, force: true });

setCrmFields({
  slug: 'weight-tracker',
  fields: [
    { fieldKey: 'current_weight', value: 182 },
    { fieldKey: 'goal_weight', value: 165 }
  ]
});

// Another record type / id
setCrmField({ slug: 'weight-tracker', referenceType: 'order', referenceId: '12345', fieldKey: 'status', value: 'shipped' });

{
  id: 42,
  slug: 'member-settings',
  created: true,        // false if entity already existed
  fields_added: 3,      // newly inserted fields
  fields_skipped: 2     // already existed (left untouched)
}

ensureCrmEntity({
  slug: 'member-settings',
  name: 'Member Settings',
  icon: 'settings',
  fields: [
    { key: 'preferred_name', label: 'Preferred name', type: 'text' },
    { key: 'time_zone',      label: 'Time zone',      type: 'select',
      options: ['UTC', 'Europe/London', 'America/New_York'] },
    { key: 'marketing_opt_in', label: 'Marketing opt-in', type: 'checkbox' },
  ],
});

// Now safe to read/write — the entity definitely exists.
var name = getCrmField({ slug: 'member-settings', fieldKey: 'preferred_name' });

var entries = getCrmEntries({ slug: 'weight-tracker', limit: 50 });

for (var i = 0; i < entries.length; i++) {
  console.log(entries[i].title, entries[i].values_flat);
}

{
  id: 'abc123',
  reference_type: 'customer',
  reference_id: 'xyz789',
  values_flat: {
    current_weight: 182,
    goal_weight: 165,
    last_checkin: '2026-03-15'
  },
  created_at: '2026-03-15T10:00:00Z',
  updated_at: '2026-03-20T14:30:00Z'
}

var weight = getCrmField({ slug: 'weight-tracker', fieldKey: 'current_weight' });

if (weight && Number(weight) <= 165) {
  setVariable('show_goal_reached', true);
}

var fields = getCrmFields({ slug: 'weight-tracker', fieldKeys: ['current_weight', 'goal_weight'] });

if (fields.current_weight && Number(fields.current_weight) <= 165) {
  setVariable('show_goal_reached', true);
}

setCrmField({ slug: 'weight-tracker', fieldKey: 'current_weight', value: 182 });
setCrmField({ slug: 'weight-tracker', fieldKey: 'last_checkin', value: new Date().toISOString() });

setCrmField({ slug: 'weight-tracker', fieldKey: 'current_weight', value: 182, force: true });
setCrmField({ slug: 'weight-tracker', fieldKey: 'goal_weight', value: 165, force: true });
setCrmField({ slug: 'weight-tracker', fieldKey: 'last_checkin', value: today, force: true });

setCrmFields({
  slug: 'weight-tracker',
  fields: [
    { fieldKey: 'current_weight', value: 182 },
    { fieldKey: 'goal_weight', value: 165 },
    { fieldKey: 'last_checkin', value: today }
  ]
});

setCrmFields({
  slug: 'affiliate-requests',
  referenceType: 'affiliate_request',
  referenceId: 'leon@elasticfunnels.io',
  fields: [
    { field_key: 'affiliate_experience', value: 'Wellness' },
    { field_key: 'niche', value: 'Health' }
  ]
});

addCrmFieldValue({
  slug: 'weight-tracker',
  fieldKey: 'weighin_history',
  value: { date: today, weight: 182, notes: 'post-workout' }
});

var history = getCrmFieldValues({ slug: 'weight-tracker', fieldKey: 'weighin_history', limit: 10 });

for (var i = 0; i < history.length; i++) {
  console.log(history[i].date, history[i].weight);
}

var result = clearCrmEntries({ slug: 'weight-tracker' });
console.log(result.deleted, 'entries removed');

var result = moveCrmLead({ slug: 'deals', pipelineSlug: 'sales', stageSlug: 'qualified' });

if (!result.ok) {
  console.log('Move failed:', result.error);
}

moveCrmToStage({ slug: 'deals', stageSlug: 'won' });

moveCrmToPipeline({ slug: 'deals', pipelineSlug: 'onboarding' });

var result = moveCrmToEntity({
  fromSlug: 'leads',
  toSlug: 'deals',
  fieldMap: {
    lead_score: 'initial_score',
    source: 'lead_source'
  },
  pipelineSlug: 'sales',
  stageSlug: 'new',
  removeFromOld: false
});

if (result.ok) {
  console.log(result.moved, 'fields copied');
}