package internalFrame.jiBenXinXi;
import java.awt.Font;
import java.awt.GridBagConstraints;
import java.awt.GridBagLayout;
import java.awt.Insets;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.util.Iterator;
import java.util.List;
import java.util.Vector;

import javax.swing.DefaultComboBoxModel;
import javax.swing.JButton;
import javax.swing.JComboBox;
import javax.swing.JInternalFrame;
import javax.swing.JLabel;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.JTextField;
import javax.swing.table.DefaultTableModel;

import model.TabSpinfo;

import org.springframework.beans.BeansException;
import org.springframework.context.ApplicationContext;
import org.springframework.context.ApplicationContextAware;

import dao.UserDAO;

public class ShangPinChaXun extends JInternalFrame implements ApplicationContextAware{
	private JTable table;

	private JTextField conditionContent;

	private JComboBox conditionOperation;

	private JComboBox conditionName;
	private UserDAO dao;
	private ApplicationContext appContext;

	public void setApplicationContext(ApplicationContext app) throws BeansException {
		appContext=app;
		dao = (UserDAO) appContext.getBean("DAOProxyTransactionFactory");
	}

	public ShangPinChaXun() {
		super();
		setMaximizable(true);
		setIconifiable(true);
		setClosable(true);
		setTitle("商品信息查詢");
		getContentPane().setLayout(new GridBagLayout());
		setBounds(100, 100, 609, 375);

		final JScrollPane scrollPane = new JScrollPane();
		final GridBagConstraints gridBagConstraints_6 = new GridBagConstraints();
		gridBagConstraints_6.weighty = 1.0;
		gridBagConstraints_6.anchor = GridBagConstraints.NORTH;
		gridBagConstraints_6.insets = new Insets(0, 10, 0, 10);
		gridBagConstraints_6.fill = GridBagConstraints.BOTH;
		gridBagConstraints_6.gridwidth = 6;
		gridBagConstraints_6.gridy = 1;
		gridBagConstraints_6.gridx = 0;
		getContentPane().add(scrollPane, gridBagConstraints_6);

		table = new JTable();
		table.setEnabled(false);
		table.setAutoResizeMode(JTable.AUTO_RESIZE_OFF);
		table.setShowGrid(true);
		table.putClientProperty("Quaqua.Table.style", "striped");
		final DefaultTableModel dftm = (DefaultTableModel) table.getModel();
		String[] tableHeads = new String[] { "客戶ID", "商品名稱", "簡稱", "產地", "單位",
				"規格", "包裝", "批號", "批準文號", "供應商全稱", "備注", };
		dftm.setColumnIdentifiers(tableHeads);
		scrollPane.setViewportView(table);

		final JLabel label = new JLabel();
		label.setFont(new Font("", Font.PLAIN, 14));
		label.setText(" 選擇查詢條件：");
		final GridBagConstraints gridBagConstraints = new GridBagConstraints();
		gridBagConstraints.gridy = 0;
		gridBagConstraints.gridx = 0;
		getContentPane().add(label, gridBagConstraints);

		conditionName = new JComboBox();
		conditionName.setModel(new DefaultComboBoxModel(new String[] { "商品名稱",
				"供應商全稱", "產地", "規格" }));
		conditionName.setFont(new Font("", Font.PLAIN, 14));
		final GridBagConstraints gridBagConstraints_1 = new GridBagConstraints();
		gridBagConstraints_1.gridy = 0;
		gridBagConstraints_1.gridx = 1;
		getContentPane().add(conditionName, gridBagConstraints_1);

		conditionOperation = new JComboBox();
		conditionOperation.setModel(new DefaultComboBoxModel(new String[] {
				"等于", "包含" }));
		conditionOperation.setFont(new Font("", Font.PLAIN, 14));
		final GridBagConstraints gridBagConstraints_2 = new GridBagConstraints();
		gridBagConstraints_2.gridy = 0;
		gridBagConstraints_2.gridx = 2;
		getContentPane().add(conditionOperation, gridBagConstraints_2);

		conditionContent = new JTextField();
		conditionContent.setFont(new Font("", Font.PLAIN, 14));
		final GridBagConstraints gridBagConstraints_3 = new GridBagConstraints();
		gridBagConstraints_3.ipadx = 105;
		gridBagConstraints_3.insets = new Insets(0, 10, 0, 10);
		gridBagConstraints_3.fill = GridBagConstraints.HORIZONTAL;
		gridBagConstraints_3.weightx = 1.0;
		gridBagConstraints_3.gridy = 0;
		gridBagConstraints_3.gridx = 3;
		getContentPane().add(conditionContent, gridBagConstraints_3);

		final JButton queryButton = new JButton();
		queryButton.addActionListener(new ActionListener() {
			public void actionPerformed(final ActionEvent e) {
				String conName, conOperation, content;
				conName = conditionName.getSelectedItem().toString().trim();
				conOperation = conditionOperation.getSelectedItem().toString();
				content = conditionContent.getText().trim();
				List list = null;
				list = searchInfo(conName, conOperation, content, list);
				updateTable(list, dftm);
			}

			private List searchInfo(String conName, String conOperation, String content, List list) {
				if (conOperation.equals("等于")) {
					if (conName.equals("商品名稱"))
						list = dao
								.queryObject("from TabSpinfo where id.spname='"
										+ content + "'");
					if (conName.equals("供應商全稱"))
						list = dao
								.queryObject("from TabSpinfo where id.gysname='"
										+ content + "'");
					if (conName.equals("產地"))
						list = dao.queryObject("from TabSpinfo where id.cd='"
								+ content + "'");
					if (conName.equals("規格"))
						list = dao.queryObject("from TabSpinfo where id.gg='"
								+ content + "'");
				} else {
					if (conName.equals("商品名稱"))
						list = dao
								.queryObject("from TabSpinfo where id.spname like '%"
										+ content + "%'");
					if (conName.equals("供應商全稱"))
						list = dao
								.queryObject("from TabSpinfo where id.gysname like '%"
										+ content + "%'");
					if (conName.equals("產地"))
						list = dao
								.queryObject("from TabSpinfo where id.cd like '%"
										+ content + "%'");
					if (conName.equals("規格"))
						list = dao
								.queryObject("from TabSpinfo where id.gg like '%"
										+ content + "%'");
				}
				return list;
			}
		});
		final GridBagConstraints gridBagConstraints_4 = new GridBagConstraints();
		gridBagConstraints_4.gridy = 0;
		gridBagConstraints_4.gridx = 4;
		getContentPane().add(queryButton, gridBagConstraints_4);
		queryButton.setFont(new Font("", Font.PLAIN, 12));
		queryButton.setText("查詢");

		final JButton showAllButton = new JButton();
		showAllButton.addActionListener(new ActionListener() {
			public void actionPerformed(final ActionEvent e) {
				conditionContent.setText("");
				List list = dao.queryObject("from TabSpinfo");
				updateTable(list, dftm);
			}
		});
		final GridBagConstraints gridBagConstraints_5 = new GridBagConstraints();
		gridBagConstraints_5.insets = new Insets(0, 0, 0, 10);
		gridBagConstraints_5.anchor = GridBagConstraints.WEST;
		gridBagConstraints_5.gridy = 0;
		gridBagConstraints_5.gridx = 5;
		getContentPane().add(showAllButton, gridBagConstraints_5);
		showAllButton.setFont(new Font("", Font.PLAIN, 12));
		showAllButton.setText("顯示全部數據");
	}

	private void updateTable(List list, final DefaultTableModel dftm) {
		int num = dftm.getRowCount();
		for (int i = 0; i < num; i++)
			dftm.removeRow(0);
		if (list == null)
			return;
		Iterator iterator = list.iterator();
		TabSpinfo spInfo;
		while (iterator.hasNext()) {
			spInfo = (TabSpinfo) iterator.next();
			Vector rowData = new Vector();
			rowData.add(spInfo.getId().trim());
			rowData.add(spInfo.getSpname().trim());
			rowData.add(spInfo.getJc().trim());
			rowData.add(spInfo.getCd().trim());
			rowData.add(spInfo.getDw().trim());
			rowData.add(spInfo.getGg().trim());
			rowData.add(spInfo.getBz().trim());
			rowData.add(spInfo.getPh().trim());
			rowData.add(spInfo.getPzwh().trim());
			rowData.add(spInfo.getGysname().trim());
			rowData.add(spInfo.getMemo().trim());
			dftm.addRow(rowData);
		}
	}
}