/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
package nl.hva.hboict.fys;

import java.sql.*;
import java.util.ArrayList;
import java.util.List;
import java.util.Stack;

import javafx.application.Application;
import static javafx.application.Application.launch;

import javafx.beans.property.ReadOnlyStringWrapper;
import javafx.beans.value.ChangeListener;
import javafx.beans.value.ObservableValue;
import javafx.collections.FXCollections;
import javafx.event.ActionEvent;
import javafx.event.EventHandler;
import javafx.geometry.HPos;
import javafx.geometry.Insets;
import javafx.geometry.Pos;
import javafx.geometry.VPos;
import javafx.scene.Scene;
import javafx.scene.control.*;
import javafx.scene.layout.*;
import javafx.stage.Stage;
import javafx.scene.text.Font;
import javafx.scene.text.Text;
import nl.hva.hboict.sql.DataRow;
import nl.hva.hboict.sql.DataTable;

/**
 *
 * @author Boris Kalshoven
 */
public class EventHandlers extends Application {

    Scene scene1, scene2;
    Stage thestage;
    Button btVbrv;

    private static TableView<DataRow> createJavaFXReadOnlyDataTableView(DataTable dt) {
        TableView<DataRow> tv = new TableView<>();
        tv.setPrefWidth(5000);

        // define a JavaFX TableColumn for every column in the DataTable
        for (int c = 0; c < dt.getNColumns(); c++) {
            TableColumn<DataRow, String> tc = new TableColumn(dt.getColumnName(c));
            tc.setStyle("-fx-alignment: CENTER;");
            tc.setResizable(true);
            final int colIndex = c;

            // configure the Cell Value generator
            tc.setCellValueFactory(data -> {
                DataRow dr = data.getValue();
                String cellValue;
                cellValue = dr.getString(colIndex);
                return new ReadOnlyStringWrapper(cellValue);
            });
            tv.getColumns().add(tc);
        }

        // Add all Data Table data to the TableView
        for (int i = 0; i < dt.size(); i++) {
            tv.getItems().add(dt.get(i));
        }

        // align the view with the boundaries of the container
        tv.setColumnResizePolicy(TableView.CONSTRAINED_RESIZE_POLICY);
        //tv.setColumnResizePolicy((param) -> true);

        return tv;
    }

    private static Region pagina2(Button btVbrv) {
        VBox inrichting = new VBox();
        inrichting.setAlignment(Pos.TOP_RIGHT);

        //hbox bovenin de grid
        HBox bar = new HBox();
        bar.setAlignment(Pos.TOP_RIGHT);
        bar.setSpacing(15);
        bar.setPadding(new Insets(5, 10, 10, 10));

        //hbox text "Corendon"
        HBox textCorendon = new HBox();
        textCorendon.setAlignment(Pos.TOP_LEFT);
        textCorendon.setSpacing(15);
        textCorendon.setPadding(new Insets(15, 10, 10, 15));

        //hbox drop down menu
        HBox invoer = new HBox();
        invoer.setAlignment(Pos.TOP_RIGHT);
        invoer.setPadding(new Insets(10, 10, 10, 10));
        invoer.setSpacing(15);

        //hbox voor button voeg toe
        HBox add = new HBox();
        add.setAlignment(Pos.TOP_RIGHT);
        add.setPadding(new Insets(10, 10, 0, 0));
        add.setSpacing(30);

        //hbox voor ingevoerde gegevens
        HBox kenmerken = new HBox();
        kenmerken.setAlignment(Pos.TOP_RIGHT);
        kenmerken.setPadding(new Insets(10, 10, 10, 10));
        kenmerken.setSpacing(15);

        HBox toevoegen = new HBox();
        toevoegen.setAlignment(Pos.TOP_RIGHT);
        toevoegen.setSpacing(15);
        toevoegen.setPadding(new Insets(5, 10, 10, 10));

        //button1
        Button btn = new Button();
        btn.setText("Vermiste bagage registreren/verwijderen");
        btn.setMaxSize(140, 60);
        btn.setWrapText(true);
        return inrichting;
    }

