package me.FairyTailSystem.util;


import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import org.bukkit.Bukkit;

import me.FairyTailSystem.MySQL.MySQL;

public class BanManager {

    public static void ban(String uuid, String playername, String reason, int seconds){
        long end = 0;
        if(seconds == -1){
            end = -1;
        }

        long current = System.currentTimeMillis();
        long millis = seconds*1000;
        end = current+millis;

        MySQL.update("INSERT INTO BannedPlayers(Spielername, UUID, Ende, Grund) VALUE('"+playername+ "','" +uuid+ "','" +end+ "','" +reason+ "')");

        if(Bukkit.getPlayer(playername) != null){
            Bukkit.getPlayer(playername).kickPlayer("§4 Du wurdest aus dem mcFairyTail-Netzwerk ausgeschlossen!\n" +
                                                    "\n" +
                                                    "Grund: §e" + getReason(uuid) + "\n" +
                                                    "\n" +
                                                    "§2Verbliebene Zeit: " + getRemainingTime(uuid));
        }

    }
//Delete Eintrag
    public static void unban(String uuid){
        MySQL.update("DELETE FROM BannedPlayers WHERE UUID='"+uuid+"'");
    }

    public static boolean isBanned(String uuid){
        ResultSet rs = MySQL.getResult("SELECT Ende FROM BannedPlayers WHERE UUID='"+uuid+"'");

        try {
                return rs.next();

        } catch (SQLException e) {
            e.printStackTrace();
        }
        return false;

    }

//Grund auslesen

    public static String getReason(String uuid){
        System.out.println("UUID: "+uuid);
        ResultSet rs = MySQL.getResult("SELECT * FROM `BannedPlayers` WHERE `UUID`='"+uuid+"';");
            try{

                while(rs.next()) {
                    return rs.getString("Grund");
                }
            }catch(SQLException e){
                System.out.println("Hier, Hammer, schau mal :)");
                e.printStackTrace();
            }
            return  "";
    }

//Ende des Bans auslesen
    public static Long getEnd(String uuid){
        ResultSet rs = MySQL.getResult("SELECT * FROM BannedPlayers WHERE UUID='"+uuid+"'");
        try{
            while(rs.next()){
                return rs.getLong("Ende");
            }
        }catch(SQLException e){
            e.printStackTrace();
        }
        return  null;

    }

//Gebannter Speier auslesen
    public static List <String> getBannedPlayers(){
        List <String> list = new ArrayList<>();
        ResultSet rs = MySQL.getResult("SELECT * FROMM BannedPlayers");
        try {
            while(rs.next()){
                list.add(rs.getString("Spielername"));
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }

        return list;
    }

//Verbliebene Zeit auslesen

    public static String getRemainingTime(String uuid){
        long current = System.currentTimeMillis();
        long end = getEnd(uuid);
        long millis = end - current;

        if(end == -1){
            return "§cPermanent";
        }

        int seconds = 0;
        int minutes = 0;
        int hours = 0;
        int days = 0;
        int weeks = 0;

        while(millis > 1000){
            millis -= 1000;
            seconds++;
        }

        while(seconds > 60){
            seconds -= 60;
            minutes++;
        }

        while(minutes > 60){
            minutes -= 60;
            hours++;
        }

        while(hours > 24){
            hours -= 24;
            days++;
        }

        while(days > 7){
            days -= 7;
            weeks++;
        }



        return "§e" + weeks + "Woche(n)" + days + "Tage(n)" + hours + "Stunde(n)" + minutes + "Minute(n)" + seconds + "Sekunde(n)";
    }

}