package supermarket;

import DB.*;
import java.awt.*;
import javax.swing.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import javax.swing.tree.DefaultMutableTreeNode;
import java.util.Vector;
import java.sql.ResultSet;
import java.sql.*;
import java.awt.event.KeyEvent;
import java.awt.event.KeyAdapter;
import javax.swing.border.Border;
import javax.swing.border.TitledBorder;
import java.awt.event.MouseEvent;
import java.awt.event.MouseAdapter;
import java.util.Calendar;
import java.util.Date;
import java.io.*;
import javax.swing.event.TreeSelectionEvent;
import javax.swing.event.TreeSelectionListener;

public class MainFrm
    extends JFrame {
  JPanel contentPane;
  Date t;
  JButton btnshangpin = new JButton();
  JButton btnhuiyuan = new JButton();
  JButton btnguanyu = new JButton();
  JButton btnexit = new JButton();
  JLabel lblimg = new JLabel();
  JTabbedPane tpnjieguo = new JTabbedPane();
  JPanel pnesell = new JPanel();
  JPanel pnetotal = new JPanel();
  JPanel jPanel8 = new JPanel();
  JScrollPane jScrollPane1 = new JScrollPane();
  Vector vt = new Vector(); //銷售商品表
  String head[] = {
      "商品編號", "類別", "商品名稱", "商品價格/元", "數量", "單位", "折扣率", "備注"};
  TableModle dm = new TableModle(head, vt);
  JTable tblsp = new JTable(dm);
  JButton btnsell = new JButton();
  JButton btncancel = new JButton();
  JTextField txtid = new JTextField();
  JLabel lblid = new JLabel();
  JLabel lblnumber = new JLabel();
  JTextField txtnumber = new JTextField();
  JButton btntianjia = new JButton();
  JLabel lblkind = new JLabel();
  JLabel lblspname = new JLabel();
  JTextField txtspname = new JTextField();
  JButton btntong = new JButton();
  JComboBox cmbname = new JComboBox();
  JScrollPane jScrollPane2 = new JScrollPane();
  Vector vr = new Vector(); //統計報表
  String totalhead[] = {
      "商品編號", "類別", "商品名稱", "售出數量", "售出總額/元", "售出時間"};
  TableModle tm = new TableModle(totalhead, vr);

  JTable tbltotal = new JTable(tm);
  String shopping = ""; //存添加到表里的商品

  JButton btncan = new JButton();
  JCheckBox chbvip = new JCheckBox();
  JMenuBar jMenuBar1 = new JMenuBar();
  JMenu jMenu1 = new JMenu();
  JMenuItem jMenuItem1 = new JMenuItem();
  JMenuItem jMenuItem2 = new JMenuItem();
  JMenuItem jMenuItem3 = new JMenuItem();
  JMenu jMenu2 = new JMenu();
  JMenu jMenu6 = new JMenu();
  JMenuItem jMenuItem11 = new JMenuItem();
  JPanel jPanel1 = new JPanel();
  Border border1 = BorderFactory.createEtchedBorder(Color.white,
      new Color(148, 145, 140));
  Border border2 = new TitledBorder(border1, "百度");
  Border border3 = BorderFactory.createEtchedBorder(Color.white,
      new Color(148, 145, 140));
  JTextField txtvipid = new JTextField();
  JLabel jLabel1 = new JLabel();
  JMenuItem jMenuItem4 = new JMenuItem();
  JMenuItem jMenuItem5 = new JMenuItem();
  JMenuItem jMenuItem9 = new JMenuItem();
  JButton btnkong = new JButton();
  JButton btndate = new JButton();
  JPanel pnejinhuo = new JPanel();
  JScrollPane jScrollPane3 = new JScrollPane();

  JTree treeIn;
  JScrollPane jScrollPane4 = new JScrollPane();
  Vector ve = new Vector(); //進貨表
  String jinhuo[] = { //進貨
      "商品編號", "類別", "商品名稱", "庫存量", "單位", "備注"};
  TableModle ta = new TableModle(jinhuo, ve);
  JTable tbljinhuo = new JTable(ta);
  JButton btnjinhuo = new JButton();
  JButton btnquan = new JButton();
  JButton btncl = new JButton();
  int i = 0;
  JPanel pnejinhuototal = new JPanel();
  JScrollPane jScrollPane5 = new JScrollPane();
  Vector vc = new Vector(); //進貨表統計
  String into[] = { //進貨
      "類別", "商品名稱", "進貨量", "進貨時間"};
  TableModle in = new TableModle(into, vc);

  JTable tblinto = new JTable(in);
  JButton btninto = new JButton();
  JButton btncls = new JButton();
  JComboBox cmbyear = new JComboBox();
  JComboBox cmbmonth = new JComboBox();
  JLabel lblyear = new JLabel();
  JLabel jLabel2 = new JLabel();
  JButton btnall = new JButton();
  JButton btnyingye = new JButton();
  JLabel lblpv = new JLabel();
  JMenuItem jMenuItem6 = new JMenuItem();
  public MainFrm(int i) {
    try {
      this.i = i;
      setDefaultCloseOperation(EXIT_ON_CLOSE);
      jbInit();
    }
    catch (Exception ex) {
      ex.printStackTrace();
    }
  }

  public MainFrm() { //默認構造方法
    setDefaultCloseOperation(EXIT_ON_CLOSE);
    try {
      jbInit();
    }
    catch (Exception ex) {
    }
  }

  /**
   * Component initialization.
   *
   * @throws java.lang.Exception
   */
  private void jbInit() throws Exception {
    contentPane = (JPanel) getContentPane();
    contentPane.setLayout(null);
    this.getContentPane().setBackground(Color.lightGray);
    this.setJMenuBar(jMenuBar1);

    setSize(new Dimension(872, 600));
    setTitle("超市管理系統");
    btnshangpin.setBackground(new Color(212, 208, 200));
    btnshangpin.setBounds(new Rectangle(1, 0, 129, 69));
    btnshangpin.setFont(new java.awt.Font("Dialog", Font.PLAIN, 20));
    btnshangpin.setText("商品管理");
    btnshangpin.addActionListener(new MainFrm_btnshangpin_actionAdapter(this));
    btnhuiyuan.setBackground(new Color(212, 208, 200));
    btnhuiyuan.setBounds(new Rectangle(130, 0, 129, 69));
    btnhuiyuan.setFont(new java.awt.Font("Dialog", Font.PLAIN, 24));
    btnhuiyuan.setRequestFocusEnabled(false);
    btnhuiyuan.setToolTipText("");
    btnhuiyuan.setVerifyInputWhenFocusTarget(false);
    btnhuiyuan.setText("會員管理");
    btnhuiyuan.addActionListener(new MainFrm_btnhuiyuan_actionAdapter(this));
//    btnhuiyuan.setIcon(new ImageIcon("img/huiyuan.jpg"));
//    btnhuiyuan.setMnemonic('0');
    btnguanyu.setBackground(new Color(212, 208, 200));
    btnguanyu.setBounds(new Rectangle(388, 0, 129, 69));
    btnguanyu.setFont(new java.awt.Font("Dialog", Font.PLAIN, 20));
    btnguanyu.setText("關于我們");
    btnguanyu.addActionListener(new MainFrm_btnguanyu_actionAdapter(this));
//    btnguanyu.setIcon(new ImageIcon("img/guanyu.jpg"));
    btnexit.setBackground(new Color(212, 208, 200));
    btnexit.setBounds(new Rectangle(518, 0, 129, 69));
    btnexit.setFont(new java.awt.Font("Dialog", Font.PLAIN, 20));
    btnexit.setText("退出");
//    btnexit.setIcon(new ImageIcon("img/tuichu.jpg"));
    btnexit.addActionListener(new MainFrm_btnexit_actionAdapter(this));
    lblimg.setText("");
    lblimg.setBounds(new Rectangle(5, 10, 859, 514));
    tpnjieguo.setBackground(Color.lightGray);
    tpnjieguo.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    tpnjieguo.setToolTipText("");
    tpnjieguo.setBounds(new Rectangle(22, 132, 826, 378));
    pnesell.setLayout(null);
    pnetotal.setLayout(null);
    pnesell.setBackground(Color.lightGray);
    pnetotal.setBackground(Color.lightGray);
    jPanel8.setBorder(BorderFactory.createEtchedBorder());
    jPanel8.setBounds(new Rectangle(1, 129, 865, 446));
    jPanel8.setLayout(null);
    jScrollPane1.setBounds(new Rectangle(15, 61, 787, 237));
    btnsell.setBounds(new Rectangle(334, 302, 142, 28));
    btnsell.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    btnsell.setText("出售");
    btnsell.addActionListener(new MainFrm_btnsell_actionAdapter(this));
    btncancel.setBounds(new Rectangle(663, 302, 142, 28));
    btncancel.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    btncancel.setText("清空");
    btncancel.addActionListener(new MainFrm_jButton2_actionAdapter(this));
    txtid.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    txtid.setText("");
    txtid.setBounds(new Rectangle(100, 25, 190, 24));
    txtid.addKeyListener(new MainFrm_txtname_keyAdapter(this));
    lblid.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    lblid.setText("商品編號:");
    lblid.setBounds(new Rectangle(15, 26, 85, 23));
    lblnumber.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    lblnumber.setText("商品個數:");
    lblnumber.setBounds(new Rectangle(321, 26, 98, 23));
    txtnumber.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    txtnumber.setText("1");
    txtnumber.setBounds(new Rectangle(427, 25, 97, 24));
    txtnumber.addKeyListener(new MainFrm_txtnumber_keyAdapter(this));
    txtnumber.setHorizontalAlignment(JTextField.RIGHT); //設置文本對齊方式
    btntianjia.setBackground(Color.lightGray);
    btntianjia.setBounds(new Rectangle(563, 23, 142, 28));
    btntianjia.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    btntianjia.setText("添加到表里");
    btntianjia.addActionListener(new MainFrm_btntianjia_actionAdapter(this));
    tblsp.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    lblkind.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    lblkind.setText("商品類別:");
    lblkind.setBounds(new Rectangle(18, 17, 87, 23));
    lblspname.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    lblspname.setText("商品名:");
    lblspname.setBounds(new Rectangle(265, 19, 77, 23));
    txtspname.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    txtspname.setText("");
    txtspname.setBounds(new Rectangle(343, 15, 96, 29));
    txtspname.addKeyListener(new MainFrm_txtspname_keyAdapter(this));
    btntong.setBounds(new Rectangle(478, 13, 119, 33));
    btntong.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    btntong.setText("統計");
    btntong.addActionListener(new MainFrm_jButton1_actionAdapter(this));
    cmbname.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    cmbname.setBounds(new Rectangle(110, 14, 111, 29));
    jScrollPane2.setBounds(new Rectangle(18, 57, 782, 253));
    btncan.setBounds(new Rectangle(499, 302, 142, 28));
    btncan.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    btncan.setText("刪除表中商品");
    btncan.addActionListener(new MainFrm_btncan_actionAdapter(this));
    chbvip.setBackground(Color.lightGray);
    chbvip.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    chbvip.setText("會員");
    chbvip.setBounds(new Rectangle(17, 305, 65, 23));
    chbvip.addMouseListener(new MainFrm_chbvip_mouseAdapter(this));
    jMenu1.setFont(new java.awt.Font("Dialog", Font.PLAIN, 20));
    jMenu1.setText("用戶管理");
    jMenuItem1.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    jMenuItem1.setText("添加用戶");
    jMenuItem1.addActionListener(new MainFrm_jMenuItem1_actionAdapter(this));
    jMenuItem2.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    jMenuItem2.setText("切換用戶");
    jMenuItem2.addActionListener(new MainFrm_jMenuItem2_actionAdapter(this));
    jMenuItem3.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    jMenuItem3.setText("退出");
    jMenuItem3.addActionListener(new MainFrm_jMenuItem3_actionAdapter(this));
    jMenu2.setFont(new java.awt.Font("Dialog", Font.PLAIN, 20));
    jMenu2.setText("工具");
    jMenu6.setFont(new java.awt.Font("Dialog", Font.PLAIN, 20));
    jMenu6.setText("幫助");
    jMenuItem11.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    jMenuItem11.setText("軟件幫助");
    jMenuItem11.addActionListener(new MainFrm_jMenuItem11_actionAdapter(this));
    jPanel1.setBorder(border3);
    jPanel1.setBounds(new Rectangle( -1, 70, 869, 64));
    jPanel1.setLayout(null);
    txtvipid.setEnabled(false);
    txtvipid.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    txtvipid.setText("");
    txtvipid.setBounds(new Rectangle(144, 304, 158, 24));
    jLabel1.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    jLabel1.setText("卡號：");
    jLabel1.setBounds(new Rectangle(86, 305, 54, 23));
    jMenuItem4.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    jMenuItem4.setText("計算器");
    jMenuItem4.addActionListener(new MainFrm_jMenuItem4_actionAdapter(this));
    jMenuItem9.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    jMenuItem9.setText("記事本");
    jMenuItem9.addActionListener(new MainFrm_jMenuItem9_actionAdapter(this));
    btnkong.setBounds(new Rectangle(684, 312, 106, 27));
    btnkong.setText("清空");
    btnkong.addActionListener(new MainFrm_btnkong_actionAdapter(this));
    btndate.setBounds(new Rectangle(680, 13, 119, 33));
    btndate.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    btndate.setText("今日統計");
    btndate.addActionListener(new MainFrm_btndate_actionAdapter(this));
    pnejinhuo.setLayout(null);
    jScrollPane3.setBounds(new Rectangle(9, 11, 160, 316));
    pnejinhuo.setBackground(Color.lightGray);
    jScrollPane4.setBounds(new Rectangle(187, 17, 620, 252));
    btnjinhuo.setBounds(new Rectangle(258, 293, 116, 35));
    btnjinhuo.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    btnjinhuo.setText("進  貨");
    btnjinhuo.addActionListener(new MainFrm_btnjinhuo_actionAdapter(this));
    btnquan.setBounds(new Rectangle(465, 293, 116, 35));
    btnquan.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    btnquan.setText("顯示所有");
    btnquan.addActionListener(new MainFrm_btnquan_actionAdapter(this));
    btncl.setBounds(new Rectangle(672, 293, 116, 35));
    btncl.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    btncl.setText("清空");
    btncl.addActionListener(new MainFrm_btncl_actionAdapter(this));
    pnejinhuototal.setLayout(null);
    pnejinhuototal.setBackground(Color.lightGray);
    jScrollPane5.setBounds(new Rectangle(19, 26, 781, 265));
    btninto.setBounds(new Rectangle(238, 299, 160, 33));
    btninto.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    btninto.setText("顯示進貨明細");
    btninto.addActionListener(new MainFrm_btninto_actionAdapter(this));
    btncls.setBounds(new Rectangle(640, 299, 160, 33));
    btncls.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    btncls.setText("清空表");
    btncls.addActionListener(new MainFrm_btncls_actionAdapter(this));
    cmbyear.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    cmbyear.setBounds(new Rectangle(21, 303, 92, 29));
    cmbmonth.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    cmbmonth.setBounds(new Rectangle(143, 303, 65, 29));
    lblyear.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    lblyear.setText("年");
    lblyear.setBounds(new Rectangle(117, 305, 23, 25));
    jLabel2.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    jLabel2.setText("月");
    jLabel2.setBounds(new Rectangle(213, 305, 29, 23));
    btnall.setBounds(new Rectangle(439, 299, 160, 33));
    btnall.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    btnall.setText("顯示全部");
    btnall.addActionListener(new MainFrm_btnall_actionAdapter(this));
    btnyingye.setBackground(new Color(212, 208, 200));
    btnyingye.setBounds(new Rectangle(259, 0, 129, 69));
    btnyingye.setFont(new java.awt.Font("Dialog", Font.PLAIN, 20));
    btnyingye.setText("統計營業額");
    btnyingye.addActionListener(new MainFrm_btnyingye_actionAdapter(this));
    lblpv.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    lblpv.setText("");
    lblpv.setBounds(new Rectangle(25, 11, 276, 39));
    jMenuItem6.setText("刪除用戶");
    jMenuItem6.addActionListener(new MainFrm_jMenuItem6_actionAdapter(this));
    contentPane.add(tpnjieguo);
    contentPane.add(jPanel8);
    jPanel8.add(lblimg, null);
    contentPane.add(jPanel1);
    jPanel1.add(lblpv);
    contentPane.add(btnshangpin);
    contentPane.add(btnhuiyuan);
    contentPane.add(btnexit);
    contentPane.add(btnguanyu);
    contentPane.add(btnyingye);
    pnesell.add(jScrollPane1);
    pnesell.add(txtid);
    pnesell.add(lblid);
    pnesell.add(lblnumber);
    pnesell.add(txtnumber);
    pnesell.add(chbvip);
    pnesell.add(btncan);
    pnesell.add(txtvipid);
    pnesell.add(jLabel1);
    pnesell.add(btnsell);
    pnesell.add(btncancel);
    pnesell.add(btntianjia);
    jScrollPane1.getViewport().add(tblsp);
    pnetotal.add(jScrollPane2);
    jScrollPane2.getViewport().add(tbltotal);
    pnetotal.add(btnkong);
    pnetotal.add(lblkind);
    pnetotal.add(cmbname);
    pnetotal.add(lblspname);
    pnetotal.add(txtspname);
    pnetotal.add(btntong);
    pnetotal.add(btndate);
    jMenuBar1.add(jMenu1);
    jMenuBar1.add(jMenu2);
    jMenuBar1.add(jMenu6);
    jMenu1.add(jMenuItem1);
    jMenu1.add(jMenuItem6);
    jMenu1.add(jMenuItem2);
    jMenu1.add(jMenuItem3);
    jMenu2.add(jMenuItem4);
    jMenu2.add(jMenuItem9);
    jMenu6.add(jMenuItem11);
    tpnjieguo.add(pnesell, "商品銷售");
    tpnjieguo.add(pnetotal, "銷售統計");
    tpnjieguo.add(pnejinhuo, "進貨管理");

    treeIn = new JTree(tree());
    treeIn.addTreeSelectionListener(new MainFrm_treeIn_treeSelectionAdapter(this));
    jScrollPane3.getViewport().add(treeIn);
    pnejinhuo.add(jScrollPane3);
    pnejinhuo.add(jScrollPane4);
    pnejinhuo.add(btnquan);
    pnejinhuo.add(btnjinhuo);
    pnejinhuo.add(btncl);
    jScrollPane4.getViewport().add(tbljinhuo);
    pnejinhuototal.add(jScrollPane5);
    pnejinhuototal.add(cmbyear);
    pnejinhuototal.add(lblyear);
    pnejinhuototal.add(cmbmonth);
    pnejinhuototal.add(jLabel2);
    pnejinhuototal.add(btninto);
    pnejinhuototal.add(btnall);
    pnejinhuototal.add(btncls);
    jScrollPane5.getViewport().add(tblinto);
    tpnjieguo.add(pnejinhuototal, "進貨明細");
    this.setResizable(false); //固定窗口大小
//    LandFrm lf = new LandFrm(this);//彈出登陸框
//    lf.setLocation(300, 250);
//    lf.show();

//    btnxitong.setIcon(new ImageIcon("img/system.png"));
//    btnshangpin.setIcon(new ImageIcon("img/Manager.jpg"));

    //lblimg.setIcon(new ImageIcon("img/shui.jpg")); //背景圖

//    this.setCursor(Cursor.HAND_CURSOR);//設置鼠標

    setData(i);
    disleibei();
    year();
  }

  public void setData(int i) { //權限管理
    switch (i) {
      case 1: //收銀員權限
        btnshangpin.setEnabled(false);
        btnhuiyuan.setEnabled(true);
        lblpv.setText("當前登陸用戶：收銀員");

        // tpnjieguo.setEnabled(true);
        btncancel.setEnabled(true);
        btntianjia.setEnabled(true);
        btnsell.setEnabled(true);
        txtid.setEnabled(true);
        txtnumber.setEnabled(true);
        btncan.setEnabled(true);
        chbvip.setEnabled(true);
        btnyingye.setEnabled(false);
        jMenuItem1.setEnabled(false);
        jMenuItem2.setEnabled(true);
        cmbname.setEnabled(true);
        txtspname.setEnabled(true);
        btntong.setEnabled(true);
        btndate.setEnabled(true);
        btnkong.setEnabled(true);
        treeIn.setEnabled(false);
        btnjinhuo.setEnabled(false);
        btnquan.setEnabled(false);
        btncls.setEnabled(false);
        btninto.setEnabled(false);
        btncl.setEnabled(false);
        btnall.setEnabled(false);
        cmbyear.setEnabled(false);
        cmbmonth.setEnabled(false);

        break;
      case 2: //倉庫保管員權限
        btnshangpin.setEnabled(true);
        btnhuiyuan.setEnabled(false);