package bookingsystem;

import java.awt.*;

import javax.swing.*;
import java.awt.Rectangle;
import com.borland.dbswing.TableScrollPane;
import com.borland.jbcl.layout.XYLayout;
import com.borland.jbcl.layout.*;
import javax.swing.table.DefaultTableModel;
import com.borland.dbswing.JdbTable;
import java.util.Vector;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.SQLException;
/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2007</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class PaybillFrame extends myFrame {
    public PaybillFrame(ResFrame r) {
        super();
        this.resFrame = r;
        try {
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    private void jbInit() throws Exception {
        this.setDefaultCloseOperation(JFrame.DO_NOTHING_ON_CLOSE);
        getContentPane().setLayout(null);
        jSplitPane1.setBounds(new Rectangle(10, 10, 491, 307));
        jButton1.setText("結帳");
        jButton1.addActionListener(new PaybillFrame_jButton1_actionAdapter(this));
        jPanel1.setLayout(xYLayout1);
        jButton2.setBounds(new Rectangle(423, 336, 69, 25));
        jButton2.setText("查詢");
        jButton2.addActionListener(new PaybillFrame_jButton2_actionAdapter(this));
        jButton3.setText("退出");
        jButton3.addActionListener(new PaybillFrame_jButton3_actionAdapter(this));
        jLabel1.setText("餐桌號");
        jLabel1.setBounds(new Rectangle(302, 335, 64, 27));
        jTextField1.setBounds(new Rectangle(342, 336, 68, 21));
        jButton4.setText("更新");
        jButton4.addActionListener(new PaybillFrame_jButton4_actionAdapter(this));
        this.getContentPane().add(jSplitPane1);
        jSplitPane1.add(jScrollPane1, JSplitPane.LEFT);
        jSplitPane1.add(jPanel1, JSplitPane.RIGHT);
        jPanel1.add(jButton1, new XYConstraints(8, 47, 69, -1));
        jScrollPane1.getViewport().add(tableScrollPane1);
        jPanel1.add(jButton3, new XYConstraints(8, 181, 69, -1));
        this.getContentPane().add(jButton2);
        this.getContentPane().add(jTextField1);
        this.getContentPane().add(jLabel1);
        tableScrollPane1.getViewport().add(jdbTable1);
        jPanel1.add(jButton4, new XYConstraints(8, 112, 69, -1));
        jSplitPane1.setDividerLocation(400);
        //顯示所有的用餐狀態的桌子
        querypaybill();
    }

    private ResFrame resFrame;
    JSplitPane jSplitPane1 = new JSplitPane();
    JScrollPane jScrollPane1 = new JScrollPane();
    TableScrollPane tableScrollPane1 = new TableScrollPane();
    JPanel jPanel1 = new JPanel();
    JButton jButton1 = new JButton();
    XYLayout xYLayout1 = new XYLayout();
    JButton jButton2 = new JButton();
    JButton jButton3 = new JButton();
    JLabel jLabel1 = new JLabel();
    JTextField jTextField1 = new JTextField();
     DefaultTableModel defaultTableModel ;
    JdbTable jdbTable1 = new JdbTable();
    JButton jButton4 = new JButton();
    public void querypaybill(){
         defaultTableModel = new DefaultTableModel();
          jdbTable1 = new JdbTable(defaultTableModel);
          tableScrollPane1.getViewport().add(jdbTable1);
          defaultTableModel.addColumn("餐桌編號");
          defaultTableModel.addColumn("餐桌狀態");


          Restaurant res = new Restaurant();
          String tempstate = "dining";
          Vector v = res.getdining(tempstate);
          for(int i=0;i<v.size();i++)
          {
              Table tab = (Table)v.get(i);
               Object[]data = new Object[2];
               data[0] = tab.gettalno();
               data[1] = tab.getState();
               defaultTableModel.addRow(data);
          }
          jdbTable1.setModel(defaultTableModel);

     }

    public void jButton1_actionPerformed(ActionEvent e) {
        int row = -1;

        row = jdbTable1.getSelectedRow();

        if(row<0)
       {
              JOptionPane.showMessageDialog(null, "操作有誤");
              return;
        }

     String talno = (String)jdbTable1.getValueAt(row,0);

     Connection cn = ConnectionDB.getCon();
     String updSql1 = "update T_TABLE set STATE=? where TALNO=?";
     String updSql2 = "UPDATE RESERVATION SET ISPAYBILL = "+true+" WHERE TALNO = '"+talno+"' and ISARRIVAL = TRUE";
     try {
                     PreparedStatement ps1 = cn.prepareStatement(updSql1);
                     ps1.setString(1,"free");
                     ps1.setString(2,talno);

                     ps1.executeUpdate();
                     PreparedStatement ps2 = cn.prepareStatement(updSql2);
                     ps2.executeUpdate();


             } catch (SQLException e1) {
                     e1.printStackTrace();
     }
       while(defaultTableModel.getRowCount()>0)
       {
           defaultTableModel.removeRow(0);
       }


        // querypaybill();
         //this.resFrame.btnDisplay_actionPerformed(e);
         this.jButton4_actionPerformed(e);
    }

    public void jButton4_actionPerformed(ActionEvent e) {
        querypaybill();
        this.resFrame.btnDisplay_actionPerformed(e);
    }
   //通過餐桌號來查詢
    public void jButton2_actionPerformed(ActionEvent e) {
    String talnotemp = (String)jTextField1.getText();
    defaultTableModel = new DefaultTableModel();
     jdbTable1 = new JdbTable(defaultTableModel);
     tableScrollPane1.getViewport().add(jdbTable1);
     defaultTableModel.addColumn("餐桌編號");
      defaultTableModel.addColumn("餐桌狀態");

      Vector v =new Vector();
      Connection cn=ConnectionDB.getCon();
      Statement st=null;
       ResultSet rs=null;
       try{
              String sql = "select * from T_TABLE where TALNO = '" + talnotemp + "'";
              st =cn.createStatement();
              rs = st.executeQuery(sql);
              while (rs.next())
              {
                  String temptalno = rs.getString("talno");
                  Table temptable = new Table(temptalno);
                  v.add(temptable);

              }
              }catch(SQLException e1)
              {
                  e1.printStackTrace();
              }

              for(int i=0;i<v.size();i++)
                 {
                     Table tab = (Table)v.get(i);
                      Object[]data = new Object[2];
                      data[0] = tab.gettalno();
                      data[1] = tab.getState();
                      defaultTableModel.addRow(data);
                 }
                 jdbTable1.setModel(defaultTableModel);







    }

    public void jButton3_actionPerformed(ActionEvent e) {
        this.resFrame.btnDisplay_actionPerformed(e);
        this.resFrame.setEnabled(true);
        this.dispose();
    }


}


class PaybillFrame_jButton3_actionAdapter implements ActionListener {
    private PaybillFrame adaptee;
    PaybillFrame_jButton3_actionAdapter(PaybillFrame adaptee) {
        this.adaptee = adaptee;
    }

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


class PaybillFrame_jButton2_actionAdapter implements ActionListener {
    private PaybillFrame adaptee;
    PaybillFrame_jButton2_actionAdapter(PaybillFrame adaptee) {
        this.adaptee = adaptee;
    }

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


class PaybillFrame_jButton4_actionAdapter implements ActionListener {
    private PaybillFrame adaptee;
    PaybillFrame_jButton4_actionAdapter(PaybillFrame adaptee) {
        this.adaptee = adaptee;
    }

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


class PaybillFrame_jButton1_actionAdapter implements ActionListener {
    private PaybillFrame adaptee;
    PaybillFrame_jButton1_actionAdapter(PaybillFrame adaptee) {
        this.adaptee = adaptee;
    }

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