bot.js

const Discord = require("discord.js");
const axios = require("axios");
const csv = require("fast-csv");
const pino = require("pino");
const moment = require("moment");
const queryHelper = require("./db");
const pgPromise = require("pg-promise");
const { v4: uuidv4 } = require("uuid");
require('dotenv').config();

const db = pgPromise()({
  host: process.env.DB_HOST || "localhost",
  user: process.env.DB_USER || "postgres",
  password: process.env.DB_PASSWORD || "postgres",
  database: process.env.DB_DATABASE || "",
});

const dbv2 = (!process.env.DBV2_HOST) ? null : pgPromise()({
  host: process.env.DBV2_HOST,
  user: process.env.DBV2_USER || "postgres",
  password: process.env.DBV2_PASSWORD || "postgres",
  database: process.env.DBV2_DATABASE || "",
});

const logger = pino({
  prettyPrint: {
    colorize: true, // --colorize
    errorLikeObjectKeys: ["err", "error"], // --errorLikeObjectKeys
    levelFirst: false, // --levelFirst
    messageKey: "msg", // --messageKey
    levelKey: "level", // --levelKey
    timestampKey: "time", // --timestampKey
    translateTime: true, // --translateTime
    ignore: "pid,hostname", // --ignore,
  },
});

const states = {
  LISTEN: "listen",
  SETUP: "setup",
  EVENT: "event",
};

const steps = {
  NONE: "none",
  CHANNEL: "channel",
  START: "start",
  END: "end",
  START_MSG: "start_msg",
  END_MSG: "end_msg",
  RESPONSE: "response",
  REACTION: "reaction",
  PASS: "pass",
  FILE: "file",
};

const defaultStartMessage =
  "The POAP distribution event is now active. *DM me to get your POAP*";
const defaultEndMessage = "The POAP distribution event has ended.";
const defaultResponseMessage =
  "Thanks for participating in the event. Here is a link where you can claim your POAP token: {code} ";
const instructions = ":warning: :warning: :warning: :warning: **You MUST send me a DIRECT MESSAGE with the code** :warning: :warning: :warning: :warning:  (click my name)"

var state = {
  state: states.LISTEN,
  expiry: 0,
  user: undefined,
  next: steps.NONE,
  event: {},
};

var guildEvents = new Map();

const client = new Discord.Client();

client.on("ready", () => {
  logger.info("[SETUP] Discord client ready!");

  (async () => {
    const res = await db.query("select count(*) from pg_database");
    logger.info(
      `[SETUP] ${res[0].count > 0 ? "PG client ready!" : "PG NOT READY"}`
    );

    await loadPendingEvents();
  })();
});

client.on("message", async (message) => {
  if (message.content === "ping") {
    message.reply("pong");
  } else if (!message.author.bot) {
    if (message.channel.type === "dm") {
      logger.info(
        `[MSG] DM ${message.channel.type} - ${message.content} from ${message.author.username}`
      );

      if (state.state === states.SETUP && state.user.id === message.author.id) {
        logger.info(
          `[ONMSG] state ${state.state} user ${
            state.user ? state.user.id : "-"
          }`
        );
        handleStepAnswer(message);
      } else {
        handlePrivateEventMessage(message);
      }
    } else {
      handlePublicMessage(message);
    }
  }
});

const sendDM = async (user, message) => {
  return new Promise(async (resolve, reject) => {
    const dm = await user.createDM();
    dm.send(message)
      .then((res) => {
        logger.info(`[DM] perfect, sent!`);
        resolve();
      })
      .catch((error) => {
        logger.error(`[DM] error ${error.httpStatus} - ${error.message}`);
        reject();
      });
  });
};

//-------------------------------
// Message handling

