Handle Duplicate Records

async function findLikelyDuplicateContacts(token) {
  // Pull all contacts modified recently
  const response = await fetch(
    'https://api.virtuoussoftware.com/api/Contact/Query',
    {
      method: 'POST',
      headers: { Authorization: `Bearer ${token}`, 'Content-Type': 'application/json' },
      body: JSON.stringify({
        groups: [
          {
            conditions: [
              {
                parameter: 'Last Modified Date',
                operator: 'Is After',
                value: '2024-12-01T00:00:00Z',
              },
            ],
          },
        ],
        sortBy: 'name',
        skip: 0,
        take: 1000,
      }),
    }
  );

  const page = await response.json();

  // Group by email, then surface groups with more than one Contact
  const byEmail = new Map();
  for (const contact of page.list) {
    if (!contact.email) continue;
    const key = contact.email.toLowerCase().trim();
    if (!byEmail.has(key)) byEmail.set(key, []);
    byEmail.get(key).push(contact);
  }

  const duplicates = [];
  for (const [email, contacts] of byEmail.entries()) {
    if (contacts.length > 1) {
      duplicates.push({ email, contacts });
    }
  }

  return duplicates;
}

async function reconcileMergedContacts(token) {
  // Look at every Virtuous Contact ID you have stored on your side
  const trackedIds = await db.partnerContacts.findAll().map((c) => c.virtuousContactId);

  for (const id of trackedIds) {
    const response = await fetch(
      `https://api.virtuoussoftware.com/api/Contact/${id}`,
      { headers: { Authorization: `Bearer ${token}` } }
    );

    if (!response.ok) continue;
    const contact = await response.json();

    if (contact.mergedIntoContactId) {
      // This Contact was merged into another. Update your local record
      // to point to the surviving Contact.
      console.log(`Contact ${id} was merged into ${contact.mergedIntoContactId}`);
      await db.partnerContacts.update(
        { virtuousContactId: id },
        { virtuousContactId: contact.mergedIntoContactId, mergedFrom: id }
      );
    }
  }
}

async function handleContactUpdated(event) {
  const contact = event.data;
  if (contact.mergedIntoContactId) {
    // The Contact was merged into another. Update our records.
    await db.partnerContacts.update(
      { virtuousContactId: contact.id },
      {
        virtuousContactId: contact.mergedIntoContactId,
        mergedFrom: contact.id,
        mergedAt: new Date(),
      }
    );
  }
}

async function findDuplicateGiftsForDonation(token, transactionSource, transactionId) {
  // Look up by external reference first — this is the canonical lookup
  const byRef = await fetch(
    `https://api.virtuoussoftware.com/api/Gift/${encodeURIComponent(transactionSource)}/${encodeURIComponent(transactionId)}`,
    { headers: { Authorization: `Bearer ${token}` } }
  );

  if (byRef.ok) {
    return [await byRef.json()]; // The reference is unique — should return one gift
  }

  // If no match by reference, search by Contact + Amount + Date
  const gift = /* the canonical gift you're checking against */;
  const response = await fetch(
    'https://api.virtuoussoftware.com/api/Gift/Query',
    {
      method: 'POST',
      headers: { Authorization: `Bearer ${token}`, 'Content-Type': 'application/json' },
      body: JSON.stringify({
        groups: [
          {
            conditions: [
              { parameter: 'Contact Id', operator: 'Is', value: gift.contactId.toString() },
              { parameter: 'Amount', operator: 'Is', value: gift.amount.toString() },
              { parameter: 'Gift Date', operator: 'Is On', value: gift.giftDate },
            ],
          },
        ],
        skip: 0,
        take: 10,
      }),
    }
  );

  const page = await response.json();
  return page.list;
}

curl -X POST https://api.virtuoussoftware.com/api/Gift/ReversingTransaction \
  -H "Authorization: Bearer YOUR_API_TOKEN" \
  -H "Content-Type: application/json" \
  -d '{
    "reversedGiftId": 78422,
    "giftDate": "2024-12-16",
    "notes": "Reversing duplicate of Gift 78421 (Stripe ch_3PXyz123)"
  }'

// ❌ Wrong — regenerating transactionId on each retry
async function submitGift(donation) {
  const body = {
    transactionSource: 'YourPlatform',
    transactionId: crypto.randomUUID(),    // ❌ different on each call
    // ...
  };
  // If this retries, Virtuous sees each retry as a new gift.
}

// ✅ Correct — using a stable identifier from the donation event itself
async function submitGift(donation) {
  const body = {
    transactionSource: 'YourPlatform',
    transactionId: donation.id,            // ✅ stable across retries
    // ...
  };
}