const commando = require('discord.js-commando');
const mysql = require('mysql');
const { RichEmbed } = require('discord.js');


// This function is adding into database, removing all previous messages and displaying the new registered list in the #attractive-ico channel

var channel = require('./channel.json');

const con = mysql.createConnection({
    host: "localhost",
    user: "root",
    password: "apple",
    database: "icoprediction"
});

class Register extends commando.Command {
    constructor(client){
        super(client, {
            name: 'register',
            group: 'ico',
            memberName: 'register',
            description: 'Register an ico Admins Only!',
            examples: ['ICO Webpage Presale/Mainsale Whitelist Time(in CET). e.g. \n Gems https://gems.org/ Presale Yes 18:00']
        });
    }

    async run(message, args) {
        var ico = args.split(' ');
        if(ico.length == 6) {
            var command = `INSERT INTO ICOPrediction (name, website, sale, whitelist, datetime) VALUES (?, ?, ?, ?, ?);`;
            var select = `SELECT name, website, sale, whitelist, datetime, DATEDIFF(datetime, NOW()) AS timeRemaining FROM icoprediction ORDER BY datetime ASC`;
            con.query(command, [ico[0], ico[1], ico[2], ico[3], ico[4] + " " + ico[5]], function(err) {
                if(!err) {
                    message.reply("Registered ICO");
                }
                else message.reply("Output Error");
            });
            this.client.channels.get(channel.id).bulkDelete(20);
            con.query(select, (err, results) => {
                if(err) {
                    message.reply("Database Error");
                }
                var currentDate = new Date();
                var conversion;
                var output = [];

                results.forEach(result => {
                    if(result.timeRemaining >= 0) {
                        if(result.whitelist == 1) {
                            conversion = 'Yes';
                        }
                        else {conversion = 'No';}
                        output.push(`${result.name} - <${result.website}> - ${result.sale} - Whitelisted : ${conversion} - ${result.datetime} \n\n`);
                    }
                });
                const embed = new RichEmbed()
                    .setDescription('output')
                    .setColor(0x00AE86)


                this.client.channels.get(channel.id).send(output.join(""));
            });
        }
        else message.reply("Input Error : You added or wrote wrong datatype");
    }
}

module.exports = Register;