annotate flys-artifacts/src/main/java/de/intevation/flys/exports/WaterlevelExporter.java @ 3252:62c9bcef0680

Fix issue705 (maín value names also in w/q-range mode). flys-artifacts/trunk@4886 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author Felix Wolfsteller <felix.wolfsteller@intevation.de>
date Fri, 06 Jul 2012 12:24:44 +0000
parents f8a1a8af338e
children 1a9ab048573a
rev   line source
389
69d05357c177 Added an exporter (OutGenerator) for waterlevels which currently supports CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
1 package de.intevation.flys.exports;
69d05357c177 Added an exporter (OutGenerator) for waterlevels which currently supports CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
2
446
c0bec245f608 Implemented writer that creates WSTs and enabled the WaterlevelExporter to create those.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 445
diff changeset
3 import java.io.IOException;
389
69d05357c177 Added an exporter (OutGenerator) for waterlevels which currently supports CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
4 import java.io.OutputStream;
2045
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
5 import java.text.DateFormat;
418
e0fec407a280 ISSUE-53 Formatted number values of CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 416
diff changeset
6 import java.text.NumberFormat;
389
69d05357c177 Added an exporter (OutGenerator) for waterlevels which currently supports CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
7 import java.util.ArrayList;
2176
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
8 import java.util.Map;
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
9 import java.util.HashMap;
2045
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
10 import java.util.Date;
389
69d05357c177 Added an exporter (OutGenerator) for waterlevels which currently supports CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
11 import java.util.List;
2045
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
12 import java.util.Locale;
2035
3ebbe497d7f7 #252 Set titles in waterlevel exports to named main values if those are existing for given Q values.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 749
diff changeset
13 import java.util.regex.Matcher;
3ebbe497d7f7 #252 Set titles in waterlevel exports to named main values if those are existing for given Q values.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 749
diff changeset
14 import java.util.regex.Pattern;
389
69d05357c177 Added an exporter (OutGenerator) for waterlevels which currently supports CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
15
69d05357c177 Added an exporter (OutGenerator) for waterlevels which currently supports CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
16 import org.w3c.dom.Document;
69d05357c177 Added an exporter (OutGenerator) for waterlevels which currently supports CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
17
69d05357c177 Added an exporter (OutGenerator) for waterlevels which currently supports CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
18 import org.apache.log4j.Logger;
69d05357c177 Added an exporter (OutGenerator) for waterlevels which currently supports CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
19
69d05357c177 Added an exporter (OutGenerator) for waterlevels which currently supports CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
20 import au.com.bytecode.opencsv.CSVWriter;
69d05357c177 Added an exporter (OutGenerator) for waterlevels which currently supports CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
21
2176
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
22 import net.sf.jasperreports.engine.JasperExportManager;
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
23 import net.sf.jasperreports.engine.JasperFillManager;
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
24 import net.sf.jasperreports.engine.JasperPrint;
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
25 import net.sf.jasperreports.engine.JRException;
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
26
389
69d05357c177 Added an exporter (OutGenerator) for waterlevels which currently supports CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
27 import de.intevation.artifacts.CallContext;
2045
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
28 import de.intevation.artifacts.CallMeta;
2185
a9a8df1473fd Added i18n support to PDF report export.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2182
diff changeset
29 import de.intevation.artifacts.common.utils.Config;
389
69d05357c177 Added an exporter (OutGenerator) for waterlevels which currently supports CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
30
2066
2b6a0de47379 Improved the WaterlevelExporter: added range check for W/Q at gauge.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2065
diff changeset
31 import de.intevation.flys.model.Gauge;
2b6a0de47379 Improved the WaterlevelExporter: added range check for W/Q at gauge.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2065
diff changeset
32
2045
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
33 import de.intevation.flys.artifacts.FLYSArtifact;
2035
3ebbe497d7f7 #252 Set titles in waterlevel exports to named main values if those are existing for given Q values.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 749
diff changeset
34 import de.intevation.flys.artifacts.WINFOArtifact;
709
3b7e9ddf6bb1 New model to transport data and error reports of calculations.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 707
diff changeset
35 import de.intevation.flys.artifacts.model.CalculationResult;
749
72bcbc308501 The WST export contains the corrected W values now.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 709
diff changeset
36 import de.intevation.flys.artifacts.model.WQCKms;
389
69d05357c177 Added an exporter (OutGenerator) for waterlevels which currently supports CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
37 import de.intevation.flys.artifacts.model.WQKms;
2176
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
38 import de.intevation.flys.artifacts.model.WKmsJRDataSource;
2045
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
39 import de.intevation.flys.artifacts.resources.Resources;
706
ddd8b37d5cd3 Removed dead code.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 701
diff changeset
40
2035
3ebbe497d7f7 #252 Set titles in waterlevel exports to named main values if those are existing for given Q values.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 749
diff changeset
41 import de.intevation.flys.utils.FLYSUtils;
2065
2f5628f0de0e Part 2 of #125: add gaugename and Q description based on the selected WQ mode.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2063
diff changeset
42 import de.intevation.flys.utils.FLYSUtils.WQ_MODE;
445
a7947972fdeb Added a new class that supports formatters for different types of data.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 418
diff changeset
43 import de.intevation.flys.utils.Formatter;
389
69d05357c177 Added an exporter (OutGenerator) for waterlevels which currently supports CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
44
69d05357c177 Added an exporter (OutGenerator) for waterlevels which currently supports CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
45
69d05357c177 Added an exporter (OutGenerator) for waterlevels which currently supports CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
46 /**
3252
62c9bcef0680 Fix issue705 (maín value names also in w/q-range mode).
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents: 2764
diff changeset
47 * Generates different output formats (wst, csv, pdf) of data that resulted from
62c9bcef0680 Fix issue705 (maín value names also in w/q-range mode).
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents: 2764
diff changeset
48 * a waterlevel computation.
62c9bcef0680 Fix issue705 (maín value names also in w/q-range mode).
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents: 2764
diff changeset
49 *
389
69d05357c177 Added an exporter (OutGenerator) for waterlevels which currently supports CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
50 * @author <a href="mailto:ingo.weinzierl@intevation.de">Ingo Weinzierl</a>
69d05357c177 Added an exporter (OutGenerator) for waterlevels which currently supports CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
51 */
391
5d6988836f01 Added an exporter to export the computed data of a duration curve.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 389
diff changeset
52 public class WaterlevelExporter extends AbstractExporter {
389
69d05357c177 Added an exporter (OutGenerator) for waterlevels which currently supports CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
53
69d05357c177 Added an exporter (OutGenerator) for waterlevels which currently supports CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
54 /** The logger used in this exporter.*/
69d05357c177 Added an exporter (OutGenerator) for waterlevels which currently supports CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
55 private static Logger logger = Logger.getLogger(WaterlevelExporter.class);
69d05357c177 Added an exporter (OutGenerator) for waterlevels which currently supports CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
56
446
c0bec245f608 Implemented writer that creates WSTs and enabled the WaterlevelExporter to create those.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 445
diff changeset
57 public static final String FACET_WST = "wst";
c0bec245f608 Implemented writer that creates WSTs and enabled the WaterlevelExporter to create those.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 445
diff changeset
58
416
340dc41a7ea3 The CSV exports will now have headers.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 391
diff changeset
59 public static final String CSV_KM_HEADER =
340dc41a7ea3 The CSV exports will now have headers.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 391
diff changeset
60 "export.waterlevel.csv.header.km";
340dc41a7ea3 The CSV exports will now have headers.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 391
diff changeset
61
340dc41a7ea3 The CSV exports will now have headers.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 391
diff changeset
62 public static final String CSV_W_HEADER =
340dc41a7ea3 The CSV exports will now have headers.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 391
diff changeset
63 "export.waterlevel.csv.header.w";
340dc41a7ea3 The CSV exports will now have headers.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 391
diff changeset
64
340dc41a7ea3 The CSV exports will now have headers.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 391
diff changeset
65 public static final String CSV_Q_HEADER =
340dc41a7ea3 The CSV exports will now have headers.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 391
diff changeset
66 "export.waterlevel.csv.header.q";
340dc41a7ea3 The CSV exports will now have headers.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 391
diff changeset
67
2063
97a25b54eea3 Part 1 of #125: added a description for a location to the WaterlevelExport.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2045
diff changeset
68 public static final String CSV_Q_DESC_HEADER =
97a25b54eea3 Part 1 of #125: added a description for a location to the WaterlevelExport.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2045
diff changeset
69 "export.waterlevel.csv.header.q.desc";
97a25b54eea3 Part 1 of #125: added a description for a location to the WaterlevelExport.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2045
diff changeset
70
2068
0cf60d64895c #370 Added a 'W at gauge' column to CSV exports if 'W at gauge' mode has been selected.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2066
diff changeset
71 public static final String CSV_W_DESC_HEADER =
0cf60d64895c #370 Added a 'W at gauge' column to CSV exports if 'W at gauge' mode has been selected.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2066
diff changeset
72 "export.waterlevel.csv.header.w.desc";
0cf60d64895c #370 Added a 'W at gauge' column to CSV exports if 'W at gauge' mode has been selected.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2066
diff changeset
73
2063
97a25b54eea3 Part 1 of #125: added a description for a location to the WaterlevelExport.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2045
diff changeset
74 public static final String CSV_LOCATION_HEADER =
97a25b54eea3 Part 1 of #125: added a description for a location to the WaterlevelExport.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2045
diff changeset
75 "export.waterlevel.csv.header.location";
97a25b54eea3 Part 1 of #125: added a description for a location to the WaterlevelExport.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2045
diff changeset
76
97a25b54eea3 Part 1 of #125: added a description for a location to the WaterlevelExport.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2045
diff changeset
77 public static final String CSV_GAUGE_HEADER =
97a25b54eea3 Part 1 of #125: added a description for a location to the WaterlevelExport.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2045
diff changeset
78 "export.waterlevel.csv.header.gauge";
97a25b54eea3 Part 1 of #125: added a description for a location to the WaterlevelExport.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2045
diff changeset
79
2045
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
80 public static final String CSV_META_RESULT =
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
81 "export.waterlevel.csv.meta.result";
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
82
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
83 public static final String CSV_META_CREATION =
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
84 "export.waterlevel.csv.meta.creation";
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
85
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
86 public static final String CSV_META_CALCULATIONBASE =
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
87 "export.waterlevel.csv.meta.calculationbase";
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
88
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
89 public static final String CSV_META_RIVER =
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
90 "export.waterlevel.csv.meta.river";
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
91
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
92 public static final String CSV_META_RANGE =
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
93 "export.waterlevel.csv.meta.range";
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
94
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
95 public static final String CSV_META_GAUGE =
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
96 "export.waterlevel.csv.meta.gauge";
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
97
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
98 public static final String CSV_META_Q =
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
99 "export.waterlevel.csv.meta.q";
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
100
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
101 public static final String CSV_META_W =
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
102 "export.waterlevel.csv.meta.w";
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
103
2066
2b6a0de47379 Improved the WaterlevelExporter: added range check for W/Q at gauge.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2065
diff changeset
104 public static final String CSV_NOT_IN_GAUGE_RANGE =
2b6a0de47379 Improved the WaterlevelExporter: added range check for W/Q at gauge.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2065
diff changeset
105 "export.waterlevel.csv.not.in.gauge.range";
2b6a0de47379 Improved the WaterlevelExporter: added range check for W/Q at gauge.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2065
diff changeset
106
2045
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
107
2035
3ebbe497d7f7 #252 Set titles in waterlevel exports to named main values if those are existing for given Q values.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 749
diff changeset
108 public static final Pattern NUMBERS_PATTERN =
3ebbe497d7f7 #252 Set titles in waterlevel exports to named main values if those are existing for given Q values.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 749
diff changeset
109 Pattern.compile("\\D*(\\d++.\\d*)\\D*");
3ebbe497d7f7 #252 Set titles in waterlevel exports to named main values if those are existing for given Q values.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 749
diff changeset
110
2063
97a25b54eea3 Part 1 of #125: added a description for a location to the WaterlevelExport.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2045
diff changeset
111 public static final String DEFAULT_CSV_KM_HEADER = "Fluss-Km";
97a25b54eea3 Part 1 of #125: added a description for a location to the WaterlevelExport.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2045
diff changeset
112 public static final String DEFAULT_CSV_W_HEADER = "W [NN + m]";
97a25b54eea3 Part 1 of #125: added a description for a location to the WaterlevelExport.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2045
diff changeset
113 public static final String DEFAULT_CSV_Q_HEADER = "Q [m\u00b3/s]";
97a25b54eea3 Part 1 of #125: added a description for a location to the WaterlevelExport.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2045
diff changeset
114 public static final String DEFAULT_CSV_Q_DESC_HEADER = "Bezeichnung";
2068
0cf60d64895c #370 Added a 'W at gauge' column to CSV exports if 'W at gauge' mode has been selected.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2066
diff changeset
115 public static final String DEFAULT_CSV_W_DESC_HEADER = "W/Pegel [cm]";
2063
97a25b54eea3 Part 1 of #125: added a description for a location to the WaterlevelExport.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2045
diff changeset
116 public static final String DEFAULT_CSV_LOCATION_HEADER = "Lage";
97a25b54eea3 Part 1 of #125: added a description for a location to the WaterlevelExport.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2045
diff changeset
117 public static final String DEFAULT_CSV_GAUGE_HEADER = "Bezugspegel";
2066
2b6a0de47379 Improved the WaterlevelExporter: added range check for W/Q at gauge.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2065
diff changeset
118 public static final String DEFAULT_CSV_NOT_IN_GAUGE_RANGE =
2b6a0de47379 Improved the WaterlevelExporter: added range check for W/Q at gauge.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2065
diff changeset
119 "außerhalb des gewählten Bezugspegels";
416
340dc41a7ea3 The CSV exports will now have headers.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 391
diff changeset
120
2176
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
121 public static final String PDF_HEADER_MODE = "export.waterlevel.pdf.mode";
2284
5d1ba04d2f68 Refactored Formatter access to ease reuse.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents: 2185
diff changeset
122 public static final String JASPER_FILE = "export.waterlevel.pdf.file";
416
340dc41a7ea3 The CSV exports will now have headers.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 391
diff changeset
123
389
69d05357c177 Added an exporter (OutGenerator) for waterlevels which currently supports CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
124 /** The storage that contains all WQKms objects for the different facets.*/
69d05357c177 Added an exporter (OutGenerator) for waterlevels which currently supports CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
125 protected List<WQKms[]> data;
69d05357c177 Added an exporter (OutGenerator) for waterlevels which currently supports CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
126
69d05357c177 Added an exporter (OutGenerator) for waterlevels which currently supports CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
127
69d05357c177 Added an exporter (OutGenerator) for waterlevels which currently supports CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
128 public void init(Document request, OutputStream out, CallContext context) {
69d05357c177 Added an exporter (OutGenerator) for waterlevels which currently supports CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
129 logger.debug("WaterlevelExporter.init");
69d05357c177 Added an exporter (OutGenerator) for waterlevels which currently supports CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
130
391
5d6988836f01 Added an exporter to export the computed data of a duration curve.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 389
diff changeset
131 super.init(request, out, context);
389
69d05357c177 Added an exporter (OutGenerator) for waterlevels which currently supports CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
132
391
5d6988836f01 Added an exporter to export the computed data of a duration curve.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 389
diff changeset
133 this.data = new ArrayList<WQKms[]>();
389
69d05357c177 Added an exporter (OutGenerator) for waterlevels which currently supports CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
134 }
69d05357c177 Added an exporter (OutGenerator) for waterlevels which currently supports CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
135
69d05357c177 Added an exporter (OutGenerator) for waterlevels which currently supports CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
136
446
c0bec245f608 Implemented writer that creates WSTs and enabled the WaterlevelExporter to create those.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 445
diff changeset
137 @Override
c0bec245f608 Implemented writer that creates WSTs and enabled the WaterlevelExporter to create those.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 445
diff changeset
138 public void generate()
c0bec245f608 Implemented writer that creates WSTs and enabled the WaterlevelExporter to create those.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 445
diff changeset
139 throws IOException
c0bec245f608 Implemented writer that creates WSTs and enabled the WaterlevelExporter to create those.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 445
diff changeset
140 {
c0bec245f608 Implemented writer that creates WSTs and enabled the WaterlevelExporter to create those.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 445
diff changeset
141 logger.debug("WaterlevelExporter.generate");
c0bec245f608 Implemented writer that creates WSTs and enabled the WaterlevelExporter to create those.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 445
diff changeset
142
c0bec245f608 Implemented writer that creates WSTs and enabled the WaterlevelExporter to create those.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 445
diff changeset
143 if (facet != null && facet.equals(AbstractExporter.FACET_CSV)) {
c0bec245f608 Implemented writer that creates WSTs and enabled the WaterlevelExporter to create those.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 445
diff changeset
144 generateCSV();
c0bec245f608 Implemented writer that creates WSTs and enabled the WaterlevelExporter to create those.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 445
diff changeset
145 }
c0bec245f608 Implemented writer that creates WSTs and enabled the WaterlevelExporter to create those.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 445
diff changeset
146 else if (facet != null && facet.equals(FACET_WST)) {
c0bec245f608 Implemented writer that creates WSTs and enabled the WaterlevelExporter to create those.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 445
diff changeset
147 generateWST();
c0bec245f608 Implemented writer that creates WSTs and enabled the WaterlevelExporter to create those.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 445
diff changeset
148 }
2176
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
149 else if (facet != null && facet.equals(AbstractExporter.FACET_PDF)) {
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
150 generatePDF();
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
151 }
446
c0bec245f608 Implemented writer that creates WSTs and enabled the WaterlevelExporter to create those.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 445
diff changeset
152 else {
c0bec245f608 Implemented writer that creates WSTs and enabled the WaterlevelExporter to create those.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 445
diff changeset
153 throw new IOException("invalid facet for exporter");
c0bec245f608 Implemented writer that creates WSTs and enabled the WaterlevelExporter to create those.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 445
diff changeset
154 }
c0bec245f608 Implemented writer that creates WSTs and enabled the WaterlevelExporter to create those.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 445
diff changeset
155 }
c0bec245f608 Implemented writer that creates WSTs and enabled the WaterlevelExporter to create those.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 445
diff changeset
156
c0bec245f608 Implemented writer that creates WSTs and enabled the WaterlevelExporter to create those.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 445
diff changeset
157
701
dad1a2c88f9f Base WST/CSV exports on facets. TODO: generate the facets.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 664
diff changeset
158 @Override
dad1a2c88f9f Base WST/CSV exports on facets. TODO: generate the facets.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 664
diff changeset
159 protected void addData(Object d) {
709
3b7e9ddf6bb1 New model to transport data and error reports of calculations.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 707
diff changeset
160 if (d instanceof CalculationResult) {
3b7e9ddf6bb1 New model to transport data and error reports of calculations.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 707
diff changeset
161 d = ((CalculationResult)d).getData();
3b7e9ddf6bb1 New model to transport data and error reports of calculations.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 707
diff changeset
162 if (d instanceof WQKms []) {
3b7e9ddf6bb1 New model to transport data and error reports of calculations.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 707
diff changeset
163 data.add((WQKms [])d);
3b7e9ddf6bb1 New model to transport data and error reports of calculations.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 707
diff changeset
164 }
701
dad1a2c88f9f Base WST/CSV exports on facets. TODO: generate the facets.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 664
diff changeset
165 }
389
69d05357c177 Added an exporter (OutGenerator) for waterlevels which currently supports CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
166 }
69d05357c177 Added an exporter (OutGenerator) for waterlevels which currently supports CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
167
69d05357c177 Added an exporter (OutGenerator) for waterlevels which currently supports CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
168
2035
3ebbe497d7f7 #252 Set titles in waterlevel exports to named main values if those are existing for given Q values.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 749
diff changeset
169 /**
3ebbe497d7f7 #252 Set titles in waterlevel exports to named main values if those are existing for given Q values.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 749
diff changeset
170 * This method is used to prepare the column titles of waterlevel exports.
3ebbe497d7f7 #252 Set titles in waterlevel exports to named main values if those are existing for given Q values.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 749
diff changeset
171 * Titles in this export include the Q value. If a Q value matches a named
3ebbe497d7f7 #252 Set titles in waterlevel exports to named main values if those are existing for given Q values.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 749
diff changeset
172 * main value (as HQ100 or MNQ) this named main value should be used as
3ebbe497d7f7 #252 Set titles in waterlevel exports to named main values if those are existing for given Q values.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 749
diff changeset
173 * title. This method resets the name of the <i>wqkms</i> object if such
3ebbe497d7f7 #252 Set titles in waterlevel exports to named main values if those are existing for given Q values.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 749
diff changeset
174 * named main value fits to the chosen Q.
3ebbe497d7f7 #252 Set titles in waterlevel exports to named main values if those are existing for given Q values.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 749
diff changeset
175 *
3ebbe497d7f7 #252 Set titles in waterlevel exports to named main values if those are existing for given Q values.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 749
diff changeset
176 * @param winfo A WINFO Artifact.
3ebbe497d7f7 #252 Set titles in waterlevel exports to named main values if those are existing for given Q values.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 749
diff changeset
177 * @param wqkms A WQKms object that should be prepared.
3ebbe497d7f7 #252 Set titles in waterlevel exports to named main values if those are existing for given Q values.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 749
diff changeset
178 */
2038
f73036b991e2 Bugfix: repaired broken named values in exports - the last solution had bad side effects.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2035
diff changeset
179 protected String getColumnTitle(WINFOArtifact winfo, WQKms wqkms) {
2035
3ebbe497d7f7 #252 Set titles in waterlevel exports to named main values if those are existing for given Q values.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 749
diff changeset
180 logger.debug("WaterlevelExporter.prepareNamedValue");
3ebbe497d7f7 #252 Set titles in waterlevel exports to named main values if those are existing for given Q values.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 749
diff changeset
181
3ebbe497d7f7 #252 Set titles in waterlevel exports to named main values if those are existing for given Q values.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 749
diff changeset
182 String name = wqkms.getName();
3ebbe497d7f7 #252 Set titles in waterlevel exports to named main values if those are existing for given Q values.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 749
diff changeset
183
3ebbe497d7f7 #252 Set titles in waterlevel exports to named main values if those are existing for given Q values.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 749
diff changeset
184 logger.debug("Name of WQKms = '" + name + "'");
3ebbe497d7f7 #252 Set titles in waterlevel exports to named main values if those are existing for given Q values.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 749
diff changeset
185
2038
f73036b991e2 Bugfix: repaired broken named values in exports - the last solution had bad side effects.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2035
diff changeset
186 if (name.indexOf("W=") >= 0) {
f73036b991e2 Bugfix: repaired broken named values in exports - the last solution had bad side effects.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2035
diff changeset
187 return name;
f73036b991e2 Bugfix: repaired broken named values in exports - the last solution had bad side effects.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2035
diff changeset
188 }
f73036b991e2 Bugfix: repaired broken named values in exports - the last solution had bad side effects.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2035
diff changeset
189
2035
3ebbe497d7f7 #252 Set titles in waterlevel exports to named main values if those are existing for given Q values.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 749
diff changeset
190 Matcher m = NUMBERS_PATTERN.matcher(name);
3ebbe497d7f7 #252 Set titles in waterlevel exports to named main values if those are existing for given Q values.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 749
diff changeset
191
3ebbe497d7f7 #252 Set titles in waterlevel exports to named main values if those are existing for given Q values.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 749
diff changeset
192 if (m.matches()) {
3ebbe497d7f7 #252 Set titles in waterlevel exports to named main values if those are existing for given Q values.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 749
diff changeset
193 String raw = m.group(1);
3ebbe497d7f7 #252 Set titles in waterlevel exports to named main values if those are existing for given Q values.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 749
diff changeset
194
3ebbe497d7f7 #252 Set titles in waterlevel exports to named main values if those are existing for given Q values.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 749
diff changeset
195 try {
3ebbe497d7f7 #252 Set titles in waterlevel exports to named main values if those are existing for given Q values.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 749
diff changeset
196 double v = Double.valueOf(raw);
3ebbe497d7f7 #252 Set titles in waterlevel exports to named main values if those are existing for given Q values.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 749
diff changeset
197
2038
f73036b991e2 Bugfix: repaired broken named values in exports - the last solution had bad side effects.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2035
diff changeset
198 String nmv = FLYSUtils.getNamedMainValue(winfo, v);
2035
3ebbe497d7f7 #252 Set titles in waterlevel exports to named main values if those are existing for given Q values.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 749
diff changeset
199
3ebbe497d7f7 #252 Set titles in waterlevel exports to named main values if those are existing for given Q values.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 749
diff changeset
200 if (nmv != null && nmv.length() > 0) {
2596
00cf69edfcc0 #252 Added numeric value of a named main value into the WST export.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2555
diff changeset
201 nmv = FLYSUtils.stripNamedMainValue(nmv);
00cf69edfcc0 #252 Added numeric value of a named main value into the WST export.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2555
diff changeset
202 nmv += "=" + String.valueOf(v);
2035
3ebbe497d7f7 #252 Set titles in waterlevel exports to named main values if those are existing for given Q values.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 749
diff changeset
203 logger.debug("Set named main value '" + nmv + "'");
3ebbe497d7f7 #252 Set titles in waterlevel exports to named main values if those are existing for given Q values.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 749
diff changeset
204
2038
f73036b991e2 Bugfix: repaired broken named values in exports - the last solution had bad side effects.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2035
diff changeset
205 return nmv;
2035
3ebbe497d7f7 #252 Set titles in waterlevel exports to named main values if those are existing for given Q values.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 749
diff changeset
206 }
3ebbe497d7f7 #252 Set titles in waterlevel exports to named main values if those are existing for given Q values.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 749
diff changeset
207 }
3ebbe497d7f7 #252 Set titles in waterlevel exports to named main values if those are existing for given Q values.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 749
diff changeset
208 catch (NumberFormatException nfe) {
3ebbe497d7f7 #252 Set titles in waterlevel exports to named main values if those are existing for given Q values.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 749
diff changeset
209 // do nothing here
3ebbe497d7f7 #252 Set titles in waterlevel exports to named main values if those are existing for given Q values.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 749
diff changeset
210 }
3ebbe497d7f7 #252 Set titles in waterlevel exports to named main values if those are existing for given Q values.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 749
diff changeset
211 }
2038
f73036b991e2 Bugfix: repaired broken named values in exports - the last solution had bad side effects.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2035
diff changeset
212
f73036b991e2 Bugfix: repaired broken named values in exports - the last solution had bad side effects.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2035
diff changeset
213 return name;
2035
3ebbe497d7f7 #252 Set titles in waterlevel exports to named main values if those are existing for given Q values.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 749
diff changeset
214 }
3ebbe497d7f7 #252 Set titles in waterlevel exports to named main values if those are existing for given Q values.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 749
diff changeset
215
3ebbe497d7f7 #252 Set titles in waterlevel exports to named main values if those are existing for given Q values.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 749
diff changeset
216
2087
bda04ae1154f #196 Localized the WQ labels in CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2068
diff changeset
217 protected String getCSVRowTitle(WINFOArtifact winfo, WQKms wqkms) {
bda04ae1154f #196 Localized the WQ labels in CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2068
diff changeset
218 logger.debug("WaterlevelExporter.prepareNamedValue");
bda04ae1154f #196 Localized the WQ labels in CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2068
diff changeset
219
bda04ae1154f #196 Localized the WQ labels in CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2068
diff changeset
220 String name = wqkms.getName();
bda04ae1154f #196 Localized the WQ labels in CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2068
diff changeset
221
bda04ae1154f #196 Localized the WQ labels in CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2068
diff changeset
222 logger.debug("Name of WQKms = '" + name + "'");
bda04ae1154f #196 Localized the WQ labels in CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2068
diff changeset
223
bda04ae1154f #196 Localized the WQ labels in CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2068
diff changeset
224 WQ_MODE wqmode = FLYSUtils.getWQMode(winfo);
bda04ae1154f #196 Localized the WQ labels in CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2068
diff changeset
225
bda04ae1154f #196 Localized the WQ labels in CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2068
diff changeset
226 if (wqmode == WQ_MODE.WFREE || wqmode == WQ_MODE.QGAUGE) {
bda04ae1154f #196 Localized the WQ labels in CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2068
diff changeset
227 return localizeWQKms(winfo, wqkms);
bda04ae1154f #196 Localized the WQ labels in CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2068
diff changeset
228 }
bda04ae1154f #196 Localized the WQ labels in CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2068
diff changeset
229
bda04ae1154f #196 Localized the WQ labels in CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2068
diff changeset
230 Double v = wqkms.getRawValue();
bda04ae1154f #196 Localized the WQ labels in CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2068
diff changeset
231
bda04ae1154f #196 Localized the WQ labels in CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2068
diff changeset
232 String nmv = FLYSUtils.getNamedMainValue(winfo, v);
bda04ae1154f #196 Localized the WQ labels in CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2068
diff changeset
233
bda04ae1154f #196 Localized the WQ labels in CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2068
diff changeset
234 if (nmv != null && nmv.length() > 0) {
bda04ae1154f #196 Localized the WQ labels in CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2068
diff changeset
235 nmv = FLYSUtils.stripNamedMainValue(nmv);
bda04ae1154f #196 Localized the WQ labels in CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2068
diff changeset
236 logger.debug("Set named main value '" + nmv + "'");
bda04ae1154f #196 Localized the WQ labels in CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2068
diff changeset
237
bda04ae1154f #196 Localized the WQ labels in CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2068
diff changeset
238 return nmv;
bda04ae1154f #196 Localized the WQ labels in CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2068
diff changeset
239 }
bda04ae1154f #196 Localized the WQ labels in CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2068
diff changeset
240
bda04ae1154f #196 Localized the WQ labels in CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2068
diff changeset
241 return localizeWQKms(winfo, wqkms);
bda04ae1154f #196 Localized the WQ labels in CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2068
diff changeset
242 }
bda04ae1154f #196 Localized the WQ labels in CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2068
diff changeset
243
bda04ae1154f #196 Localized the WQ labels in CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2068
diff changeset
244
3252
62c9bcef0680 Fix issue705 (maín value names also in w/q-range mode).
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents: 2764
diff changeset
245 /**
62c9bcef0680 Fix issue705 (maín value names also in w/q-range mode).
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents: 2764
diff changeset
246 * Get a string like 'W=' or 'Q=' with a number following in localized
62c9bcef0680 Fix issue705 (maín value names also in w/q-range mode).
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents: 2764
diff changeset
247 * format.
62c9bcef0680 Fix issue705 (maín value names also in w/q-range mode).
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents: 2764
diff changeset
248 */
2087
bda04ae1154f #196 Localized the WQ labels in CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2068
diff changeset
249 protected String localizeWQKms(WINFOArtifact winfo, WQKms wqkms) {
bda04ae1154f #196 Localized the WQ labels in CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2068
diff changeset
250 WQ_MODE wqmode = FLYSUtils.getWQMode(winfo);
bda04ae1154f #196 Localized the WQ labels in CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2068
diff changeset
251 Double rawValue = wqkms.getRawValue();
bda04ae1154f #196 Localized the WQ labels in CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2068
diff changeset
252
bda04ae1154f #196 Localized the WQ labels in CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2068
diff changeset
253 if (rawValue == null) {
bda04ae1154f #196 Localized the WQ labels in CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2068
diff changeset
254 return wqkms.getName();
bda04ae1154f #196 Localized the WQ labels in CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2068
diff changeset
255 }
bda04ae1154f #196 Localized the WQ labels in CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2068
diff changeset
256
bda04ae1154f #196 Localized the WQ labels in CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2068
diff changeset
257 NumberFormat nf = Formatter.getRawFormatter(context);
bda04ae1154f #196 Localized the WQ labels in CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2068
diff changeset
258
bda04ae1154f #196 Localized the WQ labels in CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2068
diff changeset
259 if (wqmode == WQ_MODE.WFREE || wqmode == WQ_MODE.WGAUGE) {
bda04ae1154f #196 Localized the WQ labels in CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2068
diff changeset
260 return "W=" + nf.format(rawValue);
bda04ae1154f #196 Localized the WQ labels in CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2068
diff changeset
261 }
bda04ae1154f #196 Localized the WQ labels in CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2068
diff changeset
262 else {
bda04ae1154f #196 Localized the WQ labels in CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2068
diff changeset
263 return "Q=" + nf.format(rawValue);
bda04ae1154f #196 Localized the WQ labels in CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2068
diff changeset
264 }
bda04ae1154f #196 Localized the WQ labels in CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2068
diff changeset
265 }
bda04ae1154f #196 Localized the WQ labels in CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2068
diff changeset
266
bda04ae1154f #196 Localized the WQ labels in CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2068
diff changeset
267
701
dad1a2c88f9f Base WST/CSV exports on facets. TODO: generate the facets.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 664
diff changeset
268 @Override
391
5d6988836f01 Added an exporter to export the computed data of a duration curve.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 389
diff changeset
269 protected void writeCSVData(CSVWriter writer) {
5d6988836f01 Added an exporter to export the computed data of a duration curve.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 389
diff changeset
270 logger.info("WaterlevelExporter.writeData");
389
69d05357c177 Added an exporter (OutGenerator) for waterlevels which currently supports CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
271
3252
62c9bcef0680 Fix issue705 (maín value names also in w/q-range mode).
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents: 2764
diff changeset
272 WQ_MODE mode = FLYSUtils.getWQMode((FLYSArtifact)master);
62c9bcef0680 Fix issue705 (maín value names also in w/q-range mode).
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents: 2764
diff changeset
273 boolean atGauge = mode == WQ_MODE.QGAUGE || mode == WQ_MODE.WGAUGE;
62c9bcef0680 Fix issue705 (maín value names also in w/q-range mode).
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents: 2764
diff changeset
274 boolean isQ = mode == WQ_MODE.QGAUGE || mode == WQ_MODE.QFREE;
2555
ba46af45b6e4 Write the gauge description instead of the Q value to CSV file.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2290
diff changeset
275 FLYSUtils.WQ_INPUT input
ba46af45b6e4 Write the gauge description instead of the Q value to CSV file.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2290
diff changeset
276 = FLYSUtils.getWQInputMode((FLYSArtifact)master);
2065
2f5628f0de0e Part 2 of #125: add gaugename and Q description based on the selected WQ mode.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2063
diff changeset
277
2045
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
278 writeCSVMeta(writer);
2068
0cf60d64895c #370 Added a 'W at gauge' column to CSV exports if 'W at gauge' mode has been selected.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2066
diff changeset
279 writeCSVHeader(writer, atGauge, isQ);
416
340dc41a7ea3 The CSV exports will now have headers.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 391
diff changeset
280
389
69d05357c177 Added an exporter (OutGenerator) for waterlevels which currently supports CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
281 for (WQKms[] tmp: data) {
69d05357c177 Added an exporter (OutGenerator) for waterlevels which currently supports CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
282 for (WQKms wqkms: tmp) {
3252
62c9bcef0680 Fix issue705 (maín value names also in w/q-range mode).
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents: 2764
diff changeset
283 wQKms2CSV(writer, wqkms, atGauge, isQ);
389
69d05357c177 Added an exporter (OutGenerator) for waterlevels which currently supports CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
284 }
69d05357c177 Added an exporter (OutGenerator) for waterlevels which currently supports CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
285 }
69d05357c177 Added an exporter (OutGenerator) for waterlevels which currently supports CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
286 }
69d05357c177 Added an exporter (OutGenerator) for waterlevels which currently supports CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
287
69d05357c177 Added an exporter (OutGenerator) for waterlevels which currently supports CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
288
2045
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
289 protected void writeCSVMeta(CSVWriter writer) {
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
290 logger.info("WaterlevelExporter.writeCSVMeta");
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
291
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
292 CallMeta meta = context.getMeta();
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
293
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
294 FLYSArtifact flys = (FLYSArtifact) master;
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
295
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
296 writer.writeNext(new String[] {
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
297 Resources.getMsg(
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
298 meta,
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
299 CSV_META_RESULT,
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
300 CSV_META_RESULT,
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
301 new Object[] { FLYSUtils.getRivername(flys) })
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
302 });
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
303
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
304 Locale locale = Resources.getLocale(meta);
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
305 DateFormat df = DateFormat.getDateInstance(DateFormat.SHORT, locale);
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
306
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
307 writer.writeNext(new String[] {
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
308 Resources.getMsg(
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
309 meta,
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
310 CSV_META_CREATION,
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
311 CSV_META_CREATION,
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
312 new Object[] { df.format(new Date()) })
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
313 });
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
314
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
315 writer.writeNext(new String[] {
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
316 Resources.getMsg(
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
317 meta,
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
318 CSV_META_CALCULATIONBASE,
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
319 CSV_META_CALCULATIONBASE,
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
320 new Object[] { "" }) // TODO what is required at this place?
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
321 });
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
322
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
323 writer.writeNext(new String[] {
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
324 Resources.getMsg(
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
325 meta,
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
326 CSV_META_RIVER,
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
327 CSV_META_RIVER,
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
328 new Object[] { FLYSUtils.getRivername(flys) })
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
329 });
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
330
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
331 double[] kms = FLYSUtils.getKmRange(flys);
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
332 writer.writeNext(new String[] {
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
333 Resources.getMsg(
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
334 meta,
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
335 CSV_META_RANGE,
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
336 CSV_META_RANGE,
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
337 new Object[] { kms[0], kms[kms.length-1] })
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
338 });
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
339
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
340 writer.writeNext(new String[] {
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
341 Resources.getMsg(
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
342 meta,
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
343 CSV_META_GAUGE,
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
344 CSV_META_GAUGE,
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
345 new Object[] { FLYSUtils.getGaugename(flys) })
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
346 });
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
347
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
348 FLYSUtils.WQ_MODE wq = FLYSUtils.getWQMode(flys);
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
349 if (wq == FLYSUtils.WQ_MODE.QFREE || wq == FLYSUtils.WQ_MODE.QGAUGE) {
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
350 double[] qs = FLYSUtils.getQs(flys);
2555
ba46af45b6e4 Write the gauge description instead of the Q value to CSV file.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2290
diff changeset
351 FLYSUtils.WQ_INPUT input = FLYSUtils.getWQInputMode(flys);
2045
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
352
2555
ba46af45b6e4 Write the gauge description instead of the Q value to CSV file.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2290
diff changeset
353 String data = "";
2045
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
354
2555
ba46af45b6e4 Write the gauge description instead of the Q value to CSV file.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2290
diff changeset
355 if ((input == FLYSUtils.WQ_INPUT.ADAPTED ||
ba46af45b6e4 Write the gauge description instead of the Q value to CSV file.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2290
diff changeset
356 input == FLYSUtils.WQ_INPUT.RANGE) &&
ba46af45b6e4 Write the gauge description instead of the Q value to CSV file.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2290
diff changeset
357 qs != null && qs.length > 0)
ba46af45b6e4 Write the gauge description instead of the Q value to CSV file.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2290
diff changeset
358 {
ba46af45b6e4 Write the gauge description instead of the Q value to CSV file.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2290
diff changeset
359 data = String.valueOf(qs[0]);
ba46af45b6e4 Write the gauge description instead of the Q value to CSV file.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2290
diff changeset
360 data += " - " + String.valueOf(qs[qs.length-1]);
ba46af45b6e4 Write the gauge description instead of the Q value to CSV file.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2290
diff changeset
361 }
ba46af45b6e4 Write the gauge description instead of the Q value to CSV file.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2290
diff changeset
362 else if (input == FLYSUtils.WQ_INPUT.SINGLE && qs != null){
ba46af45b6e4 Write the gauge description instead of the Q value to CSV file.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2290
diff changeset
363 data = String.valueOf(qs[0]);
ba46af45b6e4 Write the gauge description instead of the Q value to CSV file.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2290
diff changeset
364 for (int i = 1; i < qs.length; i++) {
ba46af45b6e4 Write the gauge description instead of the Q value to CSV file.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2290
diff changeset
365 data += ", " + String.valueOf(qs[i]);
ba46af45b6e4 Write the gauge description instead of the Q value to CSV file.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2290
diff changeset
366 }
2045
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
367 }
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
368 else {
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
369 logger.warn("Could not determine Q range!");
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
370 }
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
371
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
372 writer.writeNext(new String[] {
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
373 Resources.getMsg(
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
374 meta,
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
375 CSV_META_Q,
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
376 CSV_META_Q,
2555
ba46af45b6e4 Write the gauge description instead of the Q value to CSV file.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2290
diff changeset
377 new Object[] {data})
2045
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
378 });
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
379 }
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
380 else {
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
381 double[] ws = FLYSUtils.getWs(flys);
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
382
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
383 String lower = "";
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
384 String upper = "";
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
385
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
386 if (ws != null && ws.length > 0) {
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
387 lower = String.valueOf(ws[0]);
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
388 upper = String.valueOf(ws[ws.length-1]);
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
389 }
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
390 else {
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
391 logger.warn("Could not determine W range!");
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
392 }
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
393
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
394 writer.writeNext(new String[] {
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
395 Resources.getMsg(
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
396 meta,
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
397 CSV_META_W,
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
398 CSV_META_W,
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
399 new Object[] { lower, upper })
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
400 });
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
401 }
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
402
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
403 writer.writeNext(new String[] { "" });
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
404 }
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
405
d13be39cfd1d #242 Added header with meta information into CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2038
diff changeset
406
2068
0cf60d64895c #370 Added a 'W at gauge' column to CSV exports if 'W at gauge' mode has been selected.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2066
diff changeset
407 protected void writeCSVHeader(
0cf60d64895c #370 Added a 'W at gauge' column to CSV exports if 'W at gauge' mode has been selected.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2066
diff changeset
408 CSVWriter writer,
0cf60d64895c #370 Added a 'W at gauge' column to CSV exports if 'W at gauge' mode has been selected.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2066
diff changeset
409 boolean atGauge,
0cf60d64895c #370 Added a 'W at gauge' column to CSV exports if 'W at gauge' mode has been selected.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2066
diff changeset
410 boolean isQ
0cf60d64895c #370 Added a 'W at gauge' column to CSV exports if 'W at gauge' mode has been selected.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2066
diff changeset
411 ) {
416
340dc41a7ea3 The CSV exports will now have headers.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 391
diff changeset
412 logger.info("WaterlevelExporter.writeCSVHeader");
340dc41a7ea3 The CSV exports will now have headers.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 391
diff changeset
413
2065
2f5628f0de0e Part 2 of #125: add gaugename and Q description based on the selected WQ mode.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2063
diff changeset
414 if (atGauge) {
2f5628f0de0e Part 2 of #125: add gaugename and Q description based on the selected WQ mode.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2063
diff changeset
415 writer.writeNext(new String[] {
2f5628f0de0e Part 2 of #125: add gaugename and Q description based on the selected WQ mode.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2063
diff changeset
416 msg(CSV_KM_HEADER, DEFAULT_CSV_KM_HEADER),
2f5628f0de0e Part 2 of #125: add gaugename and Q description based on the selected WQ mode.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2063
diff changeset
417 msg(CSV_W_HEADER, DEFAULT_CSV_W_HEADER),
2f5628f0de0e Part 2 of #125: add gaugename and Q description based on the selected WQ mode.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2063
diff changeset
418 msg(CSV_Q_HEADER, DEFAULT_CSV_Q_HEADER),
2068
0cf60d64895c #370 Added a 'W at gauge' column to CSV exports if 'W at gauge' mode has been selected.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2066
diff changeset
419 (isQ
0cf60d64895c #370 Added a 'W at gauge' column to CSV exports if 'W at gauge' mode has been selected.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2066
diff changeset
420 ? msg(CSV_Q_DESC_HEADER, DEFAULT_CSV_Q_DESC_HEADER)
0cf60d64895c #370 Added a 'W at gauge' column to CSV exports if 'W at gauge' mode has been selected.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2066
diff changeset
421 : msg(CSV_W_DESC_HEADER, DEFAULT_CSV_W_DESC_HEADER)),
2065
2f5628f0de0e Part 2 of #125: add gaugename and Q description based on the selected WQ mode.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2063
diff changeset
422 msg(CSV_LOCATION_HEADER, DEFAULT_CSV_LOCATION_HEADER),
2f5628f0de0e Part 2 of #125: add gaugename and Q description based on the selected WQ mode.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2063
diff changeset
423 msg(CSV_GAUGE_HEADER, DEFAULT_CSV_GAUGE_HEADER)
2f5628f0de0e Part 2 of #125: add gaugename and Q description based on the selected WQ mode.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2063
diff changeset
424 });
2f5628f0de0e Part 2 of #125: add gaugename and Q description based on the selected WQ mode.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2063
diff changeset
425 }
2f5628f0de0e Part 2 of #125: add gaugename and Q description based on the selected WQ mode.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2063
diff changeset
426 else {
2f5628f0de0e Part 2 of #125: add gaugename and Q description based on the selected WQ mode.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2063
diff changeset
427 writer.writeNext(new String[] {
2f5628f0de0e Part 2 of #125: add gaugename and Q description based on the selected WQ mode.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2063
diff changeset
428 msg(CSV_KM_HEADER, DEFAULT_CSV_KM_HEADER),
2f5628f0de0e Part 2 of #125: add gaugename and Q description based on the selected WQ mode.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2063
diff changeset
429 msg(CSV_W_HEADER, DEFAULT_CSV_W_HEADER),
2f5628f0de0e Part 2 of #125: add gaugename and Q description based on the selected WQ mode.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2063
diff changeset
430 msg(CSV_Q_HEADER, DEFAULT_CSV_Q_HEADER),
2f5628f0de0e Part 2 of #125: add gaugename and Q description based on the selected WQ mode.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2063
diff changeset
431 msg(CSV_LOCATION_HEADER, DEFAULT_CSV_LOCATION_HEADER)
2f5628f0de0e Part 2 of #125: add gaugename and Q description based on the selected WQ mode.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2063
diff changeset
432 });
2f5628f0de0e Part 2 of #125: add gaugename and Q description based on the selected WQ mode.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2063
diff changeset
433 }
416
340dc41a7ea3 The CSV exports will now have headers.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 391
diff changeset
434 }
340dc41a7ea3 The CSV exports will now have headers.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 391
diff changeset
435
340dc41a7ea3 The CSV exports will now have headers.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 391
diff changeset
436
3252
62c9bcef0680 Fix issue705 (maín value names also in w/q-range mode).
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents: 2764
diff changeset
437 /**
62c9bcef0680 Fix issue705 (maín value names also in w/q-range mode).
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents: 2764
diff changeset
438 * Write "rows" of csv data from wqkms with writer.
62c9bcef0680 Fix issue705 (maín value names also in w/q-range mode).
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents: 2764
diff changeset
439 */
2068
0cf60d64895c #370 Added a 'W at gauge' column to CSV exports if 'W at gauge' mode has been selected.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2066
diff changeset
440 protected void wQKms2CSV(
0cf60d64895c #370 Added a 'W at gauge' column to CSV exports if 'W at gauge' mode has been selected.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2066
diff changeset
441 CSVWriter writer,
0cf60d64895c #370 Added a 'W at gauge' column to CSV exports if 'W at gauge' mode has been selected.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2066
diff changeset
442 WQKms wqkms,
0cf60d64895c #370 Added a 'W at gauge' column to CSV exports if 'W at gauge' mode has been selected.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2066
diff changeset
443 boolean atGauge,
3252
62c9bcef0680 Fix issue705 (maín value names also in w/q-range mode).
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents: 2764
diff changeset
444 boolean isQ
2068
0cf60d64895c #370 Added a 'W at gauge' column to CSV exports if 'W at gauge' mode has been selected.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2066
diff changeset
445 ) {
389
69d05357c177 Added an exporter (OutGenerator) for waterlevels which currently supports CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
446 logger.debug("WaterlevelExporter.wQKms2CSV");
69d05357c177 Added an exporter (OutGenerator) for waterlevels which currently supports CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
447
418
e0fec407a280 ISSUE-53 Formatted number values of CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 416
diff changeset
448 NumberFormat kmf = getKmFormatter();
e0fec407a280 ISSUE-53 Formatted number values of CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 416
diff changeset
449 NumberFormat wf = getWFormatter();
e0fec407a280 ISSUE-53 Formatted number values of CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 416
diff changeset
450 NumberFormat qf = getQFormatter();
e0fec407a280 ISSUE-53 Formatted number values of CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 416
diff changeset
451
389
69d05357c177 Added an exporter (OutGenerator) for waterlevels which currently supports CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
452 int size = wqkms.size();
69d05357c177 Added an exporter (OutGenerator) for waterlevels which currently supports CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
453 double[] result = new double[3];
69d05357c177 Added an exporter (OutGenerator) for waterlevels which currently supports CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
454
2066
2b6a0de47379 Improved the WaterlevelExporter: added range check for W/Q at gauge.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2065
diff changeset
455 FLYSArtifact flys = (FLYSArtifact) master;
2b6a0de47379 Improved the WaterlevelExporter: added range check for W/Q at gauge.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2065
diff changeset
456 Gauge gauge = FLYSUtils.getGauge(flys);
2b6a0de47379 Improved the WaterlevelExporter: added range check for W/Q at gauge.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2065
diff changeset
457 String gaugeName = gauge.getName();
2b6a0de47379 Improved the WaterlevelExporter: added range check for W/Q at gauge.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2065
diff changeset
458 String desc = "";
2b6a0de47379 Improved the WaterlevelExporter: added range check for W/Q at gauge.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2065
diff changeset
459 String notinrange = msg(
2b6a0de47379 Improved the WaterlevelExporter: added range check for W/Q at gauge.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2065
diff changeset
460 CSV_NOT_IN_GAUGE_RANGE,
2b6a0de47379 Improved the WaterlevelExporter: added range check for W/Q at gauge.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2065
diff changeset
461 DEFAULT_CSV_NOT_IN_GAUGE_RANGE);
2b6a0de47379 Improved the WaterlevelExporter: added range check for W/Q at gauge.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2065
diff changeset
462
2b6a0de47379 Improved the WaterlevelExporter: added range check for W/Q at gauge.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2065
diff changeset
463 double a = gauge.getRange().getA().doubleValue();
2b6a0de47379 Improved the WaterlevelExporter: added range check for W/Q at gauge.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2065
diff changeset
464 double b = gauge.getRange().getB().doubleValue();
2065
2f5628f0de0e Part 2 of #125: add gaugename and Q description based on the selected WQ mode.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2063
diff changeset
465
2068
0cf60d64895c #370 Added a 'W at gauge' column to CSV exports if 'W at gauge' mode has been selected.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2066
diff changeset
466 if (flys instanceof WINFOArtifact && isQ) {
2087
bda04ae1154f #196 Localized the WQ labels in CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2068
diff changeset
467 desc = getCSVRowTitle((WINFOArtifact)flys, wqkms);
2065
2f5628f0de0e Part 2 of #125: add gaugename and Q description based on the selected WQ mode.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2063
diff changeset
468 }
2068
0cf60d64895c #370 Added a 'W at gauge' column to CSV exports if 'W at gauge' mode has been selected.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2066
diff changeset
469 else if (!isQ) {
0cf60d64895c #370 Added a 'W at gauge' column to CSV exports if 'W at gauge' mode has been selected.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2066
diff changeset
470 Double value = FLYSUtils.getValueFromWQ(wqkms);
0cf60d64895c #370 Added a 'W at gauge' column to CSV exports if 'W at gauge' mode has been selected.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2066
diff changeset
471 desc = value != null
0cf60d64895c #370 Added a 'W at gauge' column to CSV exports if 'W at gauge' mode has been selected.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2066
diff changeset
472 ? Formatter.getWaterlevelW(context).format(value) : null;
0cf60d64895c #370 Added a 'W at gauge' column to CSV exports if 'W at gauge' mode has been selected.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2066
diff changeset
473 }
2063
97a25b54eea3 Part 1 of #125: added a description for a location to the WaterlevelExport.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2045
diff changeset
474
2144
a4bdf7d8527e Use FastAnnotations for LocationProvider.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 2087
diff changeset
475 long startTime = System.currentTimeMillis();
a4bdf7d8527e Use FastAnnotations for LocationProvider.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 2087
diff changeset
476
3252
62c9bcef0680 Fix issue705 (maín value names also in w/q-range mode).
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents: 2764
diff changeset
477 String colDesc = FLYSUtils.getNamedMainValue((WINFOArtifact)flys,
62c9bcef0680 Fix issue705 (maín value names also in w/q-range mode).
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents: 2764
diff changeset
478 wqkms.getRawValue());
2612
49cfa5c66651 Squashed performance bug introduced in rev4070. Now CSV export is about 245 times faster.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 2596
diff changeset
479
389
69d05357c177 Added an exporter (OutGenerator) for waterlevels which currently supports CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
480 for (int i = 0; i < size; i ++) {
69d05357c177 Added an exporter (OutGenerator) for waterlevels which currently supports CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
481 result = wqkms.get(i, result);
69d05357c177 Added an exporter (OutGenerator) for waterlevels which currently supports CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
482
2065
2f5628f0de0e Part 2 of #125: add gaugename and Q description based on the selected WQ mode.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2063
diff changeset
483 if (atGauge) {
2f5628f0de0e Part 2 of #125: add gaugename and Q description based on the selected WQ mode.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2063
diff changeset
484 writer.writeNext(new String[] {
2f5628f0de0e Part 2 of #125: add gaugename and Q description based on the selected WQ mode.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2063
diff changeset
485 kmf.format(result[2]),
2f5628f0de0e Part 2 of #125: add gaugename and Q description based on the selected WQ mode.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2063
diff changeset
486 wf.format(result[0]),
2f5628f0de0e Part 2 of #125: add gaugename and Q description based on the selected WQ mode.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2063
diff changeset
487 qf.format(result[1]),
2612
49cfa5c66651 Squashed performance bug introduced in rev4070. Now CSV export is about 245 times faster.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 2596
diff changeset
488 colDesc,
2065
2f5628f0de0e Part 2 of #125: add gaugename and Q description based on the selected WQ mode.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2063
diff changeset
489 FLYSUtils.getLocationDescription(flys, result[2]),
2066
2b6a0de47379 Improved the WaterlevelExporter: added range check for W/Q at gauge.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2065
diff changeset
490 result[2] >= a && result[2] <= b
2b6a0de47379 Improved the WaterlevelExporter: added range check for W/Q at gauge.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2065
diff changeset
491 ? gaugeName
2b6a0de47379 Improved the WaterlevelExporter: added range check for W/Q at gauge.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2065
diff changeset
492 : notinrange
2065
2f5628f0de0e Part 2 of #125: add gaugename and Q description based on the selected WQ mode.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2063
diff changeset
493 });
2f5628f0de0e Part 2 of #125: add gaugename and Q description based on the selected WQ mode.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2063
diff changeset
494 }
2f5628f0de0e Part 2 of #125: add gaugename and Q description based on the selected WQ mode.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2063
diff changeset
495 else {
2f5628f0de0e Part 2 of #125: add gaugename and Q description based on the selected WQ mode.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2063
diff changeset
496 writer.writeNext(new String[] {
2f5628f0de0e Part 2 of #125: add gaugename and Q description based on the selected WQ mode.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2063
diff changeset
497 kmf.format(result[2]),
2f5628f0de0e Part 2 of #125: add gaugename and Q description based on the selected WQ mode.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2063
diff changeset
498 wf.format(result[0]),
2f5628f0de0e Part 2 of #125: add gaugename and Q description based on the selected WQ mode.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2063
diff changeset
499 qf.format(result[1]),
2f5628f0de0e Part 2 of #125: add gaugename and Q description based on the selected WQ mode.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2063
diff changeset
500 FLYSUtils.getLocationDescription(flys, result[2])
2f5628f0de0e Part 2 of #125: add gaugename and Q description based on the selected WQ mode.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2063
diff changeset
501 });
2f5628f0de0e Part 2 of #125: add gaugename and Q description based on the selected WQ mode.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2063
diff changeset
502 }
389
69d05357c177 Added an exporter (OutGenerator) for waterlevels which currently supports CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
503 }
2144
a4bdf7d8527e Use FastAnnotations for LocationProvider.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 2087
diff changeset
504
a4bdf7d8527e Use FastAnnotations for LocationProvider.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 2087
diff changeset
505 long stopTime = System.currentTimeMillis();
a4bdf7d8527e Use FastAnnotations for LocationProvider.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 2087
diff changeset
506
a4bdf7d8527e Use FastAnnotations for LocationProvider.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 2087
diff changeset
507 if (logger.isDebugEnabled()) {
a4bdf7d8527e Use FastAnnotations for LocationProvider.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 2087
diff changeset
508 logger.debug("Writing CSV took " +
a4bdf7d8527e Use FastAnnotations for LocationProvider.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 2087
diff changeset
509 (float)(stopTime-startTime)/1000f + " secs.");
a4bdf7d8527e Use FastAnnotations for LocationProvider.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 2087
diff changeset
510 }
389
69d05357c177 Added an exporter (OutGenerator) for waterlevels which currently supports CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
511 }
418
e0fec407a280 ISSUE-53 Formatted number values of CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 416
diff changeset
512
e0fec407a280 ISSUE-53 Formatted number values of CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 416
diff changeset
513
e0fec407a280 ISSUE-53 Formatted number values of CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 416
diff changeset
514 /**
446
c0bec245f608 Implemented writer that creates WSTs and enabled the WaterlevelExporter to create those.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 445
diff changeset
515 * Generates the output in WST format.
c0bec245f608 Implemented writer that creates WSTs and enabled the WaterlevelExporter to create those.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 445
diff changeset
516 */
c0bec245f608 Implemented writer that creates WSTs and enabled the WaterlevelExporter to create those.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 445
diff changeset
517 protected void generateWST()
c0bec245f608 Implemented writer that creates WSTs and enabled the WaterlevelExporter to create those.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 445
diff changeset
518 throws IOException
c0bec245f608 Implemented writer that creates WSTs and enabled the WaterlevelExporter to create those.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 445
diff changeset
519 {
c0bec245f608 Implemented writer that creates WSTs and enabled the WaterlevelExporter to create those.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 445
diff changeset
520 logger.info("WaterlevelExporter.generateWST");
c0bec245f608 Implemented writer that creates WSTs and enabled the WaterlevelExporter to create those.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 445
diff changeset
521
c0bec245f608 Implemented writer that creates WSTs and enabled the WaterlevelExporter to create those.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 445
diff changeset
522 int cols = data.get(0).length;
c0bec245f608 Implemented writer that creates WSTs and enabled the WaterlevelExporter to create those.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 445
diff changeset
523 WstWriter writer = new WstWriter(cols);
c0bec245f608 Implemented writer that creates WSTs and enabled the WaterlevelExporter to create those.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 445
diff changeset
524
c0bec245f608 Implemented writer that creates WSTs and enabled the WaterlevelExporter to create those.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 445
diff changeset
525 writeWSTData(writer);
c0bec245f608 Implemented writer that creates WSTs and enabled the WaterlevelExporter to create those.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 445
diff changeset
526
c0bec245f608 Implemented writer that creates WSTs and enabled the WaterlevelExporter to create those.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 445
diff changeset
527 writer.write(out);
c0bec245f608 Implemented writer that creates WSTs and enabled the WaterlevelExporter to create those.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 445
diff changeset
528 }
c0bec245f608 Implemented writer that creates WSTs and enabled the WaterlevelExporter to create those.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 445
diff changeset
529
c0bec245f608 Implemented writer that creates WSTs and enabled the WaterlevelExporter to create those.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 445
diff changeset
530
c0bec245f608 Implemented writer that creates WSTs and enabled the WaterlevelExporter to create those.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 445
diff changeset
531 protected void writeWSTData(WstWriter writer) {
c0bec245f608 Implemented writer that creates WSTs and enabled the WaterlevelExporter to create those.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 445
diff changeset
532 logger.debug("WaterlevelExporter.writeWSTData");
c0bec245f608 Implemented writer that creates WSTs and enabled the WaterlevelExporter to create those.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 445
diff changeset
533
749
72bcbc308501 The WST export contains the corrected W values now.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 709
diff changeset
534 double[] result = new double[4];
446
c0bec245f608 Implemented writer that creates WSTs and enabled the WaterlevelExporter to create those.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 445
diff changeset
535
c0bec245f608 Implemented writer that creates WSTs and enabled the WaterlevelExporter to create those.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 445
diff changeset
536 for (WQKms[] tmp: data) {
c0bec245f608 Implemented writer that creates WSTs and enabled the WaterlevelExporter to create those.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 445
diff changeset
537 for (WQKms wqkms: tmp) {
c0bec245f608 Implemented writer that creates WSTs and enabled the WaterlevelExporter to create those.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 445
diff changeset
538 int size = wqkms != null ? wqkms.size() : 0;
c0bec245f608 Implemented writer that creates WSTs and enabled the WaterlevelExporter to create those.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 445
diff changeset
539
450
c8bb38115290 Enabled the discharge longitudinal section to be exported as WST.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 447
diff changeset
540 addWSTColumn(writer, wqkms);
447
5606ba4139e0 WSTs will now have a header that contains the names of the Ws or Qs that had been defined for the computation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 446
diff changeset
541
446
c0bec245f608 Implemented writer that creates WSTs and enabled the WaterlevelExporter to create those.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 445
diff changeset
542 for (int i = 0; i < size; i++) {
c0bec245f608 Implemented writer that creates WSTs and enabled the WaterlevelExporter to create those.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 445
diff changeset
543 result = wqkms.get(i, result);
c0bec245f608 Implemented writer that creates WSTs and enabled the WaterlevelExporter to create those.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 445
diff changeset
544
c0bec245f608 Implemented writer that creates WSTs and enabled the WaterlevelExporter to create those.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 445
diff changeset
545 writer.add(result);
c0bec245f608 Implemented writer that creates WSTs and enabled the WaterlevelExporter to create those.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 445
diff changeset
546 }
749
72bcbc308501 The WST export contains the corrected W values now.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 709
diff changeset
547
72bcbc308501 The WST export contains the corrected W values now.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 709
diff changeset
548 if (wqkms instanceof WQCKms) {
72bcbc308501 The WST export contains the corrected W values now.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 709
diff changeset
549 addWSTColumn(writer, wqkms);
72bcbc308501 The WST export contains the corrected W values now.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 709
diff changeset
550
72bcbc308501 The WST export contains the corrected W values now.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 709
diff changeset
551 for (int c = 0; c < size; c++) {
72bcbc308501 The WST export contains the corrected W values now.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 709
diff changeset
552 result = wqkms.get(c, result);
72bcbc308501 The WST export contains the corrected W values now.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 709
diff changeset
553
72bcbc308501 The WST export contains the corrected W values now.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 709
diff changeset
554 writer.addCorrected(result);
72bcbc308501 The WST export contains the corrected W values now.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 709
diff changeset
555 }
72bcbc308501 The WST export contains the corrected W values now.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 709
diff changeset
556 }
446
c0bec245f608 Implemented writer that creates WSTs and enabled the WaterlevelExporter to create those.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 445
diff changeset
557 }
c0bec245f608 Implemented writer that creates WSTs and enabled the WaterlevelExporter to create those.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 445
diff changeset
558 }
c0bec245f608 Implemented writer that creates WSTs and enabled the WaterlevelExporter to create those.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 445
diff changeset
559 }
c0bec245f608 Implemented writer that creates WSTs and enabled the WaterlevelExporter to create those.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 445
diff changeset
560
c0bec245f608 Implemented writer that creates WSTs and enabled the WaterlevelExporter to create those.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 445
diff changeset
561
2038
f73036b991e2 Bugfix: repaired broken named values in exports - the last solution had bad side effects.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2035
diff changeset
562 /**
f73036b991e2 Bugfix: repaired broken named values in exports - the last solution had bad side effects.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2035
diff changeset
563 * This method is used to register a new column at <i>writer</i>. The name /
f73036b991e2 Bugfix: repaired broken named values in exports - the last solution had bad side effects.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2035
diff changeset
564 * title of the column depends on the Q or W value of <i>wqkms</i>. If a Q
f73036b991e2 Bugfix: repaired broken named values in exports - the last solution had bad side effects.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2035
diff changeset
565 * was selected and the Q fits to a named main value, the title is set to
f73036b991e2 Bugfix: repaired broken named values in exports - the last solution had bad side effects.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2035
diff changeset
566 * the named main value. Otherwise, the name returned by
f73036b991e2 Bugfix: repaired broken named values in exports - the last solution had bad side effects.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2035
diff changeset
567 * <i>WQKms.getName()</i> is set.
f73036b991e2 Bugfix: repaired broken named values in exports - the last solution had bad side effects.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2035
diff changeset
568 *
f73036b991e2 Bugfix: repaired broken named values in exports - the last solution had bad side effects.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2035
diff changeset
569 * @param writer The WstWriter.
f73036b991e2 Bugfix: repaired broken named values in exports - the last solution had bad side effects.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2035
diff changeset
570 * @param wqkms The new WST column.
f73036b991e2 Bugfix: repaired broken named values in exports - the last solution had bad side effects.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2035
diff changeset
571 */
450
c8bb38115290 Enabled the discharge longitudinal section to be exported as WST.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 447
diff changeset
572 protected void addWSTColumn(WstWriter writer, WQKms wqkms) {
2038
f73036b991e2 Bugfix: repaired broken named values in exports - the last solution had bad side effects.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2035
diff changeset
573 if (master instanceof WINFOArtifact) {
f73036b991e2 Bugfix: repaired broken named values in exports - the last solution had bad side effects.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2035
diff changeset
574 writer.addColumn(getColumnTitle((WINFOArtifact) master, wqkms));
f73036b991e2 Bugfix: repaired broken named values in exports - the last solution had bad side effects.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2035
diff changeset
575 }
f73036b991e2 Bugfix: repaired broken named values in exports - the last solution had bad side effects.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2035
diff changeset
576 else {
f73036b991e2 Bugfix: repaired broken named values in exports - the last solution had bad side effects.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2035
diff changeset
577 writer.addColumn(wqkms.getName());
f73036b991e2 Bugfix: repaired broken named values in exports - the last solution had bad side effects.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2035
diff changeset
578 }
450
c8bb38115290 Enabled the discharge longitudinal section to be exported as WST.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 447
diff changeset
579 }
c8bb38115290 Enabled the discharge longitudinal section to be exported as WST.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 447
diff changeset
580
c8bb38115290 Enabled the discharge longitudinal section to be exported as WST.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 447
diff changeset
581
446
c0bec245f608 Implemented writer that creates WSTs and enabled the WaterlevelExporter to create those.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 445
diff changeset
582 /**
2176
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
583 *
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
584 */
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
585 @Override
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
586 protected void writePDF(OutputStream out) {
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
587 logger.debug("write PDF");
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
588 WKmsJRDataSource source = createJRData();
2185
a9a8df1473fd Added i18n support to PDF report export.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2182
diff changeset
589
a9a8df1473fd Added i18n support to PDF report export.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2182
diff changeset
590 String jasperFile = Resources.getMsg(
a9a8df1473fd Added i18n support to PDF report export.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2182
diff changeset
591 context.getMeta(),
a9a8df1473fd Added i18n support to PDF report export.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2182
diff changeset
592 JASPER_FILE,
a9a8df1473fd Added i18n support to PDF report export.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2182
diff changeset
593 "/jasper/waterlevel_en.jasper");
a9a8df1473fd Added i18n support to PDF report export.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2182
diff changeset
594 String confPath = Config.getConfigDirectory().toString();
a9a8df1473fd Added i18n support to PDF report export.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2182
diff changeset
595
a9a8df1473fd Added i18n support to PDF report export.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2182
diff changeset
596
2176
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
597 Map parameters = new HashMap();
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
598 parameters.put("ReportTitle", "Exported Data");
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
599 try {
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
600 JasperPrint print = JasperFillManager.fillReport(
2185
a9a8df1473fd Added i18n support to PDF report export.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2182
diff changeset
601 confPath + jasperFile,
2176
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
602 parameters,
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
603 source);
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
604 JasperExportManager.exportReportToPdfStream(print, out);
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
605 }
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
606 catch(JRException je) {
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
607 logger.warn("Error generating PDF Report!");
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
608 je.printStackTrace();
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
609 }
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
610 }
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
611
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
612 protected WKmsJRDataSource createJRData() {
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
613 WKmsJRDataSource source = new WKmsJRDataSource();
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
614
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
615 WQ_MODE mode = FLYSUtils.getWQMode((FLYSArtifact)master);
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
616 boolean atGauge = mode == WQ_MODE.QGAUGE || mode == WQ_MODE.WGAUGE;
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
617 boolean isQ = mode == WQ_MODE.QGAUGE || mode == WQ_MODE.QFREE;
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
618
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
619 addMetaData(source);
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
620 for (WQKms[] tmp: data) {
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
621 for (WQKms wqkms: tmp) {
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
622 addWKmsData(wqkms, atGauge, isQ, source);
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
623 }
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
624 }
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
625 return source;
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
626 }
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
627
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
628 protected void addMetaData(WKmsJRDataSource source) {
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
629 CallMeta meta = context.getMeta();
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
630
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
631 FLYSArtifact flys = (FLYSArtifact) master;
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
632
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
633 source.addMetaData ("river", FLYSUtils.getRivername(flys));
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
634
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
635 Locale locale = Resources.getLocale(meta);
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
636 DateFormat df = DateFormat.getDateInstance(DateFormat.SHORT, locale);
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
637
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
638 source.addMetaData("date", df.format(new Date()));
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
639
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
640 double[] kms = FLYSUtils.getKmRange(flys);
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
641 source.addMetaData("range", kms[0] + " - " + kms[kms.length-1]);
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
642
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
643 source.addMetaData("gauge", FLYSUtils.getGaugename(flys));
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
644
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
645 source.addMetaData("calculation", Resources.getMsg(
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
646 locale,
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
647 PDF_HEADER_MODE,
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
648 "Waterlevel"));
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
649 }
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
650
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
651 protected void addWKmsData(
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
652 WQKms wqkms,
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
653 boolean atGauge,
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
654 boolean isQ,
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
655 WKmsJRDataSource source)
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
656 {
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
657 logger.debug("WaterlevelExporter.addWKmsData");
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
658
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
659 NumberFormat kmf = getKmFormatter();
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
660 NumberFormat wf = getWFormatter();
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
661 NumberFormat qf = getQFormatter();
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
662
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
663 int size = wqkms.size();
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
664 double[] result = new double[3];
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
665
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
666 FLYSArtifact flys = (FLYSArtifact) master;
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
667 Gauge gauge = FLYSUtils.getGauge(flys);
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
668 String gaugeName = gauge.getName();
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
669 String desc = "";
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
670 String notinrange = msg(
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
671 CSV_NOT_IN_GAUGE_RANGE,
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
672 DEFAULT_CSV_NOT_IN_GAUGE_RANGE);
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
673
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
674 double a = gauge.getRange().getA().doubleValue();
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
675 double b = gauge.getRange().getB().doubleValue();
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
676
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
677 if (flys instanceof WINFOArtifact && isQ) {
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
678 desc = getCSVRowTitle((WINFOArtifact)flys, wqkms);
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
679 }
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
680 else if (!isQ) {
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
681 Double value = FLYSUtils.getValueFromWQ(wqkms);
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
682 desc = value != null
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
683 ? Formatter.getWaterlevelW(context).format(value) : null;
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
684 }
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
685
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
686 long startTime = System.currentTimeMillis();
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
687
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
688 for (int i = 0; i < size; i ++) {
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
689 result = wqkms.get(i, result);
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
690
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
691 if (atGauge) {
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
692 source.addData(new String[] {
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
693 kmf.format(result[2]),
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
694 wf.format(result[0]),
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
695 qf.format(result[1]),
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
696 desc,
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
697 FLYSUtils.getLocationDescription(flys, result[2]),
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
698 result[2] >= a && result[2] <= b
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
699 ? gaugeName
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
700 : notinrange
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
701 });
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
702 }
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
703 else {
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
704 source.addData(new String[] {
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
705 kmf.format(result[2]),
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
706 wf.format(result[0]),
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
707 qf.format(result[1]),
2764
f8a1a8af338e Issue 667.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2612
diff changeset
708 desc,
f8a1a8af338e Issue 667.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2612
diff changeset
709 FLYSUtils.getLocationDescription(flys, result[2]),
f8a1a8af338e Issue 667.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2612
diff changeset
710 result[2] >= a && result[2] <= b
f8a1a8af338e Issue 667.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2612
diff changeset
711 ? gaugeName
f8a1a8af338e Issue 667.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2612
diff changeset
712 : notinrange
2176
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
713 });
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
714 }
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
715 }
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
716
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
717 long stopTime = System.currentTimeMillis();
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
718
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
719 if (logger.isDebugEnabled()) {
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
720 logger.debug("Writing PDF data took " +
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
721 (float)(stopTime-startTime)/1000f + " secs.");
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
722 }
65dac9cf6ff5 Issue 138.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 2144
diff changeset
723 }
389
69d05357c177 Added an exporter (OutGenerator) for waterlevels which currently supports CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
724 }
69d05357c177 Added an exporter (OutGenerator) for waterlevels which currently supports CSV exports.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
725 // vim:set ts=4 sw=4 si et sta sts=4 fenc=utf8 :

http://dive4elements.wald.intevation.org