l2auctionmanagerinstance

/*
 * This program is free software: you can redistribute it and/or modify it under
 * the terms of the GNU General Public License as published by the Free Software
 * Foundation, either version 3 of the License, or (at your option) any later
 * version.
 *
 * This program is distributed in the hope that it will be useful, but WITHOUT
 * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
 * FOR A PARTICULAR PURPOSE. See the GNU General Public License for more
 * details.
 *
 * You should have received a copy of the GNU General Public License along with
 * this program. If not, see <http://www.gnu.org/licenses/>.
 */
package net.sf.l2j.gameserver.model.actor.instance;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.Map;

import net.sf.l2j.commons.lang.StringUtil;

import net.sf.l2j.L2DatabaseFactory;
import net.sf.l2j.gameserver.datatables.ItemTable;
import net.sf.l2j.gameserver.idfactory.IdFactory;
import net.sf.l2j.gameserver.l2spike.auction.AuctionItem;
import net.sf.l2j.gameserver.l2spike.datatables.AuctionTable;
import net.sf.l2j.gameserver.l2spike.datatables.IconTable;
import net.sf.l2j.gameserver.model.World;
import net.sf.l2j.gameserver.model.actor.template.NpcTemplate;
import net.sf.l2j.gameserver.model.item.instance.ItemInstance;
import net.sf.l2j.gameserver.network.serverpackets.InventoryUpdate;
import net.sf.l2j.gameserver.network.serverpackets.NpcHtmlMessage;

/**
 * @author Anarchy
 *
 */
public class L2AuctionManagerInstance extends L2NpcInstance
{
	public L2AuctionManagerInstance(int objectId, NpcTemplate template)
	{
		super(objectId, template);
	}

	@Override
	public void onBypassFeedback(L2PcInstance player, String command)
	{
		if (command.startsWith("auction"))
		{
			try
			{
				String[] data = command.substring(8).split(" - ");
				int page = Integer.parseInt(data[0]);
				String search = data[1];
				showAuction(player, page, search);
			}
			catch (Exception e)
			{
				showChatWindow(player);
				player.sendMessage("Invalid input. Please try again.");
				return;
			}
		}
		else if (command.startsWith("buy"))
		{
			int auctionId = Integer.parseInt(command.substring(4));
			AuctionItem item = AuctionTable.getInstance().getItem(auctionId);

			if (item == null)
			{
				showChatWindow(player);
				player.sendMessage("Invalid choice. Please try again.");
				return;
			}

			if (player.getInventory().getItemByItemId(item.getCostId()) == null || player.getInventory().getItemByItemId(item.getCostId()).getCount() < item.getCostCount())
			{
				showChatWindow(player);
				player.sendMessage("Incorrect item count.");
				return;
			}

			player.destroyItemByItemId("auction", item.getCostId(), item.getCostCount(), this, true);

			L2PcInstance owner = World.getInstance().getPlayer(item.getOwnerId());
			if (owner != null && owner.isOnline())
			{
				owner.addItem("auction", item.getCostId(), item.getCostCount(), null, true);
				owner.sendMessage("You have sold an item in the Auction Shop.");
			}
			else
			{
				addItemToOffline(item.getOwnerId(), item.getCostId(), item.getCostCount());
			}

			ItemInstance i = player.addItem("auction", item.getItemId(), item.getCount(), this, true);
			i.setEnchantLevel(item.getEnchant());
			player.sendPacket(new InventoryUpdate());
			player.sendMessage("You have purchased an item from the Auction Shop.");

			AuctionTable.getInstance().deleteItem(item);

			showChatWindow(player);
		}
		else if (command.startsWith("addpanel"))
		{
			int page = Integer.parseInt(command.substring(9));

			showAddPanel(player, page);
		}
		else if (command.startsWith("additem"))
		{
			int itemId = Integer.parseInt(command.substring(8));

			if (player.getInventory().getItemByObjectId(itemId) == null)
			{
				showChatWindow(player);
				player.sendMessage("Invalid item. Please try again.");
				return;
			}

			showAddPanel2(player, itemId);
		}
		else if (command.startsWith("addit2"))
		{
			try
			{
				String[] data = command.substring(7).split(" ");
				int itemId = Integer.parseInt(data[0]);
				String costitemtype = data[1];
				int costCount = Integer.parseInt(data[2]);
				int itemAmount = Integer.parseInt(data[3]);

				if (player.getInventory().getItemByObjectId(itemId) == null)
				{
					showChatWindow(player);
					player.sendMessage("Invalid item. Please try again.");
					return;
				}
				if (player.getInventory().getItemByObjectId(itemId).getCount() < itemAmount)
				{
					showChatWindow(player);
					player.sendMessage("Invalid item. Please try again.");
					return;
				}
				if (!player.getInventory().getItemByObjectId(itemId).isTradable())
				{
					showChatWindow(player);
					player.sendMessage("Invalid item. Please try again.");
					return;
				}

				int costId = 0;
				if (costitemtype.equals("Adena"))
				{
					costId = 57;
				}

				AuctionTable.getInstance().addItem(new AuctionItem(AuctionTable.getInstance().getNextAuctionId(), player.getObjectId(), player.getInventory().getItemByObjectId(itemId).getItemId(), itemAmount, player.getInventory().getItemByObjectId(itemId).getEnchantLevel(), costId, costCount));

				player.destroyItem("auction", itemId, itemAmount, this, true);
				player.sendPacket(new InventoryUpdate());
				player.sendMessage("You have added an item for sale in the Auction Shop.");
				showChatWindow(player);
			}
			catch (Exception e)
			{
				showChatWindow(player);
				player.sendMessage("Invalid input. Please try again.");
				return;
			}
		}
		else if (command.startsWith("myitems"))
		{
			int page = Integer.parseInt(command.substring(8));
			showMyItems(player, page);
		}
		else if (command.startsWith("remove"))
		{
			int auctionId = Integer.parseInt(command.substring(7));
			AuctionItem item = AuctionTable.getInstance().getItem(auctionId);

			if (item == null)
			{
				showChatWindow(player);
				player.sendMessage("Invalid choice. Please try again.");
				return;
			}

			AuctionTable.getInstance().deleteItem(item);

			ItemInstance i = player.addItem("auction", item.getItemId(), item.getCount(), this, true);
			i.setEnchantLevel(item.getEnchant());
			player.sendPacket(new InventoryUpdate());
			player.sendMessage("You have removed an item from the Auction Shop.");
			showChatWindow(player);
		}
		else
		{
			super.onBypassFeedback(player, command);
		}
	}

