package com.wsy.iframe;

import java.awt.BorderLayout;
import java.awt.Dimension;
import java.awt.FlowLayout;
import java.awt.GridLayout;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.KeyAdapter;
import java.awt.event.KeyEvent;
import java.awt.event.MouseAdapter;
import java.awt.event.MouseEvent;
import java.text.SimpleDateFormat;
import java.util.List;

import javax.swing.JButton;
import javax.swing.JInternalFrame;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JPanel;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.JTextField;
import javax.swing.Timer;
import javax.swing.border.TitledBorder;
import javax.swing.table.DefaultTableModel;

import com.wsy.JComPz.MapPz;
import com.wsy.dao.Dao;
import com.wsy.model.Back;
import com.wsy.model.BookType;
import com.wsy.model.Borrow;
import com.wsy.model.Operater;
import com.wsy.util.MyDocument;
public class BookBackIFrame extends JInternalFrame {
	private Operater user = BookLoginIFrame.getUser(); 
	private JTable table;
	private JTextField operator;
	private JTextField todaydate;
	private JTextField fkmoney;
	private JTextField ccdays;
	private JTextField realdays;
	private JTextField borrowdays;
	private JTextField borrowDate;
	private JTextField readerISBN;
	private String[] columnNames = { "圖書名稱", "圖書條形碼","圖書類別","讀者姓名","讀者條形碼","借書時間","歸還時間" };
	DefaultTableModel model = new DefaultTableModel();
	SimpleDateFormat myfmt=new SimpleDateFormat("yyyy-MM-dd hh:mm:ss");
	private String bookISBNs=null;
	private String readerISBNs=null;
	private int id;
	
	public final void add() {
		readerISBNs=readerISBN.getText().trim();
		List list=Dao.selectBookBack(readerISBNs);
		for(int i=0;i<list.size();i++){
			Back back=(Back)list.get(i);
		id=	back.getId();
			String str[] = new String[7];
			str[0] =back.getBookname();
			str[1] =back.getBookISBN();
			str[2]=String.valueOf(MapPz.getMap().get(back.getTypeId()+""));
			str[3] =back.getReaderName();
			str[4] =back.getReaderISBN();
			str[5] =back.getBorrowDate();
			str[6]=back.getBackDate();
			model.addRow(str);
		}

	}
	
