import javax.swing.*;
import java.awt.*;
import java.util.*;
import java.awt.event.*;
import java.io.*;
import java.sql.*;

public class Auction_GUI extends JFrame implements ActionListener
{

	JTabbedPane tp;
	JPanel pnlTraders, pnlAuctioneerss, pnlAuction;

	JMenuBar mBar;
	JMenu fileMenu;
	JMenuItem saveItem;
	JMenuItem loadItem;
	JMenuItem exit;

	JTable traders_table, t_table;

	ArrayList<Trader> traders;

	String[] columns = {"Name", "Money", "Artwork", "Type", "Artist", "Style", "Year"};
	Object[][] cells;

	String[] acolumns = {"Trader Name", "Art Work Name", "Type", "Artist", "Style", "Year"};
	Object[][] acells = new Object[100][];

	JList traderList, artworkList;
	DefaultListModel traderModel;
	DefaultListModel artworkModel;
	JScrollPane scroller, scroller2;
	JButton btnAdd, btnAdd2;

	int count = 0;
	int count2 = 0;


	public Auction_GUI()
	{

		populateData();
		displayTradersTab();
		displayAuctioneerssTab();
		displayGUI();
		fileMenu();

		pnlTraders = new JPanel();
		pnlAuctioneerss = new JPanel();
		pnlAuction = new JPanel();

		//JTable traders_table = new JTable(cells, columns);
		tp = new JTabbedPane();

		tp.addTab("Traders", pnlTraders);
		tp.addTab("Auctioneers", pnlAuctioneerss);
		tp.addTab("Auction", pnlAuction);

		add(tp, BorderLayout.CENTER);

		traders_table = new JTable(cells, columns);
		JScrollPane scroll = new JScrollPane(traders_table);
		pnlTraders.add(scroll);


		pnlAuctioneerss.add(traderList);
		pnlAuctioneerss.add(btnAdd);
		pnlAuctioneerss.add(artworkList);
		pnlAuctioneerss.add(btnAdd2);
		pnlAuctioneerss.add(scroller, BorderLayout.SOUTH);
	}

	public void populateData()
	{
		//create the ArrayList
		traders = new ArrayList<Trader>();

		try
		{
			Class.forName("com.mysql.jdbc.Driver");
			Connection conn = DriverManager.getConnection(
					"jdbc:mysql://localhost:3306/auction", "root", "");

			Statement stat = conn.createStatement();

			ResultSet results = stat.executeQuery("Select trader.trader_name, trader.trader_money, artwork_name, artwork_type, artwork_artist, artwork_style, artwork_year	FROM trader INNER JOIN traderartwork ON trader.trader_id = traderartwork.trader_id JOIN artwork	ON traderartwork.artwork_id = artwork.artwork_id");

			while(results.next())
			{
				Trader t = new Trader(results.getString(1), (Integer)(results.getObject(2)), results.getString(3), results.getString(4), results.getString(5), results.getString(6), (Integer)(results.getObject(7)));

				traders.add(t);
			}

			stat.close();
			conn.close();
		}

		catch (Exception e)
		{
			e.printStackTrace();
		}

		cells = new Object[traders.size()][];

		for(Trader trader: traders)
		{
			Object[] row = {trader.getTrader_name(), trader.getTrader_money(), trader.getArtwork_name(), trader.getArtwork_type(), trader.getArtwork_artist(), trader.getArtwork_style(), trader.getArtwork_year()};

			cells[count++] = row;
		}
	}

	public void displayTradersTab()
	{

	}

	public void displayAuctioneerssTab()
	{
		traderModel = new DefaultListModel();
		artworkModel = new DefaultListModel();
		for(Trader trader: traders)
		{
			traderModel.addElement(trader.getTrader_name());
		}

		btnAdd = new JButton(">>");
		btnAdd.addActionListener(this);

		artworkModel.addElement("             ");
		artworkList = new JList(artworkModel);

		traderList = new JList(traderModel);

		for(int i=0;i<100;i++)
		{
			Object[] row = {"    ", "    ", " ", " ", " ", " "};
			acells[i] = row;
		}
		JTable t_table = new JTable(acells, acolumns);

		scroller = new JScrollPane(t_table);

		btnAdd2 = new JButton(">>>");
		btnAdd2.addActionListener(this);
	}

	public void actionPerformed(ActionEvent e)
	{
		if(e.getSource() == btnAdd)
		{
			int[] indices = traderList.getSelectedIndices();
			for(int i=0; i<indices.length; i++)
			{
				String name = (String)traderModel.getElementAt(indices[i]);

				for(Trader trader: traders)
				{
					if(trader.getTrader_name().equals(name))
					{
						artworkModel.addElement(trader.getArtwork_name());
					}
				}
			}
		}

		if(e.getSource() == btnAdd2)
		{
			int[] indices = artworkList.getSelectedIndices();
			for(int i=0;i<indices.length;i++)
			{
				String name = (String)artworkModel.getElementAt(indices[i]);
				for(Trader trader: traders)
				{

						if(trader.getArtwork_name().equals(name))
						{
							Object[] row = {trader.getTrader_name(), trader.getArtwork_name(), trader.getArtwork_type(), trader.getArtwork_artist(), trader.getArtwork_style(), trader.getArtwork_year()};
							acells[count2++] = row;
						}
				}
			}
			repaint();
		}
	}
	public void fileMenu()
	{
		mBar = new JMenuBar();
		fileMenu = new JMenu("File");
		mBar.add(fileMenu);
		setJMenuBar(mBar);
		saveItem = new JMenuItem("Save");
		fileMenu.add(saveItem);
		//saveItem.addActionListener(this);
		loadItem = new JMenuItem("Load");
		fileMenu.add(loadItem);
		//loadItem.addActionListener(this);
		exit = new JMenuItem("Exit");
		fileMenu.add(exit);
		//exit.addActionListener(this);
	}

	public void displayGUI()
	{
		setSize(600, 400);
		setDefaultCloseOperation(EXIT_ON_CLOSE);
		setVisible(true);
	}

	public static void main(String args[])
	{
		new Auction_GUI();
	}

}