# HG changeset patch # User gernotbelger # Date 1527238163 -7200 # Node ID 7e60457f9d2693d7e99fb97a969ee0e48b8d77f3 # Parent fb976ea0146363efbd685154403d9479b364ab3b Changed order of SINFO results and fixed data in datacage. Some minor name changes. diff -r fb976ea01463 -r 7e60457f9d26 artifacts/doc/conf/meta-data.xml --- a/artifacts/doc/conf/meta-data.xml Fri May 25 10:47:38 2018 +0200 +++ b/artifacts/doc/conf/meta-data.xml Fri May 25 10:49:23 2018 +0200 @@ -1617,58 +1617,56 @@ + + + + + + - + - + - - - - + + SINFO + + + + + WINFO/DIFF/FIX + MINFO - - SINFO - - - - - - - - - - - @@ -3253,14 +3251,10 @@ - + @@ -3283,10 +3277,9 @@ - + @@ -3309,10 +3302,13 @@ - + @@ -3334,6 +3330,7 @@ + + - + @@ -3403,77 +3408,6 @@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - @@ -3481,25 +3415,25 @@ - + - + SELECT sc.tkh_id AS tkh_id, sc.id AS tkh_col_id, MIN(sc.name) AS tkh_col_name, - MIN(s.filename) AS tkh_name, MIN(v.station) AS km_min, MAX(v.station) AS km_max, - MIN(s.filename) || '<br />' - || '[km ' || MIN(v.station) || ' - ' || MAX(v.station) || ']<br />' - || MIN(s.sounding_info) || '<br />' - || MIN(s.evaluation_by) AS info + MIN(s.filename) AS tkh_name, MIN(v.station) AS km_min, MAX(v.station) AS km_max, + MIN(s.filename) || '<br />' + || '[km ' || MIN(v.station) || ' - ' || MAX(v.station) || ']<br />' + || MIN(s.sounding_info) || '<br />' + || MIN(s.evaluation_by) AS info FROM tkh_column sc INNER JOIN tkh s ON sc.tkh_id=s.id - INNER JOIN tkh_values v ON sc.id=v.tkh_column_id + INNER JOIN tkh_values v ON sc.id=v.tkh_column_id WHERE (s.river_id=${river_id}) AND (lower(s.groupname)=${tkh_groupname}) GROUP BY sc.tkh_id, sc.id @@ -3524,23 +3458,23 @@ - + - + SELECT s.id AS depthevol_id, MIN(s.filename) AS depthevol_name, MIN(v.station) AS km_min, MAX(v.station) AS km_max, - MIN(s.filename) || '<br />' - || '[km ' || MIN(v.station) || ' - ' || MAX(v.station) || ']<br />' - || MIN(s.start_year) || ' - ' || MIN(s.reference_year) || '<br />' - || MIN(s.old_sounding) || ' - ' || MIN(s.curr_sounding) || '<br />' - || MIN(s.old_glw) || ' - ' || MIN(s.curr_glw) AS info + MIN(s.filename) || '<br />' + || '[km ' || MIN(v.station) || ' - ' || MAX(v.station) || ']<br />' + || MIN(s.start_year) || ' - ' || MIN(s.reference_year) || '<br />' + || MIN(s.old_sounding) || ' - ' || MIN(s.curr_sounding) || '<br />' + || MIN(s.old_glw) || ' - ' || MIN(s.curr_glw) AS info FROM depth_evolution s INNER JOIN depth_evolution_values v ON s.id=v.depth_evolution_id WHERE (s.river_id=${river_id}) AND (lower(s.groupname)=${depthevol_groupname}) @@ -3548,7 +3482,7 @@ ORDER BY s.id - + @@ -3557,29 +3491,29 @@ - + SELECT sc.flow_depth_id AS flowdepth_id, sc.id AS flowdepth_col_id, MIN(sc.name) AS flowdepth_col_name, - MIN(s.filename) AS flowdepth_name, MIN(v.station) AS km_min, MAX(v.station) AS km_max, - MIN(s.filename) || '<br />' - || '[km ' || MIN(v.station) || ' - ' || MAX(v.station) || ']<br />' - || MIN(s.sounding_info) || '<br />' - || MIN(s.evaluation_by) AS info + MIN(s.filename) AS flowdepth_name, MIN(v.station) AS km_min, MAX(v.station) AS km_max, + MIN(s.filename) || '<br />' + || '[km ' || MIN(v.station) || ' - ' || MAX(v.station) || ']<br />' + || MIN(s.sounding_info) || '<br />' + || MIN(s.evaluation_by) AS info FROM flow_depth_column sc INNER JOIN flow_depth s ON sc.flow_depth_id=s.id - INNER JOIN flow_depth_values v ON sc.id=v.flow_depth_column_id + INNER JOIN flow_depth_values v ON sc.id=v.flow_depth_column_id WHERE (s.river_id=${river_id}) GROUP BY sc.flow_depth_id, sc.id ORDER BY sc.id - + - + diff -r fb976ea01463 -r 7e60457f9d26 gwt-client/src/main/java/org/dive4elements/river/client/client/FLYSConstants.java --- a/gwt-client/src/main/java/org/dive4elements/river/client/client/FLYSConstants.java Fri May 25 10:47:38 2018 +0200 +++ b/gwt-client/src/main/java/org/dive4elements/river/client/client/FLYSConstants.java Fri May 25 10:49:23 2018 +0200 @@ -1501,6 +1501,8 @@ String predefined_depthevol_etappe(); + String sinfo_predefined_flowdepths(); + String sinfo_predefined_flowdepth(); String uinfo(); diff -r fb976ea01463 -r 7e60457f9d26 gwt-client/src/main/java/org/dive4elements/river/client/client/FLYSConstants.properties --- a/gwt-client/src/main/java/org/dive4elements/river/client/client/FLYSConstants.properties Fri May 25 10:47:38 2018 +0200 +++ b/gwt-client/src/main/java/org/dive4elements/river/client/client/FLYSConstants.properties Fri May 25 10:49:23 2018 +0200 @@ -802,7 +802,8 @@ predefined_depthevol_aktuell = Bezug aktueller GlW predefined_depthevol_etappe = GlW-Etappen -sinfo_predefined_flowdepth = Modellierte Flie\u00dftiefen +sinfo_predefined_flowdepths = Modellierte Datens\u00e4tze +sinfo_predefined_flowdepth = Flie\u00dftiefen uinfo = U-INFO uinfo_inundation_duration_export = \u00dcberflutungsdauern Export diff -r fb976ea01463 -r 7e60457f9d26 gwt-client/src/main/java/org/dive4elements/river/client/client/FLYSConstants_de.properties --- a/gwt-client/src/main/java/org/dive4elements/river/client/client/FLYSConstants_de.properties Fri May 25 10:47:38 2018 +0200 +++ b/gwt-client/src/main/java/org/dive4elements/river/client/client/FLYSConstants_de.properties Fri May 25 10:49:23 2018 +0200 @@ -802,7 +802,8 @@ predefined_depthevol_aktuell = Bezug aktueller GlW predefined_depthevol_etappe = GlW-Etappen -sinfo_predefined_flowdepth = Modellierte Flie\u00dftiefen +sinfo_predefined_flowdepths = Modellierte Datens\u00e4tze +sinfo_predefined_flowdepth = Flie\u00dftiefen uinfo = U-INFO uinfo_inundation_duration_export = \u00dcberflutungsdauern Export