/*
 * 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 Controller;


import View.mouseHooverAnimationPieChart.MouseHoverAnimation;
import java.net.URL;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Iterator;
import java.util.List;
import java.util.ResourceBundle;
import javafx.beans.property.SimpleStringProperty;
import javafx.beans.value.ChangeListener;
import javafx.beans.value.ObservableValue;
import javafx.collections.FXCollections;
import javafx.collections.ObservableList;
import javafx.event.ActionEvent;
import javafx.event.EventHandler;
import javafx.fxml.FXML;
import javafx.fxml.Initializable;
import javafx.scene.Group;
import javafx.scene.chart.AreaChart;
import javafx.scene.chart.BarChart;
import javafx.scene.chart.LineChart;
import javafx.scene.chart.PieChart;
import javafx.scene.chart.XYChart;
import javafx.scene.control.ChoiceBox;
import javafx.scene.control.ComboBox;
import javafx.scene.control.ContextMenu;
import javafx.scene.control.Label;
import javafx.scene.control.MenuItem;
import javafx.scene.control.TableColumn;
import javafx.scene.control.TableView;
import javafx.scene.control.TextField;
import javafx.scene.control.cell.PropertyValueFactory;
import javafx.scene.effect.BlendMode;
import javafx.scene.input.MouseEvent;
import javafx.util.Callback;
import org.controlsfx.dialog.Dialogs;
import org.fxmisc.easybind.EasyBind;

/**
 *
 * @author Eskil
 */
public class FXMLDocumentController implements Initializable {

    SQL_manager sql_manager = new SQL_manager();

    ObservableList<List<String>> dataen = FXCollections.observableArrayList();

    List<TableColumn> lstClm = new ArrayList<TableColumn>();

    static XYChart.Series series1 = new XYChart.Series();
    static ObservableList<String> rows = FXCollections.observableArrayList();

    int userChosenDataNameColumnIndex = 0;
    int userChosenDataValueColumnIndex = 0;

    @FXML
    protected Label caption;
    @FXML
    protected TextField filterField;
    @FXML
    TableView tableView;
    @FXML
    LineChart lineChart;
    @FXML
    AreaChart bubbleChart;
    @FXML
    TextField t;
    @FXML
    TableView tableView2;
    @FXML
    ChoiceBox choiceBoxTable;
    @FXML
    ChoiceBox choiceBoxName;
    @FXML
    ChoiceBox choiceBoxValue;
    @FXML
    protected BarChart barChart;
    @FXML
    protected TableColumn Month;
    @FXML
    protected TableColumn Value;
    @FXML
    protected PieChart pieChart;

    @FXML
    protected TextField txtIPadress;
    @FXML
    protected TextField txtPortNumber;
    @FXML
    protected TextField txtSQLinstance;
    @FXML
    protected Group visualizationGroup;
    @FXML
    protected Group dataSelectGroup;
    @FXML
    protected Group sqlConnectGroup;

    @FXML
    protected void handleButtonAction(ActionEvent event) throws ClassNotFoundException, SQLException {
        Connection conn = sql_manager.getConnection("localhost", 8889, "mysql");
        sql_manager.getAllTables(choiceBoxTable);

        System.out.println("her kommern ut 1");

    }
    public void hideShowGroupsAndElements(Boolean barChartTrueFalse, Boolean pieChartTrueFalse, Boolean lineChartTrueFalse, Boolean visualizationGroupTrueFalse, Boolean dataSelectGroupTrueFalse, Boolean sqlConnectGroupTrueFalse) {

        visualizationGroup.visibleProperty().set(visualizationGroupTrueFalse);
        dataSelectGroup.visibleProperty().set(dataSelectGroupTrueFalse);
        sqlConnectGroup.visibleProperty().set(sqlConnectGroupTrueFalse);

        barChart.visibleProperty().set(barChartTrueFalse);
        pieChart.visibleProperty().set(pieChartTrueFalse);
        lineChart.visibleProperty().set(lineChartTrueFalse);
    }