	private void showMyItems(L2PcInstance player, int page)
	{
		HashMap<Integer, ArrayList<AuctionItem>> items = new HashMap<>();
		int curr = 1;
		int counter = 0;

		ArrayList<AuctionItem> temp = new ArrayList<>();
		for (Map.Entry<Integer, AuctionItem> entry : AuctionTable.getInstance().getItems().entrySet())
		{
			if (entry.getValue().getOwnerId() == player.getObjectId())
			{
				temp.add(entry.getValue());

				counter++;

				if (counter == 10)
				{
					items.put(curr, temp);
					temp = new ArrayList<>();
					curr++;
					counter = 0;
				}
			}
		}
		items.put(curr, temp);

		if (!items.containsKey(page))
		{
			showChatWindow(player);
			player.sendMessage("Invalid page. Please try again.");
			return;
		}

		String html = "";
		html += "<html><title>Auction Shop</title><body><center><br1>";
		html += "<table width=310 bgcolor=000000 border=1>";
		html += "<tr><td>Item</td><td>Cost</td><td></td></tr>";
		for (AuctionItem item : items.get(page))
		{
			html += "<tr>";
			html += "<td><img src=\""+IconTable.getInstance().getIcon(item.getItemId())+"\" width=32 height=32 align=center></td>";
			html += "<td>Item: "+(item.getEnchant() > 0 ? "+"+item.getEnchant()+" "+ItemTable.getInstance().getTemplate(item.getItemId()).getName()+" - "+item.getCount() : ItemTable.getInstance().getTemplate(item.getItemId()).getName()+" - "+item.getCount());
			html += "<br1>Cost: "+StringUtil.formatNumber(item.getCostCount())+" "+ItemTable.getInstance().getTemplate(item.getCostId()).getName();
			html += "</td>";
			html += "<td fixwidth=71><button value=\"Remove\" action=\"bypass -h npc_"+getObjectId()+"_remove "+item.getAuctionId()+"\" width=70 height=21 back=\"L2UI.DefaultButton_click\" fore=\"L2UI.DefaultButton\">";
			html += "</td></tr>";
		}
		html += "</table><br><br>";

		html += "Page: "+page;
		html += "<br1>";

		if (items.keySet().size() > 1)
		{
			if (page > 1)
				html += "<a action=\"bypass -h npc_"+getObjectId()+"_myitems "+(page-1)+"\"><- Prev</a>";

			if (items.keySet().size() > page)
				html += "<a action=\"bypass -h npc_"+getObjectId()+"_myitems "+(page+1)+"\">Next -></a>";
		}

		html += "</center></body></html>";

		NpcHtmlMessage htm = new NpcHtmlMessage(getObjectId());
		htm.setHtml(html);
		player.sendPacket(htm);
	}

