Revize 403c9955

re #7885 basic contingency table generation (not completely finished)

src/main/java/vldc/aswi/model/table/NameUserName.java

@@ +1 @@
+package vldc.aswi.model.table;
+
+public class NameUserName {
+
+    private String name;
+    private String userName;
+
+    public NameUserName(String name, String userName) {
+        this.name = name;
+        this.userName = userName;
+    }
+
+    public String getName() {
+        return name;
+    }
+
+    public void setName(String name) {
+        this.name = name;
+    }
+
+    public String getUserName() {
+        return userName;
+    }
+
+    public void setUserName(String userName) {
+        this.userName = userName;
+    }
+}

src/main/java/vldc/aswi/model/table/Node.java

@@ +1 @@
+package vldc.aswi.model.table;
+
+import java.util.ArrayList;
+import java.util.Collection;
+import java.util.List;
+
+public class Node {
+
+    private List<String> values;
+
+    public Node() {
+        this.values = new ArrayList<>();
+    }
+
+    public Node(Node node) {
+        this.values = new ArrayList<>(node.values);
+    }
+
+    public List<String> getValues() {
+        return values;
+    }
+
+    public void setValues(List<String> values) {
+        this.values = values;
+    }
+}

src/main/java/vldc/aswi/model/table/ValueFunction.java

@@ +1 @@
+package vldc.aswi.model.table;
+
+public class ValueFunction {
+
+    private String value;
+    private String function;
+
+    public ValueFunction(String value, String function) {
+        this.value = value;
+        this.function = function;
+    }
+
+    public String getValue() {
+        return value;
+    }
+
+    public void setValue(String value) {
+        this.value = value;
+    }
+
+    public String getFunction() {
+        return function;
+    }
+
+    public void setFunction(String function) {
+        this.function = function;
+    }
+}

src/main/java/vldc/aswi/service/SqlQueryManagerImpl.java

@@ -4 +4 @@
 import org.springframework.beans.factory.annotation.Autowired;
 import org.springframework.stereotype.Service;
 import vldc.aswi.database.DatabaseInterface;
+import vldc.aswi.model.table.NameUserName;
 import vldc.aswi.model.table.TableColumn;
+import vldc.aswi.model.table.ValueFunction;
 import vldc.aswi.model.table.contingencyTable.ContingencyTableRow;
 import vldc.aswi.utils.Converter;
 
 import javax.sql.DataSource;
+import java.util.ArrayList;
 import java.util.List;
 import java.util.Map;
 
