'use strict'

const luaTable = require('./luaTable')
const areas = require('./WorldMapArea')
const fs = require('fs')

for (let index in areas) {
  areas[index].id = parseInt(index)
  areas[index].xDiff = areas[index].x2 - areas[index].x1
  areas[index].yDiff = areas[index].y2 - areas[index].y1
}

const getArea = (x, y) => {
  let value = []
  for (let index in areas) {
    let area = areas[index]
    if (area.x2 < x && x < area.x1 && area.y2 < y && y < area.y1) {
      value.push(area)
    }
  }
  return value
}

const knex = require('knex')({
  client: 'mysql',
  connection: {
    host: 'augusta.gunsight',
    user: 'jake',
    password: 'Objoyfu1',
    database: 'elysium'
  },
  pool: { min: 0, max: 7 }
})

let GatherItems = {}

const nodeTypes = {
  'Peacebloom': {
    name: 'peacebloom',
    icon: 1,
  },
  'Briarthorn': {
    name: 'briarthorn',
    icon: 1,
  },
  'Grave Moss': {
    name: 'grave moss',
    icon: 1,
  },
  'Gromsblood': {
    name: 'gromsblood',
    icon: 1,
  },
  'Wintersbite': {
    name: 'wintersbite',
    icon: 1,
  },
  'Swiftthistle': {
    name: 'swiftthistle',
    icon: 1,
  },
  'Golden Sansam': {
    name: 'golden sansam',
    icon: 1,
  },
  'Black Lotus': {
    name: 'black lotus',
    icon: 1,
  },
  'Earthroot': {
    name: 'earthroot',
    icon: 1,
  },
  'Sungrass': {
    name: 'sungrass',
    icon: 1,
  },
  'Firebloom': {
    name: 'firebloom',
    icon: 1,
  },
  'Goldthorn': {
    name: 'goldthorn',
    icon: 1,
  },
  'Mageroyal': {
    name: 'mageroyal',
    icon: 1,
  },
  'Icecap': {
    name: 'icecap',
    icon: 1,
  },
  "Arthas' Tears": {
    name: "arthas' tears",
    icon: 1,
  },
  'Silverleaf': {
    name: 'silverleaf',
    icon: 1,
  },
  'Wild Steelbloom': {
    name: 'wild steelbloom',
    icon: 1,
  },
  'Bruiseweed': {
    name: 'bruiseweed',
    icon: 1,
  },
  'Kingsblood': {
    name: 'kingsblood',
    icon: 1,
  },
  'Blindweed': {
    name: 'blindweed',
    icon: 1,
  },
  'Fadeleaf': {
    name: 'fadeleaf',
    icon: 1,
  },
  'Dreamfoil': {
    name: 'dreamfoil',
    icon: 1,
  },
  'Mountain Silversage': {
    name: 'mountain silversage',
    icon: 1,
  },
  'Plaguebloom': {
    name: 'plaguebloom',
    icon: 1,
  },
  'Purple Lotus': {
    name: 'purple lotus',
    icon: 1,
  },
  'Stranglekelp': {
    name: 'stranglekelp',
    icon: 1,
  },
  "Khadgar's Whisker": {
    name: "khadgar's whisker",
    icon: 1,
  },
  'Liferoot': {
    name: 'liferoot',
    icon: 1,
  },
  'Peacebloom': {
    name: 'peacebloom',
    icon: 1,
  },
  'Ghost Mushroom': {
    name: 'ghost mushroom',
    icon: 1,
  },
  'Wildvine': {
    name: 'wildvine',
    icon: 1,
  },
  'Dark Iron Deposit': {
    name: 'dark iron',
    icon: 1,
  },
  'Truesilver': {
    name: 'truesilver',
    icon: 1,
  },
  'Small Thorium Vein': {
    name: 'thorium',
    icon: 1
  },
  'Rich Thorium Vein': {
    name: 'thorium (rich)',
    icon: 1
  },
  'Ooze Covered Thorium Vein': {
    name: 'thorium',
    icon: 1
  },
  'Ooze Covered Rich Thorium Vein': {
    name: 'thorium (rich)',
    icon: 1
  },
  'Tin Vein': {
    name: 'tin',
    icon: 1
  },
  'Copper Vein': {
    name: 'copper',
    icon: 1
  },
  'Truesilver Deposit': {
    name: 'truesilver',
    icon: 1
  },
  'Ooze Covered Truesilver Deposit': {
    name: 'truesilver',
    icon: 1
  },
  'Mithril Deposit': {
    name: 'mithril',
    icon: 1
  },
  'Ooze Covered Mithril Deposit': {
    name: 'mithril',
    icon: 1
  },
  'Silver Vein': {
    name: 'silver',
    icon: 1
  },
  'Ooze Covered Silver Vein': {
    name: 'silver',
    icon: 1
  },
  'Gold Vein': {
    name: 'gold',
    icon: 1
  },
  'Ooze Covered Gold Vein': {
    name: 'gold',
    icon: 1
  },
  'Iron Deposit': {
    name: 'iron',
    icon: 1
  },
  'Ooze Covered Iron Deposit': {
    name: 'iron',
    icon: 1
  },
}

knex
  .select('gt.name', 'g.map', 'g.position_x', 'g.position_y')
  .from('gameobject AS g')
  .leftJoin('gameobject_template AS gt', 'g.id', 'gt.entry')
  .leftJoin('map_template AS m', 'm.entry', 'g.map')
  .whereIn('gt.name', Object.keys(nodeTypes))
  .whereIn('g.map', [0, 1])
  .then(nodes => {

    for (let node of nodes) {
      // Get the zone the node is in
      let area = getArea(node.position_x, node.position_y)
      console.log(node, area.length)
      continue

      // Get the zone x,y coordinates of the node
      let zone_x = Math.floor(Math.abs((node.position_x - area.x1) / area.xDiff * 100) * 1000) / 1000
      let zone_y = Math.floor(Math.abs((node.position_y - area.y1) / area.yDiff * 100) * 1000) / 1000

      // Create Continent object
      if (typeof (GatherItems[node.map]) === 'undefined') {
        GatherItems[node.map] = {}
      }

      // Create zone object
      if (typeof (GatherItems[node.map][area.id]) === 'undefined') {
        GatherItems[node.map][area.id] = {}
      }

      // Create node object list
      if (typeof (GatherItems[node.map][area.id][nodeTypes[node.name].name]) === 'undefined') {
        GatherItems[node.map][area.id][nodeTypes[node.name].name] = []
      }

      let newNode = {
        gtype: 1,
        x: zone_x,
        y: zone_y,
        count: 1,
        icon: nodeTypes[node.name].icon
      }

      GatherItems[node.map][area.id][nodeTypes[node.name].name].push(newNode)

    }

    fs.writeFile('output.lua', luaTable(GatherItems))


  })
knex.destroy()