package me.zachbears27;
import java.io.Console;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import org.bukkit.Bukkit;
import org.bukkit.Location;
import org.bukkit.Server;
import org.bukkit.command.Command;
import org.bukkit.command.CommandSender;
import org.bukkit.command.ConsoleCommandSender;
import org.bukkit.conversations.ConversationAbandonedListener;
import org.bukkit.entity.Player;
import org.bukkit.event.EventHandler;
import org.bukkit.event.Listener;
import org.bukkit.event.entity.PlayerDeathEvent;
import org.bukkit.inventory.ItemStack;
import org.bukkit.plugin.java.JavaPlugin;
import java.sql.Statement;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.HashMap;
import java.util.concurrent.TimeUnit;

import me.zachbears27.MySQL;
import net.md_5.bungee.api.ChatColor;

//This Plugin Is Made For MumboCraft & It's Players & Staff.. Any misuse or re-distribution of this plugin will call for said plugin to be removed
//Plugin by A_Brave_Panda & Jamdoggy

public class JumbleHill extends JavaPlugin implements Listener {

      HashMap<String, ItemStack[]> inventoryContents = new HashMap<String, ItemStack[]>();
      HashMap<String, ItemStack[]> inventoryArmorContents = new HashMap<String, ItemStack[]>();
      Server server = Bukkit.getServer();
      ConsoleCommandSender console = server.getConsoleSender();

MySQL MySQLC = null;
Connection c = null;

String host = getConfig().getString("Hostname");
String port = getConfig().getString("Port");
String db = getConfig().getString("Database");
String username = getConfig().getString("Username");
String password = getConfig().getString("Password");
String table = getConfig().getString("Table");
String intro = ChatColor.GREEN + "" + ChatColor.BOLD + "Jumble Hill " + ChatColor.GRAY + "" + ChatColor.BOLD + ">> ";
String itemtable = "items";


 @Override
 public void onDisable() {

 }

 @Override
 public void onEnable() {
      getServer().getPluginManager().registerEvents(this, this);
      registerConfig();
      MySQL MySQLC = new MySQL(host, port, db, username, password);
  try {
    c = MySQLC.openConnection();
} catch (ClassNotFoundException e) {
    e.printStackTrace();
} catch (SQLException e) {

    e.printStackTrace();
}

System.out.print("[JumbleHill] Plugin Has Been Loaded!");

}

 public void registerConfig() {
    saveDefaultConfig();




    }


 java.util.Date dt = new java.util.Date();

 java.text.SimpleDateFormat sdf =
      new java.text.SimpleDateFormat("MM/dd/yy HH:mm:ss");
    Date now = new Date();
     SimpleDateFormat format = new SimpleDateFormat("MM/dd/yy HH:mm:ss");