	private void showAddPanel2(L2PcInstance player, int itemId)
	{
		ItemInstance item = player.getInventory().getItemByObjectId(itemId);

		String html = "";
		html += "<html><title>Auction Shop</title><body><center><br1>";
		html += "<img src=\""+IconTable.getInstance().getIcon(item.getItemId())+"\" width=32 height=32 align=center>";
		html += "Item: "+(item.getEnchantLevel() > 0 ? "+"+item.getEnchantLevel()+" "+item.getName() : item.getName());

		if (item.isStackable())
		{
			html += "<br>Set amount of items to sell:";
			html += "<edit var=amm type=number width=120 height=17>";
		}

		html += "<br>Select price:";
		html += "<br><combobox width=120 height=17 var=ebox list=Adena;>";
		html += "<br><edit var=count type=number width=120 height=17>";
		html += "<br><button value=\"Add item\" action=\"bypass -h npc_"+getObjectId()+"_addit2 "+itemId+" $ebox $count "+(item.isStackable() ? "$amm" : "1")+"\" width=70 height=21 back=\"L2UI.DefaultButton_click\" fore=\"L2UI.DefaultButton\">";
		html += "</center></body></html>";

		NpcHtmlMessage htm = new NpcHtmlMessage(getObjectId());
		htm.setHtml(html);
		player.sendPacket(htm);
	}

	private void showAddPanel(L2PcInstance player, int page)
	{
		HashMap<Integer, ArrayList<ItemInstance>> items = new HashMap<>();
		int curr = 1;
		int counter = 0;

		ArrayList<ItemInstance> temp = new ArrayList<>();
		for (ItemInstance item : player.getInventory().getItems())
		{
			if (item.getItemId() != 57 && item.isTradable())
			{
				temp.add(item);

				counter++;

				if (counter == 10)
				{
					items.put(curr, temp);
					temp = new ArrayList<>();
					curr++;
					counter = 0;
				}
			}
		}
		items.put(curr, temp);

		if (!items.containsKey(page))
		{
			showChatWindow(player);
			player.sendMessage("Invalid page. Please try again.");
			return;
		}

		String html = "";
		html += "<html><title>Auction Shop</title><body><center><br1>";
		html += "Select item:";
		html += "<br><table width=310 bgcolor=000000 border=1>";

		for (ItemInstance item : items.get(page))
		{
			html += "<tr>";
			html += "<td>";
			html += "<img src=\""+IconTable.getInstance().getIcon(item.getItemId())+"\" width=32 height=32 align=center></td>";
			html += "<td>"+(item.getEnchantLevel() > 0 ? "+"+item.getEnchantLevel()+" "+item.getName() : item.getName());
			html += "</td>";
			html += "<td><button value=\"Select\" action=\"bypass -h npc_"+getObjectId()+"_additem "+item.getObjectId()+"\" width=70 height=21 back=\"L2UI.DefaultButton_click\" fore=\"L2UI.DefaultButton\">";
			html += "</td>";
			html += "</tr>";
		}
		html += "</table><br><br>";

		html += "Page: "+page;
		html += "<br1>";

		if (items.keySet().size() > 1)
		{
			if (page > 1)
				html += "<a action=\"bypass -h npc_"+getObjectId()+"_addpanel "+(page-1)+"\"><- Prev</a>";

			if (items.keySet().size() > page)
				html += "<a action=\"bypass -h npc_"+getObjectId()+"_addpanel "+(page+1)+"\">Next -></a>";
		}

		html += "</center></body></html>";

		NpcHtmlMessage htm = new NpcHtmlMessage(getObjectId());
		htm.setHtml(html);
		player.sendPacket(htm);
	}

