Mercurial > dive4elements > river
annotate gwt-client/src/main/java/org/dive4elements/river/client/client/ui/uinfo/SupraRegionalTablePanel.java @ 9246:c08d5cfa4981
some hibernate queries on bedheigts for salix
| author | gernotbelger |
|---|---|
| date | Thu, 12 Jul 2018 11:15:42 +0200 |
| parents | 2ea7b61797d3 |
| children | d89976700474 |
| rev | line source |
|---|---|
| 9237 | 1 /* Copyright (C) 2011, 2012, 2013 by Bundesanstalt für Gewässerkunde |
| 2 * Software engineering by Intevation GmbH | |
| 3 * | |
| 4 * This file is Free Software under the GNU AGPL (>=v3) | |
| 5 * and comes with ABSOLUTELY NO WARRANTY! Check out the | |
| 6 * documentation coming with Dive4Elements River for details. | |
| 7 */ | |
| 8 | |
| 9 package org.dive4elements.river.client.client.ui.uinfo; | |
| 10 | |
| 11 import java.util.ArrayList; | |
| 12 import java.util.List; | |
| 13 | |
| 14 import org.dive4elements.river.client.client.ui.AbstractUIProvider; | |
| 15 import org.dive4elements.river.client.client.ui.DistancePanelInputHelper; | |
| 16 import org.dive4elements.river.client.client.ui.PanelHelper; | |
| 17 import org.dive4elements.river.client.shared.model.Data; | |
| 18 import org.dive4elements.river.client.shared.model.DataItem; | |
| 19 import org.dive4elements.river.client.shared.model.DataList; | |
| 20 import org.dive4elements.river.client.shared.model.DefaultData; | |
| 21 import org.dive4elements.river.client.shared.model.DefaultDataItem; | |
| 22 import org.dive4elements.river.client.shared.model.SalixZone; | |
| 23 | |
| 24 import com.google.gwt.core.client.GWT; | |
| 25 import com.google.gwt.i18n.client.NumberFormat; | |
| 26 import com.google.gwt.user.client.ui.Label; | |
| 27 import com.smartgwt.client.data.Record; | |
| 28 import com.smartgwt.client.types.Alignment; | |
| 29 import com.smartgwt.client.util.SC; | |
| 30 import com.smartgwt.client.widgets.Button; | |
| 31 import com.smartgwt.client.widgets.Canvas; | |
| 32 import com.smartgwt.client.widgets.events.ClickEvent; | |
| 33 import com.smartgwt.client.widgets.events.ClickHandler; | |
| 34 import com.smartgwt.client.widgets.form.DynamicForm; | |
| 35 import com.smartgwt.client.widgets.form.fields.TextItem; | |
| 36 import com.smartgwt.client.widgets.grid.CellEditValueFormatter; | |
| 37 import com.smartgwt.client.widgets.grid.CellFormatter; | |
| 38 import com.smartgwt.client.widgets.grid.ListGrid; | |
| 39 import com.smartgwt.client.widgets.grid.ListGridField; | |
| 40 import com.smartgwt.client.widgets.grid.ListGridRecord; | |
| 41 import com.smartgwt.client.widgets.grid.events.CellSavedEvent; | |
| 42 import com.smartgwt.client.widgets.grid.events.CellSavedHandler; | |
| 43 import com.smartgwt.client.widgets.grid.events.RecordClickEvent; | |
| 44 import com.smartgwt.client.widgets.grid.events.RecordClickHandler; | |
| 45 import com.smartgwt.client.widgets.layout.HLayout; | |
| 46 import com.smartgwt.client.widgets.layout.Layout; | |
| 47 import com.smartgwt.client.widgets.layout.VLayout; | |
| 48 | |
| 49 public class SupraRegionalTablePanel extends AbstractUIProvider { | |
| 50 private static final long serialVersionUID = 1L; | |
| 51 | |
| 52 private Double minKm, maxKm = -1.; | |
| 53 // private String tableData = ""; | |
| 54 private ListGrid table; | |
| 55 private final String datakey = "supraregional_table"; | |
| 56 final Label validationLabel = new Label(); | |
| 57 | |
| 58 private final NumberFormat format = NumberFormat.getDecimalFormat(); | |
| 59 | |
| 60 @Override | |
| 61 public Canvas createOld(final DataList dataList) { | |
| 62 final HLayout layout = new HLayout(); | |
| 63 layout.setWidth("400px"); | |
| 64 final VLayout vLayout = new VLayout(); | |
| 65 vLayout.setWidth(130); | |
| 66 final Label label = new Label(dataList.getLabel()); | |
| 67 label.setWidth("200px"); | |
| 68 label.setHeight("25px"); | |
| 69 | |
| 70 final List<Data> items = dataList.getAll(); | |
| 71 final Data str = getData(items, this.datakey); | |
| 72 final DataItem[] strItems = str.getItems(); | |
| 73 | |
| 74 final List<SalixZone> entries = SalixZone.parse(strItems[0].getLabel()); | |
| 75 | |
| 76 for (final SalixZone entry : entries) { | |
| 77 final Label dateLabel = new Label( | |
| 78 entry.getDwsplValue() + " (" + this.format.format(entry.getFromKm()) + "-" + this.format.format(entry.getToKm()) + " km)"); | |
| 79 dateLabel.setHeight("20px"); | |
| 80 vLayout.addMember(dateLabel); | |
| 81 } | |
| 82 final Canvas back = getBackButton(dataList.getState()); | |
| 83 layout.addMember(label); | |
| 84 layout.addMember(vLayout); | |
| 85 layout.addMember(back); | |
| 86 | |
| 87 return layout; | |
| 88 } | |
| 89 | |
| 90 @Override | |
| 91 public Canvas create(final DataList data) { | |
| 92 | |
| 93 final Data dataItem = data.getAll().get(0); | |
| 94 String tableData = ""; | |
| 95 for (final DataItem item : dataItem.getItems()) { | |
| 96 final String label = item.getLabel(); | |
| 97 if (label.equals("salix_zones_min")) | |
| 98 this.minKm = Double.valueOf(item.getStringValue()); | |
| 99 else if (label.equals("salix_zones_max")) | |
| 100 this.maxKm = Double.valueOf(item.getStringValue()); | |
| 101 else if (label.equals("salix_zones")) | |
| 102 tableData = item.getStringValue(); | |
| 103 } | |
| 104 | |
| 105 if (this.minKm > this.maxKm) { | |
| 106 final double temp = this.minKm; | |
| 107 this.minKm = this.maxKm; | |
| 108 this.maxKm = temp; | |
| 109 } | |
| 110 | |
| 111 final VLayout layout = new VLayout(); | |
| 112 final Canvas submit = getNextButton(); | |
| 113 | |
| 114 final VLayout root = new VLayout(); | |
| 115 root.setWidth(420); | |
| 116 createWidget(root, data, tableData); | |
| 117 | |
| 118 layout.addMember(root); | |
| 119 layout.addMember(submit); | |
| 120 | |
| 121 validateRangeOverlap();// init Text | |
| 122 return layout; | |
| 123 } | |
| 124 | |
| 125 @Override | |
| 126 protected Data[] getData() { | |
| 127 final List<Data> data = new ArrayList<Data>(); | |
| 128 | |
| 129 final ListGridRecord[] lgr = this.table.getRecords(); | |
| 130 if (lgr == null) { | |
| 131 return new Data[0]; | |
| 132 } | |
| 133 final List<SalixZone> zoneList = getSalixZones(lgr); | |
| 134 final DataItem item = new DefaultDataItem(this.datakey, null, SalixZone.parseListToDataString(zoneList)); | |
| 135 data.add(new DefaultData(this.datakey, null, null, new DataItem[] { item })); | |
| 136 return data.toArray(new Data[data.size()]); | |
| 137 } | |
| 138 | |
| 139 private List<SalixZone> getSalixZones(final ListGridRecord[] lgr) { | |
| 140 final List<SalixZone> zoneList = new ArrayList<SalixZone>(); | |
| 141 for (final ListGridRecord element : lgr) { | |
| 142 final Record r = element; | |
| 143 final SalixZone zone = SalixZone.createFromTableEntry(r.getAttribute("dmwspl"), r.getAttribute("from"), r.getAttribute("to")); | |
| 144 zoneList.add(zone); | |
| 145 } | |
| 146 return zoneList; | |
| 147 } | |
| 148 | |
| 149 public Canvas createWidget(final Layout root, final DataList data, final String tableData) { | |
| 150 | |
| 151 this.table = createTable(root, data, tableData); | |
| 152 final TextItem dwspl = PanelHelper.createItem("_label_dwspl", this.MSG.uinfo_salix_dmwspl_short(), "50"); | |
| 153 final TextItem start = PanelHelper.createIntegerItem("_from_dwspl", getLabelFromTo(this.MSG.from()), "50"); | |
| 154 final TextItem end = PanelHelper.createIntegerItem("_to_dwspl", getLabelFromTo(this.MSG.to()), "50"); | |
| 155 | |
| 156 final HLayout fields = new HLayout(); | |
| 157 | |
| 158 final Button add = new Button(this.MSG.add_date()); // TODO: make key more generic or change to more specific | |
| 159 | |
| 160 final DynamicForm newEntryForm = new DynamicForm(); | |
| 161 newEntryForm.setWidth(320); | |
| 162 newEntryForm.setNumCols(12); | |
| 9242 | 163 newEntryForm.setFields(start, end, dwspl); |
| 9237 | 164 |
| 165 add.addClickHandler(new ClickHandler() { | |
| 166 @Override | |
| 167 public void onClick(final ClickEvent ce) { | |
| 168 final String v1 = start.getValueAsString(); | |
| 169 final String v2 = end.getValueAsString(); | |
| 170 final String v3 = dwspl.getValueAsString(); | |
| 171 final String message = validate(v1, v2, v3); | |
| 172 if (message != null) { | |
| 173 SC.warn(message); | |
| 174 return; | |
| 175 } | |
| 176 final ListGridRecord r = new ListGridRecord(); | |
| 177 r.setAttribute("dmwspl", v3); | |
| 178 r.setAttribute("from", SupraRegionalTablePanel.this.format.parse(v1)); | |
| 179 r.setAttribute("to", SupraRegionalTablePanel.this.format.parse(v2)); | |
| 180 SupraRegionalTablePanel.this.table.addData(r); | |
| 181 validateRangeOverlap(); | |
| 182 } | |
| 183 }); | |
| 184 | |
| 185 fields.addMember(newEntryForm); | |
| 186 | |
| 187 root.addMember(fields); | |
| 188 root.addMember(PanelHelper.getSpacer(10)); | |
| 189 | |
| 190 initHelperPanel(start, end); | |
| 191 | |
| 192 root.addMember(add); | |
| 193 root.addMember(PanelHelper.getSpacer(20)); | |
| 194 return root; | |
| 195 } | |
| 196 | |
| 197 private String getLabelFromTo(final String fromOrTo) { | |
| 198 return new StringBuilder().append(fromOrTo).append(" [").append(this.MSG.dpUnitFrom()).append("]").toString(); | |
| 199 } | |
| 200 | |
| 201 protected void initHelperPanel(final TextItem start, final TextItem end) { | |
| 202 final DistancePanelInputHelper helper = new DistancePanelInputHelper(this.MSG, this.helperContainer, this.getRiverName()); | |
| 203 | |
| 204 helper.getDistancesTable().addRecordClickHandler(new RecordClickHandler() { | |
| 205 @Override | |
| 206 public void onRecordClick(final RecordClickEvent e) { | |
| 207 final Record r = e.getRecord(); | |
| 208 | |
| 209 final String from = r.getAttribute("from"); | |
| 210 final String to = r.getAttribute("to"); | |
| 211 | |
| 212 try { | |
| 213 start.setValue(SupraRegionalTablePanel.this.format.format(Double.valueOf(from))); | |
| 214 end.setValue(SupraRegionalTablePanel.this.format.format(Double.valueOf(to))); | |
| 215 } | |
| 216 catch (final NumberFormatException nfe) { | |
| 217 SC.warn(SupraRegionalTablePanel.this.MSG.wrongFormat()); | |
| 218 } | |
| 219 } | |
| 220 }); | |
| 221 | |
| 222 helper.getLocationsTable().addRecordClickHandler(new RecordClickHandler() { | |
| 223 @Override | |
| 224 public void onRecordClick(final RecordClickEvent e) { | |
| 225 final Record r = e.getRecord(); | |
| 226 final int field = e.getFieldNum(); | |
| 227 | |
| 228 try { | |
| 229 final String value = r.getAttribute("from"); | |
| 230 switch (field) { | |
| 231 case 0: | |
| 232 start.setValue(SupraRegionalTablePanel.this.format.format(Double.valueOf(value))); | |
| 233 break; | |
| 234 case 1: | |
| 235 end.setValue(SupraRegionalTablePanel.this.format.format(Double.valueOf(value))); | |
| 236 break; | |
| 237 } | |
| 238 } | |
| 239 catch (final NumberFormatException nfe) { | |
| 240 SC.warn(SupraRegionalTablePanel.this.MSG.wrongFormat()); | |
| 241 } | |
| 242 } | |
| 243 }); | |
| 244 | |
| 245 } | |
| 246 | |
| 247 protected final ListGrid createTable(final Layout root, final DataList data, final String tableData) { | |
| 248 | |
| 249 final Label title = new Label(data.get(0).getDescription()); | |
| 250 title.setHeight("35px"); | |
| 251 this.validationLabel.setHeight("10px"); | |
| 9242 | 252 this.validationLabel.getElement().getStyle().setColor("red"); |
| 9237 | 253 final ListGrid elements = new ListGrid(); |
| 254 elements.setWidth(320); | |
| 255 elements.setHeight(300); | |
| 256 elements.setShowHeaderContextMenu(false); | |
| 257 elements.setCanReorderFields(false); | |
| 258 elements.setCanResizeFields(false); | |
| 259 elements.setCanEdit(true); | |
| 260 elements.setCanSort(false); | |
| 261 elements.setCanResizeFields(false); | |
| 262 | |
| 263 final ListGridField dmwsplField = new ListGridField("dmwspl", this.MSG.uinfo_salix_dmwspl_short()); | |
| 264 dmwsplField.setAlign(Alignment.RIGHT); | |
| 265 dmwsplField.setWidth(95); | |
| 266 dmwsplField.addCellSavedHandler(new CellSavedHandler() { | |
| 267 @Override | |
| 268 public void onCellSaved(final CellSavedEvent event) { | |
| 269 final Object value = event.getNewValue(); | |
| 270 event.getRecord().setAttribute("dmwspl", event.getOldValue()); | |
| 271 try { | |
| 272 final int intValue = Integer.valueOf(String.valueOf(value)); | |
| 273 event.getRecord().setAttribute("dmwspl", intValue); | |
| 274 } | |
| 275 catch (final NumberFormatException e) { | |
| 276 e.printStackTrace(); | |
| 277 } | |
| 278 } | |
| 279 }); | |
|
9246
c08d5cfa4981
some hibernate queries on bedheigts for salix
gernotbelger
parents:
9242
diff
changeset
|
280 final ListGridField fromField = createDoubleTableField("from", getLabelFromTo(this.MSG.from())); |
|
c08d5cfa4981
some hibernate queries on bedheigts for salix
gernotbelger
parents:
9242
diff
changeset
|
281 final ListGridField toField = createDoubleTableField("to", getLabelFromTo(this.MSG.to())); |
| 9237 | 282 final ListGridField removeField = PanelHelper.createRemoveField(elements, GWT.getHostPageBaseURL() + this.MSG.removeFeature()); |
| 283 elements.addRecordClickHandler(new RecordClickHandler() { // adding another custom record-Remove-Handler which is not included in the Panelhelper | |
| 284 @Override | |
| 285 public void onRecordClick(final RecordClickEvent event) { | |
| 286 if (event.getField().getName().equals(removeField.getName())) { | |
| 287 validateRangeOverlap(); | |
| 288 } | |
| 289 } | |
| 290 }); | |
| 9242 | 291 elements.setFields(fromField, toField, dmwsplField, removeField); |
| 9237 | 292 addDataInit(elements, tableData); |
| 293 | |
| 294 root.addMember(title); | |
| 295 root.addMember(elements); | |
| 296 root.addMember(PanelHelper.getSpacer(3)); | |
| 297 root.addMember(this.validationLabel); | |
| 298 root.addMember(PanelHelper.getSpacer(4)); | |
| 299 return elements; | |
| 300 } | |
| 301 | |
| 302 private void addDataInit(final ListGrid table, final String tableData) { | |
| 303 if (tableData != null) { | |
| 304 final List<SalixZone> rows = SalixZone.parse(tableData); | |
| 305 for (final SalixZone row : rows) { | |
| 306 table.addData(createEntry(row)); | |
| 307 } | |
| 308 } | |
| 309 } | |
| 310 | |
| 311 public final ListGridRecord createEntry(final SalixZone row) { | |
| 312 | |
| 313 final Integer dwspl = row.getDwsplValue(); | |
| 314 final Double from = row.getFromKm(); | |
| 315 final Double to = row.getToKm(); | |
| 316 | |
| 317 if (dwspl == null || from == null || to == null) { | |
| 318 return null; | |
| 319 } | |
| 320 | |
| 321 final ListGridRecord r = new ListGridRecord(); | |
| 322 r.setAttribute("dmwspl", dwspl); | |
| 323 r.setAttribute("from", from); | |
| 324 r.setAttribute("to", to); | |
| 325 | |
| 326 return r; | |
| 327 | |
| 328 } | |
| 329 | |
| 330 private ListGridField createDoubleTableField(final String key, final String msg) { | |
| 331 final ListGridField field = new ListGridField(key, msg); | |
| 332 field.setAlign(Alignment.RIGHT); | |
| 333 field.setWidth(90); | |
| 334 field.addCellSavedHandler(new CellSavedHandler() { | |
| 335 @Override | |
| 336 public void onCellSaved(final CellSavedEvent event) { | |
| 337 final Object value = event.getNewValue(); | |
| 338 event.getRecord().setAttribute(key, event.getOldValue()); | |
| 339 try { | |
| 340 final double d = SupraRegionalTablePanel.this.format.parse(String.valueOf(value)); | |
| 341 if (d > SupraRegionalTablePanel.this.maxKm) { | |
| 342 event.getRecord().setAttribute(key, SupraRegionalTablePanel.this.maxKm); | |
| 343 } else if (d < SupraRegionalTablePanel.this.minKm) { | |
| 344 event.getRecord().setAttribute(key, SupraRegionalTablePanel.this.minKm); | |
| 345 } else { | |
| 346 event.getRecord().setAttribute(key, d); | |
| 347 } | |
| 348 validateRangeOverlap(); | |
| 349 } | |
| 350 catch (final NumberFormatException e) { | |
| 351 e.printStackTrace(); | |
| 352 } | |
| 353 } | |
| 354 }); | |
| 355 | |
| 356 field.setEditValueFormatter(new CellEditValueFormatter() { | |
| 357 @Override | |
| 358 public Object format(final Object value, final ListGridRecord record, final int rowNum, final int colNum) { | |
| 359 if (!(value instanceof Float || value instanceof Double)) { | |
| 360 try { | |
| 361 return (float) SupraRegionalTablePanel.this.format.parse(String.valueOf(value)); | |
| 362 } | |
| 363 catch (final Exception e2) { | |
| 364 return record.getAttribute(key); | |
| 365 } | |
| 366 } else { | |
| 367 return SupraRegionalTablePanel.this.format.format((Double) value); | |
| 368 } | |
| 369 } | |
| 370 }); | |
| 371 field.setCellFormatter(new CellFormatter() { | |
| 372 @Override | |
| 373 public String format(final Object value, final ListGridRecord record, final int rowNum, final int colNum) { | |
| 374 return SupraRegionalTablePanel.this.format.format(Double.valueOf(String.valueOf(value))); | |
| 375 } | |
| 376 }); | |
| 377 return field; | |
| 378 } | |
| 379 | |
| 380 private String validate(final String fromInput, final String toInput, final String dmwspl) { | |
| 381 | |
|
9239
4e3757202d5c
salix.supraregional better error- + advance-handling
gernotbelger
parents:
9238
diff
changeset
|
382 final List<SalixZone> zones = getSalixZones(this.table.getRecords()); |
|
4e3757202d5c
salix.supraregional better error- + advance-handling
gernotbelger
parents:
9238
diff
changeset
|
383 |
| 9237 | 384 if (fromInput == null || toInput == null || dmwspl == null || fromInput.trim().isEmpty() || toInput.trim().isEmpty() || dmwspl.trim().isEmpty()) |
| 385 return this.MSG.uinfo_vegetation_zones_validation_empty(); | |
| 386 | |
| 387 try { | |
| 388 final Double from = this.format.parse(fromInput); | |
| 389 final Double to = this.format.parse(toInput); | |
| 390 Integer.valueOf(dmwspl); | |
| 391 | |
|
9239
4e3757202d5c
salix.supraregional better error- + advance-handling
gernotbelger
parents:
9238
diff
changeset
|
392 if (!SalixZone.hasGaps(zones, this.minKm, this.maxKm)) |
|
4e3757202d5c
salix.supraregional better error- + advance-handling
gernotbelger
parents:
9238
diff
changeset
|
393 return this.MSG.uinfo_salix_input_complete(); |
|
4e3757202d5c
salix.supraregional better error- + advance-handling
gernotbelger
parents:
9238
diff
changeset
|
394 |
| 9237 | 395 if (from < this.minKm || from > this.maxKm || to > this.maxKm || to < this.minKm) |
| 396 return this.MSG.uinfo_salix_km_limit_exceed(); | |
|
9238
1c756bfee472
salix.supraregional table revision -> Anschluss
gernotbelger
parents:
9237
diff
changeset
|
397 |
|
1c756bfee472
salix.supraregional table revision -> Anschluss
gernotbelger
parents:
9237
diff
changeset
|
398 // range anschluss |
|
9239
4e3757202d5c
salix.supraregional better error- + advance-handling
gernotbelger
parents:
9238
diff
changeset
|
399 if (!SalixZone.isValidAnschlussRange(from, to, zones, this.minKm)) { |
|
9238
1c756bfee472
salix.supraregional table revision -> Anschluss
gernotbelger
parents:
9237
diff
changeset
|
400 return this.MSG.uinfo_salix_km_anschluss(); |
|
1c756bfee472
salix.supraregional table revision -> Anschluss
gernotbelger
parents:
9237
diff
changeset
|
401 } |
| 9237 | 402 return null; |
| 403 } | |
| 404 catch (final NumberFormatException e) { | |
| 405 return this.MSG.wrongFormat(); | |
| 406 } | |
| 407 } | |
| 408 | |
|
9239
4e3757202d5c
salix.supraregional better error- + advance-handling
gernotbelger
parents:
9238
diff
changeset
|
409 @Override |
|
4e3757202d5c
salix.supraregional better error- + advance-handling
gernotbelger
parents:
9238
diff
changeset
|
410 public List<String> validate() { |
|
4e3757202d5c
salix.supraregional better error- + advance-handling
gernotbelger
parents:
9238
diff
changeset
|
411 final List<String> errors = new ArrayList<String>(); |
|
4e3757202d5c
salix.supraregional better error- + advance-handling
gernotbelger
parents:
9238
diff
changeset
|
412 |
| 9237 | 413 if (SalixZone.zonesAreOverlapping(this.getSalixZones(this.table.getRecords()))) |
|
9239
4e3757202d5c
salix.supraregional better error- + advance-handling
gernotbelger
parents:
9238
diff
changeset
|
414 errors.add(this.MSG.uinfo_salix_km_overlap()); |
| 9237 | 415 if (SalixZone.hasGaps(this.getSalixZones(this.table.getRecords()), this.minKm, this.maxKm)) |
|
9239
4e3757202d5c
salix.supraregional better error- + advance-handling
gernotbelger
parents:
9238
diff
changeset
|
416 errors.add(this.MSG.uinfo_salix_km_has_gaps());// "Der Km-Bereich wird nicht vollst. abgedeckt."; |
|
4e3757202d5c
salix.supraregional better error- + advance-handling
gernotbelger
parents:
9238
diff
changeset
|
417 return errors; |
|
4e3757202d5c
salix.supraregional better error- + advance-handling
gernotbelger
parents:
9238
diff
changeset
|
418 } |
| 9237 | 419 |
|
9239
4e3757202d5c
salix.supraregional better error- + advance-handling
gernotbelger
parents:
9238
diff
changeset
|
420 private void validateRangeOverlap() { |
|
4e3757202d5c
salix.supraregional better error- + advance-handling
gernotbelger
parents:
9238
diff
changeset
|
421 this.validationLabel.setText(validate().toString().replace("[", "").replace("]", "").replace(",", "")); |
| 9237 | 422 } |
| 423 } |