    /*
    Pas dit aan!! Lennard
     */
    @Override
    public void start(Stage primaryStage) {
        example(primaryStage);
    }

    public void start2(Stage primaryStage) {

        thestage = primaryStage;

        //Login Pagina
        Button btnL = new Button("Login");
        TextField txtL = new TextField("Username");
        PasswordField passL = new PasswordField();
        HBox buttonBar = new HBox(btnL, txtL, passL);
//eerste pagina
        StackPane mainArea = new StackPane();

/*
Lennard
*/

        GridPane pane = new GridPane();
        pane.add(buttonBar, 0, 0);
        pane.setPrefHeight(400);
        pane.setPrefWidth(600);
        pane.setPadding(new Insets(10, 10, 10, 250));
        pane.setHgap(10);
        pane.setVgap(10);
        pane.add(mainArea, 0, 1);

        //text and labels
        Label label1 = new Label("koffers");
        label1.setPrefWidth(130);
        TextField text = new TextField();

        GridPane.setConstraints(label1, 0, 1);
        GridPane.setConstraints(text, 1, 1);

        Label label2 = new Label("kleur");
        TextField text2 = new TextField();

        GridPane.setConstraints(label2, 0, 2);
        GridPane.setConstraints(text2, 1, 2);

        Label label3 = new Label("formaat");
        TextField text3 = new TextField();
        GridPane.setConstraints(label3, 0, 3);
        GridPane.setConstraints(text3, 1, 3);

        Label label4 = new Label("gewicht");
        TextField text4 = new TextField();
        GridPane.setConstraints(label4, 0, 4);
        GridPane.setConstraints(text4, 1, 4);

        Label label5 = new Label("merk");
        TextField text5 = new TextField();
        GridPane.setConstraints(label5, 0, 5);
        GridPane.setConstraints(text5, 1, 5);

        //zoek button
        Button btZoeken = new Button("Zoeken");
        GridPane.setConstraints(btZoeken, 1, 7, 1, 1, HPos.CENTER, VPos.BASELINE);

        //repatrieer button
        Button btRepatrieer = new Button("Repatrieer");
        GridPane.setConstraints(btRepatrieer, 1, 7, 1, 1, HPos.CENTER, VPos.BASELINE);

        btVbrv = new Button("Vermiste koffers registreren");
        btVbrv.setPadding(new Insets(0));

        //Gevonden checkbox
        CheckBox cb1 = new CheckBox("Gevonden");
        GridPane.setConstraints(cb1, 0, 6);
        //Vermiste checkbox
        CheckBox cb2 = new CheckBox("Vermist");
        GridPane.setConstraints(cb2, 1, 6);

        //action voor button registreerKoffer
        //Leannard's commentaar
        btZoeken.setOnAction(new EventHandler<ActionEvent>() {

            @Override
            public void handle(ActionEvent event) {
                boolean selected1 = cb1.isSelected();
                boolean selected2 = cb2.isSelected();

                String query = "SELECT * FROM eenDatabase.tabel";

                List<String> conditions = new ArrayList<>();

                if (selected1) {
                    conditions.add("gevonden = 1");
                }

                if (selected2) {
                    conditions.add("verloren = 1");
                }

                //TODO: more querystuff
                //conditions
                if (conditions.size() > 0) {
                    query += " WHERE ";
                }

                for (int i = 0; i < conditions.size() - 1; i++) {
                    query += conditions.get(i) + " AND ";
                }

                if (conditions.size() - 1 >= 0) {
                    query += conditions.get(conditions.size() - 1);
                }

                System.out.println(query);

                //database.doQuery(query);
            }
        });

        /*
        pas dit aan!!
         */
        btVbrv.setOnAction(e -> ButtonClicked(e));

        /*

        Tweede pagina is jouw code!!
         */
//tweede pagina
        VBox inrichting = new VBox();
        inrichting.setAlignment(Pos.TOP_RIGHT);

        //hbox bovenin de grid
        HBox bar = new HBox();
        bar.setAlignment(Pos.TOP_RIGHT);
        bar.setSpacing(15);
        bar.setPadding(new Insets(5, 10, 10, 10));

        //hbox text "Corendon"
        HBox textCorendon = new HBox();
        textCorendon.setAlignment(Pos.TOP_LEFT);
        textCorendon.setSpacing(15);
        textCorendon.setPadding(new Insets(15, 10, 10, 15));

        //hbox drop down menu
        HBox invoer = new HBox();
        invoer.setAlignment(Pos.TOP_RIGHT);
        invoer.setPadding(new Insets(10, 10, 10, 10));
        invoer.setSpacing(15);

        //hbox voor button voeg toe
        HBox add = new HBox();
        add.setAlignment(Pos.TOP_RIGHT);
        add.setPadding(new Insets(10, 10, 0, 0));
        add.setSpacing(30);

        //hbox voor ingevoerde gegevens
        HBox kenmerken = new HBox();
        kenmerken.setAlignment(Pos.TOP_RIGHT);
        kenmerken.setPadding(new Insets(10, 10, 10, 10));
        kenmerken.setSpacing(15);

        HBox toevoegen = new HBox();
        toevoegen.setAlignment(Pos.TOP_RIGHT);
        toevoegen.setSpacing(15);
        toevoegen.setPadding(new Insets(5, 10, 10, 10));

        //button1
        Button btn = new Button();
        btn.setText("Vermiste bagage registreren/verwijderen");
        btn.setMaxSize(140, 60);
        btn.setWrapText(true);

        //button acties
        /*

        Pas dit aan!!

         */
        btn.setOnAction(e -> ButtonClicked(e));

        //button 2
        Button btn2 = new Button();
        btn2.setText("Gevonden bagage registreren/verwijderen");
        btn2.setMaxSize(140, 60);
        btn2.setWrapText(true);

        //button2 acties
        btn2.setOnAction(new EventHandler<ActionEvent>() {

            @Override
            public void handle(ActionEvent event) {
                System.out.println("");
            }
        });

//lennard

        //button3
        Button btn3 = new Button();
        btn3.setText("Voeg toe");
        btn3.setMaxSize(2500, 60);

        //button 4
        Button btn4 = new Button();
        btn4.setText("Toevoegen");
        btn4.setMaxSize(140, 60);

        //button 5
        Button btn5 = new Button();
        btn5.setText("Verwijderen");
        btn5.setMaxSize(140, 60);

        //text "Corendon"
        Text t = new Text("Corendon");
        t.setFont(new Font(20));

        //menu
        ChoiceBox cb = new ChoiceBox(FXCollections.observableArrayList(
                "Kleur",
                "Gewicht",
                "Lengte",
                "Breedte",
                "Label Nr.",
                "Locatie")
        );
        /*
        cb.setPrefWidth(140);
        cb.setMaxWidth(140);
         */
        Label label = new Label();
        //TextField y = new TextField();

        final String[] keuze = new String[]{"Kleur", "Gewicht", "Lengte", "Breedte", "Label Nr.", "Locatie"};

        cb.getSelectionModel().selectedIndexProperty().addListener(new ChangeListener<Number>() {
            public void changed(ObservableValue ov, Number value, Number new_value) {
                label.setText(keuze[new_value.intValue()]);
                //y.setText(keuze[new_value.intValue()]);

            }
        }
        );

        //invoer van tekst
        TextField textField = new TextField();
        textField.setMaxWidth(140);

        //display van tekst
        TextArea j = new TextArea();
        j.setPrefSize(240, 120);
        j.setEditable(false);

        /*
        label.textProperty().bind(test);
         */
        btn3.setOnAction(new EventHandler<ActionEvent>() {

            @Override
            public void handle(ActionEvent event) {
                if (textField.getText().trim().isEmpty() == false && label.getText().trim().isEmpty() == false) {
                    String test = " ";
                    test = j.getText();
                    j.setText(test + label.getText() + " - " + textField.getText() + " \n");
                    textField.clear();
                }
            }
        });

        //root
        StackPane root = new StackPane();
        root.getChildren().addAll(text, inrichting);
        inrichting.getChildren().addAll(bar, invoer, add, kenmerken, toevoegen);

        //bar
        bar.getChildren().addAll(btn, btn2);

        //text
        textCorendon.getChildren().add(t);

        //invoer
        invoer.getChildren().addAll(cb, textField);

        //add
        add.getChildren().addAll(btn3);

        //kenmerken
        kenmerken.getChildren().add(j);

        //toevoegen
        toevoegen.getChildren().addAll(btn4, btn5);

        //scene 1 en 2
        pane.getChildren().addAll(label1, text, label2, text2, label3, text3,
                label4, text4, label5, text5, btZoeken, cb1, cb2, btVbrv);
        pane.setGridLinesVisible(false);
        scene1 = new Scene(pane);
        scene2 = new Scene(root, 600, 400);
        primaryStage.setTitle("EventHandlers");
        primaryStage.setScene(scene1);
        primaryStage.show();

    }

