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());
        //        java.sql.Time tt = new java.sql.Time(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(
                    "-"),
                    RevertibleTime.length()));
            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());
        //       jScrollPane1.setLocation((this.getWidth() - jScrollPane1.getWidth())/2,0);
//        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);
    }
}