const handlePublicMessage = async (message) => {
  // logger.info(
  //   `[PUBMSG] ${message.content} from ${message.author.username} in guild ${message.channel.guild.name} #${message.channel.name}`
  // );

  const bot = client.user;

  if (message.mentions.has(bot)) {
    if (
      message.content.includes("@everyone") ||
      message.content.includes("@here")
    )
      return "";
    logger.info(`[PUBMSG] ${message.author.username} - Message mentions me with: ${message.content}`);
    botCommands(message);
  }
};

const botCommands = async (message) => {
  // let allowedRole = message.guild.roles.cache.find(x => x.name === 'POAP MASTER')
  const roleAllowed = message.member.roles.cache.some(r=>["POAP MASTER"].includes(r.name))
  logger.info(`[BOT] checking role ${roleAllowed}`);
  if (message.member.permissions.has(Discord.Permissions.FLAGS.MANAGE_GUILD) || roleAllowed) {
    // Check that user is an admin in this guild
    logger.info(`[BOT] user has permission`);
    if (message.content.toLowerCase().includes("!setup") && state.state !== states.SETUP) {
      // one at a time
      // Get any current record for this guild
      // start dialog in PM
      await setupState(message.author, message.channel.guild.name);
    } else if (message.content.includes("!status")) {
      logger.info(`[BOT] status request`);
      // sendDM(message.author, `Current status: ${state.state}`);
      const events = await queryHelper.getGuildEvents(
        db,
        message.channel.guild.name
      ); // Don't auto-create
      if (events && events.length > 0) {
        events.forEach(async (e) =>
          sendDM(message.author, `${await formattedEvent(e)}`)
        );
        reactMessage(message, "🙌");
      }
    } else if (message.content.includes("!instructions") || message.content.includes("!instruction")) {
      logger.info(`[BOT] instructions request`);

      reactMessage(message, "🤙")
      message.reply(instructions);
    }
  } else {
    logger.info(`[BOT] user lacks permission, or invalid command`);
    // reactMessage(message, "❗");
  }
};

const handleStepAnswer = async (message) => {
  resetExpiry();
  let answer = message.content;
  switch (state.next) {
    case steps.CHANNEL: {
      logger.info(`[STEPS] answer ${state.event.id}`);
      if (answer === "-") answer = state.event.channel;
      if (answer && answer.startsWith("#")) answer = answer.substring(1);
      // Confirm that channel exists
      const chan = await getChannel(state.event.server, answer);
      if (!chan) {
        const channels = printChannels(state.event.server)
        state.dm.send(
          `I can't find a channel named ${answer}. Try again -> ${channels}`
        );
      } else {
        state.event.channel = answer;
        state.next = steps.START;
        state.dm.send(
          `Date and time to START 🛫 ? *Hint: Time in UTC this format 👉  yyyy-mm-dd hh:mm`
        );
      }
      break;
    }
    case steps.START: {
      // TODO vali-date validate date :p
      if (answer === "-") answer = state.event.start_date;
      if(!moment(answer).isValid()){
        state.dm.send(
          `mmmm ${answer} It's a valid date? Try again 🙏`
        );
      } else {
        state.event.start_date = answer;
        state.next = steps.END;
        state.dm.send(
          `Date and time to END 🛬  the event? (${
            (moment(state.event.start_date).isValid() && moment(state.event.start_date)
              .add(1, "h")
              .format("YYYY-MM-DD HH:mm")) || ""
          })`
        );
      }
      break;
    }
    case steps.END: {
      if (answer === "-")
        answer = moment(state.event.start_date)
          .add(1, "h")
          .format("YYYY-MM-DD HH:mm");
      
      state.event.end_date = answer;
      state.next = steps.RESPONSE;
      state.dm.send(
        `Response to send privately to members during the event? (${
          state.event.response_message || defaultResponseMessage
        })`
      );
      break;
    }

    case steps.RESPONSE: {
      if (answer === "-")
        answer = state.event.response_message || defaultResponseMessage;
      state.event.response_message = answer;
      state.next = steps.PASS;
      state.dm.send(
        `Choose secret 🔒  pass (like a word, a hash from youtube or a complete link). This pass is for your users.`
      );
      break;
    }

    case steps.PASS: {
      const passAvailable = await queryHelper.isPassAvailable(db, answer);
      console.log(passAvailable);
      if (!passAvailable) {
        state.dm.send(`Please choose another secret pass. Try again 🙏 `);
      } else {
        state.event.pass = answer;
        //const emoji = getEmoji(state.event.server, answer);
        logger.info(`[STEPS] pass to get the POAP ${answer}`);

        state.next = steps.FILE;
        state.dm.send(`Please attach your links.txt file`);
      }
      break;
    }
    case steps.FILE: {
      if (message.attachments.size <= 0) {
        state.dm.send(`No file attachment found!`);
      } else {
        const ma = message.attachments.first();
        logger.info(`[STEPS] File ${ma.name} ${ma.url} ${ma.id} is attached`);
        state.event.file_url = ma.url;
        let total_count = await readFile(ma.url, state.event.uuid);
        // Report number of codes added
        state.dm.send(`DONE! codes added`);
      }
      state.next = steps.NONE;
      state.dm.send(
        `Thank you. That's everything. I'll start the event at the appointed time.`
      );
      clearTimeout(state.expiry);
      await queryHelper
        .saveEvent(db, state.event, message.author.username)
        .catch((error) => {
          console.log(error);
        });
      // Set timer for event start
      startEventTimer(state.event);
      clearSetup();
      break;
    }
  }
};