    /*

    pas dit aan!!

     */
    public void ButtonClicked(ActionEvent e) {
        if (e.getSource() == btVbrv) {
            thestage.setScene(scene2);
        } else {
            thestage.setScene(scene1);
        }
    }

    /*
Button btnE, btnC, btnS, btnL;
StackPane mainArea = new StackPane();
    Label txtL,passL;

    btnL.setOnAction(new EventHandler<ActionEvent>() {
                             @Override
                             public void handle(ActionEvent event) {
                                 String user = txtL.getText();
                                 String pass = passL.getText();
                                 try {
                                     Class<?> aClass = Class.forName("com.mysql.jdbc.Driver");
                                     Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/myairline", "root", "handig123");
                                     Statement stmt = con.createStatement();
                                     String sql = "Select * from user WHERE username ='" + user + "' and password ='" + pass + "'";
                                     ResultSet rs = stmt.executeQuery(sql);
                                     while (rs.next()) {
                                         if (user.equals(rs.getString("username"))) {
                                             if (pass.equals(rs.getString("password"))) {
                                                 mainArea.getChildren().clear();
                                                 mainArea.getChildren().add(createJavaFXReadOnlyDataTableView(airportData));
                                                 btnE.setVisible(true);
                                                 btnC.setVisible(false);
                                                 btnS.setVisible(false);
                                                 buttonList.setVisible(true);
                                                 txtL.setVisible(false);
                                                 passL.setVisible(false);

                                             } else {
                                                 alert.showAndWait();
                                             }
                                         } else {
                                             alert.showAndWait();
                                         }
                                         stmt.close();
                                         con.close();
                                     }


                                 } catch (ClassNotFoundException e) {
                                     e.printStackTrace();
                                 } catch (SQLException e) {
                                     e.printStackTrace();
                                 }
                             }
                         });

     */
    /**
     * @param args the command line arguments
     */
    public static void main(String[] args) {
        launch(args);
    }

    private BorderPane root;

    public void example(Stage primaryStage) {
        root = new BorderPane();

        switchScreen(createLogin());

        primaryStage.setTitle("EventHandlers");
        primaryStage.setScene(new Scene(root, 600, 400));
        primaryStage.show();
    }

    private void switchScreen(Pane screen) {
        root.setCenter(screen);
    }

    public Pane createLogin() {
        GridPane gridPane = new GridPane();

        Button login = new Button("Login!");
        login.setOnAction(new EventHandler<ActionEvent>() {

            @Override
            public void handle(ActionEvent event) {
                switchScreen(createOverview());
            }
        });

        gridPane.add(new Label("Login!"), 0, 0);
        gridPane.add(login, 0, 1);

        return gridPane;
    }

    public Pane createOverview() {
        GridPane gridPane = new GridPane();

        Button logout = new Button("Logout!");
        logout.setOnAction(new EventHandler<ActionEvent>() {

            @Override
            public void handle(ActionEvent event) {
                switchScreen(createLogin());
            }
        });

        gridPane.add(new Label("Overview!"), 0, 0);
        gridPane.add(logout, 0, 1);

        return gridPane;
    }
}