	@SuppressWarnings("resource")
	private static void addItemToOffline(int playerId, int itemId, int count)
	{
		try (Connection con = L2DatabaseFactory.getInstance().getConnection())
		{
			PreparedStatement stm = con.prepareStatement("SELECT count FROM items WHERE owner_id=? AND item_id=?");
			stm.setInt(1, playerId);
			stm.setInt(2, itemId);
			ResultSet rset = stm.executeQuery();

			if (rset.next())
			{
				stm = con.prepareStatement("UPDATE items SET count=? WHERE owner_id=? AND item_id=?");
				stm.setInt(1, rset.getInt("count") + count);
				stm.setInt(2, playerId);
				stm.setInt(3, itemId);

				stm.execute();
			}
			else
			{
				stm = con.prepareStatement("INSERT INTO items VALUES (?,?,?,?,?,?,?,?,?,?,?,?)");
				stm.setInt(1, playerId);
				stm.setInt(2, IdFactory.getInstance().getNextId());
				stm.setInt(3, itemId);
				stm.setInt(4, count);
				stm.setInt(5, 0);
				stm.setString(6, "INVENTORY");
				stm.setInt(7, 0);
				stm.setInt(8, 0);
				stm.setInt(9, 0);
				stm.setInt(10, 0);
				stm.setInt(11, -1);
				stm.setInt(12, 0);

				stm.execute();
			}

			rset.close();
			stm.close();
		}
		catch (Exception e)
		{
			e.printStackTrace();
		}
	}

	private void showAuction(L2PcInstance player, int page, String search)
	{
		boolean src = !search.equals("*null*");

		HashMap<Integer, ArrayList<AuctionItem>> items = new HashMap<>();
		int curr = 1;
		int counter = 0;

		ArrayList<AuctionItem> temp = new ArrayList<>();
		for (Map.Entry<Integer, AuctionItem> entry : AuctionTable.getInstance().getItems().entrySet())
		{
			if (entry.getValue().getOwnerId() != player.getObjectId() && (!src || (src && ItemTable.getInstance().getTemplate(entry.getValue().getItemId()).getName().contains(search))))
			{
				temp.add(entry.getValue());

				counter++;

				if (counter == 10)
				{
					items.put(curr, temp);
					temp = new ArrayList<>();
					curr++;
					counter = 0;
				}
			}
		}
		items.put(curr, temp);

		if (!items.containsKey(page))
		{
			showChatWindow(player);
			player.sendMessage("Invalid page. Please try again.");
			return;
		}

		String html = "<html><title>Auction Shop</title><body><center><br1>";
		html += "<multiedit var=srch width=150 height=20><br1>";
		html += "<button value=\"Search\" action=\"bypass -h npc_"+getObjectId()+"_auction 1 - $srch\" width=70 height=21 back=\"L2UI.DefaultButton_click\" fore=\"L2UI.DefaultButton\">";
		html += "<br><table width=310 bgcolor=000000 border=1>";
		html += "<tr><td>Item</td><td>Cost</td><td></td></tr>";
		for (AuctionItem item : items.get(page))
		{
			html += "<tr>";
			html += "<td><img src=\""+IconTable.getInstance().getIcon(item.getItemId())+"\" width=32 height=32 align=center></td>";
			html += "<td>Item: "+(item.getEnchant() > 0 ? "+"+item.getEnchant()+" "+ItemTable.getInstance().getTemplate(item.getItemId()).getName()+" - "+item.getCount() : ItemTable.getInstance().getTemplate(item.getItemId()).getName()+" - "+item.getCount());
			html += "<br1>Cost: "+StringUtil.formatNumber(item.getCostCount())+" "+ItemTable.getInstance().getTemplate(item.getCostId()).getName();
			html += "</td>";
			html += "<td fixwidth=71><button value=\"Buy\" action=\"bypass -h npc_"+getObjectId()+"_buy "+item.getAuctionId()+"\" width=70 height=21 back=\"L2UI.DefaultButton_click\" fore=\"L2UI.DefaultButton\">";
			html += "</td></tr>";
		}
		html += "</table><br><br>";

		html += "Page: "+page;
		html += "<br1>";

		if (items.keySet().size() > 1)
		{
			if (page > 1)
				html += "<a action=\"bypass -h npc_"+getObjectId()+"_auction "+(page-1)+" - "+search+"\"><- Prev</a>";

			if (items.keySet().size() > page)
				html += "<a action=\"bypass -h npc_"+getObjectId()+"_auction "+(page+1)+" - "+search+"\">Next -></a>";
		}

		html += "</center></body></html>";

		NpcHtmlMessage htm = new NpcHtmlMessage(getObjectId());
		htm.setHtml(html);
		player.sendPacket(htm);
	}

    @Override
	public String getHtmlPath(int npcId, int val)
    {
        String pom = "";
        if (val == 0)
            pom = "" + npcId;
        else
            pom = npcId + "-" + val;

        return "data/html/l2spike/auction/" + pom + ".htm";
    }
}