  public boolean onCommand(CommandSender sender, Command cmd, String label, String[] args) {
    if (sender instanceof Player) {
        Player p = (Player)sender;
 if(cmd.getLabel().equalsIgnoreCase("jumblehill")) {
      if(args.length == 0) {
          p.sendMessage(intro + ChatColor.RED + " Incorrect Arguments! Please try: '/jumblehill help'");
      } else if(args[0].equals("help")) {
          p.sendMessage(intro + ChatColor.AQUA + " /jumblehill search");
          p.sendMessage(intro + ChatColor.AQUA + " /jumblehill stats");
          p.sendMessage(intro + ChatColor.AQUA + " /jumblehill set");
          p.sendMessage(intro + ChatColor.AQUA + " /jumblehill add {item name} {item amount} {item price in diamonds}");
      } else if(args[0].equals("search")) {

        /*   new AnvilGUI(this, p, new AnvilGUI.AnvilClickHandler() {
                 @Override
                 public boolean onClick(AnvilGUI menu, String text){
                     menu.getPlayer().sendMessage(intro + ChatColor.GOLD + "You have chosen: " + ChatColor.AQUA + text);
                 String select = "SELECT * FROM " + table + " WHERE shopname = '" + text.replace("'", "").replace("Shop Name", "") +"';";
                     try {
                    Statement statement = c.createStatement();
                    ResultSet res = statement.executeQuery(select);
                    if(res.next()) {
                        //If shop exists, update location
                        menu.getPlayer().sendMessage(intro + ChatColor.GREEN + "Shop Location Updated!");
                        String UpdateShopName = "UPDATE " + table + " SET shopname='" + text.replace("'", "").replace("Shop Name", "") + "', owner='" + p.getName() + "', x='" + x + "', y='" + y + "', z='" + z + "' WHERE id='" + res.getInt("id") + "';";
                        statement.executeUpdate(UpdateShopName);
                        } else {
                            //if it doesnt, create it
                            statement.executeUpdate(ShopName);
                        }
                } catch (SQLException e2) {
                    e2.printStackTrace();
                }

                     return true;



                 }
             }).setInputName("Enter An Item Name").open(); */
      } else if(args[0].equals("set")) {

             Location l = p.getLocation();
             double x = l.getX();
             double y = l.getY();
             double z = l.getZ();

             new AnvilGUI(this, p, new AnvilGUI.AnvilClickHandler() {
                 @Override
                 public boolean onClick(AnvilGUI menu, String text){
                     String cleantext = text.replace("'", "").replace("Shop Name", "");
                     String ShopName = "INSERT INTO "+ table + " (id, shopname, owner, x, y, z) VALUES (NULL, '" + cleantext + "', '" + p.getName() + "', '" + x + "', '" + y + "', '" + z + "');";
                     String select = "SELECT * FROM " + table + " WHERE shopname = '" + cleantext +"';";
                     try {
                    Statement statement = c.createStatement();
                    ResultSet res = statement.executeQuery(select);
                //If shop exists, update location
                    if(res.next()) {
                        //shop exists
                        //if owner of shop equals player making shop then do it
                        if(menu.getPlayer().getName().equalsIgnoreCase(res.getString("owner"))) {
                            menu.getPlayer().sendMessage(intro + ChatColor.GOLD + "Your shop is called: " + ChatColor.AQUA + cleantext);
                             menu.getPlayer().sendMessage(intro + ChatColor.GOLD + "Your shop is now located at: " + ChatColor.AQUA + x + " " + y + " " + z);
                             menu.getPlayer().sendMessage(intro + ChatColor.GOLD + "Remember, you can always use this command again to re-update your shop location!");
                        menu.getPlayer().sendMessage(intro + ChatColor.GREEN + "Shop Location Updated!");
                        String UpdateShopName = "UPDATE " + table + " SET shopname='" + cleantext + "', owner='" + p.getName() + "', x='" + x + "', y='" + y + "', z='" + z + "' WHERE id='" + res.getInt("id") + "';";
                        statement.executeUpdate(UpdateShopName);
                        } else {
                            menu.getPlayer().sendMessage(intro + ChatColor.RED + "You must own " + cleantext + " to remove it!");
                        }
                        } else {
                            //shop doesnt
                             menu.getPlayer().sendMessage(intro + ChatColor.GOLD + "Your shop is called: " + ChatColor.AQUA + cleantext);
                             menu.getPlayer().sendMessage(intro + ChatColor.GOLD + "Your shop is located at: " + ChatColor.AQUA + x + " " + y + " " + z);
                             menu.getPlayer().sendMessage(intro + ChatColor.GOLD + "Remember, you can always use this command again to re-update your shop location!");
                            statement.executeUpdate(ShopName);
                            menu.getPlayer().sendMessage(intro + ChatColor.GREEN + "Shop Location Created!");
                        }
                } catch (SQLException e2) {
                    e2.printStackTrace();
                }

                     return true;

                 }
             }).setInputName("Shop Name").open();


      } else if(args[0].equals("add")) {
          if(!(args.length < 4)) {

             new AnvilGUI(this, p, new AnvilGUI.AnvilClickHandler() {
                 @Override
                 public boolean onClick(AnvilGUI menu, String text){
                     String cleantext = text.replace("'", "").replace("Shop Name", "");
                     String ShopName = "INSERT INTO "+ itemtable + " (id, shopname, itemname, itemprice, itemamount) VALUES (NULL, '" + cleantext + "', '" + args[1] + "', '" + args[3] + "', '" + args[2] + "');";
                     String itemselect = "SELECT * FROM " + itemtable + " WHERE shopname = '" + cleantext +"';";
                     String nameselect = "SELECT * FROM " + table + " WHERE shopname = '" + cleantext +"';";

                     p.sendMessage(nameselect + " ");
                     return true;

                 }
             }).setInputName("Shop Name").open();
          } else {
              p.sendMessage(intro + ChatColor.RED + "Incorrect Arguments! Please try: '/jumblehill add {item name} {item amount} {item price in diamonds}'");
          }

      }
 }
 } else {
     console.sendMessage(ChatColor.DARK_RED + "[Critical Warning]" + ChatColor.RED + " This Is For Players Only");
 }
    return true;
  }
}