const handlePrivateEventMessage = async (message) => {
  // console.log(message);
  logger.info(`[DM] msg: ${message.content}`);

  const userIsBanned = await isBanned(db, message.author.id);

  if (!userIsBanned) {
    // 1) check if pass is correct and return an event
    const event = await queryHelper.getEventFromPass(db, message.content);
    console.log(event);
    if (event) {
      const getCode = await queryHelper.checkCodeForEventUsername(
        db,
        event.id,
        message.author.id
      );

      getCode && logger.info(`[DM] Code found: ${getCode.code}`);

      if (getCode && getCode.code) {
        logger.info(
          `[DM] OK for ${message.author.username}/${message.author.id} with code: ${getCode.code}`
        );

        console.log(
          "[DEBBUG] DM",
          JSON.stringify(message.author),
          " CODE: ",
          getCode.code
        );

        // replace placeholder in message
        const replyMsg =
          event && event.response_message
            ? event.response_message.replace("{code}", getCode.code)
            : defaultResponseMessage.replace("{code}", getCode.code);

        // Send DM
        replyMessage(message, replyMsg);
      } else {
        reactMessage(message, "🤔");
        logger.info(
          `[DM] ${message.author.username}/${message.author.id} already has a badge`
        );
      }
    } else {
      const codev2 = await checkPassInNewBot(message);
      if(codev2){
        replyMessage(message, codev2);
      }else{
        // no events
        reactMessage(message, "❌");
      }
    }
  } else {
    // bannedUser, no answer
    logger.info(
      `[BANNEDUSER] DM ${message.author.username}/${message.author.id}`
    );
  }
};

const checkPassInNewBot = async (message) => {
  if(!dbv2){
    logger.error(`No .env variable defined for v2`);
    return null;
  }
  const eventPass = message.content.replace('!', '').replace(/ /g, "");
  try{
    const event = await queryHelper.v2.getEventByPass(dbv2, eventPass);
    if(!event){
      return null;
    }

    const activeEvent = await queryHelper.v2.getActiveEventByPass(dbv2, eventPass);
    if(!activeEvent) {
      return "Event is no longer active";
    }

    const claimedCode = await queryHelper.v2.checkCodeForEventUsername(dbv2, event.id,message.author.id);
    if(!claimedCode)
      return "There are no more codes available";

    logger.info(
        `[DM-V2] OK for ${message.author.username}/${message.author.id} with code from new bot v2: ${claimedCode}`
    );

    console.log(
        "[DEBUG] DM-V2",
        JSON.stringify(message.author),
        " CODE: ",
        claimedCode
    );

    // replace placeholder in message
    return event && event.response_message
        ? event.response_message.replace("{code}", claimedCode)
        : defaultResponseMessage.replace("{code}", claimedCode);
  }catch (e){
    logger.error(`[DM-V2] error with DM, ${e}`);
    return null;
  }
};

