package fr.fayiso.xenofight.hub.friends;

import fr.fayiso.xenofight.hub.Main;
import org.bukkit.OfflinePlayer;
import org.bukkit.entity.Player;

import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.UUID;

public class FriendsManager {

    private  HashMap<UUID, FriendData> friendData = new HashMap<>();

    public  void AddFriends(UUID p, UUID cible){
        try {
            PreparedStatement q = Main.getInstance().sql.getConnection().prepareStatement("INSERT INTO amies(uuid,uuidamies) VALUES (?,?)");
            q.setString(1, p.toString());
            q.setString(2, cible.toString());
            q.execute();
            q.close();
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }



    public  void removeFriend(UUID p, UUID cible) {
        try {
            Main.instance.sql.getConnection().prepareStatement("DELETE FROM amies WHERE uuid='"+p.toString()+"'AND uuidamies='"+cible.toString()+"'");
            Main.instance.sql.getConnection().prepareStatement("DELETE FROM amies WHERE uuid='"+cible.toString()+"'AND uuidamies='"+p.toString()+"'");
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }

    public  boolean hasFriend(UUID p, UUID friend) {
        try {
            PreparedStatement q = Main.instance.sql.getConnection().prepareStatement("SELECT uuid FROM amies WHERE uuid='" + p.toString() + "'AND uuidamies='" + friend.toString() + "'");
            ResultSet resultat = q.executeQuery();
            boolean hasAccount = resultat.next();
            q.close();
            return hasAccount;
        } catch (SQLException e) {
            e.printStackTrace();
        }

        return false;
    }


    public  List<String> getFriendsList(UUID p){
        loadFriendList(p);
        if(friendData.containsKey(p)){
           return friendData.get(p).getStringList();
        }
        return null;
    }

    private void loadFriendList(UUID p) {
        FriendData friend = new FriendData();
        try {
            PreparedStatement q = Main.getInstance().sql.getConnection().prepareStatement("SELECT uuidamies FROM amies WHERE uuid=?");
            q.setString(1, p.toString());
            ResultSet resultSet = q.executeQuery();
            System.out.print(resultSet);
            while (resultSet.next()) {
                UUID uuid = UUID.fromString(resultSet.getString("uuidamies"));
                friend.getStringList().add(uuid.toString());
            }
            friendData.put(p, friend);
        } catch (SQLException e) {
            e.printStackTrace();
        }


    }



    private  class FriendData{
        private List<String> stringList;

        public FriendData() {
            this.stringList = new ArrayList<>();
        }

        public List<String> getStringList() {
            return stringList;
        }
    }


}