# HG changeset patch # User Tom Gottfried # Date 1412701446 -7200 # Node ID 1e1b08d033f485cdc15a368d4dc65c80caf1afdd # Parent 5b3a2908a346c9b0526c9a3e31e9aedd96da0bc4 Removed some code duplication and moved macros to more appropriate places in file. diff -r 5b3a2908a346 -r 1e1b08d033f4 artifacts/doc/conf/meta-data.xml --- a/artifacts/doc/conf/meta-data.xml Tue Oct 07 19:02:50 2014 +0200 +++ b/artifacts/doc/conf/meta-data.xml Tue Oct 07 19:04:06 2014 +0200 @@ -444,43 +444,6 @@ - - - - - SELECT g.id AS gauge_id, - g.name AS gauge_name, - dt.id AS dt_id, - t.start_time AS start_time, - t.stop_time AS stop_time, - dt.bfg_id AS bfg_id - FROM gauges g - JOIN discharge_tables dt ON g.id = dt.gauge_id - LEFT JOIN time_intervals t ON dt.time_interval_id = t.id - WHERE g.river_id = ${river_id} - AND dt.kind <> 0 - AND ((g.station = ${fromkm} AND g.station = ${tokm}) - OR g.official_number = ${refgauge}) - ORDER BY start_time - - - - - - - - - - - - - - - @@ -1045,10 +1008,6 @@ - - - - @@ -1058,6 +1017,61 @@ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + SELECT g.name AS gauge_name, + dt.id AS dt_id, + t.start_time AS start_time, + t.stop_time AS stop_time, + dt.bfg_id AS bfg_id, + dt.kind AS kind + FROM gauges g + JOIN discharge_tables dt ON g.id = dt.gauge_id + LEFT JOIN time_intervals t ON dt.time_interval_id = t.id + WHERE g.river_id = ${river_id} + AND ((g.station = ${fromkm} AND g.station = ${tokm}) + OR g.official_number = ${refgauge}) + ORDER BY start_time + + + @@ -1721,6 +1735,10 @@ + + + + @@ -1757,32 +1775,6 @@ - - - - - SELECT g.id AS gauge_id, - g.name AS gauge_name, - t.start_time AS start_time, - t.stop_time AS stop_time - FROM gauges g - JOIN discharge_tables dt ON g.id = dt.gauge_id - LEFT JOIN time_intervals t ON dt.time_interval_id = t.id - WHERE g.river_id = ${river_id} - AND dt.kind = 0 - AND ((g.station = ${fromkm} AND g.station = ${tokm}) - OR g.official_number = ${refgauge}) - - - - - - - - -