const isBanned = async (db, user_id) => {
  const isBanned = await queryHelper.getBannedUsersById(db, user_id);
  return isBanned;
};

//-------------------------------------------
// Setup

// Initialise the state for a setup dialog
const setupState = async (user, guild) => {
  logger.info(`[SETUP] setupState ${guild}`);
  state.state = states.SETUP;
  state.next = steps.CHANNEL;
  state.event = getGuildEvent(guild); // Will create one if not already
  logger.info(`[SETUP] created or got event ${JSON.stringify(state.event)}`);
  state.dm = await user.createDM();
  state.dm.send(
    `Hi ${user.username}! You want to set me up for an event in ${guild}? I'll ask for the details, one at a time.`
  );
  state.dm.send(`To accept the suggested value, respond with "-"`);
  state.dm.send(
    `First: which channel should I speak in public? (${
      state.event.channel || ""
    }) *Hint: only for start and end event`
  );
  state.event.uuid = uuidv4();
  state.user = user;
  resetExpiry();
};

const resetExpiry = () => {
  console.log('setting reset')
  if (state.state != states.LISTEN) {
    clearTimeout(state.expiry);
    state.expiry = setTimeout(() => {
      state.dm.send(
        `Setup expired before answers received. Start again if you wish to complete setup.`
      );
      clearSetup();
    }, 300000);
  }
};

const clearSetup = () => {
  logger.info(`[SETUP] Clearing setup. Event in ${state.event.server} `);
  state.state = states.LISTEN;
  state.dm = undefined;
  state.event = {};
  state.user = undefined;
  state.next = steps.NONE;
};

// ---------------------------------------------------------------------
// Event

const startEventTimer = (event) => {
  // get seconds until event start
  const millisecs = getMillisecsUntil(event.start_date);
  if (millisecs >= 0) {
    logger.info(
      `[TIMER] Event starting at ${event.start_date}, in ${
        millisecs / 1000
      } secs`
    );
    // set timeout. Call startEvent on timeout
    state.eventTimer = setTimeout((ev) => startEvent(ev), millisecs, event);
  }
};

const startEvent = async (event) => {
  logger.info(`[EVENT] started: ${JSON.stringify(event.server)}`);
  // Send the start message to the channel
  sendMessageToChannel(event.server, event.channel, defaultStartMessage);

  // Set timer for event end
  const millisecs = getMillisecsUntil(event.end_date);
  logger.info(`[EVENT] ending in ${millisecs / 1000} secs`);
  state.endEventTimer = setTimeout((ev) => endEvent(ev), millisecs, event);
};

const getMillisecsUntil = (time) => {
  return Date.parse(time) - new Date();
};

const endEvent = async (event) => {
  logger.info(`[EVENT] ended: ${JSON.stringify(event)}`);
  state.state = states.LISTEN;
  // send the event end message
  sendMessageToChannel(event.server, event.channel, defaultEndMessage);
};

const formattedEvent = async (event) => {
  if (!event || !event.server) return "";

  let ms = getMillisecsUntil(event.start_date);
  let pending = `Event will start in ${ms / 1000} seconds`;
  if (ms < 0) {
    ms = getMillisecsUntil(event.end_date);
    if (ms < 0) {
      pending = "Event finished";
    } else {
      pending = `Event will end in ${ms / 1000} seconds`;
    }
  }

  const totalCodes = await queryHelper.countTotalCodes(db, event.id);
  const claimedCodes = await queryHelper.countClaimedCodes(db, event.id);

  return `Event in guild: ${event.server}
    Channel: ${event.channel}
    Start: ${event.start_date}
    End: ${event.end_date}
    Event start message: ${defaultStartMessage}
    Event end message: ${defaultEndMessage}
    Response to member messages: ${event.response_message}
    Pass to get the code: ${event.pass}
    Codes url: ${event.file_url}
    Total Codes: ${totalCodes && totalCodes.count}
    Claimed Codes: ${claimedCodes && claimedCodes.count}
    ${pending}`;
};

