package com.amethystmc.uhc.commands;

import com.amethystmc.uhc.AmethystUHC;
import com.amethystmc.uhc.util.DBConnection;
import com.amethystmc.uhc.util.Messaging;
import com.amethystmc.uhc.util.NameFetcher;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.Arrays;
import java.util.HashMap;
import java.util.Map;
import java.util.UUID;
import org.bukkit.Bukkit;
import org.bukkit.ChatColor;
import org.bukkit.Location;
import org.bukkit.Material;
import org.bukkit.block.Sign;
import org.bukkit.command.Command;
import org.bukkit.command.CommandExecutor;
import org.bukkit.command.CommandSender;
import org.bukkit.configuration.file.FileConfiguration;

/**
 *
 * @author Rushmead
 */
public class ReloadSigns implements CommandExecutor {

    @Override
    public boolean onCommand(CommandSender sender, Command cmd, String label, String[] args) {
        if (!sender.isOp()) {
            Messaging.sendMessage(sender, "&4You do not have permission to run this command.", "");
            return false;
        }
        FileConfiguration config = AmethystUHC.getInstance().getConfig();
        HashMap<Location, String> locs = new HashMap<>();
        for (String str : config.getStringList("signs")) {
            Location spawn1 = new Location(
                    Bukkit.getWorlds().get(0),
                    config.getDouble("signs." + str + ".loc.X"),
                    config.getDouble("signs." + str + ".loc.Y"),
                    config.getDouble("signs." + str + ".loc.Z"));
            locs.put(spawn1, config.getString("signs." + str + ".numbers"));
        }
        for (Location loc : locs.keySet()) {
            int firstNumberint = Integer.parseInt(locs.get(loc).split("-")[0]);
            int secondNumberint = Integer.parseInt(locs.get(loc).split("-")[1]);
            if (Bukkit.getWorlds().get(0).getBlockAt(loc).getType().equals(Material.SIGN)) {
                Sign sin = (Sign) Bukkit.getWorlds().get(0).getBlockAt(loc);
                try {
                    PreparedStatement checkPlayer = DBConnection.getDatabase().getConnection().prepareStatement("SELECT * FROM uhc_players ORDER BY player_wins DESC;");

                    ResultSet resultSet = checkPlayer.executeQuery();
                    int line = 0;

                    for (int i = 1; i < secondNumberint + 1; i++) {
                        if (i < firstNumberint) {

                        } else {
                            System.out.print("Position:" + i + " On Sign Line no: " + line);
                            resultSet.absolute(i);
                            NameFetcher fetcher = new NameFetcher(Arrays.asList(UUID.fromString(resultSet.getString("player_uuid"))));
                            Map<UUID, String> response = null;
                            try {
                                response = fetcher.call();
                            } catch (Exception ev) {

                                ev.printStackTrace();
                            }
                            sin.setLine(line, ChatColor.GOLD + Integer.toString(i) + "." + response.get(UUID.fromString(resultSet.getString("player_uuid"))).substring(0, 12));

                            line++;
                        }
                    }
                } catch (Exception ex) {
                    ex.printStackTrace();
                }
            }
        }
        return true;
    }

}