package project;

import java.awt.*;
import javax.swing.*;
import java.sql.*;
import javax.swing.table.JTableHeader;
import javax.swing.table.DefaultTableModel;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.io.*;
import java.io.BufferedWriter;
import javax.swing.text.JTextComponent;

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2007</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class Attendance_save_C
    extends JPanel implements All_view {

  JFrame mainframe = null;
  JButton outBtn = new JButton();
  JScrollPane jScrollPane1 = new JScrollPane();



  DataMap mp = null;
  Object[][] obj = null;
 String[] colnames = {"工號", "月份", "正常", "遲到","早退", "曠工"};
  DefaultTableModel dm = null;
  JTable jTable1 = null;
  JButton jButton1 = new JButton();
  JLabel jLabel1 = new JLabel();

  public Attendance_save_C(JFrame mainframe) {
  // closeCurrentPanel(mainframe);
    this.mainframe = mainframe;
    try {
      jbInit();
        setPanelPosOnDesktop(this.mainframe);
    }
    catch (Exception exception) {
      exception.printStackTrace();
    }
  }

  private void jbInit() throws Exception {
    this.setLayout(null);
    setSize(new Dimension(496, 407));
    outBtn.setBounds(new Rectangle(184, 300, 118, 40));
    outBtn.setForeground(new Color(85, 45, 25));
    outBtn.setText("導出數據為文本");
    outBtn.addActionListener(new Attendance_save_view_outBtn_actionAdapter(this));
    jScrollPane1.setBounds(new Rectangle(45, 85, 400, 180));
    jButton1.setText("jButton1");
    jLabel1.setFont(new java.awt.Font("幼圓", Font.BOLD, 20));
    jLabel1.setForeground(new Color(85, 45, 25));
    jLabel1.setText("導出所有考勤記錄");
    jLabel1.setBounds(new Rectangle(155, 22, 188, 43));
    DataBase db3 = new DataBase();
    String sql = "select * from attendance_table order by id,currmonth";
    ResultSet rs = db3.executeQuery(sql);
    mp = new DataMap(rs);

    obj = mp.get_DataMap_Array();
    dm = new DefaultTableModel(obj, colnames);
     jTable1 = new JTable(dm);
     this.add(jLabel1);
     this.add(outBtn);
    this.add(jScrollPane1);


    jScrollPane1.getViewport().add(jTable1);
    mainframe.getContentPane().add(jButton1);
  }


   public void setPanelPosOnDesktop(JFrame frame) {
     this.setLocation( (((Frame1)frame).get_Container_width()- this.getSize().width) / 2,
                     (((Frame1)frame).get_Container_height()- this.getSize().height) / 2);
     }

     public void closeCurrentPanel(JFrame frame) {
       ((Frame1)frame).remove_panel();
    frame.repaint();
     }

     public void set_focus() {

     }
     public void requestFocus(){
       set_focus();
     }


  public void outBtn_actionPerformed(ActionEvent e) {
    File file = new File("c:/1.txt");
   try {
     FileWriter fw = null;
     fw = new FileWriter(file);
     BufferedWriter bw = new BufferedWriter(fw);
     bw.write("工號"+"\t"+"月份"+"\t"+"\t"+"正常"+"\t"+"早退"+"\t"+"遲到"+"\t"+" 曠工");
     bw.newLine(); //換行
    String tmp=null;
     int m = mp.get_DataMap_column();
     int n = mp.get_DataMap_row();

     for (int mm = 0; mm < n; mm++) {
       for (int nn = 0; nn < m; nn++) {
         tmp = obj[mm][nn].toString()+"\t";
         bw.write(tmp);
       }
       bw.newLine(); //換行
     }
     bw.flush();
     bw.close();
     fw.close();
   JOptionPane.showMessageDialog(this,"文件已成功保存====>c:/1.txt","OK",1);
    }catch (IOException ex) {
    }


  }


}

class Attendance_save_view_outBtn_actionAdapter
    implements ActionListener {
  private Attendance_save_C adaptee;
  Attendance_save_view_outBtn_actionAdapter(Attendance_save_C adaptee) {
    this.adaptee = adaptee;
  }

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