import javax.swing.*;
import javax.swing.table.DefaultTableModel;
import java.awt.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;

import java.io.BufferedReader;
import java.io.IOException;
import java.net.Socket;
import java.sql.*;

public class Dashboard  {
    Connection conn;
    Dashboard() throws ClassNotFoundException, SQLException  {

        Class.forName("com.mysql.jdbc.Driver");
        conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/pulsaapp","root","");

        //WARNA
        Color gray = new Color(235,235,224);
        Color biru = new Color(52,152,219);

        final JFrame mainFrame = new JFrame("Nama Admin | PulsaApp");
        mainFrame.setSize(800,250);
        mainFrame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
        mainFrame.setLocation(300,100);
        mainFrame.setResizable(false);

        JMenuBar MenuBar = new JMenuBar();
        JMenu MenuFile = new JMenu("Menu");

        JMenuItem logout = new JMenuItem("Logout");
        JMenuItem stok = new JMenuItem("Pricelist");

        logout.setFont(new Font("Segoe UI",Font.PLAIN,14));
        logout.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent e) {
                mainFrame.setVisible(false);
                try {
                    new Login();
                } catch (ClassNotFoundException e1) {
                    e1.printStackTrace();
                } catch (SQLException e1) {
                    e1.printStackTrace();
                }
            }
        });

        stok.setFont(new Font("Segoe UI",Font.PLAIN,14));
        stok.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent e) {
                try {
                    new Stok();
                } catch (ClassNotFoundException e1) {
                    e1.printStackTrace();
                } catch (SQLException e1) {
                    e1.printStackTrace();
                }
            }
        });
        MenuFile.add(logout);
        MenuBar.add(MenuFile);
        mainFrame.add(MenuBar,BorderLayout.PAGE_START);

        final JPanel container = new JPanel();
        container.setLayout(new BoxLayout(container,BoxLayout.Y_AXIS));
        mainFrame.add(container);
        JPanel inputan = new JPanel();
        inputan.setLayout(new GridLayout(1,3));
        JTextField noHp = new JTextField("Masukkan No. Handphone");
        noHp.setBorder(BorderFactory.createEmptyBorder(0,20,0,0));

        //COMBO BOX PROVIDER
        final JComboBox provider  = new JComboBox();
        String dataProvider = "SELECT kode FROM provider ORDER BY nama";
        final PreparedStatement dataStmt = conn.prepareStatement(dataProvider);
        ResultSet rsProvider = dataStmt.executeQuery(dataProvider);
        while (rsProvider.next()) {
            provider.addItem(rsProvider.getString("kode"));
        }

        //COMBOBOX KATEGORI
        final JComboBox kategori = new JComboBox();
        String dataKategori = "SELECT kode FROM kategori ORDER BY nama";
        PreparedStatement kategoriStmt = conn.prepareStatement(dataKategori);
        ResultSet rsKategori = kategoriStmt.executeQuery(dataKategori);
        while(rsKategori.next()) {
            kategori.addItem(rsKategori.getString("kode"));
        }

        final JButton submit = new JButton("Submit");
        inputan.add(noHp);
        inputan.add(provider);
        inputan.add(kategori);
        inputan.add(submit);

        final DefaultTableModel model = new DefaultTableModel(new String[]{"Nama","nominal"},0);
        final JTable table = new JTable();

        //LOAD DATA KE TABLE DAN MUNCULIN TABLE KETIKA DI KLIK TOMBOL SUBMIT
        submit.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent e) {
                if (e.getSource() == submit) {
                    try {
                        String sql = "SELECT * FROM stok WHERE provider = ? AND kategori = ?";
                        PreparedStatement stmt = conn.prepareStatement(sql);
                        stmt.setString(1, String.valueOf(provider));
                        stmt.setString(2, String.valueOf(kategori));
                        ResultSet rs = stmt.executeQuery();
                        while (rs.next()) {
                            String nama = rs.getString("nama");
                            Integer nominal = rs.getInt("nominal");
                            model.addRow(new Object[]{nama, nominal});
                        }
                        table.setVisible(true);

                    } catch (SQLException e1) {
                        e1.printStackTrace();
                    }
                }
            }
        });
        container.add(inputan);
        table.setModel(model);
        table.setVisible(false);
        container.add(table);
        mainFrame.setVisible(true);
    }

    public static void main(String[] args) throws SQLException, ClassNotFoundException {
        new Dashboard();
    }
}