package supermarket;

import javax.swing.*;
import java.awt.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import DB.Link;
import java.sql.ResultSet;
import java.sql.*;

public class Taking
    extends JDialog {
  public Taking() {
    try {
      jbInit();
    }
    catch (Exception ex) {
      ex.printStackTrace();
    }
  }

  private void jbInit() throws Exception {
    this.setTitle("統計營業額");
    this.getContentPane().setLayout(null);
    cmbyear.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    cmbyear.setBounds(new Rectangle(43, 39, 107, 30));
    cmbmonth.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    lbltongji.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    lbltongji.setText("本月銷售總額：");
    lbltongji.setBounds(new Rectangle(43, 97, 265, 31));
    btntijiao.setBounds(new Rectangle(43, 153, 100, 34));
    btntijiao.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    btntijiao.setText("");
    btntijiao.addActionListener(new Taking_btntijiao_actionAdapter(this));
    btnfanghui.setBounds(new Rectangle(175, 155, 92, 31));
    btnfanghui.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    btnfanghui.setText("返回");
    btnfanghui.addActionListener(new Taking_btnfanghui_actionAdapter(this));
    lblyear.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    lblyear.setToolTipText("");
    lblyear.setText("年");
    lblyear.setBounds(new Rectangle(159, 41, 37, 33));
    lblmonth.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    lblmonth.setText("月");
    lblmonth.setBounds(new Rectangle(256, 39, 29, 32));
    jPanel1.setBorder(BorderFactory.createEtchedBorder());
    jPanel1.setBounds(new Rectangle(17, 22, 270, 61));
    jPanel2.setBorder(BorderFactory.createEtchedBorder());
    jPanel2.setBounds(new Rectangle(17, 81, 270, 61));
    jPanel3.setBorder(BorderFactory.createEtchedBorder());
    jPanel3.setBounds(new Rectangle(17, 138, 270, 61));
    this.getContentPane().add(cmbyear);
    this.getContentPane().add(lbltongji);
    this.getContentPane().add(btntijiao);
    this.getContentPane().add(cmbmonth);
    this.getContentPane().add(lblyear);
    this.getContentPane().add(lblmonth);
    this.getContentPane().add(btnfanghui);
    this.getContentPane().add(jPanel2);
    this.getContentPane().add(jPanel1);
    this.getContentPane().add(jPanel3);
    cmbmonth.setBounds(new Rectangle(196, 39, 54, 30));
    cmbyear.addItem("2008");
    cmbyear.addItem("2009");
    cmbyear.addItem("2010");
    cmbyear.addItem("2011");
    cmbyear.addItem("2012");
    cmbyear.addItem("2013");
    cmbyear.addItem("2014");
    cmbyear.addItem("2015");
    cmbyear.addItem("2016");
    cmbmonth.addItem("1");
    cmbmonth.addItem("2");
    cmbmonth.addItem("3");
    cmbmonth.addItem("4");
    cmbmonth.addItem("5");
    cmbmonth.addItem("6");
    cmbmonth.addItem("7");
    cmbmonth.addItem("8");
    cmbmonth.addItem("9");
    cmbmonth.addItem("10");
    cmbmonth.addItem("11");
    cmbmonth.addItem("12");
    btntijiao.setText("統計");
    btntijiao.setMnemonic('Q');
    this.setModal(true);
  }

  JComboBox cmbyear = new JComboBox();
  JComboBox cmbmonth = new JComboBox();
  JLabel lbltongji = new JLabel();
  JButton btntijiao = new JButton();
  JButton btnfanghui = new JButton();
  JLabel lblyear = new JLabel();
  JLabel lblmonth = new JLabel();
  JPanel jPanel1 = new JPanel();
  JPanel jPanel2 = new JPanel();
  JPanel jPanel3 = new JPanel();

  public void btnfanghui_actionPerformed(ActionEvent e) {//返回
 this.dispose();
  }

  public void btntijiao_actionPerformed(ActionEvent e) {
    float total=0;
    Link lk=new Link();
    lk.connection();
    String time=cmbyear.getSelectedItem().toString()+"-"+cmbmonth.getSelectedItem().toString()+"%'";
    String sql="select total from sellnote where times like '"+time+"";
    ResultSet rs=lk.Select(sql);
    try {
      while (rs.next()) {
        total+=rs.getFloat(1);
      }
    }
    catch (SQLException ex) {
    }
    lk.close();
    lbltongji.setText("本月銷售總額："+total+" 元");
  }

}

class Taking_btntijiao_actionAdapter
    implements ActionListener {
  private Taking adaptee;
  Taking_btntijiao_actionAdapter(Taking adaptee) {
    this.adaptee = adaptee;
  }

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

class Taking_btnfanghui_actionAdapter
    implements ActionListener {
  private Taking adaptee;
  Taking_btnfanghui_actionAdapter(Taking adaptee) {
    this.adaptee = adaptee;
  }

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