const getGuildEvent = (guild, autoCreate = true) => {
  if (!guildEvents.has(guild)) {
    if (!autoCreate) return false;
    guildEvents.set(guild, {
      server: guild,
    });
  }
  return guildEvents.get(guild);
};

//-----------------------------------------------
// Discord functions

const sendMessageToChannel = async (guildName, channelName, message) => {
  logger.info(
    `[CHANNELMSG] sendMessageToChannel ${guildName} ${channelName} msg ${message}`
  );
  const channel = getChannel(guildName, channelName);
  if (!channel) {
    return;
  }
  await channel.send(message);
};

const getChannel = (guildName, channelName) => {
  const guild = getGuild(guildName);
  if (!guild) {
    return false;
  }
  const channel = guild.channels.cache.find(
    (chan) => chan.name === channelName
  );
  if (!channel) {
    logger.info(
      `[CHANNELMSG] Channel not found! Guild channels: ${guild.channels.cache.size}`
    );
    return false;
  }
  return channel;
};

const printChannels = (guildName) => {
  const guild = getGuild(guildName);
  if (!guild) {
    return false;
  }
  const channels = guild.channels.cache.map( chan => `${chan},` ).join(' ');
  return channels;
};

const getGuild = (guildName) => {
  const guild = client.guilds.cache.find((guild) => guild.name === guildName);
  if (!guild) {
    logger.info(`[GUILD] not found! Client guilds: ${client.guilds.cache}`);
    return false;
  }
  return guild;
};

const replyMessage = async (message, sendMessage) => {
  message
    .reply(sendMessage)
    .catch((error) =>
      logger.error(`[DM] error with DM ${error.httpStatus} - ${error.message}`)
    );
};

const reactMessage = async (message, reaction) => {
  message
    .react(reaction)
    .catch((error) =>
      logger.error(
        `[EVENTMSG] error with reaction ${error.httpStatus} - ${error.message}`
      )
    );
};

//-------------------------------------------------------------------------------------------------

const loadPendingEvents = async () => {
  // read all events that will start or end in the future.
  try {
    let res = await queryHelper.getFutureActiveEvents(db);
    // console.log(res)
    res &&
      logger.info(`[PG] Active events: ${JSON.stringify(res && res.length)}`);
    if (res && res.length > 0) {
      // start timer for each one.
      res.forEach(async (row) => {
        logger.info(
          `Active event: ${row.id} | ${row.start_date} - ${row.end_date}`
        );
        startEventTimer(row);
      });
    } else {
      logger.info("[PG] No pending events");
    }
  } catch (err) {
    logger.error(`[PG] Error while getting event: ${err}`);
  }
};

const readFile = async (url, uuid) => {
  return new Promise(async (resolve, reject) => {
    try {
      const res = await axios.get(url);
      let count = 0;
      csv
        .parseString(res.data, { headers: false })
        .on("data", async function (code) {
          if (code.length) {
            await queryHelper.addCode(db, uuid, code[0]);
            logger.info(`-> code added: ${code}`);
            count += 1;
          }
        })
        .on("end", function () {
          logger.info(`[CODES] total codes ${count}`);
          resolve(count);
        })
        .on("error", (error) => logger.error(error));
    } catch (err) {
      logger.error(`[CODES] Error reading file: ${err}`);
    }
  });
};

//-------------------------------------------------------------------------------------------
// THIS  MUST  BE  THIS  WAY
client.login(process.env.BOT_TOKEN);