Function compareDates

server/charts/dataFilter.js:6–154

(data, field, condition, timezone = "", timeInterval = "day")

const determineType = require("../modules/determineType");

function compareDates(data, field, condition, timezone = "", timeInterval = "day") {
  let newData = data;
  let moment = null;
  if (timezone) {
    moment = (...args) => momentObj(...args).tz(timezone);
  } else {
    moment = (...args) => momentObj.utc(...args);
  }

  if (!condition.value
    && (condition.operator !== "isNull" && condition.operator !== "isNotNull")) {
    return data;
  }

  // extract value
  const getValue = (obj) => {
    const selectors = field.split(".");
    let value = obj;
    for (let i = 0; i < selectors.length; i++) {
      value = value && value[selectors[i]];
    }

    if (!value) return null;

    // check for a potential timestamp format
    if (parseInt(value, 10).toString() === value.toString() && value.toString().length === 10) {
      return moment(value, "X");
    }
    if (parseInt(value, 10).toString() === value.toString() && value.toString().length === 13) {
      return moment(value, "x");
    }

    return momentObj.utc(value);
  };

  switch (condition.operator) {
    case "is":
      newData = _.filter(newData, (o) => {
        const val = getValue(o);

        if (timeInterval === "day" || timeInterval === "week" || timeInterval === "month" || timeInterval === "year") {
          return val
            ? val.startOf("day").isSame(moment(condition.value).startOf("day"))
            : false;
        }

        return val ? val.isSame(condition.value, timeInterval) : false;
      });
      break;
    case "isNot":
      newData = _.filter(newData, (o) => {
        const val = getValue(o);

        if (timeInterval === "day" || timeInterval === "week" || timeInterval === "month" || timeInterval === "year") {
          return val
            ? !val.startOf("day").isSame(moment(condition.value).startOf("day"))
            : false;
        }