// ─── Configuration ───────────────────────────────────────────────────────────

// Your Fulcrum API token — replace with your actual token
// Use a read-only token with minimal permissions
var API_TOKEN = 'YOUR-API-TOKEN-HERE';

// Data name of the Single Choice field to populate with member names
var CHOICE_FIELD_NAME = 'request_reassignment';

// Storage cache key — change this if you deploy to multiple apps to avoid conflicts
var CACHE_KEY = 'memberships_choice_cache_v1';

// Number of memberships to request per page
var PER_PAGE = 1000;

// ─── Main Logic ──────────────────────────────────────────────────────────────

var storage = STORAGE();

ON('load-record', function () {
  // ── Step 1: Load cached choices if available ─────────────────────────────
  // Show cached member list immediately while the API request is in flight
  var cachedChoices = null;

  if (storage) {
    var cachedJson = storage.getItem(CACHE_KEY);
    if (cachedJson) {
      try {
        cachedChoices = JSON.parse(cachedJson);
      } catch (e) {
        cachedChoices = null;
      }
    }
  }

  if (cachedChoices && Array.isArray(cachedChoices) && cachedChoices.length > 0) {
    // Populate from cache right away (works offline)
    SETCHOICES(CHOICE_FIELD_NAME, cachedChoices);
  } else {
    // Show a placeholder while loading
    SETCHOICES(CHOICE_FIELD_NAME, [
      { label: 'Loading members...', value: '' }
    ]);
  }

  // ── Step 2: Fetch the live member list from the API ──────────────────────
  // Memberships are fetched one page at a time. The response includes
  // total_pages, so we keep requesting pages until we have them all.
  function useCacheOrAlert(message) {
    // If the request fails but we have a cached list, silently fall back to it
    if (cachedChoices && Array.isArray(cachedChoices) && cachedChoices.length > 0) {
      SETCHOICES(CHOICE_FIELD_NAME, cachedChoices);
    } else {
      ALERT(message);
    }
  }

  function fetchPage(page, collected) {
    var options = {
      url: 'https://api.fulcrumapp.com/api/v2/memberships.json?per_page=' + PER_PAGE + '&page=' + page,
      method: 'GET',
      headers: {
        'Accept': 'application/json',
        'X-ApiToken': API_TOKEN
      }
    };

    REQUEST(options, function (error, response, body) {
      if (error) {
        useCacheOrAlert('Error loading members: ' + INSPECT(error));
        return;
      }

      // ── Step 3: Parse the response ────────────────────────────────────────
      var data;
      try {
        data = JSON.parse(body);
      } catch (e) {
        useCacheOrAlert('Error parsing Memberships API response.');
        return;
      }

      collected = collected.concat(data.memberships || []);

      // Keep going until every page has been fetched
      if (page < (data.total_pages || 1)) {
        fetchPage(page + 1, collected);
      } else {
        buildChoices(collected);
      }
    });
  }

  // ── Step 4: Build choice objects, update the field, and save to cache ────
  function buildChoices(memberships) {
    var seenUserIds = {};
    var choices = [];

    memberships.forEach(function (m) {
      if (!m.user_id) return;

      // Deduplicate by user_id in case the API returns duplicates
      if (seenUserIds[m.user_id]) return;
      seenUserIds[m.user_id] = true;

      // Use the display name, falling back to first+last name, then email
      var label =
        m.user ||
        (m.first_name && m.last_name
          ? m.first_name + ' ' + m.last_name
          : (m.email || 'Unknown'));

      choices.push({
        label: label,
        value: m.user_id
      });
    });

    // Sort alphabetically by display name
    choices.sort(function (a, b) {
      return a.label.localeCompare(b.label);
    });

    SETCHOICES(CHOICE_FIELD_NAME, choices);

    if (storage) {
      try {
        storage.setItem(CACHE_KEY, JSON.stringify(choices));
      } catch (e) {
        // Ignore storage write errors (e.g. storage quota exceeded)
      }
    }

    // Clear the placeholder value if it was never filled in
    var current = VALUE(CHOICE_FIELD_NAME);
    if (current === '?' || current === '' || current == null) {
      SETVALUE(CHOICE_FIELD_NAME, null);
    }
  }

  fetchPage(1, []);
});