@Override public CellData copy() throws AWException { return new CellData(this); }
/** * Retrieve data row from resultset * @param rowIndex Row index * @param columnTotal Column total * @param metaData Metadata * @param resultSet Resultset * @return Data row * @throws SQLException Error retrieving data row */ private Map<String, CellData> getDataRow(Integer rowIndex, Integer columnTotal, ResultSetMetaData metaData, ResultSet resultSet) throws SQLException { Map<String, CellData> row = new HashMap<>(); row.put("id", new CellData(rowIndex)); for (int i = 1; i <= columnTotal; i++) { String cell = resultSet.getString(metaData.getColumnName(i)); row.put(metaData.getColumnName(i), new CellData(cell)); } return row; }
/** * Add a column with one row value * * @param list DataList * @param columnName Column name (alias) * @param cellValue Cell value */ public static void addColumnWithOneRow(DataList list, String columnName, String cellValue) { // Add cell to row addCellToRow(list, columnName, 0, new CellData(cellValue)); }
/** * Adds a parameter * * @param name Parameter name * @param value Parameter value * @return this */ public ClientAction addParameter(String name, Object value) { return addParameter(name, new CellData(value)); }
/** * Add a column with one row value * * @param list DataList * @param columnName Column name (alias) * @param cellValue Cell value */ public static void addColumnWithOneRow(DataList list, String columnName, Object cellValue) { // Add cell to row addCellToRow(list, columnName, 0, new CellData(cellValue)); }
/** * Add a column with one row value * * @param list DataList * @param columnName Column name (alias) * @param cellValue Cell value */ public static void addColumnWithOneRow(DataList list, String columnName, Date cellValue) { // Add cell to row addCellToRow(list, columnName, 0, new CellData(cellValue)); }
/** * Adds a variable to the map * * @param name Variable name * @param value Variable value * @return this */ public ServiceData addVariable(String name, String value) { this.getVariableMap().put(name, new CellData(value)); return this; }
/** * Add a column with one row value * * @param list DataList * @param columnName Column name (alias) * @param cellValue Cell value */ public static void addColumnWithOneRow(DataList list, String columnName, Integer cellValue) { // Add cell to row addCellToRow(list, columnName, 0, new CellData(cellValue)); }
/** * Add a column with one row value * * @param list DataList * @param columnName Column name (alias) * @param cellValue Cell value */ public static void addColumnWithOneRow(DataList list, String columnName, Double cellValue) { // Add cell to row addCellToRow(list, columnName, 0, new CellData(cellValue)); }
/** * Add a column with one row value * * @param list DataList * @param columnName Column name (alias) * @param cellValue Cell value */ public static void addColumnWithOneRow(DataList list, String columnName, Long cellValue) { // Add cell to row addCellToRow(list, columnName, 0, new CellData(cellValue)); }
/** * Add a column with one row value * * @param list DataList * @param columnName Column name (alias) * @param cellValue Cell value */ public static void addColumnWithOneRow(DataList list, String columnName, Float cellValue) { // Add cell to row addCellToRow(list, columnName, 0, new CellData(cellValue)); }
/** * Copy constructor * * @param other */ public DataList(DataList other) { this.total = other.total; this.page = other.page; this.records = other.records; if (other.rows != null) { this.rows = new ArrayList<>(); for (Map<String, CellData> row : other.rows) { Map newRow = new HashMap<>(); for (Map.Entry<String, CellData> cell : row.entrySet()) { newRow.put(cell.getKey(), new CellData(cell.getValue())); } this.rows.add(newRow); } } }
/** * Retrieve a column data * * @param list DataList * @param columnName Column name (alias) * @return Column object list */ public static List<CellData> getColumn(DataList list, String columnName) { List<CellData> columnData = new ArrayList<>(); // Add alias row by row for (Map<String, CellData> row : list.getRows()) { columnData.add(new CellData(row.get(columnName))); } return columnData; }
/** * Retrieve the parameter as CellData * * @param parameter Parameter * @return Parameter as celldata */ public CellData getParameterAsCellData(JsonNode parameter) { CellData parameterValue; if (parameter.isNull()) { parameterValue = new CellData(); } else if (parameter.isInt()) { parameterValue = new CellData(parameter.asInt()); } else if (parameter.isLong()) { parameterValue = new CellData(parameter.asLong()); } else if (parameter.isFloat()) { parameterValue = new CellData(parameter.floatValue()); } else if (parameter.isDouble()) { parameterValue = new CellData(parameter.doubleValue()); } else if (parameter.isBoolean()) { parameterValue = new CellData(parameter.booleanValue()); } else if (parameter.isTextual()) { parameterValue = new CellData(parameter.asText()); } else { parameterValue = new CellData(parameter); } return parameterValue; }
/** * Set column Name and it's value per line * * @param list DataList * @param columnName Column name (alias) * @param defaultValue Default value */ public static void addColumn(DataList list, String columnName, String defaultValue) { CellData cell; // Add alias row by row for (Map<String, CellData> row : list.getRows()) { // Define cell cell = new CellData(); // Add default value if (defaultValue != null) { cell.setValue(defaultValue); } // Store cell row.put(columnName, cell); } }
/** * Delete columns from grid * * @return clientActionList */ public ServiceData deleteColumns() { // Variable initialization ServiceData serviceData = new ServiceData(); // Columns List<Column> columns = new ArrayList<>(); Column column = new Column(); column.setId("NONE"); columns.add(column); // Add columns to the multiselect grid ClientAction addColumnsGrid = new ClientAction("replace-columns"); addColumnsGrid.setTarget(SELECTED_GRID); addColumnsGrid.addParameter("columns", new CellData(columns)); serviceData.addClientAction(addColumnsGrid); return serviceData; }
/** * Switch the languages * * @param fromLanguage Source language * @param toLanguage Target language * @param fromTarget Source target * @param toTarget Target target * @return Languages changed */ public ServiceData switchLanguages(String fromLanguage, String toLanguage, String fromTarget, String toTarget) { ServiceData serviceData = new ServiceData(); JsonNodeFactory factory = JsonNodeFactory.instance; ArrayNode from = factory.arrayNode(); ArrayNode to = factory.arrayNode(); // Add the values from.add(toLanguage); to.add(fromLanguage); // Select value action ClientAction fromAction = new ClientAction(SELECT); fromAction.addParameter(VALUES, new CellData(from)); fromAction.setTarget(fromTarget); // Select format action ClientAction toAction = new ClientAction(SELECT); toAction.addParameter(VALUES, new CellData(to)); toAction.setTarget(toTarget); // Add actions to list serviceData.addClientAction(fromAction); serviceData.addClientAction(toAction); return serviceData; }
/** * Fill grid with data * * @param rsMetaData Metadata * @param datalist Datalist * @return Client actions * @throws AWException Error filling grid */ private ServiceData fillGrid(ResultSetMetaData rsMetaData, DataList datalist) throws AWException { // Variable initialization ServiceData serviceData = new ServiceData(); try { // Build column structure List<Column> columns = getColumnList(rsMetaData); // Add columns to the multiselect grid ClientAction addColumnsGrid = new ClientAction("replace-columns"); addColumnsGrid.setTarget(SELECTED_GRID); addColumnsGrid.addParameter("columns", new CellData(columns)); // Fill Grid ClientAction fillGrid = new ClientAction("fill"); fillGrid.setTarget(SELECTED_GRID); fillGrid.addParameter("datalist", datalist); // Set variables serviceData.addClientAction(addColumnsGrid); serviceData.addClientAction(fillGrid); } catch (AWException exc) { throw new AWException(getLocale("ERROR_TITLE_SESSION_EXPIRED"), getLocale("ERROR_MESSAGE_SESSION_EXPIRED"), exc); } return serviceData; }