    @FXML
    protected void btnSQlConnect(ActionEvent event) throws ClassNotFoundException, SQLException {
       hideShowGroupsAndElements(Boolean.FALSE, Boolean.FALSE, Boolean.FALSE, Boolean.FALSE, Boolean.FALSE, Boolean.TRUE);

    }

    @FXML
    protected void btnDataSelect(ActionEvent event) throws ClassNotFoundException, SQLException {
        hideShowGroupsAndElements(Boolean.FALSE, Boolean.FALSE, Boolean.FALSE, Boolean.FALSE, Boolean.TRUE, Boolean.FALSE);

    }

    @FXML
    protected void handleButtonAction5(ActionEvent event) throws SQLException, ClassNotFoundException {
        Connection conn = sql_manager.getConnection(txtIPadress.getText(), Integer.parseInt(txtPortNumber.getText()), txtSQLinstance.getText());
        sql_manager.getAllTables(choiceBoxTable);

    }

    @FXML
    protected void handleButtonAction1(ActionEvent event) throws SQLException, ClassNotFoundException {
        //filterData();
    }

    @FXML
    protected void handleButtonPieChart(ActionEvent event) throws SQLException, ClassNotFoundException {
        hideShowGroupsAndElements(Boolean.FALSE, Boolean.TRUE, Boolean.FALSE, Boolean.TRUE, Boolean.FALSE, Boolean.FALSE);

        if (checkWhichIndexOnUserSelectedColumns() == true) {
            getPieChartData(userChosenDataValueColumnIndex, userChosenDataNameColumnIndex);
        }

    }

    @FXML
    protected void handleButtonBubbleChart(ActionEvent event) throws SQLException, ClassNotFoundException {
      hideShowGroupsAndElements(Boolean.FALSE, Boolean.FALSE, Boolean.TRUE, Boolean.TRUE, Boolean.FALSE, Boolean.FALSE);

        if (checkWhichIndexOnUserSelectedColumns() == true) {
            getBubbleChart(userChosenDataValueColumnIndex, userChosenDataNameColumnIndex);
        }

    }

    @FXML
    protected void handeButtonBarChart(ActionEvent event) throws SQLException, ClassNotFoundException {
      hideShowGroupsAndElements(Boolean.TRUE, Boolean.FALSE, Boolean.FALSE, Boolean.TRUE, Boolean.FALSE, Boolean.FALSE);
        if (checkWhichIndexOnUserSelectedColumns() == true) {
            getBarChartData(userChosenDataValueColumnIndex, userChosenDataNameColumnIndex);
        }

    }

    @FXML
    protected void handleButtonLineChart(ActionEvent event) throws SQLException, ClassNotFoundException {
       hideShowGroupsAndElements(Boolean.FALSE, Boolean.FALSE, Boolean.TRUE, Boolean.TRUE, Boolean.FALSE, Boolean.FALSE);
        if (checkWhichIndexOnUserSelectedColumns() == true) {
            getLineChartData(userChosenDataValueColumnIndex, userChosenDataNameColumnIndex);
        }

    }



    private boolean checkWhichIndexOnUserSelectedColumns() throws NumberFormatException {

        Iterator itr = lstClm.iterator();
        int counter = 0;
        Boolean thereIsAValue = false;
        Boolean thereIsAName = false;
        Boolean thereIsOnlyTwo = true;
        while (itr.hasNext()) {
            if (counter > 1) {
                thereIsOnlyTwo = false;
                System.out.println("FEIL");
            } else {
                if (lstClm.get(counter).getUserData() == "Value") {
                    thereIsAValue = true;
                    userChosenDataValueColumnIndex = Integer.parseInt(lstClm.get(counter).getId());

                } else if ((lstClm.get(counter).getUserData() == "Name")) {
                    thereIsAName = true;
                    userChosenDataNameColumnIndex = Integer.parseInt(lstClm.get(counter).getId());
                }
            }
            counter++;
            itr.next();
        }
        if (thereIsAName == true && thereIsAValue == true && thereIsOnlyTwo == true) {
            return true;
        }
        Dialogs.create()
                .title("Feil i datavalg")
                .message("Du har valgt en feil i tabellen. Det må kun velges ett felt med navn og ett med verdier")
                .showInformation();
        visualizationGroup.visibleProperty().set(false);
        dataSelectGroup.visibleProperty().set(true);
        sqlConnectGroup.visibleProperty().set(false);

        return false;
    }