@@ -31 +34 @@
     @Override
     public List<ContingencyTableRow> getContingencyTableRow(String sqlQuery) {
         Map<String, TableColumn> tableColumns = this.databaseInterface.executeQueryAndReturnTableColumns(sqlQuery);
-        return Converter.convertTableColumnsToContingencyTableRows(tableColumns);
+        List<NameUserName> rowNames = new ArrayList<>();
+        rowNames.add(new NameUserName("PROGRAM_STUDIA", "d"));
+        rowNames.add(new NameUserName("TYP_STUDIA", "d"));
+
+        List<NameUserName> columnNames = new ArrayList<>();
+        columnNames.add(new NameUserName("FAKULTA_STUDIA", "d"));
+        columnNames.add(new NameUserName("FORMA_STUDIA", "d"));
+
+        List<ValueFunction> valueFunctions = new ArrayList<>();
+        valueFunctions.add(new ValueFunction("VEK", "d"));
+        Converter c = new Converter();
+        return c.convertTableColumnsToContingencyTableRows(tableColumns, rowNames, columnNames, valueFunctions);
     }
 
     /**

src/main/java/vldc/aswi/utils/Converter.java

@@ -1 +1 @@
 package vldc.aswi.utils;
 
+import vldc.aswi.model.table.NameUserName;
+import vldc.aswi.model.table.Node;
 import vldc.aswi.model.table.TableColumn;
+import vldc.aswi.model.table.ValueFunction;
 import vldc.aswi.model.table.contingencyTable.ContingencyTableRow;
 import vldc.aswi.model.table.contingencyTable.ContingencyTableRowCell;
 
@@ -13 +16 @@
  */
 public class Converter {
 
+    private List<Node> rowNodes;
+    private List<Node> columnNodes;
+
     /**
      * Convert Map of TableColumns into list of ContingencyTableRow.
      * @param tableColumns - Map of TableColumn.
      * @return List of ContingencyTableRow.
      */
-    public static List<ContingencyTableRow> convertTableColumnsToContingencyTableRows(Map<String, TableColumn> tableColumns) {
+    public List<ContingencyTableRow> convertTableColumnsToContingencyTableRows(Map<String, TableColumn> tableColumns,
+                                                                                      List<NameUserName> rowNames,
+                                                                                      List<NameUserName> columnNames,
+                                                                                      List<ValueFunction> valueFunctions) {
+        /*
         List<ContingencyTableRow> contingencyTableRows = new ArrayList<>();
 
         // Create header row with column names.
@@ -50 +60 @@
             }
         }
 
+          */
+        List<ContingencyTableRow> contingencyTableRows = new ArrayList<>();
+
+        List<ContingencyTableRow> headerRows = createHeaderOnlyRows(tableColumns, columnNames);
+        List<ContingencyTableRow> dataRows = createDataRows(tableColumns, columnNames, rowNames, valueFunctions);
+
+        contingencyTableRows.addAll(headerRows);
+        contingencyTableRows.addAll(dataRows);
+
         return contingencyTableRows;
     }
+
+    private List<ContingencyTableRow> createHeaderOnlyRows(Map<String, TableColumn> tableColumns, List<NameUserName> columnNames) {
+        List<List<String>> values = new ArrayList<>();
+        columnNodes = new ArrayList<>();
+        List<ContingencyTableRow> headerRows = new ArrayList<>();
+        for(NameUserName nameUserName : columnNames) {
+            TableColumn column = tableColumns.get(nameUserName.getName());
+            values.add(getOriginalValuesFromList(column.getValues()));
+            headerRows.add(new ContingencyTableRow(true, 0));
+        }
+
+        Node node = new Node();
+        generateColumns(0, values, columnNodes, node);
+
+        for (int i = 0; i < values.size(); i++) {
+            int colSpan = 1;
+            for (int j = values.size() - 1; j > i; j--) {
+                if (values.size() - 1 == j) {
+                    colSpan = values.get(j).size();
+                }
+                else {
+                    colSpan = (colSpan + 1) * values.get(j).size();
+                }
+            }
+            int loopCount = 1;
+            for (int k = 0; k < i; k++) {
+                loopCount = loopCount * values.get(k).size();
+            }
+            headerRows.get(i).addTableRowCell(new ContingencyTableRowCell("", 1));
+            for (int k = 0; k < loopCount; k++) {
+                for (String value : values.get(i)) {
+                    headerRows.get(i).addTableRowCell(new ContingencyTableRowCell(value, colSpan));
+                    if (i != values.size() - 1) {
+                        headerRows.get(i).addTableRowCell(new ContingencyTableRowCell(value + " Celkem", 1));
+                    }
+                }
+
+                for (int l = 0; l < i; l++) {
+                    headerRows.get(i).addTableRowCell(new ContingencyTableRowCell("", 1));
+                }
+            }
+            if (i == 0) {
+                headerRows.get(i).addTableRowCell(new ContingencyTableRowCell("Celkový počet", 1));
+            }
+        }
+
+        return headerRows;
+    }
+
+    private List<String> getOriginalValuesFromList(List<String> list) {
+        List<String> origList = new ArrayList<>();
+
+        for (String string : list) {
+            if (origList.stream().noneMatch(s -> s.equals(string))) {
+                origList.add(string);
+            }
+        }
+
+        return origList;
+    }
+
+    private List<ContingencyTableRow> createDataRows(Map<String, TableColumn> tableColumns, List<NameUserName> columnNames,
+                                                     List<NameUserName> rowNames, List<ValueFunction> valueFunctions) {
+        List<ContingencyTableRow> dataRows = new ArrayList<>();
+        rowNodes = new ArrayList<>();
+        List<List<String>> values = new ArrayList<>();
+        for(NameUserName nameUserName : rowNames) {
+            TableColumn column = tableColumns.get(nameUserName.getName());
+            values.add(getOriginalValuesFromList(column.getValues()));
+        }
+
+        Node node = new Node();
+        generateRows(dataRows, 0, values, rowNodes, node);
+
+        for (int i = 0; i < dataRows.size(); i++) {
+            fillRowWithCountData(dataRows.get(i), tableColumns, rowNodes.get(i), rowNames, columnNames, valueFunctions);
+        }
+
+        return dataRows;
+    }
+
+    private void generateRows(List<ContingencyTableRow> rows, int index, List<List<String>> values, List<Node> rowNodes,
+                              Node prevNode) {
+        if (index < values.size()) {
+            List<String> list = values.get(index);
+            for (String s : list) {
+                StringBuilder levelString = new StringBuilder();
+                for (int i = 0; i < index; i++) {
+                    levelString.append("\t");
+                }
+                levelString.append(s);
+                ContingencyTableRow row = new ContingencyTableRow(false, index);
+                row.addTableRowCell(new ContingencyTableRowCell(levelString.toString(), 1));
+                rows.add(row);
+                Node node = new Node(prevNode);
+                node.getValues().add(s);
+                rowNodes.add(node);
+                int newIndex = index + 1;
+                generateRows(rows, newIndex, values, rowNodes, node);
+            }
+        }
+    }
+
+    private void generateColumns(int index, List<List<String>> values, List<Node> columnNodes, Node prevNode) {
+        if (index < values.size()) {
+            List<String> list = values.get(index);
+            for (String s : list) {
+                Node node = new Node(prevNode);
+                node.getValues().add(s);
+                int newIndex = index + 1;
+                generateColumns(newIndex, values, columnNodes, node);
+                columnNodes.add(node);
+            }
+        }
+    }
+
+    private void fillRowWithCountData(ContingencyTableRow row, Map<String, TableColumn> tableColumns, Node node,
+                                      List<NameUserName> rowNames, List<NameUserName> columnNames, List<ValueFunction> valueFunctions) {
+        //sloupec v kont. tabulce
+        for (Node columnNode : columnNodes) {
+            int count = 0;
+            // radek v orig. tabulce
+            for (int i = 0; i < tableColumns.get(rowNames.get(0).getName()).getValues().size(); i++) {
+                boolean isUsable = true;
+                //zvoleny sloupec z radku
+                for (int j = 0; j < node.getValues().size(); j++) {
+                    if (!tableColumns.get(rowNames.get(j).getName()).getValues().get(i).equals(node.getValues().get(j))) {
+                        isUsable = false;
+                        break;
+                    }
+                }
+                // zvoleny sloupec ze sloupcu
+                for (int j = 0; j < columnNode.getValues().size(); j++) {
+                    if (!tableColumns.get(columnNames.get(j).getName()).getValues().get(i).equals(columnNode.getValues().get(j))) {
+                        isUsable = false;
+                        break;
+                    }
+                }
+                // zvoleny sloupec z hodnot
+                for (ValueFunction valueFunction : valueFunctions) {
+                    if (tableColumns.get(valueFunction.getValue()).getValues().get(i) == null) {
+                        isUsable = false;
+                        break;
+                    }
+                }
+
+                if (isUsable) {
+                    count++;
+                }
+            }
+
+            row.addTableRowCell(new ContingencyTableRowCell(Integer.toString(count), 0));
+        }
+    }
 }

src/main/java/vldc/aswi/web/controller/ConfigurationController.java

@@ -17 +17 @@
 import vldc.aswi.domain.Operator;
 import vldc.aswi.domain.parameter.ParameterInConfiguration;
 import vldc.aswi.service.ConfigurationManager;
+import vldc.aswi.service.SqlQueryManager;
 import vldc.aswi.utils.AuthControl;
 import vldc.aswi.utils.Utils;
 
@@ -31 +32 @@
 @Controller
 public class ConfigurationController extends BasicController{
 
+    /** Autowired sql query manager. */
+    @Autowired
+    private SqlQueryManager sqlQueryManager;
+
     /** Autowired configuration manager */
     @Autowired
     private ConfigurationManager configurationManager;
@@ -91 +96 @@
             return modelAndView;
         }
 
+
+
         Configuration configuration = configurationManager.saveConfiguration(newConfiguration, id);
 
+        this.sqlQueryManager.getContingencyTableRow(configuration.getAssembly().getSQLQuery());
+
         initializeFields(configuration);
 
         modelAndView.setViewName("redirect:/configuration?configurationID=" + configuration.getId());