const Discord = require ('discord.js');
var mysql = require('mysql');
var con = mysql.createConnection({
  host : process.env.HOST,
  user : process.env.USER,
  password : process.env.PASSWORD,
  database : process.env.DATABASE
})

module.exports.run = async (client, msg, args) => {

  con.query(`SELECT * FROM pokemon WHERE user_id = ${msg.author.id}`, function (err, result, fields) {
    if (err) throw err;
    if(result.length === 0){
      return msg.reply(`No pokemon, try \`${process.env.PREFIX}start\`?`)
    }
    else{
      var txt = "";
      function Paginator(items, page, per_page) {
        var page = args[0] || 1,
        per_page = per_page || 20,
        offset = (page - 1) * per_page,

        paginatedItems = items.slice(offset).slice(0, per_page),
        total_pages = Math.ceil(items.length / per_page);
        return {
          page: page,
          per_page: per_page,
          pre_page: page - 1 ? page - 1 : null,
          next_page: (total_pages > page) ? page + 1 : null,
          total: items.length,
          total_pages: total_pages,
          data: paginatedItems
        };
      }
      try {
        con.query(`SELECT * FROM pokemon WHERE user_id = ${msg.author.id} ORDER BY name`, function(err, rows, fields) {
          Paginator(rows).data.forEach(function(row) {
            var no1 = (row.hpiv+row.atkiv+row.defiv+row.spatkiv+row.spdefiv+row.speediv)/31
            var no2 = no1/6
            var no3 = no2*100
            txt = txt + '#'+row.number+'\u2000**' + row.name + '** | Level : ' + row.level + ' | IV : ' + no3.toString ().slice (0,5) + '%' + `${row.nickname != null ? ` | **Nickname** : ${row.nickname}` : "" }` +'\n'
            return txt
            console.log('Finish');
          });
          let embed = new Discord.RichEmbed ()
          .setColor (process.env.WARNA)
          .setThumbnail("http://chittagongit.com//images/pokedex-icon/pokedex-icon-19.jpg")
          .setAuthor (`${msg.author.username}' pokemons`, msg.author.avatarURL)
          .setDescription (txt)
          .setFooter(`You have ${Paginator(result).total} Pokemons. Page ${Paginator(result).page} of ${Paginator(result).total_pages}`)
          msg.channel.send(embed)
        });
      }
      catch (err) {
        msg.reply(`No pokemon! try \`${process.env.PREFIX}start\``)
      }
    }
  })
}

exports.help = {
  name: 'pokemon',
}
exports.conf = {
  aliases: ['poks']
}