package 畢業設計;

import java.awt.*;
import java.util.Vector;
import javax.swing.*;
import javax.swing.JTable;
import javax.swing.border.TitledBorder;
import java.awt.event.ComponentEvent;
import java.awt.event.ComponentAdapter;
import javax.swing.table.JTableHeader;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import javax.swing.table.DefaultTableModel;
import java.awt.event.MouseEvent;
import java.awt.event.MouseAdapter;
import java.util.*;

public class frmRecord extends JFrame {
    JTable tblDisplay = new JTable();
    ButtonGroup buttonGroup1 = new ButtonGroup();
    DefaultTableModel dt;
    Vector vtColName = new Vector();
    boolean isnot;
    String[] column = {"編號", "讀者編號", "圖書編號", "圖書條形碼", "借書日期", "還書日期", "應還日期",
                      "操作人員"};
    JScrollPane jScrollPane1 = new JScrollPane();
    JLabel lblDisplay = new JLabel();
    JPanel jPanel1 = new JPanel();
    JButton btnExit = new JButton();
    public frmRecord() {
        try {
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    private void jbInit() throws Exception {
        getContentPane().setLayout(null);
        setSize(new Dimension(800, 600));
        this.setTitle("過期未還記錄");
        this.addComponentListener(new frmRecord_this_componentAdapter(this));
        tblDisplay.setBounds(new Rectangle(15, 100, 770, 450));
        jScrollPane1.setBounds(new Rectangle(15, 100, 770, 450));
        lblDisplay.setFont(new java.awt.Font("Dialog", Font.PLAIN, 36));
        lblDisplay.setText("過期未還書記錄表");
        lblDisplay.setBounds(new Rectangle(218, 23, 358, 50));
        jPanel1.setBounds(new Rectangle(3, 2, 795, 96));
        jPanel1.setLayout(null);
        btnExit.setBounds(new Rectangle(674, 28, 91, 37));
        btnExit.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
        btnExit.setText("關閉");
        btnExit.addActionListener(new frmRecord_btnExit_actionAdapter(this));
        this.getContentPane().add(jScrollPane1);
        this.getContentPane().add(jPanel1);
        jPanel1.add(lblDisplay);
        jPanel1.add(btnExit);
        jScrollPane1.getViewport().add(tblDisplay);
        DisplayAllRecord();
        tblDisplay.setAutoResizeMode(tblDisplay.AUTO_RESIZE_OFF);
        tblDisplay.getTableHeader().setReorderingAllowed(false);
    }

    //**************************顯示借出過期未還書記錄****************************
     public void DisplayAllRecord() {
         for (int i = 0; i < column.length; i++) {
             vtColName.add(column[i]);
         }
         Vector vt = new Vector();
         RecordConDB recordDB = new RecordConDB();
         Vector tempvt = new Vector();
         tempvt = recordDB.SearchLoanRecord();
         recordDB.CloseRecordDB();

         Calendar c = Calendar.getInstance();
         java.sql.Date dd = new java.sql.Date(c.getTimeInMillis());
         String NowTime;
         int year, month, day;
         NowTime = dd.toString();
         year = Integer.parseInt(NowTime.substring(0, 4));
         month = Integer.parseInt(NowTime.substring(5, NowTime.lastIndexOf("-")));
         day = Integer.parseInt(NowTime.substring(NowTime.lastIndexOf("-") + 1,
                                                  NowTime.length()));
         for (int i = 0; i < tempvt.size(); i++) {
             String RevertibleTime;
             int Ryear, Rmonth, Rday;
             RevertibleTime = ((Vector) (tempvt.get(i))).get(6).toString();

             Ryear = Integer.parseInt(RevertibleTime.substring(0, 4));
             Rmonth = Integer.parseInt(RevertibleTime.substring(5,
                     RevertibleTime.lastIndexOf("-")));
             Rday = Integer.parseInt(RevertibleTime.substring(NowTime.
                     lastIndexOf("-") + 1, RevertibleTime.length()));
             System.out.println(year+"-"+month+"-"+day+"\n"+Ryear+"-"+Rmonth+"-"+Rday+"\n");
             if ((year > Ryear) || (year == Ryear && month > Rmonth) ||
                 (year == Ryear && month == Rmonth && day > Rday)) {
                 vt.add(tempvt.get(i));
             }
         }
         dt = new DefaultTableModel(vt, vtColName);
         tblDisplay.setModel(dt);
     }
    //******************************顯示窗口********************************
     public void ShowRecord() {
         Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize();
         Dimension dlgSize = this.getSize();
         if (dlgSize.height > screenSize.height) {
             dlgSize.height = screenSize.height;
         }
         if (dlgSize.width > screenSize.width) {
             dlgSize.width = screenSize.width;
         }
         this.setLocation((screenSize.width - dlgSize.width) / 2,
                          (screenSize.height - dlgSize.height) / 2);
         this.setVisible(true);
     }

    //*****************************表格根隨窗口改變*********************************
     public void this_componentResized(ComponentEvent e) {
         jPanel1.setLocation((this.getWidth() - jPanel1.getWidth()) / 2, 0);
         jScrollPane1.setSize(this.getWidth() - 40,
                              this.getHeight() - jPanel1.getHeight() - 60);
         tblDisplay.setSize(jScrollPane1.getWidth(), jScrollPane1.getHeight());
     }

    //*****************************關閉按鈕事件*********************************
     public void btnExit_actionPerformed(ActionEvent e) {
         this.dispose();
     }
}


class frmRecord_this_componentAdapter extends ComponentAdapter {
    private frmRecord adaptee;
    frmRecord_this_componentAdapter(frmRecord adaptee) {
        this.adaptee = adaptee;
    }

    public void componentResized(ComponentEvent e) {
        adaptee.this_componentResized(e);
    }
}


class frmRecord_btnExit_actionAdapter implements ActionListener {
    private frmRecord adaptee;
    frmRecord_btnExit_actionAdapter(frmRecord adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.btnExit_actionPerformed(e);
    }
}