setup.js

const config = require("./res/config.json");

module.exports = {
  getPokemonList: function(worksheet){
    //add the pokemon to the map with their row number
    var pokemonList = new Map();
    var i = 2;
    while(worksheet['A'+i].v != "HOUSE" ){
      var pokemonName = worksheet['B'+i].v.toLowerCase();
      pokemonName = pokemonName.replace(/\W/g, '');

      //dealing with mega and primal pokemon
      if(worksheet['A'+i].v == "Mega" || worksheet['A'+i].v == "Primal" || worksheet['A'+i].v == "Ultra"){
        pokemonName = worksheet['A'+i].v.toLowerCase() + pokemonName;
        console.log("added " + pokemonName);
      }

      pokemonList.set(pokemonName,i);
      i++;

    }

    return pokemonList;
  },

  getNatureList: function(worksheet){
    //someone decided to put spaces between groups of natures. if statement ignores those
    var natureList = new Map();
    for(i = 3; i <= config.numNatures; i++){
      if(worksheet['A'+i] != undefined){
        var cell = 'A'+i;
        var natureCell = worksheet[cell];
        var natureName = natureCell.v.toLowerCase();
        natureName = natureName.replace(/\W/g, '');
        natureList.set(natureName,i);
      }
    }
    return natureList;
  },

  getAbilityList: function(worksheet){
    //add of the abilities to the map with their row number
    var abilityList = new Map();
    var i = 2;
    while(worksheet['A'+ i] != undefined){
      var cell = 'A'+i;
      var abilityCell = worksheet[cell];
      var abilityName = abilityCell.v.toLowerCase();
      abilityName = abilityName.replace(/\W/g, '');
      abilityList.set(abilityName,i);
      i++;
    }

    return abilityList;
  },

  getHeldItemList: function(worksheet){
    var itemHeldList = new Map();

    for(i = 2; i < config.numHeldItems; i++){
      if(worksheet['A'+i] != undefined && worksheet['B'+i] != undefined){
        var itemName = worksheet['A'+i].v.toLowerCase();
        itemName = itemName.replace(/\W/g, '');
        itemHeldList.set(itemName,i);
      }
    }
    return itemHeldList;
  },

  getTlrItemList: function(worksheet){
    var itemTLRList = new Map();
    var i = 2;
    while(worksheet['A'+i] != undefined){
      var itemName = worksheet['A'+i].v.toLowerCase();
      itemName = itemName.replace(/\W/g, '');
      itemTLRList.set(itemName,i);
      i++;
    }
    return itemTLRList;
  },

  getKeyItemList: function(worksheet){
    var keyItemList = new Map();

    for(i = 2; i <= config.numKeyItems; i++){
      if(worksheet['A'+i] != undefined && worksheet['B'+i] != undefined){
        var itemName = worksheet['A'+i].v.toLowerCase();
        itemName = itemName.replace(/\W/g, '');
        keyItemList.set(itemName,i);
      }
    }
    return keyItemList;
  },

  getConsumableList: function(worksheet){
    var consumableList = new Map();

    var i = 2;
    while(worksheet['A'+i] != undefined){
      var itemName = worksheet['A'+i].v.toLowerCase();
      itemName = itemName.replace(/\W/g, '');
      consumableList.set(itemName,i);
      i++;
    }
    return consumableList;
  },

  getTypeList: function(worksheet){
    var typeList = new Map();

    var i = 1;
    while(worksheet['A'+i] != undefined){
      var typeName = worksheet['A'+i].v.toLowerCase();
      typeName.replace(/\W/g, '');
      typeList.set(typeName,i);
      i++;
    }
    return typeList;
  },

  getMoveList: function(worksheet){
    var moveList = new Map();

    //loop through all rows in the move worksheet
    var i = 2;
    var start = i;
    var end = 0;

    for(i = 2; i <= config.numMoves; i++){
      if(worksheet['A' + i] != undefined){
        end = i - 1;
        var arr = [0,0];
        arr[0] = start;
        arr[1] = end;

        var name = worksheet['A'+start].v.toLowerCase();
        name = name.replace(" (move)","");
        name = name.replace(" (command)","");
        name = name.replace(/\W/g, '');

        if(!name.includes("(users)") && name != "-"){
          moveList.set(name , arr);
        }

        start = i;
      }

    }
    return moveList;
  }

};