update-sponsors.js

#!/usr/bin/env node

const fs = require('fs');
const path = require('path');
const request = require('request-promise');

const filename = 'sponsors.json';
const absoluteFilename = path.resolve(__dirname, filename);

const graphqlEndpoint = 'https://api.opencollective.com/graphql/v2';

const graphqlQuery = `query account {
  account(slug: "socketio") {
    orders(status: [ACTIVE, PAID], minAmount: 10000, limit: 1000) {
      nodes {
        fromAccount {
          id
        }
        status
        processedAt
        totalAmount {
          value
        }
      }
    }
    members(role: BACKER, limit: 1000) {
      nodes {
        tier {
          name
        }
        account {
          id
          name
          slug
          website
          socialLinks {
            type
            url
          }
          imageUrl(format: jpg)
        }
        totalDonations {
          value
        }
        createdAt
      }
    }
  }
}`;

const customImages = new Map([
  ["gem-m", { url: "https://www.noneedtostudy.com/take-my-online-class/", img: "/images/sponsors/noneedtostudy.png", alt: "Pay someone to take my online class - NoNeedToStudy.com" }],
  ["yana1", { url: "https://nongamstopcasinos.net/gb/", img: "/images/sponsors/nongamstopcasinos.png", alt: "Non Gamstop Casinos" }],
  ["de2", { url: "https://www.slotozilla.com/de/software/novoline-de", img: "/images/sponsors/slotozilla.png", alt: "Novoline Spielautomaten" }],
  ["guest-3f7631a8", { url: "https://www.hityah.com", img: "/images/sponsors/guest-3f7631a8-2.jpg", alt: "Hityah" }],
  ["skweezer-net", { url: "https://skweezer.net/buy-instagram-followers", img: "/images/sponsors/skweezer-net.png", alt: "visit skweezer to buy instagram followers today" }],
  ["buy-instagram-reels-views", { url: "https://expressfollowers.com/buy-instagram-reel-views/", img: "/images/sponsors/buy-instagram-reels-views.ico", alt: "Buy Instagram Reel Views" }],
  ["guest-5c8f6e13", { url: "https://useviral.com/", img: "https://images.opencollective.com/useviral/29bff43/logo.png", alt: "UseViral" }],
]);

const customLinks = {
  "veselin-lalev": {
    url: "https://casinodaddy.com",
    img: "/images/sponsors/casinodaddy.png",
    alt: "Casino Daddy"
  },
  "quickbooks-tool-hub": {
    url: "https://quickbookstoolhub.com/",
    img: "/images/sponsors/quickbookstoolhub.png",
    alt: "Quickbooks Tool Hub"
  },
  "leafletcasino-com": {
    url: "https://leafletcasino.com/",
    img: "https://images.opencollective.com/leafletcasino-com/f8cd951/logo.png",
    alt: "leafletcasino.com"
  },
  "casinotest-ltd": {
    url: "https://www.casinotest.com/",
    img: "https://images.opencollective.com/casinotest-ltd/7e3c899/logo.png",
    alt: "CasinoTest Ltd."
  },
  "automatenspielexcom": {
    url: "https://automatenspielex.com",
    img: "/images/sponsors/automatenspielexcom.png",
    alt: "automatenspielex.com"
  },
  "veepn-vpn": {
    url: "https://veepn.com/vpn-apps/download-vpn-for-pc/",
    img: "https://images.opencollective.com/veepn-vpn/5e3715a/avatar.png",
    alt: "VeePN VPN"
  },
  andynichols: {
    url: "https://hmkasinotsuomi.com",
    img: "/images/sponsors/holymolycasinos.png",
    alt: "Suomalaiset kasinot"
  },
  auscasinos: {
    url: "https://www.auscasinos.com/",
    img: "https://images.opencollective.com/auscasinos/8df0f47/logo.jpg",
    alt: "AusCasinos"
  }
}

const nodeToSponsor = node => (customLinks[node.account.slug] || {
  url: node.account.socialLinks.find(link => link.type === "WEBSITE")?.url || node.account.website,
  img: node.account.imageUrl,
  alt: node.account.name
});

function monthDiff(dateFrom, dateTo) {
  return dateTo.getMonth() - dateFrom.getMonth() + (12 * (dateTo.getFullYear() - dateFrom.getFullYear()));
}

const NOW = new Date();
const AMOUNT_PER_MONTH = 100;

const main = async () => {
  console.log(`fetching sponsors from the graphql API`);

  const result = await request({
    method: 'POST',
    uri: graphqlEndpoint,
    body: { query: graphqlQuery },
    json: true
  });

  const sponsors = result.data.account.members.nodes;
  const orders = result.data.account.orders.nodes;

  const activeSponsorsById = new Set();

  orders.forEach(order => {
    const isActiveSubscription = order.status === "ACTIVE";
    const isSufficientOneShotPayment = order.totalAmount.value / (monthDiff(new Date(order.processedAt), NOW) || 1) >= AMOUNT_PER_MONTH;

    if (isActiveSubscription || isSufficientOneShotPayment) {
      activeSponsorsById.add(order.fromAccount.id);
    }
  });

  const activeSponsors = sponsors
    .map(n => {
      const customImage = customImages.get(n.account.slug);
      if (customImage) {
        if (customImage.img) {
          n.account.imageUrl = customImage.img;
        }
        if (customImage.url) {
          n.account.website = customImage.url;
        }
        if (customImage.alt) {
          n.account.name = customImage.alt;
        }
      }
      return n;
    })
    .filter(n => {
      const isSponsor = !n.tier || n.tier.name.toLowerCase() === 'sponsors';
      const isActive = activeSponsorsById.delete(n.account.id); // prevent duplicates
      const hasWebsite = n.account.socialLinks.some(link => link.type === "WEBSITE") || n.account.website; // website attribute is deprecated but still used in some cases

      return isSponsor && isActive && hasWebsite;
    })
    .sort((a, b) => {
      const sortByDonation = b.totalDonations.value - a.totalDonations.value;
      if (Math.abs(sortByDonation) > AMOUNT_PER_MONTH) {
        return sortByDonation;
      }
      return a.createdAt.localeCompare(b.createdAt);
    })
    .map(nodeToSponsor);

  console.log(`${activeSponsors.length} active sponsors out of ${sponsors.length}`);

  fs.writeFileSync(absoluteFilename, JSON.stringify(activeSponsors, null, 2));
  console.log(`content written to ${absoluteFilename}`);
}

main();