	/**
	 * Create the frame
	 */
	public BookBackIFrame() {
		super();
		setIconifiable(true);							// 設置窗體可最小化－－－必須
		setClosable(true);								// 設置窗體可關閉－－－必須
		setTitle("圖書歸還管理");
		setBounds(100, 100, 550, 480);

		final JPanel panel = new JPanel();
		panel.setBorder(new TitledBorder(null, "基本信息", TitledBorder.DEFAULT_JUSTIFICATION, TitledBorder.DEFAULT_POSITION, null, null));
		panel.setPreferredSize(new Dimension(0, 200));
		getContentPane().add(panel, BorderLayout.NORTH);

		final JPanel panel_5 = new JPanel();
		final GridLayout gridLayout_1 = new GridLayout(0, 2);
		gridLayout_1.setVgap(5);
		panel_5.setLayout(gridLayout_1);
		panel_5.setPreferredSize(new Dimension(400, 20));
		panel.add(panel_5);

		final JLabel label_4 = new JLabel();
		label_4.setText("讀者編號：");
		panel_5.add(label_4);

		readerISBN = new JTextField();
		readerISBN.setDocument(new MyDocument(13));
		readerISBN.addKeyListener(new readerISBNListenerlostFocus());
		panel_5.add(readerISBN);

		final JPanel panel_4 = new JPanel();
		panel_4.setLayout(new FlowLayout());
		panel_4.setPreferredSize(new Dimension(450, 130));
		panel.add(panel_4);

		final JScrollPane scrollPane = new JScrollPane();
		scrollPane.setPreferredSize(new Dimension(450, 120));
		panel_4.add(scrollPane);

		table = new JTable();
		scrollPane.setViewportView(table);
		model.setColumnIdentifiers(columnNames);
		table.setModel(model);
		table.addMouseListener(new TableListener());
		

		final JPanel panel_1 = new JPanel();
		getContentPane().add(panel_1);

		final JPanel panel_2 = new JPanel();
		final GridLayout gridLayout_2 = new GridLayout(0, 2);
		gridLayout_2.setVgap(20);
		panel_2.setLayout(gridLayout_2);
		panel_2.setBorder(new TitledBorder(null, "罰款信息", TitledBorder.DEFAULT_JUSTIFICATION, TitledBorder.DEFAULT_POSITION, null, null));
		panel_2.setPreferredSize(new Dimension(250, 230));
		panel_1.add(panel_2);

		final JLabel label_11 = new JLabel();
		label_11.setText("借書日期：");
		panel_2.add(label_11);

		borrowDate = new JTextField();
		borrowDate.setEditable(false);

		panel_2.add(borrowDate);

		final JLabel label_12 = new JLabel();
		label_12.setText("規定天數：");
		panel_2.add(label_12);

		borrowdays = new JTextField();
		borrowdays.setEditable(false);
		panel_2.add(borrowdays);

		final JLabel label_13 = new JLabel();
		label_13.setText("實際天數：");
		panel_2.add(label_13);

		realdays = new JTextField();
		realdays.setEditable(false);
		panel_2.add(realdays);

		final JLabel label_14 = new JLabel();
		label_14.setText("超出天數：");
		panel_2.add(label_14);

		ccdays = new JTextField();
		ccdays.setEditable(false);
		panel_2.add(ccdays);

		final JLabel label_15 = new JLabel();
		label_15.setText("罰款金額：");
		panel_2.add(label_15);

		fkmoney = new JTextField();
		fkmoney.setEditable(false);
		panel_2.add(fkmoney);

		final JPanel panel_3 = new JPanel();
		panel_3.setBorder(new TitledBorder(null, "系統信息", TitledBorder.DEFAULT_JUSTIFICATION, TitledBorder.DEFAULT_POSITION, null, null));
		panel_3.setPreferredSize(new Dimension(280, 230));
		panel_1.add(panel_3);

		final JPanel panel_7 = new JPanel();
		final GridLayout gridLayout_3 = new GridLayout(0, 2);
		gridLayout_3.setVgap(35);
		panel_7.setLayout(gridLayout_3);
		panel_7.setPreferredSize(new Dimension(260, 90));
		panel_3.add(panel_7);

		final JLabel label_10_1 = new JLabel();
		label_10_1.setText("當前時間：");
		panel_7.add(label_10_1);

		todaydate = new JTextField();
		todaydate.setEditable(false);
		todaydate.setPreferredSize(new Dimension(0, 0));
		todaydate.addActionListener(new TimeActionListener());
		todaydate.setFocusable(false);
		panel_7.add(todaydate);

		final JLabel label_11_1 = new JLabel();
		label_11_1.setText("操作員：");
		panel_7.add(label_11_1);

		operator  =new JTextField(user.getName());
		operator.setEditable(false);
		panel_7.add(operator);

		final JButton buttonback = new JButton();
		buttonback.setText("圖書歸還");
		buttonback.addActionListener(new BookBackActionListener(model));
		panel_3.add(buttonback);




		final JButton buttonExit= new JButton();
		buttonExit.setText("退出");
		buttonExit.addActionListener(new CloseActionListener());
		panel_3.add(buttonExit);
		setVisible(true);
		//
	}
	class readerISBNListenerlostFocus extends KeyAdapter{
		public void keyTyped(KeyEvent e) {
			if (e.getKeyChar() == '\n') { // 判斷在文本框是否輸入回車。
				add();
			}
		}
	}
	class TimeActionListener implements ActionListener{
		public TimeActionListener(){
			Timer t=new Timer(1000,this);
			t.start();
		}
		public void actionPerformed(ActionEvent ae){
			todaydate.setText(myfmt.format(new java.util.Date()).toString());
		}
	}
	class TableListener extends MouseAdapter {
		public void mouseClicked(final MouseEvent e) {
			
			java.util.Date date=new java.util.Date();
			String fk="";
			String days1="";
			int selRow=table.getSelectedRow();
			List list =Dao.selectBookTypeFk(table.getValueAt(selRow, 2).toString().trim());
			for(int i=0;i<list.size();i++){
				BookType booktype=(BookType)list.get(i);
				fk=booktype.getFk();
				days1=booktype.getDays();
			}
			borrowDate.setText(table.getValueAt(selRow, 5).toString().trim());
			int days2,days3;
			//days1=java.sql.Timestamp.valueOf(table.getValueAt(selRow, 6).toString().trim()).getDate()-java.sql.Timestamp.valueOf(table.getValueAt(selRow, 5).toString().trim()).getDate();
			borrowdays.setText(days1+"");
			days2=date.getDate()-java.sql.Timestamp.valueOf(table.getValueAt(selRow, 5).toString().trim()).getDate();
			realdays.setText(days2+"");
			days3=days2-Integer.parseInt(days1);
			if(days3>0){
				ccdays.setText(days3+"");
				Double zfk=Double.valueOf(fk)*days3;
				fkmoney.setText(zfk+"元");
			}
			else{
				ccdays.setText("沒有超過規定天數");
				fkmoney.setText("0");
			}
			bookISBNs=table.getValueAt(selRow, 1).toString().trim();
		}
	}
	class BookBackActionListener implements ActionListener{
		private final DefaultTableModel model;

		BookBackActionListener(DefaultTableModel model) {
			this.model = model;
		}
		public void actionPerformed(ActionEvent e) {
			// TODO 自動生成方法存根
			if(readerISBNs==null){
				JOptionPane.showMessageDialog(null, "請輸入讀者編號！");
				return;
			}
			System.out.println(bookISBNs==null);

			if(table.getSelectedRow()==-1){
				JOptionPane.showMessageDialog(null, "請選擇所要歸還的圖書！");
				return;	
			}

		
			int i=Dao.UpdateBookBack(bookISBNs, readerISBNs,id);
			System.out.print(i);
			 if(i==1){	
				int selectedRow = table.getSelectedRow();
				model.removeRow(selectedRow);
				JOptionPane.showMessageDialog(null, "還書操作完成！");		
			}
		}
	}
	class CloseActionListener implements ActionListener {			// 添加關閉按鈕的事件監聽器
		public void actionPerformed(final ActionEvent e) {
			doDefaultCloseAction();
		}
	}
}