    @Override
    public void initialize(URL url, ResourceBundle rb) {
        /* MÅ være med for å binde radene i TableView til standardverdiene */
        Month.setCellValueFactory(new PropertyValueFactory("fieldMonth"));
        Value.setCellValueFactory(new PropertyValueFactory("fieldValue"));
        tableView.setItems(dataen);
        /* Added functionality for filtering */
        filterField.textProperty().addListener((ObservableValue<? extends String> observable, String oldValue, String newValue) -> {
        });
        ContextMenu menu = new ContextMenu();
        MenuItem item = new MenuItem("Filter");
        item.setOnAction(new EventHandler<ActionEvent>() {
            @Override
            public void handle(ActionEvent event) {
            }
        });
        menu.getItems().add(item);
        tableView.setContextMenu(menu);

        addListenerToChoiceBox(choiceBoxTable);

    }

    private void addListenerToChoiceBox(ChoiceBox choicebox) {
        //adding a listener to the coicebox to pull out the choice the user selected
        choicebox.valueProperty().addListener(new ChangeListener() {
            @Override
            public void changed(ObservableValue observable, Object oldValue, Object newValue) {
                String newSelection = (String) newValue;
                try {
                    getDataForSelectedTable(newSelection);
                } catch (SQLException ex) {

                }
                System.out.println("choiceBoxSelected by Listener: " + newSelection);
            }
        });
    }



    private void getDataForSelectedTable(String tableName) throws SQLException {
        // henter ut all data for en spesifikk tabell.
        tableView.getColumns().removeAll(tableView.getColumns());

        String SQL = "SELECT * FROM " + tableName;
        ResultSet rs = sql_manager.getDataFromSQL("localhost", 8889, "mysql", SQL);

        //først henter vi ut alle kolonnene og legger til de i tableview
        for (int i = 0; i < rs.getMetaData().getColumnCount(); i++) {
            //We are using non property style for making dynamic table
            System.out.print("her kommern " + i);
            final int j = i;
            TableColumn col = new TableColumn(rs.getMetaData().getColumnName(i + 1));
            System.out.println(col);
            col.setCellValueFactory(new Callback<TableColumn.CellDataFeatures<ObservableList, String>, ObservableValue<String>>() {
                public ObservableValue<String> call(TableColumn.CellDataFeatures<ObservableList, String> param) {
                    return new SimpleStringProperty(param.getValue().get(j).toString());
                }
            });

            col.setId((String.valueOf(i)));
            col.prefWidthProperty().bind(tableView.widthProperty().divide(4)); //for å automatisere bredden på kolonnene
            //col.setGraphic(new CheckBox());
            tableView.getColumns().addAll(col);
            addCheckBoxesToColumns(col);

        }

        //deretter legges all dataen til i kolonnene ved hjelp av rader
        while (rs.next()) {
            ObservableList<String> row = FXCollections.observableArrayList();
            for (int i = 1; i <= rs.getMetaData().getColumnCount(); i++) {
                if (rs.getString(i) != null) {
                    row.add(rs.getString(i));
                    rows.add(rs.getString(i));

                    System.out.println(rs.getString(i));
                } else {
                    row.add(" ");
                }

            }
            dataen.add(row);
        }

        tableView.setItems(dataen);

    }

