package fr.happytony.overplugin;

import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.HashMap;
import java.util.Map;
import java.util.UUID;

import fr.happytony.overplugin.cache.BanPlayerData;
import fr.happytony.overplugin.commands.CmdBan;
import fr.happytony.overplugin.commands.CommandCoin;
import fr.happytony.overplugin.commands.CommandDiscord;
import fr.happytony.overplugin.commands.CommandSpawn;
import fr.happytony.overplugin.commands.CommandTest;
import fr.happytony.overplugin.sql.SQL;

public class Main extends org.bukkit.plugin.java.JavaPlugin
{


  public SQL sql;

  public Map<UUID, BanPlayerData> bannis = new HashMap<>();

  public CmdBan cmdBan = new CmdBan(this);
  public CommandCoin cmdCoin = new CommandCoin(sql);

  public void onEnable()
  {
	//recup les commandes
	getCommand("gtempban").setExecutor(cmdBan);
	getCommand("pay").setExecutor(cmdCoin);
	getCommand("balance").setExecutor(cmdCoin);
	getCommand("gban").setExecutor(cmdBan);
	getCommand("unban").setExecutor(cmdBan);
    getCommand("test").setExecutor(new CommandTest());
    getCommand("spawn").setExecutor(new CommandSpawn());
    getCommand("discord").setExecutor(new CommandDiscord());
    //mettre le listener en event
   getServer().getPluginManager().registerEvents(new Listerners(this, sql), this);
    //connecté le serveur MySQL
    sql = new SQL("jdbc:mysql://","localhost","serveur","root","");
    sql.connection();

    //charger les joueur ban
    loadBannedPlayers();
  }

  private void loadBannedPlayers() {

      try {
          PreparedStatement q = sql.getConnection().prepareStatement("SELECT uuid, reason, expiredate FROM bannis WHERE CURDATE() < expiredate");

          ResultSet resultat = q.executeQuery();

          while(resultat.next()){

              UUID uuid = UUID.fromString(resultat.getString("uuid"));
              String reason = resultat.getString("reason");

              BanPlayerData ban = new BanPlayerData();
              ban.setReason(reason);
              ban.setUuid(uuid);

              bannis.put(uuid, ban);

          }

          q.execute();
          q.close();
      } catch (SQLException e) {
          e.printStackTrace();
      }

      System.out.println(bannis.size() + " joueurs ont été bannis sur le serveur !");

  }

  public void onDisable(){
      sql.disconnect();
  }




}