package bookingsystem;

import java.awt.*;

import javax.swing.*;

import com.borland.jbcl.layout.*;
import javax.swing.BorderFactory;
import java.awt.event.MouseEvent;
import java.awt.event.MouseAdapter;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.Connection;
import java.sql.SQLException;
import java.util.*;
import java.awt.Rectangle;

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2007</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class ResFrame extends myFrame {
    public ResFrame() {
        super();
        try {
            jbInit();
        } catch (Exception ex) {
            ex.printStackTrace();
        }

    }

    private void jbInit() throws Exception {
        this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
        this.getContentPane().setLayout(xYLayout1);
        xYLayout1.setWidth(1000);
        xYLayout1.setHeight(720);
        btnPanel.setBorder(BorderFactory.createEtchedBorder());
        infoPanel.setBorder(BorderFactory.createEtchedBorder());
        infoPanel.setLayout(null);
        btnLogOut.addMouseListener(new ResFrame_btnLogOut_mouseAdapter(this));
        btnReserve.addActionListener(new ResFrame_btnReserve_actionAdapter(this));
        btnWalkIn.addActionListener(new ResFrame_btnWalkIn_actionAdapter(this));
        btnDisplay.addActionListener(new ResFrame_btnDisplay_actionAdapter(this));
        btnFinish.addActionListener(new ResFrame_btnFinish_actionAdapter(this));
        jLabel1.addMouseListener(new ResFrame_jLabel1_mouseAdapter(this));
        jLabel10.setBounds(new Rectangle(34, 25, 234, 36));
        jLabel2.addMouseListener(new ResFrame_jLabel2_mouseAdapter(this));
        this.getContentPane().add(tablePanel, new XYConstraints(10, 0, 750, 500));
        this.getContentPane().add(btnPanel, new XYConstraints(760, 0, 250, 500));
        this.getContentPane().add(infoPanel, new XYConstraints(0, 500, 1000, 200));
        infoPanel.add(jLabel10);
        jPanel1.add(jLabel6);
        jPanel1.add(jLabel5);
        btnPanel();
        tablePanel();
    }

    /**
     * tablePanel
     */
    private void tablePanel() {
        tablePanel.getViewport().add(jPanel1);

        jPanel1.setLayout(new GridLayout(3, 3));
        jLabel1.setText("No.1");
        jLabel2.setText("No.2");
        jLabel3.setText("No.3");
        jLabel4.setText("No.4");
        jLabel5.setText("No.5");
        jLabel6.setText("No.6");
        jLabel7.setText("No.7");
        jLabel8.setText("No.8");
        jLabel9.setText("No.9");
        refreshtable();

        jPanel1.setBackground(Color.white);
        jPanel1.add(jLabel1);
        jPanel1.add(jLabel2);
        jPanel1.add(jLabel3);
        jPanel1.add(jLabel4);
        jPanel1.add(jLabel5);
        jPanel1.add(jLabel6);
        jPanel1.add(jLabel7);
        jPanel1.add(jLabel8);
        jPanel1.add(jLabel9);
    }

    /**
     * btnPanel
     */
    private void btnPanel() {
        btnPanel.setLayout(xYLayout2);
        btnReserve.setBorder(null);
        btnWalkIn.setBorder(null);
        btnDisplay.setBorder(null);
        btnFinish.setBorder(null);
        btnLogOut.setBorder(null);
        btnReserve.setIcon(new ImageIcon("btnReserve.jpg"));
        btnWalkIn.setIcon(new ImageIcon("btnWalkIn.jpg"));
        btnDisplay.setIcon(new ImageIcon("btnDisplay.jpg"));
        btnFinish.setIcon(new ImageIcon("btnFinish.jpg"));
        btnLogOut.setIcon(new ImageIcon("btnLogout.jpg"));
        btnPanel.add(btnReserve, new XYConstraints(30, 50, 124, 39));
        btnPanel.add(btnWalkIn, new XYConstraints(55, 120, 128, 43));
        btnPanel.add(btnDisplay, new XYConstraints(30, 190, 124, 39));
        btnPanel.add(btnFinish, new XYConstraints(55, 260, 124, 39));
        btnPanel.add(btnLogOut, new XYConstraints(30, 330, 124, 39));
    }

    XYLayout xYLayout1 = new XYLayout();
    XYLayout xYLayout2 = new XYLayout();
    JScrollPane tablePanel = new JScrollPane();
    JPanel btnPanel = new JPanel();
    JPanel infoPanel = new JPanel();
    JButton btnReserve = new JButton();
    JButton btnWalkIn = new JButton();
    JButton btnDisplay = new JButton();
    JButton btnFinish = new JButton();
    JButton btnLogOut = new JButton();
    JLabel jLabel1 = new JLabel();
    JPanel jPanel1 = new JPanel();
    JLabel jLabel2 = new JLabel();
    JLabel jLabel3 = new JLabel();
    JLabel jLabel4 = new JLabel();
    JLabel jLabel5 = new JLabel();
    JLabel jLabel6 = new JLabel();
    JLabel jLabel7 = new JLabel();
    JLabel jLabel8 = new JLabel();
    JLabel jLabel9 = new JLabel();
    JLabel jLabel10 = new JLabel();
    public void btnLogOut_mouseClicked(MouseEvent e) {
    this.dispose();
    }
    /**
      * 這個函數用來刷新面板的桌子狀態
      */
     public void refreshtable()
     {
         Restaurant res = new Restaurant();
        Date currentDate = new Date(System.currentTimeMillis());
        res.gettablestate(currentDate);
        String statelist[] = new String[9];
        String talnolist[] = new String[9];
        Connection cn=ConnectionDB.getCon();
        Statement st=null;
        ResultSet rs=null;
             try{
             String sql = "select *  from T_TABLE ORDER BY TALNO ";
             st =cn.createStatement();
             rs = st.executeQuery(sql);
             int i = 0;
             while (rs.next())
             {

                 statelist[i]=rs.getString("state");
                 i++;
             }
             }catch(SQLException e)
             {
                 e.printStackTrace();
             }


        ArrayList<JLabel> jlabel = new ArrayList<JLabel>();
        jlabel.add(jLabel1);
        jlabel.add(jLabel2);
        jlabel.add(jLabel3);
        jlabel.add(jLabel4);
        jlabel.add(jLabel5);
        jlabel.add(jLabel6);
        jlabel.add(jLabel7);
        jlabel.add(jLabel8);
        jlabel.add(jLabel9);
        for(int i=0;i<9;i++)
        {
            if(statelist[i].equals("reservation"))
          {
              jlabel.get(i).setIcon(new ImageIcon("reservationtable.jpg"));

          }
          else if (statelist[i].equals("dining"))
          {
              jlabel.get(i).setIcon(new ImageIcon("diningtable.jpg"));
          }
          else if(statelist[i].equals("free"))
          {
              jlabel.get(i).setIcon(new ImageIcon("freetable.jpg"));
          }
        }

    }
    public void btnReserve_actionPerformed(ActionEvent e) {
       ReservationFrame reser = new ReservationFrame(this);
      reser.setSize(870,600);
         Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize();
             Dimension frameSize =reser.getSize();
             if (frameSize.height > screenSize.height) {
               frameSize.height = screenSize.height;
             }
             if (frameSize.width > screenSize.width) {
               frameSize.width = screenSize.width;
             }
           reser.setLocation((screenSize.width - frameSize.width) / 2, (screenSize.height - frameSize.height) / 2);
      reser.setVisible(true);
      this.setEnabled(false);
    }

    public void btnWalkIn_actionPerformed(ActionEvent e) {
        RecordWalkInFrame walkIn = new RecordWalkInFrame();
        walkIn.setSize(420,320);
                   //Center the window
                   Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize();
                  Dimension frameSize =walkIn.getSize();
                 if (frameSize.height > screenSize.height) {
                 frameSize.height = screenSize.height;
                   }
                 if (frameSize.width > screenSize.width) {
                  frameSize.width = screenSize.width;
                 }
              walkIn.setLocation((screenSize.width - frameSize.width) / 2, (screenSize.height - frameSize.height) / 2);

        walkIn.setVisible(true);
    }

    public void btnDisplay_actionPerformed(ActionEvent e) {
        refreshtable();
    }

    public void btnFinish_actionPerformed(ActionEvent e) {
        PaybillFrame paybill = new PaybillFrame();
    paybill.setSize(600,500);
         Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize();
             Dimension frameSize =paybill.getSize();
             if (frameSize.height > screenSize.height) {
               frameSize.height = screenSize.height;
             }
             if (frameSize.width > screenSize.width) {
               frameSize.width = screenSize.width;
             }
           paybill.setLocation((screenSize.width - frameSize.width) / 2, (screenSize.height - frameSize.height) / 2);
      paybill.setVisible(true);

    }

    public void jLabel1_mouseClicked(MouseEvent e) {
      //  ImageIcon ii = new ImageIcon("reservationtable.jpg");
        //if(jLabel1.getIcon().equals(ii.getImage()))

          /*  Connection cn=ConnectionDB.getCon();
            Statement st=null;
            ResultSet rs=null;
            String talno ="001";
            try{
           String sql = "select *  from reservation where talno ='"+talno+"' ";
           st =cn.createStatement();
           rs = st.executeQuery(sql);

           while (rs.next())
           {
                 String text = rs.getString("predate")+ rs.getString("arrivaldate")+ rs.getString("arrivaltime");
                 jLabel10.setText(text);


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




    }

    public void jLabel2_mouseClicked(MouseEvent e) {
       /* jLabel10.setText("");
        Connection cn=ConnectionDB.getCon();
         Statement st=null;
         ResultSet rs=null;
         String talno ="002";
         try{
        String sql = "select *  from reservation where talno ='"+talno+"' ";
        st =cn.createStatement();
        rs = st.executeQuery(sql);

        while (rs.next())
        {
              String text = rs.getString("predate")+ rs.getString("arrivaldate")+ rs.getString("arrivaltime");
              jLabel10.setText(text);


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

    }
}


class ResFrame_jLabel2_mouseAdapter extends MouseAdapter {
    private ResFrame adaptee;
    ResFrame_jLabel2_mouseAdapter(ResFrame adaptee) {
        this.adaptee = adaptee;
    }

    public void mouseClicked(MouseEvent e) {
        adaptee.jLabel2_mouseClicked(e);
    }
}


class ResFrame_jLabel1_mouseAdapter extends MouseAdapter {
    private ResFrame adaptee;
    ResFrame_jLabel1_mouseAdapter(ResFrame adaptee) {
        this.adaptee = adaptee;
    }

    public void mouseClicked(MouseEvent e) {
        adaptee.jLabel1_mouseClicked(e);
    }
}


class ResFrame_btnFinish_actionAdapter implements ActionListener {
    private ResFrame adaptee;
    ResFrame_btnFinish_actionAdapter(ResFrame adaptee) {
        this.adaptee = adaptee;
    }

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


class ResFrame_btnDisplay_actionAdapter implements ActionListener {
    private ResFrame adaptee;
    ResFrame_btnDisplay_actionAdapter(ResFrame adaptee) {
        this.adaptee = adaptee;
    }

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


class ResFrame_btnWalkIn_actionAdapter implements ActionListener {
    private ResFrame adaptee;
    ResFrame_btnWalkIn_actionAdapter(ResFrame adaptee) {
        this.adaptee = adaptee;
    }

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


class ResFrame_btnReserve_actionAdapter implements ActionListener {
    private ResFrame adaptee;
    ResFrame_btnReserve_actionAdapter(ResFrame adaptee) {
        this.adaptee = adaptee;
    }

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


class ResFrame_btnLogOut_mouseAdapter extends MouseAdapter {
    private ResFrame adaptee;
    ResFrame_btnLogOut_mouseAdapter(ResFrame adaptee) {
        this.adaptee = adaptee;
    }

    public void mouseClicked(MouseEvent e) {
        adaptee.btnLogOut_mouseClicked(e);
    }
}