    private void addCheckBoxesToColumns(TableColumn col) {
        EventHandler<ActionEvent> handler = new EventHandler<ActionEvent>() {

            @Override
            public void handle(ActionEvent event) {
                ComboBox cb = (ComboBox) event.getSource();
                TableColumn column = (TableColumn) cb.getUserData();

                if (cb.getValue() == " ") {
                    lstClm.remove(column);
                } else {
                    lstClm.remove(column);
                    column.setUserData(cb.getValue().toString());
                    System.out.println("kanskje her? " + column.getUserData());
                    System.out.println(column + " " + column.getId());

                    lstClm.add(column);
                }

            }
        };
        ComboBox cb = new ComboBox();
        cb.getItems().add("Name");
        cb.getItems().add("Value");
        cb.getItems().add(" ");
        cb.setUserData(col);
        cb.setOnAction(handler);
        col.setGraphic(cb);

    }

    protected void getPieChartData(Integer userChosenDataValueColumnIndex, Integer userChosenDataNameColumnIndex) {

        System.out.println("Kolonne id for data er " + userChosenDataValueColumnIndex + "Kolonne id for name er " + userChosenDataNameColumnIndex);
        ObservableList<PieChart.Data> pieChartData
                = FXCollections.observableArrayList(EasyBind.map(dataen, rowData -> {
                    String name = (String) rowData.get(userChosenDataNameColumnIndex);
                    int value = Integer.parseInt(rowData.get(userChosenDataValueColumnIndex));
                    return new PieChart.Data(name, value);
                }));
        System.out.println("aa " + pieChartData.get(0));
        pieChart.setData(pieChartData);

        for (PieChart.Data d : pieChartData) {
          //  d.getNode().setOnMouseClicked(new MouseHoverAnimation(d, pieChart, caption));
         //   d.getNode().setUserData(d.getPieValue());
            d.getNode().setBlendMode(BlendMode.SRC_ATOP);
          d.getNode().addEventHandler(MouseEvent.MOUSE_ENTERED,
    new EventHandler<MouseEvent>() {
        @Override public void handle(MouseEvent e) {
           System.out.println("blabla");
         }
    });
        }
    }



    protected void getBarChartData(Integer userChosenDataValueColumnIndex, Integer userChosenDataNameColumnIndex) {

        ObservableList<XYChart.Data<String, Number>> barChartData = EasyBind.map(dataen, rowData -> {
            String name = rowData.get(userChosenDataNameColumnIndex);
            Double value = new Double(rowData.get(userChosenDataValueColumnIndex));
            return new XYChart.Data(name, value);
        });

        XYChart.Series series1 = new XYChart.Series();
        series1.getData().addAll(barChartData);
        barChart.getData().addAll(series1);

        //series1.getData().clear();
        // series1.getData().add(new XYChart.Data(itr.next(), dataen.get(1)));
        barChart.setData(FXCollections.observableArrayList(series1));
    }

    protected void getBubbleChart(Integer userChosenDataValueColumnIndex, Integer userChosenDataNameColumnIndex) {
        //in the making. Bubblechart må ha to int verdier, ikke en name og en value.
        ObservableList<XYChart.Data<String, Number>> bubbleChartData = EasyBind.map(dataen, rowData -> {
            Double name = new Double(rowData.get(1));
            Double value = new Double(rowData.get(4));
            return new XYChart.Data(name, value);
        });

        XYChart.Series series1 = new XYChart.Series();
        series1.getData().addAll(bubbleChartData);
        bubbleChart.getData().addAll(series1);

        //series1.getData().clear();
        // series1.getData().add(new XYChart.Data(itr.next(), dataen.get(1)));
        bubbleChart.setData(FXCollections.observableArrayList(series1));

    }

    protected void getLineChartData(Integer userChosenDataValueColumnIndex, Integer userChosenDataNameColumnIndex) {

        ObservableList<XYChart.Data<String, Number>> barChartData = EasyBind.map(dataen, rowData -> {
            String name = rowData.get(userChosenDataNameColumnIndex);
            Double value = new Double(rowData.get(userChosenDataValueColumnIndex));
            return new XYChart.Data(name, value);
        });
        XYChart.Series series1 = new XYChart.Series();
        series1.getData().addAll(barChartData);
        lineChart.getData().addAll(series1);

        //series1.getData().clear();
        // series1.getData().add(new XYChart.Data(itr.next(), dataen.get(1)));
        lineChart.setData(FXCollections.observableArrayList(series1));
    }


}