Mercurial > gemma
annotate pkg/controllers/fwa.go @ 5224:fc999a902d87 new-fwa
Write LCD columns.
author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
---|---|
date | Tue, 12 May 2020 11:00:50 +0200 |
parents | d4e4f7232513 |
children | c5599966befe |
rev | line source |
---|---|
5184
445daeefca7b
Added controller stub for new fairway availability.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
1 // This is Free Software under GNU Affero General Public License v >= 3.0 |
445daeefca7b
Added controller stub for new fairway availability.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
2 // without warranty, see README.md and license for details. |
445daeefca7b
Added controller stub for new fairway availability.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
3 // |
445daeefca7b
Added controller stub for new fairway availability.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
4 // SPDX-License-Identifier: AGPL-3.0-or-later |
445daeefca7b
Added controller stub for new fairway availability.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
5 // License-Filename: LICENSES/AGPL-3.0.txt |
445daeefca7b
Added controller stub for new fairway availability.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
6 // |
445daeefca7b
Added controller stub for new fairway availability.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
7 // Copyright (C) 2018, 2019, 2020 by via donau |
445daeefca7b
Added controller stub for new fairway availability.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
8 // – Österreichische Wasserstraßen-Gesellschaft mbH |
445daeefca7b
Added controller stub for new fairway availability.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
9 // Software engineering by Intevation GmbH |
445daeefca7b
Added controller stub for new fairway availability.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
10 // |
445daeefca7b
Added controller stub for new fairway availability.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
11 // Author(s): |
445daeefca7b
Added controller stub for new fairway availability.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
12 // * Sascha L. Teichmann <sascha.teichmann@intevation.de> |
445daeefca7b
Added controller stub for new fairway availability.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
13 |
445daeefca7b
Added controller stub for new fairway availability.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
14 package controllers |
445daeefca7b
Added controller stub for new fairway availability.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
15 |
445daeefca7b
Added controller stub for new fairway availability.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
16 import ( |
5197
c352dbbf2778
Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5196
diff
changeset
|
17 "context" |
c352dbbf2778
Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5196
diff
changeset
|
18 "database/sql" |
5221
6794e85dc2dd
Write headers.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5220
diff
changeset
|
19 "encoding/csv" |
5199
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
20 "fmt" |
5195
d6710d29516b
Started to move code around.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5184
diff
changeset
|
21 "log" |
5184
445daeefca7b
Added controller stub for new fairway availability.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
22 "net/http" |
5203
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
23 "sort" |
5204
7ca9e6c9a203
Introduced type for mode (monthly, quarterly, yearly).
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5203
diff
changeset
|
24 "strconv" |
7ca9e6c9a203
Introduced type for mode (monthly, quarterly, yearly).
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5203
diff
changeset
|
25 "strings" |
5196
5bc8daa986d9
More code movement.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5195
diff
changeset
|
26 "time" |
5184
445daeefca7b
Added controller stub for new fairway availability.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
27 |
5197
c352dbbf2778
Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5196
diff
changeset
|
28 "github.com/gorilla/mux" |
c352dbbf2778
Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5196
diff
changeset
|
29 |
5196
5bc8daa986d9
More code movement.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5195
diff
changeset
|
30 "gemma.intevation.de/gemma/pkg/common" |
5197
c352dbbf2778
Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5196
diff
changeset
|
31 "gemma.intevation.de/gemma/pkg/middleware" |
c352dbbf2778
Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5196
diff
changeset
|
32 ) |
c352dbbf2778
Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5196
diff
changeset
|
33 |
c352dbbf2778
Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5196
diff
changeset
|
34 const ( |
c352dbbf2778
Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5196
diff
changeset
|
35 selectBottlenecksLimitingSQL = ` |
c352dbbf2778
Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5196
diff
changeset
|
36 SELECT |
c352dbbf2778
Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5196
diff
changeset
|
37 lower(validity), |
c352dbbf2778
Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5196
diff
changeset
|
38 upper(validity), |
c352dbbf2778
Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5196
diff
changeset
|
39 limiting |
c352dbbf2778
Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5196
diff
changeset
|
40 FROM |
c352dbbf2778
Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5196
diff
changeset
|
41 waterway.bottlenecks |
c352dbbf2778
Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5196
diff
changeset
|
42 WHERE |
c352dbbf2778
Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5196
diff
changeset
|
43 bottleneck_id = $1 AND |
c352dbbf2778
Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5196
diff
changeset
|
44 validity && tstzrange($2, $3)` |
5199
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
45 |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
46 selectSymbolBottlenecksSQL = ` |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
47 SELECT |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
48 distinct(b.bottleneck_id) |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
49 FROM |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
50 users.%s s, waterway.bottlenecks b |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
51 WHERE |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
52 ST_Intersects(b.area, s.area) |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
53 AND s.name = $1 |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
54 AND b.validity && tstzrange($2, $3)` |
5200
5572da077c89
Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5199
diff
changeset
|
55 |
5572da077c89
Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5199
diff
changeset
|
56 selectLDCsSQL = ` |
5572da077c89
Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5199
diff
changeset
|
57 SELECT |
5572da077c89
Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5199
diff
changeset
|
58 lower(grwl.validity), |
5572da077c89
Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5199
diff
changeset
|
59 upper(grwl.validity), |
5572da077c89
Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5199
diff
changeset
|
60 grwl.value |
5572da077c89
Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5199
diff
changeset
|
61 FROM |
5572da077c89
Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5199
diff
changeset
|
62 waterway.gauges_reference_water_levels grwl |
5572da077c89
Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5199
diff
changeset
|
63 JOIN waterway.bottlenecks bns |
5572da077c89
Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5199
diff
changeset
|
64 ON grwl.location = bns.gauge_location |
5572da077c89
Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5199
diff
changeset
|
65 WHERE |
5572da077c89
Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5199
diff
changeset
|
66 grwl.depth_reference like 'LDC%' |
5572da077c89
Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5199
diff
changeset
|
67 AND bns.bottleneck_id = $1 |
5572da077c89
Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5199
diff
changeset
|
68 AND grwl.validity && tstzrange($2, $3)` |
5202
fbc79c8459b4
Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5201
diff
changeset
|
69 |
fbc79c8459b4
Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5201
diff
changeset
|
70 selectMeasurementsSQL = ` |
fbc79c8459b4
Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5201
diff
changeset
|
71 WITH data AS ( |
fbc79c8459b4
Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5201
diff
changeset
|
72 SELECT |
fbc79c8459b4
Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5201
diff
changeset
|
73 efa.measure_date, |
fbc79c8459b4
Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5201
diff
changeset
|
74 efa.available_depth_value, |
fbc79c8459b4
Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5201
diff
changeset
|
75 efa.available_width_value, |
fbc79c8459b4
Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5201
diff
changeset
|
76 efa.water_level_value |
fbc79c8459b4
Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5201
diff
changeset
|
77 FROM waterway.effective_fairway_availability efa |
fbc79c8459b4
Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5201
diff
changeset
|
78 JOIN waterway.fairway_availability fa |
fbc79c8459b4
Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5201
diff
changeset
|
79 ON efa.fairway_availability_id = fa.id |
fbc79c8459b4
Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5201
diff
changeset
|
80 JOIN waterway.bottlenecks bn |
fbc79c8459b4
Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5201
diff
changeset
|
81 ON fa.bottleneck_id = bn.bottleneck_id |
fbc79c8459b4
Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5201
diff
changeset
|
82 WHERE |
fbc79c8459b4
Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5201
diff
changeset
|
83 bn.bottleneck_id = $1 AND |
fbc79c8459b4
Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5201
diff
changeset
|
84 efa.level_of_service = $2 AND |
fbc79c8459b4
Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5201
diff
changeset
|
85 efa.measure_type = 'Measured' AND |
fbc79c8459b4
Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5201
diff
changeset
|
86 (efa.available_depth_value IS NOT NULL OR |
fbc79c8459b4
Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5201
diff
changeset
|
87 efa.available_width_value IS NOT NULL) AND |
fbc79c8459b4
Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5201
diff
changeset
|
88 efa.water_level_value IS NOT NULL |
fbc79c8459b4
Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5201
diff
changeset
|
89 ), |
fbc79c8459b4
Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5201
diff
changeset
|
90 before AS ( |
fbc79c8459b4
Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5201
diff
changeset
|
91 SELECT * FROM data WHERE measure_date < $3 |
fbc79c8459b4
Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5201
diff
changeset
|
92 ORDER BY measure_date DESC LIMIT 1 |
fbc79c8459b4
Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5201
diff
changeset
|
93 ), |
fbc79c8459b4
Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5201
diff
changeset
|
94 inside AS ( |
fbc79c8459b4
Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5201
diff
changeset
|
95 SELECT * FROM data WHERE measure_date BETWEEN $3 AND $4 |
fbc79c8459b4
Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5201
diff
changeset
|
96 ), |
fbc79c8459b4
Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5201
diff
changeset
|
97 after AS ( |
fbc79c8459b4
Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5201
diff
changeset
|
98 SELECT * FROM data WHERE measure_date > $4 |
fbc79c8459b4
Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5201
diff
changeset
|
99 ORDER BY measure_date LIMIT 1 |
fbc79c8459b4
Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5201
diff
changeset
|
100 ) |
fbc79c8459b4
Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5201
diff
changeset
|
101 SELECT * FROM before |
fbc79c8459b4
Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5201
diff
changeset
|
102 UNION ALL |
fbc79c8459b4
Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5201
diff
changeset
|
103 SELECT * FROM inside |
fbc79c8459b4
Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5201
diff
changeset
|
104 UNION ALL |
fbc79c8459b4
Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5201
diff
changeset
|
105 SELECT * FROM after |
fbc79c8459b4
Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5201
diff
changeset
|
106 ORDER BY measure_date` |
5197
c352dbbf2778
Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5196
diff
changeset
|
107 ) |
c352dbbf2778
Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5196
diff
changeset
|
108 |
c352dbbf2778
Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5196
diff
changeset
|
109 type ( |
5200
5572da077c89
Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5199
diff
changeset
|
110 timeRange struct { |
5572da077c89
Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5199
diff
changeset
|
111 lower time.Time |
5572da077c89
Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5199
diff
changeset
|
112 upper time.Time |
5572da077c89
Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5199
diff
changeset
|
113 } |
5572da077c89
Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5199
diff
changeset
|
114 |
5572da077c89
Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5199
diff
changeset
|
115 ldc struct { |
5572da077c89
Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5199
diff
changeset
|
116 timeRange |
5203
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
117 value []float64 |
5200
5572da077c89
Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5199
diff
changeset
|
118 } |
5572da077c89
Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5199
diff
changeset
|
119 |
5203
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
120 ldcs []*ldc |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
121 |
5210
da6eb8073f77
Introduce separate breaks from depths and widths.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5209
diff
changeset
|
122 limitingFactor int |
da6eb8073f77
Introduce separate breaks from depths and widths.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5209
diff
changeset
|
123 |
5197
c352dbbf2778
Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5196
diff
changeset
|
124 limitingValidity struct { |
5200
5572da077c89
Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5199
diff
changeset
|
125 timeRange |
5210
da6eb8073f77
Introduce separate breaks from depths and widths.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5209
diff
changeset
|
126 limiting limitingFactor |
5203
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
127 ldcs ldcs |
5197
c352dbbf2778
Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5196
diff
changeset
|
128 } |
c352dbbf2778
Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5196
diff
changeset
|
129 |
c352dbbf2778
Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5196
diff
changeset
|
130 limitingValidities []limitingValidity |
5199
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
131 |
5202
fbc79c8459b4
Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5201
diff
changeset
|
132 availMeasurement struct { |
fbc79c8459b4
Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5201
diff
changeset
|
133 when time.Time |
fbc79c8459b4
Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5201
diff
changeset
|
134 depth int16 |
fbc79c8459b4
Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5201
diff
changeset
|
135 width int16 |
fbc79c8459b4
Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5201
diff
changeset
|
136 value int16 |
fbc79c8459b4
Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5201
diff
changeset
|
137 } |
fbc79c8459b4
Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5201
diff
changeset
|
138 |
fbc79c8459b4
Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5201
diff
changeset
|
139 availMeasurements []availMeasurement |
fbc79c8459b4
Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5201
diff
changeset
|
140 |
5199
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
141 bottleneck struct { |
5202
fbc79c8459b4
Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5201
diff
changeset
|
142 id string |
fbc79c8459b4
Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5201
diff
changeset
|
143 validities limitingValidities |
fbc79c8459b4
Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5201
diff
changeset
|
144 measurements availMeasurements |
5199
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
145 } |
5204
7ca9e6c9a203
Introduced type for mode (monthly, quarterly, yearly).
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5203
diff
changeset
|
146 |
5210
da6eb8073f77
Introduce separate breaks from depths and widths.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5209
diff
changeset
|
147 bottlenecks []bottleneck |
da6eb8073f77
Introduce separate breaks from depths and widths.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5209
diff
changeset
|
148 |
5204
7ca9e6c9a203
Introduced type for mode (monthly, quarterly, yearly).
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5203
diff
changeset
|
149 fwaMode int |
5184
445daeefca7b
Added controller stub for new fairway availability.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
150 ) |
445daeefca7b
Added controller stub for new fairway availability.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
151 |
5204
7ca9e6c9a203
Introduced type for mode (monthly, quarterly, yearly).
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5203
diff
changeset
|
152 const ( |
7ca9e6c9a203
Introduced type for mode (monthly, quarterly, yearly).
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5203
diff
changeset
|
153 fwaMonthly fwaMode = iota |
7ca9e6c9a203
Introduced type for mode (monthly, quarterly, yearly).
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5203
diff
changeset
|
154 fwaQuarterly |
7ca9e6c9a203
Introduced type for mode (monthly, quarterly, yearly).
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5203
diff
changeset
|
155 fwaYearly |
7ca9e6c9a203
Introduced type for mode (monthly, quarterly, yearly).
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5203
diff
changeset
|
156 ) |
7ca9e6c9a203
Introduced type for mode (monthly, quarterly, yearly).
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5203
diff
changeset
|
157 |
5210
da6eb8073f77
Introduce separate breaks from depths and widths.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5209
diff
changeset
|
158 const ( |
da6eb8073f77
Introduce separate breaks from depths and widths.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5209
diff
changeset
|
159 limitingDepth limitingFactor = iota |
da6eb8073f77
Introduce separate breaks from depths and widths.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5209
diff
changeset
|
160 limitingWidth |
da6eb8073f77
Introduce separate breaks from depths and widths.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5209
diff
changeset
|
161 ) |
da6eb8073f77
Introduce separate breaks from depths and widths.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5209
diff
changeset
|
162 |
da6eb8073f77
Introduce separate breaks from depths and widths.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5209
diff
changeset
|
163 var limitingAccess = [...]func(*availMeasurement) float64{ |
da6eb8073f77
Introduce separate breaks from depths and widths.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5209
diff
changeset
|
164 limitingDepth: (*availMeasurement).getDepth, |
da6eb8073f77
Introduce separate breaks from depths and widths.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5209
diff
changeset
|
165 limitingWidth: (*availMeasurement).getWidth, |
da6eb8073f77
Introduce separate breaks from depths and widths.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5209
diff
changeset
|
166 } |
da6eb8073f77
Introduce separate breaks from depths and widths.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5209
diff
changeset
|
167 |
5204
7ca9e6c9a203
Introduced type for mode (monthly, quarterly, yearly).
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5203
diff
changeset
|
168 // afdRefs are the typical available fairway depth reference values. |
7ca9e6c9a203
Introduced type for mode (monthly, quarterly, yearly).
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5203
diff
changeset
|
169 var afdRefs = []float64{ |
7ca9e6c9a203
Introduced type for mode (monthly, quarterly, yearly).
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5203
diff
changeset
|
170 230, |
7ca9e6c9a203
Introduced type for mode (monthly, quarterly, yearly).
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5203
diff
changeset
|
171 250, |
7ca9e6c9a203
Introduced type for mode (monthly, quarterly, yearly).
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5203
diff
changeset
|
172 } |
7ca9e6c9a203
Introduced type for mode (monthly, quarterly, yearly).
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5203
diff
changeset
|
173 |
5203
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
174 func (ls ldcs) find(from, to time.Time) *ldc { |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
175 for _, l := range ls { |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
176 if l.intersects(from, to) { |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
177 return l |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
178 } |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
179 } |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
180 return nil |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
181 } |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
182 |
5199
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
183 func fairwayAvailability(rw http.ResponseWriter, req *http.Request) { |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
184 |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
185 from, to, ok := parseFromTo(rw, req) |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
186 if !ok { |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
187 return |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
188 } |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
189 |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
190 vars := mux.Vars(req) |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
191 name := vars["name"] |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
192 if name == "" { |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
193 http.Error(rw, "missing 'name' parameter.", http.StatusBadRequest) |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
194 return |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
195 } |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
196 |
5202
fbc79c8459b4
Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5201
diff
changeset
|
197 los, ok := parseFormInt(rw, req, "los", 1) |
fbc79c8459b4
Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5201
diff
changeset
|
198 if !ok { |
fbc79c8459b4
Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5201
diff
changeset
|
199 return |
fbc79c8459b4
Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5201
diff
changeset
|
200 } |
fbc79c8459b4
Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5201
diff
changeset
|
201 |
5199
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
202 ctx := req.Context() |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
203 conn := middleware.GetDBConn(req) |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
204 |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
205 // Function to extract the bottleneck_id's from the query. |
5210
da6eb8073f77
Introduce separate breaks from depths and widths.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5209
diff
changeset
|
206 var extract func(context.Context, *sql.Conn, string, time.Time, time.Time) (bottlenecks, error) |
5199
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
207 |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
208 switch vars["kind"] { |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
209 case "bottleneck": |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
210 extract = extractBottleneck |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
211 case "stretch": |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
212 extract = extractStretch |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
213 case "section": |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
214 extract = extractSection |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
215 default: |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
216 http.Error(rw, "Invalid kind type.", http.StatusBadRequest) |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
217 return |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
218 } |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
219 |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
220 bottlenecks, err := extract(ctx, conn, name, from, to) |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
221 if err != nil { |
5200
5572da077c89
Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5199
diff
changeset
|
222 log.Printf("error: %v\n", err) |
5199
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
223 http.Error(rw, "cannot extract bottlenecks", http.StatusBadRequest) |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
224 return |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
225 } |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
226 |
5211
8d582b5ff71e
Some checks to prevent trivial errors.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5210
diff
changeset
|
227 // If there are no bottlenecks there is nothing to do. |
8d582b5ff71e
Some checks to prevent trivial errors.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5210
diff
changeset
|
228 if len(bottlenecks) == 0 { |
8d582b5ff71e
Some checks to prevent trivial errors.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5210
diff
changeset
|
229 http.Error(rw, "No bottlenecks found.", http.StatusNotFound) |
8d582b5ff71e
Some checks to prevent trivial errors.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5210
diff
changeset
|
230 return |
8d582b5ff71e
Some checks to prevent trivial errors.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5210
diff
changeset
|
231 } |
8d582b5ff71e
Some checks to prevent trivial errors.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5210
diff
changeset
|
232 |
5199
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
233 // load validities and limiting factors |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
234 for i := range bottlenecks { |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
235 if err := bottlenecks[i].loadLimitingValidities(ctx, conn, from, to); err != nil { |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
236 log.Printf("error: %v\n", err) |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
237 http.Error(rw, "cannot load validities", http.StatusInternalServerError) |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
238 return |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
239 } |
5200
5572da077c89
Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5199
diff
changeset
|
240 // load LCDs |
5572da077c89
Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5199
diff
changeset
|
241 if err := bottlenecks[i].loadLDCs(ctx, conn, from, to); err != nil { |
5572da077c89
Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5199
diff
changeset
|
242 log.Printf("error: %v\n", err) |
5572da077c89
Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5199
diff
changeset
|
243 http.Error(rw, "cannot load LDCs", http.StatusInternalServerError) |
5572da077c89
Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5199
diff
changeset
|
244 return |
5572da077c89
Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5199
diff
changeset
|
245 } |
5202
fbc79c8459b4
Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5201
diff
changeset
|
246 // load values |
fbc79c8459b4
Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5201
diff
changeset
|
247 if err := bottlenecks[i].loadValues(ctx, conn, from, to, los); err != nil { |
fbc79c8459b4
Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5201
diff
changeset
|
248 log.Printf("error: %v\n", err) |
fbc79c8459b4
Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5201
diff
changeset
|
249 http.Error(rw, "cannot load LDCs", http.StatusInternalServerError) |
fbc79c8459b4
Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5201
diff
changeset
|
250 return |
fbc79c8459b4
Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5201
diff
changeset
|
251 } |
5199
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
252 } |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
253 |
5210
da6eb8073f77
Introduce separate breaks from depths and widths.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5209
diff
changeset
|
254 // separate breaks for depth and width |
5212
6c316a4d3386
Pull breaks from the request parameters.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5211
diff
changeset
|
255 var ( |
5214
ebcf33d79d2e
Use breaks to classfify.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5213
diff
changeset
|
256 breaks = parseBreaks(req.FormValue("breaks"), afdRefs) |
ebcf33d79d2e
Use breaks to classfify.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5213
diff
changeset
|
257 depthBreaks = parseBreaks(req.FormValue("depthbreaks"), breaks) |
ebcf33d79d2e
Use breaks to classfify.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5213
diff
changeset
|
258 widthBreaks = parseBreaks(req.FormValue("widthbreaks"), breaks) |
ebcf33d79d2e
Use breaks to classfify.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5213
diff
changeset
|
259 chooseBreaks = [...][]float64{ |
ebcf33d79d2e
Use breaks to classfify.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5213
diff
changeset
|
260 limitingDepth: depthBreaks, |
ebcf33d79d2e
Use breaks to classfify.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5213
diff
changeset
|
261 limitingWidth: widthBreaks, |
ebcf33d79d2e
Use breaks to classfify.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5213
diff
changeset
|
262 } |
ebcf33d79d2e
Use breaks to classfify.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5213
diff
changeset
|
263 |
ebcf33d79d2e
Use breaks to classfify.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5213
diff
changeset
|
264 useDepth = bottlenecks.hasLimiting(limitingDepth, from, to) |
ebcf33d79d2e
Use breaks to classfify.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5213
diff
changeset
|
265 useWidth = bottlenecks.hasLimiting(limitingWidth, from, to) |
5212
6c316a4d3386
Pull breaks from the request parameters.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5211
diff
changeset
|
266 ) |
5210
da6eb8073f77
Introduce separate breaks from depths and widths.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5209
diff
changeset
|
267 |
5212
6c316a4d3386
Pull breaks from the request parameters.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5211
diff
changeset
|
268 if useDepth && useWidth && len(widthBreaks) != len(depthBreaks) { |
5211
8d582b5ff71e
Some checks to prevent trivial errors.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5210
diff
changeset
|
269 http.Error( |
8d582b5ff71e
Some checks to prevent trivial errors.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5210
diff
changeset
|
270 rw, |
8d582b5ff71e
Some checks to prevent trivial errors.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5210
diff
changeset
|
271 fmt.Sprintf("class breaks lengths differ: %d != %d", |
5212
6c316a4d3386
Pull breaks from the request parameters.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5211
diff
changeset
|
272 len(widthBreaks), len(depthBreaks)), |
5211
8d582b5ff71e
Some checks to prevent trivial errors.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5210
diff
changeset
|
273 http.StatusBadRequest, |
8d582b5ff71e
Some checks to prevent trivial errors.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5210
diff
changeset
|
274 ) |
8d582b5ff71e
Some checks to prevent trivial errors.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5210
diff
changeset
|
275 return |
8d582b5ff71e
Some checks to prevent trivial errors.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5210
diff
changeset
|
276 } |
8d582b5ff71e
Some checks to prevent trivial errors.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5210
diff
changeset
|
277 |
5221
6794e85dc2dd
Write headers.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5220
diff
changeset
|
278 availability := vars["type"] == "availability" |
6794e85dc2dd
Write headers.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5220
diff
changeset
|
279 |
6794e85dc2dd
Write headers.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5220
diff
changeset
|
280 var record []string |
6794e85dc2dd
Write headers.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5220
diff
changeset
|
281 if availability { |
6794e85dc2dd
Write headers.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5220
diff
changeset
|
282 // in days |
6794e85dc2dd
Write headers.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5220
diff
changeset
|
283 record = makeHeader(useDepth && useWidth, 1, breaks, 'd') |
6794e85dc2dd
Write headers.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5220
diff
changeset
|
284 } else { |
6794e85dc2dd
Write headers.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5220
diff
changeset
|
285 // percentage |
6794e85dc2dd
Write headers.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5220
diff
changeset
|
286 record = makeHeader(useDepth && useWidth, 3, breaks, '%') |
6794e85dc2dd
Write headers.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5220
diff
changeset
|
287 } |
6794e85dc2dd
Write headers.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5220
diff
changeset
|
288 |
6794e85dc2dd
Write headers.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5220
diff
changeset
|
289 rw.Header().Add("Content-Type", "text/csv") |
6794e85dc2dd
Write headers.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5220
diff
changeset
|
290 |
6794e85dc2dd
Write headers.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5220
diff
changeset
|
291 out := csv.NewWriter(rw) |
6794e85dc2dd
Write headers.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5220
diff
changeset
|
292 |
6794e85dc2dd
Write headers.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5220
diff
changeset
|
293 if err := out.Write(record); err != nil { |
6794e85dc2dd
Write headers.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5220
diff
changeset
|
294 // Too late for HTTP status message. |
6794e85dc2dd
Write headers.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5220
diff
changeset
|
295 log.Printf("error: %v\n", err) |
6794e85dc2dd
Write headers.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5220
diff
changeset
|
296 return |
6794e85dc2dd
Write headers.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5220
diff
changeset
|
297 } |
6794e85dc2dd
Write headers.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5220
diff
changeset
|
298 |
6794e85dc2dd
Write headers.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5220
diff
changeset
|
299 for i := range record[1:] { |
6794e85dc2dd
Write headers.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5220
diff
changeset
|
300 record[i+1] = "0.0" |
6794e85dc2dd
Write headers.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5220
diff
changeset
|
301 } |
6794e85dc2dd
Write headers.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5220
diff
changeset
|
302 |
5203
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
303 // For every day on every bottleneck we need to find out if this day is valid. |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
304 validities := make([]func(time.Time, time.Time) *limitingValidity, len(bottlenecks)) |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
305 for i := range bottlenecks { |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
306 validities[i] = bottlenecks[i].validities.find() |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
307 } |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
308 |
5208
defca5418446
Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5205
diff
changeset
|
309 mode := parseFWAMode(req.FormValue("mode")) |
defca5418446
Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5205
diff
changeset
|
310 |
defca5418446
Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5205
diff
changeset
|
311 label, finish := interval(mode, from) |
defca5418446
Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5205
diff
changeset
|
312 |
5224
fc999a902d87
Write LCD columns.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5223
diff
changeset
|
313 var totalDays, shipableDays int |
5203
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
314 |
5216
91feaf7ac486
Started to accumulate time segments.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5215
diff
changeset
|
315 allClasses := make([][]time.Duration, len(validities)) |
5217
70d83b7d36ef
Track the number days LDCs are not available at bottlenecks.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5216
diff
changeset
|
316 missingLDCs := make([]int, len(validities)) |
5216
91feaf7ac486
Started to accumulate time segments.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5215
diff
changeset
|
317 |
5203
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
318 // We step through the time in steps of one day. |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
319 for current := from; current.Before(to); { |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
320 |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
321 next := current.AddDate(0, 0, 1) |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
322 |
5216
91feaf7ac486
Started to accumulate time segments.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5215
diff
changeset
|
323 // Assume that a bottleneck is shipable. |
5203
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
324 shipable := true |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
325 |
5216
91feaf7ac486
Started to accumulate time segments.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5215
diff
changeset
|
326 // check all bottlenecks |
5203
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
327 for i, validity := range validities { |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
328 |
5216
91feaf7ac486
Started to accumulate time segments.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5215
diff
changeset
|
329 // Assume that this bottleneck cannot be evaluated for this day. |
91feaf7ac486
Started to accumulate time segments.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5215
diff
changeset
|
330 allClasses[i] = nil |
5203
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
331 |
5216
91feaf7ac486
Started to accumulate time segments.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5215
diff
changeset
|
332 // Check if bottleneck is available for this day. |
91feaf7ac486
Started to accumulate time segments.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5215
diff
changeset
|
333 vs := validity(current, next) |
91feaf7ac486
Started to accumulate time segments.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5215
diff
changeset
|
334 if vs == nil { |
91feaf7ac486
Started to accumulate time segments.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5215
diff
changeset
|
335 continue |
91feaf7ac486
Started to accumulate time segments.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5215
diff
changeset
|
336 } |
5203
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
337 |
5216
91feaf7ac486
Started to accumulate time segments.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5215
diff
changeset
|
338 // Let's see if we have a LDC for this day. |
91feaf7ac486
Started to accumulate time segments.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5215
diff
changeset
|
339 ldc := vs.ldcs.find(current, next) |
91feaf7ac486
Started to accumulate time segments.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5215
diff
changeset
|
340 if ldc == nil { |
5217
70d83b7d36ef
Track the number days LDCs are not available at bottlenecks.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5216
diff
changeset
|
341 missingLDCs[i]++ |
5216
91feaf7ac486
Started to accumulate time segments.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5215
diff
changeset
|
342 continue |
91feaf7ac486
Started to accumulate time segments.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5215
diff
changeset
|
343 } |
5203
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
344 |
5216
91feaf7ac486
Started to accumulate time segments.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5215
diff
changeset
|
345 if shipable { // If its already not shipable we need no further tests. |
91feaf7ac486
Started to accumulate time segments.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5215
diff
changeset
|
346 result := bottlenecks[i].measurements.classify( |
5214
ebcf33d79d2e
Use breaks to classfify.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5213
diff
changeset
|
347 current, next, |
5216
91feaf7ac486
Started to accumulate time segments.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5215
diff
changeset
|
348 ldc.value, |
91feaf7ac486
Started to accumulate time segments.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5215
diff
changeset
|
349 (*availMeasurement).getValue) |
5214
ebcf33d79d2e
Use breaks to classfify.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5213
diff
changeset
|
350 |
5216
91feaf7ac486
Started to accumulate time segments.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5215
diff
changeset
|
351 if result[1] < 12*time.Hour { |
91feaf7ac486
Started to accumulate time segments.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5215
diff
changeset
|
352 shipable = false |
91feaf7ac486
Started to accumulate time segments.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5215
diff
changeset
|
353 } |
91feaf7ac486
Started to accumulate time segments.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5215
diff
changeset
|
354 } |
5214
ebcf33d79d2e
Use breaks to classfify.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5213
diff
changeset
|
355 |
5216
91feaf7ac486
Started to accumulate time segments.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5215
diff
changeset
|
356 allClasses[i] = bottlenecks[i].measurements.classify( |
91feaf7ac486
Started to accumulate time segments.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5215
diff
changeset
|
357 current, next, |
91feaf7ac486
Started to accumulate time segments.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5215
diff
changeset
|
358 chooseBreaks[vs.limiting], |
91feaf7ac486
Started to accumulate time segments.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5215
diff
changeset
|
359 limitingAccess[vs.limiting]) |
5203
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
360 } |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
361 |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
362 if shipable { |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
363 shipableDays++ |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
364 } |
5224
fc999a902d87
Write LCD columns.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5223
diff
changeset
|
365 totalDays++ |
5208
defca5418446
Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5205
diff
changeset
|
366 |
5216
91feaf7ac486
Started to accumulate time segments.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5215
diff
changeset
|
367 // TODO: Accumulate daily statistics into time segment. |
91feaf7ac486
Started to accumulate time segments.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5215
diff
changeset
|
368 |
5208
defca5418446
Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5205
diff
changeset
|
369 if finish(next) { |
5224
fc999a902d87
Write LCD columns.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5223
diff
changeset
|
370 record[0] = label(current) |
fc999a902d87
Write LCD columns.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5223
diff
changeset
|
371 |
fc999a902d87
Write LCD columns.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5223
diff
changeset
|
372 if availability { |
fc999a902d87
Write LCD columns.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5223
diff
changeset
|
373 record[1] = strconv.Itoa(totalDays - shipableDays) |
fc999a902d87
Write LCD columns.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5223
diff
changeset
|
374 record[2] = strconv.Itoa(shipableDays) |
fc999a902d87
Write LCD columns.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5223
diff
changeset
|
375 } else { |
fc999a902d87
Write LCD columns.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5223
diff
changeset
|
376 shPerc := float64(shipableDays) * 100 / float64(totalDays) |
fc999a902d87
Write LCD columns.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5223
diff
changeset
|
377 record[1] = fmt.Sprintf("%.3f", 100-shPerc) |
fc999a902d87
Write LCD columns.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5223
diff
changeset
|
378 record[2] = fmt.Sprintf("%.3f", shPerc) |
fc999a902d87
Write LCD columns.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5223
diff
changeset
|
379 } |
fc999a902d87
Write LCD columns.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5223
diff
changeset
|
380 |
5208
defca5418446
Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5205
diff
changeset
|
381 // TODO: depending on mode write out results. |
defca5418446
Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5205
diff
changeset
|
382 |
defca5418446
Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5205
diff
changeset
|
383 // Reset counters |
5224
fc999a902d87
Write LCD columns.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5223
diff
changeset
|
384 shipableDays, totalDays = 0, 0 |
5208
defca5418446
Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5205
diff
changeset
|
385 } |
5203
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
386 |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
387 current = next |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
388 } |
5217
70d83b7d36ef
Track the number days LDCs are not available at bottlenecks.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5216
diff
changeset
|
389 |
70d83b7d36ef
Track the number days LDCs are not available at bottlenecks.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5216
diff
changeset
|
390 // TODO: Log missing LDCs |
5221
6794e85dc2dd
Write headers.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5220
diff
changeset
|
391 |
6794e85dc2dd
Write headers.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5220
diff
changeset
|
392 out.Flush() |
6794e85dc2dd
Write headers.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5220
diff
changeset
|
393 if err := out.Error(); err != nil { |
6794e85dc2dd
Write headers.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5220
diff
changeset
|
394 // Too late for HTTP status message. |
6794e85dc2dd
Write headers.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5220
diff
changeset
|
395 log.Printf("error: %v\n", err) |
6794e85dc2dd
Write headers.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5220
diff
changeset
|
396 } |
5199
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
397 } |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
398 |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
399 func dusk(t time.Time) time.Time { |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
400 return time.Date( |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
401 t.Year(), |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
402 t.Month(), |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
403 t.Day(), |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
404 0, 0, 0, 0, |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
405 t.Location()) |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
406 } |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
407 |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
408 func dawn(t time.Time) time.Time { |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
409 return time.Date( |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
410 t.Year(), |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
411 t.Month(), |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
412 t.Day(), |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
413 23, 59, 59, 999999999, |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
414 t.Location()) |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
415 } |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
416 |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
417 func parseFromTo( |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
418 rw http.ResponseWriter, |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
419 req *http.Request, |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
420 ) (time.Time, time.Time, bool) { |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
421 from, ok := parseFormTime(rw, req, "from", time.Now().AddDate(-1, 0, 0)) |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
422 if !ok { |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
423 return time.Time{}, time.Time{}, false |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
424 } |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
425 |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
426 to, ok := parseFormTime(rw, req, "to", from.AddDate(1, 0, 0)) |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
427 if !ok { |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
428 return time.Time{}, time.Time{}, false |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
429 } |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
430 |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
431 from, to = common.OrderTime(from, to) |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
432 // Operate on daily basis so go to full days. |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
433 return dusk(from), dawn(to), true |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
434 } |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
435 |
5204
7ca9e6c9a203
Introduced type for mode (monthly, quarterly, yearly).
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5203
diff
changeset
|
436 func parseFWAMode(mode string) fwaMode { |
7ca9e6c9a203
Introduced type for mode (monthly, quarterly, yearly).
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5203
diff
changeset
|
437 switch strings.ToLower(mode) { |
7ca9e6c9a203
Introduced type for mode (monthly, quarterly, yearly).
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5203
diff
changeset
|
438 case "monthly": |
7ca9e6c9a203
Introduced type for mode (monthly, quarterly, yearly).
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5203
diff
changeset
|
439 return fwaMonthly |
7ca9e6c9a203
Introduced type for mode (monthly, quarterly, yearly).
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5203
diff
changeset
|
440 case "quarterly": |
7ca9e6c9a203
Introduced type for mode (monthly, quarterly, yearly).
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5203
diff
changeset
|
441 return fwaQuarterly |
7ca9e6c9a203
Introduced type for mode (monthly, quarterly, yearly).
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5203
diff
changeset
|
442 case "yearly": |
7ca9e6c9a203
Introduced type for mode (monthly, quarterly, yearly).
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5203
diff
changeset
|
443 return fwaYearly |
7ca9e6c9a203
Introduced type for mode (monthly, quarterly, yearly).
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5203
diff
changeset
|
444 default: |
7ca9e6c9a203
Introduced type for mode (monthly, quarterly, yearly).
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5203
diff
changeset
|
445 return fwaMonthly |
7ca9e6c9a203
Introduced type for mode (monthly, quarterly, yearly).
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5203
diff
changeset
|
446 } |
7ca9e6c9a203
Introduced type for mode (monthly, quarterly, yearly).
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5203
diff
changeset
|
447 } |
7ca9e6c9a203
Introduced type for mode (monthly, quarterly, yearly).
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5203
diff
changeset
|
448 |
7ca9e6c9a203
Introduced type for mode (monthly, quarterly, yearly).
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5203
diff
changeset
|
449 func breaksToReferenceValue(breaks string) []float64 { |
7ca9e6c9a203
Introduced type for mode (monthly, quarterly, yearly).
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5203
diff
changeset
|
450 parts := strings.Split(breaks, ",") |
7ca9e6c9a203
Introduced type for mode (monthly, quarterly, yearly).
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5203
diff
changeset
|
451 var values []float64 |
7ca9e6c9a203
Introduced type for mode (monthly, quarterly, yearly).
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5203
diff
changeset
|
452 |
7ca9e6c9a203
Introduced type for mode (monthly, quarterly, yearly).
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5203
diff
changeset
|
453 for _, part := range parts { |
7ca9e6c9a203
Introduced type for mode (monthly, quarterly, yearly).
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5203
diff
changeset
|
454 part = strings.TrimSpace(part) |
7ca9e6c9a203
Introduced type for mode (monthly, quarterly, yearly).
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5203
diff
changeset
|
455 if v, err := strconv.ParseFloat(part, 64); err == nil { |
7ca9e6c9a203
Introduced type for mode (monthly, quarterly, yearly).
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5203
diff
changeset
|
456 values = append(values, v) |
7ca9e6c9a203
Introduced type for mode (monthly, quarterly, yearly).
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5203
diff
changeset
|
457 } |
7ca9e6c9a203
Introduced type for mode (monthly, quarterly, yearly).
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5203
diff
changeset
|
458 } |
7ca9e6c9a203
Introduced type for mode (monthly, quarterly, yearly).
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5203
diff
changeset
|
459 |
7ca9e6c9a203
Introduced type for mode (monthly, quarterly, yearly).
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5203
diff
changeset
|
460 return common.DedupFloat64s(values) |
7ca9e6c9a203
Introduced type for mode (monthly, quarterly, yearly).
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5203
diff
changeset
|
461 } |
7ca9e6c9a203
Introduced type for mode (monthly, quarterly, yearly).
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5203
diff
changeset
|
462 |
5213
de417840dfee
Made breaks defaults more sensible
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5212
diff
changeset
|
463 func parseBreaks(breaks string, defaults []float64) []float64 { |
5204
7ca9e6c9a203
Introduced type for mode (monthly, quarterly, yearly).
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5203
diff
changeset
|
464 if breaks != "" { |
7ca9e6c9a203
Introduced type for mode (monthly, quarterly, yearly).
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5203
diff
changeset
|
465 return breaksToReferenceValue(breaks) |
7ca9e6c9a203
Introduced type for mode (monthly, quarterly, yearly).
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5203
diff
changeset
|
466 } |
5213
de417840dfee
Made breaks defaults more sensible
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5212
diff
changeset
|
467 return defaults |
5204
7ca9e6c9a203
Introduced type for mode (monthly, quarterly, yearly).
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5203
diff
changeset
|
468 } |
7ca9e6c9a203
Introduced type for mode (monthly, quarterly, yearly).
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5203
diff
changeset
|
469 |
5200
5572da077c89
Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5199
diff
changeset
|
470 func (tr *timeRange) intersects(from, to time.Time) bool { |
5572da077c89
Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5199
diff
changeset
|
471 return !(to.Before(tr.lower) || from.After(tr.upper)) |
5197
c352dbbf2778
Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5196
diff
changeset
|
472 } |
c352dbbf2778
Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5196
diff
changeset
|
473 |
5201
40daecc6f552
Made timeranges all UTC.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5200
diff
changeset
|
474 func (tr *timeRange) toUTC() { |
40daecc6f552
Made timeranges all UTC.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5200
diff
changeset
|
475 tr.lower = tr.lower.UTC() |
40daecc6f552
Made timeranges all UTC.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5200
diff
changeset
|
476 tr.upper = tr.upper.UTC() |
40daecc6f552
Made timeranges all UTC.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5200
diff
changeset
|
477 } |
40daecc6f552
Made timeranges all UTC.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5200
diff
changeset
|
478 |
5197
c352dbbf2778
Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5196
diff
changeset
|
479 func (lvs limitingValidities) find() func(from, to time.Time) *limitingValidity { |
c352dbbf2778
Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5196
diff
changeset
|
480 |
c352dbbf2778
Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5196
diff
changeset
|
481 var last *limitingValidity |
c352dbbf2778
Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5196
diff
changeset
|
482 |
c352dbbf2778
Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5196
diff
changeset
|
483 return func(from, to time.Time) *limitingValidity { |
c352dbbf2778
Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5196
diff
changeset
|
484 if last != nil && last.intersects(from, to) { |
c352dbbf2778
Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5196
diff
changeset
|
485 return last |
c352dbbf2778
Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5196
diff
changeset
|
486 } |
c352dbbf2778
Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5196
diff
changeset
|
487 for i := range lvs { |
c352dbbf2778
Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5196
diff
changeset
|
488 if lv := &lvs[i]; lv.intersects(from, to) { |
c352dbbf2778
Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5196
diff
changeset
|
489 last = lv |
c352dbbf2778
Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5196
diff
changeset
|
490 return lv |
c352dbbf2778
Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5196
diff
changeset
|
491 } |
c352dbbf2778
Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5196
diff
changeset
|
492 } |
c352dbbf2778
Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5196
diff
changeset
|
493 return nil |
c352dbbf2778
Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5196
diff
changeset
|
494 } |
c352dbbf2778
Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5196
diff
changeset
|
495 } |
c352dbbf2778
Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5196
diff
changeset
|
496 |
5210
da6eb8073f77
Introduce separate breaks from depths and widths.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5209
diff
changeset
|
497 func (lvs limitingValidities) hasLimiting(limiting limitingFactor, from, to time.Time) bool { |
da6eb8073f77
Introduce separate breaks from depths and widths.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5209
diff
changeset
|
498 for i := range lvs { |
da6eb8073f77
Introduce separate breaks from depths and widths.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5209
diff
changeset
|
499 if lvs[i].limiting == limiting && lvs[i].intersects(from, to) { |
da6eb8073f77
Introduce separate breaks from depths and widths.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5209
diff
changeset
|
500 return true |
da6eb8073f77
Introduce separate breaks from depths and widths.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5209
diff
changeset
|
501 } |
da6eb8073f77
Introduce separate breaks from depths and widths.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5209
diff
changeset
|
502 } |
da6eb8073f77
Introduce separate breaks from depths and widths.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5209
diff
changeset
|
503 return false |
da6eb8073f77
Introduce separate breaks from depths and widths.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5209
diff
changeset
|
504 } |
da6eb8073f77
Introduce separate breaks from depths and widths.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5209
diff
changeset
|
505 |
da6eb8073f77
Introduce separate breaks from depths and widths.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5209
diff
changeset
|
506 func (bns bottlenecks) hasLimiting(limiting limitingFactor, from, to time.Time) bool { |
da6eb8073f77
Introduce separate breaks from depths and widths.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5209
diff
changeset
|
507 for i := range bns { |
da6eb8073f77
Introduce separate breaks from depths and widths.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5209
diff
changeset
|
508 if bns[i].validities.hasLimiting(limiting, from, to) { |
da6eb8073f77
Introduce separate breaks from depths and widths.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5209
diff
changeset
|
509 return true |
da6eb8073f77
Introduce separate breaks from depths and widths.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5209
diff
changeset
|
510 } |
da6eb8073f77
Introduce separate breaks from depths and widths.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5209
diff
changeset
|
511 } |
da6eb8073f77
Introduce separate breaks from depths and widths.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5209
diff
changeset
|
512 return false |
da6eb8073f77
Introduce separate breaks from depths and widths.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5209
diff
changeset
|
513 } |
da6eb8073f77
Introduce separate breaks from depths and widths.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5209
diff
changeset
|
514 |
da6eb8073f77
Introduce separate breaks from depths and widths.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5209
diff
changeset
|
515 func parseLimitingFactor(limiting string) limitingFactor { |
5203
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
516 switch limiting { |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
517 case "depth": |
5210
da6eb8073f77
Introduce separate breaks from depths and widths.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5209
diff
changeset
|
518 return limitingDepth |
5203
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
519 case "width": |
5210
da6eb8073f77
Introduce separate breaks from depths and widths.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5209
diff
changeset
|
520 return limitingWidth |
5203
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
521 default: |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
522 log.Printf("warn: unknown limitation '%s'. default to 'depth'\n", limiting) |
5210
da6eb8073f77
Introduce separate breaks from depths and widths.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5209
diff
changeset
|
523 return limitingDepth |
5203
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
524 } |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
525 } |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
526 |
5197
c352dbbf2778
Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5196
diff
changeset
|
527 func loadLimitingValidities( |
c352dbbf2778
Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5196
diff
changeset
|
528 ctx context.Context, |
c352dbbf2778
Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5196
diff
changeset
|
529 conn *sql.Conn, |
c352dbbf2778
Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5196
diff
changeset
|
530 bottleneckID string, |
c352dbbf2778
Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5196
diff
changeset
|
531 from, to time.Time, |
c352dbbf2778
Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5196
diff
changeset
|
532 ) (limitingValidities, error) { |
c352dbbf2778
Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5196
diff
changeset
|
533 |
c352dbbf2778
Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5196
diff
changeset
|
534 var lvs limitingValidities |
c352dbbf2778
Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5196
diff
changeset
|
535 |
c352dbbf2778
Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5196
diff
changeset
|
536 rows, err := conn.QueryContext( |
c352dbbf2778
Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5196
diff
changeset
|
537 ctx, |
5223
d4e4f7232513
Removed old bottlenecks controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5221
diff
changeset
|
538 selectBottlenecksLimitingSQL, |
5197
c352dbbf2778
Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5196
diff
changeset
|
539 from, to) |
c352dbbf2778
Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5196
diff
changeset
|
540 |
c352dbbf2778
Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5196
diff
changeset
|
541 if err != nil { |
c352dbbf2778
Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5196
diff
changeset
|
542 return nil, err |
c352dbbf2778
Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5196
diff
changeset
|
543 } |
c352dbbf2778
Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5196
diff
changeset
|
544 defer rows.Close() |
c352dbbf2778
Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5196
diff
changeset
|
545 |
c352dbbf2778
Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5196
diff
changeset
|
546 for rows.Next() { |
c352dbbf2778
Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5196
diff
changeset
|
547 var lv limitingValidity |
5210
da6eb8073f77
Introduce separate breaks from depths and widths.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5209
diff
changeset
|
548 var limiting string |
5197
c352dbbf2778
Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5196
diff
changeset
|
549 if err := rows.Scan( |
5210
da6eb8073f77
Introduce separate breaks from depths and widths.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5209
diff
changeset
|
550 &limiting, |
5197
c352dbbf2778
Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5196
diff
changeset
|
551 &lv.lower, |
c352dbbf2778
Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5196
diff
changeset
|
552 &lv.upper, |
c352dbbf2778
Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5196
diff
changeset
|
553 ); err != nil { |
c352dbbf2778
Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5196
diff
changeset
|
554 return nil, err |
c352dbbf2778
Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5196
diff
changeset
|
555 } |
5201
40daecc6f552
Made timeranges all UTC.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5200
diff
changeset
|
556 lv.toUTC() |
5210
da6eb8073f77
Introduce separate breaks from depths and widths.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5209
diff
changeset
|
557 lv.limiting = parseLimitingFactor(limiting) |
5197
c352dbbf2778
Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5196
diff
changeset
|
558 lvs = append(lvs, lv) |
c352dbbf2778
Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5196
diff
changeset
|
559 } |
c352dbbf2778
Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5196
diff
changeset
|
560 |
c352dbbf2778
Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5196
diff
changeset
|
561 return lvs, rows.Err() |
c352dbbf2778
Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5196
diff
changeset
|
562 } |
c352dbbf2778
Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5196
diff
changeset
|
563 |
5199
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
564 func loadSymbolBottlenecksFromTo( |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
565 ctx context.Context, |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
566 conn *sql.Conn, |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
567 what, name string, |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
568 from, to time.Time, |
5210
da6eb8073f77
Introduce separate breaks from depths and widths.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5209
diff
changeset
|
569 ) (bottlenecks, error) { |
5184
445daeefca7b
Added controller stub for new fairway availability.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
570 |
5199
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
571 rows, err := conn.QueryContext( |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
572 ctx, |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
573 fmt.Sprintf(selectSymbolBottlenecksSQL, what), |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
574 name, |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
575 from, to) |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
576 if err != nil { |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
577 return nil, err |
5184
445daeefca7b
Added controller stub for new fairway availability.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
578 } |
5199
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
579 defer rows.Close() |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
580 |
5210
da6eb8073f77
Introduce separate breaks from depths and widths.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5209
diff
changeset
|
581 var bns bottlenecks |
5199
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
582 |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
583 for rows.Next() { |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
584 var b bottleneck |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
585 if err := rows.Scan(&b.id); err != nil { |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
586 return nil, err |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
587 } |
5210
da6eb8073f77
Introduce separate breaks from depths and widths.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5209
diff
changeset
|
588 bns = append(bns, b) |
5199
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
589 } |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
590 |
5210
da6eb8073f77
Introduce separate breaks from depths and widths.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5209
diff
changeset
|
591 return bns, rows.Err() |
5184
445daeefca7b
Added controller stub for new fairway availability.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
592 } |
5195
d6710d29516b
Started to move code around.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5184
diff
changeset
|
593 |
5199
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
594 func extractBottleneck( |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
595 _ context.Context, |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
596 _ *sql.Conn, |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
597 name string, |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
598 _, _ time.Time, |
5210
da6eb8073f77
Introduce separate breaks from depths and widths.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5209
diff
changeset
|
599 ) (bottlenecks, error) { |
da6eb8073f77
Introduce separate breaks from depths and widths.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5209
diff
changeset
|
600 return bottlenecks{{id: name}}, nil |
5196
5bc8daa986d9
More code movement.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5195
diff
changeset
|
601 } |
5bc8daa986d9
More code movement.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5195
diff
changeset
|
602 |
5199
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
603 func extractStretch( |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
604 ctx context.Context, |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
605 conn *sql.Conn, |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
606 name string, |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
607 from, to time.Time, |
5210
da6eb8073f77
Introduce separate breaks from depths and widths.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5209
diff
changeset
|
608 ) (bottlenecks, error) { |
5199
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
609 return loadSymbolBottlenecksFromTo( |
5197
c352dbbf2778
Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5196
diff
changeset
|
610 ctx, |
c352dbbf2778
Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5196
diff
changeset
|
611 conn, |
5199
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
612 "stretches", name, |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
613 from, to) |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
614 } |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
615 |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
616 func extractSection( |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
617 ctx context.Context, |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
618 conn *sql.Conn, |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
619 name string, |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
620 from, to time.Time, |
5210
da6eb8073f77
Introduce separate breaks from depths and widths.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5209
diff
changeset
|
621 ) (bottlenecks, error) { |
5199
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
622 return loadSymbolBottlenecksFromTo( |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
623 ctx, |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
624 conn, |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
625 "sections", name, |
5197
c352dbbf2778
Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5196
diff
changeset
|
626 from, to) |
5199
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
627 } |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
628 |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
629 func (bn *bottleneck) loadLimitingValidities( |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
630 ctx context.Context, |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
631 conn *sql.Conn, |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
632 from, to time.Time, |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
633 ) error { |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
634 vs, err := loadLimitingValidities( |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
635 ctx, |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
636 conn, |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
637 bn.id, |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
638 from, to) |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
639 if err == nil { |
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
640 bn.validities = vs |
5197
c352dbbf2778
Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5196
diff
changeset
|
641 } |
5199
5001582f2ee1
Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5197
diff
changeset
|
642 return err |
5195
d6710d29516b
Started to move code around.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5184
diff
changeset
|
643 } |
5200
5572da077c89
Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5199
diff
changeset
|
644 |
5572da077c89
Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5199
diff
changeset
|
645 func (bn *bottleneck) loadLDCs( |
5572da077c89
Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5199
diff
changeset
|
646 ctx context.Context, |
5572da077c89
Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5199
diff
changeset
|
647 conn *sql.Conn, |
5572da077c89
Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5199
diff
changeset
|
648 from, to time.Time, |
5572da077c89
Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5199
diff
changeset
|
649 ) error { |
5572da077c89
Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5199
diff
changeset
|
650 rows, err := conn.QueryContext( |
5572da077c89
Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5199
diff
changeset
|
651 ctx, selectLDCsSQL, |
5572da077c89
Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5199
diff
changeset
|
652 bn.id, |
5572da077c89
Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5199
diff
changeset
|
653 from, to) |
5572da077c89
Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5199
diff
changeset
|
654 if err != nil { |
5572da077c89
Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5199
diff
changeset
|
655 return err |
5572da077c89
Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5199
diff
changeset
|
656 } |
5572da077c89
Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5199
diff
changeset
|
657 defer rows.Close() |
5572da077c89
Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5199
diff
changeset
|
658 for rows.Next() { |
5203
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
659 l := ldc{value: []float64{0}} |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
660 if err := rows.Scan(&l.lower, &l.upper, &l.value[0]); err != nil { |
5200
5572da077c89
Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5199
diff
changeset
|
661 return err |
5572da077c89
Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5199
diff
changeset
|
662 } |
5201
40daecc6f552
Made timeranges all UTC.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5200
diff
changeset
|
663 l.toUTC() |
5200
5572da077c89
Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5199
diff
changeset
|
664 for i := range bn.validities { |
5572da077c89
Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5199
diff
changeset
|
665 vs := bn.validities[i] |
5572da077c89
Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5199
diff
changeset
|
666 if vs.intersects(l.lower, l.upper) { |
5572da077c89
Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5199
diff
changeset
|
667 vs.ldcs = append(vs.ldcs, &l) |
5572da077c89
Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5199
diff
changeset
|
668 } |
5572da077c89
Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5199
diff
changeset
|
669 } |
5572da077c89
Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5199
diff
changeset
|
670 } |
5202
fbc79c8459b4
Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5201
diff
changeset
|
671 return rows.Err() |
fbc79c8459b4
Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5201
diff
changeset
|
672 } |
fbc79c8459b4
Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5201
diff
changeset
|
673 |
fbc79c8459b4
Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5201
diff
changeset
|
674 func (bn *bottleneck) loadValues( |
fbc79c8459b4
Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5201
diff
changeset
|
675 ctx context.Context, |
fbc79c8459b4
Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5201
diff
changeset
|
676 conn *sql.Conn, |
fbc79c8459b4
Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5201
diff
changeset
|
677 from, to time.Time, |
fbc79c8459b4
Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5201
diff
changeset
|
678 los int, |
fbc79c8459b4
Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5201
diff
changeset
|
679 ) error { |
fbc79c8459b4
Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5201
diff
changeset
|
680 rows, err := conn.QueryContext( |
fbc79c8459b4
Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5201
diff
changeset
|
681 ctx, selectMeasurementsSQL, |
fbc79c8459b4
Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5201
diff
changeset
|
682 bn.id, |
fbc79c8459b4
Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5201
diff
changeset
|
683 from, to, |
fbc79c8459b4
Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5201
diff
changeset
|
684 los) |
fbc79c8459b4
Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5201
diff
changeset
|
685 if err != nil { |
fbc79c8459b4
Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5201
diff
changeset
|
686 return err |
fbc79c8459b4
Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5201
diff
changeset
|
687 } |
fbc79c8459b4
Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5201
diff
changeset
|
688 defer rows.Close() |
fbc79c8459b4
Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5201
diff
changeset
|
689 |
fbc79c8459b4
Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5201
diff
changeset
|
690 var ms availMeasurements |
fbc79c8459b4
Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5201
diff
changeset
|
691 |
fbc79c8459b4
Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5201
diff
changeset
|
692 for rows.Next() { |
fbc79c8459b4
Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5201
diff
changeset
|
693 var m availMeasurement |
fbc79c8459b4
Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5201
diff
changeset
|
694 if err := rows.Scan( |
fbc79c8459b4
Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5201
diff
changeset
|
695 &m.when, |
fbc79c8459b4
Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5201
diff
changeset
|
696 &m.depth, |
fbc79c8459b4
Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5201
diff
changeset
|
697 &m.width, |
fbc79c8459b4
Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5201
diff
changeset
|
698 &m.value, |
fbc79c8459b4
Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5201
diff
changeset
|
699 ); err != nil { |
fbc79c8459b4
Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5201
diff
changeset
|
700 return err |
fbc79c8459b4
Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5201
diff
changeset
|
701 } |
fbc79c8459b4
Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5201
diff
changeset
|
702 m.when = m.when.UTC() |
fbc79c8459b4
Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5201
diff
changeset
|
703 ms = append(ms, m) |
fbc79c8459b4
Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5201
diff
changeset
|
704 } |
fbc79c8459b4
Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5201
diff
changeset
|
705 if err := rows.Err(); err != nil { |
fbc79c8459b4
Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5201
diff
changeset
|
706 return err |
fbc79c8459b4
Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5201
diff
changeset
|
707 } |
fbc79c8459b4
Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5201
diff
changeset
|
708 bn.measurements = ms |
5200
5572da077c89
Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5199
diff
changeset
|
709 return nil |
5572da077c89
Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5199
diff
changeset
|
710 } |
5203
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
711 |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
712 func (measurement *availMeasurement) getDepth() float64 { |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
713 return float64(measurement.depth) |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
714 } |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
715 |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
716 func (measurement *availMeasurement) getValue() float64 { |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
717 return float64(measurement.value) |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
718 } |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
719 |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
720 func (measurement *availMeasurement) getWidth() float64 { |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
721 return float64(measurement.width) |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
722 } |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
723 |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
724 func (measurements availMeasurements) classify( |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
725 from, to time.Time, |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
726 breaks []float64, |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
727 access func(*availMeasurement) float64, |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
728 ) []time.Duration { |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
729 |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
730 if len(breaks) == 0 { |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
731 return []time.Duration{} |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
732 } |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
733 |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
734 result := make([]time.Duration, len(breaks)+1) |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
735 classes := make([]float64, len(breaks)+2) |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
736 values := make([]time.Time, len(classes)) |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
737 |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
738 // Add sentinels |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
739 classes[0] = breaks[0] - 9999 |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
740 classes[len(classes)-1] = breaks[len(breaks)-1] + 9999 |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
741 for i := range breaks { |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
742 classes[i+1] = breaks[i] |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
743 } |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
744 |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
745 idx := sort.Search(len(measurements), func(i int) bool { |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
746 // All values before from can be ignored. |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
747 return !measurements[i].when.Before(from) |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
748 }) |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
749 |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
750 if idx >= len(measurements) { |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
751 return result |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
752 } |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
753 |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
754 // Be safe for interpolation. |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
755 if idx > 0 { |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
756 idx-- |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
757 } |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
758 |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
759 measurements = measurements[idx:] |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
760 |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
761 for i := 0; i < len(measurements)-1; i++ { |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
762 p1 := &measurements[i] |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
763 p2 := &measurements[i+1] |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
764 |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
765 if p1.when.After(to) { |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
766 return result |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
767 } |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
768 |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
769 if p2.when.Before(from) { |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
770 continue |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
771 } |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
772 |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
773 if p2.when.Sub(p1.when).Hours() > 1.5 { |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
774 // Don't interpolate ranges bigger then one and a half hour |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
775 continue |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
776 } |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
777 |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
778 lo, hi := common.MaxTime(p1.when, from), common.MinTime(p2.when, to) |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
779 |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
780 m1, m2 := access(p1), access(p2) |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
781 if m1 == m2 { // The whole interval is in only one class. |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
782 for j := 0; j < len(classes)-1; j++ { |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
783 if classes[j] <= m1 && m1 <= classes[j+1] { |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
784 result[j] += hi.Sub(lo) |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
785 break |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
786 } |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
787 } |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
788 continue |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
789 } |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
790 |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
791 f := common.InterpolateTime( |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
792 p1.when, m1, |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
793 p2.when, m2, |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
794 ) |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
795 |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
796 for j, c := range classes { |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
797 values[j] = f(c) |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
798 } |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
799 |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
800 for j := 0; j < len(values)-1; j++ { |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
801 start, end := common.OrderTime(values[j], values[j+1]) |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
802 |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
803 if start.After(hi) || end.Before(lo) { |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
804 continue |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
805 } |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
806 |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
807 start, end = common.MaxTime(start, lo), common.MinTime(end, hi) |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
808 result[j] += end.Sub(start) |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
809 } |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
810 } |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
811 |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
812 return result |
355195a90298
Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5202
diff
changeset
|
813 } |
5208
defca5418446
Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5205
diff
changeset
|
814 |
defca5418446
Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5205
diff
changeset
|
815 func interval(mode fwaMode, t time.Time) ( |
defca5418446
Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5205
diff
changeset
|
816 label func(time.Time) string, |
defca5418446
Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5205
diff
changeset
|
817 finish func(time.Time) bool, |
defca5418446
Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5205
diff
changeset
|
818 ) { |
defca5418446
Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5205
diff
changeset
|
819 switch mode { |
defca5418446
Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5205
diff
changeset
|
820 case fwaMonthly: |
defca5418446
Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5205
diff
changeset
|
821 label, finish = monthLabel, otherMonth(t) |
defca5418446
Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5205
diff
changeset
|
822 case fwaQuarterly: |
defca5418446
Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5205
diff
changeset
|
823 label, finish = quarterLabel, otherQuarter(t) |
defca5418446
Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5205
diff
changeset
|
824 case fwaYearly: |
defca5418446
Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5205
diff
changeset
|
825 label, finish = yearLabel, otherYear(t) |
defca5418446
Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5205
diff
changeset
|
826 default: |
defca5418446
Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5205
diff
changeset
|
827 panic("Unknown mode") |
defca5418446
Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5205
diff
changeset
|
828 } |
defca5418446
Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5205
diff
changeset
|
829 return |
defca5418446
Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5205
diff
changeset
|
830 } |
defca5418446
Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5205
diff
changeset
|
831 |
defca5418446
Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5205
diff
changeset
|
832 func monthLabel(t time.Time) string { |
defca5418446
Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5205
diff
changeset
|
833 return fmt.Sprintf("%02d-%d", t.Month(), t.Year()) |
defca5418446
Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5205
diff
changeset
|
834 } |
defca5418446
Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5205
diff
changeset
|
835 |
defca5418446
Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5205
diff
changeset
|
836 func quarterLabel(t time.Time) string { |
defca5418446
Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5205
diff
changeset
|
837 return fmt.Sprintf("Q%d-%d", (int(t.Month())-1)/3+1, t.Year()) |
defca5418446
Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5205
diff
changeset
|
838 } |
defca5418446
Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5205
diff
changeset
|
839 |
defca5418446
Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5205
diff
changeset
|
840 func yearLabel(t time.Time) string { |
defca5418446
Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5205
diff
changeset
|
841 return strconv.Itoa(t.Year()) |
defca5418446
Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5205
diff
changeset
|
842 } |
defca5418446
Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5205
diff
changeset
|
843 |
defca5418446
Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5205
diff
changeset
|
844 func otherMonth(t time.Time) func(time.Time) bool { |
defca5418446
Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5205
diff
changeset
|
845 return func(x time.Time) bool { |
defca5418446
Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5205
diff
changeset
|
846 flag := t.Day() == x.Day() |
defca5418446
Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5205
diff
changeset
|
847 if flag { |
defca5418446
Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5205
diff
changeset
|
848 t = x |
defca5418446
Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5205
diff
changeset
|
849 } |
defca5418446
Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5205
diff
changeset
|
850 return flag |
defca5418446
Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5205
diff
changeset
|
851 } |
defca5418446
Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5205
diff
changeset
|
852 } |
defca5418446
Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5205
diff
changeset
|
853 |
defca5418446
Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5205
diff
changeset
|
854 func otherQuarter(t time.Time) func(time.Time) bool { |
defca5418446
Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5205
diff
changeset
|
855 return func(x time.Time) bool { |
5209
32eb35699bd3
Fixed bug in quarter detection.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5208
diff
changeset
|
856 flag := (t.Month()-1)/3 != (x.Month()-1)/3 |
5208
defca5418446
Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5205
diff
changeset
|
857 if flag { |
defca5418446
Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5205
diff
changeset
|
858 t = x |
defca5418446
Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5205
diff
changeset
|
859 } |
defca5418446
Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5205
diff
changeset
|
860 return flag |
defca5418446
Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5205
diff
changeset
|
861 } |
defca5418446
Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5205
diff
changeset
|
862 } |
defca5418446
Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5205
diff
changeset
|
863 |
defca5418446
Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5205
diff
changeset
|
864 func otherYear(t time.Time) func(time.Time) bool { |
defca5418446
Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5205
diff
changeset
|
865 return func(x time.Time) bool { |
defca5418446
Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5205
diff
changeset
|
866 flag := t.Year() != x.Year() |
defca5418446
Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5205
diff
changeset
|
867 if flag { |
defca5418446
Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5205
diff
changeset
|
868 t = x |
defca5418446
Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5205
diff
changeset
|
869 } |
defca5418446
Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5205
diff
changeset
|
870 return flag |
defca5418446
Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5205
diff
changeset
|
871 } |
defca5418446
Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5205
diff
changeset
|
872 } |
5220
142ac550bd9a
Unify headers for CSV export.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5218
diff
changeset
|
873 |
142ac550bd9a
Unify headers for CSV export.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5218
diff
changeset
|
874 func makeHeader(flag bool, prec int, breaks []float64, unit rune) []string { |
142ac550bd9a
Unify headers for CSV export.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5218
diff
changeset
|
875 record := make([]string, 1+2+len(breaks)+1) |
142ac550bd9a
Unify headers for CSV export.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5218
diff
changeset
|
876 record[0] = "# time" |
142ac550bd9a
Unify headers for CSV export.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5218
diff
changeset
|
877 record[1] = fmt.Sprintf("# < LDC [%c]", unit) |
142ac550bd9a
Unify headers for CSV export.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5218
diff
changeset
|
878 record[2] = fmt.Sprintf("# >= LDC [%c]", unit) |
142ac550bd9a
Unify headers for CSV export.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5218
diff
changeset
|
879 for i, v := range breaks { |
142ac550bd9a
Unify headers for CSV export.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5218
diff
changeset
|
880 if flag { |
142ac550bd9a
Unify headers for CSV export.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5218
diff
changeset
|
881 if i == 0 { |
142ac550bd9a
Unify headers for CSV export.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5218
diff
changeset
|
882 record[3] = fmt.Sprintf("# < break_1 [%c]", unit) |
142ac550bd9a
Unify headers for CSV export.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5218
diff
changeset
|
883 } |
142ac550bd9a
Unify headers for CSV export.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5218
diff
changeset
|
884 record[i+4] = fmt.Sprintf("# >= break_%d [%c]", i+1, unit) |
142ac550bd9a
Unify headers for CSV export.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5218
diff
changeset
|
885 } else { |
142ac550bd9a
Unify headers for CSV export.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5218
diff
changeset
|
886 if i == 0 { |
142ac550bd9a
Unify headers for CSV export.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5218
diff
changeset
|
887 record[3] = fmt.Sprintf("# < %.*f [%c]", prec, v, unit) |
142ac550bd9a
Unify headers for CSV export.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5218
diff
changeset
|
888 } |
142ac550bd9a
Unify headers for CSV export.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5218
diff
changeset
|
889 record[i+4] = fmt.Sprintf("# >= %.*f [%c]", prec, v, unit) |
142ac550bd9a
Unify headers for CSV export.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5218
diff
changeset
|
890 } |
142ac550bd9a
Unify headers for CSV export.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5218
diff
changeset
|
891 } |
142ac550bd9a
Unify headers for CSV export.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5218
diff
changeset
|
892 return record |
142ac550bd9a
Unify headers for CSV export.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
5218
diff
changeset
|
893 } |